APPS.MSC_ST_UTIL dependencies on MSC_APPS_INSTANCES

Line 2108: lv_instance_code msc_apps_instances.instance_code%TYPE;

2104: | code in case the XML message does not contain the instance code |
2105: +==========================================================================*/
2106: FUNCTION GET_INSTANCE_CODE (p_trading_partner_id number) RETURN VARCHAR2
2107: IS
2108: lv_instance_code msc_apps_instances.instance_code%TYPE;
2109: /*
2110: CURSOR c_inst(p_trading_partner_id number) IS
2111: SELECT instance_code
2112: FROM msc_apps_instances mai

Line 2112: FROM msc_apps_instances mai

2108: lv_instance_code msc_apps_instances.instance_code%TYPE;
2109: /*
2110: CURSOR c_inst(p_trading_partner_id number) IS
2111: SELECT instance_code
2112: FROM msc_apps_instances mai
2113: WHERE mai.default_flag = 'Y'
2114: AND company_id = (SELECT company_id
2115: FROM msc_trading_partners mtp
2116: WHERE mtp.partner_id = p_trading_partner_id);

Line 2497: ||'FROM msc_apps_instances '

2493: BEGIN
2494:
2495: lv_sql_stmt:=
2496: 'SELECT instance_code '
2497: ||'FROM msc_apps_instances '
2498: ||'WHERE instance_id = :instance_id ';
2499:
2500: OPEN c_cur FOR lv_sql_stmt
2501: USING p_sr_instance_id;