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_CONTRACT_PVT dependencies on OKC_K_HEADERS_B

Line 130: l_chr_id okc_k_headers_b.id%TYPE;

126: x_msg_data OUT NOCOPY VARCHAR2,
127: p_event_name IN wf_events.name%TYPE,
128: p_parameter_list IN wf_parameter_list_t) IS
129:
130: l_chr_id okc_k_headers_b.id%TYPE;
131: l_contract_process VARCHAR2(30);
132: l_parameter_list WF_PARAMETER_LIST_T := p_parameter_list;
133:
134: BEGIN

Line 261: FROM okc_k_headers_b chr,

257:
258: --Cursor to check if the contract is booked
259: Cursor Chr_sts_crs(p_cle_id IN Number) IS
260: SELECT chr.sts_code
261: FROM okc_k_headers_b chr,
262: okc_k_lines_b cle
263: WHERE chr.ID = cle.dnz_chr_id
264: AND cle.ID = p_cle_id;
265:

Line 266: l_sts_code OKC_K_HEADERS_B.STS_CODE%TYPE;

262: okc_k_lines_b cle
263: WHERE chr.ID = cle.dnz_chr_id
264: AND cle.ID = p_cle_id;
265:
266: l_sts_code OKC_K_HEADERS_B.STS_CODE%TYPE;
267:
268: --Cursor to check if the contract was ever booked
269: Cursor Ever_Booked_crs(p_cle_id IN Number) is
270: SELECT 'Y'

Line 271: FROM okc_k_headers_bh chrh,

267:
268: --Cursor to check if the contract was ever booked
269: Cursor Ever_Booked_crs(p_cle_id IN Number) is
270: SELECT 'Y'
271: FROM okc_k_headers_bh chrh,
272: okc_k_headers_b chr,
273: okc_k_lines_b cle
274: WHERE chrh.contract_number = chr.contract_number
275: AND chr.ID = cle.dnz_chr_id

Line 272: okc_k_headers_b chr,

268: --Cursor to check if the contract was ever booked
269: Cursor Ever_Booked_crs(p_cle_id IN Number) is
270: SELECT 'Y'
271: FROM okc_k_headers_bh chrh,
272: okc_k_headers_b chr,
273: okc_k_lines_b cle
274: WHERE chrh.contract_number = chr.contract_number
275: AND chr.ID = cle.dnz_chr_id
276: AND chrh.sts_code = G_OKL_BOOKED_STS_CODE

Line 314: okc_k_headers_b chrb

310: clet.NAME
311: from okc_k_lines_tl clet,
312: okc_k_lines_b cleb,
313: okc_line_styles_b lseb,
314: okc_k_headers_b chrb
315: where chrb.id = cleb.dnz_chr_id
316: and chrb.scs_code = 'LEASE'
317: and chrb.orig_system_source_code = 'OKL_REBOOK'
318: and clet.id = cleb.id

Line 325: from okc_k_headers_b orig_chrb,

321: and lseb.lty_code = 'FREE_FORM1'
322: and cleb.id = p_cle_id
323: and cleb.orig_system_id1 is not NULL
324: and exists (select '1'
325: from okc_k_headers_b orig_chrb,
326: okc_k_lines_b orig_cleb
327: where orig_chrb.id = chrb.orig_system_id1
328: and orig_cleb.id = cleb.orig_system_id1
329: --Bug# 4375800 :

Line 483: okc_k_headers_b chr

479: khr.term_duration,
480: chr.start_date,
481: chr.end_date
482: From okl_k_headers khr,
483: okc_k_headers_b chr
484: Where khr.id = chr.id
485: And chr.id = p_chr_id;
486:
487: l_sts_code okc_k_headers_b.sts_code%TYPE;

Line 487: l_sts_code okc_k_headers_b.sts_code%TYPE;

483: okc_k_headers_b chr
484: Where khr.id = chr.id
485: And chr.id = p_chr_id;
486:
487: l_sts_code okc_k_headers_b.sts_code%TYPE;
488: l_scs_code okc_k_headers_b.scs_code%TYPE;
489: l_term_duration okl_k_headers.term_duration%TYPE;
490: l_start_date okc_k_headers_b.start_date%TYPE;
491: l_end_date okc_k_headers_b.end_date%TYPE;

Line 488: l_scs_code okc_k_headers_b.scs_code%TYPE;

484: Where khr.id = chr.id
485: And chr.id = p_chr_id;
486:
487: l_sts_code okc_k_headers_b.sts_code%TYPE;
488: l_scs_code okc_k_headers_b.scs_code%TYPE;
489: l_term_duration okl_k_headers.term_duration%TYPE;
490: l_start_date okc_k_headers_b.start_date%TYPE;
491: l_end_date okc_k_headers_b.end_date%TYPE;
492:

Line 490: l_start_date okc_k_headers_b.start_date%TYPE;

486:
487: l_sts_code okc_k_headers_b.sts_code%TYPE;
488: l_scs_code okc_k_headers_b.scs_code%TYPE;
489: l_term_duration okl_k_headers.term_duration%TYPE;
490: l_start_date okc_k_headers_b.start_date%TYPE;
491: l_end_date okc_k_headers_b.end_date%TYPE;
492:
493:
494: --Cursor to check if the contract was ever booked

Line 491: l_end_date okc_k_headers_b.end_date%TYPE;

487: l_sts_code okc_k_headers_b.sts_code%TYPE;
488: l_scs_code okc_k_headers_b.scs_code%TYPE;
489: l_term_duration okl_k_headers.term_duration%TYPE;
490: l_start_date okc_k_headers_b.start_date%TYPE;
491: l_end_date okc_k_headers_b.end_date%TYPE;
492:
493:
494: --Cursor to check if the contract was ever booked
495: Cursor Ever_Booked_csr(p_chr_id IN Number) is

Line 497: FROM okc_k_headers_bh chrh,

493:
494: --Cursor to check if the contract was ever booked
495: Cursor Ever_Booked_csr(p_chr_id IN Number) is
496: SELECT 'Y'
497: FROM okc_k_headers_bh chrh,
498: okc_k_headers_b chr
499: WHERE chrh.contract_number = chr.contract_number
500: AND chr.ID = p_chr_id
501: AND chrh.sts_code = G_OKL_BOOKED_STS_CODE

Line 498: okc_k_headers_b chr

494: --Cursor to check if the contract was ever booked
495: Cursor Ever_Booked_csr(p_chr_id IN Number) is
496: SELECT 'Y'
497: FROM okc_k_headers_bh chrh,
498: okc_k_headers_b chr
499: WHERE chrh.contract_number = chr.contract_number
500: AND chr.ID = p_chr_id
501: AND chrh.sts_code = G_OKL_BOOKED_STS_CODE
502: AND rownum < 2;

Line 509: From okc_k_headers_b chr

505:
506: --Cursor to check if the contract is a rebook copy
507: Cursor Rbk_Cpy_Csr(p_chr_id IN Number) is
508: Select 'Y'
509: From okc_k_headers_b chr
510: where chr.orig_system_source_code = 'OKL_REBOOK'
511: and chr.id = p_chr_id;
512:
513: l_rbk_cpy Varchar2(1) default 'N';

Line 558: okc_k_headers_b orig,

554: Select orig.start_date,
555: orig.end_date,
556: orig_k.term_duration
557: from okl_k_headers orig_k,
558: okc_k_headers_b orig,
559: okc_k_headers_b rbk
560: where orig_k.id = orig.id
561: and orig.id = rbk.orig_system_id1
562: and rbk.id = rbk_chr_id;

Line 559: okc_k_headers_b rbk

555: orig.end_date,
556: orig_k.term_duration
557: from okl_k_headers orig_k,
558: okc_k_headers_b orig,
559: okc_k_headers_b rbk
560: where orig_k.id = orig.id
561: and orig.id = rbk.orig_system_id1
562: and rbk.id = rbk_chr_id;
563:

Line 564: l_orig_start_date okc_k_headers_b.start_date%TYPE;

560: where orig_k.id = orig.id
561: and orig.id = rbk.orig_system_id1
562: and rbk.id = rbk_chr_id;
563:
564: l_orig_start_date okc_k_headers_b.start_date%TYPE;
565: l_orig_end_date okc_k_headers_b.end_date%TYPE;
566: l_orig_term_duration okl_k_headers.term_duration%TYPE;
567:
568:

Line 565: l_orig_end_date okc_k_headers_b.end_date%TYPE;

561: and orig.id = rbk.orig_system_id1
562: and rbk.id = rbk_chr_id;
563:
564: l_orig_start_date okc_k_headers_b.start_date%TYPE;
565: l_orig_end_date okc_k_headers_b.end_date%TYPE;
566: l_orig_term_duration okl_k_headers.term_duration%TYPE;
567:
568:
569: Begin

Line 795: From okc_k_headers_b

791: x_return_status OUT NOCOPY VARCHAR2) IS
792:
793: Cursor chk_template_csr (p_chr_id IN NUMBER) is
794: Select nvl(template_yn,'N')
795: From okc_k_headers_b
796: Where id = p_chr_id;
797:
798: l_template_yn okc_k_headers_b.template_yn%TYPE;
799:

