APPS.ASG_ITEM_INDEX_PKG dependencies on ASG_PUB

Line 27: insert into ASG_PUB_ITEM_INDEX (

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,

Line 59: SELECT 'Y' INTO l_multi_plat FROM ASG_PUB_ITEM WHERE ITEM_ID=x_ITEM_ID AND HTML5_OFFLINE='Y';

55: decode(X_LAST_UPDATED_BY,FND_API.G_MISS_NUM, NULL,x_last_updated_by)
56: );
57:
58: BEGIN
59: SELECT 'Y' INTO l_multi_plat FROM ASG_PUB_ITEM WHERE ITEM_ID=x_ITEM_ID AND HTML5_OFFLINE='Y';
60: EXECUTE IMMEDIATE 'BEGIN csm_html5_pkg.set_indx_ref(:1); END;' USING X_INDEX_ID;
61: EXCEPTION
62: When Others then
63: NULL;

Line 91: from asg_pub_item_index a, asg_pub_item b

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

Line 98: from asg_pub p, asg_pub_item i

94:
95: BEGIN
96: select nvl(p.custom,'N')
97: into l_custom_flag
98: from asg_pub p, asg_pub_item i
99: where p.pub_id = i.pub_name
100: and i.item_id = l_ITEM_ID;
101: EXCEPTION
102: when no_data_found then

Line 107: update asg_pub_item_index set

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,