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 1287: p_cle_id IN OKC_K_LINES_V.ID%TYPE,

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

Line 1296: p_cle_id OKC_K_LINES_V.ID%TYPE,

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

Line 5532: p_line_number IN okc_k_lines_v.line_number%TYPE,

5528: x_msg_data OUT NOCOPY VARCHAR2,
5529: p_chr_id IN okc_k_headers_v.id%TYPE,
5530: p_contract_number IN okl_header_interface.contract_number_old%TYPE,
5531: p_cle_id IN okl_k_lines_v.id%TYPE,
5532: p_line_number IN okc_k_lines_v.line_number%TYPE,
5533: p_line_type IN okl_lines_interface.line_type%TYPE,
5534: p_inv_org_id IN okl_lines_interface.inventory_organization_id%TYPE,
5535: p_sales_tax_exempt_flag IN okl_lines_interface.sales_tax_exempt_flag%TYPE,
5536: p_sales_tax_exempt_cert_number IN okl_lines_interface.sales_tax_exempt_cert_number%TYPE,

Line 5599: p_cle_id okc_k_lines_v.id%TYPE) IS

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

Line 5609: p_rgp_id okc_k_lines_v.id%TYPE) IS

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

Line 5617: p_rgp_id okc_k_lines_v.id%TYPE) IS

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

Line 6047: p_line_number IN okc_k_lines_v.line_number%TYPE,

6043: x_msg_data OUT NOCOPY VARCHAR2,
6044: p_chr_id IN okc_k_headers_v.id%TYPE,
6045: p_contract_number IN okl_header_interface.contract_number_old%TYPE,
6046: p_cle_id IN okl_k_lines_v.id%TYPE,
6047: p_line_number IN okc_k_lines_v.line_number%TYPE,
6048: p_line_type IN okl_lines_interface.line_type%TYPE,
6049: p_inv_org_id IN okl_lines_interface.inventory_organization_id%TYPE,
6050: p_sales_tax_exempt_flag IN okl_lines_interface.sales_tax_exempt_flag%TYPE,
6051: p_sales_tax_exempt_cert_number IN okl_lines_interface.sales_tax_exempt_cert_number%TYPE,

Line 6184: p_cle_id okc_k_lines_v.id%TYPE) IS

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

Line 6193: p_rgp_id okc_k_lines_v.id%TYPE) IS

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

Line 18551: p_line_number IN okc_k_lines_v.line_number%TYPE,

18547: x_return_status OUT NOCOPY VARCHAR2,
18548: x_msg_count OUT NOCOPY NUMBER,
18549: x_msg_data OUT NOCOPY VARCHAR2,
18550: p_contract_number IN okc_k_headers_v.contract_number%TYPE,
18551: p_line_number IN okc_k_lines_v.line_number%TYPE,
18552: p_auth_org_id IN NUMBER,
18553: p_ship_to_site_number IN okx_party_site_uses_v.party_site_number%TYPE,
18554: p_ship_to_site_id IN okx_party_site_uses_v.party_site_id%TYPE,
18555: x_ship_to_site_id OUT NOCOPY okx_party_site_uses_v.party_site_id%TYPE

Line 18665: p_line_number IN okc_k_lines_v.line_number%TYPE,

18661: x_return_status OUT NOCOPY VARCHAR2,
18662: x_msg_count OUT NOCOPY NUMBER,
18663: x_msg_data OUT NOCOPY VARCHAR2,
18664: p_contract_number IN okc_k_headers_v.contract_number%TYPE,
18665: p_line_number IN okc_k_lines_v.line_number%TYPE,
18666: p_guarantor_site_number IN okl_party_roles_interface.guarantor_site_number%TYPE,
18667: p_guarantor_site_id IN okl_party_roles_interface.guarantor_site_id%TYPE,
18668: x_guarantor_site_id OUT NOCOPY okl_party_roles_interface.guarantor_site_id%TYPE
18669: ) IS

Line 19284: p_line_number IN okc_k_lines_v.line_number%TYPE,

19280: x_msg_data OUT NOCOPY VARCHAR2,
19281: p_contract_number IN okl_header_interface.contract_number_old%TYPE,
19282: p_chr_id IN okc_k_headers_v.id%TYPE,
19283: p_auth_org_id IN okl_header_interface.authoring_org_id%TYPE,
19284: p_line_number IN okc_k_lines_v.line_number%TYPE,
19285: p_line_type IN okl_lines_interface.line_type%TYPE,
19286: p_fin_cle_id IN NUMBER,
19287: p_model_cle_id IN NUMBER,
19288: p_service_line_id IN NUMBER,

Line 21851: p_line_number IN okc_k_lines_v.line_number%TYPE,

21847: x_msg_data OUT NOCOPY VARCHAR2,
21848: p_contract_number IN okc_k_headers_v.contract_number%TYPE,
21849: p_chr_id IN okc_k_headers_v.id%TYPE,
21850: p_auth_org_id IN okl_header_interface.authoring_org_id%TYPE,
21851: p_line_number IN okc_k_lines_v.line_number%TYPE,
21852: p_line_type IN okl_lines_interface.line_type%TYPE,
21853: p_cle_id IN okc_k_lines_v.id%TYPE,
21854: p_bill_to_address_id IN okl_terms_interface.bill_to_address_id%TYPE,
21855: p_bill_to_address IN okl_terms_interface.bill_to_address%TYPE,

Line 21853: p_cle_id IN okc_k_lines_v.id%TYPE,

21849: p_chr_id IN okc_k_headers_v.id%TYPE,
21850: p_auth_org_id IN okl_header_interface.authoring_org_id%TYPE,
21851: p_line_number IN okc_k_lines_v.line_number%TYPE,
21852: p_line_type IN okl_lines_interface.line_type%TYPE,
21853: p_cle_id IN okc_k_lines_v.id%TYPE,
21854: p_bill_to_address_id IN okl_terms_interface.bill_to_address_id%TYPE,
21855: p_bill_to_address IN okl_terms_interface.bill_to_address%TYPE,
21856: p_bank_account_id IN okl_terms_interface.bank_account_id%TYPE,
21857: p_bank_account_number IN okl_terms_interface.bank_account_number%TYPE,

Line 22440: p_cle_id okc_k_lines_v.id%TYPE) IS

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

Line 23067: p_line_number IN okc_k_lines_v.line_number%TYPE,

23063: x_return_status OUT NOCOPY VARCHAR2,
23064: x_msg_count OUT NOCOPY NUMBER,
23065: x_msg_data OUT NOCOPY VARCHAR2,
23066: p_contract_number IN okc_k_headers_v.contract_number%TYPE,
23067: p_line_number IN okc_k_lines_v.line_number%TYPE,
23068: p_comb_id IN NUMBER,
23069: p_segment1 IN VARCHAR2,
23070: p_segment2 IN VARCHAR2,
23071: p_segment3 IN VARCHAR2,

Line 23224: p_line_number IN okc_k_lines_v.line_number%TYPE,

23220: x_return_status OUT NOCOPY VARCHAR2,
23221: x_msg_count OUT NOCOPY NUMBER,
23222: x_msg_data OUT NOCOPY VARCHAR2,
23223: p_contract_number IN okc_k_headers_v.contract_number%TYPE,
23224: p_line_number IN okc_k_lines_v.line_number%TYPE,
23225: p_type IN VARCHAR2,
23226: p_comb_id IN NUMBER,
23227: p_segment1 IN VARCHAR2,
23228: p_segment2 IN VARCHAR2,

Line 23645: p_line_number IN okc_k_lines_v.line_number%TYPE,

23641: x_msg_data OUT NOCOPY VARCHAR2,
23642: p_asset_number IN okl_lines_interface.asset_number%TYPE,
23643: p_contract_number IN okc_k_headers_v.contract_number%TYPE,
23644: p_chr_id IN okc_k_headers_v.id%TYPE,
23645: p_line_number IN okc_k_lines_v.line_number%TYPE,
23646: x_asset_line_id OUT NOCOPY okc_k_lines_v.id%TYPE
23647: ) IS
23648:
23649: l_proc_name VARCHAR2(35) := 'GET_LINK_ASSET_ID';

