APPS.PA_XLA_INTERFACE_PKG dependencies on PA_CC_DIST_LINES_ALL

Line 549: from pa_cc_dist_lines_all cdl,

545: trunc(cdl.gl_date) gl_date,
546: NULL orig_historic,
547: NULL orig_dist_line_id,
548: NULL orig_acct_source
549: from pa_cc_dist_lines_all cdl,
550: pa_expenditure_items_all exp
551: where exp.expenditure_item_id = cdl.expenditure_item_id
552: and cdl.request_id = g_data_set_id
553: and cdl.transfer_status_code = 'X'

Line 569: from pa_cc_dist_lines_all cdl,

565: trunc(cdl.gl_date) gl_date,
566: nvl(pe.historical_flag, 'Y') orig_historic,
567: cd.cc_dist_line_id orig_dist_line_id,
568: cd.acct_source_code orig_acct_source
569: from pa_cc_dist_lines_all cdl,
570: pa_expenditure_items_all exp,
571: pa_expenditure_items_all pe,
572: pa_cc_dist_lines_all cd
573: where exp.expenditure_item_id = cdl.expenditure_item_id

Line 572: pa_cc_dist_lines_all cd

568: cd.acct_source_code orig_acct_source
569: from pa_cc_dist_lines_all cdl,
570: pa_expenditure_items_all exp,
571: pa_expenditure_items_all pe,
572: pa_cc_dist_lines_all cd
573: where exp.expenditure_item_id = cdl.expenditure_item_id
574: and cdl.request_id = g_data_set_id
575: and cdl.transfer_status_code = 'X'
576: and exp.adjusted_expenditure_item_id is not null

Line 593: from pa_cc_dist_lines_all cdl,

589: trunc(cdl.gl_date) gl_date,
590: NULL orig_historic,
591: cd.cc_dist_line_id orig_dist_line_id,
592: cd.acct_source_code orig_acct_source
593: from pa_cc_dist_lines_all cdl,
594: pa_expenditure_items_all exp,
595: pa_cc_dist_lines_all cd
596: where exp.expenditure_item_id = cdl.expenditure_item_id
597: and cdl.request_id = g_data_set_id

Line 595: pa_cc_dist_lines_all cd

591: cd.cc_dist_line_id orig_dist_line_id,
592: cd.acct_source_code orig_acct_source
593: from pa_cc_dist_lines_all cdl,
594: pa_expenditure_items_all exp,
595: pa_cc_dist_lines_all cd
596: where exp.expenditure_item_id = cdl.expenditure_item_id
597: and cdl.request_id = g_data_set_id
598: and cdl.transfer_status_code = 'X'
599: and cdl.dist_line_id_reversed is not null

Line 895: update pa_cc_dist_lines_all

891: and line_type = decode(t_line_type(i), 'B', line_type, t_line_type(i))
892: and request_id = g_data_set_id;
893: ELSIF g_calling_module in ('CC', 'PC', 'BL') THEN
894: FORALL i in t_entity_id.first..t_entity_id.last
895: update pa_cc_dist_lines_all
896: set acct_event_id = t_event_id(i),
897: acct_source_code = t_acct_source(i),
898: transferred_date = trunc(sysdate),
899: transfer_status_code = decode(t_tsc(i), 'G', 'G', 'A')

Line 919: update pa_cc_dist_lines_all

915: transfer_rejection_reason = 'Create Events API did not pick this line'
916: where transfer_status_code = 'X'
917: and request_id = g_data_set_id;
918: elsif g_calling_module in ('CC', 'PC', 'BL') then
919: update pa_cc_dist_lines_all
920: set transfer_status_code = 'R',
921: transfer_rejection_code = 'Create Events API did not pick this line'
922: where transfer_status_code = 'X'
923: and request_id = g_data_set_id;