APPS.MRP_SELECT_ALL_FOR_RELEASE_PUB dependencies on MRP_SUGG_REP_SCHEDULES

Line 66: | mrp_sugg_rep_schedules. |

62:
63: /* --------------------------------------------------+
64: | Call function to select rows which will be included|
65: | for update in mrp_recommendations and |
66: | mrp_sugg_rep_schedules. |
67: +----------------------------------------------------*/
68:
69: l_no_rec_rows := select_rec_rows(l_where_clause);
70: l_no_rep_rows := select_rep_rows(l_where_clause);

Line 104: | Process rows in mrp_sugg_rep_schedules |

100:
101: end if;
102:
103: /*---------------------------------------------------+
104: | Process rows in mrp_sugg_rep_schedules |
105: +----------------------------------------------------*/
106:
107: if(l_no_rep_rows > 0) then
108:

Line 118: | Update Attributes in MRP_SUGG_REP_SCHEDULES |

114:
115:
116:
117: /*---------------------------------------------------+
118: | Update Attributes in MRP_SUGG_REP_SCHEDULES |
119: +----------------------------------------------------*/
120:
121: update_rep_attrib(l_demand_class);
122:

Line 326: update mrp_sugg_rep_schedules

322: /*-----------------------------------------------------+
323: | Set All Old Error messages to Null. |
324: +------------------------------------------------------*/
325:
326: update mrp_sugg_rep_schedules
327: set release_errors = NULL
328: where rowid IN
329: (SELECT char1 from mrp_form_query
330: where

Line 341: update mrp_sugg_rep_schedules msrs

337: +--------------------------------------------------- --*/
338:
339: l_mesg_str := FND_MESSAGE.GET_STRING('MRP', 'MRP_REL_ALL_MODEL');
340:
341: update mrp_sugg_rep_schedules msrs
342: set release_errors = l_mesg_str
343: where rowid IN
344: (SELECT char1 from mrp_form_query
345: where

Line 362: update mrp_sugg_rep_schedules msrs

358: +---------------------------------------------------------------*/
359:
360: l_mesg_str := FND_MESSAGE.GET_STRING('MRP', 'MRP_REL_ALL_CUST_SUPP');
361:
362: update mrp_sugg_rep_schedules msrs
363: set release_errors = release_errors||l_mesg_str
364: where rowid IN
365: (SELECT char1 from mrp_form_query
366: where

Line 380: update mrp_sugg_rep_schedules msrs

376:
377: l_mesg_str := FND_MESSAGE.GET_STRING('MRP',
378: 'MRP_REL_ALL_IN_SOURCE_PLAN');
379:
380: update mrp_sugg_rep_schedules msrs
381: set release_errors = release_errors||l_mesg_str
382: where rowid IN
383: (SELECT char1 from mrp_form_query
384: where

Line 466: * mrp_sugg_rep_schedules. *

462: /******************************************************************
463: * This function inserts rows in mrp_form_query for all the *
464: * transaction id of the records which need to be selected for *
465: * release. This is done for records in table *
466: * mrp_sugg_rep_schedules. *
467: ******************************************************************/
468:
469: FUNCTION Select_Rep_Rows(p_where_clause IN VARCHAR2) return NUMBER
470: IS

Line 502: ' from mrp_sugg_rep_schedules mr' ||

498: 'TRUNC(SYSDATE), '||
499: '-1, ' ||
500: 'mr.transaction_id ,'||
501: 'mr.rowid ' ||
502: ' from mrp_sugg_rep_schedules mr' ||
503: ' where rowid IN ' ||
504: '(SELECT row_id from mrp_orders_sc_v ' ||
505: ' where ' ||
506: l_where_clause ||

Line 1015: update mrp_sugg_rep_schedules msrs

1011: | implement_date release_status |
1012: | implement_daily_rate implement_demand_class |
1013: | implement_line_id |
1014: +------------------------------------------------------*/
1015: update mrp_sugg_rep_schedules msrs
1016: SET implement_date = nvl(msrs.implement_date,
1017: msrs.last_unit_completion_date),
1018: implement_daily_rate = nvl(msrs.implement_daily_rate,
1019: msrs.daily_rate),

Line 1048: update mrp_sugg_rep_schedules msrs

1044:
1045:
1046: l_mesg_str := FND_MESSAGE.GET_STRING('MRP', 'MRP_REL_ALL_IMPL_DATE');
1047:
1048: update mrp_sugg_rep_schedules msrs
1049: set release_errors = release_errors || l_mesg_str,
1050: release_status = 2
1051: where rowid IN
1052: (SELECT char1 from mrp_form_query

Line 1062: update mrp_sugg_rep_schedules msrs

1058: /*-------------------------------------------------------------+
1059: | update load_type
1060: +--------------------------------------------------------------*/
1061:
1062: update mrp_sugg_rep_schedules msrs
1063: SET
1064: load_type=2
1065: where rowid IN
1066: (SELECT char1 from mrp_form_query

Line 1076: UPDATE mrp_sugg_rep_schedules

1072: -- Bug 1783575(--bug2503086)
1073: -- Change color to pink and action to None after clicking
1074: -- select all for release
1075: -- 2797945
1076: UPDATE mrp_sugg_rep_schedules
1077: SET status = 1
1078: WHERE rowid IN
1079: (SELECT char1 from mrp_form_query
1080: where

Line 1091: * mrp_recommendations and mrp_sugg_rep_schedules. *

1087:
1088:
1089: /******************************************************************
1090: * Function to find number of records with release errors in *
1091: * mrp_recommendations and mrp_sugg_rep_schedules. *
1092: ******************************************************************/
1093:
1094: FUNCTION Count_Row_Errors return NUMBER IS
1095: l_rep_errors NUMBER;

Line 1119: from mrp_sugg_rep_schedules

1115: SELECT
1116: count(1)
1117: into
1118: l_rep_errors
1119: from mrp_sugg_rep_schedules
1120: where rowid IN
1121: (SELECT char1 from mrp_form_query
1122: where
1123: query_id = g_rep_query_id)