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 179: IF ((p_supplier_enabled = MSC_CL_COLLECTION.SYS_YES)

175: COMMIT;
176:
177: ELSIF (p_is_partial_refresh or p_is_cont_refresh) THEN
178:
179: IF ((p_supplier_enabled = MSC_CL_COLLECTION.SYS_YES)
180: OR
181: (p_customer_enabled = MSC_CL_COLLECTION.SYS_YES)) THEN
182:
183: -- ======================================================================================

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

177: ELSIF (p_is_partial_refresh or p_is_cont_refresh) THEN
178:
179: IF ((p_supplier_enabled = MSC_CL_COLLECTION.SYS_YES)
180: OR
181: (p_customer_enabled = MSC_CL_COLLECTION.SYS_YES)) THEN
182:
183: -- ======================================================================================
184: -- Delete Records from msc_trading_partner_maps which are of typr "Planning organization".
185: -- These records will be found using msc_company_site_id_lid as reference.

Line 1046: set process_flag = MSC_CL_COLLECTION.G_ERROR

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

Line 1107: set process_flag = MSC_CL_COLLECTION.G_ERROR

1103: END LOOP;
1104:
1105: FORALL i IN 1..a_company_id.COUNT
1106: UPDATE msc_st_item_customers msic
1107: set process_flag = MSC_CL_COLLECTION.G_ERROR
1108: where msic.customer_id = a_customer_id(i)
1109: and nvl(msic.customer_site_id, -99) = nvl(a_customer_site_id (i), -99)
1110: and msic.customer_item_name = a1_item_name(i);
1111:

Line 1603: and mcr.subject_id = MSC_CL_COLLECTION.G_MY_COMPANY_ID

1599: and mcil.company_id = mcr.object_id
1600: /* Perf changes start */
1601: /* Removed nvl(mtp.company_id,...) */
1602: and mtp.company_id IS NULL
1603: and mcr.subject_id = MSC_CL_COLLECTION.G_MY_COMPANY_ID
1604: /* and nvl(mtp.company_id, MSC_CL_COLLECTION.G_MY_COMPANY_ID) = mcr.subject_id */
1605: /* Perf changes end */
1606: and decode(mtp.partner_type, G_SUPPLIER, G_CUSTOMER, G_CUSTOMER, G_SUPPLIER)
1607: = mcr.relationship_type

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

1600: /* Perf changes start */
1601: /* Removed nvl(mtp.company_id,...) */
1602: and mtp.company_id IS NULL
1603: and mcr.subject_id = MSC_CL_COLLECTION.G_MY_COMPANY_ID
1604: /* and nvl(mtp.company_id, MSC_CL_COLLECTION.G_MY_COMPANY_ID) = mcr.subject_id */
1605: /* Perf changes end */
1606: and decode(mtp.partner_type, G_SUPPLIER, G_CUSTOMER, G_CUSTOMER, G_SUPPLIER)
1607: = mcr.relationship_type
1608: -- Make sure that only trading Partner records are considered.

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

1639: and mcsil.partner_type = mtp.partner_type
1640: and mtp.partner_type = G_ORGANIZATION
1641: -- Join for company_id
1642: /* Perf changes */
1643: /* and mcs.company_id = nvl(mtp.company_id, MSC_CL_COLLECTION.G_MY_COMPANY_ID) */
1644: and mcs.company_id = MSC_CL_COLLECTION.G_MY_COMPANY_ID
1645: and mtp.company_id IS NULL
1646: and not exists ( select 1
1647: from msc_trading_partner_maps mtpm

Line 1644: and mcs.company_id = MSC_CL_COLLECTION.G_MY_COMPANY_ID

1640: and mtp.partner_type = G_ORGANIZATION
1641: -- Join for company_id
1642: /* Perf changes */
1643: /* and mcs.company_id = nvl(mtp.company_id, MSC_CL_COLLECTION.G_MY_COMPANY_ID) */
1644: and mcs.company_id = MSC_CL_COLLECTION.G_MY_COMPANY_ID
1645: and mtp.company_id IS NULL
1646: and not exists ( select 1
1647: from msc_trading_partner_maps mtpm
1648: where mtpm.tp_key = mtp.partner_id