APPS.OPI_DBI_JOBS_PKG dependencies on OPI_DBI_RUN_LOG_CURR

Line 608: l_from_date OPI.OPI_DBI_RUN_LOG_CURR.FROM_BOUND_DATE%TYPE;

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
612: select

Line 609: l_to_date OPI.OPI_DBI_RUN_LOG_CURR.FROM_BOUND_DATE%TYPE;

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
612: select
613: from_bound_date,

Line 611: CURSOR OPI_DBI_RUN_LOG_CURR_CSR IS

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
612: select
613: from_bound_date,
614: to_bound_date
615: from

Line 616: OPI_DBI_RUN_LOG_CURR

612: select
613: from_bound_date,
614: to_bound_date
615: from
616: OPI_DBI_RUN_LOG_CURR
617: where
618: ETL_ID = 4 and
619: source = 2;
620:

Line 706: OPEN OPI_DBI_RUN_LOG_CURR_CSR;

702: -- RAISE_APPLICATION_ERROR(-20000, errbuf);
703: --END IF;
704:
705: l_stmt_num :=15;
706: OPEN OPI_DBI_RUN_LOG_CURR_CSR;
707: FETCH OPI_DBI_RUN_LOG_CURR_CSR INTO l_from_date,l_to_date;
708:
709: l_stmt_num :=16;
710: IF (OPI_DBI_RUN_LOG_CURR_CSR%NOTFOUND) THEN

Line 707: FETCH OPI_DBI_RUN_LOG_CURR_CSR INTO l_from_date,l_to_date;

703: --END IF;
704:
705: l_stmt_num :=15;
706: OPEN OPI_DBI_RUN_LOG_CURR_CSR;
707: FETCH OPI_DBI_RUN_LOG_CURR_CSR INTO l_from_date,l_to_date;
708:
709: l_stmt_num :=16;
710: IF (OPI_DBI_RUN_LOG_CURR_CSR%NOTFOUND) THEN
711: --{

Line 710: IF (OPI_DBI_RUN_LOG_CURR_CSR%NOTFOUND) THEN

706: OPEN OPI_DBI_RUN_LOG_CURR_CSR;
707: FETCH OPI_DBI_RUN_LOG_CURR_CSR INTO l_from_date,l_to_date;
708:
709: l_stmt_num :=16;
710: IF (OPI_DBI_RUN_LOG_CURR_CSR%NOTFOUND) THEN
711: --{
712: RAISE NO_DATA_FOUND;
713: --}
714: END IF;

Line 715: CLOSE OPI_DBI_RUN_LOG_CURR_CSR;

711: --{
712: RAISE NO_DATA_FOUND;
713: --}
714: END IF;
715: CLOSE OPI_DBI_RUN_LOG_CURR_CSR;
716:
717: l_stmt_num := 17;
718: -- get R12 upgrade date
719: OPI_DBI_RPT_UTIL_PKG.get_inv_convergence_date(g_r12_migration_date);

Line 1079: l_from_date OPI.OPI_DBI_RUN_LOG_CURR.FROM_BOUND_DATE%TYPE;

1075: l_row_count NUMBER;
1076: l_err_num NUMBER;
1077: l_err_msg VARCHAR2(255);
1078:
1079: l_from_date OPI.OPI_DBI_RUN_LOG_CURR.FROM_BOUND_DATE%TYPE;
1080: l_to_date OPI.OPI_DBI_RUN_LOG_CURR.FROM_BOUND_DATE%TYPE;
1081:
1082: CURSOR OPI_DBI_RUN_LOG_CURR_CSR IS
1083: select

Line 1080: l_to_date OPI.OPI_DBI_RUN_LOG_CURR.FROM_BOUND_DATE%TYPE;

1076: l_err_num NUMBER;
1077: l_err_msg VARCHAR2(255);
1078:
1079: l_from_date OPI.OPI_DBI_RUN_LOG_CURR.FROM_BOUND_DATE%TYPE;
1080: l_to_date OPI.OPI_DBI_RUN_LOG_CURR.FROM_BOUND_DATE%TYPE;
1081:
1082: CURSOR OPI_DBI_RUN_LOG_CURR_CSR IS
1083: select
1084: from_bound_date,

Line 1082: CURSOR OPI_DBI_RUN_LOG_CURR_CSR IS

1078:
1079: l_from_date OPI.OPI_DBI_RUN_LOG_CURR.FROM_BOUND_DATE%TYPE;
1080: l_to_date OPI.OPI_DBI_RUN_LOG_CURR.FROM_BOUND_DATE%TYPE;
1081:
1082: CURSOR OPI_DBI_RUN_LOG_CURR_CSR IS
1083: select
1084: from_bound_date,
1085: to_bound_date
1086: from

Line 1087: OPI_DBI_RUN_LOG_CURR

1083: select
1084: from_bound_date,
1085: to_bound_date
1086: from
1087: OPI_DBI_RUN_LOG_CURR
1088: where
1089: ETL_ID = 4 and
1090: source = 2;
1091:

Line 1104: OPEN OPI_DBI_RUN_LOG_CURR_CSR;

1100: g_program_application_id := nvl (fnd_global.prog_appl_id, -1);
1101: g_request_id := nvl (fnd_global.conc_request_id, -1);
1102:
1103: l_stmt_num :=3;
1104: OPEN OPI_DBI_RUN_LOG_CURR_CSR;
1105: FETCH OPI_DBI_RUN_LOG_CURR_CSR INTO l_from_date,l_to_date;
1106:
1107: l_stmt_num :=7;
1108: IF (OPI_DBI_RUN_LOG_CURR_CSR%NOTFOUND) THEN

Line 1105: FETCH OPI_DBI_RUN_LOG_CURR_CSR INTO l_from_date,l_to_date;

1101: g_request_id := nvl (fnd_global.conc_request_id, -1);
1102:
1103: l_stmt_num :=3;
1104: OPEN OPI_DBI_RUN_LOG_CURR_CSR;
1105: FETCH OPI_DBI_RUN_LOG_CURR_CSR INTO l_from_date,l_to_date;
1106:
1107: l_stmt_num :=7;
1108: IF (OPI_DBI_RUN_LOG_CURR_CSR%NOTFOUND) THEN
1109: --{

Line 1108: IF (OPI_DBI_RUN_LOG_CURR_CSR%NOTFOUND) THEN

1104: OPEN OPI_DBI_RUN_LOG_CURR_CSR;
1105: FETCH OPI_DBI_RUN_LOG_CURR_CSR INTO l_from_date,l_to_date;
1106:
1107: l_stmt_num :=7;
1108: IF (OPI_DBI_RUN_LOG_CURR_CSR%NOTFOUND) THEN
1109: --{
1110: RAISE NO_DATA_FOUND;
1111: --}
1112: END IF;

Line 1113: CLOSE OPI_DBI_RUN_LOG_CURR_CSR;

1109: --{
1110: RAISE NO_DATA_FOUND;
1111: --}
1112: END IF;
1113: CLOSE OPI_DBI_RUN_LOG_CURR_CSR;
1114:
1115: /* Insert into Jobs Staging Table */
1116:
1117: l_stmt_num := 10;

Line 1306: l_from_date OPI.OPI_DBI_RUN_LOG_CURR.FROM_BOUND_DATE%TYPE;

1302: l_row_count NUMBER;
1303: l_err_num NUMBER;
1304: l_err_msg VARCHAR2(255);
1305:
1306: l_from_date OPI.OPI_DBI_RUN_LOG_CURR.FROM_BOUND_DATE%TYPE;
1307: l_to_date OPI.OPI_DBI_RUN_LOG_CURR.FROM_BOUND_DATE%TYPE;
1308:
1309: CURSOR OPI_DBI_RUN_LOG_CURR_CSR IS
1310: select

Line 1307: l_to_date OPI.OPI_DBI_RUN_LOG_CURR.FROM_BOUND_DATE%TYPE;

1303: l_err_num NUMBER;
1304: l_err_msg VARCHAR2(255);
1305:
1306: l_from_date OPI.OPI_DBI_RUN_LOG_CURR.FROM_BOUND_DATE%TYPE;
1307: l_to_date OPI.OPI_DBI_RUN_LOG_CURR.FROM_BOUND_DATE%TYPE;
1308:
1309: CURSOR OPI_DBI_RUN_LOG_CURR_CSR IS
1310: select
1311: from_bound_date,

Line 1309: CURSOR OPI_DBI_RUN_LOG_CURR_CSR IS

1305:
1306: l_from_date OPI.OPI_DBI_RUN_LOG_CURR.FROM_BOUND_DATE%TYPE;
1307: l_to_date OPI.OPI_DBI_RUN_LOG_CURR.FROM_BOUND_DATE%TYPE;
1308:
1309: CURSOR OPI_DBI_RUN_LOG_CURR_CSR IS
1310: select
1311: from_bound_date,
1312: to_bound_date
1313: from

Line 1314: OPI_DBI_RUN_LOG_CURR

1310: select
1311: from_bound_date,
1312: to_bound_date
1313: from
1314: OPI_DBI_RUN_LOG_CURR
1315: where
1316: ETL_ID = 4 and
1317: source = 2;
1318:

Line 1322: OPEN OPI_DBI_RUN_LOG_CURR_CSR;

1318:
1319: BEGIN
1320:
1321: l_stmt_num :=3;
1322: OPEN OPI_DBI_RUN_LOG_CURR_CSR;
1323: FETCH OPI_DBI_RUN_LOG_CURR_CSR INTO l_from_date,l_to_date;
1324:
1325: l_stmt_num :=7;
1326: IF (OPI_DBI_RUN_LOG_CURR_CSR%NOTFOUND) THEN

Line 1323: FETCH OPI_DBI_RUN_LOG_CURR_CSR INTO l_from_date,l_to_date;

1319: BEGIN
1320:
1321: l_stmt_num :=3;
1322: OPEN OPI_DBI_RUN_LOG_CURR_CSR;
1323: FETCH OPI_DBI_RUN_LOG_CURR_CSR INTO l_from_date,l_to_date;
1324:
1325: l_stmt_num :=7;
1326: IF (OPI_DBI_RUN_LOG_CURR_CSR%NOTFOUND) THEN
1327: --{

Line 1326: IF (OPI_DBI_RUN_LOG_CURR_CSR%NOTFOUND) THEN

1322: OPEN OPI_DBI_RUN_LOG_CURR_CSR;
1323: FETCH OPI_DBI_RUN_LOG_CURR_CSR INTO l_from_date,l_to_date;
1324:
1325: l_stmt_num :=7;
1326: IF (OPI_DBI_RUN_LOG_CURR_CSR%NOTFOUND) THEN
1327: --{
1328: RAISE NO_DATA_FOUND;
1329: --}
1330: END IF;

Line 1331: CLOSE OPI_DBI_RUN_LOG_CURR_CSR;

1327: --{
1328: RAISE NO_DATA_FOUND;
1329: --}
1330: END IF;
1331: CLOSE OPI_DBI_RUN_LOG_CURR_CSR;
1332:
1333: l_stmt_num := 10;
1334:
1335: MERGE INTO OPI_DBI_JOBS_STG f USING

Line 1523: SELECT LAST_COLLECTION_DATE INTO g_last_collection_date FROM OPI_DBI_RUN_LOG_CURR

1519: END IF;
1520:
1521: l_stmt_num := 20;
1522: BEGIN
1523: SELECT LAST_COLLECTION_DATE INTO g_last_collection_date FROM OPI_DBI_RUN_LOG_CURR
1524: WHERE ETL_ID = 4 AND SOURCE = 1;
1525: EXCEPTION
1526: WHEN NO_DATA_FOUND THEN
1527: BIS_COLLECTION_UTILITIES.put_line('Last collection date is not available. Cannot proceed.');

Line 1558: SELECT LAST_COLLECTION_DATE INTO g_opm_last_collection_date FROM OPI_DBI_RUN_LOG_CURR

1554:
1555: l_stmt_num := 45;
1556:
1557: BEGIN
1558: SELECT LAST_COLLECTION_DATE INTO g_opm_last_collection_date FROM OPI_DBI_RUN_LOG_CURR
1559: WHERE ETL_ID = 4 AND SOURCE = 2;
1560: EXCEPTION
1561: WHEN NO_DATA_FOUND THEN
1562: BIS_COLLECTION_UTILITIES.put_line('Process Manufacturing Last collection date is not available. Cannot proceed.');