APPS.WIP_LOCATOR dependencies on WIP_CONSTANTS

Line 39: IF (x_loc_control = WIP_CONSTANTS.NO_CONTROL OR

35: /* No Locator Control */
36:
37: /* Bug 5446216 (FP Bug 5504790): For Subinventory we should look for new possible value fnd_api.g_miss_char.
38: If it is null do validation of locator */
39: IF (x_loc_control = WIP_CONSTANTS.NO_CONTROL OR
40: P_Subinventory_Code = fnd_api.g_miss_char ) THEN
41:
42: /* Bug 5446216 (FP Bug 5504790): Modified locator validation to also check for new possible
43: value fnd_api.g_miss_num */

Line 44: IF x_loc_control = WIP_CONSTANTS.NO_CONTROL AND

40: P_Subinventory_Code = fnd_api.g_miss_char ) THEN
41:
42: /* Bug 5446216 (FP Bug 5504790): Modified locator validation to also check for new possible
43: value fnd_api.g_miss_num */
44: IF x_loc_control = WIP_CONSTANTS.NO_CONTROL AND
45: (P_Locator_Id IS NOT NULL OR P_Locator_Segments IS NOT NULL OR P_Locator_Id <> fnd_api.g_miss_num) THEN
46: P_Success_Flag := FALSE;
47: return;
48: END IF;

Line 57: ELSIF x_loc_control = WIP_CONSTANTS.PRESPECIFIED THEN

53:
54: return;
55:
56: /* Pre-specified Control */
57: ELSIF x_loc_control = WIP_CONSTANTS.PRESPECIFIED THEN
58:
59: x_flex_flag := 'CHECK_COMBINATION';
60:
61: IF P_Restrict_Flag = WIP_CONSTANTS.YES THEN

Line 61: IF P_Restrict_Flag = WIP_CONSTANTS.YES THEN

57: ELSIF x_loc_control = WIP_CONSTANTS.PRESPECIFIED THEN
58:
59: x_flex_flag := 'CHECK_COMBINATION';
60:
61: IF P_Restrict_Flag = WIP_CONSTANTS.YES THEN
62: /* x_where_clause :=
63: '(DISABLE_DATE > SYSDATE OR ' ||
64: 'DISABLE_DATE IS NULL) AND SUBINVENTORY_CODE = ' ||
65: P_Subinventory_Code

Line 96: ELSIF x_loc_control = WIP_CONSTANTS.DYNAMIC THEN

92:
93: END IF;
94:
95:
96: ELSIF x_loc_control = WIP_CONSTANTS.DYNAMIC THEN
97:
98: x_flex_flag := 'CREATE_COMBINATION';
99:
100: x_where_clause :=

Line 107: IF x_loc_control <> WIP_CONSTANTS.NO_CONTROL THEN

103: '= NVL(''' || P_Subinventory_Code || ''',''Z'') ';
104:
105: END IF;
106:
107: IF x_loc_control <> WIP_CONSTANTS.NO_CONTROL THEN
108:
109: /* Bug 5446216 (FP Bug 5504790): Modifieded locator validation to also check for new possible
110: value fnd_api.g_miss_num */
111: IF ((P_Locator_Id IS NULL AND P_Locator_Segments IS NULL) OR P_Locator_Id = fnd_api.g_miss_num)

Line 117: IF P_Restrict_Flag = WIP_CONSTANTS.YES

113: P_Success_Flag := FALSE;
114: return;
115: ELSIF P_Locator_Id IS NOT NULL THEN
116:
117: IF P_Restrict_Flag = WIP_CONSTANTS.YES
118: AND x_loc_control = WIP_CONSTANTS.PRESPECIFIED THEN
119:
120: SELECT COUNT(*)
121: INTO x_count

Line 118: AND x_loc_control = WIP_CONSTANTS.PRESPECIFIED THEN

114: return;
115: ELSIF P_Locator_Id IS NOT NULL THEN
116:
117: IF P_Restrict_Flag = WIP_CONSTANTS.YES
118: AND x_loc_control = WIP_CONSTANTS.PRESPECIFIED THEN
119:
120: SELECT COUNT(*)
121: INTO x_count
122: FROM MTL_ITEM_LOCATIONS

Line 164: IF x_loc_control = WIP_CONSTANTS.DYNAMIC THEN

160: If P_Success_Flag THEN
161:
162: P_Locator_Id := FND_FLEX_KEYVAL.COMBINATION_ID;
163:
164: IF x_loc_control = WIP_CONSTANTS.DYNAMIC THEN
165: UPDATE MTL_ITEM_LOCATIONS
166: SET SUBINVENTORY_CODE = P_Subinventory_Code
167: WHERE INVENTORY_LOCATION_ID = P_Locator_Id
168: AND ORGANIZATION_ID = P_Organization_Id;