[Home] [Help]
PACKAGE: APPS.PA_PROJ_ELEM_VER_STRUCTURE_PKG
Source
1 package PA_PROJ_ELEM_VER_STRUCTURE_PKG as
2 /*$Header: PAXSVATS.pls 120.1 2005/08/19 17:21:18 mwasowic noship $*/
3
4 -- API name : insert_row
5 -- Type : Table Handlers
6 --
7 -- History
8 --
9 -- 25-JUN-01 HSIU -Created
10 --
11 --
12
13
14 procedure insert_row
15 (
16 X_ROWID IN OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
17 , X_PEV_STRUCTURE_ID IN OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
18 , X_ELEMENT_VERSION_ID NUMBER
19 , X_VERSION_NUMBER NUMBER
20 , X_NAME VARCHAR2
21 , X_PROJECT_ID NUMBER
22 , X_PROJ_ELEMENT_ID NUMBER
23 , X_DESCRIPTION VARCHAR2
24 , X_EFFECTIVE_DATE DATE
25 , X_PUBLISHED_DATE DATE
26 , X_PUBLISHED_BY NUMBER
27 , X_CURRENT_BASELINE_DATE DATE
28 , X_CURRENT_BASELINE_FLAG VARCHAR2
29 , X_CURRENT_BASELINE_BY NUMBER
30 , X_ORIGINAL_BASELINE_DATE DATE
31 , X_ORIGINAL_BASELINE_FLAG VARCHAR2
32 , X_ORIGINAL_BASELINE_BY NUMBER
33 , X_LOCK_STATUS_CODE VARCHAR2
34 , X_LOCKED_BY NUMBER
35 , X_LOCKED_DATE DATE
36 , X_STATUS_CODE VARCHAR2
37 , X_WF_STATUS_CODE VARCHAR2
38 , X_LATEST_EFF_PUBLISHED_FLAG VARCHAR2
39 , X_CHANGE_REASON_CODE VARCHAR2
40 , X_RECORD_VERSION_NUMBER NUMBER
41 , X_CURRENT_WORKING_FLAG VARCHAR2 := 'N' --FPM changes bug 3301192
42 , x_source_object_id IN NUMBER:= PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM --Bug No 3594635 SMukka
43 , x_source_object_type IN VARCHAR2:= PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR --Bug No 3594635 SMukka
44 );
45
46
47
48 -- API name : update_row
49 -- Type : Table Handler
50 --
51 -- History
52 --
53 -- 25-JUN-01 HSIU -Created
54 --
55 --
56
57
58 procedure update_row
59 (
60 X_ROWID VARCHAR2
61 , X_PEV_STRUCTURE_ID NUMBER
62 , X_ELEMENT_VERSION_ID NUMBER
63 , X_VERSION_NUMBER NUMBER
64 , X_NAME VARCHAR2
65 , X_PROJECT_ID NUMBER
66 , X_PROJ_ELEMENT_ID NUMBER
67 , X_DESCRIPTION VARCHAR2
68 , X_EFFECTIVE_DATE DATE
69 , X_PUBLISHED_DATE DATE
70 , X_PUBLISHED_BY NUMBER
71 , X_CURRENT_BASELINE_DATE DATE
72 , X_CURRENT_BASELINE_FLAG VARCHAR2
73 , X_CURRENT_BASELINE_BY NUMBER
74 , X_ORIGINAL_BASELINE_DATE DATE
75 , X_ORIGINAL_BASELINE_FLAG VARCHAR2
76 , X_ORIGINAL_BASELINE_BY NUMBER
77 , X_LOCK_STATUS_CODE VARCHAR2
78 , X_LOCKED_BY NUMBER
79 , X_LOCKED_DATE DATE
80 , X_STATUS_CODE VARCHAR2
81 , X_WF_STATUS_CODE VARCHAR2
82 , X_LATEST_EFF_PUBLISHED_FLAG VARCHAR2
83 , X_CHANGE_REASON_CODE VARCHAR2
84 , X_RECORD_VERSION_NUMBER NUMBER
85 , X_CURRENT_WORKING_FLAG VARCHAR2 := 'N' --FPM changes bug 3301192
86 );
87
88
89 -- API name : delete_row
90 -- Type : Table Handler
91 --
92 -- History
93 --
94 -- 25-JUN-01 HSIU -Created
95 --
96 --
97
98
99 procedure delete_row
100 (
101 X_ROWID VARCHAR2
102 );
103
104
105 end PA_PROJ_ELEM_VER_STRUCTURE_PKG;