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 OKC_K_HEADERS_B

Line 818: p_chr_id IN OKC_K_HEADERS_B.ID%TYPE,

814: ------------------------------------------------------------------------------
815:
816: PROCEDURE get_can_bto(
817: x_return_status OUT NOCOPY VARCHAR2,
818: p_chr_id IN OKC_K_HEADERS_B.ID%TYPE,
819: x_bto_id OUT NOCOPY OKC_K_HEADERS_B.BILL_TO_SITE_USE_ID%TYPE,
820: x_can_id OUT NOCOPY OKC_K_HEADERS_B.CUST_ACCT_ID%TYPE
821: ) IS
822:

Line 819: x_bto_id OUT NOCOPY OKC_K_HEADERS_B.BILL_TO_SITE_USE_ID%TYPE,

815:
816: PROCEDURE get_can_bto(
817: x_return_status OUT NOCOPY VARCHAR2,
818: p_chr_id IN OKC_K_HEADERS_B.ID%TYPE,
819: x_bto_id OUT NOCOPY OKC_K_HEADERS_B.BILL_TO_SITE_USE_ID%TYPE,
820: x_can_id OUT NOCOPY OKC_K_HEADERS_B.CUST_ACCT_ID%TYPE
821: ) IS
822:
823: l_proc_name VARCHAR2(35) := 'GET_CAN_BTO';

Line 820: x_can_id OUT NOCOPY OKC_K_HEADERS_B.CUST_ACCT_ID%TYPE

816: PROCEDURE get_can_bto(
817: x_return_status OUT NOCOPY VARCHAR2,
818: p_chr_id IN OKC_K_HEADERS_B.ID%TYPE,
819: x_bto_id OUT NOCOPY OKC_K_HEADERS_B.BILL_TO_SITE_USE_ID%TYPE,
820: x_can_id OUT NOCOPY OKC_K_HEADERS_B.CUST_ACCT_ID%TYPE
821: ) IS
822:
823: l_proc_name VARCHAR2(35) := 'GET_CAN_BTO';
824:

Line 825: CURSOR can_bto_csr (p_chr_id OKC_K_HEADERS_B.ID%TYPE) IS

821: ) IS
822:
823: l_proc_name VARCHAR2(35) := 'GET_CAN_BTO';
824:
825: CURSOR can_bto_csr (p_chr_id OKC_K_HEADERS_B.ID%TYPE) IS
826: SELECT bill_to_site_use_id,
827: cust_acct_id
828: FROM okc_k_headers_v
829: WHERE id = p_chr_id;

Line 1622: l_bill_to_site_use_id OKC_K_HEADERS_B.BILL_TO_SITE_USE_ID%TYPE;

1618:
1619: l_cust_acct_present VARCHAR2(1) := 'N';
1620: l_bto_present VARCHAR2(1) := 'N';
1621:
1622: l_bill_to_site_use_id OKC_K_HEADERS_B.BILL_TO_SITE_USE_ID%TYPE;
1623: l_cust_acct_id OKC_K_HEADERS_B.CUST_ACCT_ID%TYPE;
1624: l_proc_name VARCHAR2(35) := 'check_header_literal';
1625:
1626: BEGIN

Line 1623: l_cust_acct_id OKC_K_HEADERS_B.CUST_ACCT_ID%TYPE;

1619: l_cust_acct_present VARCHAR2(1) := 'N';
1620: l_bto_present VARCHAR2(1) := 'N';
1621:
1622: l_bill_to_site_use_id OKC_K_HEADERS_B.BILL_TO_SITE_USE_ID%TYPE;
1623: l_cust_acct_id OKC_K_HEADERS_B.CUST_ACCT_ID%TYPE;
1624: l_proc_name VARCHAR2(35) := 'check_header_literal';
1625:
1626: BEGIN
1627:

Line 1846: OKC_K_HEADERS_B CHRB

1842: OKL_ASSET_RETURNS_B OAR,
1843: OKC_K_ITEMS CIM_FA,
1844: OKC_K_LINES_B CLEB_FA,
1845: OKC_K_LINES_B CLEB_TL,
1846: OKC_K_HEADERS_B CHRB
1847: WHERE cleb_tl.chr_id = chrb.id
1848: AND chrb.inv_organization_id = p_org_id
1849: AND cleb_tl.lse_id = G_FIN_LINE_LTY_ID
1850: AND oar.kle_id = cleb_tl.id

Line 1860: FROM okc_k_headers_b chrb_2,

1856: AND cim_fa.object1_id1 = fa.asset_id
1857: AND cim_fa.object1_id2 ='#'
1858: AND fa.asset_number = oli.asset_number
1859: AND not exists (SELECT '1'
1860: FROM okc_k_headers_b chrb_2,
1861: okc_statuses_b chr_sts,
1862: okc_k_lines_b cleb_2,
1863: okc_statuses_b cle_sts,
1864: okc_k_items cim_2

Line 1892: OKC_K_HEADERS_B CHRB

1888: OKL_ASSET_RETURNS_B OAR,
1889: OKC_K_ITEMS CIM_FA,
1890: OKC_K_LINES_B CLEB_FA,
1891: OKC_K_LINES_B CLEB_TL,
1892: OKC_K_HEADERS_B CHRB
1893: WHERE cleb_tl.chr_id = chrb.id
1894: AND chrb.inv_organization_id = p_org_id
1895: AND cleb_tl.lse_id = G_FIN_LINE_LTY_ID
1896: AND oar.kle_id = cleb_tl.id

Line 5430: CURSOR get_rule_group_info(p_chr_id okc_k_headers_b.id%TYPE,

5426: p_tax_name IS NOT NULL)
5427: AND TRUNC(SYSDATE) BETWEEN NVL(TRUNC(start_date), TRUNC(SYSDATE))
5428: AND NVL(TRUNC(end_date), TRUNC(SYSDATE));
5429:
5430: CURSOR get_rule_group_info(p_chr_id okc_k_headers_b.id%TYPE,
5431: p_cle_id okc_k_lines_v.id%TYPE) IS
5432: SELECT rgp.id
5433: FROM okc_rule_groups_v rgp
5434: WHERE rgp.dnz_chr_id = p_chr_id

Line 5440: CURSOR get_sales_tax_rule_info(p_chr_id okc_k_headers_b.id%TYPE,

5436: AND rgp.rgd_code = 'LAASTX'
5437: AND rgp.rgp_type = 'KRG';
5438:
5439: -- 5179119
5440: CURSOR get_sales_tax_rule_info(p_chr_id okc_k_headers_b.id%TYPE,
5441: p_rgp_id okc_k_lines_v.id%TYPE) IS
5442: SELECT rule.id
5443: FROM okc_rules_v rule
5444: WHERE rule.dnz_chr_id = p_chr_id

Line 5448: CURSOR get_prop_tax_rule_info(p_chr_id okc_k_headers_b.id%TYPE,

5444: WHERE rule.dnz_chr_id = p_chr_id
5445: AND rule.rgp_id = p_rgp_id
5446: AND rule.rule_information_category = 'LAASTX';
5447:
5448: CURSOR get_prop_tax_rule_info(p_chr_id okc_k_headers_b.id%TYPE,
5449: p_rgp_id okc_k_lines_v.id%TYPE) IS
5450: SELECT rule.id
5451: FROM okc_rules_v rule
5452: WHERE rule.dnz_chr_id = p_chr_id

Line 6003: CURSOR get_est_prop_tax_info(p_chr_id okc_k_headers_b.id%TYPE) IS

5999: NVL(TRUNC(end_date_active), TRUNC(SYSDATE));
6000:
6001: -- Added by rravikir (Fix for Bug 3947959)
6002: lv_asset_default okl_property_tax_setups.enable_asset_default%TYPE;
6003: CURSOR get_est_prop_tax_info(p_chr_id okc_k_headers_b.id%TYPE) IS
6004: SELECT enable_asset_default
6005: FROM okl_property_tax_setups
6006: WHERE org_id = (SELECT authoring_org_id
6007: FROM okc_k_headers_b

Line 6007: FROM okc_k_headers_b

6003: CURSOR get_est_prop_tax_info(p_chr_id okc_k_headers_b.id%TYPE) IS
6004: SELECT enable_asset_default
6005: FROM okl_property_tax_setups
6006: WHERE org_id = (SELECT authoring_org_id
6007: FROM okc_k_headers_b
6008: WHERE id = p_chr_id);
6009: -- End
6010:
6011: l_present_yn VARCHAR2(1);

Line 6015: CURSOR get_sales_tax_rgp_info(p_chr_id okc_k_headers_b.id%TYPE,

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
6017: SELECT rgp.id
6018: FROM okc_rule_groups_v rgp
6019: WHERE rgp.dnz_chr_id = p_chr_id

Line 6024: CURSOR get_sales_tax_rule_info(p_chr_id okc_k_headers_b.id%TYPE,

6020: AND rgp.cle_id = p_cle_id
6021: AND rgp.rgd_code = 'LAASTX'
6022: AND rgp.rgp_type = 'KRG';
6023:
6024: CURSOR get_sales_tax_rule_info(p_chr_id okc_k_headers_b.id%TYPE,
6025: p_rgp_id okc_k_lines_v.id%TYPE) IS
6026: SELECT rule.id
6027: FROM okc_rules_v rule
6028: WHERE rule.dnz_chr_id = p_chr_id

Line 8094: l_contract_number okc_k_headers_b.contract_number%TYPE;

8090: SUBTYPE fee_types_rec_type IS OKL_MAINTAIN_FEE_PVT.fee_types_rec_type;
8091: l_fee_types_rec fee_types_rec_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

Line 8095: l_contract_start_date okc_k_headers_b.start_date%TYPE;

8091: l_fee_types_rec fee_types_rec_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

Line 22252: CURSOR get_rule_group_info(p_chr_id okc_k_headers_b.id%TYPE,

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
22254: SELECT rgp.id
22255: FROM okc_rule_groups_b rgp
22256: WHERE rgp.dnz_chr_id = p_chr_id

Line 23688: p_contract_id IN okc_k_headers_b.id%TYPE,

23684: PROCEDURE create_party_payment_hdr(
23685: x_return_status OUT NOCOPY VARCHAR2,
23686: x_msg_count OUT NOCOPY NUMBER,
23687: x_msg_data OUT NOCOPY VARCHAR2,
23688: p_contract_id IN okc_k_headers_b.id%TYPE,
23689: p_line_id IN okc_k_lines_b.id%TYPE,
23690: p_line_type IN okl_lines_interface.line_type%TYPE,
23691: p_pth_start_date IN okl_party_payment_hdr.passthru_start_date%TYPE,
23692: p_pth_base_payout_basis IN okl_party_payment_hdr.payout_basis%TYPE,

Line 23712: l_contract_number okc_k_headers_b.contract_number%TYPE;

23708: l_evg_pmnt_hdr pphv_rec_type := NULL;
23709: l_pmnt_hdr_tbl_in pphv_tbl_type;
23710: l_pmnt_hdr_tbl_out pphv_tbl_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:

Line 23713: l_contract_start_date okc_k_headers_b.start_date%TYPE;

23709: l_pmnt_hdr_tbl_in pphv_tbl_type;
23710: l_pmnt_hdr_tbl_out pphv_tbl_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

Line 24735: FROM okc_k_headers_b

24731: AND rle_code = 'LESSEE' ;
24732:
24733: CURSOR temp_cust_acc_csr (p_chr_id OKC_K_HEADERS_V.ID%TYPE) IS
24734: SELECT cust_acct_id
24735: FROM okc_k_headers_b
24736: WHERE id = p_chr_id;
24737:
24738: CURSOR credit_csr (p_chr_id OKC_K_HEADERS_V.ID%TYPE,
24739: p_main_start_date OKC_K_HEADERS_V.START_DATE%TYPE) IS

Line 27148: l_contract_id okc_k_headers_b.id%type;

27144: p_delete_before_import_yn IN varchar2 -- akp_delete
27145: ) IS
27146:
27147: l_proc_name VARCHAR2(35) := 'CHECK_AND_DELETE';
27148: l_contract_id okc_k_headers_b.id%type;
27149:
27150: cursor get_contract_id(p_contract_no varchar2) is
27151: select id
27152: from okc_k_headers_b

Line 27152: from okc_k_headers_b

27148: l_contract_id okc_k_headers_b.id%type;
27149:
27150: cursor get_contract_id(p_contract_no varchar2) is
27151: select id
27152: from okc_k_headers_b
27153: where contract_number = p_contract_no;
27154:
27155: -- udhenuko Bug#5666768 Start
27156: l_ipyv_rec okl_ipy_pvt.ipyv_rec_type;

Line 28315: CURSOR deal_csr (p_chr_id OKC_K_HEADERS_B.ID%TYPE) IS

28311: FROM okl_txl_assets_b
28312: WHERE dnz_khr_id = p_khr_id
28313: AND kle_id = p_kle_id;
28314:
28315: CURSOR deal_csr (p_chr_id OKC_K_HEADERS_B.ID%TYPE) IS
28316: SELECT 'Y' loan_revolving
28317: FROM okl_k_headers
28318: WHERE deal_type = 'LOAN-REVOLVING'
28319: AND id = p_chr_id;