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 GMD_STATUS

Line 291: FROM gmd_status

287: --===================================================================== */
288: PROCEDURE get_status_meaning(P_status_code IN NUMBER, P_meaning OUT NOCOPY VARCHAR2) IS
289: CURSOR Cur_get IS
290: SELECT meaning
291: FROM gmd_status
292: WHERE status_code = P_status_code;
293: BEGIN
294: OPEN Cur_get;
295: FETCH Cur_get INTO P_meaning;

Line 434: l_pending_status gmd_status.status_code%TYPE;

430: PROCEDURE set_formula_status(p_formula_id IN NUMBER,
431: p_from_status IN VARCHAR2,
432: p_to_status IN VARCHAR2,
433: p_signature_status IN VARCHAR2) IS
434: l_pending_status gmd_status.status_code%TYPE;
435: l_rework_status gmd_status.status_code%TYPE;
436:
437: /* Declare variables, cursors for recipe generation */
438: l_orgn_code VARCHAR2(4);

Line 435: l_rework_status gmd_status.status_code%TYPE;

431: p_from_status IN VARCHAR2,
432: p_to_status IN VARCHAR2,
433: p_signature_status IN VARCHAR2) IS
434: l_pending_status gmd_status.status_code%TYPE;
435: l_rework_status gmd_status.status_code%TYPE;
436:
437: /* Declare variables, cursors for recipe generation */
438: l_orgn_code VARCHAR2(4);
439: x_return_status VARCHAR2(1);

Line 450: l_pending_status := GMD_STATUS_CODE.get_pending_status(p_from_status => p_from_status

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
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

Line 458: l_rework_status := GMD_STATUS_CODE.get_rework_status(p_from_status => p_from_status

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
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

Line 489: l_pending_status := GMD_STATUS_CODE.get_pending_status(p_from_status => p_from_status

485:
486: GMD_API_GRP.update_end_date (p_substitution_id);
487:
488: ELSIF p_signature_status = 'PENDING' THEN
489: l_pending_status := GMD_STATUS_CODE.get_pending_status(p_from_status => p_from_status
490: ,p_to_status => p_to_status);
491: IF l_pending_status IS NOT NULL THEN
492: UPDATE GMD_ITEM_SUBSTITUTION_HDR_B
493: SET substitution_status = l_pending_status

Line 497: l_rework_status := GMD_STATUS_CODE.get_rework_status(p_from_status => p_from_status

493: SET substitution_status = l_pending_status
494: WHERE substitution_id = p_substitution_id;
495: END IF;
496: ELSIF p_signature_status IN ('REJECTED','TIMEDOUT') THEN
497: l_rework_status := GMD_STATUS_CODE.get_rework_status(p_from_status => p_from_status
498: ,p_to_status => p_to_status);
499: IF l_rework_status IS NOT NULL THEN
500: UPDATE GMD_ITEM_SUBSTITUTION_HDR_B
501: SET substitution_status = l_rework_status

Line 525: l_pending_status gmd_status.status_code%TYPE;

521: PROCEDURE set_formulation_spec_status(p_formulation_spec_id IN NUMBER,
522: p_from_status IN VARCHAR2,
523: p_to_status IN VARCHAR2,
524: p_signature_status IN VARCHAR2) IS
525: l_pending_status gmd_status.status_code%TYPE;
526: l_rework_status gmd_status.status_code%TYPE;
527: BEGIN
528:
529: IF p_signature_status = 'SUCCESS' THEN

Line 526: l_rework_status gmd_status.status_code%TYPE;

522: p_from_status IN VARCHAR2,
523: p_to_status IN VARCHAR2,
524: p_signature_status IN VARCHAR2) IS
525: l_pending_status gmd_status.status_code%TYPE;
526: l_rework_status gmd_status.status_code%TYPE;
527: BEGIN
528:
529: IF p_signature_status = 'SUCCESS' THEN
530: UPDATE gmd_formulation_specs

Line 534: l_pending_status := GMD_STATUS_CODE.get_pending_status(p_from_status => p_from_status

530: UPDATE gmd_formulation_specs
531: SET spec_status = p_to_status
532: WHERE formulation_spec_id = p_formulation_spec_id;
533: ELSIF p_signature_status = 'PENDING' THEN
534: l_pending_status := GMD_STATUS_CODE.get_pending_status(p_from_status => p_from_status
535: ,p_to_status => p_to_status);
536: IF l_pending_status IS NOT NULL THEN
537: UPDATE gmd_formulation_specs
538: SET spec_status = l_pending_status

Line 542: l_rework_status := GMD_STATUS_CODE.get_rework_status(p_from_status => p_from_status

538: SET spec_status = l_pending_status
539: WHERE formulation_spec_id = p_formulation_spec_id;
540: END IF;
541: ELSIF p_signature_status IN ('REJECTED','TIMEDOUT') THEN
542: l_rework_status := GMD_STATUS_CODE.get_rework_status(p_from_status => p_from_status
543: ,p_to_status => p_to_status);
544: IF l_rework_status IS NOT NULL THEN
545: UPDATE gmd_formulation_specs
546: SET spec_status = l_rework_status

Line 571: l_pending_status gmd_status.status_code%TYPE;

567: PROCEDURE set_operation_status(p_oprn_id IN NUMBER,
568: p_from_status IN VARCHAR2,
569: p_to_status IN VARCHAR2,
570: p_signature_status IN VARCHAR2) IS
571: l_pending_status gmd_status.status_code%TYPE;
572: l_rework_status gmd_status.status_code%TYPE;
573: BEGIN
574: IF p_signature_status = 'SUCCESS' THEN
575: UPDATE gmd_operations_b

Line 572: l_rework_status gmd_status.status_code%TYPE;

568: p_from_status IN VARCHAR2,
569: p_to_status IN VARCHAR2,
570: p_signature_status IN VARCHAR2) IS
571: l_pending_status gmd_status.status_code%TYPE;
572: l_rework_status gmd_status.status_code%TYPE;
573: BEGIN
574: IF p_signature_status = 'SUCCESS' THEN
575: UPDATE gmd_operations_b
576: SET operation_status = p_to_status

Line 579: l_pending_status := GMD_STATUS_CODE.get_pending_status(p_from_status => p_from_status

575: UPDATE gmd_operations_b
576: SET operation_status = p_to_status
577: WHERE oprn_id = p_oprn_id;
578: ELSIF p_signature_status = 'PENDING' THEN
579: l_pending_status := GMD_STATUS_CODE.get_pending_status(p_from_status => p_from_status
580: ,p_to_status => p_to_status);
581: IF l_pending_status IS NOT NULL THEN
582: UPDATE gmd_operations_b
583: SET operation_status = l_pending_status

Line 587: l_rework_status := GMD_STATUS_CODE.get_rework_status(p_from_status => p_from_status

583: SET operation_status = l_pending_status
584: WHERE oprn_id = p_oprn_id;
585: END IF;
586: ELSIF p_signature_status IN ('REJECTED','TIMEDOUT') THEN
587: l_rework_status := GMD_STATUS_CODE.get_rework_status(p_from_status => p_from_status
588: ,p_to_status => p_to_status);
589: IF l_rework_status IS NOT NULL THEN
590: UPDATE gmd_operations_b
591: SET operation_status = l_rework_status

Line 617: l_pending_status gmd_status.status_code%TYPE;

613: PROCEDURE set_routing_status(p_routing_id IN NUMBER,
614: p_from_status IN VARCHAR2,
615: p_to_status IN VARCHAR2,
616: p_signature_status IN VARCHAR2) IS
617: l_pending_status gmd_status.status_code%TYPE;
618: l_rework_status gmd_status.status_code%TYPE;
619: BEGIN
620: IF p_signature_status = 'SUCCESS' THEN
621: UPDATE gmd_routings_b

Line 618: l_rework_status gmd_status.status_code%TYPE;

614: p_from_status IN VARCHAR2,
615: p_to_status IN VARCHAR2,
616: p_signature_status IN VARCHAR2) IS
617: l_pending_status gmd_status.status_code%TYPE;
618: l_rework_status gmd_status.status_code%TYPE;
619: BEGIN
620: IF p_signature_status = 'SUCCESS' THEN
621: UPDATE gmd_routings_b
622: SET routing_status = p_to_status

Line 625: l_pending_status := GMD_STATUS_CODE.get_pending_status(p_from_status => p_from_status

621: UPDATE gmd_routings_b
622: SET routing_status = p_to_status
623: WHERE routing_id = p_routing_id;
624: ELSIF p_signature_status = 'PENDING' THEN
625: l_pending_status := GMD_STATUS_CODE.get_pending_status(p_from_status => p_from_status
626: ,p_to_status => p_to_status);
627: IF l_pending_status IS NOT NULL THEN
628: UPDATE gmd_routings_b
629: SET routing_status = l_pending_status

Line 633: l_rework_status := GMD_STATUS_CODE.get_rework_status(p_from_status => p_from_status

629: SET routing_status = l_pending_status
630: WHERE routing_id = p_routing_id;
631: END IF;
632: ELSIF p_signature_status IN ('REJECTED','TIMEDOUT') THEN
633: l_rework_status := GMD_STATUS_CODE.get_rework_status(p_from_status => p_from_status
634: ,p_to_status => p_to_status);
635: IF l_rework_status IS NOT NULL THEN
636: UPDATE gmd_routings_b
637: SET routing_status = l_rework_status

Line 664: l_pending_status gmd_status.status_code%TYPE;

660: p_from_status IN VARCHAR2,
661: p_to_status IN VARCHAR2,
662: p_signature_status IN VARCHAR2,
663: p_create_validity IN NUMBER) IS
664: l_pending_status gmd_status.status_code%TYPE;
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

Line 665: l_rework_status gmd_status.status_code%TYPE;

661: p_to_status IN VARCHAR2,
662: p_signature_status IN VARCHAR2,
663: p_create_validity IN NUMBER) IS
664: l_pending_status gmd_status.status_code%TYPE;
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

Line 713: l_pending_status := GMD_STATUS_CODE.get_pending_status(p_from_status => p_from_status

709: p_event_signed => FALSE,
710: x_return_status => l_return_status);
711: END IF; /* IF p_create_validity = 1 */
712: ELSIF p_signature_status = 'PENDING' THEN
713: l_pending_status := GMD_STATUS_CODE.get_pending_status(p_from_status => p_from_status
714: ,p_to_status => p_to_status);
715: IF l_pending_status IS NOT NULL THEN
716: UPDATE gmd_recipes_b
717: SET recipe_status = l_pending_status

Line 721: l_rework_status := GMD_STATUS_CODE.get_rework_status(p_from_status => p_from_status

717: SET recipe_status = l_pending_status
718: WHERE recipe_id = p_recipe_id;
719: END IF;
720: ELSIF p_signature_status IN ('REJECTED','TIMEDOUT') THEN
721: l_rework_status := GMD_STATUS_CODE.get_rework_status(p_from_status => p_from_status
722: ,p_to_status => p_to_status);
723: IF l_rework_status IS NOT NULL THEN
724: UPDATE gmd_recipes_b
725: SET recipe_status = l_rework_status

Line 751: l_pending_status gmd_status.status_code%TYPE;

747: PROCEDURE set_validity_status(p_validity_rule_id IN NUMBER,
748: p_from_status IN VARCHAR2,
749: p_to_status IN VARCHAR2,
750: p_signature_status IN VARCHAR2) IS
751: l_pending_status gmd_status.status_code%TYPE;
752: l_rework_status gmd_status.status_code%TYPE;
753: BEGIN
754: IF p_signature_status = 'SUCCESS' THEN
755: UPDATE gmd_recipe_validity_rules

Line 752: l_rework_status gmd_status.status_code%TYPE;

748: p_from_status IN VARCHAR2,
749: p_to_status IN VARCHAR2,
750: p_signature_status IN VARCHAR2) IS
751: l_pending_status gmd_status.status_code%TYPE;
752: l_rework_status gmd_status.status_code%TYPE;
753: BEGIN
754: IF p_signature_status = 'SUCCESS' THEN
755: UPDATE gmd_recipe_validity_rules
756: SET validity_rule_status = p_to_status

Line 759: l_pending_status := GMD_STATUS_CODE.get_pending_status(p_from_status => p_from_status

755: UPDATE gmd_recipe_validity_rules
756: SET validity_rule_status = p_to_status
757: WHERE recipe_validity_rule_id = p_validity_rule_id;
758: ELSIF p_signature_status = 'PENDING' THEN
759: l_pending_status := GMD_STATUS_CODE.get_pending_status(p_from_status => p_from_status
760: ,p_to_status => p_to_status);
761: IF l_pending_status IS NOT NULL THEN
762: UPDATE gmd_recipe_validity_rules
763: SET validity_rule_status = l_pending_status

Line 767: l_rework_status := GMD_STATUS_CODE.get_rework_status(p_from_status => p_from_status

763: SET validity_rule_status = l_pending_status
764: WHERE recipe_validity_rule_id = p_validity_rule_id;
765: END IF;
766: ELSIF p_signature_status IN ('REJECTED','TIMEDOUT') THEN
767: l_rework_status := GMD_STATUS_CODE.get_rework_status(p_from_status => p_from_status
768: ,p_to_status => p_to_status);
769: IF l_rework_status IS NOT NULL THEN
770: UPDATE gmd_recipe_validity_rules
771: SET validity_rule_status = l_rework_status

Line 798: l_pending_status gmd_status.status_code%TYPE;

794: p_orgn_id IN NUMBER,
795: p_from_status IN VARCHAR2,
796: p_to_status IN VARCHAR2,
797: p_signature_status IN VARCHAR2) IS
798: l_pending_status gmd_status.status_code%TYPE;
799: l_rework_status gmd_status.status_code%TYPE;
800: l_return_status VARCHAR2(1);
801: l_recipe_no VARCHAR2(100);
802: l_recipe_version NUMBER(5);

Line 799: l_rework_status gmd_status.status_code%TYPE;

795: p_from_status IN VARCHAR2,
796: p_to_status IN VARCHAR2,
797: p_signature_status IN VARCHAR2) IS
798: l_pending_status gmd_status.status_code%TYPE;
799: l_rework_status gmd_status.status_code%TYPE;
800: l_return_status VARCHAR2(1);
801: l_recipe_no VARCHAR2(100);
802: l_recipe_version NUMBER(5);
803: BEGIN

Line 815: l_pending_status := GMD_STATUS_CODE.get_pending_status(p_from_status => p_from_status

811: ,X_recipe_no => l_recipe_no
812: ,X_recipe_version => l_recipe_version
813: ,p_event_signed => TRUE);
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

Line 823: l_rework_status := GMD_STATUS_CODE.get_rework_status(p_from_status => p_from_status

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
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

Line 946: FROM gmd_status

942: AND lookup_code = 'FORMULA';
943:
944: CURSOR Cur_get_status_desc (pstatus VARCHAR2) IS
945: SELECT description
946: FROM gmd_status
947: WHERE status_code = pstatus;
948:
949: l_replace_type_desc VARCHAR2(240);
950: l_user_key_label VARCHAR2(2000);

Line 1134: FND_MESSAGE.SET_NAME('GMD', 'GMD_STATUS');

1130: OPEN Cur_get_desc;
1131: FETCH Cur_get_desc INTO l_replace_type_desc;
1132: CLOSE Cur_get_desc;
1133:
1134: FND_MESSAGE.SET_NAME('GMD', 'GMD_STATUS');
1135: l_status := FND_MESSAGE.GET;
1136:
1137: FND_MESSAGE.SET_NAME('GMD','GMD_CONC_UPDATE_OBJECT_FAILED');
1138: FND_MESSAGE.SET_TOKEN('REPLACE_TYPE',l_replace_type_desc);

Line 1179: FROM gmd_status

1175: AND lookup_code = 'OPERATION';
1176:
1177: CURSOR Cur_get_status_desc (pstatus VARCHAR2) IS
1178: SELECT description
1179: FROM gmd_status
1180: WHERE status_code = pstatus;
1181:
1182: l_replace_type_desc VARCHAR2(240);
1183: l_user_key_label VARCHAR2(2000);

Line 1326: FND_MESSAGE.SET_NAME('GMD', 'GMD_STATUS');

1322: OPEN Cur_get_desc;
1323: FETCH Cur_get_desc INTO l_replace_type_desc;
1324: CLOSE Cur_get_desc;
1325:
1326: FND_MESSAGE.SET_NAME('GMD', 'GMD_STATUS');
1327: l_status := FND_MESSAGE.GET;
1328:
1329: FND_MESSAGE.SET_NAME('GMD','GMD_CONC_UPDATE_OBJECT_FAILED');
1330: FND_MESSAGE.SET_TOKEN('REPLACE_TYPE',l_replace_type_desc);

Line 1370: FROM gmd_status

1366: AND lookup_code = 'ROUTING';
1367:
1368: CURSOR Cur_get_status_desc (pstatus VARCHAR2) IS
1369: SELECT description
1370: FROM gmd_status
1371: WHERE status_code = pstatus;
1372:
1373: l_replace_type_desc VARCHAR2(240);
1374: l_user_key_label VARCHAR2(2000);

Line 1512: FND_MESSAGE.SET_NAME('GMD', 'GMD_STATUS');

1508: OPEN Cur_get_desc;
1509: FETCH Cur_get_desc INTO l_replace_type_desc;
1510: CLOSE Cur_get_desc;
1511:
1512: FND_MESSAGE.SET_NAME('GMD', 'GMD_STATUS');
1513: l_status := FND_MESSAGE.GET;
1514:
1515: FND_MESSAGE.SET_NAME('GMD','GMD_CONC_UPDATE_OBJECT_FAILED');
1516: FND_MESSAGE.SET_TOKEN('REPLACE_TYPE',l_replace_type_desc);

Line 1556: FROM gmd_status

1552: AND lookup_code = 'RECIPE';
1553:
1554: CURSOR Cur_get_status_desc (pstatus VARCHAR2) IS
1555: SELECT description
1556: FROM gmd_status
1557: WHERE status_code = pstatus;
1558:
1559: CURSOR Cur_get_status_type (pstatus VARCHAR2) IS
1560: SELECT status_type, description

Line 1561: FROM gmd_status

1557: WHERE status_code = pstatus;
1558:
1559: CURSOR Cur_get_status_type (pstatus VARCHAR2) IS
1560: SELECT status_type, description
1561: FROM gmd_status
1562: WHERE status_code = pstatus;
1563:
1564: l_replace_type_desc VARCHAR2(240);
1565: l_user_key_label VARCHAR2(2000);

Line 1575: l_status_type GMD_STATUS.status_type%TYPE;

1571: l_user_id NUMBER := FND_GLOBAL.USER_ID;
1572: l_status VARCHAR2(2000);
1573: l_esig_reqd BOOLEAN;
1574: l_erec_reqd BOOLEAN;
1575: l_status_type GMD_STATUS.status_type%TYPE;
1576: l_post_operation_api VARCHAR2(4000);
1577:
1578: PENDING_STATUS_ERR EXCEPTION;
1579: REWORK_STATUS_ERR EXCEPTION;

Line 1814: FND_MESSAGE.SET_NAME('GMD', 'GMD_STATUS');

1810: OPEN Cur_get_desc;
1811: FETCH Cur_get_desc INTO l_replace_type_desc;
1812: CLOSE Cur_get_desc;
1813:
1814: FND_MESSAGE.SET_NAME('GMD', 'GMD_STATUS');
1815: l_status := FND_MESSAGE.GET;
1816:
1817: FND_MESSAGE.SET_NAME('GMD','GMD_CONC_UPDATE_OBJECT_FAILED');
1818: FND_MESSAGE.SET_TOKEN('REPLACE_TYPE',l_replace_type_desc);

Line 1850: FROM gmd_status

1846: x_return_status OUT NOCOPY VARCHAR2) IS
1847:
1848: CURSOR Cur_get_status_desc (pstatus VARCHAR2) IS
1849: SELECT description
1850: FROM gmd_status
1851: WHERE status_code = pstatus;
1852:
1853: CURSOR Cur_get_recipe_info(vVR_id NUMBER) IS
1854: SELECT a.recipe_no, a.recipe_version, b.recipe_use

Line 2048: FROM gmd_status

2044: x_return_status OUT NOCOPY VARCHAR2) IS
2045:
2046: CURSOR Cur_get_status_desc (pstatus VARCHAR2) IS
2047: SELECT description
2048: FROM gmd_status
2049: WHERE status_code = pstatus;
2050:
2051:
2052: CURSOR Cur_subs_details IS

Line 2567: FROM gmd_routings_vl a , gmd_status b

2563:
2564: p_routing_id NUMBER;
2565: CURSOR Cur_get_routing_details(V_routing_id NUMBER) IS
2566: SELECT ROUTING_NO, ROUTING_VERS ,ROUTING_DESC , b.MEANING
2567: FROM gmd_routings_vl a , gmd_status b
2568: WHERE a.routing_id = V_routing_id
2569: AND a.routing_status = b.status_code;
2570:
2571: CURSOR Cur_get_value (vLookup_code VARCHAR2) IS