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

Line 73: DECODE( px_action_param_value_id, FND_API.g_miss_num, NULL, px_action_param_value_id),

69: creation_date,
70: created_by,
71: security_group_id
72: ) VALUES (
73: DECODE( px_action_param_value_id, FND_API.g_miss_num, NULL, px_action_param_value_id),
74: DECODE( p_action_param_value, FND_API.g_miss_char, NULL, p_action_param_value),
75: DECODE( p_ctd_id, FND_API.g_miss_num, NULL, p_ctd_id),
76: DECODE( p_action_param_id, FND_API.g_miss_num, NULL, p_action_param_id),
77: DECODE( px_object_version_number, FND_API.g_miss_num, NULL, px_object_version_number),

Line 74: DECODE( p_action_param_value, FND_API.g_miss_char, NULL, p_action_param_value),

70: created_by,
71: security_group_id
72: ) VALUES (
73: DECODE( px_action_param_value_id, FND_API.g_miss_num, NULL, px_action_param_value_id),
74: DECODE( p_action_param_value, FND_API.g_miss_char, NULL, p_action_param_value),
75: DECODE( p_ctd_id, FND_API.g_miss_num, NULL, p_ctd_id),
76: DECODE( p_action_param_id, FND_API.g_miss_num, NULL, p_action_param_id),
77: DECODE( px_object_version_number, FND_API.g_miss_num, NULL, px_object_version_number),
78: DECODE( p_last_update_date, FND_API.g_miss_date, NULL, p_last_update_date),

Line 75: DECODE( p_ctd_id, FND_API.g_miss_num, NULL, p_ctd_id),

71: security_group_id
72: ) VALUES (
73: DECODE( px_action_param_value_id, FND_API.g_miss_num, NULL, px_action_param_value_id),
74: DECODE( p_action_param_value, FND_API.g_miss_char, NULL, p_action_param_value),
75: DECODE( p_ctd_id, FND_API.g_miss_num, NULL, p_ctd_id),
76: DECODE( p_action_param_id, FND_API.g_miss_num, NULL, p_action_param_id),
77: DECODE( px_object_version_number, FND_API.g_miss_num, NULL, px_object_version_number),
78: DECODE( p_last_update_date, FND_API.g_miss_date, NULL, p_last_update_date),
79: DECODE( p_last_updated_by, FND_API.g_miss_num, NULL, p_last_updated_by),

Line 76: DECODE( p_action_param_id, FND_API.g_miss_num, NULL, p_action_param_id),

72: ) VALUES (
73: DECODE( px_action_param_value_id, FND_API.g_miss_num, NULL, px_action_param_value_id),
74: DECODE( p_action_param_value, FND_API.g_miss_char, NULL, p_action_param_value),
75: DECODE( p_ctd_id, FND_API.g_miss_num, NULL, p_ctd_id),
76: DECODE( p_action_param_id, FND_API.g_miss_num, NULL, p_action_param_id),
77: DECODE( px_object_version_number, FND_API.g_miss_num, NULL, px_object_version_number),
78: DECODE( p_last_update_date, FND_API.g_miss_date, NULL, p_last_update_date),
79: DECODE( p_last_updated_by, FND_API.g_miss_num, NULL, p_last_updated_by),
80: DECODE( p_last_update_login, FND_API.g_miss_num, NULL, p_last_update_login),

Line 77: DECODE( px_object_version_number, FND_API.g_miss_num, NULL, px_object_version_number),

73: DECODE( px_action_param_value_id, FND_API.g_miss_num, NULL, px_action_param_value_id),
74: DECODE( p_action_param_value, FND_API.g_miss_char, NULL, p_action_param_value),
75: DECODE( p_ctd_id, FND_API.g_miss_num, NULL, p_ctd_id),
76: DECODE( p_action_param_id, FND_API.g_miss_num, NULL, p_action_param_id),
77: DECODE( px_object_version_number, FND_API.g_miss_num, NULL, px_object_version_number),
78: DECODE( p_last_update_date, FND_API.g_miss_date, NULL, p_last_update_date),
79: DECODE( p_last_updated_by, FND_API.g_miss_num, NULL, p_last_updated_by),
80: DECODE( p_last_update_login, FND_API.g_miss_num, NULL, p_last_update_login),
81: DECODE( p_creation_date, FND_API.g_miss_date, NULL, p_creation_date),

Line 78: DECODE( p_last_update_date, FND_API.g_miss_date, NULL, p_last_update_date),

74: DECODE( p_action_param_value, FND_API.g_miss_char, NULL, p_action_param_value),
75: DECODE( p_ctd_id, FND_API.g_miss_num, NULL, p_ctd_id),
76: DECODE( p_action_param_id, FND_API.g_miss_num, NULL, p_action_param_id),
77: DECODE( px_object_version_number, FND_API.g_miss_num, NULL, px_object_version_number),
78: DECODE( p_last_update_date, FND_API.g_miss_date, NULL, p_last_update_date),
79: DECODE( p_last_updated_by, FND_API.g_miss_num, NULL, p_last_updated_by),
80: DECODE( p_last_update_login, FND_API.g_miss_num, NULL, p_last_update_login),
81: DECODE( p_creation_date, FND_API.g_miss_date, NULL, p_creation_date),
82: DECODE( p_created_by, FND_API.g_miss_num, NULL, p_created_by),

Line 79: DECODE( p_last_updated_by, FND_API.g_miss_num, NULL, p_last_updated_by),

75: DECODE( p_ctd_id, FND_API.g_miss_num, NULL, p_ctd_id),
76: DECODE( p_action_param_id, FND_API.g_miss_num, NULL, p_action_param_id),
77: DECODE( px_object_version_number, FND_API.g_miss_num, NULL, px_object_version_number),
78: DECODE( p_last_update_date, FND_API.g_miss_date, NULL, p_last_update_date),
79: DECODE( p_last_updated_by, FND_API.g_miss_num, NULL, p_last_updated_by),
80: DECODE( p_last_update_login, FND_API.g_miss_num, NULL, p_last_update_login),
81: DECODE( p_creation_date, FND_API.g_miss_date, NULL, p_creation_date),
82: DECODE( p_created_by, FND_API.g_miss_num, NULL, p_created_by),
83: DECODE( p_security_group_id, FND_API.g_miss_num, NULL, p_security_group_id));

Line 80: DECODE( p_last_update_login, FND_API.g_miss_num, NULL, p_last_update_login),

76: DECODE( p_action_param_id, FND_API.g_miss_num, NULL, p_action_param_id),
77: DECODE( px_object_version_number, FND_API.g_miss_num, NULL, px_object_version_number),
78: DECODE( p_last_update_date, FND_API.g_miss_date, NULL, p_last_update_date),
79: DECODE( p_last_updated_by, FND_API.g_miss_num, NULL, p_last_updated_by),
80: DECODE( p_last_update_login, FND_API.g_miss_num, NULL, p_last_update_login),
81: DECODE( p_creation_date, FND_API.g_miss_date, NULL, p_creation_date),
82: DECODE( p_created_by, FND_API.g_miss_num, NULL, p_created_by),
83: DECODE( p_security_group_id, FND_API.g_miss_num, NULL, p_security_group_id));
84: END Insert_Row;

Line 81: DECODE( p_creation_date, FND_API.g_miss_date, NULL, p_creation_date),

77: DECODE( px_object_version_number, FND_API.g_miss_num, NULL, px_object_version_number),
78: DECODE( p_last_update_date, FND_API.g_miss_date, NULL, p_last_update_date),
79: DECODE( p_last_updated_by, FND_API.g_miss_num, NULL, p_last_updated_by),
80: DECODE( p_last_update_login, FND_API.g_miss_num, NULL, p_last_update_login),
81: DECODE( p_creation_date, FND_API.g_miss_date, NULL, p_creation_date),
82: DECODE( p_created_by, FND_API.g_miss_num, NULL, p_created_by),
83: DECODE( p_security_group_id, FND_API.g_miss_num, NULL, p_security_group_id));
84: END Insert_Row;
85:

Line 82: DECODE( p_created_by, FND_API.g_miss_num, NULL, p_created_by),

78: DECODE( p_last_update_date, FND_API.g_miss_date, NULL, p_last_update_date),
79: DECODE( p_last_updated_by, FND_API.g_miss_num, NULL, p_last_updated_by),
80: DECODE( p_last_update_login, FND_API.g_miss_num, NULL, p_last_update_login),
81: DECODE( p_creation_date, FND_API.g_miss_date, NULL, p_creation_date),
82: DECODE( p_created_by, FND_API.g_miss_num, NULL, p_created_by),
83: DECODE( p_security_group_id, FND_API.g_miss_num, NULL, p_security_group_id));
84: END Insert_Row;
85:
86:

Line 83: DECODE( p_security_group_id, FND_API.g_miss_num, NULL, p_security_group_id));

79: DECODE( p_last_updated_by, FND_API.g_miss_num, NULL, p_last_updated_by),
80: DECODE( p_last_update_login, FND_API.g_miss_num, NULL, p_last_update_login),
81: DECODE( p_creation_date, FND_API.g_miss_date, NULL, p_creation_date),
82: DECODE( p_created_by, FND_API.g_miss_num, NULL, p_created_by),
83: DECODE( p_security_group_id, FND_API.g_miss_num, NULL, p_security_group_id));
84: END Insert_Row;
85:
86:
87: ----------------------------------------------------------

Line 120: action_param_value_id = DECODE( p_action_param_value_id, FND_API.g_miss_num, action_param_value_id, p_action_param_value_id),

116: IS
117: BEGIN
118: Update AMS_CTD_PARAM_VALUES
119: SET
120: action_param_value_id = DECODE( p_action_param_value_id, FND_API.g_miss_num, action_param_value_id, p_action_param_value_id),
121: action_param_value = DECODE( p_action_param_value, FND_API.g_miss_char, action_param_value, p_action_param_value),
122: ctd_id = DECODE( p_ctd_id, FND_API.g_miss_num, ctd_id, p_ctd_id),
123: action_param_id = DECODE( p_action_param_id, FND_API.g_miss_num, action_param_id, p_action_param_id),
124: object_version_number = DECODE( p_object_version_number, FND_API.g_miss_num, object_version_number, p_object_version_number),

Line 121: action_param_value = DECODE( p_action_param_value, FND_API.g_miss_char, action_param_value, p_action_param_value),

117: BEGIN
118: Update AMS_CTD_PARAM_VALUES
119: SET
120: action_param_value_id = DECODE( p_action_param_value_id, FND_API.g_miss_num, action_param_value_id, p_action_param_value_id),
121: action_param_value = DECODE( p_action_param_value, FND_API.g_miss_char, action_param_value, p_action_param_value),
122: ctd_id = DECODE( p_ctd_id, FND_API.g_miss_num, ctd_id, p_ctd_id),
123: action_param_id = DECODE( p_action_param_id, FND_API.g_miss_num, action_param_id, p_action_param_id),
124: object_version_number = DECODE( p_object_version_number, FND_API.g_miss_num, object_version_number, p_object_version_number),
125: last_update_date = DECODE( p_last_update_date, FND_API.g_miss_date, last_update_date, p_last_update_date),

Line 122: ctd_id = DECODE( p_ctd_id, FND_API.g_miss_num, ctd_id, p_ctd_id),

118: Update AMS_CTD_PARAM_VALUES
119: SET
120: action_param_value_id = DECODE( p_action_param_value_id, FND_API.g_miss_num, action_param_value_id, p_action_param_value_id),
121: action_param_value = DECODE( p_action_param_value, FND_API.g_miss_char, action_param_value, p_action_param_value),
122: ctd_id = DECODE( p_ctd_id, FND_API.g_miss_num, ctd_id, p_ctd_id),
123: action_param_id = DECODE( p_action_param_id, FND_API.g_miss_num, action_param_id, p_action_param_id),
124: object_version_number = DECODE( p_object_version_number, FND_API.g_miss_num, object_version_number, p_object_version_number),
125: last_update_date = DECODE( p_last_update_date, FND_API.g_miss_date, last_update_date, p_last_update_date),
126: last_updated_by = DECODE( p_last_updated_by, FND_API.g_miss_num, last_updated_by, p_last_updated_by),

Line 123: action_param_id = DECODE( p_action_param_id, FND_API.g_miss_num, action_param_id, p_action_param_id),

119: SET
120: action_param_value_id = DECODE( p_action_param_value_id, FND_API.g_miss_num, action_param_value_id, p_action_param_value_id),
121: action_param_value = DECODE( p_action_param_value, FND_API.g_miss_char, action_param_value, p_action_param_value),
122: ctd_id = DECODE( p_ctd_id, FND_API.g_miss_num, ctd_id, p_ctd_id),
123: action_param_id = DECODE( p_action_param_id, FND_API.g_miss_num, action_param_id, p_action_param_id),
124: object_version_number = DECODE( p_object_version_number, FND_API.g_miss_num, object_version_number, p_object_version_number),
125: last_update_date = DECODE( p_last_update_date, FND_API.g_miss_date, last_update_date, p_last_update_date),
126: last_updated_by = DECODE( p_last_updated_by, FND_API.g_miss_num, last_updated_by, p_last_updated_by),
127: last_update_login = DECODE( p_last_update_login, FND_API.g_miss_num, last_update_login, p_last_update_login),

Line 124: object_version_number = DECODE( p_object_version_number, FND_API.g_miss_num, object_version_number, p_object_version_number),

120: action_param_value_id = DECODE( p_action_param_value_id, FND_API.g_miss_num, action_param_value_id, p_action_param_value_id),
121: action_param_value = DECODE( p_action_param_value, FND_API.g_miss_char, action_param_value, p_action_param_value),
122: ctd_id = DECODE( p_ctd_id, FND_API.g_miss_num, ctd_id, p_ctd_id),
123: action_param_id = DECODE( p_action_param_id, FND_API.g_miss_num, action_param_id, p_action_param_id),
124: object_version_number = DECODE( p_object_version_number, FND_API.g_miss_num, object_version_number, p_object_version_number),
125: last_update_date = DECODE( p_last_update_date, FND_API.g_miss_date, last_update_date, p_last_update_date),
126: last_updated_by = DECODE( p_last_updated_by, FND_API.g_miss_num, last_updated_by, p_last_updated_by),
127: last_update_login = DECODE( p_last_update_login, FND_API.g_miss_num, last_update_login, p_last_update_login),
128: creation_date = DECODE( p_creation_date, FND_API.g_miss_date, creation_date, p_creation_date),

Line 125: last_update_date = DECODE( p_last_update_date, FND_API.g_miss_date, last_update_date, p_last_update_date),

121: action_param_value = DECODE( p_action_param_value, FND_API.g_miss_char, action_param_value, p_action_param_value),
122: ctd_id = DECODE( p_ctd_id, FND_API.g_miss_num, ctd_id, p_ctd_id),
123: action_param_id = DECODE( p_action_param_id, FND_API.g_miss_num, action_param_id, p_action_param_id),
124: object_version_number = DECODE( p_object_version_number, FND_API.g_miss_num, object_version_number, p_object_version_number),
125: last_update_date = DECODE( p_last_update_date, FND_API.g_miss_date, last_update_date, p_last_update_date),
126: last_updated_by = DECODE( p_last_updated_by, FND_API.g_miss_num, last_updated_by, p_last_updated_by),
127: last_update_login = DECODE( p_last_update_login, FND_API.g_miss_num, last_update_login, p_last_update_login),
128: creation_date = DECODE( p_creation_date, FND_API.g_miss_date, creation_date, p_creation_date),
129: created_by = DECODE( p_created_by, FND_API.g_miss_num, created_by, p_created_by),

Line 126: last_updated_by = DECODE( p_last_updated_by, FND_API.g_miss_num, last_updated_by, p_last_updated_by),

122: ctd_id = DECODE( p_ctd_id, FND_API.g_miss_num, ctd_id, p_ctd_id),
123: action_param_id = DECODE( p_action_param_id, FND_API.g_miss_num, action_param_id, p_action_param_id),
124: object_version_number = DECODE( p_object_version_number, FND_API.g_miss_num, object_version_number, p_object_version_number),
125: last_update_date = DECODE( p_last_update_date, FND_API.g_miss_date, last_update_date, p_last_update_date),
126: last_updated_by = DECODE( p_last_updated_by, FND_API.g_miss_num, last_updated_by, p_last_updated_by),
127: last_update_login = DECODE( p_last_update_login, FND_API.g_miss_num, last_update_login, p_last_update_login),
128: creation_date = DECODE( p_creation_date, FND_API.g_miss_date, creation_date, p_creation_date),
129: created_by = DECODE( p_created_by, FND_API.g_miss_num, created_by, p_created_by),
130: security_group_id = DECODE( p_security_group_id, FND_API.g_miss_num, security_group_id, p_security_group_id)

Line 127: last_update_login = DECODE( p_last_update_login, FND_API.g_miss_num, last_update_login, p_last_update_login),

123: action_param_id = DECODE( p_action_param_id, FND_API.g_miss_num, action_param_id, p_action_param_id),
124: object_version_number = DECODE( p_object_version_number, FND_API.g_miss_num, object_version_number, p_object_version_number),
125: last_update_date = DECODE( p_last_update_date, FND_API.g_miss_date, last_update_date, p_last_update_date),
126: last_updated_by = DECODE( p_last_updated_by, FND_API.g_miss_num, last_updated_by, p_last_updated_by),
127: last_update_login = DECODE( p_last_update_login, FND_API.g_miss_num, last_update_login, p_last_update_login),
128: creation_date = DECODE( p_creation_date, FND_API.g_miss_date, creation_date, p_creation_date),
129: created_by = DECODE( p_created_by, FND_API.g_miss_num, created_by, p_created_by),
130: security_group_id = DECODE( p_security_group_id, FND_API.g_miss_num, security_group_id, p_security_group_id)
131: WHERE ACTION_PARAM_VALUE_ID = p_ACTION_PARAM_VALUE_ID

Line 128: creation_date = DECODE( p_creation_date, FND_API.g_miss_date, creation_date, p_creation_date),

124: object_version_number = DECODE( p_object_version_number, FND_API.g_miss_num, object_version_number, p_object_version_number),
125: last_update_date = DECODE( p_last_update_date, FND_API.g_miss_date, last_update_date, p_last_update_date),
126: last_updated_by = DECODE( p_last_updated_by, FND_API.g_miss_num, last_updated_by, p_last_updated_by),
127: last_update_login = DECODE( p_last_update_login, FND_API.g_miss_num, last_update_login, p_last_update_login),
128: creation_date = DECODE( p_creation_date, FND_API.g_miss_date, creation_date, p_creation_date),
129: created_by = DECODE( p_created_by, FND_API.g_miss_num, created_by, p_created_by),
130: security_group_id = DECODE( p_security_group_id, FND_API.g_miss_num, security_group_id, p_security_group_id)
131: WHERE ACTION_PARAM_VALUE_ID = p_ACTION_PARAM_VALUE_ID
132: AND object_version_number = p_object_version_number;

Line 129: created_by = DECODE( p_created_by, FND_API.g_miss_num, created_by, p_created_by),

125: last_update_date = DECODE( p_last_update_date, FND_API.g_miss_date, last_update_date, p_last_update_date),
126: last_updated_by = DECODE( p_last_updated_by, FND_API.g_miss_num, last_updated_by, p_last_updated_by),
127: last_update_login = DECODE( p_last_update_login, FND_API.g_miss_num, last_update_login, p_last_update_login),
128: creation_date = DECODE( p_creation_date, FND_API.g_miss_date, creation_date, p_creation_date),
129: created_by = DECODE( p_created_by, FND_API.g_miss_num, created_by, p_created_by),
130: security_group_id = DECODE( p_security_group_id, FND_API.g_miss_num, security_group_id, p_security_group_id)
131: WHERE ACTION_PARAM_VALUE_ID = p_ACTION_PARAM_VALUE_ID
132: AND object_version_number = p_object_version_number;
133:

Line 130: security_group_id = DECODE( p_security_group_id, FND_API.g_miss_num, security_group_id, p_security_group_id)

126: last_updated_by = DECODE( p_last_updated_by, FND_API.g_miss_num, last_updated_by, p_last_updated_by),
127: last_update_login = DECODE( p_last_update_login, FND_API.g_miss_num, last_update_login, p_last_update_login),
128: creation_date = DECODE( p_creation_date, FND_API.g_miss_date, creation_date, p_creation_date),
129: created_by = DECODE( p_created_by, FND_API.g_miss_num, created_by, p_created_by),
130: security_group_id = DECODE( p_security_group_id, FND_API.g_miss_num, security_group_id, p_security_group_id)
131: WHERE ACTION_PARAM_VALUE_ID = p_ACTION_PARAM_VALUE_ID
132: AND object_version_number = p_object_version_number;
133:
134: IF (SQL%NOTFOUND) THEN

Line 135: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

131: WHERE ACTION_PARAM_VALUE_ID = p_ACTION_PARAM_VALUE_ID
132: AND object_version_number = p_object_version_number;
133:
134: IF (SQL%NOTFOUND) THEN
135: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
136: END IF;
137: END Update_Row;
138:
139:

Line 163: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

159: BEGIN
160: DELETE FROM AMS_CTD_PARAM_VALUES
161: WHERE ACTION_PARAM_VALUE_ID = p_ACTION_PARAM_VALUE_ID;
162: If (SQL%NOTFOUND) then
163: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
164: End If;
165: END Delete_Row ;
166:
167: