APPS.IGS_PS_CREATE_GENERIC_PKG dependencies on IGS_PS_USEC_WLST_PRI

Line 4593: l_n_wlst_usec_pri_id igs_ps_usec_wlst_pri.unit_sec_waitlist_priority_id%type;

4589: ********************************************************************************************** */
4590:
4591: l_insert_update VARCHAR2(1);
4592: l_n_uoo_id igs_ps_unit_ofr_opt_all.uoo_id%TYPE;
4593: l_n_wlst_usec_pri_id igs_ps_usec_wlst_pri.unit_sec_waitlist_priority_id%type;
4594: l_tbl_uoo igs_ps_create_generic_pkg.uoo_tbl_type;
4595:
4596: /* Private Procedures for create_usec_waitlist */
4597: PROCEDURE trim_values ( p_usec_wlst_rec IN OUT NOCOPY igs_ps_generic_pub.usec_waitlist_rec_type ) AS

Line 4687: FROM igs_ps_usec_wlst_pri

4683: -- Check for Update
4684: FUNCTION check_insert_update ( p_usec_wlst_rec IN OUT NOCOPY igs_ps_generic_pub.usec_waitlist_rec_type,p_n_wlst_usec_pri_id NUMBER) RETURN VARCHAR2 IS
4685: CURSOR c_usec_wlst_pri(cp_n_uoo_id NUMBER,cp_priority_value VARCHAR2) IS
4686: SELECT 'X'
4687: FROM igs_ps_usec_wlst_pri
4688: WHERE uoo_id = cp_n_uoo_id
4689: AND priority_value = cp_priority_value;
4690:
4691: c_usec_wlst_pri_rec c_usec_wlst_pri%ROWTYPE;

Line 4710: FROM igs_ps_usec_wlst_pri

4706: PROCEDURE Assign_default(p_usec_wlst_rec IN OUT NOCOPY igs_ps_generic_pub.usec_waitlist_rec_type,p_insert_update VARCHAR2 ) AS
4707:
4708: CURSOR c_usprv(cp_n_uoo_id NUMBER,cp_priority_value VARCHAR2) IS
4709: SELECT priority_number
4710: FROM igs_ps_usec_wlst_pri
4711: WHERE uoo_id = cp_n_uoo_id
4712: AND priority_value = cp_priority_value;
4713:
4714: rec_usprv c_usprv%ROWTYPE;

Line 4737: IF igs_ps_usec_wlst_pri_pkg.get_uk_for_validation ( x_priority_value =>p_usec_wlst_rec.priority_value,

4733: PROCEDURE validate_db_cons_wlstpri ( p_usec_wlst_rec IN OUT NOCOPY igs_ps_generic_pub.usec_waitlist_rec_type,p_insert_update VARCHAR2 ) AS
4734: BEGIN
4735: IF(p_insert_update = 'I') THEN
4736: /* Unique Key Validation */
4737: IF igs_ps_usec_wlst_pri_pkg.get_uk_for_validation ( x_priority_value =>p_usec_wlst_rec.priority_value,
4738: x_uoo_id => l_n_uoo_id) THEN
4739: igs_ps_validate_lgcy_pkg.set_msg('IGS_PS_LGCY_REC_EXISTS', 'USEC_WLST_PRI', 'LEGACY_TOKENS', FALSE);
4740: p_usec_wlst_rec.status := 'W';
4741: RETURN;

Line 4858: INSERT INTO igs_ps_usec_wlst_pri

4854:
4855: IF p_usec_wlst_rec.status = 'S' THEN
4856: IF l_insert_update = 'I' THEN
4857: /* Insert Record */
4858: INSERT INTO igs_ps_usec_wlst_pri
4859: ( unit_sec_waitlist_priority_id,
4860: priority_number,
4861: priority_value,
4862: created_by,

Line 4871: igs_ps_usec_wlst_pri_s.nextval,

4867: uoo_id
4868: )
4869: VALUES
4870: (
4871: igs_ps_usec_wlst_pri_s.nextval,
4872: p_usec_wlst_rec.priority_number,
4873: p_usec_wlst_rec.priority_value,
4874: g_n_user_id,
4875: sysdate,

Line 4890: UPDATE igs_ps_usec_wlst_pri SET

4886: p_usec_wlst_rec.unit_class||' '||'Priority Value:'||p_usec_wlst_rec.priority_value);
4887: END IF;
4888:
4889: ELSE --update
4890: UPDATE igs_ps_usec_wlst_pri SET
4891: priority_number= p_usec_wlst_rec.priority_number,
4892: last_updated_by = g_n_user_id,
4893: last_update_date= SYSDATE ,
4894: last_update_login= g_n_login_id

Line 4943: CURSOR c_pri_id(cp_uoo_id NUMBER, cp_priority_value igs_ps_usec_wlst_pri.priority_value%type) IS

4939:
4940: -- Carry out derivations and validate them
4941: PROCEDURE validate_derivations_prf ( p_usec_wlst_rec IN OUT NOCOPY igs_ps_generic_pub.usec_waitlist_rec_type,p_insert_update VARCHAR2 ) AS
4942:
4943: CURSOR c_pri_id(cp_uoo_id NUMBER, cp_priority_value igs_ps_usec_wlst_pri.priority_value%type) IS
4944: SELECT unit_sec_waitlist_priority_id
4945: FROM igs_ps_usec_wlst_pri
4946: WHERE uoo_id = cp_uoo_id
4947: AND priority_value = cp_priority_value;

Line 4945: FROM igs_ps_usec_wlst_pri

4941: PROCEDURE validate_derivations_prf ( p_usec_wlst_rec IN OUT NOCOPY igs_ps_generic_pub.usec_waitlist_rec_type,p_insert_update VARCHAR2 ) AS
4942:
4943: CURSOR c_pri_id(cp_uoo_id NUMBER, cp_priority_value igs_ps_usec_wlst_pri.priority_value%type) IS
4944: SELECT unit_sec_waitlist_priority_id
4945: FROM igs_ps_usec_wlst_pri
4946: WHERE uoo_id = cp_uoo_id
4947: AND priority_value = cp_priority_value;
4948:
4949: BEGIN