APPS.GMDOPGAP_WF_PKG dependencies on GMD_STATUS_NEXT

Line 163: l_target_status GMD_STATUS_NEXT.TARGET_STATUS%TYPE;

159: P_where_clause VARCHAR2(100):= ' GMD_OPERATIONS_B.OPRN_ID='||l_OPERATION_ID; -- Where clause to be appended
160: p_role GMA_ACTDATA_WF.ROLE%TYPE;
161: l_data_string VARCHAR2(2000);
162: l_delimiter VARCHAR2(15) := FND_PROFILE.VALUE ('SY$WF_DELIMITER');
163: l_target_status GMD_STATUS_NEXT.TARGET_STATUS%TYPE;
164: BEGIN
165:
166: IF (p_funcmode = 'RUN') THEN
167: gma_wfstd_p.WF_GET_CONTORL_PARAMS(P_LAB_WF_ITEM_TYPE,

Line 242: l_target_status GMD_STATUS_NEXT.TARGET_STATUS%TYPE;

238: p_itemkey IN VARCHAR2,
239: p_actid IN NUMBER,
240: p_funcmode IN VARCHAR2,
241: p_resultout OUT NOCOPY VARCHAR2) IS
242: l_target_status GMD_STATUS_NEXT.TARGET_STATUS%TYPE;
243: l_operation_id GMD_OPERATIONS_B.oprn_id%TYPE:=to_number(wf_engine.getitemattrtext(p_itemtype, p_itemkey,'GMDOPGAP_OPERATION_ID'));
244: BEGIN
245: IF (p_funcmode = 'RUN') THEN
246: l_target_status := wf_engine.getitemattrtext(p_itemtype, p_itemkey,'GMDOPGAP_TARGET_STATUS');

Line 260: l_rework_status GMD_STATUS_NEXT.TARGET_STATUS%TYPE;

256: p_itemkey IN VARCHAR2,
257: p_actid IN NUMBER,
258: p_funcmode IN VARCHAR2,
259: p_resultout OUT NOCOPY VARCHAR2) IS
260: l_rework_status GMD_STATUS_NEXT.TARGET_STATUS%TYPE;
261: l_target_status GMD_STATUS_NEXT.TARGET_STATUS%TYPE;
262: l_start_status GMD_STATUS_NEXT.TARGET_STATUS%TYPE;
263: l_operation_id GMD_OPERATIONS_B.oprn_id%TYPE:=to_number(wf_engine.getitemattrtext(p_itemtype, p_itemkey,'GMDOPGAP_OPERATION_ID'));
264: BEGIN

Line 261: l_target_status GMD_STATUS_NEXT.TARGET_STATUS%TYPE;

257: p_actid IN NUMBER,
258: p_funcmode IN VARCHAR2,
259: p_resultout OUT NOCOPY VARCHAR2) IS
260: l_rework_status GMD_STATUS_NEXT.TARGET_STATUS%TYPE;
261: l_target_status GMD_STATUS_NEXT.TARGET_STATUS%TYPE;
262: l_start_status GMD_STATUS_NEXT.TARGET_STATUS%TYPE;
263: l_operation_id GMD_OPERATIONS_B.oprn_id%TYPE:=to_number(wf_engine.getitemattrtext(p_itemtype, p_itemkey,'GMDOPGAP_OPERATION_ID'));
264: BEGIN
265: IF (p_funcmode = 'RUN') THEN

Line 262: l_start_status GMD_STATUS_NEXT.TARGET_STATUS%TYPE;

258: p_funcmode IN VARCHAR2,
259: p_resultout OUT NOCOPY VARCHAR2) IS
260: l_rework_status GMD_STATUS_NEXT.TARGET_STATUS%TYPE;
261: l_target_status GMD_STATUS_NEXT.TARGET_STATUS%TYPE;
262: l_start_status GMD_STATUS_NEXT.TARGET_STATUS%TYPE;
263: l_operation_id GMD_OPERATIONS_B.oprn_id%TYPE:=to_number(wf_engine.getitemattrtext(p_itemtype, p_itemkey,'GMDOPGAP_OPERATION_ID'));
264: BEGIN
265: IF (p_funcmode = 'RUN') THEN
266: l_start_status := wf_engine.getitemattrtext(p_itemtype, p_itemkey,'GMDOPGAP_START_STATUS');

Line 269: FROM GMD_STATUS_NEXT

265: IF (p_funcmode = 'RUN') THEN
266: l_start_status := wf_engine.getitemattrtext(p_itemtype, p_itemkey,'GMDOPGAP_START_STATUS');
267: l_target_status := wf_engine.getitemattrtext(p_itemtype, p_itemkey,'GMDOPGAP_TARGET_STATUS');
268: SELECT rework_status into l_rework_status
269: FROM GMD_STATUS_NEXT
270: WHERE current_status = l_start_status
271: AND target_status = l_target_status
272: AND pending_status IS NOT NULL;
273: UPDATE GMD_OPERATIONS_B

Line 286: l_start_status GMD_STATUS_NEXT.TARGET_STATUS%TYPE;

282: p_actid IN NUMBER,
283: p_funcmode IN VARCHAR2,
284: p_resultout OUT NOCOPY VARCHAR2) IS
285: l_operation_id GMD_OPERATIONS_B.oprn_id%TYPE:=to_number(wf_engine.getitemattrtext(p_itemtype, p_itemkey,'GMDOPGAP_OPERATION_ID'));
286: l_start_status GMD_STATUS_NEXT.TARGET_STATUS%TYPE;
287: BEGIN
288: IF (p_funcmode = 'RUN') THEN
289: l_start_status := wf_engine.getitemattrtext(p_itemtype, p_itemkey,'GMDOPGAP_START_STATUS');
290: UPDATE GMD_OPERATIONS_B