34: );
35:
36: /*
37: TYPE Actual_Rec_Type IS RECORD
38: ( Target_Level_ID NUMBER := FND_API.G_MISS_NUM
39: ,Target_Level_Name VARCHAR2(100) := FND_API.G_MISS_CHAR
40: ,Target_Level_Short_Name VARCHAR2(80) := FND_API.G_MISS_CHAR
41: ,Dim1_Level_Value_ID VARCHAR2(250) := FND_API.G_MISS_CHAR
42: ,Dim1_Level_Value_Name VARCHAR2(250) := FND_API.G_MISS_CHAR
35:
36: /*
37: TYPE Actual_Rec_Type IS RECORD
38: ( Target_Level_ID NUMBER := FND_API.G_MISS_NUM
39: ,Target_Level_Name VARCHAR2(100) := FND_API.G_MISS_CHAR
40: ,Target_Level_Short_Name VARCHAR2(80) := FND_API.G_MISS_CHAR
41: ,Dim1_Level_Value_ID VARCHAR2(250) := FND_API.G_MISS_CHAR
42: ,Dim1_Level_Value_Name VARCHAR2(250) := FND_API.G_MISS_CHAR
43: ,Dim2_Level_Value_ID VARCHAR2(250) := FND_API.G_MISS_CHAR
36: /*
37: TYPE Actual_Rec_Type IS RECORD
38: ( Target_Level_ID NUMBER := FND_API.G_MISS_NUM
39: ,Target_Level_Name VARCHAR2(100) := FND_API.G_MISS_CHAR
40: ,Target_Level_Short_Name VARCHAR2(80) := FND_API.G_MISS_CHAR
41: ,Dim1_Level_Value_ID VARCHAR2(250) := FND_API.G_MISS_CHAR
42: ,Dim1_Level_Value_Name VARCHAR2(250) := FND_API.G_MISS_CHAR
43: ,Dim2_Level_Value_ID VARCHAR2(250) := FND_API.G_MISS_CHAR
44: ,Dim2_Level_Value_Name VARCHAR2(250) := FND_API.G_MISS_CHAR
37: TYPE Actual_Rec_Type IS RECORD
38: ( Target_Level_ID NUMBER := FND_API.G_MISS_NUM
39: ,Target_Level_Name VARCHAR2(100) := FND_API.G_MISS_CHAR
40: ,Target_Level_Short_Name VARCHAR2(80) := FND_API.G_MISS_CHAR
41: ,Dim1_Level_Value_ID VARCHAR2(250) := FND_API.G_MISS_CHAR
42: ,Dim1_Level_Value_Name VARCHAR2(250) := FND_API.G_MISS_CHAR
43: ,Dim2_Level_Value_ID VARCHAR2(250) := FND_API.G_MISS_CHAR
44: ,Dim2_Level_Value_Name VARCHAR2(250) := FND_API.G_MISS_CHAR
45: ,Dim3_Level_Value_ID VARCHAR2(250) := FND_API.G_MISS_CHAR
38: ( Target_Level_ID NUMBER := FND_API.G_MISS_NUM
39: ,Target_Level_Name VARCHAR2(100) := FND_API.G_MISS_CHAR
40: ,Target_Level_Short_Name VARCHAR2(80) := FND_API.G_MISS_CHAR
41: ,Dim1_Level_Value_ID VARCHAR2(250) := FND_API.G_MISS_CHAR
42: ,Dim1_Level_Value_Name VARCHAR2(250) := FND_API.G_MISS_CHAR
43: ,Dim2_Level_Value_ID VARCHAR2(250) := FND_API.G_MISS_CHAR
44: ,Dim2_Level_Value_Name VARCHAR2(250) := FND_API.G_MISS_CHAR
45: ,Dim3_Level_Value_ID VARCHAR2(250) := FND_API.G_MISS_CHAR
46: ,Dim3_Level_Value_Name VARCHAR2(250) := FND_API.G_MISS_CHAR
39: ,Target_Level_Name VARCHAR2(100) := FND_API.G_MISS_CHAR
40: ,Target_Level_Short_Name VARCHAR2(80) := FND_API.G_MISS_CHAR
41: ,Dim1_Level_Value_ID VARCHAR2(250) := FND_API.G_MISS_CHAR
42: ,Dim1_Level_Value_Name VARCHAR2(250) := FND_API.G_MISS_CHAR
43: ,Dim2_Level_Value_ID VARCHAR2(250) := FND_API.G_MISS_CHAR
44: ,Dim2_Level_Value_Name VARCHAR2(250) := FND_API.G_MISS_CHAR
45: ,Dim3_Level_Value_ID VARCHAR2(250) := FND_API.G_MISS_CHAR
46: ,Dim3_Level_Value_Name VARCHAR2(250) := FND_API.G_MISS_CHAR
47: ,Dim4_Level_Value_ID VARCHAR2(250) := FND_API.G_MISS_CHAR
40: ,Target_Level_Short_Name VARCHAR2(80) := FND_API.G_MISS_CHAR
41: ,Dim1_Level_Value_ID VARCHAR2(250) := FND_API.G_MISS_CHAR
42: ,Dim1_Level_Value_Name VARCHAR2(250) := FND_API.G_MISS_CHAR
43: ,Dim2_Level_Value_ID VARCHAR2(250) := FND_API.G_MISS_CHAR
44: ,Dim2_Level_Value_Name VARCHAR2(250) := FND_API.G_MISS_CHAR
45: ,Dim3_Level_Value_ID VARCHAR2(250) := FND_API.G_MISS_CHAR
46: ,Dim3_Level_Value_Name VARCHAR2(250) := FND_API.G_MISS_CHAR
47: ,Dim4_Level_Value_ID VARCHAR2(250) := FND_API.G_MISS_CHAR
48: ,Dim4_Level_Value_Name VARCHAR2(250) := FND_API.G_MISS_CHAR
41: ,Dim1_Level_Value_ID VARCHAR2(250) := FND_API.G_MISS_CHAR
42: ,Dim1_Level_Value_Name VARCHAR2(250) := FND_API.G_MISS_CHAR
43: ,Dim2_Level_Value_ID VARCHAR2(250) := FND_API.G_MISS_CHAR
44: ,Dim2_Level_Value_Name VARCHAR2(250) := FND_API.G_MISS_CHAR
45: ,Dim3_Level_Value_ID VARCHAR2(250) := FND_API.G_MISS_CHAR
46: ,Dim3_Level_Value_Name VARCHAR2(250) := FND_API.G_MISS_CHAR
47: ,Dim4_Level_Value_ID VARCHAR2(250) := FND_API.G_MISS_CHAR
48: ,Dim4_Level_Value_Name VARCHAR2(250) := FND_API.G_MISS_CHAR
49: ,Dim5_Level_Value_ID VARCHAR2(250) := FND_API.G_MISS_CHAR
42: ,Dim1_Level_Value_Name VARCHAR2(250) := FND_API.G_MISS_CHAR
43: ,Dim2_Level_Value_ID VARCHAR2(250) := FND_API.G_MISS_CHAR
44: ,Dim2_Level_Value_Name VARCHAR2(250) := FND_API.G_MISS_CHAR
45: ,Dim3_Level_Value_ID VARCHAR2(250) := FND_API.G_MISS_CHAR
46: ,Dim3_Level_Value_Name VARCHAR2(250) := FND_API.G_MISS_CHAR
47: ,Dim4_Level_Value_ID VARCHAR2(250) := FND_API.G_MISS_CHAR
48: ,Dim4_Level_Value_Name VARCHAR2(250) := FND_API.G_MISS_CHAR
49: ,Dim5_Level_Value_ID VARCHAR2(250) := FND_API.G_MISS_CHAR
50: ,Dim5_Level_Value_Name VARCHAR2(250) := FND_API.G_MISS_CHAR
43: ,Dim2_Level_Value_ID VARCHAR2(250) := FND_API.G_MISS_CHAR
44: ,Dim2_Level_Value_Name VARCHAR2(250) := FND_API.G_MISS_CHAR
45: ,Dim3_Level_Value_ID VARCHAR2(250) := FND_API.G_MISS_CHAR
46: ,Dim3_Level_Value_Name VARCHAR2(250) := FND_API.G_MISS_CHAR
47: ,Dim4_Level_Value_ID VARCHAR2(250) := FND_API.G_MISS_CHAR
48: ,Dim4_Level_Value_Name VARCHAR2(250) := FND_API.G_MISS_CHAR
49: ,Dim5_Level_Value_ID VARCHAR2(250) := FND_API.G_MISS_CHAR
50: ,Dim5_Level_Value_Name VARCHAR2(250) := FND_API.G_MISS_CHAR
51: ,Dim6_Level_Value_ID VARCHAR2(250) := FND_API.G_MISS_CHAR
44: ,Dim2_Level_Value_Name VARCHAR2(250) := FND_API.G_MISS_CHAR
45: ,Dim3_Level_Value_ID VARCHAR2(250) := FND_API.G_MISS_CHAR
46: ,Dim3_Level_Value_Name VARCHAR2(250) := FND_API.G_MISS_CHAR
47: ,Dim4_Level_Value_ID VARCHAR2(250) := FND_API.G_MISS_CHAR
48: ,Dim4_Level_Value_Name VARCHAR2(250) := FND_API.G_MISS_CHAR
49: ,Dim5_Level_Value_ID VARCHAR2(250) := FND_API.G_MISS_CHAR
50: ,Dim5_Level_Value_Name VARCHAR2(250) := FND_API.G_MISS_CHAR
51: ,Dim6_Level_Value_ID VARCHAR2(250) := FND_API.G_MISS_CHAR
52: ,Dim6_Level_Value_Name VARCHAR2(250) := FND_API.G_MISS_CHAR
45: ,Dim3_Level_Value_ID VARCHAR2(250) := FND_API.G_MISS_CHAR
46: ,Dim3_Level_Value_Name VARCHAR2(250) := FND_API.G_MISS_CHAR
47: ,Dim4_Level_Value_ID VARCHAR2(250) := FND_API.G_MISS_CHAR
48: ,Dim4_Level_Value_Name VARCHAR2(250) := FND_API.G_MISS_CHAR
49: ,Dim5_Level_Value_ID VARCHAR2(250) := FND_API.G_MISS_CHAR
50: ,Dim5_Level_Value_Name VARCHAR2(250) := FND_API.G_MISS_CHAR
51: ,Dim6_Level_Value_ID VARCHAR2(250) := FND_API.G_MISS_CHAR
52: ,Dim6_Level_Value_Name VARCHAR2(250) := FND_API.G_MISS_CHAR
53: ,Dim7_Level_Value_ID VARCHAR2(250) := FND_API.G_MISS_CHAR
46: ,Dim3_Level_Value_Name VARCHAR2(250) := FND_API.G_MISS_CHAR
47: ,Dim4_Level_Value_ID VARCHAR2(250) := FND_API.G_MISS_CHAR
48: ,Dim4_Level_Value_Name VARCHAR2(250) := FND_API.G_MISS_CHAR
49: ,Dim5_Level_Value_ID VARCHAR2(250) := FND_API.G_MISS_CHAR
50: ,Dim5_Level_Value_Name VARCHAR2(250) := FND_API.G_MISS_CHAR
51: ,Dim6_Level_Value_ID VARCHAR2(250) := FND_API.G_MISS_CHAR
52: ,Dim6_Level_Value_Name VARCHAR2(250) := FND_API.G_MISS_CHAR
53: ,Dim7_Level_Value_ID VARCHAR2(250) := FND_API.G_MISS_CHAR
54: ,Dim7_Level_Value_Name VARCHAR2(250) := FND_API.G_MISS_CHAR
47: ,Dim4_Level_Value_ID VARCHAR2(250) := FND_API.G_MISS_CHAR
48: ,Dim4_Level_Value_Name VARCHAR2(250) := FND_API.G_MISS_CHAR
49: ,Dim5_Level_Value_ID VARCHAR2(250) := FND_API.G_MISS_CHAR
50: ,Dim5_Level_Value_Name VARCHAR2(250) := FND_API.G_MISS_CHAR
51: ,Dim6_Level_Value_ID VARCHAR2(250) := FND_API.G_MISS_CHAR
52: ,Dim6_Level_Value_Name VARCHAR2(250) := FND_API.G_MISS_CHAR
53: ,Dim7_Level_Value_ID VARCHAR2(250) := FND_API.G_MISS_CHAR
54: ,Dim7_Level_Value_Name VARCHAR2(250) := FND_API.G_MISS_CHAR
55: ,Responsibility_ID NUMBER := FND_API.G_MISS_NUM
48: ,Dim4_Level_Value_Name VARCHAR2(250) := FND_API.G_MISS_CHAR
49: ,Dim5_Level_Value_ID VARCHAR2(250) := FND_API.G_MISS_CHAR
50: ,Dim5_Level_Value_Name VARCHAR2(250) := FND_API.G_MISS_CHAR
51: ,Dim6_Level_Value_ID VARCHAR2(250) := FND_API.G_MISS_CHAR
52: ,Dim6_Level_Value_Name VARCHAR2(250) := FND_API.G_MISS_CHAR
53: ,Dim7_Level_Value_ID VARCHAR2(250) := FND_API.G_MISS_CHAR
54: ,Dim7_Level_Value_Name VARCHAR2(250) := FND_API.G_MISS_CHAR
55: ,Responsibility_ID NUMBER := FND_API.G_MISS_NUM
56: ,Responsibility_Short_Name VARCHAR2(100) := FND_API.G_MISS_CHAR
49: ,Dim5_Level_Value_ID VARCHAR2(250) := FND_API.G_MISS_CHAR
50: ,Dim5_Level_Value_Name VARCHAR2(250) := FND_API.G_MISS_CHAR
51: ,Dim6_Level_Value_ID VARCHAR2(250) := FND_API.G_MISS_CHAR
52: ,Dim6_Level_Value_Name VARCHAR2(250) := FND_API.G_MISS_CHAR
53: ,Dim7_Level_Value_ID VARCHAR2(250) := FND_API.G_MISS_CHAR
54: ,Dim7_Level_Value_Name VARCHAR2(250) := FND_API.G_MISS_CHAR
55: ,Responsibility_ID NUMBER := FND_API.G_MISS_NUM
56: ,Responsibility_Short_Name VARCHAR2(100) := FND_API.G_MISS_CHAR
57: ,Responsibility_Name VARCHAR2(240) := FND_API.G_MISS_CHAR
50: ,Dim5_Level_Value_Name VARCHAR2(250) := FND_API.G_MISS_CHAR
51: ,Dim6_Level_Value_ID VARCHAR2(250) := FND_API.G_MISS_CHAR
52: ,Dim6_Level_Value_Name VARCHAR2(250) := FND_API.G_MISS_CHAR
53: ,Dim7_Level_Value_ID VARCHAR2(250) := FND_API.G_MISS_CHAR
54: ,Dim7_Level_Value_Name VARCHAR2(250) := FND_API.G_MISS_CHAR
55: ,Responsibility_ID NUMBER := FND_API.G_MISS_NUM
56: ,Responsibility_Short_Name VARCHAR2(100) := FND_API.G_MISS_CHAR
57: ,Responsibility_Name VARCHAR2(240) := FND_API.G_MISS_CHAR
58: ,Actual NUMBER := FND_API.G_MISS_NUM
51: ,Dim6_Level_Value_ID VARCHAR2(250) := FND_API.G_MISS_CHAR
52: ,Dim6_Level_Value_Name VARCHAR2(250) := FND_API.G_MISS_CHAR
53: ,Dim7_Level_Value_ID VARCHAR2(250) := FND_API.G_MISS_CHAR
54: ,Dim7_Level_Value_Name VARCHAR2(250) := FND_API.G_MISS_CHAR
55: ,Responsibility_ID NUMBER := FND_API.G_MISS_NUM
56: ,Responsibility_Short_Name VARCHAR2(100) := FND_API.G_MISS_CHAR
57: ,Responsibility_Name VARCHAR2(240) := FND_API.G_MISS_CHAR
58: ,Actual NUMBER := FND_API.G_MISS_NUM
59: );
52: ,Dim6_Level_Value_Name VARCHAR2(250) := FND_API.G_MISS_CHAR
53: ,Dim7_Level_Value_ID VARCHAR2(250) := FND_API.G_MISS_CHAR
54: ,Dim7_Level_Value_Name VARCHAR2(250) := FND_API.G_MISS_CHAR
55: ,Responsibility_ID NUMBER := FND_API.G_MISS_NUM
56: ,Responsibility_Short_Name VARCHAR2(100) := FND_API.G_MISS_CHAR
57: ,Responsibility_Name VARCHAR2(240) := FND_API.G_MISS_CHAR
58: ,Actual NUMBER := FND_API.G_MISS_NUM
59: );
60: */
53: ,Dim7_Level_Value_ID VARCHAR2(250) := FND_API.G_MISS_CHAR
54: ,Dim7_Level_Value_Name VARCHAR2(250) := FND_API.G_MISS_CHAR
55: ,Responsibility_ID NUMBER := FND_API.G_MISS_NUM
56: ,Responsibility_Short_Name VARCHAR2(100) := FND_API.G_MISS_CHAR
57: ,Responsibility_Name VARCHAR2(240) := FND_API.G_MISS_CHAR
58: ,Actual NUMBER := FND_API.G_MISS_NUM
59: );
60: */
61:
54: ,Dim7_Level_Value_Name VARCHAR2(250) := FND_API.G_MISS_CHAR
55: ,Responsibility_ID NUMBER := FND_API.G_MISS_NUM
56: ,Responsibility_Short_Name VARCHAR2(100) := FND_API.G_MISS_CHAR
57: ,Responsibility_Name VARCHAR2(240) := FND_API.G_MISS_CHAR
58: ,Actual NUMBER := FND_API.G_MISS_NUM
59: );
60: */
61:
62: TYPE Actual_Tbl_Type IS TABLE OF Actual_Rec_Type
80:
81: -- Posts actual value into BIS table.
82: PROCEDURE Post_Actual
83: ( p_api_version IN NUMBER
84: ,p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
85: ,p_commit IN VARCHAR2 Default FND_API.G_FALSE
86: ,p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
87: ,p_Actual_Rec IN BIS_ACTUAL_PUB.Actual_Rec_Type
88: ,x_return_status OUT NOCOPY VARCHAR2
81: -- Posts actual value into BIS table.
82: PROCEDURE Post_Actual
83: ( p_api_version IN NUMBER
84: ,p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
85: ,p_commit IN VARCHAR2 Default FND_API.G_FALSE
86: ,p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
87: ,p_Actual_Rec IN BIS_ACTUAL_PUB.Actual_Rec_Type
88: ,x_return_status OUT NOCOPY VARCHAR2
89: ,x_msg_count OUT NOCOPY NUMBER
82: PROCEDURE Post_Actual
83: ( p_api_version IN NUMBER
84: ,p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
85: ,p_commit IN VARCHAR2 Default FND_API.G_FALSE
86: ,p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
87: ,p_Actual_Rec IN BIS_ACTUAL_PUB.Actual_Rec_Type
88: ,x_return_status OUT NOCOPY VARCHAR2
89: ,x_msg_count OUT NOCOPY NUMBER
90: ,x_msg_data OUT NOCOPY VARCHAR2
96: -- If information about dimension values are not required, set all_info
97: -- to FALSE.
98: PROCEDURE Retrieve_Actual
99: ( p_api_version IN NUMBER
100: ,p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
101: ,p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
102: ,p_all_info IN VARCHAR2 Default FND_API.G_TRUE
103: ,p_Actual_Rec IN BIS_ACTUAL_PUB.Actual_Rec_Type
104: ,x_Actual_Rec OUT NOCOPY BIS_ACTUAL_PUB.Actual_Rec_Type
97: -- to FALSE.
98: PROCEDURE Retrieve_Actual
99: ( p_api_version IN NUMBER
100: ,p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
101: ,p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
102: ,p_all_info IN VARCHAR2 Default FND_API.G_TRUE
103: ,p_Actual_Rec IN BIS_ACTUAL_PUB.Actual_Rec_Type
104: ,x_Actual_Rec OUT NOCOPY BIS_ACTUAL_PUB.Actual_Rec_Type
105: ,x_return_status OUT NOCOPY VARCHAR2
98: PROCEDURE Retrieve_Actual
99: ( p_api_version IN NUMBER
100: ,p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
101: ,p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
102: ,p_all_info IN VARCHAR2 Default FND_API.G_TRUE
103: ,p_Actual_Rec IN BIS_ACTUAL_PUB.Actual_Rec_Type
104: ,x_Actual_Rec OUT NOCOPY BIS_ACTUAL_PUB.Actual_Rec_Type
105: ,x_return_status OUT NOCOPY VARCHAR2
106: ,x_msg_count OUT NOCOPY NUMBER
114: -- If information about dimension values are not required, set all_info
115: -- to FALSE.
116: PROCEDURE Retrieve_Actuals
117: ( p_api_version IN NUMBER
118: ,p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
119: ,p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
120: ,p_all_info IN VARCHAR2 Default FND_API.G_TRUE
121: ,p_Target_Level_Rec IN BIS_TARGET_LEVEL_PUB.Target_Level_Rec_Type
122: ,x_Actual_Tbl OUT NOCOPY BIS_ACTUAL_PUB.Actual_Tbl_Type
115: -- to FALSE.
116: PROCEDURE Retrieve_Actuals
117: ( p_api_version IN NUMBER
118: ,p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
119: ,p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
120: ,p_all_info IN VARCHAR2 Default FND_API.G_TRUE
121: ,p_Target_Level_Rec IN BIS_TARGET_LEVEL_PUB.Target_Level_Rec_Type
122: ,x_Actual_Tbl OUT NOCOPY BIS_ACTUAL_PUB.Actual_Tbl_Type
123: ,x_return_status OUT NOCOPY VARCHAR2
116: PROCEDURE Retrieve_Actuals
117: ( p_api_version IN NUMBER
118: ,p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
119: ,p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
120: ,p_all_info IN VARCHAR2 Default FND_API.G_TRUE
121: ,p_Target_Level_Rec IN BIS_TARGET_LEVEL_PUB.Target_Level_Rec_Type
122: ,x_Actual_Tbl OUT NOCOPY BIS_ACTUAL_PUB.Actual_Tbl_Type
123: ,x_return_status OUT NOCOPY VARCHAR2
124: ,x_msg_count OUT NOCOPY NUMBER
132: -- If information about dimension values are not required, set all_info
133: -- to FALSE.
134: PROCEDURE Retrieve_Latest_Actual
135: ( p_api_version IN NUMBER
136: ,p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
137: ,p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
138: ,p_all_info IN VARCHAR2 Default FND_API.G_TRUE
139: ,p_Actual_Rec IN BIS_ACTUAL_PUB.Actual_Rec_Type
140: ,x_Actual_Rec OUT NOCOPY BIS_ACTUAL_PUB.Actual_Rec_Type
133: -- to FALSE.
134: PROCEDURE Retrieve_Latest_Actual
135: ( p_api_version IN NUMBER
136: ,p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
137: ,p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
138: ,p_all_info IN VARCHAR2 Default FND_API.G_TRUE
139: ,p_Actual_Rec IN BIS_ACTUAL_PUB.Actual_Rec_Type
140: ,x_Actual_Rec OUT NOCOPY BIS_ACTUAL_PUB.Actual_Rec_Type
141: ,x_return_status OUT NOCOPY VARCHAR2
134: PROCEDURE Retrieve_Latest_Actual
135: ( p_api_version IN NUMBER
136: ,p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
137: ,p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
138: ,p_all_info IN VARCHAR2 Default FND_API.G_TRUE
139: ,p_Actual_Rec IN BIS_ACTUAL_PUB.Actual_Rec_Type
140: ,x_Actual_Rec OUT NOCOPY BIS_ACTUAL_PUB.Actual_Rec_Type
141: ,x_return_status OUT NOCOPY VARCHAR2
142: ,x_msg_count OUT NOCOPY NUMBER
150: -- If information about dimension values are not required, set all_info
151: -- to FALSE.
152: PROCEDURE Retrieve_Latest_Actuals
153: ( p_api_version IN NUMBER
154: ,p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
155: ,p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
156: ,p_all_info IN VARCHAR2 Default FND_API.G_TRUE
157: ,p_Target_Level_Rec IN BIS_TARGET_LEVEL_PUB.Target_Level_Rec_Type
158: ,x_Actual_Tbl OUT NOCOPY BIS_ACTUAL_PUB.Actual_Tbl_Type
151: -- to FALSE.
152: PROCEDURE Retrieve_Latest_Actuals
153: ( p_api_version IN NUMBER
154: ,p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
155: ,p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
156: ,p_all_info IN VARCHAR2 Default FND_API.G_TRUE
157: ,p_Target_Level_Rec IN BIS_TARGET_LEVEL_PUB.Target_Level_Rec_Type
158: ,x_Actual_Tbl OUT NOCOPY BIS_ACTUAL_PUB.Actual_Tbl_Type
159: ,x_return_status OUT NOCOPY VARCHAR2
152: PROCEDURE Retrieve_Latest_Actuals
153: ( p_api_version IN NUMBER
154: ,p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
155: ,p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
156: ,p_all_info IN VARCHAR2 Default FND_API.G_TRUE
157: ,p_Target_Level_Rec IN BIS_TARGET_LEVEL_PUB.Target_Level_Rec_Type
158: ,x_Actual_Tbl OUT NOCOPY BIS_ACTUAL_PUB.Actual_Tbl_Type
159: ,x_return_status OUT NOCOPY VARCHAR2
160: ,x_msg_count OUT NOCOPY NUMBER
164:
165:
166: PROCEDURE Validate_Actual
167: ( p_api_version IN NUMBER
168: , p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
169: , p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
170: , p_event IN VARCHAR2
171: , p_user_id IN NUMBER
172: , p_Actual_Rec IN BIS_ACTUAL_PUB.Actual_Rec_Type
165:
166: PROCEDURE Validate_Actual
167: ( p_api_version IN NUMBER
168: , p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
169: , p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
170: , p_event IN VARCHAR2
171: , p_user_id IN NUMBER
172: , p_Actual_Rec IN BIS_ACTUAL_PUB.Actual_Rec_Type
173: , x_return_status OUT NOCOPY VARCHAR2