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 DUAL

Line 457: select EDR_PSIG_DOCUMENTS_S.nextval into l_document_id from dual;

453: END;
454: end if;
455:
456: /* Generate a new Document ID */
457: select EDR_PSIG_DOCUMENTS_S.nextval into l_document_id from dual;
458:
459: /* Attachments Bug Fix. Added if statement */
460: if P_WF_NID is not NULL then
461: /* capture Attachemnts if Exists */

Line 631: select EDR_PSIG_DOCUMENTS_S.nextval into l_document_id from dual;

627: RAISE TIMEZONE_ERROR;
628: end if;
629:
630: --Generate a new Document ID
631: select EDR_PSIG_DOCUMENTS_S.nextval into l_document_id from dual;
632:
633: --Bug 4672801: start
634: EDR_UTILITIES.getWhoColumns
635: ( creation_date => l_creation_date ,

Line 1234: select EDR_PSIG_DETAILS_S.nextval into l_signature_id from dual;

1230: END IF;
1231:
1232: --Bug 3330240 : end
1233: /* Get New Signature Id */
1234: select EDR_PSIG_DETAILS_S.nextval into l_signature_id from dual;
1235: /* Insert signature Details */
1236:
1237: --Bug 3330240 : Start
1238: --Inert the adhoc_status, signature_sequence also

Line 1641: select EDR_PSIG_PARAMS_S.nextval into l_parameter_id from dual;

1637:
1638: EXCEPTION
1639: WHEN NO_DATA_FOUND then
1640: /* Insert a ROW */
1641: select EDR_PSIG_PARAMS_S.nextval into l_parameter_id from dual;
1642: EDR_PSIG_DOC_PARAMS_PKG.INSERT_ROW(
1643: X_ROWID => L_ROWID,
1644: X_PARAMETER_ID => L_PARAMETER_ID,
1645: X_DOCUMENT_ID => P_DOCUMENT_ID,

Line 1755: select EDR_PSIG_PARAMS_S.nextval into l_parameter_id from dual;

1751: OPEN C1;
1752: FETCH C1 into l_parameter_id;
1753: IF C1%NOTFOUND THEN
1754: /* Insert a ROW */
1755: select EDR_PSIG_PARAMS_S.nextval into l_parameter_id from dual;
1756: EDR_PSIG_SIGN_PARAMS_PKG.INSERT_ROW(
1757: X_ROWID => L_ROWID,
1758: X_PARAMETER_ID => L_PARAMETER_ID,
1759: X_SIGNATURE_ID => P_SIGNATURE_ID,

Line 2588: from dual;

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)
2591: into l_result
2592: from dual;

Line 2592: from dual;

2588: from dual;
2589:
2590: SELECT xmlelement("ERECORD_XML",l_result)
2591: into l_result
2592: from dual;
2593:
2594: return l_result;
2595:
2596: END GET_ERECORD_XML;

Line 2642: select extract(l_result,'/ERECORD_SIGNATURE_DETAILS/*') into l_temp from dual;

2638: where
2639:
2640: psig.document_id = p_document_id;
2641:
2642: select extract(l_result,'/ERECORD_SIGNATURE_DETAILS/*') into l_temp from dual;
2643:
2644: if l_temp is null then
2645: l_result := null;
2646: end if;

Line 2740: select extract(l_result,'/PRINT_HISTORY_DETAILS/*') into l_temp from dual;

2736: where print.document_id = p_document_id;
2737:
2738:
2739: --Verify if the print history details actually exist.
2740: select extract(l_result,'/PRINT_HISTORY_DETAILS/*') into l_temp from dual;
2741:
2742: --If the print history details do not exist, then set the result variable to null.
2743: if l_temp is null then
2744: l_result := null;

Line 2778: select xmlconcat(l_result,l_current_xml) into l_result from dual;

2774: --Obtain the e-record header details.
2775: l_current_xml := get_erecord_header_xml(p_document_id => l_parent_erecord_id);
2776:
2777: --Copy the same to the result variable.
2778: select xmlconcat(l_result,l_current_xml) into l_result from dual;
2779:
2780: --Fetch the psig_xml if required.
2781: if(FND_API.TO_BOOLEAN(p_get_erecord_xml)) then
2782:

Line 2786: select xmlconcat(l_result,l_current_xml) into l_result from dual;

2782:
2783: l_current_xml := GET_ERECORD_XML(p_document_id => l_parent_erecord_id);
2784:
2785: --Append the psig_xml into the result variable.
2786: select xmlconcat(l_result,l_current_xml) into l_result from dual;
2787:
2788: end if;
2789:
2790: --Fetch the signature details if required.

Line 2796: select xmlconcat(l_result,l_current_xml) into l_result from dual;

2792:
2793: l_current_xml := GET_PSIG_DETAIL_XML(p_document_id => l_parent_erecord_id);
2794:
2795: --Append the signature details
2796: select xmlconcat(l_result,l_current_xml) into l_result from dual;
2797: end if;
2798:
2799: if(FND_API.TO_BOOLEAN(p_get_ackn_details)) then
2800:

Line 2804: select xmlconcat(l_result,l_current_xml) into l_result from dual;

2800:
2801: l_current_xml := get_ackn_detail_xml(p_document_id => l_parent_erecord_id);
2802:
2803: --Append the acknowledgement details.
2804: select xmlconcat(l_result,l_current_xml) into l_result from dual;
2805:
2806: end if;
2807:
2808: if(FND_API.TO_BOOLEAN(p_get_print_details)) then

Line 2810: select xmlconcat(l_result,l_current_xml) into l_result from dual;

2806: end if;
2807:
2808: if(FND_API.TO_BOOLEAN(p_get_print_details)) then
2809: l_current_xml := get_print_history_detail_xml(p_document_id => l_parent_erecord_id);
2810: select xmlconcat(l_result,l_current_xml) into l_result from dual;
2811: end if;
2812:
2813: select xmlelement("ERECORD",l_result) into l_result from dual;
2814:

Line 2813: select xmlelement("ERECORD",l_result) into l_result from dual;

2809: l_current_xml := get_print_history_detail_xml(p_document_id => l_parent_erecord_id);
2810: select xmlconcat(l_result,l_current_xml) into l_result from dual;
2811: end if;
2812:
2813: select xmlelement("ERECORD",l_result) into l_result from dual;
2814:
2815: select xmlelement("PARENT_ERECORD_DETAILS",l_result) into l_result from dual;
2816:
2817: return l_result;

Line 2815: select xmlelement("PARENT_ERECORD_DETAILS",l_result) into l_result from dual;

2811: end if;
2812:
2813: select xmlelement("ERECORD",l_result) into l_result from dual;
2814:
2815: select xmlelement("PARENT_ERECORD_DETAILS",l_result) into l_result from dual;
2816:
2817: return l_result;
2818:
2819: EXCEPTION

Line 2877: from dual;

2873: l_result
2874: )
2875: )
2876: into l_this_Node
2877: from dual;
2878: else
2879: -- Next node is a sibling of this Node.
2880: l_result := process_Result_Set(x_current_Level, x_current_Node,p_level_tbl,
2881: p_result_xml_tbl);

Line 2884: select xmlconcat(l_this_Node,l_result) into l_this_Node from dual;

2880: l_result := process_Result_Set(x_current_Level, x_current_Node,p_level_tbl,
2881: p_result_xml_tbl);
2882:
2883: --Append the child details in to the result variable.
2884: select xmlconcat(l_this_Node,l_result) into l_this_Node from dual;
2885: end if;
2886: end loop;
2887:
2888: return l_this_Node;

Line 2959: select xmlconcat(l_result_xml_tbl(i),l_current_xml) into l_result_xml_tbl(i) from dual;

2955: l_result_xml_tbl(i) := l_current_xml;
2956:
2957: if(FND_API.TO_BOOLEAN(p_get_erecord_xml)) then
2958: l_current_xml := GET_ERECORD_XML(p_document_id => l_child_erecord_ids(i));
2959: select xmlconcat(l_result_xml_tbl(i),l_current_xml) into l_result_xml_tbl(i) from dual;
2960: end if;
2961:
2962: if(FND_API.TO_BOOLEAN(p_get_psig_details)) then
2963: l_current_xml := GET_PSIG_DETAIL_XML(p_document_id => l_child_erecord_ids(i));

Line 2964: select xmlconcat(l_result_xml_tbl(i),l_current_xml) into l_result_xml_tbl(i) from dual;

2960: end if;
2961:
2962: if(FND_API.TO_BOOLEAN(p_get_psig_details)) then
2963: l_current_xml := GET_PSIG_DETAIL_XML(p_document_id => l_child_erecord_ids(i));
2964: select xmlconcat(l_result_xml_tbl(i),l_current_xml) into l_result_xml_tbl(i) from dual;
2965: end if;
2966:
2967: if(FND_API.TO_BOOLEAN(p_get_ackn_details)) then
2968: l_current_xml := get_ackn_detail_xml(p_document_id => l_child_erecord_ids(i));

Line 2969: select xmlconcat(l_result_xml_tbl(i),l_current_xml) into l_result_xml_tbl(i) from dual;

2965: end if;
2966:
2967: if(FND_API.TO_BOOLEAN(p_get_ackn_details)) then
2968: l_current_xml := get_ackn_detail_xml(p_document_id => l_child_erecord_ids(i));
2969: select xmlconcat(l_result_xml_tbl(i),l_current_xml) into l_result_xml_tbl(i) from dual;
2970: end if;
2971:
2972: if(FND_API.TO_BOOLEAN(p_get_print_details)) then
2973: l_current_xml := get_print_history_detail_xml(p_document_id => l_child_erecord_ids(i));

Line 2974: select xmlconcat(l_result_xml_tbl(i),l_current_xml) into l_result_xml_tbl(i) from dual;

2970: end if;
2971:
2972: if(FND_API.TO_BOOLEAN(p_get_print_details)) then
2973: l_current_xml := get_print_history_detail_xml(p_document_id => l_child_erecord_ids(i));
2974: select xmlconcat(l_result_xml_tbl(i),l_current_xml) into l_result_xml_tbl(i) from dual;
2975: end if;
2976:
2977: select xmlelement("ERECORD",l_result_xml_tbl(i)) into l_result_xml_tbl(i) from dual;
2978:

Line 2977: select xmlelement("ERECORD",l_result_xml_tbl(i)) into l_result_xml_tbl(i) from dual;

2973: l_current_xml := get_print_history_detail_xml(p_document_id => l_child_erecord_ids(i));
2974: select xmlconcat(l_result_xml_tbl(i),l_current_xml) into l_result_xml_tbl(i) from dual;
2975: end if;
2976:
2977: select xmlelement("ERECORD",l_result_xml_tbl(i)) into l_result_xml_tbl(i) from dual;
2978:
2979: end loop;
2980:
2981: g_child_erecord_count := 1;

Line 2990: select xmlelement("CHILD_ERECORD_DETAILS",l_result) into l_result from dual;

2986: --Proceed the table of child e-record IDs.
2987: --Re-arrange them to form the correct hierarchy of child e-records.
2988: l_result := process_result_set(l_current_level,l_current_node,l_level_tbl,l_result_xml_tbl);
2989:
2990: select xmlelement("CHILD_ERECORD_DETAILS",l_result) into l_result from dual;
2991:
2992: return l_result;
2993:
2994: end get_child_erecord_detail_xml;

Line 3024: select xmlconcat(l_current_result,l_current_xml) into l_current_result from dual;

3020:
3021: --Fetch the e-record header details in XML format.
3022: l_current_xml := get_erecord_header_xml(p_document_id => p_erecord_ids(i));
3023:
3024: select xmlconcat(l_current_result,l_current_xml) into l_current_result from dual;
3025:
3026: --If the psig_xml is required, fetch the same in XML format.
3027: if(FND_API.TO_BOOLEAN(p_get_erecord_xml)) then
3028: l_current_xml := GET_ERECORD_XML(p_document_id => p_erecord_ids(i));

Line 3029: select xmlconcat(l_current_result,l_current_xml) into l_current_result from dual;

3025:
3026: --If the psig_xml is required, fetch the same in XML format.
3027: if(FND_API.TO_BOOLEAN(p_get_erecord_xml)) then
3028: l_current_xml := GET_ERECORD_XML(p_document_id => p_erecord_ids(i));
3029: select xmlconcat(l_current_result,l_current_xml) into l_current_result from dual;
3030: end if;
3031:
3032: --If the signature details are required, fetch the same in XML format.
3033: if(FND_API.TO_BOOLEAN(p_get_psig_details)) then

Line 3035: select xmlconcat(l_current_result,l_current_xml) into l_current_result from dual;

3031:
3032: --If the signature details are required, fetch the same in XML format.
3033: if(FND_API.TO_BOOLEAN(p_get_psig_details)) then
3034: l_current_xml := GET_PSIG_DETAIL_XML(p_document_id => p_erecord_ids(i));
3035: select xmlconcat(l_current_result,l_current_xml) into l_current_result from dual;
3036: end if;
3037:
3038: --If the acknowledgement details are required, fetch the same in XML format.
3039: if(FND_API.TO_BOOLEAN(p_get_ackn_details)) then

Line 3041: select xmlconcat(l_current_result,l_current_xml) into l_current_result from dual;

3037:
3038: --If the acknowledgement details are required, fetch the same in XML format.
3039: if(FND_API.TO_BOOLEAN(p_get_ackn_details)) then
3040: l_current_xml := get_ackn_detail_xml(p_document_id => p_erecord_ids(i));
3041: select xmlconcat(l_current_result,l_current_xml) into l_current_result from dual;
3042: end if;
3043:
3044: --If the print history details are required, fetch the same in XML format.
3045: if(FND_API.TO_BOOLEAN(p_get_print_details)) then

Line 3047: select xmlconcat(l_current_result,l_current_xml) into l_current_result from dual;

3043:
3044: --If the print history details are required, fetch the same in XML format.
3045: if(FND_API.TO_BOOLEAN(p_get_print_details)) then
3046: l_current_xml := get_print_history_detail_xml(p_document_id => p_erecord_ids(i));
3047: select xmlconcat(l_current_result,l_current_xml) into l_current_result from dual;
3048: end if;
3049:
3050: --If the related e-record details are required, fetch the same in XML format.
3051: if(FND_API.TO_BOOLEAN(p_get_related_erec_details)) then

Line 3058: select xmlconcat(l_current_result,l_current_xml) into l_current_result from dual;

3054: P_GET_PSIG_DETAILS => P_GET_PSIG_DETAILS,
3055: P_GET_ACKN_DETAILS => P_GET_ACKN_DETAILS,
3056: P_GET_PRINT_DETAILS => P_GET_PRINT_DETAILS
3057: );
3058: select xmlconcat(l_current_result,l_current_xml) into l_current_result from dual;
3059:
3060:
3061: l_current_xml := get_child_erecord_detail_xml(p_document_id => p_erecord_ids(i),
3062: P_GET_ERECORD_XML => P_GET_ERECORD_XML,

Line 3067: select xmlconcat(l_current_result,l_current_xml) into l_current_result from dual;

3063: P_GET_PSIG_DETAILS => P_GET_PSIG_DETAILS,
3064: P_GET_ACKN_DETAILS => P_GET_ACKN_DETAILS,
3065: P_GET_PRINT_DETAILS => P_GET_PRINT_DETAILS
3066: );
3067: select xmlconcat(l_current_result,l_current_xml) into l_current_result from dual;
3068: end if;
3069:
3070: select xmlelement("ERECORD",l_current_result) into l_current_result from dual;
3071:

Line 3070: select xmlelement("ERECORD",l_current_result) into l_current_result from dual;

3066: );
3067: select xmlconcat(l_current_result,l_current_xml) into l_current_result from dual;
3068: end if;
3069:
3070: select xmlelement("ERECORD",l_current_result) into l_current_result from dual;
3071:
3072: select xmlconcat(l_result,l_current_result) into l_result from dual;
3073:
3074: end loop;

Line 3072: select xmlconcat(l_result,l_current_result) into l_result from dual;

3068: end if;
3069:
3070: select xmlelement("ERECORD",l_current_result) into l_current_result from dual;
3071:
3072: select xmlconcat(l_result,l_current_result) into l_result from dual;
3073:
3074: end loop;
3075:
3076: select xmlelement("ERECORDS",l_result) into l_result from dual;

Line 3076: select xmlelement("ERECORDS",l_result) into l_result from dual;

3072: select xmlconcat(l_result,l_current_result) into l_result from dual;
3073:
3074: end loop;
3075:
3076: select xmlelement("ERECORDS",l_result) into l_result from dual;
3077:
3078: --Convert the final result value into a CLOB.
3079: X_FINAL_XML := l_result.getClobVal;
3080:

Line 3089: --The individual e-record details such as acknowledgement details, signature details etc... are fetched based

3085: END GET_XML_FOR_ERECORDS;
3086:
3087:
3088: --This PROCEDURE will fetch the event data in XML format.
3089: --The individual e-record details such as acknowledgement details, signature details etc... are fetched based
3090: --the value of the individual flags set.
3091: PROCEDURE GET_EVENT_XML(P_EVENT_NAME IN VARCHAR2,
3092: P_EVENT_KEY IN VARCHAR2,
3093: P_ERECORD_ID IN NUMBER,

Line 3090: --the value of the individual flags set.

3086:
3087:
3088: --This PROCEDURE will fetch the event data in XML format.
3089: --The individual e-record details such as acknowledgement details, signature details etc... are fetched based
3090: --the value of the individual flags set.
3091: PROCEDURE GET_EVENT_XML(P_EVENT_NAME IN VARCHAR2,
3092: P_EVENT_KEY IN VARCHAR2,
3093: P_ERECORD_ID IN NUMBER,
3094: P_GET_ERECORD_XML IN VARCHAR2,