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_FUNDING_PVT dependencies on OKC_K_HEADERS_B

Line 114: p_khr_id IN okc_k_headers_b.id%TYPE,

110: p_init_msg_list IN VARCHAR2,
111: x_return_status OUT NOCOPY VARCHAR2,
112: x_msg_count OUT NOCOPY NUMBER,
113: x_msg_data OUT NOCOPY VARCHAR2,
114: p_khr_id IN okc_k_headers_b.id%TYPE,
115: p_id IN OKL_TRX_AP_INVOICES_B.id%TYPE,
116: p_event_name IN wf_events.name%TYPE) IS
117:
118: l_parameter_list wf_parameter_list_t;

Line 186: from okc_k_headers_b khr,

182: tap.VENDOR_INVOICE_NUMBER,
183: tap.IPVS_ID,
184: tap.PAYMENT_METHOD_CODE,
185: -SUM(NVL(OKL_FUNDING_PVT.get_partial_subsidy_amount(tpl.KLE_ID, tpl.AMOUNT),0)) SUBSIDY_TOT_AMT
186: from okc_k_headers_b khr,
187: okl_trx_ap_invoices_b tap,
188: okl_txl_ap_inv_lns_all_b tpl
189: where khr.id = tpl.khr_id
190: and tap.id = tpl.tap_id

Line 487: ,p_chr_id IN okc_k_headers_b.id%type

483: ,p_init_msg_list IN VARCHAR2
484: ,x_return_status OUT NOCOPY VARCHAR2
485: ,x_msg_count OUT NOCOPY NUMBER
486: ,x_msg_data OUT NOCOPY VARCHAR2
487: ,p_chr_id IN okc_k_headers_b.id%type
488: ,p_fund_req_id IN okl_trx_ap_invoices_b.id%type
489: ,p_creditline_id IN okc_k_headers_b.id%type DEFAULT NULL
490: )
491: is

Line 489: ,p_creditline_id IN okc_k_headers_b.id%type DEFAULT NULL

485: ,x_msg_count OUT NOCOPY NUMBER
486: ,x_msg_data OUT NOCOPY VARCHAR2
487: ,p_chr_id IN okc_k_headers_b.id%type
488: ,p_fund_req_id IN okl_trx_ap_invoices_b.id%type
489: ,p_creditline_id IN okc_k_headers_b.id%type DEFAULT NULL
490: )
491: is
492: l_api_name CONSTANT VARCHAR2(30) := 'create_funding_chklst_tpl';
493: l_api_version CONSTANT NUMBER := 1.0;

Line 516: l_credit_id okc_k_headers_b.id%TYPE;

512:
513:
514: l_template_row_not_found boolean;
515:
516: l_credit_id okc_k_headers_b.id%TYPE;
517:
518: l_funding_checklist_tpl okc_rules_b.rule_information2%TYPE;
519: l_checklists_row_found boolean;
520: -- start: 23-May-2005 cklee okl.h Lease App IA Authoring |

Line 569: CURSOR c_lease_app (p_chr_id okc_k_headers_b.id%type)

565: -- start: 23-May-2005 cklee okl.h Lease App IA Authoring |
566: ---------------------------------------------------------------------------------------------------------
567: -- check if the contract was created from a lease application
568: ---------------------------------------------------------------------------------------------------------
569: CURSOR c_lease_app (p_chr_id okc_k_headers_b.id%type)
570: IS
571: select chr.ORIG_SYSTEM_ID1
572: from okc_k_headers_b chr
573: where ORIG_SYSTEM_SOURCE_CODE = G_OKL_LEASE_APP

Line 572: from okc_k_headers_b chr

568: ---------------------------------------------------------------------------------------------------------
569: CURSOR c_lease_app (p_chr_id okc_k_headers_b.id%type)
570: IS
571: select chr.ORIG_SYSTEM_ID1
572: from okc_k_headers_b chr
573: where ORIG_SYSTEM_SOURCE_CODE = G_OKL_LEASE_APP
574: and chr.id = p_chr_id
575: ;
576:

Line 864: ,p_chr_id IN okc_k_headers_b.id%type

