23:
24: l_multi_plat VARCHAR2(1);
25: begin
26:
27: insert into ASG_PUB_ITEM_INDEX (
28: INDEX_ID,
29: ITEM_ID,
30: INDEX_NAME,
31: ENABLED,
87: begin
88:
89: select a.item_id,a.LAST_RELEASE_VERSION,b.HTML5_OFFLINE
90: into l_item_id,l_last_release_version,l_multi_plat
91: from asg_pub_item_index a, asg_pub_item b
92: where index_id = x_index_id
93: and a.item_id=b.item_id;
94:
95: BEGIN
103: l_custom_flag := 'N';
104: END;
105:
106: IF (l_custom_flag <>'Y') THEN
107: update asg_pub_item_index set
108: INDEX_ID = X_INDEX_ID,
109: ITEM_ID = X_ITEM_ID,
110: INDEX_NAME = X_INDEX_NAME,
111: ENABLED = X_ENABLED,