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 AP_INVOICES_ALL

Line 178: in different schemas. For example, you can find ap_invoices_all in both the ap and bifin schemas.

174: APP_EXCEPTION.RAISE_EXCEPTION;
175: end Get_Cols;
176:
177: /* Overload the Get_Cols procedure to handle the case where there are two tables with the same name
178: in different schemas. For example, you can find ap_invoices_all in both the ap and bifin schemas.
179: Without this the procedure will end with ORA-00957: duplicate column name
180: */
181:
182: PROCEDURE Get_Cols(tab_name in varchar2, schema_name in varchar2, ret_str out NOCOPY varchar2) is

Line 725: l_transaction_date AP_INVOICES_ALL.invoice_date%TYPE;

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;
726: l_transation_id number(20);
727: l_entity_code varchar2(20);
728:
729: l_api_Version NUMBER;

Line 3219: l_org_id AP_INVOICES_ALL.org_id%TYPE;

3215: p_commit_flag IN VARCHAR2,
3216: p_calling_sequence IN VARCHAR2) IS
3217:
3218: l_dummy NUMBER;
3219: l_org_id AP_INVOICES_ALL.org_id%TYPE;
3220: l_count_hist_pay NUMBER;
3221: l_cnt_unacc_inv_evnts NUMBER;
3222: l_cnt_unacc_pay_evnts NUMBER;
3223: l_cnt_untrx_inv_evnts NUMBER;

Line 3478: FROM ap_invoices_all

3474: BEGIN
3475:
3476: SELECT 1
3477: INTO l_dummy
3478: FROM ap_invoices_all
3479: WHERE invoice_id = l_invoice_id;
3480:
3481: EXCEPTION
3482: WHEN OTHERS THEN

Line 3503: FROM ap_invoices_all

3499: END IF;
3500:
3501: SELECT org_id
3502: INTO l_org_id
3503: FROM ap_invoices_all
3504: WHERE invoice_id = l_invoice_id;
3505:
3506: l_debug_info := 'Before setting the org context for the Invoice';
3507: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL ) THEN

Line 3534: FROM ap_invoices_all ai

3530: ai.invoice_amount,
3531: ai.payment_status_flag,
3532: ai.invoice_type_lookup_code)
3533: INTO l_validation_status
3534: FROM ap_invoices_all ai
3535: WHERE ai.invoice_id = l_invoice_id;
3536:
3537: IF l_validation_status NOT IN ('APPROVED','UNPAID','FULL','PERMANENT','AVAILABLE') THEN
3538: Push_Error(p_error_code => 'UNAPPROVED INVOICE : '||l_validation_status,

Line 3590: ap_invoices_all ai

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
3594: AND xte.entity_code = 'AP_INVOICES'

Line 3653: ap_invoices_all ai

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

Line 4242: FROM ap_invoices_all ai

4238: AND xe_adj.event_status_code <> 'P';
4239:
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

Line 4454: TYPE invoice_num_t IS TABLE OF AP_INVOICES_ALL.INVOICE_NUM%TYPE INDEX BY BINARY_INTEGER;

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;
4458: TYPE vendor_site_code_t IS TABLE OF AP_SUPPLIER_SITES_ALL.VENDOR_SITE_CODE%TYPE INDEX BY BINARY_INTEGER;

Line 4455: TYPE invoice_type_code_t IS TABLE OF AP_INVOICES_ALL.INVOICE_TYPE_LOOKUP_CODE%TYPE INDEX BY BINARY_INTEGER;

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;
4458: TYPE vendor_site_code_t IS TABLE OF AP_SUPPLIER_SITES_ALL.VENDOR_SITE_CODE%TYPE INDEX BY BINARY_INTEGER;
4459: TYPE org_id_t IS TABLE OF AP_INVOICES_ALL.ORG_ID%TYPE INDEX BY BINARY_INTEGER;

Line 4456: TYPE invoice_amount_t IS TABLE OF AP_INVOICES_ALL.INVOICE_AMOUNT%TYPE INDEX BY BINARY_INTEGER;

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;
4458: TYPE vendor_site_code_t IS TABLE OF AP_SUPPLIER_SITES_ALL.VENDOR_SITE_CODE%TYPE INDEX BY BINARY_INTEGER;
4459: TYPE org_id_t IS TABLE OF AP_INVOICES_ALL.ORG_ID%TYPE INDEX BY BINARY_INTEGER;
4460: TYPE set_of_books_id_t IS TABLE OF AP_INVOICES_ALL.SET_OF_BOOKS_ID%TYPE INDEX BY BINARY_INTEGER;

Line 4459: TYPE org_id_t IS TABLE OF AP_INVOICES_ALL.ORG_ID%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;
4458: TYPE vendor_site_code_t IS TABLE OF AP_SUPPLIER_SITES_ALL.VENDOR_SITE_CODE%TYPE INDEX BY BINARY_INTEGER;
4459: TYPE org_id_t IS TABLE OF AP_INVOICES_ALL.ORG_ID%TYPE INDEX BY BINARY_INTEGER;
4460: TYPE set_of_books_id_t IS TABLE OF AP_INVOICES_ALL.SET_OF_BOOKS_ID%TYPE INDEX BY BINARY_INTEGER;
4461: TYPE process_flag_t IS TABLE OF VARCHAR2(1) INDEX BY BINARY_INTEGER;
4462: TYPE error_reason_t IS TABLE OF VARCHAR2(1000) INDEX BY BINARY_INTEGER;
4463:

Line 4460: TYPE set_of_books_id_t IS TABLE OF AP_INVOICES_ALL.SET_OF_BOOKS_ID%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;
4458: TYPE vendor_site_code_t IS TABLE OF AP_SUPPLIER_SITES_ALL.VENDOR_SITE_CODE%TYPE INDEX BY BINARY_INTEGER;
4459: TYPE org_id_t IS TABLE OF AP_INVOICES_ALL.ORG_ID%TYPE INDEX BY BINARY_INTEGER;
4460: TYPE set_of_books_id_t IS TABLE OF AP_INVOICES_ALL.SET_OF_BOOKS_ID%TYPE INDEX BY BINARY_INTEGER;
4461: TYPE process_flag_t IS TABLE OF VARCHAR2(1) INDEX BY BINARY_INTEGER;
4462: TYPE error_reason_t IS TABLE OF VARCHAR2(1000) INDEX BY BINARY_INTEGER;
4463:
4464: TYPE repop_inv_rec_type IS RECORD

Line 4656: FROM ap_invoices_all

4652: BEGIN
4653: l_debug_info := 'Fetching the org_id';
4654: SELECT NVL(org_id,-99)
4655: INTO l_org_id
4656: FROM ap_invoices_all
4657: WHERE invoice_id = repop_invoices_list.source_id_l(i);
4658:
4659: IF l_org_id <> l_prev_org_id THEN
4660: l_debug_info := 'Setting the org context to org_id '||l_org_id;

Line 4851: ' ap_invoices_all ai, '||

4847: ' aps.set_of_books_id, '||
4848: ' dr.process_flag, '||
4849: ' NVL(dr.return_status,''Data Processed'') '||
4850: ' FROM '||l_driver_table||' dr, '||
4851: ' ap_invoices_all ai, '||
4852: ' ap_suppliers av, '||
4853: ' ap_supplier_sites_all avs, '||
4854: ' ap_system_parameters_all aps '||
4855: ' WHERE ai.invoice_id = dr.invoice_id'||

Line 4940: ' ap_invoices_all ai, '||

4936: ' aps.set_of_books_id, '||
4937: ' dr.process_flag, '||
4938: ' NVL(dr.return_status,''Data Processed'') '||
4939: ' FROM '||l_driver_table||' dr, '||
4940: ' ap_invoices_all ai, '||
4941: ' ap_suppliers av, '||
4942: ' ap_supplier_sites_all avs, '||
4943: ' ap_system_parameters_all aps '||
4944: ' WHERE ai.invoice_id = dr.invoice_id'||

Line 5042: TYPE invoice_num_t IS TABLE OF AP_INVOICES_ALL.INVOICE_NUM%TYPE INDEX BY BINARY_INTEGER;

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;
5046: l_check_canc_dt_col VARCHAR2(1) := 'N'; /*Bug 13602149*/

Line 5043: TYPE event_id_t IS TABLE OF AP_INVOICES_ALL.INVOICE_NUM%TYPE INDEX BY BINARY_INTEGER;

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;
5046: l_check_canc_dt_col VARCHAR2(1) := 'N'; /*Bug 13602149*/
5047: TYPE cancelled_date_t IS TABLE OF AP_INVOICES_ALL.CANCELLED_DATE%TYPE INDEX BY BINARY_INTEGER; /*Bug 13602149*/

Line 5047: TYPE cancelled_date_t IS TABLE OF AP_INVOICES_ALL.CANCELLED_DATE%TYPE INDEX BY BINARY_INTEGER; /Bug 13602149/

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;
5046: l_check_canc_dt_col VARCHAR2(1) := 'N'; /*Bug 13602149*/
5047: TYPE cancelled_date_t IS TABLE OF AP_INVOICES_ALL.CANCELLED_DATE%TYPE INDEX BY BINARY_INTEGER; /*Bug 13602149*/
5048:
5049: TYPE del_cascade_rec_type IS RECORD
5050: (source_id_l source_id_int_1_t,
5051: event_id_l event_id_t,

Line 5214: ' FROM ap_invoices_all '||

5210: l_debug_info := 'Populating the cancelled_date column in the driver table';
5211: print(l_debug_info);
5212: l_sql_stmt := 'UPDATE '||l_driver_table||' dr '||
5213: ' SET cancelled_date = (SELECT cancelled_date '||
5214: ' FROM ap_invoices_all '||
5215: ' WHERE invoice_id = dr.invoice_id)';
5216: EXECUTE IMMEDIATE l_sql_stmt;
5217:
5218: END IF;

Line 5239: l_sql_stmt := ' UPDATE ap_invoices_all '||

5235: l_debug_info := 'After the fetch, before looping for the batch of 1000';
5236: IF del_cascade_inv_list.source_id_l.COUNT > 0 THEN
5237: FOR i IN del_cascade_inv_list.source_id_l.FIRST..del_cascade_inv_list.source_id_l.LAST LOOP
5238: /*Bug 13602149*/
5239: l_sql_stmt := ' UPDATE ap_invoices_all '||
5240: ' SET force_revalidation_flag = ''Y'','||
5241: ' cancelled_date = NULL'||
5242: ' WHERE invoice_id = '||del_cascade_inv_list.source_id_l(i)||
5243: ' AND force_revalidation_flag != ''Y''';

Line 5270: l_sql_stmt := ' UPDATE ap_invoices_all '||

5266: ROLLBACK TO BEFORE_DELETION;
5267: END IF;
5268: IF l_rowcount <> 0 THEN
5269: /*Bug 13602149*/
5270: l_sql_stmt := ' UPDATE ap_invoices_all '||
5271: ' SET force_revalidation_flag = ''N'','||
5272: ' cancelled_date = NVL('||''''||del_cascade_inv_list.cancelled_date_l(i)||''''||',NULL)'||
5273: ' WHERE invoice_id = '||del_cascade_inv_list.source_id_l(i);
5274: EXECUTE IMMEDIATE l_sql_stmt;

Line 5308: ' ap_invoices_all ai'||

5304: ' ai.invoice_num, '||
5305: ' dr.process_flag, '||
5306: ' NVL(dr.del_cas_rt_sts,''Data Processed'') '||
5307: ' FROM '||l_driver_table||' dr, '||
5308: ' ap_invoices_all ai'||
5309: ' WHERE ai.invoice_id = dr.invoice_id'||
5310: ' AND dr.process_flag NOT IN (''N'',''E'') '||
5311: ' ORDER BY dr.invoice_id';
5312:

Line 5877: UPDATE ap_invoices_all

5873: FROM ap_prepay_history_all apph
5874: WHERE apph.invoice_id = p_source_id);
5875:
5876: --bug12833171
5877: UPDATE ap_invoices_all
5878: SET cancelled_date = NULL
5879: , last_updated_by = fnd_Global.User_Id
5880: WHERE invoice_id = p_source_id
5881: AND cancelled_date IS NOT NULL