DBA Data[Home] [Help]

APPS.PSP_SUM_TRANS dependencies on FND_GLOBAL

Line 317: errbuf := SUBSTR(l_msg_data || fnd_global.local_chr(10) ||fnd_global.local_chr(10)||g_error_api_path,1,230);

313: p_data => l_msg_data,
314: p_msg_index_out => l_msg_count); */
315:
316: g_error_api_path := 'SUM_AND_TRANSFER:'||g_error_api_path;
317: errbuf := SUBSTR(l_msg_data || fnd_global.local_chr(10) ||fnd_global.local_chr(10)||g_error_api_path,1,230);
318: psp_message_s.print_error(p_mode => FND_FILE.LOG,
319: p_print_header => FND_API.G_TRUE);
320: retcode := 2;
321: WHEN OTHERS THEN

Line 347: errbuf := SUBSTR(l_msg_data || fnd_global.local_chr(10) ||fnd_global.local_chr(10)||g_error_api_path,1,230);

343: p_data => l_msg_data,
344: p_msg_index_out => l_msg_count); */
345:
346: g_error_api_path := 'SUM_AND_TRANSFER:'||g_error_api_path;
347: errbuf := SUBSTR(l_msg_data || fnd_global.local_chr(10) ||fnd_global.local_chr(10)||g_error_api_path,1,230);
348: psp_message_s.print_error(p_mode => FND_FILE.LOG,
349: p_print_header => FND_API.G_TRUE);
350: retcode := 2;
351: END;

Line 1251: FND_GLOBAL.USER_ID,

1247: P_INTERFACE_BATCH_NAME,
1248: P_PAYROLL_CONTROL_ID,
1249: P_BUSINESS_GROUP_ID,
1250: SYSDATE,
1251: FND_GLOBAL.USER_ID,
1252: FND_GLOBAL.LOGIN_ID,
1253: FND_GLOBAL.USER_ID,
1254: SYSDATE,
1255: DECODE(P_PROJECT_ID, NULL,P_SUMMARY_AMOUNT, DECODE(P_DR_CR_FLAG,'C',0 - P_SUMMARY_AMOUNT,P_SUMMARY_AMOUNT)), --For Bug 2496661

Line 1252: FND_GLOBAL.LOGIN_ID,

1248: P_PAYROLL_CONTROL_ID,
1249: P_BUSINESS_GROUP_ID,
1250: SYSDATE,
1251: FND_GLOBAL.USER_ID,
1252: FND_GLOBAL.LOGIN_ID,
1253: FND_GLOBAL.USER_ID,
1254: SYSDATE,
1255: DECODE(P_PROJECT_ID, NULL,P_SUMMARY_AMOUNT, DECODE(P_DR_CR_FLAG,'C',0 - P_SUMMARY_AMOUNT,P_SUMMARY_AMOUNT)), --For Bug 2496661
1256: p_attribute_category, -- Introduced for bug fix 2908859

Line 1253: FND_GLOBAL.USER_ID,

1249: P_BUSINESS_GROUP_ID,
1250: SYSDATE,
1251: FND_GLOBAL.USER_ID,
1252: FND_GLOBAL.LOGIN_ID,
1253: FND_GLOBAL.USER_ID,
1254: SYSDATE,
1255: DECODE(P_PROJECT_ID, NULL,P_SUMMARY_AMOUNT, DECODE(P_DR_CR_FLAG,'C',0 - P_SUMMARY_AMOUNT,P_SUMMARY_AMOUNT)), --For Bug 2496661
1256: p_attribute_category, -- Introduced for bug fix 2908859
1257: p_attribute1,

Line 3065: FND_GLOBAL.USER_ID,

3061: P_SET_OF_BOOKS_ID,
3062: P_ACCOUNTING_DATE,
3063: P_CURRENCY_CODE,
3064: SYSDATE,
3065: FND_GLOBAL.USER_ID,
3066: 'A',
3067: P_USER_JE_CATEGORY_NAME,
3068: P_USER_JE_SOURCE_NAME,
3069: P_ENCUMBRANCE_TYPE_ID,

Line 6133: WHERE CONCURRENT_PROGRAM_ID = fnd_global.CONC_PROGRAM_ID;

6129:
6130: CURSOR get_Con_Program_name_csr IS
6131: SELECT USER_CONCURRENT_PROGRAM_NAME
6132: FROM fnd_concurrent_programs_vl fcp
6133: WHERE CONCURRENT_PROGRAM_ID = fnd_global.CONC_PROGRAM_ID;
6134: l_Con_Program_name varchar2(240);
6135:
6136:
6137: PROCEDURE SEND_NOTIFICATIONS(p_supercede_reqid_str in varchar2,

Line 6519: l_S_and_T_reqid := fnd_global.conc_request_id;

6515: ---hr_utility.trace_on('Y','ZX');
6516: hr_utility.trace( 'SandT_Supercede--> Begin p_run_id='||p_run_id);
6517: fnd_signon.set_session(to_char(sysdate,'dd-mon-yyyy'));
6518: p_return_status := fnd_api.g_ret_sts_success;
6519: l_S_and_T_reqid := fnd_global.conc_request_id;
6520: fnd_stats.gather_table_stats(ownname => 'PSP',
6521: tabname => 'PSP_SUPERCEDE_PERSONS_GT');
6522: open check_er_template_h;
6523: fetch check_er_template_h bulk collect into t_template_id, t_request_id;