APPS.ASG_HELPER dependencies on ASG_PUB_ITEM

Line 371: ( SELECT item_id FROM asg_pub_item

367:
368: DELETE FROM asg_complete_refresh
369: WHERE user_name = p_user_name AND
370: publication_item IN
371: ( SELECT item_id FROM asg_pub_item
372: WHERE pub_name = p_pub_name);
373:
374: COMMIT;
375: IF(check_is_log_enabled(g_stmt_level))

Line 639: ' FROM asg_pub_item api, ' ||

635: ' aup.pub_name = ap.name AND ' ||
636: ' aup.synch_disabled = ''Y'' AND ' ||
637: ' ap.name in ' ||
638: ' (SELECT distinct pub_name ' ||
639: ' FROM asg_pub_item api, ' ||
640: asg_base.G_OLITE_SCHEMA || '.c$pub_list_q cpq ' ||
641: ' where api.name = cpq.name)';
642:
643: EXECUTE IMMEDIATE l_query_string

Line 664: ' FROM asg_pub_item api, ' ||

660: ' aup.pub_name = ap.name AND ' ||
661: ' ap.enable_synch = ''N'' AND ' ||
662: ' ap.name in ' ||
663: ' (SELECT distinct pub_name ' ||
664: ' FROM asg_pub_item api, ' ||
665: asg_base.G_OLITE_SCHEMA || '.c$pub_list_q cpq ' ||
666: ' where api.name = cpq.name)';
667:
668: EXECUTE IMMEDIATE l_query_string

Line 688: FROM asg_user_pub_resps aup, asg_pub_item api

684: PROCEDURE set_complete_refresh(p_pub_item VARCHAR2)
685: IS
686: CURSOR c_all_users(pi_name VARCHAR2) IS
687: SELECT user_name
688: FROM asg_user_pub_resps aup, asg_pub_item api
689: WHERE api.name = upper(pi_name) AND
690: api.pub_name = aup.pub_name;
691: CURSOR c_row_exists(pi_name VARCHAR2) IS
692: SELECT count(*)

Line 697: FROM asg_user_pub_resps aup, asg_pub_item api

693: FROM asg_complete_refresh
694: WHERE publication_item=pi_name;
695: CURSOR c_new_users(pi_name VARCHAR2) IS
696: SELECT user_name
697: FROM asg_user_pub_resps aup, asg_pub_item api
698: WHERE api.name = upper(pi_name) AND
699: aup.pub_name = api.pub_name AND
700: user_name NOT IN
701: ( SELECT user_name

Line 1416: FROM asg_pub_item

1412: IS
1413: CURSOR c_inq_outq_objects
1414: IS
1415: SELECT base_object_name, inq_name
1416: FROM asg_pub_item
1417: WHERE enabled = 'Y';
1418: l_olite_schema VARCHAR2(30);
1419: l_sql_string VARCHAR2(4096);
1420: BEGIN