Line 23646: x_asset_line_id OUT NOCOPY okc_k_lines_v.id%TYPE

23642: p_asset_number IN okl_lines_interface.asset_number%TYPE,
23643: p_contract_number IN okc_k_headers_v.contract_number%TYPE,
23644: p_chr_id IN okc_k_headers_v.id%TYPE,
23645: p_line_number IN okc_k_lines_v.line_number%TYPE,
23646: x_asset_line_id OUT NOCOPY okc_k_lines_v.id%TYPE
23647: ) IS
23648:
23649: l_proc_name VARCHAR2(35) := 'GET_LINK_ASSET_ID';
23650: fin_failed EXCEPTION;

Line 23651: l_line_id okc_k_lines_v.id%TYPE;

23647: ) IS
23648:
23649: l_proc_name VARCHAR2(35) := 'GET_LINK_ASSET_ID';
23650: fin_failed EXCEPTION;
23651: l_line_id okc_k_lines_v.id%TYPE;
23652:
23653: CURSOR fin_csr (p_chr_id NUMBER,
23654: p_asset_number VARCHAR2) IS
23655: SELECT id

Line 23656: FROM okc_k_lines_v

23652:
23653: CURSOR fin_csr (p_chr_id NUMBER,
23654: p_asset_number VARCHAR2) IS
23655: SELECT id
23656: FROM okc_k_lines_v
23657: WHERE name = p_asset_number
23658: AND chr_id = p_chr_id
23659: AND lse_id = (
23660: SELECT id

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

24142: p_term_quote_id IN OKL_LINES_INTERFACE.TERMINATION_QUOTE_ID%TYPE,
24143: p_term_quote_number IN OKL_LINES_INTERFACE.TERMINATION_QUOTE_NUMBER%TYPE,
24144: x_inv_item_id_prev OUT NOCOPY okl_lines_interface.inventory_item_id%TYPE,
24145: p_cle_id IN okl_k_lines_v.id%TYPE,
24146: x_cle_id OUT NOCOPY okc_k_lines_v.id%TYPE,
24147: x_sub_cle_id OUT NOCOPY okc_k_lines_v.id%TYPE, -- Bug# 3110115
24148: p_new_line_flag IN okl_lines_interface.explicit_new_line_flag%TYPE,
24149: p_pth_base_payout_basis IN okl_lines_interface.pth_base_payout_basis%TYPE,
24150: p_pth_base_stream_code IN okl_lines_interface.pth_base_stream_code%TYPE,

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

24143: p_term_quote_number IN OKL_LINES_INTERFACE.TERMINATION_QUOTE_NUMBER%TYPE,
24144: x_inv_item_id_prev OUT NOCOPY okl_lines_interface.inventory_item_id%TYPE,
24145: p_cle_id IN okl_k_lines_v.id%TYPE,
24146: x_cle_id OUT NOCOPY okc_k_lines_v.id%TYPE,
24147: x_sub_cle_id OUT NOCOPY okc_k_lines_v.id%TYPE, -- Bug# 3110115
24148: p_new_line_flag IN okl_lines_interface.explicit_new_line_flag%TYPE,
24149: p_pth_base_payout_basis IN okl_lines_interface.pth_base_payout_basis%TYPE,
24150: p_pth_base_stream_code IN okl_lines_interface.pth_base_stream_code%TYPE,
24151: p_pth_base_stream_purpose_code IN okl_lines_interface.pth_base_stream_purpose_code%TYPE,

Line 24181: x_asset_line_id okc_k_lines_v.id%TYPE;

24177: l_proc_name VARCHAR2(35) := 'PROCESS_OTHER_LINE';
24178: x_lse_id okc_line_styles_v.id%TYPE;
24179: x_inv_org_id NUMBER;
24180: x_inv_item_id NUMBER;
24181: x_asset_line_id okc_k_lines_v.id%TYPE;
24182: l_lty_code okc_line_styles_v.lty_code%TYPE;
24183: l_link_lty_code okc_line_styles_v.lty_code%TYPE;
24184: l_link_top_code VARCHAR2(35);
24185: x_stream_type_id NUMBER;

Line 27571: x_cle_id okc_k_lines_v.id%TYPE;

27567: p_line_type_prev VARCHAR2(35);
27568: x_ship_to_site_id okx_party_site_uses_v.id1%TYPE;
27569: l_rg_id NUMBER;
27570:
27571: x_cle_id okc_k_lines_v.id%TYPE;
27572: p_cle_id okc_k_lines_v.id%TYPE;
27573:
27574: -- Header Rec
27575: p_chrv_rec chrv_rec_type;

Line 27572: p_cle_id okc_k_lines_v.id%TYPE;

27568: x_ship_to_site_id okx_party_site_uses_v.id1%TYPE;
27569: l_rg_id NUMBER;
27570:
27571: x_cle_id okc_k_lines_v.id%TYPE;
27572: p_cle_id okc_k_lines_v.id%TYPE;
27573:
27574: -- Header Rec
27575: p_chrv_rec chrv_rec_type;
27576: p_khrv_rec khrv_rec_type;

Line 27622: l_service_line_id OKC_K_LINES_V.ID%TYPE;

27618: okl_header_rec intf_h_rec_type; --cklee
27619:
27620: l_header_template template_h_rec_type; -- Header template record
27621:
27622: l_service_line_id OKC_K_LINES_V.ID%TYPE;
27623: l_fee_line_id OKC_K_LINES_V.ID%TYPE;
27624: l_usage_line_id OKC_K_LINES_V.ID%TYPE;
27625:
27626: x_update_status VARCHAR2(1);

Line 27623: l_fee_line_id OKC_K_LINES_V.ID%TYPE;

27619:
27620: l_header_template template_h_rec_type; -- Header template record
27621:
27622: l_service_line_id OKC_K_LINES_V.ID%TYPE;
27623: l_fee_line_id OKC_K_LINES_V.ID%TYPE;
27624: l_usage_line_id OKC_K_LINES_V.ID%TYPE;
27625:
27626: x_update_status VARCHAR2(1);
27627:

Line 27624: l_usage_line_id OKC_K_LINES_V.ID%TYPE;

27620: l_header_template template_h_rec_type; -- Header template record
27621:
27622: l_service_line_id OKC_K_LINES_V.ID%TYPE;
27623: l_fee_line_id OKC_K_LINES_V.ID%TYPE;
27624: l_usage_line_id OKC_K_LINES_V.ID%TYPE;
27625:
27626: x_update_status VARCHAR2(1);
27627:
27628: header_validation_failed EXCEPTION;

Line 28627: x_sub_cle_id OKC_K_LINES_V.ID%TYPE;

28623: l_master_lease_aggr_id NUMBER;
28624: l_credit_line_id NUMBER;
28625: x_credit_line_id NUMBER;
28626:
28627: x_sub_cle_id OKC_K_LINES_V.ID%TYPE;
28628: l_payment_level VARCHAR2(3);
28629: l_pmnt_line_id OKC_K_LINES_V.ID%TYPE;
28630:
28631: l_loan_yn VARCHAR2(1) := 'N';

Line 28629: l_pmnt_line_id OKC_K_LINES_V.ID%TYPE;

28625: x_credit_line_id NUMBER;
28626:
28627: x_sub_cle_id OKC_K_LINES_V.ID%TYPE;
28628: l_payment_level VARCHAR2(3);
28629: l_pmnt_line_id OKC_K_LINES_V.ID%TYPE;
28630:
28631: l_loan_yn VARCHAR2(1) := 'N';
28632: l_prev_corp_book VARCHAR2(15) := 'NULL';
28633: l_prev_asset_number VARCHAR2(15) := 'NULL';