APPS.IGS_PS_GEN_008 dependencies on IGS_PS_UNT_OFR_OPT_N

Line 1101: p_exist_uoo_id IN IGS_PS_UNT_OFR_OPT_N.uoo_id%TYPE,

1097: App_Exception.Raise_Exception;
1098: END IF;
1099: END crspl_ins_unit_ref_cd;
1100: PROCEDURE crspl_ins_unit_off_opt_note (
1101: p_exist_uoo_id IN IGS_PS_UNT_OFR_OPT_N.uoo_id%TYPE,
1102: p_new_uoo_id IN IGS_PS_UNT_OFR_OPT_N.uoo_id%TYPE )
1103: AS
1104: v_unit_offer_opt_note_rec IGS_PS_UNT_OFR_OPT_N%ROWTYPE;
1105: v_new_ref_number IGS_PS_UNT_OFR_OPT_N.reference_number%TYPE;

Line 1102: p_new_uoo_id IN IGS_PS_UNT_OFR_OPT_N.uoo_id%TYPE )

1098: END IF;
1099: END crspl_ins_unit_ref_cd;
1100: PROCEDURE crspl_ins_unit_off_opt_note (
1101: p_exist_uoo_id IN IGS_PS_UNT_OFR_OPT_N.uoo_id%TYPE,
1102: p_new_uoo_id IN IGS_PS_UNT_OFR_OPT_N.uoo_id%TYPE )
1103: AS
1104: v_unit_offer_opt_note_rec IGS_PS_UNT_OFR_OPT_N%ROWTYPE;
1105: v_new_ref_number IGS_PS_UNT_OFR_OPT_N.reference_number%TYPE;
1106: v_uoo_id IGS_PS_UNT_OFR_OPT_N.uoo_id%TYPE;

Line 1104: v_unit_offer_opt_note_rec IGS_PS_UNT_OFR_OPT_N%ROWTYPE;

1100: PROCEDURE crspl_ins_unit_off_opt_note (
1101: p_exist_uoo_id IN IGS_PS_UNT_OFR_OPT_N.uoo_id%TYPE,
1102: p_new_uoo_id IN IGS_PS_UNT_OFR_OPT_N.uoo_id%TYPE )
1103: AS
1104: v_unit_offer_opt_note_rec IGS_PS_UNT_OFR_OPT_N%ROWTYPE;
1105: v_new_ref_number IGS_PS_UNT_OFR_OPT_N.reference_number%TYPE;
1106: v_uoo_id IGS_PS_UNT_OFR_OPT_N.uoo_id%TYPE;
1107: --- The following cursor excludes notes records with NULL values in the
1108: --- note_text field as this implies that it contains data in the note_ole

Line 1105: v_new_ref_number IGS_PS_UNT_OFR_OPT_N.reference_number%TYPE;

1101: p_exist_uoo_id IN IGS_PS_UNT_OFR_OPT_N.uoo_id%TYPE,
1102: p_new_uoo_id IN IGS_PS_UNT_OFR_OPT_N.uoo_id%TYPE )
1103: AS
1104: v_unit_offer_opt_note_rec IGS_PS_UNT_OFR_OPT_N%ROWTYPE;
1105: v_new_ref_number IGS_PS_UNT_OFR_OPT_N.reference_number%TYPE;
1106: v_uoo_id IGS_PS_UNT_OFR_OPT_N.uoo_id%TYPE;
1107: --- The following cursor excludes notes records with NULL values in the
1108: --- note_text field as this implies that it contains data in the note_ole
1109: --- field which cannot be copied with the current product limitations.

Line 1106: v_uoo_id IGS_PS_UNT_OFR_OPT_N.uoo_id%TYPE;

1102: p_new_uoo_id IN IGS_PS_UNT_OFR_OPT_N.uoo_id%TYPE )
1103: AS
1104: v_unit_offer_opt_note_rec IGS_PS_UNT_OFR_OPT_N%ROWTYPE;
1105: v_new_ref_number IGS_PS_UNT_OFR_OPT_N.reference_number%TYPE;
1106: v_uoo_id IGS_PS_UNT_OFR_OPT_N.uoo_id%TYPE;
1107: --- The following cursor excludes notes records with NULL values in the
1108: --- note_text field as this implies that it contains data in the note_ole
1109: --- field which cannot be copied with the current product limitations.
1110: CURSOR c_unit_off_opt_note_rec IS

Line 1112: FROM IGS_PS_UNT_OFR_OPT_N uoon

1108: --- note_text field as this implies that it contains data in the note_ole
1109: --- field which cannot be copied with the current product limitations.
1110: CURSOR c_unit_off_opt_note_rec IS
1111: SELECT *
1112: FROM IGS_PS_UNT_OFR_OPT_N uoon
1113: WHERE uoon.uoo_id = p_exist_uoo_id AND
1114: EXISTS (
1115: SELECT 'x'
1116: FROM IGS_GE_NOTE nte

Line 1127: IGS_PS_UNT_OFR_OPT_N_PKG.INSERT_ROW(

1123: v_new_ref_number);
1124: BEGIN
1125: x_rowid := NULL;
1126: v_uoo_id := p_new_uoo_id;
1127: IGS_PS_UNT_OFR_OPT_N_PKG.INSERT_ROW(
1128: X_ROWID => x_rowid,
1129: X_UNIT_CD => p_new_unit_cd,
1130: X_VERSION_NUMBER => p_new_version_number,
1131: X_CI_SEQUENCE_NUMBER => v_unit_offer_opt_note_rec.ci_sequence_number,

Line 1166: p_new_uoo_id IN IGS_PS_UNT_OFR_OPT_N.uoo_id%TYPE)

1162: p_cal_type IN IGS_PS_UNIT_OFR_OPT.cal_type%TYPE,
1163: p_ci_sequence_number IN IGS_PS_UNIT_OFR_OPT.ci_sequence_number%TYPE,
1164: p_location_cd IN IGS_PS_UNIT_OFR_OPT.location_cd%TYPE,
1165: p_unit_class IN IGS_PS_UNIT_OFR_OPT.unit_class%TYPE,
1166: p_new_uoo_id IN IGS_PS_UNT_OFR_OPT_N.uoo_id%TYPE)
1167: AS
1168: CURSOR c_tro IS
1169: SELECT tro.location_cd,
1170: tro.unit_class,