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 1473: FROM okl_strmtyp_source_v

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

Line 1479: l_name OKL_STRMTYP_SOURCE_V.NAME%TYPE;

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

Line 2076: x_id1 okl_strmtyp_source_v.id1%TYPE;

2072:
2073: l_supp_name OKL_PARTY_ROLES_INTERFACE.SERVICE_VENDOR_NAME%TYPE;
2074: l_supp_id OKL_PARTY_ROLES_INTERFACE.SERVICE_VENDOR_ID%TYPE;
2075:
2076: x_id1 okl_strmtyp_source_v.id1%TYPE;
2077: x_asset_id OKL_LA_RELEASE_ASSETS_UV.ASSET_ID%TYPE;
2078: x_release_asset VARCHAR2(1) := 'N';
2079:
2080: halt_validation EXCEPTION;

Line 2084: l_fee_name OKL_STRMTYP_SOURCE_V.NAME%TYPE;

2080: halt_validation EXCEPTION;
2081: l_return_status VARCHAR2(1);
2082:
2083: l_proc_name VARCHAR2(35) := 'check_line_literal';
2084: l_fee_name OKL_STRMTYP_SOURCE_V.NAME%TYPE;
2085:
2086: l_exists_yn VARCHAR2(1);
2087:
2088: BEGIN

Line 2739: x_id2 okl_strmtyp_source_v.id1%TYPE;

2735: p_stub_amount IN okl_payments_interface.stub_amount%TYPE
2736: ) IS
2737:
2738: x_id1 okx_tuom_v.id1%TYPE;
2739: x_id2 okl_strmtyp_source_v.id1%TYPE;
2740: x_uom_code okx_tuom_v.uom_code%TYPE;
2741: payment_failed EXCEPTION;
2742:
2743: l_return_status VARCHAR2(1);

Line 2745: l_payment_name OKL_STRMTYP_SOURCE_V.NAME%TYPE;

2741: payment_failed EXCEPTION;
2742:
2743: l_return_status VARCHAR2(1);
2744: l_proc_name VARCHAR2(35) := 'check_payment_record';
2745: l_payment_name OKL_STRMTYP_SOURCE_V.NAME%TYPE;
2746:
2747: BEGIN
2748:
2749: debug_message(l_proc_name);

Line 5399: x_stream_id okl_strmtyp_source_v.id1%TYPE;

5395: x_title_issuer_id NUMBER := NULL;
5396: l_rgp_id NUMBER;
5397: x_base_uom_id okx_tuom_v.id1%TYPE;
5398: x_price_list_id okx_list_headers_v.id1%TYPE;
5399: x_stream_id okl_strmtyp_source_v.id1%TYPE;
5400: l_payment_term_id okx_payables_terms_v.id1%TYPE;
5401: l_vendor_paysite_id okx_vendor_sites_v.id1%TYPE;
5402: l_freq_id okl_time_units_v.id1%TYPE;
5403:

Line 5958: x_stream_id okl_strmtyp_source_v.id1%TYPE;

5954: x_usage_item_id okx_system_items_v.id1%TYPE;
5955: x_usage_id2 okx_system_items_v.id2%TYPE;
5956: x_base_uom_id okx_tuom_v.id1%TYPE;
5957: x_price_list_id okx_list_headers_v.id1%TYPE;
5958: x_stream_id okl_strmtyp_source_v.id1%TYPE;
5959: l_payment_term_id okx_payables_terms_v.id1%TYPE;
5960: l_vendor_paysite_id okx_vendor_sites_v.id1%TYPE;
5961: l_freq_id okl_time_units_v.id1%TYPE;
5962:

Line 6012: l_service_name OKL_STRMTYP_SOURCE_V.NAME%TYPE;

6008: WHERE id = p_chr_id);
6009: -- End
6010:
6011: l_present_yn VARCHAR2(1);
6012: l_service_name OKL_STRMTYP_SOURCE_V.NAME%TYPE;
6013:
6014: -- 5179119
6015: CURSOR get_sales_tax_rgp_info(p_chr_id okc_k_headers_b.id%TYPE,
6016: p_cle_id okc_k_lines_v.id%TYPE) IS

Line 8064: l_id1 OKL_STRMTYP_SOURCE_V.id1%TYPE;

8060: l_st_cap_stream_id NUMBER;
8061:
8062: l_st_tax_schedule_applies_flag VARCHAR2(450); -- R12 ebTax change
8063:
8064: l_id1 OKL_STRMTYP_SOURCE_V.id1%TYPE;
8065: l_st_stream_name OKL_STRMTYP_SOURCE_V.name%TYPE;
8066: l_send_bill_sale VARCHAR2(150);
8067: l_manual_quotes_only VARCHAR2(150);
8068: l_first_termination_date VARCHAR2(150);

Line 8065: l_st_stream_name OKL_STRMTYP_SOURCE_V.name%TYPE;

8061:
8062: l_st_tax_schedule_applies_flag VARCHAR2(450); -- R12 ebTax change
8063:
8064: l_id1 OKL_STRMTYP_SOURCE_V.id1%TYPE;
8065: l_st_stream_name OKL_STRMTYP_SOURCE_V.name%TYPE;
8066: l_send_bill_sale VARCHAR2(150);
8067: l_manual_quotes_only VARCHAR2(150);
8068: l_first_termination_date VARCHAR2(150);
8069: l_quote_rcpt_addl_rcpt_role VARCHAR2(30);

Line 8096: l_rvi_stream_type_id okl_strmtyp_source_v.id1%TYPE;

8092: x_fee_types_rec fee_types_rec_type;
8093:
8094: l_contract_number okc_k_headers_b.contract_number%TYPE;
8095: l_contract_start_date okc_k_headers_b.start_date%TYPE;
8096: l_rvi_stream_type_id okl_strmtyp_source_v.id1%TYPE;
8097:
8098: CURSOR contract_csr (p_contract_id NUMBER) is
8099: SELECT contract_number, start_date
8100: FROM okl_k_headers_full_v

Line 8113: l_rvi_stream_name OKL_STRMTYP_SOURCE_V.NAME%TYPE;

8109:
8110: l_yn VARCHAR2(1) := 'N';
8111: l_rvi_stream_code OKL_HEADER_INTERFACE.RVI_STREAM_CODE%TYPE;
8112: l_rvi_stream_purpose_code OKL_HEADER_INTERFACE.RVI_STREAM_PURPOSE_CODE%TYPE;
8113: l_rvi_stream_name OKL_STRMTYP_SOURCE_V.NAME%TYPE;
8114:
8115: -- Bug 4655611
8116:
8117: l_eot_auto_proc_purchase_opt VARCHAR2(1);

Line 22241: x_id1 okl_strmtyp_source_v.id1%TYPE;

22237: x_rgp_id OUT NOCOPY NUMBER,
22238: x_slh_rulv_rec OUT NOCOPY rulv_rec_type
22239: ) IS
22240: l_proc_name VARCHAR2(35) := 'CREATE_PAYMENT_RULE_GROUP';
22241: x_id1 okl_strmtyp_source_v.id1%TYPE;
22242: pay_rule_failed EXCEPTION;
22243:
22244: l_rulv_rec rulv_rec_type;
22245: l_rgpv_rec rgpv_rec_type;

Line 22249: l_payment_stream_name OKL_STRMTYP_SOURCE_V.NAME%TYPE;

22245: l_rgpv_rec rgpv_rec_type;
22246: x_rgpv_rec rgpv_rec_type;
22247:
22248: l_present_yn VARCHAR2(1);
22249: l_payment_stream_name OKL_STRMTYP_SOURCE_V.NAME%TYPE;
22250:
22251: --Bug# 6112766:Start
22252: CURSOR get_rule_group_info(p_chr_id okc_k_headers_b.id%TYPE,
22253: p_cle_id okc_k_lines_v.id%TYPE) IS

Line 23704: l_base_stream_type_id okl_strmtyp_source_v.id1%TYPE;

23700: ) IS
23701:
23702: l_proc_name VARCHAR2(35) := 'CREATE_PARTY_PAYMENT_HDR';
23703: l_return_status VARCHAR2(1);
23704: l_base_stream_type_id okl_strmtyp_source_v.id1%TYPE;
23705: l_evg_stream_type_id okl_strmtyp_source_v.id1%TYPE;
23706: l_yn VARCHAR2(1) := 'N';
23707: l_base_pmnt_hdr pphv_rec_type := NULL;
23708: l_evg_pmnt_hdr pphv_rec_type := NULL;

Line 23705: l_evg_stream_type_id okl_strmtyp_source_v.id1%TYPE;

23701:
23702: l_proc_name VARCHAR2(35) := 'CREATE_PARTY_PAYMENT_HDR';
23703: l_return_status VARCHAR2(1);
23704: l_base_stream_type_id okl_strmtyp_source_v.id1%TYPE;
23705: l_evg_stream_type_id okl_strmtyp_source_v.id1%TYPE;
23706: l_yn VARCHAR2(1) := 'N';
23707: l_base_pmnt_hdr pphv_rec_type := NULL;
23708: l_evg_pmnt_hdr pphv_rec_type := NULL;
23709: l_pmnt_hdr_tbl_in pphv_tbl_type;

Line 23715: l_stream_name OKL_STRMTYP_SOURCE_V.NAME%TYPE;

23711: l_counter NUMBER := 0;
23712: l_contract_number okc_k_headers_b.contract_number%TYPE;
23713: l_contract_start_date okc_k_headers_b.start_date%TYPE;
23714: party_pmnt_header_failed EXCEPTION;
23715: l_stream_name OKL_STRMTYP_SOURCE_V.NAME%TYPE;
23716:
23717: CURSOR contract_csr (p_contract_id NUMBER) is
23718: SELECT contract_number, start_date
23719: FROM okl_k_headers_full_v

Line 24033: l_stream_name OKL_STRMTYP_SOURCE_V.NAME%TYPE;

24029: x_party_pmnt_hdr_tbl_out pphv_tbl_type;
24030: l_counter NUMBER;
24031: -- passthrough
24032:
24033: l_stream_name OKL_STRMTYP_SOURCE_V.NAME%TYPE;
24034:
24035: BEGIN
24036:
24037: x_return_status := OKL_API.G_RET_STS_SUCCESS;