33: , responsibility_id
34: , object_version_number
35: ) VALUES (
36: x_nonmedia_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_nonmedia_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_action_object_code,FND_API.G_MISS_CHAR,NULL,x_action_object_code)
35: ) VALUES (
36: x_nonmedia_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_action_object_code,FND_API.G_MISS_CHAR,NULL,x_action_object_code)
43: , DECODE(x_maction_def_id,FND_API.G_MISS_NUM,NULL,x_maction_def_id)
36: x_nonmedia_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_action_object_code,FND_API.G_MISS_CHAR,NULL,x_action_object_code)
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_action_object_code,FND_API.G_MISS_CHAR,NULL,x_action_object_code)
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_source_for_task_flag,FND_API.G_MISS_CHAR,NULL,x_source_for_task_flag)
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_action_object_code,FND_API.G_MISS_CHAR,NULL,x_action_object_code)
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_source_for_task_flag,FND_API.G_MISS_CHAR,NULL,x_source_for_task_flag)
46: , DECODE(x_responsibility_id,FND_API.G_MISS_NUM,NULL,x_responsibility_id)
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_action_object_code,FND_API.G_MISS_CHAR,NULL,x_action_object_code)
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_source_for_task_flag,FND_API.G_MISS_CHAR,NULL,x_source_for_task_flag)
46: , DECODE(x_responsibility_id,FND_API.G_MISS_NUM,NULL,x_responsibility_id)
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_action_object_code,FND_API.G_MISS_CHAR,NULL,x_action_object_code)
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_source_for_task_flag,FND_API.G_MISS_CHAR,NULL,x_source_for_task_flag)
46: , DECODE(x_responsibility_id,FND_API.G_MISS_NUM,NULL,x_responsibility_id)
47: , 1
48: );
41: , DECODE(x_last_update_login,FND_API.G_MISS_NUM,NULL,x_last_update_login)
42: , DECODE(x_action_object_code,FND_API.G_MISS_CHAR,NULL,x_action_object_code)
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_source_for_task_flag,FND_API.G_MISS_CHAR,NULL,x_source_for_task_flag)
46: , DECODE(x_responsibility_id,FND_API.G_MISS_NUM,NULL,x_responsibility_id)
47: , 1
48: );
49:
42: , DECODE(x_action_object_code,FND_API.G_MISS_CHAR,NULL,x_action_object_code)
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_source_for_task_flag,FND_API.G_MISS_CHAR,NULL,x_source_for_task_flag)
46: , DECODE(x_responsibility_id,FND_API.G_MISS_NUM,NULL,x_responsibility_id)
47: , 1
48: );
49:
50: OPEN l_insert;
83: ) IS
84: BEGIN
85: UPDATE ieu_uwq_nonmedia_actions
86: SET
87: nonmedia_action_id=DECODE(x_nonmedia_action_id,FND_API.G_MISS_NUM,NULL,x_nonmedia_action_id)
88: , created_by=DECODE(x_created_by,FND_API.G_MISS_NUM,NULL,x_created_by)
89: , creation_date=DECODE(x_creation_date,FND_API.G_MISS_DATE,NULL,x_creation_date)
90: , last_updated_by=DECODE(x_last_updated_by,FND_API.G_MISS_NUM,NULL,x_last_updated_by)
91: , last_update_date=DECODE(x_last_update_date,FND_API.G_MISS_DATE,NULL,x_last_update_date)
84: BEGIN
85: UPDATE ieu_uwq_nonmedia_actions
86: SET
87: nonmedia_action_id=DECODE(x_nonmedia_action_id,FND_API.G_MISS_NUM,NULL,x_nonmedia_action_id)
88: , created_by=DECODE(x_created_by,FND_API.G_MISS_NUM,NULL,x_created_by)
89: , creation_date=DECODE(x_creation_date,FND_API.G_MISS_DATE,NULL,x_creation_date)
90: , last_updated_by=DECODE(x_last_updated_by,FND_API.G_MISS_NUM,NULL,x_last_updated_by)
91: , last_update_date=DECODE(x_last_update_date,FND_API.G_MISS_DATE,NULL,x_last_update_date)
92: , last_update_login=DECODE(x_last_update_login,FND_API.G_MISS_NUM,NULL,x_last_update_login)
85: UPDATE ieu_uwq_nonmedia_actions
86: SET
87: nonmedia_action_id=DECODE(x_nonmedia_action_id,FND_API.G_MISS_NUM,NULL,x_nonmedia_action_id)
88: , created_by=DECODE(x_created_by,FND_API.G_MISS_NUM,NULL,x_created_by)
89: , creation_date=DECODE(x_creation_date,FND_API.G_MISS_DATE,NULL,x_creation_date)
90: , last_updated_by=DECODE(x_last_updated_by,FND_API.G_MISS_NUM,NULL,x_last_updated_by)
91: , last_update_date=DECODE(x_last_update_date,FND_API.G_MISS_DATE,NULL,x_last_update_date)
92: , last_update_login=DECODE(x_last_update_login,FND_API.G_MISS_NUM,NULL,x_last_update_login)
93: , action_object_code=DECODE(x_action_object_code,FND_API.G_MISS_CHAR,NULL,x_action_object_code)
86: SET
87: nonmedia_action_id=DECODE(x_nonmedia_action_id,FND_API.G_MISS_NUM,NULL,x_nonmedia_action_id)
88: , created_by=DECODE(x_created_by,FND_API.G_MISS_NUM,NULL,x_created_by)
89: , creation_date=DECODE(x_creation_date,FND_API.G_MISS_DATE,NULL,x_creation_date)
90: , last_updated_by=DECODE(x_last_updated_by,FND_API.G_MISS_NUM,NULL,x_last_updated_by)
91: , last_update_date=DECODE(x_last_update_date,FND_API.G_MISS_DATE,NULL,x_last_update_date)
92: , last_update_login=DECODE(x_last_update_login,FND_API.G_MISS_NUM,NULL,x_last_update_login)
93: , action_object_code=DECODE(x_action_object_code,FND_API.G_MISS_CHAR,NULL,x_action_object_code)
94: , maction_def_id=DECODE(x_maction_def_id,FND_API.G_MISS_NUM,NULL,x_maction_def_id)
87: nonmedia_action_id=DECODE(x_nonmedia_action_id,FND_API.G_MISS_NUM,NULL,x_nonmedia_action_id)
88: , created_by=DECODE(x_created_by,FND_API.G_MISS_NUM,NULL,x_created_by)
89: , creation_date=DECODE(x_creation_date,FND_API.G_MISS_DATE,NULL,x_creation_date)
90: , last_updated_by=DECODE(x_last_updated_by,FND_API.G_MISS_NUM,NULL,x_last_updated_by)
91: , last_update_date=DECODE(x_last_update_date,FND_API.G_MISS_DATE,NULL,x_last_update_date)
92: , last_update_login=DECODE(x_last_update_login,FND_API.G_MISS_NUM,NULL,x_last_update_login)
93: , action_object_code=DECODE(x_action_object_code,FND_API.G_MISS_CHAR,NULL,x_action_object_code)
94: , maction_def_id=DECODE(x_maction_def_id,FND_API.G_MISS_NUM,NULL,x_maction_def_id)
95: , application_id=DECODE(x_application_id,FND_API.G_MISS_NUM,NULL,x_application_id)
88: , created_by=DECODE(x_created_by,FND_API.G_MISS_NUM,NULL,x_created_by)
89: , creation_date=DECODE(x_creation_date,FND_API.G_MISS_DATE,NULL,x_creation_date)
90: , last_updated_by=DECODE(x_last_updated_by,FND_API.G_MISS_NUM,NULL,x_last_updated_by)
91: , last_update_date=DECODE(x_last_update_date,FND_API.G_MISS_DATE,NULL,x_last_update_date)
92: , last_update_login=DECODE(x_last_update_login,FND_API.G_MISS_NUM,NULL,x_last_update_login)
93: , action_object_code=DECODE(x_action_object_code,FND_API.G_MISS_CHAR,NULL,x_action_object_code)
94: , maction_def_id=DECODE(x_maction_def_id,FND_API.G_MISS_NUM,NULL,x_maction_def_id)
95: , application_id=DECODE(x_application_id,FND_API.G_MISS_NUM,NULL,x_application_id)
96: , source_for_task_flag = DECODE(x_source_for_task_flag,FND_API.G_MISS_CHAR,NULL,x_source_for_task_flag)
89: , creation_date=DECODE(x_creation_date,FND_API.G_MISS_DATE,NULL,x_creation_date)
90: , last_updated_by=DECODE(x_last_updated_by,FND_API.G_MISS_NUM,NULL,x_last_updated_by)
91: , last_update_date=DECODE(x_last_update_date,FND_API.G_MISS_DATE,NULL,x_last_update_date)
92: , last_update_login=DECODE(x_last_update_login,FND_API.G_MISS_NUM,NULL,x_last_update_login)
93: , action_object_code=DECODE(x_action_object_code,FND_API.G_MISS_CHAR,NULL,x_action_object_code)
94: , maction_def_id=DECODE(x_maction_def_id,FND_API.G_MISS_NUM,NULL,x_maction_def_id)
95: , application_id=DECODE(x_application_id,FND_API.G_MISS_NUM,NULL,x_application_id)
96: , source_for_task_flag = DECODE(x_source_for_task_flag,FND_API.G_MISS_CHAR,NULL,x_source_for_task_flag)
97: , responsibility_id = DECODE(x_responsibility_id,FND_API.G_MISS_NUM,NULL,x_responsibility_id)
90: , last_updated_by=DECODE(x_last_updated_by,FND_API.G_MISS_NUM,NULL,x_last_updated_by)
91: , last_update_date=DECODE(x_last_update_date,FND_API.G_MISS_DATE,NULL,x_last_update_date)
92: , last_update_login=DECODE(x_last_update_login,FND_API.G_MISS_NUM,NULL,x_last_update_login)
93: , action_object_code=DECODE(x_action_object_code,FND_API.G_MISS_CHAR,NULL,x_action_object_code)
94: , maction_def_id=DECODE(x_maction_def_id,FND_API.G_MISS_NUM,NULL,x_maction_def_id)
95: , application_id=DECODE(x_application_id,FND_API.G_MISS_NUM,NULL,x_application_id)
96: , source_for_task_flag = DECODE(x_source_for_task_flag,FND_API.G_MISS_CHAR,NULL,x_source_for_task_flag)
97: , responsibility_id = DECODE(x_responsibility_id,FND_API.G_MISS_NUM,NULL,x_responsibility_id)
98: , object_version_number=nvl(object_version_number,0) + 1
91: , last_update_date=DECODE(x_last_update_date,FND_API.G_MISS_DATE,NULL,x_last_update_date)
92: , last_update_login=DECODE(x_last_update_login,FND_API.G_MISS_NUM,NULL,x_last_update_login)
93: , action_object_code=DECODE(x_action_object_code,FND_API.G_MISS_CHAR,NULL,x_action_object_code)
94: , maction_def_id=DECODE(x_maction_def_id,FND_API.G_MISS_NUM,NULL,x_maction_def_id)
95: , application_id=DECODE(x_application_id,FND_API.G_MISS_NUM,NULL,x_application_id)
96: , source_for_task_flag = DECODE(x_source_for_task_flag,FND_API.G_MISS_CHAR,NULL,x_source_for_task_flag)
97: , responsibility_id = DECODE(x_responsibility_id,FND_API.G_MISS_NUM,NULL,x_responsibility_id)
98: , object_version_number=nvl(object_version_number,0) + 1
99: WHERE ROWID = x_rowid;
92: , last_update_login=DECODE(x_last_update_login,FND_API.G_MISS_NUM,NULL,x_last_update_login)
93: , action_object_code=DECODE(x_action_object_code,FND_API.G_MISS_CHAR,NULL,x_action_object_code)
94: , maction_def_id=DECODE(x_maction_def_id,FND_API.G_MISS_NUM,NULL,x_maction_def_id)
95: , application_id=DECODE(x_application_id,FND_API.G_MISS_NUM,NULL,x_application_id)
96: , source_for_task_flag = DECODE(x_source_for_task_flag,FND_API.G_MISS_CHAR,NULL,x_source_for_task_flag)
97: , responsibility_id = DECODE(x_responsibility_id,FND_API.G_MISS_NUM,NULL,x_responsibility_id)
98: , object_version_number=nvl(object_version_number,0) + 1
99: WHERE ROWID = x_rowid;
100: IF (SQL%NOTFOUND) THEN
93: , action_object_code=DECODE(x_action_object_code,FND_API.G_MISS_CHAR,NULL,x_action_object_code)
94: , maction_def_id=DECODE(x_maction_def_id,FND_API.G_MISS_NUM,NULL,x_maction_def_id)
95: , application_id=DECODE(x_application_id,FND_API.G_MISS_NUM,NULL,x_application_id)
96: , source_for_task_flag = DECODE(x_source_for_task_flag,FND_API.G_MISS_CHAR,NULL,x_source_for_task_flag)
97: , responsibility_id = DECODE(x_responsibility_id,FND_API.G_MISS_NUM,NULL,x_responsibility_id)
98: , object_version_number=nvl(object_version_number,0) + 1
99: WHERE ROWID = x_rowid;
100: IF (SQL%NOTFOUND) THEN
101: RAISE NO_DATA_FOUND;