9: if d = rosetta_g_mistake_date then return fnd_api.g_miss_date; end if;
10: return d;
11: end;
12:
13: procedure rosetta_table_copy_in_p2(t out nocopy pv_prgm_benefits_pvt.program_benefits_tbl_type, a0 JTF_NUMBER_TABLE
14: , a1 JTF_NUMBER_TABLE
15: , a2 JTF_VARCHAR2_TABLE_100
16: , a3 JTF_NUMBER_TABLE
17: , a4 JTF_VARCHAR2_TABLE_100
10: return d;
11: end;
12:
13: procedure rosetta_table_copy_in_p2(t out nocopy pv_prgm_benefits_pvt.program_benefits_tbl_type, a0 JTF_NUMBER_TABLE
14: , a1 JTF_NUMBER_TABLE
15: , a2 JTF_VARCHAR2_TABLE_100
16: , a3 JTF_NUMBER_TABLE
17: , a4 JTF_VARCHAR2_TABLE_100
18: , a5 JTF_VARCHAR2_TABLE_100
12:
13: procedure rosetta_table_copy_in_p2(t out nocopy pv_prgm_benefits_pvt.program_benefits_tbl_type, a0 JTF_NUMBER_TABLE
14: , a1 JTF_NUMBER_TABLE
15: , a2 JTF_VARCHAR2_TABLE_100
16: , a3 JTF_NUMBER_TABLE
17: , a4 JTF_VARCHAR2_TABLE_100
18: , a5 JTF_VARCHAR2_TABLE_100
19: , a6 JTF_NUMBER_TABLE
20: , a7 JTF_NUMBER_TABLE
15: , a2 JTF_VARCHAR2_TABLE_100
16: , a3 JTF_NUMBER_TABLE
17: , a4 JTF_VARCHAR2_TABLE_100
18: , a5 JTF_VARCHAR2_TABLE_100
19: , a6 JTF_NUMBER_TABLE
20: , a7 JTF_NUMBER_TABLE
21: , a8 JTF_DATE_TABLE
22: , a9 JTF_NUMBER_TABLE
23: , a10 JTF_NUMBER_TABLE
16: , a3 JTF_NUMBER_TABLE
17: , a4 JTF_VARCHAR2_TABLE_100
18: , a5 JTF_VARCHAR2_TABLE_100
19: , a6 JTF_NUMBER_TABLE
20: , a7 JTF_NUMBER_TABLE
21: , a8 JTF_DATE_TABLE
22: , a9 JTF_NUMBER_TABLE
23: , a10 JTF_NUMBER_TABLE
24: , a11 JTF_DATE_TABLE
18: , a5 JTF_VARCHAR2_TABLE_100
19: , a6 JTF_NUMBER_TABLE
20: , a7 JTF_NUMBER_TABLE
21: , a8 JTF_DATE_TABLE
22: , a9 JTF_NUMBER_TABLE
23: , a10 JTF_NUMBER_TABLE
24: , a11 JTF_DATE_TABLE
25: ) as
26: ddindx binary_integer; indx binary_integer;
19: , a6 JTF_NUMBER_TABLE
20: , a7 JTF_NUMBER_TABLE
21: , a8 JTF_DATE_TABLE
22: , a9 JTF_NUMBER_TABLE
23: , a10 JTF_NUMBER_TABLE
24: , a11 JTF_DATE_TABLE
25: ) as
26: ddindx binary_integer; indx binary_integer;
27: begin
50: end loop;
51: end if;
52: end if;
53: end rosetta_table_copy_in_p2;
54: procedure rosetta_table_copy_out_p2(t pv_prgm_benefits_pvt.program_benefits_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
55: , a1 out nocopy JTF_NUMBER_TABLE
56: , a2 out nocopy JTF_VARCHAR2_TABLE_100
57: , a3 out nocopy JTF_NUMBER_TABLE
58: , a4 out nocopy JTF_VARCHAR2_TABLE_100
51: end if;
52: end if;
53: end rosetta_table_copy_in_p2;
54: procedure rosetta_table_copy_out_p2(t pv_prgm_benefits_pvt.program_benefits_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
55: , a1 out nocopy JTF_NUMBER_TABLE
56: , a2 out nocopy JTF_VARCHAR2_TABLE_100
57: , a3 out nocopy JTF_NUMBER_TABLE
58: , a4 out nocopy JTF_VARCHAR2_TABLE_100
59: , a5 out nocopy JTF_VARCHAR2_TABLE_100
53: end rosetta_table_copy_in_p2;
54: procedure rosetta_table_copy_out_p2(t pv_prgm_benefits_pvt.program_benefits_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
55: , a1 out nocopy JTF_NUMBER_TABLE
56: , a2 out nocopy JTF_VARCHAR2_TABLE_100
57: , a3 out nocopy JTF_NUMBER_TABLE
58: , a4 out nocopy JTF_VARCHAR2_TABLE_100
59: , a5 out nocopy JTF_VARCHAR2_TABLE_100
60: , a6 out nocopy JTF_NUMBER_TABLE
61: , a7 out nocopy JTF_NUMBER_TABLE
56: , a2 out nocopy JTF_VARCHAR2_TABLE_100
57: , a3 out nocopy JTF_NUMBER_TABLE
58: , a4 out nocopy JTF_VARCHAR2_TABLE_100
59: , a5 out nocopy JTF_VARCHAR2_TABLE_100
60: , a6 out nocopy JTF_NUMBER_TABLE
61: , a7 out nocopy JTF_NUMBER_TABLE
62: , a8 out nocopy JTF_DATE_TABLE
63: , a9 out nocopy JTF_NUMBER_TABLE
64: , a10 out nocopy JTF_NUMBER_TABLE
57: , a3 out nocopy JTF_NUMBER_TABLE
58: , a4 out nocopy JTF_VARCHAR2_TABLE_100
59: , a5 out nocopy JTF_VARCHAR2_TABLE_100
60: , a6 out nocopy JTF_NUMBER_TABLE
61: , a7 out nocopy JTF_NUMBER_TABLE
62: , a8 out nocopy JTF_DATE_TABLE
63: , a9 out nocopy JTF_NUMBER_TABLE
64: , a10 out nocopy JTF_NUMBER_TABLE
65: , a11 out nocopy JTF_DATE_TABLE
59: , a5 out nocopy JTF_VARCHAR2_TABLE_100
60: , a6 out nocopy JTF_NUMBER_TABLE
61: , a7 out nocopy JTF_NUMBER_TABLE
62: , a8 out nocopy JTF_DATE_TABLE
63: , a9 out nocopy JTF_NUMBER_TABLE
64: , a10 out nocopy JTF_NUMBER_TABLE
65: , a11 out nocopy JTF_DATE_TABLE
66: ) as
67: ddindx binary_integer; indx binary_integer;
60: , a6 out nocopy JTF_NUMBER_TABLE
61: , a7 out nocopy JTF_NUMBER_TABLE
62: , a8 out nocopy JTF_DATE_TABLE
63: , a9 out nocopy JTF_NUMBER_TABLE
64: , a10 out nocopy JTF_NUMBER_TABLE
65: , a11 out nocopy JTF_DATE_TABLE
66: ) as
67: ddindx binary_integer; indx binary_integer;
68: begin
66: ) as
67: ddindx binary_integer; indx binary_integer;
68: begin
69: if t is null or t.count = 0 then
70: a0 := JTF_NUMBER_TABLE();
71: a1 := JTF_NUMBER_TABLE();
72: a2 := JTF_VARCHAR2_TABLE_100();
73: a3 := JTF_NUMBER_TABLE();
74: a4 := JTF_VARCHAR2_TABLE_100();
67: ddindx binary_integer; indx binary_integer;
68: begin
69: if t is null or t.count = 0 then
70: a0 := JTF_NUMBER_TABLE();
71: a1 := JTF_NUMBER_TABLE();
72: a2 := JTF_VARCHAR2_TABLE_100();
73: a3 := JTF_NUMBER_TABLE();
74: a4 := JTF_VARCHAR2_TABLE_100();
75: a5 := JTF_VARCHAR2_TABLE_100();
69: if t is null or t.count = 0 then
70: a0 := JTF_NUMBER_TABLE();
71: a1 := JTF_NUMBER_TABLE();
72: a2 := JTF_VARCHAR2_TABLE_100();
73: a3 := JTF_NUMBER_TABLE();
74: a4 := JTF_VARCHAR2_TABLE_100();
75: a5 := JTF_VARCHAR2_TABLE_100();
76: a6 := JTF_NUMBER_TABLE();
77: a7 := JTF_NUMBER_TABLE();
72: a2 := JTF_VARCHAR2_TABLE_100();
73: a3 := JTF_NUMBER_TABLE();
74: a4 := JTF_VARCHAR2_TABLE_100();
75: a5 := JTF_VARCHAR2_TABLE_100();
76: a6 := JTF_NUMBER_TABLE();
77: a7 := JTF_NUMBER_TABLE();
78: a8 := JTF_DATE_TABLE();
79: a9 := JTF_NUMBER_TABLE();
80: a10 := JTF_NUMBER_TABLE();
73: a3 := JTF_NUMBER_TABLE();
74: a4 := JTF_VARCHAR2_TABLE_100();
75: a5 := JTF_VARCHAR2_TABLE_100();
76: a6 := JTF_NUMBER_TABLE();
77: a7 := JTF_NUMBER_TABLE();
78: a8 := JTF_DATE_TABLE();
79: a9 := JTF_NUMBER_TABLE();
80: a10 := JTF_NUMBER_TABLE();
81: a11 := JTF_DATE_TABLE();
75: a5 := JTF_VARCHAR2_TABLE_100();
76: a6 := JTF_NUMBER_TABLE();
77: a7 := JTF_NUMBER_TABLE();
78: a8 := JTF_DATE_TABLE();
79: a9 := JTF_NUMBER_TABLE();
80: a10 := JTF_NUMBER_TABLE();
81: a11 := JTF_DATE_TABLE();
82: else
83: a0 := JTF_NUMBER_TABLE();
76: a6 := JTF_NUMBER_TABLE();
77: a7 := JTF_NUMBER_TABLE();
78: a8 := JTF_DATE_TABLE();
79: a9 := JTF_NUMBER_TABLE();
80: a10 := JTF_NUMBER_TABLE();
81: a11 := JTF_DATE_TABLE();
82: else
83: a0 := JTF_NUMBER_TABLE();
84: a1 := JTF_NUMBER_TABLE();
79: a9 := JTF_NUMBER_TABLE();
80: a10 := JTF_NUMBER_TABLE();
81: a11 := JTF_DATE_TABLE();
82: else
83: a0 := JTF_NUMBER_TABLE();
84: a1 := JTF_NUMBER_TABLE();
85: a2 := JTF_VARCHAR2_TABLE_100();
86: a3 := JTF_NUMBER_TABLE();
87: a4 := JTF_VARCHAR2_TABLE_100();
80: a10 := JTF_NUMBER_TABLE();
81: a11 := JTF_DATE_TABLE();
82: else
83: a0 := JTF_NUMBER_TABLE();
84: a1 := JTF_NUMBER_TABLE();
85: a2 := JTF_VARCHAR2_TABLE_100();
86: a3 := JTF_NUMBER_TABLE();
87: a4 := JTF_VARCHAR2_TABLE_100();
88: a5 := JTF_VARCHAR2_TABLE_100();
82: else
83: a0 := JTF_NUMBER_TABLE();
84: a1 := JTF_NUMBER_TABLE();
85: a2 := JTF_VARCHAR2_TABLE_100();
86: a3 := JTF_NUMBER_TABLE();
87: a4 := JTF_VARCHAR2_TABLE_100();
88: a5 := JTF_VARCHAR2_TABLE_100();
89: a6 := JTF_NUMBER_TABLE();
90: a7 := JTF_NUMBER_TABLE();
85: a2 := JTF_VARCHAR2_TABLE_100();
86: a3 := JTF_NUMBER_TABLE();
87: a4 := JTF_VARCHAR2_TABLE_100();
88: a5 := JTF_VARCHAR2_TABLE_100();
89: a6 := JTF_NUMBER_TABLE();
90: a7 := JTF_NUMBER_TABLE();
91: a8 := JTF_DATE_TABLE();
92: a9 := JTF_NUMBER_TABLE();
93: a10 := JTF_NUMBER_TABLE();
86: a3 := JTF_NUMBER_TABLE();
87: a4 := JTF_VARCHAR2_TABLE_100();
88: a5 := JTF_VARCHAR2_TABLE_100();
89: a6 := JTF_NUMBER_TABLE();
90: a7 := JTF_NUMBER_TABLE();
91: a8 := JTF_DATE_TABLE();
92: a9 := JTF_NUMBER_TABLE();
93: a10 := JTF_NUMBER_TABLE();
94: a11 := JTF_DATE_TABLE();
88: a5 := JTF_VARCHAR2_TABLE_100();
89: a6 := JTF_NUMBER_TABLE();
90: a7 := JTF_NUMBER_TABLE();
91: a8 := JTF_DATE_TABLE();
92: a9 := JTF_NUMBER_TABLE();
93: a10 := JTF_NUMBER_TABLE();
94: a11 := JTF_DATE_TABLE();
95: if t.count > 0 then
96: a0.extend(t.count);
89: a6 := JTF_NUMBER_TABLE();
90: a7 := JTF_NUMBER_TABLE();
91: a8 := JTF_DATE_TABLE();
92: a9 := JTF_NUMBER_TABLE();
93: a10 := JTF_NUMBER_TABLE();
94: a11 := JTF_DATE_TABLE();
95: if t.count > 0 then
96: a0.extend(t.count);
97: a1.extend(t.count);