APPS.ASG_CUSTOM_PVT dependencies on ASG_PUB

Line 140: from asg_pub

136: -- check if the pub item is ready to custom
137: -- ****************
138: select nvl(custom, 'N')
139: into l_custom_flag
140: from asg_pub
141: where pub_id = ( select pub_name from asg_pub_item
142: where item_id = p_pub_item_name);
143: if (l_custom_flag <> 'Y')
144: then

Line 141: where pub_id = ( select pub_name from asg_pub_item

137: -- ****************
138: select nvl(custom, 'N')
139: into l_custom_flag
140: from asg_pub
141: where pub_id = ( select pub_name from asg_pub_item
142: where item_id = p_pub_item_name);
143: if (l_custom_flag <> 'Y')
144: then
145: -- the custom flag is not Y

Line 171: from asg_pub_item

167:
168:
169: select base_object_name ,primary_key_column, access_name, parent_table
170: into l_piv_name, l_pk_columns, l_acc_table_name,l_parent_table
171: from asg_pub_item
172: where item_id = p_pub_item_name;
173:
174: l_pk_num := find_num_pkcols(l_pk_columns);
175: l_col_num := find_num_pkcols(p_data_columns);

Line 318: -- update asg_pub_item

314: x_return_status := exec_cmd (l_new_query);
315: log ('Recreated the PIV view .');
316:
317: -- **************
318: -- update asg_pub_item
319: -- **************
320: log('update the asg_pub_item table.');
321: update asg_pub_item
322: set parent_table = p_base_table_name,

Line 320: log('update the asg_pub_item table.');

316:
317: -- **************
318: -- update asg_pub_item
319: -- **************
320: log('update the asg_pub_item table.');
321: update asg_pub_item
322: set parent_table = p_base_table_name,
323: last_update_date = sysdate
324: where item_id = P_pub_item_name;

Line 321: update asg_pub_item

317: -- **************
318: -- update asg_pub_item
319: -- **************
320: log('update the asg_pub_item table.');
321: update asg_pub_item
322: set parent_table = p_base_table_name,
323: last_update_date = sysdate
324: where item_id = P_pub_item_name;
325: commit;