eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.IGS_EN_WLST_GEN_PROC dependencies on IGS_EN_OR_UNIT_WLST

Line 1126: CURSOR cur_wlst_org_pri ( cp_org_unit_cd igs_en_or_unit_wlst.org_unit_cd%TYPE ,

1122:
1123: l_load_cal_type igs_ca_inst.cal_type%TYPE;
1124:
1125: -- Cursor to select priorities at organizational unit level
1126: CURSOR cur_wlst_org_pri ( cp_org_unit_cd igs_en_or_unit_wlst.org_unit_cd%TYPE ,
1127: cp_cal_type igs_en_or_unit_wlst.cal_type%TYPE )
1128: IS
1129: SELECT owp.org_unit_wlst_pri_id, owp.priority_value, owp.priority_number
1130: FROM igs_en_orun_wlst_pri owp, igs_en_or_unit_wlst ouw

Line 1127: cp_cal_type igs_en_or_unit_wlst.cal_type%TYPE )

1123: l_load_cal_type igs_ca_inst.cal_type%TYPE;
1124:
1125: -- Cursor to select priorities at organizational unit level
1126: CURSOR cur_wlst_org_pri ( cp_org_unit_cd igs_en_or_unit_wlst.org_unit_cd%TYPE ,
1127: cp_cal_type igs_en_or_unit_wlst.cal_type%TYPE )
1128: IS
1129: SELECT owp.org_unit_wlst_pri_id, owp.priority_value, owp.priority_number
1130: FROM igs_en_orun_wlst_pri owp, igs_en_or_unit_wlst ouw
1131: WHERE ouw.org_unit_cd = cp_org_unit_cd

Line 1130: FROM igs_en_orun_wlst_pri owp, igs_en_or_unit_wlst ouw

1126: CURSOR cur_wlst_org_pri ( cp_org_unit_cd igs_en_or_unit_wlst.org_unit_cd%TYPE ,
1127: cp_cal_type igs_en_or_unit_wlst.cal_type%TYPE )
1128: IS
1129: SELECT owp.org_unit_wlst_pri_id, owp.priority_value, owp.priority_number
1130: FROM igs_en_orun_wlst_pri owp, igs_en_or_unit_wlst ouw
1131: WHERE ouw.org_unit_cd = cp_org_unit_cd
1132: AND ouw.cal_type = cp_cal_type
1133: AND owp.org_unit_wlst_id = ouw.org_unit_wlst_id
1134: AND ouw.closed_flag = 'N'

Line 1146: CURSOR cur_max_org_pri ( cp_org_unit_cd igs_en_or_unit_wlst.org_unit_cd%TYPE ,

1142: WHERE org_unit_wlst_pri_id = cp_priority_id
1143: ORDER BY preference_order;
1144:
1145: -- Cursor to select maximum number of priorities at organizational unit level
1146: CURSOR cur_max_org_pri ( cp_org_unit_cd igs_en_or_unit_wlst.org_unit_cd%TYPE ,
1147: cp_cal_type igs_en_or_unit_wlst.cal_type%TYPE )
1148: IS
1149: SELECT count(org_unit_wlst_pri_id)
1150: FROM igs_en_orun_wlst_pri owp, igs_en_or_unit_wlst ouw

Line 1147: cp_cal_type igs_en_or_unit_wlst.cal_type%TYPE )

1143: ORDER BY preference_order;
1144:
1145: -- Cursor to select maximum number of priorities at organizational unit level
1146: CURSOR cur_max_org_pri ( cp_org_unit_cd igs_en_or_unit_wlst.org_unit_cd%TYPE ,
1147: cp_cal_type igs_en_or_unit_wlst.cal_type%TYPE )
1148: IS
1149: SELECT count(org_unit_wlst_pri_id)
1150: FROM igs_en_orun_wlst_pri owp, igs_en_or_unit_wlst ouw
1151: WHERE ouw.org_unit_cd = cp_org_unit_cd

Line 1150: FROM igs_en_orun_wlst_pri owp, igs_en_or_unit_wlst ouw

1146: CURSOR cur_max_org_pri ( cp_org_unit_cd igs_en_or_unit_wlst.org_unit_cd%TYPE ,
1147: cp_cal_type igs_en_or_unit_wlst.cal_type%TYPE )
1148: IS
1149: SELECT count(org_unit_wlst_pri_id)
1150: FROM igs_en_orun_wlst_pri owp, igs_en_or_unit_wlst ouw
1151: WHERE ouw.org_unit_cd = cp_org_unit_cd
1152: AND ouw.cal_type = cp_cal_type
1153: AND owp.org_unit_wlst_id = ouw.org_unit_wlst_id
1154: AND ouw.closed_flag = 'N';

Line 1158: CURSOR cur_max_org_prf ( cp_org_unit_cd igs_en_or_unit_wlst.org_unit_cd%TYPE ,

1154: AND ouw.closed_flag = 'N';
1155: l_max_org_pri NUMBER;
1156:
1157: -- Cursor to select maximum number of preferences among all the priorities at organizational unit level
1158: CURSOR cur_max_org_prf ( cp_org_unit_cd igs_en_or_unit_wlst.org_unit_cd%TYPE ,
1159: cp_cal_type igs_en_or_unit_wlst.cal_type%TYPE )
1160: IS
1161: SELECT count(org_unit_wlst_prf_id)
1162: FROM igs_en_orun_wlst_prf

Line 1159: cp_cal_type igs_en_or_unit_wlst.cal_type%TYPE )

1155: l_max_org_pri NUMBER;
1156:
1157: -- Cursor to select maximum number of preferences among all the priorities at organizational unit level
1158: CURSOR cur_max_org_prf ( cp_org_unit_cd igs_en_or_unit_wlst.org_unit_cd%TYPE ,
1159: cp_cal_type igs_en_or_unit_wlst.cal_type%TYPE )
1160: IS
1161: SELECT count(org_unit_wlst_prf_id)
1162: FROM igs_en_orun_wlst_prf
1163: WHERE org_unit_wlst_pri_id IN(SELECT owp.org_unit_wlst_pri_id

Line 1164: FROM igs_en_orun_wlst_pri owp, igs_en_or_unit_wlst ouw

1160: IS
1161: SELECT count(org_unit_wlst_prf_id)
1162: FROM igs_en_orun_wlst_prf
1163: WHERE org_unit_wlst_pri_id IN(SELECT owp.org_unit_wlst_pri_id
1164: FROM igs_en_orun_wlst_pri owp, igs_en_or_unit_wlst ouw
1165: WHERE ouw.org_unit_cd = cp_org_unit_cd
1166: AND ouw.cal_type = cp_cal_type
1167: AND owp.org_unit_wlst_id = ouw.org_unit_wlst_id
1168: AND ouw.closed_flag = 'N');