DBA Data[Home] [Help]

APPS.AMV_ITEM_PUB_W dependencies on AMV_ITEM_PUB_W

Line 1: package body amv_item_pub_w as

1: package body amv_item_pub_w as
2: /* $Header: amvwitmb.pls 120.2 2005/06/30 08:04 appldev 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:

Line 508: amv_item_pub_w.rosetta_table_copy_in_p1(ddp_channel_id_array, p_channel_id_array);

504:
505:
506:
507:
508: amv_item_pub_w.rosetta_table_copy_in_p1(ddp_channel_id_array, p_channel_id_array);
509:
510: ddp_item_obj.item_id := rosetta_g_miss_num_map(p8_a0);
511: ddp_item_obj.object_version_number := rosetta_g_miss_num_map(p8_a1);
512: ddp_item_obj.creation_date := rosetta_g_miss_date_in_map(p8_a2);

Line 535: amv_item_pub_w.rosetta_table_copy_in_p1(ddp_file_array, p_file_array);

531: ddp_item_obj.owner_id := rosetta_g_miss_num_map(p8_a21);
532: ddp_item_obj.default_approver_id := rosetta_g_miss_num_map(p8_a22);
533: ddp_item_obj.item_destination_type := p8_a23;
534:
535: amv_item_pub_w.rosetta_table_copy_in_p1(ddp_file_array, p_file_array);
536:
537: amv_item_pub_w.rosetta_table_copy_in_p8(ddp_persp_array, p10_a0
538: , p10_a1
539: );

Line 537: amv_item_pub_w.rosetta_table_copy_in_p8(ddp_persp_array, p10_a0

533: ddp_item_obj.item_destination_type := p8_a23;
534:
535: amv_item_pub_w.rosetta_table_copy_in_p1(ddp_file_array, p_file_array);
536:
537: amv_item_pub_w.rosetta_table_copy_in_p8(ddp_persp_array, p10_a0
538: , p10_a1
539: );
540:
541: amv_item_pub_w.rosetta_table_copy_in_p0(ddp_author_array, p_author_array);

Line 541: amv_item_pub_w.rosetta_table_copy_in_p0(ddp_author_array, p_author_array);

537: amv_item_pub_w.rosetta_table_copy_in_p8(ddp_persp_array, p10_a0
538: , p10_a1
539: );
540:
541: amv_item_pub_w.rosetta_table_copy_in_p0(ddp_author_array, p_author_array);
542:
543: amv_item_pub_w.rosetta_table_copy_in_p0(ddp_keyword_array, p_keyword_array);
544:
545:

Line 543: amv_item_pub_w.rosetta_table_copy_in_p0(ddp_keyword_array, p_keyword_array);

539: );
540:
541: amv_item_pub_w.rosetta_table_copy_in_p0(ddp_author_array, p_author_array);
542:
543: amv_item_pub_w.rosetta_table_copy_in_p0(ddp_keyword_array, p_keyword_array);
544:
545:
546: -- here's the delegated call to the old PL/SQL routine
547: amv_item_pub.create_item(p_api_version,

Line 635: amv_item_pub_w.rosetta_table_copy_in_p1(ddp_channel_id_array, p_channel_id_array);

631:
632:
633:
634:
635: amv_item_pub_w.rosetta_table_copy_in_p1(ddp_channel_id_array, p_channel_id_array);
636:
637: ddp_item_obj.item_id := rosetta_g_miss_num_map(p8_a0);
638: ddp_item_obj.object_version_number := rosetta_g_miss_num_map(p8_a1);
639: ddp_item_obj.creation_date := rosetta_g_miss_date_in_map(p8_a2);

Line 662: amv_item_pub_w.rosetta_table_copy_in_p1(ddp_file_array, p_file_array);

658: ddp_item_obj.owner_id := rosetta_g_miss_num_map(p8_a21);
659: ddp_item_obj.default_approver_id := rosetta_g_miss_num_map(p8_a22);
660: ddp_item_obj.item_destination_type := p8_a23;
661:
662: amv_item_pub_w.rosetta_table_copy_in_p1(ddp_file_array, p_file_array);
663:
664: amv_item_pub_w.rosetta_table_copy_in_p8(ddp_persp_array, p10_a0
665: , p10_a1
666: );

Line 664: amv_item_pub_w.rosetta_table_copy_in_p8(ddp_persp_array, p10_a0

660: ddp_item_obj.item_destination_type := p8_a23;
661:
662: amv_item_pub_w.rosetta_table_copy_in_p1(ddp_file_array, p_file_array);
663:
664: amv_item_pub_w.rosetta_table_copy_in_p8(ddp_persp_array, p10_a0
665: , p10_a1
666: );
667:
668: amv_item_pub_w.rosetta_table_copy_in_p0(ddp_author_array, p_author_array);

Line 668: amv_item_pub_w.rosetta_table_copy_in_p0(ddp_author_array, p_author_array);

664: amv_item_pub_w.rosetta_table_copy_in_p8(ddp_persp_array, p10_a0
665: , p10_a1
666: );
667:
668: amv_item_pub_w.rosetta_table_copy_in_p0(ddp_author_array, p_author_array);
669:
670: amv_item_pub_w.rosetta_table_copy_in_p0(ddp_keyword_array, p_keyword_array);
671:
672: -- here's the delegated call to the old PL/SQL routine

Line 670: amv_item_pub_w.rosetta_table_copy_in_p0(ddp_keyword_array, p_keyword_array);

666: );
667:
668: amv_item_pub_w.rosetta_table_copy_in_p0(ddp_author_array, p_author_array);
669:
670: amv_item_pub_w.rosetta_table_copy_in_p0(ddp_keyword_array, p_keyword_array);
671:
672: -- here's the delegated call to the old PL/SQL routine
673: amv_item_pub.update_item(p_api_version,
674: p_init_msg_list,

Line 809: amv_item_pub_w.rosetta_table_copy_out_p1(ddx_file_array, x_file_array);

805: p7_a21 := rosetta_g_miss_num_map(ddx_item_obj.owner_id);
806: p7_a22 := rosetta_g_miss_num_map(ddx_item_obj.default_approver_id);
807: p7_a23 := ddx_item_obj.item_destination_type;
808:
809: amv_item_pub_w.rosetta_table_copy_out_p1(ddx_file_array, x_file_array);
810:
811: amv_item_pub_w.rosetta_table_copy_out_p8(ddx_persp_array, p9_a0
812: , p9_a1
813: );

Line 811: amv_item_pub_w.rosetta_table_copy_out_p8(ddx_persp_array, p9_a0

807: p7_a23 := ddx_item_obj.item_destination_type;
808:
809: amv_item_pub_w.rosetta_table_copy_out_p1(ddx_file_array, x_file_array);
810:
811: amv_item_pub_w.rosetta_table_copy_out_p8(ddx_persp_array, p9_a0
812: , p9_a1
813: );
814:
815: amv_item_pub_w.rosetta_table_copy_out_p0(ddx_author_array, x_author_array);

Line 815: amv_item_pub_w.rosetta_table_copy_out_p0(ddx_author_array, x_author_array);

811: amv_item_pub_w.rosetta_table_copy_out_p8(ddx_persp_array, p9_a0
812: , p9_a1
813: );
814:
815: amv_item_pub_w.rosetta_table_copy_out_p0(ddx_author_array, x_author_array);
816:
817: amv_item_pub_w.rosetta_table_copy_out_p0(ddx_keyword_array, x_keyword_array);
818: end;
819:

Line 817: amv_item_pub_w.rosetta_table_copy_out_p0(ddx_keyword_array, x_keyword_array);

813: );
814:
815: amv_item_pub_w.rosetta_table_copy_out_p0(ddx_author_array, x_author_array);
816:
817: amv_item_pub_w.rosetta_table_copy_out_p0(ddx_keyword_array, x_keyword_array);
818: end;
819:
820: procedure find_item(p_api_version NUMBER
821: , p_init_msg_list VARCHAR2

Line 918: amv_item_pub_w.rosetta_table_copy_out_p6(ddx_item_obj_array, p11_a0

914: p10_a0 := rosetta_g_miss_num_map(ddx_subset_return_obj.returned_record_count);
915: p10_a1 := rosetta_g_miss_num_map(ddx_subset_return_obj.next_record_position);
916: p10_a2 := rosetta_g_miss_num_map(ddx_subset_return_obj.total_record_count);
917:
918: amv_item_pub_w.rosetta_table_copy_out_p6(ddx_item_obj_array, p11_a0
919: , p11_a1
920: , p11_a2
921: , p11_a3
922: , p11_a4

Line 975: amv_item_pub_w.rosetta_table_copy_in_p0(ddp_keyword_varray, p_keyword_varray);

971:
972:
973:
974:
975: amv_item_pub_w.rosetta_table_copy_in_p0(ddp_keyword_varray, p_keyword_varray);
976:
977: -- here's the delegated call to the old PL/SQL routine
978: amv_item_pub.add_itemkeyword(p_api_version,
979: p_init_msg_list,

Line 1024: amv_item_pub_w.rosetta_table_copy_in_p0(ddp_keyword_varray, p_keyword_varray);

1020:
1021:
1022:
1023:
1024: amv_item_pub_w.rosetta_table_copy_in_p0(ddp_keyword_varray, p_keyword_varray);
1025:
1026: -- here's the delegated call to the old PL/SQL routine
1027: amv_item_pub.delete_itemkeyword(p_api_version,
1028: p_init_msg_list,

Line 1073: amv_item_pub_w.rosetta_table_copy_in_p0(ddp_keyword_varray, p_keyword_varray);

1069:
1070:
1071:
1072:
1073: amv_item_pub_w.rosetta_table_copy_in_p0(ddp_keyword_varray, p_keyword_varray);
1074:
1075: -- here's the delegated call to the old PL/SQL routine
1076: amv_item_pub.replace_itemkeyword(p_api_version,
1077: p_init_msg_list,

Line 1139: amv_item_pub_w.rosetta_table_copy_out_p0(ddx_keyword_varray, x_keyword_varray);

1135:
1136:
1137:
1138:
1139: amv_item_pub_w.rosetta_table_copy_out_p0(ddx_keyword_varray, x_keyword_varray);
1140: end;
1141:
1142: procedure add_itemauthor(p_api_version NUMBER
1143: , p_init_msg_list VARCHAR2

Line 1167: amv_item_pub_w.rosetta_table_copy_in_p0(ddp_author_varray, p_author_varray);

1163:
1164:
1165:
1166:
1167: amv_item_pub_w.rosetta_table_copy_in_p0(ddp_author_varray, p_author_varray);
1168:
1169: -- here's the delegated call to the old PL/SQL routine
1170: amv_item_pub.add_itemauthor(p_api_version,
1171: p_init_msg_list,

Line 1216: amv_item_pub_w.rosetta_table_copy_in_p0(ddp_author_varray, p_author_varray);

1212:
1213:
1214:
1215:
1216: amv_item_pub_w.rosetta_table_copy_in_p0(ddp_author_varray, p_author_varray);
1217:
1218: -- here's the delegated call to the old PL/SQL routine
1219: amv_item_pub.delete_itemauthor(p_api_version,
1220: p_init_msg_list,

Line 1265: amv_item_pub_w.rosetta_table_copy_in_p0(ddp_author_varray, p_author_varray);

1261:
1262:
1263:
1264:
1265: amv_item_pub_w.rosetta_table_copy_in_p0(ddp_author_varray, p_author_varray);
1266:
1267: -- here's the delegated call to the old PL/SQL routine
1268: amv_item_pub.replace_itemauthor(p_api_version,
1269: p_init_msg_list,

Line 1331: amv_item_pub_w.rosetta_table_copy_out_p0(ddx_author_varray, x_author_varray);

1327:
1328:
1329:
1330:
1331: amv_item_pub_w.rosetta_table_copy_out_p0(ddx_author_varray, x_author_varray);
1332: end;
1333:
1334: procedure add_itemfile(p_api_version NUMBER
1335: , p_init_msg_list VARCHAR2

Line 1361: amv_item_pub_w.rosetta_table_copy_in_p1(ddp_file_id_varray, p_file_id_varray);

1357:
1358:
1359:
1360:
1361: amv_item_pub_w.rosetta_table_copy_in_p1(ddp_file_id_varray, p_file_id_varray);
1362:
1363: -- here's the delegated call to the old PL/SQL routine
1364: amv_item_pub.add_itemfile(p_api_version,
1365: p_init_msg_list,

Line 1412: amv_item_pub_w.rosetta_table_copy_in_p1(ddp_file_id_varray, p_file_id_varray);

1408:
1409:
1410:
1411:
1412: amv_item_pub_w.rosetta_table_copy_in_p1(ddp_file_id_varray, p_file_id_varray);
1413:
1414: -- here's the delegated call to the old PL/SQL routine
1415: amv_item_pub.delete_itemfile(p_api_version,
1416: p_init_msg_list,

Line 1461: amv_item_pub_w.rosetta_table_copy_in_p1(ddp_file_id_varray, p_file_id_varray);

1457:
1458:
1459:
1460:
1461: amv_item_pub_w.rosetta_table_copy_in_p1(ddp_file_id_varray, p_file_id_varray);
1462:
1463: -- here's the delegated call to the old PL/SQL routine
1464: amv_item_pub.replace_itemfile(p_api_version,
1465: p_init_msg_list,

Line 1527: amv_item_pub_w.rosetta_table_copy_out_p1(ddx_file_id_varray, x_file_id_varray);

1523:
1524:
1525:
1526:
1527: amv_item_pub_w.rosetta_table_copy_out_p1(ddx_file_id_varray, x_file_id_varray);
1528: end;
1529:
1530: procedure get_usermessage(p_api_version NUMBER
1531: , p_init_msg_list VARCHAR2

Line 1576: amv_item_pub_w.rosetta_table_copy_out_p1(ddx_item_id_varray, x_item_id_varray);

1572:
1573:
1574:
1575:
1576: amv_item_pub_w.rosetta_table_copy_out_p1(ddx_item_id_varray, x_item_id_varray);
1577:
1578: amv_item_pub_w.rosetta_table_copy_out_p0(ddx_message_varray, x_message_varray);
1579: end;
1580:

Line 1578: amv_item_pub_w.rosetta_table_copy_out_p0(ddx_message_varray, x_message_varray);

1574:
1575:
1576: amv_item_pub_w.rosetta_table_copy_out_p1(ddx_item_id_varray, x_item_id_varray);
1577:
1578: amv_item_pub_w.rosetta_table_copy_out_p0(ddx_message_varray, x_message_varray);
1579: end;
1580:
1581: procedure get_usermessage2(p_api_version NUMBER
1582: , p_init_msg_list VARCHAR2

Line 1651: amv_item_pub_w.rosetta_table_copy_out_p6(ddx_item_varray, p7_a0

1647:
1648:
1649:
1650:
1651: amv_item_pub_w.rosetta_table_copy_out_p6(ddx_item_varray, p7_a0
1652: , p7_a1
1653: , p7_a2
1654: , p7_a3
1655: , p7_a4

Line 1730: amv_item_pub_w.rosetta_table_copy_out_p8(ddx_channel_array, p8_a0

1726:
1727:
1728:
1729:
1730: amv_item_pub_w.rosetta_table_copy_out_p8(ddx_channel_array, p8_a0
1731: , p8_a1
1732: );
1733: end;
1734:

Line 1735: end amv_item_pub_w;

1731: , p8_a1
1732: );
1733: end;
1734:
1735: end amv_item_pub_w;