APPS.ICX_CAT_POPULATE_ITEM_PVT dependencies on PO_VENDORS

Line 3714: FROM po_vendors

3710: program_application_id = ICX_CAT_UTIL_PVT.g_who_columns_rec.program_application_id,
3711: program_id = ICX_CAT_UTIL_PVT.g_who_columns_rec.program_id,
3712: program_login_id = ICX_CAT_UTIL_PVT.g_who_columns_rec.program_login_id
3713: WHERE supplier_id IN (SELECT vendor_id
3714: FROM po_vendors
3715: WHERE party_id = p_vendor_party_id)
3716: AND internal_request_id <> ICX_CAT_UTIL_PVT.g_who_columns_rec.internal_request_id
3717: AND ROWNUM <= ICX_CAT_UTIL_PVT.g_batch_size
3718: RETURNING ROWID BULK COLLECT INTO l_rowid_tbl;

Line 3808: FROM po_vendors

3804: program_application_id = ICX_CAT_UTIL_PVT.g_who_columns_rec.program_application_id,
3805: program_id = ICX_CAT_UTIL_PVT.g_who_columns_rec.program_id,
3806: program_login_id = ICX_CAT_UTIL_PVT.g_who_columns_rec.program_login_id
3807: WHERE supplier_id IN (SELECT vendor_id
3808: FROM po_vendors
3809: WHERE party_id = p_vendor_party_id)
3810: AND internal_request_id <> ICX_CAT_UTIL_PVT.g_who_columns_rec.internal_request_id
3811: AND ROWNUM <= ICX_CAT_UTIL_PVT.g_batch_size;
3812:

Line 3876: l_to_vendor_name po_vendors.vendor_name%TYPE;

3872: )
3873: IS
3874: l_api_name CONSTANT VARCHAR2(30) := 'populateVendorMerge';
3875: l_err_loc PLS_INTEGER;
3876: l_to_vendor_name po_vendors.vendor_name%TYPE;
3877: l_continue BOOLEAN := TRUE;
3878: l_rowid_tbl DBMS_SQL.UROWID_TABLE;
3879: l_rows_updated BOOLEAN := TRUE;
3880: l_metadataTblFormed BOOLEAN := FALSE;

Line 3906: FROM po_vendors

3902: l_err_loc := 400;
3903:
3904: SELECT vendor_name
3905: INTO l_to_vendor_name
3906: FROM po_vendors
3907: WHERE vendor_id = p_to_vendor_id;
3908:
3909: l_err_loc := 500;
3910: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN