APPS.MSC_SCE_LOADS_PKG dependencies on MSC_SERIAL_NUMBERS

Line 5445: UPDATE msc_serial_numbers msn

5441: WHERE msde.transaction_id = t_transaction_id(i);
5442:
5443: -- Disable all the corresponding serial Details
5444: FORALL i IN t_transaction_id.FIRST..t_transaction_id.LAST
5445: UPDATE msc_serial_numbers msn
5446: SET msn.disable_date = sysdate
5447: WHERE msn.serial_txn_id = t_transaction_id(i) AND
5448: NVL(msn.disable_date,sysdate+1) > sysdate ;
5449: END;

Line 10211: FROM msc_serial_numbers msn

10207: NVL(mssn.row_status, G_PROCESS) = G_PROCESS AND
10208: UPPER(NVL(mssn.sync_indicator, G_NULL_STRING))='D' AND
10209: NOT EXISTS (SELECT /*+ parallel(msn,5) */
10210: msn.serial_txn_id
10211: FROM msc_serial_numbers msn
10212: WHERE msn.serial_txn_id = mssn.serial_txn_id AND
10213: msn.serial_number = mssn.serial_number
10214: );
10215:

Line 10221: msc_serial_numbers msn

10217: -- Delete the record if the sync_indicator is 'D;
10218: --=====================================================
10219: FORALL j IN t_line_id.FIRST..t_line_id.LAST
10220: UPDATE /*+ parallel(msn,5) */
10221: msc_serial_numbers msn
10222: SET msn.disable_date = sysdate
10223: WHERE (msn.serial_txn_id,msn.serial_number) IN
10224: (SELECT /*+ parallel(mssn,5) */
10225: mssn.serial_txn_id,mssn.serial_number

Line 10239: DELETE FROM msc_serial_numbers msn

10235: --=========================================================
10236: -- Delete the previous record if the sync_indicator is 'R'
10237: --=========================================================
10238: FORALL j IN t_line_id.FIRST..t_line_id.LAST
10239: DELETE FROM msc_serial_numbers msn
10240: WHERE msn.serial_txn_id = (SELECT /*+ parallel(mssn,5) */
10241: mssn.serial_txn_id
10242: FROM msc_st_serial_numbers mssn
10243: WHERE mssn.parent_header_id = p_header_id AND

Line 10344: INTO msc_serial_numbers msn

10340:
10341: IF t_serial_number IS NOT NULL AND t_serial_number.COUNT > 0 THEN
10342: FORALL i IN t_serial_number.FIRST..t_serial_number.LAST
10343: INSERT /*+ parallel(msn,5) */
10344: INTO msc_serial_numbers msn
10345: (
10346: serial_txn_id,
10347: serial_number,
10348: plan_id,