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.

[Home] [Help]

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 115.2 2002/11/08 23:04:56 txdaniel noship $ */
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 63: p_out_dep IN FM_ROUT_DEP%ROWTYPE) RETURN BOOLEAN IS

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

Line 66: INSERT INTO FM_ROUT_DEP

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

Line 124: | Fetch_Row will fetch a row in fm_rout_dep

Line 128: | Fetch_Row will fetch a row in fm_rout_dep

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

Line 133: | p_out_dep IN fm_rout_dep%ROWTYPE

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

Line 134: | x_out_dep OUT fm_rout_dep%ROWTYPE

Line 148: p_out_dep IN FM_ROUT_DEP%ROWTYPE

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

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

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

Line 191: FROM fm_rout_dep

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

Line 223: | Delete_Row will delete a row in fm_rout_dep

Line 227: | Delete_Row will delete a row in fm_rout_dep

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

Line 232: | p_out_dep IN fm_rout_dep%ROWTYPE

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

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

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

Line 252: DELETE FROM fm_rout_dep

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

Line 286: | Update_Row will update a row in fm_rout_dep

Line 290: | Update_Row will update a row in fm_rout_dep

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

Line 295: | p_out_dep IN fm_rout_dep%ROWTYPE

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

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

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

Line 318: SELECT 1 INTO l_dummy FROM fm_rout_dep

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

Line 324: UPDATE fm_rout_dep

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

Line 380: | Lock_Row will lock a row in fm_rout_dep

Line 384: | Lock_Row will lock a row in fm_rout_dep

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

Line 389: | p_out_dep IN fm_rout_dep%ROWTYPE

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

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

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

Line 410: SELECT 1 INTO l_dummy FROM fm_rout_dep

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

Line 423: END FM_ROUT_DEP_DBL;

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