DBA Data[Home] [Help]

APPS.WIP_SHOPFLOORMOVE_UTIL dependencies on FND_API

Line 19: IF l_ShopFloorMove_rec.acct_period_id = FND_API.G_MISS_NUM THEN

15: IS
16: l_ShopFloorMove_rec WIP_Transaction_PUB.Shopfloormove_Rec_Type := p_ShopFloorMove_rec;
17: BEGIN
18:
19: IF l_ShopFloorMove_rec.acct_period_id = FND_API.G_MISS_NUM THEN
20: l_ShopFloorMove_rec.acct_period_id := p_old_ShopFloorMove_rec.acct_period_id;
21: END IF;
22:
23: IF l_ShopFloorMove_rec.attribute1 = FND_API.G_MISS_CHAR THEN

Line 23: IF l_ShopFloorMove_rec.attribute1 = FND_API.G_MISS_CHAR THEN

19: IF l_ShopFloorMove_rec.acct_period_id = FND_API.G_MISS_NUM THEN
20: l_ShopFloorMove_rec.acct_period_id := p_old_ShopFloorMove_rec.acct_period_id;
21: END IF;
22:
23: IF l_ShopFloorMove_rec.attribute1 = FND_API.G_MISS_CHAR THEN
24: l_ShopFloorMove_rec.attribute1 := p_old_ShopFloorMove_rec.attribute1;
25: END IF;
26:
27: IF l_ShopFloorMove_rec.attribute10 = FND_API.G_MISS_CHAR THEN

Line 27: IF l_ShopFloorMove_rec.attribute10 = FND_API.G_MISS_CHAR THEN

23: IF l_ShopFloorMove_rec.attribute1 = FND_API.G_MISS_CHAR THEN
24: l_ShopFloorMove_rec.attribute1 := p_old_ShopFloorMove_rec.attribute1;
25: END IF;
26:
27: IF l_ShopFloorMove_rec.attribute10 = FND_API.G_MISS_CHAR THEN
28: l_ShopFloorMove_rec.attribute10 := p_old_ShopFloorMove_rec.attribute10;
29: END IF;
30:
31: IF l_ShopFloorMove_rec.attribute11 = FND_API.G_MISS_CHAR THEN

Line 31: IF l_ShopFloorMove_rec.attribute11 = FND_API.G_MISS_CHAR THEN

27: IF l_ShopFloorMove_rec.attribute10 = FND_API.G_MISS_CHAR THEN
28: l_ShopFloorMove_rec.attribute10 := p_old_ShopFloorMove_rec.attribute10;
29: END IF;
30:
31: IF l_ShopFloorMove_rec.attribute11 = FND_API.G_MISS_CHAR THEN
32: l_ShopFloorMove_rec.attribute11 := p_old_ShopFloorMove_rec.attribute11;
33: END IF;
34:
35: IF l_ShopFloorMove_rec.attribute12 = FND_API.G_MISS_CHAR THEN

Line 35: IF l_ShopFloorMove_rec.attribute12 = FND_API.G_MISS_CHAR THEN

31: IF l_ShopFloorMove_rec.attribute11 = FND_API.G_MISS_CHAR THEN
32: l_ShopFloorMove_rec.attribute11 := p_old_ShopFloorMove_rec.attribute11;
33: END IF;
34:
35: IF l_ShopFloorMove_rec.attribute12 = FND_API.G_MISS_CHAR THEN
36: l_ShopFloorMove_rec.attribute12 := p_old_ShopFloorMove_rec.attribute12;
37: END IF;
38:
39: IF l_ShopFloorMove_rec.attribute13 = FND_API.G_MISS_CHAR THEN

Line 39: IF l_ShopFloorMove_rec.attribute13 = FND_API.G_MISS_CHAR THEN

35: IF l_ShopFloorMove_rec.attribute12 = FND_API.G_MISS_CHAR THEN
36: l_ShopFloorMove_rec.attribute12 := p_old_ShopFloorMove_rec.attribute12;
37: END IF;
38:
39: IF l_ShopFloorMove_rec.attribute13 = FND_API.G_MISS_CHAR THEN
40: l_ShopFloorMove_rec.attribute13 := p_old_ShopFloorMove_rec.attribute13;
41: END IF;
42:
43: IF l_ShopFloorMove_rec.attribute14 = FND_API.G_MISS_CHAR THEN

Line 43: IF l_ShopFloorMove_rec.attribute14 = FND_API.G_MISS_CHAR THEN

39: IF l_ShopFloorMove_rec.attribute13 = FND_API.G_MISS_CHAR THEN
40: l_ShopFloorMove_rec.attribute13 := p_old_ShopFloorMove_rec.attribute13;
41: END IF;
42:
43: IF l_ShopFloorMove_rec.attribute14 = FND_API.G_MISS_CHAR THEN
44: l_ShopFloorMove_rec.attribute14 := p_old_ShopFloorMove_rec.attribute14;
45: END IF;
46:
47: IF l_ShopFloorMove_rec.attribute15 = FND_API.G_MISS_CHAR THEN

Line 47: IF l_ShopFloorMove_rec.attribute15 = FND_API.G_MISS_CHAR THEN

43: IF l_ShopFloorMove_rec.attribute14 = FND_API.G_MISS_CHAR THEN
44: l_ShopFloorMove_rec.attribute14 := p_old_ShopFloorMove_rec.attribute14;
45: END IF;
46:
47: IF l_ShopFloorMove_rec.attribute15 = FND_API.G_MISS_CHAR THEN
48: l_ShopFloorMove_rec.attribute15 := p_old_ShopFloorMove_rec.attribute15;
49: END IF;
50:
51: IF l_ShopFloorMove_rec.attribute2 = FND_API.G_MISS_CHAR THEN

Line 51: IF l_ShopFloorMove_rec.attribute2 = FND_API.G_MISS_CHAR THEN

47: IF l_ShopFloorMove_rec.attribute15 = FND_API.G_MISS_CHAR THEN
48: l_ShopFloorMove_rec.attribute15 := p_old_ShopFloorMove_rec.attribute15;
49: END IF;
50:
51: IF l_ShopFloorMove_rec.attribute2 = FND_API.G_MISS_CHAR THEN
52: l_ShopFloorMove_rec.attribute2 := p_old_ShopFloorMove_rec.attribute2;
53: END IF;
54:
55: IF l_ShopFloorMove_rec.attribute3 = FND_API.G_MISS_CHAR THEN

Line 55: IF l_ShopFloorMove_rec.attribute3 = FND_API.G_MISS_CHAR THEN

51: IF l_ShopFloorMove_rec.attribute2 = FND_API.G_MISS_CHAR THEN
52: l_ShopFloorMove_rec.attribute2 := p_old_ShopFloorMove_rec.attribute2;
53: END IF;
54:
55: IF l_ShopFloorMove_rec.attribute3 = FND_API.G_MISS_CHAR THEN
56: l_ShopFloorMove_rec.attribute3 := p_old_ShopFloorMove_rec.attribute3;
57: END IF;
58:
59: IF l_ShopFloorMove_rec.attribute4 = FND_API.G_MISS_CHAR THEN

Line 59: IF l_ShopFloorMove_rec.attribute4 = FND_API.G_MISS_CHAR THEN

55: IF l_ShopFloorMove_rec.attribute3 = FND_API.G_MISS_CHAR THEN
56: l_ShopFloorMove_rec.attribute3 := p_old_ShopFloorMove_rec.attribute3;
57: END IF;
58:
59: IF l_ShopFloorMove_rec.attribute4 = FND_API.G_MISS_CHAR THEN
60: l_ShopFloorMove_rec.attribute4 := p_old_ShopFloorMove_rec.attribute4;
61: END IF;
62:
63: IF l_ShopFloorMove_rec.attribute5 = FND_API.G_MISS_CHAR THEN

Line 63: IF l_ShopFloorMove_rec.attribute5 = FND_API.G_MISS_CHAR THEN

59: IF l_ShopFloorMove_rec.attribute4 = FND_API.G_MISS_CHAR THEN
60: l_ShopFloorMove_rec.attribute4 := p_old_ShopFloorMove_rec.attribute4;
61: END IF;
62:
63: IF l_ShopFloorMove_rec.attribute5 = FND_API.G_MISS_CHAR THEN
64: l_ShopFloorMove_rec.attribute5 := p_old_ShopFloorMove_rec.attribute5;
65: END IF;
66:
67: IF l_ShopFloorMove_rec.attribute6 = FND_API.G_MISS_CHAR THEN

Line 67: IF l_ShopFloorMove_rec.attribute6 = FND_API.G_MISS_CHAR THEN

63: IF l_ShopFloorMove_rec.attribute5 = FND_API.G_MISS_CHAR THEN
64: l_ShopFloorMove_rec.attribute5 := p_old_ShopFloorMove_rec.attribute5;
65: END IF;
66:
67: IF l_ShopFloorMove_rec.attribute6 = FND_API.G_MISS_CHAR THEN
68: l_ShopFloorMove_rec.attribute6 := p_old_ShopFloorMove_rec.attribute6;
69: END IF;
70:
71: IF l_ShopFloorMove_rec.attribute7 = FND_API.G_MISS_CHAR THEN

Line 71: IF l_ShopFloorMove_rec.attribute7 = FND_API.G_MISS_CHAR THEN

67: IF l_ShopFloorMove_rec.attribute6 = FND_API.G_MISS_CHAR THEN
68: l_ShopFloorMove_rec.attribute6 := p_old_ShopFloorMove_rec.attribute6;
69: END IF;
70:
71: IF l_ShopFloorMove_rec.attribute7 = FND_API.G_MISS_CHAR THEN
72: l_ShopFloorMove_rec.attribute7 := p_old_ShopFloorMove_rec.attribute7;
73: END IF;
74:
75: IF l_ShopFloorMove_rec.attribute8 = FND_API.G_MISS_CHAR THEN

Line 75: IF l_ShopFloorMove_rec.attribute8 = FND_API.G_MISS_CHAR THEN

71: IF l_ShopFloorMove_rec.attribute7 = FND_API.G_MISS_CHAR THEN
72: l_ShopFloorMove_rec.attribute7 := p_old_ShopFloorMove_rec.attribute7;
73: END IF;
74:
75: IF l_ShopFloorMove_rec.attribute8 = FND_API.G_MISS_CHAR THEN
76: l_ShopFloorMove_rec.attribute8 := p_old_ShopFloorMove_rec.attribute8;
77: END IF;
78:
79: IF l_ShopFloorMove_rec.attribute9 = FND_API.G_MISS_CHAR THEN

Line 79: IF l_ShopFloorMove_rec.attribute9 = FND_API.G_MISS_CHAR THEN

75: IF l_ShopFloorMove_rec.attribute8 = FND_API.G_MISS_CHAR THEN
76: l_ShopFloorMove_rec.attribute8 := p_old_ShopFloorMove_rec.attribute8;
77: END IF;
78:
79: IF l_ShopFloorMove_rec.attribute9 = FND_API.G_MISS_CHAR THEN
80: l_ShopFloorMove_rec.attribute9 := p_old_ShopFloorMove_rec.attribute9;
81: END IF;
82:
83: IF l_ShopFloorMove_rec.attribute_category = FND_API.G_MISS_CHAR THEN

Line 83: IF l_ShopFloorMove_rec.attribute_category = FND_API.G_MISS_CHAR THEN