860: ,p_init_msg_list IN VARCHAR2
861: ,x_return_status OUT NOCOPY VARCHAR2
862: ,x_msg_count OUT NOCOPY NUMBER
863: ,x_msg_data OUT NOCOPY VARCHAR2
864: ,p_chr_id IN okc_k_headers_b.id%type
865: ,p_MLA_id IN okc_k_headers_b.id%type
866: ,p_creditline_id IN okc_k_headers_b.id%type
867: )
868: IS

Line 865: ,p_MLA_id IN okc_k_headers_b.id%type

861: ,x_return_status OUT NOCOPY VARCHAR2
862: ,x_msg_count OUT NOCOPY NUMBER
863: ,x_msg_data OUT NOCOPY VARCHAR2
864: ,p_chr_id IN okc_k_headers_b.id%type
865: ,p_MLA_id IN okc_k_headers_b.id%type
866: ,p_creditline_id IN okc_k_headers_b.id%type
867: )
868: IS
869: l_api_name CONSTANT VARCHAR2(30) := 'refresh_fund_chklst';

Line 866: ,p_creditline_id IN okc_k_headers_b.id%type

862: ,x_msg_count OUT NOCOPY NUMBER
863: ,x_msg_data OUT NOCOPY VARCHAR2
864: ,p_chr_id IN okc_k_headers_b.id%type
865: ,p_MLA_id IN okc_k_headers_b.id%type
866: ,p_creditline_id IN okc_k_headers_b.id%type
867: )
868: IS
869: l_api_name CONSTANT VARCHAR2(30) := 'refresh_fund_chklst';
870: l_api_version CONSTANT NUMBER := 1.0;

Line 873: l_old_credit_id okc_k_headers_b.id%TYPE;

869: l_api_name CONSTANT VARCHAR2(30) := 'refresh_fund_chklst';
870: l_api_version CONSTANT NUMBER := 1.0;
871: i NUMBER;
872: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
873: l_old_credit_id okc_k_headers_b.id%TYPE;
874: l_funded_amout NUMBER := 0;
875: l_fund_req_id okl_trx_ap_invoices_b.id%type;
876:
877: l_refresh_flag boolean := false;

Line 880: l_final_creditline_id okc_k_headers_b.id%type;

876:
877: l_refresh_flag boolean := false;
878: l_rule_id okc_rules_b.id%type;
879: ldel_rulv_rec rulv_rec_type;
880: l_final_creditline_id okc_k_headers_b.id%type;
881: l_MLA_creditline_id okc_k_headers_b.id%type;
882: --START: CKLEE 01/04/06
883: -- l_MLA_creditline_not_found boolean := false;
884: l_MLA_creditline_found boolean := false;

Line 881: l_MLA_creditline_id okc_k_headers_b.id%type;

877: l_refresh_flag boolean := false;
878: l_rule_id okc_rules_b.id%type;
879: ldel_rulv_rec rulv_rec_type;
880: l_final_creditline_id okc_k_headers_b.id%type;
881: l_MLA_creditline_id okc_k_headers_b.id%type;
882: --START: CKLEE 01/04/06
883: -- l_MLA_creditline_not_found boolean := false;
884: l_MLA_creditline_found boolean := false;
885: --END: CKLEE 01/04/06

Line 897: from OKC_K_HEADERS_B a,

893:
894: CURSOR c_MLA_credit (p_MLA_id NUMBER)
895: IS
896: select a.ID
897: from OKC_K_HEADERS_B a,
898: okc_Governances_v g
899: where a.id = g.chr_id_referred
900: and a.sts_code = 'ACTIVE'
901: and a.scs_code = 'CREDITLINE_CONTRACT'

Line 946: CURSOR c_lease_app (p_chr_id okc_k_headers_b.id%type)

942: -- start: 23-May-2005 cklee okl.h Lease App IA Authoring |
943: ---------------------------------------------------------------------------------------------------------
944: -- 5. check if the contract was created from a lease application
945: ---------------------------------------------------------------------------------------------------------
946: CURSOR c_lease_app (p_chr_id okc_k_headers_b.id%type)
947: IS
948: --start modified abhsaxen for Performance SQLID 20562299
949: select 1
950: from okc_k_headers_b chr

Line 950: from okc_k_headers_b chr

946: CURSOR c_lease_app (p_chr_id okc_k_headers_b.id%type)
947: IS
948: --start modified abhsaxen for Performance SQLID 20562299
949: select 1
950: from okc_k_headers_b chr
951: where ORIG_SYSTEM_SOURCE_CODE = G_OKL_LEASE_APP
952: and chr.id = p_chr_id
953: ;
954: --end modified abhsaxen for Performance SQLID 20562299

Line 1223: l_scs_code OKC_K_HEADERS_B.SCS_CODE%TYPE;

1219: l_sales_id NUMBER;
1220: l_site_uses_id NUMBER;
1221:
1222: --Bug# 4622198
1223: l_scs_code OKC_K_HEADERS_B.SCS_CODE%TYPE;
1224: l_fact_synd_code FND_LOOKUPS.Lookup_code%TYPE;
1225: l_inv_acct_code OKC_RULES_B.Rule_Information1%TYPE;
1226: --Bug# 4622198
1227:

Line 1314: okc_k_headers_b chr

1310: select ct.object1_id1
1311: from okc_contacts ct,
1312: okc_contact_sources csrc,
1313: okc_k_party_roles_b pty,
1314: okc_k_headers_b chr
1315: where ct.cpl_id = pty.id
1316: and ct.cro_code = csrc.cro_code
1317: and ct.jtot_object1_code = csrc.jtot_object_code
1318: and ct.dnz_chr_id = chr.id

Line 1352: from okc_k_headers_b chr

1348: */
1349: -- OKC/OKS rule migration project 11.5.10
1350: Cursor ar_site_uses_csr( p_chr_id NUMBER) IS
1351: select bill_to_site_use_id cust_acct_site_id
1352: from okc_k_headers_b chr
1353: where chr.id = p_chr_id;
1354:
1355: -- get sty_id for manual_disb
1356: -- cklee 05/04/2004

Line 1369: okc_k_headers_b khr

1365: ,chr.currency_conversion_type
1366: ,chr.currency_conversion_rate
1367: ,chr.currency_conversion_date
1368: FROM okl_k_headers chr,
1369: okc_k_headers_b khr
1370: WHERE chr.id = khr.id
1371: AND khr.id = p_khr_id;
1372:
1373: r_curr_conv l_curr_conv_csr%ROWTYPE;

Line 1766: l_sts_code OKC_K_HEADERS_B.sts_code%TYPE;

1762: ) RETURN NUMBER
1763: IS
1764: l_row_notfound boolean := false;
1765: l_yn number := 0;
1766: l_sts_code OKC_K_HEADERS_B.sts_code%TYPE;
1767: l_deal_type OKL_K_HEADERS.deal_type%TYPE;
1768:
1769: CURSOR c_deal_type(p_contract_id NUMBER)
1770: IS

Line 1774: OKC_K_HEADERS_B chr

1770: IS
1771: select chr.sts_code,
1772: khr.deal_type
1773: from OKL_K_HEADERS khr,
1774: OKC_K_HEADERS_B chr
1775: where khr.id = chr.id
1776: and khr.id = p_contract_id
1777: ;
1778:

Line 1784: okc_k_headers_b chr

1780: CURSOR c (p_contract_id NUMBER)
1781: IS
1782: select 1
1783: from okc_statuses_b ste,
1784: okc_k_headers_b chr
1785: where ste.code = chr.sts_code
1786: and ste.ste_code in ('ENTERED', 'ACTIVE','SIGNED')
1787: and chr.id = p_contract_id
1788: ;

Line 2339: okc_k_headers_b k

2335: nvl(cle.start_date,k.start_date)
2336: from OKL_K_LINES_FULL_V cle,
2337: okc_k_party_roles_b cpl,
2338: okc_line_styles_b ls,
2339: okc_k_headers_b k
2340: where k.id = cle.dnz_chr_id
2341: and cle.dnz_chr_id = p_contract_id
2342: and cle.lse_id = ls.id
2343: and ls.lty_code = p_rle_code

Line 2413: okc_k_headers_b k

2409:
2410: from okc_rule_groups_v crg,
2411: okc_rules_v cr,
2412: OKL_K_LINES_FULL_V cle,
2413: okc_k_headers_b k
2414: where crg.dnz_chr_id = p_contract_id
2415: and cle.dnz_chr_id = k.id
2416: and crg.id = cr.rgp_id
2417: and crg.rgd_code = 'LAFEXP'

Line 2618: okc_k_headers_b k

2614: nvl(cle.start_date,k.start_date)
2615: from OKL_K_LINES_FULL_V cle,
2616: okc_k_party_roles_b cpl,
2617: okc_line_styles_b ls,
2618: okc_k_headers_b k
2619: where k.id = cle.dnz_chr_id
2620: and cle.dnz_chr_id = p_contract_id
2621: and cle.lse_id = ls.id
2622: and ls.lty_code = p_rle_code

Line 2693: okc_k_headers_b k

2689: --cklee end 10/3/2007 bug: 6128765
2690: from okc_rule_groups_v crg,
2691: okc_rules_v cr,
2692: OKL_K_LINES_FULL_V cle,
2693: okc_k_headers_b k
2694: where crg.dnz_chr_id = p_contract_id
2695: and cle.dnz_chr_id = k.id
2696: and crg.id = cr.rgp_id
2697: and crg.rgd_code = 'LAFEXP'

Line 2904: FROM OKC_K_HEADERS_B chr

