DBA Data[Home] [Help]

APPS.IEU_UWQ_MEDIA_ACTIONS_PKG dependencies on FND_API

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

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)

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

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)

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

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)

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

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)

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_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)

Line 42: , DECODE(x_media_type_id,FND_API.G_MISS_NUM,NULL,x_media_type_id)

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)

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_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

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

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

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:

Line 46: , DECODE(x_other_params,FND_API.G_MISS_CHAR,NULL,x_other_params)

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;

Line 86: media_action_id=DECODE(x_media_action_id,FND_API.G_MISS_NUM,NULL,x_media_action_id)

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)

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

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)

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

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)

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

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)

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

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)

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

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)

Line 92: , media_type_id=DECODE(x_media_type_id,FND_API.G_MISS_NUM,NULL,x_media_type_id)

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)

Line 93: , maction_def_id=DECODE(x_maction_def_id,FND_API.G_MISS_NUM,NULL,x_maction_def_id)

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

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

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;

Line 95: , classification=DECODE(x_classification,FND_API.G_MISS_CHAR,NULL,x_classification)

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

Line 96: , other_params=DECODE(x_other_params,FND_API.G_MISS_CHAR,NULL,x_other_params)

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;