APPS.PA_XLA_INTERFACE_PKG dependencies on PA_CC_DIST_LINES_ALL

Line 544: from pa_cc_dist_lines_all cdl,

540: trunc(cdl.gl_date) gl_date,
541: NULL orig_historic,
542: NULL orig_dist_line_id,
543: NULL orig_acct_source
544: from pa_cc_dist_lines_all cdl,
545: pa_expenditure_items_all exp
546: where exp.expenditure_item_id = cdl.expenditure_item_id
547: and cdl.request_id = g_data_set_id
548: and cdl.transfer_status_code = 'X'

Line 564: from pa_cc_dist_lines_all cdl,

560: trunc(cdl.gl_date) gl_date,
561: nvl(pe.historical_flag, 'Y') orig_historic,
562: cd.cc_dist_line_id orig_dist_line_id,
563: cd.acct_source_code orig_acct_source
564: from pa_cc_dist_lines_all cdl,
565: pa_expenditure_items_all exp,
566: pa_expenditure_items_all pe,
567: pa_cc_dist_lines_all cd
568: where exp.expenditure_item_id = cdl.expenditure_item_id

Line 567: pa_cc_dist_lines_all cd

563: cd.acct_source_code orig_acct_source
564: from pa_cc_dist_lines_all cdl,
565: pa_expenditure_items_all exp,
566: pa_expenditure_items_all pe,
567: pa_cc_dist_lines_all cd
568: where exp.expenditure_item_id = cdl.expenditure_item_id
569: and cdl.request_id = g_data_set_id
570: and cdl.transfer_status_code = 'X'
571: and exp.adjusted_expenditure_item_id is not null

Line 588: from pa_cc_dist_lines_all cdl,

584: trunc(cdl.gl_date) gl_date,
585: NULL orig_historic,
586: cd.cc_dist_line_id orig_dist_line_id,
587: cd.acct_source_code orig_acct_source
588: from pa_cc_dist_lines_all cdl,
589: pa_expenditure_items_all exp,
590: pa_cc_dist_lines_all cd
591: where exp.expenditure_item_id = cdl.expenditure_item_id
592: and cdl.request_id = g_data_set_id

Line 590: pa_cc_dist_lines_all cd

586: cd.cc_dist_line_id orig_dist_line_id,
587: cd.acct_source_code orig_acct_source
588: from pa_cc_dist_lines_all cdl,
589: pa_expenditure_items_all exp,
590: pa_cc_dist_lines_all cd
591: where exp.expenditure_item_id = cdl.expenditure_item_id
592: and cdl.request_id = g_data_set_id
593: and cdl.transfer_status_code = 'X'
594: and cdl.dist_line_id_reversed is not null

Line 887: update pa_cc_dist_lines_all

883: and line_type = decode(t_line_type(i), 'B', line_type, t_line_type(i))
884: and request_id = g_data_set_id;
885: ELSIF g_calling_module in ('CC', 'PC', 'BL') THEN
886: FORALL i in t_entity_id.first..t_entity_id.last
887: update pa_cc_dist_lines_all
888: set acct_event_id = t_event_id(i),
889: acct_source_code = t_acct_source(i),
890: transferred_date = trunc(sysdate),
891: transfer_status_code = decode(t_tsc(i), 'G', 'G', 'A')

Line 911: update pa_cc_dist_lines_all

907: transfer_rejection_reason = 'Create Events API did not pick this line'
908: where transfer_status_code = 'X'
909: and request_id = g_data_set_id;
910: elsif g_calling_module in ('CC', 'PC', 'BL') then
911: update pa_cc_dist_lines_all
912: set transfer_status_code = 'R',
913: transfer_rejection_code = 'Create Events API did not pick this line'
914: where transfer_status_code = 'X'
915: and request_id = g_data_set_id;