DBA Data[Home] [Help]

APPS.CSI_MASS_EDIT_PUB_W dependencies on CSI_MASS_EDIT_PUB

Line 1: package body csi_mass_edit_pub_w as

1: package body csi_mass_edit_pub_w as
2: /* $Header: csipmewb.pls 120.5.12010000.3 2008/12/03 08:33:43 ngoutam ship $ */
3: rosetta_g_mistake_date date := to_date('01/01/+4713', 'MM/DD/SYYYY');
4: rosetta_g_miss_date date := to_date('01/01/-4712', 'MM/DD/SYYYY');
5: rosetta_g_mistake_date_high date := to_date('01/01/+4710', 'MM/DD/SYYYY');

Line 25: procedure rosetta_table_copy_in_p4(t out nocopy csi_mass_edit_pub.mass_edit_tbl, a0 JTF_NUMBER_TABLE

21: if n=b then return a; end if;
22: return n;
23: end;
24:
25: procedure rosetta_table_copy_in_p4(t out nocopy csi_mass_edit_pub.mass_edit_tbl, a0 JTF_NUMBER_TABLE
26: , a1 JTF_VARCHAR2_TABLE_100
27: , a2 JTF_NUMBER_TABLE
28: , a3 JTF_NUMBER_TABLE
29: , a4 JTF_VARCHAR2_TABLE_100

Line 66: procedure rosetta_table_copy_out_p4(t csi_mass_edit_pub.mass_edit_tbl, a0 out nocopy JTF_NUMBER_TABLE

62: end loop;
63: end if;
64: end if;
65: end rosetta_table_copy_in_p4;
66: procedure rosetta_table_copy_out_p4(t csi_mass_edit_pub.mass_edit_tbl, a0 out nocopy JTF_NUMBER_TABLE
67: , a1 out nocopy JTF_VARCHAR2_TABLE_100
68: , a2 out nocopy JTF_NUMBER_TABLE
69: , a3 out nocopy JTF_NUMBER_TABLE
70: , a4 out nocopy JTF_VARCHAR2_TABLE_100

Line 145: procedure rosetta_table_copy_in_p6(t out nocopy csi_mass_edit_pub.mass_edit_inst_tbl, a0 JTF_NUMBER_TABLE

141: end if;
142: end if;
143: end rosetta_table_copy_out_p4;
144:
145: procedure rosetta_table_copy_in_p6(t out nocopy csi_mass_edit_pub.mass_edit_inst_tbl, a0 JTF_NUMBER_TABLE
146: , a1 JTF_NUMBER_TABLE
147: , a2 JTF_DATE_TABLE
148: , a3 JTF_NUMBER_TABLE
149: ) as

Line 170: procedure rosetta_table_copy_out_p6(t csi_mass_edit_pub.mass_edit_inst_tbl, a0 out nocopy JTF_NUMBER_TABLE

166: end loop;
167: end if;
168: end if;
169: end rosetta_table_copy_in_p6;
170: procedure rosetta_table_copy_out_p6(t csi_mass_edit_pub.mass_edit_inst_tbl, a0 out nocopy JTF_NUMBER_TABLE
171: , a1 out nocopy JTF_NUMBER_TABLE
172: , a2 out nocopy JTF_DATE_TABLE
173: , a3 out nocopy JTF_NUMBER_TABLE
174: ) as

Line 209: procedure rosetta_table_copy_in_p8(t out nocopy csi_mass_edit_pub.mass_edit_error_tbl, a0 JTF_NUMBER_TABLE

205: end if;
206: end if;
207: end rosetta_table_copy_out_p6;
208:
209: procedure rosetta_table_copy_in_p8(t out nocopy csi_mass_edit_pub.mass_edit_error_tbl, a0 JTF_NUMBER_TABLE
210: , a1 JTF_NUMBER_TABLE
211: , a2 JTF_NUMBER_TABLE
212: , a3 JTF_VARCHAR2_TABLE_2000
213: , a4 JTF_VARCHAR2_TABLE_100

Line 238: procedure rosetta_table_copy_out_p8(t csi_mass_edit_pub.mass_edit_error_tbl, a0 out nocopy JTF_NUMBER_TABLE

234: end loop;
235: end if;
236: end if;
237: end rosetta_table_copy_in_p8;
238: procedure rosetta_table_copy_out_p8(t csi_mass_edit_pub.mass_edit_error_tbl, a0 out nocopy JTF_NUMBER_TABLE
239: , a1 out nocopy JTF_NUMBER_TABLE
240: , a2 out nocopy JTF_NUMBER_TABLE
241: , a3 out nocopy JTF_VARCHAR2_TABLE_2000
242: , a4 out nocopy JTF_VARCHAR2_TABLE_100

Line 287: procedure rosetta_table_copy_in_p10(t out nocopy csi_mass_edit_pub.mass_edit_sys_error_tbl, a0 JTF_NUMBER_TABLE

283: end if;
284: end if;
285: end rosetta_table_copy_out_p8;
286:
287: procedure rosetta_table_copy_in_p10(t out nocopy csi_mass_edit_pub.mass_edit_sys_error_tbl, a0 JTF_NUMBER_TABLE
288: , a1 JTF_VARCHAR2_TABLE_100
289: , a2 JTF_NUMBER_TABLE
290: , a3 JTF_NUMBER_TABLE
291: , a4 JTF_VARCHAR2_TABLE_2000

Line 318: procedure rosetta_table_copy_out_p10(t csi_mass_edit_pub.mass_edit_sys_error_tbl, a0 out nocopy JTF_NUMBER_TABLE

314: end loop;
315: end if;
316: end if;
317: end rosetta_table_copy_in_p10;
318: procedure rosetta_table_copy_out_p10(t csi_mass_edit_pub.mass_edit_sys_error_tbl, a0 out nocopy JTF_NUMBER_TABLE
319: , a1 out nocopy JTF_VARCHAR2_TABLE_100
320: , a2 out nocopy JTF_NUMBER_TABLE
321: , a3 out nocopy JTF_NUMBER_TABLE
322: , a4 out nocopy JTF_VARCHAR2_TABLE_2000

Line 372: procedure rosetta_table_copy_in_p12(t out nocopy csi_mass_edit_pub.mass_upd_rep_error_tbl, a0 JTF_NUMBER_TABLE

368: end if;
369: end if;
370: end rosetta_table_copy_out_p10;
371:
372: procedure rosetta_table_copy_in_p12(t out nocopy csi_mass_edit_pub.mass_upd_rep_error_tbl, a0 JTF_NUMBER_TABLE
373: , a1 JTF_VARCHAR2_TABLE_100
374: , a2 JTF_VARCHAR2_TABLE_2000
375: , a3 JTF_NUMBER_TABLE
376: , a4 JTF_NUMBER_TABLE

Line 403: procedure rosetta_table_copy_out_p12(t csi_mass_edit_pub.mass_upd_rep_error_tbl, a0 out nocopy JTF_NUMBER_TABLE

399: end loop;
400: end if;
401: end if;
402: end rosetta_table_copy_in_p12;
403: procedure rosetta_table_copy_out_p12(t csi_mass_edit_pub.mass_upd_rep_error_tbl, a0 out nocopy JTF_NUMBER_TABLE
404: , a1 out nocopy JTF_VARCHAR2_TABLE_100
405: , a2 out nocopy JTF_VARCHAR2_TABLE_2000
406: , a3 out nocopy JTF_NUMBER_TABLE
407: , a4 out nocopy JTF_NUMBER_TABLE

Line 683: ddpx_mass_edit_rec csi_mass_edit_pub.mass_edit_rec;

679: , x_msg_data out nocopy VARCHAR2
680: )
681:
682: as
683: ddpx_mass_edit_rec csi_mass_edit_pub.mass_edit_rec;
684: ddpx_txn_line_rec csi_t_datastructures_grp.txn_line_rec;
685: ddpx_mass_edit_inst_tbl csi_mass_edit_pub.mass_edit_inst_tbl;
686: ddpx_txn_line_detail_rec csi_t_datastructures_grp.txn_line_detail_rec;
687: ddpx_txn_party_detail_tbl csi_t_datastructures_grp.txn_party_detail_tbl;

Line 685: ddpx_mass_edit_inst_tbl csi_mass_edit_pub.mass_edit_inst_tbl;

681:
682: as
683: ddpx_mass_edit_rec csi_mass_edit_pub.mass_edit_rec;
684: ddpx_txn_line_rec csi_t_datastructures_grp.txn_line_rec;
685: ddpx_mass_edit_inst_tbl csi_mass_edit_pub.mass_edit_inst_tbl;
686: ddpx_txn_line_detail_rec csi_t_datastructures_grp.txn_line_detail_rec;
687: ddpx_txn_party_detail_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
688: ddpx_txn_pty_acct_detail_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
689: ddpx_txn_ext_attrib_vals_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;

Line 690: ddx_mass_edit_error_tbl csi_mass_edit_pub.mass_edit_error_tbl;

686: ddpx_txn_line_detail_rec csi_t_datastructures_grp.txn_line_detail_rec;
687: ddpx_txn_party_detail_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
688: ddpx_txn_pty_acct_detail_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
689: ddpx_txn_ext_attrib_vals_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;
690: ddx_mass_edit_error_tbl csi_mass_edit_pub.mass_edit_error_tbl;
691: ddindx binary_integer; indx binary_integer;
692: begin
693:
694: -- copy data to the local IN or IN-OUT args, if any

Line 745: csi_mass_edit_pub_w.rosetta_table_copy_in_p6(ddpx_mass_edit_inst_tbl, p6_a0

741: ddpx_txn_line_rec.attribute14 := p5_a29;
742: ddpx_txn_line_rec.attribute15 := p5_a30;
743: ddpx_txn_line_rec.object_version_number := rosetta_g_miss_num_map(p5_a31);
744:
745: csi_mass_edit_pub_w.rosetta_table_copy_in_p6(ddpx_mass_edit_inst_tbl, p6_a0
746: , p6_a1
747: , p6_a2
748: , p6_a3
749: );

Line 925: csi_mass_edit_pub.create_mass_edit_batch(p_api_version,

921:
922:
923:
924: -- here's the delegated call to the old PL/SQL routine
925: csi_mass_edit_pub.create_mass_edit_batch(p_api_version,
926: p_commit,
927: p_init_msg_list,
928: p_validation_level,
929: ddpx_mass_edit_rec,

Line 992: csi_mass_edit_pub_w.rosetta_table_copy_out_p6(ddpx_mass_edit_inst_tbl, p6_a0

988: p5_a29 := ddpx_txn_line_rec.attribute14;
989: p5_a30 := ddpx_txn_line_rec.attribute15;
990: p5_a31 := rosetta_g_miss_num_map(ddpx_txn_line_rec.object_version_number);
991:
992: csi_mass_edit_pub_w.rosetta_table_copy_out_p6(ddpx_mass_edit_inst_tbl, p6_a0
993: , p6_a1
994: , p6_a2
995: , p6_a3
996: );

Line 1167: csi_mass_edit_pub_w.rosetta_table_copy_out_p8(ddx_mass_edit_error_tbl, p11_a0

1163: , p10_a28
1164: , p10_a29
1165: );
1166:
1167: csi_mass_edit_pub_w.rosetta_table_copy_out_p8(ddx_mass_edit_error_tbl, p11_a0
1168: , p11_a1
1169: , p11_a2
1170: , p11_a3
1171: , p11_a4

Line 1405: ddpx_mass_edit_rec csi_mass_edit_pub.mass_edit_rec;

1401: , x_msg_data out nocopy VARCHAR2
1402: )
1403:
1404: as
1405: ddpx_mass_edit_rec csi_mass_edit_pub.mass_edit_rec;
1406: ddpx_txn_line_rec csi_t_datastructures_grp.txn_line_rec;
1407: ddpx_mass_edit_inst_tbl csi_mass_edit_pub.mass_edit_inst_tbl;
1408: ddpx_txn_line_detail_rec csi_t_datastructures_grp.txn_line_detail_rec;
1409: ddpx_txn_party_detail_tbl csi_t_datastructures_grp.txn_party_detail_tbl;

Line 1407: ddpx_mass_edit_inst_tbl csi_mass_edit_pub.mass_edit_inst_tbl;

1403:
1404: as
1405: ddpx_mass_edit_rec csi_mass_edit_pub.mass_edit_rec;
1406: ddpx_txn_line_rec csi_t_datastructures_grp.txn_line_rec;
1407: ddpx_mass_edit_inst_tbl csi_mass_edit_pub.mass_edit_inst_tbl;
1408: ddpx_txn_line_detail_rec csi_t_datastructures_grp.txn_line_detail_rec;
1409: ddpx_txn_party_detail_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
1410: ddpx_txn_pty_acct_detail_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
1411: ddpx_txn_ext_attrib_vals_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;

Line 1412: ddx_mass_edit_error_tbl csi_mass_edit_pub.mass_edit_error_tbl;

1408: ddpx_txn_line_detail_rec csi_t_datastructures_grp.txn_line_detail_rec;
1409: ddpx_txn_party_detail_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
1410: ddpx_txn_pty_acct_detail_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
1411: ddpx_txn_ext_attrib_vals_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;
1412: ddx_mass_edit_error_tbl csi_mass_edit_pub.mass_edit_error_tbl;
1413: ddindx binary_integer; indx binary_integer;
1414: begin
1415:
1416: -- copy data to the local IN or IN-OUT args, if any

Line 1467: csi_mass_edit_pub_w.rosetta_table_copy_in_p6(ddpx_mass_edit_inst_tbl, p6_a0

1463: ddpx_txn_line_rec.attribute14 := p5_a29;
1464: ddpx_txn_line_rec.attribute15 := p5_a30;
1465: ddpx_txn_line_rec.object_version_number := rosetta_g_miss_num_map(p5_a31);
1466:
1467: csi_mass_edit_pub_w.rosetta_table_copy_in_p6(ddpx_mass_edit_inst_tbl, p6_a0
1468: , p6_a1
1469: , p6_a2
1470: , p6_a3
1471: );

Line 1647: csi_mass_edit_pub.update_mass_edit_batch(p_api_version,

1643:
1644:
1645:
1646: -- here's the delegated call to the old PL/SQL routine
1647: csi_mass_edit_pub.update_mass_edit_batch(p_api_version,
1648: p_commit,
1649: p_init_msg_list,
1650: p_validation_level,
1651: ddpx_mass_edit_rec,

Line 1714: csi_mass_edit_pub_w.rosetta_table_copy_out_p6(ddpx_mass_edit_inst_tbl, p6_a0

1710: p5_a29 := ddpx_txn_line_rec.attribute14;
1711: p5_a30 := ddpx_txn_line_rec.attribute15;
1712: p5_a31 := rosetta_g_miss_num_map(ddpx_txn_line_rec.object_version_number);
1713:
1714: csi_mass_edit_pub_w.rosetta_table_copy_out_p6(ddpx_mass_edit_inst_tbl, p6_a0
1715: , p6_a1
1716: , p6_a2
1717: , p6_a3
1718: );

Line 1889: csi_mass_edit_pub_w.rosetta_table_copy_out_p8(ddx_mass_edit_error_tbl, p11_a0

1885: , p10_a28
1886: , p10_a29
1887: );
1888:
1889: csi_mass_edit_pub_w.rosetta_table_copy_out_p8(ddx_mass_edit_error_tbl, p11_a0
1890: , p11_a1
1891: , p11_a2
1892: , p11_a3
1893: , p11_a4

Line 1923: ddp_mass_edit_rec csi_mass_edit_pub.mass_edit_rec;

1919: , p4_a11 VARCHAR2 := fnd_api.g_miss_char
1920: )
1921:
1922: as
1923: ddp_mass_edit_rec csi_mass_edit_pub.mass_edit_rec;
1924: ddindx binary_integer; indx binary_integer;
1925: begin
1926:
1927: -- copy data to the local IN or IN-OUT args, if any

Line 1949: csi_mass_edit_pub.delete_mass_edit_batch(p_api_version,

1945:
1946:
1947:
1948: -- here's the delegated call to the old PL/SQL routine
1949: csi_mass_edit_pub.delete_mass_edit_batch(p_api_version,
1950: p_commit,
1951: p_init_msg_list,
1952: p_validation_level,
1953: ddp_mass_edit_rec,

Line 1990: ddp_mass_edit_tbl csi_mass_edit_pub.mass_edit_tbl;

1986: , x_msg_data out nocopy VARCHAR2
1987: )
1988:
1989: as
1990: ddp_mass_edit_tbl csi_mass_edit_pub.mass_edit_tbl;
1991: ddindx binary_integer; indx binary_integer;
1992: begin
1993:
1994: -- copy data to the local IN or IN-OUT args, if any

Line 1999: csi_mass_edit_pub_w.rosetta_table_copy_in_p4(ddp_mass_edit_tbl, p4_a0

1995:
1996:
1997:
1998:
1999: csi_mass_edit_pub_w.rosetta_table_copy_in_p4(ddp_mass_edit_tbl, p4_a0
2000: , p4_a1
2001: , p4_a2
2002: , p4_a3
2003: , p4_a4

Line 2017: csi_mass_edit_pub.delete_mass_edit_batches(p_api_version,

2013:
2014:
2015:
2016: -- here's the delegated call to the old PL/SQL routine
2017: csi_mass_edit_pub.delete_mass_edit_batches(p_api_version,
2018: p_commit,
2019: p_init_msg_list,
2020: p_validation_level,
2021: ddp_mass_edit_tbl,

Line 2220: ddpx_mass_edit_rec csi_mass_edit_pub.mass_edit_rec;

2216: , x_msg_data out nocopy VARCHAR2
2217: )
2218:
2219: as
2220: ddpx_mass_edit_rec csi_mass_edit_pub.mass_edit_rec;
2221: ddx_txn_line_detail_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
2222: ddx_txn_party_detail_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
2223: ddx_txn_pty_acct_detail_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
2224: ddx_txn_ext_attrib_vals_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;

Line 2254: csi_mass_edit_pub.get_mass_edit_details(p_api_version,

2250:
2251:
2252:
2253: -- here's the delegated call to the old PL/SQL routine
2254: csi_mass_edit_pub.get_mass_edit_details(p_api_version,
2255: p_commit,
2256: p_init_msg_list,
2257: p_validation_level,
2258: ddpx_mass_edit_rec,

Line 3007: csi_mass_edit_pub.process_system_mass_update(p_api_version,

3003:
3004:
3005:
3006: -- here's the delegated call to the old PL/SQL routine
3007: csi_mass_edit_pub.process_system_mass_update(p_api_version,
3008: p_commit,
3009: p_entry_id,
3010: ddp_instance_tbl,
3011: ddp_ext_attrib_values_tbl,

Line 3308: csi_mass_edit_pub.identify_system_for_update(p_txn_line_id,

3304:
3305:
3306:
3307: -- here's the delegated call to the old PL/SQL routine
3308: csi_mass_edit_pub.identify_system_for_update(p_txn_line_id,
3309: ddp_upd_system_tbl,
3310: x_return_status);
3311:
3312: -- copy data back from the local variables to OUT or IN-OUT args, if any

Line 3338: csi_mass_edit_pub.validate_system_batch(p_entry_id,

3334: );
3335:
3336:
3337: -- here's the delegated call to the old PL/SQL routine
3338: csi_mass_edit_pub.validate_system_batch(p_entry_id,
3339: p_txn_line_id,
3340: ddp_upd_system_tbl,
3341: x_return_status);
3342:

Line 3349: end csi_mass_edit_pub_w;

3345:
3346:
3347: end;
3348:
3349: end csi_mass_edit_pub_w;