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_INTERORG_SHIP_METHODS

Line 1276: ||' on MSC_ST_INTERORG_SHIP_METHODS '

1272: application_short_name => 'MSC',
1273: statement_type => AD_DDL.CREATE_INDEX,
1274: statement =>
1275: 'create index MSC_ST_INTERORG_SHIP_N1_'||v_instance_code
1276: ||' on MSC_ST_INTERORG_SHIP_METHODS '
1277: ||'(sr_instance_code,from_organization_code,to_organization_code,ship_method,company_name) '
1278: ||' STORAGE (INITIAL 100K NEXT 1M PCTINCREASE 0) ',
1279: object_name =>'MSC_ST_INTERORG_SHIP_N1_'||v_instance_code);
1280:

Line 1288: msc_analyse_tables_pk.analyse_table( 'MSC_ST_INTERORG_SHIP_METHODS', v_instance_id, -1);

1284: WHEN OTHERS THEN
1285: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_WARNING,'Error creating Index MSC_ST_INTERORG_SHIP_N1_'||v_instance_code||'. Error:'||substr(SQLERRM,1,240));
1286: END;
1287:
1288: msc_analyse_tables_pk.analyse_table( 'MSC_ST_INTERORG_SHIP_METHODS', v_instance_id, -1);
1289:
1290: END IF;
1291:
1292: IF v_sourcing_enabled = SYS_YES THEN

Line 16006: | methods for table MSC_ST_INTERORG_SHIP_METHODS |

16002:
16003:
16004: /*==========================================================================+
16005: | DESCRIPTION : This procedure validates the data for inter org shipping |
16006: | methods for table MSC_ST_INTERORG_SHIP_METHODS |
16007: +==========================================================================*/
16008: PROCEDURE LOAD_SHIP_METHODS IS
16009:
16010: TYPE RowidTab IS TABLE OF ROWID INDEX BY BINARY_INTEGER;

Line 16024: FROM msc_st_interorg_ship_methods

16020: ex_logging_err EXCEPTION;
16021:
16022: CURSOR c1(p_batch_id NUMBER) IS
16023: SELECT rowid
16024: FROM msc_st_interorg_ship_methods
16025: WHERE process_flag IN (G_IN_PROCESS,G_ERROR_FLG)
16026: AND sr_instance_code = v_instance_code
16027: AND batch_id = p_batch_id;
16028:

Line 16049: 'UPDATE msc_st_interorg_ship_methods msis1 '

16045: --whereas in batch load we cannot.
16046:
16047: v_sql_stmt := 01;
16048: lv_sql_stmt :=
16049: 'UPDATE msc_st_interorg_ship_methods msis1 '
16050: ||' SET process_flag = '||G_ERROR_FLG||','
16051: ||' error_text = '||''''||lv_message_text||''''
16052: ||' WHERE EXISTS ( SELECT 1 FROM msc_st_interorg_ship_methods msis2 '
16053: ||' WHERE msis2.sr_instance_code = msis1.sr_instance_code'

Line 16052: ||' WHERE EXISTS ( SELECT 1 FROM msc_st_interorg_ship_methods msis2 '

16048: lv_sql_stmt :=
16049: 'UPDATE msc_st_interorg_ship_methods msis1 '
16050: ||' SET process_flag = '||G_ERROR_FLG||','
16051: ||' error_text = '||''''||lv_message_text||''''
16052: ||' WHERE EXISTS ( SELECT 1 FROM msc_st_interorg_ship_methods msis2 '
16053: ||' WHERE msis2.sr_instance_code = msis1.sr_instance_code'
16054: ||' AND NVL(msis2.company_name, '||''''||NULL_CHAR||''''||') = '
16055: ||' NVL(msis1.company_name, '||''''||NULL_CHAR||''''||')'
16056: ||' AND NVL(msis2.from_organization_code, '||''''||NULL_CHAR||''''||') = '

Line 16129: 'UPDATE msc_st_interorg_ship_methods msis1 '

16125:
16126: --Duplicate records check for the records whose source is XML
16127: v_sql_stmt := 02;
16128: lv_sql_stmt :=
16129: 'UPDATE msc_st_interorg_ship_methods msis1 '
16130: ||' SET process_flag = '||G_ERROR_FLG||','
16131: ||' error_text = '||''''||lv_message_text||''''
16132: ||' WHERE message_id < ( SELECT max(message_id) '
16133: ||' FROM msc_st_interorg_ship_methods msis2 '

