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 92: IF FND_PROFILE.VALUE('PSP_ST_EXTENSION_ENABLE') = 'Y' THEN

88: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
89: END IF;
90:
91: -- call the user extension to populate attribute1 through attribute30
92: IF FND_PROFILE.VALUE('PSP_ST_EXTENSION_ENABLE') = 'Y' THEN
93: --- 2968684 added params and exception handlers to the following proc.
94: psp_st_ext.summary_ext_actual(p_source_type,
95: p_source_code ,
96: p_payroll_id ,

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

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

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

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

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

199: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
200: END IF;
201:
202: -- call the user extension to populate attribute1 through attribute30
203: IF FND_PROFILE.VALUE('PSP_ST_EXTENSION_ENABLE') = 'Y' THEN
204: --- 2968684 added params and exception handlers to the following proc.
205: psp_st_ext.summary_ext_actual(p_source_type,
206: p_source_code ,
207: p_payroll_id ,

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

734: --- order by accounting_date, exchange_rate_type for 3108109
735: --- order by attribute_category, attribute1 through attribute 10 for BUG 6007017
736:
737:
738: -- l_sob_id NUMBER(15) := FND_PROFILE.VALUE('PSP_SET_OF_BOOKS'); -- This comes as a param
739: l_person_id NUMBER(9);
740: l_assignment_id NUMBER(9);
741: l_gl_ccid NUMBER(15);
742: l_dr_cr_flag VARCHAR2(1);

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

3970: mo_global.set_policy_context('M', null);
3971:
3972: IF gms_batch_rec.phase = 'Submitted_TI_Request' then --2444657
3973: ---- added below for 5742525
3974: IF FND_PROFILE.VALUE('PSP_ST_EXTENSION_ENABLE') = 'Y' THEN
3975: psp_st_ext.tieback_actual(gms_batch_rec.payroll_control_id ,
3976: gms_batch_rec.source_type ,
3977: l_period_end_date ,
3978: l_gms_batch_name ,

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

5701: l_tsk_segment varchar2(30);
5702: l_awd_sgement varchar2(30);
5703: l_exp_org_segment varchar2(30);
5704: l_exp_type_segment varchar2(30);
5705: l_profile_bg_id Number := FND_PROFILE.VALUE('PER_BUSINESS_GROUP_ID');
5706:
5707: CURSOR get_Con_Program_name_csr IS
5708: SELECT USER_CONCURRENT_PROGRAM_NAME
5709: FROM fnd_concurrent_programs_vl fcp