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
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
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');
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
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
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');
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;
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
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
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');
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
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
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');
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
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
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');