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 767: (wip_constants.assy_pull, wip_constants.op_pull);

763: supply_locator_id = p_supply_locator_id
764: where wip_entity_id = p_wip_entity_id
765: and operation_seq_num = p_operation_seq_num
766: and wip_supply_type in
767: (wip_constants.assy_pull, wip_constants.op_pull);
768: else
769: update wip_requirement_operations
770: set supply_subinventory = p_supply_subinventory,
771: supply_locator_id = p_supply_locator_id

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

772: where wip_entity_id = p_wip_entity_id
773: and operation_seq_num = p_operation_seq_num
774: and p_repetitive_schedule_id = p_repetitive_schedule_id
775: and wip_supply_type in
776: (wip_constants.assy_pull, wip_constants.op_pull);
777: end if;
778:
779: exception
780: when no_data_found then

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

813: into l_entityType
814: from wip_entities
815: where wip_entity_id = p_wip_entity_id;
816:
817: If (l_entityType = wip_constants.flow) then
818: Return;
819: End if;
820:
821: --for repetitive, lot-based and discrete...

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

832: and (
833: ('Y' = (select allocate_backflush_components from wip_parameters wp
834: where organization_id = wro.organization_id)
835: and wip_supply_type in
836: (wip_constants.push, wip_constants.op_pull, wip_constants.assy_pull))
837: or wip_supply_type = wip_constants.push
838: );
839: else
840: Update wip_requirement_operations wro

Line 837: or wip_supply_type = wip_constants.push

833: ('Y' = (select allocate_backflush_components from wip_parameters wp
834: where organization_id = wro.organization_id)
835: and wip_supply_type in
836: (wip_constants.push, wip_constants.op_pull, wip_constants.assy_pull))
837: or wip_supply_type = wip_constants.push
838: );
839: else
840: Update wip_requirement_operations wro
841: set quantity_backordered = GREATEST(p_new_component_qty

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

851: ('Y' = (select allocate_backflush_components
852: from wip_parameters wp
853: where organization_id = wro.organization_id)
854: and wip_supply_type in
855: (wip_constants.push, wip_constants.op_pull, wip_constants.assy_pull))
856: or wip_supply_type = wip_constants.push
857: );
858: end if;
859:

Line 856: or wip_supply_type = wip_constants.push

852: from wip_parameters wp
853: where organization_id = wro.organization_id)
854: and wip_supply_type in
855: (wip_constants.push, wip_constants.op_pull, wip_constants.assy_pull))
856: or wip_supply_type = wip_constants.push
857: );
858: end if;
859:
860: exception

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

889: into l_entityType
890: from wip_entities
891: where wip_entity_id = p_wip_entity_id;
892:
893: If (l_entityType = wip_constants.flow) then
894: Return;
895: End if;
896:
897: --for repetitive, lot-based and discrete

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

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

Line 912: or wip_supply_type = wip_constants.push

908: from wip_parameters wp
909: where organization_id = wro.organization_id)
910: and wip_supply_type in
911: (wip_constants.push, wip_constants.op_pull, wip_constants.assy_pull))
912: or wip_supply_type = wip_constants.push
913: );
914: else
915: Update wip_requirement_operations wro
916: set quantity_backordered = GREATEST(p_new_job_qty* quantity_per_assembly

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

924: ('Y' = (select allocate_backflush_components
925: from wip_parameters wp
926: where organization_id = wro.organization_id)
927: and wro.wip_supply_type in
928: (wip_constants.push, wip_constants.op_pull, wip_constants.assy_pull))
929: or wro.wip_supply_type = wip_constants.push
930: ) ;
931: end if;
932:

Line 929: or wro.wip_supply_type = wip_constants.push

925: from wip_parameters wp
926: where organization_id = wro.organization_id)
927: and wro.wip_supply_type in
928: (wip_constants.push, wip_constants.op_pull, wip_constants.assy_pull))
929: or wro.wip_supply_type = wip_constants.push
930: ) ;
931: end if;
932:
933: exception