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 686: ||' on MSC_ST_SALES_ORDERS '

682: application_short_name => 'MSC',
683: statement_type => AD_DDL.CREATE_INDEX,
684: statement =>
685: 'create index MSC_ST_SO_N1_'||v_instance_code
686: ||' on MSC_ST_SALES_ORDERS '
687: ||'(sr_instance_code, sales_order_number, line_num, organization_code, company_name) '
688: ||' STORAGE (INITIAL 100K NEXT 1M PCTINCREASE 0) ',
689: object_name =>'MSC_ST_SO_N1_'||v_instance_code);
690:

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

695: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_WARNING,'Error creating Index MSC_ST_SO_N1_'||v_instance_code||'. Error:'||substr(SQLERRM,1,240));
696: END;
697:
698: msc_analyse_tables_pk.analyse_table( 'MSC_ST_DEMANDS', v_instance_id, -1);
699: msc_analyse_tables_pk.analyse_table( 'MSC_ST_SALES_ORDERS', v_instance_id, -1);
700:
701: END IF;
702:
703: IF v_reserve_enabled = SYS_YES THEN

Line 1758: ||' on MSC_ST_SALES_ORDERS '

1754: application_short_name => 'MSC',
1755: statement_type => AD_DDL.CREATE_INDEX,
1756: statement =>
1757: 'create index MSC_ST_SO_N2_'||v_instance_code
1758: ||' on MSC_ST_SALES_ORDERS '
1759: ||' (sales_order_number, batch_id ,sr_instance_code, deleted_flag) '
1760: ||' STORAGE (INITIAL 100K NEXT 1M PCTINCREASE 0) ',
1761: object_name => 'MSC_ST_SO_N2_'||v_instance_code);
1762:

Line 1776: ||' on MSC_ST_SALES_ORDERS '

1772: application_short_name => 'MSC',
1773: statement_type => AD_DDL.CREATE_INDEX,
1774: statement =>
1775: 'create index MSC_ST_SO_N3_'||v_instance_code
1776: ||' on MSC_ST_SALES_ORDERS '
1777: ||' (sr_instance_code, batch_id , deleted_flag) '
1778: ||' STORAGE (INITIAL 100K NEXT 1M PCTINCREASE 0) ',
1779: object_name => 'MSC_ST_SO_N3_'||v_instance_code);
1780:

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

1784: WHEN OTHERS THEN
1785: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_WARNING,'Error creating Index MSC_ST_SO_N3_'||v_instance_code||'. Error:'||substr(SQLERRM,1,240));
1786: END;
1787:
1788: msc_analyse_tables_pk.analyse_table( 'MSC_ST_SALES_ORDERS', v_instance_id, -1);
1789:
1790: END IF;
1791:
1792: EXCEPTION

Line 35743: | records from the msc_st_sales_orders table. |

35739: END LOAD_SUPPLY;
35740:
35741: /*==========================================================================+
35742: | DESCRIPTION : This procedure is called for validating demand related |
35743: | records from the msc_st_sales_orders table. |
35744: +==========================================================================*/
35745: PROCEDURE LOAD_SALES_ORDER (p_batch_id IN NUMBER ) IS
35746: TYPE RowidTab IS TABLE OF ROWID INDEX BY BINARY_INTEGER;
35747:

Line 35769: FROM msc_st_sales_orders

35765: PRAGMA EXCEPTION_INIT(busy, -54);
35766:
35767: CURSOR c1(p_batch_id NUMBER) IS
35768: SELECT rowid
35769: FROM msc_st_sales_orders
35770: WHERE process_flag IN (G_IN_PROCESS,G_ERROR_FLG)
35771: AND batch_id = p_batch_id
35772: AND sr_instance_code = v_instance_code;
35773:

Line 35776: FROM msc_st_sales_orders

35772: AND sr_instance_code = v_instance_code;
35773:
35774: CURSOR c2(p_batch_id NUMBER) IS
35775: SELECT max(rowid)
35776: FROM msc_st_sales_orders
35777: WHERE process_flag = G_IN_PROCESS
35778: AND sr_instance_code = v_instance_code
35779: AND batch_id = p_batch_id
35780: AND NVL(demand_source_header_id,NULL_VALUE) = NULL_VALUE

Line 35787: FROM msc_st_sales_orders

35783: ORGANIZATION_CODE,SALES_ORDER_NUMBER;
35784:
35785: CURSOR c3(p_batch_id NUMBER) IS
35786: SELECT rowid
35787: FROM msc_st_sales_orders
35788: WHERE process_flag = G_IN_PROCESS
35789: AND sr_instance_code = v_instance_code
35790: AND batch_id = p_batch_id
35791: AND NVL(demand_id,NULL_VALUE) = NULL_VALUE

Line 35796: FROM msc_st_sales_orders

35792: AND deleted_flag = SYS_NO;
35793:
35794: CURSOR c4(p_batch_id NUMBER) IS
35795: SELECT max(rowid)
35796: FROM msc_st_sales_orders
35797: WHERE process_flag = G_IN_PROCESS
35798: AND sr_instance_code = v_instance_code
35799: AND batch_id = p_batch_id
35800: AND NVL(ship_set_id,NULL_VALUE) = NULL_VALUE

Line 35808: FROM msc_st_sales_orders

35804: ORGANIZATION_CODE,SALES_ORDER_NUMBER, SHIP_SET_NAME;
35805:
35806: CURSOR c5(p_batch_id NUMBER) IS
35807: SELECT max(rowid)
35808: FROM msc_st_sales_orders
35809: WHERE process_flag = G_IN_PROCESS
35810: AND sr_instance_code = v_instance_code
35811: AND batch_id = p_batch_id
35812: AND NVL(arrival_set_id,NULL_VALUE) = NULL_VALUE

Line 35820: FROM msc_st_sales_orders mso ,

35816: ORGANIZATION_CODE,SALES_ORDER_NUMBER, ARRIVAL_SET_NAME;
35817:
35818: CURSOR c_lock(p_batch_id NUMBER) IS
35819: SELECT 'X'
35820: FROM msc_st_sales_orders mso ,
35821: msc_st_sales_orders mcr
35822: WHERE mso.batch_id = p_batch_id
35823: AND mso.batch_id <> nvl(mcr.batch_id,NULL_VALUE)
35824: AND mso.demand_source_header_id IS NULL

Line 35821: msc_st_sales_orders mcr

35817:
35818: CURSOR c_lock(p_batch_id NUMBER) IS
35819: SELECT 'X'
35820: FROM msc_st_sales_orders mso ,
35821: msc_st_sales_orders mcr
35822: WHERE mso.batch_id = p_batch_id
35823: AND mso.batch_id <> nvl(mcr.batch_id,NULL_VALUE)
35824: AND mso.demand_source_header_id IS NULL
35825: AND mcr.demand_source_header_id IS NULL

Line 35920: 'UPDATE msc_st_sales_orders '

35916: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_WARNING,lv_error_text);
35917:
35918: v_sql_stmt := 1.1;
35919: lv_sql_stmt :=
35920: 'UPDATE msc_st_sales_orders '
35921: ||' SET process_flag = 1,'
35922: ||' batch_id = NULL'
35923: ||' WHERE batch_id = :p_batch_id'
35924: ||' AND process_flag = '||G_IN_PROCESS

Line 35962: 'UPDATE msc_st_sales_orders '

35958:
35959: v_sql_stmt := 1.5;
35960:
35961: lv_sql_stmt :=
35962: 'UPDATE msc_st_sales_orders '
35963: ||' SET process_flag = '||G_ERROR_FLG||','
35964: ||' error_text = '||''''||lv_message_text||''''
35965: ||' WHERE ( NVL(SOURCE_DEMAND_SOURCE_HEADER_ID,'
35966: ||NULL_VALUE||') = '||NULL_VALUE

Line 35988: 'UPDATE msc_st_sales_orders mso '

35984: -- Generate demand_source_header_id
35985:
35986: v_sql_stmt := 2.0;
35987: lv_sql_stmt :=
35988: 'UPDATE msc_st_sales_orders mso '
35989: ||' SET demand_source_header_id = (SELECT local_id'
35990: ||' FROM msc_local_id_demand mlid'
35991: ||' WHERE mlid.char1 = mso.sr_instance_code'
35992: ||' AND NVL(mlid.char2,'||''''||NULL_CHAR||''''||') '

Line 36013: UPDATE msc_st_sales_orders

36009:
36010: IF c2%ROWCOUNT > 0 THEN
36011: v_sql_stmt := 2.1;
36012: FORALL j IN lb_rowid.FIRST..lb_rowid.LAST
36013: UPDATE msc_st_sales_orders
36014: SET demand_source_header_id = msc_st_sales_order_id_s.NEXTVAL
36015: WHERE rowid = lb_rowid(j)
36016: AND demand_Source_header_id is null;
36017:

Line 36050: FROM msc_st_sales_orders

36046: v_current_date,
36047: v_current_user,
36048: v_current_date,
36049: v_current_user
36050: FROM msc_st_sales_orders
36051: WHERE rowid = lb_rowid(j);
36052:
36053: END IF;
36054: CLOSE c2;

Line 36060: 'UPDATE msc_st_sales_orders mso '

36056: -- Update demand source header id
36057:
36058: v_sql_stmt := 2.4;
36059: lv_sql_stmt :=
36060: 'UPDATE msc_st_sales_orders mso '
36061: ||' SET demand_source_header_id = (SELECT local_id'
36062: ||' FROM msc_local_id_demand mlid'
36063: ||' WHERE mlid.char1 = mso.sr_instance_code'
36064: ||' AND NVL(mlid.char2,'||''''||NULL_CHAR||''''||') '

Line 36099: 'UPDATE msc_st_sales_orders mso '

36095:
36096: v_sql_stmt := 2.5;
36097:
36098: lv_sql_stmt :=
36099: 'UPDATE msc_st_sales_orders mso '
36100: ||' SET demand_source_header_id = source_demand_source_header_id'
36101: ||' WHERE process_flag = '||G_IN_PROCESS
36102: ||' AND NVL(demand_source_header_id,'||NULL_VALUE||') = '||NULL_VALUE
36103: ||' AND batch_id = :p_batch_id '

Line 36119: UPDATE msc_st_sales_orders

36115: FETCH c1 BULK COLLECT INTO lb_rowid;
36116: IF c1%ROWCOUNT > 0 THEN
36117: v_sql_stmt := 03;
36118: FORALL j IN lb_rowid.FIRST..lb_rowid.LAST
36119: UPDATE msc_st_sales_orders
36120: SET st_transaction_id = msc_st_sales_orders_s.NEXTVAL,
36121: refresh_id = v_refresh_id,
36122: last_update_date = v_current_date,
36123: last_updated_by = v_current_user,

Line 36120: SET st_transaction_id = msc_st_sales_orders_s.NEXTVAL,

36116: IF c1%ROWCOUNT > 0 THEN
36117: v_sql_stmt := 03;
36118: FORALL j IN lb_rowid.FIRST..lb_rowid.LAST
36119: UPDATE msc_st_sales_orders
36120: SET st_transaction_id = msc_st_sales_orders_s.NEXTVAL,
36121: refresh_id = v_refresh_id,
36122: last_update_date = v_current_date,
36123: last_updated_by = v_current_user,
36124: creation_date = v_current_date,

Line 36151: 'UPDATE msc_st_sales_orders '

36147: -- Error out records if REVISED_DMD_PRIORITY is not a positive number
36148:
36149: v_sql_stmt := 03;
36150: lv_sql_stmt :=
36151: 'UPDATE msc_st_sales_orders '
36152: ||' SET process_flag = '||G_ERROR_FLG||','
36153: ||' error_text = '||''''||lv_message_text||''''
36154: ||' WHERE NVL(REVISED_DMD_PRIORITY, 1) < 0'
36155: ||' AND process_flag = '||G_IN_PROCESS

Line 36181: (p_table_name => 'MSC_ST_SALES_ORDERS',

36177:
36178: --Log a warning for those records where the revised_dmd_date is greater
36179: --than firm date(requirement_date)
36180: lv_return := MSC_ST_UTIL.LOG_ERROR
36181: (p_table_name => 'MSC_ST_SALES_ORDERS',
36182: p_instance_code => v_instance_code,
36183: p_row => lv_column_names,
36184: p_severity => G_SEV_WARNING,
36185: p_message_text => lv_message_text,

Line 36221: 'UPDATE msc_st_sales_orders '

36217:
36218: v_sql_stmt := 04;
36219:
36220: lv_sql_stmt :=
36221: 'UPDATE msc_st_sales_orders '
36222: ||' SET process_flag = '||G_ERROR_FLG||','
36223: ||' error_text = '||''''||lv_message_text||''''
36224: ||' WHERE ( NVL(line_num,'||NULL_VALUE||') = '||NULL_VALUE
36225: ||' OR NVL(sales_order_number,'||''''||NULL_CHAR||''''||') '

Line 36260: (p_table_name => 'MSC_ST_SALES_ORDERS',

36256:
36257: --Log a warning for those records where the deleted_flag has a value other
36258: --SYS_NO or SYS_YES
36259: lv_return := MSC_ST_UTIL.LOG_ERROR
36260: (p_table_name => 'MSC_ST_SALES_ORDERS',
36261: p_instance_code => v_instance_code,
36262: p_row => lv_column_names,
36263: p_severity => G_SEV_WARNING,
36264: p_message_text => lv_message_text,

Line 36292: (p_table_name => 'MSC_ST_SALES_ORDERS',

36288: END IF;
36289:
36290: --Derive Organization_id
36291: lv_return := MSC_ST_UTIL.DERIVE_PARTNER_ORG_ID
36292: (p_table_name => 'MSC_ST_SALES_ORDERS',
36293: p_org_partner_name => 'ORGANIZATION_CODE',
36294: p_org_partner_id => 'ORGANIZATION_ID',
36295: p_instance_code => v_instance_code,
36296: p_partner_type => G_ORGANIZATION,

Line 36325: (p_table_name =>'MSC_ST_SALES_ORDERS',

36321:
36322: --DERIVE ORIGINAL_ITEM_ID
36323:
36324: lv_return := MSC_ST_UTIL.DERIVE_ITEM_ID
36325: (p_table_name =>'MSC_ST_SALES_ORDERS',
36326: p_item_col_name =>'ORIGINAL_ITEM_NAME',
36327: p_item_col_id =>'ORIGINAL_ITEM_ID',
36328: p_instance_code => v_instance_code,
36329: p_instance_id => v_instance_id,

Line 36364: (p_table_name => 'MSC_ST_SALES_ORDERS',

36360: ||' AND deleted_flag = '||SYS_NO;
36361:
36362:
36363: lv_return := MSC_ST_UTIL.LOG_ERROR
36364: (p_table_name => 'MSC_ST_SALES_ORDERS',
36365: p_instance_code => v_instance_code,
36366: p_row => lv_column_names,
36367: p_severity => G_SEV_WARNING,
36368: p_message_text => lv_message_text,

Line 36385: 'UPDATE msc_st_sales_orders mso '

36381: -- Derive Demand id
36382:
36383: v_sql_stmt := 06;
36384: lv_sql_stmt :=
36385: 'UPDATE msc_st_sales_orders mso '
36386: ||' SET demand_id = (SELECT local_id'
36387: ||' FROM msc_local_id_demand mlid'
36388: ||' WHERE mlid.char1 = mso.sr_instance_code'
36389: ||' AND NVL(mlid.char2,'||''''||NULL_CHAR||''''||') '

Line 36424: 'UPDATE msc_st_sales_orders '

36420:
36421: v_sql_stmt := 07;
36422:
36423: lv_sql_stmt :=
36424: 'UPDATE msc_st_sales_orders '
36425: ||' SET process_flag ='||G_ERROR_FLG||','
36426: ||' error_text = '||''''||lv_message_text||''''
36427: ||' WHERE (NVL(demand_id,'||NULL_VALUE||') = '||NULL_VALUE
36428: ||' OR NVL(demand_source_header_id,'||NULL_VALUE||') = '||NULL_VALUE||')'

Line 36459: 'UPDATE msc_st_sales_orders '

36455:
36456: v_sql_stmt := 08;
36457:
36458: lv_sql_stmt :=
36459: 'UPDATE msc_st_sales_orders '
36460: ||' SET process_flag = '||G_ERROR_FLG||','
36461: ||' error_text = '||''''||lv_message_text||''''
36462: ||' WHERE ( NVL(primary_uom_quantity,'||NULL_VALUE||') = '||NULL_VALUE
36463: ||' OR NVL(requirement_date,SYSDATE-36500 ) = SYSDATE-36500 '

Line 36494: (p_table_name => 'MSC_ST_SALES_ORDERS',

36490: END IF;
36491:
36492: --Derive Inventory_item_id
36493: lv_return := MSC_ST_UTIL.DERIVE_ITEM_ID
36494: (p_table_name => 'MSC_ST_SALES_ORDERS',
36495: p_item_col_name => 'ITEM_NAME',
36496: p_item_col_id => 'INVENTORY_ITEM_ID',
36497: p_instance_id => v_instance_id,
36498: p_instance_code => v_instance_code,

Line 36521: p_token_value3 => 'MSC_ST_SALES_ORDERS' );

36517: ||'RECIPROCAL_FLAG,SR_INSTANCE_CODE',
36518: p_token2 => 'MASTER_TABLE',
36519: p_token_value2 => 'MSC_ST_ITEM_SUBSTITUTES/MSC_ITEM_SUBSTITUTES',
36520: p_token3 => 'CHILD_TABLE' ,
36521: p_token_value3 => 'MSC_ST_SALES_ORDERS' );
36522:
36523: IF lv_return <> 0 THEN
36524: RAISE ex_logging_err;
36525: END IF;

Line 36529: UPDATE msc_st_sales_orders

36525: END IF;
36526:
36527: --Validates the product substitution effectivity and directionality rules.
36528:
36529: UPDATE msc_st_sales_orders
36530: SET process_flag = G_ERROR_FLG,
36531: error_text = lv_message_text
36532: WHERE original_item_name is not null
36533: AND deleted_flag = SYS_NO

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

36581: -- Validate Demand Class, if value provided it should exists
36582: -- in ODS or staging table
36583:
36584: lv_return :=
36585: MSC_ST_UTIL.VALIDATE_DMD_CLASS(p_table_name => 'MSC_ST_SALES_ORDERS',
36586: p_dmd_class_column => 'DEMAND_CLASS',
36587: p_instance_id => v_instance_id,
36588: p_instance_code => v_instance_code,
36589: p_severity => G_SEV3_ERROR,

Line 36621: (p_table_name => 'MSC_ST_SALES_ORDERS',

36617: ' AND NVL(completed_quantity,'||NULL_VALUE||')'
36618: ||' = '||NULL_VALUE;
36619:
36620: lv_return := MSC_ST_UTIL.LOG_ERROR
36621: (p_table_name => 'MSC_ST_SALES_ORDERS',
36622: p_instance_code => v_instance_code,
36623: p_row => lv_column_names,
36624: p_severity => G_SEV_WARNING,
36625: p_message_text => lv_message_text,

Line 36659: (p_table_name => 'MSC_ST_SALES_ORDERS',

36655: ' AND NVL(demand_source_type ,'||NULL_VALUE||') NOT IN (2,8) '
36656: ||' AND deleted_flag = '||SYS_NO;
36657:
36658: lv_return := MSC_ST_UTIL.LOG_ERROR
36659: (p_table_name => 'MSC_ST_SALES_ORDERS',
36660: p_instance_code => v_instance_code,
36661: p_row => lv_column_names,
36662: p_severity => G_SEV_WARNING,
36663: p_message_text => lv_message_text,

Line 36699: (p_table_name => 'MSC_ST_SALES_ORDERS',

36695: ||' AND deleted_flag = '||SYS_NO;
36696:
36697:
36698: lv_return := MSC_ST_UTIL.LOG_ERROR
36699: (p_table_name => 'MSC_ST_SALES_ORDERS',
36700: p_instance_code => v_instance_code,
36701: p_row => lv_column_names,
36702: p_severity => G_SEV_WARNING,
36703: p_message_text => lv_message_text,

Line 36736: (p_table_name => 'MSC_ST_SALES_ORDERS',

36732: lv_where_str :=
36733: ' AND NVL(cto_flag,'||NULL_VALUE||') NOT IN (1,2)' ;
36734:
36735: lv_return := MSC_ST_UTIL.LOG_ERROR
36736: (p_table_name => 'MSC_ST_SALES_ORDERS',
36737: p_instance_code => v_instance_code,
36738: p_row => lv_column_names,
36739: p_severity => G_SEV_WARNING,
36740: p_message_text => lv_message_text,

Line 36774: (p_table_name => 'MSC_ST_SALES_ORDERS',

36770: ' AND NVL(forecast_visible ,'||''''||NULL_CHAR||''''||')'
36771: ||' NOT IN (''Y'', ''N'') AND deleted_flag = '||SYS_NO ;
36772:
36773: lv_return := MSC_ST_UTIL.LOG_ERROR
36774: (p_table_name => 'MSC_ST_SALES_ORDERS',
36775: p_instance_code => v_instance_code,
36776: p_row => lv_column_names,
36777: p_severity => G_SEV_WARNING,
36778: p_message_text => lv_message_text,

Line 36812: (p_table_name => 'MSC_ST_SALES_ORDERS',

36808: ' AND NVL(demand_visible,'||''''||NULL_CHAR||''''||')'
36809: ||' NOT IN (''Y'', ''N'') AND deleted_flag = '||SYS_NO ;
36810:
36811: lv_return := MSC_ST_UTIL.LOG_ERROR
36812: (p_table_name => 'MSC_ST_SALES_ORDERS',
36813: p_instance_code => v_instance_code,
36814: p_row => lv_column_names,
36815: p_severity => G_SEV_WARNING,
36816: p_message_text => lv_message_text,

Line 36846: (p_table_name => 'MSC_ST_SALES_ORDERS',

36842:
36843: -- Derive customer_id
36844:
36845: lv_return := MSC_ST_UTIL.DERIVE_PARTNER_ORG_ID
36846: (p_table_name => 'MSC_ST_SALES_ORDERS',
36847: p_org_partner_name => 'CUSTOMER_NAME',
36848: p_org_partner_id => 'CUSTOMER_ID',
36849: p_instance_code => v_instance_code,
36850: p_partner_type => G_CUSTOMER,

Line 36878: (p_table_name => 'MSC_ST_SALES_ORDERS',

36874: END IF;
36875:
36876: -- Derive bill_to_site_id
36877: lv_return := MSC_ST_UTIL.DERIVE_PARTNER_SITE_ID
36878: (p_table_name => 'MSC_ST_SALES_ORDERS',
36879: p_partner_name => 'CUSTOMER_NAME',
36880: p_partner_site_code => 'BILL_TO_SITE_CODE',
36881: p_partner_site_id => 'BILL_TO_SITE_USE_ID',
36882: p_instance_code => v_instance_code,

Line 36911: (p_table_name => 'MSC_ST_SALES_ORDERS',

36907: END IF;
36908:
36909: -- Derive ship_to_site_id
36910: lv_return := MSC_ST_UTIL.DERIVE_PARTNER_SITE_ID
36911: (p_table_name => 'MSC_ST_SALES_ORDERS',
36912: p_partner_name => 'CUSTOMER_NAME',
36913: p_partner_site_code => 'SHIP_TO_SITE_CODE',
36914: p_partner_site_id => 'SHIP_TO_SITE_USE_ID',
36915: p_instance_code => v_instance_code,

Line 36945: (p_table_name => 'MSC_ST_SALES_ORDERS',

36941: END IF;
36942:
36943: --Derive Project Id.
36944: lv_return:= MSC_ST_UTIL.DERIVE_PROJ_TASK_ID
36945: (p_table_name => 'MSC_ST_SALES_ORDERS',
36946: p_proj_col_name => 'PROJECT_NUMBER',
36947: p_proj_task_col_id => 'PROJECT_ID',
36948: p_instance_code => v_instance_code,
36949: p_entity_name => 'PROJECT_ID',

Line 36979: (p_table_name => 'MSC_ST_SALES_ORDERS',

36975: END IF;
36976:
36977: --Derive Task Id.
36978: lv_return:= MSC_ST_UTIL.DERIVE_PROJ_TASK_ID
36979: (p_table_name => 'MSC_ST_SALES_ORDERS',
36980: p_proj_col_name => 'PROJECT_NUMBER',
36981: p_proj_task_col_id => 'TASK_ID',
36982: p_instance_code => v_instance_code,
36983: p_entity_name => 'TASK_ID',

Line 37000: 'UPDATE msc_st_sales_orders '

36996: /* v_sql_stmt := 09;
36997:
36998: lv_sql_stmt :=
36999:
37000: 'UPDATE msc_st_sales_orders '
37001: ||' SET ordered_item_id = inventory_item_id'
37002: ||' WHERE sr_instance_code = :v_instance_code'
37003: ||' AND deleted_flag ='||SYS_NO
37004: ||' AND process_flag ='||G_IN_PROCESS

Line 37034: (p_table_name => 'MSC_ST_SALES_ORDERS',

37030: ' AND NVL(order_date_type_code ,'||NULL_VALUE||') '
37031: ||' NOT IN (1,2)';
37032:
37033: lv_return := MSC_ST_UTIL.LOG_ERROR
37034: (p_table_name => 'MSC_ST_SALES_ORDERS',
37035: p_instance_code => v_instance_code,
37036: p_row => lv_column_names,
37037: p_severity => G_SEV_WARNING,
37038: p_message_text => lv_message_text,

Line 37056: pEntityName => 'MSC_ST_SALES_ORDERS',

37052: (ERRBUF => lv_error_text,
37053: RETCODE => lv_return,
37054: pBatchID => p_batch_id,
37055: pInstanceCode => v_instance_code,
37056: pEntityName => 'MSC_ST_SALES_ORDERS',
37057: pInstanceID => v_instance_id);
37058:
37059: IF NVL(lv_return,0) <> 0 THEN
37060: RAISE ex_logging_err;

Line 37073: UPDATE msc_st_sales_orders

37069:
37070: IF c3%ROWCOUNT > 0 THEN
37071: v_sql_stmt := 13;
37072: FORALL j IN lb_rowid.FIRST..lb_rowid.LAST
37073: UPDATE msc_st_sales_orders
37074: SET demand_id = msc_st_demand_id_s.NEXTVAL
37075: WHERE rowid = lb_rowid(j);
37076:
37077: v_sql_stmt := 14;

Line 37129: FROM msc_st_sales_orders

37125: v_current_date,
37126: v_current_user,
37127: v_current_date,
37128: v_current_user
37129: FROM msc_st_sales_orders
37130: WHERE rowid = lb_rowid(j);
37131:
37132: END IF;
37133: CLOSE c3 ;

Line 37137: 'UPDATE msc_st_sales_orders '

37133: CLOSE c3 ;
37134:
37135: lv_sql_stmt :=
37136:
37137: 'UPDATE msc_st_sales_orders '
37138: ||' SET demand_source_line = demand_id,'
37139: ||' atp_refresh_number = '||v_refresh_id
37140: ||' WHERE sr_instance_code = :v_instance_code'
37141: ||' AND deleted_flag ='||SYS_NO

Line 37157: -- Then, we will finally update msc_st_sales_orders.demand_id

37153: -- in the staging table.
37154: -- Here, we will insert entity_type DEMAND_ID into
37155: -- msc_local_id_demand for sales order lines that are not present
37156: -- in the table already.
37157: -- Then, we will finally update msc_st_sales_orders.demand_id
37158: -- to be equal to demand_source_line
37159:
37160: v_sql_stmt := 14.5;
37161:

Line 37164: 'UPDATE msc_st_sales_orders '

37160: v_sql_stmt := 14.5;
37161:
37162: lv_sql_stmt :=
37163:
37164: 'UPDATE msc_st_sales_orders '
37165: ||' SET demand_source_line = source_demand_source_line,'
37166: ||' demand_id = source_demand_source_line,'
37167: ||' atp_refresh_number = '||v_refresh_id
37168: ||' WHERE sr_instance_code = :v_instance_code'

Line 37186: 'UPDATE msc_st_sales_orders mso '

37182:
37183: v_sql_stmt := 15;
37184:
37185: lv_sql_stmt :=
37186: 'UPDATE msc_st_sales_orders mso '
37187: ||' SET ship_set_id = (SELECT local_id'
37188: ||' FROM msc_local_id_demand mlid'
37189: ||' WHERE mlid.char1 = mso.sr_instance_code'
37190: ||' AND NVL(mlid.char2,'||''''||NULL_CHAR||''''||') '

Line 37213: UPDATE msc_st_sales_orders

37209:
37210: IF c4%ROWCOUNT > 0 THEN
37211: v_sql_stmt := 15.1;
37212: FORALL j IN lb_rowid.FIRST..lb_rowid.LAST
37213: UPDATE msc_st_sales_orders
37214: SET ship_set_id = msc_st_set_id_s.NEXTVAL
37215: WHERE rowid = lb_rowid(j)
37216: AND ship_set_id is null;
37217:

Line 37250: FROM msc_st_sales_orders

37246: v_current_date,
37247: v_current_user,
37248: v_current_date,
37249: v_current_user
37250: FROM msc_st_sales_orders
37251: WHERE rowid = lb_rowid(j);
37252:
37253: END IF;
37254: CLOSE c4;

Line 37260: 'UPDATE msc_st_sales_orders mso '

37256: -- Update ship_set_id
37257:
37258: v_sql_stmt := 15.4;
37259: lv_sql_stmt :=
37260: 'UPDATE msc_st_sales_orders mso '
37261: ||' SET ship_set_id = (SELECT local_id'
37262: ||' FROM msc_local_id_demand mlid'
37263: ||' WHERE mlid.char1 = mso.sr_instance_code'
37264: ||' AND NVL(mlid.char2,'||''''||NULL_CHAR||''''||') '

Line 37288: 'UPDATE msc_st_sales_orders mso '

37284:
37285: v_sql_stmt := 16;
37286:
37287: lv_sql_stmt :=
37288: 'UPDATE msc_st_sales_orders mso '
37289: ||' SET arrival_set_id = (SELECT local_id'
37290: ||' FROM msc_local_id_demand mlid'
37291: ||' WHERE mlid.char1 = mso.sr_instance_code'
37292: ||' AND NVL(mlid.char2,'||''''||NULL_CHAR||''''||') '

Line 37315: UPDATE msc_st_sales_orders

37311:
37312: IF c5%ROWCOUNT > 0 THEN
37313: v_sql_stmt := 16.1;
37314: FORALL j IN lb_rowid.FIRST..lb_rowid.LAST
37315: UPDATE msc_st_sales_orders
37316: SET arrival_set_id = msc_st_set_id_s.NEXTVAL
37317: WHERE rowid = lb_rowid(j)
37318: AND arrival_set_id is null;
37319:

Line 37352: FROM msc_st_sales_orders

37348: v_current_date,
37349: v_current_user,
37350: v_current_date,
37351: v_current_user
37352: FROM msc_st_sales_orders
37353: WHERE rowid = lb_rowid(j);
37354:
37355: END IF;
37356: CLOSE c5;

Line 37362: 'UPDATE msc_st_sales_orders mso '

37358: -- Update arrival_set_id
37359:
37360: v_sql_stmt := 16.4;
37361: lv_sql_stmt :=
37362: 'UPDATE msc_st_sales_orders mso '
37363: ||' SET arrival_set_id = (SELECT local_id'
37364: ||' FROM msc_local_id_demand mlid'
37365: ||' WHERE mlid.char1 = mso.sr_instance_code'
37366: ||' AND NVL(mlid.char2,'||''''||NULL_CHAR||''''||') '

Line 37388: 'UPDATE msc_st_sales_orders mso '

37384: -- populate row_type
37385:
37386: v_sql_stmt := 17;
37387: lv_sql_stmt :=
37388: 'UPDATE msc_st_sales_orders mso '
37389: ||' SET ROW_TYPE= decode(reservation_type,1,decode(AVAILABLE_TO_MRP,''N'',''3'',''1'')
37390: ,2,1
37391: ,3,1
37392: ,NULL)' -- resv tp already validated for 1,2,3 so this decode should never return NULL.

Line 37403: (p_table_name => 'MSC_ST_SALES_ORDERS',

37399:
37400: EXECUTE IMMEDIATE lv_sql_stmt USING p_batch_id,v_instance_code;
37401:
37402: lv_return := MSC_ST_UTIL.SET_PROCESS_FLAG
37403: (p_table_name => 'MSC_ST_SALES_ORDERS',
37404: p_instance_id => v_instance_id,
37405: p_instance_code => v_instance_code,
37406: p_process_flag => G_VALID,
37407: p_error_text => lv_error_text,

Line 37416: (p_table_name => 'MSC_ST_SALES_ORDERS',

37412: RAISE ex_logging_err;
37413: END IF;
37414:
37415: lv_return := MSC_ST_UTIL.LOG_ERROR
37416: (p_table_name => 'MSC_ST_SALES_ORDERS',
37417: p_instance_code => v_instance_code,
37418: p_row => lv_column_names,
37419: p_severity => G_SEV_ERROR,
37420: p_message_text => NULL,

Line 54741: 'UPDATE msc_st_sales_orders mso1'

54737:
54738: v_sql_stmt := 13;
54739:
54740: lv_sql_stmt :=
54741: 'UPDATE msc_st_sales_orders mso1'
54742: ||' SET process_flag = '||G_ERROR_FLG||','
54743: ||' error_text = '||''''||lv_message_text||''''
54744: ||' WHERE message_id < (SELECT MAX(message_id)'
54745: ||' FROM msc_st_sales_orders mso2'

Line 54745: ||' FROM msc_st_sales_orders mso2'

54741: 'UPDATE msc_st_sales_orders mso1'
54742: ||' SET process_flag = '||G_ERROR_FLG||','
54743: ||' error_text = '||''''||lv_message_text||''''
54744: ||' WHERE message_id < (SELECT MAX(message_id)'
54745: ||' FROM msc_st_sales_orders mso2'
54746: ||' WHERE mso2.sr_instance_code '
54747: ||' = mso1.sr_instance_code '
54748: ||' AND mso2.sales_order_number '
54749: ||' = mso1.sales_order_number '

Line 54787: 'UPDATE msc_st_sales_orders mso1'

54783:
54784: v_sql_stmt := 14;
54785:
54786: lv_sql_stmt :=
54787: 'UPDATE msc_st_sales_orders mso1'
54788: ||' SET process_flag = '||G_ERROR_FLG||','
54789: ||' error_text = '||''''||lv_message_text||''''
54790: ||' WHERE EXISTS( SELECT 1 '
54791: ||' FROM msc_st_sales_orders mso2'

Line 54791: ||' FROM msc_st_sales_orders mso2'

54787: 'UPDATE msc_st_sales_orders mso1'
54788: ||' SET process_flag = '||G_ERROR_FLG||','
54789: ||' error_text = '||''''||lv_message_text||''''
54790: ||' WHERE EXISTS( SELECT 1 '
54791: ||' FROM msc_st_sales_orders mso2'
54792: ||' WHERE mso2.sr_instance_code '
54793: ||' = mso1.sr_instance_code '
54794: ||' AND mso2.sales_order_number '
54795: ||' = mso1.sales_order_number '

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

55744: prec.wip_flag:= SYS_YES;
55745: prec.internal_repair_flag:=SYS_YES;
55746: prec.external_repair_flag:=SYS_YES;
55747: End IF;
55748: lv_count:= SET_IN_PROCESS (p_table_name => 'MSC_ST_SALES_ORDERS ',p_erp_enabled => 'Y');
55749: IF lv_count > 0 Then
55750: prec.sales_order_flag:= SYS_YES;
55751: End IF;
55752: END IF;

Line 59109: cursor c2 is SELECT rowid FROM msc_st_sales_orders

59105: lb_batch NumTblTyp := NumTblTyp(0);
59106: lv_batch_id PLS_INTEGER;
59107: lv_batch_start PLS_INTEGER;
59108: lv_batch_last PLS_INTEGER;
59109: cursor c2 is SELECT rowid FROM msc_st_sales_orders
59110: WHERE PROCESS_FLAG IN (G_IN_PROCESS,G_ERROR_FLG)
59111: AND NVL(batch_id,NULL_VALUE) = NULL_VALUE
59112: AND sr_instance_code = v_instance_code;
59113:

Line 59137: UPDATE msc_st_sales_orders

59133:
59134: lv_batch_last := lv_batch_id;
59135:
59136: FORALL j IN lb_rowid.FIRST..lb_rowid.LAST
59137: UPDATE msc_st_sales_orders
59138: SET batch_id = lb_batch(j)
59139: WHERE rowid = lb_rowid(j);
59140:
59141: commit;