4: -- API name : CHECK_LIFECYCLE_PHASE_NAME_ID
5: -- Type : Utility
6: -- Pre-reqs : None.
7: -- Parameters :
8: -- p_lifecycle_id IN NUMBER Optional Default = FND_API.G_MISS_NUM
9: -- p_current_lifecycle_phase_id IN NUMBER Optional Default = FND_API.G_MISS_NUM
10: -- p_current_lifecycle_phase IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
11: -- p_check_id_flag IN VARCHAR2 Optional Default = 'A'
12: -- x_current_lifecycle_phase_id OUT NUMBER Required
5: -- Type : Utility
6: -- Pre-reqs : None.
7: -- Parameters :
8: -- p_lifecycle_id IN NUMBER Optional Default = FND_API.G_MISS_NUM
9: -- p_current_lifecycle_phase_id IN NUMBER Optional Default = FND_API.G_MISS_NUM
10: -- p_current_lifecycle_phase IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
11: -- p_check_id_flag IN VARCHAR2 Optional Default = 'A'
12: -- x_current_lifecycle_phase_id OUT NUMBER Required
13: -- x_return_status OUT VARCHAR2 Required
6: -- Pre-reqs : None.
7: -- Parameters :
8: -- p_lifecycle_id IN NUMBER Optional Default = FND_API.G_MISS_NUM
9: -- p_current_lifecycle_phase_id IN NUMBER Optional Default = FND_API.G_MISS_NUM
10: -- p_current_lifecycle_phase IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
11: -- p_check_id_flag IN VARCHAR2 Optional Default = 'A'
12: -- x_current_lifecycle_phase_id OUT NUMBER Required
13: -- x_return_status OUT VARCHAR2 Required
14: -- x_error_msg_code OUT VARCHAR2 Required
13: -- x_return_status OUT VARCHAR2 Required
14: -- x_error_msg_code OUT VARCHAR2 Required
15:
16: PROCEDURE CHECK_LIFECYCLE_PHASE_NAME_ID
17: ( p_lifecycle_id IN NUMBER := FND_API.G_MISS_NUM
18: ,p_current_lifecycle_phase_id IN NUMBER := FND_API.G_MISS_NUM
19: ,p_current_lifecycle_phase IN VARCHAR2 := FND_API.G_MISS_CHAR
20: ,p_check_id_flag IN VARCHAR2 := 'A'
21: ,x_current_lifecycle_phase_id OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
14: -- x_error_msg_code OUT VARCHAR2 Required
15:
16: PROCEDURE CHECK_LIFECYCLE_PHASE_NAME_ID
17: ( p_lifecycle_id IN NUMBER := FND_API.G_MISS_NUM
18: ,p_current_lifecycle_phase_id IN NUMBER := FND_API.G_MISS_NUM
19: ,p_current_lifecycle_phase IN VARCHAR2 := FND_API.G_MISS_CHAR
20: ,p_check_id_flag IN VARCHAR2 := 'A'
21: ,x_current_lifecycle_phase_id OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
22: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
15:
16: PROCEDURE CHECK_LIFECYCLE_PHASE_NAME_ID
17: ( p_lifecycle_id IN NUMBER := FND_API.G_MISS_NUM
18: ,p_current_lifecycle_phase_id IN NUMBER := FND_API.G_MISS_NUM
19: ,p_current_lifecycle_phase IN VARCHAR2 := FND_API.G_MISS_CHAR
20: ,p_check_id_flag IN VARCHAR2 := 'A'
21: ,x_current_lifecycle_phase_id OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
22: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
23: ,x_error_msg_code OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
26: -- API name : CHECK_LIFECYCLE_NAME_OR_ID
27: -- Type : Utility
28: -- Pre-reqs : None.
29: -- Parameters :
30: -- p_lifecycle_id IN NUMBER Optional Default = FND_API.G_MISS_NUM
31: -- p_lifecycle_name IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
32: -- p_check_id_flag IN VARCHAR2 Optional Default = 'A'
33: -- x_lifecycle_id OUT NUMBER Required
34: -- x_return_status OUT VARCHAR2 Required
27: -- Type : Utility
28: -- Pre-reqs : None.
29: -- Parameters :
30: -- p_lifecycle_id IN NUMBER Optional Default = FND_API.G_MISS_NUM
31: -- p_lifecycle_name IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
32: -- p_check_id_flag IN VARCHAR2 Optional Default = 'A'
33: -- x_lifecycle_id OUT NUMBER Required
34: -- x_return_status OUT VARCHAR2 Required
35: -- x_error_msg_code OUT VARCHAR2 Required
34: -- x_return_status OUT VARCHAR2 Required
35: -- x_error_msg_code OUT VARCHAR2 Required
36:
37: PROCEDURE CHECK_LIFECYCLE_NAME_OR_ID
38: ( p_lifecycle_id IN NUMBER := FND_API.G_MISS_NUM
39: ,p_lifecycle_name IN VARCHAR2 := FND_API.G_MISS_CHAR
40: ,p_check_id_flag IN VARCHAR2 := 'A'
41: ,x_lifecycle_id OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
42: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
35: -- x_error_msg_code OUT VARCHAR2 Required
36:
37: PROCEDURE CHECK_LIFECYCLE_NAME_OR_ID
38: ( p_lifecycle_id IN NUMBER := FND_API.G_MISS_NUM
39: ,p_lifecycle_name IN VARCHAR2 := FND_API.G_MISS_CHAR
40: ,p_check_id_flag IN VARCHAR2 := 'A'
41: ,x_lifecycle_id OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
42: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
43: ,x_error_msg_code OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
46: -- API name : Check_Approver_Name_Or_Id
47: -- Type : Utility
48: -- Pre-reqs : None.
49: -- Parameters :
50: -- p_approver_source_id IN NUMBER Optional Default = FND_API.G_MISS_NUM
51: -- p_approver_source_type IN NUMBER Optional Default = FND_API.G_MISS_NUM
52: -- p_approver_name IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
53: -- p_check_id_flag IN VARCHAR2 Optional Default = 'A'
54: -- x_approver_source_id OUT NUMBER Required
47: -- Type : Utility
48: -- Pre-reqs : None.
49: -- Parameters :
50: -- p_approver_source_id IN NUMBER Optional Default = FND_API.G_MISS_NUM
51: -- p_approver_source_type IN NUMBER Optional Default = FND_API.G_MISS_NUM
52: -- p_approver_name IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
53: -- p_check_id_flag IN VARCHAR2 Optional Default = 'A'
54: -- x_approver_source_id OUT NUMBER Required
55: -- x_approver_source_type OUT NUMBER Required
48: -- Pre-reqs : None.
49: -- Parameters :
50: -- p_approver_source_id IN NUMBER Optional Default = FND_API.G_MISS_NUM
51: -- p_approver_source_type IN NUMBER Optional Default = FND_API.G_MISS_NUM
52: -- p_approver_name IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
53: -- p_check_id_flag IN VARCHAR2 Optional Default = 'A'
54: -- x_approver_source_id OUT NUMBER Required
55: -- x_approver_source_type OUT NUMBER Required
56: -- x_return_status OUT VARCHAR2 Required
56: -- x_return_status OUT VARCHAR2 Required
57: -- x_error_msg_code OUT VARCHAR2 Required
58:
59: PROCEDURE CHECK_APPROVER_NAME_OR_ID
60: ( p_approver_source_id IN NUMBER := FND_API.G_MISS_NUM
61: ,p_approver_source_type IN NUMBER := FND_API.G_MISS_NUM
62: ,p_approver_name IN VARCHAR2 := FND_API.G_MISS_CHAR
63: ,p_check_id_flag IN VARCHAR2 := 'A'
64: ,x_approver_source_id OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
57: -- x_error_msg_code OUT VARCHAR2 Required
58:
59: PROCEDURE CHECK_APPROVER_NAME_OR_ID
60: ( p_approver_source_id IN NUMBER := FND_API.G_MISS_NUM
61: ,p_approver_source_type IN NUMBER := FND_API.G_MISS_NUM
62: ,p_approver_name IN VARCHAR2 := FND_API.G_MISS_CHAR
63: ,p_check_id_flag IN VARCHAR2 := 'A'
64: ,x_approver_source_id OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
65: ,x_approver_source_type OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
58:
59: PROCEDURE CHECK_APPROVER_NAME_OR_ID
60: ( p_approver_source_id IN NUMBER := FND_API.G_MISS_NUM
61: ,p_approver_source_type IN NUMBER := FND_API.G_MISS_NUM
62: ,p_approver_name IN VARCHAR2 := FND_API.G_MISS_CHAR
63: ,p_check_id_flag IN VARCHAR2 := 'A'
64: ,x_approver_source_id OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
65: ,x_approver_source_type OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
66: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895