APPS.GHR_MASS_ACTIONS_PKG dependencies on GHR_NATURE_OF_ACTIONS

Line 9: p_noa_code in ghr_nature_of_actions.code%type,

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: )

Line 11: p_noa_id out nocopy ghr_nature_of_actions.nature_of_action_id%type,

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:

Line 12: p_noa_desc out nocopy ghr_nature_of_actions.description%type

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: --

Line 24: from ghr_nature_of_actions noa

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

Line 54: p_remark_code in ghr_nature_of_actions.code%type,

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: )

Line 56: p_remark_id out nocopy ghr_nature_of_actions.nature_of_action_id%type,

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:

Line 57: p_remark_desc out nocopy ghr_nature_of_actions.description%type

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: --