DBA Data[Home] [Help]

APPS.PSA_AP_BC_PVT dependencies on XLA_EVENTS_PUB_PKG

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

848: | PRAMETERS:
849: | p_org_id: Organization ID
850: | p_calling_sequence: Debug information
851: |
852: | RETURN: XLA_EVENTS_PUB_PKG.T_SECURITY
853: |
854: | KNOWN ISSUES:
855: |
856: | NOTES:

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: