APPS.PA_CC_BL_PROCESS dependencies on PA_CC_DIST_LINES

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 680: FROM pa_cc_dist_lines

676:
677: maxrec.project_tp_currency_code,
678: maxrec.projfunc_tp_currency_code
679: /*end for cross proj*/
680: FROM pa_cc_dist_lines
681: WHERE expenditure_item_id = l_source_eid
682: AND line_type = G_BL_LINE_TYPE
683: AND line_num = (SELECT max(line_num)
684: FROM pa_cc_dist_lines

Line 684: FROM pa_cc_dist_lines

680: FROM pa_cc_dist_lines
681: WHERE expenditure_item_id = l_source_eid
682: AND line_type = G_BL_LINE_TYPE
683: AND line_num = (SELECT max(line_num)
684: FROM pa_cc_dist_lines
685: WHERE expenditure_item_id = l_source_eid
686: AND line_type = G_BL_LINE_TYPE);
687:
688: IF P_DEBUG_MODE = 'Y' THEN

Line 1908: DELETE FROM PA_CC_DIST_LINES

1904: log_message('4550: Mass deletion of distributions for ' || g_dcnt || ' records');
1905:
1906: FORALL i in 1..g_dcnt
1907:
1908: DELETE FROM PA_CC_DIST_LINES
1909: WHERE rowid = in_RowId(i);
1910:
1911: log_message('4600: -- Rows deleted = ' || to_char(sql%ROWCOUNT));
1912:

Line 1975: SELECT pa_cc_dist_lines_s.nextval

1971: -- Select the next line id into the in_ variable. This is done here
1972: -- and not directly in the INSERT statement because the line_id has to
1973: -- be passed to MRC
1974:
1975: SELECT pa_cc_dist_lines_s.nextval
1976: INTO in_cc_dist_line_id(i)
1977: FROM dual;
1978:
1979: in_expenditure_item_id(i) := g_ins_rec(i).expenditure_item_id;

Line 2059: INTO pa_cc_dist_lines

2055: log_message('5050: Performing insert for ' || to_char(g_icnt));
2056:
2057: FORALL i in 1..g_icnt
2058: INSERT
2059: INTO pa_cc_dist_lines
2060: (
2061: org_id ,
2062: cc_dist_line_id,
2063: expenditure_item_id,

Line 2389: UPDATE pa_cc_dist_lines

2385:
2386: log_message('5450: Updating for ' || to_char(g_ucnt));
2387:
2388: FORALL i in 1..g_ucnt
2389: UPDATE pa_cc_dist_lines
2390: SET
2391: reversed_flag =
2392: decode(in_upd_type(i), 'U', reversed_flag, 'Y'),
2393: acct_currency_code =