eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.IBC_ATTRIBUTE_TYPES_PKG dependencies on FND_API

Line 10: -- shitij.vatsa 11/04/2002 Updated for FND_API.G_MISS_XXX

6: -- MODIFICATION HISTORY
7: -- Person Date Comments
8: -- --------- ------ ------------------------------------------
9: -- Sri Rangarajan 01/06/2002 Created Package
10: -- shitij.vatsa 11/04/2002 Updated for FND_API.G_MISS_XXX
11: -- vicho 11/13/2002 Added Overloaded procedures for OA UI
12: -- Subir Anshumali 06/03/2005 Declared OUT and IN OUT arguments as references using the NOCOPY hint
13: -- Sharma 07/04/2005 Modified LOAD_ROW, TRANSLATE_ROW and created
14: -- LOAD_SEED_ROW for R12 LCT standards bug 4411674

Line 65: ,DECODE(p_data_length,FND_API.G_MISS_NUM,NULL,p_data_length)

61: ) VALUES (
62: p_attribute_type_code
63: ,p_content_type_code
64: ,p_data_type_code
65: ,DECODE(p_data_length,FND_API.G_MISS_NUM,NULL,p_data_length)
66: ,DECODE(p_min_instances,FND_API.G_MISS_NUM,NULL,p_min_instances)
67: ,DECODE(p_max_instances,FND_API.G_MISS_NUM,NULL,p_max_instances)
68: ,DECODE(p_reference_code,FND_API.G_MISS_CHAR,NULL,p_reference_code)
69: ,DECODE(p_default_value,FND_API.G_MISS_CHAR,NULL,p_default_value)

Line 66: ,DECODE(p_min_instances,FND_API.G_MISS_NUM,NULL,p_min_instances)

62: p_attribute_type_code
63: ,p_content_type_code
64: ,p_data_type_code
65: ,DECODE(p_data_length,FND_API.G_MISS_NUM,NULL,p_data_length)
66: ,DECODE(p_min_instances,FND_API.G_MISS_NUM,NULL,p_min_instances)
67: ,DECODE(p_max_instances,FND_API.G_MISS_NUM,NULL,p_max_instances)
68: ,DECODE(p_reference_code,FND_API.G_MISS_CHAR,NULL,p_reference_code)
69: ,DECODE(p_default_value,FND_API.G_MISS_CHAR,NULL,p_default_value)
70: ,DECODE(p_updateable_flag,FND_API.G_MISS_CHAR,NULL,p_updateable_flag)

Line 67: ,DECODE(p_max_instances,FND_API.G_MISS_NUM,NULL,p_max_instances)

63: ,p_content_type_code
64: ,p_data_type_code
65: ,DECODE(p_data_length,FND_API.G_MISS_NUM,NULL,p_data_length)
66: ,DECODE(p_min_instances,FND_API.G_MISS_NUM,NULL,p_min_instances)
67: ,DECODE(p_max_instances,FND_API.G_MISS_NUM,NULL,p_max_instances)
68: ,DECODE(p_reference_code,FND_API.G_MISS_CHAR,NULL,p_reference_code)
69: ,DECODE(p_default_value,FND_API.G_MISS_CHAR,NULL,p_default_value)
70: ,DECODE(p_updateable_flag,FND_API.G_MISS_CHAR,NULL,p_updateable_flag)
71: ,DECODE(p_object_version_number,FND_API.G_MISS_NUM,1,NULL,1,p_object_version_number)

Line 68: ,DECODE(p_reference_code,FND_API.G_MISS_CHAR,NULL,p_reference_code)

64: ,p_data_type_code
65: ,DECODE(p_data_length,FND_API.G_MISS_NUM,NULL,p_data_length)
66: ,DECODE(p_min_instances,FND_API.G_MISS_NUM,NULL,p_min_instances)
67: ,DECODE(p_max_instances,FND_API.G_MISS_NUM,NULL,p_max_instances)
68: ,DECODE(p_reference_code,FND_API.G_MISS_CHAR,NULL,p_reference_code)
69: ,DECODE(p_default_value,FND_API.G_MISS_CHAR,NULL,p_default_value)
70: ,DECODE(p_updateable_flag,FND_API.G_MISS_CHAR,NULL,p_updateable_flag)
71: ,DECODE(p_object_version_number,FND_API.G_MISS_NUM,1,NULL,1,p_object_version_number)
72: ,DECODE(p_creation_date,FND_API.G_MISS_DATE,SYSDATE,NULL,SYSDATE,p_creation_date)

Line 69: ,DECODE(p_default_value,FND_API.G_MISS_CHAR,NULL,p_default_value)

65: ,DECODE(p_data_length,FND_API.G_MISS_NUM,NULL,p_data_length)
66: ,DECODE(p_min_instances,FND_API.G_MISS_NUM,NULL,p_min_instances)
67: ,DECODE(p_max_instances,FND_API.G_MISS_NUM,NULL,p_max_instances)
68: ,DECODE(p_reference_code,FND_API.G_MISS_CHAR,NULL,p_reference_code)
69: ,DECODE(p_default_value,FND_API.G_MISS_CHAR,NULL,p_default_value)
70: ,DECODE(p_updateable_flag,FND_API.G_MISS_CHAR,NULL,p_updateable_flag)
71: ,DECODE(p_object_version_number,FND_API.G_MISS_NUM,1,NULL,1,p_object_version_number)
72: ,DECODE(p_creation_date,FND_API.G_MISS_DATE,SYSDATE,NULL,SYSDATE,p_creation_date)
73: ,DECODE(p_created_by,FND_API.G_MISS_NUM,FND_GLOBAL.user_id,NULL,FND_GLOBAL.user_id,p_created_by)

Line 70: ,DECODE(p_updateable_flag,FND_API.G_MISS_CHAR,NULL,p_updateable_flag)

66: ,DECODE(p_min_instances,FND_API.G_MISS_NUM,NULL,p_min_instances)
67: ,DECODE(p_max_instances,FND_API.G_MISS_NUM,NULL,p_max_instances)
68: ,DECODE(p_reference_code,FND_API.G_MISS_CHAR,NULL,p_reference_code)
69: ,DECODE(p_default_value,FND_API.G_MISS_CHAR,NULL,p_default_value)
70: ,DECODE(p_updateable_flag,FND_API.G_MISS_CHAR,NULL,p_updateable_flag)
71: ,DECODE(p_object_version_number,FND_API.G_MISS_NUM,1,NULL,1,p_object_version_number)
72: ,DECODE(p_creation_date,FND_API.G_MISS_DATE,SYSDATE,NULL,SYSDATE,p_creation_date)
73: ,DECODE(p_created_by,FND_API.G_MISS_NUM,FND_GLOBAL.user_id,NULL,FND_GLOBAL.user_id,p_created_by)
74: ,DECODE(p_last_update_date,FND_API.G_MISS_DATE,SYSDATE,NULL,SYSDATE,p_last_update_date)

Line 71: ,DECODE(p_object_version_number,FND_API.G_MISS_NUM,1,NULL,1,p_object_version_number)

67: ,DECODE(p_max_instances,FND_API.G_MISS_NUM,NULL,p_max_instances)
68: ,DECODE(p_reference_code,FND_API.G_MISS_CHAR,NULL,p_reference_code)
69: ,DECODE(p_default_value,FND_API.G_MISS_CHAR,NULL,p_default_value)
70: ,DECODE(p_updateable_flag,FND_API.G_MISS_CHAR,NULL,p_updateable_flag)
71: ,DECODE(p_object_version_number,FND_API.G_MISS_NUM,1,NULL,1,p_object_version_number)
72: ,DECODE(p_creation_date,FND_API.G_MISS_DATE,SYSDATE,NULL,SYSDATE,p_creation_date)
73: ,DECODE(p_created_by,FND_API.G_MISS_NUM,FND_GLOBAL.user_id,NULL,FND_GLOBAL.user_id,p_created_by)
74: ,DECODE(p_last_update_date,FND_API.G_MISS_DATE,SYSDATE,NULL,SYSDATE,p_last_update_date)
75: ,DECODE(p_last_updated_by,FND_API.G_MISS_NUM,FND_GLOBAL.user_id,NULL,FND_GLOBAL.user_id,p_last_updated_by)

Line 72: ,DECODE(p_creation_date,FND_API.G_MISS_DATE,SYSDATE,NULL,SYSDATE,p_creation_date)

68: ,DECODE(p_reference_code,FND_API.G_MISS_CHAR,NULL,p_reference_code)
69: ,DECODE(p_default_value,FND_API.G_MISS_CHAR,NULL,p_default_value)
70: ,DECODE(p_updateable_flag,FND_API.G_MISS_CHAR,NULL,p_updateable_flag)
71: ,DECODE(p_object_version_number,FND_API.G_MISS_NUM,1,NULL,1,p_object_version_number)
72: ,DECODE(p_creation_date,FND_API.G_MISS_DATE,SYSDATE,NULL,SYSDATE,p_creation_date)
73: ,DECODE(p_created_by,FND_API.G_MISS_NUM,FND_GLOBAL.user_id,NULL,FND_GLOBAL.user_id,p_created_by)
74: ,DECODE(p_last_update_date,FND_API.G_MISS_DATE,SYSDATE,NULL,SYSDATE,p_last_update_date)
75: ,DECODE(p_last_updated_by,FND_API.G_MISS_NUM,FND_GLOBAL.user_id,NULL,FND_GLOBAL.user_id,p_last_updated_by)
76: ,DECODE(p_last_update_login,FND_API.G_MISS_NUM,FND_GLOBAL.login_id,NULL,FND_GLOBAL.user_id,p_last_update_login)

Line 73: ,DECODE(p_created_by,FND_API.G_MISS_NUM,FND_GLOBAL.user_id,NULL,FND_GLOBAL.user_id,p_created_by)

69: ,DECODE(p_default_value,FND_API.G_MISS_CHAR,NULL,p_default_value)
70: ,DECODE(p_updateable_flag,FND_API.G_MISS_CHAR,NULL,p_updateable_flag)
71: ,DECODE(p_object_version_number,FND_API.G_MISS_NUM,1,NULL,1,p_object_version_number)
72: ,DECODE(p_creation_date,FND_API.G_MISS_DATE,SYSDATE,NULL,SYSDATE,p_creation_date)
73: ,DECODE(p_created_by,FND_API.G_MISS_NUM,FND_GLOBAL.user_id,NULL,FND_GLOBAL.user_id,p_created_by)
74: ,DECODE(p_last_update_date,FND_API.G_MISS_DATE,SYSDATE,NULL,SYSDATE,p_last_update_date)
75: ,DECODE(p_last_updated_by,FND_API.G_MISS_NUM,FND_GLOBAL.user_id,NULL,FND_GLOBAL.user_id,p_last_updated_by)
76: ,DECODE(p_last_update_login,FND_API.G_MISS_NUM,FND_GLOBAL.login_id,NULL,FND_GLOBAL.user_id,p_last_update_login)
77: ,DECODE(p_display_order,FND_API.G_MISS_NUM,NULL,p_display_order)

Line 74: ,DECODE(p_last_update_date,FND_API.G_MISS_DATE,SYSDATE,NULL,SYSDATE,p_last_update_date)

70: ,DECODE(p_updateable_flag,FND_API.G_MISS_CHAR,NULL,p_updateable_flag)
71: ,DECODE(p_object_version_number,FND_API.G_MISS_NUM,1,NULL,1,p_object_version_number)
72: ,DECODE(p_creation_date,FND_API.G_MISS_DATE,SYSDATE,NULL,SYSDATE,p_creation_date)
73: ,DECODE(p_created_by,FND_API.G_MISS_NUM,FND_GLOBAL.user_id,NULL,FND_GLOBAL.user_id,p_created_by)
74: ,DECODE(p_last_update_date,FND_API.G_MISS_DATE,SYSDATE,NULL,SYSDATE,p_last_update_date)
75: ,DECODE(p_last_updated_by,FND_API.G_MISS_NUM,FND_GLOBAL.user_id,NULL,FND_GLOBAL.user_id,p_last_updated_by)
76: ,DECODE(p_last_update_login,FND_API.G_MISS_NUM,FND_GLOBAL.login_id,NULL,FND_GLOBAL.user_id,p_last_update_login)
77: ,DECODE(p_display_order,FND_API.G_MISS_NUM,NULL,p_display_order)
78: ,DECODE(p_flex_value_set_id,FND_API.G_MISS_NUM,NULL,p_flex_value_set_id)

Line 75: ,DECODE(p_last_updated_by,FND_API.G_MISS_NUM,FND_GLOBAL.user_id,NULL,FND_GLOBAL.user_id,p_last_updated_by)

71: ,DECODE(p_object_version_number,FND_API.G_MISS_NUM,1,NULL,1,p_object_version_number)
72: ,DECODE(p_creation_date,FND_API.G_MISS_DATE,SYSDATE,NULL,SYSDATE,p_creation_date)
73: ,DECODE(p_created_by,FND_API.G_MISS_NUM,FND_GLOBAL.user_id,NULL,FND_GLOBAL.user_id,p_created_by)
74: ,DECODE(p_last_update_date,FND_API.G_MISS_DATE,SYSDATE,NULL,SYSDATE,p_last_update_date)
75: ,DECODE(p_last_updated_by,FND_API.G_MISS_NUM,FND_GLOBAL.user_id,NULL,FND_GLOBAL.user_id,p_last_updated_by)
76: ,DECODE(p_last_update_login,FND_API.G_MISS_NUM,FND_GLOBAL.login_id,NULL,FND_GLOBAL.user_id,p_last_update_login)
77: ,DECODE(p_display_order,FND_API.G_MISS_NUM,NULL,p_display_order)
78: ,DECODE(p_flex_value_set_id,FND_API.G_MISS_NUM,NULL,p_flex_value_set_id)
79: );

Line 76: ,DECODE(p_last_update_login,FND_API.G_MISS_NUM,FND_GLOBAL.login_id,NULL,FND_GLOBAL.user_id,p_last_update_login)

72: ,DECODE(p_creation_date,FND_API.G_MISS_DATE,SYSDATE,NULL,SYSDATE,p_creation_date)
73: ,DECODE(p_created_by,FND_API.G_MISS_NUM,FND_GLOBAL.user_id,NULL,FND_GLOBAL.user_id,p_created_by)
74: ,DECODE(p_last_update_date,FND_API.G_MISS_DATE,SYSDATE,NULL,SYSDATE,p_last_update_date)
75: ,DECODE(p_last_updated_by,FND_API.G_MISS_NUM,FND_GLOBAL.user_id,NULL,FND_GLOBAL.user_id,p_last_updated_by)
76: ,DECODE(p_last_update_login,FND_API.G_MISS_NUM,FND_GLOBAL.login_id,NULL,FND_GLOBAL.user_id,p_last_update_login)
77: ,DECODE(p_display_order,FND_API.G_MISS_NUM,NULL,p_display_order)
78: ,DECODE(p_flex_value_set_id,FND_API.G_MISS_NUM,NULL,p_flex_value_set_id)
79: );
80:

Line 77: ,DECODE(p_display_order,FND_API.G_MISS_NUM,NULL,p_display_order)

73: ,DECODE(p_created_by,FND_API.G_MISS_NUM,FND_GLOBAL.user_id,NULL,FND_GLOBAL.user_id,p_created_by)
74: ,DECODE(p_last_update_date,FND_API.G_MISS_DATE,SYSDATE,NULL,SYSDATE,p_last_update_date)
75: ,DECODE(p_last_updated_by,FND_API.G_MISS_NUM,FND_GLOBAL.user_id,NULL,FND_GLOBAL.user_id,p_last_updated_by)
76: ,DECODE(p_last_update_login,FND_API.G_MISS_NUM,FND_GLOBAL.login_id,NULL,FND_GLOBAL.user_id,p_last_update_login)
77: ,DECODE(p_display_order,FND_API.G_MISS_NUM,NULL,p_display_order)
78: ,DECODE(p_flex_value_set_id,FND_API.G_MISS_NUM,NULL,p_flex_value_set_id)
79: );
80:
81: INSERT INTO ibc_attribute_types_tl (

Line 78: ,DECODE(p_flex_value_set_id,FND_API.G_MISS_NUM,NULL,p_flex_value_set_id)

74: ,DECODE(p_last_update_date,FND_API.G_MISS_DATE,SYSDATE,NULL,SYSDATE,p_last_update_date)
75: ,DECODE(p_last_updated_by,FND_API.G_MISS_NUM,FND_GLOBAL.user_id,NULL,FND_GLOBAL.user_id,p_last_updated_by)
76: ,DECODE(p_last_update_login,FND_API.G_MISS_NUM,FND_GLOBAL.login_id,NULL,FND_GLOBAL.user_id,p_last_update_login)
77: ,DECODE(p_display_order,FND_API.G_MISS_NUM,NULL,p_display_order)
78: ,DECODE(p_flex_value_set_id,FND_API.G_MISS_NUM,NULL,p_flex_value_set_id)
79: );
80:
81: INSERT INTO ibc_attribute_types_tl (
82: attribute_type_code

Line 97: ,DECODE(p_description,FND_API.G_MISS_CHAR,NULL,p_description)

93: ) SELECT
94: p_attribute_type_code
95: ,p_content_type_code
96: ,p_attribute_type_name
97: ,DECODE(p_description,FND_API.G_MISS_CHAR,NULL,p_description)
98: ,DECODE(p_creation_date,FND_API.G_MISS_DATE,SYSDATE,NULL,SYSDATE,p_creation_date)
99: ,DECODE(p_created_by,FND_API.G_MISS_NUM,FND_GLOBAL.user_id,NULL,FND_GLOBAL.user_id,p_created_by)
100: ,DECODE(p_last_update_date,FND_API.G_MISS_DATE,SYSDATE,NULL,SYSDATE,p_last_update_date)
101: ,DECODE(p_last_updated_by,FND_API.G_MISS_NUM,FND_GLOBAL.user_id,NULL,FND_GLOBAL.user_id,p_last_updated_by)

Line 98: ,DECODE(p_creation_date,FND_API.G_MISS_DATE,SYSDATE,NULL,SYSDATE,p_creation_date)

94: p_attribute_type_code
95: ,p_content_type_code
96: ,p_attribute_type_name
97: ,DECODE(p_description,FND_API.G_MISS_CHAR,NULL,p_description)
98: ,DECODE(p_creation_date,FND_API.G_MISS_DATE,SYSDATE,NULL,SYSDATE,p_creation_date)
99: ,DECODE(p_created_by,FND_API.G_MISS_NUM,FND_GLOBAL.user_id,NULL,FND_GLOBAL.user_id,p_created_by)
100: ,DECODE(p_last_update_date,FND_API.G_MISS_DATE,SYSDATE,NULL,SYSDATE,p_last_update_date)
101: ,DECODE(p_last_updated_by,FND_API.G_MISS_NUM,FND_GLOBAL.user_id,NULL,FND_GLOBAL.user_id,p_last_updated_by)
102: ,DECODE(p_last_update_login,FND_API.G_MISS_NUM,FND_GLOBAL.login_id,NULL,FND_GLOBAL.user_id,p_last_update_login)

Line 99: ,DECODE(p_created_by,FND_API.G_MISS_NUM,FND_GLOBAL.user_id,NULL,FND_GLOBAL.user_id,p_created_by)

95: ,p_content_type_code
96: ,p_attribute_type_name
97: ,DECODE(p_description,FND_API.G_MISS_CHAR,NULL,p_description)
98: ,DECODE(p_creation_date,FND_API.G_MISS_DATE,SYSDATE,NULL,SYSDATE,p_creation_date)
99: ,DECODE(p_created_by,FND_API.G_MISS_NUM,FND_GLOBAL.user_id,NULL,FND_GLOBAL.user_id,p_created_by)
100: ,DECODE(p_last_update_date,FND_API.G_MISS_DATE,SYSDATE,NULL,SYSDATE,p_last_update_date)
101: ,DECODE(p_last_updated_by,FND_API.G_MISS_NUM,FND_GLOBAL.user_id,NULL,FND_GLOBAL.user_id,p_last_updated_by)
102: ,DECODE(p_last_update_login,FND_API.G_MISS_NUM,FND_GLOBAL.login_id,NULL,FND_GLOBAL.user_id,p_last_update_login)
103: ,l.language_code

Line 100: ,DECODE(p_last_update_date,FND_API.G_MISS_DATE,SYSDATE,NULL,SYSDATE,p_last_update_date)

96: ,p_attribute_type_name
97: ,DECODE(p_description,FND_API.G_MISS_CHAR,NULL,p_description)
98: ,DECODE(p_creation_date,FND_API.G_MISS_DATE,SYSDATE,NULL,SYSDATE,p_creation_date)
99: ,DECODE(p_created_by,FND_API.G_MISS_NUM,FND_GLOBAL.user_id,NULL,FND_GLOBAL.user_id,p_created_by)
100: ,DECODE(p_last_update_date,FND_API.G_MISS_DATE,SYSDATE,NULL,SYSDATE,p_last_update_date)
101: ,DECODE(p_last_updated_by,FND_API.G_MISS_NUM,FND_GLOBAL.user_id,NULL,FND_GLOBAL.user_id,p_last_updated_by)
102: ,DECODE(p_last_update_login,FND_API.G_MISS_NUM,FND_GLOBAL.login_id,NULL,FND_GLOBAL.user_id,p_last_update_login)
103: ,l.language_code
104: ,USERENV('lang')

Line 101: ,DECODE(p_last_updated_by,FND_API.G_MISS_NUM,FND_GLOBAL.user_id,NULL,FND_GLOBAL.user_id,p_last_updated_by)

97: ,DECODE(p_description,FND_API.G_MISS_CHAR,NULL,p_description)
98: ,DECODE(p_creation_date,FND_API.G_MISS_DATE,SYSDATE,NULL,SYSDATE,p_creation_date)
99: ,DECODE(p_created_by,FND_API.G_MISS_NUM,FND_GLOBAL.user_id,NULL,FND_GLOBAL.user_id,p_created_by)
100: ,DECODE(p_last_update_date,FND_API.G_MISS_DATE,SYSDATE,NULL,SYSDATE,p_last_update_date)
101: ,DECODE(p_last_updated_by,FND_API.G_MISS_NUM,FND_GLOBAL.user_id,NULL,FND_GLOBAL.user_id,p_last_updated_by)
102: ,DECODE(p_last_update_login,FND_API.G_MISS_NUM,FND_GLOBAL.login_id,NULL,FND_GLOBAL.user_id,p_last_update_login)
103: ,l.language_code
104: ,USERENV('lang')
105: FROM fnd_languages l

Line 102: ,DECODE(p_last_update_login,FND_API.G_MISS_NUM,FND_GLOBAL.login_id,NULL,FND_GLOBAL.user_id,p_last_update_login)

98: ,DECODE(p_creation_date,FND_API.G_MISS_DATE,SYSDATE,NULL,SYSDATE,p_creation_date)
99: ,DECODE(p_created_by,FND_API.G_MISS_NUM,FND_GLOBAL.user_id,NULL,FND_GLOBAL.user_id,p_created_by)
100: ,DECODE(p_last_update_date,FND_API.G_MISS_DATE,SYSDATE,NULL,SYSDATE,p_last_update_date)
101: ,DECODE(p_last_updated_by,FND_API.G_MISS_NUM,FND_GLOBAL.user_id,NULL,FND_GLOBAL.user_id,p_last_updated_by)
102: ,DECODE(p_last_update_login,FND_API.G_MISS_NUM,FND_GLOBAL.login_id,NULL,FND_GLOBAL.user_id,p_last_update_login)
103: ,l.language_code
104: ,USERENV('lang')
105: FROM fnd_languages l
106: WHERE l.installed_flag IN ('I', 'B')

Line 229: content_type_code = DECODE(p_content_type_code,FND_API.G_MISS_CHAR,NULL,NULL,content_type_code,p_content_type_code)

225: )
226: IS
227: BEGIN
228: UPDATE ibc_attribute_types_b SET
229: content_type_code = DECODE(p_content_type_code,FND_API.G_MISS_CHAR,NULL,NULL,content_type_code,p_content_type_code)
230: ,data_type_code = DECODE(p_data_type_code,FND_API.G_MISS_CHAR,NULL,NULL,data_type_code,p_data_type_code)
231: ,data_length = DECODE(p_data_length,FND_API.G_MISS_NUM,NULL,NULL,data_length,p_data_length)
232: ,min_instances = DECODE(p_min_instances,FND_API.G_MISS_NUM,NULL,NULL,min_instances,p_min_instances)
233: ,max_instances = DECODE(p_max_instances,FND_API.G_MISS_NUM,NULL,NULL,max_instances,p_max_instances)

Line 230: ,data_type_code = DECODE(p_data_type_code,FND_API.G_MISS_CHAR,NULL,NULL,data_type_code,p_data_type_code)

226: IS
227: BEGIN
228: UPDATE ibc_attribute_types_b SET
229: content_type_code = DECODE(p_content_type_code,FND_API.G_MISS_CHAR,NULL,NULL,content_type_code,p_content_type_code)
230: ,data_type_code = DECODE(p_data_type_code,FND_API.G_MISS_CHAR,NULL,NULL,data_type_code,p_data_type_code)
231: ,data_length = DECODE(p_data_length,FND_API.G_MISS_NUM,NULL,NULL,data_length,p_data_length)
232: ,min_instances = DECODE(p_min_instances,FND_API.G_MISS_NUM,NULL,NULL,min_instances,p_min_instances)
233: ,max_instances = DECODE(p_max_instances,FND_API.G_MISS_NUM,NULL,NULL,max_instances,p_max_instances)
234: ,reference_code = DECODE(p_reference_code,FND_API.G_MISS_CHAR,NULL,NULL,reference_code,p_reference_code)

Line 231: ,data_length = DECODE(p_data_length,FND_API.G_MISS_NUM,NULL,NULL,data_length,p_data_length)

227: BEGIN
228: UPDATE ibc_attribute_types_b SET
229: content_type_code = DECODE(p_content_type_code,FND_API.G_MISS_CHAR,NULL,NULL,content_type_code,p_content_type_code)
230: ,data_type_code = DECODE(p_data_type_code,FND_API.G_MISS_CHAR,NULL,NULL,data_type_code,p_data_type_code)
231: ,data_length = DECODE(p_data_length,FND_API.G_MISS_NUM,NULL,NULL,data_length,p_data_length)
232: ,min_instances = DECODE(p_min_instances,FND_API.G_MISS_NUM,NULL,NULL,min_instances,p_min_instances)
233: ,max_instances = DECODE(p_max_instances,FND_API.G_MISS_NUM,NULL,NULL,max_instances,p_max_instances)
234: ,reference_code = DECODE(p_reference_code,FND_API.G_MISS_CHAR,NULL,NULL,reference_code,p_reference_code)
235: ,default_value = DECODE(p_default_value,FND_API.G_MISS_CHAR,NULL,NULL,default_value,p_default_value)

Line 232: ,min_instances = DECODE(p_min_instances,FND_API.G_MISS_NUM,NULL,NULL,min_instances,p_min_instances)

228: UPDATE ibc_attribute_types_b SET
229: content_type_code = DECODE(p_content_type_code,FND_API.G_MISS_CHAR,NULL,NULL,content_type_code,p_content_type_code)
230: ,data_type_code = DECODE(p_data_type_code,FND_API.G_MISS_CHAR,NULL,NULL,data_type_code,p_data_type_code)
231: ,data_length = DECODE(p_data_length,FND_API.G_MISS_NUM,NULL,NULL,data_length,p_data_length)
232: ,min_instances = DECODE(p_min_instances,FND_API.G_MISS_NUM,NULL,NULL,min_instances,p_min_instances)
233: ,max_instances = DECODE(p_max_instances,FND_API.G_MISS_NUM,NULL,NULL,max_instances,p_max_instances)
234: ,reference_code = DECODE(p_reference_code,FND_API.G_MISS_CHAR,NULL,NULL,reference_code,p_reference_code)
235: ,default_value = DECODE(p_default_value,FND_API.G_MISS_CHAR,NULL,NULL,default_value,p_default_value)
236: ,updateable_flag = DECODE(p_updateable_flag,FND_API.G_MISS_CHAR,NULL,NULL,updateable_flag,p_updateable_flag)

Line 233: ,max_instances = DECODE(p_max_instances,FND_API.G_MISS_NUM,NULL,NULL,max_instances,p_max_instances)

229: content_type_code = DECODE(p_content_type_code,FND_API.G_MISS_CHAR,NULL,NULL,content_type_code,p_content_type_code)
230: ,data_type_code = DECODE(p_data_type_code,FND_API.G_MISS_CHAR,NULL,NULL,data_type_code,p_data_type_code)
231: ,data_length = DECODE(p_data_length,FND_API.G_MISS_NUM,NULL,NULL,data_length,p_data_length)
232: ,min_instances = DECODE(p_min_instances,FND_API.G_MISS_NUM,NULL,NULL,min_instances,p_min_instances)
233: ,max_instances = DECODE(p_max_instances,FND_API.G_MISS_NUM,NULL,NULL,max_instances,p_max_instances)
234: ,reference_code = DECODE(p_reference_code,FND_API.G_MISS_CHAR,NULL,NULL,reference_code,p_reference_code)
235: ,default_value = DECODE(p_default_value,FND_API.G_MISS_CHAR,NULL,NULL,default_value,p_default_value)
236: ,updateable_flag = DECODE(p_updateable_flag,FND_API.G_MISS_CHAR,NULL,NULL,updateable_flag,p_updateable_flag)
237: ,object_version_number = NVL(object_version_number,0) + 1

Line 234: ,reference_code = DECODE(p_reference_code,FND_API.G_MISS_CHAR,NULL,NULL,reference_code,p_reference_code)

230: ,data_type_code = DECODE(p_data_type_code,FND_API.G_MISS_CHAR,NULL,NULL,data_type_code,p_data_type_code)
231: ,data_length = DECODE(p_data_length,FND_API.G_MISS_NUM,NULL,NULL,data_length,p_data_length)
232: ,min_instances = DECODE(p_min_instances,FND_API.G_MISS_NUM,NULL,NULL,min_instances,p_min_instances)
233: ,max_instances = DECODE(p_max_instances,FND_API.G_MISS_NUM,NULL,NULL,max_instances,p_max_instances)
234: ,reference_code = DECODE(p_reference_code,FND_API.G_MISS_CHAR,NULL,NULL,reference_code,p_reference_code)
235: ,default_value = DECODE(p_default_value,FND_API.G_MISS_CHAR,NULL,NULL,default_value,p_default_value)
236: ,updateable_flag = DECODE(p_updateable_flag,FND_API.G_MISS_CHAR,NULL,NULL,updateable_flag,p_updateable_flag)
237: ,object_version_number = NVL(object_version_number,0) + 1
238: ,last_update_date = DECODE(p_last_update_date,FND_API.G_MISS_DATE,SYSDATE,NULL,SYSDATE,p_last_update_date)

Line 235: ,default_value = DECODE(p_default_value,FND_API.G_MISS_CHAR,NULL,NULL,default_value,p_default_value)

231: ,data_length = DECODE(p_data_length,FND_API.G_MISS_NUM,NULL,NULL,data_length,p_data_length)
232: ,min_instances = DECODE(p_min_instances,FND_API.G_MISS_NUM,NULL,NULL,min_instances,p_min_instances)
233: ,max_instances = DECODE(p_max_instances,FND_API.G_MISS_NUM,NULL,NULL,max_instances,p_max_instances)
234: ,reference_code = DECODE(p_reference_code,FND_API.G_MISS_CHAR,NULL,NULL,reference_code,p_reference_code)
235: ,default_value = DECODE(p_default_value,FND_API.G_MISS_CHAR,NULL,NULL,default_value,p_default_value)
236: ,updateable_flag = DECODE(p_updateable_flag,FND_API.G_MISS_CHAR,NULL,NULL,updateable_flag,p_updateable_flag)
237: ,object_version_number = NVL(object_version_number,0) + 1
238: ,last_update_date = DECODE(p_last_update_date,FND_API.G_MISS_DATE,SYSDATE,NULL,SYSDATE,p_last_update_date)
239: ,last_updated_by = DECODE(p_last_updated_by,FND_API.G_MISS_NUM,FND_GLOBAL.user_id,NULL,FND_GLOBAL.user_id,p_last_updated_by)

Line 236: ,updateable_flag = DECODE(p_updateable_flag,FND_API.G_MISS_CHAR,NULL,NULL,updateable_flag,p_updateable_flag)

232: ,min_instances = DECODE(p_min_instances,FND_API.G_MISS_NUM,NULL,NULL,min_instances,p_min_instances)
233: ,max_instances = DECODE(p_max_instances,FND_API.G_MISS_NUM,NULL,NULL,max_instances,p_max_instances)
234: ,reference_code = DECODE(p_reference_code,FND_API.G_MISS_CHAR,NULL,NULL,reference_code,p_reference_code)
235: ,default_value = DECODE(p_default_value,FND_API.G_MISS_CHAR,NULL,NULL,default_value,p_default_value)
236: ,updateable_flag = DECODE(p_updateable_flag,FND_API.G_MISS_CHAR,NULL,NULL,updateable_flag,p_updateable_flag)
237: ,object_version_number = NVL(object_version_number,0) + 1
238: ,last_update_date = DECODE(p_last_update_date,FND_API.G_MISS_DATE,SYSDATE,NULL,SYSDATE,p_last_update_date)
239: ,last_updated_by = DECODE(p_last_updated_by,FND_API.G_MISS_NUM,FND_GLOBAL.user_id,NULL,FND_GLOBAL.user_id,p_last_updated_by)
240: ,last_update_login = DECODE(p_last_update_login,FND_API.G_MISS_NUM,FND_GLOBAL.login_id,NULL,FND_GLOBAL.user_id,p_last_update_login)

Line 238: ,last_update_date = DECODE(p_last_update_date,FND_API.G_MISS_DATE,SYSDATE,NULL,SYSDATE,p_last_update_date)

234: ,reference_code = DECODE(p_reference_code,FND_API.G_MISS_CHAR,NULL,NULL,reference_code,p_reference_code)
235: ,default_value = DECODE(p_default_value,FND_API.G_MISS_CHAR,NULL,NULL,default_value,p_default_value)
236: ,updateable_flag = DECODE(p_updateable_flag,FND_API.G_MISS_CHAR,NULL,NULL,updateable_flag,p_updateable_flag)
237: ,object_version_number = NVL(object_version_number,0) + 1
238: ,last_update_date = DECODE(p_last_update_date,FND_API.G_MISS_DATE,SYSDATE,NULL,SYSDATE,p_last_update_date)
239: ,last_updated_by = DECODE(p_last_updated_by,FND_API.G_MISS_NUM,FND_GLOBAL.user_id,NULL,FND_GLOBAL.user_id,p_last_updated_by)
240: ,last_update_login = DECODE(p_last_update_login,FND_API.G_MISS_NUM,FND_GLOBAL.login_id,NULL,FND_GLOBAL.user_id,p_last_update_login)
241: ,display_order = DECODE(p_display_order,FND_API.G_MISS_NUM,NULL,NULL,display_order,p_display_order)
242: ,flex_value_set_id = DECODE(p_flex_value_set_id,FND_API.G_MISS_NUM,NULL,NULL,flex_value_set_id,p_flex_value_set_id)

Line 239: ,last_updated_by = DECODE(p_last_updated_by,FND_API.G_MISS_NUM,FND_GLOBAL.user_id,NULL,FND_GLOBAL.user_id,p_last_updated_by)

235: ,default_value = DECODE(p_default_value,FND_API.G_MISS_CHAR,NULL,NULL,default_value,p_default_value)
236: ,updateable_flag = DECODE(p_updateable_flag,FND_API.G_MISS_CHAR,NULL,NULL,updateable_flag,p_updateable_flag)
237: ,object_version_number = NVL(object_version_number,0) + 1
238: ,last_update_date = DECODE(p_last_update_date,FND_API.G_MISS_DATE,SYSDATE,NULL,SYSDATE,p_last_update_date)
239: ,last_updated_by = DECODE(p_last_updated_by,FND_API.G_MISS_NUM,FND_GLOBAL.user_id,NULL,FND_GLOBAL.user_id,p_last_updated_by)
240: ,last_update_login = DECODE(p_last_update_login,FND_API.G_MISS_NUM,FND_GLOBAL.login_id,NULL,FND_GLOBAL.user_id,p_last_update_login)
241: ,display_order = DECODE(p_display_order,FND_API.G_MISS_NUM,NULL,NULL,display_order,p_display_order)
242: ,flex_value_set_id = DECODE(p_flex_value_set_id,FND_API.G_MISS_NUM,NULL,NULL,flex_value_set_id,p_flex_value_set_id)
243: WHERE attribute_type_code = p_attribute_type_code

Line 240: ,last_update_login = DECODE(p_last_update_login,FND_API.G_MISS_NUM,FND_GLOBAL.login_id,NULL,FND_GLOBAL.user_id,p_last_update_login)

236: ,updateable_flag = DECODE(p_updateable_flag,FND_API.G_MISS_CHAR,NULL,NULL,updateable_flag,p_updateable_flag)
237: ,object_version_number = NVL(object_version_number,0) + 1
238: ,last_update_date = DECODE(p_last_update_date,FND_API.G_MISS_DATE,SYSDATE,NULL,SYSDATE,p_last_update_date)
239: ,last_updated_by = DECODE(p_last_updated_by,FND_API.G_MISS_NUM,FND_GLOBAL.user_id,NULL,FND_GLOBAL.user_id,p_last_updated_by)
240: ,last_update_login = DECODE(p_last_update_login,FND_API.G_MISS_NUM,FND_GLOBAL.login_id,NULL,FND_GLOBAL.user_id,p_last_update_login)
241: ,display_order = DECODE(p_display_order,FND_API.G_MISS_NUM,NULL,NULL,display_order,p_display_order)
242: ,flex_value_set_id = DECODE(p_flex_value_set_id,FND_API.G_MISS_NUM,NULL,NULL,flex_value_set_id,p_flex_value_set_id)
243: WHERE attribute_type_code = p_attribute_type_code
244: AND content_type_code = p_content_type_code

Line 241: ,display_order = DECODE(p_display_order,FND_API.G_MISS_NUM,NULL,NULL,display_order,p_display_order)

237: ,object_version_number = NVL(object_version_number,0) + 1
238: ,last_update_date = DECODE(p_last_update_date,FND_API.G_MISS_DATE,SYSDATE,NULL,SYSDATE,p_last_update_date)
239: ,last_updated_by = DECODE(p_last_updated_by,FND_API.G_MISS_NUM,FND_GLOBAL.user_id,NULL,FND_GLOBAL.user_id,p_last_updated_by)
240: ,last_update_login = DECODE(p_last_update_login,FND_API.G_MISS_NUM,FND_GLOBAL.login_id,NULL,FND_GLOBAL.user_id,p_last_update_login)
241: ,display_order = DECODE(p_display_order,FND_API.G_MISS_NUM,NULL,NULL,display_order,p_display_order)
242: ,flex_value_set_id = DECODE(p_flex_value_set_id,FND_API.G_MISS_NUM,NULL,NULL,flex_value_set_id,p_flex_value_set_id)
243: WHERE attribute_type_code = p_attribute_type_code
244: AND content_type_code = p_content_type_code
245: AND object_version_number = DECODE(p_object_version_number,

Line 242: ,flex_value_set_id = DECODE(p_flex_value_set_id,FND_API.G_MISS_NUM,NULL,NULL,flex_value_set_id,p_flex_value_set_id)

238: ,last_update_date = DECODE(p_last_update_date,FND_API.G_MISS_DATE,SYSDATE,NULL,SYSDATE,p_last_update_date)
239: ,last_updated_by = DECODE(p_last_updated_by,FND_API.G_MISS_NUM,FND_GLOBAL.user_id,NULL,FND_GLOBAL.user_id,p_last_updated_by)
240: ,last_update_login = DECODE(p_last_update_login,FND_API.G_MISS_NUM,FND_GLOBAL.login_id,NULL,FND_GLOBAL.user_id,p_last_update_login)
241: ,display_order = DECODE(p_display_order,FND_API.G_MISS_NUM,NULL,NULL,display_order,p_display_order)
242: ,flex_value_set_id = DECODE(p_flex_value_set_id,FND_API.G_MISS_NUM,NULL,NULL,flex_value_set_id,p_flex_value_set_id)
243: WHERE attribute_type_code = p_attribute_type_code
244: AND content_type_code = p_content_type_code
245: AND object_version_number = DECODE(p_object_version_number,
246: fnd_api.g_miss_num,

Line 246: fnd_api.g_miss_num,

242: ,flex_value_set_id = DECODE(p_flex_value_set_id,FND_API.G_MISS_NUM,NULL,NULL,flex_value_set_id,p_flex_value_set_id)
243: WHERE attribute_type_code = p_attribute_type_code
244: AND content_type_code = p_content_type_code
245: AND object_version_number = DECODE(p_object_version_number,
246: fnd_api.g_miss_num,
247: object_version_number,
248: NULL,
249: object_version_number,
250: p_object_version_number);

Line 257: attribute_type_name = DECODE(p_attribute_type_name,FND_API.G_MISS_CHAR,NULL,NULL,attribute_type_name,p_attribute_type_name)

253: RAISE NO_DATA_FOUND;
254: END IF;
255:
256: UPDATE ibc_attribute_types_tl SET
257: attribute_type_name = DECODE(p_attribute_type_name,FND_API.G_MISS_CHAR,NULL,NULL,attribute_type_name,p_attribute_type_name)
258: ,description = DECODE(p_description,FND_API.G_MISS_CHAR,NULL,NULL,description,p_description)
259: ,last_update_date = DECODE(p_last_update_date,FND_API.G_MISS_DATE,SYSDATE,NULL,SYSDATE,p_last_update_date)
260: ,last_updated_by = DECODE(p_last_updated_by,FND_API.G_MISS_NUM,FND_GLOBAL.user_id,NULL,FND_GLOBAL.user_id,p_last_updated_by)
261: ,last_update_login = DECODE(p_last_update_login,FND_API.G_MISS_NUM,FND_GLOBAL.login_id,NULL,FND_GLOBAL.user_id,p_last_update_login)

Line 258: ,description = DECODE(p_description,FND_API.G_MISS_CHAR,NULL,NULL,description,p_description)

254: END IF;
255:
256: UPDATE ibc_attribute_types_tl SET
257: attribute_type_name = DECODE(p_attribute_type_name,FND_API.G_MISS_CHAR,NULL,NULL,attribute_type_name,p_attribute_type_name)
258: ,description = DECODE(p_description,FND_API.G_MISS_CHAR,NULL,NULL,description,p_description)
259: ,last_update_date = DECODE(p_last_update_date,FND_API.G_MISS_DATE,SYSDATE,NULL,SYSDATE,p_last_update_date)
260: ,last_updated_by = DECODE(p_last_updated_by,FND_API.G_MISS_NUM,FND_GLOBAL.user_id,NULL,FND_GLOBAL.user_id,p_last_updated_by)
261: ,last_update_login = DECODE(p_last_update_login,FND_API.G_MISS_NUM,FND_GLOBAL.login_id,NULL,FND_GLOBAL.user_id,p_last_update_login)
262: ,source_lang = USERENV('lang')

Line 259: ,last_update_date = DECODE(p_last_update_date,FND_API.G_MISS_DATE,SYSDATE,NULL,SYSDATE,p_last_update_date)

255:
256: UPDATE ibc_attribute_types_tl SET
257: attribute_type_name = DECODE(p_attribute_type_name,FND_API.G_MISS_CHAR,NULL,NULL,attribute_type_name,p_attribute_type_name)
258: ,description = DECODE(p_description,FND_API.G_MISS_CHAR,NULL,NULL,description,p_description)
259: ,last_update_date = DECODE(p_last_update_date,FND_API.G_MISS_DATE,SYSDATE,NULL,SYSDATE,p_last_update_date)
260: ,last_updated_by = DECODE(p_last_updated_by,FND_API.G_MISS_NUM,FND_GLOBAL.user_id,NULL,FND_GLOBAL.user_id,p_last_updated_by)
261: ,last_update_login = DECODE(p_last_update_login,FND_API.G_MISS_NUM,FND_GLOBAL.login_id,NULL,FND_GLOBAL.user_id,p_last_update_login)
262: ,source_lang = USERENV('lang')
263: WHERE attribute_type_code = p_attribute_type_code

Line 260: ,last_updated_by = DECODE(p_last_updated_by,FND_API.G_MISS_NUM,FND_GLOBAL.user_id,NULL,FND_GLOBAL.user_id,p_last_updated_by)

256: UPDATE ibc_attribute_types_tl SET
257: attribute_type_name = DECODE(p_attribute_type_name,FND_API.G_MISS_CHAR,NULL,NULL,attribute_type_name,p_attribute_type_name)
258: ,description = DECODE(p_description,FND_API.G_MISS_CHAR,NULL,NULL,description,p_description)
259: ,last_update_date = DECODE(p_last_update_date,FND_API.G_MISS_DATE,SYSDATE,NULL,SYSDATE,p_last_update_date)
260: ,last_updated_by = DECODE(p_last_updated_by,FND_API.G_MISS_NUM,FND_GLOBAL.user_id,NULL,FND_GLOBAL.user_id,p_last_updated_by)
261: ,last_update_login = DECODE(p_last_update_login,FND_API.G_MISS_NUM,FND_GLOBAL.login_id,NULL,FND_GLOBAL.user_id,p_last_update_login)
262: ,source_lang = USERENV('lang')
263: WHERE attribute_type_code = p_attribute_type_code
264: AND content_type_code = p_content_type_code

Line 261: ,last_update_login = DECODE(p_last_update_login,FND_API.G_MISS_NUM,FND_GLOBAL.login_id,NULL,FND_GLOBAL.user_id,p_last_update_login)

257: attribute_type_name = DECODE(p_attribute_type_name,FND_API.G_MISS_CHAR,NULL,NULL,attribute_type_name,p_attribute_type_name)
258: ,description = DECODE(p_description,FND_API.G_MISS_CHAR,NULL,NULL,description,p_description)
259: ,last_update_date = DECODE(p_last_update_date,FND_API.G_MISS_DATE,SYSDATE,NULL,SYSDATE,p_last_update_date)
260: ,last_updated_by = DECODE(p_last_updated_by,FND_API.G_MISS_NUM,FND_GLOBAL.user_id,NULL,FND_GLOBAL.user_id,p_last_updated_by)
261: ,last_update_login = DECODE(p_last_update_login,FND_API.G_MISS_NUM,FND_GLOBAL.login_id,NULL,FND_GLOBAL.user_id,p_last_update_login)
262: ,source_lang = USERENV('lang')
263: WHERE attribute_type_code = p_attribute_type_code
264: AND content_type_code = p_content_type_code
265: AND USERENV('lang') IN (LANGUAGE, source_lang);

Line 482: fnd_api.g_miss_num,

478: FROM ibc_attribute_types_b
479: WHERE attribute_type_code = p_attribute_type_code
480: AND content_type_code = p_content_type_code
481: AND object_version_number = DECODE(object_version_number,
482: fnd_api.g_miss_num,
483: object_version_number,
484: NULL,
485: object_version_number,
486: object_version_number);

Line 492: p_attribute_type_code => NVL(p_attribute_type_code,FND_API.G_MISS_CHAR)

488: IF (FND_LOAD_UTIL.UPLOAD_TEST(l_user_id, l_last_update_date,
489: db_user_id, db_last_update_date, p_upload_mode )) THEN
490:
491: Ibc_Attribute_Types_Pkg.Update_row (
492: p_attribute_type_code => NVL(p_attribute_type_code,FND_API.G_MISS_CHAR)
493: ,p_content_type_code => NVL(p_content_type_code,FND_API.G_MISS_CHAR)
494: ,p_data_type_code => NVL(p_data_type_code,FND_API.G_MISS_CHAR)
495: ,p_data_length => NVL(p_data_length,FND_API.G_MISS_NUM)
496: ,p_min_instances => NVL(p_min_instances,FND_API.G_MISS_NUM)

Line 493: ,p_content_type_code => NVL(p_content_type_code,FND_API.G_MISS_CHAR)

489: db_user_id, db_last_update_date, p_upload_mode )) THEN
490:
491: Ibc_Attribute_Types_Pkg.Update_row (
492: p_attribute_type_code => NVL(p_attribute_type_code,FND_API.G_MISS_CHAR)
493: ,p_content_type_code => NVL(p_content_type_code,FND_API.G_MISS_CHAR)
494: ,p_data_type_code => NVL(p_data_type_code,FND_API.G_MISS_CHAR)
495: ,p_data_length => NVL(p_data_length,FND_API.G_MISS_NUM)
496: ,p_min_instances => NVL(p_min_instances,FND_API.G_MISS_NUM)
497: ,p_max_instances => NVL(p_max_instances,FND_API.G_MISS_NUM)

Line 494: ,p_data_type_code => NVL(p_data_type_code,FND_API.G_MISS_CHAR)

490:
491: Ibc_Attribute_Types_Pkg.Update_row (
492: p_attribute_type_code => NVL(p_attribute_type_code,FND_API.G_MISS_CHAR)
493: ,p_content_type_code => NVL(p_content_type_code,FND_API.G_MISS_CHAR)
494: ,p_data_type_code => NVL(p_data_type_code,FND_API.G_MISS_CHAR)
495: ,p_data_length => NVL(p_data_length,FND_API.G_MISS_NUM)
496: ,p_min_instances => NVL(p_min_instances,FND_API.G_MISS_NUM)
497: ,p_max_instances => NVL(p_max_instances,FND_API.G_MISS_NUM)
498: ,p_reference_code => NVL(p_reference_code,FND_API.G_MISS_CHAR)

Line 495: ,p_data_length => NVL(p_data_length,FND_API.G_MISS_NUM)

491: Ibc_Attribute_Types_Pkg.Update_row (
492: p_attribute_type_code => NVL(p_attribute_type_code,FND_API.G_MISS_CHAR)
493: ,p_content_type_code => NVL(p_content_type_code,FND_API.G_MISS_CHAR)
494: ,p_data_type_code => NVL(p_data_type_code,FND_API.G_MISS_CHAR)
495: ,p_data_length => NVL(p_data_length,FND_API.G_MISS_NUM)
496: ,p_min_instances => NVL(p_min_instances,FND_API.G_MISS_NUM)
497: ,p_max_instances => NVL(p_max_instances,FND_API.G_MISS_NUM)
498: ,p_reference_code => NVL(p_reference_code,FND_API.G_MISS_CHAR)
499: ,p_default_value => NVL(p_default_value,FND_API.G_MISS_CHAR)

Line 496: ,p_min_instances => NVL(p_min_instances,FND_API.G_MISS_NUM)

492: p_attribute_type_code => NVL(p_attribute_type_code,FND_API.G_MISS_CHAR)
493: ,p_content_type_code => NVL(p_content_type_code,FND_API.G_MISS_CHAR)
494: ,p_data_type_code => NVL(p_data_type_code,FND_API.G_MISS_CHAR)
495: ,p_data_length => NVL(p_data_length,FND_API.G_MISS_NUM)
496: ,p_min_instances => NVL(p_min_instances,FND_API.G_MISS_NUM)
497: ,p_max_instances => NVL(p_max_instances,FND_API.G_MISS_NUM)
498: ,p_reference_code => NVL(p_reference_code,FND_API.G_MISS_CHAR)
499: ,p_default_value => NVL(p_default_value,FND_API.G_MISS_CHAR)
500: ,p_updateable_flag => NVL(p_updateable_flag,FND_API.G_MISS_CHAR)

Line 497: ,p_max_instances => NVL(p_max_instances,FND_API.G_MISS_NUM)

493: ,p_content_type_code => NVL(p_content_type_code,FND_API.G_MISS_CHAR)
494: ,p_data_type_code => NVL(p_data_type_code,FND_API.G_MISS_CHAR)
495: ,p_data_length => NVL(p_data_length,FND_API.G_MISS_NUM)
496: ,p_min_instances => NVL(p_min_instances,FND_API.G_MISS_NUM)
497: ,p_max_instances => NVL(p_max_instances,FND_API.G_MISS_NUM)
498: ,p_reference_code => NVL(p_reference_code,FND_API.G_MISS_CHAR)
499: ,p_default_value => NVL(p_default_value,FND_API.G_MISS_CHAR)
500: ,p_updateable_flag => NVL(p_updateable_flag,FND_API.G_MISS_CHAR)
501: ,p_object_version_number => NULL

Line 498: ,p_reference_code => NVL(p_reference_code,FND_API.G_MISS_CHAR)

494: ,p_data_type_code => NVL(p_data_type_code,FND_API.G_MISS_CHAR)
495: ,p_data_length => NVL(p_data_length,FND_API.G_MISS_NUM)
496: ,p_min_instances => NVL(p_min_instances,FND_API.G_MISS_NUM)
497: ,p_max_instances => NVL(p_max_instances,FND_API.G_MISS_NUM)
498: ,p_reference_code => NVL(p_reference_code,FND_API.G_MISS_CHAR)
499: ,p_default_value => NVL(p_default_value,FND_API.G_MISS_CHAR)
500: ,p_updateable_flag => NVL(p_updateable_flag,FND_API.G_MISS_CHAR)
501: ,p_object_version_number => NULL
502: ,p_attribute_type_name => NVL(p_attribute_type_name,FND_API.G_MISS_CHAR)

Line 499: ,p_default_value => NVL(p_default_value,FND_API.G_MISS_CHAR)

495: ,p_data_length => NVL(p_data_length,FND_API.G_MISS_NUM)
496: ,p_min_instances => NVL(p_min_instances,FND_API.G_MISS_NUM)
497: ,p_max_instances => NVL(p_max_instances,FND_API.G_MISS_NUM)
498: ,p_reference_code => NVL(p_reference_code,FND_API.G_MISS_CHAR)
499: ,p_default_value => NVL(p_default_value,FND_API.G_MISS_CHAR)
500: ,p_updateable_flag => NVL(p_updateable_flag,FND_API.G_MISS_CHAR)
501: ,p_object_version_number => NULL
502: ,p_attribute_type_name => NVL(p_attribute_type_name,FND_API.G_MISS_CHAR)
503: ,p_description => NVL(p_description,FND_API.G_MISS_CHAR)

Line 500: ,p_updateable_flag => NVL(p_updateable_flag,FND_API.G_MISS_CHAR)

496: ,p_min_instances => NVL(p_min_instances,FND_API.G_MISS_NUM)
497: ,p_max_instances => NVL(p_max_instances,FND_API.G_MISS_NUM)
498: ,p_reference_code => NVL(p_reference_code,FND_API.G_MISS_CHAR)
499: ,p_default_value => NVL(p_default_value,FND_API.G_MISS_CHAR)
500: ,p_updateable_flag => NVL(p_updateable_flag,FND_API.G_MISS_CHAR)
501: ,p_object_version_number => NULL
502: ,p_attribute_type_name => NVL(p_attribute_type_name,FND_API.G_MISS_CHAR)
503: ,p_description => NVL(p_description,FND_API.G_MISS_CHAR)
504: ,p_last_update_date => l_last_update_date

Line 502: ,p_attribute_type_name => NVL(p_attribute_type_name,FND_API.G_MISS_CHAR)

498: ,p_reference_code => NVL(p_reference_code,FND_API.G_MISS_CHAR)
499: ,p_default_value => NVL(p_default_value,FND_API.G_MISS_CHAR)
500: ,p_updateable_flag => NVL(p_updateable_flag,FND_API.G_MISS_CHAR)
501: ,p_object_version_number => NULL
502: ,p_attribute_type_name => NVL(p_attribute_type_name,FND_API.G_MISS_CHAR)
503: ,p_description => NVL(p_description,FND_API.G_MISS_CHAR)
504: ,p_last_update_date => l_last_update_date
505: ,p_last_updated_by => l_user_id
506: ,p_last_update_login => 0

Line 503: ,p_description => NVL(p_description,FND_API.G_MISS_CHAR)

499: ,p_default_value => NVL(p_default_value,FND_API.G_MISS_CHAR)
500: ,p_updateable_flag => NVL(p_updateable_flag,FND_API.G_MISS_CHAR)
501: ,p_object_version_number => NULL
502: ,p_attribute_type_name => NVL(p_attribute_type_name,FND_API.G_MISS_CHAR)
503: ,p_description => NVL(p_description,FND_API.G_MISS_CHAR)
504: ,p_last_update_date => l_last_update_date
505: ,p_last_updated_by => l_user_id
506: ,p_last_update_login => 0
507: ,p_display_order => NVL(p_display_order,FND_API.G_MISS_NUM)

Line 507: ,p_display_order => NVL(p_display_order,FND_API.G_MISS_NUM)

503: ,p_description => NVL(p_description,FND_API.G_MISS_CHAR)
504: ,p_last_update_date => l_last_update_date
505: ,p_last_updated_by => l_user_id
506: ,p_last_update_login => 0
507: ,p_display_order => NVL(p_display_order,FND_API.G_MISS_NUM)
508: ,p_flex_value_set_id => NVL(p_flex_value_set_id,FND_API.G_MISS_NUM)
509: );
510: END IF;
511:

Line 508: ,p_flex_value_set_id => NVL(p_flex_value_set_id,FND_API.G_MISS_NUM)

504: ,p_last_update_date => l_last_update_date
505: ,p_last_updated_by => l_user_id
506: ,p_last_update_login => 0
507: ,p_display_order => NVL(p_display_order,FND_API.G_MISS_NUM)
508: ,p_flex_value_set_id => NVL(p_flex_value_set_id,FND_API.G_MISS_NUM)
509: );
510: END IF;
511:
512: EXCEPTION

Line 526: p_object_version_number =>FND_API.G_MISS_NUM,

522: p_max_instances =>p_max_instances,
523: p_reference_code =>p_reference_code,
524: p_default_value =>p_default_value,
525: p_updateable_flag =>p_updateable_flag,
526: p_object_version_number =>FND_API.G_MISS_NUM,
527: p_attribute_type_name =>p_attribute_type_name,
528: p_description =>p_description,
529: p_creation_date =>l_last_update_date,
530: p_created_by =>l_user_id,