APPS.PA_BC_COSTING dependencies on PA_IMPLEMENTATIONS

Line 33: g_sob_id pa_implementations.set_of_books_id%TYPE;

29: g_request_id pa_cost_distribution_lines.request_id%TYPE ;
30: g_program_application_id pa_cost_distribution_lines.program_application_id%TYPE := FND_GLOBAL.PROG_APPL_ID;
31: g_program_id pa_cost_distribution_lines.program_id%TYPE := FND_GLOBAL.CONC_PROGRAM_ID;
32: g_packet_id pa_bc_packets.packet_id%TYPE;
33: g_sob_id pa_implementations.set_of_books_id%TYPE;
34:
35: /*
36: * Package level Pl/Sql Tables.
37: */

Line 263: pa_debug.g_err_stage := TO_CHAR(l_stage) || ':ORACLE error occurred while selecting pa_implementations';

259: IF P_DEBUG_MODE = 'Y' THEN
260: pa_debug.write_file('costing_fc_proc: ' || pa_debug.g_err_stage);
261: END IF;
262:
263: pa_debug.g_err_stage := TO_CHAR(l_stage) || ':ORACLE error occurred while selecting pa_implementations';
264: /*
265: * Get the sob_id.
266: */
267: SELECT set_of_books_id

Line 269: FROM pa_implementations;

265: * Get the sob_id.
266: */
267: SELECT set_of_books_id
268: INTO g_sob_id
269: FROM pa_implementations;
270:
271: pa_debug.g_err_stage := TO_CHAR(l_stage) || ':After selecting from pa_implementations. Sob_id is [' || TO_CHAR(g_sob_id) || ']' ;
272: IF P_DEBUG_MODE = 'Y' THEN
273: pa_debug.write_file('costing_fc_proc: ' || pa_debug.g_err_stage);

Line 271: pa_debug.g_err_stage := TO_CHAR(l_stage) || ':After selecting from pa_implementations. Sob_id is [' || TO_CHAR(g_sob_id) || ']' ;

267: SELECT set_of_books_id
268: INTO g_sob_id
269: FROM pa_implementations;
270:
271: pa_debug.g_err_stage := TO_CHAR(l_stage) || ':After selecting from pa_implementations. Sob_id is [' || TO_CHAR(g_sob_id) || ']' ;
272: IF P_DEBUG_MODE = 'Y' THEN
273: pa_debug.write_file('costing_fc_proc: ' || pa_debug.g_err_stage);
274: END IF;
275:

Line 2408: pa_debug.g_err_stage := TO_CHAR(l_stage) || ':ORACLE error occurred while selecting pa_implementations';

2404:
2405: /*
2406: * Get the sob_id.
2407: */
2408: pa_debug.g_err_stage := TO_CHAR(l_stage) || ':ORACLE error occurred while selecting pa_implementations';
2409: SELECT set_of_books_id
2410: INTO g_sob_id
2411: FROM pa_implementations;
2412:

Line 2411: FROM pa_implementations;

2407: */
2408: pa_debug.g_err_stage := TO_CHAR(l_stage) || ':ORACLE error occurred while selecting pa_implementations';
2409: SELECT set_of_books_id
2410: INTO g_sob_id
2411: FROM pa_implementations;
2412:
2413: pa_debug.g_err_stage := TO_CHAR(l_stage) || ': Sob_id is [' || TO_CHAR(g_sob_id) || ']' ;
2414: IF P_DEBUG_MODE = 'Y' THEN
2415: pa_debug.write_file(l_proc_name|| ': ' || pa_debug.g_err_stage);