APPS.IGS_AD_GEN_001 dependencies on IGS_HE_ST_SPA_ALL

Line 1628: -- Delete IGS_HE_ST_SPA_ALL records

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
1629: DECLARE
1630: CURSOR c_hssa IS
1631: SELECT hesa_st_spa_id,
1632: person_id,

Line 1634: FROM IGS_HE_ST_SPA_ALL hssa

1630: CURSOR c_hssa IS
1631: SELECT hesa_st_spa_id,
1632: person_id,
1633: course_cd
1634: FROM IGS_HE_ST_SPA_ALL hssa
1635: WHERE hssa.person_id = p_person_id AND
1636: hssa.course_cd = p_course_cd;
1637:
1638: CURSOR c_hssa_del (

Line 1639: cp_hesa_st_spa_id IGS_HE_ST_SPA_ALL.hesa_st_spa_id%TYPE) IS

1635: WHERE hssa.person_id = p_person_id AND
1636: hssa.course_cd = p_course_cd;
1637:
1638: CURSOR c_hssa_del (
1639: cp_hesa_st_spa_id IGS_HE_ST_SPA_ALL.hesa_st_spa_id%TYPE) IS
1640: SELECT rowid
1641: FROM IGS_HE_ST_SPA_ALL hssa
1642: WHERE hssa.hesa_st_spa_id = cp_hesa_st_spa_id
1643: FOR UPDATE OF hssa.LAST_UPDATE_DATE NOWAIT ;

Line 1641: FROM IGS_HE_ST_SPA_ALL hssa

1637:
1638: CURSOR c_hssa_del (
1639: cp_hesa_st_spa_id IGS_HE_ST_SPA_ALL.hesa_st_spa_id%TYPE) IS
1640: SELECT rowid
1641: FROM IGS_HE_ST_SPA_ALL hssa
1642: WHERE hssa.hesa_st_spa_id = cp_hesa_st_spa_id
1643: FOR UPDATE OF hssa.LAST_UPDATE_DATE NOWAIT ;
1644:
1645: v_hssa_del_exists c_hssa_del%ROWTYPE;

Line 1649: cp_course_cd IGS_HE_ST_SPA_ALL.course_cd%TYPE) IS

1645: v_hssa_del_exists c_hssa_del%ROWTYPE;
1646:
1647: CURSOR c_hssua (
1648: cp_person_id IGS_HE_ST_SPA_UT_ALL.person_id%TYPE,
1649: cp_course_cd IGS_HE_ST_SPA_ALL.course_cd%TYPE) IS
1650: SELECT hesa_st_spau_id
1651: FROM IGS_HE_ST_SPA_UT_ALL hssua
1652: WHERE hssua.person_id = cp_person_id AND
1653: hssua.course_cd = cp_course_cd ;

Line 1692: -- Delete IGS_HE_ST_SPA_ALL records

1688: IF l_entity_name IS NOT NULL THEN
1689: EXIT;
1690: END IF;
1691:
1692: -- Delete IGS_HE_ST_SPA_ALL records
1693: FOR v_hssa_del_exists IN c_hssa_del(v_hssa_rec.hesa_st_spa_id) LOOP
1694:
1695: IGS_HE_ST_SPA_ALL_PKG.DELETE_ROW(
1696: X_ROWID => v_hssa_del_exists.rowid );

Line 1695: IGS_HE_ST_SPA_ALL_PKG.DELETE_ROW(

1691:
1692: -- Delete IGS_HE_ST_SPA_ALL records
1693: FOR v_hssa_del_exists IN c_hssa_del(v_hssa_rec.hesa_st_spa_id) LOOP
1694:
1695: IGS_HE_ST_SPA_ALL_PKG.DELETE_ROW(
1696: X_ROWID => v_hssa_del_exists.rowid );
1697: END LOOP;
1698:
1699: END LOOP;

Line 1720: l_entity_name := 'IGS_HE_ST_SPA_ALL';

1716: END IF;
1717: IF c_hssua_del%ISOPEN THEN
1718: CLOSE c_hssua_del;
1719: END IF;
1720: l_entity_name := 'IGS_HE_ST_SPA_ALL';
1721: RETURN FALSE;
1722: WHEN OTHERS THEN
1723: IF c_hssa%ISOPEN THEN
1724: CLOSE c_hssa;

Line 2009: -- Delete IGS_HE_ST_SPA_ALL Records (5)

2005: v_process_next := TRUE;
2006: END IF;
2007: END IF;
2008:
2009: -- Delete IGS_HE_ST_SPA_ALL Records (5)
2010: IF NOT v_process_next THEN
2011: IF NOT admpl_del_hssa(
2012: v_sca_rec.person_id,
2013: v_sca_rec.course_cd) THEN