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_LINES_V

Line 1284: p_cle_id IN OKC_K_LINES_V.ID%TYPE,

1280: x_return_status OUT NOCOPY VARCHAR2,
1281: x_msg_count OUT NOCOPY NUMBER,
1282: x_msg_data OUT NOCOPY VARCHAR2,
1283: p_chr_id IN OKC_K_HEADERS_V.ID%TYPE,
1284: p_cle_id IN OKC_K_LINES_V.ID%TYPE,
1285: p_rgd_code IN OKC_RULE_GROUPS_V.RGD_CODE%TYPE,
1286: p_rule_code IN OKC_RULES_V.RULE_INFORMATION_CATEGORY%TYPE,
1287: x_rulv_tbl OUT NOCOPY rulv_tbl_type,
1288: x_rule_count OUT NOCOPY NUMBER

Line 1293: p_cle_id OKC_K_LINES_V.ID%TYPE,

1289: ) IS
1290: l_proc_name VARCHAR2(35) := 'GET_CONTRACT_RULES';
1291:
1292: CURSOR rulv_csr (p_chr_id OKC_K_HEADERS_V.ID%TYPE,
1293: p_cle_id OKC_K_LINES_V.ID%TYPE,
1294: p_rgd_code OKC_RULE_GROUPS_V.RGD_CODE%TYPE,
1295: p_rule_code OKC_RULES_V.RULE_INFORMATION_CATEGORY%TYPE) IS
1296: SELECT
1297: rule.ID,

Line 5364: p_line_number IN okc_k_lines_v.line_number%TYPE,

5360: x_msg_data OUT NOCOPY VARCHAR2,
5361: p_chr_id IN okc_k_headers_v.id%TYPE,
5362: p_contract_number IN okl_header_interface.contract_number_old%TYPE,
5363: p_cle_id IN okl_k_lines_v.id%TYPE,
5364: p_line_number IN okc_k_lines_v.line_number%TYPE,
5365: p_line_type IN okl_lines_interface.line_type%TYPE,
5366: p_inv_org_id IN okl_lines_interface.inventory_organization_id%TYPE,
5367: p_sales_tax_exempt_flag IN okl_lines_interface.sales_tax_exempt_flag%TYPE,
5368: p_sales_tax_exempt_cert_number IN okl_lines_interface.sales_tax_exempt_cert_number%TYPE,

Line 5431: p_cle_id okc_k_lines_v.id%TYPE) IS

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
5435: AND rgp.cle_id = p_cle_id

Line 5441: p_rgp_id okc_k_lines_v.id%TYPE) IS

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
5445: AND rule.rgp_id = p_rgp_id

Line 5449: p_rgp_id okc_k_lines_v.id%TYPE) IS

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
5453: AND rule.rgp_id = p_rgp_id

Line 5879: p_line_number IN okc_k_lines_v.line_number%TYPE,

5875: x_msg_data OUT NOCOPY VARCHAR2,
5876: p_chr_id IN okc_k_headers_v.id%TYPE,
5877: p_contract_number IN okl_header_interface.contract_number_old%TYPE,
5878: p_cle_id IN okl_k_lines_v.id%TYPE,
5879: p_line_number IN okc_k_lines_v.line_number%TYPE,
5880: p_line_type IN okl_lines_interface.line_type%TYPE,
5881: p_inv_org_id IN okl_lines_interface.inventory_organization_id%TYPE,
5882: p_sales_tax_exempt_flag IN okl_lines_interface.sales_tax_exempt_flag%TYPE,
5883: p_sales_tax_exempt_cert_number IN okl_lines_interface.sales_tax_exempt_cert_number%TYPE,

Line 6016: p_cle_id okc_k_lines_v.id%TYPE) IS

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
6020: AND rgp.cle_id = p_cle_id

Line 6025: p_rgp_id okc_k_lines_v.id%TYPE) IS

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
6029: AND rule.rgp_id = p_rgp_id

Line 18370: p_line_number IN okc_k_lines_v.line_number%TYPE,

18366: x_return_status OUT NOCOPY VARCHAR2,
18367: x_msg_count OUT NOCOPY NUMBER,
18368: x_msg_data OUT NOCOPY VARCHAR2,
18369: p_contract_number IN okc_k_headers_v.contract_number%TYPE,
18370: p_line_number IN okc_k_lines_v.line_number%TYPE,
18371: p_auth_org_id IN NUMBER,
18372: p_ship_to_site_number IN okx_party_site_uses_v.party_site_number%TYPE,
18373: p_ship_to_site_id IN okx_party_site_uses_v.party_site_id%TYPE,
18374: x_ship_to_site_id OUT NOCOPY okx_party_site_uses_v.party_site_id%TYPE

Line 18484: p_line_number IN okc_k_lines_v.line_number%TYPE,

18480: x_return_status OUT NOCOPY VARCHAR2,
18481: x_msg_count OUT NOCOPY NUMBER,
18482: x_msg_data OUT NOCOPY VARCHAR2,
18483: p_contract_number IN okc_k_headers_v.contract_number%TYPE,
18484: p_line_number IN okc_k_lines_v.line_number%TYPE,
18485: p_guarantor_site_number IN okl_party_roles_interface.guarantor_site_number%TYPE,
18486: p_guarantor_site_id IN okl_party_roles_interface.guarantor_site_id%TYPE,
18487: x_guarantor_site_id OUT NOCOPY okl_party_roles_interface.guarantor_site_id%TYPE
18488: ) IS

Line 19102: p_line_number IN okc_k_lines_v.line_number%TYPE,

19098: x_msg_data OUT NOCOPY VARCHAR2,
19099: p_contract_number IN okl_header_interface.contract_number_old%TYPE,
19100: p_chr_id IN okc_k_headers_v.id%TYPE,
19101: p_auth_org_id IN okl_header_interface.authoring_org_id%TYPE,
19102: p_line_number IN okc_k_lines_v.line_number%TYPE,
19103: p_line_type IN okl_lines_interface.line_type%TYPE,
19104: p_fin_cle_id IN NUMBER,
19105: p_model_cle_id IN NUMBER,
19106: p_service_line_id IN NUMBER,

Line 21665: p_line_number IN okc_k_lines_v.line_number%TYPE,

21661: x_msg_data OUT NOCOPY VARCHAR2,
21662: p_contract_number IN okc_k_headers_v.contract_number%TYPE,
21663: p_chr_id IN okc_k_headers_v.id%TYPE,
21664: p_auth_org_id IN okl_header_interface.authoring_org_id%TYPE,
21665: p_line_number IN okc_k_lines_v.line_number%TYPE,
21666: p_line_type IN okl_lines_interface.line_type%TYPE,
21667: p_cle_id IN okc_k_lines_v.id%TYPE,
21668: p_bill_to_address_id IN okl_terms_interface.bill_to_address_id%TYPE,
21669: p_bill_to_address IN okl_terms_interface.bill_to_address%TYPE,

Line 21667: p_cle_id IN okc_k_lines_v.id%TYPE,

21663: p_chr_id IN okc_k_headers_v.id%TYPE,
21664: p_auth_org_id IN okl_header_interface.authoring_org_id%TYPE,
21665: p_line_number IN okc_k_lines_v.line_number%TYPE,
21666: p_line_type IN okl_lines_interface.line_type%TYPE,
21667: p_cle_id IN okc_k_lines_v.id%TYPE,
21668: p_bill_to_address_id IN okl_terms_interface.bill_to_address_id%TYPE,
21669: p_bill_to_address IN okl_terms_interface.bill_to_address%TYPE,
21670: p_bank_account_id IN okl_terms_interface.bank_account_id%TYPE,
21671: p_bank_account_number IN okl_terms_interface.bank_account_number%TYPE,

Line 22253: p_cle_id okc_k_lines_v.id%TYPE) IS

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
22257: AND rgp.cle_id = p_cle_id

Line 22878: p_line_number IN okc_k_lines_v.line_number%TYPE,

22874: x_return_status OUT NOCOPY VARCHAR2,
22875: x_msg_count OUT NOCOPY NUMBER,
22876: x_msg_data OUT NOCOPY VARCHAR2,
22877: p_contract_number IN okc_k_headers_v.contract_number%TYPE,
22878: p_line_number IN okc_k_lines_v.line_number%TYPE,
22879: p_comb_id IN NUMBER,
22880: p_segment1 IN VARCHAR2,
22881: p_segment2 IN VARCHAR2,
22882: p_segment3 IN VARCHAR2,

Line 23035: p_line_number IN okc_k_lines_v.line_number%TYPE,

23031: x_return_status OUT NOCOPY VARCHAR2,
23032: x_msg_count OUT NOCOPY NUMBER,
23033: x_msg_data OUT NOCOPY VARCHAR2,
23034: p_contract_number IN okc_k_headers_v.contract_number%TYPE,
23035: p_line_number IN okc_k_lines_v.line_number%TYPE,
23036: p_type IN VARCHAR2,
23037: p_comb_id IN NUMBER,
23038: p_segment1 IN VARCHAR2,
23039: p_segment2 IN VARCHAR2,

Line 23456: p_line_number IN okc_k_lines_v.line_number%TYPE,

23452: x_msg_data OUT NOCOPY VARCHAR2,
23453: p_asset_number IN okl_lines_interface.asset_number%TYPE,
23454: p_contract_number IN okc_k_headers_v.contract_number%TYPE,
23455: p_chr_id IN okc_k_headers_v.id%TYPE,
23456: p_line_number IN okc_k_lines_v.line_number%TYPE,
23457: x_asset_line_id OUT NOCOPY okc_k_lines_v.id%TYPE
23458: ) IS
23459:
23460: l_proc_name VARCHAR2(35) := 'GET_LINK_ASSET_ID';

Line 23457: x_asset_line_id OUT NOCOPY okc_k_lines_v.id%TYPE

23453: p_asset_number IN okl_lines_interface.asset_number%TYPE,
23454: p_contract_number IN okc_k_headers_v.contract_number%TYPE,
23455: p_chr_id IN okc_k_headers_v.id%TYPE,
23456: p_line_number IN okc_k_lines_v.line_number%TYPE,
23457: x_asset_line_id OUT NOCOPY okc_k_lines_v.id%TYPE
23458: ) IS
23459:
23460: l_proc_name VARCHAR2(35) := 'GET_LINK_ASSET_ID';
23461: fin_failed EXCEPTION;

Line 23462: l_line_id okc_k_lines_v.id%TYPE;

23458: ) IS
23459:
23460: l_proc_name VARCHAR2(35) := 'GET_LINK_ASSET_ID';
23461: fin_failed EXCEPTION;
23462: l_line_id okc_k_lines_v.id%TYPE;
23463:
23464: CURSOR fin_csr (p_chr_id NUMBER,
23465: p_asset_number VARCHAR2) IS
23466: SELECT id

Line 23467: FROM okc_k_lines_v

