eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.MSC_SCE_LOADS_PKG dependencies on MSC_ST_SERIAL_NUMBERS

Line 9808: from msc_st_serial_numbers

9804: p_start_line IN Number,
9805: p_end_line IN Number
9806: ) IS
9807: select line_id, nvl(master_item_name,publisher_item_name), order_type,serial_number, err_msg
9808: from msc_st_serial_numbers
9809: where parent_header_id = p_header_id and
9810: row_status = G_FAILURE AND
9811: line_id BETWEEN p_start_line and p_end_line;
9812:

Line 9818: FROM msc_st_serial_numbers

9814: BEGIN
9815: BEGIN
9816: SELECT min(line_id),max(line_id)
9817: INTO l_min,l_max
9818: FROM msc_st_serial_numbers
9819: WHERE parent_header_id = p_header_id;
9820: EXCEPTION
9821: WHEN NO_DATA_FOUND THEN
9822: l_min := 0;

Line 9861: FROM msc_st_serial_numbers

9857:
9858: SELECT /*+ parallel(mssn,5) */
9859: line_id
9860: BULK COLLECT INTO t_line_id
9861: FROM msc_st_serial_numbers
9862: WHERE parent_header_id = p_header_id AND
9863: line_id BETWEEN l_start_line and l_end_line;
9864:
9865:

Line 9874: msc_st_serial_numbers mssn

9870: --=================================================
9871: l_err_msg := get_message('MSC', 'MSC_X_INVALID_SYNC_INDICATOR', p_language);
9872: FORALL j IN t_line_id.FIRST..t_line_id.LAST
9873: UPDATE /*+ parallel(mssn,5) */
9874: msc_st_serial_numbers mssn
9875: SET mssn.err_msg = substrb(l_err_msg,1,1000),
9876: mssn.row_status = G_FAILURE
9877: WHERE mssn.parent_header_id = p_header_id AND
9878: mssn.line_id = t_line_id(j) AND

Line 9888: msc_st_serial_numbers mssn

9884: --======================================================
9885: l_err_msg := get_message('MSC', 'MSC_X_INVALID_ORDER_TYPE', p_language);
9886: FORALL j IN t_line_id.FIRST..t_line_id.LAST
9887: UPDATE /*+ parallel(mssn,5) */
9888: msc_st_serial_numbers mssn
9889: SET mssn.err_msg = --DECODE(mssn.err_msg, NULL, l_err_msg ,
9890: -- mssn.err_msg || ' ' || l_err_msg ),
9891: substrb(l_err_msg,1,1000),
9892: mssn.row_status = G_FAILURE

Line 9910: msc_st_serial_numbers mssn

9906: --======================================================================
9907: l_err_msg := get_message('MSC', 'MSC_X_INVALID_NO_ITEM', p_language);
9908: FORALL j IN t_line_id.FIRST..t_line_id.LAST
9909: UPDATE /*+ parallel(mssn,5) */
9910: msc_st_serial_numbers mssn
9911: SET mssn.err_msg = --DECODE(mssn.err_msg, NULL, l_err_msg,
9912: -- mssn.err_msg || ' ' || l_err_msg ),
9913: substrb(l_err_msg,1,1000),
9914: mssn.row_status = G_FAILURE

Line 9928: msc_st_serial_numbers mssn

9924: --==============================================================
9925: l_err_msg := get_message('MSC', 'MSC_X_NO_SERIAL_NUMBER',p_language);
9926: FORALL j IN t_line_id.FIRST..t_line_id.LAST
9927: UPDATE /*+ parallel(mssn,5) */
9928: msc_st_serial_numbers mssn
9929: SET mssn.err_msg = --DECODE(mssn.err_msg, NULL, l_err_msg ,
9930: -- mssn.err_msg || ' ' || l_err_msg),
9931: substrb(l_err_msg,1,1000),
9932: mssn.row_status = G_FAILURE

Line 9944: msc_st_serial_numbers mssn

9940: -- Derive the publisher id
9941: --=============================================================
9942: FORALL j IN t_line_id.FIRST..t_line_id.LAST
9943: UPDATE /*+ parallel(mssn,5) */
9944: msc_st_serial_numbers mssn
9945: SET mssn.publisher_id = (SELECT /*+ parallel(mc,5) */
9946: mc.company_id
9947: FROM msc_companies mc
9948: WHERE UPPER(mssn.publisher_company) = UPPER(mc.company_name)

Line 9960: msc_st_serial_numbers mssn

9956: --==============================================================
9957: l_err_msg := get_message('MSC', 'MSC_X_INVALID_PUBLISHER', p_language);
9958: FORALL j IN t_line_id.FIRST..t_line_id.LAST
9959: UPDATE /*+ parallel(mssn,5) */
9960: msc_st_serial_numbers mssn
9961: SET mssn.err_msg = --DECODE(mssn.err_msg, NULL, l_err_msg,
9962: -- mssn.err_msg || ' ' || l_err_msg),
9963: substrb(l_err_msg,1,1000),
9964: mssn.row_status = G_FAILURE

Line 9977: msc_st_serial_numbers mssn

9973: --Derive the publisher site id
9974: --==========================================================
9975: FORALL j IN t_line_id.FIRST..t_line_id.LAST
9976: UPDATE /*+ parallel(mssn,5) */
9977: msc_st_serial_numbers mssn
9978: SET mssn.publisher_site_id = (SELECT /*+ parallel(mcs,5) */
9979: mcs.company_site_id
9980: FROM msc_company_sites mcs
9981: WHERE mssn.publisher_id=mcs.company_id AND

Line 9995: msc_st_serial_numbers mssn

9991: --============================================================
9992: l_err_msg := get_message('MSC', 'MSC_X_INVALID_PUBLISHER_SITE', p_language);
9993: FORALL j IN t_line_id.FIRST..t_line_id.LAST
9994: UPDATE /*+ parallel(mssn,5) */
9995: msc_st_serial_numbers mssn
9996: SET mssn.err_msg = --DECODE(mssn.err_msg, NULL, l_err_msg,
9997: -- mssn.err_msg || ' ' || l_err_msg ),
9998: substrb(l_err_msg,1,1000),
9999: mssn.row_status = G_FAILURE

Line 10012: msc_st_serial_numbers mssn

10008: -- Derive the inventory_item_id
10009: --====================================================
10010: FORALL j IN t_line_id.FIRST..t_line_id.LAST
10011: UPDATE /*+ parallel(mssn,5) */
10012: msc_st_serial_numbers mssn
10013: SET mssn.inventory_item_id = (SELECT /*+ parallel(mi,5) */
10014: mi.inventory_item_id
10015: FROM msc_items mi
10016: WHERE mi.item_name = mssn.master_item_name AND

Line 10112: msc_st_serial_numbers mssn

10108: --=======================================================
10109: l_err_msg := get_message('MSC', 'MSC_X_INVALID_ITEM', p_language);
10110: FORALL j IN t_line_id.FIRST..t_line_id.LAST
10111: UPDATE /*+ parallel(mssn,5) */
10112: msc_st_serial_numbers mssn
10113: SET mssn.err_msg = --DECODE(mssn.err_msg, NULL, l_err_msg ,
10114: -- mssn.err_msg || ' ' || l_err_msg),
10115: substrb(l_err_msg,1,1000),
10116: mssn.row_status = G_FAILURE

Line 10129: msc_st_serial_numbers mssn

10125: IF NVL(FND_PROFILE.VALUE('MSC_DEFAULT_SERIAL_CONTROL'),'Y') ='Y' THEN
10126: l_err_msg := get_message('MSC', 'MSC_X_INVALID_SERIAL_FLAG', p_language);
10127: FORALL j IN t_line_id.FIRST..t_line_id.LAST
10128: UPDATE /*+ parallel(mssn,5) */
10129: msc_st_serial_numbers mssn
10130: SET mssn.err_msg = --DECODE(mssn.err_msg, NULL, l_err_msg ,
10131: -- mssn.err_msg || ' ' || l_err_msg),
10132: substrb(l_err_msg,1,1000),
10133: mssn.row_status = G_FAILURE

Line 10157: msc_st_serial_numbers mssn

10153: -- Derive transaction id
10154: --===============================================================
10155: FORALL j IN t_line_id.FIRST..t_line_id.LAST
10156: UPDATE /*+ parallel(mssn,5) */
10157: msc_st_serial_numbers mssn
10158: SET mssn.serial_txn_id = (SELECT /*+ parallel(msde,5) */
10159: msde.transaction_id
10160: FROM msc_sup_dem_entries msde
10161: WHERE msde.plan_id = -1 AND

Line 10182: msc_st_serial_numbers mssn

10178: --=======================================================
10179: l_err_msg := get_message('MSC', 'MSC_X_ONHAND_NOT_FOUND', p_language);
10180: FORALL j IN t_line_id.FIRST..t_line_id.LAST
10181: UPDATE /*+ parallel(mssn,5) */
10182: msc_st_serial_numbers mssn
10183: SET mssn.err_msg = --DECODE(mssn.err_msg, NULL, l_err_msg,
10184: -- mssn.err_msg || ' ' || l_err_msg ),
10185: substrb(l_err_msg,1,1000),
10186: mssn.row_status = G_FAILURE

Line 10200: msc_st_serial_numbers mssn

10196: --========================================================
10197: l_err_msg := get_message('MSC', 'MSC_X_SERIAL_DATA_NOT_FOUND', p_language);
10198: FORALL j IN t_line_id.FIRST..t_line_id.LAST
10199: UPDATE /*+ parallel(mssn,5) */
10200: msc_st_serial_numbers mssn
10201: SET mssn.err_msg = -- DECODE(mssn.err_msg, NULL, l_err_msg,
10202: -- mssn.err_msg || ' ' || l_err_msg),
10203: substrb(l_err_msg,1,1000),
10204: mssn.row_status = G_FAILURE

Line 10226: FROM msc_st_serial_numbers mssn

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
10226: FROM msc_st_serial_numbers mssn
10227: WHERE mssn.parent_header_id = p_header_id AND
10228: mssn.line_id = t_line_id(j) AND
10229: NVL(mssn.row_status, G_PROCESS) = G_PROCESS AND
10230: UPPER(NVL(mssn.sync_indicator, G_NULL_STRING))='D'

Line 10242: FROM msc_st_serial_numbers mssn

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
10244: mssn.line_id = t_line_id(j) AND
10245: NVL(mssn.row_status, G_PROCESS) = G_PROCESS AND
10246: UPPER(NVL(mssn.sync_indicator, G_NULL_STRING))='R'

Line 10330: FROM msc_st_serial_numbers mssn

10326: t_attribute12,
10327: t_attribute13,
10328: t_attribute14,
10329: t_attribute15
10330: FROM msc_st_serial_numbers mssn
10331: WHERE mssn.parent_header_id = p_header_id AND
10332: NVL(mssn.row_status, G_PROCESS) = G_PROCESS AND
10333: UPPER(NVL(mssn.sync_indicator, G_NULL_STRING))='R' AND
10334: mssn.line_id BETWEEN l_start_line and l_end_line;

Line 10471: DELETE FROM msc_st_serial_numbers mssn

10467:
10468: --=====================================================
10469: -- Delete all the record which has not errored out
10470: --=====================================================
10471: DELETE FROM msc_st_serial_numbers mssn
10472: WHERE NVL(mssn.row_status, G_PROCESS) = G_PROCESS AND
10473: mssn.parent_header_id = p_header_id ;
10474:
10475:

Line 10486: ||' on MSC_ST_SERIAL_NUMBERS '

10482: application_short_name => 'MSC',
10483: statement_type => AD_DDL.CREATE_INDEX,
10484: statement =>
10485: 'create index MSC_ST_SERIAL_NUMBER_N1'
10486: ||' on MSC_ST_SERIAL_NUMBERS '
10487: ||'(publisher_company,publisher_site,publisher_item_name,master_item_name,order_type) '
10488: ||' STORAGE (INITIAL 100K NEXT 1M PCTINCREASE 0) ',
10489: object_name =>'MSC_ST_SERIAL_NUMBER_N1'
10490: );