APPS.GHR_RIF_PKG dependencies on GHR_RIF_REGISTERS

Line 73: procedure purge_register(p_session_id in ghr_rif_registers.session_id%TYPE) is

69: end return_ratings;
70:
71:
72:
73: procedure purge_register(p_session_id in ghr_rif_registers.session_id%TYPE) is
74: BEGIN
75: delete from ghr_rif_registers
76: where session_id = p_session_id;
77: END;

Line 75: delete from ghr_rif_registers

71:
72:
73: procedure purge_register(p_session_id in ghr_rif_registers.session_id%TYPE) is
74: BEGIN
75: delete from ghr_rif_registers
76: where session_id = p_session_id;
77: END;
78:
79:

Line 266: Select ghr_rif_registers_s.nextval from dual;

262: and p_effective_date between pos.effective_start_date
263: and pos.effective_end_date;
264:
265: cursor cur_rif_reg_seq is
266: Select ghr_rif_registers_s.nextval from dual;
267:
268: l_rif_reg ghr_rif_registers%rowtype;
269:
270: l_c_comp_area varchar2(30);

Line 268: l_rif_reg ghr_rif_registers%rowtype;

264:
265: cursor cur_rif_reg_seq is
266: Select ghr_rif_registers_s.nextval from dual;
267:
268: l_rif_reg ghr_rif_registers%rowtype;
269:
270: l_c_comp_area varchar2(30);
271: l_c_comp_level varchar2(30);
272: l_c_effective_date date;

Line 353: DELETE FROM ghr_rif_registers reg

349: end if;
350:
351: l_effective_date := trunc(sysdate); -- In the future l_effective_date may set to p_effective_date
352:
353: DELETE FROM ghr_rif_registers reg
354: WHERE reg.session_id = userenv('SESSIONID')
355: and rif_criteria_id = p_rif_criteria_id;
356:
357: hr_utility.set_location('Purged rif_registers' ,2);

Line 397: -- Populate the details into ghr_rif_registers

393: nvl(l_rif_reg.agency_code_subelement,hr_api.g_varchar2 ) = nvl(l_c_agency_code_se,nvl(l_rif_reg.agency_code_subelement,hr_api.g_varchar2)) and
394: nvl(per_rec.organization_id,hr_api.g_number ) = nvl(l_c_organization_id,nvl(per_rec.organization_id,hr_api.g_number))
395: then
396:
397: -- Populate the details into ghr_rif_registers
398:
399: -- Tenure and Step_or_rate
400: hr_utility.set_location('Getting Tenure and Ster_or_rate',5);
401:

Line 684: hr_utility.set_location('Inserting into ghr_rif_registers',13);

680: fetch cur_rif_reg_seq into l_rif_reg.rif_register_id;
681: close cur_rif_reg_seq;
682:
683:
684: hr_utility.set_location('Inserting into ghr_rif_registers',13);
685: INSERT INTO ghr_rif_registers
686: (rif_register_id
687: ,session_id
688: ,rif_criteria_id

Line 685: INSERT INTO ghr_rif_registers

681: close cur_rif_reg_seq;
682:
683:
684: hr_utility.set_location('Inserting into ghr_rif_registers',13);
685: INSERT INTO ghr_rif_registers
686: (rif_register_id
687: ,session_id
688: ,rif_criteria_id
689: ,effective_date

Line 819: FROM ghr_rif_registers reg

815:
816: PROCEDURE purge_register IS
817: BEGIN
818: DELETE
819: FROM ghr_rif_registers reg
820: WHERE reg.session_id = USERENV('SESSIONID');
821: -- It really doesn't matter if it didn't actually delete any!
822: COMMIT;
823: --