eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.IGS_ST_GEN_002 dependencies on IGS_PE_PERSON

Line 333: FROM IGS_PE_PERSON pe

329: DECLARE
330: CURSOR c_pe IS
331: SELECT pe.birth_dt,
332: pe.sex
333: FROM IGS_PE_PERSON pe
334: WHERE pe.person_id = p_person_id;
335: CURSOR c_ps IS
336: SELECT ps.aborig_torres_cd,
337: ps.citizenship_cd,

Line 510: v_birth_dt IGS_PE_PERSON.birth_dt%TYPE;

506: DECLARE
507: v_other_detail VARCHAR2(255);
508: v_citizenship_cd IGS_ST_GOVT_STDNT_EN.citizenship_cd%TYPE;
509: v_aborig_torres_cd IGS_ST_GOVT_STDNT_EN.aborig_torres_cd%TYPE;
510: v_birth_dt IGS_PE_PERSON.birth_dt%TYPE;
511: v_sex IGS_PE_PERSON.sex%TYPE;
512: v_govt_disability CHAR(8);
513: v_govt_aborig_torres_cd IGS_ST_GOVT_STDNT_EN.govt_aborig_torres_cd%TYPE;
514: v_govt_citizenship_cd IGS_ST_GOVT_STDNT_EN.govt_citizenship_cd%TYPE;

Line 511: v_sex IGS_PE_PERSON.sex%TYPE;

507: v_other_detail VARCHAR2(255);
508: v_citizenship_cd IGS_ST_GOVT_STDNT_EN.citizenship_cd%TYPE;
509: v_aborig_torres_cd IGS_ST_GOVT_STDNT_EN.aborig_torres_cd%TYPE;
510: v_birth_dt IGS_PE_PERSON.birth_dt%TYPE;
511: v_sex IGS_PE_PERSON.sex%TYPE;
512: v_govt_disability CHAR(8);
513: v_govt_aborig_torres_cd IGS_ST_GOVT_STDNT_EN.govt_aborig_torres_cd%TYPE;
514: v_govt_citizenship_cd IGS_ST_GOVT_STDNT_EN.govt_citizenship_cd%TYPE;
515: v_perm_resident_cd IGS_ST_GOVT_STDNT_EN.perm_resident_cd%TYPE;

Line 544: FROM IGS_PE_PERSON pe

540: v_course_cd IGS_EN_STDNT_PS_ATT.course_cd%TYPE;
541: CURSOR c_get_person_dtls IS
542: SELECT pe.birth_dt,
543: pe.sex
544: FROM IGS_PE_PERSON pe
545: WHERE pe.person_id = p_person_id;
546: CURSOR c_prsn_stats IS
547: SELECT ps.aborig_torres_cd,
548: ps.citizenship_cd,

Line 617: 'IGS_PE_PERSON' || ',' || TO_CHAR(p_person_id),

613: -- Create an entry in the System Log Entry
614: IGS_GE_GEN_003.genp_ins_log_entry(
615: p_s_log_type,
616: p_creation_dt,
617: 'IGS_PE_PERSON' || ',' || TO_CHAR(p_person_id),
618: p_message_name,
619: NULL);
620: END;
621: EXCEPTION

Line 659: 'IGS_PE_PERSON' || ',' || TO_CHAR(p_person_id),

655: -- create an entry in the system log entry
656: IGS_GE_GEN_003.genp_ins_log_entry (
657: p_s_log_type,
658: p_creation_dt,
659: 'IGS_PE_PERSON' || ',' || TO_CHAR(p_person_id),
660: 4194,
661: NULL);
662: END IF;
663: IF (v_sex NOT IN('M','F')) THEN

Line 676: 'IGS_PE_PERSON,' || TO_CHAR(p_person_id),

672: -- create an entry in the system log entry
673: IGS_GE_GEN_003.genp_ins_log_entry (
674: p_s_log_type,
675: p_creation_dt,
676: 'IGS_PE_PERSON,' || TO_CHAR(p_person_id),
677: 4195,
678: NULL);
679: --Continue processing this record after the error has been loged.
680: END IF;

Line 720: 'IGS_PE_PERSON' || ',' || TO_CHAR(p_person_id),

716: -- create an entry in the system log entry
717: IGS_GE_GEN_003.genp_ins_log_entry (
718: p_s_log_type,
719: p_creation_dt,
720: 'IGS_PE_PERSON' || ',' || TO_CHAR(p_person_id),
721: 4196,
722: NULL);
723: ELSE
724: CLOSE c_prsn_stats;

Line 747: 'IGS_PE_PERSON' || ',' || TO_CHAR(p_person_id),

743: -- create an entry in the system log entry
744: IGS_GE_GEN_003.genp_ins_log_entry (
745: p_s_log_type,
746: p_creation_dt,
747: 'IGS_PE_PERSON' || ',' || TO_CHAR(p_person_id),
748: 4197,
749: NULL);
750: END IF;
751: ELSE

Line 766: 'IGS_PE_PERSON' || ',' || TO_CHAR(p_person_id),

762: -- create an entry in the system log entry
763: IGS_GE_GEN_003.genp_ins_log_entry (
764: p_s_log_type,
765: p_creation_dt,
766: 'IGS_PE_PERSON' || ',' || TO_CHAR(p_person_id),
767: 4197,
768: NULL);
769: END IF;
770: -- citizenship code

Line 790: 'IGS_PE_PERSON' || ',' || TO_CHAR(p_person_id),

786: -- create an entry in the system log entry
787: IGS_GE_GEN_003.genp_ins_log_entry (
788: p_s_log_type,
789: p_creation_dt,
790: 'IGS_PE_PERSON' || ',' || TO_CHAR(p_person_id),
791: 4202,
792: NULL);
793: END IF;
794: ELSE

Line 809: 'IGS_PE_PERSON' || ',' || TO_CHAR(p_person_id),

805: -- create an entry in the system log entry
806: IGS_GE_GEN_003.genp_ins_log_entry (
807: p_s_log_type,
808: p_creation_dt,
809: 'IGS_PE_PERSON' || ',' || TO_CHAR(p_person_id),
810: 4202,
811: NULL);
812: END IF;
813: -- permanent resident code

Line 837: 'IGS_PE_PERSON' || ',' || TO_CHAR(p_person_id),

833: -- create an entry in the system log entry
834: IGS_GE_GEN_003.genp_ins_log_entry (
835: p_s_log_type,
836: p_creation_dt,
837: 'IGS_PE_PERSON' || ',' || TO_CHAR(p_person_id),
838: 4203,
839: NULL);
840: ELSE
841: v_perm_resident_cd := '0';

Line 855: 'IGS_PE_PERSON' || ',' || TO_CHAR(p_person_id),

851: -- create an entry in the system log entry
852: IGS_GE_GEN_003.genp_ins_log_entry (
853: p_s_log_type,
854: p_creation_dt,
855: 'IGS_PE_PERSON' || ',' || TO_CHAR(p_person_id),
856: 4644,
857: NULL);
858: END IF;
859: END IF;

Line 895: 'IGS_PE_PERSON' || ',' || TO_CHAR(p_person_id),

891: -- create an entry in the system log entry
892: IGS_GE_GEN_003.genp_ins_log_entry (
893: p_s_log_type,
894: p_creation_dt,
895: 'IGS_PE_PERSON' || ',' || TO_CHAR(p_person_id),
896: 4204,
897: NULL);
898: END IF;
899: -- term location

Line 934: 'IGS_PE_PERSON' || ',' || TO_CHAR(p_person_id),

930: -- create an entry in the system log entry
931: IGS_GE_GEN_003.genp_ins_log_entry (
932: p_s_log_type,
933: p_creation_dt,
934: 'IGS_PE_PERSON' || ',' || TO_CHAR(p_person_id),
935: 4205,
936: NULL);
937: END IF;
938: -- country of birth code

Line 966: 'IGS_PE_PERSON' || ',' || TO_CHAR(p_person_id),

962: -- create an entry in the system log entry
963: IGS_GE_GEN_003.genp_ins_log_entry (
964: p_s_log_type,
965: p_creation_dt,
966: 'IGS_PE_PERSON' || ',' || TO_CHAR(p_person_id),
967: 4206,
968: NULL);
969: END IF;
970: -- year of arrival

Line 985: 'IGS_PE_PERSON' || ',' || TO_CHAR(p_person_id),

981: -- create an entry in the system log entry
982: IGS_GE_GEN_003.genp_ins_log_entry (
983: p_s_log_type,
984: p_creation_dt,
985: 'IGS_PE_PERSON' || ',' || TO_CHAR(p_person_id),
986: 4207,
987: NULL);
988: ELSIF v_yr_arrival = 'A8' OR
989: v_yr_arrival = 'A9' THEN

Line 1002: 'IGS_PE_PERSON' || ',' || TO_CHAR(p_person_id),

998: -- create an entry in the system log entry
999: IGS_GE_GEN_003.genp_ins_log_entry (
1000: p_s_log_type,
1001: p_creation_dt,
1002: 'IGS_PE_PERSON' || ',' || TO_CHAR(p_person_id),
1003: 4207,
1004: NULL);
1005: END IF;
1006: -- home language code

Line 1033: 'IGS_PE_PERSON' || ',' || TO_CHAR(p_person_id),

1029: -- create an entry in the system log entry
1030: IGS_GE_GEN_003.genp_ins_log_entry (
1031: p_s_log_type,
1032: p_creation_dt,
1033: 'IGS_PE_PERSON' || ',' || TO_CHAR(p_person_id),
1034: 4208,
1035: NULL);
1036: END IF;
1037: -- prior undergraduate institution

Line 1070: 'IGS_PE_PERSON' || ',' || TO_CHAR(p_person_id),

1066: -- create an entry in the system log entry
1067: IGS_GE_GEN_003.genp_ins_log_entry (
1068: p_s_log_type,
1069: p_creation_dt,
1070: 'IGS_PE_PERSON' || ',' || TO_CHAR(p_person_id),
1071: 4209,
1072: NULL);
1073: END IF;
1074: ELSE

Line 1089: 'IGS_PE_PERSON' || ',' || TO_CHAR(p_person_id),

1085: -- create an entry in the system log entry
1086: IGS_GE_GEN_003.genp_ins_log_entry (
1087: p_s_log_type,
1088: p_creation_dt,
1089: 'IGS_PE_PERSON' || ',' || TO_CHAR(p_person_id),
1090: 4209,
1091: NULL);
1092: END IF;
1093: -- prior other qualification/certificate

Line 1115: 'IGS_PE_PERSON' || ',' || TO_CHAR(p_person_id),

1111: -- create an entry in the system log entry
1112: IGS_GE_GEN_003.genp_ins_log_entry (
1113: p_s_log_type,
1114: p_creation_dt,
1115: 'IGS_PE_PERSON' || ',' || TO_CHAR(p_person_id),
1116: 4210,
1117: NULL);
1118: END IF;
1119: -- prior postgraduate course

Line 1141: 'IGS_PE_PERSON' || ',' || TO_CHAR(p_person_id),

1137: -- create an entry in the system log entry
1138: IGS_GE_GEN_003.genp_ins_log_entry (
1139: p_s_log_type,
1140: p_creation_dt,
1141: 'IGS_PE_PERSON' || ',' || TO_CHAR(p_person_id),
1142: 4211,
1143: NULL);
1144: END IF;
1145: -- prior degree

Line 1167: 'IGS_PE_PERSON' || ',' || TO_CHAR(p_person_id),

1163: -- create an entry in the system log entry
1164: IGS_GE_GEN_003.genp_ins_log_entry (
1165: p_s_log_type,
1166: p_creation_dt,
1167: 'IGS_PE_PERSON' || ',' || TO_CHAR(p_person_id),
1168: 4212,
1169: NULL);
1170: END IF;
1171: -- prior sub-degree course (not at TAFE)

Line 1193: 'IGS_PE_PERSON' || ',' || TO_CHAR(p_person_id),

1189: -- create an entry in the system log entry
1190: IGS_GE_GEN_003.genp_ins_log_entry (
1191: p_s_log_type,
1192: p_creation_dt,
1193: 'IGS_PE_PERSON' || ',' || TO_CHAR(p_person_id),
1194: 4213,
1195: NULL);
1196: END IF;
1197: -- prior sub-degree course

Line 1219: 'IGS_PE_PERSON' || ',' || TO_CHAR(p_person_id),

1215: -- create an entry in the system log entry
1216: IGS_GE_GEN_003.genp_ins_log_entry (
1217: p_s_log_type,
1218: p_creation_dt,
1219: 'IGS_PE_PERSON' || ',' || TO_CHAR(p_person_id),
1220: 4214,
1221: NULL);
1222: END IF;
1223: -- prior secondary education course at TAFE

Line 1245: 'IGS_PE_PERSON' || ',' || TO_CHAR(p_person_id),

1241: -- create an entry in the system log entry
1242: IGS_GE_GEN_003.genp_ins_log_entry (
1243: p_s_log_type,
1244: p_creation_dt,
1245: 'IGS_PE_PERSON' || ',' || TO_CHAR(p_person_id),
1246: 4215,
1247: NULL);
1248: END IF;
1249: -- prior secondary course at school

Line 1271: 'IGS_PE_PERSON' || ',' || TO_CHAR(p_person_id),

1267: -- create an entry in the system log entry
1268: IGS_GE_GEN_003.genp_ins_log_entry (
1269: p_s_log_type,
1270: p_creation_dt,
1271: 'IGS_PE_PERSON' || ',' || TO_CHAR(p_person_id),
1272: 4216,
1273: NULL);
1274: END IF;
1275: -- prior TAFE award course

Line 1297: 'IGS_PE_PERSON' || ',' || TO_CHAR(p_person_id),

1293: -- create an entry in the system log entry
1294: IGS_GE_GEN_003.genp_ins_log_entry (
1295: p_s_log_type,
1296: p_creation_dt,
1297: 'IGS_PE_PERSON' || ',' || TO_CHAR(p_person_id),
1298: 4217,
1299: NULL);
1300: END IF;
1301: -- setting the output parameters to what these