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_APPLY_TEMPLATE_DEMAND_PLAN dependencies on MSD_DP_PARAMETERS

Line 384: update msd_dp_parameters

380: -- Update Dates of the input parameters
381:
382: -- set the start date and end date for input parameters having time data
383:
384: update msd_dp_parameters
385:
386: set start_date = p_plan_start_date,
387:
388: end_date = p_plan_end_date

Line 402: update msd_dp_parameters

398:
399:
400: -- set the parameter name to supply plan name for input parameters
401:
402: update msd_dp_parameters
403:
404: set parameter_name = p_supply_plan_name
405:
406: where demand_plan_id = p_new_dp_id;

Line 1021: from msd_dp_parameters

1017: as
1018:
1019: cursor c1 is
1020: select parameter_id
1021: from msd_dp_parameters
1022: where demand_plan_id=p_demand_plan_id
1023: and stream_type='CALCULATED';
1024:
1025: cursor c2(p_parameter_id number) is

Line 1034: from msd_dp_parameters

1030: order by parameter_sequence;
1031:
1032: cursor c3(p_demand_plan_id number) is
1033: select parameter_type,parameter_id
1034: from msd_dp_parameters
1035: where demand_plan_id=p_demand_plan_id;
1036:
1037: cursor c4(p_demand_plan_id number) is
1038: select parameter_id

Line 1039: from msd_dp_parameters

1035: where demand_plan_id=p_demand_plan_id;
1036:
1037: cursor c4(p_demand_plan_id number) is
1038: select parameter_id
1039: from msd_dp_parameters
1040: where demand_plan_id=p_demand_plan_id
1041: and post_calculation is not null;
1042:
1043: l_parameter_value varchar2(4000);

Line 1057: update msd_dp_parameters

1053: else
1054: l_parameter_value := c2_rec.parameter_value;
1055: end if;
1056:
1057: update msd_dp_parameters
1058: set equation = replace(equation,'%'||c2_rec.parameter_sequence||'%', l_parameter_value)
1059: where demand_plan_id = p_demand_plan_id
1060: and parameter_id = c1_rec.parameter_id;
1061:

Line 1069: update msd_dp_parameters

1065: for c3_rec in c3(p_demand_plan_id)
1066: loop
1067: for c4_rec in c4(p_demand_plan_id)
1068: loop
1069: update msd_dp_parameters
1070: set post_calculation=replace(post_calculation,c3_rec.parameter_type,c3_rec.parameter_id)
1071: where demand_plan_id=p_demand_plan_id
1072: and parameter_id=c4_rec.parameter_id;
1073: end loop;

Line 1110: update msd_dp_parameters

1106: close c1;
1107:
1108: if p_plan_type = 'EOL' then
1109:
1110: update msd_dp_parameters
1111: set start_date=msd_common_utilities.get_bucket_start_date(sysdate,1,6,'GREGORIAN'),
1112: end_date=msd_common_utilities.get_bucket_end_date(sysdate,1,6,'GREGORIAN')
1113: where parameter_type in ('MSD_ON_HAND')
1114: and demand_plan_id=p_demand_plan_id;

Line 1116: update msd_dp_parameters

1112: end_date=msd_common_utilities.get_bucket_end_date(sysdate,1,6,'GREGORIAN')
1113: where parameter_type in ('MSD_ON_HAND')
1114: and demand_plan_id=p_demand_plan_id;
1115:
1116: update msd_dp_parameters
1117: set start_date=msd_common_utilities.get_bucket_start_date(sysdate,1,6,'GREGORIAN'),
1118: end_date=msd_common_utilities.get_bucket_end_date(sysdate,24,6,'GREGORIAN')
1119: where parameter_type in ('MSD_GROSS_REQ_EXCESS_HORIZON','MSD_INTRANSIT','MSD_ONORDER',
1120: 'MSD_GROSS_REQ_OBS_DATE','MSD_TOTAL_SUPPLY','MSD_ORDER_FORECAST',

Line 1191: /*update msd_dp_parameters set allo_agg_basis_stream_id = (select parameter_id

1187:
1188: -- Update the start and end dates for the parameters
1189: update_parameter_dates(p_new_dp_id);
1190: /* Bug 5169157 */
1191: /*update msd_dp_parameters set allo_agg_basis_stream_id = (select parameter_id
1192: from msd_dp_parameters
1193: where demand_plan_id=p_new_dp_id
1194: and parameter_type='MSD_FORECAST_BASIS_LIAB')
1195: where demand_plan_id=p_new_dp_id

Line 1192: from msd_dp_parameters

1188: -- Update the start and end dates for the parameters
1189: update_parameter_dates(p_new_dp_id);
1190: /* Bug 5169157 */
1191: /*update msd_dp_parameters set allo_agg_basis_stream_id = (select parameter_id
1192: from msd_dp_parameters
1193: where demand_plan_id=p_new_dp_id
1194: and parameter_type='MSD_FORECAST_BASIS_LIAB')
1195: where demand_plan_id=p_new_dp_id
1196: and parameter_type='MSD_SIM_END_ITEM_DEMAND'; */

Line 1199: update msd_dp_parameters

1195: where demand_plan_id=p_new_dp_id
1196: and parameter_type='MSD_SIM_END_ITEM_DEMAND'; */
1197:
1198: fnd_message.set_name('MSD','MSD_SIM_DEMAND_DEP_DEM_DESC');
1199: update msd_dp_parameters
1200: set dependent_demand_desc = fnd_message.get
1201: where demand_plan_id=p_new_dp_id
1202: and parameter_type='MSD_SIM_END_ITEM_DEMAND';
1203:

Line 1220: from msd_dp_parameters

1216: Procedure replace_associate_parameters(p_new_dp_id in number)
1217: is
1218: cursor c1(p_parameter_type varchar2) is
1219: select parameter_id
1220: from msd_dp_parameters
1221: where demand_plan_id=p_new_dp_id
1222: and parameter_type=p_parameter_type;
1223:
1224: cursor c2 is

Line 1320: update msd_dp_parameters

1316:
1317:
1318: -- set the start and end dates of input parameters to month start date of 18 months backwards and current month end date respectively
1319:
1320: update msd_dp_parameters
1321:
1322: set start_date = msd_common_utilities.get_bucket_start_date(sysdate,-18,6,'GREGORIAN'),
1323:
1324: end_date = msd_common_utilities.get_bucket_end_date(sysdate,1,6,'GREGORIAN')

Line 1542: from msd_dp_parameters

1538: cursor c2 is
1539:
1540: select parameter_id, price_list_name
1541:
1542: from msd_dp_parameters
1543:
1544: where demand_plan_id = p_new_dp_id
1545:
1546: and price_list_name is not null;

Line 1584: update msd_dp_parameters

1580:
1581:
1582: -- replace message with text
1583:
1584: update msd_dp_parameters
1585:
1586: set price_list_name = fnd_message.get_string('MSD',c2_cur.price_list_name)
1587:
1588: where demand_plan_id = p_new_dp_id

Line 2730: msd_dp_parameters mdp

2726: cursor c2 is
2727:
2728: select distinct document_id
2729: from msd_dp_doc_dim_selections mdds,
2730: msd_dp_parameters mdp
2731: where mdds.demand_plan_id = p_new_dp_id
2732: and mdp.demand_plan_id=p_new_dp_id
2733: and mdp.parameter_type=mdds.selection_value
2734: and nvl(mdp.parameter_name,'ABCD')=nvl(mdds.supply_plan_name,'ABCD')

Line 3014: from msd_dp_parameters

3010: cursor c1 is
3011:
3012: select parameter_type, parameter_name
3013:
3014: from msd_dp_parameters
3015:
3016: where demand_plan_id = p_demand_plan_id
3017:
3018: and parameter_id = p_parameter_id;

Line 3174: delete from msd_dp_parameters

3170: if l_supply_plan_name is not null then
3171:
3172:
3173:
3174: delete from msd_dp_parameters
3175:
3176: where demand_plan_id = p_demand_plan_id
3177:
3178: and parameter_name = l_supply_plan_name;

Line 5691: update msd_dp_parameters

5687: if p_supply_plan_id is not null then
5688:
5689:
5690:
5691: update msd_dp_parameters
5692:
5693: set parameter_name = p_supply_plan_name, -- Bug 4729854
5694:
5695: --Bug 4549059

Line 5711: delete from msd_dp_parameters

5707: -- delete if ascp plan is detached
5708:
5709: else
5710:
5711: delete from msd_dp_parameters
5712:
5713: where demand_plan_id = p_new_dp_id
5714:
5715: and parameter_name = p_old_supply_plan_name; -- Bug 4729854

Line 5727: insert into msd_dp_parameters

5723: elsif p_supply_plan_id is not null then
5724:
5725:
5726:
5727: insert into msd_dp_parameters
5728:
5729: (
5730:
5731: demand_plan_id

Line 5810: ,msd_dp_parameters_s.nextval

5806: (select
5807:
5808: p_new_dp_id
5809:
5810: ,msd_dp_parameters_s.nextval
5811:
5812: ,parameter_type
5813:
5814: ,p_supply_plan_name -- Bug 4729854

Line 5884: from msd_dp_parameters,

5880: ,calculated_order
5881: ,post_calculation
5882: ,price_list_name
5883:
5884: from msd_dp_parameters,
5885:
5886: (select nvl(plan_type,'DP') plan_type from msd_demand_plans where demand_plan_id=p_new_dp_id) p_type
5887:
5888: where supply_plan_flag = 'Y'

Line 6075: select msd_dp_parameters_s.nextval into l_formula_id from dual;

6071: for c1_cur in c1 loop
6072:
6073:
6074:
6075: select msd_dp_parameters_s.nextval into l_formula_id from dual;
6076:
6077:
6078:
6079: insert into msd_dp_formulas

Line 6405: msd_dp_parameters mdp,

6401:
6402: ,SYSDATE
6403:
6404: from msd_dp_formula_parameters mdfp,
6405: msd_dp_parameters mdp,
6406: msd_dp_parameters mdp1
6407:
6408: where mdfp.demand_plan_id =
6409:

Line 6406: msd_dp_parameters mdp1

6402: ,SYSDATE
6403:
6404: from msd_dp_formula_parameters mdfp,
6405: msd_dp_parameters mdp,
6406: msd_dp_parameters mdp1
6407:
6408: where mdfp.demand_plan_id =
6409:
6410: (select demand_plan_id

Line 7284: from msd_dp_parameters

7280: cursor c1 is
7281:
7282: select parameter_id
7283:
7284: from msd_dp_parameters
7285:
7286: where demand_plan_id = p_demand_plan_id
7287:
7288: and parameter_type = p_parameter_type