APPS.WIP_PICKING_PUB dependencies on WIP_CONSTANTS

Line 30: if(l_entityType = wip_constants.flow) then --flow schedule

26: into l_entityType
27: from wip_entities
28: where wip_entity_id = p_wip_entity_id;
29:
30: if(l_entityType = wip_constants.flow) then --flow schedule
31: return;
32: end if;
33:
34: --for repetitive, lot-based and discrete...

Line 123: if(l_entityType <> wip_constants.REPETITIVE) then

119: into l_entityType
120: from wip_entities
121: where wip_entity_id = p_wip_entity_id;
122:
123: if(l_entityType <> wip_constants.REPETITIVE) then
124: select wdj.status_type
125: into l_status
126: from wip_discrete_jobs wdj, wip_requirement_operations wro
127: where wdj.wip_entity_id = p_wip_entity_id

Line 262: if(l_entityType = wip_constants.flow) then --flow schedule

258: select entity_type
259: into l_entityType
260: from wip_entities
261: where wip_entity_id = p_wip_entity_id;
262: if(l_entityType = wip_constants.flow) then --flow schedule
263: select allocated_flag
264: into l_flow
265: from wip_flow_schedules
266: where wip_entity_id = p_wip_entity_id

Line 824: (wip_constants.assy_pull, wip_constants.op_pull);

820: supply_locator_id = p_supply_locator_id
821: where wip_entity_id = p_wip_entity_id
822: and operation_seq_num = p_operation_seq_num
823: and wip_supply_type in
824: (wip_constants.assy_pull, wip_constants.op_pull);
825: else
826: update wip_requirement_operations
827: set supply_subinventory = p_supply_subinventory,
828: supply_locator_id = p_supply_locator_id

Line 833: (wip_constants.assy_pull, wip_constants.op_pull);

829: where wip_entity_id = p_wip_entity_id
830: and operation_seq_num = p_operation_seq_num
831: and p_repetitive_schedule_id = p_repetitive_schedule_id
832: and wip_supply_type in
833: (wip_constants.assy_pull, wip_constants.op_pull);
834: end if;
835:
836: exception
837: when no_data_found then

Line 874: If (l_entityType = wip_constants.flow) then

870: into l_entityType
871: from wip_entities
872: where wip_entity_id = p_wip_entity_id;
873:
874: If (l_entityType = wip_constants.flow) then
875: Return;
876: End if;
877:
878: --for repetitive, lot-based and discrete...

Line 893: (wip_constants.push, wip_constants.op_pull, wip_constants.assy_pull))

889: and (
890: ('Y' = (select allocate_backflush_components from wip_parameters wp
891: where organization_id = wro.organization_id)
892: and wip_supply_type in
893: (wip_constants.push, wip_constants.op_pull, wip_constants.assy_pull))
894: or wip_supply_type = wip_constants.push
895: );
896: else
897: Update wip_requirement_operations wro

Line 894: or wip_supply_type = wip_constants.push

890: ('Y' = (select allocate_backflush_components from wip_parameters wp
891: where organization_id = wro.organization_id)
892: and wip_supply_type in
893: (wip_constants.push, wip_constants.op_pull, wip_constants.assy_pull))
894: or wip_supply_type = wip_constants.push
895: );
896: else
897: Update wip_requirement_operations wro
898: set quantity_backordered = GREATEST(p_new_component_qty

Line 912: (wip_constants.push, wip_constants.op_pull, wip_constants.assy_pull))

908: ('Y' = (select allocate_backflush_components
909: from wip_parameters wp
910: where organization_id = wro.organization_id)
911: and wip_supply_type in
912: (wip_constants.push, wip_constants.op_pull, wip_constants.assy_pull))
913: or wip_supply_type = wip_constants.push
914: );
915: end if;
916:

Line 913: or wip_supply_type = wip_constants.push

909: from wip_parameters wp
910: where organization_id = wro.organization_id)
911: and wip_supply_type in
912: (wip_constants.push, wip_constants.op_pull, wip_constants.assy_pull))
913: or wip_supply_type = wip_constants.push
914: );
915: end if;
916:
917: exception

Line 950: If (l_entityType = wip_constants.flow) then

946: into l_entityType
947: from wip_entities
948: where wip_entity_id = p_wip_entity_id;
949:
950: If (l_entityType = wip_constants.flow) then
951: Return;
952: End if;
953:
954: --for repetitive, lot-based and discrete

Line 968: (wip_constants.push, wip_constants.op_pull, wip_constants.assy_pull))

964: ('Y' = (select allocate_backflush_components
965: from wip_parameters wp
966: where organization_id = wro.organization_id)
967: and wip_supply_type in
968: (wip_constants.push, wip_constants.op_pull, wip_constants.assy_pull))
969: or wip_supply_type = wip_constants.push
970: );
971: else
972: Update wip_requirement_operations wro

Line 969: or wip_supply_type = wip_constants.push

965: from wip_parameters wp
966: where organization_id = wro.organization_id)
967: and wip_supply_type in
968: (wip_constants.push, wip_constants.op_pull, wip_constants.assy_pull))
969: or wip_supply_type = wip_constants.push
970: );
971: else
972: Update wip_requirement_operations wro
973: set quantity_backordered = GREATEST(p_new_job_qty* quantity_per_assembly

Line 985: (wip_constants.push, wip_constants.op_pull, wip_constants.assy_pull))

981: ('Y' = (select allocate_backflush_components
982: from wip_parameters wp
983: where organization_id = wro.organization_id)
984: and wro.wip_supply_type in
985: (wip_constants.push, wip_constants.op_pull, wip_constants.assy_pull))
986: or wro.wip_supply_type = wip_constants.push
987: ) ;
988: end if;
989:

Line 986: or wro.wip_supply_type = wip_constants.push

982: from wip_parameters wp
983: where organization_id = wro.organization_id)
984: and wro.wip_supply_type in
985: (wip_constants.push, wip_constants.op_pull, wip_constants.assy_pull))
986: or wro.wip_supply_type = wip_constants.push
987: ) ;
988: end if;
989:
990: exception