APPS.IGS_AD_GEN_001 dependencies on IGS_HE_ST_SPA_UT_ALL

Line 1648: cp_person_id IGS_HE_ST_SPA_UT_ALL.person_id%TYPE,

1644:
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

Line 1651: FROM IGS_HE_ST_SPA_UT_ALL hssua

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 ;
1654:
1655: CURSOR c_hssua_del (

Line 1656: cp_hesa_st_spau_id IGS_HE_ST_SPA_UT_ALL.hesa_st_spau_id%TYPE) IS

1652: WHERE hssua.person_id = cp_person_id AND
1653: hssua.course_cd = cp_course_cd ;
1654:
1655: CURSOR c_hssua_del (
1656: cp_hesa_st_spau_id IGS_HE_ST_SPA_UT_ALL.hesa_st_spau_id%TYPE) IS
1657: SELECT rowid
1658: FROM IGS_HE_ST_SPA_UT_ALL hssua
1659: WHERE hssua.hesa_st_spau_id = cp_hesa_st_spau_id
1660: FOR UPDATE OF hssua.LAST_UPDATE_DATE NOWAIT ;

Line 1658: FROM IGS_HE_ST_SPA_UT_ALL hssua

1654:
1655: CURSOR c_hssua_del (
1656: cp_hesa_st_spau_id IGS_HE_ST_SPA_UT_ALL.hesa_st_spau_id%TYPE) IS
1657: SELECT rowid
1658: FROM IGS_HE_ST_SPA_UT_ALL hssua
1659: WHERE hssua.hesa_st_spau_id = cp_hesa_st_spau_id
1660: FOR UPDATE OF hssua.LAST_UPDATE_DATE NOWAIT ;
1661:
1662:

Line 1671: -- Delete unconfirmed IGS_HE_ST_SPA_UT_ALL records

1667:
1668: FOR v_hssua_rec IN c_hssua (v_hssa_rec.person_id,
1669: v_hssa_rec.course_cd ) LOOP
1670: BEGIN
1671: -- Delete unconfirmed IGS_HE_ST_SPA_UT_ALL records
1672: FOR v_hssua_del_rec in c_hssua_del(
1673: v_hssua_rec.hesa_st_spau_id) LOOP
1674: IGS_HE_ST_SPA_UT_ALL_PKG.DELETE_ROW(
1675: X_ROWID => v_hssua_del_rec.ROWID );

Line 1674: IGS_HE_ST_SPA_UT_ALL_PKG.DELETE_ROW(

1670: BEGIN
1671: -- Delete unconfirmed IGS_HE_ST_SPA_UT_ALL records
1672: FOR v_hssua_del_rec in c_hssua_del(
1673: v_hssua_rec.hesa_st_spau_id) LOOP
1674: IGS_HE_ST_SPA_UT_ALL_PKG.DELETE_ROW(
1675: X_ROWID => v_hssua_del_rec.ROWID );
1676:
1677: END LOOP;
1678: EXCEPTION

Line 1683: l_entity_name := 'IGS_HE_ST_SPA_UT_ALL';

1679: WHEN e_resource_busy THEN
1680: IF c_hssua_del%ISOPEN THEN
1681: CLOSE c_hssua_del;
1682: END IF;
1683: l_entity_name := 'IGS_HE_ST_SPA_UT_ALL';
1684: EXIT;
1685: END;
1686:
1687: END LOOP;