APPS.ASG_HELPER dependencies on ASG_PUB_ITEM

Line 390: ( SELECT item_id FROM asg_pub_item

386:
387: DELETE FROM asg_complete_refresh
388: WHERE user_name = p_user_name AND
389: publication_item IN
390: ( SELECT item_id FROM asg_pub_item
391: WHERE pub_name = p_pub_name);
392:
393: COMMIT;
394: IF(check_is_log_enabled(g_stmt_level))

Line 658: ' FROM asg_pub_item api, ' ||

654: ' aup.pub_name = ap.name AND ' ||
655: ' aup.synch_disabled = ''Y'' AND ' ||
656: ' ap.name in ' ||
657: ' (SELECT distinct pub_name ' ||
658: ' FROM asg_pub_item api, ' ||
659: asg_base.G_OLITE_SCHEMA || '.c$pub_list_q cpq ' ||
660: ' where api.name = cpq.name)';
661:
662: EXECUTE IMMEDIATE l_query_string

Line 683: ' FROM asg_pub_item api, ' ||

679: ' aup.pub_name = ap.name AND ' ||
680: ' ap.enable_synch = ''N'' AND ' ||
681: ' ap.name in ' ||
682: ' (SELECT distinct pub_name ' ||
683: ' FROM asg_pub_item api, ' ||
684: asg_base.G_OLITE_SCHEMA || '.c$pub_list_q cpq ' ||
685: ' where api.name = cpq.name)';
686:
687: EXECUTE IMMEDIATE l_query_string

Line 707: FROM asg_user_pub_resps aup, asg_pub_item api

703: PROCEDURE set_complete_refresh(p_pub_item VARCHAR2)
704: IS
705: CURSOR c_all_users(pi_name VARCHAR2) IS
706: SELECT user_name
707: FROM asg_user_pub_resps aup, asg_pub_item api
708: WHERE api.name = upper(pi_name) AND
709: api.pub_name = aup.pub_name;
710: CURSOR c_row_exists(pi_name VARCHAR2) IS
711: SELECT count(*)

Line 716: FROM asg_user_pub_resps aup, asg_pub_item api

712: FROM asg_complete_refresh
713: WHERE publication_item=pi_name;
714: CURSOR c_new_users(pi_name VARCHAR2) IS
715: SELECT user_name
716: FROM asg_user_pub_resps aup, asg_pub_item api
717: WHERE api.name = upper(pi_name) AND
718: aup.pub_name = api.pub_name AND
719: user_name NOT IN
720: ( SELECT user_name

Line 1479: FROM asg_pub_item

1475: IS
1476: CURSOR c_inq_outq_objects
1477: IS
1478: SELECT base_object_name, inq_name
1479: FROM asg_pub_item
1480: WHERE enabled = 'Y';
1481: l_olite_schema VARCHAR2(30);
1482: l_sql_string VARCHAR2(4096);
1483: BEGIN