[Home] [Help]
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