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.PSA_AP_BC_PVT dependencies on XLA_EVENTS

Line 18: ) RETURN XLA_EVENTS_PUB_PKG.T_SECURITY;

14: FUNCTION get_event_security_context
15: (
16: p_org_id IN NUMBER,
17: p_calling_sequence IN VARCHAR2
18: ) RETURN XLA_EVENTS_PUB_PKG.T_SECURITY;
19:
20: FUNCTION get_event_type_code
21: (
22: p_inv_dist_id IN NUMBER,

Line 73: FROM xla_events xla,

69: xte.source_id_int_2,
70: xte.source_id_int_3,
71: xte.source_id_int_4,
72: xte.source_id_char_1
73: FROM xla_events xla,
74: xla_transaction_entities xte
75: WHERE NVL(xla.budgetary_control_flag, 'N') ='Y'
76: AND xla.application_id = 200
77: AND xte.entity_code = 'AP_INVOICES'

Line 85: TYPE Event_tab_type IS TABLE OF XLA_EVENTS_INT_GT%ROWTYPE INDEX BY BINARY_INTEGER;

81: AND xla.entity_id = xte.entity_id
82: AND xla.application_id = xte.application_id
83: AND xte.ledger_id = p_ledger_id;
84:
85: TYPE Event_tab_type IS TABLE OF XLA_EVENTS_INT_GT%ROWTYPE INDEX BY BINARY_INTEGER;
86: l_events_Tab Event_tab_type;
87: l_event_count NUMBER;
88:
89: l_curr_calling_sequence VARCHAR2(2000);

Line 94: l_event_source_info xla_events_pub_pkg.t_event_source_info;

90: l_log_msg FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;
91: l_debug_loc VARCHAR2(30) := 'Delete_Events';
92: l_api_name VARCHAR2(240);
93:
94: l_event_source_info xla_events_pub_pkg.t_event_source_info;
95: l_valuation_method VARCHAR2(30);
96: l_security_context xla_events_pub_pkg.t_security;
97: l_return_status VARCHAR2(1);
98:

Line 96: l_security_context xla_events_pub_pkg.t_security;

92: l_api_name VARCHAR2(240);
93:
94: l_event_source_info xla_events_pub_pkg.t_event_source_info;
95: l_valuation_method VARCHAR2(30);
96: l_security_context xla_events_pub_pkg.t_security;
97: l_return_status VARCHAR2(1);
98:
99: BEGIN
100: fnd_file.put_line(fnd_file.log ,'>> PSA_AP_BC_PVT.Delete_EVENTS');

Line 116: DELETE FROM XLA_EVENTS_INT_GT;

112: --setting xla security context to use table xla_transaction_entity
113:
114: xla_security_pkg.set_security_context(602); --passing SLA application_id
115:
116: DELETE FROM XLA_EVENTS_INT_GT;
117: psa_utils.debug_other_string(g_state_level,l_api_name, '# Rows deleted from xla_events_int_gt'|| SQL%ROWCOUNT );
118:
119: l_event_count := 0;
120: FOR rec_events IN c_get_unprocessed_events

Line 117: psa_utils.debug_other_string(g_state_level,l_api_name, '# Rows deleted from xla_events_int_gt'|| SQL%ROWCOUNT );

113:
114: xla_security_pkg.set_security_context(602); --passing SLA application_id
115:
116: DELETE FROM XLA_EVENTS_INT_GT;
117: psa_utils.debug_other_string(g_state_level,l_api_name, '# Rows deleted from xla_events_int_gt'|| SQL%ROWCOUNT );
118:
119: l_event_count := 0;
120: FOR rec_events IN c_get_unprocessed_events
121: LOOP

Line 138: INSERT INTO XLA_EVENTS_INT_GT

134:
135: IF l_event_count > 0 THEN
136:
137: FORALL i IN 1..l_event_count
138: INSERT INTO XLA_EVENTS_INT_GT
139: VALUES l_events_tab(i) ;
140:
141: psa_utils.debug_other_string(g_state_level,l_api_name,' # Rows inserted into xla_events_int_gt table:' || l_event_count);
142: psa_utils.debug_other_string(g_state_level,l_api_name,'Calling XLA_EVENTS_PUB_PKG.DELETE_BULK_EVENT ');

Line 141: psa_utils.debug_other_string(g_state_level,l_api_name,' # Rows inserted into xla_events_int_gt table:' || l_event_count);

137: FORALL i IN 1..l_event_count
138: INSERT INTO XLA_EVENTS_INT_GT
139: VALUES l_events_tab(i) ;
140:
141: psa_utils.debug_other_string(g_state_level,l_api_name,' # Rows inserted into xla_events_int_gt table:' || l_event_count);
142: psa_utils.debug_other_string(g_state_level,l_api_name,'Calling XLA_EVENTS_PUB_PKG.DELETE_BULK_EVENT ');
143:
144: XLA_EVENTS_PUB_PKG.DELETE_BULK_EVENTS(p_application_id => 200);
145:

Line 142: psa_utils.debug_other_string(g_state_level,l_api_name,'Calling XLA_EVENTS_PUB_PKG.DELETE_BULK_EVENT ');

138: INSERT INTO XLA_EVENTS_INT_GT
139: VALUES l_events_tab(i) ;
140:
141: psa_utils.debug_other_string(g_state_level,l_api_name,' # Rows inserted into xla_events_int_gt table:' || l_event_count);
142: psa_utils.debug_other_string(g_state_level,l_api_name,'Calling XLA_EVENTS_PUB_PKG.DELETE_BULK_EVENT ');
143:
144: XLA_EVENTS_PUB_PKG.DELETE_BULK_EVENTS(p_application_id => 200);
145:
146: psa_utils.debug_other_string(g_state_level,l_api_name,'After Deletion of Unprocessed Events');

Line 144: XLA_EVENTS_PUB_PKG.DELETE_BULK_EVENTS(p_application_id => 200);

140:
141: psa_utils.debug_other_string(g_state_level,l_api_name,' # Rows inserted into xla_events_int_gt table:' || l_event_count);
142: psa_utils.debug_other_string(g_state_level,l_api_name,'Calling XLA_EVENTS_PUB_PKG.DELETE_BULK_EVENT ');
143:
144: XLA_EVENTS_PUB_PKG.DELETE_BULK_EVENTS(p_application_id => 200);
145:
146: psa_utils.debug_other_string(g_state_level,l_api_name,'After Deletion of Unprocessed Events');
147: fnd_file.put_line(fnd_file.log ,'The following BC unprocessed/Error events have been deleted');
148: fnd_file.put_line(fnd_file.log ,'Event_id Event_status_code Process_status_code');

Line 225: l_event_source_info xla_events_pub_pkg.t_event_source_info;

221: p_msg_count OUT NOCOPY NUMBER,
222: p_msg_data OUT NOCOPY VARCHAR2
223: )
224: IS
225: l_event_source_info xla_events_pub_pkg.t_event_source_info;
226: l_valuation_method VARCHAR2(30);
227: l_path_name VARCHAR2(500);
228: l_curr_calling_sequence VARCHAR2(2000);
229: l_security_context xla_events_pub_pkg.t_security;

