46: -- Commenting for pl-sql coding standards and instead check if p_attr_id is null
47: -- IF p_attr_id = FND_API.G_MISS_NUM THEN
48: IF p_attr_id IS NULL THEN
49:
50: IF NOT MRP_GLOBALS.Equal(p_flow_schedule_rec.alternate_bom_designator,p_old_flow_schedule_rec.alternate_bom_designator)
51: THEN
52: x_flow_schedule_rec.bom_revision := FND_API.G_MISS_CHAR;
53: x_flow_schedule_rec.bom_revision_date := FND_API.G_MISS_DATE;
54: END IF;
52: x_flow_schedule_rec.bom_revision := FND_API.G_MISS_CHAR;
53: x_flow_schedule_rec.bom_revision_date := FND_API.G_MISS_DATE;
54: END IF;
55:
56: IF NOT MRP_GLOBALS.Equal(p_flow_schedule_rec.alternate_routing_desig,p_old_flow_schedule_rec.alternate_routing_desig)
57: THEN
58: x_flow_schedule_rec.routing_revision := FND_API.G_MISS_CHAR;
59: x_flow_schedule_rec.routing_revision_date := FND_API.G_MISS_DATE;
60: x_flow_schedule_rec.completion_subinventory := FND_API.G_MISS_CHAR;
60: x_flow_schedule_rec.completion_subinventory := FND_API.G_MISS_CHAR;
61: x_flow_schedule_rec.completion_locator_id := FND_API.G_MISS_NUM;
62: END IF;
63:
64: IF NOT MRP_GLOBALS.Equal(p_flow_schedule_rec.bom_revision,p_old_flow_schedule_rec.bom_revision)
65: THEN
66: x_flow_schedule_rec.bom_revision_date := FND_API.G_MISS_DATE;
67: END IF;
68:
65: THEN
66: x_flow_schedule_rec.bom_revision_date := FND_API.G_MISS_DATE;
67: END IF;
68:
69: IF NOT MRP_GLOBALS.Equal(p_flow_schedule_rec.bom_revision_date,p_old_flow_schedule_rec.bom_revision_date)
70: THEN
71: NULL;
72: END IF;
73:
70: THEN
71: NULL;
72: END IF;
73:
74: IF NOT MRP_GLOBALS.Equal(p_flow_schedule_rec.build_sequence,p_old_flow_schedule_rec.build_sequence)
75: THEN
76: NULL;
77: END IF;
78:
75: THEN
76: NULL;
77: END IF;
78:
79: IF NOT MRP_GLOBALS.Equal(p_flow_schedule_rec.class_code,p_old_flow_schedule_rec.class_code)
80: THEN
81: x_flow_schedule_rec.material_account := FND_API.G_MISS_NUM;
82: x_flow_schedule_rec.material_overhead_account := FND_API.G_MISS_NUM;
83: x_flow_schedule_rec.resource_account := FND_API.G_MISS_NUM;
89: x_flow_schedule_rec.overhead_account := FND_API.G_MISS_NUM;
90: x_flow_schedule_rec.overhead_variance_account := FND_API.G_MISS_NUM;
91: END IF;
92:
93: IF NOT MRP_GLOBALS.Equal(p_flow_schedule_rec.completion_locator_id,p_old_flow_schedule_rec.completion_locator_id)
94: THEN
95: NULL;
96: END IF;
97:
94: THEN
95: NULL;
96: END IF;
97:
98: IF NOT MRP_GLOBALS.Equal(p_flow_schedule_rec.completion_subinventory,p_old_flow_schedule_rec.completion_subinventory)
99: THEN
100: x_flow_schedule_rec.completion_locator_id := FND_API.G_MISS_NUM;
101: END IF;
102:
99: THEN
100: x_flow_schedule_rec.completion_locator_id := FND_API.G_MISS_NUM;
101: END IF;
102:
103: IF NOT MRP_GLOBALS.Equal(p_flow_schedule_rec.created_by,p_old_flow_schedule_rec.created_by)
104: THEN
105: NULL;
106: END IF;
107:
104: THEN
105: NULL;
106: END IF;
107:
108: IF NOT MRP_GLOBALS.Equal(p_flow_schedule_rec.creation_date,p_old_flow_schedule_rec.creation_date)
109: THEN
110: NULL;
111: END IF;
112:
109: THEN
110: NULL;
111: END IF;
112:
113: IF NOT MRP_GLOBALS.Equal(p_flow_schedule_rec.date_closed,p_old_flow_schedule_rec.date_closed)
114: THEN
115: NULL;
116: END IF;
117:
114: THEN
115: NULL;
116: END IF;
117:
118: IF NOT MRP_GLOBALS.Equal(p_flow_schedule_rec.demand_class,p_old_flow_schedule_rec.demand_class)
119: THEN
120: NULL;
121: END IF;
122:
119: THEN
120: NULL;
121: END IF;
122:
123: IF NOT MRP_GLOBALS.Equal(p_flow_schedule_rec.demand_source_delivery,p_old_flow_schedule_rec.demand_source_delivery)
124: THEN
125: NULL;
126: END IF;
127:
124: THEN
125: NULL;
126: END IF;
127:
128: IF NOT MRP_GLOBALS.Equal(p_flow_schedule_rec.demand_source_header_id,p_old_flow_schedule_rec.demand_source_header_id)
129: THEN
130: x_flow_schedule_rec.demand_source_line := FND_API.G_MISS_CHAR;
131: x_flow_schedule_rec.demand_source_delivery := FND_API.G_MISS_CHAR;
132: END IF;
130: x_flow_schedule_rec.demand_source_line := FND_API.G_MISS_CHAR;
131: x_flow_schedule_rec.demand_source_delivery := FND_API.G_MISS_CHAR;
132: END IF;
133:
134: IF NOT MRP_GLOBALS.Equal(p_flow_schedule_rec.demand_source_line,p_old_flow_schedule_rec.demand_source_line)
135: THEN
136: NULL;
137: END IF;
138:
135: THEN
136: NULL;
137: END IF;
138:
139: IF NOT MRP_GLOBALS.Equal(p_flow_schedule_rec.demand_source_type,p_old_flow_schedule_rec.demand_source_type)
140: THEN
141: NULL;
142: END IF;
143:
140: THEN
141: NULL;
142: END IF;
143:
144: IF NOT MRP_GLOBALS.Equal(p_flow_schedule_rec.last_updated_by,p_old_flow_schedule_rec.last_updated_by)
145: THEN
146: NULL;
147: END IF;
148:
145: THEN
146: NULL;
147: END IF;
148:
149: IF NOT MRP_GLOBALS.Equal(p_flow_schedule_rec.last_update_date,p_old_flow_schedule_rec.last_update_date)
150: THEN
151: NULL;
152: END IF;
153:
150: THEN
151: NULL;
152: END IF;
153:
154: IF NOT MRP_GLOBALS.Equal(p_flow_schedule_rec.last_update_login,p_old_flow_schedule_rec.last_update_login)
155: THEN
156: NULL;
157: END IF;
158:
155: THEN
156: NULL;
157: END IF;
158:
159: IF NOT MRP_GLOBALS.Equal(p_flow_schedule_rec.line_id,p_old_flow_schedule_rec.line_id)
160: THEN
161: x_flow_schedule_rec.alternate_routing_desig := FND_API.G_MISS_CHAR;
162: END IF;
163:
160: THEN
161: x_flow_schedule_rec.alternate_routing_desig := FND_API.G_MISS_CHAR;
162: END IF;
163:
164: IF NOT MRP_GLOBALS.Equal(p_flow_schedule_rec.material_account,p_old_flow_schedule_rec.material_account)
165: THEN
166: NULL;
167: END IF;
168:
165: THEN
166: NULL;
167: END IF;
168:
169: IF NOT MRP_GLOBALS.Equal(p_flow_schedule_rec.material_overhead_account,p_old_flow_schedule_rec.material_overhead_account)
170: THEN
171: NULL;
172: END IF;
173:
170: THEN
171: NULL;
172: END IF;
173:
174: IF NOT MRP_GLOBALS.Equal(p_flow_schedule_rec.material_variance_account,p_old_flow_schedule_rec.material_variance_account)
175: THEN
176: NULL;
177: END IF;
178:
175: THEN
176: NULL;
177: END IF;
178:
179: IF NOT MRP_GLOBALS.Equal(p_flow_schedule_rec.mps_net_quantity,p_old_flow_schedule_rec.mps_net_quantity)
180: THEN
181: NULL;
182: END IF;
183:
180: THEN
181: NULL;
182: END IF;
183:
184: IF NOT MRP_GLOBALS.Equal(p_flow_schedule_rec.mps_scheduled_comp_date,p_old_flow_schedule_rec.mps_scheduled_comp_date)
185: THEN
186: NULL;
187: END IF;
188:
185: THEN
186: NULL;
187: END IF;
188:
189: IF NOT MRP_GLOBALS.Equal(p_flow_schedule_rec.organization_id,p_old_flow_schedule_rec.organization_id)
190: THEN
191: x_flow_schedule_rec.primary_item_id := FND_API.G_MISS_NUM;
192: x_flow_schedule_rec.completion_subinventory := FND_API.G_MISS_CHAR;
193: x_flow_schedule_rec.completion_locator_id := FND_API.G_MISS_NUM;
215: x_flow_schedule_rec.overhead_account := FND_API.G_MISS_NUM;
216: x_flow_schedule_rec.overhead_variance_account := FND_API.G_MISS_NUM;
217: END IF;
218:
219: IF NOT MRP_GLOBALS.Equal(p_flow_schedule_rec.outside_processing_acct,p_old_flow_schedule_rec.outside_processing_acct)
220: THEN
221: NULL;
222: END IF;
223:
220: THEN
221: NULL;
222: END IF;
223:
224: IF NOT MRP_GLOBALS.Equal(p_flow_schedule_rec.outside_proc_var_acct,p_old_flow_schedule_rec.outside_proc_var_acct)
225: THEN
226: NULL;
227: END IF;
228:
225: THEN
226: NULL;
227: END IF;
228:
229: IF NOT MRP_GLOBALS.Equal(p_flow_schedule_rec.overhead_account,p_old_flow_schedule_rec.overhead_account)
230: THEN
231: NULL;
232: END IF;
233:
230: THEN
231: NULL;
232: END IF;
233:
234: IF NOT MRP_GLOBALS.Equal(p_flow_schedule_rec.overhead_variance_account,p_old_flow_schedule_rec.overhead_variance_account)
235: THEN
236: NULL;
237: END IF;
238:
235: THEN
236: NULL;
237: END IF;
238:
239: IF NOT MRP_GLOBALS.Equal(p_flow_schedule_rec.planned_quantity,p_old_flow_schedule_rec.planned_quantity)
240: THEN
241: x_flow_schedule_rec.scheduled_start_date := FND_API.G_MISS_DATE;
242: END IF;
243:
240: THEN
241: x_flow_schedule_rec.scheduled_start_date := FND_API.G_MISS_DATE;
242: END IF;
243:
244: IF NOT MRP_GLOBALS.Equal(p_flow_schedule_rec.primary_item_id,p_old_flow_schedule_rec.primary_item_id)
245: THEN
246: x_flow_schedule_rec.completion_subinventory := FND_API.G_MISS_CHAR;
247: x_flow_schedule_rec.completion_locator_id := FND_API.G_MISS_NUM;
248: x_flow_schedule_rec.demand_source_header_id := FND_API.G_MISS_NUM;
268: x_flow_schedule_rec.overhead_account := FND_API.G_MISS_NUM;
269: x_flow_schedule_rec.overhead_variance_account := FND_API.G_MISS_NUM;
270: END IF;
271:
272: IF NOT MRP_GLOBALS.Equal(p_flow_schedule_rec.program_application_id,p_old_flow_schedule_rec.program_application_id)
273: THEN
274: NULL;
275: END IF;
276:
273: THEN
274: NULL;
275: END IF;
276:
277: IF NOT MRP_GLOBALS.Equal(p_flow_schedule_rec.program_id,p_old_flow_schedule_rec.program_id)
278: THEN
279: NULL;
280: END IF;
281:
278: THEN
279: NULL;
280: END IF;
281:
282: IF NOT MRP_GLOBALS.Equal(p_flow_schedule_rec.program_update_date,p_old_flow_schedule_rec.program_update_date)
283: THEN
284: NULL;
285: END IF;
286:
283: THEN
284: NULL;
285: END IF;
286:
287: IF NOT MRP_GLOBALS.Equal(p_flow_schedule_rec.project_id,p_old_flow_schedule_rec.project_id)
288: THEN
289: x_flow_schedule_rec.task_id := FND_API.G_MISS_NUM;
290: x_flow_schedule_rec.class_code := FND_API.G_MISS_CHAR;
291: x_flow_schedule_rec.material_account := FND_API.G_MISS_NUM;
299: x_flow_schedule_rec.overhead_account := FND_API.G_MISS_NUM;
300: x_flow_schedule_rec.overhead_variance_account := FND_API.G_MISS_NUM;
301: END IF;
302:
303: IF NOT MRP_GLOBALS.Equal(p_flow_schedule_rec.quantity_completed,p_old_flow_schedule_rec.quantity_completed)
304: THEN
305: NULL;
306: END IF;
307:
304: THEN
305: NULL;
306: END IF;
307:
308: IF NOT MRP_GLOBALS.Equal(p_flow_schedule_rec.request_id,p_old_flow_schedule_rec.request_id)
309: THEN
310: NULL;
311: END IF;
312:
309: THEN
310: NULL;
311: END IF;
312:
313: IF NOT MRP_GLOBALS.Equal(p_flow_schedule_rec.resource_account,p_old_flow_schedule_rec.resource_account)
314: THEN
315: NULL;
316: END IF;
317:
314: THEN
315: NULL;
316: END IF;
317:
318: IF NOT MRP_GLOBALS.Equal(p_flow_schedule_rec.resource_variance_account,p_old_flow_schedule_rec.resource_variance_account)
319: THEN
320: NULL;
321: END IF;
322:
319: THEN
320: NULL;
321: END IF;
322:
323: IF NOT MRP_GLOBALS.Equal(p_flow_schedule_rec.routing_revision,p_old_flow_schedule_rec.routing_revision)
324: THEN
325: x_flow_schedule_rec.routing_revision_date := FND_API.G_MISS_DATE;
326: END IF;
327:
324: THEN
325: x_flow_schedule_rec.routing_revision_date := FND_API.G_MISS_DATE;
326: END IF;
327:
328: IF NOT MRP_GLOBALS.Equal(p_flow_schedule_rec.routing_revision_date,p_old_flow_schedule_rec.routing_revision_date)
329: THEN
330: NULL;
331: END IF;
332:
329: THEN
330: NULL;
331: END IF;
332:
333: IF NOT MRP_GLOBALS.Equal(p_flow_schedule_rec.scheduled_completion_date,p_old_flow_schedule_rec.scheduled_completion_date)
334: THEN
335: x_flow_schedule_rec.scheduled_start_date := FND_API.G_MISS_DATE;
336: x_flow_schedule_rec.bom_revision := FND_API.G_MISS_CHAR;
337: x_flow_schedule_rec.bom_revision_date := FND_API.G_MISS_DATE;
338: x_flow_schedule_rec.routing_revision := FND_API.G_MISS_CHAR;
339: x_flow_schedule_rec.routing_revision_date := FND_API.G_MISS_DATE;
340: END IF;
341:
342: IF NOT MRP_GLOBALS.Equal(p_flow_schedule_rec.scheduled_flag,p_old_flow_schedule_rec.scheduled_flag)
343: THEN
344: NULL;
345: END IF;
346:
343: THEN
344: NULL;
345: END IF;
346:
347: IF NOT MRP_GLOBALS.Equal(p_flow_schedule_rec.scheduled_start_date,p_old_flow_schedule_rec.scheduled_start_date)
348: THEN
349: NULL;
350: END IF;
351:
351:
352: -- Comment it out to fix bug 1198493. We don't want the build_sequence set to null
353: -- when schedule group is changed
354: /*
355: IF NOT MRP_GLOBALS.Equal(p_flow_schedule_rec.schedule_group_id,p_old_flow_schedule_rec.schedule_group_id)
356: THEN
357: x_flow_schedule_rec.build_sequence := FND_API.G_MISS_NUM;
358: END IF;
359: */
357: x_flow_schedule_rec.build_sequence := FND_API.G_MISS_NUM;
358: END IF;
359: */
360:
361: IF NOT MRP_GLOBALS.Equal(p_flow_schedule_rec.schedule_number,p_old_flow_schedule_rec.schedule_number)
362: THEN
363: NULL;
364: END IF;
365:
362: THEN
363: NULL;
364: END IF;
365:
366: IF NOT MRP_GLOBALS.Equal(p_flow_schedule_rec.status,p_old_flow_schedule_rec.status)
367: THEN
368: NULL;
369: END IF;
370:
367: THEN
368: NULL;
369: END IF;
370:
371: IF NOT MRP_GLOBALS.Equal(p_flow_schedule_rec.std_cost_adjustment_acct,p_old_flow_schedule_rec.std_cost_adjustment_acct)
372: THEN
373: NULL;
374: END IF;
375:
372: THEN
373: NULL;
374: END IF;
375:
376: IF NOT MRP_GLOBALS.Equal(p_flow_schedule_rec.task_id,p_old_flow_schedule_rec.task_id)
377: THEN
378: NULL;
379: END IF;
380:
377: THEN
378: NULL;
379: END IF;
380:
381: IF NOT MRP_GLOBALS.Equal(p_flow_schedule_rec.wip_entity_id,p_old_flow_schedule_rec.wip_entity_id)
382: THEN
383: NULL;
384: END IF;
385:
581: -- Load out record
582:
583: x_flow_schedule_rec := p_flow_schedule_rec;
584:
585: IF NOT MRP_GLOBALS.Equal(p_flow_schedule_rec.alternate_bom_designator,p_old_flow_schedule_rec.alternate_bom_designator)
586: THEN
587: NULL;
588: END IF;
589:
586: THEN
587: NULL;
588: END IF;
589:
590: IF NOT MRP_GLOBALS.Equal(p_flow_schedule_rec.alternate_routing_desig,p_old_flow_schedule_rec.alternate_routing_desig)
591: THEN
592: NULL;
593: END IF;
594:
591: THEN
592: NULL;
593: END IF;
594:
595: IF NOT MRP_GLOBALS.Equal(p_flow_schedule_rec.bom_revision,p_old_flow_schedule_rec.bom_revision)
596: THEN
597: NULL;
598: END IF;
599:
596: THEN
597: NULL;
598: END IF;
599:
600: IF NOT MRP_GLOBALS.Equal(p_flow_schedule_rec.bom_revision_date,p_old_flow_schedule_rec.bom_revision_date)
601: THEN
602: NULL;
603: END IF;
604:
601: THEN
602: NULL;
603: END IF;
604:
605: IF NOT MRP_GLOBALS.Equal(p_flow_schedule_rec.build_sequence,p_old_flow_schedule_rec.build_sequence)
606: THEN
607: NULL;
608: END IF;
609:
606: THEN
607: NULL;
608: END IF;
609:
610: IF NOT MRP_GLOBALS.Equal(p_flow_schedule_rec.class_code,p_old_flow_schedule_rec.class_code)
611: THEN
612: NULL;
613: END IF;
614:
611: THEN
612: NULL;
613: END IF;
614:
615: IF NOT MRP_GLOBALS.Equal(p_flow_schedule_rec.completion_locator_id,p_old_flow_schedule_rec.completion_locator_id)
616: THEN
617: NULL;
618: END IF;
619:
616: THEN
617: NULL;
618: END IF;
619:
620: IF NOT MRP_GLOBALS.Equal(p_flow_schedule_rec.completion_subinventory,p_old_flow_schedule_rec.completion_subinventory)
621: THEN
622: NULL;
623: END IF;
624:
621: THEN
622: NULL;
623: END IF;
624:
625: IF NOT MRP_GLOBALS.Equal(p_flow_schedule_rec.created_by,p_old_flow_schedule_rec.created_by)
626: THEN
627: NULL;
628: END IF;
629:
626: THEN
627: NULL;
628: END IF;
629:
630: IF NOT MRP_GLOBALS.Equal(p_flow_schedule_rec.creation_date,p_old_flow_schedule_rec.creation_date)
631: THEN
632: NULL;
633: END IF;
634:
631: THEN
632: NULL;
633: END IF;
634:
635: IF NOT MRP_GLOBALS.Equal(p_flow_schedule_rec.date_closed,p_old_flow_schedule_rec.date_closed)
636: THEN
637: NULL;
638: END IF;
639:
636: THEN
637: NULL;
638: END IF;
639:
640: IF NOT MRP_GLOBALS.Equal(p_flow_schedule_rec.demand_class,p_old_flow_schedule_rec.demand_class)
641: THEN
642: NULL;
643: END IF;
644:
641: THEN
642: NULL;
643: END IF;
644:
645: IF NOT MRP_GLOBALS.Equal(p_flow_schedule_rec.demand_source_delivery,p_old_flow_schedule_rec.demand_source_delivery)
646: THEN
647: NULL;
648: END IF;
649:
646: THEN
647: NULL;
648: END IF;
649:
650: IF NOT MRP_GLOBALS.Equal(p_flow_schedule_rec.demand_source_header_id,p_old_flow_schedule_rec.demand_source_header_id)
651: THEN
652: NULL;
653: END IF;
654:
651: THEN
652: NULL;
653: END IF;
654:
655: IF NOT MRP_GLOBALS.Equal(p_flow_schedule_rec.demand_source_line,p_old_flow_schedule_rec.demand_source_line)
656: THEN
657: NULL;
658: END IF;
659:
656: THEN
657: NULL;
658: END IF;
659:
660: IF NOT MRP_GLOBALS.Equal(p_flow_schedule_rec.demand_source_type,p_old_flow_schedule_rec.demand_source_type)
661: THEN
662: NULL;
663: END IF;
664:
661: THEN
662: NULL;
663: END IF;
664:
665: IF NOT MRP_GLOBALS.Equal(p_flow_schedule_rec.last_updated_by,p_old_flow_schedule_rec.last_updated_by)
666: THEN
667: NULL;
668: END IF;
669:
666: THEN
667: NULL;
668: END IF;
669:
670: IF NOT MRP_GLOBALS.Equal(p_flow_schedule_rec.last_update_date,p_old_flow_schedule_rec.last_update_date)
671: THEN
672: NULL;
673: END IF;
674:
671: THEN
672: NULL;
673: END IF;
674:
675: IF NOT MRP_GLOBALS.Equal(p_flow_schedule_rec.last_update_login,p_old_flow_schedule_rec.last_update_login)
676: THEN
677: NULL;
678: END IF;
679:
676: THEN
677: NULL;
678: END IF;
679:
680: IF NOT MRP_GLOBALS.Equal(p_flow_schedule_rec.line_id,p_old_flow_schedule_rec.line_id)
681: THEN
682: NULL;
683: END IF;
684:
681: THEN
682: NULL;
683: END IF;
684:
685: IF NOT MRP_GLOBALS.Equal(p_flow_schedule_rec.material_account,p_old_flow_schedule_rec.material_account)
686: THEN
687: NULL;
688: END IF;
689:
686: THEN
687: NULL;
688: END IF;
689:
690: IF NOT MRP_GLOBALS.Equal(p_flow_schedule_rec.material_overhead_account,p_old_flow_schedule_rec.material_overhead_account)
691: THEN
692: NULL;
693: END IF;
694:
691: THEN
692: NULL;
693: END IF;
694:
695: IF NOT MRP_GLOBALS.Equal(p_flow_schedule_rec.material_variance_account,p_old_flow_schedule_rec.material_variance_account)
696: THEN
697: NULL;
698: END IF;
699:
696: THEN
697: NULL;
698: END IF;
699:
700: IF NOT MRP_GLOBALS.Equal(p_flow_schedule_rec.mps_net_quantity,p_old_flow_schedule_rec.mps_net_quantity)
701: THEN
702: NULL;
703: END IF;
704:
701: THEN
702: NULL;
703: END IF;
704:
705: IF NOT MRP_GLOBALS.Equal(p_flow_schedule_rec.mps_scheduled_comp_date,p_old_flow_schedule_rec.mps_scheduled_comp_date)
706: THEN
707: NULL;
708: END IF;
709:
706: THEN
707: NULL;
708: END IF;
709:
710: IF NOT MRP_GLOBALS.Equal(p_flow_schedule_rec.organization_id,p_old_flow_schedule_rec.organization_id)
711: THEN
712: NULL;
713: END IF;
714:
711: THEN
712: NULL;
713: END IF;
714:
715: IF NOT MRP_GLOBALS.Equal(p_flow_schedule_rec.outside_processing_acct,p_old_flow_schedule_rec.outside_processing_acct)
716: THEN
717: NULL;
718: END IF;
719:
716: THEN
717: NULL;
718: END IF;
719:
720: IF NOT MRP_GLOBALS.Equal(p_flow_schedule_rec.outside_proc_var_acct,p_old_flow_schedule_rec.outside_proc_var_acct)
721: THEN
722: NULL;
723: END IF;
724:
721: THEN
722: NULL;
723: END IF;
724:
725: IF NOT MRP_GLOBALS.Equal(p_flow_schedule_rec.overhead_account,p_old_flow_schedule_rec.overhead_account)
726: THEN
727: NULL;
728: END IF;
729:
726: THEN
727: NULL;
728: END IF;
729:
730: IF NOT MRP_GLOBALS.Equal(p_flow_schedule_rec.overhead_variance_account,p_old_flow_schedule_rec.overhead_variance_account)
731: THEN
732: NULL;
733: END IF;
734:
731: THEN
732: NULL;
733: END IF;
734:
735: IF NOT MRP_GLOBALS.Equal(p_flow_schedule_rec.planned_quantity,p_old_flow_schedule_rec.planned_quantity)
736: THEN
737: NULL;
738: END IF;
739:
736: THEN
737: NULL;
738: END IF;
739:
740: IF NOT MRP_GLOBALS.Equal(p_flow_schedule_rec.primary_item_id,p_old_flow_schedule_rec.primary_item_id)
741: THEN
742: /* Fix for bug 3661250. Added the following SQL to update primary_item_id in WIP_ENTITIES if it has been changed.
743: */
744: UPDATE WIP_ENTITIES
748:
749: /* End of fix for bug 3661250 */
750: END IF;
751:
752: IF NOT MRP_GLOBALS.Equal(p_flow_schedule_rec.program_application_id,p_old_flow_schedule_rec.program_application_id)
753: THEN
754: NULL;
755: END IF;
756:
753: THEN
754: NULL;
755: END IF;
756:
757: IF NOT MRP_GLOBALS.Equal(p_flow_schedule_rec.program_id,p_old_flow_schedule_rec.program_id)
758: THEN
759: NULL;
760: END IF;
761:
758: THEN
759: NULL;
760: END IF;
761:
762: IF NOT MRP_GLOBALS.Equal(p_flow_schedule_rec.program_update_date,p_old_flow_schedule_rec.program_update_date)
763: THEN
764: NULL;
765: END IF;
766:
763: THEN
764: NULL;
765: END IF;
766:
767: IF NOT MRP_GLOBALS.Equal(p_flow_schedule_rec.project_id,p_old_flow_schedule_rec.project_id)
768: THEN
769: NULL;
770: END IF;
771:
768: THEN
769: NULL;
770: END IF;
771:
772: IF NOT MRP_GLOBALS.Equal(p_flow_schedule_rec.quantity_completed,p_old_flow_schedule_rec.quantity_completed)
773: THEN
774: NULL;
775: END IF;
776:
773: THEN
774: NULL;
775: END IF;
776:
777: IF NOT MRP_GLOBALS.Equal(p_flow_schedule_rec.request_id,p_old_flow_schedule_rec.request_id)
778: THEN
779: NULL;
780: END IF;
781:
778: THEN
779: NULL;
780: END IF;
781:
782: IF NOT MRP_GLOBALS.Equal(p_flow_schedule_rec.resource_account,p_old_flow_schedule_rec.resource_account)
783: THEN
784: NULL;
785: END IF;
786:
783: THEN
784: NULL;
785: END IF;
786:
787: IF NOT MRP_GLOBALS.Equal(p_flow_schedule_rec.resource_variance_account,p_old_flow_schedule_rec.resource_variance_account)
788: THEN
789: NULL;
790: END IF;
791:
788: THEN
789: NULL;
790: END IF;
791:
792: IF NOT MRP_GLOBALS.Equal(p_flow_schedule_rec.routing_revision,p_old_flow_schedule_rec.routing_revision)
793: THEN
794: NULL;
795: END IF;
796:
793: THEN
794: NULL;
795: END IF;
796:
797: IF NOT MRP_GLOBALS.Equal(p_flow_schedule_rec.routing_revision_date,p_old_flow_schedule_rec.routing_revision_date)
798: THEN
799: NULL;
800: END IF;
801:
798: THEN
799: NULL;
800: END IF;
801:
802: IF NOT MRP_GLOBALS.Equal(p_flow_schedule_rec.scheduled_completion_date,p_old_flow_schedule_rec.scheduled_completion_date)
803: THEN
804: NULL;
805: END IF;
806:
803: THEN
804: NULL;
805: END IF;
806:
807: IF NOT MRP_GLOBALS.Equal(p_flow_schedule_rec.scheduled_flag,p_old_flow_schedule_rec.scheduled_flag)
808: THEN
809: NULL;
810: END IF;
811:
808: THEN
809: NULL;
810: END IF;
811:
812: IF NOT MRP_GLOBALS.Equal(p_flow_schedule_rec.scheduled_start_date,p_old_flow_schedule_rec.scheduled_start_date)
813: THEN
814: NULL;
815: END IF;
816:
813: THEN
814: NULL;
815: END IF;
816:
817: IF NOT MRP_GLOBALS.Equal(p_flow_schedule_rec.schedule_group_id,p_old_flow_schedule_rec.schedule_group_id)
818: THEN
819: NULL;
820: END IF;
821:
818: THEN
819: NULL;
820: END IF;
821:
822: IF NOT MRP_GLOBALS.Equal(p_flow_schedule_rec.schedule_number,p_old_flow_schedule_rec.schedule_number)
823: THEN
824: UPDATE wip_entities
825: SET wip_entity_name = p_flow_schedule_rec.schedule_number
826: WHERE wip_entity_id = p_flow_schedule_rec.wip_entity_id;
825: SET wip_entity_name = p_flow_schedule_rec.schedule_number
826: WHERE wip_entity_id = p_flow_schedule_rec.wip_entity_id;
827: END IF;
828:
829: IF NOT MRP_GLOBALS.Equal(p_flow_schedule_rec.status,p_old_flow_schedule_rec.status)
830: THEN
831: NULL;
832: END IF;
833:
830: THEN
831: NULL;
832: END IF;
833:
834: IF NOT MRP_GLOBALS.Equal(p_flow_schedule_rec.std_cost_adjustment_acct,p_old_flow_schedule_rec.std_cost_adjustment_acct)
835: THEN
836: NULL;
837: END IF;
838:
835: THEN
836: NULL;
837: END IF;
838:
839: IF NOT MRP_GLOBALS.Equal(p_flow_schedule_rec.task_id,p_old_flow_schedule_rec.task_id)
840: THEN
841: NULL;
842: END IF;
843:
840: THEN
841: NULL;
842: END IF;
843:
844: IF NOT MRP_GLOBALS.Equal(p_flow_schedule_rec.wip_entity_id,p_old_flow_schedule_rec.wip_entity_id)
845: THEN
846: NULL;
847: END IF;
848:
2645: BEGIN
2646:
2647: IF p_flow_schedule_rec.completion_locator_id IS NOT NULL AND
2648: p_flow_schedule_rec.completion_locator_id <> FND_API.G_MISS_NUM AND
2649: NOT MRP_GLOBALS.Equal(p_flow_schedule_rec.completion_locator_id,
2650: p_old_flow_schedule_rec.completion_locator_id)
2651: THEN
2652: l_flow_schedule_val_rec.completion_locator := MRP_Id_To_Value.Completion_Locator
2653: ( p_completion_locator_id => p_flow_schedule_rec.completion_locator_id
2655: END IF;
2656:
2657: IF p_flow_schedule_rec.line_id IS NOT NULL AND
2658: p_flow_schedule_rec.line_id <> FND_API.G_MISS_NUM AND
2659: NOT MRP_GLOBALS.Equal(p_flow_schedule_rec.line_id,
2660: p_old_flow_schedule_rec.line_id)
2661: THEN
2662: l_flow_schedule_val_rec.line := MRP_Id_To_Value.Line
2663: ( p_line_id => p_flow_schedule_rec.line_id
2665: END IF;
2666:
2667: IF p_flow_schedule_rec.organization_id IS NOT NULL AND
2668: p_flow_schedule_rec.organization_id <> FND_API.G_MISS_NUM AND
2669: NOT MRP_GLOBALS.Equal(p_flow_schedule_rec.organization_id,
2670: p_old_flow_schedule_rec.organization_id)
2671: THEN
2672: l_flow_schedule_val_rec.organization := MRP_Id_To_Value.Organization
2673: ( p_organization_id => p_flow_schedule_rec.organization_id
2675: END IF;
2676:
2677: IF p_flow_schedule_rec.primary_item_id IS NOT NULL AND
2678: p_flow_schedule_rec.primary_item_id <> FND_API.G_MISS_NUM AND
2679: NOT MRP_GLOBALS.Equal(p_flow_schedule_rec.primary_item_id,
2680: p_old_flow_schedule_rec.primary_item_id)
2681: THEN
2682: l_flow_schedule_val_rec.primary_item := MRP_Id_To_Value.Primary_Item
2683: ( p_primary_item_id => p_flow_schedule_rec.primary_item_id
2685: END IF;
2686:
2687: IF p_flow_schedule_rec.project_id IS NOT NULL AND
2688: p_flow_schedule_rec.project_id <> FND_API.G_MISS_NUM AND
2689: NOT MRP_GLOBALS.Equal(p_flow_schedule_rec.project_id,
2690: p_old_flow_schedule_rec.project_id)
2691: THEN
2692: l_flow_schedule_val_rec.project := MRP_Id_To_Value.Project
2693: ( p_project_id => p_flow_schedule_rec.project_id
2695: END IF;
2696:
2697: IF p_flow_schedule_rec.schedule_group_id IS NOT NULL AND
2698: p_flow_schedule_rec.schedule_group_id <> FND_API.G_MISS_NUM AND
2699: NOT MRP_GLOBALS.Equal(p_flow_schedule_rec.schedule_group_id,
2700: p_old_flow_schedule_rec.schedule_group_id)
2701: THEN
2702: l_flow_schedule_val_rec.schedule_group := MRP_Id_To_Value.Schedule_Group
2703: ( p_schedule_group_id => p_flow_schedule_rec.schedule_group_id
2705: END IF;
2706:
2707: IF p_flow_schedule_rec.task_id IS NOT NULL AND
2708: p_flow_schedule_rec.task_id <> FND_API.G_MISS_NUM AND
2709: NOT MRP_GLOBALS.Equal(p_flow_schedule_rec.task_id,
2710: p_old_flow_schedule_rec.task_id)
2711: THEN
2712: l_flow_schedule_val_rec.task := MRP_Id_To_Value.Task
2713: ( p_task_id => p_flow_schedule_rec.task_id
2715: END IF;
2716:
2717: IF p_flow_schedule_rec.wip_entity_id IS NOT NULL AND
2718: p_flow_schedule_rec.wip_entity_id <> FND_API.G_MISS_NUM AND
2719: NOT MRP_GLOBALS.Equal(p_flow_schedule_rec.wip_entity_id,
2720: p_old_flow_schedule_rec.wip_entity_id)
2721: THEN
2722: l_flow_schedule_val_rec.wip_entity := MRP_Id_To_Value.Wip_Entity
2723: ( p_wip_entity_id => p_flow_schedule_rec.wip_entity_id
3847: l_trans_var6 VARCHAR2(30);
3848:
3849: l_flow_schedule_rec MRP_Flow_Schedule_PVT.Flow_Schedule_PVT_Rec_Type;
3850: l_x_flow_schedule_rec MRP_Flow_Schedule_PVT.Flow_Schedule_PVT_Rec_Type;
3851: l_control_rec MRP_GLOBALS.Control_Rec_Type := MRP_GLOBALS.G_MISS_CONTROL_REC;
3852: l_old_flow_schedule_rec MRP_Flow_Schedule_PVT.Flow_Schedule_PVT_Rec_Type ;
3853:
3854:
3855: l_return_status VARCHAR2(1);
6293: | a new schedule (call private procedure) |
6294: +-------------------------------------------------------*/
6295:
6296: IF l_update_variance > 0 THEN
6297: l_flow_schedule_rec.operation := MRP_GLOBALS.G_OPR_CREATE;
6298: l_flow_schedule_rec.organization_id
6299: := p_organization_id;
6300: l_flow_schedule_rec.schedule_group_id
6301: := fs_report_rec.schedule_group_id;
6702: /*-------------------------------------------------------+
6703: | Since the variance is greater than zero, always create|
6704: | a new schedule (call private procedure) |
6705: +-------------------------------------------------------*/
6706: l_flow_schedule_rec.operation := MRP_GLOBALS.G_OPR_CREATE;
6707: l_flow_schedule_rec.organization_id
6708: := p_organization_id;
6709: l_flow_schedule_rec.schedule_group_id
6710: := fs_report_rec.schedule_group_id;