DBA Data[Home] [Help]

APPS.AHL_MC_NODE_PVT_W dependencies on AHL_MC_NODE_PVT

Line 1: package body ahl_mc_node_pvt_w as

1: package body ahl_mc_node_pvt_w as
2: /* $Header: AHLVNOWB.pls 120.4 2006/05/03 02:12 sathapli noship $ */
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 16: procedure rosetta_table_copy_in_p6(t out nocopy ahl_mc_node_pvt.node_tbl_type, a0 JTF_NUMBER_TABLE

12: if d < rosetta_g_mistake_date_low then return fnd_api.g_miss_date; end if;
13: return d;
14: end;
15:
16: procedure rosetta_table_copy_in_p6(t out nocopy ahl_mc_node_pvt.node_tbl_type, a0 JTF_NUMBER_TABLE
17: , a1 JTF_NUMBER_TABLE
18: , a2 JTF_NUMBER_TABLE
19: , a3 JTF_VARCHAR2_TABLE_100
20: , a4 JTF_VARCHAR2_TABLE_100

Line 107: procedure rosetta_table_copy_out_p6(t ahl_mc_node_pvt.node_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

103: end loop;
104: end if;
105: end if;
106: end rosetta_table_copy_in_p6;
107: procedure rosetta_table_copy_out_p6(t ahl_mc_node_pvt.node_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
108: , a1 out nocopy JTF_NUMBER_TABLE
109: , a2 out nocopy JTF_NUMBER_TABLE
110: , a3 out nocopy JTF_VARCHAR2_TABLE_100
111: , a4 out nocopy JTF_VARCHAR2_TABLE_100

Line 311: procedure rosetta_table_copy_in_p8(t out nocopy ahl_mc_node_pvt.counter_rules_tbl_type, a0 JTF_NUMBER_TABLE

307: end if;
308: end if;
309: end rosetta_table_copy_out_p6;
310:
311: procedure rosetta_table_copy_in_p8(t out nocopy ahl_mc_node_pvt.counter_rules_tbl_type, a0 JTF_NUMBER_TABLE
312: , a1 JTF_NUMBER_TABLE
313: , a2 JTF_VARCHAR2_TABLE_100
314: , a3 JTF_VARCHAR2_TABLE_100
315: , a4 JTF_VARCHAR2_TABLE_100

Line 380: procedure rosetta_table_copy_out_p8(t ahl_mc_node_pvt.counter_rules_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

376: end loop;
377: end if;
378: end if;
379: end rosetta_table_copy_in_p8;
380: procedure rosetta_table_copy_out_p8(t ahl_mc_node_pvt.counter_rules_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
381: , a1 out nocopy JTF_NUMBER_TABLE
382: , a2 out nocopy JTF_VARCHAR2_TABLE_100
383: , a3 out nocopy JTF_VARCHAR2_TABLE_100
384: , a4 out nocopy JTF_VARCHAR2_TABLE_100

Line 529: procedure rosetta_table_copy_in_p10(t out nocopy ahl_mc_node_pvt.subconfig_tbl_type, a0 JTF_NUMBER_TABLE

525: end if;
526: end if;
527: end rosetta_table_copy_out_p8;
528:
529: procedure rosetta_table_copy_in_p10(t out nocopy ahl_mc_node_pvt.subconfig_tbl_type, a0 JTF_NUMBER_TABLE
530: , a1 JTF_NUMBER_TABLE
531: , a2 JTF_VARCHAR2_TABLE_100
532: , a3 JTF_NUMBER_TABLE
533: , a4 JTF_NUMBER_TABLE

Line 600: procedure rosetta_table_copy_out_p10(t ahl_mc_node_pvt.subconfig_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

596: end loop;
597: end if;
598: end if;
599: end rosetta_table_copy_in_p10;
600: procedure rosetta_table_copy_out_p10(t ahl_mc_node_pvt.subconfig_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
601: , a1 out nocopy JTF_NUMBER_TABLE
602: , a2 out nocopy JTF_VARCHAR2_TABLE_100
603: , a3 out nocopy JTF_NUMBER_TABLE
604: , a4 out nocopy JTF_NUMBER_TABLE

Line 854: ddp_x_node_rec ahl_mc_node_pvt.node_rec_type;

850: , p9_a26 in out nocopy JTF_VARCHAR2_TABLE_100
851: )
852:
853: as
854: ddp_x_node_rec ahl_mc_node_pvt.node_rec_type;
855: ddp_x_counter_rules_tbl ahl_mc_node_pvt.counter_rules_tbl_type;
856: ddp_x_subconfig_tbl ahl_mc_node_pvt.subconfig_tbl_type;
857: ddindx binary_integer; indx binary_integer;
858: begin

Line 855: ddp_x_counter_rules_tbl ahl_mc_node_pvt.counter_rules_tbl_type;

851: )
852:
853: as
854: ddp_x_node_rec ahl_mc_node_pvt.node_rec_type;
855: ddp_x_counter_rules_tbl ahl_mc_node_pvt.counter_rules_tbl_type;
856: ddp_x_subconfig_tbl ahl_mc_node_pvt.subconfig_tbl_type;
857: ddindx binary_integer; indx binary_integer;
858: begin
859:

Line 856: ddp_x_subconfig_tbl ahl_mc_node_pvt.subconfig_tbl_type;

852:
853: as
854: ddp_x_node_rec ahl_mc_node_pvt.node_rec_type;
855: ddp_x_counter_rules_tbl ahl_mc_node_pvt.counter_rules_tbl_type;
856: ddp_x_subconfig_tbl ahl_mc_node_pvt.subconfig_tbl_type;
857: ddindx binary_integer; indx binary_integer;
858: begin
859:
860: -- copy data to the local IN or IN-OUT args, if any

Line 906: ahl_mc_node_pvt_w.rosetta_table_copy_in_p8(ddp_x_counter_rules_tbl, p8_a0

902: ddp_x_node_rec.attribute15 := p7_a34;
903: ddp_x_node_rec.operation_flag := p7_a35;
904: ddp_x_node_rec.parent_node_rec_index := p7_a36;
905:
906: ahl_mc_node_pvt_w.rosetta_table_copy_in_p8(ddp_x_counter_rules_tbl, p8_a0
907: , p8_a1
908: , p8_a2
909: , p8_a3
910: , p8_a4

Line 934: ahl_mc_node_pvt_w.rosetta_table_copy_in_p10(ddp_x_subconfig_tbl, p9_a0

930: , p8_a24
931: , p8_a25
932: );
933:
934: ahl_mc_node_pvt_w.rosetta_table_copy_in_p10(ddp_x_subconfig_tbl, p9_a0
935: , p9_a1
936: , p9_a2
937: , p9_a3
938: , p9_a4

Line 964: ahl_mc_node_pvt.create_node(p_api_version,

960: , p9_a26
961: );
962:
963: -- here's the delegated call to the old PL/SQL routine
964: ahl_mc_node_pvt.create_node(p_api_version,
965: p_init_msg_list,
966: p_commit,
967: p_validation_level,
968: x_return_status,

Line 1021: ahl_mc_node_pvt_w.rosetta_table_copy_out_p8(ddp_x_counter_rules_tbl, p8_a0

1017: p7_a34 := ddp_x_node_rec.attribute15;
1018: p7_a35 := ddp_x_node_rec.operation_flag;
1019: p7_a36 := ddp_x_node_rec.parent_node_rec_index;
1020:
1021: ahl_mc_node_pvt_w.rosetta_table_copy_out_p8(ddp_x_counter_rules_tbl, p8_a0
1022: , p8_a1
1023: , p8_a2
1024: , p8_a3
1025: , p8_a4

Line 1049: ahl_mc_node_pvt_w.rosetta_table_copy_out_p10(ddp_x_subconfig_tbl, p9_a0

1045: , p8_a24
1046: , p8_a25
1047: );
1048:
1049: ahl_mc_node_pvt_w.rosetta_table_copy_out_p10(ddp_x_subconfig_tbl, p9_a0
1050: , p9_a1
1051: , p9_a2
1052: , p9_a3
1053: , p9_a4

Line 1179: ddp_x_node_rec ahl_mc_node_pvt.node_rec_type;

1175: , p9_a26 in out nocopy JTF_VARCHAR2_TABLE_100
1176: )
1177:
1178: as
1179: ddp_x_node_rec ahl_mc_node_pvt.node_rec_type;
1180: ddp_x_counter_rules_tbl ahl_mc_node_pvt.counter_rules_tbl_type;
1181: ddp_x_subconfig_tbl ahl_mc_node_pvt.subconfig_tbl_type;
1182: ddindx binary_integer; indx binary_integer;
1183: begin

Line 1180: ddp_x_counter_rules_tbl ahl_mc_node_pvt.counter_rules_tbl_type;

1176: )
1177:
1178: as
1179: ddp_x_node_rec ahl_mc_node_pvt.node_rec_type;
1180: ddp_x_counter_rules_tbl ahl_mc_node_pvt.counter_rules_tbl_type;
1181: ddp_x_subconfig_tbl ahl_mc_node_pvt.subconfig_tbl_type;
1182: ddindx binary_integer; indx binary_integer;
1183: begin
1184:

Line 1181: ddp_x_subconfig_tbl ahl_mc_node_pvt.subconfig_tbl_type;

1177:
1178: as
1179: ddp_x_node_rec ahl_mc_node_pvt.node_rec_type;
1180: ddp_x_counter_rules_tbl ahl_mc_node_pvt.counter_rules_tbl_type;
1181: ddp_x_subconfig_tbl ahl_mc_node_pvt.subconfig_tbl_type;
1182: ddindx binary_integer; indx binary_integer;
1183: begin
1184:
1185: -- copy data to the local IN or IN-OUT args, if any

Line 1231: ahl_mc_node_pvt_w.rosetta_table_copy_in_p8(ddp_x_counter_rules_tbl, p8_a0

1227: ddp_x_node_rec.attribute15 := p7_a34;
1228: ddp_x_node_rec.operation_flag := p7_a35;
1229: ddp_x_node_rec.parent_node_rec_index := p7_a36;
1230:
1231: ahl_mc_node_pvt_w.rosetta_table_copy_in_p8(ddp_x_counter_rules_tbl, p8_a0
1232: , p8_a1
1233: , p8_a2
1234: , p8_a3
1235: , p8_a4

Line 1259: ahl_mc_node_pvt_w.rosetta_table_copy_in_p10(ddp_x_subconfig_tbl, p9_a0

1255: , p8_a24
1256: , p8_a25
1257: );
1258:
1259: ahl_mc_node_pvt_w.rosetta_table_copy_in_p10(ddp_x_subconfig_tbl, p9_a0
1260: , p9_a1
1261: , p9_a2
1262: , p9_a3
1263: , p9_a4

Line 1289: ahl_mc_node_pvt.modify_node(p_api_version,

1285: , p9_a26
1286: );
1287:
1288: -- here's the delegated call to the old PL/SQL routine
1289: ahl_mc_node_pvt.modify_node(p_api_version,
1290: p_init_msg_list,
1291: p_commit,
1292: p_validation_level,
1293: x_return_status,

Line 1346: ahl_mc_node_pvt_w.rosetta_table_copy_out_p8(ddp_x_counter_rules_tbl, p8_a0

1342: p7_a34 := ddp_x_node_rec.attribute15;
1343: p7_a35 := ddp_x_node_rec.operation_flag;
1344: p7_a36 := ddp_x_node_rec.parent_node_rec_index;
1345:
1346: ahl_mc_node_pvt_w.rosetta_table_copy_out_p8(ddp_x_counter_rules_tbl, p8_a0
1347: , p8_a1
1348: , p8_a2
1349: , p8_a3
1350: , p8_a4

Line 1374: ahl_mc_node_pvt_w.rosetta_table_copy_out_p10(ddp_x_subconfig_tbl, p9_a0

1370: , p8_a24
1371: , p8_a25
1372: );
1373:
1374: ahl_mc_node_pvt_w.rosetta_table_copy_out_p10(ddp_x_subconfig_tbl, p9_a0
1375: , p9_a1
1376: , p9_a2
1377: , p9_a3
1378: , p9_a4

Line 1448: ahl_mc_node_pvt.copy_mc_nodes(p_api_version,

1444: else ddp_node_copy := true;
1445: end if;
1446:
1447: -- here's the delegated call to the old PL/SQL routine
1448: ahl_mc_node_pvt.copy_mc_nodes(p_api_version,
1449: p_init_msg_list,
1450: p_commit,
1451: p_validation_level,
1452: x_return_status,

Line 1574: ahl_mc_node_pvt.process_documents(p_api_version,

1570: , p8_a36
1571: );
1572:
1573: -- here's the delegated call to the old PL/SQL routine
1574: ahl_mc_node_pvt.process_documents(p_api_version,
1575: p_init_msg_list,
1576: p_commit,
1577: p_validation_level,
1578: x_return_status,

Line 1680: ddp_nodes_tbl ahl_mc_node_pvt.node_tbl_type;

1676: , p7_a36 JTF_NUMBER_TABLE
1677: )
1678:
1679: as
1680: ddp_nodes_tbl ahl_mc_node_pvt.node_tbl_type;
1681: ddindx binary_integer; indx binary_integer;
1682: begin
1683:
1684: -- copy data to the local IN or IN-OUT args, if any

Line 1692: ahl_mc_node_pvt_w.rosetta_table_copy_in_p6(ddp_nodes_tbl, p7_a0

1688:
1689:
1690:
1691:
1692: ahl_mc_node_pvt_w.rosetta_table_copy_in_p6(ddp_nodes_tbl, p7_a0
1693: , p7_a1
1694: , p7_a2
1695: , p7_a3
1696: , p7_a4

Line 1732: ahl_mc_node_pvt.associate_item_group(p_api_version,

1728: , p7_a36
1729: );
1730:
1731: -- here's the delegated call to the old PL/SQL routine
1732: ahl_mc_node_pvt.associate_item_group(p_api_version,
1733: p_init_msg_list,
1734: p_commit,
1735: p_validation_level,
1736: x_return_status,

Line 1751: end ahl_mc_node_pvt_w;

1747:
1748:
1749: end;
1750:
1751: end ahl_mc_node_pvt_w;