APPS.PA_CC_BL_PROCESS dependencies on PA_EXPENDITURE_ITEMS_ALL

Line 123: ,p_acct_currency_code IN OUT NOCOPY pa_expenditure_items_all.acct_currency_code%TYPE

119: PROCEDURE pa_bl_pr
120: (
121: p_module_name IN VARCHAR2
122: ,p_debug_mode IN VARCHAR2
123: ,p_acct_currency_code IN OUT NOCOPY pa_expenditure_items_all.acct_currency_code%TYPE
124: ,p_acct_tp_exchange_rate IN OUT NOCOPY PA_PLSQL_DATATYPES.char30tabtyp
125: ,p_acct_tp_rate_date IN OUT NOCOPY PA_PLSQL_DATATYPES.char30tabtyp
126: ,p_acct_tp_rate_type IN OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp
127: ,p_acct_transfer_price IN OUT NOCOPY PA_PLSQL_DATATYPES.char30tabtyp

Line 240: l_source_eid pa_expenditure_items_all.expenditure_item_id%TYPE;

236: l_reversal_reqd BOOLEAN;
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;

Line 557: from pa_expenditure_items_all ei,

553: select 1 into l_exists
554: from dual
555: where exists
556: ( select 'Reverse in future period net-zero pair'
557: from pa_expenditure_items_all ei,
558: pa_cost_distribution_lines_all cdl,
559: pa_cost_distribution_lines_all reversal_cdl,
560: -- Start Changes for bug 15892024
561: pa_expenditures_all exp,

Line 588: from pa_expenditure_items_all parent_ei,

584: select 1 into l_exists
585: from dual
586: where exists
587: ( select 'Reverse in future period net-zero pair'
588: from pa_expenditure_items_all parent_ei,
589: pa_cost_distribution_lines_all cdl,
590: pa_cost_distribution_lines_all parent_cdl,
591: -- Start Changes for bug 15892024
592: pa_expenditures_all exp,

Line 1452: pa_expenditure_items_all ei1,

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
1456: and ei2.adjusted_expenditure_item_id = ei1.expenditure_item_id

Line 1453: pa_expenditure_items_all ei2

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
1456: and ei2.adjusted_expenditure_item_id = ei1.expenditure_item_id
1457: and ccdl1.line_type = 'BL'

Line 1468: (select 1 from pa_expenditure_items_all ei

1464: where ccdl2.request_id = pa_cc_utils.g_request_id
1465: and ccdl2.dist_line_id_reversed is null
1466: and ccdl2.line_type = 'BL'
1467: and exists
1468: (select 1 from pa_expenditure_items_all ei
1469: where ei.expenditure_item_id = ccdl2.expenditure_item_id
1470: and ei.adjusted_expenditure_item_id is not null
1471: and ei.net_zero_adjustment_flag = 'Y'
1472: --and ei.PRVDR_ACCRUAL_DATE is not null

Line 2824: FROM pa_expenditure_items_all -- _ALL table used for better performance

2820: g_ei_rec(g_eicnt).upd_type := 'G';
2821:
2822: SELECT rowid
2823: INTO g_ei_rec(g_eicnt).EIRowId
2824: FROM pa_expenditure_items_all -- _ALL table used for better performance
2825: WHERE expenditure_item_id = lcur.adjusted_exp_item_id;
2826:
2827: IF P_DEBUG_MODE = 'Y' THEN
2828: log_message('update_ei: ' || '6100: Successfully got rowid of reversed EI');

Line 3001: UPDATE pa_expenditure_items_all --_All table for better performance

2997: IF g_eicnt > 0
2998: THEN
2999: FORALL i in 1..g_eicnt
3000:
3001: UPDATE pa_expenditure_items_all --_All table for better performance
3002: SET
3003: cc_rejection_code = in_cc_rejection_code(i),
3004: cc_bl_distributed_code = decode(in_cc_rejection_code(i), NULL,
3005: decode(cc_cross_charge_code, 'B', 'Y', 'X'), 'N'),