APPS.IGS_AD_GRD_DATA_LOAD dependencies on IGS_AD_PRC_TAC_OFFER

Line 221: IF IGS_AD_PRC_TAC_OFFER.ADMP_INS_TAC_PRSN(

217:
218: -- This module uses information from the TAC offer load process
219: -- to create person and alternate person ID records if they
220: -- don't already exist.
221: IF IGS_AD_PRC_TAC_OFFER.ADMP_INS_TAC_PRSN(
222: G_match_person_id,
223: vtac_id_num,
224: vtac_surname,
225: G_vtac_all_given_names,

Line 377: IF IGS_AD_PRC_TAC_OFFER.ADMP_INS_PERSON_ADDR(

373: aust_address := 'FALSE';
374: END IF;
375:
376: IF aust_address = 'TRUE' THEN
377: IF IGS_AD_PRC_TAC_OFFER.ADMP_INS_PERSON_ADDR(
378: G_current_person_id,
379: p_aus_addr_type,
380: SYSDATE,
381: p_vtac_addr1,

Line 396: IF IGS_AD_PRC_TAC_OFFER.ADMP_INS_PERSON_ADDR(

392: FND_FILE.PUT_LINE( FND_FILE.LOG,G_current_person_id||' '||RTRIM(G_message_str));
393: END IF;
394:
395: ELSE
396: IF IGS_AD_PRC_TAC_OFFER.ADMP_INS_PERSON_ADDR(
397: G_current_person_id,
398: p_os_addr_type,
399: SYSDATE,
400: p_vtac_addr1,

Line 528: IF IGS_AD_PRC_TAC_OFFER.ADMP_INS_TAC_COURSE(

524: END IF;
525:
526: G_ret_val := 0;
527: -- Inserts TAC details to form an admission course
528: IF IGS_AD_PRC_TAC_OFFER.ADMP_INS_TAC_COURSE(
529: p_acad_cal_type,
530: p_acad_seq_num,
531: p_adm_cal_type,
532: p_adm_seq_num,

Line 737: IF IGS_AD_PRC_TAC_OFFER.ADMP_INS_AUS_SCN_EDU(

733: score := score/100;
734:
735: G_ret_val := 0;
736: -- This procedure inserts a new aus_scndry_education record
737: IF IGS_AD_PRC_TAC_OFFER.ADMP_INS_AUS_SCN_EDU(
738: G_current_person_id,
739: result_yr,
740: score,
741: vtac_state_name,

Line 808: IF IGS_AD_PRC_TAC_OFFER.ADMP_INS_AUS_SCN_SUB(

804: OPEN c_dup_chk;
805: FETCH c_dup_chk into v_dummy;
806: IF (c_dup_chk%NOTFOUND) THEN
807: -- Insert an Australian secondary education subject record
808: IF IGS_AD_PRC_TAC_OFFER.ADMP_INS_AUS_SCN_SUB(
809: G_current_person_id,
810: ase_sequence_number,
811: sub_result_yr,
812: vtac_subject_code,

Line 959: IF IGS_AD_PRC_TAC_OFFER.ADMP_INS_TERT_EDU(

955: vtac_post_sec_inst_name := RTRIM(SUBSTR(po_sec_str(k),15,12));
956:
957: G_ret_val := 0;
958: -- Insert a tertiary education record
959: IF IGS_AD_PRC_TAC_OFFER.ADMP_INS_TERT_EDU(
960: G_current_person_id,
961: 'N',
962: vtac_post_sec_compl,
963: start_yr,

Line 1056: IF (IGS_AD_PRC_TAC_OFFER.ADMP_INS_TERT_EDU(

1052:
1053:
1054: G_ret_val := 0;
1055: -- Insert a tertiary education record
1056: IF (IGS_AD_PRC_TAC_OFFER.ADMP_INS_TERT_EDU(
1057: G_current_person_id,
1058: 'N',
1059: vtac_post_sec_ccode_ov,
1060: start_yr,