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_AD_GEN_001 dependencies on IGS_EN_STDNT_PS_ATT

Line 348: -- Records are deleted from the following IGS_EN_STDNT_PS_ATT

344: -- This module deletes unconfirmed student course attempts that
345: -- were created as a result of an admission course application
346: -- offer that was never accepted. This process will be run
347: -- nightly by the Job Scheduler.
348: -- Records are deleted from the following IGS_EN_STDNT_PS_ATT
349: -- child tables
350: -- Student IGS_PS_UNIT Attempt (and histories)
351: -- Student IGS_PS_UNIT Set Attempt
352: -- Student IGS_PS_COURSE HECS Option

Line 436: FROM igs_en_stdnt_ps_att sca,

432: aa.admission_cat,
433: aa.s_admission_process_type,
434: aors.s_adm_offer_resp_status,
435: aods.s_adm_offer_dfrmnt_status
436: FROM igs_en_stdnt_ps_att sca,
437: igs_ad_ps_appl_inst acaiv,
438: igs_ad_appl aa,
439: igs_ad_ou_stat aos,
440: igs_ad_ofr_resp_stat aors,

Line 473: cp_person_id IGS_EN_STDNT_PS_ATT.person_id%TYPE,

469:
470: l_term c_term%ROWTYPE;
471:
472: CURSOR c_sca_upd(
473: cp_person_id IGS_EN_STDNT_PS_ATT.person_id%TYPE,
474: cp_course_cd IGS_EN_STDNT_PS_ATT.course_cd%TYPE) IS
475: SELECT ROWID, sca.*
476: FROM IGS_EN_STDNT_PS_ATT sca
477: WHERE sca.person_id = cp_person_id AND

Line 474: cp_course_cd IGS_EN_STDNT_PS_ATT.course_cd%TYPE) IS

470: l_term c_term%ROWTYPE;
471:
472: CURSOR c_sca_upd(
473: cp_person_id IGS_EN_STDNT_PS_ATT.person_id%TYPE,
474: cp_course_cd IGS_EN_STDNT_PS_ATT.course_cd%TYPE) IS
475: SELECT ROWID, sca.*
476: FROM IGS_EN_STDNT_PS_ATT sca
477: WHERE sca.person_id = cp_person_id AND
478: sca.course_cd = cp_course_cd

Line 476: FROM IGS_EN_STDNT_PS_ATT sca

472: CURSOR c_sca_upd(
473: cp_person_id IGS_EN_STDNT_PS_ATT.person_id%TYPE,
474: cp_course_cd IGS_EN_STDNT_PS_ATT.course_cd%TYPE) IS
475: SELECT ROWID, sca.*
476: FROM IGS_EN_STDNT_PS_ATT sca
477: WHERE sca.person_id = cp_person_id AND
478: sca.course_cd = cp_course_cd
479: FOR UPDATE OF
480: sca.LAST_UPDATE_DATE NOWAIT;

Line 539: p_person_id IGS_EN_STDNT_PS_ATT.person_id%TYPE,

535: --Who When What
536: --knaraset 29-Apr-03 Modified cursors to have uoo_id reference as part of MUS build bug 2829262
537: --------------------------------------------------------------------------------
538: FUNCTION admpl_del_sua(
539: p_person_id IGS_EN_STDNT_PS_ATT.person_id%TYPE,
540: p_course_cd IGS_EN_STDNT_PS_ATT.course_cd%TYPE)
541: RETURN BOOLEAN
542: IS
543: BEGIN -- admpl_del_sua

Line 540: p_course_cd IGS_EN_STDNT_PS_ATT.course_cd%TYPE)

536: --knaraset 29-Apr-03 Modified cursors to have uoo_id reference as part of MUS build bug 2829262
537: --------------------------------------------------------------------------------
538: FUNCTION admpl_del_sua(
539: p_person_id IGS_EN_STDNT_PS_ATT.person_id%TYPE,
540: p_course_cd IGS_EN_STDNT_PS_ATT.course_cd%TYPE)
541: RETURN BOOLEAN
542: IS
543: BEGIN -- admpl_del_sua
544: -- (1) Delete IGS_EN_SU_ATTEMPT records

Line 611: p_person_id IGS_EN_STDNT_PS_ATT.person_id%TYPE,

607: -- ADMPL_DEL_SUAH ---------------------------------------------------------------
608: --Who When What
609: --------------------------------------------------------------------------------
610: FUNCTION admpl_del_suah(
611: p_person_id IGS_EN_STDNT_PS_ATT.person_id%TYPE,
612: p_course_cd IGS_EN_STDNT_PS_ATT.course_cd%TYPE)
613: RETURN BOOLEAN
614: IS
615: BEGIN -- admpl_del_suah

Line 612: p_course_cd IGS_EN_STDNT_PS_ATT.course_cd%TYPE)

608: --Who When What
609: --------------------------------------------------------------------------------
610: FUNCTION admpl_del_suah(
611: p_person_id IGS_EN_STDNT_PS_ATT.person_id%TYPE,
612: p_course_cd IGS_EN_STDNT_PS_ATT.course_cd%TYPE)
613: RETURN BOOLEAN
614: IS
615: BEGIN -- admpl_del_suah
616: -- Delete IGS_EN_SU_ATTEMPT_H records

Line 686: p_person_id IGS_EN_STDNT_PS_ATT.person_id%TYPE,

682: --------------------------------------------------------------------------------
683: -- ADMPL_DEL_SUSA --------------------------------------------------------------
684: --------------------------------------------------------------------------------
685: FUNCTION admpl_del_susa(
686: p_person_id IGS_EN_STDNT_PS_ATT.person_id%TYPE,
687: p_course_cd IGS_EN_STDNT_PS_ATT.course_cd%TYPE)
688: RETURN BOOLEAN
689: IS
690: BEGIN -- admpl_del_susa

Line 687: p_course_cd IGS_EN_STDNT_PS_ATT.course_cd%TYPE)

683: -- ADMPL_DEL_SUSA --------------------------------------------------------------
684: --------------------------------------------------------------------------------
685: FUNCTION admpl_del_susa(
686: p_person_id IGS_EN_STDNT_PS_ATT.person_id%TYPE,
687: p_course_cd IGS_EN_STDNT_PS_ATT.course_cd%TYPE)
688: RETURN BOOLEAN
689: IS
690: BEGIN -- admpl_del_susa
691: -- (2) Delete IGS_AS_SU_SETATMPT records

Line 904: p_person_id IGS_EN_STDNT_PS_ATT.person_id%TYPE,

900: --------------------------------------------------------------------------------
901: -- ADMPL_DEL_SCHO --------------------------------------------------------------
902: --------------------------------------------------------------------------------
903: FUNCTION admpl_del_scho(
904: p_person_id IGS_EN_STDNT_PS_ATT.person_id%TYPE,
905: p_course_cd IGS_EN_STDNT_PS_ATT.course_cd%TYPE)
906: RETURN BOOLEAN
907: IS
908: BEGIN -- admpl_del_scho

Line 905: p_course_cd IGS_EN_STDNT_PS_ATT.course_cd%TYPE)

901: -- ADMPL_DEL_SCHO --------------------------------------------------------------
902: --------------------------------------------------------------------------------
903: FUNCTION admpl_del_scho(
904: p_person_id IGS_EN_STDNT_PS_ATT.person_id%TYPE,
905: p_course_cd IGS_EN_STDNT_PS_ATT.course_cd%TYPE)
906: RETURN BOOLEAN
907: IS
908: BEGIN -- admpl_del_scho
909: -- (3) Delete IGS_EN_STDNTPSHECSOP records

Line 972: p_person_id IGS_EN_STDNT_PS_ATT.person_id%TYPE,

968: --------------------------------------------------------------------------------
969: -- ADMPL_DEL_SCAE --------------------------------------------------------------
970: --------------------------------------------------------------------------------
971: FUNCTION admpl_del_scae(
972: p_person_id IGS_EN_STDNT_PS_ATT.person_id%TYPE,
973: p_course_cd IGS_EN_STDNT_PS_ATT.course_cd%TYPE)
974: RETURN BOOLEAN IS
975: BEGIN -- admpl_del_scae
976: -- (4) Delete IGS_AS_SC_ATMPT_ENR scae

Line 973: p_course_cd IGS_EN_STDNT_PS_ATT.course_cd%TYPE)

969: -- ADMPL_DEL_SCAE --------------------------------------------------------------
970: --------------------------------------------------------------------------------
971: FUNCTION admpl_del_scae(
972: p_person_id IGS_EN_STDNT_PS_ATT.person_id%TYPE,
973: p_course_cd IGS_EN_STDNT_PS_ATT.course_cd%TYPE)
974: RETURN BOOLEAN IS
975: BEGIN -- admpl_del_scae
976: -- (4) Delete IGS_AS_SC_ATMPT_ENR scae
977: DECLARE

Line 1167: p_person_id IGS_EN_STDNT_PS_ATT.person_id%TYPE,

1163: -- ADMPL_DEL_GUA ---------------------------------------------------------------
1164: --Who When What
1165: --------------------------------------------------------------------------------
1166: FUNCTION admpl_del_gua(
1167: p_person_id IGS_EN_STDNT_PS_ATT.person_id%TYPE,
1168: p_course_cd IGS_EN_STDNT_PS_ATT.course_cd%TYPE)
1169: RETURN BOOLEAN
1170: IS
1171: BEGIN -- admpl_del_gua

Line 1168: p_course_cd IGS_EN_STDNT_PS_ATT.course_cd%TYPE)

1164: --Who When What
1165: --------------------------------------------------------------------------------
1166: FUNCTION admpl_del_gua(
1167: p_person_id IGS_EN_STDNT_PS_ATT.person_id%TYPE,
1168: p_course_cd IGS_EN_STDNT_PS_ATT.course_cd%TYPE)
1169: RETURN BOOLEAN
1170: IS
1171: BEGIN -- admpl_del_gua
1172: -- Delete IGS_GR_GRADUAND_PKG records

Line 1336: p_person_id IGS_EN_STDNT_PS_ATT.person_id%TYPE,

1332: -- ADMPL_DEL_GSA ---------------------------------------------------------------
1333: --Who When What
1334: --------------------------------------------------------------------------------
1335: FUNCTION admpl_del_gsa(
1336: p_person_id IGS_EN_STDNT_PS_ATT.person_id%TYPE,
1337: p_course_cd IGS_EN_STDNT_PS_ATT.course_cd%TYPE)
1338: RETURN BOOLEAN
1339: IS
1340: BEGIN -- admpl_del_gsa

Line 1337: p_course_cd IGS_EN_STDNT_PS_ATT.course_cd%TYPE)

1333: --Who When What
1334: --------------------------------------------------------------------------------
1335: FUNCTION admpl_del_gsa(
1336: p_person_id IGS_EN_STDNT_PS_ATT.person_id%TYPE,
1337: p_course_cd IGS_EN_STDNT_PS_ATT.course_cd%TYPE)
1338: RETURN BOOLEAN
1339: IS
1340: BEGIN -- admpl_del_gsa
1341: -- (1) Delete IGS_GR_SPECIAL_AWARD records

Line 1406: p_person_id IGS_EN_STDNT_PS_ATT.person_id%TYPE,

1402: App_Exception.Raise_Exception;
1403: END admpl_del_gsa;
1404:
1405: FUNCTION admpl_del_psaa(
1406: p_person_id IGS_EN_STDNT_PS_ATT.person_id%TYPE,
1407: p_course_cd IGS_EN_STDNT_PS_ATT.course_cd%TYPE)
1408: RETURN BOOLEAN
1409: IS
1410: BEGIN -- admpl_del_psaa

Line 1407: p_course_cd IGS_EN_STDNT_PS_ATT.course_cd%TYPE)

1403: END admpl_del_gsa;
1404:
1405: FUNCTION admpl_del_psaa(
1406: p_person_id IGS_EN_STDNT_PS_ATT.person_id%TYPE,
1407: p_course_cd IGS_EN_STDNT_PS_ATT.course_cd%TYPE)
1408: RETURN BOOLEAN
1409: IS
1410: BEGIN -- admpl_del_psaa
1411: -- Delete IGS_PS_STDNT_APV_ALT records

Line 1479: p_person_id IGS_EN_STDNT_PS_ATT.person_id%TYPE,

1475: -- ADMPL_DEL_PSSR ---------------------------------------------------------------
1476: --Who When What
1477: --------------------------------------------------------------------------------
1478: FUNCTION admpl_del_pssr(
1479: p_person_id IGS_EN_STDNT_PS_ATT.person_id%TYPE,
1480: p_course_cd IGS_EN_STDNT_PS_ATT.course_cd%TYPE)
1481: RETURN BOOLEAN
1482: IS
1483: BEGIN -- admpl_del_pssr

Line 1480: p_course_cd IGS_EN_STDNT_PS_ATT.course_cd%TYPE)

1476: --Who When What
1477: --------------------------------------------------------------------------------
1478: FUNCTION admpl_del_pssr(
1479: p_person_id IGS_EN_STDNT_PS_ATT.person_id%TYPE,
1480: p_course_cd IGS_EN_STDNT_PS_ATT.course_cd%TYPE)
1481: RETURN BOOLEAN
1482: IS
1483: BEGIN -- admpl_del_pssr
1484: -- Delete IGS_PS_STDNT_SPL_REQ records

Line 1553: p_person_id IGS_EN_STDNT_PS_ATT.person_id%TYPE,

1549: -- ADMPL_DEL_ESAA ---------------------------------------------------------------
1550: --Who When What
1551: --------------------------------------------------------------------------------
1552: FUNCTION admpl_del_esaa(
1553: p_person_id IGS_EN_STDNT_PS_ATT.person_id%TYPE,
1554: p_course_cd IGS_EN_STDNT_PS_ATT.course_cd%TYPE)
1555: RETURN BOOLEAN
1556: IS
1557: BEGIN -- admpl_del_esaa

Line 1554: p_course_cd IGS_EN_STDNT_PS_ATT.course_cd%TYPE)

1550: --Who When What
1551: --------------------------------------------------------------------------------
1552: FUNCTION admpl_del_esaa(
1553: p_person_id IGS_EN_STDNT_PS_ATT.person_id%TYPE,
1554: p_course_cd IGS_EN_STDNT_PS_ATT.course_cd%TYPE)
1555: RETURN BOOLEAN
1556: IS
1557: BEGIN -- admpl_del_esaa
1558: -- Delete IGS_EN_SPA_AWD_AIM records

Line 1623: p_person_id IGS_EN_STDNT_PS_ATT.person_id%TYPE,

1619: -- ADMPL_DEL_HSSA ---------------------------------------------------------------
1620: --Who When What
1621: --------------------------------------------------------------------------------
1622: FUNCTION admpl_del_hssa(
1623: p_person_id IGS_EN_STDNT_PS_ATT.person_id%TYPE,
1624: p_course_cd IGS_EN_STDNT_PS_ATT.course_cd%TYPE)
1625: RETURN BOOLEAN
1626: IS
1627: BEGIN -- admpl_del_hssa

Line 1624: p_course_cd IGS_EN_STDNT_PS_ATT.course_cd%TYPE)

1620: --Who When What
1621: --------------------------------------------------------------------------------
1622: FUNCTION admpl_del_hssa(
1623: p_person_id IGS_EN_STDNT_PS_ATT.person_id%TYPE,
1624: p_course_cd IGS_EN_STDNT_PS_ATT.course_cd%TYPE)
1625: RETURN BOOLEAN
1626: IS
1627: BEGIN -- admpl_del_hssa
1628: -- Delete IGS_HE_ST_SPA_ALL records

Line 1750: p_person_id IGS_EN_STDNT_PS_ATT.person_id%TYPE,

1746: -- ADMPL_UPD_PR_RULE_APPL ---------------------------------------------------------------
1747: --Who When What
1748: --------------------------------------------------------------------------------
1749: FUNCTION admpl_upd_pr_rule_appl(
1750: p_person_id IGS_EN_STDNT_PS_ATT.person_id%TYPE,
1751: p_course_cd IGS_EN_STDNT_PS_ATT.course_cd%TYPE)
1752: RETURN BOOLEAN
1753: IS
1754: BEGIN -- admpl_upd_pr_rule_appl

Line 1751: p_course_cd IGS_EN_STDNT_PS_ATT.course_cd%TYPE)

1747: --Who When What
1748: --------------------------------------------------------------------------------
1749: FUNCTION admpl_upd_pr_rule_appl(
1750: p_person_id IGS_EN_STDNT_PS_ATT.person_id%TYPE,
1751: p_course_cd IGS_EN_STDNT_PS_ATT.course_cd%TYPE)
1752: RETURN BOOLEAN
1753: IS
1754: BEGIN -- admpl_upd_pr_rule_appl
1755: -- Delete IGS_PR_RU_APPL_ALL records

Line 1849: p_person_id IGS_EN_STDNT_PS_ATT.person_id%TYPE,

1845: -- ADMPL_DEL_HSSC ---------------------------------------------------------------
1846: --Who When What
1847: --------------------------------------------------------------------------------
1848: FUNCTION admpl_del_hssc(
1849: p_person_id IGS_EN_STDNT_PS_ATT.person_id%TYPE,
1850: p_course_cd IGS_EN_STDNT_PS_ATT.course_cd%TYPE)
1851: RETURN BOOLEAN
1852: IS
1853: BEGIN -- admpl_del_hssc

Line 1850: p_course_cd IGS_EN_STDNT_PS_ATT.course_cd%TYPE)

1846: --Who When What
1847: --------------------------------------------------------------------------------
1848: FUNCTION admpl_del_hssc(
1849: p_person_id IGS_EN_STDNT_PS_ATT.person_id%TYPE,
1850: p_course_cd IGS_EN_STDNT_PS_ATT.course_cd%TYPE)
1851: RETURN BOOLEAN
1852: IS
1853: BEGIN -- admpl_del_hssc
1854: -- Delete IGS_HE_ST_SPA_CC records

Line 2169: IGS_EN_STDNT_PS_ATT_PKG.DELETE_ROW(v_sca_upd_exists.rowid);

2165: END IF;
2166:
2167: -- Validate if student program attempt can be deleted
2168: IF NOT v_process_next AND v_delete_sca_ind = 'Y' THEN
2169: IGS_EN_STDNT_PS_ATT_PKG.DELETE_ROW(v_sca_upd_exists.rowid);
2170: admpl_del_ins_log_entry (
2171: p_message_name => NULL,
2172: p_default_msg_txt => NULL,
2173: p_sca_deleted_ind => 'Y',

Line 2189: l_entity_name := 'IGS_EN_STDNT_PS_ATT_ALL';

2185:
2186: CLOSE c_sca_upd;
2187: EXCEPTION
2188: WHEN e_resource_busy THEN
2189: l_entity_name := 'IGS_EN_STDNT_PS_ATT_ALL';
2190: FND_MESSAGE.SET_NAME('IGS','IGS_AD_UNCONF_SCA_REC_LOCKED');
2191: FND_MESSAGE.SET_TOKEN('ENTITY',l_entity_name);
2192: IGS_GE_MSG_STACK.ADD;
2193: extract_msg_from_stack(l_msg_at_index);