DBA Data[Home] [Help]

APPS.IGS_PR_CLSRNK_LGCY_PUB dependencies on IGS_PE_PERSON

Line 42: p_person_id OUT NOCOPY igs_pe_person.person_id%type,

38:
39: PROCEDURE derive_clsrnk_data
40: (
41: p_lgcy_clsrnk_rec IN lgcy_clsrnk_rec_type,
42: p_person_id OUT NOCOPY igs_pe_person.person_id%type,
43: p_cal_type OUT NOCOPY igs_ca_inst.cal_type%type,
44: p_sequence_number OUT NOCOPY igs_ca_inst.sequence_number%type
45: );
46:

Line 52: p_person_id IN igs_pe_person.person_id%type,

48: validate_db_cons function performs all the data integrity validation
49: */
50: FUNCTION validate_db_cons
51: (
52: p_person_id IN igs_pe_person.person_id%type,
53: p_cal_type IN igs_ca_inst.cal_type%type,
54: p_sequence_number IN igs_ca_inst.sequence_number%type,
55: p_lgcy_clsrnk_rec IN lgcy_clsrnk_rec_type
56: )

Line 108: l_person_id igs_pe_person.person_id%type;

104: l_api_name CONSTANT VARCHAR2(30) := 'create_class_rank';
105: l_api_version CONSTANT NUMBER := 1.0;
106:
107: -- variables declared to fetch data from derive_clsrnk_data
108: l_person_id igs_pe_person.person_id%type;
109: l_cal_type igs_ca_inst.cal_type%type;
110: l_sequence_number igs_ca_inst.sequence_number%type;
111:
112: l_return VARCHAR2(1) ;

Line 320: p_person_id OUT NOCOPY igs_pe_person.person_id%type,

316:
317: PROCEDURE derive_clsrnk_data
318: (
319: p_lgcy_clsrnk_rec IN lgcy_clsrnk_rec_type,
320: p_person_id OUT NOCOPY igs_pe_person.person_id%type,
321: p_cal_type OUT NOCOPY igs_ca_inst.cal_type%type,
322: p_sequence_number OUT NOCOPY igs_ca_inst.sequence_number%type
323: )
324: IS

Line 386: p_person_id IN igs_pe_person.person_id%type,

382: END derive_clsrnk_data;
383:
384: FUNCTION validate_db_cons
385: (
386: p_person_id IN igs_pe_person.person_id%type,
387: p_cal_type IN igs_ca_inst.cal_type%type,
388: p_sequence_number IN igs_ca_inst.sequence_number%type,
389: p_lgcy_clsrnk_rec IN lgcy_clsrnk_rec_type
390: )