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 1232: 'create index MSC_ST_ITEM_CUSTOMERS_N1_'||v_instance_code

1228: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,
1229: application_short_name => 'MSC',
1230: statement_type => AD_DDL.CREATE_INDEX,
1231: statement =>
1232: 'create index MSC_ST_ITEM_CUSTOMERS_N1_'||v_instance_code
1233: ||' on MSC_ST_ITEM_CUSTOMERS '
1234: ||'(ITEM_NAME, CUSTOMER_NAME, SR_INSTANCE_CODE, COMPANY_NAME, CUSTOMER_SITE_NAME) '
1235: ||' STORAGE (INITIAL 100K NEXT 1M PCTINCREASE 0) ',
1236: object_name =>'MSC_ST_ITEM_CUSTOMERS_N1_'||v_instance_code);

Line 1233: ||' on MSC_ST_ITEM_CUSTOMERS '

1229: application_short_name => 'MSC',
1230: statement_type => AD_DDL.CREATE_INDEX,
1231: statement =>
1232: 'create index MSC_ST_ITEM_CUSTOMERS_N1_'||v_instance_code
1233: ||' on MSC_ST_ITEM_CUSTOMERS '
1234: ||'(ITEM_NAME, CUSTOMER_NAME, SR_INSTANCE_CODE, COMPANY_NAME, CUSTOMER_SITE_NAME) '
1235: ||' STORAGE (INITIAL 100K NEXT 1M PCTINCREASE 0) ',
1236: object_name =>'MSC_ST_ITEM_CUSTOMERS_N1_'||v_instance_code);
1237:

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

1232: 'create index MSC_ST_ITEM_CUSTOMERS_N1_'||v_instance_code
1233: ||' on MSC_ST_ITEM_CUSTOMERS '
1234: ||'(ITEM_NAME, CUSTOMER_NAME, SR_INSTANCE_CODE, COMPANY_NAME, CUSTOMER_SITE_NAME) '
1235: ||' STORAGE (INITIAL 100K NEXT 1M PCTINCREASE 0) ',
1236: object_name =>'MSC_ST_ITEM_CUSTOMERS_N1_'||v_instance_code);
1237:
1238: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,'Created Index MSC_ST_ITEM_CUSTOMERS_N1_'||v_instance_code);
1239:
1240: EXCEPTION

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

1234: ||'(ITEM_NAME, CUSTOMER_NAME, SR_INSTANCE_CODE, COMPANY_NAME, CUSTOMER_SITE_NAME) '
1235: ||' STORAGE (INITIAL 100K NEXT 1M PCTINCREASE 0) ',
1236: object_name =>'MSC_ST_ITEM_CUSTOMERS_N1_'||v_instance_code);
1237:
1238: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,'Created Index MSC_ST_ITEM_CUSTOMERS_N1_'||v_instance_code);
1239:
1240: EXCEPTION
1241: WHEN OTHERS THEN
1242: 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 1242: 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));

1238: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,'Created Index MSC_ST_ITEM_CUSTOMERS_N1_'||v_instance_code);
1239:
1240: EXCEPTION
1241: WHEN OTHERS THEN
1242: 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));
1243: END;
1244:
1245: BEGIN
1246:

Line 1251: 'create index MSC_ST_ITEM_CUSTOMERS_N2_'||v_instance_code

1247: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,
1248: application_short_name => 'MSC',
1249: statement_type => AD_DDL.CREATE_INDEX,
1250: statement =>
1251: 'create index MSC_ST_ITEM_CUSTOMERS_N2_'||v_instance_code
1252: ||' on MSC_ST_ITEM_CUSTOMERS '
1253: ||'(CUSTOMER_ITEM_NAME, CUSTOMER_NAME, SR_INSTANCE_CODE, COMPANY_NAME, CUSTOMER_SITE_NAME) '
1254: ||' STORAGE (INITIAL 100K NEXT 1M PCTINCREASE 0) ',
1255: object_name =>'MSC_ST_ITEM_CUSTOMERS_N2_'||v_instance_code);

Line 1252: ||' on MSC_ST_ITEM_CUSTOMERS '

1248: application_short_name => 'MSC',
1249: statement_type => AD_DDL.CREATE_INDEX,
1250: statement =>
1251: 'create index MSC_ST_ITEM_CUSTOMERS_N2_'||v_instance_code
1252: ||' on MSC_ST_ITEM_CUSTOMERS '
1253: ||'(CUSTOMER_ITEM_NAME, CUSTOMER_NAME, SR_INSTANCE_CODE, COMPANY_NAME, CUSTOMER_SITE_NAME) '
1254: ||' STORAGE (INITIAL 100K NEXT 1M PCTINCREASE 0) ',
1255: object_name =>'MSC_ST_ITEM_CUSTOMERS_N2_'||v_instance_code);
1256:

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

1251: 'create index MSC_ST_ITEM_CUSTOMERS_N2_'||v_instance_code
1252: ||' on MSC_ST_ITEM_CUSTOMERS '
1253: ||'(CUSTOMER_ITEM_NAME, CUSTOMER_NAME, SR_INSTANCE_CODE, COMPANY_NAME, CUSTOMER_SITE_NAME) '
1254: ||' STORAGE (INITIAL 100K NEXT 1M PCTINCREASE 0) ',
1255: object_name =>'MSC_ST_ITEM_CUSTOMERS_N2_'||v_instance_code);
1256:
1257: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,'Created Index MSC_ST_ITEM_CUSTOMERS_N2_'||v_instance_code);
1258:
1259: EXCEPTION

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

1253: ||'(CUSTOMER_ITEM_NAME, CUSTOMER_NAME, SR_INSTANCE_CODE, COMPANY_NAME, CUSTOMER_SITE_NAME) '
1254: ||' STORAGE (INITIAL 100K NEXT 1M PCTINCREASE 0) ',
1255: object_name =>'MSC_ST_ITEM_CUSTOMERS_N2_'||v_instance_code);
1256:
1257: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,'Created Index MSC_ST_ITEM_CUSTOMERS_N2_'||v_instance_code);
1258:
1259: EXCEPTION
1260: WHEN OTHERS THEN
1261: 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 1261: 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));

1257: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,'Created Index MSC_ST_ITEM_CUSTOMERS_N2_'||v_instance_code);
1258:
1259: EXCEPTION
1260: WHEN OTHERS THEN
1261: 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));
1262: END;
1263:
1264: msc_analyse_tables_pk.analyse_table( 'MSC_ST_ITEM_CUSTOMERS', v_instance_id, -1);
1265:

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

1260: WHEN OTHERS THEN
1261: 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));
1262: END;
1263:
1264: msc_analyse_tables_pk.analyse_table( 'MSC_ST_ITEM_CUSTOMERS', v_instance_id, -1);
1265:
1266: END IF;
1267:
1268: IF v_ship_mthd_enabled = SYS_YES THEN

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

2414:
2415:
2416: END IF;
2417:
2418: -- For bug fix 2379391, dropping the indexes for MSC_ST_ITEM_CUSTOMERS
2419: IF v_item_cst_enabled = SYS_YES THEN
2420:
2421: BEGIN
2422: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,

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

2422: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,
2423: application_short_name => 'MSC',
2424: statement_type => AD_DDL.DROP_INDEX,
2425: statement =>
2426: 'drop index MSC_ST_ITEM_CUSTOMERS_N1_'||v_instance_code,
2427: object_name => 'MSC_ST_ITEM_CUSTOMERS_N1_'||v_instance_code);
2428:
2429: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,'Dropped Index MSC_ST_ITEM_CUSTOMERS_N1_'||v_instance_code);
2430:

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

2423: application_short_name => 'MSC',
2424: statement_type => AD_DDL.DROP_INDEX,
2425: statement =>
2426: 'drop index MSC_ST_ITEM_CUSTOMERS_N1_'||v_instance_code,
2427: object_name => 'MSC_ST_ITEM_CUSTOMERS_N1_'||v_instance_code);
2428:
2429: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,'Dropped Index MSC_ST_ITEM_CUSTOMERS_N1_'||v_instance_code);
2430:
2431: EXCEPTION

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

2425: statement =>
2426: 'drop index MSC_ST_ITEM_CUSTOMERS_N1_'||v_instance_code,
2427: object_name => 'MSC_ST_ITEM_CUSTOMERS_N1_'||v_instance_code);
2428:
2429: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,'Dropped Index MSC_ST_ITEM_CUSTOMERS_N1_'||v_instance_code);
2430:
2431: EXCEPTION
2432: WHEN OTHERS THEN
2433: 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 2433: 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));

2429: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,'Dropped Index MSC_ST_ITEM_CUSTOMERS_N1_'||v_instance_code);
2430:
2431: EXCEPTION
2432: WHEN OTHERS THEN
2433: 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));
2434: END;
2435:
2436: BEGIN
2437: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,

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

2437: ad_ddl.do_ddl( applsys_schema => v_applsys_schema,
2438: application_short_name => 'MSC',
2439: statement_type => AD_DDL.DROP_INDEX,
2440: statement =>
2441: 'drop index MSC_ST_ITEM_CUSTOMERS_N2_'||v_instance_code,
2442: object_name => 'MSC_ST_ITEM_CUSTOMERS_N2_'||v_instance_code);
2443:
2444: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,'Dropped Index MSC_ST_ITEM_CUSTOMERS_N2_'||v_instance_code);
2445:

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

2438: application_short_name => 'MSC',
2439: statement_type => AD_DDL.DROP_INDEX,
2440: statement =>
2441: 'drop index MSC_ST_ITEM_CUSTOMERS_N2_'||v_instance_code,
2442: object_name => 'MSC_ST_ITEM_CUSTOMERS_N2_'||v_instance_code);
2443:
2444: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,'Dropped Index MSC_ST_ITEM_CUSTOMERS_N2_'||v_instance_code);
2445:
2446: EXCEPTION

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

2440: statement =>
2441: 'drop index MSC_ST_ITEM_CUSTOMERS_N2_'||v_instance_code,
2442: object_name => 'MSC_ST_ITEM_CUSTOMERS_N2_'||v_instance_code);
2443:
2444: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,'Dropped Index MSC_ST_ITEM_CUSTOMERS_N2_'||v_instance_code);
2445:
2446: EXCEPTION
2447: WHEN OTHERS THEN
2448: 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 2448: 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));

2444: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,'Dropped Index MSC_ST_ITEM_CUSTOMERS_N2_'||v_instance_code);
2445:
2446: EXCEPTION
2447: WHEN OTHERS THEN
2448: 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));
2449: END;
2450:
2451: msc_analyse_tables_pk.analyse_table( 'MSC_ST_ITEM_CUSTOMERS', v_instance_id, -1);
2452:

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

2447: WHEN OTHERS THEN
2448: 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));
2449: END;
2450:
2451: msc_analyse_tables_pk.analyse_table( 'MSC_ST_ITEM_CUSTOMERS', v_instance_id, -1);
2452:
2453: END IF;
2454:
2455: IF v_ship_mthd_enabled = SYS_YES THEN

Line 54891: FROM msc_st_item_customers

54887: PRAGMA EXCEPTION_INIT(busy, -54);
54888:
54889: CURSOR c1(p_batch_id NUMBER) IS
54890: SELECT rowid
54891: FROM msc_st_item_customers
54892: WHERE process_flag IN (G_IN_PROCESS,G_ERROR_FLG)
54893: AND sr_instance_code = v_instance_code
54894: AND batch_id = p_batch_id;
54895:

Line 54897: -- Validation of table msc_st_item_customers

54893: AND sr_instance_code = v_instance_code
54894: AND batch_id = p_batch_id;
54895:
54896: BEGIN
54897: -- Validation of table msc_st_item_customers
54898:
54899: lv_column_names :=
54900: 'ITEM_NAME ||''~''||'
54901: ||'CUSTOMER_ITEM_NAME ||''~''||'

Line 54930: 'UPDATE msc_st_item_customers mic1 '

54926: END IF;
54927:
54928: v_sql_stmt := 01;
54929: lv_sql_stmt :=
54930: 'UPDATE msc_st_item_customers mic1 '
54931: ||' SET process_flag = '||G_ERROR_FLG||','
54932: ||' error_text = '||''''||lv_message_text||''''
54933: ||' WHERE message_id < (SELECT MAX(message_id)'
54934: ||' FROM msc_st_item_customers mic2'

Line 54934: ||' FROM msc_st_item_customers mic2'

54930: 'UPDATE msc_st_item_customers mic1 '
54931: ||' SET process_flag = '||G_ERROR_FLG||','
54932: ||' error_text = '||''''||lv_message_text||''''
54933: ||' WHERE message_id < (SELECT MAX(message_id)'
54934: ||' FROM msc_st_item_customers mic2'
54935: ||' WHERE mic2.sr_instance_code = mic1.sr_instance_code'
54936: ||' AND NVL(mic2.company_name, '||''''||NULL_CHAR||''''||') = '
54937: ||' NVL(mic1.company_name, '||''''||NULL_CHAR||''''||')'
54938: ||' AND mic2.ITEM_NAME = mic1.ITEM_NAME'

Line 54960: 'UPDATE msc_st_item_customers mic1 '

54956: END IF;
54957:
54958: v_sql_stmt := 02;
54959: lv_sql_stmt :=
54960: 'UPDATE msc_st_item_customers mic1 '
54961: ||' SET process_flag = '||G_ERROR_FLG||','
54962: ||' error_text = '||''''||lv_message_text||''''
54963: ||' WHERE message_id < (SELECT MAX(message_id)'
54964: ||' FROM msc_st_item_customers mic2'

Line 54964: ||' FROM msc_st_item_customers mic2'

54960: 'UPDATE msc_st_item_customers mic1 '
54961: ||' SET process_flag = '||G_ERROR_FLG||','
54962: ||' error_text = '||''''||lv_message_text||''''
54963: ||' WHERE message_id < (SELECT MAX(message_id)'
54964: ||' FROM msc_st_item_customers mic2'
54965: ||' WHERE mic2.sr_instance_code = mic1.sr_instance_code'
54966: ||' AND NVL(mic2.company_name, '||''''||NULL_CHAR||''''||') = '
54967: ||' NVL(mic1.company_name, '||''''||NULL_CHAR||''''||')'
54968: ||' AND mic2.CUSTOMER_ITEM_NAME = mic1.CUSTOMER_ITEM_NAME'

Line 55005: 'UPDATE msc_st_item_customers mic1 '

55001: -- Error out records if same OEM item is mapped to multiple customer items. add index for this
55002:
55003: v_sql_stmt := 03;
55004: lv_sql_stmt :=
55005: 'UPDATE msc_st_item_customers mic1 '
55006: ||' SET process_flag = '||G_ERROR_FLG||','
55007: ||' error_text = '||''''||lv_message_text||''''
55008: ||' WHERE EXISTS( SELECT 1 '
55009: ||' FROM msc_st_item_customers mic2'

Line 55009: ||' FROM msc_st_item_customers mic2'

55005: 'UPDATE msc_st_item_customers mic1 '
55006: ||' SET process_flag = '||G_ERROR_FLG||','
55007: ||' error_text = '||''''||lv_message_text||''''
55008: ||' WHERE EXISTS( SELECT 1 '
55009: ||' FROM msc_st_item_customers mic2'
55010: ||' WHERE mic2.sr_instance_code = mic1.sr_instance_code'
55011: ||' AND NVL(mic2.company_name, '||''''||NULL_CHAR||''''||') = '
55012: ||' NVL(mic1.company_name, '||''''||NULL_CHAR||''''||')'
55013: ||' AND mic2.ITEM_NAME = mic1.ITEM_NAME'

Line 55032: 'UPDATE msc_st_item_customers mic1 '

55028: -- Error out records if multiple OEM items are mapped to same customer items. add index for this
55029:
55030: v_sql_stmt := 04;
55031: lv_sql_stmt :=
55032: 'UPDATE msc_st_item_customers mic1 '
55033: ||' SET process_flag = '||G_ERROR_FLG||','
55034: ||' error_text = '||''''||lv_message_text||''''
55035: ||' WHERE EXISTS( SELECT 1 '
55036: ||' FROM msc_st_item_customers mic2'

Line 55036: ||' FROM msc_st_item_customers mic2'

55032: 'UPDATE msc_st_item_customers mic1 '
55033: ||' SET process_flag = '||G_ERROR_FLG||','
55034: ||' error_text = '||''''||lv_message_text||''''
55035: ||' WHERE EXISTS( SELECT 1 '
55036: ||' FROM msc_st_item_customers mic2'
55037: ||' WHERE mic2.sr_instance_code = mic1.sr_instance_code'
55038: ||' AND NVL(mic2.company_name, '||''''||NULL_CHAR||''''||') = '
55039: ||' NVL(mic1.company_name, '||''''||NULL_CHAR||''''||')'
55040: ||' AND mic2.CUSTOMER_ITEM_NAME = mic1.CUSTOMER_ITEM_NAME'

Line 55067: 'UPDATE msc_st_item_customers '

55063: FROM dual;
55064:
55065: v_sql_stmt := 06;
55066: lv_sql_stmt :=
55067: 'UPDATE msc_st_item_customers '
55068: ||' SET batch_id = :lv_batch_id'
55069: ||' WHERE process_flag IN ('||G_IN_PROCESS||','||G_ERROR_FLG||')'
55070: ||' AND sr_instance_code = :v_instance_code'
55071: ||' AND NVL(batch_id,'||NULL_VALUE||') = '||NULL_VALUE

Line 55090: -- Sequence : MSC_ST_ITEM_CUSTOMERS_S.

55086:
55087:
55088: -- Generate the st_transaction_id and update all the records with this st_transaction_id.
55089: -- Set the who columns also (where PROCESS_FLAG = 2 and SR_INSTANCE_CODE = v_instance_code).
55090: -- Sequence : MSC_ST_ITEM_CUSTOMERS_S.
55091:
55092: v_sql_stmt := 07;
55093: FORALL j IN lb_rowid.FIRST..lb_rowid.LAST
55094: UPDATE msc_st_item_customers

Line 55094: UPDATE msc_st_item_customers

55090: -- Sequence : MSC_ST_ITEM_CUSTOMERS_S.
55091:
55092: v_sql_stmt := 07;
55093: FORALL j IN lb_rowid.FIRST..lb_rowid.LAST
55094: UPDATE msc_st_item_customers
55095: SET st_transaction_id = MSC_ST_ITEM_CUSTOMERS_S.NEXTVAL,
55096: refresh_id = v_refresh_id,
55097: last_update_date = v_current_date,
55098: last_updated_by = v_current_user,

Line 55095: SET st_transaction_id = MSC_ST_ITEM_CUSTOMERS_S.NEXTVAL,

55091:
55092: v_sql_stmt := 07;
55093: FORALL j IN lb_rowid.FIRST..lb_rowid.LAST
55094: UPDATE msc_st_item_customers
55095: SET st_transaction_id = MSC_ST_ITEM_CUSTOMERS_S.NEXTVAL,
55096: refresh_id = v_refresh_id,
55097: last_update_date = v_current_date,
55098: last_updated_by = v_current_user,
55099: creation_date = v_current_date,

Line 55114: p_token_value1 => 'MSC_ST_ITEM_CUSTOMERS');

55110: p_error_code => 'MSC_PP_NO_DELETION',
55111: p_message_text => lv_message_text,
55112: p_error_text => lv_error_text,
55113: p_token1 => 'TABLE_NAME',
55114: p_token_value1 => 'MSC_ST_ITEM_CUSTOMERS');
55115:
55116: IF lv_return <> 0 THEN
55117: RAISE ex_logging_err;
55118: END IF;

Line 55124: 'UPDATE MSC_ST_ITEM_CUSTOMERS '

55120: -- Deletion is not allowed for this table
55121:
55122: v_sql_stmt := 08;
55123: lv_sql_stmt :=
55124: 'UPDATE MSC_ST_ITEM_CUSTOMERS '
55125: ||' SET process_flag = '||G_ERROR_FLG||','
55126: ||' error_text = '||''''||lv_message_text||''''
55127: ||' WHERE deleted_flag = '||SYS_YES
55128: ||' AND process_flag = '||G_IN_PROCESS

Line 55162: (p_table_name => 'MSC_ST_ITEM_CUSTOMERS',

55158: --Log a warning for those records where the deleted_flag has a value other
55159: --SYS_NO
55160:
55161: lv_return := MSC_ST_UTIL.LOG_ERROR
55162: (p_table_name => 'MSC_ST_ITEM_CUSTOMERS',
55163: p_instance_code => v_instance_code,
55164: p_row => lv_column_names,
55165: p_severity => G_SEV_WARNING,
55166: p_message_text => lv_message_text,

Line 55194: (p_table_name => 'MSC_ST_ITEM_CUSTOMERS',

55190: RAISE ex_logging_err;
55191: END IF;
55192:
55193: lv_return := MSC_ST_UTIL.DERIVE_COMPANY_ID
55194: (p_table_name => 'MSC_ST_ITEM_CUSTOMERS',
55195: p_company_name => 'COMPANY_NAME',
55196: p_company_id => 'COMPANY_ID',
55197: p_instance_code => v_instance_code,
55198: p_error_text => lv_error_text,

Line 55212: ' UPDATE MSC_ST_ITEM_CUSTOMERS mic '

55208:
55209:
55210: /* Calling derive_company_id
55211: lv_sql_stmt :=
55212: ' UPDATE MSC_ST_ITEM_CUSTOMERS mic '
55213: ||' SET company_id = '
55214: ||' (select company_id from msc_companies mc'
55215: ||' where mic.company_name = mc.company_name) '
55216: ||' WHERE NVL(COMPANY_NAME,''-1'') <> ''-1'''

Line 55229: ' UPDATE MSC_ST_ITEM_CUSTOMERS '

55225: USING lv_batch_id,
55226: v_instance_code;
55227:
55228: lv_sql_stmt :=
55229: ' UPDATE MSC_ST_ITEM_CUSTOMERS '
55230: ||' SET process_flag = '||G_ERROR_FLG||','
55231: ||' error_text = '||''''||lv_message_text||''''
55232: ||' WHERE NVL(COMPANY_NAME,''-1'') <> ''-1'''
55233: ||' AND COMPANY_ID IS NULL '

Line 55266: ' UPDATE MSC_ST_ITEM_CUSTOMERS '

55262: RAISE ex_logging_err;
55263: END IF;
55264:
55265: lv_sql_stmt :=
55266: ' UPDATE MSC_ST_ITEM_CUSTOMERS '
55267: ||' SET process_flag = '||G_ERROR_FLG||','
55268: ||' error_text = '||''''||lv_message_text||''''
55269: ||' WHERE NVL(customer_item_name,'||''''||NULL_CHAR||''''||')'
55270: ||' = '||''''||NULL_CHAR||''''

Line 55298: p_token_value3 => 'MSC_ST_ITEM_CUSTOMERS');

55294: p_token_value1 => 'SR_INSTANCE_CODE ,UOM_CODE',
55295: p_token2 => 'MASTER_TABLE',
55296: p_token_value2 => 'MSC_ST_UNITS_OF_MEASURE',
55297: p_token3 => 'CHILD_TABLE',
55298: p_token_value3 => 'MSC_ST_ITEM_CUSTOMERS');
55299: IF lv_return <> 0 THEN
55300: RAISE ex_logging_err;
55301: END IF;
55302:

Line 55305: ' UPDATE MSC_ST_ITEM_CUSTOMERS mic'

55301: END IF;
55302:
55303:
55304: lv_sql_stmt :=
55305: ' UPDATE MSC_ST_ITEM_CUSTOMERS mic'
55306: ||' SET process_flag = '||G_ERROR_FLG||','
55307: ||' error_text = '||''''||lv_message_text||''''
55308: ||' WHERE NOT EXISTS (SELECT 1 '
55309: ||' FROM msc_units_of_measure muom'

Line 55344: (p_table_name => 'MSC_ST_ITEM_CUSTOMERS',

55340:
55341: --Derive Inventory_item_id
55342:
55343: lv_return := MSC_ST_UTIL.DERIVE_ITEM_ID
55344: (p_table_name => 'MSC_ST_ITEM_CUSTOMERS',
55345: p_item_col_name => 'ITEM_NAME',
55346: p_item_col_id => 'INVENTORY_ITEM_ID',
55347: p_instance_id => v_instance_id,
55348: p_instance_code => v_instance_code,

Line 55381: (p_table_name => 'MSC_ST_ITEM_CUSTOMERS',

55377:
55378: -- Derive customer_id and error out records if customer is not valid
55379:
55380: lv_return := MSC_ST_UTIL.DERIVE_PARTNER_ORG_ID
55381: (p_table_name => 'MSC_ST_ITEM_CUSTOMERS',
55382: p_org_partner_name => 'CUSTOMER_NAME',
55383: p_org_partner_id => 'CUSTOMER_ID',
55384: p_instance_code => v_instance_code,
55385: p_partner_type => G_CUSTOMER,

Line 55419: (p_table_name => 'MSC_ST_ITEM_CUSTOMERS',

55415: RAISE ex_logging_err;
55416: END IF;
55417:
55418: lv_return := MSC_ST_UTIL.DERIVE_PARTNER_SITE_ID
55419: (p_table_name => 'MSC_ST_ITEM_CUSTOMERS',
55420: p_partner_name => 'CUSTOMER_NAME',
55421: p_partner_site_code => 'CUSTOMER_SITE_NAME',
55422: p_partner_site_id => 'CUSTOMER_SITE_ID',
55423: p_instance_code => v_instance_code,

Line 55445: pEntityName => 'MSC_ST_ITEM_CUSTOMERS',

55441: (ERRBUF => lv_error_text,
55442: RETCODE => lv_return,
55443: pBatchID => lv_batch_id,
55444: pInstanceCode => v_instance_code,
55445: pEntityName => 'MSC_ST_ITEM_CUSTOMERS',
55446: pInstanceID => v_instance_id);
55447:
55448: IF NVL(lv_return,0) <> 0 THEN
55449: RAISE ex_logging_err;

Line 55455: (p_table_name => 'MSC_ST_ITEM_CUSTOMERS',

55451:
55452:
55453: -- Update the process_flag to 5(valid) and sr_instance_id to v_instance_id.
55454: lv_return := MSC_ST_UTIL.SET_PROCESS_FLAG
55455: (p_table_name => 'MSC_ST_ITEM_CUSTOMERS',
55456: p_instance_id => v_instance_id,
55457: p_instance_code => v_instance_code,
55458: p_process_flag => G_VALID,
55459: p_error_text => lv_error_text,

Line 55469: (p_table_name => 'MSC_ST_ITEM_CUSTOMERS',

55465: END IF;
55466:
55467: -- Insert all the errored out records into the error table.
55468: lv_return := MSC_ST_UTIL.LOG_ERROR
55469: (p_table_name => 'MSC_ST_ITEM_CUSTOMERS',
55470: p_instance_code => v_instance_code,
55471: p_row => lv_column_names,
55472: p_severity => G_SEV_ERROR,
55473: p_message_text => NULL,

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

55963: End IF;
55964: END IF;
55965:
55966: IF v_item_cst_enabled = SYS_YES THEN
55967: lv_count:= SET_IN_PROCESS (p_table_name => 'MSC_ST_ITEM_CUSTOMERS');
55968: END IF;
55969:
55970: IF v_safety_stk_enabled = SYS_YES THEN
55971: lv_count:= SET_IN_PROCESS (p_table_name => 'MSC_ST_SAFETY_STOCKS');