eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.CS_TP_QUESTIONS_PVT_W dependencies on JTF_VARCHAR2_TABLE_100

Line 24: , a2 JTF_VARCHAR2_TABLE_100

20: end;
21:
22: procedure rosetta_table_copy_in_p1(t out nocopy cs_tp_questions_pvt.question_list, a0 JTF_NUMBER_TABLE
23: , a1 JTF_VARCHAR2_TABLE_2000
24: , a2 JTF_VARCHAR2_TABLE_100
25: , a3 JTF_VARCHAR2_TABLE_100
26: , a4 JTF_VARCHAR2_TABLE_100
27: , a5 JTF_NUMBER_TABLE
28: , a6 JTF_VARCHAR2_TABLE_100

Line 25: , a3 JTF_VARCHAR2_TABLE_100

21:
22: procedure rosetta_table_copy_in_p1(t out nocopy cs_tp_questions_pvt.question_list, a0 JTF_NUMBER_TABLE
23: , a1 JTF_VARCHAR2_TABLE_2000
24: , a2 JTF_VARCHAR2_TABLE_100
25: , a3 JTF_VARCHAR2_TABLE_100
26: , a4 JTF_VARCHAR2_TABLE_100
27: , a5 JTF_NUMBER_TABLE
28: , a6 JTF_VARCHAR2_TABLE_100
29: , a7 JTF_VARCHAR2_TABLE_100

Line 26: , a4 JTF_VARCHAR2_TABLE_100

22: procedure rosetta_table_copy_in_p1(t out nocopy cs_tp_questions_pvt.question_list, a0 JTF_NUMBER_TABLE
23: , a1 JTF_VARCHAR2_TABLE_2000
24: , a2 JTF_VARCHAR2_TABLE_100
25: , a3 JTF_VARCHAR2_TABLE_100
26: , a4 JTF_VARCHAR2_TABLE_100
27: , a5 JTF_NUMBER_TABLE
28: , a6 JTF_VARCHAR2_TABLE_100
29: , a7 JTF_VARCHAR2_TABLE_100
30: , a8 JTF_VARCHAR2_TABLE_100

Line 28: , a6 JTF_VARCHAR2_TABLE_100

24: , a2 JTF_VARCHAR2_TABLE_100
25: , a3 JTF_VARCHAR2_TABLE_100
26: , a4 JTF_VARCHAR2_TABLE_100
27: , a5 JTF_NUMBER_TABLE
28: , a6 JTF_VARCHAR2_TABLE_100
29: , a7 JTF_VARCHAR2_TABLE_100
30: , a8 JTF_VARCHAR2_TABLE_100
31: ) as
32: ddindx binary_integer; indx binary_integer;

Line 29: , a7 JTF_VARCHAR2_TABLE_100

25: , a3 JTF_VARCHAR2_TABLE_100
26: , a4 JTF_VARCHAR2_TABLE_100
27: , a5 JTF_NUMBER_TABLE
28: , a6 JTF_VARCHAR2_TABLE_100
29: , a7 JTF_VARCHAR2_TABLE_100
30: , a8 JTF_VARCHAR2_TABLE_100
31: ) as
32: ddindx binary_integer; indx binary_integer;
33: begin

Line 30: , a8 JTF_VARCHAR2_TABLE_100

26: , a4 JTF_VARCHAR2_TABLE_100
27: , a5 JTF_NUMBER_TABLE
28: , a6 JTF_VARCHAR2_TABLE_100
29: , a7 JTF_VARCHAR2_TABLE_100
30: , a8 JTF_VARCHAR2_TABLE_100
31: ) as
32: ddindx binary_integer; indx binary_integer;
33: begin
34: if a0 is not null and a0.count > 0 then

Line 59: , a2 out nocopy JTF_VARCHAR2_TABLE_100

