APPS.IGS_AD_GEN_011 dependencies on IGS_CO_S_PER_LT_PARM_SEQ_NUM_S

Line 1630: SELECT IGS_CO_S_PER_LT_PARM_SEQ_NUM_S.NEXTVAL

1626: SELECT ltp.phrase_text
1627: FROM IGS_CO_LTR_PHR ltp
1628: WHERE ltp.phrase_cd = cp_phrase_cd;
1629: CURSOR c_get_nxt_seq IS
1630: SELECT IGS_CO_S_PER_LT_PARM_SEQ_NUM_S.NEXTVAL
1631: FROM DUAL;
1632:
1633: lv_rowid VARCHAR2(25);
1634:

Line 1656: -- Get IGS_CO_S_PER_LT_PARM_SEQ_NUM_S.NEXTVAL

1652: END IF;
1653: CLOSE c_ltp;
1654: END IF;
1655: IF(v_value IS NOT NULL) THEN
1656: -- Get IGS_CO_S_PER_LT_PARM_SEQ_NUM_S.NEXTVAL
1657: OPEN c_get_nxt_seq;
1658: FETCH c_get_nxt_seq INTO v_sequence_number;
1659: CLOSE c_get_nxt_seq;
1660: IGS_CO_S_PER_LT_Parm_Pkg.Insert_Row (