APPS.ASG_ITEM_INDEX_PKG dependencies on ASG_PUB_ITEM

Line 26: insert into ASG_PUB_ITEM_INDEX (

22:
23:
24: begin
25:
26: insert into ASG_PUB_ITEM_INDEX (
27: INDEX_ID,
28: ITEM_ID,
29: INDEX_NAME,
30: ENABLED,

Line 80: from asg_pub_item_index

76:
77: begin
78:
79: select item_id into l_item_id
80: from asg_pub_item_index
81: where index_id = x_index_id;
82:
83: BEGIN
84: select nvl(p.custom,'N')

Line 86: from asg_pub p, asg_pub_item i

82:
83: BEGIN
84: select nvl(p.custom,'N')
85: into l_custom_flag
86: from asg_pub p, asg_pub_item i
87: where p.pub_id = i.pub_name
88: and i.item_id = l_ITEM_ID;
89: EXCEPTION
90: when no_data_found then

Line 95: update asg_pub_item_index set

91: l_custom_flag := 'N';
92: END;
93:
94: IF (l_custom_flag <>'Y') THEN
95: update asg_pub_item_index set
96: INDEX_ID = X_INDEX_ID,
97: ITEM_ID = X_ITEM_ID,
98: INDEX_NAME = X_INDEX_NAME,
99: ENABLED = X_ENABLED,