APPS.IGS_PS_CREATE_GENERIC_PKG dependencies on IGS_PS_USEC_SP_FEES

Line 7574: IF igs_ps_usec_sp_fees_pkg.get_uk_for_validation ( x_fee_type => p_usec_sp_fee_rec.fee_type,

7570: BEGIN
7571:
7572: IF p_insert_update = 'I' THEN
7573: /* Unique Key Validation */
7574: IF igs_ps_usec_sp_fees_pkg.get_uk_for_validation ( x_fee_type => p_usec_sp_fee_rec.fee_type,
7575: x_uoo_id => l_n_uoo_id ) THEN
7576: igs_ps_validate_lgcy_pkg.set_msg('IGS_PS_LGCY_REC_EXISTS', 'FEE_TYPE', 'IGS_FI_LOCKBOX', FALSE);
7577: p_usec_sp_fee_rec.status := 'W';
7578: RETURN;

Line 7600: igs_ps_usec_sp_fees_pkg.check_constraints('CLOSED_FLAG', p_usec_sp_fee_rec.closed_flag);

7596: p_usec_sp_fee_rec.status :='E';
7597: END;
7598:
7599: BEGIN
7600: igs_ps_usec_sp_fees_pkg.check_constraints('CLOSED_FLAG', p_usec_sp_fee_rec.closed_flag);
7601: EXCEPTION
7602: WHEN OTHERS THEN
7603: igs_ps_validate_lgcy_pkg.set_msg('IGS_PS_LGCY_Y_OR_N','CLOSED_FLAG','LEGACY_TOKENS',TRUE);
7604: p_usec_sp_fee_rec.status :='E';

Line 7608: igs_ps_usec_sp_fees_pkg.check_constraints('SP_FEE_AMT', p_usec_sp_fee_rec.sp_fee_amt);

7604: p_usec_sp_fee_rec.status :='E';
7605: END;
7606:
7607: BEGIN
7608: igs_ps_usec_sp_fees_pkg.check_constraints('SP_FEE_AMT', p_usec_sp_fee_rec.sp_fee_amt);
7609: EXCEPTION
7610: WHEN OTHERS THEN
7611: igs_ps_validate_lgcy_pkg.set_msg('IGS_PS_LGCY_VAL_0_9999D99','FEE_AMOUNT','LEGACY_TOKENS',TRUE);
7612: p_usec_sp_fee_rec.status :='E';

Line 7635: FROM igs_ps_usec_sp_fees

7631: FUNCTION check_insert_update ( p_usec_sp_fee_rec IN OUT NOCOPY igs_ps_generic_pub.usec_sp_fee_rec_type) RETURN VARCHAR2 IS
7632:
7633: CURSOR c_sp_fee IS
7634: SELECT 'X'
7635: FROM igs_ps_usec_sp_fees
7636: WHERE uoo_id = l_n_uoo_id
7637: AND fee_type =p_usec_sp_fee_rec.fee_type;
7638:
7639: l_c_sp_fee c_sp_fee%ROWTYPE;

Line 7658: FROM igs_ps_usec_sp_fees

7654:
7655: PROCEDURE Assign_default(p_usec_sp_fee_rec IN OUT NOCOPY igs_ps_generic_pub.usec_sp_fee_rec_type,p_insert_update IN VARCHAR2) AS
7656: CURSOR cur_sp_fees(cp_n_uoo_id IN NUMBER,cp_c_fee_type IN VARCHAR2) IS
7657: SELECT *
7658: FROM igs_ps_usec_sp_fees
7659: WHERE uoo_id = cp_n_uoo_id
7660: AND fee_type = cp_c_fee_type;
7661:
7662: l_cur_sp_fees cur_sp_fees%ROWTYPE;

Line 7922: INSERT INTO IGS_PS_USEC_SP_FEES(

7918:
7919: IF p_usec_sp_fee_tbl(I).status = 'S' THEN
7920: p_usec_sp_fee_tbl(I).sp_fee_amt :=igs_fi_gen_gl.get_formatted_amount(p_usec_sp_fee_tbl(I).sp_fee_amt);
7921: IF l_insert_update = 'I' THEN
7922: INSERT INTO IGS_PS_USEC_SP_FEES(
7923: USEC_SP_FEES_ID,
7924: UOO_ID,
7925: FEE_TYPE,
7926: SP_FEE_AMT,

Line 7934: igs_ps_usec_sp_fees_s.NEXTVAL,

7930: LAST_UPDATED_BY,
7931: LAST_UPDATE_DATE,
7932: LAST_UPDATE_LOGIN )
7933: VALUES (
7934: igs_ps_usec_sp_fees_s.NEXTVAL,
7935: l_n_uoo_id,
7936: p_usec_sp_fee_tbl(I).fee_type,
7937: p_usec_sp_fee_tbl(I).sp_fee_amt,
7938: p_usec_sp_fee_tbl(I).closed_flag,

Line 7953: UPDATE IGS_PS_USEC_SP_FEES SET

7949: p_usec_sp_fee_tbl(I).unit_class||' '||'Fee type:'||p_usec_sp_fee_tbl(I).fee_type);
7950: END IF;
7951:
7952: ELSE
7953: UPDATE IGS_PS_USEC_SP_FEES SET
7954: SP_FEE_AMT = p_usec_sp_fee_tbl(I).sp_fee_amt,
7955: CLOSED_FLAG = p_usec_sp_fee_tbl(I).closed_flag,
7956: last_updated_by = g_n_user_id ,
7957: last_update_date = sysdate ,