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_CODE

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