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_ROUTING_STEPS_PVT dependencies on FM_ROUT_DEP

Line 157: /* insert to fm_rout_Dep */

153: /* */
154: /* History : */
155: /* Shyam 07/29/2002 Initial implemenation */
156: /* S.Dulyk 8/24/03 remove NVL and ,0 from max_delay line in */
157: /* insert to fm_rout_Dep */
158: /* =============================================================== */
159: PROCEDURE insert_step_dependencies
160: ( p_routing_id IN gmd_routings.routing_id%TYPE
161: , p_routingstep_no IN fm_rout_dtl.routingstep_no%TYPE

Line 221: INSERT INTO fm_rout_dep

217: x_return_status := FND_API.g_ret_sts_error;
218: END IF;
219:
220:
221: INSERT INTO fm_rout_dep
222: (routingstep_no ,dep_routingstep_no ,routing_id ,dep_type ,rework_code
223: ,standard_delay ,minimum_delay ,max_delay ,transfer_qty ,routingstep_no_uom
224: ,text_code ,last_updated_by ,created_by ,last_update_date ,creation_date
225: ,last_update_login ,transfer_pct ) VALUES

Line 548: /* step dependency (fm_rout_dep table) is success. */

544: /* */
545: /* DESCRIPTION: */
546: /* */
547: /* API returns (x_return_code) = 'S' if the update into routing */
548: /* step dependency (fm_rout_dep table) is success. */
549: /* */
550: /* History : */
551: /* Shyam 07/29/2002 Initial implementation */
552: /* =============================================================== */

Line 554: ( p_routingstep_no IN fm_rout_dep.routingstep_no%TYPE

550: /* History : */
551: /* Shyam 07/29/2002 Initial implementation */
552: /* =============================================================== */
553: PROCEDURE update_step_dependencies
554: ( p_routingstep_no IN fm_rout_dep.routingstep_no%TYPE
555: , p_dep_routingstep_no IN fm_rout_dep.routingstep_no%TYPE
556: , p_routing_id IN fm_rout_dep.routing_id%TYPE
557: , p_update_table IN GMD_ROUTINGS_PUB.update_tbl_type
558: , x_return_status OUT NOCOPY VARCHAR2

Line 555: , p_dep_routingstep_no IN fm_rout_dep.routingstep_no%TYPE

551: /* Shyam 07/29/2002 Initial implementation */
552: /* =============================================================== */
553: PROCEDURE update_step_dependencies
554: ( p_routingstep_no IN fm_rout_dep.routingstep_no%TYPE
555: , p_dep_routingstep_no IN fm_rout_dep.routingstep_no%TYPE
556: , p_routing_id IN fm_rout_dep.routing_id%TYPE
557: , p_update_table IN GMD_ROUTINGS_PUB.update_tbl_type
558: , x_return_status OUT NOCOPY VARCHAR2
559: ) IS

Line 556: , p_routing_id IN fm_rout_dep.routing_id%TYPE

552: /* =============================================================== */
553: PROCEDURE update_step_dependencies
554: ( p_routingstep_no IN fm_rout_dep.routingstep_no%TYPE
555: , p_dep_routingstep_no IN fm_rout_dep.routingstep_no%TYPE
556: , p_routing_id IN fm_rout_dep.routing_id%TYPE
557: , p_update_table IN GMD_ROUTINGS_PUB.update_tbl_type
558: , x_return_status OUT NOCOPY VARCHAR2
559: ) IS
560:

Line 567: l_old_stepDep_rec fm_rout_dep%ROWTYPE;

563: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
564: l_db_date DATE;
565:
566: /* Define record type that hold the routing data */
567: l_old_stepDep_rec fm_rout_dep%ROWTYPE;
568:
569: /* Define Exceptions */
570: last_update_date_failure EXCEPTION;
571: routing_update_dep_failure EXCEPTION;

Line 575: CURSOR get_old_stepDep_rec( vRoutingStep_no fm_rout_dep.routingStep_no%TYPE

571: routing_update_dep_failure EXCEPTION;
572: invalid_version EXCEPTION;
573: setup_failure EXCEPTION;
574:
575: CURSOR get_old_stepDep_rec( vRoutingStep_no fm_rout_dep.routingStep_no%TYPE
576: ,vdep_RoutingStep_no fm_rout_dep.dep_routingStep_no%TYPE
577: ,vRouting_id fm_rout_dep.routing_id%TYPE) IS
578: Select *
579: From fm_rout_dep

Line 576: ,vdep_RoutingStep_no fm_rout_dep.dep_routingStep_no%TYPE

572: invalid_version EXCEPTION;
573: setup_failure EXCEPTION;
574:
575: CURSOR get_old_stepDep_rec( vRoutingStep_no fm_rout_dep.routingStep_no%TYPE
576: ,vdep_RoutingStep_no fm_rout_dep.dep_routingStep_no%TYPE
577: ,vRouting_id fm_rout_dep.routing_id%TYPE) IS
578: Select *
579: From fm_rout_dep
580: Where RoutingStep_no = vRoutingStep_no

Line 577: ,vRouting_id fm_rout_dep.routing_id%TYPE) IS

573: setup_failure EXCEPTION;
574:
575: CURSOR get_old_stepDep_rec( vRoutingStep_no fm_rout_dep.routingStep_no%TYPE
576: ,vdep_RoutingStep_no fm_rout_dep.dep_routingStep_no%TYPE
577: ,vRouting_id fm_rout_dep.routing_id%TYPE) IS
578: Select *
579: From fm_rout_dep
580: Where RoutingStep_no = vRoutingStep_no
581: And dep_RoutingStep_no = vdep_RoutingStep_no

Line 579: From fm_rout_dep

575: CURSOR get_old_stepDep_rec( vRoutingStep_no fm_rout_dep.routingStep_no%TYPE
576: ,vdep_RoutingStep_no fm_rout_dep.dep_routingStep_no%TYPE
577: ,vRouting_id fm_rout_dep.routing_id%TYPE) IS
578: Select *
579: From fm_rout_dep
580: Where RoutingStep_no = vRoutingStep_no
581: And dep_RoutingStep_no = vdep_RoutingStep_no
582: And Routing_id = vRouting_id;
583:

Line 614: /* Actual update in fm_rout_dep table */

610:
611: /* Get the last update date in database */
612: l_db_date := l_old_stepDep_rec.LAST_UPDATE_DATE;
613:
614: /* Actual update in fm_rout_dep table */
615: /* Loop thro' every column in p_update_table table and for each column name
616: assign or replace the old value with the table value */
617: FOR i IN 1 .. p_update_table.count LOOP
618: IF (UPPER(p_update_table(i).p_col_to_update) = 'DEP_TYPE') THEN

Line 655: UPDATE fm_rout_dep

651: x_return_status := FND_API.g_ret_sts_error;
652: END IF;
653:
654: /* S.Dulyk - 12/27/02 Bug 2669986 Added max_delay */
655: UPDATE fm_rout_dep
656: SET dep_type = l_old_stepDep_rec.dep_type
657: ,rework_code = l_old_stepDep_rec.rework_code
658: ,standard_delay = l_old_stepDep_rec.standard_delay
659: ,max_delay = l_old_stepDep_rec.max_delay

Line 709: /* step dependency (fm_rout_dep table) is success. */

705: /* */
706: /* DESCRIPTION: */
707: /* */
708: /* API returns (x_return_code) = 'S' if the delete into routing */
709: /* step dependency (fm_rout_dep table) is success. */
710: /* */
711: /* History : */
712: /* Shyam 07/29/2002 Initial implementation */
713: /* =============================================================== */

Line 725: l_routingstep_no fm_rout_dep.routingStep_no%TYPE;

721: l_api_name CONSTANT VARCHAR2(30) := 'DELETE_ROUTING_STEP';
722: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
723: l_return_from_routing_step_dep VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
724: l_routingStep_id fm_rout_dtl.routingStep_id%TYPE;
725: l_routingstep_no fm_rout_dep.routingStep_no%TYPE;
726: l_stepdep_count NUMBER := 0;
727: l_exists PLS_INTEGER;
728:
729: /* Define Cursors */

Line 732: Cursor Check_Step_dep_rec(vRoutingstep_no fm_rout_dep.routingStep_no%TYPE

728:
729: /* Define Cursors */
730: /* Cursor that check if there any row in the step dependency table that
731: needs to be deleted */
732: Cursor Check_Step_dep_rec(vRoutingstep_no fm_rout_dep.routingStep_no%TYPE
733: ,vRouting_id gmd_routings.Routing_id%TYPE) IS
734: Select count(*)
735: From fm_rout_dep
736: Where (routingStep_no = vRoutingStep_no OR dep_routingStep_no = vRoutingStep_no)

Line 735: From fm_rout_dep

731: needs to be deleted */
732: Cursor Check_Step_dep_rec(vRoutingstep_no fm_rout_dep.routingStep_no%TYPE
733: ,vRouting_id gmd_routings.Routing_id%TYPE) IS
734: Select count(*)
735: From fm_rout_dep
736: Where (routingStep_no = vRoutingStep_no OR dep_routingStep_no = vRoutingStep_no)
737: And routing_id = vrouting_id;
738:
739:

Line 856: /* Check if any rows from fm_rout_dep needs to be deleted */

852: RAISE step_used_in_recipe;
853: END IF;
854: CLOSE Cur_check_orgn_res;
855:
856: /* Check if any rows from fm_rout_dep needs to be deleted */
857: IF p_routing_id IS NOT NULL THEN
858: OPEN Check_Step_dep_rec(vRoutingstep_no => l_routingstep_no
859: ,vRouting_id => p_routing_id ) ;
860: FETCH Check_Step_dep_rec INTO l_stepdep_count;

Line 923: /* step dependency (fm_rout_dep table) is success. */

919: /* */
920: /* DESCRIPTION: */
921: /* */
922: /* API returns (x_return_code) = 'S' if the delete in routing */
923: /* step dependency (fm_rout_dep table) is success. */
924: /* */
925: /* History : */
926: /* Shyam 07/29/2002 Initial implementation */
927: /* =============================================================== */

Line 929: ( p_routingstep_no IN fm_rout_dep.routingstep_no%TYPE

925: /* History : */
926: /* Shyam 07/29/2002 Initial implementation */
927: /* =============================================================== */
928: PROCEDURE delete_step_dependencies
929: ( p_routingstep_no IN fm_rout_dep.routingstep_no%TYPE
930: , p_dep_routingstep_no IN fm_rout_dep.routingstep_no%TYPE := NULL
931: , p_routing_id IN fm_rout_dep.routing_id%TYPE
932: , x_return_status OUT NOCOPY VARCHAR2
933: ) IS

Line 930: , p_dep_routingstep_no IN fm_rout_dep.routingstep_no%TYPE := NULL

926: /* Shyam 07/29/2002 Initial implementation */
927: /* =============================================================== */
928: PROCEDURE delete_step_dependencies
929: ( p_routingstep_no IN fm_rout_dep.routingstep_no%TYPE
930: , p_dep_routingstep_no IN fm_rout_dep.routingstep_no%TYPE := NULL
931: , p_routing_id IN fm_rout_dep.routing_id%TYPE
932: , x_return_status OUT NOCOPY VARCHAR2
933: ) IS
934:

Line 931: , p_routing_id IN fm_rout_dep.routing_id%TYPE

927: /* =============================================================== */
928: PROCEDURE delete_step_dependencies
929: ( p_routingstep_no IN fm_rout_dep.routingstep_no%TYPE
930: , p_dep_routingstep_no IN fm_rout_dep.routingstep_no%TYPE := NULL
931: , p_routing_id IN fm_rout_dep.routing_id%TYPE
932: , x_return_status OUT NOCOPY VARCHAR2
933: ) IS
934:
935: /* Local variable section */

Line 952: /* Actual delete in fm_rout_dep table */

948:
949: /* Set the return status to success initially */
950: x_return_status := FND_API.G_RET_STS_SUCCESS;
951:
952: /* Actual delete in fm_rout_dep table */
953: /* This delete can be specific to a dep_routingstep_no or a
954: Routingstep_no */
955: IF (l_debug = 'Y') THEN
956: gmd_Debug.put_line('About to delete from step dep table - the routingstep no = '||p_routingstep_no ||' and routing id = '||p_routing_id);

Line 968: DELETE FROM fm_rout_dep

964: RAISE setup_failure;
965: END IF;
966:
967: IF p_dep_routingstep_no IS NOT NULL THEN
968: DELETE FROM fm_rout_dep
969: WHERE routingstep_no = p_routingstep_no
970: AND dep_routingstep_no = p_dep_routingstep_no
971: AND routing_id = p_routing_id;
972: ELSE /* this would all dep steps for this step */

Line 973: DELETE FROM fm_rout_dep

969: WHERE routingstep_no = p_routingstep_no
970: AND dep_routingstep_no = p_dep_routingstep_no
971: AND routing_id = p_routing_id;
972: ELSE /* this would all dep steps for this step */
973: DELETE FROM fm_rout_dep
974: WHERE routingstep_no = p_routingstep_no
975: AND routing_id = p_routing_id;
976: DELETE FROM fm_rout_dep
977: WHERE dep_routingstep_no = p_routingstep_no

Line 976: DELETE FROM fm_rout_dep

972: ELSE /* this would all dep steps for this step */
973: DELETE FROM fm_rout_dep
974: WHERE routingstep_no = p_routingstep_no
975: AND routing_id = p_routing_id;
976: DELETE FROM fm_rout_dep
977: WHERE dep_routingstep_no = p_routingstep_no
978: AND routing_id = p_routing_id;
979: END IF;
980: