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.AP_ACCTG_DATA_FIX_PKG dependencies on XLA_TRANSACTION_ENTITIES

Line 120: ' as select * from XLA_TRANSACTION_ENTITIES where rownum<1 ';

116: ' add datafix_update_date date default sysdate';
117:
118: Execute Immediate
119: 'create table '||'TRANS_ENTITIES_'||P_Bug_Number||
120: ' as select * from XLA_TRANSACTION_ENTITIES where rownum<1 ';
121:
122: Execute Immediate
123: 'alter table '||'TRANS_ENTITIES_'||P_Bug_Number||
124: ' add datafix_update_date date default sysdate';

Line 878: FROM xla_transaction_entities_upg xte

874: l_event_source_info.entity_type_code,
875: l_event_source_info.source_id_int_1,
876: l_event_source_info.transaction_number,
877: l_event_source_info.application_id
878: FROM xla_transaction_entities_upg xte
879: WHERE xte.application_id = 200
880: AND xte.entity_id = l_entity_id;
881:
882: EXCEPTION

Line 1013: FROM xla_transaction_entities_upg xte

1009: INTO l_dummy
1010: FROM dual
1011: WHERE EXISTS
1012: (SELECT 1
1013: FROM xla_transaction_entities_upg xte
1014: WHERE xte.application_id = 200
1015: AND xte.entity_id = l_entity_id);
1016:
1017: EXCEPTION

Line 1107: TYPE source_id_int_1_t IS TABLE OF XLA_TRANSACTION_ENTITIES.SOURCE_ID_INT_1%TYPE INDEX BY BINARY_INTEGER;

1103: TYPE event_type_code_t IS TABLE OF XLA_AE_HEADERS.EVENT_TYPE_CODE%TYPE INDEX BY BINARY_INTEGER;
1104: TYPE ae_header_id_t IS TABLE OF XLA_AE_HEADERS.AE_HEADER_ID%TYPE INDEX BY BINARY_INTEGER;
1105: TYPE accounting_date_t IS TABLE OF XLA_AE_HEADERS.ACCOUNTING_DATE%TYPE INDEX BY BINARY_INTEGER;
1106: TYPE source_type_t IS TABLE OF VARCHAR2(100) INDEX BY BINARY_INTEGER;
1107: TYPE source_id_int_1_t IS TABLE OF XLA_TRANSACTION_ENTITIES.SOURCE_ID_INT_1%TYPE INDEX BY BINARY_INTEGER;
1108: TYPE transaction_number_t IS TABLE OF XLA_TRANSACTION_ENTITIES.TRANSACTION_NUMBER%TYPE INDEX BY BINARY_INTEGER;
1109: TYPE security_id_int_1_t IS TABLE OF XLA_TRANSACTION_ENTITIES.SECURITY_ID_INT_1%TYPE INDEX BY BINARY_INTEGER;
1110: TYPE period_name_t IS TABLE OF GL_PERIOD_STATUSES.PERIOD_NAME%TYPE INDEX BY BINARY_INTEGER;
1111: TYPE closing_status_t IS TABLE OF VARCHAR2(100) INDEX BY BINARY_INTEGER;

Line 1108: TYPE transaction_number_t IS TABLE OF XLA_TRANSACTION_ENTITIES.TRANSACTION_NUMBER%TYPE INDEX BY BINARY_INTEGER;

1104: TYPE ae_header_id_t IS TABLE OF XLA_AE_HEADERS.AE_HEADER_ID%TYPE INDEX BY BINARY_INTEGER;
1105: TYPE accounting_date_t IS TABLE OF XLA_AE_HEADERS.ACCOUNTING_DATE%TYPE INDEX BY BINARY_INTEGER;
1106: TYPE source_type_t IS TABLE OF VARCHAR2(100) INDEX BY BINARY_INTEGER;
1107: TYPE source_id_int_1_t IS TABLE OF XLA_TRANSACTION_ENTITIES.SOURCE_ID_INT_1%TYPE INDEX BY BINARY_INTEGER;
1108: TYPE transaction_number_t IS TABLE OF XLA_TRANSACTION_ENTITIES.TRANSACTION_NUMBER%TYPE INDEX BY BINARY_INTEGER;
1109: TYPE security_id_int_1_t IS TABLE OF XLA_TRANSACTION_ENTITIES.SECURITY_ID_INT_1%TYPE INDEX BY BINARY_INTEGER;
1110: TYPE period_name_t IS TABLE OF GL_PERIOD_STATUSES.PERIOD_NAME%TYPE INDEX BY BINARY_INTEGER;
1111: TYPE closing_status_t IS TABLE OF VARCHAR2(100) INDEX BY BINARY_INTEGER;
1112: TYPE ledger_name_t IS TABLE OF GL_LEDGERS.NAME%TYPE INDEX BY BINARY_INTEGER;

Line 1109: TYPE security_id_int_1_t IS TABLE OF XLA_TRANSACTION_ENTITIES.SECURITY_ID_INT_1%TYPE INDEX BY BINARY_INTEGER;

1105: TYPE accounting_date_t IS TABLE OF XLA_AE_HEADERS.ACCOUNTING_DATE%TYPE INDEX BY BINARY_INTEGER;
1106: TYPE source_type_t IS TABLE OF VARCHAR2(100) INDEX BY BINARY_INTEGER;
1107: TYPE source_id_int_1_t IS TABLE OF XLA_TRANSACTION_ENTITIES.SOURCE_ID_INT_1%TYPE INDEX BY BINARY_INTEGER;
1108: TYPE transaction_number_t IS TABLE OF XLA_TRANSACTION_ENTITIES.TRANSACTION_NUMBER%TYPE INDEX BY BINARY_INTEGER;
1109: TYPE security_id_int_1_t IS TABLE OF XLA_TRANSACTION_ENTITIES.SECURITY_ID_INT_1%TYPE INDEX BY BINARY_INTEGER;
1110: TYPE period_name_t IS TABLE OF GL_PERIOD_STATUSES.PERIOD_NAME%TYPE INDEX BY BINARY_INTEGER;
1111: TYPE closing_status_t IS TABLE OF VARCHAR2(100) INDEX BY BINARY_INTEGER;
1112: TYPE ledger_name_t IS TABLE OF GL_LEDGERS.NAME%TYPE INDEX BY BINARY_INTEGER;
1113:

Line 1236: ' xla_transaction_entities_upg xte, '||

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, '||
1238: ' gl_ledgers gl '||
1239: ' WHERE xe.application_id = 200 '||
1240: ' AND xah.application_id =200 '||

Line 1372: ' xla_transaction_entities_upg xte, '||

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, '||
1374: ' gl_ledgers gl '||
1375: ' WHERE xe.application_id = 200 '||
1376: ' AND xah.application_id =200 '||

Line 1529: ' xla_transaction_entities_upg xte '||

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 '||
1532: ' AND nvl(glps.adjustment_period_flag, ''N'') = ''N'' '||
1533: ' AND glps.set_of_books_id = xte.ledger_id '||

Line 1552: ' xla_transaction_entities_upg xte, '||

1548: ' AND dr.calculated_undo_date IS NULL '||
1549: ' AND NOT EXISTS '||
1550: ' (SELECT 1 '||
1551: ' FROM gl_period_statuses glps, '||
1552: ' xla_transaction_entities_upg xte, '||
1553: ' xla_ae_headers xah '||
1554: ' WHERE (glps.application_id = 101 OR '||
1555: ' (glps.application_id = 200 AND '||
1556: ' xah.ledger_id = xte.ledger_id)) '||

Line 1583: ' xla_transaction_entities_upg xte '||

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 '||
1586: ' AND nvl(glps.adjustment_period_flag, ''N'') = ''N'' '||
1587: ' AND glps.set_of_books_id = xte.ledger_id '||

Line 1606: ' xla_transaction_entities_upg xte, '||

1602: ' AND dr.calculated_undo_date IS NULL '||
1603: ' AND NOT EXISTS '||
1604: ' (SELECT 1 '||
1605: ' FROM gl_period_statuses glps, '||
1606: ' xla_transaction_entities_upg xte, '||
1607: ' xla_ae_headers xah '||
1608: ' WHERE (glps.application_id = 101 OR '||
1609: ' (glps.application_id = 200 AND '||
1610: ' xah.ledger_id = xte.ledger_id)) '||

Line 1635: ' xla_transaction_entities_upg xte '||

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 '||
1638: ' AND nvl(glps.adjustment_period_flag, ''N'') = ''N'' '||
1639: ' AND glps.set_of_books_id = xte.ledger_id '||

Line 1658: ' xla_transaction_entities_upg xte, '||

1654: ' AND dr.calculated_undo_date IS NULL '||
1655: ' AND NOT EXISTS '||
1656: ' (SELECT 1 '||
1657: ' FROM gl_period_statuses glps, '||
1658: ' xla_transaction_entities_upg xte, '||
1659: ' xla_ae_headers xah '||
1660: ' WHERE (glps.application_id = 101 OR '||
1661: ' (glps.application_id = 200 AND '||
1662: ' xah.ledger_id = xte.ledger_id)) '||

Line 1719: TYPE source_id_int_1_t IS TABLE OF XLA_TRANSACTION_ENTITIES.SOURCE_ID_INT_1%TYPE INDEX BY BINARY_INTEGER;

1715: TYPE accounting_date_t IS TABLE OF XLA_AE_HEADERS.ACCOUNTING_DATE%TYPE INDEX BY BINARY_INTEGER;
1716: TYPE ae_line_num_t IS TABLE OF XLA_AE_LINES.AE_LINE_NUM%TYPE INDEX BY BINARY_INTEGER;
1717: TYPE accounting_class_code_t IS TABLE OF XLA_AE_LINES.ACCOUNTING_CLASS_CODE%TYPE INDEX BY BINARY_INTEGER;
1718: TYPE source_type_t IS TABLE OF VARCHAR2(100) INDEX BY BINARY_INTEGER;
1719: TYPE source_id_int_1_t IS TABLE OF XLA_TRANSACTION_ENTITIES.SOURCE_ID_INT_1%TYPE INDEX BY BINARY_INTEGER;
1720: TYPE transaction_number_t IS TABLE OF XLA_TRANSACTION_ENTITIES.TRANSACTION_NUMBER%TYPE INDEX BY BINARY_INTEGER;
1721: TYPE security_id_int_1_t IS TABLE OF XLA_TRANSACTION_ENTITIES.SECURITY_ID_INT_1%TYPE INDEX BY BINARY_INTEGER;
1722: TYPE code_combination_id_t IS TABLE OF GL_CODE_COMBINATIONS.CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
1723: TYPE account_t IS TABLE OF VARCHAR2(1000) INDEX BY BINARY_INTEGER;

Line 1720: TYPE transaction_number_t IS TABLE OF XLA_TRANSACTION_ENTITIES.TRANSACTION_NUMBER%TYPE INDEX BY BINARY_INTEGER;

1716: TYPE ae_line_num_t IS TABLE OF XLA_AE_LINES.AE_LINE_NUM%TYPE INDEX BY BINARY_INTEGER;
1717: TYPE accounting_class_code_t IS TABLE OF XLA_AE_LINES.ACCOUNTING_CLASS_CODE%TYPE INDEX BY BINARY_INTEGER;
1718: TYPE source_type_t IS TABLE OF VARCHAR2(100) INDEX BY BINARY_INTEGER;
1719: TYPE source_id_int_1_t IS TABLE OF XLA_TRANSACTION_ENTITIES.SOURCE_ID_INT_1%TYPE INDEX BY BINARY_INTEGER;
1720: TYPE transaction_number_t IS TABLE OF XLA_TRANSACTION_ENTITIES.TRANSACTION_NUMBER%TYPE INDEX BY BINARY_INTEGER;
1721: TYPE security_id_int_1_t IS TABLE OF XLA_TRANSACTION_ENTITIES.SECURITY_ID_INT_1%TYPE INDEX BY BINARY_INTEGER;
1722: TYPE code_combination_id_t IS TABLE OF GL_CODE_COMBINATIONS.CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
1723: TYPE account_t IS TABLE OF VARCHAR2(1000) INDEX BY BINARY_INTEGER;
1724: TYPE enabled_flag_t IS TABLE OF GL_CODE_COMBINATIONS.ENABLED_FLAG%TYPE INDEX BY BINARY_INTEGER;

Line 1721: TYPE security_id_int_1_t IS TABLE OF XLA_TRANSACTION_ENTITIES.SECURITY_ID_INT_1%TYPE INDEX BY BINARY_INTEGER;

1717: TYPE accounting_class_code_t IS TABLE OF XLA_AE_LINES.ACCOUNTING_CLASS_CODE%TYPE INDEX BY BINARY_INTEGER;
1718: TYPE source_type_t IS TABLE OF VARCHAR2(100) INDEX BY BINARY_INTEGER;
1719: TYPE source_id_int_1_t IS TABLE OF XLA_TRANSACTION_ENTITIES.SOURCE_ID_INT_1%TYPE INDEX BY BINARY_INTEGER;
1720: TYPE transaction_number_t IS TABLE OF XLA_TRANSACTION_ENTITIES.TRANSACTION_NUMBER%TYPE INDEX BY BINARY_INTEGER;
1721: TYPE security_id_int_1_t IS TABLE OF XLA_TRANSACTION_ENTITIES.SECURITY_ID_INT_1%TYPE INDEX BY BINARY_INTEGER;
1722: TYPE code_combination_id_t IS TABLE OF GL_CODE_COMBINATIONS.CODE_COMBINATION_ID%TYPE INDEX BY BINARY_INTEGER;
1723: TYPE account_t IS TABLE OF VARCHAR2(1000) INDEX BY BINARY_INTEGER;
1724: TYPE enabled_flag_t IS TABLE OF GL_CODE_COMBINATIONS.ENABLED_FLAG%TYPE INDEX BY BINARY_INTEGER;
1725: TYPE end_date_active_t IS TABLE OF GL_CODE_COMBINATIONS.END_DATE_ACTIVE%TYPE INDEX BY BINARY_INTEGER;

Line 1786: ' xla_transaction_entities_upg xte, '||

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, '||
1787: ' gl_code_combinations_kfv glcc, '||
1788: ' gl_ledgers gl '||
1789: ' WHERE xe.application_id = 200 '||
1790: ' AND xah.application_id = 200 '||

Line 1969: FROM xla_transaction_entities_upg xte,

1965: security_id_int_1 cur_org_id,
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

Line 2535: l_source_table XLA_TRANSACTION_ENTITIES.ENTITY_CODE%TYPE;

2531: p_calling_sequence IN VARCHAR2 DEFAULT NULL,
2532: p_bug_id IN NUMBER DEFAULT NULL,
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;

Line 2536: l_source_id XLA_TRANSACTION_ENTITIES.SOURCE_ID_INT_1%TYPE;

2532: p_bug_id IN NUMBER DEFAULT NULL,
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;

Line 2628: TYPE source_id_int_1_t IS TABLE OF XLA_TRANSACTION_ENTITIES.SOURCE_ID_INT_1%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;
2630: TYPE transaction_number_t IS TABLE OF XLA_TRANSACTION_ENTITIES.TRANSACTION_NUMBER%TYPE INDEX BY BINARY_INTEGER;
2631: TYPE entity_code_t IS TABLE OF XLA_TRANSACTION_ENTITIES.ENTITY_CODE%TYPE INDEX BY BINARY_INTEGER;
2632: TYPE ae_line_num_t IS TABLE OF XLA_AE_LINES.AE_LINE_NUM%TYPE INDEX BY BINARY_INTEGER;

Line 2629: TYPE org_id_t IS TABLE OF XLA_TRANSACTION_ENTITIES.SECURITY_ID_INT_1%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;
2630: TYPE transaction_number_t IS TABLE OF XLA_TRANSACTION_ENTITIES.TRANSACTION_NUMBER%TYPE INDEX BY BINARY_INTEGER;
2631: TYPE entity_code_t IS TABLE OF XLA_TRANSACTION_ENTITIES.ENTITY_CODE%TYPE INDEX BY BINARY_INTEGER;
2632: TYPE ae_line_num_t IS TABLE OF XLA_AE_LINES.AE_LINE_NUM%TYPE INDEX BY BINARY_INTEGER;
2633: TYPE padded_concatenated_segments_t IS TABLE OF GL_CODE_COMBINATIONS_KFV.PADDED_CONCATENATED_SEGMENTS%TYPE INDEX BY BINARY_INTEGER;

Line 2630: TYPE transaction_number_t IS TABLE OF XLA_TRANSACTION_ENTITIES.TRANSACTION_NUMBER%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;
2630: TYPE transaction_number_t IS TABLE OF XLA_TRANSACTION_ENTITIES.TRANSACTION_NUMBER%TYPE INDEX BY BINARY_INTEGER;
2631: TYPE entity_code_t IS TABLE OF XLA_TRANSACTION_ENTITIES.ENTITY_CODE%TYPE INDEX BY BINARY_INTEGER;
2632: TYPE ae_line_num_t IS TABLE OF XLA_AE_LINES.AE_LINE_NUM%TYPE INDEX BY BINARY_INTEGER;
2633: TYPE padded_concatenated_segments_t IS TABLE OF GL_CODE_COMBINATIONS_KFV.PADDED_CONCATENATED_SEGMENTS%TYPE INDEX BY BINARY_INTEGER;
2634: TYPE entered_dr_t IS TABLE OF XLA_AE_LINES.ENTERED_DR%TYPE INDEX BY BINARY_INTEGER;

Line 2631: TYPE entity_code_t IS TABLE OF XLA_TRANSACTION_ENTITIES.ENTITY_CODE%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;
2630: TYPE transaction_number_t IS TABLE OF XLA_TRANSACTION_ENTITIES.TRANSACTION_NUMBER%TYPE INDEX BY BINARY_INTEGER;
2631: TYPE entity_code_t IS TABLE OF XLA_TRANSACTION_ENTITIES.ENTITY_CODE%TYPE INDEX BY BINARY_INTEGER;
2632: TYPE ae_line_num_t IS TABLE OF XLA_AE_LINES.AE_LINE_NUM%TYPE INDEX BY BINARY_INTEGER;
2633: TYPE padded_concatenated_segments_t IS TABLE OF GL_CODE_COMBINATIONS_KFV.PADDED_CONCATENATED_SEGMENTS%TYPE INDEX BY BINARY_INTEGER;
2634: TYPE entered_dr_t IS TABLE OF XLA_AE_LINES.ENTERED_DR%TYPE INDEX BY BINARY_INTEGER;
2635: TYPE entered_cr_t IS TABLE OF XLA_AE_LINES.ENTERED_CR%TYPE INDEX BY BINARY_INTEGER;

Line 2754: ' FROM xla_transaction_entities_upg xte, '||

2750: ' xte.security_id_int_1, '||
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 '||

Line 2930: ' xla_transaction_entities_upg xte, '||

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, '||
2932: ' gl_ledgers gl '||
2933: ' WHERE xe.application_id = 200 '||
2934: ' AND xah.application_id = 200 '||

Line 2975: ' xla_transaction_entities_upg xte, '||

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, '||
2977: ' gl_ledgers gl '||
2978: ' WHERE xe.application_id = 200 '||
2979: ' AND xah.application_id = 200 '||

Line 3090: ' FROM xla_transaction_entities_upg xte, '||

3086: ' ''UNEXPECTED_EXCEPTION'', ''Unexpected Exception Occurred'', '||
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 '||

Line 3271: xla_transaction_entities_upg XTE

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
3275: AND XE.event_id = p_event_id;

Line 3556: xla_transaction_entities_upg xte,

3552: SELECT count(*)
3553: INTO l_count_hist_pay
3554: FROM ap_invoice_payments_all aip,
3555: xla_ae_headers xah,
3556: xla_transaction_entities_upg xte,
3557: xla_ae_lines xal
3558: WHERE xah.application_id = 200
3559: AND aip.check_id = nvl(xte.source_id_int_1, -99)
3560: AND aip.set_of_books_id = xte.ledger_id

