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_DTL

Line 27: /* details (fm_rout_dtl) table is successfully. */

23: /* */
24: /* DESCRIPTION: */
25: /* */
26: /* API returns (x_return_code) = 'S' if the insert into routing */
27: /* details (fm_rout_dtl) table is successfully. */
28: /* */
29: /* History : */
30: /* Shyam 07/29/2002 Initial implementation */
31: /* Raju 31-OCT-02 Changed the code to add default values. */

Line 36: , p_routing_step_rec IN fm_rout_dtl%ROWTYPE

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

Line 43: l_routingStep_id fm_rout_dtl.routingStep_id%TYPE;

39:
40: /* Local variable section */
41: l_api_name CONSTANT VARCHAR2(30) := 'INSERT_ROUTING_STEPS';
42: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
43: l_routingStep_id fm_rout_dtl.routingStep_id%TYPE;
44: l_steprelease_type fm_rout_dtl.steprelease_type%TYPE;
45:
46: /*define cursor */
47: /* get routing step id sequence */

Line 44: l_steprelease_type fm_rout_dtl.steprelease_type%TYPE;

40: /* Local variable section */
41: l_api_name CONSTANT VARCHAR2(30) := 'INSERT_ROUTING_STEPS';
42: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
43: l_routingStep_id fm_rout_dtl.routingStep_id%TYPE;
44: l_steprelease_type fm_rout_dtl.steprelease_type%TYPE;
45:
46: /*define cursor */
47: /* get routing step id sequence */
48: CURSOR Get_routingstep_id_seq IS

Line 93: INSERT INTO fm_rout_dtl

89: IF (l_debug = 'Y') THEN
90: gmd_debug.put_line('Insert the routing steps for routing with routingstep id = '||l_routingstep_id);
91: END IF;
92:
93: INSERT INTO fm_rout_dtl
94: ( routing_id, routingstep_no, routingstep_id , oprn_id ,step_qty, steprelease_type, text_code
95: ,last_updated_by, created_by, last_update_date, creation_date, last_update_login
96: ,attribute1, attribute2, attribute3, attribute4, attribute5 , attribute6 , attribute7
97: ,attribute8 , attribute9 , attribute10 , attribute11 , attribute12, attribute13

Line 161: , p_routingstep_no IN fm_rout_dtl.routingstep_no%TYPE

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

Line 169: From fm_rout_dtl

165:
166: /* Cursor section */
167: CURSOR get_step_qty (vRouting_id NUMBER,vroutingstep_no NUMBER) IS
168: Select step_qty
169: From fm_rout_dtl
170: Where routing_id = vRouting_id
171: AND routingstep_no = vroutingstep_no;
172:
173: /* Local variable section */

Line 297: /* details (fm_rout_dtl table) is success. */

293: /* */
294: /* DESCRIPTION: */
295: /* */
296: /* API returns (x_return_code) = 'S' if the update into routing */
297: /* details (fm_rout_dtl table) is success. */
298: /* */
299: /* History : */
300: /* Shyam 07/29/2002 Initial implementation */
301: /* =============================================================== */

Line 303: ( p_routingstep_id IN fm_rout_dtl.routingstep_id%TYPE

299: /* History : */
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:

Line 310: l_routingstep_id fm_rout_dtl.routingStep_id%TYPE;

306: ) IS
307:
308: /* Local variable section */
309: l_api_name CONSTANT VARCHAR2(30) := 'UPDATE_ROUTING_STEPS';
310: l_routingstep_id fm_rout_dtl.routingStep_id%TYPE;
311: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
312: l_db_date DATE;
313:
314: /* Define record type that hold the routing data */

Line 315: l_old_routingStep_rec fm_rout_dtl%ROWTYPE;

311: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
312: l_db_date DATE;
313:
314: /* Define record type that hold the routing data */
315: l_old_routingStep_rec fm_rout_dtl%ROWTYPE;
316:
317: /* Define Exceptions */
318: last_update_date_failure EXCEPTION;
319: routing_update_step_failure EXCEPTION;

Line 323: CURSOR get_old_routingStep_rec(vRoutingStep_id fm_rout_dtl.routingStep_id%TYPE) IS

319: routing_update_step_failure EXCEPTION;
320: invalid_version EXCEPTION;
321: setup_failure EXCEPTION;
322:
323: CURSOR get_old_routingStep_rec(vRoutingStep_id fm_rout_dtl.routingStep_id%TYPE) IS
324: Select *
325: From fm_rout_dtl
326: Where RoutingStep_id = vRoutingStep_id;
327:

Line 325: From fm_rout_dtl

321: setup_failure EXCEPTION;
322:
323: CURSOR get_old_routingStep_rec(vRoutingStep_id fm_rout_dtl.routingStep_id%TYPE) IS
324: Select *
325: From fm_rout_dtl
326: Where RoutingStep_id = vRoutingStep_id;
327:
328: BEGIN
329: /* Set the return status to success initially */

Line 358: /* Actual update in fm_rout_dtl table */

354:
355: /* Get the last update date from database */
356: l_db_date := l_old_routingStep_rec.LAST_UPDATE_DATE;
357:
358: /* Actual update in fm_rout_dtl table */
359: /* Loop thro' every column in p_update_table table and for each column name
360: assign or replace the old value with the table value */
361: IF (l_debug = 'Y') THEN
362: gmd_debug.put_line('Seting the update column value ');

Line 461: UPDATE fm_rout_dtl

457:
458: IF (l_debug = 'Y') THEN
459: gmd_debug.put_line('Before routing step table update ');
460: END IF;
461: UPDATE fm_rout_dtl
462: SET oprn_id = l_old_routingStep_rec.oprn_id
463: ,step_qty = l_old_routingStep_rec.step_qty
464: ,steprelease_type = l_old_routingStep_rec.steprelease_type
465: ,text_code = l_old_routingStep_rec.text_code

Line 715: ( p_routingstep_id IN fm_rout_dtl.routingstep_id%TYPE

711: /* History : */
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:

Line 724: l_routingStep_id fm_rout_dtl.routingStep_id%TYPE;

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

Line 880: DELETE FROM fm_rout_dtl

876: END IF; /* IF l_return_from_routing_step_dep <> FND_API.G_RET_STS_SUCCESS */
877: END IF; /* l_stepdep_count > 0 */
878:
879: /* Actual delete is performed */
880: DELETE FROM fm_rout_dtl
881: WHERE routingStep_id = p_routingStep_id;
882:
883: IF (l_debug = 'Y') THEN
884: gmd_debug.put_line('Completed '||l_api_name ||' at '||to_char(sysdate,'MM/DD/YYYY HH24:MI:SS'));