10:
11: PROCEDURE Insert_Row
12: (
13: p_api_version IN NUMBER,
14: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
15: p_commit IN VARCHAR2 := FND_API.G_FALSE,
16: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
17: p_return_status OUT NOCOPY VARCHAR2,
18: p_msg_count OUT NOCOPY NUMBER,
11: PROCEDURE Insert_Row
12: (
13: p_api_version IN NUMBER,
14: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
15: p_commit IN VARCHAR2 := FND_API.G_FALSE,
16: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
17: p_return_status OUT NOCOPY VARCHAR2,
18: p_msg_count OUT NOCOPY NUMBER,
19: p_msg_data OUT NOCOPY VARCHAR2,
12: (
13: p_api_version IN NUMBER,
14: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
15: p_commit IN VARCHAR2 := FND_API.G_FALSE,
16: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
17: p_return_status OUT NOCOPY VARCHAR2,
18: p_msg_count OUT NOCOPY NUMBER,
19: p_msg_data OUT NOCOPY VARCHAR2,
20: --
21: p_row_id IN OUT NOCOPY VARCHAR2,
22: p_account_position_set_id IN OUT NOCOPY NUMBER,
23: p_name IN VARCHAR2,
24: p_set_of_books_id IN NUMBER,
25: p_use_in_budget_group_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
26: p_data_extract_id IN NUMBER,
27: p_budget_group_id IN NUMBER := FND_API.G_MISS_NUM,
28: p_global_or_local_type IN VARCHAR2,
29: p_account_or_position_type IN VARCHAR2,
23: p_name IN VARCHAR2,
24: p_set_of_books_id IN NUMBER,
25: p_use_in_budget_group_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
26: p_data_extract_id IN NUMBER,
27: p_budget_group_id IN NUMBER := FND_API.G_MISS_NUM,
28: p_global_or_local_type IN VARCHAR2,
29: p_account_or_position_type IN VARCHAR2,
30: p_attribute_selection_type IN VARCHAR2,
31: p_business_group_id IN NUMBER,
39:
40: PROCEDURE Lock_Row
41: (
42: p_api_version IN NUMBER,
43: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
44: p_commit IN VARCHAR2 := FND_API.G_FALSE,
45: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
46: p_return_status OUT NOCOPY VARCHAR2,
47: p_msg_count OUT NOCOPY NUMBER,
40: PROCEDURE Lock_Row
41: (
42: p_api_version IN NUMBER,
43: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
44: p_commit IN VARCHAR2 := FND_API.G_FALSE,
45: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
46: p_return_status OUT NOCOPY VARCHAR2,
47: p_msg_count OUT NOCOPY NUMBER,
48: p_msg_data OUT NOCOPY VARCHAR2,
41: (
42: p_api_version IN NUMBER,
43: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
44: p_commit IN VARCHAR2 := FND_API.G_FALSE,
45: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
46: p_return_status OUT NOCOPY VARCHAR2,
47: p_msg_count OUT NOCOPY NUMBER,
48: p_msg_data OUT NOCOPY VARCHAR2,
49: --
50: p_row_id IN VARCHAR2,
51: p_account_position_set_id IN NUMBER,
52: p_name IN VARCHAR2,
53: p_set_of_books_id IN NUMBER,
54: p_use_in_budget_group_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
55: p_data_extract_id IN NUMBER,
56: p_budget_group_id IN NUMBER := FND_API.G_MISS_NUM,
57: p_global_or_local_type IN VARCHAR2,
58: p_account_or_position_type IN VARCHAR2,
52: p_name IN VARCHAR2,
53: p_set_of_books_id IN NUMBER,
54: p_use_in_budget_group_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
55: p_data_extract_id IN NUMBER,
56: p_budget_group_id IN NUMBER := FND_API.G_MISS_NUM,
57: p_global_or_local_type IN VARCHAR2,
58: p_account_or_position_type IN VARCHAR2,
59: p_attribute_selection_type IN VARCHAR2,
60: p_business_group_id IN NUMBER,
65:
66: PROCEDURE Update_Row
67: (
68: p_api_version IN NUMBER,
69: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
70: p_commit IN VARCHAR2 := FND_API.G_FALSE,
71: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
72: p_return_status OUT NOCOPY VARCHAR2,
73: p_msg_count OUT NOCOPY NUMBER,
66: PROCEDURE Update_Row
67: (
68: p_api_version IN NUMBER,
69: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
70: p_commit IN VARCHAR2 := FND_API.G_FALSE,
71: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
72: p_return_status OUT NOCOPY VARCHAR2,
73: p_msg_count OUT NOCOPY NUMBER,
74: p_msg_data OUT NOCOPY VARCHAR2,
67: (
68: p_api_version IN NUMBER,
69: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
70: p_commit IN VARCHAR2 := FND_API.G_FALSE,
71: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
72: p_return_status OUT NOCOPY VARCHAR2,
73: p_msg_count OUT NOCOPY NUMBER,
74: p_msg_data OUT NOCOPY VARCHAR2,
75: --
76: p_row_id IN VARCHAR2,
77: p_account_position_set_id IN NUMBER,
78: p_name IN VARCHAR2,
79: p_set_of_books_id IN NUMBER,
80: p_use_in_budget_group_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
81: p_data_extract_id IN NUMBER,
82: p_budget_group_id IN NUMBER := FND_API.G_MISS_NUM,
83: p_global_or_local_type IN VARCHAR2,
84: p_account_or_position_type IN VARCHAR2,
78: p_name IN VARCHAR2,
79: p_set_of_books_id IN NUMBER,
80: p_use_in_budget_group_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
81: p_data_extract_id IN NUMBER,
82: p_budget_group_id IN NUMBER := FND_API.G_MISS_NUM,
83: p_global_or_local_type IN VARCHAR2,
84: p_account_or_position_type IN VARCHAR2,
85: p_attribute_selection_type IN VARCHAR2,
86: p_business_group_id IN NUMBER,
92:
93: PROCEDURE Delete_Row
94: (
95: p_api_version IN NUMBER,
96: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
97: p_commit IN VARCHAR2 := FND_API.G_FALSE,
98: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
99: p_return_status OUT NOCOPY VARCHAR2,
100: p_msg_count OUT NOCOPY NUMBER,
93: PROCEDURE Delete_Row
94: (
95: p_api_version IN NUMBER,
96: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
97: p_commit IN VARCHAR2 := FND_API.G_FALSE,
98: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
99: p_return_status OUT NOCOPY VARCHAR2,
100: p_msg_count OUT NOCOPY NUMBER,
101: p_msg_data OUT NOCOPY VARCHAR2,
94: (
95: p_api_version IN NUMBER,
96: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
97: p_commit IN VARCHAR2 := FND_API.G_FALSE,
98: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
99: p_return_status OUT NOCOPY VARCHAR2,
100: p_msg_count OUT NOCOPY NUMBER,
101: p_msg_data OUT NOCOPY VARCHAR2,
102: --
106:
107: PROCEDURE Check_Unique
108: (
109: p_api_version IN NUMBER,
110: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
111: p_commit IN VARCHAR2 := FND_API.G_FALSE,
112: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
113: p_return_status OUT NOCOPY VARCHAR2,
114: p_msg_count OUT NOCOPY NUMBER,
107: PROCEDURE Check_Unique
108: (
109: p_api_version IN NUMBER,
110: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
111: p_commit IN VARCHAR2 := FND_API.G_FALSE,
112: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
113: p_return_status OUT NOCOPY VARCHAR2,
114: p_msg_count OUT NOCOPY NUMBER,
115: p_msg_data OUT NOCOPY VARCHAR2,
108: (
109: p_api_version IN NUMBER,
110: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
111: p_commit IN VARCHAR2 := FND_API.G_FALSE,
112: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
113: p_return_status OUT NOCOPY VARCHAR2,
114: p_msg_count OUT NOCOPY NUMBER,
115: p_msg_data OUT NOCOPY VARCHAR2,
116: --
123:
124: PROCEDURE Check_References
125: (
126: p_api_version IN NUMBER,
127: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
128: p_commit IN VARCHAR2 := FND_API.G_FALSE,
129: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
130: p_return_status OUT NOCOPY VARCHAR2,
131: p_msg_count OUT NOCOPY NUMBER,
124: PROCEDURE Check_References
125: (
126: p_api_version IN NUMBER,
127: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
128: p_commit IN VARCHAR2 := FND_API.G_FALSE,
129: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
130: p_return_status OUT NOCOPY VARCHAR2,
131: p_msg_count OUT NOCOPY NUMBER,
132: p_msg_data OUT NOCOPY VARCHAR2,
125: (
126: p_api_version IN NUMBER,
127: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
128: p_commit IN VARCHAR2 := FND_API.G_FALSE,
129: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
130: p_return_status OUT NOCOPY VARCHAR2,
131: p_msg_count OUT NOCOPY NUMBER,
132: p_msg_data OUT NOCOPY VARCHAR2,
133: --
140:
141: PROCEDURE Copy_Position_Sets
142: (
143: p_api_version IN NUMBER,
144: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
145: p_commit IN VARCHAR2 := FND_API.G_FALSE,
146: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
147: p_return_status OUT NOCOPY VARCHAR2,
148: p_msg_count OUT NOCOPY NUMBER,
141: PROCEDURE Copy_Position_Sets
142: (
143: p_api_version IN NUMBER,
144: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
145: p_commit IN VARCHAR2 := FND_API.G_FALSE,
146: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
147: p_return_status OUT NOCOPY VARCHAR2,
148: p_msg_count OUT NOCOPY NUMBER,
149: p_msg_data OUT NOCOPY VARCHAR2,
142: (
143: p_api_version IN NUMBER,
144: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
145: p_commit IN VARCHAR2 := FND_API.G_FALSE,
146: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
147: p_return_status OUT NOCOPY VARCHAR2,
148: p_msg_count OUT NOCOPY NUMBER,
149: p_msg_data OUT NOCOPY VARCHAR2,
150: --
156:
157: PROCEDURE Copy_Position_Set
158: (
159: p_api_version IN NUMBER,
160: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
161: p_commit IN VARCHAR2 := FND_API.G_FALSE,
162: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
163: p_return_status OUT NOCOPY VARCHAR2,
164: p_msg_count OUT NOCOPY NUMBER,
157: PROCEDURE Copy_Position_Set
158: (
159: p_api_version IN NUMBER,
160: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
161: p_commit IN VARCHAR2 := FND_API.G_FALSE,
162: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
163: p_return_status OUT NOCOPY VARCHAR2,
164: p_msg_count OUT NOCOPY NUMBER,
165: p_msg_data OUT NOCOPY VARCHAR2,
158: (
159: p_api_version IN NUMBER,
160: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
161: p_commit IN VARCHAR2 := FND_API.G_FALSE,
162: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
163: p_return_status OUT NOCOPY VARCHAR2,
164: p_msg_count OUT NOCOPY NUMBER,
165: p_msg_data OUT NOCOPY VARCHAR2,
166: --