PACKAGE BODY: APPS.PER_MM_JOB_REQUIREMENTS_PKG

Source

1 package body PER_MM_JOB_REQUIREMENTS_PKG as
2 /* $Header: pemmv05t.pkb 115.0 99/07/18 14:02:31 porting ship $ */
3 --
4 --
5 procedure load_rows
6                   (p_mass_move_id in number)
7 is
8 
9 begin
10      insert into per_mm_job_requirements
11          (MASS_MOVE_ID,
12           ANALYSIS_CRITERIA_ID,
13           DELETE_FLAG)
14      select distinct
15          p_mass_move_id,
16          analysis_criteria_id,
17          'N'
18        from per_job_requirements jbr,
19             per_mm_positions mmpos
20       where mmpos.position_id = jbr.position_id
21         and mmpos.mass_move_id = p_mass_move_id;
22     exception
23        when no_data_found then
24          null;
25        when others then
26          hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
27          hr_utility.set_message_token('PROCEDURE','insert_child_rows');
28          hr_utility.set_message_token('STEP','1');
29          hr_utility.raise_error;
30 
31   end load_rows;
32 --
33 --
34 end PER_MM_JOB_REQUIREMENTS_PKG ;
35