DBA Data[Home] [Help]

APPS.PA_PROJECT_PVT dependencies on PA_PROJECT_PUB

Line 25: p_key_members IN pa_project_pub.project_role_tbl_type );

21: PROCEDURE add_key_members
22: ( p_return_status OUT NOCOPY VARCHAR2 , --Bug: 4537865
23: p_pa_source_template_id IN NUMBER ,
24: p_project_id IN NUMBER ,
25: p_key_members IN pa_project_pub.project_role_tbl_type );
26:
27: PROCEDURE add_class_categories
28: ( p_return_status OUT NOCOPY VARCHAR2 , --Bug: 4537865
29: p_pa_source_template_id IN NUMBER ,

Line 31: p_class_categories IN pa_project_pub.class_category_tbl_type );

27: PROCEDURE add_class_categories
28: ( p_return_status OUT NOCOPY VARCHAR2 , --Bug: 4537865
29: p_pa_source_template_id IN NUMBER ,
30: p_project_id IN NUMBER ,
31: p_class_categories IN pa_project_pub.class_category_tbl_type );
32:
33: PROCEDURE add_task_round_one
34: (p_return_status OUT NOCOPY VARCHAR2 --Bug: 4537865
35: ,p_project_rec IN pa_projects%rowtype

Line 36: ,p_task_rec IN pa_project_pub.task_in_rec_type

32:
33: PROCEDURE add_task_round_one
34: (p_return_status OUT NOCOPY VARCHAR2 --Bug: 4537865
35: ,p_project_rec IN pa_projects%rowtype
36: ,p_task_rec IN pa_project_pub.task_in_rec_type
37: ,p_project_type_class_code IN pa_project_types.project_type_class_code%type
38: ,p_service_type_code IN pa_project_types.service_type_code%type
39: ,p_task_id OUT NOCOPY NUMBER ); --Bug: 4537865
40:

Line 45: ,p_task_rec IN pa_project_pub.task_in_rec_type

41: PROCEDURE add_task_round_two
42: (p_return_status OUT NOCOPY VARCHAR2 --Bug: 4537865
43: ,p_project_rec IN pa_projects%rowtype
44: ,p_task_id IN NUMBER
45: ,p_task_rec IN pa_project_pub.task_in_rec_type
46: --Project Structures
47: ,p_ref_task_id IN NUMBER
48: ,p_tasks_in IN pa_project_pub.task_in_tbl_type
49: ,p_tasks_out IN pa_project_pub.task_out_tbl_type

Line 48: ,p_tasks_in IN pa_project_pub.task_in_tbl_type

44: ,p_task_id IN NUMBER
45: ,p_task_rec IN pa_project_pub.task_in_rec_type
46: --Project Structures
47: ,p_ref_task_id IN NUMBER
48: ,p_tasks_in IN pa_project_pub.task_in_tbl_type
49: ,p_tasks_out IN pa_project_pub.task_out_tbl_type
50: ,p_task_version_id OUT NOCOPY NUMBER --Bug: 4537865
51: ,p_create_task_structure IN VARCHAR2 := 'Y' --Bug 2931183
52: --Project Structures

Line 49: ,p_tasks_out IN pa_project_pub.task_out_tbl_type

45: ,p_task_rec IN pa_project_pub.task_in_rec_type
46: --Project Structures
47: ,p_ref_task_id IN NUMBER
48: ,p_tasks_in IN pa_project_pub.task_in_tbl_type
49: ,p_tasks_out IN pa_project_pub.task_out_tbl_type
50: ,p_task_version_id OUT NOCOPY NUMBER --Bug: 4537865
51: ,p_create_task_structure IN VARCHAR2 := 'Y' --Bug 2931183
52: --Project Structures
53: );

Line 115: p_in_task_rec IN pa_project_pub.task_in_rec_type,

111:
112: PROCEDURE Validate_billing_info
113: (p_project_id IN NUMBER, -- Added for Bug: 5643876
114: p_project_class_code IN VARCHAR2,
115: p_in_task_rec IN pa_project_pub.task_in_rec_type,
116: p_return_status OUT NOCOPY VARCHAR2 ) ; --Bug: 4537865
117:
118: PROCEDURE check_start_end_date
119: ( p_return_status OUT NOCOPY VARCHAR2 --Bug: 4537865

Line 130: p_key_members IN pa_project_pub.project_role_tbl_type,

126:
127: Procedure check_for_one_manager
128: (p_project_id IN NUMBER,
129: p_person_id IN NUMBER,
130: p_key_members IN pa_project_pub.project_role_tbl_type,
131: p_start_date IN DATE,
132: p_end_date IN DATE,
133: p_return_status OUT NOCOPY VARCHAR2 ); --Bug: 4537865
134:

Line 140: p_in_task_tbl IN pa_project_pub.task_in_tbl_type,

136: (p_project_id IN NUMBER,
137: p_task_id IN NUMBER,
138: p_array_cell_number IN NUMBER,
139: p_in_task_number IN VARCHAR2,
140: p_in_task_tbl IN pa_project_pub.task_in_tbl_type,
141: p_proceed_with_update_flag OUT NOCOPY VARCHAR2, --Bug: 4537865
142: p_return_status OUT NOCOPY VARCHAR2 ) ; --Bug: 4537865
143:
144: Procedure check_parent_child_task_dates

Line 299: p_org_roles IN pa_project_pub.project_role_tbl_type );

295: PROCEDURE add_org_roles
296: ( p_return_status OUT NOCOPY VARCHAR2 , --Bug: 4537865
297: p_pa_source_template_id IN NUMBER ,
298: p_project_id IN NUMBER ,
299: p_org_roles IN pa_project_pub.project_role_tbl_type );
300:
301: -- anlee org role changes
302: FUNCTION check_valid_organization (p_party_id IN NUMBER )
303: RETURN VARCHAR2;

Line 308: ,p_structure_versions_out OUT NOCOPY PA_PROJECT_PUB.struc_out_tbl_type );

304:
305: --Project Connect 4.0
306: PROCEDURE get_structure_version(
307: p_project_id IN NUMBER
308: ,p_structure_versions_out OUT NOCOPY PA_PROJECT_PUB.struc_out_tbl_type );
309: --Project Connect 4.0
310:
311: /*Added the below two procedures for the bug 2802984*/
312: PROCEDURE Check_Schedule_type