APPS.IGS_PS_GEN_001 dependencies on IGS_RE_DFLT_MS_SET

Line 1773: v_seq_num IGS_RE_DFLT_MS_SET.sequence_number%TYPE;

1769: AS
1770:
1771: BEGIN
1772: DECLARE
1773: v_seq_num IGS_RE_DFLT_MS_SET.sequence_number%TYPE;
1774: l_org_id NUMBER(15);
1775: CURSOR c_dms IS
1776: SELECT dms.milestone_type,
1777: dms.attendance_type,

Line 1781: FROM IGS_RE_DFLT_MS_SET dms

1777: dms.attendance_type,
1778: dms.attendance_mode,
1779: dms.offset_days,
1780: dms.comments
1781: FROM IGS_RE_DFLT_MS_SET dms
1782: WHERE dms.course_cd = p_old_course_cd AND
1783: dms.version_number = p_old_version_number;
1784: CURSOR c_dms_seq IS
1785: SELECT IGS_RE_DFLT_MS_SET_SEQ_NUM_S.NEXTVAL

Line 1785: SELECT IGS_RE_DFLT_MS_SET_SEQ_NUM_S.NEXTVAL

1781: FROM IGS_RE_DFLT_MS_SET dms
1782: WHERE dms.course_cd = p_old_course_cd AND
1783: dms.version_number = p_old_version_number;
1784: CURSOR c_dms_seq IS
1785: SELECT IGS_RE_DFLT_MS_SET_SEQ_NUM_S.NEXTVAL
1786: FROM DUAL;
1787: BEGIN
1788: FOR v_dms_rec IN c_dms LOOP
1789: BEGIN

Line 1795: IGS_RE_DFLT_MS_SET_PKG.INSERT_ROW(

1791: FETCH c_dms_seq INTO v_seq_num;
1792: CLOSE c_dms_seq;
1793: x_rowid := NULL;
1794: l_org_id := IGS_GE_GEN_003.get_org_id;
1795: IGS_RE_DFLT_MS_SET_PKG.INSERT_ROW(
1796: X_ROWID => x_rowid,
1797: X_COURSE_CD => p_new_course_cd,
1798: X_VERSION_NUMBER => p_new_version_number,
1799: X_MILESTONE_TYPE => v_dms_rec.milestone_type,

Line 2038: -- calling procedure to insert IGS_RE_DFLT_MS_SET records

2034: -- child records
2035: crspl_ins_cst_rec;
2036: -- calling procedure to insert IGS_PS_VER_RU records
2037: crspl_ins_cvr_rec;
2038: -- calling procedure to insert IGS_RE_DFLT_MS_SET records
2039: crspl_ins_dms_rec;
2040:
2041: --Enh#3345205, calling procedure to insert IGS_EN_PSV_TERM_IT records
2042: crsp_ins_term_instr_time;