DBA Data[Home] [Help]

APPS.OKC_PROCESS_PVT dependencies on OKC_API

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

8:
9: ----------------------------------------------------------------------------------
10: -- Global Variables
11: G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKC_PROCESS_PVT';
12: G_APP_NAME CONSTANT VARCHAR2(3) := OKC_API.G_APP_NAME;
13: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKC_UNEXPECTED_ERROR';
14: G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'SQLerrm';
15: G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'SQLcode';
16: G_DELETE_PROC_DEF CONSTANT VARCHAR2(200) := 'OKC_CANNOT_DELETE_PROCESS_DEF';

Line 32: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

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

Line 44: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

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

Line 56: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

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

Line 66: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

62:
63: --Procedures for Process definitions
64: PROCEDURE create_proc_def(
65: p_api_version IN NUMBER,
66: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
67: x_return_status OUT NOCOPY VARCHAR2,
68: x_msg_count OUT NOCOPY NUMBER,
69: x_msg_data OUT NOCOPY VARCHAR2,
70: p_pdfv_tbl IN pdfv_tbl_type,

Line 75: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

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

Line 84: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

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

Line 92: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

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

Line 100: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

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

Line 109: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

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

Line 118: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

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

Line 126: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

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

Line 134: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

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

Line 142: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

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

Line 151: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

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

Line 160: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

156: x_pdpv_tbl OUT NOCOPY pdpv_tbl_type);
157:
158: PROCEDURE create_proc_def_parms(
159: p_api_version IN NUMBER,
160: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
161: x_return_status OUT NOCOPY VARCHAR2,
162: x_msg_count OUT NOCOPY NUMBER,
163: x_msg_data OUT NOCOPY VARCHAR2,
164: p_pdpv_rec IN pdpv_rec_type,

Line 169: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

165: x_pdpv_rec OUT NOCOPY pdpv_rec_type);
166:
167: PROCEDURE lock_proc_def_parms(
168: p_api_version IN NUMBER,
169: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
170: x_return_status OUT NOCOPY VARCHAR2,
171: x_msg_count OUT NOCOPY NUMBER,
172: x_msg_data OUT NOCOPY VARCHAR2,
173: p_pdpv_tbl IN pdpv_tbl_type);

Line 177: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

173: p_pdpv_tbl IN pdpv_tbl_type);
174:
175: PROCEDURE lock_proc_def_parms(
176: p_api_version IN NUMBER,
177: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
178: x_return_status OUT NOCOPY VARCHAR2,
179: x_msg_count OUT NOCOPY NUMBER,
180: x_msg_data OUT NOCOPY VARCHAR2,
181: p_pdpv_rec IN pdpv_rec_type);

Line 185: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

181: p_pdpv_rec IN pdpv_rec_type);
182:
183: PROCEDURE update_proc_def_parms(
184: p_api_version IN NUMBER,
185: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
186: x_return_status OUT NOCOPY VARCHAR2,
187: x_msg_count OUT NOCOPY NUMBER,
188: x_msg_data OUT NOCOPY VARCHAR2,
189: p_pdpv_tbl IN pdpv_tbl_type,

Line 194: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

190: x_pdpv_tbl OUT NOCOPY pdpv_tbl_type);
191:
192: PROCEDURE update_proc_def_parms(
193: p_api_version IN NUMBER,
194: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
195: x_return_status OUT NOCOPY VARCHAR2,
196: x_msg_count OUT NOCOPY NUMBER,
197: x_msg_data OUT NOCOPY VARCHAR2,
198: p_pdpv_rec IN pdpv_rec_type,

Line 203: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

199: x_pdpv_rec OUT NOCOPY pdpv_rec_type);
200:
201: PROCEDURE delete_proc_def_parms(
202: p_api_version IN NUMBER,
203: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
204: x_return_status OUT NOCOPY VARCHAR2,
205: x_msg_count OUT NOCOPY NUMBER,
206: x_msg_data OUT NOCOPY VARCHAR2,
207: p_pdpv_rec IN pdpv_rec_type);

Line 211: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

207: p_pdpv_rec IN pdpv_rec_type);
208:
209: PROCEDURE delete_proc_def_parms(
210: p_api_version IN NUMBER,
211: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
212: x_return_status OUT NOCOPY VARCHAR2,
213: x_msg_count OUT NOCOPY NUMBER,
214: x_msg_data OUT NOCOPY VARCHAR2,
215: p_pdpv_tbl IN pdpv_tbl_type);

Line 219: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

215: p_pdpv_tbl IN pdpv_tbl_type);
216:
217: PROCEDURE validate_proc_def_parms(
218: p_api_version IN NUMBER,
219: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
220: x_return_status OUT NOCOPY VARCHAR2,
221: x_msg_count OUT NOCOPY NUMBER,
222: x_msg_data OUT NOCOPY VARCHAR2,
223: p_pdpv_tbl IN pdpv_tbl_type);

Line 227: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

223: p_pdpv_tbl IN pdpv_tbl_type);
224:
225: PROCEDURE validate_proc_def_parms(
226: p_api_version IN NUMBER,
227: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
228: x_return_status OUT NOCOPY VARCHAR2,
229: x_msg_count OUT NOCOPY NUMBER,
230: x_msg_data OUT NOCOPY VARCHAR2,
231: p_pdpv_rec IN pdpv_rec_type);

Line 235: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

231: p_pdpv_rec IN pdpv_rec_type);
232:
233: PROCEDURE validate_dbnames(
234: p_api_version IN NUMBER,
235: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
236: x_return_status OUT NOCOPY VARCHAR2,
237: x_msg_count OUT NOCOPY NUMBER,
238: x_msg_data OUT NOCOPY VARCHAR2,
239: p_pdfv_rec IN pdfv_rec_type);