12: if d < rosetta_g_mistake_date_low then return fnd_api.g_miss_date; end if;
13: return d;
14: end;
15:
16: procedure rosetta_table_copy_in_p1(t out nocopy ieu_frm_pvt.t_ieu_media_data, a0 JTF_VARCHAR2_TABLE_4000
17: , a1 JTF_VARCHAR2_TABLE_4000
18: , a2 JTF_VARCHAR2_TABLE_4000
19: ) as
20: ddindx binary_integer; indx binary_integer;
13: return d;
14: end;
15:
16: procedure rosetta_table_copy_in_p1(t out nocopy ieu_frm_pvt.t_ieu_media_data, a0 JTF_VARCHAR2_TABLE_4000
17: , a1 JTF_VARCHAR2_TABLE_4000
18: , a2 JTF_VARCHAR2_TABLE_4000
19: ) as
20: ddindx binary_integer; indx binary_integer;
21: begin
14: end;
15:
16: procedure rosetta_table_copy_in_p1(t out nocopy ieu_frm_pvt.t_ieu_media_data, a0 JTF_VARCHAR2_TABLE_4000
17: , a1 JTF_VARCHAR2_TABLE_4000
18: , a2 JTF_VARCHAR2_TABLE_4000
19: ) as
20: ddindx binary_integer; indx binary_integer;
21: begin
22: if a0 is not null and a0.count > 0 then
35: end loop;
36: end if;
37: end if;
38: end rosetta_table_copy_in_p1;
39: procedure rosetta_table_copy_out_p1(t ieu_frm_pvt.t_ieu_media_data, a0 out nocopy JTF_VARCHAR2_TABLE_4000
40: , a1 out nocopy JTF_VARCHAR2_TABLE_4000
41: , a2 out nocopy JTF_VARCHAR2_TABLE_4000
42: ) as
43: ddindx binary_integer; indx binary_integer;
36: end if;
37: end if;
38: end rosetta_table_copy_in_p1;
39: procedure rosetta_table_copy_out_p1(t ieu_frm_pvt.t_ieu_media_data, a0 out nocopy JTF_VARCHAR2_TABLE_4000
40: , a1 out nocopy JTF_VARCHAR2_TABLE_4000
41: , a2 out nocopy JTF_VARCHAR2_TABLE_4000
42: ) as
43: ddindx binary_integer; indx binary_integer;
44: begin
37: end if;
38: end rosetta_table_copy_in_p1;
39: procedure rosetta_table_copy_out_p1(t ieu_frm_pvt.t_ieu_media_data, a0 out nocopy JTF_VARCHAR2_TABLE_4000
40: , a1 out nocopy JTF_VARCHAR2_TABLE_4000
41: , a2 out nocopy JTF_VARCHAR2_TABLE_4000
42: ) as
43: ddindx binary_integer; indx binary_integer;
44: begin
45: if t is null or t.count = 0 then
42: ) as
43: ddindx binary_integer; indx binary_integer;
44: begin
45: if t is null or t.count = 0 then
46: a0 := JTF_VARCHAR2_TABLE_4000();
47: a1 := JTF_VARCHAR2_TABLE_4000();
48: a2 := JTF_VARCHAR2_TABLE_4000();
49: else
50: a0 := JTF_VARCHAR2_TABLE_4000();
43: ddindx binary_integer; indx binary_integer;
44: begin
45: if t is null or t.count = 0 then
46: a0 := JTF_VARCHAR2_TABLE_4000();
47: a1 := JTF_VARCHAR2_TABLE_4000();
48: a2 := JTF_VARCHAR2_TABLE_4000();
49: else
50: a0 := JTF_VARCHAR2_TABLE_4000();
51: a1 := JTF_VARCHAR2_TABLE_4000();
44: begin
45: if t is null or t.count = 0 then
46: a0 := JTF_VARCHAR2_TABLE_4000();
47: a1 := JTF_VARCHAR2_TABLE_4000();
48: a2 := JTF_VARCHAR2_TABLE_4000();
49: else
50: a0 := JTF_VARCHAR2_TABLE_4000();
51: a1 := JTF_VARCHAR2_TABLE_4000();
52: a2 := JTF_VARCHAR2_TABLE_4000();
46: a0 := JTF_VARCHAR2_TABLE_4000();
47: a1 := JTF_VARCHAR2_TABLE_4000();
48: a2 := JTF_VARCHAR2_TABLE_4000();
49: else
50: a0 := JTF_VARCHAR2_TABLE_4000();
51: a1 := JTF_VARCHAR2_TABLE_4000();
52: a2 := JTF_VARCHAR2_TABLE_4000();
53: if t.count > 0 then
54: a0.extend(t.count);
47: a1 := JTF_VARCHAR2_TABLE_4000();
48: a2 := JTF_VARCHAR2_TABLE_4000();
49: else
50: a0 := JTF_VARCHAR2_TABLE_4000();
51: a1 := JTF_VARCHAR2_TABLE_4000();
52: a2 := JTF_VARCHAR2_TABLE_4000();
53: if t.count > 0 then
54: a0.extend(t.count);
55: a1.extend(t.count);
48: a2 := JTF_VARCHAR2_TABLE_4000();
49: else
50: a0 := JTF_VARCHAR2_TABLE_4000();
51: a1 := JTF_VARCHAR2_TABLE_4000();
52: a2 := JTF_VARCHAR2_TABLE_4000();
53: if t.count > 0 then
54: a0.extend(t.count);
55: a1.extend(t.count);
56: a2.extend(t.count);
70: end if;
71: end rosetta_table_copy_out_p1;
72:
73: procedure uwq_get_media_func(p_apps_proc VARCHAR2
74: , p1_a0 JTF_VARCHAR2_TABLE_4000
75: , p1_a1 JTF_VARCHAR2_TABLE_4000
76: , p1_a2 JTF_VARCHAR2_TABLE_4000
77: , p_action_type out nocopy NUMBER
78: , p_action_name out nocopy VARCHAR2
71: end rosetta_table_copy_out_p1;
72:
73: procedure uwq_get_media_func(p_apps_proc VARCHAR2
74: , p1_a0 JTF_VARCHAR2_TABLE_4000
75: , p1_a1 JTF_VARCHAR2_TABLE_4000
76: , p1_a2 JTF_VARCHAR2_TABLE_4000
77: , p_action_type out nocopy NUMBER
78: , p_action_name out nocopy VARCHAR2
79: , p_action_param out nocopy VARCHAR2
72:
73: procedure uwq_get_media_func(p_apps_proc VARCHAR2
74: , p1_a0 JTF_VARCHAR2_TABLE_4000
75: , p1_a1 JTF_VARCHAR2_TABLE_4000
76: , p1_a2 JTF_VARCHAR2_TABLE_4000
77: , p_action_type out nocopy NUMBER
78: , p_action_name out nocopy VARCHAR2
79: , p_action_param out nocopy VARCHAR2
80: )
108:
109: end;
110:
111: procedure uwq_get_action_func(p_apps_proc VARCHAR2
112: , p1_a0 JTF_VARCHAR2_TABLE_4000
113: , p1_a1 JTF_VARCHAR2_TABLE_4000
114: , p1_a2 JTF_VARCHAR2_TABLE_4000
115: , p_action_type out nocopy NUMBER
116: , p_action_name out nocopy VARCHAR2
109: end;
110:
111: procedure uwq_get_action_func(p_apps_proc VARCHAR2
112: , p1_a0 JTF_VARCHAR2_TABLE_4000
113: , p1_a1 JTF_VARCHAR2_TABLE_4000
114: , p1_a2 JTF_VARCHAR2_TABLE_4000
115: , p_action_type out nocopy NUMBER
116: , p_action_name out nocopy VARCHAR2
117: , p_action_param out nocopy VARCHAR2
110:
111: procedure uwq_get_action_func(p_apps_proc VARCHAR2
112: , p1_a0 JTF_VARCHAR2_TABLE_4000
113: , p1_a1 JTF_VARCHAR2_TABLE_4000
114: , p1_a2 JTF_VARCHAR2_TABLE_4000
115: , p_action_type out nocopy NUMBER
116: , p_action_name out nocopy VARCHAR2
117: , p_action_param out nocopy VARCHAR2
118: , p_msg_name out nocopy VARCHAR2