DBA Data[Home] [Help]

APPS.CN_ACC_PERIODS_PVT_W dependencies on JTF_VARCHAR2_TABLE_100

Line 3: procedure rosetta_table_copy_in_p1(t out nocopy cn_acc_periods_pvt.acc_period_tbl_type, a0 JTF_VARCHAR2_TABLE_100

1: package body cn_acc_periods_pvt_w as
2: /* $Header: cnwsyprb.pls 120.1 2005/09/14 03:43 vensrini noship $ */
3: procedure rosetta_table_copy_in_p1(t out nocopy cn_acc_periods_pvt.acc_period_tbl_type, a0 JTF_VARCHAR2_TABLE_100
4: , a1 JTF_NUMBER_TABLE
5: , a2 JTF_DATE_TABLE
6: , a3 JTF_DATE_TABLE
7: , a4 JTF_VARCHAR2_TABLE_100

Line 7: , a4 JTF_VARCHAR2_TABLE_100

3: procedure rosetta_table_copy_in_p1(t out nocopy cn_acc_periods_pvt.acc_period_tbl_type, a0 JTF_VARCHAR2_TABLE_100
4: , a1 JTF_NUMBER_TABLE
5: , a2 JTF_DATE_TABLE
6: , a3 JTF_DATE_TABLE
7: , a4 JTF_VARCHAR2_TABLE_100
8: , a5 JTF_VARCHAR2_TABLE_100
9: , a6 JTF_VARCHAR2_TABLE_100
10: , a7 JTF_NUMBER_TABLE
11: ) as

Line 8: , a5 JTF_VARCHAR2_TABLE_100

4: , a1 JTF_NUMBER_TABLE
5: , a2 JTF_DATE_TABLE
6: , a3 JTF_DATE_TABLE
7: , a4 JTF_VARCHAR2_TABLE_100
8: , a5 JTF_VARCHAR2_TABLE_100
9: , a6 JTF_VARCHAR2_TABLE_100
10: , a7 JTF_NUMBER_TABLE
11: ) as
12: ddindx binary_integer; indx binary_integer;

Line 9: , a6 JTF_VARCHAR2_TABLE_100

5: , a2 JTF_DATE_TABLE
6: , a3 JTF_DATE_TABLE
7: , a4 JTF_VARCHAR2_TABLE_100
8: , a5 JTF_VARCHAR2_TABLE_100
9: , a6 JTF_VARCHAR2_TABLE_100
10: , a7 JTF_NUMBER_TABLE
11: ) as
12: ddindx binary_integer; indx binary_integer;
13: begin

Line 36: procedure rosetta_table_copy_out_p1(t cn_acc_periods_pvt.acc_period_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_100

32: end loop;
33: end if;
34: end if;
35: end rosetta_table_copy_in_p1;
36: procedure rosetta_table_copy_out_p1(t cn_acc_periods_pvt.acc_period_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_100
37: , a1 out nocopy JTF_NUMBER_TABLE
38: , a2 out nocopy JTF_DATE_TABLE
39: , a3 out nocopy JTF_DATE_TABLE
40: , a4 out nocopy JTF_VARCHAR2_TABLE_100

Line 40: , a4 out nocopy JTF_VARCHAR2_TABLE_100

36: procedure rosetta_table_copy_out_p1(t cn_acc_periods_pvt.acc_period_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_100
37: , a1 out nocopy JTF_NUMBER_TABLE
38: , a2 out nocopy JTF_DATE_TABLE
39: , a3 out nocopy JTF_DATE_TABLE
40: , a4 out nocopy JTF_VARCHAR2_TABLE_100
41: , a5 out nocopy JTF_VARCHAR2_TABLE_100
42: , a6 out nocopy JTF_VARCHAR2_TABLE_100
43: , a7 out nocopy JTF_NUMBER_TABLE
44: ) as

Line 41: , a5 out nocopy JTF_VARCHAR2_TABLE_100

37: , a1 out nocopy JTF_NUMBER_TABLE
38: , a2 out nocopy JTF_DATE_TABLE
39: , a3 out nocopy JTF_DATE_TABLE
40: , a4 out nocopy JTF_VARCHAR2_TABLE_100
41: , a5 out nocopy JTF_VARCHAR2_TABLE_100
42: , a6 out nocopy JTF_VARCHAR2_TABLE_100
43: , a7 out nocopy JTF_NUMBER_TABLE
44: ) as
45: ddindx binary_integer; indx binary_integer;

Line 42: , a6 out nocopy JTF_VARCHAR2_TABLE_100

38: , a2 out nocopy JTF_DATE_TABLE
39: , a3 out nocopy JTF_DATE_TABLE
40: , a4 out nocopy JTF_VARCHAR2_TABLE_100
41: , a5 out nocopy JTF_VARCHAR2_TABLE_100
42: , a6 out nocopy JTF_VARCHAR2_TABLE_100
43: , a7 out nocopy JTF_NUMBER_TABLE
44: ) as
45: ddindx binary_integer; indx binary_integer;
46: begin

Line 48: a0 := JTF_VARCHAR2_TABLE_100();

44: ) as
45: ddindx binary_integer; indx binary_integer;
46: begin
47: if t is null or t.count = 0 then
48: a0 := JTF_VARCHAR2_TABLE_100();
49: a1 := JTF_NUMBER_TABLE();
50: a2 := JTF_DATE_TABLE();
51: a3 := JTF_DATE_TABLE();
52: a4 := JTF_VARCHAR2_TABLE_100();

Line 52: a4 := JTF_VARCHAR2_TABLE_100();

48: a0 := JTF_VARCHAR2_TABLE_100();
49: a1 := JTF_NUMBER_TABLE();
50: a2 := JTF_DATE_TABLE();
51: a3 := JTF_DATE_TABLE();
52: a4 := JTF_VARCHAR2_TABLE_100();
53: a5 := JTF_VARCHAR2_TABLE_100();
54: a6 := JTF_VARCHAR2_TABLE_100();
55: a7 := JTF_NUMBER_TABLE();
56: else

Line 53: a5 := JTF_VARCHAR2_TABLE_100();

49: a1 := JTF_NUMBER_TABLE();
50: a2 := JTF_DATE_TABLE();
51: a3 := JTF_DATE_TABLE();
52: a4 := JTF_VARCHAR2_TABLE_100();
53: a5 := JTF_VARCHAR2_TABLE_100();
54: a6 := JTF_VARCHAR2_TABLE_100();
55: a7 := JTF_NUMBER_TABLE();
56: else
57: a0 := JTF_VARCHAR2_TABLE_100();

Line 54: a6 := JTF_VARCHAR2_TABLE_100();

50: a2 := JTF_DATE_TABLE();
51: a3 := JTF_DATE_TABLE();
52: a4 := JTF_VARCHAR2_TABLE_100();
53: a5 := JTF_VARCHAR2_TABLE_100();
54: a6 := JTF_VARCHAR2_TABLE_100();
55: a7 := JTF_NUMBER_TABLE();
56: else
57: a0 := JTF_VARCHAR2_TABLE_100();
58: a1 := JTF_NUMBER_TABLE();

Line 57: a0 := JTF_VARCHAR2_TABLE_100();

53: a5 := JTF_VARCHAR2_TABLE_100();
54: a6 := JTF_VARCHAR2_TABLE_100();
55: a7 := JTF_NUMBER_TABLE();
56: else
57: a0 := JTF_VARCHAR2_TABLE_100();
58: a1 := JTF_NUMBER_TABLE();
59: a2 := JTF_DATE_TABLE();
60: a3 := JTF_DATE_TABLE();
61: a4 := JTF_VARCHAR2_TABLE_100();

Line 61: a4 := JTF_VARCHAR2_TABLE_100();

57: a0 := JTF_VARCHAR2_TABLE_100();
58: a1 := JTF_NUMBER_TABLE();
59: a2 := JTF_DATE_TABLE();
60: a3 := JTF_DATE_TABLE();
61: a4 := JTF_VARCHAR2_TABLE_100();
62: a5 := JTF_VARCHAR2_TABLE_100();
63: a6 := JTF_VARCHAR2_TABLE_100();
64: a7 := JTF_NUMBER_TABLE();
65: if t.count > 0 then

Line 62: a5 := JTF_VARCHAR2_TABLE_100();

58: a1 := JTF_NUMBER_TABLE();
59: a2 := JTF_DATE_TABLE();
60: a3 := JTF_DATE_TABLE();
61: a4 := JTF_VARCHAR2_TABLE_100();
62: a5 := JTF_VARCHAR2_TABLE_100();
63: a6 := JTF_VARCHAR2_TABLE_100();
64: a7 := JTF_NUMBER_TABLE();
65: if t.count > 0 then
66: a0.extend(t.count);

Line 63: a6 := JTF_VARCHAR2_TABLE_100();

59: a2 := JTF_DATE_TABLE();
60: a3 := JTF_DATE_TABLE();
61: a4 := JTF_VARCHAR2_TABLE_100();
62: a5 := JTF_VARCHAR2_TABLE_100();
63: a6 := JTF_VARCHAR2_TABLE_100();
64: a7 := JTF_NUMBER_TABLE();
65: if t.count > 0 then
66: a0.extend(t.count);
67: a1.extend(t.count);

Line 99: , p4_a0 JTF_VARCHAR2_TABLE_100

95: procedure update_acc_periods(p_api_version NUMBER
96: , p_init_msg_list VARCHAR2
97: , p_commit VARCHAR2
98: , p_validation_level NUMBER
99: , p4_a0 JTF_VARCHAR2_TABLE_100
100: , p4_a1 JTF_NUMBER_TABLE
101: , p4_a2 JTF_DATE_TABLE
102: , p4_a3 JTF_DATE_TABLE
103: , p4_a4 JTF_VARCHAR2_TABLE_100

Line 103: , p4_a4 JTF_VARCHAR2_TABLE_100

99: , p4_a0 JTF_VARCHAR2_TABLE_100
100: , p4_a1 JTF_NUMBER_TABLE
101: , p4_a2 JTF_DATE_TABLE
102: , p4_a3 JTF_DATE_TABLE
103: , p4_a4 JTF_VARCHAR2_TABLE_100
104: , p4_a5 JTF_VARCHAR2_TABLE_100
105: , p4_a6 JTF_VARCHAR2_TABLE_100
106: , p4_a7 JTF_NUMBER_TABLE
107: , p_org_id NUMBER

Line 104: , p4_a5 JTF_VARCHAR2_TABLE_100

100: , p4_a1 JTF_NUMBER_TABLE
101: , p4_a2 JTF_DATE_TABLE
102: , p4_a3 JTF_DATE_TABLE
103: , p4_a4 JTF_VARCHAR2_TABLE_100
104: , p4_a5 JTF_VARCHAR2_TABLE_100
105: , p4_a6 JTF_VARCHAR2_TABLE_100
106: , p4_a7 JTF_NUMBER_TABLE
107: , p_org_id NUMBER
108: , x_return_status out nocopy VARCHAR2

Line 105: , p4_a6 JTF_VARCHAR2_TABLE_100

101: , p4_a2 JTF_DATE_TABLE
102: , p4_a3 JTF_DATE_TABLE
103: , p4_a4 JTF_VARCHAR2_TABLE_100
104: , p4_a5 JTF_VARCHAR2_TABLE_100
105: , p4_a6 JTF_VARCHAR2_TABLE_100
106: , p4_a7 JTF_NUMBER_TABLE
107: , p_org_id NUMBER
108: , x_return_status out nocopy VARCHAR2
109: , x_msg_count out nocopy NUMBER

Line 163: , p4_a0 out nocopy JTF_VARCHAR2_TABLE_100

159: procedure get_acc_periods(p_year NUMBER
160: , x_system_status out nocopy VARCHAR2
161: , x_calendar out nocopy VARCHAR2
162: , x_period_type out nocopy VARCHAR2
163: , p4_a0 out nocopy JTF_VARCHAR2_TABLE_100
164: , p4_a1 out nocopy JTF_NUMBER_TABLE
165: , p4_a2 out nocopy JTF_DATE_TABLE
166: , p4_a3 out nocopy JTF_DATE_TABLE
167: , p4_a4 out nocopy JTF_VARCHAR2_TABLE_100

Line 167: , p4_a4 out nocopy JTF_VARCHAR2_TABLE_100

163: , p4_a0 out nocopy JTF_VARCHAR2_TABLE_100
164: , p4_a1 out nocopy JTF_NUMBER_TABLE
165: , p4_a2 out nocopy JTF_DATE_TABLE
166: , p4_a3 out nocopy JTF_DATE_TABLE
167: , p4_a4 out nocopy JTF_VARCHAR2_TABLE_100
168: , p4_a5 out nocopy JTF_VARCHAR2_TABLE_100
169: , p4_a6 out nocopy JTF_VARCHAR2_TABLE_100
170: , p4_a7 out nocopy JTF_NUMBER_TABLE
171: )

Line 168: , p4_a5 out nocopy JTF_VARCHAR2_TABLE_100

164: , p4_a1 out nocopy JTF_NUMBER_TABLE
165: , p4_a2 out nocopy JTF_DATE_TABLE
166: , p4_a3 out nocopy JTF_DATE_TABLE
167: , p4_a4 out nocopy JTF_VARCHAR2_TABLE_100
168: , p4_a5 out nocopy JTF_VARCHAR2_TABLE_100
169: , p4_a6 out nocopy JTF_VARCHAR2_TABLE_100
170: , p4_a7 out nocopy JTF_NUMBER_TABLE
171: )
172:

Line 169: , p4_a6 out nocopy JTF_VARCHAR2_TABLE_100

165: , p4_a2 out nocopy JTF_DATE_TABLE
166: , p4_a3 out nocopy JTF_DATE_TABLE
167: , p4_a4 out nocopy JTF_VARCHAR2_TABLE_100
168: , p4_a5 out nocopy JTF_VARCHAR2_TABLE_100
169: , p4_a6 out nocopy JTF_VARCHAR2_TABLE_100
170: , p4_a7 out nocopy JTF_NUMBER_TABLE
171: )
172:
173: as