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

Line 74: DECODE( px_Dm_Imp_Attribute_id, FND_API.G_MISS_NUM, NULL, px_Dm_Imp_Attribute_id),

70: source_field_id,
71: rank,
72: value
73: ) VALUES (
74: DECODE( px_Dm_Imp_Attribute_id, FND_API.G_MISS_NUM, NULL, px_Dm_Imp_Attribute_id),
75: DECODE( p_last_update_date, FND_API.G_MISS_DATE, SYSDATE, p_last_update_date),
76: DECODE( p_last_updated_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, p_last_updated_by),
77: DECODE( p_creation_date, FND_API.G_MISS_DATE, SYSDATE, p_creation_date),
78: DECODE( p_created_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, p_created_by),

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

71: rank,
72: value
73: ) VALUES (
74: DECODE( px_Dm_Imp_Attribute_id, FND_API.G_MISS_NUM, NULL, px_Dm_Imp_Attribute_id),
75: DECODE( p_last_update_date, FND_API.G_MISS_DATE, SYSDATE, p_last_update_date),
76: DECODE( p_last_updated_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, p_last_updated_by),
77: DECODE( p_creation_date, FND_API.G_MISS_DATE, SYSDATE, p_creation_date),
78: DECODE( p_created_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, p_created_by),
79: DECODE( p_last_update_login, FND_API.G_MISS_NUM, FND_GLOBAL.CONC_LOGIN_ID, p_last_update_login),

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

72: value
73: ) VALUES (
74: DECODE( px_Dm_Imp_Attribute_id, FND_API.G_MISS_NUM, NULL, px_Dm_Imp_Attribute_id),
75: DECODE( p_last_update_date, FND_API.G_MISS_DATE, SYSDATE, p_last_update_date),
76: DECODE( p_last_updated_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, p_last_updated_by),
77: DECODE( p_creation_date, FND_API.G_MISS_DATE, SYSDATE, p_creation_date),
78: DECODE( p_created_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, p_created_by),
79: DECODE( p_last_update_login, FND_API.G_MISS_NUM, FND_GLOBAL.CONC_LOGIN_ID, p_last_update_login),
80: DECODE( px_object_version_number, FND_API.G_MISS_NUM, 1, px_object_version_number),

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

73: ) VALUES (
74: DECODE( px_Dm_Imp_Attribute_id, FND_API.G_MISS_NUM, NULL, px_Dm_Imp_Attribute_id),
75: DECODE( p_last_update_date, FND_API.G_MISS_DATE, SYSDATE, p_last_update_date),
76: DECODE( p_last_updated_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, p_last_updated_by),
77: DECODE( p_creation_date, FND_API.G_MISS_DATE, SYSDATE, p_creation_date),
78: DECODE( p_created_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, p_created_by),
79: DECODE( p_last_update_login, FND_API.G_MISS_NUM, FND_GLOBAL.CONC_LOGIN_ID, p_last_update_login),
80: DECODE( px_object_version_number, FND_API.G_MISS_NUM, 1, px_object_version_number),
81: DECODE( p_model_id, FND_API.G_MISS_NUM, NULL, p_model_id),

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

74: DECODE( px_Dm_Imp_Attribute_id, FND_API.G_MISS_NUM, NULL, px_Dm_Imp_Attribute_id),
75: DECODE( p_last_update_date, FND_API.G_MISS_DATE, SYSDATE, p_last_update_date),
76: DECODE( p_last_updated_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, p_last_updated_by),
77: DECODE( p_creation_date, FND_API.G_MISS_DATE, SYSDATE, p_creation_date),
78: DECODE( p_created_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, p_created_by),
79: DECODE( p_last_update_login, FND_API.G_MISS_NUM, FND_GLOBAL.CONC_LOGIN_ID, p_last_update_login),
80: DECODE( px_object_version_number, FND_API.G_MISS_NUM, 1, px_object_version_number),
81: DECODE( p_model_id, FND_API.G_MISS_NUM, NULL, p_model_id),
82: DECODE( p_source_field_id, FND_API.G_MISS_NUM, NULL, p_source_field_id),

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

75: DECODE( p_last_update_date, FND_API.G_MISS_DATE, SYSDATE, p_last_update_date),
76: DECODE( p_last_updated_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, p_last_updated_by),
77: DECODE( p_creation_date, FND_API.G_MISS_DATE, SYSDATE, p_creation_date),
78: DECODE( p_created_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, p_created_by),
79: DECODE( p_last_update_login, FND_API.G_MISS_NUM, FND_GLOBAL.CONC_LOGIN_ID, p_last_update_login),
80: DECODE( px_object_version_number, FND_API.G_MISS_NUM, 1, px_object_version_number),
81: DECODE( p_model_id, FND_API.G_MISS_NUM, NULL, p_model_id),
82: DECODE( p_source_field_id, FND_API.G_MISS_NUM, NULL, p_source_field_id),
83: DECODE( p_rank, FND_API.G_MISS_NUM, NULL, p_rank),

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

76: DECODE( p_last_updated_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, p_last_updated_by),
77: DECODE( p_creation_date, FND_API.G_MISS_DATE, SYSDATE, p_creation_date),
78: DECODE( p_created_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, p_created_by),
79: DECODE( p_last_update_login, FND_API.G_MISS_NUM, FND_GLOBAL.CONC_LOGIN_ID, p_last_update_login),
80: DECODE( px_object_version_number, FND_API.G_MISS_NUM, 1, px_object_version_number),
81: DECODE( p_model_id, FND_API.G_MISS_NUM, NULL, p_model_id),
82: DECODE( p_source_field_id, FND_API.G_MISS_NUM, NULL, p_source_field_id),
83: DECODE( p_rank, FND_API.G_MISS_NUM, NULL, p_rank),
84: DECODE( p_value, FND_API.G_MISS_NUM, NULL, p_value));

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

77: DECODE( p_creation_date, FND_API.G_MISS_DATE, SYSDATE, p_creation_date),
78: DECODE( p_created_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, p_created_by),
79: DECODE( p_last_update_login, FND_API.G_MISS_NUM, FND_GLOBAL.CONC_LOGIN_ID, p_last_update_login),
80: DECODE( px_object_version_number, FND_API.G_MISS_NUM, 1, px_object_version_number),
81: DECODE( p_model_id, FND_API.G_MISS_NUM, NULL, p_model_id),
82: DECODE( p_source_field_id, FND_API.G_MISS_NUM, NULL, p_source_field_id),
83: DECODE( p_rank, FND_API.G_MISS_NUM, NULL, p_rank),
84: DECODE( p_value, FND_API.G_MISS_NUM, NULL, p_value));
85:

Line 82: DECODE( p_source_field_id, FND_API.G_MISS_NUM, NULL, p_source_field_id),

78: DECODE( p_created_by, FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, p_created_by),
79: DECODE( p_last_update_login, FND_API.G_MISS_NUM, FND_GLOBAL.CONC_LOGIN_ID, p_last_update_login),
80: DECODE( px_object_version_number, FND_API.G_MISS_NUM, 1, px_object_version_number),
81: DECODE( p_model_id, FND_API.G_MISS_NUM, NULL, p_model_id),
82: DECODE( p_source_field_id, FND_API.G_MISS_NUM, NULL, p_source_field_id),
83: DECODE( p_rank, FND_API.G_MISS_NUM, NULL, p_rank),
84: DECODE( p_value, FND_API.G_MISS_NUM, NULL, p_value));
85:
86: END Insert_Row;

Line 83: DECODE( p_rank, FND_API.G_MISS_NUM, NULL, p_rank),

79: DECODE( p_last_update_login, FND_API.G_MISS_NUM, FND_GLOBAL.CONC_LOGIN_ID, p_last_update_login),
80: DECODE( px_object_version_number, FND_API.G_MISS_NUM, 1, px_object_version_number),
81: DECODE( p_model_id, FND_API.G_MISS_NUM, NULL, p_model_id),
82: DECODE( p_source_field_id, FND_API.G_MISS_NUM, NULL, p_source_field_id),
83: DECODE( p_rank, FND_API.G_MISS_NUM, NULL, p_rank),
84: DECODE( p_value, FND_API.G_MISS_NUM, NULL, p_value));
85:
86: END Insert_Row;
87:

Line 84: DECODE( p_value, FND_API.G_MISS_NUM, NULL, p_value));

80: DECODE( px_object_version_number, FND_API.G_MISS_NUM, 1, px_object_version_number),
81: DECODE( p_model_id, FND_API.G_MISS_NUM, NULL, p_model_id),
82: DECODE( p_source_field_id, FND_API.G_MISS_NUM, NULL, p_source_field_id),
83: DECODE( p_rank, FND_API.G_MISS_NUM, NULL, p_rank),
84: DECODE( p_value, FND_API.G_MISS_NUM, NULL, p_value));
85:
86: END Insert_Row;
87:
88:

Line 118: imp_attribute_id = DECODE( p_Dm_Imp_Attribute_id, null, imp_attribute_id, FND_API.G_MISS_NUM, null, p_Dm_Imp_Attribute_id),

114: IS
115: BEGIN
116: Update ams_dm_imp_attributes
117: SET
118: imp_attribute_id = DECODE( p_Dm_Imp_Attribute_id, null, imp_attribute_id, FND_API.G_MISS_NUM, null, p_Dm_Imp_Attribute_id),
119: last_update_date = DECODE( p_last_update_date, null, last_update_date, FND_API.G_MISS_DATE, null, p_last_update_date),
120: last_updated_by = DECODE( p_last_updated_by, null, last_updated_by, FND_API.G_MISS_NUM, null, p_last_updated_by),
121: last_update_login = DECODE( p_last_update_login, null, last_update_login, FND_API.G_MISS_NUM, null, p_last_update_login),
122: object_version_number = object_version_number + 1,

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

115: BEGIN
116: Update ams_dm_imp_attributes
117: SET
118: imp_attribute_id = DECODE( p_Dm_Imp_Attribute_id, null, imp_attribute_id, FND_API.G_MISS_NUM, null, p_Dm_Imp_Attribute_id),
119: last_update_date = DECODE( p_last_update_date, null, last_update_date, FND_API.G_MISS_DATE, null, p_last_update_date),
120: last_updated_by = DECODE( p_last_updated_by, null, last_updated_by, FND_API.G_MISS_NUM, null, p_last_updated_by),
121: last_update_login = DECODE( p_last_update_login, null, last_update_login, FND_API.G_MISS_NUM, null, p_last_update_login),
122: object_version_number = object_version_number + 1,
123: model_id = DECODE( p_model_id, null, model_id, FND_API.G_MISS_NUM, null, p_model_id),

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

116: Update ams_dm_imp_attributes
117: SET
118: imp_attribute_id = DECODE( p_Dm_Imp_Attribute_id, null, imp_attribute_id, FND_API.G_MISS_NUM, null, p_Dm_Imp_Attribute_id),
119: last_update_date = DECODE( p_last_update_date, null, last_update_date, FND_API.G_MISS_DATE, null, p_last_update_date),
120: last_updated_by = DECODE( p_last_updated_by, null, last_updated_by, FND_API.G_MISS_NUM, null, p_last_updated_by),
121: last_update_login = DECODE( p_last_update_login, null, last_update_login, FND_API.G_MISS_NUM, null, p_last_update_login),
122: object_version_number = object_version_number + 1,
123: model_id = DECODE( p_model_id, null, model_id, FND_API.G_MISS_NUM, null, p_model_id),
124: source_field_id = DECODE( p_source_field_id, null, source_field_id, FND_API.G_MISS_NUM, null, p_source_field_id),

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

117: SET
118: imp_attribute_id = DECODE( p_Dm_Imp_Attribute_id, null, imp_attribute_id, FND_API.G_MISS_NUM, null, p_Dm_Imp_Attribute_id),
119: last_update_date = DECODE( p_last_update_date, null, last_update_date, FND_API.G_MISS_DATE, null, p_last_update_date),
120: last_updated_by = DECODE( p_last_updated_by, null, last_updated_by, FND_API.G_MISS_NUM, null, p_last_updated_by),
121: last_update_login = DECODE( p_last_update_login, null, last_update_login, FND_API.G_MISS_NUM, null, p_last_update_login),
122: object_version_number = object_version_number + 1,
123: model_id = DECODE( p_model_id, null, model_id, FND_API.G_MISS_NUM, null, p_model_id),
124: source_field_id = DECODE( p_source_field_id, null, source_field_id, FND_API.G_MISS_NUM, null, p_source_field_id),
125: rank = DECODE( p_rank, null, rank, FND_API.G_MISS_NUM, null, p_rank),

Line 123: model_id = DECODE( p_model_id, null, model_id, FND_API.G_MISS_NUM, null, p_model_id),

119: last_update_date = DECODE( p_last_update_date, null, last_update_date, FND_API.G_MISS_DATE, null, p_last_update_date),
120: last_updated_by = DECODE( p_last_updated_by, null, last_updated_by, FND_API.G_MISS_NUM, null, p_last_updated_by),
121: last_update_login = DECODE( p_last_update_login, null, last_update_login, FND_API.G_MISS_NUM, null, p_last_update_login),
122: object_version_number = object_version_number + 1,
123: model_id = DECODE( p_model_id, null, model_id, FND_API.G_MISS_NUM, null, p_model_id),
124: source_field_id = DECODE( p_source_field_id, null, source_field_id, FND_API.G_MISS_NUM, null, p_source_field_id),
125: rank = DECODE( p_rank, null, rank, FND_API.G_MISS_NUM, null, p_rank),
126: value = DECODE( p_value, null, value, FND_API.G_MISS_NUM, null, p_value)
127: WHERE imp_attribute_id = p_Dm_Imp_Attribute_id

Line 124: source_field_id = DECODE( p_source_field_id, null, source_field_id, FND_API.G_MISS_NUM, null, p_source_field_id),

120: last_updated_by = DECODE( p_last_updated_by, null, last_updated_by, FND_API.G_MISS_NUM, null, p_last_updated_by),
121: last_update_login = DECODE( p_last_update_login, null, last_update_login, FND_API.G_MISS_NUM, null, p_last_update_login),
122: object_version_number = object_version_number + 1,
123: model_id = DECODE( p_model_id, null, model_id, FND_API.G_MISS_NUM, null, p_model_id),
124: source_field_id = DECODE( p_source_field_id, null, source_field_id, FND_API.G_MISS_NUM, null, p_source_field_id),
125: rank = DECODE( p_rank, null, rank, FND_API.G_MISS_NUM, null, p_rank),
126: value = DECODE( p_value, null, value, FND_API.G_MISS_NUM, null, p_value)
127: WHERE imp_attribute_id = p_Dm_Imp_Attribute_id
128: AND object_version_number = px_object_version_number;

Line 125: rank = DECODE( p_rank, null, rank, FND_API.G_MISS_NUM, null, p_rank),

121: last_update_login = DECODE( p_last_update_login, null, last_update_login, FND_API.G_MISS_NUM, null, p_last_update_login),
122: object_version_number = object_version_number + 1,
123: model_id = DECODE( p_model_id, null, model_id, FND_API.G_MISS_NUM, null, p_model_id),
124: source_field_id = DECODE( p_source_field_id, null, source_field_id, FND_API.G_MISS_NUM, null, p_source_field_id),
125: rank = DECODE( p_rank, null, rank, FND_API.G_MISS_NUM, null, p_rank),
126: value = DECODE( p_value, null, value, FND_API.G_MISS_NUM, null, p_value)
127: WHERE imp_attribute_id = p_Dm_Imp_Attribute_id
128: AND object_version_number = px_object_version_number;
129:

Line 126: value = DECODE( p_value, null, value, FND_API.G_MISS_NUM, null, p_value)

122: object_version_number = object_version_number + 1,
123: model_id = DECODE( p_model_id, null, model_id, FND_API.G_MISS_NUM, null, p_model_id),
124: source_field_id = DECODE( p_source_field_id, null, source_field_id, FND_API.G_MISS_NUM, null, p_source_field_id),
125: rank = DECODE( p_rank, null, rank, FND_API.G_MISS_NUM, null, p_rank),
126: value = DECODE( p_value, null, value, FND_API.G_MISS_NUM, null, p_value)
127: WHERE imp_attribute_id = p_Dm_Imp_Attribute_id
128: AND object_version_number = px_object_version_number;
129:
130:

Line 132: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

128: AND object_version_number = px_object_version_number;
129:
130:
131: IF (SQL%NOTFOUND) THEN
132: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
133: END IF;
134:
135: px_object_version_number := nvl(px_object_version_number,0) + 1;
136:

Line 163: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

159: DELETE FROM ams_dm_imp_attributes
160: WHERE imp_attribute_id = p_Dm_Imp_Attribute_id
161: AND object_version_number = p_object_version_number;
162: If (SQL%NOTFOUND) then
163: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
164: End If;
165: END Delete_Row ;
166:
167: