eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OKL_PROCESS_PROVISIONS_PVT dependencies on OKL_PROVISIONS

Line 5: -- PROCEDURE get_rec for: OKL_PROVISIONS_V

1: PACKAGE BODY OKL_PROCESS_PROVISIONS_PVT AS
2: /* $Header: OKLRPRVB.pls 115.6 2002/02/18 20:12:38 pkm ship $ */
3:
4: ---------------------------------------------------------------------------
5: -- PROCEDURE get_rec for: OKL_PROVISIONS_V
6: ---------------------------------------------------------------------------
7: PROCEDURE get_rec (p_pvnv_rec IN pvnv_rec_type,
8: x_return_status OUT NOCOPY VARCHAR2,
9: x_no_data_found OUT NOCOPY BOOLEAN,

Line 47: FROM OKL_PROVISIONS

43: CREATION_DATE,
44: LAST_UPDATE_DATE,
45: NVL(LAST_UPDATE_LOGIN,G_MISS_NUM) LAST_UPDATE_LOGIN
46:
47: FROM OKL_PROVISIONS
48: WHERE id = p_id;
49:
50: l_okl_pvnv_pk okl_pvnv_pk_csr%ROWTYPE;
51: l_pvnv_rec pvnv_rec_type;

Line 116: -- PROCEDURE get_changes_only for: OKL_PROVISIONS_V

112:
113: END get_rec;
114:
115: ---------------------------------------------------------------------------
116: -- PROCEDURE get_changes_only for: OKL_PROVISIONS_V
117: -- To take care of the assumption that Everything except the Changed Fields
118: -- have G_MISS values in them
119: ---------------------------------------------------------------------------
120: PROCEDURE get_changes_only (p_pvnv_rec IN pvnv_rec_type,

Line 304: -- PROCEDURE determine_action for: OKL_PROVISIONS_V

300: x_pvnv_rec := l_pvnv_rec;
301: END get_changes_only;
302:
303: ---------------------------------------------------------------------------
304: -- PROCEDURE determine_action for: OKL_PROVISIONS_V
305: -- This function helps in determining the various checks to be performed
306: -- for the new/updated record and also helps in determining whether a new
307: -- version is required or not
308: ---------------------------------------------------------------------------

Line 385: p_view => 'OKL_PROVISIONS_V',

381: p_start_date_attribute_name => 'FROM_DATE',
382: p_start_date => l_pvnv_rec.from_date,
383: p_end_date_attribute_name => 'TO_DATE',
384: p_end_date => l_pvnv_rec.to_date,
385: p_view => 'OKL_PROVISIONS_V',
386: x_return_status => l_return_status,
387: x_valid => l_valid);
388:
389:

Line 422: -- PROCEDURE create_provisions for: OKL_PROVISIONS_V

418: END check_updates;
419:
420:
421: ---------------------------------------------------------------------------
422: -- PROCEDURE create_provisions for: OKL_PROVISIONS_V
423: ---------------------------------------------------------------------------
424: PROCEDURE create_provisions(p_api_version IN NUMBER,
425: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
426: x_return_status OUT NOCOPY VARCHAR2,

Line 508: OKL_PROVISIONS_PUB.INSERT_PROVISIONS(p_api_version => l_api_version,

504: END IF;
505:
506:
507: /* public api to insert provision type */
508: OKL_PROVISIONS_PUB.INSERT_PROVISIONS(p_api_version => l_api_version,
509: p_init_msg_list => p_init_msg_list,
510: x_return_status => l_return_status,
511: x_msg_count => x_msg_count,
512: x_msg_data => x_msg_data,

Line 551: -- PROCEDURE update_provisions for: OKL_PROVISIONS_V

547:
548: END create_provisions;
549:
550: ---------------------------------------------------------------------------
551: -- PROCEDURE update_provisions for: OKL_PROVISIONS_V
552: ---------------------------------------------------------------------------
553: PROCEDURE update_provisions(p_api_version IN NUMBER,
554: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
555: x_return_status OUT NOCOPY VARCHAR2,

Line 641: OKL_PROVISIONS_PUB.UPDATE_PROVISIONS(p_api_version => l_api_version,

637:
638: /* Scenario 1: The Changed Field-Values can by-pass Validation */
639: IF l_action = '1' THEN
640: /* public api to update provisions*/
641: OKL_PROVISIONS_PUB.UPDATE_PROVISIONS(p_api_version => l_api_version,
642: p_init_msg_list => p_init_msg_list,
643: x_return_status => l_return_status,
644: x_msg_count => x_msg_count,
645: x_msg_data => x_msg_data,

Line 669: OKL_PROVISIONS_PUB.UPDATE_PROVISIONS(p_api_version => l_api_version,

665: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
666: END IF;
667:
668: /* public api to update provisions */
669: OKL_PROVISIONS_PUB.UPDATE_PROVISIONS(p_api_version => l_api_version,
670: p_init_msg_list => p_init_msg_list,
671: x_return_status => l_return_status,
672: x_msg_count => x_msg_count,
673: x_msg_data => x_msg_data,

Line 709: OKL_PROVISIONS_PUB.UPDATE_PROVISIONS(p_api_version => l_api_version,

705: END IF;
706: END IF;
707:
708: /* public api to update provisions */
709: OKL_PROVISIONS_PUB.UPDATE_PROVISIONS(p_api_version => l_api_version,
710: p_init_msg_list => p_init_msg_list,
711: x_return_status => l_return_status,
712: x_msg_count => x_msg_count,
713: x_msg_data => x_msg_data,

Line 741: p_view => 'OKL_PROVISIONS_V',

737: p_attrib_tbl => l_attrib_tbl,
738: p_cur_version => l_pvnv_rec.version,
739: p_end_date_attribute_name => 'TO_DATE',
740: p_end_date => l_pvnv_rec.to_date,
741: p_view => 'OKL_PROVISIONS_V',
742: x_return_status => l_return_status,
743: x_new_version => l_new_version);
744:
745: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN

Line 767: OKL_PROVISIONS_PUB.INSERT_PROVISIONS(p_api_version => l_api_version,

763: END IF;
764: END IF;
765:
766: /* public api to insert provisions */
767: OKL_PROVISIONS_PUB.INSERT_PROVISIONS(p_api_version => l_api_version,
768: p_init_msg_list => p_init_msg_list,
769: x_return_status => l_return_status,
770: x_msg_count => x_msg_count,
771: x_msg_data => x_msg_data,

Line 829: OKL_PROVISIONS_PUB.INSERT_PROVISIONS(p_api_version => l_api_version,

825: l_api_version NUMBER := 1.0;
826:
827: BEGIN
828:
829: OKL_PROVISIONS_PUB.INSERT_PROVISIONS(p_api_version => l_api_version,
830: p_init_msg_list => p_init_msg_list,
831: x_return_status => x_return_Status,
832: x_msg_count => x_msg_count,
833: x_msg_data => x_msg_data,

Line 853: OKL_PROVISIONS_PUB.UPDATE_PROVISIONS(p_api_version => l_api_version,

849: l_api_version NUMBER := 1.0;
850:
851: BEGIN
852:
853: OKL_PROVISIONS_PUB.UPDATE_PROVISIONS(p_api_version => l_api_version,
854: p_init_msg_list => p_init_msg_list,
855: x_return_status => x_return_Status,
856: x_msg_count => x_msg_count,
857: x_msg_data => x_msg_data,

Line 877: OKL_PROVISIONS_PUB.DELETE_PROVISIONS(p_api_version => l_api_version,

873: l_api_version NUMBER := 1.0;
874:
875: BEGIN
876:
877: OKL_PROVISIONS_PUB.DELETE_PROVISIONS(p_api_version => l_api_version,
878: p_init_msg_list => p_init_msg_list,
879: x_return_status => x_return_Status,
880: x_msg_count => x_msg_count,
881: x_msg_data => x_msg_data,

Line 901: OKL_PROVISIONS_PUB.DELETE_PROVISIONS(p_api_version => l_api_version,

897: l_api_version NUMBER := 1.0;
898:
899: BEGIN
900:
901: OKL_PROVISIONS_PUB.DELETE_PROVISIONS(p_api_version => l_api_version,
902: p_init_msg_list => p_init_msg_list,
903: x_return_status => x_return_Status,
904: x_msg_count => x_msg_count,
905: x_msg_data => x_msg_data,