DBA Data[Home] [Help]

APPS.WIP_AUTOLOTPROC_PRIV dependencies on WIP_UTILITIES

Line 1176: l_enabled := wip_utilities.is_status_applicable(p_trx_type_id => getTxnType(l_item.transaction_action_id),

1172:
1173: if (l_logLevel <= wip_constants.full_logging) then
1174: wip_logger.log('lot: ' || l_lotNumber || '; qty: ' || l_lotQty, l_returnStatus);
1175: end if;
1176: l_enabled := wip_utilities.is_status_applicable(p_trx_type_id => getTxnType(l_item.transaction_action_id),
1177: p_organization_id => p_orgID,
1178: p_inventory_item_id => l_item.inventory_item_id,
1179: p_sub_code => l_item.supply_subinventory,
1180: p_locator_id => l_item.supply_locator_id,

Line 1560: l_enabled := wip_utilities.is_status_applicable(p_trx_type_id => getTxnType(l_item.transaction_action_id),

1556: end if; -- end if for row count
1557: /* End of addition for Wilson Greatbatch Enhancement */
1558: end if; -- end if for p_entrytype
1559:
1560: l_enabled := wip_utilities.is_status_applicable(p_trx_type_id => getTxnType(l_item.transaction_action_id),
1561: p_organization_id => p_orgID,
1562: p_inventory_item_id => l_item.inventory_item_id,
1563: p_sub_code => l_item.supply_subinventory,
1564: p_locator_id => l_item.supply_locator_id,

Line 1975: and (wip_utilities.is_status_applicable(/*p_trx_status_enabled => */ null,

1971: and inventory_item_id = p_itemID
1972: and current_status = 3
1973: and (group_mark_id = -1 OR group_mark_id is null)
1974: and lpn_id is null
1975: and (wip_utilities.is_status_applicable(/*p_trx_status_enabled => */ null,
1976: /*p_trx_type_id => */ l_txnTypeID,
1977: /*p_lot_status_enabled => */ null,
1978: /*p_serial_status_enabled => */ null,
1979: /*p_organization_id => */ current_organization_id,

Line 1996: and (wip_utilities.is_status_applicable(/*p_trx_status_enabled => */ null,

1992: where current_organization_id = p_orgID
1993: and inventory_item_id = p_itemID
1994: and current_status = 4
1995: and (group_mark_id = -1 OR group_mark_id is null)
1996: and (wip_utilities.is_status_applicable(/*p_trx_status_enabled => */ null,
1997: /*p_trx_type_id => */ l_txnTypeID,
1998: /*p_lot_status_enabled => */ null,
1999: /*p_serial_status_enabled => */ null,
2000: /*p_organization_id => */ current_organization_id,

Line 2027: and (wip_utilities.is_status_applicable(/*p_trx_status_enabled => */ null,

2023: where current_organization_id = p_orgID
2024: and inventory_item_id = p_itemID
2025: and current_status in (1, 6)
2026: and (group_mark_id = -1 OR group_mark_id is null)
2027: and (wip_utilities.is_status_applicable(/*p_trx_status_enabled => */ null,
2028: /*p_trx_type_id => */ l_txnTypeID,
2029: /*p_lot_status_enabled => */ null,
2030: /*p_serial_status_enabled => */ null,
2031: /*p_organization_id => */ current_organization_id,