DBA Data[Home] [Help]

APPS.PSA_AP_BC_PVT dependencies on XLA_EVENTS_PUB_PKG

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 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 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 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 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 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 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 1339: | RETURN: XLA_EVENTS_PUB_PKG.T_SECURITY

1335: | PRAMETERS:
1336: | p_org_id: Organization ID
1337: | p_calling_sequence: Debug information
1338: |
1339: | RETURN: XLA_EVENTS_PUB_PKG.T_SECURITY
1340: |
1341: | KNOWN ISSUES:
1342: |
1343: | NOTES:

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: