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 2779: okc_rules_b rul, okc_rule_groups_b rgp

2775:
2776: CURSOR c_release_k_flag(p_contract_id NUMBER)
2777: IS
2778: SELECT nvl(rul.rule_information1, 'N') FROM
2779: okc_rules_b rul, okc_rule_groups_b rgp
2780: WHERE rul.rule_information_category='LARLES'
2781: AND rgp.id = rul.rgp_id
2782: AND rgp.rgd_code = 'LARLES'
2783: AND rgp.dnz_chr_id= p_contract_id;

Line 2786: l_release_flag okc_rules_b.rule_information1%type;

2782: AND rgp.rgd_code = 'LARLES'
2783: AND rgp.dnz_chr_id= p_contract_id;
2784:
2785: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
2786: l_release_flag okc_rules_b.rule_information1%type;
2787:
2788:
2789: BEGIN
2790:

Line 2889: from okc_rules_b rult

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'
2891: and rult.dnz_chr_id = p_chr_id
2892: and rult.object1_id1 = p_fund_req_id
2893: and rult.object1_id2 = '#'

Line 5561: FROM OKC_RULES_B RULT

5557:
5558: cursor c_chklst_exists(p_fund_id varchar2) is
5559: --start modified abhsaxen for performance SQLID 20562448
5560: SELECT 1
5561: FROM OKC_RULES_B RULT
5562: WHERE rult.rule_information_category = 'LAFCLD'
5563: and rult.OBJECT1_ID1 = p_fund_id ;
5564: --end modified abhsaxen for performance SQLID 20562448
5565:

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

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
8802: ,x_credit_id OUT NOCOPY NUMBER
8803: ) IS
8804:

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

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

Line 8818: from okc_rules_b rule

8814: --------------------------------------------------------------------------------------------
8815: CURSOR c_checklists (p_credit_id NUMBER)
8816: IS
8817: select rule.rule_information2
8818: from okc_rules_b rule
8819: where rule.dnz_chr_id = p_credit_id
8820: and rule.rule_information_category = G_CREDIT_CHKLST_TPL_RULE1
8821: ;
8822:

Line 8940: FROM OKC_RULES_B RULT,

8936: cursor c_clist_funs (p_fund_req_id varchar2) is
8937: --start modified abhsaxen for performance SQLID 20562504
8938: SELECT rult.ID, rult.DNZ_CHR_ID khr_id,
8939: fun.source function_source
8940: FROM OKC_RULES_B RULT,
8941: OKL_DATA_SRC_FNCTNS_B FUN
8942: WHERE rult.rule_information_category = 'LAFCLD'
8943: and rult.object1_id1 = p_fund_req_id
8944: and rult.RULE_INFORMATION9 = fun.Id ;