APPS.IGF_SP_CREATE_BASE_REC dependencies on IGS_PE_PERSON

Line 69: p_person_id IN igs_pe_person.person_id%TYPE,

65: PROCEDURE create_base_record
66: (errbuf OUT NOCOPY VARCHAR2,
67: retcode OUT NOCOPY NUMBER,
68: p_award_year IN VARCHAR2,
69: p_person_id IN igs_pe_person.person_id%TYPE,
70: p_person_group_id IN igs_pe_prsid_grp_mem.group_id%TYPE,
71: p_org_id IN NUMBER )
72: AS
73: ------------------------------------------------------------------------------------

Line 138: PROCEDURE log_person_details ( p_n_person_id igs_pe_person.person_id%TYPE )

134: WHERE group_id = cp_group_id
135: AND (TRUNC(start_date) <= TRUNC(SYSDATE) OR (start_date IS NULL))
136: AND (TRUNC(end_date) >= TRUNC(SYSDATE) OR (end_date IS NULL));*/
137:
138: PROCEDURE log_person_details ( p_n_person_id igs_pe_person.person_id%TYPE )
139: AS
140: ------------------------------------------------------------------------------------
141: --Created by : shtatiko ( Oracle IDC)
142: --Date created: 25-MAR-2003

Line 152: CURSOR c_person_detail (cp_person_id igs_pe_person.person_id%TYPE) IS

148: --Change History:
149: --Who When What
150: -------------------------------------------------------------------------------------
151:
152: CURSOR c_person_detail (cp_person_id igs_pe_person.person_id%TYPE) IS
153: SELECT person_number,
154: full_name
155: FROM igs_pe_person_base_v
156: WHERE person_id = cp_person_id;

Line 155: FROM igs_pe_person_base_v

151:
152: CURSOR c_person_detail (cp_person_id igs_pe_person.person_id%TYPE) IS
153: SELECT person_number,
154: full_name
155: FROM igs_pe_person_base_v
156: WHERE person_id = cp_person_id;
157: rec_person_detail c_person_detail%ROWTYPE;
158:
159: BEGIN

Line 354: p_person_id IN igs_pe_person.person_id%TYPE,

350:
351: FUNCTION create_fa_base_record
352: (p_cal_type IN igs_ca_inst.cal_type%TYPE,
353: p_sequence_number IN igs_ca_inst.sequence_number%TYPE,
354: p_person_id IN igs_pe_person.person_id%TYPE,
355: p_base_id OUT NOCOPY igf_ap_fa_base_rec.base_id%TYPE,
356: p_message OUT NOCOPY VARCHAR2)
357: RETURN BOOLEAN
358: AS

Line 397: CURSOR c_exists (cp_person_id igs_pe_person.person_id%TYPE,

393: l_base_id igf_ap_fa_base_rec.BASE_ID%TYPE;
394: /*
395: cursor to see whether the FA records for the passsed in person id exists or not
396: */
397: CURSOR c_exists (cp_person_id igs_pe_person.person_id%TYPE,
398: cp_cal_type igs_ca_inst.cal_type%TYPE,
399: cp_sequence_number igs_ca_inst.sequence_number%TYPE) IS
400: SELECT base_id
401: FROM igf_ap_fa_base_rec