55: end if;
56: end rosetta_table_copy_in_p1;
57: procedure rosetta_table_copy_out_p1(t cs_tp_questions_pvt.question_list, a0 out nocopy JTF_NUMBER_TABLE
58: , a1 out nocopy JTF_VARCHAR2_TABLE_2000
59: , a2 out nocopy JTF_VARCHAR2_TABLE_100
60: , a3 out nocopy JTF_VARCHAR2_TABLE_100
61: , a4 out nocopy JTF_VARCHAR2_TABLE_100
62: , a5 out nocopy JTF_NUMBER_TABLE
63: , a6 out nocopy JTF_VARCHAR2_TABLE_100

Line 60: , a3 out nocopy JTF_VARCHAR2_TABLE_100

56: end rosetta_table_copy_in_p1;
57: procedure rosetta_table_copy_out_p1(t cs_tp_questions_pvt.question_list, a0 out nocopy JTF_NUMBER_TABLE
58: , a1 out nocopy JTF_VARCHAR2_TABLE_2000
59: , a2 out nocopy JTF_VARCHAR2_TABLE_100
60: , a3 out nocopy JTF_VARCHAR2_TABLE_100
61: , a4 out nocopy JTF_VARCHAR2_TABLE_100
62: , a5 out nocopy JTF_NUMBER_TABLE
63: , a6 out nocopy JTF_VARCHAR2_TABLE_100
64: , a7 out nocopy JTF_VARCHAR2_TABLE_100

Line 61: , a4 out nocopy JTF_VARCHAR2_TABLE_100

57: procedure rosetta_table_copy_out_p1(t cs_tp_questions_pvt.question_list, a0 out nocopy JTF_NUMBER_TABLE
58: , a1 out nocopy JTF_VARCHAR2_TABLE_2000
59: , a2 out nocopy JTF_VARCHAR2_TABLE_100
60: , a3 out nocopy JTF_VARCHAR2_TABLE_100
61: , a4 out nocopy JTF_VARCHAR2_TABLE_100
62: , a5 out nocopy JTF_NUMBER_TABLE
63: , a6 out nocopy JTF_VARCHAR2_TABLE_100
64: , a7 out nocopy JTF_VARCHAR2_TABLE_100
65: , a8 out nocopy JTF_VARCHAR2_TABLE_100

Line 63: , a6 out nocopy JTF_VARCHAR2_TABLE_100

59: , a2 out nocopy JTF_VARCHAR2_TABLE_100
60: , a3 out nocopy JTF_VARCHAR2_TABLE_100
61: , a4 out nocopy JTF_VARCHAR2_TABLE_100
62: , a5 out nocopy JTF_NUMBER_TABLE
63: , a6 out nocopy JTF_VARCHAR2_TABLE_100
64: , a7 out nocopy JTF_VARCHAR2_TABLE_100
65: , a8 out nocopy JTF_VARCHAR2_TABLE_100
66: ) as
67: ddindx binary_integer; indx binary_integer;

Line 64: , a7 out nocopy JTF_VARCHAR2_TABLE_100

60: , a3 out nocopy JTF_VARCHAR2_TABLE_100
61: , a4 out nocopy JTF_VARCHAR2_TABLE_100
62: , a5 out nocopy JTF_NUMBER_TABLE
63: , a6 out nocopy JTF_VARCHAR2_TABLE_100
64: , a7 out nocopy JTF_VARCHAR2_TABLE_100
65: , a8 out nocopy JTF_VARCHAR2_TABLE_100
66: ) as
67: ddindx binary_integer; indx binary_integer;
68: begin

Line 65: , a8 out nocopy JTF_VARCHAR2_TABLE_100

61: , a4 out nocopy JTF_VARCHAR2_TABLE_100
62: , a5 out nocopy JTF_NUMBER_TABLE
63: , a6 out nocopy JTF_VARCHAR2_TABLE_100
64: , a7 out nocopy JTF_VARCHAR2_TABLE_100
65: , a8 out nocopy JTF_VARCHAR2_TABLE_100
66: ) as
67: ddindx binary_integer; indx binary_integer;
68: begin
69: if t is null or t.count = 0 then

Line 72: a2 := JTF_VARCHAR2_TABLE_100();

68: begin
69: if t is null or t.count = 0 then
70: a0 := JTF_NUMBER_TABLE();
71: a1 := JTF_VARCHAR2_TABLE_2000();
72: a2 := JTF_VARCHAR2_TABLE_100();
73: a3 := JTF_VARCHAR2_TABLE_100();
74: a4 := JTF_VARCHAR2_TABLE_100();
75: a5 := JTF_NUMBER_TABLE();
76: a6 := JTF_VARCHAR2_TABLE_100();

Line 73: a3 := JTF_VARCHAR2_TABLE_100();

69: if t is null or t.count = 0 then
70: a0 := JTF_NUMBER_TABLE();
71: a1 := JTF_VARCHAR2_TABLE_2000();
72: a2 := JTF_VARCHAR2_TABLE_100();
73: a3 := JTF_VARCHAR2_TABLE_100();
74: a4 := JTF_VARCHAR2_TABLE_100();
75: a5 := JTF_NUMBER_TABLE();
76: a6 := JTF_VARCHAR2_TABLE_100();
77: a7 := JTF_VARCHAR2_TABLE_100();

Line 74: a4 := JTF_VARCHAR2_TABLE_100();

70: a0 := JTF_NUMBER_TABLE();
71: a1 := JTF_VARCHAR2_TABLE_2000();
72: a2 := JTF_VARCHAR2_TABLE_100();
73: a3 := JTF_VARCHAR2_TABLE_100();
74: a4 := JTF_VARCHAR2_TABLE_100();
75: a5 := JTF_NUMBER_TABLE();
76: a6 := JTF_VARCHAR2_TABLE_100();
77: a7 := JTF_VARCHAR2_TABLE_100();
78: a8 := JTF_VARCHAR2_TABLE_100();

Line 76: a6 := JTF_VARCHAR2_TABLE_100();

72: a2 := JTF_VARCHAR2_TABLE_100();
73: a3 := JTF_VARCHAR2_TABLE_100();
74: a4 := JTF_VARCHAR2_TABLE_100();
75: a5 := JTF_NUMBER_TABLE();
76: a6 := JTF_VARCHAR2_TABLE_100();
77: a7 := JTF_VARCHAR2_TABLE_100();
78: a8 := JTF_VARCHAR2_TABLE_100();
79: else
80: a0 := JTF_NUMBER_TABLE();

Line 77: a7 := JTF_VARCHAR2_TABLE_100();

73: a3 := JTF_VARCHAR2_TABLE_100();
74: a4 := JTF_VARCHAR2_TABLE_100();
75: a5 := JTF_NUMBER_TABLE();
76: a6 := JTF_VARCHAR2_TABLE_100();
77: a7 := JTF_VARCHAR2_TABLE_100();
78: a8 := JTF_VARCHAR2_TABLE_100();
79: else
80: a0 := JTF_NUMBER_TABLE();
81: a1 := JTF_VARCHAR2_TABLE_2000();

Line 78: a8 := JTF_VARCHAR2_TABLE_100();

74: a4 := JTF_VARCHAR2_TABLE_100();
75: a5 := JTF_NUMBER_TABLE();
76: a6 := JTF_VARCHAR2_TABLE_100();
77: a7 := JTF_VARCHAR2_TABLE_100();
78: a8 := JTF_VARCHAR2_TABLE_100();
79: else
80: a0 := JTF_NUMBER_TABLE();
81: a1 := JTF_VARCHAR2_TABLE_2000();
82: a2 := JTF_VARCHAR2_TABLE_100();

Line 82: a2 := JTF_VARCHAR2_TABLE_100();

78: a8 := JTF_VARCHAR2_TABLE_100();
79: else
80: a0 := JTF_NUMBER_TABLE();
81: a1 := JTF_VARCHAR2_TABLE_2000();
82: a2 := JTF_VARCHAR2_TABLE_100();
83: a3 := JTF_VARCHAR2_TABLE_100();
84: a4 := JTF_VARCHAR2_TABLE_100();
85: a5 := JTF_NUMBER_TABLE();
86: a6 := JTF_VARCHAR2_TABLE_100();

Line 83: a3 := JTF_VARCHAR2_TABLE_100();

79: else
80: a0 := JTF_NUMBER_TABLE();
81: a1 := JTF_VARCHAR2_TABLE_2000();
82: a2 := JTF_VARCHAR2_TABLE_100();
83: a3 := JTF_VARCHAR2_TABLE_100();
84: a4 := JTF_VARCHAR2_TABLE_100();
85: a5 := JTF_NUMBER_TABLE();
86: a6 := JTF_VARCHAR2_TABLE_100();
87: a7 := JTF_VARCHAR2_TABLE_100();

Line 84: a4 := JTF_VARCHAR2_TABLE_100();

80: a0 := JTF_NUMBER_TABLE();
81: a1 := JTF_VARCHAR2_TABLE_2000();
82: a2 := JTF_VARCHAR2_TABLE_100();
83: a3 := JTF_VARCHAR2_TABLE_100();
84: a4 := JTF_VARCHAR2_TABLE_100();
85: a5 := JTF_NUMBER_TABLE();
86: a6 := JTF_VARCHAR2_TABLE_100();
87: a7 := JTF_VARCHAR2_TABLE_100();
88: a8 := JTF_VARCHAR2_TABLE_100();

Line 86: a6 := JTF_VARCHAR2_TABLE_100();

82: a2 := JTF_VARCHAR2_TABLE_100();
83: a3 := JTF_VARCHAR2_TABLE_100();
84: a4 := JTF_VARCHAR2_TABLE_100();
85: a5 := JTF_NUMBER_TABLE();
86: a6 := JTF_VARCHAR2_TABLE_100();
87: a7 := JTF_VARCHAR2_TABLE_100();
88: a8 := JTF_VARCHAR2_TABLE_100();
89: if t.count > 0 then
90: a0.extend(t.count);

Line 87: a7 := JTF_VARCHAR2_TABLE_100();

83: a3 := JTF_VARCHAR2_TABLE_100();
84: a4 := JTF_VARCHAR2_TABLE_100();
85: a5 := JTF_NUMBER_TABLE();
86: a6 := JTF_VARCHAR2_TABLE_100();
87: a7 := JTF_VARCHAR2_TABLE_100();
88: a8 := JTF_VARCHAR2_TABLE_100();
89: if t.count > 0 then
90: a0.extend(t.count);
91: a1.extend(t.count);

Line 88: a8 := JTF_VARCHAR2_TABLE_100();

84: a4 := JTF_VARCHAR2_TABLE_100();
85: a5 := JTF_NUMBER_TABLE();
86: a6 := JTF_VARCHAR2_TABLE_100();
87: a7 := JTF_VARCHAR2_TABLE_100();
88: a8 := JTF_VARCHAR2_TABLE_100();
89: if t.count > 0 then
90: a0.extend(t.count);
91: a1.extend(t.count);
92: a2.extend(t.count);

Line 248: , p3_a2 JTF_VARCHAR2_TABLE_100

244: , p_init_msg_list VARCHAR2
245: , p_commit VARCHAR
246: , p3_a0 JTF_NUMBER_TABLE
247: , p3_a1 JTF_VARCHAR2_TABLE_2000
248: , p3_a2 JTF_VARCHAR2_TABLE_100
249: , p3_a3 JTF_VARCHAR2_TABLE_100
250: , p3_a4 JTF_VARCHAR2_TABLE_100
251: , p3_a5 JTF_NUMBER_TABLE
252: , p3_a6 JTF_VARCHAR2_TABLE_100

Line 249: , p3_a3 JTF_VARCHAR2_TABLE_100

245: , p_commit VARCHAR
246: , p3_a0 JTF_NUMBER_TABLE
247: , p3_a1 JTF_VARCHAR2_TABLE_2000
248: , p3_a2 JTF_VARCHAR2_TABLE_100
249: , p3_a3 JTF_VARCHAR2_TABLE_100
250: , p3_a4 JTF_VARCHAR2_TABLE_100
251: , p3_a5 JTF_NUMBER_TABLE
252: , p3_a6 JTF_VARCHAR2_TABLE_100
253: , p3_a7 JTF_VARCHAR2_TABLE_100

Line 250: , p3_a4 JTF_VARCHAR2_TABLE_100

246: , p3_a0 JTF_NUMBER_TABLE
247: , p3_a1 JTF_VARCHAR2_TABLE_2000
248: , p3_a2 JTF_VARCHAR2_TABLE_100
249: , p3_a3 JTF_VARCHAR2_TABLE_100
250: , p3_a4 JTF_VARCHAR2_TABLE_100
251: , p3_a5 JTF_NUMBER_TABLE
252: , p3_a6 JTF_VARCHAR2_TABLE_100
253: , p3_a7 JTF_VARCHAR2_TABLE_100
254: , p3_a8 JTF_VARCHAR2_TABLE_100

Line 252: , p3_a6 JTF_VARCHAR2_TABLE_100

248: , p3_a2 JTF_VARCHAR2_TABLE_100
249: , p3_a3 JTF_VARCHAR2_TABLE_100
250: , p3_a4 JTF_VARCHAR2_TABLE_100
251: , p3_a5 JTF_NUMBER_TABLE
252: , p3_a6 JTF_VARCHAR2_TABLE_100
253: , p3_a7 JTF_VARCHAR2_TABLE_100
254: , p3_a8 JTF_VARCHAR2_TABLE_100
255: , p_template_id NUMBER
256: , x_msg_count out nocopy NUMBER

Line 253: , p3_a7 JTF_VARCHAR2_TABLE_100

249: , p3_a3 JTF_VARCHAR2_TABLE_100
250: , p3_a4 JTF_VARCHAR2_TABLE_100
251: , p3_a5 JTF_NUMBER_TABLE
252: , p3_a6 JTF_VARCHAR2_TABLE_100
253: , p3_a7 JTF_VARCHAR2_TABLE_100
254: , p3_a8 JTF_VARCHAR2_TABLE_100
255: , p_template_id NUMBER
256: , x_msg_count out nocopy NUMBER
257: , x_msg_data out nocopy VARCHAR2

Line 254: , p3_a8 JTF_VARCHAR2_TABLE_100

250: , p3_a4 JTF_VARCHAR2_TABLE_100
251: , p3_a5 JTF_NUMBER_TABLE
252: , p3_a6 JTF_VARCHAR2_TABLE_100
253: , p3_a7 JTF_VARCHAR2_TABLE_100
254: , p3_a8 JTF_VARCHAR2_TABLE_100
255: , p_template_id NUMBER
256: , x_msg_count out nocopy NUMBER
257: , x_msg_data out nocopy VARCHAR2
258: , x_return_status out nocopy VARCHAR2

Line 317: , p10_a2 out nocopy JTF_VARCHAR2_TABLE_100

313: , x_msg_data out nocopy VARCHAR2
314: , x_return_status out nocopy VARCHAR2
315: , p10_a0 out nocopy JTF_NUMBER_TABLE
316: , p10_a1 out nocopy JTF_VARCHAR2_TABLE_2000
317: , p10_a2 out nocopy JTF_VARCHAR2_TABLE_100
318: , p10_a3 out nocopy JTF_VARCHAR2_TABLE_100
319: , p10_a4 out nocopy JTF_VARCHAR2_TABLE_100
320: , p10_a5 out nocopy JTF_NUMBER_TABLE
321: , p10_a6 out nocopy JTF_VARCHAR2_TABLE_100

Line 318: , p10_a3 out nocopy JTF_VARCHAR2_TABLE_100

314: , x_return_status out nocopy VARCHAR2
315: , p10_a0 out nocopy JTF_NUMBER_TABLE
316: , p10_a1 out nocopy JTF_VARCHAR2_TABLE_2000
317: , p10_a2 out nocopy JTF_VARCHAR2_TABLE_100
318: , p10_a3 out nocopy JTF_VARCHAR2_TABLE_100
319: , p10_a4 out nocopy JTF_VARCHAR2_TABLE_100
320: , p10_a5 out nocopy JTF_NUMBER_TABLE
321: , p10_a6 out nocopy JTF_VARCHAR2_TABLE_100
322: , p10_a7 out nocopy JTF_VARCHAR2_TABLE_100

Line 319: , p10_a4 out nocopy JTF_VARCHAR2_TABLE_100

315: , p10_a0 out nocopy JTF_NUMBER_TABLE
316: , p10_a1 out nocopy JTF_VARCHAR2_TABLE_2000
317: , p10_a2 out nocopy JTF_VARCHAR2_TABLE_100
318: , p10_a3 out nocopy JTF_VARCHAR2_TABLE_100
319: , p10_a4 out nocopy JTF_VARCHAR2_TABLE_100
320: , p10_a5 out nocopy JTF_NUMBER_TABLE
321: , p10_a6 out nocopy JTF_VARCHAR2_TABLE_100
322: , p10_a7 out nocopy JTF_VARCHAR2_TABLE_100
323: , p10_a8 out nocopy JTF_VARCHAR2_TABLE_100

Line 321: , p10_a6 out nocopy JTF_VARCHAR2_TABLE_100

317: , p10_a2 out nocopy JTF_VARCHAR2_TABLE_100
318: , p10_a3 out nocopy JTF_VARCHAR2_TABLE_100
319: , p10_a4 out nocopy JTF_VARCHAR2_TABLE_100
320: , p10_a5 out nocopy JTF_NUMBER_TABLE
321: , p10_a6 out nocopy JTF_VARCHAR2_TABLE_100
322: , p10_a7 out nocopy JTF_VARCHAR2_TABLE_100
323: , p10_a8 out nocopy JTF_VARCHAR2_TABLE_100
324: , x_total_questions out nocopy NUMBER
325: , x_retrieved_question_number out nocopy NUMBER

Line 322: , p10_a7 out nocopy JTF_VARCHAR2_TABLE_100

318: , p10_a3 out nocopy JTF_VARCHAR2_TABLE_100
319: , p10_a4 out nocopy JTF_VARCHAR2_TABLE_100
320: , p10_a5 out nocopy JTF_NUMBER_TABLE
321: , p10_a6 out nocopy JTF_VARCHAR2_TABLE_100
322: , p10_a7 out nocopy JTF_VARCHAR2_TABLE_100
323: , p10_a8 out nocopy JTF_VARCHAR2_TABLE_100
324: , x_total_questions out nocopy NUMBER
325: , x_retrieved_question_number out nocopy NUMBER
326: )

Line 323: , p10_a8 out nocopy JTF_VARCHAR2_TABLE_100

319: , p10_a4 out nocopy JTF_VARCHAR2_TABLE_100
320: , p10_a5 out nocopy JTF_NUMBER_TABLE
321: , p10_a6 out nocopy JTF_VARCHAR2_TABLE_100
322: , p10_a7 out nocopy JTF_VARCHAR2_TABLE_100
323: , p10_a8 out nocopy JTF_VARCHAR2_TABLE_100
324: , x_total_questions out nocopy NUMBER
325: , x_retrieved_question_number out nocopy NUMBER
326: )
327: