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.FM_ROUT_DEP_DBL dependencies on FM_ROUT_DEP

Line 1: PACKAGE BODY FM_ROUT_DEP_DBL AS

1: PACKAGE BODY FM_ROUT_DEP_DBL AS
2: /* $Header: GMDPRDDB.pls 120.1 2011/05/11 15:36:00 rnalla ship $ */
3: /*============================================================================
4: | Copyright (c) 2001 Oracle Corporation
5: | TVP, Reading

Line 12: | Package body for FM_ROUT_DEP table handlers

8: | FILENAME
9: | GMDPRDDB.pls
10: |
11: | DESCRIPTION
12: | Package body for FM_ROUT_DEP table handlers
13: |
14: |
15: |
16: | NOTES

Line 39: | Insert_Row will insert a row in fm_rout_dep

Line 43: | Insert_Row will insert a row in fm_rout_dep

39: | Insert_Row will insert a row in fm_rout_dep
40: |
41: |
42: | DESCRIPTION
43: | Insert_Row will insert a row in fm_rout_dep
44: |
45: |
46: |
47: | PARAMETERS

Line 48: | p_out_dep IN fm_rout_dep%ROWTYPE

44: |
45: |
46: |
47: | PARAMETERS
48: | p_out_dep IN fm_rout_dep%ROWTYPE
49: | x_out_dep OUT fm_rout_dep%ROWTYPE
50: |
51: | RETURNS
52: | BOOLEAN

Line 49: | x_out_dep OUT fm_rout_dep%ROWTYPE

Line 62: p_out_dep IN FM_ROUT_DEP%ROWTYPE) RETURN BOOLEAN IS

58: Api end of comments
59: */
60:
61: FUNCTION insert_row (
62: p_out_dep IN FM_ROUT_DEP%ROWTYPE) RETURN BOOLEAN IS
63: BEGIN
64:
65: INSERT INTO FM_ROUT_DEP
66: (

Line 65: INSERT INTO FM_ROUT_DEP

61: FUNCTION insert_row (
62: p_out_dep IN FM_ROUT_DEP%ROWTYPE) RETURN BOOLEAN IS
63: BEGIN
64:
65: INSERT INTO FM_ROUT_DEP
66: (
67: ROUTINGSTEP_NO
68: ,DEP_ROUTINGSTEP_NO
69: ,ROUTING_ID

Line 123: | Fetch_Row will fetch a row in fm_rout_dep

Line 127: | Fetch_Row will fetch a row in fm_rout_dep

123: | Fetch_Row will fetch a row in fm_rout_dep
124: |
125: |
126: | DESCRIPTION
127: | Fetch_Row will fetch a row in fm_rout_dep
128: |
129: |
130: |
131: | PARAMETERS

Line 132: | p_out_dep IN fm_rout_dep%ROWTYPE

128: |
129: |
130: |
131: | PARAMETERS
132: | p_out_dep IN fm_rout_dep%ROWTYPE
133: | x_out_dep OUT fm_rout_dep%ROWTYPE
134: |
135: | RETURNS
136: | BOOLEAN

Line 133: | x_out_dep OUT fm_rout_dep%ROWTYPE

Line 147: p_out_dep IN FM_ROUT_DEP%ROWTYPE

143: Api end of comments
144: */
145:
146: FUNCTION fetch_row (
147: p_out_dep IN FM_ROUT_DEP%ROWTYPE
148: , x_out_dep OUT NOCOPY FM_ROUT_DEP%ROWTYPE) RETURN BOOLEAN IS
149: BEGIN
150: IF p_out_dep.routingstep_no IS NOT NULL
151: AND p_out_dep.dep_routingstep_no IS NOT NULL

Line 148: , x_out_dep OUT NOCOPY FM_ROUT_DEP%ROWTYPE) RETURN BOOLEAN IS

144: */
145:
146: FUNCTION fetch_row (
147: p_out_dep IN FM_ROUT_DEP%ROWTYPE
148: , x_out_dep OUT NOCOPY FM_ROUT_DEP%ROWTYPE) RETURN BOOLEAN IS
149: BEGIN
150: IF p_out_dep.routingstep_no IS NOT NULL
151: AND p_out_dep.dep_routingstep_no IS NOT NULL
152: AND p_out_dep.routing_id IS NOT NULL

Line 190: FROM fm_rout_dep

186: ,x_out_dep.LAST_UPDATE_DATE
187: ,x_out_dep.CREATION_DATE
188: ,x_out_dep.LAST_UPDATE_LOGIN
189: ,x_out_dep.TRANSFER_PCT
190: FROM fm_rout_dep
191: WHERE routingstep_no = p_out_dep.routingstep_no
192: AND dep_routingstep_no = p_out_dep.dep_routingstep_no
193: AND routing_id = p_out_dep.routing_id
194: ;

Line 222: | Delete_Row will delete a row in fm_rout_dep

Line 226: | Delete_Row will delete a row in fm_rout_dep

222: | Delete_Row will delete a row in fm_rout_dep
223: |
224: |
225: | DESCRIPTION
226: | Delete_Row will delete a row in fm_rout_dep
227: |
228: |
229: |
230: | PARAMETERS

Line 231: | p_out_dep IN fm_rout_dep%ROWTYPE

227: |
228: |
229: |
230: | PARAMETERS
231: | p_out_dep IN fm_rout_dep%ROWTYPE
232: |
233: | RETURNS
234: | BOOLEAN
235: | HISTORY

Line 245: p_out_dep IN FM_ROUT_DEP%ROWTYPE) RETURN BOOLEAN IS

241: Api end of comments
242: */
243:
244: FUNCTION delete_row (
245: p_out_dep IN FM_ROUT_DEP%ROWTYPE) RETURN BOOLEAN IS
246: BEGIN
247: IF p_out_dep.routingstep_no IS NOT NULL
248: AND p_out_dep.dep_routingstep_no IS NOT NULL
249: AND p_out_dep.routing_id IS NOT NULL

Line 251: DELETE FROM fm_rout_dep

247: IF p_out_dep.routingstep_no IS NOT NULL
248: AND p_out_dep.dep_routingstep_no IS NOT NULL
249: AND p_out_dep.routing_id IS NOT NULL
250: THEN
251: DELETE FROM fm_rout_dep
252: WHERE routingstep_no = p_out_dep.routingstep_no
253: AND dep_routingstep_no = p_out_dep.dep_routingstep_no
254: AND routing_id = p_out_dep.routing_id
255: ;

Line 285: | Update_Row will update a row in fm_rout_dep

Line 289: | Update_Row will update a row in fm_rout_dep

285: | Update_Row will update a row in fm_rout_dep
286: |
287: |
288: | DESCRIPTION
289: | Update_Row will update a row in fm_rout_dep
290: |
291: |
292: |
293: | PARAMETERS

Line 294: | p_out_dep IN fm_rout_dep%ROWTYPE

290: |
291: |
292: |
293: | PARAMETERS
294: | p_out_dep IN fm_rout_dep%ROWTYPE
295: |
296: | RETURNS
297: | BOOLEAN
298: | HISTORY

Line 308: p_out_dep IN FM_ROUT_DEP%ROWTYPE) RETURN BOOLEAN IS

304: Api end of comments
305: */
306:
307: FUNCTION update_row (
308: p_out_dep IN FM_ROUT_DEP%ROWTYPE) RETURN BOOLEAN IS
309: l_dummy NUMBER;
310: locked_by_other_user EXCEPTION;
311: PRAGMA EXCEPTION_INIT (locked_by_other_user, -54);
312: BEGIN

Line 317: SELECT 1 INTO l_dummy FROM fm_rout_dep

313: IF p_out_dep.routingstep_no IS NOT NULL
314: AND p_out_dep.dep_routingstep_no IS NOT NULL
315: AND p_out_dep.routing_id IS NOT NULL
316: THEN
317: SELECT 1 INTO l_dummy FROM fm_rout_dep
318: WHERE routingstep_no = p_out_dep.routingstep_no
319: AND dep_routingstep_no = p_out_dep.dep_routingstep_no
320: AND routing_id = p_out_dep.routing_id
321: FOR UPDATE NOWAIT;

Line 323: UPDATE fm_rout_dep

319: AND dep_routingstep_no = p_out_dep.dep_routingstep_no
320: AND routing_id = p_out_dep.routing_id
321: FOR UPDATE NOWAIT;
322:
323: UPDATE fm_rout_dep
324: SET
325: ROUTINGSTEP_NO = p_out_dep.ROUTINGSTEP_NO
326: ,DEP_ROUTINGSTEP_NO = p_out_dep.DEP_ROUTINGSTEP_NO
327: ,ROUTING_ID = p_out_dep.ROUTING_ID

Line 379: | Lock_Row will lock a row in fm_rout_dep

Line 383: | Lock_Row will lock a row in fm_rout_dep

379: | Lock_Row will lock a row in fm_rout_dep
380: |
381: |
382: | DESCRIPTION
383: | Lock_Row will lock a row in fm_rout_dep
384: |
385: |
386: |
387: | PARAMETERS

Line 388: | p_out_dep IN fm_rout_dep%ROWTYPE

384: |
385: |
386: |
387: | PARAMETERS
388: | p_out_dep IN fm_rout_dep%ROWTYPE
389: |
390: | RETURNS
391: | BOOLEAN
392: | HISTORY

Line 402: p_out_dep IN FM_ROUT_DEP%ROWTYPE) RETURN BOOLEAN IS

398: Api end of comments
399: */
400:
401: FUNCTION lock_row (
402: p_out_dep IN FM_ROUT_DEP%ROWTYPE) RETURN BOOLEAN IS
403: l_dummy NUMBER;
404: BEGIN
405: IF p_out_dep.routingstep_no IS NOT NULL
406: AND p_out_dep.dep_routingstep_no IS NOT NULL

Line 409: SELECT 1 INTO l_dummy FROM fm_rout_dep

405: IF p_out_dep.routingstep_no IS NOT NULL
406: AND p_out_dep.dep_routingstep_no IS NOT NULL
407: AND p_out_dep.routing_id IS NOT NULL
408: THEN
409: SELECT 1 INTO l_dummy FROM fm_rout_dep
410: WHERE routingstep_no = p_out_dep.routingstep_no
411: AND dep_routingstep_no = p_out_dep.dep_routingstep_no
412: AND routing_id = p_out_dep.routing_id
413: FOR UPDATE NOWAIT;

Line 422: END FM_ROUT_DEP_DBL;

418: RETURN FALSE;
419: END lock_row;
420:
421:
422: END FM_ROUT_DEP_DBL;