[Home] [Help]
6: -- ----------------------------------------------------------------------------
7: --
8: TYPE g_rec_type IS RECORD (
9: succession_plan_id NUMBER (9),
10: person_id per_succession_planning.person_id%TYPE,
11: position_id per_succession_planning.position_id%TYPE,
12: business_group_id NUMBER (15),
13: start_date DATE,
14: time_scale VARCHAR2 (30),
7: --
8: TYPE g_rec_type IS RECORD (
9: succession_plan_id NUMBER (9),
10: person_id per_succession_planning.person_id%TYPE,
11: position_id per_succession_planning.position_id%TYPE,
12: business_group_id NUMBER (15),
13: start_date DATE,
14: time_scale VARCHAR2 (30),
15: end_date DATE,
36: attribute17 VARCHAR2 (150),
37: attribute18 VARCHAR2 (150),
38: attribute19 VARCHAR2 (150),
39: attribute20 VARCHAR2 (150),
40: job_id per_succession_planning.job_id%TYPE,
41: successee_person_id per_succession_planning.successee_person_id%TYPE,
42: person_rank per_succession_planning.person_rank%TYPE,
43: performance per_succession_planning.performance%TYPE,
44: plan_status per_succession_planning.plan_status%TYPE,
37: attribute18 VARCHAR2 (150),
38: attribute19 VARCHAR2 (150),
39: attribute20 VARCHAR2 (150),
40: job_id per_succession_planning.job_id%TYPE,
41: successee_person_id per_succession_planning.successee_person_id%TYPE,
42: person_rank per_succession_planning.person_rank%TYPE,
43: performance per_succession_planning.performance%TYPE,
44: plan_status per_succession_planning.plan_status%TYPE,
45: readiness_percentage per_succession_planning.readiness_percentage%TYPE
38: attribute19 VARCHAR2 (150),
39: attribute20 VARCHAR2 (150),
40: job_id per_succession_planning.job_id%TYPE,
41: successee_person_id per_succession_planning.successee_person_id%TYPE,
42: person_rank per_succession_planning.person_rank%TYPE,
43: performance per_succession_planning.performance%TYPE,
44: plan_status per_succession_planning.plan_status%TYPE,
45: readiness_percentage per_succession_planning.readiness_percentage%TYPE
46: );
39: attribute20 VARCHAR2 (150),
40: job_id per_succession_planning.job_id%TYPE,
41: successee_person_id per_succession_planning.successee_person_id%TYPE,
42: person_rank per_succession_planning.person_rank%TYPE,
43: performance per_succession_planning.performance%TYPE,
44: plan_status per_succession_planning.plan_status%TYPE,
45: readiness_percentage per_succession_planning.readiness_percentage%TYPE
46: );
47:
40: job_id per_succession_planning.job_id%TYPE,
41: successee_person_id per_succession_planning.successee_person_id%TYPE,
42: person_rank per_succession_planning.person_rank%TYPE,
43: performance per_succession_planning.performance%TYPE,
44: plan_status per_succession_planning.plan_status%TYPE,
45: readiness_percentage per_succession_planning.readiness_percentage%TYPE
46: );
47:
48: --
41: successee_person_id per_succession_planning.successee_person_id%TYPE,
42: person_rank per_succession_planning.person_rank%TYPE,
43: performance per_succession_planning.performance%TYPE,
44: plan_status per_succession_planning.plan_status%TYPE,
45: readiness_percentage per_succession_planning.readiness_percentage%TYPE
46: );
47:
48: --
49: -- ----------------------------------------------------------------------------