APPS.OKL_ACCOUNT_DIST_PVT dependencies on OKL_FORMULAE_V

Line 717: l_formula_name OKL_FORMULAE_V.NAME%TYPE;

713: l_init_msg_list VARCHAR2(1) := OKL_API.G_FALSE;
714: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
715: l_msg_count NUMBER := 0;
716: l_msg_data VARCHAR2(2000);
717: l_formula_name OKL_FORMULAE_V.NAME%TYPE;
718:
719: CURSOR frml_csr(v_id NUMBER) IS
720: SELECT name
721: FROM okl_formulae_v

Line 721: FROM okl_formulae_v

717: l_formula_name OKL_FORMULAE_V.NAME%TYPE;
718:
719: CURSOR frml_csr(v_id NUMBER) IS
720: SELECT name
721: FROM okl_formulae_v
722: WHERE id = v_id;
723:
724: BEGIN
725:

Line 2421: l_formula_name OKL_FORMULAE_V.NAME%TYPE;

2417: l_amount NUMBER := 0;
2418:
2419: tmpl_rec AVLV_REC_TYPE;
2420: l_tmpl_tbl avlv_tbl_type;
2421: l_formula_name OKL_FORMULAE_V.NAME%TYPE;
2422: l_functional_curr OKL_TRNS_ACC_DSTRS.CURRENCY_CODE%TYPE;
2423: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
2424:
2425: l_api_name VARCHAR2(30) := 'CREATE_ACCOUNTING_DIST';

Line 2442: FROM okl_formulae_v

2438:
2439:
2440: CURSOR frml_csr(v_id NUMBER) IS
2441: SELECT name
2442: FROM okl_formulae_v
2443: WHERE id = v_id;
2444:
2445: -- Added by Santonyr on 30-Jul-2003 to fix the bug 2941805
2446:

Line 3915: l_formula_name OKL_FORMULAE_V.NAME%TYPE;

3911: l_amount NUMBER := 0;
3912:
3913: tmpl_rec AVLV_REC_TYPE;
3914: l_tmpl_tbl avlv_tbl_type;
3915: l_formula_name OKL_FORMULAE_V.NAME%TYPE;
3916: l_functional_curr OKL_TRNS_ACC_DSTRS.CURRENCY_CODE%TYPE;
3917: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
3918:
3919: l_api_name VARCHAR2(30) := 'CREATE_ACCOUNTING_DIST';

Line 3936: FROM okl_formulae_v

3932:
3933:
3934: CURSOR frml_csr(v_id NUMBER) IS
3935: SELECT name
3936: FROM okl_formulae_v
3937: WHERE id = v_id;
3938:
3939: -- Added by Santonyr on 30-Jul-2003 to fix the bug 2941805
3940:

Line 4560: l_formula_name OKL_FORMULAE_V.NAME%TYPE;

4556: l_amount NUMBER := 0;
4557:
4558: tmpl_rec AVLV_REC_TYPE;
4559: l_tmpl_tbl avlv_tbl_type;
4560: l_formula_name OKL_FORMULAE_V.NAME%TYPE;
4561: l_functional_curr OKL_TRNS_ACC_DSTRS.CURRENCY_CODE%TYPE;
4562: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
4563:
4564: l_api_name VARCHAR2(30) := 'CREATE_ACCOUNTING_DIST';

Line 4575: FROM okl_formulae_v

4571: l_sty_type_name OKL_STRM_TYPE_TL.NAME%TYPE;
4572:
4573: CURSOR frml_csr(v_id NUMBER) IS
4574: SELECT name
4575: FROM okl_formulae_v
4576: WHERE id = v_id;
4577:
4578: -- Added by Santonyr on 30-Jul-2003 to fix the bug 2941805
4579:

Line 5042: l_formula_name OKL_FORMULAE_V.NAME%TYPE;

5038: l_amount NUMBER := 0;
5039:
5040: tmpl_rec AVLV_REC_TYPE;
5041: l_tmpl_tbl avlv_tbl_type;
5042: l_formula_name OKL_FORMULAE_V.NAME%TYPE;
5043: l_functional_curr OKL_TRNS_ACC_DSTRS.CURRENCY_CODE%TYPE;
5044: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
5045:
5046: l_api_name VARCHAR2(30) := 'CREATE_ACCOUNTING_DIST';

Line 5062: FROM okl_formulae_v

5058: l_line_tbl ID_TBL_TYPE;
5059:
5060: CURSOR frml_csr(v_id NUMBER) IS
5061: SELECT name
5062: FROM okl_formulae_v
5063: WHERE id = v_id;
5064:
5065: -- Added by Santonyr on 30-Jul-2003 to fix the bug 2941805
5066: