DBA Data[Home] [Help]

APPS.OKL_FUNDING_PVT dependencies on OKC_RULES_B

Line 518: l_funding_checklist_tpl okc_rules_b.rule_information2%TYPE;

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 |
521: l_function_id okl_crd_fund_checklists_tpl_uv.function_id%type;
522: l_checklist_type okl_crd_fund_checklists_tpl_uv.checklist_type%type;

Line 533: from okc_rules_b rule

529: --------------------------------------------------------------------------------------------
530: CURSOR c_checklists (p_credit_id NUMBER)
531: IS
532: select rule.rule_information2
533: from okc_rules_b rule
534: where rule.dnz_chr_id = p_credit_id
535: and rule.rule_information_category = G_CREDIT_CHKLST_TPL_RULE1
536: ;
537:

Line 878: l_rule_id okc_rules_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;
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

Line 922: FROM okc_rules_b rult

918: --5. Delete all associated list by chr_id if any
919: cursor c_fund_req_list(p_chr_id NUMBER) is
920: --start modified abhsaxen for performance SQLID 20562295
921: SELECT rult.ID
922: FROM okc_rules_b rult
923: WHERE rult.rule_information_category = 'LAFCLD'
924: and rult.dnz_chr_id = p_chr_id
925: ;
926: --end modified abhsaxen for performance SQLID 20562295

Line 1225: l_inv_acct_code OKC_RULES_B.Rule_Information1%TYPE;

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:
1228: l_cust_acct_site_id NUMBER;
1229:

Line 1252: -- l_inv_acct_code okc_rules_b.RULE_INFORMATION1%TYPE;

1248: l_acc_gen_primary_key_tbl Okl_Account_Dist_Pvt.ACC_GEN_TBL_TYPE;
1249: l_template_tbl Okl_Account_Dist_Pvt.AVLV_OUT_TBL_TYPE;
1250: l_amount_tbl Okl_Account_Dist_Pvt.AMOUNT_OUT_TBL_TYPE;
1251: -- l_fact_synd_code fnd_lookups.lookup_code%TYPE;
1252: -- l_inv_acct_code okc_rules_b.RULE_INFORMATION1%TYPE;
1253:
1254: --end:| 21-May-2007 cklee OKLR12B Accounting CR |
1255:
1256: -- sjalasut, modified the below cursor to have khr_id being selected

Line 1340: from okc_rules_b rul

1336: --AR_SITE_USES_V
1337: /*
1338: Cursor ar_site_uses_csr( p_chr_id NUMBER) IS
1339: select object1_id1 cust_acct_site_id
1340: from okc_rules_b rul
1341: where rul.rule_information_category = 'BTO'
1342: and exists (select '1'
1343: from okc_rule_groups_b rgp
1344: where rgp.id = rul.rgp_id

Line 2892: okc_rules_b rul, okc_rule_groups_b rgp

2888: IS
2889:
2890:
2891: SELECT nvl(rul.rule_information1, 'N') FROM
2892: okc_rules_b rul, okc_rule_groups_b rgp
2893: WHERE rul.rule_information_category='LARLES'
2894: AND rgp.id = rul.rgp_id
2895: AND rgp.rgd_code = 'LARLES'
2896: AND rgp.dnz_chr_id= p_contract_id;

Line 2916: l_release_flag okc_rules_b.rule_information1%type;

2912:
2913: --Bug# 15992711 End Modification
2914:
2915: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
2916: l_release_flag okc_rules_b.rule_information1%type;
2917:
2918:
2919: BEGIN
2920:

Line 3019: from okc_rules_b rult

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'
3021: and rult.dnz_chr_id = p_chr_id
3022: and rult.object1_id1 = p_fund_req_id
3023: and rult.object1_id2 = '#'

Line 5698: FROM OKC_RULES_B RULT

5694:
5695: cursor c_chklst_exists(p_fund_id varchar2) is
5696: --start modified abhsaxen for performance SQLID 20562448
5697: SELECT 1
5698: FROM OKC_RULES_B RULT
5699: WHERE rult.rule_information_category = 'LAFCLD'
5700: and rult.OBJECT1_ID1 = p_fund_id ;
5701: --end modified abhsaxen for performance SQLID 20562448
5702:

Line 9022: ,x_funding_checklist_tpl OUT NOCOPY okc_rules_b.rule_information2%TYPE

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
9024: ,x_credit_id OUT NOCOPY NUMBER
9025: ) IS
9026:

Line 9032: l_funding_checklist_tpl okc_rules_b.rule_information2%TYPE := OKC_API.G_MISS_CHAR;

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
9036: --------------------------------------------------------------------------------------------

Line 9040: from okc_rules_b rule

9036: --------------------------------------------------------------------------------------------
9037: CURSOR c_checklists (p_credit_id NUMBER)
9038: IS
9039: select rule.rule_information2
9040: from okc_rules_b rule
9041: where rule.dnz_chr_id = p_credit_id
9042: and rule.rule_information_category = G_CREDIT_CHKLST_TPL_RULE1
9043: ;
9044:

Line 9162: FROM OKC_RULES_B RULT,

9158: cursor c_clist_funs (p_fund_req_id varchar2) is
9159: --start modified abhsaxen for performance SQLID 20562504
9160: SELECT rult.ID, rult.DNZ_CHR_ID khr_id,
9161: fun.source function_source
9162: FROM OKC_RULES_B RULT,
9163: OKL_DATA_SRC_FNCTNS_B FUN
9164: WHERE rult.rule_information_category = 'LAFCLD'
9165: and rult.object1_id1 = p_fund_req_id
9166: and rult.RULE_INFORMATION9 = fun.Id ;