DBA Data[Home] [Help]

APPS.CSI_TRANSACTIONS_PVT_W dependencies on JTF_NUMBER_TABLE

Line 25: procedure rosetta_table_copy_in_p4(t out nocopy csi_transactions_pvt.util_order_by_tbl_type, a0 JTF_NUMBER_TABLE

21: if n=b then return a; end if;
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

Line 46: procedure rosetta_table_copy_out_p4(t csi_transactions_pvt.util_order_by_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

42: end loop;
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

Line 52: a0 := JTF_NUMBER_TABLE();

48: ) as
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();

Line 55: a0 := JTF_NUMBER_TABLE();

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
58: a0.extend(t.count);
59: a1.extend(t.count);

Line 85: , p12_a0 out nocopy JTF_NUMBER_TABLE

81: , p_return_tot_count VARCHAR2
82: , x_return_status out nocopy VARCHAR2
83: , x_msg_count out nocopy NUMBER
84: , x_msg_data out nocopy VARCHAR2
85: , p12_a0 out nocopy JTF_NUMBER_TABLE
86: , p12_a1 out nocopy JTF_DATE_TABLE
87: , p12_a2 out nocopy JTF_DATE_TABLE
88: , p12_a3 out nocopy JTF_NUMBER_TABLE
89: , p12_a4 out nocopy JTF_NUMBER_TABLE

Line 88: , p12_a3 out nocopy JTF_NUMBER_TABLE

84: , x_msg_data out nocopy VARCHAR2
85: , p12_a0 out nocopy JTF_NUMBER_TABLE
86: , p12_a1 out nocopy JTF_DATE_TABLE
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

Line 89: , p12_a4 out nocopy JTF_NUMBER_TABLE

85: , p12_a0 out nocopy JTF_NUMBER_TABLE
86: , p12_a1 out nocopy JTF_DATE_TABLE
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

Line 90: , p12_a5 out nocopy JTF_NUMBER_TABLE

86: , p12_a1 out nocopy JTF_DATE_TABLE
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

Line 92: , p12_a7 out nocopy JTF_NUMBER_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
96: , p12_a11 out nocopy JTF_NUMBER_TABLE

Line 94: , p12_a9 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
98: , p12_a13 out nocopy JTF_NUMBER_TABLE

Line 96: , p12_a11 out nocopy JTF_NUMBER_TABLE

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
100: , p12_a15 out nocopy JTF_VARCHAR2_TABLE_100

Line 97: , p12_a12 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
100: , p12_a15 out nocopy JTF_VARCHAR2_TABLE_100
101: , p12_a16 out nocopy JTF_NUMBER_TABLE

Line 98: , p12_a13 out nocopy JTF_NUMBER_TABLE

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
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

Line 99: , p12_a14 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
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

Line 101: , p12_a16 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
105: , p12_a20 out nocopy JTF_VARCHAR2_TABLE_100

Line 104: , p12_a19 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
108: , p12_a23 out nocopy JTF_VARCHAR2_TABLE_200

Line 121: , p12_a36 out nocopy JTF_NUMBER_TABLE

117: , p12_a32 out nocopy JTF_VARCHAR2_TABLE_200
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

Line 123: , p12_a38 out nocopy JTF_NUMBER_TABLE

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
127: , p12_a42 out nocopy JTF_VARCHAR2_TABLE_300