APPS.CSI_ITEM_INSTANCE_PUB_W dependencies on CSI_ITEM_INSTANCE_PUB

Line 1: package body csi_item_instance_pub_w as

1: package body csi_item_instance_pub_w as
2: /* $Header: csipiiwb.pls 120.18 2008/01/15 03:37:50 devijay 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_p14(t out nocopy csi_item_instance_pub.txn_oks_type_tbl, a0 JTF_VARCHAR2_TABLE_100) as

21: if n=b then return a; end if;
22: return n;
23: end;
24:
25: procedure rosetta_table_copy_in_p14(t out nocopy csi_item_instance_pub.txn_oks_type_tbl, a0 JTF_VARCHAR2_TABLE_100) as
26: ddindx binary_integer; indx binary_integer;
27: begin
28: if a0 is not null and a0.count > 0 then
29: if a0.count > 0 then

Line 43: procedure rosetta_table_copy_out_p14(t csi_item_instance_pub.txn_oks_type_tbl, a0 out nocopy JTF_VARCHAR2_TABLE_100) as

39: end loop;
40: end if;
41: end if;
42: end rosetta_table_copy_in_p14;
43: procedure rosetta_table_copy_out_p14(t csi_item_instance_pub.txn_oks_type_tbl, a0 out nocopy JTF_VARCHAR2_TABLE_100) as
44: ddindx binary_integer; indx binary_integer;
45: begin
46: if t is null or t.count = 0 then
47: a0 := JTF_VARCHAR2_TABLE_100();

Line 950: csi_item_instance_pub.create_item_instance(p_api_version,

946:
947:
948:
949: -- here's the delegated call to the old PL/SQL routine
950: csi_item_instance_pub.create_item_instance(p_api_version,
951: p_commit,
952: p_init_msg_list,
953: p_validation_level,
954: ddp_instance_rec,

Line 2296: csi_item_instance_pub.update_item_instance(p_api_version,

2292:
2293:
2294:
2295: -- here's the delegated call to the old PL/SQL routine
2296: csi_item_instance_pub.update_item_instance(p_api_version,
2297: p_commit,
2298: p_init_msg_list,
2299: p_validation_level,
2300: ddp_instance_rec,

Line 2992: csi_item_instance_pub.expire_item_instance(p_api_version,

2988:
2989:
2990:
2991: -- here's the delegated call to the old PL/SQL routine
2992: csi_item_instance_pub.expire_item_instance(p_api_version,
2993: p_commit,
2994: p_init_msg_list,
2995: p_validation_level,
2996: ddp_instance_rec,

Line 3369: csi_item_instance_pub.get_item_instances(p_api_version,

3365:
3366:
3367:
3368: -- here's the delegated call to the old PL/SQL routine
3369: csi_item_instance_pub.get_item_instances(p_api_version,
3370: p_commit,
3371: p_init_msg_list,
3372: p_validation_level,
3373: ddp_instance_query_rec,

Line 4303: csi_item_instance_pub.get_item_instance_details(p_api_version,

4299:
4300:
4301:
4302: -- here's the delegated call to the old PL/SQL routine
4303: csi_item_instance_pub.get_item_instance_details(p_api_version,
4304: p_commit,
4305: p_init_msg_list,
4306: p_validation_level,
4307: ddp_instance_rec,

Line 4913: csi_item_instance_pub.get_version_labels(p_api_version,

4909:
4910:
4911:
4912: -- here's the delegated call to the old PL/SQL routine
4913: csi_item_instance_pub.get_version_labels(p_api_version,
4914: p_commit,
4915: p_init_msg_list,
4916: p_validation_level,
4917: ddp_version_label_query_rec,

Line 5116: csi_item_instance_pub.create_version_label(p_api_version,

5112:
5113:
5114:
5115: -- here's the delegated call to the old PL/SQL routine
5116: csi_item_instance_pub.create_version_label(p_api_version,
5117: p_commit,
5118: p_init_msg_list,
5119: p_validation_level,
5120: ddp_version_label_tbl,

Line 5357: csi_item_instance_pub.update_version_label(p_api_version,

5353:
5354:
5355:
5356: -- here's the delegated call to the old PL/SQL routine
5357: csi_item_instance_pub.update_version_label(p_api_version,
5358: p_commit,
5359: p_init_msg_list,
5360: p_validation_level,
5361: ddp_version_label_tbl,

Line 5573: csi_item_instance_pub.expire_version_label(p_api_version,

5569:
5570:
5571:
5572: -- here's the delegated call to the old PL/SQL routine
5573: csi_item_instance_pub.expire_version_label(p_api_version,
5574: p_commit,
5575: p_init_msg_list,
5576: p_validation_level,
5577: ddp_version_label_tbl,

Line 5726: csi_item_instance_pub.get_extended_attrib_values(p_api_version,

5722:
5723:
5724:
5725: -- here's the delegated call to the old PL/SQL routine
5726: csi_item_instance_pub.get_extended_attrib_values(p_api_version,
5727: p_commit,
5728: p_init_msg_list,
5729: p_validation_level,
5730: ddp_ext_attribs_query_rec,

Line 5964: csi_item_instance_pub.create_extended_attrib_values(p_api_version,

5960:
5961:
5962:
5963: -- here's the delegated call to the old PL/SQL routine
5964: csi_item_instance_pub.create_extended_attrib_values(p_api_version,
5965: p_commit,
5966: p_init_msg_list,
5967: p_validation_level,
5968: ddp_ext_attrib_tbl,

Line 6208: csi_item_instance_pub.update_extended_attrib_values(p_api_version,

6204:
6205:
6206:
6207: -- here's the delegated call to the old PL/SQL routine
6208: csi_item_instance_pub.update_extended_attrib_values(p_api_version,
6209: p_commit,
6210: p_init_msg_list,
6211: p_validation_level,
6212: ddp_ext_attrib_tbl,

Line 6426: csi_item_instance_pub.expire_extended_attrib_values(p_api_version,

6422:
6423:
6424:
6425: -- here's the delegated call to the old PL/SQL routine
6426: csi_item_instance_pub.expire_extended_attrib_values(p_api_version,
6427: p_commit,
6428: p_init_msg_list,
6429: p_validation_level,
6430: ddp_ext_attrib_tbl,

Line 6980: csi_item_instance_pub.copy_item_instance(p_api_version,

6976:
6977:
6978:
6979: -- here's the delegated call to the old PL/SQL routine
6980: csi_item_instance_pub.copy_item_instance(p_api_version,
6981: p_commit,
6982: p_init_msg_list,
6983: p_validation_level,
6984: ddp_source_instance_rec,

Line 7322: ddx_txn_type_tbl csi_item_instance_pub.txn_oks_type_tbl;

7318: )
7319:
7320: as
7321: ddp_instance_rec csi_datastructures_pub.instance_rec;
7322: ddx_txn_type_tbl csi_item_instance_pub.txn_oks_type_tbl;
7323: ddpx_txn_date date;
7324: ddindx binary_integer; indx binary_integer;
7325: begin
7326:

Line 7466: csi_item_instance_pub.get_oks_txn_types(p_api_version,

7462:
7463:
7464:
7465: -- here's the delegated call to the old PL/SQL routine
7466: csi_item_instance_pub.get_oks_txn_types(p_api_version,
7467: p_commit,
7468: p_init_msg_list,
7469: ddp_instance_rec,
7470: p_check_contracts_yn,

Line 7487: csi_item_instance_pub_w.rosetta_table_copy_out_p14(ddx_txn_type_tbl, x_txn_type_tbl);

7483:
7484:
7485:
7486:
7487: csi_item_instance_pub_w.rosetta_table_copy_out_p14(ddx_txn_type_tbl, x_txn_type_tbl);
7488:
7489:
7490: px_txn_date := ddpx_txn_date;
7491:

Line 7497: end csi_item_instance_pub_w;

7493:
7494:
7495: end;
7496:
7497: end csi_item_instance_pub_w;