APPS.OPI_DBI_RES_PKG dependencies on OPI_DBI_RES_STD_F

Line 1752: INSERT INTO opi_dbi_res_std_f (

1748:
1749: bis_collection_utilities.put_line('Enter initial_opm_res_std() ' ||
1750: To_char(Sysdate, 'hh24:mi:ss dd-mon-yyyy'));
1751:
1752: INSERT INTO opi_dbi_res_std_f (
1753: resource_id,
1754: organization_id,
1755: transaction_date,
1756: std_usage_qty,

Line 1959: DELETE opi_dbi_res_std_f std

1955:
1956: bis_collection_utilities.put_line('Enter incremental_opm_res_std() ' ||
1957: To_char(Sysdate, 'hh24:mi:ss dd-mon-yyyy'));
1958:
1959: DELETE opi_dbi_res_std_f std
1960: WHERE (job_id, job_type)
1961: IN (SELECT job_id,
1962: job_type
1963: FROM opi_dbi_jobs_f

Line 1967: INSERT INTO opi_dbi_res_std_f

1963: FROM opi_dbi_jobs_f
1964: WHERE std_res_flag = 1
1965: AND job_type = 4); -- need to extract again
1966:
1967: INSERT INTO opi_dbi_res_std_f
1968: (resource_id,
1969: organization_id,
1970: transaction_date,
1971: std_usage_qty,

Line 2737: DELETE opi_dbi_res_std_f std

2733: To_char(Sysdate, 'hh24:mi:ss dd-mon-yyyy'));
2734:
2735: retcode := 0;
2736:
2737: DELETE opi_dbi_res_std_f std
2738: WHERE (job_id, job_type)
2739: IN (SELECT job_id,
2740: job_type
2741: FROM opi_dbi_jobs_f

Line 2745: INSERT INTO opi_dbi_res_std_f (

2741: FROM opi_dbi_jobs_f
2742: WHERE std_res_flag = 1 -- need to extract again
2743: AND source = OPI_SOURCE);
2744:
2745: INSERT INTO opi_dbi_res_std_f (
2746: resource_id,
2747: department_id,
2748: organization_id,
2749: transaction_date,

Line 3587: IF bis_collection_utilities.setup( 'OPI_DBI_RES_STD_F' ) = false THEN

3583:
3584: -- initialization block
3585: l_error_flag := FALSE;
3586:
3587: IF bis_collection_utilities.setup( 'OPI_DBI_RES_STD_F' ) = false THEN
3588: --{
3589: RAISE_APPLICATION_ERROR(-20000, errbuf);
3590: --}
3591: END IF;

Line 3616: || '.opi_dbi_res_std_f PURGE MATERIALIZED VIEW LOG';

3612: l_stmt_num := 20;
3613: IF fnd_installation.get_app_info( 'OPI', l_status, l_industry, l_opi_schema) THEN
3614: --{
3615: execute immediate 'truncate table ' || l_opi_schema
3616: || '.opi_dbi_res_std_f PURGE MATERIALIZED VIEW LOG';
3617: --}
3618: ELSE
3619: --{
3620: RAISE SCHEMA_INFO_NOT_FOUND;

Line 3629: INSERT /*+ append parallel(opi_dbi_res_std_f) */

3625: IF l_error_flag = FALSE THEN
3626: --{
3627: bis_collection_utilities.put_line('Load discrete res std into staging ...');
3628:
3629: INSERT /*+ append parallel(opi_dbi_res_std_f) */
3630: INTO opi_dbi_res_std_f (
3631: resource_id,
3632: department_id,
3633: organization_id,

Line 3630: INTO opi_dbi_res_std_f (

3626: --{
3627: bis_collection_utilities.put_line('Load discrete res std into staging ...');
3628:
3629: INSERT /*+ append parallel(opi_dbi_res_std_f) */
3630: INTO opi_dbi_res_std_f (
3631: resource_id,
3632: department_id,
3633: organization_id,
3634: transaction_date,