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.BIS_BUCKET_PUB dependencies on BIS_BUCKET

Line 1: PACKAGE BIS_BUCKET_PUB AUTHID CURRENT_USER AS

1: PACKAGE BIS_BUCKET_PUB AUTHID CURRENT_USER AS
2: /* $Header: BISPBKTS.pls 115.5 2004/02/15 21:54:59 ankgoel noship $ */
3:
4: G_PKG_NAME CONSTANT VARCHAR2(30):='BIS_BUCKET_PUB';
5:

Line 4: G_PKG_NAME CONSTANT VARCHAR2(30):='BIS_BUCKET_PUB';

1: PACKAGE BIS_BUCKET_PUB AUTHID CURRENT_USER AS
2: /* $Header: BISPBKTS.pls 115.5 2004/02/15 21:54:59 ankgoel noship $ */
3:
4: G_PKG_NAME CONSTANT VARCHAR2(30):='BIS_BUCKET_PUB';
5:
6: TYPE BIS_BUCKET_REC_TYPE IS RECORD (
7: bucket_id BIS_BUCKET.bucket_id%TYPE
8: ,short_name BIS_BUCKET.short_name%TYPE

Line 6: TYPE BIS_BUCKET_REC_TYPE IS RECORD (

2: /* $Header: BISPBKTS.pls 115.5 2004/02/15 21:54:59 ankgoel noship $ */
3:
4: G_PKG_NAME CONSTANT VARCHAR2(30):='BIS_BUCKET_PUB';
5:
6: TYPE BIS_BUCKET_REC_TYPE IS RECORD (
7: bucket_id BIS_BUCKET.bucket_id%TYPE
8: ,short_name BIS_BUCKET.short_name%TYPE
9: ,name BIS_BUCKET_TL.name%TYPE
10: ,type BIS_BUCKET.type%TYPE

Line 7: bucket_id BIS_BUCKET.bucket_id%TYPE

3:
4: G_PKG_NAME CONSTANT VARCHAR2(30):='BIS_BUCKET_PUB';
5:
6: TYPE BIS_BUCKET_REC_TYPE IS RECORD (
7: bucket_id BIS_BUCKET.bucket_id%TYPE
8: ,short_name BIS_BUCKET.short_name%TYPE
9: ,name BIS_BUCKET_TL.name%TYPE
10: ,type BIS_BUCKET.type%TYPE
11: ,application_id BIS_BUCKET.application_id%TYPE

Line 8: ,short_name BIS_BUCKET.short_name%TYPE

4: G_PKG_NAME CONSTANT VARCHAR2(30):='BIS_BUCKET_PUB';
5:
6: TYPE BIS_BUCKET_REC_TYPE IS RECORD (
7: bucket_id BIS_BUCKET.bucket_id%TYPE
8: ,short_name BIS_BUCKET.short_name%TYPE
9: ,name BIS_BUCKET_TL.name%TYPE
10: ,type BIS_BUCKET.type%TYPE
11: ,application_id BIS_BUCKET.application_id%TYPE
12: ,range1_name BIS_BUCKET_TL.range1_name%TYPE

Line 9: ,name BIS_BUCKET_TL.name%TYPE

5:
6: TYPE BIS_BUCKET_REC_TYPE IS RECORD (
7: bucket_id BIS_BUCKET.bucket_id%TYPE
8: ,short_name BIS_BUCKET.short_name%TYPE
9: ,name BIS_BUCKET_TL.name%TYPE
10: ,type BIS_BUCKET.type%TYPE
11: ,application_id BIS_BUCKET.application_id%TYPE
12: ,range1_name BIS_BUCKET_TL.range1_name%TYPE
13: ,range1_low BIS_BUCKET.range1_low%TYPE

Line 10: ,type BIS_BUCKET.type%TYPE

6: TYPE BIS_BUCKET_REC_TYPE IS RECORD (
7: bucket_id BIS_BUCKET.bucket_id%TYPE
8: ,short_name BIS_BUCKET.short_name%TYPE
9: ,name BIS_BUCKET_TL.name%TYPE
10: ,type BIS_BUCKET.type%TYPE
11: ,application_id BIS_BUCKET.application_id%TYPE
12: ,range1_name BIS_BUCKET_TL.range1_name%TYPE
13: ,range1_low BIS_BUCKET.range1_low%TYPE
14: ,range1_high BIS_BUCKET.range1_high%TYPE

Line 11: ,application_id BIS_BUCKET.application_id%TYPE

7: bucket_id BIS_BUCKET.bucket_id%TYPE
8: ,short_name BIS_BUCKET.short_name%TYPE
9: ,name BIS_BUCKET_TL.name%TYPE
10: ,type BIS_BUCKET.type%TYPE
11: ,application_id BIS_BUCKET.application_id%TYPE
12: ,range1_name BIS_BUCKET_TL.range1_name%TYPE
13: ,range1_low BIS_BUCKET.range1_low%TYPE
14: ,range1_high BIS_BUCKET.range1_high%TYPE
15: ,range2_name BIS_BUCKET_TL.range2_name%TYPE

Line 12: ,range1_name BIS_BUCKET_TL.range1_name%TYPE

8: ,short_name BIS_BUCKET.short_name%TYPE
9: ,name BIS_BUCKET_TL.name%TYPE
10: ,type BIS_BUCKET.type%TYPE
11: ,application_id BIS_BUCKET.application_id%TYPE
12: ,range1_name BIS_BUCKET_TL.range1_name%TYPE
13: ,range1_low BIS_BUCKET.range1_low%TYPE
14: ,range1_high BIS_BUCKET.range1_high%TYPE
15: ,range2_name BIS_BUCKET_TL.range2_name%TYPE
16: ,range2_low BIS_BUCKET.range2_low%TYPE

Line 13: ,range1_low BIS_BUCKET.range1_low%TYPE

9: ,name BIS_BUCKET_TL.name%TYPE
10: ,type BIS_BUCKET.type%TYPE
11: ,application_id BIS_BUCKET.application_id%TYPE
12: ,range1_name BIS_BUCKET_TL.range1_name%TYPE
13: ,range1_low BIS_BUCKET.range1_low%TYPE
14: ,range1_high BIS_BUCKET.range1_high%TYPE
15: ,range2_name BIS_BUCKET_TL.range2_name%TYPE
16: ,range2_low BIS_BUCKET.range2_low%TYPE
17: ,range2_high BIS_BUCKET.range2_high%TYPE

Line 14: ,range1_high BIS_BUCKET.range1_high%TYPE

10: ,type BIS_BUCKET.type%TYPE
11: ,application_id BIS_BUCKET.application_id%TYPE
12: ,range1_name BIS_BUCKET_TL.range1_name%TYPE
13: ,range1_low BIS_BUCKET.range1_low%TYPE
14: ,range1_high BIS_BUCKET.range1_high%TYPE
15: ,range2_name BIS_BUCKET_TL.range2_name%TYPE
16: ,range2_low BIS_BUCKET.range2_low%TYPE
17: ,range2_high BIS_BUCKET.range2_high%TYPE
18: ,range3_name BIS_BUCKET_TL.range3_name%TYPE

Line 15: ,range2_name BIS_BUCKET_TL.range2_name%TYPE

11: ,application_id BIS_BUCKET.application_id%TYPE
12: ,range1_name BIS_BUCKET_TL.range1_name%TYPE
13: ,range1_low BIS_BUCKET.range1_low%TYPE
14: ,range1_high BIS_BUCKET.range1_high%TYPE
15: ,range2_name BIS_BUCKET_TL.range2_name%TYPE
16: ,range2_low BIS_BUCKET.range2_low%TYPE
17: ,range2_high BIS_BUCKET.range2_high%TYPE
18: ,range3_name BIS_BUCKET_TL.range3_name%TYPE
19: ,range3_low BIS_BUCKET.range3_low%TYPE

Line 16: ,range2_low BIS_BUCKET.range2_low%TYPE

12: ,range1_name BIS_BUCKET_TL.range1_name%TYPE
13: ,range1_low BIS_BUCKET.range1_low%TYPE
14: ,range1_high BIS_BUCKET.range1_high%TYPE
15: ,range2_name BIS_BUCKET_TL.range2_name%TYPE
16: ,range2_low BIS_BUCKET.range2_low%TYPE
17: ,range2_high BIS_BUCKET.range2_high%TYPE
18: ,range3_name BIS_BUCKET_TL.range3_name%TYPE
19: ,range3_low BIS_BUCKET.range3_low%TYPE
20: ,range3_high BIS_BUCKET.range3_high%TYPE

Line 17: ,range2_high BIS_BUCKET.range2_high%TYPE

13: ,range1_low BIS_BUCKET.range1_low%TYPE
14: ,range1_high BIS_BUCKET.range1_high%TYPE
15: ,range2_name BIS_BUCKET_TL.range2_name%TYPE
16: ,range2_low BIS_BUCKET.range2_low%TYPE
17: ,range2_high BIS_BUCKET.range2_high%TYPE
18: ,range3_name BIS_BUCKET_TL.range3_name%TYPE
19: ,range3_low BIS_BUCKET.range3_low%TYPE
20: ,range3_high BIS_BUCKET.range3_high%TYPE
21: ,range4_name BIS_BUCKET_TL.range4_name%TYPE

Line 18: ,range3_name BIS_BUCKET_TL.range3_name%TYPE

14: ,range1_high BIS_BUCKET.range1_high%TYPE
15: ,range2_name BIS_BUCKET_TL.range2_name%TYPE
16: ,range2_low BIS_BUCKET.range2_low%TYPE
17: ,range2_high BIS_BUCKET.range2_high%TYPE
18: ,range3_name BIS_BUCKET_TL.range3_name%TYPE
19: ,range3_low BIS_BUCKET.range3_low%TYPE
20: ,range3_high BIS_BUCKET.range3_high%TYPE
21: ,range4_name BIS_BUCKET_TL.range4_name%TYPE
22: ,range4_low BIS_BUCKET.range4_low%TYPE

Line 19: ,range3_low BIS_BUCKET.range3_low%TYPE

15: ,range2_name BIS_BUCKET_TL.range2_name%TYPE
16: ,range2_low BIS_BUCKET.range2_low%TYPE
17: ,range2_high BIS_BUCKET.range2_high%TYPE
18: ,range3_name BIS_BUCKET_TL.range3_name%TYPE
19: ,range3_low BIS_BUCKET.range3_low%TYPE
20: ,range3_high BIS_BUCKET.range3_high%TYPE
21: ,range4_name BIS_BUCKET_TL.range4_name%TYPE
22: ,range4_low BIS_BUCKET.range4_low%TYPE
23: ,range4_high BIS_BUCKET.range4_high%TYPE

Line 20: ,range3_high BIS_BUCKET.range3_high%TYPE

16: ,range2_low BIS_BUCKET.range2_low%TYPE
17: ,range2_high BIS_BUCKET.range2_high%TYPE
18: ,range3_name BIS_BUCKET_TL.range3_name%TYPE
19: ,range3_low BIS_BUCKET.range3_low%TYPE
20: ,range3_high BIS_BUCKET.range3_high%TYPE
21: ,range4_name BIS_BUCKET_TL.range4_name%TYPE
22: ,range4_low BIS_BUCKET.range4_low%TYPE
23: ,range4_high BIS_BUCKET.range4_high%TYPE
24: ,range5_name BIS_BUCKET_TL.range5_name%TYPE

Line 21: ,range4_name BIS_BUCKET_TL.range4_name%TYPE

17: ,range2_high BIS_BUCKET.range2_high%TYPE
18: ,range3_name BIS_BUCKET_TL.range3_name%TYPE
19: ,range3_low BIS_BUCKET.range3_low%TYPE
20: ,range3_high BIS_BUCKET.range3_high%TYPE
21: ,range4_name BIS_BUCKET_TL.range4_name%TYPE
22: ,range4_low BIS_BUCKET.range4_low%TYPE
23: ,range4_high BIS_BUCKET.range4_high%TYPE
24: ,range5_name BIS_BUCKET_TL.range5_name%TYPE
25: ,range5_low BIS_BUCKET.range5_low%TYPE

Line 22: ,range4_low BIS_BUCKET.range4_low%TYPE

18: ,range3_name BIS_BUCKET_TL.range3_name%TYPE
19: ,range3_low BIS_BUCKET.range3_low%TYPE
20: ,range3_high BIS_BUCKET.range3_high%TYPE
21: ,range4_name BIS_BUCKET_TL.range4_name%TYPE
22: ,range4_low BIS_BUCKET.range4_low%TYPE
23: ,range4_high BIS_BUCKET.range4_high%TYPE
24: ,range5_name BIS_BUCKET_TL.range5_name%TYPE
25: ,range5_low BIS_BUCKET.range5_low%TYPE
26: ,range5_high BIS_BUCKET.range5_high%TYPE

Line 23: ,range4_high BIS_BUCKET.range4_high%TYPE

19: ,range3_low BIS_BUCKET.range3_low%TYPE
20: ,range3_high BIS_BUCKET.range3_high%TYPE
21: ,range4_name BIS_BUCKET_TL.range4_name%TYPE
22: ,range4_low BIS_BUCKET.range4_low%TYPE
23: ,range4_high BIS_BUCKET.range4_high%TYPE
24: ,range5_name BIS_BUCKET_TL.range5_name%TYPE
25: ,range5_low BIS_BUCKET.range5_low%TYPE
26: ,range5_high BIS_BUCKET.range5_high%TYPE
27: ,range6_name BIS_BUCKET_TL.range6_name%TYPE

Line 24: ,range5_name BIS_BUCKET_TL.range5_name%TYPE

20: ,range3_high BIS_BUCKET.range3_high%TYPE
21: ,range4_name BIS_BUCKET_TL.range4_name%TYPE
22: ,range4_low BIS_BUCKET.range4_low%TYPE
23: ,range4_high BIS_BUCKET.range4_high%TYPE
24: ,range5_name BIS_BUCKET_TL.range5_name%TYPE
25: ,range5_low BIS_BUCKET.range5_low%TYPE
26: ,range5_high BIS_BUCKET.range5_high%TYPE
27: ,range6_name BIS_BUCKET_TL.range6_name%TYPE
28: ,range6_low BIS_BUCKET.range6_low%TYPE

Line 25: ,range5_low BIS_BUCKET.range5_low%TYPE

21: ,range4_name BIS_BUCKET_TL.range4_name%TYPE
22: ,range4_low BIS_BUCKET.range4_low%TYPE
23: ,range4_high BIS_BUCKET.range4_high%TYPE
24: ,range5_name BIS_BUCKET_TL.range5_name%TYPE
25: ,range5_low BIS_BUCKET.range5_low%TYPE
26: ,range5_high BIS_BUCKET.range5_high%TYPE
27: ,range6_name BIS_BUCKET_TL.range6_name%TYPE
28: ,range6_low BIS_BUCKET.range6_low%TYPE
29: ,range6_high BIS_BUCKET.range6_high%TYPE

Line 26: ,range5_high BIS_BUCKET.range5_high%TYPE

22: ,range4_low BIS_BUCKET.range4_low%TYPE
23: ,range4_high BIS_BUCKET.range4_high%TYPE
24: ,range5_name BIS_BUCKET_TL.range5_name%TYPE
25: ,range5_low BIS_BUCKET.range5_low%TYPE
26: ,range5_high BIS_BUCKET.range5_high%TYPE
27: ,range6_name BIS_BUCKET_TL.range6_name%TYPE
28: ,range6_low BIS_BUCKET.range6_low%TYPE
29: ,range6_high BIS_BUCKET.range6_high%TYPE
30: ,range7_name BIS_BUCKET_TL.range7_name%TYPE

Line 27: ,range6_name BIS_BUCKET_TL.range6_name%TYPE

23: ,range4_high BIS_BUCKET.range4_high%TYPE
24: ,range5_name BIS_BUCKET_TL.range5_name%TYPE
25: ,range5_low BIS_BUCKET.range5_low%TYPE
26: ,range5_high BIS_BUCKET.range5_high%TYPE
27: ,range6_name BIS_BUCKET_TL.range6_name%TYPE
28: ,range6_low BIS_BUCKET.range6_low%TYPE
29: ,range6_high BIS_BUCKET.range6_high%TYPE
30: ,range7_name BIS_BUCKET_TL.range7_name%TYPE
31: ,range7_low BIS_BUCKET.range7_low%TYPE

Line 28: ,range6_low BIS_BUCKET.range6_low%TYPE

24: ,range5_name BIS_BUCKET_TL.range5_name%TYPE
25: ,range5_low BIS_BUCKET.range5_low%TYPE
26: ,range5_high BIS_BUCKET.range5_high%TYPE
27: ,range6_name BIS_BUCKET_TL.range6_name%TYPE
28: ,range6_low BIS_BUCKET.range6_low%TYPE
29: ,range6_high BIS_BUCKET.range6_high%TYPE
30: ,range7_name BIS_BUCKET_TL.range7_name%TYPE
31: ,range7_low BIS_BUCKET.range7_low%TYPE
32: ,range7_high BIS_BUCKET.range7_high%TYPE

Line 29: ,range6_high BIS_BUCKET.range6_high%TYPE

25: ,range5_low BIS_BUCKET.range5_low%TYPE
26: ,range5_high BIS_BUCKET.range5_high%TYPE
27: ,range6_name BIS_BUCKET_TL.range6_name%TYPE
28: ,range6_low BIS_BUCKET.range6_low%TYPE
29: ,range6_high BIS_BUCKET.range6_high%TYPE
30: ,range7_name BIS_BUCKET_TL.range7_name%TYPE
31: ,range7_low BIS_BUCKET.range7_low%TYPE
32: ,range7_high BIS_BUCKET.range7_high%TYPE
33: ,range8_name BIS_BUCKET_TL.range8_name%TYPE

Line 30: ,range7_name BIS_BUCKET_TL.range7_name%TYPE

26: ,range5_high BIS_BUCKET.range5_high%TYPE
27: ,range6_name BIS_BUCKET_TL.range6_name%TYPE
28: ,range6_low BIS_BUCKET.range6_low%TYPE
29: ,range6_high BIS_BUCKET.range6_high%TYPE
30: ,range7_name BIS_BUCKET_TL.range7_name%TYPE
31: ,range7_low BIS_BUCKET.range7_low%TYPE
32: ,range7_high BIS_BUCKET.range7_high%TYPE
33: ,range8_name BIS_BUCKET_TL.range8_name%TYPE
34: ,range8_low BIS_BUCKET.range8_low%TYPE

Line 31: ,range7_low BIS_BUCKET.range7_low%TYPE

27: ,range6_name BIS_BUCKET_TL.range6_name%TYPE
28: ,range6_low BIS_BUCKET.range6_low%TYPE
29: ,range6_high BIS_BUCKET.range6_high%TYPE
30: ,range7_name BIS_BUCKET_TL.range7_name%TYPE
31: ,range7_low BIS_BUCKET.range7_low%TYPE
32: ,range7_high BIS_BUCKET.range7_high%TYPE
33: ,range8_name BIS_BUCKET_TL.range8_name%TYPE
34: ,range8_low BIS_BUCKET.range8_low%TYPE
35: ,range8_high BIS_BUCKET.range8_high%TYPE

Line 32: ,range7_high BIS_BUCKET.range7_high%TYPE

28: ,range6_low BIS_BUCKET.range6_low%TYPE
29: ,range6_high BIS_BUCKET.range6_high%TYPE
30: ,range7_name BIS_BUCKET_TL.range7_name%TYPE
31: ,range7_low BIS_BUCKET.range7_low%TYPE
32: ,range7_high BIS_BUCKET.range7_high%TYPE
33: ,range8_name BIS_BUCKET_TL.range8_name%TYPE
34: ,range8_low BIS_BUCKET.range8_low%TYPE
35: ,range8_high BIS_BUCKET.range8_high%TYPE
36: ,range9_name BIS_BUCKET_TL.range9_name%TYPE

Line 33: ,range8_name BIS_BUCKET_TL.range8_name%TYPE

29: ,range6_high BIS_BUCKET.range6_high%TYPE
30: ,range7_name BIS_BUCKET_TL.range7_name%TYPE
31: ,range7_low BIS_BUCKET.range7_low%TYPE
32: ,range7_high BIS_BUCKET.range7_high%TYPE
33: ,range8_name BIS_BUCKET_TL.range8_name%TYPE
34: ,range8_low BIS_BUCKET.range8_low%TYPE
35: ,range8_high BIS_BUCKET.range8_high%TYPE
36: ,range9_name BIS_BUCKET_TL.range9_name%TYPE
37: ,range9_low BIS_BUCKET.range9_low%TYPE

Line 34: ,range8_low BIS_BUCKET.range8_low%TYPE

30: ,range7_name BIS_BUCKET_TL.range7_name%TYPE
31: ,range7_low BIS_BUCKET.range7_low%TYPE
32: ,range7_high BIS_BUCKET.range7_high%TYPE
33: ,range8_name BIS_BUCKET_TL.range8_name%TYPE
34: ,range8_low BIS_BUCKET.range8_low%TYPE
35: ,range8_high BIS_BUCKET.range8_high%TYPE
36: ,range9_name BIS_BUCKET_TL.range9_name%TYPE
37: ,range9_low BIS_BUCKET.range9_low%TYPE
38: ,range9_high BIS_BUCKET.range9_high%TYPE

Line 35: ,range8_high BIS_BUCKET.range8_high%TYPE

31: ,range7_low BIS_BUCKET.range7_low%TYPE
32: ,range7_high BIS_BUCKET.range7_high%TYPE
33: ,range8_name BIS_BUCKET_TL.range8_name%TYPE
34: ,range8_low BIS_BUCKET.range8_low%TYPE
35: ,range8_high BIS_BUCKET.range8_high%TYPE
36: ,range9_name BIS_BUCKET_TL.range9_name%TYPE
37: ,range9_low BIS_BUCKET.range9_low%TYPE
38: ,range9_high BIS_BUCKET.range9_high%TYPE
39: ,range10_name BIS_BUCKET_TL.range10_name%TYPE

Line 36: ,range9_name BIS_BUCKET_TL.range9_name%TYPE

32: ,range7_high BIS_BUCKET.range7_high%TYPE
33: ,range8_name BIS_BUCKET_TL.range8_name%TYPE
34: ,range8_low BIS_BUCKET.range8_low%TYPE
35: ,range8_high BIS_BUCKET.range8_high%TYPE
36: ,range9_name BIS_BUCKET_TL.range9_name%TYPE
37: ,range9_low BIS_BUCKET.range9_low%TYPE
38: ,range9_high BIS_BUCKET.range9_high%TYPE
39: ,range10_name BIS_BUCKET_TL.range10_name%TYPE
40: ,range10_low BIS_BUCKET.range10_low%TYPE

Line 37: ,range9_low BIS_BUCKET.range9_low%TYPE

33: ,range8_name BIS_BUCKET_TL.range8_name%TYPE
34: ,range8_low BIS_BUCKET.range8_low%TYPE
35: ,range8_high BIS_BUCKET.range8_high%TYPE
36: ,range9_name BIS_BUCKET_TL.range9_name%TYPE
37: ,range9_low BIS_BUCKET.range9_low%TYPE
38: ,range9_high BIS_BUCKET.range9_high%TYPE
39: ,range10_name BIS_BUCKET_TL.range10_name%TYPE
40: ,range10_low BIS_BUCKET.range10_low%TYPE
41: ,range10_high BIS_BUCKET.range10_high%TYPE

Line 38: ,range9_high BIS_BUCKET.range9_high%TYPE

34: ,range8_low BIS_BUCKET.range8_low%TYPE
35: ,range8_high BIS_BUCKET.range8_high%TYPE
36: ,range9_name BIS_BUCKET_TL.range9_name%TYPE
37: ,range9_low BIS_BUCKET.range9_low%TYPE
38: ,range9_high BIS_BUCKET.range9_high%TYPE
39: ,range10_name BIS_BUCKET_TL.range10_name%TYPE
40: ,range10_low BIS_BUCKET.range10_low%TYPE
41: ,range10_high BIS_BUCKET.range10_high%TYPE
42: ,customized BIS_BUCKET_CUSTOMIZATIONS.customized%TYPE

Line 39: ,range10_name BIS_BUCKET_TL.range10_name%TYPE

35: ,range8_high BIS_BUCKET.range8_high%TYPE
36: ,range9_name BIS_BUCKET_TL.range9_name%TYPE
37: ,range9_low BIS_BUCKET.range9_low%TYPE
38: ,range9_high BIS_BUCKET.range9_high%TYPE
39: ,range10_name BIS_BUCKET_TL.range10_name%TYPE
40: ,range10_low BIS_BUCKET.range10_low%TYPE
41: ,range10_high BIS_BUCKET.range10_high%TYPE
42: ,customized BIS_BUCKET_CUSTOMIZATIONS.customized%TYPE
43: ,description BIS_BUCKET_TL.description%TYPE

Line 40: ,range10_low BIS_BUCKET.range10_low%TYPE

36: ,range9_name BIS_BUCKET_TL.range9_name%TYPE
37: ,range9_low BIS_BUCKET.range9_low%TYPE
38: ,range9_high BIS_BUCKET.range9_high%TYPE
39: ,range10_name BIS_BUCKET_TL.range10_name%TYPE
40: ,range10_low BIS_BUCKET.range10_low%TYPE
41: ,range10_high BIS_BUCKET.range10_high%TYPE
42: ,customized BIS_BUCKET_CUSTOMIZATIONS.customized%TYPE
43: ,description BIS_BUCKET_TL.description%TYPE
44: ,updatable BIS_BUCKET.updatable%TYPE:='F'

Line 41: ,range10_high BIS_BUCKET.range10_high%TYPE

37: ,range9_low BIS_BUCKET.range9_low%TYPE
38: ,range9_high BIS_BUCKET.range9_high%TYPE
39: ,range10_name BIS_BUCKET_TL.range10_name%TYPE
40: ,range10_low BIS_BUCKET.range10_low%TYPE
41: ,range10_high BIS_BUCKET.range10_high%TYPE
42: ,customized BIS_BUCKET_CUSTOMIZATIONS.customized%TYPE
43: ,description BIS_BUCKET_TL.description%TYPE
44: ,updatable BIS_BUCKET.updatable%TYPE:='F'
45: ,expandable BIS_BUCKET.expandable%TYPE:='F'

Line 42: ,customized BIS_BUCKET_CUSTOMIZATIONS.customized%TYPE

38: ,range9_high BIS_BUCKET.range9_high%TYPE
39: ,range10_name BIS_BUCKET_TL.range10_name%TYPE
40: ,range10_low BIS_BUCKET.range10_low%TYPE
41: ,range10_high BIS_BUCKET.range10_high%TYPE
42: ,customized BIS_BUCKET_CUSTOMIZATIONS.customized%TYPE
43: ,description BIS_BUCKET_TL.description%TYPE
44: ,updatable BIS_BUCKET.updatable%TYPE:='F'
45: ,expandable BIS_BUCKET.expandable%TYPE:='F'
46: ,discontinuous BIS_BUCKET.discontinuous%TYPE:='F'

Line 43: ,description BIS_BUCKET_TL.description%TYPE

39: ,range10_name BIS_BUCKET_TL.range10_name%TYPE
40: ,range10_low BIS_BUCKET.range10_low%TYPE
41: ,range10_high BIS_BUCKET.range10_high%TYPE
42: ,customized BIS_BUCKET_CUSTOMIZATIONS.customized%TYPE
43: ,description BIS_BUCKET_TL.description%TYPE
44: ,updatable BIS_BUCKET.updatable%TYPE:='F'
45: ,expandable BIS_BUCKET.expandable%TYPE:='F'
46: ,discontinuous BIS_BUCKET.discontinuous%TYPE:='F'
47: ,overlapping BIS_BUCKET.overlapping%TYPE:='F'

Line 44: ,updatable BIS_BUCKET.updatable%TYPE:='F'

40: ,range10_low BIS_BUCKET.range10_low%TYPE
41: ,range10_high BIS_BUCKET.range10_high%TYPE
42: ,customized BIS_BUCKET_CUSTOMIZATIONS.customized%TYPE
43: ,description BIS_BUCKET_TL.description%TYPE
44: ,updatable BIS_BUCKET.updatable%TYPE:='F'
45: ,expandable BIS_BUCKET.expandable%TYPE:='F'
46: ,discontinuous BIS_BUCKET.discontinuous%TYPE:='F'
47: ,overlapping BIS_BUCKET.overlapping%TYPE:='F'
48: ,uom BIS_BUCKET.uom%TYPE

Line 45: ,expandable BIS_BUCKET.expandable%TYPE:='F'

41: ,range10_high BIS_BUCKET.range10_high%TYPE
42: ,customized BIS_BUCKET_CUSTOMIZATIONS.customized%TYPE
43: ,description BIS_BUCKET_TL.description%TYPE
44: ,updatable BIS_BUCKET.updatable%TYPE:='F'
45: ,expandable BIS_BUCKET.expandable%TYPE:='F'
46: ,discontinuous BIS_BUCKET.discontinuous%TYPE:='F'
47: ,overlapping BIS_BUCKET.overlapping%TYPE:='F'
48: ,uom BIS_BUCKET.uom%TYPE
49: );

Line 46: ,discontinuous BIS_BUCKET.discontinuous%TYPE:='F'

42: ,customized BIS_BUCKET_CUSTOMIZATIONS.customized%TYPE
43: ,description BIS_BUCKET_TL.description%TYPE
44: ,updatable BIS_BUCKET.updatable%TYPE:='F'
45: ,expandable BIS_BUCKET.expandable%TYPE:='F'
46: ,discontinuous BIS_BUCKET.discontinuous%TYPE:='F'
47: ,overlapping BIS_BUCKET.overlapping%TYPE:='F'
48: ,uom BIS_BUCKET.uom%TYPE
49: );
50:

Line 47: ,overlapping BIS_BUCKET.overlapping%TYPE:='F'

43: ,description BIS_BUCKET_TL.description%TYPE
44: ,updatable BIS_BUCKET.updatable%TYPE:='F'
45: ,expandable BIS_BUCKET.expandable%TYPE:='F'
46: ,discontinuous BIS_BUCKET.discontinuous%TYPE:='F'
47: ,overlapping BIS_BUCKET.overlapping%TYPE:='F'
48: ,uom BIS_BUCKET.uom%TYPE
49: );
50:
51:

Line 48: ,uom BIS_BUCKET.uom%TYPE

44: ,updatable BIS_BUCKET.updatable%TYPE:='F'
45: ,expandable BIS_BUCKET.expandable%TYPE:='F'
46: ,discontinuous BIS_BUCKET.discontinuous%TYPE:='F'
47: ,overlapping BIS_BUCKET.overlapping%TYPE:='F'
48: ,uom BIS_BUCKET.uom%TYPE
49: );
50:
51:
52: --This API should call BIS_BUCKET_PVT.CREATE_BIS_BUCKET

Line 52: --This API should call BIS_BUCKET_PVT.CREATE_BIS_BUCKET

48: ,uom BIS_BUCKET.uom%TYPE
49: );
50:
51:
52: --This API should call BIS_BUCKET_PVT.CREATE_BIS_BUCKET
53: PROCEDURE CREATE_BIS_BUCKET (
54: p_bis_bucket_rec IN BIS_BUCKET_PUB.bis_bucket_rec_type
55: ,x_return_status OUT NOCOPY VARCHAR2
56: ,x_error_tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type

Line 53: PROCEDURE CREATE_BIS_BUCKET (

49: );
50:
51:
52: --This API should call BIS_BUCKET_PVT.CREATE_BIS_BUCKET
53: PROCEDURE CREATE_BIS_BUCKET (
54: p_bis_bucket_rec IN BIS_BUCKET_PUB.bis_bucket_rec_type
55: ,x_return_status OUT NOCOPY VARCHAR2
56: ,x_error_tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
57: );

Line 54: p_bis_bucket_rec IN BIS_BUCKET_PUB.bis_bucket_rec_type

50:
51:
52: --This API should call BIS_BUCKET_PVT.CREATE_BIS_BUCKET
53: PROCEDURE CREATE_BIS_BUCKET (
54: p_bis_bucket_rec IN BIS_BUCKET_PUB.bis_bucket_rec_type
55: ,x_return_status OUT NOCOPY VARCHAR2
56: ,x_error_tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
57: );
58:

Line 59: --This API should call BIS_BUCKET_PVT.UPDATE_BIS_BUCKET

55: ,x_return_status OUT NOCOPY VARCHAR2
56: ,x_error_tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
57: );
58:
59: --This API should call BIS_BUCKET_PVT.UPDATE_BIS_BUCKET
60: PROCEDURE UPDATE_BIS_BUCKET (
61: p_bis_bucket_rec IN BIS_BUCKET_PUB.bis_bucket_rec_type
62: ,x_return_status OUT NOCOPY VARCHAR2
63: ,x_error_tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type

Line 60: PROCEDURE UPDATE_BIS_BUCKET (

56: ,x_error_tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
57: );
58:
59: --This API should call BIS_BUCKET_PVT.UPDATE_BIS_BUCKET
60: PROCEDURE UPDATE_BIS_BUCKET (
61: p_bis_bucket_rec IN BIS_BUCKET_PUB.bis_bucket_rec_type
62: ,x_return_status OUT NOCOPY VARCHAR2
63: ,x_error_tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
64: );

Line 61: p_bis_bucket_rec IN BIS_BUCKET_PUB.bis_bucket_rec_type

57: );
58:
59: --This API should call BIS_BUCKET_PVT.UPDATE_BIS_BUCKET
60: PROCEDURE UPDATE_BIS_BUCKET (
61: p_bis_bucket_rec IN BIS_BUCKET_PUB.bis_bucket_rec_type
62: ,x_return_status OUT NOCOPY VARCHAR2
63: ,x_error_tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
64: );
65:

Line 66: --This API should call BIS_BUCKET_PVT.DELETE_BIS_BUCKET

62: ,x_return_status OUT NOCOPY VARCHAR2
63: ,x_error_tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
64: );
65:
66: --This API should call BIS_BUCKET_PVT.DELETE_BIS_BUCKET
67: PROCEDURE DELETE_BIS_BUCKET (
68: p_bucket_id IN BIS_BUCKET.bucket_id%TYPE := BIS_UTILITIES_PUB.G_NULL_NUM
69: ,p_short_name IN BIS_BUCKET.short_name%TYPE := BIS_UTILITIES_PUB.G_NULL_CHAR
70: ,x_return_status OUT NOCOPY VARCHAR2

Line 67: PROCEDURE DELETE_BIS_BUCKET (

63: ,x_error_tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
64: );
65:
66: --This API should call BIS_BUCKET_PVT.DELETE_BIS_BUCKET
67: PROCEDURE DELETE_BIS_BUCKET (
68: p_bucket_id IN BIS_BUCKET.bucket_id%TYPE := BIS_UTILITIES_PUB.G_NULL_NUM
69: ,p_short_name IN BIS_BUCKET.short_name%TYPE := BIS_UTILITIES_PUB.G_NULL_CHAR
70: ,x_return_status OUT NOCOPY VARCHAR2
71: ,x_error_tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type

Line 68: p_bucket_id IN BIS_BUCKET.bucket_id%TYPE := BIS_UTILITIES_PUB.G_NULL_NUM

64: );
65:
66: --This API should call BIS_BUCKET_PVT.DELETE_BIS_BUCKET
67: PROCEDURE DELETE_BIS_BUCKET (
68: p_bucket_id IN BIS_BUCKET.bucket_id%TYPE := BIS_UTILITIES_PUB.G_NULL_NUM
69: ,p_short_name IN BIS_BUCKET.short_name%TYPE := BIS_UTILITIES_PUB.G_NULL_CHAR
70: ,x_return_status OUT NOCOPY VARCHAR2
71: ,x_error_tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
72: );

Line 69: ,p_short_name IN BIS_BUCKET.short_name%TYPE := BIS_UTILITIES_PUB.G_NULL_CHAR

65:
66: --This API should call BIS_BUCKET_PVT.DELETE_BIS_BUCKET
67: PROCEDURE DELETE_BIS_BUCKET (
68: p_bucket_id IN BIS_BUCKET.bucket_id%TYPE := BIS_UTILITIES_PUB.G_NULL_NUM
69: ,p_short_name IN BIS_BUCKET.short_name%TYPE := BIS_UTILITIES_PUB.G_NULL_CHAR
70: ,x_return_status OUT NOCOPY VARCHAR2
71: ,x_error_tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
72: );
73:

Line 75: --This API should call BIS_BUCKET_PVT.RETRIEVE _BIS_BUCKET

71: ,x_error_tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
72: );
73:
74:
75: --This API should call BIS_BUCKET_PVT.RETRIEVE _BIS_BUCKET
76: PROCEDURE RETRIEVE_BIS_BUCKET (
77: p_short_name IN BIS_BUCKET.short_name%TYPE := BIS_UTILITIES_PUB.G_NULL_CHAR
78: ,x_bis_bucket_rec OUT NOCOPY BIS_BUCKET_PUB.bis_bucket_rec_type
79: ,x_return_status OUT NOCOPY VARCHAR2

Line 76: PROCEDURE RETRIEVE_BIS_BUCKET (

72: );
73:
74:
75: --This API should call BIS_BUCKET_PVT.RETRIEVE _BIS_BUCKET
76: PROCEDURE RETRIEVE_BIS_BUCKET (
77: p_short_name IN BIS_BUCKET.short_name%TYPE := BIS_UTILITIES_PUB.G_NULL_CHAR
78: ,x_bis_bucket_rec OUT NOCOPY BIS_BUCKET_PUB.bis_bucket_rec_type
79: ,x_return_status OUT NOCOPY VARCHAR2
80: ,x_error_tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type

Line 77: p_short_name IN BIS_BUCKET.short_name%TYPE := BIS_UTILITIES_PUB.G_NULL_CHAR

73:
74:
75: --This API should call BIS_BUCKET_PVT.RETRIEVE _BIS_BUCKET
76: PROCEDURE RETRIEVE_BIS_BUCKET (
77: p_short_name IN BIS_BUCKET.short_name%TYPE := BIS_UTILITIES_PUB.G_NULL_CHAR
78: ,x_bis_bucket_rec OUT NOCOPY BIS_BUCKET_PUB.bis_bucket_rec_type
79: ,x_return_status OUT NOCOPY VARCHAR2
80: ,x_error_tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
81: );

Line 78: ,x_bis_bucket_rec OUT NOCOPY BIS_BUCKET_PUB.bis_bucket_rec_type

74:
75: --This API should call BIS_BUCKET_PVT.RETRIEVE _BIS_BUCKET
76: PROCEDURE RETRIEVE_BIS_BUCKET (
77: p_short_name IN BIS_BUCKET.short_name%TYPE := BIS_UTILITIES_PUB.G_NULL_CHAR
78: ,x_bis_bucket_rec OUT NOCOPY BIS_BUCKET_PUB.bis_bucket_rec_type
79: ,x_return_status OUT NOCOPY VARCHAR2
80: ,x_error_tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
81: );
82: -- This API is called from LCT file

Line 84: PROCEDURE LOAD_BIS_BUCKET (

80: ,x_error_tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
81: );
82: -- This API is called from LCT file
83: --=============================================================================
84: PROCEDURE LOAD_BIS_BUCKET (
85: p_bis_bucket_rec IN BIS_BUCKET_PUB.bis_bucket_rec_type
86: ,x_return_status OUT NOCOPY VARCHAR2
87: ,x_error_tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
88: );

Line 85: p_bis_bucket_rec IN BIS_BUCKET_PUB.bis_bucket_rec_type

81: );
82: -- This API is called from LCT file
83: --=============================================================================
84: PROCEDURE LOAD_BIS_BUCKET (
85: p_bis_bucket_rec IN BIS_BUCKET_PUB.bis_bucket_rec_type
86: ,x_return_status OUT NOCOPY VARCHAR2
87: ,x_error_tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
88: );
89: --=============================================================================

Line 93: END BIS_BUCKET_PUB;

89: --=============================================================================
90:
91: PROCEDURE ADD_LANGUAGE;
92:
93: END BIS_BUCKET_PUB;