APPS.ASG_APPLY dependencies on ASG_DOWNLOAD

Line 351: l_pk_list asg_download.pk_list;

347: p_curr_pubitem IN VARCHAR2)
348: IS
349: l_inq_table VARCHAR2(60);
350: l_pk_columns VARCHAR2(2000);
351: l_pk_list asg_download.pk_list;
352: l_sql VARCHAR2(1024);
353: l_pk_clause VARCHAR2(1024) := NULL;
354: l_sql_count NUMBER;
355: BEGIN

Line 392: l_pk_list := asg_download.get_listfrom_string(l_pk_columns);

388: SELECT primary_key_column INTO l_pk_columns
389: FROM asg_pub_item
390: WHERE name = p_curr_pubitem;
391:
392: l_pk_list := asg_download.get_listfrom_string(l_pk_columns);
393: FOR curr_index IN 1..l_pk_list.count LOOP
394: IF(curr_index >1) THEN
395: l_pk_clause := l_pk_clause || ' AND ';
396: END IF;