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 3913: l_formula_name OKL_FORMULAE_V.NAME%TYPE;

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

Line 3934: FROM okl_formulae_v

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

Line 4556: l_formula_name OKL_FORMULAE_V.NAME%TYPE;

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

Line 4571: FROM okl_formulae_v

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

Line 5038: l_formula_name OKL_FORMULAE_V.NAME%TYPE;

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

Line 5058: FROM okl_formulae_v

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