APPS.MSC_SATP_FUNC dependencies on MRP_AP_APPS_INSTANCES

Line 4393: FROM mrp_ap_apps_instances;

4389:
4390: --Bug3765793 adding trim functions to remove spaces from db_link
4391: SELECT instance_id, ltrim(rtrim(a2m_dblink))
4392: INTO x_instance_id, x_dblink
4393: FROM mrp_ap_apps_instances;
4394:
4395: IF PG_DEBUG in ('Y', 'C') THEN
4396: msc_sch_wb.atp_debug('get_dblink_profile: ' || 'x_instance_id := ' || NVL(x_instance_id, -1));
4397: msc_sch_wb.atp_debug('get_dblink_profile: ' || 'a2m_dblink := ' || NVL(x_dblink,'NULL'));

Line 4403: msc_sch_wb.atp_debug('Error in mrp_ap_apps_instances : ' || sqlcode);

4399: EXCEPTION
4400: WHEN others THEN
4401: -- something wrong so we want to rollback;
4402: IF PG_DEBUG in ('Y', 'C') THEN
4403: msc_sch_wb.atp_debug('Error in mrp_ap_apps_instances : ' || sqlcode);
4404: END IF;
4405: x_return_status := FND_API.G_RET_STS_ERROR;
4406:
4407: End get_dblink_profile;