APPS.OPI_DBI_BOUNDS_PKG dependencies on DUAL

Line 576: select BIS_COMMON_PARAMETERS.GET_GLOBAL_START_DATE into l_global_start_date from DUAL;

572: l_program_application_id := NVL(fnd_global.PROG_APPL_ID,-1);
573: l_request_id := NVL(fnd_global.CONC_REQUEST_ID,-1);
574:
575: l_stmt_no :=10;
576: select BIS_COMMON_PARAMETERS.GET_GLOBAL_START_DATE into l_global_start_date from DUAL;
577:
578: if (l_global_start_date is NULL) then
579: RAISE INITIALIZATION_ERROR ;
580: end if;

Line 1072: select BIS_COMMON_PARAMETERS.GET_GLOBAL_START_DATE into l_global_start_date from DUAL;

1068: l_request_id := NVL(fnd_global.CONC_REQUEST_ID,-1);
1069:
1070:
1071: l_stmt_no := 10;
1072: select BIS_COMMON_PARAMETERS.GET_GLOBAL_START_DATE into l_global_start_date from DUAL;
1073:
1074: if (l_global_start_date is NULL) then
1075: RAISE INITIALIZATION_ERROR ;
1076: end if;

Line 1217: select BIS_COMMON_PARAMETERS.GET_GLOBAL_START_DATE into l_global_start_date from DUAL;

1213: l_program_application_id := NVL(fnd_global.PROG_APPL_ID,-1);
1214: l_request_id := NVL(fnd_global.CONC_REQUEST_ID,-1);
1215:
1216: l_stmt_no :=10;
1217: select BIS_COMMON_PARAMETERS.GET_GLOBAL_START_DATE into l_global_start_date from DUAL;
1218:
1219: if (l_global_start_date is NULL) then
1220: RAISE INITIALIZATION_ERROR ;
1221: end if;

Line 1271: FROM DUAL ;

1267: l_program_id ,
1268: l_program_login_id ,
1269: l_program_application_id,
1270: l_request_id
1271: FROM DUAL ;
1272: IF l_debug_mode = 'Y' AND upper(l_module_name) like 'BIS%' THEN
1273: l_debug_msg := 'Inserted '||to_char(sql%rowcount)||' rows into OPI_DBI_CONC_PROG_RUN_LOG' ;
1274: opi_dbi_bounds_pkg.write(g_pkg_name, l_proc_name, l_stmt_no, l_debug_msg);
1275: END IF;

Line 1370: select p_pkg_name, p_proc_name, p_stmt_no, p_debug_msg from dual;

1366: -- l_module_name := FND_PROFILE.value('AFLOG_MODULE');
1367:
1368: /*
1369: insert into mano_log (pkg, proc_name, stmt_no, msg )
1370: select p_pkg_name, p_proc_name, p_stmt_no, p_debug_msg from dual;
1371: commit;
1372: */
1373: -- This API may be used to print other messages in addition to debug messages.Hence, the check is not done here.
1374: -- IF l_debug_mode = 'Y' AND upper(l_module_name) like 'BIS%' THEN