APPS.GMD_ERES_UTILS dependencies on FM_FORM_MST_B

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 446: UPDATE fm_form_mst_b

442:
443:
444: BEGIN
445: IF p_signature_status = 'SUCCESS' THEN
446: UPDATE fm_form_mst_b
447: SET formula_status = p_to_status
448: WHERE formula_id = p_formula_id;
449: ELSIF p_signature_status = 'PENDING' THEN
450: l_pending_status := GMD_STATUS_CODE.get_pending_status(p_from_status => p_from_status

Line 453: UPDATE fm_form_mst_b

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

Line 461: UPDATE fm_form_mst_b

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

Line 669: FROM gmd_recipes_b r, fm_form_mst_b f

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

Line 805: UPDATE fm_form_mst_b

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

Line 818: UPDATE fm_form_mst_b

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

Line 826: UPDATE fm_form_mst_b

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

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

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

Line 973: FROM FM_FORM_MST_B

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

Line 1111: 'FM_FORM_MST_B',

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