APPS.ASG_DEFER dependencies on ASG_PUB

Line 627: l_pub_handler asg_pub.wrapper_name%type;

623: p_commit_flag IN BOOLEAN)
624: IS
625: counter PLS_INTEGER;
626: sql_string VARCHAR2(4000);
627: l_pub_handler asg_pub.wrapper_name%type;
628: l_pubname VARCHAR2(30);
629: l_pubitems_tbl asg_apply.vc2_tbl_type;
630: l_def_trans VARCHAR2(1);
631: l_return_status VARCHAR2(1);

Line 643: FROM asg_pub a, asg_pub_item b, asg_deferred_traninfo c

639: l_orig_resp_id NUMBER;
640: l_orig_app_id NUMBER;
641: CURSOR c_pub_wrapper(p_user_name VARCHAR2, p_tranid NUMBER) IS
642: SELECT distinct a.wrapper_name, a.name
643: FROM asg_pub a, asg_pub_item b, asg_deferred_traninfo c
644: WHERE device_user_name = p_user_name AND
645: deferred_tran_id = p_tranid AND
646: c.object_name = b.name AND
647: b.pub_name = a.name

Line 845: asg_pub_item pub

841: CURSOR c_deferred_lines
842: IS
843: select distinct def.object_name,pub.enabled
844: from asg_deferred_traninfo def,
845: asg_pub_item pub
846: where pub.item_id = def.object_name;
847:
848: l_sql VARCHAR2(512);
849: l_row_count NUMBER;