APPS.MSC_PLAN_RELEASE dependencies on MSC_SUPPLIES

Line 220: FROM msc_supplies ms,

216:
217: CURSOR cur_supply_order IS
218: SELECT sum(decode(ms.load_type,20,0,1)),
219: sum(decode(ms.load_type,20,1,0))
220: FROM msc_supplies ms,
221: msc_apps_instances mai
222: where ms.plan_id = pid
223: and ms.release_errors is null
224: and ms.load_type is not null

Line 689: AND p_SOURCE_TABLE = 'MSC_SUPPLIES') THEN

685: l_ship_method varchar2(30) := p_ship_method;
686:
687: BEGIN
688: IF (p_order_type in (1,2,5)
689: AND p_SOURCE_TABLE = 'MSC_SUPPLIES') THEN
690:
691: --- get the unique number identifying the current session
692: SELECT MRP.mrp_atp_schedule_temp_s.nextval
693: INTO l_session_id

Line 923: if (p_source_table='MSC_SUPPLIES' AND

919:
920:
921:
922: /* if it is supply and order type not in (1,2,3,5,13) */
923: if (p_source_table='MSC_SUPPLIES' AND
924: p_order_type NOT IN (1, 2, 3, 5, 13) )then
925: p_rel_error :=FND_MESSAGE.GET_STRING('MSC', 'MSC_WB_RELEASE_3');
926: return p_rel_error;
927: END IF;

Line 963: if (p_order_type=5 and p_source_table='MSC_SUPPLIES' and p_release_time_fence_code = 6) then

959: end if;
960:
961:
962: /* Kanban item can not be released */
963: if (p_order_type=5 and p_source_table='MSC_SUPPLIES' and p_release_time_fence_code = 6) then
964: p_rel_error := FND_MESSAGE.GET_STRING('MRP', 'MRP_REL_ALL_KANBAN');
965: return p_rel_error;
966: end if;
967: