APPS.ASG_APPLY dependencies on ASG_DOWNLOAD

Line 355: l_pk_list asg_download.pk_list;

351: p_curr_pubitem IN VARCHAR2)
352: IS
353: l_inq_table VARCHAR2(60);
354: l_pk_columns VARCHAR2(2000);
355: l_pk_list asg_download.pk_list;
356: l_sql VARCHAR2(1024);
357: l_pk_clause VARCHAR2(1024) := NULL;
358: l_sql_count NUMBER;
359: BEGIN

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

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