APPS.HR_JP_PARAMETERS_PKG dependencies on HR_JP_PARAMETERS

Line 1: package body HR_JP_PARAMETERS_PKG as

1: package body HR_JP_PARAMETERS_PKG as
2: /* $Header: hrjpparm.pkb 115.2 99/07/17 16:38:46 porting ship $ */
3: --------------------------------------------------------------------------------
4: FUNCTION get_parameter_value(
5: p_owner IN VARCHAR2,

Line 9: l_parameter_value HR_JP_PARAMETERS.PARAMETER_VALUE%TYPE;

5: p_owner IN VARCHAR2,
6: p_parameter_name IN VARCHAR2) RETURN VARCHAR2
7: --------------------------------------------------------------------------------
8: IS
9: l_parameter_value HR_JP_PARAMETERS.PARAMETER_VALUE%TYPE;
10: CURSOR csr_parameter_value IS
11: select parameter_value
12: from hr_jp_parameters
13: where owner=p_owner

Line 12: from hr_jp_parameters

8: IS
9: l_parameter_value HR_JP_PARAMETERS.PARAMETER_VALUE%TYPE;
10: CURSOR csr_parameter_value IS
11: select parameter_value
12: from hr_jp_parameters
13: where owner=p_owner
14: and parameter_name=p_parameter_name;
15: BEGIN
16: open csr_parameter_value;

Line 35: from hr_jp_parameters

31: IS
32: l_rowid ROWID;
33: CURSOR csr_rowid IS
34: select rowid
35: from hr_jp_parameters
36: where owner=p_owner
37: and parameter_name=p_parameter_name
38: for update nowait;
39: BEGIN

Line 48: update hr_jp_parameters

44: end if;
45: close csr_rowid;
46:
47: if l_rowid is not NULL then
48: update hr_jp_parameters
49: set parameter_value=p_parameter_value
50: where rowid=l_rowid;
51: else
52: insert into HR_JP_PARAMETERS(

Line 52: insert into HR_JP_PARAMETERS(

48: update hr_jp_parameters
49: set parameter_value=p_parameter_value
50: where rowid=l_rowid;
51: else
52: insert into HR_JP_PARAMETERS(
53: OWNER,
54: PARAMETER_NAME,
55: PARAMETER_VALUE)
56: values( p_owner,