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 845: avalue => 'PLSQLBLOB:psp_xmlgen.attach_pdf/' || itemtype || ':' || itemkey);

841: --Bug 7135471
842: wf_engine.SetItemAttrText(itemType => itemtype,
843: itemKey => itemkey,
844: aname => 'PDF_ATTACHMENT',
845: avalue => 'PLSQLBLOB:psp_xmlgen.attach_pdf/' || itemtype || ':' || itemkey);
846:
847:
848: /*Added for bug 7004679 */
849: wf_engine.setitemowner(itemtype => itemtype,

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

882: end if;
883: end if;
884:
885: -- Code Moved from process Approvals
886: psp_xmlgen.update_er_person_xml (p_wf_item_key => itemkey,
887: p_return_status => l_return_status);
888:
889: IF (l_return_status = 'E') THEN
890: RAISE fnd_api.g_exc_unexpected_error;

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

1257: end loop;
1258: result := 'COMPLETE';
1259: -- MOving this code to Procedure get_next Approver
1260:
1261: psp_xmlgen.update_er_person_xml (p_wf_item_key => itemkey,
1262: p_return_status => l_return_status);
1263:
1264: IF (l_return_status = 'E') THEN
1265: RAISE fnd_api.g_exc_unexpected_error;

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

1904: --Bug 7135471
1905: wf_engine.SetItemAttrText(itemType => 'PSPERAVL',
1906: itemKey => l_wf_itemkey,
1907: aname => 'PDF_ATTACHMENT',
1908: avalue => 'PLSQLBLOB:psp_xmlgen.attach_pdf/' || 'PSPERAVL' || ':' || l_wf_itemkey);
1909:
1910: ELSE
1911: wf_engine.SetItemAttrText(itemtype => 'PSPERAVL',
1912: itemkey => l_wf_itemkey,

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

2102:
2103: wf_engine.SetItemAttrText(itemType => 'PSPERAVL',
2104: itemKey => itemkey,
2105: aname => 'PDF_ATTACHMENT',
2106: avalue => 'PLSQLBLOB:psp_xmlgen.attach_pdf/' || itemtype || ':' || itemkey);
2107: */
2108: null;
2109:
2110: end;

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

2123:
2124: wf_engine.SetItemAttrText(itemType => 'PSPERAVL',
2125: itemKey => itemkey,
2126: aname => 'PDF_ATTACHMENT',
2127: avalue => 'PLSQLBLOB:psp_xmlgen.attach_pdf/' || itemtype || ':' || itemkey);
2128:
2129: end;
2130:
2131: procedure update_receiver(itemtype in varchar2,

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

2203: --Bug 7135471
2204: wf_engine.SetItemAttrText(itemType => 'PSPERAVL',
2205: itemKey => itemkey,
2206: aname => 'PDF_ATTACHMENT',
2207: avalue => 'PLSQLBLOB:psp_xmlgen.attach_pdf/' || 'PSPERAVL' || ':' || itemkey);
2208:
2209:
2210: end update_receiver;
2211:

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

2247: --Bug 7135471
2248: wf_engine.SetItemAttrText(itemType => 'PSPERAVL',
2249: itemKey => itemkey,
2250: aname => 'PDF_ATTACHMENT',
2251: avalue => 'PLSQLBLOB:psp_xmlgen.attach_pdf/' || 'PSPERAVL' || ':' || itemkey);
2252:
2253:
2254: end update_approver;
2255: