APPS.PER_RI_RT_UTIL_PKG dependencies on PER_RI_RT_GEN

Line 3: PROCEDURE insert_per_ri_rt_gen (p_job_name VARCHAR2,

1: PACKAGE BODY per_ri_rt_util_pkg AS
2: /* $Header: perrirtutil.pkb 120.3 2006/10/05 09:54:16 balchand noship $ */
3: PROCEDURE insert_per_ri_rt_gen (p_job_name VARCHAR2,
4: p_request_id NUMBER,
5: p_user_id NUMBER)
6: IS
7: CURSOR csr_get_conc_proc_stat IS

Line 21: INSERT INTO per_ri_rt_gen (

17: OPEN csr_get_conc_proc_stat;
18: FETCH csr_get_conc_proc_stat INTO l_req_phase, l_req_status,l_submit_date;
19: CLOSE csr_get_conc_proc_stat;
20:
21: INSERT INTO per_ri_rt_gen (
22: JOB_NAME,
23: REQUEST_ID,
24: USER_ID,
25: REQUEST_PHASE,

Line 38: END insert_per_ri_rt_gen;

34: l_req_status,
35: sysdate,--l_submit_date,
36: null,
37: null);
38: END insert_per_ri_rt_gen;
39:
40: FUNCTION make_sql_stmt (p_value_set_id in number,
41: p_value_set_type in varchar2,
42: p_choice out nocopy boolean)