DBA Data[Home] [Help]

APPS.CN_ROLE_PLANS_PUB_W dependencies on JTF_NUMBER_TABLE

Line 4: , a1 JTF_NUMBER_TABLE

1: package body cn_role_plans_pub_w as
2: /* $Header: cnwrlplb.pls 120.2 2005/09/14 03:41 vensrini ship $ */
3: procedure rosetta_table_copy_in_p1(t out nocopy cn_role_plans_pub.role_plan_rec_tbl_type, a0 JTF_VARCHAR2_TABLE_100
4: , a1 JTF_NUMBER_TABLE
5: , a2 JTF_VARCHAR2_TABLE_100
6: , a3 JTF_NUMBER_TABLE
7: , a4 JTF_DATE_TABLE
8: , a5 JTF_DATE_TABLE

Line 6: , a3 JTF_NUMBER_TABLE

2: /* $Header: cnwrlplb.pls 120.2 2005/09/14 03:41 vensrini ship $ */
3: procedure rosetta_table_copy_in_p1(t out nocopy cn_role_plans_pub.role_plan_rec_tbl_type, a0 JTF_VARCHAR2_TABLE_100
4: , a1 JTF_NUMBER_TABLE
5: , a2 JTF_VARCHAR2_TABLE_100
6: , a3 JTF_NUMBER_TABLE
7: , a4 JTF_DATE_TABLE
8: , a5 JTF_DATE_TABLE
9: , a6 JTF_VARCHAR2_TABLE_100
10: , a7 JTF_VARCHAR2_TABLE_200

Line 25: , a22 JTF_NUMBER_TABLE

21: , a18 JTF_VARCHAR2_TABLE_200
22: , a19 JTF_VARCHAR2_TABLE_200
23: , a20 JTF_VARCHAR2_TABLE_200
24: , a21 JTF_VARCHAR2_TABLE_200
25: , a22 JTF_NUMBER_TABLE
26: , a23 JTF_NUMBER_TABLE
27: ) as
28: ddindx binary_integer; indx binary_integer;
29: begin

Line 26: , a23 JTF_NUMBER_TABLE

22: , a19 JTF_VARCHAR2_TABLE_200
23: , a20 JTF_VARCHAR2_TABLE_200
24: , a21 JTF_VARCHAR2_TABLE_200
25: , a22 JTF_NUMBER_TABLE
26: , a23 JTF_NUMBER_TABLE
27: ) as
28: ddindx binary_integer; indx binary_integer;
29: begin
30: if a0 is not null and a0.count > 0 then

Line 69: , a1 out nocopy JTF_NUMBER_TABLE

65: end if;
66: end if;
67: end rosetta_table_copy_in_p1;
68: procedure rosetta_table_copy_out_p1(t cn_role_plans_pub.role_plan_rec_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_100
69: , a1 out nocopy JTF_NUMBER_TABLE
70: , a2 out nocopy JTF_VARCHAR2_TABLE_100
71: , a3 out nocopy JTF_NUMBER_TABLE
72: , a4 out nocopy JTF_DATE_TABLE
73: , a5 out nocopy JTF_DATE_TABLE

Line 71: , a3 out nocopy JTF_NUMBER_TABLE

67: end rosetta_table_copy_in_p1;
68: procedure rosetta_table_copy_out_p1(t cn_role_plans_pub.role_plan_rec_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_100
69: , a1 out nocopy JTF_NUMBER_TABLE
70: , a2 out nocopy JTF_VARCHAR2_TABLE_100
71: , a3 out nocopy JTF_NUMBER_TABLE
72: , a4 out nocopy JTF_DATE_TABLE
73: , a5 out nocopy JTF_DATE_TABLE
74: , a6 out nocopy JTF_VARCHAR2_TABLE_100
75: , a7 out nocopy JTF_VARCHAR2_TABLE_200

Line 90: , a22 out nocopy JTF_NUMBER_TABLE

86: , a18 out nocopy JTF_VARCHAR2_TABLE_200
87: , a19 out nocopy JTF_VARCHAR2_TABLE_200
88: , a20 out nocopy JTF_VARCHAR2_TABLE_200
89: , a21 out nocopy JTF_VARCHAR2_TABLE_200
90: , a22 out nocopy JTF_NUMBER_TABLE
91: , a23 out nocopy JTF_NUMBER_TABLE
92: ) as
93: ddindx binary_integer; indx binary_integer;
94: begin

Line 91: , a23 out nocopy JTF_NUMBER_TABLE

87: , a19 out nocopy JTF_VARCHAR2_TABLE_200
88: , a20 out nocopy JTF_VARCHAR2_TABLE_200
89: , a21 out nocopy JTF_VARCHAR2_TABLE_200
90: , a22 out nocopy JTF_NUMBER_TABLE
91: , a23 out nocopy JTF_NUMBER_TABLE
92: ) as
93: ddindx binary_integer; indx binary_integer;
94: begin
95: if t is null or t.count = 0 then

Line 97: a1 := JTF_NUMBER_TABLE();

93: ddindx binary_integer; indx binary_integer;
94: begin
95: if t is null or t.count = 0 then
96: a0 := JTF_VARCHAR2_TABLE_100();
97: a1 := JTF_NUMBER_TABLE();
98: a2 := JTF_VARCHAR2_TABLE_100();
99: a3 := JTF_NUMBER_TABLE();
100: a4 := JTF_DATE_TABLE();
101: a5 := JTF_DATE_TABLE();

Line 99: a3 := JTF_NUMBER_TABLE();

95: if t is null or t.count = 0 then
96: a0 := JTF_VARCHAR2_TABLE_100();
97: a1 := JTF_NUMBER_TABLE();
98: a2 := JTF_VARCHAR2_TABLE_100();
99: a3 := JTF_NUMBER_TABLE();
100: a4 := JTF_DATE_TABLE();
101: a5 := JTF_DATE_TABLE();
102: a6 := JTF_VARCHAR2_TABLE_100();
103: a7 := JTF_VARCHAR2_TABLE_200();

Line 118: a22 := JTF_NUMBER_TABLE();

114: a18 := JTF_VARCHAR2_TABLE_200();
115: a19 := JTF_VARCHAR2_TABLE_200();
116: a20 := JTF_VARCHAR2_TABLE_200();
117: a21 := JTF_VARCHAR2_TABLE_200();
118: a22 := JTF_NUMBER_TABLE();
119: a23 := JTF_NUMBER_TABLE();
120: else
121: a0 := JTF_VARCHAR2_TABLE_100();
122: a1 := JTF_NUMBER_TABLE();

Line 119: a23 := JTF_NUMBER_TABLE();

115: a19 := JTF_VARCHAR2_TABLE_200();
116: a20 := JTF_VARCHAR2_TABLE_200();
117: a21 := JTF_VARCHAR2_TABLE_200();
118: a22 := JTF_NUMBER_TABLE();
119: a23 := JTF_NUMBER_TABLE();
120: else
121: a0 := JTF_VARCHAR2_TABLE_100();
122: a1 := JTF_NUMBER_TABLE();
123: a2 := JTF_VARCHAR2_TABLE_100();

Line 122: a1 := JTF_NUMBER_TABLE();

118: a22 := JTF_NUMBER_TABLE();
119: a23 := JTF_NUMBER_TABLE();
120: else
121: a0 := JTF_VARCHAR2_TABLE_100();
122: a1 := JTF_NUMBER_TABLE();
123: a2 := JTF_VARCHAR2_TABLE_100();
124: a3 := JTF_NUMBER_TABLE();
125: a4 := JTF_DATE_TABLE();
126: a5 := JTF_DATE_TABLE();

Line 124: a3 := JTF_NUMBER_TABLE();

120: else
121: a0 := JTF_VARCHAR2_TABLE_100();
122: a1 := JTF_NUMBER_TABLE();
123: a2 := JTF_VARCHAR2_TABLE_100();
124: a3 := JTF_NUMBER_TABLE();
125: a4 := JTF_DATE_TABLE();
126: a5 := JTF_DATE_TABLE();
127: a6 := JTF_VARCHAR2_TABLE_100();
128: a7 := JTF_VARCHAR2_TABLE_200();

Line 143: a22 := JTF_NUMBER_TABLE();

139: a18 := JTF_VARCHAR2_TABLE_200();
140: a19 := JTF_VARCHAR2_TABLE_200();
141: a20 := JTF_VARCHAR2_TABLE_200();
142: a21 := JTF_VARCHAR2_TABLE_200();
143: a22 := JTF_NUMBER_TABLE();
144: a23 := JTF_NUMBER_TABLE();
145: if t.count > 0 then
146: a0.extend(t.count);
147: a1.extend(t.count);

Line 144: a23 := JTF_NUMBER_TABLE();

140: a19 := JTF_VARCHAR2_TABLE_200();
141: a20 := JTF_VARCHAR2_TABLE_200();
142: a21 := JTF_VARCHAR2_TABLE_200();
143: a22 := JTF_NUMBER_TABLE();
144: a23 := JTF_NUMBER_TABLE();
145: if t.count > 0 then
146: a0.extend(t.count);
147: a1.extend(t.count);
148: a2.extend(t.count);