[Home] [Help]
PACKAGE: APPS.CS_TP_CHOICES_PVT_W
Source
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
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
16 );
17
18 procedure add_choice(p_api_version_number NUMBER
19 , p_init_msg_list VARCHAR2
20 , p_commit VARCHAR
21 , x_msg_count out nocopy NUMBER
22 , x_msg_data out nocopy VARCHAR2
23 , x_return_status out nocopy VARCHAR2
24 , x_choice_id out nocopy NUMBER
25 , p3_a0 NUMBER := 0-1962.0724
26 , p3_a1 VARCHAR2 := fnd_api.g_miss_char
27 , p3_a2 NUMBER := 0-1962.0724
28 , p3_a3 NUMBER := 0-1962.0724
29 , p3_a4 VARCHAR2 := fnd_api.g_miss_char
30 , p3_a5 VARCHAR2 := fnd_api.g_miss_char
31 );
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
41 , x_msg_count out nocopy NUMBER
42 , x_msg_data out nocopy VARCHAR2
43 , x_return_status out nocopy VARCHAR2
44 );
45 procedure show_choices(p_api_version_number NUMBER
46 , p_init_msg_list VARCHAR2
47 , p_commit VARCHAR
48 , p_lookup_id NUMBER
49 , p_display_order VARCHAR2
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
59 );
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
69 , x_msg_count out nocopy NUMBER
70 , x_msg_data out nocopy VARCHAR2
71 , x_return_status out nocopy VARCHAR2
72 );
73 procedure add_freetext(p_api_version_number NUMBER
74 , p_init_msg_list VARCHAR2
75 , p_commit VARCHAR
76 , x_msg_count out nocopy NUMBER
77 , x_msg_data out nocopy VARCHAR2
78 , x_return_status out nocopy VARCHAR2
79 , x_freetext_id out nocopy NUMBER
80 , p3_a0 NUMBER := 0-1962.0724
81 , p3_a1 NUMBER := 0-1962.0724
82 , p3_a2 VARCHAR2 := fnd_api.g_miss_char
83 , p3_a3 NUMBER := 0-1962.0724
84 , p3_a4 VARCHAR2 := fnd_api.g_miss_char
85 );
86 procedure show_freetext(p_api_version_number NUMBER
87 , p_init_msg_list VARCHAR2
88 , p_commit VARCHAR
89 , p_lookup_id NUMBER
90 , x_msg_count out nocopy NUMBER
91 , x_msg_data out nocopy VARCHAR2
92 , x_return_status out nocopy VARCHAR2
93 , p7_a0 out nocopy NUMBER
94 , p7_a1 out nocopy NUMBER
95 , p7_a2 out nocopy VARCHAR2
96 , p7_a3 out nocopy NUMBER
97 , p7_a4 out nocopy VARCHAR2
98 );
99 end cs_tp_choices_pvt_w;