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

Line 41: l_stm_id OKL_STREAMS_V.ID%TYPE;

37: l_amt_due_remaining AR_PAYMENT_SCHEDULES_ALL.AMOUNT_DUE_REMAINING%type;
38: l_due_date AR_PAYMENT_SCHEDULES_ALL.DUE_DATE%type;
39: l_khr_id OKL_CNSLD_AR_STRMS_B.KHR_ID%type;
40: l_sty_id OKL_STRM_TYPE_V.ID%TYPE;
41: l_stm_id OKL_STREAMS_V.ID%TYPE;
42: l_late_stm_id OKL_STREAMS_V.ID%TYPE;
43: l_se_line_number OKL_STRM_ELEMENTS_V.SE_LINE_NUMBER%TYPE;
44: l_amount NUMBER;
45: l_stream_purpose OKL_STRM_TYPE_V.stream_type_purpose%TYPE;

Line 42: l_late_stm_id OKL_STREAMS_V.ID%TYPE;

38: l_due_date AR_PAYMENT_SCHEDULES_ALL.DUE_DATE%type;
39: l_khr_id OKL_CNSLD_AR_STRMS_B.KHR_ID%type;
40: l_sty_id OKL_STRM_TYPE_V.ID%TYPE;
41: l_stm_id OKL_STREAMS_V.ID%TYPE;
42: l_late_stm_id OKL_STREAMS_V.ID%TYPE;
43: l_se_line_number OKL_STRM_ELEMENTS_V.SE_LINE_NUMBER%TYPE;
44: l_amount NUMBER;
45: l_stream_purpose OKL_STRM_TYPE_V.stream_type_purpose%TYPE;
46: l_sec_rec_inv_id OKL_CNSLD_AR_STRMS_V.ID%TYPE;

Line 80: l_stmv_rec Okl_Streams_Pub.stmv_rec_type;

76: l_lsmv_rec lsmv_rec_type;
77: lx_lsmv_rec lsmv_rec_type;
78:
79:
80: l_stmv_rec Okl_Streams_Pub.stmv_rec_type;
81: lx_stmv_rec Okl_Streams_Pub.stmv_rec_type;
82: l_init_stmv_rec Okl_Streams_Pub.stmv_rec_type;
83:
84: l_selv_rec Okl_Sel_Pvt.selv_rec_type;

Line 81: lx_stmv_rec Okl_Streams_Pub.stmv_rec_type;

77: lx_lsmv_rec lsmv_rec_type;
78:
79:
80: l_stmv_rec Okl_Streams_Pub.stmv_rec_type;
81: lx_stmv_rec Okl_Streams_Pub.stmv_rec_type;
82: l_init_stmv_rec Okl_Streams_Pub.stmv_rec_type;
83:
84: l_selv_rec Okl_Sel_Pvt.selv_rec_type;
85: lx_selv_rec Okl_Sel_Pvt.selv_rec_type;

Line 82: l_init_stmv_rec Okl_Streams_Pub.stmv_rec_type;

78:
79:
80: l_stmv_rec Okl_Streams_Pub.stmv_rec_type;
81: lx_stmv_rec Okl_Streams_Pub.stmv_rec_type;
82: l_init_stmv_rec Okl_Streams_Pub.stmv_rec_type;
83:
84: l_selv_rec Okl_Sel_Pvt.selv_rec_type;
85: lx_selv_rec Okl_Sel_Pvt.selv_rec_type;
86: l_init_selv_rec Okl_Sel_Pvt.selv_rec_type;

Line 485: FROM okl_streams_v stm

481: -- cursor for AR invoices
482: CURSOR l_AR_stream_csr(cp_khr_id IN NUMBER
483: ,cp_sty_id IN NUMBER) IS
484: SELECT stm.id
485: FROM okl_streams_v stm
486: WHERE stm.khr_id = cp_khr_id
487: AND stm.sty_id = cp_sty_id
488: AND stm.say_code = 'CURR'
489: AND stm.active_yn = 'Y';

Line 496: FROM okl_streams_v stm

492: CURSOR l_cons_stream_csr(cp_khr_id IN NUMBER
493: ,cp_kle_id IN NUMBER
494: ,cp_sty_id IN NUMBER) IS
495: SELECT stm.id
496: FROM okl_streams_v stm
497: WHERE stm.khr_id = cp_khr_id
498: AND nvl(stm.kle_id, -99) = nvl(cp_kle_id, -99)
499: AND stm.sty_id = cp_sty_id
500: AND stm.say_code = 'CURR'

Line 506: FROM okl_streams_v stm

502: -- second cursor for consolidated invoices
503: CURSOR l_stream_csr(cp_khr_id IN NUMBER
504: ,cp_sty_id IN NUMBER) IS
505: SELECT stm.id
506: FROM okl_streams_v stm
507: WHERE stm.khr_id = cp_khr_id
508: AND stm.sty_id = cp_sty_id
509: AND stm.say_code = 'CURR'
510: AND stm.active_yn = 'Y';

Line 809: Okl_Streams_Util.get_primary_stream_type(

805:
806: --get stream type id
807: l_sty_id := null;
808:
809: Okl_Streams_Util.get_primary_stream_type(
810: p_khr_id => l_khr_id,
811: p_primary_sty_purpose => cns_late_fee,
812: x_return_status => l_return_status,
813: x_primary_sty_id => l_sty_id );

Line 857: Okl_Streams_Pub.create_streams(

853: l_stmv_rec.comments := 'LATE FEE BILLING';
854:
855: FND_FILE.PUT_LINE (FND_FILE.LOG, ' -- Creating LATE FEE Stream');
856:
857: Okl_Streams_Pub.create_streams(
858: p_api_version => p_api_version,
859: p_init_msg_list => p_init_msg_list,
860: x_return_status => x_return_status,
861: x_msg_count => x_msg_count,

Line 964: Okl_Streams_Util.get_primary_stream_type(

960: LOOP
961: --get stream type id
962: l_sty_id := null;
963:
964: Okl_Streams_Util.get_primary_stream_type(
965: p_khr_id => cur_sec_strm.khr_id,
966: p_primary_sty_purpose => cns_late_charge_payable,
967: x_return_status => l_return_status,
968: x_primary_sty_id => l_sty_id );

Line 1011: Okl_Streams_Pub.create_streams(

1007: END IF;
1008:
1009: FND_FILE.PUT_LINE (FND_FILE.LOG, ' -- Creating INVESTOR LATE FEE PAYABLE Stream');
1010:
1011: Okl_Streams_Pub.create_streams(
1012: p_api_version => p_api_version,
1013: p_init_msg_list => p_init_msg_list,
1014: x_return_status => x_return_status,
1015: x_msg_count => x_msg_count,

Line 1085: Update okl_streams

1081: END IF;
1082: ELSE
1083: --fix for bug 4439728
1084: --deactivate late charge stream as payable stream creation was unsuccessful
1085: Update okl_streams
1086: set say_code = 'HIST'
1087: ,active_yn = 'N'
1088: ,last_updated_by = l_last_updated_by
1089: ,last_update_date = sysdate

Line 1110: Okl_Streams_Util.get_primary_stream_type(

1106: LOOP
1107: --get stream type id
1108: l_sty_id := null;
1109:
1110: Okl_Streams_Util.get_primary_stream_type(
1111: p_khr_id => cur_sec_strm.khr_id,
1112: p_primary_sty_purpose => cns_late_charge_payable,
1113: x_return_status => l_return_status,
1114: x_primary_sty_id => l_sty_id );

Line 1161: Okl_Streams_Pub.create_streams(

1157: END IF;
1158:
1159: FND_FILE.PUT_LINE (FND_FILE.LOG, ' -- Creating INVESTOR LATE FEE PAYABLE Stream');
1160:
1161: Okl_Streams_Pub.create_streams(
1162: p_api_version => p_api_version,
1163: p_init_msg_list => p_init_msg_list,
1164: x_return_status => x_return_status,
1165: x_msg_count => x_msg_count,

Line 1236: Update okl_streams

1232: END IF;
1233: ELSE
1234: --fix for bug 4439728
1235: --deactivate late charge stream as payable stream creation was unsuccessful
1236: Update okl_streams
1237: set say_code = 'HIST'
1238: ,active_yn = 'N'
1239: ,last_updated_by = l_last_updated_by
1240: ,last_update_date = sysdate

Line 1511: Okl_Streams_Util.get_primary_stream_type(

1507:
1508: --get stream type id
1509: l_sty_id := null;
1510:
1511: Okl_Streams_Util.get_primary_stream_type(
1512: p_khr_id => l_khr_id,
1513: p_primary_sty_purpose => cns_late_fee,
1514: x_return_status => l_return_status,
1515: x_primary_sty_id => l_sty_id );

Line 1559: Okl_Streams_Pub.create_streams(

1555: l_stmv_rec.comments := 'LATE FEE BILLING';
1556:
1557: FND_FILE.PUT_LINE (FND_FILE.LOG, ' -- Creating LATE FEE Streams');
1558:
1559: Okl_Streams_Pub.create_streams(
1560: p_api_version => p_api_version,
1561: p_init_msg_list => p_init_msg_list,
1562: x_return_status => x_return_status,
1563: x_msg_count => x_msg_count,

Line 1660: Okl_Streams_Util.get_primary_stream_type(

1656: FOR cur_sec_strm IN c_sec_strm_AR_csr(l_inv_cur.contract_id, l_inv_cur.consolidated_invoice_number) LOOP
1657: --get stream type id
1658: l_sty_id := null;
1659:
1660: Okl_Streams_Util.get_primary_stream_type(
1661: p_khr_id => cur_sec_strm.khr_id,
1662: p_primary_sty_purpose => cns_late_charge_payable,
1663: x_return_status => l_return_status,
1664: x_primary_sty_id => l_sty_id );

Line 1713: Okl_Streams_Pub.create_streams(

1709: END IF;
1710: -- gboomina Bug 6797000 - End
1711: FND_FILE.PUT_LINE (FND_FILE.LOG, ' -- Creating INVESTOR LATE FEE PAYABLE Streams');
1712:
1713: Okl_Streams_Pub.create_streams(
1714: p_api_version => p_api_version,
1715: p_init_msg_list => p_init_msg_list,
1716: x_return_status => x_return_status,
1717: x_msg_count => x_msg_count,

Line 1794: Update okl_streams

1790: END IF;
1791: ELSE
1792: --fix for bug 4439728
1793: --deactivate late charge stream as payable stream creation was unsuccessful
1794: Update okl_streams
1795: set say_code = 'HIST'
1796: ,active_yn = 'N'
1797: ,last_updated_by = l_last_updated_by
1798: ,last_update_date = sysdate

Line 1821: Okl_Streams_Util.get_primary_stream_type(

1817: l_inv_cur.contract_id) LOOP
1818: --get stream type id
1819: l_sty_id := null;
1820:
1821: Okl_Streams_Util.get_primary_stream_type(
1822: p_khr_id => cur_sec_strm.khr_id,
1823: p_primary_sty_purpose => cns_late_charge_payable,
1824: x_return_status => l_return_status,
1825: x_primary_sty_id => l_sty_id );

Line 1872: Okl_Streams_Pub.create_streams(

1868: END IF;
1869:
1870: FND_FILE.PUT_LINE (FND_FILE.LOG, ' -- Creating INVESTOR LATE FEE PAYABLE Stream');
1871:
1872: Okl_Streams_Pub.create_streams(
1873: p_api_version => p_api_version,
1874: p_init_msg_list => p_init_msg_list,
1875: x_return_status => x_return_status,
1876: x_msg_count => x_msg_count,

Line 1948: Update okl_streams

1944: END IF;
1945: ELSE
1946: --fix for bug 4439728
1947: --deactivate late charge stream as payable stream creation was unsuccessful
1948: Update okl_streams
1949: set say_code = 'HIST'
1950: ,active_yn = 'N'
1951: ,last_updated_by = l_last_updated_by
1952: ,last_update_date = sysdate