DBA Data[Home] [Help]

APPS.CN_ROLE_PLANS_PUB_W dependencies on JTF_VARCHAR2_TABLE_100

Line 3: procedure rosetta_table_copy_in_p1(t out nocopy cn_role_plans_pub.role_plan_rec_tbl_type, a0 JTF_VARCHAR2_TABLE_100

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

Line 5: , a2 JTF_VARCHAR2_TABLE_100

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
9: , a6 JTF_VARCHAR2_TABLE_100

Line 9: , a6 JTF_VARCHAR2_TABLE_100

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
11: , a8 JTF_VARCHAR2_TABLE_200
12: , a9 JTF_VARCHAR2_TABLE_200
13: , a10 JTF_VARCHAR2_TABLE_200

Line 68: procedure rosetta_table_copy_out_p1(t cn_role_plans_pub.role_plan_rec_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_100

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

Line 70: , a2 out nocopy JTF_VARCHAR2_TABLE_100

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
74: , a6 out nocopy JTF_VARCHAR2_TABLE_100

Line 74: , a6 out nocopy JTF_VARCHAR2_TABLE_100

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
76: , a8 out nocopy JTF_VARCHAR2_TABLE_200
77: , a9 out nocopy JTF_VARCHAR2_TABLE_200
78: , a10 out nocopy JTF_VARCHAR2_TABLE_200

Line 96: a0 := JTF_VARCHAR2_TABLE_100();

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

Line 98: a2 := JTF_VARCHAR2_TABLE_100();

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();
102: a6 := JTF_VARCHAR2_TABLE_100();

Line 102: a6 := JTF_VARCHAR2_TABLE_100();

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();
104: a8 := JTF_VARCHAR2_TABLE_200();
105: a9 := JTF_VARCHAR2_TABLE_200();
106: a10 := JTF_VARCHAR2_TABLE_200();

Line 121: a0 := JTF_VARCHAR2_TABLE_100();

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();
124: a3 := JTF_NUMBER_TABLE();
125: a4 := JTF_DATE_TABLE();

Line 123: a2 := JTF_VARCHAR2_TABLE_100();

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();
127: a6 := JTF_VARCHAR2_TABLE_100();

Line 127: a6 := JTF_VARCHAR2_TABLE_100();

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();
129: a8 := JTF_VARCHAR2_TABLE_200();
130: a9 := JTF_VARCHAR2_TABLE_200();
131: a10 := JTF_VARCHAR2_TABLE_200();