[Home] [Help]
8: , p7_a0 JTF_NUMBER_TABLE
9: , p7_a1 JTF_NUMBER_TABLE
10: , p7_a2 JTF_VARCHAR2_TABLE_200
11: , p7_a3 JTF_VARCHAR2_TABLE_2000
12: , p7_a4 JTF_VARCHAR2_TABLE_100
13: , p7_a5 JTF_VARCHAR2_TABLE_100
14: , p7_a6 JTF_VARCHAR2_TABLE_500
15: , p7_a7 JTF_VARCHAR2_TABLE_500
16: , p7_a8 JTF_NUMBER_TABLE
9: , p7_a1 JTF_NUMBER_TABLE
10: , p7_a2 JTF_VARCHAR2_TABLE_200
11: , p7_a3 JTF_VARCHAR2_TABLE_2000
12: , p7_a4 JTF_VARCHAR2_TABLE_100
13: , p7_a5 JTF_VARCHAR2_TABLE_100
14: , p7_a6 JTF_VARCHAR2_TABLE_500
15: , p7_a7 JTF_VARCHAR2_TABLE_500
16: , p7_a8 JTF_NUMBER_TABLE
17: , p7_a9 JTF_NUMBER_TABLE
22: , p7_a14 JTF_NUMBER_TABLE
23: , p8_a0 JTF_NUMBER_TABLE
24: , p8_a1 JTF_NUMBER_TABLE
25: , p8_a2 JTF_NUMBER_TABLE
26: , p8_a3 JTF_VARCHAR2_TABLE_100
27: , p8_a4 JTF_NUMBER_TABLE
28: , p8_a5 JTF_NUMBER_TABLE
29: , p8_a6 JTF_VARCHAR2_TABLE_200
30: , p8_a7 JTF_NUMBER_TABLE
119: , p7_a0 JTF_NUMBER_TABLE
120: , p7_a1 JTF_NUMBER_TABLE
121: , p7_a2 JTF_VARCHAR2_TABLE_200
122: , p7_a3 JTF_VARCHAR2_TABLE_2000
123: , p7_a4 JTF_VARCHAR2_TABLE_100
124: , p7_a5 JTF_VARCHAR2_TABLE_100
125: , p7_a6 JTF_VARCHAR2_TABLE_500
126: , p7_a7 JTF_VARCHAR2_TABLE_500
127: , p7_a8 JTF_NUMBER_TABLE
120: , p7_a1 JTF_NUMBER_TABLE
121: , p7_a2 JTF_VARCHAR2_TABLE_200
122: , p7_a3 JTF_VARCHAR2_TABLE_2000
123: , p7_a4 JTF_VARCHAR2_TABLE_100
124: , p7_a5 JTF_VARCHAR2_TABLE_100
125: , p7_a6 JTF_VARCHAR2_TABLE_500
126: , p7_a7 JTF_VARCHAR2_TABLE_500
127: , p7_a8 JTF_NUMBER_TABLE
128: , p7_a9 JTF_NUMBER_TABLE
133: , p7_a14 JTF_NUMBER_TABLE
134: , p8_a0 JTF_NUMBER_TABLE
135: , p8_a1 JTF_NUMBER_TABLE
136: , p8_a2 JTF_NUMBER_TABLE
137: , p8_a3 JTF_VARCHAR2_TABLE_100
138: , p8_a4 JTF_NUMBER_TABLE
139: , p8_a5 JTF_NUMBER_TABLE
140: , p8_a6 JTF_VARCHAR2_TABLE_200
141: , p8_a7 JTF_NUMBER_TABLE
230: , p5_a0 JTF_NUMBER_TABLE
231: , p5_a1 JTF_NUMBER_TABLE
232: , p5_a2 JTF_VARCHAR2_TABLE_200
233: , p5_a3 JTF_VARCHAR2_TABLE_2000
234: , p5_a4 JTF_VARCHAR2_TABLE_100
235: , p5_a5 JTF_VARCHAR2_TABLE_100
236: , p5_a6 JTF_VARCHAR2_TABLE_500
237: , p5_a7 JTF_VARCHAR2_TABLE_500
238: , p5_a8 JTF_NUMBER_TABLE
231: , p5_a1 JTF_NUMBER_TABLE
232: , p5_a2 JTF_VARCHAR2_TABLE_200
233: , p5_a3 JTF_VARCHAR2_TABLE_2000
234: , p5_a4 JTF_VARCHAR2_TABLE_100
235: , p5_a5 JTF_VARCHAR2_TABLE_100
236: , p5_a6 JTF_VARCHAR2_TABLE_500
237: , p5_a7 JTF_VARCHAR2_TABLE_500
238: , p5_a8 JTF_NUMBER_TABLE
239: , p5_a9 JTF_NUMBER_TABLE
250: , x_msg_data out nocopy VARCHAR2
251: , p5_a0 JTF_NUMBER_TABLE
252: , p5_a1 JTF_NUMBER_TABLE
253: , p5_a2 JTF_NUMBER_TABLE
254: , p5_a3 JTF_VARCHAR2_TABLE_100
255: , p5_a4 JTF_NUMBER_TABLE
256: , p5_a5 JTF_NUMBER_TABLE
257: , p5_a6 JTF_VARCHAR2_TABLE_200
258: , p5_a7 JTF_NUMBER_TABLE
269: , x_msg_data out nocopy VARCHAR2
270: , p5_a0 JTF_NUMBER_TABLE
271: , p5_a1 JTF_NUMBER_TABLE
272: , p5_a2 JTF_NUMBER_TABLE
273: , p5_a3 JTF_VARCHAR2_TABLE_100
274: , p5_a4 JTF_NUMBER_TABLE
275: , p5_a5 JTF_NUMBER_TABLE
276: , p5_a6 JTF_VARCHAR2_TABLE_200
277: , p5_a7 JTF_NUMBER_TABLE
290: , p_pri_sty_id NUMBER
291: , p7_a0 JTF_NUMBER_TABLE
292: , p7_a1 JTF_NUMBER_TABLE
293: , p7_a2 JTF_NUMBER_TABLE
294: , p7_a3 JTF_VARCHAR2_TABLE_100
295: , p7_a4 JTF_NUMBER_TABLE
296: , p7_a5 JTF_NUMBER_TABLE
297: , p7_a6 JTF_VARCHAR2_TABLE_200
298: , p7_a7 JTF_NUMBER_TABLE
347: , x_msg_count out nocopy NUMBER
348: , x_msg_data out nocopy VARCHAR2
349: , p_gtt_id NUMBER
350: , p6_a0 out nocopy JTF_VARCHAR2_TABLE_2500
351: , p6_a1 out nocopy JTF_VARCHAR2_TABLE_100
352: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
353: , x_return_tmpt_status out nocopy VARCHAR2
354: , p_during_upd_flag VARCHAR2
355: );
348: , x_msg_data out nocopy VARCHAR2
349: , p_gtt_id NUMBER
350: , p6_a0 out nocopy JTF_VARCHAR2_TABLE_2500
351: , p6_a1 out nocopy JTF_VARCHAR2_TABLE_100
352: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
353: , x_return_tmpt_status out nocopy VARCHAR2
354: , p_during_upd_flag VARCHAR2
355: );
356: procedure validate_for_warnings(p_api_version NUMBER
359: , x_msg_count out nocopy NUMBER
360: , x_msg_data out nocopy VARCHAR2
361: , p_gtt_id NUMBER
362: , p6_a0 out nocopy JTF_VARCHAR2_TABLE_2500
363: , p6_a1 out nocopy JTF_VARCHAR2_TABLE_100
364: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
365: , p_during_upd_flag VARCHAR
366: , x_pri_purpose_list out nocopy VARCHAR
367: );
360: , x_msg_data out nocopy VARCHAR2
361: , p_gtt_id NUMBER
362: , p6_a0 out nocopy JTF_VARCHAR2_TABLE_2500
363: , p6_a1 out nocopy JTF_VARCHAR2_TABLE_100
364: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
365: , p_during_upd_flag VARCHAR
366: , x_pri_purpose_list out nocopy VARCHAR
367: );
368: procedure update_pri_dep_of_sgt(p_api_version NUMBER
373: , p7_a0 JTF_NUMBER_TABLE
374: , p7_a1 JTF_NUMBER_TABLE
375: , p7_a2 JTF_VARCHAR2_TABLE_200
376: , p7_a3 JTF_VARCHAR2_TABLE_2000
377: , p7_a4 JTF_VARCHAR2_TABLE_100
378: , p7_a5 JTF_VARCHAR2_TABLE_100
379: , p7_a6 JTF_VARCHAR2_TABLE_500
380: , p7_a7 JTF_VARCHAR2_TABLE_500
381: , p7_a8 JTF_NUMBER_TABLE
374: , p7_a1 JTF_NUMBER_TABLE
375: , p7_a2 JTF_VARCHAR2_TABLE_200
376: , p7_a3 JTF_VARCHAR2_TABLE_2000
377: , p7_a4 JTF_VARCHAR2_TABLE_100
378: , p7_a5 JTF_VARCHAR2_TABLE_100
379: , p7_a6 JTF_VARCHAR2_TABLE_500
380: , p7_a7 JTF_VARCHAR2_TABLE_500
381: , p7_a8 JTF_NUMBER_TABLE
382: , p7_a9 JTF_NUMBER_TABLE
387: , p7_a14 JTF_NUMBER_TABLE
388: , p8_a0 JTF_NUMBER_TABLE
389: , p8_a1 JTF_NUMBER_TABLE
390: , p8_a2 JTF_NUMBER_TABLE
391: , p8_a3 JTF_VARCHAR2_TABLE_100
392: , p8_a4 JTF_NUMBER_TABLE
393: , p8_a5 JTF_NUMBER_TABLE
394: , p8_a6 JTF_VARCHAR2_TABLE_200
395: , p8_a7 JTF_NUMBER_TABLE
400: , p8_a12 JTF_NUMBER_TABLE
401: , p9_a0 JTF_NUMBER_TABLE
402: , p9_a1 JTF_NUMBER_TABLE
403: , p9_a2 JTF_NUMBER_TABLE
404: , p9_a3 JTF_VARCHAR2_TABLE_100
405: , p9_a4 JTF_NUMBER_TABLE
406: , p9_a5 JTF_NUMBER_TABLE
407: , p9_a6 JTF_VARCHAR2_TABLE_200
408: , p9_a7 JTF_NUMBER_TABLE
413: , p9_a12 JTF_NUMBER_TABLE
414: , p10_a0 JTF_NUMBER_TABLE
415: , p10_a1 JTF_NUMBER_TABLE
416: , p10_a2 JTF_NUMBER_TABLE
417: , p10_a3 JTF_VARCHAR2_TABLE_100
418: , p10_a4 JTF_NUMBER_TABLE
419: , p10_a5 JTF_NUMBER_TABLE
420: , p10_a6 JTF_VARCHAR2_TABLE_200
421: , p10_a7 JTF_NUMBER_TABLE