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_HL_PARAM_PKG dependencies on FND_API

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

76: last_update_login,
77: param_type,
78: lookup_type
79: ) VALUES (
80: DECODE( px_history_log_param_id, FND_API.G_MISS_NUM, NULL, px_history_log_param_id),
81: DECODE( p_entity_history_log_id, FND_API.G_MISS_NUM, NULL, p_entity_history_log_id),
82: DECODE( p_param_name, FND_API.g_miss_char, NULL, p_param_name),
83: DECODE( px_object_version_number, FND_API.G_MISS_NUM, 1, px_object_version_number),
84: DECODE( p_param_value, FND_API.g_miss_char, NULL, p_param_value),

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

77: param_type,
78: lookup_type
79: ) VALUES (
80: DECODE( px_history_log_param_id, FND_API.G_MISS_NUM, NULL, px_history_log_param_id),
81: DECODE( p_entity_history_log_id, FND_API.G_MISS_NUM, NULL, p_entity_history_log_id),
82: DECODE( p_param_name, FND_API.g_miss_char, NULL, p_param_name),
83: DECODE( px_object_version_number, FND_API.G_MISS_NUM, 1, px_object_version_number),
84: DECODE( p_param_value, FND_API.g_miss_char, NULL, p_param_value),
85: DECODE( p_created_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, p_created_by),

Line 82: DECODE( p_param_name, FND_API.g_miss_char, NULL, p_param_name),

78: lookup_type
79: ) VALUES (
80: DECODE( px_history_log_param_id, FND_API.G_MISS_NUM, NULL, px_history_log_param_id),
81: DECODE( p_entity_history_log_id, FND_API.G_MISS_NUM, NULL, p_entity_history_log_id),
82: DECODE( p_param_name, FND_API.g_miss_char, NULL, p_param_name),
83: DECODE( px_object_version_number, FND_API.G_MISS_NUM, 1, px_object_version_number),
84: DECODE( p_param_value, FND_API.g_miss_char, NULL, p_param_value),
85: DECODE( p_created_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, p_created_by),
86: DECODE( p_creation_date, FND_API.G_MISS_DATE, SYSDATE, p_creation_date),

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

79: ) VALUES (
80: DECODE( px_history_log_param_id, FND_API.G_MISS_NUM, NULL, px_history_log_param_id),
81: DECODE( p_entity_history_log_id, FND_API.G_MISS_NUM, NULL, p_entity_history_log_id),
82: DECODE( p_param_name, FND_API.g_miss_char, NULL, p_param_name),
83: DECODE( px_object_version_number, FND_API.G_MISS_NUM, 1, px_object_version_number),
84: DECODE( p_param_value, FND_API.g_miss_char, NULL, p_param_value),
85: DECODE( p_created_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, p_created_by),
86: DECODE( p_creation_date, FND_API.G_MISS_DATE, SYSDATE, p_creation_date),
87: DECODE( p_last_updated_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, p_last_updated_by),

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

80: DECODE( px_history_log_param_id, FND_API.G_MISS_NUM, NULL, px_history_log_param_id),
81: DECODE( p_entity_history_log_id, FND_API.G_MISS_NUM, NULL, p_entity_history_log_id),
82: DECODE( p_param_name, FND_API.g_miss_char, NULL, p_param_name),
83: DECODE( px_object_version_number, FND_API.G_MISS_NUM, 1, px_object_version_number),
84: DECODE( p_param_value, FND_API.g_miss_char, NULL, p_param_value),
85: DECODE( p_created_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, p_created_by),
86: DECODE( p_creation_date, FND_API.G_MISS_DATE, SYSDATE, p_creation_date),
87: DECODE( p_last_updated_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, p_last_updated_by),
88: DECODE( p_last_update_date, FND_API.G_MISS_DATE, SYSDATE, p_last_update_date),

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

81: DECODE( p_entity_history_log_id, FND_API.G_MISS_NUM, NULL, p_entity_history_log_id),
82: DECODE( p_param_name, FND_API.g_miss_char, NULL, p_param_name),
83: DECODE( px_object_version_number, FND_API.G_MISS_NUM, 1, px_object_version_number),
84: DECODE( p_param_value, FND_API.g_miss_char, NULL, p_param_value),
85: DECODE( p_created_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, p_created_by),
86: DECODE( p_creation_date, FND_API.G_MISS_DATE, SYSDATE, p_creation_date),
87: DECODE( p_last_updated_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, p_last_updated_by),
88: DECODE( p_last_update_date, FND_API.G_MISS_DATE, SYSDATE, p_last_update_date),
89: DECODE( p_last_update_login, FND_API.G_MISS_NUM, FND_GLOBAL.CONC_LOGIN_ID, p_last_update_login),

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

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

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

83: DECODE( px_object_version_number, FND_API.G_MISS_NUM, 1, px_object_version_number),
84: DECODE( p_param_value, FND_API.g_miss_char, NULL, p_param_value),
85: DECODE( p_created_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, p_created_by),
86: DECODE( p_creation_date, FND_API.G_MISS_DATE, SYSDATE, p_creation_date),
87: DECODE( p_last_updated_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, p_last_updated_by),
88: DECODE( p_last_update_date, FND_API.G_MISS_DATE, SYSDATE, p_last_update_date),
89: DECODE( p_last_update_login, FND_API.G_MISS_NUM, FND_GLOBAL.CONC_LOGIN_ID, p_last_update_login),
90: DECODE( p_param_type, FND_API.g_miss_char, NULL, p_param_type),
91: DECODE( p_lookup_type, FND_API.g_miss_char, NULL, p_lookup_type));

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

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

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

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

Line 90: DECODE( p_param_type, FND_API.g_miss_char, NULL, p_param_type),

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

Line 91: DECODE( p_lookup_type, FND_API.g_miss_char, NULL, p_lookup_type));

87: DECODE( p_last_updated_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, p_last_updated_by),
88: DECODE( p_last_update_date, FND_API.G_MISS_DATE, SYSDATE, p_last_update_date),
89: DECODE( p_last_update_login, FND_API.G_MISS_NUM, FND_GLOBAL.CONC_LOGIN_ID, p_last_update_login),
90: DECODE( p_param_type, FND_API.g_miss_char, NULL, p_param_type),
91: DECODE( p_lookup_type, FND_API.g_miss_char, NULL, p_lookup_type));
92:
93: END Insert_Row;
94:
95:

Line 126: history_log_param_id = DECODE( p_history_log_param_id, null, history_log_param_id, FND_API.G_MISS_NUM, null, p_history_log_param_id),

122: IS
123: BEGIN
124: Update pv_ge_history_log_params
125: SET
126: history_log_param_id = DECODE( p_history_log_param_id, null, history_log_param_id, FND_API.G_MISS_NUM, null, p_history_log_param_id),
127: entity_history_log_id = DECODE( p_entity_history_log_id, null, entity_history_log_id, FND_API.G_MISS_NUM, null, p_entity_history_log_id),
128: param_name = DECODE( p_param_name, null, param_name, FND_API.g_miss_char, null, p_param_name),
129: object_version_number = nvl(p_object_version_number,0) + 1 ,
130: param_value = DECODE( p_param_value, null, param_value, FND_API.g_miss_char, null, p_param_value),

Line 127: entity_history_log_id = DECODE( p_entity_history_log_id, null, entity_history_log_id, FND_API.G_MISS_NUM, null, p_entity_history_log_id),

123: BEGIN
124: Update pv_ge_history_log_params
125: SET
126: history_log_param_id = DECODE( p_history_log_param_id, null, history_log_param_id, FND_API.G_MISS_NUM, null, p_history_log_param_id),
127: entity_history_log_id = DECODE( p_entity_history_log_id, null, entity_history_log_id, FND_API.G_MISS_NUM, null, p_entity_history_log_id),
128: param_name = DECODE( p_param_name, null, param_name, FND_API.g_miss_char, null, p_param_name),
129: object_version_number = nvl(p_object_version_number,0) + 1 ,
130: param_value = DECODE( p_param_value, null, param_value, FND_API.g_miss_char, null, p_param_value),
131: last_updated_by = DECODE( p_last_updated_by, null, last_updated_by, FND_API.G_MISS_NUM, null, p_last_updated_by),

Line 128: param_name = DECODE( p_param_name, null, param_name, FND_API.g_miss_char, null, p_param_name),

124: Update pv_ge_history_log_params
125: SET
126: history_log_param_id = DECODE( p_history_log_param_id, null, history_log_param_id, FND_API.G_MISS_NUM, null, p_history_log_param_id),
127: entity_history_log_id = DECODE( p_entity_history_log_id, null, entity_history_log_id, FND_API.G_MISS_NUM, null, p_entity_history_log_id),
128: param_name = DECODE( p_param_name, null, param_name, FND_API.g_miss_char, null, p_param_name),
129: object_version_number = nvl(p_object_version_number,0) + 1 ,
130: param_value = DECODE( p_param_value, null, param_value, FND_API.g_miss_char, null, p_param_value),
131: last_updated_by = DECODE( p_last_updated_by, null, last_updated_by, FND_API.G_MISS_NUM, null, p_last_updated_by),
132: last_update_date = DECODE( p_last_update_date, null, last_update_date, FND_API.G_MISS_DATE, null, p_last_update_date),

Line 130: param_value = DECODE( p_param_value, null, param_value, FND_API.g_miss_char, null, p_param_value),

126: history_log_param_id = DECODE( p_history_log_param_id, null, history_log_param_id, FND_API.G_MISS_NUM, null, p_history_log_param_id),
127: entity_history_log_id = DECODE( p_entity_history_log_id, null, entity_history_log_id, FND_API.G_MISS_NUM, null, p_entity_history_log_id),
128: param_name = DECODE( p_param_name, null, param_name, FND_API.g_miss_char, null, p_param_name),
129: object_version_number = nvl(p_object_version_number,0) + 1 ,
130: param_value = DECODE( p_param_value, null, param_value, FND_API.g_miss_char, null, p_param_value),
131: last_updated_by = DECODE( p_last_updated_by, null, last_updated_by, FND_API.G_MISS_NUM, null, p_last_updated_by),
132: last_update_date = DECODE( p_last_update_date, null, last_update_date, FND_API.G_MISS_DATE, null, p_last_update_date),
133: last_update_login = DECODE( p_last_update_login, null, last_update_login, FND_API.G_MISS_NUM, null, p_last_update_login),
134: param_type = DECODE( p_param_type, null, p_param_type, FND_API.g_miss_char, null, p_param_type),

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

127: entity_history_log_id = DECODE( p_entity_history_log_id, null, entity_history_log_id, FND_API.G_MISS_NUM, null, p_entity_history_log_id),
128: param_name = DECODE( p_param_name, null, param_name, FND_API.g_miss_char, null, p_param_name),
129: object_version_number = nvl(p_object_version_number,0) + 1 ,
130: param_value = DECODE( p_param_value, null, param_value, FND_API.g_miss_char, null, p_param_value),
131: last_updated_by = DECODE( p_last_updated_by, null, last_updated_by, FND_API.G_MISS_NUM, null, p_last_updated_by),
132: last_update_date = DECODE( p_last_update_date, null, last_update_date, FND_API.G_MISS_DATE, null, p_last_update_date),
133: last_update_login = DECODE( p_last_update_login, null, last_update_login, FND_API.G_MISS_NUM, null, p_last_update_login),
134: param_type = DECODE( p_param_type, null, p_param_type, FND_API.g_miss_char, null, p_param_type),
135: lookup_type = DECODE( p_lookup_type, null, p_lookup_type, FND_API.g_miss_char, null, p_lookup_type)

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

128: param_name = DECODE( p_param_name, null, param_name, FND_API.g_miss_char, null, p_param_name),
129: object_version_number = nvl(p_object_version_number,0) + 1 ,
130: param_value = DECODE( p_param_value, null, param_value, FND_API.g_miss_char, null, p_param_value),
131: last_updated_by = DECODE( p_last_updated_by, null, last_updated_by, FND_API.G_MISS_NUM, null, p_last_updated_by),
132: last_update_date = DECODE( p_last_update_date, null, last_update_date, FND_API.G_MISS_DATE, null, p_last_update_date),
133: last_update_login = DECODE( p_last_update_login, null, last_update_login, FND_API.G_MISS_NUM, null, p_last_update_login),
134: param_type = DECODE( p_param_type, null, p_param_type, FND_API.g_miss_char, null, p_param_type),
135: lookup_type = DECODE( p_lookup_type, null, p_lookup_type, FND_API.g_miss_char, null, p_lookup_type)
136: WHERE history_log_param_id = p_history_log_param_id

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

129: object_version_number = nvl(p_object_version_number,0) + 1 ,
130: param_value = DECODE( p_param_value, null, param_value, FND_API.g_miss_char, null, p_param_value),
131: last_updated_by = DECODE( p_last_updated_by, null, last_updated_by, FND_API.G_MISS_NUM, null, p_last_updated_by),
132: last_update_date = DECODE( p_last_update_date, null, last_update_date, FND_API.G_MISS_DATE, null, p_last_update_date),
133: last_update_login = DECODE( p_last_update_login, null, last_update_login, FND_API.G_MISS_NUM, null, p_last_update_login),
134: param_type = DECODE( p_param_type, null, p_param_type, FND_API.g_miss_char, null, p_param_type),
135: lookup_type = DECODE( p_lookup_type, null, p_lookup_type, FND_API.g_miss_char, null, p_lookup_type)
136: WHERE history_log_param_id = p_history_log_param_id
137: AND object_version_number = p_object_version_number;

Line 134: param_type = DECODE( p_param_type, null, p_param_type, FND_API.g_miss_char, null, p_param_type),

130: param_value = DECODE( p_param_value, null, param_value, FND_API.g_miss_char, null, p_param_value),
131: last_updated_by = DECODE( p_last_updated_by, null, last_updated_by, FND_API.G_MISS_NUM, null, p_last_updated_by),
132: last_update_date = DECODE( p_last_update_date, null, last_update_date, FND_API.G_MISS_DATE, null, p_last_update_date),
133: last_update_login = DECODE( p_last_update_login, null, last_update_login, FND_API.G_MISS_NUM, null, p_last_update_login),
134: param_type = DECODE( p_param_type, null, p_param_type, FND_API.g_miss_char, null, p_param_type),
135: lookup_type = DECODE( p_lookup_type, null, p_lookup_type, FND_API.g_miss_char, null, p_lookup_type)
136: WHERE history_log_param_id = p_history_log_param_id
137: AND object_version_number = p_object_version_number;
138:

Line 135: lookup_type = DECODE( p_lookup_type, null, p_lookup_type, FND_API.g_miss_char, null, p_lookup_type)

131: last_updated_by = DECODE( p_last_updated_by, null, last_updated_by, FND_API.G_MISS_NUM, null, p_last_updated_by),
132: last_update_date = DECODE( p_last_update_date, null, last_update_date, FND_API.G_MISS_DATE, null, p_last_update_date),
133: last_update_login = DECODE( p_last_update_login, null, last_update_login, FND_API.G_MISS_NUM, null, p_last_update_login),
134: param_type = DECODE( p_param_type, null, p_param_type, FND_API.g_miss_char, null, p_param_type),
135: lookup_type = DECODE( p_lookup_type, null, p_lookup_type, FND_API.g_miss_char, null, p_lookup_type)
136: WHERE history_log_param_id = p_history_log_param_id
137: AND object_version_number = p_object_version_number;
138:
139:

Line 141: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 171: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

167: DELETE FROM pv_ge_history_log_params
168: WHERE history_log_param_id = p_history_log_param_id
169: AND object_version_number = p_object_version_number;
170: If (SQL%NOTFOUND) then
171: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
172: End If;
173: END Delete_Row ;
174:
175:

Line 209: RAISE FND_API.g_exc_error;

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