DBA Data[Home] [Help]

APPS.OKC_PROCESS_PUB dependencies on OKC_API

Line 14: G_APP_NAME CONSTANT VARCHAR2(3) := OKC_API.G_APP_NAME;

10: ---------------------------------------------------------------------------------------
11: -- GLOBAL VARIABLES
12: ---------------------------------------------------------------------------------------
13: G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKC_PROCESS_PUB';
14: G_APP_NAME CONSTANT VARCHAR2(3) := OKC_API.G_APP_NAME;
15: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKC_UNEXPECTED_ERROR';
16: G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'SQLerrm';
17: G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'SQLcode';
18:

Line 34: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

30:
31: --Object type procedure for insert
32: PROCEDURE create_process_def(
33: p_api_version IN NUMBER,
34: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
35: x_return_status OUT NOCOPY VARCHAR2,
36: x_msg_count OUT NOCOPY NUMBER,
37: x_msg_data OUT NOCOPY VARCHAR2,
38: p_pdfv_rec IN pdfv_rec_type,

Line 46: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

42:
43: --Object type procedure for update
44: PROCEDURE update_process_def(
45: p_api_version IN NUMBER,
46: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
47: x_return_status OUT NOCOPY VARCHAR2,
48: x_msg_count OUT NOCOPY NUMBER,
49: x_msg_data OUT NOCOPY VARCHAR2,
50: p_pdfv_rec IN pdfv_rec_type,

Line 58: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

54:
55: --Object type procedure for validate
56: PROCEDURE validate_process_def(
57: p_api_version IN NUMBER,
58: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
59: x_return_status OUT NOCOPY VARCHAR2,
60: x_msg_count OUT NOCOPY NUMBER,
61: x_msg_data OUT NOCOPY VARCHAR2,
62: p_pdfv_rec IN pdfv_rec_type,

Line 69: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

65: --Procedures for Process Definitions
66:
67: PROCEDURE create_proc_def(
68: p_api_version IN NUMBER,
69: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
70: x_return_status OUT NOCOPY VARCHAR2,
71: x_msg_count OUT NOCOPY NUMBER,
72: x_msg_data OUT NOCOPY VARCHAR2,
73: p_pdfv_tbl IN pdfv_tbl_type,

Line 78: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

74: x_pdfv_tbl OUT NOCOPY pdfv_tbl_type);
75:
76: PROCEDURE create_proc_def(
77: p_api_version IN NUMBER,
78: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
79: x_return_status OUT NOCOPY VARCHAR2,
80: x_msg_count OUT NOCOPY NUMBER,
81: x_msg_data OUT NOCOPY VARCHAR2,
82: p_pdfv_rec IN pdfv_rec_type,

Line 87: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

83: x_pdfv_rec OUT NOCOPY pdfv_rec_type);
84:
85: PROCEDURE lock_proc_def(
86: p_api_version IN NUMBER,
87: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
88: x_return_status OUT NOCOPY VARCHAR2,
89: x_msg_count OUT NOCOPY NUMBER,
90: x_msg_data OUT NOCOPY VARCHAR2,
91: p_pdfv_tbl IN pdfv_tbl_type);

Line 95: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

91: p_pdfv_tbl IN pdfv_tbl_type);
92:
93: PROCEDURE lock_proc_def(
94: p_api_version IN NUMBER,
95: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
96: x_return_status OUT NOCOPY VARCHAR2,
97: x_msg_count OUT NOCOPY NUMBER,
98: x_msg_data OUT NOCOPY VARCHAR2,
99: p_pdfv_rec IN pdfv_rec_type);

Line 103: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

99: p_pdfv_rec IN pdfv_rec_type);
100:
101: PROCEDURE update_proc_def(
102: p_api_version IN NUMBER,
103: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
104: x_return_status OUT NOCOPY VARCHAR2,
105: x_msg_count OUT NOCOPY NUMBER,
106: x_msg_data OUT NOCOPY VARCHAR2,
107: p_pdfv_tbl IN pdfv_tbl_type,

Line 112: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

108: x_pdfv_tbl OUT NOCOPY pdfv_tbl_type);
109:
110: PROCEDURE update_proc_def(
111: p_api_version IN NUMBER,
112: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
113: x_return_status OUT NOCOPY VARCHAR2,
114: x_msg_count OUT NOCOPY NUMBER,
115: x_msg_data OUT NOCOPY VARCHAR2,
116: p_pdfv_rec IN pdfv_rec_type,

Line 121: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

117: x_pdfv_rec OUT NOCOPY pdfv_rec_type);
118:
119: PROCEDURE delete_proc_def(
120: p_api_version IN NUMBER,
121: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
122: x_return_status OUT NOCOPY VARCHAR2,
123: x_msg_count OUT NOCOPY NUMBER,
124: x_msg_data OUT NOCOPY VARCHAR2,
125: p_pdfv_tbl IN pdfv_tbl_type);

Line 129: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

125: p_pdfv_tbl IN pdfv_tbl_type);
126:
127: PROCEDURE delete_proc_def(
128: p_api_version IN NUMBER,
129: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
130: x_return_status OUT NOCOPY VARCHAR2,
131: x_msg_count OUT NOCOPY NUMBER,
132: x_msg_data OUT NOCOPY VARCHAR2,
133: p_pdfv_rec IN pdfv_rec_type);

Line 137: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

133: p_pdfv_rec IN pdfv_rec_type);
134:
135: PROCEDURE validate_proc_def(
136: p_api_version IN NUMBER,
137: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
138: x_return_status OUT NOCOPY VARCHAR2,
139: x_msg_count OUT NOCOPY NUMBER,
140: x_msg_data OUT NOCOPY VARCHAR2,
141: p_pdfv_tbl IN pdfv_tbl_type);

Line 145: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

141: p_pdfv_tbl IN pdfv_tbl_type);
142:
143: PROCEDURE validate_proc_def(
144: p_api_version IN NUMBER,
145: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
146: x_return_status OUT NOCOPY VARCHAR2,
147: x_msg_count OUT NOCOPY NUMBER,
148: x_msg_data OUT NOCOPY VARCHAR2,
149: p_pdfv_rec IN pdfv_rec_type);

Line 155: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

151: --Procedures for Process Definition Parameters
152:
153: PROCEDURE create_proc_def_parms(
154: p_api_version IN NUMBER,
155: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
156: x_return_status OUT NOCOPY VARCHAR2,
157: x_msg_count OUT NOCOPY NUMBER,
158: x_msg_data OUT NOCOPY VARCHAR2,
159: p_pdpv_tbl IN pdpv_tbl_type,

Line 164: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

160: x_pdpv_tbl OUT NOCOPY pdpv_tbl_type);
161:
162: PROCEDURE create_proc_def_parms(
163: p_api_version IN NUMBER,
164: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
165: x_return_status OUT NOCOPY VARCHAR2,
166: x_msg_count OUT NOCOPY NUMBER,
167: x_msg_data OUT NOCOPY VARCHAR2,
168: p_pdpv_rec IN pdpv_rec_type,

Line 173: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

169: x_pdpv_rec OUT NOCOPY pdpv_rec_type);
170:
171: PROCEDURE lock_proc_def_parms(
172: p_api_version IN NUMBER,
173: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
174: x_return_status OUT NOCOPY VARCHAR2,
175: x_msg_count OUT NOCOPY NUMBER,
176: x_msg_data OUT NOCOPY VARCHAR2,
177: p_pdpv_tbl IN pdpv_tbl_type);

Line 181: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

177: p_pdpv_tbl IN pdpv_tbl_type);
178:
179: PROCEDURE lock_proc_def_parms(
180: p_api_version IN NUMBER,
181: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
182: x_return_status OUT NOCOPY VARCHAR2,
183: x_msg_count OUT NOCOPY NUMBER,
184: x_msg_data OUT NOCOPY VARCHAR2,
185: p_pdpv_rec IN pdpv_rec_type);

Line 189: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

185: p_pdpv_rec IN pdpv_rec_type);
186:
187: PROCEDURE update_proc_def_parms(
188: p_api_version IN NUMBER,
189: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
190: x_return_status OUT NOCOPY VARCHAR2,
191: x_msg_count OUT NOCOPY NUMBER,
192: x_msg_data OUT NOCOPY VARCHAR2,
193: p_pdpv_tbl IN pdpv_tbl_type,

Line 198: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

194: x_pdpv_tbl OUT NOCOPY pdpv_tbl_type);
195:
196: PROCEDURE update_proc_def_parms(
197: p_api_version IN NUMBER,
198: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
199: x_return_status OUT NOCOPY VARCHAR2,
200: x_msg_count OUT NOCOPY NUMBER,
201: x_msg_data OUT NOCOPY VARCHAR2,
202: p_pdpv_rec IN pdpv_rec_type,

Line 207: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

203: x_pdpv_rec OUT NOCOPY pdpv_rec_type);
204:
205: PROCEDURE delete_proc_def_parms(
206: p_api_version IN NUMBER,
207: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
208: x_return_status OUT NOCOPY VARCHAR2,
209: x_msg_count OUT NOCOPY NUMBER,
210: x_msg_data OUT NOCOPY VARCHAR2,
211: p_pdpv_rec IN pdpv_rec_type);

Line 215: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

211: p_pdpv_rec IN pdpv_rec_type);
212:
213: PROCEDURE delete_proc_def_parms(
214: p_api_version IN NUMBER,
215: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
216: x_return_status OUT NOCOPY VARCHAR2,
217: x_msg_count OUT NOCOPY NUMBER,
218: x_msg_data OUT NOCOPY VARCHAR2,
219: p_pdpv_tbl IN pdpv_tbl_type);

Line 223: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

219: p_pdpv_tbl IN pdpv_tbl_type);
220:
221: PROCEDURE validate_proc_def_parms(
222: p_api_version IN NUMBER,
223: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
224: x_return_status OUT NOCOPY VARCHAR2,
225: x_msg_count OUT NOCOPY NUMBER,
226: x_msg_data OUT NOCOPY VARCHAR2,
227: p_pdpv_tbl IN pdpv_tbl_type);

Line 231: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

227: p_pdpv_tbl IN pdpv_tbl_type);
228:
229: PROCEDURE validate_proc_def_parms(
230: p_api_version IN NUMBER,
231: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
232: x_return_status OUT NOCOPY VARCHAR2,
233: x_msg_count OUT NOCOPY NUMBER,
234: x_msg_data OUT NOCOPY VARCHAR2,
235: p_pdpv_rec IN pdpv_rec_type);

Line 239: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

235: p_pdpv_rec IN pdpv_rec_type);
236:
237: PROCEDURE validate_dbnames(
238: p_api_version IN NUMBER,
239: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
240: x_return_status OUT NOCOPY VARCHAR2,
241: x_msg_count OUT NOCOPY NUMBER,
242: x_msg_data OUT NOCOPY VARCHAR2,
243: p_wf_proc IN VARCHAR2,