DBA Data[Home] [Help]

APPS.CN_IMP_MAPS_PVT_W dependencies on JTF_VARCHAR2_TABLE_200

Line 16: procedure rosetta_table_copy_in_p0(t out nocopy cn_imp_maps_pvt.v_tbl_type, a0 JTF_VARCHAR2_TABLE_200) as

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_p0(t out nocopy cn_imp_maps_pvt.v_tbl_type, a0 JTF_VARCHAR2_TABLE_200) as
17: ddindx binary_integer; indx binary_integer;
18: begin
19: if a0 is not null and a0.count > 0 then
20: if a0.count > 0 then

Line 34: procedure rosetta_table_copy_out_p0(t cn_imp_maps_pvt.v_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_200) as

30: end loop;
31: end if;
32: end if;
33: end rosetta_table_copy_in_p0;
34: procedure rosetta_table_copy_out_p0(t cn_imp_maps_pvt.v_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_200) as
35: ddindx binary_integer; indx binary_integer;
36: begin
37: if t is null or t.count = 0 then
38: a0 := JTF_VARCHAR2_TABLE_200();

Line 38: a0 := JTF_VARCHAR2_TABLE_200();

34: procedure rosetta_table_copy_out_p0(t cn_imp_maps_pvt.v_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_200) as
35: ddindx binary_integer; indx binary_integer;
36: begin
37: if t is null or t.count = 0 then
38: a0 := JTF_VARCHAR2_TABLE_200();
39: else
40: a0 := JTF_VARCHAR2_TABLE_200();
41: if t.count > 0 then
42: a0.extend(t.count);

Line 40: a0 := JTF_VARCHAR2_TABLE_200();

36: begin
37: if t is null or t.count = 0 then
38: a0 := JTF_VARCHAR2_TABLE_200();
39: else
40: a0 := JTF_VARCHAR2_TABLE_200();
41: if t.count > 0 then
42: a0.extend(t.count);
43: ddindx := t.first;
44: indx := 1;

Line 57: procedure rosetta_table_copy_in_p6(t out nocopy cn_imp_maps_pvt.map_field_tbl_type, a0 JTF_VARCHAR2_TABLE_200

53: end if;
54: end if;
55: end rosetta_table_copy_out_p0;
56:
57: procedure rosetta_table_copy_in_p6(t out nocopy cn_imp_maps_pvt.map_field_tbl_type, a0 JTF_VARCHAR2_TABLE_200
58: , a1 JTF_VARCHAR2_TABLE_200
59: , a2 JTF_VARCHAR2_TABLE_200
60: ) as
61: ddindx binary_integer; indx binary_integer;

Line 58: , a1 JTF_VARCHAR2_TABLE_200

54: end if;
55: end rosetta_table_copy_out_p0;
56:
57: procedure rosetta_table_copy_in_p6(t out nocopy cn_imp_maps_pvt.map_field_tbl_type, a0 JTF_VARCHAR2_TABLE_200
58: , a1 JTF_VARCHAR2_TABLE_200
59: , a2 JTF_VARCHAR2_TABLE_200
60: ) as
61: ddindx binary_integer; indx binary_integer;
62: begin

Line 59: , a2 JTF_VARCHAR2_TABLE_200

55: end rosetta_table_copy_out_p0;
56:
57: procedure rosetta_table_copy_in_p6(t out nocopy cn_imp_maps_pvt.map_field_tbl_type, a0 JTF_VARCHAR2_TABLE_200
58: , a1 JTF_VARCHAR2_TABLE_200
59: , a2 JTF_VARCHAR2_TABLE_200
60: ) as
61: ddindx binary_integer; indx binary_integer;
62: begin
63: if a0 is not null and a0.count > 0 then

Line 80: procedure rosetta_table_copy_out_p6(t cn_imp_maps_pvt.map_field_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_200

76: end loop;
77: end if;
78: end if;
79: end rosetta_table_copy_in_p6;
80: procedure rosetta_table_copy_out_p6(t cn_imp_maps_pvt.map_field_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_200
81: , a1 out nocopy JTF_VARCHAR2_TABLE_200
82: , a2 out nocopy JTF_VARCHAR2_TABLE_200
83: ) as
84: ddindx binary_integer; indx binary_integer;

Line 81: , a1 out nocopy JTF_VARCHAR2_TABLE_200

77: end if;
78: end if;
79: end rosetta_table_copy_in_p6;
80: procedure rosetta_table_copy_out_p6(t cn_imp_maps_pvt.map_field_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_200
81: , a1 out nocopy JTF_VARCHAR2_TABLE_200
82: , a2 out nocopy JTF_VARCHAR2_TABLE_200
83: ) as
84: ddindx binary_integer; indx binary_integer;
85: begin

Line 82: , a2 out nocopy JTF_VARCHAR2_TABLE_200

78: end if;
79: end rosetta_table_copy_in_p6;
80: procedure rosetta_table_copy_out_p6(t cn_imp_maps_pvt.map_field_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_200
81: , a1 out nocopy JTF_VARCHAR2_TABLE_200
82: , a2 out nocopy JTF_VARCHAR2_TABLE_200
83: ) as
84: ddindx binary_integer; indx binary_integer;
85: begin
86: if t is null or t.count = 0 then

Line 87: a0 := JTF_VARCHAR2_TABLE_200();

83: ) as
84: ddindx binary_integer; indx binary_integer;
85: begin
86: if t is null or t.count = 0 then
87: a0 := JTF_VARCHAR2_TABLE_200();
88: a1 := JTF_VARCHAR2_TABLE_200();
89: a2 := JTF_VARCHAR2_TABLE_200();
90: else
91: a0 := JTF_VARCHAR2_TABLE_200();

Line 88: a1 := JTF_VARCHAR2_TABLE_200();

84: ddindx binary_integer; indx binary_integer;
85: begin
86: if t is null or t.count = 0 then
87: a0 := JTF_VARCHAR2_TABLE_200();
88: a1 := JTF_VARCHAR2_TABLE_200();
89: a2 := JTF_VARCHAR2_TABLE_200();
90: else
91: a0 := JTF_VARCHAR2_TABLE_200();
92: a1 := JTF_VARCHAR2_TABLE_200();

Line 89: a2 := JTF_VARCHAR2_TABLE_200();

85: begin
86: if t is null or t.count = 0 then
87: a0 := JTF_VARCHAR2_TABLE_200();
88: a1 := JTF_VARCHAR2_TABLE_200();
89: a2 := JTF_VARCHAR2_TABLE_200();
90: else
91: a0 := JTF_VARCHAR2_TABLE_200();
92: a1 := JTF_VARCHAR2_TABLE_200();
93: a2 := JTF_VARCHAR2_TABLE_200();

Line 91: a0 := JTF_VARCHAR2_TABLE_200();

87: a0 := JTF_VARCHAR2_TABLE_200();
88: a1 := JTF_VARCHAR2_TABLE_200();
89: a2 := JTF_VARCHAR2_TABLE_200();
90: else
91: a0 := JTF_VARCHAR2_TABLE_200();
92: a1 := JTF_VARCHAR2_TABLE_200();
93: a2 := JTF_VARCHAR2_TABLE_200();
94: if t.count > 0 then
95: a0.extend(t.count);

Line 92: a1 := JTF_VARCHAR2_TABLE_200();

88: a1 := JTF_VARCHAR2_TABLE_200();
89: a2 := JTF_VARCHAR2_TABLE_200();
90: else
91: a0 := JTF_VARCHAR2_TABLE_200();
92: a1 := JTF_VARCHAR2_TABLE_200();
93: a2 := JTF_VARCHAR2_TABLE_200();
94: if t.count > 0 then
95: a0.extend(t.count);
96: a1.extend(t.count);

Line 93: a2 := JTF_VARCHAR2_TABLE_200();

89: a2 := JTF_VARCHAR2_TABLE_200();
90: else
91: a0 := JTF_VARCHAR2_TABLE_200();
92: a1 := JTF_VARCHAR2_TABLE_200();
93: a2 := JTF_VARCHAR2_TABLE_200();
94: if t.count > 0 then
95: a0.extend(t.count);
96: a1.extend(t.count);
97: a2.extend(t.count);

Line 148: , p10_a0 JTF_VARCHAR2_TABLE_200

144: , p9_a21 NUMBER
145: , p9_a22 DATE
146: , p9_a23 NUMBER
147: , p9_a24 NUMBER
148: , p10_a0 JTF_VARCHAR2_TABLE_200
149: , p10_a1 JTF_VARCHAR2_TABLE_200
150: , p10_a2 JTF_VARCHAR2_TABLE_200
151: , p_target_fields JTF_VARCHAR2_TABLE_200
152: , x_imp_map_id out nocopy NUMBER

Line 149: , p10_a1 JTF_VARCHAR2_TABLE_200

145: , p9_a22 DATE
146: , p9_a23 NUMBER
147: , p9_a24 NUMBER
148: , p10_a0 JTF_VARCHAR2_TABLE_200
149: , p10_a1 JTF_VARCHAR2_TABLE_200
150: , p10_a2 JTF_VARCHAR2_TABLE_200
151: , p_target_fields JTF_VARCHAR2_TABLE_200
152: , x_imp_map_id out nocopy NUMBER
153: , p_org_id NUMBER

Line 150: , p10_a2 JTF_VARCHAR2_TABLE_200

146: , p9_a23 NUMBER
147: , p9_a24 NUMBER
148: , p10_a0 JTF_VARCHAR2_TABLE_200
149: , p10_a1 JTF_VARCHAR2_TABLE_200
150: , p10_a2 JTF_VARCHAR2_TABLE_200
151: , p_target_fields JTF_VARCHAR2_TABLE_200
152: , x_imp_map_id out nocopy NUMBER
153: , p_org_id NUMBER
154: )

Line 151: , p_target_fields JTF_VARCHAR2_TABLE_200

147: , p9_a24 NUMBER
148: , p10_a0 JTF_VARCHAR2_TABLE_200
149: , p10_a1 JTF_VARCHAR2_TABLE_200
150: , p10_a2 JTF_VARCHAR2_TABLE_200
151: , p_target_fields JTF_VARCHAR2_TABLE_200
152: , x_imp_map_id out nocopy NUMBER
153: , p_org_id NUMBER
154: )
155:

Line 249: , p9_a0 out nocopy JTF_VARCHAR2_TABLE_200

245: , x_msg_count out nocopy NUMBER
246: , x_msg_data out nocopy VARCHAR2
247: , p_imp_map_id NUMBER
248: , p_import_type_code VARCHAR2
249: , p9_a0 out nocopy JTF_VARCHAR2_TABLE_200
250: , p9_a1 out nocopy JTF_VARCHAR2_TABLE_200
251: , p9_a2 out nocopy JTF_VARCHAR2_TABLE_200
252: , p10_a0 out nocopy JTF_VARCHAR2_TABLE_200
253: , p10_a1 out nocopy JTF_VARCHAR2_TABLE_200

Line 250: , p9_a1 out nocopy JTF_VARCHAR2_TABLE_200

246: , x_msg_data out nocopy VARCHAR2
247: , p_imp_map_id NUMBER
248: , p_import_type_code VARCHAR2
249: , p9_a0 out nocopy JTF_VARCHAR2_TABLE_200
250: , p9_a1 out nocopy JTF_VARCHAR2_TABLE_200
251: , p9_a2 out nocopy JTF_VARCHAR2_TABLE_200
252: , p10_a0 out nocopy JTF_VARCHAR2_TABLE_200
253: , p10_a1 out nocopy JTF_VARCHAR2_TABLE_200
254: , p10_a2 out nocopy JTF_VARCHAR2_TABLE_200

Line 251: , p9_a2 out nocopy JTF_VARCHAR2_TABLE_200

247: , p_imp_map_id NUMBER
248: , p_import_type_code VARCHAR2
249: , p9_a0 out nocopy JTF_VARCHAR2_TABLE_200
250: , p9_a1 out nocopy JTF_VARCHAR2_TABLE_200
251: , p9_a2 out nocopy JTF_VARCHAR2_TABLE_200
252: , p10_a0 out nocopy JTF_VARCHAR2_TABLE_200
253: , p10_a1 out nocopy JTF_VARCHAR2_TABLE_200
254: , p10_a2 out nocopy JTF_VARCHAR2_TABLE_200
255: , p11_a0 out nocopy JTF_VARCHAR2_TABLE_200

Line 252: , p10_a0 out nocopy JTF_VARCHAR2_TABLE_200

248: , p_import_type_code VARCHAR2
249: , p9_a0 out nocopy JTF_VARCHAR2_TABLE_200
250: , p9_a1 out nocopy JTF_VARCHAR2_TABLE_200
251: , p9_a2 out nocopy JTF_VARCHAR2_TABLE_200
252: , p10_a0 out nocopy JTF_VARCHAR2_TABLE_200
253: , p10_a1 out nocopy JTF_VARCHAR2_TABLE_200
254: , p10_a2 out nocopy JTF_VARCHAR2_TABLE_200
255: , p11_a0 out nocopy JTF_VARCHAR2_TABLE_200
256: , p11_a1 out nocopy JTF_VARCHAR2_TABLE_200

Line 253: , p10_a1 out nocopy JTF_VARCHAR2_TABLE_200

249: , p9_a0 out nocopy JTF_VARCHAR2_TABLE_200
250: , p9_a1 out nocopy JTF_VARCHAR2_TABLE_200
251: , p9_a2 out nocopy JTF_VARCHAR2_TABLE_200
252: , p10_a0 out nocopy JTF_VARCHAR2_TABLE_200
253: , p10_a1 out nocopy JTF_VARCHAR2_TABLE_200
254: , p10_a2 out nocopy JTF_VARCHAR2_TABLE_200
255: , p11_a0 out nocopy JTF_VARCHAR2_TABLE_200
256: , p11_a1 out nocopy JTF_VARCHAR2_TABLE_200
257: , p11_a2 out nocopy JTF_VARCHAR2_TABLE_200

Line 254: , p10_a2 out nocopy JTF_VARCHAR2_TABLE_200

250: , p9_a1 out nocopy JTF_VARCHAR2_TABLE_200
251: , p9_a2 out nocopy JTF_VARCHAR2_TABLE_200
252: , p10_a0 out nocopy JTF_VARCHAR2_TABLE_200
253: , p10_a1 out nocopy JTF_VARCHAR2_TABLE_200
254: , p10_a2 out nocopy JTF_VARCHAR2_TABLE_200
255: , p11_a0 out nocopy JTF_VARCHAR2_TABLE_200
256: , p11_a1 out nocopy JTF_VARCHAR2_TABLE_200
257: , p11_a2 out nocopy JTF_VARCHAR2_TABLE_200
258: , x_map_obj_num out nocopy NUMBER

Line 255: , p11_a0 out nocopy JTF_VARCHAR2_TABLE_200

251: , p9_a2 out nocopy JTF_VARCHAR2_TABLE_200
252: , p10_a0 out nocopy JTF_VARCHAR2_TABLE_200
253: , p10_a1 out nocopy JTF_VARCHAR2_TABLE_200
254: , p10_a2 out nocopy JTF_VARCHAR2_TABLE_200
255: , p11_a0 out nocopy JTF_VARCHAR2_TABLE_200
256: , p11_a1 out nocopy JTF_VARCHAR2_TABLE_200
257: , p11_a2 out nocopy JTF_VARCHAR2_TABLE_200
258: , x_map_obj_num out nocopy NUMBER
259: , p_org_id NUMBER

Line 256: , p11_a1 out nocopy JTF_VARCHAR2_TABLE_200

252: , p10_a0 out nocopy JTF_VARCHAR2_TABLE_200
253: , p10_a1 out nocopy JTF_VARCHAR2_TABLE_200
254: , p10_a2 out nocopy JTF_VARCHAR2_TABLE_200
255: , p11_a0 out nocopy JTF_VARCHAR2_TABLE_200
256: , p11_a1 out nocopy JTF_VARCHAR2_TABLE_200
257: , p11_a2 out nocopy JTF_VARCHAR2_TABLE_200
258: , x_map_obj_num out nocopy NUMBER
259: , p_org_id NUMBER
260: )

Line 257: , p11_a2 out nocopy JTF_VARCHAR2_TABLE_200

253: , p10_a1 out nocopy JTF_VARCHAR2_TABLE_200
254: , p10_a2 out nocopy JTF_VARCHAR2_TABLE_200
255: , p11_a0 out nocopy JTF_VARCHAR2_TABLE_200
256: , p11_a1 out nocopy JTF_VARCHAR2_TABLE_200
257: , p11_a2 out nocopy JTF_VARCHAR2_TABLE_200
258: , x_map_obj_num out nocopy NUMBER
259: , p_org_id NUMBER
260: )
261: