APPS.IGS_AD_ADM_REQ dependencies on IGS_PE_PERSON_ADDR

Line 827: CURSOR c_igs_pe_person_addr IS

823: p_nominated_prg_cd IN VARCHAR2,
824: p_nominated_prg_version IN NUMBER
825: ) RETURN TRK_TYPE AS
826:
827: CURSOR c_igs_pe_person_addr IS
828: SELECT row_id
829: FROM igs_pe_person_addr
830: WHERE person_id = p_person_id;
831:

Line 829: FROM igs_pe_person_addr

825: ) RETURN TRK_TYPE AS
826:
827: CURSOR c_igs_pe_person_addr IS
828: SELECT row_id
829: FROM igs_pe_person_addr
830: WHERE person_id = p_person_id;
831:
832: CURSOR c_igs_pe_mil_services IS
833: SELECT row_id

Line 1015: lv_rowid_per_addr igs_pe_person_addr.row_id%TYPE;

1011: lv_trk_types TRK_TYPE;
1012: lv_tmp_trk TRK_TYPE;
1013: lv_emp_trk TRK_TYPE;
1014:
1015: lv_rowid_per_addr igs_pe_person_addr.row_id%TYPE;
1016: lv_rowid_mil_serv igs_pe_mil_services.row_id%TYPE;
1017: lv_rowid_pers_dis igs_pe_pers_disablty_v.row_id%TYPE;
1018: -- lv_rowid_pe_stat igs_pe_stat_v.row_id%TYPE;
1019: lv_rowid_pe_citizen_status igs_pe_eit_restatus_v.row_id%TYPE;

Line 1037: TYPE rowid_type IS TABLE OF igs_pe_person_addr.row_id%TYPE INDEX BY BINARY_INTEGER;

1033: lv_rowid_ath IGS_PE_ATHLETIC_PRG_V.row_id%TYPE; -- bug 2794983
1034: lv_rowid_acad_hon igs_pe_acad_honors_v.row_id%TYPE;
1035:
1036:
1037: TYPE rowid_type IS TABLE OF igs_pe_person_addr.row_id%TYPE INDEX BY BINARY_INTEGER;
1038:
1039:
1040: rowid_per_addr_table rowid_type;
1041: rowid_mil_serv_table rowid_type;

Line 1195: OPEN c_igs_pe_person_addr;

1191:
1192:
1193: IF rowid_per_addr_table.count = 0 AND l_address_rule_exists THEN
1194:
1195: OPEN c_igs_pe_person_addr;
1196: FETCH c_igs_pe_person_addr BULK COLLECT INTO rowid_per_addr_table ;
1197: IF c_igs_pe_person_addr%ISOPEN THEN
1198: CLOSE c_igs_pe_person_addr;
1199: END IF;

Line 1196: FETCH c_igs_pe_person_addr BULK COLLECT INTO rowid_per_addr_table ;

1192:
1193: IF rowid_per_addr_table.count = 0 AND l_address_rule_exists THEN
1194:
1195: OPEN c_igs_pe_person_addr;
1196: FETCH c_igs_pe_person_addr BULK COLLECT INTO rowid_per_addr_table ;
1197: IF c_igs_pe_person_addr%ISOPEN THEN
1198: CLOSE c_igs_pe_person_addr;
1199: END IF;
1200: END IF;

Line 1197: IF c_igs_pe_person_addr%ISOPEN THEN

1193: IF rowid_per_addr_table.count = 0 AND l_address_rule_exists THEN
1194:
1195: OPEN c_igs_pe_person_addr;
1196: FETCH c_igs_pe_person_addr BULK COLLECT INTO rowid_per_addr_table ;
1197: IF c_igs_pe_person_addr%ISOPEN THEN
1198: CLOSE c_igs_pe_person_addr;
1199: END IF;
1200: END IF;
1201:

Line 1198: CLOSE c_igs_pe_person_addr;

1194:
1195: OPEN c_igs_pe_person_addr;
1196: FETCH c_igs_pe_person_addr BULK COLLECT INTO rowid_per_addr_table ;
1197: IF c_igs_pe_person_addr%ISOPEN THEN
1198: CLOSE c_igs_pe_person_addr;
1199: END IF;
1200: END IF;
1201:
1202: IF rowid_mil_serv_table.count = 0 AND l_military_rule_exists THEN