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_SALES_ORDERS

Line 678: ||' on MSC_ST_SALES_ORDERS '

674: application_short_name => 'MSC',
675: statement_type => AD_DDL.CREATE_INDEX,
676: statement =>
677: 'create index MSC_ST_SO_N1_'||v_instance_code
678: ||' on MSC_ST_SALES_ORDERS '
679: ||'(sr_instance_code, sales_order_number, line_num, organization_code, company_name) '
680: ||' STORAGE (INITIAL 100K NEXT 1M PCTINCREASE 0) ',
681: object_name =>'MSC_ST_SO_N1_'||v_instance_code);
682:

Line 691: msc_analyse_tables_pk.analyse_table( 'MSC_ST_SALES_ORDERS', v_instance_id, -1);

687: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_WARNING,'Error creating Index MSC_ST_SO_N1_'||v_instance_code||'. Error:'||substr(SQLERRM,1,240));
688: END;
689:
690: msc_analyse_tables_pk.analyse_table( 'MSC_ST_DEMANDS', v_instance_id, -1);
691: msc_analyse_tables_pk.analyse_table( 'MSC_ST_SALES_ORDERS', v_instance_id, -1);
692:
693: END IF;
694:
695: IF v_reserve_enabled = SYS_YES THEN

Line 1750: ||' on MSC_ST_SALES_ORDERS '

1746: application_short_name => 'MSC',
1747: statement_type => AD_DDL.CREATE_INDEX,
1748: statement =>
1749: 'create index MSC_ST_SO_N2_'||v_instance_code
1750: ||' on MSC_ST_SALES_ORDERS '
1751: ||' (sales_order_number, batch_id ,sr_instance_code, deleted_flag) '
1752: ||' STORAGE (INITIAL 100K NEXT 1M PCTINCREASE 0) ',
1753: object_name => 'MSC_ST_SO_N2_'||v_instance_code);
1754:

Line 1768: ||' on MSC_ST_SALES_ORDERS '

1764: application_short_name => 'MSC',
1765: statement_type => AD_DDL.CREATE_INDEX,
1766: statement =>
1767: 'create index MSC_ST_SO_N3_'||v_instance_code
1768: ||' on MSC_ST_SALES_ORDERS '
1769: ||' (sr_instance_code, batch_id , deleted_flag) '
1770: ||' STORAGE (INITIAL 100K NEXT 1M PCTINCREASE 0) ',
1771: object_name => 'MSC_ST_SO_N3_'||v_instance_code);
1772:

Line 1780: msc_analyse_tables_pk.analyse_table( 'MSC_ST_SALES_ORDERS', v_instance_id, -1);

1776: WHEN OTHERS THEN
1777: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_WARNING,'Error creating Index MSC_ST_SO_N3_'||v_instance_code||'. Error:'||substr(SQLERRM,1,240));
1778: END;
1779:
1780: msc_analyse_tables_pk.analyse_table( 'MSC_ST_SALES_ORDERS', v_instance_id, -1);
1781:
1782: END IF;
1783:
1784: EXCEPTION

Line 31235: | records from the msc_st_sales_orders table. |

31231: END LOAD_SUPPLY;
31232:
31233: /*==========================================================================+
31234: | DESCRIPTION : This procedure is called for validating demand related |
31235: | records from the msc_st_sales_orders table. |
31236: +==========================================================================*/
31237: PROCEDURE LOAD_SALES_ORDER (p_batch_id IN NUMBER ) IS
31238: TYPE RowidTab IS TABLE OF ROWID INDEX BY BINARY_INTEGER;
31239:

Line 31257: FROM msc_st_sales_orders

31253: PRAGMA EXCEPTION_INIT(busy, -54);
31254:
31255: CURSOR c1(p_batch_id NUMBER) IS
31256: SELECT rowid
31257: FROM msc_st_sales_orders
31258: WHERE process_flag IN (G_IN_PROCESS,G_ERROR_FLG)
31259: AND batch_id = p_batch_id
31260: AND sr_instance_code = v_instance_code;
31261:

Line 31264: FROM msc_st_sales_orders

31260: AND sr_instance_code = v_instance_code;
31261:
31262: CURSOR c2(p_batch_id NUMBER) IS
31263: SELECT max(rowid)
31264: FROM msc_st_sales_orders
31265: WHERE process_flag = G_IN_PROCESS
31266: AND sr_instance_code = v_instance_code
31267: AND batch_id = p_batch_id
31268: AND NVL(demand_source_header_id,NULL_VALUE) = NULL_VALUE

Line 31275: FROM msc_st_sales_orders

31271: ORGANIZATION_CODE,SALES_ORDER_NUMBER;
31272:
31273: CURSOR c3(p_batch_id NUMBER) IS
31274: SELECT rowid
31275: FROM msc_st_sales_orders
31276: WHERE process_flag = G_IN_PROCESS
31277: AND sr_instance_code = v_instance_code
31278: AND batch_id = p_batch_id
31279: AND NVL(demand_id,NULL_VALUE) = NULL_VALUE

Line 31284: FROM msc_st_sales_orders

31280: AND deleted_flag = SYS_NO;
31281:
31282: CURSOR c4(p_batch_id NUMBER) IS
31283: SELECT max(rowid)
31284: FROM msc_st_sales_orders
31285: WHERE process_flag = G_IN_PROCESS
31286: AND sr_instance_code = v_instance_code
31287: AND batch_id = p_batch_id
31288: AND NVL(ship_set_id,NULL_VALUE) = NULL_VALUE

Line 31296: FROM msc_st_sales_orders

31292: ORGANIZATION_CODE,SALES_ORDER_NUMBER, SHIP_SET_NAME;
31293:
31294: CURSOR c5(p_batch_id NUMBER) IS
31295: SELECT max(rowid)
31296: FROM msc_st_sales_orders
31297: WHERE process_flag = G_IN_PROCESS
31298: AND sr_instance_code = v_instance_code
31299: AND batch_id = p_batch_id
31300: AND NVL(arrival_set_id,NULL_VALUE) = NULL_VALUE

Line 31308: FROM msc_st_sales_orders mso ,

31304: ORGANIZATION_CODE,SALES_ORDER_NUMBER, ARRIVAL_SET_NAME;
31305:
31306: CURSOR c_lock(p_batch_id NUMBER) IS
31307: SELECT 'X'
31308: FROM msc_st_sales_orders mso ,
31309: msc_st_sales_orders mcr
31310: WHERE mso.batch_id = p_batch_id
31311: AND mso.batch_id <> nvl(mcr.batch_id,NULL_VALUE)
31312: AND mso.demand_source_header_id IS NULL

Line 31309: msc_st_sales_orders mcr

31305:
31306: CURSOR c_lock(p_batch_id NUMBER) IS
31307: SELECT 'X'
31308: FROM msc_st_sales_orders mso ,
31309: msc_st_sales_orders mcr
31310: WHERE mso.batch_id = p_batch_id
31311: AND mso.batch_id <> nvl(mcr.batch_id,NULL_VALUE)
31312: AND mso.demand_source_header_id IS NULL
31313: AND mcr.demand_source_header_id IS NULL

Line 31380: 'UPDATE msc_st_sales_orders '

31376: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_WARNING,lv_error_text);
31377:
31378: v_sql_stmt := 1.1;
31379: lv_sql_stmt :=
31380: 'UPDATE msc_st_sales_orders '
31381: ||' SET process_flag = 1,'
31382: ||' batch_id = NULL'
31383: ||' WHERE batch_id = :p_batch_id'
31384: ||' AND process_flag = '||G_IN_PROCESS

Line 31402: 'UPDATE msc_st_sales_orders mso '

31398: -- Generate demand_source_header_id
31399:
31400: v_sql_stmt := 2.0;
31401: lv_sql_stmt :=
31402: 'UPDATE msc_st_sales_orders mso '
31403: ||' SET demand_source_header_id = (SELECT local_id'
31404: ||' FROM msc_local_id_demand mlid'
31405: ||' WHERE mlid.char1 = mso.sr_instance_code'
31406: ||' AND NVL(mlid.char2,'||''''||NULL_CHAR||''''||') '

Line 31427: UPDATE msc_st_sales_orders

31423:
31424: IF c2%ROWCOUNT > 0 THEN
31425: v_sql_stmt := 2.1;
31426: FORALL j IN lb_rowid.FIRST..lb_rowid.LAST
31427: UPDATE msc_st_sales_orders
31428: SET demand_source_header_id = msc_st_sales_order_id_s.NEXTVAL
31429: WHERE rowid = lb_rowid(j)
31430: AND demand_Source_header_id is null;
31431:

Line 31464: FROM msc_st_sales_orders

31460: v_current_date,
31461: v_current_user,
31462: v_current_date,
31463: v_current_user
31464: FROM msc_st_sales_orders
31465: WHERE rowid = lb_rowid(j);
31466:
31467: END IF;
31468: CLOSE c2;

Line 31474: 'UPDATE msc_st_sales_orders mso '

31470: -- Update demand source header id
31471:
31472: v_sql_stmt := 2.4;
31473: lv_sql_stmt :=
31474: 'UPDATE msc_st_sales_orders mso '
31475: ||' SET demand_source_header_id = (SELECT local_id'
31476: ||' FROM msc_local_id_demand mlid'
31477: ||' WHERE mlid.char1 = mso.sr_instance_code'
31478: ||' AND NVL(mlid.char2,'||''''||NULL_CHAR||''''||') '

Line 31509: UPDATE msc_st_sales_orders

31505: FETCH c1 BULK COLLECT INTO lb_rowid;
31506: IF c1%ROWCOUNT > 0 THEN
31507: v_sql_stmt := 03;
31508: FORALL j IN lb_rowid.FIRST..lb_rowid.LAST
31509: UPDATE msc_st_sales_orders
31510: SET st_transaction_id = msc_st_sales_orders_s.NEXTVAL,
31511: refresh_id = v_refresh_id,
31512: last_update_date = v_current_date,
31513: last_updated_by = v_current_user,

Line 31510: SET st_transaction_id = msc_st_sales_orders_s.NEXTVAL,

31506: IF c1%ROWCOUNT > 0 THEN
31507: v_sql_stmt := 03;
31508: FORALL j IN lb_rowid.FIRST..lb_rowid.LAST
31509: UPDATE msc_st_sales_orders
31510: SET st_transaction_id = msc_st_sales_orders_s.NEXTVAL,
31511: refresh_id = v_refresh_id,
31512: last_update_date = v_current_date,
31513: last_updated_by = v_current_user,
31514: creation_date = v_current_date,

Line 31542: 'UPDATE msc_st_sales_orders '

31538:
31539: v_sql_stmt := 04;
31540:
31541: lv_sql_stmt :=
31542: 'UPDATE msc_st_sales_orders '
31543: ||' SET process_flag = '||G_ERROR_FLG||','
31544: ||' error_text = '||''''||lv_message_text||''''
31545: ||' WHERE ( NVL(line_num,'||NULL_VALUE||') = '||NULL_VALUE
31546: ||' OR NVL(sales_order_number,'||''''||NULL_CHAR||''''||') '

Line 31581: (p_table_name => 'MSC_ST_SALES_ORDERS',

31577:
31578: --Log a warning for those records where the deleted_flag has a value other
31579: --SYS_NO or SYS_YES
31580: lv_return := MSC_ST_UTIL.LOG_ERROR
31581: (p_table_name => 'MSC_ST_SALES_ORDERS',
31582: p_instance_code => v_instance_code,
31583: p_row => lv_column_names,
31584: p_severity => G_SEV_WARNING,
31585: p_message_text => lv_message_text,

Line 31613: (p_table_name => 'MSC_ST_SALES_ORDERS',

31609: END IF;
31610:
31611: --Derive Organization_id
31612: lv_return := MSC_ST_UTIL.DERIVE_PARTNER_ORG_ID
31613: (p_table_name => 'MSC_ST_SALES_ORDERS',
31614: p_org_partner_name => 'ORGANIZATION_CODE',
31615: p_org_partner_id => 'ORGANIZATION_ID',
31616: p_instance_code => v_instance_code,
31617: p_partner_type => G_ORGANIZATION,

Line 31646: (p_table_name =>'MSC_ST_SALES_ORDERS',

31642:
31643: --DERIVE ORIGINAL_ITEM_ID
31644:
31645: lv_return := MSC_ST_UTIL.DERIVE_ITEM_ID
31646: (p_table_name =>'MSC_ST_SALES_ORDERS',
31647: p_item_col_name =>'ORIGINAL_ITEM_NAME',
31648: p_item_col_id =>'ORIGINAL_ITEM_ID',
31649: p_instance_code => v_instance_code,
31650: p_instance_id => v_instance_id,

Line 31666: 'UPDATE msc_st_sales_orders mso '

31662: -- Derive Demand id
31663:
31664: v_sql_stmt := 06;
31665: lv_sql_stmt :=
31666: 'UPDATE msc_st_sales_orders mso '
31667: ||' SET demand_id = (SELECT local_id'
31668: ||' FROM msc_local_id_demand mlid'
31669: ||' WHERE mlid.char1 = mso.sr_instance_code'
31670: ||' AND NVL(mlid.char2,'||''''||NULL_CHAR||''''||') '

Line 31705: 'UPDATE msc_st_sales_orders '

31701:
31702: v_sql_stmt := 07;
31703:
31704: lv_sql_stmt :=
31705: 'UPDATE msc_st_sales_orders '
31706: ||' SET process_flag ='||G_ERROR_FLG||','
31707: ||' error_text = '||''''||lv_message_text||''''
31708: ||' WHERE (NVL(demand_id,'||NULL_VALUE||') = '||NULL_VALUE
31709: ||' OR NVL(demand_source_header_id,'||NULL_VALUE||') = '||NULL_VALUE||')'

Line 31740: 'UPDATE msc_st_sales_orders '

31736:
31737: v_sql_stmt := 08;
31738:
31739: lv_sql_stmt :=
31740: 'UPDATE msc_st_sales_orders '
31741: ||' SET process_flag = '||G_ERROR_FLG||','
31742: ||' error_text = '||''''||lv_message_text||''''
31743: ||' WHERE ( NVL(primary_uom_quantity,'||NULL_VALUE||') = '||NULL_VALUE
31744: ||' OR NVL(requirement_date,SYSDATE-36500 ) = SYSDATE-36500 '

Line 31775: (p_table_name => 'MSC_ST_SALES_ORDERS',

31771: END IF;
31772:
31773: --Derive Inventory_item_id
31774: lv_return := MSC_ST_UTIL.DERIVE_ITEM_ID
31775: (p_table_name => 'MSC_ST_SALES_ORDERS',
31776: p_item_col_name => 'ITEM_NAME',
31777: p_item_col_id => 'INVENTORY_ITEM_ID',
31778: p_instance_id => v_instance_id,
31779: p_instance_code => v_instance_code,

Line 31802: p_token_value3 => 'MSC_ST_SALES_ORDERS' );

31798: ||'RECIPROCAL_FLAG,SR_INSTANCE_CODE',
31799: p_token2 => 'MASTER_TABLE',
31800: p_token_value2 => 'MSC_ST_ITEM_SUBSTITUTES/MSC_ITEM_SUBSTITUTES',
31801: p_token3 => 'CHILD_TABLE' ,
31802: p_token_value3 => 'MSC_ST_SALES_ORDERS' );
31803:
31804: IF lv_return <> 0 THEN
31805: RAISE ex_logging_err;
31806: END IF;

Line 31810: UPDATE msc_st_sales_orders

31806: END IF;
31807:
31808: --Validates the product substitution effectivity and directionality rules.
31809:
31810: UPDATE msc_st_sales_orders
31811: SET process_flag = G_ERROR_FLG,
31812: error_text = lv_message_text
31813: WHERE original_item_name is not null
31814: AND deleted_flag = SYS_NO

Line 31866: MSC_ST_UTIL.VALIDATE_DMD_CLASS(p_table_name => 'MSC_ST_SALES_ORDERS',

31862: -- Validate Demand Class, if value provided it should exists
31863: -- in ODS or staging table
31864:
31865: lv_return :=
31866: MSC_ST_UTIL.VALIDATE_DMD_CLASS(p_table_name => 'MSC_ST_SALES_ORDERS',
31867: p_dmd_class_column => 'DEMAND_CLASS',
31868: p_instance_id => v_instance_id,
31869: p_instance_code => v_instance_code,
31870: p_severity => G_SEV3_ERROR,

Line 31902: (p_table_name => 'MSC_ST_SALES_ORDERS',

31898: ' AND NVL(completed_quantity,'||NULL_VALUE||')'
31899: ||' = '||NULL_VALUE;
31900:
31901: lv_return := MSC_ST_UTIL.LOG_ERROR
31902: (p_table_name => 'MSC_ST_SALES_ORDERS',
31903: p_instance_code => v_instance_code,
31904: p_row => lv_column_names,
31905: p_severity => G_SEV_WARNING,
31906: p_message_text => lv_message_text,

Line 31940: (p_table_name => 'MSC_ST_SALES_ORDERS',

31936: ' AND NVL(demand_source_type ,'||NULL_VALUE||') NOT IN (2,8) '
31937: ||' AND deleted_flag = '||SYS_NO;
31938:
31939: lv_return := MSC_ST_UTIL.LOG_ERROR
31940: (p_table_name => 'MSC_ST_SALES_ORDERS',
31941: p_instance_code => v_instance_code,
31942: p_row => lv_column_names,
31943: p_severity => G_SEV_WARNING,
31944: p_message_text => lv_message_text,

Line 31978: (p_table_name => 'MSC_ST_SALES_ORDERS',

31974: ||' AND deleted_flag = '||SYS_NO;
31975:
31976:
31977: lv_return := MSC_ST_UTIL.LOG_ERROR
31978: (p_table_name => 'MSC_ST_SALES_ORDERS',
31979: p_instance_code => v_instance_code,
31980: p_row => lv_column_names,
31981: p_severity => G_SEV_WARNING,
31982: p_message_text => lv_message_text,

Line 32017: (p_table_name => 'MSC_ST_SALES_ORDERS',

32013: ||' AND deleted_flag = '||SYS_NO;
32014:
32015:
32016: lv_return := MSC_ST_UTIL.LOG_ERROR
32017: (p_table_name => 'MSC_ST_SALES_ORDERS',
32018: p_instance_code => v_instance_code,
32019: p_row => lv_column_names,
32020: p_severity => G_SEV_WARNING,
32021: p_message_text => lv_message_text,

Line 32054: (p_table_name => 'MSC_ST_SALES_ORDERS',

32050: lv_where_str :=
32051: ' AND NVL(cto_flag,'||NULL_VALUE||') NOT IN (1,2)' ;
32052:
32053: lv_return := MSC_ST_UTIL.LOG_ERROR
32054: (p_table_name => 'MSC_ST_SALES_ORDERS',
32055: p_instance_code => v_instance_code,
32056: p_row => lv_column_names,
32057: p_severity => G_SEV_WARNING,
32058: p_message_text => lv_message_text,

Line 32092: (p_table_name => 'MSC_ST_SALES_ORDERS',

32088: ' AND NVL(forecast_visible ,'||''''||NULL_CHAR||''''||')'
32089: ||' NOT IN (''Y'', ''N'') AND deleted_flag = '||SYS_NO ;
32090:
32091: lv_return := MSC_ST_UTIL.LOG_ERROR
32092: (p_table_name => 'MSC_ST_SALES_ORDERS',
32093: p_instance_code => v_instance_code,
32094: p_row => lv_column_names,
32095: p_severity => G_SEV_WARNING,
32096: p_message_text => lv_message_text,

Line 32130: (p_table_name => 'MSC_ST_SALES_ORDERS',

32126: ' AND NVL(demand_visible,'||''''||NULL_CHAR||''''||')'
32127: ||' NOT IN (''Y'', ''N'') AND deleted_flag = '||SYS_NO ;
32128:
32129: lv_return := MSC_ST_UTIL.LOG_ERROR
32130: (p_table_name => 'MSC_ST_SALES_ORDERS',
32131: p_instance_code => v_instance_code,
32132: p_row => lv_column_names,
32133: p_severity => G_SEV_WARNING,
32134: p_message_text => lv_message_text,

Line 32164: (p_table_name => 'MSC_ST_SALES_ORDERS',

32160:
32161: -- Derive customer_id
32162:
32163: lv_return := MSC_ST_UTIL.DERIVE_PARTNER_ORG_ID
32164: (p_table_name => 'MSC_ST_SALES_ORDERS',
32165: p_org_partner_name => 'CUSTOMER_NAME',
32166: p_org_partner_id => 'CUSTOMER_ID',
32167: p_instance_code => v_instance_code,
32168: p_partner_type => G_CUSTOMER,

Line 32196: (p_table_name => 'MSC_ST_SALES_ORDERS',

32192: END IF;
32193:
32194: -- Derive bill_to_site_id
32195: lv_return := MSC_ST_UTIL.DERIVE_PARTNER_SITE_ID
32196: (p_table_name => 'MSC_ST_SALES_ORDERS',
32197: p_partner_name => 'CUSTOMER_NAME',
32198: p_partner_site_code => 'BILL_TO_SITE_CODE',
32199: p_partner_site_id => 'BILL_TO_SITE_USE_ID',
32200: p_instance_code => v_instance_code,

Line 32229: (p_table_name => 'MSC_ST_SALES_ORDERS',

32225: END IF;
32226:
32227: -- Derive ship_to_site_id
32228: lv_return := MSC_ST_UTIL.DERIVE_PARTNER_SITE_ID
32229: (p_table_name => 'MSC_ST_SALES_ORDERS',
32230: p_partner_name => 'CUSTOMER_NAME',
32231: p_partner_site_code => 'SHIP_TO_SITE_CODE',
32232: p_partner_site_id => 'SHIP_TO_SITE_USE_ID',
32233: p_instance_code => v_instance_code,

Line 32263: (p_table_name => 'MSC_ST_SALES_ORDERS',

32259: END IF;
32260:
32261: --Derive Project Id.
32262: lv_return:= MSC_ST_UTIL.DERIVE_PROJ_TASK_ID
32263: (p_table_name => 'MSC_ST_SALES_ORDERS',
32264: p_proj_col_name => 'PROJECT_NUMBER',
32265: p_proj_task_col_id => 'PROJECT_ID',
32266: p_instance_code => v_instance_code,
32267: p_entity_name => 'PROJECT_ID',

Line 32297: (p_table_name => 'MSC_ST_SALES_ORDERS',

32293: END IF;
32294:
32295: --Derive Task Id.
32296: lv_return:= MSC_ST_UTIL.DERIVE_PROJ_TASK_ID
32297: (p_table_name => 'MSC_ST_SALES_ORDERS',
32298: p_proj_col_name => 'PROJECT_NUMBER',
32299: p_proj_task_col_id => 'TASK_ID',
32300: p_instance_code => v_instance_code,
32301: p_entity_name => 'TASK_ID',

Line 32318: 'UPDATE msc_st_sales_orders '

32314: /* v_sql_stmt := 09;
32315:
32316: lv_sql_stmt :=
32317:
32318: 'UPDATE msc_st_sales_orders '
32319: ||' SET ordered_item_id = inventory_item_id'
32320: ||' WHERE sr_instance_code = :v_instance_code'
32321: ||' AND deleted_flag ='||SYS_NO
32322: ||' AND process_flag ='||G_IN_PROCESS

Line 32352: (p_table_name => 'MSC_ST_SALES_ORDERS',

32348: ' AND NVL(order_date_type_code ,'||NULL_VALUE||') '
32349: ||' NOT IN (1,2)';
32350:
32351: lv_return := MSC_ST_UTIL.LOG_ERROR
32352: (p_table_name => 'MSC_ST_SALES_ORDERS',
32353: p_instance_code => v_instance_code,
32354: p_row => lv_column_names,
32355: p_severity => G_SEV_WARNING,
32356: p_message_text => lv_message_text,

Line 32374: pEntityName => 'MSC_ST_SALES_ORDERS',

32370: (ERRBUF => lv_error_text,
32371: RETCODE => lv_return,
32372: pBatchID => p_batch_id,
32373: pInstanceCode => v_instance_code,
32374: pEntityName => 'MSC_ST_SALES_ORDERS',
32375: pInstanceID => v_instance_id);
32376:
32377: IF NVL(lv_return,0) <> 0 THEN
32378: RAISE ex_logging_err;

Line 32389: UPDATE msc_st_sales_orders

32385:
32386: IF c3%ROWCOUNT > 0 THEN
32387: v_sql_stmt := 13;
32388: FORALL j IN lb_rowid.FIRST..lb_rowid.LAST
32389: UPDATE msc_st_sales_orders
32390: SET demand_id = msc_st_demand_id_s.NEXTVAL
32391: WHERE rowid = lb_rowid(j);
32392:
32393: v_sql_stmt := 14;

Line 32445: FROM msc_st_sales_orders

32441: v_current_date,
32442: v_current_user,
32443: v_current_date,
32444: v_current_user
32445: FROM msc_st_sales_orders
32446: WHERE rowid = lb_rowid(j);
32447:
32448: END IF;
32449: CLOSE c3 ;

Line 32453: 'UPDATE msc_st_sales_orders '

32449: CLOSE c3 ;
32450:
32451: lv_sql_stmt :=
32452:
32453: 'UPDATE msc_st_sales_orders '
32454: ||' SET demand_source_line = demand_id,'
32455: ||' atp_refresh_number = '||v_refresh_id
32456: ||' WHERE sr_instance_code = :v_instance_code'
32457: ||' AND deleted_flag ='||SYS_NO

Line 32471: 'UPDATE msc_st_sales_orders mso '

32467:
32468: v_sql_stmt := 15;
32469:
32470: lv_sql_stmt :=
32471: 'UPDATE msc_st_sales_orders mso '
32472: ||' SET ship_set_id = (SELECT local_id'
32473: ||' FROM msc_local_id_demand mlid'
32474: ||' WHERE mlid.char1 = mso.sr_instance_code'
32475: ||' AND NVL(mlid.char2,'||''''||NULL_CHAR||''''||') '

Line 32498: UPDATE msc_st_sales_orders

32494:
32495: IF c4%ROWCOUNT > 0 THEN
32496: v_sql_stmt := 15.1;
32497: FORALL j IN lb_rowid.FIRST..lb_rowid.LAST
32498: UPDATE msc_st_sales_orders
32499: SET ship_set_id = msc_st_set_id_s.NEXTVAL
32500: WHERE rowid = lb_rowid(j)
32501: AND ship_set_id is null;
32502:

Line 32535: FROM msc_st_sales_orders

32531: v_current_date,
32532: v_current_user,
32533: v_current_date,
32534: v_current_user
32535: FROM msc_st_sales_orders
32536: WHERE rowid = lb_rowid(j);
32537:
32538: END IF;
32539: CLOSE c4;

Line 32545: 'UPDATE msc_st_sales_orders mso '

32541: -- Update ship_set_id
32542:
32543: v_sql_stmt := 15.4;
32544: lv_sql_stmt :=
32545: 'UPDATE msc_st_sales_orders mso '
32546: ||' SET ship_set_id = (SELECT local_id'
32547: ||' FROM msc_local_id_demand mlid'
32548: ||' WHERE mlid.char1 = mso.sr_instance_code'
32549: ||' AND NVL(mlid.char2,'||''''||NULL_CHAR||''''||') '

Line 32573: 'UPDATE msc_st_sales_orders mso '

32569:
32570: v_sql_stmt := 16;
32571:
32572: lv_sql_stmt :=
32573: 'UPDATE msc_st_sales_orders mso '
32574: ||' SET arrival_set_id = (SELECT local_id'
32575: ||' FROM msc_local_id_demand mlid'
32576: ||' WHERE mlid.char1 = mso.sr_instance_code'
32577: ||' AND NVL(mlid.char2,'||''''||NULL_CHAR||''''||') '

Line 32600: UPDATE msc_st_sales_orders

32596:
32597: IF c5%ROWCOUNT > 0 THEN
32598: v_sql_stmt := 16.1;
32599: FORALL j IN lb_rowid.FIRST..lb_rowid.LAST
32600: UPDATE msc_st_sales_orders
32601: SET arrival_set_id = msc_st_set_id_s.NEXTVAL
32602: WHERE rowid = lb_rowid(j)
32603: AND arrival_set_id is null;
32604:

Line 32637: FROM msc_st_sales_orders

32633: v_current_date,
32634: v_current_user,
32635: v_current_date,
32636: v_current_user
32637: FROM msc_st_sales_orders
32638: WHERE rowid = lb_rowid(j);
32639:
32640: END IF;
32641: CLOSE c5;

Line 32647: 'UPDATE msc_st_sales_orders mso '

32643: -- Update arrival_set_id
32644:
32645: v_sql_stmt := 16.4;
32646: lv_sql_stmt :=
32647: 'UPDATE msc_st_sales_orders mso '
32648: ||' SET arrival_set_id = (SELECT local_id'
32649: ||' FROM msc_local_id_demand mlid'
32650: ||' WHERE mlid.char1 = mso.sr_instance_code'
32651: ||' AND NVL(mlid.char2,'||''''||NULL_CHAR||''''||') '

Line 32673: 'UPDATE msc_st_sales_orders mso '

32669: -- populate row_type
32670:
32671: v_sql_stmt := 17;
32672: lv_sql_stmt :=
32673: 'UPDATE msc_st_sales_orders mso '
32674: ||' SET ROW_TYPE= decode(reservation_type,1,decode(AVAILABLE_TO_MRP,''N'',''3'',''1'')
32675: ,2,1
32676: ,3,1
32677: ,NULL)' -- resv tp already validated for 1,2,3 so this decode should never return NULL.

Line 32688: (p_table_name => 'MSC_ST_SALES_ORDERS',

32684:
32685: EXECUTE IMMEDIATE lv_sql_stmt USING p_batch_id,v_instance_code;
32686:
32687: lv_return := MSC_ST_UTIL.SET_PROCESS_FLAG
32688: (p_table_name => 'MSC_ST_SALES_ORDERS',
32689: p_instance_id => v_instance_id,
32690: p_instance_code => v_instance_code,
32691: p_process_flag => G_VALID,
32692: p_error_text => lv_error_text,

Line 32701: (p_table_name => 'MSC_ST_SALES_ORDERS',

32697: RAISE ex_logging_err;
32698: END IF;
32699:
32700: lv_return := MSC_ST_UTIL.LOG_ERROR
32701: (p_table_name => 'MSC_ST_SALES_ORDERS',
32702: p_instance_code => v_instance_code,
32703: p_row => lv_column_names,
32704: p_severity => G_SEV_ERROR,
32705: p_message_text => NULL,

Line 49827: 'UPDATE msc_st_sales_orders mso1'

49823:
49824: v_sql_stmt := 13;
49825:
49826: lv_sql_stmt :=
49827: 'UPDATE msc_st_sales_orders mso1'
49828: ||' SET process_flag = '||G_ERROR_FLG||','
49829: ||' error_text = '||''''||lv_message_text||''''
49830: ||' WHERE message_id < (SELECT MAX(message_id)'
49831: ||' FROM msc_st_sales_orders mso2'

Line 49831: ||' FROM msc_st_sales_orders mso2'

49827: 'UPDATE msc_st_sales_orders mso1'
49828: ||' SET process_flag = '||G_ERROR_FLG||','
49829: ||' error_text = '||''''||lv_message_text||''''
49830: ||' WHERE message_id < (SELECT MAX(message_id)'
49831: ||' FROM msc_st_sales_orders mso2'
49832: ||' WHERE mso2.sr_instance_code '
49833: ||' = mso1.sr_instance_code '
49834: ||' AND mso2.sales_order_number '
49835: ||' = mso1.sales_order_number '

Line 49873: 'UPDATE msc_st_sales_orders mso1'

49869:
49870: v_sql_stmt := 14;
49871:
49872: lv_sql_stmt :=
49873: 'UPDATE msc_st_sales_orders mso1'
49874: ||' SET process_flag = '||G_ERROR_FLG||','
49875: ||' error_text = '||''''||lv_message_text||''''
49876: ||' WHERE EXISTS( SELECT 1 '
49877: ||' FROM msc_st_sales_orders mso2'

Line 49877: ||' FROM msc_st_sales_orders mso2'

49873: 'UPDATE msc_st_sales_orders mso1'
49874: ||' SET process_flag = '||G_ERROR_FLG||','
49875: ||' error_text = '||''''||lv_message_text||''''
49876: ||' WHERE EXISTS( SELECT 1 '
49877: ||' FROM msc_st_sales_orders mso2'
49878: ||' WHERE mso2.sr_instance_code '
49879: ||' = mso1.sr_instance_code '
49880: ||' AND mso2.sales_order_number '
49881: ||' = mso1.sales_order_number '

Line 50835: lv_count:= SET_IN_PROCESS (p_table_name => 'MSC_ST_SALES_ORDERS ',p_erp_enabled => 'Y');

50831: prec.wip_flag:= SYS_YES;
50832: prec.internal_repair_flag:=SYS_YES;
50833: prec.external_repair_flag:=SYS_YES;
50834: End IF;
50835: lv_count:= SET_IN_PROCESS (p_table_name => 'MSC_ST_SALES_ORDERS ',p_erp_enabled => 'Y');
50836: IF lv_count > 0 Then
50837: prec.sales_order_flag:= SYS_YES;
50838: End IF;
50839: END IF;

Line 54016: cursor c2 is SELECT rowid FROM msc_st_sales_orders

54012: lb_batch NumTblTyp := NumTblTyp(0);
54013: lv_batch_id PLS_INTEGER;
54014: lv_batch_start PLS_INTEGER;
54015: lv_batch_last PLS_INTEGER;
54016: cursor c2 is SELECT rowid FROM msc_st_sales_orders
54017: WHERE PROCESS_FLAG IN (G_IN_PROCESS,G_ERROR_FLG)
54018: AND NVL(batch_id,NULL_VALUE) = NULL_VALUE
54019: AND sr_instance_code = v_instance_code;
54020:

Line 54044: UPDATE msc_st_sales_orders

54040:
54041: lv_batch_last := lv_batch_id;
54042:
54043: FORALL j IN lb_rowid.FIRST..lb_rowid.LAST
54044: UPDATE msc_st_sales_orders
54045: SET batch_id = lb_batch(j)
54046: WHERE rowid = lb_rowid(j);
54047:
54048: commit;