APPS.OKL_STRM_GEN_TEMPLATE_PVT_W dependencies on JTF_VARCHAR2_TABLE_100

Line 4: , a1 JTF_VARCHAR2_TABLE_100

1: package okl_strm_gen_template_pvt_w as
2: /* $Header: OKLETSGS.pls 120.8 2007/10/15 15:56:42 dpsingh ship $ */
3: procedure rosetta_table_copy_in_p72(t out nocopy okl_strm_gen_template_pvt.error_msgs_tbl_type, a0 JTF_VARCHAR2_TABLE_2500
4: , a1 JTF_VARCHAR2_TABLE_100
5: , a2 JTF_VARCHAR2_TABLE_100
6: );
7: procedure rosetta_table_copy_out_p72(t okl_strm_gen_template_pvt.error_msgs_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_2500
8: , a1 out nocopy JTF_VARCHAR2_TABLE_100

Line 5: , a2 JTF_VARCHAR2_TABLE_100

1: package okl_strm_gen_template_pvt_w as
2: /* $Header: OKLETSGS.pls 120.8 2007/10/15 15:56:42 dpsingh ship $ */
3: procedure rosetta_table_copy_in_p72(t out nocopy okl_strm_gen_template_pvt.error_msgs_tbl_type, a0 JTF_VARCHAR2_TABLE_2500
4: , a1 JTF_VARCHAR2_TABLE_100
5: , a2 JTF_VARCHAR2_TABLE_100
6: );
7: procedure rosetta_table_copy_out_p72(t okl_strm_gen_template_pvt.error_msgs_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_2500
8: , a1 out nocopy JTF_VARCHAR2_TABLE_100
9: , a2 out nocopy JTF_VARCHAR2_TABLE_100

Line 8: , a1 out nocopy JTF_VARCHAR2_TABLE_100

4: , a1 JTF_VARCHAR2_TABLE_100
5: , a2 JTF_VARCHAR2_TABLE_100
6: );
7: procedure rosetta_table_copy_out_p72(t okl_strm_gen_template_pvt.error_msgs_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_2500
8: , a1 out nocopy JTF_VARCHAR2_TABLE_100
9: , a2 out nocopy JTF_VARCHAR2_TABLE_100
10: );
11:
12: procedure create_strm_gen_template(p_api_version NUMBER

Line 9: , a2 out nocopy JTF_VARCHAR2_TABLE_100

5: , a2 JTF_VARCHAR2_TABLE_100
6: );
7: procedure rosetta_table_copy_out_p72(t okl_strm_gen_template_pvt.error_msgs_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_2500
8: , a1 out nocopy JTF_VARCHAR2_TABLE_100
9: , a2 out nocopy JTF_VARCHAR2_TABLE_100
10: );
11:
12: procedure create_strm_gen_template(p_api_version NUMBER
13: , p_init_msg_list VARCHAR2

Line 21: , p7_a4 JTF_VARCHAR2_TABLE_100

17: , p7_a0 JTF_NUMBER_TABLE
18: , p7_a1 JTF_NUMBER_TABLE
19: , p7_a2 JTF_VARCHAR2_TABLE_200
20: , p7_a3 JTF_VARCHAR2_TABLE_2000
21: , p7_a4 JTF_VARCHAR2_TABLE_100
22: , p7_a5 JTF_VARCHAR2_TABLE_100
23: , p7_a6 JTF_VARCHAR2_TABLE_500
24: , p7_a7 JTF_VARCHAR2_TABLE_500
25: , p7_a8 JTF_NUMBER_TABLE

Line 22: , p7_a5 JTF_VARCHAR2_TABLE_100

18: , p7_a1 JTF_NUMBER_TABLE
19: , p7_a2 JTF_VARCHAR2_TABLE_200
20: , p7_a3 JTF_VARCHAR2_TABLE_2000
21: , p7_a4 JTF_VARCHAR2_TABLE_100
22: , p7_a5 JTF_VARCHAR2_TABLE_100
23: , p7_a6 JTF_VARCHAR2_TABLE_500
24: , p7_a7 JTF_VARCHAR2_TABLE_500
25: , p7_a8 JTF_NUMBER_TABLE
26: , p7_a9 JTF_NUMBER_TABLE

Line 35: , p8_a3 JTF_VARCHAR2_TABLE_100

31: , p7_a14 JTF_NUMBER_TABLE
32: , p8_a0 JTF_NUMBER_TABLE
33: , p8_a1 JTF_NUMBER_TABLE
34: , p8_a2 JTF_NUMBER_TABLE
35: , p8_a3 JTF_VARCHAR2_TABLE_100
36: , p8_a4 JTF_NUMBER_TABLE
37: , p8_a5 JTF_NUMBER_TABLE
38: , p8_a6 JTF_VARCHAR2_TABLE_200
39: , p8_a7 JTF_NUMBER_TABLE

Line 132: , p7_a4 JTF_VARCHAR2_TABLE_100

128: , p7_a0 JTF_NUMBER_TABLE
129: , p7_a1 JTF_NUMBER_TABLE
130: , p7_a2 JTF_VARCHAR2_TABLE_200
131: , p7_a3 JTF_VARCHAR2_TABLE_2000
132: , p7_a4 JTF_VARCHAR2_TABLE_100
133: , p7_a5 JTF_VARCHAR2_TABLE_100
134: , p7_a6 JTF_VARCHAR2_TABLE_500
135: , p7_a7 JTF_VARCHAR2_TABLE_500
136: , p7_a8 JTF_NUMBER_TABLE

Line 133: , p7_a5 JTF_VARCHAR2_TABLE_100

129: , p7_a1 JTF_NUMBER_TABLE
130: , p7_a2 JTF_VARCHAR2_TABLE_200
131: , p7_a3 JTF_VARCHAR2_TABLE_2000
132: , p7_a4 JTF_VARCHAR2_TABLE_100
133: , p7_a5 JTF_VARCHAR2_TABLE_100
134: , p7_a6 JTF_VARCHAR2_TABLE_500
135: , p7_a7 JTF_VARCHAR2_TABLE_500
136: , p7_a8 JTF_NUMBER_TABLE
137: , p7_a9 JTF_NUMBER_TABLE

Line 146: , p8_a3 JTF_VARCHAR2_TABLE_100

142: , p7_a14 JTF_NUMBER_TABLE
143: , p8_a0 JTF_NUMBER_TABLE
144: , p8_a1 JTF_NUMBER_TABLE
145: , p8_a2 JTF_NUMBER_TABLE
146: , p8_a3 JTF_VARCHAR2_TABLE_100
147: , p8_a4 JTF_NUMBER_TABLE
148: , p8_a5 JTF_NUMBER_TABLE
149: , p8_a6 JTF_VARCHAR2_TABLE_200
150: , p8_a7 JTF_NUMBER_TABLE

Line 244: , p7_a3 JTF_VARCHAR2_TABLE_100

240: , p_pri_sty_id NUMBER
241: , p7_a0 JTF_NUMBER_TABLE
242: , p7_a1 JTF_NUMBER_TABLE
243: , p7_a2 JTF_NUMBER_TABLE
244: , p7_a3 JTF_VARCHAR2_TABLE_100
245: , p7_a4 JTF_NUMBER_TABLE
246: , p7_a5 JTF_NUMBER_TABLE
247: , p7_a6 JTF_VARCHAR2_TABLE_200
248: , p7_a7 JTF_NUMBER_TABLE

Line 303: , p5_a4 JTF_VARCHAR2_TABLE_100

299: , p5_a0 JTF_NUMBER_TABLE
300: , p5_a1 JTF_NUMBER_TABLE
301: , p5_a2 JTF_VARCHAR2_TABLE_200
302: , p5_a3 JTF_VARCHAR2_TABLE_2000
303: , p5_a4 JTF_VARCHAR2_TABLE_100
304: , p5_a5 JTF_VARCHAR2_TABLE_100
305: , p5_a6 JTF_VARCHAR2_TABLE_500
306: , p5_a7 JTF_VARCHAR2_TABLE_500
307: , p5_a8 JTF_NUMBER_TABLE

Line 304: , p5_a5 JTF_VARCHAR2_TABLE_100

300: , p5_a1 JTF_NUMBER_TABLE
301: , p5_a2 JTF_VARCHAR2_TABLE_200
302: , p5_a3 JTF_VARCHAR2_TABLE_2000
303: , p5_a4 JTF_VARCHAR2_TABLE_100
304: , p5_a5 JTF_VARCHAR2_TABLE_100
305: , p5_a6 JTF_VARCHAR2_TABLE_500
306: , p5_a7 JTF_VARCHAR2_TABLE_500
307: , p5_a8 JTF_NUMBER_TABLE
308: , p5_a9 JTF_NUMBER_TABLE

Line 323: , p5_a3 JTF_VARCHAR2_TABLE_100

319: , x_msg_data out nocopy VARCHAR2
320: , p5_a0 JTF_NUMBER_TABLE
321: , p5_a1 JTF_NUMBER_TABLE
322: , p5_a2 JTF_NUMBER_TABLE
323: , p5_a3 JTF_VARCHAR2_TABLE_100
324: , p5_a4 JTF_NUMBER_TABLE
325: , p5_a5 JTF_NUMBER_TABLE
326: , p5_a6 JTF_VARCHAR2_TABLE_200
327: , p5_a7 JTF_NUMBER_TABLE

Line 342: , p5_a3 JTF_VARCHAR2_TABLE_100

338: , x_msg_data out nocopy VARCHAR2
339: , p5_a0 JTF_NUMBER_TABLE
340: , p5_a1 JTF_NUMBER_TABLE
341: , p5_a2 JTF_NUMBER_TABLE
342: , p5_a3 JTF_VARCHAR2_TABLE_100
343: , p5_a4 JTF_NUMBER_TABLE
344: , p5_a5 JTF_NUMBER_TABLE
345: , p5_a6 JTF_VARCHAR2_TABLE_200
346: , p5_a7 JTF_NUMBER_TABLE

Line 360: , p6_a1 out nocopy JTF_VARCHAR2_TABLE_100

356: , x_msg_count out nocopy NUMBER
357: , x_msg_data out nocopy VARCHAR2
358: , p_gtt_id NUMBER
359: , p6_a0 out nocopy JTF_VARCHAR2_TABLE_2500
360: , p6_a1 out nocopy JTF_VARCHAR2_TABLE_100
361: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
362: , x_return_tmpt_status out nocopy VARCHAR2
363: , p_during_upd_flag VARCHAR2
364: );

Line 361: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100

357: , x_msg_data out nocopy VARCHAR2
358: , p_gtt_id NUMBER
359: , p6_a0 out nocopy JTF_VARCHAR2_TABLE_2500
360: , p6_a1 out nocopy JTF_VARCHAR2_TABLE_100
361: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
362: , x_return_tmpt_status out nocopy VARCHAR2
363: , p_during_upd_flag VARCHAR2
364: );
365: procedure validate_for_warnings(p_api_version NUMBER

Line 372: , p6_a1 out nocopy JTF_VARCHAR2_TABLE_100

368: , x_msg_count out nocopy NUMBER
369: , x_msg_data out nocopy VARCHAR2
370: , p_gtt_id NUMBER
371: , p6_a0 out nocopy JTF_VARCHAR2_TABLE_2500
372: , p6_a1 out nocopy JTF_VARCHAR2_TABLE_100
373: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
374: , p_during_upd_flag VARCHAR
375: , x_pri_purpose_list out nocopy VARCHAR
376: );

Line 373: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100

369: , x_msg_data out nocopy VARCHAR2
370: , p_gtt_id NUMBER
371: , p6_a0 out nocopy JTF_VARCHAR2_TABLE_2500
372: , p6_a1 out nocopy JTF_VARCHAR2_TABLE_100
373: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
374: , p_during_upd_flag VARCHAR
375: , x_pri_purpose_list out nocopy VARCHAR
376: );
377: procedure update_pri_dep_of_sgt(p_api_version NUMBER

Line 386: , p7_a4 JTF_VARCHAR2_TABLE_100

382: , p7_a0 JTF_NUMBER_TABLE
383: , p7_a1 JTF_NUMBER_TABLE
384: , p7_a2 JTF_VARCHAR2_TABLE_200
385: , p7_a3 JTF_VARCHAR2_TABLE_2000
386: , p7_a4 JTF_VARCHAR2_TABLE_100
387: , p7_a5 JTF_VARCHAR2_TABLE_100
388: , p7_a6 JTF_VARCHAR2_TABLE_500
389: , p7_a7 JTF_VARCHAR2_TABLE_500
390: , p7_a8 JTF_NUMBER_TABLE

Line 387: , p7_a5 JTF_VARCHAR2_TABLE_100

383: , p7_a1 JTF_NUMBER_TABLE
384: , p7_a2 JTF_VARCHAR2_TABLE_200
385: , p7_a3 JTF_VARCHAR2_TABLE_2000
386: , p7_a4 JTF_VARCHAR2_TABLE_100
387: , p7_a5 JTF_VARCHAR2_TABLE_100
388: , p7_a6 JTF_VARCHAR2_TABLE_500
389: , p7_a7 JTF_VARCHAR2_TABLE_500
390: , p7_a8 JTF_NUMBER_TABLE
391: , p7_a9 JTF_NUMBER_TABLE

Line 400: , p8_a3 JTF_VARCHAR2_TABLE_100

396: , p7_a14 JTF_NUMBER_TABLE
397: , p8_a0 JTF_NUMBER_TABLE
398: , p8_a1 JTF_NUMBER_TABLE
399: , p8_a2 JTF_NUMBER_TABLE
400: , p8_a3 JTF_VARCHAR2_TABLE_100
401: , p8_a4 JTF_NUMBER_TABLE
402: , p8_a5 JTF_NUMBER_TABLE
403: , p8_a6 JTF_VARCHAR2_TABLE_200
404: , p8_a7 JTF_NUMBER_TABLE

Line 413: , p9_a3 JTF_VARCHAR2_TABLE_100

409: , p8_a12 JTF_NUMBER_TABLE
410: , p9_a0 JTF_NUMBER_TABLE
411: , p9_a1 JTF_NUMBER_TABLE
412: , p9_a2 JTF_NUMBER_TABLE
413: , p9_a3 JTF_VARCHAR2_TABLE_100
414: , p9_a4 JTF_NUMBER_TABLE
415: , p9_a5 JTF_NUMBER_TABLE
416: , p9_a6 JTF_VARCHAR2_TABLE_200
417: , p9_a7 JTF_NUMBER_TABLE

Line 426: , p10_a3 JTF_VARCHAR2_TABLE_100

422: , p9_a12 JTF_NUMBER_TABLE
423: , p10_a0 JTF_NUMBER_TABLE
424: , p10_a1 JTF_NUMBER_TABLE
425: , p10_a2 JTF_NUMBER_TABLE
426: , p10_a3 JTF_VARCHAR2_TABLE_100
427: , p10_a4 JTF_NUMBER_TABLE
428: , p10_a5 JTF_NUMBER_TABLE
429: , p10_a6 JTF_VARCHAR2_TABLE_200
430: , p10_a7 JTF_NUMBER_TABLE