APPS.MSD_APPLY_TEMPLATE_DEMAND_PLAN dependencies on MSD_DP_FORMULAS

Line 446: update msd_dp_formulas mdf

442:
443:
444: -- replace formula name with ID
445:
446: update msd_dp_formulas mdf
447:
448: set upload_formula_id = (select formula_id from msd_dp_formulas mdf1
449:
450: where mdf1.demand_plan_id = p_new_dp_id

Line 448: set upload_formula_id = (select formula_id from msd_dp_formulas mdf1

444: -- replace formula name with ID
445:
446: update msd_dp_formulas mdf
447:
448: set upload_formula_id = (select formula_id from msd_dp_formulas mdf1
449:
450: where mdf1.demand_plan_id = p_new_dp_id
451:
452: and mdf1.formula_name = mdf.upload_formula_id)

Line 821: from msd_dp_formulas

817: cursor c2 is
818:
819: select formula_name,formula_id
820:
821: from msd_dp_formulas
822:
823: where demand_plan_id = p_demand_plan_id;
824:
825:

Line 831: from msd_dp_formulas

827: cursor c3(p_template_id in number, p_formula_name in varchar2) is
828:
829: select equation, custom_field1, custom_field2, isby, numerator, denominator
830:
831: from msd_dp_formulas
832:
833: where demand_plan_id = p_template_id
834:
835: and formula_name = p_formula_name;

Line 883: update msd_dp_formulas

879:
880:
881: -- update equation, custom_field1, isby, numerator and denominator for the formula in plan with the corresponding formula in template
882:
883: update msd_dp_formulas
884:
885: set equation = l_equation,
886:
887: custom_field1 = l_custom_field1,

Line 1676: from msd_dp_formulas

1672: cursor c1 is
1673:
1674: select formula_name, formula_desc, formula_id
1675:
1676: from msd_dp_formulas
1677:
1678: where demand_plan_id = p_new_dp_id
1679:
1680: order by creation_sequence;

Line 1710: update msd_dp_formulas

1706:
1707:
1708: -- update the description seeded as message with message text
1709:
1710: update msd_dp_formulas
1711:
1712: --set formula_desc = fnd_message.get
1713:
1714: set formula_desc = fnd_message.get_string('MSD',c1_cur.formula_desc)

Line 1780: from msd_dp_formulas

1776: cursor c1 is
1777:
1778: select formula_id
1779:
1780: from msd_dp_formulas
1781:
1782: where demand_plan_id = p_new_dp_id
1783:
1784: order by creation_sequence;

Line 1848: update msd_dp_formulas

1844:
1845:
1846: -- update the names with IDS
1847:
1848: update msd_dp_formulas
1849:
1850: set custom_field1 = replace(custom_field1,'%'||c2_cur.parameter_sequence||'%', l_parameter_value),
1851:
1852: custom_field2 = replace(custom_field2,'%'||c2_cur.parameter_sequence||'%', l_parameter_value),

Line 2370: update msd_dp_formulas

2366:
2367:
2368: -- Set all formulas to valid first
2369:
2370: update msd_dp_formulas
2371:
2372: set valid_flag = 'Y'
2373:
2374: where demand_plan_id = p_new_dp_id;

Line 2382: update msd_dp_formulas

2378: -- invalidate the formula if any of the mandatory parameter is disabled
2379:
2380: for c1_cur in c1 loop
2381:
2382: update msd_dp_formulas
2383:
2384: set valid_flag = 'N'
2385:
2386: where demand_plan_id = p_new_dp_id

Line 5978: from msd_dp_formulas

5974: ,FORMAT /* ADDED NEW COLUMN FOR THE BUG#4373422 */
5975:
5976: ,START_PERIOD /* ADDED NEW COLUMN FOR THE BUG#4744717 */
5977:
5978: from msd_dp_formulas
5979:
5980: where demand_plan_id =
5981:
5982: (select demand_plan_id

Line 6021: update msd_dp_formulas

6017: if p_supply_plan_id is not null then
6018:
6019:
6020:
6021: update msd_dp_formulas
6022:
6023: set supply_plan_name = p_supply_plan_name -- Bug 4729854
6024:
6025: where demand_plan_id = p_new_dp_id

Line 6047: delete from msd_dp_formulas

6043: else
6044:
6045:
6046:
6047: delete from msd_dp_formulas
6048:
6049: where demand_plan_id = p_new_dp_id
6050:
6051: and supply_plan_name = p_old_supply_plan_name; -- Bug 4729854

Line 6079: insert into msd_dp_formulas

6075: select msd_dp_parameters_s.nextval into l_formula_id from dual;
6076:
6077:
6078:
6079: insert into msd_dp_formulas
6080:
6081: (
6082:
6083: demand_plan_id

Line 7374: from msd_dp_formulas

7370: cursor c1 is
7371:
7372: select formula_id
7373:
7374: from msd_dp_formulas
7375:
7376: where demand_plan_id = p_demand_plan_id
7377:
7378: and formula_name = p_formula_name