APPS.AHL_UMP_SMRINSTANCE_PVT_W dependencies on AHL_UMP_SMRINSTANCE_PVT

Line 1: package body ahl_ump_smrinstance_pvt_w as

1: package body ahl_ump_smrinstance_pvt_w as
2: /* $Header: AHLSMRWB.pls 120.4.12020000.2 2012/12/10 16:42:47 prakkum ship $ */
3: procedure rosetta_table_copy_in_p3(t out nocopy ahl_ump_smrinstance_pvt.results_mrinstance_tbl_type, a0 JTF_VARCHAR2_TABLE_100
4: , a1 JTF_VARCHAR2_TABLE_100
5: , a2 JTF_VARCHAR2_TABLE_100

Line 3: procedure rosetta_table_copy_in_p3(t out nocopy ahl_ump_smrinstance_pvt.results_mrinstance_tbl_type, a0 JTF_VARCHAR2_TABLE_100

1: package body ahl_ump_smrinstance_pvt_w as
2: /* $Header: AHLSMRWB.pls 120.4.12020000.2 2012/12/10 16:42:47 prakkum ship $ */
3: procedure rosetta_table_copy_in_p3(t out nocopy ahl_ump_smrinstance_pvt.results_mrinstance_tbl_type, a0 JTF_VARCHAR2_TABLE_100
4: , a1 JTF_VARCHAR2_TABLE_100
5: , a2 JTF_VARCHAR2_TABLE_100
6: , a3 JTF_VARCHAR2_TABLE_100
7: , a4 JTF_NUMBER_TABLE

Line 98: procedure rosetta_table_copy_out_p3(t ahl_ump_smrinstance_pvt.results_mrinstance_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_100

94: end loop;
95: end if;
96: end if;
97: end rosetta_table_copy_in_p3;
98: procedure rosetta_table_copy_out_p3(t ahl_ump_smrinstance_pvt.results_mrinstance_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_100
99: , a1 out nocopy JTF_VARCHAR2_TABLE_100
100: , a2 out nocopy JTF_VARCHAR2_TABLE_100
101: , a3 out nocopy JTF_VARCHAR2_TABLE_100
102: , a4 out nocopy JTF_NUMBER_TABLE

Line 312: procedure rosetta_table_copy_in_p7(t out nocopy ahl_ump_smrinstance_pvt.ump_bind_param_tbl_type, a0 JTF_VARCHAR2_TABLE_400

308: end if;
309: end if;
310: end rosetta_table_copy_out_p3;
311:
312: procedure rosetta_table_copy_in_p7(t out nocopy ahl_ump_smrinstance_pvt.ump_bind_param_tbl_type, a0 JTF_VARCHAR2_TABLE_400
313: ) as
314: ddindx binary_integer; indx binary_integer;
315: begin
316: if a0 is not null and a0.count > 0 then

Line 331: procedure rosetta_table_copy_out_p7(t ahl_ump_smrinstance_pvt.ump_bind_param_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_400

327: end loop;
328: end if;
329: end if;
330: end rosetta_table_copy_in_p7;
331: procedure rosetta_table_copy_out_p7(t ahl_ump_smrinstance_pvt.ump_bind_param_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_400
332: ) as
333: ddindx binary_integer; indx binary_integer;
334: begin
335: if t is null or t.count = 0 then

Line 441: ddp_search_mr_instance_rec ahl_ump_smrinstance_pvt.search_mrinstance_rec_type;

437: , x_msg_data out nocopy VARCHAR2
438: )
439:
440: as
441: ddp_search_mr_instance_rec ahl_ump_smrinstance_pvt.search_mrinstance_rec_type;
442: ddx_results_mr_instance_tbl ahl_ump_smrinstance_pvt.results_mrinstance_tbl_type;
443: ddindx binary_integer; indx binary_integer;
444: begin
445:

Line 442: ddx_results_mr_instance_tbl ahl_ump_smrinstance_pvt.results_mrinstance_tbl_type;

438: )
439:
440: as
441: ddp_search_mr_instance_rec ahl_ump_smrinstance_pvt.search_mrinstance_rec_type;
442: ddx_results_mr_instance_tbl ahl_ump_smrinstance_pvt.results_mrinstance_tbl_type;
443: ddindx binary_integer; indx binary_integer;
444: begin
445:
446: -- copy data to the local IN or IN-OUT args, if any

Line 493: ahl_ump_smrinstance_pvt.search_mr_instances(p_api_version,

489:
490:
491:
492: -- here's the delegated call to the old PL/SQL routine
493: ahl_ump_smrinstance_pvt.search_mr_instances(p_api_version,
494: p_init_msg_list,
495: p_commit,
496: p_validation_level,
497: p_default,

Line 518: ahl_ump_smrinstance_pvt_w.rosetta_table_copy_out_p3(ddx_results_mr_instance_tbl, p9_a0

514:
515:
516:
517:
518: ahl_ump_smrinstance_pvt_w.rosetta_table_copy_out_p3(ddx_results_mr_instance_tbl, p9_a0
519: , p9_a1
520: , p9_a2
521: , p9_a3
522: , p9_a4

Line 608: ddp_search_ump_rec ahl_ump_smrinstance_pvt.search_ump_rec_type;

604: , x_msg_data out nocopy VARCHAR2
605: )
606:
607: as
608: ddp_search_ump_rec ahl_ump_smrinstance_pvt.search_ump_rec_type;
609: ddx_ump_search_query ahl_ump_smrinstance_pvt.ump_search_query_type;
610: ddx_ump_bind_params ahl_ump_smrinstance_pvt.ump_bind_param_tbl_type;
611: ddindx binary_integer; indx binary_integer;
612: begin

Line 609: ddx_ump_search_query ahl_ump_smrinstance_pvt.ump_search_query_type;

605: )
606:
607: as
608: ddp_search_ump_rec ahl_ump_smrinstance_pvt.search_ump_rec_type;
609: ddx_ump_search_query ahl_ump_smrinstance_pvt.ump_search_query_type;
610: ddx_ump_bind_params ahl_ump_smrinstance_pvt.ump_bind_param_tbl_type;
611: ddindx binary_integer; indx binary_integer;
612: begin
613:

Line 610: ddx_ump_bind_params ahl_ump_smrinstance_pvt.ump_bind_param_tbl_type;

606:
607: as
608: ddp_search_ump_rec ahl_ump_smrinstance_pvt.search_ump_rec_type;
609: ddx_ump_search_query ahl_ump_smrinstance_pvt.ump_search_query_type;
610: ddx_ump_bind_params ahl_ump_smrinstance_pvt.ump_bind_param_tbl_type;
611: ddindx binary_integer; indx binary_integer;
612: begin
613:
614: -- copy data to the local IN or IN-OUT args, if any

Line 658: ahl_ump_smrinstance_pvt.build_ump_search_query(p_api_version,

654:
655:
656:
657: -- here's the delegated call to the old PL/SQL routine
658: ahl_ump_smrinstance_pvt.build_ump_search_query(p_api_version,
659: p_init_msg_list,
660: p_commit,
661: p_validation_level,
662: p_default,

Line 681: ahl_ump_smrinstance_pvt_w.rosetta_table_copy_out_p7(ddx_ump_bind_params, p8_a0

677:
678:
679: p7_a0 := ddx_ump_search_query.ump_search_query_str;
680:
681: ahl_ump_smrinstance_pvt_w.rosetta_table_copy_out_p7(ddx_ump_bind_params, p8_a0
682: );
683:
684:
685:

Line 688: end ahl_ump_smrinstance_pvt_w;

684:
685:
686: end;
687:
688: end ahl_ump_smrinstance_pvt_w;