APPS.EDR_PSIG dependencies on XMLAGG

Line 2530: (select xmlagg(xmlelement("DOC_PARAMS",

2526: evid.created_by as CREATED_BY,
2527: evid.last_update_date as LAST_UPDATE_DATE,
2528: evid.last_updated_by as LAST_UPDATED_BY,
2529: evid.last_update_login as LAST_UPDATE_LOGIN,
2530: (select xmlagg(xmlelement("DOC_PARAMS",
2531: xmlforest(param1.name as PARAM_NAME,
2532: param1.value as PARAM_VALUE)
2533: ))
2534: from edr_psig_doc_params_vl param1

Line 2614: xmlagg(xmlelement("SIGNER_DETAIL",

2610: begin
2611:
2612: --This query would fetch the required XML.
2613: select xmlelement("ERECORD_SIGNATURE_DETAILS",
2614: xmlagg(xmlelement("SIGNER_DETAIL",
2615: xmlforest(psig.signature_sequence as SIGNATURE_SEQUENCE,
2616: psig.user_name as SIGNER_USER_NAME,
2617: psig.user_display_name as SIGNER_DISPLAY_NAME,
2618: psig.user_response as SIGNER_RESPONSE,

Line 2621: (select xmlagg(xmlelement("SIGNATURE_PARAMS",

2617: psig.user_display_name as SIGNER_DISPLAY_NAME,
2618: psig.user_response as SIGNER_RESPONSE,
2619: fnd_date.date_to_displayDT(psig.signature_timestamp,FND_TIMEZONES.GET_SERVER_TIMEZONE_CODE) as SIGNING_DATE,
2620: psig.SIGNATURE_OVERRIDING_COMMENTS as OVERRIDING_DETAILS,
2621: (select xmlagg(xmlelement("SIGNATURE_PARAMS",
2622: xmlforest(param1.name as PARAM_NAME,
2623: param1.value as PARAM_VALUE)
2624: )
2625: )

Line 2709: xmlagg(xmlelement("PRINT_DETAILS",

2705:
2706:
2707: --This query would fetch the required XML.
2708: select xmlelement("PRINT_HISTORY_DETAILS",
2709: xmlagg(xmlelement("PRINT_DETAILS",
2710: xmlforest(print.print_document_id as PRINT_ERECORD_ID,
2711: print.PRINT_COUNT as PRINT_COUNT,
2712: PRINT.PRINT_REQUESTED_BY as PRINT_REQUESTER,
2713: PRINT.USER_DISPLAY_NAME as PRINT_REQUESTER_DISPLAY_NAME,