5:
6:
7: procedure get_noa_id_desc
8: (
9: p_noa_code in ghr_nature_of_actions.code%type,
10: p_effective_date in date default trunc(sysdate),
11: p_noa_id out nocopy ghr_nature_of_actions.nature_of_action_id%type,
12: p_noa_desc out nocopy ghr_nature_of_actions.description%type
13: )
7: procedure get_noa_id_desc
8: (
9: p_noa_code in ghr_nature_of_actions.code%type,
10: p_effective_date in date default trunc(sysdate),
11: p_noa_id out nocopy ghr_nature_of_actions.nature_of_action_id%type,
12: p_noa_desc out nocopy ghr_nature_of_actions.description%type
13: )
14: is
15:
8: (
9: p_noa_code in ghr_nature_of_actions.code%type,
10: p_effective_date in date default trunc(sysdate),
11: p_noa_id out nocopy ghr_nature_of_actions.nature_of_action_id%type,
12: p_noa_desc out nocopy ghr_nature_of_actions.description%type
13: )
14: is
15:
16: --
20: l_proc varchar2(72) := g_package || 'get_noa_id_desc';
21:
22: cursor c_noa is
23: select noa.nature_of_action_id, noa.description
24: from ghr_nature_of_actions noa
25: where noa.code = p_noa_code
26: and noa.enabled_flag = 'Y'
27: and nvl(p_effective_date,trunc(sysdate))
28: between noa.date_from
50:
51:
52: procedure get_remark_id_desc
53: (
54: p_remark_code in ghr_nature_of_actions.code%type,
55: p_effective_date in date default trunc(sysdate),
56: p_remark_id out nocopy ghr_nature_of_actions.nature_of_action_id%type,
57: p_remark_desc out nocopy ghr_nature_of_actions.description%type
58: )
52: procedure get_remark_id_desc
53: (
54: p_remark_code in ghr_nature_of_actions.code%type,
55: p_effective_date in date default trunc(sysdate),
56: p_remark_id out nocopy ghr_nature_of_actions.nature_of_action_id%type,
57: p_remark_desc out nocopy ghr_nature_of_actions.description%type
58: )
59: is
60:
53: (
54: p_remark_code in ghr_nature_of_actions.code%type,
55: p_effective_date in date default trunc(sysdate),
56: p_remark_id out nocopy ghr_nature_of_actions.nature_of_action_id%type,
57: p_remark_desc out nocopy ghr_nature_of_actions.description%type
58: )
59: is
60:
61: --