[Home] [Help]
PACKAGE: APPS.PA_PROJECT_UTILS2
Source
1 package PA_PROJECT_UTILS2 as
2 -- $Header: PAXPUT2S.pls 120.1 2005/08/19 17:18:40 mwasowic noship $
3
4
5 -- ----------------------------------------------------------
6 -- Validate_Attribute_Change
7 -- X_err_code:
8 -- > 0 for application business errors
9 -- < 0 for SQL errors
10 -- = 0 for success
11 -- If X_err_code > 0, X_err_stage contains the message code
12 -- X_err_code < 0, X_err_stage contains SQLCODE
13 -- ----------------------------------------------------------
14
15 PA_Arch_Pur_Subroutine_Error EXCEPTION ;
16 g_sqlerrm VARCHAR2(2000);
17
18
19 PROCEDURE validate_attribute_change(
20 X_Context IN VARCHAR2
21 , X_insert_update_mode IN VARCHAR2
22 , X_calling_module IN VARCHAR2
23 , X_project_id IN NUMBER
24 , X_task_id IN NUMBER
25 , X_old_value IN VARCHAR2
26 , X_new_value IN VARCHAR2
27 , X_project_type IN VARCHAR2
28 , X_project_start_date IN DATE
29 , X_project_end_date IN DATE
30 , X_public_sector_flag IN VARCHAR2
31 , X_task_manager_person_id IN NUMBER
32 , X_Service_type IN VARCHAR2
33 , X_task_start_date IN DATE
34 , X_task_end_date IN DATE
35 , X_entered_by_user_id IN NUMBER
36 , X_attribute_category IN VARCHAR2
37 , X_attribute1 IN VARCHAR2
38 , X_attribute2 IN VARCHAR2
39 , X_attribute3 IN VARCHAR2
40 , X_attribute4 IN VARCHAR2
41 , X_attribute5 IN VARCHAR2
42 , X_attribute6 IN VARCHAR2
43 , X_attribute7 IN VARCHAR2
44 , X_attribute8 IN VARCHAR2
45 , X_attribute9 IN VARCHAR2
46 , X_attribute10 IN VARCHAR2
47 , X_pm_product_code IN VARCHAR2
48 , X_pm_project_reference IN VARCHAR2
49 , X_pm_task_reference IN VARCHAR2
50 , X_functional_security_flag IN VARCHAR2
51 , x_warnings_only_flag OUT NOCOPY varchar2 --bug3134205 --File.Sql.39 bug 4440895
52 , X_err_code IN OUT NOCOPY number --File.Sql.39 bug 4440895
53 , X_err_stage IN OUT NOCOPY varchar2 --File.Sql.39 bug 4440895
54 , X_err_stack IN OUT NOCOPY varchar2); --File.Sql.39 bug 4440895
55 FUNCTION Get_project_business_group
56 (p_project_id IN pa_projects_all.project_id%TYPE) RETURN NUMBER ;
57 PRAGMA RESTRICT_REFERENCES (Get_project_business_group , WNPS, WNDS );
58
59 PROCEDURE Check_Project_Number_Or_Id
60 ( p_project_id IN pa_projects_all.project_id%TYPE
61 ,p_project_number IN pa_projects_all.segment1%TYPE
62 ,p_check_id_flag IN VARCHAR2 := 'A'
63 ,x_project_id OUT NOCOPY pa_projects_all.project_id%TYPE --File.Sql.39 bug 4440895
64 ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
65 ,x_error_message_code OUT NOCOPY VARCHAR2); --File.Sql.39 bug 4440895
66
67
68 PROCEDURE AbortWorkflow( p_project_id IN NUMBER,
69 p_record_version_number IN NUMBER,
70 x_return_status OUT NOCOPY VARCHAR2,
71 x_msg_count OUT NOCOPY NUMBER,
72 x_msg_data OUT NOCOPY VARCHAR2 );
73
74 end PA_PROJECT_UTILS2 ;