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.OPI_DBI_INV_VALUE_INIT_PKG dependencies on OPI_DBI_RPT_UTIL_PKG

Line 16: --OPI_DBI_RPT_UTIL_PKG.g_pk_uom_conversion number;

12: g_global_sec_rate_type VARCHAR2(32);
13: g_R12_date DATE;
14: g_pkg_name CONSTANT VARCHAR2(200) := 'OPI_DBI_INV_VALUE_INIT_PKG';
15: g_opi_schema VARCHAR2(10);
16: --OPI_DBI_RPT_UTIL_PKG.g_pk_uom_conversion number;
17: -- User Defined Exceptions
18:
19: INITIALIZATION_ERROR EXCEPTION;
20: PRAGMA EXCEPTION_INIT (INITIALIZATION_ERROR, -20900);

Line 1190: OPI_DBI_RPT_UTIL_PKG.g_pk_uom_conversion := 1;

1186: l_debug_msg := 'Inserting data into OPI_DBI_INV_BEG_STG for Intransit Inception load ';
1187: OPI_DBI_BOUNDS_PKG.write (g_pkg_name,l_proc_name,l_stmt_num, l_debug_msg );
1188: END IF;
1189:
1190: OPI_DBI_RPT_UTIL_PKG.g_pk_uom_conversion := 1;
1191:
1192: INSERT /*+ append parallel(opi_dbi_intransit_stg) */
1193: INTO OPI_DBI_INV_BEG_STG
1194: ( organization_id ,

Line 1225: OPI_DBI_RPT_UTIL_PKG.OPI_UM_CONVERT(mmt1.inventory_item_id,mmt1.primary_quantity , msi_fm.primary_uom_code,msi_to.primary_uom_code)),

1221: mmt1.primary_quantity), --Bug 4878458
1222: decode (mmt1.transaction_action_id,
1223: 21,decode (mip.fob_point,
1224: 2, mmt1.primary_quantity,
1225: OPI_DBI_RPT_UTIL_PKG.OPI_UM_CONVERT(mmt1.inventory_item_id,mmt1.primary_quantity , msi_fm.primary_uom_code,msi_to.primary_uom_code)),
1226: 12,decode (mip.fob_point,
1227: 2,OPI_DBI_RPT_UTIL_PKG.OPI_UM_CONVERT(mmt1.inventory_item_id, mmt1.primary_quantity , msi_fm.primary_uom_code,msi_to.primary_uom_code),
1228: mmt1.primary_quantity)))) tot_prim_qty,
1229: decode(Mip.owning_org_process_flag -- this need only for cost group id, As For OPM it is -1

Line 1227: 2,OPI_DBI_RPT_UTIL_PKG.OPI_UM_CONVERT(mmt1.inventory_item_id, mmt1.primary_quantity , msi_fm.primary_uom_code,msi_to.primary_uom_code),

1223: 21,decode (mip.fob_point,
1224: 2, mmt1.primary_quantity,
1225: OPI_DBI_RPT_UTIL_PKG.OPI_UM_CONVERT(mmt1.inventory_item_id,mmt1.primary_quantity , msi_fm.primary_uom_code,msi_to.primary_uom_code)),
1226: 12,decode (mip.fob_point,
1227: 2,OPI_DBI_RPT_UTIL_PKG.OPI_UM_CONVERT(mmt1.inventory_item_id, mmt1.primary_quantity , msi_fm.primary_uom_code,msi_to.primary_uom_code),
1228: mmt1.primary_quantity)))) tot_prim_qty,
1229: decode(Mip.owning_org_process_flag -- this need only for cost group id, As For OPM it is -1
1230: ,'N',decode (mmt1.transaction_action_id,
1231: 21,decode (mip.fob_point,

Line 1306: if OPI_DBI_RPT_UTIL_PKG.g_pk_uom_conversion <>1 then

1302: cost_group_id,
1303: g_global_start_date
1304: HAVING SUM(xy.tot_prim_qty) <>0 ;
1305:
1306: if OPI_DBI_RPT_UTIL_PKG.g_pk_uom_conversion <>1 then
1307: Raise UOM_CONV_ERROR;
1308: end if;
1309: l_debug_msg := 'Inserted into staging table OPI_DBI_INV_BEG_STG - ' || SQL%ROWCOUNT || ' rows. ';
1310: OPI_DBI_BOUNDS_PKG.write(g_pkg_name, l_proc_name,l_stmt_num, l_debug_msg);

Line 1577: OPI_DBI_RPT_UTIL_PKG.g_pk_uom_conversion := 1;

1573: -- 15 is logical receipt and 22 is logical shipment.
1574: -- both these logical txns always has txn_organization same as owning organization.
1575: -- refer to detail use cases in DLD for this.
1576: -- The quantity on these txns is also the +ve intransit quantity.
1577: OPI_DBI_RPT_UTIL_PKG.g_pk_uom_conversion := 1;
1578: INSERT /*+ append */ INTO OPI_DBI_INTRANSIT_STG(
1579: organization_id,
1580: inventory_item_id,
1581: transaction_date,

Line 1625: OPI_DBI_RPT_UTIL_PKG.OPI_UM_CONVERT(mmt1.inventory_item_id,mmt1.primary_quantity , msi_fm.primary_uom_code,msi_to.primary_uom_code)

1621: mmt1.transaction_action_id,
1622: 21, DECODE( -- intransit shipment
1623: mip.fob_point, -- FOB 2 is receipt
1624: 2, mmt1.primary_quantity,
1625: OPI_DBI_RPT_UTIL_PKG.OPI_UM_CONVERT(mmt1.inventory_item_id,mmt1.primary_quantity , msi_fm.primary_uom_code,msi_to.primary_uom_code)
1626: ),
1627: 12, DECODE ( -- inransit receipt
1628: mip.fob_point,
1629: 2, OPI_DBI_RPT_UTIL_PKG.OPI_UM_CONVERT(mmt1.inventory_item_id,mmt1.primary_quantity , msi_fm.primary_uom_code,msi_to.primary_uom_code),

Line 1629: 2, OPI_DBI_RPT_UTIL_PKG.OPI_UM_CONVERT(mmt1.inventory_item_id,mmt1.primary_quantity , msi_fm.primary_uom_code,msi_to.primary_uom_code),

1625: OPI_DBI_RPT_UTIL_PKG.OPI_UM_CONVERT(mmt1.inventory_item_id,mmt1.primary_quantity , msi_fm.primary_uom_code,msi_to.primary_uom_code)
1626: ),
1627: 12, DECODE ( -- inransit receipt
1628: mip.fob_point,
1629: 2, OPI_DBI_RPT_UTIL_PKG.OPI_UM_CONVERT(mmt1.inventory_item_id,mmt1.primary_quantity , msi_fm.primary_uom_code,msi_to.primary_uom_code),
1630: mmt1.primary_quantity),
1631: 22, mmt1.primary_quantity, -- Absolute value fix
1632: 15, -1 * mmt1.primary_quantity))) qty,
1633: SUM (base_transaction_value) value,

Line 1718: if OPI_DBI_RPT_UTIL_PKG.g_pk_uom_conversion <> 1 then

1714: trx_date,
1715: decode(process_flag,'N',1,2) -- Bug fix: 5362465
1716: HAVING sum(value) <> 0 or sum(qty) <> 0;
1717:
1718: if OPI_DBI_RPT_UTIL_PKG.g_pk_uom_conversion <> 1 then
1719: Raise UOM_CONV_ERROR;
1720: end if ;
1721:
1722: l_debug_msg := 'Inserted into staging table opi_dbi_intransit_stg - ' || SQL%ROWCOUNT || ' rows. ';

Line 1736: OPI_DBI_RPT_UTIL_PKG.g_pk_uom_conversion := 1;

1732:
1733: -- extract to collect process orgs intransit data
1734: -- process does not support cost updates for intransit data hence
1735: -- no separate extract to get cost update data.
1736: OPI_DBI_RPT_UTIL_PKG.g_pk_uom_conversion := 1;
1737:
1738: INSERT /*+ APPEND */ INTO OPI_DBI_INTRANSIT_STG(
1739: organization_id,
1740: inventory_item_id,

Line 1786: OPI_DBI_RPT_UTIL_PKG.OPI_UM_CONVERT(mmt1.inventory_item_id,mmt1.primary_quantity , msi_fm.primary_uom_code,msi_to.primary_uom_code)

1782: mmt1.primary_quantity),
1783: DECODE (mmt1.transaction_action_id,
1784: 21, DECODE (mip.fob_point,
1785: 2, mmt1.primary_quantity,
1786: OPI_DBI_RPT_UTIL_PKG.OPI_UM_CONVERT(mmt1.inventory_item_id,mmt1.primary_quantity , msi_fm.primary_uom_code,msi_to.primary_uom_code)
1787: ),
1788: 12, DECODE (mip.fob_point,
1789: 2,OPI_DBI_RPT_UTIL_PKG.OPI_UM_CONVERT(mmt1.inventory_item_id, mmt1.primary_quantity , msi_fm.primary_uom_code,msi_to.primary_uom_code),
1790: mmt1.primary_quantity),

Line 1789: 2,OPI_DBI_RPT_UTIL_PKG.OPI_UM_CONVERT(mmt1.inventory_item_id, mmt1.primary_quantity , msi_fm.primary_uom_code,msi_to.primary_uom_code),

1785: 2, mmt1.primary_quantity,
1786: OPI_DBI_RPT_UTIL_PKG.OPI_UM_CONVERT(mmt1.inventory_item_id,mmt1.primary_quantity , msi_fm.primary_uom_code,msi_to.primary_uom_code)
1787: ),
1788: 12, DECODE (mip.fob_point,
1789: 2,OPI_DBI_RPT_UTIL_PKG.OPI_UM_CONVERT(mmt1.inventory_item_id, mmt1.primary_quantity , msi_fm.primary_uom_code,msi_to.primary_uom_code),
1790: mmt1.primary_quantity),
1791: 22, mmt1.primary_quantity ,-- Absolute value fix ,no need of conversion ??
1792: 15, -1 * mmt1.primary_quantity
1793: )))) qty,-- Bug 4901338, removed ,0

Line 1805: OPI_DBI_RPT_UTIL_PKG.OPI_UM_CONVERT(mmt1.inventory_item_id, mmt1.primary_quantity , msi_fm.primary_uom_code,msi_to.primary_uom_code)),

1801: mmt1.primary_quantity),
1802: DECODE (mmt1.transaction_action_id,
1803: 21, DECODE (mip.fob_point,
1804: 2, mmt1.primary_quantity,
1805: OPI_DBI_RPT_UTIL_PKG.OPI_UM_CONVERT(mmt1.inventory_item_id, mmt1.primary_quantity , msi_fm.primary_uom_code,msi_to.primary_uom_code)),
1806: 12, DECODE (mip.fob_point,
1807: 2, OPI_DBI_RPT_UTIL_PKG.OPI_UM_CONVERT(mmt1.inventory_item_id, mmt1.primary_quantity , msi_fm.primary_uom_code,msi_to.primary_uom_code),
1808: mmt1.primary_quantity),
1809: 22, mmt1.primary_quantity ,-- Absolute value fix no need of conversion ??

Line 1807: 2, OPI_DBI_RPT_UTIL_PKG.OPI_UM_CONVERT(mmt1.inventory_item_id, mmt1.primary_quantity , msi_fm.primary_uom_code,msi_to.primary_uom_code),

1803: 21, DECODE (mip.fob_point,
1804: 2, mmt1.primary_quantity,
1805: OPI_DBI_RPT_UTIL_PKG.OPI_UM_CONVERT(mmt1.inventory_item_id, mmt1.primary_quantity , msi_fm.primary_uom_code,msi_to.primary_uom_code)),
1806: 12, DECODE (mip.fob_point,
1807: 2, OPI_DBI_RPT_UTIL_PKG.OPI_UM_CONVERT(mmt1.inventory_item_id, mmt1.primary_quantity , msi_fm.primary_uom_code,msi_to.primary_uom_code),
1808: mmt1.primary_quantity),
1809: 22, mmt1.primary_quantity ,-- Absolute value fix no need of conversion ??
1810: 15, -1 * mmt1.primary_quantity
1811: )),0)) Draft_qty,

Line 1873: if OPI_DBI_RPT_UTIL_PKG.g_pk_uom_conversion <> 1 then

1869: trx_date,
1870: decode(process_flag,'N',1,2) -- Bug fix: 5362465
1871: HAVING sum(value) <> 0 or sum(qty) <> 0 OR sum(draft_value) <> 0 OR sum(draft_qty) <> 0 ;
1872:
1873: if OPI_DBI_RPT_UTIL_PKG.g_pk_uom_conversion <> 1 then
1874: Raise UOM_CONV_ERROR;
1875: end if;
1876: commit;
1877:

Line 2907: OPI_DBI_RPT_UTIL_PKG.get_inv_convergence_date(l_inv_migration_date);

2903: l_debug_msg := 'Getting Convergence date. ';
2904: OPI_DBI_BOUNDS_PKG.write (g_pkg_name,l_proc_name,l_stmt_num, l_debug_msg );
2905: END IF;
2906: -- Procedure will provide R12 migration date
2907: OPI_DBI_RPT_UTIL_PKG.get_inv_convergence_date(l_inv_migration_date);
2908: g_R12_date:=l_inv_migration_date;
2909: -- ACTION: confirm that it returns a truncated date
2910:
2911: IF (g_R12_date IS NULL ) THEN