APPS.IGS_PS_VALIDATE_LGCY_PKG dependencies on IGS_PS_USEC_OCCURS_ALL

Line 62: l_c_cancel igs_ps_usec_occurs_all.cancel_flag%TYPE;

58: AND (schedule_status IS NULL OR schedule_status <> cp_c_schd_stat)
59: AND NO_SET_DAY_IND ='N'
60: FOR UPDATE NOWAIT;
61:
62: l_c_cancel igs_ps_usec_occurs_all.cancel_flag%TYPE;
63: l_c_schedule_status igs_ps_usec_occurs_all.schedule_status%TYPE;
64:
65: BEGIN
66:

Line 63: l_c_schedule_status igs_ps_usec_occurs_all.schedule_status%TYPE;

59: AND NO_SET_DAY_IND ='N'
60: FOR UPDATE NOWAIT;
61:
62: l_c_cancel igs_ps_usec_occurs_all.cancel_flag%TYPE;
63: l_c_schedule_status igs_ps_usec_occurs_all.schedule_status%TYPE;
64:
65: BEGIN
66:
67: FOR c_usec_occurs_rec IN c_usec_occurs(p_uoo_id, schd_stat) LOOP

Line 794: CURSOR c_uso(cp_n_uoo_id igs_ps_usec_occurs_all.uoo_id%TYPE) IS

790: AND cal_type = p_c_cal_type ;
791:
792: c_usec_rec c_usec%ROWTYPE;
793:
794: CURSOR c_uso(cp_n_uoo_id igs_ps_usec_occurs_all.uoo_id%TYPE) IS
795: SELECT uso.rowid, uso.*
796: FROM igs_ps_usec_occurs_all uso
797: WHERE uso.uoo_id = cp_n_uoo_id
798: AND building_code IS NOT NULL;

Line 796: FROM igs_ps_usec_occurs_all uso

792: c_usec_rec c_usec%ROWTYPE;
793:
794: CURSOR c_uso(cp_n_uoo_id igs_ps_usec_occurs_all.uoo_id%TYPE) IS
795: SELECT uso.rowid, uso.*
796: FROM igs_ps_usec_occurs_all uso
797: WHERE uso.uoo_id = cp_n_uoo_id
798: AND building_code IS NOT NULL;
799:
800: CURSOR cur_unit_audit(cp_uoo_id igs_en_su_attempt.uoo_id%TYPE) IS

Line 1763: FROM igs_ps_usec_occurs_all

1759: WHERE unit_section_occurrence_id = cp_uso_id;
1760:
1761: CURSOR cur_occur(cp_uso_id IN NUMBER) IS
1762: SELECT *
1763: FROM igs_ps_usec_occurs_all
1764: WHERE unit_section_occurrence_id = cp_uso_id;
1765: l_cur_occur cur_occur%ROWTYPE;
1766:
1767: CURSOR c_shadow_num(l_unit_sec_occurrence_id IGS_PS_USEC_OCCURS.unit_section_occurrence_id%TYPE) IS

Line 3769: CURSOR c_occurs(cp_unit_section_occurrence_id igs_ps_usec_occurs_all.unit_section_occurrence_id%TYPE) IS

3765: WHERE reference_cd_type = cp_c_ref_cd_type;
3766:
3767: rec_ref_flag c_ref_flag%ROWTYPE;
3768:
3769: CURSOR c_occurs(cp_unit_section_occurrence_id igs_ps_usec_occurs_all.unit_section_occurrence_id%TYPE) IS
3770: SELECT uso.unit_section_occurrence_id
3771: FROM igs_ps_usec_occurs_all uso
3772: WHERE (uso.schedule_status IS NOT NULL AND uso.schedule_status NOT IN ('PROCESSING','USER_UPDATE'))
3773: AND uso.no_set_day_ind ='N'

Line 3771: FROM igs_ps_usec_occurs_all uso

3767: rec_ref_flag c_ref_flag%ROWTYPE;
3768:
3769: CURSOR c_occurs(cp_unit_section_occurrence_id igs_ps_usec_occurs_all.unit_section_occurrence_id%TYPE) IS
3770: SELECT uso.unit_section_occurrence_id
3771: FROM igs_ps_usec_occurs_all uso
3772: WHERE (uso.schedule_status IS NOT NULL AND uso.schedule_status NOT IN ('PROCESSING','USER_UPDATE'))
3773: AND uso.no_set_day_ind ='N'
3774: AND uso.unit_section_occurrence_id=cp_unit_section_occurrence_id;
3775:

Line 3778: FROM igs_ps_usec_occurs_all

3774: AND uso.unit_section_occurrence_id=cp_unit_section_occurrence_id;
3775:
3776: CURSOR c_ref_code (cp_uso_id igs_ps_uso_facility.unit_section_occurrence_id%TYPE) IS
3777: SELECT 'X'
3778: FROM igs_ps_usec_occurs_all
3779: WHERE unit_section_occurrence_id = cp_uso_id
3780: AND schedule_status = 'PROCESSING';
3781:
3782: l_c_var VARCHAR2(1);

Line 3894: FROM igs_ps_usec_occurs_all

3890: Who When What
3891: ********************************************************************************************** */
3892: CURSOR occur IS
3893: SELECT unit_section_occurrence_id
3894: FROM igs_ps_usec_occurs_all
3895: WHERE uoo_id= p_uoo_id
3896: AND occurrence_identifier=p_occurrence_identifier;
3897:
3898: BEGIN

Line 3999: FROM igs_ps_usec_occurs_all

3995: l_n_uoo_id igs_ps_unit_ofr_opt_all.uoo_id%TYPE;
3996:
3997: CURSOR c_uso_chk(p_n_uso_id NUMBER) IS
3998: SELECT schedule_status,abort_flag
3999: FROM igs_ps_usec_occurs_all
4000: WHERE unit_section_occurrence_id = p_n_uso_id;
4001:
4002:
4003: c_uso_chk_rec c_uso_chk%ROWTYPE;

Line 4106: FROM igs_ps_usec_occurs_all

4102: sommukhe 15-NOV-2005 Bug# 4721543, Included the the check for cancelled status of unit section.
4103: ***********************************************************************************************/
4104: CURSOR c_uso_chk(cp_n_uso_id IN NUMBER) IS
4105: SELECT schedule_status,abort_flag
4106: FROM igs_ps_usec_occurs_all
4107: WHERE unit_section_occurrence_id = cp_n_uso_id;
4108: c_uso_chk_rec c_uso_chk%ROWTYPE;
4109:
4110: CURSOR c_usec_chk(cp_n_uoo_id IN NUMBER) IS