DBA Data[Home] [Help]

APPS.IEU_UWQ_NONMEDIA_ACTIONS_PKG dependencies on FND_API

Line 37: , DECODE(x_created_by,FND_API.G_MISS_NUM,NULL,x_created_by)

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)

Line 38: , DECODE(x_creation_date,FND_API.G_MISS_DATE,NULL,x_creation_date)

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)

Line 39: , DECODE(x_last_updated_by,FND_API.G_MISS_NUM,NULL,x_last_updated_by)

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)

Line 40: , DECODE(x_last_update_date,FND_API.G_MISS_DATE,NULL,x_last_update_date)

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)

Line 41: , DECODE(x_last_update_login,FND_API.G_MISS_NUM,NULL,x_last_update_login)

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)

Line 42: , DECODE(x_action_object_code,FND_API.G_MISS_CHAR,NULL,x_action_object_code)

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)

Line 43: , DECODE(x_maction_def_id,FND_API.G_MISS_NUM,NULL,x_maction_def_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

Line 44: , DECODE(x_application_id,FND_API.G_MISS_NUM,NULL,x_application_id)

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

Line 45: , DECODE(x_source_for_task_flag,FND_API.G_MISS_CHAR,NULL,x_source_for_task_flag)

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:

Line 46: , DECODE(x_responsibility_id,FND_API.G_MISS_NUM,NULL,x_responsibility_id)

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;

Line 87: nonmedia_action_id=DECODE(x_nonmedia_action_id,FND_API.G_MISS_NUM,NULL,x_nonmedia_action_id)

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)

Line 88: , created_by=DECODE(x_created_by,FND_API.G_MISS_NUM,NULL,x_created_by)

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)

Line 89: , creation_date=DECODE(x_creation_date,FND_API.G_MISS_DATE,NULL,x_creation_date)

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)

Line 90: , last_updated_by=DECODE(x_last_updated_by,FND_API.G_MISS_NUM,NULL,x_last_updated_by)

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)

Line 91: , last_update_date=DECODE(x_last_update_date,FND_API.G_MISS_DATE,NULL,x_last_update_date)

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)

Line 92: , last_update_login=DECODE(x_last_update_login,FND_API.G_MISS_NUM,NULL,x_last_update_login)

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)

Line 93: , action_object_code=DECODE(x_action_object_code,FND_API.G_MISS_CHAR,NULL,x_action_object_code)

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)

Line 94: , maction_def_id=DECODE(x_maction_def_id,FND_API.G_MISS_NUM,NULL,x_maction_def_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

Line 95: , application_id=DECODE(x_application_id,FND_API.G_MISS_NUM,NULL,x_application_id)

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;

Line 96: , source_for_task_flag = DECODE(x_source_for_task_flag,FND_API.G_MISS_CHAR,NULL,x_source_for_task_flag)

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

Line 97: , responsibility_id = DECODE(x_responsibility_id,FND_API.G_MISS_NUM,NULL,x_responsibility_id)

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;