DBA Data[Home] [Help]

APPS.OZF_APPROVAL_PVT_OAW dependencies on JTF_VARCHAR2_TABLE_100

Line 3: procedure rosetta_table_copy_in_p1(t out nocopy ozf_approval_pvt.action_tbl_type, a0 JTF_VARCHAR2_TABLE_100

1: package body ozf_approval_pvt_oaw as
2: /* $Header: ozfaappb.pls 115.1 2003/12/10 16:03:42 feliu noship $ */
3: procedure rosetta_table_copy_in_p1(t out nocopy ozf_approval_pvt.action_tbl_type, a0 JTF_VARCHAR2_TABLE_100
4: , a1 JTF_NUMBER_TABLE
5: , a2 JTF_VARCHAR2_TABLE_100
6: , a3 JTF_VARCHAR2_TABLE_100
7: , a4 JTF_NUMBER_TABLE

Line 5: , a2 JTF_VARCHAR2_TABLE_100

1: package body ozf_approval_pvt_oaw as
2: /* $Header: ozfaappb.pls 115.1 2003/12/10 16:03:42 feliu noship $ */
3: procedure rosetta_table_copy_in_p1(t out nocopy ozf_approval_pvt.action_tbl_type, a0 JTF_VARCHAR2_TABLE_100
4: , a1 JTF_NUMBER_TABLE
5: , a2 JTF_VARCHAR2_TABLE_100
6: , a3 JTF_VARCHAR2_TABLE_100
7: , a4 JTF_NUMBER_TABLE
8: ) as
9: ddindx binary_integer; indx binary_integer;

Line 6: , a3 JTF_VARCHAR2_TABLE_100

2: /* $Header: ozfaappb.pls 115.1 2003/12/10 16:03:42 feliu noship $ */
3: procedure rosetta_table_copy_in_p1(t out nocopy ozf_approval_pvt.action_tbl_type, a0 JTF_VARCHAR2_TABLE_100
4: , a1 JTF_NUMBER_TABLE
5: , a2 JTF_VARCHAR2_TABLE_100
6: , a3 JTF_VARCHAR2_TABLE_100
7: , a4 JTF_NUMBER_TABLE
8: ) as
9: ddindx binary_integer; indx binary_integer;
10: begin

Line 34: procedure rosetta_table_copy_out_p1(t ozf_approval_pvt.action_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_100

30: end loop;
31: end if;
32: end if;
33: end rosetta_table_copy_in_p1;
34: procedure rosetta_table_copy_out_p1(t ozf_approval_pvt.action_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_100
35: , a1 out nocopy JTF_NUMBER_TABLE
36: , a2 out nocopy JTF_VARCHAR2_TABLE_100
37: , a3 out nocopy JTF_VARCHAR2_TABLE_100
38: , a4 out nocopy JTF_NUMBER_TABLE

Line 36: , a2 out nocopy JTF_VARCHAR2_TABLE_100

32: end if;
33: end rosetta_table_copy_in_p1;
34: procedure rosetta_table_copy_out_p1(t ozf_approval_pvt.action_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_100
35: , a1 out nocopy JTF_NUMBER_TABLE
36: , a2 out nocopy JTF_VARCHAR2_TABLE_100
37: , a3 out nocopy JTF_VARCHAR2_TABLE_100
38: , a4 out nocopy JTF_NUMBER_TABLE
39: ) as
40: ddindx binary_integer; indx binary_integer;

Line 37: , a3 out nocopy JTF_VARCHAR2_TABLE_100

33: end rosetta_table_copy_in_p1;
34: procedure rosetta_table_copy_out_p1(t ozf_approval_pvt.action_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_100
35: , a1 out nocopy JTF_NUMBER_TABLE
36: , a2 out nocopy JTF_VARCHAR2_TABLE_100
37: , a3 out nocopy JTF_VARCHAR2_TABLE_100
38: , a4 out nocopy JTF_NUMBER_TABLE
39: ) as
40: ddindx binary_integer; indx binary_integer;
41: begin

Line 49: a0 := JTF_VARCHAR2_TABLE_100();

45: a2 := null;
46: a3 := null;
47: a4 := null;
48: elsif t.count = 0 then
49: a0 := JTF_VARCHAR2_TABLE_100();
50: a1 := JTF_NUMBER_TABLE();
51: a2 := JTF_VARCHAR2_TABLE_100();
52: a3 := JTF_VARCHAR2_TABLE_100();
53: a4 := JTF_NUMBER_TABLE();

Line 51: a2 := JTF_VARCHAR2_TABLE_100();

47: a4 := null;
48: elsif t.count = 0 then
49: a0 := JTF_VARCHAR2_TABLE_100();
50: a1 := JTF_NUMBER_TABLE();
51: a2 := JTF_VARCHAR2_TABLE_100();
52: a3 := JTF_VARCHAR2_TABLE_100();
53: a4 := JTF_NUMBER_TABLE();
54: else
55: a0 := JTF_VARCHAR2_TABLE_100();

Line 52: a3 := JTF_VARCHAR2_TABLE_100();

48: elsif t.count = 0 then
49: a0 := JTF_VARCHAR2_TABLE_100();
50: a1 := JTF_NUMBER_TABLE();
51: a2 := JTF_VARCHAR2_TABLE_100();
52: a3 := JTF_VARCHAR2_TABLE_100();
53: a4 := JTF_NUMBER_TABLE();
54: else
55: a0 := JTF_VARCHAR2_TABLE_100();
56: a1 := JTF_NUMBER_TABLE();

Line 55: a0 := JTF_VARCHAR2_TABLE_100();

51: a2 := JTF_VARCHAR2_TABLE_100();
52: a3 := JTF_VARCHAR2_TABLE_100();
53: a4 := JTF_NUMBER_TABLE();
54: else
55: a0 := JTF_VARCHAR2_TABLE_100();
56: a1 := JTF_NUMBER_TABLE();
57: a2 := JTF_VARCHAR2_TABLE_100();
58: a3 := JTF_VARCHAR2_TABLE_100();
59: a4 := JTF_NUMBER_TABLE();

Line 57: a2 := JTF_VARCHAR2_TABLE_100();

53: a4 := JTF_NUMBER_TABLE();
54: else
55: a0 := JTF_VARCHAR2_TABLE_100();
56: a1 := JTF_NUMBER_TABLE();
57: a2 := JTF_VARCHAR2_TABLE_100();
58: a3 := JTF_VARCHAR2_TABLE_100();
59: a4 := JTF_NUMBER_TABLE();
60: if t.count > 0 then
61: a0.extend(t.count);

Line 58: a3 := JTF_VARCHAR2_TABLE_100();

54: else
55: a0 := JTF_VARCHAR2_TABLE_100();
56: a1 := JTF_NUMBER_TABLE();
57: a2 := JTF_VARCHAR2_TABLE_100();
58: a3 := JTF_VARCHAR2_TABLE_100();
59: a4 := JTF_NUMBER_TABLE();
60: if t.count > 0 then
61: a0.extend(t.count);
62: a1.extend(t.count);

Line 84: procedure rosetta_table_copy_in_p3(t out nocopy ozf_approval_pvt.approvers_tbl_type, a0 JTF_VARCHAR2_TABLE_100

80: end if;
81: end if;
82: end rosetta_table_copy_out_p1;
83:
84: procedure rosetta_table_copy_in_p3(t out nocopy ozf_approval_pvt.approvers_tbl_type, a0 JTF_VARCHAR2_TABLE_100
85: , a1 JTF_NUMBER_TABLE
86: , a2 JTF_NUMBER_TABLE
87: ) as
88: ddindx binary_integer; indx binary_integer;

Line 111: procedure rosetta_table_copy_out_p3(t ozf_approval_pvt.approvers_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_100

107: end loop;
108: end if;
109: end if;
110: end rosetta_table_copy_in_p3;
111: procedure rosetta_table_copy_out_p3(t ozf_approval_pvt.approvers_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_100
112: , a1 out nocopy JTF_NUMBER_TABLE
113: , a2 out nocopy JTF_NUMBER_TABLE
114: ) as
115: ddindx binary_integer; indx binary_integer;

Line 122: a0 := JTF_VARCHAR2_TABLE_100();

118: a0 := null;
119: a1 := null;
120: a2 := null;
121: elsif t.count = 0 then
122: a0 := JTF_VARCHAR2_TABLE_100();
123: a1 := JTF_NUMBER_TABLE();
124: a2 := JTF_NUMBER_TABLE();
125: else
126: a0 := JTF_VARCHAR2_TABLE_100();

Line 126: a0 := JTF_VARCHAR2_TABLE_100();

122: a0 := JTF_VARCHAR2_TABLE_100();
123: a1 := JTF_NUMBER_TABLE();
124: a2 := JTF_NUMBER_TABLE();
125: else
126: a0 := JTF_VARCHAR2_TABLE_100();
127: a1 := JTF_NUMBER_TABLE();
128: a2 := JTF_NUMBER_TABLE();
129: if t.count > 0 then
130: a0.extend(t.count);

Line 209: , p7_a0 out nocopy JTF_VARCHAR2_TABLE_100

205: , p6_a1 NUMBER
206: , p6_a2 VARCHAR2
207: , p6_a3 VARCHAR2
208: , p6_a4 NUMBER
209: , p7_a0 out nocopy JTF_VARCHAR2_TABLE_100
210: , p7_a1 out nocopy JTF_NUMBER_TABLE
211: , p7_a2 out nocopy JTF_NUMBER_TABLE
212: , x_final_approval_flag out nocopy VARCHAR2
213: )

Line 274: , p8_a0 JTF_VARCHAR2_TABLE_100

270: , p7_a1 NUMBER
271: , p7_a2 VARCHAR2
272: , p7_a3 VARCHAR2
273: , p7_a4 NUMBER
274: , p8_a0 JTF_VARCHAR2_TABLE_100
275: , p8_a1 JTF_NUMBER_TABLE
276: , p8_a2 JTF_NUMBER_TABLE
277: )
278: