APPS.IGS_PS_CREATE_GENERIC_PKG dependencies on IGS_PS_RSV_USEC_PRI

Line 63: l_n_rsv_usec_pri_id igs_ps_rsv_usec_pri.rsv_usec_pri_id%type;

59: /* Private Procedures for create_usec_res_seat */
60:
61: l_insert_update VARCHAR2(1);
62: l_n_uoo_id igs_ps_unit_ofr_opt_all.uoo_id%TYPE;
63: l_n_rsv_usec_pri_id igs_ps_rsv_usec_pri.rsv_usec_pri_id%type;
64: l_n_group_id igs_pe_persid_group_all.group_id%TYPE;
65:
66: l_tbl_uoo igs_ps_create_generic_pkg.uoo_tbl_type;
67:

Line 164: FROM igs_ps_rsv_usec_pri

160: -- Check for Update
161: 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
162: CURSOR c_usec_rsv_pri(cp_n_uoo_id NUMBER,cp_priority_value VARCHAR2) IS
163: SELECT 'X'
164: FROM igs_ps_rsv_usec_pri
165: WHERE uoo_id = cp_n_uoo_id
166: AND priority_value = cp_priority_value;
167:
168: c_usec_rsv_pri_rec c_usec_rsv_pri%ROWTYPE;

Line 185: FROM igs_ps_rsv_usec_pri

181: PROCEDURE Assign_default(p_usec_rsv_rec IN OUT NOCOPY igs_ps_generic_pub.usec_res_seat_rec_type,p_insert_update VARCHAR2 ) AS
182:
183: CURSOR c_usprv(cp_n_uoo_id NUMBER,cp_priority_value VARCHAR2) IS
184: SELECT priority_order
185: FROM igs_ps_rsv_usec_pri
186: WHERE uoo_id = cp_n_uoo_id
187: AND priority_value = cp_priority_value;
188:
189: rec_usprv c_usprv%ROWTYPE;

Line 214: IF igs_ps_rsv_usec_pri_pkg.get_uk_for_validation (x_uoo_id => l_n_uoo_id,

210: PROCEDURE validate_db_cons_rsvpri ( p_usec_rsv_rec IN OUT NOCOPY igs_ps_generic_pub.usec_res_seat_rec_type,p_insert_update VARCHAR2 ) AS
211: BEGIN
212: IF(p_insert_update = 'I') THEN
213: /* Unique Key Validation */
214: IF igs_ps_rsv_usec_pri_pkg.get_uk_for_validation (x_uoo_id => l_n_uoo_id,
215: x_priority_value =>p_usec_rsv_rec.priority_value ) THEN
216: igs_ps_validate_lgcy_pkg.set_msg('IGS_PS_LGCY_REC_EXISTS', 'USEC_RSV_PRI', 'LEGACY_TOKENS', FALSE);
217: p_usec_rsv_rec.status := 'W';
218: RETURN;

Line 357: INSERT INTO igs_ps_rsv_usec_pri

353:
354: IF p_usec_rsv_rec.status = 'S' THEN
355: IF l_insert_update = 'I' THEN
356: /* Insert Record */
357: INSERT INTO igs_ps_rsv_usec_pri
358: (
359: rsv_usec_pri_id,
360: uoo_id,
361: priority_order,

Line 371: igs_ps_rsv_usec_pri_s.nextval,

367: last_update_login
368: )
369: VALUES
370: (
371: igs_ps_rsv_usec_pri_s.nextval,
372: l_n_uoo_id,
373: p_usec_rsv_rec.priority_order,
374: p_usec_rsv_rec.priority_value,
375: g_n_user_id,

Line 390: UPDATE igs_ps_rsv_usec_pri SET

386: p_usec_rsv_rec.unit_class||' '||'Priority Value:'||p_usec_rsv_rec.priority_value);
387: END IF;
388:
389: ELSE --update
390: UPDATE igs_ps_rsv_usec_pri SET
391: priority_order= p_usec_rsv_rec.priority_order,
392: last_updated_by = g_n_user_id,
393: last_update_date= SYSDATE ,
394: last_update_login= g_n_login_id

Line 453: CURSOR c_pri_id(cp_uoo_id NUMBER, cp_priority_value igs_ps_rsv_usec_pri.priority_value%type) IS

449: l_d_start_dt igs_ca_inst_all.start_dt%TYPE;
450: l_d_end_dt igs_ca_inst_all.end_dt%TYPE;
451: l_c_message VARCHAR2(30);
452:
453: CURSOR c_pri_id(cp_uoo_id NUMBER, cp_priority_value igs_ps_rsv_usec_pri.priority_value%type) IS
454: SELECT rsv_usec_pri_id
455: FROM igs_ps_rsv_usec_pri
456: WHERE uoo_id = cp_uoo_id
457: AND priority_value = cp_priority_value;

Line 455: FROM igs_ps_rsv_usec_pri

451: l_c_message VARCHAR2(30);
452:
453: CURSOR c_pri_id(cp_uoo_id NUMBER, cp_priority_value igs_ps_rsv_usec_pri.priority_value%type) IS
454: SELECT rsv_usec_pri_id
455: FROM igs_ps_rsv_usec_pri
456: WHERE uoo_id = cp_uoo_id
457: AND priority_value = cp_priority_value;
458:
459: BEGIN