DBA Data[Home] [Help]

APPS.CSI_TRANSACTIONS_PVT_W dependencies on JTF_VARCHAR2_TABLE_100

Line 26: , a1 JTF_VARCHAR2_TABLE_100

22: return n;
23: end;
24:
25: procedure rosetta_table_copy_in_p4(t out nocopy csi_transactions_pvt.util_order_by_tbl_type, a0 JTF_NUMBER_TABLE
26: , a1 JTF_VARCHAR2_TABLE_100
27: ) as
28: ddindx binary_integer; indx binary_integer;
29: begin
30: if a0 is not null and a0.count > 0 then

Line 47: , a1 out nocopy JTF_VARCHAR2_TABLE_100

43: end if;
44: end if;
45: end rosetta_table_copy_in_p4;
46: procedure rosetta_table_copy_out_p4(t csi_transactions_pvt.util_order_by_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
47: , a1 out nocopy JTF_VARCHAR2_TABLE_100
48: ) as
49: ddindx binary_integer; indx binary_integer;
50: begin
51: if t is null or t.count = 0 then

Line 53: a1 := JTF_VARCHAR2_TABLE_100();

49: ddindx binary_integer; indx binary_integer;
50: begin
51: if t is null or t.count = 0 then
52: a0 := JTF_NUMBER_TABLE();
53: a1 := JTF_VARCHAR2_TABLE_100();
54: else
55: a0 := JTF_NUMBER_TABLE();
56: a1 := JTF_VARCHAR2_TABLE_100();
57: if t.count > 0 then

Line 56: a1 := JTF_VARCHAR2_TABLE_100();

52: a0 := JTF_NUMBER_TABLE();
53: a1 := JTF_VARCHAR2_TABLE_100();
54: else
55: a0 := JTF_NUMBER_TABLE();
56: a1 := JTF_VARCHAR2_TABLE_100();
57: if t.count > 0 then
58: a0.extend(t.count);
59: a1.extend(t.count);
60: ddindx := t.first;

Line 91: , p12_a6 out nocopy JTF_VARCHAR2_TABLE_100

87: , p12_a2 out nocopy JTF_DATE_TABLE
88: , p12_a3 out nocopy JTF_NUMBER_TABLE
89: , p12_a4 out nocopy JTF_NUMBER_TABLE
90: , p12_a5 out nocopy JTF_NUMBER_TABLE
91: , p12_a6 out nocopy JTF_VARCHAR2_TABLE_100
92: , p12_a7 out nocopy JTF_NUMBER_TABLE
93: , p12_a8 out nocopy JTF_VARCHAR2_TABLE_100
94: , p12_a9 out nocopy JTF_NUMBER_TABLE
95: , p12_a10 out nocopy JTF_VARCHAR2_TABLE_100

Line 93: , p12_a8 out nocopy JTF_VARCHAR2_TABLE_100

89: , p12_a4 out nocopy JTF_NUMBER_TABLE
90: , p12_a5 out nocopy JTF_NUMBER_TABLE
91: , p12_a6 out nocopy JTF_VARCHAR2_TABLE_100
92: , p12_a7 out nocopy JTF_NUMBER_TABLE
93: , p12_a8 out nocopy JTF_VARCHAR2_TABLE_100
94: , p12_a9 out nocopy JTF_NUMBER_TABLE
95: , p12_a10 out nocopy JTF_VARCHAR2_TABLE_100
96: , p12_a11 out nocopy JTF_NUMBER_TABLE
97: , p12_a12 out nocopy JTF_NUMBER_TABLE

Line 95: , p12_a10 out nocopy JTF_VARCHAR2_TABLE_100

91: , p12_a6 out nocopy JTF_VARCHAR2_TABLE_100
92: , p12_a7 out nocopy JTF_NUMBER_TABLE
93: , p12_a8 out nocopy JTF_VARCHAR2_TABLE_100
94: , p12_a9 out nocopy JTF_NUMBER_TABLE
95: , p12_a10 out nocopy JTF_VARCHAR2_TABLE_100
96: , p12_a11 out nocopy JTF_NUMBER_TABLE
97: , p12_a12 out nocopy JTF_NUMBER_TABLE
98: , p12_a13 out nocopy JTF_NUMBER_TABLE
99: , p12_a14 out nocopy JTF_NUMBER_TABLE

Line 100: , p12_a15 out nocopy JTF_VARCHAR2_TABLE_100

96: , p12_a11 out nocopy JTF_NUMBER_TABLE
97: , p12_a12 out nocopy JTF_NUMBER_TABLE
98: , p12_a13 out nocopy JTF_NUMBER_TABLE
99: , p12_a14 out nocopy JTF_NUMBER_TABLE
100: , p12_a15 out nocopy JTF_VARCHAR2_TABLE_100
101: , p12_a16 out nocopy JTF_NUMBER_TABLE
102: , p12_a17 out nocopy JTF_VARCHAR2_TABLE_100
103: , p12_a18 out nocopy JTF_VARCHAR2_TABLE_100
104: , p12_a19 out nocopy JTF_NUMBER_TABLE

Line 102: , p12_a17 out nocopy JTF_VARCHAR2_TABLE_100

98: , p12_a13 out nocopy JTF_NUMBER_TABLE
99: , p12_a14 out nocopy JTF_NUMBER_TABLE
100: , p12_a15 out nocopy JTF_VARCHAR2_TABLE_100
101: , p12_a16 out nocopy JTF_NUMBER_TABLE
102: , p12_a17 out nocopy JTF_VARCHAR2_TABLE_100
103: , p12_a18 out nocopy JTF_VARCHAR2_TABLE_100
104: , p12_a19 out nocopy JTF_NUMBER_TABLE
105: , p12_a20 out nocopy JTF_VARCHAR2_TABLE_100
106: , p12_a21 out nocopy JTF_VARCHAR2_TABLE_200

Line 103: , p12_a18 out nocopy JTF_VARCHAR2_TABLE_100

99: , p12_a14 out nocopy JTF_NUMBER_TABLE
100: , p12_a15 out nocopy JTF_VARCHAR2_TABLE_100
101: , p12_a16 out nocopy JTF_NUMBER_TABLE
102: , p12_a17 out nocopy JTF_VARCHAR2_TABLE_100
103: , p12_a18 out nocopy JTF_VARCHAR2_TABLE_100
104: , p12_a19 out nocopy JTF_NUMBER_TABLE
105: , p12_a20 out nocopy JTF_VARCHAR2_TABLE_100
106: , p12_a21 out nocopy JTF_VARCHAR2_TABLE_200
107: , p12_a22 out nocopy JTF_VARCHAR2_TABLE_200

Line 105: , p12_a20 out nocopy JTF_VARCHAR2_TABLE_100

101: , p12_a16 out nocopy JTF_NUMBER_TABLE
102: , p12_a17 out nocopy JTF_VARCHAR2_TABLE_100
103: , p12_a18 out nocopy JTF_VARCHAR2_TABLE_100
104: , p12_a19 out nocopy JTF_NUMBER_TABLE
105: , p12_a20 out nocopy JTF_VARCHAR2_TABLE_100
106: , p12_a21 out nocopy JTF_VARCHAR2_TABLE_200
107: , p12_a22 out nocopy JTF_VARCHAR2_TABLE_200
108: , p12_a23 out nocopy JTF_VARCHAR2_TABLE_200
109: , p12_a24 out nocopy JTF_VARCHAR2_TABLE_200

Line 122: , p12_a37 out nocopy JTF_VARCHAR2_TABLE_100

118: , p12_a33 out nocopy JTF_VARCHAR2_TABLE_200
119: , p12_a34 out nocopy JTF_VARCHAR2_TABLE_200
120: , p12_a35 out nocopy JTF_VARCHAR2_TABLE_200
121: , p12_a36 out nocopy JTF_NUMBER_TABLE
122: , p12_a37 out nocopy JTF_VARCHAR2_TABLE_100
123: , p12_a38 out nocopy JTF_NUMBER_TABLE
124: , p12_a39 out nocopy JTF_VARCHAR2_TABLE_100
125: , p12_a40 out nocopy JTF_VARCHAR2_TABLE_100
126: , p12_a41 out nocopy JTF_VARCHAR2_TABLE_100

Line 124: , p12_a39 out nocopy JTF_VARCHAR2_TABLE_100

120: , p12_a35 out nocopy JTF_VARCHAR2_TABLE_200
121: , p12_a36 out nocopy JTF_NUMBER_TABLE
122: , p12_a37 out nocopy JTF_VARCHAR2_TABLE_100
123: , p12_a38 out nocopy JTF_NUMBER_TABLE
124: , p12_a39 out nocopy JTF_VARCHAR2_TABLE_100
125: , p12_a40 out nocopy JTF_VARCHAR2_TABLE_100
126: , p12_a41 out nocopy JTF_VARCHAR2_TABLE_100
127: , p12_a42 out nocopy JTF_VARCHAR2_TABLE_300
128: , p12_a43 out nocopy JTF_VARCHAR2_TABLE_100

Line 125: , p12_a40 out nocopy JTF_VARCHAR2_TABLE_100

121: , p12_a36 out nocopy JTF_NUMBER_TABLE
122: , p12_a37 out nocopy JTF_VARCHAR2_TABLE_100
123: , p12_a38 out nocopy JTF_NUMBER_TABLE
124: , p12_a39 out nocopy JTF_VARCHAR2_TABLE_100
125: , p12_a40 out nocopy JTF_VARCHAR2_TABLE_100
126: , p12_a41 out nocopy JTF_VARCHAR2_TABLE_100
127: , p12_a42 out nocopy JTF_VARCHAR2_TABLE_300
128: , p12_a43 out nocopy JTF_VARCHAR2_TABLE_100
129: , x_returned_rec_count out nocopy NUMBER

Line 126: , p12_a41 out nocopy JTF_VARCHAR2_TABLE_100

122: , p12_a37 out nocopy JTF_VARCHAR2_TABLE_100
123: , p12_a38 out nocopy JTF_NUMBER_TABLE
124: , p12_a39 out nocopy JTF_VARCHAR2_TABLE_100
125: , p12_a40 out nocopy JTF_VARCHAR2_TABLE_100
126: , p12_a41 out nocopy JTF_VARCHAR2_TABLE_100
127: , p12_a42 out nocopy JTF_VARCHAR2_TABLE_300
128: , p12_a43 out nocopy JTF_VARCHAR2_TABLE_100
129: , x_returned_rec_count out nocopy NUMBER
130: , x_next_rec_ptr out nocopy NUMBER

Line 128: , p12_a43 out nocopy JTF_VARCHAR2_TABLE_100

124: , p12_a39 out nocopy JTF_VARCHAR2_TABLE_100
125: , p12_a40 out nocopy JTF_VARCHAR2_TABLE_100
126: , p12_a41 out nocopy JTF_VARCHAR2_TABLE_100
127: , p12_a42 out nocopy JTF_VARCHAR2_TABLE_300
128: , p12_a43 out nocopy JTF_VARCHAR2_TABLE_100
129: , x_returned_rec_count out nocopy NUMBER
130: , x_next_rec_ptr out nocopy NUMBER
131: , x_tot_rec_count out nocopy NUMBER
132: , p4_a0 NUMBER := 0-1962.0724