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_SPLIT_ASSET_PVT dependencies on OKL_STREAMS

Line 1291: OKL_STREAMS_SEC_PVT.RESET_REPO_STREAMS; -- MGAAP 7263041

1287: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
1288: RAISE Okl_Api.G_EXCEPTION_ERROR;
1289: END IF;
1290:
1291: OKL_STREAMS_SEC_PVT.RESET_REPO_STREAMS; -- MGAAP 7263041
1292: OKL_CONTRACT_REBOOK_PVT.calc_accrual_adjustment(
1293: p_api_version => p_api_version,
1294: p_init_msg_list => p_init_msg_list,
1295: x_return_status => x_return_status,

Line 1332: OKL_STREAMS_SEC_PVT.SET_REPO_STREAMS; -- MGAAP 7263041

1328: END IF;
1329: END IF;
1330:
1331: -- MGAAP start 7263041
1332: OKL_STREAMS_SEC_PVT.SET_REPO_STREAMS; -- MGAAP 7263041
1333: OKL_CONTRACT_REBOOK_PVT.calc_accrual_adjustment(
1334: p_api_version => p_api_version,
1335: p_init_msg_list => p_init_msg_list,
1336: x_return_status => x_return_status,

Line 1348: OKL_STREAMS_SEC_PVT.RESET_REPO_STREAMS; -- MGAAP 7263041

1344: x_stream_tbl => l_stream_tbl,
1345: p_trx_tbl_code => 'TAS',
1346: p_trx_type => 'ALI');
1347:
1348: OKL_STREAMS_SEC_PVT.RESET_REPO_STREAMS; -- MGAAP 7263041
1349: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
1350: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1351: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
1352: RAISE Okl_Api.G_EXCEPTION_ERROR;

Line 1507: OKL_STREAMS_SEC_PVT.SET_REPO_STREAMS;

1503: END IF;
1504:
1505: -- MGAAP start 7263041
1506: IF (l_multi_gaap_yn = 'Y') THEN
1507: OKL_STREAMS_SEC_PVT.SET_REPO_STREAMS;
1508: OKL_CONTRACT_REBOOK_PVT.calc_inv_acc_adjustment(
1509: p_api_version => p_api_version,
1510: p_init_msg_list => p_init_msg_list,
1511: x_return_status => x_return_status,

Line 1523: OKL_STREAMS_SEC_PVT.RESET_REPO_STREAMS;

1519: p_trx_tbl_code => 'TAS',
1520: p_trx_type => 'ALI',
1521: p_product_id => l_reporting_pdt_id); -- MGAAP 7263041
1522:
1523: OKL_STREAMS_SEC_PVT.RESET_REPO_STREAMS;
1524: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
1525: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1526: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
1527: RAISE Okl_Api.G_EXCEPTION_ERROR;

Line 1595: okl_streams_util.update_trx_state(p_chr_id, 'BOTH');

1591: RAISE Okl_Api.G_EXCEPTION_ERROR;
1592: END IF;
1593:
1594: -- racheruv: added update of okl_stream_trx_data.last_trx_state
1595: okl_streams_util.update_trx_state(p_chr_id, 'BOTH');
1596: -- end update of okl_stream_trx_data.last_trx_state
1597:
1598: END IF;
1599:

Line 7799: l_stmv_rec Okl_Streams_pub.stmv_rec_type;

7795: l_api_version CONSTANT NUMBER := 1.0;
7796: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
7797:
7798:
7799: l_stmv_rec Okl_Streams_pub.stmv_rec_type;
7800: l_selv_tbl Okl_Streams_pub.selv_tbl_type;
7801: x_stmv_rec Okl_Streams_pub.stmv_rec_type;
7802: x_selv_tbl Okl_Streams_pub.selv_tbl_type;
7803:

Line 7800: l_selv_tbl Okl_Streams_pub.selv_tbl_type;

7796: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
7797:
7798:
7799: l_stmv_rec Okl_Streams_pub.stmv_rec_type;
7800: l_selv_tbl Okl_Streams_pub.selv_tbl_type;
7801: x_stmv_rec Okl_Streams_pub.stmv_rec_type;
7802: x_selv_tbl Okl_Streams_pub.selv_tbl_type;
7803:
7804: --Cursor to fetch split child records (for split asset as well as split asset into components)

Line 7801: x_stmv_rec Okl_Streams_pub.stmv_rec_type;

7797:
7798:
7799: l_stmv_rec Okl_Streams_pub.stmv_rec_type;
7800: l_selv_tbl Okl_Streams_pub.selv_tbl_type;
7801: x_stmv_rec Okl_Streams_pub.stmv_rec_type;
7802: x_selv_tbl Okl_Streams_pub.selv_tbl_type;
7803:
7804: --Cursor to fetch split child records (for split asset as well as split asset into components)
7805: CURSOR l_split_trx_csr1(p_trxline_id IN NUMBER) IS

Line 7802: x_selv_tbl Okl_Streams_pub.selv_tbl_type;

7798:
7799: l_stmv_rec Okl_Streams_pub.stmv_rec_type;
7800: l_selv_tbl Okl_Streams_pub.selv_tbl_type;
7801: x_stmv_rec Okl_Streams_pub.stmv_rec_type;
7802: x_selv_tbl Okl_Streams_pub.selv_tbl_type;
7803:
7804: --Cursor to fetch split child records (for split asset as well as split asset into components)
7805: CURSOR l_split_trx_csr1(p_trxline_id IN NUMBER) IS
7806: SELECT txd.split_percent,

Line 7947: l_stmv_rec Okl_Streams_pub.stmv_rec_type;

7943: p_txl_id IN NUMBER,
7944: --Bug# 6344223
7945: p_highest_split_comp_amt IN VARCHAR2 DEFAULT 'N') IS
7946:
7947: l_stmv_rec Okl_Streams_pub.stmv_rec_type;
7948: l_selv_tbl Okl_Streams_pub.selv_tbl_type;
7949: l_stmv_rec_hist Okl_Streams_pub.stmv_rec_type;
7950: l_selv_tbl_hist Okl_Streams_pub.selv_tbl_type;
7951: x_stmv_rec Okl_Streams_pub.stmv_rec_type;

Line 7948: l_selv_tbl Okl_Streams_pub.selv_tbl_type;

7944: --Bug# 6344223
7945: p_highest_split_comp_amt IN VARCHAR2 DEFAULT 'N') IS
7946:
7947: l_stmv_rec Okl_Streams_pub.stmv_rec_type;
7948: l_selv_tbl Okl_Streams_pub.selv_tbl_type;
7949: l_stmv_rec_hist Okl_Streams_pub.stmv_rec_type;
7950: l_selv_tbl_hist Okl_Streams_pub.selv_tbl_type;
7951: x_stmv_rec Okl_Streams_pub.stmv_rec_type;
7952: x_selv_tbl Okl_Streams_pub.selv_tbl_type;

Line 7949: l_stmv_rec_hist Okl_Streams_pub.stmv_rec_type;

7945: p_highest_split_comp_amt IN VARCHAR2 DEFAULT 'N') IS
7946:
7947: l_stmv_rec Okl_Streams_pub.stmv_rec_type;
7948: l_selv_tbl Okl_Streams_pub.selv_tbl_type;
7949: l_stmv_rec_hist Okl_Streams_pub.stmv_rec_type;
7950: l_selv_tbl_hist Okl_Streams_pub.selv_tbl_type;
7951: x_stmv_rec Okl_Streams_pub.stmv_rec_type;
7952: x_selv_tbl Okl_Streams_pub.selv_tbl_type;
7953:

Line 7950: l_selv_tbl_hist Okl_Streams_pub.selv_tbl_type;

7946:
7947: l_stmv_rec Okl_Streams_pub.stmv_rec_type;
7948: l_selv_tbl Okl_Streams_pub.selv_tbl_type;
7949: l_stmv_rec_hist Okl_Streams_pub.stmv_rec_type;
7950: l_selv_tbl_hist Okl_Streams_pub.selv_tbl_type;
7951: x_stmv_rec Okl_Streams_pub.stmv_rec_type;
7952: x_selv_tbl Okl_Streams_pub.selv_tbl_type;
7953:
7954:

Line 7951: x_stmv_rec Okl_Streams_pub.stmv_rec_type;

7947: l_stmv_rec Okl_Streams_pub.stmv_rec_type;
7948: l_selv_tbl Okl_Streams_pub.selv_tbl_type;
7949: l_stmv_rec_hist Okl_Streams_pub.stmv_rec_type;
7950: l_selv_tbl_hist Okl_Streams_pub.selv_tbl_type;
7951: x_stmv_rec Okl_Streams_pub.stmv_rec_type;
7952: x_selv_tbl Okl_Streams_pub.selv_tbl_type;
7953:
7954:
7955: CURSOR l_strm_csr ( kleId NUMBER, status VARCHAR2) IS

Line 7952: x_selv_tbl Okl_Streams_pub.selv_tbl_type;

7948: l_selv_tbl Okl_Streams_pub.selv_tbl_type;
7949: l_stmv_rec_hist Okl_Streams_pub.stmv_rec_type;
7950: l_selv_tbl_hist Okl_Streams_pub.selv_tbl_type;
7951: x_stmv_rec Okl_Streams_pub.stmv_rec_type;
7952: x_selv_tbl Okl_Streams_pub.selv_tbl_type;
7953:
7954:
7955: CURSOR l_strm_csr ( kleId NUMBER, status VARCHAR2) IS
7956: SELECT str.Id,

Line 7972: FROM okl_streams str,

7968: -- Bug# 4775555
7969: sty.stream_type_purpose,
7970: --Bug# 6344223
7971: str.link_hist_stream_id
7972: FROM okl_streams str,
7973: okl_strm_type_b sty
7974: WHERE
7975: str.kle_id = kleId
7976: AND str.say_code = status

Line 7993: okl_streams str

7989: str.sgn_code SGN_CODE,
7990: ele.stm_id STM_ID,
7991: ele.se_line_number SE_LINE_NUMBER
7992: FROM okl_strm_elements ele,
7993: okl_streams str
7994: WHERE ele.stm_id = str.id
7995: AND str.id = strId
7996: AND str.kle_id = kleId
7997: AND str.sty_id = styId

Line 8021: l_active_yn OKL_STREAMS.ACTIVE_YN%TYPE;

8017: WHERE id = p_kle_id;
8018:
8019: l_currency_code OKC_K_LINES_B.currency_code%type;
8020:
8021: l_active_yn OKL_STREAMS.ACTIVE_YN%TYPE;
8022:
8023: --Bug# 4775555
8024: l_stmv_rec_temp Okl_Streams_pub.stmv_rec_type;
8025:

Line 8024: l_stmv_rec_temp Okl_Streams_pub.stmv_rec_type;

8020:
8021: l_active_yn OKL_STREAMS.ACTIVE_YN%TYPE;
8022:
8023: --Bug# 4775555
8024: l_stmv_rec_temp Okl_Streams_pub.stmv_rec_type;
8025:
8026: --Bug# 6344223
8027: CURSOR l_txd_csr(p_trxline_id IN NUMBER) IS
8028: SELECT txd.id,

Line 8089: Okl_Streams_Pub.update_streams(

8085: l_stmv_rec_hist.active_yn := 'N';
8086: l_stmv_rec_hist.date_history := SYSDATE;
8087: --Bug# 6344223
8088: l_stmv_rec_hist.link_hist_stream_id := l_strms_rec.link_hist_stream_id;
8089: Okl_Streams_Pub.update_streams(
8090: p_api_version => l_api_version
8091: ,p_init_msg_list => p_init_msg_list
8092: ,x_return_status => x_return_status
8093: ,x_msg_count => x_msg_count

Line 8252: Okl_Streams_Pub.update_streams(

8248: l_stmv_rec_hist.active_yn := 'N';
8249: l_stmv_rec_hist.date_history := SYSDATE;
8250: --Bug# 6344223
8251: l_stmv_rec_hist.link_hist_stream_id := l_strms_rec.link_hist_stream_id;
8252: Okl_Streams_Pub.update_streams(
8253: p_api_version => l_api_version
8254: ,p_init_msg_list => p_init_msg_list
8255: ,x_return_status => x_return_status
8256: ,x_msg_count => x_msg_count

Line 8277: Okl_Streams_Pub.create_streams(

8273: CLOSE l_sifseq_csr;
8274: --Bug# 3502142
8275: l_stmv_rec.date_current := SYSDATE;
8276:
8277: Okl_Streams_Pub.create_streams(
8278: p_api_version => l_api_version
8279: ,p_init_msg_list => p_init_msg_list
8280: ,x_return_status => x_return_status
8281: ,x_msg_count => x_msg_count

Line 8305: Okl_Streams_Pub.create_streams(

8301: CLOSE l_sifseq_csr;
8302: --Bug# 3502142
8303: l_stmv_rec.date_current := SYSDATE;
8304:
8305: Okl_Streams_Pub.create_streams(
8306: p_api_version => l_api_version
8307: ,p_init_msg_list => p_init_msg_list
8308: ,x_return_status => x_return_status
8309: ,x_msg_count => x_msg_count