67: last_update_date,
68: last_update_login,
69: object_version_number
70: ) VALUES (
71: DECODE( px_placement_citem_id, FND_API.g_miss_num, NULL, px_placement_citem_id),
72: DECODE( p_placement_mp_id, FND_API.g_miss_num, NULL, p_placement_mp_id),
73: DECODE( p_content_item_id, FND_API.g_miss_num, NULL, p_content_item_id),
74: DECODE( p_citem_version_id, FND_API.g_miss_num, NULL, p_citem_version_id),
75: DECODE( p_created_by, FND_API.g_miss_num, NULL, p_created_by),
68: last_update_login,
69: object_version_number
70: ) VALUES (
71: DECODE( px_placement_citem_id, FND_API.g_miss_num, NULL, px_placement_citem_id),
72: DECODE( p_placement_mp_id, FND_API.g_miss_num, NULL, p_placement_mp_id),
73: DECODE( p_content_item_id, FND_API.g_miss_num, NULL, p_content_item_id),
74: DECODE( p_citem_version_id, FND_API.g_miss_num, NULL, p_citem_version_id),
75: DECODE( p_created_by, FND_API.g_miss_num, NULL, p_created_by),
76: DECODE( p_creation_date, FND_API.g_miss_date, NULL, p_creation_date),
69: object_version_number
70: ) VALUES (
71: DECODE( px_placement_citem_id, FND_API.g_miss_num, NULL, px_placement_citem_id),
72: DECODE( p_placement_mp_id, FND_API.g_miss_num, NULL, p_placement_mp_id),
73: DECODE( p_content_item_id, FND_API.g_miss_num, NULL, p_content_item_id),
74: DECODE( p_citem_version_id, FND_API.g_miss_num, NULL, p_citem_version_id),
75: DECODE( p_created_by, FND_API.g_miss_num, NULL, p_created_by),
76: DECODE( p_creation_date, FND_API.g_miss_date, NULL, p_creation_date),
77: DECODE( p_last_updated_by, FND_API.g_miss_num, NULL, p_last_updated_by),
70: ) VALUES (
71: DECODE( px_placement_citem_id, FND_API.g_miss_num, NULL, px_placement_citem_id),
72: DECODE( p_placement_mp_id, FND_API.g_miss_num, NULL, p_placement_mp_id),
73: DECODE( p_content_item_id, FND_API.g_miss_num, NULL, p_content_item_id),
74: DECODE( p_citem_version_id, FND_API.g_miss_num, NULL, p_citem_version_id),
75: DECODE( p_created_by, FND_API.g_miss_num, NULL, p_created_by),
76: DECODE( p_creation_date, FND_API.g_miss_date, NULL, p_creation_date),
77: DECODE( p_last_updated_by, FND_API.g_miss_num, NULL, p_last_updated_by),
78: DECODE( p_last_update_date, FND_API.g_miss_date, NULL, p_last_update_date),
71: DECODE( px_placement_citem_id, FND_API.g_miss_num, NULL, px_placement_citem_id),
72: DECODE( p_placement_mp_id, FND_API.g_miss_num, NULL, p_placement_mp_id),
73: DECODE( p_content_item_id, FND_API.g_miss_num, NULL, p_content_item_id),
74: DECODE( p_citem_version_id, FND_API.g_miss_num, NULL, p_citem_version_id),
75: DECODE( p_created_by, FND_API.g_miss_num, NULL, p_created_by),
76: DECODE( p_creation_date, FND_API.g_miss_date, NULL, p_creation_date),
77: DECODE( p_last_updated_by, FND_API.g_miss_num, NULL, p_last_updated_by),
78: DECODE( p_last_update_date, FND_API.g_miss_date, NULL, p_last_update_date),
79: DECODE( p_last_update_login, FND_API.g_miss_num, NULL, p_last_update_login),
72: DECODE( p_placement_mp_id, FND_API.g_miss_num, NULL, p_placement_mp_id),
73: DECODE( p_content_item_id, FND_API.g_miss_num, NULL, p_content_item_id),
74: DECODE( p_citem_version_id, FND_API.g_miss_num, NULL, p_citem_version_id),
75: DECODE( p_created_by, FND_API.g_miss_num, NULL, p_created_by),
76: DECODE( p_creation_date, FND_API.g_miss_date, NULL, p_creation_date),
77: DECODE( p_last_updated_by, FND_API.g_miss_num, NULL, p_last_updated_by),
78: DECODE( p_last_update_date, FND_API.g_miss_date, NULL, p_last_update_date),
79: DECODE( p_last_update_login, FND_API.g_miss_num, NULL, p_last_update_login),
80: DECODE( px_object_version_number, FND_API.g_miss_num, NULL, px_object_version_number));
73: DECODE( p_content_item_id, FND_API.g_miss_num, NULL, p_content_item_id),
74: DECODE( p_citem_version_id, FND_API.g_miss_num, NULL, p_citem_version_id),
75: DECODE( p_created_by, FND_API.g_miss_num, NULL, p_created_by),
76: DECODE( p_creation_date, FND_API.g_miss_date, NULL, p_creation_date),
77: DECODE( p_last_updated_by, FND_API.g_miss_num, NULL, p_last_updated_by),
78: DECODE( p_last_update_date, FND_API.g_miss_date, NULL, p_last_update_date),
79: DECODE( p_last_update_login, FND_API.g_miss_num, NULL, p_last_update_login),
80: DECODE( px_object_version_number, FND_API.g_miss_num, NULL, px_object_version_number));
81:
74: DECODE( p_citem_version_id, FND_API.g_miss_num, NULL, p_citem_version_id),
75: DECODE( p_created_by, FND_API.g_miss_num, NULL, p_created_by),
76: DECODE( p_creation_date, FND_API.g_miss_date, NULL, p_creation_date),
77: DECODE( p_last_updated_by, FND_API.g_miss_num, NULL, p_last_updated_by),
78: DECODE( p_last_update_date, FND_API.g_miss_date, NULL, p_last_update_date),
79: DECODE( p_last_update_login, FND_API.g_miss_num, NULL, p_last_update_login),
80: DECODE( px_object_version_number, FND_API.g_miss_num, NULL, px_object_version_number));
81:
82:
75: DECODE( p_created_by, FND_API.g_miss_num, NULL, p_created_by),
76: DECODE( p_creation_date, FND_API.g_miss_date, NULL, p_creation_date),
77: DECODE( p_last_updated_by, FND_API.g_miss_num, NULL, p_last_updated_by),
78: DECODE( p_last_update_date, FND_API.g_miss_date, NULL, p_last_update_date),
79: DECODE( p_last_update_login, FND_API.g_miss_num, NULL, p_last_update_login),
80: DECODE( px_object_version_number, FND_API.g_miss_num, NULL, px_object_version_number));
81:
82:
83: END Insert_Row;
76: DECODE( p_creation_date, FND_API.g_miss_date, NULL, p_creation_date),
77: DECODE( p_last_updated_by, FND_API.g_miss_num, NULL, p_last_updated_by),
78: DECODE( p_last_update_date, FND_API.g_miss_date, NULL, p_last_update_date),
79: DECODE( p_last_update_login, FND_API.g_miss_num, NULL, p_last_update_login),
80: DECODE( px_object_version_number, FND_API.g_miss_num, NULL, px_object_version_number));
81:
82:
83: END Insert_Row;
84:
116:
117:
118: UPDATE ams_web_plce_citem_assoc
119: SET
120: last_update_date = DECODE( p_last_update_date, FND_API.g_miss_date, last_update_date, p_last_update_date),
121: last_updated_by = DECODE( p_last_updated_by, FND_API.g_miss_num, last_updated_by, p_last_updated_by),
122: last_update_login = DECODE( p_last_update_login, FND_API.g_miss_num, last_update_login, p_last_update_login),
123: placement_mp_id = DECODE( p_placement_mp_id, FND_API.g_miss_num, NULL, p_placement_mp_id),
124: content_item_id = DECODE( p_content_item_id, FND_API.g_miss_num, NULL, p_content_item_id),
117:
118: UPDATE ams_web_plce_citem_assoc
119: SET
120: last_update_date = DECODE( p_last_update_date, FND_API.g_miss_date, last_update_date, p_last_update_date),
121: last_updated_by = DECODE( p_last_updated_by, FND_API.g_miss_num, last_updated_by, p_last_updated_by),
122: last_update_login = DECODE( p_last_update_login, FND_API.g_miss_num, last_update_login, p_last_update_login),
123: placement_mp_id = DECODE( p_placement_mp_id, FND_API.g_miss_num, NULL, p_placement_mp_id),
124: content_item_id = DECODE( p_content_item_id, FND_API.g_miss_num, NULL, p_content_item_id),
125: citem_version_id = DECODE( p_citem_version_id, FND_API.g_miss_num, NULL, p_citem_version_id)
118: UPDATE ams_web_plce_citem_assoc
119: SET
120: last_update_date = DECODE( p_last_update_date, FND_API.g_miss_date, last_update_date, p_last_update_date),
121: last_updated_by = DECODE( p_last_updated_by, FND_API.g_miss_num, last_updated_by, p_last_updated_by),
122: last_update_login = DECODE( p_last_update_login, FND_API.g_miss_num, last_update_login, p_last_update_login),
123: placement_mp_id = DECODE( p_placement_mp_id, FND_API.g_miss_num, NULL, p_placement_mp_id),
124: content_item_id = DECODE( p_content_item_id, FND_API.g_miss_num, NULL, p_content_item_id),
125: citem_version_id = DECODE( p_citem_version_id, FND_API.g_miss_num, NULL, p_citem_version_id)
126: WHERE placement_citem_id = p_placement_citem_id;
119: SET
120: last_update_date = DECODE( p_last_update_date, FND_API.g_miss_date, last_update_date, p_last_update_date),
121: last_updated_by = DECODE( p_last_updated_by, FND_API.g_miss_num, last_updated_by, p_last_updated_by),
122: last_update_login = DECODE( p_last_update_login, FND_API.g_miss_num, last_update_login, p_last_update_login),
123: placement_mp_id = DECODE( p_placement_mp_id, FND_API.g_miss_num, NULL, p_placement_mp_id),
124: content_item_id = DECODE( p_content_item_id, FND_API.g_miss_num, NULL, p_content_item_id),
125: citem_version_id = DECODE( p_citem_version_id, FND_API.g_miss_num, NULL, p_citem_version_id)
126: WHERE placement_citem_id = p_placement_citem_id;
127:
120: last_update_date = DECODE( p_last_update_date, FND_API.g_miss_date, last_update_date, p_last_update_date),
121: last_updated_by = DECODE( p_last_updated_by, FND_API.g_miss_num, last_updated_by, p_last_updated_by),
122: last_update_login = DECODE( p_last_update_login, FND_API.g_miss_num, last_update_login, p_last_update_login),
123: placement_mp_id = DECODE( p_placement_mp_id, FND_API.g_miss_num, NULL, p_placement_mp_id),
124: content_item_id = DECODE( p_content_item_id, FND_API.g_miss_num, NULL, p_content_item_id),
125: citem_version_id = DECODE( p_citem_version_id, FND_API.g_miss_num, NULL, p_citem_version_id)
126: WHERE placement_citem_id = p_placement_citem_id;
127:
128: IF (SQL%NOTFOUND) THEN
121: last_updated_by = DECODE( p_last_updated_by, FND_API.g_miss_num, last_updated_by, p_last_updated_by),
122: last_update_login = DECODE( p_last_update_login, FND_API.g_miss_num, last_update_login, p_last_update_login),
123: placement_mp_id = DECODE( p_placement_mp_id, FND_API.g_miss_num, NULL, p_placement_mp_id),
124: content_item_id = DECODE( p_content_item_id, FND_API.g_miss_num, NULL, p_content_item_id),
125: citem_version_id = DECODE( p_citem_version_id, FND_API.g_miss_num, NULL, p_citem_version_id)
126: WHERE placement_citem_id = p_placement_citem_id;
127:
128: IF (SQL%NOTFOUND) THEN
129: RAISE no_data_found;