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),
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),
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),
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),
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),
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),
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));
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;
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:
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:
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: ----------------------------------------------------------
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),
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),
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),
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),
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),
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),
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)
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
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;
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:
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
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:
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: