eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.ENG_SUB_COMPONENT_UTIL dependencies on FND_API

Line 19: IF l_sub_component_rec.substitute_component_id = FND_API.G_MISS_NUM THEN

15: l_sub_component_rec Bom_Bo_Pub.Sub_Component_Rec_Type := p_sub_component_rec;
16: BEGIN
17:
18: /*
19: IF l_sub_component_rec.substitute_component_id = FND_API.G_MISS_NUM THEN
20: l_sub_component_rec.substitute_component_id := NULL;
21: END IF;
22:
23: IF l_sub_component_rec.last_update_date = FND_API.G_MISS_DATE THEN

Line 23: IF l_sub_component_rec.last_update_date = FND_API.G_MISS_DATE THEN

19: IF l_sub_component_rec.substitute_component_id = FND_API.G_MISS_NUM THEN
20: l_sub_component_rec.substitute_component_id := NULL;
21: END IF;
22:
23: IF l_sub_component_rec.last_update_date = FND_API.G_MISS_DATE THEN
24: l_sub_component_rec.last_update_date := NULL;
25: END IF;
26:
27: IF l_sub_component_rec.last_updated_by = FND_API.G_MISS_NUM THEN

Line 27: IF l_sub_component_rec.last_updated_by = FND_API.G_MISS_NUM THEN

23: IF l_sub_component_rec.last_update_date = FND_API.G_MISS_DATE THEN
24: l_sub_component_rec.last_update_date := NULL;
25: END IF;
26:
27: IF l_sub_component_rec.last_updated_by = FND_API.G_MISS_NUM THEN
28: l_sub_component_rec.last_updated_by := NULL;
29: END IF;
30:
31: IF l_sub_component_rec.creation_date = FND_API.G_MISS_DATE THEN

Line 31: IF l_sub_component_rec.creation_date = FND_API.G_MISS_DATE THEN

27: IF l_sub_component_rec.last_updated_by = FND_API.G_MISS_NUM THEN
28: l_sub_component_rec.last_updated_by := NULL;
29: END IF;
30:
31: IF l_sub_component_rec.creation_date = FND_API.G_MISS_DATE THEN
32: l_sub_component_rec.creation_date := NULL;
33: END IF;
34:
35: IF l_sub_component_rec.created_by = FND_API.G_MISS_NUM THEN

Line 35: IF l_sub_component_rec.created_by = FND_API.G_MISS_NUM THEN

31: IF l_sub_component_rec.creation_date = FND_API.G_MISS_DATE THEN
32: l_sub_component_rec.creation_date := NULL;
33: END IF;
34:
35: IF l_sub_component_rec.created_by = FND_API.G_MISS_NUM THEN
36: l_sub_component_rec.created_by := NULL;
37: END IF;
38:
39: IF l_sub_component_rec.last_update_login = FND_API.G_MISS_NUM THEN

Line 39: IF l_sub_component_rec.last_update_login = FND_API.G_MISS_NUM THEN

35: IF l_sub_component_rec.created_by = FND_API.G_MISS_NUM THEN
36: l_sub_component_rec.created_by := NULL;
37: END IF;
38:
39: IF l_sub_component_rec.last_update_login = FND_API.G_MISS_NUM THEN
40: l_sub_component_rec.last_update_login := NULL;
41: END IF;
42:
43: IF l_sub_component_rec.substitute_item_quantity = FND_API.G_MISS_NUM THEN

Line 43: IF l_sub_component_rec.substitute_item_quantity = FND_API.G_MISS_NUM THEN

39: IF l_sub_component_rec.last_update_login = FND_API.G_MISS_NUM THEN
40: l_sub_component_rec.last_update_login := NULL;
41: END IF;
42:
43: IF l_sub_component_rec.substitute_item_quantity = FND_API.G_MISS_NUM THEN
44: l_sub_component_rec.substitute_item_quantity := NULL;
45: END IF;
46:
47: IF l_sub_component_rec.component_sequence_id = FND_API.G_MISS_NUM THEN

Line 47: IF l_sub_component_rec.component_sequence_id = FND_API.G_MISS_NUM THEN

43: IF l_sub_component_rec.substitute_item_quantity = FND_API.G_MISS_NUM THEN
44: l_sub_component_rec.substitute_item_quantity := NULL;
45: END IF;
46:
47: IF l_sub_component_rec.component_sequence_id = FND_API.G_MISS_NUM THEN
48: l_sub_component_rec.component_sequence_id := NULL;
49: END IF;
50:
51: IF l_sub_component_rec.acd_type = FND_API.G_MISS_NUM THEN

Line 51: IF l_sub_component_rec.acd_type = FND_API.G_MISS_NUM THEN

47: IF l_sub_component_rec.component_sequence_id = FND_API.G_MISS_NUM THEN
48: l_sub_component_rec.component_sequence_id := NULL;
49: END IF;
50:
51: IF l_sub_component_rec.acd_type = FND_API.G_MISS_NUM THEN
52: l_sub_component_rec.acd_type := NULL;
53: END IF;
54:
55: IF l_sub_component_rec.change_notice = FND_API.G_MISS_CHAR THEN

Line 55: IF l_sub_component_rec.change_notice = FND_API.G_MISS_CHAR THEN

51: IF l_sub_component_rec.acd_type = FND_API.G_MISS_NUM THEN
52: l_sub_component_rec.acd_type := NULL;
53: END IF;
54:
55: IF l_sub_component_rec.change_notice = FND_API.G_MISS_CHAR THEN
56: l_sub_component_rec.change_notice := NULL;
57: END IF;
58:
59: IF l_sub_component_rec.request_id = FND_API.G_MISS_NUM THEN

Line 59: IF l_sub_component_rec.request_id = FND_API.G_MISS_NUM THEN

55: IF l_sub_component_rec.change_notice = FND_API.G_MISS_CHAR THEN
56: l_sub_component_rec.change_notice := NULL;
57: END IF;
58:
59: IF l_sub_component_rec.request_id = FND_API.G_MISS_NUM THEN
60: l_sub_component_rec.request_id := NULL;
61: END IF;
62:
63: IF l_sub_component_rec.program_application_id = FND_API.G_MISS_NUM THEN

Line 63: IF l_sub_component_rec.program_application_id = FND_API.G_MISS_NUM THEN

59: IF l_sub_component_rec.request_id = FND_API.G_MISS_NUM THEN
60: l_sub_component_rec.request_id := NULL;
61: END IF;
62:
63: IF l_sub_component_rec.program_application_id = FND_API.G_MISS_NUM THEN
64: l_sub_component_rec.program_application_id := NULL;
65: END IF;
66:
67: IF l_sub_component_rec.program_update_date = FND_API.G_MISS_DATE THEN

Line 67: IF l_sub_component_rec.program_update_date = FND_API.G_MISS_DATE THEN

63: IF l_sub_component_rec.program_application_id = FND_API.G_MISS_NUM THEN
64: l_sub_component_rec.program_application_id := NULL;
65: END IF;
66:
67: IF l_sub_component_rec.program_update_date = FND_API.G_MISS_DATE THEN
68: l_sub_component_rec.program_update_date := NULL;
69: END IF;
70:
71: IF l_sub_component_rec.attribute_category = FND_API.G_MISS_CHAR THEN

Line 71: IF l_sub_component_rec.attribute_category = FND_API.G_MISS_CHAR THEN

67: IF l_sub_component_rec.program_update_date = FND_API.G_MISS_DATE THEN
68: l_sub_component_rec.program_update_date := NULL;
69: END IF;
70:
71: IF l_sub_component_rec.attribute_category = FND_API.G_MISS_CHAR THEN
72: l_sub_component_rec.attribute_category := NULL;
73: END IF;
74:
75: IF l_sub_component_rec.attribute1 = FND_API.G_MISS_CHAR THEN

Line 75: IF l_sub_component_rec.attribute1 = FND_API.G_MISS_CHAR THEN

71: IF l_sub_component_rec.attribute_category = FND_API.G_MISS_CHAR THEN
72: l_sub_component_rec.attribute_category := NULL;
73: END IF;
74:
75: IF l_sub_component_rec.attribute1 = FND_API.G_MISS_CHAR THEN
76: l_sub_component_rec.attribute1 := NULL;
77: END IF;
78:
79: IF l_sub_component_rec.attribute2 = FND_API.G_MISS_CHAR THEN

Line 79: IF l_sub_component_rec.attribute2 = FND_API.G_MISS_CHAR THEN

75: IF l_sub_component_rec.attribute1 = FND_API.G_MISS_CHAR THEN
76: l_sub_component_rec.attribute1 := NULL;
77: END IF;
78:
79: IF l_sub_component_rec.attribute2 = FND_API.G_MISS_CHAR THEN
80: l_sub_component_rec.attribute2 := NULL;
81: END IF;
82:
83: IF l_sub_component_rec.attribute4 = FND_API.G_MISS_CHAR THEN

Line 83: IF l_sub_component_rec.attribute4 = FND_API.G_MISS_CHAR THEN

79: IF l_sub_component_rec.attribute2 = FND_API.G_MISS_CHAR THEN
80: l_sub_component_rec.attribute2 := NULL;
81: END IF;
82:
83: IF l_sub_component_rec.attribute4 = FND_API.G_MISS_CHAR THEN
84: l_sub_component_rec.attribute4 := NULL;
85: END IF;
86:
87: IF l_sub_component_rec.attribute5 = FND_API.G_MISS_CHAR THEN

Line 87: IF l_sub_component_rec.attribute5 = FND_API.G_MISS_CHAR THEN

83: IF l_sub_component_rec.attribute4 = FND_API.G_MISS_CHAR THEN
84: l_sub_component_rec.attribute4 := NULL;
85: END IF;
86:
87: IF l_sub_component_rec.attribute5 = FND_API.G_MISS_CHAR THEN
88: l_sub_component_rec.attribute5 := NULL;
89: END IF;
90:
91: IF l_sub_component_rec.attribute6 = FND_API.G_MISS_CHAR THEN

Line 91: IF l_sub_component_rec.attribute6 = FND_API.G_MISS_CHAR THEN

87: IF l_sub_component_rec.attribute5 = FND_API.G_MISS_CHAR THEN
88: l_sub_component_rec.attribute5 := NULL;
89: END IF;
90:
91: IF l_sub_component_rec.attribute6 = FND_API.G_MISS_CHAR THEN
92: l_sub_component_rec.attribute6 := NULL;
93: END IF;
94:
95: IF l_sub_component_rec.attribute8 = FND_API.G_MISS_CHAR THEN

Line 95: IF l_sub_component_rec.attribute8 = FND_API.G_MISS_CHAR THEN

91: IF l_sub_component_rec.attribute6 = FND_API.G_MISS_CHAR THEN
92: l_sub_component_rec.attribute6 := NULL;
93: END IF;
94:
95: IF l_sub_component_rec.attribute8 = FND_API.G_MISS_CHAR THEN
96: l_sub_component_rec.attribute8 := NULL;
97: END IF;
98:
99: IF l_sub_component_rec.attribute9 = FND_API.G_MISS_CHAR THEN

Line 99: IF l_sub_component_rec.attribute9 = FND_API.G_MISS_CHAR THEN

95: IF l_sub_component_rec.attribute8 = FND_API.G_MISS_CHAR THEN
96: l_sub_component_rec.attribute8 := NULL;
97: END IF;
98:
99: IF l_sub_component_rec.attribute9 = FND_API.G_MISS_CHAR THEN
100: l_sub_component_rec.attribute9 := NULL;
101: END IF;
102:
103: IF l_sub_component_rec.attribute10 = FND_API.G_MISS_CHAR THEN

Line 103: IF l_sub_component_rec.attribute10 = FND_API.G_MISS_CHAR THEN

99: IF l_sub_component_rec.attribute9 = FND_API.G_MISS_CHAR THEN
100: l_sub_component_rec.attribute9 := NULL;
101: END IF;
102:
103: IF l_sub_component_rec.attribute10 = FND_API.G_MISS_CHAR THEN
104: l_sub_component_rec.attribute10 := NULL;
105: END IF;
106:
107: IF l_sub_component_rec.attribute12 = FND_API.G_MISS_CHAR THEN

Line 107: IF l_sub_component_rec.attribute12 = FND_API.G_MISS_CHAR THEN

103: IF l_sub_component_rec.attribute10 = FND_API.G_MISS_CHAR THEN
104: l_sub_component_rec.attribute10 := NULL;
105: END IF;
106:
107: IF l_sub_component_rec.attribute12 = FND_API.G_MISS_CHAR THEN
108: l_sub_component_rec.attribute12 := NULL;
109: END IF;
110:
111: IF l_sub_component_rec.attribute13 = FND_API.G_MISS_CHAR THEN

Line 111: IF l_sub_component_rec.attribute13 = FND_API.G_MISS_CHAR THEN

107: IF l_sub_component_rec.attribute12 = FND_API.G_MISS_CHAR THEN
108: l_sub_component_rec.attribute12 := NULL;
109: END IF;
110:
111: IF l_sub_component_rec.attribute13 = FND_API.G_MISS_CHAR THEN
112: l_sub_component_rec.attribute13 := NULL;
113: END IF;
114:
115: IF l_sub_component_rec.attribute14 = FND_API.G_MISS_CHAR THEN

Line 115: IF l_sub_component_rec.attribute14 = FND_API.G_MISS_CHAR THEN

111: IF l_sub_component_rec.attribute13 = FND_API.G_MISS_CHAR THEN
112: l_sub_component_rec.attribute13 := NULL;
113: END IF;
114:
115: IF l_sub_component_rec.attribute14 = FND_API.G_MISS_CHAR THEN
116: l_sub_component_rec.attribute14 := NULL;
117: END IF;
118:
119: IF l_sub_component_rec.attribute15 = FND_API.G_MISS_CHAR THEN

Line 119: IF l_sub_component_rec.attribute15 = FND_API.G_MISS_CHAR THEN

115: IF l_sub_component_rec.attribute14 = FND_API.G_MISS_CHAR THEN
116: l_sub_component_rec.attribute14 := NULL;
117: END IF;
118:
119: IF l_sub_component_rec.attribute15 = FND_API.G_MISS_CHAR THEN
120: l_sub_component_rec.attribute15 := NULL;
121: END IF;
122:
123: IF l_sub_component_rec.program_id = FND_API.G_MISS_NUM THEN

Line 123: IF l_sub_component_rec.program_id = FND_API.G_MISS_NUM THEN

119: IF l_sub_component_rec.attribute15 = FND_API.G_MISS_CHAR THEN
120: l_sub_component_rec.attribute15 := NULL;
121: END IF;
122:
123: IF l_sub_component_rec.program_id = FND_API.G_MISS_NUM THEN
124: l_sub_component_rec.program_id := NULL;
125: END IF;
126:
127: IF l_sub_component_rec.attribute3 = FND_API.G_MISS_CHAR THEN

Line 127: IF l_sub_component_rec.attribute3 = FND_API.G_MISS_CHAR THEN

123: IF l_sub_component_rec.program_id = FND_API.G_MISS_NUM THEN
124: l_sub_component_rec.program_id := NULL;
125: END IF;
126:
127: IF l_sub_component_rec.attribute3 = FND_API.G_MISS_CHAR THEN
128: l_sub_component_rec.attribute3 := NULL;
129: END IF;
130:
131: IF l_sub_component_rec.attribute7 = FND_API.G_MISS_CHAR THEN

Line 131: IF l_sub_component_rec.attribute7 = FND_API.G_MISS_CHAR THEN

127: IF l_sub_component_rec.attribute3 = FND_API.G_MISS_CHAR THEN
128: l_sub_component_rec.attribute3 := NULL;
129: END IF;
130:
131: IF l_sub_component_rec.attribute7 = FND_API.G_MISS_CHAR THEN
132: l_sub_component_rec.attribute7 := NULL;
133: END IF;
134:
135: IF l_sub_component_rec.attribute11 = FND_API.G_MISS_CHAR THEN

Line 135: IF l_sub_component_rec.attribute11 = FND_API.G_MISS_CHAR THEN

131: IF l_sub_component_rec.attribute7 = FND_API.G_MISS_CHAR THEN
132: l_sub_component_rec.attribute7 := NULL;
133: END IF;
134:
135: IF l_sub_component_rec.attribute11 = FND_API.G_MISS_CHAR THEN
136: l_sub_component_rec.attribute11 := NULL;
137: END IF;
138:
139: */

