APPS.INV_RCV_COMMON_APIS dependencies on INV_MATERIAL_STATUS_GRP

Line 2940: AND inv_material_status_grp.is_status_applicable('TRUE', NULL, l_transaction_type, NULL, NULL, p_organization_id

2936: FROM mtl_item_sub_inventories mis
2937: WHERE mis.organization_id = p_organization_id
2938: AND mis.inventory_item_id = p_item_id
2939: AND mis.secondary_inventory = l_sub
2940: AND inv_material_status_grp.is_status_applicable('TRUE', NULL, l_transaction_type, NULL, NULL, p_organization_id
2941: , p_item_id, l_sub, NULL, NULL, NULL, 'Z') = 'Y');
2942: EXCEPTION
2943: WHEN OTHERS THEN
2944: x_return_status := fnd_api.g_ret_sts_error;

Line 2963: AND inv_material_status_grp.is_status_applicable('TRUE', NULL, l_transaction_type, NULL, NULL, p_organization_id

2959: FROM mtl_secondary_inventories msi
2960: WHERE msi.organization_id = p_organization_id
2961: AND NVL(msi.disable_date, TRUNC(SYSDATE + 1)) > TRUNC(SYSDATE)
2962: AND msi.secondary_inventory_name = l_sub
2963: AND inv_material_status_grp.is_status_applicable('TRUE', NULL, l_transaction_type, NULL, NULL, p_organization_id
2964: , p_item_id, l_sub, NULL, NULL, NULL, 'Z') = 'Y');
2965: EXCEPTION
2966: WHEN OTHERS THEN
2967: x_return_status := fnd_api.g_ret_sts_error;

Line 2993: AND inv_material_status_grp.is_status_applicable(

2989: WHERE msl.organization_id = p_organization_id
2990: AND msl.inventory_item_id = p_item_id
2991: AND msl.subinventory_code = l_sub
2992: AND msl.secondary_locator = l_locator_id
2993: AND inv_material_status_grp.is_status_applicable(
2994: 'TRUE'
2995: , NULL
2996: , l_transaction_type
2997: , NULL

Line 3029: AND inv_material_status_grp.is_status_applicable(

3025: WHERE mil.organization_id = p_organization_id
3026: AND mil.subinventory_code = l_sub
3027: AND NVL(mil.disable_date, TRUNC(SYSDATE + 1)) > TRUNC(SYSDATE)
3028: AND mil.inventory_location_id = l_locator_id
3029: AND inv_material_status_grp.is_status_applicable(
3030: 'TRUE'
3031: , NULL
3032: , l_transaction_type
3033: , NULL

Line 4836: inv_material_status_grp.update_status(

4832: AND(p_update_status = 'TRUE'))
4833: OR (p_transfer_organization_id IS NOT NULL AND
4834: l_exists = 'FALSE' AND l_status_enabled = 'Y' AND l_dest_status_enabled = 'Y')) THEN --Added OR condition for bug 3853202, Added l_status_enabled bug3998321
4835: --Added l_dest_status_enabled = 'Y' bug4035918
4836: inv_material_status_grp.update_status(
4837: p_api_version_number => p_api_version
4838: , p_init_msg_lst => NULL
4839: , x_return_status => x_return_status
4840: , x_msg_count => x_msg_count

Line 5020: inv_material_status_grp.update_status(

5016: IF (l_inv_po_j_higher = FALSE) THEN
5017:
5018: IF p_update_serial_status = 'TRUE' THEN
5019: l_progress := '40';
5020: inv_material_status_grp.update_status(
5021: p_api_version_number => p_api_version
5022: , p_init_msg_lst => NULL
5023: , x_return_status => x_return_status
5024: , x_msg_count => x_msg_count

Line 5294: inv_material_status_grp.update_status(

5290: l_progress := '60';
5291:
5292: IF p_update_serial_status = 'TRUE' THEN
5293: l_progress := '70';
5294: inv_material_status_grp.update_status(
5295: p_api_version_number => p_api_version
5296: , p_init_msg_lst => NULL
5297: , x_return_status => x_return_status
5298: , x_msg_count => x_msg_count