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_p1(t out nocopy csc_action_assembler_pvt.results_tab_type, a0 JTF_VARCHAR2_TABLE_1000
14: , a1 JTF_VARCHAR2_TABLE_1000
15: , a2 JTF_VARCHAR2_TABLE_1800
16: ) as
17: ddindx binary_integer; indx binary_integer;
10: return d;
11: end;
12:
13: procedure rosetta_table_copy_in_p1(t out nocopy csc_action_assembler_pvt.results_tab_type, a0 JTF_VARCHAR2_TABLE_1000
14: , a1 JTF_VARCHAR2_TABLE_1000
15: , a2 JTF_VARCHAR2_TABLE_1800
16: ) as
17: ddindx binary_integer; indx binary_integer;
18: begin
32: end loop;
33: end if;
34: end if;
35: end rosetta_table_copy_in_p1;
36: procedure rosetta_table_copy_out_p1(t csc_action_assembler_pvt.results_tab_type, a0 out nocopy JTF_VARCHAR2_TABLE_1000
37: , a1 out nocopy JTF_VARCHAR2_TABLE_1000
38: , a2 out nocopy JTF_VARCHAR2_TABLE_1800
39: ) as
40: ddindx binary_integer; indx binary_integer;
33: end if;
34: end if;
35: end rosetta_table_copy_in_p1;
36: procedure rosetta_table_copy_out_p1(t csc_action_assembler_pvt.results_tab_type, a0 out nocopy JTF_VARCHAR2_TABLE_1000
37: , a1 out nocopy JTF_VARCHAR2_TABLE_1000
38: , a2 out nocopy JTF_VARCHAR2_TABLE_1800
39: ) as
40: ddindx binary_integer; indx binary_integer;
41: begin
39: ) as
40: ddindx binary_integer; indx binary_integer;
41: begin
42: if t is null or t.count = 0 then
43: a0 := JTF_VARCHAR2_TABLE_1000();
44: a1 := JTF_VARCHAR2_TABLE_1000();
45: a2 := JTF_VARCHAR2_TABLE_1800();
46: else
47: a0 := JTF_VARCHAR2_TABLE_1000();
40: ddindx binary_integer; indx binary_integer;
41: begin
42: if t is null or t.count = 0 then
43: a0 := JTF_VARCHAR2_TABLE_1000();
44: a1 := JTF_VARCHAR2_TABLE_1000();
45: a2 := JTF_VARCHAR2_TABLE_1800();
46: else
47: a0 := JTF_VARCHAR2_TABLE_1000();
48: a1 := JTF_VARCHAR2_TABLE_1000();
43: a0 := JTF_VARCHAR2_TABLE_1000();
44: a1 := JTF_VARCHAR2_TABLE_1000();
45: a2 := JTF_VARCHAR2_TABLE_1800();
46: else
47: a0 := JTF_VARCHAR2_TABLE_1000();
48: a1 := JTF_VARCHAR2_TABLE_1000();
49: a2 := JTF_VARCHAR2_TABLE_1800();
50: if t.count > 0 then
51: a0.extend(t.count);
44: a1 := JTF_VARCHAR2_TABLE_1000();
45: a2 := JTF_VARCHAR2_TABLE_1800();
46: else
47: a0 := JTF_VARCHAR2_TABLE_1000();
48: a1 := JTF_VARCHAR2_TABLE_1000();
49: a2 := JTF_VARCHAR2_TABLE_1800();
50: if t.count > 0 then
51: a0.extend(t.count);
52: a1.extend(t.count);
72: , p_end_user_type VARCHAR2
73: , p_application_short_name VARCHAR2
74: , p4_a0 JTF_VARCHAR2_TABLE_200
75: , p4_a1 JTF_VARCHAR2_TABLE_300
76: , p5_a0 out nocopy JTF_VARCHAR2_TABLE_1000
77: , p5_a1 out nocopy JTF_VARCHAR2_TABLE_1000
78: , p5_a2 out nocopy JTF_VARCHAR2_TABLE_1800
79: )
80:
73: , p_application_short_name VARCHAR2
74: , p4_a0 JTF_VARCHAR2_TABLE_200
75: , p4_a1 JTF_VARCHAR2_TABLE_300
76: , p5_a0 out nocopy JTF_VARCHAR2_TABLE_1000
77: , p5_a1 out nocopy JTF_VARCHAR2_TABLE_1000
78: , p5_a2 out nocopy JTF_VARCHAR2_TABLE_1800
79: )
80:
81: as
122: , p4_a1 JTF_VARCHAR2_TABLE_300
123: , x_return_status out nocopy VARCHAR2
124: , x_msg_count out nocopy NUMBER
125: , x_msg_data out nocopy VARCHAR2
126: , p8_a0 in out nocopy JTF_VARCHAR2_TABLE_1000
127: , p8_a1 in out nocopy JTF_VARCHAR2_TABLE_1000
128: , p8_a2 in out nocopy JTF_VARCHAR2_TABLE_1800
129: )
130:
123: , x_return_status out nocopy VARCHAR2
124: , x_msg_count out nocopy NUMBER
125: , x_msg_data out nocopy VARCHAR2
126: , p8_a0 in out nocopy JTF_VARCHAR2_TABLE_1000
127: , p8_a1 in out nocopy JTF_VARCHAR2_TABLE_1000
128: , p8_a2 in out nocopy JTF_VARCHAR2_TABLE_1800
129: )
130:
131: as