2900: -- but needs to be validated at contract line
2901: -- Cursor modified to include validation at asset line level
2902: --Start Modification 120.67.12010000.8 Pratrao 5-Feb-2013
2903: /*SELECT nvl(kle.re_lease_yn,'N')
2904: FROM OKC_K_HEADERS_B chr
2905: ,okc_k_lines_b cle
2906: ,okl_k_lines kle
2907: WHERE chr.id = cle.chr_id
2908: and chr.id = cle.dnz_chr_id

Line 2970: l_credit_id okc_k_headers_b.id%TYPE;

2966: l_chklist_sts_row_found boolean;
2967: l_status okl_crd_fund_checklists_tpl_uv.STATUS%TYPE;
2968: l_fund_cls_tpl_exp_found boolean := false;
2969:
2970: l_credit_id okc_k_headers_b.id%TYPE;
2971: -- start: 23-May-2005 cklee okl.h Lease App IA Authoring |
2972: l_lease_app_found boolean := false;
2973: -- end: 23-May-2005 cklee okl.h Lease App IA Authoring |
2974: ---------------------------------------------------------------------------------------------------------

Line 3016: CURSOR c_chklst (p_chr_id okc_k_headers_b.id%type, p_fund_req_id okl_trx_ap_invoices_b.id%type)

3012: ---------------------------------------------------------------------------------------------------------
3013: -- 4. check checklist required items
3014: ---------------------------------------------------------------------------------------------------------
3015:
3016: CURSOR c_chklst (p_chr_id okc_k_headers_b.id%type, p_fund_req_id okl_trx_ap_invoices_b.id%type)
3017: IS
3018: select 1
3019: from okc_rules_b rult
3020: where rult.rule_information_category = G_FUNDING_CHKLST_TPL_RULE1--'LAFCLD'

Line 3032: CURSOR c_lease_app (p_chr_id okc_k_headers_b.id%type)

3028: -- start: 23-May-2005 cklee okl.h Lease App IA Authoring |
3029: ---------------------------------------------------------------------------------------------------------
3030: -- 5. check if the contract was created from a lease application
3031: ---------------------------------------------------------------------------------------------------------
3032: CURSOR c_lease_app (p_chr_id okc_k_headers_b.id%type)
3033: IS
3034: --start modified abhsaxen for performance SQLID 20562365
3035: select 1
3036: from okc_k_headers_b chr

Line 3036: from okc_k_headers_b chr

3032: CURSOR c_lease_app (p_chr_id okc_k_headers_b.id%type)
3033: IS
3034: --start modified abhsaxen for performance SQLID 20562365
3035: select 1
3036: from okc_k_headers_b chr
3037: where ORIG_SYSTEM_SOURCE_CODE = G_OKL_LEASE_APP
3038: and chr.id = p_chr_id
3039: ;
3040: --end modified abhsaxen for performance SQLID 20562365

Line 3407: from OKC_K_HEADERS_B a

3403:
3404: CURSOR c_booked (p_contract_id NUMBER)
3405: IS
3406: select count(1)
3407: from OKC_K_HEADERS_B a
3408: where id = p_contract_id
3409: and sts_code = 'BOOKED'
3410: ;
3411:

Line 3957: okc_k_headers_b chr

3953: CURSOR c_sts (p_contract_id NUMBER)
3954: IS
3955: select ste.meaning
3956: from OKC_STATUSES_V ste,
3957: okc_k_headers_b chr
3958: where ste.code = chr.sts_code
3959: and chr.id = p_chr_id
3960: ;
3961:

Line 4008: l_END_DATE OKC_K_HEADERS_B.END_DATE%TYPE;

4004:
4005: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
4006:
4007: l_REVOLVING_CREDIT_YN OKL_K_HEADERS.REVOLVING_CREDIT_YN%TYPE;
4008: l_END_DATE OKC_K_HEADERS_B.END_DATE%TYPE;
4009:
4010: l_DEAL_TYPE OKL_K_HEADERS.DEAL_TYPE%TYPE;
4011: l_creditline_row_found boolean := false;
4012: l_credit_id okc_k_headers_b.id%TYPE;

Line 4012: l_credit_id okc_k_headers_b.id%TYPE;

4008: l_END_DATE OKC_K_HEADERS_B.END_DATE%TYPE;
4009:
4010: l_DEAL_TYPE OKL_K_HEADERS.DEAL_TYPE%TYPE;
4011: l_creditline_row_found boolean := false;
4012: l_credit_id okc_k_headers_b.id%TYPE;
4013:
4014: CURSOR c_contract (p_contract_id NUMBER)
4015: IS
4016: select a.DEAL_TYPE

Line 4026: okc_k_headers_b chr

4022: IS
4023: select khr.REVOLVING_CREDIT_YN,
4024: NVL(chr.END_DATE, SYSDATE)
4025: from okl_k_headers khr,
4026: okc_k_headers_b chr
4027: where khr.id = chr.id
4028: and chr.id = p_credit_id
4029: ;
4030:

Line 4869: l_org_id okc_k_headers_b.AUTHORING_ORG_ID%TYPE;

4865: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
4866: x_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
4867:
4868: l_vendor_id PO_VENDOR_SITES_ALL.vendor_id%TYPE;
4869: l_org_id okc_k_headers_b.AUTHORING_ORG_ID%TYPE;
4870:
4871:
4872: cursor c_vs (p_vendor_site_id number)
4873: is

Line 4881: from okc_k_headers_b chr

4877:
4878: cursor c_org (p_khr_id number)
4879: is
4880: select chr.AUTHORING_ORG_ID
4881: from okc_k_headers_b chr
4882: where chr.id = p_khr_id;
4883:
4884:
4885: BEGIN

Line 5425: FROM okc_k_headers_b chr

5421:
5422:
5423: CURSOR l_org_id_csr(p_chr_id number) IS
5424: SELECT chr.authoring_org_id
5425: FROM okc_k_headers_b chr
5426: WHERE chr.id = p_chr_id;
5427:
5428:
5429:

Line 5434: FROM okc_k_headers_b

5430:
5431: --Added by dpsingh for LE uptake
5432: CURSOR contract_num_csr (p_ctr_id1 NUMBER) IS
5433: SELECT contract_number
5434: FROM okc_k_headers_b
5435: WHERE id = p_ctr_id1;
5436:
5437: l_cntrct_number OKC_K_HEADERS_B.CONTRACT_NUMBER%TYPE;
5438: l_legal_entity_id NUMBER;

Line 5437: l_cntrct_number OKC_K_HEADERS_B.CONTRACT_NUMBER%TYPE;

5433: SELECT contract_number
5434: FROM okc_k_headers_b
5435: WHERE id = p_ctr_id1;
5436:
5437: l_cntrct_number OKC_K_HEADERS_B.CONTRACT_NUMBER%TYPE;
5438: l_legal_entity_id NUMBER;
5439:
5440: BEGIN
5441: -- Set API savepoint

Line 6924: l_currency_code okc_k_headers_b.CURRENCY_CODE%TYPE;

6920: funding_line_id number;
6921:
6922:
6923: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
6924: l_currency_code okc_k_headers_b.CURRENCY_CODE%TYPE;
6925: l_org_id okc_k_headers_b.AUTHORING_ORG_ID%TYPE;
6926: l_contract_number okc_k_headers_b.CONTRACT_NUMBER%TYPE;
6927:
6928: l_amount okl_trx_ap_invoices_b.AMOUNT%TYPE;

Line 6925: l_org_id okc_k_headers_b.AUTHORING_ORG_ID%TYPE;

6921:
6922:
6923: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
6924: l_currency_code okc_k_headers_b.CURRENCY_CODE%TYPE;
6925: l_org_id okc_k_headers_b.AUTHORING_ORG_ID%TYPE;
6926: l_contract_number okc_k_headers_b.CONTRACT_NUMBER%TYPE;
6927:
6928: l_amount okl_trx_ap_invoices_b.AMOUNT%TYPE;
6929:

Line 6926: l_contract_number okc_k_headers_b.CONTRACT_NUMBER%TYPE;

6922:
6923: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
6924: l_currency_code okc_k_headers_b.CURRENCY_CODE%TYPE;
6925: l_org_id okc_k_headers_b.AUTHORING_ORG_ID%TYPE;
6926: l_contract_number okc_k_headers_b.CONTRACT_NUMBER%TYPE;
6927:
6928: l_amount okl_trx_ap_invoices_b.AMOUNT%TYPE;
6929:
6930: l_ipvs_id okl_trx_ap_invoices_b.IPVS_ID%TYPE;

Line 6951: from okc_k_headers_b a

6947: IS
6948: select a.AUTHORING_ORG_ID,
6949: a.CURRENCY_CODE,
6950: a.CONTRACT_NUMBER
6951: from okc_k_headers_b a
6952: where a.id = p_contract_id
6953: ;
6954:
6955: -- sjalasut, modified the below cursor to have p_contract_id joined with

Line 7483: p_khr_id okc_k_headers_b.id%TYPE

7479:
7480: --start:| 08-Feb-08 cklee Fixed bug: 6783566 |
7481: /*
7482: CURSOR c_kle_id(
7483: p_khr_id okc_k_headers_b.id%TYPE
7484: ) IS
7485: SELECT kle.cle_id kle_id,
7486: kle_k.down_payment_receiver_code downpymnt_recvr
7487: FROM okl_assets_lov_uv kle,

Line 7493: p_khr_id okc_k_headers_b.id%TYPE

7489: WHERE kle.cle_id = kle_k.ID
7490: AND kle.chr_id = p_khr_id;
7491: */
7492: CURSOR c_kle_id(
7493: p_khr_id okc_k_headers_b.id%TYPE
7494: ) IS
7495: SELECT kle_k.id kle_id,
7496: kle_k.down_payment_receiver_code downpymnt_recvr
7497: FROM okl_k_lines kle_k,

Line 7884: okc_k_headers_b chr,

7880: IS
7881: SELECT 'X'
7882: FROM okl_trx_ap_invoices_b th,
7883: okl_txl_ap_inv_lns_all_b tl,
7884: okc_k_headers_b chr,
7885: PO_VENDOR_SITES_ALL VS
7886: WHERE th.id = tl.tap_id
7887: AND tl.khr_id = chr.id
7888: AND th.ipvs_id = vs.vendor_site_id

Line 8555: -- 2. contract okc_k_headers_b.ste_code

8551: -- OUT: x_value is the fee amount
8552: -- Business Rules : x_value will be 0 if fee line has not meet the following requirements
8553: -- : 1. Effective date greater than line start date
8554: -- (or contract start date if line start date is null)
8555: -- 2. contract okc_k_headers_b.ste_code
8556: -- in ('ENTERED', 'ACTIVE','SIGNED')
8557: -- 3. fee line is not passthrough
8558: -- 4. fee line is associated with vendor
8559: -- Business Rules :

Line 8660: -- 2. contract okc_k_headers_b.ste_code

8656: -- IN: p_effective_date is the effective date of the total fee amount
8657: -- Business Rules : x_value will be 0 if fee line has not meet the following requirements
8658: -- : 1. Effective date greater than line start date
8659: -- (or contract start date if line start date is null)
8660: -- 2. contract okc_k_headers_b.ste_code
8661: -- in ('ENTERED', 'ACTIVE','SIGNED')
8662: -- 3. fee line is not passthrough
8663: -- 4. fee line is associated with vendor
8664: -- Parameters :

Line 8694: okc_k_headers_b k

8690: nvl(cle.start_date,k.start_date)
8691: from OKL_K_LINES_FULL_V cle,
8692: okc_k_party_roles_b cpl,
8693: okc_line_styles_b ls,
8694: okc_k_headers_b k
8695: where k.id = cle.dnz_chr_id
8696: and cle.dnz_chr_id = p_contract_id
8697: and cle.lse_id = ls.id
8698: and ls.lty_code = p_rle_code

Line 8740: okc_k_headers_b k

8736: , months_between(p_effective_date, nvl(cle.start_date, k.start_date))))
8737: from okc_rule_groups_v crg,
8738: okc_rules_v cr,
8739: OKL_K_LINES_FULL_V cle,
8740: okc_k_headers_b k
8741: where crg.dnz_chr_id = p_contract_id
8742: and cle.dnz_chr_id = k.id
8743: and crg.id = cr.rgp_id
8744: and crg.rgd_code = 'LAFEXP'

Line 9019: ,p_chr_id IN okc_k_headers_b.id%type

9015: ,p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE
9016: ,x_return_status OUT NOCOPY VARCHAR2
9017: ,x_msg_count OUT NOCOPY NUMBER
9018: ,x_msg_data OUT NOCOPY VARCHAR2
9019: ,p_chr_id IN okc_k_headers_b.id%type
9020: ,x_lease_app_found OUT NOCOPY VARCHAR2
9021: ,x_lease_app_list_found OUT NOCOPY VARCHAR2
9022: ,x_funding_checklist_tpl OUT NOCOPY okc_rules_b.rule_information2%TYPE
9023: ,x_lease_app_id OUT NOCOPY NUMBER

Line 9031: l_credit_id okc_k_headers_b.id%TYPE;

9027: l_lease_app_id number := OKC_API.G_MISS_NUM;
9028: l_lease_app_found boolean := FALSE;
9029: l_dummy number;
9030: l_lease_app_list_found boolean := FALSE;
9031: l_credit_id okc_k_headers_b.id%TYPE;
9032: l_funding_checklist_tpl okc_rules_b.rule_information2%TYPE := OKC_API.G_MISS_CHAR;
9033:
9034: --------------------------------------------------------------------------------------------
9035: -- Checklists link check

Line 9048: CURSOR c_lease_app (p_chr_id okc_k_headers_b.id%type)

9044:
9045: ---------------------------------------------------------------------------------------------------------
9046: -- check if the contract was created from a lease application
9047: ---------------------------------------------------------------------------------------------------------
9048: CURSOR c_lease_app (p_chr_id okc_k_headers_b.id%type)
9049: IS
9050: select chr.ORIG_SYSTEM_ID1
9051: from okc_k_headers_b chr
9052: where ORIG_SYSTEM_SOURCE_CODE = G_OKL_LEASE_APP

Line 9051: from okc_k_headers_b chr

9047: ---------------------------------------------------------------------------------------------------------
9048: CURSOR c_lease_app (p_chr_id okc_k_headers_b.id%type)
9049: IS
9050: select chr.ORIG_SYSTEM_ID1
9051: from okc_k_headers_b chr
9052: where ORIG_SYSTEM_SOURCE_CODE = G_OKL_LEASE_APP
9053: and chr.id = p_chr_id
9054: ;
9055:

Line 9465: p_khr_id okc_k_headers_b.id%TYPE

9461:
9462: l_downpymnt_recvr okl_k_lines.down_payment_receiver_code%TYPE;
9463:
9464: CURSOR c_kle_id(
9465: p_khr_id okc_k_headers_b.id%TYPE
9466: ) IS
9467: SELECT kle_k.id kle_id,
9468: kle_k.down_payment_receiver_code downpymnt_recvr
9469: FROM okl_k_lines kle_k,