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_OPEN_INTERFACE_PVT dependencies on OKL_STRMTYP_SOURCE_V

Line 1476: FROM okl_strmtyp_source_v

1472:
1473: CURSOR strm_csr (p_strm_code VARCHAR2,
1474: p_strm_purpose VARCHAR2) IS
1475: SELECT ID1, NAME
1476: FROM okl_strmtyp_source_v
1477: WHERE status = 'A'
1478: AND name = p_strm_code
1479: AND stream_type_purpose = p_strm_purpose;
1480:

Line 1482: l_name OKL_STRMTYP_SOURCE_V.NAME%TYPE;

1478: AND name = p_strm_code
1479: AND stream_type_purpose = p_strm_purpose;
1480:
1481: l_id1 NUMBER;
1482: l_name OKL_STRMTYP_SOURCE_V.NAME%TYPE;
1483: strm_failed EXCEPTION;
1484:
1485: BEGIN
1486: x_return_status := OKL_API.G_RET_STS_SUCCESS;

Line 2170: x_id1 okl_strmtyp_source_v.id1%TYPE;

2166:
2167: l_supp_name OKL_PARTY_ROLES_INTERFACE.SERVICE_VENDOR_NAME%TYPE;
2168: l_supp_id OKL_PARTY_ROLES_INTERFACE.SERVICE_VENDOR_ID%TYPE;
2169:
2170: x_id1 okl_strmtyp_source_v.id1%TYPE;
2171: x_asset_id OKL_LA_RELEASE_ASSETS_UV.ASSET_ID%TYPE;
2172: x_release_asset VARCHAR2(1) := 'N';
2173:
2174: halt_validation EXCEPTION;

Line 2178: l_fee_name OKL_STRMTYP_SOURCE_V.NAME%TYPE;

2174: halt_validation EXCEPTION;
2175: l_return_status VARCHAR2(1);
2176:
2177: l_proc_name VARCHAR2(35) := 'check_line_literal';
2178: l_fee_name OKL_STRMTYP_SOURCE_V.NAME%TYPE;
2179:
2180: l_exists_yn VARCHAR2(1);
2181:
2182: BEGIN

Line 2904: x_id2 okl_strmtyp_source_v.id1%TYPE;

2900: p_stub_amount IN okl_payments_interface.stub_amount%TYPE
2901: ) IS
2902:
2903: x_id1 okx_tuom_v.id1%TYPE;
2904: x_id2 okl_strmtyp_source_v.id1%TYPE;
2905: x_uom_code okx_tuom_v.uom_code%TYPE;
2906: payment_failed EXCEPTION;
2907:
2908: l_return_status VARCHAR2(1);

Line 2910: l_payment_name OKL_STRMTYP_SOURCE_V.NAME%TYPE;

2906: payment_failed EXCEPTION;
2907:
2908: l_return_status VARCHAR2(1);
2909: l_proc_name VARCHAR2(35) := 'check_payment_record';
2910: l_payment_name OKL_STRMTYP_SOURCE_V.NAME%TYPE;
2911:
2912: BEGIN
2913:
2914: debug_message(l_proc_name);

Line 5567: x_stream_id okl_strmtyp_source_v.id1%TYPE;

5563: x_title_issuer_id NUMBER := NULL;
5564: l_rgp_id NUMBER;
5565: x_base_uom_id okx_tuom_v.id1%TYPE;
5566: x_price_list_id okx_list_headers_v.id1%TYPE;
5567: x_stream_id okl_strmtyp_source_v.id1%TYPE;
5568: l_payment_term_id okx_payables_terms_v.id1%TYPE;
5569: l_vendor_paysite_id okx_vendor_sites_v.id1%TYPE;
5570: l_freq_id okl_time_units_v.id1%TYPE;
5571:

Line 6126: x_stream_id okl_strmtyp_source_v.id1%TYPE;

6122: x_usage_item_id okx_system_items_v.id1%TYPE;
6123: x_usage_id2 okx_system_items_v.id2%TYPE;
6124: x_base_uom_id okx_tuom_v.id1%TYPE;
6125: x_price_list_id okx_list_headers_v.id1%TYPE;
6126: x_stream_id okl_strmtyp_source_v.id1%TYPE;
6127: l_payment_term_id okx_payables_terms_v.id1%TYPE;
6128: l_vendor_paysite_id okx_vendor_sites_v.id1%TYPE;
6129: l_freq_id okl_time_units_v.id1%TYPE;
6130:

Line 6180: l_service_name OKL_STRMTYP_SOURCE_V.NAME%TYPE;

6176: WHERE id = p_chr_id);
6177: -- End
6178:
6179: l_present_yn VARCHAR2(1);
6180: l_service_name OKL_STRMTYP_SOURCE_V.NAME%TYPE;
6181:
6182: -- 5179119
6183: CURSOR get_sales_tax_rgp_info(p_chr_id okc_k_headers_b.id%TYPE,
6184: p_cle_id okc_k_lines_v.id%TYPE) IS

Line 8232: l_id1 OKL_STRMTYP_SOURCE_V.id1%TYPE;

8228: l_st_cap_stream_id NUMBER;
8229:
8230: l_st_tax_schedule_applies_flag VARCHAR2(450); -- R12 ebTax change
8231:
8232: l_id1 OKL_STRMTYP_SOURCE_V.id1%TYPE;
8233: l_st_stream_name OKL_STRMTYP_SOURCE_V.name%TYPE;
8234: l_send_bill_sale VARCHAR2(150);
8235: l_manual_quotes_only VARCHAR2(150);
8236: l_first_termination_date VARCHAR2(150);

Line 8233: l_st_stream_name OKL_STRMTYP_SOURCE_V.name%TYPE;

8229:
8230: l_st_tax_schedule_applies_flag VARCHAR2(450); -- R12 ebTax change
8231:
8232: l_id1 OKL_STRMTYP_SOURCE_V.id1%TYPE;
8233: l_st_stream_name OKL_STRMTYP_SOURCE_V.name%TYPE;
8234: l_send_bill_sale VARCHAR2(150);
8235: l_manual_quotes_only VARCHAR2(150);
8236: l_first_termination_date VARCHAR2(150);
8237: l_quote_rcpt_addl_rcpt_role VARCHAR2(30);

Line 8264: l_rvi_stream_type_id okl_strmtyp_source_v.id1%TYPE;

8260: x_fee_types_rec fee_types_rec_type;
8261:
8262: l_contract_number okc_k_headers_b.contract_number%TYPE;
8263: l_contract_start_date okc_k_headers_b.start_date%TYPE;
8264: l_rvi_stream_type_id okl_strmtyp_source_v.id1%TYPE;
8265:
8266: CURSOR contract_csr (p_contract_id NUMBER) is
8267: SELECT contract_number, start_date
8268: FROM okl_k_headers_full_v

Line 8281: l_rvi_stream_name OKL_STRMTYP_SOURCE_V.NAME%TYPE;

8277:
8278: l_yn VARCHAR2(1) := 'N';
8279: l_rvi_stream_code OKL_HEADER_INTERFACE.RVI_STREAM_CODE%TYPE;
8280: l_rvi_stream_purpose_code OKL_HEADER_INTERFACE.RVI_STREAM_PURPOSE_CODE%TYPE;
8281: l_rvi_stream_name OKL_STRMTYP_SOURCE_V.NAME%TYPE;
8282:
8283: -- Bug 4655611
8284:
8285: l_eot_auto_proc_purchase_opt VARCHAR2(1);

Line 22428: x_id1 okl_strmtyp_source_v.id1%TYPE;

22424: x_rgp_id OUT NOCOPY NUMBER,
22425: x_slh_rulv_rec OUT NOCOPY rulv_rec_type
22426: ) IS
22427: l_proc_name VARCHAR2(35) := 'CREATE_PAYMENT_RULE_GROUP';
22428: x_id1 okl_strmtyp_source_v.id1%TYPE;
22429: pay_rule_failed EXCEPTION;
22430:
22431: l_rulv_rec rulv_rec_type;
22432: l_rgpv_rec rgpv_rec_type;

Line 22436: l_payment_stream_name OKL_STRMTYP_SOURCE_V.NAME%TYPE;

22432: l_rgpv_rec rgpv_rec_type;
22433: x_rgpv_rec rgpv_rec_type;
22434:
22435: l_present_yn VARCHAR2(1);
22436: l_payment_stream_name OKL_STRMTYP_SOURCE_V.NAME%TYPE;
22437:
22438: --Bug# 6112766:Start
22439: CURSOR get_rule_group_info(p_chr_id okc_k_headers_b.id%TYPE,
22440: p_cle_id okc_k_lines_v.id%TYPE) IS

Line 23893: l_base_stream_type_id okl_strmtyp_source_v.id1%TYPE;

23889: ) IS
23890:
23891: l_proc_name VARCHAR2(35) := 'CREATE_PARTY_PAYMENT_HDR';
23892: l_return_status VARCHAR2(1);
23893: l_base_stream_type_id okl_strmtyp_source_v.id1%TYPE;
23894: l_evg_stream_type_id okl_strmtyp_source_v.id1%TYPE;
23895: l_yn VARCHAR2(1) := 'N';
23896: l_base_pmnt_hdr pphv_rec_type := NULL;
23897: l_evg_pmnt_hdr pphv_rec_type := NULL;

Line 23894: l_evg_stream_type_id okl_strmtyp_source_v.id1%TYPE;

23890:
23891: l_proc_name VARCHAR2(35) := 'CREATE_PARTY_PAYMENT_HDR';
23892: l_return_status VARCHAR2(1);
23893: l_base_stream_type_id okl_strmtyp_source_v.id1%TYPE;
23894: l_evg_stream_type_id okl_strmtyp_source_v.id1%TYPE;
23895: l_yn VARCHAR2(1) := 'N';
23896: l_base_pmnt_hdr pphv_rec_type := NULL;
23897: l_evg_pmnt_hdr pphv_rec_type := NULL;
23898: l_pmnt_hdr_tbl_in pphv_tbl_type;

Line 23904: l_stream_name OKL_STRMTYP_SOURCE_V.NAME%TYPE;

23900: l_counter NUMBER := 0;
23901: l_contract_number okc_k_headers_b.contract_number%TYPE;
23902: l_contract_start_date okc_k_headers_b.start_date%TYPE;
23903: party_pmnt_header_failed EXCEPTION;
23904: l_stream_name OKL_STRMTYP_SOURCE_V.NAME%TYPE;
23905:
23906: CURSOR contract_csr (p_contract_id NUMBER) is
23907: SELECT contract_number, start_date
23908: FROM okl_k_headers_full_v

Line 24240: l_stream_name OKL_STRMTYP_SOURCE_V.NAME%TYPE;

24236: x_party_pmnt_hdr_tbl_out pphv_tbl_type;
24237: l_counter NUMBER;
24238: -- passthrough
24239:
24240: l_stream_name OKL_STRMTYP_SOURCE_V.NAME%TYPE;
24241:
24242: BEGIN
24243:
24244: x_return_status := OKL_API.G_RET_STS_SUCCESS;