DBA Data[Home] [Help]

APPS.WIP_DISCRETEJOB_UTIL dependencies on FND_API

Line 24: IF p_old_DiscreteJob_rec.alternate_bom_designator = FND_API.G_MISS_CHAR THEN

20: IF (p_ForceCopy is NOT NULL) THEN
21: IF (p_ForceCopy = TRUE)
22: THEN
23:
24: IF p_old_DiscreteJob_rec.alternate_bom_designator = FND_API.G_MISS_CHAR THEN
25: NULL;
26: ELSE
27: l_DiscreteJob_rec.alternate_bom_designator := p_old_DiscreteJob_rec.alternate_bom_designator;
28: END IF;

Line 30: IF p_old_DiscreteJob_rec.alternate_rout_designator = FND_API.G_MISS_CHAR THEN

26: ELSE
27: l_DiscreteJob_rec.alternate_bom_designator := p_old_DiscreteJob_rec.alternate_bom_designator;
28: END IF;
29:
30: IF p_old_DiscreteJob_rec.alternate_rout_designator = FND_API.G_MISS_CHAR THEN
31: NULL;
32: ELSE
33: l_DiscreteJob_rec.alternate_rout_designator := p_old_DiscreteJob_rec.alternate_rout_designator;
34: END IF;

Line 36: IF p_old_DiscreteJob_rec.attribute1 = FND_API.G_MISS_CHAR THEN

32: ELSE
33: l_DiscreteJob_rec.alternate_rout_designator := p_old_DiscreteJob_rec.alternate_rout_designator;
34: END IF;
35:
36: IF p_old_DiscreteJob_rec.attribute1 = FND_API.G_MISS_CHAR THEN
37: NULL;
38: ELSE
39: l_DiscreteJob_rec.attribute1 := p_old_DiscreteJob_rec.attribute1;
40: END IF;

Line 42: IF p_old_DiscreteJob_rec.attribute10 = FND_API.G_MISS_CHAR THEN

38: ELSE
39: l_DiscreteJob_rec.attribute1 := p_old_DiscreteJob_rec.attribute1;
40: END IF;
41:
42: IF p_old_DiscreteJob_rec.attribute10 = FND_API.G_MISS_CHAR THEN
43: NULL;
44: ELSE
45: l_DiscreteJob_rec.attribute10 := p_old_DiscreteJob_rec.attribute10;
46: END IF;

Line 48: IF p_old_DiscreteJob_rec.attribute11 = FND_API.G_MISS_CHAR THEN

44: ELSE
45: l_DiscreteJob_rec.attribute10 := p_old_DiscreteJob_rec.attribute10;
46: END IF;
47:
48: IF p_old_DiscreteJob_rec.attribute11 = FND_API.G_MISS_CHAR THEN
49: NULL;
50: ELSE
51: l_DiscreteJob_rec.attribute11 := p_old_DiscreteJob_rec.attribute11;
52: END IF;

Line 54: IF p_old_DiscreteJob_rec.attribute12 = FND_API.G_MISS_CHAR THEN

50: ELSE
51: l_DiscreteJob_rec.attribute11 := p_old_DiscreteJob_rec.attribute11;
52: END IF;
53:
54: IF p_old_DiscreteJob_rec.attribute12 = FND_API.G_MISS_CHAR THEN
55: NULL;
56: ELSE
57: l_DiscreteJob_rec.attribute12 := p_old_DiscreteJob_rec.attribute12;
58: END IF;

Line 60: IF p_old_DiscreteJob_rec.attribute13 = FND_API.G_MISS_CHAR THEN

56: ELSE
57: l_DiscreteJob_rec.attribute12 := p_old_DiscreteJob_rec.attribute12;
58: END IF;
59:
60: IF p_old_DiscreteJob_rec.attribute13 = FND_API.G_MISS_CHAR THEN
61: NULL;
62: ELSE
63: l_DiscreteJob_rec.attribute13 := p_old_DiscreteJob_rec.attribute13;
64: END IF;

Line 66: IF p_old_DiscreteJob_rec.attribute14 = FND_API.G_MISS_CHAR THEN

62: ELSE
63: l_DiscreteJob_rec.attribute13 := p_old_DiscreteJob_rec.attribute13;
64: END IF;
65:
66: IF p_old_DiscreteJob_rec.attribute14 = FND_API.G_MISS_CHAR THEN
67: NULL;
68: ELSE
69: l_DiscreteJob_rec.attribute14 := p_old_DiscreteJob_rec.attribute14;
70: END IF;

Line 72: IF p_old_DiscreteJob_rec.attribute15 = FND_API.G_MISS_CHAR THEN

68: ELSE
69: l_DiscreteJob_rec.attribute14 := p_old_DiscreteJob_rec.attribute14;
70: END IF;
71:
72: IF p_old_DiscreteJob_rec.attribute15 = FND_API.G_MISS_CHAR THEN
73: NULL;
74: ELSE
75: l_DiscreteJob_rec.attribute15 := p_old_DiscreteJob_rec.attribute15;
76: END IF;

Line 78: IF p_old_DiscreteJob_rec.attribute2 = FND_API.G_MISS_CHAR THEN

74: ELSE
75: l_DiscreteJob_rec.attribute15 := p_old_DiscreteJob_rec.attribute15;
76: END IF;
77:
78: IF p_old_DiscreteJob_rec.attribute2 = FND_API.G_MISS_CHAR THEN
79: NULL;
80: ELSE
81: l_DiscreteJob_rec.attribute2 := p_old_DiscreteJob_rec.attribute2;
82: END IF;

Line 84: IF p_old_DiscreteJob_rec.attribute3 = FND_API.G_MISS_CHAR THEN

80: ELSE
81: l_DiscreteJob_rec.attribute2 := p_old_DiscreteJob_rec.attribute2;
82: END IF;
83:
84: IF p_old_DiscreteJob_rec.attribute3 = FND_API.G_MISS_CHAR THEN
85: NULL;
86: ELSE
87: l_DiscreteJob_rec.attribute3 := p_old_DiscreteJob_rec.attribute3;
88: END IF;

Line 90: IF p_old_DiscreteJob_rec.attribute4 = FND_API.G_MISS_CHAR THEN

86: ELSE
87: l_DiscreteJob_rec.attribute3 := p_old_DiscreteJob_rec.attribute3;
88: END IF;
89:
90: IF p_old_DiscreteJob_rec.attribute4 = FND_API.G_MISS_CHAR THEN
91: NULL;
92: ELSE
93: l_DiscreteJob_rec.attribute4 := p_old_DiscreteJob_rec.attribute4;
94: END IF;

Line 96: IF p_old_DiscreteJob_rec.attribute5 = FND_API.G_MISS_CHAR THEN

92: ELSE
93: l_DiscreteJob_rec.attribute4 := p_old_DiscreteJob_rec.attribute4;
94: END IF;
95:
96: IF p_old_DiscreteJob_rec.attribute5 = FND_API.G_MISS_CHAR THEN
97: NULL;
98: ELSE
99: l_DiscreteJob_rec.attribute5 := p_old_DiscreteJob_rec.attribute5;
100: END IF;

Line 102: IF p_old_DiscreteJob_rec.attribute6 = FND_API.G_MISS_CHAR THEN

98: ELSE
99: l_DiscreteJob_rec.attribute5 := p_old_DiscreteJob_rec.attribute5;
100: END IF;
101:
102: IF p_old_DiscreteJob_rec.attribute6 = FND_API.G_MISS_CHAR THEN
103: NULL;
104: ELSE
105: l_DiscreteJob_rec.attribute6 := p_old_DiscreteJob_rec.attribute6;
106: END IF;

Line 108: IF p_old_DiscreteJob_rec.attribute7 = FND_API.G_MISS_CHAR THEN

104: ELSE
105: l_DiscreteJob_rec.attribute6 := p_old_DiscreteJob_rec.attribute6;
106: END IF;
107:
108: IF p_old_DiscreteJob_rec.attribute7 = FND_API.G_MISS_CHAR THEN
109: NULL;
110: ELSE
111: l_DiscreteJob_rec.attribute7 := p_old_DiscreteJob_rec.attribute7;
112: END IF;

Line 114: IF p_old_DiscreteJob_rec.attribute8 = FND_API.G_MISS_CHAR THEN

110: ELSE
111: l_DiscreteJob_rec.attribute7 := p_old_DiscreteJob_rec.attribute7;
112: END IF;
113:
114: IF p_old_DiscreteJob_rec.attribute8 = FND_API.G_MISS_CHAR THEN
115: NULL;
116: ELSE
117: l_DiscreteJob_rec.attribute8 := p_old_DiscreteJob_rec.attribute8;
118: END IF;

Line 120: IF p_old_DiscreteJob_rec.attribute9 = FND_API.G_MISS_CHAR THEN

116: ELSE
117: l_DiscreteJob_rec.attribute8 := p_old_DiscreteJob_rec.attribute8;
118: END IF;
119:
120: IF p_old_DiscreteJob_rec.attribute9 = FND_API.G_MISS_CHAR THEN
121: NULL;
122: ELSE
123: l_DiscreteJob_rec.attribute9 := p_old_DiscreteJob_rec.attribute9;
124: END IF;

Line 126: IF p_old_DiscreteJob_rec.attribute_category = FND_API.G_MISS_CHAR THEN

122: ELSE
123: l_DiscreteJob_rec.attribute9 := p_old_DiscreteJob_rec.attribute9;
124: END IF;
125:
126: IF p_old_DiscreteJob_rec.attribute_category = FND_API.G_MISS_CHAR THEN
127: NULL;
128: ELSE
129: l_DiscreteJob_rec.attribute_category := p_old_DiscreteJob_rec.attribute_category;
130: END IF;

Line 132: IF p_old_DiscreteJob_rec.bom_reference_id = FND_API.G_MISS_NUM THEN

128: ELSE
129: l_DiscreteJob_rec.attribute_category := p_old_DiscreteJob_rec.attribute_category;
130: END IF;
131:
132: IF p_old_DiscreteJob_rec.bom_reference_id = FND_API.G_MISS_NUM THEN
133: NULL;
134: ELSE
135: l_DiscreteJob_rec.bom_reference_id := p_old_DiscreteJob_rec.bom_reference_id;
136: END IF;

Line 138: IF p_old_DiscreteJob_rec.bom_revision = FND_API.G_MISS_CHAR THEN

134: ELSE
135: l_DiscreteJob_rec.bom_reference_id := p_old_DiscreteJob_rec.bom_reference_id;
136: END IF;
137:
138: IF p_old_DiscreteJob_rec.bom_revision = FND_API.G_MISS_CHAR THEN
139: NULL;
140: ELSE
141: l_DiscreteJob_rec.bom_revision := p_old_DiscreteJob_rec.bom_revision;
142: END IF;

Line 144: IF p_old_DiscreteJob_rec.bom_revision_date = FND_API.G_MISS_DATE THEN

140: ELSE
141: l_DiscreteJob_rec.bom_revision := p_old_DiscreteJob_rec.bom_revision;
142: END IF;
143:
144: IF p_old_DiscreteJob_rec.bom_revision_date = FND_API.G_MISS_DATE THEN
145: NULL;
146: ELSE
147: l_DiscreteJob_rec.bom_revision_date := p_old_DiscreteJob_rec.bom_revision_date;
148: END IF;

Line 150: IF p_old_DiscreteJob_rec.build_sequence = FND_API.G_MISS_NUM THEN

146: ELSE
147: l_DiscreteJob_rec.bom_revision_date := p_old_DiscreteJob_rec.bom_revision_date;
148: END IF;
149:
150: IF p_old_DiscreteJob_rec.build_sequence = FND_API.G_MISS_NUM THEN
151: NULL;
152: ELSE
153: l_DiscreteJob_rec.build_sequence := p_old_DiscreteJob_rec.build_sequence;
154: END IF;

Line 156: IF p_old_DiscreteJob_rec.class_code = FND_API.G_MISS_CHAR THEN

152: ELSE
153: l_DiscreteJob_rec.build_sequence := p_old_DiscreteJob_rec.build_sequence;
154: END IF;
155:
156: IF p_old_DiscreteJob_rec.class_code = FND_API.G_MISS_CHAR THEN
157: NULL;
158: ELSE
159: l_DiscreteJob_rec.class_code := p_old_DiscreteJob_rec.class_code;
160: END IF;

Line 162: IF p_old_DiscreteJob_rec.common_bom_sequence_id = FND_API.G_MISS_NUM THEN

158: ELSE
159: l_DiscreteJob_rec.class_code := p_old_DiscreteJob_rec.class_code;
160: END IF;
161:
162: IF p_old_DiscreteJob_rec.common_bom_sequence_id = FND_API.G_MISS_NUM THEN
163: NULL;
164: ELSE
165: l_DiscreteJob_rec.common_bom_sequence_id := p_old_DiscreteJob_rec.common_bom_sequence_id;
166: END IF;

Line 168: IF p_old_DiscreteJob_rec.common_rout_sequence_id = FND_API.G_MISS_NUM THEN

164: ELSE
165: l_DiscreteJob_rec.common_bom_sequence_id := p_old_DiscreteJob_rec.common_bom_sequence_id;
166: END IF;
167:
168: IF p_old_DiscreteJob_rec.common_rout_sequence_id = FND_API.G_MISS_NUM THEN
169: NULL;
170: ELSE
171: l_DiscreteJob_rec.common_rout_sequence_id := p_old_DiscreteJob_rec.common_rout_sequence_id;
172: END IF;

Line 174: IF p_old_DiscreteJob_rec.completion_locator_id = FND_API.G_MISS_NUM THEN

170: ELSE
171: l_DiscreteJob_rec.common_rout_sequence_id := p_old_DiscreteJob_rec.common_rout_sequence_id;
172: END IF;
173:
174: IF p_old_DiscreteJob_rec.completion_locator_id = FND_API.G_MISS_NUM THEN
175: NULL;
176: ELSE
177: l_DiscreteJob_rec.completion_locator_id := p_old_DiscreteJob_rec.completion_locator_id;
178: END IF;

Line 180: IF p_old_DiscreteJob_rec.completion_subinventory = FND_API.G_MISS_CHAR THEN

176: ELSE
177: l_DiscreteJob_rec.completion_locator_id := p_old_DiscreteJob_rec.completion_locator_id;
178: END IF;
179:
180: IF p_old_DiscreteJob_rec.completion_subinventory = FND_API.G_MISS_CHAR THEN
181: NULL;
182: ELSE
183: l_DiscreteJob_rec.completion_subinventory := p_old_DiscreteJob_rec.completion_subinventory;
184: END IF;

Line 186: IF p_old_DiscreteJob_rec.created_by = FND_API.G_MISS_NUM THEN

182: ELSE
183: l_DiscreteJob_rec.completion_subinventory := p_old_DiscreteJob_rec.completion_subinventory;
184: END IF;
185:
186: IF p_old_DiscreteJob_rec.created_by = FND_API.G_MISS_NUM THEN
187: NULL;
188: ELSE
189: l_DiscreteJob_rec.created_by := p_old_DiscreteJob_rec.created_by;
190: END IF;

Line 192: IF p_old_DiscreteJob_rec.creation_date = FND_API.G_MISS_DATE THEN

188: ELSE
189: l_DiscreteJob_rec.created_by := p_old_DiscreteJob_rec.created_by;
190: END IF;
191:
192: IF p_old_DiscreteJob_rec.creation_date = FND_API.G_MISS_DATE THEN
193: NULL;
194: ELSE
195: l_DiscreteJob_rec.creation_date := p_old_DiscreteJob_rec.creation_date;
196: END IF;

Line 198: IF p_old_DiscreteJob_rec.date_closed = FND_API.G_MISS_DATE THEN

194: ELSE
195: l_DiscreteJob_rec.creation_date := p_old_DiscreteJob_rec.creation_date;
196: END IF;
197:
198: IF p_old_DiscreteJob_rec.date_closed = FND_API.G_MISS_DATE THEN
199: NULL;
200: ELSE
201: l_DiscreteJob_rec.date_closed := p_old_DiscreteJob_rec.date_closed;
202: END IF;

Line 204: IF p_old_DiscreteJob_rec.date_completed = FND_API.G_MISS_DATE THEN

200: ELSE
201: l_DiscreteJob_rec.date_closed := p_old_DiscreteJob_rec.date_closed;
202: END IF;
203:
204: IF p_old_DiscreteJob_rec.date_completed = FND_API.G_MISS_DATE THEN
205: NULL;
206: ELSE
207: l_DiscreteJob_rec.date_completed := p_old_DiscreteJob_rec.date_completed;
208: END IF;

Line 210: IF p_old_DiscreteJob_rec.date_released = FND_API.G_MISS_DATE THEN

206: ELSE
207: l_DiscreteJob_rec.date_completed := p_old_DiscreteJob_rec.date_completed;
208: END IF;
209:
210: IF p_old_DiscreteJob_rec.date_released = FND_API.G_MISS_DATE THEN
211: NULL;
212: ELSE
213: l_DiscreteJob_rec.date_released := p_old_DiscreteJob_rec.date_released;
214: END IF;

Line 216: IF p_old_DiscreteJob_rec.demand_class = FND_API.G_MISS_CHAR THEN

212: ELSE
213: l_DiscreteJob_rec.date_released := p_old_DiscreteJob_rec.date_released;
214: END IF;
215:
216: IF p_old_DiscreteJob_rec.demand_class = FND_API.G_MISS_CHAR THEN
217: NULL;
218: ELSE
219: l_DiscreteJob_rec.demand_class := p_old_DiscreteJob_rec.demand_class;
220: END IF;

Line 222: IF p_old_DiscreteJob_rec.description = FND_API.G_MISS_CHAR THEN

218: ELSE
219: l_DiscreteJob_rec.demand_class := p_old_DiscreteJob_rec.demand_class;
220: END IF;
221:
222: IF p_old_DiscreteJob_rec.description = FND_API.G_MISS_CHAR THEN
223: NULL;
224: ELSE
225: l_DiscreteJob_rec.description := p_old_DiscreteJob_rec.description;
226: END IF;

Line 228: IF p_old_DiscreteJob_rec.firm_planned_flag = FND_API.G_MISS_NUM THEN

224: ELSE
225: l_DiscreteJob_rec.description := p_old_DiscreteJob_rec.description;
226: END IF;
227:
228: IF p_old_DiscreteJob_rec.firm_planned_flag = FND_API.G_MISS_NUM THEN
229: NULL;
230: ELSE
231: l_DiscreteJob_rec.firm_planned_flag := p_old_DiscreteJob_rec.firm_planned_flag;
232: END IF;

Line 234: IF p_old_DiscreteJob_rec.job_type = FND_API.G_MISS_NUM THEN

230: ELSE
231: l_DiscreteJob_rec.firm_planned_flag := p_old_DiscreteJob_rec.firm_planned_flag;
232: END IF;
233:
234: IF p_old_DiscreteJob_rec.job_type = FND_API.G_MISS_NUM THEN
235: NULL;
236: ELSE
237: l_DiscreteJob_rec.job_type := p_old_DiscreteJob_rec.job_type;
238: END IF;

Line 240: IF p_old_DiscreteJob_rec.kanban_card_id = FND_API.G_MISS_NUM THEN

236: ELSE
237: l_DiscreteJob_rec.job_type := p_old_DiscreteJob_rec.job_type;
238: END IF;
239:
240: IF p_old_DiscreteJob_rec.kanban_card_id = FND_API.G_MISS_NUM THEN
241: NULL;
242: ELSE
243: l_DiscreteJob_rec.kanban_card_id := p_old_DiscreteJob_rec.kanban_card_id;
244: END IF;

Line 246: IF p_old_DiscreteJob_rec.last_updated_by = FND_API.G_MISS_NUM THEN

242: ELSE
243: l_DiscreteJob_rec.kanban_card_id := p_old_DiscreteJob_rec.kanban_card_id;
244: END IF;
245:
246: IF p_old_DiscreteJob_rec.last_updated_by = FND_API.G_MISS_NUM THEN
247: NULL;
248: ELSE
249: l_DiscreteJob_rec.last_updated_by := p_old_DiscreteJob_rec.last_updated_by;
250: END IF;

Line 252: IF p_old_DiscreteJob_rec.last_update_date = FND_API.G_MISS_DATE THEN

248: ELSE
249: l_DiscreteJob_rec.last_updated_by := p_old_DiscreteJob_rec.last_updated_by;
250: END IF;
251:
252: IF p_old_DiscreteJob_rec.last_update_date = FND_API.G_MISS_DATE THEN
253: NULL;
254: ELSE
255: l_DiscreteJob_rec.last_update_date := p_old_DiscreteJob_rec.last_update_date;
256: END IF;

Line 258: IF p_old_DiscreteJob_rec.last_update_login = FND_API.G_MISS_NUM THEN

254: ELSE
255: l_DiscreteJob_rec.last_update_date := p_old_DiscreteJob_rec.last_update_date;
256: END IF;
257:
258: IF p_old_DiscreteJob_rec.last_update_login = FND_API.G_MISS_NUM THEN
259: NULL;
260: ELSE
261: l_DiscreteJob_rec.last_update_login := p_old_DiscreteJob_rec.last_update_login;
262: END IF;

Line 264: IF p_old_DiscreteJob_rec.line_id = FND_API.G_MISS_NUM THEN

260: ELSE
261: l_DiscreteJob_rec.last_update_login := p_old_DiscreteJob_rec.last_update_login;
262: END IF;
263:
264: IF p_old_DiscreteJob_rec.line_id = FND_API.G_MISS_NUM THEN
265: NULL;
266: ELSE
267: l_DiscreteJob_rec.line_id := p_old_DiscreteJob_rec.line_id;
268: END IF;

Line 270: IF p_old_DiscreteJob_rec.lot_number = FND_API.G_MISS_CHAR THEN

266: ELSE
267: l_DiscreteJob_rec.line_id := p_old_DiscreteJob_rec.line_id;
268: END IF;
269:
270: IF p_old_DiscreteJob_rec.lot_number = FND_API.G_MISS_CHAR THEN
271: NULL;
272: ELSE
273: l_DiscreteJob_rec.lot_number := p_old_DiscreteJob_rec.lot_number;
274: END IF;

Line 276: IF p_old_DiscreteJob_rec.material_account = FND_API.G_MISS_NUM THEN

272: ELSE
273: l_DiscreteJob_rec.lot_number := p_old_DiscreteJob_rec.lot_number;
274: END IF;
275:
276: IF p_old_DiscreteJob_rec.material_account = FND_API.G_MISS_NUM THEN
277: NULL;
278: ELSE
279: l_DiscreteJob_rec.material_account := p_old_DiscreteJob_rec.material_account;
280: END IF;

Line 282: IF p_old_DiscreteJob_rec.material_overhead_account = FND_API.G_MISS_NUM THEN

278: ELSE
279: l_DiscreteJob_rec.material_account := p_old_DiscreteJob_rec.material_account;
280: END IF;
281:
282: IF p_old_DiscreteJob_rec.material_overhead_account = FND_API.G_MISS_NUM THEN
283: NULL;
284: ELSE
285: l_DiscreteJob_rec.material_overhead_account := p_old_DiscreteJob_rec.material_overhead_account;
286: END IF;

Line 288: IF p_old_DiscreteJob_rec.material_variance_account = FND_API.G_MISS_NUM THEN

284: ELSE
285: l_DiscreteJob_rec.material_overhead_account := p_old_DiscreteJob_rec.material_overhead_account;
286: END IF;
287:
288: IF p_old_DiscreteJob_rec.material_variance_account = FND_API.G_MISS_NUM THEN
289: NULL;
290: ELSE
291: l_DiscreteJob_rec.material_variance_account := p_old_DiscreteJob_rec.material_variance_account;
292: END IF;

Line 294: IF p_old_DiscreteJob_rec.mps_net_quantity = FND_API.G_MISS_NUM THEN

290: ELSE
291: l_DiscreteJob_rec.material_variance_account := p_old_DiscreteJob_rec.material_variance_account;
292: END IF;
293:
294: IF p_old_DiscreteJob_rec.mps_net_quantity = FND_API.G_MISS_NUM THEN
295: NULL;
296: ELSE
297: l_DiscreteJob_rec.mps_net_quantity := p_old_DiscreteJob_rec.mps_net_quantity;
298: END IF;

Line 300: IF p_old_DiscreteJob_rec.mps_scheduled_cpl_date = FND_API.G_MISS_DATE THEN

296: ELSE
297: l_DiscreteJob_rec.mps_net_quantity := p_old_DiscreteJob_rec.mps_net_quantity;
298: END IF;
299:
300: IF p_old_DiscreteJob_rec.mps_scheduled_cpl_date = FND_API.G_MISS_DATE THEN
301: NULL;
302: ELSE
303: l_DiscreteJob_rec.mps_scheduled_cpl_date := p_old_DiscreteJob_rec.mps_scheduled_cpl_date;
304: END IF;

Line 306: IF p_old_DiscreteJob_rec.net_quantity = FND_API.G_MISS_NUM THEN

302: ELSE
303: l_DiscreteJob_rec.mps_scheduled_cpl_date := p_old_DiscreteJob_rec.mps_scheduled_cpl_date;
304: END IF;
305:
306: IF p_old_DiscreteJob_rec.net_quantity = FND_API.G_MISS_NUM THEN
307: NULL;
308: ELSE
309: l_DiscreteJob_rec.net_quantity := p_old_DiscreteJob_rec.net_quantity;
310: END IF;

Line 312: IF p_old_DiscreteJob_rec.organization_id = FND_API.G_MISS_NUM THEN

308: ELSE
309: l_DiscreteJob_rec.net_quantity := p_old_DiscreteJob_rec.net_quantity;
310: END IF;
311:
312: IF p_old_DiscreteJob_rec.organization_id = FND_API.G_MISS_NUM THEN
313: NULL;
314: ELSE
315: l_DiscreteJob_rec.organization_id := p_old_DiscreteJob_rec.organization_id;
316: END IF;

Line 318: IF p_old_DiscreteJob_rec.osp_account = FND_API.G_MISS_NUM THEN

314: ELSE
315: l_DiscreteJob_rec.organization_id := p_old_DiscreteJob_rec.organization_id;
316: END IF;
317:
318: IF p_old_DiscreteJob_rec.osp_account = FND_API.G_MISS_NUM THEN
319: NULL;
320: ELSE
321: l_DiscreteJob_rec.osp_account := p_old_DiscreteJob_rec.osp_account;
322: END IF;

Line 324: IF p_old_DiscreteJob_rec.osp_variance_account = FND_API.G_MISS_NUM THEN

320: ELSE
321: l_DiscreteJob_rec.osp_account := p_old_DiscreteJob_rec.osp_account;
322: END IF;
323:
324: IF p_old_DiscreteJob_rec.osp_variance_account = FND_API.G_MISS_NUM THEN
325: NULL;
326: ELSE
327: l_DiscreteJob_rec.osp_variance_account := p_old_DiscreteJob_rec.osp_variance_account;
328: END IF;

Line 330: IF p_old_DiscreteJob_rec.overcpl_tolerance_type = FND_API.G_MISS_NUM THEN

326: ELSE
327: l_DiscreteJob_rec.osp_variance_account := p_old_DiscreteJob_rec.osp_variance_account;
328: END IF;
329:
330: IF p_old_DiscreteJob_rec.overcpl_tolerance_type = FND_API.G_MISS_NUM THEN
331: NULL;
332: ELSE
333: l_DiscreteJob_rec.overcpl_tolerance_type := p_old_DiscreteJob_rec.overcpl_tolerance_type;
334: END IF;

Line 336: IF p_old_DiscreteJob_rec.overcpl_tolerance_value = FND_API.G_MISS_NUM THEN

332: ELSE
333: l_DiscreteJob_rec.overcpl_tolerance_type := p_old_DiscreteJob_rec.overcpl_tolerance_type;
334: END IF;
335:
336: IF p_old_DiscreteJob_rec.overcpl_tolerance_value = FND_API.G_MISS_NUM THEN
337: NULL;
338: ELSE
339: l_DiscreteJob_rec.overcpl_tolerance_value := p_old_DiscreteJob_rec.overcpl_tolerance_value;
340: END IF;

Line 342: IF p_old_DiscreteJob_rec.overhead_account = FND_API.G_MISS_NUM THEN

338: ELSE
339: l_DiscreteJob_rec.overcpl_tolerance_value := p_old_DiscreteJob_rec.overcpl_tolerance_value;
340: END IF;
341:
342: IF p_old_DiscreteJob_rec.overhead_account = FND_API.G_MISS_NUM THEN
343: NULL;
344: ELSE
345: l_DiscreteJob_rec.overhead_account := p_old_DiscreteJob_rec.overhead_account;
346: END IF;

Line 348: IF p_old_DiscreteJob_rec.overhead_variance_account = FND_API.G_MISS_NUM THEN

344: ELSE
345: l_DiscreteJob_rec.overhead_account := p_old_DiscreteJob_rec.overhead_account;
346: END IF;
347:
348: IF p_old_DiscreteJob_rec.overhead_variance_account = FND_API.G_MISS_NUM THEN
349: NULL;
350: ELSE
351: l_DiscreteJob_rec.overhead_variance_account := p_old_DiscreteJob_rec.overhead_variance_account;
352: END IF;

Line 354: IF p_old_DiscreteJob_rec.primary_item_id = FND_API.G_MISS_NUM THEN

350: ELSE
351: l_DiscreteJob_rec.overhead_variance_account := p_old_DiscreteJob_rec.overhead_variance_account;
352: END IF;
353:
354: IF p_old_DiscreteJob_rec.primary_item_id = FND_API.G_MISS_NUM THEN
355: NULL;
356: ELSE
357: l_DiscreteJob_rec.primary_item_id := p_old_DiscreteJob_rec.primary_item_id;
358: END IF;

Line 360: IF p_old_DiscreteJob_rec.program_application_id = FND_API.G_MISS_NUM THEN

356: ELSE
357: l_DiscreteJob_rec.primary_item_id := p_old_DiscreteJob_rec.primary_item_id;
358: END IF;
359:
360: IF p_old_DiscreteJob_rec.program_application_id = FND_API.G_MISS_NUM THEN
361: NULL;
362: ELSE
363: l_DiscreteJob_rec.program_application_id := p_old_DiscreteJob_rec.program_application_id;
364: END IF;

Line 366: IF p_old_DiscreteJob_rec.program_id = FND_API.G_MISS_NUM THEN

362: ELSE
363: l_DiscreteJob_rec.program_application_id := p_old_DiscreteJob_rec.program_application_id;
364: END IF;
365:
366: IF p_old_DiscreteJob_rec.program_id = FND_API.G_MISS_NUM THEN
367: NULL;
368: ELSE
369: l_DiscreteJob_rec.program_id := p_old_DiscreteJob_rec.program_id;
370: END IF;

Line 372: IF p_old_DiscreteJob_rec.program_update_date = FND_API.G_MISS_DATE THEN

368: ELSE
369: l_DiscreteJob_rec.program_id := p_old_DiscreteJob_rec.program_id;
370: END IF;
371:
372: IF p_old_DiscreteJob_rec.program_update_date = FND_API.G_MISS_DATE THEN
373: NULL;
374: ELSE
375: l_DiscreteJob_rec.program_update_date := p_old_DiscreteJob_rec.program_update_date;
376: END IF;

Line 378: IF p_old_DiscreteJob_rec.project_costed = FND_API.G_MISS_NUM THEN

374: ELSE
375: l_DiscreteJob_rec.program_update_date := p_old_DiscreteJob_rec.program_update_date;
376: END IF;
377:
378: IF p_old_DiscreteJob_rec.project_costed = FND_API.G_MISS_NUM THEN
379: NULL;
380: ELSE
381: l_DiscreteJob_rec.project_costed := p_old_DiscreteJob_rec.project_costed;
382: END IF;

Line 384: IF p_old_DiscreteJob_rec.project_id = FND_API.G_MISS_NUM THEN

380: ELSE
381: l_DiscreteJob_rec.project_costed := p_old_DiscreteJob_rec.project_costed;
382: END IF;
383:
384: IF p_old_DiscreteJob_rec.project_id = FND_API.G_MISS_NUM THEN
385: NULL;
386: ELSE
387: l_DiscreteJob_rec.project_id := p_old_DiscreteJob_rec.project_id;
388: END IF;

Line 390: IF p_old_DiscreteJob_rec.quantity_completed = FND_API.G_MISS_NUM THEN

386: ELSE
387: l_DiscreteJob_rec.project_id := p_old_DiscreteJob_rec.project_id;
388: END IF;
389:
390: IF p_old_DiscreteJob_rec.quantity_completed = FND_API.G_MISS_NUM THEN
391: NULL;
392: ELSE
393: l_DiscreteJob_rec.quantity_completed := p_old_DiscreteJob_rec.quantity_completed;
394: END IF;

Line 396: IF p_old_DiscreteJob_rec.quantity_scrapped = FND_API.G_MISS_NUM THEN

392: ELSE
393: l_DiscreteJob_rec.quantity_completed := p_old_DiscreteJob_rec.quantity_completed;
394: END IF;
395:
396: IF p_old_DiscreteJob_rec.quantity_scrapped = FND_API.G_MISS_NUM THEN
397: NULL;
398: ELSE
399: l_DiscreteJob_rec.quantity_scrapped := p_old_DiscreteJob_rec.quantity_scrapped;
400: END IF;

Line 402: IF p_old_DiscreteJob_rec.request_id = FND_API.G_MISS_NUM THEN

398: ELSE
399: l_DiscreteJob_rec.quantity_scrapped := p_old_DiscreteJob_rec.quantity_scrapped;
400: END IF;
401:
402: IF p_old_DiscreteJob_rec.request_id = FND_API.G_MISS_NUM THEN
403: NULL;
404: ELSE
405: l_DiscreteJob_rec.request_id := p_old_DiscreteJob_rec.request_id;
406: END IF;

Line 408: IF p_old_DiscreteJob_rec.resource_account = FND_API.G_MISS_NUM THEN

404: ELSE
405: l_DiscreteJob_rec.request_id := p_old_DiscreteJob_rec.request_id;
406: END IF;
407:
408: IF p_old_DiscreteJob_rec.resource_account = FND_API.G_MISS_NUM THEN
409: NULL;
410: ELSE
411: l_DiscreteJob_rec.resource_account := p_old_DiscreteJob_rec.resource_account;
412: END IF;

Line 414: IF p_old_DiscreteJob_rec.resource_variance_account = FND_API.G_MISS_NUM THEN

410: ELSE
411: l_DiscreteJob_rec.resource_account := p_old_DiscreteJob_rec.resource_account;
412: END IF;
413:
414: IF p_old_DiscreteJob_rec.resource_variance_account = FND_API.G_MISS_NUM THEN
415: NULL;
416: ELSE
417: l_DiscreteJob_rec.resource_variance_account := p_old_DiscreteJob_rec.resource_variance_account;
418: END IF;

Line 420: IF p_old_DiscreteJob_rec.routing_reference_id = FND_API.G_MISS_NUM THEN

416: ELSE
417: l_DiscreteJob_rec.resource_variance_account := p_old_DiscreteJob_rec.resource_variance_account;
418: END IF;
419:
420: IF p_old_DiscreteJob_rec.routing_reference_id = FND_API.G_MISS_NUM THEN
421: NULL;
422: ELSE
423: l_DiscreteJob_rec.routing_reference_id := p_old_DiscreteJob_rec.routing_reference_id;
424: END IF;

Line 426: IF p_old_DiscreteJob_rec.routing_revision = FND_API.G_MISS_CHAR THEN

422: ELSE
423: l_DiscreteJob_rec.routing_reference_id := p_old_DiscreteJob_rec.routing_reference_id;
424: END IF;
425:
426: IF p_old_DiscreteJob_rec.routing_revision = FND_API.G_MISS_CHAR THEN
427: NULL;
428: ELSE
429: l_DiscreteJob_rec.routing_revision := p_old_DiscreteJob_rec.routing_revision;
430: END IF;

Line 432: IF p_old_DiscreteJob_rec.routing_revision_date = FND_API.G_MISS_DATE THEN

428: ELSE
429: l_DiscreteJob_rec.routing_revision := p_old_DiscreteJob_rec.routing_revision;
430: END IF;
431:
432: IF p_old_DiscreteJob_rec.routing_revision_date = FND_API.G_MISS_DATE THEN
433: NULL;
434: ELSE
435: l_DiscreteJob_rec.routing_revision_date := p_old_DiscreteJob_rec.routing_revision_date;
436: END IF;

Line 438: IF p_old_DiscreteJob_rec.scheduled_completion_date = FND_API.G_MISS_DATE THEN

434: ELSE
435: l_DiscreteJob_rec.routing_revision_date := p_old_DiscreteJob_rec.routing_revision_date;
436: END IF;
437:
438: IF p_old_DiscreteJob_rec.scheduled_completion_date = FND_API.G_MISS_DATE THEN
439: NULL;
440: ELSE
441: l_DiscreteJob_rec.scheduled_completion_date := p_old_DiscreteJob_rec.scheduled_completion_date;
442: END IF;

Line 444: IF p_old_DiscreteJob_rec.scheduled_start_date = FND_API.G_MISS_DATE THEN

440: ELSE
441: l_DiscreteJob_rec.scheduled_completion_date := p_old_DiscreteJob_rec.scheduled_completion_date;
442: END IF;
443:
444: IF p_old_DiscreteJob_rec.scheduled_start_date = FND_API.G_MISS_DATE THEN
445: NULL;
446: ELSE
447: l_DiscreteJob_rec.scheduled_start_date := p_old_DiscreteJob_rec.scheduled_start_date;
448: END IF;

Line 450: IF p_old_DiscreteJob_rec.schedule_group_id = FND_API.G_MISS_NUM THEN

446: ELSE
447: l_DiscreteJob_rec.scheduled_start_date := p_old_DiscreteJob_rec.scheduled_start_date;
448: END IF;
449:
450: IF p_old_DiscreteJob_rec.schedule_group_id = FND_API.G_MISS_NUM THEN
451: NULL;
452: ELSE
453: l_DiscreteJob_rec.schedule_group_id := p_old_DiscreteJob_rec.schedule_group_id;
454: END IF;

Line 456: IF p_old_DiscreteJob_rec.source_code = FND_API.G_MISS_CHAR THEN

452: ELSE
453: l_DiscreteJob_rec.schedule_group_id := p_old_DiscreteJob_rec.schedule_group_id;
454: END IF;
455:
456: IF p_old_DiscreteJob_rec.source_code = FND_API.G_MISS_CHAR THEN
457: NULL;
458: ELSE
459: l_DiscreteJob_rec.source_code := p_old_DiscreteJob_rec.source_code;
460: END IF;

Line 462: IF p_old_DiscreteJob_rec.source_line_id = FND_API.G_MISS_NUM THEN

458: ELSE
459: l_DiscreteJob_rec.source_code := p_old_DiscreteJob_rec.source_code;
460: END IF;
461:
462: IF p_old_DiscreteJob_rec.source_line_id = FND_API.G_MISS_NUM THEN
463: NULL;
464: ELSE
465: l_DiscreteJob_rec.source_line_id := p_old_DiscreteJob_rec.source_line_id;
466: END IF;

Line 468: IF p_old_DiscreteJob_rec.start_quantity = FND_API.G_MISS_NUM THEN

464: ELSE
465: l_DiscreteJob_rec.source_line_id := p_old_DiscreteJob_rec.source_line_id;
466: END IF;
467:
468: IF p_old_DiscreteJob_rec.start_quantity = FND_API.G_MISS_NUM THEN
469: NULL;
470: ELSE
471: l_DiscreteJob_rec.start_quantity := p_old_DiscreteJob_rec.start_quantity;
472: END IF;

Line 474: IF p_old_DiscreteJob_rec.status_type = FND_API.G_MISS_NUM THEN

470: ELSE
471: l_DiscreteJob_rec.start_quantity := p_old_DiscreteJob_rec.start_quantity;
472: END IF;
473:
474: IF p_old_DiscreteJob_rec.status_type = FND_API.G_MISS_NUM THEN
475: NULL;
476: ELSE
477: l_DiscreteJob_rec.status_type := p_old_DiscreteJob_rec.status_type;
478: END IF;

Line 480: IF p_old_DiscreteJob_rec.std_cost_adj_account = FND_API.G_MISS_NUM THEN

476: ELSE
477: l_DiscreteJob_rec.status_type := p_old_DiscreteJob_rec.status_type;
478: END IF;
479:
480: IF p_old_DiscreteJob_rec.std_cost_adj_account = FND_API.G_MISS_NUM THEN
481: NULL;
482: ELSE
483: l_DiscreteJob_rec.std_cost_adj_account := p_old_DiscreteJob_rec.std_cost_adj_account;
484: END IF;

Line 486: IF p_old_DiscreteJob_rec.task_id = FND_API.G_MISS_NUM THEN

482: ELSE
483: l_DiscreteJob_rec.std_cost_adj_account := p_old_DiscreteJob_rec.std_cost_adj_account;
484: END IF;
485:
486: IF p_old_DiscreteJob_rec.task_id = FND_API.G_MISS_NUM THEN
487: NULL;
488: ELSE
489: l_DiscreteJob_rec.task_id := p_old_DiscreteJob_rec.task_id;
490: END IF;

Line 492: IF p_old_DiscreteJob_rec.wip_entity_id = FND_API.G_MISS_NUM THEN

488: ELSE
489: l_DiscreteJob_rec.task_id := p_old_DiscreteJob_rec.task_id;
490: END IF;
491:
492: IF p_old_DiscreteJob_rec.wip_entity_id = FND_API.G_MISS_NUM THEN
493: NULL;
494: ELSE
495: l_DiscreteJob_rec.wip_entity_id := p_old_DiscreteJob_rec.wip_entity_id;
496: END IF;

Line 498: IF p_old_DiscreteJob_rec.wip_supply_type = FND_API.G_MISS_NUM THEN

494: ELSE
495: l_DiscreteJob_rec.wip_entity_id := p_old_DiscreteJob_rec.wip_entity_id;
496: END IF;
497:
498: IF p_old_DiscreteJob_rec.wip_supply_type = FND_API.G_MISS_NUM THEN
499: NULL;
500: ELSE
501: l_DiscreteJob_rec.wip_supply_type := p_old_DiscreteJob_rec.wip_supply_type;
502: END IF;

Line 506: IF l_DiscreteJob_rec.alternate_bom_designator = FND_API.G_MISS_CHAR THEN

502: END IF;
503:
504: ELSE
505:
506: IF l_DiscreteJob_rec.alternate_bom_designator = FND_API.G_MISS_CHAR THEN
507: l_DiscreteJob_rec.alternate_bom_designator := p_old_DiscreteJob_rec.alternate_bom_designator;
508: END IF;
509:
510: IF l_DiscreteJob_rec.alternate_rout_designator = FND_API.G_MISS_CHAR THEN

Line 510: IF l_DiscreteJob_rec.alternate_rout_designator = FND_API.G_MISS_CHAR THEN

506: IF l_DiscreteJob_rec.alternate_bom_designator = FND_API.G_MISS_CHAR THEN
507: l_DiscreteJob_rec.alternate_bom_designator := p_old_DiscreteJob_rec.alternate_bom_designator;
508: END IF;
509:
510: IF l_DiscreteJob_rec.alternate_rout_designator = FND_API.G_MISS_CHAR THEN
511: l_DiscreteJob_rec.alternate_rout_designator := p_old_DiscreteJob_rec.alternate_rout_designator;
512: END IF;
513:
514: IF l_DiscreteJob_rec.attribute1 = FND_API.G_MISS_CHAR THEN

Line 514: IF l_DiscreteJob_rec.attribute1 = FND_API.G_MISS_CHAR THEN

510: IF l_DiscreteJob_rec.alternate_rout_designator = FND_API.G_MISS_CHAR THEN
511: l_DiscreteJob_rec.alternate_rout_designator := p_old_DiscreteJob_rec.alternate_rout_designator;
512: END IF;
513:
514: IF l_DiscreteJob_rec.attribute1 = FND_API.G_MISS_CHAR THEN
515: l_DiscreteJob_rec.attribute1 := p_old_DiscreteJob_rec.attribute1;
516: END IF;
517:
518: IF l_DiscreteJob_rec.attribute10 = FND_API.G_MISS_CHAR THEN

Line 518: IF l_DiscreteJob_rec.attribute10 = FND_API.G_MISS_CHAR THEN

514: IF l_DiscreteJob_rec.attribute1 = FND_API.G_MISS_CHAR THEN
515: l_DiscreteJob_rec.attribute1 := p_old_DiscreteJob_rec.attribute1;
516: END IF;
517:
518: IF l_DiscreteJob_rec.attribute10 = FND_API.G_MISS_CHAR THEN
519: l_DiscreteJob_rec.attribute10 := p_old_DiscreteJob_rec.attribute10;
520: END IF;
521:
522: IF l_DiscreteJob_rec.attribute11 = FND_API.G_MISS_CHAR THEN

Line 522: IF l_DiscreteJob_rec.attribute11 = FND_API.G_MISS_CHAR THEN

518: IF l_DiscreteJob_rec.attribute10 = FND_API.G_MISS_CHAR THEN
519: l_DiscreteJob_rec.attribute10 := p_old_DiscreteJob_rec.attribute10;
520: END IF;
521:
522: IF l_DiscreteJob_rec.attribute11 = FND_API.G_MISS_CHAR THEN
523: l_DiscreteJob_rec.attribute11 := p_old_DiscreteJob_rec.attribute11;
524: END IF;
525:
526: IF l_DiscreteJob_rec.attribute12 = FND_API.G_MISS_CHAR THEN

Line 526: IF l_DiscreteJob_rec.attribute12 = FND_API.G_MISS_CHAR THEN

522: IF l_DiscreteJob_rec.attribute11 = FND_API.G_MISS_CHAR THEN
523: l_DiscreteJob_rec.attribute11 := p_old_DiscreteJob_rec.attribute11;
524: END IF;
525:
526: IF l_DiscreteJob_rec.attribute12 = FND_API.G_MISS_CHAR THEN
527: l_DiscreteJob_rec.attribute12 := p_old_DiscreteJob_rec.attribute12;
528: END IF;
529:
530: IF l_DiscreteJob_rec.attribute13 = FND_API.G_MISS_CHAR THEN

Line 530: IF l_DiscreteJob_rec.attribute13 = FND_API.G_MISS_CHAR THEN

526: IF l_DiscreteJob_rec.attribute12 = FND_API.G_MISS_CHAR THEN
527: l_DiscreteJob_rec.attribute12 := p_old_DiscreteJob_rec.attribute12;
528: END IF;
529:
530: IF l_DiscreteJob_rec.attribute13 = FND_API.G_MISS_CHAR THEN
531: l_DiscreteJob_rec.attribute13 := p_old_DiscreteJob_rec.attribute13;
532: END IF;
533:
534: IF l_DiscreteJob_rec.attribute14 = FND_API.G_MISS_CHAR THEN

Line 534: IF l_DiscreteJob_rec.attribute14 = FND_API.G_MISS_CHAR THEN

530: IF l_DiscreteJob_rec.attribute13 = FND_API.G_MISS_CHAR THEN
531: l_DiscreteJob_rec.attribute13 := p_old_DiscreteJob_rec.attribute13;
532: END IF;
533:
534: IF l_DiscreteJob_rec.attribute14 = FND_API.G_MISS_CHAR THEN
535: l_DiscreteJob_rec.attribute14 := p_old_DiscreteJob_rec.attribute14;
536: END IF;
537:
538: IF l_DiscreteJob_rec.attribute15 = FND_API.G_MISS_CHAR THEN

Line 538: IF l_DiscreteJob_rec.attribute15 = FND_API.G_MISS_CHAR THEN

534: IF l_DiscreteJob_rec.attribute14 = FND_API.G_MISS_CHAR THEN
535: l_DiscreteJob_rec.attribute14 := p_old_DiscreteJob_rec.attribute14;
536: END IF;
537:
538: IF l_DiscreteJob_rec.attribute15 = FND_API.G_MISS_CHAR THEN
539: l_DiscreteJob_rec.attribute15 := p_old_DiscreteJob_rec.attribute15;
540: END IF;
541:
542: IF l_DiscreteJob_rec.attribute2 = FND_API.G_MISS_CHAR THEN

Line 542: IF l_DiscreteJob_rec.attribute2 = FND_API.G_MISS_CHAR THEN

538: IF l_DiscreteJob_rec.attribute15 = FND_API.G_MISS_CHAR THEN
539: l_DiscreteJob_rec.attribute15 := p_old_DiscreteJob_rec.attribute15;
540: END IF;
541:
542: IF l_DiscreteJob_rec.attribute2 = FND_API.G_MISS_CHAR THEN
543: l_DiscreteJob_rec.attribute2 := p_old_DiscreteJob_rec.attribute2;
544: END IF;
545:
546: IF l_DiscreteJob_rec.attribute3 = FND_API.G_MISS_CHAR THEN

Line 546: IF l_DiscreteJob_rec.attribute3 = FND_API.G_MISS_CHAR THEN

542: IF l_DiscreteJob_rec.attribute2 = FND_API.G_MISS_CHAR THEN
543: l_DiscreteJob_rec.attribute2 := p_old_DiscreteJob_rec.attribute2;
544: END IF;
545:
546: IF l_DiscreteJob_rec.attribute3 = FND_API.G_MISS_CHAR THEN
547: l_DiscreteJob_rec.attribute3 := p_old_DiscreteJob_rec.attribute3;
548: END IF;
549:
550: IF l_DiscreteJob_rec.attribute4 = FND_API.G_MISS_CHAR THEN

Line 550: IF l_DiscreteJob_rec.attribute4 = FND_API.G_MISS_CHAR THEN

546: IF l_DiscreteJob_rec.attribute3 = FND_API.G_MISS_CHAR THEN
547: l_DiscreteJob_rec.attribute3 := p_old_DiscreteJob_rec.attribute3;
548: END IF;
549:
550: IF l_DiscreteJob_rec.attribute4 = FND_API.G_MISS_CHAR THEN
551: l_DiscreteJob_rec.attribute4 := p_old_DiscreteJob_rec.attribute4;
552: END IF;
553:
554: IF l_DiscreteJob_rec.attribute5 = FND_API.G_MISS_CHAR THEN

Line 554: IF l_DiscreteJob_rec.attribute5 = FND_API.G_MISS_CHAR THEN

550: IF l_DiscreteJob_rec.attribute4 = FND_API.G_MISS_CHAR THEN
551: l_DiscreteJob_rec.attribute4 := p_old_DiscreteJob_rec.attribute4;
552: END IF;
553:
554: IF l_DiscreteJob_rec.attribute5 = FND_API.G_MISS_CHAR THEN
555: l_DiscreteJob_rec.attribute5 := p_old_DiscreteJob_rec.attribute5;
556: END IF;
557:
558: IF l_DiscreteJob_rec.attribute6 = FND_API.G_MISS_CHAR THEN

Line 558: IF l_DiscreteJob_rec.attribute6 = FND_API.G_MISS_CHAR THEN

554: IF l_DiscreteJob_rec.attribute5 = FND_API.G_MISS_CHAR THEN
555: l_DiscreteJob_rec.attribute5 := p_old_DiscreteJob_rec.attribute5;
556: END IF;
557:
558: IF l_DiscreteJob_rec.attribute6 = FND_API.G_MISS_CHAR THEN
559: l_DiscreteJob_rec.attribute6 := p_old_DiscreteJob_rec.attribute6;
560: END IF;
561:
562: IF l_DiscreteJob_rec.attribute7 = FND_API.G_MISS_CHAR THEN

Line 562: IF l_DiscreteJob_rec.attribute7 = FND_API.G_MISS_CHAR THEN

558: IF l_DiscreteJob_rec.attribute6 = FND_API.G_MISS_CHAR THEN
559: l_DiscreteJob_rec.attribute6 := p_old_DiscreteJob_rec.attribute6;
560: END IF;
561:
562: IF l_DiscreteJob_rec.attribute7 = FND_API.G_MISS_CHAR THEN
563: l_DiscreteJob_rec.attribute7 := p_old_DiscreteJob_rec.attribute7;
564: END IF;
565:
566: IF l_DiscreteJob_rec.attribute8 = FND_API.G_MISS_CHAR THEN

Line 566: IF l_DiscreteJob_rec.attribute8 = FND_API.G_MISS_CHAR THEN

562: IF l_DiscreteJob_rec.attribute7 = FND_API.G_MISS_CHAR THEN
563: l_DiscreteJob_rec.attribute7 := p_old_DiscreteJob_rec.attribute7;
564: END IF;
565:
566: IF l_DiscreteJob_rec.attribute8 = FND_API.G_MISS_CHAR THEN
567: l_DiscreteJob_rec.attribute8 := p_old_DiscreteJob_rec.attribute8;
568: END IF;
569:
570: IF l_DiscreteJob_rec.attribute9 = FND_API.G_MISS_CHAR THEN

Line 570: IF l_DiscreteJob_rec.attribute9 = FND_API.G_MISS_CHAR THEN

566: IF l_DiscreteJob_rec.attribute8 = FND_API.G_MISS_CHAR THEN
567: l_DiscreteJob_rec.attribute8 := p_old_DiscreteJob_rec.attribute8;
568: END IF;
569:
570: IF l_DiscreteJob_rec.attribute9 = FND_API.G_MISS_CHAR THEN
571: l_DiscreteJob_rec.attribute9 := p_old_DiscreteJob_rec.attribute9;
572: END IF;
573:
574: IF l_DiscreteJob_rec.attribute_category = FND_API.G_MISS_CHAR THEN

Line 574: IF l_DiscreteJob_rec.attribute_category = FND_API.G_MISS_CHAR THEN

570: IF l_DiscreteJob_rec.attribute9 = FND_API.G_MISS_CHAR THEN
571: l_DiscreteJob_rec.attribute9 := p_old_DiscreteJob_rec.attribute9;
572: END IF;
573:
574: IF l_DiscreteJob_rec.attribute_category = FND_API.G_MISS_CHAR THEN
575: l_DiscreteJob_rec.attribute_category := p_old_DiscreteJob_rec.attribute_category;
576: END IF;
577:
578: IF l_DiscreteJob_rec.bom_reference_id = FND_API.G_MISS_NUM THEN

Line 578: IF l_DiscreteJob_rec.bom_reference_id = FND_API.G_MISS_NUM THEN

574: IF l_DiscreteJob_rec.attribute_category = FND_API.G_MISS_CHAR THEN
575: l_DiscreteJob_rec.attribute_category := p_old_DiscreteJob_rec.attribute_category;
576: END IF;
577:
578: IF l_DiscreteJob_rec.bom_reference_id = FND_API.G_MISS_NUM THEN
579: l_DiscreteJob_rec.bom_reference_id := p_old_DiscreteJob_rec.bom_reference_id;
580: END IF;
581:
582: IF l_DiscreteJob_rec.bom_revision = FND_API.G_MISS_CHAR THEN

Line 582: IF l_DiscreteJob_rec.bom_revision = FND_API.G_MISS_CHAR THEN

578: IF l_DiscreteJob_rec.bom_reference_id = FND_API.G_MISS_NUM THEN
579: l_DiscreteJob_rec.bom_reference_id := p_old_DiscreteJob_rec.bom_reference_id;
580: END IF;
581:
582: IF l_DiscreteJob_rec.bom_revision = FND_API.G_MISS_CHAR THEN
583: l_DiscreteJob_rec.bom_revision := p_old_DiscreteJob_rec.bom_revision;
584: END IF;
585:
586: IF l_DiscreteJob_rec.bom_revision_date = FND_API.G_MISS_DATE THEN

Line 586: IF l_DiscreteJob_rec.bom_revision_date = FND_API.G_MISS_DATE THEN

582: IF l_DiscreteJob_rec.bom_revision = FND_API.G_MISS_CHAR THEN
583: l_DiscreteJob_rec.bom_revision := p_old_DiscreteJob_rec.bom_revision;
584: END IF;
585:
586: IF l_DiscreteJob_rec.bom_revision_date = FND_API.G_MISS_DATE THEN
587: l_DiscreteJob_rec.bom_revision_date := p_old_DiscreteJob_rec.bom_revision_date;
588: END IF;
589:
590: IF l_DiscreteJob_rec.build_sequence = FND_API.G_MISS_NUM THEN

Line 590: IF l_DiscreteJob_rec.build_sequence = FND_API.G_MISS_NUM THEN

586: IF l_DiscreteJob_rec.bom_revision_date = FND_API.G_MISS_DATE THEN
587: l_DiscreteJob_rec.bom_revision_date := p_old_DiscreteJob_rec.bom_revision_date;
588: END IF;
589:
590: IF l_DiscreteJob_rec.build_sequence = FND_API.G_MISS_NUM THEN
591: l_DiscreteJob_rec.build_sequence := p_old_DiscreteJob_rec.build_sequence;
592: END IF;
593:
594: IF l_DiscreteJob_rec.class_code = FND_API.G_MISS_CHAR THEN

Line 594: IF l_DiscreteJob_rec.class_code = FND_API.G_MISS_CHAR THEN

590: IF l_DiscreteJob_rec.build_sequence = FND_API.G_MISS_NUM THEN
591: l_DiscreteJob_rec.build_sequence := p_old_DiscreteJob_rec.build_sequence;
592: END IF;
593:
594: IF l_DiscreteJob_rec.class_code = FND_API.G_MISS_CHAR THEN
595: l_DiscreteJob_rec.class_code := p_old_DiscreteJob_rec.class_code;
596: END IF;
597:
598: IF l_DiscreteJob_rec.common_bom_sequence_id = FND_API.G_MISS_NUM THEN

Line 598: IF l_DiscreteJob_rec.common_bom_sequence_id = FND_API.G_MISS_NUM THEN

594: IF l_DiscreteJob_rec.class_code = FND_API.G_MISS_CHAR THEN
595: l_DiscreteJob_rec.class_code := p_old_DiscreteJob_rec.class_code;
596: END IF;
597:
598: IF l_DiscreteJob_rec.common_bom_sequence_id = FND_API.G_MISS_NUM THEN
599: l_DiscreteJob_rec.common_bom_sequence_id := p_old_DiscreteJob_rec.common_bom_sequence_id;
600: END IF;
601:
602: IF l_DiscreteJob_rec.common_rout_sequence_id = FND_API.G_MISS_NUM THEN

Line 602: IF l_DiscreteJob_rec.common_rout_sequence_id = FND_API.G_MISS_NUM THEN

598: IF l_DiscreteJob_rec.common_bom_sequence_id = FND_API.G_MISS_NUM THEN
599: l_DiscreteJob_rec.common_bom_sequence_id := p_old_DiscreteJob_rec.common_bom_sequence_id;
600: END IF;
601:
602: IF l_DiscreteJob_rec.common_rout_sequence_id = FND_API.G_MISS_NUM THEN
603: l_DiscreteJob_rec.common_rout_sequence_id := p_old_DiscreteJob_rec.common_rout_sequence_id;
604: END IF;
605:
606: IF l_DiscreteJob_rec.completion_locator_id = FND_API.G_MISS_NUM THEN

Line 606: IF l_DiscreteJob_rec.completion_locator_id = FND_API.G_MISS_NUM THEN

602: IF l_DiscreteJob_rec.common_rout_sequence_id = FND_API.G_MISS_NUM THEN
603: l_DiscreteJob_rec.common_rout_sequence_id := p_old_DiscreteJob_rec.common_rout_sequence_id;
604: END IF;
605:
606: IF l_DiscreteJob_rec.completion_locator_id = FND_API.G_MISS_NUM THEN
607: l_DiscreteJob_rec.completion_locator_id := p_old_DiscreteJob_rec.completion_locator_id;
608: END IF;
609:
610: IF l_DiscreteJob_rec.completion_subinventory = FND_API.G_MISS_CHAR THEN

Line 610: IF l_DiscreteJob_rec.completion_subinventory = FND_API.G_MISS_CHAR THEN

606: IF l_DiscreteJob_rec.completion_locator_id = FND_API.G_MISS_NUM THEN
607: l_DiscreteJob_rec.completion_locator_id := p_old_DiscreteJob_rec.completion_locator_id;
608: END IF;
609:
610: IF l_DiscreteJob_rec.completion_subinventory = FND_API.G_MISS_CHAR THEN
611: l_DiscreteJob_rec.completion_subinventory := p_old_DiscreteJob_rec.completion_subinventory;
612: END IF;
613:
614: IF l_DiscreteJob_rec.created_by = FND_API.G_MISS_NUM THEN

Line 614: IF l_DiscreteJob_rec.created_by = FND_API.G_MISS_NUM THEN

610: IF l_DiscreteJob_rec.completion_subinventory = FND_API.G_MISS_CHAR THEN
611: l_DiscreteJob_rec.completion_subinventory := p_old_DiscreteJob_rec.completion_subinventory;
612: END IF;
613:
614: IF l_DiscreteJob_rec.created_by = FND_API.G_MISS_NUM THEN
615: l_DiscreteJob_rec.created_by := p_old_DiscreteJob_rec.created_by;
616: END IF;
617:
618: IF l_DiscreteJob_rec.creation_date = FND_API.G_MISS_DATE THEN

Line 618: IF l_DiscreteJob_rec.creation_date = FND_API.G_MISS_DATE THEN

614: IF l_DiscreteJob_rec.created_by = FND_API.G_MISS_NUM THEN
615: l_DiscreteJob_rec.created_by := p_old_DiscreteJob_rec.created_by;
616: END IF;
617:
618: IF l_DiscreteJob_rec.creation_date = FND_API.G_MISS_DATE THEN
619: l_DiscreteJob_rec.creation_date := p_old_DiscreteJob_rec.creation_date;
620: END IF;
621:
622: IF l_DiscreteJob_rec.date_closed = FND_API.G_MISS_DATE THEN

Line 622: IF l_DiscreteJob_rec.date_closed = FND_API.G_MISS_DATE THEN

618: IF l_DiscreteJob_rec.creation_date = FND_API.G_MISS_DATE THEN
619: l_DiscreteJob_rec.creation_date := p_old_DiscreteJob_rec.creation_date;
620: END IF;
621:
622: IF l_DiscreteJob_rec.date_closed = FND_API.G_MISS_DATE THEN
623: l_DiscreteJob_rec.date_closed := p_old_DiscreteJob_rec.date_closed;
624: END IF;
625:
626: IF l_DiscreteJob_rec.date_completed = FND_API.G_MISS_DATE THEN

Line 626: IF l_DiscreteJob_rec.date_completed = FND_API.G_MISS_DATE THEN

622: IF l_DiscreteJob_rec.date_closed = FND_API.G_MISS_DATE THEN
623: l_DiscreteJob_rec.date_closed := p_old_DiscreteJob_rec.date_closed;
624: END IF;
625:
626: IF l_DiscreteJob_rec.date_completed = FND_API.G_MISS_DATE THEN
627: l_DiscreteJob_rec.date_completed := p_old_DiscreteJob_rec.date_completed;
628: END IF;
629:
630: IF l_DiscreteJob_rec.date_released = FND_API.G_MISS_DATE THEN

Line 630: IF l_DiscreteJob_rec.date_released = FND_API.G_MISS_DATE THEN

626: IF l_DiscreteJob_rec.date_completed = FND_API.G_MISS_DATE THEN
627: l_DiscreteJob_rec.date_completed := p_old_DiscreteJob_rec.date_completed;
628: END IF;
629:
630: IF l_DiscreteJob_rec.date_released = FND_API.G_MISS_DATE THEN
631: l_DiscreteJob_rec.date_released := p_old_DiscreteJob_rec.date_released;
632: END IF;
633:
634: IF l_DiscreteJob_rec.demand_class = FND_API.G_MISS_CHAR THEN

Line 634: IF l_DiscreteJob_rec.demand_class = FND_API.G_MISS_CHAR THEN

630: IF l_DiscreteJob_rec.date_released = FND_API.G_MISS_DATE THEN
631: l_DiscreteJob_rec.date_released := p_old_DiscreteJob_rec.date_released;
632: END IF;
633:
634: IF l_DiscreteJob_rec.demand_class = FND_API.G_MISS_CHAR THEN
635: l_DiscreteJob_rec.demand_class := p_old_DiscreteJob_rec.demand_class;
636: END IF;
637:
638: IF l_DiscreteJob_rec.description = FND_API.G_MISS_CHAR THEN

Line 638: IF l_DiscreteJob_rec.description = FND_API.G_MISS_CHAR THEN

634: IF l_DiscreteJob_rec.demand_class = FND_API.G_MISS_CHAR THEN
635: l_DiscreteJob_rec.demand_class := p_old_DiscreteJob_rec.demand_class;
636: END IF;
637:
638: IF l_DiscreteJob_rec.description = FND_API.G_MISS_CHAR THEN
639: l_DiscreteJob_rec.description := p_old_DiscreteJob_rec.description;
640: END IF;
641:
642: IF l_DiscreteJob_rec.firm_planned_flag = FND_API.G_MISS_NUM THEN

Line 642: IF l_DiscreteJob_rec.firm_planned_flag = FND_API.G_MISS_NUM THEN

638: IF l_DiscreteJob_rec.description = FND_API.G_MISS_CHAR THEN
639: l_DiscreteJob_rec.description := p_old_DiscreteJob_rec.description;
640: END IF;
641:
642: IF l_DiscreteJob_rec.firm_planned_flag = FND_API.G_MISS_NUM THEN
643: l_DiscreteJob_rec.firm_planned_flag := p_old_DiscreteJob_rec.firm_planned_flag;
644: END IF;
645:
646: IF l_DiscreteJob_rec.job_type = FND_API.G_MISS_NUM THEN

Line 646: IF l_DiscreteJob_rec.job_type = FND_API.G_MISS_NUM THEN

642: IF l_DiscreteJob_rec.firm_planned_flag = FND_API.G_MISS_NUM THEN
643: l_DiscreteJob_rec.firm_planned_flag := p_old_DiscreteJob_rec.firm_planned_flag;
644: END IF;
645:
646: IF l_DiscreteJob_rec.job_type = FND_API.G_MISS_NUM THEN
647: l_DiscreteJob_rec.job_type := p_old_DiscreteJob_rec.job_type;
648: END IF;
649:
650: IF l_DiscreteJob_rec.kanban_card_id = FND_API.G_MISS_NUM THEN

Line 650: IF l_DiscreteJob_rec.kanban_card_id = FND_API.G_MISS_NUM THEN

646: IF l_DiscreteJob_rec.job_type = FND_API.G_MISS_NUM THEN
647: l_DiscreteJob_rec.job_type := p_old_DiscreteJob_rec.job_type;
648: END IF;
649:
650: IF l_DiscreteJob_rec.kanban_card_id = FND_API.G_MISS_NUM THEN
651: l_DiscreteJob_rec.kanban_card_id := p_old_DiscreteJob_rec.kanban_card_id;
652: END IF;
653:
654: IF l_DiscreteJob_rec.last_updated_by = FND_API.G_MISS_NUM THEN

Line 654: IF l_DiscreteJob_rec.last_updated_by = FND_API.G_MISS_NUM THEN

650: IF l_DiscreteJob_rec.kanban_card_id = FND_API.G_MISS_NUM THEN
651: l_DiscreteJob_rec.kanban_card_id := p_old_DiscreteJob_rec.kanban_card_id;
652: END IF;
653:
654: IF l_DiscreteJob_rec.last_updated_by = FND_API.G_MISS_NUM THEN
655: l_DiscreteJob_rec.last_updated_by := p_old_DiscreteJob_rec.last_updated_by;
656: END IF;
657:
658: IF l_DiscreteJob_rec.last_update_date = FND_API.G_MISS_DATE THEN

Line 658: IF l_DiscreteJob_rec.last_update_date = FND_API.G_MISS_DATE THEN

654: IF l_DiscreteJob_rec.last_updated_by = FND_API.G_MISS_NUM THEN
655: l_DiscreteJob_rec.last_updated_by := p_old_DiscreteJob_rec.last_updated_by;
656: END IF;
657:
658: IF l_DiscreteJob_rec.last_update_date = FND_API.G_MISS_DATE THEN
659: l_DiscreteJob_rec.last_update_date := p_old_DiscreteJob_rec.last_update_date;
660: END IF;
661:
662: IF l_DiscreteJob_rec.last_update_login = FND_API.G_MISS_NUM THEN

Line 662: IF l_DiscreteJob_rec.last_update_login = FND_API.G_MISS_NUM THEN

658: IF l_DiscreteJob_rec.last_update_date = FND_API.G_MISS_DATE THEN
659: l_DiscreteJob_rec.last_update_date := p_old_DiscreteJob_rec.last_update_date;
660: END IF;
661:
662: IF l_DiscreteJob_rec.last_update_login = FND_API.G_MISS_NUM THEN
663: l_DiscreteJob_rec.last_update_login := p_old_DiscreteJob_rec.last_update_login;
664: END IF;
665:
666: IF l_DiscreteJob_rec.line_id = FND_API.G_MISS_NUM THEN

Line 666: IF l_DiscreteJob_rec.line_id = FND_API.G_MISS_NUM THEN

662: IF l_DiscreteJob_rec.last_update_login = FND_API.G_MISS_NUM THEN
663: l_DiscreteJob_rec.last_update_login := p_old_DiscreteJob_rec.last_update_login;
664: END IF;
665:
666: IF l_DiscreteJob_rec.line_id = FND_API.G_MISS_NUM THEN
667: l_DiscreteJob_rec.line_id := p_old_DiscreteJob_rec.line_id;
668: END IF;
669:
670: IF l_DiscreteJob_rec.lot_number = FND_API.G_MISS_CHAR THEN

Line 670: IF l_DiscreteJob_rec.lot_number = FND_API.G_MISS_CHAR THEN

666: IF l_DiscreteJob_rec.line_id = FND_API.G_MISS_NUM THEN
667: l_DiscreteJob_rec.line_id := p_old_DiscreteJob_rec.line_id;
668: END IF;
669:
670: IF l_DiscreteJob_rec.lot_number = FND_API.G_MISS_CHAR THEN
671: l_DiscreteJob_rec.lot_number := p_old_DiscreteJob_rec.lot_number;
672: END IF;
673:
674: IF l_DiscreteJob_rec.material_account = FND_API.G_MISS_NUM THEN

Line 674: IF l_DiscreteJob_rec.material_account = FND_API.G_MISS_NUM THEN

670: IF l_DiscreteJob_rec.lot_number = FND_API.G_MISS_CHAR THEN
671: l_DiscreteJob_rec.lot_number := p_old_DiscreteJob_rec.lot_number;
672: END IF;
673:
674: IF l_DiscreteJob_rec.material_account = FND_API.G_MISS_NUM THEN
675: l_DiscreteJob_rec.material_account := p_old_DiscreteJob_rec.material_account;
676: END IF;
677:
678: IF l_DiscreteJob_rec.material_overhead_account = FND_API.G_MISS_NUM THEN

Line 678: IF l_DiscreteJob_rec.material_overhead_account = FND_API.G_MISS_NUM THEN

674: IF l_DiscreteJob_rec.material_account = FND_API.G_MISS_NUM THEN
675: l_DiscreteJob_rec.material_account := p_old_DiscreteJob_rec.material_account;
676: END IF;
677:
678: IF l_DiscreteJob_rec.material_overhead_account = FND_API.G_MISS_NUM THEN
679: l_DiscreteJob_rec.material_overhead_account := p_old_DiscreteJob_rec.material_overhead_account;
680: END IF;
681:
682: IF l_DiscreteJob_rec.material_variance_account = FND_API.G_MISS_NUM THEN

Line 682: IF l_DiscreteJob_rec.material_variance_account = FND_API.G_MISS_NUM THEN

678: IF l_DiscreteJob_rec.material_overhead_account = FND_API.G_MISS_NUM THEN
679: l_DiscreteJob_rec.material_overhead_account := p_old_DiscreteJob_rec.material_overhead_account;
680: END IF;
681:
682: IF l_DiscreteJob_rec.material_variance_account = FND_API.G_MISS_NUM THEN
683: l_DiscreteJob_rec.material_variance_account := p_old_DiscreteJob_rec.material_variance_account;
684: END IF;
685:
686: IF l_DiscreteJob_rec.mps_net_quantity = FND_API.G_MISS_NUM THEN

Line 686: IF l_DiscreteJob_rec.mps_net_quantity = FND_API.G_MISS_NUM THEN

682: IF l_DiscreteJob_rec.material_variance_account = FND_API.G_MISS_NUM THEN
683: l_DiscreteJob_rec.material_variance_account := p_old_DiscreteJob_rec.material_variance_account;
684: END IF;
685:
686: IF l_DiscreteJob_rec.mps_net_quantity = FND_API.G_MISS_NUM THEN
687: l_DiscreteJob_rec.mps_net_quantity := p_old_DiscreteJob_rec.mps_net_quantity;
688: END IF;
689:
690: IF l_DiscreteJob_rec.mps_scheduled_cpl_date = FND_API.G_MISS_DATE THEN

Line 690: IF l_DiscreteJob_rec.mps_scheduled_cpl_date = FND_API.G_MISS_DATE THEN

686: IF l_DiscreteJob_rec.mps_net_quantity = FND_API.G_MISS_NUM THEN
687: l_DiscreteJob_rec.mps_net_quantity := p_old_DiscreteJob_rec.mps_net_quantity;
688: END IF;
689:
690: IF l_DiscreteJob_rec.mps_scheduled_cpl_date = FND_API.G_MISS_DATE THEN
691: l_DiscreteJob_rec.mps_scheduled_cpl_date := p_old_DiscreteJob_rec.mps_scheduled_cpl_date;
692: END IF;
693:
694: IF l_DiscreteJob_rec.net_quantity = FND_API.G_MISS_NUM THEN

Line 694: IF l_DiscreteJob_rec.net_quantity = FND_API.G_MISS_NUM THEN

690: IF l_DiscreteJob_rec.mps_scheduled_cpl_date = FND_API.G_MISS_DATE THEN
691: l_DiscreteJob_rec.mps_scheduled_cpl_date := p_old_DiscreteJob_rec.mps_scheduled_cpl_date;
692: END IF;
693:
694: IF l_DiscreteJob_rec.net_quantity = FND_API.G_MISS_NUM THEN
695: l_DiscreteJob_rec.net_quantity := p_old_DiscreteJob_rec.net_quantity;
696: END IF;
697:
698: IF l_DiscreteJob_rec.organization_id = FND_API.G_MISS_NUM THEN

Line 698: IF l_DiscreteJob_rec.organization_id = FND_API.G_MISS_NUM THEN

694: IF l_DiscreteJob_rec.net_quantity = FND_API.G_MISS_NUM THEN
695: l_DiscreteJob_rec.net_quantity := p_old_DiscreteJob_rec.net_quantity;
696: END IF;
697:
698: IF l_DiscreteJob_rec.organization_id = FND_API.G_MISS_NUM THEN
699: l_DiscreteJob_rec.organization_id := p_old_DiscreteJob_rec.organization_id;
700: END IF;
701:
702: IF l_DiscreteJob_rec.osp_account = FND_API.G_MISS_NUM THEN

Line 702: IF l_DiscreteJob_rec.osp_account = FND_API.G_MISS_NUM THEN

698: IF l_DiscreteJob_rec.organization_id = FND_API.G_MISS_NUM THEN
699: l_DiscreteJob_rec.organization_id := p_old_DiscreteJob_rec.organization_id;
700: END IF;
701:
702: IF l_DiscreteJob_rec.osp_account = FND_API.G_MISS_NUM THEN
703: l_DiscreteJob_rec.osp_account := p_old_DiscreteJob_rec.osp_account;
704: END IF;
705:
706: IF l_DiscreteJob_rec.osp_variance_account = FND_API.G_MISS_NUM THEN

Line 706: IF l_DiscreteJob_rec.osp_variance_account = FND_API.G_MISS_NUM THEN

702: IF l_DiscreteJob_rec.osp_account = FND_API.G_MISS_NUM THEN
703: l_DiscreteJob_rec.osp_account := p_old_DiscreteJob_rec.osp_account;
704: END IF;
705:
706: IF l_DiscreteJob_rec.osp_variance_account = FND_API.G_MISS_NUM THEN
707: l_DiscreteJob_rec.osp_variance_account := p_old_DiscreteJob_rec.osp_variance_account;
708: END IF;
709:
710: IF l_DiscreteJob_rec.overcpl_tolerance_type = FND_API.G_MISS_NUM THEN

Line 710: IF l_DiscreteJob_rec.overcpl_tolerance_type = FND_API.G_MISS_NUM THEN

706: IF l_DiscreteJob_rec.osp_variance_account = FND_API.G_MISS_NUM THEN
707: l_DiscreteJob_rec.osp_variance_account := p_old_DiscreteJob_rec.osp_variance_account;
708: END IF;
709:
710: IF l_DiscreteJob_rec.overcpl_tolerance_type = FND_API.G_MISS_NUM THEN
711: l_DiscreteJob_rec.overcpl_tolerance_type := p_old_DiscreteJob_rec.overcpl_tolerance_type;
712: END IF;
713:
714: IF l_DiscreteJob_rec.overcpl_tolerance_value = FND_API.G_MISS_NUM THEN

Line 714: IF l_DiscreteJob_rec.overcpl_tolerance_value = FND_API.G_MISS_NUM THEN

710: IF l_DiscreteJob_rec.overcpl_tolerance_type = FND_API.G_MISS_NUM THEN
711: l_DiscreteJob_rec.overcpl_tolerance_type := p_old_DiscreteJob_rec.overcpl_tolerance_type;
712: END IF;
713:
714: IF l_DiscreteJob_rec.overcpl_tolerance_value = FND_API.G_MISS_NUM THEN
715: l_DiscreteJob_rec.overcpl_tolerance_value := p_old_DiscreteJob_rec.overcpl_tolerance_value;
716: END IF;
717:
718: IF l_DiscreteJob_rec.overhead_account = FND_API.G_MISS_NUM THEN

Line 718: IF l_DiscreteJob_rec.overhead_account = FND_API.G_MISS_NUM THEN

714: IF l_DiscreteJob_rec.overcpl_tolerance_value = FND_API.G_MISS_NUM THEN
715: l_DiscreteJob_rec.overcpl_tolerance_value := p_old_DiscreteJob_rec.overcpl_tolerance_value;
716: END IF;
717:
718: IF l_DiscreteJob_rec.overhead_account = FND_API.G_MISS_NUM THEN
719: l_DiscreteJob_rec.overhead_account := p_old_DiscreteJob_rec.overhead_account;
720: END IF;
721:
722: IF l_DiscreteJob_rec.overhead_variance_account = FND_API.G_MISS_NUM THEN

Line 722: IF l_DiscreteJob_rec.overhead_variance_account = FND_API.G_MISS_NUM THEN

718: IF l_DiscreteJob_rec.overhead_account = FND_API.G_MISS_NUM THEN
719: l_DiscreteJob_rec.overhead_account := p_old_DiscreteJob_rec.overhead_account;
720: END IF;
721:
722: IF l_DiscreteJob_rec.overhead_variance_account = FND_API.G_MISS_NUM THEN
723: l_DiscreteJob_rec.overhead_variance_account := p_old_DiscreteJob_rec.overhead_variance_account;
724: END IF;
725:
726: IF l_DiscreteJob_rec.primary_item_id = FND_API.G_MISS_NUM THEN

Line 726: IF l_DiscreteJob_rec.primary_item_id = FND_API.G_MISS_NUM THEN

722: IF l_DiscreteJob_rec.overhead_variance_account = FND_API.G_MISS_NUM THEN
723: l_DiscreteJob_rec.overhead_variance_account := p_old_DiscreteJob_rec.overhead_variance_account;
724: END IF;
725:
726: IF l_DiscreteJob_rec.primary_item_id = FND_API.G_MISS_NUM THEN
727: l_DiscreteJob_rec.primary_item_id := p_old_DiscreteJob_rec.primary_item_id;
728: END IF;
729:
730: IF l_DiscreteJob_rec.program_application_id = FND_API.G_MISS_NUM THEN

Line 730: IF l_DiscreteJob_rec.program_application_id = FND_API.G_MISS_NUM THEN

726: IF l_DiscreteJob_rec.primary_item_id = FND_API.G_MISS_NUM THEN
727: l_DiscreteJob_rec.primary_item_id := p_old_DiscreteJob_rec.primary_item_id;
728: END IF;
729:
730: IF l_DiscreteJob_rec.program_application_id = FND_API.G_MISS_NUM THEN
731: l_DiscreteJob_rec.program_application_id := p_old_DiscreteJob_rec.program_application_id;
732: END IF;
733:
734: IF l_DiscreteJob_rec.program_id = FND_API.G_MISS_NUM THEN

Line 734: IF l_DiscreteJob_rec.program_id = FND_API.G_MISS_NUM THEN

730: IF l_DiscreteJob_rec.program_application_id = FND_API.G_MISS_NUM THEN
731: l_DiscreteJob_rec.program_application_id := p_old_DiscreteJob_rec.program_application_id;
732: END IF;
733:
734: IF l_DiscreteJob_rec.program_id = FND_API.G_MISS_NUM THEN
735: l_DiscreteJob_rec.program_id := p_old_DiscreteJob_rec.program_id;
736: END IF;
737:
738: IF l_DiscreteJob_rec.program_update_date = FND_API.G_MISS_DATE THEN

Line 738: IF l_DiscreteJob_rec.program_update_date = FND_API.G_MISS_DATE THEN

734: IF l_DiscreteJob_rec.program_id = FND_API.G_MISS_NUM THEN
735: l_DiscreteJob_rec.program_id := p_old_DiscreteJob_rec.program_id;
736: END IF;
737:
738: IF l_DiscreteJob_rec.program_update_date = FND_API.G_MISS_DATE THEN
739: l_DiscreteJob_rec.program_update_date := p_old_DiscreteJob_rec.program_update_date;
740: END IF;
741:
742: IF l_DiscreteJob_rec.project_costed = FND_API.G_MISS_NUM THEN

Line 742: IF l_DiscreteJob_rec.project_costed = FND_API.G_MISS_NUM THEN

738: IF l_DiscreteJob_rec.program_update_date = FND_API.G_MISS_DATE THEN
739: l_DiscreteJob_rec.program_update_date := p_old_DiscreteJob_rec.program_update_date;
740: END IF;
741:
742: IF l_DiscreteJob_rec.project_costed = FND_API.G_MISS_NUM THEN
743: l_DiscreteJob_rec.project_costed := p_old_DiscreteJob_rec.project_costed;
744: END IF;
745:
746: IF l_DiscreteJob_rec.project_id = FND_API.G_MISS_NUM THEN

Line 746: IF l_DiscreteJob_rec.project_id = FND_API.G_MISS_NUM THEN

742: IF l_DiscreteJob_rec.project_costed = FND_API.G_MISS_NUM THEN
743: l_DiscreteJob_rec.project_costed := p_old_DiscreteJob_rec.project_costed;
744: END IF;
745:
746: IF l_DiscreteJob_rec.project_id = FND_API.G_MISS_NUM THEN
747: l_DiscreteJob_rec.project_id := p_old_DiscreteJob_rec.project_id;
748: END IF;
749:
750: IF l_DiscreteJob_rec.quantity_completed = FND_API.G_MISS_NUM THEN

Line 750: IF l_DiscreteJob_rec.quantity_completed = FND_API.G_MISS_NUM THEN

746: IF l_DiscreteJob_rec.project_id = FND_API.G_MISS_NUM THEN
747: l_DiscreteJob_rec.project_id := p_old_DiscreteJob_rec.project_id;
748: END IF;
749:
750: IF l_DiscreteJob_rec.quantity_completed = FND_API.G_MISS_NUM THEN
751: l_DiscreteJob_rec.quantity_completed := p_old_DiscreteJob_rec.quantity_completed;
752: END IF;
753:
754: IF l_DiscreteJob_rec.quantity_scrapped = FND_API.G_MISS_NUM THEN

Line 754: IF l_DiscreteJob_rec.quantity_scrapped = FND_API.G_MISS_NUM THEN

750: IF l_DiscreteJob_rec.quantity_completed = FND_API.G_MISS_NUM THEN
751: l_DiscreteJob_rec.quantity_completed := p_old_DiscreteJob_rec.quantity_completed;
752: END IF;
753:
754: IF l_DiscreteJob_rec.quantity_scrapped = FND_API.G_MISS_NUM THEN
755: l_DiscreteJob_rec.quantity_scrapped := p_old_DiscreteJob_rec.quantity_scrapped;
756: END IF;
757:
758: IF l_DiscreteJob_rec.request_id = FND_API.G_MISS_NUM THEN

Line 758: IF l_DiscreteJob_rec.request_id = FND_API.G_MISS_NUM THEN

754: IF l_DiscreteJob_rec.quantity_scrapped = FND_API.G_MISS_NUM THEN
755: l_DiscreteJob_rec.quantity_scrapped := p_old_DiscreteJob_rec.quantity_scrapped;
756: END IF;
757:
758: IF l_DiscreteJob_rec.request_id = FND_API.G_MISS_NUM THEN
759: l_DiscreteJob_rec.request_id := p_old_DiscreteJob_rec.request_id;
760: END IF;
761:
762: IF l_DiscreteJob_rec.resource_account = FND_API.G_MISS_NUM THEN

Line 762: IF l_DiscreteJob_rec.resource_account = FND_API.G_MISS_NUM THEN

758: IF l_DiscreteJob_rec.request_id = FND_API.G_MISS_NUM THEN
759: l_DiscreteJob_rec.request_id := p_old_DiscreteJob_rec.request_id;
760: END IF;
761:
762: IF l_DiscreteJob_rec.resource_account = FND_API.G_MISS_NUM THEN
763: l_DiscreteJob_rec.resource_account := p_old_DiscreteJob_rec.resource_account;
764: END IF;
765:
766: IF l_DiscreteJob_rec.resource_variance_account = FND_API.G_MISS_NUM THEN

Line 766: IF l_DiscreteJob_rec.resource_variance_account = FND_API.G_MISS_NUM THEN

762: IF l_DiscreteJob_rec.resource_account = FND_API.G_MISS_NUM THEN
763: l_DiscreteJob_rec.resource_account := p_old_DiscreteJob_rec.resource_account;
764: END IF;
765:
766: IF l_DiscreteJob_rec.resource_variance_account = FND_API.G_MISS_NUM THEN
767: l_DiscreteJob_rec.resource_variance_account := p_old_DiscreteJob_rec.resource_variance_account;
768: END IF;
769:
770: IF l_DiscreteJob_rec.routing_reference_id = FND_API.G_MISS_NUM THEN

Line 770: IF l_DiscreteJob_rec.routing_reference_id = FND_API.G_MISS_NUM THEN

766: IF l_DiscreteJob_rec.resource_variance_account = FND_API.G_MISS_NUM THEN
767: l_DiscreteJob_rec.resource_variance_account := p_old_DiscreteJob_rec.resource_variance_account;
768: END IF;
769:
770: IF l_DiscreteJob_rec.routing_reference_id = FND_API.G_MISS_NUM THEN
771: l_DiscreteJob_rec.routing_reference_id := p_old_DiscreteJob_rec.routing_reference_id;
772: END IF;
773:
774: IF l_DiscreteJob_rec.routing_revision = FND_API.G_MISS_CHAR THEN

Line 774: IF l_DiscreteJob_rec.routing_revision = FND_API.G_MISS_CHAR THEN

770: IF l_DiscreteJob_rec.routing_reference_id = FND_API.G_MISS_NUM THEN
771: l_DiscreteJob_rec.routing_reference_id := p_old_DiscreteJob_rec.routing_reference_id;
772: END IF;
773:
774: IF l_DiscreteJob_rec.routing_revision = FND_API.G_MISS_CHAR THEN
775: l_DiscreteJob_rec.routing_revision := p_old_DiscreteJob_rec.routing_revision;
776: END IF;
777:
778: IF l_DiscreteJob_rec.routing_revision_date = FND_API.G_MISS_DATE THEN

Line 778: IF l_DiscreteJob_rec.routing_revision_date = FND_API.G_MISS_DATE THEN

774: IF l_DiscreteJob_rec.routing_revision = FND_API.G_MISS_CHAR THEN
775: l_DiscreteJob_rec.routing_revision := p_old_DiscreteJob_rec.routing_revision;
776: END IF;
777:
778: IF l_DiscreteJob_rec.routing_revision_date = FND_API.G_MISS_DATE THEN
779: l_DiscreteJob_rec.routing_revision_date := p_old_DiscreteJob_rec.routing_revision_date;
780: END IF;
781:
782: IF l_DiscreteJob_rec.scheduled_completion_date = FND_API.G_MISS_DATE THEN

Line 782: IF l_DiscreteJob_rec.scheduled_completion_date = FND_API.G_MISS_DATE THEN

778: IF l_DiscreteJob_rec.routing_revision_date = FND_API.G_MISS_DATE THEN
779: l_DiscreteJob_rec.routing_revision_date := p_old_DiscreteJob_rec.routing_revision_date;
780: END IF;
781:
782: IF l_DiscreteJob_rec.scheduled_completion_date = FND_API.G_MISS_DATE THEN
783: l_DiscreteJob_rec.scheduled_completion_date := p_old_DiscreteJob_rec.scheduled_completion_date;
784: END IF;
785:
786: IF l_DiscreteJob_rec.scheduled_start_date = FND_API.G_MISS_DATE THEN

Line 786: IF l_DiscreteJob_rec.scheduled_start_date = FND_API.G_MISS_DATE THEN

782: IF l_DiscreteJob_rec.scheduled_completion_date = FND_API.G_MISS_DATE THEN
783: l_DiscreteJob_rec.scheduled_completion_date := p_old_DiscreteJob_rec.scheduled_completion_date;
784: END IF;
785:
786: IF l_DiscreteJob_rec.scheduled_start_date = FND_API.G_MISS_DATE THEN
787: l_DiscreteJob_rec.scheduled_start_date := p_old_DiscreteJob_rec.scheduled_start_date;
788: END IF;
789:
790: IF l_DiscreteJob_rec.schedule_group_id = FND_API.G_MISS_NUM THEN

Line 790: IF l_DiscreteJob_rec.schedule_group_id = FND_API.G_MISS_NUM THEN

786: IF l_DiscreteJob_rec.scheduled_start_date = FND_API.G_MISS_DATE THEN
787: l_DiscreteJob_rec.scheduled_start_date := p_old_DiscreteJob_rec.scheduled_start_date;
788: END IF;
789:
790: IF l_DiscreteJob_rec.schedule_group_id = FND_API.G_MISS_NUM THEN
791: l_DiscreteJob_rec.schedule_group_id := p_old_DiscreteJob_rec.schedule_group_id;
792: END IF;
793:
794: IF l_DiscreteJob_rec.source_code = FND_API.G_MISS_CHAR THEN

Line 794: IF l_DiscreteJob_rec.source_code = FND_API.G_MISS_CHAR THEN

790: IF l_DiscreteJob_rec.schedule_group_id = FND_API.G_MISS_NUM THEN
791: l_DiscreteJob_rec.schedule_group_id := p_old_DiscreteJob_rec.schedule_group_id;
792: END IF;
793:
794: IF l_DiscreteJob_rec.source_code = FND_API.G_MISS_CHAR THEN
795: l_DiscreteJob_rec.source_code := p_old_DiscreteJob_rec.source_code;
796: END IF;
797:
798: IF l_DiscreteJob_rec.source_line_id = FND_API.G_MISS_NUM THEN

Line 798: IF l_DiscreteJob_rec.source_line_id = FND_API.G_MISS_NUM THEN

794: IF l_DiscreteJob_rec.source_code = FND_API.G_MISS_CHAR THEN
795: l_DiscreteJob_rec.source_code := p_old_DiscreteJob_rec.source_code;
796: END IF;
797:
798: IF l_DiscreteJob_rec.source_line_id = FND_API.G_MISS_NUM THEN
799: l_DiscreteJob_rec.source_line_id := p_old_DiscreteJob_rec.source_line_id;
800: END IF;
801:
802: IF l_DiscreteJob_rec.start_quantity = FND_API.G_MISS_NUM THEN

Line 802: IF l_DiscreteJob_rec.start_quantity = FND_API.G_MISS_NUM THEN

798: IF l_DiscreteJob_rec.source_line_id = FND_API.G_MISS_NUM THEN
799: l_DiscreteJob_rec.source_line_id := p_old_DiscreteJob_rec.source_line_id;
800: END IF;
801:
802: IF l_DiscreteJob_rec.start_quantity = FND_API.G_MISS_NUM THEN
803: l_DiscreteJob_rec.start_quantity := p_old_DiscreteJob_rec.start_quantity;
804: END IF;
805:
806: IF l_DiscreteJob_rec.status_type = FND_API.G_MISS_NUM THEN

Line 806: IF l_DiscreteJob_rec.status_type = FND_API.G_MISS_NUM THEN

802: IF l_DiscreteJob_rec.start_quantity = FND_API.G_MISS_NUM THEN
803: l_DiscreteJob_rec.start_quantity := p_old_DiscreteJob_rec.start_quantity;
804: END IF;
805:
806: IF l_DiscreteJob_rec.status_type = FND_API.G_MISS_NUM THEN
807: l_DiscreteJob_rec.status_type := p_old_DiscreteJob_rec.status_type;
808: END IF;
809:
810: IF l_DiscreteJob_rec.std_cost_adj_account = FND_API.G_MISS_NUM THEN

Line 810: IF l_DiscreteJob_rec.std_cost_adj_account = FND_API.G_MISS_NUM THEN

806: IF l_DiscreteJob_rec.status_type = FND_API.G_MISS_NUM THEN
807: l_DiscreteJob_rec.status_type := p_old_DiscreteJob_rec.status_type;
808: END IF;
809:
810: IF l_DiscreteJob_rec.std_cost_adj_account = FND_API.G_MISS_NUM THEN
811: l_DiscreteJob_rec.std_cost_adj_account := p_old_DiscreteJob_rec.std_cost_adj_account;
812: END IF;
813:
814: IF l_DiscreteJob_rec.task_id = FND_API.G_MISS_NUM THEN

Line 814: IF l_DiscreteJob_rec.task_id = FND_API.G_MISS_NUM THEN

810: IF l_DiscreteJob_rec.std_cost_adj_account = FND_API.G_MISS_NUM THEN
811: l_DiscreteJob_rec.std_cost_adj_account := p_old_DiscreteJob_rec.std_cost_adj_account;
812: END IF;
813:
814: IF l_DiscreteJob_rec.task_id = FND_API.G_MISS_NUM THEN
815: l_DiscreteJob_rec.task_id := p_old_DiscreteJob_rec.task_id;
816: END IF;
817:
818: IF l_DiscreteJob_rec.wip_entity_id = FND_API.G_MISS_NUM THEN

Line 818: IF l_DiscreteJob_rec.wip_entity_id = FND_API.G_MISS_NUM THEN

814: IF l_DiscreteJob_rec.task_id = FND_API.G_MISS_NUM THEN
815: l_DiscreteJob_rec.task_id := p_old_DiscreteJob_rec.task_id;
816: END IF;
817:
818: IF l_DiscreteJob_rec.wip_entity_id = FND_API.G_MISS_NUM THEN
819: l_DiscreteJob_rec.wip_entity_id := p_old_DiscreteJob_rec.wip_entity_id;
820: END IF;
821:
822: IF l_DiscreteJob_rec.wip_supply_type = FND_API.G_MISS_NUM THEN

Line 822: IF l_DiscreteJob_rec.wip_supply_type = FND_API.G_MISS_NUM THEN

818: IF l_DiscreteJob_rec.wip_entity_id = FND_API.G_MISS_NUM THEN
819: l_DiscreteJob_rec.wip_entity_id := p_old_DiscreteJob_rec.wip_entity_id;
820: END IF;
821:
822: IF l_DiscreteJob_rec.wip_supply_type = FND_API.G_MISS_NUM THEN
823: l_DiscreteJob_rec.wip_supply_type := p_old_DiscreteJob_rec.wip_supply_type;
824: END IF;
825:
826: END IF;

Line 841: IF l_DiscreteJob_rec.alternate_bom_designator = FND_API.G_MISS_CHAR THEN

837: IS
838: l_DiscreteJob_rec WIP_Work_Order_PUB.Discretejob_Rec_Type := p_DiscreteJob_rec;
839: BEGIN
840:
841: IF l_DiscreteJob_rec.alternate_bom_designator = FND_API.G_MISS_CHAR THEN
842: l_DiscreteJob_rec.alternate_bom_designator := NULL;
843: END IF;
844:
845: IF l_DiscreteJob_rec.alternate_rout_designator = FND_API.G_MISS_CHAR THEN

Line 845: IF l_DiscreteJob_rec.alternate_rout_designator = FND_API.G_MISS_CHAR THEN

841: IF l_DiscreteJob_rec.alternate_bom_designator = FND_API.G_MISS_CHAR THEN
842: l_DiscreteJob_rec.alternate_bom_designator := NULL;
843: END IF;
844:
845: IF l_DiscreteJob_rec.alternate_rout_designator = FND_API.G_MISS_CHAR THEN
846: l_DiscreteJob_rec.alternate_rout_designator := NULL;
847: END IF;
848:
849: IF l_DiscreteJob_rec.attribute1 = FND_API.G_MISS_CHAR THEN

Line 849: IF l_DiscreteJob_rec.attribute1 = FND_API.G_MISS_CHAR THEN

845: IF l_DiscreteJob_rec.alternate_rout_designator = FND_API.G_MISS_CHAR THEN
846: l_DiscreteJob_rec.alternate_rout_designator := NULL;
847: END IF;
848:
849: IF l_DiscreteJob_rec.attribute1 = FND_API.G_MISS_CHAR THEN
850: l_DiscreteJob_rec.attribute1 := NULL;
851: END IF;
852:
853: IF l_DiscreteJob_rec.attribute10 = FND_API.G_MISS_CHAR THEN

Line 853: IF l_DiscreteJob_rec.attribute10 = FND_API.G_MISS_CHAR THEN

849: IF l_DiscreteJob_rec.attribute1 = FND_API.G_MISS_CHAR THEN
850: l_DiscreteJob_rec.attribute1 := NULL;
851: END IF;
852:
853: IF l_DiscreteJob_rec.attribute10 = FND_API.G_MISS_CHAR THEN
854: l_DiscreteJob_rec.attribute10 := NULL;
855: END IF;
856:
857: IF l_DiscreteJob_rec.attribute11 = FND_API.G_MISS_CHAR THEN

Line 857: IF l_DiscreteJob_rec.attribute11 = FND_API.G_MISS_CHAR THEN

853: IF l_DiscreteJob_rec.attribute10 = FND_API.G_MISS_CHAR THEN
854: l_DiscreteJob_rec.attribute10 := NULL;
855: END IF;
856:
857: IF l_DiscreteJob_rec.attribute11 = FND_API.G_MISS_CHAR THEN
858: l_DiscreteJob_rec.attribute11 := NULL;
859: END IF;
860:
861: IF l_DiscreteJob_rec.attribute12 = FND_API.G_MISS_CHAR THEN

Line 861: IF l_DiscreteJob_rec.attribute12 = FND_API.G_MISS_CHAR THEN

857: IF l_DiscreteJob_rec.attribute11 = FND_API.G_MISS_CHAR THEN
858: l_DiscreteJob_rec.attribute11 := NULL;
859: END IF;
860:
861: IF l_DiscreteJob_rec.attribute12 = FND_API.G_MISS_CHAR THEN
862: l_DiscreteJob_rec.attribute12 := NULL;
863: END IF;
864:
865: IF l_DiscreteJob_rec.attribute13 = FND_API.G_MISS_CHAR THEN

Line 865: IF l_DiscreteJob_rec.attribute13 = FND_API.G_MISS_CHAR THEN

861: IF l_DiscreteJob_rec.attribute12 = FND_API.G_MISS_CHAR THEN
862: l_DiscreteJob_rec.attribute12 := NULL;
863: END IF;
864:
865: IF l_DiscreteJob_rec.attribute13 = FND_API.G_MISS_CHAR THEN
866: l_DiscreteJob_rec.attribute13 := NULL;
867: END IF;
868:
869: IF l_DiscreteJob_rec.attribute14 = FND_API.G_MISS_CHAR THEN

Line 869: IF l_DiscreteJob_rec.attribute14 = FND_API.G_MISS_CHAR THEN

865: IF l_DiscreteJob_rec.attribute13 = FND_API.G_MISS_CHAR THEN
866: l_DiscreteJob_rec.attribute13 := NULL;
867: END IF;
868:
869: IF l_DiscreteJob_rec.attribute14 = FND_API.G_MISS_CHAR THEN
870: l_DiscreteJob_rec.attribute14 := NULL;
871: END IF;
872:
873: IF l_DiscreteJob_rec.attribute15 = FND_API.G_MISS_CHAR THEN

Line 873: IF l_DiscreteJob_rec.attribute15 = FND_API.G_MISS_CHAR THEN

869: IF l_DiscreteJob_rec.attribute14 = FND_API.G_MISS_CHAR THEN
870: l_DiscreteJob_rec.attribute14 := NULL;
871: END IF;
872:
873: IF l_DiscreteJob_rec.attribute15 = FND_API.G_MISS_CHAR THEN
874: l_DiscreteJob_rec.attribute15 := NULL;
875: END IF;
876:
877: IF l_DiscreteJob_rec.attribute2 = FND_API.G_MISS_CHAR THEN

Line 877: IF l_DiscreteJob_rec.attribute2 = FND_API.G_MISS_CHAR THEN

873: IF l_DiscreteJob_rec.attribute15 = FND_API.G_MISS_CHAR THEN
874: l_DiscreteJob_rec.attribute15 := NULL;
875: END IF;
876:
877: IF l_DiscreteJob_rec.attribute2 = FND_API.G_MISS_CHAR THEN
878: l_DiscreteJob_rec.attribute2 := NULL;
879: END IF;
880:
881: IF l_DiscreteJob_rec.attribute3 = FND_API.G_MISS_CHAR THEN

Line 881: IF l_DiscreteJob_rec.attribute3 = FND_API.G_MISS_CHAR THEN

877: IF l_DiscreteJob_rec.attribute2 = FND_API.G_MISS_CHAR THEN
878: l_DiscreteJob_rec.attribute2 := NULL;
879: END IF;
880:
881: IF l_DiscreteJob_rec.attribute3 = FND_API.G_MISS_CHAR THEN
882: l_DiscreteJob_rec.attribute3 := NULL;
883: END IF;
884:
885: IF l_DiscreteJob_rec.attribute4 = FND_API.G_MISS_CHAR THEN

Line 885: IF l_DiscreteJob_rec.attribute4 = FND_API.G_MISS_CHAR THEN

881: IF l_DiscreteJob_rec.attribute3 = FND_API.G_MISS_CHAR THEN
882: l_DiscreteJob_rec.attribute3 := NULL;
883: END IF;
884:
885: IF l_DiscreteJob_rec.attribute4 = FND_API.G_MISS_CHAR THEN
886: l_DiscreteJob_rec.attribute4 := NULL;
887: END IF;
888:
889: IF l_DiscreteJob_rec.attribute5 = FND_API.G_MISS_CHAR THEN

Line 889: IF l_DiscreteJob_rec.attribute5 = FND_API.G_MISS_CHAR THEN

885: IF l_DiscreteJob_rec.attribute4 = FND_API.G_MISS_CHAR THEN
886: l_DiscreteJob_rec.attribute4 := NULL;
887: END IF;
888:
889: IF l_DiscreteJob_rec.attribute5 = FND_API.G_MISS_CHAR THEN
890: l_DiscreteJob_rec.attribute5 := NULL;
891: END IF;
892:
893: IF l_DiscreteJob_rec.attribute6 = FND_API.G_MISS_CHAR THEN

Line 893: IF l_DiscreteJob_rec.attribute6 = FND_API.G_MISS_CHAR THEN

889: IF l_DiscreteJob_rec.attribute5 = FND_API.G_MISS_CHAR THEN
890: l_DiscreteJob_rec.attribute5 := NULL;
891: END IF;
892:
893: IF l_DiscreteJob_rec.attribute6 = FND_API.G_MISS_CHAR THEN
894: l_DiscreteJob_rec.attribute6 := NULL;
895: END IF;
896:
897: IF l_DiscreteJob_rec.attribute7 = FND_API.G_MISS_CHAR THEN

Line 897: IF l_DiscreteJob_rec.attribute7 = FND_API.G_MISS_CHAR THEN

893: IF l_DiscreteJob_rec.attribute6 = FND_API.G_MISS_CHAR THEN
894: l_DiscreteJob_rec.attribute6 := NULL;
895: END IF;
896:
897: IF l_DiscreteJob_rec.attribute7 = FND_API.G_MISS_CHAR THEN
898: l_DiscreteJob_rec.attribute7 := NULL;
899: END IF;
900:
901: IF l_DiscreteJob_rec.attribute8 = FND_API.G_MISS_CHAR THEN

Line 901: IF l_DiscreteJob_rec.attribute8 = FND_API.G_MISS_CHAR THEN

897: IF l_DiscreteJob_rec.attribute7 = FND_API.G_MISS_CHAR THEN
898: l_DiscreteJob_rec.attribute7 := NULL;
899: END IF;
900:
901: IF l_DiscreteJob_rec.attribute8 = FND_API.G_MISS_CHAR THEN
902: l_DiscreteJob_rec.attribute8 := NULL;
903: END IF;
904:
905: IF l_DiscreteJob_rec.attribute9 = FND_API.G_MISS_CHAR THEN

Line 905: IF l_DiscreteJob_rec.attribute9 = FND_API.G_MISS_CHAR THEN

901: IF l_DiscreteJob_rec.attribute8 = FND_API.G_MISS_CHAR THEN
902: l_DiscreteJob_rec.attribute8 := NULL;
903: END IF;
904:
905: IF l_DiscreteJob_rec.attribute9 = FND_API.G_MISS_CHAR THEN
906: l_DiscreteJob_rec.attribute9 := NULL;
907: END IF;
908:
909: IF l_DiscreteJob_rec.attribute_category = FND_API.G_MISS_CHAR THEN

Line 909: IF l_DiscreteJob_rec.attribute_category = FND_API.G_MISS_CHAR THEN

905: IF l_DiscreteJob_rec.attribute9 = FND_API.G_MISS_CHAR THEN
906: l_DiscreteJob_rec.attribute9 := NULL;
907: END IF;
908:
909: IF l_DiscreteJob_rec.attribute_category = FND_API.G_MISS_CHAR THEN
910: l_DiscreteJob_rec.attribute_category := NULL;
911: END IF;
912:
913: IF l_DiscreteJob_rec.bom_reference_id = FND_API.G_MISS_NUM THEN

Line 913: IF l_DiscreteJob_rec.bom_reference_id = FND_API.G_MISS_NUM THEN

909: IF l_DiscreteJob_rec.attribute_category = FND_API.G_MISS_CHAR THEN
910: l_DiscreteJob_rec.attribute_category := NULL;
911: END IF;
912:
913: IF l_DiscreteJob_rec.bom_reference_id = FND_API.G_MISS_NUM THEN
914: l_DiscreteJob_rec.bom_reference_id := NULL;
915: END IF;
916:
917: IF l_DiscreteJob_rec.bom_revision = FND_API.G_MISS_CHAR THEN

Line 917: IF l_DiscreteJob_rec.bom_revision = FND_API.G_MISS_CHAR THEN

913: IF l_DiscreteJob_rec.bom_reference_id = FND_API.G_MISS_NUM THEN
914: l_DiscreteJob_rec.bom_reference_id := NULL;
915: END IF;
916:
917: IF l_DiscreteJob_rec.bom_revision = FND_API.G_MISS_CHAR THEN
918: l_DiscreteJob_rec.bom_revision := NULL;
919: END IF;
920:
921: IF l_DiscreteJob_rec.bom_revision_date = FND_API.G_MISS_DATE THEN

Line 921: IF l_DiscreteJob_rec.bom_revision_date = FND_API.G_MISS_DATE THEN

917: IF l_DiscreteJob_rec.bom_revision = FND_API.G_MISS_CHAR THEN
918: l_DiscreteJob_rec.bom_revision := NULL;
919: END IF;
920:
921: IF l_DiscreteJob_rec.bom_revision_date = FND_API.G_MISS_DATE THEN
922: l_DiscreteJob_rec.bom_revision_date := NULL;
923: END IF;
924:
925: IF l_DiscreteJob_rec.build_sequence = FND_API.G_MISS_NUM THEN

Line 925: IF l_DiscreteJob_rec.build_sequence = FND_API.G_MISS_NUM THEN

921: IF l_DiscreteJob_rec.bom_revision_date = FND_API.G_MISS_DATE THEN
922: l_DiscreteJob_rec.bom_revision_date := NULL;
923: END IF;
924:
925: IF l_DiscreteJob_rec.build_sequence = FND_API.G_MISS_NUM THEN
926: l_DiscreteJob_rec.build_sequence := NULL;
927: END IF;
928:
929: IF l_DiscreteJob_rec.class_code = FND_API.G_MISS_CHAR THEN

Line 929: IF l_DiscreteJob_rec.class_code = FND_API.G_MISS_CHAR THEN

925: IF l_DiscreteJob_rec.build_sequence = FND_API.G_MISS_NUM THEN
926: l_DiscreteJob_rec.build_sequence := NULL;
927: END IF;
928:
929: IF l_DiscreteJob_rec.class_code = FND_API.G_MISS_CHAR THEN
930: l_DiscreteJob_rec.class_code := NULL;
931: END IF;
932:
933: IF l_DiscreteJob_rec.common_bom_sequence_id = FND_API.G_MISS_NUM THEN

Line 933: IF l_DiscreteJob_rec.common_bom_sequence_id = FND_API.G_MISS_NUM THEN

929: IF l_DiscreteJob_rec.class_code = FND_API.G_MISS_CHAR THEN
930: l_DiscreteJob_rec.class_code := NULL;
931: END IF;
932:
933: IF l_DiscreteJob_rec.common_bom_sequence_id = FND_API.G_MISS_NUM THEN
934: l_DiscreteJob_rec.common_bom_sequence_id := NULL;
935: END IF;
936:
937: IF l_DiscreteJob_rec.common_rout_sequence_id = FND_API.G_MISS_NUM THEN

Line 937: IF l_DiscreteJob_rec.common_rout_sequence_id = FND_API.G_MISS_NUM THEN

933: IF l_DiscreteJob_rec.common_bom_sequence_id = FND_API.G_MISS_NUM THEN
934: l_DiscreteJob_rec.common_bom_sequence_id := NULL;
935: END IF;
936:
937: IF l_DiscreteJob_rec.common_rout_sequence_id = FND_API.G_MISS_NUM THEN
938: l_DiscreteJob_rec.common_rout_sequence_id := NULL;
939: END IF;
940:
941: IF l_DiscreteJob_rec.completion_locator_id = FND_API.G_MISS_NUM THEN

Line 941: IF l_DiscreteJob_rec.completion_locator_id = FND_API.G_MISS_NUM THEN

937: IF l_DiscreteJob_rec.common_rout_sequence_id = FND_API.G_MISS_NUM THEN
938: l_DiscreteJob_rec.common_rout_sequence_id := NULL;
939: END IF;
940:
941: IF l_DiscreteJob_rec.completion_locator_id = FND_API.G_MISS_NUM THEN
942: l_DiscreteJob_rec.completion_locator_id := NULL;
943: END IF;
944:
945: IF l_DiscreteJob_rec.completion_subinventory = FND_API.G_MISS_CHAR THEN

Line 945: IF l_DiscreteJob_rec.completion_subinventory = FND_API.G_MISS_CHAR THEN

941: IF l_DiscreteJob_rec.completion_locator_id = FND_API.G_MISS_NUM THEN
942: l_DiscreteJob_rec.completion_locator_id := NULL;
943: END IF;
944:
945: IF l_DiscreteJob_rec.completion_subinventory = FND_API.G_MISS_CHAR THEN
946: l_DiscreteJob_rec.completion_subinventory := NULL;
947: END IF;
948:
949: IF l_DiscreteJob_rec.created_by = FND_API.G_MISS_NUM THEN

Line 949: IF l_DiscreteJob_rec.created_by = FND_API.G_MISS_NUM THEN

945: IF l_DiscreteJob_rec.completion_subinventory = FND_API.G_MISS_CHAR THEN
946: l_DiscreteJob_rec.completion_subinventory := NULL;
947: END IF;
948:
949: IF l_DiscreteJob_rec.created_by = FND_API.G_MISS_NUM THEN
950: l_DiscreteJob_rec.created_by := NULL;
951: END IF;
952:
953: IF l_DiscreteJob_rec.creation_date = FND_API.G_MISS_DATE THEN

Line 953: IF l_DiscreteJob_rec.creation_date = FND_API.G_MISS_DATE THEN

949: IF l_DiscreteJob_rec.created_by = FND_API.G_MISS_NUM THEN
950: l_DiscreteJob_rec.created_by := NULL;
951: END IF;
952:
953: IF l_DiscreteJob_rec.creation_date = FND_API.G_MISS_DATE THEN
954: l_DiscreteJob_rec.creation_date := NULL;
955: END IF;
956:
957: IF l_DiscreteJob_rec.date_closed = FND_API.G_MISS_DATE THEN

Line 957: IF l_DiscreteJob_rec.date_closed = FND_API.G_MISS_DATE THEN

953: IF l_DiscreteJob_rec.creation_date = FND_API.G_MISS_DATE THEN
954: l_DiscreteJob_rec.creation_date := NULL;
955: END IF;
956:
957: IF l_DiscreteJob_rec.date_closed = FND_API.G_MISS_DATE THEN
958: l_DiscreteJob_rec.date_closed := NULL;
959: END IF;
960:
961: IF l_DiscreteJob_rec.date_completed = FND_API.G_MISS_DATE THEN

Line 961: IF l_DiscreteJob_rec.date_completed = FND_API.G_MISS_DATE THEN

957: IF l_DiscreteJob_rec.date_closed = FND_API.G_MISS_DATE THEN
958: l_DiscreteJob_rec.date_closed := NULL;
959: END IF;
960:
961: IF l_DiscreteJob_rec.date_completed = FND_API.G_MISS_DATE THEN
962: l_DiscreteJob_rec.date_completed := NULL;
963: END IF;
964:
965: IF l_DiscreteJob_rec.date_released = FND_API.G_MISS_DATE THEN

Line 965: IF l_DiscreteJob_rec.date_released = FND_API.G_MISS_DATE THEN

961: IF l_DiscreteJob_rec.date_completed = FND_API.G_MISS_DATE THEN
962: l_DiscreteJob_rec.date_completed := NULL;
963: END IF;
964:
965: IF l_DiscreteJob_rec.date_released = FND_API.G_MISS_DATE THEN
966: l_DiscreteJob_rec.date_released := NULL;
967: END IF;
968:
969: IF l_DiscreteJob_rec.demand_class = FND_API.G_MISS_CHAR THEN

Line 969: IF l_DiscreteJob_rec.demand_class = FND_API.G_MISS_CHAR THEN

965: IF l_DiscreteJob_rec.date_released = FND_API.G_MISS_DATE THEN
966: l_DiscreteJob_rec.date_released := NULL;
967: END IF;
968:
969: IF l_DiscreteJob_rec.demand_class = FND_API.G_MISS_CHAR THEN
970: l_DiscreteJob_rec.demand_class := NULL;
971: END IF;
972:
973: IF l_DiscreteJob_rec.description = FND_API.G_MISS_CHAR THEN

Line 973: IF l_DiscreteJob_rec.description = FND_API.G_MISS_CHAR THEN

969: IF l_DiscreteJob_rec.demand_class = FND_API.G_MISS_CHAR THEN
970: l_DiscreteJob_rec.demand_class := NULL;
971: END IF;
972:
973: IF l_DiscreteJob_rec.description = FND_API.G_MISS_CHAR THEN
974: l_DiscreteJob_rec.description := NULL;
975: END IF;
976:
977: IF l_DiscreteJob_rec.firm_planned_flag = FND_API.G_MISS_NUM THEN

Line 977: IF l_DiscreteJob_rec.firm_planned_flag = FND_API.G_MISS_NUM THEN

973: IF l_DiscreteJob_rec.description = FND_API.G_MISS_CHAR THEN
974: l_DiscreteJob_rec.description := NULL;
975: END IF;
976:
977: IF l_DiscreteJob_rec.firm_planned_flag = FND_API.G_MISS_NUM THEN
978: l_DiscreteJob_rec.firm_planned_flag := NULL;
979: END IF;
980:
981: IF l_DiscreteJob_rec.job_type = FND_API.G_MISS_NUM THEN

Line 981: IF l_DiscreteJob_rec.job_type = FND_API.G_MISS_NUM THEN

977: IF l_DiscreteJob_rec.firm_planned_flag = FND_API.G_MISS_NUM THEN
978: l_DiscreteJob_rec.firm_planned_flag := NULL;
979: END IF;
980:
981: IF l_DiscreteJob_rec.job_type = FND_API.G_MISS_NUM THEN
982: l_DiscreteJob_rec.job_type := NULL;
983: END IF;
984:
985: IF l_DiscreteJob_rec.kanban_card_id = FND_API.G_MISS_NUM THEN

Line 985: IF l_DiscreteJob_rec.kanban_card_id = FND_API.G_MISS_NUM THEN

981: IF l_DiscreteJob_rec.job_type = FND_API.G_MISS_NUM THEN
982: l_DiscreteJob_rec.job_type := NULL;
983: END IF;
984:
985: IF l_DiscreteJob_rec.kanban_card_id = FND_API.G_MISS_NUM THEN
986: l_DiscreteJob_rec.kanban_card_id := NULL;
987: END IF;
988:
989: IF l_DiscreteJob_rec.last_updated_by = FND_API.G_MISS_NUM THEN

Line 989: IF l_DiscreteJob_rec.last_updated_by = FND_API.G_MISS_NUM THEN

985: IF l_DiscreteJob_rec.kanban_card_id = FND_API.G_MISS_NUM THEN
986: l_DiscreteJob_rec.kanban_card_id := NULL;
987: END IF;
988:
989: IF l_DiscreteJob_rec.last_updated_by = FND_API.G_MISS_NUM THEN
990: l_DiscreteJob_rec.last_updated_by := NULL;
991: END IF;
992:
993: IF l_DiscreteJob_rec.last_update_date = FND_API.G_MISS_DATE THEN

Line 993: IF l_DiscreteJob_rec.last_update_date = FND_API.G_MISS_DATE THEN

989: IF l_DiscreteJob_rec.last_updated_by = FND_API.G_MISS_NUM THEN
990: l_DiscreteJob_rec.last_updated_by := NULL;
991: END IF;
992:
993: IF l_DiscreteJob_rec.last_update_date = FND_API.G_MISS_DATE THEN
994: l_DiscreteJob_rec.last_update_date := NULL;
995: END IF;
996:
997: IF l_DiscreteJob_rec.last_update_login = FND_API.G_MISS_NUM THEN

Line 997: IF l_DiscreteJob_rec.last_update_login = FND_API.G_MISS_NUM THEN

993: IF l_DiscreteJob_rec.last_update_date = FND_API.G_MISS_DATE THEN
994: l_DiscreteJob_rec.last_update_date := NULL;
995: END IF;
996:
997: IF l_DiscreteJob_rec.last_update_login = FND_API.G_MISS_NUM THEN
998: l_DiscreteJob_rec.last_update_login := NULL;
999: END IF;
1000:
1001: IF l_DiscreteJob_rec.line_id = FND_API.G_MISS_NUM THEN

Line 1001: IF l_DiscreteJob_rec.line_id = FND_API.G_MISS_NUM THEN

997: IF l_DiscreteJob_rec.last_update_login = FND_API.G_MISS_NUM THEN
998: l_DiscreteJob_rec.last_update_login := NULL;
999: END IF;
1000:
1001: IF l_DiscreteJob_rec.line_id = FND_API.G_MISS_NUM THEN
1002: l_DiscreteJob_rec.line_id := NULL;
1003: END IF;
1004:
1005: IF l_DiscreteJob_rec.lot_number = FND_API.G_MISS_CHAR THEN

Line 1005: IF l_DiscreteJob_rec.lot_number = FND_API.G_MISS_CHAR THEN

1001: IF l_DiscreteJob_rec.line_id = FND_API.G_MISS_NUM THEN
1002: l_DiscreteJob_rec.line_id := NULL;
1003: END IF;
1004:
1005: IF l_DiscreteJob_rec.lot_number = FND_API.G_MISS_CHAR THEN
1006: l_DiscreteJob_rec.lot_number := NULL;
1007: END IF;
1008:
1009: IF l_DiscreteJob_rec.material_account = FND_API.G_MISS_NUM THEN

Line 1009: IF l_DiscreteJob_rec.material_account = FND_API.G_MISS_NUM THEN

1005: IF l_DiscreteJob_rec.lot_number = FND_API.G_MISS_CHAR THEN
1006: l_DiscreteJob_rec.lot_number := NULL;
1007: END IF;
1008:
1009: IF l_DiscreteJob_rec.material_account = FND_API.G_MISS_NUM THEN
1010: l_DiscreteJob_rec.material_account := NULL;
1011: END IF;
1012:
1013: IF l_DiscreteJob_rec.material_overhead_account = FND_API.G_MISS_NUM THEN

Line 1013: IF l_DiscreteJob_rec.material_overhead_account = FND_API.G_MISS_NUM THEN

1009: IF l_DiscreteJob_rec.material_account = FND_API.G_MISS_NUM THEN
1010: l_DiscreteJob_rec.material_account := NULL;
1011: END IF;
1012:
1013: IF l_DiscreteJob_rec.material_overhead_account = FND_API.G_MISS_NUM THEN
1014: l_DiscreteJob_rec.material_overhead_account := NULL;
1015: END IF;
1016:
1017: IF l_DiscreteJob_rec.material_variance_account = FND_API.G_MISS_NUM THEN

Line 1017: IF l_DiscreteJob_rec.material_variance_account = FND_API.G_MISS_NUM THEN

1013: IF l_DiscreteJob_rec.material_overhead_account = FND_API.G_MISS_NUM THEN
1014: l_DiscreteJob_rec.material_overhead_account := NULL;
1015: END IF;
1016:
1017: IF l_DiscreteJob_rec.material_variance_account = FND_API.G_MISS_NUM THEN
1018: l_DiscreteJob_rec.material_variance_account := NULL;
1019: END IF;
1020:
1021: IF l_DiscreteJob_rec.mps_net_quantity = FND_API.G_MISS_NUM THEN

Line 1021: IF l_DiscreteJob_rec.mps_net_quantity = FND_API.G_MISS_NUM THEN

1017: IF l_DiscreteJob_rec.material_variance_account = FND_API.G_MISS_NUM THEN
1018: l_DiscreteJob_rec.material_variance_account := NULL;
1019: END IF;
1020:
1021: IF l_DiscreteJob_rec.mps_net_quantity = FND_API.G_MISS_NUM THEN
1022: l_DiscreteJob_rec.mps_net_quantity := NULL;
1023: END IF;
1024:
1025: IF l_DiscreteJob_rec.mps_scheduled_cpl_date = FND_API.G_MISS_DATE THEN

Line 1025: IF l_DiscreteJob_rec.mps_scheduled_cpl_date = FND_API.G_MISS_DATE THEN

1021: IF l_DiscreteJob_rec.mps_net_quantity = FND_API.G_MISS_NUM THEN
1022: l_DiscreteJob_rec.mps_net_quantity := NULL;
1023: END IF;
1024:
1025: IF l_DiscreteJob_rec.mps_scheduled_cpl_date = FND_API.G_MISS_DATE THEN
1026: l_DiscreteJob_rec.mps_scheduled_cpl_date := NULL;
1027: END IF;
1028:
1029: IF l_DiscreteJob_rec.net_quantity = FND_API.G_MISS_NUM THEN

Line 1029: IF l_DiscreteJob_rec.net_quantity = FND_API.G_MISS_NUM THEN

1025: IF l_DiscreteJob_rec.mps_scheduled_cpl_date = FND_API.G_MISS_DATE THEN
1026: l_DiscreteJob_rec.mps_scheduled_cpl_date := NULL;
1027: END IF;
1028:
1029: IF l_DiscreteJob_rec.net_quantity = FND_API.G_MISS_NUM THEN
1030: l_DiscreteJob_rec.net_quantity := NULL;
1031: END IF;
1032:
1033: IF l_DiscreteJob_rec.organization_id = FND_API.G_MISS_NUM THEN

Line 1033: IF l_DiscreteJob_rec.organization_id = FND_API.G_MISS_NUM THEN

1029: IF l_DiscreteJob_rec.net_quantity = FND_API.G_MISS_NUM THEN
1030: l_DiscreteJob_rec.net_quantity := NULL;
1031: END IF;
1032:
1033: IF l_DiscreteJob_rec.organization_id = FND_API.G_MISS_NUM THEN
1034: l_DiscreteJob_rec.organization_id := NULL;
1035: END IF;
1036:
1037: IF l_DiscreteJob_rec.osp_account = FND_API.G_MISS_NUM THEN

Line 1037: IF l_DiscreteJob_rec.osp_account = FND_API.G_MISS_NUM THEN

1033: IF l_DiscreteJob_rec.organization_id = FND_API.G_MISS_NUM THEN
1034: l_DiscreteJob_rec.organization_id := NULL;
1035: END IF;
1036:
1037: IF l_DiscreteJob_rec.osp_account = FND_API.G_MISS_NUM THEN
1038: l_DiscreteJob_rec.osp_account := NULL;
1039: END IF;
1040:
1041: IF l_DiscreteJob_rec.osp_variance_account = FND_API.G_MISS_NUM THEN

Line 1041: IF l_DiscreteJob_rec.osp_variance_account = FND_API.G_MISS_NUM THEN

1037: IF l_DiscreteJob_rec.osp_account = FND_API.G_MISS_NUM THEN
1038: l_DiscreteJob_rec.osp_account := NULL;
1039: END IF;
1040:
1041: IF l_DiscreteJob_rec.osp_variance_account = FND_API.G_MISS_NUM THEN
1042: l_DiscreteJob_rec.osp_variance_account := NULL;
1043: END IF;
1044:
1045: IF l_DiscreteJob_rec.overcpl_tolerance_type = FND_API.G_MISS_NUM THEN

Line 1045: IF l_DiscreteJob_rec.overcpl_tolerance_type = FND_API.G_MISS_NUM THEN

1041: IF l_DiscreteJob_rec.osp_variance_account = FND_API.G_MISS_NUM THEN
1042: l_DiscreteJob_rec.osp_variance_account := NULL;
1043: END IF;
1044:
1045: IF l_DiscreteJob_rec.overcpl_tolerance_type = FND_API.G_MISS_NUM THEN
1046: l_DiscreteJob_rec.overcpl_tolerance_type := NULL;
1047: END IF;
1048:
1049: IF l_DiscreteJob_rec.overcpl_tolerance_value = FND_API.G_MISS_NUM THEN

Line 1049: IF l_DiscreteJob_rec.overcpl_tolerance_value = FND_API.G_MISS_NUM THEN

1045: IF l_DiscreteJob_rec.overcpl_tolerance_type = FND_API.G_MISS_NUM THEN
1046: l_DiscreteJob_rec.overcpl_tolerance_type := NULL;
1047: END IF;
1048:
1049: IF l_DiscreteJob_rec.overcpl_tolerance_value = FND_API.G_MISS_NUM THEN
1050: l_DiscreteJob_rec.overcpl_tolerance_value := NULL;
1051: END IF;
1052:
1053: IF l_DiscreteJob_rec.overhead_account = FND_API.G_MISS_NUM THEN

Line 1053: IF l_DiscreteJob_rec.overhead_account = FND_API.G_MISS_NUM THEN

1049: IF l_DiscreteJob_rec.overcpl_tolerance_value = FND_API.G_MISS_NUM THEN
1050: l_DiscreteJob_rec.overcpl_tolerance_value := NULL;
1051: END IF;
1052:
1053: IF l_DiscreteJob_rec.overhead_account = FND_API.G_MISS_NUM THEN
1054: l_DiscreteJob_rec.overhead_account := NULL;
1055: END IF;
1056:
1057: IF l_DiscreteJob_rec.overhead_variance_account = FND_API.G_MISS_NUM THEN

Line 1057: IF l_DiscreteJob_rec.overhead_variance_account = FND_API.G_MISS_NUM THEN

1053: IF l_DiscreteJob_rec.overhead_account = FND_API.G_MISS_NUM THEN
1054: l_DiscreteJob_rec.overhead_account := NULL;
1055: END IF;
1056:
1057: IF l_DiscreteJob_rec.overhead_variance_account = FND_API.G_MISS_NUM THEN
1058: l_DiscreteJob_rec.overhead_variance_account := NULL;
1059: END IF;
1060:
1061: IF l_DiscreteJob_rec.primary_item_id = FND_API.G_MISS_NUM THEN

Line 1061: IF l_DiscreteJob_rec.primary_item_id = FND_API.G_MISS_NUM THEN

1057: IF l_DiscreteJob_rec.overhead_variance_account = FND_API.G_MISS_NUM THEN
1058: l_DiscreteJob_rec.overhead_variance_account := NULL;
1059: END IF;
1060:
1061: IF l_DiscreteJob_rec.primary_item_id = FND_API.G_MISS_NUM THEN
1062: l_DiscreteJob_rec.primary_item_id := NULL;
1063: END IF;
1064:
1065: IF l_DiscreteJob_rec.program_application_id = FND_API.G_MISS_NUM THEN

Line 1065: IF l_DiscreteJob_rec.program_application_id = FND_API.G_MISS_NUM THEN

1061: IF l_DiscreteJob_rec.primary_item_id = FND_API.G_MISS_NUM THEN
1062: l_DiscreteJob_rec.primary_item_id := NULL;
1063: END IF;
1064:
1065: IF l_DiscreteJob_rec.program_application_id = FND_API.G_MISS_NUM THEN
1066: l_DiscreteJob_rec.program_application_id := NULL;
1067: END IF;
1068:
1069: IF l_DiscreteJob_rec.program_id = FND_API.G_MISS_NUM THEN

Line 1069: IF l_DiscreteJob_rec.program_id = FND_API.G_MISS_NUM THEN

1065: IF l_DiscreteJob_rec.program_application_id = FND_API.G_MISS_NUM THEN
1066: l_DiscreteJob_rec.program_application_id := NULL;
1067: END IF;
1068:
1069: IF l_DiscreteJob_rec.program_id = FND_API.G_MISS_NUM THEN
1070: l_DiscreteJob_rec.program_id := NULL;
1071: END IF;
1072:
1073: IF l_DiscreteJob_rec.program_update_date = FND_API.G_MISS_DATE THEN

Line 1073: IF l_DiscreteJob_rec.program_update_date = FND_API.G_MISS_DATE THEN

1069: IF l_DiscreteJob_rec.program_id = FND_API.G_MISS_NUM THEN
1070: l_DiscreteJob_rec.program_id := NULL;
1071: END IF;
1072:
1073: IF l_DiscreteJob_rec.program_update_date = FND_API.G_MISS_DATE THEN
1074: l_DiscreteJob_rec.program_update_date := NULL;
1075: END IF;
1076:
1077: IF l_DiscreteJob_rec.project_costed = FND_API.G_MISS_NUM THEN

Line 1077: IF l_DiscreteJob_rec.project_costed = FND_API.G_MISS_NUM THEN

1073: IF l_DiscreteJob_rec.program_update_date = FND_API.G_MISS_DATE THEN
1074: l_DiscreteJob_rec.program_update_date := NULL;
1075: END IF;
1076:
1077: IF l_DiscreteJob_rec.project_costed = FND_API.G_MISS_NUM THEN
1078: l_DiscreteJob_rec.project_costed := NULL;
1079: END IF;
1080:
1081: IF l_DiscreteJob_rec.project_id = FND_API.G_MISS_NUM THEN

Line 1081: IF l_DiscreteJob_rec.project_id = FND_API.G_MISS_NUM THEN

1077: IF l_DiscreteJob_rec.project_costed = FND_API.G_MISS_NUM THEN
1078: l_DiscreteJob_rec.project_costed := NULL;
1079: END IF;
1080:
1081: IF l_DiscreteJob_rec.project_id = FND_API.G_MISS_NUM THEN
1082: l_DiscreteJob_rec.project_id := NULL;
1083: END IF;
1084:
1085: IF l_DiscreteJob_rec.quantity_completed = FND_API.G_MISS_NUM THEN

Line 1085: IF l_DiscreteJob_rec.quantity_completed = FND_API.G_MISS_NUM THEN

1081: IF l_DiscreteJob_rec.project_id = FND_API.G_MISS_NUM THEN
1082: l_DiscreteJob_rec.project_id := NULL;
1083: END IF;
1084:
1085: IF l_DiscreteJob_rec.quantity_completed = FND_API.G_MISS_NUM THEN
1086: l_DiscreteJob_rec.quantity_completed := NULL;
1087: END IF;
1088:
1089: IF l_DiscreteJob_rec.quantity_scrapped = FND_API.G_MISS_NUM THEN

Line 1089: IF l_DiscreteJob_rec.quantity_scrapped = FND_API.G_MISS_NUM THEN

1085: IF l_DiscreteJob_rec.quantity_completed = FND_API.G_MISS_NUM THEN
1086: l_DiscreteJob_rec.quantity_completed := NULL;
1087: END IF;
1088:
1089: IF l_DiscreteJob_rec.quantity_scrapped = FND_API.G_MISS_NUM THEN
1090: l_DiscreteJob_rec.quantity_scrapped := NULL;
1091: END IF;
1092:
1093: IF l_DiscreteJob_rec.request_id = FND_API.G_MISS_NUM THEN

Line 1093: IF l_DiscreteJob_rec.request_id = FND_API.G_MISS_NUM THEN

1089: IF l_DiscreteJob_rec.quantity_scrapped = FND_API.G_MISS_NUM THEN
1090: l_DiscreteJob_rec.quantity_scrapped := NULL;
1091: END IF;
1092:
1093: IF l_DiscreteJob_rec.request_id = FND_API.G_MISS_NUM THEN
1094: l_DiscreteJob_rec.request_id := NULL;
1095: END IF;
1096:
1097: IF l_DiscreteJob_rec.resource_account = FND_API.G_MISS_NUM THEN

Line 1097: IF l_DiscreteJob_rec.resource_account = FND_API.G_MISS_NUM THEN

1093: IF l_DiscreteJob_rec.request_id = FND_API.G_MISS_NUM THEN
1094: l_DiscreteJob_rec.request_id := NULL;
1095: END IF;
1096:
1097: IF l_DiscreteJob_rec.resource_account = FND_API.G_MISS_NUM THEN
1098: l_DiscreteJob_rec.resource_account := NULL;
1099: END IF;
1100:
1101: IF l_DiscreteJob_rec.resource_variance_account = FND_API.G_MISS_NUM THEN

Line 1101: IF l_DiscreteJob_rec.resource_variance_account = FND_API.G_MISS_NUM THEN

1097: IF l_DiscreteJob_rec.resource_account = FND_API.G_MISS_NUM THEN
1098: l_DiscreteJob_rec.resource_account := NULL;
1099: END IF;
1100:
1101: IF l_DiscreteJob_rec.resource_variance_account = FND_API.G_MISS_NUM THEN
1102: l_DiscreteJob_rec.resource_variance_account := NULL;
1103: END IF;
1104:
1105: IF l_DiscreteJob_rec.routing_reference_id = FND_API.G_MISS_NUM THEN

Line 1105: IF l_DiscreteJob_rec.routing_reference_id = FND_API.G_MISS_NUM THEN

1101: IF l_DiscreteJob_rec.resource_variance_account = FND_API.G_MISS_NUM THEN
1102: l_DiscreteJob_rec.resource_variance_account := NULL;
1103: END IF;
1104:
1105: IF l_DiscreteJob_rec.routing_reference_id = FND_API.G_MISS_NUM THEN
1106: l_DiscreteJob_rec.routing_reference_id := NULL;
1107: END IF;
1108:
1109: IF l_DiscreteJob_rec.routing_revision = FND_API.G_MISS_CHAR THEN

Line 1109: IF l_DiscreteJob_rec.routing_revision = FND_API.G_MISS_CHAR THEN

1105: IF l_DiscreteJob_rec.routing_reference_id = FND_API.G_MISS_NUM THEN
1106: l_DiscreteJob_rec.routing_reference_id := NULL;
1107: END IF;
1108:
1109: IF l_DiscreteJob_rec.routing_revision = FND_API.G_MISS_CHAR THEN
1110: l_DiscreteJob_rec.routing_revision := NULL;
1111: END IF;
1112:
1113: IF l_DiscreteJob_rec.routing_revision_date = FND_API.G_MISS_DATE THEN

Line 1113: IF l_DiscreteJob_rec.routing_revision_date = FND_API.G_MISS_DATE THEN

1109: IF l_DiscreteJob_rec.routing_revision = FND_API.G_MISS_CHAR THEN
1110: l_DiscreteJob_rec.routing_revision := NULL;
1111: END IF;
1112:
1113: IF l_DiscreteJob_rec.routing_revision_date = FND_API.G_MISS_DATE THEN
1114: l_DiscreteJob_rec.routing_revision_date := NULL;
1115: END IF;
1116:
1117: IF l_DiscreteJob_rec.scheduled_completion_date = FND_API.G_MISS_DATE THEN

Line 1117: IF l_DiscreteJob_rec.scheduled_completion_date = FND_API.G_MISS_DATE THEN

1113: IF l_DiscreteJob_rec.routing_revision_date = FND_API.G_MISS_DATE THEN
1114: l_DiscreteJob_rec.routing_revision_date := NULL;
1115: END IF;
1116:
1117: IF l_DiscreteJob_rec.scheduled_completion_date = FND_API.G_MISS_DATE THEN
1118: l_DiscreteJob_rec.scheduled_completion_date := NULL;
1119: END IF;
1120:
1121: IF l_DiscreteJob_rec.scheduled_start_date = FND_API.G_MISS_DATE THEN

Line 1121: IF l_DiscreteJob_rec.scheduled_start_date = FND_API.G_MISS_DATE THEN

1117: IF l_DiscreteJob_rec.scheduled_completion_date = FND_API.G_MISS_DATE THEN
1118: l_DiscreteJob_rec.scheduled_completion_date := NULL;
1119: END IF;
1120:
1121: IF l_DiscreteJob_rec.scheduled_start_date = FND_API.G_MISS_DATE THEN
1122: l_DiscreteJob_rec.scheduled_start_date := NULL;
1123: END IF;
1124:
1125: IF l_DiscreteJob_rec.schedule_group_id = FND_API.G_MISS_NUM THEN

Line 1125: IF l_DiscreteJob_rec.schedule_group_id = FND_API.G_MISS_NUM THEN

1121: IF l_DiscreteJob_rec.scheduled_start_date = FND_API.G_MISS_DATE THEN
1122: l_DiscreteJob_rec.scheduled_start_date := NULL;
1123: END IF;
1124:
1125: IF l_DiscreteJob_rec.schedule_group_id = FND_API.G_MISS_NUM THEN
1126: l_DiscreteJob_rec.schedule_group_id := NULL;
1127: END IF;
1128:
1129: IF l_DiscreteJob_rec.source_code = FND_API.G_MISS_CHAR THEN

Line 1129: IF l_DiscreteJob_rec.source_code = FND_API.G_MISS_CHAR THEN

1125: IF l_DiscreteJob_rec.schedule_group_id = FND_API.G_MISS_NUM THEN
1126: l_DiscreteJob_rec.schedule_group_id := NULL;
1127: END IF;
1128:
1129: IF l_DiscreteJob_rec.source_code = FND_API.G_MISS_CHAR THEN
1130: l_DiscreteJob_rec.source_code := NULL;
1131: END IF;
1132:
1133: IF l_DiscreteJob_rec.source_line_id = FND_API.G_MISS_NUM THEN

Line 1133: IF l_DiscreteJob_rec.source_line_id = FND_API.G_MISS_NUM THEN

1129: IF l_DiscreteJob_rec.source_code = FND_API.G_MISS_CHAR THEN
1130: l_DiscreteJob_rec.source_code := NULL;
1131: END IF;
1132:
1133: IF l_DiscreteJob_rec.source_line_id = FND_API.G_MISS_NUM THEN
1134: l_DiscreteJob_rec.source_line_id := NULL;
1135: END IF;
1136:
1137: IF l_DiscreteJob_rec.start_quantity = FND_API.G_MISS_NUM THEN

Line 1137: IF l_DiscreteJob_rec.start_quantity = FND_API.G_MISS_NUM THEN

1133: IF l_DiscreteJob_rec.source_line_id = FND_API.G_MISS_NUM THEN
1134: l_DiscreteJob_rec.source_line_id := NULL;
1135: END IF;
1136:
1137: IF l_DiscreteJob_rec.start_quantity = FND_API.G_MISS_NUM THEN
1138: l_DiscreteJob_rec.start_quantity := NULL;
1139: END IF;
1140:
1141: IF l_DiscreteJob_rec.status_type = FND_API.G_MISS_NUM THEN

Line 1141: IF l_DiscreteJob_rec.status_type = FND_API.G_MISS_NUM THEN

1137: IF l_DiscreteJob_rec.start_quantity = FND_API.G_MISS_NUM THEN
1138: l_DiscreteJob_rec.start_quantity := NULL;
1139: END IF;
1140:
1141: IF l_DiscreteJob_rec.status_type = FND_API.G_MISS_NUM THEN
1142: l_DiscreteJob_rec.status_type := NULL;
1143: END IF;
1144:
1145: IF l_DiscreteJob_rec.std_cost_adj_account = FND_API.G_MISS_NUM THEN

Line 1145: IF l_DiscreteJob_rec.std_cost_adj_account = FND_API.G_MISS_NUM THEN

1141: IF l_DiscreteJob_rec.status_type = FND_API.G_MISS_NUM THEN
1142: l_DiscreteJob_rec.status_type := NULL;
1143: END IF;
1144:
1145: IF l_DiscreteJob_rec.std_cost_adj_account = FND_API.G_MISS_NUM THEN
1146: l_DiscreteJob_rec.std_cost_adj_account := NULL;
1147: END IF;
1148:
1149: IF l_DiscreteJob_rec.task_id = FND_API.G_MISS_NUM THEN

Line 1149: IF l_DiscreteJob_rec.task_id = FND_API.G_MISS_NUM THEN

1145: IF l_DiscreteJob_rec.std_cost_adj_account = FND_API.G_MISS_NUM THEN
1146: l_DiscreteJob_rec.std_cost_adj_account := NULL;
1147: END IF;
1148:
1149: IF l_DiscreteJob_rec.task_id = FND_API.G_MISS_NUM THEN
1150: l_DiscreteJob_rec.task_id := NULL;
1151: END IF;
1152:
1153: IF l_DiscreteJob_rec.wip_entity_id = FND_API.G_MISS_NUM THEN

Line 1153: IF l_DiscreteJob_rec.wip_entity_id = FND_API.G_MISS_NUM THEN

1149: IF l_DiscreteJob_rec.task_id = FND_API.G_MISS_NUM THEN
1150: l_DiscreteJob_rec.task_id := NULL;
1151: END IF;
1152:
1153: IF l_DiscreteJob_rec.wip_entity_id = FND_API.G_MISS_NUM THEN
1154: l_DiscreteJob_rec.wip_entity_id := NULL;
1155: END IF;
1156:
1157: IF l_DiscreteJob_rec.wip_supply_type = FND_API.G_MISS_NUM THEN

Line 1157: IF l_DiscreteJob_rec.wip_supply_type = FND_API.G_MISS_NUM THEN

1153: IF l_DiscreteJob_rec.wip_entity_id = FND_API.G_MISS_NUM THEN
1154: l_DiscreteJob_rec.wip_entity_id := NULL;
1155: END IF;
1156:
1157: IF l_DiscreteJob_rec.wip_supply_type = FND_API.G_MISS_NUM THEN
1158: l_DiscreteJob_rec.wip_supply_type := NULL;
1159: END IF;
1160:
1161: RETURN l_DiscreteJob_rec;

Line 1269: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1265: , 'Update_Row'
1266: );
1267: END IF;
1268:
1269: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1270:
1271: END Update_Row;
1272:
1273: -- Procedure Insert_Row

Line 1458: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1454: , 'Insert_Row'
1455: );
1456: END IF;
1457:
1458: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1459:
1460: END Insert_Row;
1461:
1462: -- Procedure Delete_Row

Line 1486: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1482: , 'Delete_Row'
1483: );
1484: END IF;
1485:
1486: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1487:
1488: END Delete_Row;
1489:
1490: -- Function Query_Row

Line 1698: p_wip_entity_id <> FND_API.G_MISS_NUM)

1694:
1695: IF
1696: (p_wip_entity_id IS NOT NULL
1697: AND
1698: p_wip_entity_id <> FND_API.G_MISS_NUM)
1699: AND
1700: (l_DiscreteJob_tbl.COUNT = 0)
1701: THEN
1702: RAISE NO_DATA_FOUND;

Line 1712: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1708: RETURN l_DiscreteJob_tbl;
1709:
1710: EXCEPTION
1711:
1712: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1713:
1714: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1715:
1716: WHEN OTHERS THEN

Line 1714: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1710: EXCEPTION
1711:
1712: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1713:
1714: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1715:
1716: WHEN OTHERS THEN
1717:
1718: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

Line 1726: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1722: , 'Query_Rows'
1723: );
1724: END IF;
1725:
1726: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1727:
1728: END Query_Rows;
1729:
1730: -- Procedure lock_Row

Line 2076: x_return_status := FND_API.G_RET_STS_SUCCESS;

2072: x_DiscreteJob_rec := l_DiscreteJob_rec;
2073:
2074: -- Set return status
2075:
2076: x_return_status := FND_API.G_RET_STS_SUCCESS;
2077: x_DiscreteJob_rec.return_status := FND_API.G_RET_STS_SUCCESS;
2078:
2079: ELSE
2080:

Line 2077: x_DiscreteJob_rec.return_status := FND_API.G_RET_STS_SUCCESS;

2073:
2074: -- Set return status
2075:
2076: x_return_status := FND_API.G_RET_STS_SUCCESS;
2077: x_DiscreteJob_rec.return_status := FND_API.G_RET_STS_SUCCESS;
2078:
2079: ELSE
2080:
2081: -- Row has changed by another user.

Line 2083: x_return_status := FND_API.G_RET_STS_ERROR;

2079: ELSE
2080:
2081: -- Row has changed by another user.
2082:
2083: x_return_status := FND_API.G_RET_STS_ERROR;
2084: x_DiscreteJob_rec.return_status := FND_API.G_RET_STS_ERROR;
2085:
2086: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
2087: THEN

Line 2084: x_DiscreteJob_rec.return_status := FND_API.G_RET_STS_ERROR;

2080:
2081: -- Row has changed by another user.
2082:
2083: x_return_status := FND_API.G_RET_STS_ERROR;
2084: x_DiscreteJob_rec.return_status := FND_API.G_RET_STS_ERROR;
2085:
2086: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
2087: THEN
2088:

Line 2100: x_return_status := FND_API.G_RET_STS_ERROR;

2096: EXCEPTION
2097:
2098: WHEN NO_DATA_FOUND THEN
2099:
2100: x_return_status := FND_API.G_RET_STS_ERROR;
2101: x_DiscreteJob_rec.return_status := FND_API.G_RET_STS_ERROR;
2102:
2103: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
2104: THEN

Line 2101: x_DiscreteJob_rec.return_status := FND_API.G_RET_STS_ERROR;

2097:
2098: WHEN NO_DATA_FOUND THEN
2099:
2100: x_return_status := FND_API.G_RET_STS_ERROR;
2101: x_DiscreteJob_rec.return_status := FND_API.G_RET_STS_ERROR;
2102:
2103: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
2104: THEN
2105:

Line 2112: x_return_status := FND_API.G_RET_STS_ERROR;

2108:
2109: END IF;
2110: WHEN APP_EXCEPTIONS.RECORD_LOCK_EXCEPTION THEN
2111:
2112: x_return_status := FND_API.G_RET_STS_ERROR;
2113: x_DiscreteJob_rec.return_status := FND_API.G_RET_STS_ERROR;
2114:
2115: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
2116: THEN

Line 2113: x_DiscreteJob_rec.return_status := FND_API.G_RET_STS_ERROR;

2109: END IF;
2110: WHEN APP_EXCEPTIONS.RECORD_LOCK_EXCEPTION THEN
2111:
2112: x_return_status := FND_API.G_RET_STS_ERROR;
2113: x_DiscreteJob_rec.return_status := FND_API.G_RET_STS_ERROR;
2114:
2115: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
2116: THEN
2117:

Line 2124: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2120:
2121: END IF;
2122: WHEN OTHERS THEN
2123:
2124: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2125: x_DiscreteJob_rec.return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2126:
2127: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2128: THEN

Line 2125: x_DiscreteJob_rec.return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2121: END IF;
2122: WHEN OTHERS THEN
2123:
2124: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2125: x_DiscreteJob_rec.return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2126:
2127: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2128: THEN
2129: FND_MSG_PUB.Add_Exc_Msg

Line 2374: x_return_status := FND_API.G_RET_STS_ERROR;

2370: x_wip_entity_name VARCHAR2(240);
2371:
2372: BEGIN
2373:
2374: x_return_status := FND_API.G_RET_STS_ERROR;
2375:
2376: if (p_initialize = 'Y') then
2377: fnd_msg_pub.initialize;
2378: end if;

Line 2391: -- RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2387: fnd_msg_pub.add_exc_msg(p_pkg_name => 'wip_discretejob_util',
2388: p_procedure_name => 'update_job_details',
2389: p_error_text => x_err_msg);
2390:
2391: -- RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2392: return;
2393: end if;
2394:
2395: -- Verify that the schedule group and build sequence are unique

Line 2407: --RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2403: fnd_msg_pub.add_exc_msg(p_pkg_name => 'wip_discretejob_util',
2404: p_procedure_name => 'update_job_details',
2405: p_error_text => x_err_msg);
2406:
2407: --RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2408: close c_build_seq;
2409: return;
2410: end if;
2411:

Line 2425: x_return_status := FND_API.G_RET_STS_SUCCESS;

2421: where organization_id = p_org_id and
2422: wip_entity_id = p_wip_entity_id;
2423:
2424:
2425: x_return_status := FND_API.G_RET_STS_SUCCESS;
2426:
2427: exception
2428: when fnd_api.g_exc_unexpected_error then
2429: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 2428: when fnd_api.g_exc_unexpected_error then

2424:
2425: x_return_status := FND_API.G_RET_STS_SUCCESS;
2426:
2427: exception
2428: when fnd_api.g_exc_unexpected_error then
2429: x_return_status := fnd_api.g_ret_sts_unexp_error;
2430:
2431: when others then
2432: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 2429: x_return_status := fnd_api.g_ret_sts_unexp_error;

2425: x_return_status := FND_API.G_RET_STS_SUCCESS;
2426:
2427: exception
2428: when fnd_api.g_exc_unexpected_error then
2429: x_return_status := fnd_api.g_ret_sts_unexp_error;
2430:
2431: when others then
2432: x_return_status := fnd_api.g_ret_sts_unexp_error;
2433: fnd_msg_pub.add_exc_msg(p_pkg_name => 'wip_discretejob_util',

Line 2432: x_return_status := fnd_api.g_ret_sts_unexp_error;

2428: when fnd_api.g_exc_unexpected_error then
2429: x_return_status := fnd_api.g_ret_sts_unexp_error;
2430:
2431: when others then
2432: x_return_status := fnd_api.g_ret_sts_unexp_error;
2433: fnd_msg_pub.add_exc_msg(p_pkg_name => 'wip_discretejob_util',
2434: p_procedure_name => 'update_job_details',
2435: p_error_text => SQLERRM);
2436: