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.GMDOPLAP_WF_PKG dependencies on GMD_STATUS_NEXT

Line 162: l_target_status GMD_STATUS_NEXT.TARGET_STATUS%TYPE;

158: P_where_clause VARCHAR2(100):= ' GMD_OPERATIONS_B.OPRN_ID='||l_OPERATION_ID; -- Where clause to be appended
159: p_role GMA_ACTDATA_WF.ROLE%TYPE;
160: l_data_string VARCHAR2(2000);
161: l_delimiter VARCHAR2(15) := FND_PROFILE.VALUE ('SY$WF_DELIMITER');
162: l_target_status GMD_STATUS_NEXT.TARGET_STATUS%TYPE;
163: BEGIN
164:
165: IF (p_funcmode = 'RUN') THEN
166: 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,'GMDOPLAP_OPERATION_ID'));
244: BEGIN
245: IF (p_funcmode = 'RUN') THEN
246: l_target_status := wf_engine.getitemattrtext(p_itemtype, p_itemkey,'GMDOPLAP_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,'GMDOPLAP_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,'GMDOPLAP_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,'GMDOPLAP_OPERATION_ID'));
264: BEGIN
265: IF (p_funcmode = 'RUN') THEN
266: l_start_status := wf_engine.getitemattrtext(p_itemtype, p_itemkey,'GMDOPLAP_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,'GMDOPLAP_START_STATUS');
267: l_target_status := wf_engine.getitemattrtext(p_itemtype, p_itemkey,'GMDOPLAP_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,'GMDOPLAP_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,'GMDOPLAP_START_STATUS');
290: UPDATE GMD_OPERATIONS_B