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 1764: l_sts_code OKC_K_HEADERS_B.sts_code%TYPE;

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

Line 1772: OKC_K_HEADERS_B chr

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

Line 1782: okc_k_headers_b chr

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

Line 2312: okc_k_headers_b k

2308: nvl(cle.start_date,k.start_date)
2309: from OKL_K_LINES_FULL_V cle,
2310: okc_k_party_roles_b cpl,
2311: okc_line_styles_b ls,
2312: okc_k_headers_b k
2313: where k.id = cle.dnz_chr_id
2314: and cle.dnz_chr_id = p_contract_id
2315: and cle.lse_id = ls.id
2316: and ls.lty_code = p_rle_code

Line 2358: okc_k_headers_b k

2354:
2355: from okc_rule_groups_v crg,
2356: okc_rules_v cr,
2357: OKL_K_LINES_FULL_V cle,
2358: okc_k_headers_b k
2359: where crg.dnz_chr_id = p_contract_id
2360: and cle.dnz_chr_id = k.id
2361: and crg.id = cr.rgp_id
2362: and crg.rgd_code = 'LAFEXP'

Line 2550: okc_k_headers_b k

2546: nvl(cle.start_date,k.start_date)
2547: from OKL_K_LINES_FULL_V cle,
2548: okc_k_party_roles_b cpl,
2549: okc_line_styles_b ls,
2550: okc_k_headers_b k
2551: where k.id = cle.dnz_chr_id
2552: and cle.dnz_chr_id = p_contract_id
2553: and cle.lse_id = ls.id
2554: and ls.lty_code = p_rle_code

Line 2595: okc_k_headers_b k

2591: --cklee end 10/3/2007 bug: 6128765
2592: from okc_rule_groups_v crg,
2593: okc_rules_v cr,
2594: OKL_K_LINES_FULL_V cle,
2595: okc_k_headers_b k
2596: where crg.dnz_chr_id = p_contract_id
2597: and cle.dnz_chr_id = k.id
2598: and crg.id = cr.rgp_id
2599: and crg.rgd_code = 'LAFEXP'

Line 2840: l_credit_id okc_k_headers_b.id%TYPE;

2836: l_chklist_sts_row_found boolean;
2837: l_status okl_crd_fund_checklists_tpl_uv.STATUS%TYPE;
2838: l_fund_cls_tpl_exp_found boolean := false;
2839:
2840: l_credit_id okc_k_headers_b.id%TYPE;
2841: -- start: 23-May-2005 cklee okl.h Lease App IA Authoring |
2842: l_lease_app_found boolean := false;
2843: -- end: 23-May-2005 cklee okl.h Lease App IA Authoring |
2844: ---------------------------------------------------------------------------------------------------------

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

2882: ---------------------------------------------------------------------------------------------------------
2883: -- 4. check checklist required items
2884: ---------------------------------------------------------------------------------------------------------
2885:
2886: CURSOR c_chklst (p_chr_id okc_k_headers_b.id%type, p_fund_req_id okl_trx_ap_invoices_b.id%type)
2887: IS
2888: select 1
2889: from okc_rules_b rult
2890: where rult.rule_information_category = G_FUNDING_CHKLST_TPL_RULE1--'LAFCLD'

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

2898: -- start: 23-May-2005 cklee okl.h Lease App IA Authoring |
2899: ---------------------------------------------------------------------------------------------------------
2900: -- 5. check if the contract was created from a lease application
2901: ---------------------------------------------------------------------------------------------------------
2902: CURSOR c_lease_app (p_chr_id okc_k_headers_b.id%type)
2903: IS
2904: --start modified abhsaxen for performance SQLID 20562365
2905: select 1
2906: from okc_k_headers_b chr

Line 2906: from okc_k_headers_b chr

2902: CURSOR c_lease_app (p_chr_id okc_k_headers_b.id%type)
2903: IS
2904: --start modified abhsaxen for performance SQLID 20562365
2905: select 1
2906: from okc_k_headers_b chr
2907: where ORIG_SYSTEM_SOURCE_CODE = G_OKL_LEASE_APP
2908: and chr.id = p_chr_id
2909: ;
2910: --end modified abhsaxen for performance SQLID 20562365

Line 3277: from OKC_K_HEADERS_B a

3273:
3274: CURSOR c_booked (p_contract_id NUMBER)
3275: IS
3276: select count(1)
3277: from OKC_K_HEADERS_B a
3278: where id = p_contract_id
3279: and sts_code = 'BOOKED'
3280: ;
3281:

Line 3825: okc_k_headers_b chr

3821: CURSOR c_sts (p_contract_id NUMBER)
3822: IS
3823: select ste.meaning
3824: from OKC_STATUSES_V ste,
3825: okc_k_headers_b chr
3826: where ste.code = chr.sts_code
3827: and chr.id = p_chr_id
3828: ;
3829:

Line 3875: l_END_DATE OKC_K_HEADERS_B.END_DATE%TYPE;

3871:
3872: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
3873:
3874: l_REVOLVING_CREDIT_YN OKL_K_HEADERS.REVOLVING_CREDIT_YN%TYPE;
3875: l_END_DATE OKC_K_HEADERS_B.END_DATE%TYPE;
3876:
3877: l_DEAL_TYPE OKL_K_HEADERS.DEAL_TYPE%TYPE;
3878: l_creditline_row_found boolean := false;
3879: l_credit_id okc_k_headers_b.id%TYPE;

Line 3879: l_credit_id okc_k_headers_b.id%TYPE;

3875: l_END_DATE OKC_K_HEADERS_B.END_DATE%TYPE;
3876:
3877: l_DEAL_TYPE OKL_K_HEADERS.DEAL_TYPE%TYPE;
3878: l_creditline_row_found boolean := false;
3879: l_credit_id okc_k_headers_b.id%TYPE;
3880:
3881: CURSOR c_contract (p_contract_id NUMBER)
3882: IS
3883: select a.DEAL_TYPE

Line 3893: okc_k_headers_b chr

3889: IS
3890: select khr.REVOLVING_CREDIT_YN,
3891: NVL(chr.END_DATE, SYSDATE)
3892: from okl_k_headers khr,
3893: okc_k_headers_b chr
3894: where khr.id = chr.id
3895: and chr.id = p_credit_id
3896: ;
3897:

Line 4733: l_org_id okc_k_headers_b.AUTHORING_ORG_ID%TYPE;

4729: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
4730: x_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
4731:
4732: l_vendor_id PO_VENDOR_SITES_ALL.vendor_id%TYPE;
4733: l_org_id okc_k_headers_b.AUTHORING_ORG_ID%TYPE;
4734:
4735:
4736: cursor c_vs (p_vendor_site_id number)
4737: is

Line 4745: from okc_k_headers_b chr

4741:
4742: cursor c_org (p_khr_id number)
4743: is
4744: select chr.AUTHORING_ORG_ID
4745: from okc_k_headers_b chr
4746: where chr.id = p_khr_id;
4747:
4748:
4749: BEGIN

Line 5288: FROM okc_k_headers_b chr

5284:
5285:
5286: CURSOR l_org_id_csr(p_chr_id number) IS
5287: SELECT chr.authoring_org_id
5288: FROM okc_k_headers_b chr
5289: WHERE chr.id = p_chr_id;
5290:
5291:
5292:

Line 5297: FROM okc_k_headers_b

5293:
5294: --Added by dpsingh for LE uptake
5295: CURSOR contract_num_csr (p_ctr_id1 NUMBER) IS
5296: SELECT contract_number
5297: FROM okc_k_headers_b
5298: WHERE id = p_ctr_id1;
5299:
5300: l_cntrct_number OKC_K_HEADERS_B.CONTRACT_NUMBER%TYPE;
5301: l_legal_entity_id NUMBER;

Line 5300: l_cntrct_number OKC_K_HEADERS_B.CONTRACT_NUMBER%TYPE;

5296: SELECT contract_number
5297: FROM okc_k_headers_b
5298: WHERE id = p_ctr_id1;
5299:
5300: l_cntrct_number OKC_K_HEADERS_B.CONTRACT_NUMBER%TYPE;
5301: l_legal_entity_id NUMBER;
5302:
5303: BEGIN
5304: -- Set API savepoint

Line 6767: l_currency_code okc_k_headers_b.CURRENCY_CODE%TYPE;

6763: funding_line_id number;
6764:
6765:
6766: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
6767: l_currency_code okc_k_headers_b.CURRENCY_CODE%TYPE;
6768: l_org_id okc_k_headers_b.AUTHORING_ORG_ID%TYPE;
6769: l_contract_number okc_k_headers_b.CONTRACT_NUMBER%TYPE;
6770:
6771: l_amount okl_trx_ap_invoices_b.AMOUNT%TYPE;

Line 6768: l_org_id okc_k_headers_b.AUTHORING_ORG_ID%TYPE;

6764:
6765:
6766: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
6767: l_currency_code okc_k_headers_b.CURRENCY_CODE%TYPE;
6768: l_org_id okc_k_headers_b.AUTHORING_ORG_ID%TYPE;
6769: l_contract_number okc_k_headers_b.CONTRACT_NUMBER%TYPE;
6770:
6771: l_amount okl_trx_ap_invoices_b.AMOUNT%TYPE;
6772:

Line 6769: l_contract_number okc_k_headers_b.CONTRACT_NUMBER%TYPE;

6765:
6766: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
6767: l_currency_code okc_k_headers_b.CURRENCY_CODE%TYPE;
6768: l_org_id okc_k_headers_b.AUTHORING_ORG_ID%TYPE;
6769: l_contract_number okc_k_headers_b.CONTRACT_NUMBER%TYPE;
6770:
6771: l_amount okl_trx_ap_invoices_b.AMOUNT%TYPE;
6772:
6773: l_ipvs_id okl_trx_ap_invoices_b.IPVS_ID%TYPE;

Line 6794: from okc_k_headers_b a

6790: IS
6791: select a.AUTHORING_ORG_ID,
6792: a.CURRENCY_CODE,
6793: a.CONTRACT_NUMBER
6794: from okc_k_headers_b a
6795: where a.id = p_contract_id
6796: ;
6797:
6798: -- sjalasut, modified the below cursor to have p_contract_id joined with

Line 7270: p_khr_id okc_k_headers_b.id%TYPE

7266:
7267: --start:| 08-Feb-08 cklee Fixed bug: 6783566 |
7268: /*
7269: CURSOR c_kle_id(
7270: p_khr_id okc_k_headers_b.id%TYPE
7271: ) IS
7272: SELECT kle.cle_id kle_id,
7273: kle_k.down_payment_receiver_code downpymnt_recvr
7274: FROM okl_assets_lov_uv kle,

Line 7280: p_khr_id okc_k_headers_b.id%TYPE

7276: WHERE kle.cle_id = kle_k.ID
7277: AND kle.chr_id = p_khr_id;
7278: */
7279: CURSOR c_kle_id(
7280: p_khr_id okc_k_headers_b.id%TYPE
7281: ) IS
7282: SELECT kle_k.id kle_id,
7283: kle_k.down_payment_receiver_code downpymnt_recvr
7284: FROM okl_k_lines kle_k,

Line 7667: okc_k_headers_b chr,

7663: IS
7664: SELECT 'X'
7665: FROM okl_trx_ap_invoices_b th,
7666: okl_txl_ap_inv_lns_all_b tl,
7667: okc_k_headers_b chr,
7668: PO_VENDOR_SITES_ALL VS
7669: WHERE th.id = tl.tap_id
7670: AND tl.khr_id = chr.id
7671: AND th.ipvs_id = vs.vendor_site_id

Line 8338: -- 2. contract okc_k_headers_b.ste_code

8334: -- OUT: x_value is the fee amount
8335: -- Business Rules : x_value will be 0 if fee line has not meet the following requirements
8336: -- : 1. Effective date greater than line start date
8337: -- (or contract start date if line start date is null)
8338: -- 2. contract okc_k_headers_b.ste_code
8339: -- in ('ENTERED', 'ACTIVE','SIGNED')
8340: -- 3. fee line is not passthrough
8341: -- 4. fee line is associated with vendor
8342: -- Business Rules :

Line 8443: -- 2. contract okc_k_headers_b.ste_code

8439: -- IN: p_effective_date is the effective date of the total fee amount
8440: -- Business Rules : x_value will be 0 if fee line has not meet the following requirements
8441: -- : 1. Effective date greater than line start date
8442: -- (or contract start date if line start date is null)
8443: -- 2. contract okc_k_headers_b.ste_code
8444: -- in ('ENTERED', 'ACTIVE','SIGNED')
8445: -- 3. fee line is not passthrough
8446: -- 4. fee line is associated with vendor
8447: -- Parameters :

Line 8477: okc_k_headers_b k

8473: nvl(cle.start_date,k.start_date)
8474: from OKL_K_LINES_FULL_V cle,
8475: okc_k_party_roles_b cpl,
8476: okc_line_styles_b ls,
8477: okc_k_headers_b k
8478: where k.id = cle.dnz_chr_id
8479: and cle.dnz_chr_id = p_contract_id
8480: and cle.lse_id = ls.id
8481: and ls.lty_code = p_rle_code

Line 8518: okc_k_headers_b k

8514: , months_between(p_effective_date, nvl(cle.start_date, k.start_date))))
8515: from okc_rule_groups_v crg,
8516: okc_rules_v cr,
8517: OKL_K_LINES_FULL_V cle,
8518: okc_k_headers_b k
8519: where crg.dnz_chr_id = p_contract_id
8520: and cle.dnz_chr_id = k.id
8521: and crg.id = cr.rgp_id
8522: and crg.rgd_code = 'LAFEXP'

Line 8797: ,p_chr_id IN okc_k_headers_b.id%type

8793: ,p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE
8794: ,x_return_status OUT NOCOPY VARCHAR2
8795: ,x_msg_count OUT NOCOPY NUMBER
8796: ,x_msg_data OUT NOCOPY VARCHAR2
8797: ,p_chr_id IN okc_k_headers_b.id%type
8798: ,x_lease_app_found OUT NOCOPY VARCHAR2
8799: ,x_lease_app_list_found OUT NOCOPY VARCHAR2
8800: ,x_funding_checklist_tpl OUT NOCOPY okc_rules_b.rule_information2%TYPE
8801: ,x_lease_app_id OUT NOCOPY NUMBER

Line 8809: l_credit_id okc_k_headers_b.id%TYPE;

8805: l_lease_app_id number := OKC_API.G_MISS_NUM;
8806: l_lease_app_found boolean := FALSE;
8807: l_dummy number;
8808: l_lease_app_list_found boolean := FALSE;
8809: l_credit_id okc_k_headers_b.id%TYPE;
8810: l_funding_checklist_tpl okc_rules_b.rule_information2%TYPE := OKC_API.G_MISS_CHAR;
8811:
8812: --------------------------------------------------------------------------------------------
8813: -- Checklists link check

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

8822:
8823: ---------------------------------------------------------------------------------------------------------
8824: -- check if the contract was created from a lease application
8825: ---------------------------------------------------------------------------------------------------------
8826: CURSOR c_lease_app (p_chr_id okc_k_headers_b.id%type)
8827: IS
8828: select chr.ORIG_SYSTEM_ID1
8829: from okc_k_headers_b chr
8830: where ORIG_SYSTEM_SOURCE_CODE = G_OKL_LEASE_APP

Line 8829: from okc_k_headers_b chr

8825: ---------------------------------------------------------------------------------------------------------
8826: CURSOR c_lease_app (p_chr_id okc_k_headers_b.id%type)
8827: IS
8828: select chr.ORIG_SYSTEM_ID1
8829: from okc_k_headers_b chr
8830: where ORIG_SYSTEM_SOURCE_CODE = G_OKL_LEASE_APP
8831: and chr.id = p_chr_id
8832: ;
8833: