APPS.CS_TP_QUESTIONS_PVT_W dependencies on JTF_VARCHAR2_TABLE_100

Line 5: , a2 JTF_VARCHAR2_TABLE_100

1: package cs_tp_questions_pvt_w 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

Line 6: , a3 JTF_VARCHAR2_TABLE_100

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

Line 7: , a4 JTF_VARCHAR2_TABLE_100

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

Line 9: , a6 JTF_VARCHAR2_TABLE_100

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

Line 10: , a7 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

Line 11: , a8 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

Line 15: , a2 out nocopy 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

Line 16: , a3 out nocopy 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

Line 17: , a4 out nocopy JTF_VARCHAR2_TABLE_100

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

Line 19: , a6 out nocopy JTF_VARCHAR2_TABLE_100

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:

Line 20: , a7 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

Line 21: , a8 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

Line 63: , p3_a2 JTF_VARCHAR2_TABLE_100

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

Line 64: , p3_a3 JTF_VARCHAR2_TABLE_100

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

Line 65: , p3_a4 JTF_VARCHAR2_TABLE_100

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

Line 67: , p3_a6 JTF_VARCHAR2_TABLE_100

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

Line 68: , p3_a7 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

Line 69: , p3_a8 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

Line 87: , p10_a2 out nocopy JTF_VARCHAR2_TABLE_100

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

Line 88: , p10_a3 out nocopy JTF_VARCHAR2_TABLE_100

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

Line 89: , p10_a4 out nocopy JTF_VARCHAR2_TABLE_100

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

Line 91: , p10_a6 out nocopy JTF_VARCHAR2_TABLE_100

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

Line 92: , p10_a7 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: );

Line 93: , p10_a8 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