APPS.ASG_DEFER dependencies on ASG_BASE

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

247: BEGIN
248:
249: x_return_status := FND_API.G_RET_STS_SUCCESS;
250: inq_tbl_name := 'CFM$' || p_pubitem;
251: sql_string := 'DELETE FROM '|| asg_base.G_OLITE_SCHEMA ||
252: '.' || inq_tbl_name ||
253: ' WHERE clid$$cs = :1 AND ' ||
254: ' tranid$$ =:2';
255: IF(asg_helper.check_is_log_enabled(g_stmt_level))

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

313: BEGIN
314:
315: x_return_status := FND_API.G_RET_STS_SUCCESS;
316: inq_tbl_name := 'CFM$' || p_pubitem;
317: sql_string := 'DELETE FROM ' || asg_base.G_OLITE_SCHEMA ||
318: '.' || inq_tbl_name ||
319: ' WHERE clid$$cs = :1 AND ' ||
320: ' tranid$$ = :2 AND ' ||
321: ' seqno$$ = :3';

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

827: asg_helper.log('delete_deferred: Processing object: ' || cdl.object_name,
828: 'asg_defer',g_stmt_level);
829: END IF;
830:
831: l_inq_table_name := asg_base.G_OLITE_SCHEMA || '.CFM$' || cdl.object_name;
832: l_sql := 'DELETE FROM asg_deferred_traninfo ' ||
833: 'WHERE object_name = :1 AND ' ||
834: '(device_user_name, deferred_tran_id, sequence) NOT IN ' ||
835: ' (SELECT clid$$cs, tranid$$, seqno$$ ' ||