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_LEVEL_PVT dependencies on BIS_DIMENSION_LEVEL_PUB

Line 96: ( p_Dimension_Level_Rec IN BIS_DIMENSION_LEVEL_PUB.Dimension_Level_Rec_Type

92: -- returns the record with the G_MISS_CHAR/G_MISS_NUM replaced
93: -- by null
94: --
95: PROCEDURE SetNULL
96: ( p_Dimension_Level_Rec IN BIS_DIMENSION_LEVEL_PUB.Dimension_Level_Rec_Type
97: , x_Dimension_Level_Rec OUT NOCOPY BIS_DIMENSION_LEVEL_PUB.Dimension_Level_Rec_Type
98: );
99: --
100: -- queries database to retrieve the dimension level from the database

Line 97: , x_Dimension_Level_Rec OUT NOCOPY BIS_DIMENSION_LEVEL_PUB.Dimension_Level_Rec_Type

93: -- by null
94: --
95: PROCEDURE SetNULL
96: ( p_Dimension_Level_Rec IN BIS_DIMENSION_LEVEL_PUB.Dimension_Level_Rec_Type
97: , x_Dimension_Level_Rec OUT NOCOPY BIS_DIMENSION_LEVEL_PUB.Dimension_Level_Rec_Type
98: );
99: --
100: -- queries database to retrieve the dimension level from the database
101: -- updates the record with the changes sent in

Line 104: ( p_Dimension_Level_Rec BIS_Dimension_Level_PUB.Dimension_Level_Rec_Type

100: -- queries database to retrieve the dimension level from the database
101: -- updates the record with the changes sent in
102: --
103: PROCEDURE UpdateRecord
104: ( p_Dimension_Level_Rec BIS_Dimension_Level_PUB.Dimension_Level_Rec_Type
105: , x_Dimension_Level_Rec OUT NOCOPY BIS_Dimension_Level_PUB.Dimension_Level_Rec_Type
106: , x_return_status OUT NOCOPY VARCHAR2
107: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
108: );

Line 105: , x_Dimension_Level_Rec OUT NOCOPY BIS_Dimension_Level_PUB.Dimension_Level_Rec_Type

101: -- updates the record with the changes sent in
102: --
103: PROCEDURE UpdateRecord
104: ( p_Dimension_Level_Rec BIS_Dimension_Level_PUB.Dimension_Level_Rec_Type
105: , x_Dimension_Level_Rec OUT NOCOPY BIS_Dimension_Level_PUB.Dimension_Level_Rec_Type
106: , x_return_status OUT NOCOPY VARCHAR2
107: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
108: );
109: --

Line 120: p_all_dim_levels_tbl IN BIS_DIMENSION_LEVEL_PUB.Dimension_Level_Tbl_Type

116: RETURN BOOLEAN;
117:
118: --==================================================================
119: PROCEDURE retrieve_sql(
120: p_all_dim_levels_tbl IN BIS_DIMENSION_LEVEL_PUB.Dimension_Level_Tbl_Type
121: ,x_is_bind OUT NOCOPY BOOLEAN
122: ,x_is_execute OUT NOCOPY BOOLEAN
123: ,x_sql OUT NOCOPY VARCHAR2
124: ,x_bind_variables_tbl OUT NOCOPY bind_variables_tbl_type

Line 130: ( p_Dimension_Level_Rec IN BIS_DIMENSION_LEVEL_PUB.Dimension_Level_Rec_Type

126:
127: --==================================================================
128: --
129: PROCEDURE SetNULL
130: ( p_Dimension_Level_Rec IN BIS_DIMENSION_LEVEL_PUB.Dimension_Level_Rec_Type
131: , x_Dimension_Level_Rec OUT NOCOPY BIS_DIMENSION_LEVEL_PUB.Dimension_Level_Rec_Type
132: )
133: IS
134: BEGIN

Line 131: , x_Dimension_Level_Rec OUT NOCOPY BIS_DIMENSION_LEVEL_PUB.Dimension_Level_Rec_Type

127: --==================================================================
128: --
129: PROCEDURE SetNULL
130: ( p_Dimension_Level_Rec IN BIS_DIMENSION_LEVEL_PUB.Dimension_Level_Rec_Type
131: , x_Dimension_Level_Rec OUT NOCOPY BIS_DIMENSION_LEVEL_PUB.Dimension_Level_Rec_Type
132: )
133: IS
134: BEGIN
135:

Line 204: ( p_Dimension_Level_Rec BIS_Dimension_Level_PUB.Dimension_Level_Rec_Type

200:
201: END SetNULL;
202: --
203: PROCEDURE UpdateRecord
204: ( p_Dimension_Level_Rec BIS_Dimension_Level_PUB.Dimension_Level_Rec_Type
205: , x_Dimension_Level_Rec OUT NOCOPY BIS_Dimension_Level_PUB.Dimension_Level_Rec_Type
206: , x_return_status OUT NOCOPY VARCHAR2
207: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
208: )

Line 205: , x_Dimension_Level_Rec OUT NOCOPY BIS_Dimension_Level_PUB.Dimension_Level_Rec_Type

201: END SetNULL;
202: --
203: PROCEDURE UpdateRecord
204: ( p_Dimension_Level_Rec BIS_Dimension_Level_PUB.Dimension_Level_Rec_Type
205: , x_Dimension_Level_Rec OUT NOCOPY BIS_Dimension_Level_PUB.Dimension_Level_Rec_Type
206: , x_return_status OUT NOCOPY VARCHAR2
207: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
208: )
209: IS

Line 211: l_Dimension_Level_Rec BIS_Dimension_Level_PUB.Dimension_Level_Rec_Type;

207: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
208: )
209: IS
210: --
211: l_Dimension_Level_Rec BIS_Dimension_Level_PUB.Dimension_Level_Rec_Type;
212: l_return_status VARCHAR2(10);
213: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;
214: --
215: BEGIN

Line 377: , x_Dimension_Level_Tbl OUT NOCOPY BIS_DIMENSION_LEVEL_PUB.Dimension_Level_Tbl_Type

373: --
374: Procedure Retrieve_Dimension_Levels
375: ( p_api_version IN NUMBER
376: , p_Dimension_Rec IN BIS_DIMENSION_PUB.Dimension_Rec_Type
377: , x_Dimension_Level_Tbl OUT NOCOPY BIS_DIMENSION_LEVEL_PUB.Dimension_Level_Tbl_Type
378: , x_return_status OUT NOCOPY VARCHAR2
379: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
380: )
381: IS

Line 384: l_dim_level_rec BIS_DIMENSION_LEVEL_PUB.Dimension_Level_Rec_Type;

380: )
381: IS
382: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;
383: l_dimension_rec BIS_DIMENSION_PUB.Dimension_Rec_Type;
384: l_dim_level_rec BIS_DIMENSION_LEVEL_PUB.Dimension_Level_Rec_Type;
385: --flag to check if there is an error
386: l_flag NUMBER :=0;
387: cursor cr_dim_id is
388: select dimension_id

Line 627: , p_Dimension_level_Rec IN BIS_DIMENSION_LEVEL_PUB.Dimension_Level_Rec_Type

623: END Retrieve_Dimension_Levels;
624: --
625: Procedure Retrieve_Dimension_Level
626: ( p_api_version IN NUMBER
627: , p_Dimension_level_Rec IN BIS_DIMENSION_LEVEL_PUB.Dimension_Level_Rec_Type
628: , x_Dimension_level_Rec IN OUT NOCOPY BIS_DIMENSION_LEVEL_PUB.Dimension_Level_Rec_Type
629: , x_return_status OUT NOCOPY VARCHAR2
630: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
631: )

Line 628: , x_Dimension_level_Rec IN OUT NOCOPY BIS_DIMENSION_LEVEL_PUB.Dimension_Level_Rec_Type

624: --
625: Procedure Retrieve_Dimension_Level
626: ( p_api_version IN NUMBER
627: , p_Dimension_level_Rec IN BIS_DIMENSION_LEVEL_PUB.Dimension_Level_Rec_Type
628: , x_Dimension_level_Rec IN OUT NOCOPY BIS_DIMENSION_LEVEL_PUB.Dimension_Level_Rec_Type
629: , x_return_status OUT NOCOPY VARCHAR2
630: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
631: )
632: IS

Line 879: ,p_all_dim_levels_tbl IN BIS_DIMENSION_LEVEL_PUB.Dimension_Level_Tbl_Type

875: -- The output plsql table will be indexed by dimension level id
876:
877: PROCEDURE retrieve_mult_dim_levels(
878: p_api_version IN NUMBER
879: ,p_all_dim_levels_tbl IN BIS_DIMENSION_LEVEL_PUB.Dimension_Level_Tbl_Type
880: ,x_all_dim_levels_tbl OUT NOCOPY BIS_DIMENSION_LEVEL_PUB.Dimension_Level_Tbl_Type
881: ,x_return_status OUT NOCOPY VARCHAR2
882: ,x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
883: )

Line 880: ,x_all_dim_levels_tbl OUT NOCOPY BIS_DIMENSION_LEVEL_PUB.Dimension_Level_Tbl_Type

876:
877: PROCEDURE retrieve_mult_dim_levels(
878: p_api_version IN NUMBER
879: ,p_all_dim_levels_tbl IN BIS_DIMENSION_LEVEL_PUB.Dimension_Level_Tbl_Type
880: ,x_all_dim_levels_tbl OUT NOCOPY BIS_DIMENSION_LEVEL_PUB.Dimension_Level_Tbl_Type
881: ,x_return_status OUT NOCOPY VARCHAR2
882: ,x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
883: )
884: IS

Line 888: l_dimension_level_rec BIS_DIMENSION_LEVEL_PUB.Dimension_Level_Rec_Type;

884: IS
885: TYPE ref_cursor_type IS REF CURSOR;
886: c_dim_level_details ref_cursor_type;
887:
888: l_dimension_level_rec BIS_DIMENSION_LEVEL_PUB.Dimension_Level_Rec_Type;
889: l_bind_var_tbl bind_variables_tbl_type;
890: l_sql VARCHAR2(32000);
891: l_is_bind BOOLEAN := FALSE;
892: l_is_execute BOOLEAN := FALSE;

Line 978: p_all_dim_levels_tbl IN BIS_DIMENSION_LEVEL_PUB.Dimension_Level_Tbl_Type

974:
975: --====================================================================
976:
977: PROCEDURE retrieve_sql(
978: p_all_dim_levels_tbl IN BIS_DIMENSION_LEVEL_PUB.Dimension_Level_Tbl_Type
979: ,x_is_bind OUT NOCOPY BOOLEAN
980: ,x_is_execute OUT NOCOPY BOOLEAN
981: ,x_sql OUT NOCOPY VARCHAR2
982: ,x_bind_variables_tbl OUT NOCOPY bind_variables_tbl_type

Line 1070: , p_Dimension_Level_Rec IN BIS_DIMENSION_LEVEL_PUB.Dimension_Level_Rec_Type

1066: Procedure Create_Dimension_Level
1067: ( p_api_version IN NUMBER
1068: , p_commit IN VARCHAR2 := FND_API.G_FALSE
1069: , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
1070: , p_Dimension_Level_Rec IN BIS_DIMENSION_LEVEL_PUB.Dimension_Level_Rec_Type
1071: , x_return_status OUT NOCOPY VARCHAR2
1072: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
1073: )
1074: IS

Line 1076: l_Dimension_Level_Rec BIS_DIMENSION_LEVEL_PUB.Dimension_Level_Rec_Type;

1072: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
1073: )
1074: IS
1075: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;
1076: l_Dimension_Level_Rec BIS_DIMENSION_LEVEL_PUB.Dimension_Level_Rec_Type;
1077: BEGIN
1078:
1079:
1080: l_Dimension_Level_Rec := p_Dimension_Level_Rec;

Line 1113: , p_Dimension_Level_Rec IN BIS_DIMENSION_LEVEL_PUB.Dimension_Level_Rec_Type

1109: PROCEDURE Create_Dimension_Level
1110: ( p_api_version IN NUMBER
1111: , p_commit IN VARCHAR2 := FND_API.G_FALSE
1112: , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
1113: , p_Dimension_Level_Rec IN BIS_DIMENSION_LEVEL_PUB.Dimension_Level_Rec_Type
1114: , p_owner IN VARCHAR2
1115: , x_return_status OUT NOCOPY VARCHAR2
1116: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
1117: )

Line 1122: l_Dimension_Level_Rec BIS_DIMENSION_LEVEL_PUB.Dimension_Level_Rec_Type;

1118: IS
1119: l_user_id NUMBER;
1120: l_login_id NUMBER;
1121: l_id NUMBER;
1122: l_Dimension_Level_Rec BIS_DIMENSION_LEVEL_PUB.Dimension_Level_Rec_Type;
1123: l_level_name_is_used BOOLEAN;
1124: l_msg VARCHAR2(1000);
1125: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;
1126:

Line 1489: , p_Dimension_Level_Rec IN BIS_DIMENSION_LEVEL_PUB.Dimension_Level_Rec_Type

1485: PROCEDURE Update_Dimension_Level
1486: ( p_api_version IN NUMBER
1487: , p_commit IN VARCHAR2 := FND_API.G_FALSE
1488: , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
1489: , p_Dimension_Level_Rec IN BIS_DIMENSION_LEVEL_PUB.Dimension_Level_Rec_Type
1490: , x_return_status OUT NOCOPY VARCHAR2
1491: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
1492: )
1493: IS

Line 1494: l_Dimension_Level_Rec BIS_DIMENSION_LEVEL_PUB.Dimension_Level_Rec_Type;

1490: , x_return_status OUT NOCOPY VARCHAR2
1491: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
1492: )
1493: IS
1494: l_Dimension_Level_Rec BIS_DIMENSION_LEVEL_PUB.Dimension_Level_Rec_Type;
1495: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;
1496: BEGIN
1497:
1498: l_Dimension_Level_Rec := p_Dimension_Level_Rec;

Line 1532: , p_Dimension_Level_Rec IN BIS_DIMENSION_LEVEL_PUB.Dimension_Level_Rec_Type

1528: PROCEDURE Update_Dimension_Level
1529: ( p_api_version IN NUMBER
1530: , p_commit IN VARCHAR2 := FND_API.G_FALSE
1531: , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
1532: , p_Dimension_Level_Rec IN BIS_DIMENSION_LEVEL_PUB.Dimension_Level_Rec_Type
1533: , p_owner IN VARCHAR2
1534: , x_return_status OUT NOCOPY VARCHAR2
1535: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
1536: )

Line 1540: l_Dimension_Level_Rec BIS_DIMENSION_LEVEL_PUB.Dimension_Level_Rec_Type;

1536: )
1537: IS
1538: l_user_id NUMBER;
1539: l_login_id NUMBER;
1540: l_Dimension_Level_Rec BIS_DIMENSION_LEVEL_PUB.Dimension_Level_Rec_Type;
1541: l_count NUMBER := 0;
1542: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;
1543: --exception
1544:

Line 1690: , p_Dimension_Level_Rec IN BIS_DIMENSION_LEVEL_PUB.Dimension_Level_Rec_Type

1686: Procedure Translate_Dimension_Level
1687: ( p_api_version IN NUMBER
1688: , p_commit IN VARCHAR2 := FND_API.G_FALSE
1689: , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
1690: , p_Dimension_Level_Rec IN BIS_DIMENSION_LEVEL_PUB.Dimension_Level_Rec_Type
1691: , x_return_status OUT NOCOPY VARCHAR2
1692: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
1693: )
1694: IS

Line 1696: l_Dimension_Level_Rec BIS_DIMENSION_LEVEL_PUB.Dimension_Level_Rec_Type;

1692: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
1693: )
1694: IS
1695: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;
1696: l_Dimension_Level_Rec BIS_DIMENSION_LEVEL_PUB.Dimension_Level_Rec_Type;
1697: BEGIN
1698:
1699: l_Dimension_Level_Rec := p_Dimension_Level_Rec;
1700: l_Dimension_Level_Rec.Last_Update_Date := NVL(p_Dimension_Level_Rec.Last_Update_Date, SYSDATE);

Line 1733: , p_Dimension_Level_Rec IN BIS_DIMENSION_LEVEL_PUB.Dimension_Level_Rec_Type

1729: Procedure Translate_Dimension_Level
1730: ( p_api_version IN NUMBER
1731: , p_commit IN VARCHAR2 := FND_API.G_FALSE
1732: , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
1733: , p_Dimension_Level_Rec IN BIS_DIMENSION_LEVEL_PUB.Dimension_Level_Rec_Type
1734: , p_owner IN VARCHAR2
1735: , x_return_status OUT NOCOPY VARCHAR2
1736: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
1737: )

Line 1742: l_Dimension_Level_Rec BIS_DIMENSION_LEVEL_PUB.Dimension_Level_Rec_Type;

1738: IS
1739: l_user_id NUMBER;
1740: l_login_id NUMBER;
1741: l_count NUMBER := 0;
1742: l_Dimension_Level_Rec BIS_DIMENSION_LEVEL_PUB.Dimension_Level_Rec_Type;
1743: l_error_tbl BIS_UTILITIES_PUB.Error_Tbl_Type;
1744:
1745: BEGIN
1746: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1817: , p_Dimension_Level_Rec IN BIS_DIMENSION_LEVEL_PUB.Dimension_Level_Rec_Type

1813: --
1814: -- Value - ID conversion
1815: PROCEDURE Value_ID_Conversion
1816: ( p_api_version IN NUMBER
1817: , p_Dimension_Level_Rec IN BIS_DIMENSION_LEVEL_PUB.Dimension_Level_Rec_Type
1818: , x_Dimension_Level_Rec OUT NOCOPY BIS_DIMENSION_LEVEL_PUB.Dimension_Level_Rec_Type
1819: , x_return_status OUT NOCOPY VARCHAR2
1820: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
1821: )

Line 1818: , x_Dimension_Level_Rec OUT NOCOPY BIS_DIMENSION_LEVEL_PUB.Dimension_Level_Rec_Type

1814: -- Value - ID conversion
1815: PROCEDURE Value_ID_Conversion
1816: ( p_api_version IN NUMBER
1817: , p_Dimension_Level_Rec IN BIS_DIMENSION_LEVEL_PUB.Dimension_Level_Rec_Type
1818: , x_Dimension_Level_Rec OUT NOCOPY BIS_DIMENSION_LEVEL_PUB.Dimension_Level_Rec_Type
1819: , x_return_status OUT NOCOPY VARCHAR2
1820: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
1821: )
1822: is

Line 1954: , p_Dimension_Level_Rec IN BIS_DIMENSION_LEVEL_PUB.Dimension_Level_Rec_Type

1950: -- Validates Dimension_Level
1951: PROCEDURE Validate_Dimension_Level
1952: ( p_api_version IN NUMBER
1953: , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
1954: , p_Dimension_Level_Rec IN BIS_DIMENSION_LEVEL_PUB.Dimension_Level_Rec_Type
1955: , x_return_status OUT NOCOPY VARCHAR2
1956: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
1957: )
1958: IS

Line 2017: , p_Dimension_Level_Rec IN BIS_Dimension_Level_PUB.Dimension_Level_Rec_Type

2013: PROCEDURE Delete_Dimension_Level
2014: (
2015: p_commit IN VARCHAR2 := FND_API.G_FALSE
2016: , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
2017: , p_Dimension_Level_Rec IN BIS_Dimension_Level_PUB.Dimension_Level_Rec_Type
2018: , x_return_status OUT NOCOPY VARCHAR2
2019: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
2020: ) IS
2021: l_dim_level_id NUMBER;

Line 2095: , p_Dimension_Level_Rec IN BIS_DIMENSION_LEVEL_PUB.Dimension_Level_Rec_Type

2091: PROCEDURE Trans_DimObj_By_Given_Lang
2092: (
2093: p_commit IN VARCHAR2 := FND_API.G_FALSE
2094: , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
2095: , p_Dimension_Level_Rec IN BIS_DIMENSION_LEVEL_PUB.Dimension_Level_Rec_Type
2096: , x_return_status OUT NOCOPY VARCHAR2
2097: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
2098: ) IS
2099: