APPS.AP_VENDOR_SITES_PKG dependencies on AP_PO_LOCN_ASSOCIATION_PKG

Line 510: ap_po_locn_association_pkg.insert_row( p_location_id => X_Shipping_Location_id,

506: if (X_Shipping_Location_id is not null) then
507:
508: debug_info := 'Insert values into PO_LOCATION_ASSOCIATIONS';
509:
510: ap_po_locn_association_pkg.insert_row( p_location_id => X_Shipping_Location_id,
511: p_vendor_id => X_Vendor_Id,
512: p_vendor_site_id => X_Vendor_Site_Id,
513: p_last_update_date => X_Last_Update_Date,
514: p_last_updated_by => X_Last_Updated_By,

Line 883: ap_po_locn_association_pkg.insert_row(

879: if (p_vendor_site_rec.Shipping_Location_id is not null) then
880:
881: debug_info := 'Insert values into PO_LOCATION_ASSOCIATIONS';
882:
883: ap_po_locn_association_pkg.insert_row(
884: p_location_id => p_vendor_site_rec.Ship_to_Location_id,
885: p_vendor_id => p_vendor_site_rec.Vendor_Id,
886: p_vendor_site_id => x_Vendor_Site_Id,
887: p_last_update_date => p_Last_Update_Date,

Line 1838: ap_po_locn_association_pkg.update_row(p_location_id => X_Shipping_Location_id,

1834: debug_info := 'Update values in PO_LOCATION_ASSOCIATIONS';
1835: --Bug 2697177: Added the IF condition
1836: if (X_Shipping_Location_id is not null and X_Shipping_Location_id <> ap_null_num) then /*Bug 11724842*/
1837:
1838: ap_po_locn_association_pkg.update_row(p_location_id => X_Shipping_Location_id,
1839: p_vendor_id => X_Vendor_Id,
1840: p_vendor_site_id => X_Vendor_Site_Id,
1841: p_last_update_date => X_Last_Update_Date,
1842: p_last_updated_by => X_Last_Updated_By,

Line 1849: ap_po_locn_association_pkg.delete_row(p_vendor_site_id => X_Vendor_Site_Id);

1845: p_created_by => X_Created_By,
1846: p_org_id => X_Org_ID); --MO Access Control
1847: /*Bug 11724842 start */
1848: else
1849: ap_po_locn_association_pkg.delete_row(p_vendor_site_id => X_Vendor_Site_Id);
1850: /*Bug 11724842 end */
1851: end if;
1852:
1853: EXCEPTION

Line 2058: ap_po_locn_association_pkg.update_row(

2054:
2055: debug_info := 'Update values in PO_LOCATION_ASSOCIATIONS';
2056: if (p_vendor_site_rec.Shipping_Location_id is not null and p_vendor_site_rec.Shipping_Location_id <> ap_null_num) then /*Bug11724842 */
2057:
2058: ap_po_locn_association_pkg.update_row(
2059: p_location_id => p_vendor_site_rec.Shipping_Location_id,
2060: /* 5945837: Shipping_Location_id is stored in po_location_associations*/
2061: p_vendor_id => p_vendor_site_rec.Vendor_Id,
2062: p_vendor_site_id => P_Vendor_Site_Id,

Line 2071: ap_po_locn_association_pkg.delete_row(p_vendor_site_id => P_Vendor_Site_Id);

2067: p_created_by => -1,
2068: p_org_id => p_vendor_site_rec.Org_ID);
2069: /*Bug11724842 Start*/
2070: else
2071: ap_po_locn_association_pkg.delete_row(p_vendor_site_id => P_Vendor_Site_Id);
2072: /*Bug11724842 end*/
2073: end if;
2074:
2075: EXCEPTION