APPS.OPI_DBI_BOUNDS_PKG dependencies on OPI_DBI_ORG_LE_TEMP

Line 1542: -- OPM loads. Each ETL query would join to the table OPI_DBI_ORG_LE_TEMP to extract rows

1538:
1539: /*===================================================================================
1540: -- This API would insert the ORGANIZATION_ID, LEDGER_ID, LEGAL_ENTITY_ID,COST_TYPE_ID
1541: -- for all the process orgs. This API would be called from each ETL prior to calling
1542: -- OPM loads. Each ETL query would join to the table OPI_DBI_ORG_LE_TEMP to extract rows
1543: -- from gmf_transaction_valuation for an inventory organization corresponding to a
1544: -- specific legal entity/ledger(primary)/cost type/period.
1545:
1546: Date Author Action

Line 1565: DELETE FROM OPI_DBI_ORG_LE_TEMP;

1561:
1562: -- Deleting rows from the temp table to avoid any undesirable data.
1563:
1564: l_stmt_no := 10;
1565: DELETE FROM OPI_DBI_ORG_LE_TEMP;
1566:
1567: IF l_debug_mode = 'Y' AND upper(l_module_name) like 'BIS%' THEN
1568: l_debug_msg := 'Deleted '||to_char(sql%rowcount)||' rows from OPI_DBI_ORG_LE_TEMP' ;
1569: opi_dbi_bounds_pkg.write(g_pkg_name, l_proc_name, l_stmt_no, l_debug_msg);

Line 1568: l_debug_msg := 'Deleted '||to_char(sql%rowcount)||' rows from OPI_DBI_ORG_LE_TEMP' ;

1564: l_stmt_no := 10;
1565: DELETE FROM OPI_DBI_ORG_LE_TEMP;
1566:
1567: IF l_debug_mode = 'Y' AND upper(l_module_name) like 'BIS%' THEN
1568: l_debug_msg := 'Deleted '||to_char(sql%rowcount)||' rows from OPI_DBI_ORG_LE_TEMP' ;
1569: opi_dbi_bounds_pkg.write(g_pkg_name, l_proc_name, l_stmt_no, l_debug_msg);
1570: END IF;
1571:
1572: -- Inserting rows into the temp table from org_organization_definitions and

Line 1576: INSERT INTO OPI_DBI_ORG_LE_TEMP

1572: -- Inserting rows into the temp table from org_organization_definitions and
1573: -- gmf_fiscal_policies
1574:
1575: l_stmt_no := 20;
1576: INSERT INTO OPI_DBI_ORG_LE_TEMP
1577: (
1578: organization_id ,
1579: ledger_id ,
1580: legal_entity_id ,

Line 1595: l_debug_msg := 'Inserted '||to_char(sql%rowcount)||' rows from OPI_DBI_ORG_LE_TEMP' ;

1591: AND mp.organization_id = ood.organization_id
1592: AND ood.legal_entity = gfp.legal_entity_id ;
1593:
1594: IF l_debug_mode = 'Y' AND upper(l_module_name) like 'BIS%' THEN
1595: l_debug_msg := 'Inserted '||to_char(sql%rowcount)||' rows from OPI_DBI_ORG_LE_TEMP' ;
1596: opi_dbi_bounds_pkg.write(g_pkg_name, l_proc_name, l_stmt_no, l_debug_msg);
1597: END IF;
1598:
1599: EXCEPTION

Line 1602: l_debug_msg := 'Error in deleting/inserting OPM org ledger data into OPI_DBI_ORG_LE_TEMP' ;

1598:
1599: EXCEPTION
1600: WHEN OTHERS THEN
1601: IF l_debug_mode = 'Y' AND upper(l_module_name) like 'BIS%' THEN
1602: l_debug_msg := 'Error in deleting/inserting OPM org ledger data into OPI_DBI_ORG_LE_TEMP' ;
1603: opi_dbi_bounds_pkg.write(g_pkg_name, l_proc_name, l_stmt_no, l_debug_msg);
1604: END IF;
1605: RAISE;
1606: END load_opm_org_ledger_data;