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 17: ) RETURN XLA_EVENTS_PUB_PKG.T_SECURITY;

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

Line 61: FROM xla_events xla,

57: xte.source_id_int_2,
58: xte.source_id_int_3,
59: xte.source_id_int_4,
60: xte.source_id_char_1
61: FROM xla_events xla,
62: xla_transaction_entities xte
63: WHERE NVL(xla.budgetary_control_flag, 'N') ='Y'
64: AND xla.application_id = 200
65: AND xla.event_date BETWEEN p_start_date AND p_end_date

Line 72: TYPE Event_tab_type IS TABLE OF XLA_EVENTS_INT_GT%rowtype

68: AND xla.entity_id = xte.entity_id
69: AND xla.application_id = xte.application_id
70: AND xte.ledger_id = p_ledger_id;
71:
72: TYPE Event_tab_type IS TABLE OF XLA_EVENTS_INT_GT%rowtype
73: INDEX BY BINARY_INTEGER;
74: l_events_Tab Event_tab_type;
75: l_event_count NUMBER;
76:

Line 82: l_event_source_info xla_events_pub_pkg.t_event_source_info;

78: l_log_msg FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;
79: l_debug_loc VARCHAR2(30) := 'Delete_Events';
80: l_api_name VARCHAR2(240);
81:
82: l_event_source_info xla_events_pub_pkg.t_event_source_info;
83: l_valuation_method VARCHAR2(30);
84: l_security_context xla_events_pub_pkg.t_security;
85:
86: BEGIN

Line 84: l_security_context xla_events_pub_pkg.t_security;

80: l_api_name VARCHAR2(240);
81:
82: l_event_source_info xla_events_pub_pkg.t_event_source_info;
83: l_valuation_method VARCHAR2(30);
84: l_security_context xla_events_pub_pkg.t_security;
85:
86: BEGIN
87: fnd_file.put_line(fnd_file.log ,'>> PSA_AP_BC_PVT.Delete_EVENTS');
88: l_api_name := g_full_path||'.Delete_Events';

Line 103: DELETE FROM XLA_EVENTS_INT_GT;

99: --setting xla security context to use table xla_transaction_entity
100:
101: xla_security_pkg.set_security_context(200); --passing payables application_id
102:
103: DELETE FROM XLA_EVENTS_INT_GT;
104: psa_utils.debug_other_string(g_state_level,l_api_name, '# Rows deleted from xla_events_int_gt'|| SQL%ROWCOUNT );
105:
106: l_event_count := 0;
107: FOR rec_events IN c_get_unprocessed_events

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

100:
101: xla_security_pkg.set_security_context(200); --passing payables application_id
102:
103: DELETE FROM XLA_EVENTS_INT_GT;
104: psa_utils.debug_other_string(g_state_level,l_api_name, '# Rows deleted from xla_events_int_gt'|| SQL%ROWCOUNT );
105:
106: l_event_count := 0;
107: FOR rec_events IN c_get_unprocessed_events
108: LOOP

Line 124: INSERT INTO XLA_EVENTS_INT_GT

120:
121:
122: IF l_event_count > 0 THEN
123: FORALL i IN 1..l_event_count
124: INSERT INTO XLA_EVENTS_INT_GT
125: VALUES l_events_tab(i) ;
126: psa_utils.debug_other_string(g_state_level,l_api_name,' # Rows inserted into xla_events_int_gt table:' || l_event_count);
127: psa_utils.debug_other_string(g_state_level,l_api_name,'Calling XLA_EVENTS_PUB_PKG.DELETE_BULK_EVENT ');
128:

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

122: IF l_event_count > 0 THEN
123: FORALL i IN 1..l_event_count
124: INSERT INTO XLA_EVENTS_INT_GT
125: VALUES l_events_tab(i) ;
126: psa_utils.debug_other_string(g_state_level,l_api_name,' # Rows inserted into xla_events_int_gt table:' || l_event_count);
127: psa_utils.debug_other_string(g_state_level,l_api_name,'Calling XLA_EVENTS_PUB_PKG.DELETE_BULK_EVENT ');
128:
129: XLA_EVENTS_PUB_PKG.DELETE_BULK_EVENTS(p_application_id => 200);
130:

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

123: FORALL i IN 1..l_event_count
124: INSERT INTO XLA_EVENTS_INT_GT
125: VALUES l_events_tab(i) ;
126: psa_utils.debug_other_string(g_state_level,l_api_name,' # Rows inserted into xla_events_int_gt table:' || l_event_count);
127: psa_utils.debug_other_string(g_state_level,l_api_name,'Calling XLA_EVENTS_PUB_PKG.DELETE_BULK_EVENT ');
128:
129: XLA_EVENTS_PUB_PKG.DELETE_BULK_EVENTS(p_application_id => 200);
130:
131: psa_utils.debug_other_string(g_state_level,l_api_name,'After Deletion of Unprocessed Events');

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

125: VALUES l_events_tab(i) ;
126: psa_utils.debug_other_string(g_state_level,l_api_name,' # Rows inserted into xla_events_int_gt table:' || l_event_count);
127: psa_utils.debug_other_string(g_state_level,l_api_name,'Calling XLA_EVENTS_PUB_PKG.DELETE_BULK_EVENT ');
128:
129: XLA_EVENTS_PUB_PKG.DELETE_BULK_EVENTS(p_application_id => 200);
130:
131: psa_utils.debug_other_string(g_state_level,l_api_name,'After Deletion of Unprocessed Events');
132: fnd_file.put_line(fnd_file.log ,'The following BC unprocessed/Error events have been deleted');
133: fnd_file.put_line(fnd_file.log ,'Event_id Event_status_code Process_status_code');

Line 208: FROM ap_invoice_distributions_all aid, xla_events xe

204:
205:
206: CURSOR c_parent_prepayapply_processed(p_prepayapply_dist_id number) IS
207: SELECT 'Y'
208: FROM ap_invoice_distributions_all aid, xla_events xe
209: WHERE aid.invoice_distribution_id=p_prepayapply_dist_id
210: --l_parent_reversal_id
211: AND aid.bc_event_id = xe.event_id
212: AND xe.event_status_code = 'P'

Line 262: TYPE BC_Event_tab_type IS TABLE OF xla_events%rowtype

258: l_curr_calling_sequence VARCHAR2(2000);
259: l_log_msg FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;
260: l_debug_loc VARCHAR2(30) := 'Create_Events';
261:
262: TYPE BC_Event_tab_type IS TABLE OF xla_events%rowtype
263: INDEX BY BINARY_INTEGER;
264:
265: l_BC_Event_Tab BC_Event_tab_type;
266: l_api_name VARCHAR2(240);

Line 273: l_event_source_info xla_events_pub_pkg.t_event_source_info;

269: l_event_type_code VARCHAR2(30);
270: l_event_date DATE;
271: l_event_status_code VARCHAR2(30);
272: l_event_number NUMBER;
273: l_event_source_info xla_events_pub_pkg.t_event_source_info;
274: l_reference_info xla_events_pub_pkg.t_event_reference_info;
275: l_valuation_method VARCHAR2(30);
276: l_security_context xla_events_pub_pkg.t_security;
277: l_event_check BOOLEAN;

Line 274: l_reference_info xla_events_pub_pkg.t_event_reference_info;

270: l_event_date DATE;
271: l_event_status_code VARCHAR2(30);
272: l_event_number NUMBER;
273: l_event_source_info xla_events_pub_pkg.t_event_source_info;
274: l_reference_info xla_events_pub_pkg.t_event_reference_info;
275: l_valuation_method VARCHAR2(30);
276: l_security_context xla_events_pub_pkg.t_security;
277: l_event_check BOOLEAN;
278: dummy VARCHAR2(200);

Line 276: l_security_context xla_events_pub_pkg.t_security;

272: l_event_number NUMBER;
273: l_event_source_info xla_events_pub_pkg.t_event_source_info;
274: l_reference_info xla_events_pub_pkg.t_event_reference_info;
275: l_valuation_method VARCHAR2(30);
276: l_security_context xla_events_pub_pkg.t_security;
277: l_event_check BOOLEAN;
278: dummy VARCHAR2(200);
279: l_process_dist BOOLEAN;
280: l_encum_flag VARCHAR2(1);

Line 309: DELETE from psa_bc_xla_events_gt;

305:
306: ----------------------------------------------------------------------
307: -- Bug 5160179: clear the temporary gt table before inserting any rows
308: ----------------------------------------------------------------------
309: DELETE from psa_bc_xla_events_gt;
310: psa_utils.debug_other_string(g_state_level,l_api_name,'Number of rows deleted of psa_bc_xla_events_gt: ' || SQL%ROWCOUNT);
311: DELETE from xla_acct_prog_events_gt;
312: psa_utils.debug_other_string(g_state_level,l_api_name,'Number of rows deleted of xla_acct_prog_events_gt: ' || SQL%ROWCOUNT);
313: DELETE from xla_ae_headers_gt;

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

306: ----------------------------------------------------------------------
307: -- Bug 5160179: clear the temporary gt table before inserting any rows
308: ----------------------------------------------------------------------
309: DELETE from psa_bc_xla_events_gt;
310: psa_utils.debug_other_string(g_state_level,l_api_name,'Number of rows deleted of psa_bc_xla_events_gt: ' || SQL%ROWCOUNT);
311: DELETE from xla_acct_prog_events_gt;
312: psa_utils.debug_other_string(g_state_level,l_api_name,'Number of rows deleted of xla_acct_prog_events_gt: ' || SQL%ROWCOUNT);
313: DELETE from xla_ae_headers_gt;
314: psa_utils.debug_other_string(g_state_level,l_api_name,'Number of rows deleted of xla_ae_headers_gt: ' || SQL%ROWCOUNT);

Line 321: l_event_status_code := xla_events_pub_pkg.c_event_unprocessed;

317: DELETE from xla_validation_lines_gt;
318: psa_utils.debug_other_string(g_state_level,l_api_name,'Number of rows deleted of xla_validation_lines_gt: ' || SQL%ROWCOUNT);
319:
320: l_bc_event_count := 0;
321: l_event_status_code := xla_events_pub_pkg.c_event_unprocessed;
322: l_valuation_method := null;
323: l_event_check := TRUE;
324: l_process_dist := TRUE;
325:

Line 519: IF XLA_EVENTS_PUB_PKG.event_exists

515: psa_utils.debug_other_string(g_state_level,l_api_name,'Budgetary Control API will not delete this event:'||p_tab_fc_dist(i) .bc_event_id);
516: ELSE
517: CLOSE c_exists_encumline;
518:
519: IF XLA_EVENTS_PUB_PKG.event_exists
520: (p_event_source_info => l_event_source_info
521: ,p_event_type_code => l_event_type_code
522: ,p_event_date => l_event_date
523: ,p_event_status_code => l_event_status_code

Line 529: psa_utils.debug_other_string(g_state_level,l_api_name,'Calling XLA_EVENTS_PUB_PKG.DELETE_EVENT to delete Event Id :'||p_tab_fc_dist(i).bc_event_id);

525: ,p_security_context => l_security_context
526: ) THEN
527:
528: psa_utils.debug_other_string(g_state_level,l_api_name,'Event Id for the event that exists:'||p_tab_fc_dist(i).bc_event_id);
529: psa_utils.debug_other_string(g_state_level,l_api_name,'Calling XLA_EVENTS_PUB_PKG.DELETE_EVENT to delete Event Id :'||p_tab_fc_dist(i).bc_event_id);
530: XLA_EVENTS_PUB_PKG.DELETE_EVENT(
531: p_event_source_info => l_event_source_info,
532: p_event_id => p_tab_fc_dist(i).bc_event_id,
533: p_valuation_method => l_valuation_method,

Line 530: XLA_EVENTS_PUB_PKG.DELETE_EVENT(

526: ) THEN
527:
528: psa_utils.debug_other_string(g_state_level,l_api_name,'Event Id for the event that exists:'||p_tab_fc_dist(i).bc_event_id);
529: psa_utils.debug_other_string(g_state_level,l_api_name,'Calling XLA_EVENTS_PUB_PKG.DELETE_EVENT to delete Event Id :'||p_tab_fc_dist(i).bc_event_id);
530: XLA_EVENTS_PUB_PKG.DELETE_EVENT(
531: p_event_source_info => l_event_source_info,
532: p_event_id => p_tab_fc_dist(i).bc_event_id,
533: p_valuation_method => l_valuation_method,
534: p_security_context => l_security_context);

Line 571: l_event_id := Xla_Events_Pub_Pkg.Create_Event(

567: END IF;
568:
569: IF l_event_id IS NULL THEN
570:
571: l_event_id := Xla_Events_Pub_Pkg.Create_Event(
572: p_event_source_info => l_event_source_info,
573: p_event_type_code => l_event_type_code,
574: p_event_date => l_event_date,
575: p_event_status_code => l_event_status_code,

Line 670: INSERT into psa_bc_xla_events_gt(event_id,result_code)

666:
667: FOR i IN 1..l_bc_event_count LOOP
668:
669: psa_utils.debug_other_string(g_state_level,l_api_name,'Loop Index i = '||i||' Event id = '||l_bc_event_tab(i).event_id);
670: INSERT into psa_bc_xla_events_gt(event_id,result_code)
671: VALUES (l_bc_event_tab(i).event_id,'XLA_UNPROCESSED');
672: psa_utils.debug_other_string(g_state_level,l_api_name,'Number of rows inserted in psa_bc_xla_events_gt: ' || SQL%ROWCOUNT);
673: END LOOP;
674:

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

668:
669: psa_utils.debug_other_string(g_state_level,l_api_name,'Loop Index i = '||i||' Event id = '||l_bc_event_tab(i).event_id);
670: INSERT into psa_bc_xla_events_gt(event_id,result_code)
671: VALUES (l_bc_event_tab(i).event_id,'XLA_UNPROCESSED');
672: psa_utils.debug_other_string(g_state_level,l_api_name,'Number of rows inserted in psa_bc_xla_events_gt: ' || SQL%ROWCOUNT);
673: END LOOP;
674:
675: -- Checking for if prepay and non-prepay distributions are sharing the same bc event BEGIN
676: -- AP poupulates the distributions for only one invoice at a time

Line 773: FROM psa_bc_xla_events_gt e,

769: SELECT decode(min(p.status_code),'A', 'S', 'F'),
770: min(p.status_code)
771: INTO p_tab_fc_dist(i).result_code,
772: p_tab_fc_dist(i).status_code
773: FROM psa_bc_xla_events_gt e,
774: gl_bc_packets p,
775: xla_distribution_links xdl,
776: ap_prepay_app_dists apad
777: WHERE xdl.event_id = e.event_id

Line 796: FROM psa_bc_xla_events_gt e,

792: SELECT decode(min(p.status_code),'A', 'S', 'F'),
793: min(p.status_code)
794: INTO p_tab_fc_dist(i).result_code,
795: p_tab_fc_dist(i).status_code
796: FROM psa_bc_xla_events_gt e,
797: gl_bc_packets p,
798: xla_distribution_links xdl
799: WHERE xdl.event_id = e.event_id
800: AND xdl.source_distribution_id_num_1 = p_tab_fc_dist(i).inv_distribution_id

Line 852: | RETURN: XLA_EVENTS_PUB_PKG.T_SECURITY

Line 866: RETURN XLA_EVENTS_PUB_PKG.T_SECURITY

862:
863: FUNCTION get_event_security_context(
864: p_org_id IN NUMBER,
865: p_calling_sequence IN VARCHAR2)
866: RETURN XLA_EVENTS_PUB_PKG.T_SECURITY
867: IS
868:
869: l_event_security_context XLA_EVENTS_PUB_PKG.T_SECURITY;
870:

Line 869: l_event_security_context XLA_EVENTS_PUB_PKG.T_SECURITY;

865: p_calling_sequence IN VARCHAR2)
866: RETURN XLA_EVENTS_PUB_PKG.T_SECURITY
867: IS
868:
869: l_event_security_context XLA_EVENTS_PUB_PKG.T_SECURITY;
870:
871: -- Logging:
872: l_api_name VARCHAR(240);
873:

Line 937: psa_bc_xla_events_gt e

933: FROM gl_lookups l
934: WHERE lookup_type = 'FUNDS_CHECK_RESULT_CODE'
935: AND EXISTS ( SELECT 'x'
936: FROM gl_bc_packets bc,
937: psa_bc_xla_events_gt e
938: WHERE bc.event_id = e.event_id
939: AND bc.result_code like 'F%'
940: AND bc.result_code = l.lookup_code
941: )

Line 1668: FROM xla_events evt

1664: l_r12_unencumbered_amount NUMBER;
1665:
1666: CURSOR cur_get_po_encum_rev_amt IS
1667: 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
1668: FROM xla_events evt
1669: ,ap_invoice_distributions_all dist
1670: ,po_distributions_all pod
1671: WHERE evt.event_status_code = 'P'
1672: AND ( ( p_start_gl_date is not null