[Home] [Help]
6892: AND mstp.sr_instance_code = v_instance_code
6893: AND mstp.batch_id = lv_batch_id
6894: AND mstp.partner_type = G_ORGANIZATION
6895: AND EXISTS -- check against those orgs which do not belong to this company
6896: (SELECT mtp.organization_code from msc_trading_partners mtp
6897: WHERE mstp.organization_code = mtp.organization_code
6898: AND mtp.sr_instance_id = v_instance_id
6899: AND mtp.partner_type = G_ORGANIZATION
6900: MINUS
7311: 'UPDATE msc_st_trading_partners mstp'
7312: ||' SET process_flag = '||G_ERROR_FLG||','
7313: ||' error_text = '||''''||lv_message_text||''''
7314: ||' WHERE EXISTS(SELECT 1 '
7315: ||' FROM msc_trading_partners mtp,'
7316: ||' msc_company_id_lid mcil'
7317: ||' WHERE mtp.partner_name = mstp.partner_name'
7318: ||' AND mtp.partner_type = mstp.partner_type'
7319: ||' AND mtp.organization_code <> mstp.organization_code'
7341: 'UPDATE msc_st_trading_partners mstp'
7342: ||' SET process_flag = '||G_ERROR_FLG||','
7343: ||' error_text = '||''''||lv_message_text||''''
7344: ||' WHERE EXISTS(SELECT 1 '
7345: ||' FROM msc_trading_partners mtp'
7346: ||' WHERE mtp.partner_name = mstp.partner_name'
7347: ||' AND mtp.partner_type = mstp.partner_type'
7348: ||' AND mtp.organization_code <> mstp.organization_code'
7349: ||' AND nvl(mtp.company_id,1) = 1)'
20637: ||' AND EXISTS (SELECT msn.serial_txn_id
20638: FROM msc_serial_numbers msn,
20639: msc_sup_dem_entries msde,
20640: msc_trading_partner_maps mtpm,
20641: msc_trading_partners mtp,
20642: msc_item_id_lid miil,
20643: msc_apps_instances mai
20644: WHERE msde.inventory_item_id = miil.inventory_item_id
20645: AND miil.sr_inventory_item_id = mssi.sr_inventory_item_id
28832:
28833: lv_sql_stmt :=
28834: 'UPDATE msc_st_resource_shifts msrs'
28835: ||' SET shift_num =(SELECT mlis.local_id'
28836: ||' FROM msc_local_id_setup mlis, msc_trading_partners mtp '
28837: ||' WHERE mtp.sr_instance_id = '||v_instance_id
28838: ||' AND mlis.char1 = msrs.sr_instance_code'
28839: ||' AND NVL(mlis.char2,'||''''||NULL_CHAR||''''||') '
28840: ||' = NVL(msrs.company_name,'||''''||NULL_CHAR||''''||') '
29407:
29408: lv_sql_stmt :=
29409: 'UPDATE msc_st_resource_changes msrc'
29410: ||' SET shift_num =(SELECT mlis.local_id'
29411: ||' FROM msc_local_id_setup mlis, msc_trading_partners mtp '
29412: ||' WHERE mtp.sr_instance_id = '||v_instance_id
29413: ||' AND mlis.char1 = msrc.sr_instance_code'
29414: ||' AND NVL(mlis.char2,'||''''||NULL_CHAR||''''||') '
29415: ||' = NVL(msrc.company_name,'||''''||NULL_CHAR||''''||') '
49222: v_current_date,
49223: v_current_user,
49224: v_current_date,
49225: v_current_user
49226: FROM msc_period_start_dates mpsd,msc_trading_partners mtp
49227: WHERE mpsd.calendar_code = mtp.calendar_code
49228: AND mpsd.sr_instance_id = mtp.sr_instance_id
49229: AND mtp.partner_type = G_ORGANIZATION
49230: AND mtp.sr_instance_id = v_instance_id );
49280: AND mtp.partner_type = G_ORGANIZATION
49281: AND mtp.process_flag = G_VALID
49282: AND mtp.sr_instance_id = v_instance_id
49283: AND NOT EXISTS(SELECT 1
49284: FROM msc_trading_partners mtpo
49285: WHERE mtpo.sr_instance_id = mtp.sr_instance_id
49286: AND mtpo.partner_type = mtp.partner_type
49287: AND mtpo.sr_tp_id = mtp.sr_tp_id));
49288: END IF;
50443: IF lv_return <> 0 THEN
50444: RAISE ex_logging_err;
50445: END IF;
50446:
50447: -- check customer exists in msc_trading_partners
50448: -- Set the message
50449:
50450: v_sql_stmt := 12;
50451: