DBA Data[Home] [Help]

APPS.PA_WORKPLAN_ATTR_UTILS dependencies on FND_API

Line 8: -- p_lifecycle_id IN NUMBER Optional Default = FND_API.G_MISS_NUM

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

Line 9: -- p_current_lifecycle_phase_id IN NUMBER Optional Default = FND_API.G_MISS_NUM

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

Line 10: -- p_current_lifecycle_phase IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR

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

Line 17: ( p_lifecycle_id IN NUMBER := FND_API.G_MISS_NUM

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

Line 18: ,p_current_lifecycle_phase_id IN NUMBER := FND_API.G_MISS_NUM

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

Line 19: ,p_current_lifecycle_phase IN VARCHAR2 := FND_API.G_MISS_CHAR

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

Line 30: -- p_lifecycle_id IN NUMBER Optional Default = FND_API.G_MISS_NUM

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

Line 31: -- p_lifecycle_name IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR

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

Line 38: ( p_lifecycle_id IN NUMBER := FND_API.G_MISS_NUM

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

Line 39: ,p_lifecycle_name IN VARCHAR2 := FND_API.G_MISS_CHAR

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

Line 50: -- p_approver_source_id IN NUMBER Optional Default = FND_API.G_MISS_NUM

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

Line 51: -- p_approver_source_type IN NUMBER Optional Default = FND_API.G_MISS_NUM

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

Line 52: -- p_approver_name IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR

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

Line 60: ( p_approver_source_id IN NUMBER := FND_API.G_MISS_NUM

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

Line 61: ,p_approver_source_type IN NUMBER := FND_API.G_MISS_NUM

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

Line 62: ,p_approver_name IN VARCHAR2 := FND_API.G_MISS_CHAR

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