Line 3589: xla_transaction_entities_upg xte,

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
3593: AND xe.entity_id = xte.entity_id

Line 3619: xla_transaction_entities_upg xte,

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
3623: AND xte.entity_code = 'AP_PAYMENTS'

Line 3652: xla_transaction_entities_upg xte,

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
3655: AND xte.application_id = 200
3656: AND xah.application_id = 200

Line 3685: xla_transaction_entities_upg xte,

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
3688: AND xte.application_id = 200
3689: AND xte.entity_code = 'AP_PAYMENTS'

Line 3935: FROM xla_transaction_entities_upg xte,

3931:
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

Line 4313: FROM xla_transaction_entities_upg xte

4309: l_event_source_info.entity_type_code,
4310: l_event_source_info.source_id_int_1,
4311: l_event_source_info.transaction_number,
4312: l_event_source_info.application_id
4313: FROM xla_transaction_entities_upg xte
4314: WHERE NVL(xte.source_id_int_1, -99) = p_source_id
4315: AND xte.entity_code = p_source_type
4316: AND xte.application_id = 200;
4317:

Line 4453: TYPE source_id_int_1_t IS TABLE OF XLA_TRANSACTION_ENTITIES.SOURCE_ID_INT_1%TYPE INDEX BY BINARY_INTEGER;

4449: TYPE refcurtyp IS REF CURSOR;
4450: drv_invoices_cur REFCURTYP;
4451: drv_status_cur REFCURTYP;
4452:
4453: TYPE source_id_int_1_t IS TABLE OF XLA_TRANSACTION_ENTITIES.SOURCE_ID_INT_1%TYPE INDEX BY BINARY_INTEGER;
4454: TYPE invoice_num_t IS TABLE OF AP_INVOICES_ALL.INVOICE_NUM%TYPE INDEX BY BINARY_INTEGER;
4455: TYPE invoice_type_code_t IS TABLE OF AP_INVOICES_ALL.INVOICE_TYPE_LOOKUP_CODE%TYPE INDEX BY BINARY_INTEGER;
4456: TYPE invoice_amount_t IS TABLE OF AP_INVOICES_ALL.INVOICE_AMOUNT%TYPE INDEX BY BINARY_INTEGER;
4457: TYPE vendor_name_t IS TABLE OF AP_SUPPLIERS.vendor_name%TYPE INDEX BY BINARY_INTEGER;

Line 5041: TYPE source_id_int_1_t IS TABLE OF XLA_TRANSACTION_ENTITIES.SOURCE_ID_INT_1%TYPE INDEX BY BINARY_INTEGER;

5037: TYPE refcurtyp IS REF CURSOR;
5038: drv_invoices_cur REFCURTYP;
5039: drv_status_cur REFCURTYP;
5040:
5041: TYPE source_id_int_1_t IS TABLE OF XLA_TRANSACTION_ENTITIES.SOURCE_ID_INT_1%TYPE INDEX BY BINARY_INTEGER;
5042: TYPE invoice_num_t IS TABLE OF AP_INVOICES_ALL.INVOICE_NUM%TYPE INDEX BY BINARY_INTEGER;
5043: TYPE event_id_t IS TABLE OF AP_INVOICES_ALL.INVOICE_NUM%TYPE INDEX BY BINARY_INTEGER;
5044: TYPE process_flag_t IS TABLE OF VARCHAR2(1) INDEX BY BINARY_INTEGER;
5045: TYPE error_reason_t IS TABLE OF VARCHAR2(1000) INDEX BY BINARY_INTEGER;

Line 5411: FROM xla_transaction_entities_upg xte

5407: , security_id_int_1 cur_org_id
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

Line 5986: l_source_table XLA_TRANSACTION_ENTITIES.ENTITY_CODE%TYPE;

5982: p_calling_sequence IN VARCHAR2 DEFAULT NULL,
5983: p_bug_id IN NUMBER DEFAULT NULL,
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;

Line 5987: l_source_id XLA_TRANSACTION_ENTITIES.SOURCE_ID_INT_1%TYPE;

5983: p_bug_id IN NUMBER DEFAULT NULL,
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;