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.GMD_ERES_UTILS dependencies on FM_FORM_MST

Line 87: FROM fm_form_mst_b

83: --===================================================================== */
84: PROCEDURE get_formula_no(P_formula_id IN NUMBER, P_formula_no OUT NOCOPY VARCHAR2) IS
85: CURSOR Cur_get_formula IS
86: SELECT formula_no
87: FROM fm_form_mst_b
88: WHERE formula_id = P_formula_id;
89: BEGIN
90: OPEN Cur_get_formula;
91: FETCH Cur_get_formula INTO P_formula_no;

Line 112: FROM fm_form_mst_b

108: --===================================================================== */
109: PROCEDURE get_formula_vers(P_formula_id IN NUMBER,P_formula_vers OUT NOCOPY NUMBER) IS
110: CURSOR Cur_get_formula IS
111: SELECT formula_vers
112: FROM fm_form_mst_b
113: WHERE formula_id = P_formula_id;
114: BEGIN
115: OPEN Cur_get_formula;
116: FETCH Cur_get_formula INTO P_formula_vers;

Line 138: FROM fm_form_mst

134: --===================================================================== */
135: PROCEDURE get_formula_desc(P_formula_id IN NUMBER, P_formula_desc OUT NOCOPY VARCHAR2) IS
136: CURSOR Cur_get_formula_desc IS
137: SELECT formula_desc1
138: FROM fm_form_mst
139: WHERE formula_id = P_formula_id;
140: BEGIN
141: OPEN Cur_get_formula_desc;
142: FETCH Cur_get_formula_desc INTO P_formula_desc;

Line 448: UPDATE fm_form_mst_b

444: BEGIN
445: --Added the following line for bug13364903.
446: gmd_p_fs_context.set_additional_attr;
447: IF p_signature_status = 'SUCCESS' THEN
448: UPDATE fm_form_mst_b
449: SET formula_status = p_to_status
450: WHERE formula_id = p_formula_id;
451: ELSIF p_signature_status = 'PENDING' THEN
452: l_pending_status := GMD_STATUS_CODE.get_pending_status(p_from_status => p_from_status

Line 455: UPDATE fm_form_mst_b

451: ELSIF p_signature_status = 'PENDING' THEN
452: l_pending_status := GMD_STATUS_CODE.get_pending_status(p_from_status => p_from_status
453: ,p_to_status => p_to_status);
454: IF l_pending_status IS NOT NULL THEN
455: UPDATE fm_form_mst_b
456: SET formula_status = l_pending_status
457: WHERE formula_id = p_formula_id;
458: END IF;
459: ELSIF p_signature_status IN ('REJECTED','TIMEDOUT') THEN

Line 463: UPDATE fm_form_mst_b

459: ELSIF p_signature_status IN ('REJECTED','TIMEDOUT') THEN
460: l_rework_status := GMD_STATUS_CODE.get_rework_status(p_from_status => p_from_status
461: ,p_to_status => p_to_status);
462: IF l_rework_status IS NOT NULL THEN
463: UPDATE fm_form_mst_b
464: SET formula_status = l_rework_status
465: WHERE formula_id = p_formula_id;
466: END IF;
467: END IF;

Line 671: FROM gmd_recipes_b r, fm_form_mst_b f

667: l_rework_status gmd_status.status_code%TYPE;
668:
669: CURSOR Cur_get_formula_details IS
670: SELECT r.owner_organization_id, r.formula_id, r.recipe_no, r.recipe_version
671: FROM gmd_recipes_b r, fm_form_mst_b f
672: WHERE r.recipe_id = p_recipe_id
673: AND r.formula_id = f.formula_id;
674: LocalFormRecord Cur_get_formula_details%ROWTYPE;
675:

Line 807: UPDATE fm_form_mst_b

803: l_recipe_no VARCHAR2(100);
804: l_recipe_version NUMBER(5);
805: BEGIN
806: IF p_signature_status = 'SUCCESS' THEN
807: UPDATE fm_form_mst_b
808: SET formula_status = p_to_status
809: WHERE formula_id = p_formula_id;
810: gmd_recipe_generate.recipe_generate (p_orgn_id => p_orgn_id
811: ,p_formula_id => p_formula_id

Line 820: UPDATE fm_form_mst_b

816: ELSIF p_signature_status = 'PENDING' THEN
817: l_pending_status := GMD_STATUS_CODE.get_pending_status(p_from_status => p_from_status
818: ,p_to_status => p_to_status);
819: IF l_pending_status IS NOT NULL THEN
820: UPDATE fm_form_mst_b
821: SET formula_status = l_pending_status
822: WHERE formula_id = p_formula_id;
823: END IF;
824: ELSIF p_signature_status IN ('REJECTED','TIMEDOUT') THEN

Line 828: UPDATE fm_form_mst_b

824: ELSIF p_signature_status IN ('REJECTED','TIMEDOUT') THEN
825: l_rework_status := GMD_STATUS_CODE.get_rework_status(p_from_status => p_from_status
826: ,p_to_status => p_to_status);
827: IF l_rework_status IS NOT NULL THEN
828: UPDATE fm_form_mst_b
829: SET formula_status = l_rework_status
830: WHERE formula_id = p_formula_id;
831: END IF;
832: END IF;

Line 973: CURSOR get_orgn_code( CP_FORMULA_ID FM_FORM_MST_B.FORMULA_ID%TYPE) IS

969: --Local variables
970: l_access_type_ind VARCHAR2(10);
971: l_owner_organization_id NUMBER(15);
972: --New cursor to get the organization to which the formula belongs.
973: CURSOR get_orgn_code( CP_FORMULA_ID FM_FORM_MST_B.FORMULA_ID%TYPE) IS
974: SELECT OWNER_ORGANIZATION_ID
975: FROM FM_FORM_MST_B
976: WHERE FORMULA_ID = CP_FORMULA_ID;
977: --End of Declaration for Bug# 3497522

Line 975: FROM FM_FORM_MST_B

971: l_owner_organization_id NUMBER(15);
972: --New cursor to get the organization to which the formula belongs.
973: CURSOR get_orgn_code( CP_FORMULA_ID FM_FORM_MST_B.FORMULA_ID%TYPE) IS
974: SELECT OWNER_ORGANIZATION_ID
975: FROM FM_FORM_MST_B
976: WHERE FORMULA_ID = CP_FORMULA_ID;
977: --End of Declaration for Bug# 3497522
978:
979: BEGIN

Line 988: FROM fm_form_mst

984: l_object_type := FND_MESSAGE.GET;
985:
986: SELECT 'x'
987: INTO l_text
988: FROM fm_form_mst
989: WHERE formula_id = p_formula_id
990: FOR UPDATE OF formula_status nowait;
991:
992: UPDATE fm_form_mst

Line 992: UPDATE fm_form_mst

988: FROM fm_form_mst
989: WHERE formula_id = p_formula_id
990: FOR UPDATE OF formula_status nowait;
991:
992: UPDATE fm_form_mst
993: SET formula_status = p_to_status,
994: last_update_date = sysdate,
995: last_updated_by = l_user_id
996: WHERE formula_id = p_formula_id;

Line 1072: UPDATE fm_form_mst

1068: ,p_parameter_value7=>-1);
1069:
1070: IF l_esig_reqd THEN
1071: X_return_status := 'P';
1072: UPDATE fm_form_mst
1073: SET formula_status = p_pending_status
1074: WHERE formula_id = p_formula_id;
1075: IF p_called_from_form = 'F' THEN
1076: FND_MESSAGE.SET_NAME('GMD','GMD_ERES_PEND_STAT_UPD');

Line 1113: 'FM_FORM_MST_B',

1109: gmd_debug.put_line ('In GMDERESB.pls - locked exception section ');
1110: END IF;
1111: gmd_api_grp.log_message('GMD_RECORD_LOCKED',
1112: 'TABLE_NAME',
1113: 'FM_FORM_MST_B',
1114: 'RECORD',
1115: 'FORMULA_NO : FORMULA_VERS = ',
1116: 'KEY',
1117: p_object_name||':'||p_object_version