APPS.ASG_APPLY dependencies on ASG_PUB_ITEM

Line 132: -- asg_pub_item table

128: return false;
129: end raise_row_deferred;
130:
131: -- Sort the publication item list by weight stored in
132: -- asg_pub_item table
133: PROCEDURE sort_by_weight(p_pub_name IN VARCHAR2,
134: x_pub_items_tbl IN OUT NOCOPY vc2_tbl_type)
135: IS
136: l_pub_items_tbl vc2_tbl_type;

Line 140: SELECT /*+ index (asg_pub_item, asg_pub_item_n1) */ name

136: l_pub_items_tbl vc2_tbl_type;
137: l_all_pub_items vc2_tbl_type;
138: counter PLS_INTEGER;
139: CURSOR c_pub_items(p_pub_name IN VARCHAR2) IS
140: SELECT /*+ index (asg_pub_item, asg_pub_item_n1) */ name
141: FROM asg_pub_item
142: WHERE pub_name = p_pub_name
143: ORDER BY nvl(table_weight, 0);
144: BEGIN

Line 141: FROM asg_pub_item

137: l_all_pub_items vc2_tbl_type;
138: counter PLS_INTEGER;
139: CURSOR c_pub_items(p_pub_name IN VARCHAR2) IS
140: SELECT /*+ index (asg_pub_item, asg_pub_item_n1) */ name
141: FROM asg_pub_item
142: WHERE pub_name = p_pub_name
143: ORDER BY nvl(table_weight, 0);
144: BEGIN
145:

Line 156: -- Get the ordered list of pub items from the asg_pub_item table

152: FOR curr_index in 1..x_pub_items_tbl.count LOOP
153: l_pub_items_tbl(curr_index) := x_pub_items_tbl(curr_index);
154: END LOOP;
155:
156: -- Get the ordered list of pub items from the asg_pub_item table
157: counter := 1;
158: FOR cpi in c_pub_items(p_pub_name) LOOP
159: l_all_pub_items(counter) := cpi.name;
160: counter := counter +1;

Line 389: FROM asg_pub_item

385:
386: -- OK, all inq records to be processed have the same tranid$$
387: -- We need to update dmltype$$ now
388: SELECT primary_key_column INTO l_pk_columns
389: FROM asg_pub_item
390: WHERE name = p_curr_pubitem;
391:
392: l_pk_list := asg_download.get_listfrom_string(l_pk_columns);
393: FOR curr_index IN 1..l_pk_list.count LOOP

Line 779: ' FROM asg_pub_item ' ||

775: 'WHERE clid$$cs = :1 AND ' ||
776: ' tranid$$ = :2 AND ' ||
777: ' store in ' ||
778: ' (SELECT name ' ||
779: ' FROM asg_pub_item ' ||
780: ' WHERE pub_name = :3) ' ||
781: ' ORDER BY store';
782:
783: l_cursor_id1 := DBMS_SQL.OPEN_CURSOR;

Line 813: ' FROM asg_pub_item ' ||

809: 'WHERE device_user_name = :user_name AND ' ||
810: ' deferred_tran_id = :tranid AND ' ||
811: ' object_name IN ' ||
812: ' (SELECT name ' ||
813: ' FROM asg_pub_item ' ||
814: ' WHERE pub_name = :pubname) AND ' ||
815: ' object_name not in ' ||
816: ' (SELECT store ' ||
817: ' FROM ' || asg_base.G_OLITE_SCHEMA || '.c$inq ' ||

Line 877: ' FROM asg_pub_item ' ||

873: ' WHERE device_user_name = :3 AND ' ||
874: ' deferred_tran_id = :4) AND ' ||
875: ' store in ' ||
876: ' (SELECT name ' ||
877: ' FROM asg_pub_item ' ||
878: ' WHERE pub_name = :5) ' ||
879: ' ORDER BY store';
880:
881: l_cursor_id1 := DBMS_SQL.OPEN_CURSOR;

Line 1736: ' FROM asg_pub ap, asg_pub_item api ' ||

1732: l_delete_inq_sqlstring :=
1733: 'DELETE from ' || asg_base.G_OLITE_SCHEMA || '.c$inq ' ||
1734: 'WHERE store in ' ||
1735: ' (SELECT api.name ' ||
1736: ' FROM asg_pub ap, asg_pub_item api ' ||
1737: ' WHERE ap.custom = ''Y'' AND ' ||
1738: ' ap.name = api.pub_name)';
1739: EXECUTE IMMEDIATE l_delete_inq_sqlstring;
1740: