APPS.MSC_CL_SCE_COLLECTION dependencies on MSC_ST_ITEM_SUPPLIERS

Line 854: /* Error out records in msc_st_item_suppliers if

850: a_company_name companyNames;
851: a_sr_instance_id number_arr;
852:
853:
854: /* Error out records in msc_st_item_suppliers if
855: same Supplier Item belonging to same Supplier Site is pointing
856: to multiple master items.
857: */
858: CURSOR validateItemSuppliers IS

Line 867: from msc_st_item_suppliers

863: supplier_id,
864: supplier_site_id,
865: item_name,
866: count(*) count
867: from msc_st_item_suppliers
868: where sr_instance_id = p_instance_id
869: and item_name is not null
870: group by nvl(company_id ,-1), using_organization_id,
871: organization_id, supplier_id, supplier_site_id, item_name

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

993: RETURN FALSE;
994: END;
995: END IF;
996:
997: --==== Data Validation for the many to one records in msc_st_item_suppliers
998:
999: /* Error out records in msc_st_item_suppliers if
1000: same Supplier Item belonging to same Supplier Site is pointing
1001: to multiple master items.

Line 999: /* Error out records in msc_st_item_suppliers if

995: END IF;
996:
997: --==== Data Validation for the many to one records in msc_st_item_suppliers
998:
999: /* Error out records in msc_st_item_suppliers if
1000: same Supplier Item belonging to same Supplier Site is pointing
1001: to multiple master items.
1002: */
1003:

Line 1045: UPDATE msc_st_item_suppliers msis

1041:
1042:
1043:
1044: FORALL i IN 1..a_organization_id.COUNT
1045: UPDATE msc_st_item_suppliers msis
1046: set process_flag = MSC_CL_COLLECTION.G_ERROR
1047: where msis.organization_id = a_organization_id(i)
1048: and msis.supplier_id = a_supplier_id(i)
1049: and nvl(msis.supplier_site_id, -99) = nvl(a_supplier_site_id (i), -99)

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

1051:
1052: EXCEPTION
1053: WHEN OTHERS THEN
1054:
1055: LOG_MESSAGE('Error while updating invalid records in msc_st_item_suppliers');
1056: LOG_MESSAGE(SQLERRM);
1057: return FALSE;
1058: END;
1059: END IF;

Line 1198: from msc_st_item_suppliers msis,

1194: CURSOR supItemCompanies IS
1195: select ROWIDTOCHAR(msis.rowid),
1196: mcil.company_id,
1197: -99
1198: from msc_st_item_suppliers msis,
1199: msc_company_id_lid mcil
1200: where msis.supplier_id = mcil.sr_company_id
1201: and msis.sr_instance_id = mcil.sr_instance_id
1202: and mcil.partner_type = G_SUPPLIER

Line 1210: from msc_st_item_suppliers msis,

1206: UNION
1207: select ROWIDTOCHAR(msis.rowid),
1208: mcil.company_id,
1209: mcsil.company_site_id
1210: from msc_st_item_suppliers msis,
1211: msc_company_id_lid mcil,
1212: msc_company_site_id_lid mcsil
1213: where msis.supplier_id = mcil.sr_company_id
1214: and msis.sr_instance_id = mcil.sr_instance_id

Line 1273: UPDATE msc_st_item_suppliers mis

1269:
1270: IF a_rowid.COUNT > 0 THEN
1271: BEGIN
1272: FORALL i IN 1..a_rowid.COUNT
1273: UPDATE msc_st_item_suppliers mis
1274: set supplier_company_id = a_company_id(i),
1275: supplier_company_site_id = decode(a_company_site_id(i), -99, null, a_company_site_id(i))
1276: where mis.rowid = CHARTOROWID(a_rowid(i));
1277: EXCEPTION WHEN OTHERS THEN