DBA Data[Home] [Help]

APPS.PSP_ENC_SUM_TRAN dependencies on FND_GLOBAL

Line 206: l_last_updated_by := NVL(FND_GLOBAL.USER_ID, -1);

202: FETCH def_end_date_cur INTO g_def_end_date;
203: CLOSE def_end_date_cur;
204:
205: l_last_update_date := SYSDATE;
206: l_last_updated_by := NVL(FND_GLOBAL.USER_ID, -1);
207: l_last_updated_login := NVL(FND_GLOBAL.LOGIN_ID, -1);
208: l_request_id := fnd_global.conc_request_id;
209:
210: INSERT INTO psp_enc_processes

Line 207: l_last_updated_login := NVL(FND_GLOBAL.LOGIN_ID, -1);

203: CLOSE def_end_date_cur;
204:
205: l_last_update_date := SYSDATE;
206: l_last_updated_by := NVL(FND_GLOBAL.USER_ID, -1);
207: l_last_updated_login := NVL(FND_GLOBAL.LOGIN_ID, -1);
208: l_request_id := fnd_global.conc_request_id;
209:
210: INSERT INTO psp_enc_processes
211: (request_id, process_code, payroll_action_id,

Line 208: l_request_id := fnd_global.conc_request_id;

204:
205: l_last_update_date := SYSDATE;
206: l_last_updated_by := NVL(FND_GLOBAL.USER_ID, -1);
207: l_last_updated_login := NVL(FND_GLOBAL.LOGIN_ID, -1);
208: l_request_id := fnd_global.conc_request_id;
209:
210: INSERT INTO psp_enc_processes
211: (request_id, process_code, payroll_action_id,
212: process_status, process_phase, business_group_id,

Line 1828: FND_GLOBAL.USER_ID,

1824: p_attribute8,
1825: p_attribute9,
1826: p_attribute10,
1827: SYSDATE,
1828: FND_GLOBAL.USER_ID,
1829: FND_GLOBAL.LOGIN_ID,
1830: FND_GLOBAL.USER_ID,
1831: SYSDATE);
1832: p_return_status := fnd_api.g_ret_sts_success;

Line 1829: FND_GLOBAL.LOGIN_ID,

1825: p_attribute9,
1826: p_attribute10,
1827: SYSDATE,
1828: FND_GLOBAL.USER_ID,
1829: FND_GLOBAL.LOGIN_ID,
1830: FND_GLOBAL.USER_ID,
1831: SYSDATE);
1832: p_return_status := fnd_api.g_ret_sts_success;
1833: EXCEPTION

Line 1830: FND_GLOBAL.USER_ID,

1826: p_attribute10,
1827: SYSDATE,
1828: FND_GLOBAL.USER_ID,
1829: FND_GLOBAL.LOGIN_ID,
1830: FND_GLOBAL.USER_ID,
1831: SYSDATE);
1832: p_return_status := fnd_api.g_ret_sts_success;
1833: EXCEPTION
1834: WHEN OTHERS THEN

Line 2363: l_created_by := fnd_global.user_id;

2359: WHERE payroll_action_id = p_payroll_action_id;
2360: BEGIN
2361: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Entering Transfer to GL Interface');
2362:
2363: l_created_by := fnd_global.user_id;
2364: l_tie_back_failed := NULL;
2365: l_summarization_option := NVL(fnd_profile.value('PSP_ENABLE_ENC_SUMM_GL'),'N');
2366:
2367: gl_je_source( l_user_je_source,

Line 4031: FND_GLOBAL.USER_ID,

4027: P_SET_OF_BOOKS_ID,
4028: P_ACCOUNTING_DATE,
4029: P_CURRENCY_CODE,
4030: SYSDATE,
4031: FND_GLOBAL.USER_ID,
4032: 'E',
4033: P_USER_JE_CATEGORY_NAME,
4034: P_USER_JE_SOURCE_NAME,
4035: P_ENCUMBRANCE_TYPE_ID,

Line 6812: l_last_updated_by := fnd_global.user_id;

6808: attribute10 t_varchar_150_type,
6809: org_id t_num_15_type);
6810: t_sum_lines sum_lines_rec;
6811: BEGIN
6812: l_last_updated_by := fnd_global.user_id;
6813: l_last_update_login := fnd_global.login_id;
6814:
6815: OPEN sum_lines_cur;
6816: FETCH sum_lines_cur BULK COLLECT INTO t_sum_lines.enc_control_id,

Line 6813: l_last_update_login := fnd_global.login_id;

6809: org_id t_num_15_type);
6810: t_sum_lines sum_lines_rec;
6811: BEGIN
6812: l_last_updated_by := fnd_global.user_id;
6813: l_last_update_login := fnd_global.login_id;
6814:
6815: OPEN sum_lines_cur;
6816: FETCH sum_lines_cur BULK COLLECT INTO t_sum_lines.enc_control_id,
6817: t_sum_lines.time_period_id, t_sum_lines.person_id,

Line 7154: l_request_id := fnd_global.conc_request_id;

7150: FROM pay_element_types_f
7151: WHERE element_type_id = p_element_type_id
7152: AND ROWNUM = 1;
7153: BEGIN
7154: l_request_id := fnd_global.conc_request_id;
7155:
7156: FOR recno IN 1..st_warnings.assignment_id.COUNT
7157: LOOP
7158: OPEN asg_number_cur(st_warnings.assignment_id(recno), st_warnings.payroll_id(recno), st_warnings.start_date(recno));