DBA Data[Home] [Help]

APPS.AHL_DI_DOC_INDEX_PUB_W dependencies on AHL_DI_DOC_INDEX_PUB

Line 1: package body ahl_di_doc_index_pub_w as

1: package body ahl_di_doc_index_pub_w as
2: /* $Header: AHLDOCWB.pls 120.1.12020000.2 2012/12/06 22:24:33 sareepar 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 16: procedure rosetta_table_copy_in_p3(t out nocopy ahl_di_doc_index_pub.document_tbl, 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_p3(t out nocopy ahl_di_doc_index_pub.document_tbl, a0 JTF_NUMBER_TABLE
17: , a1 JTF_NUMBER_TABLE
18: , a2 JTF_VARCHAR2_TABLE_100
19: , a3 JTF_VARCHAR2_TABLE_100
20: , a4 JTF_VARCHAR2_TABLE_100

Line 105: procedure rosetta_table_copy_out_p3(t ahl_di_doc_index_pub.document_tbl, a0 out nocopy JTF_NUMBER_TABLE

101: end loop;
102: end if;
103: end if;
104: end rosetta_table_copy_in_p3;
105: procedure rosetta_table_copy_out_p3(t ahl_di_doc_index_pub.document_tbl, a0 out nocopy JTF_NUMBER_TABLE
106: , a1 out nocopy JTF_NUMBER_TABLE
107: , a2 out nocopy JTF_VARCHAR2_TABLE_100
108: , a3 out nocopy JTF_VARCHAR2_TABLE_100
109: , a4 out nocopy JTF_VARCHAR2_TABLE_100

Line 304: procedure rosetta_table_copy_in_p4(t out nocopy ahl_di_doc_index_pub.supplier_tbl, a0 JTF_NUMBER_TABLE

300: end if;
301: end if;
302: end rosetta_table_copy_out_p3;
303:
304: procedure rosetta_table_copy_in_p4(t out nocopy ahl_di_doc_index_pub.supplier_tbl, a0 JTF_NUMBER_TABLE
305: , a1 JTF_NUMBER_TABLE
306: , a2 JTF_VARCHAR2_TABLE_100
307: , a3 JTF_NUMBER_TABLE
308: , a4 JTF_VARCHAR2_TABLE_100

Line 369: procedure rosetta_table_copy_out_p4(t ahl_di_doc_index_pub.supplier_tbl, a0 out nocopy JTF_NUMBER_TABLE

365: end loop;
366: end if;
367: end if;
368: end rosetta_table_copy_in_p4;
369: procedure rosetta_table_copy_out_p4(t ahl_di_doc_index_pub.supplier_tbl, a0 out nocopy JTF_NUMBER_TABLE
370: , a1 out nocopy JTF_NUMBER_TABLE
371: , a2 out nocopy JTF_VARCHAR2_TABLE_100
372: , a3 out nocopy JTF_NUMBER_TABLE
373: , a4 out nocopy JTF_VARCHAR2_TABLE_100

Line 508: procedure rosetta_table_copy_in_p5(t out nocopy ahl_di_doc_index_pub.recipient_tbl, a0 JTF_NUMBER_TABLE

504: end if;
505: end if;
506: end rosetta_table_copy_out_p4;
507:
508: procedure rosetta_table_copy_in_p5(t out nocopy ahl_di_doc_index_pub.recipient_tbl, a0 JTF_NUMBER_TABLE
509: , a1 JTF_NUMBER_TABLE
510: , a2 JTF_VARCHAR2_TABLE_100
511: , a3 JTF_NUMBER_TABLE
512: , a4 JTF_NUMBER_TABLE

Line 569: procedure rosetta_table_copy_out_p5(t ahl_di_doc_index_pub.recipient_tbl, a0 out nocopy JTF_NUMBER_TABLE

565: end loop;
566: end if;
567: end if;
568: end rosetta_table_copy_in_p5;
569: procedure rosetta_table_copy_out_p5(t ahl_di_doc_index_pub.recipient_tbl, a0 out nocopy JTF_NUMBER_TABLE
570: , a1 out nocopy JTF_NUMBER_TABLE
571: , a2 out nocopy JTF_VARCHAR2_TABLE_100
572: , a3 out nocopy JTF_NUMBER_TABLE
573: , a4 out nocopy JTF_NUMBER_TABLE

Line 792: ddp_x_document_tbl ahl_di_doc_index_pub.document_tbl;

788: , x_msg_data out nocopy VARCHAR2
789: )
790:
791: as
792: ddp_x_document_tbl ahl_di_doc_index_pub.document_tbl;
793: ddp_x_supplier_tbl ahl_di_doc_index_pub.supplier_tbl;
794: ddp_x_recipient_tbl ahl_di_doc_index_pub.recipient_tbl;
795: ddindx binary_integer; indx binary_integer;
796: begin

Line 793: ddp_x_supplier_tbl ahl_di_doc_index_pub.supplier_tbl;

789: )
790:
791: as
792: ddp_x_document_tbl ahl_di_doc_index_pub.document_tbl;
793: ddp_x_supplier_tbl ahl_di_doc_index_pub.supplier_tbl;
794: ddp_x_recipient_tbl ahl_di_doc_index_pub.recipient_tbl;
795: ddindx binary_integer; indx binary_integer;
796: begin
797:

Line 794: ddp_x_recipient_tbl ahl_di_doc_index_pub.recipient_tbl;

790:
791: as
792: ddp_x_document_tbl ahl_di_doc_index_pub.document_tbl;
793: ddp_x_supplier_tbl ahl_di_doc_index_pub.supplier_tbl;
794: ddp_x_recipient_tbl ahl_di_doc_index_pub.recipient_tbl;
795: ddindx binary_integer; indx binary_integer;
796: begin
797:
798: -- copy data to the local IN or IN-OUT args, if any

Line 804: ahl_di_doc_index_pub_w.rosetta_table_copy_in_p3(ddp_x_document_tbl, p5_a0

800:
801:
802:
803:
804: ahl_di_doc_index_pub_w.rosetta_table_copy_in_p3(ddp_x_document_tbl, p5_a0
805: , p5_a1
806: , p5_a2
807: , p5_a3
808: , p5_a4

Line 842: ahl_di_doc_index_pub_w.rosetta_table_copy_in_p4(ddp_x_supplier_tbl, p6_a0

838: , p5_a34
839: , p5_a35
840: );
841:
842: ahl_di_doc_index_pub_w.rosetta_table_copy_in_p4(ddp_x_supplier_tbl, p6_a0
843: , p6_a1
844: , p6_a2
845: , p6_a3
846: , p6_a4

Line 868: ahl_di_doc_index_pub_w.rosetta_table_copy_in_p5(ddp_x_recipient_tbl, p7_a0

864: , p6_a22
865: , p6_a23
866: );
867:
868: ahl_di_doc_index_pub_w.rosetta_table_copy_in_p5(ddp_x_recipient_tbl, p7_a0
869: , p7_a1
870: , p7_a2
871: , p7_a3
872: , p7_a4

Line 897: ahl_di_doc_index_pub.create_document(p_api_version,

893:
894:
895:
896: -- here's the delegated call to the old PL/SQL routine
897: ahl_di_doc_index_pub.create_document(p_api_version,
898: p_init_msg_list,
899: p_commit,
900: p_validate_only,
901: p_validation_level,

Line 916: ahl_di_doc_index_pub_w.rosetta_table_copy_out_p3(ddp_x_document_tbl, p5_a0

912:
913:
914:
915:
916: ahl_di_doc_index_pub_w.rosetta_table_copy_out_p3(ddp_x_document_tbl, p5_a0
917: , p5_a1
918: , p5_a2
919: , p5_a3
920: , p5_a4

Line 954: ahl_di_doc_index_pub_w.rosetta_table_copy_out_p4(ddp_x_supplier_tbl, p6_a0

950: , p5_a34
951: , p5_a35
952: );
953:
954: ahl_di_doc_index_pub_w.rosetta_table_copy_out_p4(ddp_x_supplier_tbl, p6_a0
955: , p6_a1
956: , p6_a2
957: , p6_a3
958: , p6_a4

Line 980: ahl_di_doc_index_pub_w.rosetta_table_copy_out_p5(ddp_x_recipient_tbl, p7_a0

976: , p6_a22
977: , p6_a23
978: );
979:
980: ahl_di_doc_index_pub_w.rosetta_table_copy_out_p5(ddp_x_recipient_tbl, p7_a0
981: , p7_a1
982: , p7_a2
983: , p7_a3
984: , p7_a4

Line 1103: ddp_x_document_tbl ahl_di_doc_index_pub.document_tbl;

1099: , x_msg_data out nocopy VARCHAR2
1100: )
1101:
1102: as
1103: ddp_x_document_tbl ahl_di_doc_index_pub.document_tbl;
1104: ddp_x_supplier_tbl ahl_di_doc_index_pub.supplier_tbl;
1105: ddp_x_recipient_tbl ahl_di_doc_index_pub.recipient_tbl;
1106: ddindx binary_integer; indx binary_integer;
1107: begin

Line 1104: ddp_x_supplier_tbl ahl_di_doc_index_pub.supplier_tbl;

1100: )
1101:
1102: as
1103: ddp_x_document_tbl ahl_di_doc_index_pub.document_tbl;
1104: ddp_x_supplier_tbl ahl_di_doc_index_pub.supplier_tbl;
1105: ddp_x_recipient_tbl ahl_di_doc_index_pub.recipient_tbl;
1106: ddindx binary_integer; indx binary_integer;
1107: begin
1108:

Line 1105: ddp_x_recipient_tbl ahl_di_doc_index_pub.recipient_tbl;

1101:
1102: as
1103: ddp_x_document_tbl ahl_di_doc_index_pub.document_tbl;
1104: ddp_x_supplier_tbl ahl_di_doc_index_pub.supplier_tbl;
1105: ddp_x_recipient_tbl ahl_di_doc_index_pub.recipient_tbl;
1106: ddindx binary_integer; indx binary_integer;
1107: begin
1108:
1109: -- copy data to the local IN or IN-OUT args, if any

Line 1115: ahl_di_doc_index_pub_w.rosetta_table_copy_in_p3(ddp_x_document_tbl, p5_a0

1111:
1112:
1113:
1114:
1115: ahl_di_doc_index_pub_w.rosetta_table_copy_in_p3(ddp_x_document_tbl, p5_a0
1116: , p5_a1
1117: , p5_a2
1118: , p5_a3
1119: , p5_a4

Line 1153: ahl_di_doc_index_pub_w.rosetta_table_copy_in_p4(ddp_x_supplier_tbl, p6_a0

1149: , p5_a34
1150: , p5_a35
1151: );
1152:
1153: ahl_di_doc_index_pub_w.rosetta_table_copy_in_p4(ddp_x_supplier_tbl, p6_a0
1154: , p6_a1
1155: , p6_a2
1156: , p6_a3
1157: , p6_a4

Line 1179: ahl_di_doc_index_pub_w.rosetta_table_copy_in_p5(ddp_x_recipient_tbl, p7_a0

1175: , p6_a22
1176: , p6_a23
1177: );
1178:
1179: ahl_di_doc_index_pub_w.rosetta_table_copy_in_p5(ddp_x_recipient_tbl, p7_a0
1180: , p7_a1
1181: , p7_a2
1182: , p7_a3
1183: , p7_a4

Line 1208: ahl_di_doc_index_pub.modify_document(p_api_version,

1204:
1205:
1206:
1207: -- here's the delegated call to the old PL/SQL routine
1208: ahl_di_doc_index_pub.modify_document(p_api_version,
1209: p_init_msg_list,
1210: p_commit,
1211: p_validate_only,
1212: p_validation_level,

Line 1227: ahl_di_doc_index_pub_w.rosetta_table_copy_out_p3(ddp_x_document_tbl, p5_a0

1223:
1224:
1225:
1226:
1227: ahl_di_doc_index_pub_w.rosetta_table_copy_out_p3(ddp_x_document_tbl, p5_a0
1228: , p5_a1
1229: , p5_a2
1230: , p5_a3
1231: , p5_a4

Line 1265: ahl_di_doc_index_pub_w.rosetta_table_copy_out_p4(ddp_x_supplier_tbl, p6_a0

1261: , p5_a34
1262: , p5_a35
1263: );
1264:
1265: ahl_di_doc_index_pub_w.rosetta_table_copy_out_p4(ddp_x_supplier_tbl, p6_a0
1266: , p6_a1
1267: , p6_a2
1268: , p6_a3
1269: , p6_a4

Line 1291: ahl_di_doc_index_pub_w.rosetta_table_copy_out_p5(ddp_x_recipient_tbl, p7_a0

1287: , p6_a22
1288: , p6_a23
1289: );
1290:
1291: ahl_di_doc_index_pub_w.rosetta_table_copy_out_p5(ddp_x_recipient_tbl, p7_a0
1292: , p7_a1
1293: , p7_a2
1294: , p7_a3
1295: , p7_a4

Line 1320: end ahl_di_doc_index_pub_w;

1316:
1317:
1318: end;
1319:
1320: end ahl_di_doc_index_pub_w;