APPS.OKL_SETUP_STREAMTYPES_PVT dependencies on OKL_STRM_TYPE_V

Line 5: -- PROCEDURE get_rec for: OKL_STRM_TYPE_V

1: PACKAGE BODY Okl_Setup_Streamtypes_Pvt AS
2: /* $Header: OKLRSMTB.pls 120.4 2011/01/30 19:04:16 gkadarka ship $ */
3:
4: ---------------------------------------------------------------------------
5: -- PROCEDURE get_rec for: OKL_STRM_TYPE_V
6: ---------------------------------------------------------------------------
7: PROCEDURE get_rec (
8: p_styv_rec IN styv_rec_type,
9: x_return_status OUT NOCOPY VARCHAR2,

Line 57: FROM OKL_STRM_TYPE_V

53: STREAM_TYPE_PURPOSE,
54: CONTINGENCY,
55: SHORT_DESCRIPTION
56: -- Added by RGOOTY for ER 3935682: End
57: FROM OKL_STRM_TYPE_V
58: WHERE OKL_STRM_TYPE_V.id = p_id;
59:
60: l_okl_styv_pk okl_styv_pk_csr%ROWTYPE;
61: l_styv_rec styv_rec_type;

Line 58: WHERE OKL_STRM_TYPE_V.id = p_id;

54: CONTINGENCY,
55: SHORT_DESCRIPTION
56: -- Added by RGOOTY for ER 3935682: End
57: FROM OKL_STRM_TYPE_V
58: WHERE OKL_STRM_TYPE_V.id = p_id;
59:
60: l_okl_styv_pk okl_styv_pk_csr%ROWTYPE;
61: l_styv_rec styv_rec_type;
62: BEGIN

Line 465: -- PROCEDURE determine_action for: OKL_STRM_TYPE_V

461:
462: END get_changes_only;
463:
464: ---------------------------------------------------------------------------
465: -- PROCEDURE determine_action for: OKL_STRM_TYPE_V
466: -- This function helps in determining the various checks to be performed
467: -- for the new/updated record and also helps in determining whether a new
468: -- version is required or not
469: ---------------------------------------------------------------------------

Line 599: p_view => 'Okl_Strm_Type_V',

595: p_start_date_attribute_name => 'START_DATE',
596: p_start_date => l_styv_rec.start_date,
597: p_end_date_attribute_name => 'END_DATE',
598: p_end_date => l_styv_rec.end_date,
599: p_view => 'Okl_Strm_Type_V',
600: x_return_status => l_return_status,
601: x_valid => l_valid);
602:
603: IF (l_return_status = G_RET_STS_UNEXP_ERROR) THEN

Line 662: -- PROCEDURE create_stream_type for: OKL_STRM_TYPE_V

658:
659: END check_updates;
660:
661: ---------------------------------------------------------------------------
662: -- PROCEDURE create_stream_type for: OKL_STRM_TYPE_V
663: ---------------------------------------------------------------------------
664: PROCEDURE create_stream_type( p_api_version IN NUMBER,
665: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
666: x_return_status OUT NOCOPY VARCHAR2,

Line 742: -- PROCEDURE update_stream_type for: OKL_STRM_TYPE_V

738: x_return_status := G_RET_STS_UNEXP_ERROR;
739: END create_stream_type;
740:
741: ---------------------------------------------------------------------------
742: -- PROCEDURE update_stream_type for: OKL_STRM_TYPE_V
743: ---------------------------------------------------------------------------
744: PROCEDURE update_stream_type(p_api_version IN NUMBER,
745: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
746: x_return_status OUT NOCOPY VARCHAR2,

Line 1077: p_view => 'OKL_STRM_TYPE_V',

1073: okl_accounting_util.get_version(p_attrib_tbl => l_attrib_tbl,
1074: p_cur_version => l_styv_rec.version,
1075: p_end_date_attribute_name => 'END_DATE',
1076: p_end_date => l_styv_rec.end_date,
1077: p_view => 'OKL_STRM_TYPE_V',
1078: x_return_status => l_return_status,
1079: x_new_version => l_new_version);
1080: IF (l_return_status = G_RET_STS_UNEXP_ERROR) THEN
1081: RAISE G_EXCEPTION_UNEXPECTED_ERROR;