APPS.OKL_STRM_GEN_TEMPLATE_PVT dependencies on FND_NUMBER

Line 419: l_version := TRIM(TO_CHAR( FND_NUMBER.CANONICAL_TO_NUMBER( l_gttv_rec_in.version ) -1 ) ) || '.0'; -- Bug 10369520

415: --2.
416: IF l_tmpt_status = G_INIT_TMPT_STATUS AND l_gttv_rec_in.version <> '1.0' --meaning its greater than 1.0
417: THEN
418:
419: l_version := TRIM(TO_CHAR( FND_NUMBER.CANONICAL_TO_NUMBER( l_gttv_rec_in.version ) -1 ) ) || '.0'; -- Bug 10369520
420: --Fetch prev version and check for start date violations
421: FOR gts_id_rec IN fetch_gtt_ver_dtls_csr( l_gttv_rec_in.gts_id,l_version)
422: LOOP
423: IF trunc(l_gttv_rec_in.start_date) <= trunc(gts_id_rec.end_date) --(prev vers startdate)

Line 439: l_version := TRIM(TO_CHAR(FND_NUMBER.CANONICAL_TO_NUMBER( l_gttv_rec_in.version ) -1 ) ) || '.0'; -- Bug 10369520

435: IF l_tmpt_status = G_INIT_TMPT_STATUS AND l_gttv_rec_in.version <> '1.0' --meaning its greater than 1.0
436: THEN
437:
438: --Fetch previous version end date and set to one less than this start date
439: l_version := TRIM(TO_CHAR(FND_NUMBER.CANONICAL_TO_NUMBER( l_gttv_rec_in.version ) -1 ) ) || '.0'; -- Bug 10369520
440: FOR gts_id_rec IN fetch_gtt_ver_dtls_csr( l_gttv_rec_in.gts_id,l_version)
441: LOOP
442: l_new_gttv_in_rec.id := gts_id_rec.id;
443: l_new_gttv_in_rec.gts_id := gts_id_rec.gts_id;

Line 463: SELECT max(FND_NUMBER.CANONICAL_TO_NUMBER(version)) -- Bug 10369520

459:
460: --4.
461: IF l_tmpt_status = G_STATUS_ACTIVE THEN
462: -- Bug 9435866
463: SELECT max(FND_NUMBER.CANONICAL_TO_NUMBER(version)) -- Bug 10369520
464: INTO l_max_version
465: FROM OKL_ST_GEN_TEMPLATES
466: WHERE gts_id = (SELECT gts_id
467: FROM OKL_ST_GEN_TEMPLATES

Line 471: IF FND_NUMBER.CANONICAL_TO_NUMBER(l_gttv_rec_in.version) = l_max_version THEN -- Bug 10369520

467: FROM OKL_ST_GEN_TEMPLATES
468: WHERE id = l_gttv_rec_in.id);
469:
470: -- The following check should be done for the latest version
471: IF FND_NUMBER.CANONICAL_TO_NUMBER(l_gttv_rec_in.version) = l_max_version THEN -- Bug 10369520
472:
473: -- End Bug 9435866
474: --Max contract start date which used this SGT
475: OPEN okl_new_version_date_csr(l_gttv_rec_in.id);

Line 497: l_version := TRIM(TO_CHAR( FND_NUMBER.CANONICAL_TO_NUMBER( l_gttv_rec_in.version ) +1 ) ) || '.0'; -- Bug 10369520

493: END IF;
494:
495: IF l_gttv_rec_in.end_date IS NOT NULL AND (trunc(l_gttv_rec_in.end_date) <> trunc(l_end_date)) THEN --Eff to date has changed on this version
496: --Fetch next version start date and set to one greater than this end date
497: l_version := TRIM(TO_CHAR( FND_NUMBER.CANONICAL_TO_NUMBER( l_gttv_rec_in.version ) +1 ) ) || '.0'; -- Bug 10369520
498: FOR gts_id_rec IN fetch_gtt_ver_dtls_csr( l_gttv_rec_in.gts_id,l_version)
499: LOOP
500: --Cant update Eff To if there are successive versions which are active
501: IF gts_id_rec.tmpt_status = G_STATUS_ACTIVE THEN

Line 993: l_gttv_rec_in.version := TRIM(TO_CHAR( FND_NUMBER.CANONICAL_TO_NUMBER( l_gttv_rec_in.version ) + 1 ) ) || '.0'; -- Bug 10369520

989: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
990: RAISE OKL_API.G_EXCEPTION_ERROR;
991: END IF;
992: -- Modifications for New Version
993: l_gttv_rec_in.version := TRIM(TO_CHAR( FND_NUMBER.CANONICAL_TO_NUMBER( l_gttv_rec_in.version ) + 1 ) ) || '.0'; -- Bug 10369520
994: l_gttv_rec_in.start_date := l_gttv_rec_prev_version_out.end_date + 1;
995:
996: END IF;
997: l_gttv_rec_in.id := G_MISS_NUM;