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.MSD_CL_PRE_PROCESS dependencies on MSD_ST_MFG_FORECAST

Line 3885: lv_batch_id msd_st_mfg_forecast.batch_id%TYPE;

3881: TYPE RowidTab IS TABLE OF ROWID INDEX BY BINARY_INTEGER;
3882: lb_rowid RowidTab;
3883: /* lb_rowid1 RowidTab; Bug3749959 */
3884: lv_sql_stmt VARCHAR2(4000);
3885: lv_batch_id msd_st_mfg_forecast.batch_id%TYPE;
3886: lv_my_company msc_companies.company_name%TYPE := GET_MY_COMPANY;
3887: lv_message_text msc_errors.error_text%TYPE;
3888: lv_error_text VARCHAR2(250);
3889: lv_debug BOOLEAN := msc_cl_pre_process.v_debug;

Line 3899: FROM msd_st_mfg_forecast

3895: lv_column_names VARCHAR2(5000);
3896:
3897: CURSOR c1(p_batch_id NUMBER)IS
3898: SELECT rowid
3899: FROM msd_st_mfg_forecast
3900: WHERE process_flag IN (G_IN_PROCESS,G_ERROR_FLG)
3901: AND sr_instance_code = p_instance_code
3902: AND batch_id = p_batch_id;
3903:

Line 3920: FROM msd_st_mfg_forecast

3916: lv_all_dcs_pk NUMBER :=0; --Bug 3749959
3917:
3918: CURSOR c2(p_batch_id NUMBER)IS --This cursor is used to fetch all records which doesn't have any level value for demand class dimension. --Bug 3749959
3919: SELECT rowid
3920: FROM msd_st_mfg_forecast
3921: WHERE process_flag IN (G_IN_PROCESS,G_ERROR_FLG)
3922: AND nvl(DEMAND_CLASS_LVL_VAL,'-1') = '-1'
3923: AND sr_instance_code = p_instance_code
3924: AND batch_id = p_batch_id;

Line 3967: UPDATE msd_st_mfg_forecast

3963: CLOSE c1;
3964:
3965: v_sql_stmt := 04;
3966: FORALL j IN lb_rowid.FIRST..lb_rowid.LAST
3967: UPDATE msd_st_mfg_forecast
3968: SET st_transaction_id = msd_st_mfg_forecast_s.NEXTVAL,
3969: last_update_date = lv_current_date,
3970: last_updated_by = lv_current_user,
3971: creation_date = lv_current_date,

Line 3968: SET st_transaction_id = msd_st_mfg_forecast_s.NEXTVAL,

3964:
3965: v_sql_stmt := 04;
3966: FORALL j IN lb_rowid.FIRST..lb_rowid.LAST
3967: UPDATE msd_st_mfg_forecast
3968: SET st_transaction_id = msd_st_mfg_forecast_s.NEXTVAL,
3969: last_update_date = lv_current_date,
3970: last_updated_by = lv_current_user,
3971: creation_date = lv_current_date,
3972: created_by = lv_current_user

Line 3988: UPDATE msd_st_mfg_forecast

3984: lv_all_dcs_desc := msd_sr_util.get_all_dcs_desc; --Calling fuction - msd_sr_util.get_all_dcs_desc, to fetch the level value 'All Demand Classes'
3985:
3986: v_sql_stmt := 05;
3987: FORALL j IN lb_rowid1.FIRST..lb_rowid1.LAST -- Update the demand class level value column with 'Other' as Demand Class Level Value.
3988: UPDATE msd_st_mfg_forecast
3989: SET DEMAND_CLASS_LVL_VAL = lv_other_desc --Using the value fetched from function - msd_sr_util.get_null_desc
3990: WHERE rowid = lb_rowid1(j);
3991:
3992:

Line 4178: (p_table_name => 'MSD_ST_MFG_FORECAST',

4174:
4175: -- Derive sr_item_pk from msd_st_level_values and msd_level_values
4176:
4177: lv_return := MSC_ST_UTIL.DERIVE_SR_PK
4178: (p_table_name => 'MSD_ST_MFG_FORECAST',
4179: p_column_name => 'ITEM',
4180: p_pk_col_name => 'SR_ITEM_PK',
4181: p_level_id => 1,
4182: p_instance_code => p_instance_code,

Line 4207: (p_table_name => 'MSD_ST_MFG_FORECAST',

4203:
4204: -- Derive sr_inv_org_pk from msd_st_level_values and msd_level_values
4205:
4206: lv_return := MSC_ST_UTIL.DERIVE_SR_PK
4207: (p_table_name => 'MSD_ST_MFG_FORECAST',
4208: p_column_name => 'INV_ORG',
4209: p_pk_col_name => 'SR_INV_ORG_PK',
4210: p_level_id => 7,
4211: p_instance_code => p_instance_code,

Line 4237: (p_table_name => 'MSD_ST_MFG_FORECAST',

4233:
4234: -- Derive sr_customer_pk from msd_st_level_values and msd_level_values
4235:
4236: lv_return := MSC_ST_UTIL.DERIVE_SR_PK
4237: (p_table_name => 'MSD_ST_MFG_FORECAST',
4238: p_column_name => 'CUSTOMER',
4239: p_pk_col_name => 'SR_CUSTOMER_PK',
4240: p_level_id => 15,
4241: p_instance_code => p_instance_code,

Line 4266: (p_table_name => 'MSD_ST_MFG_FORECAST',

4262: END IF;
4263: -- Derive sr_ship_to_loc_pk from msd_st_level_values and msd_level_values
4264:
4265: lv_return := MSC_ST_UTIL.DERIVE_SR_PK
4266: (p_table_name => 'MSD_ST_MFG_FORECAST',
4267: p_column_name => 'SHIP_TO_LOC',
4268: p_pk_col_name => 'SR_SHIP_TO_LOC_PK',
4269: p_level_id => 11,
4270: p_instance_code => p_instance_code,

Line 4296: (p_table_name => 'MSD_ST_MFG_FORECAST',

4292:
4293: -- Derive sr_sales_channel_pk from msd_st_level_values and msd_level_values
4294:
4295: lv_return := MSC_ST_UTIL.DERIVE_SR_PK
4296: (p_table_name => 'MSD_ST_MFG_FORECAST',
4297: p_column_name => 'SALES_CHANNEL',
4298: p_pk_col_name => 'SR_SALES_CHANNEL_PK',
4299: p_level_id => 27,
4300: p_instance_code => p_instance_code,

Line 4327: (p_table_name => 'MSD_ST_MFG_FORECAST',

4323:
4324: -- Derive sr_sales_channel_pk from msd_st_level_values and msd_level_values
4325:
4326: lv_return := MSC_ST_UTIL.DERIVE_SR_PK
4327: (p_table_name => 'MSD_ST_MFG_FORECAST',
4328: p_column_name => 'DEMAND_CLASS_LVL_VAL',
4329: p_pk_col_name => 'SR_DEMAND_CLASS_PK',
4330: p_level_id => 34,
4331: p_instance_code => p_instance_code,

Line 4360: (p_table_name => 'MSD_ST_MFG_FORECAST',

4356:
4357: -- Derive SR_USER_DEFINED2_LVL_PK
4358:
4359: lv_return := MSC_ST_UTIL.DERIVE_LEVEL_PK
4360: (p_table_name => 'MSD_ST_MFG_FORECAST',
4361: p_level_val_col => 'USER_DEFINED1',
4362: p_level_name_col => 'USER_DEFINED_LEVEL1',
4363: p_level_pk_col => 'SR_USER_DEFINED1_PK',
4364: p_instance_code => p_instance_code,

Line 4391: (p_table_name => 'MSD_ST_MFG_FORECAST',

4387:
4388: -- Derive SR_USER_DEFINED2_LVL_PK
4389:
4390: lv_return := MSC_ST_UTIL.DERIVE_LEVEL_PK
4391: (p_table_name => 'MSD_ST_MFG_FORECAST',
4392: p_level_val_col => 'USER_DEFINED2',
4393: p_level_name_col => 'USER_DEFINED_LEVEL2',
4394: p_level_pk_col => 'SR_USER_DEFINED2_PK',
4395: p_instance_code => p_instance_code,

Line 4421: 'UPDATE msd_st_mfg_forecast'

4417:
4418: -- Error out the record if forecast_designator is NULL
4419: v_sql_stmt := 08;
4420: lv_sql_stmt :=
4421: 'UPDATE msd_st_mfg_forecast'
4422: ||' SET process_flag = '||G_ERROR_FLG||','
4423: ||' error_text = '||''''||lv_message_text||''''
4424: ||' WHERE NVL(forecast_designator, '||''''||NULL_CHAR||''''||') '
4425: ||' = '||''''||NULL_CHAR||''''

Line 4452: 'UPDATE msd_st_mfg_forecast '

4448: END IF;
4449:
4450: v_sql_stmt := 08;
4451: lv_sql_Stmt:=
4452: 'UPDATE msd_st_mfg_forecast '
4453: ||' SET process_flag ='||G_ERROR_FLG||','
4454: ||' error_text = '||''''||lv_message_text||''''
4455: ||' WHERE NVL(forecast_date,(sysdate-36500)) = (sysdate-36500)'
4456: ||' AND process_flag ='|| G_IN_PROCESS

Line 4483: 'UPDATE msd_st_mfg_forecast'

4479: END IF;
4480:
4481: -- Original quantity should not be NULL
4482: lv_sql_stmt :=
4483: 'UPDATE msd_st_mfg_forecast'
4484: ||' SET process_flag = '||G_ERROR_FLG||','
4485: ||' error_text = '||''''||lv_message_text||''''
4486: ||' WHERE NVL(original_quantity,'||NULL_VALUE||')= '||NULL_VALUE
4487: ||' AND process_flag = '||G_IN_PROCESS

Line 4502: ' UPDATE msd_st_mfg_forecast'

4498: -- Current quantity should be defaulted to original quantitty of NULL
4499:
4500: v_sql_stmt := 08;
4501: lv_sql_stmt :=
4502: ' UPDATE msd_st_mfg_forecast'
4503: ||' SET current_quantity = original_quantity'
4504: ||' WHERE NVL(current_quantity,'||NULL_VALUE||')= '||NULL_VALUE
4505: ||' AND process_flag = '||G_IN_PROCESS
4506: ||' AND batch_id = :lv_batch_id'

Line 4521: ' UPDATE msd_st_mfg_forecast'

4517:
4518: -- BUCKET_TYPE value should be 1,2 or 3 if NULL default it to 1(daily)
4519: v_sql_stmt := 08;
4520: lv_sql_stmt :=
4521: ' UPDATE msd_st_mfg_forecast'
4522: ||' SET bucket_type = '||G_BUCKET_TYPE
4523: ||' WHERE NVL(bucket_type,'||NULL_VALUE||') NOT IN(1,2,3)'
4524: ||' AND process_flag = '||G_IN_PROCESS
4525: ||' AND batch_id = :lv_batch_id'

Line 4555: p_token_value3 => 'MSD_ST_MFG_FORECAST');

4551: ||' AND ITEM.MRP_PLANNING_CODE',
4552: p_token2 => 'MASTER_TABLE',
4553: p_token_value2 => 'MSC_SYSTEM_ITEMS',
4554: p_token3 => 'CHILD_TABLE',
4555: p_token_value3 => 'MSD_ST_MFG_FORECAST');
4556:
4557: IF lv_return <> 0 THEN
4558: RAISE ex_logging_err;
4559: END IF;

Line 4564: UPDATE msd_st_mfg_forecast mmf

4560:
4561: -- Validate item-org combination
4562: v_sql_stmt := 15;
4563:
4564: UPDATE msd_st_mfg_forecast mmf
4565: SET process_flag = G_ERROR_FLG,
4566: error_text = lv_message_text
4567: WHERE NOT EXISTS(SELECT 1
4568: FROM msc_st_system_items msi

Line 4596: pEntityName => 'MSD_ST_MFG_FORECAST',

4592: (ERRBUF => lv_error_text,
4593: RETCODE => lv_return,
4594: pBatchID => lv_batch_id,
4595: pInstanceCode => p_instance_code,
4596: pEntityName => 'MSD_ST_MFG_FORECAST',
4597: pInstanceID => p_instance_id);
4598:
4599: IF NVL(lv_return,0) <> 0 THEN
4600: RAISE ex_logging_err;

Line 4605: (p_table_name => 'MSD_ST_MFG_FORECAST',

4601: END IF;
4602:
4603: -- Set the process flag as Valid and populate instance_id
4604: lv_return := MSC_ST_UTIL.SET_PROCESS_FLAG
4605: (p_table_name => 'MSD_ST_MFG_FORECAST',
4606: p_instance_id => p_instance_id,
4607: p_instance_code => p_instance_code,
4608: p_process_flag => G_VALID,
4609: p_error_text => lv_error_text,

Line 4621: (p_table_name => 'MSD_ST_MFG_FORECAST',

4617:
4618: -- Inserting all the errored out records into MSC_ERRORS:
4619:
4620: lv_return := MSC_ST_UTIL.LOG_ERROR
4621: (p_table_name => 'MSD_ST_MFG_FORECAST',
4622: p_instance_code => p_instance_code,
4623: p_row => lv_column_names,
4624: p_severity => G_SEV_ERROR,
4625: p_error_text => lv_error_text,