DBA Data[Home] [Help]

APPS.PSP_ENC_LIQ_TRAN dependencies on FND_GLOBAL

Line 70: g_request_id := fnd_global.conc_request_id;

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

Line 429: g_request_id := fnd_global.conc_request_id;

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

Line 2182: l_last_updated_by := fnd_global.user_id;

2178: l_last_update_login NUMBER(15);
2179: BEGIN
2180: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Entering CREATE_GL_ENC_LIQ_LINES');
2181:
2182: l_last_updated_by := fnd_global.user_id;
2183: l_last_update_login := fnd_global.login_id;
2184:
2185: IF (g_person_id IS NOT NULL) THEN
2186: OPEN emp_term_enc_liq_cur;

Line 2183: l_last_update_login := fnd_global.login_id;

2179: BEGIN
2180: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Entering CREATE_GL_ENC_LIQ_LINES');
2181:
2182: l_last_updated_by := fnd_global.user_id;
2183: l_last_update_login := fnd_global.login_id;
2184:
2185: IF (g_person_id IS NOT NULL) THEN
2186: OPEN emp_term_enc_liq_cur;
2187: FETCH emp_term_enc_liq_cur BULK COLLECT INTO r_liq_lines.enc_summary_line_id, r_liq_lines.effective_date,

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

2321: AND business_group_id = g_bg_id
2322: AND set_of_books_id = g_sob_id
2323: AND (gl_phase is null or gl_phase = 'TieBack'); --- added this line for 2444657
2324:
2325: l_request_id NUMBER DEFAULT fnd_global.conc_request_id; -- Introduced for bug 2259310
2326:
2327: CURSOR enc_liq_cur(p_enc_control_id IN NUMBER) IS
2328: SELECT DISTINCT pesl.enc_summary_line_id,
2329: pesl.effective_date,

Line 2619: FND_GLOBAL.USER_ID,

2615: p_attribute9,
2616: p_attribute10,
2617: p_expenditure_item_id, -- bug 4068182
2618: SYSDATE,
2619: FND_GLOBAL.USER_ID,
2620: FND_GLOBAL.LOGIN_ID,
2621: FND_GLOBAL.USER_ID,
2622: SYSDATE);
2623: p_return_status := fnd_api.g_ret_sts_success;

Line 2620: FND_GLOBAL.LOGIN_ID,

2616: p_attribute10,
2617: p_expenditure_item_id, -- bug 4068182
2618: SYSDATE,
2619: FND_GLOBAL.USER_ID,
2620: FND_GLOBAL.LOGIN_ID,
2621: FND_GLOBAL.USER_ID,
2622: SYSDATE);
2623: p_return_status := fnd_api.g_ret_sts_success;
2624:

Line 2621: FND_GLOBAL.USER_ID,

2617: p_expenditure_item_id, -- bug 4068182
2618: SYSDATE,
2619: FND_GLOBAL.USER_ID,
2620: FND_GLOBAL.LOGIN_ID,
2621: FND_GLOBAL.USER_ID,
2622: SYSDATE);
2623: p_return_status := fnd_api.g_ret_sts_success;
2624:
2625: EXCEPTION

Line 2795: l_created_by := fnd_global.user_id;

2791: -- End of changes for bug fix 4507892
2792: BEGIN
2793: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Entering Transfer to GL Interface');
2794:
2795: l_created_by := fnd_global.user_id;
2796:
2797: -- gl_tie_tab.delete; Commented for bug fix 4625734
2798:
2799: gl_je_source( l_user_je_source,

Line 4354: FND_GLOBAL.USER_ID,

4350: P_SET_OF_BOOKS_ID,
4351: P_ACCOUNTING_DATE,
4352: P_CURRENCY_CODE,
4353: SYSDATE,
4354: FND_GLOBAL.USER_ID,
4355: 'E',
4356: P_USER_JE_CATEGORY_NAME,
4357: P_USER_JE_SOURCE_NAME,
4358: P_ENCUMBRANCE_TYPE_ID,

Line 4656: l_last_updated_by := fnd_global.user_id;

4652: l_last_update_login NUMBER(15);
4653: BEGIN
4654: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Entering CREATE_GMS_ENC_LIQ_LINES');
4655:
4656: l_last_updated_by := fnd_global.user_id;
4657: l_last_update_login := fnd_global.login_id;
4658:
4659: IF (g_person_id IS NOT NULL) THEN
4660: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Fetching Liquidation for Emplopyee Termination Lines');

Line 4657: l_last_update_login := fnd_global.login_id;

4653: BEGIN
4654: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Entering CREATE_GMS_ENC_LIQ_LINES');
4655:
4656: l_last_updated_by := fnd_global.user_id;
4657: l_last_update_login := fnd_global.login_id;
4658:
4659: IF (g_person_id IS NOT NULL) THEN
4660: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Fetching Liquidation for Emplopyee Termination Lines');
4661: OPEN emp_term_enc_liq_cur;

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

4815: AND business_group_id = g_bg_id
4816: AND set_of_books_id = g_sob_id
4817: AND (gms_phase = 'TieBack' or gms_phase is null); --- added for 2444657
4818:
4819: l_request_id NUMBER DEFAULT fnd_global.conc_request_id; -- Introduced for bug 2259310
4820:
4821: CURSOR enc_liq_cur(p_enc_control_id IN NUMBER) IS
4822: SELECT distinct pesl.enc_summary_line_id,
4823: pesl.effective_date,

Line 7213: fnd_global.user_id,

7209: VALUES (get_rec_to_move_rec.assignment_id,
7210: p_payroll_id,
7211: get_rec_to_move_rec.change_type,
7212: p_action_type,
7213: fnd_global.user_id,
7214: sysdate,
7215: NULL);
7216:
7217: DELETE FROM psp_enc_changed_assignments peca