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 480: FROM okl_streams_v stm

476: -- cursor for AR invoices
477: CURSOR l_AR_stream_csr(cp_khr_id IN NUMBER
478: ,cp_sty_id IN NUMBER) IS
479: SELECT stm.id
480: FROM okl_streams_v stm
481: WHERE stm.khr_id = cp_khr_id
482: AND stm.sty_id = cp_sty_id
483: AND stm.say_code = 'CURR'
484: AND stm.active_yn = 'Y';

Line 491: FROM okl_streams_v stm

487: CURSOR l_cons_stream_csr(cp_khr_id IN NUMBER
488: ,cp_kle_id IN NUMBER
489: ,cp_sty_id IN NUMBER) IS
490: SELECT stm.id
491: FROM okl_streams_v stm
492: WHERE stm.khr_id = cp_khr_id
493: AND nvl(stm.kle_id, -99) = nvl(cp_kle_id, -99)
494: AND stm.sty_id = cp_sty_id
495: AND stm.say_code = 'CURR'

Line 501: FROM okl_streams_v stm

497: -- second cursor for consolidated invoices
498: CURSOR l_stream_csr(cp_khr_id IN NUMBER
499: ,cp_sty_id IN NUMBER) IS
500: SELECT stm.id
501: FROM okl_streams_v stm
502: WHERE stm.khr_id = cp_khr_id
503: AND stm.sty_id = cp_sty_id
504: AND stm.say_code = 'CURR'
505: AND stm.active_yn = 'Y';

Line 802: Okl_Streams_Util.get_primary_stream_type(

798:
799: --get stream type id
800: l_sty_id := null;
801:
802: Okl_Streams_Util.get_primary_stream_type(
803: p_khr_id => l_khr_id,
804: p_primary_sty_purpose => cns_late_fee,
805: x_return_status => l_return_status,
806: x_primary_sty_id => l_sty_id );

Line 850: Okl_Streams_Pub.create_streams(

846: l_stmv_rec.comments := 'LATE FEE BILLING';
847:
848: FND_FILE.PUT_LINE (FND_FILE.LOG, ' -- Creating LATE FEE Stream');
849:
850: Okl_Streams_Pub.create_streams(
851: p_api_version => p_api_version,
852: p_init_msg_list => p_init_msg_list,
853: x_return_status => x_return_status,
854: x_msg_count => x_msg_count,

Line 957: Okl_Streams_Util.get_primary_stream_type(

953: LOOP
954: --get stream type id
955: l_sty_id := null;
956:
957: Okl_Streams_Util.get_primary_stream_type(
958: p_khr_id => cur_sec_strm.khr_id,
959: p_primary_sty_purpose => cns_late_charge_payable,
960: x_return_status => l_return_status,
961: x_primary_sty_id => l_sty_id );

Line 1004: Okl_Streams_Pub.create_streams(

1000: END IF;
1001:
1002: FND_FILE.PUT_LINE (FND_FILE.LOG, ' -- Creating INVESTOR LATE FEE PAYABLE Stream');
1003:
1004: Okl_Streams_Pub.create_streams(
1005: p_api_version => p_api_version,
1006: p_init_msg_list => p_init_msg_list,
1007: x_return_status => x_return_status,
1008: x_msg_count => x_msg_count,

Line 1078: Update okl_streams

1074: END IF;
1075: ELSE
1076: --fix for bug 4439728
1077: --deactivate late charge stream as payable stream creation was unsuccessful
1078: Update okl_streams
1079: set say_code = 'HIST'
1080: ,active_yn = 'N'
1081: ,last_updated_by = l_last_updated_by
1082: ,last_update_date = sysdate

Line 1103: Okl_Streams_Util.get_primary_stream_type(

1099: LOOP
1100: --get stream type id
1101: l_sty_id := null;
1102:
1103: Okl_Streams_Util.get_primary_stream_type(
1104: p_khr_id => cur_sec_strm.khr_id,
1105: p_primary_sty_purpose => cns_late_charge_payable,
1106: x_return_status => l_return_status,
1107: x_primary_sty_id => l_sty_id );

Line 1154: Okl_Streams_Pub.create_streams(

1150: END IF;
1151:
1152: FND_FILE.PUT_LINE (FND_FILE.LOG, ' -- Creating INVESTOR LATE FEE PAYABLE Stream');
1153:
1154: Okl_Streams_Pub.create_streams(
1155: p_api_version => p_api_version,
1156: p_init_msg_list => p_init_msg_list,
1157: x_return_status => x_return_status,
1158: x_msg_count => x_msg_count,

Line 1229: Update okl_streams

1225: END IF;
1226: ELSE
1227: --fix for bug 4439728
1228: --deactivate late charge stream as payable stream creation was unsuccessful
1229: Update okl_streams
1230: set say_code = 'HIST'
1231: ,active_yn = 'N'
1232: ,last_updated_by = l_last_updated_by
1233: ,last_update_date = sysdate

Line 1503: Okl_Streams_Util.get_primary_stream_type(

1499:
1500: --get stream type id
1501: l_sty_id := null;
1502:
1503: Okl_Streams_Util.get_primary_stream_type(
1504: p_khr_id => l_khr_id,
1505: p_primary_sty_purpose => cns_late_fee,
1506: x_return_status => l_return_status,
1507: x_primary_sty_id => l_sty_id );

Line 1551: Okl_Streams_Pub.create_streams(

1547: l_stmv_rec.comments := 'LATE FEE BILLING';
1548:
1549: FND_FILE.PUT_LINE (FND_FILE.LOG, ' -- Creating LATE FEE Streams');
1550:
1551: Okl_Streams_Pub.create_streams(
1552: p_api_version => p_api_version,
1553: p_init_msg_list => p_init_msg_list,
1554: x_return_status => x_return_status,
1555: x_msg_count => x_msg_count,

Line 1652: Okl_Streams_Util.get_primary_stream_type(

1648: FOR cur_sec_strm IN c_sec_strm_AR_csr(l_inv_cur.contract_id, l_inv_cur.consolidated_invoice_number) LOOP
1649: --get stream type id
1650: l_sty_id := null;
1651:
1652: Okl_Streams_Util.get_primary_stream_type(
1653: p_khr_id => cur_sec_strm.khr_id,
1654: p_primary_sty_purpose => cns_late_charge_payable,
1655: x_return_status => l_return_status,
1656: x_primary_sty_id => l_sty_id );

Line 1705: Okl_Streams_Pub.create_streams(

1701: END IF;
1702: -- gboomina Bug 6797000 - End
1703: FND_FILE.PUT_LINE (FND_FILE.LOG, ' -- Creating INVESTOR LATE FEE PAYABLE Streams');
1704:
1705: Okl_Streams_Pub.create_streams(
1706: p_api_version => p_api_version,
1707: p_init_msg_list => p_init_msg_list,
1708: x_return_status => x_return_status,
1709: x_msg_count => x_msg_count,

Line 1786: Update okl_streams

1782: END IF;
1783: ELSE
1784: --fix for bug 4439728
1785: --deactivate late charge stream as payable stream creation was unsuccessful
1786: Update okl_streams
1787: set say_code = 'HIST'
1788: ,active_yn = 'N'
1789: ,last_updated_by = l_last_updated_by
1790: ,last_update_date = sysdate

Line 1813: Okl_Streams_Util.get_primary_stream_type(

1809: l_inv_cur.contract_id) LOOP
1810: --get stream type id
1811: l_sty_id := null;
1812:
1813: Okl_Streams_Util.get_primary_stream_type(
1814: p_khr_id => cur_sec_strm.khr_id,
1815: p_primary_sty_purpose => cns_late_charge_payable,
1816: x_return_status => l_return_status,
1817: x_primary_sty_id => l_sty_id );

Line 1864: Okl_Streams_Pub.create_streams(

1860: END IF;
1861:
1862: FND_FILE.PUT_LINE (FND_FILE.LOG, ' -- Creating INVESTOR LATE FEE PAYABLE Stream');
1863:
1864: Okl_Streams_Pub.create_streams(
1865: p_api_version => p_api_version,
1866: p_init_msg_list => p_init_msg_list,
1867: x_return_status => x_return_status,
1868: x_msg_count => x_msg_count,

Line 1940: Update okl_streams

1936: END IF;
1937: ELSE
1938: --fix for bug 4439728
1939: --deactivate late charge stream as payable stream creation was unsuccessful
1940: Update okl_streams
1941: set say_code = 'HIST'
1942: ,active_yn = 'N'
1943: ,last_updated_by = l_last_updated_by
1944: ,last_update_date = sysdate