APPS.MSC_SRP_PIPE SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 13

SELECT_DATA		constant number :=2;

Line: 50

REM #define OLP_SELECT_DATA 2
REM #define OLP_DELETING    3
REM #define OLP_REPLANNING  4
REM #define OLP_FLUSHING    5

REM /*
REM Currently, in DRP/ASCP UI (MSCFNSIM.pld), it has 4 timer
REM 1. start_olp_timer,which is started when CP is sbumit and before got OLP_READY code
REM 2. ready_olp_timer,which is started once engine return OLP_READY -- engine is ready for replan request
REM 3. planing_olp_timer,which is started once submit replan reqest
REM 3. stop_olp_times, which is started when stop command is sent
REM
REM The normal way to get the status from engine is to
REM 1. ping engine in outpipe  with comamnd=4
REM 2. read iputpipe to get engine return. Engine could return (6,7,8,9)

REM #OLP_Ready ==>100%
REM /* this procedure is called from java servlet once user click ok button in replan option window
REM in DRP/ASCP,planner could be in stage (started,ready,plan,error stage). user can only submit request
REM if it is in ready status. but in srp, there is only 1 menu for user, so ui code need to start cp(if
REM it is not currently started, submit replan request only after planner is in ready status)
REM
REM ping engine, if engine return the following code
REM #define OLP_READY   6   ===> replan is 100% finished. (??? is this true)
REM #define OLP_ERROR   9   ===> replan is 100% finished. with error. (milestone=Error,percentage=100%)
REM #define OLP_INFO    7   ===> show milestone=??, percentage=??
REM #define OLP_STARTED 8
REM */

/*this procedure is called by servlet periodically.
REM p_error_code =-1 -->pipe error
REM p_error_code =0  --> normal status
REM p_error_code =2  -->no planner
REM p_stage_code  --> return the stage code of the planner
REM p_pcnt  -->percentage of completion
*/

Procedure get_replan_progress(p_request_id in number,
			      p_outPipe in varchar2,
                              p_inPipe in varchar2,
			      p_error_code out nocopy number,
			      p_stage_code out nocopy number,
			      p_pcnt   out nocopy number) is

l_engine_ping_return_code  number;  -- (6.7.8.9)

Line: 161

	        p_stage_code:=SELECT_DATA;

Line: 314

       select request_id from Fnd_Concurrent_Requests
       where parent_request_Id = p_parent_req_id;