[Home] [Help]
71:
72: --cursor to find that chr id is valid okl contract header id
73: cursor l_chr_csr (p_chr_id in number) is
74: select 'Y'
75: from okc_k_headers_b chrb,
76: okc_subclasses_b scsb
77: where chrb.id = p_chr_id
78: and scsb.code = chrb.scs_code
79: and scsb.cls_code = 'OKL';
121: p_lty_code in varchar2) is
122: select 'Y'
123: from okc_k_lines_b cleb,
124: okc_line_styles_b lseb,
125: okc_k_headers_b chrb,
126: okc_subclasses_b scsb
127: where chrb.id = cleb.dnz_chr_id
128: and scsb.code = chrb.scs_code
129: and scsb.cls_code = 'OKL'
1006: chr.start_date,
1007: khr.deal_type,
1008: khr.term_duration,
1009: NVL(khr.generate_accrual_yn, 'Y')
1010: FROM okc_k_headers_b chr,
1011: okl_k_headers khr
1012: WHERE khr.id = p_khr_id
1013: AND chr.id = khr.id;
1014:
1846: p_round_yn IN VARCHAR2 DEFAULT OKL_API.G_TRUE,
1847: x_converted_amount OUT NOCOPY NUMBER,
1848: x_return_status OUT NOCOPY VARCHAR2) is
1849:
1850: l_contract_currency okc_k_headers_b.currency_code%TYPE;
1851: l_currency_conversion_type okl_k_headers.currency_conversion_type%TYPE;
1852: l_currency_conversion_rate okl_k_headers.currency_conversion_rate%TYPE;
1853: l_currency_conversion_date okl_k_headers.currency_conversion_date%TYPE;
1854: l_converted_subsidy_amount Number;
4270: l_par_id NUMBER;
4271: l_rgd_id NUMBER;
4272: l_party_name VARCHAR2(1000);
4273:
4274: l_bill_to_site_use_id OKC_K_HEADERS_B.bill_to_site_use_id%TYPE;
4275: l_cust_acct_id OKC_K_PARTY_ROLES_B.cust_acct_id%TYPE;
4276: l_party_role FND_LOOKUPS.meaning%TYPE;
4277:
4278: ----------------------------------------------------------------------------
4308: cPl.Bill_To_Site_Use_Id Bill_To_Site_Use_Id,
4309: -- cPl.ROLE ParACty_Role,
4310: cPl.cUst_acct_Id cUst_acct_Id
4311: FROM Okl_k_Headers khr,
4312: Okc_k_Headers_b Par,
4313: Okc_Rule_Groups_v rgd,
4314: Okc_k_Party_Roles_b cPl
4315: WHERE khr.Id = cp_khr_Id
4316: AND Par.Id = khr.khr_Id
4910: lx_tilv_tbl okl_til_pvt.tilv_tbl_type;
4911: lx_tldv_tbl okl_tld_pvt.tldv_tbl_type;
4912:
4913: --Varangan - Billing Enhancement changes - Bug#5874824 - End
4914: l_bill_to_site_use_id OKC_K_HEADERS_B.bill_to_site_use_id%TYPE;
4915: l_cust_acct_id OKC_K_PARTY_ROLES_B.cust_acct_id%TYPE;
4916: l_payment_method_id Number;
4917: l_bank_account_id Number;
4918: l_inv_reason_for_review Varchar2(450);
7114: lx_taiv_rec okl_trx_ar_invoices_pub.taiv_rec_type;
7115: lx_tilv_rec okl_txl_ar_inv_lns_pub.tilv_rec_type;
7116: lx_bpd_acc_rec okl_acc_call_pub.bpd_acc_rec_type;
7117:
7118: l_bill_to_site_use_id OKC_K_HEADERS_B.bill_to_site_use_id%TYPE;
7119: l_cust_acct_id OKC_K_PARTY_ROLES_B.cust_acct_id%TYPE;
7120: l_payment_method_id Number;
7121: l_bank_account_id Number;
7122: l_inv_reason_for_review Varchar2(450);
7147: cursor l_chk_rbk_csr(p_chr_id IN NUMBER) is
7148: SELECT 'Y',
7149: chrb.orig_system_id1,
7150: ktrx.date_transaction_occurred
7151: FROM okc_k_headers_b CHRB,
7152: okl_trx_contracts ktrx
7153: WHERE ktrx.khr_id_new = chrb.id
7154: AND ktrx.tsu_code = 'ENTERED'
7155: AND ktrx.rbr_code is NOT NULL
7160: AND CHRB.id = p_chr_id
7161: AND CHRB.ORIG_SYSTEM_SOURCE_CODE = 'OKL_REBOOK';
7162:
7163: l_rebook_cpy varchar2(1) default 'N';
7164: l_orig_chr_id okc_k_headers_b.id%TYPE;
7165: l_rebook_date date;
7166:
7167: l_try_id number;
7168: