90: attribute14,
91: attribute15
92:
93: ) VALUES (
94: DECODE( p_created_by, FND_API.g_miss_num, NULL, p_created_by),
95: DECODE( p_creation_date, FND_API.g_miss_date, NULL, p_creation_date),
96: DECODE( p_last_updated_by, FND_API.g_miss_num, NULL, p_last_updated_by),
97: DECODE( p_last_update_date, FND_API.g_miss_date, NULL, p_last_update_date),
98: DECODE( p_last_update_login, FND_API.g_miss_num, NULL, p_last_update_login),
91: attribute15
92:
93: ) VALUES (
94: DECODE( p_created_by, FND_API.g_miss_num, NULL, p_created_by),
95: DECODE( p_creation_date, FND_API.g_miss_date, NULL, p_creation_date),
96: DECODE( p_last_updated_by, FND_API.g_miss_num, NULL, p_last_updated_by),
97: DECODE( p_last_update_date, FND_API.g_miss_date, NULL, p_last_update_date),
98: DECODE( p_last_update_login, FND_API.g_miss_num, NULL, p_last_update_login),
99: DECODE( px_object_version_number, FND_API.g_miss_num, NULL, px_object_version_number),
92:
93: ) VALUES (
94: DECODE( p_created_by, FND_API.g_miss_num, NULL, p_created_by),
95: DECODE( p_creation_date, FND_API.g_miss_date, NULL, p_creation_date),
96: DECODE( p_last_updated_by, FND_API.g_miss_num, NULL, p_last_updated_by),
97: DECODE( p_last_update_date, FND_API.g_miss_date, NULL, p_last_update_date),
98: DECODE( p_last_update_login, FND_API.g_miss_num, NULL, p_last_update_login),
99: DECODE( px_object_version_number, FND_API.g_miss_num, NULL, px_object_version_number),
100: DECODE( px_posting_id, FND_API.g_miss_num, NULL, px_posting_id),
93: ) VALUES (
94: DECODE( p_created_by, FND_API.g_miss_num, NULL, p_created_by),
95: DECODE( p_creation_date, FND_API.g_miss_date, NULL, p_creation_date),
96: DECODE( p_last_updated_by, FND_API.g_miss_num, NULL, p_last_updated_by),
97: DECODE( p_last_update_date, FND_API.g_miss_date, NULL, p_last_update_date),
98: DECODE( p_last_update_login, FND_API.g_miss_num, NULL, p_last_update_login),
99: DECODE( px_object_version_number, FND_API.g_miss_num, NULL, px_object_version_number),
100: DECODE( px_posting_id, FND_API.g_miss_num, NULL, px_posting_id),
101: DECODE( p_max_no_contents, FND_API.g_miss_num, NULL, p_max_no_contents),
94: DECODE( p_created_by, FND_API.g_miss_num, NULL, p_created_by),
95: DECODE( p_creation_date, FND_API.g_miss_date, NULL, p_creation_date),
96: DECODE( p_last_updated_by, FND_API.g_miss_num, NULL, p_last_updated_by),
97: DECODE( p_last_update_date, FND_API.g_miss_date, NULL, p_last_update_date),
98: DECODE( p_last_update_login, FND_API.g_miss_num, NULL, p_last_update_login),
99: DECODE( px_object_version_number, FND_API.g_miss_num, NULL, px_object_version_number),
100: DECODE( px_posting_id, FND_API.g_miss_num, NULL, px_posting_id),
101: DECODE( p_max_no_contents, FND_API.g_miss_num, NULL, p_max_no_contents),
102: DECODE( p_posting_type, FND_API.g_miss_char, NULL, p_posting_type),
95: DECODE( p_creation_date, FND_API.g_miss_date, NULL, p_creation_date),
96: DECODE( p_last_updated_by, FND_API.g_miss_num, NULL, p_last_updated_by),
97: DECODE( p_last_update_date, FND_API.g_miss_date, NULL, p_last_update_date),
98: DECODE( p_last_update_login, FND_API.g_miss_num, NULL, p_last_update_login),
99: DECODE( px_object_version_number, FND_API.g_miss_num, NULL, px_object_version_number),
100: DECODE( px_posting_id, FND_API.g_miss_num, NULL, px_posting_id),
101: DECODE( p_max_no_contents, FND_API.g_miss_num, NULL, p_max_no_contents),
102: DECODE( p_posting_type, FND_API.g_miss_char, NULL, p_posting_type),
103: DECODE( p_content_type, FND_API.g_miss_char, NULL, p_content_type),
96: DECODE( p_last_updated_by, FND_API.g_miss_num, NULL, p_last_updated_by),
97: DECODE( p_last_update_date, FND_API.g_miss_date, NULL, p_last_update_date),
98: DECODE( p_last_update_login, FND_API.g_miss_num, NULL, p_last_update_login),
99: DECODE( px_object_version_number, FND_API.g_miss_num, NULL, px_object_version_number),
100: DECODE( px_posting_id, FND_API.g_miss_num, NULL, px_posting_id),
101: DECODE( p_max_no_contents, FND_API.g_miss_num, NULL, p_max_no_contents),
102: DECODE( p_posting_type, FND_API.g_miss_char, NULL, p_posting_type),
103: DECODE( p_content_type, FND_API.g_miss_char, NULL, p_content_type),
104: DECODE( p_default_content_id, FND_API.g_miss_num, NULL, p_default_content_id),
97: DECODE( p_last_update_date, FND_API.g_miss_date, NULL, p_last_update_date),
98: DECODE( p_last_update_login, FND_API.g_miss_num, NULL, p_last_update_login),
99: DECODE( px_object_version_number, FND_API.g_miss_num, NULL, px_object_version_number),
100: DECODE( px_posting_id, FND_API.g_miss_num, NULL, px_posting_id),
101: DECODE( p_max_no_contents, FND_API.g_miss_num, NULL, p_max_no_contents),
102: DECODE( p_posting_type, FND_API.g_miss_char, NULL, p_posting_type),
103: DECODE( p_content_type, FND_API.g_miss_char, NULL, p_content_type),
104: DECODE( p_default_content_id, FND_API.g_miss_num, NULL, p_default_content_id),
105: DECODE( p_status_code, FND_API.g_miss_char, NULL, p_status_code),
98: DECODE( p_last_update_login, FND_API.g_miss_num, NULL, p_last_update_login),
99: DECODE( px_object_version_number, FND_API.g_miss_num, NULL, px_object_version_number),
100: DECODE( px_posting_id, FND_API.g_miss_num, NULL, px_posting_id),
101: DECODE( p_max_no_contents, FND_API.g_miss_num, NULL, p_max_no_contents),
102: DECODE( p_posting_type, FND_API.g_miss_char, NULL, p_posting_type),
103: DECODE( p_content_type, FND_API.g_miss_char, NULL, p_content_type),
104: DECODE( p_default_content_id, FND_API.g_miss_num, NULL, p_default_content_id),
105: DECODE( p_status_code, FND_API.g_miss_char, NULL, p_status_code),
106: DECODE( p_attribute_category, FND_API.g_miss_char, NULL, p_attribute_category),
99: DECODE( px_object_version_number, FND_API.g_miss_num, NULL, px_object_version_number),
100: DECODE( px_posting_id, FND_API.g_miss_num, NULL, px_posting_id),
101: DECODE( p_max_no_contents, FND_API.g_miss_num, NULL, p_max_no_contents),
102: DECODE( p_posting_type, FND_API.g_miss_char, NULL, p_posting_type),
103: DECODE( p_content_type, FND_API.g_miss_char, NULL, p_content_type),
104: DECODE( p_default_content_id, FND_API.g_miss_num, NULL, p_default_content_id),
105: DECODE( p_status_code, FND_API.g_miss_char, NULL, p_status_code),
106: DECODE( p_attribute_category, FND_API.g_miss_char, NULL, p_attribute_category),
107: DECODE( p_attribute1, FND_API.g_miss_char, NULL, p_attribute1),
100: DECODE( px_posting_id, FND_API.g_miss_num, NULL, px_posting_id),
101: DECODE( p_max_no_contents, FND_API.g_miss_num, NULL, p_max_no_contents),
102: DECODE( p_posting_type, FND_API.g_miss_char, NULL, p_posting_type),
103: DECODE( p_content_type, FND_API.g_miss_char, NULL, p_content_type),
104: DECODE( p_default_content_id, FND_API.g_miss_num, NULL, p_default_content_id),
105: DECODE( p_status_code, FND_API.g_miss_char, NULL, p_status_code),
106: DECODE( p_attribute_category, FND_API.g_miss_char, NULL, p_attribute_category),
107: DECODE( p_attribute1, FND_API.g_miss_char, NULL, p_attribute1),
108: DECODE( p_attribute2, FND_API.g_miss_char, NULL, p_attribute2),
101: DECODE( p_max_no_contents, FND_API.g_miss_num, NULL, p_max_no_contents),
102: DECODE( p_posting_type, FND_API.g_miss_char, NULL, p_posting_type),
103: DECODE( p_content_type, FND_API.g_miss_char, NULL, p_content_type),
104: DECODE( p_default_content_id, FND_API.g_miss_num, NULL, p_default_content_id),
105: DECODE( p_status_code, FND_API.g_miss_char, NULL, p_status_code),
106: DECODE( p_attribute_category, FND_API.g_miss_char, NULL, p_attribute_category),
107: DECODE( p_attribute1, FND_API.g_miss_char, NULL, p_attribute1),
108: DECODE( p_attribute2, FND_API.g_miss_char, NULL, p_attribute2),
109: DECODE( p_attribute3, FND_API.g_miss_char, NULL, p_attribute3),
102: DECODE( p_posting_type, FND_API.g_miss_char, NULL, p_posting_type),
103: DECODE( p_content_type, FND_API.g_miss_char, NULL, p_content_type),
104: DECODE( p_default_content_id, FND_API.g_miss_num, NULL, p_default_content_id),
105: DECODE( p_status_code, FND_API.g_miss_char, NULL, p_status_code),
106: DECODE( p_attribute_category, FND_API.g_miss_char, NULL, p_attribute_category),
107: DECODE( p_attribute1, FND_API.g_miss_char, NULL, p_attribute1),
108: DECODE( p_attribute2, FND_API.g_miss_char, NULL, p_attribute2),
109: DECODE( p_attribute3, FND_API.g_miss_char, NULL, p_attribute3),
110: DECODE( p_attribute4, FND_API.g_miss_char, NULL, p_attribute4),
103: DECODE( p_content_type, FND_API.g_miss_char, NULL, p_content_type),
104: DECODE( p_default_content_id, FND_API.g_miss_num, NULL, p_default_content_id),
105: DECODE( p_status_code, FND_API.g_miss_char, NULL, p_status_code),
106: DECODE( p_attribute_category, FND_API.g_miss_char, NULL, p_attribute_category),
107: DECODE( p_attribute1, FND_API.g_miss_char, NULL, p_attribute1),
108: DECODE( p_attribute2, FND_API.g_miss_char, NULL, p_attribute2),
109: DECODE( p_attribute3, FND_API.g_miss_char, NULL, p_attribute3),
110: DECODE( p_attribute4, FND_API.g_miss_char, NULL, p_attribute4),
111: DECODE( p_attribute5, FND_API.g_miss_char, NULL, p_attribute5),
104: DECODE( p_default_content_id, FND_API.g_miss_num, NULL, p_default_content_id),
105: DECODE( p_status_code, FND_API.g_miss_char, NULL, p_status_code),
106: DECODE( p_attribute_category, FND_API.g_miss_char, NULL, p_attribute_category),
107: DECODE( p_attribute1, FND_API.g_miss_char, NULL, p_attribute1),
108: DECODE( p_attribute2, FND_API.g_miss_char, NULL, p_attribute2),
109: DECODE( p_attribute3, FND_API.g_miss_char, NULL, p_attribute3),
110: DECODE( p_attribute4, FND_API.g_miss_char, NULL, p_attribute4),
111: DECODE( p_attribute5, FND_API.g_miss_char, NULL, p_attribute5),
112: DECODE( p_attribute6, FND_API.g_miss_char, NULL, p_attribute6),
105: DECODE( p_status_code, FND_API.g_miss_char, NULL, p_status_code),
106: DECODE( p_attribute_category, FND_API.g_miss_char, NULL, p_attribute_category),
107: DECODE( p_attribute1, FND_API.g_miss_char, NULL, p_attribute1),
108: DECODE( p_attribute2, FND_API.g_miss_char, NULL, p_attribute2),
109: DECODE( p_attribute3, FND_API.g_miss_char, NULL, p_attribute3),
110: DECODE( p_attribute4, FND_API.g_miss_char, NULL, p_attribute4),
111: DECODE( p_attribute5, FND_API.g_miss_char, NULL, p_attribute5),
112: DECODE( p_attribute6, FND_API.g_miss_char, NULL, p_attribute6),
113: DECODE( p_attribute7, FND_API.g_miss_char, NULL, p_attribute7),
106: DECODE( p_attribute_category, FND_API.g_miss_char, NULL, p_attribute_category),
107: DECODE( p_attribute1, FND_API.g_miss_char, NULL, p_attribute1),
108: DECODE( p_attribute2, FND_API.g_miss_char, NULL, p_attribute2),
109: DECODE( p_attribute3, FND_API.g_miss_char, NULL, p_attribute3),
110: DECODE( p_attribute4, FND_API.g_miss_char, NULL, p_attribute4),
111: DECODE( p_attribute5, FND_API.g_miss_char, NULL, p_attribute5),
112: DECODE( p_attribute6, FND_API.g_miss_char, NULL, p_attribute6),
113: DECODE( p_attribute7, FND_API.g_miss_char, NULL, p_attribute7),
114: DECODE( p_attribute8, FND_API.g_miss_char, NULL, p_attribute8),
107: DECODE( p_attribute1, FND_API.g_miss_char, NULL, p_attribute1),
108: DECODE( p_attribute2, FND_API.g_miss_char, NULL, p_attribute2),
109: DECODE( p_attribute3, FND_API.g_miss_char, NULL, p_attribute3),
110: DECODE( p_attribute4, FND_API.g_miss_char, NULL, p_attribute4),
111: DECODE( p_attribute5, FND_API.g_miss_char, NULL, p_attribute5),
112: DECODE( p_attribute6, FND_API.g_miss_char, NULL, p_attribute6),
113: DECODE( p_attribute7, FND_API.g_miss_char, NULL, p_attribute7),
114: DECODE( p_attribute8, FND_API.g_miss_char, NULL, p_attribute8),
115: DECODE( p_attribute9, FND_API.g_miss_char, NULL, p_attribute9),
108: DECODE( p_attribute2, FND_API.g_miss_char, NULL, p_attribute2),
109: DECODE( p_attribute3, FND_API.g_miss_char, NULL, p_attribute3),
110: DECODE( p_attribute4, FND_API.g_miss_char, NULL, p_attribute4),
111: DECODE( p_attribute5, FND_API.g_miss_char, NULL, p_attribute5),
112: DECODE( p_attribute6, FND_API.g_miss_char, NULL, p_attribute6),
113: DECODE( p_attribute7, FND_API.g_miss_char, NULL, p_attribute7),
114: DECODE( p_attribute8, FND_API.g_miss_char, NULL, p_attribute8),
115: DECODE( p_attribute9, FND_API.g_miss_char, NULL, p_attribute9),
116: DECODE( p_attribute10, FND_API.g_miss_char, NULL, p_attribute10),
109: DECODE( p_attribute3, FND_API.g_miss_char, NULL, p_attribute3),
110: DECODE( p_attribute4, FND_API.g_miss_char, NULL, p_attribute4),
111: DECODE( p_attribute5, FND_API.g_miss_char, NULL, p_attribute5),
112: DECODE( p_attribute6, FND_API.g_miss_char, NULL, p_attribute6),
113: DECODE( p_attribute7, FND_API.g_miss_char, NULL, p_attribute7),
114: DECODE( p_attribute8, FND_API.g_miss_char, NULL, p_attribute8),
115: DECODE( p_attribute9, FND_API.g_miss_char, NULL, p_attribute9),
116: DECODE( p_attribute10, FND_API.g_miss_char, NULL, p_attribute10),
117: DECODE( p_attribute11, FND_API.g_miss_char, NULL, p_attribute11),
110: DECODE( p_attribute4, FND_API.g_miss_char, NULL, p_attribute4),
111: DECODE( p_attribute5, FND_API.g_miss_char, NULL, p_attribute5),
112: DECODE( p_attribute6, FND_API.g_miss_char, NULL, p_attribute6),
113: DECODE( p_attribute7, FND_API.g_miss_char, NULL, p_attribute7),
114: DECODE( p_attribute8, FND_API.g_miss_char, NULL, p_attribute8),
115: DECODE( p_attribute9, FND_API.g_miss_char, NULL, p_attribute9),
116: DECODE( p_attribute10, FND_API.g_miss_char, NULL, p_attribute10),
117: DECODE( p_attribute11, FND_API.g_miss_char, NULL, p_attribute11),
118: DECODE( p_attribute12, FND_API.g_miss_char, NULL, p_attribute12),
111: DECODE( p_attribute5, FND_API.g_miss_char, NULL, p_attribute5),
112: DECODE( p_attribute6, FND_API.g_miss_char, NULL, p_attribute6),
113: DECODE( p_attribute7, FND_API.g_miss_char, NULL, p_attribute7),
114: DECODE( p_attribute8, FND_API.g_miss_char, NULL, p_attribute8),
115: DECODE( p_attribute9, FND_API.g_miss_char, NULL, p_attribute9),
116: DECODE( p_attribute10, FND_API.g_miss_char, NULL, p_attribute10),
117: DECODE( p_attribute11, FND_API.g_miss_char, NULL, p_attribute11),
118: DECODE( p_attribute12, FND_API.g_miss_char, NULL, p_attribute12),
119: DECODE( p_attribute13, FND_API.g_miss_char, NULL, p_attribute13),
112: DECODE( p_attribute6, FND_API.g_miss_char, NULL, p_attribute6),
113: DECODE( p_attribute7, FND_API.g_miss_char, NULL, p_attribute7),
114: DECODE( p_attribute8, FND_API.g_miss_char, NULL, p_attribute8),
115: DECODE( p_attribute9, FND_API.g_miss_char, NULL, p_attribute9),
116: DECODE( p_attribute10, FND_API.g_miss_char, NULL, p_attribute10),
117: DECODE( p_attribute11, FND_API.g_miss_char, NULL, p_attribute11),
118: DECODE( p_attribute12, FND_API.g_miss_char, NULL, p_attribute12),
119: DECODE( p_attribute13, FND_API.g_miss_char, NULL, p_attribute13),
120: DECODE( p_attribute14, FND_API.g_miss_char, NULL, p_attribute14),
113: DECODE( p_attribute7, FND_API.g_miss_char, NULL, p_attribute7),
114: DECODE( p_attribute8, FND_API.g_miss_char, NULL, p_attribute8),
115: DECODE( p_attribute9, FND_API.g_miss_char, NULL, p_attribute9),
116: DECODE( p_attribute10, FND_API.g_miss_char, NULL, p_attribute10),
117: DECODE( p_attribute11, FND_API.g_miss_char, NULL, p_attribute11),
118: DECODE( p_attribute12, FND_API.g_miss_char, NULL, p_attribute12),
119: DECODE( p_attribute13, FND_API.g_miss_char, NULL, p_attribute13),
120: DECODE( p_attribute14, FND_API.g_miss_char, NULL, p_attribute14),
121: DECODE( p_attribute15, FND_API.g_miss_char, NULL, p_attribute15));
114: DECODE( p_attribute8, FND_API.g_miss_char, NULL, p_attribute8),
115: DECODE( p_attribute9, FND_API.g_miss_char, NULL, p_attribute9),
116: DECODE( p_attribute10, FND_API.g_miss_char, NULL, p_attribute10),
117: DECODE( p_attribute11, FND_API.g_miss_char, NULL, p_attribute11),
118: DECODE( p_attribute12, FND_API.g_miss_char, NULL, p_attribute12),
119: DECODE( p_attribute13, FND_API.g_miss_char, NULL, p_attribute13),
120: DECODE( p_attribute14, FND_API.g_miss_char, NULL, p_attribute14),
121: DECODE( p_attribute15, FND_API.g_miss_char, NULL, p_attribute15));
122:
115: DECODE( p_attribute9, FND_API.g_miss_char, NULL, p_attribute9),
116: DECODE( p_attribute10, FND_API.g_miss_char, NULL, p_attribute10),
117: DECODE( p_attribute11, FND_API.g_miss_char, NULL, p_attribute11),
118: DECODE( p_attribute12, FND_API.g_miss_char, NULL, p_attribute12),
119: DECODE( p_attribute13, FND_API.g_miss_char, NULL, p_attribute13),
120: DECODE( p_attribute14, FND_API.g_miss_char, NULL, p_attribute14),
121: DECODE( p_attribute15, FND_API.g_miss_char, NULL, p_attribute15));
122:
123:
116: DECODE( p_attribute10, FND_API.g_miss_char, NULL, p_attribute10),
117: DECODE( p_attribute11, FND_API.g_miss_char, NULL, p_attribute11),
118: DECODE( p_attribute12, FND_API.g_miss_char, NULL, p_attribute12),
119: DECODE( p_attribute13, FND_API.g_miss_char, NULL, p_attribute13),
120: DECODE( p_attribute14, FND_API.g_miss_char, NULL, p_attribute14),
121: DECODE( p_attribute15, FND_API.g_miss_char, NULL, p_attribute15));
122:
123:
124: INSERT INTO ams_iba_ps_postings_tl (
117: DECODE( p_attribute11, FND_API.g_miss_char, NULL, p_attribute11),
118: DECODE( p_attribute12, FND_API.g_miss_char, NULL, p_attribute12),
119: DECODE( p_attribute13, FND_API.g_miss_char, NULL, p_attribute13),
120: DECODE( p_attribute14, FND_API.g_miss_char, NULL, p_attribute14),
121: DECODE( p_attribute15, FND_API.g_miss_char, NULL, p_attribute15));
122:
123:
124: INSERT INTO ams_iba_ps_postings_tl (
125: created_by,
139: SYSDATE,
140: SYSDATE,
141: FND_GLOBAL.conc_login_id,
142: FND_GLOBAL.conc_login_id,
143: DECODE( px_object_version_number, FND_API.g_miss_num, NULL, px_object_version_number),
144: DECODE( px_posting_id, FND_API.g_miss_num, NULL, px_posting_id),
145: decode( p_posting_name, FND_API.G_MISS_CHAR, NULL, p_posting_name),
146: decode( p_display_name, FND_API.G_MISS_CHAR, NULL, p_display_name),
147: decode( p_posting_description, FND_API.G_MISS_CHAR, NULL, p_posting_description),
140: SYSDATE,
141: FND_GLOBAL.conc_login_id,
142: FND_GLOBAL.conc_login_id,
143: DECODE( px_object_version_number, FND_API.g_miss_num, NULL, px_object_version_number),
144: DECODE( px_posting_id, FND_API.g_miss_num, NULL, px_posting_id),
145: decode( p_posting_name, FND_API.G_MISS_CHAR, NULL, p_posting_name),
146: decode( p_display_name, FND_API.G_MISS_CHAR, NULL, p_display_name),
147: decode( p_posting_description, FND_API.G_MISS_CHAR, NULL, p_posting_description),
148: l.language_code,
141: FND_GLOBAL.conc_login_id,
142: FND_GLOBAL.conc_login_id,
143: DECODE( px_object_version_number, FND_API.g_miss_num, NULL, px_object_version_number),
144: DECODE( px_posting_id, FND_API.g_miss_num, NULL, px_posting_id),
145: decode( p_posting_name, FND_API.G_MISS_CHAR, NULL, p_posting_name),
146: decode( p_display_name, FND_API.G_MISS_CHAR, NULL, p_display_name),
147: decode( p_posting_description, FND_API.G_MISS_CHAR, NULL, p_posting_description),
148: l.language_code,
149: USERENV('LANG')
142: FND_GLOBAL.conc_login_id,
143: DECODE( px_object_version_number, FND_API.g_miss_num, NULL, px_object_version_number),
144: DECODE( px_posting_id, FND_API.g_miss_num, NULL, px_posting_id),
145: decode( p_posting_name, FND_API.G_MISS_CHAR, NULL, p_posting_name),
146: decode( p_display_name, FND_API.G_MISS_CHAR, NULL, p_display_name),
147: decode( p_posting_description, FND_API.G_MISS_CHAR, NULL, p_posting_description),
148: l.language_code,
149: USERENV('LANG')
150: FROM fnd_languages l
143: DECODE( px_object_version_number, FND_API.g_miss_num, NULL, px_object_version_number),
144: DECODE( px_posting_id, FND_API.g_miss_num, NULL, px_posting_id),
145: decode( p_posting_name, FND_API.G_MISS_CHAR, NULL, p_posting_name),
146: decode( p_display_name, FND_API.G_MISS_CHAR, NULL, p_display_name),
147: decode( p_posting_description, FND_API.G_MISS_CHAR, NULL, p_posting_description),
148: l.language_code,
149: USERENV('LANG')
150: FROM fnd_languages l
151: WHERE l.installed_flag IN ('I', 'B')
151: WHERE l.installed_flag IN ('I', 'B')
152: AND NOT EXISTS
153: (SELECT null
154: FROM ams_iba_ps_postings_tl t
155: WHERE t.posting_id = DECODE( px_posting_id, FND_API.g_miss_num, NULL, px_posting_id)
156: AND t.language = l.language_code);
157:
158: END Insert_Row;
159:
210: IS
211: BEGIN
212: Update AMS_IBA_PS_POSTINGS_B
213: SET
214: created_by = DECODE( p_created_by, FND_API.g_miss_num, created_by, p_created_by),
215: creation_date = DECODE( p_creation_date, FND_API.g_miss_date, creation_date, p_creation_date),
216: last_updated_by = DECODE( p_last_updated_by, FND_API.g_miss_num, last_updated_by, p_last_updated_by),
217: last_update_date = DECODE( p_last_update_date, FND_API.g_miss_date, last_update_date, p_last_update_date),
218: last_update_login = DECODE( p_last_update_login, FND_API.g_miss_num, last_update_login, p_last_update_login),
211: BEGIN
212: Update AMS_IBA_PS_POSTINGS_B
213: SET
214: created_by = DECODE( p_created_by, FND_API.g_miss_num, created_by, p_created_by),
215: creation_date = DECODE( p_creation_date, FND_API.g_miss_date, creation_date, p_creation_date),
216: last_updated_by = DECODE( p_last_updated_by, FND_API.g_miss_num, last_updated_by, p_last_updated_by),
217: last_update_date = DECODE( p_last_update_date, FND_API.g_miss_date, last_update_date, p_last_update_date),
218: last_update_login = DECODE( p_last_update_login, FND_API.g_miss_num, last_update_login, p_last_update_login),
219: object_version_number = DECODE( p_object_version_number, FND_API.g_miss_num, object_version_number, p_object_version_number),
212: Update AMS_IBA_PS_POSTINGS_B
213: SET
214: created_by = DECODE( p_created_by, FND_API.g_miss_num, created_by, p_created_by),
215: creation_date = DECODE( p_creation_date, FND_API.g_miss_date, creation_date, p_creation_date),
216: last_updated_by = DECODE( p_last_updated_by, FND_API.g_miss_num, last_updated_by, p_last_updated_by),
217: last_update_date = DECODE( p_last_update_date, FND_API.g_miss_date, last_update_date, p_last_update_date),
218: last_update_login = DECODE( p_last_update_login, FND_API.g_miss_num, last_update_login, p_last_update_login),
219: object_version_number = DECODE( p_object_version_number, FND_API.g_miss_num, object_version_number, p_object_version_number),
220: posting_id = DECODE( p_posting_id, FND_API.g_miss_num, posting_id, p_posting_id),
213: SET
214: created_by = DECODE( p_created_by, FND_API.g_miss_num, created_by, p_created_by),
215: creation_date = DECODE( p_creation_date, FND_API.g_miss_date, creation_date, p_creation_date),
216: last_updated_by = DECODE( p_last_updated_by, FND_API.g_miss_num, last_updated_by, p_last_updated_by),
217: last_update_date = DECODE( p_last_update_date, FND_API.g_miss_date, last_update_date, p_last_update_date),
218: last_update_login = DECODE( p_last_update_login, FND_API.g_miss_num, last_update_login, p_last_update_login),
219: object_version_number = DECODE( p_object_version_number, FND_API.g_miss_num, object_version_number, p_object_version_number),
220: posting_id = DECODE( p_posting_id, FND_API.g_miss_num, posting_id, p_posting_id),
221: max_no_contents = DECODE( p_max_no_contents, FND_API.g_miss_num, max_no_contents, p_max_no_contents),
214: created_by = DECODE( p_created_by, FND_API.g_miss_num, created_by, p_created_by),
215: creation_date = DECODE( p_creation_date, FND_API.g_miss_date, creation_date, p_creation_date),
216: last_updated_by = DECODE( p_last_updated_by, FND_API.g_miss_num, last_updated_by, p_last_updated_by),
217: last_update_date = DECODE( p_last_update_date, FND_API.g_miss_date, last_update_date, p_last_update_date),
218: last_update_login = DECODE( p_last_update_login, FND_API.g_miss_num, last_update_login, p_last_update_login),
219: object_version_number = DECODE( p_object_version_number, FND_API.g_miss_num, object_version_number, p_object_version_number),
220: posting_id = DECODE( p_posting_id, FND_API.g_miss_num, posting_id, p_posting_id),
221: max_no_contents = DECODE( p_max_no_contents, FND_API.g_miss_num, max_no_contents, p_max_no_contents),
222: posting_type = DECODE( p_posting_type, FND_API.g_miss_char, posting_type, p_posting_type),
215: creation_date = DECODE( p_creation_date, FND_API.g_miss_date, creation_date, p_creation_date),
216: last_updated_by = DECODE( p_last_updated_by, FND_API.g_miss_num, last_updated_by, p_last_updated_by),
217: last_update_date = DECODE( p_last_update_date, FND_API.g_miss_date, last_update_date, p_last_update_date),
218: last_update_login = DECODE( p_last_update_login, FND_API.g_miss_num, last_update_login, p_last_update_login),
219: object_version_number = DECODE( p_object_version_number, FND_API.g_miss_num, object_version_number, p_object_version_number),
220: posting_id = DECODE( p_posting_id, FND_API.g_miss_num, posting_id, p_posting_id),
221: max_no_contents = DECODE( p_max_no_contents, FND_API.g_miss_num, max_no_contents, p_max_no_contents),
222: posting_type = DECODE( p_posting_type, FND_API.g_miss_char, posting_type, p_posting_type),
223: content_type = DECODE( p_content_type, FND_API.g_miss_char, content_type, p_content_type),
216: last_updated_by = DECODE( p_last_updated_by, FND_API.g_miss_num, last_updated_by, p_last_updated_by),
217: last_update_date = DECODE( p_last_update_date, FND_API.g_miss_date, last_update_date, p_last_update_date),
218: last_update_login = DECODE( p_last_update_login, FND_API.g_miss_num, last_update_login, p_last_update_login),
219: object_version_number = DECODE( p_object_version_number, FND_API.g_miss_num, object_version_number, p_object_version_number),
220: posting_id = DECODE( p_posting_id, FND_API.g_miss_num, posting_id, p_posting_id),
221: max_no_contents = DECODE( p_max_no_contents, FND_API.g_miss_num, max_no_contents, p_max_no_contents),
222: posting_type = DECODE( p_posting_type, FND_API.g_miss_char, posting_type, p_posting_type),
223: content_type = DECODE( p_content_type, FND_API.g_miss_char, content_type, p_content_type),
224: default_content_id = DECODE( p_default_content_id, FND_API.g_miss_num, default_content_id, p_default_content_id),
217: last_update_date = DECODE( p_last_update_date, FND_API.g_miss_date, last_update_date, p_last_update_date),
218: last_update_login = DECODE( p_last_update_login, FND_API.g_miss_num, last_update_login, p_last_update_login),
219: object_version_number = DECODE( p_object_version_number, FND_API.g_miss_num, object_version_number, p_object_version_number),
220: posting_id = DECODE( p_posting_id, FND_API.g_miss_num, posting_id, p_posting_id),
221: max_no_contents = DECODE( p_max_no_contents, FND_API.g_miss_num, max_no_contents, p_max_no_contents),
222: posting_type = DECODE( p_posting_type, FND_API.g_miss_char, posting_type, p_posting_type),
223: content_type = DECODE( p_content_type, FND_API.g_miss_char, content_type, p_content_type),
224: default_content_id = DECODE( p_default_content_id, FND_API.g_miss_num, default_content_id, p_default_content_id),
225: status_code = DECODE( p_status_code, FND_API.g_miss_char, status_code, p_status_code),
218: last_update_login = DECODE( p_last_update_login, FND_API.g_miss_num, last_update_login, p_last_update_login),
219: object_version_number = DECODE( p_object_version_number, FND_API.g_miss_num, object_version_number, p_object_version_number),
220: posting_id = DECODE( p_posting_id, FND_API.g_miss_num, posting_id, p_posting_id),
221: max_no_contents = DECODE( p_max_no_contents, FND_API.g_miss_num, max_no_contents, p_max_no_contents),
222: posting_type = DECODE( p_posting_type, FND_API.g_miss_char, posting_type, p_posting_type),
223: content_type = DECODE( p_content_type, FND_API.g_miss_char, content_type, p_content_type),
224: default_content_id = DECODE( p_default_content_id, FND_API.g_miss_num, default_content_id, p_default_content_id),
225: status_code = DECODE( p_status_code, FND_API.g_miss_char, status_code, p_status_code),
226: attribute_category = DECODE( p_attribute_category, FND_API.g_miss_char, attribute_category, p_attribute_category),
219: object_version_number = DECODE( p_object_version_number, FND_API.g_miss_num, object_version_number, p_object_version_number),
220: posting_id = DECODE( p_posting_id, FND_API.g_miss_num, posting_id, p_posting_id),
221: max_no_contents = DECODE( p_max_no_contents, FND_API.g_miss_num, max_no_contents, p_max_no_contents),
222: posting_type = DECODE( p_posting_type, FND_API.g_miss_char, posting_type, p_posting_type),
223: content_type = DECODE( p_content_type, FND_API.g_miss_char, content_type, p_content_type),
224: default_content_id = DECODE( p_default_content_id, FND_API.g_miss_num, default_content_id, p_default_content_id),
225: status_code = DECODE( p_status_code, FND_API.g_miss_char, status_code, p_status_code),
226: attribute_category = DECODE( p_attribute_category, FND_API.g_miss_char, attribute_category, p_attribute_category),
227: attribute1 = DECODE( p_attribute1, FND_API.g_miss_char, attribute1, p_attribute1),
220: posting_id = DECODE( p_posting_id, FND_API.g_miss_num, posting_id, p_posting_id),
221: max_no_contents = DECODE( p_max_no_contents, FND_API.g_miss_num, max_no_contents, p_max_no_contents),
222: posting_type = DECODE( p_posting_type, FND_API.g_miss_char, posting_type, p_posting_type),
223: content_type = DECODE( p_content_type, FND_API.g_miss_char, content_type, p_content_type),
224: default_content_id = DECODE( p_default_content_id, FND_API.g_miss_num, default_content_id, p_default_content_id),
225: status_code = DECODE( p_status_code, FND_API.g_miss_char, status_code, p_status_code),
226: attribute_category = DECODE( p_attribute_category, FND_API.g_miss_char, attribute_category, p_attribute_category),
227: attribute1 = DECODE( p_attribute1, FND_API.g_miss_char, attribute1, p_attribute1),
228: attribute2 = DECODE( p_attribute2, FND_API.g_miss_char, attribute2, p_attribute2),
221: max_no_contents = DECODE( p_max_no_contents, FND_API.g_miss_num, max_no_contents, p_max_no_contents),
222: posting_type = DECODE( p_posting_type, FND_API.g_miss_char, posting_type, p_posting_type),
223: content_type = DECODE( p_content_type, FND_API.g_miss_char, content_type, p_content_type),
224: default_content_id = DECODE( p_default_content_id, FND_API.g_miss_num, default_content_id, p_default_content_id),
225: status_code = DECODE( p_status_code, FND_API.g_miss_char, status_code, p_status_code),
226: attribute_category = DECODE( p_attribute_category, FND_API.g_miss_char, attribute_category, p_attribute_category),
227: attribute1 = DECODE( p_attribute1, FND_API.g_miss_char, attribute1, p_attribute1),
228: attribute2 = DECODE( p_attribute2, FND_API.g_miss_char, attribute2, p_attribute2),
229: attribute3 = DECODE( p_attribute3, FND_API.g_miss_char, attribute3, p_attribute3),
222: posting_type = DECODE( p_posting_type, FND_API.g_miss_char, posting_type, p_posting_type),
223: content_type = DECODE( p_content_type, FND_API.g_miss_char, content_type, p_content_type),
224: default_content_id = DECODE( p_default_content_id, FND_API.g_miss_num, default_content_id, p_default_content_id),
225: status_code = DECODE( p_status_code, FND_API.g_miss_char, status_code, p_status_code),
226: attribute_category = DECODE( p_attribute_category, FND_API.g_miss_char, attribute_category, p_attribute_category),
227: attribute1 = DECODE( p_attribute1, FND_API.g_miss_char, attribute1, p_attribute1),
228: attribute2 = DECODE( p_attribute2, FND_API.g_miss_char, attribute2, p_attribute2),
229: attribute3 = DECODE( p_attribute3, FND_API.g_miss_char, attribute3, p_attribute3),
230: attribute4 = DECODE( p_attribute4, FND_API.g_miss_char, attribute4, p_attribute4),
223: content_type = DECODE( p_content_type, FND_API.g_miss_char, content_type, p_content_type),
224: default_content_id = DECODE( p_default_content_id, FND_API.g_miss_num, default_content_id, p_default_content_id),
225: status_code = DECODE( p_status_code, FND_API.g_miss_char, status_code, p_status_code),
226: attribute_category = DECODE( p_attribute_category, FND_API.g_miss_char, attribute_category, p_attribute_category),
227: attribute1 = DECODE( p_attribute1, FND_API.g_miss_char, attribute1, p_attribute1),
228: attribute2 = DECODE( p_attribute2, FND_API.g_miss_char, attribute2, p_attribute2),
229: attribute3 = DECODE( p_attribute3, FND_API.g_miss_char, attribute3, p_attribute3),
230: attribute4 = DECODE( p_attribute4, FND_API.g_miss_char, attribute4, p_attribute4),
231: attribute5 = DECODE( p_attribute5, FND_API.g_miss_char, attribute5, p_attribute5),
224: default_content_id = DECODE( p_default_content_id, FND_API.g_miss_num, default_content_id, p_default_content_id),
225: status_code = DECODE( p_status_code, FND_API.g_miss_char, status_code, p_status_code),
226: attribute_category = DECODE( p_attribute_category, FND_API.g_miss_char, attribute_category, p_attribute_category),
227: attribute1 = DECODE( p_attribute1, FND_API.g_miss_char, attribute1, p_attribute1),
228: attribute2 = DECODE( p_attribute2, FND_API.g_miss_char, attribute2, p_attribute2),
229: attribute3 = DECODE( p_attribute3, FND_API.g_miss_char, attribute3, p_attribute3),
230: attribute4 = DECODE( p_attribute4, FND_API.g_miss_char, attribute4, p_attribute4),
231: attribute5 = DECODE( p_attribute5, FND_API.g_miss_char, attribute5, p_attribute5),
232: attribute6 = DECODE( p_attribute6, FND_API.g_miss_char, attribute6, p_attribute6),
225: status_code = DECODE( p_status_code, FND_API.g_miss_char, status_code, p_status_code),
226: attribute_category = DECODE( p_attribute_category, FND_API.g_miss_char, attribute_category, p_attribute_category),
227: attribute1 = DECODE( p_attribute1, FND_API.g_miss_char, attribute1, p_attribute1),
228: attribute2 = DECODE( p_attribute2, FND_API.g_miss_char, attribute2, p_attribute2),
229: attribute3 = DECODE( p_attribute3, FND_API.g_miss_char, attribute3, p_attribute3),
230: attribute4 = DECODE( p_attribute4, FND_API.g_miss_char, attribute4, p_attribute4),
231: attribute5 = DECODE( p_attribute5, FND_API.g_miss_char, attribute5, p_attribute5),
232: attribute6 = DECODE( p_attribute6, FND_API.g_miss_char, attribute6, p_attribute6),
233: attribute7 = DECODE( p_attribute7, FND_API.g_miss_char, attribute7, p_attribute7),
226: attribute_category = DECODE( p_attribute_category, FND_API.g_miss_char, attribute_category, p_attribute_category),
227: attribute1 = DECODE( p_attribute1, FND_API.g_miss_char, attribute1, p_attribute1),
228: attribute2 = DECODE( p_attribute2, FND_API.g_miss_char, attribute2, p_attribute2),
229: attribute3 = DECODE( p_attribute3, FND_API.g_miss_char, attribute3, p_attribute3),
230: attribute4 = DECODE( p_attribute4, FND_API.g_miss_char, attribute4, p_attribute4),
231: attribute5 = DECODE( p_attribute5, FND_API.g_miss_char, attribute5, p_attribute5),
232: attribute6 = DECODE( p_attribute6, FND_API.g_miss_char, attribute6, p_attribute6),
233: attribute7 = DECODE( p_attribute7, FND_API.g_miss_char, attribute7, p_attribute7),
234: attribute8 = DECODE( p_attribute8, FND_API.g_miss_char, attribute8, p_attribute8),
227: attribute1 = DECODE( p_attribute1, FND_API.g_miss_char, attribute1, p_attribute1),
228: attribute2 = DECODE( p_attribute2, FND_API.g_miss_char, attribute2, p_attribute2),
229: attribute3 = DECODE( p_attribute3, FND_API.g_miss_char, attribute3, p_attribute3),
230: attribute4 = DECODE( p_attribute4, FND_API.g_miss_char, attribute4, p_attribute4),
231: attribute5 = DECODE( p_attribute5, FND_API.g_miss_char, attribute5, p_attribute5),
232: attribute6 = DECODE( p_attribute6, FND_API.g_miss_char, attribute6, p_attribute6),
233: attribute7 = DECODE( p_attribute7, FND_API.g_miss_char, attribute7, p_attribute7),
234: attribute8 = DECODE( p_attribute8, FND_API.g_miss_char, attribute8, p_attribute8),
235: attribute9 = DECODE( p_attribute9, FND_API.g_miss_char, attribute9, p_attribute9),
228: attribute2 = DECODE( p_attribute2, FND_API.g_miss_char, attribute2, p_attribute2),
229: attribute3 = DECODE( p_attribute3, FND_API.g_miss_char, attribute3, p_attribute3),
230: attribute4 = DECODE( p_attribute4, FND_API.g_miss_char, attribute4, p_attribute4),
231: attribute5 = DECODE( p_attribute5, FND_API.g_miss_char, attribute5, p_attribute5),
232: attribute6 = DECODE( p_attribute6, FND_API.g_miss_char, attribute6, p_attribute6),
233: attribute7 = DECODE( p_attribute7, FND_API.g_miss_char, attribute7, p_attribute7),
234: attribute8 = DECODE( p_attribute8, FND_API.g_miss_char, attribute8, p_attribute8),
235: attribute9 = DECODE( p_attribute9, FND_API.g_miss_char, attribute9, p_attribute9),
236: attribute10 = DECODE( p_attribute10, FND_API.g_miss_char, attribute10, p_attribute10),
229: attribute3 = DECODE( p_attribute3, FND_API.g_miss_char, attribute3, p_attribute3),
230: attribute4 = DECODE( p_attribute4, FND_API.g_miss_char, attribute4, p_attribute4),
231: attribute5 = DECODE( p_attribute5, FND_API.g_miss_char, attribute5, p_attribute5),
232: attribute6 = DECODE( p_attribute6, FND_API.g_miss_char, attribute6, p_attribute6),
233: attribute7 = DECODE( p_attribute7, FND_API.g_miss_char, attribute7, p_attribute7),
234: attribute8 = DECODE( p_attribute8, FND_API.g_miss_char, attribute8, p_attribute8),
235: attribute9 = DECODE( p_attribute9, FND_API.g_miss_char, attribute9, p_attribute9),
236: attribute10 = DECODE( p_attribute10, FND_API.g_miss_char, attribute10, p_attribute10),
237: attribute11 = DECODE( p_attribute11, FND_API.g_miss_char, attribute11, p_attribute11),
230: attribute4 = DECODE( p_attribute4, FND_API.g_miss_char, attribute4, p_attribute4),
231: attribute5 = DECODE( p_attribute5, FND_API.g_miss_char, attribute5, p_attribute5),
232: attribute6 = DECODE( p_attribute6, FND_API.g_miss_char, attribute6, p_attribute6),
233: attribute7 = DECODE( p_attribute7, FND_API.g_miss_char, attribute7, p_attribute7),
234: attribute8 = DECODE( p_attribute8, FND_API.g_miss_char, attribute8, p_attribute8),
235: attribute9 = DECODE( p_attribute9, FND_API.g_miss_char, attribute9, p_attribute9),
236: attribute10 = DECODE( p_attribute10, FND_API.g_miss_char, attribute10, p_attribute10),
237: attribute11 = DECODE( p_attribute11, FND_API.g_miss_char, attribute11, p_attribute11),
238: attribute12 = DECODE( p_attribute12, FND_API.g_miss_char, attribute12, p_attribute12),
231: attribute5 = DECODE( p_attribute5, FND_API.g_miss_char, attribute5, p_attribute5),
232: attribute6 = DECODE( p_attribute6, FND_API.g_miss_char, attribute6, p_attribute6),
233: attribute7 = DECODE( p_attribute7, FND_API.g_miss_char, attribute7, p_attribute7),
234: attribute8 = DECODE( p_attribute8, FND_API.g_miss_char, attribute8, p_attribute8),
235: attribute9 = DECODE( p_attribute9, FND_API.g_miss_char, attribute9, p_attribute9),
236: attribute10 = DECODE( p_attribute10, FND_API.g_miss_char, attribute10, p_attribute10),
237: attribute11 = DECODE( p_attribute11, FND_API.g_miss_char, attribute11, p_attribute11),
238: attribute12 = DECODE( p_attribute12, FND_API.g_miss_char, attribute12, p_attribute12),
239: attribute13 = DECODE( p_attribute13, FND_API.g_miss_char, attribute13, p_attribute13),
232: attribute6 = DECODE( p_attribute6, FND_API.g_miss_char, attribute6, p_attribute6),
233: attribute7 = DECODE( p_attribute7, FND_API.g_miss_char, attribute7, p_attribute7),
234: attribute8 = DECODE( p_attribute8, FND_API.g_miss_char, attribute8, p_attribute8),
235: attribute9 = DECODE( p_attribute9, FND_API.g_miss_char, attribute9, p_attribute9),
236: attribute10 = DECODE( p_attribute10, FND_API.g_miss_char, attribute10, p_attribute10),
237: attribute11 = DECODE( p_attribute11, FND_API.g_miss_char, attribute11, p_attribute11),
238: attribute12 = DECODE( p_attribute12, FND_API.g_miss_char, attribute12, p_attribute12),
239: attribute13 = DECODE( p_attribute13, FND_API.g_miss_char, attribute13, p_attribute13),
240: attribute14 = DECODE( p_attribute14, FND_API.g_miss_char, attribute14, p_attribute14),
233: attribute7 = DECODE( p_attribute7, FND_API.g_miss_char, attribute7, p_attribute7),
234: attribute8 = DECODE( p_attribute8, FND_API.g_miss_char, attribute8, p_attribute8),
235: attribute9 = DECODE( p_attribute9, FND_API.g_miss_char, attribute9, p_attribute9),
236: attribute10 = DECODE( p_attribute10, FND_API.g_miss_char, attribute10, p_attribute10),
237: attribute11 = DECODE( p_attribute11, FND_API.g_miss_char, attribute11, p_attribute11),
238: attribute12 = DECODE( p_attribute12, FND_API.g_miss_char, attribute12, p_attribute12),
239: attribute13 = DECODE( p_attribute13, FND_API.g_miss_char, attribute13, p_attribute13),
240: attribute14 = DECODE( p_attribute14, FND_API.g_miss_char, attribute14, p_attribute14),
241: attribute15 = DECODE( p_attribute15, FND_API.g_miss_char, attribute15, p_attribute15)
234: attribute8 = DECODE( p_attribute8, FND_API.g_miss_char, attribute8, p_attribute8),
235: attribute9 = DECODE( p_attribute9, FND_API.g_miss_char, attribute9, p_attribute9),
236: attribute10 = DECODE( p_attribute10, FND_API.g_miss_char, attribute10, p_attribute10),
237: attribute11 = DECODE( p_attribute11, FND_API.g_miss_char, attribute11, p_attribute11),
238: attribute12 = DECODE( p_attribute12, FND_API.g_miss_char, attribute12, p_attribute12),
239: attribute13 = DECODE( p_attribute13, FND_API.g_miss_char, attribute13, p_attribute13),
240: attribute14 = DECODE( p_attribute14, FND_API.g_miss_char, attribute14, p_attribute14),
241: attribute15 = DECODE( p_attribute15, FND_API.g_miss_char, attribute15, p_attribute15)
242:
235: attribute9 = DECODE( p_attribute9, FND_API.g_miss_char, attribute9, p_attribute9),
236: attribute10 = DECODE( p_attribute10, FND_API.g_miss_char, attribute10, p_attribute10),
237: attribute11 = DECODE( p_attribute11, FND_API.g_miss_char, attribute11, p_attribute11),
238: attribute12 = DECODE( p_attribute12, FND_API.g_miss_char, attribute12, p_attribute12),
239: attribute13 = DECODE( p_attribute13, FND_API.g_miss_char, attribute13, p_attribute13),
240: attribute14 = DECODE( p_attribute14, FND_API.g_miss_char, attribute14, p_attribute14),
241: attribute15 = DECODE( p_attribute15, FND_API.g_miss_char, attribute15, p_attribute15)
242:
243: WHERE posting_id = p_posting_id
236: attribute10 = DECODE( p_attribute10, FND_API.g_miss_char, attribute10, p_attribute10),
237: attribute11 = DECODE( p_attribute11, FND_API.g_miss_char, attribute11, p_attribute11),
238: attribute12 = DECODE( p_attribute12, FND_API.g_miss_char, attribute12, p_attribute12),
239: attribute13 = DECODE( p_attribute13, FND_API.g_miss_char, attribute13, p_attribute13),
240: attribute14 = DECODE( p_attribute14, FND_API.g_miss_char, attribute14, p_attribute14),
241: attribute15 = DECODE( p_attribute15, FND_API.g_miss_char, attribute15, p_attribute15)
242:
243: WHERE posting_id = p_posting_id
244: AND object_version_number = p_object_version_number;
237: attribute11 = DECODE( p_attribute11, FND_API.g_miss_char, attribute11, p_attribute11),
238: attribute12 = DECODE( p_attribute12, FND_API.g_miss_char, attribute12, p_attribute12),
239: attribute13 = DECODE( p_attribute13, FND_API.g_miss_char, attribute13, p_attribute13),
240: attribute14 = DECODE( p_attribute14, FND_API.g_miss_char, attribute14, p_attribute14),
241: attribute15 = DECODE( p_attribute15, FND_API.g_miss_char, attribute15, p_attribute15)
242:
243: WHERE posting_id = p_posting_id
244: AND object_version_number = p_object_version_number;
245:
243: WHERE posting_id = p_posting_id
244: AND object_version_number = p_object_version_number;
245:
246: IF (SQL%NOTFOUND) THEN
247: RAISE FND_API.G_EXC_ERROR;
248: END IF;
249:
250:
251: UPDATE ams_iba_ps_postings_tl SET
248: END IF;
249:
250:
251: UPDATE ams_iba_ps_postings_tl SET
252: posting_name = decode( p_posting_name, FND_API.G_MISS_CHAR, posting_name, p_posting_name),
253: display_name = decode( p_display_name, FND_API.G_MISS_CHAR, display_name, p_posting_name),
254: posting_description = decode( p_posting_description, FND_API.G_MISS_CHAR, posting_description, p_posting_description),
255: last_update_date = SYSDATE,
256: last_updated_by = FND_GLOBAL.user_id,
249:
250:
251: UPDATE ams_iba_ps_postings_tl SET
252: posting_name = decode( p_posting_name, FND_API.G_MISS_CHAR, posting_name, p_posting_name),
253: display_name = decode( p_display_name, FND_API.G_MISS_CHAR, display_name, p_posting_name),
254: posting_description = decode( p_posting_description, FND_API.G_MISS_CHAR, posting_description, p_posting_description),
255: last_update_date = SYSDATE,
256: last_updated_by = FND_GLOBAL.user_id,
257: last_update_login = FND_GLOBAL.conc_login_id,
250:
251: UPDATE ams_iba_ps_postings_tl SET
252: posting_name = decode( p_posting_name, FND_API.G_MISS_CHAR, posting_name, p_posting_name),
253: display_name = decode( p_display_name, FND_API.G_MISS_CHAR, display_name, p_posting_name),
254: posting_description = decode( p_posting_description, FND_API.G_MISS_CHAR, posting_description, p_posting_description),
255: last_update_date = SYSDATE,
256: last_updated_by = FND_GLOBAL.user_id,
257: last_update_login = FND_GLOBAL.conc_login_id,
258: source_lang = USERENV('LANG')
259: WHERE posting_id = p_posting_id
260: AND USERENV('LANG') IN (language, source_lang);
261:
262: IF (SQL%NOTFOUND) THEN
263: RAISE FND_API.G_EXC_ERROR;
264: END IF;
265:
266: END Update_Row;
267:
287: BEGIN
288: DELETE FROM AMS_IBA_PS_POSTINGS_B
289: WHERE POSTING_ID = p_POSTING_ID;
290: If (SQL%NOTFOUND) then
291: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
292: End If;
293: END Delete_Row ;
294:
295: