43: -- If attr_id is missing compare old and new records and for
44: -- every changed attribute clear its dependent fields.
45:
46: -- Commenting for pl-sql coding standards and instead check if p_attr_id is null
47: -- IF p_attr_id = FND_API.G_MISS_NUM THEN
48: IF p_attr_id IS NULL THEN
49:
50: IF NOT MRP_GLOBALS.Equal(p_flow_schedule_rec.alternate_bom_designator,p_old_flow_schedule_rec.alternate_bom_designator)
51: THEN
48: IF p_attr_id IS NULL THEN
49:
50: IF NOT MRP_GLOBALS.Equal(p_flow_schedule_rec.alternate_bom_designator,p_old_flow_schedule_rec.alternate_bom_designator)
51: THEN
52: x_flow_schedule_rec.bom_revision := FND_API.G_MISS_CHAR;
53: x_flow_schedule_rec.bom_revision_date := FND_API.G_MISS_DATE;
54: END IF;
55:
56: IF NOT MRP_GLOBALS.Equal(p_flow_schedule_rec.alternate_routing_desig,p_old_flow_schedule_rec.alternate_routing_desig)
49:
50: IF NOT MRP_GLOBALS.Equal(p_flow_schedule_rec.alternate_bom_designator,p_old_flow_schedule_rec.alternate_bom_designator)
51: THEN
52: x_flow_schedule_rec.bom_revision := FND_API.G_MISS_CHAR;
53: x_flow_schedule_rec.bom_revision_date := FND_API.G_MISS_DATE;
54: END IF;
55:
56: IF NOT MRP_GLOBALS.Equal(p_flow_schedule_rec.alternate_routing_desig,p_old_flow_schedule_rec.alternate_routing_desig)
57: THEN
54: END IF;
55:
56: IF NOT MRP_GLOBALS.Equal(p_flow_schedule_rec.alternate_routing_desig,p_old_flow_schedule_rec.alternate_routing_desig)
57: THEN
58: x_flow_schedule_rec.routing_revision := FND_API.G_MISS_CHAR;
59: x_flow_schedule_rec.routing_revision_date := FND_API.G_MISS_DATE;
60: x_flow_schedule_rec.completion_subinventory := FND_API.G_MISS_CHAR;
61: x_flow_schedule_rec.completion_locator_id := FND_API.G_MISS_NUM;
62: END IF;
55:
56: IF NOT MRP_GLOBALS.Equal(p_flow_schedule_rec.alternate_routing_desig,p_old_flow_schedule_rec.alternate_routing_desig)
57: THEN
58: x_flow_schedule_rec.routing_revision := FND_API.G_MISS_CHAR;
59: x_flow_schedule_rec.routing_revision_date := FND_API.G_MISS_DATE;
60: x_flow_schedule_rec.completion_subinventory := FND_API.G_MISS_CHAR;
61: x_flow_schedule_rec.completion_locator_id := FND_API.G_MISS_NUM;
62: END IF;
63:
56: IF NOT MRP_GLOBALS.Equal(p_flow_schedule_rec.alternate_routing_desig,p_old_flow_schedule_rec.alternate_routing_desig)
57: THEN
58: x_flow_schedule_rec.routing_revision := FND_API.G_MISS_CHAR;
59: x_flow_schedule_rec.routing_revision_date := FND_API.G_MISS_DATE;
60: x_flow_schedule_rec.completion_subinventory := FND_API.G_MISS_CHAR;
61: x_flow_schedule_rec.completion_locator_id := FND_API.G_MISS_NUM;
62: END IF;
63:
64: IF NOT MRP_GLOBALS.Equal(p_flow_schedule_rec.bom_revision,p_old_flow_schedule_rec.bom_revision)
57: THEN
58: x_flow_schedule_rec.routing_revision := FND_API.G_MISS_CHAR;
59: x_flow_schedule_rec.routing_revision_date := FND_API.G_MISS_DATE;
60: x_flow_schedule_rec.completion_subinventory := FND_API.G_MISS_CHAR;
61: x_flow_schedule_rec.completion_locator_id := FND_API.G_MISS_NUM;
62: END IF;
63:
64: IF NOT MRP_GLOBALS.Equal(p_flow_schedule_rec.bom_revision,p_old_flow_schedule_rec.bom_revision)
65: THEN
62: END IF;
63:
64: IF NOT MRP_GLOBALS.Equal(p_flow_schedule_rec.bom_revision,p_old_flow_schedule_rec.bom_revision)
65: THEN
66: x_flow_schedule_rec.bom_revision_date := FND_API.G_MISS_DATE;
67: END IF;
68:
69: IF NOT MRP_GLOBALS.Equal(p_flow_schedule_rec.bom_revision_date,p_old_flow_schedule_rec.bom_revision_date)
70: THEN
77: END IF;
78:
79: IF NOT MRP_GLOBALS.Equal(p_flow_schedule_rec.class_code,p_old_flow_schedule_rec.class_code)
80: THEN
81: x_flow_schedule_rec.material_account := FND_API.G_MISS_NUM;
82: x_flow_schedule_rec.material_overhead_account := FND_API.G_MISS_NUM;
83: x_flow_schedule_rec.resource_account := FND_API.G_MISS_NUM;
84: x_flow_schedule_rec.outside_processing_acct := FND_API.G_MISS_NUM;
85: x_flow_schedule_rec.material_variance_account := FND_API.G_MISS_NUM;
78:
79: IF NOT MRP_GLOBALS.Equal(p_flow_schedule_rec.class_code,p_old_flow_schedule_rec.class_code)
80: THEN
81: x_flow_schedule_rec.material_account := FND_API.G_MISS_NUM;
82: x_flow_schedule_rec.material_overhead_account := FND_API.G_MISS_NUM;
83: x_flow_schedule_rec.resource_account := FND_API.G_MISS_NUM;
84: x_flow_schedule_rec.outside_processing_acct := FND_API.G_MISS_NUM;
85: x_flow_schedule_rec.material_variance_account := FND_API.G_MISS_NUM;
86: x_flow_schedule_rec.resource_variance_account := FND_API.G_MISS_NUM;
79: IF NOT MRP_GLOBALS.Equal(p_flow_schedule_rec.class_code,p_old_flow_schedule_rec.class_code)
80: THEN
81: x_flow_schedule_rec.material_account := FND_API.G_MISS_NUM;
82: x_flow_schedule_rec.material_overhead_account := FND_API.G_MISS_NUM;
83: x_flow_schedule_rec.resource_account := FND_API.G_MISS_NUM;
84: x_flow_schedule_rec.outside_processing_acct := FND_API.G_MISS_NUM;
85: x_flow_schedule_rec.material_variance_account := FND_API.G_MISS_NUM;
86: x_flow_schedule_rec.resource_variance_account := FND_API.G_MISS_NUM;
87: x_flow_schedule_rec.outside_proc_var_acct := FND_API.G_MISS_NUM;
80: THEN
81: x_flow_schedule_rec.material_account := FND_API.G_MISS_NUM;
82: x_flow_schedule_rec.material_overhead_account := FND_API.G_MISS_NUM;
83: x_flow_schedule_rec.resource_account := FND_API.G_MISS_NUM;
84: x_flow_schedule_rec.outside_processing_acct := FND_API.G_MISS_NUM;
85: x_flow_schedule_rec.material_variance_account := FND_API.G_MISS_NUM;
86: x_flow_schedule_rec.resource_variance_account := FND_API.G_MISS_NUM;
87: x_flow_schedule_rec.outside_proc_var_acct := FND_API.G_MISS_NUM;
88: x_flow_schedule_rec.std_cost_adjustment_acct := FND_API.G_MISS_NUM;
81: x_flow_schedule_rec.material_account := FND_API.G_MISS_NUM;
82: x_flow_schedule_rec.material_overhead_account := FND_API.G_MISS_NUM;
83: x_flow_schedule_rec.resource_account := FND_API.G_MISS_NUM;
84: x_flow_schedule_rec.outside_processing_acct := FND_API.G_MISS_NUM;
85: x_flow_schedule_rec.material_variance_account := FND_API.G_MISS_NUM;
86: x_flow_schedule_rec.resource_variance_account := FND_API.G_MISS_NUM;
87: x_flow_schedule_rec.outside_proc_var_acct := FND_API.G_MISS_NUM;
88: x_flow_schedule_rec.std_cost_adjustment_acct := FND_API.G_MISS_NUM;
89: x_flow_schedule_rec.overhead_account := FND_API.G_MISS_NUM;
82: x_flow_schedule_rec.material_overhead_account := FND_API.G_MISS_NUM;
83: x_flow_schedule_rec.resource_account := FND_API.G_MISS_NUM;
84: x_flow_schedule_rec.outside_processing_acct := FND_API.G_MISS_NUM;
85: x_flow_schedule_rec.material_variance_account := FND_API.G_MISS_NUM;
86: x_flow_schedule_rec.resource_variance_account := FND_API.G_MISS_NUM;
87: x_flow_schedule_rec.outside_proc_var_acct := FND_API.G_MISS_NUM;
88: x_flow_schedule_rec.std_cost_adjustment_acct := FND_API.G_MISS_NUM;
89: x_flow_schedule_rec.overhead_account := FND_API.G_MISS_NUM;
90: x_flow_schedule_rec.overhead_variance_account := FND_API.G_MISS_NUM;
83: x_flow_schedule_rec.resource_account := FND_API.G_MISS_NUM;
84: x_flow_schedule_rec.outside_processing_acct := FND_API.G_MISS_NUM;
85: x_flow_schedule_rec.material_variance_account := FND_API.G_MISS_NUM;
86: x_flow_schedule_rec.resource_variance_account := FND_API.G_MISS_NUM;
87: x_flow_schedule_rec.outside_proc_var_acct := FND_API.G_MISS_NUM;
88: x_flow_schedule_rec.std_cost_adjustment_acct := FND_API.G_MISS_NUM;
89: x_flow_schedule_rec.overhead_account := FND_API.G_MISS_NUM;
90: x_flow_schedule_rec.overhead_variance_account := FND_API.G_MISS_NUM;
91: END IF;
84: x_flow_schedule_rec.outside_processing_acct := FND_API.G_MISS_NUM;
85: x_flow_schedule_rec.material_variance_account := FND_API.G_MISS_NUM;
86: x_flow_schedule_rec.resource_variance_account := FND_API.G_MISS_NUM;
87: x_flow_schedule_rec.outside_proc_var_acct := FND_API.G_MISS_NUM;
88: x_flow_schedule_rec.std_cost_adjustment_acct := FND_API.G_MISS_NUM;
89: x_flow_schedule_rec.overhead_account := FND_API.G_MISS_NUM;
90: x_flow_schedule_rec.overhead_variance_account := FND_API.G_MISS_NUM;
91: END IF;
92:
85: x_flow_schedule_rec.material_variance_account := FND_API.G_MISS_NUM;
86: x_flow_schedule_rec.resource_variance_account := FND_API.G_MISS_NUM;
87: x_flow_schedule_rec.outside_proc_var_acct := FND_API.G_MISS_NUM;
88: x_flow_schedule_rec.std_cost_adjustment_acct := FND_API.G_MISS_NUM;
89: x_flow_schedule_rec.overhead_account := FND_API.G_MISS_NUM;
90: x_flow_schedule_rec.overhead_variance_account := FND_API.G_MISS_NUM;
91: END IF;
92:
93: IF NOT MRP_GLOBALS.Equal(p_flow_schedule_rec.completion_locator_id,p_old_flow_schedule_rec.completion_locator_id)
86: x_flow_schedule_rec.resource_variance_account := FND_API.G_MISS_NUM;
87: x_flow_schedule_rec.outside_proc_var_acct := FND_API.G_MISS_NUM;
88: x_flow_schedule_rec.std_cost_adjustment_acct := FND_API.G_MISS_NUM;
89: x_flow_schedule_rec.overhead_account := FND_API.G_MISS_NUM;
90: x_flow_schedule_rec.overhead_variance_account := FND_API.G_MISS_NUM;
91: END IF;
92:
93: IF NOT MRP_GLOBALS.Equal(p_flow_schedule_rec.completion_locator_id,p_old_flow_schedule_rec.completion_locator_id)
94: THEN
96: END IF;
97:
98: IF NOT MRP_GLOBALS.Equal(p_flow_schedule_rec.completion_subinventory,p_old_flow_schedule_rec.completion_subinventory)
99: THEN
100: x_flow_schedule_rec.completion_locator_id := FND_API.G_MISS_NUM;
101: END IF;
102:
103: IF NOT MRP_GLOBALS.Equal(p_flow_schedule_rec.created_by,p_old_flow_schedule_rec.created_by)
104: THEN
126: END IF;
127:
128: IF NOT MRP_GLOBALS.Equal(p_flow_schedule_rec.demand_source_header_id,p_old_flow_schedule_rec.demand_source_header_id)
129: THEN
130: x_flow_schedule_rec.demand_source_line := FND_API.G_MISS_CHAR;
131: x_flow_schedule_rec.demand_source_delivery := FND_API.G_MISS_CHAR;
132: END IF;
133:
134: IF NOT MRP_GLOBALS.Equal(p_flow_schedule_rec.demand_source_line,p_old_flow_schedule_rec.demand_source_line)
127:
128: IF NOT MRP_GLOBALS.Equal(p_flow_schedule_rec.demand_source_header_id,p_old_flow_schedule_rec.demand_source_header_id)
129: THEN
130: x_flow_schedule_rec.demand_source_line := FND_API.G_MISS_CHAR;
131: x_flow_schedule_rec.demand_source_delivery := FND_API.G_MISS_CHAR;
132: END IF;
133:
134: IF NOT MRP_GLOBALS.Equal(p_flow_schedule_rec.demand_source_line,p_old_flow_schedule_rec.demand_source_line)
135: THEN
157: END IF;
158:
159: IF NOT MRP_GLOBALS.Equal(p_flow_schedule_rec.line_id,p_old_flow_schedule_rec.line_id)
160: THEN
161: x_flow_schedule_rec.alternate_routing_desig := FND_API.G_MISS_CHAR;
162: END IF;
163:
164: IF NOT MRP_GLOBALS.Equal(p_flow_schedule_rec.material_account,p_old_flow_schedule_rec.material_account)
165: THEN
187: END IF;
188:
189: IF NOT MRP_GLOBALS.Equal(p_flow_schedule_rec.organization_id,p_old_flow_schedule_rec.organization_id)
190: THEN
191: x_flow_schedule_rec.primary_item_id := FND_API.G_MISS_NUM;
192: x_flow_schedule_rec.completion_subinventory := FND_API.G_MISS_CHAR;
193: x_flow_schedule_rec.completion_locator_id := FND_API.G_MISS_NUM;
194: x_flow_schedule_rec.demand_source_header_id := FND_API.G_MISS_NUM;
195: x_flow_schedule_rec.demand_source_type := FND_API.G_MISS_NUM;
188:
189: IF NOT MRP_GLOBALS.Equal(p_flow_schedule_rec.organization_id,p_old_flow_schedule_rec.organization_id)
190: THEN
191: x_flow_schedule_rec.primary_item_id := FND_API.G_MISS_NUM;
192: x_flow_schedule_rec.completion_subinventory := FND_API.G_MISS_CHAR;
193: x_flow_schedule_rec.completion_locator_id := FND_API.G_MISS_NUM;
194: x_flow_schedule_rec.demand_source_header_id := FND_API.G_MISS_NUM;
195: x_flow_schedule_rec.demand_source_type := FND_API.G_MISS_NUM;
196: x_flow_schedule_rec.demand_source_line := FND_API.G_MISS_CHAR;
189: IF NOT MRP_GLOBALS.Equal(p_flow_schedule_rec.organization_id,p_old_flow_schedule_rec.organization_id)
190: THEN
191: x_flow_schedule_rec.primary_item_id := FND_API.G_MISS_NUM;
192: x_flow_schedule_rec.completion_subinventory := FND_API.G_MISS_CHAR;
193: x_flow_schedule_rec.completion_locator_id := FND_API.G_MISS_NUM;
194: x_flow_schedule_rec.demand_source_header_id := FND_API.G_MISS_NUM;
195: x_flow_schedule_rec.demand_source_type := FND_API.G_MISS_NUM;
196: x_flow_schedule_rec.demand_source_line := FND_API.G_MISS_CHAR;
197: x_flow_schedule_rec.demand_source_delivery := FND_API.G_MISS_CHAR;
190: THEN
191: x_flow_schedule_rec.primary_item_id := FND_API.G_MISS_NUM;
192: x_flow_schedule_rec.completion_subinventory := FND_API.G_MISS_CHAR;
193: x_flow_schedule_rec.completion_locator_id := FND_API.G_MISS_NUM;
194: x_flow_schedule_rec.demand_source_header_id := FND_API.G_MISS_NUM;
195: x_flow_schedule_rec.demand_source_type := FND_API.G_MISS_NUM;
196: x_flow_schedule_rec.demand_source_line := FND_API.G_MISS_CHAR;
197: x_flow_schedule_rec.demand_source_delivery := FND_API.G_MISS_CHAR;
198: x_flow_schedule_rec.alternate_bom_designator := FND_API.G_MISS_CHAR;
191: x_flow_schedule_rec.primary_item_id := FND_API.G_MISS_NUM;
192: x_flow_schedule_rec.completion_subinventory := FND_API.G_MISS_CHAR;
193: x_flow_schedule_rec.completion_locator_id := FND_API.G_MISS_NUM;
194: x_flow_schedule_rec.demand_source_header_id := FND_API.G_MISS_NUM;
195: x_flow_schedule_rec.demand_source_type := FND_API.G_MISS_NUM;
196: x_flow_schedule_rec.demand_source_line := FND_API.G_MISS_CHAR;
197: x_flow_schedule_rec.demand_source_delivery := FND_API.G_MISS_CHAR;
198: x_flow_schedule_rec.alternate_bom_designator := FND_API.G_MISS_CHAR;
199: x_flow_schedule_rec.bom_revision := FND_API.G_MISS_CHAR;
192: x_flow_schedule_rec.completion_subinventory := FND_API.G_MISS_CHAR;
193: x_flow_schedule_rec.completion_locator_id := FND_API.G_MISS_NUM;
194: x_flow_schedule_rec.demand_source_header_id := FND_API.G_MISS_NUM;
195: x_flow_schedule_rec.demand_source_type := FND_API.G_MISS_NUM;
196: x_flow_schedule_rec.demand_source_line := FND_API.G_MISS_CHAR;
197: x_flow_schedule_rec.demand_source_delivery := FND_API.G_MISS_CHAR;
198: x_flow_schedule_rec.alternate_bom_designator := FND_API.G_MISS_CHAR;
199: x_flow_schedule_rec.bom_revision := FND_API.G_MISS_CHAR;
200: x_flow_schedule_rec.bom_revision_date := FND_API.G_MISS_DATE;
193: x_flow_schedule_rec.completion_locator_id := FND_API.G_MISS_NUM;
194: x_flow_schedule_rec.demand_source_header_id := FND_API.G_MISS_NUM;
195: x_flow_schedule_rec.demand_source_type := FND_API.G_MISS_NUM;
196: x_flow_schedule_rec.demand_source_line := FND_API.G_MISS_CHAR;
197: x_flow_schedule_rec.demand_source_delivery := FND_API.G_MISS_CHAR;
198: x_flow_schedule_rec.alternate_bom_designator := FND_API.G_MISS_CHAR;
199: x_flow_schedule_rec.bom_revision := FND_API.G_MISS_CHAR;
200: x_flow_schedule_rec.bom_revision_date := FND_API.G_MISS_DATE;
201: x_flow_schedule_rec.alternate_routing_desig := FND_API.G_MISS_CHAR;
194: x_flow_schedule_rec.demand_source_header_id := FND_API.G_MISS_NUM;
195: x_flow_schedule_rec.demand_source_type := FND_API.G_MISS_NUM;
196: x_flow_schedule_rec.demand_source_line := FND_API.G_MISS_CHAR;
197: x_flow_schedule_rec.demand_source_delivery := FND_API.G_MISS_CHAR;
198: x_flow_schedule_rec.alternate_bom_designator := FND_API.G_MISS_CHAR;
199: x_flow_schedule_rec.bom_revision := FND_API.G_MISS_CHAR;
200: x_flow_schedule_rec.bom_revision_date := FND_API.G_MISS_DATE;
201: x_flow_schedule_rec.alternate_routing_desig := FND_API.G_MISS_CHAR;
202: x_flow_schedule_rec.routing_revision := FND_API.G_MISS_CHAR;
195: x_flow_schedule_rec.demand_source_type := FND_API.G_MISS_NUM;
196: x_flow_schedule_rec.demand_source_line := FND_API.G_MISS_CHAR;
197: x_flow_schedule_rec.demand_source_delivery := FND_API.G_MISS_CHAR;
198: x_flow_schedule_rec.alternate_bom_designator := FND_API.G_MISS_CHAR;
199: x_flow_schedule_rec.bom_revision := FND_API.G_MISS_CHAR;
200: x_flow_schedule_rec.bom_revision_date := FND_API.G_MISS_DATE;
201: x_flow_schedule_rec.alternate_routing_desig := FND_API.G_MISS_CHAR;
202: x_flow_schedule_rec.routing_revision := FND_API.G_MISS_CHAR;
203: x_flow_schedule_rec.routing_revision_date := FND_API.G_MISS_DATE;
196: x_flow_schedule_rec.demand_source_line := FND_API.G_MISS_CHAR;
197: x_flow_schedule_rec.demand_source_delivery := FND_API.G_MISS_CHAR;
198: x_flow_schedule_rec.alternate_bom_designator := FND_API.G_MISS_CHAR;
199: x_flow_schedule_rec.bom_revision := FND_API.G_MISS_CHAR;
200: x_flow_schedule_rec.bom_revision_date := FND_API.G_MISS_DATE;
201: x_flow_schedule_rec.alternate_routing_desig := FND_API.G_MISS_CHAR;
202: x_flow_schedule_rec.routing_revision := FND_API.G_MISS_CHAR;
203: x_flow_schedule_rec.routing_revision_date := FND_API.G_MISS_DATE;
204: x_flow_schedule_rec.line_id := FND_API.G_MISS_NUM;
197: x_flow_schedule_rec.demand_source_delivery := FND_API.G_MISS_CHAR;
198: x_flow_schedule_rec.alternate_bom_designator := FND_API.G_MISS_CHAR;
199: x_flow_schedule_rec.bom_revision := FND_API.G_MISS_CHAR;
200: x_flow_schedule_rec.bom_revision_date := FND_API.G_MISS_DATE;
201: x_flow_schedule_rec.alternate_routing_desig := FND_API.G_MISS_CHAR;
202: x_flow_schedule_rec.routing_revision := FND_API.G_MISS_CHAR;
203: x_flow_schedule_rec.routing_revision_date := FND_API.G_MISS_DATE;
204: x_flow_schedule_rec.line_id := FND_API.G_MISS_NUM;
205: x_flow_schedule_rec.class_code := FND_API.G_MISS_CHAR;
198: x_flow_schedule_rec.alternate_bom_designator := FND_API.G_MISS_CHAR;
199: x_flow_schedule_rec.bom_revision := FND_API.G_MISS_CHAR;
200: x_flow_schedule_rec.bom_revision_date := FND_API.G_MISS_DATE;
201: x_flow_schedule_rec.alternate_routing_desig := FND_API.G_MISS_CHAR;
202: x_flow_schedule_rec.routing_revision := FND_API.G_MISS_CHAR;
203: x_flow_schedule_rec.routing_revision_date := FND_API.G_MISS_DATE;
204: x_flow_schedule_rec.line_id := FND_API.G_MISS_NUM;
205: x_flow_schedule_rec.class_code := FND_API.G_MISS_CHAR;
206: x_flow_schedule_rec.schedule_group_id := FND_API.G_MISS_NUM;
199: x_flow_schedule_rec.bom_revision := FND_API.G_MISS_CHAR;
200: x_flow_schedule_rec.bom_revision_date := FND_API.G_MISS_DATE;
201: x_flow_schedule_rec.alternate_routing_desig := FND_API.G_MISS_CHAR;
202: x_flow_schedule_rec.routing_revision := FND_API.G_MISS_CHAR;
203: x_flow_schedule_rec.routing_revision_date := FND_API.G_MISS_DATE;
204: x_flow_schedule_rec.line_id := FND_API.G_MISS_NUM;
205: x_flow_schedule_rec.class_code := FND_API.G_MISS_CHAR;
206: x_flow_schedule_rec.schedule_group_id := FND_API.G_MISS_NUM;
207: x_flow_schedule_rec.material_account := FND_API.G_MISS_NUM;
200: x_flow_schedule_rec.bom_revision_date := FND_API.G_MISS_DATE;
201: x_flow_schedule_rec.alternate_routing_desig := FND_API.G_MISS_CHAR;
202: x_flow_schedule_rec.routing_revision := FND_API.G_MISS_CHAR;
203: x_flow_schedule_rec.routing_revision_date := FND_API.G_MISS_DATE;
204: x_flow_schedule_rec.line_id := FND_API.G_MISS_NUM;
205: x_flow_schedule_rec.class_code := FND_API.G_MISS_CHAR;
206: x_flow_schedule_rec.schedule_group_id := FND_API.G_MISS_NUM;
207: x_flow_schedule_rec.material_account := FND_API.G_MISS_NUM;
208: x_flow_schedule_rec.material_overhead_account := FND_API.G_MISS_NUM;
201: x_flow_schedule_rec.alternate_routing_desig := FND_API.G_MISS_CHAR;
202: x_flow_schedule_rec.routing_revision := FND_API.G_MISS_CHAR;
203: x_flow_schedule_rec.routing_revision_date := FND_API.G_MISS_DATE;
204: x_flow_schedule_rec.line_id := FND_API.G_MISS_NUM;
205: x_flow_schedule_rec.class_code := FND_API.G_MISS_CHAR;
206: x_flow_schedule_rec.schedule_group_id := FND_API.G_MISS_NUM;
207: x_flow_schedule_rec.material_account := FND_API.G_MISS_NUM;
208: x_flow_schedule_rec.material_overhead_account := FND_API.G_MISS_NUM;
209: x_flow_schedule_rec.resource_account := FND_API.G_MISS_NUM;
202: x_flow_schedule_rec.routing_revision := FND_API.G_MISS_CHAR;
203: x_flow_schedule_rec.routing_revision_date := FND_API.G_MISS_DATE;
204: x_flow_schedule_rec.line_id := FND_API.G_MISS_NUM;
205: x_flow_schedule_rec.class_code := FND_API.G_MISS_CHAR;
206: x_flow_schedule_rec.schedule_group_id := FND_API.G_MISS_NUM;
207: x_flow_schedule_rec.material_account := FND_API.G_MISS_NUM;
208: x_flow_schedule_rec.material_overhead_account := FND_API.G_MISS_NUM;
209: x_flow_schedule_rec.resource_account := FND_API.G_MISS_NUM;
210: x_flow_schedule_rec.outside_processing_acct := FND_API.G_MISS_NUM;
203: x_flow_schedule_rec.routing_revision_date := FND_API.G_MISS_DATE;
204: x_flow_schedule_rec.line_id := FND_API.G_MISS_NUM;
205: x_flow_schedule_rec.class_code := FND_API.G_MISS_CHAR;
206: x_flow_schedule_rec.schedule_group_id := FND_API.G_MISS_NUM;
207: x_flow_schedule_rec.material_account := FND_API.G_MISS_NUM;
208: x_flow_schedule_rec.material_overhead_account := FND_API.G_MISS_NUM;
209: x_flow_schedule_rec.resource_account := FND_API.G_MISS_NUM;
210: x_flow_schedule_rec.outside_processing_acct := FND_API.G_MISS_NUM;
211: x_flow_schedule_rec.material_variance_account := FND_API.G_MISS_NUM;
204: x_flow_schedule_rec.line_id := FND_API.G_MISS_NUM;
205: x_flow_schedule_rec.class_code := FND_API.G_MISS_CHAR;
206: x_flow_schedule_rec.schedule_group_id := FND_API.G_MISS_NUM;
207: x_flow_schedule_rec.material_account := FND_API.G_MISS_NUM;
208: x_flow_schedule_rec.material_overhead_account := FND_API.G_MISS_NUM;
209: x_flow_schedule_rec.resource_account := FND_API.G_MISS_NUM;
210: x_flow_schedule_rec.outside_processing_acct := FND_API.G_MISS_NUM;
211: x_flow_schedule_rec.material_variance_account := FND_API.G_MISS_NUM;
212: x_flow_schedule_rec.resource_variance_account := FND_API.G_MISS_NUM;
205: x_flow_schedule_rec.class_code := FND_API.G_MISS_CHAR;
206: x_flow_schedule_rec.schedule_group_id := FND_API.G_MISS_NUM;
207: x_flow_schedule_rec.material_account := FND_API.G_MISS_NUM;
208: x_flow_schedule_rec.material_overhead_account := FND_API.G_MISS_NUM;
209: x_flow_schedule_rec.resource_account := FND_API.G_MISS_NUM;
210: x_flow_schedule_rec.outside_processing_acct := FND_API.G_MISS_NUM;
211: x_flow_schedule_rec.material_variance_account := FND_API.G_MISS_NUM;
212: x_flow_schedule_rec.resource_variance_account := FND_API.G_MISS_NUM;
213: x_flow_schedule_rec.outside_proc_var_acct := FND_API.G_MISS_NUM;
206: x_flow_schedule_rec.schedule_group_id := FND_API.G_MISS_NUM;
207: x_flow_schedule_rec.material_account := FND_API.G_MISS_NUM;
208: x_flow_schedule_rec.material_overhead_account := FND_API.G_MISS_NUM;
209: x_flow_schedule_rec.resource_account := FND_API.G_MISS_NUM;
210: x_flow_schedule_rec.outside_processing_acct := FND_API.G_MISS_NUM;
211: x_flow_schedule_rec.material_variance_account := FND_API.G_MISS_NUM;
212: x_flow_schedule_rec.resource_variance_account := FND_API.G_MISS_NUM;
213: x_flow_schedule_rec.outside_proc_var_acct := FND_API.G_MISS_NUM;
214: x_flow_schedule_rec.std_cost_adjustment_acct := FND_API.G_MISS_NUM;
207: x_flow_schedule_rec.material_account := FND_API.G_MISS_NUM;
208: x_flow_schedule_rec.material_overhead_account := FND_API.G_MISS_NUM;
209: x_flow_schedule_rec.resource_account := FND_API.G_MISS_NUM;
210: x_flow_schedule_rec.outside_processing_acct := FND_API.G_MISS_NUM;
211: x_flow_schedule_rec.material_variance_account := FND_API.G_MISS_NUM;
212: x_flow_schedule_rec.resource_variance_account := FND_API.G_MISS_NUM;
213: x_flow_schedule_rec.outside_proc_var_acct := FND_API.G_MISS_NUM;
214: x_flow_schedule_rec.std_cost_adjustment_acct := FND_API.G_MISS_NUM;
215: x_flow_schedule_rec.overhead_account := FND_API.G_MISS_NUM;
208: x_flow_schedule_rec.material_overhead_account := FND_API.G_MISS_NUM;
209: x_flow_schedule_rec.resource_account := FND_API.G_MISS_NUM;
210: x_flow_schedule_rec.outside_processing_acct := FND_API.G_MISS_NUM;
211: x_flow_schedule_rec.material_variance_account := FND_API.G_MISS_NUM;
212: x_flow_schedule_rec.resource_variance_account := FND_API.G_MISS_NUM;
213: x_flow_schedule_rec.outside_proc_var_acct := FND_API.G_MISS_NUM;
214: x_flow_schedule_rec.std_cost_adjustment_acct := FND_API.G_MISS_NUM;
215: x_flow_schedule_rec.overhead_account := FND_API.G_MISS_NUM;
216: x_flow_schedule_rec.overhead_variance_account := FND_API.G_MISS_NUM;
209: x_flow_schedule_rec.resource_account := FND_API.G_MISS_NUM;
210: x_flow_schedule_rec.outside_processing_acct := FND_API.G_MISS_NUM;
211: x_flow_schedule_rec.material_variance_account := FND_API.G_MISS_NUM;
212: x_flow_schedule_rec.resource_variance_account := FND_API.G_MISS_NUM;
213: x_flow_schedule_rec.outside_proc_var_acct := FND_API.G_MISS_NUM;
214: x_flow_schedule_rec.std_cost_adjustment_acct := FND_API.G_MISS_NUM;
215: x_flow_schedule_rec.overhead_account := FND_API.G_MISS_NUM;
216: x_flow_schedule_rec.overhead_variance_account := FND_API.G_MISS_NUM;
217: END IF;
210: x_flow_schedule_rec.outside_processing_acct := FND_API.G_MISS_NUM;
211: x_flow_schedule_rec.material_variance_account := FND_API.G_MISS_NUM;
212: x_flow_schedule_rec.resource_variance_account := FND_API.G_MISS_NUM;
213: x_flow_schedule_rec.outside_proc_var_acct := FND_API.G_MISS_NUM;
214: x_flow_schedule_rec.std_cost_adjustment_acct := FND_API.G_MISS_NUM;
215: x_flow_schedule_rec.overhead_account := FND_API.G_MISS_NUM;
216: x_flow_schedule_rec.overhead_variance_account := FND_API.G_MISS_NUM;
217: END IF;
218:
211: x_flow_schedule_rec.material_variance_account := FND_API.G_MISS_NUM;
212: x_flow_schedule_rec.resource_variance_account := FND_API.G_MISS_NUM;
213: x_flow_schedule_rec.outside_proc_var_acct := FND_API.G_MISS_NUM;
214: x_flow_schedule_rec.std_cost_adjustment_acct := FND_API.G_MISS_NUM;
215: x_flow_schedule_rec.overhead_account := FND_API.G_MISS_NUM;
216: x_flow_schedule_rec.overhead_variance_account := FND_API.G_MISS_NUM;
217: END IF;
218:
219: IF NOT MRP_GLOBALS.Equal(p_flow_schedule_rec.outside_processing_acct,p_old_flow_schedule_rec.outside_processing_acct)
212: x_flow_schedule_rec.resource_variance_account := FND_API.G_MISS_NUM;
213: x_flow_schedule_rec.outside_proc_var_acct := FND_API.G_MISS_NUM;
214: x_flow_schedule_rec.std_cost_adjustment_acct := FND_API.G_MISS_NUM;
215: x_flow_schedule_rec.overhead_account := FND_API.G_MISS_NUM;
216: x_flow_schedule_rec.overhead_variance_account := FND_API.G_MISS_NUM;
217: END IF;
218:
219: IF NOT MRP_GLOBALS.Equal(p_flow_schedule_rec.outside_processing_acct,p_old_flow_schedule_rec.outside_processing_acct)
220: THEN
237: END IF;
238:
239: IF NOT MRP_GLOBALS.Equal(p_flow_schedule_rec.planned_quantity,p_old_flow_schedule_rec.planned_quantity)
240: THEN
241: x_flow_schedule_rec.scheduled_start_date := FND_API.G_MISS_DATE;
242: END IF;
243:
244: IF NOT MRP_GLOBALS.Equal(p_flow_schedule_rec.primary_item_id,p_old_flow_schedule_rec.primary_item_id)
245: THEN
242: END IF;
243:
244: IF NOT MRP_GLOBALS.Equal(p_flow_schedule_rec.primary_item_id,p_old_flow_schedule_rec.primary_item_id)
245: THEN
246: x_flow_schedule_rec.completion_subinventory := FND_API.G_MISS_CHAR;
247: x_flow_schedule_rec.completion_locator_id := FND_API.G_MISS_NUM;
248: x_flow_schedule_rec.demand_source_header_id := FND_API.G_MISS_NUM;
249: x_flow_schedule_rec.demand_source_type := FND_API.G_MISS_NUM;
250: x_flow_schedule_rec.demand_source_line := FND_API.G_MISS_CHAR;
243:
244: IF NOT MRP_GLOBALS.Equal(p_flow_schedule_rec.primary_item_id,p_old_flow_schedule_rec.primary_item_id)
245: THEN
246: x_flow_schedule_rec.completion_subinventory := FND_API.G_MISS_CHAR;
247: x_flow_schedule_rec.completion_locator_id := FND_API.G_MISS_NUM;
248: x_flow_schedule_rec.demand_source_header_id := FND_API.G_MISS_NUM;
249: x_flow_schedule_rec.demand_source_type := FND_API.G_MISS_NUM;
250: x_flow_schedule_rec.demand_source_line := FND_API.G_MISS_CHAR;
251: x_flow_schedule_rec.demand_source_delivery := FND_API.G_MISS_CHAR;
244: IF NOT MRP_GLOBALS.Equal(p_flow_schedule_rec.primary_item_id,p_old_flow_schedule_rec.primary_item_id)
245: THEN
246: x_flow_schedule_rec.completion_subinventory := FND_API.G_MISS_CHAR;
247: x_flow_schedule_rec.completion_locator_id := FND_API.G_MISS_NUM;
248: x_flow_schedule_rec.demand_source_header_id := FND_API.G_MISS_NUM;
249: x_flow_schedule_rec.demand_source_type := FND_API.G_MISS_NUM;
250: x_flow_schedule_rec.demand_source_line := FND_API.G_MISS_CHAR;
251: x_flow_schedule_rec.demand_source_delivery := FND_API.G_MISS_CHAR;
252: x_flow_schedule_rec.alternate_bom_designator := FND_API.G_MISS_CHAR;
245: THEN
246: x_flow_schedule_rec.completion_subinventory := FND_API.G_MISS_CHAR;
247: x_flow_schedule_rec.completion_locator_id := FND_API.G_MISS_NUM;
248: x_flow_schedule_rec.demand_source_header_id := FND_API.G_MISS_NUM;
249: x_flow_schedule_rec.demand_source_type := FND_API.G_MISS_NUM;
250: x_flow_schedule_rec.demand_source_line := FND_API.G_MISS_CHAR;
251: x_flow_schedule_rec.demand_source_delivery := FND_API.G_MISS_CHAR;
252: x_flow_schedule_rec.alternate_bom_designator := FND_API.G_MISS_CHAR;
253: x_flow_schedule_rec.bom_revision := FND_API.G_MISS_CHAR;
246: x_flow_schedule_rec.completion_subinventory := FND_API.G_MISS_CHAR;
247: x_flow_schedule_rec.completion_locator_id := FND_API.G_MISS_NUM;
248: x_flow_schedule_rec.demand_source_header_id := FND_API.G_MISS_NUM;
249: x_flow_schedule_rec.demand_source_type := FND_API.G_MISS_NUM;
250: x_flow_schedule_rec.demand_source_line := FND_API.G_MISS_CHAR;
251: x_flow_schedule_rec.demand_source_delivery := FND_API.G_MISS_CHAR;
252: x_flow_schedule_rec.alternate_bom_designator := FND_API.G_MISS_CHAR;
253: x_flow_schedule_rec.bom_revision := FND_API.G_MISS_CHAR;
254: x_flow_schedule_rec.bom_revision_date := FND_API.G_MISS_DATE;
247: x_flow_schedule_rec.completion_locator_id := FND_API.G_MISS_NUM;
248: x_flow_schedule_rec.demand_source_header_id := FND_API.G_MISS_NUM;
249: x_flow_schedule_rec.demand_source_type := FND_API.G_MISS_NUM;
250: x_flow_schedule_rec.demand_source_line := FND_API.G_MISS_CHAR;
251: x_flow_schedule_rec.demand_source_delivery := FND_API.G_MISS_CHAR;
252: x_flow_schedule_rec.alternate_bom_designator := FND_API.G_MISS_CHAR;
253: x_flow_schedule_rec.bom_revision := FND_API.G_MISS_CHAR;
254: x_flow_schedule_rec.bom_revision_date := FND_API.G_MISS_DATE;
255: x_flow_schedule_rec.alternate_routing_desig := FND_API.G_MISS_CHAR;
248: x_flow_schedule_rec.demand_source_header_id := FND_API.G_MISS_NUM;
249: x_flow_schedule_rec.demand_source_type := FND_API.G_MISS_NUM;
250: x_flow_schedule_rec.demand_source_line := FND_API.G_MISS_CHAR;
251: x_flow_schedule_rec.demand_source_delivery := FND_API.G_MISS_CHAR;
252: x_flow_schedule_rec.alternate_bom_designator := FND_API.G_MISS_CHAR;
253: x_flow_schedule_rec.bom_revision := FND_API.G_MISS_CHAR;
254: x_flow_schedule_rec.bom_revision_date := FND_API.G_MISS_DATE;
255: x_flow_schedule_rec.alternate_routing_desig := FND_API.G_MISS_CHAR;
256: x_flow_schedule_rec.routing_revision := FND_API.G_MISS_CHAR;
249: x_flow_schedule_rec.demand_source_type := FND_API.G_MISS_NUM;
250: x_flow_schedule_rec.demand_source_line := FND_API.G_MISS_CHAR;
251: x_flow_schedule_rec.demand_source_delivery := FND_API.G_MISS_CHAR;
252: x_flow_schedule_rec.alternate_bom_designator := FND_API.G_MISS_CHAR;
253: x_flow_schedule_rec.bom_revision := FND_API.G_MISS_CHAR;
254: x_flow_schedule_rec.bom_revision_date := FND_API.G_MISS_DATE;
255: x_flow_schedule_rec.alternate_routing_desig := FND_API.G_MISS_CHAR;
256: x_flow_schedule_rec.routing_revision := FND_API.G_MISS_CHAR;
257: x_flow_schedule_rec.routing_revision_date := FND_API.G_MISS_DATE;
250: x_flow_schedule_rec.demand_source_line := FND_API.G_MISS_CHAR;
251: x_flow_schedule_rec.demand_source_delivery := FND_API.G_MISS_CHAR;
252: x_flow_schedule_rec.alternate_bom_designator := FND_API.G_MISS_CHAR;
253: x_flow_schedule_rec.bom_revision := FND_API.G_MISS_CHAR;
254: x_flow_schedule_rec.bom_revision_date := FND_API.G_MISS_DATE;
255: x_flow_schedule_rec.alternate_routing_desig := FND_API.G_MISS_CHAR;
256: x_flow_schedule_rec.routing_revision := FND_API.G_MISS_CHAR;
257: x_flow_schedule_rec.routing_revision_date := FND_API.G_MISS_DATE;
258: x_flow_schedule_rec.class_code := FND_API.G_MISS_CHAR;
251: x_flow_schedule_rec.demand_source_delivery := FND_API.G_MISS_CHAR;
252: x_flow_schedule_rec.alternate_bom_designator := FND_API.G_MISS_CHAR;
253: x_flow_schedule_rec.bom_revision := FND_API.G_MISS_CHAR;
254: x_flow_schedule_rec.bom_revision_date := FND_API.G_MISS_DATE;
255: x_flow_schedule_rec.alternate_routing_desig := FND_API.G_MISS_CHAR;
256: x_flow_schedule_rec.routing_revision := FND_API.G_MISS_CHAR;
257: x_flow_schedule_rec.routing_revision_date := FND_API.G_MISS_DATE;
258: x_flow_schedule_rec.class_code := FND_API.G_MISS_CHAR;
259: x_flow_schedule_rec.scheduled_start_date := FND_API.G_MISS_DATE;
252: x_flow_schedule_rec.alternate_bom_designator := FND_API.G_MISS_CHAR;
253: x_flow_schedule_rec.bom_revision := FND_API.G_MISS_CHAR;
254: x_flow_schedule_rec.bom_revision_date := FND_API.G_MISS_DATE;
255: x_flow_schedule_rec.alternate_routing_desig := FND_API.G_MISS_CHAR;
256: x_flow_schedule_rec.routing_revision := FND_API.G_MISS_CHAR;
257: x_flow_schedule_rec.routing_revision_date := FND_API.G_MISS_DATE;
258: x_flow_schedule_rec.class_code := FND_API.G_MISS_CHAR;
259: x_flow_schedule_rec.scheduled_start_date := FND_API.G_MISS_DATE;
260: x_flow_schedule_rec.material_account := FND_API.G_MISS_NUM;
253: x_flow_schedule_rec.bom_revision := FND_API.G_MISS_CHAR;
254: x_flow_schedule_rec.bom_revision_date := FND_API.G_MISS_DATE;
255: x_flow_schedule_rec.alternate_routing_desig := FND_API.G_MISS_CHAR;
256: x_flow_schedule_rec.routing_revision := FND_API.G_MISS_CHAR;
257: x_flow_schedule_rec.routing_revision_date := FND_API.G_MISS_DATE;
258: x_flow_schedule_rec.class_code := FND_API.G_MISS_CHAR;
259: x_flow_schedule_rec.scheduled_start_date := FND_API.G_MISS_DATE;
260: x_flow_schedule_rec.material_account := FND_API.G_MISS_NUM;
261: x_flow_schedule_rec.material_overhead_account := FND_API.G_MISS_NUM;
254: x_flow_schedule_rec.bom_revision_date := FND_API.G_MISS_DATE;
255: x_flow_schedule_rec.alternate_routing_desig := FND_API.G_MISS_CHAR;
256: x_flow_schedule_rec.routing_revision := FND_API.G_MISS_CHAR;
257: x_flow_schedule_rec.routing_revision_date := FND_API.G_MISS_DATE;
258: x_flow_schedule_rec.class_code := FND_API.G_MISS_CHAR;
259: x_flow_schedule_rec.scheduled_start_date := FND_API.G_MISS_DATE;
260: x_flow_schedule_rec.material_account := FND_API.G_MISS_NUM;
261: x_flow_schedule_rec.material_overhead_account := FND_API.G_MISS_NUM;
262: x_flow_schedule_rec.resource_account := FND_API.G_MISS_NUM;
255: x_flow_schedule_rec.alternate_routing_desig := FND_API.G_MISS_CHAR;
256: x_flow_schedule_rec.routing_revision := FND_API.G_MISS_CHAR;
257: x_flow_schedule_rec.routing_revision_date := FND_API.G_MISS_DATE;
258: x_flow_schedule_rec.class_code := FND_API.G_MISS_CHAR;
259: x_flow_schedule_rec.scheduled_start_date := FND_API.G_MISS_DATE;
260: x_flow_schedule_rec.material_account := FND_API.G_MISS_NUM;
261: x_flow_schedule_rec.material_overhead_account := FND_API.G_MISS_NUM;
262: x_flow_schedule_rec.resource_account := FND_API.G_MISS_NUM;
263: x_flow_schedule_rec.outside_processing_acct := FND_API.G_MISS_NUM;
256: x_flow_schedule_rec.routing_revision := FND_API.G_MISS_CHAR;
257: x_flow_schedule_rec.routing_revision_date := FND_API.G_MISS_DATE;
258: x_flow_schedule_rec.class_code := FND_API.G_MISS_CHAR;
259: x_flow_schedule_rec.scheduled_start_date := FND_API.G_MISS_DATE;
260: x_flow_schedule_rec.material_account := FND_API.G_MISS_NUM;
261: x_flow_schedule_rec.material_overhead_account := FND_API.G_MISS_NUM;
262: x_flow_schedule_rec.resource_account := FND_API.G_MISS_NUM;
263: x_flow_schedule_rec.outside_processing_acct := FND_API.G_MISS_NUM;
264: x_flow_schedule_rec.material_variance_account := FND_API.G_MISS_NUM;
257: x_flow_schedule_rec.routing_revision_date := FND_API.G_MISS_DATE;
258: x_flow_schedule_rec.class_code := FND_API.G_MISS_CHAR;
259: x_flow_schedule_rec.scheduled_start_date := FND_API.G_MISS_DATE;
260: x_flow_schedule_rec.material_account := FND_API.G_MISS_NUM;
261: x_flow_schedule_rec.material_overhead_account := FND_API.G_MISS_NUM;
262: x_flow_schedule_rec.resource_account := FND_API.G_MISS_NUM;
263: x_flow_schedule_rec.outside_processing_acct := FND_API.G_MISS_NUM;
264: x_flow_schedule_rec.material_variance_account := FND_API.G_MISS_NUM;
265: x_flow_schedule_rec.resource_variance_account := FND_API.G_MISS_NUM;
258: x_flow_schedule_rec.class_code := FND_API.G_MISS_CHAR;
259: x_flow_schedule_rec.scheduled_start_date := FND_API.G_MISS_DATE;
260: x_flow_schedule_rec.material_account := FND_API.G_MISS_NUM;
261: x_flow_schedule_rec.material_overhead_account := FND_API.G_MISS_NUM;
262: x_flow_schedule_rec.resource_account := FND_API.G_MISS_NUM;
263: x_flow_schedule_rec.outside_processing_acct := FND_API.G_MISS_NUM;
264: x_flow_schedule_rec.material_variance_account := FND_API.G_MISS_NUM;
265: x_flow_schedule_rec.resource_variance_account := FND_API.G_MISS_NUM;
266: x_flow_schedule_rec.outside_proc_var_acct := FND_API.G_MISS_NUM;
259: x_flow_schedule_rec.scheduled_start_date := FND_API.G_MISS_DATE;
260: x_flow_schedule_rec.material_account := FND_API.G_MISS_NUM;
261: x_flow_schedule_rec.material_overhead_account := FND_API.G_MISS_NUM;
262: x_flow_schedule_rec.resource_account := FND_API.G_MISS_NUM;
263: x_flow_schedule_rec.outside_processing_acct := FND_API.G_MISS_NUM;
264: x_flow_schedule_rec.material_variance_account := FND_API.G_MISS_NUM;
265: x_flow_schedule_rec.resource_variance_account := FND_API.G_MISS_NUM;
266: x_flow_schedule_rec.outside_proc_var_acct := FND_API.G_MISS_NUM;
267: x_flow_schedule_rec.std_cost_adjustment_acct := FND_API.G_MISS_NUM;
260: x_flow_schedule_rec.material_account := FND_API.G_MISS_NUM;
261: x_flow_schedule_rec.material_overhead_account := FND_API.G_MISS_NUM;
262: x_flow_schedule_rec.resource_account := FND_API.G_MISS_NUM;
263: x_flow_schedule_rec.outside_processing_acct := FND_API.G_MISS_NUM;
264: x_flow_schedule_rec.material_variance_account := FND_API.G_MISS_NUM;
265: x_flow_schedule_rec.resource_variance_account := FND_API.G_MISS_NUM;
266: x_flow_schedule_rec.outside_proc_var_acct := FND_API.G_MISS_NUM;
267: x_flow_schedule_rec.std_cost_adjustment_acct := FND_API.G_MISS_NUM;
268: x_flow_schedule_rec.overhead_account := FND_API.G_MISS_NUM;
261: x_flow_schedule_rec.material_overhead_account := FND_API.G_MISS_NUM;
262: x_flow_schedule_rec.resource_account := FND_API.G_MISS_NUM;
263: x_flow_schedule_rec.outside_processing_acct := FND_API.G_MISS_NUM;
264: x_flow_schedule_rec.material_variance_account := FND_API.G_MISS_NUM;
265: x_flow_schedule_rec.resource_variance_account := FND_API.G_MISS_NUM;
266: x_flow_schedule_rec.outside_proc_var_acct := FND_API.G_MISS_NUM;
267: x_flow_schedule_rec.std_cost_adjustment_acct := FND_API.G_MISS_NUM;
268: x_flow_schedule_rec.overhead_account := FND_API.G_MISS_NUM;
269: x_flow_schedule_rec.overhead_variance_account := FND_API.G_MISS_NUM;
262: x_flow_schedule_rec.resource_account := FND_API.G_MISS_NUM;
263: x_flow_schedule_rec.outside_processing_acct := FND_API.G_MISS_NUM;
264: x_flow_schedule_rec.material_variance_account := FND_API.G_MISS_NUM;
265: x_flow_schedule_rec.resource_variance_account := FND_API.G_MISS_NUM;
266: x_flow_schedule_rec.outside_proc_var_acct := FND_API.G_MISS_NUM;
267: x_flow_schedule_rec.std_cost_adjustment_acct := FND_API.G_MISS_NUM;
268: x_flow_schedule_rec.overhead_account := FND_API.G_MISS_NUM;
269: x_flow_schedule_rec.overhead_variance_account := FND_API.G_MISS_NUM;
270: END IF;
263: x_flow_schedule_rec.outside_processing_acct := FND_API.G_MISS_NUM;
264: x_flow_schedule_rec.material_variance_account := FND_API.G_MISS_NUM;
265: x_flow_schedule_rec.resource_variance_account := FND_API.G_MISS_NUM;
266: x_flow_schedule_rec.outside_proc_var_acct := FND_API.G_MISS_NUM;
267: x_flow_schedule_rec.std_cost_adjustment_acct := FND_API.G_MISS_NUM;
268: x_flow_schedule_rec.overhead_account := FND_API.G_MISS_NUM;
269: x_flow_schedule_rec.overhead_variance_account := FND_API.G_MISS_NUM;
270: END IF;
271:
264: x_flow_schedule_rec.material_variance_account := FND_API.G_MISS_NUM;
265: x_flow_schedule_rec.resource_variance_account := FND_API.G_MISS_NUM;
266: x_flow_schedule_rec.outside_proc_var_acct := FND_API.G_MISS_NUM;
267: x_flow_schedule_rec.std_cost_adjustment_acct := FND_API.G_MISS_NUM;
268: x_flow_schedule_rec.overhead_account := FND_API.G_MISS_NUM;
269: x_flow_schedule_rec.overhead_variance_account := FND_API.G_MISS_NUM;
270: END IF;
271:
272: IF NOT MRP_GLOBALS.Equal(p_flow_schedule_rec.program_application_id,p_old_flow_schedule_rec.program_application_id)
265: x_flow_schedule_rec.resource_variance_account := FND_API.G_MISS_NUM;
266: x_flow_schedule_rec.outside_proc_var_acct := FND_API.G_MISS_NUM;
267: x_flow_schedule_rec.std_cost_adjustment_acct := FND_API.G_MISS_NUM;
268: x_flow_schedule_rec.overhead_account := FND_API.G_MISS_NUM;
269: x_flow_schedule_rec.overhead_variance_account := FND_API.G_MISS_NUM;
270: END IF;
271:
272: IF NOT MRP_GLOBALS.Equal(p_flow_schedule_rec.program_application_id,p_old_flow_schedule_rec.program_application_id)
273: THEN
285: END IF;
286:
287: IF NOT MRP_GLOBALS.Equal(p_flow_schedule_rec.project_id,p_old_flow_schedule_rec.project_id)
288: THEN
289: x_flow_schedule_rec.task_id := FND_API.G_MISS_NUM;
290: x_flow_schedule_rec.class_code := FND_API.G_MISS_CHAR;
291: x_flow_schedule_rec.material_account := FND_API.G_MISS_NUM;
292: x_flow_schedule_rec.material_overhead_account := FND_API.G_MISS_NUM;
293: x_flow_schedule_rec.resource_account := FND_API.G_MISS_NUM;
286:
287: IF NOT MRP_GLOBALS.Equal(p_flow_schedule_rec.project_id,p_old_flow_schedule_rec.project_id)
288: THEN
289: x_flow_schedule_rec.task_id := FND_API.G_MISS_NUM;
290: x_flow_schedule_rec.class_code := FND_API.G_MISS_CHAR;
291: x_flow_schedule_rec.material_account := FND_API.G_MISS_NUM;
292: x_flow_schedule_rec.material_overhead_account := FND_API.G_MISS_NUM;
293: x_flow_schedule_rec.resource_account := FND_API.G_MISS_NUM;
294: x_flow_schedule_rec.outside_processing_acct := FND_API.G_MISS_NUM;
287: IF NOT MRP_GLOBALS.Equal(p_flow_schedule_rec.project_id,p_old_flow_schedule_rec.project_id)
288: THEN
289: x_flow_schedule_rec.task_id := FND_API.G_MISS_NUM;
290: x_flow_schedule_rec.class_code := FND_API.G_MISS_CHAR;
291: x_flow_schedule_rec.material_account := FND_API.G_MISS_NUM;
292: x_flow_schedule_rec.material_overhead_account := FND_API.G_MISS_NUM;
293: x_flow_schedule_rec.resource_account := FND_API.G_MISS_NUM;
294: x_flow_schedule_rec.outside_processing_acct := FND_API.G_MISS_NUM;
295: x_flow_schedule_rec.material_variance_account := FND_API.G_MISS_NUM;
288: THEN
289: x_flow_schedule_rec.task_id := FND_API.G_MISS_NUM;
290: x_flow_schedule_rec.class_code := FND_API.G_MISS_CHAR;
291: x_flow_schedule_rec.material_account := FND_API.G_MISS_NUM;
292: x_flow_schedule_rec.material_overhead_account := FND_API.G_MISS_NUM;
293: x_flow_schedule_rec.resource_account := FND_API.G_MISS_NUM;
294: x_flow_schedule_rec.outside_processing_acct := FND_API.G_MISS_NUM;
295: x_flow_schedule_rec.material_variance_account := FND_API.G_MISS_NUM;
296: x_flow_schedule_rec.resource_variance_account := FND_API.G_MISS_NUM;
289: x_flow_schedule_rec.task_id := FND_API.G_MISS_NUM;
290: x_flow_schedule_rec.class_code := FND_API.G_MISS_CHAR;
291: x_flow_schedule_rec.material_account := FND_API.G_MISS_NUM;
292: x_flow_schedule_rec.material_overhead_account := FND_API.G_MISS_NUM;
293: x_flow_schedule_rec.resource_account := FND_API.G_MISS_NUM;
294: x_flow_schedule_rec.outside_processing_acct := FND_API.G_MISS_NUM;
295: x_flow_schedule_rec.material_variance_account := FND_API.G_MISS_NUM;
296: x_flow_schedule_rec.resource_variance_account := FND_API.G_MISS_NUM;
297: x_flow_schedule_rec.outside_proc_var_acct := FND_API.G_MISS_NUM;
290: x_flow_schedule_rec.class_code := FND_API.G_MISS_CHAR;
291: x_flow_schedule_rec.material_account := FND_API.G_MISS_NUM;
292: x_flow_schedule_rec.material_overhead_account := FND_API.G_MISS_NUM;
293: x_flow_schedule_rec.resource_account := FND_API.G_MISS_NUM;
294: x_flow_schedule_rec.outside_processing_acct := FND_API.G_MISS_NUM;
295: x_flow_schedule_rec.material_variance_account := FND_API.G_MISS_NUM;
296: x_flow_schedule_rec.resource_variance_account := FND_API.G_MISS_NUM;
297: x_flow_schedule_rec.outside_proc_var_acct := FND_API.G_MISS_NUM;
298: x_flow_schedule_rec.std_cost_adjustment_acct := FND_API.G_MISS_NUM;
291: x_flow_schedule_rec.material_account := FND_API.G_MISS_NUM;
292: x_flow_schedule_rec.material_overhead_account := FND_API.G_MISS_NUM;
293: x_flow_schedule_rec.resource_account := FND_API.G_MISS_NUM;
294: x_flow_schedule_rec.outside_processing_acct := FND_API.G_MISS_NUM;
295: x_flow_schedule_rec.material_variance_account := FND_API.G_MISS_NUM;
296: x_flow_schedule_rec.resource_variance_account := FND_API.G_MISS_NUM;
297: x_flow_schedule_rec.outside_proc_var_acct := FND_API.G_MISS_NUM;
298: x_flow_schedule_rec.std_cost_adjustment_acct := FND_API.G_MISS_NUM;
299: x_flow_schedule_rec.overhead_account := FND_API.G_MISS_NUM;
292: x_flow_schedule_rec.material_overhead_account := FND_API.G_MISS_NUM;
293: x_flow_schedule_rec.resource_account := FND_API.G_MISS_NUM;
294: x_flow_schedule_rec.outside_processing_acct := FND_API.G_MISS_NUM;
295: x_flow_schedule_rec.material_variance_account := FND_API.G_MISS_NUM;
296: x_flow_schedule_rec.resource_variance_account := FND_API.G_MISS_NUM;
297: x_flow_schedule_rec.outside_proc_var_acct := FND_API.G_MISS_NUM;
298: x_flow_schedule_rec.std_cost_adjustment_acct := FND_API.G_MISS_NUM;
299: x_flow_schedule_rec.overhead_account := FND_API.G_MISS_NUM;
300: x_flow_schedule_rec.overhead_variance_account := FND_API.G_MISS_NUM;
293: x_flow_schedule_rec.resource_account := FND_API.G_MISS_NUM;
294: x_flow_schedule_rec.outside_processing_acct := FND_API.G_MISS_NUM;
295: x_flow_schedule_rec.material_variance_account := FND_API.G_MISS_NUM;
296: x_flow_schedule_rec.resource_variance_account := FND_API.G_MISS_NUM;
297: x_flow_schedule_rec.outside_proc_var_acct := FND_API.G_MISS_NUM;
298: x_flow_schedule_rec.std_cost_adjustment_acct := FND_API.G_MISS_NUM;
299: x_flow_schedule_rec.overhead_account := FND_API.G_MISS_NUM;
300: x_flow_schedule_rec.overhead_variance_account := FND_API.G_MISS_NUM;
301: END IF;
294: x_flow_schedule_rec.outside_processing_acct := FND_API.G_MISS_NUM;
295: x_flow_schedule_rec.material_variance_account := FND_API.G_MISS_NUM;
296: x_flow_schedule_rec.resource_variance_account := FND_API.G_MISS_NUM;
297: x_flow_schedule_rec.outside_proc_var_acct := FND_API.G_MISS_NUM;
298: x_flow_schedule_rec.std_cost_adjustment_acct := FND_API.G_MISS_NUM;
299: x_flow_schedule_rec.overhead_account := FND_API.G_MISS_NUM;
300: x_flow_schedule_rec.overhead_variance_account := FND_API.G_MISS_NUM;
301: END IF;
302:
295: x_flow_schedule_rec.material_variance_account := FND_API.G_MISS_NUM;
296: x_flow_schedule_rec.resource_variance_account := FND_API.G_MISS_NUM;
297: x_flow_schedule_rec.outside_proc_var_acct := FND_API.G_MISS_NUM;
298: x_flow_schedule_rec.std_cost_adjustment_acct := FND_API.G_MISS_NUM;
299: x_flow_schedule_rec.overhead_account := FND_API.G_MISS_NUM;
300: x_flow_schedule_rec.overhead_variance_account := FND_API.G_MISS_NUM;
301: END IF;
302:
303: IF NOT MRP_GLOBALS.Equal(p_flow_schedule_rec.quantity_completed,p_old_flow_schedule_rec.quantity_completed)
296: x_flow_schedule_rec.resource_variance_account := FND_API.G_MISS_NUM;
297: x_flow_schedule_rec.outside_proc_var_acct := FND_API.G_MISS_NUM;
298: x_flow_schedule_rec.std_cost_adjustment_acct := FND_API.G_MISS_NUM;
299: x_flow_schedule_rec.overhead_account := FND_API.G_MISS_NUM;
300: x_flow_schedule_rec.overhead_variance_account := FND_API.G_MISS_NUM;
301: END IF;
302:
303: IF NOT MRP_GLOBALS.Equal(p_flow_schedule_rec.quantity_completed,p_old_flow_schedule_rec.quantity_completed)
304: THEN
321: END IF;
322:
323: IF NOT MRP_GLOBALS.Equal(p_flow_schedule_rec.routing_revision,p_old_flow_schedule_rec.routing_revision)
324: THEN
325: x_flow_schedule_rec.routing_revision_date := FND_API.G_MISS_DATE;
326: END IF;
327:
328: IF NOT MRP_GLOBALS.Equal(p_flow_schedule_rec.routing_revision_date,p_old_flow_schedule_rec.routing_revision_date)
329: THEN
331: END IF;
332:
333: IF NOT MRP_GLOBALS.Equal(p_flow_schedule_rec.scheduled_completion_date,p_old_flow_schedule_rec.scheduled_completion_date)
334: THEN
335: x_flow_schedule_rec.scheduled_start_date := FND_API.G_MISS_DATE;
336: x_flow_schedule_rec.bom_revision := FND_API.G_MISS_CHAR;
337: x_flow_schedule_rec.bom_revision_date := FND_API.G_MISS_DATE;
338: x_flow_schedule_rec.routing_revision := FND_API.G_MISS_CHAR;
339: x_flow_schedule_rec.routing_revision_date := FND_API.G_MISS_DATE;
332:
333: IF NOT MRP_GLOBALS.Equal(p_flow_schedule_rec.scheduled_completion_date,p_old_flow_schedule_rec.scheduled_completion_date)
334: THEN
335: x_flow_schedule_rec.scheduled_start_date := FND_API.G_MISS_DATE;
336: x_flow_schedule_rec.bom_revision := FND_API.G_MISS_CHAR;
337: x_flow_schedule_rec.bom_revision_date := FND_API.G_MISS_DATE;
338: x_flow_schedule_rec.routing_revision := FND_API.G_MISS_CHAR;
339: x_flow_schedule_rec.routing_revision_date := FND_API.G_MISS_DATE;
340: END IF;
333: IF NOT MRP_GLOBALS.Equal(p_flow_schedule_rec.scheduled_completion_date,p_old_flow_schedule_rec.scheduled_completion_date)
334: THEN
335: x_flow_schedule_rec.scheduled_start_date := FND_API.G_MISS_DATE;
336: x_flow_schedule_rec.bom_revision := FND_API.G_MISS_CHAR;
337: x_flow_schedule_rec.bom_revision_date := FND_API.G_MISS_DATE;
338: x_flow_schedule_rec.routing_revision := FND_API.G_MISS_CHAR;
339: x_flow_schedule_rec.routing_revision_date := FND_API.G_MISS_DATE;
340: END IF;
341:
334: THEN
335: x_flow_schedule_rec.scheduled_start_date := FND_API.G_MISS_DATE;
336: x_flow_schedule_rec.bom_revision := FND_API.G_MISS_CHAR;
337: x_flow_schedule_rec.bom_revision_date := FND_API.G_MISS_DATE;
338: x_flow_schedule_rec.routing_revision := FND_API.G_MISS_CHAR;
339: x_flow_schedule_rec.routing_revision_date := FND_API.G_MISS_DATE;
340: END IF;
341:
342: IF NOT MRP_GLOBALS.Equal(p_flow_schedule_rec.scheduled_flag,p_old_flow_schedule_rec.scheduled_flag)
335: x_flow_schedule_rec.scheduled_start_date := FND_API.G_MISS_DATE;
336: x_flow_schedule_rec.bom_revision := FND_API.G_MISS_CHAR;
337: x_flow_schedule_rec.bom_revision_date := FND_API.G_MISS_DATE;
338: x_flow_schedule_rec.routing_revision := FND_API.G_MISS_CHAR;
339: x_flow_schedule_rec.routing_revision_date := FND_API.G_MISS_DATE;
340: END IF;
341:
342: IF NOT MRP_GLOBALS.Equal(p_flow_schedule_rec.scheduled_flag,p_old_flow_schedule_rec.scheduled_flag)
343: THEN
353: -- when schedule group is changed
354: /*
355: IF NOT MRP_GLOBALS.Equal(p_flow_schedule_rec.schedule_group_id,p_old_flow_schedule_rec.schedule_group_id)
356: THEN
357: x_flow_schedule_rec.build_sequence := FND_API.G_MISS_NUM;
358: END IF;
359: */
360:
361: IF NOT MRP_GLOBALS.Equal(p_flow_schedule_rec.schedule_number,p_old_flow_schedule_rec.schedule_number)
383: NULL;
384: END IF;
385:
386: ELSIF p_attr_id = G_ALTERNATE_BOM_DESIGNATOR THEN
387: x_flow_schedule_rec.bom_revision := FND_API.G_MISS_CHAR;
388: x_flow_schedule_rec.bom_revision_date := FND_API.G_MISS_DATE;
389: ELSIF p_attr_id = G_ALTERNATE_ROUTING_DESIG THEN
390: x_flow_schedule_rec.routing_revision := FND_API.G_MISS_CHAR;
391: x_flow_schedule_rec.routing_revision_date := FND_API.G_MISS_DATE;
384: END IF;
385:
386: ELSIF p_attr_id = G_ALTERNATE_BOM_DESIGNATOR THEN
387: x_flow_schedule_rec.bom_revision := FND_API.G_MISS_CHAR;
388: x_flow_schedule_rec.bom_revision_date := FND_API.G_MISS_DATE;
389: ELSIF p_attr_id = G_ALTERNATE_ROUTING_DESIG THEN
390: x_flow_schedule_rec.routing_revision := FND_API.G_MISS_CHAR;
391: x_flow_schedule_rec.routing_revision_date := FND_API.G_MISS_DATE;
392: x_flow_schedule_rec.completion_subinventory := FND_API.G_MISS_CHAR;
386: ELSIF p_attr_id = G_ALTERNATE_BOM_DESIGNATOR THEN
387: x_flow_schedule_rec.bom_revision := FND_API.G_MISS_CHAR;
388: x_flow_schedule_rec.bom_revision_date := FND_API.G_MISS_DATE;
389: ELSIF p_attr_id = G_ALTERNATE_ROUTING_DESIG THEN
390: x_flow_schedule_rec.routing_revision := FND_API.G_MISS_CHAR;
391: x_flow_schedule_rec.routing_revision_date := FND_API.G_MISS_DATE;
392: x_flow_schedule_rec.completion_subinventory := FND_API.G_MISS_CHAR;
393: x_flow_schedule_rec.completion_locator_id := FND_API.G_MISS_NUM;
394: ELSIF p_attr_id = G_BOM_REVISION THEN
387: x_flow_schedule_rec.bom_revision := FND_API.G_MISS_CHAR;
388: x_flow_schedule_rec.bom_revision_date := FND_API.G_MISS_DATE;
389: ELSIF p_attr_id = G_ALTERNATE_ROUTING_DESIG THEN
390: x_flow_schedule_rec.routing_revision := FND_API.G_MISS_CHAR;
391: x_flow_schedule_rec.routing_revision_date := FND_API.G_MISS_DATE;
392: x_flow_schedule_rec.completion_subinventory := FND_API.G_MISS_CHAR;
393: x_flow_schedule_rec.completion_locator_id := FND_API.G_MISS_NUM;
394: ELSIF p_attr_id = G_BOM_REVISION THEN
395: x_flow_schedule_rec.bom_revision_date := FND_API.G_MISS_DATE;
388: x_flow_schedule_rec.bom_revision_date := FND_API.G_MISS_DATE;
389: ELSIF p_attr_id = G_ALTERNATE_ROUTING_DESIG THEN
390: x_flow_schedule_rec.routing_revision := FND_API.G_MISS_CHAR;
391: x_flow_schedule_rec.routing_revision_date := FND_API.G_MISS_DATE;
392: x_flow_schedule_rec.completion_subinventory := FND_API.G_MISS_CHAR;
393: x_flow_schedule_rec.completion_locator_id := FND_API.G_MISS_NUM;
394: ELSIF p_attr_id = G_BOM_REVISION THEN
395: x_flow_schedule_rec.bom_revision_date := FND_API.G_MISS_DATE;
396: ELSIF p_attr_id = G_BOM_REVISION_DATE THEN
389: ELSIF p_attr_id = G_ALTERNATE_ROUTING_DESIG THEN
390: x_flow_schedule_rec.routing_revision := FND_API.G_MISS_CHAR;
391: x_flow_schedule_rec.routing_revision_date := FND_API.G_MISS_DATE;
392: x_flow_schedule_rec.completion_subinventory := FND_API.G_MISS_CHAR;
393: x_flow_schedule_rec.completion_locator_id := FND_API.G_MISS_NUM;
394: ELSIF p_attr_id = G_BOM_REVISION THEN
395: x_flow_schedule_rec.bom_revision_date := FND_API.G_MISS_DATE;
396: ELSIF p_attr_id = G_BOM_REVISION_DATE THEN
397: NULL;
391: x_flow_schedule_rec.routing_revision_date := FND_API.G_MISS_DATE;
392: x_flow_schedule_rec.completion_subinventory := FND_API.G_MISS_CHAR;
393: x_flow_schedule_rec.completion_locator_id := FND_API.G_MISS_NUM;
394: ELSIF p_attr_id = G_BOM_REVISION THEN
395: x_flow_schedule_rec.bom_revision_date := FND_API.G_MISS_DATE;
396: ELSIF p_attr_id = G_BOM_REVISION_DATE THEN
397: NULL;
398: ELSIF p_attr_id = G_BUILD_SEQUENCE THEN
399: NULL;
397: NULL;
398: ELSIF p_attr_id = G_BUILD_SEQUENCE THEN
399: NULL;
400: ELSIF p_attr_id = G_CLASS THEN
401: x_flow_schedule_rec.material_account := FND_API.G_MISS_NUM;
402: x_flow_schedule_rec.material_overhead_account := FND_API.G_MISS_NUM;
403: x_flow_schedule_rec.resource_account := FND_API.G_MISS_NUM;
404: x_flow_schedule_rec.outside_processing_acct := FND_API.G_MISS_NUM;
405: x_flow_schedule_rec.material_variance_account := FND_API.G_MISS_NUM;
398: ELSIF p_attr_id = G_BUILD_SEQUENCE THEN
399: NULL;
400: ELSIF p_attr_id = G_CLASS THEN
401: x_flow_schedule_rec.material_account := FND_API.G_MISS_NUM;
402: x_flow_schedule_rec.material_overhead_account := FND_API.G_MISS_NUM;
403: x_flow_schedule_rec.resource_account := FND_API.G_MISS_NUM;
404: x_flow_schedule_rec.outside_processing_acct := FND_API.G_MISS_NUM;
405: x_flow_schedule_rec.material_variance_account := FND_API.G_MISS_NUM;
406: x_flow_schedule_rec.resource_variance_account := FND_API.G_MISS_NUM;
399: NULL;
400: ELSIF p_attr_id = G_CLASS THEN
401: x_flow_schedule_rec.material_account := FND_API.G_MISS_NUM;
402: x_flow_schedule_rec.material_overhead_account := FND_API.G_MISS_NUM;
403: x_flow_schedule_rec.resource_account := FND_API.G_MISS_NUM;
404: x_flow_schedule_rec.outside_processing_acct := FND_API.G_MISS_NUM;
405: x_flow_schedule_rec.material_variance_account := FND_API.G_MISS_NUM;
406: x_flow_schedule_rec.resource_variance_account := FND_API.G_MISS_NUM;
407: x_flow_schedule_rec.outside_proc_var_acct := FND_API.G_MISS_NUM;
400: ELSIF p_attr_id = G_CLASS THEN
401: x_flow_schedule_rec.material_account := FND_API.G_MISS_NUM;
402: x_flow_schedule_rec.material_overhead_account := FND_API.G_MISS_NUM;
403: x_flow_schedule_rec.resource_account := FND_API.G_MISS_NUM;
404: x_flow_schedule_rec.outside_processing_acct := FND_API.G_MISS_NUM;
405: x_flow_schedule_rec.material_variance_account := FND_API.G_MISS_NUM;
406: x_flow_schedule_rec.resource_variance_account := FND_API.G_MISS_NUM;
407: x_flow_schedule_rec.outside_proc_var_acct := FND_API.G_MISS_NUM;
408: x_flow_schedule_rec.std_cost_adjustment_acct := FND_API.G_MISS_NUM;
401: x_flow_schedule_rec.material_account := FND_API.G_MISS_NUM;
402: x_flow_schedule_rec.material_overhead_account := FND_API.G_MISS_NUM;
403: x_flow_schedule_rec.resource_account := FND_API.G_MISS_NUM;
404: x_flow_schedule_rec.outside_processing_acct := FND_API.G_MISS_NUM;
405: x_flow_schedule_rec.material_variance_account := FND_API.G_MISS_NUM;
406: x_flow_schedule_rec.resource_variance_account := FND_API.G_MISS_NUM;
407: x_flow_schedule_rec.outside_proc_var_acct := FND_API.G_MISS_NUM;
408: x_flow_schedule_rec.std_cost_adjustment_acct := FND_API.G_MISS_NUM;
409: x_flow_schedule_rec.overhead_account := FND_API.G_MISS_NUM;
402: x_flow_schedule_rec.material_overhead_account := FND_API.G_MISS_NUM;
403: x_flow_schedule_rec.resource_account := FND_API.G_MISS_NUM;
404: x_flow_schedule_rec.outside_processing_acct := FND_API.G_MISS_NUM;
405: x_flow_schedule_rec.material_variance_account := FND_API.G_MISS_NUM;
406: x_flow_schedule_rec.resource_variance_account := FND_API.G_MISS_NUM;
407: x_flow_schedule_rec.outside_proc_var_acct := FND_API.G_MISS_NUM;
408: x_flow_schedule_rec.std_cost_adjustment_acct := FND_API.G_MISS_NUM;
409: x_flow_schedule_rec.overhead_account := FND_API.G_MISS_NUM;
410: x_flow_schedule_rec.overhead_variance_account := FND_API.G_MISS_NUM;
403: x_flow_schedule_rec.resource_account := FND_API.G_MISS_NUM;
404: x_flow_schedule_rec.outside_processing_acct := FND_API.G_MISS_NUM;
405: x_flow_schedule_rec.material_variance_account := FND_API.G_MISS_NUM;
406: x_flow_schedule_rec.resource_variance_account := FND_API.G_MISS_NUM;
407: x_flow_schedule_rec.outside_proc_var_acct := FND_API.G_MISS_NUM;
408: x_flow_schedule_rec.std_cost_adjustment_acct := FND_API.G_MISS_NUM;
409: x_flow_schedule_rec.overhead_account := FND_API.G_MISS_NUM;
410: x_flow_schedule_rec.overhead_variance_account := FND_API.G_MISS_NUM;
411: ELSIF p_attr_id = G_COMPLETION_LOCATOR THEN
404: x_flow_schedule_rec.outside_processing_acct := FND_API.G_MISS_NUM;
405: x_flow_schedule_rec.material_variance_account := FND_API.G_MISS_NUM;
406: x_flow_schedule_rec.resource_variance_account := FND_API.G_MISS_NUM;
407: x_flow_schedule_rec.outside_proc_var_acct := FND_API.G_MISS_NUM;
408: x_flow_schedule_rec.std_cost_adjustment_acct := FND_API.G_MISS_NUM;
409: x_flow_schedule_rec.overhead_account := FND_API.G_MISS_NUM;
410: x_flow_schedule_rec.overhead_variance_account := FND_API.G_MISS_NUM;
411: ELSIF p_attr_id = G_COMPLETION_LOCATOR THEN
412: NULL;
405: x_flow_schedule_rec.material_variance_account := FND_API.G_MISS_NUM;
406: x_flow_schedule_rec.resource_variance_account := FND_API.G_MISS_NUM;
407: x_flow_schedule_rec.outside_proc_var_acct := FND_API.G_MISS_NUM;
408: x_flow_schedule_rec.std_cost_adjustment_acct := FND_API.G_MISS_NUM;
409: x_flow_schedule_rec.overhead_account := FND_API.G_MISS_NUM;
410: x_flow_schedule_rec.overhead_variance_account := FND_API.G_MISS_NUM;
411: ELSIF p_attr_id = G_COMPLETION_LOCATOR THEN
412: NULL;
413: ELSIF p_attr_id = G_COMPLETION_SUBINVENTORY THEN
406: x_flow_schedule_rec.resource_variance_account := FND_API.G_MISS_NUM;
407: x_flow_schedule_rec.outside_proc_var_acct := FND_API.G_MISS_NUM;
408: x_flow_schedule_rec.std_cost_adjustment_acct := FND_API.G_MISS_NUM;
409: x_flow_schedule_rec.overhead_account := FND_API.G_MISS_NUM;
410: x_flow_schedule_rec.overhead_variance_account := FND_API.G_MISS_NUM;
411: ELSIF p_attr_id = G_COMPLETION_LOCATOR THEN
412: NULL;
413: ELSIF p_attr_id = G_COMPLETION_SUBINVENTORY THEN
414: x_flow_schedule_rec.completion_locator_id := FND_API.G_MISS_NUM;
410: x_flow_schedule_rec.overhead_variance_account := FND_API.G_MISS_NUM;
411: ELSIF p_attr_id = G_COMPLETION_LOCATOR THEN
412: NULL;
413: ELSIF p_attr_id = G_COMPLETION_SUBINVENTORY THEN
414: x_flow_schedule_rec.completion_locator_id := FND_API.G_MISS_NUM;
415: ELSIF p_attr_id = G_CREATED_BY THEN
416: NULL;
417: ELSIF p_attr_id = G_CREATION_DATE THEN
418: NULL;
422: NULL;
423: ELSIF p_attr_id = G_DEMAND_SOURCE_DELIVERY THEN
424: NULL;
425: ELSIF p_attr_id = G_DEMAND_SOURCE_HEADER THEN
426: x_flow_schedule_rec.demand_source_line := FND_API.G_MISS_CHAR;
427: x_flow_schedule_rec.demand_source_delivery := FND_API.G_MISS_CHAR;
428: ELSIF p_attr_id = G_DEMAND_SOURCE_LINE THEN
429: NULL;
430: ELSIF p_attr_id = G_DEMAND_SOURCE_TYPE THEN
423: ELSIF p_attr_id = G_DEMAND_SOURCE_DELIVERY THEN
424: NULL;
425: ELSIF p_attr_id = G_DEMAND_SOURCE_HEADER THEN
426: x_flow_schedule_rec.demand_source_line := FND_API.G_MISS_CHAR;
427: x_flow_schedule_rec.demand_source_delivery := FND_API.G_MISS_CHAR;
428: ELSIF p_attr_id = G_DEMAND_SOURCE_LINE THEN
429: NULL;
430: ELSIF p_attr_id = G_DEMAND_SOURCE_TYPE THEN
431: NULL;
447: NULL;
448: ELSIF p_attr_id = G_MPS_SCHEDULED_COMP_DATE THEN
449: NULL;
450: ELSIF p_attr_id = G_ORGANIZATION THEN
451: x_flow_schedule_rec.primary_item_id := FND_API.G_MISS_NUM;
452: x_flow_schedule_rec.completion_subinventory := FND_API.G_MISS_CHAR;
453: x_flow_schedule_rec.completion_locator_id := FND_API.G_MISS_NUM;
454: x_flow_schedule_rec.demand_source_header_id := FND_API.G_MISS_NUM;
455: x_flow_schedule_rec.demand_source_type := FND_API.G_MISS_NUM;
448: ELSIF p_attr_id = G_MPS_SCHEDULED_COMP_DATE THEN
449: NULL;
450: ELSIF p_attr_id = G_ORGANIZATION THEN
451: x_flow_schedule_rec.primary_item_id := FND_API.G_MISS_NUM;
452: x_flow_schedule_rec.completion_subinventory := FND_API.G_MISS_CHAR;
453: x_flow_schedule_rec.completion_locator_id := FND_API.G_MISS_NUM;
454: x_flow_schedule_rec.demand_source_header_id := FND_API.G_MISS_NUM;
455: x_flow_schedule_rec.demand_source_type := FND_API.G_MISS_NUM;
456: x_flow_schedule_rec.demand_source_line := FND_API.G_MISS_CHAR;
449: NULL;
450: ELSIF p_attr_id = G_ORGANIZATION THEN
451: x_flow_schedule_rec.primary_item_id := FND_API.G_MISS_NUM;
452: x_flow_schedule_rec.completion_subinventory := FND_API.G_MISS_CHAR;
453: x_flow_schedule_rec.completion_locator_id := FND_API.G_MISS_NUM;
454: x_flow_schedule_rec.demand_source_header_id := FND_API.G_MISS_NUM;
455: x_flow_schedule_rec.demand_source_type := FND_API.G_MISS_NUM;
456: x_flow_schedule_rec.demand_source_line := FND_API.G_MISS_CHAR;
457: x_flow_schedule_rec.demand_source_delivery := FND_API.G_MISS_CHAR;
450: ELSIF p_attr_id = G_ORGANIZATION THEN
451: x_flow_schedule_rec.primary_item_id := FND_API.G_MISS_NUM;
452: x_flow_schedule_rec.completion_subinventory := FND_API.G_MISS_CHAR;
453: x_flow_schedule_rec.completion_locator_id := FND_API.G_MISS_NUM;
454: x_flow_schedule_rec.demand_source_header_id := FND_API.G_MISS_NUM;
455: x_flow_schedule_rec.demand_source_type := FND_API.G_MISS_NUM;
456: x_flow_schedule_rec.demand_source_line := FND_API.G_MISS_CHAR;
457: x_flow_schedule_rec.demand_source_delivery := FND_API.G_MISS_CHAR;
458: x_flow_schedule_rec.alternate_bom_designator := FND_API.G_MISS_CHAR;
451: x_flow_schedule_rec.primary_item_id := FND_API.G_MISS_NUM;
452: x_flow_schedule_rec.completion_subinventory := FND_API.G_MISS_CHAR;
453: x_flow_schedule_rec.completion_locator_id := FND_API.G_MISS_NUM;
454: x_flow_schedule_rec.demand_source_header_id := FND_API.G_MISS_NUM;
455: x_flow_schedule_rec.demand_source_type := FND_API.G_MISS_NUM;
456: x_flow_schedule_rec.demand_source_line := FND_API.G_MISS_CHAR;
457: x_flow_schedule_rec.demand_source_delivery := FND_API.G_MISS_CHAR;
458: x_flow_schedule_rec.alternate_bom_designator := FND_API.G_MISS_CHAR;
459: x_flow_schedule_rec.bom_revision := FND_API.G_MISS_CHAR;
452: x_flow_schedule_rec.completion_subinventory := FND_API.G_MISS_CHAR;
453: x_flow_schedule_rec.completion_locator_id := FND_API.G_MISS_NUM;
454: x_flow_schedule_rec.demand_source_header_id := FND_API.G_MISS_NUM;
455: x_flow_schedule_rec.demand_source_type := FND_API.G_MISS_NUM;
456: x_flow_schedule_rec.demand_source_line := FND_API.G_MISS_CHAR;
457: x_flow_schedule_rec.demand_source_delivery := FND_API.G_MISS_CHAR;
458: x_flow_schedule_rec.alternate_bom_designator := FND_API.G_MISS_CHAR;
459: x_flow_schedule_rec.bom_revision := FND_API.G_MISS_CHAR;
460: x_flow_schedule_rec.bom_revision_date := FND_API.G_MISS_DATE;
453: x_flow_schedule_rec.completion_locator_id := FND_API.G_MISS_NUM;
454: x_flow_schedule_rec.demand_source_header_id := FND_API.G_MISS_NUM;
455: x_flow_schedule_rec.demand_source_type := FND_API.G_MISS_NUM;
456: x_flow_schedule_rec.demand_source_line := FND_API.G_MISS_CHAR;
457: x_flow_schedule_rec.demand_source_delivery := FND_API.G_MISS_CHAR;
458: x_flow_schedule_rec.alternate_bom_designator := FND_API.G_MISS_CHAR;
459: x_flow_schedule_rec.bom_revision := FND_API.G_MISS_CHAR;
460: x_flow_schedule_rec.bom_revision_date := FND_API.G_MISS_DATE;
461: x_flow_schedule_rec.alternate_routing_desig := FND_API.G_MISS_CHAR;
454: x_flow_schedule_rec.demand_source_header_id := FND_API.G_MISS_NUM;
455: x_flow_schedule_rec.demand_source_type := FND_API.G_MISS_NUM;
456: x_flow_schedule_rec.demand_source_line := FND_API.G_MISS_CHAR;
457: x_flow_schedule_rec.demand_source_delivery := FND_API.G_MISS_CHAR;
458: x_flow_schedule_rec.alternate_bom_designator := FND_API.G_MISS_CHAR;
459: x_flow_schedule_rec.bom_revision := FND_API.G_MISS_CHAR;
460: x_flow_schedule_rec.bom_revision_date := FND_API.G_MISS_DATE;
461: x_flow_schedule_rec.alternate_routing_desig := FND_API.G_MISS_CHAR;
462: x_flow_schedule_rec.routing_revision := FND_API.G_MISS_CHAR;
455: x_flow_schedule_rec.demand_source_type := FND_API.G_MISS_NUM;
456: x_flow_schedule_rec.demand_source_line := FND_API.G_MISS_CHAR;
457: x_flow_schedule_rec.demand_source_delivery := FND_API.G_MISS_CHAR;
458: x_flow_schedule_rec.alternate_bom_designator := FND_API.G_MISS_CHAR;
459: x_flow_schedule_rec.bom_revision := FND_API.G_MISS_CHAR;
460: x_flow_schedule_rec.bom_revision_date := FND_API.G_MISS_DATE;
461: x_flow_schedule_rec.alternate_routing_desig := FND_API.G_MISS_CHAR;
462: x_flow_schedule_rec.routing_revision := FND_API.G_MISS_CHAR;
463: x_flow_schedule_rec.routing_revision_date := FND_API.G_MISS_DATE;
456: x_flow_schedule_rec.demand_source_line := FND_API.G_MISS_CHAR;
457: x_flow_schedule_rec.demand_source_delivery := FND_API.G_MISS_CHAR;
458: x_flow_schedule_rec.alternate_bom_designator := FND_API.G_MISS_CHAR;
459: x_flow_schedule_rec.bom_revision := FND_API.G_MISS_CHAR;
460: x_flow_schedule_rec.bom_revision_date := FND_API.G_MISS_DATE;
461: x_flow_schedule_rec.alternate_routing_desig := FND_API.G_MISS_CHAR;
462: x_flow_schedule_rec.routing_revision := FND_API.G_MISS_CHAR;
463: x_flow_schedule_rec.routing_revision_date := FND_API.G_MISS_DATE;
464: x_flow_schedule_rec.line_id := FND_API.G_MISS_NUM;
457: x_flow_schedule_rec.demand_source_delivery := FND_API.G_MISS_CHAR;
458: x_flow_schedule_rec.alternate_bom_designator := FND_API.G_MISS_CHAR;
459: x_flow_schedule_rec.bom_revision := FND_API.G_MISS_CHAR;
460: x_flow_schedule_rec.bom_revision_date := FND_API.G_MISS_DATE;
461: x_flow_schedule_rec.alternate_routing_desig := FND_API.G_MISS_CHAR;
462: x_flow_schedule_rec.routing_revision := FND_API.G_MISS_CHAR;
463: x_flow_schedule_rec.routing_revision_date := FND_API.G_MISS_DATE;
464: x_flow_schedule_rec.line_id := FND_API.G_MISS_NUM;
465: x_flow_schedule_rec.class_code := FND_API.G_MISS_CHAR;
458: x_flow_schedule_rec.alternate_bom_designator := FND_API.G_MISS_CHAR;
459: x_flow_schedule_rec.bom_revision := FND_API.G_MISS_CHAR;
460: x_flow_schedule_rec.bom_revision_date := FND_API.G_MISS_DATE;
461: x_flow_schedule_rec.alternate_routing_desig := FND_API.G_MISS_CHAR;
462: x_flow_schedule_rec.routing_revision := FND_API.G_MISS_CHAR;
463: x_flow_schedule_rec.routing_revision_date := FND_API.G_MISS_DATE;
464: x_flow_schedule_rec.line_id := FND_API.G_MISS_NUM;
465: x_flow_schedule_rec.class_code := FND_API.G_MISS_CHAR;
466: x_flow_schedule_rec.schedule_group_id := FND_API.G_MISS_NUM;
459: x_flow_schedule_rec.bom_revision := FND_API.G_MISS_CHAR;
460: x_flow_schedule_rec.bom_revision_date := FND_API.G_MISS_DATE;
461: x_flow_schedule_rec.alternate_routing_desig := FND_API.G_MISS_CHAR;
462: x_flow_schedule_rec.routing_revision := FND_API.G_MISS_CHAR;
463: x_flow_schedule_rec.routing_revision_date := FND_API.G_MISS_DATE;
464: x_flow_schedule_rec.line_id := FND_API.G_MISS_NUM;
465: x_flow_schedule_rec.class_code := FND_API.G_MISS_CHAR;
466: x_flow_schedule_rec.schedule_group_id := FND_API.G_MISS_NUM;
467: x_flow_schedule_rec.material_account := FND_API.G_MISS_NUM;
460: x_flow_schedule_rec.bom_revision_date := FND_API.G_MISS_DATE;
461: x_flow_schedule_rec.alternate_routing_desig := FND_API.G_MISS_CHAR;
462: x_flow_schedule_rec.routing_revision := FND_API.G_MISS_CHAR;
463: x_flow_schedule_rec.routing_revision_date := FND_API.G_MISS_DATE;
464: x_flow_schedule_rec.line_id := FND_API.G_MISS_NUM;
465: x_flow_schedule_rec.class_code := FND_API.G_MISS_CHAR;
466: x_flow_schedule_rec.schedule_group_id := FND_API.G_MISS_NUM;
467: x_flow_schedule_rec.material_account := FND_API.G_MISS_NUM;
468: x_flow_schedule_rec.material_overhead_account := FND_API.G_MISS_NUM;
461: x_flow_schedule_rec.alternate_routing_desig := FND_API.G_MISS_CHAR;
462: x_flow_schedule_rec.routing_revision := FND_API.G_MISS_CHAR;
463: x_flow_schedule_rec.routing_revision_date := FND_API.G_MISS_DATE;
464: x_flow_schedule_rec.line_id := FND_API.G_MISS_NUM;
465: x_flow_schedule_rec.class_code := FND_API.G_MISS_CHAR;
466: x_flow_schedule_rec.schedule_group_id := FND_API.G_MISS_NUM;
467: x_flow_schedule_rec.material_account := FND_API.G_MISS_NUM;
468: x_flow_schedule_rec.material_overhead_account := FND_API.G_MISS_NUM;
469: x_flow_schedule_rec.resource_account := FND_API.G_MISS_NUM;
462: x_flow_schedule_rec.routing_revision := FND_API.G_MISS_CHAR;
463: x_flow_schedule_rec.routing_revision_date := FND_API.G_MISS_DATE;
464: x_flow_schedule_rec.line_id := FND_API.G_MISS_NUM;
465: x_flow_schedule_rec.class_code := FND_API.G_MISS_CHAR;
466: x_flow_schedule_rec.schedule_group_id := FND_API.G_MISS_NUM;
467: x_flow_schedule_rec.material_account := FND_API.G_MISS_NUM;
468: x_flow_schedule_rec.material_overhead_account := FND_API.G_MISS_NUM;
469: x_flow_schedule_rec.resource_account := FND_API.G_MISS_NUM;
470: x_flow_schedule_rec.outside_processing_acct := FND_API.G_MISS_NUM;
463: x_flow_schedule_rec.routing_revision_date := FND_API.G_MISS_DATE;
464: x_flow_schedule_rec.line_id := FND_API.G_MISS_NUM;
465: x_flow_schedule_rec.class_code := FND_API.G_MISS_CHAR;
466: x_flow_schedule_rec.schedule_group_id := FND_API.G_MISS_NUM;
467: x_flow_schedule_rec.material_account := FND_API.G_MISS_NUM;
468: x_flow_schedule_rec.material_overhead_account := FND_API.G_MISS_NUM;
469: x_flow_schedule_rec.resource_account := FND_API.G_MISS_NUM;
470: x_flow_schedule_rec.outside_processing_acct := FND_API.G_MISS_NUM;
471: x_flow_schedule_rec.material_variance_account := FND_API.G_MISS_NUM;
464: x_flow_schedule_rec.line_id := FND_API.G_MISS_NUM;
465: x_flow_schedule_rec.class_code := FND_API.G_MISS_CHAR;
466: x_flow_schedule_rec.schedule_group_id := FND_API.G_MISS_NUM;
467: x_flow_schedule_rec.material_account := FND_API.G_MISS_NUM;
468: x_flow_schedule_rec.material_overhead_account := FND_API.G_MISS_NUM;
469: x_flow_schedule_rec.resource_account := FND_API.G_MISS_NUM;
470: x_flow_schedule_rec.outside_processing_acct := FND_API.G_MISS_NUM;
471: x_flow_schedule_rec.material_variance_account := FND_API.G_MISS_NUM;
472: x_flow_schedule_rec.resource_variance_account := FND_API.G_MISS_NUM;
465: x_flow_schedule_rec.class_code := FND_API.G_MISS_CHAR;
466: x_flow_schedule_rec.schedule_group_id := FND_API.G_MISS_NUM;
467: x_flow_schedule_rec.material_account := FND_API.G_MISS_NUM;
468: x_flow_schedule_rec.material_overhead_account := FND_API.G_MISS_NUM;
469: x_flow_schedule_rec.resource_account := FND_API.G_MISS_NUM;
470: x_flow_schedule_rec.outside_processing_acct := FND_API.G_MISS_NUM;
471: x_flow_schedule_rec.material_variance_account := FND_API.G_MISS_NUM;
472: x_flow_schedule_rec.resource_variance_account := FND_API.G_MISS_NUM;
473: x_flow_schedule_rec.outside_proc_var_acct := FND_API.G_MISS_NUM;
466: x_flow_schedule_rec.schedule_group_id := FND_API.G_MISS_NUM;
467: x_flow_schedule_rec.material_account := FND_API.G_MISS_NUM;
468: x_flow_schedule_rec.material_overhead_account := FND_API.G_MISS_NUM;
469: x_flow_schedule_rec.resource_account := FND_API.G_MISS_NUM;
470: x_flow_schedule_rec.outside_processing_acct := FND_API.G_MISS_NUM;
471: x_flow_schedule_rec.material_variance_account := FND_API.G_MISS_NUM;
472: x_flow_schedule_rec.resource_variance_account := FND_API.G_MISS_NUM;
473: x_flow_schedule_rec.outside_proc_var_acct := FND_API.G_MISS_NUM;
474: x_flow_schedule_rec.std_cost_adjustment_acct := FND_API.G_MISS_NUM;
467: x_flow_schedule_rec.material_account := FND_API.G_MISS_NUM;
468: x_flow_schedule_rec.material_overhead_account := FND_API.G_MISS_NUM;
469: x_flow_schedule_rec.resource_account := FND_API.G_MISS_NUM;
470: x_flow_schedule_rec.outside_processing_acct := FND_API.G_MISS_NUM;
471: x_flow_schedule_rec.material_variance_account := FND_API.G_MISS_NUM;
472: x_flow_schedule_rec.resource_variance_account := FND_API.G_MISS_NUM;
473: x_flow_schedule_rec.outside_proc_var_acct := FND_API.G_MISS_NUM;
474: x_flow_schedule_rec.std_cost_adjustment_acct := FND_API.G_MISS_NUM;
475: x_flow_schedule_rec.overhead_account := FND_API.G_MISS_NUM;
468: x_flow_schedule_rec.material_overhead_account := FND_API.G_MISS_NUM;
469: x_flow_schedule_rec.resource_account := FND_API.G_MISS_NUM;
470: x_flow_schedule_rec.outside_processing_acct := FND_API.G_MISS_NUM;
471: x_flow_schedule_rec.material_variance_account := FND_API.G_MISS_NUM;
472: x_flow_schedule_rec.resource_variance_account := FND_API.G_MISS_NUM;
473: x_flow_schedule_rec.outside_proc_var_acct := FND_API.G_MISS_NUM;
474: x_flow_schedule_rec.std_cost_adjustment_acct := FND_API.G_MISS_NUM;
475: x_flow_schedule_rec.overhead_account := FND_API.G_MISS_NUM;
476: x_flow_schedule_rec.overhead_variance_account := FND_API.G_MISS_NUM;
469: x_flow_schedule_rec.resource_account := FND_API.G_MISS_NUM;
470: x_flow_schedule_rec.outside_processing_acct := FND_API.G_MISS_NUM;
471: x_flow_schedule_rec.material_variance_account := FND_API.G_MISS_NUM;
472: x_flow_schedule_rec.resource_variance_account := FND_API.G_MISS_NUM;
473: x_flow_schedule_rec.outside_proc_var_acct := FND_API.G_MISS_NUM;
474: x_flow_schedule_rec.std_cost_adjustment_acct := FND_API.G_MISS_NUM;
475: x_flow_schedule_rec.overhead_account := FND_API.G_MISS_NUM;
476: x_flow_schedule_rec.overhead_variance_account := FND_API.G_MISS_NUM;
477: ELSIF p_attr_id = G_OUTSIDE_PROCESSING_ACCT THEN
470: x_flow_schedule_rec.outside_processing_acct := FND_API.G_MISS_NUM;
471: x_flow_schedule_rec.material_variance_account := FND_API.G_MISS_NUM;
472: x_flow_schedule_rec.resource_variance_account := FND_API.G_MISS_NUM;
473: x_flow_schedule_rec.outside_proc_var_acct := FND_API.G_MISS_NUM;
474: x_flow_schedule_rec.std_cost_adjustment_acct := FND_API.G_MISS_NUM;
475: x_flow_schedule_rec.overhead_account := FND_API.G_MISS_NUM;
476: x_flow_schedule_rec.overhead_variance_account := FND_API.G_MISS_NUM;
477: ELSIF p_attr_id = G_OUTSIDE_PROCESSING_ACCT THEN
478: NULL;
471: x_flow_schedule_rec.material_variance_account := FND_API.G_MISS_NUM;
472: x_flow_schedule_rec.resource_variance_account := FND_API.G_MISS_NUM;
473: x_flow_schedule_rec.outside_proc_var_acct := FND_API.G_MISS_NUM;
474: x_flow_schedule_rec.std_cost_adjustment_acct := FND_API.G_MISS_NUM;
475: x_flow_schedule_rec.overhead_account := FND_API.G_MISS_NUM;
476: x_flow_schedule_rec.overhead_variance_account := FND_API.G_MISS_NUM;
477: ELSIF p_attr_id = G_OUTSIDE_PROCESSING_ACCT THEN
478: NULL;
479: ELSIF p_attr_id = G_OUTSIDE_PROC_VAR_ACCT THEN
472: x_flow_schedule_rec.resource_variance_account := FND_API.G_MISS_NUM;
473: x_flow_schedule_rec.outside_proc_var_acct := FND_API.G_MISS_NUM;
474: x_flow_schedule_rec.std_cost_adjustment_acct := FND_API.G_MISS_NUM;
475: x_flow_schedule_rec.overhead_account := FND_API.G_MISS_NUM;
476: x_flow_schedule_rec.overhead_variance_account := FND_API.G_MISS_NUM;
477: ELSIF p_attr_id = G_OUTSIDE_PROCESSING_ACCT THEN
478: NULL;
479: ELSIF p_attr_id = G_OUTSIDE_PROC_VAR_ACCT THEN
480: NULL;
482: NULL;
483: ELSIF p_attr_id = G_OVERHEAD_VARIANCE_ACCOUNT THEN
484: NULL;
485: ELSIF p_attr_id = G_PLANNED_QUANTITY THEN
486: x_flow_schedule_rec.scheduled_start_date := FND_API.G_MISS_DATE;
487: ELSIF p_attr_id = G_PRIMARY_ITEM THEN
488: x_flow_schedule_rec.completion_subinventory := FND_API.G_MISS_CHAR;
489: x_flow_schedule_rec.completion_locator_id := FND_API.G_MISS_NUM;
490: x_flow_schedule_rec.demand_source_header_id := FND_API.G_MISS_NUM;
484: NULL;
485: ELSIF p_attr_id = G_PLANNED_QUANTITY THEN
486: x_flow_schedule_rec.scheduled_start_date := FND_API.G_MISS_DATE;
487: ELSIF p_attr_id = G_PRIMARY_ITEM THEN
488: x_flow_schedule_rec.completion_subinventory := FND_API.G_MISS_CHAR;
489: x_flow_schedule_rec.completion_locator_id := FND_API.G_MISS_NUM;
490: x_flow_schedule_rec.demand_source_header_id := FND_API.G_MISS_NUM;
491: x_flow_schedule_rec.demand_source_type := FND_API.G_MISS_NUM;
492: x_flow_schedule_rec.demand_source_line := FND_API.G_MISS_CHAR;
485: ELSIF p_attr_id = G_PLANNED_QUANTITY THEN
486: x_flow_schedule_rec.scheduled_start_date := FND_API.G_MISS_DATE;
487: ELSIF p_attr_id = G_PRIMARY_ITEM THEN
488: x_flow_schedule_rec.completion_subinventory := FND_API.G_MISS_CHAR;
489: x_flow_schedule_rec.completion_locator_id := FND_API.G_MISS_NUM;
490: x_flow_schedule_rec.demand_source_header_id := FND_API.G_MISS_NUM;
491: x_flow_schedule_rec.demand_source_type := FND_API.G_MISS_NUM;
492: x_flow_schedule_rec.demand_source_line := FND_API.G_MISS_CHAR;
493: x_flow_schedule_rec.demand_source_delivery := FND_API.G_MISS_CHAR;
486: x_flow_schedule_rec.scheduled_start_date := FND_API.G_MISS_DATE;
487: ELSIF p_attr_id = G_PRIMARY_ITEM THEN
488: x_flow_schedule_rec.completion_subinventory := FND_API.G_MISS_CHAR;
489: x_flow_schedule_rec.completion_locator_id := FND_API.G_MISS_NUM;
490: x_flow_schedule_rec.demand_source_header_id := FND_API.G_MISS_NUM;
491: x_flow_schedule_rec.demand_source_type := FND_API.G_MISS_NUM;
492: x_flow_schedule_rec.demand_source_line := FND_API.G_MISS_CHAR;
493: x_flow_schedule_rec.demand_source_delivery := FND_API.G_MISS_CHAR;
494: x_flow_schedule_rec.alternate_bom_designator := FND_API.G_MISS_CHAR;
487: ELSIF p_attr_id = G_PRIMARY_ITEM THEN
488: x_flow_schedule_rec.completion_subinventory := FND_API.G_MISS_CHAR;
489: x_flow_schedule_rec.completion_locator_id := FND_API.G_MISS_NUM;
490: x_flow_schedule_rec.demand_source_header_id := FND_API.G_MISS_NUM;
491: x_flow_schedule_rec.demand_source_type := FND_API.G_MISS_NUM;
492: x_flow_schedule_rec.demand_source_line := FND_API.G_MISS_CHAR;
493: x_flow_schedule_rec.demand_source_delivery := FND_API.G_MISS_CHAR;
494: x_flow_schedule_rec.alternate_bom_designator := FND_API.G_MISS_CHAR;
495: x_flow_schedule_rec.bom_revision := FND_API.G_MISS_CHAR;
488: x_flow_schedule_rec.completion_subinventory := FND_API.G_MISS_CHAR;
489: x_flow_schedule_rec.completion_locator_id := FND_API.G_MISS_NUM;
490: x_flow_schedule_rec.demand_source_header_id := FND_API.G_MISS_NUM;
491: x_flow_schedule_rec.demand_source_type := FND_API.G_MISS_NUM;
492: x_flow_schedule_rec.demand_source_line := FND_API.G_MISS_CHAR;
493: x_flow_schedule_rec.demand_source_delivery := FND_API.G_MISS_CHAR;
494: x_flow_schedule_rec.alternate_bom_designator := FND_API.G_MISS_CHAR;
495: x_flow_schedule_rec.bom_revision := FND_API.G_MISS_CHAR;
496: x_flow_schedule_rec.bom_revision_date := FND_API.G_MISS_DATE;
489: x_flow_schedule_rec.completion_locator_id := FND_API.G_MISS_NUM;
490: x_flow_schedule_rec.demand_source_header_id := FND_API.G_MISS_NUM;
491: x_flow_schedule_rec.demand_source_type := FND_API.G_MISS_NUM;
492: x_flow_schedule_rec.demand_source_line := FND_API.G_MISS_CHAR;
493: x_flow_schedule_rec.demand_source_delivery := FND_API.G_MISS_CHAR;
494: x_flow_schedule_rec.alternate_bom_designator := FND_API.G_MISS_CHAR;
495: x_flow_schedule_rec.bom_revision := FND_API.G_MISS_CHAR;
496: x_flow_schedule_rec.bom_revision_date := FND_API.G_MISS_DATE;
497: x_flow_schedule_rec.alternate_routing_desig := FND_API.G_MISS_CHAR;
490: x_flow_schedule_rec.demand_source_header_id := FND_API.G_MISS_NUM;
491: x_flow_schedule_rec.demand_source_type := FND_API.G_MISS_NUM;
492: x_flow_schedule_rec.demand_source_line := FND_API.G_MISS_CHAR;
493: x_flow_schedule_rec.demand_source_delivery := FND_API.G_MISS_CHAR;
494: x_flow_schedule_rec.alternate_bom_designator := FND_API.G_MISS_CHAR;
495: x_flow_schedule_rec.bom_revision := FND_API.G_MISS_CHAR;
496: x_flow_schedule_rec.bom_revision_date := FND_API.G_MISS_DATE;
497: x_flow_schedule_rec.alternate_routing_desig := FND_API.G_MISS_CHAR;
498: x_flow_schedule_rec.routing_revision := FND_API.G_MISS_CHAR;
491: x_flow_schedule_rec.demand_source_type := FND_API.G_MISS_NUM;
492: x_flow_schedule_rec.demand_source_line := FND_API.G_MISS_CHAR;
493: x_flow_schedule_rec.demand_source_delivery := FND_API.G_MISS_CHAR;
494: x_flow_schedule_rec.alternate_bom_designator := FND_API.G_MISS_CHAR;
495: x_flow_schedule_rec.bom_revision := FND_API.G_MISS_CHAR;
496: x_flow_schedule_rec.bom_revision_date := FND_API.G_MISS_DATE;
497: x_flow_schedule_rec.alternate_routing_desig := FND_API.G_MISS_CHAR;
498: x_flow_schedule_rec.routing_revision := FND_API.G_MISS_CHAR;
499: x_flow_schedule_rec.routing_revision_date := FND_API.G_MISS_DATE;
492: x_flow_schedule_rec.demand_source_line := FND_API.G_MISS_CHAR;
493: x_flow_schedule_rec.demand_source_delivery := FND_API.G_MISS_CHAR;
494: x_flow_schedule_rec.alternate_bom_designator := FND_API.G_MISS_CHAR;
495: x_flow_schedule_rec.bom_revision := FND_API.G_MISS_CHAR;
496: x_flow_schedule_rec.bom_revision_date := FND_API.G_MISS_DATE;
497: x_flow_schedule_rec.alternate_routing_desig := FND_API.G_MISS_CHAR;
498: x_flow_schedule_rec.routing_revision := FND_API.G_MISS_CHAR;
499: x_flow_schedule_rec.routing_revision_date := FND_API.G_MISS_DATE;
500: x_flow_schedule_rec.class_code := FND_API.G_MISS_CHAR;
493: x_flow_schedule_rec.demand_source_delivery := FND_API.G_MISS_CHAR;
494: x_flow_schedule_rec.alternate_bom_designator := FND_API.G_MISS_CHAR;
495: x_flow_schedule_rec.bom_revision := FND_API.G_MISS_CHAR;
496: x_flow_schedule_rec.bom_revision_date := FND_API.G_MISS_DATE;
497: x_flow_schedule_rec.alternate_routing_desig := FND_API.G_MISS_CHAR;
498: x_flow_schedule_rec.routing_revision := FND_API.G_MISS_CHAR;
499: x_flow_schedule_rec.routing_revision_date := FND_API.G_MISS_DATE;
500: x_flow_schedule_rec.class_code := FND_API.G_MISS_CHAR;
501: x_flow_schedule_rec.scheduled_start_date := FND_API.G_MISS_DATE;
494: x_flow_schedule_rec.alternate_bom_designator := FND_API.G_MISS_CHAR;
495: x_flow_schedule_rec.bom_revision := FND_API.G_MISS_CHAR;
496: x_flow_schedule_rec.bom_revision_date := FND_API.G_MISS_DATE;
497: x_flow_schedule_rec.alternate_routing_desig := FND_API.G_MISS_CHAR;
498: x_flow_schedule_rec.routing_revision := FND_API.G_MISS_CHAR;
499: x_flow_schedule_rec.routing_revision_date := FND_API.G_MISS_DATE;
500: x_flow_schedule_rec.class_code := FND_API.G_MISS_CHAR;
501: x_flow_schedule_rec.scheduled_start_date := FND_API.G_MISS_DATE;
502: x_flow_schedule_rec.material_account := FND_API.G_MISS_NUM;
495: x_flow_schedule_rec.bom_revision := FND_API.G_MISS_CHAR;
496: x_flow_schedule_rec.bom_revision_date := FND_API.G_MISS_DATE;
497: x_flow_schedule_rec.alternate_routing_desig := FND_API.G_MISS_CHAR;
498: x_flow_schedule_rec.routing_revision := FND_API.G_MISS_CHAR;
499: x_flow_schedule_rec.routing_revision_date := FND_API.G_MISS_DATE;
500: x_flow_schedule_rec.class_code := FND_API.G_MISS_CHAR;
501: x_flow_schedule_rec.scheduled_start_date := FND_API.G_MISS_DATE;
502: x_flow_schedule_rec.material_account := FND_API.G_MISS_NUM;
503: x_flow_schedule_rec.material_overhead_account := FND_API.G_MISS_NUM;
496: x_flow_schedule_rec.bom_revision_date := FND_API.G_MISS_DATE;
497: x_flow_schedule_rec.alternate_routing_desig := FND_API.G_MISS_CHAR;
498: x_flow_schedule_rec.routing_revision := FND_API.G_MISS_CHAR;
499: x_flow_schedule_rec.routing_revision_date := FND_API.G_MISS_DATE;
500: x_flow_schedule_rec.class_code := FND_API.G_MISS_CHAR;
501: x_flow_schedule_rec.scheduled_start_date := FND_API.G_MISS_DATE;
502: x_flow_schedule_rec.material_account := FND_API.G_MISS_NUM;
503: x_flow_schedule_rec.material_overhead_account := FND_API.G_MISS_NUM;
504: x_flow_schedule_rec.resource_account := FND_API.G_MISS_NUM;
497: x_flow_schedule_rec.alternate_routing_desig := FND_API.G_MISS_CHAR;
498: x_flow_schedule_rec.routing_revision := FND_API.G_MISS_CHAR;
499: x_flow_schedule_rec.routing_revision_date := FND_API.G_MISS_DATE;
500: x_flow_schedule_rec.class_code := FND_API.G_MISS_CHAR;
501: x_flow_schedule_rec.scheduled_start_date := FND_API.G_MISS_DATE;
502: x_flow_schedule_rec.material_account := FND_API.G_MISS_NUM;
503: x_flow_schedule_rec.material_overhead_account := FND_API.G_MISS_NUM;
504: x_flow_schedule_rec.resource_account := FND_API.G_MISS_NUM;
505: x_flow_schedule_rec.outside_processing_acct := FND_API.G_MISS_NUM;
498: x_flow_schedule_rec.routing_revision := FND_API.G_MISS_CHAR;
499: x_flow_schedule_rec.routing_revision_date := FND_API.G_MISS_DATE;
500: x_flow_schedule_rec.class_code := FND_API.G_MISS_CHAR;
501: x_flow_schedule_rec.scheduled_start_date := FND_API.G_MISS_DATE;
502: x_flow_schedule_rec.material_account := FND_API.G_MISS_NUM;
503: x_flow_schedule_rec.material_overhead_account := FND_API.G_MISS_NUM;
504: x_flow_schedule_rec.resource_account := FND_API.G_MISS_NUM;
505: x_flow_schedule_rec.outside_processing_acct := FND_API.G_MISS_NUM;
506: x_flow_schedule_rec.material_variance_account := FND_API.G_MISS_NUM;
499: x_flow_schedule_rec.routing_revision_date := FND_API.G_MISS_DATE;
500: x_flow_schedule_rec.class_code := FND_API.G_MISS_CHAR;
501: x_flow_schedule_rec.scheduled_start_date := FND_API.G_MISS_DATE;
502: x_flow_schedule_rec.material_account := FND_API.G_MISS_NUM;
503: x_flow_schedule_rec.material_overhead_account := FND_API.G_MISS_NUM;
504: x_flow_schedule_rec.resource_account := FND_API.G_MISS_NUM;
505: x_flow_schedule_rec.outside_processing_acct := FND_API.G_MISS_NUM;
506: x_flow_schedule_rec.material_variance_account := FND_API.G_MISS_NUM;
507: x_flow_schedule_rec.resource_variance_account := FND_API.G_MISS_NUM;
500: x_flow_schedule_rec.class_code := FND_API.G_MISS_CHAR;
501: x_flow_schedule_rec.scheduled_start_date := FND_API.G_MISS_DATE;
502: x_flow_schedule_rec.material_account := FND_API.G_MISS_NUM;
503: x_flow_schedule_rec.material_overhead_account := FND_API.G_MISS_NUM;
504: x_flow_schedule_rec.resource_account := FND_API.G_MISS_NUM;
505: x_flow_schedule_rec.outside_processing_acct := FND_API.G_MISS_NUM;
506: x_flow_schedule_rec.material_variance_account := FND_API.G_MISS_NUM;
507: x_flow_schedule_rec.resource_variance_account := FND_API.G_MISS_NUM;
508: x_flow_schedule_rec.outside_proc_var_acct := FND_API.G_MISS_NUM;
501: x_flow_schedule_rec.scheduled_start_date := FND_API.G_MISS_DATE;
502: x_flow_schedule_rec.material_account := FND_API.G_MISS_NUM;
503: x_flow_schedule_rec.material_overhead_account := FND_API.G_MISS_NUM;
504: x_flow_schedule_rec.resource_account := FND_API.G_MISS_NUM;
505: x_flow_schedule_rec.outside_processing_acct := FND_API.G_MISS_NUM;
506: x_flow_schedule_rec.material_variance_account := FND_API.G_MISS_NUM;
507: x_flow_schedule_rec.resource_variance_account := FND_API.G_MISS_NUM;
508: x_flow_schedule_rec.outside_proc_var_acct := FND_API.G_MISS_NUM;
509: x_flow_schedule_rec.std_cost_adjustment_acct := FND_API.G_MISS_NUM;
502: x_flow_schedule_rec.material_account := FND_API.G_MISS_NUM;
503: x_flow_schedule_rec.material_overhead_account := FND_API.G_MISS_NUM;
504: x_flow_schedule_rec.resource_account := FND_API.G_MISS_NUM;
505: x_flow_schedule_rec.outside_processing_acct := FND_API.G_MISS_NUM;
506: x_flow_schedule_rec.material_variance_account := FND_API.G_MISS_NUM;
507: x_flow_schedule_rec.resource_variance_account := FND_API.G_MISS_NUM;
508: x_flow_schedule_rec.outside_proc_var_acct := FND_API.G_MISS_NUM;
509: x_flow_schedule_rec.std_cost_adjustment_acct := FND_API.G_MISS_NUM;
510: x_flow_schedule_rec.overhead_account := FND_API.G_MISS_NUM;
503: x_flow_schedule_rec.material_overhead_account := FND_API.G_MISS_NUM;
504: x_flow_schedule_rec.resource_account := FND_API.G_MISS_NUM;
505: x_flow_schedule_rec.outside_processing_acct := FND_API.G_MISS_NUM;
506: x_flow_schedule_rec.material_variance_account := FND_API.G_MISS_NUM;
507: x_flow_schedule_rec.resource_variance_account := FND_API.G_MISS_NUM;
508: x_flow_schedule_rec.outside_proc_var_acct := FND_API.G_MISS_NUM;
509: x_flow_schedule_rec.std_cost_adjustment_acct := FND_API.G_MISS_NUM;
510: x_flow_schedule_rec.overhead_account := FND_API.G_MISS_NUM;
511: x_flow_schedule_rec.overhead_variance_account := FND_API.G_MISS_NUM;
504: x_flow_schedule_rec.resource_account := FND_API.G_MISS_NUM;
505: x_flow_schedule_rec.outside_processing_acct := FND_API.G_MISS_NUM;
506: x_flow_schedule_rec.material_variance_account := FND_API.G_MISS_NUM;
507: x_flow_schedule_rec.resource_variance_account := FND_API.G_MISS_NUM;
508: x_flow_schedule_rec.outside_proc_var_acct := FND_API.G_MISS_NUM;
509: x_flow_schedule_rec.std_cost_adjustment_acct := FND_API.G_MISS_NUM;
510: x_flow_schedule_rec.overhead_account := FND_API.G_MISS_NUM;
511: x_flow_schedule_rec.overhead_variance_account := FND_API.G_MISS_NUM;
512: ELSIF p_attr_id = G_PROGRAM_APPLICATION THEN
505: x_flow_schedule_rec.outside_processing_acct := FND_API.G_MISS_NUM;
506: x_flow_schedule_rec.material_variance_account := FND_API.G_MISS_NUM;
507: x_flow_schedule_rec.resource_variance_account := FND_API.G_MISS_NUM;
508: x_flow_schedule_rec.outside_proc_var_acct := FND_API.G_MISS_NUM;
509: x_flow_schedule_rec.std_cost_adjustment_acct := FND_API.G_MISS_NUM;
510: x_flow_schedule_rec.overhead_account := FND_API.G_MISS_NUM;
511: x_flow_schedule_rec.overhead_variance_account := FND_API.G_MISS_NUM;
512: ELSIF p_attr_id = G_PROGRAM_APPLICATION THEN
513: NULL;
506: x_flow_schedule_rec.material_variance_account := FND_API.G_MISS_NUM;
507: x_flow_schedule_rec.resource_variance_account := FND_API.G_MISS_NUM;
508: x_flow_schedule_rec.outside_proc_var_acct := FND_API.G_MISS_NUM;
509: x_flow_schedule_rec.std_cost_adjustment_acct := FND_API.G_MISS_NUM;
510: x_flow_schedule_rec.overhead_account := FND_API.G_MISS_NUM;
511: x_flow_schedule_rec.overhead_variance_account := FND_API.G_MISS_NUM;
512: ELSIF p_attr_id = G_PROGRAM_APPLICATION THEN
513: NULL;
514: ELSIF p_attr_id = G_PROGRAM THEN
507: x_flow_schedule_rec.resource_variance_account := FND_API.G_MISS_NUM;
508: x_flow_schedule_rec.outside_proc_var_acct := FND_API.G_MISS_NUM;
509: x_flow_schedule_rec.std_cost_adjustment_acct := FND_API.G_MISS_NUM;
510: x_flow_schedule_rec.overhead_account := FND_API.G_MISS_NUM;
511: x_flow_schedule_rec.overhead_variance_account := FND_API.G_MISS_NUM;
512: ELSIF p_attr_id = G_PROGRAM_APPLICATION THEN
513: NULL;
514: ELSIF p_attr_id = G_PROGRAM THEN
515: NULL;
515: NULL;
516: ELSIF p_attr_id = G_PROGRAM_UPDATE_DATE THEN
517: NULL;
518: ELSIF p_attr_id = G_PROJECT THEN
519: x_flow_schedule_rec.task_id := FND_API.G_MISS_NUM;
520: x_flow_schedule_rec.class_code := FND_API.G_MISS_CHAR;
521: x_flow_schedule_rec.material_account := FND_API.G_MISS_NUM;
522: x_flow_schedule_rec.material_overhead_account := FND_API.G_MISS_NUM;
523: x_flow_schedule_rec.resource_account := FND_API.G_MISS_NUM;
516: ELSIF p_attr_id = G_PROGRAM_UPDATE_DATE THEN
517: NULL;
518: ELSIF p_attr_id = G_PROJECT THEN
519: x_flow_schedule_rec.task_id := FND_API.G_MISS_NUM;
520: x_flow_schedule_rec.class_code := FND_API.G_MISS_CHAR;
521: x_flow_schedule_rec.material_account := FND_API.G_MISS_NUM;
522: x_flow_schedule_rec.material_overhead_account := FND_API.G_MISS_NUM;
523: x_flow_schedule_rec.resource_account := FND_API.G_MISS_NUM;
524: x_flow_schedule_rec.outside_processing_acct := FND_API.G_MISS_NUM;
517: NULL;
518: ELSIF p_attr_id = G_PROJECT THEN
519: x_flow_schedule_rec.task_id := FND_API.G_MISS_NUM;
520: x_flow_schedule_rec.class_code := FND_API.G_MISS_CHAR;
521: x_flow_schedule_rec.material_account := FND_API.G_MISS_NUM;
522: x_flow_schedule_rec.material_overhead_account := FND_API.G_MISS_NUM;
523: x_flow_schedule_rec.resource_account := FND_API.G_MISS_NUM;
524: x_flow_schedule_rec.outside_processing_acct := FND_API.G_MISS_NUM;
525: x_flow_schedule_rec.material_variance_account := FND_API.G_MISS_NUM;
518: ELSIF p_attr_id = G_PROJECT THEN
519: x_flow_schedule_rec.task_id := FND_API.G_MISS_NUM;
520: x_flow_schedule_rec.class_code := FND_API.G_MISS_CHAR;
521: x_flow_schedule_rec.material_account := FND_API.G_MISS_NUM;
522: x_flow_schedule_rec.material_overhead_account := FND_API.G_MISS_NUM;
523: x_flow_schedule_rec.resource_account := FND_API.G_MISS_NUM;
524: x_flow_schedule_rec.outside_processing_acct := FND_API.G_MISS_NUM;
525: x_flow_schedule_rec.material_variance_account := FND_API.G_MISS_NUM;
526: x_flow_schedule_rec.resource_variance_account := FND_API.G_MISS_NUM;
519: x_flow_schedule_rec.task_id := FND_API.G_MISS_NUM;
520: x_flow_schedule_rec.class_code := FND_API.G_MISS_CHAR;
521: x_flow_schedule_rec.material_account := FND_API.G_MISS_NUM;
522: x_flow_schedule_rec.material_overhead_account := FND_API.G_MISS_NUM;
523: x_flow_schedule_rec.resource_account := FND_API.G_MISS_NUM;
524: x_flow_schedule_rec.outside_processing_acct := FND_API.G_MISS_NUM;
525: x_flow_schedule_rec.material_variance_account := FND_API.G_MISS_NUM;
526: x_flow_schedule_rec.resource_variance_account := FND_API.G_MISS_NUM;
527: x_flow_schedule_rec.outside_proc_var_acct := FND_API.G_MISS_NUM;
520: x_flow_schedule_rec.class_code := FND_API.G_MISS_CHAR;
521: x_flow_schedule_rec.material_account := FND_API.G_MISS_NUM;
522: x_flow_schedule_rec.material_overhead_account := FND_API.G_MISS_NUM;
523: x_flow_schedule_rec.resource_account := FND_API.G_MISS_NUM;
524: x_flow_schedule_rec.outside_processing_acct := FND_API.G_MISS_NUM;
525: x_flow_schedule_rec.material_variance_account := FND_API.G_MISS_NUM;
526: x_flow_schedule_rec.resource_variance_account := FND_API.G_MISS_NUM;
527: x_flow_schedule_rec.outside_proc_var_acct := FND_API.G_MISS_NUM;
528: x_flow_schedule_rec.std_cost_adjustment_acct := FND_API.G_MISS_NUM;
521: x_flow_schedule_rec.material_account := FND_API.G_MISS_NUM;
522: x_flow_schedule_rec.material_overhead_account := FND_API.G_MISS_NUM;
523: x_flow_schedule_rec.resource_account := FND_API.G_MISS_NUM;
524: x_flow_schedule_rec.outside_processing_acct := FND_API.G_MISS_NUM;
525: x_flow_schedule_rec.material_variance_account := FND_API.G_MISS_NUM;
526: x_flow_schedule_rec.resource_variance_account := FND_API.G_MISS_NUM;
527: x_flow_schedule_rec.outside_proc_var_acct := FND_API.G_MISS_NUM;
528: x_flow_schedule_rec.std_cost_adjustment_acct := FND_API.G_MISS_NUM;
529: x_flow_schedule_rec.overhead_account := FND_API.G_MISS_NUM;
522: x_flow_schedule_rec.material_overhead_account := FND_API.G_MISS_NUM;
523: x_flow_schedule_rec.resource_account := FND_API.G_MISS_NUM;
524: x_flow_schedule_rec.outside_processing_acct := FND_API.G_MISS_NUM;
525: x_flow_schedule_rec.material_variance_account := FND_API.G_MISS_NUM;
526: x_flow_schedule_rec.resource_variance_account := FND_API.G_MISS_NUM;
527: x_flow_schedule_rec.outside_proc_var_acct := FND_API.G_MISS_NUM;
528: x_flow_schedule_rec.std_cost_adjustment_acct := FND_API.G_MISS_NUM;
529: x_flow_schedule_rec.overhead_account := FND_API.G_MISS_NUM;
530: x_flow_schedule_rec.overhead_variance_account := FND_API.G_MISS_NUM;
523: x_flow_schedule_rec.resource_account := FND_API.G_MISS_NUM;
524: x_flow_schedule_rec.outside_processing_acct := FND_API.G_MISS_NUM;
525: x_flow_schedule_rec.material_variance_account := FND_API.G_MISS_NUM;
526: x_flow_schedule_rec.resource_variance_account := FND_API.G_MISS_NUM;
527: x_flow_schedule_rec.outside_proc_var_acct := FND_API.G_MISS_NUM;
528: x_flow_schedule_rec.std_cost_adjustment_acct := FND_API.G_MISS_NUM;
529: x_flow_schedule_rec.overhead_account := FND_API.G_MISS_NUM;
530: x_flow_schedule_rec.overhead_variance_account := FND_API.G_MISS_NUM;
531: ELSIF p_attr_id = G_QUANTITY_COMPLETED THEN
524: x_flow_schedule_rec.outside_processing_acct := FND_API.G_MISS_NUM;
525: x_flow_schedule_rec.material_variance_account := FND_API.G_MISS_NUM;
526: x_flow_schedule_rec.resource_variance_account := FND_API.G_MISS_NUM;
527: x_flow_schedule_rec.outside_proc_var_acct := FND_API.G_MISS_NUM;
528: x_flow_schedule_rec.std_cost_adjustment_acct := FND_API.G_MISS_NUM;
529: x_flow_schedule_rec.overhead_account := FND_API.G_MISS_NUM;
530: x_flow_schedule_rec.overhead_variance_account := FND_API.G_MISS_NUM;
531: ELSIF p_attr_id = G_QUANTITY_COMPLETED THEN
532: NULL;
525: x_flow_schedule_rec.material_variance_account := FND_API.G_MISS_NUM;
526: x_flow_schedule_rec.resource_variance_account := FND_API.G_MISS_NUM;
527: x_flow_schedule_rec.outside_proc_var_acct := FND_API.G_MISS_NUM;
528: x_flow_schedule_rec.std_cost_adjustment_acct := FND_API.G_MISS_NUM;
529: x_flow_schedule_rec.overhead_account := FND_API.G_MISS_NUM;
530: x_flow_schedule_rec.overhead_variance_account := FND_API.G_MISS_NUM;
531: ELSIF p_attr_id = G_QUANTITY_COMPLETED THEN
532: NULL;
533: ELSIF p_attr_id = G_REQUEST THEN
526: x_flow_schedule_rec.resource_variance_account := FND_API.G_MISS_NUM;
527: x_flow_schedule_rec.outside_proc_var_acct := FND_API.G_MISS_NUM;
528: x_flow_schedule_rec.std_cost_adjustment_acct := FND_API.G_MISS_NUM;
529: x_flow_schedule_rec.overhead_account := FND_API.G_MISS_NUM;
530: x_flow_schedule_rec.overhead_variance_account := FND_API.G_MISS_NUM;
531: ELSIF p_attr_id = G_QUANTITY_COMPLETED THEN
532: NULL;
533: ELSIF p_attr_id = G_REQUEST THEN
534: NULL;
536: NULL;
537: ELSIF p_attr_id = G_RESOURCE_VARIANCE_ACCOUNT THEN
538: NULL;
539: ELSIF p_attr_id = G_ROUTING_REVISION THEN
540: x_flow_schedule_rec.routing_revision_date := FND_API.G_MISS_DATE;
541: ELSIF p_attr_id = G_ROUTING_REVISION_DATE THEN
542: NULL;
543: ELSIF p_attr_id = G_SCHEDULED_COMPLETION_DATE THEN
544: x_flow_schedule_rec.scheduled_start_date := FND_API.G_MISS_DATE;
540: x_flow_schedule_rec.routing_revision_date := FND_API.G_MISS_DATE;
541: ELSIF p_attr_id = G_ROUTING_REVISION_DATE THEN
542: NULL;
543: ELSIF p_attr_id = G_SCHEDULED_COMPLETION_DATE THEN
544: x_flow_schedule_rec.scheduled_start_date := FND_API.G_MISS_DATE;
545: ELSIF p_attr_id = G_SCHEDULED THEN
546: NULL;
547: ELSIF p_attr_id = G_SCHEDULED_START_DATE THEN
548: NULL;
546: NULL;
547: ELSIF p_attr_id = G_SCHEDULED_START_DATE THEN
548: NULL;
549: ELSIF p_attr_id = G_SCHEDULE_GROUP THEN
550: x_flow_schedule_rec.build_sequence := FND_API.G_MISS_NUM;
551: ELSIF p_attr_id = G_SCHEDULE_NUMBER THEN
552: NULL;
553: ELSIF p_attr_id = G_STATUS THEN
554: NULL;
857: IS
858: l_flow_schedule_rec MRP_Flow_Schedule_PVT.Flow_Schedule_PVT_Rec_Type := p_flow_schedule_rec;
859: BEGIN
860:
861: IF l_flow_schedule_rec.alternate_bom_designator = FND_API.G_MISS_CHAR THEN
862: l_flow_schedule_rec.alternate_bom_designator := NULL ;
863: ELSIF l_flow_schedule_rec.alternate_bom_designator IS NULL THEN
864: l_flow_schedule_rec.alternate_bom_designator := p_old_flow_schedule_rec.alternate_bom_designator;
865: END IF;
863: ELSIF l_flow_schedule_rec.alternate_bom_designator IS NULL THEN
864: l_flow_schedule_rec.alternate_bom_designator := p_old_flow_schedule_rec.alternate_bom_designator;
865: END IF;
866:
867: IF l_flow_schedule_rec.alternate_routing_desig = FND_API.G_MISS_CHAR THEN
868: l_flow_schedule_rec.alternate_routing_desig := NULL ;
869: ELSIF l_flow_schedule_rec.alternate_routing_desig IS NULL THEN
870: l_flow_schedule_rec.alternate_routing_desig := p_old_flow_schedule_rec.alternate_routing_desig;
871: END IF;
869: ELSIF l_flow_schedule_rec.alternate_routing_desig IS NULL THEN
870: l_flow_schedule_rec.alternate_routing_desig := p_old_flow_schedule_rec.alternate_routing_desig;
871: END IF;
872:
873: IF l_flow_schedule_rec.attribute1 = FND_API.G_MISS_CHAR THEN
874: l_flow_schedule_rec.attribute1 := NULL ;
875: ELSIF l_flow_schedule_rec.attribute1 IS NULL THEN
876: l_flow_schedule_rec.attribute1 := p_old_flow_schedule_rec.attribute1;
877: END IF;
875: ELSIF l_flow_schedule_rec.attribute1 IS NULL THEN
876: l_flow_schedule_rec.attribute1 := p_old_flow_schedule_rec.attribute1;
877: END IF;
878:
879: IF l_flow_schedule_rec.attribute10 = FND_API.G_MISS_CHAR THEN
880: l_flow_schedule_rec.attribute10 := NULL ;
881: ELSIF l_flow_schedule_rec.attribute10 IS NULL THEN
882: l_flow_schedule_rec.attribute10 := p_old_flow_schedule_rec.attribute10;
883: END IF;
881: ELSIF l_flow_schedule_rec.attribute10 IS NULL THEN
882: l_flow_schedule_rec.attribute10 := p_old_flow_schedule_rec.attribute10;
883: END IF;
884:
885: IF l_flow_schedule_rec.attribute11 = FND_API.G_MISS_CHAR THEN
886: l_flow_schedule_rec.attribute11 := NULL ;
887: ELSIF l_flow_schedule_rec.attribute11 IS NULL THEN
888: l_flow_schedule_rec.attribute11 := p_old_flow_schedule_rec.attribute11;
889: END IF;
887: ELSIF l_flow_schedule_rec.attribute11 IS NULL THEN
888: l_flow_schedule_rec.attribute11 := p_old_flow_schedule_rec.attribute11;
889: END IF;
890:
891: IF l_flow_schedule_rec.attribute12 = FND_API.G_MISS_CHAR THEN
892: l_flow_schedule_rec.attribute12 := NULL ;
893: ELSIF l_flow_schedule_rec.attribute12 IS NULL THEN
894: l_flow_schedule_rec.attribute12 := p_old_flow_schedule_rec.attribute12;
895: END IF;
893: ELSIF l_flow_schedule_rec.attribute12 IS NULL THEN
894: l_flow_schedule_rec.attribute12 := p_old_flow_schedule_rec.attribute12;
895: END IF;
896:
897: IF l_flow_schedule_rec.attribute13 = FND_API.G_MISS_CHAR THEN
898: l_flow_schedule_rec.attribute13 := NULL ;
899: ELSIF l_flow_schedule_rec.attribute13 IS NULL THEN
900: l_flow_schedule_rec.attribute13 := p_old_flow_schedule_rec.attribute13;
901: END IF;
899: ELSIF l_flow_schedule_rec.attribute13 IS NULL THEN
900: l_flow_schedule_rec.attribute13 := p_old_flow_schedule_rec.attribute13;
901: END IF;
902:
903: IF l_flow_schedule_rec.attribute14 = FND_API.G_MISS_CHAR THEN
904: l_flow_schedule_rec.attribute14 := NULL ;
905: ELSIF l_flow_schedule_rec.attribute14 IS NULL THEN
906: l_flow_schedule_rec.attribute14 := p_old_flow_schedule_rec.attribute14;
907: END IF;
905: ELSIF l_flow_schedule_rec.attribute14 IS NULL THEN
906: l_flow_schedule_rec.attribute14 := p_old_flow_schedule_rec.attribute14;
907: END IF;
908:
909: IF l_flow_schedule_rec.attribute15 = FND_API.G_MISS_CHAR THEN
910: l_flow_schedule_rec.attribute15 := NULL ;
911: ELSIF l_flow_schedule_rec.attribute15 IS NULL THEN
912: l_flow_schedule_rec.attribute15 := p_old_flow_schedule_rec.attribute15;
913: END IF;
911: ELSIF l_flow_schedule_rec.attribute15 IS NULL THEN
912: l_flow_schedule_rec.attribute15 := p_old_flow_schedule_rec.attribute15;
913: END IF;
914:
915: IF l_flow_schedule_rec.attribute2 = FND_API.G_MISS_CHAR THEN
916: l_flow_schedule_rec.attribute2 := NULL ;
917: ELSIF l_flow_schedule_rec.attribute2 IS NULL THEN
918: l_flow_schedule_rec.attribute2 := p_old_flow_schedule_rec.attribute2;
919: END IF;
917: ELSIF l_flow_schedule_rec.attribute2 IS NULL THEN
918: l_flow_schedule_rec.attribute2 := p_old_flow_schedule_rec.attribute2;
919: END IF;
920:
921: IF l_flow_schedule_rec.attribute3 = FND_API.G_MISS_CHAR THEN
922: l_flow_schedule_rec.attribute3 := NULL ;
923: ELSIF l_flow_schedule_rec.attribute3 IS NULL THEN
924: l_flow_schedule_rec.attribute3 := p_old_flow_schedule_rec.attribute3;
925: END IF;
923: ELSIF l_flow_schedule_rec.attribute3 IS NULL THEN
924: l_flow_schedule_rec.attribute3 := p_old_flow_schedule_rec.attribute3;
925: END IF;
926:
927: IF l_flow_schedule_rec.attribute4 = FND_API.G_MISS_CHAR THEN
928: l_flow_schedule_rec.attribute4 := NULL ;
929: ELSIF l_flow_schedule_rec.attribute4 IS NULL THEN
930: l_flow_schedule_rec.attribute4 := p_old_flow_schedule_rec.attribute4;
931: END IF;
929: ELSIF l_flow_schedule_rec.attribute4 IS NULL THEN
930: l_flow_schedule_rec.attribute4 := p_old_flow_schedule_rec.attribute4;
931: END IF;
932:
933: IF l_flow_schedule_rec.attribute5 = FND_API.G_MISS_CHAR THEN
934: l_flow_schedule_rec.attribute5 := NULL ;
935: ELSIF l_flow_schedule_rec.attribute5 IS NULL THEN
936: l_flow_schedule_rec.attribute5 := p_old_flow_schedule_rec.attribute5;
937: END IF;
935: ELSIF l_flow_schedule_rec.attribute5 IS NULL THEN
936: l_flow_schedule_rec.attribute5 := p_old_flow_schedule_rec.attribute5;
937: END IF;
938:
939: IF l_flow_schedule_rec.attribute6 = FND_API.G_MISS_CHAR THEN
940: l_flow_schedule_rec.attribute6 := NULL ;
941: ELSIF l_flow_schedule_rec.attribute6 IS NULL THEN
942: l_flow_schedule_rec.attribute6 := p_old_flow_schedule_rec.attribute6;
943: END IF;
941: ELSIF l_flow_schedule_rec.attribute6 IS NULL THEN
942: l_flow_schedule_rec.attribute6 := p_old_flow_schedule_rec.attribute6;
943: END IF;
944:
945: IF l_flow_schedule_rec.attribute7 = FND_API.G_MISS_CHAR THEN
946: l_flow_schedule_rec.attribute7 := NULL ;
947: ELSIF l_flow_schedule_rec.attribute7 IS NULL THEN
948: l_flow_schedule_rec.attribute7 := p_old_flow_schedule_rec.attribute7;
949: END IF;
947: ELSIF l_flow_schedule_rec.attribute7 IS NULL THEN
948: l_flow_schedule_rec.attribute7 := p_old_flow_schedule_rec.attribute7;
949: END IF;
950:
951: IF l_flow_schedule_rec.attribute8 = FND_API.G_MISS_CHAR THEN
952: l_flow_schedule_rec.attribute8 := NULL ;
953: ELSIF l_flow_schedule_rec.attribute8 IS NULL THEN
954: l_flow_schedule_rec.attribute8 := p_old_flow_schedule_rec.attribute8;
955: END IF;
953: ELSIF l_flow_schedule_rec.attribute8 IS NULL THEN
954: l_flow_schedule_rec.attribute8 := p_old_flow_schedule_rec.attribute8;
955: END IF;
956:
957: IF l_flow_schedule_rec.attribute9 = FND_API.G_MISS_CHAR THEN
958: l_flow_schedule_rec.attribute9 := NULL ;
959: ELSIF l_flow_schedule_rec.attribute9 IS NULL THEN
960: l_flow_schedule_rec.attribute9 := p_old_flow_schedule_rec.attribute9;
961: END IF;
959: ELSIF l_flow_schedule_rec.attribute9 IS NULL THEN
960: l_flow_schedule_rec.attribute9 := p_old_flow_schedule_rec.attribute9;
961: END IF;
962:
963: IF l_flow_schedule_rec.attribute_category = FND_API.G_MISS_CHAR THEN
964: l_flow_schedule_rec.attribute_category := NULL ;
965: ELSIF l_flow_schedule_rec.attribute_category IS NULL THEN
966: l_flow_schedule_rec.attribute_category := p_old_flow_schedule_rec.attribute_category;
967: END IF;
965: ELSIF l_flow_schedule_rec.attribute_category IS NULL THEN
966: l_flow_schedule_rec.attribute_category := p_old_flow_schedule_rec.attribute_category;
967: END IF;
968:
969: IF l_flow_schedule_rec.bom_revision = FND_API.G_MISS_CHAR THEN
970: l_flow_schedule_rec.bom_revision := NULL ;
971: ELSIF l_flow_schedule_rec.bom_revision IS NULL THEN
972: l_flow_schedule_rec.bom_revision := p_old_flow_schedule_rec.bom_revision;
973: END IF;
971: ELSIF l_flow_schedule_rec.bom_revision IS NULL THEN
972: l_flow_schedule_rec.bom_revision := p_old_flow_schedule_rec.bom_revision;
973: END IF;
974:
975: IF l_flow_schedule_rec.bom_revision_date = FND_API.G_MISS_DATE THEN
976: l_flow_schedule_rec.bom_revision_date := NULL ;
977: ELSIF l_flow_schedule_rec.bom_revision_date IS NULL THEN
978: l_flow_schedule_rec.bom_revision_date := p_old_flow_schedule_rec.bom_revision_date;
979: END IF;
977: ELSIF l_flow_schedule_rec.bom_revision_date IS NULL THEN
978: l_flow_schedule_rec.bom_revision_date := p_old_flow_schedule_rec.bom_revision_date;
979: END IF;
980:
981: IF l_flow_schedule_rec.build_sequence = FND_API.G_MISS_NUM THEN
982: l_flow_schedule_rec.build_sequence := NULL ;
983: ELSIF l_flow_schedule_rec.build_sequence IS NULL THEN
984: l_flow_schedule_rec.build_sequence := p_old_flow_schedule_rec.build_sequence;
985: END IF;
983: ELSIF l_flow_schedule_rec.build_sequence IS NULL THEN
984: l_flow_schedule_rec.build_sequence := p_old_flow_schedule_rec.build_sequence;
985: END IF;
986:
987: IF l_flow_schedule_rec.class_code = FND_API.G_MISS_CHAR THEN
988: l_flow_schedule_rec.class_code := NULL ;
989: ELSIF l_flow_schedule_rec.class_code IS NULL THEN
990: l_flow_schedule_rec.class_code := p_old_flow_schedule_rec.class_code;
991: END IF;
989: ELSIF l_flow_schedule_rec.class_code IS NULL THEN
990: l_flow_schedule_rec.class_code := p_old_flow_schedule_rec.class_code;
991: END IF;
992:
993: IF l_flow_schedule_rec.completion_locator_id = FND_API.G_MISS_NUM THEN
994: l_flow_schedule_rec.completion_locator_id := NULL ;
995: ELSIF l_flow_schedule_rec.completion_locator_id IS NULL THEN
996: l_flow_schedule_rec.completion_locator_id := p_old_flow_schedule_rec.completion_locator_id;
997: END IF;
995: ELSIF l_flow_schedule_rec.completion_locator_id IS NULL THEN
996: l_flow_schedule_rec.completion_locator_id := p_old_flow_schedule_rec.completion_locator_id;
997: END IF;
998:
999: IF l_flow_schedule_rec.completion_subinventory = FND_API.G_MISS_CHAR THEN
1000: l_flow_schedule_rec.completion_subinventory := NULL ;
1001: ELSIF l_flow_schedule_rec.completion_subinventory IS NULL THEN
1002: l_flow_schedule_rec.completion_subinventory := p_old_flow_schedule_rec.completion_subinventory;
1003: END IF;
1001: ELSIF l_flow_schedule_rec.completion_subinventory IS NULL THEN
1002: l_flow_schedule_rec.completion_subinventory := p_old_flow_schedule_rec.completion_subinventory;
1003: END IF;
1004:
1005: IF l_flow_schedule_rec.created_by = FND_API.G_MISS_NUM THEN
1006: l_flow_schedule_rec.created_by := NULL ;
1007: ELSIF l_flow_schedule_rec.created_by IS NULL THEN
1008: l_flow_schedule_rec.created_by := p_old_flow_schedule_rec.created_by;
1009: END IF;
1007: ELSIF l_flow_schedule_rec.created_by IS NULL THEN
1008: l_flow_schedule_rec.created_by := p_old_flow_schedule_rec.created_by;
1009: END IF;
1010:
1011: IF l_flow_schedule_rec.creation_date = FND_API.G_MISS_DATE THEN
1012: l_flow_schedule_rec.creation_date := NULL ;
1013: ELSIF l_flow_schedule_rec.creation_date IS NULL THEN
1014: l_flow_schedule_rec.creation_date := p_old_flow_schedule_rec.creation_date;
1015: END IF;
1013: ELSIF l_flow_schedule_rec.creation_date IS NULL THEN
1014: l_flow_schedule_rec.creation_date := p_old_flow_schedule_rec.creation_date;
1015: END IF;
1016:
1017: IF l_flow_schedule_rec.date_closed = FND_API.G_MISS_DATE THEN
1018: l_flow_schedule_rec.date_closed := NULL ;
1019: ELSIF l_flow_schedule_rec.date_closed IS NULL THEN
1020: l_flow_schedule_rec.date_closed := p_old_flow_schedule_rec.date_closed;
1021: END IF;
1019: ELSIF l_flow_schedule_rec.date_closed IS NULL THEN
1020: l_flow_schedule_rec.date_closed := p_old_flow_schedule_rec.date_closed;
1021: END IF;
1022:
1023: IF l_flow_schedule_rec.demand_class = FND_API.G_MISS_CHAR THEN
1024: l_flow_schedule_rec.demand_class := NULL ;
1025: ELSIF l_flow_schedule_rec.demand_class IS NULL THEN
1026: l_flow_schedule_rec.demand_class := p_old_flow_schedule_rec.demand_class;
1027: END IF;
1025: ELSIF l_flow_schedule_rec.demand_class IS NULL THEN
1026: l_flow_schedule_rec.demand_class := p_old_flow_schedule_rec.demand_class;
1027: END IF;
1028:
1029: IF l_flow_schedule_rec.demand_source_delivery = FND_API.G_MISS_CHAR THEN
1030: l_flow_schedule_rec.demand_source_delivery := NULL ;
1031: ELSIF l_flow_schedule_rec.demand_source_delivery IS NULL THEN
1032: l_flow_schedule_rec.demand_source_delivery := p_old_flow_schedule_rec.demand_source_delivery;
1033: END IF;
1031: ELSIF l_flow_schedule_rec.demand_source_delivery IS NULL THEN
1032: l_flow_schedule_rec.demand_source_delivery := p_old_flow_schedule_rec.demand_source_delivery;
1033: END IF;
1034:
1035: IF l_flow_schedule_rec.demand_source_header_id = FND_API.G_MISS_NUM THEN
1036: l_flow_schedule_rec.demand_source_header_id := NULL ;
1037: ELSIF l_flow_schedule_rec.demand_source_header_id IS NULL THEN
1038: l_flow_schedule_rec.demand_source_header_id := p_old_flow_schedule_rec.demand_source_header_id;
1039: END IF;
1037: ELSIF l_flow_schedule_rec.demand_source_header_id IS NULL THEN
1038: l_flow_schedule_rec.demand_source_header_id := p_old_flow_schedule_rec.demand_source_header_id;
1039: END IF;
1040:
1041: IF l_flow_schedule_rec.demand_source_line = FND_API.G_MISS_CHAR THEN
1042: l_flow_schedule_rec.demand_source_line := NULL ;
1043: ELSIF l_flow_schedule_rec.demand_source_line IS NULL THEN
1044: l_flow_schedule_rec.demand_source_line := p_old_flow_schedule_rec.demand_source_line;
1045: END IF;
1043: ELSIF l_flow_schedule_rec.demand_source_line IS NULL THEN
1044: l_flow_schedule_rec.demand_source_line := p_old_flow_schedule_rec.demand_source_line;
1045: END IF;
1046:
1047: IF l_flow_schedule_rec.demand_source_type = FND_API.G_MISS_NUM THEN
1048: l_flow_schedule_rec.demand_source_type := NULL ;
1049: ELSIF l_flow_schedule_rec.demand_source_type IS NULL THEN
1050: l_flow_schedule_rec.demand_source_type := p_old_flow_schedule_rec.demand_source_type;
1051: END IF;
1049: ELSIF l_flow_schedule_rec.demand_source_type IS NULL THEN
1050: l_flow_schedule_rec.demand_source_type := p_old_flow_schedule_rec.demand_source_type;
1051: END IF;
1052:
1053: IF l_flow_schedule_rec.last_updated_by = FND_API.G_MISS_NUM THEN
1054: l_flow_schedule_rec.last_updated_by := NULL ;
1055: ELSIF l_flow_schedule_rec.last_updated_by IS NULL THEN
1056: l_flow_schedule_rec.last_updated_by := p_old_flow_schedule_rec.last_updated_by;
1057: END IF;
1055: ELSIF l_flow_schedule_rec.last_updated_by IS NULL THEN
1056: l_flow_schedule_rec.last_updated_by := p_old_flow_schedule_rec.last_updated_by;
1057: END IF;
1058:
1059: IF l_flow_schedule_rec.last_update_date = FND_API.G_MISS_DATE THEN
1060: l_flow_schedule_rec.last_update_date := NULL ;
1061: ELSIF l_flow_schedule_rec.last_update_date IS NULL THEN
1062: l_flow_schedule_rec.last_update_date := p_old_flow_schedule_rec.last_update_date;
1063: END IF;
1061: ELSIF l_flow_schedule_rec.last_update_date IS NULL THEN
1062: l_flow_schedule_rec.last_update_date := p_old_flow_schedule_rec.last_update_date;
1063: END IF;
1064:
1065: IF l_flow_schedule_rec.last_update_login = FND_API.G_MISS_NUM THEN
1066: l_flow_schedule_rec.last_update_login := NULL ;
1067: ELSIF l_flow_schedule_rec.last_update_login IS NULL THEN
1068: l_flow_schedule_rec.last_update_login := p_old_flow_schedule_rec.last_update_login;
1069: END IF;
1067: ELSIF l_flow_schedule_rec.last_update_login IS NULL THEN
1068: l_flow_schedule_rec.last_update_login := p_old_flow_schedule_rec.last_update_login;
1069: END IF;
1070:
1071: IF l_flow_schedule_rec.line_id = FND_API.G_MISS_NUM THEN
1072: l_flow_schedule_rec.line_id := NULL ;
1073: ELSIF l_flow_schedule_rec.line_id IS NULL THEN
1074: l_flow_schedule_rec.line_id := p_old_flow_schedule_rec.line_id;
1075: END IF;
1073: ELSIF l_flow_schedule_rec.line_id IS NULL THEN
1074: l_flow_schedule_rec.line_id := p_old_flow_schedule_rec.line_id;
1075: END IF;
1076:
1077: IF l_flow_schedule_rec.material_account = FND_API.G_MISS_NUM THEN
1078: l_flow_schedule_rec.material_account := NULL ;
1079: ELSIF l_flow_schedule_rec.material_account IS NULL THEN
1080: l_flow_schedule_rec.material_account := p_old_flow_schedule_rec.material_account;
1081: END IF;
1079: ELSIF l_flow_schedule_rec.material_account IS NULL THEN
1080: l_flow_schedule_rec.material_account := p_old_flow_schedule_rec.material_account;
1081: END IF;
1082:
1083: IF l_flow_schedule_rec.material_overhead_account = FND_API.G_MISS_NUM THEN
1084: l_flow_schedule_rec.material_overhead_account := NULL ;
1085: ELSIF l_flow_schedule_rec.material_overhead_account IS NULL THEN
1086: l_flow_schedule_rec.material_overhead_account := p_old_flow_schedule_rec.material_overhead_account;
1087: END IF;
1085: ELSIF l_flow_schedule_rec.material_overhead_account IS NULL THEN
1086: l_flow_schedule_rec.material_overhead_account := p_old_flow_schedule_rec.material_overhead_account;
1087: END IF;
1088:
1089: IF l_flow_schedule_rec.material_variance_account = FND_API.G_MISS_NUM THEN
1090: l_flow_schedule_rec.material_variance_account := NULL ;
1091: ELSIF l_flow_schedule_rec.material_variance_account IS NULL THEN
1092: l_flow_schedule_rec.material_variance_account := p_old_flow_schedule_rec.material_variance_account;
1093: END IF;
1091: ELSIF l_flow_schedule_rec.material_variance_account IS NULL THEN
1092: l_flow_schedule_rec.material_variance_account := p_old_flow_schedule_rec.material_variance_account;
1093: END IF;
1094:
1095: IF l_flow_schedule_rec.mps_net_quantity = FND_API.G_MISS_NUM THEN
1096: l_flow_schedule_rec.mps_net_quantity := NULL ;
1097: ELSIF l_flow_schedule_rec.mps_net_quantity IS NULL THEN
1098: l_flow_schedule_rec.mps_net_quantity := p_old_flow_schedule_rec.mps_net_quantity;
1099: END IF;
1097: ELSIF l_flow_schedule_rec.mps_net_quantity IS NULL THEN
1098: l_flow_schedule_rec.mps_net_quantity := p_old_flow_schedule_rec.mps_net_quantity;
1099: END IF;
1100:
1101: IF l_flow_schedule_rec.mps_scheduled_comp_date = FND_API.G_MISS_DATE THEN
1102: l_flow_schedule_rec.mps_scheduled_comp_date := NULL ;
1103: ELSIF l_flow_schedule_rec.mps_scheduled_comp_date IS NULL THEN
1104: l_flow_schedule_rec.mps_scheduled_comp_date := p_old_flow_schedule_rec.mps_scheduled_comp_date;
1105: END IF;
1103: ELSIF l_flow_schedule_rec.mps_scheduled_comp_date IS NULL THEN
1104: l_flow_schedule_rec.mps_scheduled_comp_date := p_old_flow_schedule_rec.mps_scheduled_comp_date;
1105: END IF;
1106:
1107: IF l_flow_schedule_rec.organization_id = FND_API.G_MISS_NUM THEN
1108: l_flow_schedule_rec.organization_id := NULL ;
1109: ELSIF l_flow_schedule_rec.organization_id IS NULL THEN
1110: l_flow_schedule_rec.organization_id := p_old_flow_schedule_rec.organization_id;
1111: END IF;
1109: ELSIF l_flow_schedule_rec.organization_id IS NULL THEN
1110: l_flow_schedule_rec.organization_id := p_old_flow_schedule_rec.organization_id;
1111: END IF;
1112:
1113: IF l_flow_schedule_rec.outside_processing_acct = FND_API.G_MISS_NUM THEN
1114: l_flow_schedule_rec.outside_processing_acct := NULL ;
1115: ELSIF l_flow_schedule_rec.outside_processing_acct IS NULL THEN
1116: l_flow_schedule_rec.outside_processing_acct := p_old_flow_schedule_rec.outside_processing_acct;
1117: END IF;
1115: ELSIF l_flow_schedule_rec.outside_processing_acct IS NULL THEN
1116: l_flow_schedule_rec.outside_processing_acct := p_old_flow_schedule_rec.outside_processing_acct;
1117: END IF;
1118:
1119: IF l_flow_schedule_rec.outside_proc_var_acct = FND_API.G_MISS_NUM THEN
1120: l_flow_schedule_rec.outside_proc_var_acct := NULL ;
1121: ELSIF l_flow_schedule_rec.outside_proc_var_acct IS NULL THEN
1122: l_flow_schedule_rec.outside_proc_var_acct := p_old_flow_schedule_rec.outside_proc_var_acct;
1123: END IF;
1121: ELSIF l_flow_schedule_rec.outside_proc_var_acct IS NULL THEN
1122: l_flow_schedule_rec.outside_proc_var_acct := p_old_flow_schedule_rec.outside_proc_var_acct;
1123: END IF;
1124:
1125: IF l_flow_schedule_rec.overhead_account = FND_API.G_MISS_NUM THEN
1126: l_flow_schedule_rec.overhead_account := NULL ;
1127: ELSIF l_flow_schedule_rec.overhead_account IS NULL THEN
1128: l_flow_schedule_rec.overhead_account := p_old_flow_schedule_rec.overhead_account;
1129: END IF;
1127: ELSIF l_flow_schedule_rec.overhead_account IS NULL THEN
1128: l_flow_schedule_rec.overhead_account := p_old_flow_schedule_rec.overhead_account;
1129: END IF;
1130:
1131: IF l_flow_schedule_rec.overhead_variance_account = FND_API.G_MISS_NUM THEN
1132: l_flow_schedule_rec.overhead_variance_account := NULL ;
1133: ELSIF l_flow_schedule_rec.overhead_variance_account IS NULL THEN
1134: l_flow_schedule_rec.overhead_variance_account := p_old_flow_schedule_rec.overhead_variance_account;
1135: END IF;
1133: ELSIF l_flow_schedule_rec.overhead_variance_account IS NULL THEN
1134: l_flow_schedule_rec.overhead_variance_account := p_old_flow_schedule_rec.overhead_variance_account;
1135: END IF;
1136:
1137: IF l_flow_schedule_rec.planned_quantity = FND_API.G_MISS_NUM THEN
1138: l_flow_schedule_rec.planned_quantity := NULL ;
1139: ELSIF l_flow_schedule_rec.overhead_variance_account IS NULL THEN
1140: l_flow_schedule_rec.planned_quantity := p_old_flow_schedule_rec.planned_quantity;
1141: END IF;
1139: ELSIF l_flow_schedule_rec.overhead_variance_account IS NULL THEN
1140: l_flow_schedule_rec.planned_quantity := p_old_flow_schedule_rec.planned_quantity;
1141: END IF;
1142:
1143: IF l_flow_schedule_rec.primary_item_id = FND_API.G_MISS_NUM THEN
1144: l_flow_schedule_rec.primary_item_id := NULL ;
1145: ELSIF l_flow_schedule_rec.primary_item_id IS NULL THEN
1146: l_flow_schedule_rec.primary_item_id := p_old_flow_schedule_rec.primary_item_id;
1147: END IF;
1145: ELSIF l_flow_schedule_rec.primary_item_id IS NULL THEN
1146: l_flow_schedule_rec.primary_item_id := p_old_flow_schedule_rec.primary_item_id;
1147: END IF;
1148:
1149: IF l_flow_schedule_rec.program_application_id = FND_API.G_MISS_NUM THEN
1150: l_flow_schedule_rec.program_application_id := NULL ;
1151: ELSIF l_flow_schedule_rec.program_application_id IS NULL THEN
1152: l_flow_schedule_rec.program_application_id := p_old_flow_schedule_rec.program_application_id;
1153: END IF;
1151: ELSIF l_flow_schedule_rec.program_application_id IS NULL THEN
1152: l_flow_schedule_rec.program_application_id := p_old_flow_schedule_rec.program_application_id;
1153: END IF;
1154:
1155: IF l_flow_schedule_rec.program_id = FND_API.G_MISS_NUM THEN
1156: l_flow_schedule_rec.program_id := NULL ;
1157: ELSIF l_flow_schedule_rec.program_id IS NULL THEN
1158: l_flow_schedule_rec.program_id := p_old_flow_schedule_rec.program_id;
1159: END IF;
1157: ELSIF l_flow_schedule_rec.program_id IS NULL THEN
1158: l_flow_schedule_rec.program_id := p_old_flow_schedule_rec.program_id;
1159: END IF;
1160:
1161: IF l_flow_schedule_rec.program_update_date = FND_API.G_MISS_DATE THEN
1162: l_flow_schedule_rec.program_update_date := NULL ;
1163: ELSIF l_flow_schedule_rec.program_update_date IS NULL THEN
1164: l_flow_schedule_rec.program_update_date := p_old_flow_schedule_rec.program_update_date;
1165: END IF;
1163: ELSIF l_flow_schedule_rec.program_update_date IS NULL THEN
1164: l_flow_schedule_rec.program_update_date := p_old_flow_schedule_rec.program_update_date;
1165: END IF;
1166:
1167: IF l_flow_schedule_rec.project_id = FND_API.G_MISS_NUM THEN
1168: l_flow_schedule_rec.project_id := NULL ;
1169: ELSIF l_flow_schedule_rec.project_id IS NULL THEN
1170: l_flow_schedule_rec.project_id := p_old_flow_schedule_rec.project_id;
1171: END IF;
1169: ELSIF l_flow_schedule_rec.project_id IS NULL THEN
1170: l_flow_schedule_rec.project_id := p_old_flow_schedule_rec.project_id;
1171: END IF;
1172:
1173: IF l_flow_schedule_rec.quantity_completed = FND_API.G_MISS_NUM THEN
1174: l_flow_schedule_rec.quantity_completed := NULL ;
1175: ELSIF l_flow_schedule_rec.quantity_completed IS NULL THEN
1176: l_flow_schedule_rec.quantity_completed := p_old_flow_schedule_rec.quantity_completed;
1177: END IF;
1175: ELSIF l_flow_schedule_rec.quantity_completed IS NULL THEN
1176: l_flow_schedule_rec.quantity_completed := p_old_flow_schedule_rec.quantity_completed;
1177: END IF;
1178:
1179: IF l_flow_schedule_rec.request_id = FND_API.G_MISS_NUM THEN
1180: l_flow_schedule_rec.request_id := NULL ;
1181: ELSIF l_flow_schedule_rec.request_id IS NULL THEN
1182: l_flow_schedule_rec.request_id := p_old_flow_schedule_rec.request_id;
1183: END IF;
1181: ELSIF l_flow_schedule_rec.request_id IS NULL THEN
1182: l_flow_schedule_rec.request_id := p_old_flow_schedule_rec.request_id;
1183: END IF;
1184:
1185: IF l_flow_schedule_rec.resource_account = FND_API.G_MISS_NUM THEN
1186: l_flow_schedule_rec.resource_account := NULL ;
1187: ELSIF l_flow_schedule_rec.resource_account IS NULL THEN
1188: l_flow_schedule_rec.resource_account := p_old_flow_schedule_rec.resource_account;
1189: END IF;
1187: ELSIF l_flow_schedule_rec.resource_account IS NULL THEN
1188: l_flow_schedule_rec.resource_account := p_old_flow_schedule_rec.resource_account;
1189: END IF;
1190:
1191: IF l_flow_schedule_rec.resource_variance_account = FND_API.G_MISS_NUM THEN
1192: l_flow_schedule_rec.resource_variance_account := NULL ;
1193: ELSIF l_flow_schedule_rec.resource_variance_account IS NULL THEN
1194: l_flow_schedule_rec.resource_variance_account := p_old_flow_schedule_rec.resource_variance_account;
1195: END IF;
1193: ELSIF l_flow_schedule_rec.resource_variance_account IS NULL THEN
1194: l_flow_schedule_rec.resource_variance_account := p_old_flow_schedule_rec.resource_variance_account;
1195: END IF;
1196:
1197: IF l_flow_schedule_rec.routing_revision = FND_API.G_MISS_CHAR THEN
1198: l_flow_schedule_rec.routing_revision := NULL ;
1199: ELSIF l_flow_schedule_rec.routing_revision IS NULL THEN
1200: l_flow_schedule_rec.routing_revision := p_old_flow_schedule_rec.routing_revision;
1201: END IF;
1199: ELSIF l_flow_schedule_rec.routing_revision IS NULL THEN
1200: l_flow_schedule_rec.routing_revision := p_old_flow_schedule_rec.routing_revision;
1201: END IF;
1202:
1203: IF l_flow_schedule_rec.routing_revision_date = FND_API.G_MISS_DATE THEN
1204: l_flow_schedule_rec.routing_revision_date := NULL ;
1205: ELSIF l_flow_schedule_rec.routing_revision_date IS NULL THEN
1206: l_flow_schedule_rec.routing_revision_date := p_old_flow_schedule_rec.routing_revision_date;
1207: END IF;
1205: ELSIF l_flow_schedule_rec.routing_revision_date IS NULL THEN
1206: l_flow_schedule_rec.routing_revision_date := p_old_flow_schedule_rec.routing_revision_date;
1207: END IF;
1208:
1209: IF l_flow_schedule_rec.scheduled_completion_date = FND_API.G_MISS_DATE THEN
1210: l_flow_schedule_rec.scheduled_completion_date := NULL ;
1211: ELSIF l_flow_schedule_rec.scheduled_completion_date IS NULL THEN
1212: l_flow_schedule_rec.scheduled_completion_date := p_old_flow_schedule_rec.scheduled_completion_date;
1213: END IF;
1211: ELSIF l_flow_schedule_rec.scheduled_completion_date IS NULL THEN
1212: l_flow_schedule_rec.scheduled_completion_date := p_old_flow_schedule_rec.scheduled_completion_date;
1213: END IF;
1214:
1215: IF l_flow_schedule_rec.scheduled_flag = FND_API.G_MISS_NUM THEN
1216: l_flow_schedule_rec.scheduled_flag := NULL ;
1217: ELSIF l_flow_schedule_rec.scheduled_flag IS NULL THEN
1218: l_flow_schedule_rec.scheduled_flag := p_old_flow_schedule_rec.scheduled_flag;
1219: END IF;
1217: ELSIF l_flow_schedule_rec.scheduled_flag IS NULL THEN
1218: l_flow_schedule_rec.scheduled_flag := p_old_flow_schedule_rec.scheduled_flag;
1219: END IF;
1220:
1221: IF l_flow_schedule_rec.scheduled_start_date = FND_API.G_MISS_DATE THEN
1222: l_flow_schedule_rec.scheduled_start_date := NULL ;
1223: ELSIF l_flow_schedule_rec.scheduled_start_date IS NULL THEN
1224: l_flow_schedule_rec.scheduled_start_date := p_old_flow_schedule_rec.scheduled_start_date;
1225: END IF;
1223: ELSIF l_flow_schedule_rec.scheduled_start_date IS NULL THEN
1224: l_flow_schedule_rec.scheduled_start_date := p_old_flow_schedule_rec.scheduled_start_date;
1225: END IF;
1226:
1227: IF l_flow_schedule_rec.schedule_group_id = FND_API.G_MISS_NUM THEN
1228: l_flow_schedule_rec.schedule_group_id := NULL ;
1229: ELSIF l_flow_schedule_rec.schedule_group_id IS NULL THEN
1230: l_flow_schedule_rec.schedule_group_id := p_old_flow_schedule_rec.schedule_group_id;
1231: END IF;
1229: ELSIF l_flow_schedule_rec.schedule_group_id IS NULL THEN
1230: l_flow_schedule_rec.schedule_group_id := p_old_flow_schedule_rec.schedule_group_id;
1231: END IF;
1232:
1233: IF l_flow_schedule_rec.schedule_number = FND_API.G_MISS_CHAR THEN
1234: l_flow_schedule_rec.schedule_number := NULL ;
1235: ELSIF l_flow_schedule_rec.schedule_number IS NULL THEN
1236: l_flow_schedule_rec.schedule_number := p_old_flow_schedule_rec.schedule_number;
1237: END IF;
1235: ELSIF l_flow_schedule_rec.schedule_number IS NULL THEN
1236: l_flow_schedule_rec.schedule_number := p_old_flow_schedule_rec.schedule_number;
1237: END IF;
1238:
1239: IF l_flow_schedule_rec.status = FND_API.G_MISS_NUM THEN
1240: l_flow_schedule_rec.status := NULL ;
1241: ELSIF l_flow_schedule_rec.status IS NULL THEN
1242: l_flow_schedule_rec.status := p_old_flow_schedule_rec.status;
1243: END IF;
1241: ELSIF l_flow_schedule_rec.status IS NULL THEN
1242: l_flow_schedule_rec.status := p_old_flow_schedule_rec.status;
1243: END IF;
1244:
1245: IF l_flow_schedule_rec.std_cost_adjustment_acct = FND_API.G_MISS_NUM THEN
1246: l_flow_schedule_rec.std_cost_adjustment_acct := NULL ;
1247: ELSIF l_flow_schedule_rec.std_cost_adjustment_acct IS NULL THEN
1248: l_flow_schedule_rec.std_cost_adjustment_acct := p_old_flow_schedule_rec.std_cost_adjustment_acct;
1249: END IF;
1247: ELSIF l_flow_schedule_rec.std_cost_adjustment_acct IS NULL THEN
1248: l_flow_schedule_rec.std_cost_adjustment_acct := p_old_flow_schedule_rec.std_cost_adjustment_acct;
1249: END IF;
1250:
1251: IF l_flow_schedule_rec.task_id = FND_API.G_MISS_NUM THEN
1252: l_flow_schedule_rec.task_id := NULL ;
1253: ELSIF l_flow_schedule_rec.task_id IS NULL THEN
1254: l_flow_schedule_rec.task_id := p_old_flow_schedule_rec.task_id;
1255: END IF;
1253: ELSIF l_flow_schedule_rec.task_id IS NULL THEN
1254: l_flow_schedule_rec.task_id := p_old_flow_schedule_rec.task_id;
1255: END IF;
1256:
1257: IF l_flow_schedule_rec.wip_entity_id = FND_API.G_MISS_NUM THEN
1258: l_flow_schedule_rec.wip_entity_id := NULL ;
1259: ELSIF l_flow_schedule_rec.wip_entity_id IS NULL THEN
1260: l_flow_schedule_rec.wip_entity_id := p_old_flow_schedule_rec.wip_entity_id;
1261: END IF;
1259: ELSIF l_flow_schedule_rec.wip_entity_id IS NULL THEN
1260: l_flow_schedule_rec.wip_entity_id := p_old_flow_schedule_rec.wip_entity_id;
1261: END IF;
1262:
1263: IF l_flow_schedule_rec.end_item_unit_number = FND_API.G_MISS_CHAR THEN
1264: l_flow_schedule_rec.end_item_unit_number := NULL ;
1265: ELSIF l_flow_schedule_rec.end_item_unit_number IS NULL THEN
1266: l_flow_schedule_rec.end_item_unit_number := p_old_flow_schedule_rec.end_item_unit_number;
1267: END IF;
1266: l_flow_schedule_rec.end_item_unit_number := p_old_flow_schedule_rec.end_item_unit_number;
1267: END IF;
1268:
1269:
1270: IF l_flow_schedule_rec.quantity_scrapped = FND_API.G_MISS_NUM THEN
1271: l_flow_schedule_rec.quantity_scrapped := NULL ;
1272: ELSIF l_flow_schedule_rec.quantity_scrapped IS NULL THEN
1273: l_flow_schedule_rec.quantity_scrapped := p_old_flow_schedule_rec.quantity_scrapped;
1274: END IF;
1285: IS
1286: l_flow_schedule_rec MRP_Flow_Schedule_PVT.Flow_Schedule_PVT_Rec_Type:= p_flow_schedule_rec;
1287: BEGIN
1288:
1289: IF l_flow_schedule_rec.alternate_bom_designator = FND_API.G_MISS_CHAR THEN
1290: l_flow_schedule_rec.alternate_bom_designator := NULL;
1291: END IF;
1292:
1293: IF l_flow_schedule_rec.alternate_routing_desig = FND_API.G_MISS_CHAR THEN
1289: IF l_flow_schedule_rec.alternate_bom_designator = FND_API.G_MISS_CHAR THEN
1290: l_flow_schedule_rec.alternate_bom_designator := NULL;
1291: END IF;
1292:
1293: IF l_flow_schedule_rec.alternate_routing_desig = FND_API.G_MISS_CHAR THEN
1294: l_flow_schedule_rec.alternate_routing_desig := NULL;
1295: END IF;
1296:
1297: IF l_flow_schedule_rec.attribute1 = FND_API.G_MISS_CHAR THEN
1293: IF l_flow_schedule_rec.alternate_routing_desig = FND_API.G_MISS_CHAR THEN
1294: l_flow_schedule_rec.alternate_routing_desig := NULL;
1295: END IF;
1296:
1297: IF l_flow_schedule_rec.attribute1 = FND_API.G_MISS_CHAR THEN
1298: l_flow_schedule_rec.attribute1 := NULL;
1299: END IF;
1300:
1301: IF l_flow_schedule_rec.attribute10 = FND_API.G_MISS_CHAR THEN
1297: IF l_flow_schedule_rec.attribute1 = FND_API.G_MISS_CHAR THEN
1298: l_flow_schedule_rec.attribute1 := NULL;
1299: END IF;
1300:
1301: IF l_flow_schedule_rec.attribute10 = FND_API.G_MISS_CHAR THEN
1302: l_flow_schedule_rec.attribute10 := NULL;
1303: END IF;
1304:
1305: IF l_flow_schedule_rec.attribute11 = FND_API.G_MISS_CHAR THEN
1301: IF l_flow_schedule_rec.attribute10 = FND_API.G_MISS_CHAR THEN
1302: l_flow_schedule_rec.attribute10 := NULL;
1303: END IF;
1304:
1305: IF l_flow_schedule_rec.attribute11 = FND_API.G_MISS_CHAR THEN
1306: l_flow_schedule_rec.attribute11 := NULL;
1307: END IF;
1308:
1309: IF l_flow_schedule_rec.attribute12 = FND_API.G_MISS_CHAR THEN
1305: IF l_flow_schedule_rec.attribute11 = FND_API.G_MISS_CHAR THEN
1306: l_flow_schedule_rec.attribute11 := NULL;
1307: END IF;
1308:
1309: IF l_flow_schedule_rec.attribute12 = FND_API.G_MISS_CHAR THEN
1310: l_flow_schedule_rec.attribute12 := NULL;
1311: END IF;
1312:
1313: IF l_flow_schedule_rec.attribute13 = FND_API.G_MISS_CHAR THEN
1309: IF l_flow_schedule_rec.attribute12 = FND_API.G_MISS_CHAR THEN
1310: l_flow_schedule_rec.attribute12 := NULL;
1311: END IF;
1312:
1313: IF l_flow_schedule_rec.attribute13 = FND_API.G_MISS_CHAR THEN
1314: l_flow_schedule_rec.attribute13 := NULL;
1315: END IF;
1316:
1317: IF l_flow_schedule_rec.attribute14 = FND_API.G_MISS_CHAR THEN
1313: IF l_flow_schedule_rec.attribute13 = FND_API.G_MISS_CHAR THEN
1314: l_flow_schedule_rec.attribute13 := NULL;
1315: END IF;
1316:
1317: IF l_flow_schedule_rec.attribute14 = FND_API.G_MISS_CHAR THEN
1318: l_flow_schedule_rec.attribute14 := NULL;
1319: END IF;
1320:
1321: IF l_flow_schedule_rec.attribute15 = FND_API.G_MISS_CHAR THEN
1317: IF l_flow_schedule_rec.attribute14 = FND_API.G_MISS_CHAR THEN
1318: l_flow_schedule_rec.attribute14 := NULL;
1319: END IF;
1320:
1321: IF l_flow_schedule_rec.attribute15 = FND_API.G_MISS_CHAR THEN
1322: l_flow_schedule_rec.attribute15 := NULL;
1323: END IF;
1324:
1325: IF l_flow_schedule_rec.attribute2 = FND_API.G_MISS_CHAR THEN
1321: IF l_flow_schedule_rec.attribute15 = FND_API.G_MISS_CHAR THEN
1322: l_flow_schedule_rec.attribute15 := NULL;
1323: END IF;
1324:
1325: IF l_flow_schedule_rec.attribute2 = FND_API.G_MISS_CHAR THEN
1326: l_flow_schedule_rec.attribute2 := NULL;
1327: END IF;
1328:
1329: IF l_flow_schedule_rec.attribute3 = FND_API.G_MISS_CHAR THEN
1325: IF l_flow_schedule_rec.attribute2 = FND_API.G_MISS_CHAR THEN
1326: l_flow_schedule_rec.attribute2 := NULL;
1327: END IF;
1328:
1329: IF l_flow_schedule_rec.attribute3 = FND_API.G_MISS_CHAR THEN
1330: l_flow_schedule_rec.attribute3 := NULL;
1331: END IF;
1332:
1333: IF l_flow_schedule_rec.attribute4 = FND_API.G_MISS_CHAR THEN
1329: IF l_flow_schedule_rec.attribute3 = FND_API.G_MISS_CHAR THEN
1330: l_flow_schedule_rec.attribute3 := NULL;
1331: END IF;
1332:
1333: IF l_flow_schedule_rec.attribute4 = FND_API.G_MISS_CHAR THEN
1334: l_flow_schedule_rec.attribute4 := NULL;
1335: END IF;
1336:
1337: IF l_flow_schedule_rec.attribute5 = FND_API.G_MISS_CHAR THEN
1333: IF l_flow_schedule_rec.attribute4 = FND_API.G_MISS_CHAR THEN
1334: l_flow_schedule_rec.attribute4 := NULL;
1335: END IF;
1336:
1337: IF l_flow_schedule_rec.attribute5 = FND_API.G_MISS_CHAR THEN
1338: l_flow_schedule_rec.attribute5 := NULL;
1339: END IF;
1340:
1341: IF l_flow_schedule_rec.attribute6 = FND_API.G_MISS_CHAR THEN
1337: IF l_flow_schedule_rec.attribute5 = FND_API.G_MISS_CHAR THEN
1338: l_flow_schedule_rec.attribute5 := NULL;
1339: END IF;
1340:
1341: IF l_flow_schedule_rec.attribute6 = FND_API.G_MISS_CHAR THEN
1342: l_flow_schedule_rec.attribute6 := NULL;
1343: END IF;
1344:
1345: IF l_flow_schedule_rec.attribute7 = FND_API.G_MISS_CHAR THEN
1341: IF l_flow_schedule_rec.attribute6 = FND_API.G_MISS_CHAR THEN
1342: l_flow_schedule_rec.attribute6 := NULL;
1343: END IF;
1344:
1345: IF l_flow_schedule_rec.attribute7 = FND_API.G_MISS_CHAR THEN
1346: l_flow_schedule_rec.attribute7 := NULL;
1347: END IF;
1348:
1349: IF l_flow_schedule_rec.attribute8 = FND_API.G_MISS_CHAR THEN
1345: IF l_flow_schedule_rec.attribute7 = FND_API.G_MISS_CHAR THEN
1346: l_flow_schedule_rec.attribute7 := NULL;
1347: END IF;
1348:
1349: IF l_flow_schedule_rec.attribute8 = FND_API.G_MISS_CHAR THEN
1350: l_flow_schedule_rec.attribute8 := NULL;
1351: END IF;
1352:
1353: IF l_flow_schedule_rec.attribute9 = FND_API.G_MISS_CHAR THEN
1349: IF l_flow_schedule_rec.attribute8 = FND_API.G_MISS_CHAR THEN
1350: l_flow_schedule_rec.attribute8 := NULL;
1351: END IF;
1352:
1353: IF l_flow_schedule_rec.attribute9 = FND_API.G_MISS_CHAR THEN
1354: l_flow_schedule_rec.attribute9 := NULL;
1355: END IF;
1356:
1357: IF l_flow_schedule_rec.attribute_category = FND_API.G_MISS_CHAR THEN
1353: IF l_flow_schedule_rec.attribute9 = FND_API.G_MISS_CHAR THEN
1354: l_flow_schedule_rec.attribute9 := NULL;
1355: END IF;
1356:
1357: IF l_flow_schedule_rec.attribute_category = FND_API.G_MISS_CHAR THEN
1358: l_flow_schedule_rec.attribute_category := NULL;
1359: END IF;
1360:
1361: IF l_flow_schedule_rec.bom_revision = FND_API.G_MISS_CHAR THEN
1357: IF l_flow_schedule_rec.attribute_category = FND_API.G_MISS_CHAR THEN
1358: l_flow_schedule_rec.attribute_category := NULL;
1359: END IF;
1360:
1361: IF l_flow_schedule_rec.bom_revision = FND_API.G_MISS_CHAR THEN
1362: l_flow_schedule_rec.bom_revision := NULL;
1363: END IF;
1364:
1365: IF l_flow_schedule_rec.bom_revision_date = FND_API.G_MISS_DATE THEN
1361: IF l_flow_schedule_rec.bom_revision = FND_API.G_MISS_CHAR THEN
1362: l_flow_schedule_rec.bom_revision := NULL;
1363: END IF;
1364:
1365: IF l_flow_schedule_rec.bom_revision_date = FND_API.G_MISS_DATE THEN
1366: l_flow_schedule_rec.bom_revision_date := NULL;
1367: END IF;
1368:
1369: IF l_flow_schedule_rec.build_sequence = FND_API.G_MISS_NUM THEN
1365: IF l_flow_schedule_rec.bom_revision_date = FND_API.G_MISS_DATE THEN
1366: l_flow_schedule_rec.bom_revision_date := NULL;
1367: END IF;
1368:
1369: IF l_flow_schedule_rec.build_sequence = FND_API.G_MISS_NUM THEN
1370: l_flow_schedule_rec.build_sequence := NULL;
1371: END IF;
1372:
1373: IF l_flow_schedule_rec.class_code = FND_API.G_MISS_CHAR THEN
1369: IF l_flow_schedule_rec.build_sequence = FND_API.G_MISS_NUM THEN
1370: l_flow_schedule_rec.build_sequence := NULL;
1371: END IF;
1372:
1373: IF l_flow_schedule_rec.class_code = FND_API.G_MISS_CHAR THEN
1374: l_flow_schedule_rec.class_code := NULL;
1375: END IF;
1376:
1377: IF l_flow_schedule_rec.completion_locator_id = FND_API.G_MISS_NUM THEN
1373: IF l_flow_schedule_rec.class_code = FND_API.G_MISS_CHAR THEN
1374: l_flow_schedule_rec.class_code := NULL;
1375: END IF;
1376:
1377: IF l_flow_schedule_rec.completion_locator_id = FND_API.G_MISS_NUM THEN
1378: l_flow_schedule_rec.completion_locator_id := NULL;
1379: END IF;
1380:
1381: IF l_flow_schedule_rec.completion_subinventory = FND_API.G_MISS_CHAR THEN
1377: IF l_flow_schedule_rec.completion_locator_id = FND_API.G_MISS_NUM THEN
1378: l_flow_schedule_rec.completion_locator_id := NULL;
1379: END IF;
1380:
1381: IF l_flow_schedule_rec.completion_subinventory = FND_API.G_MISS_CHAR THEN
1382: l_flow_schedule_rec.completion_subinventory := NULL;
1383: END IF;
1384:
1385: IF l_flow_schedule_rec.created_by = FND_API.G_MISS_NUM THEN
1381: IF l_flow_schedule_rec.completion_subinventory = FND_API.G_MISS_CHAR THEN
1382: l_flow_schedule_rec.completion_subinventory := NULL;
1383: END IF;
1384:
1385: IF l_flow_schedule_rec.created_by = FND_API.G_MISS_NUM THEN
1386: l_flow_schedule_rec.created_by := NULL;
1387: END IF;
1388:
1389: IF l_flow_schedule_rec.creation_date = FND_API.G_MISS_DATE THEN
1385: IF l_flow_schedule_rec.created_by = FND_API.G_MISS_NUM THEN
1386: l_flow_schedule_rec.created_by := NULL;
1387: END IF;
1388:
1389: IF l_flow_schedule_rec.creation_date = FND_API.G_MISS_DATE THEN
1390: l_flow_schedule_rec.creation_date := NULL;
1391: END IF;
1392:
1393: IF l_flow_schedule_rec.date_closed = FND_API.G_MISS_DATE THEN
1389: IF l_flow_schedule_rec.creation_date = FND_API.G_MISS_DATE THEN
1390: l_flow_schedule_rec.creation_date := NULL;
1391: END IF;
1392:
1393: IF l_flow_schedule_rec.date_closed = FND_API.G_MISS_DATE THEN
1394: l_flow_schedule_rec.date_closed := NULL;
1395: END IF;
1396:
1397: IF l_flow_schedule_rec.demand_class = FND_API.G_MISS_CHAR THEN
1393: IF l_flow_schedule_rec.date_closed = FND_API.G_MISS_DATE THEN
1394: l_flow_schedule_rec.date_closed := NULL;
1395: END IF;
1396:
1397: IF l_flow_schedule_rec.demand_class = FND_API.G_MISS_CHAR THEN
1398: l_flow_schedule_rec.demand_class := NULL;
1399: END IF;
1400:
1401: IF l_flow_schedule_rec.demand_source_delivery = FND_API.G_MISS_CHAR THEN
1397: IF l_flow_schedule_rec.demand_class = FND_API.G_MISS_CHAR THEN
1398: l_flow_schedule_rec.demand_class := NULL;
1399: END IF;
1400:
1401: IF l_flow_schedule_rec.demand_source_delivery = FND_API.G_MISS_CHAR THEN
1402: l_flow_schedule_rec.demand_source_delivery := NULL;
1403: END IF;
1404:
1405: IF l_flow_schedule_rec.demand_source_header_id = FND_API.G_MISS_NUM THEN
1401: IF l_flow_schedule_rec.demand_source_delivery = FND_API.G_MISS_CHAR THEN
1402: l_flow_schedule_rec.demand_source_delivery := NULL;
1403: END IF;
1404:
1405: IF l_flow_schedule_rec.demand_source_header_id = FND_API.G_MISS_NUM THEN
1406: l_flow_schedule_rec.demand_source_header_id := NULL;
1407: END IF;
1408:
1409: IF l_flow_schedule_rec.demand_source_line = FND_API.G_MISS_CHAR THEN
1405: IF l_flow_schedule_rec.demand_source_header_id = FND_API.G_MISS_NUM THEN
1406: l_flow_schedule_rec.demand_source_header_id := NULL;
1407: END IF;
1408:
1409: IF l_flow_schedule_rec.demand_source_line = FND_API.G_MISS_CHAR THEN
1410: l_flow_schedule_rec.demand_source_line := NULL;
1411: END IF;
1412:
1413: IF l_flow_schedule_rec.demand_source_type = FND_API.G_MISS_NUM THEN
1409: IF l_flow_schedule_rec.demand_source_line = FND_API.G_MISS_CHAR THEN
1410: l_flow_schedule_rec.demand_source_line := NULL;
1411: END IF;
1412:
1413: IF l_flow_schedule_rec.demand_source_type = FND_API.G_MISS_NUM THEN
1414: l_flow_schedule_rec.demand_source_type := NULL;
1415: END IF;
1416:
1417: IF l_flow_schedule_rec.last_updated_by = FND_API.G_MISS_NUM THEN
1413: IF l_flow_schedule_rec.demand_source_type = FND_API.G_MISS_NUM THEN
1414: l_flow_schedule_rec.demand_source_type := NULL;
1415: END IF;
1416:
1417: IF l_flow_schedule_rec.last_updated_by = FND_API.G_MISS_NUM THEN
1418: l_flow_schedule_rec.last_updated_by := NULL;
1419: END IF;
1420:
1421: IF l_flow_schedule_rec.last_update_date = FND_API.G_MISS_DATE THEN
1417: IF l_flow_schedule_rec.last_updated_by = FND_API.G_MISS_NUM THEN
1418: l_flow_schedule_rec.last_updated_by := NULL;
1419: END IF;
1420:
1421: IF l_flow_schedule_rec.last_update_date = FND_API.G_MISS_DATE THEN
1422: l_flow_schedule_rec.last_update_date := NULL;
1423: END IF;
1424:
1425: IF l_flow_schedule_rec.last_update_login = FND_API.G_MISS_NUM THEN
1421: IF l_flow_schedule_rec.last_update_date = FND_API.G_MISS_DATE THEN
1422: l_flow_schedule_rec.last_update_date := NULL;
1423: END IF;
1424:
1425: IF l_flow_schedule_rec.last_update_login = FND_API.G_MISS_NUM THEN
1426: l_flow_schedule_rec.last_update_login := NULL;
1427: END IF;
1428:
1429: IF l_flow_schedule_rec.line_id = FND_API.G_MISS_NUM THEN
1425: IF l_flow_schedule_rec.last_update_login = FND_API.G_MISS_NUM THEN
1426: l_flow_schedule_rec.last_update_login := NULL;
1427: END IF;
1428:
1429: IF l_flow_schedule_rec.line_id = FND_API.G_MISS_NUM THEN
1430: l_flow_schedule_rec.line_id := NULL;
1431: END IF;
1432:
1433: IF l_flow_schedule_rec.material_account = FND_API.G_MISS_NUM THEN
1429: IF l_flow_schedule_rec.line_id = FND_API.G_MISS_NUM THEN
1430: l_flow_schedule_rec.line_id := NULL;
1431: END IF;
1432:
1433: IF l_flow_schedule_rec.material_account = FND_API.G_MISS_NUM THEN
1434: l_flow_schedule_rec.material_account := NULL;
1435: END IF;
1436:
1437: IF l_flow_schedule_rec.material_overhead_account = FND_API.G_MISS_NUM THEN
1433: IF l_flow_schedule_rec.material_account = FND_API.G_MISS_NUM THEN
1434: l_flow_schedule_rec.material_account := NULL;
1435: END IF;
1436:
1437: IF l_flow_schedule_rec.material_overhead_account = FND_API.G_MISS_NUM THEN
1438: l_flow_schedule_rec.material_overhead_account := NULL;
1439: END IF;
1440:
1441: IF l_flow_schedule_rec.material_variance_account = FND_API.G_MISS_NUM THEN
1437: IF l_flow_schedule_rec.material_overhead_account = FND_API.G_MISS_NUM THEN
1438: l_flow_schedule_rec.material_overhead_account := NULL;
1439: END IF;
1440:
1441: IF l_flow_schedule_rec.material_variance_account = FND_API.G_MISS_NUM THEN
1442: l_flow_schedule_rec.material_variance_account := NULL;
1443: END IF;
1444:
1445: IF l_flow_schedule_rec.mps_net_quantity = FND_API.G_MISS_NUM THEN
1441: IF l_flow_schedule_rec.material_variance_account = FND_API.G_MISS_NUM THEN
1442: l_flow_schedule_rec.material_variance_account := NULL;
1443: END IF;
1444:
1445: IF l_flow_schedule_rec.mps_net_quantity = FND_API.G_MISS_NUM THEN
1446: l_flow_schedule_rec.mps_net_quantity := NULL;
1447: END IF;
1448:
1449: IF l_flow_schedule_rec.mps_scheduled_comp_date = FND_API.G_MISS_DATE THEN
1445: IF l_flow_schedule_rec.mps_net_quantity = FND_API.G_MISS_NUM THEN
1446: l_flow_schedule_rec.mps_net_quantity := NULL;
1447: END IF;
1448:
1449: IF l_flow_schedule_rec.mps_scheduled_comp_date = FND_API.G_MISS_DATE THEN
1450: l_flow_schedule_rec.mps_scheduled_comp_date := NULL;
1451: END IF;
1452:
1453: IF l_flow_schedule_rec.organization_id = FND_API.G_MISS_NUM THEN
1449: IF l_flow_schedule_rec.mps_scheduled_comp_date = FND_API.G_MISS_DATE THEN
1450: l_flow_schedule_rec.mps_scheduled_comp_date := NULL;
1451: END IF;
1452:
1453: IF l_flow_schedule_rec.organization_id = FND_API.G_MISS_NUM THEN
1454: l_flow_schedule_rec.organization_id := NULL;
1455: END IF;
1456:
1457: IF l_flow_schedule_rec.outside_processing_acct = FND_API.G_MISS_NUM THEN
1453: IF l_flow_schedule_rec.organization_id = FND_API.G_MISS_NUM THEN
1454: l_flow_schedule_rec.organization_id := NULL;
1455: END IF;
1456:
1457: IF l_flow_schedule_rec.outside_processing_acct = FND_API.G_MISS_NUM THEN
1458: l_flow_schedule_rec.outside_processing_acct := NULL;
1459: END IF;
1460:
1461: IF l_flow_schedule_rec.outside_proc_var_acct = FND_API.G_MISS_NUM THEN
1457: IF l_flow_schedule_rec.outside_processing_acct = FND_API.G_MISS_NUM THEN
1458: l_flow_schedule_rec.outside_processing_acct := NULL;
1459: END IF;
1460:
1461: IF l_flow_schedule_rec.outside_proc_var_acct = FND_API.G_MISS_NUM THEN
1462: l_flow_schedule_rec.outside_proc_var_acct := NULL;
1463: END IF;
1464:
1465: IF l_flow_schedule_rec.overhead_account = FND_API.G_MISS_NUM THEN
1461: IF l_flow_schedule_rec.outside_proc_var_acct = FND_API.G_MISS_NUM THEN
1462: l_flow_schedule_rec.outside_proc_var_acct := NULL;
1463: END IF;
1464:
1465: IF l_flow_schedule_rec.overhead_account = FND_API.G_MISS_NUM THEN
1466: l_flow_schedule_rec.overhead_account := NULL;
1467: END IF;
1468:
1469: IF l_flow_schedule_rec.overhead_variance_account = FND_API.G_MISS_NUM THEN
1465: IF l_flow_schedule_rec.overhead_account = FND_API.G_MISS_NUM THEN
1466: l_flow_schedule_rec.overhead_account := NULL;
1467: END IF;
1468:
1469: IF l_flow_schedule_rec.overhead_variance_account = FND_API.G_MISS_NUM THEN
1470: l_flow_schedule_rec.overhead_variance_account := NULL;
1471: END IF;
1472:
1473: IF l_flow_schedule_rec.planned_quantity = FND_API.G_MISS_NUM THEN
1469: IF l_flow_schedule_rec.overhead_variance_account = FND_API.G_MISS_NUM THEN
1470: l_flow_schedule_rec.overhead_variance_account := NULL;
1471: END IF;
1472:
1473: IF l_flow_schedule_rec.planned_quantity = FND_API.G_MISS_NUM THEN
1474: l_flow_schedule_rec.planned_quantity := NULL;
1475: END IF;
1476:
1477: IF l_flow_schedule_rec.primary_item_id = FND_API.G_MISS_NUM THEN
1473: IF l_flow_schedule_rec.planned_quantity = FND_API.G_MISS_NUM THEN
1474: l_flow_schedule_rec.planned_quantity := NULL;
1475: END IF;
1476:
1477: IF l_flow_schedule_rec.primary_item_id = FND_API.G_MISS_NUM THEN
1478: l_flow_schedule_rec.primary_item_id := NULL;
1479: END IF;
1480:
1481: IF l_flow_schedule_rec.program_application_id = FND_API.G_MISS_NUM THEN
1477: IF l_flow_schedule_rec.primary_item_id = FND_API.G_MISS_NUM THEN
1478: l_flow_schedule_rec.primary_item_id := NULL;
1479: END IF;
1480:
1481: IF l_flow_schedule_rec.program_application_id = FND_API.G_MISS_NUM THEN
1482: l_flow_schedule_rec.program_application_id := NULL;
1483: END IF;
1484:
1485: IF l_flow_schedule_rec.program_id = FND_API.G_MISS_NUM THEN
1481: IF l_flow_schedule_rec.program_application_id = FND_API.G_MISS_NUM THEN
1482: l_flow_schedule_rec.program_application_id := NULL;
1483: END IF;
1484:
1485: IF l_flow_schedule_rec.program_id = FND_API.G_MISS_NUM THEN
1486: l_flow_schedule_rec.program_id := NULL;
1487: END IF;
1488:
1489: IF l_flow_schedule_rec.program_update_date = FND_API.G_MISS_DATE THEN
1485: IF l_flow_schedule_rec.program_id = FND_API.G_MISS_NUM THEN
1486: l_flow_schedule_rec.program_id := NULL;
1487: END IF;
1488:
1489: IF l_flow_schedule_rec.program_update_date = FND_API.G_MISS_DATE THEN
1490: l_flow_schedule_rec.program_update_date := NULL;
1491: END IF;
1492:
1493: IF l_flow_schedule_rec.project_id = FND_API.G_MISS_NUM THEN
1489: IF l_flow_schedule_rec.program_update_date = FND_API.G_MISS_DATE THEN
1490: l_flow_schedule_rec.program_update_date := NULL;
1491: END IF;
1492:
1493: IF l_flow_schedule_rec.project_id = FND_API.G_MISS_NUM THEN
1494: l_flow_schedule_rec.project_id := NULL;
1495: END IF;
1496:
1497: IF l_flow_schedule_rec.quantity_completed = FND_API.G_MISS_NUM THEN
1493: IF l_flow_schedule_rec.project_id = FND_API.G_MISS_NUM THEN
1494: l_flow_schedule_rec.project_id := NULL;
1495: END IF;
1496:
1497: IF l_flow_schedule_rec.quantity_completed = FND_API.G_MISS_NUM THEN
1498: l_flow_schedule_rec.quantity_completed := NULL;
1499: END IF;
1500:
1501: IF l_flow_schedule_rec.request_id = FND_API.G_MISS_NUM THEN
1497: IF l_flow_schedule_rec.quantity_completed = FND_API.G_MISS_NUM THEN
1498: l_flow_schedule_rec.quantity_completed := NULL;
1499: END IF;
1500:
1501: IF l_flow_schedule_rec.request_id = FND_API.G_MISS_NUM THEN
1502: l_flow_schedule_rec.request_id := NULL;
1503: END IF;
1504:
1505: IF l_flow_schedule_rec.resource_account = FND_API.G_MISS_NUM THEN
1501: IF l_flow_schedule_rec.request_id = FND_API.G_MISS_NUM THEN
1502: l_flow_schedule_rec.request_id := NULL;
1503: END IF;
1504:
1505: IF l_flow_schedule_rec.resource_account = FND_API.G_MISS_NUM THEN
1506: l_flow_schedule_rec.resource_account := NULL;
1507: END IF;
1508:
1509: IF l_flow_schedule_rec.resource_variance_account = FND_API.G_MISS_NUM THEN
1505: IF l_flow_schedule_rec.resource_account = FND_API.G_MISS_NUM THEN
1506: l_flow_schedule_rec.resource_account := NULL;
1507: END IF;
1508:
1509: IF l_flow_schedule_rec.resource_variance_account = FND_API.G_MISS_NUM THEN
1510: l_flow_schedule_rec.resource_variance_account := NULL;
1511: END IF;
1512:
1513: IF l_flow_schedule_rec.routing_revision = FND_API.G_MISS_CHAR THEN
1509: IF l_flow_schedule_rec.resource_variance_account = FND_API.G_MISS_NUM THEN
1510: l_flow_schedule_rec.resource_variance_account := NULL;
1511: END IF;
1512:
1513: IF l_flow_schedule_rec.routing_revision = FND_API.G_MISS_CHAR THEN
1514: l_flow_schedule_rec.routing_revision := NULL;
1515: END IF;
1516:
1517: IF l_flow_schedule_rec.routing_revision_date = FND_API.G_MISS_DATE THEN
1513: IF l_flow_schedule_rec.routing_revision = FND_API.G_MISS_CHAR THEN
1514: l_flow_schedule_rec.routing_revision := NULL;
1515: END IF;
1516:
1517: IF l_flow_schedule_rec.routing_revision_date = FND_API.G_MISS_DATE THEN
1518: l_flow_schedule_rec.routing_revision_date := NULL;
1519: END IF;
1520:
1521: IF l_flow_schedule_rec.scheduled_completion_date = FND_API.G_MISS_DATE THEN
1517: IF l_flow_schedule_rec.routing_revision_date = FND_API.G_MISS_DATE THEN
1518: l_flow_schedule_rec.routing_revision_date := NULL;
1519: END IF;
1520:
1521: IF l_flow_schedule_rec.scheduled_completion_date = FND_API.G_MISS_DATE THEN
1522: l_flow_schedule_rec.scheduled_completion_date := NULL;
1523: END IF;
1524:
1525: IF l_flow_schedule_rec.scheduled_flag = FND_API.G_MISS_NUM THEN
1521: IF l_flow_schedule_rec.scheduled_completion_date = FND_API.G_MISS_DATE THEN
1522: l_flow_schedule_rec.scheduled_completion_date := NULL;
1523: END IF;
1524:
1525: IF l_flow_schedule_rec.scheduled_flag = FND_API.G_MISS_NUM THEN
1526: l_flow_schedule_rec.scheduled_flag := NULL;
1527: END IF;
1528:
1529: IF l_flow_schedule_rec.scheduled_start_date = FND_API.G_MISS_DATE THEN
1525: IF l_flow_schedule_rec.scheduled_flag = FND_API.G_MISS_NUM THEN
1526: l_flow_schedule_rec.scheduled_flag := NULL;
1527: END IF;
1528:
1529: IF l_flow_schedule_rec.scheduled_start_date = FND_API.G_MISS_DATE THEN
1530: l_flow_schedule_rec.scheduled_start_date := NULL;
1531: END IF;
1532:
1533: IF l_flow_schedule_rec.schedule_group_id = FND_API.G_MISS_NUM THEN
1529: IF l_flow_schedule_rec.scheduled_start_date = FND_API.G_MISS_DATE THEN
1530: l_flow_schedule_rec.scheduled_start_date := NULL;
1531: END IF;
1532:
1533: IF l_flow_schedule_rec.schedule_group_id = FND_API.G_MISS_NUM THEN
1534: l_flow_schedule_rec.schedule_group_id := NULL;
1535: END IF;
1536:
1537: IF l_flow_schedule_rec.schedule_number = FND_API.G_MISS_CHAR THEN
1533: IF l_flow_schedule_rec.schedule_group_id = FND_API.G_MISS_NUM THEN
1534: l_flow_schedule_rec.schedule_group_id := NULL;
1535: END IF;
1536:
1537: IF l_flow_schedule_rec.schedule_number = FND_API.G_MISS_CHAR THEN
1538: l_flow_schedule_rec.schedule_number := NULL;
1539: END IF;
1540:
1541: IF l_flow_schedule_rec.status = FND_API.G_MISS_NUM THEN
1537: IF l_flow_schedule_rec.schedule_number = FND_API.G_MISS_CHAR THEN
1538: l_flow_schedule_rec.schedule_number := NULL;
1539: END IF;
1540:
1541: IF l_flow_schedule_rec.status = FND_API.G_MISS_NUM THEN
1542: l_flow_schedule_rec.status := NULL;
1543: END IF;
1544:
1545: IF l_flow_schedule_rec.std_cost_adjustment_acct = FND_API.G_MISS_NUM THEN
1541: IF l_flow_schedule_rec.status = FND_API.G_MISS_NUM THEN
1542: l_flow_schedule_rec.status := NULL;
1543: END IF;
1544:
1545: IF l_flow_schedule_rec.std_cost_adjustment_acct = FND_API.G_MISS_NUM THEN
1546: l_flow_schedule_rec.std_cost_adjustment_acct := NULL;
1547: END IF;
1548:
1549: IF l_flow_schedule_rec.task_id = FND_API.G_MISS_NUM THEN
1545: IF l_flow_schedule_rec.std_cost_adjustment_acct = FND_API.G_MISS_NUM THEN
1546: l_flow_schedule_rec.std_cost_adjustment_acct := NULL;
1547: END IF;
1548:
1549: IF l_flow_schedule_rec.task_id = FND_API.G_MISS_NUM THEN
1550: l_flow_schedule_rec.task_id := NULL;
1551: END IF;
1552:
1553: IF l_flow_schedule_rec.wip_entity_id = FND_API.G_MISS_NUM THEN
1549: IF l_flow_schedule_rec.task_id = FND_API.G_MISS_NUM THEN
1550: l_flow_schedule_rec.task_id := NULL;
1551: END IF;
1552:
1553: IF l_flow_schedule_rec.wip_entity_id = FND_API.G_MISS_NUM THEN
1554: l_flow_schedule_rec.wip_entity_id := NULL;
1555: END IF;
1556:
1557: IF l_flow_schedule_rec.end_item_unit_number = FND_API.G_MISS_CHAR THEN
1553: IF l_flow_schedule_rec.wip_entity_id = FND_API.G_MISS_NUM THEN
1554: l_flow_schedule_rec.wip_entity_id := NULL;
1555: END IF;
1556:
1557: IF l_flow_schedule_rec.end_item_unit_number = FND_API.G_MISS_CHAR THEN
1558: l_flow_schedule_rec.end_item_unit_number := NULL;
1559: END IF;
1560:
1561: IF l_flow_schedule_rec.quantity_scrapped = FND_API.G_MISS_NUM THEN
1557: IF l_flow_schedule_rec.end_item_unit_number = FND_API.G_MISS_CHAR THEN
1558: l_flow_schedule_rec.end_item_unit_number := NULL;
1559: END IF;
1560:
1561: IF l_flow_schedule_rec.quantity_scrapped = FND_API.G_MISS_NUM THEN
1562: l_flow_schedule_rec.quantity_scrapped := NULL;
1563: END IF;
1564:
1565: IF l_flow_schedule_rec.kanban_card_id = FND_API.G_MISS_NUM THEN
1561: IF l_flow_schedule_rec.quantity_scrapped = FND_API.G_MISS_NUM THEN
1562: l_flow_schedule_rec.quantity_scrapped := NULL;
1563: END IF;
1564:
1565: IF l_flow_schedule_rec.kanban_card_id = FND_API.G_MISS_NUM THEN
1566: l_flow_schedule_rec.kanban_card_id := NULL;
1567: END IF;
1568:
1569: IF l_flow_schedule_rec.synch_schedule_num = FND_API.G_MISS_CHAR THEN
1565: IF l_flow_schedule_rec.kanban_card_id = FND_API.G_MISS_NUM THEN
1566: l_flow_schedule_rec.kanban_card_id := NULL;
1567: END IF;
1568:
1569: IF l_flow_schedule_rec.synch_schedule_num = FND_API.G_MISS_CHAR THEN
1570: l_flow_schedule_rec.synch_schedule_num := NULL;
1571: END IF;
1572:
1573: IF l_flow_schedule_rec.synch_operation_seq_num = FND_API.G_MISS_NUM THEN
1569: IF l_flow_schedule_rec.synch_schedule_num = FND_API.G_MISS_CHAR THEN
1570: l_flow_schedule_rec.synch_schedule_num := NULL;
1571: END IF;
1572:
1573: IF l_flow_schedule_rec.synch_operation_seq_num = FND_API.G_MISS_NUM THEN
1574: l_flow_schedule_rec.synch_operation_seq_num := NULL;
1575: END IF;
1576:
1577: IF l_flow_schedule_rec.roll_forwarded_flag = FND_API.G_MISS_NUM THEN
1573: IF l_flow_schedule_rec.synch_operation_seq_num = FND_API.G_MISS_NUM THEN
1574: l_flow_schedule_rec.synch_operation_seq_num := NULL;
1575: END IF;
1576:
1577: IF l_flow_schedule_rec.roll_forwarded_flag = FND_API.G_MISS_NUM THEN
1578: l_flow_schedule_rec.roll_forwarded_flag := NULL;
1579: END IF;
1580:
1581: IF l_flow_schedule_rec.current_line_operation = FND_API.G_MISS_NUM THEN
1577: IF l_flow_schedule_rec.roll_forwarded_flag = FND_API.G_MISS_NUM THEN
1578: l_flow_schedule_rec.roll_forwarded_flag := NULL;
1579: END IF;
1580:
1581: IF l_flow_schedule_rec.current_line_operation = FND_API.G_MISS_NUM THEN
1582: l_flow_schedule_rec.current_line_operation := NULL;
1583: END IF;
1584:
1585: RETURN l_flow_schedule_rec;
1682: , 'Update_Row'
1683: );
1684: END IF;
1685:
1686: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1687:
1688: END Update_Row;
1689:
1690: -- Procedure Insert_Row
1862: , 'Insert_Row'
1863: );
1864: END IF;
1865:
1866: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1867:
1868: END Insert_Row;
1869:
1870: -- Procedure Delete_Row
1890: , 'Delete_Row'
1891: );
1892: END IF;
1893:
1894: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1895:
1896: END Delete_Row;
1897:
1898: -- Function Query_Row
2059: , 'Query_Row'
2060: );
2061: END IF;
2062:
2063: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2064:
2065: END Query_Row;
2066:
2067: -- Procedure lock_Row
2222: -- Row locked. Compare IN attributes to DB attributes.
2223:
2224: IF ( (l_flow_schedule_rec.alternate_bom_designator =
2225: p_flow_schedule_rec.alternate_bom_designator) OR
2226: ((p_flow_schedule_rec.alternate_bom_designator = FND_API.G_MISS_CHAR) OR
2227: ( (l_flow_schedule_rec.alternate_bom_designator IS NULL) AND
2228: (p_flow_schedule_rec.alternate_bom_designator IS NULL))))
2229: AND ( (l_flow_schedule_rec.alternate_routing_desig =
2230: p_flow_schedule_rec.alternate_routing_desig) OR
2227: ( (l_flow_schedule_rec.alternate_bom_designator IS NULL) AND
2228: (p_flow_schedule_rec.alternate_bom_designator IS NULL))))
2229: AND ( (l_flow_schedule_rec.alternate_routing_desig =
2230: p_flow_schedule_rec.alternate_routing_desig) OR
2231: ((p_flow_schedule_rec.alternate_routing_desig = FND_API.G_MISS_CHAR) OR
2232: ( (l_flow_schedule_rec.alternate_routing_desig IS NULL) AND
2233: (p_flow_schedule_rec.alternate_routing_desig IS NULL))))
2234: AND ( (l_flow_schedule_rec.attribute1 =
2235: p_flow_schedule_rec.attribute1) OR
2232: ( (l_flow_schedule_rec.alternate_routing_desig IS NULL) AND
2233: (p_flow_schedule_rec.alternate_routing_desig IS NULL))))
2234: AND ( (l_flow_schedule_rec.attribute1 =
2235: p_flow_schedule_rec.attribute1) OR
2236: ((p_flow_schedule_rec.attribute1 = FND_API.G_MISS_CHAR) OR
2237: ( (l_flow_schedule_rec.attribute1 IS NULL) AND
2238: (p_flow_schedule_rec.attribute1 IS NULL))))
2239: AND ( (l_flow_schedule_rec.attribute10 =
2240: p_flow_schedule_rec.attribute10) OR
2237: ( (l_flow_schedule_rec.attribute1 IS NULL) AND
2238: (p_flow_schedule_rec.attribute1 IS NULL))))
2239: AND ( (l_flow_schedule_rec.attribute10 =
2240: p_flow_schedule_rec.attribute10) OR
2241: ((p_flow_schedule_rec.attribute10 = FND_API.G_MISS_CHAR) OR
2242: ( (l_flow_schedule_rec.attribute10 IS NULL) AND
2243: (p_flow_schedule_rec.attribute10 IS NULL))))
2244: AND ( (l_flow_schedule_rec.attribute11 =
2245: p_flow_schedule_rec.attribute11) OR
2242: ( (l_flow_schedule_rec.attribute10 IS NULL) AND
2243: (p_flow_schedule_rec.attribute10 IS NULL))))
2244: AND ( (l_flow_schedule_rec.attribute11 =
2245: p_flow_schedule_rec.attribute11) OR
2246: ((p_flow_schedule_rec.attribute11 = FND_API.G_MISS_CHAR) OR
2247: ( (l_flow_schedule_rec.attribute11 IS NULL) AND
2248: (p_flow_schedule_rec.attribute11 IS NULL))))
2249: AND ( (l_flow_schedule_rec.attribute12 =
2250: p_flow_schedule_rec.attribute12) OR
2247: ( (l_flow_schedule_rec.attribute11 IS NULL) AND
2248: (p_flow_schedule_rec.attribute11 IS NULL))))
2249: AND ( (l_flow_schedule_rec.attribute12 =
2250: p_flow_schedule_rec.attribute12) OR
2251: ((p_flow_schedule_rec.attribute12 = FND_API.G_MISS_CHAR) OR
2252: ( (l_flow_schedule_rec.attribute12 IS NULL) AND
2253: (p_flow_schedule_rec.attribute12 IS NULL))))
2254: AND ( (l_flow_schedule_rec.attribute13 =
2255: p_flow_schedule_rec.attribute13) OR
2252: ( (l_flow_schedule_rec.attribute12 IS NULL) AND
2253: (p_flow_schedule_rec.attribute12 IS NULL))))
2254: AND ( (l_flow_schedule_rec.attribute13 =
2255: p_flow_schedule_rec.attribute13) OR
2256: ((p_flow_schedule_rec.attribute13 = FND_API.G_MISS_CHAR) OR
2257: ( (l_flow_schedule_rec.attribute13 IS NULL) AND
2258: (p_flow_schedule_rec.attribute13 IS NULL))))
2259: AND ( (l_flow_schedule_rec.attribute14 =
2260: p_flow_schedule_rec.attribute14) OR
2257: ( (l_flow_schedule_rec.attribute13 IS NULL) AND
2258: (p_flow_schedule_rec.attribute13 IS NULL))))
2259: AND ( (l_flow_schedule_rec.attribute14 =
2260: p_flow_schedule_rec.attribute14) OR
2261: ((p_flow_schedule_rec.attribute14 = FND_API.G_MISS_CHAR) OR
2262: ( (l_flow_schedule_rec.attribute14 IS NULL) AND
2263: (p_flow_schedule_rec.attribute14 IS NULL))))
2264: AND ( (l_flow_schedule_rec.attribute15 =
2265: p_flow_schedule_rec.attribute15) OR
2262: ( (l_flow_schedule_rec.attribute14 IS NULL) AND
2263: (p_flow_schedule_rec.attribute14 IS NULL))))
2264: AND ( (l_flow_schedule_rec.attribute15 =
2265: p_flow_schedule_rec.attribute15) OR
2266: ((p_flow_schedule_rec.attribute15 = FND_API.G_MISS_CHAR) OR
2267: ( (l_flow_schedule_rec.attribute15 IS NULL) AND
2268: (p_flow_schedule_rec.attribute15 IS NULL))))
2269: AND ( (l_flow_schedule_rec.attribute2 =
2270: p_flow_schedule_rec.attribute2) OR
2267: ( (l_flow_schedule_rec.attribute15 IS NULL) AND
2268: (p_flow_schedule_rec.attribute15 IS NULL))))
2269: AND ( (l_flow_schedule_rec.attribute2 =
2270: p_flow_schedule_rec.attribute2) OR
2271: ((p_flow_schedule_rec.attribute2 = FND_API.G_MISS_CHAR) OR
2272: ( (l_flow_schedule_rec.attribute2 IS NULL) AND
2273: (p_flow_schedule_rec.attribute2 IS NULL))))
2274: AND ( (l_flow_schedule_rec.attribute3 =
2275: p_flow_schedule_rec.attribute3) OR
2272: ( (l_flow_schedule_rec.attribute2 IS NULL) AND
2273: (p_flow_schedule_rec.attribute2 IS NULL))))
2274: AND ( (l_flow_schedule_rec.attribute3 =
2275: p_flow_schedule_rec.attribute3) OR
2276: ((p_flow_schedule_rec.attribute3 = FND_API.G_MISS_CHAR) OR
2277: ( (l_flow_schedule_rec.attribute3 IS NULL) AND
2278: (p_flow_schedule_rec.attribute3 IS NULL))))
2279: AND ( (l_flow_schedule_rec.attribute4 =
2280: p_flow_schedule_rec.attribute4) OR
2277: ( (l_flow_schedule_rec.attribute3 IS NULL) AND
2278: (p_flow_schedule_rec.attribute3 IS NULL))))
2279: AND ( (l_flow_schedule_rec.attribute4 =
2280: p_flow_schedule_rec.attribute4) OR
2281: ((p_flow_schedule_rec.attribute4 = FND_API.G_MISS_CHAR) OR
2282: ( (l_flow_schedule_rec.attribute4 IS NULL) AND
2283: (p_flow_schedule_rec.attribute4 IS NULL))))
2284: AND ( (l_flow_schedule_rec.attribute5 =
2285: p_flow_schedule_rec.attribute5) OR
2282: ( (l_flow_schedule_rec.attribute4 IS NULL) AND
2283: (p_flow_schedule_rec.attribute4 IS NULL))))
2284: AND ( (l_flow_schedule_rec.attribute5 =
2285: p_flow_schedule_rec.attribute5) OR
2286: ((p_flow_schedule_rec.attribute5 = FND_API.G_MISS_CHAR) OR
2287: ( (l_flow_schedule_rec.attribute5 IS NULL) AND
2288: (p_flow_schedule_rec.attribute5 IS NULL))))
2289: AND ( (l_flow_schedule_rec.attribute6 =
2290: p_flow_schedule_rec.attribute6) OR
2287: ( (l_flow_schedule_rec.attribute5 IS NULL) AND
2288: (p_flow_schedule_rec.attribute5 IS NULL))))
2289: AND ( (l_flow_schedule_rec.attribute6 =
2290: p_flow_schedule_rec.attribute6) OR
2291: ((p_flow_schedule_rec.attribute6 = FND_API.G_MISS_CHAR) OR
2292: ( (l_flow_schedule_rec.attribute6 IS NULL) AND
2293: (p_flow_schedule_rec.attribute6 IS NULL))))
2294: AND ( (l_flow_schedule_rec.attribute7 =
2295: p_flow_schedule_rec.attribute7) OR
2292: ( (l_flow_schedule_rec.attribute6 IS NULL) AND
2293: (p_flow_schedule_rec.attribute6 IS NULL))))
2294: AND ( (l_flow_schedule_rec.attribute7 =
2295: p_flow_schedule_rec.attribute7) OR
2296: ((p_flow_schedule_rec.attribute7 = FND_API.G_MISS_CHAR) OR
2297: ( (l_flow_schedule_rec.attribute7 IS NULL) AND
2298: (p_flow_schedule_rec.attribute7 IS NULL))))
2299: AND ( (l_flow_schedule_rec.attribute8 =
2300: p_flow_schedule_rec.attribute8) OR
2297: ( (l_flow_schedule_rec.attribute7 IS NULL) AND
2298: (p_flow_schedule_rec.attribute7 IS NULL))))
2299: AND ( (l_flow_schedule_rec.attribute8 =
2300: p_flow_schedule_rec.attribute8) OR
2301: ((p_flow_schedule_rec.attribute8 = FND_API.G_MISS_CHAR) OR
2302: ( (l_flow_schedule_rec.attribute8 IS NULL) AND
2303: (p_flow_schedule_rec.attribute8 IS NULL))))
2304: AND ( (l_flow_schedule_rec.attribute9 =
2305: p_flow_schedule_rec.attribute9) OR
2302: ( (l_flow_schedule_rec.attribute8 IS NULL) AND
2303: (p_flow_schedule_rec.attribute8 IS NULL))))
2304: AND ( (l_flow_schedule_rec.attribute9 =
2305: p_flow_schedule_rec.attribute9) OR
2306: ((p_flow_schedule_rec.attribute9 = FND_API.G_MISS_CHAR) OR
2307: ( (l_flow_schedule_rec.attribute9 IS NULL) AND
2308: (p_flow_schedule_rec.attribute9 IS NULL))))
2309: AND ( (l_flow_schedule_rec.attribute_category =
2310: p_flow_schedule_rec.attribute_category) OR
2307: ( (l_flow_schedule_rec.attribute9 IS NULL) AND
2308: (p_flow_schedule_rec.attribute9 IS NULL))))
2309: AND ( (l_flow_schedule_rec.attribute_category =
2310: p_flow_schedule_rec.attribute_category) OR
2311: ((p_flow_schedule_rec.attribute_category = FND_API.G_MISS_CHAR) OR
2312: ( (l_flow_schedule_rec.attribute_category IS NULL) AND
2313: (p_flow_schedule_rec.attribute_category IS NULL))))
2314: AND ( (l_flow_schedule_rec.bom_revision =
2315: p_flow_schedule_rec.bom_revision) OR
2312: ( (l_flow_schedule_rec.attribute_category IS NULL) AND
2313: (p_flow_schedule_rec.attribute_category IS NULL))))
2314: AND ( (l_flow_schedule_rec.bom_revision =
2315: p_flow_schedule_rec.bom_revision) OR
2316: ((p_flow_schedule_rec.bom_revision = FND_API.G_MISS_CHAR) OR
2317: ( (l_flow_schedule_rec.bom_revision IS NULL) AND
2318: (p_flow_schedule_rec.bom_revision IS NULL))))
2319: AND ( (l_flow_schedule_rec.bom_revision_date =
2320: p_flow_schedule_rec.bom_revision_date) OR
2317: ( (l_flow_schedule_rec.bom_revision IS NULL) AND
2318: (p_flow_schedule_rec.bom_revision IS NULL))))
2319: AND ( (l_flow_schedule_rec.bom_revision_date =
2320: p_flow_schedule_rec.bom_revision_date) OR
2321: ((p_flow_schedule_rec.bom_revision_date = FND_API.G_MISS_DATE) OR
2322: ( (l_flow_schedule_rec.bom_revision_date IS NULL) AND
2323: (p_flow_schedule_rec.bom_revision_date IS NULL))))
2324: AND ( (l_flow_schedule_rec.build_sequence =
2325: p_flow_schedule_rec.build_sequence) OR
2322: ( (l_flow_schedule_rec.bom_revision_date IS NULL) AND
2323: (p_flow_schedule_rec.bom_revision_date IS NULL))))
2324: AND ( (l_flow_schedule_rec.build_sequence =
2325: p_flow_schedule_rec.build_sequence) OR
2326: ((p_flow_schedule_rec.build_sequence = FND_API.G_MISS_NUM) OR
2327: ( (l_flow_schedule_rec.build_sequence IS NULL) AND
2328: (p_flow_schedule_rec.build_sequence IS NULL))))
2329: AND ( (l_flow_schedule_rec.class_code =
2330: p_flow_schedule_rec.class_code) OR
2327: ( (l_flow_schedule_rec.build_sequence IS NULL) AND
2328: (p_flow_schedule_rec.build_sequence IS NULL))))
2329: AND ( (l_flow_schedule_rec.class_code =
2330: p_flow_schedule_rec.class_code) OR
2331: ((p_flow_schedule_rec.class_code = FND_API.G_MISS_CHAR) OR
2332: ( (l_flow_schedule_rec.class_code IS NULL) AND
2333: (p_flow_schedule_rec.class_code IS NULL))))
2334: AND ( (l_flow_schedule_rec.completion_locator_id =
2335: p_flow_schedule_rec.completion_locator_id) OR
2332: ( (l_flow_schedule_rec.class_code IS NULL) AND
2333: (p_flow_schedule_rec.class_code IS NULL))))
2334: AND ( (l_flow_schedule_rec.completion_locator_id =
2335: p_flow_schedule_rec.completion_locator_id) OR
2336: ((p_flow_schedule_rec.completion_locator_id = FND_API.G_MISS_NUM) OR
2337: ( (l_flow_schedule_rec.completion_locator_id IS NULL) AND
2338: (p_flow_schedule_rec.completion_locator_id IS NULL))))
2339: AND ( (l_flow_schedule_rec.completion_subinventory =
2340: p_flow_schedule_rec.completion_subinventory) OR
2337: ( (l_flow_schedule_rec.completion_locator_id IS NULL) AND
2338: (p_flow_schedule_rec.completion_locator_id IS NULL))))
2339: AND ( (l_flow_schedule_rec.completion_subinventory =
2340: p_flow_schedule_rec.completion_subinventory) OR
2341: ((p_flow_schedule_rec.completion_subinventory = FND_API.G_MISS_CHAR) OR
2342: ( (l_flow_schedule_rec.completion_subinventory IS NULL) AND
2343: (p_flow_schedule_rec.completion_subinventory IS NULL))))
2344: /* AND ( (l_flow_schedule_rec.created_by =
2345: p_flow_schedule_rec.created_by) OR
2342: ( (l_flow_schedule_rec.completion_subinventory IS NULL) AND
2343: (p_flow_schedule_rec.completion_subinventory IS NULL))))
2344: /* AND ( (l_flow_schedule_rec.created_by =
2345: p_flow_schedule_rec.created_by) OR
2346: ((p_flow_schedule_rec.created_by = FND_API.G_MISS_NUM) OR
2347: ( (l_flow_schedule_rec.created_by IS NULL) AND
2348: (p_flow_schedule_rec.created_by IS NULL))))
2349: AND ( (l_flow_schedule_rec.creation_date =
2350: p_flow_schedule_rec.creation_date) OR
2347: ( (l_flow_schedule_rec.created_by IS NULL) AND
2348: (p_flow_schedule_rec.created_by IS NULL))))
2349: AND ( (l_flow_schedule_rec.creation_date =
2350: p_flow_schedule_rec.creation_date) OR
2351: ((p_flow_schedule_rec.creation_date = FND_API.G_MISS_DATE) OR
2352: ( (l_flow_schedule_rec.creation_date IS NULL) AND
2353: (p_flow_schedule_rec.creation_date IS NULL)))) */
2354: AND ( (l_flow_schedule_rec.date_closed =
2355: p_flow_schedule_rec.date_closed) OR
2352: ( (l_flow_schedule_rec.creation_date IS NULL) AND
2353: (p_flow_schedule_rec.creation_date IS NULL)))) */
2354: AND ( (l_flow_schedule_rec.date_closed =
2355: p_flow_schedule_rec.date_closed) OR
2356: ((p_flow_schedule_rec.date_closed = FND_API.G_MISS_DATE) OR
2357: ( (l_flow_schedule_rec.date_closed IS NULL) AND
2358: (p_flow_schedule_rec.date_closed IS NULL))))
2359: AND ( (l_flow_schedule_rec.demand_class =
2360: p_flow_schedule_rec.demand_class) OR
2357: ( (l_flow_schedule_rec.date_closed IS NULL) AND
2358: (p_flow_schedule_rec.date_closed IS NULL))))
2359: AND ( (l_flow_schedule_rec.demand_class =
2360: p_flow_schedule_rec.demand_class) OR
2361: ((p_flow_schedule_rec.demand_class = FND_API.G_MISS_CHAR) OR
2362: ( (l_flow_schedule_rec.demand_class IS NULL) AND
2363: (p_flow_schedule_rec.demand_class IS NULL))))
2364: AND ( (l_flow_schedule_rec.demand_source_delivery =
2365: p_flow_schedule_rec.demand_source_delivery) OR
2362: ( (l_flow_schedule_rec.demand_class IS NULL) AND
2363: (p_flow_schedule_rec.demand_class IS NULL))))
2364: AND ( (l_flow_schedule_rec.demand_source_delivery =
2365: p_flow_schedule_rec.demand_source_delivery) OR
2366: ((p_flow_schedule_rec.demand_source_delivery = FND_API.G_MISS_CHAR) OR
2367: ( (l_flow_schedule_rec.demand_source_delivery IS NULL) AND
2368: (p_flow_schedule_rec.demand_source_delivery IS NULL))))
2369: AND ( (l_flow_schedule_rec.demand_source_header_id =
2370: p_flow_schedule_rec.demand_source_header_id) OR
2367: ( (l_flow_schedule_rec.demand_source_delivery IS NULL) AND
2368: (p_flow_schedule_rec.demand_source_delivery IS NULL))))
2369: AND ( (l_flow_schedule_rec.demand_source_header_id =
2370: p_flow_schedule_rec.demand_source_header_id) OR
2371: ((p_flow_schedule_rec.demand_source_header_id = FND_API.G_MISS_NUM) OR
2372: ( (l_flow_schedule_rec.demand_source_header_id IS NULL) AND
2373: (p_flow_schedule_rec.demand_source_header_id IS NULL))))
2374: AND ( (l_flow_schedule_rec.demand_source_line =
2375: p_flow_schedule_rec.demand_source_line) OR
2372: ( (l_flow_schedule_rec.demand_source_header_id IS NULL) AND
2373: (p_flow_schedule_rec.demand_source_header_id IS NULL))))
2374: AND ( (l_flow_schedule_rec.demand_source_line =
2375: p_flow_schedule_rec.demand_source_line) OR
2376: ((p_flow_schedule_rec.demand_source_line = FND_API.G_MISS_CHAR) OR
2377: ( (l_flow_schedule_rec.demand_source_line IS NULL) AND
2378: (p_flow_schedule_rec.demand_source_line IS NULL))))
2379: AND ( (l_flow_schedule_rec.demand_source_type =
2380: p_flow_schedule_rec.demand_source_type) OR
2377: ( (l_flow_schedule_rec.demand_source_line IS NULL) AND
2378: (p_flow_schedule_rec.demand_source_line IS NULL))))
2379: AND ( (l_flow_schedule_rec.demand_source_type =
2380: p_flow_schedule_rec.demand_source_type) OR
2381: ((p_flow_schedule_rec.demand_source_type = FND_API.G_MISS_NUM) OR
2382: ( (l_flow_schedule_rec.demand_source_type IS NULL) AND
2383: (p_flow_schedule_rec.demand_source_type IS NULL))))
2384: /* AND ( (l_flow_schedule_rec.last_updated_by =
2385: p_flow_schedule_rec.last_updated_by) OR
2382: ( (l_flow_schedule_rec.demand_source_type IS NULL) AND
2383: (p_flow_schedule_rec.demand_source_type IS NULL))))
2384: /* AND ( (l_flow_schedule_rec.last_updated_by =
2385: p_flow_schedule_rec.last_updated_by) OR
2386: ((p_flow_schedule_rec.last_updated_by = FND_API.G_MISS_NUM) OR
2387: ( (l_flow_schedule_rec.last_updated_by IS NULL) AND
2388: (p_flow_schedule_rec.last_updated_by IS NULL))))
2389: AND ( (l_flow_schedule_rec.last_update_date =
2390: p_flow_schedule_rec.last_update_date) OR
2387: ( (l_flow_schedule_rec.last_updated_by IS NULL) AND
2388: (p_flow_schedule_rec.last_updated_by IS NULL))))
2389: AND ( (l_flow_schedule_rec.last_update_date =
2390: p_flow_schedule_rec.last_update_date) OR
2391: ((p_flow_schedule_rec.last_update_date = FND_API.G_MISS_DATE) OR
2392: ( (l_flow_schedule_rec.last_update_date IS NULL) AND
2393: (p_flow_schedule_rec.last_update_date IS NULL))))
2394: AND ( (l_flow_schedule_rec.last_update_login =
2395: p_flow_schedule_rec.last_update_login) OR
2392: ( (l_flow_schedule_rec.last_update_date IS NULL) AND
2393: (p_flow_schedule_rec.last_update_date IS NULL))))
2394: AND ( (l_flow_schedule_rec.last_update_login =
2395: p_flow_schedule_rec.last_update_login) OR
2396: ((p_flow_schedule_rec.last_update_login = FND_API.G_MISS_NUM) OR
2397: ( (l_flow_schedule_rec.last_update_login IS NULL) AND
2398: (p_flow_schedule_rec.last_update_login IS NULL)))) */
2399: AND ( (l_flow_schedule_rec.line_id =
2400: p_flow_schedule_rec.line_id) OR
2397: ( (l_flow_schedule_rec.last_update_login IS NULL) AND
2398: (p_flow_schedule_rec.last_update_login IS NULL)))) */
2399: AND ( (l_flow_schedule_rec.line_id =
2400: p_flow_schedule_rec.line_id) OR
2401: ((p_flow_schedule_rec.line_id = FND_API.G_MISS_NUM) OR
2402: ( (l_flow_schedule_rec.line_id IS NULL) AND
2403: (p_flow_schedule_rec.line_id IS NULL))))
2404: AND ( (l_flow_schedule_rec.material_account =
2405: p_flow_schedule_rec.material_account) OR
2402: ( (l_flow_schedule_rec.line_id IS NULL) AND
2403: (p_flow_schedule_rec.line_id IS NULL))))
2404: AND ( (l_flow_schedule_rec.material_account =
2405: p_flow_schedule_rec.material_account) OR
2406: ((p_flow_schedule_rec.material_account = FND_API.G_MISS_NUM) OR
2407: ( (l_flow_schedule_rec.material_account IS NULL) AND
2408: (p_flow_schedule_rec.material_account IS NULL))))
2409: AND ( (l_flow_schedule_rec.material_overhead_account =
2410: p_flow_schedule_rec.material_overhead_account) OR
2407: ( (l_flow_schedule_rec.material_account IS NULL) AND
2408: (p_flow_schedule_rec.material_account IS NULL))))
2409: AND ( (l_flow_schedule_rec.material_overhead_account =
2410: p_flow_schedule_rec.material_overhead_account) OR
2411: ((p_flow_schedule_rec.material_overhead_account = FND_API.G_MISS_NUM) OR
2412: ( (l_flow_schedule_rec.material_overhead_account IS NULL) AND
2413: (p_flow_schedule_rec.material_overhead_account IS NULL))))
2414: AND ( (l_flow_schedule_rec.material_variance_account =
2415: p_flow_schedule_rec.material_variance_account) OR
2412: ( (l_flow_schedule_rec.material_overhead_account IS NULL) AND
2413: (p_flow_schedule_rec.material_overhead_account IS NULL))))
2414: AND ( (l_flow_schedule_rec.material_variance_account =
2415: p_flow_schedule_rec.material_variance_account) OR
2416: ((p_flow_schedule_rec.material_variance_account = FND_API.G_MISS_NUM) OR
2417: ( (l_flow_schedule_rec.material_variance_account IS NULL) AND
2418: (p_flow_schedule_rec.material_variance_account IS NULL))))
2419: AND ( (l_flow_schedule_rec.mps_net_quantity =
2420: p_flow_schedule_rec.mps_net_quantity) OR
2417: ( (l_flow_schedule_rec.material_variance_account IS NULL) AND
2418: (p_flow_schedule_rec.material_variance_account IS NULL))))
2419: AND ( (l_flow_schedule_rec.mps_net_quantity =
2420: p_flow_schedule_rec.mps_net_quantity) OR
2421: ((p_flow_schedule_rec.mps_net_quantity = FND_API.G_MISS_NUM) OR
2422: ( (l_flow_schedule_rec.mps_net_quantity IS NULL) AND
2423: (p_flow_schedule_rec.mps_net_quantity IS NULL))))
2424: AND ( (l_flow_schedule_rec.mps_scheduled_comp_date =
2425: p_flow_schedule_rec.mps_scheduled_comp_date) OR
2422: ( (l_flow_schedule_rec.mps_net_quantity IS NULL) AND
2423: (p_flow_schedule_rec.mps_net_quantity IS NULL))))
2424: AND ( (l_flow_schedule_rec.mps_scheduled_comp_date =
2425: p_flow_schedule_rec.mps_scheduled_comp_date) OR
2426: ((p_flow_schedule_rec.mps_scheduled_comp_date = FND_API.G_MISS_DATE) OR
2427: ( (l_flow_schedule_rec.mps_scheduled_comp_date IS NULL) AND
2428: (p_flow_schedule_rec.mps_scheduled_comp_date IS NULL))))
2429: AND ( (l_flow_schedule_rec.organization_id =
2430: p_flow_schedule_rec.organization_id) OR
2427: ( (l_flow_schedule_rec.mps_scheduled_comp_date IS NULL) AND
2428: (p_flow_schedule_rec.mps_scheduled_comp_date IS NULL))))
2429: AND ( (l_flow_schedule_rec.organization_id =
2430: p_flow_schedule_rec.organization_id) OR
2431: ((p_flow_schedule_rec.organization_id = FND_API.G_MISS_NUM) OR
2432: ( (l_flow_schedule_rec.organization_id IS NULL) AND
2433: (p_flow_schedule_rec.organization_id IS NULL))))
2434: AND ( (l_flow_schedule_rec.outside_processing_acct =
2435: p_flow_schedule_rec.outside_processing_acct) OR
2432: ( (l_flow_schedule_rec.organization_id IS NULL) AND
2433: (p_flow_schedule_rec.organization_id IS NULL))))
2434: AND ( (l_flow_schedule_rec.outside_processing_acct =
2435: p_flow_schedule_rec.outside_processing_acct) OR
2436: ((p_flow_schedule_rec.outside_processing_acct = FND_API.G_MISS_NUM) OR
2437: ( (l_flow_schedule_rec.outside_processing_acct IS NULL) AND
2438: (p_flow_schedule_rec.outside_processing_acct IS NULL))))
2439: AND ( (l_flow_schedule_rec.outside_proc_var_acct =
2440: p_flow_schedule_rec.outside_proc_var_acct) OR
2437: ( (l_flow_schedule_rec.outside_processing_acct IS NULL) AND
2438: (p_flow_schedule_rec.outside_processing_acct IS NULL))))
2439: AND ( (l_flow_schedule_rec.outside_proc_var_acct =
2440: p_flow_schedule_rec.outside_proc_var_acct) OR
2441: ((p_flow_schedule_rec.outside_proc_var_acct = FND_API.G_MISS_NUM) OR
2442: ( (l_flow_schedule_rec.outside_proc_var_acct IS NULL) AND
2443: (p_flow_schedule_rec.outside_proc_var_acct IS NULL))))
2444: AND ( (l_flow_schedule_rec.overhead_account =
2445: p_flow_schedule_rec.overhead_account) OR
2442: ( (l_flow_schedule_rec.outside_proc_var_acct IS NULL) AND
2443: (p_flow_schedule_rec.outside_proc_var_acct IS NULL))))
2444: AND ( (l_flow_schedule_rec.overhead_account =
2445: p_flow_schedule_rec.overhead_account) OR
2446: ((p_flow_schedule_rec.overhead_account = FND_API.G_MISS_NUM) OR
2447: ( (l_flow_schedule_rec.overhead_account IS NULL) AND
2448: (p_flow_schedule_rec.overhead_account IS NULL))))
2449: AND ( (l_flow_schedule_rec.overhead_variance_account =
2450: p_flow_schedule_rec.overhead_variance_account) OR
2447: ( (l_flow_schedule_rec.overhead_account IS NULL) AND
2448: (p_flow_schedule_rec.overhead_account IS NULL))))
2449: AND ( (l_flow_schedule_rec.overhead_variance_account =
2450: p_flow_schedule_rec.overhead_variance_account) OR
2451: ((p_flow_schedule_rec.overhead_variance_account = FND_API.G_MISS_NUM) OR
2452: ( (l_flow_schedule_rec.overhead_variance_account IS NULL) AND
2453: (p_flow_schedule_rec.overhead_variance_account IS NULL))))
2454: AND ( (l_flow_schedule_rec.planned_quantity =
2455: p_flow_schedule_rec.planned_quantity) OR
2452: ( (l_flow_schedule_rec.overhead_variance_account IS NULL) AND
2453: (p_flow_schedule_rec.overhead_variance_account IS NULL))))
2454: AND ( (l_flow_schedule_rec.planned_quantity =
2455: p_flow_schedule_rec.planned_quantity) OR
2456: ((p_flow_schedule_rec.planned_quantity = FND_API.G_MISS_NUM) OR
2457: ( (l_flow_schedule_rec.planned_quantity IS NULL) AND
2458: (p_flow_schedule_rec.planned_quantity IS NULL))))
2459: AND ( (l_flow_schedule_rec.primary_item_id =
2460: p_flow_schedule_rec.primary_item_id) OR
2457: ( (l_flow_schedule_rec.planned_quantity IS NULL) AND
2458: (p_flow_schedule_rec.planned_quantity IS NULL))))
2459: AND ( (l_flow_schedule_rec.primary_item_id =
2460: p_flow_schedule_rec.primary_item_id) OR
2461: ((p_flow_schedule_rec.primary_item_id = FND_API.G_MISS_NUM) OR
2462: ( (l_flow_schedule_rec.primary_item_id IS NULL) AND
2463: (p_flow_schedule_rec.primary_item_id IS NULL))))
2464: AND ( (l_flow_schedule_rec.program_application_id =
2465: p_flow_schedule_rec.program_application_id) OR
2462: ( (l_flow_schedule_rec.primary_item_id IS NULL) AND
2463: (p_flow_schedule_rec.primary_item_id IS NULL))))
2464: AND ( (l_flow_schedule_rec.program_application_id =
2465: p_flow_schedule_rec.program_application_id) OR
2466: ((p_flow_schedule_rec.program_application_id = FND_API.G_MISS_NUM) OR
2467: ( (l_flow_schedule_rec.program_application_id IS NULL) AND
2468: (p_flow_schedule_rec.program_application_id IS NULL))))
2469: AND ( (l_flow_schedule_rec.program_id =
2470: p_flow_schedule_rec.program_id) OR
2467: ( (l_flow_schedule_rec.program_application_id IS NULL) AND
2468: (p_flow_schedule_rec.program_application_id IS NULL))))
2469: AND ( (l_flow_schedule_rec.program_id =
2470: p_flow_schedule_rec.program_id) OR
2471: ((p_flow_schedule_rec.program_id = FND_API.G_MISS_NUM) OR
2472: ( (l_flow_schedule_rec.program_id IS NULL) AND
2473: (p_flow_schedule_rec.program_id IS NULL))))
2474: AND ( (l_flow_schedule_rec.program_update_date =
2475: p_flow_schedule_rec.program_update_date) OR
2472: ( (l_flow_schedule_rec.program_id IS NULL) AND
2473: (p_flow_schedule_rec.program_id IS NULL))))
2474: AND ( (l_flow_schedule_rec.program_update_date =
2475: p_flow_schedule_rec.program_update_date) OR
2476: ((p_flow_schedule_rec.program_update_date = FND_API.G_MISS_DATE) OR
2477: ( (l_flow_schedule_rec.program_update_date IS NULL) AND
2478: (p_flow_schedule_rec.program_update_date IS NULL))))
2479: AND ( (l_flow_schedule_rec.project_id =
2480: p_flow_schedule_rec.project_id) OR
2477: ( (l_flow_schedule_rec.program_update_date IS NULL) AND
2478: (p_flow_schedule_rec.program_update_date IS NULL))))
2479: AND ( (l_flow_schedule_rec.project_id =
2480: p_flow_schedule_rec.project_id) OR
2481: ((p_flow_schedule_rec.project_id = FND_API.G_MISS_NUM) OR
2482: ( (l_flow_schedule_rec.project_id IS NULL) AND
2483: (p_flow_schedule_rec.project_id IS NULL))))
2484: AND ( (l_flow_schedule_rec.quantity_completed =
2485: p_flow_schedule_rec.quantity_completed) OR
2482: ( (l_flow_schedule_rec.project_id IS NULL) AND
2483: (p_flow_schedule_rec.project_id IS NULL))))
2484: AND ( (l_flow_schedule_rec.quantity_completed =
2485: p_flow_schedule_rec.quantity_completed) OR
2486: ((p_flow_schedule_rec.quantity_completed = FND_API.G_MISS_NUM) OR
2487: ( (l_flow_schedule_rec.quantity_completed IS NULL) AND
2488: (p_flow_schedule_rec.quantity_completed IS NULL))))
2489: AND ( (l_flow_schedule_rec.request_id =
2490: p_flow_schedule_rec.request_id) OR
2487: ( (l_flow_schedule_rec.quantity_completed IS NULL) AND
2488: (p_flow_schedule_rec.quantity_completed IS NULL))))
2489: AND ( (l_flow_schedule_rec.request_id =
2490: p_flow_schedule_rec.request_id) OR
2491: ((p_flow_schedule_rec.request_id = FND_API.G_MISS_NUM) OR
2492: ( (l_flow_schedule_rec.request_id IS NULL) AND
2493: (p_flow_schedule_rec.request_id IS NULL))))
2494: AND ( (l_flow_schedule_rec.resource_account =
2495: p_flow_schedule_rec.resource_account) OR
2492: ( (l_flow_schedule_rec.request_id IS NULL) AND
2493: (p_flow_schedule_rec.request_id IS NULL))))
2494: AND ( (l_flow_schedule_rec.resource_account =
2495: p_flow_schedule_rec.resource_account) OR
2496: ((p_flow_schedule_rec.resource_account = FND_API.G_MISS_NUM) OR
2497: ( (l_flow_schedule_rec.resource_account IS NULL) AND
2498: (p_flow_schedule_rec.resource_account IS NULL))))
2499: AND ( (l_flow_schedule_rec.resource_variance_account =
2500: p_flow_schedule_rec.resource_variance_account) OR
2497: ( (l_flow_schedule_rec.resource_account IS NULL) AND
2498: (p_flow_schedule_rec.resource_account IS NULL))))
2499: AND ( (l_flow_schedule_rec.resource_variance_account =
2500: p_flow_schedule_rec.resource_variance_account) OR
2501: ((p_flow_schedule_rec.resource_variance_account = FND_API.G_MISS_NUM) OR
2502: ( (l_flow_schedule_rec.resource_variance_account IS NULL) AND
2503: (p_flow_schedule_rec.resource_variance_account IS NULL))))
2504: AND ( (l_flow_schedule_rec.routing_revision =
2505: p_flow_schedule_rec.routing_revision) OR
2502: ( (l_flow_schedule_rec.resource_variance_account IS NULL) AND
2503: (p_flow_schedule_rec.resource_variance_account IS NULL))))
2504: AND ( (l_flow_schedule_rec.routing_revision =
2505: p_flow_schedule_rec.routing_revision) OR
2506: ((p_flow_schedule_rec.routing_revision = FND_API.G_MISS_CHAR) OR
2507: ( (l_flow_schedule_rec.routing_revision IS NULL) AND
2508: (p_flow_schedule_rec.routing_revision IS NULL))))
2509: AND ( (l_flow_schedule_rec.routing_revision_date =
2510: p_flow_schedule_rec.routing_revision_date) OR
2507: ( (l_flow_schedule_rec.routing_revision IS NULL) AND
2508: (p_flow_schedule_rec.routing_revision IS NULL))))
2509: AND ( (l_flow_schedule_rec.routing_revision_date =
2510: p_flow_schedule_rec.routing_revision_date) OR
2511: ((p_flow_schedule_rec.routing_revision_date = FND_API.G_MISS_DATE) OR
2512: ( (l_flow_schedule_rec.routing_revision_date IS NULL) AND
2513: (p_flow_schedule_rec.routing_revision_date IS NULL))))
2514: AND ( (l_flow_schedule_rec.scheduled_completion_date =
2515: p_flow_schedule_rec.scheduled_completion_date) OR
2512: ( (l_flow_schedule_rec.routing_revision_date IS NULL) AND
2513: (p_flow_schedule_rec.routing_revision_date IS NULL))))
2514: AND ( (l_flow_schedule_rec.scheduled_completion_date =
2515: p_flow_schedule_rec.scheduled_completion_date) OR
2516: ((p_flow_schedule_rec.scheduled_completion_date = FND_API.G_MISS_DATE) OR
2517: ( (l_flow_schedule_rec.scheduled_completion_date IS NULL) AND
2518: (p_flow_schedule_rec.scheduled_completion_date IS NULL))))
2519: AND ( (l_flow_schedule_rec.scheduled_flag =
2520: p_flow_schedule_rec.scheduled_flag) OR
2517: ( (l_flow_schedule_rec.scheduled_completion_date IS NULL) AND
2518: (p_flow_schedule_rec.scheduled_completion_date IS NULL))))
2519: AND ( (l_flow_schedule_rec.scheduled_flag =
2520: p_flow_schedule_rec.scheduled_flag) OR
2521: ((p_flow_schedule_rec.scheduled_flag = FND_API.G_MISS_NUM) OR
2522: ( (l_flow_schedule_rec.scheduled_flag IS NULL) AND
2523: (p_flow_schedule_rec.scheduled_flag IS NULL))))
2524: AND ( (l_flow_schedule_rec.scheduled_start_date =
2525: p_flow_schedule_rec.scheduled_start_date) OR
2522: ( (l_flow_schedule_rec.scheduled_flag IS NULL) AND
2523: (p_flow_schedule_rec.scheduled_flag IS NULL))))
2524: AND ( (l_flow_schedule_rec.scheduled_start_date =
2525: p_flow_schedule_rec.scheduled_start_date) OR
2526: ((p_flow_schedule_rec.scheduled_start_date = FND_API.G_MISS_DATE) OR
2527: ( (l_flow_schedule_rec.scheduled_start_date IS NULL) AND
2528: (p_flow_schedule_rec.scheduled_start_date IS NULL))))
2529: AND ( (l_flow_schedule_rec.schedule_group_id =
2530: p_flow_schedule_rec.schedule_group_id) OR
2527: ( (l_flow_schedule_rec.scheduled_start_date IS NULL) AND
2528: (p_flow_schedule_rec.scheduled_start_date IS NULL))))
2529: AND ( (l_flow_schedule_rec.schedule_group_id =
2530: p_flow_schedule_rec.schedule_group_id) OR
2531: ((p_flow_schedule_rec.schedule_group_id = FND_API.G_MISS_NUM) OR
2532: ( (l_flow_schedule_rec.schedule_group_id IS NULL) AND
2533: (p_flow_schedule_rec.schedule_group_id IS NULL))))
2534: AND ( (l_flow_schedule_rec.schedule_number =
2535: p_flow_schedule_rec.schedule_number) OR
2532: ( (l_flow_schedule_rec.schedule_group_id IS NULL) AND
2533: (p_flow_schedule_rec.schedule_group_id IS NULL))))
2534: AND ( (l_flow_schedule_rec.schedule_number =
2535: p_flow_schedule_rec.schedule_number) OR
2536: ((p_flow_schedule_rec.schedule_number = FND_API.G_MISS_CHAR) OR
2537: ( (l_flow_schedule_rec.schedule_number IS NULL) AND
2538: (p_flow_schedule_rec.schedule_number IS NULL))))
2539: AND ( (l_flow_schedule_rec.status =
2540: p_flow_schedule_rec.status) OR
2537: ( (l_flow_schedule_rec.schedule_number IS NULL) AND
2538: (p_flow_schedule_rec.schedule_number IS NULL))))
2539: AND ( (l_flow_schedule_rec.status =
2540: p_flow_schedule_rec.status) OR
2541: ((p_flow_schedule_rec.status = FND_API.G_MISS_NUM) OR
2542: ( (l_flow_schedule_rec.status IS NULL) AND
2543: (p_flow_schedule_rec.status IS NULL))))
2544: AND ( (l_flow_schedule_rec.std_cost_adjustment_acct =
2545: p_flow_schedule_rec.std_cost_adjustment_acct) OR
2542: ( (l_flow_schedule_rec.status IS NULL) AND
2543: (p_flow_schedule_rec.status IS NULL))))
2544: AND ( (l_flow_schedule_rec.std_cost_adjustment_acct =
2545: p_flow_schedule_rec.std_cost_adjustment_acct) OR
2546: ((p_flow_schedule_rec.std_cost_adjustment_acct = FND_API.G_MISS_NUM) OR
2547: ( (l_flow_schedule_rec.std_cost_adjustment_acct IS NULL) AND
2548: (p_flow_schedule_rec.std_cost_adjustment_acct IS NULL))))
2549: AND ( (l_flow_schedule_rec.task_id =
2550: p_flow_schedule_rec.task_id) OR
2547: ( (l_flow_schedule_rec.std_cost_adjustment_acct IS NULL) AND
2548: (p_flow_schedule_rec.std_cost_adjustment_acct IS NULL))))
2549: AND ( (l_flow_schedule_rec.task_id =
2550: p_flow_schedule_rec.task_id) OR
2551: ((p_flow_schedule_rec.task_id = FND_API.G_MISS_NUM) OR
2552: ( (l_flow_schedule_rec.task_id IS NULL) AND
2553: (p_flow_schedule_rec.task_id IS NULL))))
2554: AND ( (l_flow_schedule_rec.end_item_unit_number =
2555: p_flow_schedule_rec.end_item_unit_number) OR
2552: ( (l_flow_schedule_rec.task_id IS NULL) AND
2553: (p_flow_schedule_rec.task_id IS NULL))))
2554: AND ( (l_flow_schedule_rec.end_item_unit_number =
2555: p_flow_schedule_rec.end_item_unit_number) OR
2556: ((p_flow_schedule_rec.end_item_unit_number = FND_API.G_MISS_CHAR) OR
2557: ( (l_flow_schedule_rec.end_item_unit_number IS NULL) AND
2558: (p_flow_schedule_rec.end_item_unit_number IS NULL))))
2559: AND ( (l_flow_schedule_rec.quantity_scrapped =
2560: p_flow_schedule_rec.quantity_scrapped) OR
2557: ( (l_flow_schedule_rec.end_item_unit_number IS NULL) AND
2558: (p_flow_schedule_rec.end_item_unit_number IS NULL))))
2559: AND ( (l_flow_schedule_rec.quantity_scrapped =
2560: p_flow_schedule_rec.quantity_scrapped) OR
2561: ((p_flow_schedule_rec.quantity_scrapped = FND_API.G_MISS_NUM) OR
2562: ( (l_flow_schedule_rec.quantity_scrapped IS NULL) AND
2563: (p_flow_schedule_rec.quantity_scrapped IS NULL))))
2564: AND ( (l_flow_schedule_rec.wip_entity_id =
2565: p_flow_schedule_rec.wip_entity_id) OR
2562: ( (l_flow_schedule_rec.quantity_scrapped IS NULL) AND
2563: (p_flow_schedule_rec.quantity_scrapped IS NULL))))
2564: AND ( (l_flow_schedule_rec.wip_entity_id =
2565: p_flow_schedule_rec.wip_entity_id) OR
2566: ((p_flow_schedule_rec.wip_entity_id = FND_API.G_MISS_NUM) OR
2567: ( (l_flow_schedule_rec.wip_entity_id IS NULL) AND
2568: (p_flow_schedule_rec.wip_entity_id IS NULL))))
2569: THEN
2570:
2573: x_flow_schedule_rec := l_flow_schedule_rec;
2574:
2575: -- Set return status
2576:
2577: x_return_status := FND_API.G_RET_STS_SUCCESS;
2578: x_flow_schedule_rec.return_status := FND_API.G_RET_STS_SUCCESS;
2579:
2580: ELSE
2581: -- Row has changed by another user.
2574:
2575: -- Set return status
2576:
2577: x_return_status := FND_API.G_RET_STS_SUCCESS;
2578: x_flow_schedule_rec.return_status := FND_API.G_RET_STS_SUCCESS;
2579:
2580: ELSE
2581: -- Row has changed by another user.
2582:
2579:
2580: ELSE
2581: -- Row has changed by another user.
2582:
2583: x_return_status := FND_API.G_RET_STS_ERROR;
2584: x_flow_schedule_rec.return_status := FND_API.G_RET_STS_ERROR;
2585:
2586: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
2587: THEN
2580: ELSE
2581: -- Row has changed by another user.
2582:
2583: x_return_status := FND_API.G_RET_STS_ERROR;
2584: x_flow_schedule_rec.return_status := FND_API.G_RET_STS_ERROR;
2585:
2586: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
2587: THEN
2588:
2596: EXCEPTION
2597:
2598: WHEN NO_DATA_FOUND THEN
2599:
2600: x_return_status := FND_API.G_RET_STS_ERROR;
2601: x_flow_schedule_rec.return_status := FND_API.G_RET_STS_ERROR;
2602:
2603: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
2604: THEN
2597:
2598: WHEN NO_DATA_FOUND THEN
2599:
2600: x_return_status := FND_API.G_RET_STS_ERROR;
2601: x_flow_schedule_rec.return_status := FND_API.G_RET_STS_ERROR;
2602:
2603: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
2604: THEN
2605:
2608:
2609: END IF;
2610: WHEN APP_EXCEPTIONS.RECORD_LOCK_EXCEPTION THEN
2611:
2612: x_return_status := FND_API.G_RET_STS_ERROR;
2613: x_flow_schedule_rec.return_status := FND_API.G_RET_STS_ERROR;
2614:
2615: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
2616: THEN
2609: END IF;
2610: WHEN APP_EXCEPTIONS.RECORD_LOCK_EXCEPTION THEN
2611:
2612: x_return_status := FND_API.G_RET_STS_ERROR;
2613: x_flow_schedule_rec.return_status := FND_API.G_RET_STS_ERROR;
2614:
2615: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
2616: THEN
2617:
2620:
2621: END IF;
2622: WHEN OTHERS THEN
2623:
2624: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2625: x_flow_schedule_rec.return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2626:
2627: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2628: THEN
2621: END IF;
2622: WHEN OTHERS THEN
2623:
2624: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2625: x_flow_schedule_rec.return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2626:
2627: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2628: THEN
2629: FND_MSG_PUB.Add_Exc_Msg
2644: l_flow_schedule_val_rec MRP_Flow_Schedule_PVT.Flow_Schedule_Val_PVT_Rec_Type ;
2645: BEGIN
2646:
2647: IF p_flow_schedule_rec.completion_locator_id IS NOT NULL AND
2648: p_flow_schedule_rec.completion_locator_id <> FND_API.G_MISS_NUM AND
2649: NOT MRP_GLOBALS.Equal(p_flow_schedule_rec.completion_locator_id,
2650: p_old_flow_schedule_rec.completion_locator_id)
2651: THEN
2652: l_flow_schedule_val_rec.completion_locator := MRP_Id_To_Value.Completion_Locator
2654: );
2655: END IF;
2656:
2657: IF p_flow_schedule_rec.line_id IS NOT NULL AND
2658: p_flow_schedule_rec.line_id <> FND_API.G_MISS_NUM AND
2659: NOT MRP_GLOBALS.Equal(p_flow_schedule_rec.line_id,
2660: p_old_flow_schedule_rec.line_id)
2661: THEN
2662: l_flow_schedule_val_rec.line := MRP_Id_To_Value.Line
2664: );
2665: END IF;
2666:
2667: IF p_flow_schedule_rec.organization_id IS NOT NULL AND
2668: p_flow_schedule_rec.organization_id <> FND_API.G_MISS_NUM AND
2669: NOT MRP_GLOBALS.Equal(p_flow_schedule_rec.organization_id,
2670: p_old_flow_schedule_rec.organization_id)
2671: THEN
2672: l_flow_schedule_val_rec.organization := MRP_Id_To_Value.Organization
2674: );
2675: END IF;
2676:
2677: IF p_flow_schedule_rec.primary_item_id IS NOT NULL AND
2678: p_flow_schedule_rec.primary_item_id <> FND_API.G_MISS_NUM AND
2679: NOT MRP_GLOBALS.Equal(p_flow_schedule_rec.primary_item_id,
2680: p_old_flow_schedule_rec.primary_item_id)
2681: THEN
2682: l_flow_schedule_val_rec.primary_item := MRP_Id_To_Value.Primary_Item
2684: );
2685: END IF;
2686:
2687: IF p_flow_schedule_rec.project_id IS NOT NULL AND
2688: p_flow_schedule_rec.project_id <> FND_API.G_MISS_NUM AND
2689: NOT MRP_GLOBALS.Equal(p_flow_schedule_rec.project_id,
2690: p_old_flow_schedule_rec.project_id)
2691: THEN
2692: l_flow_schedule_val_rec.project := MRP_Id_To_Value.Project
2694: );
2695: END IF;
2696:
2697: IF p_flow_schedule_rec.schedule_group_id IS NOT NULL AND
2698: p_flow_schedule_rec.schedule_group_id <> FND_API.G_MISS_NUM AND
2699: NOT MRP_GLOBALS.Equal(p_flow_schedule_rec.schedule_group_id,
2700: p_old_flow_schedule_rec.schedule_group_id)
2701: THEN
2702: l_flow_schedule_val_rec.schedule_group := MRP_Id_To_Value.Schedule_Group
2704: );
2705: END IF;
2706:
2707: IF p_flow_schedule_rec.task_id IS NOT NULL AND
2708: p_flow_schedule_rec.task_id <> FND_API.G_MISS_NUM AND
2709: NOT MRP_GLOBALS.Equal(p_flow_schedule_rec.task_id,
2710: p_old_flow_schedule_rec.task_id)
2711: THEN
2712: l_flow_schedule_val_rec.task := MRP_Id_To_Value.Task
2714: );
2715: END IF;
2716:
2717: IF p_flow_schedule_rec.wip_entity_id IS NOT NULL AND
2718: p_flow_schedule_rec.wip_entity_id <> FND_API.G_MISS_NUM AND
2719: NOT MRP_GLOBALS.Equal(p_flow_schedule_rec.wip_entity_id,
2720: p_old_flow_schedule_rec.wip_entity_id)
2721: THEN
2722: l_flow_schedule_val_rec.wip_entity := MRP_Id_To_Value.Wip_Entity
2739: BEGIN
2740:
2741: -- initialize return_status.
2742:
2743: l_flow_schedule_rec.return_status := FND_API.G_RET_STS_SUCCESS;
2744:
2745: -- initialize l_flow_schedule_rec.
2746:
2747: l_flow_schedule_rec := p_flow_schedule_rec;
2745: -- initialize l_flow_schedule_rec.
2746:
2747: l_flow_schedule_rec := p_flow_schedule_rec;
2748:
2749: IF p_flow_schedule_val_rec.completion_locator <> FND_API.G_MISS_CHAR
2750: THEN
2751:
2752: IF p_flow_schedule_rec.completion_locator_id <> FND_API.G_MISS_NUM THEN
2753:
2748:
2749: IF p_flow_schedule_val_rec.completion_locator <> FND_API.G_MISS_CHAR
2750: THEN
2751:
2752: IF p_flow_schedule_rec.completion_locator_id <> FND_API.G_MISS_NUM THEN
2753:
2754: l_flow_schedule_rec.completion_locator_id := p_flow_schedule_rec.completion_locator_id;
2755:
2756: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_SUCCESS)
2767: l_flow_schedule_rec.completion_locator_id := MRP_Value_To_Id.completion_locator
2768: ( p_completion_locator => p_flow_schedule_val_rec.completion_locator
2769: );
2770:
2771: IF l_flow_schedule_rec.completion_locator_id = FND_API.G_MISS_NUM THEN
2772: l_flow_schedule_rec.return_status := FND_API.G_RET_STS_ERROR;
2773: END IF;
2774:
2775: END IF;
2768: ( p_completion_locator => p_flow_schedule_val_rec.completion_locator
2769: );
2770:
2771: IF l_flow_schedule_rec.completion_locator_id = FND_API.G_MISS_NUM THEN
2772: l_flow_schedule_rec.return_status := FND_API.G_RET_STS_ERROR;
2773: END IF;
2774:
2775: END IF;
2776:
2775: END IF;
2776:
2777: END IF;
2778:
2779: IF p_flow_schedule_val_rec.line <> FND_API.G_MISS_CHAR
2780: THEN
2781:
2782: IF p_flow_schedule_rec.line_id <> FND_API.G_MISS_NUM THEN
2783:
2778:
2779: IF p_flow_schedule_val_rec.line <> FND_API.G_MISS_CHAR
2780: THEN
2781:
2782: IF p_flow_schedule_rec.line_id <> FND_API.G_MISS_NUM THEN
2783:
2784: l_flow_schedule_rec.line_id := p_flow_schedule_rec.line_id;
2785:
2786: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_SUCCESS)
2797: l_flow_schedule_rec.line_id := MRP_Value_To_Id.line
2798: ( p_line => p_flow_schedule_val_rec.line
2799: );
2800:
2801: IF l_flow_schedule_rec.line_id = FND_API.G_MISS_NUM THEN
2802: l_flow_schedule_rec.return_status := FND_API.G_RET_STS_ERROR;
2803: END IF;
2804:
2805: END IF;
2798: ( p_line => p_flow_schedule_val_rec.line
2799: );
2800:
2801: IF l_flow_schedule_rec.line_id = FND_API.G_MISS_NUM THEN
2802: l_flow_schedule_rec.return_status := FND_API.G_RET_STS_ERROR;
2803: END IF;
2804:
2805: END IF;
2806:
2805: END IF;
2806:
2807: END IF;
2808:
2809: IF p_flow_schedule_val_rec.organization <> FND_API.G_MISS_CHAR
2810: THEN
2811:
2812: IF p_flow_schedule_rec.organization_id <> FND_API.G_MISS_NUM THEN
2813:
2808:
2809: IF p_flow_schedule_val_rec.organization <> FND_API.G_MISS_CHAR
2810: THEN
2811:
2812: IF p_flow_schedule_rec.organization_id <> FND_API.G_MISS_NUM THEN
2813:
2814: l_flow_schedule_rec.organization_id := p_flow_schedule_rec.organization_id;
2815:
2816: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_SUCCESS)
2827: l_flow_schedule_rec.organization_id := MRP_Value_To_Id.organization
2828: ( p_organization => p_flow_schedule_val_rec.organization
2829: );
2830:
2831: IF l_flow_schedule_rec.organization_id = FND_API.G_MISS_NUM THEN
2832: l_flow_schedule_rec.return_status := FND_API.G_RET_STS_ERROR;
2833: END IF;
2834:
2835: END IF;
2828: ( p_organization => p_flow_schedule_val_rec.organization
2829: );
2830:
2831: IF l_flow_schedule_rec.organization_id = FND_API.G_MISS_NUM THEN
2832: l_flow_schedule_rec.return_status := FND_API.G_RET_STS_ERROR;
2833: END IF;
2834:
2835: END IF;
2836:
2835: END IF;
2836:
2837: END IF;
2838:
2839: IF p_flow_schedule_val_rec.primary_item <> FND_API.G_MISS_CHAR
2840: THEN
2841:
2842: IF p_flow_schedule_rec.primary_item_id <> FND_API.G_MISS_NUM THEN
2843:
2838:
2839: IF p_flow_schedule_val_rec.primary_item <> FND_API.G_MISS_CHAR
2840: THEN
2841:
2842: IF p_flow_schedule_rec.primary_item_id <> FND_API.G_MISS_NUM THEN
2843:
2844: l_flow_schedule_rec.primary_item_id := p_flow_schedule_rec.primary_item_id;
2845:
2846: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_SUCCESS)
2857: l_flow_schedule_rec.primary_item_id := MRP_Value_To_Id.primary_item
2858: ( p_primary_item => p_flow_schedule_val_rec.primary_item
2859: );
2860:
2861: IF l_flow_schedule_rec.primary_item_id = FND_API.G_MISS_NUM THEN
2862: l_flow_schedule_rec.return_status := FND_API.G_RET_STS_ERROR;
2863: END IF;
2864:
2865: END IF;
2858: ( p_primary_item => p_flow_schedule_val_rec.primary_item
2859: );
2860:
2861: IF l_flow_schedule_rec.primary_item_id = FND_API.G_MISS_NUM THEN
2862: l_flow_schedule_rec.return_status := FND_API.G_RET_STS_ERROR;
2863: END IF;
2864:
2865: END IF;
2866:
2865: END IF;
2866:
2867: END IF;
2868:
2869: IF p_flow_schedule_val_rec.project <> FND_API.G_MISS_CHAR
2870: THEN
2871:
2872: IF p_flow_schedule_rec.project_id <> FND_API.G_MISS_NUM THEN
2873:
2868:
2869: IF p_flow_schedule_val_rec.project <> FND_API.G_MISS_CHAR
2870: THEN
2871:
2872: IF p_flow_schedule_rec.project_id <> FND_API.G_MISS_NUM THEN
2873:
2874: l_flow_schedule_rec.project_id := p_flow_schedule_rec.project_id;
2875:
2876: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_SUCCESS)
2887: l_flow_schedule_rec.project_id := MRP_Value_To_Id.project
2888: ( p_project => p_flow_schedule_val_rec.project
2889: );
2890:
2891: IF l_flow_schedule_rec.project_id = FND_API.G_MISS_NUM THEN
2892: l_flow_schedule_rec.return_status := FND_API.G_RET_STS_ERROR;
2893: END IF;
2894:
2895: END IF;
2888: ( p_project => p_flow_schedule_val_rec.project
2889: );
2890:
2891: IF l_flow_schedule_rec.project_id = FND_API.G_MISS_NUM THEN
2892: l_flow_schedule_rec.return_status := FND_API.G_RET_STS_ERROR;
2893: END IF;
2894:
2895: END IF;
2896:
2895: END IF;
2896:
2897: END IF;
2898:
2899: IF p_flow_schedule_val_rec.schedule_group <> FND_API.G_MISS_CHAR
2900: THEN
2901:
2902: IF p_flow_schedule_rec.schedule_group_id <> FND_API.G_MISS_NUM THEN
2903:
2898:
2899: IF p_flow_schedule_val_rec.schedule_group <> FND_API.G_MISS_CHAR
2900: THEN
2901:
2902: IF p_flow_schedule_rec.schedule_group_id <> FND_API.G_MISS_NUM THEN
2903:
2904: l_flow_schedule_rec.schedule_group_id := p_flow_schedule_rec.schedule_group_id;
2905:
2906: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_SUCCESS)
2917: l_flow_schedule_rec.schedule_group_id := MRP_Value_To_Id.schedule_group
2918: ( p_schedule_group => p_flow_schedule_val_rec.schedule_group
2919: );
2920:
2921: IF l_flow_schedule_rec.schedule_group_id = FND_API.G_MISS_NUM THEN
2922: l_flow_schedule_rec.return_status := FND_API.G_RET_STS_ERROR;
2923: END IF;
2924:
2925: END IF;
2918: ( p_schedule_group => p_flow_schedule_val_rec.schedule_group
2919: );
2920:
2921: IF l_flow_schedule_rec.schedule_group_id = FND_API.G_MISS_NUM THEN
2922: l_flow_schedule_rec.return_status := FND_API.G_RET_STS_ERROR;
2923: END IF;
2924:
2925: END IF;
2926:
2925: END IF;
2926:
2927: END IF;
2928:
2929: IF p_flow_schedule_val_rec.task <> FND_API.G_MISS_CHAR
2930: THEN
2931:
2932: IF p_flow_schedule_rec.task_id <> FND_API.G_MISS_NUM THEN
2933:
2928:
2929: IF p_flow_schedule_val_rec.task <> FND_API.G_MISS_CHAR
2930: THEN
2931:
2932: IF p_flow_schedule_rec.task_id <> FND_API.G_MISS_NUM THEN
2933:
2934: l_flow_schedule_rec.task_id := p_flow_schedule_rec.task_id;
2935:
2936: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_SUCCESS)
2947: l_flow_schedule_rec.task_id := MRP_Value_To_Id.task
2948: ( p_task => p_flow_schedule_val_rec.task
2949: );
2950:
2951: IF l_flow_schedule_rec.task_id = FND_API.G_MISS_NUM THEN
2952: l_flow_schedule_rec.return_status := FND_API.G_RET_STS_ERROR;
2953: END IF;
2954:
2955: END IF;
2948: ( p_task => p_flow_schedule_val_rec.task
2949: );
2950:
2951: IF l_flow_schedule_rec.task_id = FND_API.G_MISS_NUM THEN
2952: l_flow_schedule_rec.return_status := FND_API.G_RET_STS_ERROR;
2953: END IF;
2954:
2955: END IF;
2956:
2955: END IF;
2956:
2957: END IF;
2958:
2959: IF p_flow_schedule_val_rec.wip_entity <> FND_API.G_MISS_CHAR
2960: THEN
2961:
2962: IF p_flow_schedule_rec.wip_entity_id <> FND_API.G_MISS_NUM THEN
2963:
2958:
2959: IF p_flow_schedule_val_rec.wip_entity <> FND_API.G_MISS_CHAR
2960: THEN
2961:
2962: IF p_flow_schedule_rec.wip_entity_id <> FND_API.G_MISS_NUM THEN
2963:
2964: l_flow_schedule_rec.wip_entity_id := p_flow_schedule_rec.wip_entity_id;
2965:
2966: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_SUCCESS)
2977: l_flow_schedule_rec.wip_entity_id := MRP_Value_To_Id.wip_entity
2978: ( p_wip_entity => p_flow_schedule_val_rec.wip_entity
2979: );
2980:
2981: IF l_flow_schedule_rec.wip_entity_id = FND_API.G_MISS_NUM THEN
2982: l_flow_schedule_rec.return_status := FND_API.G_RET_STS_ERROR;
2983: END IF;
2984:
2985: END IF;
2978: ( p_wip_entity => p_flow_schedule_val_rec.wip_entity
2979: );
2980:
2981: IF l_flow_schedule_rec.wip_entity_id = FND_API.G_MISS_NUM THEN
2982: l_flow_schedule_rec.return_status := FND_API.G_RET_STS_ERROR;
2983: END IF;
2984:
2985: END IF;
2986:
3166: SELECT mrp_form_query_s.nextval
3167: INTO l_query_id1
3168: FROM dual;
3169:
3170: x_return_status := FND_API.G_RET_STS_SUCCESS;
3171:
3172: FOR loop in 1..7 LOOP
3173: INSERT INTO mrp_form_query (
3174: query_id,
3267: EXCEPTION
3268:
3269: WHEN OTHERS THEN
3270:
3271: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3272:
3273: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
3274:
3275: FND_MSG_PUB.Add_Exc_Msg
3277: , 'populate_flow_summary'
3278: );
3279: END IF;
3280:
3281: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3282:
3283: END Populate_Flow_Summary;
3284:
3285: PROCEDURE Update_Quantity(
3296: UPDATE wip_flow_schedules
3297: SET planned_quantity = planned_quantity + p_quantity
3298: WHERE wip_entity_id = p_wip_entity_id;
3299:
3300: x_return_status := FND_API.G_RET_STS_SUCCESS;
3301:
3302: -- Get message count and data
3303:
3304: FND_MSG_PUB.Count_And_Get
3309: EXCEPTION
3310:
3311: WHEN OTHERS THEN
3312:
3313: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3314:
3315: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
3316:
3317: FND_MSG_PUB.Add_Exc_Msg
3319: , 'update_quantity'
3320: );
3321: END IF;
3322:
3323: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3324:
3325: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3326:
3327: -- Get message count and data
3321: END IF;
3322:
3323: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3324:
3325: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3326:
3327: -- Get message count and data
3328:
3329: FND_MSG_PUB.Count_And_Get
3354: , 'update_quantity'
3355: );
3356: END IF;
3357:
3358: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3359:
3360: END Update_Quantity;
3361:
3362: PROCEDURE Delete_Flow_Row
3376: AND nvl(transacted_flag, 'N') = 'N'
3377: AND quantity_completed = 0
3378: AND quantity_scrapped = 0 ;
3379:
3380: x_return_status := FND_API.G_RET_STS_SUCCESS;
3381:
3382: -- Get message count and data
3383:
3384: FND_MSG_PUB.Count_And_Get
3396: , 'Delete_Flow_Row'
3397: );
3398: END IF;
3399:
3400: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3401:
3402: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3403:
3404: -- Get message count and data
3398: END IF;
3399:
3400: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3401:
3402: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3403:
3404: -- Get message count and data
3405:
3406: FND_MSG_PUB.Count_And_Get
3684:
3685: -- Added to support component picking. It will cancel the move order when the flow
3686: -- schedule is to be deleted.
3687: wip_picking_pvt.cancel_allocations(l_wip_entity_id, 4, null, l_return_status, l_msg_data);
3688: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3689: MRP_UTIL.MRP_LOG(l_msg_data);
3690: ELSE
3691: DELETE FROM wip_flow_schedules
3692: WHERE wip_entity_id = l_wip_entity_id AND organization_id = p_organization_id;
3814: l_unprocessed_var NUMBER := 0;
3815: l_remainder NUMBER := 0;
3816: l_row_count NUMBER := 0;
3817:
3818: l_wip_entity_id NUMBER := FND_API.G_MISS_NUM;
3819: l_wip_entity_id2 NUMBER := FND_API.G_MISS_NUM;
3820: l_completion_date DATE := FND_API.G_MISS_DATE;
3821: l_old_completion_date DATE := FND_API.G_MISS_DATE;
3822: l_planned_quantity NUMBER := FND_API.G_MISS_NUM;
3815: l_remainder NUMBER := 0;
3816: l_row_count NUMBER := 0;
3817:
3818: l_wip_entity_id NUMBER := FND_API.G_MISS_NUM;
3819: l_wip_entity_id2 NUMBER := FND_API.G_MISS_NUM;
3820: l_completion_date DATE := FND_API.G_MISS_DATE;
3821: l_old_completion_date DATE := FND_API.G_MISS_DATE;
3822: l_planned_quantity NUMBER := FND_API.G_MISS_NUM;
3823: l_quantity_completed NUMBER := FND_API.G_MISS_NUM;
3816: l_row_count NUMBER := 0;
3817:
3818: l_wip_entity_id NUMBER := FND_API.G_MISS_NUM;
3819: l_wip_entity_id2 NUMBER := FND_API.G_MISS_NUM;
3820: l_completion_date DATE := FND_API.G_MISS_DATE;
3821: l_old_completion_date DATE := FND_API.G_MISS_DATE;
3822: l_planned_quantity NUMBER := FND_API.G_MISS_NUM;
3823: l_quantity_completed NUMBER := FND_API.G_MISS_NUM;
3824:
3817:
3818: l_wip_entity_id NUMBER := FND_API.G_MISS_NUM;
3819: l_wip_entity_id2 NUMBER := FND_API.G_MISS_NUM;
3820: l_completion_date DATE := FND_API.G_MISS_DATE;
3821: l_old_completion_date DATE := FND_API.G_MISS_DATE;
3822: l_planned_quantity NUMBER := FND_API.G_MISS_NUM;
3823: l_quantity_completed NUMBER := FND_API.G_MISS_NUM;
3824:
3825: l_report_query_id NUMBER;
3818: l_wip_entity_id NUMBER := FND_API.G_MISS_NUM;
3819: l_wip_entity_id2 NUMBER := FND_API.G_MISS_NUM;
3820: l_completion_date DATE := FND_API.G_MISS_DATE;
3821: l_old_completion_date DATE := FND_API.G_MISS_DATE;
3822: l_planned_quantity NUMBER := FND_API.G_MISS_NUM;
3823: l_quantity_completed NUMBER := FND_API.G_MISS_NUM;
3824:
3825: l_report_query_id NUMBER;
3826:
3819: l_wip_entity_id2 NUMBER := FND_API.G_MISS_NUM;
3820: l_completion_date DATE := FND_API.G_MISS_DATE;
3821: l_old_completion_date DATE := FND_API.G_MISS_DATE;
3822: l_planned_quantity NUMBER := FND_API.G_MISS_NUM;
3823: l_quantity_completed NUMBER := FND_API.G_MISS_NUM;
3824:
3825: l_report_query_id NUMBER;
3826:
3827: fs_report_rec REPORT_REC_TYPE;
6245: l_remainder := abs(mod(l_variance,l_row_count));
6246:
6247: CLOSE C4;
6248:
6249: l_old_completion_date := FND_API.G_MISS_DATE;
6250: OPEN C3(fs_report_rec.line_id, fs_report_rec.primary_item_id,
6251: l_to_start_date, l_to_end_date); --fix bug#3170105
6252:
6253: LOOP
6337: );
6338:
6339: IF p_output = 2 THEN
6340: -- Write either error or success message to log
6341: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
6342: FND_MESSAGE.set_name('MRP','MRP_ROLL_CREATE');
6343: FND_MESSAGE.set_token('LINE',fs_report_rec.line_code);
6344: FND_MESSAGE.set_token('ITEM',fs_report_rec.item);
6345: FND_MESSAGE.set_token('COMP_DATE',l_x_flow_schedule_rec.scheduled_completion_date);
6895: x_flow_schedule_rec => l_x_flow_schedule_rec
6896: );
6897:
6898: /* Added for Enhancement #2829204 */
6899: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
6900: SELECT auto_replenish,
6901: wip_entity_id
6902: INTO l_auto_replenish,
6903: l_wip_entity_id
6938: END IF; /* end of if for l_return_status */
6939:
6940: IF p_output = 2 THEN
6941: -- Write either error or success message to log
6942: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
6943: FND_MESSAGE.set_name('MRP','MRP_ROLL_CREATE');
6944: FND_MESSAGE.set_token('LINE',fs_report_rec.line_code);
6945: FND_MESSAGE.set_token('ITEM',fs_report_rec.item);
6946: FND_MESSAGE.set_token('COMP_DATE',l_x_flow_schedule_rec.scheduled_completion_date);
7420: END IF;
7421:
7422: EXCEPTION
7423:
7424: WHEN FND_API.G_EXC_ERROR THEN
7425:
7426: x_return_status := FND_API.G_RET_STS_ERROR;
7427:
7428: -- Get message count and data
7422: EXCEPTION
7423:
7424: WHEN FND_API.G_EXC_ERROR THEN
7425:
7426: x_return_status := FND_API.G_RET_STS_ERROR;
7427:
7428: -- Get message count and data
7429:
7430: FND_MSG_PUB.Count_And_Get
7431: ( p_count => x_msg_count
7432: , p_data => x_msg_data
7433: );
7434:
7435: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
7436:
7437: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
7438:
7439: -- Get message count and data
7433: );
7434:
7435: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
7436:
7437: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
7438:
7439: -- Get message count and data
7440:
7441: FND_MSG_PUB.Count_And_Get
7444: );
7445:
7446: WHEN OTHERS THEN
7447:
7448: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
7449:
7450: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
7451: THEN
7452: FND_MSG_PUB.Add_Exc_Msg
7511: UPDATE wip_entities
7512: SET wip_entity_name = l_schedule_number_out
7513: WHERE wip_entity_id = l_wip_entity_id;
7514: ELSE
7515: RAISE FND_API.G_EXC_ERROR;
7516: END IF;
7517: END IF;
7518: END LOOP;
7519: CLOSE C1;
7580: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
7581: FND_MESSAGE.SET_NAME('BOM',l_error_msg);
7582: FND_MSG_PUB.Add;
7583: END IF;
7584: RAISE FND_API.G_EXC_ERROR;
7585: END IF;
7586:
7587: END LOOP;
7588:
7991: ,x_msg_data => l_msg_data
7992: );
7993:
7994: l_return := 1;
7995: IF ( l_return_status = FND_API.G_RET_STS_SUCCESS AND
7996: l_check_holds_result = FND_API.G_FALSE ) THEN
7997: l_return := 0;
7998: END IF;
7999:
7992: );
7993:
7994: l_return := 1;
7995: IF ( l_return_status = FND_API.G_RET_STS_SUCCESS AND
7996: l_check_holds_result = FND_API.G_FALSE ) THEN
7997: l_return := 0;
7998: END IF;
7999:
8000: return l_return;
8133: ,x_msg_data => l_msg_data
8134: );
8135:
8136: l_return := 1;
8137: IF ( l_return_status = FND_API.G_RET_STS_SUCCESS AND
8138: l_check_holds_result = FND_API.G_FALSE ) THEN
8139: l_return := 0;
8140: END IF;
8141:
8134: );
8135:
8136: l_return := 1;
8137: IF ( l_return_status = FND_API.G_RET_STS_SUCCESS AND
8138: l_check_holds_result = FND_API.G_FALSE ) THEN
8139: l_return := 0;
8140: END IF;
8141:
8142: return l_return;