APPS.GHR_MTO_PKG dependencies on GHR_PA_REMARKS

Line 34: SELECT * FROM ghr_pa_remarks

30:
31: l_proc VARCHAR2(72) := g_package || '.create_lac_remarks';
32:
33: CURSOR cur_pa_rem_cur is
34: SELECT * FROM ghr_pa_remarks
35: WHERE pa_request_id = p_pa_request_id;
36:
37: CURSOR cur_rem_code(c_effective_date ghr_pa_requests.effective_date%type) IS
38: SELECT remark_id

Line 45: l_remarks_rec ghr_pa_remarks%rowtype;

41: AND enabled_flag = 'Y'
42: AND nvl(c_effective_date,trunc(sysdate))
43: BETWEEN date_from AND nvl(date_to,nvl(c_effective_date, trunc(sysdate)));
44:
45: l_remarks_rec ghr_pa_remarks%rowtype;
46: l_remark_id ghr_pa_remarks.remark_id%type;
47:
48: BEGIN
49: g_proc := 'create_lac_remarks';

Line 46: l_remark_id ghr_pa_remarks.remark_id%type;

42: AND nvl(c_effective_date,trunc(sysdate))
43: BETWEEN date_from AND nvl(date_to,nvl(c_effective_date, trunc(sysdate)));
44:
45: l_remarks_rec ghr_pa_remarks%rowtype;
46: l_remark_id ghr_pa_remarks.remark_id%type;
47:
48: BEGIN
49: g_proc := 'create_lac_remarks';
50: hr_utility.set_location('Entering ' || l_proc,5);

Line 116: ghr_pa_remarks_api.create_pa_remarks

112: hr_utility.set_location('description ' || l_remarks_rec.description,10);
113: END IF;
114: hr_utility.set_location('l_remarks_rec.object_version_number ' ||l_remarks_rec.object_version_number,10);
115: pr('Rem id '||to_char(l_remarks_rec.remark_id));
116: ghr_pa_remarks_api.create_pa_remarks
117: (p_validate => false
118: ,p_pa_request_id => p_new_pa_request_id
119: ,p_remark_id => l_remarks_rec.remark_id
120: ,p_description => l_remarks_rec.description