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 143: l_chr_id okc_k_headers_b.id%TYPE;

139: x_msg_data OUT NOCOPY VARCHAR2,
140: p_event_name IN wf_events.name%TYPE,
141: p_parameter_list IN wf_parameter_list_t) IS
142:
143: l_chr_id okc_k_headers_b.id%TYPE;
144: l_contract_process VARCHAR2(30);
145: l_parameter_list WF_PARAMETER_LIST_T := p_parameter_list;
146:
147: BEGIN

Line 274: FROM okc_k_headers_b chr,

270:
271: --Cursor to check if the contract is booked
272: Cursor Chr_sts_crs(p_cle_id IN Number) IS
273: SELECT chr.sts_code
274: FROM okc_k_headers_b chr,
275: okc_k_lines_b cle
276: WHERE chr.ID = cle.dnz_chr_id
277: AND cle.ID = p_cle_id;
278:

Line 279: l_sts_code OKC_K_HEADERS_B.STS_CODE%TYPE;

275: okc_k_lines_b cle
276: WHERE chr.ID = cle.dnz_chr_id
277: AND cle.ID = p_cle_id;
278:
279: l_sts_code OKC_K_HEADERS_B.STS_CODE%TYPE;
280:
281: --Cursor to check if the contract was ever booked
282: Cursor Ever_Booked_crs(p_cle_id IN Number) is
283: SELECT 'Y'

Line 284: FROM okc_k_headers_bh chrh,

280:
281: --Cursor to check if the contract was ever booked
282: Cursor Ever_Booked_crs(p_cle_id IN Number) is
283: SELECT 'Y'
284: FROM okc_k_headers_bh chrh,
285: okc_k_headers_b chr,
286: okc_k_lines_b cle
287: WHERE chrh.contract_number = chr.contract_number
288: AND chr.ID = cle.dnz_chr_id

Line 285: okc_k_headers_b chr,

281: --Cursor to check if the contract was ever booked
282: Cursor Ever_Booked_crs(p_cle_id IN Number) is
283: SELECT 'Y'
284: FROM okc_k_headers_bh chrh,
285: okc_k_headers_b chr,
286: okc_k_lines_b cle
287: WHERE chrh.contract_number = chr.contract_number
288: AND chr.ID = cle.dnz_chr_id
289: AND chrh.sts_code = G_OKL_BOOKED_STS_CODE

Line 327: okc_k_headers_b chrb

323: clet.NAME
324: from okc_k_lines_tl clet,
325: okc_k_lines_b cleb,
326: okc_line_styles_b lseb,
327: okc_k_headers_b chrb
328: where chrb.id = cleb.dnz_chr_id
329: and chrb.scs_code = 'LEASE'
330: and chrb.orig_system_source_code = 'OKL_REBOOK'
331: and clet.id = cleb.id

Line 338: from okc_k_headers_b orig_chrb,

334: and lseb.lty_code = 'FREE_FORM1'
335: and cleb.id = p_cle_id
336: and cleb.orig_system_id1 is not NULL
337: and exists (select '1'
338: from okc_k_headers_b orig_chrb,
339: okc_k_lines_b orig_cleb
340: where orig_chrb.id = chrb.orig_system_id1
341: and orig_cleb.id = cleb.orig_system_id1
342: --Bug# 4375800 :

Line 497: okc_k_headers_b chr

493: khr.term_duration,
494: chr.start_date,
495: chr.end_date
496: From okl_k_headers khr,
497: okc_k_headers_b chr
498: Where khr.id = chr.id
499: And chr.id = p_chr_id;
500:
501: l_sts_code okc_k_headers_b.sts_code%TYPE;

Line 501: l_sts_code okc_k_headers_b.sts_code%TYPE;

497: okc_k_headers_b chr
498: Where khr.id = chr.id
499: And chr.id = p_chr_id;
500:
501: l_sts_code okc_k_headers_b.sts_code%TYPE;
502: l_scs_code okc_k_headers_b.scs_code%TYPE;
503: l_term_duration okl_k_headers.term_duration%TYPE;
504: l_start_date okc_k_headers_b.start_date%TYPE;
505: l_end_date okc_k_headers_b.end_date%TYPE;

Line 502: l_scs_code okc_k_headers_b.scs_code%TYPE;

498: Where khr.id = chr.id
499: And chr.id = p_chr_id;
500:
501: l_sts_code okc_k_headers_b.sts_code%TYPE;
502: l_scs_code okc_k_headers_b.scs_code%TYPE;
503: l_term_duration okl_k_headers.term_duration%TYPE;
504: l_start_date okc_k_headers_b.start_date%TYPE;
505: l_end_date okc_k_headers_b.end_date%TYPE;
506:

Line 504: l_start_date okc_k_headers_b.start_date%TYPE;

500:
501: l_sts_code okc_k_headers_b.sts_code%TYPE;
502: l_scs_code okc_k_headers_b.scs_code%TYPE;
503: l_term_duration okl_k_headers.term_duration%TYPE;
504: l_start_date okc_k_headers_b.start_date%TYPE;
505: l_end_date okc_k_headers_b.end_date%TYPE;
506:
507:
508: --Cursor to check if the contract was ever booked

Line 505: l_end_date okc_k_headers_b.end_date%TYPE;

501: l_sts_code okc_k_headers_b.sts_code%TYPE;
502: l_scs_code okc_k_headers_b.scs_code%TYPE;
503: l_term_duration okl_k_headers.term_duration%TYPE;
504: l_start_date okc_k_headers_b.start_date%TYPE;
505: l_end_date okc_k_headers_b.end_date%TYPE;
506:
507:
508: --Cursor to check if the contract was ever booked
509: Cursor Ever_Booked_csr(p_chr_id IN Number) is

Line 511: FROM okc_k_headers_bh chrh,

507:
508: --Cursor to check if the contract was ever booked
509: Cursor Ever_Booked_csr(p_chr_id IN Number) is
510: SELECT 'Y'
511: FROM okc_k_headers_bh chrh,
512: okc_k_headers_b chr
513: WHERE chrh.contract_number = chr.contract_number
514: AND chr.ID = p_chr_id
515: AND chrh.sts_code = G_OKL_BOOKED_STS_CODE

Line 512: okc_k_headers_b chr

508: --Cursor to check if the contract was ever booked
509: Cursor Ever_Booked_csr(p_chr_id IN Number) is
510: SELECT 'Y'
511: FROM okc_k_headers_bh chrh,
512: okc_k_headers_b chr
513: WHERE chrh.contract_number = chr.contract_number
514: AND chr.ID = p_chr_id
515: AND chrh.sts_code = G_OKL_BOOKED_STS_CODE
516: AND rownum < 2;

Line 523: From okc_k_headers_b chr

519:
520: --Cursor to check if the contract is a rebook copy
521: Cursor Rbk_Cpy_Csr(p_chr_id IN Number) is
522: Select 'Y'
523: From okc_k_headers_b chr
524: where chr.orig_system_source_code = 'OKL_REBOOK'
525: and chr.id = p_chr_id;
526:
527: l_rbk_cpy Varchar2(1) default 'N';

Line 579: okc_k_headers_b orig,

575: Select orig.start_date,
576: orig.end_date,
577: orig_k.term_duration
578: from okl_k_headers orig_k,
579: okc_k_headers_b orig,
580: okc_k_headers_b rbk
581: where orig_k.id = orig.id
582: and orig.id = rbk.orig_system_id1
583: and rbk.id = rbk_chr_id;

Line 580: okc_k_headers_b rbk

576: orig.end_date,
577: orig_k.term_duration
578: from okl_k_headers orig_k,
579: okc_k_headers_b orig,
580: okc_k_headers_b rbk
581: where orig_k.id = orig.id
582: and orig.id = rbk.orig_system_id1
583: and rbk.id = rbk_chr_id;
584:

Line 585: l_orig_start_date okc_k_headers_b.start_date%TYPE;

581: where orig_k.id = orig.id
582: and orig.id = rbk.orig_system_id1
583: and rbk.id = rbk_chr_id;
584:
585: l_orig_start_date okc_k_headers_b.start_date%TYPE;
586: l_orig_end_date okc_k_headers_b.end_date%TYPE;
587: l_orig_term_duration okl_k_headers.term_duration%TYPE;
588:
589:

Line 586: l_orig_end_date okc_k_headers_b.end_date%TYPE;

582: and orig.id = rbk.orig_system_id1
583: and rbk.id = rbk_chr_id;
584:
585: l_orig_start_date okc_k_headers_b.start_date%TYPE;
586: l_orig_end_date okc_k_headers_b.end_date%TYPE;
587: l_orig_term_duration okl_k_headers.term_duration%TYPE;
588:
589:
590: Begin

Line 827: From okc_k_headers_b

823: x_return_status OUT NOCOPY VARCHAR2) IS
824:
825: Cursor chk_template_csr (p_chr_id IN NUMBER) is
826: Select nvl(template_yn,'N')
827: From okc_k_headers_b
828: Where id = p_chr_id;
829:
830: l_template_yn okc_k_headers_b.template_yn%TYPE;
831:

Line 830: l_template_yn okc_k_headers_b.template_yn%TYPE;

826: Select nvl(template_yn,'N')
827: From okc_k_headers_b
828: Where id = p_chr_id;
829:
830: l_template_yn okc_k_headers_b.template_yn%TYPE;
831:
832: BEGIN
833: x_return_status := OKL_API.G_RET_STS_SUCCESS;
834: --check if contract template creation is allowed

Line 1307: From okc_k_headers_b chr

1303: FUNCTION Is_Rebook_Copy (p_chr_id IN NUMBER) return varchar2 IS
1304: --Cursor to check if the contract is a rebook copy
1305: Cursor Rbk_Cpy_Csr(p_chr_id IN Number) is
1306: Select 'Y'
1307: From okc_k_headers_b chr
1308: where chr.orig_system_source_code = 'OKL_REBOOK'
1309: and chr.id = p_chr_id;
1310:
1311: l_rbk_cpy Varchar2(1) default 'N';

Line 1348: from okc_k_headers_b chrb

1344: chrb.end_date,
1345: chrb.scs_code,
1346: chrb.currency_code,
1347: chrb.sts_code
1348: from okc_k_headers_b chrb
1349: where chrb.id = p_chr_id;
1350:
1351: l_chr_start_date date;
1352: l_chr_end_date date;

Line 1353: l_scs_code okc_k_headers_b.scs_code%TYPE;

1349: where chrb.id = p_chr_id;
1350:
1351: l_chr_start_date date;
1352: l_chr_end_date date;
1353: l_scs_code okc_k_headers_b.scs_code%TYPE;
1354: l_chr_curr_code okc_k_headers_b.currency_code%TYPE;
1355: l_chr_sts_code okc_k_headers_b.sts_code%TYPE;
1356:
1357: --cursor to get parent line dates

Line 1354: l_chr_curr_code okc_k_headers_b.currency_code%TYPE;

1350:
1351: l_chr_start_date date;
1352: l_chr_end_date date;
1353: l_scs_code okc_k_headers_b.scs_code%TYPE;
1354: l_chr_curr_code okc_k_headers_b.currency_code%TYPE;
1355: l_chr_sts_code okc_k_headers_b.sts_code%TYPE;
1356:
1357: --cursor to get parent line dates
1358: cursor l_cle_csr (p_cle_id in number) is

Line 1355: l_chr_sts_code okc_k_headers_b.sts_code%TYPE;

1351: l_chr_start_date date;
1352: l_chr_end_date date;
1353: l_scs_code okc_k_headers_b.scs_code%TYPE;
1354: l_chr_curr_code okc_k_headers_b.currency_code%TYPE;
1355: l_chr_sts_code okc_k_headers_b.sts_code%TYPE;
1356:
1357: --cursor to get parent line dates
1358: cursor l_cle_csr (p_cle_id in number) is
1359: select cleb.start_date,

Line 1496: -- been promoted to OKC_K_HEADERS_B

1492: --------------------------------------------------------------------------------
1493: --Bug# 3124577 : Procedure Create_OKC_CURRENCY_RULE is removed for
1494: -- OKC 11.5.10 Rule Migration
1495: -- as there is no need to create the CVN rule . Currency columns
1496: -- been promoted to OKC_K_HEADERS_B
1497: /*--Bug# 3124577 : 11.5.10 Rule Migration -------------------------------------*/
1498: --------------------------------------------------------------------------------
1499: --Bug # : Multi-Currency Enhancement
1500: --

Line 1544: okc_k_headers_b rbk_chr

1540: khr.currency_conversion_type,
1541: khr.currency_conversion_date,
1542: khr.currency_conversion_rate
1543: from okl_k_headers_full_v khr,
1544: okc_k_headers_b rbk_chr
1545: where khr.id = rbk_chr.orig_system_id1
1546: and rbk_chr.id = p_rbk_chr_id;
1547:
1548: l_orig_curr_code okl_k_headers_full_v.currency_code%TYPE;

Line 1746: l_scs_code okc_k_headers_b.scs_code%TYPE;

1742: x_multigaap_yn OUT NOCOPY VARCHAR2) is
1743:
1744: l_pdt_id Number;
1745: l_pdt_date date;
1746: l_scs_code okc_k_headers_b.scs_code%TYPE;
1747: l_pdtv_rec okl_setupproducts_pub.pdtv_rec_type;
1748: l_pdt_parameter_rec okl_setupproducts_pub.pdt_parameters_rec_type;
1749: l_no_data_found Boolean;
1750: l_error_condition exception;

Line 1794: okc_k_headers_b rbk_chr

1790: -- cursor to get product of the original contract
1791: Cursor ger_orig_pdt_csr(p_rbk_chr_id IN NUMBER) is
1792: Select khr.pdt_id
1793: from okl_k_headers khr,
1794: okc_k_headers_b rbk_chr
1795: where khr.id = rbk_chr.orig_system_id1
1796: and rbk_chr.id = p_rbk_chr_id;
1797:
1798: l_orig_pdt_id okl_k_headers.pdt_id%TYPE;

Line 1811: okc_k_headers_b chrb

1807: select khr.pdt_id,
1808: chrb.scs_code,
1809: chrb.orig_system_source_code
1810: from okl_k_headers khr,
1811: okc_k_headers_b chrb
1812: where khr.id = chrb.id
1813: and chrb.id = p_chr_id;
1814:
1815: l_curr_pdt_rec l_curr_pdt_csr%ROWTYPE;

Line 3028: FROM okc_k_headers_b chr

3024: chr.scs_code,
3025: chr.orig_system_source_code,
3026: chr.orig_system_id1,
3027: chr.authoring_org_id --MOAC
3028: FROM okc_k_headers_b chr
3029: WHERE chr.id = chrid;
3030:
3031: l_orig_chr_rec get_orig_chr_csr%ROWTYPE;
3032:

Line 3099: l_parent_cle_start_date OKC_K_HEADERS_B.start_date%TYPE;

3095: cle.end_date
3096: From okc_k_lines_b cle
3097: Where cle.id = p_cle_id;
3098:
3099: l_parent_cle_start_date OKC_K_HEADERS_B.start_date%TYPE;
3100: l_parent_cle_end_date OKC_K_HEADERS_B.end_date%TYPE;
3101:
3102: --Bug# 3143522 : Subsidies
3103: --cursor to get lty code

Line 3100: l_parent_cle_end_date OKC_K_HEADERS_B.end_date%TYPE;

3096: From okc_k_lines_b cle
3097: Where cle.id = p_cle_id;
3098:
3099: l_parent_cle_start_date OKC_K_HEADERS_B.start_date%TYPE;
3100: l_parent_cle_end_date OKC_K_HEADERS_B.end_date%TYPE;
3101:
3102: --Bug# 3143522 : Subsidies
3103: --cursor to get lty code
3104: cursor l_ltycd_csr (p_lse_id in number) is

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

4315: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
4316: x_return_status OUT NOCOPY VARCHAR2,
4317: x_msg_count OUT NOCOPY NUMBER,
4318: x_msg_data OUT NOCOPY VARCHAR2,
4319: p_contract_id IN okc_k_headers_b.id%TYPE) IS
4320:
4321: SUBTYPE chrv_rec_type IS OKL_OKC_MIGRATION_PVT.CHRV_REC_TYPE;
4322: SUBTYPE khrv_rec_type IS OKL_CONTRACT_PUB.KHRV_REC_TYPE;
4323: G_TLS_TYPE OKC_LINE_STYLES_V.LSE_TYPE%TYPE := 'TLS';

Line 4342: l_sts_code OKC_K_HEADERS_B.STS_CODE%TYPE;

4338: l_tcnv_rec OKL_TRX_CONTRACTS_PVT.tcnv_rec_type;
4339: lx_tcnv_rec OKL_TRX_CONTRACTS_PVT.tcnv_rec_type;
4340: l_stmv_rec OKL_STREAMS_PUB.stmv_rec_type;
4341: r_tcnv_rec OKL_TRX_CONTRACTS_PVT.tcnv_rec_type;
4342: l_sts_code OKC_K_HEADERS_B.STS_CODE%TYPE;
4343:
4344: l_orig_system_source_code okc_k_headers_b.orig_system_source_code%type;
4345: l_contract_number okc_k_headers_b.contract_number%type;
4346: l_funding_count number := 0;

Line 4344: l_orig_system_source_code okc_k_headers_b.orig_system_source_code%type;

4340: l_stmv_rec OKL_STREAMS_PUB.stmv_rec_type;
4341: r_tcnv_rec OKL_TRX_CONTRACTS_PVT.tcnv_rec_type;
4342: l_sts_code OKC_K_HEADERS_B.STS_CODE%TYPE;
4343:
4344: l_orig_system_source_code okc_k_headers_b.orig_system_source_code%type;
4345: l_contract_number okc_k_headers_b.contract_number%type;
4346: l_funding_count number := 0;
4347: l_chr_ever_booked varchar2(1);
4348: l_chr_invoices varchar2(1);

Line 4345: l_contract_number okc_k_headers_b.contract_number%type;

4341: r_tcnv_rec OKL_TRX_CONTRACTS_PVT.tcnv_rec_type;
4342: l_sts_code OKC_K_HEADERS_B.STS_CODE%TYPE;
4343:
4344: l_orig_system_source_code okc_k_headers_b.orig_system_source_code%type;
4345: l_contract_number okc_k_headers_b.contract_number%type;
4346: l_funding_count number := 0;
4347: l_chr_ever_booked varchar2(1);
4348: l_chr_invoices varchar2(1);
4349: l_receipts_csr number;

Line 4361: FROM okc_k_headers_bh chrh,

4357: AND rownum < 2;
4358:
4359: CURSOR Ever_Booked_crs(p_id number) IS
4360: SELECT 'Y'
4361: FROM okc_k_headers_bh chrh,
4362: okc_k_headers_b chr
4363: WHERE chrh.contract_number = chr.contract_number
4364: AND chr.id = p_id
4365: AND chrh.sts_code = G_OKL_BOOKED_STS_CODE

Line 4362: okc_k_headers_b chr

4358:
4359: CURSOR Ever_Booked_crs(p_id number) IS
4360: SELECT 'Y'
4361: FROM okc_k_headers_bh chrh,
4362: okc_k_headers_b chr
4363: WHERE chrh.contract_number = chr.contract_number
4364: AND chr.id = p_id
4365: AND chrh.sts_code = G_OKL_BOOKED_STS_CODE
4366: AND rownum < 2;

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

4392: AND lse.lse_parent_id IS NULL
4393: AND lse.lse_type = G_TLS_TYPE;
4394:
4395: -- To get the orig system id for p_chr_id
4396: CURSOR get_sts_code(p_chr_id OKC_K_HEADERS_B.ID%TYPE) IS
4397: SELECT sts_code, orig_system_source_code, contract_number,authoring_org_id --CDUBEY authoring_org_id added for MOAC
4398: FROM okc_k_headers_b
4399: WHERE id = p_chr_id;
4400:

Line 4398: FROM okc_k_headers_b

4394:
4395: -- To get the orig system id for p_chr_id
4396: CURSOR get_sts_code(p_chr_id OKC_K_HEADERS_B.ID%TYPE) IS
4397: SELECT sts_code, orig_system_source_code, contract_number,authoring_org_id --CDUBEY authoring_org_id added for MOAC
4398: FROM okc_k_headers_b
4399: WHERE id = p_chr_id;
4400:
4401:
4402: FUNCTION DELETE_GOVERNANCES( p_chr_id number) Return varchar2 IS

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

5741: x_klev_rec OUT NOCOPY klev_rec_type
5742: ) IS
5743:
5744: --Fix Bug# 2727161
5745: CURSOR curr_hdr_csr (p_chr_id OKC_K_HEADERS_B.ID%TYPE) IS
5746: SELECT currency_code
5747: FROM okc_k_headers_b
5748: WHERE id = p_chr_id;
5749:

Line 5747: FROM okc_k_headers_b

5743:
5744: --Fix Bug# 2727161
5745: CURSOR curr_hdr_csr (p_chr_id OKC_K_HEADERS_B.ID%TYPE) IS
5746: SELECT currency_code
5747: FROM okc_k_headers_b
5748: WHERE id = p_chr_id;
5749:
5750: CURSOR curr_ln_csr (p_line_id OKC_K_HEADERS_B.ID%TYPE) IS
5751: SELECT h.currency_code

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

5746: SELECT currency_code
5747: FROM okc_k_headers_b
5748: WHERE id = p_chr_id;
5749:
5750: CURSOR curr_ln_csr (p_line_id OKC_K_HEADERS_B.ID%TYPE) IS
5751: SELECT h.currency_code
5752: FROM okc_k_headers_b h,
5753: okc_k_lines_b l
5754: WHERE h.id = l.dnz_chr_id

Line 5752: FROM okc_k_headers_b h,

5748: WHERE id = p_chr_id;
5749:
5750: CURSOR curr_ln_csr (p_line_id OKC_K_HEADERS_B.ID%TYPE) IS
5751: SELECT h.currency_code
5752: FROM okc_k_headers_b h,
5753: okc_k_lines_b l
5754: WHERE h.id = l.dnz_chr_id
5755: AND l.id = p_line_id;
5756:

Line 6698: 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

6694: WHERE lse.id = line.lse_id
6695: AND line.id = p_line_id;
6696:
6697: -- sjalasut. added cursors to get the service contract details
6698: 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
6699: select rlobj.object1_id1
6700: from okc_k_rel_objs_v rlobj
6701: where rlobj.chr_id = p_okl_chr_id
6702: and rlobj.cle_id = p_okl_cle_id

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

6703: and rlobj.rty_code = 'OKLSRV'
6704: and rlobj.jtot_object1_code = 'OKL_SERVICE_LINE';
6705: l_linked_serv_cle_id okc_k_lines_b.id%TYPE;
6706:
6707: CURSOR get_linked_serv_khr (p_oks_cle_id okc_k_headers_b.id%TYPE) IS
6708: select dnz_chr_id from okc_k_lines_b where id = p_oks_cle_id;
6709: l_linked_serv_chr_id okc_k_headers_b.id%TYPE;
6710:
6711:

Line 6709: l_linked_serv_chr_id okc_k_headers_b.id%TYPE;

6705: l_linked_serv_cle_id okc_k_lines_b.id%TYPE;
6706:
6707: CURSOR get_linked_serv_khr (p_oks_cle_id okc_k_headers_b.id%TYPE) IS
6708: select dnz_chr_id from okc_k_lines_b where id = p_oks_cle_id;
6709: l_linked_serv_chr_id okc_k_headers_b.id%TYPE;
6710:
6711:
6712: l_lty_code okc_line_styles_b.lty_code%TYPE;
6713: l_parameter_list wf_parameter_list_t;

Line 10833: okc_k_headers_b b,

10829: b.currency_code,
10830: --Bug# 2857899
10831: nvl(b.template_yn,'N') template_yn
10832: from okc_statuses_b a,
10833: okc_k_headers_b b,
10834: okl_k_headers c,
10835: OKC_STATUSES_TL cst
10836: where b.id = c.id
10837: and b.id = chrId

Line 10844: l_scs_code okc_k_headers_b.scs_code%TYPE;

10840: and cst.LANGUAGE = userenv('LANG');
10841:
10842:
10843: status_rec status_csr%ROWTYPE;
10844: l_scs_code okc_k_headers_b.scs_code%TYPE;
10845: l_currency_code okc_k_headers_b.currency_code%TYPE;
10846: --bug# 2857899
10847: l_template_yn okc_k_headers_b.template_yn%TYPE;
10848:

Line 10845: l_currency_code okc_k_headers_b.currency_code%TYPE;

10841:
10842:
10843: status_rec status_csr%ROWTYPE;
10844: l_scs_code okc_k_headers_b.scs_code%TYPE;
10845: l_currency_code okc_k_headers_b.currency_code%TYPE;
10846: --bug# 2857899
10847: l_template_yn okc_k_headers_b.template_yn%TYPE;
10848:
10849: Cursor chr_csr ( chrId NUMBER ) IS

Line 10847: l_template_yn okc_k_headers_b.template_yn%TYPE;

10843: status_rec status_csr%ROWTYPE;
10844: l_scs_code okc_k_headers_b.scs_code%TYPE;
10845: l_currency_code okc_k_headers_b.currency_code%TYPE;
10846: --bug# 2857899
10847: l_template_yn okc_k_headers_b.template_yn%TYPE;
10848:
10849: Cursor chr_csr ( chrId NUMBER ) IS
10850: select khr.SHORT_DESCRIPTION,
10851: khr.CONTRACT_NUMBER,

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

10871:
10872:
10873: -------------------------------------------------------
10874: --Bug# 3124577 : 11.5.10 Rule Migration
10875: -- new cust csr will fetch customet account from OKC_K_HEADERS_B
10876: --------------------------------------------------------
10877: Cursor cust_csr ( chrId IN NUMBER) IS
10878: SELECT CHRB.CURRENCY_CODE,
10879: CHRB.AUTHORING_ORG_ID,

Line 10885: FROM OKC_K_HEADERS_B CHRB,

10881: CHRB.BUY_OR_SELL,
10882: CHRB.CUST_ACCT_ID,
10883: CUS.NAME,
10884: CUS.DESCRIPTION
10885: FROM OKC_K_HEADERS_B CHRB,
10886: OKX_CUSTOMER_ACCOUNTS_V CUS
10887: WHERE CUS.ID1 = CHRB.cust_acct_id
10888: AND CHRB.ID = chrId;
10889:

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

10897: -------------------------------------------------------
10898: --Bug# 4748777 : 11.5.10 Change from Program short
10899: -- description to program number in the common header
10900: --------------------------------------------------------
10901: l_prog_num OKC_K_HEADERS_B.CONTRACT_NUMBER%type := null;
10902: Cursor prog_num_csr ( p_chr_id IN NUMBER) IS
10903: select prog.contract_number
10904: from OKL_K_HEADERS KHR,
10905: OKC_K_HEADERS_B PROG

Line 10905: OKC_K_HEADERS_B PROG

10901: l_prog_num OKC_K_HEADERS_B.CONTRACT_NUMBER%type := null;
10902: Cursor prog_num_csr ( p_chr_id IN NUMBER) IS
10903: select prog.contract_number
10904: from OKL_K_HEADERS KHR,
10905: OKC_K_HEADERS_B PROG
10906: where PROG.ID = KHR.KHR_ID
10907: and khr.id = p_chr_id;
10908:
10909: -------------------------------------------------------

Line 10929: SELECT 'Y' FROM okc_k_headers_b chr

10925: RETURN VARCHAR2
10926: IS
10927: -- A complex query to find out if a contract has syndication
10928: CURSOR syndicate_flag_csr(p_contract_id NUMBER) IS
10929: SELECT 'Y' FROM okc_k_headers_b chr
10930: WHERE id = p_contract_id
10931: AND EXISTS
10932: (
10933: SELECT 'x' FROM okc_k_items cim

Line 10944: SELECT 'x' FROM okc_k_headers_b chr2

10940: AND cle.id = cim.cle_id
10941: )
10942: AND EXISTS
10943: (
10944: SELECT 'x' FROM okc_k_headers_b chr2
10945: WHERE chr2.id = cim.dnz_chr_id
10946: AND chr2.scs_code = 'SYNDICATION'
10947: AND chr2.sts_code not in ('TERMINATED','ABANDONED')
10948: )