APPS.IGS_AD_GEN_012 dependencies on IGS_PE_PERSON

Line 1018: cp_pp_per_id IN IGS_PE_PERSON.person_id%TYPE)IS

1014: DECLARE
1015: e_resource_busy EXCEPTION;
1016: PRAGMA EXCEPTION_INIT(e_resource_busy, -54);
1017: CURSOR c_pp (
1018: cp_pp_per_id IN IGS_PE_PERSON.person_id%TYPE)IS
1019: -- SELECT 'x'
1020: SELECT ROWID, pp.*
1021: FROM IGS_PE_PERS_PREFS_ALL pp
1022: WHERE pp.person_id = cp_pp_per_id

Line 1026: v_person_id IGS_PE_PERSON.person_id%TYPE;

1022: WHERE pp.person_id = cp_pp_per_id
1023: FOR UPDATE OF enr_acad_cal_type NOWAIT;
1024:
1025: Rec_IGS_PE_PERS_PREFS C_PP%ROWTYPE;
1026: v_person_id IGS_PE_PERSON.person_id%TYPE;
1027: v_check CHAR;
1028: lv_rowid VARCHAR2(25);
1029: l_org_id NUMBER(15);
1030: BEGIN

Line 1130: cp_pp_per_id IN IGS_PE_PERSON.person_id%TYPE)IS

1126: DECLARE
1127: e_resource_busy EXCEPTION;
1128: PRAGMA EXCEPTION_INIT(e_resource_busy, -54);
1129: CURSOR c_pp (
1130: cp_pp_per_id IN IGS_PE_PERSON.person_id%TYPE)IS
1131: -- SELECT 'x'
1132: SELECT ROWID, pp.*
1133: FROM IGS_PE_PERS_PREFS_ALL pp
1134: WHERE pp.person_id = cp_pp_per_id

Line 1138: v_person_id IGS_PE_PERSON.person_id%TYPE;

1134: WHERE pp.person_id = cp_pp_per_id
1135: FOR UPDATE OF enr_acad_cal_type NOWAIT;
1136:
1137: Rec_IGS_PE_PERS_PREFS c_pp%ROWTYPE;
1138: v_person_id IGS_PE_PERSON.person_id%TYPE;
1139: v_check CHAR;
1140: lv_rowid VARCHAR2(25);
1141: l_org_id NUMBER(15);
1142: BEGIN