Line 798: l_template_yn okc_k_headers_b.template_yn%TYPE;

794: Select nvl(template_yn,'N')
795: From okc_k_headers_b
796: Where id = p_chr_id;
797:
798: l_template_yn okc_k_headers_b.template_yn%TYPE;
799:
800: BEGIN
801: x_return_status := OKL_API.G_RET_STS_SUCCESS;
802: --check if contract template creation is allowed

Line 1275: From okc_k_headers_b chr

1271: FUNCTION Is_Rebook_Copy (p_chr_id IN NUMBER) return varchar2 IS
1272: --Cursor to check if the contract is a rebook copy
1273: Cursor Rbk_Cpy_Csr(p_chr_id IN Number) is
1274: Select 'Y'
1275: From okc_k_headers_b chr
1276: where chr.orig_system_source_code = 'OKL_REBOOK'
1277: and chr.id = p_chr_id;
1278:
1279: l_rbk_cpy Varchar2(1) default 'N';

Line 1316: from okc_k_headers_b chrb

1312: chrb.end_date,
1313: chrb.scs_code,
1314: chrb.currency_code,
1315: chrb.sts_code
1316: from okc_k_headers_b chrb
1317: where chrb.id = p_chr_id;
1318:
1319: l_chr_start_date date;
1320: l_chr_end_date date;

Line 1321: l_scs_code okc_k_headers_b.scs_code%TYPE;

1317: where chrb.id = p_chr_id;
1318:
1319: l_chr_start_date date;
1320: l_chr_end_date date;
1321: l_scs_code okc_k_headers_b.scs_code%TYPE;
1322: l_chr_curr_code okc_k_headers_b.currency_code%TYPE;
1323: l_chr_sts_code okc_k_headers_b.sts_code%TYPE;
1324:
1325: --cursor to get parent line dates

Line 1322: l_chr_curr_code okc_k_headers_b.currency_code%TYPE;

1318:
1319: l_chr_start_date date;
1320: l_chr_end_date date;
1321: l_scs_code okc_k_headers_b.scs_code%TYPE;
1322: l_chr_curr_code okc_k_headers_b.currency_code%TYPE;
1323: l_chr_sts_code okc_k_headers_b.sts_code%TYPE;
1324:
1325: --cursor to get parent line dates
1326: cursor l_cle_csr (p_cle_id in number) is

Line 1323: l_chr_sts_code okc_k_headers_b.sts_code%TYPE;

1319: l_chr_start_date date;
1320: l_chr_end_date date;
1321: l_scs_code okc_k_headers_b.scs_code%TYPE;
1322: l_chr_curr_code okc_k_headers_b.currency_code%TYPE;
1323: l_chr_sts_code okc_k_headers_b.sts_code%TYPE;
1324:
1325: --cursor to get parent line dates
1326: cursor l_cle_csr (p_cle_id in number) is
1327: select cleb.start_date,

Line 1464: -- been promoted to OKC_K_HEADERS_B

1460: --------------------------------------------------------------------------------
1461: --Bug# 3124577 : Procedure Create_OKC_CURRENCY_RULE is removed for
1462: -- OKC 11.5.10 Rule Migration
1463: -- as there is no need to create the CVN rule . Currency columns
1464: -- been promoted to OKC_K_HEADERS_B
1465: /*--Bug# 3124577 : 11.5.10 Rule Migration -------------------------------------*/
1466: --------------------------------------------------------------------------------
1467: --Bug # : Multi-Currency Enhancement
1468: --

Line 1512: okc_k_headers_b rbk_chr

1508: khr.currency_conversion_type,
1509: khr.currency_conversion_date,
1510: khr.currency_conversion_rate
1511: from okl_k_headers_full_v khr,
1512: okc_k_headers_b rbk_chr
1513: where khr.id = rbk_chr.orig_system_id1
1514: and rbk_chr.id = p_rbk_chr_id;
1515:
1516: l_orig_curr_code okl_k_headers_full_v.currency_code%TYPE;

Line 1714: l_scs_code okc_k_headers_b.scs_code%TYPE;

1710: x_multigaap_yn OUT NOCOPY VARCHAR2) is
1711:
1712: l_pdt_id Number;
1713: l_pdt_date date;
1714: l_scs_code okc_k_headers_b.scs_code%TYPE;
1715: l_pdtv_rec okl_setupproducts_pub.pdtv_rec_type;
1716: l_pdt_parameter_rec okl_setupproducts_pub.pdt_parameters_rec_type;
1717: l_no_data_found Boolean;
1718: l_error_condition exception;

Line 1762: okc_k_headers_b rbk_chr

1758: -- cursor to get product of the original contract
1759: Cursor ger_orig_pdt_csr(p_rbk_chr_id IN NUMBER) is
1760: Select khr.pdt_id
1761: from okl_k_headers khr,
1762: okc_k_headers_b rbk_chr
1763: where khr.id = rbk_chr.orig_system_id1
1764: and rbk_chr.id = p_rbk_chr_id;
1765:
1766: l_orig_pdt_id okl_k_headers.pdt_id%TYPE;

Line 1779: okc_k_headers_b chrb

1775: select khr.pdt_id,
1776: chrb.scs_code,
1777: chrb.orig_system_source_code
1778: from okl_k_headers khr,
1779: okc_k_headers_b chrb
1780: where khr.id = chrb.id
1781: and chrb.id = p_chr_id;
1782:
1783: l_curr_pdt_rec l_curr_pdt_csr%ROWTYPE;

Line 2949: FROM okc_k_headers_b chr

2945: chr.scs_code,
2946: chr.orig_system_source_code,
2947: chr.orig_system_id1,
2948: chr.authoring_org_id --MOAC
2949: FROM okc_k_headers_b chr
2950: WHERE chr.id = chrid;
2951:
2952: l_orig_chr_rec get_orig_chr_csr%ROWTYPE;
2953:

Line 3020: l_parent_cle_start_date OKC_K_HEADERS_B.start_date%TYPE;

3016: cle.end_date
3017: From okc_k_lines_b cle
3018: Where cle.id = p_cle_id;
3019:
3020: l_parent_cle_start_date OKC_K_HEADERS_B.start_date%TYPE;
3021: l_parent_cle_end_date OKC_K_HEADERS_B.end_date%TYPE;
3022:
3023: --Bug# 3143522 : Subsidies
3024: --cursor to get lty code

Line 3021: l_parent_cle_end_date OKC_K_HEADERS_B.end_date%TYPE;

3017: From okc_k_lines_b cle
3018: Where cle.id = p_cle_id;
3019:
3020: l_parent_cle_start_date OKC_K_HEADERS_B.start_date%TYPE;
3021: l_parent_cle_end_date OKC_K_HEADERS_B.end_date%TYPE;
3022:
3023: --Bug# 3143522 : Subsidies
3024: --cursor to get lty code
3025: cursor l_ltycd_csr (p_lse_id in number) is

Line 4234: p_contract_id IN okc_k_headers_b.id%TYPE) IS

4230: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
4231: x_return_status OUT NOCOPY VARCHAR2,
4232: x_msg_count OUT NOCOPY NUMBER,
4233: x_msg_data OUT NOCOPY VARCHAR2,
4234: p_contract_id IN okc_k_headers_b.id%TYPE) IS
4235:
4236: SUBTYPE chrv_rec_type IS OKL_OKC_MIGRATION_PVT.CHRV_REC_TYPE;
4237: SUBTYPE khrv_rec_type IS OKL_CONTRACT_PUB.KHRV_REC_TYPE;
4238: G_TLS_TYPE OKC_LINE_STYLES_V.LSE_TYPE%TYPE := 'TLS';

Line 4257: l_sts_code OKC_K_HEADERS_B.STS_CODE%TYPE;

4253: l_tcnv_rec OKL_TRX_CONTRACTS_PVT.tcnv_rec_type;
4254: lx_tcnv_rec OKL_TRX_CONTRACTS_PVT.tcnv_rec_type;
4255: l_stmv_rec OKL_STREAMS_PUB.stmv_rec_type;
4256: r_tcnv_rec OKL_TRX_CONTRACTS_PVT.tcnv_rec_type;
4257: l_sts_code OKC_K_HEADERS_B.STS_CODE%TYPE;
4258:
4259: l_orig_system_source_code okc_k_headers_b.orig_system_source_code%type;
4260: l_contract_number okc_k_headers_b.contract_number%type;
4261: l_funding_count number := 0;

Line 4259: l_orig_system_source_code okc_k_headers_b.orig_system_source_code%type;

4255: l_stmv_rec OKL_STREAMS_PUB.stmv_rec_type;
4256: r_tcnv_rec OKL_TRX_CONTRACTS_PVT.tcnv_rec_type;
4257: l_sts_code OKC_K_HEADERS_B.STS_CODE%TYPE;
4258:
4259: l_orig_system_source_code okc_k_headers_b.orig_system_source_code%type;
4260: l_contract_number okc_k_headers_b.contract_number%type;
4261: l_funding_count number := 0;
4262: l_chr_ever_booked varchar2(1);
4263: l_chr_invoices varchar2(1);

Line 4260: l_contract_number okc_k_headers_b.contract_number%type;

4256: r_tcnv_rec OKL_TRX_CONTRACTS_PVT.tcnv_rec_type;
4257: l_sts_code OKC_K_HEADERS_B.STS_CODE%TYPE;
4258:
4259: l_orig_system_source_code okc_k_headers_b.orig_system_source_code%type;
4260: l_contract_number okc_k_headers_b.contract_number%type;
4261: l_funding_count number := 0;
4262: l_chr_ever_booked varchar2(1);
4263: l_chr_invoices varchar2(1);
4264: l_receipts_csr number;

Line 4276: FROM okc_k_headers_bh chrh,

4272: AND rownum < 2;
4273:
4274: CURSOR Ever_Booked_crs(p_id number) IS
4275: SELECT 'Y'
4276: FROM okc_k_headers_bh chrh,
4277: okc_k_headers_b chr
4278: WHERE chrh.contract_number = chr.contract_number
4279: AND chr.id = p_id
4280: AND chrh.sts_code = G_OKL_BOOKED_STS_CODE

Line 4277: okc_k_headers_b chr

4273:
4274: CURSOR Ever_Booked_crs(p_id number) IS
4275: SELECT 'Y'
4276: FROM okc_k_headers_bh chrh,
4277: okc_k_headers_b chr
4278: WHERE chrh.contract_number = chr.contract_number
4279: AND chr.id = p_id
4280: AND chrh.sts_code = G_OKL_BOOKED_STS_CODE
4281: AND rownum < 2;

Line 4311: CURSOR get_sts_code(p_chr_id OKC_K_HEADERS_B.ID%TYPE) IS

4307: AND lse.lse_parent_id IS NULL
4308: AND lse.lse_type = G_TLS_TYPE;
4309:
4310: -- To get the orig system id for p_chr_id
4311: CURSOR get_sts_code(p_chr_id OKC_K_HEADERS_B.ID%TYPE) IS
4312: SELECT sts_code, orig_system_source_code, contract_number,authoring_org_id --CDUBEY authoring_org_id added for MOAC
4313: FROM okc_k_headers_b
4314: WHERE id = p_chr_id;
4315:

Line 4313: FROM okc_k_headers_b

4309:
4310: -- To get the orig system id for p_chr_id
4311: CURSOR get_sts_code(p_chr_id OKC_K_HEADERS_B.ID%TYPE) IS
4312: SELECT sts_code, orig_system_source_code, contract_number,authoring_org_id --CDUBEY authoring_org_id added for MOAC
4313: FROM okc_k_headers_b
4314: WHERE id = p_chr_id;
4315:
4316:
4317: FUNCTION DELETE_GOVERNANCES( p_chr_id number) Return varchar2 IS

Line 5660: CURSOR curr_hdr_csr (p_chr_id OKC_K_HEADERS_B.ID%TYPE) IS

5656: x_klev_rec OUT NOCOPY klev_rec_type
5657: ) IS
5658:
5659: --Fix Bug# 2727161
5660: CURSOR curr_hdr_csr (p_chr_id OKC_K_HEADERS_B.ID%TYPE) IS
5661: SELECT currency_code
5662: FROM okc_k_headers_b
5663: WHERE id = p_chr_id;
5664:

Line 5662: FROM okc_k_headers_b

5658:
5659: --Fix Bug# 2727161
5660: CURSOR curr_hdr_csr (p_chr_id OKC_K_HEADERS_B.ID%TYPE) IS
5661: SELECT currency_code
5662: FROM okc_k_headers_b
5663: WHERE id = p_chr_id;
5664:
5665: CURSOR curr_ln_csr (p_line_id OKC_K_HEADERS_B.ID%TYPE) IS
5666: SELECT h.currency_code

Line 5665: CURSOR curr_ln_csr (p_line_id OKC_K_HEADERS_B.ID%TYPE) IS

5661: SELECT currency_code
5662: FROM okc_k_headers_b
5663: WHERE id = p_chr_id;
5664:
5665: CURSOR curr_ln_csr (p_line_id OKC_K_HEADERS_B.ID%TYPE) IS
5666: SELECT h.currency_code
5667: FROM okc_k_headers_b h,
5668: okc_k_lines_b l
5669: WHERE h.id = l.dnz_chr_id

Line 5667: FROM okc_k_headers_b h,

5663: WHERE id = p_chr_id;
5664:
5665: CURSOR curr_ln_csr (p_line_id OKC_K_HEADERS_B.ID%TYPE) IS
5666: SELECT h.currency_code
5667: FROM okc_k_headers_b h,
5668: okc_k_lines_b l
5669: WHERE h.id = l.dnz_chr_id
5670: AND l.id = p_line_id;
5671:

Line 6596: CURSOR get_linked_serv_cle (p_okl_chr_id okc_k_headers_b.id%TYPE, p_okl_cle_id okc_k_lines_b.id%TYPE) IS

6592: WHERE lse.id = line.lse_id
6593: AND line.id = p_line_id;
6594:
6595: -- sjalasut. added cursors to get the service contract details
6596: CURSOR get_linked_serv_cle (p_okl_chr_id okc_k_headers_b.id%TYPE, p_okl_cle_id okc_k_lines_b.id%TYPE) IS
6597: select rlobj.object1_id1
6598: from okc_k_rel_objs_v rlobj
6599: where rlobj.chr_id = p_okl_chr_id
6600: and rlobj.cle_id = p_okl_cle_id

Line 6605: CURSOR get_linked_serv_khr (p_oks_cle_id okc_k_headers_b.id%TYPE) IS

6601: and rlobj.rty_code = 'OKLSRV'
6602: and rlobj.jtot_object1_code = 'OKL_SERVICE_LINE';
6603: l_linked_serv_cle_id okc_k_lines_b.id%TYPE;
6604:
6605: CURSOR get_linked_serv_khr (p_oks_cle_id okc_k_headers_b.id%TYPE) IS
6606: select dnz_chr_id from okc_k_lines_b where id = p_oks_cle_id;
6607: l_linked_serv_chr_id okc_k_headers_b.id%TYPE;
6608:
6609:

Line 6607: l_linked_serv_chr_id okc_k_headers_b.id%TYPE;

6603: l_linked_serv_cle_id okc_k_lines_b.id%TYPE;
6604:
6605: CURSOR get_linked_serv_khr (p_oks_cle_id okc_k_headers_b.id%TYPE) IS
6606: select dnz_chr_id from okc_k_lines_b where id = p_oks_cle_id;
6607: l_linked_serv_chr_id okc_k_headers_b.id%TYPE;
6608:
6609:
6610: l_lty_code okc_line_styles_b.lty_code%TYPE;
6611: l_parameter_list wf_parameter_list_t;

Line 10731: okc_k_headers_b b,

10727: b.currency_code,
10728: --Bug# 2857899
10729: nvl(b.template_yn,'N') template_yn
10730: from okc_statuses_b a,
10731: okc_k_headers_b b,
10732: okl_k_headers c,
10733: OKC_STATUSES_TL cst
10734: where b.id = c.id
10735: and b.id = chrId

Line 10742: l_scs_code okc_k_headers_b.scs_code%TYPE;

10738: and cst.LANGUAGE = userenv('LANG');
10739:
10740:
10741: status_rec status_csr%ROWTYPE;
10742: l_scs_code okc_k_headers_b.scs_code%TYPE;
10743: l_currency_code okc_k_headers_b.currency_code%TYPE;
10744: --bug# 2857899
10745: l_template_yn okc_k_headers_b.template_yn%TYPE;
10746:

Line 10743: l_currency_code okc_k_headers_b.currency_code%TYPE;

10739:
10740:
10741: status_rec status_csr%ROWTYPE;
10742: l_scs_code okc_k_headers_b.scs_code%TYPE;
10743: l_currency_code okc_k_headers_b.currency_code%TYPE;
10744: --bug# 2857899
10745: l_template_yn okc_k_headers_b.template_yn%TYPE;
10746:
10747: Cursor chr_csr ( chrId NUMBER ) IS

Line 10745: l_template_yn okc_k_headers_b.template_yn%TYPE;

10741: status_rec status_csr%ROWTYPE;
10742: l_scs_code okc_k_headers_b.scs_code%TYPE;
10743: l_currency_code okc_k_headers_b.currency_code%TYPE;
10744: --bug# 2857899
10745: l_template_yn okc_k_headers_b.template_yn%TYPE;
10746:
10747: Cursor chr_csr ( chrId NUMBER ) IS
10748: select khr.SHORT_DESCRIPTION,
10749: khr.CONTRACT_NUMBER,

Line 10773: -- new cust csr will fetch customet account from OKC_K_HEADERS_B

10769:
10770:
10771: -------------------------------------------------------
10772: --Bug# 3124577 : 11.5.10 Rule Migration
10773: -- new cust csr will fetch customet account from OKC_K_HEADERS_B
10774: --------------------------------------------------------
10775: Cursor cust_csr ( chrId IN NUMBER) IS
10776: SELECT CHRB.CURRENCY_CODE,
10777: CHRB.AUTHORING_ORG_ID,

Line 10783: FROM OKC_K_HEADERS_B CHRB,

10779: CHRB.BUY_OR_SELL,
10780: CHRB.CUST_ACCT_ID,
10781: CUS.NAME,
10782: CUS.DESCRIPTION
10783: FROM OKC_K_HEADERS_B CHRB,
10784: OKX_CUSTOMER_ACCOUNTS_V CUS
10785: WHERE CUS.ID1 = CHRB.cust_acct_id
10786: AND CHRB.ID = chrId;
10787:

Line 10799: l_prog_num OKC_K_HEADERS_B.CONTRACT_NUMBER%type := null;

10795: -------------------------------------------------------
10796: --Bug# 4748777 : 11.5.10 Change from Program short
10797: -- description to program number in the common header
10798: --------------------------------------------------------
10799: l_prog_num OKC_K_HEADERS_B.CONTRACT_NUMBER%type := null;
10800: Cursor prog_num_csr ( p_chr_id IN NUMBER) IS
10801: select prog.contract_number
10802: from OKL_K_HEADERS KHR,
10803: OKC_K_HEADERS_B PROG

Line 10803: OKC_K_HEADERS_B PROG

10799: l_prog_num OKC_K_HEADERS_B.CONTRACT_NUMBER%type := null;
10800: Cursor prog_num_csr ( p_chr_id IN NUMBER) IS
10801: select prog.contract_number
10802: from OKL_K_HEADERS KHR,
10803: OKC_K_HEADERS_B PROG
10804: where PROG.ID = KHR.KHR_ID
10805: and khr.id = p_chr_id;
10806:
10807: -------------------------------------------------------

Line 10827: SELECT 'Y' FROM okc_k_headers_b chr

10823: RETURN VARCHAR2
10824: IS
10825: -- A complex query to find out if a contract has syndication
10826: CURSOR syndicate_flag_csr(p_contract_id NUMBER) IS
10827: SELECT 'Y' FROM okc_k_headers_b chr
10828: WHERE id = p_contract_id
10829: AND EXISTS
10830: (
10831: SELECT 'x' FROM okc_k_items cim

Line 10842: SELECT 'x' FROM okc_k_headers_b chr2

10838: AND cle.id = cim.cle_id
10839: )
10840: AND EXISTS
10841: (
10842: SELECT 'x' FROM okc_k_headers_b chr2
10843: WHERE chr2.id = cim.dnz_chr_id
10844: AND chr2.scs_code = 'SYNDICATION'
10845: AND chr2.sts_code not in ('TERMINATED','ABANDONED')
10846: )