APPS.PSP_SUM_TRANS dependencies on FND_PROFILE

Line 14: g_enable_enc_summ_gl VARCHAR2(1) DEFAULT NVL(fnd_profile.value('PSP_ENABLE_ENC_SUMM_GL'), 'N');

10: g_payroll_id integer; --- added for ER enhancment.
11: -- g_currency_code Varchar2(15); -- added for bug no 2478000 Commented for Bug 2916848
12:
13: -- Introduced the following for bug 2259310
14: g_enable_enc_summ_gl VARCHAR2(1) DEFAULT NVL(fnd_profile.value('PSP_ENABLE_ENC_SUMM_GL'), 'N');
15:
16: g_insert_str VARCHAR2(5000); -- Introduced for Bug fix 2935850
17:
18: g_dff_grouping_option CHAR(1); -- Introduced for bug fix 2908859

Line 129: IF FND_PROFILE.VALUE('PSP_ST_EXTENSION_ENABLE') = 'Y' THEN

125: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
126: END IF;
127:
128: -- call the user extension to populate attribute1 through attribute30
129: IF FND_PROFILE.VALUE('PSP_ST_EXTENSION_ENABLE') = 'Y' THEN
130: --- 2968684 added params and exception handlers to the following proc.
131: psp_st_ext.summary_ext_actual(p_source_type,
132: p_source_code ,
133: p_payroll_id ,

Line 168: IF FND_PROFILE.VALUE('PSP_ST_EXTENSION_ENABLE') = 'Y' THEN

164: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
165: END IF;
166:
167: -- Call the user extension to populate attribute1 thru attribute 30.
168: IF FND_PROFILE.VALUE('PSP_ST_EXTENSION_ENABLE') = 'Y' THEN
169: --- 2968684 added params and exception handlers to the following proc.
170: psp_st_ext.summary_ext_actual(p_source_type,
171: p_source_code ,
172: p_payroll_id ,

Line 212: IF FND_PROFILE.VALUE('PSP_ST_EXTENSION_ENABLE') = 'Y' THEN

208: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
209: END IF;
210:
211: -- Call the user extension to populate attribute1 thru attribute 30.
212: IF FND_PROFILE.VALUE('PSP_ST_EXTENSION_ENABLE') = 'Y' THEN
213: --- 2968684 added params and exception handlers to the following proc.
214: psp_st_ext.summary_ext_actual(p_source_type,
215: p_source_code ,
216: p_payroll_id ,

Line 252: IF FND_PROFILE.VALUE('PSP_ST_EXTENSION_ENABLE') = 'Y' THEN

248: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
249: END IF;
250:
251: -- call the user extension to populate attribute1 through attribute30
252: IF FND_PROFILE.VALUE('PSP_ST_EXTENSION_ENABLE') = 'Y' THEN
253: --- 2968684 added params and exception handlers to the following proc.
254: psp_st_ext.summary_ext_actual(p_source_type,
255: p_source_code ,
256: p_payroll_id ,

Line 795: -- l_sob_id NUMBER(15) := FND_PROFILE.VALUE('PSP_SET_OF_BOOKS'); -- This comes as a param

791: --- order by accounting_date, exchange_rate_type for 3108109
792: --- order by attribute_category, attribute1 through attribute 10 for BUG 6007017
793:
794:
795: -- l_sob_id NUMBER(15) := FND_PROFILE.VALUE('PSP_SET_OF_BOOKS'); -- This comes as a param
796: l_person_id NUMBER(9);
797: l_assignment_id NUMBER(9);
798: l_gl_ccid NUMBER(15);
799: l_dr_cr_flag VARCHAR2(1);

Line 4233: IF FND_PROFILE.VALUE('PSP_ST_EXTENSION_ENABLE') = 'Y' THEN

4229: mo_global.set_policy_context('M', null);
4230:
4231: IF gms_batch_rec.phase = 'Submitted_TI_Request' then --2444657
4232: ---- added below for 5742525
4233: IF FND_PROFILE.VALUE('PSP_ST_EXTENSION_ENABLE') = 'Y' THEN
4234: psp_st_ext.tieback_actual(gms_batch_rec.payroll_control_id ,
4235: gms_batch_rec.source_type ,
4236: l_period_end_date ,
4237: l_gms_batch_name ,

Line 6128: l_profile_bg_id Number := FND_PROFILE.VALUE('PER_BUSINESS_GROUP_ID');

6124: l_tsk_segment varchar2(30);
6125: l_awd_sgement varchar2(30);
6126: l_exp_org_segment varchar2(30);
6127: l_exp_type_segment varchar2(30);
6128: l_profile_bg_id Number := FND_PROFILE.VALUE('PER_BUSINESS_GROUP_ID');
6129:
6130: CURSOR get_Con_Program_name_csr IS
6131: SELECT USER_CONCURRENT_PROGRAM_NAME
6132: FROM fnd_concurrent_programs_vl fcp