APPS.PA_XLA_SWEEP_TXN_PKG dependencies on PA_COST_DISTRIBUTION_LINES_ALL

Line 145: Update PA_COST_DISTRIBUTION_LINES_ALL

141: End If;
142:
143: If NVL(P_TRAN_TYPE,'EXPENDITURES') = 'EXPENDITURES' Then
144: FORALL i IN 1..g_event_tab.count
145: Update PA_COST_DISTRIBUTION_LINES_ALL
146: SET TRANSFER_STATUS_CODE = 'X' ,
147: Request_Id = g_request_id
148: Where Acct_Event_ID = g_event_tab(i);
149:

Line 250: pa_cost_distribution_lines_all cdl,

246: ei.projfunc_cost_rate_type,
247: ei.projfunc_cost_exchange_rate,
248: ei.work_type_id
249: FROM pa_expenditure_items_all ei,
250: pa_cost_distribution_lines_all cdl,
251: pa_transaction_sources tr
252: WHERE tr.transaction_source(+) = ei.transaction_source
253: AND ei.expenditure_item_id = cdl.expenditure_item_id
254: AND CDL.Transfer_Status_Code = 'Y'

Line 279: From PA_Cost_Distribution_lines_ALL CDL,

275: ei.document_header_id ,
276: ei.document_distribution_id ,
277: ei.expenditure_type ,
278: cdl.Acct_Event_ID
279: From PA_Cost_Distribution_lines_ALL CDL,
280: PA_Expenditure_items_all EI,
281: PA_IMPLEMENTATIONS_ALL IMP ,
282: PA_EXPENDITURES_ALL EXP ,
283: PA_EXPENDITURE_GROUPS_ALL EXP_GRP

Line 372: UPDATE PA_Cost_Distribution_lines_ALL CDL

368:
369: log_message ('Updating CDLs with TSC = A if Not Summarised, Y if Summarised');
370:
371: FORALL i IN 1..g_expenditure_item_id.count
372: UPDATE PA_Cost_Distribution_lines_ALL CDL
373: SET CDL.request_id = g_request_id,
374: CDL.transfer_status_code = DECODE(g_gl_date_new_tab(i),
375: NULL,'R', DECODE(g_recvr_gl_date_new_tab(i)
376: ,NULL,'R',

Line 450: UPDATE PA_Cost_Distribution_lines_ALL CDL

446: End Loop;
447:
448:
449: FORALL i IN 1..g_expenditure_item_id.count
450: UPDATE PA_Cost_Distribution_lines_ALL CDL
451: SET CDL.request_id = g_request_id
452: ,CDL.transfer_status_code = 'A'
453: ,CDL.gl_date = nvl(g_gl_date_new_tab(i),CDL.gl_date)
454: ,CDL.gl_period_name = nvl(g_gl_period_new_tab(i),CDL.gl_period_name)

Line 523: l_billable_flag pa_cost_distribution_lines_all.billable_flag%type;

519: l_exp_item_id pa_expenditure_items_all.expenditure_item_id%type;
520: l_gl_date DATE;
521: l_pji_summarized_flag VARCHAR2(1);
522: l_prvdr_accr_date DATE;
523: l_billable_flag pa_cost_distribution_lines_all.billable_flag%type;
524: l_line_type VARCHAR2(1);
525: l_line_num NUMBER ;
526: l_denom_currency_code pa_expenditure_items_all.denom_currency_code%type;
527: l_acct_currency_code pa_expenditure_items_all.acct_currency_code%type;

Line 542: l_acct_event_id pa_cost_distribution_lines_all.acct_event_id%type;

538: l_projfunc_cost_exchange_rate pa_expenditure_items_all.projfunc_cost_exchange_rate%type;
539: l_work_type_id pa_expenditure_items_all.work_type_id%type;
540:
541:
542: l_acct_event_id pa_cost_distribution_lines_all.acct_event_id%type;
543: l_transfer_status_Code pa_cost_distribution_lines_all.transfer_status_code%type;
544: l_accr_period_name pa_cost_distribution_lines_all.gl_period_name%type;
545:
546: l_err_code NUMBER ;

Line 543: l_transfer_status_Code pa_cost_distribution_lines_all.transfer_status_code%type;

539: l_work_type_id pa_expenditure_items_all.work_type_id%type;
540:
541:
542: l_acct_event_id pa_cost_distribution_lines_all.acct_event_id%type;
543: l_transfer_status_Code pa_cost_distribution_lines_all.transfer_status_code%type;
544: l_accr_period_name pa_cost_distribution_lines_all.gl_period_name%type;
545:
546: l_err_code NUMBER ;
547: l_err_stage VARCHAR2(2000);

Line 544: l_accr_period_name pa_cost_distribution_lines_all.gl_period_name%type;

540:
541:
542: l_acct_event_id pa_cost_distribution_lines_all.acct_event_id%type;
543: l_transfer_status_Code pa_cost_distribution_lines_all.transfer_status_code%type;
544: l_accr_period_name pa_cost_distribution_lines_all.gl_period_name%type;
545:
546: l_err_code NUMBER ;
547: l_err_stage VARCHAR2(2000);
548: l_err_stack VARCHAR2(255) ;

Line 605: FROM PA_COST_DISTRIBUTION_LINES_ALL CDL,

601: l_work_type_id,
602: l_acct_event_id,
603: l_transfer_status_code,
604: l_org_id
605: FROM PA_COST_DISTRIBUTION_LINES_ALL CDL,
606: PA_EXPENDITURE_ITEMS_ALL EI
607: WHERE CDL.EXPENDITURE_ITEM_ID = EI.EXPENDITURE_ITEM_ID
608: AND EI.ADJUSTED_EXPENDITURE_ITEM_ID = g_expenditure_item_id(g_currec);
609:

Line 641: UPDATE PA_Cost_Distribution_lines_ALL CDL

637: ' re-derived with ' || l_prvdr_accr_date );
638:
639: IF (l_pji_summarized_flag = 'N') THEN
640:
641: UPDATE PA_Cost_Distribution_lines_ALL CDL
642: SET CDL.gl_date = l_prvdr_accr_date
643: WHERE CDL.EXPENDITURE_ITEM_ID = l_exp_item_id;
644:
645:

Line 696: UPDATE PA_Cost_Distribution_lines_ALL CDL

692: l_accr_period_name := pa_utils2.get_gl_period_name (l_prvdr_accr_date,l_org_id);
693:
694:
695:
696: UPDATE PA_Cost_Distribution_lines_ALL CDL
697: SET CDL.GL_DATE = l_prvdr_accr_date,
698: CDL.GL_PERIOD_NAME = l_accr_period_name
699: WHERE CDL.EXPENDITURE_ITEM_ID = l_exp_item_id
700: AND CDL.LINE_NUM_REVERSED IS NULL