APPS.MSC_CL_SCE_COLLECTION dependencies on MSC_CL_COLLECTION

Line 39: p_status := MSC_CL_COLLECTION.G_ERROR;

35: v_my_company_old_name := MSC_CL_SCE_COLLECTION.GET_MY_COMPANY;
36: IF (v_my_company_old_name = null) then
37:
38: LOG_MESSAGE('Error while fetching Company Name');
39: p_status := MSC_CL_COLLECTION.G_ERROR;
40:
41: END IF;
42:
43: -- ========== Get My company's new name ============

Line 63: p_status := MSC_CL_COLLECTION.G_ERROR;

59:
60: EXCEPTION WHEN OTHERS THEN
61: LOG_MESSAGE('Error while updating Company Name in msc_companies');
62: ROLLBACK;
63: p_status := MSC_CL_COLLECTION.G_ERROR;
64: END;
65:
66: -- =======================================
67: -- Update msc_trading_partners.

Line 83: p_status := MSC_CL_COLLECTION.G_ERROR;

79: and nvl(company_id, 1) <> 1;
80: EXCEPTION WHEN OTHERS THEN
81: LOG_MESSAGE('Error while updating Company Name in msc_trading_partners');
82: ROLLBACK;
83: p_status := MSC_CL_COLLECTION.G_ERROR;
84: END;
85: end if;
86:
87: COMMIT;

Line 89: p_status := MSC_CL_COLLECTION.G_SUCCESS;

85: end if;
86:
87: COMMIT;
88:
89: p_status := MSC_CL_COLLECTION.G_SUCCESS;
90:
91: END; -- PROCESS_COMPANY_CHANGE
92:
93: FUNCTION SCE_TRANSFORM_KEYS(p_instance_id NUMBER,

Line 200: IF ((p_supplier_enabled = MSC_CL_COLLECTION.SYS_YES)

196: COMMIT;
197:
198: ELSIF (p_is_partial_refresh or p_is_cont_refresh) THEN
199:
200: IF ((p_supplier_enabled = MSC_CL_COLLECTION.SYS_YES)
201: OR
202: (p_customer_enabled = MSC_CL_COLLECTION.SYS_YES)) THEN
203:
204: -- ======================================================================================

Line 202: (p_customer_enabled = MSC_CL_COLLECTION.SYS_YES)) THEN

198: ELSIF (p_is_partial_refresh or p_is_cont_refresh) THEN
199:
200: IF ((p_supplier_enabled = MSC_CL_COLLECTION.SYS_YES)
201: OR
202: (p_customer_enabled = MSC_CL_COLLECTION.SYS_YES)) THEN
203:
204: -- ======================================================================================
205: -- Delete Records from msc_trading_partner_maps which are of typr "Planning organization".
206: -- These records will be found using msc_company_site_id_lid as reference.

Line 1129: set process_flag = MSC_CL_COLLECTION.G_ERROR

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)
1133: and msis.item_name = a_item_name(i);

Line 1190: set process_flag = MSC_CL_COLLECTION.G_ERROR

1186: END LOOP;
1187:
1188: FORALL i IN 1..a_company_id.COUNT
1189: UPDATE msc_st_item_customers msic
1190: set process_flag = MSC_CL_COLLECTION.G_ERROR
1191: where msic.customer_id = a_customer_id(i)
1192: and nvl(msic.customer_site_id, -99) = nvl(a_customer_site_id (i), -99)
1193: and msic.customer_item_name = a1_item_name(i);
1194:

Line 1686: and mcr.subject_id = MSC_CL_COLLECTION.G_MY_COMPANY_ID

1682: and mcil.company_id = mcr.object_id
1683: /* Perf changes start */
1684: /* Removed nvl(mtp.company_id,...) */
1685: and mtp.company_id IS NULL
1686: and mcr.subject_id = MSC_CL_COLLECTION.G_MY_COMPANY_ID
1687: /* and nvl(mtp.company_id, MSC_CL_COLLECTION.G_MY_COMPANY_ID) = mcr.subject_id */
1688: /* Perf changes end */
1689: and decode(mtp.partner_type, G_SUPPLIER, G_CUSTOMER, G_CUSTOMER, G_SUPPLIER)
1690: = mcr.relationship_type

Line 1687: /* and nvl(mtp.company_id, MSC_CL_COLLECTION.G_MY_COMPANY_ID) = mcr.subject_id */

1683: /* Perf changes start */
1684: /* Removed nvl(mtp.company_id,...) */
1685: and mtp.company_id IS NULL
1686: and mcr.subject_id = MSC_CL_COLLECTION.G_MY_COMPANY_ID
1687: /* and nvl(mtp.company_id, MSC_CL_COLLECTION.G_MY_COMPANY_ID) = mcr.subject_id */
1688: /* Perf changes end */
1689: and decode(mtp.partner_type, G_SUPPLIER, G_CUSTOMER, G_CUSTOMER, G_SUPPLIER)
1690: = mcr.relationship_type
1691: -- Make sure that only trading Partner records are considered.

Line 1726: /* and mcs.company_id = nvl(mtp.company_id, MSC_CL_COLLECTION.G_MY_COMPANY_ID) */

1722: and mcsil.partner_type = mtp.partner_type
1723: and mtp.partner_type = G_ORGANIZATION
1724: -- Join for company_id
1725: /* Perf changes */
1726: /* and mcs.company_id = nvl(mtp.company_id, MSC_CL_COLLECTION.G_MY_COMPANY_ID) */
1727: and mcs.company_id = MSC_CL_COLLECTION.G_MY_COMPANY_ID
1728: and mtp.company_id IS NULL
1729: and not exists ( select 1
1730: from msc_trading_partner_maps mtpm

Line 1727: and mcs.company_id = MSC_CL_COLLECTION.G_MY_COMPANY_ID

1723: and mtp.partner_type = G_ORGANIZATION
1724: -- Join for company_id
1725: /* Perf changes */
1726: /* and mcs.company_id = nvl(mtp.company_id, MSC_CL_COLLECTION.G_MY_COMPANY_ID) */
1727: and mcs.company_id = MSC_CL_COLLECTION.G_MY_COMPANY_ID
1728: and mtp.company_id IS NULL
1729: and not exists ( select 1
1730: from msc_trading_partner_maps mtpm
1731: where mtpm.tp_key = mtp.partner_id