Line 16133: ||' FROM msc_st_interorg_ship_methods msis2 '

16129: 'UPDATE msc_st_interorg_ship_methods msis1 '
16130: ||' SET process_flag = '||G_ERROR_FLG||','
16131: ||' error_text = '||''''||lv_message_text||''''
16132: ||' WHERE message_id < ( SELECT max(message_id) '
16133: ||' FROM msc_st_interorg_ship_methods msis2 '
16134: ||' WHERE msis2.sr_instance_code = msis1.sr_instance_code'
16135: ||' AND NVL(msis2.company_name, '||''''||NULL_CHAR||''''||') = '
16136: ||' NVL(msis1.company_name, '||''''||NULL_CHAR||''''||')'
16137: ||' AND NVL(msis2.from_organization_code, '||''''||NULL_CHAR||''''||') = '

Line 16225: 'UPDATE msc_st_interorg_ship_methods '

16221: FROM DUAL;
16222:
16223: v_sql_stmt := 04;
16224: lv_sql_stmt :=
16225: 'UPDATE msc_st_interorg_ship_methods '
16226: ||' SET batch_id = :lv_batch_id '
16227: ||' WHERE process_flag IN ('||G_IN_PROCESS||','||G_ERROR_FLG||')'
16228: ||' AND sr_instance_code = :v_instance_code'
16229: ||' AND NVL(batch_id,'||NULL_VALUE||') = '||NULL_VALUE

Line 16247: UPDATE msc_st_interorg_ship_methods

16243: CLOSE c1;
16244:
16245: v_sql_stmt := 05;
16246: FORALL j IN lb_rowid.FIRST..lb_rowid.LAST
16247: UPDATE msc_st_interorg_ship_methods
16248: SET st_transaction_id = msc_st_interorg_ship_methods_s.NEXTVAL,
16249: refresh_id = v_refresh_id,
16250: last_update_date = v_current_date,
16251: last_updated_by = v_current_user,

Line 16248: SET st_transaction_id = msc_st_interorg_ship_methods_s.NEXTVAL,

16244:
16245: v_sql_stmt := 05;
16246: FORALL j IN lb_rowid.FIRST..lb_rowid.LAST
16247: UPDATE msc_st_interorg_ship_methods
16248: SET st_transaction_id = msc_st_interorg_ship_methods_s.NEXTVAL,
16249: refresh_id = v_refresh_id,
16250: last_update_date = v_current_date,
16251: last_updated_by = v_current_user,
16252: creation_date = v_current_date,

Line 16262: p_token_value1 => 'MSC_ST_INTERORG_SHIP_METHODS');

16258: p_error_code => 'MSC_PP_NO_DELETION',
16259: p_message_text => lv_message_text,
16260: p_error_text => lv_error_text,
16261: p_token1 => 'TABLE_NAME',
16262: p_token_value1 => 'MSC_ST_INTERORG_SHIP_METHODS');
16263:
16264:
16265: -- Deletion is not allowed for this table
16266: v_sql_stmt := 06;

Line 16268: 'UPDATE msc_st_interorg_ship_methods '

16264:
16265: -- Deletion is not allowed for this table
16266: v_sql_stmt := 06;
16267: lv_sql_stmt :=
16268: 'UPDATE msc_st_interorg_ship_methods '
16269: ||' SET process_flag = '||G_ERROR_FLG||','
16270: ||' error_text = '||''''||lv_message_text||''''
16271: ||' WHERE deleted_flag = '||SYS_YES
16272: ||' AND process_flag = '||G_IN_PROCESS

Line 16306: (p_table_name => 'MSC_ST_INTERORG_SHIP_METHODS',

16302: lv_where_str := ' AND NVL(deleted_flag,'||NULL_VALUE||') '
16303: ||' NOT IN(1,2)';
16304:
16305: lv_return := MSC_ST_UTIL.LOG_ERROR
16306: (p_table_name => 'MSC_ST_INTERORG_SHIP_METHODS',
16307: p_instance_code => v_instance_code,
16308: p_row => lv_column_names,
16309: p_severity => G_SEV_WARNING,
16310: p_message_text => lv_message_text,

Line 16337: 'UPDATE msc_st_interorg_ship_methods'

16333:
16334: -- Error out records where ship_method is NULL
16335: v_sql_stmt := 07;
16336: lv_sql_stmt :=
16337: 'UPDATE msc_st_interorg_ship_methods'
16338: ||' SET process_flag = '||G_ERROR_FLG||','
16339: ||' error_text = '||''''||lv_message_text||''''
16340: ||' WHERE NVL(ship_method, '||''''||NULL_CHAR||''''||') '
16341: ||' = '||''''||NULL_CHAR||''''

Line 16369: (p_table_name => 'MSC_ST_INTERORG_SHIP_METHODS',

16365:
16366: -- Derive from_organization_id
16367:
16368: lv_return := MSC_ST_UTIL.DERIVE_PARTNER_ORG_ID
16369: (p_table_name => 'MSC_ST_INTERORG_SHIP_METHODS',
16370: p_org_partner_name => 'FROM_ORGANIZATION_CODE',
16371: p_org_partner_id => 'FROM_ORGANIZATION_ID',
16372: p_instance_code => v_instance_code,
16373: p_partner_type => G_ORGANIZATION,

Line 16385: 'UPDATE msc_st_interorg_ship_methods '

16381: RAISE ex_logging_err;
16382: END IF;
16383:
16384: lv_sql_stmt :=
16385: 'UPDATE msc_st_interorg_ship_methods '
16386: ||' SET FROM_ORGANIZATION_ID = -1 '
16387: ||' WHERE NVL(FROM_ORGANIZATION_ID,'||NULL_VALUE||') = '||NULL_VALUE
16388: ||' AND NVL(FROM_ORGANIZATION_CODE,'||''''||NULL_CHAR||''''||')'
16389: ||' = '||''''||NULL_CHAR||''''

Line 16419: (p_table_name => 'MSC_ST_INTERORG_SHIP_METHODS',

16415:
16416: -- Derive to_organization_id
16417:
16418: lv_return := MSC_ST_UTIL.DERIVE_PARTNER_ORG_ID
16419: (p_table_name => 'MSC_ST_INTERORG_SHIP_METHODS',
16420: p_org_partner_name => 'TO_ORGANIZATION_CODE',
16421: p_org_partner_id => 'TO_ORGANIZATION_ID',
16422: p_instance_code => v_instance_code,
16423: p_partner_type => G_ORGANIZATION,

Line 16435: 'UPDATE msc_st_interorg_ship_methods '

16431: RAISE ex_logging_err;
16432: END IF;
16433:
16434: lv_sql_stmt :=
16435: 'UPDATE msc_st_interorg_ship_methods '
16436: ||' SET TO_ORGANIZATION_ID = -1 '
16437: ||' WHERE NVL(TO_ORGANIZATION_ID,'||NULL_VALUE||') = '||NULL_VALUE
16438: ||' AND NVL(TO_ORGANIZATION_CODE,'||''''||NULL_CHAR||''''||')'
16439: ||' = '||''''||NULL_CHAR||''''

Line 16455: 'UPDATE msc_st_interorg_ship_methods msis'

16451:
16452: -- Update FROM_LOCATION_ID
16453: v_sql_stmt := 08;
16454: lv_sql_stmt :=
16455: 'UPDATE msc_st_interorg_ship_methods msis'
16456: ||' SET from_location_id = (SELECT local_id'
16457: ||' FROM msc_local_id_setup mls'
16458: ||' WHERE mls.char1 = msis.sr_instance_code'
16459: ||' AND mls.char3 = msis.from_location_code'

Line 16477: 'UPDATE msc_st_interorg_ship_methods msis'

16473: -- Update TO_LOCATION_ID
16474:
16475: v_sql_stmt := 09;
16476: lv_sql_stmt :=
16477: 'UPDATE msc_st_interorg_ship_methods msis'
16478: ||' SET to_location_id = (SELECT local_id'
16479: ||' FROM msc_local_id_setup mls'
16480: ||' WHERE mls.char1 = msis.sr_instance_code'
16481: ||' AND mls.char3 = msis.to_location_code'

Line 16512: 'UPDATE msc_st_interorg_ship_methods '

16508: END IF;
16509:
16510: v_sql_stmt := 9.1;
16511: lv_sql_stmt :=
16512: 'UPDATE msc_st_interorg_ship_methods '
16513: ||' SET error_text = '||''''||lv_error_text||''''||','
16514: ||' process_flag = '||G_ERROR
16515: ||' WHERE NVL(to_location_id,'||NULL_VALUE||') = '||NULL_VALUE
16516: ||' AND NVL(to_location_code,'||''''||NULL_CHAR||''''||')'

Line 16545: 'UPDATE msc_st_interorg_ship_methods '

16541: END IF;
16542:
16543: v_sql_stmt := 9.2;
16544: lv_sql_stmt :=
16545: 'UPDATE msc_st_interorg_ship_methods '
16546: ||' SET error_text = '||''''||lv_error_text||''''||','
16547: ||' process_flag = '||G_ERROR
16548: ||' WHERE NVL(from_location_id,'||NULL_VALUE||') = '||NULL_VALUE
16549: ||' AND NVL(from_location_code,'||''''||NULL_CHAR||''''||')'

Line 16564: 'UPDATE msc_st_interorg_ship_methods '

16560: USING lv_batch_id,
16561: v_instance_code;
16562:
16563: lv_sql_stmt :=
16564: 'UPDATE msc_st_interorg_ship_methods '
16565: ||' SET from_location_id = -1'
16566: ||' WHERE NVL(from_location_id,'||NULL_VALUE||') = '||NULL_VALUE
16567: ||' AND NVL(from_location_code,'||''''||NULL_CHAR||''''||')'
16568: ||' = '||''''||NULL_CHAR||''''

Line 16582: 'UPDATE msc_st_interorg_ship_methods '

16578: USING lv_batch_id,
16579: v_instance_code;
16580:
16581: lv_sql_stmt :=
16582: 'UPDATE msc_st_interorg_ship_methods '
16583: ||' SET to_location_id = -1'
16584: ||' WHERE NVL(to_location_id,'||NULL_VALUE||') = '||NULL_VALUE
16585: ||' AND NVL(to_location_code,'||''''||NULL_CHAR||''''||')'
16586: ||' = '||''''||NULL_CHAR||''''

Line 16602: 'UPDATE msc_st_interorg_ship_methods msr'

16598:
16599: -- Derive from_region_id
16600:
16601: lv_sql_stmt :=
16602: 'UPDATE msc_st_interorg_ship_methods msr'
16603: ||' SET from_region_id = (SELECT local_id'
16604: ||' FROM msc_local_id_setup mls'
16605: ||' WHERE mls.char1 = msr.sr_instance_code'
16606: ||' AND mls.number1 = nvl(msr.from_region_type,'||NULL_VALUE||')'

Line 16641: 'UPDATE msc_st_interorg_ship_methods msr'

16637:
16638: -- Derive to_region_id
16639:
16640: lv_sql_stmt :=
16641: 'UPDATE msc_st_interorg_ship_methods msr'
16642: ||' SET to_region_id = (SELECT local_id'
16643: ||' FROM msc_local_id_setup mls'
16644: ||' WHERE mls.char1 = msr.sr_instance_code'
16645: ||' AND mls.number1 = nvl(msr.to_region_type,'||NULL_VALUE||')'

Line 16702: 'UPDATE msc_st_interorg_ship_methods msis1'

16698:
16699:
16700: v_sql_stmt := 9.1;
16701: lv_sql_stmt :=
16702: 'UPDATE msc_st_interorg_ship_methods msis1'
16703: ||' SET process_flag = '||G_ERROR_FLG||','
16704: ||' error_text = '||''''||lv_message_text||''''
16705: ||' WHERE (msis1.to_location_id is NULL OR msis1.from_location_id is NULL) '
16706: ||' AND (msis1.to_organization_id is NULL OR msis1.from_organization_id is NULL) '

Line 16736: (p_table_name => 'MSC_ST_INTERORG_SHIP_METHODS',

16732: lv_where_str := ' AND NVL(default_flag,'||NULL_VALUE||') '
16733: ||' NOT IN(1,2)';
16734:
16735: lv_return := MSC_ST_UTIL.LOG_ERROR
16736: (p_table_name => 'MSC_ST_INTERORG_SHIP_METHODS',
16737: p_instance_code => v_instance_code,
16738: p_row => lv_column_names,
16739: p_severity => G_SEV_WARNING,
16740: p_message_text => lv_message_text,

Line 16773: 'UPDATE msc_st_interorg_ship_methods msis1'

16769: -- forward ported 2767559
16770:
16771: v_sql_stmt := 12;
16772: lv_sql_stmt :=
16773: 'UPDATE msc_st_interorg_ship_methods msis1'
16774: ||' SET process_flag = '||G_ERROR_FLG||','
16775: ||' error_text = '||''''||lv_message_text||''''
16776: ||' WHERE EXISTS( SELECT 1 '
16777: ||' FROM msc_st_interorg_ship_methods msis2'

Line 16777: ||' FROM msc_st_interorg_ship_methods msis2'

16773: 'UPDATE msc_st_interorg_ship_methods msis1'
16774: ||' SET process_flag = '||G_ERROR_FLG||','
16775: ||' error_text = '||''''||lv_message_text||''''
16776: ||' WHERE EXISTS( SELECT 1 '
16777: ||' FROM msc_st_interorg_ship_methods msis2'
16778: ||' WHERE msis2.sr_instance_code = msis1.sr_instance_code'
16779: ||' AND nvl(msis2.from_organization_code, '||''''||NULL_CHAR||''''||') = '
16780: ||' nvl(msis1.from_organization_code, '||''''||NULL_CHAR||''''||')'
16781: ||' AND nvl(msis2.to_organization_code, '||''''||NULL_CHAR||''''||') = '

Line 16840: MSC_ST_UTIL.VALIDATE_UOM (p_table_name => 'MSC_ST_INTERORG_SHIP_METHODS',

16836:
16837: -- Validate Volume UOM
16838:
16839: lv_return :=
16840: MSC_ST_UTIL.VALIDATE_UOM (p_table_name => 'MSC_ST_INTERORG_SHIP_METHODS',
16841: p_uom_col_name => 'VOLUME_UOM',
16842: p_instance_id => v_instance_id,
16843: p_instance_code => v_instance_code,
16844: p_severity => G_SEV3_ERROR,

Line 16869: MSC_ST_UTIL.VALIDATE_UOM (p_table_name => 'MSC_ST_INTERORG_SHIP_METHODS',

16865:
16866: -- Validate Weight UOM
16867:
16868: lv_return :=
16869: MSC_ST_UTIL.VALIDATE_UOM (p_table_name => 'MSC_ST_INTERORG_SHIP_METHODS',
16870: p_uom_col_name => 'WEIGHT_UOM',
16871: p_instance_id => v_instance_id,
16872: p_instance_code => v_instance_code,
16873: p_severity => G_SEV3_ERROR,

Line 16890: pEntityName => 'MSC_ST_INTERORG_SHIP_METHODS',

16886: (ERRBUF => lv_error_text,
16887: RETCODE => lv_return,
16888: pBatchID => lv_batch_id,
16889: pInstanceCode => v_instance_code,
16890: pEntityName => 'MSC_ST_INTERORG_SHIP_METHODS',
16891: pInstanceID => v_instance_id);
16892:
16893: IF NVL(lv_return,0) <> 0 THEN
16894: RAISE ex_logging_err;

Line 16899: (p_table_name => 'MSC_ST_INTERORG_SHIP_METHODS',

16895: END IF;
16896:
16897:
16898: lv_return := MSC_ST_UTIL.SET_PROCESS_FLAG
16899: (p_table_name => 'MSC_ST_INTERORG_SHIP_METHODS',
16900: p_instance_id => v_instance_id,
16901: p_instance_code => v_instance_code,
16902: p_process_flag => G_VALID,
16903: p_error_text => lv_error_text,

Line 16913: 'UPDATE msc_st_interorg_ship_methods'

16909: END IF;
16910:
16911: v_sql_stmt := 13;
16912: lv_sql_stmt :=
16913: 'UPDATE msc_st_interorg_ship_methods'
16914: ||' SET sr_instance_id2 = '||v_instance_id
16915: ||' WHERE sr_instance_code = :v_instance_code'
16916: ||' AND process_flag ='|| G_VALID
16917: ||' AND batch_id = :lv_batch_id' ;

Line 16926: (p_table_name => 'MSC_ST_INTERORG_SHIP_METHODS',

16922:
16923: EXECUTE IMMEDIATE lv_sql_stmt USING v_instance_code,lv_batch_id;
16924:
16925: lv_return := MSC_ST_UTIL.LOG_ERROR
16926: (p_table_name => 'MSC_ST_INTERORG_SHIP_METHODS',
16927: p_instance_code => v_instance_code,
16928: p_row => lv_column_names,
16929: p_severity => G_SEV_ERROR,
16930: p_message_text => NULL,

Line 55825: lv_count:= SET_IN_PROCESS (p_table_name => 'MSC_ST_INTERORG_SHIP_METHODS');

55821: End IF;
55822: END IF;
55823:
55824: IF v_ship_mthd_enabled = SYS_YES THEN
55825: lv_count:= SET_IN_PROCESS (p_table_name => 'MSC_ST_INTERORG_SHIP_METHODS');
55826: IF lv_count > 0 Then
55827: prec.sourcing_rule_flag:= SYS_YES;
55828: End IF;
55829: END IF;