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.PV_ATTRIBUTE_CODE_PKG dependencies on FND_API

Line 72: DECODE( px_attr_code_id, FND_API.g_miss_num, NULL, px_attr_code_id),

68: object_version_number,
69: attribute_id,
70: enabled_flag
71: ) VALUES (
72: DECODE( px_attr_code_id, FND_API.g_miss_num, NULL, px_attr_code_id),
73: DECODE( p_attr_code, FND_API.g_miss_char, NULL, p_attr_code),
74: DECODE( p_last_update_date, FND_API.g_miss_date, NULL, p_last_update_date),
75: DECODE( p_last_updated_by, FND_API.g_miss_num, NULL, p_last_updated_by),
76: DECODE( p_creation_date, FND_API.g_miss_date, NULL, p_creation_date),

Line 73: DECODE( p_attr_code, FND_API.g_miss_char, NULL, p_attr_code),

69: attribute_id,
70: enabled_flag
71: ) VALUES (
72: DECODE( px_attr_code_id, FND_API.g_miss_num, NULL, px_attr_code_id),
73: DECODE( p_attr_code, FND_API.g_miss_char, NULL, p_attr_code),
74: DECODE( p_last_update_date, FND_API.g_miss_date, NULL, p_last_update_date),
75: DECODE( p_last_updated_by, FND_API.g_miss_num, NULL, p_last_updated_by),
76: DECODE( p_creation_date, FND_API.g_miss_date, NULL, p_creation_date),
77: DECODE( p_created_by, FND_API.g_miss_num, NULL, p_created_by),

Line 74: DECODE( p_last_update_date, FND_API.g_miss_date, NULL, p_last_update_date),

70: enabled_flag
71: ) VALUES (
72: DECODE( px_attr_code_id, FND_API.g_miss_num, NULL, px_attr_code_id),
73: DECODE( p_attr_code, FND_API.g_miss_char, NULL, p_attr_code),
74: DECODE( p_last_update_date, FND_API.g_miss_date, NULL, p_last_update_date),
75: DECODE( p_last_updated_by, FND_API.g_miss_num, NULL, p_last_updated_by),
76: DECODE( p_creation_date, FND_API.g_miss_date, NULL, p_creation_date),
77: DECODE( p_created_by, FND_API.g_miss_num, NULL, p_created_by),
78: DECODE( p_last_update_login, FND_API.g_miss_num, NULL, p_last_update_login),

Line 75: DECODE( p_last_updated_by, FND_API.g_miss_num, NULL, p_last_updated_by),

71: ) VALUES (
72: DECODE( px_attr_code_id, FND_API.g_miss_num, NULL, px_attr_code_id),
73: DECODE( p_attr_code, FND_API.g_miss_char, NULL, p_attr_code),
74: DECODE( p_last_update_date, FND_API.g_miss_date, NULL, p_last_update_date),
75: DECODE( p_last_updated_by, FND_API.g_miss_num, NULL, p_last_updated_by),
76: DECODE( p_creation_date, FND_API.g_miss_date, NULL, p_creation_date),
77: DECODE( p_created_by, FND_API.g_miss_num, NULL, p_created_by),
78: DECODE( p_last_update_login, FND_API.g_miss_num, NULL, p_last_update_login),
79: DECODE( px_object_version_number, FND_API.g_miss_num, NULL, px_object_version_number),

Line 76: DECODE( p_creation_date, FND_API.g_miss_date, NULL, p_creation_date),

72: DECODE( px_attr_code_id, FND_API.g_miss_num, NULL, px_attr_code_id),
73: DECODE( p_attr_code, FND_API.g_miss_char, NULL, p_attr_code),
74: DECODE( p_last_update_date, FND_API.g_miss_date, NULL, p_last_update_date),
75: DECODE( p_last_updated_by, FND_API.g_miss_num, NULL, p_last_updated_by),
76: DECODE( p_creation_date, FND_API.g_miss_date, NULL, p_creation_date),
77: DECODE( p_created_by, FND_API.g_miss_num, NULL, p_created_by),
78: DECODE( p_last_update_login, FND_API.g_miss_num, NULL, p_last_update_login),
79: DECODE( px_object_version_number, FND_API.g_miss_num, NULL, px_object_version_number),
80: DECODE( p_attribute_id, FND_API.g_miss_num, NULL, p_attribute_id),

Line 77: DECODE( p_created_by, FND_API.g_miss_num, NULL, p_created_by),

73: DECODE( p_attr_code, FND_API.g_miss_char, NULL, p_attr_code),
74: DECODE( p_last_update_date, FND_API.g_miss_date, NULL, p_last_update_date),
75: DECODE( p_last_updated_by, FND_API.g_miss_num, NULL, p_last_updated_by),
76: DECODE( p_creation_date, FND_API.g_miss_date, NULL, p_creation_date),
77: DECODE( p_created_by, FND_API.g_miss_num, NULL, p_created_by),
78: DECODE( p_last_update_login, FND_API.g_miss_num, NULL, p_last_update_login),
79: DECODE( px_object_version_number, FND_API.g_miss_num, NULL, px_object_version_number),
80: DECODE( p_attribute_id, FND_API.g_miss_num, NULL, p_attribute_id),
81: DECODE( p_enabled_flag, FND_API.g_miss_char, NULL, p_enabled_flag)

Line 78: DECODE( p_last_update_login, FND_API.g_miss_num, NULL, p_last_update_login),

74: DECODE( p_last_update_date, FND_API.g_miss_date, NULL, p_last_update_date),
75: DECODE( p_last_updated_by, FND_API.g_miss_num, NULL, p_last_updated_by),
76: DECODE( p_creation_date, FND_API.g_miss_date, NULL, p_creation_date),
77: DECODE( p_created_by, FND_API.g_miss_num, NULL, p_created_by),
78: DECODE( p_last_update_login, FND_API.g_miss_num, NULL, p_last_update_login),
79: DECODE( px_object_version_number, FND_API.g_miss_num, NULL, px_object_version_number),
80: DECODE( p_attribute_id, FND_API.g_miss_num, NULL, p_attribute_id),
81: DECODE( p_enabled_flag, FND_API.g_miss_char, NULL, p_enabled_flag)
82:

Line 79: DECODE( px_object_version_number, FND_API.g_miss_num, NULL, px_object_version_number),

75: DECODE( p_last_updated_by, FND_API.g_miss_num, NULL, p_last_updated_by),
76: DECODE( p_creation_date, FND_API.g_miss_date, NULL, p_creation_date),
77: DECODE( p_created_by, FND_API.g_miss_num, NULL, p_created_by),
78: DECODE( p_last_update_login, FND_API.g_miss_num, NULL, p_last_update_login),
79: DECODE( px_object_version_number, FND_API.g_miss_num, NULL, px_object_version_number),
80: DECODE( p_attribute_id, FND_API.g_miss_num, NULL, p_attribute_id),
81: DECODE( p_enabled_flag, FND_API.g_miss_char, NULL, p_enabled_flag)
82:
83: );

Line 80: DECODE( p_attribute_id, FND_API.g_miss_num, NULL, p_attribute_id),

76: DECODE( p_creation_date, FND_API.g_miss_date, NULL, p_creation_date),
77: DECODE( p_created_by, FND_API.g_miss_num, NULL, p_created_by),
78: DECODE( p_last_update_login, FND_API.g_miss_num, NULL, p_last_update_login),
79: DECODE( px_object_version_number, FND_API.g_miss_num, NULL, px_object_version_number),
80: DECODE( p_attribute_id, FND_API.g_miss_num, NULL, p_attribute_id),
81: DECODE( p_enabled_flag, FND_API.g_miss_char, NULL, p_enabled_flag)
82:
83: );
84:

Line 81: DECODE( p_enabled_flag, FND_API.g_miss_char, NULL, p_enabled_flag)

77: DECODE( p_created_by, FND_API.g_miss_num, NULL, p_created_by),
78: DECODE( p_last_update_login, FND_API.g_miss_num, NULL, p_last_update_login),
79: DECODE( px_object_version_number, FND_API.g_miss_num, NULL, px_object_version_number),
80: DECODE( p_attribute_id, FND_API.g_miss_num, NULL, p_attribute_id),
81: DECODE( p_enabled_flag, FND_API.g_miss_char, NULL, p_enabled_flag)
82:
83: );
84:
85:

Line 99: DECODE( px_attr_code_id, FND_API.g_miss_num, NULL, px_attr_code_id),

95: object_version_number,
96: description
97: --security_group_id
98: ) SELECT
99: DECODE( px_attr_code_id, FND_API.g_miss_num, NULL, px_attr_code_id),
100: FNDL.language_code,
101: USERENV('LANG'),
102: DECODE( p_last_update_date, FND_API.g_miss_date, NULL, p_last_update_date),
103: DECODE( p_last_updated_by, FND_API.g_miss_num, NULL, p_last_updated_by),

Line 102: DECODE( p_last_update_date, FND_API.g_miss_date, NULL, p_last_update_date),

98: ) SELECT
99: DECODE( px_attr_code_id, FND_API.g_miss_num, NULL, px_attr_code_id),
100: FNDL.language_code,
101: USERENV('LANG'),
102: DECODE( p_last_update_date, FND_API.g_miss_date, NULL, p_last_update_date),
103: DECODE( p_last_updated_by, FND_API.g_miss_num, NULL, p_last_updated_by),
104: DECODE( p_creation_date, FND_API.g_miss_date, NULL, p_creation_date),
105: DECODE( p_created_by, FND_API.g_miss_num, NULL, p_created_by),
106: DECODE( p_last_update_login, FND_API.g_miss_num, NULL, p_last_update_login),

Line 103: DECODE( p_last_updated_by, FND_API.g_miss_num, NULL, p_last_updated_by),

99: DECODE( px_attr_code_id, FND_API.g_miss_num, NULL, px_attr_code_id),
100: FNDL.language_code,
101: USERENV('LANG'),
102: DECODE( p_last_update_date, FND_API.g_miss_date, NULL, p_last_update_date),
103: DECODE( p_last_updated_by, FND_API.g_miss_num, NULL, p_last_updated_by),
104: DECODE( p_creation_date, FND_API.g_miss_date, NULL, p_creation_date),
105: DECODE( p_created_by, FND_API.g_miss_num, NULL, p_created_by),
106: DECODE( p_last_update_login, FND_API.g_miss_num, NULL, p_last_update_login),
107: DECODE( px_object_version_number, FND_API.g_miss_num, NULL, px_object_version_number),

Line 104: DECODE( p_creation_date, FND_API.g_miss_date, NULL, p_creation_date),

100: FNDL.language_code,
101: USERENV('LANG'),
102: DECODE( p_last_update_date, FND_API.g_miss_date, NULL, p_last_update_date),
103: DECODE( p_last_updated_by, FND_API.g_miss_num, NULL, p_last_updated_by),
104: DECODE( p_creation_date, FND_API.g_miss_date, NULL, p_creation_date),
105: DECODE( p_created_by, FND_API.g_miss_num, NULL, p_created_by),
106: DECODE( p_last_update_login, FND_API.g_miss_num, NULL, p_last_update_login),
107: DECODE( px_object_version_number, FND_API.g_miss_num, NULL, px_object_version_number),
108: DECODE( p_description, FND_API.g_miss_char, NULL, p_description)

Line 105: DECODE( p_created_by, FND_API.g_miss_num, NULL, p_created_by),

101: USERENV('LANG'),
102: DECODE( p_last_update_date, FND_API.g_miss_date, NULL, p_last_update_date),
103: DECODE( p_last_updated_by, FND_API.g_miss_num, NULL, p_last_updated_by),
104: DECODE( p_creation_date, FND_API.g_miss_date, NULL, p_creation_date),
105: DECODE( p_created_by, FND_API.g_miss_num, NULL, p_created_by),
106: DECODE( p_last_update_login, FND_API.g_miss_num, NULL, p_last_update_login),
107: DECODE( px_object_version_number, FND_API.g_miss_num, NULL, px_object_version_number),
108: DECODE( p_description, FND_API.g_miss_char, NULL, p_description)
109: --DECODE( p_security_group_id, FND_API.g_miss_num, NULL, p_security_group_id)

Line 106: DECODE( p_last_update_login, FND_API.g_miss_num, NULL, p_last_update_login),

102: DECODE( p_last_update_date, FND_API.g_miss_date, NULL, p_last_update_date),
103: DECODE( p_last_updated_by, FND_API.g_miss_num, NULL, p_last_updated_by),
104: DECODE( p_creation_date, FND_API.g_miss_date, NULL, p_creation_date),
105: DECODE( p_created_by, FND_API.g_miss_num, NULL, p_created_by),
106: DECODE( p_last_update_login, FND_API.g_miss_num, NULL, p_last_update_login),
107: DECODE( px_object_version_number, FND_API.g_miss_num, NULL, px_object_version_number),
108: DECODE( p_description, FND_API.g_miss_char, NULL, p_description)
109: --DECODE( p_security_group_id, FND_API.g_miss_num, NULL, p_security_group_id)
110: FROM fnd_languages FNDL

Line 107: DECODE( px_object_version_number, FND_API.g_miss_num, NULL, px_object_version_number),

103: DECODE( p_last_updated_by, FND_API.g_miss_num, NULL, p_last_updated_by),
104: DECODE( p_creation_date, FND_API.g_miss_date, NULL, p_creation_date),
105: DECODE( p_created_by, FND_API.g_miss_num, NULL, p_created_by),
106: DECODE( p_last_update_login, FND_API.g_miss_num, NULL, p_last_update_login),
107: DECODE( px_object_version_number, FND_API.g_miss_num, NULL, px_object_version_number),
108: DECODE( p_description, FND_API.g_miss_char, NULL, p_description)
109: --DECODE( p_security_group_id, FND_API.g_miss_num, NULL, p_security_group_id)
110: FROM fnd_languages FNDL
111: WHERE FNDL.installed_flag in ('I', 'B')

Line 108: DECODE( p_description, FND_API.g_miss_char, NULL, p_description)

104: DECODE( p_creation_date, FND_API.g_miss_date, NULL, p_creation_date),
105: DECODE( p_created_by, FND_API.g_miss_num, NULL, p_created_by),
106: DECODE( p_last_update_login, FND_API.g_miss_num, NULL, p_last_update_login),
107: DECODE( px_object_version_number, FND_API.g_miss_num, NULL, px_object_version_number),
108: DECODE( p_description, FND_API.g_miss_char, NULL, p_description)
109: --DECODE( p_security_group_id, FND_API.g_miss_num, NULL, p_security_group_id)
110: FROM fnd_languages FNDL
111: WHERE FNDL.installed_flag in ('I', 'B')
112: AND NOT EXISTS(

Line 109: --DECODE( p_security_group_id, FND_API.g_miss_num, NULL, p_security_group_id)

105: DECODE( p_created_by, FND_API.g_miss_num, NULL, p_created_by),
106: DECODE( p_last_update_login, FND_API.g_miss_num, NULL, p_last_update_login),
107: DECODE( px_object_version_number, FND_API.g_miss_num, NULL, px_object_version_number),
108: DECODE( p_description, FND_API.g_miss_char, NULL, p_description)
109: --DECODE( p_security_group_id, FND_API.g_miss_num, NULL, p_security_group_id)
110: FROM fnd_languages FNDL
111: WHERE FNDL.installed_flag in ('I', 'B')
112: AND NOT EXISTS(
113: SELECT NULL

Line 142: p_creation_date DATE := FND_API.g_miss_date ,

138: p_attr_code_id NUMBER,
139: p_attr_code VARCHAR2,
140: p_last_update_date DATE,
141: p_last_updated_by NUMBER,
142: p_creation_date DATE := FND_API.g_miss_date ,
143: p_created_by NUMBER := FND_API.g_miss_num ,
144: p_last_update_login NUMBER,
145: p_object_version_number NUMBER,
146: p_attribute_id NUMBER,

Line 143: p_created_by NUMBER := FND_API.g_miss_num ,

139: p_attr_code VARCHAR2,
140: p_last_update_date DATE,
141: p_last_updated_by NUMBER,
142: p_creation_date DATE := FND_API.g_miss_date ,
143: p_created_by NUMBER := FND_API.g_miss_num ,
144: p_last_update_login NUMBER,
145: p_object_version_number NUMBER,
146: p_attribute_id NUMBER,
147: p_enabled_flag VARCHAR2,

Line 154: attr_code_id = DECODE( p_attr_code_id, FND_API.g_miss_num, attr_code_id, p_attr_code_id),

150: IS
151: BEGIN
152: Update PV_ATTRIBUTE_CODES_B
153: SET
154: attr_code_id = DECODE( p_attr_code_id, FND_API.g_miss_num, attr_code_id, p_attr_code_id),
155: attr_code = DECODE( p_attr_code, FND_API.g_miss_char, attr_code, p_attr_code),
156: last_update_date = DECODE( p_last_update_date, FND_API.g_miss_date, last_update_date, p_last_update_date),
157: last_updated_by = DECODE( p_last_updated_by, FND_API.g_miss_num, last_updated_by, p_last_updated_by),
158: --creation_date = DECODE( p_creation_date, FND_API.g_miss_date, creation_date, p_creation_date),

Line 155: attr_code = DECODE( p_attr_code, FND_API.g_miss_char, attr_code, p_attr_code),

151: BEGIN
152: Update PV_ATTRIBUTE_CODES_B
153: SET
154: attr_code_id = DECODE( p_attr_code_id, FND_API.g_miss_num, attr_code_id, p_attr_code_id),
155: attr_code = DECODE( p_attr_code, FND_API.g_miss_char, attr_code, p_attr_code),
156: last_update_date = DECODE( p_last_update_date, FND_API.g_miss_date, last_update_date, p_last_update_date),
157: last_updated_by = DECODE( p_last_updated_by, FND_API.g_miss_num, last_updated_by, p_last_updated_by),
158: --creation_date = DECODE( p_creation_date, FND_API.g_miss_date, creation_date, p_creation_date),
159: --created_by = DECODE( p_created_by, FND_API.g_miss_num, created_by, p_created_by),

Line 156: last_update_date = DECODE( p_last_update_date, FND_API.g_miss_date, last_update_date, p_last_update_date),

152: Update PV_ATTRIBUTE_CODES_B
153: SET
154: attr_code_id = DECODE( p_attr_code_id, FND_API.g_miss_num, attr_code_id, p_attr_code_id),
155: attr_code = DECODE( p_attr_code, FND_API.g_miss_char, attr_code, p_attr_code),
156: last_update_date = DECODE( p_last_update_date, FND_API.g_miss_date, last_update_date, p_last_update_date),
157: last_updated_by = DECODE( p_last_updated_by, FND_API.g_miss_num, last_updated_by, p_last_updated_by),
158: --creation_date = DECODE( p_creation_date, FND_API.g_miss_date, creation_date, p_creation_date),
159: --created_by = DECODE( p_created_by, FND_API.g_miss_num, created_by, p_created_by),
160: last_update_login = DECODE( p_last_update_login, FND_API.g_miss_num, last_update_login, p_last_update_login),

Line 157: last_updated_by = DECODE( p_last_updated_by, FND_API.g_miss_num, last_updated_by, p_last_updated_by),

153: SET
154: attr_code_id = DECODE( p_attr_code_id, FND_API.g_miss_num, attr_code_id, p_attr_code_id),
155: attr_code = DECODE( p_attr_code, FND_API.g_miss_char, attr_code, p_attr_code),
156: last_update_date = DECODE( p_last_update_date, FND_API.g_miss_date, last_update_date, p_last_update_date),
157: last_updated_by = DECODE( p_last_updated_by, FND_API.g_miss_num, last_updated_by, p_last_updated_by),
158: --creation_date = DECODE( p_creation_date, FND_API.g_miss_date, creation_date, p_creation_date),
159: --created_by = DECODE( p_created_by, FND_API.g_miss_num, created_by, p_created_by),
160: last_update_login = DECODE( p_last_update_login, FND_API.g_miss_num, last_update_login, p_last_update_login),
161: object_version_number = DECODE( p_object_version_number, FND_API.g_miss_num, object_version_number, p_object_version_number+1),

Line 158: --creation_date = DECODE( p_creation_date, FND_API.g_miss_date, creation_date, p_creation_date),

154: attr_code_id = DECODE( p_attr_code_id, FND_API.g_miss_num, attr_code_id, p_attr_code_id),
155: attr_code = DECODE( p_attr_code, FND_API.g_miss_char, attr_code, p_attr_code),
156: last_update_date = DECODE( p_last_update_date, FND_API.g_miss_date, last_update_date, p_last_update_date),
157: last_updated_by = DECODE( p_last_updated_by, FND_API.g_miss_num, last_updated_by, p_last_updated_by),
158: --creation_date = DECODE( p_creation_date, FND_API.g_miss_date, creation_date, p_creation_date),
159: --created_by = DECODE( p_created_by, FND_API.g_miss_num, created_by, p_created_by),
160: last_update_login = DECODE( p_last_update_login, FND_API.g_miss_num, last_update_login, p_last_update_login),
161: object_version_number = DECODE( p_object_version_number, FND_API.g_miss_num, object_version_number, p_object_version_number+1),
162: attribute_id = DECODE( p_attribute_id, FND_API.g_miss_num, attribute_id, p_attribute_id),

Line 159: --created_by = DECODE( p_created_by, FND_API.g_miss_num, created_by, p_created_by),

155: attr_code = DECODE( p_attr_code, FND_API.g_miss_char, attr_code, p_attr_code),
156: last_update_date = DECODE( p_last_update_date, FND_API.g_miss_date, last_update_date, p_last_update_date),
157: last_updated_by = DECODE( p_last_updated_by, FND_API.g_miss_num, last_updated_by, p_last_updated_by),
158: --creation_date = DECODE( p_creation_date, FND_API.g_miss_date, creation_date, p_creation_date),
159: --created_by = DECODE( p_created_by, FND_API.g_miss_num, created_by, p_created_by),
160: last_update_login = DECODE( p_last_update_login, FND_API.g_miss_num, last_update_login, p_last_update_login),
161: object_version_number = DECODE( p_object_version_number, FND_API.g_miss_num, object_version_number, p_object_version_number+1),
162: attribute_id = DECODE( p_attribute_id, FND_API.g_miss_num, attribute_id, p_attribute_id),
163: enabled_flag = DECODE( p_enabled_flag, FND_API.g_miss_char, enabled_flag, p_enabled_flag)

Line 160: last_update_login = DECODE( p_last_update_login, FND_API.g_miss_num, last_update_login, p_last_update_login),

156: last_update_date = DECODE( p_last_update_date, FND_API.g_miss_date, last_update_date, p_last_update_date),
157: last_updated_by = DECODE( p_last_updated_by, FND_API.g_miss_num, last_updated_by, p_last_updated_by),
158: --creation_date = DECODE( p_creation_date, FND_API.g_miss_date, creation_date, p_creation_date),
159: --created_by = DECODE( p_created_by, FND_API.g_miss_num, created_by, p_created_by),
160: last_update_login = DECODE( p_last_update_login, FND_API.g_miss_num, last_update_login, p_last_update_login),
161: object_version_number = DECODE( p_object_version_number, FND_API.g_miss_num, object_version_number, p_object_version_number+1),
162: attribute_id = DECODE( p_attribute_id, FND_API.g_miss_num, attribute_id, p_attribute_id),
163: enabled_flag = DECODE( p_enabled_flag, FND_API.g_miss_char, enabled_flag, p_enabled_flag)
164:

Line 161: object_version_number = DECODE( p_object_version_number, FND_API.g_miss_num, object_version_number, p_object_version_number+1),

157: last_updated_by = DECODE( p_last_updated_by, FND_API.g_miss_num, last_updated_by, p_last_updated_by),
158: --creation_date = DECODE( p_creation_date, FND_API.g_miss_date, creation_date, p_creation_date),
159: --created_by = DECODE( p_created_by, FND_API.g_miss_num, created_by, p_created_by),
160: last_update_login = DECODE( p_last_update_login, FND_API.g_miss_num, last_update_login, p_last_update_login),
161: object_version_number = DECODE( p_object_version_number, FND_API.g_miss_num, object_version_number, p_object_version_number+1),
162: attribute_id = DECODE( p_attribute_id, FND_API.g_miss_num, attribute_id, p_attribute_id),
163: enabled_flag = DECODE( p_enabled_flag, FND_API.g_miss_char, enabled_flag, p_enabled_flag)
164:
165: WHERE ATTR_CODE_ID = p_ATTR_CODE_ID

Line 162: attribute_id = DECODE( p_attribute_id, FND_API.g_miss_num, attribute_id, p_attribute_id),

158: --creation_date = DECODE( p_creation_date, FND_API.g_miss_date, creation_date, p_creation_date),
159: --created_by = DECODE( p_created_by, FND_API.g_miss_num, created_by, p_created_by),
160: last_update_login = DECODE( p_last_update_login, FND_API.g_miss_num, last_update_login, p_last_update_login),
161: object_version_number = DECODE( p_object_version_number, FND_API.g_miss_num, object_version_number, p_object_version_number+1),
162: attribute_id = DECODE( p_attribute_id, FND_API.g_miss_num, attribute_id, p_attribute_id),
163: enabled_flag = DECODE( p_enabled_flag, FND_API.g_miss_char, enabled_flag, p_enabled_flag)
164:
165: WHERE ATTR_CODE_ID = p_ATTR_CODE_ID
166: AND object_version_number = p_object_version_number;

Line 163: enabled_flag = DECODE( p_enabled_flag, FND_API.g_miss_char, enabled_flag, p_enabled_flag)

159: --created_by = DECODE( p_created_by, FND_API.g_miss_num, created_by, p_created_by),
160: last_update_login = DECODE( p_last_update_login, FND_API.g_miss_num, last_update_login, p_last_update_login),
161: object_version_number = DECODE( p_object_version_number, FND_API.g_miss_num, object_version_number, p_object_version_number+1),
162: attribute_id = DECODE( p_attribute_id, FND_API.g_miss_num, attribute_id, p_attribute_id),
163: enabled_flag = DECODE( p_enabled_flag, FND_API.g_miss_char, enabled_flag, p_enabled_flag)
164:
165: WHERE ATTR_CODE_ID = p_ATTR_CODE_ID
166: AND object_version_number = p_object_version_number;
167:

Line 169: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

165: WHERE ATTR_CODE_ID = p_ATTR_CODE_ID
166: AND object_version_number = p_object_version_number;
167:
168: IF (SQL%NOTFOUND) THEN
169: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
170: END IF;
171:
172: Update PV_ATTRIBUTE_CODES_TL
173: SET

Line 174: attr_code_id = DECODE( p_attr_code_id, FND_API.g_miss_num, attr_code_id, p_attr_code_id),

170: END IF;
171:
172: Update PV_ATTRIBUTE_CODES_TL
173: SET
174: attr_code_id = DECODE( p_attr_code_id, FND_API.g_miss_num, attr_code_id, p_attr_code_id),
175: source_lang = userenv('LANG'),
176: last_update_date = DECODE( p_last_update_date, FND_API.g_miss_date, last_update_date, p_last_update_date),
177: last_updated_by = DECODE( p_last_updated_by, FND_API.g_miss_num, last_updated_by, p_last_updated_by),
178: --creation_date = DECODE( p_creation_date, FND_API.g_miss_date, creation_date, p_creation_date),

Line 176: last_update_date = DECODE( p_last_update_date, FND_API.g_miss_date, last_update_date, p_last_update_date),

172: Update PV_ATTRIBUTE_CODES_TL
173: SET
174: attr_code_id = DECODE( p_attr_code_id, FND_API.g_miss_num, attr_code_id, p_attr_code_id),
175: source_lang = userenv('LANG'),
176: last_update_date = DECODE( p_last_update_date, FND_API.g_miss_date, last_update_date, p_last_update_date),
177: last_updated_by = DECODE( p_last_updated_by, FND_API.g_miss_num, last_updated_by, p_last_updated_by),
178: --creation_date = DECODE( p_creation_date, FND_API.g_miss_date, creation_date, p_creation_date),
179: --created_by = DECODE( p_created_by, FND_API.g_miss_num, created_by, p_created_by),
180: last_update_login = DECODE( p_last_update_login, FND_API.g_miss_num, last_update_login, p_last_update_login),

Line 177: last_updated_by = DECODE( p_last_updated_by, FND_API.g_miss_num, last_updated_by, p_last_updated_by),

173: SET
174: attr_code_id = DECODE( p_attr_code_id, FND_API.g_miss_num, attr_code_id, p_attr_code_id),
175: source_lang = userenv('LANG'),
176: last_update_date = DECODE( p_last_update_date, FND_API.g_miss_date, last_update_date, p_last_update_date),
177: last_updated_by = DECODE( p_last_updated_by, FND_API.g_miss_num, last_updated_by, p_last_updated_by),
178: --creation_date = DECODE( p_creation_date, FND_API.g_miss_date, creation_date, p_creation_date),
179: --created_by = DECODE( p_created_by, FND_API.g_miss_num, created_by, p_created_by),
180: last_update_login = DECODE( p_last_update_login, FND_API.g_miss_num, last_update_login, p_last_update_login),
181: object_version_number = DECODE( p_object_version_number, FND_API.g_miss_num, object_version_number, p_object_version_number+1),

Line 178: --creation_date = DECODE( p_creation_date, FND_API.g_miss_date, creation_date, p_creation_date),

174: attr_code_id = DECODE( p_attr_code_id, FND_API.g_miss_num, attr_code_id, p_attr_code_id),
175: source_lang = userenv('LANG'),
176: last_update_date = DECODE( p_last_update_date, FND_API.g_miss_date, last_update_date, p_last_update_date),
177: last_updated_by = DECODE( p_last_updated_by, FND_API.g_miss_num, last_updated_by, p_last_updated_by),
178: --creation_date = DECODE( p_creation_date, FND_API.g_miss_date, creation_date, p_creation_date),
179: --created_by = DECODE( p_created_by, FND_API.g_miss_num, created_by, p_created_by),
180: last_update_login = DECODE( p_last_update_login, FND_API.g_miss_num, last_update_login, p_last_update_login),
181: object_version_number = DECODE( p_object_version_number, FND_API.g_miss_num, object_version_number, p_object_version_number+1),
182: description = DECODE( p_description, FND_API.g_miss_char, description, p_description)

Line 179: --created_by = DECODE( p_created_by, FND_API.g_miss_num, created_by, p_created_by),

175: source_lang = userenv('LANG'),
176: last_update_date = DECODE( p_last_update_date, FND_API.g_miss_date, last_update_date, p_last_update_date),
177: last_updated_by = DECODE( p_last_updated_by, FND_API.g_miss_num, last_updated_by, p_last_updated_by),
178: --creation_date = DECODE( p_creation_date, FND_API.g_miss_date, creation_date, p_creation_date),
179: --created_by = DECODE( p_created_by, FND_API.g_miss_num, created_by, p_created_by),
180: last_update_login = DECODE( p_last_update_login, FND_API.g_miss_num, last_update_login, p_last_update_login),
181: object_version_number = DECODE( p_object_version_number, FND_API.g_miss_num, object_version_number, p_object_version_number+1),
182: description = DECODE( p_description, FND_API.g_miss_char, description, p_description)
183: --security_group_id = DECODE( p_security_group_id, FND_API.g_miss_num, security_group_id, p_security_group_id)

Line 180: last_update_login = DECODE( p_last_update_login, FND_API.g_miss_num, last_update_login, p_last_update_login),

176: last_update_date = DECODE( p_last_update_date, FND_API.g_miss_date, last_update_date, p_last_update_date),
177: last_updated_by = DECODE( p_last_updated_by, FND_API.g_miss_num, last_updated_by, p_last_updated_by),
178: --creation_date = DECODE( p_creation_date, FND_API.g_miss_date, creation_date, p_creation_date),
179: --created_by = DECODE( p_created_by, FND_API.g_miss_num, created_by, p_created_by),
180: last_update_login = DECODE( p_last_update_login, FND_API.g_miss_num, last_update_login, p_last_update_login),
181: object_version_number = DECODE( p_object_version_number, FND_API.g_miss_num, object_version_number, p_object_version_number+1),
182: description = DECODE( p_description, FND_API.g_miss_char, description, p_description)
183: --security_group_id = DECODE( p_security_group_id, FND_API.g_miss_num, security_group_id, p_security_group_id)
184: WHERE ATTR_CODE_ID = p_ATTR_CODE_ID

Line 181: object_version_number = DECODE( p_object_version_number, FND_API.g_miss_num, object_version_number, p_object_version_number+1),

177: last_updated_by = DECODE( p_last_updated_by, FND_API.g_miss_num, last_updated_by, p_last_updated_by),
178: --creation_date = DECODE( p_creation_date, FND_API.g_miss_date, creation_date, p_creation_date),
179: --created_by = DECODE( p_created_by, FND_API.g_miss_num, created_by, p_created_by),
180: last_update_login = DECODE( p_last_update_login, FND_API.g_miss_num, last_update_login, p_last_update_login),
181: object_version_number = DECODE( p_object_version_number, FND_API.g_miss_num, object_version_number, p_object_version_number+1),
182: description = DECODE( p_description, FND_API.g_miss_char, description, p_description)
183: --security_group_id = DECODE( p_security_group_id, FND_API.g_miss_num, security_group_id, p_security_group_id)
184: WHERE ATTR_CODE_ID = p_ATTR_CODE_ID
185: --AND object_version_number = p_object_version_number

Line 182: description = DECODE( p_description, FND_API.g_miss_char, description, p_description)

178: --creation_date = DECODE( p_creation_date, FND_API.g_miss_date, creation_date, p_creation_date),
179: --created_by = DECODE( p_created_by, FND_API.g_miss_num, created_by, p_created_by),
180: last_update_login = DECODE( p_last_update_login, FND_API.g_miss_num, last_update_login, p_last_update_login),
181: object_version_number = DECODE( p_object_version_number, FND_API.g_miss_num, object_version_number, p_object_version_number+1),
182: description = DECODE( p_description, FND_API.g_miss_char, description, p_description)
183: --security_group_id = DECODE( p_security_group_id, FND_API.g_miss_num, security_group_id, p_security_group_id)
184: WHERE ATTR_CODE_ID = p_ATTR_CODE_ID
185: --AND object_version_number = p_object_version_number
186: AND userenv('LANG') in (LANGUAGE, SOURCE_LANG);

Line 183: --security_group_id = DECODE( p_security_group_id, FND_API.g_miss_num, security_group_id, p_security_group_id)

179: --created_by = DECODE( p_created_by, FND_API.g_miss_num, created_by, p_created_by),
180: last_update_login = DECODE( p_last_update_login, FND_API.g_miss_num, last_update_login, p_last_update_login),
181: object_version_number = DECODE( p_object_version_number, FND_API.g_miss_num, object_version_number, p_object_version_number+1),
182: description = DECODE( p_description, FND_API.g_miss_char, description, p_description)
183: --security_group_id = DECODE( p_security_group_id, FND_API.g_miss_num, security_group_id, p_security_group_id)
184: WHERE ATTR_CODE_ID = p_ATTR_CODE_ID
185: --AND object_version_number = p_object_version_number
186: AND userenv('LANG') in (LANGUAGE, SOURCE_LANG);
187:

Line 190: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

186: AND userenv('LANG') in (LANGUAGE, SOURCE_LANG);
187:
188:
189: IF (SQL%NOTFOUND) THEN
190: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
191: END IF;
192:
193: END Update_Row;
194:

Line 217: p_creation_date DATE := FND_API.g_miss_date ,

213: p_attr_code_id NUMBER,
214: p_attr_code VARCHAR2,
215: p_last_update_date DATE,
216: p_last_updated_by NUMBER,
217: p_creation_date DATE := FND_API.g_miss_date ,
218: p_created_by NUMBER := FND_API.g_miss_num ,
219: p_last_update_login NUMBER,
220: p_object_version_number NUMBER,
221: p_attribute_id NUMBER,

Line 218: p_created_by NUMBER := FND_API.g_miss_num ,

214: p_attr_code VARCHAR2,
215: p_last_update_date DATE,
216: p_last_updated_by NUMBER,
217: p_creation_date DATE := FND_API.g_miss_date ,
218: p_created_by NUMBER := FND_API.g_miss_num ,
219: p_last_update_login NUMBER,
220: p_object_version_number NUMBER,
221: p_attribute_id NUMBER,
222: p_enabled_flag VARCHAR2,

Line 250: attr_code_id = DECODE( p_attr_code_id, FND_API.g_miss_num, attr_code_id, p_attr_code_id),

246: if( l_last_updated_by = 1) then
247:
248: Update PV_ATTRIBUTE_CODES_B
249: SET
250: attr_code_id = DECODE( p_attr_code_id, FND_API.g_miss_num, attr_code_id, p_attr_code_id),
251: attr_code = DECODE( p_attr_code, FND_API.g_miss_char, attr_code, p_attr_code),
252: last_update_date = DECODE( p_last_update_date, FND_API.g_miss_date, last_update_date, p_last_update_date),
253: last_updated_by = DECODE( p_last_updated_by, FND_API.g_miss_num, last_updated_by, p_last_updated_by),
254: --creation_date = DECODE( p_creation_date, FND_API.g_miss_date, creation_date, p_creation_date),

Line 251: attr_code = DECODE( p_attr_code, FND_API.g_miss_char, attr_code, p_attr_code),

247:
248: Update PV_ATTRIBUTE_CODES_B
249: SET
250: attr_code_id = DECODE( p_attr_code_id, FND_API.g_miss_num, attr_code_id, p_attr_code_id),
251: attr_code = DECODE( p_attr_code, FND_API.g_miss_char, attr_code, p_attr_code),
252: last_update_date = DECODE( p_last_update_date, FND_API.g_miss_date, last_update_date, p_last_update_date),
253: last_updated_by = DECODE( p_last_updated_by, FND_API.g_miss_num, last_updated_by, p_last_updated_by),
254: --creation_date = DECODE( p_creation_date, FND_API.g_miss_date, creation_date, p_creation_date),
255: --created_by = DECODE( p_created_by, FND_API.g_miss_num, created_by, p_created_by),

Line 252: last_update_date = DECODE( p_last_update_date, FND_API.g_miss_date, last_update_date, p_last_update_date),

248: Update PV_ATTRIBUTE_CODES_B
249: SET
250: attr_code_id = DECODE( p_attr_code_id, FND_API.g_miss_num, attr_code_id, p_attr_code_id),
251: attr_code = DECODE( p_attr_code, FND_API.g_miss_char, attr_code, p_attr_code),
252: last_update_date = DECODE( p_last_update_date, FND_API.g_miss_date, last_update_date, p_last_update_date),
253: last_updated_by = DECODE( p_last_updated_by, FND_API.g_miss_num, last_updated_by, p_last_updated_by),
254: --creation_date = DECODE( p_creation_date, FND_API.g_miss_date, creation_date, p_creation_date),
255: --created_by = DECODE( p_created_by, FND_API.g_miss_num, created_by, p_created_by),
256: last_update_login = DECODE( p_last_update_login, FND_API.g_miss_num, last_update_login, p_last_update_login),

Line 253: last_updated_by = DECODE( p_last_updated_by, FND_API.g_miss_num, last_updated_by, p_last_updated_by),

249: SET
250: attr_code_id = DECODE( p_attr_code_id, FND_API.g_miss_num, attr_code_id, p_attr_code_id),
251: attr_code = DECODE( p_attr_code, FND_API.g_miss_char, attr_code, p_attr_code),
252: last_update_date = DECODE( p_last_update_date, FND_API.g_miss_date, last_update_date, p_last_update_date),
253: last_updated_by = DECODE( p_last_updated_by, FND_API.g_miss_num, last_updated_by, p_last_updated_by),
254: --creation_date = DECODE( p_creation_date, FND_API.g_miss_date, creation_date, p_creation_date),
255: --created_by = DECODE( p_created_by, FND_API.g_miss_num, created_by, p_created_by),
256: last_update_login = DECODE( p_last_update_login, FND_API.g_miss_num, last_update_login, p_last_update_login),
257: object_version_number = DECODE( p_object_version_number, FND_API.g_miss_num, object_version_number, p_object_version_number+1),

Line 254: --creation_date = DECODE( p_creation_date, FND_API.g_miss_date, creation_date, p_creation_date),

250: attr_code_id = DECODE( p_attr_code_id, FND_API.g_miss_num, attr_code_id, p_attr_code_id),
251: attr_code = DECODE( p_attr_code, FND_API.g_miss_char, attr_code, p_attr_code),
252: last_update_date = DECODE( p_last_update_date, FND_API.g_miss_date, last_update_date, p_last_update_date),
253: last_updated_by = DECODE( p_last_updated_by, FND_API.g_miss_num, last_updated_by, p_last_updated_by),
254: --creation_date = DECODE( p_creation_date, FND_API.g_miss_date, creation_date, p_creation_date),
255: --created_by = DECODE( p_created_by, FND_API.g_miss_num, created_by, p_created_by),
256: last_update_login = DECODE( p_last_update_login, FND_API.g_miss_num, last_update_login, p_last_update_login),
257: object_version_number = DECODE( p_object_version_number, FND_API.g_miss_num, object_version_number, p_object_version_number+1),
258: attribute_id = DECODE( p_attribute_id, FND_API.g_miss_num, attribute_id, p_attribute_id),

Line 255: --created_by = DECODE( p_created_by, FND_API.g_miss_num, created_by, p_created_by),

251: attr_code = DECODE( p_attr_code, FND_API.g_miss_char, attr_code, p_attr_code),
252: last_update_date = DECODE( p_last_update_date, FND_API.g_miss_date, last_update_date, p_last_update_date),
253: last_updated_by = DECODE( p_last_updated_by, FND_API.g_miss_num, last_updated_by, p_last_updated_by),
254: --creation_date = DECODE( p_creation_date, FND_API.g_miss_date, creation_date, p_creation_date),
255: --created_by = DECODE( p_created_by, FND_API.g_miss_num, created_by, p_created_by),
256: last_update_login = DECODE( p_last_update_login, FND_API.g_miss_num, last_update_login, p_last_update_login),
257: object_version_number = DECODE( p_object_version_number, FND_API.g_miss_num, object_version_number, p_object_version_number+1),
258: attribute_id = DECODE( p_attribute_id, FND_API.g_miss_num, attribute_id, p_attribute_id),
259: enabled_flag = DECODE( p_enabled_flag, FND_API.g_miss_char, enabled_flag, p_enabled_flag)

Line 256: last_update_login = DECODE( p_last_update_login, FND_API.g_miss_num, last_update_login, p_last_update_login),

252: last_update_date = DECODE( p_last_update_date, FND_API.g_miss_date, last_update_date, p_last_update_date),
253: last_updated_by = DECODE( p_last_updated_by, FND_API.g_miss_num, last_updated_by, p_last_updated_by),
254: --creation_date = DECODE( p_creation_date, FND_API.g_miss_date, creation_date, p_creation_date),
255: --created_by = DECODE( p_created_by, FND_API.g_miss_num, created_by, p_created_by),
256: last_update_login = DECODE( p_last_update_login, FND_API.g_miss_num, last_update_login, p_last_update_login),
257: object_version_number = DECODE( p_object_version_number, FND_API.g_miss_num, object_version_number, p_object_version_number+1),
258: attribute_id = DECODE( p_attribute_id, FND_API.g_miss_num, attribute_id, p_attribute_id),
259: enabled_flag = DECODE( p_enabled_flag, FND_API.g_miss_char, enabled_flag, p_enabled_flag)
260:

Line 257: object_version_number = DECODE( p_object_version_number, FND_API.g_miss_num, object_version_number, p_object_version_number+1),

253: last_updated_by = DECODE( p_last_updated_by, FND_API.g_miss_num, last_updated_by, p_last_updated_by),
254: --creation_date = DECODE( p_creation_date, FND_API.g_miss_date, creation_date, p_creation_date),
255: --created_by = DECODE( p_created_by, FND_API.g_miss_num, created_by, p_created_by),
256: last_update_login = DECODE( p_last_update_login, FND_API.g_miss_num, last_update_login, p_last_update_login),
257: object_version_number = DECODE( p_object_version_number, FND_API.g_miss_num, object_version_number, p_object_version_number+1),
258: attribute_id = DECODE( p_attribute_id, FND_API.g_miss_num, attribute_id, p_attribute_id),
259: enabled_flag = DECODE( p_enabled_flag, FND_API.g_miss_char, enabled_flag, p_enabled_flag)
260:
261: WHERE ATTR_CODE_ID = p_ATTR_CODE_ID

Line 258: attribute_id = DECODE( p_attribute_id, FND_API.g_miss_num, attribute_id, p_attribute_id),

254: --creation_date = DECODE( p_creation_date, FND_API.g_miss_date, creation_date, p_creation_date),
255: --created_by = DECODE( p_created_by, FND_API.g_miss_num, created_by, p_created_by),
256: last_update_login = DECODE( p_last_update_login, FND_API.g_miss_num, last_update_login, p_last_update_login),
257: object_version_number = DECODE( p_object_version_number, FND_API.g_miss_num, object_version_number, p_object_version_number+1),
258: attribute_id = DECODE( p_attribute_id, FND_API.g_miss_num, attribute_id, p_attribute_id),
259: enabled_flag = DECODE( p_enabled_flag, FND_API.g_miss_char, enabled_flag, p_enabled_flag)
260:
261: WHERE ATTR_CODE_ID = p_ATTR_CODE_ID
262: AND object_version_number = p_object_version_number;

Line 259: enabled_flag = DECODE( p_enabled_flag, FND_API.g_miss_char, enabled_flag, p_enabled_flag)

255: --created_by = DECODE( p_created_by, FND_API.g_miss_num, created_by, p_created_by),
256: last_update_login = DECODE( p_last_update_login, FND_API.g_miss_num, last_update_login, p_last_update_login),
257: object_version_number = DECODE( p_object_version_number, FND_API.g_miss_num, object_version_number, p_object_version_number+1),
258: attribute_id = DECODE( p_attribute_id, FND_API.g_miss_num, attribute_id, p_attribute_id),
259: enabled_flag = DECODE( p_enabled_flag, FND_API.g_miss_char, enabled_flag, p_enabled_flag)
260:
261: WHERE ATTR_CODE_ID = p_ATTR_CODE_ID
262: AND object_version_number = p_object_version_number;
263:

Line 265: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

261: WHERE ATTR_CODE_ID = p_ATTR_CODE_ID
262: AND object_version_number = p_object_version_number;
263:
264: IF (SQL%NOTFOUND) THEN
265: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
266: END IF;
267:
268: Update PV_ATTRIBUTE_CODES_TL
269: SET

Line 270: attr_code_id = DECODE( p_attr_code_id, FND_API.g_miss_num, attr_code_id, p_attr_code_id),

266: END IF;
267:
268: Update PV_ATTRIBUTE_CODES_TL
269: SET
270: attr_code_id = DECODE( p_attr_code_id, FND_API.g_miss_num, attr_code_id, p_attr_code_id),
271: source_lang = userenv('LANG'),
272: last_update_date = DECODE( p_last_update_date, FND_API.g_miss_date, last_update_date, p_last_update_date),
273: last_updated_by = DECODE( p_last_updated_by, FND_API.g_miss_num, last_updated_by, p_last_updated_by),
274: --creation_date = DECODE( p_creation_date, FND_API.g_miss_date, creation_date, p_creation_date),

Line 272: last_update_date = DECODE( p_last_update_date, FND_API.g_miss_date, last_update_date, p_last_update_date),

268: Update PV_ATTRIBUTE_CODES_TL
269: SET
270: attr_code_id = DECODE( p_attr_code_id, FND_API.g_miss_num, attr_code_id, p_attr_code_id),
271: source_lang = userenv('LANG'),
272: last_update_date = DECODE( p_last_update_date, FND_API.g_miss_date, last_update_date, p_last_update_date),
273: last_updated_by = DECODE( p_last_updated_by, FND_API.g_miss_num, last_updated_by, p_last_updated_by),
274: --creation_date = DECODE( p_creation_date, FND_API.g_miss_date, creation_date, p_creation_date),
275: --created_by = DECODE( p_created_by, FND_API.g_miss_num, created_by, p_created_by),
276: last_update_login = DECODE( p_last_update_login, FND_API.g_miss_num, last_update_login, p_last_update_login),

Line 273: last_updated_by = DECODE( p_last_updated_by, FND_API.g_miss_num, last_updated_by, p_last_updated_by),

269: SET
270: attr_code_id = DECODE( p_attr_code_id, FND_API.g_miss_num, attr_code_id, p_attr_code_id),
271: source_lang = userenv('LANG'),
272: last_update_date = DECODE( p_last_update_date, FND_API.g_miss_date, last_update_date, p_last_update_date),
273: last_updated_by = DECODE( p_last_updated_by, FND_API.g_miss_num, last_updated_by, p_last_updated_by),
274: --creation_date = DECODE( p_creation_date, FND_API.g_miss_date, creation_date, p_creation_date),
275: --created_by = DECODE( p_created_by, FND_API.g_miss_num, created_by, p_created_by),
276: last_update_login = DECODE( p_last_update_login, FND_API.g_miss_num, last_update_login, p_last_update_login),
277: object_version_number = DECODE( p_object_version_number, FND_API.g_miss_num, object_version_number, p_object_version_number+1),

Line 274: --creation_date = DECODE( p_creation_date, FND_API.g_miss_date, creation_date, p_creation_date),

270: attr_code_id = DECODE( p_attr_code_id, FND_API.g_miss_num, attr_code_id, p_attr_code_id),
271: source_lang = userenv('LANG'),
272: last_update_date = DECODE( p_last_update_date, FND_API.g_miss_date, last_update_date, p_last_update_date),
273: last_updated_by = DECODE( p_last_updated_by, FND_API.g_miss_num, last_updated_by, p_last_updated_by),
274: --creation_date = DECODE( p_creation_date, FND_API.g_miss_date, creation_date, p_creation_date),
275: --created_by = DECODE( p_created_by, FND_API.g_miss_num, created_by, p_created_by),
276: last_update_login = DECODE( p_last_update_login, FND_API.g_miss_num, last_update_login, p_last_update_login),
277: object_version_number = DECODE( p_object_version_number, FND_API.g_miss_num, object_version_number, p_object_version_number+1),
278: description = DECODE( p_description, FND_API.g_miss_char, description, p_description)

Line 275: --created_by = DECODE( p_created_by, FND_API.g_miss_num, created_by, p_created_by),

271: source_lang = userenv('LANG'),
272: last_update_date = DECODE( p_last_update_date, FND_API.g_miss_date, last_update_date, p_last_update_date),
273: last_updated_by = DECODE( p_last_updated_by, FND_API.g_miss_num, last_updated_by, p_last_updated_by),
274: --creation_date = DECODE( p_creation_date, FND_API.g_miss_date, creation_date, p_creation_date),
275: --created_by = DECODE( p_created_by, FND_API.g_miss_num, created_by, p_created_by),
276: last_update_login = DECODE( p_last_update_login, FND_API.g_miss_num, last_update_login, p_last_update_login),
277: object_version_number = DECODE( p_object_version_number, FND_API.g_miss_num, object_version_number, p_object_version_number+1),
278: description = DECODE( p_description, FND_API.g_miss_char, description, p_description)
279:

Line 276: last_update_login = DECODE( p_last_update_login, FND_API.g_miss_num, last_update_login, p_last_update_login),

272: last_update_date = DECODE( p_last_update_date, FND_API.g_miss_date, last_update_date, p_last_update_date),
273: last_updated_by = DECODE( p_last_updated_by, FND_API.g_miss_num, last_updated_by, p_last_updated_by),
274: --creation_date = DECODE( p_creation_date, FND_API.g_miss_date, creation_date, p_creation_date),
275: --created_by = DECODE( p_created_by, FND_API.g_miss_num, created_by, p_created_by),
276: last_update_login = DECODE( p_last_update_login, FND_API.g_miss_num, last_update_login, p_last_update_login),
277: object_version_number = DECODE( p_object_version_number, FND_API.g_miss_num, object_version_number, p_object_version_number+1),
278: description = DECODE( p_description, FND_API.g_miss_char, description, p_description)
279:
280: WHERE ATTR_CODE_ID = p_ATTR_CODE_ID

Line 277: object_version_number = DECODE( p_object_version_number, FND_API.g_miss_num, object_version_number, p_object_version_number+1),

273: last_updated_by = DECODE( p_last_updated_by, FND_API.g_miss_num, last_updated_by, p_last_updated_by),
274: --creation_date = DECODE( p_creation_date, FND_API.g_miss_date, creation_date, p_creation_date),
275: --created_by = DECODE( p_created_by, FND_API.g_miss_num, created_by, p_created_by),
276: last_update_login = DECODE( p_last_update_login, FND_API.g_miss_num, last_update_login, p_last_update_login),
277: object_version_number = DECODE( p_object_version_number, FND_API.g_miss_num, object_version_number, p_object_version_number+1),
278: description = DECODE( p_description, FND_API.g_miss_char, description, p_description)
279:
280: WHERE ATTR_CODE_ID = p_ATTR_CODE_ID
281: --AND object_version_number = p_object_version_number

Line 278: description = DECODE( p_description, FND_API.g_miss_char, description, p_description)

274: --creation_date = DECODE( p_creation_date, FND_API.g_miss_date, creation_date, p_creation_date),
275: --created_by = DECODE( p_created_by, FND_API.g_miss_num, created_by, p_created_by),
276: last_update_login = DECODE( p_last_update_login, FND_API.g_miss_num, last_update_login, p_last_update_login),
277: object_version_number = DECODE( p_object_version_number, FND_API.g_miss_num, object_version_number, p_object_version_number+1),
278: description = DECODE( p_description, FND_API.g_miss_char, description, p_description)
279:
280: WHERE ATTR_CODE_ID = p_ATTR_CODE_ID
281: --AND object_version_number = p_object_version_number
282: AND userenv('LANG') in (LANGUAGE, SOURCE_LANG);

Line 286: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

282: AND userenv('LANG') in (LANGUAGE, SOURCE_LANG);
283:
284:
285: IF (SQL%NOTFOUND) THEN
286: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
287: END IF;
288:
289: ELSE
290:

Line 294: attr_code_id = DECODE( p_attr_code_id, FND_API.g_miss_num, attr_code_id, p_attr_code_id),

290:
291:
292: Update PV_ATTRIBUTE_CODES_B
293: SET
294: attr_code_id = DECODE( p_attr_code_id, FND_API.g_miss_num, attr_code_id, p_attr_code_id),
295: attr_code = DECODE( p_attr_code, FND_API.g_miss_char, attr_code, p_attr_code),
296: last_update_date = DECODE( p_last_update_date, FND_API.g_miss_date, last_update_date, p_last_update_date),
297: last_updated_by = DECODE( p_last_updated_by, FND_API.g_miss_num, last_updated_by, p_last_updated_by),
298: --creation_date = DECODE( p_creation_date, FND_API.g_miss_date, creation_date, p_creation_date),

Line 295: attr_code = DECODE( p_attr_code, FND_API.g_miss_char, attr_code, p_attr_code),

291:
292: Update PV_ATTRIBUTE_CODES_B
293: SET
294: attr_code_id = DECODE( p_attr_code_id, FND_API.g_miss_num, attr_code_id, p_attr_code_id),
295: attr_code = DECODE( p_attr_code, FND_API.g_miss_char, attr_code, p_attr_code),
296: last_update_date = DECODE( p_last_update_date, FND_API.g_miss_date, last_update_date, p_last_update_date),
297: last_updated_by = DECODE( p_last_updated_by, FND_API.g_miss_num, last_updated_by, p_last_updated_by),
298: --creation_date = DECODE( p_creation_date, FND_API.g_miss_date, creation_date, p_creation_date),
299: --created_by = DECODE( p_created_by, FND_API.g_miss_num, created_by, p_created_by),

Line 296: last_update_date = DECODE( p_last_update_date, FND_API.g_miss_date, last_update_date, p_last_update_date),

292: Update PV_ATTRIBUTE_CODES_B
293: SET
294: attr_code_id = DECODE( p_attr_code_id, FND_API.g_miss_num, attr_code_id, p_attr_code_id),
295: attr_code = DECODE( p_attr_code, FND_API.g_miss_char, attr_code, p_attr_code),
296: last_update_date = DECODE( p_last_update_date, FND_API.g_miss_date, last_update_date, p_last_update_date),
297: last_updated_by = DECODE( p_last_updated_by, FND_API.g_miss_num, last_updated_by, p_last_updated_by),
298: --creation_date = DECODE( p_creation_date, FND_API.g_miss_date, creation_date, p_creation_date),
299: --created_by = DECODE( p_created_by, FND_API.g_miss_num, created_by, p_created_by),
300: last_update_login = DECODE( p_last_update_login, FND_API.g_miss_num, last_update_login, p_last_update_login),

Line 297: last_updated_by = DECODE( p_last_updated_by, FND_API.g_miss_num, last_updated_by, p_last_updated_by),

293: SET
294: attr_code_id = DECODE( p_attr_code_id, FND_API.g_miss_num, attr_code_id, p_attr_code_id),
295: attr_code = DECODE( p_attr_code, FND_API.g_miss_char, attr_code, p_attr_code),
296: last_update_date = DECODE( p_last_update_date, FND_API.g_miss_date, last_update_date, p_last_update_date),
297: last_updated_by = DECODE( p_last_updated_by, FND_API.g_miss_num, last_updated_by, p_last_updated_by),
298: --creation_date = DECODE( p_creation_date, FND_API.g_miss_date, creation_date, p_creation_date),
299: --created_by = DECODE( p_created_by, FND_API.g_miss_num, created_by, p_created_by),
300: last_update_login = DECODE( p_last_update_login, FND_API.g_miss_num, last_update_login, p_last_update_login),
301: object_version_number = DECODE( p_object_version_number, FND_API.g_miss_num, object_version_number, p_object_version_number+1),

Line 298: --creation_date = DECODE( p_creation_date, FND_API.g_miss_date, creation_date, p_creation_date),

294: attr_code_id = DECODE( p_attr_code_id, FND_API.g_miss_num, attr_code_id, p_attr_code_id),
295: attr_code = DECODE( p_attr_code, FND_API.g_miss_char, attr_code, p_attr_code),
296: last_update_date = DECODE( p_last_update_date, FND_API.g_miss_date, last_update_date, p_last_update_date),
297: last_updated_by = DECODE( p_last_updated_by, FND_API.g_miss_num, last_updated_by, p_last_updated_by),
298: --creation_date = DECODE( p_creation_date, FND_API.g_miss_date, creation_date, p_creation_date),
299: --created_by = DECODE( p_created_by, FND_API.g_miss_num, created_by, p_created_by),
300: last_update_login = DECODE( p_last_update_login, FND_API.g_miss_num, last_update_login, p_last_update_login),
301: object_version_number = DECODE( p_object_version_number, FND_API.g_miss_num, object_version_number, p_object_version_number+1),
302: attribute_id = DECODE( p_attribute_id, FND_API.g_miss_num, attribute_id, p_attribute_id)

Line 299: --created_by = DECODE( p_created_by, FND_API.g_miss_num, created_by, p_created_by),

295: attr_code = DECODE( p_attr_code, FND_API.g_miss_char, attr_code, p_attr_code),
296: last_update_date = DECODE( p_last_update_date, FND_API.g_miss_date, last_update_date, p_last_update_date),
297: last_updated_by = DECODE( p_last_updated_by, FND_API.g_miss_num, last_updated_by, p_last_updated_by),
298: --creation_date = DECODE( p_creation_date, FND_API.g_miss_date, creation_date, p_creation_date),
299: --created_by = DECODE( p_created_by, FND_API.g_miss_num, created_by, p_created_by),
300: last_update_login = DECODE( p_last_update_login, FND_API.g_miss_num, last_update_login, p_last_update_login),
301: object_version_number = DECODE( p_object_version_number, FND_API.g_miss_num, object_version_number, p_object_version_number+1),
302: attribute_id = DECODE( p_attribute_id, FND_API.g_miss_num, attribute_id, p_attribute_id)
303: --enabled_flag = DECODE( p_enabled_flag, FND_API.g_miss_char, enabled_flag, p_enabled_flag)

Line 300: last_update_login = DECODE( p_last_update_login, FND_API.g_miss_num, last_update_login, p_last_update_login),

296: last_update_date = DECODE( p_last_update_date, FND_API.g_miss_date, last_update_date, p_last_update_date),
297: last_updated_by = DECODE( p_last_updated_by, FND_API.g_miss_num, last_updated_by, p_last_updated_by),
298: --creation_date = DECODE( p_creation_date, FND_API.g_miss_date, creation_date, p_creation_date),
299: --created_by = DECODE( p_created_by, FND_API.g_miss_num, created_by, p_created_by),
300: last_update_login = DECODE( p_last_update_login, FND_API.g_miss_num, last_update_login, p_last_update_login),
301: object_version_number = DECODE( p_object_version_number, FND_API.g_miss_num, object_version_number, p_object_version_number+1),
302: attribute_id = DECODE( p_attribute_id, FND_API.g_miss_num, attribute_id, p_attribute_id)
303: --enabled_flag = DECODE( p_enabled_flag, FND_API.g_miss_char, enabled_flag, p_enabled_flag)
304:

Line 301: object_version_number = DECODE( p_object_version_number, FND_API.g_miss_num, object_version_number, p_object_version_number+1),

297: last_updated_by = DECODE( p_last_updated_by, FND_API.g_miss_num, last_updated_by, p_last_updated_by),
298: --creation_date = DECODE( p_creation_date, FND_API.g_miss_date, creation_date, p_creation_date),
299: --created_by = DECODE( p_created_by, FND_API.g_miss_num, created_by, p_created_by),
300: last_update_login = DECODE( p_last_update_login, FND_API.g_miss_num, last_update_login, p_last_update_login),
301: object_version_number = DECODE( p_object_version_number, FND_API.g_miss_num, object_version_number, p_object_version_number+1),
302: attribute_id = DECODE( p_attribute_id, FND_API.g_miss_num, attribute_id, p_attribute_id)
303: --enabled_flag = DECODE( p_enabled_flag, FND_API.g_miss_char, enabled_flag, p_enabled_flag)
304:
305: WHERE ATTR_CODE_ID = p_ATTR_CODE_ID

Line 302: attribute_id = DECODE( p_attribute_id, FND_API.g_miss_num, attribute_id, p_attribute_id)

298: --creation_date = DECODE( p_creation_date, FND_API.g_miss_date, creation_date, p_creation_date),
299: --created_by = DECODE( p_created_by, FND_API.g_miss_num, created_by, p_created_by),
300: last_update_login = DECODE( p_last_update_login, FND_API.g_miss_num, last_update_login, p_last_update_login),
301: object_version_number = DECODE( p_object_version_number, FND_API.g_miss_num, object_version_number, p_object_version_number+1),
302: attribute_id = DECODE( p_attribute_id, FND_API.g_miss_num, attribute_id, p_attribute_id)
303: --enabled_flag = DECODE( p_enabled_flag, FND_API.g_miss_char, enabled_flag, p_enabled_flag)
304:
305: WHERE ATTR_CODE_ID = p_ATTR_CODE_ID
306: AND object_version_number = p_object_version_number;

Line 303: --enabled_flag = DECODE( p_enabled_flag, FND_API.g_miss_char, enabled_flag, p_enabled_flag)

299: --created_by = DECODE( p_created_by, FND_API.g_miss_num, created_by, p_created_by),
300: last_update_login = DECODE( p_last_update_login, FND_API.g_miss_num, last_update_login, p_last_update_login),
301: object_version_number = DECODE( p_object_version_number, FND_API.g_miss_num, object_version_number, p_object_version_number+1),
302: attribute_id = DECODE( p_attribute_id, FND_API.g_miss_num, attribute_id, p_attribute_id)
303: --enabled_flag = DECODE( p_enabled_flag, FND_API.g_miss_char, enabled_flag, p_enabled_flag)
304:
305: WHERE ATTR_CODE_ID = p_ATTR_CODE_ID
306: AND object_version_number = p_object_version_number;
307:

Line 309: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

305: WHERE ATTR_CODE_ID = p_ATTR_CODE_ID
306: AND object_version_number = p_object_version_number;
307:
308: IF (SQL%NOTFOUND) THEN
309: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
310: END IF;
311:
312: Update PV_ATTRIBUTE_CODES_TL
313: SET

Line 314: attr_code_id = DECODE( p_attr_code_id, FND_API.g_miss_num, attr_code_id, p_attr_code_id),

310: END IF;
311:
312: Update PV_ATTRIBUTE_CODES_TL
313: SET
314: attr_code_id = DECODE( p_attr_code_id, FND_API.g_miss_num, attr_code_id, p_attr_code_id),
315: source_lang = userenv('LANG'),
316: last_update_date = DECODE( p_last_update_date, FND_API.g_miss_date, last_update_date, p_last_update_date),
317: last_updated_by = DECODE( p_last_updated_by, FND_API.g_miss_num, last_updated_by, p_last_updated_by),
318: --creation_date = DECODE( p_creation_date, FND_API.g_miss_date, creation_date, p_creation_date),

Line 316: last_update_date = DECODE( p_last_update_date, FND_API.g_miss_date, last_update_date, p_last_update_date),

312: Update PV_ATTRIBUTE_CODES_TL
313: SET
314: attr_code_id = DECODE( p_attr_code_id, FND_API.g_miss_num, attr_code_id, p_attr_code_id),
315: source_lang = userenv('LANG'),
316: last_update_date = DECODE( p_last_update_date, FND_API.g_miss_date, last_update_date, p_last_update_date),
317: last_updated_by = DECODE( p_last_updated_by, FND_API.g_miss_num, last_updated_by, p_last_updated_by),
318: --creation_date = DECODE( p_creation_date, FND_API.g_miss_date, creation_date, p_creation_date),
319: --created_by = DECODE( p_created_by, FND_API.g_miss_num, created_by, p_created_by),
320: last_update_login = DECODE( p_last_update_login, FND_API.g_miss_num, last_update_login, p_last_update_login),

Line 317: last_updated_by = DECODE( p_last_updated_by, FND_API.g_miss_num, last_updated_by, p_last_updated_by),

313: SET
314: attr_code_id = DECODE( p_attr_code_id, FND_API.g_miss_num, attr_code_id, p_attr_code_id),
315: source_lang = userenv('LANG'),
316: last_update_date = DECODE( p_last_update_date, FND_API.g_miss_date, last_update_date, p_last_update_date),
317: last_updated_by = DECODE( p_last_updated_by, FND_API.g_miss_num, last_updated_by, p_last_updated_by),
318: --creation_date = DECODE( p_creation_date, FND_API.g_miss_date, creation_date, p_creation_date),
319: --created_by = DECODE( p_created_by, FND_API.g_miss_num, created_by, p_created_by),
320: last_update_login = DECODE( p_last_update_login, FND_API.g_miss_num, last_update_login, p_last_update_login),
321: object_version_number = DECODE( p_object_version_number, FND_API.g_miss_num, object_version_number, p_object_version_number+1)

Line 318: --creation_date = DECODE( p_creation_date, FND_API.g_miss_date, creation_date, p_creation_date),

314: attr_code_id = DECODE( p_attr_code_id, FND_API.g_miss_num, attr_code_id, p_attr_code_id),
315: source_lang = userenv('LANG'),
316: last_update_date = DECODE( p_last_update_date, FND_API.g_miss_date, last_update_date, p_last_update_date),
317: last_updated_by = DECODE( p_last_updated_by, FND_API.g_miss_num, last_updated_by, p_last_updated_by),
318: --creation_date = DECODE( p_creation_date, FND_API.g_miss_date, creation_date, p_creation_date),
319: --created_by = DECODE( p_created_by, FND_API.g_miss_num, created_by, p_created_by),
320: last_update_login = DECODE( p_last_update_login, FND_API.g_miss_num, last_update_login, p_last_update_login),
321: object_version_number = DECODE( p_object_version_number, FND_API.g_miss_num, object_version_number, p_object_version_number+1)
322: --description = DECODE( p_description, FND_API.g_miss_char, description, p_description)

Line 319: --created_by = DECODE( p_created_by, FND_API.g_miss_num, created_by, p_created_by),

315: source_lang = userenv('LANG'),
316: last_update_date = DECODE( p_last_update_date, FND_API.g_miss_date, last_update_date, p_last_update_date),
317: last_updated_by = DECODE( p_last_updated_by, FND_API.g_miss_num, last_updated_by, p_last_updated_by),
318: --creation_date = DECODE( p_creation_date, FND_API.g_miss_date, creation_date, p_creation_date),
319: --created_by = DECODE( p_created_by, FND_API.g_miss_num, created_by, p_created_by),
320: last_update_login = DECODE( p_last_update_login, FND_API.g_miss_num, last_update_login, p_last_update_login),
321: object_version_number = DECODE( p_object_version_number, FND_API.g_miss_num, object_version_number, p_object_version_number+1)
322: --description = DECODE( p_description, FND_API.g_miss_char, description, p_description)
323: --security_group_id = DECODE( p_security_group_id, FND_API.g_miss_num, security_group_id, p_security_group_id)

Line 320: last_update_login = DECODE( p_last_update_login, FND_API.g_miss_num, last_update_login, p_last_update_login),

316: last_update_date = DECODE( p_last_update_date, FND_API.g_miss_date, last_update_date, p_last_update_date),
317: last_updated_by = DECODE( p_last_updated_by, FND_API.g_miss_num, last_updated_by, p_last_updated_by),
318: --creation_date = DECODE( p_creation_date, FND_API.g_miss_date, creation_date, p_creation_date),
319: --created_by = DECODE( p_created_by, FND_API.g_miss_num, created_by, p_created_by),
320: last_update_login = DECODE( p_last_update_login, FND_API.g_miss_num, last_update_login, p_last_update_login),
321: object_version_number = DECODE( p_object_version_number, FND_API.g_miss_num, object_version_number, p_object_version_number+1)
322: --description = DECODE( p_description, FND_API.g_miss_char, description, p_description)
323: --security_group_id = DECODE( p_security_group_id, FND_API.g_miss_num, security_group_id, p_security_group_id)
324: WHERE ATTR_CODE_ID = p_ATTR_CODE_ID

Line 321: object_version_number = DECODE( p_object_version_number, FND_API.g_miss_num, object_version_number, p_object_version_number+1)

317: last_updated_by = DECODE( p_last_updated_by, FND_API.g_miss_num, last_updated_by, p_last_updated_by),
318: --creation_date = DECODE( p_creation_date, FND_API.g_miss_date, creation_date, p_creation_date),
319: --created_by = DECODE( p_created_by, FND_API.g_miss_num, created_by, p_created_by),
320: last_update_login = DECODE( p_last_update_login, FND_API.g_miss_num, last_update_login, p_last_update_login),
321: object_version_number = DECODE( p_object_version_number, FND_API.g_miss_num, object_version_number, p_object_version_number+1)
322: --description = DECODE( p_description, FND_API.g_miss_char, description, p_description)
323: --security_group_id = DECODE( p_security_group_id, FND_API.g_miss_num, security_group_id, p_security_group_id)
324: WHERE ATTR_CODE_ID = p_ATTR_CODE_ID
325: --AND object_version_number = p_object_version_number

Line 322: --description = DECODE( p_description, FND_API.g_miss_char, description, p_description)

318: --creation_date = DECODE( p_creation_date, FND_API.g_miss_date, creation_date, p_creation_date),
319: --created_by = DECODE( p_created_by, FND_API.g_miss_num, created_by, p_created_by),
320: last_update_login = DECODE( p_last_update_login, FND_API.g_miss_num, last_update_login, p_last_update_login),
321: object_version_number = DECODE( p_object_version_number, FND_API.g_miss_num, object_version_number, p_object_version_number+1)
322: --description = DECODE( p_description, FND_API.g_miss_char, description, p_description)
323: --security_group_id = DECODE( p_security_group_id, FND_API.g_miss_num, security_group_id, p_security_group_id)
324: WHERE ATTR_CODE_ID = p_ATTR_CODE_ID
325: --AND object_version_number = p_object_version_number
326: AND userenv('LANG') in (LANGUAGE, SOURCE_LANG);

Line 323: --security_group_id = DECODE( p_security_group_id, FND_API.g_miss_num, security_group_id, p_security_group_id)

319: --created_by = DECODE( p_created_by, FND_API.g_miss_num, created_by, p_created_by),
320: last_update_login = DECODE( p_last_update_login, FND_API.g_miss_num, last_update_login, p_last_update_login),
321: object_version_number = DECODE( p_object_version_number, FND_API.g_miss_num, object_version_number, p_object_version_number+1)
322: --description = DECODE( p_description, FND_API.g_miss_char, description, p_description)
323: --security_group_id = DECODE( p_security_group_id, FND_API.g_miss_num, security_group_id, p_security_group_id)
324: WHERE ATTR_CODE_ID = p_ATTR_CODE_ID
325: --AND object_version_number = p_object_version_number
326: AND userenv('LANG') in (LANGUAGE, SOURCE_LANG);
327:

Line 330: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

326: AND userenv('LANG') in (LANGUAGE, SOURCE_LANG);
327:
328:
329: IF (SQL%NOTFOUND) THEN
330: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
331: END IF;
332:
333:
334: END IF;

Line 362: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

358: BEGIN
359: DELETE FROM PV_ATTRIBUTE_CODES_B
360: WHERE ATTR_CODE_ID = p_ATTR_CODE_ID;
361: If (SQL%NOTFOUND) then
362: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
363: End If;
364:
365: DELETE FROM PV_ATTRIBUTE_CODES_TL
366: WHERE ATTR_CODE_ID = p_ATTR_CODE_ID;

Line 368: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

364:
365: DELETE FROM PV_ATTRIBUTE_CODES_TL
366: WHERE ATTR_CODE_ID = p_ATTR_CODE_ID;
367: If (SQL%NOTFOUND) then
368: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
369: End If;
370:
371: END Delete_Row ;
372: