APPS.MSC_ST_UTIL dependencies on MSC_APPS_INSTANCES

Line 2068: lv_instance_code msc_apps_instances.instance_code%TYPE;

2064: | code in case the XML message does not contain the instance code |
2065: +==========================================================================*/
2066: FUNCTION GET_INSTANCE_CODE (p_trading_partner_id number) RETURN VARCHAR2
2067: IS
2068: lv_instance_code msc_apps_instances.instance_code%TYPE;
2069: /*
2070: CURSOR c_inst(p_trading_partner_id number) IS
2071: SELECT instance_code
2072: FROM msc_apps_instances mai

Line 2072: FROM msc_apps_instances mai

2068: lv_instance_code msc_apps_instances.instance_code%TYPE;
2069: /*
2070: CURSOR c_inst(p_trading_partner_id number) IS
2071: SELECT instance_code
2072: FROM msc_apps_instances mai
2073: WHERE mai.default_flag = 'Y'
2074: AND company_id = (SELECT company_id
2075: FROM msc_trading_partners mtp
2076: WHERE mtp.partner_id = p_trading_partner_id);

Line 2457: ||'FROM msc_apps_instances '

2453: BEGIN
2454:
2455: lv_sql_stmt:=
2456: 'SELECT instance_code '
2457: ||'FROM msc_apps_instances '
2458: ||'WHERE instance_id = :instance_id ';
2459:
2460: OPEN c_cur FOR lv_sql_stmt
2461: USING p_sr_instance_id;