APPS.ASG_CUSTOM_PVT dependencies on ASG_PUB_ITEM

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 294: -- update asg_pub_item

290: x_return_status := exec_cmd (l_new_query);
291: log ('Recreated the PIV view .');
292:
293: -- **************
294: -- update asg_pub_item
295: -- **************
296: log('update the asg_pub_item table.');
297: update asg_pub_item
298: set parent_table = p_base_table_name,

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

292:
293: -- **************
294: -- update asg_pub_item
295: -- **************
296: log('update the asg_pub_item table.');
297: update asg_pub_item
298: set parent_table = p_base_table_name,
299: last_update_date = sysdate
300: where item_id = P_pub_item_name;

Line 297: update asg_pub_item

293: -- **************
294: -- update asg_pub_item
295: -- **************
296: log('update the asg_pub_item table.');
297: update asg_pub_item
298: set parent_table = p_base_table_name,
299: last_update_date = sysdate
300: where item_id = P_pub_item_name;
301: commit;