DBA Data[Home] [Help]

APPS.CSI_JAVA_INTERFACE_PKG_W dependencies on CSI_JAVA_INTERFACE_PKG

Line 1: package body csi_java_interface_pkg_w as

1: package body csi_java_interface_pkg_w as
2: /* $Header: csivjiwb.pls 120.19.12010000.2 2009/05/25 05:24:52 dsingire 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_p1(t out nocopy csi_java_interface_pkg.csi_output_tbl_ib, 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_p1(t out nocopy csi_java_interface_pkg.csi_output_tbl_ib, a0 JTF_NUMBER_TABLE
26: , a1 JTF_VARCHAR2_TABLE_200
27: , a2 JTF_VARCHAR2_TABLE_200
28: , a3 JTF_VARCHAR2_TABLE_100
29: , a4 JTF_NUMBER_TABLE

Line 80: procedure rosetta_table_copy_out_p1(t csi_java_interface_pkg.csi_output_tbl_ib, a0 out nocopy JTF_NUMBER_TABLE

76: end loop;
77: end if;
78: end if;
79: end rosetta_table_copy_in_p1;
80: procedure rosetta_table_copy_out_p1(t csi_java_interface_pkg.csi_output_tbl_ib, a0 out nocopy JTF_NUMBER_TABLE
81: , a1 out nocopy JTF_VARCHAR2_TABLE_200
82: , a2 out nocopy JTF_VARCHAR2_TABLE_200
83: , a3 out nocopy JTF_VARCHAR2_TABLE_100
84: , a4 out nocopy JTF_NUMBER_TABLE

Line 194: procedure rosetta_table_copy_in_p3(t out nocopy csi_java_interface_pkg.csi_coverage_tbl_ib, a0 JTF_VARCHAR2_TABLE_100

190: end if;
191: end if;
192: end rosetta_table_copy_out_p1;
193:
194: procedure rosetta_table_copy_in_p3(t out nocopy csi_java_interface_pkg.csi_coverage_tbl_ib, a0 JTF_VARCHAR2_TABLE_100
195: , a1 JTF_NUMBER_TABLE
196: ) as
197: ddindx binary_integer; indx binary_integer;
198: begin

Line 215: procedure rosetta_table_copy_out_p3(t csi_java_interface_pkg.csi_coverage_tbl_ib, a0 out nocopy JTF_VARCHAR2_TABLE_100

211: end loop;
212: end if;
213: end if;
214: end rosetta_table_copy_in_p3;
215: procedure rosetta_table_copy_out_p3(t csi_java_interface_pkg.csi_coverage_tbl_ib, a0 out nocopy JTF_VARCHAR2_TABLE_100
216: , a1 out nocopy JTF_NUMBER_TABLE
217: ) as
218: ddindx binary_integer; indx binary_integer;
219: begin

Line 244: procedure rosetta_table_copy_in_p5(t out nocopy csi_java_interface_pkg.dpl_instance_tbl, a0 JTF_NUMBER_TABLE

240: end if;
241: end if;
242: end rosetta_table_copy_out_p3;
243:
244: procedure rosetta_table_copy_in_p5(t out nocopy csi_java_interface_pkg.dpl_instance_tbl, a0 JTF_NUMBER_TABLE
245: ) as
246: ddindx binary_integer; indx binary_integer;
247: begin
248: if a0 is not null and a0.count > 0 then

Line 263: procedure rosetta_table_copy_out_p5(t csi_java_interface_pkg.dpl_instance_tbl, a0 out nocopy JTF_NUMBER_TABLE

259: end loop;
260: end if;
261: end if;
262: end rosetta_table_copy_in_p5;
263: procedure rosetta_table_copy_out_p5(t csi_java_interface_pkg.dpl_instance_tbl, a0 out nocopy JTF_NUMBER_TABLE
264: ) as
265: ddindx binary_integer; indx binary_integer;
266: begin
267: if t is null or t.count = 0 then

Line 783: csi_java_interface_pkg.create_item_instance(p_api_version,

779:
780:
781:
782: -- here's the delegated call to the old PL/SQL routine
783: csi_java_interface_pkg.create_item_instance(p_api_version,
784: p_commit,
785: p_init_msg_list,
786: p_validation_level,
787: ddp_instance_rec,

Line 1535: csi_java_interface_pkg.split_item_instance(p_api_version,

1531:
1532:
1533:
1534: -- here's the delegated call to the old PL/SQL routine
1535: csi_java_interface_pkg.split_item_instance(p_api_version,
1536: p_commit,
1537: p_init_msg_list,
1538: p_validation_level,
1539: ddp_source_instance_rec,

Line 2349: csi_java_interface_pkg.split_item_instance_lines(p_api_version,

2345:
2346:
2347:
2348: -- here's the delegated call to the old PL/SQL routine
2349: csi_java_interface_pkg.split_item_instance_lines(p_api_version,
2350: p_commit,
2351: p_init_msg_list,
2352: p_validation_level,
2353: ddp_source_instance_rec,

Line 3164: csi_java_interface_pkg.copy_item_instance(p_api_version,

3160:
3161:
3162:
3163: -- here's the delegated call to the old PL/SQL routine
3164: csi_java_interface_pkg.copy_item_instance(p_api_version,
3165: p_commit,
3166: p_init_msg_list,
3167: p_validation_level,
3168: ddp_source_instance_rec,

Line 3393: ddx_output_contracts csi_java_interface_pkg.csi_output_tbl_ib;

3389: , p4_a18 out nocopy JTF_DATE_TABLE
3390: )
3391:
3392: as
3393: ddx_output_contracts csi_java_interface_pkg.csi_output_tbl_ib;
3394: ddindx binary_integer; indx binary_integer;
3395: begin
3396:
3397: -- copy data to the local IN or IN-OUT args, if any

Line 3404: csi_java_interface_pkg.getcontracts(product_id,

3400:
3401:
3402:
3403: -- here's the delegated call to the old PL/SQL routine
3404: csi_java_interface_pkg.getcontracts(product_id,
3405: x_return_status,
3406: x_msg_count,
3407: x_msg_data,
3408: ddx_output_contracts);

Line 3415: csi_java_interface_pkg_w.rosetta_table_copy_out_p1(ddx_output_contracts, p4_a0

3411:
3412:
3413:
3414:
3415: csi_java_interface_pkg_w.rosetta_table_copy_out_p1(ddx_output_contracts, p4_a0
3416: , p4_a1
3417: , p4_a2
3418: , p4_a3
3419: , p4_a4

Line 3447: ddx_coverage_tbl csi_java_interface_pkg.csi_coverage_tbl_ib;

3443: , x_msg_data out nocopy VARCHAR2
3444: )
3445:
3446: as
3447: ddx_coverage_tbl csi_java_interface_pkg.csi_coverage_tbl_ib;
3448: ddindx binary_integer; indx binary_integer;
3449: begin
3450:
3451: -- copy data to the local IN or IN-OUT args, if any

Line 3459: csi_java_interface_pkg.get_coverage_for_prod_sch(contract_number,

3455:
3456:
3457:
3458: -- here's the delegated call to the old PL/SQL routine
3459: csi_java_interface_pkg.get_coverage_for_prod_sch(contract_number,
3460: ddx_coverage_tbl,
3461: x_sequence_id,
3462: x_return_status,
3463: x_msg_count,

Line 3468: csi_java_interface_pkg_w.rosetta_table_copy_out_p3(ddx_coverage_tbl, p1_a0

3464: x_msg_data);
3465:
3466: -- copy data back from the local variables to OUT or IN-OUT args, if any
3467:
3468: csi_java_interface_pkg_w.rosetta_table_copy_out_p3(ddx_coverage_tbl, p1_a0
3469: , p1_a1
3470: );
3471:
3472:

Line 4242: csi_java_interface_pkg.get_history_transactions(p_api_version,

4238:
4239:
4240:
4241: -- here's the delegated call to the old PL/SQL routine
4242: csi_java_interface_pkg.get_history_transactions(p_api_version,
4243: p_commit,
4244: p_init_msg_list,
4245: p_validation_level,
4246: p_transaction_id,

Line 5053: csi_java_interface_pkg.get_instance_link_locations(p_api_version,

5049:
5050:
5051:
5052: -- here's the delegated call to the old PL/SQL routine
5053: csi_java_interface_pkg.get_instance_link_locations(p_api_version,
5054: p_commit,
5055: p_init_msg_list,
5056: p_validation_level,
5057: p_instance_id,

Line 5137: csi_java_interface_pkg.get_contact_details(p_api_version,

5133:
5134:
5135:
5136: -- here's the delegated call to the old PL/SQL routine
5137: csi_java_interface_pkg.get_contact_details(p_api_version,
5138: p_commit,
5139: p_init_msg_list,
5140: p_validation_level,
5141: p_contact_party_id,

Line 5194: csi_java_interface_pkg.bld_instance_all_parents_tbl(p_subject_id,

5190:
5191: ddp_time_stamp := rosetta_g_miss_date_in_map(p_time_stamp);
5192:
5193: -- here's the delegated call to the old PL/SQL routine
5194: csi_java_interface_pkg.bld_instance_all_parents_tbl(p_subject_id,
5195: p_relationship_type_code,
5196: ddp_time_stamp);
5197:
5198: -- copy data back from the local variables to OUT or IN-OUT args, if any

Line 5218: ddrosetta_retval := csi_java_interface_pkg.get_instance_all_parents(p_subject_id,

5214:
5215: ddp_time_stamp := rosetta_g_miss_date_in_map(p_time_stamp);
5216:
5217: -- here's the delegated call to the old PL/SQL routine
5218: ddrosetta_retval := csi_java_interface_pkg.get_instance_all_parents(p_subject_id,
5219: ddp_time_stamp);
5220:
5221: -- copy data back from the local variables to OUT or IN-OUT args, if any
5222:

Line 5336: csi_java_interface_pkg.expire_relationship(p_api_version,

5332:
5333:
5334:
5335: -- here's the delegated call to the old PL/SQL routine
5336: csi_java_interface_pkg.expire_relationship(p_api_version,
5337: p_commit,
5338: p_init_msg_list,
5339: p_validation_level,
5340: p_subject_id,

Line 5404: ddp_instance_tbl csi_java_interface_pkg.dpl_instance_tbl;

5400: function get_instance_ids(p0_a0 in out nocopy JTF_NUMBER_TABLE
5401: ) return varchar2
5402:
5403: as
5404: ddp_instance_tbl csi_java_interface_pkg.dpl_instance_tbl;
5405: ddindx binary_integer; indx binary_integer;
5406: ddrosetta_retval varchar2(4000);
5407: begin
5408:

Line 5410: csi_java_interface_pkg_w.rosetta_table_copy_in_p5(ddp_instance_tbl, p0_a0

5406: ddrosetta_retval varchar2(4000);
5407: begin
5408:
5409: -- copy data to the local IN or IN-OUT args, if any
5410: csi_java_interface_pkg_w.rosetta_table_copy_in_p5(ddp_instance_tbl, p0_a0
5411: );
5412:
5413: -- here's the delegated call to the old PL/SQL routine
5414: ddrosetta_retval := csi_java_interface_pkg.get_instance_ids(ddp_instance_tbl);

Line 5414: ddrosetta_retval := csi_java_interface_pkg.get_instance_ids(ddp_instance_tbl);

5410: csi_java_interface_pkg_w.rosetta_table_copy_in_p5(ddp_instance_tbl, p0_a0
5411: );
5412:
5413: -- here's the delegated call to the old PL/SQL routine
5414: ddrosetta_retval := csi_java_interface_pkg.get_instance_ids(ddp_instance_tbl);
5415:
5416: -- copy data back from the local variables to OUT or IN-OUT args, if any
5417: csi_java_interface_pkg_w.rosetta_table_copy_out_p5(ddp_instance_tbl, p0_a0
5418: );

Line 5417: csi_java_interface_pkg_w.rosetta_table_copy_out_p5(ddp_instance_tbl, p0_a0

5413: -- here's the delegated call to the old PL/SQL routine
5414: ddrosetta_retval := csi_java_interface_pkg.get_instance_ids(ddp_instance_tbl);
5415:
5416: -- copy data back from the local variables to OUT or IN-OUT args, if any
5417: csi_java_interface_pkg_w.rosetta_table_copy_out_p5(ddp_instance_tbl, p0_a0
5418: );
5419:
5420: return ddrosetta_retval;
5421: end;

Line 5423: end csi_java_interface_pkg_w;

5419:
5420: return ddrosetta_retval;
5421: end;
5422:
5423: end csi_java_interface_pkg_w;