APPS.WIP_LOT_NUMBER_DEFAULT dependencies on WIP_CONSTANTS

Line 70: IF x_lot_control_code = WIP_CONSTANTS.NO_LOT THEN

66:
67: lot_no := NULL;
68:
69: -- Not under lot control
70: IF x_lot_control_code = WIP_CONSTANTS.NO_LOT THEN
71: return(NULL);
72:
73: -- If the lot_number is already manually set then just use it
74: ELSIF P_Lot_Number IS NOT NULL OR P_Default_Flag <> WIP_CONSTANTS.YES THEN

Line 74: ELSIF P_Lot_Number IS NOT NULL OR P_Default_Flag <> WIP_CONSTANTS.YES THEN

70: IF x_lot_control_code = WIP_CONSTANTS.NO_LOT THEN
71: return(NULL);
72:
73: -- If the lot_number is already manually set then just use it
74: ELSIF P_Lot_Number IS NOT NULL OR P_Default_Flag <> WIP_CONSTANTS.YES THEN
75: return(P_Lot_Number);
76:
77: -- If WIP Parameter is set to no default
78: ELSIF x_lot_number_default_type = WIP_CONSTANTS.NO_DEFAULT THEN

Line 78: ELSIF x_lot_number_default_type = WIP_CONSTANTS.NO_DEFAULT THEN

74: ELSIF P_Lot_Number IS NOT NULL OR P_Default_Flag <> WIP_CONSTANTS.YES THEN
75: return(P_Lot_Number);
76:
77: -- If WIP Parameter is set to no default
78: ELSIF x_lot_number_default_type = WIP_CONSTANTS.NO_DEFAULT THEN
79: return(NULL);
80:
81: -- If WIP Parameter is set to based on Job Name
82: ELSIF x_lot_number_default_type = WIP_CONSTANTS.DEFAULT_JOB THEN

Line 82: ELSIF x_lot_number_default_type = WIP_CONSTANTS.DEFAULT_JOB THEN

78: ELSIF x_lot_number_default_type = WIP_CONSTANTS.NO_DEFAULT THEN
79: return(NULL);
80:
81: -- If WIP Parameter is set to based on Job Name
82: ELSIF x_lot_number_default_type = WIP_CONSTANTS.DEFAULT_JOB THEN
83: return(P_Job_Name);
84:
85: -- Based on Inventory Rules
86: ELSE

Line 87: IF x_lot_number_generation = WIP_CONSTANTS.ORG_LEVEL THEN

83: return(P_Job_Name);
84:
85: -- Based on Inventory Rules
86: ELSE
87: IF x_lot_number_generation = WIP_CONSTANTS.ORG_LEVEL THEN
88: IF x_lot_number_zero_padding = WIP_CONSTANTS.YES THEN
89: SELECT x_org_prefix ||
90: LPAD(to_char(MTL_LOT_NUMERIC_SUFFIX_S.nextval),
91: x_lot_number_length -

Line 88: IF x_lot_number_zero_padding = WIP_CONSTANTS.YES THEN

84:
85: -- Based on Inventory Rules
86: ELSE
87: IF x_lot_number_generation = WIP_CONSTANTS.ORG_LEVEL THEN
88: IF x_lot_number_zero_padding = WIP_CONSTANTS.YES THEN
89: SELECT x_org_prefix ||
90: LPAD(to_char(MTL_LOT_NUMERIC_SUFFIX_S.nextval),
91: x_lot_number_length -
92: nvl(lengthb(x_org_prefix),0),'0')

Line 104: ELSIF x_lot_number_generation = WIP_CONSTANTS.ITEM_LEVEL THEN

100: MTL_LOT_NUMERIC_SUFFIX_S.currval)),0)
101: INTO lot_no, lot_length
102: FROM DUAL;
103: END IF;
104: ELSIF x_lot_number_generation = WIP_CONSTANTS.ITEM_LEVEL THEN
105: IF x_lot_number_zero_padding = WIP_CONSTANTS.YES THEN
106: lot_no := x_item_prefix || lpad(x_start_auto_lot_number,
107: x_lot_number_length - nvl(lengthb(x_item_prefix),0),'0');
108: ELSE

Line 105: IF x_lot_number_zero_padding = WIP_CONSTANTS.YES THEN

101: INTO lot_no, lot_length
102: FROM DUAL;
103: END IF;
104: ELSIF x_lot_number_generation = WIP_CONSTANTS.ITEM_LEVEL THEN
105: IF x_lot_number_zero_padding = WIP_CONSTANTS.YES THEN
106: lot_no := x_item_prefix || lpad(x_start_auto_lot_number,
107: x_lot_number_length - nvl(lengthb(x_item_prefix),0),'0');
108: ELSE
109: lot_no := x_item_prefix || x_start_auto_lot_number;

Line 118: IF x_lot_number_zero_padding = WIP_CONSTANTS.YES THEN

114: /** Fix for bug 2923750 -- modification starts **/
115: new_auto_lot_number := to_char(to_number(x_start_auto_lot_number) + 1);
116: /* Fix for bug 4768625. We should not do zero padding when we update
117: MSI.START_AUTO_LOT_NUMBER.
118: IF x_lot_number_zero_padding = WIP_CONSTANTS.YES THEN
119: new_auto_lot_number := lpad(new_auto_lot_number,
120: x_lot_number_length - nvl(lengthb(x_item_prefix),0)
121: ,'0');
122: ELSE

Line 148: AND x_lot_number_zero_padding <> WIP_CONSTANTS.YES THEN

144:
145: END IF;
146: commit; -- Fixed bug 5201815
147: IF lot_length > x_lot_number_length
148: AND x_lot_number_zero_padding <> WIP_CONSTANTS.YES THEN
149: return(NULL);
150: ELSE
151: return(lot_no);
152: END IF;