APPS.OPI_DBI_INV_VALUE_INCR_PKG dependencies on OPI_DBI_RPT_UTIL_PKG

Line 565: OPI_DBI_RPT_UTIL_PKG.g_pk_uom_conversion :=1 ;

561: -- Shipping Conversion Not Required Conversion Not Required
562: -- Receiving Conversion Not Required Conversion Required
563:
564: -- Index on opi_dbi_intr_mip_tmp Can avoid full table scan
565: OPI_DBI_RPT_UTIL_PKG.g_pk_uom_conversion :=1 ;
566: INSERT /*+ append */ INTO OPI_DBI_INTRANSIT_STG(
567: organization_id,
568: inventory_item_id,
569: transaction_date,

Line 614: 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)),

610: mmt1.transaction_action_id,
611: 21, DECODE(
612: mip.fob_point,
613: 2, mmt1.primary_quantity,
614: 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)),
615: 12, DECODE (
616: mip.fob_point,
617: 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),
618: mmt1.primary_quantity),

Line 617: 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),

613: 2, mmt1.primary_quantity,
614: 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)),
615: 12, DECODE (
616: mip.fob_point,
617: 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),
618: mmt1.primary_quantity),
619: 22, mmt1.primary_quantity, --Absolute value fix
620: 15, -1 * mmt1.primary_quantity))) qty,
621: SUM (base_transaction_value) value,

Line 707: if OPI_DBI_RPT_UTIL_PKG.g_pk_uom_conversion <>1 then

703: trx_date,
704: decode(process_flag,'N',1,2) -- Bug fix: 5362465
705: HAVING sum(value) <> 0 or sum(qty) <> 0;
706:
707: if OPI_DBI_RPT_UTIL_PKG.g_pk_uom_conversion <>1 then
708: Raise UOM_CONV_ERROR;
709: end if;
710:
711: l_debug_msg := 'Inserted into staging table opi_dbi_intransit_stg - ' || SQL%ROWCOUNT || ' rows. ';

Line 720: OPI_DBI_RPT_UTIL_PKG.g_pk_uom_conversion :=1 ;

716: IF l_debug_mode = 'Y' and upper(l_module_name) like 'BIS%' then
717: l_debug_msg := 'Inserting data Into opi_dbi_intransit_stg for OPM Post R12 ';
718: OPI_DBI_BOUNDS_PKG.write (g_pkg_name,l_proc_name,l_stmt_num, l_debug_msg );
719: END IF;
720: OPI_DBI_RPT_UTIL_PKG.g_pk_uom_conversion :=1 ;
721: -- Query to collect POST R12 OPM data
722: INSERT /*+ APPEND */ INTO OPI_DBI_INTRANSIT_STG(
723: organization_id,
724: inventory_item_id,

Line 770: 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)),

766: mmt1.primary_quantity), --Bug 4878458
767: DECODE (mmt1.transaction_action_id,
768: 21, DECODE (mip.fob_point,
769: 2, mmt1.primary_quantity,
770: 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)),
771: 12, DECODE (mip.fob_point,
772: 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),
773: mmt1.primary_quantity),
774: 22, mmt1.primary_quantity ,-- Absolute value fix, no need of conversion ??

Line 772: 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),

768: 21, DECODE (mip.fob_point,
769: 2, mmt1.primary_quantity,
770: 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)),
771: 12, DECODE (mip.fob_point,
772: 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),
773: mmt1.primary_quantity),
774: 22, mmt1.primary_quantity ,-- Absolute value fix, no need of conversion ??
775: 15, -1 * mmt1.primary_quantity
776: )))) qty, -- Bug 4901338, removed ,0

Line 788: 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)),

784: mmt1.primary_quantity), --Bug 4878458
785: DECODE (mmt1.transaction_action_id,
786: 21, DECODE (mip.fob_point,
787: 2, mmt1.primary_quantity,
788: 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)),
789: 12, DECODE (mip.fob_point,
790: 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),
791: mmt1.primary_quantity),
792: 22, mmt1.primary_quantity ,-- Absolute value fix, no need of conversion ??

Line 790: 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),

786: 21, DECODE (mip.fob_point,
787: 2, mmt1.primary_quantity,
788: 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)),
789: 12, DECODE (mip.fob_point,
790: 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),
791: mmt1.primary_quantity),
792: 22, mmt1.primary_quantity ,-- Absolute value fix, no need of conversion ??
793: 15, -1 * mmt1.primary_quantity
794: )),0)) Draft_qty,

Line 875: if OPI_DBI_RPT_UTIL_PKG.g_pk_uom_conversion <>1 then

871: decode(process_flag,'N',1,2) -- Bug fix: 5362465
872: HAVING sum(value) <> 0 or sum(qty) <> 0 OR sum(draft_value) <> 0 OR sum(draft_qty) <> 0
873: OR (sum(draft_value) = 0 AND sum(draft_qty) = 0); -- Bug 4968293
874:
875: if OPI_DBI_RPT_UTIL_PKG.g_pk_uom_conversion <>1 then
876: Raise UOM_CONV_ERROR;
877: end if;
878: commit;
879: