DBA Data[Home] [Help]

APPS.INV_SHIPPING_TRANSACTION_PUB dependencies on INV_MATERIAL_STATUS_GRP

Line 2047: l_status_applicable := INV_MATERIAL_STATUS_GRP.is_status_applicable(

2043: FETCH get_lpn_id_wdd INTO l_lpn_id;
2044: CLOSE get_lpn_id_wdd; --16482236
2045: -- check subinventory
2046: if (l_detail_rec.subinventory is not NULL) then
2047: l_status_applicable := INV_MATERIAL_STATUS_GRP.is_status_applicable(
2048: p_wms_installed => 'TRUE'
2049: , p_trx_status_enabled => l_status_enabled
2050: , p_trx_type_id => l_trx_type_code
2051: , p_organization_id => l_org_id

Line 2064: l_status_applicable := INV_MATERIAL_STATUS_GRP.is_status_applicable(

2060: end if;
2061: end if;
2062: -- check locator
2063: if (l_detail_rec.locator_id is not NULL) then
2064: l_status_applicable := INV_MATERIAL_STATUS_GRP.is_status_applicable(
2065: p_wms_installed => 'TRUE'
2066: , p_trx_status_enabled => l_status_enabled
2067: , p_trx_type_id => l_trx_type_code
2068: , p_organization_id => l_org_id

Line 2080: l_status_applicable := INV_MATERIAL_STATUS_GRP.is_status_applicable(

2076: end if;
2077: end if;
2078: -- check lot
2079: if (l_detail_rec.lot_number is not NULL) then
2080: l_status_applicable := INV_MATERIAL_STATUS_GRP.is_status_applicable(
2081: p_wms_installed => 'TRUE'
2082: , p_trx_status_enabled => l_status_enabled
2083: , p_trx_type_id => l_trx_type_code
2084: , p_organization_id => l_org_id

Line 2100: l_status_applicable := INV_MATERIAL_STATUS_GRP.is_status_applicable(

2096: end if;
2097: end if;
2098: -- check serial
2099: if (l_detail_rec.serial_number is not NULL) then
2100: l_status_applicable := INV_MATERIAL_STATUS_GRP.is_status_applicable(
2101: p_wms_installed => 'TRUE'
2102: , p_trx_status_enabled => l_status_enabled
2103: , p_trx_type_id => l_trx_type_code
2104: , p_organization_id => l_org_id