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 821: p_chr_id IN OKC_K_HEADERS_B.ID%TYPE,

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

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

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

Line 823: x_can_id OUT NOCOPY OKC_K_HEADERS_B.CUST_ACCT_ID%TYPE

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

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

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

Line 1625: l_bill_to_site_use_id OKC_K_HEADERS_B.BILL_TO_SITE_USE_ID%TYPE;

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

Line 1626: l_cust_acct_id OKC_K_HEADERS_B.CUST_ACCT_ID%TYPE;

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

Line 1851: OKC_K_HEADERS_B CHRB

1847: OKL_ASSET_RETURNS_B OAR,
1848: OKC_K_ITEMS CIM_FA,
1849: OKC_K_LINES_B CLEB_FA,
1850: OKC_K_LINES_B CLEB_TL,
1851: OKC_K_HEADERS_B CHRB
1852: WHERE cleb_tl.chr_id = chrb.id
1853: AND chrb.inv_organization_id = p_org_id
1854: AND cleb_tl.lse_id = G_FIN_LINE_LTY_ID
1855: AND oar.kle_id = cleb_tl.id

Line 1866: FROM okc_k_headers_b chrb_2,

1862: AND cim_fa.object1_id2 ='#'
1863: AND fa.asset_number = oli.asset_number
1864: AND oli.asset_number = p_asset_number -- Bug #15992711: Add extra condition to fetch the record pertaining to asset number
1865: AND not exists (SELECT '1'
1866: FROM okc_k_headers_b chrb_2,
1867: okc_statuses_b chr_sts,
1868: okc_k_lines_b cleb_2,
1869: okc_statuses_b cle_sts,
1870: okc_k_items cim_2

Line 1898: OKC_K_HEADERS_B CHRB

1894: OKL_ASSET_RETURNS_B OAR,
1895: OKC_K_ITEMS CIM_FA,
1896: OKC_K_LINES_B CLEB_FA,
1897: OKC_K_LINES_B CLEB_TL,
1898: OKC_K_HEADERS_B CHRB
1899: WHERE cleb_tl.chr_id = chrb.id
1900: AND chrb.inv_organization_id = p_org_id
1901: AND cleb_tl.lse_id = G_FIN_LINE_LTY_ID
1902: AND oar.kle_id = cleb_tl.id

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

5594: p_tax_name IS NOT NULL)
5595: AND TRUNC(SYSDATE) BETWEEN NVL(TRUNC(start_date), TRUNC(SYSDATE))
5596: AND NVL(TRUNC(end_date), TRUNC(SYSDATE));
5597:
5598: CURSOR get_rule_group_info(p_chr_id okc_k_headers_b.id%TYPE,
5599: p_cle_id okc_k_lines_v.id%TYPE) IS
5600: SELECT rgp.id
5601: FROM okc_rule_groups_v rgp
5602: WHERE rgp.dnz_chr_id = p_chr_id

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

5604: AND rgp.rgd_code = 'LAASTX'
5605: AND rgp.rgp_type = 'KRG';
5606:
5607: -- 5179119
5608: CURSOR get_sales_tax_rule_info(p_chr_id okc_k_headers_b.id%TYPE,
5609: p_rgp_id okc_k_lines_v.id%TYPE) IS
5610: SELECT rule.id
5611: FROM okc_rules_v rule
5612: WHERE rule.dnz_chr_id = p_chr_id

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

5612: WHERE rule.dnz_chr_id = p_chr_id
5613: AND rule.rgp_id = p_rgp_id
5614: AND rule.rule_information_category = 'LAASTX';
5615:
5616: CURSOR get_prop_tax_rule_info(p_chr_id okc_k_headers_b.id%TYPE,
5617: p_rgp_id okc_k_lines_v.id%TYPE) IS
5618: SELECT rule.id
5619: FROM okc_rules_v rule
5620: WHERE rule.dnz_chr_id = p_chr_id

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

6167: NVL(TRUNC(end_date_active), TRUNC(SYSDATE));
6168:
6169: -- Added by rravikir (Fix for Bug 3947959)
6170: lv_asset_default okl_property_tax_setups.enable_asset_default%TYPE;
6171: CURSOR get_est_prop_tax_info(p_chr_id okc_k_headers_b.id%TYPE) IS
6172: SELECT enable_asset_default
6173: FROM okl_property_tax_setups
6174: WHERE org_id = (SELECT authoring_org_id
6175: FROM okc_k_headers_b

Line 6175: FROM okc_k_headers_b

6171: CURSOR get_est_prop_tax_info(p_chr_id okc_k_headers_b.id%TYPE) IS
6172: SELECT enable_asset_default
6173: FROM okl_property_tax_setups
6174: WHERE org_id = (SELECT authoring_org_id
6175: FROM okc_k_headers_b
6176: WHERE id = p_chr_id);
6177: -- End
6178:
6179: l_present_yn VARCHAR2(1);

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

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
6185: SELECT rgp.id
6186: FROM okc_rule_groups_v rgp
6187: WHERE rgp.dnz_chr_id = p_chr_id

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

6188: AND rgp.cle_id = p_cle_id
6189: AND rgp.rgd_code = 'LAASTX'
6190: AND rgp.rgp_type = 'KRG';
6191:
6192: CURSOR get_sales_tax_rule_info(p_chr_id okc_k_headers_b.id%TYPE,
6193: p_rgp_id okc_k_lines_v.id%TYPE) IS
6194: SELECT rule.id
6195: FROM okc_rules_v rule
6196: WHERE rule.dnz_chr_id = p_chr_id

Line 8262: l_contract_number okc_k_headers_b.contract_number%TYPE;

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

Line 8263: l_contract_start_date okc_k_headers_b.start_date%TYPE;

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

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

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
22441: SELECT rgp.id
22442: FROM okc_rule_groups_b rgp
22443: WHERE rgp.dnz_chr_id = p_chr_id

Line 23877: p_contract_id IN okc_k_headers_b.id%TYPE,

23873: PROCEDURE create_party_payment_hdr(
23874: x_return_status OUT NOCOPY VARCHAR2,
23875: x_msg_count OUT NOCOPY NUMBER,
23876: x_msg_data OUT NOCOPY VARCHAR2,
23877: p_contract_id IN okc_k_headers_b.id%TYPE,
23878: p_line_id IN okc_k_lines_b.id%TYPE,
23879: p_line_type IN okl_lines_interface.line_type%TYPE,
23880: p_pth_start_date IN okl_party_payment_hdr.passthru_start_date%TYPE,
23881: p_pth_base_payout_basis IN okl_party_payment_hdr.payout_basis%TYPE,

Line 23901: l_contract_number okc_k_headers_b.contract_number%TYPE;

23897: l_evg_pmnt_hdr pphv_rec_type := NULL;
23898: l_pmnt_hdr_tbl_in pphv_tbl_type;
23899: l_pmnt_hdr_tbl_out pphv_tbl_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:

Line 23902: l_contract_start_date okc_k_headers_b.start_date%TYPE;

23898: l_pmnt_hdr_tbl_in pphv_tbl_type;
23899: l_pmnt_hdr_tbl_out pphv_tbl_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

Line 24977: FROM okc_k_headers_b

24973: AND rle_code = 'LESSEE' ;
24974:
24975: CURSOR temp_cust_acc_csr (p_chr_id OKC_K_HEADERS_V.ID%TYPE) IS
24976: SELECT cust_acct_id
24977: FROM okc_k_headers_b
24978: WHERE id = p_chr_id;
24979:
24980: CURSOR credit_csr (p_chr_id OKC_K_HEADERS_V.ID%TYPE,
24981: p_main_start_date OKC_K_HEADERS_V.START_DATE%TYPE) IS

Line 27420: l_contract_id okc_k_headers_b.id%type;

27416: p_delete_before_import_yn IN varchar2 -- akp_delete
27417: ) IS
27418:
27419: l_proc_name VARCHAR2(35) := 'CHECK_AND_DELETE';
27420: l_contract_id okc_k_headers_b.id%type;
27421:
27422: cursor get_contract_id(p_contract_no varchar2) is
27423: select id
27424: from okc_k_headers_b

Line 27424: from okc_k_headers_b

27420: l_contract_id okc_k_headers_b.id%type;
27421:
27422: cursor get_contract_id(p_contract_no varchar2) is
27423: select id
27424: from okc_k_headers_b
27425: where contract_number = p_contract_no;
27426:
27427: -- udhenuko Bug#5666768 Start
27428: l_ipyv_rec okl_ipy_pvt.ipyv_rec_type;

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

28608: FROM okl_txl_assets_b
28609: WHERE dnz_khr_id = p_khr_id
28610: AND kle_id = p_kle_id;
28611:
28612: CURSOR deal_csr (p_chr_id OKC_K_HEADERS_B.ID%TYPE) IS
28613: SELECT 'Y' loan_revolving
28614: FROM okl_k_headers
28615: WHERE deal_type = 'LOAN-REVOLVING'
28616: AND id = p_chr_id;