DBA Data[Home] [Help]

APPS.AHL_SB_RULES_PVT_W dependencies on AHL_SB_RULES_PVT

Line 1: package body ahl_sb_rules_pvt_w as

1: package body ahl_sb_rules_pvt_w as
2: /* $Header: AHLWSBRB.pls 120.0.12020000.2 2012/12/14 06:28:47 shnatu noship $ */
3: procedure rosetta_table_copy_in_p4(t out nocopy ahl_sb_rules_pvt.sb_rule_tbl_type, a0 JTF_NUMBER_TABLE
4: , a1 JTF_VARCHAR2_TABLE_100
5: , a2 JTF_NUMBER_TABLE

Line 3: procedure rosetta_table_copy_in_p4(t out nocopy ahl_sb_rules_pvt.sb_rule_tbl_type, a0 JTF_NUMBER_TABLE

1: package body ahl_sb_rules_pvt_w as
2: /* $Header: AHLWSBRB.pls 120.0.12020000.2 2012/12/14 06:28:47 shnatu noship $ */
3: procedure rosetta_table_copy_in_p4(t out nocopy ahl_sb_rules_pvt.sb_rule_tbl_type, a0 JTF_NUMBER_TABLE
4: , a1 JTF_VARCHAR2_TABLE_100
5: , a2 JTF_NUMBER_TABLE
6: , a3 JTF_DATE_TABLE
7: , a4 JTF_NUMBER_TABLE

Line 84: procedure rosetta_table_copy_out_p4(t ahl_sb_rules_pvt.sb_rule_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

80: end loop;
81: end if;
82: end if;
83: end rosetta_table_copy_in_p4;
84: procedure rosetta_table_copy_out_p4(t ahl_sb_rules_pvt.sb_rule_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
85: , a1 out nocopy JTF_VARCHAR2_TABLE_100
86: , a2 out nocopy JTF_NUMBER_TABLE
87: , a3 out nocopy JTF_DATE_TABLE
88: , a4 out nocopy JTF_NUMBER_TABLE

Line 263: procedure rosetta_table_copy_in_p6(t out nocopy ahl_sb_rules_pvt.sb_rule_items_tbl_type, a0 JTF_NUMBER_TABLE

259: end if;
260: end if;
261: end rosetta_table_copy_out_p4;
262:
263: procedure rosetta_table_copy_in_p6(t out nocopy ahl_sb_rules_pvt.sb_rule_items_tbl_type, a0 JTF_NUMBER_TABLE
264: , a1 JTF_VARCHAR2_TABLE_100
265: , a2 JTF_NUMBER_TABLE
266: , a3 JTF_DATE_TABLE
267: , a4 JTF_NUMBER_TABLE

Line 338: procedure rosetta_table_copy_out_p6(t ahl_sb_rules_pvt.sb_rule_items_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

334: end loop;
335: end if;
336: end if;
337: end rosetta_table_copy_in_p6;
338: procedure rosetta_table_copy_out_p6(t ahl_sb_rules_pvt.sb_rule_items_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
339: , a1 out nocopy JTF_VARCHAR2_TABLE_100
340: , a2 out nocopy JTF_NUMBER_TABLE
341: , a3 out nocopy JTF_DATE_TABLE
342: , a4 out nocopy JTF_NUMBER_TABLE

Line 502: procedure rosetta_table_copy_in_p7(t out nocopy ahl_sb_rules_pvt.violated_inst_tbl_type, a0 JTF_NUMBER_TABLE) as

498: end if;
499: end if;
500: end rosetta_table_copy_out_p6;
501:
502: procedure rosetta_table_copy_in_p7(t out nocopy ahl_sb_rules_pvt.violated_inst_tbl_type, a0 JTF_NUMBER_TABLE) as
503: ddindx binary_integer; indx binary_integer;
504: begin
505: if a0 is not null and a0.count > 0 then
506: if a0.count > 0 then

Line 520: procedure rosetta_table_copy_out_p7(t ahl_sb_rules_pvt.violated_inst_tbl_type, a0 out nocopy JTF_NUMBER_TABLE) as

516: end loop;
517: end if;
518: end if;
519: end rosetta_table_copy_in_p7;
520: procedure rosetta_table_copy_out_p7(t ahl_sb_rules_pvt.violated_inst_tbl_type, a0 out nocopy JTF_NUMBER_TABLE) as
521: ddindx binary_integer; indx binary_integer;
522: begin
523: if t is null or t.count = 0 then
524: a0 := JTF_NUMBER_TABLE();

Line 543: procedure rosetta_table_copy_in_p8(t out nocopy ahl_sb_rules_pvt.affected_mc_tbl_type, a0 JTF_NUMBER_TABLE) as

539: end if;
540: end if;
541: end rosetta_table_copy_out_p7;
542:
543: procedure rosetta_table_copy_in_p8(t out nocopy ahl_sb_rules_pvt.affected_mc_tbl_type, a0 JTF_NUMBER_TABLE) as
544: ddindx binary_integer; indx binary_integer;
545: begin
546: if a0 is not null and a0.count > 0 then
547: if a0.count > 0 then

Line 561: procedure rosetta_table_copy_out_p8(t ahl_sb_rules_pvt.affected_mc_tbl_type, a0 out nocopy JTF_NUMBER_TABLE) as

557: end loop;
558: end if;
559: end if;
560: end rosetta_table_copy_in_p8;
561: procedure rosetta_table_copy_out_p8(t ahl_sb_rules_pvt.affected_mc_tbl_type, a0 out nocopy JTF_NUMBER_TABLE) as
562: ddindx binary_integer; indx binary_integer;
563: begin
564: if t is null or t.count = 0 then
565: a0 := JTF_NUMBER_TABLE();

Line 614: ahl_sb_rules_pvt.check_unit_completeness(p_api_version,

610:
611:
612:
613: -- here's the delegated call to the old PL/SQL routine
614: ahl_sb_rules_pvt.check_unit_completeness(p_api_version,
615: p_init_msg_list,
616: p_validation_level,
617: p_module_type,
618: p_uc_header_id,

Line 666: ahl_sb_rules_pvt.check_inst_completeness(p_api_version,

662:
663:
664:
665: -- here's the delegated call to the old PL/SQL routine
666: ahl_sb_rules_pvt.check_inst_completeness(p_api_version,
667: p_init_msg_list,
668: p_validation_level,
669: p_module_type,
670: p_csi_instance_id,

Line 700: ddx_violated_inst_tbl ahl_sb_rules_pvt.violated_inst_tbl_type;

696: , x_msg_data out nocopy VARCHAR2
697: )
698:
699: as
700: ddx_violated_inst_tbl ahl_sb_rules_pvt.violated_inst_tbl_type;
701: ddindx binary_integer; indx binary_integer;
702: begin
703:
704: -- copy data to the local IN or IN-OUT args, if any

Line 715: ahl_sb_rules_pvt.get_violated_instances(p_api_version,

711:
712:
713:
714: -- here's the delegated call to the old PL/SQL routine
715: ahl_sb_rules_pvt.get_violated_instances(p_api_version,
716: p_init_msg_list,
717: p_validation_level,
718: p_module_type,
719: p_uc_header_id,

Line 731: ahl_sb_rules_pvt_w.rosetta_table_copy_out_p7(ddx_violated_inst_tbl, x_violated_inst_tbl);

727:
728:
729:
730:
731: ahl_sb_rules_pvt_w.rosetta_table_copy_out_p7(ddx_violated_inst_tbl, x_violated_inst_tbl);
732:
733:
734:
735: end;

Line 749: ddx_affected_mc_tbl ahl_sb_rules_pvt.affected_mc_tbl_type;

745: , x_msg_data out nocopy VARCHAR2
746: )
747:
748: as
749: ddx_affected_mc_tbl ahl_sb_rules_pvt.affected_mc_tbl_type;
750: ddindx binary_integer; indx binary_integer;
751: begin
752:
753: -- copy data to the local IN or IN-OUT args, if any

Line 764: ahl_sb_rules_pvt.get_affected_mc(p_api_version,

760:
761:
762:
763: -- here's the delegated call to the old PL/SQL routine
764: ahl_sb_rules_pvt.get_affected_mc(p_api_version,
765: p_init_msg_list,
766: p_validation_level,
767: p_module_type,
768: p_mr_header_id,

Line 780: ahl_sb_rules_pvt_w.rosetta_table_copy_out_p8(ddx_affected_mc_tbl, x_affected_mc_tbl);

776:
777:
778:
779:
780: ahl_sb_rules_pvt_w.rosetta_table_copy_out_p8(ddx_affected_mc_tbl, x_affected_mc_tbl);
781:
782:
783:
784: end;

Line 786: end ahl_sb_rules_pvt_w;

782:
783:
784: end;
785:
786: end ahl_sb_rules_pvt_w;