APPS.IGS_PS_CREATE_GENERIC_PKG dependencies on IGS_PS_RSV_USEC_PRF

Line 471: FROM igs_ps_rsv_usec_prf

467:
468: FUNCTION check_insert_update ( p_usec_rsv_rec IN OUT NOCOPY igs_ps_generic_pub.usec_res_seat_rec_type,p_n_rsv_usec_pri_id NUMBER) RETURN VARCHAR2 IS
469: CURSOR c_usec_rsv_prf(p_rsv_usec_pri_id NUMBER,p_preference_code VARCHAR2) IS
470: SELECT 'X'
471: FROM igs_ps_rsv_usec_prf
472: WHERE rsv_usec_pri_id = p_rsv_usec_pri_id
473: AND preference_code = p_preference_code;
474:
475: c_usec_rsv_prf_rec c_usec_rsv_prf%ROWTYPE;

Line 479: FROM igs_ps_rsv_usec_prf

475: c_usec_rsv_prf_rec c_usec_rsv_prf%ROWTYPE;
476:
477: CURSOR c_usec_rsv_prf1(cp_rsv_usec_pri_id NUMBER,cp_preference_code VARCHAR2,cp_preference_version NUMBER) IS
478: SELECT 'X'
479: FROM igs_ps_rsv_usec_prf
480: WHERE rsv_usec_pri_id = cp_rsv_usec_pri_id
481: AND preference_code = cp_preference_code
482: AND preference_version = cp_preference_version;
483:

Line 528: IF igs_ps_rsv_usec_prf_pkg.get_uk_for_validation(x_rsv_usec_pri_id => l_n_rsv_usec_pri_id ,

524: BEGIN
525:
526: IF(p_insert_update = 'I') THEN
527: /* Unique Key Validation */
528: IF igs_ps_rsv_usec_prf_pkg.get_uk_for_validation(x_rsv_usec_pri_id => l_n_rsv_usec_pri_id ,
529: x_preference_code =>p_usec_rsv_rec.preference_code ) THEN
530: igs_ps_validate_lgcy_pkg.set_msg('IGS_PS_LGCY_REC_EXISTS', 'USEC_RSV_PRF', 'LEGACY_TOKENS', FALSE);
531: p_usec_rsv_rec.status := 'W';
532:

Line 669: INSERT INTO igs_ps_rsv_usec_prf (

665:
666: IF p_usec_rsv_rec.status = 'S' THEN
667: IF l_insert_update = 'I' THEN
668: /* Insert Record */
669: INSERT INTO igs_ps_rsv_usec_prf (
670: rsv_usec_prf_id,
671: rsv_usec_pri_id,
672: preference_order,
673: preference_code,

Line 683: igs_ps_rsv_usec_prf_s.NEXTVAL,

679: last_updated_by,
680: last_update_date,
681: last_update_login )
682: VALUES (
683: igs_ps_rsv_usec_prf_s.NEXTVAL,
684: l_n_rsv_usec_pri_id,
685: p_usec_rsv_rec.preference_order,
686: p_usec_rsv_rec.preference_code,
687: p_usec_rsv_rec.preference_version,

Line 706: UPDATE igs_ps_rsv_usec_prf SET

702: END IF;
703:
704:
705: ELSE --update
706: UPDATE igs_ps_rsv_usec_prf SET
707: preference_order= p_usec_rsv_rec.preference_order,
708: percentage_reserved=p_usec_rsv_rec.percentage_reserved,
709: preference_version=p_usec_rsv_rec.preference_version,
710: last_updated_by = g_n_user_id,