APPS.ICX_CAT_POPULATE_ITEM_PVT dependencies on PO_VENDORS

Line 3739: FROM po_vendors

3735: program_application_id = ICX_CAT_UTIL_PVT.g_who_columns_rec.program_application_id,
3736: program_id = ICX_CAT_UTIL_PVT.g_who_columns_rec.program_id,
3737: program_login_id = ICX_CAT_UTIL_PVT.g_who_columns_rec.program_login_id
3738: WHERE supplier_id IN (SELECT vendor_id
3739: FROM po_vendors
3740: WHERE party_id = p_vendor_party_id)
3741: AND internal_request_id <> ICX_CAT_UTIL_PVT.g_who_columns_rec.internal_request_id
3742: AND ROWNUM <= ICX_CAT_UTIL_PVT.g_batch_size
3743: RETURNING ROWID BULK COLLECT INTO l_rowid_tbl;

Line 3833: FROM po_vendors

3829: program_application_id = ICX_CAT_UTIL_PVT.g_who_columns_rec.program_application_id,
3830: program_id = ICX_CAT_UTIL_PVT.g_who_columns_rec.program_id,
3831: program_login_id = ICX_CAT_UTIL_PVT.g_who_columns_rec.program_login_id
3832: WHERE supplier_id IN (SELECT vendor_id
3833: FROM po_vendors
3834: WHERE party_id = p_vendor_party_id)
3835: AND internal_request_id <> ICX_CAT_UTIL_PVT.g_who_columns_rec.internal_request_id
3836: AND ROWNUM <= ICX_CAT_UTIL_PVT.g_batch_size;
3837:

Line 3901: l_to_vendor_name po_vendors.vendor_name%TYPE;

3897: )
3898: IS
3899: l_api_name CONSTANT VARCHAR2(30) := 'populateVendorMerge';
3900: l_err_loc PLS_INTEGER;
3901: l_to_vendor_name po_vendors.vendor_name%TYPE;
3902: l_continue BOOLEAN := TRUE;
3903: l_rowid_tbl DBMS_SQL.UROWID_TABLE;
3904: l_rows_updated BOOLEAN := TRUE;
3905: l_metadataTblFormed BOOLEAN := FALSE;

Line 3931: FROM po_vendors

3927: l_err_loc := 400;
3928:
3929: SELECT vendor_name
3930: INTO l_to_vendor_name
3931: FROM po_vendors
3932: WHERE vendor_id = p_to_vendor_id;
3933:
3934: l_err_loc := 500;
3935: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN