DBA Data[Home] [Help]

APPS.BIS_DIMENSION_PVT dependencies on BIS_DIMENSION_PUB

Line 36: , x_Dimension_Tbl OUT NOCOPY BIS_DIMENSION_PUB.Dimension_Tbl_Type

32: --
33: --
34: Procedure Retrieve_Dimensions
35: ( p_api_version IN NUMBER
36: , x_Dimension_Tbl OUT NOCOPY BIS_DIMENSION_PUB.Dimension_Tbl_Type
37: , x_return_status OUT NOCOPY VARCHAR2
38: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
39: );
40: --

Line 43: , p_Dimension_Rec IN BIS_DIMENSION_PUB.Dimension_Rec_Type

39: );
40: --
41: Procedure Retrieve_Dimension
42: ( p_api_version IN NUMBER
43: , p_Dimension_Rec IN BIS_DIMENSION_PUB.Dimension_Rec_Type
44: , x_Dimension_Rec OUT NOCOPY BIS_DIMENSION_PUB.Dimension_Rec_Type
45: , x_return_status OUT NOCOPY VARCHAR2
46: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
47: );

Line 44: , x_Dimension_Rec OUT NOCOPY BIS_DIMENSION_PUB.Dimension_Rec_Type

40: --
41: Procedure Retrieve_Dimension
42: ( p_api_version IN NUMBER
43: , p_Dimension_Rec IN BIS_DIMENSION_PUB.Dimension_Rec_Type
44: , x_Dimension_Rec OUT NOCOPY BIS_DIMENSION_PUB.Dimension_Rec_Type
45: , x_return_status OUT NOCOPY VARCHAR2
46: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
47: );
48: --

Line 53: , p_Dimension_Rec IN BIS_DIMENSION_PUB.Dimension_Rec_Type

49: Procedure Create_Dimension
50: ( p_api_version IN NUMBER
51: , p_commit IN VARCHAR2 := FND_API.G_FALSE
52: , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
53: , p_Dimension_Rec IN BIS_DIMENSION_PUB.Dimension_Rec_Type
54: , x_return_status OUT NOCOPY VARCHAR2
55: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
56: );
57: --

Line 62: , p_Dimension_Rec IN BIS_DIMENSION_PUB.Dimension_Rec_Type

58: Procedure Create_Dimension
59: ( p_api_version IN NUMBER
60: , p_commit IN VARCHAR2 := FND_API.G_FALSE
61: , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
62: , p_Dimension_Rec IN BIS_DIMENSION_PUB.Dimension_Rec_Type
63: , p_owner IN VARCHAR2
64: , x_return_status OUT NOCOPY VARCHAR2
65: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
66: );

Line 72: , p_Dimension_Rec IN BIS_DIMENSION_PUB.Dimension_Rec_Type

68: Procedure Update_Dimension
69: ( p_api_version IN NUMBER
70: , p_commit IN VARCHAR2 := FND_API.G_FALSE
71: , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
72: , p_Dimension_Rec IN BIS_DIMENSION_PUB.Dimension_Rec_Type
73: , x_return_status OUT NOCOPY VARCHAR2
74: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
75: );
76: --

Line 81: , p_Dimension_Rec IN BIS_DIMENSION_PUB.Dimension_Rec_Type

77: Procedure Update_Dimension
78: ( p_api_version IN NUMBER
79: , p_commit IN VARCHAR2 := FND_API.G_FALSE
80: , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
81: , p_Dimension_Rec IN BIS_DIMENSION_PUB.Dimension_Rec_Type
82: , p_owner IN VARCHAR2
83: , x_return_status OUT NOCOPY VARCHAR2
84: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
85: );

Line 91: , p_Dimension_Rec IN BIS_DIMENSION_PUB.Dimension_Rec_Type

87: Procedure Translate_Dimension
88: ( p_api_version IN NUMBER
89: , p_commit IN VARCHAR2 := FND_API.G_FALSE
90: , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
91: , p_Dimension_Rec IN BIS_DIMENSION_PUB.Dimension_Rec_Type
92: , x_return_status OUT NOCOPY VARCHAR2
93: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
94: );
95: --

Line 100: , p_Dimension_Rec IN BIS_DIMENSION_PUB.Dimension_Rec_Type

96: Procedure Translate_Dimension
97: ( p_api_version IN NUMBER
98: , p_commit IN VARCHAR2 := FND_API.G_FALSE
99: , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
100: , p_Dimension_Rec IN BIS_DIMENSION_PUB.Dimension_Rec_Type
101: , p_owner IN VARCHAR2 := BIS_UTILITIES_PUB.G_CUSTOM_OWNER
102: , x_return_status OUT NOCOPY VARCHAR2
103: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
104: );

Line 109: , p_Dimension_Rec IN BIS_DIMENSION_PUB.Dimension_Rec_Type

105: --
106: -- Value - ID conversion
107: PROCEDURE Value_ID_Conversion
108: ( p_api_version IN NUMBER
109: , p_Dimension_Rec IN BIS_DIMENSION_PUB.Dimension_Rec_Type
110: , x_Dimension_Rec IN OUT NOCOPY BIS_DIMENSION_PUB.Dimension_Rec_Type
111: , x_return_status OUT NOCOPY VARCHAR2
112: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
113: );

Line 110: , x_Dimension_Rec IN OUT NOCOPY BIS_DIMENSION_PUB.Dimension_Rec_Type

106: -- Value - ID conversion
107: PROCEDURE Value_ID_Conversion
108: ( p_api_version IN NUMBER
109: , p_Dimension_Rec IN BIS_DIMENSION_PUB.Dimension_Rec_Type
110: , x_Dimension_Rec IN OUT NOCOPY BIS_DIMENSION_PUB.Dimension_Rec_Type
111: , x_return_status OUT NOCOPY VARCHAR2
112: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
113: );
114: --

Line 118: , p_Dimension_Rec IN BIS_DIMENSION_PUB.Dimension_Rec_Type

114: --
115: PROCEDURE Validate_Dimension
116: ( p_api_version IN NUMBER
117: , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
118: , p_Dimension_Rec IN BIS_DIMENSION_PUB.Dimension_Rec_Type
119: , x_return_status OUT NOCOPY VARCHAR2
120: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
121: );
122: --

Line 134: ( p_dimension_rec BIS_DIMENSION_PUB.Dimension_Rec_Type

130: );
131: --
132: /* modified from ansingha's function */
133: FUNCTION DuplicateDimension
134: ( p_dimension_rec BIS_DIMENSION_PUB.Dimension_Rec_Type
135: , p_dimensions_tbl BIS_DIMENSION_PUB.Dimension_Tbl_Type
136: ) return BOOLEAN;
137: --
138: -- removes the dimensions from p_all_dimension_table

Line 135: , p_dimensions_tbl BIS_DIMENSION_PUB.Dimension_Tbl_Type

131: --
132: /* modified from ansingha's function */
133: FUNCTION DuplicateDimension
134: ( p_dimension_rec BIS_DIMENSION_PUB.Dimension_Rec_Type
135: , p_dimensions_tbl BIS_DIMENSION_PUB.Dimension_Tbl_Type
136: ) return BOOLEAN;
137: --
138: -- removes the dimensions from p_all_dimension_table
139: -- which are in p_dimension_table

Line 141: ( p_dimension_table in BIS_DIMENSION_PUB.Dimension_tbl_type

137: --
138: -- removes the dimensions from p_all_dimension_table
139: -- which are in p_dimension_table
140: PROCEDURE RemoveDuplicates
141: ( p_dimension_table in BIS_DIMENSION_PUB.Dimension_tbl_type
142: , p_all_dimension_table in BIS_DIMENSION_PUB.Dimension_tbl_type
143: , x_all_dimension_table out NOCOPY BIS_DIMENSION_PUB.Dimension_tbl_type
144: );
145: --

Line 142: , p_all_dimension_table in BIS_DIMENSION_PUB.Dimension_tbl_type

138: -- removes the dimensions from p_all_dimension_table
139: -- which are in p_dimension_table
140: PROCEDURE RemoveDuplicates
141: ( p_dimension_table in BIS_DIMENSION_PUB.Dimension_tbl_type
142: , p_all_dimension_table in BIS_DIMENSION_PUB.Dimension_tbl_type
143: , x_all_dimension_table out NOCOPY BIS_DIMENSION_PUB.Dimension_tbl_type
144: );
145: --
146: PROCEDURE Delete_Dimension

Line 143: , x_all_dimension_table out NOCOPY BIS_DIMENSION_PUB.Dimension_tbl_type

139: -- which are in p_dimension_table
140: PROCEDURE RemoveDuplicates
141: ( p_dimension_table in BIS_DIMENSION_PUB.Dimension_tbl_type
142: , p_all_dimension_table in BIS_DIMENSION_PUB.Dimension_tbl_type
143: , x_all_dimension_table out NOCOPY BIS_DIMENSION_PUB.Dimension_tbl_type
144: );
145: --
146: PROCEDURE Delete_Dimension
147: (

Line 150: , p_Dimension_Rec IN BIS_DIMENSION_PUB.Dimension_Rec_Type

146: PROCEDURE Delete_Dimension
147: (
148: p_commit IN VARCHAR2 := FND_API.G_FALSE
149: , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
150: , p_Dimension_Rec IN BIS_DIMENSION_PUB.Dimension_Rec_Type
151: , x_return_status OUT NOCOPY VARCHAR2
152: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
153: );
154: --

Line 160: , p_Dimension_Rec IN BIS_DIMENSION_PUB.Dimension_Rec_Type

156: PROCEDURE Translate_Dim_By_Given_Lang
157: (
158: p_commit IN VARCHAR2 := FND_API.G_FALSE
159: , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
160: , p_Dimension_Rec IN BIS_DIMENSION_PUB.Dimension_Rec_Type
161: , x_return_status OUT NOCOPY VARCHAR2
162: , x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type
163: );
164: