APPS.OPI_DBI_RES_PKG dependencies on STANDARD

Line 7: -- Standard who columns

3:
4: /*========================================
5: Package Level Variables
6: =========================================*/
7: -- Standard who columns
8: g_user_id NUMBER;
9: g_login_id NUMBER;
10: g_program_id NUMBER;
11: g_program_login_id NUMBER;

Line 1733: This procedure extracts standard resource usage data

1729:
1730:
1731:
1732: /*======================================================
1733: This procedure extracts standard resource usage data
1734: into the staging table for initial load.
1735:
1736: Parameters:
1737: - errbuf: error buffer

Line 1941: This procedure extracts standard resource usage data

1937: END initial_opm_res_std;
1938:
1939:
1940: /*======================================================
1941: This procedure extracts standard resource usage data
1942: into the staging table for incremental load.
1943:
1944: Parameters:
1945: - errbuf: error buffer

Line 2718: This is the incremental procedure to extract resource standard usage

2714: END initial_load_res_utl;
2715:
2716:
2717: /*======================================================================
2718: This is the incremental procedure to extract resource standard usage
2719: data for discrete organizations.
2720:
2721: Parameters:
2722: - errbuf: error buffer

Line 2966: /*** Collect Standard Resource Usage ***/

2962: --}
2963: END IF;
2964:
2965:
2966: /*** Collect Standard Resource Usage ***/
2967:
2968: -- Incrementally load resource standard usage fact for discrete
2969: bis_collection_utilities.put_line('Load discrete resource std into staging ...');
2970: l_stmt_num := 30;

Line 2968: -- Incrementally load resource standard usage fact for discrete

2964:
2965:
2966: /*** Collect Standard Resource Usage ***/
2967:
2968: -- Incrementally load resource standard usage fact for discrete
2969: bis_collection_utilities.put_line('Load discrete resource std into staging ...');
2970: l_stmt_num := 30;
2971:
2972: incremental_opi_res_std(errbuf => errbuf, retcode => retcode);

Line 2981: -- Incrementally load resource standard usage fact for process

2977: --}
2978: END IF;
2979:
2980:
2981: -- Incrementally load resource standard usage fact for process
2982: bis_collection_utilities.put_line('Load process resource std into staging ...');
2983: l_stmt_num := 40;
2984:
2985: incremental_opm_res_std(errbuf => errbuf, retcode => retcode);

Line 3556: This procedure extracts Resource Standard Usage for initial loads.

3552: END incremental_load_res_utl;
3553:
3554:
3555: /*======================================================================
3556: This procedure extracts Resource Standard Usage for initial loads.
3557:
3558: Parameters:
3559: - errbuf: error buffer
3560: - retcode: return code

Line 3748: bis_collection_utilities.put_line('Load OPI resource standard into FACT ' ||

3744: l_row_count := SQL%rowcount;
3745:
3746: COMMIT;
3747:
3748: bis_collection_utilities.put_line('Load OPI resource standard into FACT ' ||
3749: l_row_count || ' rows, completed at '
3750: || To_char(Sysdate, 'hh24:mi:ss dd-mon-yyyy'));
3751:
3752: