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_ITEM_CUSTOMERS

Line 1224: 'create index MSC_ST_ITEM_CUSTOMERS_N1_'||v_instance_code

1220: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,
1221: application_short_name => 'MSC',
1222: statement_type => AD_DDL.CREATE_INDEX,
1223: statement =>
1224: 'create index MSC_ST_ITEM_CUSTOMERS_N1_'||v_instance_code
1225: ||' on MSC_ST_ITEM_CUSTOMERS '
1226: ||'(ITEM_NAME, CUSTOMER_NAME, SR_INSTANCE_CODE, COMPANY_NAME, CUSTOMER_SITE_NAME) '
1227: ||' STORAGE (INITIAL 100K NEXT 1M PCTINCREASE 0) ',
1228: object_name =>'MSC_ST_ITEM_CUSTOMERS_N1_'||v_instance_code);

Line 1225: ||' on MSC_ST_ITEM_CUSTOMERS '

1221: application_short_name => 'MSC',
1222: statement_type => AD_DDL.CREATE_INDEX,
1223: statement =>
1224: 'create index MSC_ST_ITEM_CUSTOMERS_N1_'||v_instance_code
1225: ||' on MSC_ST_ITEM_CUSTOMERS '
1226: ||'(ITEM_NAME, CUSTOMER_NAME, SR_INSTANCE_CODE, COMPANY_NAME, CUSTOMER_SITE_NAME) '
1227: ||' STORAGE (INITIAL 100K NEXT 1M PCTINCREASE 0) ',
1228: object_name =>'MSC_ST_ITEM_CUSTOMERS_N1_'||v_instance_code);
1229:

Line 1228: object_name =>'MSC_ST_ITEM_CUSTOMERS_N1_'||v_instance_code);

1224: 'create index MSC_ST_ITEM_CUSTOMERS_N1_'||v_instance_code
1225: ||' on MSC_ST_ITEM_CUSTOMERS '
1226: ||'(ITEM_NAME, CUSTOMER_NAME, SR_INSTANCE_CODE, COMPANY_NAME, CUSTOMER_SITE_NAME) '
1227: ||' STORAGE (INITIAL 100K NEXT 1M PCTINCREASE 0) ',
1228: object_name =>'MSC_ST_ITEM_CUSTOMERS_N1_'||v_instance_code);
1229:
1230: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,'Created Index MSC_ST_ITEM_CUSTOMERS_N1_'||v_instance_code);
1231:
1232: EXCEPTION

Line 1230: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,'Created Index MSC_ST_ITEM_CUSTOMERS_N1_'||v_instance_code);

1226: ||'(ITEM_NAME, CUSTOMER_NAME, SR_INSTANCE_CODE, COMPANY_NAME, CUSTOMER_SITE_NAME) '
1227: ||' STORAGE (INITIAL 100K NEXT 1M PCTINCREASE 0) ',
1228: object_name =>'MSC_ST_ITEM_CUSTOMERS_N1_'||v_instance_code);
1229:
1230: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,'Created Index MSC_ST_ITEM_CUSTOMERS_N1_'||v_instance_code);
1231:
1232: EXCEPTION
1233: WHEN OTHERS THEN
1234: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_WARNING,'Error creating Index MSC_ST_ITEM_CUSTOMERS_N1_'||v_instance_code||'. Error:'||substr(SQLERRM,1,240));

Line 1234: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_WARNING,'Error creating Index MSC_ST_ITEM_CUSTOMERS_N1_'||v_instance_code||'. Error:'||substr(SQLERRM,1,240));

1230: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,'Created Index MSC_ST_ITEM_CUSTOMERS_N1_'||v_instance_code);
1231:
1232: EXCEPTION
1233: WHEN OTHERS THEN
1234: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_WARNING,'Error creating Index MSC_ST_ITEM_CUSTOMERS_N1_'||v_instance_code||'. Error:'||substr(SQLERRM,1,240));
1235: END;
1236:
1237: BEGIN
1238:

Line 1243: 'create index MSC_ST_ITEM_CUSTOMERS_N2_'||v_instance_code

1239: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,
1240: application_short_name => 'MSC',
1241: statement_type => AD_DDL.CREATE_INDEX,
1242: statement =>
1243: 'create index MSC_ST_ITEM_CUSTOMERS_N2_'||v_instance_code
1244: ||' on MSC_ST_ITEM_CUSTOMERS '
1245: ||'(CUSTOMER_ITEM_NAME, CUSTOMER_NAME, SR_INSTANCE_CODE, COMPANY_NAME, CUSTOMER_SITE_NAME) '
1246: ||' STORAGE (INITIAL 100K NEXT 1M PCTINCREASE 0) ',
1247: object_name =>'MSC_ST_ITEM_CUSTOMERS_N2_'||v_instance_code);

Line 1244: ||' on MSC_ST_ITEM_CUSTOMERS '

1240: application_short_name => 'MSC',
1241: statement_type => AD_DDL.CREATE_INDEX,
1242: statement =>
1243: 'create index MSC_ST_ITEM_CUSTOMERS_N2_'||v_instance_code
1244: ||' on MSC_ST_ITEM_CUSTOMERS '
1245: ||'(CUSTOMER_ITEM_NAME, CUSTOMER_NAME, SR_INSTANCE_CODE, COMPANY_NAME, CUSTOMER_SITE_NAME) '
1246: ||' STORAGE (INITIAL 100K NEXT 1M PCTINCREASE 0) ',
1247: object_name =>'MSC_ST_ITEM_CUSTOMERS_N2_'||v_instance_code);
1248:

Line 1247: object_name =>'MSC_ST_ITEM_CUSTOMERS_N2_'||v_instance_code);

1243: 'create index MSC_ST_ITEM_CUSTOMERS_N2_'||v_instance_code
1244: ||' on MSC_ST_ITEM_CUSTOMERS '
1245: ||'(CUSTOMER_ITEM_NAME, CUSTOMER_NAME, SR_INSTANCE_CODE, COMPANY_NAME, CUSTOMER_SITE_NAME) '
1246: ||' STORAGE (INITIAL 100K NEXT 1M PCTINCREASE 0) ',
1247: object_name =>'MSC_ST_ITEM_CUSTOMERS_N2_'||v_instance_code);
1248:
1249: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,'Created Index MSC_ST_ITEM_CUSTOMERS_N2_'||v_instance_code);
1250:
1251: EXCEPTION

Line 1249: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,'Created Index MSC_ST_ITEM_CUSTOMERS_N2_'||v_instance_code);

1245: ||'(CUSTOMER_ITEM_NAME, CUSTOMER_NAME, SR_INSTANCE_CODE, COMPANY_NAME, CUSTOMER_SITE_NAME) '
1246: ||' STORAGE (INITIAL 100K NEXT 1M PCTINCREASE 0) ',
1247: object_name =>'MSC_ST_ITEM_CUSTOMERS_N2_'||v_instance_code);
1248:
1249: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,'Created Index MSC_ST_ITEM_CUSTOMERS_N2_'||v_instance_code);
1250:
1251: EXCEPTION
1252: WHEN OTHERS THEN
1253: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_WARNING,'Error creating Index MSC_ST_ITEM_CUSTOMERS_N2_'||v_instance_code||'. Error:'||substr(SQLERRM,1,240));

Line 1253: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_WARNING,'Error creating Index MSC_ST_ITEM_CUSTOMERS_N2_'||v_instance_code||'. Error:'||substr(SQLERRM,1,240));

1249: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,'Created Index MSC_ST_ITEM_CUSTOMERS_N2_'||v_instance_code);
1250:
1251: EXCEPTION
1252: WHEN OTHERS THEN
1253: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_WARNING,'Error creating Index MSC_ST_ITEM_CUSTOMERS_N2_'||v_instance_code||'. Error:'||substr(SQLERRM,1,240));
1254: END;
1255:
1256: msc_analyse_tables_pk.analyse_table( 'MSC_ST_ITEM_CUSTOMERS', v_instance_id, -1);
1257:

Line 1256: msc_analyse_tables_pk.analyse_table( 'MSC_ST_ITEM_CUSTOMERS', v_instance_id, -1);

1252: WHEN OTHERS THEN
1253: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_WARNING,'Error creating Index MSC_ST_ITEM_CUSTOMERS_N2_'||v_instance_code||'. Error:'||substr(SQLERRM,1,240));
1254: END;
1255:
1256: msc_analyse_tables_pk.analyse_table( 'MSC_ST_ITEM_CUSTOMERS', v_instance_id, -1);
1257:
1258: END IF;
1259:
1260: IF v_ship_mthd_enabled = SYS_YES THEN

Line 2410: -- For bug fix 2379391, dropping the indexes for MSC_ST_ITEM_CUSTOMERS

2406:
2407:
2408: END IF;
2409:
2410: -- For bug fix 2379391, dropping the indexes for MSC_ST_ITEM_CUSTOMERS
2411: IF v_item_cst_enabled = SYS_YES THEN
2412:
2413: BEGIN
2414: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,

Line 2418: 'drop index MSC_ST_ITEM_CUSTOMERS_N1_'||v_instance_code,

2414: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,
2415: application_short_name => 'MSC',
2416: statement_type => AD_DDL.DROP_INDEX,
2417: statement =>
2418: 'drop index MSC_ST_ITEM_CUSTOMERS_N1_'||v_instance_code,
2419: object_name => 'MSC_ST_ITEM_CUSTOMERS_N1_'||v_instance_code);
2420:
2421: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,'Dropped Index MSC_ST_ITEM_CUSTOMERS_N1_'||v_instance_code);
2422:

Line 2419: object_name => 'MSC_ST_ITEM_CUSTOMERS_N1_'||v_instance_code);

2415: application_short_name => 'MSC',
2416: statement_type => AD_DDL.DROP_INDEX,
2417: statement =>
2418: 'drop index MSC_ST_ITEM_CUSTOMERS_N1_'||v_instance_code,
2419: object_name => 'MSC_ST_ITEM_CUSTOMERS_N1_'||v_instance_code);
2420:
2421: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,'Dropped Index MSC_ST_ITEM_CUSTOMERS_N1_'||v_instance_code);
2422:
2423: EXCEPTION

Line 2421: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,'Dropped Index MSC_ST_ITEM_CUSTOMERS_N1_'||v_instance_code);

2417: statement =>
2418: 'drop index MSC_ST_ITEM_CUSTOMERS_N1_'||v_instance_code,
2419: object_name => 'MSC_ST_ITEM_CUSTOMERS_N1_'||v_instance_code);
2420:
2421: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,'Dropped Index MSC_ST_ITEM_CUSTOMERS_N1_'||v_instance_code);
2422:
2423: EXCEPTION
2424: WHEN OTHERS THEN
2425: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_WARNING,'Error dropping Index MSC_ST_ITEM_CUSTOMERS_N1_'||v_instance_code||'. Error:'||substr(SQLERRM,1,240));

Line 2425: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_WARNING,'Error dropping Index MSC_ST_ITEM_CUSTOMERS_N1_'||v_instance_code||'. Error:'||substr(SQLERRM,1,240));

2421: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,'Dropped Index MSC_ST_ITEM_CUSTOMERS_N1_'||v_instance_code);
2422:
2423: EXCEPTION
2424: WHEN OTHERS THEN
2425: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_WARNING,'Error dropping Index MSC_ST_ITEM_CUSTOMERS_N1_'||v_instance_code||'. Error:'||substr(SQLERRM,1,240));
2426: END;
2427:
2428: BEGIN
2429: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,

Line 2433: 'drop index MSC_ST_ITEM_CUSTOMERS_N2_'||v_instance_code,

2429: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,
2430: application_short_name => 'MSC',
2431: statement_type => AD_DDL.DROP_INDEX,
2432: statement =>
2433: 'drop index MSC_ST_ITEM_CUSTOMERS_N2_'||v_instance_code,
2434: object_name => 'MSC_ST_ITEM_CUSTOMERS_N2_'||v_instance_code);
2435:
2436: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,'Dropped Index MSC_ST_ITEM_CUSTOMERS_N2_'||v_instance_code);
2437:

Line 2434: object_name => 'MSC_ST_ITEM_CUSTOMERS_N2_'||v_instance_code);

2430: application_short_name => 'MSC',
2431: statement_type => AD_DDL.DROP_INDEX,
2432: statement =>
2433: 'drop index MSC_ST_ITEM_CUSTOMERS_N2_'||v_instance_code,
2434: object_name => 'MSC_ST_ITEM_CUSTOMERS_N2_'||v_instance_code);
2435:
2436: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,'Dropped Index MSC_ST_ITEM_CUSTOMERS_N2_'||v_instance_code);
2437:
2438: EXCEPTION

Line 2436: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,'Dropped Index MSC_ST_ITEM_CUSTOMERS_N2_'||v_instance_code);

2432: statement =>
2433: 'drop index MSC_ST_ITEM_CUSTOMERS_N2_'||v_instance_code,
2434: object_name => 'MSC_ST_ITEM_CUSTOMERS_N2_'||v_instance_code);
2435:
2436: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,'Dropped Index MSC_ST_ITEM_CUSTOMERS_N2_'||v_instance_code);
2437:
2438: EXCEPTION
2439: WHEN OTHERS THEN
2440: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_WARNING,'Error dropping Index MSC_ST_ITEM_CUSTOMERS_N2_'||v_instance_code||'. Error:'||substr(SQLERRM,1,240));

Line 2440: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_WARNING,'Error dropping Index MSC_ST_ITEM_CUSTOMERS_N2_'||v_instance_code||'. Error:'||substr(SQLERRM,1,240));

2436: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,'Dropped Index MSC_ST_ITEM_CUSTOMERS_N2_'||v_instance_code);
2437:
2438: EXCEPTION
2439: WHEN OTHERS THEN
2440: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_WARNING,'Error dropping Index MSC_ST_ITEM_CUSTOMERS_N2_'||v_instance_code||'. Error:'||substr(SQLERRM,1,240));
2441: END;
2442:
2443: msc_analyse_tables_pk.analyse_table( 'MSC_ST_ITEM_CUSTOMERS', v_instance_id, -1);
2444:

Line 2443: msc_analyse_tables_pk.analyse_table( 'MSC_ST_ITEM_CUSTOMERS', v_instance_id, -1);

2439: WHEN OTHERS THEN
2440: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_WARNING,'Error dropping Index MSC_ST_ITEM_CUSTOMERS_N2_'||v_instance_code||'. Error:'||substr(SQLERRM,1,240));
2441: END;
2442:
2443: msc_analyse_tables_pk.analyse_table( 'MSC_ST_ITEM_CUSTOMERS', v_instance_id, -1);
2444:
2445: END IF;
2446:
2447: IF v_ship_mthd_enabled = SYS_YES THEN

Line 49977: FROM msc_st_item_customers

49973: PRAGMA EXCEPTION_INIT(busy, -54);
49974:
49975: CURSOR c1(p_batch_id NUMBER) IS
49976: SELECT rowid
49977: FROM msc_st_item_customers
49978: WHERE process_flag IN (G_IN_PROCESS,G_ERROR_FLG)
49979: AND sr_instance_code = v_instance_code
49980: AND batch_id = p_batch_id;
49981:

Line 49983: -- Validation of table msc_st_item_customers

49979: AND sr_instance_code = v_instance_code
49980: AND batch_id = p_batch_id;
49981:
49982: BEGIN
49983: -- Validation of table msc_st_item_customers
49984:
49985: lv_column_names :=
49986: 'ITEM_NAME ||''~''||'
49987: ||'CUSTOMER_ITEM_NAME ||''~''||'

Line 50016: 'UPDATE msc_st_item_customers mic1 '

