DBA Data[Home] [Help]

APPS.CN_GET_TX_DATA_PUB_W dependencies on JTF_VARCHAR2_TABLE_400

Line 5: , a2 JTF_VARCHAR2_TABLE_400

1: package cn_get_tx_data_pub_w as
2: /* $Header: cnwxadjs.pls 120.4.12000000.2 2007/08/08 05:57:56 apink ship $ */
3: procedure rosetta_table_copy_in_p1(t out nocopy cn_get_tx_data_pub.adj_tbl_type, a0 JTF_NUMBER_TABLE
4: , a1 JTF_VARCHAR2_TABLE_100
5: , a2 JTF_VARCHAR2_TABLE_400
6: , a3 JTF_NUMBER_TABLE
7: , a4 JTF_NUMBER_TABLE
8: , a5 JTF_VARCHAR2_TABLE_100
9: , a6 JTF_DATE_TABLE

Line 197: , a2 out nocopy JTF_VARCHAR2_TABLE_400

193: , a190 JTF_VARCHAR2_TABLE_2000
194: );
195: procedure rosetta_table_copy_out_p1(t cn_get_tx_data_pub.adj_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
196: , a1 out nocopy JTF_VARCHAR2_TABLE_100
197: , a2 out nocopy JTF_VARCHAR2_TABLE_400
198: , a3 out nocopy JTF_NUMBER_TABLE
199: , a4 out nocopy JTF_NUMBER_TABLE
200: , a5 out nocopy JTF_VARCHAR2_TABLE_100
201: , a6 out nocopy JTF_DATE_TABLE

Line 390: , a2 JTF_VARCHAR2_TABLE_400

386: );
387:
388: procedure rosetta_table_copy_in_p3(t out nocopy cn_get_tx_data_pub.tx_adj_data_tbl, a0 JTF_NUMBER_TABLE
389: , a1 JTF_VARCHAR2_TABLE_100
390: , a2 JTF_VARCHAR2_TABLE_400
391: , a3 JTF_DATE_TABLE
392: , a4 JTF_NUMBER_TABLE
393: , a5 JTF_NUMBER_TABLE
394: , a6 JTF_NUMBER_TABLE

Line 406: , a2 out nocopy JTF_VARCHAR2_TABLE_400

402: , a14 JTF_NUMBER_TABLE
403: );
404: procedure rosetta_table_copy_out_p3(t cn_get_tx_data_pub.tx_adj_data_tbl, a0 out nocopy JTF_NUMBER_TABLE
405: , a1 out nocopy JTF_VARCHAR2_TABLE_100
406: , a2 out nocopy JTF_VARCHAR2_TABLE_400
407: , a3 out nocopy JTF_DATE_TABLE
408: , a4 out nocopy JTF_NUMBER_TABLE
409: , a5 out nocopy JTF_NUMBER_TABLE
410: , a6 out nocopy JTF_NUMBER_TABLE

Line 437: , a3 JTF_VARCHAR2_TABLE_400

433:
434: procedure rosetta_table_copy_in_p7(t out nocopy cn_get_tx_data_pub.trx_line_tbl, a0 JTF_NUMBER_TABLE
435: , a1 JTF_NUMBER_TABLE
436: , a2 JTF_NUMBER_TABLE
437: , a3 JTF_VARCHAR2_TABLE_400
438: , a4 JTF_VARCHAR2_TABLE_100
439: , a5 JTF_NUMBER_TABLE
440: , a6 JTF_DATE_TABLE
441: , a7 JTF_VARCHAR2_TABLE_100

Line 453: , a19 JTF_VARCHAR2_TABLE_400

449: , a15 JTF_NUMBER_TABLE
450: , a16 JTF_VARCHAR2_TABLE_100
451: , a17 JTF_VARCHAR2_TABLE_100
452: , a18 JTF_VARCHAR2_TABLE_100
453: , a19 JTF_VARCHAR2_TABLE_400
454: );
455: procedure rosetta_table_copy_out_p7(t cn_get_tx_data_pub.trx_line_tbl, a0 out nocopy JTF_NUMBER_TABLE
456: , a1 out nocopy JTF_NUMBER_TABLE
457: , a2 out nocopy JTF_NUMBER_TABLE

Line 458: , a3 out nocopy JTF_VARCHAR2_TABLE_400

454: );
455: procedure rosetta_table_copy_out_p7(t cn_get_tx_data_pub.trx_line_tbl, a0 out nocopy JTF_NUMBER_TABLE
456: , a1 out nocopy JTF_NUMBER_TABLE
457: , a2 out nocopy JTF_NUMBER_TABLE
458: , a3 out nocopy JTF_VARCHAR2_TABLE_400
459: , a4 out nocopy JTF_VARCHAR2_TABLE_100
460: , a5 out nocopy JTF_NUMBER_TABLE
461: , a6 out nocopy JTF_DATE_TABLE
462: , a7 out nocopy JTF_VARCHAR2_TABLE_100

Line 474: , a19 out nocopy JTF_VARCHAR2_TABLE_400

470: , a15 out nocopy JTF_NUMBER_TABLE
471: , a16 out nocopy JTF_VARCHAR2_TABLE_100
472: , a17 out nocopy JTF_VARCHAR2_TABLE_100
473: , a18 out nocopy JTF_VARCHAR2_TABLE_100
474: , a19 out nocopy JTF_VARCHAR2_TABLE_400
475: );
476:
477: procedure rosetta_table_copy_in_p9(t out nocopy cn_get_tx_data_pub.cust_info_tbl, a0 JTF_NUMBER_TABLE
478: , a1 JTF_VARCHAR2_TABLE_100

Line 497: , a20 JTF_VARCHAR2_TABLE_400

493: , a16 JTF_VARCHAR2_TABLE_100
494: , a17 JTF_VARCHAR2_TABLE_100
495: , a18 JTF_VARCHAR2_TABLE_100
496: , a19 JTF_NUMBER_TABLE
497: , a20 JTF_VARCHAR2_TABLE_400
498: , a21 JTF_NUMBER_TABLE
499: , a22 JTF_VARCHAR2_TABLE_400
500: );
501: procedure rosetta_table_copy_out_p9(t cn_get_tx_data_pub.cust_info_tbl, a0 out nocopy JTF_NUMBER_TABLE

Line 499: , a22 JTF_VARCHAR2_TABLE_400

495: , a18 JTF_VARCHAR2_TABLE_100
496: , a19 JTF_NUMBER_TABLE
497: , a20 JTF_VARCHAR2_TABLE_400
498: , a21 JTF_NUMBER_TABLE
499: , a22 JTF_VARCHAR2_TABLE_400
500: );
501: procedure rosetta_table_copy_out_p9(t cn_get_tx_data_pub.cust_info_tbl, a0 out nocopy JTF_NUMBER_TABLE
502: , a1 out nocopy JTF_VARCHAR2_TABLE_100
503: , a2 out nocopy JTF_VARCHAR2_TABLE_300

Line 521: , a20 out nocopy JTF_VARCHAR2_TABLE_400

517: , a16 out nocopy JTF_VARCHAR2_TABLE_100
518: , a17 out nocopy JTF_VARCHAR2_TABLE_100
519: , a18 out nocopy JTF_VARCHAR2_TABLE_100
520: , a19 out nocopy JTF_NUMBER_TABLE
521: , a20 out nocopy JTF_VARCHAR2_TABLE_400
522: , a21 out nocopy JTF_NUMBER_TABLE
523: , a22 out nocopy JTF_VARCHAR2_TABLE_400
524: );
525:

Line 523: , a22 out nocopy JTF_VARCHAR2_TABLE_400

519: , a18 out nocopy JTF_VARCHAR2_TABLE_100
520: , a19 out nocopy JTF_NUMBER_TABLE
521: , a20 out nocopy JTF_VARCHAR2_TABLE_400
522: , a21 out nocopy JTF_NUMBER_TABLE
523: , a22 out nocopy JTF_VARCHAR2_TABLE_400
524: );
525:
526: procedure rosetta_table_copy_in_p11(t out nocopy cn_get_tx_data_pub.attribute_tbl, a0 JTF_VARCHAR2_TABLE_100
527: , a1 JTF_VARCHAR2_TABLE_100

Line 536: , p1_a2 out nocopy JTF_VARCHAR2_TABLE_400

532:
533: procedure get_api_data(p_comm_lines_api_id NUMBER
534: , p1_a0 out nocopy JTF_NUMBER_TABLE
535: , p1_a1 out nocopy JTF_VARCHAR2_TABLE_100
536: , p1_a2 out nocopy JTF_VARCHAR2_TABLE_400
537: , p1_a3 out nocopy JTF_NUMBER_TABLE
538: , p1_a4 out nocopy JTF_NUMBER_TABLE
539: , p1_a5 out nocopy JTF_VARCHAR2_TABLE_100
540: , p1_a6 out nocopy JTF_DATE_TABLE

Line 937: , p19_a2 out nocopy JTF_VARCHAR2_TABLE_400

933: , x_msg_data out nocopy VARCHAR2
934: , x_loading_status out nocopy VARCHAR2
935: , p19_a0 out nocopy JTF_NUMBER_TABLE
936: , p19_a1 out nocopy JTF_VARCHAR2_TABLE_100
937: , p19_a2 out nocopy JTF_VARCHAR2_TABLE_400
938: , p19_a3 out nocopy JTF_NUMBER_TABLE
939: , p19_a4 out nocopy JTF_NUMBER_TABLE
940: , p19_a5 out nocopy JTF_VARCHAR2_TABLE_100
941: , p19_a6 out nocopy JTF_DATE_TABLE

Line 1140: , p9_a2 out nocopy JTF_VARCHAR2_TABLE_400

1136: , x_msg_data out nocopy VARCHAR2
1137: , x_loading_status out nocopy VARCHAR2
1138: , p9_a0 out nocopy JTF_NUMBER_TABLE
1139: , p9_a1 out nocopy JTF_VARCHAR2_TABLE_100
1140: , p9_a2 out nocopy JTF_VARCHAR2_TABLE_400
1141: , p9_a3 out nocopy JTF_NUMBER_TABLE
1142: , p9_a4 out nocopy JTF_NUMBER_TABLE
1143: , p9_a5 out nocopy JTF_VARCHAR2_TABLE_100
1144: , p9_a6 out nocopy JTF_DATE_TABLE

Line 1965: , p8_a3 out nocopy JTF_VARCHAR2_TABLE_400

1961: , x_loading_status out nocopy VARCHAR2
1962: , p8_a0 out nocopy JTF_NUMBER_TABLE
1963: , p8_a1 out nocopy JTF_NUMBER_TABLE
1964: , p8_a2 out nocopy JTF_NUMBER_TABLE
1965: , p8_a3 out nocopy JTF_VARCHAR2_TABLE_400
1966: , p8_a4 out nocopy JTF_VARCHAR2_TABLE_100
1967: , p8_a5 out nocopy JTF_NUMBER_TABLE
1968: , p8_a6 out nocopy JTF_DATE_TABLE
1969: , p8_a7 out nocopy JTF_VARCHAR2_TABLE_100

Line 1981: , p8_a19 out nocopy JTF_VARCHAR2_TABLE_400

1977: , p8_a15 out nocopy JTF_NUMBER_TABLE
1978: , p8_a16 out nocopy JTF_VARCHAR2_TABLE_100
1979: , p8_a17 out nocopy JTF_VARCHAR2_TABLE_100
1980: , p8_a18 out nocopy JTF_VARCHAR2_TABLE_100
1981: , p8_a19 out nocopy JTF_VARCHAR2_TABLE_400
1982: , x_tbl_count out nocopy NUMBER
1983: );
1984: procedure get_trx_history(p_api_version NUMBER
1985: , p_init_msg_list VARCHAR2

Line 1994: , p8_a2 out nocopy JTF_VARCHAR2_TABLE_400

1990: , x_msg_data out nocopy VARCHAR2
1991: , x_loading_status out nocopy VARCHAR2
1992: , p8_a0 out nocopy JTF_NUMBER_TABLE
1993: , p8_a1 out nocopy JTF_VARCHAR2_TABLE_100
1994: , p8_a2 out nocopy JTF_VARCHAR2_TABLE_400
1995: , p8_a3 out nocopy JTF_NUMBER_TABLE
1996: , p8_a4 out nocopy JTF_NUMBER_TABLE
1997: , p8_a5 out nocopy JTF_VARCHAR2_TABLE_100
1998: , p8_a6 out nocopy JTF_DATE_TABLE