APPS.IGS_PS_GEN_001 dependencies on IGS_PS_STAGE

Line 1622: -- inserts into IGS_PS_STAGE and its child table IGS_PS_STAGE_RU table

1618: ELSE
1619: App_Exception.Raise_Exception;
1620: END IF;
1621: END crsp_ins_cvn_rec;
1622: -- inserts into IGS_PS_STAGE and its child table IGS_PS_STAGE_RU table
1623: PROCEDURE crspl_ins_cst_rec
1624: AS
1625: BEGIN
1626: DECLARE

Line 1627: v_cst_seq_num IGS_PS_STAGE.sequence_number%TYPE;

1623: PROCEDURE crspl_ins_cst_rec
1624: AS
1625: BEGIN
1626: DECLARE
1627: v_cst_seq_num IGS_PS_STAGE.sequence_number%TYPE;
1628: v_new_rul_seq_num IGS_PS_STAGE_RU.rul_sequence_number%TYPE;
1629: CURSOR c_cst_seq_num IS
1630: SELECT IGS_PS_STAGE_SEQ_NUM_S.NEXTVAL
1631: FROM DUAL;

Line 1628: v_new_rul_seq_num IGS_PS_STAGE_RU.rul_sequence_number%TYPE;

1624: AS
1625: BEGIN
1626: DECLARE
1627: v_cst_seq_num IGS_PS_STAGE.sequence_number%TYPE;
1628: v_new_rul_seq_num IGS_PS_STAGE_RU.rul_sequence_number%TYPE;
1629: CURSOR c_cst_seq_num IS
1630: SELECT IGS_PS_STAGE_SEQ_NUM_S.NEXTVAL
1631: FROM DUAL;
1632: CURSOR c_cst IS

Line 1630: SELECT IGS_PS_STAGE_SEQ_NUM_S.NEXTVAL

1626: DECLARE
1627: v_cst_seq_num IGS_PS_STAGE.sequence_number%TYPE;
1628: v_new_rul_seq_num IGS_PS_STAGE_RU.rul_sequence_number%TYPE;
1629: CURSOR c_cst_seq_num IS
1630: SELECT IGS_PS_STAGE_SEQ_NUM_S.NEXTVAL
1631: FROM DUAL;
1632: CURSOR c_cst IS
1633: SELECT cst.sequence_number,
1634: cst.course_stage_type,

Line 1637: FROM IGS_PS_STAGE cst

1633: SELECT cst.sequence_number,
1634: cst.course_stage_type,
1635: cst.description,
1636: cst.comments
1637: FROM IGS_PS_STAGE cst
1638: WHERE cst.course_cd = p_old_course_cd AND
1639: cst.version_number = p_old_version_number;
1640: CURSOR c_csr (
1641: cp_cst_seq_num IGS_PS_STAGE.sequence_number%TYPE) IS

Line 1641: cp_cst_seq_num IGS_PS_STAGE.sequence_number%TYPE) IS

1637: FROM IGS_PS_STAGE cst
1638: WHERE cst.course_cd = p_old_course_cd AND
1639: cst.version_number = p_old_version_number;
1640: CURSOR c_csr (
1641: cp_cst_seq_num IGS_PS_STAGE.sequence_number%TYPE) IS
1642: SELECT csr.cst_sequence_number,
1643: csr.s_rule_call_cd,
1644: csr.rul_sequence_number
1645: FROM IGS_PS_STAGE_RU csr

Line 1645: FROM IGS_PS_STAGE_RU csr

1641: cp_cst_seq_num IGS_PS_STAGE.sequence_number%TYPE) IS
1642: SELECT csr.cst_sequence_number,
1643: csr.s_rule_call_cd,
1644: csr.rul_sequence_number
1645: FROM IGS_PS_STAGE_RU csr
1646: WHERE csr.course_cd = p_old_course_cd AND
1647: csr.version_number = p_old_version_number AND
1648: csr.cst_sequence_number = cp_cst_seq_num;
1649: BEGIN

Line 1656: IGS_PS_STAGE_PKG.INSERT_ROW(

1652: OPEN c_cst_seq_num;
1653: FETCH c_cst_seq_num INTO v_cst_seq_num;
1654: CLOSE c_cst_seq_num;
1655: x_rowid := NULL;
1656: IGS_PS_STAGE_PKG.INSERT_ROW(
1657: X_ROWID => x_rowid,
1658: X_COURSE_CD => p_new_course_cd,
1659: X_VERSION_NUMBER => p_new_version_number,
1660: X_SEQUENCE_NUMBER => v_cst_seq_num,

Line 1672: IGS_PS_STAGE_RU_PKG.INSERT_ROW(

1668: v_new_rul_seq_num := IGS_RU_GEN_003.rulp_ins_copy_rule(
1669: v_csr_rec.s_rule_call_cd,
1670: v_csr_rec.rul_sequence_number);
1671: X_ROWID := NULL;
1672: IGS_PS_STAGE_RU_PKG.INSERT_ROW(
1673: X_ROWID => x_rowid,
1674: X_COURSE_CD => p_new_course_cd,
1675: X_VERSION_NUMBER => p_new_version_number,
1676: X_S_RULE_CALL_CD => v_csr_rec.s_rule_call_cd,

Line 2033: -- calling procedure to insert IGS_PS_STAGE records and its

2029: CLOSE c_co_rec;
2030:
2031: -- Removed code to insert records into igs_ps_accounts table as part of Enh# 2831572
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;