[Home] [Help]
19: IF(p_ForceCopy IS NOT NULL) THEN
20: IF(p_ForceCopy = TRUE)
21: THEN
22:
23: IF p_old_RepSchedule_rec.alternate_bom_designator <> FND_API.G_MISS_CHAR THEN
24: l_RepSchedule_rec.alternate_bom_designator := p_old_RepSchedule_rec.alternate_bom_designator;
25: END IF;
26:
27: IF p_old_RepSchedule_rec.alternate_rout_designator <> FND_API.G_MISS_CHAR THEN
23: IF p_old_RepSchedule_rec.alternate_bom_designator <> FND_API.G_MISS_CHAR THEN
24: l_RepSchedule_rec.alternate_bom_designator := p_old_RepSchedule_rec.alternate_bom_designator;
25: END IF;
26:
27: IF p_old_RepSchedule_rec.alternate_rout_designator <> FND_API.G_MISS_CHAR THEN
28: l_RepSchedule_rec.alternate_rout_designator := p_old_RepSchedule_rec.alternate_rout_designator;
29: END IF;
30:
31: IF p_old_RepSchedule_rec.attribute1 <> FND_API.G_MISS_CHAR THEN
27: IF p_old_RepSchedule_rec.alternate_rout_designator <> FND_API.G_MISS_CHAR THEN
28: l_RepSchedule_rec.alternate_rout_designator := p_old_RepSchedule_rec.alternate_rout_designator;
29: END IF;
30:
31: IF p_old_RepSchedule_rec.attribute1 <> FND_API.G_MISS_CHAR THEN
32: l_RepSchedule_rec.attribute1 := p_old_RepSchedule_rec.attribute1;
33: END IF;
34:
35: IF p_old_RepSchedule_rec.attribute10 <> FND_API.G_MISS_CHAR THEN
31: IF p_old_RepSchedule_rec.attribute1 <> FND_API.G_MISS_CHAR THEN
32: l_RepSchedule_rec.attribute1 := p_old_RepSchedule_rec.attribute1;
33: END IF;
34:
35: IF p_old_RepSchedule_rec.attribute10 <> FND_API.G_MISS_CHAR THEN
36: l_RepSchedule_rec.attribute10 := p_old_RepSchedule_rec.attribute10;
37: END IF;
38:
39: IF p_old_RepSchedule_rec.attribute11 <> FND_API.G_MISS_CHAR THEN
35: IF p_old_RepSchedule_rec.attribute10 <> FND_API.G_MISS_CHAR THEN
36: l_RepSchedule_rec.attribute10 := p_old_RepSchedule_rec.attribute10;
37: END IF;
38:
39: IF p_old_RepSchedule_rec.attribute11 <> FND_API.G_MISS_CHAR THEN
40: l_RepSchedule_rec.attribute11 := p_old_RepSchedule_rec.attribute11;
41: END IF;
42:
43: IF p_old_RepSchedule_rec.attribute12 <> FND_API.G_MISS_CHAR THEN
39: IF p_old_RepSchedule_rec.attribute11 <> FND_API.G_MISS_CHAR THEN
40: l_RepSchedule_rec.attribute11 := p_old_RepSchedule_rec.attribute11;
41: END IF;
42:
43: IF p_old_RepSchedule_rec.attribute12 <> FND_API.G_MISS_CHAR THEN
44: l_RepSchedule_rec.attribute12 := p_old_RepSchedule_rec.attribute12;
45: END IF;
46:
47: IF p_old_RepSchedule_rec.attribute13 <> FND_API.G_MISS_CHAR THEN
43: IF p_old_RepSchedule_rec.attribute12 <> FND_API.G_MISS_CHAR THEN
44: l_RepSchedule_rec.attribute12 := p_old_RepSchedule_rec.attribute12;
45: END IF;
46:
47: IF p_old_RepSchedule_rec.attribute13 <> FND_API.G_MISS_CHAR THEN
48: l_RepSchedule_rec.attribute13 := p_old_RepSchedule_rec.attribute13;
49: END IF;
50:
51: IF p_old_RepSchedule_rec.attribute14 <> FND_API.G_MISS_CHAR THEN
47: IF p_old_RepSchedule_rec.attribute13 <> FND_API.G_MISS_CHAR THEN
48: l_RepSchedule_rec.attribute13 := p_old_RepSchedule_rec.attribute13;
49: END IF;
50:
51: IF p_old_RepSchedule_rec.attribute14 <> FND_API.G_MISS_CHAR THEN
52: l_RepSchedule_rec.attribute14 := p_old_RepSchedule_rec.attribute14;
53: END IF;
54:
55: IF p_old_RepSchedule_rec.attribute15 <> FND_API.G_MISS_CHAR THEN
51: IF p_old_RepSchedule_rec.attribute14 <> FND_API.G_MISS_CHAR THEN
52: l_RepSchedule_rec.attribute14 := p_old_RepSchedule_rec.attribute14;
53: END IF;
54:
55: IF p_old_RepSchedule_rec.attribute15 <> FND_API.G_MISS_CHAR THEN
56: l_RepSchedule_rec.attribute15 := p_old_RepSchedule_rec.attribute15;
57: END IF;
58:
59: IF p_old_RepSchedule_rec.attribute2 <> FND_API.G_MISS_CHAR THEN
55: IF p_old_RepSchedule_rec.attribute15 <> FND_API.G_MISS_CHAR THEN
56: l_RepSchedule_rec.attribute15 := p_old_RepSchedule_rec.attribute15;
57: END IF;
58:
59: IF p_old_RepSchedule_rec.attribute2 <> FND_API.G_MISS_CHAR THEN
60: l_RepSchedule_rec.attribute2 := p_old_RepSchedule_rec.attribute2;
61: END IF;
62:
63: IF p_old_RepSchedule_rec.attribute3 <> FND_API.G_MISS_CHAR THEN
59: IF p_old_RepSchedule_rec.attribute2 <> FND_API.G_MISS_CHAR THEN
60: l_RepSchedule_rec.attribute2 := p_old_RepSchedule_rec.attribute2;
61: END IF;
62:
63: IF p_old_RepSchedule_rec.attribute3 <> FND_API.G_MISS_CHAR THEN
64: l_RepSchedule_rec.attribute3 := p_old_RepSchedule_rec.attribute3;
65: END IF;
66:
67: IF p_old_RepSchedule_rec.attribute4 <> FND_API.G_MISS_CHAR THEN
63: IF p_old_RepSchedule_rec.attribute3 <> FND_API.G_MISS_CHAR THEN
64: l_RepSchedule_rec.attribute3 := p_old_RepSchedule_rec.attribute3;
65: END IF;
66:
67: IF p_old_RepSchedule_rec.attribute4 <> FND_API.G_MISS_CHAR THEN
68: l_RepSchedule_rec.attribute4 := p_old_RepSchedule_rec.attribute4;
69: END IF;
70:
71: IF p_old_RepSchedule_rec.attribute5 <> FND_API.G_MISS_CHAR THEN
67: IF p_old_RepSchedule_rec.attribute4 <> FND_API.G_MISS_CHAR THEN
68: l_RepSchedule_rec.attribute4 := p_old_RepSchedule_rec.attribute4;
69: END IF;
70:
71: IF p_old_RepSchedule_rec.attribute5 <> FND_API.G_MISS_CHAR THEN
72: l_RepSchedule_rec.attribute5 := p_old_RepSchedule_rec.attribute5;
73: END IF;
74:
75: IF p_old_RepSchedule_rec.attribute6 <> FND_API.G_MISS_CHAR THEN
71: IF p_old_RepSchedule_rec.attribute5 <> FND_API.G_MISS_CHAR THEN
72: l_RepSchedule_rec.attribute5 := p_old_RepSchedule_rec.attribute5;
73: END IF;
74:
75: IF p_old_RepSchedule_rec.attribute6 <> FND_API.G_MISS_CHAR THEN
76: l_RepSchedule_rec.attribute6 := p_old_RepSchedule_rec.attribute6;
77: END IF;
78:
79: IF p_old_RepSchedule_rec.attribute7 <> FND_API.G_MISS_CHAR THEN
75: IF p_old_RepSchedule_rec.attribute6 <> FND_API.G_MISS_CHAR THEN
76: l_RepSchedule_rec.attribute6 := p_old_RepSchedule_rec.attribute6;
77: END IF;
78:
79: IF p_old_RepSchedule_rec.attribute7 <> FND_API.G_MISS_CHAR THEN
80: l_RepSchedule_rec.attribute7 := p_old_RepSchedule_rec.attribute7;
81: END IF;
82:
83: IF p_old_RepSchedule_rec.attribute8 <> FND_API.G_MISS_CHAR THEN
79: IF p_old_RepSchedule_rec.attribute7 <> FND_API.G_MISS_CHAR THEN
80: l_RepSchedule_rec.attribute7 := p_old_RepSchedule_rec.attribute7;
81: END IF;
82:
83: IF p_old_RepSchedule_rec.attribute8 <> FND_API.G_MISS_CHAR THEN
84: l_RepSchedule_rec.attribute8 := p_old_RepSchedule_rec.attribute8;
85: END IF;
86:
87: IF p_old_RepSchedule_rec.attribute9 <> FND_API.G_MISS_CHAR THEN
83: IF p_old_RepSchedule_rec.attribute8 <> FND_API.G_MISS_CHAR THEN
84: l_RepSchedule_rec.attribute8 := p_old_RepSchedule_rec.attribute8;
85: END IF;
86:
87: IF p_old_RepSchedule_rec.attribute9 <> FND_API.G_MISS_CHAR THEN
88: l_RepSchedule_rec.attribute9 := p_old_RepSchedule_rec.attribute9;
89: END IF;
90:
91: IF p_old_RepSchedule_rec.attribute_category <> FND_API.G_MISS_CHAR THEN
87: IF p_old_RepSchedule_rec.attribute9 <> FND_API.G_MISS_CHAR THEN
88: l_RepSchedule_rec.attribute9 := p_old_RepSchedule_rec.attribute9;
89: END IF;
90:
91: IF p_old_RepSchedule_rec.attribute_category <> FND_API.G_MISS_CHAR THEN
92: l_RepSchedule_rec.attribute_category := p_old_RepSchedule_rec.attribute_category;
93: END IF;
94:
95: IF p_old_RepSchedule_rec.bom_revision <> FND_API.G_MISS_CHAR THEN
91: IF p_old_RepSchedule_rec.attribute_category <> FND_API.G_MISS_CHAR THEN
92: l_RepSchedule_rec.attribute_category := p_old_RepSchedule_rec.attribute_category;
93: END IF;
94:
95: IF p_old_RepSchedule_rec.bom_revision <> FND_API.G_MISS_CHAR THEN
96: l_RepSchedule_rec.bom_revision := p_old_RepSchedule_rec.bom_revision;
97: END IF;
98:
99: IF p_old_RepSchedule_rec.bom_revision_date <> FND_API.G_MISS_DATE THEN
95: IF p_old_RepSchedule_rec.bom_revision <> FND_API.G_MISS_CHAR THEN
96: l_RepSchedule_rec.bom_revision := p_old_RepSchedule_rec.bom_revision;
97: END IF;
98:
99: IF p_old_RepSchedule_rec.bom_revision_date <> FND_API.G_MISS_DATE THEN
100: l_RepSchedule_rec.bom_revision_date := p_old_RepSchedule_rec.bom_revision_date;
101: END IF;
102:
103: IF p_old_RepSchedule_rec.common_bom_sequence_id <> FND_API.G_MISS_NUM THEN
99: IF p_old_RepSchedule_rec.bom_revision_date <> FND_API.G_MISS_DATE THEN
100: l_RepSchedule_rec.bom_revision_date := p_old_RepSchedule_rec.bom_revision_date;
101: END IF;
102:
103: IF p_old_RepSchedule_rec.common_bom_sequence_id <> FND_API.G_MISS_NUM THEN
104: l_RepSchedule_rec.common_bom_sequence_id := p_old_RepSchedule_rec.common_bom_sequence_id;
105: END IF;
106:
107: IF p_old_RepSchedule_rec.common_rout_sequence_id <> FND_API.G_MISS_NUM THEN
103: IF p_old_RepSchedule_rec.common_bom_sequence_id <> FND_API.G_MISS_NUM THEN
104: l_RepSchedule_rec.common_bom_sequence_id := p_old_RepSchedule_rec.common_bom_sequence_id;
105: END IF;
106:
107: IF p_old_RepSchedule_rec.common_rout_sequence_id <> FND_API.G_MISS_NUM THEN
108: l_RepSchedule_rec.common_rout_sequence_id := p_old_RepSchedule_rec.common_rout_sequence_id;
109: END IF;
110:
111: IF p_old_RepSchedule_rec.created_by <> FND_API.G_MISS_NUM THEN
107: IF p_old_RepSchedule_rec.common_rout_sequence_id <> FND_API.G_MISS_NUM THEN
108: l_RepSchedule_rec.common_rout_sequence_id := p_old_RepSchedule_rec.common_rout_sequence_id;
109: END IF;
110:
111: IF p_old_RepSchedule_rec.created_by <> FND_API.G_MISS_NUM THEN
112: l_RepSchedule_rec.created_by := p_old_RepSchedule_rec.created_by;
113: END IF;
114:
115: IF p_old_RepSchedule_rec.creation_date <> FND_API.G_MISS_DATE THEN
111: IF p_old_RepSchedule_rec.created_by <> FND_API.G_MISS_NUM THEN
112: l_RepSchedule_rec.created_by := p_old_RepSchedule_rec.created_by;
113: END IF;
114:
115: IF p_old_RepSchedule_rec.creation_date <> FND_API.G_MISS_DATE THEN
116: l_RepSchedule_rec.creation_date := p_old_RepSchedule_rec.creation_date;
117: END IF;
118:
119: IF p_old_RepSchedule_rec.daily_production_rate <> FND_API.G_MISS_NUM THEN
115: IF p_old_RepSchedule_rec.creation_date <> FND_API.G_MISS_DATE THEN
116: l_RepSchedule_rec.creation_date := p_old_RepSchedule_rec.creation_date;
117: END IF;
118:
119: IF p_old_RepSchedule_rec.daily_production_rate <> FND_API.G_MISS_NUM THEN
120: l_RepSchedule_rec.daily_production_rate := p_old_RepSchedule_rec.daily_production_rate;
121: END IF;
122:
123: IF p_old_RepSchedule_rec.date_closed <> FND_API.G_MISS_DATE THEN
119: IF p_old_RepSchedule_rec.daily_production_rate <> FND_API.G_MISS_NUM THEN
120: l_RepSchedule_rec.daily_production_rate := p_old_RepSchedule_rec.daily_production_rate;
121: END IF;
122:
123: IF p_old_RepSchedule_rec.date_closed <> FND_API.G_MISS_DATE THEN
124: l_RepSchedule_rec.date_closed := p_old_RepSchedule_rec.date_closed;
125: END IF;
126:
127: IF p_old_RepSchedule_rec.date_released <> FND_API.G_MISS_DATE THEN
123: IF p_old_RepSchedule_rec.date_closed <> FND_API.G_MISS_DATE THEN
124: l_RepSchedule_rec.date_closed := p_old_RepSchedule_rec.date_closed;
125: END IF;
126:
127: IF p_old_RepSchedule_rec.date_released <> FND_API.G_MISS_DATE THEN
128: l_RepSchedule_rec.date_released := p_old_RepSchedule_rec.date_released;
129: END IF;
130:
131: IF p_old_RepSchedule_rec.demand_class <> FND_API.G_MISS_CHAR THEN
127: IF p_old_RepSchedule_rec.date_released <> FND_API.G_MISS_DATE THEN
128: l_RepSchedule_rec.date_released := p_old_RepSchedule_rec.date_released;
129: END IF;
130:
131: IF p_old_RepSchedule_rec.demand_class <> FND_API.G_MISS_CHAR THEN
132: l_RepSchedule_rec.demand_class := p_old_RepSchedule_rec.demand_class;
133: END IF;
134:
135: IF p_old_RepSchedule_rec.description <> FND_API.G_MISS_CHAR THEN
131: IF p_old_RepSchedule_rec.demand_class <> FND_API.G_MISS_CHAR THEN
132: l_RepSchedule_rec.demand_class := p_old_RepSchedule_rec.demand_class;
133: END IF;
134:
135: IF p_old_RepSchedule_rec.description <> FND_API.G_MISS_CHAR THEN
136: l_RepSchedule_rec.description := p_old_RepSchedule_rec.description;
137: END IF;
138:
139: IF p_old_RepSchedule_rec.firm_planned_flag <> FND_API.G_MISS_NUM THEN
135: IF p_old_RepSchedule_rec.description <> FND_API.G_MISS_CHAR THEN
136: l_RepSchedule_rec.description := p_old_RepSchedule_rec.description;
137: END IF;
138:
139: IF p_old_RepSchedule_rec.firm_planned_flag <> FND_API.G_MISS_NUM THEN
140: l_RepSchedule_rec.firm_planned_flag := p_old_RepSchedule_rec.firm_planned_flag;
141: END IF;
142:
143: IF p_old_RepSchedule_rec.first_unit_cpl_date <> FND_API.G_MISS_DATE THEN
139: IF p_old_RepSchedule_rec.firm_planned_flag <> FND_API.G_MISS_NUM THEN
140: l_RepSchedule_rec.firm_planned_flag := p_old_RepSchedule_rec.firm_planned_flag;
141: END IF;
142:
143: IF p_old_RepSchedule_rec.first_unit_cpl_date <> FND_API.G_MISS_DATE THEN
144: l_RepSchedule_rec.first_unit_cpl_date := p_old_RepSchedule_rec.first_unit_cpl_date;
145: END IF;
146:
147: IF p_old_RepSchedule_rec.first_unit_start_date <> FND_API.G_MISS_DATE THEN
143: IF p_old_RepSchedule_rec.first_unit_cpl_date <> FND_API.G_MISS_DATE THEN
144: l_RepSchedule_rec.first_unit_cpl_date := p_old_RepSchedule_rec.first_unit_cpl_date;
145: END IF;
146:
147: IF p_old_RepSchedule_rec.first_unit_start_date <> FND_API.G_MISS_DATE THEN
148: l_RepSchedule_rec.first_unit_start_date := p_old_RepSchedule_rec.first_unit_start_date;
149: END IF;
150:
151: IF p_old_RepSchedule_rec.last_unit_cpl_date <> FND_API.G_MISS_DATE THEN
147: IF p_old_RepSchedule_rec.first_unit_start_date <> FND_API.G_MISS_DATE THEN
148: l_RepSchedule_rec.first_unit_start_date := p_old_RepSchedule_rec.first_unit_start_date;
149: END IF;
150:
151: IF p_old_RepSchedule_rec.last_unit_cpl_date <> FND_API.G_MISS_DATE THEN
152: l_RepSchedule_rec.last_unit_cpl_date := p_old_RepSchedule_rec.last_unit_cpl_date;
153: END IF;
154:
155: IF p_old_RepSchedule_rec.last_unit_start_date <> FND_API.G_MISS_DATE THEN
151: IF p_old_RepSchedule_rec.last_unit_cpl_date <> FND_API.G_MISS_DATE THEN
152: l_RepSchedule_rec.last_unit_cpl_date := p_old_RepSchedule_rec.last_unit_cpl_date;
153: END IF;
154:
155: IF p_old_RepSchedule_rec.last_unit_start_date <> FND_API.G_MISS_DATE THEN
156: l_RepSchedule_rec.last_unit_start_date := p_old_RepSchedule_rec.last_unit_start_date;
157: END IF;
158:
159: IF p_old_RepSchedule_rec.last_updated_by <> FND_API.G_MISS_NUM THEN
155: IF p_old_RepSchedule_rec.last_unit_start_date <> FND_API.G_MISS_DATE THEN
156: l_RepSchedule_rec.last_unit_start_date := p_old_RepSchedule_rec.last_unit_start_date;
157: END IF;
158:
159: IF p_old_RepSchedule_rec.last_updated_by <> FND_API.G_MISS_NUM THEN
160: l_RepSchedule_rec.last_updated_by := p_old_RepSchedule_rec.last_updated_by;
161: END IF;
162:
163: IF p_old_RepSchedule_rec.last_update_date <> FND_API.G_MISS_DATE THEN
159: IF p_old_RepSchedule_rec.last_updated_by <> FND_API.G_MISS_NUM THEN
160: l_RepSchedule_rec.last_updated_by := p_old_RepSchedule_rec.last_updated_by;
161: END IF;
162:
163: IF p_old_RepSchedule_rec.last_update_date <> FND_API.G_MISS_DATE THEN
164: l_RepSchedule_rec.last_update_date := p_old_RepSchedule_rec.last_update_date;
165: END IF;
166:
167: IF p_old_RepSchedule_rec.last_update_login <> FND_API.G_MISS_NUM THEN
163: IF p_old_RepSchedule_rec.last_update_date <> FND_API.G_MISS_DATE THEN
164: l_RepSchedule_rec.last_update_date := p_old_RepSchedule_rec.last_update_date;
165: END IF;
166:
167: IF p_old_RepSchedule_rec.last_update_login <> FND_API.G_MISS_NUM THEN
168: l_RepSchedule_rec.last_update_login := p_old_RepSchedule_rec.last_update_login;
169: END IF;
170:
171: IF p_old_RepSchedule_rec.line_id <> FND_API.G_MISS_NUM THEN
167: IF p_old_RepSchedule_rec.last_update_login <> FND_API.G_MISS_NUM THEN
168: l_RepSchedule_rec.last_update_login := p_old_RepSchedule_rec.last_update_login;
169: END IF;
170:
171: IF p_old_RepSchedule_rec.line_id <> FND_API.G_MISS_NUM THEN
172: l_RepSchedule_rec.line_id := p_old_RepSchedule_rec.line_id;
173: END IF;
174:
175: IF p_old_RepSchedule_rec.material_account <> FND_API.G_MISS_NUM THEN
171: IF p_old_RepSchedule_rec.line_id <> FND_API.G_MISS_NUM THEN
172: l_RepSchedule_rec.line_id := p_old_RepSchedule_rec.line_id;
173: END IF;
174:
175: IF p_old_RepSchedule_rec.material_account <> FND_API.G_MISS_NUM THEN
176: l_RepSchedule_rec.material_account := p_old_RepSchedule_rec.material_account;
177: END IF;
178:
179: IF p_old_RepSchedule_rec.material_overhead_account <> FND_API.G_MISS_NUM THEN
175: IF p_old_RepSchedule_rec.material_account <> FND_API.G_MISS_NUM THEN
176: l_RepSchedule_rec.material_account := p_old_RepSchedule_rec.material_account;
177: END IF;
178:
179: IF p_old_RepSchedule_rec.material_overhead_account <> FND_API.G_MISS_NUM THEN
180: l_RepSchedule_rec.material_overhead_account := p_old_RepSchedule_rec.material_overhead_account;
181: END IF;
182:
183: IF p_old_RepSchedule_rec.material_variance_account <> FND_API.G_MISS_NUM THEN
179: IF p_old_RepSchedule_rec.material_overhead_account <> FND_API.G_MISS_NUM THEN
180: l_RepSchedule_rec.material_overhead_account := p_old_RepSchedule_rec.material_overhead_account;
181: END IF;
182:
183: IF p_old_RepSchedule_rec.material_variance_account <> FND_API.G_MISS_NUM THEN
184: l_RepSchedule_rec.material_variance_account := p_old_RepSchedule_rec.material_variance_account;
185: END IF;
186:
187: IF p_old_RepSchedule_rec.organization_id <> FND_API.G_MISS_NUM THEN
183: IF p_old_RepSchedule_rec.material_variance_account <> FND_API.G_MISS_NUM THEN
184: l_RepSchedule_rec.material_variance_account := p_old_RepSchedule_rec.material_variance_account;
185: END IF;
186:
187: IF p_old_RepSchedule_rec.organization_id <> FND_API.G_MISS_NUM THEN
188: l_RepSchedule_rec.organization_id := p_old_RepSchedule_rec.organization_id;
189: END IF;
190:
191: IF p_old_RepSchedule_rec.osp_account <> FND_API.G_MISS_NUM THEN
187: IF p_old_RepSchedule_rec.organization_id <> FND_API.G_MISS_NUM THEN
188: l_RepSchedule_rec.organization_id := p_old_RepSchedule_rec.organization_id;
189: END IF;
190:
191: IF p_old_RepSchedule_rec.osp_account <> FND_API.G_MISS_NUM THEN
192: l_RepSchedule_rec.osp_account := p_old_RepSchedule_rec.osp_account;
193: END IF;
194:
195: IF p_old_RepSchedule_rec.osp_variance_account <> FND_API.G_MISS_NUM THEN
191: IF p_old_RepSchedule_rec.osp_account <> FND_API.G_MISS_NUM THEN
192: l_RepSchedule_rec.osp_account := p_old_RepSchedule_rec.osp_account;
193: END IF;
194:
195: IF p_old_RepSchedule_rec.osp_variance_account <> FND_API.G_MISS_NUM THEN
196: l_RepSchedule_rec.osp_variance_account := p_old_RepSchedule_rec.osp_variance_account;
197: END IF;
198:
199: IF p_old_RepSchedule_rec.overhead_account <> FND_API.G_MISS_NUM THEN
195: IF p_old_RepSchedule_rec.osp_variance_account <> FND_API.G_MISS_NUM THEN
196: l_RepSchedule_rec.osp_variance_account := p_old_RepSchedule_rec.osp_variance_account;
197: END IF;
198:
199: IF p_old_RepSchedule_rec.overhead_account <> FND_API.G_MISS_NUM THEN
200: l_RepSchedule_rec.overhead_account := p_old_RepSchedule_rec.overhead_account;
201: END IF;
202:
203: IF p_old_RepSchedule_rec.overhead_variance_account <> FND_API.G_MISS_NUM THEN
199: IF p_old_RepSchedule_rec.overhead_account <> FND_API.G_MISS_NUM THEN
200: l_RepSchedule_rec.overhead_account := p_old_RepSchedule_rec.overhead_account;
201: END IF;
202:
203: IF p_old_RepSchedule_rec.overhead_variance_account <> FND_API.G_MISS_NUM THEN
204: l_RepSchedule_rec.overhead_variance_account := p_old_RepSchedule_rec.overhead_variance_account;
205: END IF;
206:
207: IF p_old_RepSchedule_rec.processing_work_days <> FND_API.G_MISS_NUM THEN
203: IF p_old_RepSchedule_rec.overhead_variance_account <> FND_API.G_MISS_NUM THEN
204: l_RepSchedule_rec.overhead_variance_account := p_old_RepSchedule_rec.overhead_variance_account;
205: END IF;
206:
207: IF p_old_RepSchedule_rec.processing_work_days <> FND_API.G_MISS_NUM THEN
208: l_RepSchedule_rec.processing_work_days := p_old_RepSchedule_rec.processing_work_days;
209: END IF;
210:
211: IF p_old_RepSchedule_rec.program_application_id <> FND_API.G_MISS_NUM THEN
207: IF p_old_RepSchedule_rec.processing_work_days <> FND_API.G_MISS_NUM THEN
208: l_RepSchedule_rec.processing_work_days := p_old_RepSchedule_rec.processing_work_days;
209: END IF;
210:
211: IF p_old_RepSchedule_rec.program_application_id <> FND_API.G_MISS_NUM THEN
212: l_RepSchedule_rec.program_application_id := p_old_RepSchedule_rec.program_application_id;
213: END IF;
214:
215: IF p_old_RepSchedule_rec.program_id <> FND_API.G_MISS_NUM THEN
211: IF p_old_RepSchedule_rec.program_application_id <> FND_API.G_MISS_NUM THEN
212: l_RepSchedule_rec.program_application_id := p_old_RepSchedule_rec.program_application_id;
213: END IF;
214:
215: IF p_old_RepSchedule_rec.program_id <> FND_API.G_MISS_NUM THEN
216: l_RepSchedule_rec.program_id := p_old_RepSchedule_rec.program_id;
217: END IF;
218:
219: IF p_old_RepSchedule_rec.program_update_date <> FND_API.G_MISS_DATE THEN
215: IF p_old_RepSchedule_rec.program_id <> FND_API.G_MISS_NUM THEN
216: l_RepSchedule_rec.program_id := p_old_RepSchedule_rec.program_id;
217: END IF;
218:
219: IF p_old_RepSchedule_rec.program_update_date <> FND_API.G_MISS_DATE THEN
220: l_RepSchedule_rec.program_update_date := p_old_RepSchedule_rec.program_update_date;
221: END IF;
222:
223: IF p_old_RepSchedule_rec.quantity_completed <> FND_API.G_MISS_NUM THEN
219: IF p_old_RepSchedule_rec.program_update_date <> FND_API.G_MISS_DATE THEN
220: l_RepSchedule_rec.program_update_date := p_old_RepSchedule_rec.program_update_date;
221: END IF;
222:
223: IF p_old_RepSchedule_rec.quantity_completed <> FND_API.G_MISS_NUM THEN
224: l_RepSchedule_rec.quantity_completed := p_old_RepSchedule_rec.quantity_completed;
225: END IF;
226:
227: IF p_old_RepSchedule_rec.repetitive_schedule_id <> FND_API.G_MISS_NUM THEN
223: IF p_old_RepSchedule_rec.quantity_completed <> FND_API.G_MISS_NUM THEN
224: l_RepSchedule_rec.quantity_completed := p_old_RepSchedule_rec.quantity_completed;
225: END IF;
226:
227: IF p_old_RepSchedule_rec.repetitive_schedule_id <> FND_API.G_MISS_NUM THEN
228: l_RepSchedule_rec.repetitive_schedule_id := p_old_RepSchedule_rec.repetitive_schedule_id;
229: END IF;
230:
231: IF p_old_RepSchedule_rec.request_id <> FND_API.G_MISS_NUM THEN
227: IF p_old_RepSchedule_rec.repetitive_schedule_id <> FND_API.G_MISS_NUM THEN
228: l_RepSchedule_rec.repetitive_schedule_id := p_old_RepSchedule_rec.repetitive_schedule_id;
229: END IF;
230:
231: IF p_old_RepSchedule_rec.request_id <> FND_API.G_MISS_NUM THEN
232: l_RepSchedule_rec.request_id := p_old_RepSchedule_rec.request_id;
233: END IF;
234:
235: IF p_old_RepSchedule_rec.resource_account <> FND_API.G_MISS_NUM THEN
231: IF p_old_RepSchedule_rec.request_id <> FND_API.G_MISS_NUM THEN
232: l_RepSchedule_rec.request_id := p_old_RepSchedule_rec.request_id;
233: END IF;
234:
235: IF p_old_RepSchedule_rec.resource_account <> FND_API.G_MISS_NUM THEN
236: l_RepSchedule_rec.resource_account := p_old_RepSchedule_rec.resource_account;
237: END IF;
238:
239: IF p_old_RepSchedule_rec.resource_variance_account <> FND_API.G_MISS_NUM THEN
235: IF p_old_RepSchedule_rec.resource_account <> FND_API.G_MISS_NUM THEN
236: l_RepSchedule_rec.resource_account := p_old_RepSchedule_rec.resource_account;
237: END IF;
238:
239: IF p_old_RepSchedule_rec.resource_variance_account <> FND_API.G_MISS_NUM THEN
240: l_RepSchedule_rec.resource_variance_account := p_old_RepSchedule_rec.resource_variance_account;
241: END IF;
242:
243: IF p_old_RepSchedule_rec.routing_revision <> FND_API.G_MISS_CHAR THEN
239: IF p_old_RepSchedule_rec.resource_variance_account <> FND_API.G_MISS_NUM THEN
240: l_RepSchedule_rec.resource_variance_account := p_old_RepSchedule_rec.resource_variance_account;
241: END IF;
242:
243: IF p_old_RepSchedule_rec.routing_revision <> FND_API.G_MISS_CHAR THEN
244: l_RepSchedule_rec.routing_revision := p_old_RepSchedule_rec.routing_revision;
245: END IF;
246:
247: IF p_old_RepSchedule_rec.routing_revision_date <> FND_API.G_MISS_DATE THEN
243: IF p_old_RepSchedule_rec.routing_revision <> FND_API.G_MISS_CHAR THEN
244: l_RepSchedule_rec.routing_revision := p_old_RepSchedule_rec.routing_revision;
245: END IF;
246:
247: IF p_old_RepSchedule_rec.routing_revision_date <> FND_API.G_MISS_DATE THEN
248: l_RepSchedule_rec.routing_revision_date := p_old_RepSchedule_rec.routing_revision_date;
249: END IF;
250:
251: IF p_old_RepSchedule_rec.status_type <> FND_API.G_MISS_NUM THEN
247: IF p_old_RepSchedule_rec.routing_revision_date <> FND_API.G_MISS_DATE THEN
248: l_RepSchedule_rec.routing_revision_date := p_old_RepSchedule_rec.routing_revision_date;
249: END IF;
250:
251: IF p_old_RepSchedule_rec.status_type <> FND_API.G_MISS_NUM THEN
252: l_RepSchedule_rec.status_type := p_old_RepSchedule_rec.status_type;
253: END IF;
254:
255: IF p_old_RepSchedule_rec.wip_entity_id <> FND_API.G_MISS_NUM THEN
251: IF p_old_RepSchedule_rec.status_type <> FND_API.G_MISS_NUM THEN
252: l_RepSchedule_rec.status_type := p_old_RepSchedule_rec.status_type;
253: END IF;
254:
255: IF p_old_RepSchedule_rec.wip_entity_id <> FND_API.G_MISS_NUM THEN
256: l_RepSchedule_rec.wip_entity_id := p_old_RepSchedule_rec.wip_entity_id;
257: END IF;
258:
259: IF p_old_RepSchedule_rec.kanban_card_id <> FND_API.G_MISS_NUM THEN
255: IF p_old_RepSchedule_rec.wip_entity_id <> FND_API.G_MISS_NUM THEN
256: l_RepSchedule_rec.wip_entity_id := p_old_RepSchedule_rec.wip_entity_id;
257: END IF;
258:
259: IF p_old_RepSchedule_rec.kanban_card_id <> FND_API.G_MISS_NUM THEN
260: l_RepSchedule_rec.kanban_card_id := p_old_RepSchedule_rec.kanban_card_id;
261: END IF;
262:
263: ELSE
261: END IF;
262:
263: ELSE
264:
265: IF l_RepSchedule_rec.alternate_bom_designator = FND_API.G_MISS_CHAR THEN
266: l_RepSchedule_rec.alternate_bom_designator := p_old_RepSchedule_rec.alternate_bom_designator;
267: END IF;
268:
269: IF l_RepSchedule_rec.alternate_rout_designator = FND_API.G_MISS_CHAR THEN
265: IF l_RepSchedule_rec.alternate_bom_designator = FND_API.G_MISS_CHAR THEN
266: l_RepSchedule_rec.alternate_bom_designator := p_old_RepSchedule_rec.alternate_bom_designator;
267: END IF;
268:
269: IF l_RepSchedule_rec.alternate_rout_designator = FND_API.G_MISS_CHAR THEN
270: l_RepSchedule_rec.alternate_rout_designator := p_old_RepSchedule_rec.alternate_rout_designator;
271: END IF;
272:
273: IF l_RepSchedule_rec.attribute1 = FND_API.G_MISS_CHAR THEN
269: IF l_RepSchedule_rec.alternate_rout_designator = FND_API.G_MISS_CHAR THEN
270: l_RepSchedule_rec.alternate_rout_designator := p_old_RepSchedule_rec.alternate_rout_designator;
271: END IF;
272:
273: IF l_RepSchedule_rec.attribute1 = FND_API.G_MISS_CHAR THEN
274: l_RepSchedule_rec.attribute1 := p_old_RepSchedule_rec.attribute1;
275: END IF;
276:
277: IF l_RepSchedule_rec.attribute10 = FND_API.G_MISS_CHAR THEN
273: IF l_RepSchedule_rec.attribute1 = FND_API.G_MISS_CHAR THEN
274: l_RepSchedule_rec.attribute1 := p_old_RepSchedule_rec.attribute1;
275: END IF;
276:
277: IF l_RepSchedule_rec.attribute10 = FND_API.G_MISS_CHAR THEN
278: l_RepSchedule_rec.attribute10 := p_old_RepSchedule_rec.attribute10;
279: END IF;
280:
281: IF l_RepSchedule_rec.attribute11 = FND_API.G_MISS_CHAR THEN
277: IF l_RepSchedule_rec.attribute10 = FND_API.G_MISS_CHAR THEN
278: l_RepSchedule_rec.attribute10 := p_old_RepSchedule_rec.attribute10;
279: END IF;
280:
281: IF l_RepSchedule_rec.attribute11 = FND_API.G_MISS_CHAR THEN
282: l_RepSchedule_rec.attribute11 := p_old_RepSchedule_rec.attribute11;
283: END IF;
284:
285: IF l_RepSchedule_rec.attribute12 = FND_API.G_MISS_CHAR THEN
281: IF l_RepSchedule_rec.attribute11 = FND_API.G_MISS_CHAR THEN
282: l_RepSchedule_rec.attribute11 := p_old_RepSchedule_rec.attribute11;
283: END IF;
284:
285: IF l_RepSchedule_rec.attribute12 = FND_API.G_MISS_CHAR THEN
286: l_RepSchedule_rec.attribute12 := p_old_RepSchedule_rec.attribute12;
287: END IF;
288:
289: IF l_RepSchedule_rec.attribute13 = FND_API.G_MISS_CHAR THEN
285: IF l_RepSchedule_rec.attribute12 = FND_API.G_MISS_CHAR THEN
286: l_RepSchedule_rec.attribute12 := p_old_RepSchedule_rec.attribute12;
287: END IF;
288:
289: IF l_RepSchedule_rec.attribute13 = FND_API.G_MISS_CHAR THEN
290: l_RepSchedule_rec.attribute13 := p_old_RepSchedule_rec.attribute13;
291: END IF;
292:
293: IF l_RepSchedule_rec.attribute14 = FND_API.G_MISS_CHAR THEN
289: IF l_RepSchedule_rec.attribute13 = FND_API.G_MISS_CHAR THEN
290: l_RepSchedule_rec.attribute13 := p_old_RepSchedule_rec.attribute13;
291: END IF;
292:
293: IF l_RepSchedule_rec.attribute14 = FND_API.G_MISS_CHAR THEN
294: l_RepSchedule_rec.attribute14 := p_old_RepSchedule_rec.attribute14;
295: END IF;
296:
297: IF l_RepSchedule_rec.attribute15 = FND_API.G_MISS_CHAR THEN
293: IF l_RepSchedule_rec.attribute14 = FND_API.G_MISS_CHAR THEN
294: l_RepSchedule_rec.attribute14 := p_old_RepSchedule_rec.attribute14;
295: END IF;
296:
297: IF l_RepSchedule_rec.attribute15 = FND_API.G_MISS_CHAR THEN
298: l_RepSchedule_rec.attribute15 := p_old_RepSchedule_rec.attribute15;
299: END IF;
300:
301: IF l_RepSchedule_rec.attribute2 = FND_API.G_MISS_CHAR THEN
297: IF l_RepSchedule_rec.attribute15 = FND_API.G_MISS_CHAR THEN
298: l_RepSchedule_rec.attribute15 := p_old_RepSchedule_rec.attribute15;
299: END IF;
300:
301: IF l_RepSchedule_rec.attribute2 = FND_API.G_MISS_CHAR THEN
302: l_RepSchedule_rec.attribute2 := p_old_RepSchedule_rec.attribute2;
303: END IF;
304:
305: IF l_RepSchedule_rec.attribute3 = FND_API.G_MISS_CHAR THEN
301: IF l_RepSchedule_rec.attribute2 = FND_API.G_MISS_CHAR THEN
302: l_RepSchedule_rec.attribute2 := p_old_RepSchedule_rec.attribute2;
303: END IF;
304:
305: IF l_RepSchedule_rec.attribute3 = FND_API.G_MISS_CHAR THEN
306: l_RepSchedule_rec.attribute3 := p_old_RepSchedule_rec.attribute3;
307: END IF;
308:
309: IF l_RepSchedule_rec.attribute4 = FND_API.G_MISS_CHAR THEN
305: IF l_RepSchedule_rec.attribute3 = FND_API.G_MISS_CHAR THEN
306: l_RepSchedule_rec.attribute3 := p_old_RepSchedule_rec.attribute3;
307: END IF;
308:
309: IF l_RepSchedule_rec.attribute4 = FND_API.G_MISS_CHAR THEN
310: l_RepSchedule_rec.attribute4 := p_old_RepSchedule_rec.attribute4;
311: END IF;
312:
313: IF l_RepSchedule_rec.attribute5 = FND_API.G_MISS_CHAR THEN
309: IF l_RepSchedule_rec.attribute4 = FND_API.G_MISS_CHAR THEN
310: l_RepSchedule_rec.attribute4 := p_old_RepSchedule_rec.attribute4;
311: END IF;
312:
313: IF l_RepSchedule_rec.attribute5 = FND_API.G_MISS_CHAR THEN
314: l_RepSchedule_rec.attribute5 := p_old_RepSchedule_rec.attribute5;
315: END IF;
316:
317: IF l_RepSchedule_rec.attribute6 = FND_API.G_MISS_CHAR THEN
313: IF l_RepSchedule_rec.attribute5 = FND_API.G_MISS_CHAR THEN
314: l_RepSchedule_rec.attribute5 := p_old_RepSchedule_rec.attribute5;
315: END IF;
316:
317: IF l_RepSchedule_rec.attribute6 = FND_API.G_MISS_CHAR THEN
318: l_RepSchedule_rec.attribute6 := p_old_RepSchedule_rec.attribute6;
319: END IF;
320:
321: IF l_RepSchedule_rec.attribute7 = FND_API.G_MISS_CHAR THEN
317: IF l_RepSchedule_rec.attribute6 = FND_API.G_MISS_CHAR THEN
318: l_RepSchedule_rec.attribute6 := p_old_RepSchedule_rec.attribute6;
319: END IF;
320:
321: IF l_RepSchedule_rec.attribute7 = FND_API.G_MISS_CHAR THEN
322: l_RepSchedule_rec.attribute7 := p_old_RepSchedule_rec.attribute7;
323: END IF;
324:
325: IF l_RepSchedule_rec.attribute8 = FND_API.G_MISS_CHAR THEN
321: IF l_RepSchedule_rec.attribute7 = FND_API.G_MISS_CHAR THEN
322: l_RepSchedule_rec.attribute7 := p_old_RepSchedule_rec.attribute7;
323: END IF;
324:
325: IF l_RepSchedule_rec.attribute8 = FND_API.G_MISS_CHAR THEN
326: l_RepSchedule_rec.attribute8 := p_old_RepSchedule_rec.attribute8;
327: END IF;
328:
329: IF l_RepSchedule_rec.attribute9 = FND_API.G_MISS_CHAR THEN
325: IF l_RepSchedule_rec.attribute8 = FND_API.G_MISS_CHAR THEN
326: l_RepSchedule_rec.attribute8 := p_old_RepSchedule_rec.attribute8;
327: END IF;
328:
329: IF l_RepSchedule_rec.attribute9 = FND_API.G_MISS_CHAR THEN
330: l_RepSchedule_rec.attribute9 := p_old_RepSchedule_rec.attribute9;
331: END IF;
332:
333: IF l_RepSchedule_rec.attribute_category = FND_API.G_MISS_CHAR THEN
329: IF l_RepSchedule_rec.attribute9 = FND_API.G_MISS_CHAR THEN
330: l_RepSchedule_rec.attribute9 := p_old_RepSchedule_rec.attribute9;
331: END IF;
332:
333: IF l_RepSchedule_rec.attribute_category = FND_API.G_MISS_CHAR THEN
334: l_RepSchedule_rec.attribute_category := p_old_RepSchedule_rec.attribute_category;
335: END IF;
336:
337: IF l_RepSchedule_rec.bom_revision = FND_API.G_MISS_CHAR THEN
333: IF l_RepSchedule_rec.attribute_category = FND_API.G_MISS_CHAR THEN
334: l_RepSchedule_rec.attribute_category := p_old_RepSchedule_rec.attribute_category;
335: END IF;
336:
337: IF l_RepSchedule_rec.bom_revision = FND_API.G_MISS_CHAR THEN
338: l_RepSchedule_rec.bom_revision := p_old_RepSchedule_rec.bom_revision;
339: END IF;
340:
341: IF l_RepSchedule_rec.bom_revision_date = FND_API.G_MISS_DATE THEN
337: IF l_RepSchedule_rec.bom_revision = FND_API.G_MISS_CHAR THEN
338: l_RepSchedule_rec.bom_revision := p_old_RepSchedule_rec.bom_revision;
339: END IF;
340:
341: IF l_RepSchedule_rec.bom_revision_date = FND_API.G_MISS_DATE THEN
342: l_RepSchedule_rec.bom_revision_date := p_old_RepSchedule_rec.bom_revision_date;
343: END IF;
344:
345: IF l_RepSchedule_rec.common_bom_sequence_id = FND_API.G_MISS_NUM THEN
341: IF l_RepSchedule_rec.bom_revision_date = FND_API.G_MISS_DATE THEN
342: l_RepSchedule_rec.bom_revision_date := p_old_RepSchedule_rec.bom_revision_date;
343: END IF;
344:
345: IF l_RepSchedule_rec.common_bom_sequence_id = FND_API.G_MISS_NUM THEN
346: l_RepSchedule_rec.common_bom_sequence_id := p_old_RepSchedule_rec.common_bom_sequence_id;
347: END IF;
348:
349: IF l_RepSchedule_rec.common_rout_sequence_id = FND_API.G_MISS_NUM THEN
345: IF l_RepSchedule_rec.common_bom_sequence_id = FND_API.G_MISS_NUM THEN
346: l_RepSchedule_rec.common_bom_sequence_id := p_old_RepSchedule_rec.common_bom_sequence_id;
347: END IF;
348:
349: IF l_RepSchedule_rec.common_rout_sequence_id = FND_API.G_MISS_NUM THEN
350: l_RepSchedule_rec.common_rout_sequence_id := p_old_RepSchedule_rec.common_rout_sequence_id;
351: END IF;
352:
353: IF l_RepSchedule_rec.created_by = FND_API.G_MISS_NUM THEN
349: IF l_RepSchedule_rec.common_rout_sequence_id = FND_API.G_MISS_NUM THEN
350: l_RepSchedule_rec.common_rout_sequence_id := p_old_RepSchedule_rec.common_rout_sequence_id;
351: END IF;
352:
353: IF l_RepSchedule_rec.created_by = FND_API.G_MISS_NUM THEN
354: l_RepSchedule_rec.created_by := p_old_RepSchedule_rec.created_by;
355: END IF;
356:
357: IF l_RepSchedule_rec.creation_date = FND_API.G_MISS_DATE THEN
353: IF l_RepSchedule_rec.created_by = FND_API.G_MISS_NUM THEN
354: l_RepSchedule_rec.created_by := p_old_RepSchedule_rec.created_by;
355: END IF;
356:
357: IF l_RepSchedule_rec.creation_date = FND_API.G_MISS_DATE THEN
358: l_RepSchedule_rec.creation_date := p_old_RepSchedule_rec.creation_date;
359: END IF;
360:
361: IF l_RepSchedule_rec.daily_production_rate = FND_API.G_MISS_NUM THEN
357: IF l_RepSchedule_rec.creation_date = FND_API.G_MISS_DATE THEN
358: l_RepSchedule_rec.creation_date := p_old_RepSchedule_rec.creation_date;
359: END IF;
360:
361: IF l_RepSchedule_rec.daily_production_rate = FND_API.G_MISS_NUM THEN
362: l_RepSchedule_rec.daily_production_rate := p_old_RepSchedule_rec.daily_production_rate;
363: END IF;
364:
365: IF l_RepSchedule_rec.date_closed = FND_API.G_MISS_DATE THEN
361: IF l_RepSchedule_rec.daily_production_rate = FND_API.G_MISS_NUM THEN
362: l_RepSchedule_rec.daily_production_rate := p_old_RepSchedule_rec.daily_production_rate;
363: END IF;
364:
365: IF l_RepSchedule_rec.date_closed = FND_API.G_MISS_DATE THEN
366: l_RepSchedule_rec.date_closed := p_old_RepSchedule_rec.date_closed;
367: END IF;
368:
369: IF l_RepSchedule_rec.date_released = FND_API.G_MISS_DATE THEN
365: IF l_RepSchedule_rec.date_closed = FND_API.G_MISS_DATE THEN
366: l_RepSchedule_rec.date_closed := p_old_RepSchedule_rec.date_closed;
367: END IF;
368:
369: IF l_RepSchedule_rec.date_released = FND_API.G_MISS_DATE THEN
370: l_RepSchedule_rec.date_released := p_old_RepSchedule_rec.date_released;
371: END IF;
372:
373: IF l_RepSchedule_rec.demand_class = FND_API.G_MISS_CHAR THEN
369: IF l_RepSchedule_rec.date_released = FND_API.G_MISS_DATE THEN
370: l_RepSchedule_rec.date_released := p_old_RepSchedule_rec.date_released;
371: END IF;
372:
373: IF l_RepSchedule_rec.demand_class = FND_API.G_MISS_CHAR THEN
374: l_RepSchedule_rec.demand_class := p_old_RepSchedule_rec.demand_class;
375: END IF;
376:
377: IF l_RepSchedule_rec.description = FND_API.G_MISS_CHAR THEN
373: IF l_RepSchedule_rec.demand_class = FND_API.G_MISS_CHAR THEN
374: l_RepSchedule_rec.demand_class := p_old_RepSchedule_rec.demand_class;
375: END IF;
376:
377: IF l_RepSchedule_rec.description = FND_API.G_MISS_CHAR THEN
378: l_RepSchedule_rec.description := p_old_RepSchedule_rec.description;
379: END IF;
380:
381: IF l_RepSchedule_rec.firm_planned_flag = FND_API.G_MISS_NUM THEN
377: IF l_RepSchedule_rec.description = FND_API.G_MISS_CHAR THEN
378: l_RepSchedule_rec.description := p_old_RepSchedule_rec.description;
379: END IF;
380:
381: IF l_RepSchedule_rec.firm_planned_flag = FND_API.G_MISS_NUM THEN
382: l_RepSchedule_rec.firm_planned_flag := p_old_RepSchedule_rec.firm_planned_flag;
383: END IF;
384:
385: IF l_RepSchedule_rec.first_unit_cpl_date = FND_API.G_MISS_DATE THEN
381: IF l_RepSchedule_rec.firm_planned_flag = FND_API.G_MISS_NUM THEN
382: l_RepSchedule_rec.firm_planned_flag := p_old_RepSchedule_rec.firm_planned_flag;
383: END IF;
384:
385: IF l_RepSchedule_rec.first_unit_cpl_date = FND_API.G_MISS_DATE THEN
386: l_RepSchedule_rec.first_unit_cpl_date := p_old_RepSchedule_rec.first_unit_cpl_date;
387: END IF;
388:
389: IF l_RepSchedule_rec.first_unit_start_date = FND_API.G_MISS_DATE THEN
385: IF l_RepSchedule_rec.first_unit_cpl_date = FND_API.G_MISS_DATE THEN
386: l_RepSchedule_rec.first_unit_cpl_date := p_old_RepSchedule_rec.first_unit_cpl_date;
387: END IF;
388:
389: IF l_RepSchedule_rec.first_unit_start_date = FND_API.G_MISS_DATE THEN
390: l_RepSchedule_rec.first_unit_start_date := p_old_RepSchedule_rec.first_unit_start_date;
391: END IF;
392:
393: IF l_RepSchedule_rec.last_unit_cpl_date = FND_API.G_MISS_DATE THEN
389: IF l_RepSchedule_rec.first_unit_start_date = FND_API.G_MISS_DATE THEN
390: l_RepSchedule_rec.first_unit_start_date := p_old_RepSchedule_rec.first_unit_start_date;
391: END IF;
392:
393: IF l_RepSchedule_rec.last_unit_cpl_date = FND_API.G_MISS_DATE THEN
394: l_RepSchedule_rec.last_unit_cpl_date := p_old_RepSchedule_rec.last_unit_cpl_date;
395: END IF;
396:
397: IF l_RepSchedule_rec.last_unit_start_date = FND_API.G_MISS_DATE THEN
393: IF l_RepSchedule_rec.last_unit_cpl_date = FND_API.G_MISS_DATE THEN
394: l_RepSchedule_rec.last_unit_cpl_date := p_old_RepSchedule_rec.last_unit_cpl_date;
395: END IF;
396:
397: IF l_RepSchedule_rec.last_unit_start_date = FND_API.G_MISS_DATE THEN
398: l_RepSchedule_rec.last_unit_start_date := p_old_RepSchedule_rec.last_unit_start_date;
399: END IF;
400:
401: IF l_RepSchedule_rec.last_updated_by = FND_API.G_MISS_NUM THEN
397: IF l_RepSchedule_rec.last_unit_start_date = FND_API.G_MISS_DATE THEN
398: l_RepSchedule_rec.last_unit_start_date := p_old_RepSchedule_rec.last_unit_start_date;
399: END IF;
400:
401: IF l_RepSchedule_rec.last_updated_by = FND_API.G_MISS_NUM THEN
402: l_RepSchedule_rec.last_updated_by := p_old_RepSchedule_rec.last_updated_by;
403: END IF;
404:
405: IF l_RepSchedule_rec.last_update_date = FND_API.G_MISS_DATE THEN
401: IF l_RepSchedule_rec.last_updated_by = FND_API.G_MISS_NUM THEN
402: l_RepSchedule_rec.last_updated_by := p_old_RepSchedule_rec.last_updated_by;
403: END IF;
404:
405: IF l_RepSchedule_rec.last_update_date = FND_API.G_MISS_DATE THEN
406: l_RepSchedule_rec.last_update_date := p_old_RepSchedule_rec.last_update_date;
407: END IF;
408:
409: IF l_RepSchedule_rec.last_update_login = FND_API.G_MISS_NUM THEN
405: IF l_RepSchedule_rec.last_update_date = FND_API.G_MISS_DATE THEN
406: l_RepSchedule_rec.last_update_date := p_old_RepSchedule_rec.last_update_date;
407: END IF;
408:
409: IF l_RepSchedule_rec.last_update_login = FND_API.G_MISS_NUM THEN
410: l_RepSchedule_rec.last_update_login := p_old_RepSchedule_rec.last_update_login;
411: END IF;
412:
413: IF l_RepSchedule_rec.line_id = FND_API.G_MISS_NUM THEN
409: IF l_RepSchedule_rec.last_update_login = FND_API.G_MISS_NUM THEN
410: l_RepSchedule_rec.last_update_login := p_old_RepSchedule_rec.last_update_login;
411: END IF;
412:
413: IF l_RepSchedule_rec.line_id = FND_API.G_MISS_NUM THEN
414: l_RepSchedule_rec.line_id := p_old_RepSchedule_rec.line_id;
415: END IF;
416:
417: IF l_RepSchedule_rec.material_account = FND_API.G_MISS_NUM THEN
413: IF l_RepSchedule_rec.line_id = FND_API.G_MISS_NUM THEN
414: l_RepSchedule_rec.line_id := p_old_RepSchedule_rec.line_id;
415: END IF;
416:
417: IF l_RepSchedule_rec.material_account = FND_API.G_MISS_NUM THEN
418: l_RepSchedule_rec.material_account := p_old_RepSchedule_rec.material_account;
419: END IF;
420:
421: IF l_RepSchedule_rec.material_overhead_account = FND_API.G_MISS_NUM THEN
417: IF l_RepSchedule_rec.material_account = FND_API.G_MISS_NUM THEN
418: l_RepSchedule_rec.material_account := p_old_RepSchedule_rec.material_account;
419: END IF;
420:
421: IF l_RepSchedule_rec.material_overhead_account = FND_API.G_MISS_NUM THEN
422: l_RepSchedule_rec.material_overhead_account := p_old_RepSchedule_rec.material_overhead_account;
423: END IF;
424:
425: IF l_RepSchedule_rec.material_variance_account = FND_API.G_MISS_NUM THEN
421: IF l_RepSchedule_rec.material_overhead_account = FND_API.G_MISS_NUM THEN
422: l_RepSchedule_rec.material_overhead_account := p_old_RepSchedule_rec.material_overhead_account;
423: END IF;
424:
425: IF l_RepSchedule_rec.material_variance_account = FND_API.G_MISS_NUM THEN
426: l_RepSchedule_rec.material_variance_account := p_old_RepSchedule_rec.material_variance_account;
427: END IF;
428:
429: IF l_RepSchedule_rec.organization_id = FND_API.G_MISS_NUM THEN
425: IF l_RepSchedule_rec.material_variance_account = FND_API.G_MISS_NUM THEN
426: l_RepSchedule_rec.material_variance_account := p_old_RepSchedule_rec.material_variance_account;
427: END IF;
428:
429: IF l_RepSchedule_rec.organization_id = FND_API.G_MISS_NUM THEN
430: l_RepSchedule_rec.organization_id := p_old_RepSchedule_rec.organization_id;
431: END IF;
432:
433: IF l_RepSchedule_rec.osp_account = FND_API.G_MISS_NUM THEN
429: IF l_RepSchedule_rec.organization_id = FND_API.G_MISS_NUM THEN
430: l_RepSchedule_rec.organization_id := p_old_RepSchedule_rec.organization_id;
431: END IF;
432:
433: IF l_RepSchedule_rec.osp_account = FND_API.G_MISS_NUM THEN
434: l_RepSchedule_rec.osp_account := p_old_RepSchedule_rec.osp_account;
435: END IF;
436:
437: IF l_RepSchedule_rec.osp_variance_account = FND_API.G_MISS_NUM THEN
433: IF l_RepSchedule_rec.osp_account = FND_API.G_MISS_NUM THEN
434: l_RepSchedule_rec.osp_account := p_old_RepSchedule_rec.osp_account;
435: END IF;
436:
437: IF l_RepSchedule_rec.osp_variance_account = FND_API.G_MISS_NUM THEN
438: l_RepSchedule_rec.osp_variance_account := p_old_RepSchedule_rec.osp_variance_account;
439: END IF;
440:
441: IF l_RepSchedule_rec.overhead_account = FND_API.G_MISS_NUM THEN
437: IF l_RepSchedule_rec.osp_variance_account = FND_API.G_MISS_NUM THEN
438: l_RepSchedule_rec.osp_variance_account := p_old_RepSchedule_rec.osp_variance_account;
439: END IF;
440:
441: IF l_RepSchedule_rec.overhead_account = FND_API.G_MISS_NUM THEN
442: l_RepSchedule_rec.overhead_account := p_old_RepSchedule_rec.overhead_account;
443: END IF;
444:
445: IF l_RepSchedule_rec.overhead_variance_account = FND_API.G_MISS_NUM THEN
441: IF l_RepSchedule_rec.overhead_account = FND_API.G_MISS_NUM THEN
442: l_RepSchedule_rec.overhead_account := p_old_RepSchedule_rec.overhead_account;
443: END IF;
444:
445: IF l_RepSchedule_rec.overhead_variance_account = FND_API.G_MISS_NUM THEN
446: l_RepSchedule_rec.overhead_variance_account := p_old_RepSchedule_rec.overhead_variance_account;
447: END IF;
448:
449: IF l_RepSchedule_rec.processing_work_days = FND_API.G_MISS_NUM THEN
445: IF l_RepSchedule_rec.overhead_variance_account = FND_API.G_MISS_NUM THEN
446: l_RepSchedule_rec.overhead_variance_account := p_old_RepSchedule_rec.overhead_variance_account;
447: END IF;
448:
449: IF l_RepSchedule_rec.processing_work_days = FND_API.G_MISS_NUM THEN
450: l_RepSchedule_rec.processing_work_days := p_old_RepSchedule_rec.processing_work_days;
451: END IF;
452:
453: IF l_RepSchedule_rec.program_application_id = FND_API.G_MISS_NUM THEN
449: IF l_RepSchedule_rec.processing_work_days = FND_API.G_MISS_NUM THEN
450: l_RepSchedule_rec.processing_work_days := p_old_RepSchedule_rec.processing_work_days;
451: END IF;
452:
453: IF l_RepSchedule_rec.program_application_id = FND_API.G_MISS_NUM THEN
454: l_RepSchedule_rec.program_application_id := p_old_RepSchedule_rec.program_application_id;
455: END IF;
456:
457: IF l_RepSchedule_rec.program_id = FND_API.G_MISS_NUM THEN
453: IF l_RepSchedule_rec.program_application_id = FND_API.G_MISS_NUM THEN
454: l_RepSchedule_rec.program_application_id := p_old_RepSchedule_rec.program_application_id;
455: END IF;
456:
457: IF l_RepSchedule_rec.program_id = FND_API.G_MISS_NUM THEN
458: l_RepSchedule_rec.program_id := p_old_RepSchedule_rec.program_id;
459: END IF;
460:
461: IF l_RepSchedule_rec.program_update_date = FND_API.G_MISS_DATE THEN
457: IF l_RepSchedule_rec.program_id = FND_API.G_MISS_NUM THEN
458: l_RepSchedule_rec.program_id := p_old_RepSchedule_rec.program_id;
459: END IF;
460:
461: IF l_RepSchedule_rec.program_update_date = FND_API.G_MISS_DATE THEN
462: l_RepSchedule_rec.program_update_date := p_old_RepSchedule_rec.program_update_date;
463: END IF;
464:
465: IF l_RepSchedule_rec.quantity_completed = FND_API.G_MISS_NUM THEN
461: IF l_RepSchedule_rec.program_update_date = FND_API.G_MISS_DATE THEN
462: l_RepSchedule_rec.program_update_date := p_old_RepSchedule_rec.program_update_date;
463: END IF;
464:
465: IF l_RepSchedule_rec.quantity_completed = FND_API.G_MISS_NUM THEN
466: l_RepSchedule_rec.quantity_completed := p_old_RepSchedule_rec.quantity_completed;
467: END IF;
468:
469: IF l_RepSchedule_rec.repetitive_schedule_id = FND_API.G_MISS_NUM THEN
465: IF l_RepSchedule_rec.quantity_completed = FND_API.G_MISS_NUM THEN
466: l_RepSchedule_rec.quantity_completed := p_old_RepSchedule_rec.quantity_completed;
467: END IF;
468:
469: IF l_RepSchedule_rec.repetitive_schedule_id = FND_API.G_MISS_NUM THEN
470: l_RepSchedule_rec.repetitive_schedule_id := p_old_RepSchedule_rec.repetitive_schedule_id;
471: END IF;
472:
473: IF l_RepSchedule_rec.request_id = FND_API.G_MISS_NUM THEN
469: IF l_RepSchedule_rec.repetitive_schedule_id = FND_API.G_MISS_NUM THEN
470: l_RepSchedule_rec.repetitive_schedule_id := p_old_RepSchedule_rec.repetitive_schedule_id;
471: END IF;
472:
473: IF l_RepSchedule_rec.request_id = FND_API.G_MISS_NUM THEN
474: l_RepSchedule_rec.request_id := p_old_RepSchedule_rec.request_id;
475: END IF;
476:
477: IF l_RepSchedule_rec.resource_account = FND_API.G_MISS_NUM THEN
473: IF l_RepSchedule_rec.request_id = FND_API.G_MISS_NUM THEN
474: l_RepSchedule_rec.request_id := p_old_RepSchedule_rec.request_id;
475: END IF;
476:
477: IF l_RepSchedule_rec.resource_account = FND_API.G_MISS_NUM THEN
478: l_RepSchedule_rec.resource_account := p_old_RepSchedule_rec.resource_account;
479: END IF;
480:
481: IF l_RepSchedule_rec.resource_variance_account = FND_API.G_MISS_NUM THEN
477: IF l_RepSchedule_rec.resource_account = FND_API.G_MISS_NUM THEN
478: l_RepSchedule_rec.resource_account := p_old_RepSchedule_rec.resource_account;
479: END IF;
480:
481: IF l_RepSchedule_rec.resource_variance_account = FND_API.G_MISS_NUM THEN
482: l_RepSchedule_rec.resource_variance_account := p_old_RepSchedule_rec.resource_variance_account;
483: END IF;
484:
485: IF l_RepSchedule_rec.routing_revision = FND_API.G_MISS_CHAR THEN
481: IF l_RepSchedule_rec.resource_variance_account = FND_API.G_MISS_NUM THEN
482: l_RepSchedule_rec.resource_variance_account := p_old_RepSchedule_rec.resource_variance_account;
483: END IF;
484:
485: IF l_RepSchedule_rec.routing_revision = FND_API.G_MISS_CHAR THEN
486: l_RepSchedule_rec.routing_revision := p_old_RepSchedule_rec.routing_revision;
487: END IF;
488:
489: IF l_RepSchedule_rec.routing_revision_date = FND_API.G_MISS_DATE THEN
485: IF l_RepSchedule_rec.routing_revision = FND_API.G_MISS_CHAR THEN
486: l_RepSchedule_rec.routing_revision := p_old_RepSchedule_rec.routing_revision;
487: END IF;
488:
489: IF l_RepSchedule_rec.routing_revision_date = FND_API.G_MISS_DATE THEN
490: l_RepSchedule_rec.routing_revision_date := p_old_RepSchedule_rec.routing_revision_date;
491: END IF;
492:
493: IF l_RepSchedule_rec.status_type = FND_API.G_MISS_NUM THEN
489: IF l_RepSchedule_rec.routing_revision_date = FND_API.G_MISS_DATE THEN
490: l_RepSchedule_rec.routing_revision_date := p_old_RepSchedule_rec.routing_revision_date;
491: END IF;
492:
493: IF l_RepSchedule_rec.status_type = FND_API.G_MISS_NUM THEN
494: l_RepSchedule_rec.status_type := p_old_RepSchedule_rec.status_type;
495: END IF;
496:
497: IF l_RepSchedule_rec.wip_entity_id = FND_API.G_MISS_NUM THEN
493: IF l_RepSchedule_rec.status_type = FND_API.G_MISS_NUM THEN
494: l_RepSchedule_rec.status_type := p_old_RepSchedule_rec.status_type;
495: END IF;
496:
497: IF l_RepSchedule_rec.wip_entity_id = FND_API.G_MISS_NUM THEN
498: l_RepSchedule_rec.wip_entity_id := p_old_RepSchedule_rec.wip_entity_id;
499: END IF;
500:
501: IF l_RepSchedule_rec.kanban_card_id = FND_API.G_MISS_NUM THEN
497: IF l_RepSchedule_rec.wip_entity_id = FND_API.G_MISS_NUM THEN
498: l_RepSchedule_rec.wip_entity_id := p_old_RepSchedule_rec.wip_entity_id;
499: END IF;
500:
501: IF l_RepSchedule_rec.kanban_card_id = FND_API.G_MISS_NUM THEN
502: l_RepSchedule_rec.kanban_card_id := p_old_RepSchedule_rec.kanban_card_id;
503: END IF;
504: END IF;
505: END IF;
515: IS
516: l_RepSchedule_rec WIP_Work_Order_PUB.Repschedule_Rec_Type := p_RepSchedule_rec;
517: BEGIN
518:
519: IF l_RepSchedule_rec.alternate_bom_designator = FND_API.G_MISS_CHAR THEN
520: l_RepSchedule_rec.alternate_bom_designator := NULL;
521: END IF;
522:
523: IF l_RepSchedule_rec.alternate_rout_designator = FND_API.G_MISS_CHAR THEN
519: IF l_RepSchedule_rec.alternate_bom_designator = FND_API.G_MISS_CHAR THEN
520: l_RepSchedule_rec.alternate_bom_designator := NULL;
521: END IF;
522:
523: IF l_RepSchedule_rec.alternate_rout_designator = FND_API.G_MISS_CHAR THEN
524: l_RepSchedule_rec.alternate_rout_designator := NULL;
525: END IF;
526:
527: IF l_RepSchedule_rec.attribute1 = FND_API.G_MISS_CHAR THEN
523: IF l_RepSchedule_rec.alternate_rout_designator = FND_API.G_MISS_CHAR THEN
524: l_RepSchedule_rec.alternate_rout_designator := NULL;
525: END IF;
526:
527: IF l_RepSchedule_rec.attribute1 = FND_API.G_MISS_CHAR THEN
528: l_RepSchedule_rec.attribute1 := NULL;
529: END IF;
530:
531: IF l_RepSchedule_rec.attribute10 = FND_API.G_MISS_CHAR THEN
527: IF l_RepSchedule_rec.attribute1 = FND_API.G_MISS_CHAR THEN
528: l_RepSchedule_rec.attribute1 := NULL;
529: END IF;
530:
531: IF l_RepSchedule_rec.attribute10 = FND_API.G_MISS_CHAR THEN
532: l_RepSchedule_rec.attribute10 := NULL;
533: END IF;
534:
535: IF l_RepSchedule_rec.attribute11 = FND_API.G_MISS_CHAR THEN
531: IF l_RepSchedule_rec.attribute10 = FND_API.G_MISS_CHAR THEN
532: l_RepSchedule_rec.attribute10 := NULL;
533: END IF;
534:
535: IF l_RepSchedule_rec.attribute11 = FND_API.G_MISS_CHAR THEN
536: l_RepSchedule_rec.attribute11 := NULL;
537: END IF;
538:
539: IF l_RepSchedule_rec.attribute12 = FND_API.G_MISS_CHAR THEN
535: IF l_RepSchedule_rec.attribute11 = FND_API.G_MISS_CHAR THEN
536: l_RepSchedule_rec.attribute11 := NULL;
537: END IF;
538:
539: IF l_RepSchedule_rec.attribute12 = FND_API.G_MISS_CHAR THEN
540: l_RepSchedule_rec.attribute12 := NULL;
541: END IF;
542:
543: IF l_RepSchedule_rec.attribute13 = FND_API.G_MISS_CHAR THEN
539: IF l_RepSchedule_rec.attribute12 = FND_API.G_MISS_CHAR THEN
540: l_RepSchedule_rec.attribute12 := NULL;
541: END IF;
542:
543: IF l_RepSchedule_rec.attribute13 = FND_API.G_MISS_CHAR THEN
544: l_RepSchedule_rec.attribute13 := NULL;
545: END IF;
546:
547: IF l_RepSchedule_rec.attribute14 = FND_API.G_MISS_CHAR THEN
543: IF l_RepSchedule_rec.attribute13 = FND_API.G_MISS_CHAR THEN
544: l_RepSchedule_rec.attribute13 := NULL;
545: END IF;
546:
547: IF l_RepSchedule_rec.attribute14 = FND_API.G_MISS_CHAR THEN
548: l_RepSchedule_rec.attribute14 := NULL;
549: END IF;
550:
551: IF l_RepSchedule_rec.attribute15 = FND_API.G_MISS_CHAR THEN
547: IF l_RepSchedule_rec.attribute14 = FND_API.G_MISS_CHAR THEN
548: l_RepSchedule_rec.attribute14 := NULL;
549: END IF;
550:
551: IF l_RepSchedule_rec.attribute15 = FND_API.G_MISS_CHAR THEN
552: l_RepSchedule_rec.attribute15 := NULL;
553: END IF;
554:
555: IF l_RepSchedule_rec.attribute2 = FND_API.G_MISS_CHAR THEN
551: IF l_RepSchedule_rec.attribute15 = FND_API.G_MISS_CHAR THEN
552: l_RepSchedule_rec.attribute15 := NULL;
553: END IF;
554:
555: IF l_RepSchedule_rec.attribute2 = FND_API.G_MISS_CHAR THEN
556: l_RepSchedule_rec.attribute2 := NULL;
557: END IF;
558:
559: IF l_RepSchedule_rec.attribute3 = FND_API.G_MISS_CHAR THEN
555: IF l_RepSchedule_rec.attribute2 = FND_API.G_MISS_CHAR THEN
556: l_RepSchedule_rec.attribute2 := NULL;
557: END IF;
558:
559: IF l_RepSchedule_rec.attribute3 = FND_API.G_MISS_CHAR THEN
560: l_RepSchedule_rec.attribute3 := NULL;
561: END IF;
562:
563: IF l_RepSchedule_rec.attribute4 = FND_API.G_MISS_CHAR THEN
559: IF l_RepSchedule_rec.attribute3 = FND_API.G_MISS_CHAR THEN
560: l_RepSchedule_rec.attribute3 := NULL;
561: END IF;
562:
563: IF l_RepSchedule_rec.attribute4 = FND_API.G_MISS_CHAR THEN
564: l_RepSchedule_rec.attribute4 := NULL;
565: END IF;
566:
567: IF l_RepSchedule_rec.attribute5 = FND_API.G_MISS_CHAR THEN
563: IF l_RepSchedule_rec.attribute4 = FND_API.G_MISS_CHAR THEN
564: l_RepSchedule_rec.attribute4 := NULL;
565: END IF;
566:
567: IF l_RepSchedule_rec.attribute5 = FND_API.G_MISS_CHAR THEN
568: l_RepSchedule_rec.attribute5 := NULL;
569: END IF;
570:
571: IF l_RepSchedule_rec.attribute6 = FND_API.G_MISS_CHAR THEN
567: IF l_RepSchedule_rec.attribute5 = FND_API.G_MISS_CHAR THEN
568: l_RepSchedule_rec.attribute5 := NULL;
569: END IF;
570:
571: IF l_RepSchedule_rec.attribute6 = FND_API.G_MISS_CHAR THEN
572: l_RepSchedule_rec.attribute6 := NULL;
573: END IF;
574:
575: IF l_RepSchedule_rec.attribute7 = FND_API.G_MISS_CHAR THEN
571: IF l_RepSchedule_rec.attribute6 = FND_API.G_MISS_CHAR THEN
572: l_RepSchedule_rec.attribute6 := NULL;
573: END IF;
574:
575: IF l_RepSchedule_rec.attribute7 = FND_API.G_MISS_CHAR THEN
576: l_RepSchedule_rec.attribute7 := NULL;
577: END IF;
578:
579: IF l_RepSchedule_rec.attribute8 = FND_API.G_MISS_CHAR THEN
575: IF l_RepSchedule_rec.attribute7 = FND_API.G_MISS_CHAR THEN
576: l_RepSchedule_rec.attribute7 := NULL;
577: END IF;
578:
579: IF l_RepSchedule_rec.attribute8 = FND_API.G_MISS_CHAR THEN
580: l_RepSchedule_rec.attribute8 := NULL;
581: END IF;
582:
583: IF l_RepSchedule_rec.attribute9 = FND_API.G_MISS_CHAR THEN
579: IF l_RepSchedule_rec.attribute8 = FND_API.G_MISS_CHAR THEN
580: l_RepSchedule_rec.attribute8 := NULL;
581: END IF;
582:
583: IF l_RepSchedule_rec.attribute9 = FND_API.G_MISS_CHAR THEN
584: l_RepSchedule_rec.attribute9 := NULL;
585: END IF;
586:
587: IF l_RepSchedule_rec.attribute_category = FND_API.G_MISS_CHAR THEN
583: IF l_RepSchedule_rec.attribute9 = FND_API.G_MISS_CHAR THEN
584: l_RepSchedule_rec.attribute9 := NULL;
585: END IF;
586:
587: IF l_RepSchedule_rec.attribute_category = FND_API.G_MISS_CHAR THEN
588: l_RepSchedule_rec.attribute_category := NULL;
589: END IF;
590:
591: IF l_RepSchedule_rec.bom_revision = FND_API.G_MISS_CHAR THEN
587: IF l_RepSchedule_rec.attribute_category = FND_API.G_MISS_CHAR THEN
588: l_RepSchedule_rec.attribute_category := NULL;
589: END IF;
590:
591: IF l_RepSchedule_rec.bom_revision = FND_API.G_MISS_CHAR THEN
592: l_RepSchedule_rec.bom_revision := NULL;
593: END IF;
594:
595: IF l_RepSchedule_rec.bom_revision_date = FND_API.G_MISS_DATE THEN
591: IF l_RepSchedule_rec.bom_revision = FND_API.G_MISS_CHAR THEN
592: l_RepSchedule_rec.bom_revision := NULL;
593: END IF;
594:
595: IF l_RepSchedule_rec.bom_revision_date = FND_API.G_MISS_DATE THEN
596: l_RepSchedule_rec.bom_revision_date := NULL;
597: END IF;
598:
599: IF l_RepSchedule_rec.common_bom_sequence_id = FND_API.G_MISS_NUM THEN
595: IF l_RepSchedule_rec.bom_revision_date = FND_API.G_MISS_DATE THEN
596: l_RepSchedule_rec.bom_revision_date := NULL;
597: END IF;
598:
599: IF l_RepSchedule_rec.common_bom_sequence_id = FND_API.G_MISS_NUM THEN
600: l_RepSchedule_rec.common_bom_sequence_id := NULL;
601: END IF;
602:
603: IF l_RepSchedule_rec.common_rout_sequence_id = FND_API.G_MISS_NUM THEN
599: IF l_RepSchedule_rec.common_bom_sequence_id = FND_API.G_MISS_NUM THEN
600: l_RepSchedule_rec.common_bom_sequence_id := NULL;
601: END IF;
602:
603: IF l_RepSchedule_rec.common_rout_sequence_id = FND_API.G_MISS_NUM THEN
604: l_RepSchedule_rec.common_rout_sequence_id := NULL;
605: END IF;
606:
607: IF l_RepSchedule_rec.created_by = FND_API.G_MISS_NUM THEN
603: IF l_RepSchedule_rec.common_rout_sequence_id = FND_API.G_MISS_NUM THEN
604: l_RepSchedule_rec.common_rout_sequence_id := NULL;
605: END IF;
606:
607: IF l_RepSchedule_rec.created_by = FND_API.G_MISS_NUM THEN
608: l_RepSchedule_rec.created_by := NULL;
609: END IF;
610:
611: IF l_RepSchedule_rec.creation_date = FND_API.G_MISS_DATE THEN
607: IF l_RepSchedule_rec.created_by = FND_API.G_MISS_NUM THEN
608: l_RepSchedule_rec.created_by := NULL;
609: END IF;
610:
611: IF l_RepSchedule_rec.creation_date = FND_API.G_MISS_DATE THEN
612: l_RepSchedule_rec.creation_date := NULL;
613: END IF;
614:
615: IF l_RepSchedule_rec.daily_production_rate = FND_API.G_MISS_NUM THEN
611: IF l_RepSchedule_rec.creation_date = FND_API.G_MISS_DATE THEN
612: l_RepSchedule_rec.creation_date := NULL;
613: END IF;
614:
615: IF l_RepSchedule_rec.daily_production_rate = FND_API.G_MISS_NUM THEN
616: l_RepSchedule_rec.daily_production_rate := NULL;
617: END IF;
618:
619: IF l_RepSchedule_rec.date_closed = FND_API.G_MISS_DATE THEN
615: IF l_RepSchedule_rec.daily_production_rate = FND_API.G_MISS_NUM THEN
616: l_RepSchedule_rec.daily_production_rate := NULL;
617: END IF;
618:
619: IF l_RepSchedule_rec.date_closed = FND_API.G_MISS_DATE THEN
620: l_RepSchedule_rec.date_closed := NULL;
621: END IF;
622:
623: IF l_RepSchedule_rec.date_released = FND_API.G_MISS_DATE THEN
619: IF l_RepSchedule_rec.date_closed = FND_API.G_MISS_DATE THEN
620: l_RepSchedule_rec.date_closed := NULL;
621: END IF;
622:
623: IF l_RepSchedule_rec.date_released = FND_API.G_MISS_DATE THEN
624: l_RepSchedule_rec.date_released := NULL;
625: END IF;
626:
627: IF l_RepSchedule_rec.demand_class = FND_API.G_MISS_CHAR THEN
623: IF l_RepSchedule_rec.date_released = FND_API.G_MISS_DATE THEN
624: l_RepSchedule_rec.date_released := NULL;
625: END IF;
626:
627: IF l_RepSchedule_rec.demand_class = FND_API.G_MISS_CHAR THEN
628: l_RepSchedule_rec.demand_class := NULL;
629: END IF;
630:
631: IF l_RepSchedule_rec.description = FND_API.G_MISS_CHAR THEN
627: IF l_RepSchedule_rec.demand_class = FND_API.G_MISS_CHAR THEN
628: l_RepSchedule_rec.demand_class := NULL;
629: END IF;
630:
631: IF l_RepSchedule_rec.description = FND_API.G_MISS_CHAR THEN
632: l_RepSchedule_rec.description := NULL;
633: END IF;
634:
635: IF l_RepSchedule_rec.firm_planned_flag = FND_API.G_MISS_NUM THEN
631: IF l_RepSchedule_rec.description = FND_API.G_MISS_CHAR THEN
632: l_RepSchedule_rec.description := NULL;
633: END IF;
634:
635: IF l_RepSchedule_rec.firm_planned_flag = FND_API.G_MISS_NUM THEN
636: l_RepSchedule_rec.firm_planned_flag := NULL;
637: END IF;
638:
639: IF l_RepSchedule_rec.first_unit_cpl_date = FND_API.G_MISS_DATE THEN
635: IF l_RepSchedule_rec.firm_planned_flag = FND_API.G_MISS_NUM THEN
636: l_RepSchedule_rec.firm_planned_flag := NULL;
637: END IF;
638:
639: IF l_RepSchedule_rec.first_unit_cpl_date = FND_API.G_MISS_DATE THEN
640: l_RepSchedule_rec.first_unit_cpl_date := NULL;
641: END IF;
642:
643: IF l_RepSchedule_rec.first_unit_start_date = FND_API.G_MISS_DATE THEN
639: IF l_RepSchedule_rec.first_unit_cpl_date = FND_API.G_MISS_DATE THEN
640: l_RepSchedule_rec.first_unit_cpl_date := NULL;
641: END IF;
642:
643: IF l_RepSchedule_rec.first_unit_start_date = FND_API.G_MISS_DATE THEN
644: l_RepSchedule_rec.first_unit_start_date := NULL;
645: END IF;
646:
647: IF l_RepSchedule_rec.last_unit_cpl_date = FND_API.G_MISS_DATE THEN
643: IF l_RepSchedule_rec.first_unit_start_date = FND_API.G_MISS_DATE THEN
644: l_RepSchedule_rec.first_unit_start_date := NULL;
645: END IF;
646:
647: IF l_RepSchedule_rec.last_unit_cpl_date = FND_API.G_MISS_DATE THEN
648: l_RepSchedule_rec.last_unit_cpl_date := NULL;
649: END IF;
650:
651: IF l_RepSchedule_rec.last_unit_start_date = FND_API.G_MISS_DATE THEN
647: IF l_RepSchedule_rec.last_unit_cpl_date = FND_API.G_MISS_DATE THEN
648: l_RepSchedule_rec.last_unit_cpl_date := NULL;
649: END IF;
650:
651: IF l_RepSchedule_rec.last_unit_start_date = FND_API.G_MISS_DATE THEN
652: l_RepSchedule_rec.last_unit_start_date := NULL;
653: END IF;
654:
655: IF l_RepSchedule_rec.last_updated_by = FND_API.G_MISS_NUM THEN
651: IF l_RepSchedule_rec.last_unit_start_date = FND_API.G_MISS_DATE THEN
652: l_RepSchedule_rec.last_unit_start_date := NULL;
653: END IF;
654:
655: IF l_RepSchedule_rec.last_updated_by = FND_API.G_MISS_NUM THEN
656: l_RepSchedule_rec.last_updated_by := NULL;
657: END IF;
658:
659: IF l_RepSchedule_rec.last_update_date = FND_API.G_MISS_DATE THEN
655: IF l_RepSchedule_rec.last_updated_by = FND_API.G_MISS_NUM THEN
656: l_RepSchedule_rec.last_updated_by := NULL;
657: END IF;
658:
659: IF l_RepSchedule_rec.last_update_date = FND_API.G_MISS_DATE THEN
660: l_RepSchedule_rec.last_update_date := NULL;
661: END IF;
662:
663: IF l_RepSchedule_rec.last_update_login = FND_API.G_MISS_NUM THEN
659: IF l_RepSchedule_rec.last_update_date = FND_API.G_MISS_DATE THEN
660: l_RepSchedule_rec.last_update_date := NULL;
661: END IF;
662:
663: IF l_RepSchedule_rec.last_update_login = FND_API.G_MISS_NUM THEN
664: l_RepSchedule_rec.last_update_login := NULL;
665: END IF;
666:
667: IF l_RepSchedule_rec.line_id = FND_API.G_MISS_NUM THEN
663: IF l_RepSchedule_rec.last_update_login = FND_API.G_MISS_NUM THEN
664: l_RepSchedule_rec.last_update_login := NULL;
665: END IF;
666:
667: IF l_RepSchedule_rec.line_id = FND_API.G_MISS_NUM THEN
668: l_RepSchedule_rec.line_id := NULL;
669: END IF;
670:
671: IF l_RepSchedule_rec.material_account = FND_API.G_MISS_NUM THEN
667: IF l_RepSchedule_rec.line_id = FND_API.G_MISS_NUM THEN
668: l_RepSchedule_rec.line_id := NULL;
669: END IF;
670:
671: IF l_RepSchedule_rec.material_account = FND_API.G_MISS_NUM THEN
672: l_RepSchedule_rec.material_account := NULL;
673: END IF;
674:
675: IF l_RepSchedule_rec.material_overhead_account = FND_API.G_MISS_NUM THEN
671: IF l_RepSchedule_rec.material_account = FND_API.G_MISS_NUM THEN
672: l_RepSchedule_rec.material_account := NULL;
673: END IF;
674:
675: IF l_RepSchedule_rec.material_overhead_account = FND_API.G_MISS_NUM THEN
676: l_RepSchedule_rec.material_overhead_account := NULL;
677: END IF;
678:
679: IF l_RepSchedule_rec.material_variance_account = FND_API.G_MISS_NUM THEN
675: IF l_RepSchedule_rec.material_overhead_account = FND_API.G_MISS_NUM THEN
676: l_RepSchedule_rec.material_overhead_account := NULL;
677: END IF;
678:
679: IF l_RepSchedule_rec.material_variance_account = FND_API.G_MISS_NUM THEN
680: l_RepSchedule_rec.material_variance_account := NULL;
681: END IF;
682:
683: IF l_RepSchedule_rec.organization_id = FND_API.G_MISS_NUM THEN
679: IF l_RepSchedule_rec.material_variance_account = FND_API.G_MISS_NUM THEN
680: l_RepSchedule_rec.material_variance_account := NULL;
681: END IF;
682:
683: IF l_RepSchedule_rec.organization_id = FND_API.G_MISS_NUM THEN
684: l_RepSchedule_rec.organization_id := NULL;
685: END IF;
686:
687: IF l_RepSchedule_rec.osp_account = FND_API.G_MISS_NUM THEN
683: IF l_RepSchedule_rec.organization_id = FND_API.G_MISS_NUM THEN
684: l_RepSchedule_rec.organization_id := NULL;
685: END IF;
686:
687: IF l_RepSchedule_rec.osp_account = FND_API.G_MISS_NUM THEN
688: l_RepSchedule_rec.osp_account := NULL;
689: END IF;
690:
691: IF l_RepSchedule_rec.osp_variance_account = FND_API.G_MISS_NUM THEN
687: IF l_RepSchedule_rec.osp_account = FND_API.G_MISS_NUM THEN
688: l_RepSchedule_rec.osp_account := NULL;
689: END IF;
690:
691: IF l_RepSchedule_rec.osp_variance_account = FND_API.G_MISS_NUM THEN
692: l_RepSchedule_rec.osp_variance_account := NULL;
693: END IF;
694:
695: IF l_RepSchedule_rec.overhead_account = FND_API.G_MISS_NUM THEN
691: IF l_RepSchedule_rec.osp_variance_account = FND_API.G_MISS_NUM THEN
692: l_RepSchedule_rec.osp_variance_account := NULL;
693: END IF;
694:
695: IF l_RepSchedule_rec.overhead_account = FND_API.G_MISS_NUM THEN
696: l_RepSchedule_rec.overhead_account := NULL;
697: END IF;
698:
699: IF l_RepSchedule_rec.overhead_variance_account = FND_API.G_MISS_NUM THEN
695: IF l_RepSchedule_rec.overhead_account = FND_API.G_MISS_NUM THEN
696: l_RepSchedule_rec.overhead_account := NULL;
697: END IF;
698:
699: IF l_RepSchedule_rec.overhead_variance_account = FND_API.G_MISS_NUM THEN
700: l_RepSchedule_rec.overhead_variance_account := NULL;
701: END IF;
702:
703: IF l_RepSchedule_rec.processing_work_days = FND_API.G_MISS_NUM THEN
699: IF l_RepSchedule_rec.overhead_variance_account = FND_API.G_MISS_NUM THEN
700: l_RepSchedule_rec.overhead_variance_account := NULL;
701: END IF;
702:
703: IF l_RepSchedule_rec.processing_work_days = FND_API.G_MISS_NUM THEN
704: l_RepSchedule_rec.processing_work_days := NULL;
705: END IF;
706:
707: IF l_RepSchedule_rec.program_application_id = FND_API.G_MISS_NUM THEN
703: IF l_RepSchedule_rec.processing_work_days = FND_API.G_MISS_NUM THEN
704: l_RepSchedule_rec.processing_work_days := NULL;
705: END IF;
706:
707: IF l_RepSchedule_rec.program_application_id = FND_API.G_MISS_NUM THEN
708: l_RepSchedule_rec.program_application_id := NULL;
709: END IF;
710:
711: IF l_RepSchedule_rec.program_id = FND_API.G_MISS_NUM THEN
707: IF l_RepSchedule_rec.program_application_id = FND_API.G_MISS_NUM THEN
708: l_RepSchedule_rec.program_application_id := NULL;
709: END IF;
710:
711: IF l_RepSchedule_rec.program_id = FND_API.G_MISS_NUM THEN
712: l_RepSchedule_rec.program_id := NULL;
713: END IF;
714:
715: IF l_RepSchedule_rec.program_update_date = FND_API.G_MISS_DATE THEN
711: IF l_RepSchedule_rec.program_id = FND_API.G_MISS_NUM THEN
712: l_RepSchedule_rec.program_id := NULL;
713: END IF;
714:
715: IF l_RepSchedule_rec.program_update_date = FND_API.G_MISS_DATE THEN
716: l_RepSchedule_rec.program_update_date := NULL;
717: END IF;
718:
719: IF l_RepSchedule_rec.quantity_completed = FND_API.G_MISS_NUM THEN
715: IF l_RepSchedule_rec.program_update_date = FND_API.G_MISS_DATE THEN
716: l_RepSchedule_rec.program_update_date := NULL;
717: END IF;
718:
719: IF l_RepSchedule_rec.quantity_completed = FND_API.G_MISS_NUM THEN
720: l_RepSchedule_rec.quantity_completed := NULL;
721: END IF;
722:
723: IF l_RepSchedule_rec.repetitive_schedule_id = FND_API.G_MISS_NUM THEN
719: IF l_RepSchedule_rec.quantity_completed = FND_API.G_MISS_NUM THEN
720: l_RepSchedule_rec.quantity_completed := NULL;
721: END IF;
722:
723: IF l_RepSchedule_rec.repetitive_schedule_id = FND_API.G_MISS_NUM THEN
724: l_RepSchedule_rec.repetitive_schedule_id := NULL;
725: END IF;
726:
727: IF l_RepSchedule_rec.request_id = FND_API.G_MISS_NUM THEN
723: IF l_RepSchedule_rec.repetitive_schedule_id = FND_API.G_MISS_NUM THEN
724: l_RepSchedule_rec.repetitive_schedule_id := NULL;
725: END IF;
726:
727: IF l_RepSchedule_rec.request_id = FND_API.G_MISS_NUM THEN
728: l_RepSchedule_rec.request_id := NULL;
729: END IF;
730:
731: IF l_RepSchedule_rec.resource_account = FND_API.G_MISS_NUM THEN
727: IF l_RepSchedule_rec.request_id = FND_API.G_MISS_NUM THEN
728: l_RepSchedule_rec.request_id := NULL;
729: END IF;
730:
731: IF l_RepSchedule_rec.resource_account = FND_API.G_MISS_NUM THEN
732: l_RepSchedule_rec.resource_account := NULL;
733: END IF;
734:
735: IF l_RepSchedule_rec.resource_variance_account = FND_API.G_MISS_NUM THEN
731: IF l_RepSchedule_rec.resource_account = FND_API.G_MISS_NUM THEN
732: l_RepSchedule_rec.resource_account := NULL;
733: END IF;
734:
735: IF l_RepSchedule_rec.resource_variance_account = FND_API.G_MISS_NUM THEN
736: l_RepSchedule_rec.resource_variance_account := NULL;
737: END IF;
738:
739: IF l_RepSchedule_rec.routing_revision = FND_API.G_MISS_CHAR THEN
735: IF l_RepSchedule_rec.resource_variance_account = FND_API.G_MISS_NUM THEN
736: l_RepSchedule_rec.resource_variance_account := NULL;
737: END IF;
738:
739: IF l_RepSchedule_rec.routing_revision = FND_API.G_MISS_CHAR THEN
740: l_RepSchedule_rec.routing_revision := NULL;
741: END IF;
742:
743: IF l_RepSchedule_rec.routing_revision_date = FND_API.G_MISS_DATE THEN
739: IF l_RepSchedule_rec.routing_revision = FND_API.G_MISS_CHAR THEN
740: l_RepSchedule_rec.routing_revision := NULL;
741: END IF;
742:
743: IF l_RepSchedule_rec.routing_revision_date = FND_API.G_MISS_DATE THEN
744: l_RepSchedule_rec.routing_revision_date := NULL;
745: END IF;
746:
747: IF l_RepSchedule_rec.status_type = FND_API.G_MISS_NUM THEN
743: IF l_RepSchedule_rec.routing_revision_date = FND_API.G_MISS_DATE THEN
744: l_RepSchedule_rec.routing_revision_date := NULL;
745: END IF;
746:
747: IF l_RepSchedule_rec.status_type = FND_API.G_MISS_NUM THEN
748: l_RepSchedule_rec.status_type := NULL;
749: END IF;
750:
751: IF l_RepSchedule_rec.wip_entity_id = FND_API.G_MISS_NUM THEN
747: IF l_RepSchedule_rec.status_type = FND_API.G_MISS_NUM THEN
748: l_RepSchedule_rec.status_type := NULL;
749: END IF;
750:
751: IF l_RepSchedule_rec.wip_entity_id = FND_API.G_MISS_NUM THEN
752: l_RepSchedule_rec.wip_entity_id := NULL;
753: END IF;
754:
755: IF l_RepSchedule_rec.kanban_card_id = FND_API.G_MISS_NUM THEN
751: IF l_RepSchedule_rec.wip_entity_id = FND_API.G_MISS_NUM THEN
752: l_RepSchedule_rec.wip_entity_id := NULL;
753: END IF;
754:
755: IF l_RepSchedule_rec.kanban_card_id = FND_API.G_MISS_NUM THEN
756: l_RepSchedule_rec.kanban_card_id := NULL;
757: END IF;
758:
759: RETURN l_RepSchedule_rec;
842: , 'Update_Row'
843: );
844: END IF;
845:
846: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
847:
848: END Update_Row;
849:
850: -- Procedure Insert_Row
989: , 'Insert_Row'
990: );
991: END IF;
992:
993: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
994:
995: END Insert_Row;
996:
997: -- Procedure Delete_Row
1017: , 'Delete_Row'
1018: );
1019: END IF;
1020:
1021: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1022:
1023: END Delete_Row;
1024:
1025: -- Function Query_Row
1122: , ROUTING_REVISION_DATE
1123: , STATUS_TYPE
1124: , WIP_ENTITY_ID
1125: FROM WIP_REPETITIVE_SCHEDULES
1126: WHERE ( REPETITIVE_SCHEDULE_ID = nvl(p_repetitive_schedule_id,FND_API.G_MISS_NUM)
1127: )
1128: OR ( WIP_ENTITY_ID = nvl(p_wip_entity_id,FND_API.G_MISS_NUM)
1129: );
1130:
1124: , WIP_ENTITY_ID
1125: FROM WIP_REPETITIVE_SCHEDULES
1126: WHERE ( REPETITIVE_SCHEDULE_ID = nvl(p_repetitive_schedule_id,FND_API.G_MISS_NUM)
1127: )
1128: OR ( WIP_ENTITY_ID = nvl(p_wip_entity_id,FND_API.G_MISS_NUM)
1129: );
1130:
1131: BEGIN
1132:
1132:
1133: IF
1134: (p_repetitive_schedule_id IS NOT NULL
1135: AND
1136: p_repetitive_schedule_id <> FND_API.G_MISS_NUM)
1137: AND
1138: (p_wip_entity_id IS NOT NULL
1139: AND
1140: p_wip_entity_id <> FND_API.G_MISS_NUM)
1136: p_repetitive_schedule_id <> FND_API.G_MISS_NUM)
1137: AND
1138: (p_wip_entity_id IS NOT NULL
1139: AND
1140: p_wip_entity_id <> FND_API.G_MISS_NUM)
1141: THEN
1142: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1143: THEN
1144: FND_MSG_PUB.Add_Exc_Msg
1147: , 'Keys are mutually exclusive: repetitive_schedule_id = '|| p_repetitive_schedule_id || ', wip_entity_id = '|| p_wip_entity_id
1148: );
1149: END IF;
1150:
1151: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1152:
1153: END IF;
1154:
1155:
1226:
1227: IF
1228: (p_repetitive_schedule_id IS NOT NULL
1229: AND
1230: p_repetitive_schedule_id <> FND_API.G_MISS_NUM)
1231: AND
1232: (l_RepSchedule_tbl.COUNT = 0)
1233: THEN
1234: RAISE NO_DATA_FOUND;
1240: RETURN l_RepSchedule_tbl;
1241:
1242: EXCEPTION
1243:
1244: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1245:
1246: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1247:
1248: WHEN OTHERS THEN
1242: EXCEPTION
1243:
1244: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1245:
1246: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1247:
1248: WHEN OTHERS THEN
1249:
1250: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1254: , 'Query_Rows'
1255: );
1256: END IF;
1257:
1258: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1259:
1260: END Query_Rows;
1261:
1262: -- Procedure lock_Row
1520: x_RepSchedule_rec := l_RepSchedule_rec;
1521:
1522: -- Set return status
1523:
1524: x_return_status := FND_API.G_RET_STS_SUCCESS;
1525: x_RepSchedule_rec.return_status := FND_API.G_RET_STS_SUCCESS;
1526:
1527: ELSE
1528:
1521:
1522: -- Set return status
1523:
1524: x_return_status := FND_API.G_RET_STS_SUCCESS;
1525: x_RepSchedule_rec.return_status := FND_API.G_RET_STS_SUCCESS;
1526:
1527: ELSE
1528:
1529: -- Row has changed by another user.
1527: ELSE
1528:
1529: -- Row has changed by another user.
1530:
1531: x_return_status := FND_API.G_RET_STS_ERROR;
1532: x_RepSchedule_rec.return_status := FND_API.G_RET_STS_ERROR;
1533:
1534: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
1535: THEN
1528:
1529: -- Row has changed by another user.
1530:
1531: x_return_status := FND_API.G_RET_STS_ERROR;
1532: x_RepSchedule_rec.return_status := FND_API.G_RET_STS_ERROR;
1533:
1534: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
1535: THEN
1536:
1544: EXCEPTION
1545:
1546: WHEN NO_DATA_FOUND THEN
1547:
1548: x_return_status := FND_API.G_RET_STS_ERROR;
1549: x_RepSchedule_rec.return_status := FND_API.G_RET_STS_ERROR;
1550:
1551: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
1552: THEN
1545:
1546: WHEN NO_DATA_FOUND THEN
1547:
1548: x_return_status := FND_API.G_RET_STS_ERROR;
1549: x_RepSchedule_rec.return_status := FND_API.G_RET_STS_ERROR;
1550:
1551: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
1552: THEN
1553:
1556:
1557: END IF;
1558: WHEN APP_EXCEPTIONS.RECORD_LOCK_EXCEPTION THEN
1559:
1560: x_return_status := FND_API.G_RET_STS_ERROR;
1561: x_RepSchedule_rec.return_status := FND_API.G_RET_STS_ERROR;
1562:
1563: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
1564: THEN
1557: END IF;
1558: WHEN APP_EXCEPTIONS.RECORD_LOCK_EXCEPTION THEN
1559:
1560: x_return_status := FND_API.G_RET_STS_ERROR;
1561: x_RepSchedule_rec.return_status := FND_API.G_RET_STS_ERROR;
1562:
1563: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
1564: THEN
1565:
1568:
1569: END IF;
1570: WHEN OTHERS THEN
1571:
1572: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1573: x_RepSchedule_rec.return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1574:
1575: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1576: THEN
1569: END IF;
1570: WHEN OTHERS THEN
1571:
1572: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1573: x_RepSchedule_rec.return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1574:
1575: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1576: THEN
1577: FND_MSG_PUB.Add_Exc_Msg