DBA Data[Home] [Help]

APPS.AP_ACCTG_DATA_FIX_PKG dependencies on XLA_EVENTS

Line 88: ' as select * from XLA_EVENTS where rownum<1 ';

84: 'AP_Acctg_Data_Fix_PKG.Create_Temp_Acctg_Tables';
85:
86: Execute Immediate
87: 'create table '||'Events_'||P_Bug_Number||
88: ' as select * from XLA_EVENTS where rownum<1 ';
89:
90: Execute Immediate
91: 'alter table '||'Events_'||P_Bug_Number||
92: ' add datafix_update_date date default sysdate';

Line 286: ' select '||col_str5||' from xla_events '||

282: FND_File.Put_Line(fnd_file.log,l_message);
283:
284: l_debug_info := 'Before backing the events';
285: sql_liab_stat := 'insert into events_'||P_Bug_Number||'('||col_str5||') '||
286: ' select '||col_str5||' from xla_events '||
287: ' where event_id in '||
288: ' (select event_id from '||l_driver_table||
289: ' Where process_flag=''Y'')';
290:

Line 713: l_event_status_code XLA_EVENTS.EVENT_STATUS_CODE%TYPE;

709: p_delete_event IN VARCHAR2,
710: p_commit_flag IN VARCHAR2,
711: p_calling_sequence IN VARCHAR2) IS
712:
713: l_event_status_code XLA_EVENTS.EVENT_STATUS_CODE%TYPE;
714: l_gl_transfer_status_code XLA_AE_HEADERS.GL_TRANSFER_STATUS_CODE%TYPE;
715: l_debug_info VARCHAR2(4000);
716: l_error_log LONG;
717: l_calling_sequence VARCHAR2(4000);

Line 720: l_event_security_context XLA_EVENTS_PUB_PKG.T_SECURITY;

716: l_error_log LONG;
717: l_calling_sequence VARCHAR2(4000);
718:
719: /* Bug 11674553 */
720: l_event_security_context XLA_EVENTS_PUB_PKG.T_SECURITY;
721: l_event_source_info XLA_EVENTS_PUB_PKG.T_EVENT_SOURCE_INFO;
722:
723: l_legal_entity_id NUMBER(15);
724: l_ledger_id NUMBER(15);

Line 721: l_event_source_info XLA_EVENTS_PUB_PKG.T_EVENT_SOURCE_INFO;

717: l_calling_sequence VARCHAR2(4000);
718:
719: /* Bug 11674553 */
720: l_event_security_context XLA_EVENTS_PUB_PKG.T_SECURITY;
721: l_event_source_info XLA_EVENTS_PUB_PKG.T_EVENT_SOURCE_INFO;
722:
723: l_legal_entity_id NUMBER(15);
724: l_ledger_id NUMBER(15);
725: l_transaction_date AP_INVOICES_ALL.invoice_date%TYPE;

Line 784: FROM xla_events xe

780: INTO l_dummy
781: FROM dual
782: WHERE EXISTS
783: (SELECT 1
784: FROM xla_events xe
785: WHERE xe.application_id = 200
786: AND xe.event_id = p_event_id);
787:
788: EXCEPTION

Line 821: FROM xla_events xe

817: SELECT xe.event_status_code,
818: xe.entity_id
819: INTO l_event_status_code,
820: l_entity_id
821: FROM xla_events xe
822: WHERE xe.application_id = 200
823: AND xe.event_id = p_event_id;
824:
825: SELECT xah.gl_transfer_status_code

Line 980: AP_XLA_EVENTS_PKG.delete_event

976: IF (p_delete_event = 'Y' and l_Return_Status = 'S' ) THEN
977:
978: BEGIN
979: l_debug_info := ' Calling delete event..';
980: AP_XLA_EVENTS_PKG.delete_event
981: ( p_event_source_info => l_event_source_info,
982: p_event_id => p_event_id,
983: p_valuation_method => NULL,
984: p_security_context => l_event_security_context,

Line 1027: l_result := xla_events_pub_pkg.delete_entity (

1023:
1024: l_debug_info := 'Calling delete entity..';
1025:
1026: BEGIN
1027: l_result := xla_events_pub_pkg.delete_entity (
1028: p_source_info => l_event_source_info,
1029: p_valuation_method => NULL,
1030: p_security_context => l_event_security_context );
1031: EXCEPTION

Line 1233: ' FROM xla_events xe, '||

1229: ' ''C'', ''Closed'', '||
1230: ' ''N'', ''Never Opened'', '||
1231: ' ''Not-Open''), '||
1232: ' gl.name '||
1233: ' FROM xla_events xe, '||
1234: ' xla_ae_headers xah, '||
1235: l_driver_table||' dr, '||
1236: ' xla_transaction_entities_upg xte, '||
1237: ' gl_period_statuses glps, '||

Line 1369: ' FROM xla_events xe, '||

1365: ' ''C'', ''Closed'', '||
1366: ' ''N'', ''Never Opened'', '||
1367: ' ''Not-Open''), '||
1368: ' gl.name '||
1369: ' FROM xla_events xe, '||
1370: ' xla_ae_headers xah, '||
1371: l_driver_table||' dr, '||
1372: ' xla_transaction_entities_upg xte, '||
1373: ' gl_period_statuses glps, '||

Line 1527: ' FROM xla_events xe, '||

1523: ' UPDATE '||l_driver_table ||' dr '||
1524: ' SET (dr.calculated_undo_date, '||
1525: ' dr.calculated_undo_period) = '||
1526: ' (SELECT dr.proposed_undo_date, glps.period_name '||
1527: ' FROM xla_events xe, '||
1528: ' gl_period_statuses glps, '||
1529: ' xla_transaction_entities_upg xte '||
1530: ' WHERE xe.application_id = 200 '||
1531: ' AND glps.application_id = 200 '||

Line 1581: ' FROM xla_events xe, '||

1577: ' UPDATE '||l_driver_table ||' dr '||
1578: ' SET (dr.calculated_undo_date, '||
1579: ' dr.calculated_undo_period) = '||
1580: ' (SELECT xe.event_date, glps.period_name '||
1581: ' FROM xla_events xe, '||
1582: ' gl_period_statuses glps, '||
1583: ' xla_transaction_entities_upg xte '||
1584: ' WHERE xe.application_id = 200 '||
1585: ' AND glps.application_id = 200 '||

Line 1633: ' FROM xla_events xe, '||

1629: ' UPDATE '||l_driver_table ||' dr '||
1630: ' SET (dr.calculated_undo_date, '||
1631: ' dr.calculated_undo_period) = '||
1632: ' (SELECT trunc(sysdate), glps.period_name '||
1633: ' FROM xla_events xe, '||
1634: ' gl_period_statuses glps, '||
1635: ' xla_transaction_entities_upg xte '||
1636: ' WHERE xe.application_id = 200 '||
1637: ' AND glps.application_id = 200 '||

Line 1782: ' FROM xla_events xe, '||

1778: ' glcc.padded_concatenated_segments, '||
1779: ' glcc.enabled_flag, '||
1780: ' glcc.end_date_active, '||
1781: ' gl.name '||
1782: ' FROM xla_events xe, '||
1783: ' xla_ae_headers xah, '||
1784: ' xla_ae_lines xal, '||
1785: l_driver_table||' dr, '||
1786: ' xla_transaction_entities_upg xte, '||

Line 1957: l_event_status_code XLA_EVENTS.EVENT_STATUS_CODE%TYPE;

1953: l_Rev_Event_Id INTEGER;
1954: l_New_Event_Id INTEGER;
1955: l_Source_Id NUMBER;
1956: l_Return_Status VARCHAR2(300);
1957: l_event_status_code XLA_EVENTS.EVENT_STATUS_CODE%TYPE;
1958: Debug_Info VARCHAR2(50) := 'Undo_Accounting';
1959: l_calling_sequence VARCHAR2(4000);
1960:
1961: --Cursor modified to improve performance 7655892

Line 1970: xla_events xe,

1966: decode(xte.entity_code, 'AP_PAYMENTS', 'CHECKS', 'AP_INVOICES', 'INVOICES') check_or_invoice,
1967: xe.event_date gl_date,
1968: MAX(DECODE(NVL(gl_transfer_status_code,'N'), 'Y', 'Y', 'N')) gl_transfer_status_code /*bug 13911650*/
1969: FROM xla_transaction_entities_upg xte,
1970: xla_events xe,
1971: xla_ae_headers xah,
1972: ap_system_parameters_all asp
1973: WHERE xte.entity_id = xe.entity_id
1974: AND xe.application_id = 200

Line 2327: FROM xla_events xe

2323: IF (l_Return_Status = 'S') THEN
2324: BEGIN
2325: SELECT event_status_code
2326: INTO l_event_status_code
2327: FROM xla_events xe
2328: WHERE xe.application_id = 200
2329: AND xe.event_id = Events_to_Process_tab(i).Event_Id;
2330:
2331: IF l_event_status_code = 'P' THEN

Line 2375: UPDATE xla_Events

2371: AND line_type_lookup_code = 'AWT' ;
2372: --end of 8306966
2373:
2374:
2375: UPDATE xla_Events
2376: SET Event_Date = l_gl_Date
2377: WHERE Event_Id = Events_to_Process_tab(i).Event_Id;
2378:
2379: EXECUTE IMMEDIATE ins_AP_undo_event_log_stmt USING

Line 2430: UPDATE xla_Events

2426: WHERE Accounting_Event_Id = Events_to_Process_tab(i).Event_Id
2427: AND Invoice_Id = l_Source_Id;
2428:
2429:
2430: UPDATE xla_Events
2431: SET Event_Date = l_gl_Date
2432: WHERE Event_Id = Events_to_Process_tab(i).Event_Id;
2433:
2434: UPDATE ap_prepay_history_all aph

Line 2537: l_event_id XLA_EVENTS.EVENT_ID%TYPE;

2533: p_GL_Date IN DATE DEFAULT NULL) IS
2534:
2535: l_source_table XLA_TRANSACTION_ENTITIES.ENTITY_CODE%TYPE;
2536: l_source_id XLA_TRANSACTION_ENTITIES.SOURCE_ID_INT_1%TYPE;
2537: l_event_id XLA_EVENTS.EVENT_ID%TYPE;
2538: l_calling_sequence VARCHAR2(4000);
2539: l_bug_id NUMBER;
2540: l_rev_event_id NUMBER;
2541: l_new_event_id NUMBER;

Line 2612: l_event_status_code XLA_EVENTS.EVENT_STATUS_CODE%TYPE;

2608: l_dummy NUMBER;
2609: l_rev_event_id NUMBER;
2610: l_new_event_id NUMBER;
2611: l_return_code VARCHAR2(1000);
2612: l_event_status_code XLA_EVENTS.EVENT_STATUS_CODE%TYPE;
2613: l_message VARCHAR2(4000);
2614: l_calling_sequence VARCHAR2(4000);
2615:
2616: TYPE refcurtyp IS REF CURSOR;

Line 2625: TYPE event_date_t IS TABLE OF XLA_EVENTS.EVENT_DATE%TYPE INDEX BY BINARY_INTEGER;

2621: TYPE kind_t IS TABLE OF VARCHAR2(100) INDEX BY BINARY_INTEGER;
2622: TYPE event_id_t IS TABLE OF XLA_AE_HEADERS.EVENT_ID%TYPE INDEX BY BINARY_INTEGER;
2623: TYPE accounting_class_code_t IS TABLE OF XLA_AE_LINES.ACCOUNTING_CLASS_CODE%TYPE INDEX BY BINARY_INTEGER;
2624: TYPE event_type_code_t IS TABLE OF XLA_AE_HEADERS.EVENT_TYPE_CODE%TYPE INDEX BY BINARY_INTEGER;
2625: TYPE event_date_t IS TABLE OF XLA_EVENTS.EVENT_DATE%TYPE INDEX BY BINARY_INTEGER;
2626: TYPE ae_header_id_t IS TABLE OF XLA_AE_HEADERS.AE_HEADER_ID%TYPE INDEX BY BINARY_INTEGER;
2627: TYPE balance_type_code_t IS TABLE OF XLA_AE_HEADERS.BALANCE_TYPE_CODE%TYPE INDEX BY BINARY_INTEGER;
2628: TYPE source_id_int_1_t IS TABLE OF XLA_TRANSACTION_ENTITIES.SOURCE_ID_INT_1%TYPE INDEX BY BINARY_INTEGER;
2629: TYPE org_id_t IS TABLE OF XLA_TRANSACTION_ENTITIES.SECURITY_ID_INT_1%TYPE INDEX BY BINARY_INTEGER;

Line 2640: TYPE calc_undo_date_t IS TABLE OF XLA_EVENTS.EVENT_DATE%TYPE INDEX BY BINARY_INTEGER;

2636: TYPE accounted_dr_t IS TABLE OF XLA_AE_LINES.ACCOUNTED_DR%TYPE INDEX BY BINARY_INTEGER;
2637: TYPE accounted_cr_t IS TABLE OF XLA_AE_LINES.ACCOUNTED_CR%TYPE INDEX BY BINARY_INTEGER;
2638: TYPE description_t IS TABLE OF XLA_AE_LINES.DESCRIPTION%TYPE INDEX BY BINARY_INTEGER;
2639: TYPE name_t IS TABLE OF GL_LEDGERS.NAME%TYPE INDEX BY BINARY_INTEGER;
2640: TYPE calc_undo_date_t IS TABLE OF XLA_EVENTS.EVENT_DATE%TYPE INDEX BY BINARY_INTEGER;
2641: TYPE calc_undo_period_t IS TABLE OF GL_PERIOD_STATUSES.PERIOD_NAME%TYPE INDEX BY BINARY_INTEGER;
2642: TYPE error_reason_t IS TABLE OF VARCHAR2(1000) INDEX BY BINARY_INTEGER;
2643: TYPE budgetary_control_flag_t IS TABLE OF XLA_EVENTS.budgetary_control_flag%TYPE INDEX BY BINARY_INTEGER; /*Bug 10072990*/
2644:

Line 2643: TYPE budgetary_control_flag_t IS TABLE OF XLA_EVENTS.budgetary_control_flag%TYPE INDEX BY BINARY_INTEGER; /*Bug 10072990*/

2639: TYPE name_t IS TABLE OF GL_LEDGERS.NAME%TYPE INDEX BY BINARY_INTEGER;
2640: TYPE calc_undo_date_t IS TABLE OF XLA_EVENTS.EVENT_DATE%TYPE INDEX BY BINARY_INTEGER;
2641: TYPE calc_undo_period_t IS TABLE OF GL_PERIOD_STATUSES.PERIOD_NAME%TYPE INDEX BY BINARY_INTEGER;
2642: TYPE error_reason_t IS TABLE OF VARCHAR2(1000) INDEX BY BINARY_INTEGER;
2643: TYPE budgetary_control_flag_t IS TABLE OF XLA_EVENTS.budgetary_control_flag%TYPE INDEX BY BINARY_INTEGER; /*Bug 10072990*/
2644:
2645: TYPE undo_rec_typ IS RECORD
2646: (event_id_l event_id_t,
2647: source_type_l entity_code_t,

Line 2755: ' xla_events xe, '||

2751: ' dr.calculated_undo_date, '||
2752: ' dr.calculated_undo_period, '||
2753: ' xe.budgetary_control_flag '|| --Bug 10072990
2754: ' FROM xla_transaction_entities_upg xte, '||
2755: ' xla_events xe, '||
2756: l_driver_table||' dr '||
2757: ' WHERE xte.application_id = 200 '||
2758: ' AND xe.application_id = 200 '||
2759: ' AND dr.event_id = xe.event_id '||

Line 2927: ' FROM xla_events xe, '||

2923: ' xal.accounted_dr, '||
2924: ' xal.accounted_cr, '||
2925: ' xal.description, '||
2926: ' gl.name '||
2927: ' FROM xla_events xe, '||
2928: ' xla_ae_headers xah, '||
2929: ' xla_ae_lines xal, '||
2930: ' xla_transaction_entities_upg xte, '||
2931: ' gl_code_combinations_kfv gcc, '||

Line 2945: ' xla_events xe '||

2941: ' AND xal.code_combination_id = gcc.code_combination_id '||
2942: ' AND xah.event_id IN '||
2943: ' (SELECT DISTINCT dr.new_event_id '||
2944: ' FROM '||l_driver_table||' dr, '||
2945: ' xla_events xe '||
2946: ' WHERE xe.application_id = 200 '||
2947: ' AND dr.event_id = xe.event_id '||
2948: ' AND xe.event_status_code <> ''MANUAL'' '||
2949: ' AND dr.process_flag = ''Y'' '||

Line 2972: ' FROM xla_events xe, '||

2968: ' xal.accounted_dr, '||
2969: ' xal.accounted_cr, '||
2970: ' xal.description, '||
2971: ' gl.name '||
2972: ' FROM xla_events xe, '||
2973: ' xla_ae_headers xah, '||
2974: ' xla_ae_lines xal, '||
2975: ' xla_transaction_entities_upg xte, '||
2976: ' gl_code_combinations_kfv gcc, '||

Line 2991: ' xla_events xe '||

2987: ' AND xal.code_combination_id = gcc.code_combination_id '||
2988: ' AND xe.event_id IN '||
2989: ' (SELECT DISTINCT dr.reversal_event_id '||
2990: ' FROM '||l_driver_table||' dr, '||
2991: ' xla_events xe '||
2992: ' WHERE xe.application_id = 200 '||
2993: ' AND dr.event_id = xe.event_id '||
2994: ' AND xe.event_status_code <> ''MANUAL'' '||
2995: ' AND dr.process_flag = ''Y'' '||

Line 3067: l_message := 'Following are the details of the XLA events for which '||

3063: l_message := '';
3064: print(l_message);
3065:
3066:
3067: l_message := 'Following are the details of the XLA events for which '||
3068: 'there was an error while Unaccounting';
3069: Print(l_message);
3070:
3071: l_debug_info := ' Printing the details of the transactions for which the Undo '||

Line 3091: ' xla_events xe, '||

3087: ' ''SUCCESS'', ''Success'', '||
3088: ' ''Relevant Error Not Found '' '||
3089: ' ) '||
3090: ' FROM xla_transaction_entities_upg xte, '||
3091: ' xla_events xe, '||
3092: l_driver_table||' dr '||
3093: ' WHERE xte.application_id = 200 '||
3094: ' AND xe.application_id = 200 '||
3095: ' AND dr.event_id = xe.event_id '||

Line 3152: ' FROM xla_events xe, '||

3148: ' SET dr.process_flag = ''D'' '||
3149: ' WHERE dr.process_flag = ''Y'' '||
3150: ' AND (dr.event_id IN '||
3151: ' (SELECT xe.event_id '||
3152: ' FROM xla_events xe, '||
3153: l_driver_table||' dr1 '||
3154: ' WHERE xe.application_id = 200 '||
3155: ' AND xe.event_status_code <> ''P'' '||
3156: ' AND xe.event_id = dr1.event_id) ' ||

Line 3159: ' FROM xla_events xe ' ||

3155: ' AND xe.event_status_code <> ''P'' '||
3156: ' AND xe.event_id = dr1.event_id) ' ||
3157: ' OR NOT EXISTS ' ||
3158: ' (SELECT 1 ' ||
3159: ' FROM xla_events xe ' ||
3160: ' WHERE xe.event_id = dr.event_id ' ||
3161: ' AND xe.application_id =200 ))';
3162:
3163: EXECUTE IMMEDIATE l_sql_stmt;

Line 3231: l_max_event_id XLA_EVENTS.event_id%TYPE;

3227: l_is_final_pay BOOLEAN;
3228: l_rej_count NUMBER;
3229: l_reject_code VARCHAR2(100);
3230: l_index NUMBER := 0;
3231: l_max_event_id XLA_EVENTS.event_id%TYPE;
3232: l_op_event_type XLA_EVENTS.EVENT_TYPE_CODE%TYPE;
3233: l_max_pay_dist_id NUMBER;
3234: l_max_prepay_dist_id NUMBER;
3235: l_return_status BOOLEAN;

Line 3232: l_op_event_type XLA_EVENTS.EVENT_TYPE_CODE%TYPE;

3228: l_rej_count NUMBER;
3229: l_reject_code VARCHAR2(100);
3230: l_index NUMBER := 0;
3231: l_max_event_id XLA_EVENTS.event_id%TYPE;
3232: l_op_event_type XLA_EVENTS.EVENT_TYPE_CODE%TYPE;
3233: l_max_pay_dist_id NUMBER;
3234: l_max_prepay_dist_id NUMBER;
3235: l_return_status BOOLEAN;
3236: l_validation_status VARCHAR2(100);

Line 3270: FROM xla_events XE,

3266: XE.Event_Number,
3267: XE.Event_Status_Code,
3268: XTE.Entity_Code,
3269: XTE.Source_ID_Int_1
3270: FROM xla_events XE,
3271: xla_transaction_entities_upg XTE
3272: WHERE XE.application_id = 200
3273: AND XTE.application_id = 200
3274: AND XE.entity_id = XTE.entity_id

Line 3588: FROM xla_events xe,

3584:
3585:
3586: SELECT count(*)
3587: INTO l_cnt_unacc_inv_evnts
3588: FROM xla_events xe,
3589: xla_transaction_entities_upg xte,
3590: ap_invoices_all ai
3591: WHERE xe.application_id = 200
3592: AND xte.application_id = 200

Line 3618: FROM xla_events xe,

3614:
3615:
3616: SELECT count(*)
3617: INTO l_cnt_unacc_pay_evnts
3618: FROM xla_events xe,
3619: xla_transaction_entities_upg xte,
3620: ap_invoice_payments_all aip
3621: WHERE xe.application_id = 200
3622: AND xte.application_id = 200

Line 3650: FROM xla_events xe,

3646: END IF;
3647:
3648: SELECT count(*)
3649: INTO l_cnt_untrx_inv_evnts
3650: FROM xla_events xe,
3651: xla_ae_headers xah,
3652: xla_transaction_entities_upg xte,
3653: ap_invoices_all ai
3654: WHERE xe.application_id = 200

Line 3683: FROM xla_events xe,

3679: END IF;
3680:
3681: SELECT count(*)
3682: INTO l_cnt_untrx_pay_evnts
3683: FROM xla_events xe,
3684: xla_ae_headers xah,
3685: xla_transaction_entities_upg xte,
3686: ap_invoice_payments_all aip
3687: WHERE xe.application_id = 200

Line 3719: FROM xla_events xe

3715: END IF;
3716:
3717: SELECT max(xe.event_id)
3718: INTO l_max_event_id
3719: FROM xla_events xe
3720: WHERE xe.application_id = 200
3721: AND xe.event_status_code = 'P'
3722: AND xe.event_id IN
3723: (SELECT aph.accounting_event_id

Line 3797: FROM xla_events xe

3793: END IF;
3794:
3795: SELECT xe.event_type_code
3796: INTO p_op_event_type
3797: FROM xla_events xe
3798: WHERE xe.application_id = 200
3799: AND xe.event_id = l_max_event_id;
3800:
3801:

Line 3936: xla_events xe

3932: l_debug_info := 'before fetching the check_id';
3933: SELECT xte.source_id_int_1
3934: INTO l_check_id
3935: FROM xla_transaction_entities_upg xte,
3936: xla_events xe
3937: WHERE xe.application_id = 200
3938: AND xte.application_id = 200
3939: AND xe.entity_id = xte.entity_id
3940: AND xte.entity_code = 'AP_PAYMENTS'

Line 4209: l_event_security_context XLA_EVENTS_PUB_PKG.T_SECURITY;

4205:
4206: l_procedure_name CONSTANT VARCHAR2(30) := 'delete_cascade_adjustments()';
4207: l_debug_info VARCHAR2(1000);
4208:
4209: l_event_security_context XLA_EVENTS_PUB_PKG.T_SECURITY;
4210: l_event_source_info XLA_EVENTS_PUB_PKG.T_EVENT_SOURCE_INFO;
4211: l_orgid NUMBER(10);
4212:
4213: CURSOR payment_cascade_adj_cur IS

Line 4210: l_event_source_info XLA_EVENTS_PUB_PKG.T_EVENT_SOURCE_INFO;

4206: l_procedure_name CONSTANT VARCHAR2(30) := 'delete_cascade_adjustments()';
4207: l_debug_info VARCHAR2(1000);
4208:
4209: l_event_security_context XLA_EVENTS_PUB_PKG.T_SECURITY;
4210: l_event_source_info XLA_EVENTS_PUB_PKG.T_EVENT_SOURCE_INFO;
4211: l_orgid NUMBER(10);
4212:
4213: CURSOR payment_cascade_adj_cur IS
4214: SELECT DISTINCT aph_adj.accounting_event_id

Line 4216: , xla_events xe

4212:
4213: CURSOR payment_cascade_adj_cur IS
4214: SELECT DISTINCT aph_adj.accounting_event_id
4215: FROM ap_payment_history_all aph
4216: , xla_events xe
4217: , ap_payment_history_all aph_adj
4218: , xla_events xe_adj
4219: WHERE aph.check_id = p_source_id
4220: AND aph.accounting_event_id = NVL(p_related_event_id

Line 4218: , xla_events xe_adj

4214: SELECT DISTINCT aph_adj.accounting_event_id
4215: FROM ap_payment_history_all aph
4216: , xla_events xe
4217: , ap_payment_history_all aph_adj
4218: , xla_events xe_adj
4219: WHERE aph.check_id = p_source_id
4220: AND aph.accounting_event_id = NVL(p_related_event_id
4221: , aph.accounting_event_id)
4222: AND aph.transaction_type IN('PAYMENT CREATED',

Line 4244: , xla_events xe

4240: CURSOR prepay_appl_cascade_adj_cur IS
4241: SELECT DISTINCT apph_adj.accounting_event_id
4242: FROM ap_invoices_all ai
4243: , ap_prepay_history_all apph
4244: , xla_events xe
4245: , ap_prepay_history_all apph_adj
4246: , xla_events xe_adj
4247: WHERE 1=1
4248: AND ai.invoice_id = p_source_id

Line 4246: , xla_events xe_adj

4242: FROM ap_invoices_all ai
4243: , ap_prepay_history_all apph
4244: , xla_events xe
4245: , ap_prepay_history_all apph_adj
4246: , xla_events xe_adj
4247: WHERE 1=1
4248: AND ai.invoice_id = p_source_id
4249: AND ap_invoices_utility_pkg.get_approval_status
4250: (ai.invoice_id,

Line 4340: AP_XLA_EVENTS_PKG.delete_event

4336: /* delete PREPAY APPL cascade adjustments */
4337: FOR i IN prepay_appl_cascade_adj_cur
4338: LOOP
4339:
4340: AP_XLA_EVENTS_PKG.delete_event
4341: ( p_event_source_info => l_event_source_info,
4342: p_event_id => i.accounting_event_id,
4343: p_valuation_method => NULL,
4344: p_security_context => l_event_security_context,

Line 4353: FROM xla_events xe

4349: WHERE apad.accounting_event_id = i.accounting_event_id
4350: AND NOT EXISTS
4351: (
4352: SELECT 1
4353: FROM xla_events xe
4354: WHERE xe.event_id = apad.accounting_event_id
4355: AND xe.application_id = 200
4356: );
4357:

Line 4363: FROM xla_events xe

4359: WHERE apph.accounting_event_id = i.accounting_event_id
4360: AND NOT EXISTS
4361: (
4362: SELECT 1
4363: FROM xla_events xe
4364: WHERE xe.event_id = apph.accounting_event_id
4365: AND xe.application_id = 200
4366: );
4367:

Line 4376: AP_XLA_EVENTS_PKG.delete_event

4372: /* delete PAYMENT cascade adjustments */
4373: FOR i IN payment_cascade_adj_cur
4374: LOOP
4375:
4376: AP_XLA_EVENTS_PKG.delete_event
4377: ( p_event_source_info => l_event_source_info,
4378: p_event_id => i.accounting_event_id,
4379: p_valuation_method => NULL,
4380: p_security_context => l_event_security_context,

Line 4389: FROM xla_events xe

4385: WHERE aphd.accounting_event_id = i.accounting_event_id
4386: AND NOT EXISTS
4387: (
4388: SELECT 1
4389: FROM xla_events xe
4390: WHERE xe.event_id = aphd.accounting_event_id
4391: AND xe.application_id = 200
4392: );
4393:

Line 4399: FROM xla_events xe

4395: WHERE aph.accounting_event_id = i.accounting_event_id
4396: AND NOT EXISTS
4397: (
4398: SELECT 1
4399: FROM xla_events xe
4400: WHERE xe.event_id = aph.accounting_event_id
4401: AND xe.application_id = 200
4402: );
4403:

Line 4497: xla_events xe

4493: aid.accounting_event_id,
4494: aid.bc_event_id,
4495: aid.match_status_flag
4496: FROM ap_invoice_distributions_all aid,
4497: xla_events xe
4498: WHERE xe.application_id = 200
4499: AND aid.accounting_event_id = xe.event_id
4500: AND aid.invoice_id = P_Invoice_ID
4501: AND xe.event_status_code IN ('I','U')

Line 4509: FROM xla_events xe_bc,

4505: AND NVL(encumbered_flag, 'N') <> 'Y'
4506: AND aid.posted_flag <> 'Y'
4507: AND NOT EXISTS
4508: (SELECT 1
4509: FROM xla_events xe_bc,
4510: financials_system_params_all fsp
4511: WHERE fsp.org_id = aid.org_id
4512: AND fsp.purch_encumbrance_flag = 'Y'
4513: AND xe_bc.application_id = 200

Line 5412: , xla_events xe

5408: , xe.event_date gl_date
5409: , nvl(xe.budgetary_control_flag, 'N') budgetary_control_flag /*Bug 12975723*/
5410: , MAX(DECODE(NVL(gl_transfer_status_code,'N'), 'Y', 'Y', 'N')) gl_transfer_status_code /* bug 13911650*/
5411: FROM xla_transaction_entities_upg xte
5412: , xla_events xe
5413: , xla_ae_headers xah
5414: , ap_system_parameters_all asp
5415: WHERE xte.entity_id = xe.entity_id
5416: AND xe.application_id = 200

Line 5529: l_event_status_code XLA_EVENTS.EVENT_STATUS_CODE%TYPE;

5525: l_rev_event_id INTEGER;
5526: l_new_event_id INTEGER;
5527: l_source_id NUMBER;
5528: l_return_status VARCHAR2(300);
5529: l_event_status_code XLA_EVENTS.EVENT_STATUS_CODE%TYPE;
5530: debug_info VARCHAR2(50) := 'Undo_Inv_Accounting';
5531: l_calling_sequence VARCHAR2(4000);
5532: l_rel_act_acct_event_cnt NUMBER;
5533:

Line 5668: , xla_events xe

5664: IF( Events_to_Process_tab( i ).budgetary_control_flag = 'Y' ) THEN
5665: SELECT COUNT( 1 )
5666: INTO l_rel_act_acct_event_cnt
5667: FROM ap_invoice_distributions_all aid
5668: , xla_events xe
5669: WHERE aid.invoice_id = p_source_id
5670: AND aid.bc_event_id = Events_to_Process_tab( i ).event_id
5671: AND xe.event_id = aid.accounting_event_id
5672: AND xe.event_status_code = 'P'

Line 5761: FROM xla_events xe

5757: IF( l_Return_Status = 'S' ) THEN
5758: BEGIN
5759: SELECT event_status_code
5760: INTO l_event_status_code
5761: FROM xla_events xe
5762: WHERE xe.application_id = 200
5763: AND xe.event_id = Events_to_Process_tab( i ).Event_Id;
5764: IF l_event_status_code = 'P' THEN
5765: p_return_code := 'XLA_NO_WORK';

Line 5792: UPDATE xla_Events

5788: , Period_Name = l_Period_Name
5789: WHERE Accounting_Event_Id = Events_to_Process_tab( i ).Event_Id
5790: AND Invoice_Id = l_Source_Id;
5791:
5792: UPDATE xla_Events
5793: SET Event_Date = l_gl_Date
5794: WHERE Event_Id = Events_to_Process_tab( i ).Event_Id
5795: AND application_id = 200;
5796:

Line 5988: l_event_id XLA_EVENTS.EVENT_ID%TYPE;

5984: p_gl_date IN DATE DEFAULT NULL) IS
5985:
5986: l_source_table XLA_TRANSACTION_ENTITIES.ENTITY_CODE%TYPE;
5987: l_source_id XLA_TRANSACTION_ENTITIES.SOURCE_ID_INT_1%TYPE;
5988: l_event_id XLA_EVENTS.EVENT_ID%TYPE;
5989: l_calling_sequence VARCHAR2(4000);
5990: l_bug_id NUMBER;
5991: l_rev_event_id NUMBER;
5992: l_new_event_id NUMBER;