APPS.IGS_PS_GEN_001 dependencies on IGS_PS_STAGE_RU

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 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 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 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,