1 package JTF_UM_APPROVALS_PKG as
2 /* $Header: JTFUMAWS.pls 120.3 2005/11/28 08:49:38 vimohan ship $ */
3 procedure INSERT_ROW (
4 X_APPROVAL_ID out NOCOPY NUMBER,
5 X_EFFECTIVE_END_DATE in DATE,
6 X_APPROVAL_KEY in VARCHAR2,
7 X_ENABLED_FLAG in VARCHAR2,
8 X_WF_ITEM_TYPE in VARCHAR2,
9 X_EFFECTIVE_START_DATE in DATE,
10 X_APPLICATION_ID in NUMBER,
11 X_APPROVAL_NAME in VARCHAR2,
12 X_DESCRIPTION in VARCHAR2,
13 X_CREATION_DATE in DATE,
14 X_CREATED_BY in NUMBER,
15 X_LAST_UPDATE_DATE in DATE,
16 X_LAST_UPDATED_BY in NUMBER,
17 X_LAST_UPDATE_LOGIN in NUMBER,
18 X_USE_PENDING_REQ_FLAG in VARCHAR2
19 );
20
21 procedure INSERT_APPROVERS_ROW (
22 X_APPROVER_ID out NOCOPY NUMBER,
23 X_APPROVAL_ID in NUMBER,
24 X_APPROVAL_SEQ in NUMBER,
25 X_EFFECTIVE_START_DATE in DATE,
26 X_CREATED_BY in NUMBER,
27 X_CREATION_DATE in DATE,
28 X_LAST_UPDATED_BY in NUMBER,
29 X_LAST_UPDATE_DATE in DATE,
30 X_LAST_UPDATE_LOGIN in NUMBER,
31 X_USER_ID in NUMBER,
32 X_ORG_PARTY_ID in NUMBER
33 );
34
35 procedure LOCK_ROW (
36 X_APPROVAL_ID in NUMBER,
37 X_EFFECTIVE_END_DATE in DATE,
38 X_APPROVAL_KEY in VARCHAR2,
39 X_ENABLED_FLAG in VARCHAR2,
40 X_WF_ITEM_TYPE in VARCHAR2,
41 X_EFFECTIVE_START_DATE in DATE,
42 X_APPLICATION_ID in NUMBER,
43 X_APPROVAL_NAME in VARCHAR2,
44 X_DESCRIPTION in VARCHAR2
45 );
46
47 procedure UPDATE_ROW (
48 X_APPROVAL_ID in NUMBER,
49 X_APPROVAL_KEY in VARCHAR2,
50 X_ENABLED_FLAG in VARCHAR2,
51 X_WF_ITEM_TYPE in VARCHAR2,
52 X_APPLICATION_ID in NUMBER,
53 X_APPROVAL_NAME in VARCHAR2,
54 X_DESCRIPTION in VARCHAR2,
55 X_EFFECTIVE_END_DATE in DATE,
56 X_LAST_UPDATE_DATE in DATE,
57 X_LAST_UPDATED_BY in NUMBER,
58 X_LAST_UPDATE_LOGIN in NUMBER,
59 X_USE_PENDING_REQ_FLAG in VARCHAR2
60 );
61
62
63 procedure UPDATE_APPROVERS_ROW (
64 X_APPROVER_ID in NUMBER,
65 X_APPROVAL_ID in NUMBER,
66 X_APPROVAL_SEQ in NUMBER,
67 X_LAST_UPDATED_BY in NUMBER,
68 X_LAST_UPDATE_DATE in DATE,
69 X_LAST_UPDATE_LOGIN in NUMBER,
70 X_USER_ID in NUMBER,
71 X_ORG_PARTY_ID in NUMBER
72 );
73
74 procedure DELETE_ROW (
75 X_APPROVAL_ID in NUMBER
76 );
77
78
79
80
81 procedure LOAD_ROW (
82 X_APPROVAL_ID IN NUMBER,
83 X_EFFECTIVE_START_DATE IN DATE,
84 X_EFFECTIVE_END_DATE IN DATE,
85 X_OWNER IN VARCHAR2,
86 X_APPLICATION_ID IN NUMBER,
87 X_ENABLED_FLAG IN VARCHAR2,
88 X_WF_ITEM_TYPE IN VARCHAR2,
89 X_USE_PENDING_REQ_FLAG IN VARCHAR2,
90 X_APPROVAL_KEY IN VARCHAR2,
91 X_APPROVAL_NAME IN VARCHAR2,
92 X_DESCRIPTION IN VARCHAR2,
93 x_last_update_date in varchar2 default NULL,
94 X_CUSTOM_MODE in varchar2 default NULL
95 );
96
97 procedure DELETE_APPROVERS_ROW (
98 X_APPROVER_ID in NUMBER
99 );
100
101 procedure CREATE_APPROVERS_ROW (
102 X_APPROVER_ID out NOCOPY NUMBER,
103 X_APPROVAL_ID in NUMBER,
104 X_APPROVER_SEQ in NUMBER,
105 X_USER_ID in NUMBER,
106 X_EFFECTIVE_START_DATE in DATE,
107 X_EFFECTIVE_END_DATE in DATE,
108 X_CREATION_DATE in DATE,
109 X_CREATED_BY in NUMBER,
110 X_LAST_UPDATE_DATE in DATE,
111 X_LAST_UPDATED_BY in NUMBER,
112 X_LAST_UPDATE_LOGIN in NUMBER
113 );
114
115 procedure UPDATE_APPROVERS_ROW (
116 X_APPROVER_ID in NUMBER,
117 X_APPROVAL_ID in NUMBER,
118 X_APPROVER_SEQ in NUMBER,
119 X_LAST_UPDATED_BY in NUMBER,
120 X_LAST_UPDATE_DATE in DATE,
121 X_EFFECTIVE_END_DATE in DATE,
122 X_USER_ID in NUMBER
123 );
124
125 procedure LOAD_APPROVERS_ROW(
126 X_APPROVAL_ID IN NUMBER,
127 X_APPROVER_SEQ IN NUMBER,
128 X_USER_ID IN NUMBER,
129 X_EFFECTIVE_START_DATE IN DATE,
130 X_EFFECTIVE_END_DATE IN DATE,
131 X_OWNER IN VARCHAR2,
132 x_last_update_date in varchar2 default NULL,
133 X_CUSTOM_MODE in varchar2 default NULL
134 );
135
136 procedure TRANSLATE_ROW (
137 X_APPROVAL_ID in NUMBER, -- key field
138 X_APPROVAL_NAME in VARCHAR2, -- translated name
139 X_DESCRIPTION in VARCHAR2, -- translated description
140 X_OWNER in VARCHAR2, -- owner field
141 x_last_update_date in varchar2 default NULL,
142 X_CUSTOM_MODE in varchar2 default NULL
143 );
144
145 procedure ADD_LANGUAGE;
146
147 function is_approval_overridden(
148 p_approval_id IN NUMBER,
149 p_org_party_id IN NUMBER
150 )
151 return varchar2;
152 end JTF_UM_APPROVALS_PKG;