APPS.GMD_ROUTING_STEPS_PVT dependencies on GMD_ROUTINGS

Line 35: ( p_routing_id IN gmd_routings.routing_id%TYPE

31: /* Raju 31-OCT-02 Changed the code to add default values. */
32: /* Raju 18-NOV-02 Tested in opm115qa db and fixed the issues */
33: /* =============================================================== */
34: PROCEDURE insert_routing_steps
35: ( p_routing_id IN gmd_routings.routing_id%TYPE
36: , p_routing_step_rec IN fm_rout_dtl%ROWTYPE
37: , x_return_status OUT NOCOPY VARCHAR2
38: ) IS
39:

Line 160: ( p_routing_id IN gmd_routings.routing_id%TYPE

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
162: , p_routings_step_dep_tbl IN GMD_ROUTINGS_PUB.gmd_routings_step_dep_tab
163: , x_return_status OUT NOCOPY VARCHAR2
164: ) IS

Line 162: , p_routings_step_dep_tbl IN GMD_ROUTINGS_PUB.gmd_routings_step_dep_tab

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
162: , p_routings_step_dep_tbl IN GMD_ROUTINGS_PUB.gmd_routings_step_dep_tab
163: , x_return_status OUT NOCOPY VARCHAR2
164: ) IS
165:
166: /* Cursor section */

Line 304: , p_update_table IN GMD_ROUTINGS_PUB.update_tbl_type

300: /* Shyam 07/29/2002 Initial implementation */
301: /* =============================================================== */
302: PROCEDURE update_routing_steps
303: ( p_routingstep_id IN fm_rout_dtl.routingstep_id%TYPE
304: , p_update_table IN GMD_ROUTINGS_PUB.update_tbl_type
305: , x_return_status OUT NOCOPY VARCHAR2
306: ) IS
307:
308: /* Local variable section */

Line 348: FND_MESSAGE.SET_NAME('GMD', 'GMD_ROUTINGSTEP_INVALID');

344:
345: OPEN get_old_routingStep_rec(p_routingStep_id);
346: FETCH get_old_routingStep_rec INTO l_old_routingStep_rec;
347: IF get_old_routingStep_rec%NOTFOUND THEN
348: FND_MESSAGE.SET_NAME('GMD', 'GMD_ROUTINGSTEP_INVALID');
349: FND_MSG_PUB.ADD;
350: CLOSE get_old_routingStep_rec;
351: RAISE routing_update_step_failure;
352: END IF;

Line 557: , p_update_table IN GMD_ROUTINGS_PUB.update_tbl_type

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:
561: /* Local variable section */

Line 716: , p_routing_id IN gmd_routings.routing_id%TYPE := NULL

712: /* Shyam 07/29/2002 Initial implementation */
713: /* =============================================================== */
714: PROCEDURE delete_routing_step
715: ( p_routingstep_id IN fm_rout_dtl.routingstep_id%TYPE
716: , p_routing_id IN gmd_routings.routing_id%TYPE := NULL
717: , x_return_status OUT NOCOPY VARCHAR2
718: ) IS
719:
720: /* Local variable section */

Line 733: ,vRouting_id gmd_routings.Routing_id%TYPE) IS

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)
737: And routing_id = vrouting_id;

Line 803: FND_MESSAGE.SET_NAME('GMD', 'GMD_ROUTINGSTEP_INVALID');

799: ,pxRoutingStep_id => l_routingstep_id
800: ,x_return_status => l_return_status );
801: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
802: /* it indicates that this routing does'ntexists */
803: FND_MESSAGE.SET_NAME('GMD', 'GMD_ROUTINGSTEP_INVALID');
804: FND_MSG_PUB.ADD;
805: RAISE routing_delete_step_failure;
806: END IF;
807: END IF;