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_CREDIT_PUB dependencies on OKC_RULES_B

Line 690: l_rule_id okc_rules_b.id%type;

686:
687: lp_rulv_rec rulv_rec_type := p_rulv_rec;
688: lx_rulv_rec rulv_rec_type := x_rulv_rec;
689:
690: l_rule_id okc_rules_b.id%type;
691: ldel_rulv_rec rulv_rec_type;
692: lcrt_rulv_rec rulv_rec_type;
693:
694: -- l_dummy number;

Line 696: l_RULE_INFORMATION1 okc_rules_b.RULE_INFORMATION1%type;

692: lcrt_rulv_rec rulv_rec_type;
693:
694: -- l_dummy number;
695: l_row_found boolean := false;
696: l_RULE_INFORMATION1 okc_rules_b.RULE_INFORMATION1%type;
697: l_RULE_INFORMATION2 okc_rules_b.RULE_INFORMATION2%type;
698:
699: l_todo_item_code okl_checklist_details.TODO_ITEM_CODE%type;
700: l_fund_clist_hdr_id okc_rules_b.id%TYPE;

Line 697: l_RULE_INFORMATION2 okc_rules_b.RULE_INFORMATION2%type;

693:
694: -- l_dummy number;
695: l_row_found boolean := false;
696: l_RULE_INFORMATION1 okc_rules_b.RULE_INFORMATION1%type;
697: l_RULE_INFORMATION2 okc_rules_b.RULE_INFORMATION2%type;
698:
699: l_todo_item_code okl_checklist_details.TODO_ITEM_CODE%type;
700: l_fund_clist_hdr_id okc_rules_b.id%TYPE;
701: l_fund_cl_hdr_notfound boolean := false;

Line 700: l_fund_clist_hdr_id okc_rules_b.id%TYPE;

696: l_RULE_INFORMATION1 okc_rules_b.RULE_INFORMATION1%type;
697: l_RULE_INFORMATION2 okc_rules_b.RULE_INFORMATION2%type;
698:
699: l_todo_item_code okl_checklist_details.TODO_ITEM_CODE%type;
700: l_fund_clist_hdr_id okc_rules_b.id%TYPE;
701: l_fund_cl_hdr_notfound boolean := false;
702:
703: --start: 06-May-2005 cklee okl.h Lease App IA Authoring |
704: l_function_id okl_checklist_details_uv.function_id%type;

Line 749: cursor c_del (p_rgp_id okc_rules_b.rgp_id%type,

745:
746: ---------------------------------------------------------
747: -- to do item lists from instance of credit line
748: ---------------------------------------------------------
749: cursor c_del (p_rgp_id okc_rules_b.rgp_id%type,
750: p_rule_category okc_rules_b.RULE_INFORMATION_CATEGORY%type) is
751: select rule.id
752: from okc_rules_b rule
753: where rule.RULE_INFORMATION_CATEGORY = p_rule_category

Line 750: p_rule_category okc_rules_b.RULE_INFORMATION_CATEGORY%type) is

746: ---------------------------------------------------------
747: -- to do item lists from instance of credit line
748: ---------------------------------------------------------
749: cursor c_del (p_rgp_id okc_rules_b.rgp_id%type,
750: p_rule_category okc_rules_b.RULE_INFORMATION_CATEGORY%type) is
751: select rule.id
752: from okc_rules_b rule
753: where rule.RULE_INFORMATION_CATEGORY = p_rule_category
754: and rule.RGP_ID = p_rgp_id

Line 752: from okc_rules_b rule

748: ---------------------------------------------------------
749: cursor c_del (p_rgp_id okc_rules_b.rgp_id%type,
750: p_rule_category okc_rules_b.RULE_INFORMATION_CATEGORY%type) is
751: select rule.id
752: from okc_rules_b rule
753: where rule.RULE_INFORMATION_CATEGORY = p_rule_category
754: and rule.RGP_ID = p_rgp_id
755: ;
756:

Line 760: cursor c_chk (p_rule_id okc_rules_b.id%type) is

756:
757: ---------------------------------------------------------
758: -- existing FK for checklists
759: ---------------------------------------------------------
760: cursor c_chk (p_rule_id okc_rules_b.id%type) is
761: select rule.RULE_INFORMATION1,
762: rule.RULE_INFORMATION2
763: from okc_rules_b rule
764: where rule.id = p_rule_id

Line 763: from okc_rules_b rule

759: ---------------------------------------------------------
760: cursor c_chk (p_rule_id okc_rules_b.id%type) is
761: select rule.RULE_INFORMATION1,
762: rule.RULE_INFORMATION2
763: from okc_rules_b rule
764: where rule.id = p_rule_id
765: ;
766:
767: ---------------------------------------------------------

Line 770: cursor c_chk_tpl_hdr (p_chr_id okc_rules_b.dnz_chr_id%type) is

766:
767: ---------------------------------------------------------
768: -- existing funding request checklist template header
769: ---------------------------------------------------------
770: cursor c_chk_tpl_hdr (p_chr_id okc_rules_b.dnz_chr_id%type) is
771: select hdr.ID
772: from okl_crd_fund_chklst_tpl_hdr_uv hdr
773: where hdr.khr_id = p_chr_id
774: ;

Line 1374: l_credit_checklist_tpl okc_rules_b.rule_information1%TYPE;

1370: l_expired_row_found boolean;
1371: l_chklist_sts_row_found boolean;
1372: l_chklist_hdr_row_notfound boolean;
1373:
1374: l_credit_checklist_tpl okc_rules_b.rule_information1%TYPE;
1375: l_funding_checklist_tpl okc_rules_b.rule_information2%TYPE;
1376: l_checklists_row_found boolean;
1377:
1378: l_dummy number;

Line 1375: l_funding_checklist_tpl okc_rules_b.rule_information2%TYPE;

1371: l_chklist_sts_row_found boolean;
1372: l_chklist_hdr_row_notfound boolean;
1373:
1374: l_credit_checklist_tpl okc_rules_b.rule_information1%TYPE;
1375: l_funding_checklist_tpl okc_rules_b.rule_information2%TYPE;
1376: l_checklists_row_found boolean;
1377:
1378: l_dummy number;
1379:

Line 1402: from OKC_RULES_B RULT

1398: CURSOR c_chklst_sts (p_chr_id okc_k_headers_b.id%type)
1399: IS
1400: --start modified abhsaxen for performance SQLID 20562641
1401: select 1
1402: from OKC_RULES_B RULT
1403: where rult.DNZ_CHR_ID = p_chr_id and
1404: nvl(rult.RULE_INFORMATION5, 'NEW') <> 'ACTIVE'and
1405: rult.rule_information_category = 'LACCLD'
1406: --end modified abhsaxen for performance SQLID 20562641

Line 1428: from okc_rules_b rult

1424: --------------------------------------------------------------------------------------------
1425: CURSOR c_chklst (p_chr_id okc_k_headers_b.id%type)
1426: IS
1427: select 1
1428: from okc_rules_b rult
1429: where rult.rule_information_category = G_CREDIT_CHKLST_TPL_RULE2--'LACCLD'
1430: and rult.dnz_chr_id = p_chr_id
1431: and rult.RULE_INFORMATION2 = 'Y'
1432: and (rult.RULE_INFORMATION3 <> 'Y' or rult.RULE_INFORMATION3 is null)

Line 1453: from okc_rules_b rule

1449: CURSOR c_checklists (p_chr_id NUMBER)
1450: IS
1451: select rule.rule_information1,
1452: rule.rule_information2
1453: from okc_rules_b rule
1454: where rule.dnz_chr_id = p_chr_id
1455: and rule.rule_information_category = G_CREDIT_CHKLST_TPL_RULE1
1456: ;
1457:

Line 2540: l_credit_checklist_tpl okc_rules_b.rule_information1%TYPE;

2536: l_dummy VARCHAR2(1) := OKL_API.G_TRUE;
2537: l_dirty_row_found boolean;
2538: l_active_row_found boolean;
2539:
2540: l_credit_checklist_tpl okc_rules_b.rule_information1%TYPE;
2541: l_funding_checklist_tpl okc_rules_b.rule_information2%TYPE;
2542: l_checklists_row_found boolean;
2543:
2544: --------------------------------------------------------------------------------------------

Line 2541: l_funding_checklist_tpl okc_rules_b.rule_information2%TYPE;

2537: l_dirty_row_found boolean;
2538: l_active_row_found boolean;
2539:
2540: l_credit_checklist_tpl okc_rules_b.rule_information1%TYPE;
2541: l_funding_checklist_tpl okc_rules_b.rule_information2%TYPE;
2542: l_checklists_row_found boolean;
2543:
2544: --------------------------------------------------------------------------------------------
2545: -- Checklists link check

Line 2551: from okc_rules_b rule

2547: CURSOR c_checklists (p_chr_id NUMBER)
2548: IS
2549: select rule.rule_information1,
2550: rule.rule_information2
2551: from okc_rules_b rule
2552: where rule.dnz_chr_id = p_chr_id
2553: and rule.rule_information_category = G_CREDIT_CHKLST_TPL_RULE1
2554: ;
2555:

Line 2563: from okc_rules_b rult

2559: CURSOR c_checklist_active (p_chr_id okc_k_headers_b.id%type,
2560: p_crd_chklst_id varchar2)
2561: IS
2562: select 1
2563: from okc_rules_b rult
2564: where rult.rule_information_category = G_CREDIT_CHKLST_TPL_RULE2--'LACCLD'
2565: and rult.dnz_chr_id = p_chr_id
2566: and rult.RULE_INFORMATION5 = 'ACTIVE'
2567: and exists (select null

Line 2568: from okc_rules_b rult1

2564: where rult.rule_information_category = G_CREDIT_CHKLST_TPL_RULE2--'LACCLD'
2565: and rult.dnz_chr_id = p_chr_id
2566: and rult.RULE_INFORMATION5 = 'ACTIVE'
2567: and exists (select null
2568: from okc_rules_b rult1
2569: where rult1.dnz_chr_id = rult.dnz_chr_id
2570: and rult1.dnz_chr_id = p_chr_id -- impove performance
2571: and rult1.rule_information_category = G_CREDIT_CHKLST_TPL_RULE1--'LACCLT'
2572: and rult1.RULE_INFORMATION1 <> p_crd_chklst_id) -- id changes

Line 2582: from okc_rules_b rult

2578: CURSOR c_approver_dirty (p_chr_id okc_k_headers_b.id%type,
2579: p_crd_chklst_id varchar2)
2580: IS
2581: select 1
2582: from okc_rules_b rult
2583: where rult.rule_information_category = G_CREDIT_CHKLST_TPL_RULE2--'LACCLD'
2584: and rult.dnz_chr_id = p_chr_id
2585: and rult.RULE_INFORMATION2 = 'Y' -- dirty bit check
2586: and exists (select null

Line 2592: from okc_rules_b rult1

2588: where khr.id = rult.dnz_chr_id
2589: and khr.id = p_chr_id -- impove performance
2590: and khr.sts_code = 'NEW')
2591: and exists (select null
2592: from okc_rules_b rult1
2593: where rult1.dnz_chr_id = rult.dnz_chr_id
2594: and rult1.dnz_chr_id = p_chr_id -- impove performance
2595: and rult1.rule_information_category = G_CREDIT_CHKLST_TPL_RULE1--'LACCLT'
2596: and rult1.RULE_INFORMATION1 <> p_crd_chklst_id) -- id changes

Line 2673: l_credit_checklist_tpl okc_rules_b.rule_information1%TYPE;

2669:
2670: l_dirty_row_found boolean;
2671: l_active_row_found boolean;
2672:
2673: l_credit_checklist_tpl okc_rules_b.rule_information1%TYPE;
2674:
2675: l_funding_checklist_tpl okc_rules_b.rule_information2%TYPE;
2676: l_checklists_row_found boolean;
2677:

Line 2675: l_funding_checklist_tpl okc_rules_b.rule_information2%TYPE;

2671: l_active_row_found boolean;
2672:
2673: l_credit_checklist_tpl okc_rules_b.rule_information1%TYPE;
2674:
2675: l_funding_checklist_tpl okc_rules_b.rule_information2%TYPE;
2676: l_checklists_row_found boolean;
2677:
2678: --------------------------------------------------------------------------------------------
2679: -- Checklists link check

Line 2685: from okc_rules_b rule

2681: CURSOR c_checklists (p_chr_id NUMBER)
2682: IS
2683: select rule.rule_information1,
2684: rule.rule_information2
2685: from okc_rules_b rule
2686: where rule.dnz_chr_id = p_chr_id
2687: and rule.rule_information_category = G_CREDIT_CHKLST_TPL_RULE1
2688: ;
2689:

Line 2697: from okc_rules_b rult

2693: CURSOR c_checklist_active (p_chr_id okc_k_headers_b.id%type,
2694: p_fund_chklst_id varchar2)
2695: IS
2696: select 1
2697: from okc_rules_b rult
2698: where rult.rule_information_category = G_CREDIT_CHKLST_TPL_RULE4--'LACLFM'
2699: and rult.dnz_chr_id = p_chr_id
2700: and rult.RULE_INFORMATION3 = 'ACTIVE'
2701: and exists (select null

Line 2702: from okc_rules_b rult1

2698: where rult.rule_information_category = G_CREDIT_CHKLST_TPL_RULE4--'LACLFM'
2699: and rult.dnz_chr_id = p_chr_id
2700: and rult.RULE_INFORMATION3 = 'ACTIVE'
2701: and exists (select null
2702: from okc_rules_b rult1
2703: where rult1.dnz_chr_id = rult.dnz_chr_id
2704: and rult1.dnz_chr_id = p_chr_id -- impove performance
2705: and rult1.rule_information_category = G_CREDIT_CHKLST_TPL_RULE1--'LACCLT'
2706: and rult1.RULE_INFORMATION2 <> p_fund_chklst_id) -- id changes

Line 2716: from okc_rules_b rult

2712: CURSOR c_approver_dirty (p_chr_id okc_k_headers_b.id%type,
2713: p_fund_chklst_id varchar2)
2714: IS
2715: select 1
2716: from okc_rules_b rult
2717: where rult.rule_information_category = G_CREDIT_CHKLST_TPL_RULE3--'LACLFD'
2718: and rult.dnz_chr_id = p_chr_id
2719: and rult.RULE_INFORMATION2 = 'Y' -- dirty bit check
2720: and exists (select null

Line 2726: from okc_rules_b rult1

2722: where khr.id = rult.dnz_chr_id
2723: and khr.id = p_chr_id -- impove performance
2724: and khr.sts_code = 'NEW')
2725: and exists (select null
2726: from okc_rules_b rult1
2727: where rult1.dnz_chr_id = rult.dnz_chr_id
2728: and rult1.dnz_chr_id = p_chr_id -- impove performance
2729: and rult1.rule_information_category = G_CREDIT_CHKLST_TPL_RULE1--'LACCLT'
2730: and rult1.RULE_INFORMATION2 <> p_fund_chklst_id) -- id changes

Line 5002: OKC_RULES_B RUL,

4998: OKC_K_HEADERS_B CHRB,
4999: OKC_K_HEADERS_TL CHRT,
5000: OKL_K_HEADERS KHR,
5001: HZ_CUST_ACCOUNTS CA,
5002: OKC_RULES_B RUL,
5003: OKX_PARTIES_V PARTY,
5004: OKC_K_PARTY_ROLES_B CPL
5005: WHERE chrb.id = chrt.id
5006: AND chrt.language = USERENV('LANG')

Line 5844: from okc_rules_b rule

5840: CURSOR c_fk (p_chr_id NUMBER)
5841: IS
5842: select DECODE(p_attr, 'RULE_INFORMATION1', to_number(rule.rule_information1),
5843: 'RULE_INFORMATION2', to_number(rule.rule_information2))
5844: from okc_rules_b rule
5845: where rule.dnz_chr_id = p_chr_id
5846: and rule.rule_information_category = G_CREDIT_CHKLST_TPL_RULE1
5847: ;
5848:

Line 5917: l_rgp_id okc_rules_b.rgp_id%type;

5913: p_chr_id IN NUMBER
5914: ,p_attr IN VARCHAR2
5915: ) RETURN VARCHAR2
5916: is
5917: l_rgp_id okc_rules_b.rgp_id%type;
5918: l_id okc_rules_b.id%type;
5919: l_rule_information1 okc_rules_b.rule_information1%type;
5920: l_rule_information2 okc_rules_b.rule_information2%type;
5921:

Line 5918: l_id okc_rules_b.id%type;

5914: ,p_attr IN VARCHAR2
5915: ) RETURN VARCHAR2
5916: is
5917: l_rgp_id okc_rules_b.rgp_id%type;
5918: l_id okc_rules_b.id%type;
5919: l_rule_information1 okc_rules_b.rule_information1%type;
5920: l_rule_information2 okc_rules_b.rule_information2%type;
5921:
5922:

Line 5919: l_rule_information1 okc_rules_b.rule_information1%type;

5915: ) RETURN VARCHAR2
5916: is
5917: l_rgp_id okc_rules_b.rgp_id%type;
5918: l_id okc_rules_b.id%type;
5919: l_rule_information1 okc_rules_b.rule_information1%type;
5920: l_rule_information2 okc_rules_b.rule_information2%type;
5921:
5922:
5923: CURSOR c (p_chr_id NUMBER)

Line 5920: l_rule_information2 okc_rules_b.rule_information2%type;

5916: is
5917: l_rgp_id okc_rules_b.rgp_id%type;
5918: l_id okc_rules_b.id%type;
5919: l_rule_information1 okc_rules_b.rule_information1%type;
5920: l_rule_information2 okc_rules_b.rule_information2%type;
5921:
5922:
5923: CURSOR c (p_chr_id NUMBER)
5924: IS

Line 5929: from okc_rules_b rule

5925: select rule.id,
5926: rule.rgp_id,
5927: rule.rule_information1,
5928: rule.rule_information2
5929: from okc_rules_b rule
5930: where rule.dnz_chr_id = p_chr_id
5931: and rule.rule_information_category = G_CREDIT_CHKLST_TPL_RULE1
5932: ;
5933:

Line 6213: FROM OKC_RULES_B RULT,

6209: --start modified abhsaxen for performance SQLID 20562912
6210: SELECT
6211: rult.ID,
6212: fun.source function_source
6213: FROM OKC_RULES_B RULT,
6214: OKL_DATA_SRC_FNCTNS_b FUN
6215: WHERE rult.rule_information_category = 'LACCLD' and
6216: rult.RULE_INFORMATION9 = fun.ID and
6217: rult.DNZ_CHR_ID = p_contract_id

Line 6415: OKC_RULES_B RUL,

6411: OKC_K_HEADERS_B CHRB,
6412: OKC_K_HEADERS_TL CHRT,
6413: OKL_K_HEADERS KHR,
6414: HZ_CUST_ACCOUNTS CA,
6415: OKC_RULES_B RUL,
6416: OKX_PARTIES_V PARTY,
6417: OKC_K_PARTY_ROLES_B CPL
6418: WHERE chrb.id = chrt.id
6419: AND chrt.language = USERENV('LANG')