DBA Data[Home] [Help]

APPS.PSP_ENC_LIQ_TRAN dependencies on FND_GLOBAL

Line 69: g_request_id := fnd_global.conc_request_id;

65:
66: g_dff_grouping_option := psp_general.get_enc_dff_grouping_option(p_business_group_id); -- Introduced for bug fix 2908859
67: g_gl_run := FALSE;
68: g_liq_has_failed_transactions := FALSE;
69: g_request_id := fnd_global.conc_request_id;
70:
71: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' g_bg_id: ' || g_bg_id || '
72: g_sob_id: ' || g_sob_id || '
73: g_payroll_id: ' || g_payroll_id || '

Line 428: g_request_id := fnd_global.conc_request_id;

424: g_bg_id := p_business_group_id;
425: g_sob_id := p_set_of_books_id;
426: g_gl_run := FALSE;
427: g_liq_has_failed_transactions := FALSE;
428: g_request_id := fnd_global.conc_request_id;
429: g_currency_code := psp_general.get_currency_code(p_business_group_id);
430: g_dff_grouping_option := psp_general.get_enc_dff_grouping_option(p_business_group_id); -- Introduced for bug fix 2908859
431:
432: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' PA Transaction Purgeble Flag set');

Line 2130: l_last_updated_by := fnd_global.user_id;

2126: l_last_update_login NUMBER(15);
2127: BEGIN
2128: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Entering CREATE_GL_ENC_LIQ_LINES');
2129:
2130: l_last_updated_by := fnd_global.user_id;
2131: l_last_update_login := fnd_global.login_id;
2132:
2133: IF (g_person_id IS NOT NULL) THEN
2134: OPEN emp_term_enc_liq_cur;

Line 2131: l_last_update_login := fnd_global.login_id;

2127: BEGIN
2128: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Entering CREATE_GL_ENC_LIQ_LINES');
2129:
2130: l_last_updated_by := fnd_global.user_id;
2131: l_last_update_login := fnd_global.login_id;
2132:
2133: IF (g_person_id IS NOT NULL) THEN
2134: OPEN emp_term_enc_liq_cur;
2135: FETCH emp_term_enc_liq_cur BULK COLLECT INTO r_liq_lines.enc_summary_line_id, r_liq_lines.effective_date,

Line 2272: l_request_id NUMBER DEFAULT fnd_global.conc_request_id; -- Introduced for bug 2259310

2268: AND business_group_id = g_bg_id
2269: AND set_of_books_id = g_sob_id
2270: AND (gl_phase is null or gl_phase = 'TieBack'); --- added this line for 2444657
2271:
2272: l_request_id NUMBER DEFAULT fnd_global.conc_request_id; -- Introduced for bug 2259310
2273:
2274: CURSOR enc_liq_cur(p_enc_control_id IN NUMBER) IS
2275: SELECT DISTINCT pesl.enc_summary_line_id,
2276: pesl.effective_date,

Line 2566: FND_GLOBAL.USER_ID,

2562: p_attribute9,
2563: p_attribute10,
2564: p_expenditure_item_id, -- bug 4068182
2565: SYSDATE,
2566: FND_GLOBAL.USER_ID,
2567: FND_GLOBAL.LOGIN_ID,
2568: FND_GLOBAL.USER_ID,
2569: SYSDATE);
2570: p_return_status := fnd_api.g_ret_sts_success;

Line 2567: FND_GLOBAL.LOGIN_ID,

2563: p_attribute10,
2564: p_expenditure_item_id, -- bug 4068182
2565: SYSDATE,
2566: FND_GLOBAL.USER_ID,
2567: FND_GLOBAL.LOGIN_ID,
2568: FND_GLOBAL.USER_ID,
2569: SYSDATE);
2570: p_return_status := fnd_api.g_ret_sts_success;
2571:

Line 2568: FND_GLOBAL.USER_ID,

2564: p_expenditure_item_id, -- bug 4068182
2565: SYSDATE,
2566: FND_GLOBAL.USER_ID,
2567: FND_GLOBAL.LOGIN_ID,
2568: FND_GLOBAL.USER_ID,
2569: SYSDATE);
2570: p_return_status := fnd_api.g_ret_sts_success;
2571:
2572: EXCEPTION

Line 2742: l_created_by := fnd_global.user_id;

2738: -- End of changes for bug fix 4507892
2739: BEGIN
2740: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Entering Transfer to GL Interface');
2741:
2742: l_created_by := fnd_global.user_id;
2743:
2744: -- gl_tie_tab.delete; Commented for bug fix 4625734
2745:
2746: gl_je_source( l_user_je_source,

Line 4290: FND_GLOBAL.USER_ID,

4286: P_SET_OF_BOOKS_ID,
4287: P_ACCOUNTING_DATE,
4288: P_CURRENCY_CODE,
4289: SYSDATE,
4290: FND_GLOBAL.USER_ID,
4291: 'E',
4292: P_USER_JE_CATEGORY_NAME,
4293: P_USER_JE_SOURCE_NAME,
4294: P_ENCUMBRANCE_TYPE_ID,

Line 4592: l_last_updated_by := fnd_global.user_id;

4588: l_last_update_login NUMBER(15);
4589: BEGIN
4590: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Entering CREATE_GMS_ENC_LIQ_LINES');
4591:
4592: l_last_updated_by := fnd_global.user_id;
4593: l_last_update_login := fnd_global.login_id;
4594:
4595: IF (g_person_id IS NOT NULL) THEN
4596: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Fetching Liquidation for Emplopyee Termination Lines');

Line 4593: l_last_update_login := fnd_global.login_id;

4589: BEGIN
4590: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Entering CREATE_GMS_ENC_LIQ_LINES');
4591:
4592: l_last_updated_by := fnd_global.user_id;
4593: l_last_update_login := fnd_global.login_id;
4594:
4595: IF (g_person_id IS NOT NULL) THEN
4596: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Fetching Liquidation for Emplopyee Termination Lines');
4597: OPEN emp_term_enc_liq_cur;

Line 4754: l_request_id NUMBER DEFAULT fnd_global.conc_request_id; -- Introduced for bug 2259310

4750: AND business_group_id = g_bg_id
4751: AND set_of_books_id = g_sob_id
4752: AND (gms_phase = 'TieBack' or gms_phase is null); --- added for 2444657
4753:
4754: l_request_id NUMBER DEFAULT fnd_global.conc_request_id; -- Introduced for bug 2259310
4755:
4756: CURSOR enc_liq_cur(p_enc_control_id IN NUMBER) IS
4757: SELECT distinct pesl.enc_summary_line_id,
4758: pesl.effective_date,

Line 6975: fnd_global.user_id,

6971: VALUES (get_rec_to_move_rec.assignment_id,
6972: p_payroll_id,
6973: get_rec_to_move_rec.change_type,
6974: p_action_type,
6975: fnd_global.user_id,
6976: sysdate,
6977: NULL);
6978:
6979: DELETE FROM psp_enc_changed_assignments peca