45:
46: --===================================================================
47: TYPE ctd_prm_val_rec_type IS RECORD
48: (
49: action_param_value_id NUMBER := FND_API.G_MISS_NUM,
50: action_param_value VARCHAR2(256) := FND_API.G_MISS_CHAR,
51: ctd_id NUMBER := FND_API.G_MISS_NUM,
52: action_param_id NUMBER := FND_API.G_MISS_NUM,
53: object_version_number NUMBER := FND_API.G_MISS_NUM,
46: --===================================================================
47: TYPE ctd_prm_val_rec_type IS RECORD
48: (
49: action_param_value_id NUMBER := FND_API.G_MISS_NUM,
50: action_param_value VARCHAR2(256) := FND_API.G_MISS_CHAR,
51: ctd_id NUMBER := FND_API.G_MISS_NUM,
52: action_param_id NUMBER := FND_API.G_MISS_NUM,
53: object_version_number NUMBER := FND_API.G_MISS_NUM,
54: last_update_date DATE := FND_API.G_MISS_DATE,
47: TYPE ctd_prm_val_rec_type IS RECORD
48: (
49: action_param_value_id NUMBER := FND_API.G_MISS_NUM,
50: action_param_value VARCHAR2(256) := FND_API.G_MISS_CHAR,
51: ctd_id NUMBER := FND_API.G_MISS_NUM,
52: action_param_id NUMBER := FND_API.G_MISS_NUM,
53: object_version_number NUMBER := FND_API.G_MISS_NUM,
54: last_update_date DATE := FND_API.G_MISS_DATE,
55: last_updated_by NUMBER := FND_API.G_MISS_NUM,
48: (
49: action_param_value_id NUMBER := FND_API.G_MISS_NUM,
50: action_param_value VARCHAR2(256) := FND_API.G_MISS_CHAR,
51: ctd_id NUMBER := FND_API.G_MISS_NUM,
52: action_param_id NUMBER := FND_API.G_MISS_NUM,
53: object_version_number NUMBER := FND_API.G_MISS_NUM,
54: last_update_date DATE := FND_API.G_MISS_DATE,
55: last_updated_by NUMBER := FND_API.G_MISS_NUM,
56: last_update_login NUMBER := FND_API.G_MISS_NUM,
49: action_param_value_id NUMBER := FND_API.G_MISS_NUM,
50: action_param_value VARCHAR2(256) := FND_API.G_MISS_CHAR,
51: ctd_id NUMBER := FND_API.G_MISS_NUM,
52: action_param_id NUMBER := FND_API.G_MISS_NUM,
53: object_version_number NUMBER := FND_API.G_MISS_NUM,
54: last_update_date DATE := FND_API.G_MISS_DATE,
55: last_updated_by NUMBER := FND_API.G_MISS_NUM,
56: last_update_login NUMBER := FND_API.G_MISS_NUM,
57: creation_date DATE := FND_API.G_MISS_DATE,
50: action_param_value VARCHAR2(256) := FND_API.G_MISS_CHAR,
51: ctd_id NUMBER := FND_API.G_MISS_NUM,
52: action_param_id NUMBER := FND_API.G_MISS_NUM,
53: object_version_number NUMBER := FND_API.G_MISS_NUM,
54: last_update_date DATE := FND_API.G_MISS_DATE,
55: last_updated_by NUMBER := FND_API.G_MISS_NUM,
56: last_update_login NUMBER := FND_API.G_MISS_NUM,
57: creation_date DATE := FND_API.G_MISS_DATE,
58: created_by NUMBER := FND_API.G_MISS_NUM,
51: ctd_id NUMBER := FND_API.G_MISS_NUM,
52: action_param_id NUMBER := FND_API.G_MISS_NUM,
53: object_version_number NUMBER := FND_API.G_MISS_NUM,
54: last_update_date DATE := FND_API.G_MISS_DATE,
55: last_updated_by NUMBER := FND_API.G_MISS_NUM,
56: last_update_login NUMBER := FND_API.G_MISS_NUM,
57: creation_date DATE := FND_API.G_MISS_DATE,
58: created_by NUMBER := FND_API.G_MISS_NUM,
59: security_group_id NUMBER := FND_API.G_MISS_NUM
52: action_param_id NUMBER := FND_API.G_MISS_NUM,
53: object_version_number NUMBER := FND_API.G_MISS_NUM,
54: last_update_date DATE := FND_API.G_MISS_DATE,
55: last_updated_by NUMBER := FND_API.G_MISS_NUM,
56: last_update_login NUMBER := FND_API.G_MISS_NUM,
57: creation_date DATE := FND_API.G_MISS_DATE,
58: created_by NUMBER := FND_API.G_MISS_NUM,
59: security_group_id NUMBER := FND_API.G_MISS_NUM
60: );
53: object_version_number NUMBER := FND_API.G_MISS_NUM,
54: last_update_date DATE := FND_API.G_MISS_DATE,
55: last_updated_by NUMBER := FND_API.G_MISS_NUM,
56: last_update_login NUMBER := FND_API.G_MISS_NUM,
57: creation_date DATE := FND_API.G_MISS_DATE,
58: created_by NUMBER := FND_API.G_MISS_NUM,
59: security_group_id NUMBER := FND_API.G_MISS_NUM
60: );
61:
54: last_update_date DATE := FND_API.G_MISS_DATE,
55: last_updated_by NUMBER := FND_API.G_MISS_NUM,
56: last_update_login NUMBER := FND_API.G_MISS_NUM,
57: creation_date DATE := FND_API.G_MISS_DATE,
58: created_by NUMBER := FND_API.G_MISS_NUM,
59: security_group_id NUMBER := FND_API.G_MISS_NUM
60: );
61:
62: g_miss_ctd_prm_val_rec ctd_prm_val_rec_type;
55: last_updated_by NUMBER := FND_API.G_MISS_NUM,
56: last_update_login NUMBER := FND_API.G_MISS_NUM,
57: creation_date DATE := FND_API.G_MISS_DATE,
58: created_by NUMBER := FND_API.G_MISS_NUM,
59: security_group_id NUMBER := FND_API.G_MISS_NUM
60: );
61:
62: g_miss_ctd_prm_val_rec ctd_prm_val_rec_type;
63: TYPE ctd_prm_val_tbl_type IS TABLE OF ctd_prm_val_rec_type INDEX BY BINARY_INTEGER;
75: -- Parameters
76: --
77: -- IN
78: -- p_api_version_number IN NUMBER Required
79: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
80: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
81: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
82: -- p_ctd_prm_val_rec IN ctd_prm_val_rec_type Required
83: --
76: --
77: -- IN
78: -- p_api_version_number IN NUMBER Required
79: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
80: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
81: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
82: -- p_ctd_prm_val_rec IN ctd_prm_val_rec_type Required
83: --
84: -- OUT NOCOPY
77: -- IN
78: -- p_api_version_number IN NUMBER Required
79: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
80: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
81: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
82: -- p_ctd_prm_val_rec IN ctd_prm_val_rec_type Required
83: --
84: -- OUT NOCOPY
85: -- x_return_status OUT NOCOPY VARCHAR2
94: --
95:
96: PROCEDURE Create_Ctd_Prm_Val(
97: p_api_version_number IN NUMBER,
98: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
99: p_commit IN VARCHAR2 := FND_API.G_FALSE,
100: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
101:
102: x_return_status OUT NOCOPY VARCHAR2,
95:
96: PROCEDURE Create_Ctd_Prm_Val(
97: p_api_version_number IN NUMBER,
98: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
99: p_commit IN VARCHAR2 := FND_API.G_FALSE,
100: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
101:
102: x_return_status OUT NOCOPY VARCHAR2,
103: x_msg_count OUT NOCOPY NUMBER,
96: PROCEDURE Create_Ctd_Prm_Val(
97: p_api_version_number IN NUMBER,
98: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
99: p_commit IN VARCHAR2 := FND_API.G_FALSE,
100: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
101:
102: x_return_status OUT NOCOPY VARCHAR2,
103: x_msg_count OUT NOCOPY NUMBER,
104: x_msg_data OUT NOCOPY VARCHAR2,
119: -- Parameters
120: --
121: -- IN
122: -- p_api_version_number IN NUMBER Required
123: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
124: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
125: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
126: -- p_ctd_prm_val_rec IN ctd_prm_val_rec_type Required
127: --
120: --
121: -- IN
122: -- p_api_version_number IN NUMBER Required
123: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
124: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
125: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
126: -- p_ctd_prm_val_rec IN ctd_prm_val_rec_type Required
127: --
128: -- OUT NOCOPY
121: -- IN
122: -- p_api_version_number IN NUMBER Required
123: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
124: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
125: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
126: -- p_ctd_prm_val_rec IN ctd_prm_val_rec_type Required
127: --
128: -- OUT NOCOPY
129: -- x_return_status OUT NOCOPY VARCHAR2
138: --
139:
140: PROCEDURE Update_Ctd_Prm_Val(
141: p_api_version_number IN NUMBER,
142: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
143: p_commit IN VARCHAR2 := FND_API.G_FALSE,
144: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
145:
146: x_return_status OUT NOCOPY VARCHAR2,
139:
140: PROCEDURE Update_Ctd_Prm_Val(
141: p_api_version_number IN NUMBER,
142: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
143: p_commit IN VARCHAR2 := FND_API.G_FALSE,
144: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
145:
146: x_return_status OUT NOCOPY VARCHAR2,
147: x_msg_count OUT NOCOPY NUMBER,
140: PROCEDURE Update_Ctd_Prm_Val(
141: p_api_version_number IN NUMBER,
142: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
143: p_commit IN VARCHAR2 := FND_API.G_FALSE,
144: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
145:
146: x_return_status OUT NOCOPY VARCHAR2,
147: x_msg_count OUT NOCOPY NUMBER,
148: x_msg_data OUT NOCOPY VARCHAR2,
163: -- Parameters
164: --
165: -- IN
166: -- p_api_version_number IN NUMBER Required
167: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
168: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
169: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
170: -- p_ACTION_PARAM_VALUE_ID IN NUMBER
171: -- p_object_version_number IN NUMBER Optional Default = NULL
164: --
165: -- IN
166: -- p_api_version_number IN NUMBER Required
167: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
168: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
169: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
170: -- p_ACTION_PARAM_VALUE_ID IN NUMBER
171: -- p_object_version_number IN NUMBER Optional Default = NULL
172: --
165: -- IN
166: -- p_api_version_number IN NUMBER Required
167: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
168: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
169: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
170: -- p_ACTION_PARAM_VALUE_ID IN NUMBER
171: -- p_object_version_number IN NUMBER Optional Default = NULL
172: --
173: -- OUT NOCOPY
183: --
184:
185: PROCEDURE Delete_Ctd_Prm_Val(
186: p_api_version_number IN NUMBER,
187: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
188: p_commit IN VARCHAR2 := FND_API.G_FALSE,
189: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
190: x_return_status OUT NOCOPY VARCHAR2,
191: x_msg_count OUT NOCOPY NUMBER,
184:
185: PROCEDURE Delete_Ctd_Prm_Val(
186: p_api_version_number IN NUMBER,
187: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
188: p_commit IN VARCHAR2 := FND_API.G_FALSE,
189: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
190: x_return_status OUT NOCOPY VARCHAR2,
191: x_msg_count OUT NOCOPY NUMBER,
192: x_msg_data OUT NOCOPY VARCHAR2,
185: PROCEDURE Delete_Ctd_Prm_Val(
186: p_api_version_number IN NUMBER,
187: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
188: p_commit IN VARCHAR2 := FND_API.G_FALSE,
189: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
190: x_return_status OUT NOCOPY VARCHAR2,
191: x_msg_count OUT NOCOPY NUMBER,
192: x_msg_data OUT NOCOPY VARCHAR2,
193: p_action_param_value_id IN NUMBER,
206: -- Parameters
207: --
208: -- IN
209: -- p_api_version_number IN NUMBER Required
210: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
211: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
212: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
213: -- p_ctd_prm_val_rec IN ctd_prm_val_rec_type Required
214: --
207: --
208: -- IN
209: -- p_api_version_number IN NUMBER Required
210: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
211: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
212: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
213: -- p_ctd_prm_val_rec IN ctd_prm_val_rec_type Required
214: --
215: -- OUT NOCOPY
208: -- IN
209: -- p_api_version_number IN NUMBER Required
210: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
211: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
212: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
213: -- p_ctd_prm_val_rec IN ctd_prm_val_rec_type Required
214: --
215: -- OUT NOCOPY
216: -- x_return_status OUT NOCOPY VARCHAR2
225: --
226:
227: PROCEDURE Lock_Ctd_Prm_Val(
228: p_api_version_number IN NUMBER,
229: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
230:
231: x_return_status OUT NOCOPY VARCHAR2,
232: x_msg_count OUT NOCOPY NUMBER,
233: x_msg_data OUT NOCOPY VARCHAR2,
249: -- End of Comments
250:
251: PROCEDURE Validate_ctd_prm_val(
252: p_api_version_number IN NUMBER,
253: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
254: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
255: p_ctd_prm_val_rec IN ctd_prm_val_rec_type,
256: x_return_status OUT NOCOPY VARCHAR2,
257: x_msg_count OUT NOCOPY NUMBER,
250:
251: PROCEDURE Validate_ctd_prm_val(
252: p_api_version_number IN NUMBER,
253: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
254: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
255: p_ctd_prm_val_rec IN ctd_prm_val_rec_type,
256: x_return_status OUT NOCOPY VARCHAR2,
257: x_msg_count OUT NOCOPY NUMBER,
258: x_msg_data OUT NOCOPY VARCHAR2
287: -- End of Comments
288:
289: PROCEDURE Validate_ctd_prm_val_rec(
290: p_api_version_number IN NUMBER,
291: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
292: x_return_status OUT NOCOPY VARCHAR2,
293: x_msg_count OUT NOCOPY NUMBER,
294: x_msg_data OUT NOCOPY VARCHAR2,
295: p_ctd_prm_val_rec IN ctd_prm_val_rec_type