APPS.IGS_AD_GEN_001 dependencies on IGS_HE_ST_SPA_CC

Line 1854: -- Delete IGS_HE_ST_SPA_CC records

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
1855: DECLARE
1856: CURSOR c_hssc IS
1857: SELECT he_spa_cc_id
1858: FROM IGS_HE_ST_SPA_CC hssc

Line 1858: FROM IGS_HE_ST_SPA_CC hssc

1854: -- Delete IGS_HE_ST_SPA_CC records
1855: DECLARE
1856: CURSOR c_hssc IS
1857: SELECT he_spa_cc_id
1858: FROM IGS_HE_ST_SPA_CC hssc
1859: WHERE hssc.person_id = p_person_id AND
1860: hssc.course_cd = p_course_cd;
1861:
1862: CURSOR c_hssc_del (cp_he_spa_cc_id IGS_HE_ST_SPA_CC.he_spa_cc_id%TYPE) IS

Line 1862: CURSOR c_hssc_del (cp_he_spa_cc_id IGS_HE_ST_SPA_CC.he_spa_cc_id%TYPE) IS

1858: FROM IGS_HE_ST_SPA_CC hssc
1859: WHERE hssc.person_id = p_person_id AND
1860: hssc.course_cd = p_course_cd;
1861:
1862: CURSOR c_hssc_del (cp_he_spa_cc_id IGS_HE_ST_SPA_CC.he_spa_cc_id%TYPE) IS
1863: SELECT rowid
1864: FROM IGS_HE_ST_SPA_CC hssc
1865: WHERE hssc.he_spa_cc_id = cp_he_spa_cc_id
1866: FOR UPDATE OF hssc.LAST_UPDATE_DATE NOWAIT ;

Line 1864: FROM IGS_HE_ST_SPA_CC hssc

1860: hssc.course_cd = p_course_cd;
1861:
1862: CURSOR c_hssc_del (cp_he_spa_cc_id IGS_HE_ST_SPA_CC.he_spa_cc_id%TYPE) IS
1863: SELECT rowid
1864: FROM IGS_HE_ST_SPA_CC hssc
1865: WHERE hssc.he_spa_cc_id = cp_he_spa_cc_id
1866: FOR UPDATE OF hssc.LAST_UPDATE_DATE NOWAIT ;
1867:
1868: v_hssc_del_exists c_hssc_del%ROWTYPE;

Line 1876: -- Delete IGS_HE_ST_SPA_CC records

1872:
1873: v_error_flag := FALSE;
1874:
1875: FOR v_hssc_rec IN c_hssc LOOP
1876: -- Delete IGS_HE_ST_SPA_CC records
1877: FOR v_hssc_del_exists IN c_hssc_del(v_hssc_rec.he_spa_cc_id) LOOP
1878:
1879: IGS_HE_ST_SPA_CC_PKG.DELETE_ROW(
1880: X_ROWID => v_hssc_del_exists.ROWID );

Line 1879: IGS_HE_ST_SPA_CC_PKG.DELETE_ROW(

1875: FOR v_hssc_rec IN c_hssc LOOP
1876: -- Delete IGS_HE_ST_SPA_CC records
1877: FOR v_hssc_del_exists IN c_hssc_del(v_hssc_rec.he_spa_cc_id) LOOP
1878:
1879: IGS_HE_ST_SPA_CC_PKG.DELETE_ROW(
1880: X_ROWID => v_hssc_del_exists.ROWID );
1881: END LOOP;
1882: END LOOP;
1883:

Line 1894: l_entity_name := 'IGS_HE_ST_SPA_CC';

1890: END IF;
1891: IF c_hssc_del%ISOPEN THEN
1892: CLOSE c_hssc_del;
1893: END IF;
1894: l_entity_name := 'IGS_HE_ST_SPA_CC';
1895: RETURN FALSE;
1896: WHEN OTHERS THEN
1897: IF c_hssc%ISOPEN THEN
1898: CLOSE c_hssc;

Line 1998: -- Delete IGS_HE_ST_SPA_CC Records (4)

1994: v_process_next := TRUE;
1995: END IF;
1996: END IF;
1997:
1998: -- Delete IGS_HE_ST_SPA_CC Records (4)
1999: IF NOT v_process_next THEN
2000: IF NOT admpl_del_hssc(
2001: v_sca_rec.person_id,
2002: v_sca_rec.course_cd) THEN