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_DP_FORMULA_PKG dependencies on MSD_DP_FORMULAS

Line 25: ,P_FORMAT in varchar2 /* Added a new coulumn in MSD_DP_FORMULAS table (Bug#4373422)*/

21: ,P_SUPPLY_PLAN_FLAG in varchar2
22: ,P_SUPPLY_PLAN_NAME in varchar2
23: ,P_UPLOAD_FORMULA_ID in varchar2
24: ,P_LAST_UPDATE_DATE in varchar2
25: ,P_FORMAT in varchar2 /* Added a new coulumn in MSD_DP_FORMULAS table (Bug#4373422)*/
26: ,P_START_PERIOD in varchar2 /* Added a new coulumn in MSD_DP_FORMULAS table (Bug#4744717)*/
27: ,P_CUSTOM_MODE in varchar2
28: )
29: is

Line 26: ,P_START_PERIOD in varchar2 /* Added a new coulumn in MSD_DP_FORMULAS table (Bug#4744717)*/

22: ,P_SUPPLY_PLAN_NAME in varchar2
23: ,P_UPLOAD_FORMULA_ID in varchar2
24: ,P_LAST_UPDATE_DATE in varchar2
25: ,P_FORMAT in varchar2 /* Added a new coulumn in MSD_DP_FORMULAS table (Bug#4373422)*/
26: ,P_START_PERIOD in varchar2 /* Added a new coulumn in MSD_DP_FORMULAS table (Bug#4744717)*/
27: ,P_CUSTOM_MODE in varchar2
28: )
29: is
30:

Line 57: from msd_dp_formulas

53: f_ludate := nvl(to_date(P_LAST_UPDATE_DATE, 'YYYY/MM/DD'), sysdate);
54: begin
55: select LAST_UPDATED_BY, LAST_UPDATE_DATE
56: into db_luby, db_ludate
57: from msd_dp_formulas
58: where DEMAND_PLAN_ID = l_demand_plan_id
59: and FORMULA_NAME = P_FORMULA_NAME;
60:
61: -- Test for customization and version

Line 65: update msd_dp_formulas

61: -- Test for customization and version
62: if (fnd_load_util.upload_test(f_luby, f_ludate, db_luby,
63: db_ludate, P_CUSTOM_MODE)) then
64: -- Update existing row
65: update msd_dp_formulas
66: set CREATION_SEQUENCE = P_CREATION_SEQUENCE
67: ,FORMULA_DESC = P_FORMULA_DESC
68: ,CUSTOM_TYPE = P_CUSTOM_TYPE
69: ,EQUATION = P_EQUATION

Line 82: ,format = P_FORMAT /* Added a new coulumn in MSD_DP_FORMULAS table (Bug#4373422)*/

78: ,SUPPLY_PLAN_FLAG = P_SUPPLY_PLAN_FLAG
79: ,SUPPLY_PLAN_NAME = P_SUPPLY_PLAN_NAME
80: ,UPLOAD_FORMULA_ID = P_UPLOAD_FORMULA_ID
81: ,last_update_date = f_ludate
82: ,format = P_FORMAT /* Added a new coulumn in MSD_DP_FORMULAS table (Bug#4373422)*/
83: ,last_updated_by = f_luby
84: ,last_update_login = 0
85: ,START_PERIOD=P_START_PERIOD /* Added a new coulumn in MSD_DP_FORMULAS table (Bug#4744717)*/
86: where demand_plan_id = l_demand_plan_id

Line 85: ,START_PERIOD=P_START_PERIOD /* Added a new coulumn in MSD_DP_FORMULAS table (Bug#4744717)*/

81: ,last_update_date = f_ludate
82: ,format = P_FORMAT /* Added a new coulumn in MSD_DP_FORMULAS table (Bug#4373422)*/
83: ,last_updated_by = f_luby
84: ,last_update_login = 0
85: ,START_PERIOD=P_START_PERIOD /* Added a new coulumn in MSD_DP_FORMULAS table (Bug#4744717)*/
86: where demand_plan_id = l_demand_plan_id
87: and formula_name = p_formula_name;
88:
89: end if;

Line 93: insert into msd_dp_formulas

89: end if;
90: exception
91: when no_data_found then
92: -- Record doesn't exist - insert in all cases
93: insert into msd_dp_formulas
94: (DEMAND_PLAN_ID
95: ,FORMULA_ID
96: ,FORMULA_NAME
97: ,CREATION_SEQUENCE

Line 115: ,FORMAT /* Added a new coulumn in MSD_DP_FORMULAS table (Bug#4373422)*/

111: ,UPLOAD_FORMULA_ID
112: ,CREATION_DATE
113: ,CREATED_BY
114: ,LAST_UPDATE_DATE
115: ,FORMAT /* Added a new coulumn in MSD_DP_FORMULAS table (Bug#4373422)*/
116: ,LAST_UPDATED_BY
117: ,LAST_UPDATE_LOGIN
118: ,START_PERIOD /* Added a new coulumn in MSD_DP_FORMULAS table (Bug#4744717)*/
119: )

Line 118: ,START_PERIOD /* Added a new coulumn in MSD_DP_FORMULAS table (Bug#4744717)*/

114: ,LAST_UPDATE_DATE
115: ,FORMAT /* Added a new coulumn in MSD_DP_FORMULAS table (Bug#4373422)*/
116: ,LAST_UPDATED_BY
117: ,LAST_UPDATE_LOGIN
118: ,START_PERIOD /* Added a new coulumn in MSD_DP_FORMULAS table (Bug#4744717)*/
119: )
120: values
121: (l_demand_plan_id
122: ,msd_dp_parameters_s.nextval

Line 142: ,P_FORMAT /* Added a new coulumn in MSD_DP_FORMULAS table (Bug#4373422)*/

138: ,P_UPLOAD_FORMULA_ID
139: ,f_ludate
140: ,f_luby
141: ,f_ludate
142: ,P_FORMAT /* Added a new coulumn in MSD_DP_FORMULAS table (Bug#4373422)*/
143: ,f_luby
144: ,0
145: ,P_START_PERIOD /* Added a new coulumn in MSD_DP_FORMULAS table (Bug#4744717)*/
146:

Line 145: ,P_START_PERIOD /* Added a new coulumn in MSD_DP_FORMULAS table (Bug#4744717)*/

141: ,f_ludate
142: ,P_FORMAT /* Added a new coulumn in MSD_DP_FORMULAS table (Bug#4373422)*/
143: ,f_luby
144: ,0
145: ,P_START_PERIOD /* Added a new coulumn in MSD_DP_FORMULAS table (Bug#4744717)*/
146:
147: );
148: end;
149: