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 869: p_chr_id IN okc_k_headers_b.id%TYPE,

865: p_init_msg_list IN VARCHAR2,
866: x_return_status OUT NOCOPY VARCHAR2,
867: x_msg_count OUT NOCOPY NUMBER,
868: x_msg_data OUT NOCOPY VARCHAR2,
869: p_chr_id IN okc_k_headers_b.id%TYPE,
870: p_fee_line_id IN okc_k_lines_b.id%TYPE,
871: p_event_name IN wf_events.name%TYPE) IS
872:
873: l_parameter_list wf_parameter_list_t;

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

959: l_supp_id okx_vendors_v.id1%type := null;
960: l_party_name okx_vendors_v.name%type := null;
961: l_item_id NUMBER:= null;
962: l_item_name OKL_STRMTYP_SOURCE_V.name%type := null;
963: l_start_date okc_k_headers_b.start_date%type := null;
964: l_pdt_id okl_k_headers.pdt_id%type := null;
965: l_qte_id okl_k_lines.qte_id%type := null;
966: l_chk_qte_id okl_k_lines.qte_id%type := null;
967: l_roll_qt OKL_TRX_QUOTES_B.QUOTE_NUMBER%type := null;

Line 1040: from okc_k_headers_b chr, okl_k_headers khr

1036: and OKL_STRMTYP.STATUS = 'A';
1037:
1038: cursor l_start_date_csr IS
1039: select chr.start_date, khr.pdt_id
1040: from okc_k_headers_b chr, okl_k_headers khr
1041: where chr.id = p_fee_types_rec.dnz_chr_id
1042: and chr.id = khr.id;
1043:
1044: CURSOR l_roll_qt_csr(p_start_date okc_k_lines_b.start_date%type) IS

Line 1047: OKC_K_HEADERS_B chr

1043:
1044: CURSOR l_roll_qt_csr(p_start_date okc_k_lines_b.start_date%type) IS
1045: SELECT rqt.qte_id
1046: FROM OKL_LA_ROLLOVER_FEE_UV rqt,
1047: OKC_K_HEADERS_B chr
1048: WHERE CHR.CUST_ACCT_ID = rqt.cust_acct_id
1049: AND rqt.rollover_quote = p_fee_types_rec.roll_qt
1050: AND trunc(p_start_date) between nvl(trunc(date_effective_from),trunc(p_start_date))
1051: and nvl(trunc(date_effective_to),trunc(p_start_date+1))

Line 1057: OKC_K_HEADERS_B chr,

1053:
1054: CURSOR l_qte_id_csr(p_start_date okc_k_lines_b.start_date%type) IS
1055: SELECT rqt.rollover_quote
1056: FROM OKL_LA_ROLLOVER_FEE_UV rqt,
1057: OKC_K_HEADERS_B chr,
1058: okl_k_headers khr
1059: WHERE chr.id = khr.id
1060: and chr.currency_code = rqt.currency_code
1061: and CHR.CUST_ACCT_ID = rqt.cust_acct_id

Line 1070: OKC_K_HEADERS_B chr,

1066:
1067: CURSOR l_qte_id_prog_csr(p_start_date okc_k_lines_b.start_date%type) IS
1068: SELECT rqt.rollover_quote
1069: FROM OKL_LA_ROLLOVER_FEE_UV rqt,
1070: OKC_K_HEADERS_B chr,
1071: okl_k_headers khr
1072: WHERE chr.id = khr.id
1073: and chr.currency_code = rqt.currency_code
1074: and CHR.CUST_ACCT_ID = rqt.cust_acct_id

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

1922: l_api_version CONSTANT NUMBER := 1.0;
1923: l_ak_prompt AK_ATTRIBUTES_VL.attribute_label_long%type;
1924:
1925: l_lse_id OKC_LINE_STYLES_B.id%type := null;
1926: l_currency_code okc_k_headers_b.currency_code%type := null;
1927: l_sts_code okc_k_headers_b.sts_code%type := null;
1928:
1929: CURSOR get_lse_id_csr IS
1930: select id

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

1923: l_ak_prompt AK_ATTRIBUTES_VL.attribute_label_long%type;
1924:
1925: l_lse_id OKC_LINE_STYLES_B.id%type := null;
1926: l_currency_code okc_k_headers_b.currency_code%type := null;
1927: l_sts_code okc_k_headers_b.sts_code%type := null;
1928:
1929: CURSOR get_lse_id_csr IS
1930: select id
1931: from okc_line_styles_v

Line 1936: from okc_k_headers_b

1932: where lty_code = 'FEE';
1933:
1934: CURSOR get_cur_sts_code_csr(chr_id NUMBER) IS
1935: select currency_code,sts_code
1936: from okc_k_headers_b
1937: where id = chr_id;
1938:
1939: -- Modified by zrehman for Bug#6763287 on 17-Jan-2008 start
1940: l_is_investor NUMBER;

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

2354: lx_clev_rec okl_okc_migration_pvt.clev_rec_type;
2355: lx_cimv_rec okl_okc_migration_pvt.cimv_rec_type;
2356: lx_cplv_rec okl_okc_migration_pvt.cplv_rec_type;
2357:
2358: l_chr_id okc_k_headers_b.id%type := p_fee_types_rec.dnz_chr_id;
2359:
2360: l_api_name CONSTANT VARCHAR2(30) := 'create_fee_type';
2361: l_api_version CONSTANT NUMBER := 1.0;
2362: l_ak_prompt AK_ATTRIBUTES_VL.attribute_label_long%type;

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

2790: lx_clev_rec okl_okc_migration_pvt.clev_rec_type;
2791: lx_cimv_rec okl_okc_migration_pvt.cimv_rec_type;
2792: lx_cplv_rec okl_okc_migration_pvt.cplv_rec_type;
2793:
2794: l_chr_id okc_k_headers_b.id%type := p_fee_types_rec.dnz_chr_id;
2795: l_rgp_id okc_rules_v.id%type := null;
2796: l_rul_id okc_rules_v.id%type := null;
2797:
2798: l_api_name CONSTANT VARCHAR2(30) := 'update_fee_type';

Line 3094: from OKC_K_HEADERS_B chr

3090: l_fee_purpose_code okl_k_lines.fee_purpose_code%type;
3091:
3092: CURSOR l_rebook_csr IS
3093: select 'Y'
3094: from OKC_K_HEADERS_B chr
3095: where chr.id = p_fee_types_rec.dnz_chr_id
3096: and chr.orig_system_source_code = 'OKL_REBOOK';
3097:
3098: CURSOR c_sub_line_csr( p_line_id IN NUMBER, p_chr_id IN NUMBER) IS

Line 3432: l_chr_id okc_k_headers_b.id%type;

3428: lx_lapsth_rgpv_rec OKL_OKC_MIGRATION_PVT.rgpv_rec_type;
3429: lp_lastrm_rulv_rec Okl_Rule_Pub.rulv_rec_type;
3430: lx_lastrm_rulv_rec Okl_Rule_Pub.rulv_rec_type;
3431:
3432: l_chr_id okc_k_headers_b.id%type;
3433: l_rul_id okc_rules_v.id%type := null;
3434: l_rgp_id okc_rules_v.id%type := null;
3435: l_lapsth_rgp_id okc_rules_v.id%type := null;
3436:

Line 3694: l_chr_id okc_k_headers_b.id%type;

3690: lx_lapsth_rgpv_rec OKL_OKC_MIGRATION_PVT.rgpv_rec_type;
3691: lp_lastrm_rulv_rec Okl_Rule_Pub.rulv_rec_type;
3692: lx_lastrm_rulv_rec Okl_Rule_Pub.rulv_rec_type;
3693:
3694: l_chr_id okc_k_headers_b.id%type;
3695: l_object1_id1 okc_k_items_v.object1_id1%type := null;
3696: l_object1_id2 okc_k_items_v.object1_id2%type := null;
3697:
3698: l_api_name CONSTANT VARCHAR2(30) := 'create_strmtp_rul';

Line 3870: l_chr_id okc_k_headers_b.id%type;

3866: lx_lapsth_rgpv_rec OKL_OKC_MIGRATION_PVT.rgpv_rec_type;
3867: lp_lastrm_rulv_rec Okl_Rule_Pub.rulv_rec_type;
3868: lx_lastrm_rulv_rec Okl_Rule_Pub.rulv_rec_type;
3869:
3870: l_chr_id okc_k_headers_b.id%type;
3871: l_rgp_id okc_k_headers_b.id%type;
3872: l_object1_id1 okc_k_items_v.object1_id1%type := null;
3873: l_object1_id2 okc_k_items_v.object1_id2%type := null;
3874:

Line 3871: l_rgp_id okc_k_headers_b.id%type;

3867: lp_lastrm_rulv_rec Okl_Rule_Pub.rulv_rec_type;
3868: lx_lastrm_rulv_rec Okl_Rule_Pub.rulv_rec_type;
3869:
3870: l_chr_id okc_k_headers_b.id%type;
3871: l_rgp_id okc_k_headers_b.id%type;
3872: l_object1_id1 okc_k_items_v.object1_id1%type := null;
3873: l_object1_id2 okc_k_items_v.object1_id2%type := null;
3874:
3875: l_api_name CONSTANT VARCHAR2(30) := 'update_strmtp_rul';

Line 4003: p_chr_id IN OKC_K_HEADERS_B.ID%TYPE,

3999: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
4000: x_return_status OUT NOCOPY VARCHAR2,
4001: x_msg_count OUT NOCOPY NUMBER,
4002: x_msg_data OUT NOCOPY VARCHAR2,
4003: p_chr_id IN OKC_K_HEADERS_B.ID%TYPE,
4004: p_qte_id IN OKL_K_LINES.QTE_ID%TYPE,
4005: p_for_qa_check IN BOOLEAN DEFAULT FALSE) IS
4006:
4007: l_api_name CONSTANT VARCHAR2(30) := 'VALIDATE_ROLLOVER_FEELINE';

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

4022: l_do_validation VARCHAR2(1);
4023:
4024: /* Cursor to get the contract number and quote number. */
4025:
4026: CURSOR l_con_qte_csr ( chrID OKC_K_HEADERS_B.ID%TYPE,
4027: qteID OKL_K_LINES.QTE_ID%TYPE ) IS
4028: SELECT khr.contract_number, qte.quote_number
4029: FROM okc_k_headers_v khr,okl_trx_quotes_b qte
4030: WHERE khr.id = chrID

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

4031: AND qte.id = qteID;
4032:
4033: /* Cursor to get the Fee Name. */
4034:
4035: CURSOR l_fee_name_csr ( chrID OKC_K_HEADERS_B.ID%TYPE,
4036: qteID OKL_K_LINES.QTE_ID%TYPE ) IS
4037: SELECT cle.name
4038: FROM okc_k_headers_b khr,
4039: okl_k_lines kle,

Line 4038: FROM okc_k_headers_b khr,

4034:
4035: CURSOR l_fee_name_csr ( chrID OKC_K_HEADERS_B.ID%TYPE,
4036: qteID OKL_K_LINES.QTE_ID%TYPE ) IS
4037: SELECT cle.name
4038: FROM okc_k_headers_b khr,
4039: okl_k_lines kle,
4040: okc_k_lines_v cle,
4041: okl_trx_quotes_b qte
4042: WHERE cle.id = kle.id

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

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

Line 4053: SELECT 1 FROM okc_k_headers_b

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

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

4051: CURSOR l_cust_accnt_csr ( chrID OKC_K_HEADERS_B.ID%TYPE,
4052: qteID OKL_K_LINES.QTE_ID%TYPE ) IS
4053: SELECT 1 FROM okc_k_headers_b
4054: WHERE id = chrID
4055: AND cust_acct_id = (SELECT khr.cust_acct_id FROM okc_k_headers_b khr,okl_trx_quotes_b qte
4056: WHERE khr.id = qte.khr_id
4057: AND qte.id = qteID);
4058:
4059: /* Cursor to check if the Currency Code on the current Contract

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

4058:
4059: /* Cursor to check if the Currency Code on the current Contract
4060: and the contract on the quote match, if not throw an error. */
4061:
4062: CURSOR l_curr_code_csr ( chrID OKC_K_HEADERS_B.ID%TYPE,
4063: qteID OKL_K_LINES.QTE_ID%TYPE ) IS
4064: SELECT 1 FROM okc_k_headers_b
4065: WHERE id = chrID
4066: AND currency_code = (SELECT khr.currency_code FROM okc_k_headers_b khr,okl_trx_quotes_b qte

Line 4064: SELECT 1 FROM okc_k_headers_b

4060: and the contract on the quote match, if not throw an error. */
4061:
4062: CURSOR l_curr_code_csr ( chrID OKC_K_HEADERS_B.ID%TYPE,
4063: qteID OKL_K_LINES.QTE_ID%TYPE ) IS
4064: SELECT 1 FROM okc_k_headers_b
4065: WHERE id = chrID
4066: AND currency_code = (SELECT khr.currency_code FROM okc_k_headers_b khr,okl_trx_quotes_b qte
4067: WHERE khr.id = qte.khr_id
4068: AND qte.id = qteID);

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

4062: CURSOR l_curr_code_csr ( chrID OKC_K_HEADERS_B.ID%TYPE,
4063: qteID OKL_K_LINES.QTE_ID%TYPE ) IS
4064: SELECT 1 FROM okc_k_headers_b
4065: WHERE id = chrID
4066: AND currency_code = (SELECT khr.currency_code FROM okc_k_headers_b khr,okl_trx_quotes_b qte
4067: WHERE khr.id = qte.khr_id
4068: AND qte.id = qteID);
4069:
4070: /* Cursor to check if the Quote status is Approved, if not throw an error. */

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

4091:
4092: /* Cursor to check if the Rollover Fee Start date is between Quote
4093: effective dates, if not throw an error. */
4094:
4095: CURSOR l_rq_fee_check_csr ( chrID OKC_K_HEADERS_B.ID%TYPE,
4096: qteID OKL_K_LINES.QTE_ID%TYPE ) IS
4097: SELECT 1
4098: FROM okc_k_headers_b khr,
4099: okl_k_lines kle,

Line 4098: FROM okc_k_headers_b khr,

4094:
4095: CURSOR l_rq_fee_check_csr ( chrID OKC_K_HEADERS_B.ID%TYPE,
4096: qteID OKL_K_LINES.QTE_ID%TYPE ) IS
4097: SELECT 1
4098: FROM okc_k_headers_b khr,
4099: okl_k_lines kle,
4100: okc_k_lines_b cle,
4101: okl_trx_quotes_b qte
4102: WHERE cle.id = kle.id

Line 4116: FROM okc_k_headers_b khr1

4112: WHERE okcsts.code = cle.sts_code
4113: AND okcsts.ste_code IN ('EXPIRED','HOLD','CANCELLED','TERMINATED', 'ABANDONED'))
4114: AND NOT EXISTS (
4115: SELECT 'Y'
4116: FROM okc_k_headers_b khr1
4117: WHERE khr1.id = chrID
4118: AND khr1.orig_system_source_code IN ('OKL_RELEASE'));
4119:
4120: /* Cursor to check if the Rollover Quote Amount is equal to

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

4120: /* Cursor to check if the Rollover Quote Amount is equal to
4121: Rollover Fee line amount on the contract, if not throw an error. */
4122:
4123: -- AKJAIN fixed bug 4198968
4124: CURSOR l_rq_amt_check_csr ( chrID OKC_K_HEADERS_B.ID%TYPE,
4125: qteID OKL_K_LINES.QTE_ID%TYPE ) IS
4126: (SELECT SUM(tql.amount)
4127: FROM okl_trx_quotes_b qte, okl_txl_quote_lines_b tql
4128: WHERE qte.id = qteID

Line 4145: FROM okc_k_headers_b khr1

4141: AND okcsts.ste_code IN ('EXPIRED','HOLD','CANCELLED','TERMINATED', 'ABANDONED'))
4142: /* Added to exclude this check for Re-lease contracts. */
4143: AND NOT EXISTS (
4144: SELECT 'Y'
4145: FROM okc_k_headers_b khr1
4146: WHERE khr1.id = chrID
4147: AND khr1.orig_system_source_code IN ('OKL_RELEASE')));
4148:
4149: /* Cursor to check if it is a Re-book contract.

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

4147: AND khr1.orig_system_source_code IN ('OKL_RELEASE')));
4148:
4149: /* Cursor to check if it is a Re-book contract.
4150: If yes, ignore approval step else continue all the checks */
4151: CURSOR l_rebook_chk_csr ( p_chr_id OKC_K_HEADERS_B.ID%TYPE) IS
4152: SELECT 'Y'
4153: FROM okc_k_headers_b
4154: WHERE orig_system_source_code = 'OKL_REBOOK'
4155: AND id = p_chr_id;

Line 4153: FROM okc_k_headers_b

4149: /* Cursor to check if it is a Re-book contract.
4150: If yes, ignore approval step else continue all the checks */
4151: CURSOR l_rebook_chk_csr ( p_chr_id OKC_K_HEADERS_B.ID%TYPE) IS
4152: SELECT 'Y'
4153: FROM okc_k_headers_b
4154: WHERE orig_system_source_code = 'OKL_REBOOK'
4155: AND id = p_chr_id;
4156:
4157: /* Cursor to check if orig_system_id1 exists for a re-book contract

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

4155: AND id = p_chr_id;
4156:
4157: /* Cursor to check if orig_system_id1 exists for a re-book contract
4158: If yes, ignore approval step else continue all the checks */
4159: 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
4160: SELECT orig_system_id1
4161: FROM okc_k_lines_b cle,
4162: okl_k_lines kle
4163: WHERE cle.id = kle.id

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

4164: AND dnz_chr_id = p_chr_id
4165: AND kle.qte_id = p_qte_id;
4166:
4167: /* Check if it a mass re-book contract */
4168: CURSOR l_mass_rebook_csr ( p_chr_id OKC_K_HEADERS_B.ID%TYPE ) IS
4169: SELECT COUNT(1)
4170: FROM okl_rbk_selected_contract
4171: WHERE khr_id = p_chr_id
4172: AND NVL(status,'NEW') = 'UNDER REVISION';

Line 4590: l_chr_id okc_k_headers_b.id%type;

4586: and lse.id = cle.lse_id
4587: and lse.lty_code = 'FEE'
4588: and fee_type = 'ROLLOVER';
4589:
4590: l_chr_id okc_k_headers_b.id%type;
4591: l_prev_roll_amount number := null;
4592: l_roll_amt number := null;
4593: l_tot_roll_amt number := null;
4594:

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

4728: that is booked for the first time. */
4729:
4730: CURSOR l_rq_fee_lns_bkg_csr ( p_chr_id number ) IS
4731: SELECT kle.qte_id
4732: FROM okc_k_headers_b khr, okc_k_lines_b cleb, okl_k_lines kle
4733: WHERE khr.id = p_chr_id
4734: AND cleb.dnz_chr_id = khr.id
4735: AND kle.ID = cleb.ID
4736: AND kle.fee_type = 'ROLLOVER';

Line 4740: FROM okc_k_headers_b khr

4736: AND kle.fee_type = 'ROLLOVER';
4737:
4738: CURSOR l_orig_src_code_csr ( p_chr_id number ) IS
4739: SELECT nvl(ORIG_SYSTEM_SOURCE_CODE,'XXX')
4740: FROM okc_k_headers_b khr
4741: WHERE khr.id = p_chr_id;
4742:
4743: l_orig_src_code okc_k_headers_b.orig_system_source_code%type := null;
4744: l_cl_roll_amt NUMBER := 0;

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

4739: SELECT nvl(ORIG_SYSTEM_SOURCE_CODE,'XXX')
4740: FROM okc_k_headers_b khr
4741: WHERE khr.id = p_chr_id;
4742:
4743: l_orig_src_code okc_k_headers_b.orig_system_source_code%type := null;
4744: l_cl_roll_amt NUMBER := 0;
4745: l_cl_tot_roll_amt NUMBER := 0;
4746: l_chr_id okc_k_headers_b.id%type;
4747: l_cl_id okc_k_headers_b.id%type := null;

Line 4746: l_chr_id okc_k_headers_b.id%type;

4742:
4743: l_orig_src_code okc_k_headers_b.orig_system_source_code%type := null;
4744: l_cl_roll_amt NUMBER := 0;
4745: l_cl_tot_roll_amt NUMBER := 0;
4746: l_chr_id okc_k_headers_b.id%type;
4747: l_cl_id okc_k_headers_b.id%type := null;
4748: l_qte_id number := null;
4749: l_cl_rem_amt number := null;
4750: l_prev_roll_amount number := null;

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

4743: l_orig_src_code okc_k_headers_b.orig_system_source_code%type := null;
4744: l_cl_roll_amt NUMBER := 0;
4745: l_cl_tot_roll_amt NUMBER := 0;
4746: l_chr_id okc_k_headers_b.id%type;
4747: l_cl_id okc_k_headers_b.id%type := null;
4748: l_qte_id number := null;
4749: l_cl_rem_amt number := null;
4750: l_prev_roll_amount number := null;
4751: l_roll_amt number := null;

Line 4962: FROM okc_k_headers_b

4958: END IF;
4959:
4960: SELECT currency_code
4961: INTO l_currency_code
4962: FROM okc_k_headers_b
4963: WHERE id = p_chr_id;
4964:
4965: l_link_asset_tbl := p_link_asset_tbl;
4966:

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

5225: x_msg_count OUT NOCOPY NUMBER,
5226: x_msg_data OUT NOCOPY VARCHAR2) IS
5227:
5228:
5229: l_chr_id okc_k_headers_b.id%type := null;
5230: l_cl_id okc_k_headers_b.id%type := null;
5231:
5232: l_api_name CONSTANT VARCHAR2(30) := 'allocate_amount';
5233: l_api_version CONSTANT NUMBER := 1.0;

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

5226: x_msg_data OUT NOCOPY VARCHAR2) IS
5227:
5228:
5229: l_chr_id okc_k_headers_b.id%type := null;
5230: l_cl_id okc_k_headers_b.id%type := null;
5231:
5232: l_api_name CONSTANT VARCHAR2(30) := 'allocate_amount';
5233: l_api_version CONSTANT NUMBER := 1.0;
5234:

Line 5496: l_orig_system_source_code okc_k_headers_b.orig_system_source_code%type;

5492: l_ak_prompt AK_ATTRIBUTES_VL.attribute_label_long%type;
5493: l_check_box_val VARCHAR2(450);
5494: l_cim_id NUMBER;
5495: --Bug# 4524091
5496: l_orig_system_source_code okc_k_headers_b.orig_system_source_code%type;
5497:
5498: --Bug# 8652738
5499: l_orig_check_box_value OKC_RULES_B.rule_information1%TYPE;
5500: l_orig_chr_id OKC_K_HEADERS_B.id%TYPE;

Line 5500: l_orig_chr_id OKC_K_HEADERS_B.id%TYPE;

5496: l_orig_system_source_code okc_k_headers_b.orig_system_source_code%type;
5497:
5498: --Bug# 8652738
5499: l_orig_check_box_value OKC_RULES_B.rule_information1%TYPE;
5500: l_orig_chr_id OKC_K_HEADERS_B.id%TYPE;
5501:
5502: BEGIN
5503:
5504: l_chr_id := p_fee_types_rec.dnz_chr_id;