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_COMMON_UTILITIES

Line 1111: set start_date=msd_common_utilities.get_bucket_start_date(sysdate,1,6,'GREGORIAN'),

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;
1115:

Line 1112: end_date=msd_common_utilities.get_bucket_end_date(sysdate,1,6,'GREGORIAN')

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;
1115:
1116: update msd_dp_parameters

Line 1117: set start_date=msd_common_utilities.get_bucket_start_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',
1121: 'MSD_FORECAST_BASIS_LIAB','MSD_AUTHORIZATION','MSD_SUPPLY_COMMIT',

Line 1118: end_date=msd_common_utilities.get_bucket_end_date(sysdate,24,6,'GREGORIAN')

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',
1121: 'MSD_FORECAST_BASIS_LIAB','MSD_AUTHORIZATION','MSD_SUPPLY_COMMIT',
1122: 'MSD_SHORTAGE','MSD_FORECAST_LIABILITY','MSD_ESTIMATED_FORECAST_LIAB',

Line 1322: set start_date = msd_common_utilities.get_bucket_start_date(sysdate,-18,6,'GREGORIAN'),

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')
1325:
1326: where demand_plan_id = p_new_dp_id

Line 1324: end_date = msd_common_utilities.get_bucket_end_date(sysdate,1,6,'GREGORIAN')

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')
1325:
1326: where demand_plan_id = p_new_dp_id
1327:
1328: and (supply_plan_flag <> 'Y'

Line 1340: set history_start_date = msd_common_utilities.get_bucket_start_date(sysdate,-18,6,'GREGORIAN'),

1336: -- set the horizon start and end dates of scenarios to month start date of next month and end date of 19 months forwards respectively
1337:
1338: update msd_dp_scenarios
1339:
1340: set history_start_date = msd_common_utilities.get_bucket_start_date(sysdate,-18,6,'GREGORIAN'),
1341:
1342: history_end_date = msd_common_utilities.get_bucket_end_date(sysdate,1,6,'GREGORIAN'),
1343:
1344: horizon_start_date = msd_common_utilities.get_bucket_start_date(sysdate,2,6,'GREGORIAN'),

Line 1342: history_end_date = msd_common_utilities.get_bucket_end_date(sysdate,1,6,'GREGORIAN'),

1338: update msd_dp_scenarios
1339:
1340: set history_start_date = msd_common_utilities.get_bucket_start_date(sysdate,-18,6,'GREGORIAN'),
1341:
1342: history_end_date = msd_common_utilities.get_bucket_end_date(sysdate,1,6,'GREGORIAN'),
1343:
1344: horizon_start_date = msd_common_utilities.get_bucket_start_date(sysdate,2,6,'GREGORIAN'),
1345:
1346: horizon_end_date = msd_common_utilities.get_bucket_end_date(sysdate,19,6,'GREGORIAN')

Line 1344: horizon_start_date = msd_common_utilities.get_bucket_start_date(sysdate,2,6,'GREGORIAN'),

1340: set history_start_date = msd_common_utilities.get_bucket_start_date(sysdate,-18,6,'GREGORIAN'),
1341:
1342: history_end_date = msd_common_utilities.get_bucket_end_date(sysdate,1,6,'GREGORIAN'),
1343:
1344: horizon_start_date = msd_common_utilities.get_bucket_start_date(sysdate,2,6,'GREGORIAN'),
1345:
1346: horizon_end_date = msd_common_utilities.get_bucket_end_date(sysdate,19,6,'GREGORIAN')
1347:
1348: where demand_plan_id = p_new_dp_id;

Line 1346: horizon_end_date = msd_common_utilities.get_bucket_end_date(sysdate,19,6,'GREGORIAN')

1342: history_end_date = msd_common_utilities.get_bucket_end_date(sysdate,1,6,'GREGORIAN'),
1343:
1344: horizon_start_date = msd_common_utilities.get_bucket_start_date(sysdate,2,6,'GREGORIAN'),
1345:
1346: horizon_end_date = msd_common_utilities.get_bucket_end_date(sysdate,19,6,'GREGORIAN')
1347:
1348: where demand_plan_id = p_new_dp_id;
1349:
1350:

Line 1472: ,MSD_COMMON_UTILITIES_LB.get_default_mfg_cal ( l_org_id,l_instance_id)

1468: p_new_dp_id
1469:
1470: ,2
1471:
1472: ,MSD_COMMON_UTILITIES_LB.get_default_mfg_cal ( l_org_id,l_instance_id)
1473:
1474: ,SYSDATE
1475:
1476: ,fnd_global.user_id

Line 4538: l_start_date := msd_common_utilities.get_bucket_start_date(sysdate,c3_cur.selection_value,p_old_output_period_type_id,l_calendar_code);

4534: -- first value is the start bucket. get the start date for the old bucket and then get the new start bucket
4535:
4536: if c3_cur.selection_sequence = 1 then
4537:
4538: l_start_date := msd_common_utilities.get_bucket_start_date(sysdate,c3_cur.selection_value,p_old_output_period_type_id,l_calendar_code);
4539:
4540: l_new_selection_value := msd_common_utilities.get_age_in_buckets(l_start_date,sysdate,p_output_period_type_id,l_calendar_code);
4541:
4542: -- second value is the end bucket. get the end date for the old bucket and then get the new end bucket

Line 4540: l_new_selection_value := msd_common_utilities.get_age_in_buckets(l_start_date,sysdate,p_output_period_type_id,l_calendar_code);

4536: if c3_cur.selection_sequence = 1 then
4537:
4538: l_start_date := msd_common_utilities.get_bucket_start_date(sysdate,c3_cur.selection_value,p_old_output_period_type_id,l_calendar_code);
4539:
4540: l_new_selection_value := msd_common_utilities.get_age_in_buckets(l_start_date,sysdate,p_output_period_type_id,l_calendar_code);
4541:
4542: -- second value is the end bucket. get the end date for the old bucket and then get the new end bucket
4543:
4544: elsif c3_cur.selection_sequence = 2 then

Line 4546: l_end_date := msd_common_utilities.get_bucket_end_date(sysdate,c3_cur.selection_value,p_old_output_period_type_id,l_calendar_code);

4542: -- second value is the end bucket. get the end date for the old bucket and then get the new end bucket
4543:
4544: elsif c3_cur.selection_sequence = 2 then
4545:
4546: l_end_date := msd_common_utilities.get_bucket_end_date(sysdate,c3_cur.selection_value,p_old_output_period_type_id,l_calendar_code);
4547:
4548: l_new_selection_value := msd_common_utilities.get_age_in_buckets(sysdate,l_end_date,p_output_period_type_id,l_calendar_code);
4549:
4550: end if;

Line 4548: l_new_selection_value := msd_common_utilities.get_age_in_buckets(sysdate,l_end_date,p_output_period_type_id,l_calendar_code);

4544: elsif c3_cur.selection_sequence = 2 then
4545:
4546: l_end_date := msd_common_utilities.get_bucket_end_date(sysdate,c3_cur.selection_value,p_old_output_period_type_id,l_calendar_code);
4547:
4548: l_new_selection_value := msd_common_utilities.get_age_in_buckets(sysdate,l_end_date,p_output_period_type_id,l_calendar_code);
4549:
4550: end if;
4551:
4552:

Line 5339: ,decode(p_type.plan_type, 'SOP', msd_common_utilities.get_bucket_start_date(sysdate,2,6,'GREGORIAN'), null)

5335: ,l_description
5336:
5337: ,output_period_type
5338:
5339: ,decode(p_type.plan_type, 'SOP', msd_common_utilities.get_bucket_start_date(sysdate,2,6,'GREGORIAN'), null)
5340:
5341: ,decode(p_type.plan_type, 'SOP', msd_common_utilities.get_bucket_end_date(sysdate,19,6,'GREGORIAN'), null)
5342:
5343: ,forecast_date_used

Line 5341: ,decode(p_type.plan_type, 'SOP', msd_common_utilities.get_bucket_end_date(sysdate,19,6,'GREGORIAN'), null)

5337: ,output_period_type
5338:
5339: ,decode(p_type.plan_type, 'SOP', msd_common_utilities.get_bucket_start_date(sysdate,2,6,'GREGORIAN'), null)
5340:
5341: ,decode(p_type.plan_type, 'SOP', msd_common_utilities.get_bucket_end_date(sysdate,19,6,'GREGORIAN'), null)
5342:
5343: ,forecast_date_used
5344:
5345: ,forecast_based_on

Line 5401: ,decode(p_type.plan_type, 'SOP', msd_common_utilities.get_bucket_start_date(sysdate,-18,6,'GREGORIAN'), null)

5397: ,scenario_type
5398:
5399: ,status
5400:
5401: ,decode(p_type.plan_type, 'SOP', msd_common_utilities.get_bucket_start_date(sysdate,-18,6,'GREGORIAN'), null)
5402:
5403: ,decode(p_type.plan_type, 'SOP', msd_common_utilities.get_bucket_end_date(sysdate,1,6,'GREGORIAN'), null)
5404:
5405: ,publish_flag

Line 5403: ,decode(p_type.plan_type, 'SOP', msd_common_utilities.get_bucket_end_date(sysdate,1,6,'GREGORIAN'), null)

5399: ,status
5400:
5401: ,decode(p_type.plan_type, 'SOP', msd_common_utilities.get_bucket_start_date(sysdate,-18,6,'GREGORIAN'), null)
5402:
5403: ,decode(p_type.plan_type, 'SOP', msd_common_utilities.get_bucket_end_date(sysdate,1,6,'GREGORIAN'), null)
5404:
5405: ,publish_flag
5406:
5407: ,enable_flag

Line 7170: else l_start_date := msd_common_utilities.get_bucket_start_date(sysdate,2,6,'GREGORIAN'); -- Bug 4729854

7166: close c1;
7167:
7168:
7169:
7170: else l_start_date := msd_common_utilities.get_bucket_start_date(sysdate,2,6,'GREGORIAN'); -- Bug 4729854
7171:
7172:
7173:
7174: end if; -- Bug 4729854

Line 7236: else l_end_date := msd_common_utilities.get_bucket_end_date(sysdate,19,6,'GREGORIAN'); -- Bug 4729854

7232: fetch c1 into l_end_date;
7233:
7234: close c1;
7235:
7236: else l_end_date := msd_common_utilities.get_bucket_end_date(sysdate,19,6,'GREGORIAN'); -- Bug 4729854
7237:
7238: end if;
7239:
7240: if l_end_date is not null then