DBA Data[Home] [Help]

APPS.POS_SUPPLIER_ADDRESS_PKG dependencies on AP_VENDOR_PUB_PKG

Line 348: l_vendor_site_rec ap_vendor_pub_pkg.r_vendor_site_rec_type;

344: l_location_id NUMBER;
345: l_party_site_use_id NUMBER;
346: l_ou_ids pos_security_profile_utl_pkg.number_table;
347: l_ou_count NUMBER;
348: l_vendor_site_rec ap_vendor_pub_pkg.r_vendor_site_rec_type;
349: l_vendor_site_id NUMBER;
350: l_dummy_location_id NUMBER;
351: l_dummy_party_site_id NUMBER;
352:

Line 867: l_vendor_contact_rec ap_vendor_pub_pkg.r_vendor_contact_rec_type;

863: AND ASCS.org_party_site_id = p_org_party_site_id
864: AND ASCS.per_party_id = p_contact_party_id;
865:
866: l_rec l_cur%ROWTYPE;
867: l_vendor_contact_rec ap_vendor_pub_pkg.r_vendor_contact_rec_type;
868:
869: BEGIN
870:
871: for l_rec in l_cur loop

Line 901: AP_VENDOR_PUB_PKG.Update_Vendor_Contact

897: ' org_contact_id ' || l_rec.org_contact_id);
898:
899: END IF;
900:
901: AP_VENDOR_PUB_PKG.Update_Vendor_Contact
902: (
903: p_api_version => 1.0,
904: p_init_msg_list => FND_API.G_TRUE,
905: p_commit => FND_API.G_FALSE,

Line 958: l_vendor_contact_rec ap_vendor_pub_pkg.r_vendor_contact_rec_type;

954: AND ASCS.org_party_site_id = p_org_party_site_id
955: AND ASCS.per_party_id = p_contact_party_id;
956:
957: l_rec l_cur%ROWTYPE;
958: l_vendor_contact_rec ap_vendor_pub_pkg.r_vendor_contact_rec_type;
959:
960: BEGIN
961:
962: for l_rec in l_cur loop

Line 992: AP_VENDOR_PUB_PKG.Update_Vendor_Contact

988: ' org_contact_id ' || l_rec.org_contact_id);
989:
990: END IF;
991:
992: AP_VENDOR_PUB_PKG.Update_Vendor_Contact
993: (
994: p_api_version => 1.0,
995: p_init_msg_list => FND_API.G_TRUE,
996: p_commit => FND_API.G_FALSE,

Line 1063: l_vendor_contact_rec ap_vendor_pub_pkg.r_vendor_contact_rec_type;

1059: AND rownum = 1;
1060:
1061: l_number NUMBER;
1062:
1063: l_vendor_contact_rec ap_vendor_pub_pkg.r_vendor_contact_rec_type;
1064:
1065: /* Bug 6610366 , Checking the Status from hz_relationships as status column
1066: in hz_org_contacts is obsoleted in R12 ,Also checking for */
1067:

Line 1236: AP_VENDOR_PUB_PKG.Update_Address_Assignments_DFF

1232: BEGIN
1233:
1234: /* Here We Need To Call AP Package For Updating The Address Assignments */
1235:
1236: AP_VENDOR_PUB_PKG.Update_Address_Assignments_DFF
1237: (
1238: p_api_version => 1,
1239: p_init_msg_list => FND_API.G_FALSE,
1240: p_commit => FND_API.G_FALSE,

Line 1266: ' After Calling AP_VENDOR_PUB_PKG.Update_Address_Assignments_DFF ');

1262: );
1263:
1264: IF ( fnd_log.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
1265: FND_LOG.string(fnd_log.level_statement, g_module,
1266: ' After Calling AP_VENDOR_PUB_PKG.Update_Address_Assignments_DFF ');
1267: FND_LOG.string(fnd_log.level_statement, g_module,
1268: ' x_return_status ' || x_return_status);
1269: FND_LOG.string(fnd_log.level_statement, g_module,
1270: ' x_msg_count ' || x_msg_count);