[Home] [Help]
PACKAGE: APPS.PA_WORKPLAN_AMG_PUB
Source
1 PACKAGE PA_WORKPLAN_AMG_PUB AUTHID DEFINER AS
2 /* $Header: PAPMWKPS.pls 115.1 2002/12/02 20:29:27 mwasowic noship $*/
3
4 -- ----------------------------------------------------------------------------------------
5 -- Standard Globals
6 -- ----------------------------------------------------------------------------------------
7
8 -- WHO Globals
9
10 G_LAST_UPDATED_BY NUMBER(15) := FND_GLOBAL.USER_ID;
11 G_LAST_UPDATE_DATE DATE := SYSDATE;
12 G_CREATION_DATE DATE := SYSDATE;
13 G_CREATED_BY NUMBER(15) := FND_GLOBAL.USER_ID;
14 G_LAST_UPDATE_LOGIN NUMBER(15) := FND_GLOBAL.LOGIN_ID;
15
16 -- Local Package Globals
17
18 G_PKG_NAME CONSTANT VARCHAR2(30) := ' PA_WORKPLAN_AMG_PUB';
19 G_API_VERSION_NUMBER CONSTANT NUMBER := 1.0;
20
21 ROW_ALREADY_LOCKED EXCEPTION;
22 PRAGMA EXCEPTION_INIT(ROW_ALREADY_LOCKED, -54);
23
24
25 -- -----------------------------------------------------------------------------------------
26 -- Procedures
27 -- -----------------------------------------------------------------------------------------
28
29
30 PROCEDURE change_structure_status
31 (p_api_version_number IN NUMBER
32 , p_init_msg_list IN VARCHAR2 := 'F'
33 , p_commit IN VARCHAR2 := 'F'
34 , p_return_status OUT NOCOPY VARCHAR2
35 , p_msg_count OUT NOCOPY NUMBER
36 , p_msg_data OUT NOCOPY VARCHAR2
37 , p_structure_version_id IN NUMBER
38 , p_pa_project_id IN NUMBER
39 , p_status_code IN VARCHAR2
40 , p_published_struct_ver_id OUT NOCOPY NUMBER
41
42 );
43
44 PROCEDURE baseline_structure
45 (p_api_version_number IN NUMBER
46 , p_init_msg_list IN VARCHAR2 := 'F'
47 , p_commit IN VARCHAR2 := 'F'
48 , p_return_status OUT NOCOPY VARCHAR2
49 , p_msg_count OUT NOCOPY NUMBER
50 , p_msg_data OUT NOCOPY VARCHAR2
51 , p_structure_version_id IN NUMBER
52 , p_pa_project_id IN NUMBER
53
54 );
55
56 END pa_workplan_amg_pub;