APPS.ASG_DEFER dependencies on ASG_BASE

Line 264: sql_string := 'DELETE FROM '|| asg_base.G_OLITE_SCHEMA ||

260: ' WHERE clid$$cs = :1 AND ' ||' tranid$$ = :2 AND ' ||' seqno$$ = :3';
261: ELSE
262:
263: inq_tbl_name := 'CFM$' || p_pubitem;
264: sql_string := 'DELETE FROM '|| asg_base.G_OLITE_SCHEMA ||
265: '.' || inq_tbl_name ||
266: ' WHERE clid$$cs = :1 AND ' ||
267: ' tranid$$ =:2';
268: END IF;

Line 335: sql_string := 'DELETE FROM ' || asg_base.G_OLITE_SCHEMA ||

331: sql_string := 'DELETE FROM '|| csm_util_pkg.get_inq_tab(p_pubitem) ||
332: ' WHERE clid$$cs = :1 AND ' ||' tranid$$ = :2 AND ' ||' seqno$$ = :3';
333: ELSE
334: inq_tbl_name := 'CFM$' || p_pubitem;
335: sql_string := 'DELETE FROM ' || asg_base.G_OLITE_SCHEMA ||
336: '.' || inq_tbl_name ||
337: ' WHERE clid$$cs = :1 AND ' ||
338: ' tranid$$ = :2 AND ' ||
339: ' seqno$$ = :3';

Line 867: l_inq_table_name := asg_base.G_OLITE_SCHEMA || '.CFM$' || cdl.object_name;

863: 'asg_defer',g_stmt_level);
864: END IF;
865: IF cdl.enabled = 'Y' THEN
866:
867: l_inq_table_name := asg_base.G_OLITE_SCHEMA || '.CFM$' || cdl.object_name;
868: l_sql := 'DELETE FROM asg_deferred_traninfo ' ||
869: 'WHERE object_name = :1 AND ' ||
870: '(device_user_name, deferred_tran_id, sequence) NOT IN ' ||
871: ' (SELECT clid$$cs, tranid$$, seqno$$ ' ||