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.12010000.2 2009/05/22 20:04:40 hyonlee 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 3370: csi_item_instance_pub.get_item_instances(p_api_version,

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

Line 4307: csi_item_instance_pub.get_item_instance_details(p_api_version,

4303:
4304:
4305:
4306: -- here's the delegated call to the old PL/SQL routine
4307: csi_item_instance_pub.get_item_instance_details(p_api_version,
4308: p_commit,
4309: p_init_msg_list,
4310: p_validation_level,
4311: ddp_instance_rec,

Line 4918: csi_item_instance_pub.get_version_labels(p_api_version,

4914:
4915:
4916:
4917: -- here's the delegated call to the old PL/SQL routine
4918: csi_item_instance_pub.get_version_labels(p_api_version,
4919: p_commit,
4920: p_init_msg_list,
4921: p_validation_level,
4922: ddp_version_label_query_rec,

Line 5121: csi_item_instance_pub.create_version_label(p_api_version,

5117:
5118:
5119:
5120: -- here's the delegated call to the old PL/SQL routine
5121: csi_item_instance_pub.create_version_label(p_api_version,
5122: p_commit,
5123: p_init_msg_list,
5124: p_validation_level,
5125: ddp_version_label_tbl,

Line 5362: csi_item_instance_pub.update_version_label(p_api_version,

5358:
5359:
5360:
5361: -- here's the delegated call to the old PL/SQL routine
5362: csi_item_instance_pub.update_version_label(p_api_version,
5363: p_commit,
5364: p_init_msg_list,
5365: p_validation_level,
5366: ddp_version_label_tbl,

Line 5578: csi_item_instance_pub.expire_version_label(p_api_version,

5574:
5575:
5576:
5577: -- here's the delegated call to the old PL/SQL routine
5578: csi_item_instance_pub.expire_version_label(p_api_version,
5579: p_commit,
5580: p_init_msg_list,
5581: p_validation_level,
5582: ddp_version_label_tbl,

Line 5731: csi_item_instance_pub.get_extended_attrib_values(p_api_version,

5727:
5728:
5729:
5730: -- here's the delegated call to the old PL/SQL routine
5731: csi_item_instance_pub.get_extended_attrib_values(p_api_version,
5732: p_commit,
5733: p_init_msg_list,
5734: p_validation_level,
5735: ddp_ext_attribs_query_rec,

Line 5969: csi_item_instance_pub.create_extended_attrib_values(p_api_version,

5965:
5966:
5967:
5968: -- here's the delegated call to the old PL/SQL routine
5969: csi_item_instance_pub.create_extended_attrib_values(p_api_version,
5970: p_commit,
5971: p_init_msg_list,
5972: p_validation_level,
5973: ddp_ext_attrib_tbl,

Line 6213: csi_item_instance_pub.update_extended_attrib_values(p_api_version,

6209:
6210:
6211:
6212: -- here's the delegated call to the old PL/SQL routine
6213: csi_item_instance_pub.update_extended_attrib_values(p_api_version,
6214: p_commit,
6215: p_init_msg_list,
6216: p_validation_level,
6217: ddp_ext_attrib_tbl,

Line 6431: csi_item_instance_pub.expire_extended_attrib_values(p_api_version,

6427:
6428:
6429:
6430: -- here's the delegated call to the old PL/SQL routine
6431: csi_item_instance_pub.expire_extended_attrib_values(p_api_version,
6432: p_commit,
6433: p_init_msg_list,
6434: p_validation_level,
6435: ddp_ext_attrib_tbl,

Line 6985: csi_item_instance_pub.copy_item_instance(p_api_version,

6981:
6982:
6983:
6984: -- here's the delegated call to the old PL/SQL routine
6985: csi_item_instance_pub.copy_item_instance(p_api_version,
6986: p_commit,
6987: p_init_msg_list,
6988: p_validation_level,
6989: ddp_source_instance_rec,

Line 7327: ddx_txn_type_tbl csi_item_instance_pub.txn_oks_type_tbl;

7323: )
7324:
7325: as
7326: ddp_instance_rec csi_datastructures_pub.instance_rec;
7327: ddx_txn_type_tbl csi_item_instance_pub.txn_oks_type_tbl;
7328: ddpx_txn_date date;
7329: ddindx binary_integer; indx binary_integer;
7330: begin
7331:

Line 7471: csi_item_instance_pub.get_oks_txn_types(p_api_version,

7467:
7468:
7469:
7470: -- here's the delegated call to the old PL/SQL routine
7471: csi_item_instance_pub.get_oks_txn_types(p_api_version,
7472: p_commit,
7473: p_init_msg_list,
7474: ddp_instance_rec,
7475: p_check_contracts_yn,

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

7488:
7489:
7490:
7491:
7492: csi_item_instance_pub_w.rosetta_table_copy_out_p14(ddx_txn_type_tbl, x_txn_type_tbl);
7493:
7494:
7495: px_txn_date := ddpx_txn_date;
7496:

Line 7502: end csi_item_instance_pub_w;

7498:
7499:
7500: end;
7501:
7502: end csi_item_instance_pub_w;