APPS.IGS_PS_CREATE_GENERIC_PKG dependencies on IGS_PE_HZ_PARTIES

Line 55: --sommukhe 12-AUG-2005 Bug#4377818,changed the cursor cur_hzp, included table igs_pe_hz_parties in

51:
52: Known limitations,enhancements,remarks:
53: Change History (in reverse chronological order)
54: Who When What
55: --sommukhe 12-AUG-2005 Bug#4377818,changed the cursor cur_hzp, included table igs_pe_hz_parties in
56: -- FROM clause and modified the WHERE clause by joining HZ_PARTIES and IGS_PE_HZ_PARTIES
57: -- using party_id and org unit being compared with oss_org_unit_cd of IGS_PE_HZ_PARTIES.
58: ********************************************************************************************** */
59: /* Private Procedures for create_usec_res_seat */

Line 56: -- FROM clause and modified the WHERE clause by joining HZ_PARTIES and IGS_PE_HZ_PARTIES

52: Known limitations,enhancements,remarks:
53: Change History (in reverse chronological order)
54: Who When What
55: --sommukhe 12-AUG-2005 Bug#4377818,changed the cursor cur_hzp, included table igs_pe_hz_parties in
56: -- FROM clause and modified the WHERE clause by joining HZ_PARTIES and IGS_PE_HZ_PARTIES
57: -- using party_id and org unit being compared with oss_org_unit_cd of IGS_PE_HZ_PARTIES.
58: ********************************************************************************************** */
59: /* Private Procedures for create_usec_res_seat */
60:

Line 57: -- using party_id and org unit being compared with oss_org_unit_cd of IGS_PE_HZ_PARTIES.

53: Change History (in reverse chronological order)
54: Who When What
55: --sommukhe 12-AUG-2005 Bug#4377818,changed the cursor cur_hzp, included table igs_pe_hz_parties in
56: -- FROM clause and modified the WHERE clause by joining HZ_PARTIES and IGS_PE_HZ_PARTIES
57: -- using party_id and org unit being compared with oss_org_unit_cd of IGS_PE_HZ_PARTIES.
58: ********************************************************************************************** */
59: /* Private Procedures for create_usec_res_seat */
60:
61: l_insert_update VARCHAR2(1);

Line 513: FROM hz_parties hp, igs_pe_hz_parties pe

509: -- Validate Database Constraints for reserved seating preference.
510: PROCEDURE validate_db_cons_rsvprf ( p_usec_rsv_rec IN OUT NOCOPY igs_ps_generic_pub.usec_res_seat_rec_type,p_insert_update VARCHAR2 ) AS
511: CURSOR cur_hzp(cp_preference_code VARCHAR2) IS
512: SELECT 'x'
513: FROM hz_parties hp, igs_pe_hz_parties pe
514: WHERE hp.party_id = pe.party_id
515: AND pe.oss_org_unit_cd =cp_preference_code;
516:
517: cur_Hzp_rec cur_Hzp%ROWTYPE;

Line 4586: --sommukhe 12-AUG-2005 Bug#4377818,changed the cursor cur_hzp, included table igs_pe_hz_parties in

4582:
4583: Known limitations,enhancements,remarks:
4584: Change History (in reverse chronological order)
4585: Who When What
4586: --sommukhe 12-AUG-2005 Bug#4377818,changed the cursor cur_hzp, included table igs_pe_hz_parties in
4587: -- FROM clause and modified the WHERE clause by joining HZ_PARTIES and IGS_PE_HZ_PARTIES
4588: -- using party_id and org unit being compared with oss_org_unit_cd of IGS_PE_HZ_PARTIES.
4589: ********************************************************************************************** */
4590:

Line 4587: -- FROM clause and modified the WHERE clause by joining HZ_PARTIES and IGS_PE_HZ_PARTIES

4583: Known limitations,enhancements,remarks:
4584: Change History (in reverse chronological order)
4585: Who When What
4586: --sommukhe 12-AUG-2005 Bug#4377818,changed the cursor cur_hzp, included table igs_pe_hz_parties in
4587: -- FROM clause and modified the WHERE clause by joining HZ_PARTIES and IGS_PE_HZ_PARTIES
4588: -- using party_id and org unit being compared with oss_org_unit_cd of IGS_PE_HZ_PARTIES.
4589: ********************************************************************************************** */
4590:
4591: l_insert_update VARCHAR2(1);

Line 4588: -- using party_id and org unit being compared with oss_org_unit_cd of IGS_PE_HZ_PARTIES.

4584: Change History (in reverse chronological order)
4585: Who When What
4586: --sommukhe 12-AUG-2005 Bug#4377818,changed the cursor cur_hzp, included table igs_pe_hz_parties in
4587: -- FROM clause and modified the WHERE clause by joining HZ_PARTIES and IGS_PE_HZ_PARTIES
4588: -- using party_id and org unit being compared with oss_org_unit_cd of IGS_PE_HZ_PARTIES.
4589: ********************************************************************************************** */
4590:
4591: l_insert_update VARCHAR2(1);
4592: l_n_uoo_id igs_ps_unit_ofr_opt_all.uoo_id%TYPE;

Line 5005: FROM hz_parties hp, igs_pe_hz_parties pe

5001: -- Validate Database Constraints for waitlist preference.
5002: PROCEDURE validate_db_cons_wlstprf ( p_usec_wlst_rec IN OUT NOCOPY igs_ps_generic_pub.usec_waitlist_rec_type,p_insert_update VARCHAR2 ) AS
5003: CURSOR cur_hzp(cp_preference_code VARCHAR2) IS
5004: SELECT 'x'
5005: FROM hz_parties hp, igs_pe_hz_parties pe
5006: WHERE hp.party_id = pe.party_id
5007: AND pe.oss_org_unit_cd =cp_preference_code;
5008:
5009: cur_hzp_rec cur_hzp%ROWTYPE;