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.PV_GE_CHKLST_RESP_PKG dependencies on FND_API

Line 80: DECODE( px_chklst_response_id, FND_API.G_MISS_NUM, NULL, px_chklst_response_id),

76: last_updated_by,
77: last_update_date,
78: last_update_login
79: ) VALUES (
80: DECODE( px_chklst_response_id, FND_API.G_MISS_NUM, NULL, px_chklst_response_id),
81: DECODE( p_checklist_item_id, FND_API.G_MISS_NUM, NULL, p_checklist_item_id),
82: DECODE( px_object_version_number, FND_API.G_MISS_NUM, 1, px_object_version_number),
83: DECODE( p_arc_response_for_entity_code, FND_API.g_miss_char, NULL, p_arc_response_for_entity_code),
84: DECODE( p_response_flag, FND_API.g_miss_char, NULL, p_response_flag),

Line 81: DECODE( p_checklist_item_id, FND_API.G_MISS_NUM, NULL, p_checklist_item_id),

77: last_update_date,
78: last_update_login
79: ) VALUES (
80: DECODE( px_chklst_response_id, FND_API.G_MISS_NUM, NULL, px_chklst_response_id),
81: DECODE( p_checklist_item_id, FND_API.G_MISS_NUM, NULL, p_checklist_item_id),
82: DECODE( px_object_version_number, FND_API.G_MISS_NUM, 1, px_object_version_number),
83: DECODE( p_arc_response_for_entity_code, FND_API.g_miss_char, NULL, p_arc_response_for_entity_code),
84: DECODE( p_response_flag, FND_API.g_miss_char, NULL, p_response_flag),
85: DECODE( p_response_for_entity_id, FND_API.G_MISS_NUM, NULL, p_response_for_entity_id),

Line 82: DECODE( px_object_version_number, FND_API.G_MISS_NUM, 1, px_object_version_number),

78: last_update_login
79: ) VALUES (
80: DECODE( px_chklst_response_id, FND_API.G_MISS_NUM, NULL, px_chklst_response_id),
81: DECODE( p_checklist_item_id, FND_API.G_MISS_NUM, NULL, p_checklist_item_id),
82: DECODE( px_object_version_number, FND_API.G_MISS_NUM, 1, px_object_version_number),
83: DECODE( p_arc_response_for_entity_code, FND_API.g_miss_char, NULL, p_arc_response_for_entity_code),
84: DECODE( p_response_flag, FND_API.g_miss_char, NULL, p_response_flag),
85: DECODE( p_response_for_entity_id, FND_API.G_MISS_NUM, NULL, p_response_for_entity_id),
86: DECODE( p_created_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, p_created_by),

Line 83: DECODE( p_arc_response_for_entity_code, FND_API.g_miss_char, NULL, p_arc_response_for_entity_code),

79: ) VALUES (
80: DECODE( px_chklst_response_id, FND_API.G_MISS_NUM, NULL, px_chklst_response_id),
81: DECODE( p_checklist_item_id, FND_API.G_MISS_NUM, NULL, p_checklist_item_id),
82: DECODE( px_object_version_number, FND_API.G_MISS_NUM, 1, px_object_version_number),
83: DECODE( p_arc_response_for_entity_code, FND_API.g_miss_char, NULL, p_arc_response_for_entity_code),
84: DECODE( p_response_flag, FND_API.g_miss_char, NULL, p_response_flag),
85: DECODE( p_response_for_entity_id, FND_API.G_MISS_NUM, NULL, p_response_for_entity_id),
86: DECODE( p_created_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, p_created_by),
87: DECODE( p_creation_date, FND_API.G_MISS_DATE, SYSDATE, p_creation_date),

Line 84: DECODE( p_response_flag, FND_API.g_miss_char, NULL, p_response_flag),

80: DECODE( px_chklst_response_id, FND_API.G_MISS_NUM, NULL, px_chklst_response_id),
81: DECODE( p_checklist_item_id, FND_API.G_MISS_NUM, NULL, p_checklist_item_id),
82: DECODE( px_object_version_number, FND_API.G_MISS_NUM, 1, px_object_version_number),
83: DECODE( p_arc_response_for_entity_code, FND_API.g_miss_char, NULL, p_arc_response_for_entity_code),
84: DECODE( p_response_flag, FND_API.g_miss_char, NULL, p_response_flag),
85: DECODE( p_response_for_entity_id, FND_API.G_MISS_NUM, NULL, p_response_for_entity_id),
86: DECODE( p_created_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, p_created_by),
87: DECODE( p_creation_date, FND_API.G_MISS_DATE, SYSDATE, p_creation_date),
88: DECODE( p_last_updated_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, p_last_updated_by),

Line 85: DECODE( p_response_for_entity_id, FND_API.G_MISS_NUM, NULL, p_response_for_entity_id),

81: DECODE( p_checklist_item_id, FND_API.G_MISS_NUM, NULL, p_checklist_item_id),
82: DECODE( px_object_version_number, FND_API.G_MISS_NUM, 1, px_object_version_number),
83: DECODE( p_arc_response_for_entity_code, FND_API.g_miss_char, NULL, p_arc_response_for_entity_code),
84: DECODE( p_response_flag, FND_API.g_miss_char, NULL, p_response_flag),
85: DECODE( p_response_for_entity_id, FND_API.G_MISS_NUM, NULL, p_response_for_entity_id),
86: DECODE( p_created_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, p_created_by),
87: DECODE( p_creation_date, FND_API.G_MISS_DATE, SYSDATE, p_creation_date),
88: DECODE( p_last_updated_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, p_last_updated_by),
89: DECODE( p_last_update_date, FND_API.G_MISS_DATE, SYSDATE, p_last_update_date),

Line 86: DECODE( p_created_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, p_created_by),

82: DECODE( px_object_version_number, FND_API.G_MISS_NUM, 1, px_object_version_number),
83: DECODE( p_arc_response_for_entity_code, FND_API.g_miss_char, NULL, p_arc_response_for_entity_code),
84: DECODE( p_response_flag, FND_API.g_miss_char, NULL, p_response_flag),
85: DECODE( p_response_for_entity_id, FND_API.G_MISS_NUM, NULL, p_response_for_entity_id),
86: DECODE( p_created_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, p_created_by),
87: DECODE( p_creation_date, FND_API.G_MISS_DATE, SYSDATE, p_creation_date),
88: DECODE( p_last_updated_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, p_last_updated_by),
89: DECODE( p_last_update_date, FND_API.G_MISS_DATE, SYSDATE, p_last_update_date),
90: DECODE( p_last_update_login, FND_API.G_MISS_NUM, FND_GLOBAL.CONC_LOGIN_ID, p_last_update_login));

Line 87: DECODE( p_creation_date, FND_API.G_MISS_DATE, SYSDATE, p_creation_date),

83: DECODE( p_arc_response_for_entity_code, FND_API.g_miss_char, NULL, p_arc_response_for_entity_code),
84: DECODE( p_response_flag, FND_API.g_miss_char, NULL, p_response_flag),
85: DECODE( p_response_for_entity_id, FND_API.G_MISS_NUM, NULL, p_response_for_entity_id),
86: DECODE( p_created_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, p_created_by),
87: DECODE( p_creation_date, FND_API.G_MISS_DATE, SYSDATE, p_creation_date),
88: DECODE( p_last_updated_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, p_last_updated_by),
89: DECODE( p_last_update_date, FND_API.G_MISS_DATE, SYSDATE, p_last_update_date),
90: DECODE( p_last_update_login, FND_API.G_MISS_NUM, FND_GLOBAL.CONC_LOGIN_ID, p_last_update_login));
91:

Line 88: DECODE( p_last_updated_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, p_last_updated_by),

84: DECODE( p_response_flag, FND_API.g_miss_char, NULL, p_response_flag),
85: DECODE( p_response_for_entity_id, FND_API.G_MISS_NUM, NULL, p_response_for_entity_id),
86: DECODE( p_created_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, p_created_by),
87: DECODE( p_creation_date, FND_API.G_MISS_DATE, SYSDATE, p_creation_date),
88: DECODE( p_last_updated_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, p_last_updated_by),
89: DECODE( p_last_update_date, FND_API.G_MISS_DATE, SYSDATE, p_last_update_date),
90: DECODE( p_last_update_login, FND_API.G_MISS_NUM, FND_GLOBAL.CONC_LOGIN_ID, p_last_update_login));
91:
92: END Insert_Row;

Line 89: DECODE( p_last_update_date, FND_API.G_MISS_DATE, SYSDATE, p_last_update_date),

85: DECODE( p_response_for_entity_id, FND_API.G_MISS_NUM, NULL, p_response_for_entity_id),
86: DECODE( p_created_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, p_created_by),
87: DECODE( p_creation_date, FND_API.G_MISS_DATE, SYSDATE, p_creation_date),
88: DECODE( p_last_updated_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, p_last_updated_by),
89: DECODE( p_last_update_date, FND_API.G_MISS_DATE, SYSDATE, p_last_update_date),
90: DECODE( p_last_update_login, FND_API.G_MISS_NUM, FND_GLOBAL.CONC_LOGIN_ID, p_last_update_login));
91:
92: END Insert_Row;
93:

Line 90: DECODE( p_last_update_login, FND_API.G_MISS_NUM, FND_GLOBAL.CONC_LOGIN_ID, p_last_update_login));

86: DECODE( p_created_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, p_created_by),
87: DECODE( p_creation_date, FND_API.G_MISS_DATE, SYSDATE, p_creation_date),
88: DECODE( p_last_updated_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, p_last_updated_by),
89: DECODE( p_last_update_date, FND_API.G_MISS_DATE, SYSDATE, p_last_update_date),
90: DECODE( p_last_update_login, FND_API.G_MISS_NUM, FND_GLOBAL.CONC_LOGIN_ID, p_last_update_login));
91:
92: END Insert_Row;
93:
94:

Line 124: chklst_response_id = DECODE( p_chklst_response_id, null, chklst_response_id, FND_API.G_MISS_NUM, null, p_chklst_response_id),

120: IS
121: BEGIN
122: Update pv_ge_chklst_responses
123: SET
124: chklst_response_id = DECODE( p_chklst_response_id, null, chklst_response_id, FND_API.G_MISS_NUM, null, p_chklst_response_id),
125: checklist_item_id = DECODE( p_checklist_item_id, null, checklist_item_id, FND_API.G_MISS_NUM, null, p_checklist_item_id),
126: object_version_number = nvl(p_object_version_number,0) + 1 ,
127: arc_response_for_entity_code = DECODE( p_arc_response_for_entity_code, null, arc_response_for_entity_code, FND_API.g_miss_char, null, p_arc_response_for_entity_code),
128: response_flag = DECODE( p_response_flag, null, response_flag, FND_API.g_miss_char, null, p_response_flag),

Line 125: checklist_item_id = DECODE( p_checklist_item_id, null, checklist_item_id, FND_API.G_MISS_NUM, null, p_checklist_item_id),

121: BEGIN
122: Update pv_ge_chklst_responses
123: SET
124: chklst_response_id = DECODE( p_chklst_response_id, null, chklst_response_id, FND_API.G_MISS_NUM, null, p_chklst_response_id),
125: checklist_item_id = DECODE( p_checklist_item_id, null, checklist_item_id, FND_API.G_MISS_NUM, null, p_checklist_item_id),
126: object_version_number = nvl(p_object_version_number,0) + 1 ,
127: arc_response_for_entity_code = DECODE( p_arc_response_for_entity_code, null, arc_response_for_entity_code, FND_API.g_miss_char, null, p_arc_response_for_entity_code),
128: response_flag = DECODE( p_response_flag, null, response_flag, FND_API.g_miss_char, null, p_response_flag),
129: response_for_entity_id = DECODE( p_response_for_entity_id, null, response_for_entity_id, FND_API.G_MISS_NUM, null, p_response_for_entity_id),

Line 127: arc_response_for_entity_code = DECODE( p_arc_response_for_entity_code, null, arc_response_for_entity_code, FND_API.g_miss_char, null, p_arc_response_for_entity_code),

123: SET
124: chklst_response_id = DECODE( p_chklst_response_id, null, chklst_response_id, FND_API.G_MISS_NUM, null, p_chklst_response_id),
125: checklist_item_id = DECODE( p_checklist_item_id, null, checklist_item_id, FND_API.G_MISS_NUM, null, p_checklist_item_id),
126: object_version_number = nvl(p_object_version_number,0) + 1 ,
127: arc_response_for_entity_code = DECODE( p_arc_response_for_entity_code, null, arc_response_for_entity_code, FND_API.g_miss_char, null, p_arc_response_for_entity_code),
128: response_flag = DECODE( p_response_flag, null, response_flag, FND_API.g_miss_char, null, p_response_flag),
129: response_for_entity_id = DECODE( p_response_for_entity_id, null, response_for_entity_id, FND_API.G_MISS_NUM, null, p_response_for_entity_id),
130: last_updated_by = DECODE( p_last_updated_by, null, last_updated_by, FND_API.G_MISS_NUM, null, p_last_updated_by),
131: last_update_date = DECODE( p_last_update_date, null, last_update_date, FND_API.G_MISS_DATE, null, p_last_update_date),

Line 128: response_flag = DECODE( p_response_flag, null, response_flag, FND_API.g_miss_char, null, p_response_flag),

124: chklst_response_id = DECODE( p_chklst_response_id, null, chklst_response_id, FND_API.G_MISS_NUM, null, p_chklst_response_id),
125: checklist_item_id = DECODE( p_checklist_item_id, null, checklist_item_id, FND_API.G_MISS_NUM, null, p_checklist_item_id),
126: object_version_number = nvl(p_object_version_number,0) + 1 ,
127: arc_response_for_entity_code = DECODE( p_arc_response_for_entity_code, null, arc_response_for_entity_code, FND_API.g_miss_char, null, p_arc_response_for_entity_code),
128: response_flag = DECODE( p_response_flag, null, response_flag, FND_API.g_miss_char, null, p_response_flag),
129: response_for_entity_id = DECODE( p_response_for_entity_id, null, response_for_entity_id, FND_API.G_MISS_NUM, null, p_response_for_entity_id),
130: last_updated_by = DECODE( p_last_updated_by, null, last_updated_by, FND_API.G_MISS_NUM, null, p_last_updated_by),
131: last_update_date = DECODE( p_last_update_date, null, last_update_date, FND_API.G_MISS_DATE, null, p_last_update_date),
132: last_update_login = DECODE( p_last_update_login, null, last_update_login, FND_API.G_MISS_NUM, null, p_last_update_login)

Line 129: response_for_entity_id = DECODE( p_response_for_entity_id, null, response_for_entity_id, FND_API.G_MISS_NUM, null, p_response_for_entity_id),

125: checklist_item_id = DECODE( p_checklist_item_id, null, checklist_item_id, FND_API.G_MISS_NUM, null, p_checklist_item_id),
126: object_version_number = nvl(p_object_version_number,0) + 1 ,
127: arc_response_for_entity_code = DECODE( p_arc_response_for_entity_code, null, arc_response_for_entity_code, FND_API.g_miss_char, null, p_arc_response_for_entity_code),
128: response_flag = DECODE( p_response_flag, null, response_flag, FND_API.g_miss_char, null, p_response_flag),
129: response_for_entity_id = DECODE( p_response_for_entity_id, null, response_for_entity_id, FND_API.G_MISS_NUM, null, p_response_for_entity_id),
130: last_updated_by = DECODE( p_last_updated_by, null, last_updated_by, FND_API.G_MISS_NUM, null, p_last_updated_by),
131: last_update_date = DECODE( p_last_update_date, null, last_update_date, FND_API.G_MISS_DATE, null, p_last_update_date),
132: last_update_login = DECODE( p_last_update_login, null, last_update_login, FND_API.G_MISS_NUM, null, p_last_update_login)
133: WHERE chklst_response_id = p_chklst_response_id

Line 130: last_updated_by = DECODE( p_last_updated_by, null, last_updated_by, FND_API.G_MISS_NUM, null, p_last_updated_by),

126: object_version_number = nvl(p_object_version_number,0) + 1 ,
127: arc_response_for_entity_code = DECODE( p_arc_response_for_entity_code, null, arc_response_for_entity_code, FND_API.g_miss_char, null, p_arc_response_for_entity_code),
128: response_flag = DECODE( p_response_flag, null, response_flag, FND_API.g_miss_char, null, p_response_flag),
129: response_for_entity_id = DECODE( p_response_for_entity_id, null, response_for_entity_id, FND_API.G_MISS_NUM, null, p_response_for_entity_id),
130: last_updated_by = DECODE( p_last_updated_by, null, last_updated_by, FND_API.G_MISS_NUM, null, p_last_updated_by),
131: last_update_date = DECODE( p_last_update_date, null, last_update_date, FND_API.G_MISS_DATE, null, p_last_update_date),
132: last_update_login = DECODE( p_last_update_login, null, last_update_login, FND_API.G_MISS_NUM, null, p_last_update_login)
133: WHERE chklst_response_id = p_chklst_response_id
134: AND object_version_number = p_object_version_number;

Line 131: last_update_date = DECODE( p_last_update_date, null, last_update_date, FND_API.G_MISS_DATE, null, p_last_update_date),

127: arc_response_for_entity_code = DECODE( p_arc_response_for_entity_code, null, arc_response_for_entity_code, FND_API.g_miss_char, null, p_arc_response_for_entity_code),
128: response_flag = DECODE( p_response_flag, null, response_flag, FND_API.g_miss_char, null, p_response_flag),
129: response_for_entity_id = DECODE( p_response_for_entity_id, null, response_for_entity_id, FND_API.G_MISS_NUM, null, p_response_for_entity_id),
130: last_updated_by = DECODE( p_last_updated_by, null, last_updated_by, FND_API.G_MISS_NUM, null, p_last_updated_by),
131: last_update_date = DECODE( p_last_update_date, null, last_update_date, FND_API.G_MISS_DATE, null, p_last_update_date),
132: last_update_login = DECODE( p_last_update_login, null, last_update_login, FND_API.G_MISS_NUM, null, p_last_update_login)
133: WHERE chklst_response_id = p_chklst_response_id
134: AND object_version_number = p_object_version_number;
135:

Line 132: last_update_login = DECODE( p_last_update_login, null, last_update_login, FND_API.G_MISS_NUM, null, p_last_update_login)

128: response_flag = DECODE( p_response_flag, null, response_flag, FND_API.g_miss_char, null, p_response_flag),
129: response_for_entity_id = DECODE( p_response_for_entity_id, null, response_for_entity_id, FND_API.G_MISS_NUM, null, p_response_for_entity_id),
130: last_updated_by = DECODE( p_last_updated_by, null, last_updated_by, FND_API.G_MISS_NUM, null, p_last_updated_by),
131: last_update_date = DECODE( p_last_update_date, null, last_update_date, FND_API.G_MISS_DATE, null, p_last_update_date),
132: last_update_login = DECODE( p_last_update_login, null, last_update_login, FND_API.G_MISS_NUM, null, p_last_update_login)
133: WHERE chklst_response_id = p_chklst_response_id
134: AND object_version_number = p_object_version_number;
135:
136:

Line 138: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

134: AND object_version_number = p_object_version_number;
135:
136:
137: IF (SQL%NOTFOUND) THEN
138: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
139: END IF;
140:
141:
142: END Update_Row;

Line 168: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

164: DELETE FROM pv_ge_chklst_responses
165: WHERE chklst_response_id = p_chklst_response_id
166: AND object_version_number = p_object_version_number;
167: If (SQL%NOTFOUND) then
168: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
169: End If;
170: END Delete_Row ;
171:
172:

Line 206: RAISE FND_API.g_exc_error;

202: FETCH c INTO Recinfo;
203: IF (c%NOTFOUND) THEN
204: CLOSE c;
205: AMS_Utility_PVT.error_message ('AMS_API_RECORD_NOT_FOUND');
206: RAISE FND_API.g_exc_error;
207: END IF;
208: CLOSE c;
209: END Lock_Row;
210: