DBA Data[Home] [Help]

APPS.WMS_PUTAWAY_UTILS dependencies on INV_GLOBALS

Line 5446: ,inv_globals.g_to_status_closed

5442: SET quantity = quantity - l_mmtt_qty_mol_uom
5443: , quantity_detailed = quantity_detailed - l_mmtt_qty_mol_uom
5444: , line_status = Decode(quantity-Nvl(quantity_delivered,0)-l_mmtt_qty_mol_uom
5445: ,0
5446: ,inv_globals.g_to_status_closed
5447: ,line_status)
5448: WHERE line_id = l_mol_id;
5449: EXCEPTION
5450: WHEN OTHERS THEN

Line 6406: , p_trx_action_id => inv_globals.g_action_containerpack

6402: l_ret := inv_trx_util_pub.insert_line_trx(
6403: p_trx_hdr_id => p_trx_header_id
6404: , p_item_id => '0'
6405: , p_org_id => p_org_id
6406: , p_trx_action_id => inv_globals.g_action_containerpack
6407: , p_subinv_code => p_sub_code
6408: , p_locator_id => p_loc_id
6409: , p_trx_type_id => inv_globals.g_type_container_pack
6410: , p_trx_src_type_id => inv_globals.g_sourcetype_inventory

Line 6409: , p_trx_type_id => inv_globals.g_type_container_pack

6405: , p_org_id => p_org_id
6406: , p_trx_action_id => inv_globals.g_action_containerpack
6407: , p_subinv_code => p_sub_code
6408: , p_locator_id => p_loc_id
6409: , p_trx_type_id => inv_globals.g_type_container_pack
6410: , p_trx_src_type_id => inv_globals.g_sourcetype_inventory
6411: , p_trx_qty => 1
6412: , p_pri_qty => 1
6413: , p_uom => 'Ea'

Line 6410: , p_trx_src_type_id => inv_globals.g_sourcetype_inventory

6406: , p_trx_action_id => inv_globals.g_action_containerpack
6407: , p_subinv_code => p_sub_code
6408: , p_locator_id => p_loc_id
6409: , p_trx_type_id => inv_globals.g_type_container_pack
6410: , p_trx_src_type_id => inv_globals.g_sourcetype_inventory
6411: , p_trx_qty => 1
6412: , p_pri_qty => 1
6413: , p_uom => 'Ea'
6414: , p_user_id => p_user_id

Line 6431: , p_trx_action_id => inv_globals.g_action_containerunpack

6427: l_ret := inv_trx_util_pub.insert_line_trx(
6428: p_trx_hdr_id => p_trx_header_id
6429: , p_item_id => '-1'
6430: , p_org_id => p_org_id
6431: , p_trx_action_id => inv_globals.g_action_containerunpack
6432: , p_subinv_code => p_sub_code
6433: , p_locator_id => p_loc_id
6434: , p_trx_type_id => inv_globals.g_type_container_unpack
6435: , p_trx_src_type_id => inv_globals.g_sourcetype_inventory

Line 6434: , p_trx_type_id => inv_globals.g_type_container_unpack

6430: , p_org_id => p_org_id
6431: , p_trx_action_id => inv_globals.g_action_containerunpack
6432: , p_subinv_code => p_sub_code
6433: , p_locator_id => p_loc_id
6434: , p_trx_type_id => inv_globals.g_type_container_unpack
6435: , p_trx_src_type_id => inv_globals.g_sourcetype_inventory
6436: , p_trx_qty => 1
6437: , p_pri_qty => 1
6438: , p_uom => 'Ea'

Line 6435: , p_trx_src_type_id => inv_globals.g_sourcetype_inventory

6431: , p_trx_action_id => inv_globals.g_action_containerunpack
6432: , p_subinv_code => p_sub_code
6433: , p_locator_id => p_loc_id
6434: , p_trx_type_id => inv_globals.g_type_container_unpack
6435: , p_trx_src_type_id => inv_globals.g_sourcetype_inventory
6436: , p_trx_qty => 1
6437: , p_pri_qty => 1
6438: , p_uom => 'Ea'
6439: , p_user_id => p_user_id

Line 8944: , p_trx_action_id => inv_globals.g_action_containersplit

8940: (
8941: p_trx_hdr_id => l_hdr_id
8942: , p_item_id => -1
8943: , p_org_id => l_org_id
8944: , p_trx_action_id => inv_globals.g_action_containersplit
8945: , p_subinv_code => l_sub_code
8946: , p_locator_id => l_loc_id
8947: , p_trx_type_id => inv_globals.g_type_container_split
8948: , p_trx_src_type_id => inv_globals.g_sourcetype_inventory

Line 8947: , p_trx_type_id => inv_globals.g_type_container_split

8943: , p_org_id => l_org_id
8944: , p_trx_action_id => inv_globals.g_action_containersplit
8945: , p_subinv_code => l_sub_code
8946: , p_locator_id => l_loc_id
8947: , p_trx_type_id => inv_globals.g_type_container_split
8948: , p_trx_src_type_id => inv_globals.g_sourcetype_inventory
8949: , p_trx_qty => 1
8950: , p_pri_qty => 1
8951: , p_uom => 'X'

Line 8948: , p_trx_src_type_id => inv_globals.g_sourcetype_inventory

8944: , p_trx_action_id => inv_globals.g_action_containersplit
8945: , p_subinv_code => l_sub_code
8946: , p_locator_id => l_loc_id
8947: , p_trx_type_id => inv_globals.g_type_container_split
8948: , p_trx_src_type_id => inv_globals.g_sourcetype_inventory
8949: , p_trx_qty => 1
8950: , p_pri_qty => 1
8951: , p_uom => 'X'
8952: , p_user_id => l_user_id --??

Line 9012: , p_trx_action_id => inv_globals.g_action_containersplit

9008: p_trx_hdr_id => l_hdr_id
9009: , p_item_id => l_wlpnc_rec.inventory_item_id
9010: , p_revision => l_wlpnc_rec.revision
9011: , p_org_id => l_org_id
9012: , p_trx_action_id => inv_globals.g_action_containersplit
9013: , p_subinv_code => l_sub_code
9014: , p_locator_id => l_loc_id
9015: , p_trx_type_id => inv_globals.g_type_container_split
9016: , p_trx_src_type_id => inv_globals.g_sourcetype_inventory

Line 9015: , p_trx_type_id => inv_globals.g_type_container_split

9011: , p_org_id => l_org_id
9012: , p_trx_action_id => inv_globals.g_action_containersplit
9013: , p_subinv_code => l_sub_code
9014: , p_locator_id => l_loc_id
9015: , p_trx_type_id => inv_globals.g_type_container_split
9016: , p_trx_src_type_id => inv_globals.g_sourcetype_inventory
9017: , p_trx_qty => l_wlpnc_rec.quantity
9018: , p_pri_qty => l_prim_qty
9019: , p_uom => l_wlpnc_rec.uom_code

Line 9016: , p_trx_src_type_id => inv_globals.g_sourcetype_inventory

9012: , p_trx_action_id => inv_globals.g_action_containersplit
9013: , p_subinv_code => l_sub_code
9014: , p_locator_id => l_loc_id
9015: , p_trx_type_id => inv_globals.g_type_container_split
9016: , p_trx_src_type_id => inv_globals.g_sourcetype_inventory
9017: , p_trx_qty => l_wlpnc_rec.quantity
9018: , p_pri_qty => l_prim_qty
9019: , p_uom => l_wlpnc_rec.uom_code
9020: , p_user_id => l_user_id --??

Line 11556: INV_GLOBALS.G_TYPE_CONTAINER_PACK,

11552: )
11553: )
11554: AND inv_material_status_grp.is_status_applicable('TRUE',
11555: NULL,
11556: INV_GLOBALS.G_TYPE_CONTAINER_PACK,
11557: NULL,
11558: NULL,
11559: p_organization_id,
11560: NULL,

Line 11568: INV_GLOBALS.G_TYPE_CONTAINER_PACK,

11564: NULL,
11565: 'Z') = 'Y'
11566: AND inv_material_status_grp.is_status_applicable('TRUE',
11567: NULL,
11568: INV_GLOBALS.G_TYPE_CONTAINER_PACK,
11569: NULL,
11570: NULL,
11571: p_organization_id,
11572: NULL,

Line 11793: ('TRUE',NULL,inv_globals.g_type_container_pack,

11789: )
11790: )
11791: )
11792: AND inv_material_status_grp.is_status_applicable
11793: ('TRUE',NULL,inv_globals.g_type_container_pack,
11794: NULL,NULL,p_organization_id,NULL,wlpn.subinventory_code,
11795: wlpn.locator_id,NULL,NULL,'Z') = 'Y'
11796: AND inv_material_status_grp.is_status_applicable
11797: ('TRUE',NULL,inv_globals.g_type_container_pack,NULL,

Line 11797: ('TRUE',NULL,inv_globals.g_type_container_pack,NULL,

11793: ('TRUE',NULL,inv_globals.g_type_container_pack,
11794: NULL,NULL,p_organization_id,NULL,wlpn.subinventory_code,
11795: wlpn.locator_id,NULL,NULL,'Z') = 'Y'
11796: AND inv_material_status_grp.is_status_applicable
11797: ('TRUE',NULL,inv_globals.g_type_container_pack,NULL,
11798: NULL,p_organization_id,NULL,wlpn.subinventory_code,
11799: wlpn.locator_id,NULL,NULL,'L') = 'Y'
11800: )
11801: );