Posts

Showing posts from March, 2019

How to create dependent lov in OAF

How to create dependent lov in OAF

How to create external lov in OAF

How to create external lov in OAF

How to create Check Box in OAF

How to create Check Box in OAF

How to create LOV in OAF

How to create LOV in OAF

How to create PopList in OAF

How to create PopList in OAF

How to create result based search Page in oaf

How to create result based search Page in oaf

How to create auto customization criteria search Page in oaf

How to create auto customization criteria search Page in oaf

Difference between auto customization criteria and result based search in OAF

Difference between auto customization criteria and result based search in OAF

How to Make Simple Hello Page In OAF

How to Make Simple Hello Page In OAF

How to Install OAF

How to Install OAF

How to Make Connection in OAF

How to Make Connection in OAF

How to use standard Date Format as a Parameter in rdf report

How to use standard Date Format as a Parameter in rdf report

How to use DATE format in PLSQL Reports

How to use DATE format in PLSQL Reports

How to create XML reports by using PLSQL Procedure with Examples

How to create XML reports by using PLSQL Procedure with Examples --==================================================================== CREATE OR REPLACE PROCEDURE APPS.XXSD_RDF_TO_XML_PROC ( RETCODE OUT VARCHAR2, ERRBUF OUT VARCHAR2, P_VENDOR_TYPE IN VARCHAR2  ) AS --*==================================================+ --| PACKAGE XXSD_RDF_TO_XML_PROC --+--------------------------------------------------------------------------+ --| DESCRIPTION This package is used to designed for xml  ( PROCEDURE base EXCEL REPORT) --+--------------------------------------------------------------------------+ --| Author              | Date              | DESCRIPTION --| MANOJ KUMAR | 31-JAN-2016 | FIRST AND FINAL Version --+==================================================+ CURSOR C1 IS SELECT SEGMENT1 VENDOR_CODE, VENDOR_NAME, VENDOR_TYPE_LOOKUP_CODE VENDOR_TYPE,START_DATE_ACTIVE  FROM AP_SUPPLIERS WHERE   VENDOR_TYPE_LOOKUP_CODE = P_VENDOR_TYPE;    BEGIN         fnd_fil

How to create oracle text reports by using PLSQL Procedure with Examples

How to create oracle text reports by using PLSQL Procedure with Examples --============================================================= CREATE OR REPLACE PROCEDURE APPS.XXSD_RDF_TO_TEXT_PROC ( RETCODE OUT VARCHAR2, ERRBUF OUT VARCHAR2, P_VENDOR_TYPE IN VARCHAR2  ) AS --*==================================================+ --| PACKAGE XXSD_RDF_TO_TEXT_PROC --+--------------------------------------------------------------------------+ --| DESCRIPTION This package is used to designed for testing TEXT Report --+--------------------------------------------------------------------------+ --| Author              | Date              | DESCRIPTION --| MANOJ KUMAR | 31-JAN-2016 | FIRST AND FINAL Version --+==================================================+ CURSOR C1 IS SELECT SEGMENT1 VENDOR_CODE, VENDOR_NAME, VENDOR_TYPE_LOOKUP_CODE VENDOR_TYPE,START_DATE_ACTIVE  FROM AP_SUPPLIERS WHERE   VENDOR_TYPE_LOOKUP_CODE = P_VENDOR_TYPE; BEGIN fnd_file.put_line (fnd_file.ou

How to create oracle text reports with Examples

Image
How to create oracle text reports with Examples

How to Assign a Concurrent Program to a Responsibility

Image
How to Assign a Concurrent Program to a Responsibility