DBA Data[Home] [Help]

APPS.WMS_PUTAWAY_UTILS dependencies on INV_GLOBALS

Line 6175: ,inv_globals.g_to_status_closed

6171: SET quantity = quantity - l_mmtt_qty_mol_uom
6172: , quantity_detailed = quantity_detailed - l_mmtt_qty_mol_uom
6173: , line_status = Decode(quantity-Nvl(quantity_delivered,0)-l_mmtt_qty_mol_uom
6174: ,0
6175: ,inv_globals.g_to_status_closed
6176: ,line_status)
6177: WHERE line_id = l_mol_id;
6178: EXCEPTION
6179: WHEN OTHERS THEN

Line 7268: , p_trx_action_id => inv_globals.g_action_containerpack

7264: l_ret := inv_trx_util_pub.insert_line_trx(
7265: p_trx_hdr_id => p_trx_header_id
7266: , p_item_id => '0'
7267: , p_org_id => p_org_id
7268: , p_trx_action_id => inv_globals.g_action_containerpack
7269: , p_subinv_code => p_sub_code
7270: , p_locator_id => p_loc_id
7271: , p_trx_type_id => inv_globals.g_type_container_pack
7272: , p_trx_src_type_id => inv_globals.g_sourcetype_inventory

Line 7271: , p_trx_type_id => inv_globals.g_type_container_pack

7267: , p_org_id => p_org_id
7268: , p_trx_action_id => inv_globals.g_action_containerpack
7269: , p_subinv_code => p_sub_code
7270: , p_locator_id => p_loc_id
7271: , p_trx_type_id => inv_globals.g_type_container_pack
7272: , p_trx_src_type_id => inv_globals.g_sourcetype_inventory
7273: , p_trx_qty => 1
7274: , p_pri_qty => 1
7275: , p_uom => 'Ea'

Line 7272: , p_trx_src_type_id => inv_globals.g_sourcetype_inventory

7268: , p_trx_action_id => inv_globals.g_action_containerpack
7269: , p_subinv_code => p_sub_code
7270: , p_locator_id => p_loc_id
7271: , p_trx_type_id => inv_globals.g_type_container_pack
7272: , p_trx_src_type_id => inv_globals.g_sourcetype_inventory
7273: , p_trx_qty => 1
7274: , p_pri_qty => 1
7275: , p_uom => 'Ea'
7276: , p_user_id => p_user_id

Line 7293: , p_trx_action_id => inv_globals.g_action_containerunpack

7289: l_ret := inv_trx_util_pub.insert_line_trx(
7290: p_trx_hdr_id => p_trx_header_id
7291: , p_item_id => '-1'
7292: , p_org_id => p_org_id
7293: , p_trx_action_id => inv_globals.g_action_containerunpack
7294: , p_subinv_code => p_sub_code
7295: , p_locator_id => p_loc_id
7296: , p_trx_type_id => inv_globals.g_type_container_unpack
7297: , p_trx_src_type_id => inv_globals.g_sourcetype_inventory

Line 7296: , p_trx_type_id => inv_globals.g_type_container_unpack

7292: , p_org_id => p_org_id
7293: , p_trx_action_id => inv_globals.g_action_containerunpack
7294: , p_subinv_code => p_sub_code
7295: , p_locator_id => p_loc_id
7296: , p_trx_type_id => inv_globals.g_type_container_unpack
7297: , p_trx_src_type_id => inv_globals.g_sourcetype_inventory
7298: , p_trx_qty => 1
7299: , p_pri_qty => 1
7300: , p_uom => 'Ea'

Line 7297: , p_trx_src_type_id => inv_globals.g_sourcetype_inventory

7293: , p_trx_action_id => inv_globals.g_action_containerunpack
7294: , p_subinv_code => p_sub_code
7295: , p_locator_id => p_loc_id
7296: , p_trx_type_id => inv_globals.g_type_container_unpack
7297: , p_trx_src_type_id => inv_globals.g_sourcetype_inventory
7298: , p_trx_qty => 1
7299: , p_pri_qty => 1
7300: , p_uom => 'Ea'
7301: , p_user_id => p_user_id

Line 9809: , p_trx_action_id => inv_globals.g_action_containersplit

9805: (
9806: p_trx_hdr_id => l_hdr_id
9807: , p_item_id => -1
9808: , p_org_id => l_org_id
9809: , p_trx_action_id => inv_globals.g_action_containersplit
9810: , p_subinv_code => l_sub_code
9811: , p_locator_id => l_loc_id
9812: , p_trx_type_id => inv_globals.g_type_container_split
9813: , p_trx_src_type_id => inv_globals.g_sourcetype_inventory

Line 9812: , p_trx_type_id => inv_globals.g_type_container_split

9808: , p_org_id => l_org_id
9809: , p_trx_action_id => inv_globals.g_action_containersplit
9810: , p_subinv_code => l_sub_code
9811: , p_locator_id => l_loc_id
9812: , p_trx_type_id => inv_globals.g_type_container_split
9813: , p_trx_src_type_id => inv_globals.g_sourcetype_inventory
9814: , p_trx_qty => 1
9815: , p_pri_qty => 1
9816: , p_uom => 'X'

Line 9813: , p_trx_src_type_id => inv_globals.g_sourcetype_inventory

9809: , p_trx_action_id => inv_globals.g_action_containersplit
9810: , p_subinv_code => l_sub_code
9811: , p_locator_id => l_loc_id
9812: , p_trx_type_id => inv_globals.g_type_container_split
9813: , p_trx_src_type_id => inv_globals.g_sourcetype_inventory
9814: , p_trx_qty => 1
9815: , p_pri_qty => 1
9816: , p_uom => 'X'
9817: , p_user_id => l_user_id --??

Line 9877: , p_trx_action_id => inv_globals.g_action_containersplit

9873: p_trx_hdr_id => l_hdr_id
9874: , p_item_id => l_wlpnc_rec.inventory_item_id
9875: , p_revision => l_wlpnc_rec.revision
9876: , p_org_id => l_org_id
9877: , p_trx_action_id => inv_globals.g_action_containersplit
9878: , p_subinv_code => l_sub_code
9879: , p_locator_id => l_loc_id
9880: , p_trx_type_id => inv_globals.g_type_container_split
9881: , p_trx_src_type_id => inv_globals.g_sourcetype_inventory

Line 9880: , p_trx_type_id => inv_globals.g_type_container_split

9876: , p_org_id => l_org_id
9877: , p_trx_action_id => inv_globals.g_action_containersplit
9878: , p_subinv_code => l_sub_code
9879: , p_locator_id => l_loc_id
9880: , p_trx_type_id => inv_globals.g_type_container_split
9881: , p_trx_src_type_id => inv_globals.g_sourcetype_inventory
9882: , p_trx_qty => l_wlpnc_rec.quantity
9883: , p_pri_qty => l_prim_qty
9884: , p_uom => l_wlpnc_rec.uom_code

Line 9881: , p_trx_src_type_id => inv_globals.g_sourcetype_inventory

9877: , p_trx_action_id => inv_globals.g_action_containersplit
9878: , p_subinv_code => l_sub_code
9879: , p_locator_id => l_loc_id
9880: , p_trx_type_id => inv_globals.g_type_container_split
9881: , p_trx_src_type_id => inv_globals.g_sourcetype_inventory
9882: , p_trx_qty => l_wlpnc_rec.quantity
9883: , p_pri_qty => l_prim_qty
9884: , p_uom => l_wlpnc_rec.uom_code
9885: , p_user_id => l_user_id --??

Line 12535: INV_GLOBALS.G_TYPE_CONTAINER_PACK,

12531: )
12532: )
12533: AND inv_material_status_grp.is_status_applicable('TRUE',
12534: NULL,
12535: INV_GLOBALS.G_TYPE_CONTAINER_PACK,
12536: NULL,
12537: NULL,
12538: p_organization_id,
12539: NULL,

Line 12547: INV_GLOBALS.G_TYPE_CONTAINER_PACK,

12543: NULL,
12544: 'Z') = 'Y'
12545: AND inv_material_status_grp.is_status_applicable('TRUE',
12546: NULL,
12547: INV_GLOBALS.G_TYPE_CONTAINER_PACK,
12548: NULL,
12549: NULL,
12550: p_organization_id,
12551: NULL,

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

12890: )
12891: )
12892: )
12893: AND inv_material_status_grp.is_status_applicable
12894: ('TRUE',NULL,inv_globals.g_type_container_pack,
12895: NULL,NULL,p_organization_id,NULL,wlpn.subinventory_code,
12896: wlpn.locator_id,NULL,NULL,'Z') = 'Y'
12897: AND inv_material_status_grp.is_status_applicable
12898: ('TRUE',NULL,inv_globals.g_type_container_pack,NULL,

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

12894: ('TRUE',NULL,inv_globals.g_type_container_pack,
12895: NULL,NULL,p_organization_id,NULL,wlpn.subinventory_code,
12896: wlpn.locator_id,NULL,NULL,'Z') = 'Y'
12897: AND inv_material_status_grp.is_status_applicable
12898: ('TRUE',NULL,inv_globals.g_type_container_pack,NULL,
12899: NULL,p_organization_id,NULL,wlpn.subinventory_code,
12900: wlpn.locator_id,NULL,NULL,'L') = 'Y'
12901: )
12902: );