[Home] [Help]
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:
61: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
62: END IF;
63:
64: -- call the user extension to populate attribute1 through attribute30
65: IF FND_PROFILE.VALUE('PSP_ST_EXTENSION_ENABLE') = 'Y' THEN
66: --- 2968684: added params and exception handler to proc.
67: psp_st_ext.summary_ext_adjustment(p_adj_sum_batch_name,
68: p_business_group_id ,
69: p_set_of_books_id );
111: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
112: END IF;
113:
114: -- call the user extension to populate attribute1 through attribute30
115: IF FND_PROFILE.VALUE('PSP_ST_EXTENSION_ENABLE') = 'Y' THEN
116: --- 2968684: added params and exception handler to proc.
117: psp_st_ext.summary_ext_adjustment(p_adj_sum_batch_name,
118: p_business_group_id ,
119: p_set_of_books_id );
638: ORDER BY 1,2,3,4,6,7,11,12,13,14,15,16,17,18,19,20,21,5;
639: --- added 2 columns for 3108109
640: --- changed the order by clause for 6007017
641:
642: -- l_sob_id NUMBER(15) := FND_PROFILE.VALUE('PSP_SET_OF_BOOKS'); --Passed as a parameter.
643: l_sob_id NUMBER(15) := p_set_of_books_id;
644: l_person_id NUMBER(9);
645: l_assignment_id NUMBER(9);
646: l_gl_ccid NUMBER(15);
1168: AND psl.payroll_control_id = p_payroll_control_id;
1169:
1170: gl_batch_rec gl_batch_cursor%ROWTYPE;
1171: gl_interface_rec gl_interface_cursor%ROWTYPE;
1172: -- l_sob_id NUMBER(15) := FND_PROFILE.VALUE('PSP_SET_OF_BOOKS');
1173: l_sob_id NUMBER(15) := p_set_of_books_id;
1174: l_user_je_source_name VARCHAR2(25);
1175: l_user_je_category_name VARCHAR2(25);
1176: l_period_name VARCHAR2(35);