DBA Data[Home] [Help]

APPS.PSP_ER_WORKFLOW dependencies on PSP_XMLGEN

Line 111: psp_xmlgen.update_er_error_details (p_request_id => l_request_id,

107:
108: IF (l_program_name <> 'PSPRTEF') THEN
109: start_initiator_wf(l_request_id);
110:
111: psp_xmlgen.update_er_error_details (p_request_id => l_request_id,
112: p_retry_request_id => NULL,
113: p_return_status => l_return_status);
114: ELSE
115: OPEN original_request_id_cur;

Line 119: psp_xmlgen.update_er_error_details (p_request_id => l_original_request_id,

115: OPEN original_request_id_cur;
116: FETCH original_request_id_cur INTO l_original_request_id;
117: CLOSE original_request_id_cur;
118:
119: psp_xmlgen.update_er_error_details (p_request_id => l_original_request_id,
120: p_retry_request_id => l_request_id,
121: p_return_status => l_return_status);
122: END IF;
123:

Line 393: avalue => 'PLSQLBLOB:psp_xmlgen.attach_pdf/' || 'PSPERAVL' || ':' || wf_ikey_array(k));

389: --Bug 7135471
390: wf_engine.SetItemAttrText(itemType => 'PSPERAVL',
391: itemKey => wf_ikey_array(k),
392: aname => 'PDF_ATTACHMENT',
393: avalue => 'PLSQLBLOB:psp_xmlgen.attach_pdf/' || 'PSPERAVL' || ':' || wf_ikey_array(k));
394:
395: wf_engine.SetItemAttrText(itemtype => 'PSPERAVL',
396: itemkey => wf_ikey_array(k),
397: aname => 'START_DATE',

Line 829: avalue => 'PLSQLBLOB:psp_xmlgen.attach_pdf/' || itemtype || ':' || itemkey);

825: --Bug 7135471
826: wf_engine.SetItemAttrText(itemType => itemtype,
827: itemKey => itemkey,
828: aname => 'PDF_ATTACHMENT',
829: avalue => 'PLSQLBLOB:psp_xmlgen.attach_pdf/' || itemtype || ':' || itemkey);
830:
831:
832: /*Added for bug 7004679 */
833: wf_engine.setitemowner(itemtype => itemtype,

Line 870: psp_xmlgen.update_er_person_xml (p_wf_item_key => itemkey,

866: end if;
867: end if;
868:
869: -- Code Moved from process Approvals
870: psp_xmlgen.update_er_person_xml (p_wf_item_key => itemkey,
871: p_return_status => l_return_status);
872:
873: IF (l_return_status = 'E') THEN
874: RAISE fnd_api.g_exc_unexpected_error;

Line 1229: psp_xmlgen.update_er_person_xml (p_wf_item_key => itemkey,

1225: end loop;
1226: result := 'COMPLETE';
1227: -- MOving this code to Procedure get_next Approver
1228:
1229: psp_xmlgen.update_er_person_xml (p_wf_item_key => itemkey,
1230: p_return_status => l_return_status);
1231:
1232: IF (l_return_status = 'E') THEN
1233: RAISE fnd_api.g_exc_unexpected_error;

Line 1868: avalue => 'PLSQLBLOB:psp_xmlgen.attach_pdf/' || 'PSPERAVL' || ':' || l_wf_itemkey);

1864: --Bug 7135471
1865: wf_engine.SetItemAttrText(itemType => 'PSPERAVL',
1866: itemKey => l_wf_itemkey,
1867: aname => 'PDF_ATTACHMENT',
1868: avalue => 'PLSQLBLOB:psp_xmlgen.attach_pdf/' || 'PSPERAVL' || ':' || l_wf_itemkey);
1869:
1870: ELSE
1871: wf_engine.SetItemAttrText(itemtype => 'PSPERAVL',
1872: itemkey => l_wf_itemkey,

Line 2066: avalue => 'PLSQLBLOB:psp_xmlgen.attach_pdf/' || itemtype || ':' || itemkey);

2062:
2063: wf_engine.SetItemAttrText(itemType => 'PSPERAVL',
2064: itemKey => itemkey,
2065: aname => 'PDF_ATTACHMENT',
2066: avalue => 'PLSQLBLOB:psp_xmlgen.attach_pdf/' || itemtype || ':' || itemkey);
2067: */
2068: null;
2069:
2070: end;

Line 2087: avalue => 'PLSQLBLOB:psp_xmlgen.attach_pdf/' || itemtype || ':' || itemkey);

2083:
2084: wf_engine.SetItemAttrText(itemType => 'PSPERAVL',
2085: itemKey => itemkey,
2086: aname => 'PDF_ATTACHMENT',
2087: avalue => 'PLSQLBLOB:psp_xmlgen.attach_pdf/' || itemtype || ':' || itemkey);
2088:
2089: end;
2090:
2091: procedure update_receiver(itemtype in varchar2,

Line 2151: avalue => 'PLSQLBLOB:psp_xmlgen.attach_pdf/' || 'PSPERAVL' || ':' || itemkey);

2147: --Bug 7135471
2148: wf_engine.SetItemAttrText(itemType => 'PSPERAVL',
2149: itemKey => itemkey,
2150: aname => 'PDF_ATTACHMENT',
2151: avalue => 'PLSQLBLOB:psp_xmlgen.attach_pdf/' || 'PSPERAVL' || ':' || itemkey);
2152:
2153:
2154: end update_receiver;
2155:

Line 2176: avalue => 'PLSQLBLOB:psp_xmlgen.attach_pdf/' || 'PSPERAVL' || ':' || itemkey);

2172: --Bug 7135471
2173: wf_engine.SetItemAttrText(itemType => 'PSPERAVL',
2174: itemKey => itemkey,
2175: aname => 'PDF_ATTACHMENT',
2176: avalue => 'PLSQLBLOB:psp_xmlgen.attach_pdf/' || 'PSPERAVL' || ':' || itemkey);
2177:
2178:
2179: end update_approver;
2180: