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;
141:
142: FUNCTION Create_Set_With_Validation
143: (
144: p_api_version in number,
145: p_init_msg_list in varchar2 := FND_API.G_FALSE,
146: p_commit in varchar2 := FND_API.G_FALSE,
147: p_validation_level in number := FND_API.G_VALID_LEVEL_FULL,
148: x_return_status OUT NOCOPY varchar2,
149: x_msg_count OUT NOCOPY number,
142: FUNCTION Create_Set_With_Validation
143: (
144: p_api_version in number,
145: p_init_msg_list in varchar2 := FND_API.G_FALSE,
146: p_commit in varchar2 := FND_API.G_FALSE,
147: p_validation_level in number := FND_API.G_VALID_LEVEL_FULL,
148: x_return_status OUT NOCOPY varchar2,
149: x_msg_count OUT NOCOPY number,
150: x_msg_data OUT NOCOPY varchar2,
143: (
144: p_api_version in number,
145: p_init_msg_list in varchar2 := FND_API.G_FALSE,
146: p_commit in varchar2 := FND_API.G_FALSE,
147: p_validation_level in number := FND_API.G_VALID_LEVEL_FULL,
148: x_return_status OUT NOCOPY varchar2,
149: x_msg_count OUT NOCOPY number,
150: x_msg_data OUT NOCOPY varchar2,
151: p_set_type_name in varchar2,
172:
173: FUNCTION Update_Set_With_Validation
174: (
175: p_api_version in number,
176: p_init_msg_list in varchar2 := FND_API.G_FALSE,
177: p_commit in varchar2 := FND_API.G_FALSE,
178: p_validation_level in number := FND_API.G_VALID_LEVEL_FULL,
179: x_return_status OUT NOCOPY varchar2,
180: x_msg_count OUT NOCOPY number,
173: FUNCTION Update_Set_With_Validation
174: (
175: p_api_version in number,
176: p_init_msg_list in varchar2 := FND_API.G_FALSE,
177: p_commit in varchar2 := FND_API.G_FALSE,
178: p_validation_level in number := FND_API.G_VALID_LEVEL_FULL,
179: x_return_status OUT NOCOPY varchar2,
180: x_msg_count OUT NOCOPY number,
181: x_msg_data OUT NOCOPY varchar2,
174: (
175: p_api_version in number,
176: p_init_msg_list in varchar2 := FND_API.G_FALSE,
177: p_commit in varchar2 := FND_API.G_FALSE,
178: p_validation_level in number := FND_API.G_VALID_LEVEL_FULL,
179: x_return_status OUT NOCOPY varchar2,
180: x_msg_count OUT NOCOPY number,
181: x_msg_data OUT NOCOPY varchar2,
182: p_set_number in varchar2,
387: RETURN VARCHAR2;
388:
389: -- (SRCHEFF)
390: PROCEDURE Update_Solution_Usage_Score(
391: p_commit IN VARCHAR2 := FND_API.G_FALSE);
392:
393: FUNCTION VALIDATE_SOLN_ATTRIBUTES_2
394: (
395: p_set_type_id IN NUMBER,
462:
463: FUNCTION Create_Set_With_Validation_2
464: (
465: p_api_version in number,
466: p_init_msg_list in varchar2 := FND_API.G_FALSE,
467: p_commit in varchar2 := FND_API.G_FALSE,
468: p_validation_level in number := FND_API.G_VALID_LEVEL_FULL,
469: x_return_status OUT NOCOPY varchar2,
470: x_msg_count OUT NOCOPY number,
463: FUNCTION Create_Set_With_Validation_2
464: (
465: p_api_version in number,
466: p_init_msg_list in varchar2 := FND_API.G_FALSE,
467: p_commit in varchar2 := FND_API.G_FALSE,
468: p_validation_level in number := FND_API.G_VALID_LEVEL_FULL,
469: x_return_status OUT NOCOPY varchar2,
470: x_msg_count OUT NOCOPY number,
471: x_msg_data OUT NOCOPY varchar2,
464: (
465: p_api_version in number,
466: p_init_msg_list in varchar2 := FND_API.G_FALSE,
467: p_commit in varchar2 := FND_API.G_FALSE,
468: p_validation_level in number := FND_API.G_VALID_LEVEL_FULL,
469: x_return_status OUT NOCOPY varchar2,
470: x_msg_count OUT NOCOPY number,
471: x_msg_data OUT NOCOPY varchar2,
472: p_set_type_name in varchar2,
495:
496: FUNCTION Create_Set_With_Validation_3
497: (
498: p_api_version in number,
499: p_init_msg_list in varchar2 := FND_API.G_FALSE,
500: p_commit in varchar2 := FND_API.G_FALSE,
501: p_validation_level in number := FND_API.G_VALID_LEVEL_FULL,
502: x_return_status OUT NOCOPY varchar2,
503: x_msg_count OUT NOCOPY number,
496: FUNCTION Create_Set_With_Validation_3
497: (
498: p_api_version in number,
499: p_init_msg_list in varchar2 := FND_API.G_FALSE,
500: p_commit in varchar2 := FND_API.G_FALSE,
501: p_validation_level in number := FND_API.G_VALID_LEVEL_FULL,
502: x_return_status OUT NOCOPY varchar2,
503: x_msg_count OUT NOCOPY number,
504: x_msg_data OUT NOCOPY varchar2,
497: (
498: p_api_version in number,
499: p_init_msg_list in varchar2 := FND_API.G_FALSE,
500: p_commit in varchar2 := FND_API.G_FALSE,
501: p_validation_level in number := FND_API.G_VALID_LEVEL_FULL,
502: x_return_status OUT NOCOPY varchar2,
503: x_msg_count OUT NOCOPY number,
504: x_msg_data OUT NOCOPY varchar2,
505: p_set_type_name in varchar2,
554:
555: FUNCTION Update_Set_With_Validation_2
556: (
557: p_api_version in number,
558: p_init_msg_list in varchar2 := FND_API.G_FALSE,
559: p_commit in varchar2 := FND_API.G_FALSE,
560: p_validation_level in number := FND_API.G_VALID_LEVEL_FULL,
561: x_return_status OUT NOCOPY varchar2,
562: x_msg_count OUT NOCOPY number,
555: FUNCTION Update_Set_With_Validation_2
556: (
557: p_api_version in number,
558: p_init_msg_list in varchar2 := FND_API.G_FALSE,
559: p_commit in varchar2 := FND_API.G_FALSE,
560: p_validation_level in number := FND_API.G_VALID_LEVEL_FULL,
561: x_return_status OUT NOCOPY varchar2,
562: x_msg_count OUT NOCOPY number,
563: x_msg_data OUT NOCOPY varchar2,
556: (
557: p_api_version in number,
558: p_init_msg_list in varchar2 := FND_API.G_FALSE,
559: p_commit in varchar2 := FND_API.G_FALSE,
560: p_validation_level in number := FND_API.G_VALID_LEVEL_FULL,
561: x_return_status OUT NOCOPY varchar2,
562: x_msg_count OUT NOCOPY number,
563: x_msg_data OUT NOCOPY varchar2,
564: p_set_number in varchar2,
586:
587: FUNCTION Update_Set_With_Validation_3
588: (
589: p_api_version in number,
590: p_init_msg_list in varchar2 := FND_API.G_FALSE,
591: p_commit in varchar2 := FND_API.G_FALSE,
592: p_validation_level in number := FND_API.G_VALID_LEVEL_FULL,
593: x_return_status OUT NOCOPY varchar2,
594: x_msg_count OUT NOCOPY number,
587: FUNCTION Update_Set_With_Validation_3
588: (
589: p_api_version in number,
590: p_init_msg_list in varchar2 := FND_API.G_FALSE,
591: p_commit in varchar2 := FND_API.G_FALSE,
592: p_validation_level in number := FND_API.G_VALID_LEVEL_FULL,
593: x_return_status OUT NOCOPY varchar2,
594: x_msg_count OUT NOCOPY number,
595: x_msg_data OUT NOCOPY varchar2,
588: (
589: p_api_version in number,
590: p_init_msg_list in varchar2 := FND_API.G_FALSE,
591: p_commit in varchar2 := FND_API.G_FALSE,
592: p_validation_level in number := FND_API.G_VALID_LEVEL_FULL,
593: x_return_status OUT NOCOPY varchar2,
594: x_msg_count OUT NOCOPY number,
595: x_msg_data OUT NOCOPY varchar2,
596: p_set_number in varchar2,