[Home] [Help]
PACKAGE: APPS.CS_TP_QUESTIONS_PVT_W
Source
1 package cs_tp_questions_pvt_w AUTHID CURRENT_USER as
2 /* $Header: cstprqss.pls 120.2 2005/06/30 11:03 appldev ship $ */
3 procedure rosetta_table_copy_in_p1(t out nocopy cs_tp_questions_pvt.question_list, a0 JTF_NUMBER_TABLE
4 , a1 JTF_VARCHAR2_TABLE_2000
5 , a2 JTF_VARCHAR2_TABLE_100
6 , a3 JTF_VARCHAR2_TABLE_100
7 , a4 JTF_VARCHAR2_TABLE_100
8 , a5 JTF_NUMBER_TABLE
9 , a6 JTF_VARCHAR2_TABLE_100
10 , a7 JTF_VARCHAR2_TABLE_100
11 , a8 JTF_VARCHAR2_TABLE_100
12 );
13 procedure rosetta_table_copy_out_p1(t cs_tp_questions_pvt.question_list, a0 out nocopy JTF_NUMBER_TABLE
14 , a1 out nocopy JTF_VARCHAR2_TABLE_2000
15 , a2 out nocopy JTF_VARCHAR2_TABLE_100
16 , a3 out nocopy JTF_VARCHAR2_TABLE_100
17 , a4 out nocopy JTF_VARCHAR2_TABLE_100
18 , a5 out nocopy JTF_NUMBER_TABLE
19 , a6 out nocopy JTF_VARCHAR2_TABLE_100
20 , a7 out nocopy JTF_VARCHAR2_TABLE_100
21 , a8 out nocopy JTF_VARCHAR2_TABLE_100
22 );
23
24 procedure add_question(p_api_version_number NUMBER
25 , p_init_msg_list VARCHAR2
26 , p_commit VARCHAR
27 , p_template_id NUMBER
28 , x_msg_count out nocopy NUMBER
29 , x_msg_data out nocopy VARCHAR2
30 , x_return_status out nocopy VARCHAR2
31 , x_question_id out nocopy NUMBER
32 , p3_a0 NUMBER := 0-1962.0724
33 , p3_a1 VARCHAR2 := fnd_api.g_miss_char
34 , p3_a2 VARCHAR2 := fnd_api.g_miss_char
35 , p3_a3 VARCHAR2 := fnd_api.g_miss_char
36 , p3_a4 VARCHAR2 := fnd_api.g_miss_char
37 , p3_a5 NUMBER := 0-1962.0724
38 , p3_a6 VARCHAR2 := fnd_api.g_miss_char
39 , p3_a7 VARCHAR2 := fnd_api.g_miss_char
40 , p3_a8 VARCHAR2 := fnd_api.g_miss_char
41 );
42 procedure update_question(p_api_version_number NUMBER
43 , p_init_msg_list VARCHAR2
44 , p_commit VARCHAR
45 , x_msg_count out nocopy NUMBER
46 , x_msg_data out nocopy VARCHAR2
47 , x_return_status out nocopy VARCHAR2
48 , p3_a0 NUMBER := 0-1962.0724
49 , p3_a1 VARCHAR2 := fnd_api.g_miss_char
50 , p3_a2 VARCHAR2 := fnd_api.g_miss_char
51 , p3_a3 VARCHAR2 := fnd_api.g_miss_char
52 , p3_a4 VARCHAR2 := fnd_api.g_miss_char
53 , p3_a5 NUMBER := 0-1962.0724
54 , p3_a6 VARCHAR2 := fnd_api.g_miss_char
55 , p3_a7 VARCHAR2 := fnd_api.g_miss_char
56 , p3_a8 VARCHAR2 := fnd_api.g_miss_char
57 );
58 procedure sort_questions(p_api_version_number NUMBER
59 , p_init_msg_list VARCHAR2
60 , p_commit VARCHAR
61 , p3_a0 JTF_NUMBER_TABLE
62 , p3_a1 JTF_VARCHAR2_TABLE_2000
63 , p3_a2 JTF_VARCHAR2_TABLE_100
64 , p3_a3 JTF_VARCHAR2_TABLE_100
65 , p3_a4 JTF_VARCHAR2_TABLE_100
66 , p3_a5 JTF_NUMBER_TABLE
67 , p3_a6 JTF_VARCHAR2_TABLE_100
68 , p3_a7 JTF_VARCHAR2_TABLE_100
69 , p3_a8 JTF_VARCHAR2_TABLE_100
70 , p_template_id NUMBER
71 , x_msg_count out nocopy NUMBER
72 , x_msg_data out nocopy VARCHAR2
73 , x_return_status out nocopy VARCHAR2
74 );
75 procedure show_questions(p_api_version_number NUMBER
76 , p_init_msg_list VARCHAR2
77 , p_commit VARCHAR
78 , p_template_id NUMBER
79 , p_start_question NUMBER
80 , p_end_question NUMBER
81 , p_display_order VARCHAR2
82 , x_msg_count out nocopy NUMBER
83 , x_msg_data out nocopy VARCHAR2
84 , x_return_status out nocopy VARCHAR2
85 , p10_a0 out nocopy JTF_NUMBER_TABLE
86 , p10_a1 out nocopy JTF_VARCHAR2_TABLE_2000
87 , p10_a2 out nocopy JTF_VARCHAR2_TABLE_100
88 , p10_a3 out nocopy JTF_VARCHAR2_TABLE_100
89 , p10_a4 out nocopy JTF_VARCHAR2_TABLE_100
90 , p10_a5 out nocopy JTF_NUMBER_TABLE
91 , p10_a6 out nocopy JTF_VARCHAR2_TABLE_100
92 , p10_a7 out nocopy JTF_VARCHAR2_TABLE_100
93 , p10_a8 out nocopy JTF_VARCHAR2_TABLE_100
94 , x_total_questions out nocopy NUMBER
95 , x_retrieved_question_number out nocopy NUMBER
96 );
97 procedure show_question(p_api_version_number NUMBER
98 , p_init_msg_list VARCHAR2
99 , p_commit VARCHAR
100 , p_question_id NUMBER
101 , x_msg_count out nocopy NUMBER
102 , x_msg_data out nocopy VARCHAR2
103 , x_return_status out nocopy VARCHAR2
104 , p7_a0 out nocopy NUMBER
105 , p7_a1 out nocopy VARCHAR2
106 , p7_a2 out nocopy VARCHAR2
107 , p7_a3 out nocopy VARCHAR2
108 , p7_a4 out nocopy VARCHAR2
109 , p7_a5 out nocopy NUMBER
110 , p7_a6 out nocopy VARCHAR2
111 , p7_a7 out nocopy VARCHAR2
112 , p7_a8 out nocopy VARCHAR2
113 );
114 end cs_tp_questions_pvt_w;