DBA Data[Home] [Help]

APPS.IGS_AD_PG_DATA_LOAD dependencies on IGS_AD_PRC_TAC_OFFER

Line 233: IF IGS_AD_PRC_TAC_OFFER.ADMP_INS_TAC_PRSN(

229:
230: -- This module uses information from the TAC offer load process
231: -- to create person and alternate person ID records if they
232: -- don't already exist
233: IF IGS_AD_PRC_TAC_OFFER.ADMP_INS_TAC_PRSN(
234: G_pg_match_person_id,
235: vtac_id_num,
236: vtac_surname,
237: G_vtac_pg_all_given_names,

Line 407: IF IGS_AD_PRC_TAC_OFFER.ADMP_INS_PERSON_ADDR(

403:
404: G_pg_ret_val := 0;
405:
406: --Procedure inserts a new person address record
407: IF IGS_AD_PRC_TAC_OFFER.ADMP_INS_PERSON_ADDR(
408: G_pg_current_person_id,
409: p_aus_addr_type,
410: SYSDATE,
411: p_vtac_street_name,

Line 433: IF IGS_AD_PRC_TAC_OFFER.ADMP_INS_PERSON_ADDR(

429: ELSE
430:
431: G_pg_ret_val := 0;
432: --Procedure inserts a new person address record
433: IF IGS_AD_PRC_TAC_OFFER.ADMP_INS_PERSON_ADDR(
434: G_pg_current_person_id,
435: p_os_addr_type,
436: SYSDATE,
437: p_vtac_street_name,

Line 540: IF IGS_AD_PRC_TAC_OFFER.ADMP_INS_TAC_COURSE(

536:
537: G_pg_ret_val := 0;
538:
539: -- Inserts TAC details to form an admission course
540: IF IGS_AD_PRC_TAC_OFFER.ADMP_INS_TAC_COURSE(
541: p_acad_cal_type,
542: p_acad_seq_num,
543: p_adm_cal_type,
544: p_adm_seq_num,

Line 705: IF IGS_AD_PRC_TAC_OFFER.ADMP_INS_TERT_EDU(

701: vtac_tert_qual := RTRIM(SUBSTR(po_sec_str(k),23,10));
702:
703: G_pg_ret_val := 0;
704: -- Insert a tertiary education record
705: IF IGS_AD_PRC_TAC_OFFER.ADMP_INS_TERT_EDU(
706: G_pg_current_person_id,
707: 'N', --exclusion indiacator
708: vtac_tert_status,
709: start_yr,