Line 213: x_return_status := FND_API.G_RET_STS_SUCCESS;

209: ;
210: -- end if;
211: dbms_output.put_line('Update Row successful . . . ');
212:
213: x_return_status := FND_API.G_RET_STS_SUCCESS;
214: EXCEPTION
215:
216: WHEN NO_DATA_FOUND THEN
217: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

Line 226: x_return_status := FND_API.G_RET_STS_ERROR;

222: , x_Mesg_Token_Tbl => l_Mesg_Token_Tbl
223: );
224: END IF;
225:
226: x_return_status := FND_API.G_RET_STS_ERROR;
227: x_Mesg_Token_Tbl := l_Mesg_Token_Tbl;
228:
229: WHEN OTHERS THEN
230:

Line 246: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

242: , x_Mesg_Token_Tbl => l_Mesg_Token_Tbl
243: );
244: END IF;
245: x_Mesg_Token_Tbl := l_Mesg_Token_Tbl;
246: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
247:
248: END Update_Row;
249:
250: /********************************************************************

Line 343: x_return_status := FND_API.G_RET_STS_SUCCESS;

339: , Bom_Globals.Get_Prog_Id
340: , p_sub_component_rec.Original_System_Reference
341: );
342:
343: x_return_status := FND_API.G_RET_STS_SUCCESS;
344:
345: EXCEPTION
346:
347: WHEN OTHERS THEN

Line 361: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

357: , x_Mesg_Token_Tbl => l_Mesg_Token_Tbl
358: );
359: END IF;
360: x_Mesg_Token_Tbl := l_Mesg_Token_Tbl;
361: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
362:
363: END Insert_Row;
364:
365:

Line 407: x_return_status := FND_API.G_RET_STS_SUCCESS;

403: AND COMPONENT_SEQUENCE_ID = p_component_sequence_id
404: AND ACD_TYPE = p_acd_type
405: ;
406:
407: x_return_status := FND_API.G_RET_STS_SUCCESS;
408:
409: EXCEPTION
410:
411: WHEN OTHERS THEN

Line 427: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

423: , x_Mesg_Token_Tbl => l_Mesg_Token_Tbl
424: );
425: END IF;
426: x_Mesg_Token_Tbl := l_Mesg_Token_Tbl;
427: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
428:
429: END Delete_Row;
430:
431: /********************************************************************