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

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

76: last_update_date,
77: last_update_login,
78: object_version_number
79: ) VALUES (
80: DECODE( px_stylesheet_id, FND_API.g_miss_num, NULL, px_stylesheet_id),
81: DECODE( p_content_type, FND_API.g_miss_char, NULL, p_content_type),
82: DECODE( p_stylesheet_filename, FND_API.g_miss_char, NULL, p_stylesheet_filename),
83: DECODE( p_status_code, FND_API.g_miss_char, NULL, p_status_code),
84: DECODE( p_created_by, FND_API.g_miss_num, NULL, p_created_by),

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

77: last_update_login,
78: object_version_number
79: ) VALUES (
80: DECODE( px_stylesheet_id, FND_API.g_miss_num, NULL, px_stylesheet_id),
81: DECODE( p_content_type, FND_API.g_miss_char, NULL, p_content_type),
82: DECODE( p_stylesheet_filename, FND_API.g_miss_char, NULL, p_stylesheet_filename),
83: DECODE( p_status_code, FND_API.g_miss_char, NULL, p_status_code),
84: DECODE( p_created_by, FND_API.g_miss_num, NULL, p_created_by),
85: DECODE( p_creation_date, FND_API.g_miss_date, NULL, p_creation_date),

Line 82: DECODE( p_stylesheet_filename, FND_API.g_miss_char, NULL, p_stylesheet_filename),

78: object_version_number
79: ) VALUES (
80: DECODE( px_stylesheet_id, FND_API.g_miss_num, NULL, px_stylesheet_id),
81: DECODE( p_content_type, FND_API.g_miss_char, NULL, p_content_type),
82: DECODE( p_stylesheet_filename, FND_API.g_miss_char, NULL, p_stylesheet_filename),
83: DECODE( p_status_code, FND_API.g_miss_char, NULL, p_status_code),
84: DECODE( p_created_by, FND_API.g_miss_num, NULL, p_created_by),
85: DECODE( p_creation_date, FND_API.g_miss_date, NULL, p_creation_date),
86: DECODE( p_last_updated_by, FND_API.g_miss_num, NULL, p_last_updated_by),

Line 83: DECODE( p_status_code, FND_API.g_miss_char, NULL, p_status_code),

79: ) VALUES (
80: DECODE( px_stylesheet_id, FND_API.g_miss_num, NULL, px_stylesheet_id),
81: DECODE( p_content_type, FND_API.g_miss_char, NULL, p_content_type),
82: DECODE( p_stylesheet_filename, FND_API.g_miss_char, NULL, p_stylesheet_filename),
83: DECODE( p_status_code, FND_API.g_miss_char, NULL, p_status_code),
84: DECODE( p_created_by, FND_API.g_miss_num, NULL, p_created_by),
85: DECODE( p_creation_date, FND_API.g_miss_date, NULL, p_creation_date),
86: DECODE( p_last_updated_by, FND_API.g_miss_num, NULL, p_last_updated_by),
87: DECODE( p_last_update_date, FND_API.g_miss_date, NULL, p_last_update_date),

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

80: DECODE( px_stylesheet_id, FND_API.g_miss_num, NULL, px_stylesheet_id),
81: DECODE( p_content_type, FND_API.g_miss_char, NULL, p_content_type),
82: DECODE( p_stylesheet_filename, FND_API.g_miss_char, NULL, p_stylesheet_filename),
83: DECODE( p_status_code, FND_API.g_miss_char, NULL, p_status_code),
84: DECODE( p_created_by, FND_API.g_miss_num, NULL, p_created_by),
85: DECODE( p_creation_date, FND_API.g_miss_date, NULL, p_creation_date),
86: DECODE( p_last_updated_by, FND_API.g_miss_num, NULL, p_last_updated_by),
87: DECODE( p_last_update_date, FND_API.g_miss_date, NULL, p_last_update_date),
88: DECODE( p_last_update_login, FND_API.g_miss_num, NULL, p_last_update_login),

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

81: DECODE( p_content_type, FND_API.g_miss_char, NULL, p_content_type),
82: DECODE( p_stylesheet_filename, FND_API.g_miss_char, NULL, p_stylesheet_filename),
83: DECODE( p_status_code, FND_API.g_miss_char, NULL, p_status_code),
84: DECODE( p_created_by, FND_API.g_miss_num, NULL, p_created_by),
85: DECODE( p_creation_date, FND_API.g_miss_date, NULL, p_creation_date),
86: DECODE( p_last_updated_by, FND_API.g_miss_num, NULL, p_last_updated_by),
87: DECODE( p_last_update_date, FND_API.g_miss_date, NULL, p_last_update_date),
88: DECODE( p_last_update_login, FND_API.g_miss_num, NULL, p_last_update_login),
89: DECODE( px_object_version_number, FND_API.g_miss_num, NULL, px_object_version_number));

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

82: DECODE( p_stylesheet_filename, FND_API.g_miss_char, NULL, p_stylesheet_filename),
83: DECODE( p_status_code, FND_API.g_miss_char, NULL, p_status_code),
84: DECODE( p_created_by, FND_API.g_miss_num, NULL, p_created_by),
85: DECODE( p_creation_date, FND_API.g_miss_date, NULL, p_creation_date),
86: DECODE( p_last_updated_by, FND_API.g_miss_num, NULL, p_last_updated_by),
87: DECODE( p_last_update_date, FND_API.g_miss_date, NULL, p_last_update_date),
88: DECODE( p_last_update_login, FND_API.g_miss_num, NULL, p_last_update_login),
89: DECODE( px_object_version_number, FND_API.g_miss_num, NULL, px_object_version_number));
90:

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

83: DECODE( p_status_code, FND_API.g_miss_char, NULL, p_status_code),
84: DECODE( p_created_by, FND_API.g_miss_num, NULL, p_created_by),
85: DECODE( p_creation_date, FND_API.g_miss_date, NULL, p_creation_date),
86: DECODE( p_last_updated_by, FND_API.g_miss_num, NULL, p_last_updated_by),
87: DECODE( p_last_update_date, FND_API.g_miss_date, NULL, p_last_update_date),
88: DECODE( p_last_update_login, FND_API.g_miss_num, NULL, p_last_update_login),
89: DECODE( px_object_version_number, FND_API.g_miss_num, NULL, px_object_version_number));
90:
91: IF (AMS_DEBUG_HIGH_ON) THEN

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

84: DECODE( p_created_by, FND_API.g_miss_num, NULL, p_created_by),
85: DECODE( p_creation_date, FND_API.g_miss_date, NULL, p_creation_date),
86: DECODE( p_last_updated_by, FND_API.g_miss_num, NULL, p_last_updated_by),
87: DECODE( p_last_update_date, FND_API.g_miss_date, NULL, p_last_update_date),
88: DECODE( p_last_update_login, FND_API.g_miss_num, NULL, p_last_update_login),
89: DECODE( px_object_version_number, FND_API.g_miss_num, NULL, px_object_version_number));
90:
91: IF (AMS_DEBUG_HIGH_ON) THEN
92:

Line 89: DECODE( px_object_version_number, FND_API.g_miss_num, NULL, px_object_version_number));

85: DECODE( p_creation_date, FND_API.g_miss_date, NULL, p_creation_date),
86: DECODE( p_last_updated_by, FND_API.g_miss_num, NULL, p_last_updated_by),
87: DECODE( p_last_update_date, FND_API.g_miss_date, NULL, p_last_update_date),
88: DECODE( p_last_update_login, FND_API.g_miss_num, NULL, p_last_update_login),
89: DECODE( px_object_version_number, FND_API.g_miss_num, NULL, px_object_version_number));
90:
91: IF (AMS_DEBUG_HIGH_ON) THEN
92:
93:

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

108: LAST_UPDATED_BY,
109: LANGUAGE,
110: SOURCE_LANG
111: ) select
112: DECODE( p_last_update_login, FND_API.g_miss_num, NULL, p_last_update_login),
113: DECODE( px_object_version_number, FND_API.g_miss_num, NULL, px_object_version_number),
114: DECODE( px_stylesheet_id, FND_API.g_miss_num, NULL, px_stylesheet_id),
115: DECODE( p_name, FND_API.g_miss_char, NULL, p_name),
116: DECODE( p_description, FND_API.g_miss_char, NULL, p_description),

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

109: LANGUAGE,
110: SOURCE_LANG
111: ) select
112: DECODE( p_last_update_login, FND_API.g_miss_num, NULL, p_last_update_login),
113: DECODE( px_object_version_number, FND_API.g_miss_num, NULL, px_object_version_number),
114: DECODE( px_stylesheet_id, FND_API.g_miss_num, NULL, px_stylesheet_id),
115: DECODE( p_name, FND_API.g_miss_char, NULL, p_name),
116: DECODE( p_description, FND_API.g_miss_char, NULL, p_description),
117: DECODE( p_created_by, FND_API.g_miss_num, NULL, p_created_by),

Line 114: DECODE( px_stylesheet_id, FND_API.g_miss_num, NULL, px_stylesheet_id),

110: SOURCE_LANG
111: ) select
112: DECODE( p_last_update_login, FND_API.g_miss_num, NULL, p_last_update_login),
113: DECODE( px_object_version_number, FND_API.g_miss_num, NULL, px_object_version_number),
114: DECODE( px_stylesheet_id, FND_API.g_miss_num, NULL, px_stylesheet_id),
115: DECODE( p_name, FND_API.g_miss_char, NULL, p_name),
116: DECODE( p_description, FND_API.g_miss_char, NULL, p_description),
117: DECODE( p_created_by, FND_API.g_miss_num, NULL, p_created_by),
118: DECODE( p_creation_date, FND_API.g_miss_date, NULL, p_creation_date),

Line 115: DECODE( p_name, FND_API.g_miss_char, NULL, p_name),

111: ) select
112: DECODE( p_last_update_login, FND_API.g_miss_num, NULL, p_last_update_login),
113: DECODE( px_object_version_number, FND_API.g_miss_num, NULL, px_object_version_number),
114: DECODE( px_stylesheet_id, FND_API.g_miss_num, NULL, px_stylesheet_id),
115: DECODE( p_name, FND_API.g_miss_char, NULL, p_name),
116: DECODE( p_description, FND_API.g_miss_char, NULL, p_description),
117: DECODE( p_created_by, FND_API.g_miss_num, NULL, p_created_by),
118: DECODE( p_creation_date, FND_API.g_miss_date, NULL, p_creation_date),
119: DECODE( p_last_update_date, FND_API.g_miss_date, NULL, p_last_update_date),

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

112: DECODE( p_last_update_login, FND_API.g_miss_num, NULL, p_last_update_login),
113: DECODE( px_object_version_number, FND_API.g_miss_num, NULL, px_object_version_number),
114: DECODE( px_stylesheet_id, FND_API.g_miss_num, NULL, px_stylesheet_id),
115: DECODE( p_name, FND_API.g_miss_char, NULL, p_name),
116: DECODE( p_description, FND_API.g_miss_char, NULL, p_description),
117: DECODE( p_created_by, FND_API.g_miss_num, NULL, p_created_by),
118: DECODE( p_creation_date, FND_API.g_miss_date, NULL, p_creation_date),
119: DECODE( p_last_update_date, FND_API.g_miss_date, NULL, p_last_update_date),
120: DECODE( p_last_updated_by, FND_API.g_miss_num, NULL, p_last_updated_by),

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

113: DECODE( px_object_version_number, FND_API.g_miss_num, NULL, px_object_version_number),
114: DECODE( px_stylesheet_id, FND_API.g_miss_num, NULL, px_stylesheet_id),
115: DECODE( p_name, FND_API.g_miss_char, NULL, p_name),
116: DECODE( p_description, FND_API.g_miss_char, NULL, p_description),
117: DECODE( p_created_by, FND_API.g_miss_num, NULL, p_created_by),
118: DECODE( p_creation_date, FND_API.g_miss_date, NULL, p_creation_date),
119: DECODE( p_last_update_date, FND_API.g_miss_date, NULL, p_last_update_date),
120: DECODE( p_last_updated_by, FND_API.g_miss_num, NULL, p_last_updated_by),
121: L.LANGUAGE_CODE,

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

114: DECODE( px_stylesheet_id, FND_API.g_miss_num, NULL, px_stylesheet_id),
115: DECODE( p_name, FND_API.g_miss_char, NULL, p_name),
116: DECODE( p_description, FND_API.g_miss_char, NULL, p_description),
117: DECODE( p_created_by, FND_API.g_miss_num, NULL, p_created_by),
118: DECODE( p_creation_date, FND_API.g_miss_date, NULL, p_creation_date),
119: DECODE( p_last_update_date, FND_API.g_miss_date, NULL, p_last_update_date),
120: DECODE( p_last_updated_by, FND_API.g_miss_num, NULL, p_last_updated_by),
121: L.LANGUAGE_CODE,
122: userenv('LANG')

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

115: DECODE( p_name, FND_API.g_miss_char, NULL, p_name),
116: DECODE( p_description, FND_API.g_miss_char, NULL, p_description),
117: DECODE( p_created_by, FND_API.g_miss_num, NULL, p_created_by),
118: DECODE( p_creation_date, FND_API.g_miss_date, NULL, p_creation_date),
119: DECODE( p_last_update_date, FND_API.g_miss_date, NULL, p_last_update_date),
120: DECODE( p_last_updated_by, FND_API.g_miss_num, NULL, p_last_updated_by),
121: L.LANGUAGE_CODE,
122: userenv('LANG')
123: from FND_LANGUAGES L

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

116: DECODE( p_description, FND_API.g_miss_char, NULL, p_description),
117: DECODE( p_created_by, FND_API.g_miss_num, NULL, p_created_by),
118: DECODE( p_creation_date, FND_API.g_miss_date, NULL, p_creation_date),
119: DECODE( p_last_update_date, FND_API.g_miss_date, NULL, p_last_update_date),
120: DECODE( p_last_updated_by, FND_API.g_miss_num, NULL, p_last_updated_by),
121: L.LANGUAGE_CODE,
122: userenv('LANG')
123: from FND_LANGUAGES L
124: where L.INSTALLED_FLAG in ('I', 'B')

Line 128: where T.STYLESHEET_ID = DECODE( px_stylesheet_id, FND_API.g_miss_num, NULL, px_stylesheet_id)

124: where L.INSTALLED_FLAG in ('I', 'B')
125: and not exists
126: (select NULL
127: from AMS_IBA_PL_STYLESHTS_TL T
128: where T.STYLESHEET_ID = DECODE( px_stylesheet_id, FND_API.g_miss_num, NULL, px_stylesheet_id)
129: and T.LANGUAGE = L.LANGUAGE_CODE);
130:
131: IF (AMS_DEBUG_HIGH_ON) THEN
132:

Line 175: content_type = DECODE( p_content_type, FND_API.g_miss_char, content_type, p_content_type),

171: IS
172: BEGIN
173: Update AMS_IBA_PL_STYLESHTS_B
174: SET
175: content_type = DECODE( p_content_type, FND_API.g_miss_char, content_type, p_content_type),
176: stylesheet_filename = DECODE( p_stylesheet_filename, FND_API.g_miss_char, stylesheet_filename, p_stylesheet_filename),
177: status_code = DECODE( p_status_code, FND_API.g_miss_char, status_code, p_status_code),
178: last_updated_by = DECODE( p_last_updated_by, FND_API.g_miss_num, last_updated_by, p_last_updated_by),
179: last_update_date = DECODE( p_last_update_date, FND_API.g_miss_date, last_update_date, p_last_update_date),

Line 176: stylesheet_filename = DECODE( p_stylesheet_filename, FND_API.g_miss_char, stylesheet_filename, p_stylesheet_filename),

172: BEGIN
173: Update AMS_IBA_PL_STYLESHTS_B
174: SET
175: content_type = DECODE( p_content_type, FND_API.g_miss_char, content_type, p_content_type),
176: stylesheet_filename = DECODE( p_stylesheet_filename, FND_API.g_miss_char, stylesheet_filename, p_stylesheet_filename),
177: status_code = DECODE( p_status_code, FND_API.g_miss_char, status_code, p_status_code),
178: last_updated_by = DECODE( p_last_updated_by, FND_API.g_miss_num, last_updated_by, p_last_updated_by),
179: last_update_date = DECODE( p_last_update_date, FND_API.g_miss_date, last_update_date, p_last_update_date),
180: last_update_login = DECODE( p_last_update_login, FND_API.g_miss_num, last_update_login, p_last_update_login),

Line 177: status_code = DECODE( p_status_code, FND_API.g_miss_char, status_code, p_status_code),

173: Update AMS_IBA_PL_STYLESHTS_B
174: SET
175: content_type = DECODE( p_content_type, FND_API.g_miss_char, content_type, p_content_type),
176: stylesheet_filename = DECODE( p_stylesheet_filename, FND_API.g_miss_char, stylesheet_filename, p_stylesheet_filename),
177: status_code = DECODE( p_status_code, FND_API.g_miss_char, status_code, p_status_code),
178: last_updated_by = DECODE( p_last_updated_by, FND_API.g_miss_num, last_updated_by, p_last_updated_by),
179: last_update_date = DECODE( p_last_update_date, FND_API.g_miss_date, last_update_date, p_last_update_date),
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)

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

174: SET
175: content_type = DECODE( p_content_type, FND_API.g_miss_char, content_type, p_content_type),
176: stylesheet_filename = DECODE( p_stylesheet_filename, FND_API.g_miss_char, stylesheet_filename, p_stylesheet_filename),
177: status_code = DECODE( p_status_code, FND_API.g_miss_char, status_code, p_status_code),
178: last_updated_by = DECODE( p_last_updated_by, FND_API.g_miss_num, last_updated_by, p_last_updated_by),
179: last_update_date = DECODE( p_last_update_date, FND_API.g_miss_date, last_update_date, p_last_update_date),
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)
182: WHERE STYLESHEET_ID = p_STYLESHEET_ID

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

175: content_type = DECODE( p_content_type, FND_API.g_miss_char, content_type, p_content_type),
176: stylesheet_filename = DECODE( p_stylesheet_filename, FND_API.g_miss_char, stylesheet_filename, p_stylesheet_filename),
177: status_code = DECODE( p_status_code, FND_API.g_miss_char, status_code, p_status_code),
178: last_updated_by = DECODE( p_last_updated_by, FND_API.g_miss_num, last_updated_by, p_last_updated_by),
179: last_update_date = DECODE( p_last_update_date, FND_API.g_miss_date, last_update_date, p_last_update_date),
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)
182: WHERE STYLESHEET_ID = p_STYLESHEET_ID
183: AND object_version_number = p_object_version_number;

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

176: stylesheet_filename = DECODE( p_stylesheet_filename, FND_API.g_miss_char, stylesheet_filename, p_stylesheet_filename),
177: status_code = DECODE( p_status_code, FND_API.g_miss_char, status_code, p_status_code),
178: last_updated_by = DECODE( p_last_updated_by, FND_API.g_miss_num, last_updated_by, p_last_updated_by),
179: last_update_date = DECODE( p_last_update_date, FND_API.g_miss_date, last_update_date, p_last_update_date),
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)
182: WHERE STYLESHEET_ID = p_STYLESHEET_ID
183: AND object_version_number = p_object_version_number;
184:

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

177: status_code = DECODE( p_status_code, FND_API.g_miss_char, status_code, p_status_code),
178: last_updated_by = DECODE( p_last_updated_by, FND_API.g_miss_num, last_updated_by, p_last_updated_by),
179: last_update_date = DECODE( p_last_update_date, FND_API.g_miss_date, last_update_date, p_last_update_date),
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)
182: WHERE STYLESHEET_ID = p_STYLESHEET_ID
183: AND object_version_number = p_object_version_number;
184:
185: IF (SQL%NOTFOUND) THEN

Line 186: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

182: WHERE STYLESHEET_ID = p_STYLESHEET_ID
183: AND object_version_number = p_object_version_number;
184:
185: IF (SQL%NOTFOUND) THEN
186: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
187: END IF;
188:
189: UPDATE ams_iba_pl_styleshts_tl SET
190: name = DECODE(p_name,FND_API.g_miss_char,name,p_name),

Line 190: name = DECODE(p_name,FND_API.g_miss_char,name,p_name),

186: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
187: END IF;
188:
189: UPDATE ams_iba_pl_styleshts_tl SET
190: name = DECODE(p_name,FND_API.g_miss_char,name,p_name),
191: description = DECODE(p_description,FND_API.g_miss_char,description,p_description),
192: last_update_date = DECODE( p_last_update_date, FND_API.g_miss_date, last_update_date, p_last_update_date),
193: last_updated_by = DECODE( p_last_updated_by, FND_API.g_miss_num, last_updated_by, p_last_updated_by),
194: last_update_login = DECODE( p_last_update_login, FND_API.g_miss_num, last_update_login, p_last_update_login),

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

187: END IF;
188:
189: UPDATE ams_iba_pl_styleshts_tl SET
190: name = DECODE(p_name,FND_API.g_miss_char,name,p_name),
191: description = DECODE(p_description,FND_API.g_miss_char,description,p_description),
192: last_update_date = DECODE( p_last_update_date, FND_API.g_miss_date, last_update_date, p_last_update_date),
193: last_updated_by = DECODE( p_last_updated_by, FND_API.g_miss_num, last_updated_by, p_last_updated_by),
194: last_update_login = DECODE( p_last_update_login, FND_API.g_miss_num, last_update_login, p_last_update_login),
195: source_lang = userenv('LANG')

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

188:
189: UPDATE ams_iba_pl_styleshts_tl SET
190: name = DECODE(p_name,FND_API.g_miss_char,name,p_name),
191: description = DECODE(p_description,FND_API.g_miss_char,description,p_description),
192: last_update_date = DECODE( p_last_update_date, FND_API.g_miss_date, last_update_date, p_last_update_date),
193: last_updated_by = DECODE( p_last_updated_by, FND_API.g_miss_num, last_updated_by, p_last_updated_by),
194: last_update_login = DECODE( p_last_update_login, FND_API.g_miss_num, last_update_login, p_last_update_login),
195: source_lang = userenv('LANG')
196: where stylesheet_id = p_stylesheet_iD

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

189: UPDATE ams_iba_pl_styleshts_tl SET
190: name = DECODE(p_name,FND_API.g_miss_char,name,p_name),
191: description = DECODE(p_description,FND_API.g_miss_char,description,p_description),
192: last_update_date = DECODE( p_last_update_date, FND_API.g_miss_date, last_update_date, p_last_update_date),
193: last_updated_by = DECODE( p_last_updated_by, FND_API.g_miss_num, last_updated_by, p_last_updated_by),
194: last_update_login = DECODE( p_last_update_login, FND_API.g_miss_num, last_update_login, p_last_update_login),
195: source_lang = userenv('LANG')
196: where stylesheet_id = p_stylesheet_iD
197: and userenv('lang') in (language, source_lang);

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

190: name = DECODE(p_name,FND_API.g_miss_char,name,p_name),
191: description = DECODE(p_description,FND_API.g_miss_char,description,p_description),
192: last_update_date = DECODE( p_last_update_date, FND_API.g_miss_date, last_update_date, p_last_update_date),
193: last_updated_by = DECODE( p_last_updated_by, FND_API.g_miss_num, last_updated_by, p_last_updated_by),
194: last_update_login = DECODE( p_last_update_login, FND_API.g_miss_num, last_update_login, p_last_update_login),
195: source_lang = userenv('LANG')
196: where stylesheet_id = p_stylesheet_iD
197: and userenv('lang') in (language, source_lang);
198:

Line 200: RAISE FND_API.g_exc_error;

196: where stylesheet_id = p_stylesheet_iD
197: and userenv('lang') in (language, source_lang);
198:
199: IF (SQL%NOTFOUND) THEN
200: RAISE FND_API.g_exc_error;
201: END IF;
202:
203: END Update_Row;
204:

Line 230: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

226: DELETE FROM ams_iba_pl_styleshts_b
227: WHERE stylesheet_id = p_stylesheet_id;
228:
229: If (SQL%NOTFOUND) then
230: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
231: End If;
232:
233: DELETE FROM ams_iba_pl_styleshts_tl
234: WHERE stylesheet_id = p_stylesheet_id;