DBA Data[Home] [Help]

APPS.CS_TP_CHOICES_PVT_W dependencies on JTF_VARCHAR2_TABLE_100

Line 4: , a1 JTF_VARCHAR2_TABLE_1000

1: package cs_tp_choices_pvt_w as
2: /* $Header: cstprcss.pls 120.2 2005/06/30 10:59 appldev ship $ */
3: procedure rosetta_table_copy_in_p1(t out nocopy cs_tp_choices_pvt.choice_list, a0 JTF_NUMBER_TABLE
4: , a1 JTF_VARCHAR2_TABLE_1000
5: , a2 JTF_NUMBER_TABLE
6: , a3 JTF_NUMBER_TABLE
7: , a4 JTF_VARCHAR2_TABLE_100
8: , a5 JTF_VARCHAR2_TABLE_100

Line 7: , a4 JTF_VARCHAR2_TABLE_100

3: procedure rosetta_table_copy_in_p1(t out nocopy cs_tp_choices_pvt.choice_list, a0 JTF_NUMBER_TABLE
4: , a1 JTF_VARCHAR2_TABLE_1000
5: , a2 JTF_NUMBER_TABLE
6: , a3 JTF_NUMBER_TABLE
7: , a4 JTF_VARCHAR2_TABLE_100
8: , a5 JTF_VARCHAR2_TABLE_100
9: );
10: procedure rosetta_table_copy_out_p1(t cs_tp_choices_pvt.choice_list, a0 out nocopy JTF_NUMBER_TABLE
11: , a1 out nocopy JTF_VARCHAR2_TABLE_1000

Line 8: , a5 JTF_VARCHAR2_TABLE_100

4: , a1 JTF_VARCHAR2_TABLE_1000
5: , a2 JTF_NUMBER_TABLE
6: , a3 JTF_NUMBER_TABLE
7: , a4 JTF_VARCHAR2_TABLE_100
8: , a5 JTF_VARCHAR2_TABLE_100
9: );
10: procedure rosetta_table_copy_out_p1(t cs_tp_choices_pvt.choice_list, a0 out nocopy JTF_NUMBER_TABLE
11: , a1 out nocopy JTF_VARCHAR2_TABLE_1000
12: , a2 out nocopy JTF_NUMBER_TABLE

Line 11: , a1 out nocopy JTF_VARCHAR2_TABLE_1000

7: , a4 JTF_VARCHAR2_TABLE_100
8: , a5 JTF_VARCHAR2_TABLE_100
9: );
10: procedure rosetta_table_copy_out_p1(t cs_tp_choices_pvt.choice_list, a0 out nocopy JTF_NUMBER_TABLE
11: , a1 out nocopy JTF_VARCHAR2_TABLE_1000
12: , a2 out nocopy JTF_NUMBER_TABLE
13: , a3 out nocopy JTF_NUMBER_TABLE
14: , a4 out nocopy JTF_VARCHAR2_TABLE_100
15: , a5 out nocopy JTF_VARCHAR2_TABLE_100

Line 14: , a4 out nocopy JTF_VARCHAR2_TABLE_100

10: procedure rosetta_table_copy_out_p1(t cs_tp_choices_pvt.choice_list, a0 out nocopy JTF_NUMBER_TABLE
11: , a1 out nocopy JTF_VARCHAR2_TABLE_1000
12: , a2 out nocopy JTF_NUMBER_TABLE
13: , a3 out nocopy JTF_NUMBER_TABLE
14: , a4 out nocopy JTF_VARCHAR2_TABLE_100
15: , a5 out nocopy JTF_VARCHAR2_TABLE_100
16: );
17:
18: procedure add_choice(p_api_version_number NUMBER

Line 15: , a5 out nocopy JTF_VARCHAR2_TABLE_100

11: , a1 out nocopy JTF_VARCHAR2_TABLE_1000
12: , a2 out nocopy JTF_NUMBER_TABLE
13: , a3 out nocopy JTF_NUMBER_TABLE
14: , a4 out nocopy JTF_VARCHAR2_TABLE_100
15: , a5 out nocopy JTF_VARCHAR2_TABLE_100
16: );
17:
18: procedure add_choice(p_api_version_number NUMBER
19: , p_init_msg_list VARCHAR2

Line 36: , p3_a1 JTF_VARCHAR2_TABLE_1000

32: procedure sort_choices(p_api_version_number NUMBER
33: , p_init_msg_list VARCHAR2
34: , p_commit VARCHAR
35: , p3_a0 JTF_NUMBER_TABLE
36: , p3_a1 JTF_VARCHAR2_TABLE_1000
37: , p3_a2 JTF_NUMBER_TABLE
38: , p3_a3 JTF_NUMBER_TABLE
39: , p3_a4 JTF_VARCHAR2_TABLE_100
40: , p3_a5 JTF_VARCHAR2_TABLE_100

Line 39: , p3_a4 JTF_VARCHAR2_TABLE_100

35: , p3_a0 JTF_NUMBER_TABLE
36: , p3_a1 JTF_VARCHAR2_TABLE_1000
37: , p3_a2 JTF_NUMBER_TABLE
38: , p3_a3 JTF_NUMBER_TABLE
39: , p3_a4 JTF_VARCHAR2_TABLE_100
40: , p3_a5 JTF_VARCHAR2_TABLE_100
41: , x_msg_count out nocopy NUMBER
42: , x_msg_data out nocopy VARCHAR2
43: , x_return_status out nocopy VARCHAR2

Line 40: , p3_a5 JTF_VARCHAR2_TABLE_100

36: , p3_a1 JTF_VARCHAR2_TABLE_1000
37: , p3_a2 JTF_NUMBER_TABLE
38: , p3_a3 JTF_NUMBER_TABLE
39: , p3_a4 JTF_VARCHAR2_TABLE_100
40: , p3_a5 JTF_VARCHAR2_TABLE_100
41: , x_msg_count out nocopy NUMBER
42: , x_msg_data out nocopy VARCHAR2
43: , x_return_status out nocopy VARCHAR2
44: );

Line 54: , p8_a1 out nocopy JTF_VARCHAR2_TABLE_1000

50: , x_msg_count out nocopy NUMBER
51: , x_msg_data out nocopy VARCHAR2
52: , x_return_status out nocopy VARCHAR2
53: , p8_a0 out nocopy JTF_NUMBER_TABLE
54: , p8_a1 out nocopy JTF_VARCHAR2_TABLE_1000
55: , p8_a2 out nocopy JTF_NUMBER_TABLE
56: , p8_a3 out nocopy JTF_NUMBER_TABLE
57: , p8_a4 out nocopy JTF_VARCHAR2_TABLE_100
58: , p8_a5 out nocopy JTF_VARCHAR2_TABLE_100

Line 57: , p8_a4 out nocopy JTF_VARCHAR2_TABLE_100

53: , p8_a0 out nocopy JTF_NUMBER_TABLE
54: , p8_a1 out nocopy JTF_VARCHAR2_TABLE_1000
55: , p8_a2 out nocopy JTF_NUMBER_TABLE
56: , p8_a3 out nocopy JTF_NUMBER_TABLE
57: , p8_a4 out nocopy JTF_VARCHAR2_TABLE_100
58: , p8_a5 out nocopy JTF_VARCHAR2_TABLE_100
59: );
60: procedure update_choices(p_api_version_number NUMBER
61: , p_init_msg_list VARCHAR2

Line 58: , p8_a5 out nocopy JTF_VARCHAR2_TABLE_100

54: , p8_a1 out nocopy JTF_VARCHAR2_TABLE_1000
55: , p8_a2 out nocopy JTF_NUMBER_TABLE
56: , p8_a3 out nocopy JTF_NUMBER_TABLE
57: , p8_a4 out nocopy JTF_VARCHAR2_TABLE_100
58: , p8_a5 out nocopy JTF_VARCHAR2_TABLE_100
59: );
60: procedure update_choices(p_api_version_number NUMBER
61: , p_init_msg_list VARCHAR2
62: , p_commit VARCHAR

Line 64: , p3_a1 JTF_VARCHAR2_TABLE_1000

60: procedure update_choices(p_api_version_number NUMBER
61: , p_init_msg_list VARCHAR2
62: , p_commit VARCHAR
63: , p3_a0 JTF_NUMBER_TABLE
64: , p3_a1 JTF_VARCHAR2_TABLE_1000
65: , p3_a2 JTF_NUMBER_TABLE
66: , p3_a3 JTF_NUMBER_TABLE
67: , p3_a4 JTF_VARCHAR2_TABLE_100
68: , p3_a5 JTF_VARCHAR2_TABLE_100

Line 67: , p3_a4 JTF_VARCHAR2_TABLE_100

63: , p3_a0 JTF_NUMBER_TABLE
64: , p3_a1 JTF_VARCHAR2_TABLE_1000
65: , p3_a2 JTF_NUMBER_TABLE
66: , p3_a3 JTF_NUMBER_TABLE
67: , p3_a4 JTF_VARCHAR2_TABLE_100
68: , p3_a5 JTF_VARCHAR2_TABLE_100
69: , x_msg_count out nocopy NUMBER
70: , x_msg_data out nocopy VARCHAR2
71: , x_return_status out nocopy VARCHAR2

Line 68: , p3_a5 JTF_VARCHAR2_TABLE_100

64: , p3_a1 JTF_VARCHAR2_TABLE_1000
65: , p3_a2 JTF_NUMBER_TABLE
66: , p3_a3 JTF_NUMBER_TABLE
67: , p3_a4 JTF_VARCHAR2_TABLE_100
68: , p3_a5 JTF_VARCHAR2_TABLE_100
69: , x_msg_count out nocopy NUMBER
70: , x_msg_data out nocopy VARCHAR2
71: , x_return_status out nocopy VARCHAR2
72: );