APPS.IGS_PS_GEN_001 dependencies on IGS_PS_VER_RU

Line 1719: v_new_rul_seq_number IGS_PS_VER_RU.rul_sequence_number%TYPE;

1715: PROCEDURE crspl_ins_cvr_rec
1716: AS
1717: BEGIN
1718: DECLARE
1719: v_new_rul_seq_number IGS_PS_VER_RU.rul_sequence_number%TYPE;
1720: CURSOR c_cvr IS
1721: SELECT cvr.s_rule_call_cd,
1722: cvr.rul_sequence_number
1723: FROM IGS_PS_VER_RU cvr

Line 1723: FROM IGS_PS_VER_RU cvr

1719: v_new_rul_seq_number IGS_PS_VER_RU.rul_sequence_number%TYPE;
1720: CURSOR c_cvr IS
1721: SELECT cvr.s_rule_call_cd,
1722: cvr.rul_sequence_number
1723: FROM IGS_PS_VER_RU cvr
1724: WHERE cvr.course_cd = p_old_course_cd AND
1725: cvr.version_number = p_old_version_number;
1726: BEGIN
1727: FOR v_cvr_rec IN c_cvr LOOP

Line 1733: IGS_PS_VER_RU_PKG.INSERT_ROW(

1729: v_new_rul_seq_number := IGS_RU_GEN_003.rulp_ins_copy_rule(
1730: v_cvr_rec.s_rule_call_cd,
1731: v_cvr_rec.rul_sequence_number);
1732: x_rowid := NULL;
1733: IGS_PS_VER_RU_PKG.INSERT_ROW(
1734: X_ROWID => x_rowid,
1735: X_COURSE_CD => p_new_course_cd,
1736: X_VERSION_NUMBER => p_new_version_number,
1737: X_S_RULE_CALL_CD => v_cvr_rec.s_rule_call_cd,

Line 2036: -- calling procedure to insert IGS_PS_VER_RU records

2032:
2033: -- calling procedure to insert IGS_PS_STAGE records and its
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: