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_K_HEADERS_B

Line 1387: CURSOR c_chklst_header(p_chr_id okc_k_headers_b.id%type)

1383: --------------------------------------------------------------------------------------------
1384: --1 This is used for existing credit line and user try to activate credit line w/o activate
1385: -- checklists
1386: --------------------------------------------------------------------------------------------
1387: CURSOR c_chklst_header(p_chr_id okc_k_headers_b.id%type)
1388: IS
1389: select 1
1390: from okc_rule_groups_b rgp
1391: where rgp.dnz_chr_id = p_chr_id

Line 1398: CURSOR c_chklst_sts (p_chr_id okc_k_headers_b.id%type)

1394:
1395: --------------------------------------------------------------------------------------------
1396: --2. Credit line checklist must activated before activate credit line
1397: --------------------------------------------------------------------------------------------
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

Line 1414: CURSOR c_fund_chklst_sts (p_chr_id okc_k_headers_b.id%type)

1410: --------------------------------------------------------------------------------------------
1411: --------------------------------------------------------------------------------------------
1412: --3.2 Funding request checklist template must not expired before activate credit line
1413: --------------------------------------------------------------------------------------------
1414: CURSOR c_fund_chklst_sts (p_chr_id okc_k_headers_b.id%type)
1415: IS
1416: select chk.status,
1417: chk.effective_to
1418: from okl_crd_fund_chklst_tpl_hdr_uv chk

Line 1425: CURSOR c_chklst (p_chr_id okc_k_headers_b.id%type)

1421:
1422: --------------------------------------------------------------------------------------------
1423: --4. Credit line checklist has not met requirement before activate credit line
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'

Line 1438: CURSOR c_active (p_chr_id okc_k_headers_b.id%type)

1434:
1435: --------------------------------------------------------------------------------------------
1436: -- credit line status
1437: --------------------------------------------------------------------------------------------
1438: CURSOR c_active (p_chr_id okc_k_headers_b.id%type)
1439: IS
1440: select 1
1441: from okc_k_headers_b k
1442: where k.id = p_chr_id

Line 1441: from okc_k_headers_b k

1437: --------------------------------------------------------------------------------------------
1438: CURSOR c_active (p_chr_id okc_k_headers_b.id%type)
1439: IS
1440: select 1
1441: from okc_k_headers_b k
1442: where k.id = p_chr_id
1443: and k.sts_code = 'ACTIVE'
1444: ;
1445:

Line 1667: FROM okc_k_headers_b chr,

1663: -- line start date < header start date
1664: CURSOR c_date_check1 (p_chr_id NUMBER)
1665: IS
1666: SELECT 1
1667: FROM okc_k_headers_b chr,
1668: okc_k_lines_b cln
1669: WHERE chr.id = cln.dnz_chr_id
1670: AND chr.start_date IS NOT NULL
1671: AND trunc(cln.start_date) < trunc(chr.start_date)

Line 1679: FROM okc_k_headers_b chr,

1675: -- line start date > header end date
1676: CURSOR c_date_check2 (p_chr_id NUMBER)
1677: IS
1678: SELECT 1
1679: FROM okc_k_headers_b chr,
1680: okc_k_lines_b cln
1681: WHERE chr.id = cln.dnz_chr_id
1682: AND chr.end_date IS NOT NULL
1683: AND trunc(cln.start_date) > trunc(chr.end_date)

Line 1980: FROM okc_k_headers_b k

1976: CURSOR c (p_chr_id NUMBER)
1977: IS
1978: SELECT k.start_date,
1979: k.end_date
1980: FROM okc_k_headers_b k
1981: WHERE k.id = p_chr_id
1982: ;
1983:
1984: BEGIN

Line 2108: FROM okc_k_headers_b k

2104:
2105: CURSOR c (p_credit_number VARCHAR2)
2106: IS
2107: SELECT 'X'
2108: FROM okc_k_headers_b k
2109: WHERE k.contract_number = p_credit_number
2110: -- bug fixed for creditline contarct sub-class
2111: -- and k.scs_code = 'CREDITLINE_CONTRACT'
2112: ;

Line 2118: FROM okc_k_headers_b k

2114:
2115: CURSOR c2 (p_credit_number VARCHAR2, p_id NUMBER)
2116: IS
2117: SELECT 'X'
2118: FROM okc_k_headers_b k
2119: WHERE k.contract_number = p_credit_number
2120: AND k.id <> p_id -- except itself
2121: ;
2122:

Line 2341: FROM okc_k_headers_b k

2337:
2338: CURSOR c (p_chr_id NUMBER)
2339: IS
2340: SELECT k.start_date
2341: FROM okc_k_headers_b k
2342: WHERE k.id = p_chr_id
2343: ;
2344:
2345: BEGIN

Line 2463: l_currency_code okc_k_headers_b.currency_code%TYPE;

2459: ) RETURN VARCHAR2
2460: IS
2461: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
2462: l_dummy VARCHAR2(1) := OKL_API.G_TRUE;
2463: l_currency_code okc_k_headers_b.currency_code%TYPE;
2464: l_amount OKL_K_LINES_FULL_V.AMOUNT%type;
2465:
2466: cursor c_old_curr
2467: is

Line 2469: from okc_k_headers_b khr

2465:
2466: cursor c_old_curr
2467: is
2468: select khr.currency_code
2469: from okc_k_headers_b khr
2470: where khr.id = p_chrv_rec.id
2471: ;
2472:
2473: CURSOR c_limit_amt

Line 2559: CURSOR c_checklist_active (p_chr_id okc_k_headers_b.id%type,

2555:
2556: --------------------------------------------------------------------
2557: --1. read only if credit line checklist status is active
2558: --------------------------------------------------------------------
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

Line 2578: CURSOR c_approver_dirty (p_chr_id okc_k_headers_b.id%type,

2574:
2575: --------------------------------------------------------------------
2576: --2. read only if credit line checklist have been touch by approver
2577: --------------------------------------------------------------------
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

Line 2587: from okc_k_headers_b khr

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
2587: from okc_k_headers_b khr
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

Line 2693: CURSOR c_checklist_active (p_chr_id okc_k_headers_b.id%type,

2689:
2690: --------------------------------------------------------------------
2691: --1. read only if funding requrest checklist template status is active
2692: --------------------------------------------------------------------
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

Line 2712: CURSOR c_approver_dirty (p_chr_id okc_k_headers_b.id%type,

2708:
2709: --------------------------------------------------------------------
2710: --2. read only if funding requrest checklist template have been touch by approver
2711: --------------------------------------------------------------------
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

Line 2721: from okc_k_headers_b khr

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
2721: from okc_k_headers_b khr
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

Line 3220: l_sts_code OKC_K_HEADERS_B.STS_CODE%TYPE;

3216: l_khrv_rec OKL_CONTRACT_PUB.khrv_rec_type;
3217:
3218: lp_cplv_rec OKC_CONTRACT_PARTY_PUB.cplv_rec_type;
3219:
3220: l_sts_code OKC_K_HEADERS_B.STS_CODE%TYPE;
3221:
3222:
3223: -- funding checklist enhancement for 11.5.9
3224: lp_rulv_rec rulv_rec_type;

Line 3230: from okc_k_headers_b

3226: -- funding checklist enhancement for 11.5.9
3227:
3228: Cursor c_sts_code (p_chr_id NUMBER) is
3229: select sts_code
3230: from okc_k_headers_b
3231: where id = p_chr_id
3232: ;
3233:
3234: BEGIN

Line 3867: CURSOR c_old_sts_code(p_chr_id okc_k_headers_b.id%TYPE) IS

3863: x_khrv_rec OUT NOCOPY khrv_rec_type)
3864: is
3865:
3866: -- vthiruva Code change to enable Business Event START
3867: CURSOR c_old_sts_code(p_chr_id okc_k_headers_b.id%TYPE) IS
3868: SELECT sts_code
3869: FROM okc_k_headers_b
3870: WHERE id = p_chr_id;
3871:

Line 3869: FROM okc_k_headers_b

3865:
3866: -- vthiruva Code change to enable Business Event START
3867: CURSOR c_old_sts_code(p_chr_id okc_k_headers_b.id%TYPE) IS
3868: SELECT sts_code
3869: FROM okc_k_headers_b
3870: WHERE id = p_chr_id;
3871:
3872: l_old_status okc_k_headers_b.sts_code%TYPE;
3873: -- vthiruva Code change to enable Business Event END

Line 3872: l_old_status okc_k_headers_b.sts_code%TYPE;

3868: SELECT sts_code
3869: FROM okc_k_headers_b
3870: WHERE id = p_chr_id;
3871:
3872: l_old_status okc_k_headers_b.sts_code%TYPE;
3873: -- vthiruva Code change to enable Business Event END
3874:
3875: l_api_name CONSTANT VARCHAR2(30) := 'update_credit_header_pub';
3876: l_api_version CONSTANT NUMBER := 1.0;

Line 3895: from OKC_K_HEADERS_B CHRB

3891: l_cust_acct_id number;
3892:
3893: cursor l_cust_acct(p_chr_id number) is
3894: select chrb.cust_acct_id cust_acct_id
3895: from OKC_K_HEADERS_B CHRB
3896: where CHRB.id = p_chr_id;
3897:
3898: -- end: bug#4218700
3899:

Line 4998: OKC_K_HEADERS_B CHRB,

4994: rul.rgp_id chklst_tpl_rgp_id,
4995: rul.id chklst_tpl_rule_id,
4996: CA.ACCOUNT_NUMBER cust_acct_number
4997: FROM
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,

Line 5981: l_credit_id okc_k_headers_b.id%TYPE := NULL;

5977: FUNCTION get_creditline_by_chrid(
5978: p_contract_id IN NUMBER -- contract hdr
5979: ) RETURN NUMBER
5980: IS
5981: l_credit_id okc_k_headers_b.id%TYPE := NULL;
5982: l_row_not_found boolean := false;
5983:
5984: CURSOR c_credit (p_contract_id NUMBER)
5985: IS

Line 5987: from OKC_K_HEADERS_B a,

5983:
5984: CURSOR c_credit (p_contract_id NUMBER)
5985: IS
5986: select a.ID
5987: from OKC_K_HEADERS_B a,
5988: okc_Governances_v g
5989: where a.id = g.chr_id_referred
5990: and a.sts_code = 'ACTIVE'
5991: and g.dnz_chr_id = p_contract_id

Line 5998: from OKC_K_HEADERS_B a,

5994: --cklee, fixed bug# 3149922
5995: CURSOR c_MLA_credit (p_contract_id NUMBER)
5996: IS
5997: select a.ID
5998: from OKC_K_HEADERS_B a,
5999: okc_Governances_v g
6000: where a.id = g.chr_id_referred
6001: and a.sts_code = 'ACTIVE'
6002: and a.scs_code = 'CREDITLINE_CONTRACT'

Line 6004: from OKC_K_HEADERS_B a1,

6000: where a.id = g.chr_id_referred
6001: and a.sts_code = 'ACTIVE'
6002: and a.scs_code = 'CREDITLINE_CONTRACT'
6003: and g.dnz_chr_id = (select a1.ID -- MLA chrid
6004: from OKC_K_HEADERS_B a1,
6005: okc_Governances_v g1
6006: where a1.id = g1.chr_id_referred
6007: and g1.dnz_chr_id = p_contract_id
6008: and a1.scs_code = 'MASTER_LEASE')

Line 6411: OKC_K_HEADERS_B CHRB,

6407: rul.rgp_id chklst_tpl_rgp_id,
6408: rul.id chklst_tpl_rule_id,
6409: CA.ACCOUNT_NUMBER cust_acct_number
6410: FROM
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,