23463:
23464: CURSOR fin_csr (p_chr_id NUMBER,
23465: p_asset_number VARCHAR2) IS
23466: SELECT id
23467: FROM okc_k_lines_v
23468: WHERE name = p_asset_number
23469: AND chr_id = p_chr_id
23470: AND lse_id = (
23471: SELECT id

Line 23957: x_cle_id OUT NOCOPY okc_k_lines_v.id%TYPE,

23953: p_term_quote_id IN OKL_LINES_INTERFACE.TERMINATION_QUOTE_ID%TYPE,
23954: p_term_quote_number IN OKL_LINES_INTERFACE.TERMINATION_QUOTE_NUMBER%TYPE,
23955: x_inv_item_id_prev OUT NOCOPY okl_lines_interface.inventory_item_id%TYPE,
23956: p_cle_id IN okl_k_lines_v.id%TYPE,
23957: x_cle_id OUT NOCOPY okc_k_lines_v.id%TYPE,
23958: x_sub_cle_id OUT NOCOPY okc_k_lines_v.id%TYPE, -- Bug# 3110115
23959: p_new_line_flag IN okl_lines_interface.explicit_new_line_flag%TYPE,
23960: p_pth_base_payout_basis IN okl_lines_interface.pth_base_payout_basis%TYPE,
23961: p_pth_base_stream_code IN okl_lines_interface.pth_base_stream_code%TYPE,

Line 23958: x_sub_cle_id OUT NOCOPY okc_k_lines_v.id%TYPE, -- Bug# 3110115

23954: p_term_quote_number IN OKL_LINES_INTERFACE.TERMINATION_QUOTE_NUMBER%TYPE,
23955: x_inv_item_id_prev OUT NOCOPY okl_lines_interface.inventory_item_id%TYPE,
23956: p_cle_id IN okl_k_lines_v.id%TYPE,
23957: x_cle_id OUT NOCOPY okc_k_lines_v.id%TYPE,
23958: x_sub_cle_id OUT NOCOPY okc_k_lines_v.id%TYPE, -- Bug# 3110115
23959: p_new_line_flag IN okl_lines_interface.explicit_new_line_flag%TYPE,
23960: p_pth_base_payout_basis IN okl_lines_interface.pth_base_payout_basis%TYPE,
23961: p_pth_base_stream_code IN okl_lines_interface.pth_base_stream_code%TYPE,
23962: p_pth_base_stream_purpose_code IN okl_lines_interface.pth_base_stream_purpose_code%TYPE,

Line 23974: x_asset_line_id okc_k_lines_v.id%TYPE;

23970: l_proc_name VARCHAR2(35) := 'PROCESS_OTHER_LINE';
23971: x_lse_id okc_line_styles_v.id%TYPE;
23972: x_inv_org_id NUMBER;
23973: x_inv_item_id NUMBER;
23974: x_asset_line_id okc_k_lines_v.id%TYPE;
23975: l_lty_code okc_line_styles_v.lty_code%TYPE;
23976: l_link_lty_code okc_line_styles_v.lty_code%TYPE;
23977: l_link_top_code VARCHAR2(35);
23978: x_stream_type_id NUMBER;

Line 27299: x_cle_id okc_k_lines_v.id%TYPE;

27295: p_line_type_prev VARCHAR2(35);
27296: x_ship_to_site_id okx_party_site_uses_v.id1%TYPE;
27297: l_rg_id NUMBER;
27298:
27299: x_cle_id okc_k_lines_v.id%TYPE;
27300: p_cle_id okc_k_lines_v.id%TYPE;
27301:
27302: -- Header Rec
27303: p_chrv_rec chrv_rec_type;

Line 27300: p_cle_id okc_k_lines_v.id%TYPE;

27296: x_ship_to_site_id okx_party_site_uses_v.id1%TYPE;
27297: l_rg_id NUMBER;
27298:
27299: x_cle_id okc_k_lines_v.id%TYPE;
27300: p_cle_id okc_k_lines_v.id%TYPE;
27301:
27302: -- Header Rec
27303: p_chrv_rec chrv_rec_type;
27304: p_khrv_rec khrv_rec_type;

Line 27350: l_service_line_id OKC_K_LINES_V.ID%TYPE;

27346: okl_header_rec intf_h_rec_type; --cklee
27347:
27348: l_header_template template_h_rec_type; -- Header template record
27349:
27350: l_service_line_id OKC_K_LINES_V.ID%TYPE;
27351: l_fee_line_id OKC_K_LINES_V.ID%TYPE;
27352: l_usage_line_id OKC_K_LINES_V.ID%TYPE;
27353:
27354: x_update_status VARCHAR2(1);

Line 27351: l_fee_line_id OKC_K_LINES_V.ID%TYPE;

27347:
27348: l_header_template template_h_rec_type; -- Header template record
27349:
27350: l_service_line_id OKC_K_LINES_V.ID%TYPE;
27351: l_fee_line_id OKC_K_LINES_V.ID%TYPE;
27352: l_usage_line_id OKC_K_LINES_V.ID%TYPE;
27353:
27354: x_update_status VARCHAR2(1);
27355: header_validation_failed EXCEPTION;

Line 27352: l_usage_line_id OKC_K_LINES_V.ID%TYPE;

27348: l_header_template template_h_rec_type; -- Header template record
27349:
27350: l_service_line_id OKC_K_LINES_V.ID%TYPE;
27351: l_fee_line_id OKC_K_LINES_V.ID%TYPE;
27352: l_usage_line_id OKC_K_LINES_V.ID%TYPE;
27353:
27354: x_update_status VARCHAR2(1);
27355: header_validation_failed EXCEPTION;
27356: line_validation_failed EXCEPTION;

Line 28330: x_sub_cle_id OKC_K_LINES_V.ID%TYPE;

28326: l_master_lease_aggr_id NUMBER;
28327: l_credit_line_id NUMBER;
28328: x_credit_line_id NUMBER;
28329:
28330: x_sub_cle_id OKC_K_LINES_V.ID%TYPE;
28331: l_payment_level VARCHAR2(3);
28332: l_pmnt_line_id OKC_K_LINES_V.ID%TYPE;
28333:
28334: l_loan_yn VARCHAR2(1) := 'N';

Line 28332: l_pmnt_line_id OKC_K_LINES_V.ID%TYPE;

28328: x_credit_line_id NUMBER;
28329:
28330: x_sub_cle_id OKC_K_LINES_V.ID%TYPE;
28331: l_payment_level VARCHAR2(3);
28332: l_pmnt_line_id OKC_K_LINES_V.ID%TYPE;
28333:
28334: l_loan_yn VARCHAR2(1) := 'N';
28335: l_prev_corp_book VARCHAR2(15) := 'NULL';
28336: l_prev_asset_number VARCHAR2(15) := 'NULL';