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