[Home] [Help]
2279: -- Cursor to get region code information to be exported to flat file
2280: CURSOR c_region IS
2281: SELECT lookup_code,meaning,description,tag,start_date_active,end_date_active,enabled_flag,closed_ind
2282: FROM igs_lookup_values
2283: WHERE lookup_type = 'IGS_OR_LOC_REGION'
2284: AND enabled_flag = 'Y'
2285: AND TRUNC(SYSDATE) BETWEEN TRUNC(NVL(start_date_active,TRUNC(SYSDATE))) AND TRUNC(NVL(end_date_active,TRUNC(SYSDATE)))
2286: ORDER BY lookup_code;
2287:
2325: -- local variable added as part of bug#2833850 to hold the export flat file name for preferred region
2326: rec_reg_fname c_reg_fname%ROWTYPE;
2327:
2328: -- Cursor added as part of bug#2833850
2329: CURSOR c_loc_reg_map(cp_c_loc_cd IN igs_or_loc_region.location_cd%TYPE) IS
2330: SELECT region_cd
2331: FROM igs_or_loc_region
2332: WHERE location_cd = cp_c_loc_cd;
2333:
2327:
2328: -- Cursor added as part of bug#2833850
2329: CURSOR c_loc_reg_map(cp_c_loc_cd IN igs_or_loc_region.location_cd%TYPE) IS
2330: SELECT region_cd
2331: FROM igs_or_loc_region
2332: WHERE location_cd = cp_c_loc_cd;
2333:
2334: procedure prof_value_pres_pvt(p_isthere OUT NOCOPY varchar2) AS
2335: /**********************************************************
4468:
4469: -- Following transferred information is printed in log file if procedure log_usec_occurs is called from
4470: -- Initiate Scheduling Unit Section Occurrence process
4471: IF p_c_call = 'I' THEN
4472: OPEN cur_lookup_meaning('IGS_OR_LOC_REGION',p_usec_occur_rec.preferred_region_code);
4473: FETCH cur_lookup_meaning INTO l_prf_reg_desc;
4474: CLOSE cur_lookup_meaning;
4475: log_messages(igs_ps_validate_lgcy_pkg.get_lkup_meaning('IGSPS130-CG$TABPAGE_2','GE_CFG_TAB'),l_prf_reg_desc,20);
4476: END IF;