APPS.IGS_ST_GEN_003 dependencies on IGS_PE_PERSON

Line 23: -- is an 8 character code derived from the IGS_PE_PERSON table

19: RETURN VARCHAR2 AS
20: gv_other_detail VARCHAR2(255);
21: BEGIN -- stap_get_prsn_dsblty
22: -- Derive the government disability value for a person. Disability
23: -- is an 8 character code derived from the IGS_PE_PERSON table
24: -- DEETYA element 386
25: DECLARE
26: v_disability CHAR(8) DEFAULT ' ';
27: v_disability_exist CHAR DEFAULT ' ';

Line 35: CURSOR c_prsn_dsblty (cp_person_id IGS_PE_PERSON.person_id%TYPE) IS

31: v_vision CHAR DEFAULT ' ';
32: v_medical CHAR DEFAULT ' ';
33: v_other CHAR DEFAULT ' ';
34: v_contact CHAR DEFAULT ' ';
35: CURSOR c_prsn_dsblty (cp_person_id IGS_PE_PERSON.person_id%TYPE) IS
36: SELECT pd.contact_ind,
37: dt.govt_disability_type
38: FROM
39: IGS_PE_PERS_DISABLTY pd,

Line 91: v_all_given_name IGS_PE_PERSON.given_names%TYPE;

87: -- Derive the student's first given name and other given name(s)
88: -- DEETYA element 403, 404
89: DECLARE
90: v_delim_space NUMBER(2);
91: v_all_given_name IGS_PE_PERSON.given_names%TYPE;
92: CURSOR c_get_given_name (cp_person_id IGS_PE_PERSON.person_id%TYPE) IS
93: SELECT given_names
94: FROM IGS_PE_PERSON
95: WHERE person_id = cp_person_id;

Line 92: CURSOR c_get_given_name (cp_person_id IGS_PE_PERSON.person_id%TYPE) IS

88: -- DEETYA element 403, 404
89: DECLARE
90: v_delim_space NUMBER(2);
91: v_all_given_name IGS_PE_PERSON.given_names%TYPE;
92: CURSOR c_get_given_name (cp_person_id IGS_PE_PERSON.person_id%TYPE) IS
93: SELECT given_names
94: FROM IGS_PE_PERSON
95: WHERE person_id = cp_person_id;
96: BEGIN

Line 94: FROM IGS_PE_PERSON

90: v_delim_space NUMBER(2);
91: v_all_given_name IGS_PE_PERSON.given_names%TYPE;
92: CURSOR c_get_given_name (cp_person_id IGS_PE_PERSON.person_id%TYPE) IS
93: SELECT given_names
94: FROM IGS_PE_PERSON
95: WHERE person_id = cp_person_id;
96: BEGIN
97: OPEN c_get_given_name(p_person_id);
98: FETCH c_get_given_name INTO v_all_given_name;

Line 886: 'IGS_PE_PERSON IGS_PS_COURSE,' ||

882: -- Create an entry in the System Log Entry
883: IGS_GE_GEN_003.genp_ins_log_entry(
884: p_s_log_type,
885: p_creation_dt,
886: 'IGS_PE_PERSON IGS_PS_COURSE,' ||
887: TO_CHAR(p_person_id) || ', ' ||
888: p_course_cd,
889: p_message_name,
890: NULL);

Line 943: 'IGS_PE_PERSON IGS_PS_COURSE,' ||

939: --Create an entry in the system log entry
940: IGS_GE_GEN_003.genp_ins_log_entry (
941: p_s_log_type,
942: p_creation_dt,
943: 'IGS_PE_PERSON IGS_PS_COURSE,' ||
944: TO_CHAR(p_person_id) || ', ' ||
945: p_course_cd,
946: 4250,
947: NULL);

Line 992: 'IGS_PE_PERSON IGS_PS_COURSE,' || TO_CHAR(p_person_id) || ', ' || p_course_cd,

988: --Create an entry in the system log entry
989: IGS_GE_GEN_003.genp_ins_log_entry (
990: p_s_log_type,
991: p_creation_dt,
992: 'IGS_PE_PERSON IGS_PS_COURSE,' || TO_CHAR(p_person_id) || ', ' || p_course_cd,
993: 4218,
994: NULL);
995: END IF;
996: END IF;

Line 1040: 'IGS_PE_PERSON IGS_PS_COURSE,' || TO_CHAR(p_person_id) || ', ' || p_course_cd,

1036: --Create an entry in the system log entry
1037: IGS_GE_GEN_003.genp_ins_log_entry (
1038: p_s_log_type,
1039: p_creation_dt,
1040: 'IGS_PE_PERSON IGS_PS_COURSE,' || TO_CHAR(p_person_id) || ', ' || p_course_cd,
1041: 4219,
1042: NULL);
1043: ELSIF c_ase%FOUND AND
1044: v_result_obtained_yr IS NOT NULL THEN

Line 1079: 'IGS_PE_PERSON IGS_PS_COURSE' || ',' || TO_CHAR(p_person_id) || ',' || p_course_cd,

1075: -- create an entry in the system log entry
1076: IGS_GE_GEN_003.genp_ins_log_entry (
1077: p_s_log_type,
1078: p_creation_dt,
1079: 'IGS_PE_PERSON IGS_PS_COURSE' || ',' || TO_CHAR(p_person_id) || ',' || p_course_cd,
1080: 4220,
1081: NULL);
1082: END IF;
1083: -- continue processing after this error has been logged

Line 1127: 'IGS_PE_PERSON IGS_PS_COURSE' || ',' || TO_CHAR(p_person_id) || ',' || p_course_cd,

1123: -- create an entry in the system log entry
1124: IGS_GE_GEN_003.genp_ins_log_entry (
1125: p_s_log_type,
1126: p_creation_dt,
1127: 'IGS_PE_PERSON IGS_PS_COURSE' || ',' || TO_CHAR(p_person_id) || ',' || p_course_cd,
1128: 4901,
1129: NULL);
1130: v_hecs_fee := 9999;
1131: END IF;