44:
45: BEGIN
46:
47: IF g_flow_schedule_rec.primary_item_id IS NOT NULL AND
48: g_flow_schedule_rec.primary_item_id <> FND_API.G_MISS_NUM AND
49: g_flow_schedule_rec.organization_id IS NOT NULL AND
50: g_flow_schedule_rec.organization_id <> FND_API.G_MISS_NUM AND
51: g_flow_schedule_rec.line_id IS NOT NULL AND
52: g_flow_schedule_rec.line_id <> FND_API.G_MISS_NUM
46:
47: IF g_flow_schedule_rec.primary_item_id IS NOT NULL AND
48: g_flow_schedule_rec.primary_item_id <> FND_API.G_MISS_NUM AND
49: g_flow_schedule_rec.organization_id IS NOT NULL AND
50: g_flow_schedule_rec.organization_id <> FND_API.G_MISS_NUM AND
51: g_flow_schedule_rec.line_id IS NOT NULL AND
52: g_flow_schedule_rec.line_id <> FND_API.G_MISS_NUM
53: THEN
54:
48: g_flow_schedule_rec.primary_item_id <> FND_API.G_MISS_NUM AND
49: g_flow_schedule_rec.organization_id IS NOT NULL AND
50: g_flow_schedule_rec.organization_id <> FND_API.G_MISS_NUM AND
51: g_flow_schedule_rec.line_id IS NOT NULL AND
52: g_flow_schedule_rec.line_id <> FND_API.G_MISS_NUM
53: THEN
54:
55: OPEN C1(g_flow_schedule_rec.primary_item_id,
56: g_flow_schedule_rec.organization_id,
85: 'Get_Alternate_Routing_Desig'
86: );
87: END IF;
88:
89: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
90:
91: END Get_Alternate_Routing_Desig;
92:
93: FUNCTION Get_Bom_Revision
99: l_revision_date DATE := NULL;
100: BEGIN
101:
102: IF g_flow_schedule_rec.primary_item_id IS NOT NULL AND
103: g_flow_schedule_rec.primary_item_id <> FND_API.G_MISS_NUM AND
104: g_flow_schedule_rec.organization_id IS NOT NULL AND
105: g_flow_schedule_rec.organization_id <> FND_API.G_MISS_NUM AND
106: g_flow_schedule_rec.scheduled_completion_date IS NOT NULL AND
107: g_flow_schedule_rec.scheduled_completion_date <> FND_API.G_MISS_DATE
101:
102: IF g_flow_schedule_rec.primary_item_id IS NOT NULL AND
103: g_flow_schedule_rec.primary_item_id <> FND_API.G_MISS_NUM AND
104: g_flow_schedule_rec.organization_id IS NOT NULL AND
105: g_flow_schedule_rec.organization_id <> FND_API.G_MISS_NUM AND
106: g_flow_schedule_rec.scheduled_completion_date IS NOT NULL AND
107: g_flow_schedule_rec.scheduled_completion_date <> FND_API.G_MISS_DATE
108: THEN
109:
103: g_flow_schedule_rec.primary_item_id <> FND_API.G_MISS_NUM AND
104: g_flow_schedule_rec.organization_id IS NOT NULL AND
105: g_flow_schedule_rec.organization_id <> FND_API.G_MISS_NUM AND
106: g_flow_schedule_rec.scheduled_completion_date IS NOT NULL AND
107: g_flow_schedule_rec.scheduled_completion_date <> FND_API.G_MISS_DATE
108: THEN
109:
110: IF g_flow_schedule_rec.bom_revision_date = FND_API.G_MISS_DATE THEN
111: l_revision_date := NULL;
106: g_flow_schedule_rec.scheduled_completion_date IS NOT NULL AND
107: g_flow_schedule_rec.scheduled_completion_date <> FND_API.G_MISS_DATE
108: THEN
109:
110: IF g_flow_schedule_rec.bom_revision_date = FND_API.G_MISS_DATE THEN
111: l_revision_date := NULL;
112: ELSE
113: l_revision_date := g_flow_schedule_rec.bom_revision_date;
114: END IF;
151: l_revision_date DATE := NULL;
152: BEGIN
153:
154: IF g_flow_schedule_rec.primary_item_id IS NOT NULL AND
155: g_flow_schedule_rec.primary_item_id <> FND_API.G_MISS_NUM AND
156: g_flow_schedule_rec.organization_id IS NOT NULL AND
157: g_flow_schedule_rec.organization_id <> FND_API.G_MISS_NUM AND
158: g_flow_schedule_rec.scheduled_completion_date IS NOT NULL AND
159: g_flow_schedule_rec.scheduled_completion_date <> FND_API.G_MISS_DATE
153:
154: IF g_flow_schedule_rec.primary_item_id IS NOT NULL AND
155: g_flow_schedule_rec.primary_item_id <> FND_API.G_MISS_NUM AND
156: g_flow_schedule_rec.organization_id IS NOT NULL AND
157: g_flow_schedule_rec.organization_id <> FND_API.G_MISS_NUM AND
158: g_flow_schedule_rec.scheduled_completion_date IS NOT NULL AND
159: g_flow_schedule_rec.scheduled_completion_date <> FND_API.G_MISS_DATE
160: THEN
161:
155: g_flow_schedule_rec.primary_item_id <> FND_API.G_MISS_NUM AND
156: g_flow_schedule_rec.organization_id IS NOT NULL AND
157: g_flow_schedule_rec.organization_id <> FND_API.G_MISS_NUM AND
158: g_flow_schedule_rec.scheduled_completion_date IS NOT NULL AND
159: g_flow_schedule_rec.scheduled_completion_date <> FND_API.G_MISS_DATE
160: THEN
161:
162: /* Fix for bug 2977987: Initialized l_revision_date instead of
163: l_bom_revision so that scheduled_completion_date is returned
162: /* Fix for bug 2977987: Initialized l_revision_date instead of
163: l_bom_revision so that scheduled_completion_date is returned
164: instead of sysdate */
165:
166: IF g_flow_schedule_rec.bom_revision_date = FND_API.G_MISS_DATE THEN
167: l_revision_date := NULL;
168: ELSE
169: l_revision_date := g_flow_schedule_rec.bom_revision_date;
170: END IF;
222: -- Use wip procedure to get class code. Class code is dependent
223: -- on item, organization, and project.
224:
225: IF g_flow_schedule_rec.primary_item_id IS NOT NULL AND
226: g_flow_schedule_rec.primary_item_id <> FND_API.G_MISS_NUM AND
227: g_flow_schedule_rec.organization_id IS NOT NULL AND
228: g_flow_schedule_rec.organization_id <> FND_API.G_MISS_NUM
229: THEN
230:
224:
225: IF g_flow_schedule_rec.primary_item_id IS NOT NULL AND
226: g_flow_schedule_rec.primary_item_id <> FND_API.G_MISS_NUM AND
227: g_flow_schedule_rec.organization_id IS NOT NULL AND
228: g_flow_schedule_rec.organization_id <> FND_API.G_MISS_NUM
229: THEN
230:
231: IF g_flow_schedule_rec.project_id = FND_API.G_MISS_NUM THEN
232: l_project_id := NULL;
227: g_flow_schedule_rec.organization_id IS NOT NULL AND
228: g_flow_schedule_rec.organization_id <> FND_API.G_MISS_NUM
229: THEN
230:
231: IF g_flow_schedule_rec.project_id = FND_API.G_MISS_NUM THEN
232: l_project_id := NULL;
233: ELSE
234: l_project_id := g_flow_schedule_rec.project_id;
235: END IF;
255: FND_MESSAGE.SET_NAME('MRP','MRP_NO_PROJ_CLASS_CODE');
256: FND_MESSAGE.SET_TOKEN('PROJECT',l_project_name);
257: FND_MSG_PUB.Add;
258:
259: RAISE FND_API.G_EXC_ERROR;
260:
261: END IF;
262:
263: END;
299: FND_MSG_PUB.Add;
300:
301: END IF;
302:
303: RAISE FND_API.G_EXC_ERROR;
304:
305: WHEN OTHERS THEN
306:
307: -- l_err_mesg is not used because class code procedure
314: 'Get_Class: '||l_err_mesg
315: );
316: END IF;
317:
318: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
319:
320: END;
321:
322: END IF;
338: l_error_number NUMBER := 1;
339: BEGIN
340:
341: IF g_flow_schedule_rec.primary_item_id IS NOT NULL AND
342: g_flow_schedule_rec.primary_item_id <> FND_API.G_MISS_NUM AND
343: g_flow_schedule_rec.organization_id IS NOT NULL AND
344: g_flow_schedule_rec.organization_id <> FND_API.G_MISS_NUM
345: THEN
346:
340:
341: IF g_flow_schedule_rec.primary_item_id IS NOT NULL AND
342: g_flow_schedule_rec.primary_item_id <> FND_API.G_MISS_NUM AND
343: g_flow_schedule_rec.organization_id IS NOT NULL AND
344: g_flow_schedule_rec.organization_id <> FND_API.G_MISS_NUM
345: THEN
346:
347: IF g_flow_schedule_rec.alternate_routing_desig = FND_API.G_MISS_CHAR
348: THEN
343: g_flow_schedule_rec.organization_id IS NOT NULL AND
344: g_flow_schedule_rec.organization_id <> FND_API.G_MISS_NUM
345: THEN
346:
347: IF g_flow_schedule_rec.alternate_routing_desig = FND_API.G_MISS_CHAR
348: THEN
349: l_alt_routing := NULL;
350: ELSE
351: l_alt_routing := g_flow_schedule_rec.alternate_routing_desig;
372: 'Get_Completion_Locator'
373: );
374: END IF;
375:
376: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
377:
378: END IF;
379:
380: ELSE
394: l_error_number NUMBER := 1;
395: BEGIN
396:
397: IF g_flow_schedule_rec.primary_item_id IS NOT NULL AND
398: g_flow_schedule_rec.primary_item_id <> FND_API.G_MISS_NUM AND
399: g_flow_schedule_rec.organization_id IS NOT NULL AND
400: g_flow_schedule_rec.organization_id <> FND_API.G_MISS_NUM
401: THEN
402:
396:
397: IF g_flow_schedule_rec.primary_item_id IS NOT NULL AND
398: g_flow_schedule_rec.primary_item_id <> FND_API.G_MISS_NUM AND
399: g_flow_schedule_rec.organization_id IS NOT NULL AND
400: g_flow_schedule_rec.organization_id <> FND_API.G_MISS_NUM
401: THEN
402:
403: IF g_flow_schedule_rec.alternate_routing_desig = FND_API.G_MISS_CHAR
404: THEN
399: g_flow_schedule_rec.organization_id IS NOT NULL AND
400: g_flow_schedule_rec.organization_id <> FND_API.G_MISS_NUM
401: THEN
402:
403: IF g_flow_schedule_rec.alternate_routing_desig = FND_API.G_MISS_CHAR
404: THEN
405: l_alt_routing := NULL;
406: ELSE
407: l_alt_routing := g_flow_schedule_rec.alternate_routing_desig;
428: 'Get_Completion_Subinventory'
429: );
430: END IF;
431:
432: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
433:
434: END IF;
435:
436: ELSE
501: l_line_id NUMBER;
502: BEGIN
503:
504: IF g_flow_schedule_rec.primary_item_id IS NOT NULL AND
505: g_flow_schedule_rec.primary_item_id <> FND_API.G_MISS_NUM AND
506: g_flow_schedule_rec.organization_id IS NOT NULL AND
507: g_flow_schedule_rec.organization_id <> FND_API.G_MISS_NUM
508: THEN
509: SELECT line_id
503:
504: IF g_flow_schedule_rec.primary_item_id IS NOT NULL AND
505: g_flow_schedule_rec.primary_item_id <> FND_API.G_MISS_NUM AND
506: g_flow_schedule_rec.organization_id IS NOT NULL AND
507: g_flow_schedule_rec.organization_id <> FND_API.G_MISS_NUM
508: THEN
509: SELECT line_id
510: INTO l_line_id
511: FROM bom_operational_routings
548: l_material_account NUMBER := NULL;
549: BEGIN
550:
551: IF g_flow_schedule_rec.class_code IS NOT NULL AND
552: g_flow_schedule_rec.class_code <> FND_API.G_MISS_CHAR AND
553: g_flow_schedule_rec.organization_id IS NOT NULL AND
554: g_flow_schedule_rec.organization_id <> FND_API.G_MISS_NUM
555: THEN
556:
550:
551: IF g_flow_schedule_rec.class_code IS NOT NULL AND
552: g_flow_schedule_rec.class_code <> FND_API.G_MISS_CHAR AND
553: g_flow_schedule_rec.organization_id IS NOT NULL AND
554: g_flow_schedule_rec.organization_id <> FND_API.G_MISS_NUM
555: THEN
556:
557: SELECT MATERIAL_ACCOUNT
558: INTO l_material_account
579: 'Get_Material_Account'
580: );
581: END IF;
582:
583: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
584:
585: END Get_Material_Account;
586:
587: FUNCTION Get_Material_Overhead_Account
590: l_material_overhead_account NUMBER := NULL;
591: BEGIN
592:
593: IF g_flow_schedule_rec.class_code IS NOT NULL AND
594: g_flow_schedule_rec.class_code <> FND_API.G_MISS_CHAR AND
595: g_flow_schedule_rec.organization_id IS NOT NULL AND
596: g_flow_schedule_rec.organization_id <> FND_API.G_MISS_NUM
597: THEN
598:
592:
593: IF g_flow_schedule_rec.class_code IS NOT NULL AND
594: g_flow_schedule_rec.class_code <> FND_API.G_MISS_CHAR AND
595: g_flow_schedule_rec.organization_id IS NOT NULL AND
596: g_flow_schedule_rec.organization_id <> FND_API.G_MISS_NUM
597: THEN
598:
599: SELECT MATERIAL_OVERHEAD_ACCOUNT
600: INTO l_material_overhead_account
621: 'Get_Material_Overhead_Account'
622: );
623: END IF;
624:
625: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
626:
627: END Get_Material_Overhead_Account;
628:
629: FUNCTION Get_Material_Variance_Account
632: l_material_variance_account NUMBER := NULL;
633: BEGIN
634:
635: IF g_flow_schedule_rec.class_code IS NOT NULL AND
636: g_flow_schedule_rec.class_code <> FND_API.G_MISS_CHAR AND
637: g_flow_schedule_rec.organization_id IS NOT NULL AND
638: g_flow_schedule_rec.organization_id <> FND_API.G_MISS_NUM
639: THEN
640:
634:
635: IF g_flow_schedule_rec.class_code IS NOT NULL AND
636: g_flow_schedule_rec.class_code <> FND_API.G_MISS_CHAR AND
637: g_flow_schedule_rec.organization_id IS NOT NULL AND
638: g_flow_schedule_rec.organization_id <> FND_API.G_MISS_NUM
639: THEN
640:
641: SELECT MATERIAL_VARIANCE_ACCOUNT
642: INTO l_material_variance_account
663: 'Get_Material_Variance_Account'
664: );
665: END IF;
666:
667: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
668:
669: END Get_Material_Variance_Account;
670:
671: FUNCTION Get_Mps_Net_Quantity
701: l_outside_processing_acct NUMBER := NULL;
702: BEGIN
703:
704: IF g_flow_schedule_rec.class_code IS NOT NULL AND
705: g_flow_schedule_rec.class_code <> FND_API.G_MISS_CHAR AND
706: g_flow_schedule_rec.organization_id IS NOT NULL AND
707: g_flow_schedule_rec.organization_id <> FND_API.G_MISS_NUM
708: THEN
709:
703:
704: IF g_flow_schedule_rec.class_code IS NOT NULL AND
705: g_flow_schedule_rec.class_code <> FND_API.G_MISS_CHAR AND
706: g_flow_schedule_rec.organization_id IS NOT NULL AND
707: g_flow_schedule_rec.organization_id <> FND_API.G_MISS_NUM
708: THEN
709:
710: SELECT OUTSIDE_PROCESSING_ACCOUNT
711: INTO l_outside_processing_acct
732: 'Get_Outside_Processing_Acct'
733: );
734: END IF;
735:
736: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
737:
738: END Get_Outside_Processing_Acct;
739:
740: FUNCTION Get_Outside_Proc_Var_Acct
743: l_outside_proc_var_acct NUMBER := NULL;
744: BEGIN
745:
746: IF g_flow_schedule_rec.class_code IS NOT NULL AND
747: g_flow_schedule_rec.class_code <> FND_API.G_MISS_CHAR AND
748: g_flow_schedule_rec.organization_id IS NOT NULL AND
749: g_flow_schedule_rec.organization_id <> FND_API.G_MISS_NUM
750: THEN
751:
745:
746: IF g_flow_schedule_rec.class_code IS NOT NULL AND
747: g_flow_schedule_rec.class_code <> FND_API.G_MISS_CHAR AND
748: g_flow_schedule_rec.organization_id IS NOT NULL AND
749: g_flow_schedule_rec.organization_id <> FND_API.G_MISS_NUM
750: THEN
751:
752: SELECT OUTSIDE_PROC_VARIANCE_ACCOUNT
753: INTO l_outside_proc_var_acct
774: 'Get_Outside_Proc_Var_Acct'
775: );
776: END IF;
777:
778: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
779:
780: END Get_Outside_Proc_Var_Acct;
781:
782: FUNCTION Get_Overhead_Account
785: l_overhead_account NUMBER := NULL;
786: BEGIN
787:
788: IF g_flow_schedule_rec.class_code IS NOT NULL AND
789: g_flow_schedule_rec.class_code <> FND_API.G_MISS_CHAR AND
790: g_flow_schedule_rec.organization_id IS NOT NULL AND
791: g_flow_schedule_rec.organization_id <> FND_API.G_MISS_NUM
792: THEN
793:
787:
788: IF g_flow_schedule_rec.class_code IS NOT NULL AND
789: g_flow_schedule_rec.class_code <> FND_API.G_MISS_CHAR AND
790: g_flow_schedule_rec.organization_id IS NOT NULL AND
791: g_flow_schedule_rec.organization_id <> FND_API.G_MISS_NUM
792: THEN
793:
794: SELECT OVERHEAD_ACCOUNT
795: INTO l_overhead_account
816: 'Get_Overhead_Account'
817: );
818: END IF;
819:
820: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
821:
822: END Get_Overhead_Account;
823:
824: FUNCTION Get_Overhead_Variance_Account
827: l_overhead_variance_account NUMBER := NULL;
828: BEGIN
829:
830: IF g_flow_schedule_rec.class_code IS NOT NULL AND
831: g_flow_schedule_rec.class_code <> FND_API.G_MISS_CHAR AND
832: g_flow_schedule_rec.organization_id IS NOT NULL AND
833: g_flow_schedule_rec.organization_id <> FND_API.G_MISS_NUM
834: THEN
835:
829:
830: IF g_flow_schedule_rec.class_code IS NOT NULL AND
831: g_flow_schedule_rec.class_code <> FND_API.G_MISS_CHAR AND
832: g_flow_schedule_rec.organization_id IS NOT NULL AND
833: g_flow_schedule_rec.organization_id <> FND_API.G_MISS_NUM
834: THEN
835:
836: SELECT OVERHEAD_VARIANCE_ACCOUNT
837: INTO l_overhead_variance_account
858: 'Get_Overhead_Variance_Account'
859: );
860: END IF;
861:
862: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
863:
864: END Get_Overhead_Variance_Account;
865:
866: FUNCTION Get_Planned_Quantity
919: l_resource_account NUMBER := NULL;
920: BEGIN
921:
922: IF g_flow_schedule_rec.class_code IS NOT NULL AND
923: g_flow_schedule_rec.class_code <> FND_API.G_MISS_CHAR AND
924: g_flow_schedule_rec.organization_id IS NOT NULL AND
925: g_flow_schedule_rec.organization_id <> FND_API.G_MISS_NUM
926: THEN
927:
921:
922: IF g_flow_schedule_rec.class_code IS NOT NULL AND
923: g_flow_schedule_rec.class_code <> FND_API.G_MISS_CHAR AND
924: g_flow_schedule_rec.organization_id IS NOT NULL AND
925: g_flow_schedule_rec.organization_id <> FND_API.G_MISS_NUM
926: THEN
927:
928: SELECT RESOURCE_ACCOUNT
929: INTO l_resource_account
950: 'Get_Resource_Account'
951: );
952: END IF;
953:
954: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
955:
956: END Get_Resource_Account;
957:
958: FUNCTION Get_Resource_Variance_Account
961: l_resource_variance_account NUMBER := NULL;
962: BEGIN
963:
964: IF g_flow_schedule_rec.class_code IS NOT NULL AND
965: g_flow_schedule_rec.class_code <> FND_API.G_MISS_CHAR AND
966: g_flow_schedule_rec.organization_id IS NOT NULL AND
967: g_flow_schedule_rec.organization_id <> FND_API.G_MISS_NUM
968: THEN
969:
963:
964: IF g_flow_schedule_rec.class_code IS NOT NULL AND
965: g_flow_schedule_rec.class_code <> FND_API.G_MISS_CHAR AND
966: g_flow_schedule_rec.organization_id IS NOT NULL AND
967: g_flow_schedule_rec.organization_id <> FND_API.G_MISS_NUM
968: THEN
969:
970: SELECT RESOURCE_VARIANCE_ACCOUNT
971: INTO l_resource_variance_account
992: 'Get_Resource_Variance_Account'
993: );
994: END IF;
995:
996: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
997:
998: END Get_Resource_Variance_Account;
999:
1000: FUNCTION Get_Routing_Revision
1005: l_revision_date DATE := NULL;
1006: BEGIN
1007:
1008: IF g_flow_schedule_rec.primary_item_id IS NOT NULL AND
1009: g_flow_schedule_rec.primary_item_id <> FND_API.G_MISS_NUM AND
1010: g_flow_schedule_rec.organization_id IS NOT NULL AND
1011: g_flow_schedule_rec.organization_id <> FND_API.G_MISS_NUM AND
1012: g_flow_schedule_rec.scheduled_completion_date IS NOT NULL AND
1013: g_flow_schedule_rec.scheduled_completion_date <> FND_API.G_MISS_DATE
1007:
1008: IF g_flow_schedule_rec.primary_item_id IS NOT NULL AND
1009: g_flow_schedule_rec.primary_item_id <> FND_API.G_MISS_NUM AND
1010: g_flow_schedule_rec.organization_id IS NOT NULL AND
1011: g_flow_schedule_rec.organization_id <> FND_API.G_MISS_NUM AND
1012: g_flow_schedule_rec.scheduled_completion_date IS NOT NULL AND
1013: g_flow_schedule_rec.scheduled_completion_date <> FND_API.G_MISS_DATE
1014: THEN
1015:
1009: g_flow_schedule_rec.primary_item_id <> FND_API.G_MISS_NUM AND
1010: g_flow_schedule_rec.organization_id IS NOT NULL AND
1011: g_flow_schedule_rec.organization_id <> FND_API.G_MISS_NUM AND
1012: g_flow_schedule_rec.scheduled_completion_date IS NOT NULL AND
1013: g_flow_schedule_rec.scheduled_completion_date <> FND_API.G_MISS_DATE
1014: THEN
1015:
1016: IF g_flow_schedule_rec.routing_revision_date = FND_API.G_MISS_DATE THEN
1017: l_revision_date := NULL;
1012: g_flow_schedule_rec.scheduled_completion_date IS NOT NULL AND
1013: g_flow_schedule_rec.scheduled_completion_date <> FND_API.G_MISS_DATE
1014: THEN
1015:
1016: IF g_flow_schedule_rec.routing_revision_date = FND_API.G_MISS_DATE THEN
1017: l_revision_date := NULL;
1018: ELSE
1019: l_revision_date := g_flow_schedule_rec.routing_revision_date;
1020: END IF;
1054: l_revision_date DATE := NULL;
1055: BEGIN
1056:
1057: IF g_flow_schedule_rec.primary_item_id IS NOT NULL AND
1058: g_flow_schedule_rec.primary_item_id <> FND_API.G_MISS_NUM AND
1059: g_flow_schedule_rec.organization_id IS NOT NULL AND
1060: g_flow_schedule_rec.organization_id <> FND_API.G_MISS_NUM AND
1061: g_flow_schedule_rec.scheduled_completion_date IS NOT NULL AND
1062: g_flow_schedule_rec.scheduled_completion_date <> FND_API.G_MISS_DATE
1056:
1057: IF g_flow_schedule_rec.primary_item_id IS NOT NULL AND
1058: g_flow_schedule_rec.primary_item_id <> FND_API.G_MISS_NUM AND
1059: g_flow_schedule_rec.organization_id IS NOT NULL AND
1060: g_flow_schedule_rec.organization_id <> FND_API.G_MISS_NUM AND
1061: g_flow_schedule_rec.scheduled_completion_date IS NOT NULL AND
1062: g_flow_schedule_rec.scheduled_completion_date <> FND_API.G_MISS_DATE
1063: THEN
1064:
1058: g_flow_schedule_rec.primary_item_id <> FND_API.G_MISS_NUM AND
1059: g_flow_schedule_rec.organization_id IS NOT NULL AND
1060: g_flow_schedule_rec.organization_id <> FND_API.G_MISS_NUM AND
1061: g_flow_schedule_rec.scheduled_completion_date IS NOT NULL AND
1062: g_flow_schedule_rec.scheduled_completion_date <> FND_API.G_MISS_DATE
1063: THEN
1064:
1065: IF g_flow_schedule_rec.routing_revision_date = FND_API.G_MISS_DATE THEN
1066: l_revision_date := NULL;
1061: g_flow_schedule_rec.scheduled_completion_date IS NOT NULL AND
1062: g_flow_schedule_rec.scheduled_completion_date <> FND_API.G_MISS_DATE
1063: THEN
1064:
1065: IF g_flow_schedule_rec.routing_revision_date = FND_API.G_MISS_DATE THEN
1066: l_revision_date := NULL;
1067: ELSE
1068: l_revision_date := g_flow_schedule_rec.routing_revision_date;
1069: END IF;
1130:
1131: BEGIN
1132:
1133: IF g_flow_schedule_rec.scheduled_completion_date IS NOT NULL AND
1134: g_flow_schedule_rec.scheduled_completion_date <> FND_API.G_MISS_DATE AND
1135: g_flow_schedule_rec.organization_id IS NOT NULL AND
1136: g_flow_schedule_rec.organization_id <> FND_API.G_MISS_NUM AND
1137: g_flow_schedule_rec.primary_item_id IS NOT NULL AND
1138: g_flow_schedule_rec.primary_item_id <> FND_API.G_MISS_NUM AND
1132:
1133: IF g_flow_schedule_rec.scheduled_completion_date IS NOT NULL AND
1134: g_flow_schedule_rec.scheduled_completion_date <> FND_API.G_MISS_DATE AND
1135: g_flow_schedule_rec.organization_id IS NOT NULL AND
1136: g_flow_schedule_rec.organization_id <> FND_API.G_MISS_NUM AND
1137: g_flow_schedule_rec.primary_item_id IS NOT NULL AND
1138: g_flow_schedule_rec.primary_item_id <> FND_API.G_MISS_NUM AND
1139: g_flow_schedule_rec.planned_quantity IS NOT NULL AND
1140: g_flow_schedule_rec.planned_quantity <> FND_API.G_MISS_NUM AND
1134: g_flow_schedule_rec.scheduled_completion_date <> FND_API.G_MISS_DATE AND
1135: g_flow_schedule_rec.organization_id IS NOT NULL AND
1136: g_flow_schedule_rec.organization_id <> FND_API.G_MISS_NUM AND
1137: g_flow_schedule_rec.primary_item_id IS NOT NULL AND
1138: g_flow_schedule_rec.primary_item_id <> FND_API.G_MISS_NUM AND
1139: g_flow_schedule_rec.planned_quantity IS NOT NULL AND
1140: g_flow_schedule_rec.planned_quantity <> FND_API.G_MISS_NUM AND
1141: g_flow_schedule_rec.line_id IS NOT NULL AND
1142: g_flow_schedule_rec.line_id <> FND_API.G_MISS_NUM
1136: g_flow_schedule_rec.organization_id <> FND_API.G_MISS_NUM AND
1137: g_flow_schedule_rec.primary_item_id IS NOT NULL AND
1138: g_flow_schedule_rec.primary_item_id <> FND_API.G_MISS_NUM AND
1139: g_flow_schedule_rec.planned_quantity IS NOT NULL AND
1140: g_flow_schedule_rec.planned_quantity <> FND_API.G_MISS_NUM AND
1141: g_flow_schedule_rec.line_id IS NOT NULL AND
1142: g_flow_schedule_rec.line_id <> FND_API.G_MISS_NUM
1143: THEN
1144:
1138: g_flow_schedule_rec.primary_item_id <> FND_API.G_MISS_NUM AND
1139: g_flow_schedule_rec.planned_quantity IS NOT NULL AND
1140: g_flow_schedule_rec.planned_quantity <> FND_API.G_MISS_NUM AND
1141: g_flow_schedule_rec.line_id IS NOT NULL AND
1142: g_flow_schedule_rec.line_id <> FND_API.G_MISS_NUM
1143: THEN
1144:
1145: SELECT NVL(FIXED_LEAD_TIME,0),
1146: NVL(VARIABLE_LEAD_TIME,0)
1212: 'Get_Scheduled_Start_Date'
1213: );
1214: END IF;
1215:
1216: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1217:
1218: END Get_Scheduled_Start_Date;
1219:
1220: FUNCTION Get_Schedule_Group
1248: 'Get_Schedule_Number'
1249: );
1250: END IF;
1251:
1252: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1253:
1254: RETURN NULL;
1255:
1256: END IF;
1273: l_std_cost_adjustment_acct NUMBER := NULL;
1274: BEGIN
1275:
1276: IF g_flow_schedule_rec.class_code IS NOT NULL AND
1277: g_flow_schedule_rec.class_code <> FND_API.G_MISS_CHAR AND
1278: g_flow_schedule_rec.organization_id IS NOT NULL AND
1279: g_flow_schedule_rec.organization_id <> FND_API.G_MISS_NUM
1280: THEN
1281:
1275:
1276: IF g_flow_schedule_rec.class_code IS NOT NULL AND
1277: g_flow_schedule_rec.class_code <> FND_API.G_MISS_CHAR AND
1278: g_flow_schedule_rec.organization_id IS NOT NULL AND
1279: g_flow_schedule_rec.organization_id <> FND_API.G_MISS_NUM
1280: THEN
1281:
1282: SELECT STD_COST_ADJUSTMENT_ACCOUNT
1283: INTO l_std_cost_adjustment_acct
1304: 'Get_Std_Cost_Adjustment_Acct'
1305: );
1306: END IF;
1307:
1308: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1309:
1310: END Get_Std_Cost_Adjustment_Acct;
1311:
1312: FUNCTION Get_Task
1342: 'Get_Wip_Entity'
1343: );
1344: END IF;
1345:
1346: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1347:
1348: END Get_Wip_Entity;
1349:
1350:
1371: BEGIN
1372:
1373: -- In the future call Flex APIs for defaults
1374:
1375: IF g_flow_schedule_rec.attribute1 = FND_API.G_MISS_CHAR THEN
1376: g_flow_schedule_rec.attribute1 := NULL;
1377: END IF;
1378:
1379: IF g_flow_schedule_rec.attribute10 = FND_API.G_MISS_CHAR THEN
1375: IF g_flow_schedule_rec.attribute1 = FND_API.G_MISS_CHAR THEN
1376: g_flow_schedule_rec.attribute1 := NULL;
1377: END IF;
1378:
1379: IF g_flow_schedule_rec.attribute10 = FND_API.G_MISS_CHAR THEN
1380: g_flow_schedule_rec.attribute10 := NULL;
1381: END IF;
1382:
1383: IF g_flow_schedule_rec.attribute11 = FND_API.G_MISS_CHAR THEN
1379: IF g_flow_schedule_rec.attribute10 = FND_API.G_MISS_CHAR THEN
1380: g_flow_schedule_rec.attribute10 := NULL;
1381: END IF;
1382:
1383: IF g_flow_schedule_rec.attribute11 = FND_API.G_MISS_CHAR THEN
1384: g_flow_schedule_rec.attribute11 := NULL;
1385: END IF;
1386:
1387: IF g_flow_schedule_rec.attribute12 = FND_API.G_MISS_CHAR THEN
1383: IF g_flow_schedule_rec.attribute11 = FND_API.G_MISS_CHAR THEN
1384: g_flow_schedule_rec.attribute11 := NULL;
1385: END IF;
1386:
1387: IF g_flow_schedule_rec.attribute12 = FND_API.G_MISS_CHAR THEN
1388: g_flow_schedule_rec.attribute12 := NULL;
1389: END IF;
1390:
1391: IF g_flow_schedule_rec.attribute13 = FND_API.G_MISS_CHAR THEN
1387: IF g_flow_schedule_rec.attribute12 = FND_API.G_MISS_CHAR THEN
1388: g_flow_schedule_rec.attribute12 := NULL;
1389: END IF;
1390:
1391: IF g_flow_schedule_rec.attribute13 = FND_API.G_MISS_CHAR THEN
1392: g_flow_schedule_rec.attribute13 := NULL;
1393: END IF;
1394:
1395: IF g_flow_schedule_rec.attribute14 = FND_API.G_MISS_CHAR THEN
1391: IF g_flow_schedule_rec.attribute13 = FND_API.G_MISS_CHAR THEN
1392: g_flow_schedule_rec.attribute13 := NULL;
1393: END IF;
1394:
1395: IF g_flow_schedule_rec.attribute14 = FND_API.G_MISS_CHAR THEN
1396: g_flow_schedule_rec.attribute14 := NULL;
1397: END IF;
1398:
1399: IF g_flow_schedule_rec.attribute15 = FND_API.G_MISS_CHAR THEN
1395: IF g_flow_schedule_rec.attribute14 = FND_API.G_MISS_CHAR THEN
1396: g_flow_schedule_rec.attribute14 := NULL;
1397: END IF;
1398:
1399: IF g_flow_schedule_rec.attribute15 = FND_API.G_MISS_CHAR THEN
1400: g_flow_schedule_rec.attribute15 := NULL;
1401: END IF;
1402:
1403: IF g_flow_schedule_rec.attribute2 = FND_API.G_MISS_CHAR THEN
1399: IF g_flow_schedule_rec.attribute15 = FND_API.G_MISS_CHAR THEN
1400: g_flow_schedule_rec.attribute15 := NULL;
1401: END IF;
1402:
1403: IF g_flow_schedule_rec.attribute2 = FND_API.G_MISS_CHAR THEN
1404: g_flow_schedule_rec.attribute2 := NULL;
1405: END IF;
1406:
1407: IF g_flow_schedule_rec.attribute3 = FND_API.G_MISS_CHAR THEN
1403: IF g_flow_schedule_rec.attribute2 = FND_API.G_MISS_CHAR THEN
1404: g_flow_schedule_rec.attribute2 := NULL;
1405: END IF;
1406:
1407: IF g_flow_schedule_rec.attribute3 = FND_API.G_MISS_CHAR THEN
1408: g_flow_schedule_rec.attribute3 := NULL;
1409: END IF;
1410:
1411: IF g_flow_schedule_rec.attribute4 = FND_API.G_MISS_CHAR THEN
1407: IF g_flow_schedule_rec.attribute3 = FND_API.G_MISS_CHAR THEN
1408: g_flow_schedule_rec.attribute3 := NULL;
1409: END IF;
1410:
1411: IF g_flow_schedule_rec.attribute4 = FND_API.G_MISS_CHAR THEN
1412: g_flow_schedule_rec.attribute4 := NULL;
1413: END IF;
1414:
1415: IF g_flow_schedule_rec.attribute5 = FND_API.G_MISS_CHAR THEN
1411: IF g_flow_schedule_rec.attribute4 = FND_API.G_MISS_CHAR THEN
1412: g_flow_schedule_rec.attribute4 := NULL;
1413: END IF;
1414:
1415: IF g_flow_schedule_rec.attribute5 = FND_API.G_MISS_CHAR THEN
1416: g_flow_schedule_rec.attribute5 := NULL;
1417: END IF;
1418:
1419: IF g_flow_schedule_rec.attribute6 = FND_API.G_MISS_CHAR THEN
1415: IF g_flow_schedule_rec.attribute5 = FND_API.G_MISS_CHAR THEN
1416: g_flow_schedule_rec.attribute5 := NULL;
1417: END IF;
1418:
1419: IF g_flow_schedule_rec.attribute6 = FND_API.G_MISS_CHAR THEN
1420: g_flow_schedule_rec.attribute6 := NULL;
1421: END IF;
1422:
1423: IF g_flow_schedule_rec.attribute7 = FND_API.G_MISS_CHAR THEN
1419: IF g_flow_schedule_rec.attribute6 = FND_API.G_MISS_CHAR THEN
1420: g_flow_schedule_rec.attribute6 := NULL;
1421: END IF;
1422:
1423: IF g_flow_schedule_rec.attribute7 = FND_API.G_MISS_CHAR THEN
1424: g_flow_schedule_rec.attribute7 := NULL;
1425: END IF;
1426:
1427: IF g_flow_schedule_rec.attribute8 = FND_API.G_MISS_CHAR THEN
1423: IF g_flow_schedule_rec.attribute7 = FND_API.G_MISS_CHAR THEN
1424: g_flow_schedule_rec.attribute7 := NULL;
1425: END IF;
1426:
1427: IF g_flow_schedule_rec.attribute8 = FND_API.G_MISS_CHAR THEN
1428: g_flow_schedule_rec.attribute8 := NULL;
1429: END IF;
1430:
1431: IF g_flow_schedule_rec.attribute9 = FND_API.G_MISS_CHAR THEN
1427: IF g_flow_schedule_rec.attribute8 = FND_API.G_MISS_CHAR THEN
1428: g_flow_schedule_rec.attribute8 := NULL;
1429: END IF;
1430:
1431: IF g_flow_schedule_rec.attribute9 = FND_API.G_MISS_CHAR THEN
1432: g_flow_schedule_rec.attribute9 := NULL;
1433: END IF;
1434:
1435: IF g_flow_schedule_rec.attribute_category = FND_API.G_MISS_CHAR THEN
1431: IF g_flow_schedule_rec.attribute9 = FND_API.G_MISS_CHAR THEN
1432: g_flow_schedule_rec.attribute9 := NULL;
1433: END IF;
1434:
1435: IF g_flow_schedule_rec.attribute_category = FND_API.G_MISS_CHAR THEN
1436: g_flow_schedule_rec.attribute_category := NULL;
1437: END IF;
1438:
1439: END Get_Flex_Wip_Flow_Schedule;
1460: FND_MSG_PUB.Add;
1461:
1462: END IF;
1463:
1464: RAISE FND_API.G_EXC_ERROR;
1465:
1466: END IF;
1467: -- Initialize g_flow_schedule_rec
1468:
1469: g_flow_schedule_rec := p_flow_schedule_rec;
1470:
1471: -- Default missing attributes.
1472:
1473: IF g_flow_schedule_rec.alternate_bom_designator = FND_API.G_MISS_CHAR or g_flow_schedule_rec.alternate_bom_designator IS NULL THEN
1474:
1475: g_flow_schedule_rec.alternate_bom_designator := Get_Alternate_Bom_Designator;
1476:
1477: IF g_flow_schedule_rec.alternate_bom_designator IS NOT NULL THEN
1491: END IF;
1492:
1493: END IF;
1494:
1495: IF g_flow_schedule_rec.alternate_routing_desig = FND_API.G_MISS_CHAR or g_flow_schedule_rec.alternate_routing_desig IS NULL THEN
1496:
1497: g_flow_schedule_rec.alternate_routing_desig := Get_Alternate_Routing_Desig;
1498:
1499: IF g_flow_schedule_rec.alternate_routing_desig IS NOT NULL THEN
1516:
1517: /* Fix for bug 2977987: Moved this code to ensure that bom_revision is calculated after calculating
1518: bom_revision_date
1519:
1520: IF g_flow_schedule_rec.bom_revision = FND_API.G_MISS_CHAR OR g_flow_schedule_rec.bom_revision IS NULL THEN
1521:
1522: g_flow_schedule_rec.bom_revision := Get_Bom_Revision;
1523:
1524: IF g_flow_schedule_rec.bom_revision IS NOT NULL THEN
1539:
1540: END IF;
1541: */
1542:
1543: IF g_flow_schedule_rec.bom_revision_date = FND_API.G_MISS_DATE OR g_flow_schedule_rec.bom_revision_date IS NULL THEN
1544:
1545: g_flow_schedule_rec.bom_revision_date := Get_Bom_Revision_Date;
1546:
1547: IF g_flow_schedule_rec.bom_revision_date IS NOT NULL THEN
1563: END IF;
1564:
1565: /* Fix for bug 2977987: bom_revision is being calculated after calculating bom_revision_date. */
1566:
1567: IF g_flow_schedule_rec.bom_revision = FND_API.G_MISS_CHAR OR g_flow_schedule_rec.bom_revision IS NULL THEN
1568:
1569: g_flow_schedule_rec.bom_revision := Get_Bom_Revision;
1570:
1571: IF g_flow_schedule_rec.bom_revision IS NOT NULL THEN
1586:
1587: END IF;
1588:
1589:
1590: IF g_flow_schedule_rec.build_sequence = FND_API.G_MISS_NUM OR g_flow_schedule_rec.build_sequence IS NULL THEN
1591:
1592: g_flow_schedule_rec.build_sequence := Get_Build_Sequence;
1593:
1594: IF g_flow_schedule_rec.build_sequence IS NOT NULL THEN
1608: END IF;
1609:
1610: END IF;
1611:
1612: IF g_flow_schedule_rec.class_code = FND_API.G_MISS_CHAR OR g_flow_schedule_rec.class_code IS NULL THEN
1613:
1614: g_flow_schedule_rec.class_code := Get_Class;
1615:
1616: IF g_flow_schedule_rec.class_code IS NOT NULL THEN
1630: END IF;
1631:
1632: END IF;
1633:
1634: IF g_flow_schedule_rec.completion_locator_id = FND_API.G_MISS_NUM OR g_flow_schedule_rec.completion_locator_id IS NULL THEN
1635:
1636: g_flow_schedule_rec.completion_locator_id := Get_Completion_Locator;
1637:
1638: IF g_flow_schedule_rec.completion_locator_id IS NOT NULL THEN
1652: END IF;
1653:
1654: END IF;
1655:
1656: IF g_flow_schedule_rec.completion_subinventory = FND_API.G_MISS_CHAR OR g_flow_schedule_rec.completion_subinventory IS NULL THEN
1657:
1658: g_flow_schedule_rec.completion_subinventory := Get_Completion_Subinventory;
1659:
1660: IF g_flow_schedule_rec.completion_subinventory IS NOT NULL THEN
1674: END IF;
1675:
1676: END IF;
1677:
1678: IF g_flow_schedule_rec.date_closed = FND_API.G_MISS_DATE OR g_flow_schedule_rec.date_closed IS NULL THEN
1679:
1680: g_flow_schedule_rec.date_closed := Get_Date_Closed;
1681:
1682: IF g_flow_schedule_rec.date_closed IS NOT NULL THEN
1696: END IF;
1697:
1698: END IF;
1699:
1700: IF g_flow_schedule_rec.demand_class = FND_API.G_MISS_CHAR OR g_flow_schedule_rec.demand_class IS NULL THEN
1701:
1702: g_flow_schedule_rec.demand_class := Get_Demand_Class;
1703:
1704: IF g_flow_schedule_rec.demand_class IS NOT NULL THEN
1718: END IF;
1719:
1720: END IF;
1721:
1722: IF g_flow_schedule_rec.end_item_unit_number = FND_API.G_MISS_CHAR OR g_flow_schedule_rec.end_item_unit_number IS NULL THEN
1723:
1724: g_flow_schedule_rec.end_item_unit_number := Get_end_item_unit_number;
1725:
1726: IF g_flow_schedule_rec.end_item_unit_number IS NOT NULL THEN
1740: END IF;
1741:
1742: END IF;
1743:
1744: IF g_flow_schedule_rec.quantity_scrapped = FND_API.G_MISS_NUM or g_flow_schedule_rec.quantity_scrapped IS NULL THEN
1745:
1746: g_flow_schedule_rec.quantity_scrapped := Get_quantity_scrapped;
1747:
1748: IF g_flow_schedule_rec.quantity_scrapped IS NOT NULL THEN
1762: END IF;
1763:
1764: END IF;
1765:
1766: IF g_flow_schedule_rec.demand_source_delivery = FND_API.G_MISS_CHAR OR g_flow_schedule_rec.demand_source_delivery IS NULL THEN
1767:
1768: g_flow_schedule_rec.demand_source_delivery := Get_Demand_Source_Delivery;
1769:
1770: IF g_flow_schedule_rec.demand_source_delivery IS NOT NULL THEN
1784: END IF;
1785:
1786: END IF;
1787:
1788: IF g_flow_schedule_rec.demand_source_header_id = FND_API.G_MISS_NUM OR g_flow_schedule_rec.demand_source_header_id IS NULL THEN
1789:
1790: g_flow_schedule_rec.demand_source_header_id := Get_Demand_Source_Header;
1791:
1792: IF g_flow_schedule_rec.demand_source_header_id IS NOT NULL THEN
1806: END IF;
1807:
1808: END IF;
1809:
1810: IF g_flow_schedule_rec.demand_source_line = FND_API.G_MISS_CHAR OR g_flow_schedule_rec.demand_source_line IS NULL THEN
1811:
1812: g_flow_schedule_rec.demand_source_line := Get_Demand_Source_Line;
1813:
1814: IF g_flow_schedule_rec.demand_source_line IS NOT NULL THEN
1828: END IF;
1829:
1830: END IF;
1831:
1832: IF g_flow_schedule_rec.demand_source_type = FND_API.G_MISS_NUM OR g_flow_schedule_rec.demand_source_type IS NULL THEN
1833:
1834: g_flow_schedule_rec.demand_source_type := Get_Demand_Source_Type;
1835:
1836: IF g_flow_schedule_rec.demand_source_type IS NOT NULL THEN
1850: END IF;
1851:
1852: END IF;
1853:
1854: IF g_flow_schedule_rec.line_id = FND_API.G_MISS_NUM OR g_flow_schedule_rec.line_id IS NULL THEN
1855:
1856: g_flow_schedule_rec.line_id := Get_Line;
1857:
1858: IF g_flow_schedule_rec.line_id IS NOT NULL THEN
1872: END IF;
1873:
1874: END IF;
1875:
1876: IF g_flow_schedule_rec.material_account = FND_API.G_MISS_NUM OR g_flow_schedule_rec.material_account IS NULL THEN
1877:
1878: g_flow_schedule_rec.material_account := Get_Material_Account;
1879:
1880: IF g_flow_schedule_rec.material_account IS NOT NULL THEN
1894: END IF;
1895:
1896: END IF;
1897:
1898: IF g_flow_schedule_rec.material_overhead_account = FND_API.G_MISS_NUM OR g_flow_schedule_rec.material_overhead_account IS NULL THEN
1899:
1900: g_flow_schedule_rec.material_overhead_account := Get_Material_Overhead_Account;
1901:
1902: IF g_flow_schedule_rec.material_overhead_account IS NOT NULL THEN
1916: END IF;
1917:
1918: END IF;
1919:
1920: IF g_flow_schedule_rec.material_variance_account = FND_API.G_MISS_NUM OR g_flow_schedule_rec.material_variance_account IS NULL THEN
1921:
1922: g_flow_schedule_rec.material_variance_account := Get_Material_Variance_Account;
1923:
1924: IF g_flow_schedule_rec.material_variance_account IS NOT NULL THEN
1938: END IF;
1939:
1940: END IF;
1941:
1942: IF g_flow_schedule_rec.mps_net_quantity = FND_API.G_MISS_NUM OR g_flow_schedule_rec.mps_net_quantity IS NULL THEN
1943:
1944: g_flow_schedule_rec.mps_net_quantity := Get_Mps_Net_Quantity;
1945:
1946: IF g_flow_schedule_rec.mps_net_quantity IS NOT NULL THEN
1960: END IF;
1961:
1962: END IF;
1963:
1964: IF g_flow_schedule_rec.mps_scheduled_comp_date = FND_API.G_MISS_DATE OR g_flow_schedule_rec.mps_scheduled_comp_date IS NULL THEN
1965:
1966: g_flow_schedule_rec.mps_scheduled_comp_date := Get_Mps_Scheduled_Comp_Date;
1967:
1968: IF g_flow_schedule_rec.mps_scheduled_comp_date IS NOT NULL THEN
1982: END IF;
1983:
1984: END IF;
1985:
1986: IF g_flow_schedule_rec.organization_id = FND_API.G_MISS_NUM OR g_flow_schedule_rec.organization_id IS NULL THEN
1987:
1988: g_flow_schedule_rec.organization_id := Get_Organization;
1989:
1990: IF g_flow_schedule_rec.organization_id IS NOT NULL THEN
2004: END IF;
2005:
2006: END IF;
2007:
2008: IF g_flow_schedule_rec.outside_processing_acct = FND_API.G_MISS_NUM OR g_flow_schedule_rec.outside_processing_acct IS NULL THEN
2009:
2010: g_flow_schedule_rec.outside_processing_acct := Get_Outside_Processing_Acct;
2011:
2012: IF g_flow_schedule_rec.outside_processing_acct IS NOT NULL THEN
2026: END IF;
2027:
2028: END IF;
2029:
2030: IF g_flow_schedule_rec.outside_proc_var_acct = FND_API.G_MISS_NUM OR g_flow_schedule_rec.outside_proc_var_acct IS NULL THEN
2031:
2032: g_flow_schedule_rec.outside_proc_var_acct := Get_Outside_Proc_Var_Acct;
2033:
2034: IF g_flow_schedule_rec.outside_proc_var_acct IS NOT NULL THEN
2048: END IF;
2049:
2050: END IF;
2051:
2052: IF g_flow_schedule_rec.overhead_account = FND_API.G_MISS_NUM OR g_flow_schedule_rec.overhead_account IS NULL THEN
2053:
2054: g_flow_schedule_rec.overhead_account := Get_Overhead_Account;
2055:
2056: IF g_flow_schedule_rec.overhead_account IS NOT NULL THEN
2070: END IF;
2071:
2072: END IF;
2073:
2074: IF g_flow_schedule_rec.overhead_variance_account = FND_API.G_MISS_NUM OR g_flow_schedule_rec.overhead_variance_account IS NULL THEN
2075:
2076: g_flow_schedule_rec.overhead_variance_account := Get_Overhead_Variance_Account;
2077:
2078: IF g_flow_schedule_rec.overhead_variance_account IS NOT NULL THEN
2092: END IF;
2093:
2094: END IF;
2095:
2096: IF g_flow_schedule_rec.planned_quantity = FND_API.G_MISS_NUM OR g_flow_schedule_rec.planned_quantity IS NULL THEN
2097:
2098: g_flow_schedule_rec.planned_quantity := Get_Planned_Quantity;
2099:
2100: IF g_flow_schedule_rec.planned_quantity IS NOT NULL THEN
2114: END IF;
2115:
2116: END IF;
2117:
2118: IF g_flow_schedule_rec.primary_item_id = FND_API.G_MISS_NUM OR g_flow_schedule_rec.primary_item_id IS NULL THEN
2119:
2120: g_flow_schedule_rec.primary_item_id := Get_Primary_Item;
2121:
2122: IF g_flow_schedule_rec.primary_item_id IS NOT NULL THEN
2136: END IF;
2137:
2138: END IF;
2139:
2140: IF g_flow_schedule_rec.project_id = FND_API.G_MISS_NUM OR g_flow_schedule_rec.project_id IS NULL THEN
2141:
2142: g_flow_schedule_rec.project_id := Get_Project;
2143:
2144: IF g_flow_schedule_rec.project_id IS NOT NULL THEN
2158: END IF;
2159:
2160: END IF;
2161:
2162: IF g_flow_schedule_rec.quantity_completed = FND_API.G_MISS_NUM OR g_flow_schedule_rec.quantity_completed IS NULL THEN
2163:
2164: g_flow_schedule_rec.quantity_completed := Get_Quantity_Completed;
2165:
2166: IF g_flow_schedule_rec.quantity_completed IS NOT NULL THEN
2180: END IF;
2181:
2182: END IF;
2183:
2184: IF g_flow_schedule_rec.request_id = FND_API.G_MISS_NUM OR g_flow_schedule_rec.request_id IS NULL THEN
2185:
2186: -- bug 4529167
2187: -- g_flow_schedule_rec.request_id := Get_Request_Id;
2188: g_flow_schedule_rec.request_id := null;
2188: g_flow_schedule_rec.request_id := null;
2189:
2190: END IF;
2191:
2192: IF g_flow_schedule_rec.resource_account = FND_API.G_MISS_NUM OR g_flow_schedule_rec.resource_account IS NULL THEN
2193:
2194: g_flow_schedule_rec.resource_account := Get_Resource_Account;
2195:
2196: IF g_flow_schedule_rec.resource_account IS NOT NULL THEN
2210: END IF;
2211:
2212: END IF;
2213:
2214: IF g_flow_schedule_rec.resource_variance_account = FND_API.G_MISS_NUM OR g_flow_schedule_rec.resource_variance_account IS NULL THEN
2215:
2216: g_flow_schedule_rec.resource_variance_account := Get_Resource_Variance_Account;
2217:
2218: IF g_flow_schedule_rec.resource_variance_account IS NOT NULL THEN
2235:
2236: /* Fix for bug 2977987: Moved this code to ensure that routing_revision is calculated after calculating
2237: routing_revision_date
2238:
2239: IF g_flow_schedule_rec.routing_revision = FND_API.G_MISS_CHAR OR g_flow_schedule_rec.routing_revision IS NULL THEN
2240:
2241: g_flow_schedule_rec.routing_revision := Get_Routing_Revision;
2242:
2243: IF g_flow_schedule_rec.routing_revision IS NOT NULL THEN
2258:
2259: END IF;
2260: */
2261:
2262: IF g_flow_schedule_rec.routing_revision_date = FND_API.G_MISS_DATE OR g_flow_schedule_rec.routing_revision_date IS NULL THEN
2263:
2264: g_flow_schedule_rec.routing_revision_date := Get_Routing_Revision_Date;
2265:
2266: IF g_flow_schedule_rec.routing_revision_date IS NOT NULL THEN
2282: END IF;
2283:
2284: /* Fix for bug 2977987: routing_revision is being calculated after calculating routing_revision_date */
2285:
2286: IF g_flow_schedule_rec.routing_revision = FND_API.G_MISS_CHAR OR g_flow_schedule_rec.routing_revision IS NULL THEN
2287:
2288: g_flow_schedule_rec.routing_revision := Get_Routing_Revision;
2289:
2290: IF g_flow_schedule_rec.routing_revision IS NOT NULL THEN
2304: END IF;
2305:
2306: END IF;
2307:
2308: IF g_flow_schedule_rec.scheduled_completion_date = FND_API.G_MISS_DATE OR g_flow_schedule_rec.scheduled_completion_date IS NULL THEN
2309:
2310: g_flow_schedule_rec.scheduled_completion_date := Get_Scheduled_Completion_Date;
2311:
2312: IF g_flow_schedule_rec.scheduled_completion_date IS NOT NULL THEN
2326: END IF;
2327:
2328: END IF;
2329:
2330: IF g_flow_schedule_rec.scheduled_flag = FND_API.G_MISS_NUM or g_flow_schedule_rec.scheduled_flag IS NULL THEN
2331:
2332: g_flow_schedule_rec.scheduled_flag := Get_Scheduled;
2333:
2334: IF g_flow_schedule_rec.scheduled_flag IS NOT NULL THEN
2348: END IF;
2349:
2350: END IF;
2351:
2352: IF g_flow_schedule_rec.scheduled_start_date = FND_API.G_MISS_DATE OR g_flow_schedule_rec.scheduled_start_date IS NULL THEN
2353:
2354: g_flow_schedule_rec.scheduled_start_date := Get_Scheduled_Start_Date;
2355:
2356: IF g_flow_schedule_rec.scheduled_start_date IS NOT NULL THEN
2370: END IF;
2371:
2372: END IF;
2373:
2374: IF g_flow_schedule_rec.schedule_group_id = FND_API.G_MISS_NUM OR g_flow_schedule_rec.schedule_group_id IS NULL THEN
2375:
2376: g_flow_schedule_rec.schedule_group_id := Get_Schedule_Group;
2377:
2378: IF g_flow_schedule_rec.schedule_group_id IS NOT NULL THEN
2392: END IF;
2393:
2394: END IF;
2395:
2396: IF g_flow_schedule_rec.schedule_number = FND_API.G_MISS_CHAR OR g_flow_schedule_rec.schedule_number IS NULL THEN
2397:
2398: g_flow_schedule_rec.schedule_number := Get_Schedule_Number;
2399:
2400: IF g_flow_schedule_rec.schedule_number IS NOT NULL THEN
2414: END IF;
2415:
2416: END IF;
2417:
2418: IF g_flow_schedule_rec.status = FND_API.G_MISS_NUM OR g_flow_schedule_rec.status IS NULL THEN
2419:
2420: g_flow_schedule_rec.status := Get_Status;
2421:
2422: IF g_flow_schedule_rec.status IS NOT NULL THEN
2436: END IF;
2437:
2438: END IF;
2439:
2440: IF g_flow_schedule_rec.std_cost_adjustment_acct = FND_API.G_MISS_NUM OR g_flow_schedule_rec.std_cost_adjustment_acct IS NULL THEN
2441:
2442: g_flow_schedule_rec.std_cost_adjustment_acct := Get_Std_Cost_Adjustment_Acct;
2443:
2444: IF g_flow_schedule_rec.std_cost_adjustment_acct IS NOT NULL THEN
2458: END IF;
2459:
2460: END IF;
2461:
2462: IF g_flow_schedule_rec.task_id = FND_API.G_MISS_NUM OR g_flow_schedule_rec.task_id IS NULL THEN
2463:
2464: g_flow_schedule_rec.task_id := Get_Task;
2465:
2466: IF g_flow_schedule_rec.task_id IS NOT NULL THEN
2480: END IF;
2481:
2482: END IF;
2483:
2484: IF g_flow_schedule_rec.wip_entity_id = FND_API.G_MISS_NUM OR g_flow_schedule_rec.wip_entity_id IS NULL THEN
2485:
2486: g_flow_schedule_rec.wip_entity_id := Get_Wip_Entity;
2487:
2488: IF g_flow_schedule_rec.wip_entity_id IS NOT NULL THEN
2502: END IF;
2503:
2504: END IF;
2505:
2506: IF g_flow_schedule_rec.attribute1 = FND_API.G_MISS_CHAR
2507: OR g_flow_schedule_rec.attribute10 = FND_API.G_MISS_CHAR
2508: OR g_flow_schedule_rec.attribute11 = FND_API.G_MISS_CHAR
2509: OR g_flow_schedule_rec.attribute12 = FND_API.G_MISS_CHAR
2510: OR g_flow_schedule_rec.attribute13 = FND_API.G_MISS_CHAR
2503:
2504: END IF;
2505:
2506: IF g_flow_schedule_rec.attribute1 = FND_API.G_MISS_CHAR
2507: OR g_flow_schedule_rec.attribute10 = FND_API.G_MISS_CHAR
2508: OR g_flow_schedule_rec.attribute11 = FND_API.G_MISS_CHAR
2509: OR g_flow_schedule_rec.attribute12 = FND_API.G_MISS_CHAR
2510: OR g_flow_schedule_rec.attribute13 = FND_API.G_MISS_CHAR
2511: OR g_flow_schedule_rec.attribute14 = FND_API.G_MISS_CHAR
2504: END IF;
2505:
2506: IF g_flow_schedule_rec.attribute1 = FND_API.G_MISS_CHAR
2507: OR g_flow_schedule_rec.attribute10 = FND_API.G_MISS_CHAR
2508: OR g_flow_schedule_rec.attribute11 = FND_API.G_MISS_CHAR
2509: OR g_flow_schedule_rec.attribute12 = FND_API.G_MISS_CHAR
2510: OR g_flow_schedule_rec.attribute13 = FND_API.G_MISS_CHAR
2511: OR g_flow_schedule_rec.attribute14 = FND_API.G_MISS_CHAR
2512: OR g_flow_schedule_rec.attribute15 = FND_API.G_MISS_CHAR
2505:
2506: IF g_flow_schedule_rec.attribute1 = FND_API.G_MISS_CHAR
2507: OR g_flow_schedule_rec.attribute10 = FND_API.G_MISS_CHAR
2508: OR g_flow_schedule_rec.attribute11 = FND_API.G_MISS_CHAR
2509: OR g_flow_schedule_rec.attribute12 = FND_API.G_MISS_CHAR
2510: OR g_flow_schedule_rec.attribute13 = FND_API.G_MISS_CHAR
2511: OR g_flow_schedule_rec.attribute14 = FND_API.G_MISS_CHAR
2512: OR g_flow_schedule_rec.attribute15 = FND_API.G_MISS_CHAR
2513: OR g_flow_schedule_rec.attribute2 = FND_API.G_MISS_CHAR
2506: IF g_flow_schedule_rec.attribute1 = FND_API.G_MISS_CHAR
2507: OR g_flow_schedule_rec.attribute10 = FND_API.G_MISS_CHAR
2508: OR g_flow_schedule_rec.attribute11 = FND_API.G_MISS_CHAR
2509: OR g_flow_schedule_rec.attribute12 = FND_API.G_MISS_CHAR
2510: OR g_flow_schedule_rec.attribute13 = FND_API.G_MISS_CHAR
2511: OR g_flow_schedule_rec.attribute14 = FND_API.G_MISS_CHAR
2512: OR g_flow_schedule_rec.attribute15 = FND_API.G_MISS_CHAR
2513: OR g_flow_schedule_rec.attribute2 = FND_API.G_MISS_CHAR
2514: OR g_flow_schedule_rec.attribute3 = FND_API.G_MISS_CHAR
2507: OR g_flow_schedule_rec.attribute10 = FND_API.G_MISS_CHAR
2508: OR g_flow_schedule_rec.attribute11 = FND_API.G_MISS_CHAR
2509: OR g_flow_schedule_rec.attribute12 = FND_API.G_MISS_CHAR
2510: OR g_flow_schedule_rec.attribute13 = FND_API.G_MISS_CHAR
2511: OR g_flow_schedule_rec.attribute14 = FND_API.G_MISS_CHAR
2512: OR g_flow_schedule_rec.attribute15 = FND_API.G_MISS_CHAR
2513: OR g_flow_schedule_rec.attribute2 = FND_API.G_MISS_CHAR
2514: OR g_flow_schedule_rec.attribute3 = FND_API.G_MISS_CHAR
2515: OR g_flow_schedule_rec.attribute4 = FND_API.G_MISS_CHAR
2508: OR g_flow_schedule_rec.attribute11 = FND_API.G_MISS_CHAR
2509: OR g_flow_schedule_rec.attribute12 = FND_API.G_MISS_CHAR
2510: OR g_flow_schedule_rec.attribute13 = FND_API.G_MISS_CHAR
2511: OR g_flow_schedule_rec.attribute14 = FND_API.G_MISS_CHAR
2512: OR g_flow_schedule_rec.attribute15 = FND_API.G_MISS_CHAR
2513: OR g_flow_schedule_rec.attribute2 = FND_API.G_MISS_CHAR
2514: OR g_flow_schedule_rec.attribute3 = FND_API.G_MISS_CHAR
2515: OR g_flow_schedule_rec.attribute4 = FND_API.G_MISS_CHAR
2516: OR g_flow_schedule_rec.attribute5 = FND_API.G_MISS_CHAR
2509: OR g_flow_schedule_rec.attribute12 = FND_API.G_MISS_CHAR
2510: OR g_flow_schedule_rec.attribute13 = FND_API.G_MISS_CHAR
2511: OR g_flow_schedule_rec.attribute14 = FND_API.G_MISS_CHAR
2512: OR g_flow_schedule_rec.attribute15 = FND_API.G_MISS_CHAR
2513: OR g_flow_schedule_rec.attribute2 = FND_API.G_MISS_CHAR
2514: OR g_flow_schedule_rec.attribute3 = FND_API.G_MISS_CHAR
2515: OR g_flow_schedule_rec.attribute4 = FND_API.G_MISS_CHAR
2516: OR g_flow_schedule_rec.attribute5 = FND_API.G_MISS_CHAR
2517: OR g_flow_schedule_rec.attribute6 = FND_API.G_MISS_CHAR
2510: OR g_flow_schedule_rec.attribute13 = FND_API.G_MISS_CHAR
2511: OR g_flow_schedule_rec.attribute14 = FND_API.G_MISS_CHAR
2512: OR g_flow_schedule_rec.attribute15 = FND_API.G_MISS_CHAR
2513: OR g_flow_schedule_rec.attribute2 = FND_API.G_MISS_CHAR
2514: OR g_flow_schedule_rec.attribute3 = FND_API.G_MISS_CHAR
2515: OR g_flow_schedule_rec.attribute4 = FND_API.G_MISS_CHAR
2516: OR g_flow_schedule_rec.attribute5 = FND_API.G_MISS_CHAR
2517: OR g_flow_schedule_rec.attribute6 = FND_API.G_MISS_CHAR
2518: OR g_flow_schedule_rec.attribute7 = FND_API.G_MISS_CHAR
2511: OR g_flow_schedule_rec.attribute14 = FND_API.G_MISS_CHAR
2512: OR g_flow_schedule_rec.attribute15 = FND_API.G_MISS_CHAR
2513: OR g_flow_schedule_rec.attribute2 = FND_API.G_MISS_CHAR
2514: OR g_flow_schedule_rec.attribute3 = FND_API.G_MISS_CHAR
2515: OR g_flow_schedule_rec.attribute4 = FND_API.G_MISS_CHAR
2516: OR g_flow_schedule_rec.attribute5 = FND_API.G_MISS_CHAR
2517: OR g_flow_schedule_rec.attribute6 = FND_API.G_MISS_CHAR
2518: OR g_flow_schedule_rec.attribute7 = FND_API.G_MISS_CHAR
2519: OR g_flow_schedule_rec.attribute8 = FND_API.G_MISS_CHAR
2512: OR g_flow_schedule_rec.attribute15 = FND_API.G_MISS_CHAR
2513: OR g_flow_schedule_rec.attribute2 = FND_API.G_MISS_CHAR
2514: OR g_flow_schedule_rec.attribute3 = FND_API.G_MISS_CHAR
2515: OR g_flow_schedule_rec.attribute4 = FND_API.G_MISS_CHAR
2516: OR g_flow_schedule_rec.attribute5 = FND_API.G_MISS_CHAR
2517: OR g_flow_schedule_rec.attribute6 = FND_API.G_MISS_CHAR
2518: OR g_flow_schedule_rec.attribute7 = FND_API.G_MISS_CHAR
2519: OR g_flow_schedule_rec.attribute8 = FND_API.G_MISS_CHAR
2520: OR g_flow_schedule_rec.attribute9 = FND_API.G_MISS_CHAR
2513: OR g_flow_schedule_rec.attribute2 = FND_API.G_MISS_CHAR
2514: OR g_flow_schedule_rec.attribute3 = FND_API.G_MISS_CHAR
2515: OR g_flow_schedule_rec.attribute4 = FND_API.G_MISS_CHAR
2516: OR g_flow_schedule_rec.attribute5 = FND_API.G_MISS_CHAR
2517: OR g_flow_schedule_rec.attribute6 = FND_API.G_MISS_CHAR
2518: OR g_flow_schedule_rec.attribute7 = FND_API.G_MISS_CHAR
2519: OR g_flow_schedule_rec.attribute8 = FND_API.G_MISS_CHAR
2520: OR g_flow_schedule_rec.attribute9 = FND_API.G_MISS_CHAR
2521: OR g_flow_schedule_rec.attribute_category = FND_API.G_MISS_CHAR
2514: OR g_flow_schedule_rec.attribute3 = FND_API.G_MISS_CHAR
2515: OR g_flow_schedule_rec.attribute4 = FND_API.G_MISS_CHAR
2516: OR g_flow_schedule_rec.attribute5 = FND_API.G_MISS_CHAR
2517: OR g_flow_schedule_rec.attribute6 = FND_API.G_MISS_CHAR
2518: OR g_flow_schedule_rec.attribute7 = FND_API.G_MISS_CHAR
2519: OR g_flow_schedule_rec.attribute8 = FND_API.G_MISS_CHAR
2520: OR g_flow_schedule_rec.attribute9 = FND_API.G_MISS_CHAR
2521: OR g_flow_schedule_rec.attribute_category = FND_API.G_MISS_CHAR
2522: THEN
2515: OR g_flow_schedule_rec.attribute4 = FND_API.G_MISS_CHAR
2516: OR g_flow_schedule_rec.attribute5 = FND_API.G_MISS_CHAR
2517: OR g_flow_schedule_rec.attribute6 = FND_API.G_MISS_CHAR
2518: OR g_flow_schedule_rec.attribute7 = FND_API.G_MISS_CHAR
2519: OR g_flow_schedule_rec.attribute8 = FND_API.G_MISS_CHAR
2520: OR g_flow_schedule_rec.attribute9 = FND_API.G_MISS_CHAR
2521: OR g_flow_schedule_rec.attribute_category = FND_API.G_MISS_CHAR
2522: THEN
2523:
2516: OR g_flow_schedule_rec.attribute5 = FND_API.G_MISS_CHAR
2517: OR g_flow_schedule_rec.attribute6 = FND_API.G_MISS_CHAR
2518: OR g_flow_schedule_rec.attribute7 = FND_API.G_MISS_CHAR
2519: OR g_flow_schedule_rec.attribute8 = FND_API.G_MISS_CHAR
2520: OR g_flow_schedule_rec.attribute9 = FND_API.G_MISS_CHAR
2521: OR g_flow_schedule_rec.attribute_category = FND_API.G_MISS_CHAR
2522: THEN
2523:
2524: Get_Flex_Wip_Flow_Schedule;
2517: OR g_flow_schedule_rec.attribute6 = FND_API.G_MISS_CHAR
2518: OR g_flow_schedule_rec.attribute7 = FND_API.G_MISS_CHAR
2519: OR g_flow_schedule_rec.attribute8 = FND_API.G_MISS_CHAR
2520: OR g_flow_schedule_rec.attribute9 = FND_API.G_MISS_CHAR
2521: OR g_flow_schedule_rec.attribute_category = FND_API.G_MISS_CHAR
2522: THEN
2523:
2524: Get_Flex_Wip_Flow_Schedule;
2525:
2524: Get_Flex_Wip_Flow_Schedule;
2525:
2526: END IF;
2527:
2528: IF g_flow_schedule_rec.created_by = FND_API.G_MISS_NUM THEN
2529:
2530: g_flow_schedule_rec.created_by := NULL;
2531:
2532: END IF;
2530: g_flow_schedule_rec.created_by := NULL;
2531:
2532: END IF;
2533:
2534: IF g_flow_schedule_rec.creation_date = FND_API.G_MISS_DATE THEN
2535:
2536: g_flow_schedule_rec.creation_date := NULL;
2537:
2538: END IF;
2536: g_flow_schedule_rec.creation_date := NULL;
2537:
2538: END IF;
2539:
2540: IF g_flow_schedule_rec.last_updated_by = FND_API.G_MISS_NUM THEN
2541:
2542: g_flow_schedule_rec.last_updated_by := NULL;
2543:
2544: END IF;
2542: g_flow_schedule_rec.last_updated_by := NULL;
2543:
2544: END IF;
2545:
2546: IF g_flow_schedule_rec.last_update_date = FND_API.G_MISS_DATE THEN
2547:
2548: g_flow_schedule_rec.last_update_date := NULL;
2549:
2550: END IF;
2548: g_flow_schedule_rec.last_update_date := NULL;
2549:
2550: END IF;
2551:
2552: IF g_flow_schedule_rec.last_update_login = FND_API.G_MISS_NUM THEN
2553:
2554: g_flow_schedule_rec.last_update_login := NULL;
2555:
2556: END IF;
2554: g_flow_schedule_rec.last_update_login := NULL;
2555:
2556: END IF;
2557:
2558: IF g_flow_schedule_rec.program_application_id = FND_API.G_MISS_NUM THEN
2559:
2560: g_flow_schedule_rec.program_application_id := NULL;
2561:
2562: END IF;
2560: g_flow_schedule_rec.program_application_id := NULL;
2561:
2562: END IF;
2563:
2564: IF g_flow_schedule_rec.program_id = FND_API.G_MISS_NUM THEN
2565:
2566: g_flow_schedule_rec.program_id := NULL;
2567:
2568: END IF;
2566: g_flow_schedule_rec.program_id := NULL;
2567:
2568: END IF;
2569:
2570: IF g_flow_schedule_rec.program_update_date = FND_API.G_MISS_DATE THEN
2571:
2572: g_flow_schedule_rec.program_update_date := NULL;
2573:
2574: END IF;
2572: g_flow_schedule_rec.program_update_date := NULL;
2573:
2574: END IF;
2575:
2576: IF g_flow_schedule_rec.request_id = FND_API.G_MISS_NUM THEN
2577:
2578: g_flow_schedule_rec.request_id := NULL;
2579:
2580: END IF;
2578: g_flow_schedule_rec.request_id := NULL;
2579:
2580: END IF;
2581:
2582: IF g_flow_schedule_rec.kanban_card_id = FND_API.G_MISS_NUM THEN
2583:
2584: g_flow_schedule_rec.kanban_card_id := NULL;
2585:
2586: END IF;
2586: END IF;
2587:
2588: -- Redefault if there are any missing attributes.
2589:
2590: IF g_flow_schedule_rec.alternate_bom_designator = FND_API.G_MISS_CHAR
2591: OR g_flow_schedule_rec.alternate_routing_desig = FND_API.G_MISS_CHAR
2592: OR g_flow_schedule_rec.attribute1 = FND_API.G_MISS_CHAR
2593: OR g_flow_schedule_rec.attribute10 = FND_API.G_MISS_CHAR
2594: OR g_flow_schedule_rec.attribute11 = FND_API.G_MISS_CHAR
2587:
2588: -- Redefault if there are any missing attributes.
2589:
2590: IF g_flow_schedule_rec.alternate_bom_designator = FND_API.G_MISS_CHAR
2591: OR g_flow_schedule_rec.alternate_routing_desig = FND_API.G_MISS_CHAR
2592: OR g_flow_schedule_rec.attribute1 = FND_API.G_MISS_CHAR
2593: OR g_flow_schedule_rec.attribute10 = FND_API.G_MISS_CHAR
2594: OR g_flow_schedule_rec.attribute11 = FND_API.G_MISS_CHAR
2595: OR g_flow_schedule_rec.attribute12 = FND_API.G_MISS_CHAR
2588: -- Redefault if there are any missing attributes.
2589:
2590: IF g_flow_schedule_rec.alternate_bom_designator = FND_API.G_MISS_CHAR
2591: OR g_flow_schedule_rec.alternate_routing_desig = FND_API.G_MISS_CHAR
2592: OR g_flow_schedule_rec.attribute1 = FND_API.G_MISS_CHAR
2593: OR g_flow_schedule_rec.attribute10 = FND_API.G_MISS_CHAR
2594: OR g_flow_schedule_rec.attribute11 = FND_API.G_MISS_CHAR
2595: OR g_flow_schedule_rec.attribute12 = FND_API.G_MISS_CHAR
2596: OR g_flow_schedule_rec.attribute13 = FND_API.G_MISS_CHAR
2589:
2590: IF g_flow_schedule_rec.alternate_bom_designator = FND_API.G_MISS_CHAR
2591: OR g_flow_schedule_rec.alternate_routing_desig = FND_API.G_MISS_CHAR
2592: OR g_flow_schedule_rec.attribute1 = FND_API.G_MISS_CHAR
2593: OR g_flow_schedule_rec.attribute10 = FND_API.G_MISS_CHAR
2594: OR g_flow_schedule_rec.attribute11 = FND_API.G_MISS_CHAR
2595: OR g_flow_schedule_rec.attribute12 = FND_API.G_MISS_CHAR
2596: OR g_flow_schedule_rec.attribute13 = FND_API.G_MISS_CHAR
2597: OR g_flow_schedule_rec.attribute14 = FND_API.G_MISS_CHAR
2590: IF g_flow_schedule_rec.alternate_bom_designator = FND_API.G_MISS_CHAR
2591: OR g_flow_schedule_rec.alternate_routing_desig = FND_API.G_MISS_CHAR
2592: OR g_flow_schedule_rec.attribute1 = FND_API.G_MISS_CHAR
2593: OR g_flow_schedule_rec.attribute10 = FND_API.G_MISS_CHAR
2594: OR g_flow_schedule_rec.attribute11 = FND_API.G_MISS_CHAR
2595: OR g_flow_schedule_rec.attribute12 = FND_API.G_MISS_CHAR
2596: OR g_flow_schedule_rec.attribute13 = FND_API.G_MISS_CHAR
2597: OR g_flow_schedule_rec.attribute14 = FND_API.G_MISS_CHAR
2598: OR g_flow_schedule_rec.attribute15 = FND_API.G_MISS_CHAR
2591: OR g_flow_schedule_rec.alternate_routing_desig = FND_API.G_MISS_CHAR
2592: OR g_flow_schedule_rec.attribute1 = FND_API.G_MISS_CHAR
2593: OR g_flow_schedule_rec.attribute10 = FND_API.G_MISS_CHAR
2594: OR g_flow_schedule_rec.attribute11 = FND_API.G_MISS_CHAR
2595: OR g_flow_schedule_rec.attribute12 = FND_API.G_MISS_CHAR
2596: OR g_flow_schedule_rec.attribute13 = FND_API.G_MISS_CHAR
2597: OR g_flow_schedule_rec.attribute14 = FND_API.G_MISS_CHAR
2598: OR g_flow_schedule_rec.attribute15 = FND_API.G_MISS_CHAR
2599: OR g_flow_schedule_rec.attribute2 = FND_API.G_MISS_CHAR
2592: OR g_flow_schedule_rec.attribute1 = FND_API.G_MISS_CHAR
2593: OR g_flow_schedule_rec.attribute10 = FND_API.G_MISS_CHAR
2594: OR g_flow_schedule_rec.attribute11 = FND_API.G_MISS_CHAR
2595: OR g_flow_schedule_rec.attribute12 = FND_API.G_MISS_CHAR
2596: OR g_flow_schedule_rec.attribute13 = FND_API.G_MISS_CHAR
2597: OR g_flow_schedule_rec.attribute14 = FND_API.G_MISS_CHAR
2598: OR g_flow_schedule_rec.attribute15 = FND_API.G_MISS_CHAR
2599: OR g_flow_schedule_rec.attribute2 = FND_API.G_MISS_CHAR
2600: OR g_flow_schedule_rec.attribute3 = FND_API.G_MISS_CHAR
2593: OR g_flow_schedule_rec.attribute10 = FND_API.G_MISS_CHAR
2594: OR g_flow_schedule_rec.attribute11 = FND_API.G_MISS_CHAR
2595: OR g_flow_schedule_rec.attribute12 = FND_API.G_MISS_CHAR
2596: OR g_flow_schedule_rec.attribute13 = FND_API.G_MISS_CHAR
2597: OR g_flow_schedule_rec.attribute14 = FND_API.G_MISS_CHAR
2598: OR g_flow_schedule_rec.attribute15 = FND_API.G_MISS_CHAR
2599: OR g_flow_schedule_rec.attribute2 = FND_API.G_MISS_CHAR
2600: OR g_flow_schedule_rec.attribute3 = FND_API.G_MISS_CHAR
2601: OR g_flow_schedule_rec.attribute4 = FND_API.G_MISS_CHAR
2594: OR g_flow_schedule_rec.attribute11 = FND_API.G_MISS_CHAR
2595: OR g_flow_schedule_rec.attribute12 = FND_API.G_MISS_CHAR
2596: OR g_flow_schedule_rec.attribute13 = FND_API.G_MISS_CHAR
2597: OR g_flow_schedule_rec.attribute14 = FND_API.G_MISS_CHAR
2598: OR g_flow_schedule_rec.attribute15 = FND_API.G_MISS_CHAR
2599: OR g_flow_schedule_rec.attribute2 = FND_API.G_MISS_CHAR
2600: OR g_flow_schedule_rec.attribute3 = FND_API.G_MISS_CHAR
2601: OR g_flow_schedule_rec.attribute4 = FND_API.G_MISS_CHAR
2602: OR g_flow_schedule_rec.attribute5 = FND_API.G_MISS_CHAR
2595: OR g_flow_schedule_rec.attribute12 = FND_API.G_MISS_CHAR
2596: OR g_flow_schedule_rec.attribute13 = FND_API.G_MISS_CHAR
2597: OR g_flow_schedule_rec.attribute14 = FND_API.G_MISS_CHAR
2598: OR g_flow_schedule_rec.attribute15 = FND_API.G_MISS_CHAR
2599: OR g_flow_schedule_rec.attribute2 = FND_API.G_MISS_CHAR
2600: OR g_flow_schedule_rec.attribute3 = FND_API.G_MISS_CHAR
2601: OR g_flow_schedule_rec.attribute4 = FND_API.G_MISS_CHAR
2602: OR g_flow_schedule_rec.attribute5 = FND_API.G_MISS_CHAR
2603: OR g_flow_schedule_rec.attribute6 = FND_API.G_MISS_CHAR
2596: OR g_flow_schedule_rec.attribute13 = FND_API.G_MISS_CHAR
2597: OR g_flow_schedule_rec.attribute14 = FND_API.G_MISS_CHAR
2598: OR g_flow_schedule_rec.attribute15 = FND_API.G_MISS_CHAR
2599: OR g_flow_schedule_rec.attribute2 = FND_API.G_MISS_CHAR
2600: OR g_flow_schedule_rec.attribute3 = FND_API.G_MISS_CHAR
2601: OR g_flow_schedule_rec.attribute4 = FND_API.G_MISS_CHAR
2602: OR g_flow_schedule_rec.attribute5 = FND_API.G_MISS_CHAR
2603: OR g_flow_schedule_rec.attribute6 = FND_API.G_MISS_CHAR
2604: OR g_flow_schedule_rec.attribute7 = FND_API.G_MISS_CHAR
2597: OR g_flow_schedule_rec.attribute14 = FND_API.G_MISS_CHAR
2598: OR g_flow_schedule_rec.attribute15 = FND_API.G_MISS_CHAR
2599: OR g_flow_schedule_rec.attribute2 = FND_API.G_MISS_CHAR
2600: OR g_flow_schedule_rec.attribute3 = FND_API.G_MISS_CHAR
2601: OR g_flow_schedule_rec.attribute4 = FND_API.G_MISS_CHAR
2602: OR g_flow_schedule_rec.attribute5 = FND_API.G_MISS_CHAR
2603: OR g_flow_schedule_rec.attribute6 = FND_API.G_MISS_CHAR
2604: OR g_flow_schedule_rec.attribute7 = FND_API.G_MISS_CHAR
2605: OR g_flow_schedule_rec.attribute8 = FND_API.G_MISS_CHAR
2598: OR g_flow_schedule_rec.attribute15 = FND_API.G_MISS_CHAR
2599: OR g_flow_schedule_rec.attribute2 = FND_API.G_MISS_CHAR
2600: OR g_flow_schedule_rec.attribute3 = FND_API.G_MISS_CHAR
2601: OR g_flow_schedule_rec.attribute4 = FND_API.G_MISS_CHAR
2602: OR g_flow_schedule_rec.attribute5 = FND_API.G_MISS_CHAR
2603: OR g_flow_schedule_rec.attribute6 = FND_API.G_MISS_CHAR
2604: OR g_flow_schedule_rec.attribute7 = FND_API.G_MISS_CHAR
2605: OR g_flow_schedule_rec.attribute8 = FND_API.G_MISS_CHAR
2606: OR g_flow_schedule_rec.attribute9 = FND_API.G_MISS_CHAR
2599: OR g_flow_schedule_rec.attribute2 = FND_API.G_MISS_CHAR
2600: OR g_flow_schedule_rec.attribute3 = FND_API.G_MISS_CHAR
2601: OR g_flow_schedule_rec.attribute4 = FND_API.G_MISS_CHAR
2602: OR g_flow_schedule_rec.attribute5 = FND_API.G_MISS_CHAR
2603: OR g_flow_schedule_rec.attribute6 = FND_API.G_MISS_CHAR
2604: OR g_flow_schedule_rec.attribute7 = FND_API.G_MISS_CHAR
2605: OR g_flow_schedule_rec.attribute8 = FND_API.G_MISS_CHAR
2606: OR g_flow_schedule_rec.attribute9 = FND_API.G_MISS_CHAR
2607: OR g_flow_schedule_rec.attribute_category = FND_API.G_MISS_CHAR
2600: OR g_flow_schedule_rec.attribute3 = FND_API.G_MISS_CHAR
2601: OR g_flow_schedule_rec.attribute4 = FND_API.G_MISS_CHAR
2602: OR g_flow_schedule_rec.attribute5 = FND_API.G_MISS_CHAR
2603: OR g_flow_schedule_rec.attribute6 = FND_API.G_MISS_CHAR
2604: OR g_flow_schedule_rec.attribute7 = FND_API.G_MISS_CHAR
2605: OR g_flow_schedule_rec.attribute8 = FND_API.G_MISS_CHAR
2606: OR g_flow_schedule_rec.attribute9 = FND_API.G_MISS_CHAR
2607: OR g_flow_schedule_rec.attribute_category = FND_API.G_MISS_CHAR
2608: OR g_flow_schedule_rec.bom_revision = FND_API.G_MISS_CHAR
2601: OR g_flow_schedule_rec.attribute4 = FND_API.G_MISS_CHAR
2602: OR g_flow_schedule_rec.attribute5 = FND_API.G_MISS_CHAR
2603: OR g_flow_schedule_rec.attribute6 = FND_API.G_MISS_CHAR
2604: OR g_flow_schedule_rec.attribute7 = FND_API.G_MISS_CHAR
2605: OR g_flow_schedule_rec.attribute8 = FND_API.G_MISS_CHAR
2606: OR g_flow_schedule_rec.attribute9 = FND_API.G_MISS_CHAR
2607: OR g_flow_schedule_rec.attribute_category = FND_API.G_MISS_CHAR
2608: OR g_flow_schedule_rec.bom_revision = FND_API.G_MISS_CHAR
2609: OR g_flow_schedule_rec.bom_revision_date = FND_API.G_MISS_DATE
2602: OR g_flow_schedule_rec.attribute5 = FND_API.G_MISS_CHAR
2603: OR g_flow_schedule_rec.attribute6 = FND_API.G_MISS_CHAR
2604: OR g_flow_schedule_rec.attribute7 = FND_API.G_MISS_CHAR
2605: OR g_flow_schedule_rec.attribute8 = FND_API.G_MISS_CHAR
2606: OR g_flow_schedule_rec.attribute9 = FND_API.G_MISS_CHAR
2607: OR g_flow_schedule_rec.attribute_category = FND_API.G_MISS_CHAR
2608: OR g_flow_schedule_rec.bom_revision = FND_API.G_MISS_CHAR
2609: OR g_flow_schedule_rec.bom_revision_date = FND_API.G_MISS_DATE
2610: OR g_flow_schedule_rec.build_sequence = FND_API.G_MISS_NUM
2603: OR g_flow_schedule_rec.attribute6 = FND_API.G_MISS_CHAR
2604: OR g_flow_schedule_rec.attribute7 = FND_API.G_MISS_CHAR
2605: OR g_flow_schedule_rec.attribute8 = FND_API.G_MISS_CHAR
2606: OR g_flow_schedule_rec.attribute9 = FND_API.G_MISS_CHAR
2607: OR g_flow_schedule_rec.attribute_category = FND_API.G_MISS_CHAR
2608: OR g_flow_schedule_rec.bom_revision = FND_API.G_MISS_CHAR
2609: OR g_flow_schedule_rec.bom_revision_date = FND_API.G_MISS_DATE
2610: OR g_flow_schedule_rec.build_sequence = FND_API.G_MISS_NUM
2611: OR g_flow_schedule_rec.class_code = FND_API.G_MISS_CHAR
2604: OR g_flow_schedule_rec.attribute7 = FND_API.G_MISS_CHAR
2605: OR g_flow_schedule_rec.attribute8 = FND_API.G_MISS_CHAR
2606: OR g_flow_schedule_rec.attribute9 = FND_API.G_MISS_CHAR
2607: OR g_flow_schedule_rec.attribute_category = FND_API.G_MISS_CHAR
2608: OR g_flow_schedule_rec.bom_revision = FND_API.G_MISS_CHAR
2609: OR g_flow_schedule_rec.bom_revision_date = FND_API.G_MISS_DATE
2610: OR g_flow_schedule_rec.build_sequence = FND_API.G_MISS_NUM
2611: OR g_flow_schedule_rec.class_code = FND_API.G_MISS_CHAR
2612: OR g_flow_schedule_rec.completion_locator_id = FND_API.G_MISS_NUM
2605: OR g_flow_schedule_rec.attribute8 = FND_API.G_MISS_CHAR
2606: OR g_flow_schedule_rec.attribute9 = FND_API.G_MISS_CHAR
2607: OR g_flow_schedule_rec.attribute_category = FND_API.G_MISS_CHAR
2608: OR g_flow_schedule_rec.bom_revision = FND_API.G_MISS_CHAR
2609: OR g_flow_schedule_rec.bom_revision_date = FND_API.G_MISS_DATE
2610: OR g_flow_schedule_rec.build_sequence = FND_API.G_MISS_NUM
2611: OR g_flow_schedule_rec.class_code = FND_API.G_MISS_CHAR
2612: OR g_flow_schedule_rec.completion_locator_id = FND_API.G_MISS_NUM
2613: OR g_flow_schedule_rec.completion_subinventory = FND_API.G_MISS_CHAR
2606: OR g_flow_schedule_rec.attribute9 = FND_API.G_MISS_CHAR
2607: OR g_flow_schedule_rec.attribute_category = FND_API.G_MISS_CHAR
2608: OR g_flow_schedule_rec.bom_revision = FND_API.G_MISS_CHAR
2609: OR g_flow_schedule_rec.bom_revision_date = FND_API.G_MISS_DATE
2610: OR g_flow_schedule_rec.build_sequence = FND_API.G_MISS_NUM
2611: OR g_flow_schedule_rec.class_code = FND_API.G_MISS_CHAR
2612: OR g_flow_schedule_rec.completion_locator_id = FND_API.G_MISS_NUM
2613: OR g_flow_schedule_rec.completion_subinventory = FND_API.G_MISS_CHAR
2614: OR g_flow_schedule_rec.created_by = FND_API.G_MISS_NUM
2607: OR g_flow_schedule_rec.attribute_category = FND_API.G_MISS_CHAR
2608: OR g_flow_schedule_rec.bom_revision = FND_API.G_MISS_CHAR
2609: OR g_flow_schedule_rec.bom_revision_date = FND_API.G_MISS_DATE
2610: OR g_flow_schedule_rec.build_sequence = FND_API.G_MISS_NUM
2611: OR g_flow_schedule_rec.class_code = FND_API.G_MISS_CHAR
2612: OR g_flow_schedule_rec.completion_locator_id = FND_API.G_MISS_NUM
2613: OR g_flow_schedule_rec.completion_subinventory = FND_API.G_MISS_CHAR
2614: OR g_flow_schedule_rec.created_by = FND_API.G_MISS_NUM
2615: OR g_flow_schedule_rec.creation_date = FND_API.G_MISS_DATE
2608: OR g_flow_schedule_rec.bom_revision = FND_API.G_MISS_CHAR
2609: OR g_flow_schedule_rec.bom_revision_date = FND_API.G_MISS_DATE
2610: OR g_flow_schedule_rec.build_sequence = FND_API.G_MISS_NUM
2611: OR g_flow_schedule_rec.class_code = FND_API.G_MISS_CHAR
2612: OR g_flow_schedule_rec.completion_locator_id = FND_API.G_MISS_NUM
2613: OR g_flow_schedule_rec.completion_subinventory = FND_API.G_MISS_CHAR
2614: OR g_flow_schedule_rec.created_by = FND_API.G_MISS_NUM
2615: OR g_flow_schedule_rec.creation_date = FND_API.G_MISS_DATE
2616: OR g_flow_schedule_rec.date_closed = FND_API.G_MISS_DATE
2609: OR g_flow_schedule_rec.bom_revision_date = FND_API.G_MISS_DATE
2610: OR g_flow_schedule_rec.build_sequence = FND_API.G_MISS_NUM
2611: OR g_flow_schedule_rec.class_code = FND_API.G_MISS_CHAR
2612: OR g_flow_schedule_rec.completion_locator_id = FND_API.G_MISS_NUM
2613: OR g_flow_schedule_rec.completion_subinventory = FND_API.G_MISS_CHAR
2614: OR g_flow_schedule_rec.created_by = FND_API.G_MISS_NUM
2615: OR g_flow_schedule_rec.creation_date = FND_API.G_MISS_DATE
2616: OR g_flow_schedule_rec.date_closed = FND_API.G_MISS_DATE
2617: OR g_flow_schedule_rec.end_item_unit_number = FND_API.G_MISS_CHAR
2610: OR g_flow_schedule_rec.build_sequence = FND_API.G_MISS_NUM
2611: OR g_flow_schedule_rec.class_code = FND_API.G_MISS_CHAR
2612: OR g_flow_schedule_rec.completion_locator_id = FND_API.G_MISS_NUM
2613: OR g_flow_schedule_rec.completion_subinventory = FND_API.G_MISS_CHAR
2614: OR g_flow_schedule_rec.created_by = FND_API.G_MISS_NUM
2615: OR g_flow_schedule_rec.creation_date = FND_API.G_MISS_DATE
2616: OR g_flow_schedule_rec.date_closed = FND_API.G_MISS_DATE
2617: OR g_flow_schedule_rec.end_item_unit_number = FND_API.G_MISS_CHAR
2618: OR g_flow_schedule_rec.quantity_scrapped = FND_API.G_MISS_NUM
2611: OR g_flow_schedule_rec.class_code = FND_API.G_MISS_CHAR
2612: OR g_flow_schedule_rec.completion_locator_id = FND_API.G_MISS_NUM
2613: OR g_flow_schedule_rec.completion_subinventory = FND_API.G_MISS_CHAR
2614: OR g_flow_schedule_rec.created_by = FND_API.G_MISS_NUM
2615: OR g_flow_schedule_rec.creation_date = FND_API.G_MISS_DATE
2616: OR g_flow_schedule_rec.date_closed = FND_API.G_MISS_DATE
2617: OR g_flow_schedule_rec.end_item_unit_number = FND_API.G_MISS_CHAR
2618: OR g_flow_schedule_rec.quantity_scrapped = FND_API.G_MISS_NUM
2619: OR g_flow_schedule_rec.demand_class = FND_API.G_MISS_CHAR
2612: OR g_flow_schedule_rec.completion_locator_id = FND_API.G_MISS_NUM
2613: OR g_flow_schedule_rec.completion_subinventory = FND_API.G_MISS_CHAR
2614: OR g_flow_schedule_rec.created_by = FND_API.G_MISS_NUM
2615: OR g_flow_schedule_rec.creation_date = FND_API.G_MISS_DATE
2616: OR g_flow_schedule_rec.date_closed = FND_API.G_MISS_DATE
2617: OR g_flow_schedule_rec.end_item_unit_number = FND_API.G_MISS_CHAR
2618: OR g_flow_schedule_rec.quantity_scrapped = FND_API.G_MISS_NUM
2619: OR g_flow_schedule_rec.demand_class = FND_API.G_MISS_CHAR
2620: OR g_flow_schedule_rec.demand_source_delivery = FND_API.G_MISS_CHAR
2613: OR g_flow_schedule_rec.completion_subinventory = FND_API.G_MISS_CHAR
2614: OR g_flow_schedule_rec.created_by = FND_API.G_MISS_NUM
2615: OR g_flow_schedule_rec.creation_date = FND_API.G_MISS_DATE
2616: OR g_flow_schedule_rec.date_closed = FND_API.G_MISS_DATE
2617: OR g_flow_schedule_rec.end_item_unit_number = FND_API.G_MISS_CHAR
2618: OR g_flow_schedule_rec.quantity_scrapped = FND_API.G_MISS_NUM
2619: OR g_flow_schedule_rec.demand_class = FND_API.G_MISS_CHAR
2620: OR g_flow_schedule_rec.demand_source_delivery = FND_API.G_MISS_CHAR
2621: OR g_flow_schedule_rec.demand_source_header_id = FND_API.G_MISS_NUM
2614: OR g_flow_schedule_rec.created_by = FND_API.G_MISS_NUM
2615: OR g_flow_schedule_rec.creation_date = FND_API.G_MISS_DATE
2616: OR g_flow_schedule_rec.date_closed = FND_API.G_MISS_DATE
2617: OR g_flow_schedule_rec.end_item_unit_number = FND_API.G_MISS_CHAR
2618: OR g_flow_schedule_rec.quantity_scrapped = FND_API.G_MISS_NUM
2619: OR g_flow_schedule_rec.demand_class = FND_API.G_MISS_CHAR
2620: OR g_flow_schedule_rec.demand_source_delivery = FND_API.G_MISS_CHAR
2621: OR g_flow_schedule_rec.demand_source_header_id = FND_API.G_MISS_NUM
2622: OR g_flow_schedule_rec.demand_source_line = FND_API.G_MISS_CHAR
2615: OR g_flow_schedule_rec.creation_date = FND_API.G_MISS_DATE
2616: OR g_flow_schedule_rec.date_closed = FND_API.G_MISS_DATE
2617: OR g_flow_schedule_rec.end_item_unit_number = FND_API.G_MISS_CHAR
2618: OR g_flow_schedule_rec.quantity_scrapped = FND_API.G_MISS_NUM
2619: OR g_flow_schedule_rec.demand_class = FND_API.G_MISS_CHAR
2620: OR g_flow_schedule_rec.demand_source_delivery = FND_API.G_MISS_CHAR
2621: OR g_flow_schedule_rec.demand_source_header_id = FND_API.G_MISS_NUM
2622: OR g_flow_schedule_rec.demand_source_line = FND_API.G_MISS_CHAR
2623: OR g_flow_schedule_rec.demand_source_type = FND_API.G_MISS_NUM
2616: OR g_flow_schedule_rec.date_closed = FND_API.G_MISS_DATE
2617: OR g_flow_schedule_rec.end_item_unit_number = FND_API.G_MISS_CHAR
2618: OR g_flow_schedule_rec.quantity_scrapped = FND_API.G_MISS_NUM
2619: OR g_flow_schedule_rec.demand_class = FND_API.G_MISS_CHAR
2620: OR g_flow_schedule_rec.demand_source_delivery = FND_API.G_MISS_CHAR
2621: OR g_flow_schedule_rec.demand_source_header_id = FND_API.G_MISS_NUM
2622: OR g_flow_schedule_rec.demand_source_line = FND_API.G_MISS_CHAR
2623: OR g_flow_schedule_rec.demand_source_type = FND_API.G_MISS_NUM
2624: OR g_flow_schedule_rec.last_updated_by = FND_API.G_MISS_NUM
2617: OR g_flow_schedule_rec.end_item_unit_number = FND_API.G_MISS_CHAR
2618: OR g_flow_schedule_rec.quantity_scrapped = FND_API.G_MISS_NUM
2619: OR g_flow_schedule_rec.demand_class = FND_API.G_MISS_CHAR
2620: OR g_flow_schedule_rec.demand_source_delivery = FND_API.G_MISS_CHAR
2621: OR g_flow_schedule_rec.demand_source_header_id = FND_API.G_MISS_NUM
2622: OR g_flow_schedule_rec.demand_source_line = FND_API.G_MISS_CHAR
2623: OR g_flow_schedule_rec.demand_source_type = FND_API.G_MISS_NUM
2624: OR g_flow_schedule_rec.last_updated_by = FND_API.G_MISS_NUM
2625: OR g_flow_schedule_rec.last_update_date = FND_API.G_MISS_DATE
2618: OR g_flow_schedule_rec.quantity_scrapped = FND_API.G_MISS_NUM
2619: OR g_flow_schedule_rec.demand_class = FND_API.G_MISS_CHAR
2620: OR g_flow_schedule_rec.demand_source_delivery = FND_API.G_MISS_CHAR
2621: OR g_flow_schedule_rec.demand_source_header_id = FND_API.G_MISS_NUM
2622: OR g_flow_schedule_rec.demand_source_line = FND_API.G_MISS_CHAR
2623: OR g_flow_schedule_rec.demand_source_type = FND_API.G_MISS_NUM
2624: OR g_flow_schedule_rec.last_updated_by = FND_API.G_MISS_NUM
2625: OR g_flow_schedule_rec.last_update_date = FND_API.G_MISS_DATE
2626: OR g_flow_schedule_rec.last_update_login = FND_API.G_MISS_NUM
2619: OR g_flow_schedule_rec.demand_class = FND_API.G_MISS_CHAR
2620: OR g_flow_schedule_rec.demand_source_delivery = FND_API.G_MISS_CHAR
2621: OR g_flow_schedule_rec.demand_source_header_id = FND_API.G_MISS_NUM
2622: OR g_flow_schedule_rec.demand_source_line = FND_API.G_MISS_CHAR
2623: OR g_flow_schedule_rec.demand_source_type = FND_API.G_MISS_NUM
2624: OR g_flow_schedule_rec.last_updated_by = FND_API.G_MISS_NUM
2625: OR g_flow_schedule_rec.last_update_date = FND_API.G_MISS_DATE
2626: OR g_flow_schedule_rec.last_update_login = FND_API.G_MISS_NUM
2627: OR g_flow_schedule_rec.line_id = FND_API.G_MISS_NUM
2620: OR g_flow_schedule_rec.demand_source_delivery = FND_API.G_MISS_CHAR
2621: OR g_flow_schedule_rec.demand_source_header_id = FND_API.G_MISS_NUM
2622: OR g_flow_schedule_rec.demand_source_line = FND_API.G_MISS_CHAR
2623: OR g_flow_schedule_rec.demand_source_type = FND_API.G_MISS_NUM
2624: OR g_flow_schedule_rec.last_updated_by = FND_API.G_MISS_NUM
2625: OR g_flow_schedule_rec.last_update_date = FND_API.G_MISS_DATE
2626: OR g_flow_schedule_rec.last_update_login = FND_API.G_MISS_NUM
2627: OR g_flow_schedule_rec.line_id = FND_API.G_MISS_NUM
2628: OR g_flow_schedule_rec.material_account = FND_API.G_MISS_NUM
2621: OR g_flow_schedule_rec.demand_source_header_id = FND_API.G_MISS_NUM
2622: OR g_flow_schedule_rec.demand_source_line = FND_API.G_MISS_CHAR
2623: OR g_flow_schedule_rec.demand_source_type = FND_API.G_MISS_NUM
2624: OR g_flow_schedule_rec.last_updated_by = FND_API.G_MISS_NUM
2625: OR g_flow_schedule_rec.last_update_date = FND_API.G_MISS_DATE
2626: OR g_flow_schedule_rec.last_update_login = FND_API.G_MISS_NUM
2627: OR g_flow_schedule_rec.line_id = FND_API.G_MISS_NUM
2628: OR g_flow_schedule_rec.material_account = FND_API.G_MISS_NUM
2629: OR g_flow_schedule_rec.material_overhead_account = FND_API.G_MISS_NUM
2622: OR g_flow_schedule_rec.demand_source_line = FND_API.G_MISS_CHAR
2623: OR g_flow_schedule_rec.demand_source_type = FND_API.G_MISS_NUM
2624: OR g_flow_schedule_rec.last_updated_by = FND_API.G_MISS_NUM
2625: OR g_flow_schedule_rec.last_update_date = FND_API.G_MISS_DATE
2626: OR g_flow_schedule_rec.last_update_login = FND_API.G_MISS_NUM
2627: OR g_flow_schedule_rec.line_id = FND_API.G_MISS_NUM
2628: OR g_flow_schedule_rec.material_account = FND_API.G_MISS_NUM
2629: OR g_flow_schedule_rec.material_overhead_account = FND_API.G_MISS_NUM
2630: OR g_flow_schedule_rec.material_variance_account = FND_API.G_MISS_NUM
2623: OR g_flow_schedule_rec.demand_source_type = FND_API.G_MISS_NUM
2624: OR g_flow_schedule_rec.last_updated_by = FND_API.G_MISS_NUM
2625: OR g_flow_schedule_rec.last_update_date = FND_API.G_MISS_DATE
2626: OR g_flow_schedule_rec.last_update_login = FND_API.G_MISS_NUM
2627: OR g_flow_schedule_rec.line_id = FND_API.G_MISS_NUM
2628: OR g_flow_schedule_rec.material_account = FND_API.G_MISS_NUM
2629: OR g_flow_schedule_rec.material_overhead_account = FND_API.G_MISS_NUM
2630: OR g_flow_schedule_rec.material_variance_account = FND_API.G_MISS_NUM
2631: OR g_flow_schedule_rec.mps_net_quantity = FND_API.G_MISS_NUM
2624: OR g_flow_schedule_rec.last_updated_by = FND_API.G_MISS_NUM
2625: OR g_flow_schedule_rec.last_update_date = FND_API.G_MISS_DATE
2626: OR g_flow_schedule_rec.last_update_login = FND_API.G_MISS_NUM
2627: OR g_flow_schedule_rec.line_id = FND_API.G_MISS_NUM
2628: OR g_flow_schedule_rec.material_account = FND_API.G_MISS_NUM
2629: OR g_flow_schedule_rec.material_overhead_account = FND_API.G_MISS_NUM
2630: OR g_flow_schedule_rec.material_variance_account = FND_API.G_MISS_NUM
2631: OR g_flow_schedule_rec.mps_net_quantity = FND_API.G_MISS_NUM
2632: OR g_flow_schedule_rec.mps_scheduled_comp_date = FND_API.G_MISS_DATE
2625: OR g_flow_schedule_rec.last_update_date = FND_API.G_MISS_DATE
2626: OR g_flow_schedule_rec.last_update_login = FND_API.G_MISS_NUM
2627: OR g_flow_schedule_rec.line_id = FND_API.G_MISS_NUM
2628: OR g_flow_schedule_rec.material_account = FND_API.G_MISS_NUM
2629: OR g_flow_schedule_rec.material_overhead_account = FND_API.G_MISS_NUM
2630: OR g_flow_schedule_rec.material_variance_account = FND_API.G_MISS_NUM
2631: OR g_flow_schedule_rec.mps_net_quantity = FND_API.G_MISS_NUM
2632: OR g_flow_schedule_rec.mps_scheduled_comp_date = FND_API.G_MISS_DATE
2633: OR g_flow_schedule_rec.organization_id = FND_API.G_MISS_NUM
2626: OR g_flow_schedule_rec.last_update_login = FND_API.G_MISS_NUM
2627: OR g_flow_schedule_rec.line_id = FND_API.G_MISS_NUM
2628: OR g_flow_schedule_rec.material_account = FND_API.G_MISS_NUM
2629: OR g_flow_schedule_rec.material_overhead_account = FND_API.G_MISS_NUM
2630: OR g_flow_schedule_rec.material_variance_account = FND_API.G_MISS_NUM
2631: OR g_flow_schedule_rec.mps_net_quantity = FND_API.G_MISS_NUM
2632: OR g_flow_schedule_rec.mps_scheduled_comp_date = FND_API.G_MISS_DATE
2633: OR g_flow_schedule_rec.organization_id = FND_API.G_MISS_NUM
2634: OR g_flow_schedule_rec.outside_processing_acct = FND_API.G_MISS_NUM
2627: OR g_flow_schedule_rec.line_id = FND_API.G_MISS_NUM
2628: OR g_flow_schedule_rec.material_account = FND_API.G_MISS_NUM
2629: OR g_flow_schedule_rec.material_overhead_account = FND_API.G_MISS_NUM
2630: OR g_flow_schedule_rec.material_variance_account = FND_API.G_MISS_NUM
2631: OR g_flow_schedule_rec.mps_net_quantity = FND_API.G_MISS_NUM
2632: OR g_flow_schedule_rec.mps_scheduled_comp_date = FND_API.G_MISS_DATE
2633: OR g_flow_schedule_rec.organization_id = FND_API.G_MISS_NUM
2634: OR g_flow_schedule_rec.outside_processing_acct = FND_API.G_MISS_NUM
2635: OR g_flow_schedule_rec.outside_proc_var_acct = FND_API.G_MISS_NUM
2628: OR g_flow_schedule_rec.material_account = FND_API.G_MISS_NUM
2629: OR g_flow_schedule_rec.material_overhead_account = FND_API.G_MISS_NUM
2630: OR g_flow_schedule_rec.material_variance_account = FND_API.G_MISS_NUM
2631: OR g_flow_schedule_rec.mps_net_quantity = FND_API.G_MISS_NUM
2632: OR g_flow_schedule_rec.mps_scheduled_comp_date = FND_API.G_MISS_DATE
2633: OR g_flow_schedule_rec.organization_id = FND_API.G_MISS_NUM
2634: OR g_flow_schedule_rec.outside_processing_acct = FND_API.G_MISS_NUM
2635: OR g_flow_schedule_rec.outside_proc_var_acct = FND_API.G_MISS_NUM
2636: OR g_flow_schedule_rec.overhead_account = FND_API.G_MISS_NUM
2629: OR g_flow_schedule_rec.material_overhead_account = FND_API.G_MISS_NUM
2630: OR g_flow_schedule_rec.material_variance_account = FND_API.G_MISS_NUM
2631: OR g_flow_schedule_rec.mps_net_quantity = FND_API.G_MISS_NUM
2632: OR g_flow_schedule_rec.mps_scheduled_comp_date = FND_API.G_MISS_DATE
2633: OR g_flow_schedule_rec.organization_id = FND_API.G_MISS_NUM
2634: OR g_flow_schedule_rec.outside_processing_acct = FND_API.G_MISS_NUM
2635: OR g_flow_schedule_rec.outside_proc_var_acct = FND_API.G_MISS_NUM
2636: OR g_flow_schedule_rec.overhead_account = FND_API.G_MISS_NUM
2637: OR g_flow_schedule_rec.overhead_variance_account = FND_API.G_MISS_NUM
2630: OR g_flow_schedule_rec.material_variance_account = FND_API.G_MISS_NUM
2631: OR g_flow_schedule_rec.mps_net_quantity = FND_API.G_MISS_NUM
2632: OR g_flow_schedule_rec.mps_scheduled_comp_date = FND_API.G_MISS_DATE
2633: OR g_flow_schedule_rec.organization_id = FND_API.G_MISS_NUM
2634: OR g_flow_schedule_rec.outside_processing_acct = FND_API.G_MISS_NUM
2635: OR g_flow_schedule_rec.outside_proc_var_acct = FND_API.G_MISS_NUM
2636: OR g_flow_schedule_rec.overhead_account = FND_API.G_MISS_NUM
2637: OR g_flow_schedule_rec.overhead_variance_account = FND_API.G_MISS_NUM
2638: OR g_flow_schedule_rec.planned_quantity = FND_API.G_MISS_NUM
2631: OR g_flow_schedule_rec.mps_net_quantity = FND_API.G_MISS_NUM
2632: OR g_flow_schedule_rec.mps_scheduled_comp_date = FND_API.G_MISS_DATE
2633: OR g_flow_schedule_rec.organization_id = FND_API.G_MISS_NUM
2634: OR g_flow_schedule_rec.outside_processing_acct = FND_API.G_MISS_NUM
2635: OR g_flow_schedule_rec.outside_proc_var_acct = FND_API.G_MISS_NUM
2636: OR g_flow_schedule_rec.overhead_account = FND_API.G_MISS_NUM
2637: OR g_flow_schedule_rec.overhead_variance_account = FND_API.G_MISS_NUM
2638: OR g_flow_schedule_rec.planned_quantity = FND_API.G_MISS_NUM
2639: OR g_flow_schedule_rec.primary_item_id = FND_API.G_MISS_NUM
2632: OR g_flow_schedule_rec.mps_scheduled_comp_date = FND_API.G_MISS_DATE
2633: OR g_flow_schedule_rec.organization_id = FND_API.G_MISS_NUM
2634: OR g_flow_schedule_rec.outside_processing_acct = FND_API.G_MISS_NUM
2635: OR g_flow_schedule_rec.outside_proc_var_acct = FND_API.G_MISS_NUM
2636: OR g_flow_schedule_rec.overhead_account = FND_API.G_MISS_NUM
2637: OR g_flow_schedule_rec.overhead_variance_account = FND_API.G_MISS_NUM
2638: OR g_flow_schedule_rec.planned_quantity = FND_API.G_MISS_NUM
2639: OR g_flow_schedule_rec.primary_item_id = FND_API.G_MISS_NUM
2640: OR g_flow_schedule_rec.program_application_id = FND_API.G_MISS_NUM
2633: OR g_flow_schedule_rec.organization_id = FND_API.G_MISS_NUM
2634: OR g_flow_schedule_rec.outside_processing_acct = FND_API.G_MISS_NUM
2635: OR g_flow_schedule_rec.outside_proc_var_acct = FND_API.G_MISS_NUM
2636: OR g_flow_schedule_rec.overhead_account = FND_API.G_MISS_NUM
2637: OR g_flow_schedule_rec.overhead_variance_account = FND_API.G_MISS_NUM
2638: OR g_flow_schedule_rec.planned_quantity = FND_API.G_MISS_NUM
2639: OR g_flow_schedule_rec.primary_item_id = FND_API.G_MISS_NUM
2640: OR g_flow_schedule_rec.program_application_id = FND_API.G_MISS_NUM
2641: OR g_flow_schedule_rec.program_id = FND_API.G_MISS_NUM
2634: OR g_flow_schedule_rec.outside_processing_acct = FND_API.G_MISS_NUM
2635: OR g_flow_schedule_rec.outside_proc_var_acct = FND_API.G_MISS_NUM
2636: OR g_flow_schedule_rec.overhead_account = FND_API.G_MISS_NUM
2637: OR g_flow_schedule_rec.overhead_variance_account = FND_API.G_MISS_NUM
2638: OR g_flow_schedule_rec.planned_quantity = FND_API.G_MISS_NUM
2639: OR g_flow_schedule_rec.primary_item_id = FND_API.G_MISS_NUM
2640: OR g_flow_schedule_rec.program_application_id = FND_API.G_MISS_NUM
2641: OR g_flow_schedule_rec.program_id = FND_API.G_MISS_NUM
2642: OR g_flow_schedule_rec.program_update_date = FND_API.G_MISS_DATE
2635: OR g_flow_schedule_rec.outside_proc_var_acct = FND_API.G_MISS_NUM
2636: OR g_flow_schedule_rec.overhead_account = FND_API.G_MISS_NUM
2637: OR g_flow_schedule_rec.overhead_variance_account = FND_API.G_MISS_NUM
2638: OR g_flow_schedule_rec.planned_quantity = FND_API.G_MISS_NUM
2639: OR g_flow_schedule_rec.primary_item_id = FND_API.G_MISS_NUM
2640: OR g_flow_schedule_rec.program_application_id = FND_API.G_MISS_NUM
2641: OR g_flow_schedule_rec.program_id = FND_API.G_MISS_NUM
2642: OR g_flow_schedule_rec.program_update_date = FND_API.G_MISS_DATE
2643: OR g_flow_schedule_rec.project_id = FND_API.G_MISS_NUM
2636: OR g_flow_schedule_rec.overhead_account = FND_API.G_MISS_NUM
2637: OR g_flow_schedule_rec.overhead_variance_account = FND_API.G_MISS_NUM
2638: OR g_flow_schedule_rec.planned_quantity = FND_API.G_MISS_NUM
2639: OR g_flow_schedule_rec.primary_item_id = FND_API.G_MISS_NUM
2640: OR g_flow_schedule_rec.program_application_id = FND_API.G_MISS_NUM
2641: OR g_flow_schedule_rec.program_id = FND_API.G_MISS_NUM
2642: OR g_flow_schedule_rec.program_update_date = FND_API.G_MISS_DATE
2643: OR g_flow_schedule_rec.project_id = FND_API.G_MISS_NUM
2644: OR g_flow_schedule_rec.quantity_completed = FND_API.G_MISS_NUM
2637: OR g_flow_schedule_rec.overhead_variance_account = FND_API.G_MISS_NUM
2638: OR g_flow_schedule_rec.planned_quantity = FND_API.G_MISS_NUM
2639: OR g_flow_schedule_rec.primary_item_id = FND_API.G_MISS_NUM
2640: OR g_flow_schedule_rec.program_application_id = FND_API.G_MISS_NUM
2641: OR g_flow_schedule_rec.program_id = FND_API.G_MISS_NUM
2642: OR g_flow_schedule_rec.program_update_date = FND_API.G_MISS_DATE
2643: OR g_flow_schedule_rec.project_id = FND_API.G_MISS_NUM
2644: OR g_flow_schedule_rec.quantity_completed = FND_API.G_MISS_NUM
2645: OR g_flow_schedule_rec.request_id = FND_API.G_MISS_NUM
2638: OR g_flow_schedule_rec.planned_quantity = FND_API.G_MISS_NUM
2639: OR g_flow_schedule_rec.primary_item_id = FND_API.G_MISS_NUM
2640: OR g_flow_schedule_rec.program_application_id = FND_API.G_MISS_NUM
2641: OR g_flow_schedule_rec.program_id = FND_API.G_MISS_NUM
2642: OR g_flow_schedule_rec.program_update_date = FND_API.G_MISS_DATE
2643: OR g_flow_schedule_rec.project_id = FND_API.G_MISS_NUM
2644: OR g_flow_schedule_rec.quantity_completed = FND_API.G_MISS_NUM
2645: OR g_flow_schedule_rec.request_id = FND_API.G_MISS_NUM
2646: OR g_flow_schedule_rec.resource_account = FND_API.G_MISS_NUM
2639: OR g_flow_schedule_rec.primary_item_id = FND_API.G_MISS_NUM
2640: OR g_flow_schedule_rec.program_application_id = FND_API.G_MISS_NUM
2641: OR g_flow_schedule_rec.program_id = FND_API.G_MISS_NUM
2642: OR g_flow_schedule_rec.program_update_date = FND_API.G_MISS_DATE
2643: OR g_flow_schedule_rec.project_id = FND_API.G_MISS_NUM
2644: OR g_flow_schedule_rec.quantity_completed = FND_API.G_MISS_NUM
2645: OR g_flow_schedule_rec.request_id = FND_API.G_MISS_NUM
2646: OR g_flow_schedule_rec.resource_account = FND_API.G_MISS_NUM
2647: OR g_flow_schedule_rec.resource_variance_account = FND_API.G_MISS_NUM
2640: OR g_flow_schedule_rec.program_application_id = FND_API.G_MISS_NUM
2641: OR g_flow_schedule_rec.program_id = FND_API.G_MISS_NUM
2642: OR g_flow_schedule_rec.program_update_date = FND_API.G_MISS_DATE
2643: OR g_flow_schedule_rec.project_id = FND_API.G_MISS_NUM
2644: OR g_flow_schedule_rec.quantity_completed = FND_API.G_MISS_NUM
2645: OR g_flow_schedule_rec.request_id = FND_API.G_MISS_NUM
2646: OR g_flow_schedule_rec.resource_account = FND_API.G_MISS_NUM
2647: OR g_flow_schedule_rec.resource_variance_account = FND_API.G_MISS_NUM
2648: OR g_flow_schedule_rec.routing_revision = FND_API.G_MISS_CHAR
2641: OR g_flow_schedule_rec.program_id = FND_API.G_MISS_NUM
2642: OR g_flow_schedule_rec.program_update_date = FND_API.G_MISS_DATE
2643: OR g_flow_schedule_rec.project_id = FND_API.G_MISS_NUM
2644: OR g_flow_schedule_rec.quantity_completed = FND_API.G_MISS_NUM
2645: OR g_flow_schedule_rec.request_id = FND_API.G_MISS_NUM
2646: OR g_flow_schedule_rec.resource_account = FND_API.G_MISS_NUM
2647: OR g_flow_schedule_rec.resource_variance_account = FND_API.G_MISS_NUM
2648: OR g_flow_schedule_rec.routing_revision = FND_API.G_MISS_CHAR
2649: OR g_flow_schedule_rec.routing_revision_date = FND_API.G_MISS_DATE
2642: OR g_flow_schedule_rec.program_update_date = FND_API.G_MISS_DATE
2643: OR g_flow_schedule_rec.project_id = FND_API.G_MISS_NUM
2644: OR g_flow_schedule_rec.quantity_completed = FND_API.G_MISS_NUM
2645: OR g_flow_schedule_rec.request_id = FND_API.G_MISS_NUM
2646: OR g_flow_schedule_rec.resource_account = FND_API.G_MISS_NUM
2647: OR g_flow_schedule_rec.resource_variance_account = FND_API.G_MISS_NUM
2648: OR g_flow_schedule_rec.routing_revision = FND_API.G_MISS_CHAR
2649: OR g_flow_schedule_rec.routing_revision_date = FND_API.G_MISS_DATE
2650: OR g_flow_schedule_rec.scheduled_completion_date = FND_API.G_MISS_DATE
2643: OR g_flow_schedule_rec.project_id = FND_API.G_MISS_NUM
2644: OR g_flow_schedule_rec.quantity_completed = FND_API.G_MISS_NUM
2645: OR g_flow_schedule_rec.request_id = FND_API.G_MISS_NUM
2646: OR g_flow_schedule_rec.resource_account = FND_API.G_MISS_NUM
2647: OR g_flow_schedule_rec.resource_variance_account = FND_API.G_MISS_NUM
2648: OR g_flow_schedule_rec.routing_revision = FND_API.G_MISS_CHAR
2649: OR g_flow_schedule_rec.routing_revision_date = FND_API.G_MISS_DATE
2650: OR g_flow_schedule_rec.scheduled_completion_date = FND_API.G_MISS_DATE
2651: OR g_flow_schedule_rec.scheduled_flag = FND_API.G_MISS_NUM
2644: OR g_flow_schedule_rec.quantity_completed = FND_API.G_MISS_NUM
2645: OR g_flow_schedule_rec.request_id = FND_API.G_MISS_NUM
2646: OR g_flow_schedule_rec.resource_account = FND_API.G_MISS_NUM
2647: OR g_flow_schedule_rec.resource_variance_account = FND_API.G_MISS_NUM
2648: OR g_flow_schedule_rec.routing_revision = FND_API.G_MISS_CHAR
2649: OR g_flow_schedule_rec.routing_revision_date = FND_API.G_MISS_DATE
2650: OR g_flow_schedule_rec.scheduled_completion_date = FND_API.G_MISS_DATE
2651: OR g_flow_schedule_rec.scheduled_flag = FND_API.G_MISS_NUM
2652: OR g_flow_schedule_rec.scheduled_start_date = FND_API.G_MISS_DATE
2645: OR g_flow_schedule_rec.request_id = FND_API.G_MISS_NUM
2646: OR g_flow_schedule_rec.resource_account = FND_API.G_MISS_NUM
2647: OR g_flow_schedule_rec.resource_variance_account = FND_API.G_MISS_NUM
2648: OR g_flow_schedule_rec.routing_revision = FND_API.G_MISS_CHAR
2649: OR g_flow_schedule_rec.routing_revision_date = FND_API.G_MISS_DATE
2650: OR g_flow_schedule_rec.scheduled_completion_date = FND_API.G_MISS_DATE
2651: OR g_flow_schedule_rec.scheduled_flag = FND_API.G_MISS_NUM
2652: OR g_flow_schedule_rec.scheduled_start_date = FND_API.G_MISS_DATE
2653: OR g_flow_schedule_rec.schedule_group_id = FND_API.G_MISS_NUM
2646: OR g_flow_schedule_rec.resource_account = FND_API.G_MISS_NUM
2647: OR g_flow_schedule_rec.resource_variance_account = FND_API.G_MISS_NUM
2648: OR g_flow_schedule_rec.routing_revision = FND_API.G_MISS_CHAR
2649: OR g_flow_schedule_rec.routing_revision_date = FND_API.G_MISS_DATE
2650: OR g_flow_schedule_rec.scheduled_completion_date = FND_API.G_MISS_DATE
2651: OR g_flow_schedule_rec.scheduled_flag = FND_API.G_MISS_NUM
2652: OR g_flow_schedule_rec.scheduled_start_date = FND_API.G_MISS_DATE
2653: OR g_flow_schedule_rec.schedule_group_id = FND_API.G_MISS_NUM
2654: OR g_flow_schedule_rec.schedule_number = FND_API.G_MISS_CHAR
2647: OR g_flow_schedule_rec.resource_variance_account = FND_API.G_MISS_NUM
2648: OR g_flow_schedule_rec.routing_revision = FND_API.G_MISS_CHAR
2649: OR g_flow_schedule_rec.routing_revision_date = FND_API.G_MISS_DATE
2650: OR g_flow_schedule_rec.scheduled_completion_date = FND_API.G_MISS_DATE
2651: OR g_flow_schedule_rec.scheduled_flag = FND_API.G_MISS_NUM
2652: OR g_flow_schedule_rec.scheduled_start_date = FND_API.G_MISS_DATE
2653: OR g_flow_schedule_rec.schedule_group_id = FND_API.G_MISS_NUM
2654: OR g_flow_schedule_rec.schedule_number = FND_API.G_MISS_CHAR
2655: OR g_flow_schedule_rec.status = FND_API.G_MISS_NUM
2648: OR g_flow_schedule_rec.routing_revision = FND_API.G_MISS_CHAR
2649: OR g_flow_schedule_rec.routing_revision_date = FND_API.G_MISS_DATE
2650: OR g_flow_schedule_rec.scheduled_completion_date = FND_API.G_MISS_DATE
2651: OR g_flow_schedule_rec.scheduled_flag = FND_API.G_MISS_NUM
2652: OR g_flow_schedule_rec.scheduled_start_date = FND_API.G_MISS_DATE
2653: OR g_flow_schedule_rec.schedule_group_id = FND_API.G_MISS_NUM
2654: OR g_flow_schedule_rec.schedule_number = FND_API.G_MISS_CHAR
2655: OR g_flow_schedule_rec.status = FND_API.G_MISS_NUM
2656: OR g_flow_schedule_rec.std_cost_adjustment_acct = FND_API.G_MISS_NUM
2649: OR g_flow_schedule_rec.routing_revision_date = FND_API.G_MISS_DATE
2650: OR g_flow_schedule_rec.scheduled_completion_date = FND_API.G_MISS_DATE
2651: OR g_flow_schedule_rec.scheduled_flag = FND_API.G_MISS_NUM
2652: OR g_flow_schedule_rec.scheduled_start_date = FND_API.G_MISS_DATE
2653: OR g_flow_schedule_rec.schedule_group_id = FND_API.G_MISS_NUM
2654: OR g_flow_schedule_rec.schedule_number = FND_API.G_MISS_CHAR
2655: OR g_flow_schedule_rec.status = FND_API.G_MISS_NUM
2656: OR g_flow_schedule_rec.std_cost_adjustment_acct = FND_API.G_MISS_NUM
2657: OR g_flow_schedule_rec.task_id = FND_API.G_MISS_NUM
2650: OR g_flow_schedule_rec.scheduled_completion_date = FND_API.G_MISS_DATE
2651: OR g_flow_schedule_rec.scheduled_flag = FND_API.G_MISS_NUM
2652: OR g_flow_schedule_rec.scheduled_start_date = FND_API.G_MISS_DATE
2653: OR g_flow_schedule_rec.schedule_group_id = FND_API.G_MISS_NUM
2654: OR g_flow_schedule_rec.schedule_number = FND_API.G_MISS_CHAR
2655: OR g_flow_schedule_rec.status = FND_API.G_MISS_NUM
2656: OR g_flow_schedule_rec.std_cost_adjustment_acct = FND_API.G_MISS_NUM
2657: OR g_flow_schedule_rec.task_id = FND_API.G_MISS_NUM
2658: OR g_flow_schedule_rec.wip_entity_id = FND_API.G_MISS_NUM
2651: OR g_flow_schedule_rec.scheduled_flag = FND_API.G_MISS_NUM
2652: OR g_flow_schedule_rec.scheduled_start_date = FND_API.G_MISS_DATE
2653: OR g_flow_schedule_rec.schedule_group_id = FND_API.G_MISS_NUM
2654: OR g_flow_schedule_rec.schedule_number = FND_API.G_MISS_CHAR
2655: OR g_flow_schedule_rec.status = FND_API.G_MISS_NUM
2656: OR g_flow_schedule_rec.std_cost_adjustment_acct = FND_API.G_MISS_NUM
2657: OR g_flow_schedule_rec.task_id = FND_API.G_MISS_NUM
2658: OR g_flow_schedule_rec.wip_entity_id = FND_API.G_MISS_NUM
2659: THEN
2652: OR g_flow_schedule_rec.scheduled_start_date = FND_API.G_MISS_DATE
2653: OR g_flow_schedule_rec.schedule_group_id = FND_API.G_MISS_NUM
2654: OR g_flow_schedule_rec.schedule_number = FND_API.G_MISS_CHAR
2655: OR g_flow_schedule_rec.status = FND_API.G_MISS_NUM
2656: OR g_flow_schedule_rec.std_cost_adjustment_acct = FND_API.G_MISS_NUM
2657: OR g_flow_schedule_rec.task_id = FND_API.G_MISS_NUM
2658: OR g_flow_schedule_rec.wip_entity_id = FND_API.G_MISS_NUM
2659: THEN
2660:
2653: OR g_flow_schedule_rec.schedule_group_id = FND_API.G_MISS_NUM
2654: OR g_flow_schedule_rec.schedule_number = FND_API.G_MISS_CHAR
2655: OR g_flow_schedule_rec.status = FND_API.G_MISS_NUM
2656: OR g_flow_schedule_rec.std_cost_adjustment_acct = FND_API.G_MISS_NUM
2657: OR g_flow_schedule_rec.task_id = FND_API.G_MISS_NUM
2658: OR g_flow_schedule_rec.wip_entity_id = FND_API.G_MISS_NUM
2659: THEN
2660:
2661: MRP_Default_Flow_Schedule.Attributes
2654: OR g_flow_schedule_rec.schedule_number = FND_API.G_MISS_CHAR
2655: OR g_flow_schedule_rec.status = FND_API.G_MISS_NUM
2656: OR g_flow_schedule_rec.std_cost_adjustment_acct = FND_API.G_MISS_NUM
2657: OR g_flow_schedule_rec.task_id = FND_API.G_MISS_NUM
2658: OR g_flow_schedule_rec.wip_entity_id = FND_API.G_MISS_NUM
2659: THEN
2660:
2661: MRP_Default_Flow_Schedule.Attributes
2662: ( p_flow_schedule_rec => g_flow_schedule_rec