33: , other_params
34: , object_version_number
35: ) VALUES (
36: x_media_action_id
37: , DECODE(x_created_by,FND_API.G_MISS_NUM,NULL,x_created_by)
38: , DECODE(x_creation_date,FND_API.G_MISS_DATE,NULL,x_creation_date)
39: , DECODE(x_last_updated_by,FND_API.G_MISS_NUM,NULL,x_last_updated_by)
40: , DECODE(x_last_update_date,FND_API.G_MISS_DATE,NULL,x_last_update_date)
41: , DECODE(x_last_update_login,FND_API.G_MISS_NUM,NULL,x_last_update_login)
34: , object_version_number
35: ) VALUES (
36: x_media_action_id
37: , DECODE(x_created_by,FND_API.G_MISS_NUM,NULL,x_created_by)
38: , DECODE(x_creation_date,FND_API.G_MISS_DATE,NULL,x_creation_date)
39: , DECODE(x_last_updated_by,FND_API.G_MISS_NUM,NULL,x_last_updated_by)
40: , DECODE(x_last_update_date,FND_API.G_MISS_DATE,NULL,x_last_update_date)
41: , DECODE(x_last_update_login,FND_API.G_MISS_NUM,NULL,x_last_update_login)
42: , DECODE(x_media_type_id,FND_API.G_MISS_NUM,NULL,x_media_type_id)
35: ) VALUES (
36: x_media_action_id
37: , DECODE(x_created_by,FND_API.G_MISS_NUM,NULL,x_created_by)
38: , DECODE(x_creation_date,FND_API.G_MISS_DATE,NULL,x_creation_date)
39: , DECODE(x_last_updated_by,FND_API.G_MISS_NUM,NULL,x_last_updated_by)
40: , DECODE(x_last_update_date,FND_API.G_MISS_DATE,NULL,x_last_update_date)
41: , DECODE(x_last_update_login,FND_API.G_MISS_NUM,NULL,x_last_update_login)
42: , DECODE(x_media_type_id,FND_API.G_MISS_NUM,NULL,x_media_type_id)
43: , DECODE(x_maction_def_id,FND_API.G_MISS_NUM,NULL,x_maction_def_id)
36: x_media_action_id
37: , DECODE(x_created_by,FND_API.G_MISS_NUM,NULL,x_created_by)
38: , DECODE(x_creation_date,FND_API.G_MISS_DATE,NULL,x_creation_date)
39: , DECODE(x_last_updated_by,FND_API.G_MISS_NUM,NULL,x_last_updated_by)
40: , DECODE(x_last_update_date,FND_API.G_MISS_DATE,NULL,x_last_update_date)
41: , DECODE(x_last_update_login,FND_API.G_MISS_NUM,NULL,x_last_update_login)
42: , DECODE(x_media_type_id,FND_API.G_MISS_NUM,NULL,x_media_type_id)
43: , DECODE(x_maction_def_id,FND_API.G_MISS_NUM,NULL,x_maction_def_id)
44: , DECODE(x_application_id,FND_API.G_MISS_NUM,NULL,x_application_id)
37: , DECODE(x_created_by,FND_API.G_MISS_NUM,NULL,x_created_by)
38: , DECODE(x_creation_date,FND_API.G_MISS_DATE,NULL,x_creation_date)
39: , DECODE(x_last_updated_by,FND_API.G_MISS_NUM,NULL,x_last_updated_by)
40: , DECODE(x_last_update_date,FND_API.G_MISS_DATE,NULL,x_last_update_date)
41: , DECODE(x_last_update_login,FND_API.G_MISS_NUM,NULL,x_last_update_login)
42: , DECODE(x_media_type_id,FND_API.G_MISS_NUM,NULL,x_media_type_id)
43: , DECODE(x_maction_def_id,FND_API.G_MISS_NUM,NULL,x_maction_def_id)
44: , DECODE(x_application_id,FND_API.G_MISS_NUM,NULL,x_application_id)
45: , DECODE(x_classification,FND_API.G_MISS_CHAR,NULL,x_classification)
38: , DECODE(x_creation_date,FND_API.G_MISS_DATE,NULL,x_creation_date)
39: , DECODE(x_last_updated_by,FND_API.G_MISS_NUM,NULL,x_last_updated_by)
40: , DECODE(x_last_update_date,FND_API.G_MISS_DATE,NULL,x_last_update_date)
41: , DECODE(x_last_update_login,FND_API.G_MISS_NUM,NULL,x_last_update_login)
42: , DECODE(x_media_type_id,FND_API.G_MISS_NUM,NULL,x_media_type_id)
43: , DECODE(x_maction_def_id,FND_API.G_MISS_NUM,NULL,x_maction_def_id)
44: , DECODE(x_application_id,FND_API.G_MISS_NUM,NULL,x_application_id)
45: , DECODE(x_classification,FND_API.G_MISS_CHAR,NULL,x_classification)
46: , DECODE(x_other_params,FND_API.G_MISS_CHAR,NULL,x_other_params)
39: , DECODE(x_last_updated_by,FND_API.G_MISS_NUM,NULL,x_last_updated_by)
40: , DECODE(x_last_update_date,FND_API.G_MISS_DATE,NULL,x_last_update_date)
41: , DECODE(x_last_update_login,FND_API.G_MISS_NUM,NULL,x_last_update_login)
42: , DECODE(x_media_type_id,FND_API.G_MISS_NUM,NULL,x_media_type_id)
43: , DECODE(x_maction_def_id,FND_API.G_MISS_NUM,NULL,x_maction_def_id)
44: , DECODE(x_application_id,FND_API.G_MISS_NUM,NULL,x_application_id)
45: , DECODE(x_classification,FND_API.G_MISS_CHAR,NULL,x_classification)
46: , DECODE(x_other_params,FND_API.G_MISS_CHAR,NULL,x_other_params)
47: , 1
40: , DECODE(x_last_update_date,FND_API.G_MISS_DATE,NULL,x_last_update_date)
41: , DECODE(x_last_update_login,FND_API.G_MISS_NUM,NULL,x_last_update_login)
42: , DECODE(x_media_type_id,FND_API.G_MISS_NUM,NULL,x_media_type_id)
43: , DECODE(x_maction_def_id,FND_API.G_MISS_NUM,NULL,x_maction_def_id)
44: , DECODE(x_application_id,FND_API.G_MISS_NUM,NULL,x_application_id)
45: , DECODE(x_classification,FND_API.G_MISS_CHAR,NULL,x_classification)
46: , DECODE(x_other_params,FND_API.G_MISS_CHAR,NULL,x_other_params)
47: , 1
48: );
41: , DECODE(x_last_update_login,FND_API.G_MISS_NUM,NULL,x_last_update_login)
42: , DECODE(x_media_type_id,FND_API.G_MISS_NUM,NULL,x_media_type_id)
43: , DECODE(x_maction_def_id,FND_API.G_MISS_NUM,NULL,x_maction_def_id)
44: , DECODE(x_application_id,FND_API.G_MISS_NUM,NULL,x_application_id)
45: , DECODE(x_classification,FND_API.G_MISS_CHAR,NULL,x_classification)
46: , DECODE(x_other_params,FND_API.G_MISS_CHAR,NULL,x_other_params)
47: , 1
48: );
49:
42: , DECODE(x_media_type_id,FND_API.G_MISS_NUM,NULL,x_media_type_id)
43: , DECODE(x_maction_def_id,FND_API.G_MISS_NUM,NULL,x_maction_def_id)
44: , DECODE(x_application_id,FND_API.G_MISS_NUM,NULL,x_application_id)
45: , DECODE(x_classification,FND_API.G_MISS_CHAR,NULL,x_classification)
46: , DECODE(x_other_params,FND_API.G_MISS_CHAR,NULL,x_other_params)
47: , 1
48: );
49:
50: OPEN l_insert;
82: ) IS
83: BEGIN
84: UPDATE ieu_uwq_media_actions
85: SET
86: media_action_id=DECODE(x_media_action_id,FND_API.G_MISS_NUM,NULL,x_media_action_id)
87: , created_by=DECODE(x_created_by,FND_API.G_MISS_NUM,NULL,x_created_by)
88: , creation_date=DECODE(x_creation_date,FND_API.G_MISS_DATE,NULL,x_creation_date)
89: , last_updated_by=DECODE(x_last_updated_by,FND_API.G_MISS_NUM,NULL,x_last_updated_by)
90: , last_update_date=DECODE(x_last_update_date,FND_API.G_MISS_DATE,NULL,x_last_update_date)
83: BEGIN
84: UPDATE ieu_uwq_media_actions
85: SET
86: media_action_id=DECODE(x_media_action_id,FND_API.G_MISS_NUM,NULL,x_media_action_id)
87: , created_by=DECODE(x_created_by,FND_API.G_MISS_NUM,NULL,x_created_by)
88: , creation_date=DECODE(x_creation_date,FND_API.G_MISS_DATE,NULL,x_creation_date)
89: , last_updated_by=DECODE(x_last_updated_by,FND_API.G_MISS_NUM,NULL,x_last_updated_by)
90: , last_update_date=DECODE(x_last_update_date,FND_API.G_MISS_DATE,NULL,x_last_update_date)
91: , last_update_login=DECODE(x_last_update_login,FND_API.G_MISS_NUM,NULL,x_last_update_login)
84: UPDATE ieu_uwq_media_actions
85: SET
86: media_action_id=DECODE(x_media_action_id,FND_API.G_MISS_NUM,NULL,x_media_action_id)
87: , created_by=DECODE(x_created_by,FND_API.G_MISS_NUM,NULL,x_created_by)
88: , creation_date=DECODE(x_creation_date,FND_API.G_MISS_DATE,NULL,x_creation_date)
89: , last_updated_by=DECODE(x_last_updated_by,FND_API.G_MISS_NUM,NULL,x_last_updated_by)
90: , last_update_date=DECODE(x_last_update_date,FND_API.G_MISS_DATE,NULL,x_last_update_date)
91: , last_update_login=DECODE(x_last_update_login,FND_API.G_MISS_NUM,NULL,x_last_update_login)
92: , media_type_id=DECODE(x_media_type_id,FND_API.G_MISS_NUM,NULL,x_media_type_id)
85: SET
86: media_action_id=DECODE(x_media_action_id,FND_API.G_MISS_NUM,NULL,x_media_action_id)
87: , created_by=DECODE(x_created_by,FND_API.G_MISS_NUM,NULL,x_created_by)
88: , creation_date=DECODE(x_creation_date,FND_API.G_MISS_DATE,NULL,x_creation_date)
89: , last_updated_by=DECODE(x_last_updated_by,FND_API.G_MISS_NUM,NULL,x_last_updated_by)
90: , last_update_date=DECODE(x_last_update_date,FND_API.G_MISS_DATE,NULL,x_last_update_date)
91: , last_update_login=DECODE(x_last_update_login,FND_API.G_MISS_NUM,NULL,x_last_update_login)
92: , media_type_id=DECODE(x_media_type_id,FND_API.G_MISS_NUM,NULL,x_media_type_id)
93: , maction_def_id=DECODE(x_maction_def_id,FND_API.G_MISS_NUM,NULL,x_maction_def_id)
86: media_action_id=DECODE(x_media_action_id,FND_API.G_MISS_NUM,NULL,x_media_action_id)
87: , created_by=DECODE(x_created_by,FND_API.G_MISS_NUM,NULL,x_created_by)
88: , creation_date=DECODE(x_creation_date,FND_API.G_MISS_DATE,NULL,x_creation_date)
89: , last_updated_by=DECODE(x_last_updated_by,FND_API.G_MISS_NUM,NULL,x_last_updated_by)
90: , last_update_date=DECODE(x_last_update_date,FND_API.G_MISS_DATE,NULL,x_last_update_date)
91: , last_update_login=DECODE(x_last_update_login,FND_API.G_MISS_NUM,NULL,x_last_update_login)
92: , media_type_id=DECODE(x_media_type_id,FND_API.G_MISS_NUM,NULL,x_media_type_id)
93: , maction_def_id=DECODE(x_maction_def_id,FND_API.G_MISS_NUM,NULL,x_maction_def_id)
94: , application_id=DECODE(x_application_id,FND_API.G_MISS_NUM,NULL,x_application_id)
87: , created_by=DECODE(x_created_by,FND_API.G_MISS_NUM,NULL,x_created_by)
88: , creation_date=DECODE(x_creation_date,FND_API.G_MISS_DATE,NULL,x_creation_date)
89: , last_updated_by=DECODE(x_last_updated_by,FND_API.G_MISS_NUM,NULL,x_last_updated_by)
90: , last_update_date=DECODE(x_last_update_date,FND_API.G_MISS_DATE,NULL,x_last_update_date)
91: , last_update_login=DECODE(x_last_update_login,FND_API.G_MISS_NUM,NULL,x_last_update_login)
92: , media_type_id=DECODE(x_media_type_id,FND_API.G_MISS_NUM,NULL,x_media_type_id)
93: , maction_def_id=DECODE(x_maction_def_id,FND_API.G_MISS_NUM,NULL,x_maction_def_id)
94: , application_id=DECODE(x_application_id,FND_API.G_MISS_NUM,NULL,x_application_id)
95: , classification=DECODE(x_classification,FND_API.G_MISS_CHAR,NULL,x_classification)
88: , creation_date=DECODE(x_creation_date,FND_API.G_MISS_DATE,NULL,x_creation_date)
89: , last_updated_by=DECODE(x_last_updated_by,FND_API.G_MISS_NUM,NULL,x_last_updated_by)
90: , last_update_date=DECODE(x_last_update_date,FND_API.G_MISS_DATE,NULL,x_last_update_date)
91: , last_update_login=DECODE(x_last_update_login,FND_API.G_MISS_NUM,NULL,x_last_update_login)
92: , media_type_id=DECODE(x_media_type_id,FND_API.G_MISS_NUM,NULL,x_media_type_id)
93: , maction_def_id=DECODE(x_maction_def_id,FND_API.G_MISS_NUM,NULL,x_maction_def_id)
94: , application_id=DECODE(x_application_id,FND_API.G_MISS_NUM,NULL,x_application_id)
95: , classification=DECODE(x_classification,FND_API.G_MISS_CHAR,NULL,x_classification)
96: , other_params=DECODE(x_other_params,FND_API.G_MISS_CHAR,NULL,x_other_params)
89: , last_updated_by=DECODE(x_last_updated_by,FND_API.G_MISS_NUM,NULL,x_last_updated_by)
90: , last_update_date=DECODE(x_last_update_date,FND_API.G_MISS_DATE,NULL,x_last_update_date)
91: , last_update_login=DECODE(x_last_update_login,FND_API.G_MISS_NUM,NULL,x_last_update_login)
92: , media_type_id=DECODE(x_media_type_id,FND_API.G_MISS_NUM,NULL,x_media_type_id)
93: , maction_def_id=DECODE(x_maction_def_id,FND_API.G_MISS_NUM,NULL,x_maction_def_id)
94: , application_id=DECODE(x_application_id,FND_API.G_MISS_NUM,NULL,x_application_id)
95: , classification=DECODE(x_classification,FND_API.G_MISS_CHAR,NULL,x_classification)
96: , other_params=DECODE(x_other_params,FND_API.G_MISS_CHAR,NULL,x_other_params)
97: , object_version_number=nvl(object_version_number,0) + 1
90: , last_update_date=DECODE(x_last_update_date,FND_API.G_MISS_DATE,NULL,x_last_update_date)
91: , last_update_login=DECODE(x_last_update_login,FND_API.G_MISS_NUM,NULL,x_last_update_login)
92: , media_type_id=DECODE(x_media_type_id,FND_API.G_MISS_NUM,NULL,x_media_type_id)
93: , maction_def_id=DECODE(x_maction_def_id,FND_API.G_MISS_NUM,NULL,x_maction_def_id)
94: , application_id=DECODE(x_application_id,FND_API.G_MISS_NUM,NULL,x_application_id)
95: , classification=DECODE(x_classification,FND_API.G_MISS_CHAR,NULL,x_classification)
96: , other_params=DECODE(x_other_params,FND_API.G_MISS_CHAR,NULL,x_other_params)
97: , object_version_number=nvl(object_version_number,0) + 1
98: WHERE ROWID = x_rowid;
91: , last_update_login=DECODE(x_last_update_login,FND_API.G_MISS_NUM,NULL,x_last_update_login)
92: , media_type_id=DECODE(x_media_type_id,FND_API.G_MISS_NUM,NULL,x_media_type_id)
93: , maction_def_id=DECODE(x_maction_def_id,FND_API.G_MISS_NUM,NULL,x_maction_def_id)
94: , application_id=DECODE(x_application_id,FND_API.G_MISS_NUM,NULL,x_application_id)
95: , classification=DECODE(x_classification,FND_API.G_MISS_CHAR,NULL,x_classification)
96: , other_params=DECODE(x_other_params,FND_API.G_MISS_CHAR,NULL,x_other_params)
97: , object_version_number=nvl(object_version_number,0) + 1
98: WHERE ROWID = x_rowid;
99: IF (SQL%NOTFOUND) THEN
92: , media_type_id=DECODE(x_media_type_id,FND_API.G_MISS_NUM,NULL,x_media_type_id)
93: , maction_def_id=DECODE(x_maction_def_id,FND_API.G_MISS_NUM,NULL,x_maction_def_id)
94: , application_id=DECODE(x_application_id,FND_API.G_MISS_NUM,NULL,x_application_id)
95: , classification=DECODE(x_classification,FND_API.G_MISS_CHAR,NULL,x_classification)
96: , other_params=DECODE(x_other_params,FND_API.G_MISS_CHAR,NULL,x_other_params)
97: , object_version_number=nvl(object_version_number,0) + 1
98: WHERE ROWID = x_rowid;
99: IF (SQL%NOTFOUND) THEN
100: RAISE NO_DATA_FOUND;