[Home] [Help]
44: -- 1. The required input is as follows:
45: -- content_type_code
46: -- default_display_template_id
47: -- deliverable_id
48: -- association_type_code (to be recorded in ibc_associations table)
49: -- 2. This procedure returns the Content Item ID of the newly created
50: -- Content Item associated with the given deliverable.
51: --
52: -- HISTORY
148: --
149: -- This procedure will create a new Content Item in IBC Schema.
150: -- It will record the Default Display Template ID as the value of one special Attribute
151: -- of the same Content Item.
152: -- It will also create a record in IBC_ASSOCIATIONS table to associate the Deliverable
153: -- and the newly created Content Item.
154: --
155: -- Fetch the Deliverable Details.
156:
227: END IF;
228:
229: l_init_msg_list := FND_API.g_false ; -- This point onwards, we should not initialize the message list.
230:
231: -- If the above statement is successful, add the association record in IBC_ASSOCIATIONS.
232: --
233: -- Prepare the data for insert.
234:
235: l_assoc_type_codes.extend();
385: -- 1. The required input is as follows:
386: -- content_type_code
387: -- deliverable_id
388: -- content_item_id
389: -- association_type_code (this is recorded in ibc_associations table)
390: -- 2. This procedure returns the success or failure status
391: --
392: -- COMMENTS added on May 06, 2002.
393: /*
3774: -- content_type_code
3775: -- default_display_template_id
3776: -- deliverable_id
3777: -- content_item_id
3778: -- association_type_code (this is recorded in ibc_associations table)
3779: -- 2. This procedure returns the success or failure status
3780: --
3781: -----------------------------------------------------------------------
3782: PROCEDURE update_citem_for_delv(
3924: AMS_Utility_PVT.Error_Message('AMS_ERR_UPDATE_CITEM');
3925: RAISE FND_API.g_exc_error;
3926: END IF;
3927:
3928: --Change the value of default_display_template in IBC_ASSOCIATIONS table.
3929:
3930: UPDATE ibc_associations
3931: SET associated_object_val3 = p_def_disp_template_id
3932: WHERE content_item_id = p_citem_id
3926: END IF;
3927:
3928: --Change the value of default_display_template in IBC_ASSOCIATIONS table.
3929:
3930: UPDATE ibc_associations
3931: SET associated_object_val3 = p_def_disp_template_id
3932: WHERE content_item_id = p_citem_id
3933: AND associated_object_val1 = TO_CHAR(p_delv_id)
3934: AND association_type_code = G_CPAGE_ASSOC_TYPE_CODE;