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 452: l_pending_status := GMD_STATUS_CODE.get_pending_status(p_from_status => p_from_status

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

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

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

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

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

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

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

Line 527: l_pending_status gmd_status.status_code%TYPE;

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

Line 528: l_rework_status gmd_status.status_code%TYPE;

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

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

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

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

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

Line 573: l_pending_status gmd_status.status_code%TYPE;

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

Line 574: l_rework_status gmd_status.status_code%TYPE;

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

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

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

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

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

Line 619: l_pending_status gmd_status.status_code%TYPE;

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

Line 620: l_rework_status gmd_status.status_code%TYPE;

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

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

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

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

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

Line 666: l_pending_status gmd_status.status_code%TYPE;

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

Line 667: l_rework_status gmd_status.status_code%TYPE;

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

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

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

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

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

Line 753: l_pending_status gmd_status.status_code%TYPE;

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

Line 754: l_rework_status gmd_status.status_code%TYPE;

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

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

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

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

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

Line 800: l_pending_status gmd_status.status_code%TYPE;

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

Line 801: l_rework_status gmd_status.status_code%TYPE;

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

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

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

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

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

Line 948: FROM gmd_status

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

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

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

Line 1181: FROM gmd_status

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

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

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

Line 1372: FROM gmd_status

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

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

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

Line 1558: FROM gmd_status

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

Line 1563: FROM gmd_status

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

Line 1577: l_status_type GMD_STATUS.status_type%TYPE;

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

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

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

Line 1852: FROM gmd_status

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

Line 2050: FROM gmd_status

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

Line 2569: FROM gmd_routings_vl a , gmd_status b

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