APPS.OKL_PROCESS_BUCKETS_PVT dependencies on OKL_BUCKETS_V

Line 5: -- PROCEDURE get_rec for: OKL_BUCKETS_V

1: PACKAGE BODY OKL_PROCESS_BUCKETS_PVT AS
2: /* $Header: OKLRBUKB.pls 120.3 2005/10/30 03:38:23 appldev noship $ */
3:
4: ---------------------------------------------------------------------------
5: -- PROCEDURE get_rec for: OKL_BUCKETS_V
6: ---------------------------------------------------------------------------
7: PROCEDURE get_rec (
8: p_bktv_rec IN bktv_rec_type,
9: p_changes_only IN BOOLEAN DEFAULT FALSE,

Line 33: FROM OKL_BUCKETS_V

29: LAST_UPDATED_BY,
30: CREATION_DATE,
31: LAST_UPDATE_DATE,
32: NVL(LAST_UPDATE_LOGIN,OKL_API.G_MISS_NUM) LAST_UPDATE_LOGIN
33: FROM OKL_BUCKETS_V
34: WHERE OKL_BUCKETS_V.id = p_id;
35:
36: l_okl_bktv_pk okl_bktv_pk_csr%ROWTYPE;
37: l_bktv_rec bktv_rec_type;

Line 34: WHERE OKL_BUCKETS_V.id = p_id;

30: CREATION_DATE,
31: LAST_UPDATE_DATE,
32: NVL(LAST_UPDATE_LOGIN,OKL_API.G_MISS_NUM) LAST_UPDATE_LOGIN
33: FROM OKL_BUCKETS_V
34: WHERE OKL_BUCKETS_V.id = p_id;
35:
36: l_okl_bktv_pk okl_bktv_pk_csr%ROWTYPE;
37: l_bktv_rec bktv_rec_type;
38: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;

Line 194: p_view => 'OKL_BUCKETS_V',

190: p_start_date_attribute_name => 'START_DATE',
191: p_start_date => l_bktv_rec.start_date,
192: p_end_date_attribute_name => 'END_DATE',
193: p_end_date => l_bktv_rec.end_date,
194: p_view => 'OKL_BUCKETS_V',
195: x_return_status => l_return_status,
196: x_valid => l_valid);
197:
198: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN

Line 230: -- PROCEDURE create_buckets for: OKL_BUCKETS_V

226:
227: END check_updates;
228:
229: ---------------------------------------------------------------------------
230: -- PROCEDURE create_buckets for: OKL_BUCKETS_V
231: ---------------------------------------------------------------------------
232: PROCEDURE create_buckets(p_api_version IN NUMBER,
233: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
234: x_return_status OUT NOCOPY VARCHAR2,

Line 287: p_view => 'OKL_BUCKETS_V',

283: p_attrib_tbl => l_attrib_tbl,
284: p_cur_version => l_bktv_rec.version,
285: p_end_date_attribute_name => 'END_DATE',
286: p_end_date => l_bktv_rec.end_date,
287: p_view => 'OKL_BUCKETS_V',
288: x_return_status => l_return_status,
289: x_new_version => l_new_version);
290:
291: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN

Line 357: -- PROCEDURE update_buckets for: OKL_BUCKETS_V

353:
354: END create_buckets;
355:
356: ---------------------------------------------------------------------------
357: -- PROCEDURE update_buckets for: OKL_BUCKETS_V
358: ---------------------------------------------------------------------------
359: PROCEDURE update_buckets(p_api_version IN NUMBER,
360: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
361: x_return_status OUT NOCOPY VARCHAR2,

Line 512: p_view => 'OKL_BUCKETS_V',

508: p_attrib_tbl => l_attrib_tbl,
509: p_cur_version => l_bktv_rec.version,
510: p_end_date_attribute_name => 'END_DATE',
511: p_end_date => l_bktv_rec.end_date,
512: p_view => 'OKL_BUCKETS_V',
513: x_return_status => l_return_status,
514: x_new_version => l_new_version);
515:
516: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN

Line 571: p_view => 'OKL_BUCKETS_V',

567: p_attrib_tbl => l_attrib_tbl,
568: p_cur_version => l_bktv_rec.version,
569: p_end_date_attribute_name => 'END_DATE',
570: p_end_date => l_bktv_rec.end_date,
571: p_view => 'OKL_BUCKETS_V',
572: x_return_status => l_return_status,
573: x_new_version => l_new_version);
574:
575: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN