[Home] [Help]
55: l_line_cust_address_id OKL_TRX_AR_INVOICES_V.ibt_id%TYPE;
56: l_line_receipt_method_id OKL_TRX_AR_INVOICES_V.irm_id%TYPE;
57: l_line_term_id OKL_TRX_AR_INVOICES_V.irt_id%TYPE;
58:
59: l_khr_id okc_k_headers_b.id%type;
60:
61: CURSOR get_chr_id (p_kle_id NUMBER) IS
62: select dnz_chr_id
63: from okc_k_lines_b
78: -- nikshah -- Bug # 5484903 Fixed,
79: -- Changed CURSOR line_bill_to_csr SQL definition
80: CURSOR line_bill_to_csr(p_khr_id NUMBER, p_kle_id NUMBER) IS
81: SELECT cs.cust_acct_site_id, cp.standard_terms payment_term_id
82: FROM okc_k_headers_b khr
83: , okx_cust_site_uses_v cs
84: , okc_k_lines_b cle
85: , hz_customer_profiles cp
86: WHERE khr.id = p_khr_id
90: AND cle.BILL_TO_SITE_USE_ID = cs.id1
91: AND khr.bill_to_site_use_id = cp.site_use_id(+)
92: UNION
93: SELECT cs.cust_acct_site_id, cp.standard_terms payment_term_id
94: FROM okc_k_headers_b khr
95: , okc_k_lines_b cle
96: , okc_k_items item
97: , okc_k_lines_b linked_asset
98: , okx_cust_site_uses_v cs
568: IS
569: --modified by pgomes on 21-aug-2003 for rules migration
570: CURSOR get_khr_id_csr ( p_contract_number VARCHAR2 ) IS
571: SELECT cust_acct_id
572: FROM okc_k_headers_b
573: where contract_number = p_contract_number;
574:
575: --commented out by pgomes on 21-aug-2003 for rules migration
576: BEGIN
688: where id = p_cle_id;
689:
690: CURSOR derive_top_line_id (p_lsm_id NUMBER) IS
691: SELECT FA.ID
692: FROM OKC_K_HEADERS_B CHR,
693: OKC_K_LINES_B TOP_CLE,
694: OKC_LINE_STYLES_b TOP_LSE,
695: OKC_K_LINES_B SUB_CLE,
696: OKC_LINE_STYLES_b SUB_LSE,
760: FROM ra_salesreps
761: WHERE SALESREP_ID = p_salesrep_id;
762:
763: --cursor to fetch the sales rep for the contract.
764: CURSOR get_sales_rep(p_contract_number okc_k_headers_b.contract_number%TYPE) IS
765: SELECT contact.object1_id1
766: FROM okc_k_headers_b hdr, okc_contacts contact
767: WHERE contact.dnz_chr_id = hdr.id
768: AND hdr.contract_number = p_contract_number
762:
763: --cursor to fetch the sales rep for the contract.
764: CURSOR get_sales_rep(p_contract_number okc_k_headers_b.contract_number%TYPE) IS
765: SELECT contact.object1_id1
766: FROM okc_k_headers_b hdr, okc_contacts contact
767: WHERE contact.dnz_chr_id = hdr.id
768: AND hdr.contract_number = p_contract_number
769: AND contact.cro_code = 'SALESPERSON';
770:
1114: l_group_by_contract_yn okl_invoice_types_v.group_by_contract_yn%type;
1115: l_group_asset_yn okl_invoice_types_v.group_asset_yn%type;
1116: l_contract_level_yn okl_invoice_formats_v.contract_level_yn%type;
1117: l_invoice_group okl_invoice_formats_v.name%type;
1118: l_khr_id okc_k_headers_b.id%type;
1119: x_tax_det_rec OKL_PROCESS_SALES_TAX_PVT.tax_det_rec_type;
1120: l_api_version NUMBER := 1.0;
1121: x_msg_count NUMBER;
1122: x_msg_data VARCHAR2(4000);
1144: where id = p_cle_id;
1145:
1146: CURSOR derive_top_line_id (p_lsm_id NUMBER) IS
1147: SELECT FA.ID
1148: FROM OKC_K_HEADERS_B CHR,
1149: OKC_K_LINES_B TOP_CLE,
1150: OKC_LINE_STYLES_b TOP_LSE,
1151: OKC_K_LINES_B SUB_CLE,
1152: OKC_LINE_STYLES_b SUB_LSE,
1847: --gkhuntet - FP Bug 5516814..start
1848: CURSOR c_get_adv_rcpt_for_cont(cp_cont_number IN VARCHAR2) IS
1849: SELECT DISTINCT c.contract_number
1850: FROM okl_trx_csh_rcpt_all_b a, okl_txl_rcpt_apps_b b,
1851: okc_k_headers_b c
1852: WHERE a.FULLY_APPLIED_FLAG = 'N'
1853: AND a.receipt_type = 'ADV'
1854: AND a.id = b.rct_id_details
1855: AND b.khr_id = c.id
1874: l_group_by_contract_yn okl_invoice_types_v.group_by_contract_yn%type;
1875: l_group_asset_yn okl_invoice_types_v.group_asset_yn%type;
1876: l_contract_level_yn okl_invoice_formats_v.contract_level_yn%type;
1877: l_invoice_group okl_invoice_formats_v.name%type;
1878: l_khr_id okc_k_headers_b.id%type;
1879:
1880: CURSOR acc_sys_option is
1881: select account_derivation
1882: from okl_sys_acct_opts;