1 PACKAGE PJM_SEIBAN_PKG AUTHID CURRENT_USER AS
2 /* $Header: PJMSEBNS.pls 115.6 2002/10/29 20:14:07 alaw ship $ */
3
4 -- Procedure Name : project_number_dup
5 --
6 -- Checks for the project_number if it already exists in PJM_PROJECTS_V
7
8 PROCEDURE project_number_dup
9 ( X_project_number IN VARCHAR2
10 , X_dup_number_flag OUT NOCOPY VARCHAR2
11 );
12
13
14 -- Procedure Name : project_name_dup
15 --
16 -- Checks for the project_name if it already exists in PJM_PROJECTS_V
17
18 PROCEDURE project_name_dup
19 ( X_project_name IN VARCHAR2
20 , X_dup_name_flag OUT NOCOPY VARCHAR2
21 );
22
23 FUNCTION check_dup_project_num
24 ( X_project_number IN VARCHAR2
25 , X_project_id IN NUMBER DEFAULT NULL
26 ) RETURN VARCHAR2;
27
28 FUNCTION check_dup_project_name
29 ( X_project_name IN VARCHAR2
30 , X_project_id IN NUMBER DEFAULT NULL
31 ) RETURN VARCHAR2;
32
33 --
34 -- Create_amg_project procedure can be used to create a project in
35 -- Oracle Projects. This uses AMG's API named create_project.
36 --
37 -- This procedure takes the following IN parameters:
38 --
39 -- Project_created_from source (template) project_id
40 -- Project_number target project_number
41 -- Project_name target project_name
42 -- start_date start date for the new project
43 -- end_date end date for the new project
44 -- Submit_Workflow 'Y' or 'N'
45 -- Project_id ID of the target project
46 -- Return_status status of the project creation
47 --
48 PROCEDURE create_amg_project
49 ( X_project_created_from IN NUMBER
50 , X_project_number IN VARCHAR2
51 , X_project_name IN VARCHAR2
52 , X_start_date IN DATE
53 , X_end_date IN DATE
54 , X_submit_workflow IN VARCHAR2
55 , X_project_id OUT NOCOPY NUMBER
56 , X_return_status OUT NOCOPY VARCHAR2
57 );
58
59
60 --
61 -- Procedure Name : create_amg_task
62 --
63 -- Create_amg_task procedure can be used to create a task in
64 -- Oracle projects. This uses AMG's API named add_task.
65 --
66 -- This procedure accepts the following parameters:
67 --
68 -- Project_id project_id of project under which the task
69 -- needs to be created
70 -- Project_number Corresponding project_number for the above
71 -- project
72 -- Task_number Task number for the task to be created
73 -- Task_id ID of the task that has been created
74 -- Return_status status of the Task creation
75 --
76 PROCEDURE create_amg_task
77 ( X_project_id IN NUMBER
78 , X_project_number IN VARCHAR2
79 , X_task_number IN VARCHAR2
80 , X_task_id OUT NOCOPY NUMBER
81 , X_return_status OUT NOCOPY VARCHAR2
82 );
83
84
85 PROCEDURE Conc_Create
86 ( ERRBUF OUT NOCOPY VARCHAR2
87 , RETCODE OUT NOCOPY NUMBER
88 , X_Create_or_Add IN NUMBER DEFAULT 1
89 , X_Project_Template IN NUMBER DEFAULT NULL
90 , X_Project_Number IN VARCHAR2 DEFAULT NULL
91 , X_Project_Name IN VARCHAR2 DEFAULT NULL
92 , X_start_date IN VARCHAR2 DEFAULT NULL
93 , X_end_date IN VARCHAR2 DEFAULT NULL
94 , X_submit_workflow IN VARCHAR2 DEFAULT 'Y'
95 , X_Project_ID IN NUMBER DEFAULT NULL
96 , X_Prefix IN VARCHAR2 DEFAULT NULL
97 , X_Suffix IN VARCHAR2 DEFAULT NULL
98 , X_From_Task IN NUMBER
99 , X_To_Task IN NUMBER
100 , X_Increment_By IN NUMBER DEFAULT 1
101 , X_numeric_width IN NUMBER DEFAULT NULL
102 );
103
104 END PJM_SEIBAN_PKG;