79: IF l_ShopFloorMove_rec.attribute9 = FND_API.G_MISS_CHAR THEN
80: l_ShopFloorMove_rec.attribute9 := p_old_ShopFloorMove_rec.attribute9;
81: END IF;
82:
83: IF l_ShopFloorMove_rec.attribute_category = FND_API.G_MISS_CHAR THEN
84: l_ShopFloorMove_rec.attribute_category := p_old_ShopFloorMove_rec.attribute_category;
85: END IF;
86:
87: IF l_ShopFloorMove_rec.created_by = FND_API.G_MISS_NUM THEN

Line 87: IF l_ShopFloorMove_rec.created_by = FND_API.G_MISS_NUM THEN

83: IF l_ShopFloorMove_rec.attribute_category = FND_API.G_MISS_CHAR THEN
84: l_ShopFloorMove_rec.attribute_category := p_old_ShopFloorMove_rec.attribute_category;
85: END IF;
86:
87: IF l_ShopFloorMove_rec.created_by = FND_API.G_MISS_NUM THEN
88: l_ShopFloorMove_rec.created_by := p_old_ShopFloorMove_rec.created_by;
89: END IF;
90:
91: IF l_ShopFloorMove_rec.created_by_name = FND_API.G_MISS_CHAR THEN

Line 91: IF l_ShopFloorMove_rec.created_by_name = FND_API.G_MISS_CHAR THEN

87: IF l_ShopFloorMove_rec.created_by = FND_API.G_MISS_NUM THEN
88: l_ShopFloorMove_rec.created_by := p_old_ShopFloorMove_rec.created_by;
89: END IF;
90:
91: IF l_ShopFloorMove_rec.created_by_name = FND_API.G_MISS_CHAR THEN
92: l_ShopFloorMove_rec.created_by_name := p_old_ShopFloorMove_rec.created_by_name;
93: END IF;
94:
95: IF l_ShopFloorMove_rec.creation_date = FND_API.G_MISS_DATE THEN

Line 95: IF l_ShopFloorMove_rec.creation_date = FND_API.G_MISS_DATE THEN

91: IF l_ShopFloorMove_rec.created_by_name = FND_API.G_MISS_CHAR THEN
92: l_ShopFloorMove_rec.created_by_name := p_old_ShopFloorMove_rec.created_by_name;
93: END IF;
94:
95: IF l_ShopFloorMove_rec.creation_date = FND_API.G_MISS_DATE THEN
96: l_ShopFloorMove_rec.creation_date := p_old_ShopFloorMove_rec.creation_date;
97: END IF;
98:
99: IF l_ShopFloorMove_rec.entity_type = FND_API.G_MISS_NUM THEN

Line 99: IF l_ShopFloorMove_rec.entity_type = FND_API.G_MISS_NUM THEN

95: IF l_ShopFloorMove_rec.creation_date = FND_API.G_MISS_DATE THEN
96: l_ShopFloorMove_rec.creation_date := p_old_ShopFloorMove_rec.creation_date;
97: END IF;
98:
99: IF l_ShopFloorMove_rec.entity_type = FND_API.G_MISS_NUM THEN
100: l_ShopFloorMove_rec.entity_type := p_old_ShopFloorMove_rec.entity_type;
101: END IF;
102:
103: IF l_ShopFloorMove_rec.fm_department_code = FND_API.G_MISS_CHAR THEN

Line 103: IF l_ShopFloorMove_rec.fm_department_code = FND_API.G_MISS_CHAR THEN

99: IF l_ShopFloorMove_rec.entity_type = FND_API.G_MISS_NUM THEN
100: l_ShopFloorMove_rec.entity_type := p_old_ShopFloorMove_rec.entity_type;
101: END IF;
102:
103: IF l_ShopFloorMove_rec.fm_department_code = FND_API.G_MISS_CHAR THEN
104: l_ShopFloorMove_rec.fm_department_code := p_old_ShopFloorMove_rec.fm_department_code;
105: END IF;
106:
107: IF l_ShopFloorMove_rec.fm_department_id = FND_API.G_MISS_NUM THEN

Line 107: IF l_ShopFloorMove_rec.fm_department_id = FND_API.G_MISS_NUM THEN

103: IF l_ShopFloorMove_rec.fm_department_code = FND_API.G_MISS_CHAR THEN
104: l_ShopFloorMove_rec.fm_department_code := p_old_ShopFloorMove_rec.fm_department_code;
105: END IF;
106:
107: IF l_ShopFloorMove_rec.fm_department_id = FND_API.G_MISS_NUM THEN
108: l_ShopFloorMove_rec.fm_department_id := p_old_ShopFloorMove_rec.fm_department_id;
109: END IF;
110:
111: IF l_ShopFloorMove_rec.fm_intraop_step_type = FND_API.G_MISS_NUM THEN

Line 111: IF l_ShopFloorMove_rec.fm_intraop_step_type = FND_API.G_MISS_NUM THEN

107: IF l_ShopFloorMove_rec.fm_department_id = FND_API.G_MISS_NUM THEN
108: l_ShopFloorMove_rec.fm_department_id := p_old_ShopFloorMove_rec.fm_department_id;
109: END IF;
110:
111: IF l_ShopFloorMove_rec.fm_intraop_step_type = FND_API.G_MISS_NUM THEN
112: l_ShopFloorMove_rec.fm_intraop_step_type := p_old_ShopFloorMove_rec.fm_intraop_step_type;
113: END IF;
114:
115: IF l_ShopFloorMove_rec.fm_operation_code = FND_API.G_MISS_CHAR THEN

Line 115: IF l_ShopFloorMove_rec.fm_operation_code = FND_API.G_MISS_CHAR THEN

111: IF l_ShopFloorMove_rec.fm_intraop_step_type = FND_API.G_MISS_NUM THEN
112: l_ShopFloorMove_rec.fm_intraop_step_type := p_old_ShopFloorMove_rec.fm_intraop_step_type;
113: END IF;
114:
115: IF l_ShopFloorMove_rec.fm_operation_code = FND_API.G_MISS_CHAR THEN
116: l_ShopFloorMove_rec.fm_operation_code := p_old_ShopFloorMove_rec.fm_operation_code;
117: END IF;
118:
119: IF l_ShopFloorMove_rec.fm_operation_seq_num = FND_API.G_MISS_NUM THEN

Line 119: IF l_ShopFloorMove_rec.fm_operation_seq_num = FND_API.G_MISS_NUM THEN

115: IF l_ShopFloorMove_rec.fm_operation_code = FND_API.G_MISS_CHAR THEN
116: l_ShopFloorMove_rec.fm_operation_code := p_old_ShopFloorMove_rec.fm_operation_code;
117: END IF;
118:
119: IF l_ShopFloorMove_rec.fm_operation_seq_num = FND_API.G_MISS_NUM THEN
120: l_ShopFloorMove_rec.fm_operation_seq_num := p_old_ShopFloorMove_rec.fm_operation_seq_num;
121: END IF;
122:
123: IF l_ShopFloorMove_rec.group_id = FND_API.G_MISS_NUM THEN

Line 123: IF l_ShopFloorMove_rec.group_id = FND_API.G_MISS_NUM THEN

119: IF l_ShopFloorMove_rec.fm_operation_seq_num = FND_API.G_MISS_NUM THEN
120: l_ShopFloorMove_rec.fm_operation_seq_num := p_old_ShopFloorMove_rec.fm_operation_seq_num;
121: END IF;
122:
123: IF l_ShopFloorMove_rec.group_id = FND_API.G_MISS_NUM THEN
124: l_ShopFloorMove_rec.group_id := p_old_ShopFloorMove_rec.group_id;
125: END IF;
126:
127: IF l_ShopFloorMove_rec.kanban_card_id = FND_API.G_MISS_NUM THEN

Line 127: IF l_ShopFloorMove_rec.kanban_card_id = FND_API.G_MISS_NUM THEN

123: IF l_ShopFloorMove_rec.group_id = FND_API.G_MISS_NUM THEN
124: l_ShopFloorMove_rec.group_id := p_old_ShopFloorMove_rec.group_id;
125: END IF;
126:
127: IF l_ShopFloorMove_rec.kanban_card_id = FND_API.G_MISS_NUM THEN
128: l_ShopFloorMove_rec.kanban_card_id := p_old_ShopFloorMove_rec.kanban_card_id;
129: END IF;
130:
131: IF l_ShopFloorMove_rec.last_updated_by = FND_API.G_MISS_NUM THEN

Line 131: IF l_ShopFloorMove_rec.last_updated_by = FND_API.G_MISS_NUM THEN

127: IF l_ShopFloorMove_rec.kanban_card_id = FND_API.G_MISS_NUM THEN
128: l_ShopFloorMove_rec.kanban_card_id := p_old_ShopFloorMove_rec.kanban_card_id;
129: END IF;
130:
131: IF l_ShopFloorMove_rec.last_updated_by = FND_API.G_MISS_NUM THEN
132: l_ShopFloorMove_rec.last_updated_by := p_old_ShopFloorMove_rec.last_updated_by;
133: END IF;
134:
135: IF l_ShopFloorMove_rec.last_updated_by_name = FND_API.G_MISS_CHAR THEN

Line 135: IF l_ShopFloorMove_rec.last_updated_by_name = FND_API.G_MISS_CHAR THEN

131: IF l_ShopFloorMove_rec.last_updated_by = FND_API.G_MISS_NUM THEN
132: l_ShopFloorMove_rec.last_updated_by := p_old_ShopFloorMove_rec.last_updated_by;
133: END IF;
134:
135: IF l_ShopFloorMove_rec.last_updated_by_name = FND_API.G_MISS_CHAR THEN
136: l_ShopFloorMove_rec.last_updated_by_name := p_old_ShopFloorMove_rec.last_updated_by_name;
137: END IF;
138:
139: IF l_ShopFloorMove_rec.last_update_date = FND_API.G_MISS_DATE THEN

Line 139: IF l_ShopFloorMove_rec.last_update_date = FND_API.G_MISS_DATE THEN

135: IF l_ShopFloorMove_rec.last_updated_by_name = FND_API.G_MISS_CHAR THEN
136: l_ShopFloorMove_rec.last_updated_by_name := p_old_ShopFloorMove_rec.last_updated_by_name;
137: END IF;
138:
139: IF l_ShopFloorMove_rec.last_update_date = FND_API.G_MISS_DATE THEN
140: l_ShopFloorMove_rec.last_update_date := p_old_ShopFloorMove_rec.last_update_date;
141: END IF;
142:
143: IF l_ShopFloorMove_rec.last_update_login = FND_API.G_MISS_NUM THEN

Line 143: IF l_ShopFloorMove_rec.last_update_login = FND_API.G_MISS_NUM THEN

139: IF l_ShopFloorMove_rec.last_update_date = FND_API.G_MISS_DATE THEN
140: l_ShopFloorMove_rec.last_update_date := p_old_ShopFloorMove_rec.last_update_date;
141: END IF;
142:
143: IF l_ShopFloorMove_rec.last_update_login = FND_API.G_MISS_NUM THEN
144: l_ShopFloorMove_rec.last_update_login := p_old_ShopFloorMove_rec.last_update_login;
145: END IF;
146:
147: IF l_ShopFloorMove_rec.line_code = FND_API.G_MISS_CHAR THEN

Line 147: IF l_ShopFloorMove_rec.line_code = FND_API.G_MISS_CHAR THEN

143: IF l_ShopFloorMove_rec.last_update_login = FND_API.G_MISS_NUM THEN
144: l_ShopFloorMove_rec.last_update_login := p_old_ShopFloorMove_rec.last_update_login;
145: END IF;
146:
147: IF l_ShopFloorMove_rec.line_code = FND_API.G_MISS_CHAR THEN
148: l_ShopFloorMove_rec.line_code := p_old_ShopFloorMove_rec.line_code;
149: END IF;
150:
151: IF l_ShopFloorMove_rec.line_id = FND_API.G_MISS_NUM THEN

Line 151: IF l_ShopFloorMove_rec.line_id = FND_API.G_MISS_NUM THEN

147: IF l_ShopFloorMove_rec.line_code = FND_API.G_MISS_CHAR THEN
148: l_ShopFloorMove_rec.line_code := p_old_ShopFloorMove_rec.line_code;
149: END IF;
150:
151: IF l_ShopFloorMove_rec.line_id = FND_API.G_MISS_NUM THEN
152: l_ShopFloorMove_rec.line_id := p_old_ShopFloorMove_rec.line_id;
153: END IF;
154:
155: IF l_ShopFloorMove_rec.organization_code = FND_API.G_MISS_CHAR THEN

Line 155: IF l_ShopFloorMove_rec.organization_code = FND_API.G_MISS_CHAR THEN

151: IF l_ShopFloorMove_rec.line_id = FND_API.G_MISS_NUM THEN
152: l_ShopFloorMove_rec.line_id := p_old_ShopFloorMove_rec.line_id;
153: END IF;
154:
155: IF l_ShopFloorMove_rec.organization_code = FND_API.G_MISS_CHAR THEN
156: l_ShopFloorMove_rec.organization_code := p_old_ShopFloorMove_rec.organization_code;
157: END IF;
158:
159: IF l_ShopFloorMove_rec.organization_id = FND_API.G_MISS_NUM THEN

Line 159: IF l_ShopFloorMove_rec.organization_id = FND_API.G_MISS_NUM THEN

155: IF l_ShopFloorMove_rec.organization_code = FND_API.G_MISS_CHAR THEN
156: l_ShopFloorMove_rec.organization_code := p_old_ShopFloorMove_rec.organization_code;
157: END IF;
158:
159: IF l_ShopFloorMove_rec.organization_id = FND_API.G_MISS_NUM THEN
160: l_ShopFloorMove_rec.organization_id := p_old_ShopFloorMove_rec.organization_id;
161: END IF;
162:
163: IF l_ShopFloorMove_rec.overcpl_primary_qty = FND_API.G_MISS_NUM THEN

Line 163: IF l_ShopFloorMove_rec.overcpl_primary_qty = FND_API.G_MISS_NUM THEN

159: IF l_ShopFloorMove_rec.organization_id = FND_API.G_MISS_NUM THEN
160: l_ShopFloorMove_rec.organization_id := p_old_ShopFloorMove_rec.organization_id;
161: END IF;
162:
163: IF l_ShopFloorMove_rec.overcpl_primary_qty = FND_API.G_MISS_NUM THEN
164: l_ShopFloorMove_rec.overcpl_primary_qty := p_old_ShopFloorMove_rec.overcpl_primary_qty;
165: END IF;
166:
167: IF l_ShopFloorMove_rec.overcpl_transaction_id = FND_API.G_MISS_NUM THEN

Line 167: IF l_ShopFloorMove_rec.overcpl_transaction_id = FND_API.G_MISS_NUM THEN

163: IF l_ShopFloorMove_rec.overcpl_primary_qty = FND_API.G_MISS_NUM THEN
164: l_ShopFloorMove_rec.overcpl_primary_qty := p_old_ShopFloorMove_rec.overcpl_primary_qty;
165: END IF;
166:
167: IF l_ShopFloorMove_rec.overcpl_transaction_id = FND_API.G_MISS_NUM THEN
168: l_ShopFloorMove_rec.overcpl_transaction_id := p_old_ShopFloorMove_rec.overcpl_transaction_id;
169: END IF;
170:
171: IF l_ShopFloorMove_rec.overcpl_transaction_qty = FND_API.G_MISS_NUM THEN

Line 171: IF l_ShopFloorMove_rec.overcpl_transaction_qty = FND_API.G_MISS_NUM THEN

167: IF l_ShopFloorMove_rec.overcpl_transaction_id = FND_API.G_MISS_NUM THEN
168: l_ShopFloorMove_rec.overcpl_transaction_id := p_old_ShopFloorMove_rec.overcpl_transaction_id;
169: END IF;
170:
171: IF l_ShopFloorMove_rec.overcpl_transaction_qty = FND_API.G_MISS_NUM THEN
172: l_ShopFloorMove_rec.overcpl_transaction_qty := p_old_ShopFloorMove_rec.overcpl_transaction_qty;
173: END IF;
174:
175: IF l_ShopFloorMove_rec.primary_item_id = FND_API.G_MISS_NUM THEN

Line 175: IF l_ShopFloorMove_rec.primary_item_id = FND_API.G_MISS_NUM THEN

171: IF l_ShopFloorMove_rec.overcpl_transaction_qty = FND_API.G_MISS_NUM THEN
172: l_ShopFloorMove_rec.overcpl_transaction_qty := p_old_ShopFloorMove_rec.overcpl_transaction_qty;
173: END IF;
174:
175: IF l_ShopFloorMove_rec.primary_item_id = FND_API.G_MISS_NUM THEN
176: l_ShopFloorMove_rec.primary_item_id := p_old_ShopFloorMove_rec.primary_item_id;
177: END IF;
178:
179: IF l_ShopFloorMove_rec.primary_quantity = FND_API.G_MISS_NUM THEN

Line 179: IF l_ShopFloorMove_rec.primary_quantity = FND_API.G_MISS_NUM THEN

175: IF l_ShopFloorMove_rec.primary_item_id = FND_API.G_MISS_NUM THEN
176: l_ShopFloorMove_rec.primary_item_id := p_old_ShopFloorMove_rec.primary_item_id;
177: END IF;
178:
179: IF l_ShopFloorMove_rec.primary_quantity = FND_API.G_MISS_NUM THEN
180: l_ShopFloorMove_rec.primary_quantity := p_old_ShopFloorMove_rec.primary_quantity;
181: END IF;
182:
183: IF l_ShopFloorMove_rec.primary_uom = FND_API.G_MISS_CHAR THEN

Line 183: IF l_ShopFloorMove_rec.primary_uom = FND_API.G_MISS_CHAR THEN

179: IF l_ShopFloorMove_rec.primary_quantity = FND_API.G_MISS_NUM THEN
180: l_ShopFloorMove_rec.primary_quantity := p_old_ShopFloorMove_rec.primary_quantity;
181: END IF;
182:
183: IF l_ShopFloorMove_rec.primary_uom = FND_API.G_MISS_CHAR THEN
184: l_ShopFloorMove_rec.primary_uom := p_old_ShopFloorMove_rec.primary_uom;
185: END IF;
186:
187: IF l_ShopFloorMove_rec.process_phase = FND_API.G_MISS_NUM THEN

Line 187: IF l_ShopFloorMove_rec.process_phase = FND_API.G_MISS_NUM THEN

183: IF l_ShopFloorMove_rec.primary_uom = FND_API.G_MISS_CHAR THEN
184: l_ShopFloorMove_rec.primary_uom := p_old_ShopFloorMove_rec.primary_uom;
185: END IF;
186:
187: IF l_ShopFloorMove_rec.process_phase = FND_API.G_MISS_NUM THEN
188: l_ShopFloorMove_rec.process_phase := p_old_ShopFloorMove_rec.process_phase;
189: END IF;
190:
191: IF l_ShopFloorMove_rec.process_status = FND_API.G_MISS_NUM THEN

Line 191: IF l_ShopFloorMove_rec.process_status = FND_API.G_MISS_NUM THEN

187: IF l_ShopFloorMove_rec.process_phase = FND_API.G_MISS_NUM THEN
188: l_ShopFloorMove_rec.process_phase := p_old_ShopFloorMove_rec.process_phase;
189: END IF;
190:
191: IF l_ShopFloorMove_rec.process_status = FND_API.G_MISS_NUM THEN
192: l_ShopFloorMove_rec.process_status := p_old_ShopFloorMove_rec.process_status;
193: END IF;
194:
195: IF l_ShopFloorMove_rec.program_application_id = FND_API.G_MISS_NUM THEN

Line 195: IF l_ShopFloorMove_rec.program_application_id = FND_API.G_MISS_NUM THEN

191: IF l_ShopFloorMove_rec.process_status = FND_API.G_MISS_NUM THEN
192: l_ShopFloorMove_rec.process_status := p_old_ShopFloorMove_rec.process_status;
193: END IF;
194:
195: IF l_ShopFloorMove_rec.program_application_id = FND_API.G_MISS_NUM THEN
196: l_ShopFloorMove_rec.program_application_id := p_old_ShopFloorMove_rec.program_application_id;
197: END IF;
198:
199: IF l_ShopFloorMove_rec.program_id = FND_API.G_MISS_NUM THEN

Line 199: IF l_ShopFloorMove_rec.program_id = FND_API.G_MISS_NUM THEN

195: IF l_ShopFloorMove_rec.program_application_id = FND_API.G_MISS_NUM THEN
196: l_ShopFloorMove_rec.program_application_id := p_old_ShopFloorMove_rec.program_application_id;
197: END IF;
198:
199: IF l_ShopFloorMove_rec.program_id = FND_API.G_MISS_NUM THEN
200: l_ShopFloorMove_rec.program_id := p_old_ShopFloorMove_rec.program_id;
201: END IF;
202:
203: IF l_ShopFloorMove_rec.program_update_date = FND_API.G_MISS_DATE THEN

Line 203: IF l_ShopFloorMove_rec.program_update_date = FND_API.G_MISS_DATE THEN

199: IF l_ShopFloorMove_rec.program_id = FND_API.G_MISS_NUM THEN
200: l_ShopFloorMove_rec.program_id := p_old_ShopFloorMove_rec.program_id;
201: END IF;
202:
203: IF l_ShopFloorMove_rec.program_update_date = FND_API.G_MISS_DATE THEN
204: l_ShopFloorMove_rec.program_update_date := p_old_ShopFloorMove_rec.program_update_date;
205: END IF;
206:
207: IF l_ShopFloorMove_rec.qa_collection_id = FND_API.G_MISS_NUM THEN

Line 207: IF l_ShopFloorMove_rec.qa_collection_id = FND_API.G_MISS_NUM THEN

203: IF l_ShopFloorMove_rec.program_update_date = FND_API.G_MISS_DATE THEN
204: l_ShopFloorMove_rec.program_update_date := p_old_ShopFloorMove_rec.program_update_date;
205: END IF;
206:
207: IF l_ShopFloorMove_rec.qa_collection_id = FND_API.G_MISS_NUM THEN
208: l_ShopFloorMove_rec.qa_collection_id := p_old_ShopFloorMove_rec.qa_collection_id;
209: END IF;
210:
211: IF l_ShopFloorMove_rec.reason_id = FND_API.G_MISS_NUM THEN

Line 211: IF l_ShopFloorMove_rec.reason_id = FND_API.G_MISS_NUM THEN

207: IF l_ShopFloorMove_rec.qa_collection_id = FND_API.G_MISS_NUM THEN
208: l_ShopFloorMove_rec.qa_collection_id := p_old_ShopFloorMove_rec.qa_collection_id;
209: END IF;
210:
211: IF l_ShopFloorMove_rec.reason_id = FND_API.G_MISS_NUM THEN
212: l_ShopFloorMove_rec.reason_id := p_old_ShopFloorMove_rec.reason_id;
213: END IF;
214:
215: IF l_ShopFloorMove_rec.reason_name = FND_API.G_MISS_CHAR THEN

Line 215: IF l_ShopFloorMove_rec.reason_name = FND_API.G_MISS_CHAR THEN

211: IF l_ShopFloorMove_rec.reason_id = FND_API.G_MISS_NUM THEN
212: l_ShopFloorMove_rec.reason_id := p_old_ShopFloorMove_rec.reason_id;
213: END IF;
214:
215: IF l_ShopFloorMove_rec.reason_name = FND_API.G_MISS_CHAR THEN
216: l_ShopFloorMove_rec.reason_name := p_old_ShopFloorMove_rec.reason_name;
217: END IF;
218:
219: IF l_ShopFloorMove_rec.reference = FND_API.G_MISS_CHAR THEN

Line 219: IF l_ShopFloorMove_rec.reference = FND_API.G_MISS_CHAR THEN

215: IF l_ShopFloorMove_rec.reason_name = FND_API.G_MISS_CHAR THEN
216: l_ShopFloorMove_rec.reason_name := p_old_ShopFloorMove_rec.reason_name;
217: END IF;
218:
219: IF l_ShopFloorMove_rec.reference = FND_API.G_MISS_CHAR THEN
220: l_ShopFloorMove_rec.reference := p_old_ShopFloorMove_rec.reference;
221: END IF;
222:
223: IF l_ShopFloorMove_rec.repetitive_schedule_id = FND_API.G_MISS_NUM THEN

Line 223: IF l_ShopFloorMove_rec.repetitive_schedule_id = FND_API.G_MISS_NUM THEN

219: IF l_ShopFloorMove_rec.reference = FND_API.G_MISS_CHAR THEN
220: l_ShopFloorMove_rec.reference := p_old_ShopFloorMove_rec.reference;
221: END IF;
222:
223: IF l_ShopFloorMove_rec.repetitive_schedule_id = FND_API.G_MISS_NUM THEN
224: l_ShopFloorMove_rec.repetitive_schedule_id := p_old_ShopFloorMove_rec.repetitive_schedule_id;
225: END IF;
226:
227: IF l_ShopFloorMove_rec.request_id = FND_API.G_MISS_NUM THEN

Line 227: IF l_ShopFloorMove_rec.request_id = FND_API.G_MISS_NUM THEN

223: IF l_ShopFloorMove_rec.repetitive_schedule_id = FND_API.G_MISS_NUM THEN
224: l_ShopFloorMove_rec.repetitive_schedule_id := p_old_ShopFloorMove_rec.repetitive_schedule_id;
225: END IF;
226:
227: IF l_ShopFloorMove_rec.request_id = FND_API.G_MISS_NUM THEN
228: l_ShopFloorMove_rec.request_id := p_old_ShopFloorMove_rec.request_id;
229: END IF;
230:
231: IF l_ShopFloorMove_rec.scrap_account_id = FND_API.G_MISS_NUM THEN

Line 231: IF l_ShopFloorMove_rec.scrap_account_id = FND_API.G_MISS_NUM THEN

227: IF l_ShopFloorMove_rec.request_id = FND_API.G_MISS_NUM THEN
228: l_ShopFloorMove_rec.request_id := p_old_ShopFloorMove_rec.request_id;
229: END IF;
230:
231: IF l_ShopFloorMove_rec.scrap_account_id = FND_API.G_MISS_NUM THEN
232: l_ShopFloorMove_rec.scrap_account_id := p_old_ShopFloorMove_rec.scrap_account_id;
233: END IF;
234:
235: IF l_ShopFloorMove_rec.source_code = FND_API.G_MISS_CHAR THEN

Line 235: IF l_ShopFloorMove_rec.source_code = FND_API.G_MISS_CHAR THEN

231: IF l_ShopFloorMove_rec.scrap_account_id = FND_API.G_MISS_NUM THEN
232: l_ShopFloorMove_rec.scrap_account_id := p_old_ShopFloorMove_rec.scrap_account_id;
233: END IF;
234:
235: IF l_ShopFloorMove_rec.source_code = FND_API.G_MISS_CHAR THEN
236: l_ShopFloorMove_rec.source_code := p_old_ShopFloorMove_rec.source_code;
237: END IF;
238:
239: IF l_ShopFloorMove_rec.source_line_id = FND_API.G_MISS_NUM THEN

Line 239: IF l_ShopFloorMove_rec.source_line_id = FND_API.G_MISS_NUM THEN

235: IF l_ShopFloorMove_rec.source_code = FND_API.G_MISS_CHAR THEN
236: l_ShopFloorMove_rec.source_code := p_old_ShopFloorMove_rec.source_code;
237: END IF;
238:
239: IF l_ShopFloorMove_rec.source_line_id = FND_API.G_MISS_NUM THEN
240: l_ShopFloorMove_rec.source_line_id := p_old_ShopFloorMove_rec.source_line_id;
241: END IF;
242:
243: IF l_ShopFloorMove_rec.to_department_code = FND_API.G_MISS_CHAR THEN

Line 243: IF l_ShopFloorMove_rec.to_department_code = FND_API.G_MISS_CHAR THEN

239: IF l_ShopFloorMove_rec.source_line_id = FND_API.G_MISS_NUM THEN
240: l_ShopFloorMove_rec.source_line_id := p_old_ShopFloorMove_rec.source_line_id;
241: END IF;
242:
243: IF l_ShopFloorMove_rec.to_department_code = FND_API.G_MISS_CHAR THEN
244: l_ShopFloorMove_rec.to_department_code := p_old_ShopFloorMove_rec.to_department_code;
245: END IF;
246:
247: IF l_ShopFloorMove_rec.to_department_id = FND_API.G_MISS_NUM THEN

Line 247: IF l_ShopFloorMove_rec.to_department_id = FND_API.G_MISS_NUM THEN

243: IF l_ShopFloorMove_rec.to_department_code = FND_API.G_MISS_CHAR THEN
244: l_ShopFloorMove_rec.to_department_code := p_old_ShopFloorMove_rec.to_department_code;
245: END IF;
246:
247: IF l_ShopFloorMove_rec.to_department_id = FND_API.G_MISS_NUM THEN
248: l_ShopFloorMove_rec.to_department_id := p_old_ShopFloorMove_rec.to_department_id;
249: END IF;
250:
251: IF l_ShopFloorMove_rec.to_intraop_step_type = FND_API.G_MISS_NUM THEN

Line 251: IF l_ShopFloorMove_rec.to_intraop_step_type = FND_API.G_MISS_NUM THEN

247: IF l_ShopFloorMove_rec.to_department_id = FND_API.G_MISS_NUM THEN
248: l_ShopFloorMove_rec.to_department_id := p_old_ShopFloorMove_rec.to_department_id;
249: END IF;
250:
251: IF l_ShopFloorMove_rec.to_intraop_step_type = FND_API.G_MISS_NUM THEN
252: l_ShopFloorMove_rec.to_intraop_step_type := p_old_ShopFloorMove_rec.to_intraop_step_type;
253: END IF;
254:
255: IF l_ShopFloorMove_rec.to_operation_code = FND_API.G_MISS_CHAR THEN

Line 255: IF l_ShopFloorMove_rec.to_operation_code = FND_API.G_MISS_CHAR THEN

251: IF l_ShopFloorMove_rec.to_intraop_step_type = FND_API.G_MISS_NUM THEN
252: l_ShopFloorMove_rec.to_intraop_step_type := p_old_ShopFloorMove_rec.to_intraop_step_type;
253: END IF;
254:
255: IF l_ShopFloorMove_rec.to_operation_code = FND_API.G_MISS_CHAR THEN
256: l_ShopFloorMove_rec.to_operation_code := p_old_ShopFloorMove_rec.to_operation_code;
257: END IF;
258:
259: IF l_ShopFloorMove_rec.to_operation_seq_num = FND_API.G_MISS_NUM THEN

Line 259: IF l_ShopFloorMove_rec.to_operation_seq_num = FND_API.G_MISS_NUM THEN

255: IF l_ShopFloorMove_rec.to_operation_code = FND_API.G_MISS_CHAR THEN
256: l_ShopFloorMove_rec.to_operation_code := p_old_ShopFloorMove_rec.to_operation_code;
257: END IF;
258:
259: IF l_ShopFloorMove_rec.to_operation_seq_num = FND_API.G_MISS_NUM THEN
260: l_ShopFloorMove_rec.to_operation_seq_num := p_old_ShopFloorMove_rec.to_operation_seq_num;
261: END IF;
262:
263: IF l_ShopFloorMove_rec.transaction_date = FND_API.G_MISS_DATE THEN

Line 263: IF l_ShopFloorMove_rec.transaction_date = FND_API.G_MISS_DATE THEN

259: IF l_ShopFloorMove_rec.to_operation_seq_num = FND_API.G_MISS_NUM THEN
260: l_ShopFloorMove_rec.to_operation_seq_num := p_old_ShopFloorMove_rec.to_operation_seq_num;
261: END IF;
262:
263: IF l_ShopFloorMove_rec.transaction_date = FND_API.G_MISS_DATE THEN
264: l_ShopFloorMove_rec.transaction_date := p_old_ShopFloorMove_rec.transaction_date;
265: END IF;
266:
267: IF l_ShopFloorMove_rec.transaction_id = FND_API.G_MISS_NUM THEN

Line 267: IF l_ShopFloorMove_rec.transaction_id = FND_API.G_MISS_NUM THEN

263: IF l_ShopFloorMove_rec.transaction_date = FND_API.G_MISS_DATE THEN
264: l_ShopFloorMove_rec.transaction_date := p_old_ShopFloorMove_rec.transaction_date;
265: END IF;
266:
267: IF l_ShopFloorMove_rec.transaction_id = FND_API.G_MISS_NUM THEN
268: l_ShopFloorMove_rec.transaction_id := p_old_ShopFloorMove_rec.transaction_id;
269: END IF;
270:
271: IF l_ShopFloorMove_rec.transaction_quantity = FND_API.G_MISS_NUM THEN

Line 271: IF l_ShopFloorMove_rec.transaction_quantity = FND_API.G_MISS_NUM THEN

267: IF l_ShopFloorMove_rec.transaction_id = FND_API.G_MISS_NUM THEN
268: l_ShopFloorMove_rec.transaction_id := p_old_ShopFloorMove_rec.transaction_id;
269: END IF;
270:
271: IF l_ShopFloorMove_rec.transaction_quantity = FND_API.G_MISS_NUM THEN
272: l_ShopFloorMove_rec.transaction_quantity := p_old_ShopFloorMove_rec.transaction_quantity;
273: END IF;
274:
275: IF l_ShopFloorMove_rec.transaction_type = FND_API.G_MISS_NUM THEN

Line 275: IF l_ShopFloorMove_rec.transaction_type = FND_API.G_MISS_NUM THEN

271: IF l_ShopFloorMove_rec.transaction_quantity = FND_API.G_MISS_NUM THEN
272: l_ShopFloorMove_rec.transaction_quantity := p_old_ShopFloorMove_rec.transaction_quantity;
273: END IF;
274:
275: IF l_ShopFloorMove_rec.transaction_type = FND_API.G_MISS_NUM THEN
276: l_ShopFloorMove_rec.transaction_type := p_old_ShopFloorMove_rec.transaction_type;
277: END IF;
278:
279: IF l_ShopFloorMove_rec.transaction_uom = FND_API.G_MISS_CHAR THEN

Line 279: IF l_ShopFloorMove_rec.transaction_uom = FND_API.G_MISS_CHAR THEN

275: IF l_ShopFloorMove_rec.transaction_type = FND_API.G_MISS_NUM THEN
276: l_ShopFloorMove_rec.transaction_type := p_old_ShopFloorMove_rec.transaction_type;
277: END IF;
278:
279: IF l_ShopFloorMove_rec.transaction_uom = FND_API.G_MISS_CHAR THEN
280: l_ShopFloorMove_rec.transaction_uom := p_old_ShopFloorMove_rec.transaction_uom;
281: END IF;
282:
283: IF l_ShopFloorMove_rec.wip_entity_id = FND_API.G_MISS_NUM THEN

Line 283: IF l_ShopFloorMove_rec.wip_entity_id = FND_API.G_MISS_NUM THEN

279: IF l_ShopFloorMove_rec.transaction_uom = FND_API.G_MISS_CHAR THEN
280: l_ShopFloorMove_rec.transaction_uom := p_old_ShopFloorMove_rec.transaction_uom;
281: END IF;
282:
283: IF l_ShopFloorMove_rec.wip_entity_id = FND_API.G_MISS_NUM THEN
284: l_ShopFloorMove_rec.wip_entity_id := p_old_ShopFloorMove_rec.wip_entity_id;
285: END IF;
286:
287: IF l_ShopFloorMove_rec.wip_entity_name = FND_API.G_MISS_CHAR THEN

Line 287: IF l_ShopFloorMove_rec.wip_entity_name = FND_API.G_MISS_CHAR THEN

283: IF l_ShopFloorMove_rec.wip_entity_id = FND_API.G_MISS_NUM THEN
284: l_ShopFloorMove_rec.wip_entity_id := p_old_ShopFloorMove_rec.wip_entity_id;
285: END IF;
286:
287: IF l_ShopFloorMove_rec.wip_entity_name = FND_API.G_MISS_CHAR THEN
288: l_ShopFloorMove_rec.wip_entity_name := p_old_ShopFloorMove_rec.wip_entity_name;
289: END IF;
290:
291: RETURN l_ShopFloorMove_rec;

Line 304: IF l_ShopFloorMove_rec.acct_period_id = FND_API.G_MISS_NUM THEN

300: IS
301: l_ShopFloorMove_rec WIP_Transaction_PUB.Shopfloormove_Rec_Type := p_ShopFloorMove_rec;
302: BEGIN
303:
304: IF l_ShopFloorMove_rec.acct_period_id = FND_API.G_MISS_NUM THEN
305: l_ShopFloorMove_rec.acct_period_id := NULL;
306: END IF;
307:
308: IF l_ShopFloorMove_rec.attribute1 = FND_API.G_MISS_CHAR THEN

Line 308: IF l_ShopFloorMove_rec.attribute1 = FND_API.G_MISS_CHAR THEN

304: IF l_ShopFloorMove_rec.acct_period_id = FND_API.G_MISS_NUM THEN
305: l_ShopFloorMove_rec.acct_period_id := NULL;
306: END IF;
307:
308: IF l_ShopFloorMove_rec.attribute1 = FND_API.G_MISS_CHAR THEN
309: l_ShopFloorMove_rec.attribute1 := NULL;
310: END IF;
311:
312: IF l_ShopFloorMove_rec.attribute10 = FND_API.G_MISS_CHAR THEN

Line 312: IF l_ShopFloorMove_rec.attribute10 = FND_API.G_MISS_CHAR THEN

308: IF l_ShopFloorMove_rec.attribute1 = FND_API.G_MISS_CHAR THEN
309: l_ShopFloorMove_rec.attribute1 := NULL;
310: END IF;
311:
312: IF l_ShopFloorMove_rec.attribute10 = FND_API.G_MISS_CHAR THEN
313: l_ShopFloorMove_rec.attribute10 := NULL;
314: END IF;
315:
316: IF l_ShopFloorMove_rec.attribute11 = FND_API.G_MISS_CHAR THEN

Line 316: IF l_ShopFloorMove_rec.attribute11 = FND_API.G_MISS_CHAR THEN

312: IF l_ShopFloorMove_rec.attribute10 = FND_API.G_MISS_CHAR THEN
313: l_ShopFloorMove_rec.attribute10 := NULL;
314: END IF;
315:
316: IF l_ShopFloorMove_rec.attribute11 = FND_API.G_MISS_CHAR THEN
317: l_ShopFloorMove_rec.attribute11 := NULL;
318: END IF;
319:
320: IF l_ShopFloorMove_rec.attribute12 = FND_API.G_MISS_CHAR THEN

Line 320: IF l_ShopFloorMove_rec.attribute12 = FND_API.G_MISS_CHAR THEN

316: IF l_ShopFloorMove_rec.attribute11 = FND_API.G_MISS_CHAR THEN
317: l_ShopFloorMove_rec.attribute11 := NULL;
318: END IF;
319:
320: IF l_ShopFloorMove_rec.attribute12 = FND_API.G_MISS_CHAR THEN
321: l_ShopFloorMove_rec.attribute12 := NULL;
322: END IF;
323:
324: IF l_ShopFloorMove_rec.attribute13 = FND_API.G_MISS_CHAR THEN

Line 324: IF l_ShopFloorMove_rec.attribute13 = FND_API.G_MISS_CHAR THEN

320: IF l_ShopFloorMove_rec.attribute12 = FND_API.G_MISS_CHAR THEN
321: l_ShopFloorMove_rec.attribute12 := NULL;
322: END IF;
323:
324: IF l_ShopFloorMove_rec.attribute13 = FND_API.G_MISS_CHAR THEN
325: l_ShopFloorMove_rec.attribute13 := NULL;
326: END IF;
327:
328: IF l_ShopFloorMove_rec.attribute14 = FND_API.G_MISS_CHAR THEN

Line 328: IF l_ShopFloorMove_rec.attribute14 = FND_API.G_MISS_CHAR THEN

324: IF l_ShopFloorMove_rec.attribute13 = FND_API.G_MISS_CHAR THEN
325: l_ShopFloorMove_rec.attribute13 := NULL;
326: END IF;
327:
328: IF l_ShopFloorMove_rec.attribute14 = FND_API.G_MISS_CHAR THEN
329: l_ShopFloorMove_rec.attribute14 := NULL;
330: END IF;
331:
332: IF l_ShopFloorMove_rec.attribute15 = FND_API.G_MISS_CHAR THEN

Line 332: IF l_ShopFloorMove_rec.attribute15 = FND_API.G_MISS_CHAR THEN

328: IF l_ShopFloorMove_rec.attribute14 = FND_API.G_MISS_CHAR THEN
329: l_ShopFloorMove_rec.attribute14 := NULL;
330: END IF;
331:
332: IF l_ShopFloorMove_rec.attribute15 = FND_API.G_MISS_CHAR THEN
333: l_ShopFloorMove_rec.attribute15 := NULL;
334: END IF;
335:
336: IF l_ShopFloorMove_rec.attribute2 = FND_API.G_MISS_CHAR THEN

Line 336: IF l_ShopFloorMove_rec.attribute2 = FND_API.G_MISS_CHAR THEN

332: IF l_ShopFloorMove_rec.attribute15 = FND_API.G_MISS_CHAR THEN
333: l_ShopFloorMove_rec.attribute15 := NULL;
334: END IF;
335:
336: IF l_ShopFloorMove_rec.attribute2 = FND_API.G_MISS_CHAR THEN
337: l_ShopFloorMove_rec.attribute2 := NULL;
338: END IF;
339:
340: IF l_ShopFloorMove_rec.attribute3 = FND_API.G_MISS_CHAR THEN

Line 340: IF l_ShopFloorMove_rec.attribute3 = FND_API.G_MISS_CHAR THEN

336: IF l_ShopFloorMove_rec.attribute2 = FND_API.G_MISS_CHAR THEN
337: l_ShopFloorMove_rec.attribute2 := NULL;
338: END IF;
339:
340: IF l_ShopFloorMove_rec.attribute3 = FND_API.G_MISS_CHAR THEN
341: l_ShopFloorMove_rec.attribute3 := NULL;
342: END IF;
343:
344: IF l_ShopFloorMove_rec.attribute4 = FND_API.G_MISS_CHAR THEN

Line 344: IF l_ShopFloorMove_rec.attribute4 = FND_API.G_MISS_CHAR THEN

340: IF l_ShopFloorMove_rec.attribute3 = FND_API.G_MISS_CHAR THEN
341: l_ShopFloorMove_rec.attribute3 := NULL;
342: END IF;
343:
344: IF l_ShopFloorMove_rec.attribute4 = FND_API.G_MISS_CHAR THEN
345: l_ShopFloorMove_rec.attribute4 := NULL;
346: END IF;
347:
348: IF l_ShopFloorMove_rec.attribute5 = FND_API.G_MISS_CHAR THEN

Line 348: IF l_ShopFloorMove_rec.attribute5 = FND_API.G_MISS_CHAR THEN

344: IF l_ShopFloorMove_rec.attribute4 = FND_API.G_MISS_CHAR THEN
345: l_ShopFloorMove_rec.attribute4 := NULL;
346: END IF;
347:
348: IF l_ShopFloorMove_rec.attribute5 = FND_API.G_MISS_CHAR THEN
349: l_ShopFloorMove_rec.attribute5 := NULL;
350: END IF;
351:
352: IF l_ShopFloorMove_rec.attribute6 = FND_API.G_MISS_CHAR THEN

Line 352: IF l_ShopFloorMove_rec.attribute6 = FND_API.G_MISS_CHAR THEN

348: IF l_ShopFloorMove_rec.attribute5 = FND_API.G_MISS_CHAR THEN
349: l_ShopFloorMove_rec.attribute5 := NULL;
350: END IF;
351:
352: IF l_ShopFloorMove_rec.attribute6 = FND_API.G_MISS_CHAR THEN
353: l_ShopFloorMove_rec.attribute6 := NULL;
354: END IF;
355:
356: IF l_ShopFloorMove_rec.attribute7 = FND_API.G_MISS_CHAR THEN

Line 356: IF l_ShopFloorMove_rec.attribute7 = FND_API.G_MISS_CHAR THEN

352: IF l_ShopFloorMove_rec.attribute6 = FND_API.G_MISS_CHAR THEN
353: l_ShopFloorMove_rec.attribute6 := NULL;
354: END IF;
355:
356: IF l_ShopFloorMove_rec.attribute7 = FND_API.G_MISS_CHAR THEN
357: l_ShopFloorMove_rec.attribute7 := NULL;
358: END IF;
359:
360: IF l_ShopFloorMove_rec.attribute8 = FND_API.G_MISS_CHAR THEN

Line 360: IF l_ShopFloorMove_rec.attribute8 = FND_API.G_MISS_CHAR THEN

356: IF l_ShopFloorMove_rec.attribute7 = FND_API.G_MISS_CHAR THEN
357: l_ShopFloorMove_rec.attribute7 := NULL;
358: END IF;
359:
360: IF l_ShopFloorMove_rec.attribute8 = FND_API.G_MISS_CHAR THEN
361: l_ShopFloorMove_rec.attribute8 := NULL;
362: END IF;
363:
364: IF l_ShopFloorMove_rec.attribute9 = FND_API.G_MISS_CHAR THEN

Line 364: IF l_ShopFloorMove_rec.attribute9 = FND_API.G_MISS_CHAR THEN

360: IF l_ShopFloorMove_rec.attribute8 = FND_API.G_MISS_CHAR THEN
361: l_ShopFloorMove_rec.attribute8 := NULL;
362: END IF;
363:
364: IF l_ShopFloorMove_rec.attribute9 = FND_API.G_MISS_CHAR THEN
365: l_ShopFloorMove_rec.attribute9 := NULL;
366: END IF;
367:
368: IF l_ShopFloorMove_rec.attribute_category = FND_API.G_MISS_CHAR THEN

Line 368: IF l_ShopFloorMove_rec.attribute_category = FND_API.G_MISS_CHAR THEN

364: IF l_ShopFloorMove_rec.attribute9 = FND_API.G_MISS_CHAR THEN
365: l_ShopFloorMove_rec.attribute9 := NULL;
366: END IF;
367:
368: IF l_ShopFloorMove_rec.attribute_category = FND_API.G_MISS_CHAR THEN
369: l_ShopFloorMove_rec.attribute_category := NULL;
370: END IF;
371:
372: IF l_ShopFloorMove_rec.created_by = FND_API.G_MISS_NUM THEN

Line 372: IF l_ShopFloorMove_rec.created_by = FND_API.G_MISS_NUM THEN

368: IF l_ShopFloorMove_rec.attribute_category = FND_API.G_MISS_CHAR THEN
369: l_ShopFloorMove_rec.attribute_category := NULL;
370: END IF;
371:
372: IF l_ShopFloorMove_rec.created_by = FND_API.G_MISS_NUM THEN
373: l_ShopFloorMove_rec.created_by := NULL;
374: END IF;
375:
376: IF l_ShopFloorMove_rec.created_by_name = FND_API.G_MISS_CHAR THEN

Line 376: IF l_ShopFloorMove_rec.created_by_name = FND_API.G_MISS_CHAR THEN

372: IF l_ShopFloorMove_rec.created_by = FND_API.G_MISS_NUM THEN
373: l_ShopFloorMove_rec.created_by := NULL;
374: END IF;
375:
376: IF l_ShopFloorMove_rec.created_by_name = FND_API.G_MISS_CHAR THEN
377: l_ShopFloorMove_rec.created_by_name := NULL;
378: END IF;
379:
380: IF l_ShopFloorMove_rec.creation_date = FND_API.G_MISS_DATE THEN

Line 380: IF l_ShopFloorMove_rec.creation_date = FND_API.G_MISS_DATE THEN

376: IF l_ShopFloorMove_rec.created_by_name = FND_API.G_MISS_CHAR THEN
377: l_ShopFloorMove_rec.created_by_name := NULL;
378: END IF;
379:
380: IF l_ShopFloorMove_rec.creation_date = FND_API.G_MISS_DATE THEN
381: l_ShopFloorMove_rec.creation_date := NULL;
382: END IF;
383:
384: IF l_ShopFloorMove_rec.entity_type = FND_API.G_MISS_NUM THEN

Line 384: IF l_ShopFloorMove_rec.entity_type = FND_API.G_MISS_NUM THEN

380: IF l_ShopFloorMove_rec.creation_date = FND_API.G_MISS_DATE THEN
381: l_ShopFloorMove_rec.creation_date := NULL;
382: END IF;
383:
384: IF l_ShopFloorMove_rec.entity_type = FND_API.G_MISS_NUM THEN
385: l_ShopFloorMove_rec.entity_type := NULL;
386: END IF;
387:
388: IF l_ShopFloorMove_rec.fm_department_code = FND_API.G_MISS_CHAR THEN

Line 388: IF l_ShopFloorMove_rec.fm_department_code = FND_API.G_MISS_CHAR THEN

384: IF l_ShopFloorMove_rec.entity_type = FND_API.G_MISS_NUM THEN
385: l_ShopFloorMove_rec.entity_type := NULL;
386: END IF;
387:
388: IF l_ShopFloorMove_rec.fm_department_code = FND_API.G_MISS_CHAR THEN
389: l_ShopFloorMove_rec.fm_department_code := NULL;
390: END IF;
391:
392: IF l_ShopFloorMove_rec.fm_department_id = FND_API.G_MISS_NUM THEN

Line 392: IF l_ShopFloorMove_rec.fm_department_id = FND_API.G_MISS_NUM THEN

388: IF l_ShopFloorMove_rec.fm_department_code = FND_API.G_MISS_CHAR THEN
389: l_ShopFloorMove_rec.fm_department_code := NULL;
390: END IF;
391:
392: IF l_ShopFloorMove_rec.fm_department_id = FND_API.G_MISS_NUM THEN
393: l_ShopFloorMove_rec.fm_department_id := NULL;
394: END IF;
395:
396: IF l_ShopFloorMove_rec.fm_intraop_step_type = FND_API.G_MISS_NUM THEN

Line 396: IF l_ShopFloorMove_rec.fm_intraop_step_type = FND_API.G_MISS_NUM THEN

392: IF l_ShopFloorMove_rec.fm_department_id = FND_API.G_MISS_NUM THEN
393: l_ShopFloorMove_rec.fm_department_id := NULL;
394: END IF;
395:
396: IF l_ShopFloorMove_rec.fm_intraop_step_type = FND_API.G_MISS_NUM THEN
397: l_ShopFloorMove_rec.fm_intraop_step_type := NULL;
398: END IF;
399:
400: IF l_ShopFloorMove_rec.fm_operation_code = FND_API.G_MISS_CHAR THEN

Line 400: IF l_ShopFloorMove_rec.fm_operation_code = FND_API.G_MISS_CHAR THEN

396: IF l_ShopFloorMove_rec.fm_intraop_step_type = FND_API.G_MISS_NUM THEN
397: l_ShopFloorMove_rec.fm_intraop_step_type := NULL;
398: END IF;
399:
400: IF l_ShopFloorMove_rec.fm_operation_code = FND_API.G_MISS_CHAR THEN
401: l_ShopFloorMove_rec.fm_operation_code := NULL;
402: END IF;
403:
404: IF l_ShopFloorMove_rec.fm_operation_seq_num = FND_API.G_MISS_NUM THEN

Line 404: IF l_ShopFloorMove_rec.fm_operation_seq_num = FND_API.G_MISS_NUM THEN

400: IF l_ShopFloorMove_rec.fm_operation_code = FND_API.G_MISS_CHAR THEN
401: l_ShopFloorMove_rec.fm_operation_code := NULL;
402: END IF;
403:
404: IF l_ShopFloorMove_rec.fm_operation_seq_num = FND_API.G_MISS_NUM THEN
405: l_ShopFloorMove_rec.fm_operation_seq_num := NULL;
406: END IF;
407:
408: IF l_ShopFloorMove_rec.group_id = FND_API.G_MISS_NUM THEN

Line 408: IF l_ShopFloorMove_rec.group_id = FND_API.G_MISS_NUM THEN

404: IF l_ShopFloorMove_rec.fm_operation_seq_num = FND_API.G_MISS_NUM THEN
405: l_ShopFloorMove_rec.fm_operation_seq_num := NULL;
406: END IF;
407:
408: IF l_ShopFloorMove_rec.group_id = FND_API.G_MISS_NUM THEN
409: l_ShopFloorMove_rec.group_id := NULL;
410: END IF;
411:
412: IF l_ShopFloorMove_rec.kanban_card_id = FND_API.G_MISS_NUM THEN

Line 412: IF l_ShopFloorMove_rec.kanban_card_id = FND_API.G_MISS_NUM THEN

408: IF l_ShopFloorMove_rec.group_id = FND_API.G_MISS_NUM THEN
409: l_ShopFloorMove_rec.group_id := NULL;
410: END IF;
411:
412: IF l_ShopFloorMove_rec.kanban_card_id = FND_API.G_MISS_NUM THEN
413: l_ShopFloorMove_rec.kanban_card_id := NULL;
414: END IF;
415:
416: IF l_ShopFloorMove_rec.last_updated_by = FND_API.G_MISS_NUM THEN

Line 416: IF l_ShopFloorMove_rec.last_updated_by = FND_API.G_MISS_NUM THEN

412: IF l_ShopFloorMove_rec.kanban_card_id = FND_API.G_MISS_NUM THEN
413: l_ShopFloorMove_rec.kanban_card_id := NULL;
414: END IF;
415:
416: IF l_ShopFloorMove_rec.last_updated_by = FND_API.G_MISS_NUM THEN
417: l_ShopFloorMove_rec.last_updated_by := NULL;
418: END IF;
419:
420: IF l_ShopFloorMove_rec.last_updated_by_name = FND_API.G_MISS_CHAR THEN

Line 420: IF l_ShopFloorMove_rec.last_updated_by_name = FND_API.G_MISS_CHAR THEN

416: IF l_ShopFloorMove_rec.last_updated_by = FND_API.G_MISS_NUM THEN
417: l_ShopFloorMove_rec.last_updated_by := NULL;
418: END IF;
419:
420: IF l_ShopFloorMove_rec.last_updated_by_name = FND_API.G_MISS_CHAR THEN
421: l_ShopFloorMove_rec.last_updated_by_name := NULL;
422: END IF;
423:
424: IF l_ShopFloorMove_rec.last_update_date = FND_API.G_MISS_DATE THEN

Line 424: IF l_ShopFloorMove_rec.last_update_date = FND_API.G_MISS_DATE THEN

420: IF l_ShopFloorMove_rec.last_updated_by_name = FND_API.G_MISS_CHAR THEN
421: l_ShopFloorMove_rec.last_updated_by_name := NULL;
422: END IF;
423:
424: IF l_ShopFloorMove_rec.last_update_date = FND_API.G_MISS_DATE THEN
425: l_ShopFloorMove_rec.last_update_date := NULL;
426: END IF;
427:
428: IF l_ShopFloorMove_rec.last_update_login = FND_API.G_MISS_NUM THEN

Line 428: IF l_ShopFloorMove_rec.last_update_login = FND_API.G_MISS_NUM THEN

424: IF l_ShopFloorMove_rec.last_update_date = FND_API.G_MISS_DATE THEN
425: l_ShopFloorMove_rec.last_update_date := NULL;
426: END IF;
427:
428: IF l_ShopFloorMove_rec.last_update_login = FND_API.G_MISS_NUM THEN
429: l_ShopFloorMove_rec.last_update_login := NULL;
430: END IF;
431:
432: IF l_ShopFloorMove_rec.line_code = FND_API.G_MISS_CHAR THEN

Line 432: IF l_ShopFloorMove_rec.line_code = FND_API.G_MISS_CHAR THEN

428: IF l_ShopFloorMove_rec.last_update_login = FND_API.G_MISS_NUM THEN
429: l_ShopFloorMove_rec.last_update_login := NULL;
430: END IF;
431:
432: IF l_ShopFloorMove_rec.line_code = FND_API.G_MISS_CHAR THEN
433: l_ShopFloorMove_rec.line_code := NULL;
434: END IF;
435:
436: IF l_ShopFloorMove_rec.line_id = FND_API.G_MISS_NUM THEN

Line 436: IF l_ShopFloorMove_rec.line_id = FND_API.G_MISS_NUM THEN

432: IF l_ShopFloorMove_rec.line_code = FND_API.G_MISS_CHAR THEN
433: l_ShopFloorMove_rec.line_code := NULL;
434: END IF;
435:
436: IF l_ShopFloorMove_rec.line_id = FND_API.G_MISS_NUM THEN
437: l_ShopFloorMove_rec.line_id := NULL;
438: END IF;
439:
440: IF l_ShopFloorMove_rec.organization_code = FND_API.G_MISS_CHAR THEN

Line 440: IF l_ShopFloorMove_rec.organization_code = FND_API.G_MISS_CHAR THEN

436: IF l_ShopFloorMove_rec.line_id = FND_API.G_MISS_NUM THEN
437: l_ShopFloorMove_rec.line_id := NULL;
438: END IF;
439:
440: IF l_ShopFloorMove_rec.organization_code = FND_API.G_MISS_CHAR THEN
441: l_ShopFloorMove_rec.organization_code := NULL;
442: END IF;
443:
444: IF l_ShopFloorMove_rec.organization_id = FND_API.G_MISS_NUM THEN

Line 444: IF l_ShopFloorMove_rec.organization_id = FND_API.G_MISS_NUM THEN

440: IF l_ShopFloorMove_rec.organization_code = FND_API.G_MISS_CHAR THEN
441: l_ShopFloorMove_rec.organization_code := NULL;
442: END IF;
443:
444: IF l_ShopFloorMove_rec.organization_id = FND_API.G_MISS_NUM THEN
445: l_ShopFloorMove_rec.organization_id := NULL;
446: END IF;
447:
448: IF l_ShopFloorMove_rec.overcpl_primary_qty = FND_API.G_MISS_NUM THEN

Line 448: IF l_ShopFloorMove_rec.overcpl_primary_qty = FND_API.G_MISS_NUM THEN

444: IF l_ShopFloorMove_rec.organization_id = FND_API.G_MISS_NUM THEN
445: l_ShopFloorMove_rec.organization_id := NULL;
446: END IF;
447:
448: IF l_ShopFloorMove_rec.overcpl_primary_qty = FND_API.G_MISS_NUM THEN
449: l_ShopFloorMove_rec.overcpl_primary_qty := NULL;
450: END IF;
451:
452: IF l_ShopFloorMove_rec.overcpl_transaction_id = FND_API.G_MISS_NUM THEN

Line 452: IF l_ShopFloorMove_rec.overcpl_transaction_id = FND_API.G_MISS_NUM THEN

448: IF l_ShopFloorMove_rec.overcpl_primary_qty = FND_API.G_MISS_NUM THEN
449: l_ShopFloorMove_rec.overcpl_primary_qty := NULL;
450: END IF;
451:
452: IF l_ShopFloorMove_rec.overcpl_transaction_id = FND_API.G_MISS_NUM THEN
453: l_ShopFloorMove_rec.overcpl_transaction_id := NULL;
454: END IF;
455:
456: IF l_ShopFloorMove_rec.overcpl_transaction_qty = FND_API.G_MISS_NUM THEN

Line 456: IF l_ShopFloorMove_rec.overcpl_transaction_qty = FND_API.G_MISS_NUM THEN

452: IF l_ShopFloorMove_rec.overcpl_transaction_id = FND_API.G_MISS_NUM THEN
453: l_ShopFloorMove_rec.overcpl_transaction_id := NULL;
454: END IF;
455:
456: IF l_ShopFloorMove_rec.overcpl_transaction_qty = FND_API.G_MISS_NUM THEN
457: l_ShopFloorMove_rec.overcpl_transaction_qty := NULL;
458: END IF;
459:
460: IF l_ShopFloorMove_rec.primary_item_id = FND_API.G_MISS_NUM THEN

Line 460: IF l_ShopFloorMove_rec.primary_item_id = FND_API.G_MISS_NUM THEN

456: IF l_ShopFloorMove_rec.overcpl_transaction_qty = FND_API.G_MISS_NUM THEN
457: l_ShopFloorMove_rec.overcpl_transaction_qty := NULL;
458: END IF;
459:
460: IF l_ShopFloorMove_rec.primary_item_id = FND_API.G_MISS_NUM THEN
461: l_ShopFloorMove_rec.primary_item_id := NULL;
462: END IF;
463:
464: IF l_ShopFloorMove_rec.primary_quantity = FND_API.G_MISS_NUM THEN

Line 464: IF l_ShopFloorMove_rec.primary_quantity = FND_API.G_MISS_NUM THEN

460: IF l_ShopFloorMove_rec.primary_item_id = FND_API.G_MISS_NUM THEN
461: l_ShopFloorMove_rec.primary_item_id := NULL;
462: END IF;
463:
464: IF l_ShopFloorMove_rec.primary_quantity = FND_API.G_MISS_NUM THEN
465: l_ShopFloorMove_rec.primary_quantity := NULL;
466: END IF;
467:
468: IF l_ShopFloorMove_rec.primary_uom = FND_API.G_MISS_CHAR THEN

Line 468: IF l_ShopFloorMove_rec.primary_uom = FND_API.G_MISS_CHAR THEN

464: IF l_ShopFloorMove_rec.primary_quantity = FND_API.G_MISS_NUM THEN
465: l_ShopFloorMove_rec.primary_quantity := NULL;
466: END IF;
467:
468: IF l_ShopFloorMove_rec.primary_uom = FND_API.G_MISS_CHAR THEN
469: l_ShopFloorMove_rec.primary_uom := NULL;
470: END IF;
471:
472: IF l_ShopFloorMove_rec.process_phase = FND_API.G_MISS_NUM THEN

Line 472: IF l_ShopFloorMove_rec.process_phase = FND_API.G_MISS_NUM THEN

468: IF l_ShopFloorMove_rec.primary_uom = FND_API.G_MISS_CHAR THEN
469: l_ShopFloorMove_rec.primary_uom := NULL;
470: END IF;
471:
472: IF l_ShopFloorMove_rec.process_phase = FND_API.G_MISS_NUM THEN
473: l_ShopFloorMove_rec.process_phase := NULL;
474: END IF;
475:
476: IF l_ShopFloorMove_rec.process_status = FND_API.G_MISS_NUM THEN

Line 476: IF l_ShopFloorMove_rec.process_status = FND_API.G_MISS_NUM THEN

472: IF l_ShopFloorMove_rec.process_phase = FND_API.G_MISS_NUM THEN
473: l_ShopFloorMove_rec.process_phase := NULL;
474: END IF;
475:
476: IF l_ShopFloorMove_rec.process_status = FND_API.G_MISS_NUM THEN
477: l_ShopFloorMove_rec.process_status := NULL;
478: END IF;
479:
480: IF l_ShopFloorMove_rec.program_application_id = FND_API.G_MISS_NUM THEN

Line 480: IF l_ShopFloorMove_rec.program_application_id = FND_API.G_MISS_NUM THEN

476: IF l_ShopFloorMove_rec.process_status = FND_API.G_MISS_NUM THEN
477: l_ShopFloorMove_rec.process_status := NULL;
478: END IF;
479:
480: IF l_ShopFloorMove_rec.program_application_id = FND_API.G_MISS_NUM THEN
481: l_ShopFloorMove_rec.program_application_id := NULL;
482: END IF;
483:
484: IF l_ShopFloorMove_rec.program_id = FND_API.G_MISS_NUM THEN

Line 484: IF l_ShopFloorMove_rec.program_id = FND_API.G_MISS_NUM THEN

480: IF l_ShopFloorMove_rec.program_application_id = FND_API.G_MISS_NUM THEN
481: l_ShopFloorMove_rec.program_application_id := NULL;
482: END IF;
483:
484: IF l_ShopFloorMove_rec.program_id = FND_API.G_MISS_NUM THEN
485: l_ShopFloorMove_rec.program_id := NULL;
486: END IF;
487:
488: IF l_ShopFloorMove_rec.program_update_date = FND_API.G_MISS_DATE THEN

Line 488: IF l_ShopFloorMove_rec.program_update_date = FND_API.G_MISS_DATE THEN

484: IF l_ShopFloorMove_rec.program_id = FND_API.G_MISS_NUM THEN
485: l_ShopFloorMove_rec.program_id := NULL;
486: END IF;
487:
488: IF l_ShopFloorMove_rec.program_update_date = FND_API.G_MISS_DATE THEN
489: l_ShopFloorMove_rec.program_update_date := NULL;
490: END IF;
491:
492: IF l_ShopFloorMove_rec.qa_collection_id = FND_API.G_MISS_NUM THEN

Line 492: IF l_ShopFloorMove_rec.qa_collection_id = FND_API.G_MISS_NUM THEN

488: IF l_ShopFloorMove_rec.program_update_date = FND_API.G_MISS_DATE THEN
489: l_ShopFloorMove_rec.program_update_date := NULL;
490: END IF;
491:
492: IF l_ShopFloorMove_rec.qa_collection_id = FND_API.G_MISS_NUM THEN
493: l_ShopFloorMove_rec.qa_collection_id := NULL;
494: END IF;
495:
496: IF l_ShopFloorMove_rec.reason_id = FND_API.G_MISS_NUM THEN

Line 496: IF l_ShopFloorMove_rec.reason_id = FND_API.G_MISS_NUM THEN

492: IF l_ShopFloorMove_rec.qa_collection_id = FND_API.G_MISS_NUM THEN
493: l_ShopFloorMove_rec.qa_collection_id := NULL;
494: END IF;
495:
496: IF l_ShopFloorMove_rec.reason_id = FND_API.G_MISS_NUM THEN
497: l_ShopFloorMove_rec.reason_id := NULL;
498: END IF;
499:
500: IF l_ShopFloorMove_rec.reason_name = FND_API.G_MISS_CHAR THEN

Line 500: IF l_ShopFloorMove_rec.reason_name = FND_API.G_MISS_CHAR THEN

496: IF l_ShopFloorMove_rec.reason_id = FND_API.G_MISS_NUM THEN
497: l_ShopFloorMove_rec.reason_id := NULL;
498: END IF;
499:
500: IF l_ShopFloorMove_rec.reason_name = FND_API.G_MISS_CHAR THEN
501: l_ShopFloorMove_rec.reason_name := NULL;
502: END IF;
503:
504: IF l_ShopFloorMove_rec.reference = FND_API.G_MISS_CHAR THEN

Line 504: IF l_ShopFloorMove_rec.reference = FND_API.G_MISS_CHAR THEN

500: IF l_ShopFloorMove_rec.reason_name = FND_API.G_MISS_CHAR THEN
501: l_ShopFloorMove_rec.reason_name := NULL;
502: END IF;
503:
504: IF l_ShopFloorMove_rec.reference = FND_API.G_MISS_CHAR THEN
505: l_ShopFloorMove_rec.reference := NULL;
506: END IF;
507:
508: IF l_ShopFloorMove_rec.repetitive_schedule_id = FND_API.G_MISS_NUM THEN

Line 508: IF l_ShopFloorMove_rec.repetitive_schedule_id = FND_API.G_MISS_NUM THEN

504: IF l_ShopFloorMove_rec.reference = FND_API.G_MISS_CHAR THEN
505: l_ShopFloorMove_rec.reference := NULL;
506: END IF;
507:
508: IF l_ShopFloorMove_rec.repetitive_schedule_id = FND_API.G_MISS_NUM THEN
509: l_ShopFloorMove_rec.repetitive_schedule_id := NULL;
510: END IF;
511:
512: IF l_ShopFloorMove_rec.request_id = FND_API.G_MISS_NUM THEN

Line 512: IF l_ShopFloorMove_rec.request_id = FND_API.G_MISS_NUM THEN

508: IF l_ShopFloorMove_rec.repetitive_schedule_id = FND_API.G_MISS_NUM THEN
509: l_ShopFloorMove_rec.repetitive_schedule_id := NULL;
510: END IF;
511:
512: IF l_ShopFloorMove_rec.request_id = FND_API.G_MISS_NUM THEN
513: l_ShopFloorMove_rec.request_id := NULL;
514: END IF;
515:
516: IF l_ShopFloorMove_rec.scrap_account_id = FND_API.G_MISS_NUM THEN

Line 516: IF l_ShopFloorMove_rec.scrap_account_id = FND_API.G_MISS_NUM THEN

512: IF l_ShopFloorMove_rec.request_id = FND_API.G_MISS_NUM THEN
513: l_ShopFloorMove_rec.request_id := NULL;
514: END IF;
515:
516: IF l_ShopFloorMove_rec.scrap_account_id = FND_API.G_MISS_NUM THEN
517: l_ShopFloorMove_rec.scrap_account_id := NULL;
518: END IF;
519:
520: IF l_ShopFloorMove_rec.source_code = FND_API.G_MISS_CHAR THEN

Line 520: IF l_ShopFloorMove_rec.source_code = FND_API.G_MISS_CHAR THEN

516: IF l_ShopFloorMove_rec.scrap_account_id = FND_API.G_MISS_NUM THEN
517: l_ShopFloorMove_rec.scrap_account_id := NULL;
518: END IF;
519:
520: IF l_ShopFloorMove_rec.source_code = FND_API.G_MISS_CHAR THEN
521: l_ShopFloorMove_rec.source_code := NULL;
522: END IF;
523:
524: IF l_ShopFloorMove_rec.source_line_id = FND_API.G_MISS_NUM THEN

Line 524: IF l_ShopFloorMove_rec.source_line_id = FND_API.G_MISS_NUM THEN

520: IF l_ShopFloorMove_rec.source_code = FND_API.G_MISS_CHAR THEN
521: l_ShopFloorMove_rec.source_code := NULL;
522: END IF;
523:
524: IF l_ShopFloorMove_rec.source_line_id = FND_API.G_MISS_NUM THEN
525: l_ShopFloorMove_rec.source_line_id := NULL;
526: END IF;
527:
528: IF l_ShopFloorMove_rec.to_department_code = FND_API.G_MISS_CHAR THEN

Line 528: IF l_ShopFloorMove_rec.to_department_code = FND_API.G_MISS_CHAR THEN

524: IF l_ShopFloorMove_rec.source_line_id = FND_API.G_MISS_NUM THEN
525: l_ShopFloorMove_rec.source_line_id := NULL;
526: END IF;
527:
528: IF l_ShopFloorMove_rec.to_department_code = FND_API.G_MISS_CHAR THEN
529: l_ShopFloorMove_rec.to_department_code := NULL;
530: END IF;
531:
532: IF l_ShopFloorMove_rec.to_department_id = FND_API.G_MISS_NUM THEN

Line 532: IF l_ShopFloorMove_rec.to_department_id = FND_API.G_MISS_NUM THEN

528: IF l_ShopFloorMove_rec.to_department_code = FND_API.G_MISS_CHAR THEN
529: l_ShopFloorMove_rec.to_department_code := NULL;
530: END IF;
531:
532: IF l_ShopFloorMove_rec.to_department_id = FND_API.G_MISS_NUM THEN
533: l_ShopFloorMove_rec.to_department_id := NULL;
534: END IF;
535:
536: IF l_ShopFloorMove_rec.to_intraop_step_type = FND_API.G_MISS_NUM THEN

Line 536: IF l_ShopFloorMove_rec.to_intraop_step_type = FND_API.G_MISS_NUM THEN

532: IF l_ShopFloorMove_rec.to_department_id = FND_API.G_MISS_NUM THEN
533: l_ShopFloorMove_rec.to_department_id := NULL;
534: END IF;
535:
536: IF l_ShopFloorMove_rec.to_intraop_step_type = FND_API.G_MISS_NUM THEN
537: l_ShopFloorMove_rec.to_intraop_step_type := NULL;
538: END IF;
539:
540: IF l_ShopFloorMove_rec.to_operation_code = FND_API.G_MISS_CHAR THEN

Line 540: IF l_ShopFloorMove_rec.to_operation_code = FND_API.G_MISS_CHAR THEN

536: IF l_ShopFloorMove_rec.to_intraop_step_type = FND_API.G_MISS_NUM THEN
537: l_ShopFloorMove_rec.to_intraop_step_type := NULL;
538: END IF;
539:
540: IF l_ShopFloorMove_rec.to_operation_code = FND_API.G_MISS_CHAR THEN
541: l_ShopFloorMove_rec.to_operation_code := NULL;
542: END IF;
543:
544: IF l_ShopFloorMove_rec.to_operation_seq_num = FND_API.G_MISS_NUM THEN

Line 544: IF l_ShopFloorMove_rec.to_operation_seq_num = FND_API.G_MISS_NUM THEN

540: IF l_ShopFloorMove_rec.to_operation_code = FND_API.G_MISS_CHAR THEN
541: l_ShopFloorMove_rec.to_operation_code := NULL;
542: END IF;
543:
544: IF l_ShopFloorMove_rec.to_operation_seq_num = FND_API.G_MISS_NUM THEN
545: l_ShopFloorMove_rec.to_operation_seq_num := NULL;
546: END IF;
547:
548: IF l_ShopFloorMove_rec.transaction_date = FND_API.G_MISS_DATE THEN

Line 548: IF l_ShopFloorMove_rec.transaction_date = FND_API.G_MISS_DATE THEN

544: IF l_ShopFloorMove_rec.to_operation_seq_num = FND_API.G_MISS_NUM THEN
545: l_ShopFloorMove_rec.to_operation_seq_num := NULL;
546: END IF;
547:
548: IF l_ShopFloorMove_rec.transaction_date = FND_API.G_MISS_DATE THEN
549: l_ShopFloorMove_rec.transaction_date := NULL;
550: END IF;
551:
552: IF l_ShopFloorMove_rec.transaction_id = FND_API.G_MISS_NUM THEN

Line 552: IF l_ShopFloorMove_rec.transaction_id = FND_API.G_MISS_NUM THEN

548: IF l_ShopFloorMove_rec.transaction_date = FND_API.G_MISS_DATE THEN
549: l_ShopFloorMove_rec.transaction_date := NULL;
550: END IF;
551:
552: IF l_ShopFloorMove_rec.transaction_id = FND_API.G_MISS_NUM THEN
553: l_ShopFloorMove_rec.transaction_id := NULL;
554: END IF;
555:
556: IF l_ShopFloorMove_rec.transaction_quantity = FND_API.G_MISS_NUM THEN

Line 556: IF l_ShopFloorMove_rec.transaction_quantity = FND_API.G_MISS_NUM THEN

552: IF l_ShopFloorMove_rec.transaction_id = FND_API.G_MISS_NUM THEN
553: l_ShopFloorMove_rec.transaction_id := NULL;
554: END IF;
555:
556: IF l_ShopFloorMove_rec.transaction_quantity = FND_API.G_MISS_NUM THEN
557: l_ShopFloorMove_rec.transaction_quantity := NULL;
558: END IF;
559:
560: IF l_ShopFloorMove_rec.transaction_type = FND_API.G_MISS_NUM THEN

Line 560: IF l_ShopFloorMove_rec.transaction_type = FND_API.G_MISS_NUM THEN

556: IF l_ShopFloorMove_rec.transaction_quantity = FND_API.G_MISS_NUM THEN
557: l_ShopFloorMove_rec.transaction_quantity := NULL;
558: END IF;
559:
560: IF l_ShopFloorMove_rec.transaction_type = FND_API.G_MISS_NUM THEN
561: l_ShopFloorMove_rec.transaction_type := NULL;
562: END IF;
563:
564: IF l_ShopFloorMove_rec.transaction_uom = FND_API.G_MISS_CHAR THEN

Line 564: IF l_ShopFloorMove_rec.transaction_uom = FND_API.G_MISS_CHAR THEN

560: IF l_ShopFloorMove_rec.transaction_type = FND_API.G_MISS_NUM THEN
561: l_ShopFloorMove_rec.transaction_type := NULL;
562: END IF;
563:
564: IF l_ShopFloorMove_rec.transaction_uom = FND_API.G_MISS_CHAR THEN
565: l_ShopFloorMove_rec.transaction_uom := NULL;
566: END IF;
567:
568: IF l_ShopFloorMove_rec.wip_entity_id = FND_API.G_MISS_NUM THEN

Line 568: IF l_ShopFloorMove_rec.wip_entity_id = FND_API.G_MISS_NUM THEN

564: IF l_ShopFloorMove_rec.transaction_uom = FND_API.G_MISS_CHAR THEN
565: l_ShopFloorMove_rec.transaction_uom := NULL;
566: END IF;
567:
568: IF l_ShopFloorMove_rec.wip_entity_id = FND_API.G_MISS_NUM THEN
569: l_ShopFloorMove_rec.wip_entity_id := NULL;
570: END IF;
571:
572: IF l_ShopFloorMove_rec.wip_entity_name = FND_API.G_MISS_CHAR THEN

Line 572: IF l_ShopFloorMove_rec.wip_entity_name = FND_API.G_MISS_CHAR THEN

568: IF l_ShopFloorMove_rec.wip_entity_id = FND_API.G_MISS_NUM THEN
569: l_ShopFloorMove_rec.wip_entity_id := NULL;
570: END IF;
571:
572: IF l_ShopFloorMove_rec.wip_entity_name = FND_API.G_MISS_CHAR THEN
573: l_ShopFloorMove_rec.wip_entity_name := NULL;
574: END IF;
575:
576: RETURN l_ShopFloorMove_rec;

Line 744: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

740: , 'Insert_Row'
741: );
742: END IF;
743:
744: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
745:
746: END Insert_Row;
747:
748: -- Procedure Delete_Row

Line 772: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

768: , 'Delete_Row'
769: );
770: END IF;
771:
772: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
773:
774: END Delete_Row;
775:
776: FUNCTION Query_Row

Line 872: WHERE ( TRANSACTION_ID = nvl(p_transaction_id,FND_API.G_MISS_NUM)

868: , TRANSACTION_UOM
869: , WIP_ENTITY_ID
870: , WIP_ENTITY_NAME
871: FROM WIP_MOVE_TXN_INTERFACE
872: WHERE ( TRANSACTION_ID = nvl(p_transaction_id,FND_API.G_MISS_NUM)
873: );
874:
875: BEGIN
876:

Line 961: p_transaction_id <> FND_API.G_MISS_NUM)

957:
958: IF
959: (p_transaction_id IS NOT NULL
960: AND
961: p_transaction_id <> FND_API.G_MISS_NUM)
962: AND
963: (l_ShopFloorMove_tbl.COUNT = 0)
964: THEN
965: RAISE NO_DATA_FOUND;

Line 975: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

971: RETURN l_ShopFloorMove_tbl;
972:
973: EXCEPTION
974:
975: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
976:
977: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
978:
979: WHEN OTHERS THEN

Line 977: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

973: EXCEPTION
974:
975: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
976:
977: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
978:
979: WHEN OTHERS THEN
980:
981: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

Line 989: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

985: , 'Query_Rows'
986: );
987: END IF;
988:
989: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
990:
991: END Query_Rows;
992:
993: