DBA Data[Home] [Help]

APPS.PSP_ER_WORKFLOW dependencies on DUAL

Line 629: select apps.fnd_global.resp_appl_id into l_resp_appl_id from dual;

625:
626: begin
627:
628: /*Changes for the bug 10185794 */
629: select apps.fnd_global.resp_appl_id into l_resp_appl_id from dual;
630: select apps.fnd_global.resp_id into l_resp_id from dual;
631: select apps.fnd_global.user_id into l_user from dual;
632:
633: if l_resp_id = -1

Line 630: select apps.fnd_global.resp_id into l_resp_id from dual;

626: begin
627:
628: /*Changes for the bug 10185794 */
629: select apps.fnd_global.resp_appl_id into l_resp_appl_id from dual;
630: select apps.fnd_global.resp_id into l_resp_id from dual;
631: select apps.fnd_global.user_id into l_user from dual;
632:
633: if l_resp_id = -1
634: then

Line 631: select apps.fnd_global.user_id into l_user from dual;

627:
628: /*Changes for the bug 10185794 */
629: select apps.fnd_global.resp_appl_id into l_resp_appl_id from dual;
630: select apps.fnd_global.resp_id into l_resp_id from dual;
631: select apps.fnd_global.user_id into l_user from dual;
632:
633: if l_resp_id = -1
634: then
635: l_set_options_success := fnd_request.set_options(datagroup=> 'Standard');

Line 1175: select apps.fnd_global.resp_appl_id into l_resp_appl_id from dual;

1171:
1172: begin
1173:
1174: /*Changes for the bug 10185794 */
1175: select apps.fnd_global.resp_appl_id into l_resp_appl_id from dual;
1176: select apps.fnd_global.resp_id into l_resp_id from dual;
1177: select apps.fnd_global.user_id into l_user from dual;
1178:
1179: if l_resp_id = -1

Line 1176: select apps.fnd_global.resp_id into l_resp_id from dual;

1172: begin
1173:
1174: /*Changes for the bug 10185794 */
1175: select apps.fnd_global.resp_appl_id into l_resp_appl_id from dual;
1176: select apps.fnd_global.resp_id into l_resp_id from dual;
1177: select apps.fnd_global.user_id into l_user from dual;
1178:
1179: if l_resp_id = -1
1180: then

Line 1177: select apps.fnd_global.user_id into l_user from dual;

1173:
1174: /*Changes for the bug 10185794 */
1175: select apps.fnd_global.resp_appl_id into l_resp_appl_id from dual;
1176: select apps.fnd_global.resp_id into l_resp_id from dual;
1177: select apps.fnd_global.user_id into l_user from dual;
1178:
1179: if l_resp_id = -1
1180: then
1181: l_set_options_success := fnd_request.set_options(datagroup=> 'Standard');

Line 1813: from dual;

1809: CLOSE payroll_action_id_cur;
1810:
1811: select psp_wf_item_key_s.nextval
1812: into l_wf_itemkey
1813: from dual;
1814:
1815: OPEN template_name_cur;
1816: FETCH template_name_cur INTO l_template_name, l_preview_flag, l_time_out, l_start_date, l_end_date;
1817: CLOSE template_name_cur;

Line 2155: select apps.fnd_global.resp_appl_id into l_resp_appl_id from dual;

2151:
2152: begin
2153:
2154: /*Changes for the bug 10185794 */
2155: select apps.fnd_global.resp_appl_id into l_resp_appl_id from dual;
2156: select apps.fnd_global.resp_id into l_resp_id from dual;
2157: select apps.fnd_global.user_id into l_user from dual;
2158:
2159: if l_resp_id = -1

Line 2156: select apps.fnd_global.resp_id into l_resp_id from dual;

2152: begin
2153:
2154: /*Changes for the bug 10185794 */
2155: select apps.fnd_global.resp_appl_id into l_resp_appl_id from dual;
2156: select apps.fnd_global.resp_id into l_resp_id from dual;
2157: select apps.fnd_global.user_id into l_user from dual;
2158:
2159: if l_resp_id = -1
2160: then

Line 2157: select apps.fnd_global.user_id into l_user from dual;

2153:
2154: /*Changes for the bug 10185794 */
2155: select apps.fnd_global.resp_appl_id into l_resp_appl_id from dual;
2156: select apps.fnd_global.resp_id into l_resp_id from dual;
2157: select apps.fnd_global.user_id into l_user from dual;
2158:
2159: if l_resp_id = -1
2160: then
2161: l_set_options_success := fnd_request.set_options(datagroup=> 'Standard');

Line 2227: select apps.fnd_global.resp_appl_id into l_resp_appl_id from dual;

2223:
2224: begin
2225:
2226: /*Changes for the bug 10185794 */
2227: select apps.fnd_global.resp_appl_id into l_resp_appl_id from dual;
2228: select apps.fnd_global.resp_id into l_resp_id from dual;
2229: select apps.fnd_global.user_id into l_user from dual;
2230:
2231: if l_resp_id = -1

Line 2228: select apps.fnd_global.resp_id into l_resp_id from dual;

2224: begin
2225:
2226: /*Changes for the bug 10185794 */
2227: select apps.fnd_global.resp_appl_id into l_resp_appl_id from dual;
2228: select apps.fnd_global.resp_id into l_resp_id from dual;
2229: select apps.fnd_global.user_id into l_user from dual;
2230:
2231: if l_resp_id = -1
2232: then

Line 2229: select apps.fnd_global.user_id into l_user from dual;

2225:
2226: /*Changes for the bug 10185794 */
2227: select apps.fnd_global.resp_appl_id into l_resp_appl_id from dual;
2228: select apps.fnd_global.resp_id into l_resp_id from dual;
2229: select apps.fnd_global.user_id into l_user from dual;
2230:
2231: if l_resp_id = -1
2232: then
2233: l_set_options_success := fnd_request.set_options(datagroup=> 'Standard');

Line 2409: select apps.fnd_global.resp_appl_id into l_resp_appl_id from dual;

2405:
2406: begin
2407:
2408: /*Changes for the bug 10185794 */
2409: select apps.fnd_global.resp_appl_id into l_resp_appl_id from dual;
2410: select apps.fnd_global.resp_id into l_resp_id from dual;
2411: select apps.fnd_global.user_id into l_user from dual;
2412:
2413: if l_resp_id = -1

Line 2410: select apps.fnd_global.resp_id into l_resp_id from dual;

2406: begin
2407:
2408: /*Changes for the bug 10185794 */
2409: select apps.fnd_global.resp_appl_id into l_resp_appl_id from dual;
2410: select apps.fnd_global.resp_id into l_resp_id from dual;
2411: select apps.fnd_global.user_id into l_user from dual;
2412:
2413: if l_resp_id = -1
2414: then

Line 2411: select apps.fnd_global.user_id into l_user from dual;

2407:
2408: /*Changes for the bug 10185794 */
2409: select apps.fnd_global.resp_appl_id into l_resp_appl_id from dual;
2410: select apps.fnd_global.resp_id into l_resp_id from dual;
2411: select apps.fnd_global.user_id into l_user from dual;
2412:
2413: if l_resp_id = -1
2414: then
2415: l_set_options_success := fnd_request.set_options(datagroup=> 'Standard');