DBA Data[Home] [Help]

APPS.PA_CC_BL_PROCESS dependencies on PA_CC_DIST_LINES_ALL

Line 30: G_BL_LINE_TYPE CONSTANT pa_cc_dist_lines_all.line_type%TYPE := 'BL';

26:
27: g_initialization_done BOOLEAN := FALSE;
28: --g_mrc_enabled boolean;
29:
30: G_BL_LINE_TYPE CONSTANT pa_cc_dist_lines_all.line_type%TYPE := 'BL';
31:
32: -- g_org_id stores the current OU.
33: g_org_id pa_implementations_all.org_id%type ;
34:

Line 241: l_transfer_status_code pa_cc_dist_lines_all.transfer_status_code%TYPE;

237: l_prev_rec_exist BOOLEAN;
238: l_parent_dist_code VARCHAR2(2);
239:
240: l_source_eid pa_expenditure_items_all.expenditure_item_id%TYPE;
241: l_transfer_status_code pa_cc_dist_lines_all.transfer_status_code%TYPE;
242:
243: /*Added for cross proj*/
244: p_project_transfer_price PA_PLSQL_DATATYPES.Char30TabTyp;
245: p_projfunc_transfer_price PA_PLSQL_DATATYPES.Char30TabTyp;

Line 1451: (select ccdl1.cc_dist_line_id from pa_cc_dist_lines_all ccdl1,

1447: get inserted only during mass_insert. ****** */
1448:
1449: update pa_cc_dist_lines ccdl2
1450: set dist_line_id_reversed =
1451: (select ccdl1.cc_dist_line_id from pa_cc_dist_lines_all ccdl1,
1452: pa_expenditure_items_all ei1,
1453: pa_expenditure_items_all ei2
1454: where ccdl1.expenditure_item_id = ei1.expenditure_item_id
1455: and ccdl2.expenditure_item_id = ei2.expenditure_item_id