DBA Data[Home] [Help]

APPS.GME_CREATE_STEP_PVT dependencies on GMP_CALENDAR_API

Line 1792: l_contig_period_tbl gmp_calendar_api.contig_period_tbl;

1788: ,p_offset IN NUMBER
1789: ,p_calendar_code IN VARCHAR2)
1790: RETURN DATE
1791: IS
1792: l_contig_period_tbl gmp_calendar_api.contig_period_tbl;
1793: l_diff NUMBER;
1794: l_start_date DATE;
1795: l_cal_count NUMBER;
1796: l_return_status VARCHAR2 (1);

Line 1809: gmp_calendar_api.get_contiguous_periods

1805: RETURN NULL;
1806: END IF;
1807:
1808: IF p_offset >= 0 THEN
1809: gmp_calendar_api.get_contiguous_periods
1810: (p_api_version => 1
1811: ,p_init_msg_list => TRUE
1812: ,p_start_date => p_start_date
1813: ,p_end_date => NULL

Line 1826: gmp_calendar_api.get_contiguous_periods

1822:
1823: l_cal_count := l_contig_period_tbl.COUNT;
1824: l_start_date := l_contig_period_tbl (l_cal_count).end_date;
1825: ELSE /* p_offset >= 0 */
1826: gmp_calendar_api.get_contiguous_periods
1827: (p_api_version => 1
1828: ,p_init_msg_list => TRUE
1829: ,p_start_date => NULL
1830: ,p_end_date => p_start_date

Line 1844: IF gmp_calendar_api.is_working_daytime

1840: l_cal_count := l_contig_period_tbl.COUNT;
1841: l_start_date := l_contig_period_tbl (l_cal_count).start_date;
1842: END IF; /* p_offset >= 0 */
1843:
1844: IF gmp_calendar_api.is_working_daytime
1845: (p_api_version => 1
1846: ,p_init_msg_list => TRUE
1847: ,p_calendar_code => p_calendar_code
1848: ,p_date => l_start_date

Line 1852: ELSE /* gmp_calendar_api.is_working_daytime */

1848: ,p_date => l_start_date
1849: ,p_ind => 0
1850: ,x_return_status => l_return_status) THEN
1851: RETURN l_start_date;
1852: ELSE /* gmp_calendar_api.is_working_daytime */
1853: l_diff := 1 / 3600;
1854:
1855: IF NVL (g_debug, -1) = gme_debug.g_log_statement THEN
1856: gme_debug.put_line (l_api_name || ':l_diff ' || l_diff);

Line 1861: gmp_calendar_api.get_contiguous_periods

1857: END IF;
1858:
1859: IF p_offset > 0 THEN
1860: /* If offset was 0 then the l_start_date is the working date time */
1861: gmp_calendar_api.get_contiguous_periods
1862: (p_api_version => 1
1863: ,p_init_msg_list => TRUE
1864: ,p_start_date => l_start_date
1865: ,p_end_date => NULL

Line 1879: gmp_calendar_api.get_contiguous_periods

1875: l_cal_count := l_contig_period_tbl.COUNT;
1876: l_start_date :=
1877: (l_contig_period_tbl (l_cal_count).end_date - (l_diff / 24) );
1878: ELSE /* p_offset > 0 */
1879: gmp_calendar_api.get_contiguous_periods
1880: (p_api_version => 1
1881: ,p_init_msg_list => TRUE
1882: ,p_start_date => NULL
1883: ,p_end_date => l_start_date

Line 1897: END IF; /* gmp_calendar_api.is_working_daytime */

1893: l_cal_count := l_contig_period_tbl.COUNT;
1894: l_start_date :=
1895: (l_contig_period_tbl (l_cal_count).start_date + (l_diff / 24) );
1896: END IF; /* p_offset > 0 */
1897: END IF; /* gmp_calendar_api.is_working_daytime */
1898:
1899: IF g_debug <= gme_debug.g_log_procedure THEN
1900: gme_debug.put_line ('Exiting api ' || g_pkg_name || '.' || l_api_name);
1901: END IF;

Line 1968: l_contig_period_tbl gmp_calendar_api.contig_period_tbl;

1964: l_usage_hrs gme_batch_step_resources.plan_rsrc_usage%TYPE;
1965: l_batchstep_activity_id NUMBER;
1966: l_batchstep_id NUMBER;
1967: l_cal_count NUMBER;
1968: l_contig_period_tbl gmp_calendar_api.contig_period_tbl;
1969: l_duration NUMBER;
1970: l_activity VARCHAR2 (80);
1971: l_api_name CONSTANT VARCHAR2 (30) := 'Calc dates';
1972:

Line 2134: gmp_calendar_api.get_contiguous_periods

2130: || TO_CHAR (p_plan_cmplt_date
2131: ,'DD-MON-YYYY HH24:MI:SS') );
2132: END IF;
2133:
2134: gmp_calendar_api.get_contiguous_periods
2135: (p_api_version => 1
2136: ,p_init_msg_list => TRUE
2137: ,p_start_date => NULL
2138: ,p_end_date => p_plan_cmplt_date

Line 2187: gmp_calendar_api.get_contiguous_periods

2183: (p_gme_batch_header_rec.plan_cmplt_date
2184: ,'DD-MON-YYYY HH24:MI:SS') );
2185: END IF;
2186:
2187: gmp_calendar_api.get_contiguous_periods
2188: (p_api_version => 1
2189: ,p_init_msg_list => TRUE
2190: ,p_start_date => p_gme_batch_header_rec.plan_start_date
2191: ,p_end_date => NULL

Line 2238: gmp_calendar_api.get_contiguous_periods

2234: (p_gme_batch_header_rec.plan_cmplt_date
2235: ,'DD-MON-YYYY HH24:MI:SS') );
2236: END IF;
2237:
2238: gmp_calendar_api.get_contiguous_periods
2239: (p_api_version => 1
2240: ,p_init_msg_list => TRUE
2241: ,p_start_date => NULL
2242: ,p_end_date => p_gme_batch_header_rec.plan_cmplt_date

Line 2291: gmp_calendar_api.get_contiguous_periods

2287: (p_gme_batch_header_rec.plan_cmplt_date
2288: ,'DD-MON-YYYY HH24:MI:SS') );
2289: END IF;
2290:
2291: gmp_calendar_api.get_contiguous_periods
2292: (p_api_version => 1
2293: ,p_init_msg_list => TRUE
2294: ,p_start_date => gme_common_pvt.g_timestamp
2295: ,p_end_date => NULL

Line 2463: gmp_calendar_api.get_contiguous_periods

2459: l_duration := l_usage_hrs / x_rsrc_tab (k).plan_rsrc_count;
2460:
2461: IF l_use_workday_cal = fnd_api.g_true
2462: AND l_calendar_code IS NOT NULL THEN
2463: gmp_calendar_api.get_contiguous_periods
2464: (p_api_version => 1
2465: ,p_init_msg_list => TRUE
2466: ,p_start_date => x_rsrc_tab (k).plan_start_date
2467: ,p_end_date => NULL