1 package OKE_CHG_REQUESTS_PKG as
2 /* $Header: OKEOCRXS.pls 120.0 2005/05/25 17:54:15 appldev noship $ */
3
4 PROCEDURE Start_WF_Process
5 ( X_LAST_CHG_LOG_ID IN NUMBER
6 );
7
8 procedure INSERT_ROW
9 ( X_ROWID in out NOCOPY VARCHAR2
10 , X_CHG_REQUEST_ID in out NOCOPY NUMBER
11 , X_CREATION_DATE in DATE
12 , X_CREATED_BY in NUMBER
13 , X_LAST_UPDATE_DATE in DATE
14 , X_LAST_UPDATED_BY in NUMBER
15 , X_LAST_UPDATE_LOGIN in NUMBER
16 , X_K_HEADER_ID in NUMBER
17 , X_CHG_REQUEST_NUM in out NOCOPY VARCHAR2
18 , X_CHG_TYPE_CODE in VARCHAR2
19 , X_CHG_STATUS_CODE in VARCHAR2
20 , X_CHG_REASON_CODE in VARCHAR2
21 , X_IMPACT_FUNDING_FLAG in VARCHAR2
22 , X_EFFECTIVE_DATE in DATE
23 , X_REQUESTED_BY_PERSON_ID in NUMBER
24 , X_REQUESTED_DATE in DATE
25 , X_RECEIVE_DATE in DATE
26 , X_APPROVE_DATE in out NOCOPY DATE
27 , X_IMPLEMENT_DATE in out NOCOPY DATE
28 , X_PREV_VERSION in NUMBER
29 , X_NEW_VERSION in NUMBER
30 , X_DESCRIPTION in VARCHAR2
31 , X_CHG_TEXT in VARCHAR2
32 , X_LAST_CHG_LOG_ID in out NOCOPY NUMBER
33 , X_ATTRIBUTE_CATEGORY in VARCHAR2
34 , X_ATTRIBUTE1 in VARCHAR2
35 , X_ATTRIBUTE2 in VARCHAR2
36 , X_ATTRIBUTE3 in VARCHAR2
37 , X_ATTRIBUTE4 in VARCHAR2
38 , X_ATTRIBUTE5 in VARCHAR2
39 , X_ATTRIBUTE6 in VARCHAR2
40 , X_ATTRIBUTE7 in VARCHAR2
41 , X_ATTRIBUTE8 in VARCHAR2
42 , X_ATTRIBUTE9 in VARCHAR2
43 , X_ATTRIBUTE10 in VARCHAR2
44 , X_ATTRIBUTE11 in VARCHAR2
45 , X_ATTRIBUTE12 in VARCHAR2
46 , X_ATTRIBUTE13 in VARCHAR2
47 , X_ATTRIBUTE14 in VARCHAR2
48 , X_ATTRIBUTE15 in VARCHAR2
49 );
50
51 procedure LOCK_ROW
52 ( X_CHG_REQUEST_ID in NUMBER
53 , X_K_HEADER_ID in NUMBER
54 , X_CHG_REQUEST_NUM in VARCHAR2
55 , X_CHG_TYPE_CODE in VARCHAR2
56 , X_CHG_STATUS_CODE in VARCHAR2
57 , X_CHG_REASON_CODE in VARCHAR2
58 , X_IMPACT_FUNDING_FLAG in VARCHAR2
59 , X_EFFECTIVE_DATE in DATE
60 , X_REQUESTED_BY_PERSON_ID in NUMBER
61 , X_REQUESTED_DATE in DATE
62 , X_RECEIVE_DATE in DATE
63 , X_APPROVE_DATE in DATE
64 , X_IMPLEMENT_DATE in DATE
65 , X_PREV_VERSION in NUMBER
66 , X_NEW_VERSION in NUMBER
67 , X_DESCRIPTION in VARCHAR2
68 , X_CHG_TEXT in VARCHAR2
69 , X_ATTRIBUTE_CATEGORY in VARCHAR2
70 , X_ATTRIBUTE1 in VARCHAR2
71 , X_ATTRIBUTE2 in VARCHAR2
72 , X_ATTRIBUTE3 in VARCHAR2
73 , X_ATTRIBUTE4 in VARCHAR2
74 , X_ATTRIBUTE5 in VARCHAR2
75 , X_ATTRIBUTE6 in VARCHAR2
76 , X_ATTRIBUTE7 in VARCHAR2
77 , X_ATTRIBUTE8 in VARCHAR2
78 , X_ATTRIBUTE9 in VARCHAR2
79 , X_ATTRIBUTE10 in VARCHAR2
80 , X_ATTRIBUTE11 in VARCHAR2
81 , X_ATTRIBUTE12 in VARCHAR2
82 , X_ATTRIBUTE13 in VARCHAR2
83 , X_ATTRIBUTE14 in VARCHAR2
84 , X_ATTRIBUTE15 in VARCHAR2
85 );
86
87 procedure UPDATE_ROW
88 ( X_CHG_REQUEST_ID in NUMBER
89 , X_LAST_UPDATE_DATE in DATE
90 , X_LAST_UPDATED_BY in NUMBER
91 , X_LAST_UPDATE_LOGIN in NUMBER
92 , X_K_HEADER_ID in NUMBER
93 , X_CHG_REQUEST_NUM in VARCHAR2
94 , X_CHG_TYPE_CODE in VARCHAR2
95 , X_CHG_STATUS_CODE in VARCHAR2
96 , X_CHG_REASON_CODE in VARCHAR2
97 , X_IMPACT_FUNDING_FLAG in VARCHAR2
98 , X_EFFECTIVE_DATE in DATE
99 , X_REQUESTED_BY_PERSON_ID in NUMBER
100 , X_REQUESTED_DATE in DATE
101 , X_RECEIVE_DATE in DATE
102 , X_APPROVE_DATE in out NOCOPY DATE
103 , X_IMPLEMENT_DATE in out NOCOPY DATE
104 , X_PREV_VERSION in NUMBER
105 , X_NEW_VERSION in NUMBER
106 , X_DESCRIPTION in VARCHAR2
107 , X_CHG_TEXT in VARCHAR2
108 , X_LAST_CHG_LOG_ID in out NOCOPY NUMBER
109 , X_ATTRIBUTE_CATEGORY in VARCHAR2
110 , X_ATTRIBUTE1 in VARCHAR2
111 , X_ATTRIBUTE2 in VARCHAR2
112 , X_ATTRIBUTE3 in VARCHAR2
113 , X_ATTRIBUTE4 in VARCHAR2
114 , X_ATTRIBUTE5 in VARCHAR2
115 , X_ATTRIBUTE6 in VARCHAR2
116 , X_ATTRIBUTE7 in VARCHAR2
117 , X_ATTRIBUTE8 in VARCHAR2
118 , X_ATTRIBUTE9 in VARCHAR2
119 , X_ATTRIBUTE10 in VARCHAR2
120 , X_ATTRIBUTE11 in VARCHAR2
121 , X_ATTRIBUTE12 in VARCHAR2
122 , X_ATTRIBUTE13 in VARCHAR2
123 , X_ATTRIBUTE14 in VARCHAR2
124 , X_ATTRIBUTE15 in VARCHAR2
125 );
126
127 FUNCTION Validate_Chg_Request_Num
128 ( X_K_HEADER_ID in NUMBER,
129 X_CHG_REQ_NUM in VARCHAR2,
130 X_CHG_REQ_ID in NUMBER
131 )RETURN VARCHAR2;
132
133 FUNCTION Chg_Req_Num_Type
134 (X_K_HEADER_ID in NUMBER
135 ) RETURN VARCHAR2;
136
137 FUNCTION Chg_Req_Num_Mode
138 (X_K_HEADER_ID in NUMBER
139 ) RETURN VARCHAR2;
140
141 end OKE_CHG_REQUESTS_PKG;