1: PACKAGE BODY gme_material_details_dbl AS
2: /* $Header: GMEVGMDB.pls 120.3.12010000.2 2009/02/27 20:19:17 gmurator ship $ */
3:
4: /* Global Variables */
5: g_table_name VARCHAR2 (80) DEFAULT 'GME_MATERIAL_DETAILS';
1: PACKAGE BODY gme_material_details_dbl AS
2: /* $Header: GMEVGMDB.pls 120.3.12010000.2 2009/02/27 20:19:17 gmurator ship $ */
3:
4: /* Global Variables */
5: g_table_name VARCHAR2 (80) DEFAULT 'GME_MATERIAL_DETAILS';
6: g_pkg_name CONSTANT VARCHAR2 (30) := 'GME_MATERIAL_DETAILS_DBL';
7: g_debug VARCHAR2 (5) := fnd_profile.VALUE ('AFLOG_LEVEL');
8:
9: /* ===========================================================================
2: /* $Header: GMEVGMDB.pls 120.3.12010000.2 2009/02/27 20:19:17 gmurator ship $ */
3:
4: /* Global Variables */
5: g_table_name VARCHAR2 (80) DEFAULT 'GME_MATERIAL_DETAILS';
6: g_pkg_name CONSTANT VARCHAR2 (30) := 'GME_MATERIAL_DETAILS_DBL';
7: g_debug VARCHAR2 (5) := fnd_profile.VALUE ('AFLOG_LEVEL');
8:
9: /* ===========================================================================
10: | Copyright (c) 2001 Oracle Corporation |
15: | GMEVGMDB.pls |
16: | |
17: | DESCRIPTION |
18: | |
19: | Body of package gme_material_details_dbl |
20: | |
21: | NOTES |
22: | HISTORY |
23: | |
41: | TYPE |
42: | Private |
43: | |
44: | USAGE |
45: | insert_Row will insert a row in gme_material_details |
46: | |
47: | |
48: | DESCRIPTION |
49: | insert_Row will insert a row in gme_material_details |
45: | insert_Row will insert a row in gme_material_details |
46: | |
47: | |
48: | DESCRIPTION |
49: | insert_Row will insert a row in gme_material_details |
50: | |
51: | |
52: | PARAMETERS |
53: | p_material_detail IN gme_material_details%ROWTYPE |
49: | insert_Row will insert a row in gme_material_details |
50: | |
51: | |
52: | PARAMETERS |
53: | p_material_detail IN gme_material_details%ROWTYPE |
54: | x_material_detail IN OUT NOCOPY gme_material_details%ROWTYPE |
55: | RETURNS |
56: | BOOLEAN |
57: | |
50: | |
51: | |
52: | PARAMETERS |
53: | p_material_detail IN gme_material_details%ROWTYPE |
54: | x_material_detail IN OUT NOCOPY gme_material_details%ROWTYPE |
55: | RETURNS |
56: | BOOLEAN |
57: | |
58: | HISTORY |
64: +==========================================================================+
65: Api end of comments
66: */
67: FUNCTION insert_row (
68: p_material_detail IN gme_material_details%ROWTYPE
69: ,x_material_detail IN OUT NOCOPY gme_material_details%ROWTYPE)
70: RETURN BOOLEAN
71: IS
72: l_api_name CONSTANT VARCHAR2 (30) := 'INSERT_ROW';
65: Api end of comments
66: */
67: FUNCTION insert_row (
68: p_material_detail IN gme_material_details%ROWTYPE
69: ,x_material_detail IN OUT NOCOPY gme_material_details%ROWTYPE)
70: RETURN BOOLEAN
71: IS
72: l_api_name CONSTANT VARCHAR2 (30) := 'INSERT_ROW';
73: BEGIN
72: l_api_name CONSTANT VARCHAR2 (30) := 'INSERT_ROW';
73: BEGIN
74: x_material_detail := p_material_detail;
75:
76: INSERT INTO gme_material_details
77: (material_detail_id, batch_id
78: ,formulaline_id
79: ,line_no,
80: --item_id,
252: | TYPE |
253: | Private |
254: | |
255: | USAGE |
256: | fetch_Row will fetch a row in gme_material_details |
257: | |
258: | |
259: | DESCRIPTION |
260: | fetch_row will fetch a row in gme_material_details |
256: | fetch_Row will fetch a row in gme_material_details |
257: | |
258: | |
259: | DESCRIPTION |
260: | fetch_row will fetch a row in gme_material_details |
261: | |
262: | |
263: | PARAMETERS |
264: | p_material_detail IN gme_material_details%ROWTYPE |
260: | fetch_row will fetch a row in gme_material_details |
261: | |
262: | |
263: | PARAMETERS |
264: | p_material_detail IN gme_material_details%ROWTYPE |
265: | x_material_detail IN OUT NOCOPY gme_material_details%ROWTYPE |
266: | RETURNS |
267: | BOOLEAN |
268: | |
261: | |
262: | |
263: | PARAMETERS |
264: | p_material_detail IN gme_material_details%ROWTYPE |
265: | x_material_detail IN OUT NOCOPY gme_material_details%ROWTYPE |
266: | RETURNS |
267: | BOOLEAN |
268: | |
269: | HISTORY |
272: +==========================================================================+
273: Api end of comments
274: */
275: FUNCTION fetch_row (
276: p_material_detail IN gme_material_details%ROWTYPE
277: ,x_material_detail IN OUT NOCOPY gme_material_details%ROWTYPE)
278: RETURN BOOLEAN
279: IS
280: l_api_name CONSTANT VARCHAR2 (30) := 'FETCH_ROW';
273: Api end of comments
274: */
275: FUNCTION fetch_row (
276: p_material_detail IN gme_material_details%ROWTYPE
277: ,x_material_detail IN OUT NOCOPY gme_material_details%ROWTYPE)
278: RETURN BOOLEAN
279: IS
280: l_api_name CONSTANT VARCHAR2 (30) := 'FETCH_ROW';
281: l_gme_material_details gme_material_details%ROWTYPE;
277: ,x_material_detail IN OUT NOCOPY gme_material_details%ROWTYPE)
278: RETURN BOOLEAN
279: IS
280: l_api_name CONSTANT VARCHAR2 (30) := 'FETCH_ROW';
281: l_gme_material_details gme_material_details%ROWTYPE;
282: l_material_detail_id NUMBER;
283: l_batch_id NUMBER;
284: l_line_no NUMBER;
285: l_line_type NUMBER;
366: ,phantom_line_id
367: ,move_order_line_id
368: ,dtl_um
369: ,dispense_ind
370: INTO l_gme_material_details.batch_id
371: ,l_gme_material_details.material_detail_id
372: ,l_gme_material_details.formulaline_id
373: ,l_gme_material_details.line_no
374: ,
367: ,move_order_line_id
368: ,dtl_um
369: ,dispense_ind
370: INTO l_gme_material_details.batch_id
371: ,l_gme_material_details.material_detail_id
372: ,l_gme_material_details.formulaline_id
373: ,l_gme_material_details.line_no
374: ,
375: --l_gme_material_details.item_id,
368: ,dtl_um
369: ,dispense_ind
370: INTO l_gme_material_details.batch_id
371: ,l_gme_material_details.material_detail_id
372: ,l_gme_material_details.formulaline_id
373: ,l_gme_material_details.line_no
374: ,
375: --l_gme_material_details.item_id,
376: l_gme_material_details.line_type
369: ,dispense_ind
370: INTO l_gme_material_details.batch_id
371: ,l_gme_material_details.material_detail_id
372: ,l_gme_material_details.formulaline_id
373: ,l_gme_material_details.line_no
374: ,
375: --l_gme_material_details.item_id,
376: l_gme_material_details.line_type
377: ,l_gme_material_details.plan_qty
371: ,l_gme_material_details.material_detail_id
372: ,l_gme_material_details.formulaline_id
373: ,l_gme_material_details.line_no
374: ,
375: --l_gme_material_details.item_id,
376: l_gme_material_details.line_type
377: ,l_gme_material_details.plan_qty
378: ,
379: --l_gme_material_details.item_um,
372: ,l_gme_material_details.formulaline_id
373: ,l_gme_material_details.line_no
374: ,
375: --l_gme_material_details.item_id,
376: l_gme_material_details.line_type
377: ,l_gme_material_details.plan_qty
378: ,
379: --l_gme_material_details.item_um,
380: l_gme_material_details.item_um2
373: ,l_gme_material_details.line_no
374: ,
375: --l_gme_material_details.item_id,
376: l_gme_material_details.line_type
377: ,l_gme_material_details.plan_qty
378: ,
379: --l_gme_material_details.item_um,
380: l_gme_material_details.item_um2
381: ,l_gme_material_details.actual_qty
375: --l_gme_material_details.item_id,
376: l_gme_material_details.line_type
377: ,l_gme_material_details.plan_qty
378: ,
379: --l_gme_material_details.item_um,
380: l_gme_material_details.item_um2
381: ,l_gme_material_details.actual_qty
382: ,l_gme_material_details.release_type
383: ,l_gme_material_details.scrap_factor
376: l_gme_material_details.line_type
377: ,l_gme_material_details.plan_qty
378: ,
379: --l_gme_material_details.item_um,
380: l_gme_material_details.item_um2
381: ,l_gme_material_details.actual_qty
382: ,l_gme_material_details.release_type
383: ,l_gme_material_details.scrap_factor
384: ,l_gme_material_details.scale_type
377: ,l_gme_material_details.plan_qty
378: ,
379: --l_gme_material_details.item_um,
380: l_gme_material_details.item_um2
381: ,l_gme_material_details.actual_qty
382: ,l_gme_material_details.release_type
383: ,l_gme_material_details.scrap_factor
384: ,l_gme_material_details.scale_type
385: ,l_gme_material_details.phantom_type
378: ,
379: --l_gme_material_details.item_um,
380: l_gme_material_details.item_um2
381: ,l_gme_material_details.actual_qty
382: ,l_gme_material_details.release_type
383: ,l_gme_material_details.scrap_factor
384: ,l_gme_material_details.scale_type
385: ,l_gme_material_details.phantom_type
386: ,l_gme_material_details.cost_alloc
379: --l_gme_material_details.item_um,
380: l_gme_material_details.item_um2
381: ,l_gme_material_details.actual_qty
382: ,l_gme_material_details.release_type
383: ,l_gme_material_details.scrap_factor
384: ,l_gme_material_details.scale_type
385: ,l_gme_material_details.phantom_type
386: ,l_gme_material_details.cost_alloc
387: ,l_gme_material_details.alloc_ind
380: l_gme_material_details.item_um2
381: ,l_gme_material_details.actual_qty
382: ,l_gme_material_details.release_type
383: ,l_gme_material_details.scrap_factor
384: ,l_gme_material_details.scale_type
385: ,l_gme_material_details.phantom_type
386: ,l_gme_material_details.cost_alloc
387: ,l_gme_material_details.alloc_ind
388: ,l_gme_material_details.COST
381: ,l_gme_material_details.actual_qty
382: ,l_gme_material_details.release_type
383: ,l_gme_material_details.scrap_factor
384: ,l_gme_material_details.scale_type
385: ,l_gme_material_details.phantom_type
386: ,l_gme_material_details.cost_alloc
387: ,l_gme_material_details.alloc_ind
388: ,l_gme_material_details.COST
389: ,l_gme_material_details.text_code
382: ,l_gme_material_details.release_type
383: ,l_gme_material_details.scrap_factor
384: ,l_gme_material_details.scale_type
385: ,l_gme_material_details.phantom_type
386: ,l_gme_material_details.cost_alloc
387: ,l_gme_material_details.alloc_ind
388: ,l_gme_material_details.COST
389: ,l_gme_material_details.text_code
390: ,l_gme_material_details.phantom_id
383: ,l_gme_material_details.scrap_factor
384: ,l_gme_material_details.scale_type
385: ,l_gme_material_details.phantom_type
386: ,l_gme_material_details.cost_alloc
387: ,l_gme_material_details.alloc_ind
388: ,l_gme_material_details.COST
389: ,l_gme_material_details.text_code
390: ,l_gme_material_details.phantom_id
391: ,l_gme_material_details.created_by
384: ,l_gme_material_details.scale_type
385: ,l_gme_material_details.phantom_type
386: ,l_gme_material_details.cost_alloc
387: ,l_gme_material_details.alloc_ind
388: ,l_gme_material_details.COST
389: ,l_gme_material_details.text_code
390: ,l_gme_material_details.phantom_id
391: ,l_gme_material_details.created_by
392: ,l_gme_material_details.creation_date
385: ,l_gme_material_details.phantom_type
386: ,l_gme_material_details.cost_alloc
387: ,l_gme_material_details.alloc_ind
388: ,l_gme_material_details.COST
389: ,l_gme_material_details.text_code
390: ,l_gme_material_details.phantom_id
391: ,l_gme_material_details.created_by
392: ,l_gme_material_details.creation_date
393: ,l_gme_material_details.last_updated_by
386: ,l_gme_material_details.cost_alloc
387: ,l_gme_material_details.alloc_ind
388: ,l_gme_material_details.COST
389: ,l_gme_material_details.text_code
390: ,l_gme_material_details.phantom_id
391: ,l_gme_material_details.created_by
392: ,l_gme_material_details.creation_date
393: ,l_gme_material_details.last_updated_by
394: ,l_gme_material_details.last_update_date
387: ,l_gme_material_details.alloc_ind
388: ,l_gme_material_details.COST
389: ,l_gme_material_details.text_code
390: ,l_gme_material_details.phantom_id
391: ,l_gme_material_details.created_by
392: ,l_gme_material_details.creation_date
393: ,l_gme_material_details.last_updated_by
394: ,l_gme_material_details.last_update_date
395: ,l_gme_material_details.attribute1
388: ,l_gme_material_details.COST
389: ,l_gme_material_details.text_code
390: ,l_gme_material_details.phantom_id
391: ,l_gme_material_details.created_by
392: ,l_gme_material_details.creation_date
393: ,l_gme_material_details.last_updated_by
394: ,l_gme_material_details.last_update_date
395: ,l_gme_material_details.attribute1
396: ,l_gme_material_details.attribute2
389: ,l_gme_material_details.text_code
390: ,l_gme_material_details.phantom_id
391: ,l_gme_material_details.created_by
392: ,l_gme_material_details.creation_date
393: ,l_gme_material_details.last_updated_by
394: ,l_gme_material_details.last_update_date
395: ,l_gme_material_details.attribute1
396: ,l_gme_material_details.attribute2
397: ,l_gme_material_details.attribute3
390: ,l_gme_material_details.phantom_id
391: ,l_gme_material_details.created_by
392: ,l_gme_material_details.creation_date
393: ,l_gme_material_details.last_updated_by
394: ,l_gme_material_details.last_update_date
395: ,l_gme_material_details.attribute1
396: ,l_gme_material_details.attribute2
397: ,l_gme_material_details.attribute3
398: ,l_gme_material_details.attribute4
391: ,l_gme_material_details.created_by
392: ,l_gme_material_details.creation_date
393: ,l_gme_material_details.last_updated_by
394: ,l_gme_material_details.last_update_date
395: ,l_gme_material_details.attribute1
396: ,l_gme_material_details.attribute2
397: ,l_gme_material_details.attribute3
398: ,l_gme_material_details.attribute4
399: ,l_gme_material_details.attribute5
392: ,l_gme_material_details.creation_date
393: ,l_gme_material_details.last_updated_by
394: ,l_gme_material_details.last_update_date
395: ,l_gme_material_details.attribute1
396: ,l_gme_material_details.attribute2
397: ,l_gme_material_details.attribute3
398: ,l_gme_material_details.attribute4
399: ,l_gme_material_details.attribute5
400: ,l_gme_material_details.attribute6
393: ,l_gme_material_details.last_updated_by
394: ,l_gme_material_details.last_update_date
395: ,l_gme_material_details.attribute1
396: ,l_gme_material_details.attribute2
397: ,l_gme_material_details.attribute3
398: ,l_gme_material_details.attribute4
399: ,l_gme_material_details.attribute5
400: ,l_gme_material_details.attribute6
401: ,l_gme_material_details.attribute7
394: ,l_gme_material_details.last_update_date
395: ,l_gme_material_details.attribute1
396: ,l_gme_material_details.attribute2
397: ,l_gme_material_details.attribute3
398: ,l_gme_material_details.attribute4
399: ,l_gme_material_details.attribute5
400: ,l_gme_material_details.attribute6
401: ,l_gme_material_details.attribute7
402: ,l_gme_material_details.attribute8
395: ,l_gme_material_details.attribute1
396: ,l_gme_material_details.attribute2
397: ,l_gme_material_details.attribute3
398: ,l_gme_material_details.attribute4
399: ,l_gme_material_details.attribute5
400: ,l_gme_material_details.attribute6
401: ,l_gme_material_details.attribute7
402: ,l_gme_material_details.attribute8
403: ,l_gme_material_details.attribute9
396: ,l_gme_material_details.attribute2
397: ,l_gme_material_details.attribute3
398: ,l_gme_material_details.attribute4
399: ,l_gme_material_details.attribute5
400: ,l_gme_material_details.attribute6
401: ,l_gme_material_details.attribute7
402: ,l_gme_material_details.attribute8
403: ,l_gme_material_details.attribute9
404: ,l_gme_material_details.attribute10
397: ,l_gme_material_details.attribute3
398: ,l_gme_material_details.attribute4
399: ,l_gme_material_details.attribute5
400: ,l_gme_material_details.attribute6
401: ,l_gme_material_details.attribute7
402: ,l_gme_material_details.attribute8
403: ,l_gme_material_details.attribute9
404: ,l_gme_material_details.attribute10
405: ,l_gme_material_details.attribute11
398: ,l_gme_material_details.attribute4
399: ,l_gme_material_details.attribute5
400: ,l_gme_material_details.attribute6
401: ,l_gme_material_details.attribute7
402: ,l_gme_material_details.attribute8
403: ,l_gme_material_details.attribute9
404: ,l_gme_material_details.attribute10
405: ,l_gme_material_details.attribute11
406: ,l_gme_material_details.attribute12
399: ,l_gme_material_details.attribute5
400: ,l_gme_material_details.attribute6
401: ,l_gme_material_details.attribute7
402: ,l_gme_material_details.attribute8
403: ,l_gme_material_details.attribute9
404: ,l_gme_material_details.attribute10
405: ,l_gme_material_details.attribute11
406: ,l_gme_material_details.attribute12
407: ,l_gme_material_details.attribute13
400: ,l_gme_material_details.attribute6
401: ,l_gme_material_details.attribute7
402: ,l_gme_material_details.attribute8
403: ,l_gme_material_details.attribute9
404: ,l_gme_material_details.attribute10
405: ,l_gme_material_details.attribute11
406: ,l_gme_material_details.attribute12
407: ,l_gme_material_details.attribute13
408: ,l_gme_material_details.attribute14
401: ,l_gme_material_details.attribute7
402: ,l_gme_material_details.attribute8
403: ,l_gme_material_details.attribute9
404: ,l_gme_material_details.attribute10
405: ,l_gme_material_details.attribute11
406: ,l_gme_material_details.attribute12
407: ,l_gme_material_details.attribute13
408: ,l_gme_material_details.attribute14
409: ,l_gme_material_details.attribute15
402: ,l_gme_material_details.attribute8
403: ,l_gme_material_details.attribute9
404: ,l_gme_material_details.attribute10
405: ,l_gme_material_details.attribute11
406: ,l_gme_material_details.attribute12
407: ,l_gme_material_details.attribute13
408: ,l_gme_material_details.attribute14
409: ,l_gme_material_details.attribute15
410: ,l_gme_material_details.attribute16
403: ,l_gme_material_details.attribute9
404: ,l_gme_material_details.attribute10
405: ,l_gme_material_details.attribute11
406: ,l_gme_material_details.attribute12
407: ,l_gme_material_details.attribute13
408: ,l_gme_material_details.attribute14
409: ,l_gme_material_details.attribute15
410: ,l_gme_material_details.attribute16
411: ,l_gme_material_details.attribute17
404: ,l_gme_material_details.attribute10
405: ,l_gme_material_details.attribute11
406: ,l_gme_material_details.attribute12
407: ,l_gme_material_details.attribute13
408: ,l_gme_material_details.attribute14
409: ,l_gme_material_details.attribute15
410: ,l_gme_material_details.attribute16
411: ,l_gme_material_details.attribute17
412: ,l_gme_material_details.attribute18
405: ,l_gme_material_details.attribute11
406: ,l_gme_material_details.attribute12
407: ,l_gme_material_details.attribute13
408: ,l_gme_material_details.attribute14
409: ,l_gme_material_details.attribute15
410: ,l_gme_material_details.attribute16
411: ,l_gme_material_details.attribute17
412: ,l_gme_material_details.attribute18
413: ,l_gme_material_details.attribute19
406: ,l_gme_material_details.attribute12
407: ,l_gme_material_details.attribute13
408: ,l_gme_material_details.attribute14
409: ,l_gme_material_details.attribute15
410: ,l_gme_material_details.attribute16
411: ,l_gme_material_details.attribute17
412: ,l_gme_material_details.attribute18
413: ,l_gme_material_details.attribute19
414: ,l_gme_material_details.attribute20
407: ,l_gme_material_details.attribute13
408: ,l_gme_material_details.attribute14
409: ,l_gme_material_details.attribute15
410: ,l_gme_material_details.attribute16
411: ,l_gme_material_details.attribute17
412: ,l_gme_material_details.attribute18
413: ,l_gme_material_details.attribute19
414: ,l_gme_material_details.attribute20
415: ,l_gme_material_details.attribute21
408: ,l_gme_material_details.attribute14
409: ,l_gme_material_details.attribute15
410: ,l_gme_material_details.attribute16
411: ,l_gme_material_details.attribute17
412: ,l_gme_material_details.attribute18
413: ,l_gme_material_details.attribute19
414: ,l_gme_material_details.attribute20
415: ,l_gme_material_details.attribute21
416: ,l_gme_material_details.attribute22
409: ,l_gme_material_details.attribute15
410: ,l_gme_material_details.attribute16
411: ,l_gme_material_details.attribute17
412: ,l_gme_material_details.attribute18
413: ,l_gme_material_details.attribute19
414: ,l_gme_material_details.attribute20
415: ,l_gme_material_details.attribute21
416: ,l_gme_material_details.attribute22
417: ,l_gme_material_details.attribute23
410: ,l_gme_material_details.attribute16
411: ,l_gme_material_details.attribute17
412: ,l_gme_material_details.attribute18
413: ,l_gme_material_details.attribute19
414: ,l_gme_material_details.attribute20
415: ,l_gme_material_details.attribute21
416: ,l_gme_material_details.attribute22
417: ,l_gme_material_details.attribute23
418: ,l_gme_material_details.attribute24
411: ,l_gme_material_details.attribute17
412: ,l_gme_material_details.attribute18
413: ,l_gme_material_details.attribute19
414: ,l_gme_material_details.attribute20
415: ,l_gme_material_details.attribute21
416: ,l_gme_material_details.attribute22
417: ,l_gme_material_details.attribute23
418: ,l_gme_material_details.attribute24
419: ,l_gme_material_details.attribute25
412: ,l_gme_material_details.attribute18
413: ,l_gme_material_details.attribute19
414: ,l_gme_material_details.attribute20
415: ,l_gme_material_details.attribute21
416: ,l_gme_material_details.attribute22
417: ,l_gme_material_details.attribute23
418: ,l_gme_material_details.attribute24
419: ,l_gme_material_details.attribute25
420: ,l_gme_material_details.attribute26
413: ,l_gme_material_details.attribute19
414: ,l_gme_material_details.attribute20
415: ,l_gme_material_details.attribute21
416: ,l_gme_material_details.attribute22
417: ,l_gme_material_details.attribute23
418: ,l_gme_material_details.attribute24
419: ,l_gme_material_details.attribute25
420: ,l_gme_material_details.attribute26
421: ,l_gme_material_details.attribute27
414: ,l_gme_material_details.attribute20
415: ,l_gme_material_details.attribute21
416: ,l_gme_material_details.attribute22
417: ,l_gme_material_details.attribute23
418: ,l_gme_material_details.attribute24
419: ,l_gme_material_details.attribute25
420: ,l_gme_material_details.attribute26
421: ,l_gme_material_details.attribute27
422: ,l_gme_material_details.attribute28
415: ,l_gme_material_details.attribute21
416: ,l_gme_material_details.attribute22
417: ,l_gme_material_details.attribute23
418: ,l_gme_material_details.attribute24
419: ,l_gme_material_details.attribute25
420: ,l_gme_material_details.attribute26
421: ,l_gme_material_details.attribute27
422: ,l_gme_material_details.attribute28
423: ,l_gme_material_details.attribute29
416: ,l_gme_material_details.attribute22
417: ,l_gme_material_details.attribute23
418: ,l_gme_material_details.attribute24
419: ,l_gme_material_details.attribute25
420: ,l_gme_material_details.attribute26
421: ,l_gme_material_details.attribute27
422: ,l_gme_material_details.attribute28
423: ,l_gme_material_details.attribute29
424: ,l_gme_material_details.attribute30
417: ,l_gme_material_details.attribute23
418: ,l_gme_material_details.attribute24
419: ,l_gme_material_details.attribute25
420: ,l_gme_material_details.attribute26
421: ,l_gme_material_details.attribute27
422: ,l_gme_material_details.attribute28
423: ,l_gme_material_details.attribute29
424: ,l_gme_material_details.attribute30
425: ,l_gme_material_details.attribute_category
418: ,l_gme_material_details.attribute24
419: ,l_gme_material_details.attribute25
420: ,l_gme_material_details.attribute26
421: ,l_gme_material_details.attribute27
422: ,l_gme_material_details.attribute28
423: ,l_gme_material_details.attribute29
424: ,l_gme_material_details.attribute30
425: ,l_gme_material_details.attribute_category
426: ,l_gme_material_details.last_update_login
419: ,l_gme_material_details.attribute25
420: ,l_gme_material_details.attribute26
421: ,l_gme_material_details.attribute27
422: ,l_gme_material_details.attribute28
423: ,l_gme_material_details.attribute29
424: ,l_gme_material_details.attribute30
425: ,l_gme_material_details.attribute_category
426: ,l_gme_material_details.last_update_login
427: ,l_gme_material_details.scale_rounding_variance
420: ,l_gme_material_details.attribute26
421: ,l_gme_material_details.attribute27
422: ,l_gme_material_details.attribute28
423: ,l_gme_material_details.attribute29
424: ,l_gme_material_details.attribute30
425: ,l_gme_material_details.attribute_category
426: ,l_gme_material_details.last_update_login
427: ,l_gme_material_details.scale_rounding_variance
428: ,l_gme_material_details.scale_multiple
421: ,l_gme_material_details.attribute27
422: ,l_gme_material_details.attribute28
423: ,l_gme_material_details.attribute29
424: ,l_gme_material_details.attribute30
425: ,l_gme_material_details.attribute_category
426: ,l_gme_material_details.last_update_login
427: ,l_gme_material_details.scale_rounding_variance
428: ,l_gme_material_details.scale_multiple
429: ,l_gme_material_details.rounding_direction
422: ,l_gme_material_details.attribute28
423: ,l_gme_material_details.attribute29
424: ,l_gme_material_details.attribute30
425: ,l_gme_material_details.attribute_category
426: ,l_gme_material_details.last_update_login
427: ,l_gme_material_details.scale_rounding_variance
428: ,l_gme_material_details.scale_multiple
429: ,l_gme_material_details.rounding_direction
430: ,l_gme_material_details.contribute_yield_ind
423: ,l_gme_material_details.attribute29
424: ,l_gme_material_details.attribute30
425: ,l_gme_material_details.attribute_category
426: ,l_gme_material_details.last_update_login
427: ,l_gme_material_details.scale_rounding_variance
428: ,l_gme_material_details.scale_multiple
429: ,l_gme_material_details.rounding_direction
430: ,l_gme_material_details.contribute_yield_ind
431: ,l_gme_material_details.contribute_step_qty_ind
424: ,l_gme_material_details.attribute30
425: ,l_gme_material_details.attribute_category
426: ,l_gme_material_details.last_update_login
427: ,l_gme_material_details.scale_rounding_variance
428: ,l_gme_material_details.scale_multiple
429: ,l_gme_material_details.rounding_direction
430: ,l_gme_material_details.contribute_yield_ind
431: ,l_gme_material_details.contribute_step_qty_ind
432: ,l_gme_material_details.wip_plan_qty
425: ,l_gme_material_details.attribute_category
426: ,l_gme_material_details.last_update_login
427: ,l_gme_material_details.scale_rounding_variance
428: ,l_gme_material_details.scale_multiple
429: ,l_gme_material_details.rounding_direction
430: ,l_gme_material_details.contribute_yield_ind
431: ,l_gme_material_details.contribute_step_qty_ind
432: ,l_gme_material_details.wip_plan_qty
433: ,l_gme_material_details.original_qty
426: ,l_gme_material_details.last_update_login
427: ,l_gme_material_details.scale_rounding_variance
428: ,l_gme_material_details.scale_multiple
429: ,l_gme_material_details.rounding_direction
430: ,l_gme_material_details.contribute_yield_ind
431: ,l_gme_material_details.contribute_step_qty_ind
432: ,l_gme_material_details.wip_plan_qty
433: ,l_gme_material_details.original_qty
434: ,l_gme_material_details.by_product_type
427: ,l_gme_material_details.scale_rounding_variance
428: ,l_gme_material_details.scale_multiple
429: ,l_gme_material_details.rounding_direction
430: ,l_gme_material_details.contribute_yield_ind
431: ,l_gme_material_details.contribute_step_qty_ind
432: ,l_gme_material_details.wip_plan_qty
433: ,l_gme_material_details.original_qty
434: ,l_gme_material_details.by_product_type
435: ,l_gme_material_details.organization_id
428: ,l_gme_material_details.scale_multiple
429: ,l_gme_material_details.rounding_direction
430: ,l_gme_material_details.contribute_yield_ind
431: ,l_gme_material_details.contribute_step_qty_ind
432: ,l_gme_material_details.wip_plan_qty
433: ,l_gme_material_details.original_qty
434: ,l_gme_material_details.by_product_type
435: ,l_gme_material_details.organization_id
436: ,l_gme_material_details.inventory_item_id
429: ,l_gme_material_details.rounding_direction
430: ,l_gme_material_details.contribute_yield_ind
431: ,l_gme_material_details.contribute_step_qty_ind
432: ,l_gme_material_details.wip_plan_qty
433: ,l_gme_material_details.original_qty
434: ,l_gme_material_details.by_product_type
435: ,l_gme_material_details.organization_id
436: ,l_gme_material_details.inventory_item_id
437: ,l_gme_material_details.subinventory
430: ,l_gme_material_details.contribute_yield_ind
431: ,l_gme_material_details.contribute_step_qty_ind
432: ,l_gme_material_details.wip_plan_qty
433: ,l_gme_material_details.original_qty
434: ,l_gme_material_details.by_product_type
435: ,l_gme_material_details.organization_id
436: ,l_gme_material_details.inventory_item_id
437: ,l_gme_material_details.subinventory
438: ,l_gme_material_details.locator_id
431: ,l_gme_material_details.contribute_step_qty_ind
432: ,l_gme_material_details.wip_plan_qty
433: ,l_gme_material_details.original_qty
434: ,l_gme_material_details.by_product_type
435: ,l_gme_material_details.organization_id
436: ,l_gme_material_details.inventory_item_id
437: ,l_gme_material_details.subinventory
438: ,l_gme_material_details.locator_id
439: ,l_gme_material_details.revision
432: ,l_gme_material_details.wip_plan_qty
433: ,l_gme_material_details.original_qty
434: ,l_gme_material_details.by_product_type
435: ,l_gme_material_details.organization_id
436: ,l_gme_material_details.inventory_item_id
437: ,l_gme_material_details.subinventory
438: ,l_gme_material_details.locator_id
439: ,l_gme_material_details.revision
440: ,l_gme_material_details.backordered_qty
433: ,l_gme_material_details.original_qty
434: ,l_gme_material_details.by_product_type
435: ,l_gme_material_details.organization_id
436: ,l_gme_material_details.inventory_item_id
437: ,l_gme_material_details.subinventory
438: ,l_gme_material_details.locator_id
439: ,l_gme_material_details.revision
440: ,l_gme_material_details.backordered_qty
441: ,l_gme_material_details.original_primary_qty
434: ,l_gme_material_details.by_product_type
435: ,l_gme_material_details.organization_id
436: ,l_gme_material_details.inventory_item_id
437: ,l_gme_material_details.subinventory
438: ,l_gme_material_details.locator_id
439: ,l_gme_material_details.revision
440: ,l_gme_material_details.backordered_qty
441: ,l_gme_material_details.original_primary_qty
442: ,l_gme_material_details.material_requirement_date
435: ,l_gme_material_details.organization_id
436: ,l_gme_material_details.inventory_item_id
437: ,l_gme_material_details.subinventory
438: ,l_gme_material_details.locator_id
439: ,l_gme_material_details.revision
440: ,l_gme_material_details.backordered_qty
441: ,l_gme_material_details.original_primary_qty
442: ,l_gme_material_details.material_requirement_date
443: ,l_gme_material_details.phantom_line_id
436: ,l_gme_material_details.inventory_item_id
437: ,l_gme_material_details.subinventory
438: ,l_gme_material_details.locator_id
439: ,l_gme_material_details.revision
440: ,l_gme_material_details.backordered_qty
441: ,l_gme_material_details.original_primary_qty
442: ,l_gme_material_details.material_requirement_date
443: ,l_gme_material_details.phantom_line_id
444: ,l_gme_material_details.move_order_line_id
437: ,l_gme_material_details.subinventory
438: ,l_gme_material_details.locator_id
439: ,l_gme_material_details.revision
440: ,l_gme_material_details.backordered_qty
441: ,l_gme_material_details.original_primary_qty
442: ,l_gme_material_details.material_requirement_date
443: ,l_gme_material_details.phantom_line_id
444: ,l_gme_material_details.move_order_line_id
445: ,l_gme_material_details.dtl_um
438: ,l_gme_material_details.locator_id
439: ,l_gme_material_details.revision
440: ,l_gme_material_details.backordered_qty
441: ,l_gme_material_details.original_primary_qty
442: ,l_gme_material_details.material_requirement_date
443: ,l_gme_material_details.phantom_line_id
444: ,l_gme_material_details.move_order_line_id
445: ,l_gme_material_details.dtl_um
446: ,l_gme_material_details.dispense_ind
439: ,l_gme_material_details.revision
440: ,l_gme_material_details.backordered_qty
441: ,l_gme_material_details.original_primary_qty
442: ,l_gme_material_details.material_requirement_date
443: ,l_gme_material_details.phantom_line_id
444: ,l_gme_material_details.move_order_line_id
445: ,l_gme_material_details.dtl_um
446: ,l_gme_material_details.dispense_ind
447: FROM gme_material_details
440: ,l_gme_material_details.backordered_qty
441: ,l_gme_material_details.original_primary_qty
442: ,l_gme_material_details.material_requirement_date
443: ,l_gme_material_details.phantom_line_id
444: ,l_gme_material_details.move_order_line_id
445: ,l_gme_material_details.dtl_um
446: ,l_gme_material_details.dispense_ind
447: FROM gme_material_details
448: WHERE material_detail_id = l_material_detail_id;
441: ,l_gme_material_details.original_primary_qty
442: ,l_gme_material_details.material_requirement_date
443: ,l_gme_material_details.phantom_line_id
444: ,l_gme_material_details.move_order_line_id
445: ,l_gme_material_details.dtl_um
446: ,l_gme_material_details.dispense_ind
447: FROM gme_material_details
448: WHERE material_detail_id = l_material_detail_id;
449: ELSIF (l_batch_id IS NOT NULL)
442: ,l_gme_material_details.material_requirement_date
443: ,l_gme_material_details.phantom_line_id
444: ,l_gme_material_details.move_order_line_id
445: ,l_gme_material_details.dtl_um
446: ,l_gme_material_details.dispense_ind
447: FROM gme_material_details
448: WHERE material_detail_id = l_material_detail_id;
449: ELSIF (l_batch_id IS NOT NULL)
450: AND (l_line_no IS NOT NULL)
443: ,l_gme_material_details.phantom_line_id
444: ,l_gme_material_details.move_order_line_id
445: ,l_gme_material_details.dtl_um
446: ,l_gme_material_details.dispense_ind
447: FROM gme_material_details
448: WHERE material_detail_id = l_material_detail_id;
449: ELSIF (l_batch_id IS NOT NULL)
450: AND (l_line_no IS NOT NULL)
451: AND (l_line_type IS NOT NULL) THEN
525: ,phantom_line_id
526: ,move_order_line_id
527: ,dtl_um
528: ,dispense_ind
529: INTO l_gme_material_details.batch_id
530: ,l_gme_material_details.material_detail_id
531: ,l_gme_material_details.formulaline_id
532: ,l_gme_material_details.line_no
533: ,
526: ,move_order_line_id
527: ,dtl_um
528: ,dispense_ind
529: INTO l_gme_material_details.batch_id
530: ,l_gme_material_details.material_detail_id
531: ,l_gme_material_details.formulaline_id
532: ,l_gme_material_details.line_no
533: ,
534: --l_gme_material_details.item_id,
527: ,dtl_um
528: ,dispense_ind
529: INTO l_gme_material_details.batch_id
530: ,l_gme_material_details.material_detail_id
531: ,l_gme_material_details.formulaline_id
532: ,l_gme_material_details.line_no
533: ,
534: --l_gme_material_details.item_id,
535: l_gme_material_details.line_type
528: ,dispense_ind
529: INTO l_gme_material_details.batch_id
530: ,l_gme_material_details.material_detail_id
531: ,l_gme_material_details.formulaline_id
532: ,l_gme_material_details.line_no
533: ,
534: --l_gme_material_details.item_id,
535: l_gme_material_details.line_type
536: ,l_gme_material_details.plan_qty
530: ,l_gme_material_details.material_detail_id
531: ,l_gme_material_details.formulaline_id
532: ,l_gme_material_details.line_no
533: ,
534: --l_gme_material_details.item_id,
535: l_gme_material_details.line_type
536: ,l_gme_material_details.plan_qty
537: ,
538: --l_gme_material_details.item_um,
531: ,l_gme_material_details.formulaline_id
532: ,l_gme_material_details.line_no
533: ,
534: --l_gme_material_details.item_id,
535: l_gme_material_details.line_type
536: ,l_gme_material_details.plan_qty
537: ,
538: --l_gme_material_details.item_um,
539: l_gme_material_details.item_um2
532: ,l_gme_material_details.line_no
533: ,
534: --l_gme_material_details.item_id,
535: l_gme_material_details.line_type
536: ,l_gme_material_details.plan_qty
537: ,
538: --l_gme_material_details.item_um,
539: l_gme_material_details.item_um2
540: ,l_gme_material_details.actual_qty
534: --l_gme_material_details.item_id,
535: l_gme_material_details.line_type
536: ,l_gme_material_details.plan_qty
537: ,
538: --l_gme_material_details.item_um,
539: l_gme_material_details.item_um2
540: ,l_gme_material_details.actual_qty
541: ,l_gme_material_details.release_type
542: ,l_gme_material_details.scrap_factor
535: l_gme_material_details.line_type
536: ,l_gme_material_details.plan_qty
537: ,
538: --l_gme_material_details.item_um,
539: l_gme_material_details.item_um2
540: ,l_gme_material_details.actual_qty
541: ,l_gme_material_details.release_type
542: ,l_gme_material_details.scrap_factor
543: ,l_gme_material_details.scale_type
536: ,l_gme_material_details.plan_qty
537: ,
538: --l_gme_material_details.item_um,
539: l_gme_material_details.item_um2
540: ,l_gme_material_details.actual_qty
541: ,l_gme_material_details.release_type
542: ,l_gme_material_details.scrap_factor
543: ,l_gme_material_details.scale_type
544: ,l_gme_material_details.phantom_type
537: ,
538: --l_gme_material_details.item_um,
539: l_gme_material_details.item_um2
540: ,l_gme_material_details.actual_qty
541: ,l_gme_material_details.release_type
542: ,l_gme_material_details.scrap_factor
543: ,l_gme_material_details.scale_type
544: ,l_gme_material_details.phantom_type
545: ,l_gme_material_details.cost_alloc
538: --l_gme_material_details.item_um,
539: l_gme_material_details.item_um2
540: ,l_gme_material_details.actual_qty
541: ,l_gme_material_details.release_type
542: ,l_gme_material_details.scrap_factor
543: ,l_gme_material_details.scale_type
544: ,l_gme_material_details.phantom_type
545: ,l_gme_material_details.cost_alloc
546: ,l_gme_material_details.alloc_ind
539: l_gme_material_details.item_um2
540: ,l_gme_material_details.actual_qty
541: ,l_gme_material_details.release_type
542: ,l_gme_material_details.scrap_factor
543: ,l_gme_material_details.scale_type
544: ,l_gme_material_details.phantom_type
545: ,l_gme_material_details.cost_alloc
546: ,l_gme_material_details.alloc_ind
547: ,l_gme_material_details.COST
540: ,l_gme_material_details.actual_qty
541: ,l_gme_material_details.release_type
542: ,l_gme_material_details.scrap_factor
543: ,l_gme_material_details.scale_type
544: ,l_gme_material_details.phantom_type
545: ,l_gme_material_details.cost_alloc
546: ,l_gme_material_details.alloc_ind
547: ,l_gme_material_details.COST
548: ,l_gme_material_details.text_code
541: ,l_gme_material_details.release_type
542: ,l_gme_material_details.scrap_factor
543: ,l_gme_material_details.scale_type
544: ,l_gme_material_details.phantom_type
545: ,l_gme_material_details.cost_alloc
546: ,l_gme_material_details.alloc_ind
547: ,l_gme_material_details.COST
548: ,l_gme_material_details.text_code
549: ,l_gme_material_details.phantom_id
542: ,l_gme_material_details.scrap_factor
543: ,l_gme_material_details.scale_type
544: ,l_gme_material_details.phantom_type
545: ,l_gme_material_details.cost_alloc
546: ,l_gme_material_details.alloc_ind
547: ,l_gme_material_details.COST
548: ,l_gme_material_details.text_code
549: ,l_gme_material_details.phantom_id
550: ,l_gme_material_details.created_by
543: ,l_gme_material_details.scale_type
544: ,l_gme_material_details.phantom_type
545: ,l_gme_material_details.cost_alloc
546: ,l_gme_material_details.alloc_ind
547: ,l_gme_material_details.COST
548: ,l_gme_material_details.text_code
549: ,l_gme_material_details.phantom_id
550: ,l_gme_material_details.created_by
551: ,l_gme_material_details.creation_date
544: ,l_gme_material_details.phantom_type
545: ,l_gme_material_details.cost_alloc
546: ,l_gme_material_details.alloc_ind
547: ,l_gme_material_details.COST
548: ,l_gme_material_details.text_code
549: ,l_gme_material_details.phantom_id
550: ,l_gme_material_details.created_by
551: ,l_gme_material_details.creation_date
552: ,l_gme_material_details.last_updated_by
545: ,l_gme_material_details.cost_alloc
546: ,l_gme_material_details.alloc_ind
547: ,l_gme_material_details.COST
548: ,l_gme_material_details.text_code
549: ,l_gme_material_details.phantom_id
550: ,l_gme_material_details.created_by
551: ,l_gme_material_details.creation_date
552: ,l_gme_material_details.last_updated_by
553: ,l_gme_material_details.last_update_date
546: ,l_gme_material_details.alloc_ind
547: ,l_gme_material_details.COST
548: ,l_gme_material_details.text_code
549: ,l_gme_material_details.phantom_id
550: ,l_gme_material_details.created_by
551: ,l_gme_material_details.creation_date
552: ,l_gme_material_details.last_updated_by
553: ,l_gme_material_details.last_update_date
554: ,l_gme_material_details.attribute1
547: ,l_gme_material_details.COST
548: ,l_gme_material_details.text_code
549: ,l_gme_material_details.phantom_id
550: ,l_gme_material_details.created_by
551: ,l_gme_material_details.creation_date
552: ,l_gme_material_details.last_updated_by
553: ,l_gme_material_details.last_update_date
554: ,l_gme_material_details.attribute1
555: ,l_gme_material_details.attribute2
548: ,l_gme_material_details.text_code
549: ,l_gme_material_details.phantom_id
550: ,l_gme_material_details.created_by
551: ,l_gme_material_details.creation_date
552: ,l_gme_material_details.last_updated_by
553: ,l_gme_material_details.last_update_date
554: ,l_gme_material_details.attribute1
555: ,l_gme_material_details.attribute2
556: ,l_gme_material_details.attribute3
549: ,l_gme_material_details.phantom_id
550: ,l_gme_material_details.created_by
551: ,l_gme_material_details.creation_date
552: ,l_gme_material_details.last_updated_by
553: ,l_gme_material_details.last_update_date
554: ,l_gme_material_details.attribute1
555: ,l_gme_material_details.attribute2
556: ,l_gme_material_details.attribute3
557: ,l_gme_material_details.attribute4
550: ,l_gme_material_details.created_by
551: ,l_gme_material_details.creation_date
552: ,l_gme_material_details.last_updated_by
553: ,l_gme_material_details.last_update_date
554: ,l_gme_material_details.attribute1
555: ,l_gme_material_details.attribute2
556: ,l_gme_material_details.attribute3
557: ,l_gme_material_details.attribute4
558: ,l_gme_material_details.attribute5
551: ,l_gme_material_details.creation_date
552: ,l_gme_material_details.last_updated_by
553: ,l_gme_material_details.last_update_date
554: ,l_gme_material_details.attribute1
555: ,l_gme_material_details.attribute2
556: ,l_gme_material_details.attribute3
557: ,l_gme_material_details.attribute4
558: ,l_gme_material_details.attribute5
559: ,l_gme_material_details.attribute6
552: ,l_gme_material_details.last_updated_by
553: ,l_gme_material_details.last_update_date
554: ,l_gme_material_details.attribute1
555: ,l_gme_material_details.attribute2
556: ,l_gme_material_details.attribute3
557: ,l_gme_material_details.attribute4
558: ,l_gme_material_details.attribute5
559: ,l_gme_material_details.attribute6
560: ,l_gme_material_details.attribute7
553: ,l_gme_material_details.last_update_date
554: ,l_gme_material_details.attribute1
555: ,l_gme_material_details.attribute2
556: ,l_gme_material_details.attribute3
557: ,l_gme_material_details.attribute4
558: ,l_gme_material_details.attribute5
559: ,l_gme_material_details.attribute6
560: ,l_gme_material_details.attribute7
561: ,l_gme_material_details.attribute8
554: ,l_gme_material_details.attribute1
555: ,l_gme_material_details.attribute2
556: ,l_gme_material_details.attribute3
557: ,l_gme_material_details.attribute4
558: ,l_gme_material_details.attribute5
559: ,l_gme_material_details.attribute6
560: ,l_gme_material_details.attribute7
561: ,l_gme_material_details.attribute8
562: ,l_gme_material_details.attribute9
555: ,l_gme_material_details.attribute2
556: ,l_gme_material_details.attribute3
557: ,l_gme_material_details.attribute4
558: ,l_gme_material_details.attribute5
559: ,l_gme_material_details.attribute6
560: ,l_gme_material_details.attribute7
561: ,l_gme_material_details.attribute8
562: ,l_gme_material_details.attribute9
563: ,l_gme_material_details.attribute10
556: ,l_gme_material_details.attribute3
557: ,l_gme_material_details.attribute4
558: ,l_gme_material_details.attribute5
559: ,l_gme_material_details.attribute6
560: ,l_gme_material_details.attribute7
561: ,l_gme_material_details.attribute8
562: ,l_gme_material_details.attribute9
563: ,l_gme_material_details.attribute10
564: ,l_gme_material_details.attribute11
557: ,l_gme_material_details.attribute4
558: ,l_gme_material_details.attribute5
559: ,l_gme_material_details.attribute6
560: ,l_gme_material_details.attribute7
561: ,l_gme_material_details.attribute8
562: ,l_gme_material_details.attribute9
563: ,l_gme_material_details.attribute10
564: ,l_gme_material_details.attribute11
565: ,l_gme_material_details.attribute12
558: ,l_gme_material_details.attribute5
559: ,l_gme_material_details.attribute6
560: ,l_gme_material_details.attribute7
561: ,l_gme_material_details.attribute8
562: ,l_gme_material_details.attribute9
563: ,l_gme_material_details.attribute10
564: ,l_gme_material_details.attribute11
565: ,l_gme_material_details.attribute12
566: ,l_gme_material_details.attribute13
559: ,l_gme_material_details.attribute6
560: ,l_gme_material_details.attribute7
561: ,l_gme_material_details.attribute8
562: ,l_gme_material_details.attribute9
563: ,l_gme_material_details.attribute10
564: ,l_gme_material_details.attribute11
565: ,l_gme_material_details.attribute12
566: ,l_gme_material_details.attribute13
567: ,l_gme_material_details.attribute14
560: ,l_gme_material_details.attribute7
561: ,l_gme_material_details.attribute8
562: ,l_gme_material_details.attribute9
563: ,l_gme_material_details.attribute10
564: ,l_gme_material_details.attribute11
565: ,l_gme_material_details.attribute12
566: ,l_gme_material_details.attribute13
567: ,l_gme_material_details.attribute14
568: ,l_gme_material_details.attribute15
561: ,l_gme_material_details.attribute8
562: ,l_gme_material_details.attribute9
563: ,l_gme_material_details.attribute10
564: ,l_gme_material_details.attribute11
565: ,l_gme_material_details.attribute12
566: ,l_gme_material_details.attribute13
567: ,l_gme_material_details.attribute14
568: ,l_gme_material_details.attribute15
569: ,l_gme_material_details.attribute16
562: ,l_gme_material_details.attribute9
563: ,l_gme_material_details.attribute10
564: ,l_gme_material_details.attribute11
565: ,l_gme_material_details.attribute12
566: ,l_gme_material_details.attribute13
567: ,l_gme_material_details.attribute14
568: ,l_gme_material_details.attribute15
569: ,l_gme_material_details.attribute16
570: ,l_gme_material_details.attribute17
563: ,l_gme_material_details.attribute10
564: ,l_gme_material_details.attribute11
565: ,l_gme_material_details.attribute12
566: ,l_gme_material_details.attribute13
567: ,l_gme_material_details.attribute14
568: ,l_gme_material_details.attribute15
569: ,l_gme_material_details.attribute16
570: ,l_gme_material_details.attribute17
571: ,l_gme_material_details.attribute18
564: ,l_gme_material_details.attribute11
565: ,l_gme_material_details.attribute12
566: ,l_gme_material_details.attribute13
567: ,l_gme_material_details.attribute14
568: ,l_gme_material_details.attribute15
569: ,l_gme_material_details.attribute16
570: ,l_gme_material_details.attribute17
571: ,l_gme_material_details.attribute18
572: ,l_gme_material_details.attribute19
565: ,l_gme_material_details.attribute12
566: ,l_gme_material_details.attribute13
567: ,l_gme_material_details.attribute14
568: ,l_gme_material_details.attribute15
569: ,l_gme_material_details.attribute16
570: ,l_gme_material_details.attribute17
571: ,l_gme_material_details.attribute18
572: ,l_gme_material_details.attribute19
573: ,l_gme_material_details.attribute20
566: ,l_gme_material_details.attribute13
567: ,l_gme_material_details.attribute14
568: ,l_gme_material_details.attribute15
569: ,l_gme_material_details.attribute16
570: ,l_gme_material_details.attribute17
571: ,l_gme_material_details.attribute18
572: ,l_gme_material_details.attribute19
573: ,l_gme_material_details.attribute20
574: ,l_gme_material_details.attribute21
567: ,l_gme_material_details.attribute14
568: ,l_gme_material_details.attribute15
569: ,l_gme_material_details.attribute16
570: ,l_gme_material_details.attribute17
571: ,l_gme_material_details.attribute18
572: ,l_gme_material_details.attribute19
573: ,l_gme_material_details.attribute20
574: ,l_gme_material_details.attribute21
575: ,l_gme_material_details.attribute22
568: ,l_gme_material_details.attribute15
569: ,l_gme_material_details.attribute16
570: ,l_gme_material_details.attribute17
571: ,l_gme_material_details.attribute18
572: ,l_gme_material_details.attribute19
573: ,l_gme_material_details.attribute20
574: ,l_gme_material_details.attribute21
575: ,l_gme_material_details.attribute22
576: ,l_gme_material_details.attribute23
569: ,l_gme_material_details.attribute16
570: ,l_gme_material_details.attribute17
571: ,l_gme_material_details.attribute18
572: ,l_gme_material_details.attribute19
573: ,l_gme_material_details.attribute20
574: ,l_gme_material_details.attribute21
575: ,l_gme_material_details.attribute22
576: ,l_gme_material_details.attribute23
577: ,l_gme_material_details.attribute24
570: ,l_gme_material_details.attribute17
571: ,l_gme_material_details.attribute18
572: ,l_gme_material_details.attribute19
573: ,l_gme_material_details.attribute20
574: ,l_gme_material_details.attribute21
575: ,l_gme_material_details.attribute22
576: ,l_gme_material_details.attribute23
577: ,l_gme_material_details.attribute24
578: ,l_gme_material_details.attribute25
571: ,l_gme_material_details.attribute18
572: ,l_gme_material_details.attribute19
573: ,l_gme_material_details.attribute20
574: ,l_gme_material_details.attribute21
575: ,l_gme_material_details.attribute22
576: ,l_gme_material_details.attribute23
577: ,l_gme_material_details.attribute24
578: ,l_gme_material_details.attribute25
579: ,l_gme_material_details.attribute26
572: ,l_gme_material_details.attribute19
573: ,l_gme_material_details.attribute20
574: ,l_gme_material_details.attribute21
575: ,l_gme_material_details.attribute22
576: ,l_gme_material_details.attribute23
577: ,l_gme_material_details.attribute24
578: ,l_gme_material_details.attribute25
579: ,l_gme_material_details.attribute26
580: ,l_gme_material_details.attribute27
573: ,l_gme_material_details.attribute20
574: ,l_gme_material_details.attribute21
575: ,l_gme_material_details.attribute22
576: ,l_gme_material_details.attribute23
577: ,l_gme_material_details.attribute24
578: ,l_gme_material_details.attribute25
579: ,l_gme_material_details.attribute26
580: ,l_gme_material_details.attribute27
581: ,l_gme_material_details.attribute28
574: ,l_gme_material_details.attribute21
575: ,l_gme_material_details.attribute22
576: ,l_gme_material_details.attribute23
577: ,l_gme_material_details.attribute24
578: ,l_gme_material_details.attribute25
579: ,l_gme_material_details.attribute26
580: ,l_gme_material_details.attribute27
581: ,l_gme_material_details.attribute28
582: ,l_gme_material_details.attribute29
575: ,l_gme_material_details.attribute22
576: ,l_gme_material_details.attribute23
577: ,l_gme_material_details.attribute24
578: ,l_gme_material_details.attribute25
579: ,l_gme_material_details.attribute26
580: ,l_gme_material_details.attribute27
581: ,l_gme_material_details.attribute28
582: ,l_gme_material_details.attribute29
583: ,l_gme_material_details.attribute30
576: ,l_gme_material_details.attribute23
577: ,l_gme_material_details.attribute24
578: ,l_gme_material_details.attribute25
579: ,l_gme_material_details.attribute26
580: ,l_gme_material_details.attribute27
581: ,l_gme_material_details.attribute28
582: ,l_gme_material_details.attribute29
583: ,l_gme_material_details.attribute30
584: ,l_gme_material_details.attribute_category
577: ,l_gme_material_details.attribute24
578: ,l_gme_material_details.attribute25
579: ,l_gme_material_details.attribute26
580: ,l_gme_material_details.attribute27
581: ,l_gme_material_details.attribute28
582: ,l_gme_material_details.attribute29
583: ,l_gme_material_details.attribute30
584: ,l_gme_material_details.attribute_category
585: ,l_gme_material_details.last_update_login
578: ,l_gme_material_details.attribute25
579: ,l_gme_material_details.attribute26
580: ,l_gme_material_details.attribute27
581: ,l_gme_material_details.attribute28
582: ,l_gme_material_details.attribute29
583: ,l_gme_material_details.attribute30
584: ,l_gme_material_details.attribute_category
585: ,l_gme_material_details.last_update_login
586: ,l_gme_material_details.scale_rounding_variance
579: ,l_gme_material_details.attribute26
580: ,l_gme_material_details.attribute27
581: ,l_gme_material_details.attribute28
582: ,l_gme_material_details.attribute29
583: ,l_gme_material_details.attribute30
584: ,l_gme_material_details.attribute_category
585: ,l_gme_material_details.last_update_login
586: ,l_gme_material_details.scale_rounding_variance
587: ,l_gme_material_details.scale_multiple
580: ,l_gme_material_details.attribute27
581: ,l_gme_material_details.attribute28
582: ,l_gme_material_details.attribute29
583: ,l_gme_material_details.attribute30
584: ,l_gme_material_details.attribute_category
585: ,l_gme_material_details.last_update_login
586: ,l_gme_material_details.scale_rounding_variance
587: ,l_gme_material_details.scale_multiple
588: ,l_gme_material_details.rounding_direction
581: ,l_gme_material_details.attribute28
582: ,l_gme_material_details.attribute29
583: ,l_gme_material_details.attribute30
584: ,l_gme_material_details.attribute_category
585: ,l_gme_material_details.last_update_login
586: ,l_gme_material_details.scale_rounding_variance
587: ,l_gme_material_details.scale_multiple
588: ,l_gme_material_details.rounding_direction
589: ,l_gme_material_details.contribute_yield_ind
582: ,l_gme_material_details.attribute29
583: ,l_gme_material_details.attribute30
584: ,l_gme_material_details.attribute_category
585: ,l_gme_material_details.last_update_login
586: ,l_gme_material_details.scale_rounding_variance
587: ,l_gme_material_details.scale_multiple
588: ,l_gme_material_details.rounding_direction
589: ,l_gme_material_details.contribute_yield_ind
590: ,l_gme_material_details.contribute_step_qty_ind
583: ,l_gme_material_details.attribute30
584: ,l_gme_material_details.attribute_category
585: ,l_gme_material_details.last_update_login
586: ,l_gme_material_details.scale_rounding_variance
587: ,l_gme_material_details.scale_multiple
588: ,l_gme_material_details.rounding_direction
589: ,l_gme_material_details.contribute_yield_ind
590: ,l_gme_material_details.contribute_step_qty_ind
591: ,l_gme_material_details.wip_plan_qty
584: ,l_gme_material_details.attribute_category
585: ,l_gme_material_details.last_update_login
586: ,l_gme_material_details.scale_rounding_variance
587: ,l_gme_material_details.scale_multiple
588: ,l_gme_material_details.rounding_direction
589: ,l_gme_material_details.contribute_yield_ind
590: ,l_gme_material_details.contribute_step_qty_ind
591: ,l_gme_material_details.wip_plan_qty
592: ,l_gme_material_details.original_qty
585: ,l_gme_material_details.last_update_login
586: ,l_gme_material_details.scale_rounding_variance
587: ,l_gme_material_details.scale_multiple
588: ,l_gme_material_details.rounding_direction
589: ,l_gme_material_details.contribute_yield_ind
590: ,l_gme_material_details.contribute_step_qty_ind
591: ,l_gme_material_details.wip_plan_qty
592: ,l_gme_material_details.original_qty
593: ,l_gme_material_details.by_product_type
586: ,l_gme_material_details.scale_rounding_variance
587: ,l_gme_material_details.scale_multiple
588: ,l_gme_material_details.rounding_direction
589: ,l_gme_material_details.contribute_yield_ind
590: ,l_gme_material_details.contribute_step_qty_ind
591: ,l_gme_material_details.wip_plan_qty
592: ,l_gme_material_details.original_qty
593: ,l_gme_material_details.by_product_type
594: ,l_gme_material_details.organization_id
587: ,l_gme_material_details.scale_multiple
588: ,l_gme_material_details.rounding_direction
589: ,l_gme_material_details.contribute_yield_ind
590: ,l_gme_material_details.contribute_step_qty_ind
591: ,l_gme_material_details.wip_plan_qty
592: ,l_gme_material_details.original_qty
593: ,l_gme_material_details.by_product_type
594: ,l_gme_material_details.organization_id
595: ,l_gme_material_details.inventory_item_id
588: ,l_gme_material_details.rounding_direction
589: ,l_gme_material_details.contribute_yield_ind
590: ,l_gme_material_details.contribute_step_qty_ind
591: ,l_gme_material_details.wip_plan_qty
592: ,l_gme_material_details.original_qty
593: ,l_gme_material_details.by_product_type
594: ,l_gme_material_details.organization_id
595: ,l_gme_material_details.inventory_item_id
596: ,l_gme_material_details.subinventory
589: ,l_gme_material_details.contribute_yield_ind
590: ,l_gme_material_details.contribute_step_qty_ind
591: ,l_gme_material_details.wip_plan_qty
592: ,l_gme_material_details.original_qty
593: ,l_gme_material_details.by_product_type
594: ,l_gme_material_details.organization_id
595: ,l_gme_material_details.inventory_item_id
596: ,l_gme_material_details.subinventory
597: ,l_gme_material_details.locator_id
590: ,l_gme_material_details.contribute_step_qty_ind
591: ,l_gme_material_details.wip_plan_qty
592: ,l_gme_material_details.original_qty
593: ,l_gme_material_details.by_product_type
594: ,l_gme_material_details.organization_id
595: ,l_gme_material_details.inventory_item_id
596: ,l_gme_material_details.subinventory
597: ,l_gme_material_details.locator_id
598: ,l_gme_material_details.revision
591: ,l_gme_material_details.wip_plan_qty
592: ,l_gme_material_details.original_qty
593: ,l_gme_material_details.by_product_type
594: ,l_gme_material_details.organization_id
595: ,l_gme_material_details.inventory_item_id
596: ,l_gme_material_details.subinventory
597: ,l_gme_material_details.locator_id
598: ,l_gme_material_details.revision
599: ,l_gme_material_details.backordered_qty
592: ,l_gme_material_details.original_qty
593: ,l_gme_material_details.by_product_type
594: ,l_gme_material_details.organization_id
595: ,l_gme_material_details.inventory_item_id
596: ,l_gme_material_details.subinventory
597: ,l_gme_material_details.locator_id
598: ,l_gme_material_details.revision
599: ,l_gme_material_details.backordered_qty
600: ,l_gme_material_details.original_primary_qty
593: ,l_gme_material_details.by_product_type
594: ,l_gme_material_details.organization_id
595: ,l_gme_material_details.inventory_item_id
596: ,l_gme_material_details.subinventory
597: ,l_gme_material_details.locator_id
598: ,l_gme_material_details.revision
599: ,l_gme_material_details.backordered_qty
600: ,l_gme_material_details.original_primary_qty
601: ,l_gme_material_details.material_requirement_date
594: ,l_gme_material_details.organization_id
595: ,l_gme_material_details.inventory_item_id
596: ,l_gme_material_details.subinventory
597: ,l_gme_material_details.locator_id
598: ,l_gme_material_details.revision
599: ,l_gme_material_details.backordered_qty
600: ,l_gme_material_details.original_primary_qty
601: ,l_gme_material_details.material_requirement_date
602: ,l_gme_material_details.phantom_line_id
595: ,l_gme_material_details.inventory_item_id
596: ,l_gme_material_details.subinventory
597: ,l_gme_material_details.locator_id
598: ,l_gme_material_details.revision
599: ,l_gme_material_details.backordered_qty
600: ,l_gme_material_details.original_primary_qty
601: ,l_gme_material_details.material_requirement_date
602: ,l_gme_material_details.phantom_line_id
603: ,l_gme_material_details.move_order_line_id
596: ,l_gme_material_details.subinventory
597: ,l_gme_material_details.locator_id
598: ,l_gme_material_details.revision
599: ,l_gme_material_details.backordered_qty
600: ,l_gme_material_details.original_primary_qty
601: ,l_gme_material_details.material_requirement_date
602: ,l_gme_material_details.phantom_line_id
603: ,l_gme_material_details.move_order_line_id
604: ,l_gme_material_details.dtl_um
597: ,l_gme_material_details.locator_id
598: ,l_gme_material_details.revision
599: ,l_gme_material_details.backordered_qty
600: ,l_gme_material_details.original_primary_qty
601: ,l_gme_material_details.material_requirement_date
602: ,l_gme_material_details.phantom_line_id
603: ,l_gme_material_details.move_order_line_id
604: ,l_gme_material_details.dtl_um
605: ,l_gme_material_details.dispense_ind
598: ,l_gme_material_details.revision
599: ,l_gme_material_details.backordered_qty
600: ,l_gme_material_details.original_primary_qty
601: ,l_gme_material_details.material_requirement_date
602: ,l_gme_material_details.phantom_line_id
603: ,l_gme_material_details.move_order_line_id
604: ,l_gme_material_details.dtl_um
605: ,l_gme_material_details.dispense_ind
606:
599: ,l_gme_material_details.backordered_qty
600: ,l_gme_material_details.original_primary_qty
601: ,l_gme_material_details.material_requirement_date
602: ,l_gme_material_details.phantom_line_id
603: ,l_gme_material_details.move_order_line_id
604: ,l_gme_material_details.dtl_um
605: ,l_gme_material_details.dispense_ind
606:
607: FROM gme_material_details
600: ,l_gme_material_details.original_primary_qty
601: ,l_gme_material_details.material_requirement_date
602: ,l_gme_material_details.phantom_line_id
603: ,l_gme_material_details.move_order_line_id
604: ,l_gme_material_details.dtl_um
605: ,l_gme_material_details.dispense_ind
606:
607: FROM gme_material_details
608: WHERE batch_id = l_batch_id
601: ,l_gme_material_details.material_requirement_date
602: ,l_gme_material_details.phantom_line_id
603: ,l_gme_material_details.move_order_line_id
604: ,l_gme_material_details.dtl_um
605: ,l_gme_material_details.dispense_ind
606:
607: FROM gme_material_details
608: WHERE batch_id = l_batch_id
609: AND line_no = l_line_no
603: ,l_gme_material_details.move_order_line_id
604: ,l_gme_material_details.dtl_um
605: ,l_gme_material_details.dispense_ind
606:
607: FROM gme_material_details
608: WHERE batch_id = l_batch_id
609: AND line_no = l_line_no
610: AND line_type = l_line_type;
611: ELSE
615: RETURN FALSE;
616: END IF;
617:
618: IF (SQL%FOUND) THEN
619: x_material_detail := l_gme_material_details;
620: RETURN TRUE;
621: ELSE
622: gme_common_pvt.log_message ('GME_NO_DATA_FOUND'
623: ,'TABLE_NAME'
621: ELSE
622: gme_common_pvt.log_message ('GME_NO_DATA_FOUND'
623: ,'TABLE_NAME'
624: ,g_table_name);
625: x_material_detail := l_gme_material_details;
626: RETURN FALSE;
627: END IF;
628: EXCEPTION
629: WHEN NO_DATA_FOUND THEN
653: | TYPE |
654: | Private |
655: | |
656: | USAGE |
657: | delete_Row will delete a row in gme_material_details |
658: | |
659: | |
660: | DESCRIPTION |
661: | delete_row will delete a row in gme_material_details |
657: | delete_Row will delete a row in gme_material_details |
658: | |
659: | |
660: | DESCRIPTION |
661: | delete_row will delete a row in gme_material_details |
662: | |
663: | |
664: | PARAMETERS |
665: | p_material_detail IN gme_material_details%ROWTYPE |
661: | delete_row will delete a row in gme_material_details |
662: | |
663: | |
664: | PARAMETERS |
665: | p_material_detail IN gme_material_details%ROWTYPE |
666: | RETURNS |
667: | BOOLEAN |
668: | |
669: | HISTORY |
672: | Added Error message 'GME_RECORD_CHANGED' |
673: +==========================================================================+
674: Api end of comments
675: */
676: FUNCTION delete_row (p_material_detail IN gme_material_details%ROWTYPE)
677: RETURN BOOLEAN
678: IS
679: l_material_detail_id NUMBER;
680: l_batch_id NUMBER;
692:
693: IF l_material_detail_id IS NOT NULL THEN
694: SELECT 1
695: INTO l_dummy
696: FROM gme_material_details
697: WHERE material_detail_id = l_material_detail_id
698: FOR UPDATE NOWAIT;
699:
700: DELETE FROM gme_material_details
696: FROM gme_material_details
697: WHERE material_detail_id = l_material_detail_id
698: FOR UPDATE NOWAIT;
699:
700: DELETE FROM gme_material_details
701: WHERE material_detail_id = l_material_detail_id;
702: ELSIF (l_batch_id IS NOT NULL)
703: AND (l_line_no IS NOT NULL)
704: AND (l_line_type IS NOT NULL) THEN
703: AND (l_line_no IS NOT NULL)
704: AND (l_line_type IS NOT NULL) THEN
705: SELECT 1
706: INTO l_dummy
707: FROM gme_material_details
708: WHERE batch_id = l_batch_id
709: AND line_no = l_line_no
710: AND line_type = l_line_type
711: FOR UPDATE NOWAIT;
709: AND line_no = l_line_no
710: AND line_type = l_line_type
711: FOR UPDATE NOWAIT;
712:
713: DELETE FROM gme_material_details
714: WHERE batch_id = l_batch_id
715: AND line_no = l_line_no
716: AND line_type = l_line_type;
717: ELSE
782: | TYPE |
783: | Private |
784: | |
785: | USAGE |
786: | update_row will update a row in gme_material_details |
787: | |
788: | |
789: | DESCRIPTION |
790: | update_row will update a row in gme_material_details |
786: | update_row will update a row in gme_material_details |
787: | |
788: | |
789: | DESCRIPTION |
790: | update_row will update a row in gme_material_details |
791: | |
792: | |
793: | PARAMETERS |
794: | p_material_detail IN gme_material_details%ROWTYPE |
790: | update_row will update a row in gme_material_details |
791: | |
792: | |
793: | PARAMETERS |
794: | p_material_detail IN gme_material_details%ROWTYPE |
795: | RETURNS |
796: | BOOLEAN | |
797: | HISTORY |
798: | 12-FEB-2001 fabdi Created
806: left additional debug messages in here for future use.
807: +==========================================================================+
808: Api end of comments
809: */
810: FUNCTION update_row (p_material_detail IN gme_material_details%ROWTYPE
811: ,p_called_by IN VARCHAR2 DEFAULT 'U')
812: RETURN BOOLEAN
813: IS
814: l_material_detail_id NUMBER;
839:
840: IF l_material_detail_id IS NOT NULL THEN
841: SELECT 1, last_update_date
842: INTO l_dummy, l_upd
843: FROM gme_material_details
844: WHERE material_detail_id = l_material_detail_id
845: FOR UPDATE NOWAIT;
846:
847: UPDATE gme_material_details
843: FROM gme_material_details
844: WHERE material_detail_id = l_material_detail_id
845: FOR UPDATE NOWAIT;
846:
847: UPDATE gme_material_details
848: SET formulaline_id = p_material_detail.formulaline_id
849: ,line_no = p_material_detail.line_no
850: ,
851: --item_id = p_material_detail.item_id,
929: AND (l_line_no IS NOT NULL)
930: AND (l_line_type IS NOT NULL) THEN
931: SELECT 1
932: INTO l_dummy
933: FROM gme_material_details
934: WHERE batch_id = l_batch_id
935: AND line_no = l_line_no
936: AND line_type = l_line_type
937: FOR UPDATE NOWAIT;
935: AND line_no = l_line_no
936: AND line_type = l_line_type
937: FOR UPDATE NOWAIT;
938:
939: UPDATE gme_material_details
940: SET formulaline_id = p_material_detail.formulaline_id
941: ,line_no = p_material_detail.line_no
942: ,line_type = p_material_detail.line_type
943: ,plan_qty = p_material_detail.plan_qty
1101: | TYPE |
1102: | Private |
1103: | |
1104: | USAGE |
1105: | fetch_tab will fetch a tab in gme_material_details |
1106: | |
1107: | |
1108: | DESCRIPTION |
1109: | fetch_tab will fetch a tab in gme_material_details |
1105: | fetch_tab will fetch a tab in gme_material_details |
1106: | |
1107: | |
1108: | DESCRIPTION |
1109: | fetch_tab will fetch a tab in gme_material_details |
1110: | |
1111: | |
1112: | PARAMETERS |
1113: | p_material_detail IN gme_material_details%ROWTYPE |
1109: | fetch_tab will fetch a tab in gme_material_details |
1110: | |
1111: | |
1112: | PARAMETERS |
1113: | p_material_detail IN gme_material_details%ROWTYPE |
1114: | x_material_detail IN OUT NOCOPY GME_API_GRP.material_details_tab |
1115: | |
1116: | RETURNS |
1117: | BOOLEAN |
1121: | |
1122: +==========================================================================+
1123: */
1124: FUNCTION fetch_tab (
1125: p_material_detail IN gme_material_details%ROWTYPE
1126: ,x_material_detail IN OUT NOCOPY gme_common_pvt.material_details_tab)
1127: RETURN BOOLEAN
1128: IS
1129: i NUMBER := 0;
1131:
1132: CURSOR c_material_dtl_0 (l_batch_id IN NUMBER)
1133: IS
1134: SELECT *
1135: FROM gme_material_details
1136: WHERE batch_id = l_batch_id;
1137:
1138: CURSOR c_material_dtl_1 (l_mat_dtl_id IN NUMBER)
1139: IS
1137:
1138: CURSOR c_material_dtl_1 (l_mat_dtl_id IN NUMBER)
1139: IS
1140: SELECT *
1141: FROM gme_material_details
1142: WHERE material_detail_id = l_mat_dtl_id;
1143:
1144: CURSOR c_material_dtl_2 (
1145: l_batch_id IN NUMBER
1146: ,l_line_no IN NUMBER
1147: ,l_line_type IN NUMBER)
1148: IS
1149: SELECT *
1150: FROM gme_material_details
1151: WHERE batch_id = l_batch_id
1152: AND line_no = l_line_no
1153: AND line_type = l_line_type;
1154: BEGIN
1257:
1258: gme_common_pvt.log_message ('GME_UNEXPECTED_ERROR', 'ERROR', SQLERRM);
1259: RETURN FALSE;
1260: END fetch_tab;
1261: END gme_material_details_dbl;