APPS.OKL_SETUP_ACCRUALS_PVT dependencies on OKL_ACCRUAL_GNRTNS

Line 5: -- PROCEDURE get_rec for: OKL_ACCRUAL_GNRTNS_V

1: PACKAGE BODY OKL_SETUP_ACCRUALS_PVT AS
2: /* $Header: OKLRARUB.pls 120.3 2007/02/06 11:14:00 gkhuntet noship $ */
3:
4: ---------------------------------------------------------------------------
5: -- PROCEDURE get_rec for: OKL_ACCRUAL_GNRTNS_V
6: ---------------------------------------------------------------------------
7: PROCEDURE get_rec (p_agnv_rec IN agnv_rec_type,
8: x_return_status OUT NOCOPY VARCHAR2,
9: x_no_data_found OUT NOCOPY BOOLEAN,

Line 33: FROM OKL_ACCRUAL_GNRTNS

29: CREATION_DATE,
30: LAST_UPDATE_DATE,
31: NVL(LAST_UPDATE_LOGIN,G_MISS_NUM) LAST_UPDATE_LOGIN
32:
33: FROM OKL_ACCRUAL_GNRTNS
34: WHERE id = p_id;
35:
36: l_okl_agnv_pk okl_agnv_pk_csr%ROWTYPE;
37: l_agnv_rec agnv_rec_type;

Line 88: -- PROCEDURE get_changes_only for: OKL_ACCRUAL_GNRTNS_V

84:
85: END get_rec;
86:
87: ---------------------------------------------------------------------------
88: -- PROCEDURE get_changes_only for: OKL_ACCRUAL_GNRTNS_V
89: -- To take care of the assumption that Everything except the Changed Fields
90: -- have G_MISS values in them
91: ---------------------------------------------------------------------------
92: PROCEDURE get_changes_only (p_agnv_rec IN agnv_rec_type,

Line 170: -- PROCEDURE create_accrual_rules for: OKL_ACCRUAL_GNRTNS_V

166:
167:
168:
169: ---------------------------------------------------------------------------
170: -- PROCEDURE create_accrual_rules for: OKL_ACCRUAL_GNRTNS_V
171: ---------------------------------------------------------------------------
172: PROCEDURE create_accrual_rules(p_api_version IN NUMBER,
173: p_init_msg_list IN VARCHAR2,
174: x_return_status OUT NOCOPY VARCHAR2,

Line 191: FROM OKL_ACCRUAL_GNRTNS

187: l_line_number NUMBER := 1;
188: l_tot_version NUMBER :=1 ;
189: CURSOR line_num_csr(p_version VARCHAR2) IS
190: SELECT MAX(line_number)
191: FROM OKL_ACCRUAL_GNRTNS
192: WHERE ORG_ID = p_agnv_rec.ORG_ID AND version = p_version;
193:
194: /*TO FIND NO OF VERSION ON THE BASIS OF ID. */
195: CURSOR ver_count_csr(p_orgId NUMBER) IS

Line 197: FROM OKL_ACCRUAL_GNRTNS

193:
194: /*TO FIND NO OF VERSION ON THE BASIS OF ID. */
195: CURSOR ver_count_csr(p_orgId NUMBER) IS
196: SELECT MAX(TO_NUMBER(VERSION))
197: FROM OKL_ACCRUAL_GNRTNS
198: WHERE ORG_ID = p_orgID;
199: BEGIN
200: l_agnv_rec := p_agnv_rec;
201:

Line 303: -- PROCEDURE update_accrual_rules for: OKL_ACCRUAL_GNRTNS_V

299:
300: END create_accrual_rules;
301:
302: ---------------------------------------------------------------------------
303: -- PROCEDURE update_accrual_rules for: OKL_ACCRUAL_GNRTNS_V
304: ---------------------------------------------------------------------------
305: PROCEDURE update_accrual_rules(p_api_version IN NUMBER,
306: p_init_msg_list IN VARCHAR2,
307: x_return_status OUT NOCOPY VARCHAR2,

Line 331: FROM OKL_ACCRUAL_GNRTNS

327: l_line_number NUMBER := 1;
328:
329: CURSOR line_num_csr(p_version VARCHAR2 , p_orgID Number) IS
330: SELECT MAX(line_number)
331: FROM OKL_ACCRUAL_GNRTNS
332: WHERE version = p_version and ORG_ID = p_orgID;
333:
334: BEGIN
335:

Line 543: FROM OKL_ACCRUAL_GNRTNS

539: x_agnv_rec agnv_rec_type; /*update return copy */
540:
541: CURSOR check_rule_csr(p_id NUMBER) IS
542: SELECT COUNT(*)
543: FROM OKL_ACCRUAL_GNRTNS
544: WHERE version = (SELECT version
545: FROM OKL_ACCRUAL_GNRTNS
546: WHERE id = p_id)
547: AND to_date IS NULL;

Line 545: FROM OKL_ACCRUAL_GNRTNS

541: CURSOR check_rule_csr(p_id NUMBER) IS
542: SELECT COUNT(*)
543: FROM OKL_ACCRUAL_GNRTNS
544: WHERE version = (SELECT version
545: FROM OKL_ACCRUAL_GNRTNS
546: WHERE id = p_id)
547: AND to_date IS NULL;
548:
549: BEGIN