DBA Data[Home] [Help]

APPS.GME_CREATE_STEP_PVT dependencies on GMP_CALENDAR_API

Line 1877: l_contig_period_tbl gmp_calendar_api.contig_period_tbl;

1873: ,p_offset IN NUMBER
1874: ,p_calendar_code IN VARCHAR2)
1875: RETURN DATE
1876: IS
1877: l_contig_period_tbl gmp_calendar_api.contig_period_tbl;
1878: l_diff NUMBER;
1879: l_start_date DATE;
1880: l_cal_count NUMBER;
1881: l_return_status VARCHAR2 (1);

Line 1900: gmp_calendar_api.get_contiguous_periods

1896: gme_debug.put_line ('start date passed in is '||TO_CHAR(p_start_date, 'DD-MON-YYYY HH24:MI:SS')); -- Bug 13582990
1897: gme_debug.put_line ('duration passed in is '||p_offset); -- Bug 13582990
1898: gme_debug.put_line ('p_calendar_code passed in is '||p_calendar_code); -- Bug 13582990
1899: END IF;
1900: gmp_calendar_api.get_contiguous_periods
1901: (p_api_version => 1
1902: ,p_init_msg_list => TRUE
1903: ,p_start_date => p_start_date
1904: ,p_end_date => NULL

Line 1927: gmp_calendar_api.get_contiguous_periods

1923: gme_debug.put_line ('END date passed in is '||TO_CHAR(p_start_date, 'DD-MON-YYYY HH24:MI:SS')); -- Bug 13582990
1924: gme_debug.put_line ('duration passed in is '||ABS(p_offset)); -- Bug 13582990
1925: gme_debug.put_line ('p_calendar_code passed in is '||p_calendar_code); -- Bug 13582990
1926: END IF;
1927: gmp_calendar_api.get_contiguous_periods
1928: (p_api_version => 1
1929: ,p_init_msg_list => TRUE
1930: ,p_start_date => NULL
1931: ,p_end_date => p_start_date

Line 1949: IF gmp_calendar_api.is_working_daytime

1945: gme_debug.put_line ('rows returned from get_contiguous_periods is '||l_cal_count); -- Bug 13582990
1946: END IF;
1947: END IF; /* p_offset >= 0 */
1948:
1949: IF gmp_calendar_api.is_working_daytime
1950: (p_api_version => 1
1951: ,p_init_msg_list => TRUE
1952: ,p_calendar_code => p_calendar_code
1953: ,p_date => l_start_date

Line 1957: ELSE /* gmp_calendar_api.is_working_daytime */

1953: ,p_date => l_start_date
1954: ,p_ind => 0
1955: ,x_return_status => l_return_status) THEN
1956: RETURN l_start_date;
1957: ELSE /* gmp_calendar_api.is_working_daytime */
1958: l_diff := 1 / 3600;
1959:
1960: IF NVL (g_debug, -1) = gme_debug.g_log_statement THEN
1961: gme_debug.put_line (l_api_name || ':l_diff ' || l_diff);

Line 1972: gmp_calendar_api.get_contiguous_periods

1968: gme_debug.put_line ('start date passed in is '||TO_CHAR(l_start_date, 'DD-MON-YYYY HH24:MI:SS')); -- Bug 13582990
1969: gme_debug.put_line ('duration passed in is '||l_diff); -- Bug 13582990
1970: gme_debug.put_line ('p_calendar_code passed in is '||p_calendar_code); -- Bug 13582990
1971: END IF;
1972: gmp_calendar_api.get_contiguous_periods
1973: (p_api_version => 1
1974: ,p_init_msg_list => TRUE
1975: ,p_start_date => l_start_date
1976: ,p_end_date => NULL

Line 2000: gmp_calendar_api.get_contiguous_periods

1996: gme_debug.put_line ('END date passed in is '||TO_CHAR(l_start_date, 'DD-MON-YYYY HH24:MI:SS')); -- Bug 13582990
1997: gme_debug.put_line ('duration passed in is '||l_diff); -- Bug 13582990
1998: gme_debug.put_line ('p_calendar_code passed in is '||p_calendar_code); -- Bug 13582990
1999: END IF;
2000: gmp_calendar_api.get_contiguous_periods
2001: (p_api_version => 1
2002: ,p_init_msg_list => TRUE
2003: ,p_start_date => NULL
2004: ,p_end_date => l_start_date

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

2018: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
2019: gme_debug.put_line ('rows returned from get_contiguous_periods is '||l_cal_count); -- Bug 13582990
2020: END IF;
2021: END IF; /* p_offset > 0 */
2022: END IF; /* gmp_calendar_api.is_working_daytime */
2023:
2024: IF g_debug <= gme_debug.g_log_procedure THEN
2025: gme_debug.put_line ('Exiting api ' || g_pkg_name || '.' || l_api_name);
2026: END IF;

Line 2093: l_contig_period_tbl gmp_calendar_api.contig_period_tbl;

2089: l_usage_hrs gme_batch_step_resources.plan_rsrc_usage%TYPE;
2090: l_batchstep_activity_id NUMBER;
2091: l_batchstep_id NUMBER;
2092: l_cal_count NUMBER;
2093: l_contig_period_tbl gmp_calendar_api.contig_period_tbl;
2094: l_duration NUMBER;
2095: l_activity VARCHAR2 (80);
2096: l_api_name CONSTANT VARCHAR2 (30) := 'Calc dates';
2097:

Line 2268: gmp_calendar_api.get_contiguous_periods

2264: gme_debug.put_line ('duration passed in is '||l_step_duration_tab(x_step_no)); -- Bug 13582990
2265: gme_debug.put_line ('p_calendar_code passed in is '||l_calendar_code); -- Bug 13582990
2266: END IF;
2267:
2268: gmp_calendar_api.get_contiguous_periods
2269: (p_api_version => 1
2270: ,p_init_msg_list => TRUE
2271: ,p_start_date => NULL
2272: ,p_end_date => p_plan_cmplt_date

Line 2324: gmp_calendar_api.get_contiguous_periods

2320: gme_debug.put_line ('duration passed in is '||x_batch_duration); -- Bug 13582990
2321: gme_debug.put_line ('p_calendar_code passed in is '||l_calendar_code); -- Bug 13582990
2322: END IF;
2323:
2324: gmp_calendar_api.get_contiguous_periods
2325: (p_api_version => 1
2326: ,p_init_msg_list => TRUE
2327: ,p_start_date => p_gme_batch_header_rec.plan_start_date
2328: ,p_end_date => NULL

Line 2379: gmp_calendar_api.get_contiguous_periods

2375: gme_debug.put_line ('duration passed in is '||x_batch_duration); -- Bug 13582990
2376: gme_debug.put_line ('p_calendar_code passed in is '||l_calendar_code); -- Bug 13582990
2377: END IF;
2378:
2379: gmp_calendar_api.get_contiguous_periods
2380: (p_api_version => 1
2381: ,p_init_msg_list => TRUE
2382: ,p_start_date => NULL
2383: ,p_end_date => p_gme_batch_header_rec.plan_cmplt_date

Line 2437: gmp_calendar_api.get_contiguous_periods

2433: gme_debug.put_line ('duration passed in is '||x_batch_duration); -- Bug 13582990
2434: gme_debug.put_line ('p_calendar_code passed in is '||l_calendar_code); -- Bug 13582990
2435: END IF;
2436:
2437: gmp_calendar_api.get_contiguous_periods
2438: (p_api_version => 1
2439: ,p_init_msg_list => TRUE
2440: ,p_start_date => gme_common_pvt.g_timestamp
2441: ,p_end_date => NULL

Line 2623: gmp_calendar_api.get_contiguous_periods

2619: gme_debug.put_line ('duration passed in is '||l_duration); -- Bug 13582990
2620: gme_debug.put_line ('p_calendar_code passed in is '||l_calendar_code); -- Bug 13582990
2621: END IF;
2622:
2623: gmp_calendar_api.get_contiguous_periods
2624: (p_api_version => 1
2625: ,p_init_msg_list => TRUE
2626: ,p_start_date => x_rsrc_tab (k).plan_start_date
2627: ,p_end_date => NULL