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_PVT dependencies on BIS_BUCKET_PUB

Line 6: p_bis_bucket_rec IN BIS_BUCKET_PUB.bis_bucket_rec_type

2: /* $Header: BISVBKTB.pls 120.1 2006/07/26 07:58:21 ankgoel noship $ */
3:
4: --=============================================================================
5: FUNCTION CHECK_RANGE_NAME (
6: p_bis_bucket_rec IN BIS_BUCKET_PUB.bis_bucket_rec_type
7: ) RETURN BOOLEAN;
8: --=============================================================================
9: FUNCTION CHECK_RANGE_VAL_LOW (
10: p_bis_bucket_rec IN BIS_BUCKET_PUB.bis_bucket_rec_type

Line 10: p_bis_bucket_rec IN BIS_BUCKET_PUB.bis_bucket_rec_type

6: p_bis_bucket_rec IN BIS_BUCKET_PUB.bis_bucket_rec_type
7: ) RETURN BOOLEAN;
8: --=============================================================================
9: FUNCTION CHECK_RANGE_VAL_LOW (
10: p_bis_bucket_rec IN BIS_BUCKET_PUB.bis_bucket_rec_type
11: ) RETURN BOOLEAN;
12: --=============================================================================
13: FUNCTION CHECK_RANGE_VAL_HIGH (
14: p_bis_bucket_rec IN BIS_BUCKET_PUB.bis_bucket_rec_type

Line 14: p_bis_bucket_rec IN BIS_BUCKET_PUB.bis_bucket_rec_type

10: p_bis_bucket_rec IN BIS_BUCKET_PUB.bis_bucket_rec_type
11: ) RETURN BOOLEAN;
12: --=============================================================================
13: FUNCTION CHECK_RANGE_VAL_HIGH (
14: p_bis_bucket_rec IN BIS_BUCKET_PUB.bis_bucket_rec_type
15: ) RETURN BOOLEAN;
16: --=============================================================================
17: PROCEDURE sync_bucket_ranges (
18: p_id IN NUMBER

Line 71: l_bis_bucket_rec BIS_BUCKET_PUB.bis_bucket_rec_type;

67: ,x_error_msg OUT NOCOPY VARCHAR2
68: )
69: IS
70:
71: l_bis_bucket_rec BIS_BUCKET_PUB.bis_bucket_rec_type;
72: l_return_status VARCHAR2(10);
73: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;
74:
75: BEGIN

Line 196: l_bis_bucket_rec BIS_BUCKET_PUB.bis_bucket_rec_type;

192: ,x_error_msg OUT NOCOPY VARCHAR2
193: )
194: IS
195:
196: l_bis_bucket_rec BIS_BUCKET_PUB.bis_bucket_rec_type;
197: l_return_status VARCHAR2(10);
198: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;
199: l_ret VARCHAR2(10);
200:

Line 776: l_bis_bucket_rec BIS_BUCKET_PUB.bis_bucket_rec_type;

772: ,x_error_msg OUT NOCOPY VARCHAR2
773: )
774: IS
775:
776: l_bis_bucket_rec BIS_BUCKET_PUB.bis_bucket_rec_type;
777: l_return_status VARCHAR2(10);
778: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;
779:
780: BEGIN

Line 892: p_bis_bucket_rec IN BIS_BUCKET_PUB.bis_bucket_rec_type

888:
889: --This API should generate the bucket_id in sequence and insert the data passed to it,
890: --into the tables BIS_BUCKET, BIS_BUCKET_TL
891: PROCEDURE CREATE_BIS_BUCKET (
892: p_bis_bucket_rec IN BIS_BUCKET_PUB.bis_bucket_rec_type
893: ,x_return_status OUT NOCOPY VARCHAR2
894: ,x_error_tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
895: )
896: IS

Line 905: l_bis_bucket_rec BIS_BUCKET_PUB.bis_bucket_rec_type;

901: l_login_id NUMBER;
902: l_short_count NUMBER;
903: l_fnd_type_count NUMBER;
904: l_bis_type_count NUMBER;
905: l_bis_bucket_rec BIS_BUCKET_PUB.bis_bucket_rec_type;
906: l_return_status VARCHAR2(10);
907: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;
908:
909: BEGIN

Line 1212: p_bis_bucket_rec IN BIS_BUCKET_PUB.bis_bucket_rec_type

1208:
1209: --This API should update the tables BIS_BUCKET, BIS_BUCKET_TL
1210: --using the short name or the bucket id as the where clause value
1211: PROCEDURE UPDATE_BIS_BUCKET (
1212: p_bis_bucket_rec IN BIS_BUCKET_PUB.bis_bucket_rec_type
1213: ,x_return_status OUT NOCOPY VARCHAR2
1214: ,x_error_tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
1215: )
1216: IS

Line 1218: --l_bis_bucket_rec_orig BIS_BUCKET_PUB.bis_bucket_rec_type;

1214: ,x_error_tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
1215: )
1216: IS
1217:
1218: --l_bis_bucket_rec_orig BIS_BUCKET_PUB.bis_bucket_rec_type;
1219: l_bis_bucket_rec BIS_BUCKET_PUB.bis_bucket_rec_type;
1220: l_return_status VARCHAR2(10);
1221: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;
1222: l_user_id NUMBER;

Line 1219: l_bis_bucket_rec BIS_BUCKET_PUB.bis_bucket_rec_type;

1215: )
1216: IS
1217:
1218: --l_bis_bucket_rec_orig BIS_BUCKET_PUB.bis_bucket_rec_type;
1219: l_bis_bucket_rec BIS_BUCKET_PUB.bis_bucket_rec_type;
1220: l_return_status VARCHAR2(10);
1221: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;
1222: l_user_id NUMBER;
1223: l_login_id NUMBER;

Line 1583: ,x_bis_bucket_rec OUT NOCOPY BIS_BUCKET_PUB.bis_bucket_rec_type

1579: -- Modified for bug #3394457 , ankgoel
1580: -- Retrieve the record always from the customization table
1581: PROCEDURE RETRIEVE_BIS_BUCKET (
1582: p_short_name IN BIS_BUCKET.short_name%TYPE := BIS_UTILITIES_PUB.G_NULL_CHAR
1583: ,x_bis_bucket_rec OUT NOCOPY BIS_BUCKET_PUB.bis_bucket_rec_type
1584: ,x_return_status OUT NOCOPY VARCHAR2
1585: ,x_error_tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
1586: )
1587: IS

Line 1739: p_bis_bucket_rec IN BIS_BUCKET_PUB.bis_bucket_rec_type

1735:
1736: END RETRIEVE_BIS_BUCKET;
1737:
1738: PROCEDURE TRANSLATE_BUCKET (
1739: p_bis_bucket_rec IN BIS_BUCKET_PUB.bis_bucket_rec_type
1740: ,p_owner IN VARCHAR2
1741: ,x_return_status OUT NOCOPY VARCHAR2
1742: ,x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
1743: )

Line 1748: l_bis_bucket_rec BIS_BUCKET_PUB.bis_bucket_rec_type;

1744: IS
1745:
1746: l_user_id NUMBER;
1747: l_login_id NUMBER;
1748: l_bis_bucket_rec BIS_BUCKET_PUB.bis_bucket_rec_type;
1749: l_bis_bucket_rec_orig BIS_BUCKET_PUB.bis_bucket_rec_type;
1750: l_return_status VARCHAR2(10);
1751: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;
1752:

Line 1749: l_bis_bucket_rec_orig BIS_BUCKET_PUB.bis_bucket_rec_type;

1745:
1746: l_user_id NUMBER;
1747: l_login_id NUMBER;
1748: l_bis_bucket_rec BIS_BUCKET_PUB.bis_bucket_rec_type;
1749: l_bis_bucket_rec_orig BIS_BUCKET_PUB.bis_bucket_rec_type;
1750: l_return_status VARCHAR2(10);
1751: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;
1752:
1753: BEGIN

Line 1845: p_bis_bucket_rec IN BIS_BUCKET_PUB.bis_bucket_rec_type

1841: END TRANSLATE_BUCKET;
1842:
1843:
1844: FUNCTION CHECK_RANGE_NAME (
1845: p_bis_bucket_rec IN BIS_BUCKET_PUB.bis_bucket_rec_type
1846: ) RETURN BOOLEAN
1847: IS
1848:
1849: TYPE range_name_t IS TABLE OF VARCHAR2(80) INDEX BY BINARY_INTEGER;

Line 2012: p_bis_bucket_rec IN BIS_BUCKET_PUB.bis_bucket_rec_type

2008: END CHECK_RANGE_NAME;
2009:
2010: --=============================================================================
2011: FUNCTION CHECK_RANGE_VAL_LOW (
2012: p_bis_bucket_rec IN BIS_BUCKET_PUB.bis_bucket_rec_type
2013: ) RETURN BOOLEAN
2014: IS
2015:
2016: TYPE range_low_t IS TABLE OF VARCHAR2(30) INDEX BY BINARY_INTEGER;

Line 2177: p_bis_bucket_rec IN BIS_BUCKET_PUB.bis_bucket_rec_type

2173:
2174: END CHECK_RANGE_VAL_LOW;
2175: --=============================================================================
2176: FUNCTION CHECK_RANGE_VAL_HIGH (
2177: p_bis_bucket_rec IN BIS_BUCKET_PUB.bis_bucket_rec_type
2178: ) RETURN BOOLEAN
2179: IS
2180:
2181: TYPE range_high_t IS TABLE OF VARCHAR2(30) INDEX BY BINARY_INTEGER;

Line 2382: p_bis_bucket_rec IN BIS_BUCKET_PUB.bis_bucket_rec_type

2378:
2379: END IS_BUCKET_TYPE_EXISTS;
2380: --=============================================================================
2381: PROCEDURE Validate_Bucket (
2382: p_bis_bucket_rec IN BIS_BUCKET_PUB.bis_bucket_rec_type
2383: ,x_return_status OUT NOCOPY VARCHAR2
2384: ,x_error_tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
2385: ) IS
2386:

Line 2388: l_bis_bucket_rec BIS_BUCKET_PUB.bis_bucket_rec_type;

2384: ,x_error_tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
2385: ) IS
2386:
2387: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;
2388: l_bis_bucket_rec BIS_BUCKET_PUB.bis_bucket_rec_type;
2389:
2390: l_bucket_ranges_tbl BIS_BUCKET_PVT.BIS_BUCKET_RANGES_TBL;
2391:
2392: BEGIN

Line 2522: p_bis_bucket_rec IN BIS_BUCKET_PUB.bis_bucket_rec_type

2518: -- If the bucket has no label, it doesn't count as a valid bucket.
2519: --=============================================================================
2520: PROCEDURE Populate_Loc_Bucket_Range_Tbl
2521: (
2522: p_bis_bucket_rec IN BIS_BUCKET_PUB.bis_bucket_rec_type
2523: ,x_bucket_ranges_tbl OUT NOCOPY BIS_BUCKET_PVT.bis_bucket_ranges_tbl
2524: ,x_return_status OUT NOCOPY VARCHAR2
2525: ,x_error_tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
2526: )

Line 2855: l_bis_bucket_rec BIS_BUCKET_PUB.bis_bucket_rec_type;

2851: ,x_error_msg OUT NOCOPY VARCHAR2
2852: )
2853: IS
2854:
2855: l_bis_bucket_rec BIS_BUCKET_PUB.bis_bucket_rec_type;
2856: l_return_status VARCHAR2(10);
2857: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;
2858:
2859: BEGIN

Line 2954: p_bis_bucket_rec IN BIS_BUCKET_PUB.bis_bucket_rec_type

2950:
2951: --=============================================================================
2952: --The common validation that good for bucket. (Normal, Customized)
2953: PROCEDURE Validate_Bucket_Common (
2954: p_bis_bucket_rec IN BIS_BUCKET_PUB.bis_bucket_rec_type
2955: ,x_return_status OUT NOCOPY VARCHAR2
2956: ,x_error_tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
2957: ) IS
2958:

Line 2960: l_bis_bucket_rec BIS_BUCKET_PUB.bis_bucket_rec_type;

2956: ,x_error_tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
2957: ) IS
2958:
2959: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;
2960: l_bis_bucket_rec BIS_BUCKET_PUB.bis_bucket_rec_type;
2961:
2962: l_bucket_ranges_tbl BIS_BUCKET_PVT.BIS_BUCKET_RANGES_TBL;
2963:
2964: BEGIN