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_CL_PRE_PROCESS dependencies on MSC_ST_UOM_CONVERSIONS

Line 20070: | msc_st_uom_conversions. |

20066:
20067: /*==========================================================================+
20068: | DESCRIPTION : This procedure performs validation and loads data into the |
20069: | tables msc_st_uom_class_conversions and |
20070: | msc_st_uom_conversions. |
20071: +==========================================================================*/
20072: PROCEDURE LOAD_UOM_CLASS_CONV IS
20073: TYPE RowidTab IS TABLE OF ROWID INDEX BY BINARY_INTEGER;
20074: TYPE CharTblTyp IS TABLE OF VARCHAR2(1000);

Line 20119: FROM msc_st_uom_conversions

20115: AND sr_instance_code = v_instance_code;
20116:
20117: CURSOR c3(p_batch_id NUMBER) IS
20118: SELECT rowid
20119: FROM msc_st_uom_conversions
20120: WHERE process_flag IN (G_IN_PROCESS,G_ERROR_FLG)
20121: AND batch_id = p_batch_id
20122: AND sr_instance_code = v_instance_code;
20123:

Line 20773: 'UPDATE msc_st_uom_conversions mcc1 '

20769:
20770: --Duplicate records check for the records whose source is XML.
20771: v_sql_stmt := 23;
20772: lv_sql_stmt :=
20773: 'UPDATE msc_st_uom_conversions mcc1 '
20774: ||' SET process_flag = '||G_ERROR_FLG||','
20775: ||' error_text = '||''''||lv_message_text||''''
20776: ||' WHERE message_id < (SELECT MAX(message_id) '
20777: ||' FROM msc_st_uom_conversions mcc2 '

Line 20777: ||' FROM msc_st_uom_conversions mcc2 '

20773: 'UPDATE msc_st_uom_conversions mcc1 '
20774: ||' SET process_flag = '||G_ERROR_FLG||','
20775: ||' error_text = '||''''||lv_message_text||''''
20776: ||' WHERE message_id < (SELECT MAX(message_id) '
20777: ||' FROM msc_st_uom_conversions mcc2 '
20778: ||' WHERE NVL(mcc2.item_name, '||''''||NULL_CHAR||''''||') = '
20779: ||' NVL(mcc1.item_name, '||''''||NULL_CHAR||''''||')'
20780: ||' AND NVL(mcc2.unit_of_measure, '||''''||NULL_CHAR||''''||') = '
20781: ||' NVL(mcc1.unit_of_measure, '||''''||NULL_CHAR||''''||')'

Line 20813: 'UPDATE msc_st_uom_conversions mcc1 '

20809: --Different SQL is used because in XML we can identify the latest records
20810: --whereas in batch load we cannot.
20811: v_sql_stmt := 24;
20812: lv_sql_stmt :=
20813: 'UPDATE msc_st_uom_conversions mcc1 '
20814: ||' SET process_flag = '||G_ERROR_FLG||','
20815: ||' error_text = '||''''||lv_message_text||''''
20816: ||' WHERE EXISTS( SELECT 1 '
20817: ||' FROM msc_st_uom_conversions mcc2'

Line 20817: ||' FROM msc_st_uom_conversions mcc2'

20813: 'UPDATE msc_st_uom_conversions mcc1 '
20814: ||' SET process_flag = '||G_ERROR_FLG||','
20815: ||' error_text = '||''''||lv_message_text||''''
20816: ||' WHERE EXISTS( SELECT 1 '
20817: ||' FROM msc_st_uom_conversions mcc2'
20818: ||' WHERE NVL(mcc2.item_name, '||''''||NULL_CHAR||''''||') = '
20819: ||' NVL(mcc1.item_name, '||''''||NULL_CHAR||''''||')'
20820: ||' AND NVL(mcc2.unit_of_measure, '||''''||NULL_CHAR||''''||') = '
20821: ||' NVL(mcc1.unit_of_measure, '||''''||NULL_CHAR||''''||')'

Line 20861: 'UPDATE msc_st_uom_conversions '

20857: FROM dual;
20858:
20859: v_sql_stmt := 26;
20860: lv_sql_stmt :=
20861: 'UPDATE msc_st_uom_conversions '
20862: ||' SET batch_id = :lv_batch_id'
20863: ||' WHERE process_flag IN ('||G_IN_PROCESS||','||G_ERROR_FLG||')'
20864: ||' AND sr_instance_code = :v_instance_code'
20865: ||' AND NVL(batch_id,'||NULL_VALUE||') = '||NULL_VALUE

Line 20883: UPDATE msc_st_uom_conversions

20879: CLOSE c3;
20880:
20881: v_sql_stmt := 27;
20882: FORALL j IN lb_rowid.FIRST..lb_rowid.LAST
20883: UPDATE msc_st_uom_conversions
20884: SET st_transaction_id = msc_st_uom_conversions_s.NEXTVAL,
20885: refresh_id = v_refresh_id,
20886: last_update_date = v_current_date,
20887: last_updated_by = v_current_user,

Line 20884: SET st_transaction_id = msc_st_uom_conversions_s.NEXTVAL,

20880:
20881: v_sql_stmt := 27;
20882: FORALL j IN lb_rowid.FIRST..lb_rowid.LAST
20883: UPDATE msc_st_uom_conversions
20884: SET st_transaction_id = msc_st_uom_conversions_s.NEXTVAL,
20885: refresh_id = v_refresh_id,
20886: last_update_date = v_current_date,
20887: last_updated_by = v_current_user,
20888: creation_date = v_current_date,

Line 20898: p_token_value1 => 'MSC_ST_UOM_CONVERSIONS');

20894: p_error_code => 'MSC_PP_NO_DELETION',
20895: p_message_text => lv_message_text,
20896: p_error_text => lv_error_text,
20897: p_token1 => 'TABLE_NAME',
20898: p_token_value1 => 'MSC_ST_UOM_CONVERSIONS');
20899:
20900: IF lv_return <> 0 THEN
20901: RAISE ex_logging_err;
20902: END IF;

Line 20907: 'UPDATE msc_st_uom_conversions'

20903:
20904: --Deletion is not allowed on this table.
20905: v_sql_stmt := 28;
20906: lv_sql_stmt :=
20907: 'UPDATE msc_st_uom_conversions'
20908: ||' SET process_flag = '||G_ERROR_FLG||','
20909: ||' error_text = '||''''||lv_message_text||''''
20910: ||' WHERE deleted_flag = '||SYS_YES
20911: ||' AND process_flag = '||G_IN_PROCESS

Line 20937: 'UPDATE msc_st_uom_conversions'

20933:
20934: --Item Name is mandatory if the Default Conversion Flag is set to 'Y' (fix for 2747791)
20935: v_sql_stmt := 29;
20936: lv_sql_stmt :=
20937: 'UPDATE msc_st_uom_conversions'
20938: ||' SET process_flag = '||G_ERROR_FLG||','
20939: ||' error_text = '||''''||lv_message_text||''''
20940: ||' WHERE item_name IS NULL '
20941: ||' AND default_conversion_flag = ''Y'' '

Line 20975: (p_table_name => 'MSC_ST_UOM_CONVERSIONS',

20971:
20972: --Log a warning for those records where the deleted_flag has a value other
20973: --than SYS_NO
20974: lv_return := MSC_ST_UTIL.LOG_ERROR
20975: (p_table_name => 'MSC_ST_UOM_CONVERSIONS',
20976: p_instance_code => v_instance_code,
20977: p_row => lv_column_names,
20978: p_severity => G_SEV_WARNING,
20979: p_message_text => lv_message_text,

Line 21005: 'UPDATE msc_st_uom_conversions'

21001: END IF;
21002:
21003: v_sql_stmt := 30;
21004: lv_sql_stmt :=
21005: 'UPDATE msc_st_uom_conversions'
21006: ||' SET process_flag = '||G_ERROR_FLG||','
21007: ||' error_text = '||''''||lv_message_text||''''
21008: ||' WHERE (NVL(uom_code, '||''''||NULL_CHAR||''''||') '
21009: ||' = '||''''||NULL_CHAR||''''

Line 21024: 'UPDATE msc_st_uom_conversions'

21020: v_instance_code;
21021:
21022: v_sql_stmt := 30;
21023: lv_sql_stmt :=
21024: 'UPDATE msc_st_uom_conversions'
21025: ||' SET unit_of_measure = uom_code'
21026: ||' WHERE NVL(unit_of_measure,'||''''||NULL_CHAR||''''||')'
21027: ||' = '||''''||NULL_CHAR||''''
21028: ||' AND process_flag = '||G_IN_PROCESS

Line 21049: p_token_value3 => 'MSC_ST_UOM_CONVERSIONS');

21045: p_token_value1 => 'UOM_CODE, UOM_CLASS AND UNIT_OF_MEASURE',
21046: p_token2 => 'MASTER_TABLE',
21047: p_token_value2 => 'MSC_ST_UNITS_OF_MEASURE',
21048: p_token3 => 'CHILD_TABLE',
21049: p_token_value3 => 'MSC_ST_UOM_CONVERSIONS');
21050: IF lv_return <> 0 THEN
21051: RAISE ex_logging_err;
21052: END IF;
21053:

Line 21056: ' UPDATE msc_st_uom_conversions mcc'

21052: END IF;
21053:
21054: v_sql_stmt := 31;
21055: lv_sql_stmt :=
21056: ' UPDATE msc_st_uom_conversions mcc'
21057: ||' SET process_flag = '||G_ERROR_FLG||','
21058: ||' error_text = '||''''||lv_message_text||''''
21059: ||' WHERE NOT EXISTS(SELECT 1'
21060: ||' FROM msc_units_of_measure mum'

Line 21097: 'UPDATE msc_st_uom_conversions'

21093: END IF;
21094:
21095: v_sql_stmt := 32;
21096: lv_sql_stmt :=
21097: 'UPDATE msc_st_uom_conversions'
21098: ||' SET process_flag = '||G_ERROR_FLG||','
21099: ||' error_text = '||''''||lv_message_text||''''
21100: ||' WHERE NVL(conversion_rate,'||NULL_VALUE||') <= 0'
21101: ||' AND process_flag = '||G_IN_PROCESS

Line 21127: 'UPDATE msc_st_uom_conversions'

21123:
21124: /* --Org code is mandatory where item name is not null
21125: v_sql_stmt := 33;
21126: lv_sql_stmt :=
21127: 'UPDATE msc_st_uom_conversions'
21128: ||' SET process_flag = '||G_ERROR_FLG||','
21129: ||' error_text = '||''''||lv_message_text||''''
21130: ||' WHERE NVL(item_name, '||''''||NULL_CHAR||''''||') '
21131: ||' <> '||''''||NULL_CHAR||''''

Line 21160: (p_table_name => 'MSC_ST_UOM_CONVERSIONS',

21156: END IF;
21157:
21158: --Derive Organization_id
21159: lv_return := MSC_ST_UTIL.DERIVE_PARTNER_ORG_ID
21160: (p_table_name => 'MSC_ST_UOM_CONVERSIONS',
21161: p_org_partner_name => 'ORGANIZATION_CODE',
21162: p_org_partner_id => 'ORGANIZATION_ID',
21163: p_instance_code => v_instance_code,
21164: p_partner_type => G_ORGANIZATION,

Line 21178: 'UPDATE msc_st_uom_conversions mcc '

21174: END IF; */
21175:
21176: --Update inventory_item_id
21177: lv_sql_stmt :=
21178: 'UPDATE msc_st_uom_conversions mcc '
21179: ||' SET inventory_item_id = (SELECT local_id'
21180: ||' FROM msc_local_id_item mli'
21181: ||' WHERE mli.char1 = mcc.sr_instance_code '
21182: ||' AND NVL(mli.char2, '||''''||NULL_CHAR||''''||')='

Line 21234: 'UPDATE msc_st_uom_conversions '

21230:
21231: --Item id is set to 0 if the inventory_item_id is NULL
21232: v_sql_stmt := 34;
21233: lv_sql_stmt :=
21234: 'UPDATE msc_st_uom_conversions '
21235: ||' SET inventory_item_id = 0 '
21236: ||' WHERE process_flag = '||G_IN_PROCESS
21237: ||' AND batch_id = :lv_batch_id'
21238: ||' AND sr_instance_code = :v_instance_code'

Line 21254: pEntityName => 'MSC_ST_UOM_CONVERSIONS',

21250: (ERRBUF => lv_error_text,
21251: RETCODE => lv_return,
21252: pBatchID => lv_batch_id,
21253: pInstanceCode => v_instance_code,
21254: pEntityName => 'MSC_ST_UOM_CONVERSIONS',
21255: pInstanceID => v_instance_id);
21256:
21257: IF NVL(lv_return,0) <> 0 THEN
21258: RAISE ex_logging_err;

Line 21262: (p_table_name => 'MSC_ST_UOM_CONVERSIONS',

21258: RAISE ex_logging_err;
21259: END IF;
21260:
21261: lv_return := MSC_ST_UTIL.SET_PROCESS_FLAG
21262: (p_table_name => 'MSC_ST_UOM_CONVERSIONS',
21263: p_instance_id => v_instance_id,
21264: p_instance_code => v_instance_code,
21265: p_process_flag => G_VALID,
21266: p_error_text => lv_error_text,

Line 21275: (p_table_name => 'MSC_ST_UOM_CONVERSIONS',

21271: RAISE ex_logging_err;
21272: END IF;
21273:
21274: lv_return := MSC_ST_UTIL.LOG_ERROR
21275: (p_table_name => 'MSC_ST_UOM_CONVERSIONS',
21276: p_instance_code => v_instance_code,
21277: p_row => lv_column_names,
21278: p_severity => G_SEV_ERROR,
21279: p_message_text => NULL,

Line 55996: lv_count:= SET_IN_PROCESS (p_table_name => 'MSC_ST_UOM_CONVERSIONS');

55992: lv_count:= SET_IN_PROCESS (p_table_name => 'MSC_ST_UOM_CLASS_CONVERSIONS');
55993: IF lv_count > 0 Then
55994: prec.uom_flag:= SYS_YES;
55995: End IF;
55996: lv_count:= SET_IN_PROCESS (p_table_name => 'MSC_ST_UOM_CONVERSIONS');
55997: IF lv_count > 0 Then
55998: prec.uom_flag:= SYS_YES;
55999: End IF;
56000: END IF;