Line 229: l_security_context xla_events_pub_pkg.t_security;

225: l_event_source_info xla_events_pub_pkg.t_event_source_info;
226: l_valuation_method VARCHAR2(30);
227: l_path_name VARCHAR2(500);
228: l_curr_calling_sequence VARCHAR2(2000);
229: l_security_context xla_events_pub_pkg.t_security;
230: l_curr_invoice_id NUMBER := -1;
231: l_curr_org_id NUMBER := -1;
232: l_event_status_code xla_events.event_status_code%TYPE;
233: l_entity_ret_code INTEGER;

Line 232: l_event_status_code xla_events.event_status_code%TYPE;

228: l_curr_calling_sequence VARCHAR2(2000);
229: l_security_context xla_events_pub_pkg.t_security;
230: l_curr_invoice_id NUMBER := -1;
231: l_curr_org_id NUMBER := -1;
232: l_event_status_code xla_events.event_status_code%TYPE;
233: l_entity_ret_code INTEGER;
234: BEGIN
235: l_path_name := g_full_path || '.delete_unprocessed_events';
236: p_return_status := Fnd_Api.G_Ret_Sts_Success;

Line 267: FROM xla_events e

263: BEGIN
264: l_event_status_code := NULL;
265: SELECT event_status_code
266: INTO l_event_status_code
267: FROM xla_events e
268: WHERE event_id = p_tab_fc_dist(i).bc_event_id;
269: EXCEPTION
270: WHEN NO_DATA_FOUND THEN
271: psa_utils.debug_other_string(g_state_level,l_path_name, 'No such BC event in XLA' );

Line 277: xla_events_pub_pkg.delete_event

273:
274: psa_utils.debug_other_string(g_state_level,l_path_name, 'l_event_status_code='||l_event_status_code );
275: IF (l_event_status_code = 'U') THEN
276: psa_utils.debug_other_string(g_state_level,l_path_name, 'Deleting Event:'||p_tab_fc_dist(i).bc_event_id);
277: xla_events_pub_pkg.delete_event
278: (
279: p_event_source_info => l_event_source_info,
280: p_event_id => p_tab_fc_dist(i).bc_event_id,
281: p_valuation_method => l_valuation_method,

Line 316: FROM xla_events e,

312: /* Delete the orphan events per Invoice Id*/
313: IF (l_curr_invoice_id <> p_tab_fc_dist(i).invoice_id) THEN
314: psa_utils.debug_other_string(g_state_level,l_path_name, 'Deleting Orphan Events');
315: FOR event_rec IN (SELECT e.*
316: FROM xla_events e,
317: xla_transaction_entities t
318: WHERE e.entity_id = t.entity_id
319: AND t.application_id = 200
320: AND t.entity_code = l_event_source_info.entity_type_code

Line 332: xla_events_pub_pkg.delete_event

328: psa_utils.debug_other_string(g_state_level,l_path_name, 'Found Event Id = '||event_rec.event_id);
329: psa_utils.debug_other_string(g_state_level,l_path_name, 'process_status_code = '||event_rec.process_status_code);
330: IF (event_rec.event_status_code = 'U') THEN
331: psa_utils.debug_other_string(g_state_level,l_path_name, 'Deleting the event');
332: xla_events_pub_pkg.delete_event
333: (
334: p_event_source_info => l_event_source_info,
335: p_event_id => event_rec.event_id,
336: p_valuation_method => l_valuation_method,

Line 431: FROM xla_events xe,

427: NVL(xe.budgetary_control_flag, 'N') BUDGETARY_CONTROL_FLAG ,
428: xah.accounting_date ACCOUNTING_DATE ,
429: xah.ledger_id,
430: ai.org_id
431: FROM xla_events xe,
432: xla_ae_headers xah,
433: xla_transaction_entities xt,
434: ap_invoices_all ai
435: WHERE xe.application_id = 200

Line 562: DELETE FROM xla_events

558: DELETE gl_bc_packets
559: WHERE event_id = orphan_event_rec.event_id;
560: psa_utils.debug_other_string(g_state_level,l_path_name, 'Deleting the gl_bc_packets'|| sql%rowcount);
561:
562: DELETE FROM xla_events
563: WHERE event_id = orphan_event_rec.event_id;
564: psa_utils.debug_other_string(g_state_level,l_path_name, 'Deleting the xla_events'|| sql%rowcount);
565:
566: DELETE FROM xla_trial_balances

Line 564: psa_utils.debug_other_string(g_state_level,l_path_name, 'Deleting the xla_events'|| sql%rowcount);

560: psa_utils.debug_other_string(g_state_level,l_path_name, 'Deleting the gl_bc_packets'|| sql%rowcount);
561:
562: DELETE FROM xla_events
563: WHERE event_id = orphan_event_rec.event_id;
564: psa_utils.debug_other_string(g_state_level,l_path_name, 'Deleting the xla_events'|| sql%rowcount);
565:
566: DELETE FROM xla_trial_balances
567: WHERE ae_header_id = orphan_event_rec.ae_header_id;
568: psa_utils.debug_other_string(g_state_level,l_path_name, 'Deleting the xla_trial_balance'|| sql%rowcount);

Line 643: FROM ap_invoice_distributions_all aid, xla_events xe

639: (
640: p_prepayapply_dist_id NUMBER
641: ) IS
642: SELECT 'Y'
643: FROM ap_invoice_distributions_all aid, xla_events xe
644: WHERE aid.invoice_distribution_id=p_prepayapply_dist_id
645: AND aid.bc_event_id = xe.event_id
646: AND xe.event_status_code = 'P'
647: AND xe.application_id = 200;

Line 700: TYPE BC_Event_tab_type IS TABLE OF xla_events%rowtype

696: l_curr_calling_sequence VARCHAR2(2000);
697: l_log_msg FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;
698: l_debug_loc VARCHAR2(30) := 'Create_Events';
699:
700: TYPE BC_Event_tab_type IS TABLE OF xla_events%rowtype
701: INDEX BY BINARY_INTEGER;
702:
703: l_bc_event_tab BC_Event_tab_type;
704: l_api_name VARCHAR2(240);

Line 711: l_event_source_info xla_events_pub_pkg.t_event_source_info;

707: l_event_type_code VARCHAR2(30);
708: l_event_date DATE;
709: l_event_status_code VARCHAR2(30);
710: l_event_number NUMBER;
711: l_event_source_info xla_events_pub_pkg.t_event_source_info;
712: l_reference_info xla_events_pub_pkg.t_event_reference_info;
713: l_valuation_method VARCHAR2(30);
714: l_security_context xla_events_pub_pkg.t_security;
715: l_event_check BOOLEAN;

Line 712: l_reference_info xla_events_pub_pkg.t_event_reference_info;

708: l_event_date DATE;
709: l_event_status_code VARCHAR2(30);
710: l_event_number NUMBER;
711: l_event_source_info xla_events_pub_pkg.t_event_source_info;
712: l_reference_info xla_events_pub_pkg.t_event_reference_info;
713: l_valuation_method VARCHAR2(30);
714: l_security_context xla_events_pub_pkg.t_security;
715: l_event_check BOOLEAN;
716: l_process_dist BOOLEAN;

Line 714: l_security_context xla_events_pub_pkg.t_security;

710: l_event_number NUMBER;
711: l_event_source_info xla_events_pub_pkg.t_event_source_info;
712: l_reference_info xla_events_pub_pkg.t_event_reference_info;
713: l_valuation_method VARCHAR2(30);
714: l_security_context xla_events_pub_pkg.t_security;
715: l_event_check BOOLEAN;
716: l_process_dist BOOLEAN;
717: l_encum_flag VARCHAR2(1);
718: l_parent_reversal_id ap_invoice_distributions_all.parent_reversal_id%TYPE;

Line 802: DELETE from psa_bc_xla_events_gt;

798:
799: ----------------------------------------------------------------------
800: -- Bug 5160179: clear the temporary gt table before inserting any rows
801: ----------------------------------------------------------------------
802: DELETE from psa_bc_xla_events_gt;
803: psa_utils.debug_other_string(g_state_level,l_api_name,'Number of rows deleted of psa_bc_xla_events_gt: ' || SQL%ROWCOUNT);
804: DELETE from xla_acct_prog_events_gt;
805: psa_utils.debug_other_string(g_state_level,l_api_name,'Number of rows deleted of xla_acct_prog_events_gt: ' || SQL%ROWCOUNT);
806: DELETE from xla_ae_headers_gt;

Line 803: psa_utils.debug_other_string(g_state_level,l_api_name,'Number of rows deleted of psa_bc_xla_events_gt: ' || SQL%ROWCOUNT);

799: ----------------------------------------------------------------------
800: -- Bug 5160179: clear the temporary gt table before inserting any rows
801: ----------------------------------------------------------------------
802: DELETE from psa_bc_xla_events_gt;
803: psa_utils.debug_other_string(g_state_level,l_api_name,'Number of rows deleted of psa_bc_xla_events_gt: ' || SQL%ROWCOUNT);
804: DELETE from xla_acct_prog_events_gt;
805: psa_utils.debug_other_string(g_state_level,l_api_name,'Number of rows deleted of xla_acct_prog_events_gt: ' || SQL%ROWCOUNT);
806: DELETE from xla_ae_headers_gt;
807: psa_utils.debug_other_string(g_state_level,l_api_name,'Number of rows deleted of xla_ae_headers_gt: ' || SQL%ROWCOUNT);

Line 814: l_event_status_code := xla_events_pub_pkg.c_event_unprocessed;

810: DELETE from xla_validation_lines_gt;
811: psa_utils.debug_other_string(g_state_level,l_api_name,'Number of rows deleted of xla_validation_lines_gt: ' || SQL%ROWCOUNT);
812:
813: l_bc_event_count := 0;
814: l_event_status_code := xla_events_pub_pkg.c_event_unprocessed;
815: l_valuation_method := NULL;
816: l_event_check := TRUE;
817: l_process_dist := TRUE;
818:

Line 1049: l_event_id := xla_events_pub_pkg.create_event

1045: p_org_id => p_tab_fc_dist(i).org_id,
1046: p_calling_sequence => l_curr_calling_sequence
1047: );
1048:
1049: l_event_id := xla_events_pub_pkg.create_event
1050: (
1051: p_event_source_info => l_event_source_info,
1052: p_event_type_code => l_event_type_code,
1053: p_event_date => l_event_date,

Line 1141: INSERT INTO psa_bc_xla_events_gt

1137: END IF;
1138:
1139: FOR i IN 1..l_bc_event_count LOOP
1140: psa_utils.debug_other_string(g_state_level,l_api_name,'Loop Index i = '||i||' Event id = '||l_bc_event_tab(i).event_id);
1141: INSERT INTO psa_bc_xla_events_gt
1142: (
1143: event_id,
1144: result_code
1145: )

Line 1151: psa_utils.debug_other_string(g_state_level,l_api_name,'Number of rows inserted in psa_bc_xla_events_gt: ' || SQL%ROWCOUNT);

1147: (
1148: l_bc_event_tab(i).event_id,
1149: 'XLA_UNPROCESSED'
1150: );
1151: psa_utils.debug_other_string(g_state_level,l_api_name,'Number of rows inserted in psa_bc_xla_events_gt: ' || SQL%ROWCOUNT);
1152: END LOOP;
1153:
1154:
1155: IF (p_bc_mode <> 'C') THEN

Line 1254: FROM psa_bc_xla_events_gt e,

1250: SELECT DECODE(MIN(p.status_code),'A', 'S', 'F'),
1251: MIN(p.status_code)
1252: INTO p_tab_fc_dist(i).result_code,
1253: p_tab_fc_dist(i).status_code
1254: FROM psa_bc_xla_events_gt e,
1255: gl_bc_packets p,
1256: xla_distribution_links xdl,
1257: ap_prepay_app_dists apad
1258: WHERE xdl.event_id = e.event_id

Line 1281: FROM psa_bc_xla_events_gt e,

1277: SELECT DECODE(MIN(p.status_code),'A', 'S', 'F'),
1278: MIN(p.status_code)
1279: INTO p_tab_fc_dist(i).result_code,
1280: p_tab_fc_dist(i).status_code
1281: FROM psa_bc_xla_events_gt e,
1282: gl_bc_packets p,
1283: xla_distribution_links xdl
1284: WHERE xdl.event_id = e.event_id
1285: AND xdl.source_distribution_id_num_1 = p_tab_fc_dist(i).inv_distribution_id

Line 1339: | RETURN: XLA_EVENTS_PUB_PKG.T_SECURITY

Line 1355: RETURN XLA_EVENTS_PUB_PKG.T_SECURITY

1351: (
1352: p_org_id IN NUMBER,
1353: p_calling_sequence IN VARCHAR2
1354: )
1355: RETURN XLA_EVENTS_PUB_PKG.T_SECURITY
1356: IS
1357:
1358: l_event_security_context XLA_EVENTS_PUB_PKG.T_SECURITY;
1359:

Line 1358: l_event_security_context XLA_EVENTS_PUB_PKG.T_SECURITY;

1354: )
1355: RETURN XLA_EVENTS_PUB_PKG.T_SECURITY
1356: IS
1357:
1358: l_event_security_context XLA_EVENTS_PUB_PKG.T_SECURITY;
1359:
1360: -- Logging:
1361: l_api_name VARCHAR(240);
1362:

Line 1426: psa_bc_xla_events_gt e

1422: FROM gl_lookups l
1423: WHERE lookup_type = 'FUNDS_CHECK_RESULT_CODE'
1424: AND EXISTS ( SELECT 'x'
1425: FROM gl_bc_packets bc,
1426: psa_bc_xla_events_gt e
1427: WHERE bc.event_id = e.event_id
1428: AND bc.result_code like 'F%'
1429: AND bc.result_code = l.lookup_code)
1430: AND rownum = 1;

Line 2168: FROM xla_events evt,

2164: l_r12_unencumbered_amount NUMBER;
2165:
2166: CURSOR cur_get_po_encum_rev_amt IS
2167: SELECT NVL(sum((NVL(dist.amount,0) - NVL(dist.amount_variance,0) - NVL(dist.quantity_variance,0))*nvl(pod.rate,1)), 0) po_reversed_encumbered_amount
2168: FROM xla_events evt,
2169: ap_invoice_distributions_all dist,
2170: po_distributions_all pod
2171: WHERE evt.event_status_code = 'P'
2172: AND ((p_start_gl_date is not null