eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PA_FUNDS_CONTROL_PKG1 dependencies on PSA_BC_XLA_EVENTS_GT

Line 2584: -- 1. Driving table for this procedure is psa_bc_xla_events_gt .Picks all AP/PO/REQ events

2580: -- R12 Funds Management Uptake --rshaik
2581: -- ----------------------------
2582: -- Called from PSA_BC_XLA_PVT.Budgetary_control after creating events for AP/PO/REQ.
2583: -- and before It performs following tasks :
2584: -- 1. Driving table for this procedure is psa_bc_xla_events_gt .Picks all AP/PO/REQ events
2585: -- created by BCPSA FC engine.
2586: -- 2. Inserts raw records into pa_bc_packets by fetching PO/REQ data from po_bc_distributions
2587: -- and AP data from ap_invoice_distributions_all table for all events in psa_bc_xla_events_gt.
2588: -- 3. Fires populate_burden_cost procedure to Insert burden records for above raw components

Line 2587: -- and AP data from ap_invoice_distributions_all table for all events in psa_bc_xla_events_gt.

2583: -- and before It performs following tasks :
2584: -- 1. Driving table for this procedure is psa_bc_xla_events_gt .Picks all AP/PO/REQ events
2585: -- created by BCPSA FC engine.
2586: -- 2. Inserts raw records into pa_bc_packets by fetching PO/REQ data from po_bc_distributions
2587: -- and AP data from ap_invoice_distributions_all table for all events in psa_bc_xla_events_gt.
2588: -- 3. Fires populate_burden_cost procedure to Insert burden records for above raw components
2589: -- 4. Fires pa_funds_control_pkg.derive_rlmi to derive resource_list_member_id on bc packets
2590: -- 5. Fires pa_funds_control_utils.get_budegt_ccid to derive budget_ccid and budget_line_id
2591: -- 6. Finally calls pa_xla_interface_pkg.create_events to create events for project

Line 2684: psa_bc_xla_events_gt xlaevt

2680: pobc.applied_to_dist_id_2,
2681: pa_bc_packets_s.nextval bc_packet_id -- Bug 5406690
2682: FROM po_bc_distributions pobc ,
2683: po_encumbrance_gt pogt,
2684: psa_bc_xla_events_gt xlaevt
2685: WHERE pobc.ae_event_id = xlaevt.event_id
2686: AND pobc.pa_project_id IS NOT NULL
2687: AND pogt.distribution_id = pobc.distribution_id
2688: AND pogt.distribution_type = pobc.distribution_type

Line 2734: psa_bc_xla_events_gt xlaevt,

2730: DECODE(apd.line_type_lookup_code -- Bug 5490378
2731: ,'NONREC_TAX',DECODE(apd.prepay_distribution_id,NULL,apd.line_type_lookup_code,'PREPAY')
2732: ,apd.line_type_lookup_code)
2733: FROM ap_invoice_distributions_all apd ,
2734: psa_bc_xla_events_gt xlaevt,
2735: ap_invoices_all apinv
2736: WHERE apd.bc_event_id = xlaevt.event_id
2737: AND apd.project_id IS NOT NULL
2738: AND NVL(apd.pa_addition_flag, 'X' ) <> 'T'

Line 2805: psa_bc_xla_events_gt xlaevt,

2801: DECODE(apd.line_type_lookup_code
2802: ,'NONREC_TAX',DECODE(apd.prepay_distribution_id,NULL,decode(apd.line_type_lookup_code,'NONREC_TAX','SELF_ASSESSED_TAX',apd.line_type_lookup_code),'PREPAY')
2803: ,decode(apd.line_type_lookup_code,'NONREC_TAX','SELF_ASSESSED_TAX',apd.line_type_lookup_code))
2804: FROM ap_self_assessed_tax_dist_all apd ,
2805: psa_bc_xla_events_gt xlaevt,
2806: ap_invoices_all apinv
2807: WHERE apd.bc_event_id = xlaevt.event_id
2808: AND apd.project_id IS NOT NULL
2809: AND NVL(apd.pa_addition_flag, 'X' ) <> 'T'

Line 3079: PSA_BC_XLA_EVENTS_GT PBXEG -- Added for bug 14752984

3075: AND AID.ORG_ID = FSP.ORG_ID
3076: AND aid.set_of_books_id = asp.set_of_books_id
3077: AND aid.org_id = asp.org_id
3078: ) apext ,
3079: PSA_BC_XLA_EVENTS_GT PBXEG -- Added for bug 14752984
3080: WHERE apext.aid_invoice_dist_id IN (select Column_Value from Table(g_ap_inv_dist_id))
3081: /*AND apext.event_id in ( SELECT event_id FROM psa_bc_xla_events_gt) removed the existing inline view and added below join*/
3082: AND apext.event_id = PBXEG.EVENT_ID -- Added for bug 14752984
3083: AND (p_bc_mode ='C'

Line 3081: /AND apext.event_id in ( SELECT event_id FROM psa_bc_xla_events_gt) removed the existing inline view and added below join/

3077: AND aid.org_id = asp.org_id
3078: ) apext ,
3079: PSA_BC_XLA_EVENTS_GT PBXEG -- Added for bug 14752984
3080: WHERE apext.aid_invoice_dist_id IN (select Column_Value from Table(g_ap_inv_dist_id))
3081: /*AND apext.event_id in ( SELECT event_id FROM psa_bc_xla_events_gt) removed the existing inline view and added below join*/
3082: AND apext.event_id = PBXEG.EVENT_ID -- Added for bug 14752984
3083: AND (p_bc_mode ='C'
3084: OR (apext.aid_line_type_lookup_code <> 'PREPAY' AND p_bc_mode <>'C')) -- Bug 5238282
3085: AND NOT EXISTS ( --Bug 5490378 : Filter out Tax associated with prepay lines for reserve action

Line 3103: SELECT /+ leading(PSA_BC_XLA_EVENTS_GT) cardinality(PSA_BC_XLA_EVENTS_GT,1) / NULL budget_version_id, -- Added for bug 14752984

3099: AND p_bc_mode <> 'C'
3100: AND apd2.line_type_lookup_code = 'PREPAY')
3101: AND p_stdinvoice_exists = 'Y'
3102: UNION ALL
3103: SELECT /*+ leading(PSA_BC_XLA_EVENTS_GT) cardinality(PSA_BC_XLA_EVENTS_GT,1) */ NULL budget_version_id, -- Added for bug 14752984
3104: NULL budget_line_id,
3105: NULL budget_ccid,
3106: AID.project_id project_id,
3107: AID.task_id task_id,

Line 3159: PSA_BC_XLA_EVENTS_GT PBXEG, --Added for bug 14752984

3155: WHERE encumbrance_type_KEY = 'Invoices') encumbrance_type_id,
3156: AID.PERIOD_NAME period_name,
3157: AID.parent_reversal_id parent_reversal_id -- Bug 5406690
3158: FROM AP_PREPAY_HISTORY_ALL APPH,
3159: PSA_BC_XLA_EVENTS_GT PBXEG, --Added for bug 14752984
3160: AP_PREPAY_APP_DISTS APAD,
3161: AP_INVOICE_LINES_ALL AIL,
3162: AP_INVOICE_DISTRIBUTIONS_ALL AID
3163: WHERE AID.bc_event_id = APPH.bc_Event_id

Line 3168: /* and APPH.bc_Event_id IN ( SELECT event_id FROM psa_bc_xla_events_gt)removed the inline view for bug 14752984 and added below join */

3164: AND APPH.prepay_history_id = APAD.prepay_history_id
3165: AND AID.invoice_line_number = AIL.line_number
3166: AND AID.invoice_id = AIL.invoice_id
3167: AND AID.line_type_lookup_code IN ( 'PREPAY' ,'NONREC_TAX' ) --Bug 5490378
3168: /* and APPH.bc_Event_id IN ( SELECT event_id FROM psa_bc_xla_events_gt)removed the inline view for bug 14752984 and added below join */
3169: and AID.invoice_distribution_id IN (select Column_Value from Table(g_ap_inv_dist_id))
3170: AND APPH.bc_Event_id = PBXEG.event_id --Added for bug 14752984
3171: AND p_prepay_exists = 'Y'
3172: and aid.invoice_distribution_id = apad.prepay_app_distribution_id

Line 3231: and APPH.bc_Event_id IN ( SELECT event_id FROM psa_bc_xla_events_gt)

3227: AND APPH.prepay_history_id = APAD.prepay_history_id
3228: AND AID.invoice_line_number = AIL.line_number
3229: AND AID.invoice_id = AIL.invoice_id
3230: AND AID.line_type_lookup_code IN ( 'PREPAY' ,'NONREC_TAX' )
3231: and APPH.bc_Event_id IN ( SELECT event_id FROM psa_bc_xla_events_gt)
3232: and AID.invoice_distribution_id IN (select Column_Value from Table(g_ap_inv_dist_id))
3233: AND p_prepay_exists = 'Y'
3234: and aid.invoice_distribution_id = apad.prepay_app_distribution_id;
3235:

Line 8187: FROM PSA_BC_XLA_EVENTS_GT b;

8183: PROCEDURE TIEBACK_FAILED_ACCT_STATUS (p_bc_mode IN VARCHAR2 DEFAULT 'C') IS
8184:
8185: CURSOR C_PRINT_EVENT_STATUS IS
8186: SELECT event_id, b.result_code
8187: FROM PSA_BC_XLA_EVENTS_GT b;
8188:
8189: BEGIN
8190:
8191: If pa_funds_control_pkg.g_debug_mode = 'Y' then

Line 8225: FROM PSA_BC_XLA_EVENTS_GT

8221: result_code = DECODE(substr(result_code,1,1),'F',result_code,'F172')
8222: WHERE status_code in ('P','I','A','S')
8223: AND source_event_id IN
8224: (SELECT event_id
8225: FROM PSA_BC_XLA_EVENTS_GT
8226: WHERE upper(result_code) in ('XLA_ERROR','FATAL','XLA_UNPROCESSED','XLA_NO_JOURNAL'));
8227:
8228: UPDATE pa_bc_packets a
8229: SET status_code = DECODE(p_bc_mode,'C','F','R'),

Line 8234: FROM PSA_BC_XLA_EVENTS_GT

8230: result_code = DECODE(substr(result_code,1,1),'F',result_code,'F172')
8231: WHERE status_code in ('P','I','A','S')
8232: AND bc_event_id IN
8233: (SELECT event_id
8234: FROM PSA_BC_XLA_EVENTS_GT
8235: WHERE upper(result_code) in ('XLA_ERROR','FATAL','XLA_UNPROCESSED','XLA_NO_JOURNAL'));
8236:
8237: IF pa_funds_control_pkg.g_debug_mode = 'Y' THEN
8238: pa_funds_control_pkg.log_message(p_msg_token1 => 'TIEBACK_FAILED_ACCT_STATUS : End ');

Line 9178: psa_bc_xla_events_gt pbgt,

9174: NULL ,
9175: NULL
9176: FROM igc_cc_interface igc,
9177: igc_cc_headers_all igchead,
9178: psa_bc_xla_events_gt pbgt,
9179: gl_period_statuses glp
9180: WHERE pbgt.event_id = igc.event_id
9181: and igc.cc_header_id = igchead.cc_header_id
9182: and igc.budget_dest_flag = 'S'