[Home] [Help]
162: -- Removed local variable no_meeting_day_checked, all its occurrences
163: -- replaced with l_no_meeting_day_checked, added cursor cur_teach_cal
164: -- Modified cursor c_weekdays
165: --Nishikant 13Mar2003 Bug#2845730. While calculating the offset days, if the round method is
166: -- Standard then it will simply apply round function of the Duration Days/Meeting Days.
167: -------------------------------------------------------------------
168:
169: CURSOR c_call_cnstr IS
170: SELECT enr_dl_offset_cons_id FROM igs_en_dl_offset_cons
586: -- consider this as duration days (Formula method) case with meeting days Monday to Friday
587:
588: IF l_unitsectionfound = 'FALSE' THEN
589:
590: --If non standard unit section does not have occurrence at all or have only NSD occurrences
591: --then deadline date is calculated using Duration days with include weekend flag checked
592: --Set the include weekend flag as Y for this setup, bug#4114992
593: l_c_include_weekends := 'Y';
594: weekends_count := FALSE;
1645:
1646: FUNCTION f_retention_offset_date (
1647: p_n_uoo_id IN NUMBER, -- Unique Identifier for Unit Section
1648: p_c_formula_method IN VARCHAR2, -- Formula Method 'D' -> Duration Days, 'N' -> Meeting Days, 'P' -> Percentage of Duration Days, 'M' -> Percentage of Meeting Days.
1649: p_c_round_method IN VARCHAR2, -- Round Method 'S' -> Standard Round, 'A' -> Always Round
1650: p_c_incl_wkend_duration IN VARCHAR2, -- Include Weekend duration Flag 'Y' -> Duration days is calculated inclusive of weekends otherwise not.
1651: p_n_offset_value IN NUMBER) -- Offset value entered by user, may be days or percentages.
1652: RETURN DATE AS
1653:
1688: OPEN c_date (p_n_uoo_id);
1689: FETCH c_date INTO l_d_us_st_dt, l_d_end_dt;
1690: CLOSE c_date;
1691:
1692: -- Functional Validation : Unit Section Start Date is mandatory for Non Standard Unit Section.
1693: -- Otherwise calculation will not be done.
1694: IF l_d_us_st_dt IS NULL THEN
1695: l_c_msg := 'IGS_EN_OFFSET_DT_NULL';
1696: fnd_message.set_name ('IGS',l_c_msg);
1737: FUNCTION duration_days( p_n_uoo_id IN NUMBER, -- Unique Identifier for Unit Section
1738: p_d_us_st_dt IN DATE, -- Unit Section Start Date
1739: p_d_end_dt IN DATE, -- Unit Section End Date
1740: p_c_formula_method IN VARCHAR2, -- Formula Method 'D' -> Duration Days, 'P' -> Percentage of Duration Days
1741: p_c_round_method IN VARCHAR2, -- Round Method 'S' -> Standard Round, 'A' -> Always Round
1742: p_c_incl_wkend_duration IN VARCHAR2, -- Include Weekend duration Flag 'Y' -> Duration days is calculated inclusive of weekends otherwise not.
1743: p_n_offset_value IN NUMBER, -- Offset value entered by user, may be days or percentages.
1744: p_c_msg OUT NOCOPY VARCHAR2) RETURN DATE IS
1745: /***********************************************************************************************
1967: FUNCTION meeting_days( p_n_uoo_id IN NUMBER, -- Unique Identifier for Unit Section
1968: p_d_us_st_dt IN DATE, -- Unit Section Start Date
1969: p_d_end_dt IN DATE, -- Unit Section End Date
1970: p_c_formula_method IN VARCHAR2, -- Formula Method 'N' -> Meeting Days, 'M' -> Percentage of Meeting Days.
1971: p_c_round_method IN VARCHAR2, -- Round Method 'S' -> Standard Round, 'A' -> Always Round
1972: p_c_incl_wkend_duration IN VARCHAR2, -- Include Weekend duration Flag 'Y' -> Duration days is calculated inclusive of weekends otherwise not.
1973: p_n_offset_value IN NUMBER, -- Offset value entered by user, may be days or percentages.
1974: p_c_msg OUT NOCOPY VARCHAR2) RETURN DATE IS
1975:
2377: ********************************************************************************************** */
2378:
2379: BEGIN
2380:
2381: -- if the round method is Standard then use normal rounding (ie. 4.2 = 4, 4.5 = 5, 4.6 = 5)
2382: IF p_c_round_method = 'S' THEN
2383: p_n_value := ROUND(p_n_value);
2384: ELSIF p_c_round_method ='A' THEN
2385: -- if the round method is Always Round up then use ceil value(ie. 4.2 = 5, 4.5 = 5, 4.6 = 5)