4:
5:
6: PROCEDURE Check_Unique_Sequence
7: ( p_api_version IN NUMBER,
8: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
9: p_commit IN VARCHAR2 := FND_API.G_FALSE,
10: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
11: p_return_status OUT NOCOPY VARCHAR2,
12: p_msg_count OUT NOCOPY NUMBER,
5:
6: PROCEDURE Check_Unique_Sequence
7: ( p_api_version IN NUMBER,
8: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
9: p_commit IN VARCHAR2 := FND_API.G_FALSE,
10: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
11: p_return_status OUT NOCOPY VARCHAR2,
12: p_msg_count OUT NOCOPY NUMBER,
13: p_msg_data OUT NOCOPY VARCHAR2,
6: PROCEDURE Check_Unique_Sequence
7: ( p_api_version IN NUMBER,
8: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
9: p_commit IN VARCHAR2 := FND_API.G_FALSE,
10: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
11: p_return_status OUT NOCOPY VARCHAR2,
12: p_msg_count OUT NOCOPY NUMBER,
13: p_msg_data OUT NOCOPY VARCHAR2,
14: p_year_type_id IN NUMBER,
17: --
18: --
19: PROCEDURE Check_Unique_Name
20: ( p_api_version IN NUMBER,
21: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
22: p_commit IN VARCHAR2 := FND_API.G_FALSE,
23: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
24: p_return_status OUT NOCOPY VARCHAR2,
25: p_msg_count OUT NOCOPY NUMBER,
18: --
19: PROCEDURE Check_Unique_Name
20: ( p_api_version IN NUMBER,
21: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
22: p_commit IN VARCHAR2 := FND_API.G_FALSE,
23: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
24: p_return_status OUT NOCOPY VARCHAR2,
25: p_msg_count OUT NOCOPY NUMBER,
26: p_msg_data OUT NOCOPY VARCHAR2,
19: PROCEDURE Check_Unique_Name
20: ( p_api_version IN NUMBER,
21: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
22: p_commit IN VARCHAR2 := FND_API.G_FALSE,
23: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
24: p_return_status OUT NOCOPY VARCHAR2,
25: p_msg_count OUT NOCOPY NUMBER,
26: p_msg_data OUT NOCOPY VARCHAR2,
27: p_year_type_id IN NUMBER,
30: --
31: --
32: PROCEDURE Check_Sequence
33: ( p_api_version IN NUMBER,
34: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
35: p_commit IN VARCHAR2 := FND_API.G_FALSE,
36: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
37: p_return_status OUT NOCOPY VARCHAR2,
38: p_msg_count OUT NOCOPY NUMBER,
31: --
32: PROCEDURE Check_Sequence
33: ( p_api_version IN NUMBER,
34: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
35: p_commit IN VARCHAR2 := FND_API.G_FALSE,
36: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
37: p_return_status OUT NOCOPY VARCHAR2,
38: p_msg_count OUT NOCOPY NUMBER,
39: p_msg_data OUT NOCOPY VARCHAR2,
32: PROCEDURE Check_Sequence
33: ( p_api_version IN NUMBER,
34: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
35: p_commit IN VARCHAR2 := FND_API.G_FALSE,
36: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
37: p_return_status OUT NOCOPY VARCHAR2,
38: p_msg_count OUT NOCOPY NUMBER,
39: p_msg_data OUT NOCOPY VARCHAR2,
40: p_year_type IN VARCHAR2,
43: --
44: --
45: PROCEDURE Check_CY_Count
46: ( p_api_version IN NUMBER,
47: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
48: p_commit IN VARCHAR2 := FND_API.G_FALSE,
49: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
50: p_return_status OUT NOCOPY VARCHAR2,
51: p_msg_count OUT NOCOPY NUMBER,
44: --
45: PROCEDURE Check_CY_Count
46: ( p_api_version IN NUMBER,
47: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
48: p_commit IN VARCHAR2 := FND_API.G_FALSE,
49: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
50: p_return_status OUT NOCOPY VARCHAR2,
51: p_msg_count OUT NOCOPY NUMBER,
52: p_msg_data OUT NOCOPY VARCHAR2,
45: PROCEDURE Check_CY_Count
46: ( p_api_version IN NUMBER,
47: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
48: p_commit IN VARCHAR2 := FND_API.G_FALSE,
49: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
50: p_return_status OUT NOCOPY VARCHAR2,
51: p_msg_count OUT NOCOPY NUMBER,
52: p_msg_data OUT NOCOPY VARCHAR2,
53: p_year_type_id IN NUMBER
55: --
56: --
57: PROCEDURE Check_Reference
58: ( p_api_version IN NUMBER,
59: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
60: p_commit IN VARCHAR2 := FND_API.G_FALSE,
61: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
62: p_return_status OUT NOCOPY VARCHAR2,
63: p_msg_count OUT NOCOPY NUMBER,
56: --
57: PROCEDURE Check_Reference
58: ( p_api_version IN NUMBER,
59: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
60: p_commit IN VARCHAR2 := FND_API.G_FALSE,
61: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
62: p_return_status OUT NOCOPY VARCHAR2,
63: p_msg_count OUT NOCOPY NUMBER,
64: p_msg_data OUT NOCOPY VARCHAR2,
57: PROCEDURE Check_Reference
58: ( p_api_version IN NUMBER,
59: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
60: p_commit IN VARCHAR2 := FND_API.G_FALSE,
61: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
62: p_return_status OUT NOCOPY VARCHAR2,
63: p_msg_count OUT NOCOPY NUMBER,
64: p_msg_data OUT NOCOPY VARCHAR2,
65: p_year_type_id IN NUMBER
70: --
71: --
72: procedure INSERT_ROW
73: ( p_api_version IN NUMBER,
74: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
75: p_commit IN VARCHAR2 := FND_API.G_FALSE,
76: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
77: p_return_status OUT NOCOPY VARCHAR2,
78: p_msg_count OUT NOCOPY NUMBER,
71: --
72: procedure INSERT_ROW
73: ( p_api_version IN NUMBER,
74: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
75: p_commit IN VARCHAR2 := FND_API.G_FALSE,
76: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
77: p_return_status OUT NOCOPY VARCHAR2,
78: p_msg_count OUT NOCOPY NUMBER,
79: p_msg_data OUT NOCOPY VARCHAR2,
72: procedure INSERT_ROW
73: ( p_api_version IN NUMBER,
74: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
75: p_commit IN VARCHAR2 := FND_API.G_FALSE,
76: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
77: p_return_status OUT NOCOPY VARCHAR2,
78: p_msg_count OUT NOCOPY NUMBER,
79: p_msg_data OUT NOCOPY VARCHAR2,
80: p_ROWID in OUT NOCOPY VARCHAR2,
91:
92:
93: procedure LOCK_ROW
94: ( p_api_version IN NUMBER,
95: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
96: p_commit IN VARCHAR2 := FND_API.G_FALSE,
97: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
98: p_return_status OUT NOCOPY VARCHAR2,
99: p_msg_count OUT NOCOPY NUMBER,
92:
93: procedure LOCK_ROW
94: ( p_api_version IN NUMBER,
95: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
96: p_commit IN VARCHAR2 := FND_API.G_FALSE,
97: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
98: p_return_status OUT NOCOPY VARCHAR2,
99: p_msg_count OUT NOCOPY NUMBER,
100: p_msg_data OUT NOCOPY VARCHAR2,
93: procedure LOCK_ROW
94: ( p_api_version IN NUMBER,
95: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
96: p_commit IN VARCHAR2 := FND_API.G_FALSE,
97: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
98: p_return_status OUT NOCOPY VARCHAR2,
99: p_msg_count OUT NOCOPY NUMBER,
100: p_msg_data OUT NOCOPY VARCHAR2,
101: p_BUDGET_YEAR_TYPE_ID in NUMBER,
107:
108:
109: procedure UPDATE_ROW
110: ( p_api_version IN NUMBER,
111: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
112: p_commit IN VARCHAR2 := FND_API.G_FALSE,
113: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
114: p_return_status OUT NOCOPY VARCHAR2,
115: p_msg_count OUT NOCOPY NUMBER,
108:
109: procedure UPDATE_ROW
110: ( p_api_version IN NUMBER,
111: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
112: p_commit IN VARCHAR2 := FND_API.G_FALSE,
113: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
114: p_return_status OUT NOCOPY VARCHAR2,
115: p_msg_count OUT NOCOPY NUMBER,
116: p_msg_data OUT NOCOPY VARCHAR2,
109: procedure UPDATE_ROW
110: ( p_api_version IN NUMBER,
111: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
112: p_commit IN VARCHAR2 := FND_API.G_FALSE,
113: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
114: p_return_status OUT NOCOPY VARCHAR2,
115: p_msg_count OUT NOCOPY NUMBER,
116: p_msg_data OUT NOCOPY VARCHAR2,
117: p_BUDGET_YEAR_TYPE_ID in NUMBER,
125: );
126:
127: procedure DELETE_ROW
128: ( p_api_version IN NUMBER,
129: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
130: p_commit IN VARCHAR2 := FND_API.G_FALSE,
131: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
132: p_return_status OUT NOCOPY VARCHAR2,
133: p_msg_count OUT NOCOPY NUMBER,
126:
127: procedure DELETE_ROW
128: ( p_api_version IN NUMBER,
129: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
130: p_commit IN VARCHAR2 := FND_API.G_FALSE,
131: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
132: p_return_status OUT NOCOPY VARCHAR2,
133: p_msg_count OUT NOCOPY NUMBER,
134: p_msg_data OUT NOCOPY VARCHAR2,
127: procedure DELETE_ROW
128: ( p_api_version IN NUMBER,
129: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
130: p_commit IN VARCHAR2 := FND_API.G_FALSE,
131: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
132: p_return_status OUT NOCOPY VARCHAR2,
133: p_msg_count OUT NOCOPY NUMBER,
134: p_msg_data OUT NOCOPY VARCHAR2,
135: p_BUDGET_YEAR_TYPE_ID in NUMBER