[Home] [Help]
2059: ,x_calendar_assigned OUT NOCOPY VARCHAR2
2060: ,x_return_code OUT NOCOPY VARCHAR2
2061: ,x_error_msg OUT NOCOPY VARCHAR2)
2062: IS
2063: l_output_tbl gmp_calendar_api.date_tbl;
2064: l_nb_record BINARY_INTEGER := 0;
2065: l_record_ind BINARY_INTEGER := 1;
2066: l_cal_rec VARCHAR2 (15);
2067: l_cal_rec_tbl VARCHAR2 (32000);
2093: RAISE inv_calendar_sel;
2094: END IF;
2095: END IF;
2096:
2097: gmp_calendar_api.get_all_dates (p_api_version => 1
2098: ,p_init_msg_list => FALSE
2099: ,p_calendar_code => g_mfg_calendar_code
2100: ,p_start_date => p_from_date
2101: ,p_end_date => p_to_date
2166: ,x_error_msg OUT NOCOPY VARCHAR2)
2167: IS
2168: l_api_name CONSTANT VARCHAR2 (30) := 'Validate_Reschedule_Event';
2169: l_is_working_day BOOLEAN;
2170: l_contig_period_tbl gmp_calendar_api.contig_period_tbl;
2171: l_batch_duration NUMBER;
2172: l_contiguity_ind NUMBER;
2173: l_batch_no VARCHAR2 (32);
2174: non_work_time EXCEPTION;
2186: END IF;
2187:
2188: IF p_start_date IS NOT NULL THEN
2189: l_is_working_day :=
2190: gmp_calendar_api.is_working_daytime
2191: (p_api_version => 1
2192: ,p_init_msg_list => TRUE
2193: ,p_calendar_code => g_mfg_calendar_code
2194: ,p_date => p_start_date
2216: END IF;
2217:
2218: IF p_end_date IS NOT NULL THEN
2219: l_is_working_day :=
2220: gmp_calendar_api.is_working_daytime
2221: (p_api_version => 1
2222: ,p_init_msg_list => TRUE
2223: ,p_calendar_code => g_mfg_calendar_code
2224: ,p_date => p_end_date