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

Line 860: p_chr_id IN okc_k_headers_b.id%TYPE,

856: p_init_msg_list IN VARCHAR2,
857: x_return_status OUT NOCOPY VARCHAR2,
858: x_msg_count OUT NOCOPY NUMBER,
859: x_msg_data OUT NOCOPY VARCHAR2,
860: p_chr_id IN okc_k_headers_b.id%TYPE,
861: p_fee_line_id IN okc_k_lines_b.id%TYPE,
862: p_event_name IN wf_events.name%TYPE) IS
863:
864: l_parameter_list wf_parameter_list_t;

Line 954: l_start_date okc_k_headers_b.start_date%type := null;

950: l_supp_id okx_vendors_v.id1%type := null;
951: l_party_name okx_vendors_v.name%type := null;
952: l_item_id NUMBER:= null;
953: l_item_name OKL_STRMTYP_SOURCE_V.name%type := null;
954: l_start_date okc_k_headers_b.start_date%type := null;
955: l_pdt_id okl_k_headers.pdt_id%type := null;
956: l_qte_id okl_k_lines.qte_id%type := null;
957: l_chk_qte_id okl_k_lines.qte_id%type := null;
958: l_roll_qt OKL_TRX_QUOTES_B.QUOTE_NUMBER%type := null;

Line 1031: from okc_k_headers_b chr, okl_k_headers khr

1027: and OKL_STRMTYP.STATUS = 'A';
1028:
1029: cursor l_start_date_csr IS
1030: select chr.start_date, khr.pdt_id
1031: from okc_k_headers_b chr, okl_k_headers khr
1032: where chr.id = p_fee_types_rec.dnz_chr_id
1033: and chr.id = khr.id;
1034:
1035: CURSOR l_roll_qt_csr(p_start_date okc_k_lines_b.start_date%type) IS

Line 1038: OKC_K_HEADERS_B chr

1034:
1035: CURSOR l_roll_qt_csr(p_start_date okc_k_lines_b.start_date%type) IS
1036: SELECT rqt.qte_id
1037: FROM OKL_LA_ROLLOVER_FEE_UV rqt,
1038: OKC_K_HEADERS_B chr
1039: WHERE CHR.CUST_ACCT_ID = rqt.cust_acct_id
1040: AND rqt.rollover_quote = p_fee_types_rec.roll_qt
1041: AND trunc(p_start_date) between nvl(trunc(date_effective_from),trunc(p_start_date))
1042: and nvl(trunc(date_effective_to),trunc(p_start_date+1))

Line 1048: OKC_K_HEADERS_B chr,

1044:
1045: CURSOR l_qte_id_csr(p_start_date okc_k_lines_b.start_date%type) IS
1046: SELECT rqt.rollover_quote
1047: FROM OKL_LA_ROLLOVER_FEE_UV rqt,
1048: OKC_K_HEADERS_B chr,
1049: okl_k_headers khr
1050: WHERE chr.id = khr.id
1051: and chr.currency_code = rqt.currency_code
1052: and CHR.CUST_ACCT_ID = rqt.cust_acct_id

Line 1061: OKC_K_HEADERS_B chr,

1057:
1058: CURSOR l_qte_id_prog_csr(p_start_date okc_k_lines_b.start_date%type) IS
1059: SELECT rqt.rollover_quote
1060: FROM OKL_LA_ROLLOVER_FEE_UV rqt,
1061: OKC_K_HEADERS_B chr,
1062: okl_k_headers khr
1063: WHERE chr.id = khr.id
1064: and chr.currency_code = rqt.currency_code
1065: and CHR.CUST_ACCT_ID = rqt.cust_acct_id

Line 1917: l_currency_code okc_k_headers_b.currency_code%type := null;

1913: l_api_version CONSTANT NUMBER := 1.0;
1914: l_ak_prompt AK_ATTRIBUTES_VL.attribute_label_long%type;
1915:
1916: l_lse_id OKC_LINE_STYLES_B.id%type := null;
1917: l_currency_code okc_k_headers_b.currency_code%type := null;
1918: l_sts_code okc_k_headers_b.sts_code%type := null;
1919:
1920: CURSOR get_lse_id_csr IS
1921: select id

Line 1918: l_sts_code okc_k_headers_b.sts_code%type := null;

1914: l_ak_prompt AK_ATTRIBUTES_VL.attribute_label_long%type;
1915:
1916: l_lse_id OKC_LINE_STYLES_B.id%type := null;
1917: l_currency_code okc_k_headers_b.currency_code%type := null;
1918: l_sts_code okc_k_headers_b.sts_code%type := null;
1919:
1920: CURSOR get_lse_id_csr IS
1921: select id
1922: from okc_line_styles_v

Line 1927: from okc_k_headers_b

1923: where lty_code = 'FEE';
1924:
1925: CURSOR get_cur_sts_code_csr(chr_id NUMBER) IS
1926: select currency_code,sts_code
1927: from okc_k_headers_b
1928: where id = chr_id;
1929:
1930: -- Modified by zrehman for Bug#6763287 on 17-Jan-2008 start
1931: l_is_investor NUMBER;

Line 2345: l_chr_id okc_k_headers_b.id%type := p_fee_types_rec.dnz_chr_id;

2341: lx_clev_rec okl_okc_migration_pvt.clev_rec_type;
2342: lx_cimv_rec okl_okc_migration_pvt.cimv_rec_type;
2343: lx_cplv_rec okl_okc_migration_pvt.cplv_rec_type;
2344:
2345: l_chr_id okc_k_headers_b.id%type := p_fee_types_rec.dnz_chr_id;
2346:
2347: l_api_name CONSTANT VARCHAR2(30) := 'create_fee_type';
2348: l_api_version CONSTANT NUMBER := 1.0;
2349: l_ak_prompt AK_ATTRIBUTES_VL.attribute_label_long%type;

Line 2781: l_chr_id okc_k_headers_b.id%type := p_fee_types_rec.dnz_chr_id;

2777: lx_clev_rec okl_okc_migration_pvt.clev_rec_type;
2778: lx_cimv_rec okl_okc_migration_pvt.cimv_rec_type;
2779: lx_cplv_rec okl_okc_migration_pvt.cplv_rec_type;
2780:
2781: l_chr_id okc_k_headers_b.id%type := p_fee_types_rec.dnz_chr_id;
2782: l_rgp_id okc_rules_v.id%type := null;
2783: l_rul_id okc_rules_v.id%type := null;
2784:
2785: l_api_name CONSTANT VARCHAR2(30) := 'update_fee_type';

Line 3081: from OKC_K_HEADERS_B chr

3077: l_fee_purpose_code okl_k_lines.fee_purpose_code%type;
3078:
3079: CURSOR l_rebook_csr IS
3080: select 'Y'
3081: from OKC_K_HEADERS_B chr
3082: where chr.id = p_fee_types_rec.dnz_chr_id
3083: and chr.orig_system_source_code = 'OKL_REBOOK';
3084:
3085: CURSOR c_sub_line_csr( p_line_id IN NUMBER, p_chr_id IN NUMBER) IS

Line 3419: l_chr_id okc_k_headers_b.id%type;

3415: lx_lapsth_rgpv_rec OKL_OKC_MIGRATION_PVT.rgpv_rec_type;
3416: lp_lastrm_rulv_rec Okl_Rule_Pub.rulv_rec_type;
3417: lx_lastrm_rulv_rec Okl_Rule_Pub.rulv_rec_type;
3418:
3419: l_chr_id okc_k_headers_b.id%type;
3420: l_rul_id okc_rules_v.id%type := null;
3421: l_rgp_id okc_rules_v.id%type := null;
3422: l_lapsth_rgp_id okc_rules_v.id%type := null;
3423:

Line 3681: l_chr_id okc_k_headers_b.id%type;

3677: lx_lapsth_rgpv_rec OKL_OKC_MIGRATION_PVT.rgpv_rec_type;
3678: lp_lastrm_rulv_rec Okl_Rule_Pub.rulv_rec_type;
3679: lx_lastrm_rulv_rec Okl_Rule_Pub.rulv_rec_type;
3680:
3681: l_chr_id okc_k_headers_b.id%type;
3682: l_object1_id1 okc_k_items_v.object1_id1%type := null;
3683: l_object1_id2 okc_k_items_v.object1_id2%type := null;
3684:
3685: l_api_name CONSTANT VARCHAR2(30) := 'create_strmtp_rul';

Line 3857: l_chr_id okc_k_headers_b.id%type;

3853: lx_lapsth_rgpv_rec OKL_OKC_MIGRATION_PVT.rgpv_rec_type;
3854: lp_lastrm_rulv_rec Okl_Rule_Pub.rulv_rec_type;
3855: lx_lastrm_rulv_rec Okl_Rule_Pub.rulv_rec_type;
3856:
3857: l_chr_id okc_k_headers_b.id%type;
3858: l_rgp_id okc_k_headers_b.id%type;
3859: l_object1_id1 okc_k_items_v.object1_id1%type := null;
3860: l_object1_id2 okc_k_items_v.object1_id2%type := null;
3861:

Line 3858: l_rgp_id okc_k_headers_b.id%type;

3854: lp_lastrm_rulv_rec Okl_Rule_Pub.rulv_rec_type;
3855: lx_lastrm_rulv_rec Okl_Rule_Pub.rulv_rec_type;
3856:
3857: l_chr_id okc_k_headers_b.id%type;
3858: l_rgp_id okc_k_headers_b.id%type;
3859: l_object1_id1 okc_k_items_v.object1_id1%type := null;
3860: l_object1_id2 okc_k_items_v.object1_id2%type := null;
3861:
3862: l_api_name CONSTANT VARCHAR2(30) := 'update_strmtp_rul';

Line 3990: p_chr_id IN OKC_K_HEADERS_B.ID%TYPE,

3986: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
3987: x_return_status OUT NOCOPY VARCHAR2,
3988: x_msg_count OUT NOCOPY NUMBER,
3989: x_msg_data OUT NOCOPY VARCHAR2,
3990: p_chr_id IN OKC_K_HEADERS_B.ID%TYPE,
3991: p_qte_id IN OKL_K_LINES.QTE_ID%TYPE,
3992: p_for_qa_check IN BOOLEAN DEFAULT FALSE) IS
3993:
3994: l_api_name CONSTANT VARCHAR2(30) := 'VALIDATE_ROLLOVER_FEELINE';

Line 4013: CURSOR l_con_qte_csr ( chrID OKC_K_HEADERS_B.ID%TYPE,

4009: l_do_validation VARCHAR2(1);
4010:
4011: /* Cursor to get the contract number and quote number. */
4012:
4013: CURSOR l_con_qte_csr ( chrID OKC_K_HEADERS_B.ID%TYPE,
4014: qteID OKL_K_LINES.QTE_ID%TYPE ) IS
4015: SELECT khr.contract_number, qte.quote_number
4016: FROM okc_k_headers_v khr,okl_trx_quotes_b qte
4017: WHERE khr.id = chrID

Line 4022: CURSOR l_fee_name_csr ( chrID OKC_K_HEADERS_B.ID%TYPE,

4018: AND qte.id = qteID;
4019:
4020: /* Cursor to get the Fee Name. */
4021:
4022: CURSOR l_fee_name_csr ( chrID OKC_K_HEADERS_B.ID%TYPE,
4023: qteID OKL_K_LINES.QTE_ID%TYPE ) IS
4024: SELECT cle.name
4025: FROM okc_k_headers_b khr,
4026: okl_k_lines kle,

Line 4025: FROM okc_k_headers_b khr,

4021:
4022: CURSOR l_fee_name_csr ( chrID OKC_K_HEADERS_B.ID%TYPE,
4023: qteID OKL_K_LINES.QTE_ID%TYPE ) IS
4024: SELECT cle.name
4025: FROM okc_k_headers_b khr,
4026: okl_k_lines kle,
4027: okc_k_lines_v cle,
4028: okl_trx_quotes_b qte
4029: WHERE cle.id = kle.id

Line 4038: CURSOR l_cust_accnt_csr ( chrID OKC_K_HEADERS_B.ID%TYPE,

4034:
4035: /* Cursor to check if the Customer Account on the current Contract
4036: and the contract on the quote match, if not throw an error. */
4037:
4038: CURSOR l_cust_accnt_csr ( chrID OKC_K_HEADERS_B.ID%TYPE,
4039: qteID OKL_K_LINES.QTE_ID%TYPE ) IS
4040: SELECT 1 FROM okc_k_headers_b
4041: WHERE id = chrID
4042: AND cust_acct_id = (SELECT khr.cust_acct_id FROM okc_k_headers_b khr,okl_trx_quotes_b qte

Line 4040: SELECT 1 FROM okc_k_headers_b

4036: and the contract on the quote match, if not throw an error. */
4037:
4038: CURSOR l_cust_accnt_csr ( chrID OKC_K_HEADERS_B.ID%TYPE,
4039: qteID OKL_K_LINES.QTE_ID%TYPE ) IS
4040: SELECT 1 FROM okc_k_headers_b
4041: WHERE id = chrID
4042: AND cust_acct_id = (SELECT khr.cust_acct_id FROM okc_k_headers_b khr,okl_trx_quotes_b qte
4043: WHERE khr.id = qte.khr_id
4044: AND qte.id = qteID);

Line 4042: AND cust_acct_id = (SELECT khr.cust_acct_id FROM okc_k_headers_b khr,okl_trx_quotes_b qte

4038: CURSOR l_cust_accnt_csr ( chrID OKC_K_HEADERS_B.ID%TYPE,
4039: qteID OKL_K_LINES.QTE_ID%TYPE ) IS
4040: SELECT 1 FROM okc_k_headers_b
4041: WHERE id = chrID
4042: AND cust_acct_id = (SELECT khr.cust_acct_id FROM okc_k_headers_b khr,okl_trx_quotes_b qte
4043: WHERE khr.id = qte.khr_id
4044: AND qte.id = qteID);
4045:
4046: /* Cursor to check if the Currency Code on the current Contract

Line 4049: CURSOR l_curr_code_csr ( chrID OKC_K_HEADERS_B.ID%TYPE,

4045:
4046: /* Cursor to check if the Currency Code on the current Contract
4047: and the contract on the quote match, if not throw an error. */
4048:
4049: CURSOR l_curr_code_csr ( chrID OKC_K_HEADERS_B.ID%TYPE,
4050: qteID OKL_K_LINES.QTE_ID%TYPE ) IS
4051: SELECT 1 FROM okc_k_headers_b
4052: WHERE id = chrID
4053: AND currency_code = (SELECT khr.currency_code FROM okc_k_headers_b khr,okl_trx_quotes_b qte

Line 4051: SELECT 1 FROM okc_k_headers_b

4047: and the contract on the quote match, if not throw an error. */
4048:
4049: CURSOR l_curr_code_csr ( chrID OKC_K_HEADERS_B.ID%TYPE,
4050: qteID OKL_K_LINES.QTE_ID%TYPE ) IS
4051: SELECT 1 FROM okc_k_headers_b
4052: WHERE id = chrID
4053: AND currency_code = (SELECT khr.currency_code FROM okc_k_headers_b khr,okl_trx_quotes_b qte
4054: WHERE khr.id = qte.khr_id
4055: AND qte.id = qteID);

Line 4053: AND currency_code = (SELECT khr.currency_code FROM okc_k_headers_b khr,okl_trx_quotes_b qte

4049: CURSOR l_curr_code_csr ( chrID OKC_K_HEADERS_B.ID%TYPE,
4050: qteID OKL_K_LINES.QTE_ID%TYPE ) IS
4051: SELECT 1 FROM okc_k_headers_b
4052: WHERE id = chrID
4053: AND currency_code = (SELECT khr.currency_code FROM okc_k_headers_b khr,okl_trx_quotes_b qte
4054: WHERE khr.id = qte.khr_id
4055: AND qte.id = qteID);
4056:
4057: /* Cursor to check if the Quote status is Approved, if not throw an error. */

Line 4082: CURSOR l_rq_fee_check_csr ( chrID OKC_K_HEADERS_B.ID%TYPE,

4078:
4079: /* Cursor to check if the Rollover Fee Start date is between Quote
4080: effective dates, if not throw an error. */
4081:
4082: CURSOR l_rq_fee_check_csr ( chrID OKC_K_HEADERS_B.ID%TYPE,
4083: qteID OKL_K_LINES.QTE_ID%TYPE ) IS
4084: SELECT 1
4085: FROM okc_k_headers_b khr,
4086: okl_k_lines kle,

Line 4085: FROM okc_k_headers_b khr,

4081:
4082: CURSOR l_rq_fee_check_csr ( chrID OKC_K_HEADERS_B.ID%TYPE,
4083: qteID OKL_K_LINES.QTE_ID%TYPE ) IS
4084: SELECT 1
4085: FROM okc_k_headers_b khr,
4086: okl_k_lines kle,
4087: okc_k_lines_b cle,
4088: okl_trx_quotes_b qte
4089: WHERE cle.id = kle.id

Line 4103: FROM okc_k_headers_b khr1

4099: WHERE okcsts.code = cle.sts_code
4100: AND okcsts.ste_code IN ('EXPIRED','HOLD','CANCELLED','TERMINATED', 'ABANDONED'))
4101: AND NOT EXISTS (
4102: SELECT 'Y'
4103: FROM okc_k_headers_b khr1
4104: WHERE khr1.id = chrID
4105: AND khr1.orig_system_source_code IN ('OKL_RELEASE'));
4106:
4107: /* Cursor to check if the Rollover Quote Amount is equal to

Line 4111: CURSOR l_rq_amt_check_csr ( chrID OKC_K_HEADERS_B.ID%TYPE,

4107: /* Cursor to check if the Rollover Quote Amount is equal to
4108: Rollover Fee line amount on the contract, if not throw an error. */
4109:
4110: -- AKJAIN fixed bug 4198968
4111: CURSOR l_rq_amt_check_csr ( chrID OKC_K_HEADERS_B.ID%TYPE,
4112: qteID OKL_K_LINES.QTE_ID%TYPE ) IS
4113: (SELECT SUM(tql.amount)
4114: FROM okl_trx_quotes_b qte, okl_txl_quote_lines_b tql
4115: WHERE qte.id = qteID

Line 4132: FROM okc_k_headers_b khr1

4128: AND okcsts.ste_code IN ('EXPIRED','HOLD','CANCELLED','TERMINATED', 'ABANDONED'))
4129: /* Added to exclude this check for Re-lease contracts. */
4130: AND NOT EXISTS (
4131: SELECT 'Y'
4132: FROM okc_k_headers_b khr1
4133: WHERE khr1.id = chrID
4134: AND khr1.orig_system_source_code IN ('OKL_RELEASE')));
4135:
4136: /* Cursor to check if it is a Re-book contract.

Line 4138: CURSOR l_rebook_chk_csr ( p_chr_id OKC_K_HEADERS_B.ID%TYPE) IS

4134: AND khr1.orig_system_source_code IN ('OKL_RELEASE')));
4135:
4136: /* Cursor to check if it is a Re-book contract.
4137: If yes, ignore approval step else continue all the checks */
4138: CURSOR l_rebook_chk_csr ( p_chr_id OKC_K_HEADERS_B.ID%TYPE) IS
4139: SELECT 'Y'
4140: FROM okc_k_headers_b
4141: WHERE orig_system_source_code = 'OKL_REBOOK'
4142: AND id = p_chr_id;

Line 4140: FROM okc_k_headers_b

4136: /* Cursor to check if it is a Re-book contract.
4137: If yes, ignore approval step else continue all the checks */
4138: CURSOR l_rebook_chk_csr ( p_chr_id OKC_K_HEADERS_B.ID%TYPE) IS
4139: SELECT 'Y'
4140: FROM okc_k_headers_b
4141: WHERE orig_system_source_code = 'OKL_REBOOK'
4142: AND id = p_chr_id;
4143:
4144: /* Cursor to check if orig_system_id1 exists for a re-book contract

Line 4146: CURSOR l_orig_sys_id1_csr ( p_chr_id OKC_K_HEADERS_B.ID%TYPE, p_qte_id OKL_K_LINES.QTE_ID%TYPE ) IS

4142: AND id = p_chr_id;
4143:
4144: /* Cursor to check if orig_system_id1 exists for a re-book contract
4145: If yes, ignore approval step else continue all the checks */
4146: CURSOR l_orig_sys_id1_csr ( p_chr_id OKC_K_HEADERS_B.ID%TYPE, p_qte_id OKL_K_LINES.QTE_ID%TYPE ) IS
4147: SELECT orig_system_id1
4148: FROM okc_k_lines_b cle,
4149: okl_k_lines kle
4150: WHERE cle.id = kle.id

Line 4155: CURSOR l_mass_rebook_csr ( p_chr_id OKC_K_HEADERS_B.ID%TYPE ) IS

4151: AND dnz_chr_id = p_chr_id
4152: AND kle.qte_id = p_qte_id;
4153:
4154: /* Check if it a mass re-book contract */
4155: CURSOR l_mass_rebook_csr ( p_chr_id OKC_K_HEADERS_B.ID%TYPE ) IS
4156: SELECT COUNT(1)
4157: FROM okl_rbk_selected_contract
4158: WHERE khr_id = p_chr_id
4159: AND NVL(status,'NEW') = 'UNDER REVISION';

Line 4577: l_chr_id okc_k_headers_b.id%type;

4573: and lse.id = cle.lse_id
4574: and lse.lty_code = 'FEE'
4575: and fee_type = 'ROLLOVER';
4576:
4577: l_chr_id okc_k_headers_b.id%type;
4578: l_prev_roll_amount number := null;
4579: l_roll_amt number := null;
4580: l_tot_roll_amt number := null;
4581:

Line 4719: FROM okc_k_headers_b khr, okc_k_lines_b cleb, okl_k_lines kle

4715: that is booked for the first time. */
4716:
4717: CURSOR l_rq_fee_lns_bkg_csr ( p_chr_id number ) IS
4718: SELECT kle.qte_id
4719: FROM okc_k_headers_b khr, okc_k_lines_b cleb, okl_k_lines kle
4720: WHERE khr.id = p_chr_id
4721: AND cleb.dnz_chr_id = khr.id
4722: AND kle.ID = cleb.ID
4723: AND kle.fee_type = 'ROLLOVER';

Line 4727: FROM okc_k_headers_b khr

4723: AND kle.fee_type = 'ROLLOVER';
4724:
4725: CURSOR l_orig_src_code_csr ( p_chr_id number ) IS
4726: SELECT nvl(ORIG_SYSTEM_SOURCE_CODE,'XXX')
4727: FROM okc_k_headers_b khr
4728: WHERE khr.id = p_chr_id;
4729:
4730: l_orig_src_code okc_k_headers_b.orig_system_source_code%type := null;
4731: l_cl_roll_amt NUMBER := 0;

Line 4730: l_orig_src_code okc_k_headers_b.orig_system_source_code%type := null;

4726: SELECT nvl(ORIG_SYSTEM_SOURCE_CODE,'XXX')
4727: FROM okc_k_headers_b khr
4728: WHERE khr.id = p_chr_id;
4729:
4730: l_orig_src_code okc_k_headers_b.orig_system_source_code%type := null;
4731: l_cl_roll_amt NUMBER := 0;
4732: l_cl_tot_roll_amt NUMBER := 0;
4733: l_chr_id okc_k_headers_b.id%type;
4734: l_cl_id okc_k_headers_b.id%type := null;

Line 4733: l_chr_id okc_k_headers_b.id%type;

4729:
4730: l_orig_src_code okc_k_headers_b.orig_system_source_code%type := null;
4731: l_cl_roll_amt NUMBER := 0;
4732: l_cl_tot_roll_amt NUMBER := 0;
4733: l_chr_id okc_k_headers_b.id%type;
4734: l_cl_id okc_k_headers_b.id%type := null;
4735: l_qte_id number := null;
4736: l_cl_rem_amt number := null;
4737: l_prev_roll_amount number := null;

Line 4734: l_cl_id okc_k_headers_b.id%type := null;

4730: l_orig_src_code okc_k_headers_b.orig_system_source_code%type := null;
4731: l_cl_roll_amt NUMBER := 0;
4732: l_cl_tot_roll_amt NUMBER := 0;
4733: l_chr_id okc_k_headers_b.id%type;
4734: l_cl_id okc_k_headers_b.id%type := null;
4735: l_qte_id number := null;
4736: l_cl_rem_amt number := null;
4737: l_prev_roll_amount number := null;
4738: l_roll_amt number := null;

Line 4949: FROM okc_k_headers_b

4945: END IF;
4946:
4947: SELECT currency_code
4948: INTO l_currency_code
4949: FROM okc_k_headers_b
4950: WHERE id = p_chr_id;
4951:
4952: l_link_asset_tbl := p_link_asset_tbl;
4953:

Line 5216: l_chr_id okc_k_headers_b.id%type := null;

5212: x_msg_count OUT NOCOPY NUMBER,
5213: x_msg_data OUT NOCOPY VARCHAR2) IS
5214:
5215:
5216: l_chr_id okc_k_headers_b.id%type := null;
5217: l_cl_id okc_k_headers_b.id%type := null;
5218:
5219: l_api_name CONSTANT VARCHAR2(30) := 'allocate_amount';
5220: l_api_version CONSTANT NUMBER := 1.0;

Line 5217: l_cl_id okc_k_headers_b.id%type := null;

5213: x_msg_data OUT NOCOPY VARCHAR2) IS
5214:
5215:
5216: l_chr_id okc_k_headers_b.id%type := null;
5217: l_cl_id okc_k_headers_b.id%type := null;
5218:
5219: l_api_name CONSTANT VARCHAR2(30) := 'allocate_amount';
5220: l_api_version CONSTANT NUMBER := 1.0;
5221:

Line 5483: l_orig_system_source_code okc_k_headers_b.orig_system_source_code%type;

5479: l_ak_prompt AK_ATTRIBUTES_VL.attribute_label_long%type;
5480: l_check_box_val VARCHAR2(450);
5481: l_cim_id NUMBER;
5482: --Bug# 4524091
5483: l_orig_system_source_code okc_k_headers_b.orig_system_source_code%type;
5484:
5485: BEGIN
5486:
5487: l_chr_id := p_fee_types_rec.dnz_chr_id;