DBA Data[Home] [Help]

APPS.PSP_SUM_ADJ dependencies on FND_PROFILE

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

5: g_gms_batch_name varchar2(10); /* bug 1662816 */
6: g_run_type varchar2(1); --- restart = R, normal = N, Replaces p_run_type -2444657
7:
8: -- Introduced the following for bug 2259310
9: g_enable_enc_summ_gl VARCHAR2(1) DEFAULT NVL(fnd_profile.value('PSP_ENABLE_ENC_SUMM_GL'), 'N');
10:
11: --Introduced for Bug no 2478000 Qubec fixes
12: -- g_currency_code VARCHAR2(15);-- for Bug no 2478000 by tbalacha Commented for bug fix 2916848
13:

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

102: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
103: END IF;
104:
105: -- call the user extension to populate attribute1 through attribute30
106: IF FND_PROFILE.VALUE('PSP_ST_EXTENSION_ENABLE') = 'Y' THEN
107: --- 2968684: added params and exception handler to proc.
108: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) ||' calling EXT ADJ code 1');
109:
110: psp_st_ext.summary_ext_adjustment(p_adj_sum_batch_name,

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

158: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
159: END IF;
160:
161: -- call the user extension to populate attribute1 through attribute30
162: IF FND_PROFILE.VALUE('PSP_ST_EXTENSION_ENABLE') = 'Y' THEN
163: --- 2968684: added params and exception handler to proc.
164: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) ||' calling EXT ADJ code 2');
165:
166: psp_st_ext.summary_ext_adjustment(p_adj_sum_batch_name,

Line 718: -- l_sob_id NUMBER(15) := FND_PROFILE.VALUE('PSP_SET_OF_BOOKS'); --Passed as a parameter.

714: ORDER BY 1,2,3,4,6,7,11,12,13,14,15,16,17,18,19,20,21,5;
715: --- added 2 columns for 3108109
716: --- changed the order by clause for 6007017
717:
718: -- l_sob_id NUMBER(15) := FND_PROFILE.VALUE('PSP_SET_OF_BOOKS'); --Passed as a parameter.
719: l_sob_id NUMBER(15) := p_set_of_books_id;
720: l_person_id NUMBER(9);
721: l_assignment_id NUMBER(9);
722: l_gl_ccid NUMBER(15);

Line 1264: -- l_sob_id NUMBER(15) := FND_PROFILE.VALUE('PSP_SET_OF_BOOKS');

1260: AND psl.payroll_control_id = p_payroll_control_id;
1261:
1262: gl_batch_rec gl_batch_cursor%ROWTYPE;
1263: gl_interface_rec gl_interface_cursor%ROWTYPE;
1264: -- l_sob_id NUMBER(15) := FND_PROFILE.VALUE('PSP_SET_OF_BOOKS');
1265: l_sob_id NUMBER(15) := p_set_of_books_id;
1266: l_user_je_source_name VARCHAR2(25);
1267: l_user_je_category_name VARCHAR2(25);
1268: l_period_name VARCHAR2(35);