APPS.OKC_TIME_RES_PVT dependencies on OKC_TIME_RES_PVT

Line 1: Package BODY OKC_TIME_RES_PVT AS

1: Package BODY OKC_TIME_RES_PVT AS
2: /* $Header: OKCCRESB.pls 120.2 2006/02/24 15:11:51 smallya noship $ */
3:
4: l_debug VARCHAR2(1) := NVL(FND_PROFILE.VALUE('AFLOG_ENABLED'),'N');
5:

Line 1287: p_resolved_until_date => add_months(sysdate,(OKC_TIME_RES_PVT.RESOLVE_UNTIL_MONTHS +

1283: x_return_status OUT NOCOPY VARCHAR2) IS
1284:
1285: BEGIN
1286: Res_Time_K(p_chr_id => p_chr_id,
1287: p_resolved_until_date => add_months(sysdate,(OKC_TIME_RES_PVT.RESOLVE_UNTIL_MONTHS +
1288: OKC_TIME_RES_PVT.PICKUP_UPTO_MONTHS)) ,
1289: p_cutoff_date => sysdate,
1290: p_api_version => p_api_version,
1291: p_init_msg_list => p_init_msg_list,

Line 1288: OKC_TIME_RES_PVT.PICKUP_UPTO_MONTHS)) ,

1284:
1285: BEGIN
1286: Res_Time_K(p_chr_id => p_chr_id,
1287: p_resolved_until_date => add_months(sysdate,(OKC_TIME_RES_PVT.RESOLVE_UNTIL_MONTHS +
1288: OKC_TIME_RES_PVT.PICKUP_UPTO_MONTHS)) ,
1289: p_cutoff_date => sysdate,
1290: p_api_version => p_api_version,
1291: p_init_msg_list => p_init_msg_list,
1292: x_return_status => x_return_status);

Line 1406: l_resolved_until_date := add_months(sysdate,OKC_TIME_RES_PVT.RESOLVE_UNTIL_MONTHS);

1402: end if;
1403: end if;
1404: elsif p_chr_id is NOT NULL AND
1405: p_chr_id <> OKC_API.G_MISS_NUM Then
1406: l_resolved_until_date := add_months(sysdate,OKC_TIME_RES_PVT.RESOLVE_UNTIL_MONTHS);
1407: if l_end_date <= l_resolved_until_date then
1408: l_over_further_resolving := '1';
1409: else
1410: l_end_date := l_resolved_until_date;

Line 1864: where resolved_until < add_months(sysdate, OKC_TIME_RES_PVT.PICKUP_UPTO_MONTHS)

1860:
1861: PROCEDURE Batch_Resolve_Time_N_Tasks IS
1862: CURSOR c_chr IS
1863: SELECT contract_number, id, resolved_until from OKC_K_HEADERS_B
1864: where resolved_until < add_months(sysdate, OKC_TIME_RES_PVT.PICKUP_UPTO_MONTHS)
1865: and resolved_until >= sysdate;
1866: x_return_status VARCHAR2(1);
1867: l_init_msg_list VARCHAR2(1) := 'F';
1868: l_api_version NUMBER := 1.0;

Line 1880: -- l_resolved_until_date := add_months(sysdate, OKC_TIME_RES_PVT.RESOLVE_UNTIL_MONTHS);

1876: reset the resolved until dates for the contract
1877: to null and will never be picked up.
1878: */
1879:
1880: -- l_resolved_until_date := add_months(sysdate, OKC_TIME_RES_PVT.RESOLVE_UNTIL_MONTHS);
1881: for chr_rec in c_chr LOOP
1882: l_resolved_until_date := add_months(chr_rec.resolved_until, OKC_TIME_RES_PVT.RESOLVE_UNTIL_MONTHS);
1883: Res_Time_K(p_chr_id => chr_rec.id,
1884: p_resolved_until_date => l_resolved_until_date,

Line 1882: l_resolved_until_date := add_months(chr_rec.resolved_until, OKC_TIME_RES_PVT.RESOLVE_UNTIL_MONTHS);

1878: */
1879:
1880: -- l_resolved_until_date := add_months(sysdate, OKC_TIME_RES_PVT.RESOLVE_UNTIL_MONTHS);
1881: for chr_rec in c_chr LOOP
1882: l_resolved_until_date := add_months(chr_rec.resolved_until, OKC_TIME_RES_PVT.RESOLVE_UNTIL_MONTHS);
1883: Res_Time_K(p_chr_id => chr_rec.id,
1884: p_resolved_until_date => l_resolved_until_date,
1885: p_cutoff_date => chr_rec.resolved_until,
1886: p_api_version => l_api_version,

Line 1916: OKC_TIME_RES_PVT.Batch_Resolve_Time_N_Tasks;

1912: );
1913: --Initialize the return code
1914: retcode := 0;
1915:
1916: OKC_TIME_RES_PVT.Batch_Resolve_Time_N_Tasks;
1917:
1918: IF l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
1919: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1920: ELSIF l_return_status = OKC_API.G_RET_STS_ERROR THEN

Line 1964: END OKC_TIME_RES_PVT;

1960: l_msg_data,
1961: '_COMPLEX');
1962: END time_resolver;
1963:
1964: END OKC_TIME_RES_PVT;