DBA Data[Home] [Help]

APPS.PSP_ENC_SUM_TRAN dependencies on FND_GLOBAL

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

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

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

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

Line 206: l_request_id := fnd_global.conc_request_id;

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

Line 1808: FND_GLOBAL.USER_ID,

1804: p_attribute8,
1805: p_attribute9,
1806: p_attribute10,
1807: SYSDATE,
1808: FND_GLOBAL.USER_ID,
1809: FND_GLOBAL.LOGIN_ID,
1810: FND_GLOBAL.USER_ID,
1811: SYSDATE);
1812: p_return_status := fnd_api.g_ret_sts_success;

Line 1809: FND_GLOBAL.LOGIN_ID,

1805: p_attribute9,
1806: p_attribute10,
1807: SYSDATE,
1808: FND_GLOBAL.USER_ID,
1809: FND_GLOBAL.LOGIN_ID,
1810: FND_GLOBAL.USER_ID,
1811: SYSDATE);
1812: p_return_status := fnd_api.g_ret_sts_success;
1813: EXCEPTION

Line 1810: FND_GLOBAL.USER_ID,

1806: p_attribute10,
1807: SYSDATE,
1808: FND_GLOBAL.USER_ID,
1809: FND_GLOBAL.LOGIN_ID,
1810: FND_GLOBAL.USER_ID,
1811: SYSDATE);
1812: p_return_status := fnd_api.g_ret_sts_success;
1813: EXCEPTION
1814: WHEN OTHERS THEN

Line 2342: l_created_by := fnd_global.user_id;

2338: WHERE payroll_action_id = p_payroll_action_id;
2339: BEGIN
2340: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Entering Transfer to GL Interface');
2341:
2342: l_created_by := fnd_global.user_id;
2343: l_tie_back_failed := NULL;
2344: l_summarization_option := NVL(fnd_profile.value('PSP_ENABLE_ENC_SUMM_GL'),'N');
2345:
2346: gl_je_source( l_user_je_source,

Line 3928: FND_GLOBAL.USER_ID,

3924: P_SET_OF_BOOKS_ID,
3925: P_ACCOUNTING_DATE,
3926: P_CURRENCY_CODE,
3927: SYSDATE,
3928: FND_GLOBAL.USER_ID,
3929: 'E',
3930: P_USER_JE_CATEGORY_NAME,
3931: P_USER_JE_SOURCE_NAME,
3932: P_ENCUMBRANCE_TYPE_ID,

Line 6578: l_last_updated_by := fnd_global.user_id;

6574: attribute10 t_varchar_150_type,
6575: org_id t_num_15_type);
6576: t_sum_lines sum_lines_rec;
6577: BEGIN
6578: l_last_updated_by := fnd_global.user_id;
6579: l_last_update_login := fnd_global.login_id;
6580:
6581: OPEN sum_lines_cur;
6582: FETCH sum_lines_cur BULK COLLECT INTO t_sum_lines.enc_control_id,

Line 6579: l_last_update_login := fnd_global.login_id;

6575: org_id t_num_15_type);
6576: t_sum_lines sum_lines_rec;
6577: BEGIN
6578: l_last_updated_by := fnd_global.user_id;
6579: l_last_update_login := fnd_global.login_id;
6580:
6581: OPEN sum_lines_cur;
6582: FETCH sum_lines_cur BULK COLLECT INTO t_sum_lines.enc_control_id,
6583: t_sum_lines.time_period_id, t_sum_lines.person_id,

Line 6918: l_request_id := fnd_global.conc_request_id;

6914: FROM pay_element_types_f
6915: WHERE element_type_id = p_element_type_id
6916: AND ROWNUM = 1;
6917: BEGIN
6918: l_request_id := fnd_global.conc_request_id;
6919:
6920: FOR recno IN 1..st_warnings.assignment_id.COUNT
6921: LOOP
6922: OPEN asg_number_cur(st_warnings.assignment_id(recno), st_warnings.payroll_id(recno), st_warnings.start_date(recno));