[Home] [Help]
19:
20: IF p_ForceCopy = TRUE
21: THEN
22:
23: IF p_old_FlowSchedule_rec.alternate_bom_designator <> FND_API.G_MISS_CHAR THEN
24: l_FlowSchedule_rec.alternate_bom_designator := p_old_FlowSchedule_rec.alternate_bom_designator;
25: END IF;
26:
27: IF p_old_FlowSchedule_rec.alternate_rout_designator <> FND_API.G_MISS_CHAR THEN
23: IF p_old_FlowSchedule_rec.alternate_bom_designator <> FND_API.G_MISS_CHAR THEN
24: l_FlowSchedule_rec.alternate_bom_designator := p_old_FlowSchedule_rec.alternate_bom_designator;
25: END IF;
26:
27: IF p_old_FlowSchedule_rec.alternate_rout_designator <> FND_API.G_MISS_CHAR THEN
28: l_FlowSchedule_rec.alternate_rout_designator := p_old_FlowSchedule_rec.alternate_rout_designator;
29: END IF;
30:
31: IF p_old_FlowSchedule_rec.attribute1 <> FND_API.G_MISS_CHAR THEN
27: IF p_old_FlowSchedule_rec.alternate_rout_designator <> FND_API.G_MISS_CHAR THEN
28: l_FlowSchedule_rec.alternate_rout_designator := p_old_FlowSchedule_rec.alternate_rout_designator;
29: END IF;
30:
31: IF p_old_FlowSchedule_rec.attribute1 <> FND_API.G_MISS_CHAR THEN
32: l_FlowSchedule_rec.attribute1 := p_old_FlowSchedule_rec.attribute1;
33: END IF;
34:
35: IF p_old_FlowSchedule_rec.attribute10 <> FND_API.G_MISS_CHAR THEN
31: IF p_old_FlowSchedule_rec.attribute1 <> FND_API.G_MISS_CHAR THEN
32: l_FlowSchedule_rec.attribute1 := p_old_FlowSchedule_rec.attribute1;
33: END IF;
34:
35: IF p_old_FlowSchedule_rec.attribute10 <> FND_API.G_MISS_CHAR THEN
36: l_FlowSchedule_rec.attribute10 := p_old_FlowSchedule_rec.attribute10;
37: END IF;
38:
39: IF p_old_FlowSchedule_rec.attribute11 <> FND_API.G_MISS_CHAR THEN
35: IF p_old_FlowSchedule_rec.attribute10 <> FND_API.G_MISS_CHAR THEN
36: l_FlowSchedule_rec.attribute10 := p_old_FlowSchedule_rec.attribute10;
37: END IF;
38:
39: IF p_old_FlowSchedule_rec.attribute11 <> FND_API.G_MISS_CHAR THEN
40: l_FlowSchedule_rec.attribute11 := p_old_FlowSchedule_rec.attribute11;
41: END IF;
42:
43: IF p_old_FlowSchedule_rec.attribute12 <> FND_API.G_MISS_CHAR THEN
39: IF p_old_FlowSchedule_rec.attribute11 <> FND_API.G_MISS_CHAR THEN
40: l_FlowSchedule_rec.attribute11 := p_old_FlowSchedule_rec.attribute11;
41: END IF;
42:
43: IF p_old_FlowSchedule_rec.attribute12 <> FND_API.G_MISS_CHAR THEN
44: l_FlowSchedule_rec.attribute12 := p_old_FlowSchedule_rec.attribute12;
45: END IF;
46:
47: IF p_old_FlowSchedule_rec.attribute13 <> FND_API.G_MISS_CHAR THEN
43: IF p_old_FlowSchedule_rec.attribute12 <> FND_API.G_MISS_CHAR THEN
44: l_FlowSchedule_rec.attribute12 := p_old_FlowSchedule_rec.attribute12;
45: END IF;
46:
47: IF p_old_FlowSchedule_rec.attribute13 <> FND_API.G_MISS_CHAR THEN
48: l_FlowSchedule_rec.attribute13 := p_old_FlowSchedule_rec.attribute13;
49: END IF;
50:
51: IF p_old_FlowSchedule_rec.attribute14 <> FND_API.G_MISS_CHAR THEN
47: IF p_old_FlowSchedule_rec.attribute13 <> FND_API.G_MISS_CHAR THEN
48: l_FlowSchedule_rec.attribute13 := p_old_FlowSchedule_rec.attribute13;
49: END IF;
50:
51: IF p_old_FlowSchedule_rec.attribute14 <> FND_API.G_MISS_CHAR THEN
52: l_FlowSchedule_rec.attribute14 := p_old_FlowSchedule_rec.attribute14;
53: END IF;
54:
55: IF p_old_FlowSchedule_rec.attribute15 <> FND_API.G_MISS_CHAR THEN
51: IF p_old_FlowSchedule_rec.attribute14 <> FND_API.G_MISS_CHAR THEN
52: l_FlowSchedule_rec.attribute14 := p_old_FlowSchedule_rec.attribute14;
53: END IF;
54:
55: IF p_old_FlowSchedule_rec.attribute15 <> FND_API.G_MISS_CHAR THEN
56: l_FlowSchedule_rec.attribute15 := p_old_FlowSchedule_rec.attribute15;
57: END IF;
58:
59: IF p_old_FlowSchedule_rec.attribute2 <> FND_API.G_MISS_CHAR THEN
55: IF p_old_FlowSchedule_rec.attribute15 <> FND_API.G_MISS_CHAR THEN
56: l_FlowSchedule_rec.attribute15 := p_old_FlowSchedule_rec.attribute15;
57: END IF;
58:
59: IF p_old_FlowSchedule_rec.attribute2 <> FND_API.G_MISS_CHAR THEN
60: l_FlowSchedule_rec.attribute2 := p_old_FlowSchedule_rec.attribute2;
61: END IF;
62:
63: IF p_old_FlowSchedule_rec.attribute3 <> FND_API.G_MISS_CHAR THEN
59: IF p_old_FlowSchedule_rec.attribute2 <> FND_API.G_MISS_CHAR THEN
60: l_FlowSchedule_rec.attribute2 := p_old_FlowSchedule_rec.attribute2;
61: END IF;
62:
63: IF p_old_FlowSchedule_rec.attribute3 <> FND_API.G_MISS_CHAR THEN
64: l_FlowSchedule_rec.attribute3 := p_old_FlowSchedule_rec.attribute3;
65: END IF;
66:
67: IF p_old_FlowSchedule_rec.attribute4 <> FND_API.G_MISS_CHAR THEN
63: IF p_old_FlowSchedule_rec.attribute3 <> FND_API.G_MISS_CHAR THEN
64: l_FlowSchedule_rec.attribute3 := p_old_FlowSchedule_rec.attribute3;
65: END IF;
66:
67: IF p_old_FlowSchedule_rec.attribute4 <> FND_API.G_MISS_CHAR THEN
68: l_FlowSchedule_rec.attribute4 := p_old_FlowSchedule_rec.attribute4;
69: END IF;
70:
71: IF p_old_FlowSchedule_rec.attribute5 <> FND_API.G_MISS_CHAR THEN
67: IF p_old_FlowSchedule_rec.attribute4 <> FND_API.G_MISS_CHAR THEN
68: l_FlowSchedule_rec.attribute4 := p_old_FlowSchedule_rec.attribute4;
69: END IF;
70:
71: IF p_old_FlowSchedule_rec.attribute5 <> FND_API.G_MISS_CHAR THEN
72: l_FlowSchedule_rec.attribute5 := p_old_FlowSchedule_rec.attribute5;
73: END IF;
74:
75: IF p_old_FlowSchedule_rec.attribute6 <> FND_API.G_MISS_CHAR THEN
71: IF p_old_FlowSchedule_rec.attribute5 <> FND_API.G_MISS_CHAR THEN
72: l_FlowSchedule_rec.attribute5 := p_old_FlowSchedule_rec.attribute5;
73: END IF;
74:
75: IF p_old_FlowSchedule_rec.attribute6 <> FND_API.G_MISS_CHAR THEN
76: l_FlowSchedule_rec.attribute6 := p_old_FlowSchedule_rec.attribute6;
77: END IF;
78:
79: IF p_old_FlowSchedule_rec.attribute7 <> FND_API.G_MISS_CHAR THEN
75: IF p_old_FlowSchedule_rec.attribute6 <> FND_API.G_MISS_CHAR THEN
76: l_FlowSchedule_rec.attribute6 := p_old_FlowSchedule_rec.attribute6;
77: END IF;
78:
79: IF p_old_FlowSchedule_rec.attribute7 <> FND_API.G_MISS_CHAR THEN
80: l_FlowSchedule_rec.attribute7 := p_old_FlowSchedule_rec.attribute7;
81: END IF;
82:
83: IF p_old_FlowSchedule_rec.attribute8 <> FND_API.G_MISS_CHAR THEN
79: IF p_old_FlowSchedule_rec.attribute7 <> FND_API.G_MISS_CHAR THEN
80: l_FlowSchedule_rec.attribute7 := p_old_FlowSchedule_rec.attribute7;
81: END IF;
82:
83: IF p_old_FlowSchedule_rec.attribute8 <> FND_API.G_MISS_CHAR THEN
84: l_FlowSchedule_rec.attribute8 := p_old_FlowSchedule_rec.attribute8;
85: END IF;
86:
87: IF p_old_FlowSchedule_rec.attribute9 <> FND_API.G_MISS_CHAR THEN
83: IF p_old_FlowSchedule_rec.attribute8 <> FND_API.G_MISS_CHAR THEN
84: l_FlowSchedule_rec.attribute8 := p_old_FlowSchedule_rec.attribute8;
85: END IF;
86:
87: IF p_old_FlowSchedule_rec.attribute9 <> FND_API.G_MISS_CHAR THEN
88: l_FlowSchedule_rec.attribute9 := p_old_FlowSchedule_rec.attribute9;
89: END IF;
90:
91: IF p_old_FlowSchedule_rec.attribute_category <> FND_API.G_MISS_CHAR THEN
87: IF p_old_FlowSchedule_rec.attribute9 <> FND_API.G_MISS_CHAR THEN
88: l_FlowSchedule_rec.attribute9 := p_old_FlowSchedule_rec.attribute9;
89: END IF;
90:
91: IF p_old_FlowSchedule_rec.attribute_category <> FND_API.G_MISS_CHAR THEN
92: l_FlowSchedule_rec.attribute_category := p_old_FlowSchedule_rec.attribute_category;
93: END IF;
94:
95: IF p_old_FlowSchedule_rec.bom_revision <> FND_API.G_MISS_CHAR THEN
91: IF p_old_FlowSchedule_rec.attribute_category <> FND_API.G_MISS_CHAR THEN
92: l_FlowSchedule_rec.attribute_category := p_old_FlowSchedule_rec.attribute_category;
93: END IF;
94:
95: IF p_old_FlowSchedule_rec.bom_revision <> FND_API.G_MISS_CHAR THEN
96: l_FlowSchedule_rec.bom_revision := p_old_FlowSchedule_rec.bom_revision;
97: END IF;
98:
99: IF p_old_FlowSchedule_rec.bom_revision_date <> FND_API.G_MISS_DATE THEN
95: IF p_old_FlowSchedule_rec.bom_revision <> FND_API.G_MISS_CHAR THEN
96: l_FlowSchedule_rec.bom_revision := p_old_FlowSchedule_rec.bom_revision;
97: END IF;
98:
99: IF p_old_FlowSchedule_rec.bom_revision_date <> FND_API.G_MISS_DATE THEN
100: l_FlowSchedule_rec.bom_revision_date := p_old_FlowSchedule_rec.bom_revision_date;
101: END IF;
102:
103: IF p_old_FlowSchedule_rec.build_sequence <> FND_API.G_MISS_NUM THEN
99: IF p_old_FlowSchedule_rec.bom_revision_date <> FND_API.G_MISS_DATE THEN
100: l_FlowSchedule_rec.bom_revision_date := p_old_FlowSchedule_rec.bom_revision_date;
101: END IF;
102:
103: IF p_old_FlowSchedule_rec.build_sequence <> FND_API.G_MISS_NUM THEN
104: l_FlowSchedule_rec.build_sequence := p_old_FlowSchedule_rec.build_sequence;
105: END IF;
106:
107: IF p_old_FlowSchedule_rec.class_code <> FND_API.G_MISS_CHAR THEN
103: IF p_old_FlowSchedule_rec.build_sequence <> FND_API.G_MISS_NUM THEN
104: l_FlowSchedule_rec.build_sequence := p_old_FlowSchedule_rec.build_sequence;
105: END IF;
106:
107: IF p_old_FlowSchedule_rec.class_code <> FND_API.G_MISS_CHAR THEN
108: l_FlowSchedule_rec.class_code := p_old_FlowSchedule_rec.class_code;
109: END IF;
110:
111: IF p_old_FlowSchedule_rec.completion_locator_id <> FND_API.G_MISS_NUM THEN
107: IF p_old_FlowSchedule_rec.class_code <> FND_API.G_MISS_CHAR THEN
108: l_FlowSchedule_rec.class_code := p_old_FlowSchedule_rec.class_code;
109: END IF;
110:
111: IF p_old_FlowSchedule_rec.completion_locator_id <> FND_API.G_MISS_NUM THEN
112: l_FlowSchedule_rec.completion_locator_id := p_old_FlowSchedule_rec.completion_locator_id;
113: END IF;
114:
115: IF p_old_FlowSchedule_rec.completion_subinventory <> FND_API.G_MISS_CHAR THEN
111: IF p_old_FlowSchedule_rec.completion_locator_id <> FND_API.G_MISS_NUM THEN
112: l_FlowSchedule_rec.completion_locator_id := p_old_FlowSchedule_rec.completion_locator_id;
113: END IF;
114:
115: IF p_old_FlowSchedule_rec.completion_subinventory <> FND_API.G_MISS_CHAR THEN
116: l_FlowSchedule_rec.completion_subinventory := p_old_FlowSchedule_rec.completion_subinventory;
117: END IF;
118:
119: IF p_old_FlowSchedule_rec.created_by <> FND_API.G_MISS_NUM THEN
115: IF p_old_FlowSchedule_rec.completion_subinventory <> FND_API.G_MISS_CHAR THEN
116: l_FlowSchedule_rec.completion_subinventory := p_old_FlowSchedule_rec.completion_subinventory;
117: END IF;
118:
119: IF p_old_FlowSchedule_rec.created_by <> FND_API.G_MISS_NUM THEN
120: l_FlowSchedule_rec.created_by := p_old_FlowSchedule_rec.created_by;
121: END IF;
122:
123: IF p_old_FlowSchedule_rec.creation_date <> FND_API.G_MISS_DATE THEN
119: IF p_old_FlowSchedule_rec.created_by <> FND_API.G_MISS_NUM THEN
120: l_FlowSchedule_rec.created_by := p_old_FlowSchedule_rec.created_by;
121: END IF;
122:
123: IF p_old_FlowSchedule_rec.creation_date <> FND_API.G_MISS_DATE THEN
124: l_FlowSchedule_rec.creation_date := p_old_FlowSchedule_rec.creation_date;
125: END IF;
126:
127: IF p_old_FlowSchedule_rec.date_closed <> FND_API.G_MISS_DATE THEN
123: IF p_old_FlowSchedule_rec.creation_date <> FND_API.G_MISS_DATE THEN
124: l_FlowSchedule_rec.creation_date := p_old_FlowSchedule_rec.creation_date;
125: END IF;
126:
127: IF p_old_FlowSchedule_rec.date_closed <> FND_API.G_MISS_DATE THEN
128: l_FlowSchedule_rec.date_closed := p_old_FlowSchedule_rec.date_closed;
129: END IF;
130:
131: IF p_old_FlowSchedule_rec.demand_class <> FND_API.G_MISS_CHAR THEN
127: IF p_old_FlowSchedule_rec.date_closed <> FND_API.G_MISS_DATE THEN
128: l_FlowSchedule_rec.date_closed := p_old_FlowSchedule_rec.date_closed;
129: END IF;
130:
131: IF p_old_FlowSchedule_rec.demand_class <> FND_API.G_MISS_CHAR THEN
132: l_FlowSchedule_rec.demand_class := p_old_FlowSchedule_rec.demand_class;
133: END IF;
134:
135: IF p_old_FlowSchedule_rec.demand_source_delivery <> FND_API.G_MISS_CHAR THEN
131: IF p_old_FlowSchedule_rec.demand_class <> FND_API.G_MISS_CHAR THEN
132: l_FlowSchedule_rec.demand_class := p_old_FlowSchedule_rec.demand_class;
133: END IF;
134:
135: IF p_old_FlowSchedule_rec.demand_source_delivery <> FND_API.G_MISS_CHAR THEN
136: l_FlowSchedule_rec.demand_source_delivery := p_old_FlowSchedule_rec.demand_source_delivery;
137: END IF;
138:
139: IF p_old_FlowSchedule_rec.demand_source_header_id <> FND_API.G_MISS_NUM THEN
135: IF p_old_FlowSchedule_rec.demand_source_delivery <> FND_API.G_MISS_CHAR THEN
136: l_FlowSchedule_rec.demand_source_delivery := p_old_FlowSchedule_rec.demand_source_delivery;
137: END IF;
138:
139: IF p_old_FlowSchedule_rec.demand_source_header_id <> FND_API.G_MISS_NUM THEN
140: l_FlowSchedule_rec.demand_source_header_id := p_old_FlowSchedule_rec.demand_source_header_id;
141: END IF;
142:
143: IF p_old_FlowSchedule_rec.demand_source_line <> FND_API.G_MISS_CHAR THEN
139: IF p_old_FlowSchedule_rec.demand_source_header_id <> FND_API.G_MISS_NUM THEN
140: l_FlowSchedule_rec.demand_source_header_id := p_old_FlowSchedule_rec.demand_source_header_id;
141: END IF;
142:
143: IF p_old_FlowSchedule_rec.demand_source_line <> FND_API.G_MISS_CHAR THEN
144: l_FlowSchedule_rec.demand_source_line := p_old_FlowSchedule_rec.demand_source_line;
145: END IF;
146:
147: IF p_old_FlowSchedule_rec.demand_source_type <> FND_API.G_MISS_NUM THEN
143: IF p_old_FlowSchedule_rec.demand_source_line <> FND_API.G_MISS_CHAR THEN
144: l_FlowSchedule_rec.demand_source_line := p_old_FlowSchedule_rec.demand_source_line;
145: END IF;
146:
147: IF p_old_FlowSchedule_rec.demand_source_type <> FND_API.G_MISS_NUM THEN
148: l_FlowSchedule_rec.demand_source_type := p_old_FlowSchedule_rec.demand_source_type;
149: END IF;
150:
151: IF p_old_FlowSchedule_rec.kanban_card_id <> FND_API.G_MISS_NUM THEN
147: IF p_old_FlowSchedule_rec.demand_source_type <> FND_API.G_MISS_NUM THEN
148: l_FlowSchedule_rec.demand_source_type := p_old_FlowSchedule_rec.demand_source_type;
149: END IF;
150:
151: IF p_old_FlowSchedule_rec.kanban_card_id <> FND_API.G_MISS_NUM THEN
152: l_FlowSchedule_rec.kanban_card_id := p_old_FlowSchedule_rec.kanban_card_id;
153: END IF;
154:
155: IF p_old_FlowSchedule_rec.last_updated_by <> FND_API.G_MISS_NUM THEN
151: IF p_old_FlowSchedule_rec.kanban_card_id <> FND_API.G_MISS_NUM THEN
152: l_FlowSchedule_rec.kanban_card_id := p_old_FlowSchedule_rec.kanban_card_id;
153: END IF;
154:
155: IF p_old_FlowSchedule_rec.last_updated_by <> FND_API.G_MISS_NUM THEN
156: l_FlowSchedule_rec.last_updated_by := p_old_FlowSchedule_rec.last_updated_by;
157: END IF;
158:
159: IF p_old_FlowSchedule_rec.last_update_date <> FND_API.G_MISS_DATE THEN
155: IF p_old_FlowSchedule_rec.last_updated_by <> FND_API.G_MISS_NUM THEN
156: l_FlowSchedule_rec.last_updated_by := p_old_FlowSchedule_rec.last_updated_by;
157: END IF;
158:
159: IF p_old_FlowSchedule_rec.last_update_date <> FND_API.G_MISS_DATE THEN
160: l_FlowSchedule_rec.last_update_date := p_old_FlowSchedule_rec.last_update_date;
161: END IF;
162:
163: IF p_old_FlowSchedule_rec.last_update_login <> FND_API.G_MISS_NUM THEN
159: IF p_old_FlowSchedule_rec.last_update_date <> FND_API.G_MISS_DATE THEN
160: l_FlowSchedule_rec.last_update_date := p_old_FlowSchedule_rec.last_update_date;
161: END IF;
162:
163: IF p_old_FlowSchedule_rec.last_update_login <> FND_API.G_MISS_NUM THEN
164: l_FlowSchedule_rec.last_update_login := p_old_FlowSchedule_rec.last_update_login;
165: END IF;
166:
167: IF p_old_FlowSchedule_rec.line_id <> FND_API.G_MISS_NUM THEN
163: IF p_old_FlowSchedule_rec.last_update_login <> FND_API.G_MISS_NUM THEN
164: l_FlowSchedule_rec.last_update_login := p_old_FlowSchedule_rec.last_update_login;
165: END IF;
166:
167: IF p_old_FlowSchedule_rec.line_id <> FND_API.G_MISS_NUM THEN
168: l_FlowSchedule_rec.line_id := p_old_FlowSchedule_rec.line_id;
169: END IF;
170:
171: IF p_old_FlowSchedule_rec.material_account <> FND_API.G_MISS_NUM THEN
167: IF p_old_FlowSchedule_rec.line_id <> FND_API.G_MISS_NUM THEN
168: l_FlowSchedule_rec.line_id := p_old_FlowSchedule_rec.line_id;
169: END IF;
170:
171: IF p_old_FlowSchedule_rec.material_account <> FND_API.G_MISS_NUM THEN
172: l_FlowSchedule_rec.material_account := p_old_FlowSchedule_rec.material_account;
173: END IF;
174:
175: IF p_old_FlowSchedule_rec.material_overhead_account <> FND_API.G_MISS_NUM THEN
171: IF p_old_FlowSchedule_rec.material_account <> FND_API.G_MISS_NUM THEN
172: l_FlowSchedule_rec.material_account := p_old_FlowSchedule_rec.material_account;
173: END IF;
174:
175: IF p_old_FlowSchedule_rec.material_overhead_account <> FND_API.G_MISS_NUM THEN
176: l_FlowSchedule_rec.material_overhead_account := p_old_FlowSchedule_rec.material_overhead_account;
177: END IF;
178:
179: IF p_old_FlowSchedule_rec.material_variance_account <> FND_API.G_MISS_NUM THEN
175: IF p_old_FlowSchedule_rec.material_overhead_account <> FND_API.G_MISS_NUM THEN
176: l_FlowSchedule_rec.material_overhead_account := p_old_FlowSchedule_rec.material_overhead_account;
177: END IF;
178:
179: IF p_old_FlowSchedule_rec.material_variance_account <> FND_API.G_MISS_NUM THEN
180: l_FlowSchedule_rec.material_variance_account := p_old_FlowSchedule_rec.material_variance_account;
181: END IF;
182:
183: IF p_old_FlowSchedule_rec.mps_net_quantity <> FND_API.G_MISS_NUM THEN
179: IF p_old_FlowSchedule_rec.material_variance_account <> FND_API.G_MISS_NUM THEN
180: l_FlowSchedule_rec.material_variance_account := p_old_FlowSchedule_rec.material_variance_account;
181: END IF;
182:
183: IF p_old_FlowSchedule_rec.mps_net_quantity <> FND_API.G_MISS_NUM THEN
184: l_FlowSchedule_rec.mps_net_quantity := p_old_FlowSchedule_rec.mps_net_quantity;
185: END IF;
186:
187: IF p_old_FlowSchedule_rec.mps_scheduled_cpl_date <> FND_API.G_MISS_DATE THEN
183: IF p_old_FlowSchedule_rec.mps_net_quantity <> FND_API.G_MISS_NUM THEN
184: l_FlowSchedule_rec.mps_net_quantity := p_old_FlowSchedule_rec.mps_net_quantity;
185: END IF;
186:
187: IF p_old_FlowSchedule_rec.mps_scheduled_cpl_date <> FND_API.G_MISS_DATE THEN
188: l_FlowSchedule_rec.mps_scheduled_cpl_date := p_old_FlowSchedule_rec.mps_scheduled_cpl_date;
189: END IF;
190:
191: IF p_old_FlowSchedule_rec.organization_id <> FND_API.G_MISS_NUM THEN
187: IF p_old_FlowSchedule_rec.mps_scheduled_cpl_date <> FND_API.G_MISS_DATE THEN
188: l_FlowSchedule_rec.mps_scheduled_cpl_date := p_old_FlowSchedule_rec.mps_scheduled_cpl_date;
189: END IF;
190:
191: IF p_old_FlowSchedule_rec.organization_id <> FND_API.G_MISS_NUM THEN
192: l_FlowSchedule_rec.organization_id := p_old_FlowSchedule_rec.organization_id;
193: END IF;
194:
195: IF p_old_FlowSchedule_rec.osp_account <> FND_API.G_MISS_NUM THEN
191: IF p_old_FlowSchedule_rec.organization_id <> FND_API.G_MISS_NUM THEN
192: l_FlowSchedule_rec.organization_id := p_old_FlowSchedule_rec.organization_id;
193: END IF;
194:
195: IF p_old_FlowSchedule_rec.osp_account <> FND_API.G_MISS_NUM THEN
196: l_FlowSchedule_rec.osp_account := p_old_FlowSchedule_rec.osp_account;
197: END IF;
198:
199: IF p_old_FlowSchedule_rec.osp_variance_account <> FND_API.G_MISS_NUM THEN
195: IF p_old_FlowSchedule_rec.osp_account <> FND_API.G_MISS_NUM THEN
196: l_FlowSchedule_rec.osp_account := p_old_FlowSchedule_rec.osp_account;
197: END IF;
198:
199: IF p_old_FlowSchedule_rec.osp_variance_account <> FND_API.G_MISS_NUM THEN
200: l_FlowSchedule_rec.osp_variance_account := p_old_FlowSchedule_rec.osp_variance_account;
201: END IF;
202:
203: IF p_old_FlowSchedule_rec.overhead_account <> FND_API.G_MISS_NUM THEN
199: IF p_old_FlowSchedule_rec.osp_variance_account <> FND_API.G_MISS_NUM THEN
200: l_FlowSchedule_rec.osp_variance_account := p_old_FlowSchedule_rec.osp_variance_account;
201: END IF;
202:
203: IF p_old_FlowSchedule_rec.overhead_account <> FND_API.G_MISS_NUM THEN
204: l_FlowSchedule_rec.overhead_account := p_old_FlowSchedule_rec.overhead_account;
205: END IF;
206:
207: IF p_old_FlowSchedule_rec.overhead_variance_account <> FND_API.G_MISS_NUM THEN
203: IF p_old_FlowSchedule_rec.overhead_account <> FND_API.G_MISS_NUM THEN
204: l_FlowSchedule_rec.overhead_account := p_old_FlowSchedule_rec.overhead_account;
205: END IF;
206:
207: IF p_old_FlowSchedule_rec.overhead_variance_account <> FND_API.G_MISS_NUM THEN
208: l_FlowSchedule_rec.overhead_variance_account := p_old_FlowSchedule_rec.overhead_variance_account;
209: END IF;
210:
211: IF p_old_FlowSchedule_rec.planned_quantity <> FND_API.G_MISS_NUM THEN
207: IF p_old_FlowSchedule_rec.overhead_variance_account <> FND_API.G_MISS_NUM THEN
208: l_FlowSchedule_rec.overhead_variance_account := p_old_FlowSchedule_rec.overhead_variance_account;
209: END IF;
210:
211: IF p_old_FlowSchedule_rec.planned_quantity <> FND_API.G_MISS_NUM THEN
212: l_FlowSchedule_rec.planned_quantity := p_old_FlowSchedule_rec.planned_quantity;
213: END IF;
214:
215: IF p_old_FlowSchedule_rec.primary_item_id <> FND_API.G_MISS_NUM THEN
211: IF p_old_FlowSchedule_rec.planned_quantity <> FND_API.G_MISS_NUM THEN
212: l_FlowSchedule_rec.planned_quantity := p_old_FlowSchedule_rec.planned_quantity;
213: END IF;
214:
215: IF p_old_FlowSchedule_rec.primary_item_id <> FND_API.G_MISS_NUM THEN
216: l_FlowSchedule_rec.primary_item_id := p_old_FlowSchedule_rec.primary_item_id;
217: END IF;
218:
219: IF p_old_FlowSchedule_rec.program_application_id <> FND_API.G_MISS_NUM THEN
215: IF p_old_FlowSchedule_rec.primary_item_id <> FND_API.G_MISS_NUM THEN
216: l_FlowSchedule_rec.primary_item_id := p_old_FlowSchedule_rec.primary_item_id;
217: END IF;
218:
219: IF p_old_FlowSchedule_rec.program_application_id <> FND_API.G_MISS_NUM THEN
220: l_FlowSchedule_rec.program_application_id := p_old_FlowSchedule_rec.program_application_id;
221: END IF;
222:
223: IF p_old_FlowSchedule_rec.program_id <> FND_API.G_MISS_NUM THEN
219: IF p_old_FlowSchedule_rec.program_application_id <> FND_API.G_MISS_NUM THEN
220: l_FlowSchedule_rec.program_application_id := p_old_FlowSchedule_rec.program_application_id;
221: END IF;
222:
223: IF p_old_FlowSchedule_rec.program_id <> FND_API.G_MISS_NUM THEN
224: l_FlowSchedule_rec.program_id := p_old_FlowSchedule_rec.program_id;
225: END IF;
226:
227: IF p_old_FlowSchedule_rec.program_update_date <> FND_API.G_MISS_DATE THEN
223: IF p_old_FlowSchedule_rec.program_id <> FND_API.G_MISS_NUM THEN
224: l_FlowSchedule_rec.program_id := p_old_FlowSchedule_rec.program_id;
225: END IF;
226:
227: IF p_old_FlowSchedule_rec.program_update_date <> FND_API.G_MISS_DATE THEN
228: l_FlowSchedule_rec.program_update_date := p_old_FlowSchedule_rec.program_update_date;
229: END IF;
230:
231: IF p_old_FlowSchedule_rec.project_id <> FND_API.G_MISS_NUM THEN
227: IF p_old_FlowSchedule_rec.program_update_date <> FND_API.G_MISS_DATE THEN
228: l_FlowSchedule_rec.program_update_date := p_old_FlowSchedule_rec.program_update_date;
229: END IF;
230:
231: IF p_old_FlowSchedule_rec.project_id <> FND_API.G_MISS_NUM THEN
232: l_FlowSchedule_rec.project_id := p_old_FlowSchedule_rec.project_id;
233: END IF;
234:
235: IF p_old_FlowSchedule_rec.quantity_completed <> FND_API.G_MISS_NUM THEN
231: IF p_old_FlowSchedule_rec.project_id <> FND_API.G_MISS_NUM THEN
232: l_FlowSchedule_rec.project_id := p_old_FlowSchedule_rec.project_id;
233: END IF;
234:
235: IF p_old_FlowSchedule_rec.quantity_completed <> FND_API.G_MISS_NUM THEN
236: l_FlowSchedule_rec.quantity_completed := p_old_FlowSchedule_rec.quantity_completed;
237: END IF;
238:
239: IF p_old_FlowSchedule_rec.request_id <> FND_API.G_MISS_NUM THEN
235: IF p_old_FlowSchedule_rec.quantity_completed <> FND_API.G_MISS_NUM THEN
236: l_FlowSchedule_rec.quantity_completed := p_old_FlowSchedule_rec.quantity_completed;
237: END IF;
238:
239: IF p_old_FlowSchedule_rec.request_id <> FND_API.G_MISS_NUM THEN
240: l_FlowSchedule_rec.request_id := p_old_FlowSchedule_rec.request_id;
241: END IF;
242:
243: IF p_old_FlowSchedule_rec.resource_account <> FND_API.G_MISS_NUM THEN
239: IF p_old_FlowSchedule_rec.request_id <> FND_API.G_MISS_NUM THEN
240: l_FlowSchedule_rec.request_id := p_old_FlowSchedule_rec.request_id;
241: END IF;
242:
243: IF p_old_FlowSchedule_rec.resource_account <> FND_API.G_MISS_NUM THEN
244: l_FlowSchedule_rec.resource_account := p_old_FlowSchedule_rec.resource_account;
245: END IF;
246:
247: IF p_old_FlowSchedule_rec.resource_variance_account <> FND_API.G_MISS_NUM THEN
243: IF p_old_FlowSchedule_rec.resource_account <> FND_API.G_MISS_NUM THEN
244: l_FlowSchedule_rec.resource_account := p_old_FlowSchedule_rec.resource_account;
245: END IF;
246:
247: IF p_old_FlowSchedule_rec.resource_variance_account <> FND_API.G_MISS_NUM THEN
248: l_FlowSchedule_rec.resource_variance_account := p_old_FlowSchedule_rec.resource_variance_account;
249: END IF;
250:
251: IF p_old_FlowSchedule_rec.routing_revision <> FND_API.G_MISS_CHAR THEN
247: IF p_old_FlowSchedule_rec.resource_variance_account <> FND_API.G_MISS_NUM THEN
248: l_FlowSchedule_rec.resource_variance_account := p_old_FlowSchedule_rec.resource_variance_account;
249: END IF;
250:
251: IF p_old_FlowSchedule_rec.routing_revision <> FND_API.G_MISS_CHAR THEN
252: l_FlowSchedule_rec.routing_revision := p_old_FlowSchedule_rec.routing_revision;
253: END IF;
254:
255: IF p_old_FlowSchedule_rec.routing_revision_date <> FND_API.G_MISS_DATE THEN
251: IF p_old_FlowSchedule_rec.routing_revision <> FND_API.G_MISS_CHAR THEN
252: l_FlowSchedule_rec.routing_revision := p_old_FlowSchedule_rec.routing_revision;
253: END IF;
254:
255: IF p_old_FlowSchedule_rec.routing_revision_date <> FND_API.G_MISS_DATE THEN
256: l_FlowSchedule_rec.routing_revision_date := p_old_FlowSchedule_rec.routing_revision_date;
257: END IF;
258:
259: IF p_old_FlowSchedule_rec.scheduled_completion_date <> FND_API.G_MISS_DATE THEN
255: IF p_old_FlowSchedule_rec.routing_revision_date <> FND_API.G_MISS_DATE THEN
256: l_FlowSchedule_rec.routing_revision_date := p_old_FlowSchedule_rec.routing_revision_date;
257: END IF;
258:
259: IF p_old_FlowSchedule_rec.scheduled_completion_date <> FND_API.G_MISS_DATE THEN
260: l_FlowSchedule_rec.scheduled_completion_date := p_old_FlowSchedule_rec.scheduled_completion_date;
261: END IF;
262:
263: IF p_old_FlowSchedule_rec.scheduled_flag <> FND_API.G_MISS_NUM THEN
259: IF p_old_FlowSchedule_rec.scheduled_completion_date <> FND_API.G_MISS_DATE THEN
260: l_FlowSchedule_rec.scheduled_completion_date := p_old_FlowSchedule_rec.scheduled_completion_date;
261: END IF;
262:
263: IF p_old_FlowSchedule_rec.scheduled_flag <> FND_API.G_MISS_NUM THEN
264: l_FlowSchedule_rec.scheduled_flag := p_old_FlowSchedule_rec.scheduled_flag;
265: END IF;
266:
267: IF p_old_FlowSchedule_rec.scheduled_start_date <> FND_API.G_MISS_DATE THEN
263: IF p_old_FlowSchedule_rec.scheduled_flag <> FND_API.G_MISS_NUM THEN
264: l_FlowSchedule_rec.scheduled_flag := p_old_FlowSchedule_rec.scheduled_flag;
265: END IF;
266:
267: IF p_old_FlowSchedule_rec.scheduled_start_date <> FND_API.G_MISS_DATE THEN
268: l_FlowSchedule_rec.scheduled_start_date := p_old_FlowSchedule_rec.scheduled_start_date;
269: END IF;
270:
271: IF p_old_FlowSchedule_rec.schedule_group_id <> FND_API.G_MISS_NUM THEN
267: IF p_old_FlowSchedule_rec.scheduled_start_date <> FND_API.G_MISS_DATE THEN
268: l_FlowSchedule_rec.scheduled_start_date := p_old_FlowSchedule_rec.scheduled_start_date;
269: END IF;
270:
271: IF p_old_FlowSchedule_rec.schedule_group_id <> FND_API.G_MISS_NUM THEN
272: l_FlowSchedule_rec.schedule_group_id := p_old_FlowSchedule_rec.schedule_group_id;
273: END IF;
274:
275: IF p_old_FlowSchedule_rec.schedule_number <> FND_API.G_MISS_CHAR THEN
271: IF p_old_FlowSchedule_rec.schedule_group_id <> FND_API.G_MISS_NUM THEN
272: l_FlowSchedule_rec.schedule_group_id := p_old_FlowSchedule_rec.schedule_group_id;
273: END IF;
274:
275: IF p_old_FlowSchedule_rec.schedule_number <> FND_API.G_MISS_CHAR THEN
276: l_FlowSchedule_rec.schedule_number := p_old_FlowSchedule_rec.schedule_number;
277: END IF;
278:
279: IF p_old_FlowSchedule_rec.status <> FND_API.G_MISS_NUM THEN
275: IF p_old_FlowSchedule_rec.schedule_number <> FND_API.G_MISS_CHAR THEN
276: l_FlowSchedule_rec.schedule_number := p_old_FlowSchedule_rec.schedule_number;
277: END IF;
278:
279: IF p_old_FlowSchedule_rec.status <> FND_API.G_MISS_NUM THEN
280: l_FlowSchedule_rec.status := p_old_FlowSchedule_rec.status;
281: END IF;
282:
283: IF p_old_FlowSchedule_rec.std_cost_adj_account <> FND_API.G_MISS_NUM THEN
279: IF p_old_FlowSchedule_rec.status <> FND_API.G_MISS_NUM THEN
280: l_FlowSchedule_rec.status := p_old_FlowSchedule_rec.status;
281: END IF;
282:
283: IF p_old_FlowSchedule_rec.std_cost_adj_account <> FND_API.G_MISS_NUM THEN
284: l_FlowSchedule_rec.std_cost_adj_account := p_old_FlowSchedule_rec.std_cost_adj_account;
285: END IF;
286:
287: IF p_old_FlowSchedule_rec.task_id <> FND_API.G_MISS_NUM THEN
283: IF p_old_FlowSchedule_rec.std_cost_adj_account <> FND_API.G_MISS_NUM THEN
284: l_FlowSchedule_rec.std_cost_adj_account := p_old_FlowSchedule_rec.std_cost_adj_account;
285: END IF;
286:
287: IF p_old_FlowSchedule_rec.task_id <> FND_API.G_MISS_NUM THEN
288: l_FlowSchedule_rec.task_id := p_old_FlowSchedule_rec.task_id;
289: END IF;
290:
291: IF p_old_FlowSchedule_rec.wip_entity_id <> FND_API.G_MISS_NUM THEN
287: IF p_old_FlowSchedule_rec.task_id <> FND_API.G_MISS_NUM THEN
288: l_FlowSchedule_rec.task_id := p_old_FlowSchedule_rec.task_id;
289: END IF;
290:
291: IF p_old_FlowSchedule_rec.wip_entity_id <> FND_API.G_MISS_NUM THEN
292: l_FlowSchedule_rec.wip_entity_id := p_old_FlowSchedule_rec.wip_entity_id;
293: END IF;
294:
295: ELSE
293: END IF;
294:
295: ELSE
296:
297: IF l_FlowSchedule_rec.alternate_bom_designator = FND_API.G_MISS_CHAR THEN
298: l_FlowSchedule_rec.alternate_bom_designator := p_old_FlowSchedule_rec.alternate_bom_designator;
299: END IF;
300:
301: IF l_FlowSchedule_rec.alternate_rout_designator = FND_API.G_MISS_CHAR THEN
297: IF l_FlowSchedule_rec.alternate_bom_designator = FND_API.G_MISS_CHAR THEN
298: l_FlowSchedule_rec.alternate_bom_designator := p_old_FlowSchedule_rec.alternate_bom_designator;
299: END IF;
300:
301: IF l_FlowSchedule_rec.alternate_rout_designator = FND_API.G_MISS_CHAR THEN
302: l_FlowSchedule_rec.alternate_rout_designator := p_old_FlowSchedule_rec.alternate_rout_designator;
303: END IF;
304:
305: IF l_FlowSchedule_rec.attribute1 = FND_API.G_MISS_CHAR THEN
301: IF l_FlowSchedule_rec.alternate_rout_designator = FND_API.G_MISS_CHAR THEN
302: l_FlowSchedule_rec.alternate_rout_designator := p_old_FlowSchedule_rec.alternate_rout_designator;
303: END IF;
304:
305: IF l_FlowSchedule_rec.attribute1 = FND_API.G_MISS_CHAR THEN
306: l_FlowSchedule_rec.attribute1 := p_old_FlowSchedule_rec.attribute1;
307: END IF;
308:
309: IF l_FlowSchedule_rec.attribute10 = FND_API.G_MISS_CHAR THEN
305: IF l_FlowSchedule_rec.attribute1 = FND_API.G_MISS_CHAR THEN
306: l_FlowSchedule_rec.attribute1 := p_old_FlowSchedule_rec.attribute1;
307: END IF;
308:
309: IF l_FlowSchedule_rec.attribute10 = FND_API.G_MISS_CHAR THEN
310: l_FlowSchedule_rec.attribute10 := p_old_FlowSchedule_rec.attribute10;
311: END IF;
312:
313: IF l_FlowSchedule_rec.attribute11 = FND_API.G_MISS_CHAR THEN
309: IF l_FlowSchedule_rec.attribute10 = FND_API.G_MISS_CHAR THEN
310: l_FlowSchedule_rec.attribute10 := p_old_FlowSchedule_rec.attribute10;
311: END IF;
312:
313: IF l_FlowSchedule_rec.attribute11 = FND_API.G_MISS_CHAR THEN
314: l_FlowSchedule_rec.attribute11 := p_old_FlowSchedule_rec.attribute11;
315: END IF;
316:
317: IF l_FlowSchedule_rec.attribute12 = FND_API.G_MISS_CHAR THEN
313: IF l_FlowSchedule_rec.attribute11 = FND_API.G_MISS_CHAR THEN
314: l_FlowSchedule_rec.attribute11 := p_old_FlowSchedule_rec.attribute11;
315: END IF;
316:
317: IF l_FlowSchedule_rec.attribute12 = FND_API.G_MISS_CHAR THEN
318: l_FlowSchedule_rec.attribute12 := p_old_FlowSchedule_rec.attribute12;
319: END IF;
320:
321: IF l_FlowSchedule_rec.attribute13 = FND_API.G_MISS_CHAR THEN
317: IF l_FlowSchedule_rec.attribute12 = FND_API.G_MISS_CHAR THEN
318: l_FlowSchedule_rec.attribute12 := p_old_FlowSchedule_rec.attribute12;
319: END IF;
320:
321: IF l_FlowSchedule_rec.attribute13 = FND_API.G_MISS_CHAR THEN
322: l_FlowSchedule_rec.attribute13 := p_old_FlowSchedule_rec.attribute13;
323: END IF;
324:
325: IF l_FlowSchedule_rec.attribute14 = FND_API.G_MISS_CHAR THEN
321: IF l_FlowSchedule_rec.attribute13 = FND_API.G_MISS_CHAR THEN
322: l_FlowSchedule_rec.attribute13 := p_old_FlowSchedule_rec.attribute13;
323: END IF;
324:
325: IF l_FlowSchedule_rec.attribute14 = FND_API.G_MISS_CHAR THEN
326: l_FlowSchedule_rec.attribute14 := p_old_FlowSchedule_rec.attribute14;
327: END IF;
328:
329: IF l_FlowSchedule_rec.attribute15 = FND_API.G_MISS_CHAR THEN
325: IF l_FlowSchedule_rec.attribute14 = FND_API.G_MISS_CHAR THEN
326: l_FlowSchedule_rec.attribute14 := p_old_FlowSchedule_rec.attribute14;
327: END IF;
328:
329: IF l_FlowSchedule_rec.attribute15 = FND_API.G_MISS_CHAR THEN
330: l_FlowSchedule_rec.attribute15 := p_old_FlowSchedule_rec.attribute15;
331: END IF;
332:
333: IF l_FlowSchedule_rec.attribute2 = FND_API.G_MISS_CHAR THEN
329: IF l_FlowSchedule_rec.attribute15 = FND_API.G_MISS_CHAR THEN
330: l_FlowSchedule_rec.attribute15 := p_old_FlowSchedule_rec.attribute15;
331: END IF;
332:
333: IF l_FlowSchedule_rec.attribute2 = FND_API.G_MISS_CHAR THEN
334: l_FlowSchedule_rec.attribute2 := p_old_FlowSchedule_rec.attribute2;
335: END IF;
336:
337: IF l_FlowSchedule_rec.attribute3 = FND_API.G_MISS_CHAR THEN
333: IF l_FlowSchedule_rec.attribute2 = FND_API.G_MISS_CHAR THEN
334: l_FlowSchedule_rec.attribute2 := p_old_FlowSchedule_rec.attribute2;
335: END IF;
336:
337: IF l_FlowSchedule_rec.attribute3 = FND_API.G_MISS_CHAR THEN
338: l_FlowSchedule_rec.attribute3 := p_old_FlowSchedule_rec.attribute3;
339: END IF;
340:
341: IF l_FlowSchedule_rec.attribute4 = FND_API.G_MISS_CHAR THEN
337: IF l_FlowSchedule_rec.attribute3 = FND_API.G_MISS_CHAR THEN
338: l_FlowSchedule_rec.attribute3 := p_old_FlowSchedule_rec.attribute3;
339: END IF;
340:
341: IF l_FlowSchedule_rec.attribute4 = FND_API.G_MISS_CHAR THEN
342: l_FlowSchedule_rec.attribute4 := p_old_FlowSchedule_rec.attribute4;
343: END IF;
344:
345: IF l_FlowSchedule_rec.attribute5 = FND_API.G_MISS_CHAR THEN
341: IF l_FlowSchedule_rec.attribute4 = FND_API.G_MISS_CHAR THEN
342: l_FlowSchedule_rec.attribute4 := p_old_FlowSchedule_rec.attribute4;
343: END IF;
344:
345: IF l_FlowSchedule_rec.attribute5 = FND_API.G_MISS_CHAR THEN
346: l_FlowSchedule_rec.attribute5 := p_old_FlowSchedule_rec.attribute5;
347: END IF;
348:
349: IF l_FlowSchedule_rec.attribute6 = FND_API.G_MISS_CHAR THEN
345: IF l_FlowSchedule_rec.attribute5 = FND_API.G_MISS_CHAR THEN
346: l_FlowSchedule_rec.attribute5 := p_old_FlowSchedule_rec.attribute5;
347: END IF;
348:
349: IF l_FlowSchedule_rec.attribute6 = FND_API.G_MISS_CHAR THEN
350: l_FlowSchedule_rec.attribute6 := p_old_FlowSchedule_rec.attribute6;
351: END IF;
352:
353: IF l_FlowSchedule_rec.attribute7 = FND_API.G_MISS_CHAR THEN
349: IF l_FlowSchedule_rec.attribute6 = FND_API.G_MISS_CHAR THEN
350: l_FlowSchedule_rec.attribute6 := p_old_FlowSchedule_rec.attribute6;
351: END IF;
352:
353: IF l_FlowSchedule_rec.attribute7 = FND_API.G_MISS_CHAR THEN
354: l_FlowSchedule_rec.attribute7 := p_old_FlowSchedule_rec.attribute7;
355: END IF;
356:
357: IF l_FlowSchedule_rec.attribute8 = FND_API.G_MISS_CHAR THEN
353: IF l_FlowSchedule_rec.attribute7 = FND_API.G_MISS_CHAR THEN
354: l_FlowSchedule_rec.attribute7 := p_old_FlowSchedule_rec.attribute7;
355: END IF;
356:
357: IF l_FlowSchedule_rec.attribute8 = FND_API.G_MISS_CHAR THEN
358: l_FlowSchedule_rec.attribute8 := p_old_FlowSchedule_rec.attribute8;
359: END IF;
360:
361: IF l_FlowSchedule_rec.attribute9 = FND_API.G_MISS_CHAR THEN
357: IF l_FlowSchedule_rec.attribute8 = FND_API.G_MISS_CHAR THEN
358: l_FlowSchedule_rec.attribute8 := p_old_FlowSchedule_rec.attribute8;
359: END IF;
360:
361: IF l_FlowSchedule_rec.attribute9 = FND_API.G_MISS_CHAR THEN
362: l_FlowSchedule_rec.attribute9 := p_old_FlowSchedule_rec.attribute9;
363: END IF;
364:
365: IF l_FlowSchedule_rec.attribute_category = FND_API.G_MISS_CHAR THEN
361: IF l_FlowSchedule_rec.attribute9 = FND_API.G_MISS_CHAR THEN
362: l_FlowSchedule_rec.attribute9 := p_old_FlowSchedule_rec.attribute9;
363: END IF;
364:
365: IF l_FlowSchedule_rec.attribute_category = FND_API.G_MISS_CHAR THEN
366: l_FlowSchedule_rec.attribute_category := p_old_FlowSchedule_rec.attribute_category;
367: END IF;
368:
369: IF l_FlowSchedule_rec.bom_revision = FND_API.G_MISS_CHAR THEN
365: IF l_FlowSchedule_rec.attribute_category = FND_API.G_MISS_CHAR THEN
366: l_FlowSchedule_rec.attribute_category := p_old_FlowSchedule_rec.attribute_category;
367: END IF;
368:
369: IF l_FlowSchedule_rec.bom_revision = FND_API.G_MISS_CHAR THEN
370: l_FlowSchedule_rec.bom_revision := p_old_FlowSchedule_rec.bom_revision;
371: END IF;
372:
373: IF l_FlowSchedule_rec.bom_revision_date = FND_API.G_MISS_DATE THEN
369: IF l_FlowSchedule_rec.bom_revision = FND_API.G_MISS_CHAR THEN
370: l_FlowSchedule_rec.bom_revision := p_old_FlowSchedule_rec.bom_revision;
371: END IF;
372:
373: IF l_FlowSchedule_rec.bom_revision_date = FND_API.G_MISS_DATE THEN
374: l_FlowSchedule_rec.bom_revision_date := p_old_FlowSchedule_rec.bom_revision_date;
375: END IF;
376:
377: IF l_FlowSchedule_rec.build_sequence = FND_API.G_MISS_NUM THEN
373: IF l_FlowSchedule_rec.bom_revision_date = FND_API.G_MISS_DATE THEN
374: l_FlowSchedule_rec.bom_revision_date := p_old_FlowSchedule_rec.bom_revision_date;
375: END IF;
376:
377: IF l_FlowSchedule_rec.build_sequence = FND_API.G_MISS_NUM THEN
378: l_FlowSchedule_rec.build_sequence := p_old_FlowSchedule_rec.build_sequence;
379: END IF;
380:
381: IF l_FlowSchedule_rec.class_code = FND_API.G_MISS_CHAR THEN
377: IF l_FlowSchedule_rec.build_sequence = FND_API.G_MISS_NUM THEN
378: l_FlowSchedule_rec.build_sequence := p_old_FlowSchedule_rec.build_sequence;
379: END IF;
380:
381: IF l_FlowSchedule_rec.class_code = FND_API.G_MISS_CHAR THEN
382: l_FlowSchedule_rec.class_code := p_old_FlowSchedule_rec.class_code;
383: END IF;
384:
385: IF l_FlowSchedule_rec.completion_locator_id = FND_API.G_MISS_NUM THEN
381: IF l_FlowSchedule_rec.class_code = FND_API.G_MISS_CHAR THEN
382: l_FlowSchedule_rec.class_code := p_old_FlowSchedule_rec.class_code;
383: END IF;
384:
385: IF l_FlowSchedule_rec.completion_locator_id = FND_API.G_MISS_NUM THEN
386: l_FlowSchedule_rec.completion_locator_id := p_old_FlowSchedule_rec.completion_locator_id;
387: END IF;
388:
389: IF l_FlowSchedule_rec.completion_subinventory = FND_API.G_MISS_CHAR THEN
385: IF l_FlowSchedule_rec.completion_locator_id = FND_API.G_MISS_NUM THEN
386: l_FlowSchedule_rec.completion_locator_id := p_old_FlowSchedule_rec.completion_locator_id;
387: END IF;
388:
389: IF l_FlowSchedule_rec.completion_subinventory = FND_API.G_MISS_CHAR THEN
390: l_FlowSchedule_rec.completion_subinventory := p_old_FlowSchedule_rec.completion_subinventory;
391: END IF;
392:
393: IF l_FlowSchedule_rec.created_by = FND_API.G_MISS_NUM THEN
389: IF l_FlowSchedule_rec.completion_subinventory = FND_API.G_MISS_CHAR THEN
390: l_FlowSchedule_rec.completion_subinventory := p_old_FlowSchedule_rec.completion_subinventory;
391: END IF;
392:
393: IF l_FlowSchedule_rec.created_by = FND_API.G_MISS_NUM THEN
394: l_FlowSchedule_rec.created_by := p_old_FlowSchedule_rec.created_by;
395: END IF;
396:
397: IF l_FlowSchedule_rec.creation_date = FND_API.G_MISS_DATE THEN
393: IF l_FlowSchedule_rec.created_by = FND_API.G_MISS_NUM THEN
394: l_FlowSchedule_rec.created_by := p_old_FlowSchedule_rec.created_by;
395: END IF;
396:
397: IF l_FlowSchedule_rec.creation_date = FND_API.G_MISS_DATE THEN
398: l_FlowSchedule_rec.creation_date := p_old_FlowSchedule_rec.creation_date;
399: END IF;
400:
401: IF l_FlowSchedule_rec.date_closed = FND_API.G_MISS_DATE THEN
397: IF l_FlowSchedule_rec.creation_date = FND_API.G_MISS_DATE THEN
398: l_FlowSchedule_rec.creation_date := p_old_FlowSchedule_rec.creation_date;
399: END IF;
400:
401: IF l_FlowSchedule_rec.date_closed = FND_API.G_MISS_DATE THEN
402: l_FlowSchedule_rec.date_closed := p_old_FlowSchedule_rec.date_closed;
403: END IF;
404:
405: IF l_FlowSchedule_rec.demand_class = FND_API.G_MISS_CHAR THEN
401: IF l_FlowSchedule_rec.date_closed = FND_API.G_MISS_DATE THEN
402: l_FlowSchedule_rec.date_closed := p_old_FlowSchedule_rec.date_closed;
403: END IF;
404:
405: IF l_FlowSchedule_rec.demand_class = FND_API.G_MISS_CHAR THEN
406: l_FlowSchedule_rec.demand_class := p_old_FlowSchedule_rec.demand_class;
407: END IF;
408:
409: IF l_FlowSchedule_rec.demand_source_delivery = FND_API.G_MISS_CHAR THEN
405: IF l_FlowSchedule_rec.demand_class = FND_API.G_MISS_CHAR THEN
406: l_FlowSchedule_rec.demand_class := p_old_FlowSchedule_rec.demand_class;
407: END IF;
408:
409: IF l_FlowSchedule_rec.demand_source_delivery = FND_API.G_MISS_CHAR THEN
410: l_FlowSchedule_rec.demand_source_delivery := p_old_FlowSchedule_rec.demand_source_delivery;
411: END IF;
412:
413: IF l_FlowSchedule_rec.demand_source_header_id = FND_API.G_MISS_NUM THEN
409: IF l_FlowSchedule_rec.demand_source_delivery = FND_API.G_MISS_CHAR THEN
410: l_FlowSchedule_rec.demand_source_delivery := p_old_FlowSchedule_rec.demand_source_delivery;
411: END IF;
412:
413: IF l_FlowSchedule_rec.demand_source_header_id = FND_API.G_MISS_NUM THEN
414: l_FlowSchedule_rec.demand_source_header_id := p_old_FlowSchedule_rec.demand_source_header_id;
415: END IF;
416:
417: IF l_FlowSchedule_rec.demand_source_line = FND_API.G_MISS_CHAR THEN
413: IF l_FlowSchedule_rec.demand_source_header_id = FND_API.G_MISS_NUM THEN
414: l_FlowSchedule_rec.demand_source_header_id := p_old_FlowSchedule_rec.demand_source_header_id;
415: END IF;
416:
417: IF l_FlowSchedule_rec.demand_source_line = FND_API.G_MISS_CHAR THEN
418: l_FlowSchedule_rec.demand_source_line := p_old_FlowSchedule_rec.demand_source_line;
419: END IF;
420:
421: IF l_FlowSchedule_rec.demand_source_type = FND_API.G_MISS_NUM THEN
417: IF l_FlowSchedule_rec.demand_source_line = FND_API.G_MISS_CHAR THEN
418: l_FlowSchedule_rec.demand_source_line := p_old_FlowSchedule_rec.demand_source_line;
419: END IF;
420:
421: IF l_FlowSchedule_rec.demand_source_type = FND_API.G_MISS_NUM THEN
422: l_FlowSchedule_rec.demand_source_type := p_old_FlowSchedule_rec.demand_source_type;
423: END IF;
424:
425: IF l_FlowSchedule_rec.kanban_card_id = FND_API.G_MISS_NUM THEN
421: IF l_FlowSchedule_rec.demand_source_type = FND_API.G_MISS_NUM THEN
422: l_FlowSchedule_rec.demand_source_type := p_old_FlowSchedule_rec.demand_source_type;
423: END IF;
424:
425: IF l_FlowSchedule_rec.kanban_card_id = FND_API.G_MISS_NUM THEN
426: l_FlowSchedule_rec.kanban_card_id := p_old_FlowSchedule_rec.kanban_card_id;
427: END IF;
428:
429: IF l_FlowSchedule_rec.last_updated_by = FND_API.G_MISS_NUM THEN
425: IF l_FlowSchedule_rec.kanban_card_id = FND_API.G_MISS_NUM THEN
426: l_FlowSchedule_rec.kanban_card_id := p_old_FlowSchedule_rec.kanban_card_id;
427: END IF;
428:
429: IF l_FlowSchedule_rec.last_updated_by = FND_API.G_MISS_NUM THEN
430: l_FlowSchedule_rec.last_updated_by := p_old_FlowSchedule_rec.last_updated_by;
431: END IF;
432:
433: IF l_FlowSchedule_rec.last_update_date = FND_API.G_MISS_DATE THEN
429: IF l_FlowSchedule_rec.last_updated_by = FND_API.G_MISS_NUM THEN
430: l_FlowSchedule_rec.last_updated_by := p_old_FlowSchedule_rec.last_updated_by;
431: END IF;
432:
433: IF l_FlowSchedule_rec.last_update_date = FND_API.G_MISS_DATE THEN
434: l_FlowSchedule_rec.last_update_date := p_old_FlowSchedule_rec.last_update_date;
435: END IF;
436:
437: IF l_FlowSchedule_rec.last_update_login = FND_API.G_MISS_NUM THEN
433: IF l_FlowSchedule_rec.last_update_date = FND_API.G_MISS_DATE THEN
434: l_FlowSchedule_rec.last_update_date := p_old_FlowSchedule_rec.last_update_date;
435: END IF;
436:
437: IF l_FlowSchedule_rec.last_update_login = FND_API.G_MISS_NUM THEN
438: l_FlowSchedule_rec.last_update_login := p_old_FlowSchedule_rec.last_update_login;
439: END IF;
440:
441: IF l_FlowSchedule_rec.line_id = FND_API.G_MISS_NUM THEN
437: IF l_FlowSchedule_rec.last_update_login = FND_API.G_MISS_NUM THEN
438: l_FlowSchedule_rec.last_update_login := p_old_FlowSchedule_rec.last_update_login;
439: END IF;
440:
441: IF l_FlowSchedule_rec.line_id = FND_API.G_MISS_NUM THEN
442: l_FlowSchedule_rec.line_id := p_old_FlowSchedule_rec.line_id;
443: END IF;
444:
445: IF l_FlowSchedule_rec.material_account = FND_API.G_MISS_NUM THEN
441: IF l_FlowSchedule_rec.line_id = FND_API.G_MISS_NUM THEN
442: l_FlowSchedule_rec.line_id := p_old_FlowSchedule_rec.line_id;
443: END IF;
444:
445: IF l_FlowSchedule_rec.material_account = FND_API.G_MISS_NUM THEN
446: l_FlowSchedule_rec.material_account := p_old_FlowSchedule_rec.material_account;
447: END IF;
448:
449: IF l_FlowSchedule_rec.material_overhead_account = FND_API.G_MISS_NUM THEN
445: IF l_FlowSchedule_rec.material_account = FND_API.G_MISS_NUM THEN
446: l_FlowSchedule_rec.material_account := p_old_FlowSchedule_rec.material_account;
447: END IF;
448:
449: IF l_FlowSchedule_rec.material_overhead_account = FND_API.G_MISS_NUM THEN
450: l_FlowSchedule_rec.material_overhead_account := p_old_FlowSchedule_rec.material_overhead_account;
451: END IF;
452:
453: IF l_FlowSchedule_rec.material_variance_account = FND_API.G_MISS_NUM THEN
449: IF l_FlowSchedule_rec.material_overhead_account = FND_API.G_MISS_NUM THEN
450: l_FlowSchedule_rec.material_overhead_account := p_old_FlowSchedule_rec.material_overhead_account;
451: END IF;
452:
453: IF l_FlowSchedule_rec.material_variance_account = FND_API.G_MISS_NUM THEN
454: l_FlowSchedule_rec.material_variance_account := p_old_FlowSchedule_rec.material_variance_account;
455: END IF;
456:
457: IF l_FlowSchedule_rec.mps_net_quantity = FND_API.G_MISS_NUM THEN
453: IF l_FlowSchedule_rec.material_variance_account = FND_API.G_MISS_NUM THEN
454: l_FlowSchedule_rec.material_variance_account := p_old_FlowSchedule_rec.material_variance_account;
455: END IF;
456:
457: IF l_FlowSchedule_rec.mps_net_quantity = FND_API.G_MISS_NUM THEN
458: l_FlowSchedule_rec.mps_net_quantity := p_old_FlowSchedule_rec.mps_net_quantity;
459: END IF;
460:
461: IF l_FlowSchedule_rec.mps_scheduled_cpl_date = FND_API.G_MISS_DATE THEN
457: IF l_FlowSchedule_rec.mps_net_quantity = FND_API.G_MISS_NUM THEN
458: l_FlowSchedule_rec.mps_net_quantity := p_old_FlowSchedule_rec.mps_net_quantity;
459: END IF;
460:
461: IF l_FlowSchedule_rec.mps_scheduled_cpl_date = FND_API.G_MISS_DATE THEN
462: l_FlowSchedule_rec.mps_scheduled_cpl_date := p_old_FlowSchedule_rec.mps_scheduled_cpl_date;
463: END IF;
464:
465: IF l_FlowSchedule_rec.organization_id = FND_API.G_MISS_NUM THEN
461: IF l_FlowSchedule_rec.mps_scheduled_cpl_date = FND_API.G_MISS_DATE THEN
462: l_FlowSchedule_rec.mps_scheduled_cpl_date := p_old_FlowSchedule_rec.mps_scheduled_cpl_date;
463: END IF;
464:
465: IF l_FlowSchedule_rec.organization_id = FND_API.G_MISS_NUM THEN
466: l_FlowSchedule_rec.organization_id := p_old_FlowSchedule_rec.organization_id;
467: END IF;
468:
469: IF l_FlowSchedule_rec.osp_account = FND_API.G_MISS_NUM THEN
465: IF l_FlowSchedule_rec.organization_id = FND_API.G_MISS_NUM THEN
466: l_FlowSchedule_rec.organization_id := p_old_FlowSchedule_rec.organization_id;
467: END IF;
468:
469: IF l_FlowSchedule_rec.osp_account = FND_API.G_MISS_NUM THEN
470: l_FlowSchedule_rec.osp_account := p_old_FlowSchedule_rec.osp_account;
471: END IF;
472:
473: IF l_FlowSchedule_rec.osp_variance_account = FND_API.G_MISS_NUM THEN
469: IF l_FlowSchedule_rec.osp_account = FND_API.G_MISS_NUM THEN
470: l_FlowSchedule_rec.osp_account := p_old_FlowSchedule_rec.osp_account;
471: END IF;
472:
473: IF l_FlowSchedule_rec.osp_variance_account = FND_API.G_MISS_NUM THEN
474: l_FlowSchedule_rec.osp_variance_account := p_old_FlowSchedule_rec.osp_variance_account;
475: END IF;
476:
477: IF l_FlowSchedule_rec.overhead_account = FND_API.G_MISS_NUM THEN
473: IF l_FlowSchedule_rec.osp_variance_account = FND_API.G_MISS_NUM THEN
474: l_FlowSchedule_rec.osp_variance_account := p_old_FlowSchedule_rec.osp_variance_account;
475: END IF;
476:
477: IF l_FlowSchedule_rec.overhead_account = FND_API.G_MISS_NUM THEN
478: l_FlowSchedule_rec.overhead_account := p_old_FlowSchedule_rec.overhead_account;
479: END IF;
480:
481: IF l_FlowSchedule_rec.overhead_variance_account = FND_API.G_MISS_NUM THEN
477: IF l_FlowSchedule_rec.overhead_account = FND_API.G_MISS_NUM THEN
478: l_FlowSchedule_rec.overhead_account := p_old_FlowSchedule_rec.overhead_account;
479: END IF;
480:
481: IF l_FlowSchedule_rec.overhead_variance_account = FND_API.G_MISS_NUM THEN
482: l_FlowSchedule_rec.overhead_variance_account := p_old_FlowSchedule_rec.overhead_variance_account;
483: END IF;
484:
485: IF l_FlowSchedule_rec.planned_quantity = FND_API.G_MISS_NUM THEN
481: IF l_FlowSchedule_rec.overhead_variance_account = FND_API.G_MISS_NUM THEN
482: l_FlowSchedule_rec.overhead_variance_account := p_old_FlowSchedule_rec.overhead_variance_account;
483: END IF;
484:
485: IF l_FlowSchedule_rec.planned_quantity = FND_API.G_MISS_NUM THEN
486: l_FlowSchedule_rec.planned_quantity := p_old_FlowSchedule_rec.planned_quantity;
487: END IF;
488:
489: IF l_FlowSchedule_rec.primary_item_id = FND_API.G_MISS_NUM THEN
485: IF l_FlowSchedule_rec.planned_quantity = FND_API.G_MISS_NUM THEN
486: l_FlowSchedule_rec.planned_quantity := p_old_FlowSchedule_rec.planned_quantity;
487: END IF;
488:
489: IF l_FlowSchedule_rec.primary_item_id = FND_API.G_MISS_NUM THEN
490: l_FlowSchedule_rec.primary_item_id := p_old_FlowSchedule_rec.primary_item_id;
491: END IF;
492:
493: IF l_FlowSchedule_rec.program_application_id = FND_API.G_MISS_NUM THEN
489: IF l_FlowSchedule_rec.primary_item_id = FND_API.G_MISS_NUM THEN
490: l_FlowSchedule_rec.primary_item_id := p_old_FlowSchedule_rec.primary_item_id;
491: END IF;
492:
493: IF l_FlowSchedule_rec.program_application_id = FND_API.G_MISS_NUM THEN
494: l_FlowSchedule_rec.program_application_id := p_old_FlowSchedule_rec.program_application_id;
495: END IF;
496:
497: IF l_FlowSchedule_rec.program_id = FND_API.G_MISS_NUM THEN
493: IF l_FlowSchedule_rec.program_application_id = FND_API.G_MISS_NUM THEN
494: l_FlowSchedule_rec.program_application_id := p_old_FlowSchedule_rec.program_application_id;
495: END IF;
496:
497: IF l_FlowSchedule_rec.program_id = FND_API.G_MISS_NUM THEN
498: l_FlowSchedule_rec.program_id := p_old_FlowSchedule_rec.program_id;
499: END IF;
500:
501: IF l_FlowSchedule_rec.program_update_date = FND_API.G_MISS_DATE THEN
497: IF l_FlowSchedule_rec.program_id = FND_API.G_MISS_NUM THEN
498: l_FlowSchedule_rec.program_id := p_old_FlowSchedule_rec.program_id;
499: END IF;
500:
501: IF l_FlowSchedule_rec.program_update_date = FND_API.G_MISS_DATE THEN
502: l_FlowSchedule_rec.program_update_date := p_old_FlowSchedule_rec.program_update_date;
503: END IF;
504:
505: IF l_FlowSchedule_rec.project_id = FND_API.G_MISS_NUM THEN
501: IF l_FlowSchedule_rec.program_update_date = FND_API.G_MISS_DATE THEN
502: l_FlowSchedule_rec.program_update_date := p_old_FlowSchedule_rec.program_update_date;
503: END IF;
504:
505: IF l_FlowSchedule_rec.project_id = FND_API.G_MISS_NUM THEN
506: l_FlowSchedule_rec.project_id := p_old_FlowSchedule_rec.project_id;
507: END IF;
508:
509: IF l_FlowSchedule_rec.quantity_completed = FND_API.G_MISS_NUM THEN
505: IF l_FlowSchedule_rec.project_id = FND_API.G_MISS_NUM THEN
506: l_FlowSchedule_rec.project_id := p_old_FlowSchedule_rec.project_id;
507: END IF;
508:
509: IF l_FlowSchedule_rec.quantity_completed = FND_API.G_MISS_NUM THEN
510: l_FlowSchedule_rec.quantity_completed := p_old_FlowSchedule_rec.quantity_completed;
511: END IF;
512:
513: IF l_FlowSchedule_rec.request_id = FND_API.G_MISS_NUM THEN
509: IF l_FlowSchedule_rec.quantity_completed = FND_API.G_MISS_NUM THEN
510: l_FlowSchedule_rec.quantity_completed := p_old_FlowSchedule_rec.quantity_completed;
511: END IF;
512:
513: IF l_FlowSchedule_rec.request_id = FND_API.G_MISS_NUM THEN
514: l_FlowSchedule_rec.request_id := p_old_FlowSchedule_rec.request_id;
515: END IF;
516:
517: IF l_FlowSchedule_rec.resource_account = FND_API.G_MISS_NUM THEN
513: IF l_FlowSchedule_rec.request_id = FND_API.G_MISS_NUM THEN
514: l_FlowSchedule_rec.request_id := p_old_FlowSchedule_rec.request_id;
515: END IF;
516:
517: IF l_FlowSchedule_rec.resource_account = FND_API.G_MISS_NUM THEN
518: l_FlowSchedule_rec.resource_account := p_old_FlowSchedule_rec.resource_account;
519: END IF;
520:
521: IF l_FlowSchedule_rec.resource_variance_account = FND_API.G_MISS_NUM THEN
517: IF l_FlowSchedule_rec.resource_account = FND_API.G_MISS_NUM THEN
518: l_FlowSchedule_rec.resource_account := p_old_FlowSchedule_rec.resource_account;
519: END IF;
520:
521: IF l_FlowSchedule_rec.resource_variance_account = FND_API.G_MISS_NUM THEN
522: l_FlowSchedule_rec.resource_variance_account := p_old_FlowSchedule_rec.resource_variance_account;
523: END IF;
524:
525: IF l_FlowSchedule_rec.routing_revision = FND_API.G_MISS_CHAR THEN
521: IF l_FlowSchedule_rec.resource_variance_account = FND_API.G_MISS_NUM THEN
522: l_FlowSchedule_rec.resource_variance_account := p_old_FlowSchedule_rec.resource_variance_account;
523: END IF;
524:
525: IF l_FlowSchedule_rec.routing_revision = FND_API.G_MISS_CHAR THEN
526: l_FlowSchedule_rec.routing_revision := p_old_FlowSchedule_rec.routing_revision;
527: END IF;
528:
529: IF l_FlowSchedule_rec.routing_revision_date = FND_API.G_MISS_DATE THEN
525: IF l_FlowSchedule_rec.routing_revision = FND_API.G_MISS_CHAR THEN
526: l_FlowSchedule_rec.routing_revision := p_old_FlowSchedule_rec.routing_revision;
527: END IF;
528:
529: IF l_FlowSchedule_rec.routing_revision_date = FND_API.G_MISS_DATE THEN
530: l_FlowSchedule_rec.routing_revision_date := p_old_FlowSchedule_rec.routing_revision_date;
531: END IF;
532:
533: IF l_FlowSchedule_rec.scheduled_completion_date = FND_API.G_MISS_DATE THEN
529: IF l_FlowSchedule_rec.routing_revision_date = FND_API.G_MISS_DATE THEN
530: l_FlowSchedule_rec.routing_revision_date := p_old_FlowSchedule_rec.routing_revision_date;
531: END IF;
532:
533: IF l_FlowSchedule_rec.scheduled_completion_date = FND_API.G_MISS_DATE THEN
534: l_FlowSchedule_rec.scheduled_completion_date := p_old_FlowSchedule_rec.scheduled_completion_date;
535: END IF;
536:
537: IF l_FlowSchedule_rec.scheduled_flag = FND_API.G_MISS_NUM THEN
533: IF l_FlowSchedule_rec.scheduled_completion_date = FND_API.G_MISS_DATE THEN
534: l_FlowSchedule_rec.scheduled_completion_date := p_old_FlowSchedule_rec.scheduled_completion_date;
535: END IF;
536:
537: IF l_FlowSchedule_rec.scheduled_flag = FND_API.G_MISS_NUM THEN
538: l_FlowSchedule_rec.scheduled_flag := p_old_FlowSchedule_rec.scheduled_flag;
539: END IF;
540:
541: IF l_FlowSchedule_rec.scheduled_start_date = FND_API.G_MISS_DATE THEN
537: IF l_FlowSchedule_rec.scheduled_flag = FND_API.G_MISS_NUM THEN
538: l_FlowSchedule_rec.scheduled_flag := p_old_FlowSchedule_rec.scheduled_flag;
539: END IF;
540:
541: IF l_FlowSchedule_rec.scheduled_start_date = FND_API.G_MISS_DATE THEN
542: l_FlowSchedule_rec.scheduled_start_date := p_old_FlowSchedule_rec.scheduled_start_date;
543: END IF;
544:
545: IF l_FlowSchedule_rec.schedule_group_id = FND_API.G_MISS_NUM THEN
541: IF l_FlowSchedule_rec.scheduled_start_date = FND_API.G_MISS_DATE THEN
542: l_FlowSchedule_rec.scheduled_start_date := p_old_FlowSchedule_rec.scheduled_start_date;
543: END IF;
544:
545: IF l_FlowSchedule_rec.schedule_group_id = FND_API.G_MISS_NUM THEN
546: l_FlowSchedule_rec.schedule_group_id := p_old_FlowSchedule_rec.schedule_group_id;
547: END IF;
548:
549: IF l_FlowSchedule_rec.schedule_number = FND_API.G_MISS_CHAR THEN
545: IF l_FlowSchedule_rec.schedule_group_id = FND_API.G_MISS_NUM THEN
546: l_FlowSchedule_rec.schedule_group_id := p_old_FlowSchedule_rec.schedule_group_id;
547: END IF;
548:
549: IF l_FlowSchedule_rec.schedule_number = FND_API.G_MISS_CHAR THEN
550: l_FlowSchedule_rec.schedule_number := p_old_FlowSchedule_rec.schedule_number;
551: END IF;
552:
553: IF l_FlowSchedule_rec.status = FND_API.G_MISS_NUM THEN
549: IF l_FlowSchedule_rec.schedule_number = FND_API.G_MISS_CHAR THEN
550: l_FlowSchedule_rec.schedule_number := p_old_FlowSchedule_rec.schedule_number;
551: END IF;
552:
553: IF l_FlowSchedule_rec.status = FND_API.G_MISS_NUM THEN
554: l_FlowSchedule_rec.status := p_old_FlowSchedule_rec.status;
555: END IF;
556:
557: IF l_FlowSchedule_rec.std_cost_adj_account = FND_API.G_MISS_NUM THEN
553: IF l_FlowSchedule_rec.status = FND_API.G_MISS_NUM THEN
554: l_FlowSchedule_rec.status := p_old_FlowSchedule_rec.status;
555: END IF;
556:
557: IF l_FlowSchedule_rec.std_cost_adj_account = FND_API.G_MISS_NUM THEN
558: l_FlowSchedule_rec.std_cost_adj_account := p_old_FlowSchedule_rec.std_cost_adj_account;
559: END IF;
560:
561: IF l_FlowSchedule_rec.task_id = FND_API.G_MISS_NUM THEN
557: IF l_FlowSchedule_rec.std_cost_adj_account = FND_API.G_MISS_NUM THEN
558: l_FlowSchedule_rec.std_cost_adj_account := p_old_FlowSchedule_rec.std_cost_adj_account;
559: END IF;
560:
561: IF l_FlowSchedule_rec.task_id = FND_API.G_MISS_NUM THEN
562: l_FlowSchedule_rec.task_id := p_old_FlowSchedule_rec.task_id;
563: END IF;
564:
565: IF l_FlowSchedule_rec.wip_entity_id = FND_API.G_MISS_NUM THEN
561: IF l_FlowSchedule_rec.task_id = FND_API.G_MISS_NUM THEN
562: l_FlowSchedule_rec.task_id := p_old_FlowSchedule_rec.task_id;
563: END IF;
564:
565: IF l_FlowSchedule_rec.wip_entity_id = FND_API.G_MISS_NUM THEN
566: l_FlowSchedule_rec.wip_entity_id := p_old_FlowSchedule_rec.wip_entity_id;
567: END IF;
568: END IF;
569:
579: IS
580: l_FlowSchedule_rec WIP_Work_Order_PUB.Flowschedule_Rec_Type := p_FlowSchedule_rec;
581: BEGIN
582:
583: IF l_FlowSchedule_rec.alternate_bom_designator = FND_API.G_MISS_CHAR THEN
584: l_FlowSchedule_rec.alternate_bom_designator := NULL;
585: END IF;
586:
587: IF l_FlowSchedule_rec.alternate_rout_designator = FND_API.G_MISS_CHAR THEN
583: IF l_FlowSchedule_rec.alternate_bom_designator = FND_API.G_MISS_CHAR THEN
584: l_FlowSchedule_rec.alternate_bom_designator := NULL;
585: END IF;
586:
587: IF l_FlowSchedule_rec.alternate_rout_designator = FND_API.G_MISS_CHAR THEN
588: l_FlowSchedule_rec.alternate_rout_designator := NULL;
589: END IF;
590:
591: IF l_FlowSchedule_rec.attribute1 = FND_API.G_MISS_CHAR THEN
587: IF l_FlowSchedule_rec.alternate_rout_designator = FND_API.G_MISS_CHAR THEN
588: l_FlowSchedule_rec.alternate_rout_designator := NULL;
589: END IF;
590:
591: IF l_FlowSchedule_rec.attribute1 = FND_API.G_MISS_CHAR THEN
592: l_FlowSchedule_rec.attribute1 := NULL;
593: END IF;
594:
595: IF l_FlowSchedule_rec.attribute10 = FND_API.G_MISS_CHAR THEN
591: IF l_FlowSchedule_rec.attribute1 = FND_API.G_MISS_CHAR THEN
592: l_FlowSchedule_rec.attribute1 := NULL;
593: END IF;
594:
595: IF l_FlowSchedule_rec.attribute10 = FND_API.G_MISS_CHAR THEN
596: l_FlowSchedule_rec.attribute10 := NULL;
597: END IF;
598:
599: IF l_FlowSchedule_rec.attribute11 = FND_API.G_MISS_CHAR THEN
595: IF l_FlowSchedule_rec.attribute10 = FND_API.G_MISS_CHAR THEN
596: l_FlowSchedule_rec.attribute10 := NULL;
597: END IF;
598:
599: IF l_FlowSchedule_rec.attribute11 = FND_API.G_MISS_CHAR THEN
600: l_FlowSchedule_rec.attribute11 := NULL;
601: END IF;
602:
603: IF l_FlowSchedule_rec.attribute12 = FND_API.G_MISS_CHAR THEN
599: IF l_FlowSchedule_rec.attribute11 = FND_API.G_MISS_CHAR THEN
600: l_FlowSchedule_rec.attribute11 := NULL;
601: END IF;
602:
603: IF l_FlowSchedule_rec.attribute12 = FND_API.G_MISS_CHAR THEN
604: l_FlowSchedule_rec.attribute12 := NULL;
605: END IF;
606:
607: IF l_FlowSchedule_rec.attribute13 = FND_API.G_MISS_CHAR THEN
603: IF l_FlowSchedule_rec.attribute12 = FND_API.G_MISS_CHAR THEN
604: l_FlowSchedule_rec.attribute12 := NULL;
605: END IF;
606:
607: IF l_FlowSchedule_rec.attribute13 = FND_API.G_MISS_CHAR THEN
608: l_FlowSchedule_rec.attribute13 := NULL;
609: END IF;
610:
611: IF l_FlowSchedule_rec.attribute14 = FND_API.G_MISS_CHAR THEN
607: IF l_FlowSchedule_rec.attribute13 = FND_API.G_MISS_CHAR THEN
608: l_FlowSchedule_rec.attribute13 := NULL;
609: END IF;
610:
611: IF l_FlowSchedule_rec.attribute14 = FND_API.G_MISS_CHAR THEN
612: l_FlowSchedule_rec.attribute14 := NULL;
613: END IF;
614:
615: IF l_FlowSchedule_rec.attribute15 = FND_API.G_MISS_CHAR THEN
611: IF l_FlowSchedule_rec.attribute14 = FND_API.G_MISS_CHAR THEN
612: l_FlowSchedule_rec.attribute14 := NULL;
613: END IF;
614:
615: IF l_FlowSchedule_rec.attribute15 = FND_API.G_MISS_CHAR THEN
616: l_FlowSchedule_rec.attribute15 := NULL;
617: END IF;
618:
619: IF l_FlowSchedule_rec.attribute2 = FND_API.G_MISS_CHAR THEN
615: IF l_FlowSchedule_rec.attribute15 = FND_API.G_MISS_CHAR THEN
616: l_FlowSchedule_rec.attribute15 := NULL;
617: END IF;
618:
619: IF l_FlowSchedule_rec.attribute2 = FND_API.G_MISS_CHAR THEN
620: l_FlowSchedule_rec.attribute2 := NULL;
621: END IF;
622:
623: IF l_FlowSchedule_rec.attribute3 = FND_API.G_MISS_CHAR THEN
619: IF l_FlowSchedule_rec.attribute2 = FND_API.G_MISS_CHAR THEN
620: l_FlowSchedule_rec.attribute2 := NULL;
621: END IF;
622:
623: IF l_FlowSchedule_rec.attribute3 = FND_API.G_MISS_CHAR THEN
624: l_FlowSchedule_rec.attribute3 := NULL;
625: END IF;
626:
627: IF l_FlowSchedule_rec.attribute4 = FND_API.G_MISS_CHAR THEN
623: IF l_FlowSchedule_rec.attribute3 = FND_API.G_MISS_CHAR THEN
624: l_FlowSchedule_rec.attribute3 := NULL;
625: END IF;
626:
627: IF l_FlowSchedule_rec.attribute4 = FND_API.G_MISS_CHAR THEN
628: l_FlowSchedule_rec.attribute4 := NULL;
629: END IF;
630:
631: IF l_FlowSchedule_rec.attribute5 = FND_API.G_MISS_CHAR THEN
627: IF l_FlowSchedule_rec.attribute4 = FND_API.G_MISS_CHAR THEN
628: l_FlowSchedule_rec.attribute4 := NULL;
629: END IF;
630:
631: IF l_FlowSchedule_rec.attribute5 = FND_API.G_MISS_CHAR THEN
632: l_FlowSchedule_rec.attribute5 := NULL;
633: END IF;
634:
635: IF l_FlowSchedule_rec.attribute6 = FND_API.G_MISS_CHAR THEN
631: IF l_FlowSchedule_rec.attribute5 = FND_API.G_MISS_CHAR THEN
632: l_FlowSchedule_rec.attribute5 := NULL;
633: END IF;
634:
635: IF l_FlowSchedule_rec.attribute6 = FND_API.G_MISS_CHAR THEN
636: l_FlowSchedule_rec.attribute6 := NULL;
637: END IF;
638:
639: IF l_FlowSchedule_rec.attribute7 = FND_API.G_MISS_CHAR THEN
635: IF l_FlowSchedule_rec.attribute6 = FND_API.G_MISS_CHAR THEN
636: l_FlowSchedule_rec.attribute6 := NULL;
637: END IF;
638:
639: IF l_FlowSchedule_rec.attribute7 = FND_API.G_MISS_CHAR THEN
640: l_FlowSchedule_rec.attribute7 := NULL;
641: END IF;
642:
643: IF l_FlowSchedule_rec.attribute8 = FND_API.G_MISS_CHAR THEN
639: IF l_FlowSchedule_rec.attribute7 = FND_API.G_MISS_CHAR THEN
640: l_FlowSchedule_rec.attribute7 := NULL;
641: END IF;
642:
643: IF l_FlowSchedule_rec.attribute8 = FND_API.G_MISS_CHAR THEN
644: l_FlowSchedule_rec.attribute8 := NULL;
645: END IF;
646:
647: IF l_FlowSchedule_rec.attribute9 = FND_API.G_MISS_CHAR THEN
643: IF l_FlowSchedule_rec.attribute8 = FND_API.G_MISS_CHAR THEN
644: l_FlowSchedule_rec.attribute8 := NULL;
645: END IF;
646:
647: IF l_FlowSchedule_rec.attribute9 = FND_API.G_MISS_CHAR THEN
648: l_FlowSchedule_rec.attribute9 := NULL;
649: END IF;
650:
651: IF l_FlowSchedule_rec.attribute_category = FND_API.G_MISS_CHAR THEN
647: IF l_FlowSchedule_rec.attribute9 = FND_API.G_MISS_CHAR THEN
648: l_FlowSchedule_rec.attribute9 := NULL;
649: END IF;
650:
651: IF l_FlowSchedule_rec.attribute_category = FND_API.G_MISS_CHAR THEN
652: l_FlowSchedule_rec.attribute_category := NULL;
653: END IF;
654:
655: IF l_FlowSchedule_rec.bom_revision = FND_API.G_MISS_CHAR THEN
651: IF l_FlowSchedule_rec.attribute_category = FND_API.G_MISS_CHAR THEN
652: l_FlowSchedule_rec.attribute_category := NULL;
653: END IF;
654:
655: IF l_FlowSchedule_rec.bom_revision = FND_API.G_MISS_CHAR THEN
656: l_FlowSchedule_rec.bom_revision := NULL;
657: END IF;
658:
659: IF l_FlowSchedule_rec.bom_revision_date = FND_API.G_MISS_DATE THEN
655: IF l_FlowSchedule_rec.bom_revision = FND_API.G_MISS_CHAR THEN
656: l_FlowSchedule_rec.bom_revision := NULL;
657: END IF;
658:
659: IF l_FlowSchedule_rec.bom_revision_date = FND_API.G_MISS_DATE THEN
660: l_FlowSchedule_rec.bom_revision_date := NULL;
661: END IF;
662:
663: IF l_FlowSchedule_rec.build_sequence = FND_API.G_MISS_NUM THEN
659: IF l_FlowSchedule_rec.bom_revision_date = FND_API.G_MISS_DATE THEN
660: l_FlowSchedule_rec.bom_revision_date := NULL;
661: END IF;
662:
663: IF l_FlowSchedule_rec.build_sequence = FND_API.G_MISS_NUM THEN
664: l_FlowSchedule_rec.build_sequence := NULL;
665: END IF;
666:
667: IF l_FlowSchedule_rec.class_code = FND_API.G_MISS_CHAR THEN
663: IF l_FlowSchedule_rec.build_sequence = FND_API.G_MISS_NUM THEN
664: l_FlowSchedule_rec.build_sequence := NULL;
665: END IF;
666:
667: IF l_FlowSchedule_rec.class_code = FND_API.G_MISS_CHAR THEN
668: l_FlowSchedule_rec.class_code := NULL;
669: END IF;
670:
671: IF l_FlowSchedule_rec.completion_locator_id = FND_API.G_MISS_NUM THEN
667: IF l_FlowSchedule_rec.class_code = FND_API.G_MISS_CHAR THEN
668: l_FlowSchedule_rec.class_code := NULL;
669: END IF;
670:
671: IF l_FlowSchedule_rec.completion_locator_id = FND_API.G_MISS_NUM THEN
672: l_FlowSchedule_rec.completion_locator_id := NULL;
673: END IF;
674:
675: IF l_FlowSchedule_rec.completion_subinventory = FND_API.G_MISS_CHAR THEN
671: IF l_FlowSchedule_rec.completion_locator_id = FND_API.G_MISS_NUM THEN
672: l_FlowSchedule_rec.completion_locator_id := NULL;
673: END IF;
674:
675: IF l_FlowSchedule_rec.completion_subinventory = FND_API.G_MISS_CHAR THEN
676: l_FlowSchedule_rec.completion_subinventory := NULL;
677: END IF;
678:
679: IF l_FlowSchedule_rec.created_by = FND_API.G_MISS_NUM THEN
675: IF l_FlowSchedule_rec.completion_subinventory = FND_API.G_MISS_CHAR THEN
676: l_FlowSchedule_rec.completion_subinventory := NULL;
677: END IF;
678:
679: IF l_FlowSchedule_rec.created_by = FND_API.G_MISS_NUM THEN
680: l_FlowSchedule_rec.created_by := NULL;
681: END IF;
682:
683: IF l_FlowSchedule_rec.creation_date = FND_API.G_MISS_DATE THEN
679: IF l_FlowSchedule_rec.created_by = FND_API.G_MISS_NUM THEN
680: l_FlowSchedule_rec.created_by := NULL;
681: END IF;
682:
683: IF l_FlowSchedule_rec.creation_date = FND_API.G_MISS_DATE THEN
684: l_FlowSchedule_rec.creation_date := NULL;
685: END IF;
686:
687: IF l_FlowSchedule_rec.date_closed = FND_API.G_MISS_DATE THEN
683: IF l_FlowSchedule_rec.creation_date = FND_API.G_MISS_DATE THEN
684: l_FlowSchedule_rec.creation_date := NULL;
685: END IF;
686:
687: IF l_FlowSchedule_rec.date_closed = FND_API.G_MISS_DATE THEN
688: l_FlowSchedule_rec.date_closed := NULL;
689: END IF;
690:
691: IF l_FlowSchedule_rec.demand_class = FND_API.G_MISS_CHAR THEN
687: IF l_FlowSchedule_rec.date_closed = FND_API.G_MISS_DATE THEN
688: l_FlowSchedule_rec.date_closed := NULL;
689: END IF;
690:
691: IF l_FlowSchedule_rec.demand_class = FND_API.G_MISS_CHAR THEN
692: l_FlowSchedule_rec.demand_class := NULL;
693: END IF;
694:
695: IF l_FlowSchedule_rec.demand_source_delivery = FND_API.G_MISS_CHAR THEN
691: IF l_FlowSchedule_rec.demand_class = FND_API.G_MISS_CHAR THEN
692: l_FlowSchedule_rec.demand_class := NULL;
693: END IF;
694:
695: IF l_FlowSchedule_rec.demand_source_delivery = FND_API.G_MISS_CHAR THEN
696: l_FlowSchedule_rec.demand_source_delivery := NULL;
697: END IF;
698:
699: IF l_FlowSchedule_rec.demand_source_header_id = FND_API.G_MISS_NUM THEN
695: IF l_FlowSchedule_rec.demand_source_delivery = FND_API.G_MISS_CHAR THEN
696: l_FlowSchedule_rec.demand_source_delivery := NULL;
697: END IF;
698:
699: IF l_FlowSchedule_rec.demand_source_header_id = FND_API.G_MISS_NUM THEN
700: l_FlowSchedule_rec.demand_source_header_id := NULL;
701: END IF;
702:
703: IF l_FlowSchedule_rec.demand_source_line = FND_API.G_MISS_CHAR THEN
699: IF l_FlowSchedule_rec.demand_source_header_id = FND_API.G_MISS_NUM THEN
700: l_FlowSchedule_rec.demand_source_header_id := NULL;
701: END IF;
702:
703: IF l_FlowSchedule_rec.demand_source_line = FND_API.G_MISS_CHAR THEN
704: l_FlowSchedule_rec.demand_source_line := NULL;
705: END IF;
706:
707: IF l_FlowSchedule_rec.demand_source_type = FND_API.G_MISS_NUM THEN
703: IF l_FlowSchedule_rec.demand_source_line = FND_API.G_MISS_CHAR THEN
704: l_FlowSchedule_rec.demand_source_line := NULL;
705: END IF;
706:
707: IF l_FlowSchedule_rec.demand_source_type = FND_API.G_MISS_NUM THEN
708: l_FlowSchedule_rec.demand_source_type := NULL;
709: END IF;
710:
711: IF l_FlowSchedule_rec.kanban_card_id = FND_API.G_MISS_NUM THEN
707: IF l_FlowSchedule_rec.demand_source_type = FND_API.G_MISS_NUM THEN
708: l_FlowSchedule_rec.demand_source_type := NULL;
709: END IF;
710:
711: IF l_FlowSchedule_rec.kanban_card_id = FND_API.G_MISS_NUM THEN
712: l_FlowSchedule_rec.kanban_card_id := NULL;
713: END IF;
714:
715: IF l_FlowSchedule_rec.last_updated_by = FND_API.G_MISS_NUM THEN
711: IF l_FlowSchedule_rec.kanban_card_id = FND_API.G_MISS_NUM THEN
712: l_FlowSchedule_rec.kanban_card_id := NULL;
713: END IF;
714:
715: IF l_FlowSchedule_rec.last_updated_by = FND_API.G_MISS_NUM THEN
716: l_FlowSchedule_rec.last_updated_by := NULL;
717: END IF;
718:
719: IF l_FlowSchedule_rec.last_update_date = FND_API.G_MISS_DATE THEN
715: IF l_FlowSchedule_rec.last_updated_by = FND_API.G_MISS_NUM THEN
716: l_FlowSchedule_rec.last_updated_by := NULL;
717: END IF;
718:
719: IF l_FlowSchedule_rec.last_update_date = FND_API.G_MISS_DATE THEN
720: l_FlowSchedule_rec.last_update_date := NULL;
721: END IF;
722:
723: IF l_FlowSchedule_rec.last_update_login = FND_API.G_MISS_NUM THEN
719: IF l_FlowSchedule_rec.last_update_date = FND_API.G_MISS_DATE THEN
720: l_FlowSchedule_rec.last_update_date := NULL;
721: END IF;
722:
723: IF l_FlowSchedule_rec.last_update_login = FND_API.G_MISS_NUM THEN
724: l_FlowSchedule_rec.last_update_login := NULL;
725: END IF;
726:
727: IF l_FlowSchedule_rec.line_id = FND_API.G_MISS_NUM THEN
723: IF l_FlowSchedule_rec.last_update_login = FND_API.G_MISS_NUM THEN
724: l_FlowSchedule_rec.last_update_login := NULL;
725: END IF;
726:
727: IF l_FlowSchedule_rec.line_id = FND_API.G_MISS_NUM THEN
728: l_FlowSchedule_rec.line_id := NULL;
729: END IF;
730:
731: IF l_FlowSchedule_rec.material_account = FND_API.G_MISS_NUM THEN
727: IF l_FlowSchedule_rec.line_id = FND_API.G_MISS_NUM THEN
728: l_FlowSchedule_rec.line_id := NULL;
729: END IF;
730:
731: IF l_FlowSchedule_rec.material_account = FND_API.G_MISS_NUM THEN
732: l_FlowSchedule_rec.material_account := NULL;
733: END IF;
734:
735: IF l_FlowSchedule_rec.material_overhead_account = FND_API.G_MISS_NUM THEN
731: IF l_FlowSchedule_rec.material_account = FND_API.G_MISS_NUM THEN
732: l_FlowSchedule_rec.material_account := NULL;
733: END IF;
734:
735: IF l_FlowSchedule_rec.material_overhead_account = FND_API.G_MISS_NUM THEN
736: l_FlowSchedule_rec.material_overhead_account := NULL;
737: END IF;
738:
739: IF l_FlowSchedule_rec.material_variance_account = FND_API.G_MISS_NUM THEN
735: IF l_FlowSchedule_rec.material_overhead_account = FND_API.G_MISS_NUM THEN
736: l_FlowSchedule_rec.material_overhead_account := NULL;
737: END IF;
738:
739: IF l_FlowSchedule_rec.material_variance_account = FND_API.G_MISS_NUM THEN
740: l_FlowSchedule_rec.material_variance_account := NULL;
741: END IF;
742:
743: IF l_FlowSchedule_rec.mps_net_quantity = FND_API.G_MISS_NUM THEN
739: IF l_FlowSchedule_rec.material_variance_account = FND_API.G_MISS_NUM THEN
740: l_FlowSchedule_rec.material_variance_account := NULL;
741: END IF;
742:
743: IF l_FlowSchedule_rec.mps_net_quantity = FND_API.G_MISS_NUM THEN
744: l_FlowSchedule_rec.mps_net_quantity := NULL;
745: END IF;
746:
747: IF l_FlowSchedule_rec.mps_scheduled_cpl_date = FND_API.G_MISS_DATE THEN
743: IF l_FlowSchedule_rec.mps_net_quantity = FND_API.G_MISS_NUM THEN
744: l_FlowSchedule_rec.mps_net_quantity := NULL;
745: END IF;
746:
747: IF l_FlowSchedule_rec.mps_scheduled_cpl_date = FND_API.G_MISS_DATE THEN
748: l_FlowSchedule_rec.mps_scheduled_cpl_date := NULL;
749: END IF;
750:
751: IF l_FlowSchedule_rec.organization_id = FND_API.G_MISS_NUM THEN
747: IF l_FlowSchedule_rec.mps_scheduled_cpl_date = FND_API.G_MISS_DATE THEN
748: l_FlowSchedule_rec.mps_scheduled_cpl_date := NULL;
749: END IF;
750:
751: IF l_FlowSchedule_rec.organization_id = FND_API.G_MISS_NUM THEN
752: l_FlowSchedule_rec.organization_id := NULL;
753: END IF;
754:
755: IF l_FlowSchedule_rec.osp_account = FND_API.G_MISS_NUM THEN
751: IF l_FlowSchedule_rec.organization_id = FND_API.G_MISS_NUM THEN
752: l_FlowSchedule_rec.organization_id := NULL;
753: END IF;
754:
755: IF l_FlowSchedule_rec.osp_account = FND_API.G_MISS_NUM THEN
756: l_FlowSchedule_rec.osp_account := NULL;
757: END IF;
758:
759: IF l_FlowSchedule_rec.osp_variance_account = FND_API.G_MISS_NUM THEN
755: IF l_FlowSchedule_rec.osp_account = FND_API.G_MISS_NUM THEN
756: l_FlowSchedule_rec.osp_account := NULL;
757: END IF;
758:
759: IF l_FlowSchedule_rec.osp_variance_account = FND_API.G_MISS_NUM THEN
760: l_FlowSchedule_rec.osp_variance_account := NULL;
761: END IF;
762:
763: IF l_FlowSchedule_rec.overhead_account = FND_API.G_MISS_NUM THEN
759: IF l_FlowSchedule_rec.osp_variance_account = FND_API.G_MISS_NUM THEN
760: l_FlowSchedule_rec.osp_variance_account := NULL;
761: END IF;
762:
763: IF l_FlowSchedule_rec.overhead_account = FND_API.G_MISS_NUM THEN
764: l_FlowSchedule_rec.overhead_account := NULL;
765: END IF;
766:
767: IF l_FlowSchedule_rec.overhead_variance_account = FND_API.G_MISS_NUM THEN
763: IF l_FlowSchedule_rec.overhead_account = FND_API.G_MISS_NUM THEN
764: l_FlowSchedule_rec.overhead_account := NULL;
765: END IF;
766:
767: IF l_FlowSchedule_rec.overhead_variance_account = FND_API.G_MISS_NUM THEN
768: l_FlowSchedule_rec.overhead_variance_account := NULL;
769: END IF;
770:
771: IF l_FlowSchedule_rec.planned_quantity = FND_API.G_MISS_NUM THEN
767: IF l_FlowSchedule_rec.overhead_variance_account = FND_API.G_MISS_NUM THEN
768: l_FlowSchedule_rec.overhead_variance_account := NULL;
769: END IF;
770:
771: IF l_FlowSchedule_rec.planned_quantity = FND_API.G_MISS_NUM THEN
772: l_FlowSchedule_rec.planned_quantity := NULL;
773: END IF;
774:
775: IF l_FlowSchedule_rec.primary_item_id = FND_API.G_MISS_NUM THEN
771: IF l_FlowSchedule_rec.planned_quantity = FND_API.G_MISS_NUM THEN
772: l_FlowSchedule_rec.planned_quantity := NULL;
773: END IF;
774:
775: IF l_FlowSchedule_rec.primary_item_id = FND_API.G_MISS_NUM THEN
776: l_FlowSchedule_rec.primary_item_id := NULL;
777: END IF;
778:
779: IF l_FlowSchedule_rec.program_application_id = FND_API.G_MISS_NUM THEN
775: IF l_FlowSchedule_rec.primary_item_id = FND_API.G_MISS_NUM THEN
776: l_FlowSchedule_rec.primary_item_id := NULL;
777: END IF;
778:
779: IF l_FlowSchedule_rec.program_application_id = FND_API.G_MISS_NUM THEN
780: l_FlowSchedule_rec.program_application_id := NULL;
781: END IF;
782:
783: IF l_FlowSchedule_rec.program_id = FND_API.G_MISS_NUM THEN
779: IF l_FlowSchedule_rec.program_application_id = FND_API.G_MISS_NUM THEN
780: l_FlowSchedule_rec.program_application_id := NULL;
781: END IF;
782:
783: IF l_FlowSchedule_rec.program_id = FND_API.G_MISS_NUM THEN
784: l_FlowSchedule_rec.program_id := NULL;
785: END IF;
786:
787: IF l_FlowSchedule_rec.program_update_date = FND_API.G_MISS_DATE THEN
783: IF l_FlowSchedule_rec.program_id = FND_API.G_MISS_NUM THEN
784: l_FlowSchedule_rec.program_id := NULL;
785: END IF;
786:
787: IF l_FlowSchedule_rec.program_update_date = FND_API.G_MISS_DATE THEN
788: l_FlowSchedule_rec.program_update_date := NULL;
789: END IF;
790:
791: IF l_FlowSchedule_rec.project_id = FND_API.G_MISS_NUM THEN
787: IF l_FlowSchedule_rec.program_update_date = FND_API.G_MISS_DATE THEN
788: l_FlowSchedule_rec.program_update_date := NULL;
789: END IF;
790:
791: IF l_FlowSchedule_rec.project_id = FND_API.G_MISS_NUM THEN
792: l_FlowSchedule_rec.project_id := NULL;
793: END IF;
794:
795: IF l_FlowSchedule_rec.quantity_completed = FND_API.G_MISS_NUM THEN
791: IF l_FlowSchedule_rec.project_id = FND_API.G_MISS_NUM THEN
792: l_FlowSchedule_rec.project_id := NULL;
793: END IF;
794:
795: IF l_FlowSchedule_rec.quantity_completed = FND_API.G_MISS_NUM THEN
796: l_FlowSchedule_rec.quantity_completed := NULL;
797: END IF;
798:
799: IF l_FlowSchedule_rec.request_id = FND_API.G_MISS_NUM THEN
795: IF l_FlowSchedule_rec.quantity_completed = FND_API.G_MISS_NUM THEN
796: l_FlowSchedule_rec.quantity_completed := NULL;
797: END IF;
798:
799: IF l_FlowSchedule_rec.request_id = FND_API.G_MISS_NUM THEN
800: l_FlowSchedule_rec.request_id := NULL;
801: END IF;
802:
803: IF l_FlowSchedule_rec.resource_account = FND_API.G_MISS_NUM THEN
799: IF l_FlowSchedule_rec.request_id = FND_API.G_MISS_NUM THEN
800: l_FlowSchedule_rec.request_id := NULL;
801: END IF;
802:
803: IF l_FlowSchedule_rec.resource_account = FND_API.G_MISS_NUM THEN
804: l_FlowSchedule_rec.resource_account := NULL;
805: END IF;
806:
807: IF l_FlowSchedule_rec.resource_variance_account = FND_API.G_MISS_NUM THEN
803: IF l_FlowSchedule_rec.resource_account = FND_API.G_MISS_NUM THEN
804: l_FlowSchedule_rec.resource_account := NULL;
805: END IF;
806:
807: IF l_FlowSchedule_rec.resource_variance_account = FND_API.G_MISS_NUM THEN
808: l_FlowSchedule_rec.resource_variance_account := NULL;
809: END IF;
810:
811: IF l_FlowSchedule_rec.routing_revision = FND_API.G_MISS_CHAR THEN
807: IF l_FlowSchedule_rec.resource_variance_account = FND_API.G_MISS_NUM THEN
808: l_FlowSchedule_rec.resource_variance_account := NULL;
809: END IF;
810:
811: IF l_FlowSchedule_rec.routing_revision = FND_API.G_MISS_CHAR THEN
812: l_FlowSchedule_rec.routing_revision := NULL;
813: END IF;
814:
815: IF l_FlowSchedule_rec.routing_revision_date = FND_API.G_MISS_DATE THEN
811: IF l_FlowSchedule_rec.routing_revision = FND_API.G_MISS_CHAR THEN
812: l_FlowSchedule_rec.routing_revision := NULL;
813: END IF;
814:
815: IF l_FlowSchedule_rec.routing_revision_date = FND_API.G_MISS_DATE THEN
816: l_FlowSchedule_rec.routing_revision_date := NULL;
817: END IF;
818:
819: IF l_FlowSchedule_rec.scheduled_completion_date = FND_API.G_MISS_DATE THEN
815: IF l_FlowSchedule_rec.routing_revision_date = FND_API.G_MISS_DATE THEN
816: l_FlowSchedule_rec.routing_revision_date := NULL;
817: END IF;
818:
819: IF l_FlowSchedule_rec.scheduled_completion_date = FND_API.G_MISS_DATE THEN
820: l_FlowSchedule_rec.scheduled_completion_date := NULL;
821: END IF;
822:
823: IF l_FlowSchedule_rec.scheduled_flag = FND_API.G_MISS_NUM THEN
819: IF l_FlowSchedule_rec.scheduled_completion_date = FND_API.G_MISS_DATE THEN
820: l_FlowSchedule_rec.scheduled_completion_date := NULL;
821: END IF;
822:
823: IF l_FlowSchedule_rec.scheduled_flag = FND_API.G_MISS_NUM THEN
824: l_FlowSchedule_rec.scheduled_flag := NULL;
825: END IF;
826:
827: IF l_FlowSchedule_rec.scheduled_start_date = FND_API.G_MISS_DATE THEN
823: IF l_FlowSchedule_rec.scheduled_flag = FND_API.G_MISS_NUM THEN
824: l_FlowSchedule_rec.scheduled_flag := NULL;
825: END IF;
826:
827: IF l_FlowSchedule_rec.scheduled_start_date = FND_API.G_MISS_DATE THEN
828: l_FlowSchedule_rec.scheduled_start_date := NULL;
829: END IF;
830:
831: IF l_FlowSchedule_rec.schedule_group_id = FND_API.G_MISS_NUM THEN
827: IF l_FlowSchedule_rec.scheduled_start_date = FND_API.G_MISS_DATE THEN
828: l_FlowSchedule_rec.scheduled_start_date := NULL;
829: END IF;
830:
831: IF l_FlowSchedule_rec.schedule_group_id = FND_API.G_MISS_NUM THEN
832: l_FlowSchedule_rec.schedule_group_id := NULL;
833: END IF;
834:
835: IF l_FlowSchedule_rec.schedule_number = FND_API.G_MISS_CHAR THEN
831: IF l_FlowSchedule_rec.schedule_group_id = FND_API.G_MISS_NUM THEN
832: l_FlowSchedule_rec.schedule_group_id := NULL;
833: END IF;
834:
835: IF l_FlowSchedule_rec.schedule_number = FND_API.G_MISS_CHAR THEN
836: l_FlowSchedule_rec.schedule_number := NULL;
837: END IF;
838:
839: IF l_FlowSchedule_rec.status = FND_API.G_MISS_NUM THEN
835: IF l_FlowSchedule_rec.schedule_number = FND_API.G_MISS_CHAR THEN
836: l_FlowSchedule_rec.schedule_number := NULL;
837: END IF;
838:
839: IF l_FlowSchedule_rec.status = FND_API.G_MISS_NUM THEN
840: l_FlowSchedule_rec.status := NULL;
841: END IF;
842:
843: IF l_FlowSchedule_rec.std_cost_adj_account = FND_API.G_MISS_NUM THEN
839: IF l_FlowSchedule_rec.status = FND_API.G_MISS_NUM THEN
840: l_FlowSchedule_rec.status := NULL;
841: END IF;
842:
843: IF l_FlowSchedule_rec.std_cost_adj_account = FND_API.G_MISS_NUM THEN
844: l_FlowSchedule_rec.std_cost_adj_account := NULL;
845: END IF;
846:
847: IF l_FlowSchedule_rec.task_id = FND_API.G_MISS_NUM THEN
843: IF l_FlowSchedule_rec.std_cost_adj_account = FND_API.G_MISS_NUM THEN
844: l_FlowSchedule_rec.std_cost_adj_account := NULL;
845: END IF;
846:
847: IF l_FlowSchedule_rec.task_id = FND_API.G_MISS_NUM THEN
848: l_FlowSchedule_rec.task_id := NULL;
849: END IF;
850:
851: IF l_FlowSchedule_rec.wip_entity_id = FND_API.G_MISS_NUM THEN
847: IF l_FlowSchedule_rec.task_id = FND_API.G_MISS_NUM THEN
848: l_FlowSchedule_rec.task_id := NULL;
849: END IF;
850:
851: IF l_FlowSchedule_rec.wip_entity_id = FND_API.G_MISS_NUM THEN
852: l_FlowSchedule_rec.wip_entity_id := NULL;
853: END IF;
854:
855: RETURN l_FlowSchedule_rec;
947: , 'Update_Row'
948: );
949: END IF;
950:
951: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
952:
953: END Update_Row;
954:
955: -- Procedure Insert_Row
1112: , 'Insert_Row'
1113: );
1114: END IF;
1115:
1116: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1117:
1118: END Insert_Row;
1119:
1120: -- Procedure Delete_Row
1140: , 'Delete_Row'
1141: );
1142: END IF;
1143:
1144: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1145:
1146: END Delete_Row;
1147:
1148: -- Function Query_Row
1177: --
1178:
1179: FUNCTION Query_Rows
1180: ( p_schedule_number IN VARCHAR2 :=
1181: FND_API.G_MISS_CHAR
1182: , p_wip_entity_id IN NUMBER :=
1183: FND_API.G_MISS_NUM
1184: ) RETURN WIP_Work_Order_PUB.Flowschedule_Tbl_Type
1185: IS
1179: FUNCTION Query_Rows
1180: ( p_schedule_number IN VARCHAR2 :=
1181: FND_API.G_MISS_CHAR
1182: , p_wip_entity_id IN NUMBER :=
1183: FND_API.G_MISS_NUM
1184: ) RETURN WIP_Work_Order_PUB.Flowschedule_Tbl_Type
1185: IS
1186: l_FlowSchedule_rec WIP_Work_Order_PUB.Flowschedule_Rec_Type;
1187: l_FlowSchedule_tbl WIP_Work_Order_PUB.Flowschedule_Tbl_Type;
1265:
1266: IF
1267: (p_schedule_number IS NOT NULL
1268: AND
1269: p_schedule_number <> FND_API.G_MISS_CHAR)
1270: AND
1271: (p_wip_entity_id IS NOT NULL
1272: AND
1273: p_wip_entity_id <> FND_API.G_MISS_NUM)
1269: p_schedule_number <> FND_API.G_MISS_CHAR)
1270: AND
1271: (p_wip_entity_id IS NOT NULL
1272: AND
1273: p_wip_entity_id <> FND_API.G_MISS_NUM)
1274: THEN
1275: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1276: THEN
1277: FND_MSG_PUB.Add_Exc_Msg
1280: , 'Keys are mutually exclusive: schedule_number = '|| p_schedule_number || ', wip_entity_id = '|| p_wip_entity_id
1281: );
1282: END IF;
1283:
1284: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1285:
1286: END IF;
1287:
1288:
1368:
1369: IF
1370: (p_schedule_number IS NOT NULL
1371: AND
1372: p_schedule_number <> FND_API.G_MISS_CHAR)
1373: AND
1374: (l_FlowSchedule_tbl.COUNT = 0)
1375: THEN
1376: RAISE NO_DATA_FOUND;
1382: RETURN l_FlowSchedule_tbl;
1383:
1384: EXCEPTION
1385:
1386: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1387:
1388: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1389:
1390: WHEN OTHERS THEN
1384: EXCEPTION
1385:
1386: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1387:
1388: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1389:
1390: WHEN OTHERS THEN
1391:
1392: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1396: , 'Query_Rows'
1397: );
1398: END IF;
1399:
1400: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1401:
1402: END Query_Rows;
1403:
1404: -- Procedure lock_Row
1698: x_FlowSchedule_rec := l_FlowSchedule_rec;
1699:
1700: -- Set return status
1701:
1702: x_return_status := FND_API.G_RET_STS_SUCCESS;
1703: x_FlowSchedule_rec.return_status := FND_API.G_RET_STS_SUCCESS;
1704:
1705: ELSE
1706:
1699:
1700: -- Set return status
1701:
1702: x_return_status := FND_API.G_RET_STS_SUCCESS;
1703: x_FlowSchedule_rec.return_status := FND_API.G_RET_STS_SUCCESS;
1704:
1705: ELSE
1706:
1707: -- Row has changed by another user.
1705: ELSE
1706:
1707: -- Row has changed by another user.
1708:
1709: x_return_status := FND_API.G_RET_STS_ERROR;
1710: x_FlowSchedule_rec.return_status := FND_API.G_RET_STS_ERROR;
1711:
1712: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
1713: THEN
1706:
1707: -- Row has changed by another user.
1708:
1709: x_return_status := FND_API.G_RET_STS_ERROR;
1710: x_FlowSchedule_rec.return_status := FND_API.G_RET_STS_ERROR;
1711:
1712: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
1713: THEN
1714:
1722: EXCEPTION
1723:
1724: WHEN NO_DATA_FOUND THEN
1725:
1726: x_return_status := FND_API.G_RET_STS_ERROR;
1727: x_FlowSchedule_rec.return_status := FND_API.G_RET_STS_ERROR;
1728:
1729: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
1730: THEN
1723:
1724: WHEN NO_DATA_FOUND THEN
1725:
1726: x_return_status := FND_API.G_RET_STS_ERROR;
1727: x_FlowSchedule_rec.return_status := FND_API.G_RET_STS_ERROR;
1728:
1729: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
1730: THEN
1731:
1734:
1735: END IF;
1736: WHEN APP_EXCEPTIONS.RECORD_LOCK_EXCEPTION THEN
1737:
1738: x_return_status := FND_API.G_RET_STS_ERROR;
1739: x_FlowSchedule_rec.return_status := FND_API.G_RET_STS_ERROR;
1740:
1741: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
1742: THEN
1735: END IF;
1736: WHEN APP_EXCEPTIONS.RECORD_LOCK_EXCEPTION THEN
1737:
1738: x_return_status := FND_API.G_RET_STS_ERROR;
1739: x_FlowSchedule_rec.return_status := FND_API.G_RET_STS_ERROR;
1740:
1741: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
1742: THEN
1743:
1746:
1747: END IF;
1748: WHEN OTHERS THEN
1749:
1750: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1751: x_FlowSchedule_rec.return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1752:
1753: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1754: THEN
1747: END IF;
1748: WHEN OTHERS THEN
1749:
1750: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1751: x_FlowSchedule_rec.return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1752:
1753: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1754: THEN
1755: FND_MSG_PUB.Add_Exc_Msg