APPS.MSC_SET_DEMAND_PRIORITY dependencies on MSC_DEMANDS

Line 17: DemandId MSC_DEMANDS.DEMAND_ID%TYPE;

13: criteria char3000_arr );
14:
15: v_DemandSort t_DemandSort;
16:
17: DemandId MSC_DEMANDS.DEMAND_ID%TYPE;
18:
19: TYPE RefCurType IS REF CURSOR;
20: cv RefCurType;
21:

Line 58: 'DECODE(MSC_DEMANDS.ORIGINATION_TYPE,

54: SELECT DECODE(MSR.meaning,
55: 'Gross Margin',
56: '-md.USING_REQUIREMENT_QUANTITY*md.SELLING_PRICE',
57: 'Sales Order Priority',
58: 'DECODE(MSC_DEMANDS.ORIGINATION_TYPE,
59: 6, NVL(md.SALES_ORDER_PRIORITY, 10000),
60: 7, NVL(md.FORECAST_PRIORITY, 100000),
61: 100000)',
62: 'Schedule Date',

Line 98: v_FromClause := 'FROM msc_demands md, msc_plan_schedules mp ';

94: /****************************************************/
95: /* Get the SELECT, FROM and WHERE clause */
96: /****************************************************/
97: v_SelectClause := 'SELECT demand_id ';
98: v_FromClause := 'FROM msc_demands md, msc_plan_schedules mp ';
99: v_WhereClause1 := 'WHERE md.SCHEDULE_DESIGNATOR_ID =
100: mp.INPUT_SCHEDULE_ID ';
101: v_WhereClause2 := 'AND mp.PLAN_ID = :arg_plan_id ';
102: v_WhereClause3 := 'AND md.PLAN_ID = -1 ';

Line 117: /* Update demand_priority in MSC_DEMANDS for this */

113: FETCH cv INTO DemandId;
114: EXIT WHEN cv%NOTFOUND;
115:
116: /****************************************************/
117: /* Update demand_priority in MSC_DEMANDS for this */
118: /* demand_id */
119: /****************************************************/
120: UPDATE msc_demands
121: SET DEMAND_PRIORITY = demand_priority

Line 120: UPDATE msc_demands

116: /****************************************************/
117: /* Update demand_priority in MSC_DEMANDS for this */
118: /* demand_id */
119: /****************************************************/
120: UPDATE msc_demands
121: SET DEMAND_PRIORITY = demand_priority
122: WHERE DEMAND_ID = DemandId
123: AND PLAN_ID = -1;
124:

Line 151: msc_demands end_dem,

147: SELECT NVL(MIN(end_dem.demand_priority),
148: 100000)
149: INTO p_dem_priority
150: FROM
151: msc_demands end_dem,
152: msc_full_pegging end_peg,
153: msc_full_pegging pegging,
154: msc_supplies sup
155: WHERE