DBA Data[Home] [Help]

APPS.WIP_AUTOLOTPROC_PRIV dependencies on WIP_UTILITIES

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

1166:
1167: if (l_logLevel <= wip_constants.full_logging) then
1168: wip_logger.log('lot: ' || l_lotNumber || '; qty: ' || l_lotQty, l_returnStatus);
1169: end if;
1170: l_enabled := wip_utilities.is_status_applicable(p_trx_type_id => getTxnType(l_item.transaction_action_id),
1171: p_organization_id => p_orgID,
1172: p_inventory_item_id => l_item.inventory_item_id,
1173: p_sub_code => l_item.supply_subinventory,
1174: p_locator_id => l_item.supply_locator_id,

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

1494: end if; -- end if for row count
1495: /* End of addition for Wilson Greatbatch Enhancement */
1496: end if; -- end if for p_entrytype
1497:
1498: l_enabled := wip_utilities.is_status_applicable(p_trx_type_id => getTxnType(l_item.transaction_action_id),
1499: p_organization_id => p_orgID,
1500: p_inventory_item_id => l_item.inventory_item_id,
1501: p_sub_code => l_item.supply_subinventory,
1502: p_locator_id => l_item.supply_locator_id,

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

1900: and inventory_item_id = p_itemID
1901: and current_status = 3
1902: and (group_mark_id = -1 OR group_mark_id is null)
1903: and lpn_id is null
1904: and (wip_utilities.is_status_applicable(/*p_trx_status_enabled => */ null,
1905: /*p_trx_type_id => */ l_txnTypeID,
1906: /*p_lot_status_enabled => */ null,
1907: /*p_serial_status_enabled => */ null,
1908: /*p_organization_id => */ current_organization_id,

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

1921: where current_organization_id = p_orgID
1922: and inventory_item_id = p_itemID
1923: and current_status = 4
1924: and (group_mark_id = -1 OR group_mark_id is null)
1925: and (wip_utilities.is_status_applicable(/*p_trx_status_enabled => */ null,
1926: /*p_trx_type_id => */ l_txnTypeID,
1927: /*p_lot_status_enabled => */ null,
1928: /*p_serial_status_enabled => */ null,
1929: /*p_organization_id => */ current_organization_id,

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

1952: where current_organization_id = p_orgID
1953: and inventory_item_id = p_itemID
1954: and current_status in (1, 6)
1955: and (group_mark_id = -1 OR group_mark_id is null)
1956: and (wip_utilities.is_status_applicable(/*p_trx_status_enabled => */ null,
1957: /*p_trx_type_id => */ l_txnTypeID,
1958: /*p_lot_status_enabled => */ null,
1959: /*p_serial_status_enabled => */ null,
1960: /*p_organization_id => */ current_organization_id,