DBA Data[Home] [Help]

APPS.GME_BATCH_STEP_DEPEND_DBL dependencies on GME_BATCH_STEP_DEPENDENCIES

Line 5: g_table_name VARCHAR2 (80) DEFAULT 'GME_BATCH_STEP_DEPENDENCIES';

1: PACKAGE BODY gme_batch_step_depend_dbl AS
2: /* $Header: GMEVGSDB.pls 120.1 2005/06/03 13:46:57 appldev $ */
3:
4: /* Global Variables */
5: g_table_name VARCHAR2 (80) DEFAULT 'GME_BATCH_STEP_DEPENDENCIES';
6:
7: /*============================================================================
8: | Copyright (c) 2001 Oracle Corporation
9: | TVP, Reading

Line 42: | Insert_Row will insert a row in gme_batch_step_dependencies

38: |
39: | TYPE
40: | Private
41: | USAGE
42: | Insert_Row will insert a row in gme_batch_step_dependencies
43: |
44: |
45: | DESCRIPTION
46: | Insert_Row will insert a row in gme_batch_step_dependencies

Line 46: | Insert_Row will insert a row in gme_batch_step_dependencies

42: | Insert_Row will insert a row in gme_batch_step_dependencies
43: |
44: |
45: | DESCRIPTION
46: | Insert_Row will insert a row in gme_batch_step_dependencies
47: |
48: |
49: |
50: | PARAMETERS

Line 51: | p_batch_step_dependencies IN gme_batch_step_dependencies%ROWTYPE

47: |
48: |
49: |
50: | PARAMETERS
51: | p_batch_step_dependencies IN gme_batch_step_dependencies%ROWTYPE
52: | x_batch_step_dependencies IN OUT NOCOPY gme_batch_step_dependencies%ROWTYPE
53: |
54: | RETURNS
55: | BOOLEAN

Line 52: | x_batch_step_dependencies IN OUT NOCOPY gme_batch_step_dependencies%ROWTYPE

48: |
49: |
50: | PARAMETERS
51: | p_batch_step_dependencies IN gme_batch_step_dependencies%ROWTYPE
52: | x_batch_step_dependencies IN OUT NOCOPY gme_batch_step_dependencies%ROWTYPE
53: |
54: | RETURNS
55: | BOOLEAN
56: | HISTORY

Line 65: p_batch_step_dependencies IN gme_batch_step_dependencies%ROWTYPE

61: +=============================================================================
62: Api end of comments
63: */
64: FUNCTION insert_row (
65: p_batch_step_dependencies IN gme_batch_step_dependencies%ROWTYPE
66: ,x_batch_step_dependencies IN OUT NOCOPY gme_batch_step_dependencies%ROWTYPE)
67: RETURN BOOLEAN
68: IS
69: BEGIN

Line 66: ,x_batch_step_dependencies IN OUT NOCOPY gme_batch_step_dependencies%ROWTYPE)

62: Api end of comments
63: */
64: FUNCTION insert_row (
65: p_batch_step_dependencies IN gme_batch_step_dependencies%ROWTYPE
66: ,x_batch_step_dependencies IN OUT NOCOPY gme_batch_step_dependencies%ROWTYPE)
67: RETURN BOOLEAN
68: IS
69: BEGIN
70: x_batch_step_dependencies := p_batch_step_dependencies;

Line 72: INSERT INTO gme_batch_step_dependencies

68: IS
69: BEGIN
70: x_batch_step_dependencies := p_batch_step_dependencies;
71:
72: INSERT INTO gme_batch_step_dependencies
73: (batch_id
74: ,batchstep_id
75: ,dep_type
76: ,dep_step_id

Line 184: | Fetch_Row will fetch a row in gme_batch_step_dependencies

180: |
181: | TYPE
182: | Private
183: | USAGE
184: | Fetch_Row will fetch a row in gme_batch_step_dependencies
185: |
186: |
187: | DESCRIPTION
188: | Fetch_Row will fetch a row in gme_batch_step_dependencies

Line 188: | Fetch_Row will fetch a row in gme_batch_step_dependencies

184: | Fetch_Row will fetch a row in gme_batch_step_dependencies
185: |
186: |
187: | DESCRIPTION
188: | Fetch_Row will fetch a row in gme_batch_step_dependencies
189: |
190: |
191: |
192: | PARAMETERS

Line 193: | p_batch_step_dependencies IN gme_batch_step_dependencies%ROWTYPE

189: |
190: |
191: |
192: | PARAMETERS
193: | p_batch_step_dependencies IN gme_batch_step_dependencies%ROWTYPE
194: | x_batch_step_dependencies IN OUT NOCOPY gme_batch_step_dependencies%ROWTYPE
195: |
196: | RETURNS
197: | BOOLEAN

Line 194: | x_batch_step_dependencies IN OUT NOCOPY gme_batch_step_dependencies%ROWTYPE

190: |
191: |
192: | PARAMETERS
193: | p_batch_step_dependencies IN gme_batch_step_dependencies%ROWTYPE
194: | x_batch_step_dependencies IN OUT NOCOPY gme_batch_step_dependencies%ROWTYPE
195: |
196: | RETURNS
197: | BOOLEAN
198: | HISTORY

Line 207: p_batch_step_dependencies IN gme_batch_step_dependencies%ROWTYPE

203: +=============================================================================
204: Api end of comments
205: */
206: FUNCTION fetch_row (
207: p_batch_step_dependencies IN gme_batch_step_dependencies%ROWTYPE
208: ,x_batch_step_dependencies IN OUT NOCOPY gme_batch_step_dependencies%ROWTYPE)
209: RETURN BOOLEAN
210: IS
211: BEGIN

Line 208: ,x_batch_step_dependencies IN OUT NOCOPY gme_batch_step_dependencies%ROWTYPE)

204: Api end of comments
205: */
206: FUNCTION fetch_row (
207: p_batch_step_dependencies IN gme_batch_step_dependencies%ROWTYPE
208: ,x_batch_step_dependencies IN OUT NOCOPY gme_batch_step_dependencies%ROWTYPE)
209: RETURN BOOLEAN
210: IS
211: BEGIN
212: IF p_batch_step_dependencies.batch_id IS NOT NULL

Line 313: FROM gme_batch_step_dependencies

309: ,x_batch_step_dependencies.attribute29
310: ,x_batch_step_dependencies.attribute30
311: ,x_batch_step_dependencies.attribute_category
312: ,x_batch_step_dependencies.chargeable_ind
313: FROM gme_batch_step_dependencies
314: WHERE batch_id = p_batch_step_dependencies.batch_id
315: AND batchstep_id = p_batch_step_dependencies.batchstep_id
316: AND dep_step_id = p_batch_step_dependencies.dep_step_id;
317: ELSE

Line 345: | Delete_Row will delete a row in gme_batch_step_dependencies

341: |
342: | TYPE
343: | Private
344: | USAGE
345: | Delete_Row will delete a row in gme_batch_step_dependencies
346: |
347: |
348: | DESCRIPTION
349: | Delete_Row will delete a row in gme_batch_step_dependencies

Line 349: | Delete_Row will delete a row in gme_batch_step_dependencies

345: | Delete_Row will delete a row in gme_batch_step_dependencies
346: |
347: |
348: | DESCRIPTION
349: | Delete_Row will delete a row in gme_batch_step_dependencies
350: |
351: |
352: |
353: | PARAMETERS

Line 354: | p_batch_step_dependencies IN gme_batch_step_dependencies%ROWTYPE

350: |
351: |
352: |
353: | PARAMETERS
354: | p_batch_step_dependencies IN gme_batch_step_dependencies%ROWTYPE
355: |
356: | RETURNS
357: | BOOLEAN
358: | HISTORY

Line 368: p_batch_step_dependencies IN gme_batch_step_dependencies%ROWTYPE)

364: +=============================================================================
365: Api end of comments
366: */
367: FUNCTION delete_row (
368: p_batch_step_dependencies IN gme_batch_step_dependencies%ROWTYPE)
369: RETURN BOOLEAN
370: IS
371: l_dummy NUMBER (5) := 0;
372: x_batchstep_no NUMBER;

Line 388: FROM gme_batch_step_dependencies

384: AND batch_id = p_batch_step_dependencies.batch_id;
385:
386: SELECT 1
387: INTO l_dummy
388: FROM gme_batch_step_dependencies
389: WHERE batch_id = p_batch_step_dependencies.batch_id
390: AND batchstep_id = p_batch_step_dependencies.batchstep_id
391: AND dep_step_id = p_batch_step_dependencies.dep_step_id
392: FOR UPDATE NOWAIT;

Line 394: DELETE FROM gme_batch_step_dependencies

390: AND batchstep_id = p_batch_step_dependencies.batchstep_id
391: AND dep_step_id = p_batch_step_dependencies.dep_step_id
392: FOR UPDATE NOWAIT;
393:
394: DELETE FROM gme_batch_step_dependencies
395: WHERE batch_id = p_batch_step_dependencies.batch_id
396: AND batchstep_id = p_batch_step_dependencies.batchstep_id
397: AND dep_step_id = p_batch_step_dependencies.dep_step_id;
398: ELSE

Line 456: | Update_Row will update a row in gme_batch_step_dependencies

452: |
453: | TYPE
454: | Private
455: | USAGE
456: | Update_Row will update a row in gme_batch_step_dependencies
457: |
458: |
459: | DESCRIPTION
460: | Update_Row will update a row in gme_batch_step_dependencies

Line 460: | Update_Row will update a row in gme_batch_step_dependencies

456: | Update_Row will update a row in gme_batch_step_dependencies
457: |
458: |
459: | DESCRIPTION
460: | Update_Row will update a row in gme_batch_step_dependencies
461: |
462: |
463: |
464: | PARAMETERS

Line 465: | p_batch_step_dependencies IN gme_batch_step_dependencies%ROWTYPE

461: |
462: |
463: |
464: | PARAMETERS
465: | p_batch_step_dependencies IN gme_batch_step_dependencies%ROWTYPE
466: |
467: | RETURNS
468: | BOOLEAN
469: | HISTORY

Line 481: p_batch_step_dependencies IN gme_batch_step_dependencies%ROWTYPE)

477: +=============================================================================
478: Api end of comments
479: */
480: FUNCTION update_row (
481: p_batch_step_dependencies IN gme_batch_step_dependencies%ROWTYPE)
482: RETURN BOOLEAN
483: IS
484: l_dummy NUMBER := 0;
485: x_batchstep_no NUMBER;

Line 501: FROM gme_batch_step_dependencies

497: AND batch_id = p_batch_step_dependencies.batch_id;
498:
499: SELECT 1
500: INTO l_dummy
501: FROM gme_batch_step_dependencies
502: WHERE batch_id = p_batch_step_dependencies.batch_id
503: AND batchstep_id = p_batch_step_dependencies.batchstep_id
504: AND dep_step_id = p_batch_step_dependencies.dep_step_id
505: FOR UPDATE NOWAIT;

Line 507: UPDATE gme_batch_step_dependencies

503: AND batchstep_id = p_batch_step_dependencies.batchstep_id
504: AND dep_step_id = p_batch_step_dependencies.dep_step_id
505: FOR UPDATE NOWAIT;
506:
507: UPDATE gme_batch_step_dependencies
508: SET dep_type = p_batch_step_dependencies.dep_type
509: ,rework_code = p_batch_step_dependencies.rework_code
510: ,standard_delay = p_batch_step_dependencies.standard_delay
511: ,min_delay = p_batch_step_dependencies.min_delay

Line 620: | Lock_Row will lock a row in gme_batch_step_dependencies

616: |
617: | TYPE
618: | Private
619: | USAGE
620: | Lock_Row will lock a row in gme_batch_step_dependencies
621: |
622: |
623: | DESCRIPTION
624: | Lock_Row will lock a row in gme_batch_step_dependencies

Line 624: | Lock_Row will lock a row in gme_batch_step_dependencies

620: | Lock_Row will lock a row in gme_batch_step_dependencies
621: |
622: |
623: | DESCRIPTION
624: | Lock_Row will lock a row in gme_batch_step_dependencies
625: |
626: |
627: |
628: | PARAMETERS

Line 629: | p_batch_step_dependencies IN gme_batch_step_dependencies%ROWTYPE

625: |
626: |
627: |
628: | PARAMETERS
629: | p_batch_step_dependencies IN gme_batch_step_dependencies%ROWTYPE
630: |
631: | RETURNS
632: | BOOLEAN
633: | HISTORY

Line 642: p_batch_step_dependencies IN gme_batch_step_dependencies%ROWTYPE)

638: +=============================================================================
639: Api end of comments
640: */
641: FUNCTION lock_row (
642: p_batch_step_dependencies IN gme_batch_step_dependencies%ROWTYPE)
643: RETURN BOOLEAN
644: IS
645: l_dummy NUMBER;
646: x_batchstep_no NUMBER;

Line 660: FROM gme_batch_step_dependencies

656: AND batch_id = p_batch_step_dependencies.batch_id;
657:
658: SELECT 1
659: INTO l_dummy
660: FROM gme_batch_step_dependencies
661: WHERE batch_id = p_batch_step_dependencies.batch_id
662: AND batchstep_id = p_batch_step_dependencies.batchstep_id
663: AND dep_step_id = p_batch_step_dependencies.dep_step_id
664: FOR UPDATE NOWAIT;