eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.EDR_PSIG dependencies on XMLTYPE

Line 2503: RETURN XMLType

2499:
2500: --This function would fetch the e-record header details in XML format for the specified e-record ID.
2501: FUNCTION GET_ERECORD_HEADER_XML(P_DOCUMENT_ID IN NUMBER)
2502:
2503: RETURN XMLType
2504:
2505: IS
2506:
2507: --This variable would hold the resultant XML for e-record header details obtained from the query.

Line 2508: l_result XMLType;

2504:
2505: IS
2506:
2507: --This variable would hold the resultant XML for e-record header details obtained from the query.
2508: l_result XMLType;
2509:
2510: begin
2511:
2512: --This query would fetch the e-record header details in XML format.

Line 2560: return XMLType

2556:
2557: --This function would fetch the PSIG_XML identified by the specified e-record ID.
2558: FUNCTION GET_ERECORD_XML (P_DOCUMENT_ID IN NUMBER)
2559:
2560: return XMLType
2561:
2562: is
2563:
2564: --This holds the query context.

Line 2568: l_result XMLType;

2564: --This holds the query context.
2565: qryCtx DBMS_XMLGEN.ctxHandle;
2566:
2567: --This would hold the resultant CLOB.
2568: l_result XMLType;
2569:
2570: BEGIN
2571:
2572: --Create the query context based on the SQL QUERY.

Line 2573: qryCtx := dbms_xmlgen.newContext('select xmltype(psig_xml) as ERECORD_XML from edr_psig_documents where document_id = ' || p_document_id);

2569:
2570: BEGIN
2571:
2572: --Create the query context based on the SQL QUERY.
2573: qryCtx := dbms_xmlgen.newContext('select xmltype(psig_xml) as ERECORD_XML from edr_psig_documents where document_id = ' || p_document_id);
2574:
2575: --We want the "" tag to be null
2576: dbms_xmlgen.setRowTag(qryCtx,null);
2577:

Line 2586: select extract(dbms_xmlgen.getXMLType(qryCtx),'/ERECORD_XML/*')

2582: --This will ensure that the '<' and '> symbols in the base psig_xml are retained.
2583: dbms_xmlgen.setConvertSpecialChars(qryCtx,false);
2584:
2585: --This would give us the required XML without any standard comments.
2586: select extract(dbms_xmlgen.getXMLType(qryCtx),'/ERECORD_XML/*')
2587: into l_result
2588: from dual;
2589:
2590: SELECT xmlelement("ERECORD_XML",l_result)

Line 2602: return XMLType

2598:
2599: --This function would fetch the signature details for the specified e-record ID in XML format.
2600: FUNCTION GET_PSIG_DETAIL_XML(P_DOCUMENT_ID IN NUMBER)
2601:
2602: return XMLType
2603:
2604: is
2605:
2606: l_result XMLType;

Line 2606: l_result XMLType;

2602: return XMLType
2603:
2604: is
2605:
2606: l_result XMLType;
2607:
2608: l_temp XMLType;
2609:
2610: begin

Line 2608: l_temp XMLType;

2604: is
2605:
2606: l_result XMLType;
2607:
2608: l_temp XMLType;
2609:
2610: begin
2611:
2612: --This query would fetch the required XML.

Line 2656: return XMLType

2652:
2653: --This function would fetch the acknowledgement details for the specified in XML format.
2654: FUNCTION GET_ACKN_DETAIL_XML(P_DOCUMENT_ID IN NUMBER)
2655:
2656: return XMLType
2657:
2658: is
2659:
2660: l_result XMLType;

Line 2660: l_result XMLType;

2656: return XMLType
2657:
2658: is
2659:
2660: l_result XMLType;
2661:
2662: begin
2663:
2664: --This query would fetch the required XML.

Line 2696: return XMLType

2692:
2693: --This function would fetch the print history details for the specified e-record ID in XML format.
2694: FUNCTION GET_PRINT_HISTORY_DETAIL_XML(P_DOCUMENT_ID IN NUMBER)
2695:
2696: return XMLType
2697:
2698: is
2699:
2700: l_result XMLType;

Line 2700: l_result XMLType;

2696: return XMLType
2697:
2698: is
2699:
2700: l_result XMLType;
2701:
2702: l_temp XMLType;
2703:
2704: begin

Line 2702: l_temp XMLType;

2698: is
2699:
2700: l_result XMLType;
2701:
2702: l_temp XMLType;
2703:
2704: begin
2705:
2706:

Line 2759: RETURN XMLType

2755: P_GET_PSIG_DETAILS IN VARCHAR2,
2756: P_GET_ACKN_DETAILS IN VARCHAR2,
2757: P_GET_PRINT_DETAILS IN VARCHAR2)
2758:
2759: RETURN XMLType
2760:
2761: as
2762:
2763: l_result XMLType;

Line 2763: l_result XMLType;

2759: RETURN XMLType
2760:
2761: as
2762:
2763: l_result XMLType;
2764: l_current_xml XMLType;
2765: l_parent_erecord_id NUMBER;
2766:
2767: begin

Line 2764: l_current_xml XMLType;

2760:
2761: as
2762:
2763: l_result XMLType;
2764: l_current_xml XMLType;
2765: l_parent_erecord_id NUMBER;
2766:
2767: begin
2768:

Line 2828: X_CURRENT_NODE IN OUT NOCOPY XMLTYPE,

2824:
2825:
2826: --This function is called recursively to fetch the entire child e-record hierarchy.
2827: FUNCTION PROCESS_RESULT_SET(X_CURRENT_LEVEL IN OUT NOCOPY NUMBER,
2828: X_CURRENT_NODE IN OUT NOCOPY XMLTYPE,
2829: P_LEVEL_TBL IN NUMBER_TBL,
2830: P_RESULT_XML_TBL IN XMLTYPE_TBL)
2831: return XMLType
2832: is

Line 2830: P_RESULT_XML_TBL IN XMLTYPE_TBL)

2826: --This function is called recursively to fetch the entire child e-record hierarchy.
2827: FUNCTION PROCESS_RESULT_SET(X_CURRENT_LEVEL IN OUT NOCOPY NUMBER,
2828: X_CURRENT_NODE IN OUT NOCOPY XMLTYPE,
2829: P_LEVEL_TBL IN NUMBER_TBL,
2830: P_RESULT_XML_TBL IN XMLTYPE_TBL)
2831: return XMLType
2832: is
2833:
2834: l_this_Level number;

Line 2831: return XMLType

2827: FUNCTION PROCESS_RESULT_SET(X_CURRENT_LEVEL IN OUT NOCOPY NUMBER,
2828: X_CURRENT_NODE IN OUT NOCOPY XMLTYPE,
2829: P_LEVEL_TBL IN NUMBER_TBL,
2830: P_RESULT_XML_TBL IN XMLTYPE_TBL)
2831: return XMLType
2832: is
2833:
2834: l_this_Level number;
2835: l_this_Node xmlType;

Line 2835: l_this_Node xmlType;

2831: return XMLType
2832: is
2833:
2834: l_this_Level number;
2835: l_this_Node xmlType;
2836: l_result xmlType;
2837:
2838: begin
2839:

Line 2836: l_result xmlType;

2832: is
2833:
2834: l_this_Level number;
2835: l_this_Node xmlType;
2836: l_result xmlType;
2837:
2838: begin
2839:
2840: l_this_Level := x_current_Level;

Line 2900: return XMLType

2896: P_GET_ERECORD_XML IN VARCHAR2,
2897: P_GET_PSIG_DETAILS IN VARCHAR2,
2898: P_GET_ACKN_DETAILS IN VARCHAR2,
2899: P_GET_PRINT_DETAILS IN VARCHAR2)
2900: return XMLType
2901:
2902: as
2903:
2904: l_result XMLType;

Line 2904: l_result XMLType;

2900: return XMLType
2901:
2902: as
2903:
2904: l_result XMLType;
2905:
2906: l_current_xml XMLType;
2907:
2908: l_result_xml_tbl XMLType_TBL;

Line 2906: l_current_xml XMLType;

2902: as
2903:
2904: l_result XMLType;
2905:
2906: l_current_xml XMLType;
2907:
2908: l_result_xml_tbl XMLType_TBL;
2909:
2910: l_level_tbl NUMBER_TBL;

Line 2908: l_result_xml_tbl XMLType_TBL;

2904: l_result XMLType;
2905:
2906: l_current_xml XMLType;
2907:
2908: l_result_xml_tbl XMLType_TBL;
2909:
2910: l_level_tbl NUMBER_TBL;
2911:
2912: l_current_level NUMBER;

Line 2913: l_current_node XMLType;

2909:
2910: l_level_tbl NUMBER_TBL;
2911:
2912: l_current_level NUMBER;
2913: l_current_node XMLType;
2914:
2915: l_child_erecord_ids NUMBER_TBL;
2916:
2917: l_count NUMBER;

Line 3009: l_result XMLType;

3005:
3006: IS
3007:
3008: --This variable would hold the result XML.
3009: l_result XMLType;
3010:
3011: --This variable would hold the current XML data being processed.
3012: l_current_xml XMLType;
3013:

Line 3012: l_current_xml XMLType;

3008: --This variable would hold the result XML.
3009: l_result XMLType;
3010:
3011: --This variable would hold the current XML data being processed.
3012: l_current_xml XMLType;
3013:
3014: l_current_result XMLType;
3015:
3016: BEGIN

Line 3014: l_current_result XMLType;

3010:
3011: --This variable would hold the current XML data being processed.
3012: l_current_xml XMLType;
3013:
3014: l_current_result XMLType;
3015:
3016: BEGIN
3017:
3018: for i in 1..P_ERECORD_IDS.COUNT loop