APPS.MSC_CL_SCE_COLLECTION dependencies on MSC_ST_ITEM_SUPPLIERS

Line 937: /* Error out records in msc_st_item_suppliers if

933: a_company_name companyNames;
934: a_sr_instance_id number_arr;
935:
936:
937: /* Error out records in msc_st_item_suppliers if
938: same Supplier Item belonging to same Supplier Site is pointing
939: to multiple master items.
940: */
941: CURSOR validateItemSuppliers IS

Line 950: from msc_st_item_suppliers

946: supplier_id,
947: supplier_site_id,
948: item_name,
949: count(*) count
950: from msc_st_item_suppliers
951: where sr_instance_id = p_instance_id
952: and item_name is not null
953: group by nvl(company_id ,-1), using_organization_id,
954: organization_id, supplier_id, supplier_site_id, item_name

Line 1080: --==== Data Validation for the many to one records in msc_st_item_suppliers

1076: RETURN FALSE;
1077: END;
1078: END IF;
1079:
1080: --==== Data Validation for the many to one records in msc_st_item_suppliers
1081:
1082: /* Error out records in msc_st_item_suppliers if
1083: same Supplier Item belonging to same Supplier Site is pointing
1084: to multiple master items.

Line 1082: /* Error out records in msc_st_item_suppliers if

1078: END IF;
1079:
1080: --==== Data Validation for the many to one records in msc_st_item_suppliers
1081:
1082: /* Error out records in msc_st_item_suppliers if
1083: same Supplier Item belonging to same Supplier Site is pointing
1084: to multiple master items.
1085: */
1086:

Line 1128: UPDATE msc_st_item_suppliers msis

1124:
1125:
1126:
1127: FORALL i IN 1..a_organization_id.COUNT
1128: UPDATE msc_st_item_suppliers msis
1129: set process_flag = MSC_CL_COLLECTION.G_ERROR
1130: where msis.organization_id = a_organization_id(i)
1131: and msis.supplier_id = a_supplier_id(i)
1132: and nvl(msis.supplier_site_id, -99) = nvl(a_supplier_site_id (i), -99)

Line 1138: LOG_MESSAGE('Error while updating invalid records in msc_st_item_suppliers');

1134:
1135: EXCEPTION
1136: WHEN OTHERS THEN
1137:
1138: LOG_MESSAGE('Error while updating invalid records in msc_st_item_suppliers');
1139: LOG_MESSAGE(SQLERRM);
1140: return FALSE;
1141: END;
1142: END IF;

Line 1281: from msc_st_item_suppliers msis,

1277: CURSOR supItemCompanies IS
1278: select ROWIDTOCHAR(msis.rowid),
1279: mcil.company_id,
1280: -99
1281: from msc_st_item_suppliers msis,
1282: msc_company_id_lid mcil
1283: where msis.supplier_id = mcil.sr_company_id
1284: and msis.sr_instance_id = mcil.sr_instance_id
1285: and mcil.partner_type = G_SUPPLIER

Line 1293: from msc_st_item_suppliers msis,

1289: UNION
1290: select ROWIDTOCHAR(msis.rowid),
1291: mcil.company_id,
1292: mcsil.company_site_id
1293: from msc_st_item_suppliers msis,
1294: msc_company_id_lid mcil,
1295: msc_company_site_id_lid mcsil
1296: where msis.supplier_id = mcil.sr_company_id
1297: and msis.sr_instance_id = mcil.sr_instance_id

Line 1356: UPDATE msc_st_item_suppliers mis

1352:
1353: IF a_rowid.COUNT > 0 THEN
1354: BEGIN
1355: FORALL i IN 1..a_rowid.COUNT
1356: UPDATE msc_st_item_suppliers mis
1357: set supplier_company_id = a_company_id(i),
1358: supplier_company_site_id = decode(a_company_site_id(i), -99, null, a_company_site_id(i))
1359: where mis.rowid = CHARTOROWID(a_rowid(i));
1360: EXCEPTION WHEN OTHERS THEN