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_DIMENSION_PVT dependencies on BIS_DIMENSION_PUB

Line 66: ( p_Dimension_Rec IN BIS_DIMENSION_PUB.Dimension_Rec_Type

62: -- returns the record with the G_MISS_CHAR/G_MISS_NUM replaced
63: -- by null
64: --
65: PROCEDURE SetNULL
66: ( p_Dimension_Rec IN BIS_DIMENSION_PUB.Dimension_Rec_Type
67: , x_Dimension_Rec OUT NOCOPY BIS_DIMENSION_PUB.Dimension_Rec_Type
68: );
69: --
70: -- queries database to retrieve the dimension from the database

Line 67: , x_Dimension_Rec OUT NOCOPY BIS_DIMENSION_PUB.Dimension_Rec_Type

63: -- by null
64: --
65: PROCEDURE SetNULL
66: ( p_Dimension_Rec IN BIS_DIMENSION_PUB.Dimension_Rec_Type
67: , x_Dimension_Rec OUT NOCOPY BIS_DIMENSION_PUB.Dimension_Rec_Type
68: );
69: --
70: -- queries database to retrieve the dimension from the database
71: -- updates the record with the changes sent in

Line 74: ( p_Dimension_Rec BIS_Dimension_PUB.Dimension_Rec_Type

70: -- queries database to retrieve the dimension from the database
71: -- updates the record with the changes sent in
72: --
73: PROCEDURE UpdateRecord
74: ( p_Dimension_Rec BIS_Dimension_PUB.Dimension_Rec_Type
75: , x_Dimension_Rec OUT NOCOPY BIS_Dimension_PUB.Dimension_Rec_Type
76: , x_return_status OUT NOCOPY VARCHAR2
77: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
78: );

Line 75: , x_Dimension_Rec OUT NOCOPY BIS_Dimension_PUB.Dimension_Rec_Type

71: -- updates the record with the changes sent in
72: --
73: PROCEDURE UpdateRecord
74: ( p_Dimension_Rec BIS_Dimension_PUB.Dimension_Rec_Type
75: , x_Dimension_Rec OUT NOCOPY BIS_Dimension_PUB.Dimension_Rec_Type
76: , x_return_status OUT NOCOPY VARCHAR2
77: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
78: );
79: --

Line 95: ( p_Dimension_Rec IN BIS_DIMENSION_PUB.Dimension_Rec_Type

91: p_last_update_date IN DATE := SYSDATE
92: );
93: --
94: PROCEDURE SetNULL
95: ( p_Dimension_Rec IN BIS_DIMENSION_PUB.Dimension_Rec_Type
96: , x_Dimension_Rec OUT NOCOPY BIS_DIMENSION_PUB.Dimension_Rec_Type
97: )
98: IS
99: BEGIN

Line 96: , x_Dimension_Rec OUT NOCOPY BIS_DIMENSION_PUB.Dimension_Rec_Type

92: );
93: --
94: PROCEDURE SetNULL
95: ( p_Dimension_Rec IN BIS_DIMENSION_PUB.Dimension_Rec_Type
96: , x_Dimension_Rec OUT NOCOPY BIS_DIMENSION_PUB.Dimension_Rec_Type
97: )
98: IS
99: BEGIN
100:

Line 133: ( p_Dimension_Rec BIS_Dimension_PUB.Dimension_Rec_Type

129:
130: END SetNULL;
131: --
132: PROCEDURE UpdateRecord
133: ( p_Dimension_Rec BIS_Dimension_PUB.Dimension_Rec_Type
134: , x_Dimension_Rec OUT NOCOPY BIS_Dimension_PUB.Dimension_Rec_Type
135: , x_return_status OUT NOCOPY VARCHAR2
136: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
137: )

Line 134: , x_Dimension_Rec OUT NOCOPY BIS_Dimension_PUB.Dimension_Rec_Type

130: END SetNULL;
131: --
132: PROCEDURE UpdateRecord
133: ( p_Dimension_Rec BIS_Dimension_PUB.Dimension_Rec_Type
134: , x_Dimension_Rec OUT NOCOPY BIS_Dimension_PUB.Dimension_Rec_Type
135: , x_return_status OUT NOCOPY VARCHAR2
136: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
137: )
138: IS

Line 140: l_Dimension_Rec BIS_Dimension_PUB.Dimension_Rec_Type;

136: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
137: )
138: IS
139: --
140: l_Dimension_Rec BIS_Dimension_PUB.Dimension_Rec_Type;
141: l_return_status VARCHAR2(10);
142: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;
143: --
144: BEGIN

Line 234: , x_Dimension_Tbl OUT NOCOPY BIS_DIMENSION_PUB.Dimension_Tbl_Type

230: --
231:
232: PROCEDURE Retrieve_Dimensions
233: ( p_api_version IN NUMBER
234: , x_Dimension_Tbl OUT NOCOPY BIS_DIMENSION_PUB.Dimension_Tbl_Type
235: , x_return_status OUT NOCOPY VARCHAR2
236: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
237: )
238: IS

Line 239: l_Dimension_Rec BIS_DIMENSION_PUB.Dimension_Rec_Type;

235: , x_return_status OUT NOCOPY VARCHAR2
236: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
237: )
238: IS
239: l_Dimension_Rec BIS_DIMENSION_PUB.Dimension_Rec_Type;
240: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;
241:
242: cursor cr_all_dimensions is
243: SELECT dimension_id

Line 296: , p_Dimension_Rec IN BIS_DIMENSION_PUB.Dimension_Rec_Type

292: --
293:
294: PROCEDURE Retrieve_Dimension
295: ( p_api_version IN NUMBER
296: , p_Dimension_Rec IN BIS_DIMENSION_PUB.Dimension_Rec_Type
297: , x_Dimension_Rec OUT NOCOPY BIS_DIMENSION_PUB.Dimension_Rec_Type
298: , x_return_status OUT NOCOPY VARCHAR2
299: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
300: )

Line 297: , x_Dimension_Rec OUT NOCOPY BIS_DIMENSION_PUB.Dimension_Rec_Type

293:
294: PROCEDURE Retrieve_Dimension
295: ( p_api_version IN NUMBER
296: , p_Dimension_Rec IN BIS_DIMENSION_PUB.Dimension_Rec_Type
297: , x_Dimension_Rec OUT NOCOPY BIS_DIMENSION_PUB.Dimension_Rec_Type
298: , x_return_status OUT NOCOPY VARCHAR2
299: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
300: )
301: is

Line 439: , p_Dimension_Rec IN BIS_DIMENSION_PUB.Dimension_Rec_Type

435: PROCEDURE Create_Dimension
436: ( p_api_version IN NUMBER
437: , p_commit IN VARCHAR2 := FND_API.G_FALSE
438: , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
439: , p_Dimension_Rec IN BIS_DIMENSION_PUB.Dimension_Rec_Type
440: , x_return_status OUT NOCOPY VARCHAR2
441: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
442: )
443: IS

Line 444: l_Dimension_Rec BIS_DIMENSION_PUB.Dimension_Rec_Type;

440: , x_return_status OUT NOCOPY VARCHAR2
441: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
442: )
443: IS
444: l_Dimension_Rec BIS_DIMENSION_PUB.Dimension_Rec_Type;
445: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;
446: BEGIN
447: l_Dimension_Rec := p_Dimension_Rec;
448: l_Dimension_Rec.Last_Update_Date := NVL(p_Dimension_Rec.Last_Update_Date, SYSDATE);

Line 479: , p_Dimension_Rec IN BIS_DIMENSION_PUB.Dimension_Rec_Type

475: PROCEDURE Create_Dimension
476: ( p_api_version IN NUMBER
477: , p_commit IN VARCHAR2 := FND_API.G_FALSE
478: , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
479: , p_Dimension_Rec IN BIS_DIMENSION_PUB.Dimension_Rec_Type
480: , p_owner IN VARCHAR2
481: , x_return_status OUT NOCOPY VARCHAR2
482: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
483: )

Line 488: l_Dimension_Rec BIS_DIMENSION_PUB.Dimension_Rec_Type;

484: IS
485: l_user_id NUMBER;
486: l_login_id NUMBER;
487: l_id NUMBER;
488: l_Dimension_Rec BIS_DIMENSION_PUB.Dimension_Rec_Type;
489: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;
490:
491: DUPLICATE_DIMENSION_VALUE EXCEPTION;
492: PRAGMA EXCEPTION_INIT(DUPLICATE_DIMENSION_VALUE, -1);

Line 714: , p_Dimension_Rec IN BIS_DIMENSION_PUB.Dimension_Rec_Type

710: PROCEDURE Update_Dimension
711: ( p_api_version IN NUMBER
712: , p_commit IN VARCHAR2 := FND_API.G_FALSE
713: , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
714: , p_Dimension_Rec IN BIS_DIMENSION_PUB.Dimension_Rec_Type
715: , x_return_status OUT NOCOPY VARCHAR2
716: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
717: )
718: IS

Line 720: l_Dimension_Rec BIS_DIMENSION_PUB.Dimension_Rec_Type;

716: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
717: )
718: IS
719: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;
720: l_Dimension_Rec BIS_DIMENSION_PUB.Dimension_Rec_Type;
721: BEGIN
722:
723: l_Dimension_Rec := p_Dimension_Rec;
724: l_Dimension_Rec.Last_Update_Date := NVL(p_Dimension_Rec.Last_Update_Date, SYSDATE);

Line 756: , p_Dimension_Rec IN BIS_DIMENSION_PUB.Dimension_Rec_Type

752: PROCEDURE Update_Dimension
753: ( p_api_version IN NUMBER
754: , p_commit IN VARCHAR2 := FND_API.G_FALSE
755: , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
756: , p_Dimension_Rec IN BIS_DIMENSION_PUB.Dimension_Rec_Type
757: , p_owner IN VARCHAR2
758: , x_return_status OUT NOCOPY VARCHAR2
759: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
760: )

Line 766: l_Dimension_Rec BIS_DIMENSION_PUB.Dimension_Rec_Type;

762:
763: l_user_id number;
764: l_login_id number;
765: l_count NUMBER := 0;
766: l_Dimension_Rec BIS_DIMENSION_PUB.Dimension_Rec_Type;
767: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;
768:
769: DUPLICATE_DIMENSION_VALUE EXCEPTION;
770: PRAGMA EXCEPTION_INIT(DUPLICATE_DIMENSION_VALUE, -1);

Line 876: , p_Dimension_Rec IN BIS_DIMENSION_PUB.Dimension_Rec_Type

872: PROCEDURE Translate_Dimension
873: ( p_api_version IN NUMBER
874: , p_commit IN VARCHAR2 := FND_API.G_FALSE
875: , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
876: , p_Dimension_Rec IN BIS_DIMENSION_PUB.Dimension_Rec_Type
877: , x_return_status OUT NOCOPY VARCHAR2
878: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
879: )
880: IS

Line 882: l_Dimension_Rec BIS_DIMENSION_PUB.Dimension_Rec_Type;

878: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
879: )
880: IS
881: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;
882: l_Dimension_Rec BIS_DIMENSION_PUB.Dimension_Rec_Type;
883: BEGIN
884:
885: l_Dimension_Rec := p_Dimension_Rec;
886: l_Dimension_Rec.Last_Update_Date := NVL(p_Dimension_Rec.Last_Update_Date, SYSDATE);

Line 918: , p_Dimension_Rec IN BIS_DIMENSION_PUB.Dimension_Rec_Type

914: PROCEDURE Translate_Dimension
915: ( p_api_version IN NUMBER
916: , p_commit IN VARCHAR2 := FND_API.G_FALSE
917: , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
918: , p_Dimension_Rec IN BIS_DIMENSION_PUB.Dimension_Rec_Type
919: , p_owner IN VARCHAR2
920: , x_return_status OUT NOCOPY VARCHAR2
921: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
922: )

Line 927: l_Dimension_Rec BIS_DIMENSION_PUB.Dimension_Rec_Type;

923: IS
924: l_user_id NUMBER;
925: l_login_id NUMBER;
926: l_count NUMBER := 0;
927: l_Dimension_Rec BIS_DIMENSION_PUB.Dimension_Rec_Type;
928: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;
929:
930: BEGIN
931:

Line 1002: , p_Dimension_Rec IN BIS_DIMENSION_PUB.Dimension_Rec_Type

998: --
999: PROCEDURE Validate_Dimension
1000: ( p_api_version IN NUMBER
1001: , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
1002: , p_Dimension_Rec IN BIS_DIMENSION_PUB.Dimension_Rec_Type
1003: , x_return_status OUT NOCOPY VARCHAR2
1004: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
1005: )
1006: IS

Line 1063: , p_Dimension_Rec IN BIS_DIMENSION_PUB.Dimension_Rec_Type

1059: --
1060: -- Value - ID conversion
1061: PROCEDURE Value_ID_Conversion
1062: ( p_api_version IN NUMBER
1063: , p_Dimension_Rec IN BIS_DIMENSION_PUB.Dimension_Rec_Type
1064: , x_Dimension_Rec IN OUT NOCOPY BIS_DIMENSION_PUB.Dimension_Rec_Type
1065: , x_return_status OUT NOCOPY VARCHAR2
1066: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
1067: )

Line 1064: , x_Dimension_Rec IN OUT NOCOPY BIS_DIMENSION_PUB.Dimension_Rec_Type

1060: -- Value - ID conversion
1061: PROCEDURE Value_ID_Conversion
1062: ( p_api_version IN NUMBER
1063: , p_Dimension_Rec IN BIS_DIMENSION_PUB.Dimension_Rec_Type
1064: , x_Dimension_Rec IN OUT NOCOPY BIS_DIMENSION_PUB.Dimension_Rec_Type
1065: , x_return_status OUT NOCOPY VARCHAR2
1066: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
1067: )
1068: IS

Line 1169: ( p_dimension_rec BIS_DIMENSION_PUB.Dimension_Rec_Type

1165: END Value_ID_Conversion;
1166: --
1167: /* modified from ansingha's FUNCTION */
1168: FUNCTION DuplicateDimension
1169: ( p_dimension_rec BIS_DIMENSION_PUB.Dimension_Rec_Type
1170: , p_dimensions_tbl BIS_DIMENSION_PUB.Dimension_Tbl_Type
1171: ) return BOOLEAN
1172: is
1173: begin

Line 1170: , p_dimensions_tbl BIS_DIMENSION_PUB.Dimension_Tbl_Type

1166: --
1167: /* modified from ansingha's FUNCTION */
1168: FUNCTION DuplicateDimension
1169: ( p_dimension_rec BIS_DIMENSION_PUB.Dimension_Rec_Type
1170: , p_dimensions_tbl BIS_DIMENSION_PUB.Dimension_Tbl_Type
1171: ) return BOOLEAN
1172: is
1173: begin
1174: for i in 1 .. p_dimensions_tbl.count loop

Line 1194: ( p_dimension_table in BIS_DIMENSION_PUB.Dimension_tbl_type

1190:
1191: END DuplicateDimension;
1192: --
1193: PROCEDURE RemoveDuplicates
1194: ( p_dimension_table in BIS_DIMENSION_PUB.Dimension_tbl_type
1195: , p_all_dimension_table in BIS_DIMENSION_PUB.Dimension_tbl_type
1196: , x_all_dimension_table out NOCOPY BIS_DIMENSION_PUB.Dimension_tbl_type
1197: )
1198: is

Line 1195: , p_all_dimension_table in BIS_DIMENSION_PUB.Dimension_tbl_type

1191: END DuplicateDimension;
1192: --
1193: PROCEDURE RemoveDuplicates
1194: ( p_dimension_table in BIS_DIMENSION_PUB.Dimension_tbl_type
1195: , p_all_dimension_table in BIS_DIMENSION_PUB.Dimension_tbl_type
1196: , x_all_dimension_table out NOCOPY BIS_DIMENSION_PUB.Dimension_tbl_type
1197: )
1198: is
1199: l_unique BOOLEAN;

Line 1196: , x_all_dimension_table out NOCOPY BIS_DIMENSION_PUB.Dimension_tbl_type

1192: --
1193: PROCEDURE RemoveDuplicates
1194: ( p_dimension_table in BIS_DIMENSION_PUB.Dimension_tbl_type
1195: , p_all_dimension_table in BIS_DIMENSION_PUB.Dimension_tbl_type
1196: , x_all_dimension_table out NOCOPY BIS_DIMENSION_PUB.Dimension_tbl_type
1197: )
1198: is
1199: l_unique BOOLEAN;
1200: l_rec BIS_DIMENSION_PUB.Dimension_Rec_Type;

Line 1200: l_rec BIS_DIMENSION_PUB.Dimension_Rec_Type;

1196: , x_all_dimension_table out NOCOPY BIS_DIMENSION_PUB.Dimension_tbl_type
1197: )
1198: is
1199: l_unique BOOLEAN;
1200: l_rec BIS_DIMENSION_PUB.Dimension_Rec_Type;
1201: begin
1202: --
1203: for i in 1 .. p_all_dimension_table.count loop
1204: l_rec := p_all_dimension_table(i);

Line 1227: , p_Dimension_Rec IN BIS_DIMENSION_PUB.Dimension_Rec_Type

1223: PROCEDURE Delete_Dimension
1224: (
1225: p_commit IN VARCHAR2 := FND_API.G_FALSE
1226: , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
1227: , p_Dimension_Rec IN BIS_DIMENSION_PUB.Dimension_Rec_Type
1228: , x_return_status OUT NOCOPY VARCHAR2
1229: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
1230: ) IS
1231: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;

Line 1232: l_Dimension_Rec BIS_DIMENSION_PUB.Dimension_Rec_Type;

1228: , x_return_status OUT NOCOPY VARCHAR2
1229: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
1230: ) IS
1231: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;
1232: l_Dimension_Rec BIS_DIMENSION_PUB.Dimension_Rec_Type;
1233: BEGIN
1234: SAVEPOINT DeleteFromBISDims;
1235:
1236: BIS_DIMENSION_PVT.Retrieve_Dimension

Line 1284: , p_Dimension_Rec IN BIS_DIMENSION_PUB.Dimension_Rec_Type

1280: PROCEDURE Translate_Dim_By_Given_Lang
1281: (
1282: p_commit IN VARCHAR2 := FND_API.G_FALSE
1283: , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
1284: , p_Dimension_Rec IN BIS_DIMENSION_PUB.Dimension_Rec_Type
1285: , x_return_status OUT NOCOPY VARCHAR2
1286: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
1287: ) IS
1288: