DBA Data[Home] [Help]

APPS.OPI_DBI_JOBS_PKG dependencies on DBMS_SQL

Line 607: l_list dbms_sql.varchar2_table;

603: l_proc_name VARCHAR2(255);
604: l_opi_schema VARCHAR2(30);
605: l_status VARCHAR2(30);
606: l_industry VARCHAR2(30);
607: l_list dbms_sql.varchar2_table;
608: l_from_date OPI.OPI_DBI_RUN_LOG_CURR.FROM_BOUND_DATE%TYPE;
609: l_to_date OPI.OPI_DBI_RUN_LOG_CURR.FROM_BOUND_DATE%TYPE;
610:
611: CURSOR OPI_DBI_RUN_LOG_CURR_CSR IS

Line 1469: l_list dbms_sql.varchar2_table;

1465: l_proc_name VARCHAR2(255);
1466: l_opi_schema VARCHAR2(30);
1467: l_status VARCHAR2(30);
1468: l_industry VARCHAR2(30);
1469: l_list dbms_sql.varchar2_table;
1470: BEGIN
1471:
1472: l_proc_name := 'OPI_DBI_JOBS_PKG.GET_JOBS_INCR_LOAD';
1473: BIS_COLLECTION_UTILITIES.PUT_LINE('Entering Procedure '|| l_proc_name);