50012: END IF;
50013:
50014: v_sql_stmt := 01;
50015: lv_sql_stmt :=
50016: 'UPDATE msc_st_item_customers mic1 '
50017: ||' SET process_flag = '||G_ERROR_FLG||','
50018: ||' error_text = '||''''||lv_message_text||''''
50019: ||' WHERE message_id < (SELECT MAX(message_id)'
50020: ||' FROM msc_st_item_customers mic2'

Line 50020: ||' FROM msc_st_item_customers mic2'

50016: 'UPDATE msc_st_item_customers mic1 '
50017: ||' SET process_flag = '||G_ERROR_FLG||','
50018: ||' error_text = '||''''||lv_message_text||''''
50019: ||' WHERE message_id < (SELECT MAX(message_id)'
50020: ||' FROM msc_st_item_customers mic2'
50021: ||' WHERE mic2.sr_instance_code = mic1.sr_instance_code'
50022: ||' AND NVL(mic2.company_name, '||''''||NULL_CHAR||''''||') = '
50023: ||' NVL(mic1.company_name, '||''''||NULL_CHAR||''''||')'
50024: ||' AND mic2.ITEM_NAME = mic1.ITEM_NAME'

Line 50046: 'UPDATE msc_st_item_customers mic1 '

50042: END IF;
50043:
50044: v_sql_stmt := 02;
50045: lv_sql_stmt :=
50046: 'UPDATE msc_st_item_customers mic1 '
50047: ||' SET process_flag = '||G_ERROR_FLG||','
50048: ||' error_text = '||''''||lv_message_text||''''
50049: ||' WHERE message_id < (SELECT MAX(message_id)'
50050: ||' FROM msc_st_item_customers mic2'

Line 50050: ||' FROM msc_st_item_customers mic2'

50046: 'UPDATE msc_st_item_customers mic1 '
50047: ||' SET process_flag = '||G_ERROR_FLG||','
50048: ||' error_text = '||''''||lv_message_text||''''
50049: ||' WHERE message_id < (SELECT MAX(message_id)'
50050: ||' FROM msc_st_item_customers mic2'
50051: ||' WHERE mic2.sr_instance_code = mic1.sr_instance_code'
50052: ||' AND NVL(mic2.company_name, '||''''||NULL_CHAR||''''||') = '
50053: ||' NVL(mic1.company_name, '||''''||NULL_CHAR||''''||')'
50054: ||' AND mic2.CUSTOMER_ITEM_NAME = mic1.CUSTOMER_ITEM_NAME'

Line 50091: 'UPDATE msc_st_item_customers mic1 '

50087: -- Error out records if same OEM item is mapped to multiple customer items. add index for this
50088:
50089: v_sql_stmt := 03;
50090: lv_sql_stmt :=
50091: 'UPDATE msc_st_item_customers mic1 '
50092: ||' SET process_flag = '||G_ERROR_FLG||','
50093: ||' error_text = '||''''||lv_message_text||''''
50094: ||' WHERE EXISTS( SELECT 1 '
50095: ||' FROM msc_st_item_customers mic2'

Line 50095: ||' FROM msc_st_item_customers mic2'

50091: 'UPDATE msc_st_item_customers mic1 '
50092: ||' SET process_flag = '||G_ERROR_FLG||','
50093: ||' error_text = '||''''||lv_message_text||''''
50094: ||' WHERE EXISTS( SELECT 1 '
50095: ||' FROM msc_st_item_customers mic2'
50096: ||' WHERE mic2.sr_instance_code = mic1.sr_instance_code'
50097: ||' AND NVL(mic2.company_name, '||''''||NULL_CHAR||''''||') = '
50098: ||' NVL(mic1.company_name, '||''''||NULL_CHAR||''''||')'
50099: ||' AND mic2.ITEM_NAME = mic1.ITEM_NAME'

Line 50118: 'UPDATE msc_st_item_customers mic1 '

50114: -- Error out records if multiple OEM items are mapped to same customer items. add index for this
50115:
50116: v_sql_stmt := 04;
50117: lv_sql_stmt :=
50118: 'UPDATE msc_st_item_customers mic1 '
50119: ||' SET process_flag = '||G_ERROR_FLG||','
50120: ||' error_text = '||''''||lv_message_text||''''
50121: ||' WHERE EXISTS( SELECT 1 '
50122: ||' FROM msc_st_item_customers mic2'

Line 50122: ||' FROM msc_st_item_customers mic2'

50118: 'UPDATE msc_st_item_customers mic1 '
50119: ||' SET process_flag = '||G_ERROR_FLG||','
50120: ||' error_text = '||''''||lv_message_text||''''
50121: ||' WHERE EXISTS( SELECT 1 '
50122: ||' FROM msc_st_item_customers mic2'
50123: ||' WHERE mic2.sr_instance_code = mic1.sr_instance_code'
50124: ||' AND NVL(mic2.company_name, '||''''||NULL_CHAR||''''||') = '
50125: ||' NVL(mic1.company_name, '||''''||NULL_CHAR||''''||')'
50126: ||' AND mic2.CUSTOMER_ITEM_NAME = mic1.CUSTOMER_ITEM_NAME'

Line 50153: 'UPDATE msc_st_item_customers '

50149: FROM dual;
50150:
50151: v_sql_stmt := 06;
50152: lv_sql_stmt :=
50153: 'UPDATE msc_st_item_customers '
50154: ||' SET batch_id = :lv_batch_id'
50155: ||' WHERE process_flag IN ('||G_IN_PROCESS||','||G_ERROR_FLG||')'
50156: ||' AND sr_instance_code = :v_instance_code'
50157: ||' AND NVL(batch_id,'||NULL_VALUE||') = '||NULL_VALUE

Line 50176: -- Sequence : MSC_ST_ITEM_CUSTOMERS_S.

50172:
50173:
50174: -- Generate the st_transaction_id and update all the records with this st_transaction_id.
50175: -- Set the who columns also (where PROCESS_FLAG = 2 and SR_INSTANCE_CODE = v_instance_code).
50176: -- Sequence : MSC_ST_ITEM_CUSTOMERS_S.
50177:
50178: v_sql_stmt := 07;
50179: FORALL j IN lb_rowid.FIRST..lb_rowid.LAST
50180: UPDATE msc_st_item_customers

Line 50180: UPDATE msc_st_item_customers

50176: -- Sequence : MSC_ST_ITEM_CUSTOMERS_S.
50177:
50178: v_sql_stmt := 07;
50179: FORALL j IN lb_rowid.FIRST..lb_rowid.LAST
50180: UPDATE msc_st_item_customers
50181: SET st_transaction_id = MSC_ST_ITEM_CUSTOMERS_S.NEXTVAL,
50182: refresh_id = v_refresh_id,
50183: last_update_date = v_current_date,
50184: last_updated_by = v_current_user,

Line 50181: SET st_transaction_id = MSC_ST_ITEM_CUSTOMERS_S.NEXTVAL,

50177:
50178: v_sql_stmt := 07;
50179: FORALL j IN lb_rowid.FIRST..lb_rowid.LAST
50180: UPDATE msc_st_item_customers
50181: SET st_transaction_id = MSC_ST_ITEM_CUSTOMERS_S.NEXTVAL,
50182: refresh_id = v_refresh_id,
50183: last_update_date = v_current_date,
50184: last_updated_by = v_current_user,
50185: creation_date = v_current_date,

Line 50200: p_token_value1 => 'MSC_ST_ITEM_CUSTOMERS');

50196: p_error_code => 'MSC_PP_NO_DELETION',
50197: p_message_text => lv_message_text,
50198: p_error_text => lv_error_text,
50199: p_token1 => 'TABLE_NAME',
50200: p_token_value1 => 'MSC_ST_ITEM_CUSTOMERS');
50201:
50202: IF lv_return <> 0 THEN
50203: RAISE ex_logging_err;
50204: END IF;

Line 50210: 'UPDATE MSC_ST_ITEM_CUSTOMERS '

50206: -- Deletion is not allowed for this table
50207:
50208: v_sql_stmt := 08;
50209: lv_sql_stmt :=
50210: 'UPDATE MSC_ST_ITEM_CUSTOMERS '
50211: ||' SET process_flag = '||G_ERROR_FLG||','
50212: ||' error_text = '||''''||lv_message_text||''''
50213: ||' WHERE deleted_flag = '||SYS_YES
50214: ||' AND process_flag = '||G_IN_PROCESS

Line 50248: (p_table_name => 'MSC_ST_ITEM_CUSTOMERS',

50244: --Log a warning for those records where the deleted_flag has a value other
50245: --SYS_NO
50246:
50247: lv_return := MSC_ST_UTIL.LOG_ERROR
50248: (p_table_name => 'MSC_ST_ITEM_CUSTOMERS',
50249: p_instance_code => v_instance_code,
50250: p_row => lv_column_names,
50251: p_severity => G_SEV_WARNING,
50252: p_message_text => lv_message_text,

Line 50280: (p_table_name => 'MSC_ST_ITEM_CUSTOMERS',

50276: RAISE ex_logging_err;
50277: END IF;
50278:
50279: lv_return := MSC_ST_UTIL.DERIVE_COMPANY_ID
50280: (p_table_name => 'MSC_ST_ITEM_CUSTOMERS',
50281: p_company_name => 'COMPANY_NAME',
50282: p_company_id => 'COMPANY_ID',
50283: p_instance_code => v_instance_code,
50284: p_error_text => lv_error_text,

Line 50298: ' UPDATE MSC_ST_ITEM_CUSTOMERS mic '

50294:
50295:
50296: /* Calling derive_company_id
50297: lv_sql_stmt :=
50298: ' UPDATE MSC_ST_ITEM_CUSTOMERS mic '
50299: ||' SET company_id = '
50300: ||' (select company_id from msc_companies mc'
50301: ||' where mic.company_name = mc.company_name) '
50302: ||' WHERE NVL(COMPANY_NAME,''-1'') <> ''-1'''

Line 50315: ' UPDATE MSC_ST_ITEM_CUSTOMERS '

50311: USING lv_batch_id,
50312: v_instance_code;
50313:
50314: lv_sql_stmt :=
50315: ' UPDATE MSC_ST_ITEM_CUSTOMERS '
50316: ||' SET process_flag = '||G_ERROR_FLG||','
50317: ||' error_text = '||''''||lv_message_text||''''
50318: ||' WHERE NVL(COMPANY_NAME,''-1'') <> ''-1'''
50319: ||' AND COMPANY_ID IS NULL '

Line 50352: ' UPDATE MSC_ST_ITEM_CUSTOMERS '

50348: RAISE ex_logging_err;
50349: END IF;
50350:
50351: lv_sql_stmt :=
50352: ' UPDATE MSC_ST_ITEM_CUSTOMERS '
50353: ||' SET process_flag = '||G_ERROR_FLG||','
50354: ||' error_text = '||''''||lv_message_text||''''
50355: ||' WHERE NVL(customer_item_name,'||''''||NULL_CHAR||''''||')'
50356: ||' = '||''''||NULL_CHAR||''''

Line 50384: p_token_value3 => 'MSC_ST_ITEM_CUSTOMERS');

50380: p_token_value1 => 'SR_INSTANCE_CODE ,UOM_CODE',
50381: p_token2 => 'MASTER_TABLE',
50382: p_token_value2 => 'MSC_ST_UNITS_OF_MEASURE',
50383: p_token3 => 'CHILD_TABLE',
50384: p_token_value3 => 'MSC_ST_ITEM_CUSTOMERS');
50385: IF lv_return <> 0 THEN
50386: RAISE ex_logging_err;
50387: END IF;
50388:

Line 50391: ' UPDATE MSC_ST_ITEM_CUSTOMERS mic'

50387: END IF;
50388:
50389:
50390: lv_sql_stmt :=
50391: ' UPDATE MSC_ST_ITEM_CUSTOMERS mic'
50392: ||' SET process_flag = '||G_ERROR_FLG||','
50393: ||' error_text = '||''''||lv_message_text||''''
50394: ||' WHERE NOT EXISTS (SELECT 1 '
50395: ||' FROM msc_units_of_measure muom'

Line 50430: (p_table_name => 'MSC_ST_ITEM_CUSTOMERS',

50426:
50427: --Derive Inventory_item_id
50428:
50429: lv_return := MSC_ST_UTIL.DERIVE_ITEM_ID
50430: (p_table_name => 'MSC_ST_ITEM_CUSTOMERS',
50431: p_item_col_name => 'ITEM_NAME',
50432: p_item_col_id => 'INVENTORY_ITEM_ID',
50433: p_instance_id => v_instance_id,
50434: p_instance_code => v_instance_code,

Line 50467: (p_table_name => 'MSC_ST_ITEM_CUSTOMERS',

50463:
50464: -- Derive customer_id and error out records if customer is not valid
50465:
50466: lv_return := MSC_ST_UTIL.DERIVE_PARTNER_ORG_ID
50467: (p_table_name => 'MSC_ST_ITEM_CUSTOMERS',
50468: p_org_partner_name => 'CUSTOMER_NAME',
50469: p_org_partner_id => 'CUSTOMER_ID',
50470: p_instance_code => v_instance_code,
50471: p_partner_type => G_CUSTOMER,

Line 50505: (p_table_name => 'MSC_ST_ITEM_CUSTOMERS',

50501: RAISE ex_logging_err;
50502: END IF;
50503:
50504: lv_return := MSC_ST_UTIL.DERIVE_PARTNER_SITE_ID
50505: (p_table_name => 'MSC_ST_ITEM_CUSTOMERS',
50506: p_partner_name => 'CUSTOMER_NAME',
50507: p_partner_site_code => 'CUSTOMER_SITE_NAME',
50508: p_partner_site_id => 'CUSTOMER_SITE_ID',
50509: p_instance_code => v_instance_code,

Line 50531: pEntityName => 'MSC_ST_ITEM_CUSTOMERS',

50527: (ERRBUF => lv_error_text,
50528: RETCODE => lv_return,
50529: pBatchID => lv_batch_id,
50530: pInstanceCode => v_instance_code,
50531: pEntityName => 'MSC_ST_ITEM_CUSTOMERS',
50532: pInstanceID => v_instance_id);
50533:
50534: IF NVL(lv_return,0) <> 0 THEN
50535: RAISE ex_logging_err;

Line 50541: (p_table_name => 'MSC_ST_ITEM_CUSTOMERS',

50537:
50538:
50539: -- Update the process_flag to 5(valid) and sr_instance_id to v_instance_id.
50540: lv_return := MSC_ST_UTIL.SET_PROCESS_FLAG
50541: (p_table_name => 'MSC_ST_ITEM_CUSTOMERS',
50542: p_instance_id => v_instance_id,
50543: p_instance_code => v_instance_code,
50544: p_process_flag => G_VALID,
50545: p_error_text => lv_error_text,

Line 50555: (p_table_name => 'MSC_ST_ITEM_CUSTOMERS',

50551: END IF;
50552:
50553: -- Insert all the errored out records into the error table.
50554: lv_return := MSC_ST_UTIL.LOG_ERROR
50555: (p_table_name => 'MSC_ST_ITEM_CUSTOMERS',
50556: p_instance_code => v_instance_code,
50557: p_row => lv_column_names,
50558: p_severity => G_SEV_ERROR,
50559: p_message_text => NULL,

Line 51045: lv_count:= SET_IN_PROCESS (p_table_name => 'MSC_ST_ITEM_CUSTOMERS');

51041: End IF;
51042: END IF;
51043:
51044: IF v_item_cst_enabled = SYS_YES THEN
51045: lv_count:= SET_IN_PROCESS (p_table_name => 'MSC_ST_ITEM_CUSTOMERS');
51046: END IF;
51047:
51048: IF v_safety_stk_enabled = SYS_YES THEN
51049: lv_count:= SET_IN_PROCESS (p_table_name => 'MSC_ST_SAFETY_STOCKS');