12: /* DEFAULT increment for count */
13: COUNT_INCR CONSTANT NUMBER := 1;
14: COUNT_INIT CONSTANT NUMBER := 1;
15:
16: G_TRUE CONSTANT VARCHAR2(1) := FND_API.G_TRUE;
17: G_FALSE CONSTANT VARCHAR2(1) := FND_API.G_FALSE;
18:
19: VALIDATION_ERROR EXCEPTION;
20: INVALID_FLOW EXCEPTION;
13: COUNT_INCR CONSTANT NUMBER := 1;
14: COUNT_INIT CONSTANT NUMBER := 1;
15:
16: G_TRUE CONSTANT VARCHAR2(1) := FND_API.G_TRUE;
17: G_FALSE CONSTANT VARCHAR2(1) := FND_API.G_FALSE;
18:
19: VALIDATION_ERROR EXCEPTION;
20: INVALID_FLOW EXCEPTION;
21: INVALID_SET_NUMBER EXCEPTION;
149:
150: FUNCTION Create_Set_With_Validation
151: (
152: p_api_version in number,
153: p_init_msg_list in varchar2 := FND_API.G_FALSE,
154: p_commit in varchar2 := FND_API.G_FALSE,
155: p_validation_level in number := FND_API.G_VALID_LEVEL_FULL,
156: x_return_status OUT NOCOPY varchar2,
157: x_msg_count OUT NOCOPY number,
150: FUNCTION Create_Set_With_Validation
151: (
152: p_api_version in number,
153: p_init_msg_list in varchar2 := FND_API.G_FALSE,
154: p_commit in varchar2 := FND_API.G_FALSE,
155: p_validation_level in number := FND_API.G_VALID_LEVEL_FULL,
156: x_return_status OUT NOCOPY varchar2,
157: x_msg_count OUT NOCOPY number,
158: x_msg_data OUT NOCOPY varchar2,
151: (
152: p_api_version in number,
153: p_init_msg_list in varchar2 := FND_API.G_FALSE,
154: p_commit in varchar2 := FND_API.G_FALSE,
155: p_validation_level in number := FND_API.G_VALID_LEVEL_FULL,
156: x_return_status OUT NOCOPY varchar2,
157: x_msg_count OUT NOCOPY number,
158: x_msg_data OUT NOCOPY varchar2,
159: p_set_type_name in varchar2,
180:
181: FUNCTION Update_Set_With_Validation
182: (
183: p_api_version in number,
184: p_init_msg_list in varchar2 := FND_API.G_FALSE,
185: p_commit in varchar2 := FND_API.G_FALSE,
186: p_validation_level in number := FND_API.G_VALID_LEVEL_FULL,
187: x_return_status OUT NOCOPY varchar2,
188: x_msg_count OUT NOCOPY number,
181: FUNCTION Update_Set_With_Validation
182: (
183: p_api_version in number,
184: p_init_msg_list in varchar2 := FND_API.G_FALSE,
185: p_commit in varchar2 := FND_API.G_FALSE,
186: p_validation_level in number := FND_API.G_VALID_LEVEL_FULL,
187: x_return_status OUT NOCOPY varchar2,
188: x_msg_count OUT NOCOPY number,
189: x_msg_data OUT NOCOPY varchar2,
182: (
183: p_api_version in number,
184: p_init_msg_list in varchar2 := FND_API.G_FALSE,
185: p_commit in varchar2 := FND_API.G_FALSE,
186: p_validation_level in number := FND_API.G_VALID_LEVEL_FULL,
187: x_return_status OUT NOCOPY varchar2,
188: x_msg_count OUT NOCOPY number,
189: x_msg_data OUT NOCOPY varchar2,
190: p_set_number in varchar2,
395: RETURN VARCHAR2;
396:
397: -- (SRCHEFF)
398: PROCEDURE Update_Solution_Usage_Score(
399: p_commit IN VARCHAR2 := FND_API.G_FALSE);
400:
401: FUNCTION VALIDATE_SOLN_ATTRIBUTES_2
402: (
403: p_set_type_id IN NUMBER,
470:
471: FUNCTION Create_Set_With_Validation_2
472: (
473: p_api_version in number,
474: p_init_msg_list in varchar2 := FND_API.G_FALSE,
475: p_commit in varchar2 := FND_API.G_FALSE,
476: p_validation_level in number := FND_API.G_VALID_LEVEL_FULL,
477: x_return_status OUT NOCOPY varchar2,
478: x_msg_count OUT NOCOPY number,
471: FUNCTION Create_Set_With_Validation_2
472: (
473: p_api_version in number,
474: p_init_msg_list in varchar2 := FND_API.G_FALSE,
475: p_commit in varchar2 := FND_API.G_FALSE,
476: p_validation_level in number := FND_API.G_VALID_LEVEL_FULL,
477: x_return_status OUT NOCOPY varchar2,
478: x_msg_count OUT NOCOPY number,
479: x_msg_data OUT NOCOPY varchar2,
472: (
473: p_api_version in number,
474: p_init_msg_list in varchar2 := FND_API.G_FALSE,
475: p_commit in varchar2 := FND_API.G_FALSE,
476: p_validation_level in number := FND_API.G_VALID_LEVEL_FULL,
477: x_return_status OUT NOCOPY varchar2,
478: x_msg_count OUT NOCOPY number,
479: x_msg_data OUT NOCOPY varchar2,
480: p_set_type_name in varchar2,
503:
504: FUNCTION Create_Set_With_Validation_3
505: (
506: p_api_version in number,
507: p_init_msg_list in varchar2 := FND_API.G_FALSE,
508: p_commit in varchar2 := FND_API.G_FALSE,
509: p_validation_level in number := FND_API.G_VALID_LEVEL_FULL,
510: x_return_status OUT NOCOPY varchar2,
511: x_msg_count OUT NOCOPY number,
504: FUNCTION Create_Set_With_Validation_3
505: (
506: p_api_version in number,
507: p_init_msg_list in varchar2 := FND_API.G_FALSE,
508: p_commit in varchar2 := FND_API.G_FALSE,
509: p_validation_level in number := FND_API.G_VALID_LEVEL_FULL,
510: x_return_status OUT NOCOPY varchar2,
511: x_msg_count OUT NOCOPY number,
512: x_msg_data OUT NOCOPY varchar2,
505: (
506: p_api_version in number,
507: p_init_msg_list in varchar2 := FND_API.G_FALSE,
508: p_commit in varchar2 := FND_API.G_FALSE,
509: p_validation_level in number := FND_API.G_VALID_LEVEL_FULL,
510: x_return_status OUT NOCOPY varchar2,
511: x_msg_count OUT NOCOPY number,
512: x_msg_data OUT NOCOPY varchar2,
513: p_set_type_name in varchar2,
562:
563: FUNCTION Update_Set_With_Validation_2
564: (
565: p_api_version in number,
566: p_init_msg_list in varchar2 := FND_API.G_FALSE,
567: p_commit in varchar2 := FND_API.G_FALSE,
568: p_validation_level in number := FND_API.G_VALID_LEVEL_FULL,
569: x_return_status OUT NOCOPY varchar2,
570: x_msg_count OUT NOCOPY number,
563: FUNCTION Update_Set_With_Validation_2
564: (
565: p_api_version in number,
566: p_init_msg_list in varchar2 := FND_API.G_FALSE,
567: p_commit in varchar2 := FND_API.G_FALSE,
568: p_validation_level in number := FND_API.G_VALID_LEVEL_FULL,
569: x_return_status OUT NOCOPY varchar2,
570: x_msg_count OUT NOCOPY number,
571: x_msg_data OUT NOCOPY varchar2,
564: (
565: p_api_version in number,
566: p_init_msg_list in varchar2 := FND_API.G_FALSE,
567: p_commit in varchar2 := FND_API.G_FALSE,
568: p_validation_level in number := FND_API.G_VALID_LEVEL_FULL,
569: x_return_status OUT NOCOPY varchar2,
570: x_msg_count OUT NOCOPY number,
571: x_msg_data OUT NOCOPY varchar2,
572: p_set_number in varchar2,
594:
595: FUNCTION Update_Set_With_Validation_3
596: (
597: p_api_version in number,
598: p_init_msg_list in varchar2 := FND_API.G_FALSE,
599: p_commit in varchar2 := FND_API.G_FALSE,
600: p_validation_level in number := FND_API.G_VALID_LEVEL_FULL,
601: x_return_status OUT NOCOPY varchar2,
602: x_msg_count OUT NOCOPY number,
595: FUNCTION Update_Set_With_Validation_3
596: (
597: p_api_version in number,
598: p_init_msg_list in varchar2 := FND_API.G_FALSE,
599: p_commit in varchar2 := FND_API.G_FALSE,
600: p_validation_level in number := FND_API.G_VALID_LEVEL_FULL,
601: x_return_status OUT NOCOPY varchar2,
602: x_msg_count OUT NOCOPY number,
603: x_msg_data OUT NOCOPY varchar2,
596: (
597: p_api_version in number,
598: p_init_msg_list in varchar2 := FND_API.G_FALSE,
599: p_commit in varchar2 := FND_API.G_FALSE,
600: p_validation_level in number := FND_API.G_VALID_LEVEL_FULL,
601: x_return_status OUT NOCOPY varchar2,
602: x_msg_count OUT NOCOPY number,
603: x_msg_data OUT NOCOPY varchar2,
604: p_set_number in varchar2,