1: PACKAGE BODY gme_batch_header_dbl AS
2: /* $Header: GMEVGBHB.pls 120.4.12010000.2 2008/11/11 09:34:46 ssangane noship $ */
3:
4: /* Global Variables */
5: g_table_name VARCHAR2 (80) DEFAULT 'GME_BATCH_HEADER';
1: PACKAGE BODY gme_batch_header_dbl AS
2: /* $Header: GMEVGBHB.pls 120.4.12010000.2 2008/11/11 09:34:46 ssangane noship $ */
3:
4: /* Global Variables */
5: g_table_name VARCHAR2 (80) DEFAULT 'GME_BATCH_HEADER';
6: g_debug VARCHAR2 (5) := fnd_profile.VALUE ('AFLOG_LEVEL');
7: g_pkg_name CONSTANT VARCHAR2 (30) := 'GME_BATCH_HEADER_DBL';
8:
9: /* ===========================================================================
3:
4: /* Global Variables */
5: g_table_name VARCHAR2 (80) DEFAULT 'GME_BATCH_HEADER';
6: g_debug VARCHAR2 (5) := fnd_profile.VALUE ('AFLOG_LEVEL');
7: g_pkg_name CONSTANT VARCHAR2 (30) := 'GME_BATCH_HEADER_DBL';
8:
9: /* ===========================================================================
10: | Copyright (c) 2001 Oracle Corporation |
11: | TVP, Reading, England |
15: | GMEVGBHB.pls |
16: | |
17: | DESCRIPTION |
18: | |
19: | Body of package gme_batch_header_dbl |
20: | |
21: | NOTES |
22: | |
23: | HISTORY |
41: | TYPE |
42: | Private |
43: | |
44: | USAGE |
45: | insert_Row will insert a row in gme_batch_header |
46: | |
47: | |
48: | DESCRIPTION |
49: | insert_Row will insert a row in gme_batch_header |
45: | insert_Row will insert a row in gme_batch_header |
46: | |
47: | |
48: | DESCRIPTION |
49: | insert_Row will insert a row in gme_batch_header |
50: | |
51: | |
52: | PARAMETERS |
53: | p_batch_header IN gme_batch_header%ROWTYPE |
49: | insert_Row will insert a row in gme_batch_header |
50: | |
51: | |
52: | PARAMETERS |
53: | p_batch_header IN gme_batch_header%ROWTYPE |
54: | x_batch_header IN OUT NOCOPY gme_batch_header%ROWTYPE |
55: | RETURNS |
56: | BOOLEAN |
57: | |
50: | |
51: | |
52: | PARAMETERS |
53: | p_batch_header IN gme_batch_header%ROWTYPE |
54: | x_batch_header IN OUT NOCOPY gme_batch_header%ROWTYPE |
55: | RETURNS |
56: | BOOLEAN |
57: | |
58: | HISTORY |
61: +==========================================================================+
62: Api end of comments
63: */
64: FUNCTION insert_row (
65: p_batch_header IN gme_batch_header%ROWTYPE
66: ,x_batch_header IN OUT NOCOPY gme_batch_header%ROWTYPE)
67: RETURN BOOLEAN
68: IS
69: l_api_name CONSTANT VARCHAR2 (30) := 'INSERT_ROW';
62: Api end of comments
63: */
64: FUNCTION insert_row (
65: p_batch_header IN gme_batch_header%ROWTYPE
66: ,x_batch_header IN OUT NOCOPY gme_batch_header%ROWTYPE)
67: RETURN BOOLEAN
68: IS
69: l_api_name CONSTANT VARCHAR2 (30) := 'INSERT_ROW';
70: l_wip_entity_id NUMBER;
107: ,0, gme_common_pvt.g_wip_entity_type_batch
108: ,gme_common_pvt.g_wip_entity_type_fpo)
109: ,mtl_gen_object_id_s.NEXTVAL);
110:
111: INSERT INTO gme_batch_header
112: (batch_id, batch_no
113: ,batch_type, prod_id
114: ,prod_sequence
115: ,recipe_validity_rule_id
252: | TYPE |
253: | Private |
254: | |
255: | USAGE |
256: | fetch_Row will fetch a row in gme_batch_header |
257: | |
258: | |
259: | DESCRIPTION |
260: | fetch_row will fetch a row in gme_batch_header |
256: | fetch_Row will fetch a row in gme_batch_header |
257: | |
258: | |
259: | DESCRIPTION |
260: | fetch_row will fetch a row in gme_batch_header |
261: | |
262: | |
263: | PARAMETERS |
264: | p_batch_header IN gme_batch_header%ROWTYPE |
260: | fetch_row will fetch a row in gme_batch_header |
261: | |
262: | |
263: | PARAMETERS |
264: | p_batch_header IN gme_batch_header%ROWTYPE |
265: | x_batch_header IN OUT NOCOPY gme_batch_header%ROWTYPE |
266: | RETURNS |
267: | BOOLEAN |
268: | |
261: | |
262: | |
263: | PARAMETERS |
264: | p_batch_header IN gme_batch_header%ROWTYPE |
265: | x_batch_header IN OUT NOCOPY gme_batch_header%ROWTYPE |
266: | RETURNS |
267: | BOOLEAN |
268: | |
269: | HISTORY |
271: +==========================================================================+
272: Api end of comments
273: */
274: FUNCTION fetch_row (
275: p_batch_header IN gme_batch_header%ROWTYPE
276: ,x_batch_header IN OUT NOCOPY gme_batch_header%ROWTYPE)
277: RETURN BOOLEAN
278: IS
279: l_gme_batch_header gme_batch_header%ROWTYPE;
272: Api end of comments
273: */
274: FUNCTION fetch_row (
275: p_batch_header IN gme_batch_header%ROWTYPE
276: ,x_batch_header IN OUT NOCOPY gme_batch_header%ROWTYPE)
277: RETURN BOOLEAN
278: IS
279: l_gme_batch_header gme_batch_header%ROWTYPE;
280: l_batch_id NUMBER;
275: p_batch_header IN gme_batch_header%ROWTYPE
276: ,x_batch_header IN OUT NOCOPY gme_batch_header%ROWTYPE)
277: RETURN BOOLEAN
278: IS
279: l_gme_batch_header gme_batch_header%ROWTYPE;
280: l_batch_id NUMBER;
281: l_organization_id NUMBER;
282: l_batch_no VARCHAR2 (32);
283: l_batch_type NUMBER (5);
384: ,enhanced_pi_ind
385: ,move_order_header_id
386: ,terminate_reason_id
387: ,fixed_process_loss_applied
388: INTO l_gme_batch_header.batch_id
389: --, l_gme_batch_header.PLANT_CODE
390: , l_gme_batch_header.batch_no
391: ,l_gme_batch_header.batch_type, l_gme_batch_header.prod_id
392: ,l_gme_batch_header.prod_sequence
385: ,move_order_header_id
386: ,terminate_reason_id
387: ,fixed_process_loss_applied
388: INTO l_gme_batch_header.batch_id
389: --, l_gme_batch_header.PLANT_CODE
390: , l_gme_batch_header.batch_no
391: ,l_gme_batch_header.batch_type, l_gme_batch_header.prod_id
392: ,l_gme_batch_header.prod_sequence
393: ,l_gme_batch_header.recipe_validity_rule_id
386: ,terminate_reason_id
387: ,fixed_process_loss_applied
388: INTO l_gme_batch_header.batch_id
389: --, l_gme_batch_header.PLANT_CODE
390: , l_gme_batch_header.batch_no
391: ,l_gme_batch_header.batch_type, l_gme_batch_header.prod_id
392: ,l_gme_batch_header.prod_sequence
393: ,l_gme_batch_header.recipe_validity_rule_id
394: ,l_gme_batch_header.formula_id
387: ,fixed_process_loss_applied
388: INTO l_gme_batch_header.batch_id
389: --, l_gme_batch_header.PLANT_CODE
390: , l_gme_batch_header.batch_no
391: ,l_gme_batch_header.batch_type, l_gme_batch_header.prod_id
392: ,l_gme_batch_header.prod_sequence
393: ,l_gme_batch_header.recipe_validity_rule_id
394: ,l_gme_batch_header.formula_id
395: ,l_gme_batch_header.routing_id
388: INTO l_gme_batch_header.batch_id
389: --, l_gme_batch_header.PLANT_CODE
390: , l_gme_batch_header.batch_no
391: ,l_gme_batch_header.batch_type, l_gme_batch_header.prod_id
392: ,l_gme_batch_header.prod_sequence
393: ,l_gme_batch_header.recipe_validity_rule_id
394: ,l_gme_batch_header.formula_id
395: ,l_gme_batch_header.routing_id
396: ,l_gme_batch_header.plan_start_date
389: --, l_gme_batch_header.PLANT_CODE
390: , l_gme_batch_header.batch_no
391: ,l_gme_batch_header.batch_type, l_gme_batch_header.prod_id
392: ,l_gme_batch_header.prod_sequence
393: ,l_gme_batch_header.recipe_validity_rule_id
394: ,l_gme_batch_header.formula_id
395: ,l_gme_batch_header.routing_id
396: ,l_gme_batch_header.plan_start_date
397: ,l_gme_batch_header.actual_start_date
390: , l_gme_batch_header.batch_no
391: ,l_gme_batch_header.batch_type, l_gme_batch_header.prod_id
392: ,l_gme_batch_header.prod_sequence
393: ,l_gme_batch_header.recipe_validity_rule_id
394: ,l_gme_batch_header.formula_id
395: ,l_gme_batch_header.routing_id
396: ,l_gme_batch_header.plan_start_date
397: ,l_gme_batch_header.actual_start_date
398: ,l_gme_batch_header.due_date
391: ,l_gme_batch_header.batch_type, l_gme_batch_header.prod_id
392: ,l_gme_batch_header.prod_sequence
393: ,l_gme_batch_header.recipe_validity_rule_id
394: ,l_gme_batch_header.formula_id
395: ,l_gme_batch_header.routing_id
396: ,l_gme_batch_header.plan_start_date
397: ,l_gme_batch_header.actual_start_date
398: ,l_gme_batch_header.due_date
399: ,l_gme_batch_header.plan_cmplt_date
392: ,l_gme_batch_header.prod_sequence
393: ,l_gme_batch_header.recipe_validity_rule_id
394: ,l_gme_batch_header.formula_id
395: ,l_gme_batch_header.routing_id
396: ,l_gme_batch_header.plan_start_date
397: ,l_gme_batch_header.actual_start_date
398: ,l_gme_batch_header.due_date
399: ,l_gme_batch_header.plan_cmplt_date
400: ,l_gme_batch_header.actual_cmplt_date
393: ,l_gme_batch_header.recipe_validity_rule_id
394: ,l_gme_batch_header.formula_id
395: ,l_gme_batch_header.routing_id
396: ,l_gme_batch_header.plan_start_date
397: ,l_gme_batch_header.actual_start_date
398: ,l_gme_batch_header.due_date
399: ,l_gme_batch_header.plan_cmplt_date
400: ,l_gme_batch_header.actual_cmplt_date
401: ,l_gme_batch_header.batch_status
394: ,l_gme_batch_header.formula_id
395: ,l_gme_batch_header.routing_id
396: ,l_gme_batch_header.plan_start_date
397: ,l_gme_batch_header.actual_start_date
398: ,l_gme_batch_header.due_date
399: ,l_gme_batch_header.plan_cmplt_date
400: ,l_gme_batch_header.actual_cmplt_date
401: ,l_gme_batch_header.batch_status
402: ,l_gme_batch_header.priority_value
395: ,l_gme_batch_header.routing_id
396: ,l_gme_batch_header.plan_start_date
397: ,l_gme_batch_header.actual_start_date
398: ,l_gme_batch_header.due_date
399: ,l_gme_batch_header.plan_cmplt_date
400: ,l_gme_batch_header.actual_cmplt_date
401: ,l_gme_batch_header.batch_status
402: ,l_gme_batch_header.priority_value
403: ,l_gme_batch_header.priority_code
396: ,l_gme_batch_header.plan_start_date
397: ,l_gme_batch_header.actual_start_date
398: ,l_gme_batch_header.due_date
399: ,l_gme_batch_header.plan_cmplt_date
400: ,l_gme_batch_header.actual_cmplt_date
401: ,l_gme_batch_header.batch_status
402: ,l_gme_batch_header.priority_value
403: ,l_gme_batch_header.priority_code
404: ,l_gme_batch_header.print_count
397: ,l_gme_batch_header.actual_start_date
398: ,l_gme_batch_header.due_date
399: ,l_gme_batch_header.plan_cmplt_date
400: ,l_gme_batch_header.actual_cmplt_date
401: ,l_gme_batch_header.batch_status
402: ,l_gme_batch_header.priority_value
403: ,l_gme_batch_header.priority_code
404: ,l_gme_batch_header.print_count
405: ,l_gme_batch_header.fmcontrol_class
398: ,l_gme_batch_header.due_date
399: ,l_gme_batch_header.plan_cmplt_date
400: ,l_gme_batch_header.actual_cmplt_date
401: ,l_gme_batch_header.batch_status
402: ,l_gme_batch_header.priority_value
403: ,l_gme_batch_header.priority_code
404: ,l_gme_batch_header.print_count
405: ,l_gme_batch_header.fmcontrol_class
406: --, l_gme_batch_header.WIP_WHSE_CODE
399: ,l_gme_batch_header.plan_cmplt_date
400: ,l_gme_batch_header.actual_cmplt_date
401: ,l_gme_batch_header.batch_status
402: ,l_gme_batch_header.priority_value
403: ,l_gme_batch_header.priority_code
404: ,l_gme_batch_header.print_count
405: ,l_gme_batch_header.fmcontrol_class
406: --, l_gme_batch_header.WIP_WHSE_CODE
407: , l_gme_batch_header.batch_close_date
400: ,l_gme_batch_header.actual_cmplt_date
401: ,l_gme_batch_header.batch_status
402: ,l_gme_batch_header.priority_value
403: ,l_gme_batch_header.priority_code
404: ,l_gme_batch_header.print_count
405: ,l_gme_batch_header.fmcontrol_class
406: --, l_gme_batch_header.WIP_WHSE_CODE
407: , l_gme_batch_header.batch_close_date
408: ,l_gme_batch_header.poc_ind
401: ,l_gme_batch_header.batch_status
402: ,l_gme_batch_header.priority_value
403: ,l_gme_batch_header.priority_code
404: ,l_gme_batch_header.print_count
405: ,l_gme_batch_header.fmcontrol_class
406: --, l_gme_batch_header.WIP_WHSE_CODE
407: , l_gme_batch_header.batch_close_date
408: ,l_gme_batch_header.poc_ind
409: ,l_gme_batch_header.actual_cost_ind
402: ,l_gme_batch_header.priority_value
403: ,l_gme_batch_header.priority_code
404: ,l_gme_batch_header.print_count
405: ,l_gme_batch_header.fmcontrol_class
406: --, l_gme_batch_header.WIP_WHSE_CODE
407: , l_gme_batch_header.batch_close_date
408: ,l_gme_batch_header.poc_ind
409: ,l_gme_batch_header.actual_cost_ind
410: ,l_gme_batch_header.gl_posted_ind
403: ,l_gme_batch_header.priority_code
404: ,l_gme_batch_header.print_count
405: ,l_gme_batch_header.fmcontrol_class
406: --, l_gme_batch_header.WIP_WHSE_CODE
407: , l_gme_batch_header.batch_close_date
408: ,l_gme_batch_header.poc_ind
409: ,l_gme_batch_header.actual_cost_ind
410: ,l_gme_batch_header.gl_posted_ind
411: ,l_gme_batch_header.update_inventory_ind
404: ,l_gme_batch_header.print_count
405: ,l_gme_batch_header.fmcontrol_class
406: --, l_gme_batch_header.WIP_WHSE_CODE
407: , l_gme_batch_header.batch_close_date
408: ,l_gme_batch_header.poc_ind
409: ,l_gme_batch_header.actual_cost_ind
410: ,l_gme_batch_header.gl_posted_ind
411: ,l_gme_batch_header.update_inventory_ind
412: ,l_gme_batch_header.last_update_date
405: ,l_gme_batch_header.fmcontrol_class
406: --, l_gme_batch_header.WIP_WHSE_CODE
407: , l_gme_batch_header.batch_close_date
408: ,l_gme_batch_header.poc_ind
409: ,l_gme_batch_header.actual_cost_ind
410: ,l_gme_batch_header.gl_posted_ind
411: ,l_gme_batch_header.update_inventory_ind
412: ,l_gme_batch_header.last_update_date
413: ,l_gme_batch_header.last_updated_by
406: --, l_gme_batch_header.WIP_WHSE_CODE
407: , l_gme_batch_header.batch_close_date
408: ,l_gme_batch_header.poc_ind
409: ,l_gme_batch_header.actual_cost_ind
410: ,l_gme_batch_header.gl_posted_ind
411: ,l_gme_batch_header.update_inventory_ind
412: ,l_gme_batch_header.last_update_date
413: ,l_gme_batch_header.last_updated_by
414: ,l_gme_batch_header.creation_date
407: , l_gme_batch_header.batch_close_date
408: ,l_gme_batch_header.poc_ind
409: ,l_gme_batch_header.actual_cost_ind
410: ,l_gme_batch_header.gl_posted_ind
411: ,l_gme_batch_header.update_inventory_ind
412: ,l_gme_batch_header.last_update_date
413: ,l_gme_batch_header.last_updated_by
414: ,l_gme_batch_header.creation_date
415: ,l_gme_batch_header.created_by
408: ,l_gme_batch_header.poc_ind
409: ,l_gme_batch_header.actual_cost_ind
410: ,l_gme_batch_header.gl_posted_ind
411: ,l_gme_batch_header.update_inventory_ind
412: ,l_gme_batch_header.last_update_date
413: ,l_gme_batch_header.last_updated_by
414: ,l_gme_batch_header.creation_date
415: ,l_gme_batch_header.created_by
416: ,l_gme_batch_header.last_update_login
409: ,l_gme_batch_header.actual_cost_ind
410: ,l_gme_batch_header.gl_posted_ind
411: ,l_gme_batch_header.update_inventory_ind
412: ,l_gme_batch_header.last_update_date
413: ,l_gme_batch_header.last_updated_by
414: ,l_gme_batch_header.creation_date
415: ,l_gme_batch_header.created_by
416: ,l_gme_batch_header.last_update_login
417: ,l_gme_batch_header.delete_mark
410: ,l_gme_batch_header.gl_posted_ind
411: ,l_gme_batch_header.update_inventory_ind
412: ,l_gme_batch_header.last_update_date
413: ,l_gme_batch_header.last_updated_by
414: ,l_gme_batch_header.creation_date
415: ,l_gme_batch_header.created_by
416: ,l_gme_batch_header.last_update_login
417: ,l_gme_batch_header.delete_mark
418: ,l_gme_batch_header.text_code
411: ,l_gme_batch_header.update_inventory_ind
412: ,l_gme_batch_header.last_update_date
413: ,l_gme_batch_header.last_updated_by
414: ,l_gme_batch_header.creation_date
415: ,l_gme_batch_header.created_by
416: ,l_gme_batch_header.last_update_login
417: ,l_gme_batch_header.delete_mark
418: ,l_gme_batch_header.text_code
419: ,l_gme_batch_header.parentline_id, l_gme_batch_header.fpo_id
412: ,l_gme_batch_header.last_update_date
413: ,l_gme_batch_header.last_updated_by
414: ,l_gme_batch_header.creation_date
415: ,l_gme_batch_header.created_by
416: ,l_gme_batch_header.last_update_login
417: ,l_gme_batch_header.delete_mark
418: ,l_gme_batch_header.text_code
419: ,l_gme_batch_header.parentline_id, l_gme_batch_header.fpo_id
420: ,l_gme_batch_header.attribute1
413: ,l_gme_batch_header.last_updated_by
414: ,l_gme_batch_header.creation_date
415: ,l_gme_batch_header.created_by
416: ,l_gme_batch_header.last_update_login
417: ,l_gme_batch_header.delete_mark
418: ,l_gme_batch_header.text_code
419: ,l_gme_batch_header.parentline_id, l_gme_batch_header.fpo_id
420: ,l_gme_batch_header.attribute1
421: ,l_gme_batch_header.attribute2
414: ,l_gme_batch_header.creation_date
415: ,l_gme_batch_header.created_by
416: ,l_gme_batch_header.last_update_login
417: ,l_gme_batch_header.delete_mark
418: ,l_gme_batch_header.text_code
419: ,l_gme_batch_header.parentline_id, l_gme_batch_header.fpo_id
420: ,l_gme_batch_header.attribute1
421: ,l_gme_batch_header.attribute2
422: ,l_gme_batch_header.attribute3
415: ,l_gme_batch_header.created_by
416: ,l_gme_batch_header.last_update_login
417: ,l_gme_batch_header.delete_mark
418: ,l_gme_batch_header.text_code
419: ,l_gme_batch_header.parentline_id, l_gme_batch_header.fpo_id
420: ,l_gme_batch_header.attribute1
421: ,l_gme_batch_header.attribute2
422: ,l_gme_batch_header.attribute3
423: ,l_gme_batch_header.attribute4
416: ,l_gme_batch_header.last_update_login
417: ,l_gme_batch_header.delete_mark
418: ,l_gme_batch_header.text_code
419: ,l_gme_batch_header.parentline_id, l_gme_batch_header.fpo_id
420: ,l_gme_batch_header.attribute1
421: ,l_gme_batch_header.attribute2
422: ,l_gme_batch_header.attribute3
423: ,l_gme_batch_header.attribute4
424: ,l_gme_batch_header.attribute5
417: ,l_gme_batch_header.delete_mark
418: ,l_gme_batch_header.text_code
419: ,l_gme_batch_header.parentline_id, l_gme_batch_header.fpo_id
420: ,l_gme_batch_header.attribute1
421: ,l_gme_batch_header.attribute2
422: ,l_gme_batch_header.attribute3
423: ,l_gme_batch_header.attribute4
424: ,l_gme_batch_header.attribute5
425: ,l_gme_batch_header.attribute6
418: ,l_gme_batch_header.text_code
419: ,l_gme_batch_header.parentline_id, l_gme_batch_header.fpo_id
420: ,l_gme_batch_header.attribute1
421: ,l_gme_batch_header.attribute2
422: ,l_gme_batch_header.attribute3
423: ,l_gme_batch_header.attribute4
424: ,l_gme_batch_header.attribute5
425: ,l_gme_batch_header.attribute6
426: ,l_gme_batch_header.attribute7
419: ,l_gme_batch_header.parentline_id, l_gme_batch_header.fpo_id
420: ,l_gme_batch_header.attribute1
421: ,l_gme_batch_header.attribute2
422: ,l_gme_batch_header.attribute3
423: ,l_gme_batch_header.attribute4
424: ,l_gme_batch_header.attribute5
425: ,l_gme_batch_header.attribute6
426: ,l_gme_batch_header.attribute7
427: ,l_gme_batch_header.attribute8
420: ,l_gme_batch_header.attribute1
421: ,l_gme_batch_header.attribute2
422: ,l_gme_batch_header.attribute3
423: ,l_gme_batch_header.attribute4
424: ,l_gme_batch_header.attribute5
425: ,l_gme_batch_header.attribute6
426: ,l_gme_batch_header.attribute7
427: ,l_gme_batch_header.attribute8
428: ,l_gme_batch_header.attribute9
421: ,l_gme_batch_header.attribute2
422: ,l_gme_batch_header.attribute3
423: ,l_gme_batch_header.attribute4
424: ,l_gme_batch_header.attribute5
425: ,l_gme_batch_header.attribute6
426: ,l_gme_batch_header.attribute7
427: ,l_gme_batch_header.attribute8
428: ,l_gme_batch_header.attribute9
429: ,l_gme_batch_header.attribute10
422: ,l_gme_batch_header.attribute3
423: ,l_gme_batch_header.attribute4
424: ,l_gme_batch_header.attribute5
425: ,l_gme_batch_header.attribute6
426: ,l_gme_batch_header.attribute7
427: ,l_gme_batch_header.attribute8
428: ,l_gme_batch_header.attribute9
429: ,l_gme_batch_header.attribute10
430: ,l_gme_batch_header.attribute11
423: ,l_gme_batch_header.attribute4
424: ,l_gme_batch_header.attribute5
425: ,l_gme_batch_header.attribute6
426: ,l_gme_batch_header.attribute7
427: ,l_gme_batch_header.attribute8
428: ,l_gme_batch_header.attribute9
429: ,l_gme_batch_header.attribute10
430: ,l_gme_batch_header.attribute11
431: ,l_gme_batch_header.attribute12
424: ,l_gme_batch_header.attribute5
425: ,l_gme_batch_header.attribute6
426: ,l_gme_batch_header.attribute7
427: ,l_gme_batch_header.attribute8
428: ,l_gme_batch_header.attribute9
429: ,l_gme_batch_header.attribute10
430: ,l_gme_batch_header.attribute11
431: ,l_gme_batch_header.attribute12
432: ,l_gme_batch_header.attribute13
425: ,l_gme_batch_header.attribute6
426: ,l_gme_batch_header.attribute7
427: ,l_gme_batch_header.attribute8
428: ,l_gme_batch_header.attribute9
429: ,l_gme_batch_header.attribute10
430: ,l_gme_batch_header.attribute11
431: ,l_gme_batch_header.attribute12
432: ,l_gme_batch_header.attribute13
433: ,l_gme_batch_header.attribute14
426: ,l_gme_batch_header.attribute7
427: ,l_gme_batch_header.attribute8
428: ,l_gme_batch_header.attribute9
429: ,l_gme_batch_header.attribute10
430: ,l_gme_batch_header.attribute11
431: ,l_gme_batch_header.attribute12
432: ,l_gme_batch_header.attribute13
433: ,l_gme_batch_header.attribute14
434: ,l_gme_batch_header.attribute15
427: ,l_gme_batch_header.attribute8
428: ,l_gme_batch_header.attribute9
429: ,l_gme_batch_header.attribute10
430: ,l_gme_batch_header.attribute11
431: ,l_gme_batch_header.attribute12
432: ,l_gme_batch_header.attribute13
433: ,l_gme_batch_header.attribute14
434: ,l_gme_batch_header.attribute15
435: ,l_gme_batch_header.attribute16
428: ,l_gme_batch_header.attribute9
429: ,l_gme_batch_header.attribute10
430: ,l_gme_batch_header.attribute11
431: ,l_gme_batch_header.attribute12
432: ,l_gme_batch_header.attribute13
433: ,l_gme_batch_header.attribute14
434: ,l_gme_batch_header.attribute15
435: ,l_gme_batch_header.attribute16
436: ,l_gme_batch_header.attribute17
429: ,l_gme_batch_header.attribute10
430: ,l_gme_batch_header.attribute11
431: ,l_gme_batch_header.attribute12
432: ,l_gme_batch_header.attribute13
433: ,l_gme_batch_header.attribute14
434: ,l_gme_batch_header.attribute15
435: ,l_gme_batch_header.attribute16
436: ,l_gme_batch_header.attribute17
437: ,l_gme_batch_header.attribute18
430: ,l_gme_batch_header.attribute11
431: ,l_gme_batch_header.attribute12
432: ,l_gme_batch_header.attribute13
433: ,l_gme_batch_header.attribute14
434: ,l_gme_batch_header.attribute15
435: ,l_gme_batch_header.attribute16
436: ,l_gme_batch_header.attribute17
437: ,l_gme_batch_header.attribute18
438: ,l_gme_batch_header.attribute19
431: ,l_gme_batch_header.attribute12
432: ,l_gme_batch_header.attribute13
433: ,l_gme_batch_header.attribute14
434: ,l_gme_batch_header.attribute15
435: ,l_gme_batch_header.attribute16
436: ,l_gme_batch_header.attribute17
437: ,l_gme_batch_header.attribute18
438: ,l_gme_batch_header.attribute19
439: ,l_gme_batch_header.attribute20
432: ,l_gme_batch_header.attribute13
433: ,l_gme_batch_header.attribute14
434: ,l_gme_batch_header.attribute15
435: ,l_gme_batch_header.attribute16
436: ,l_gme_batch_header.attribute17
437: ,l_gme_batch_header.attribute18
438: ,l_gme_batch_header.attribute19
439: ,l_gme_batch_header.attribute20
440: ,l_gme_batch_header.attribute21
433: ,l_gme_batch_header.attribute14
434: ,l_gme_batch_header.attribute15
435: ,l_gme_batch_header.attribute16
436: ,l_gme_batch_header.attribute17
437: ,l_gme_batch_header.attribute18
438: ,l_gme_batch_header.attribute19
439: ,l_gme_batch_header.attribute20
440: ,l_gme_batch_header.attribute21
441: ,l_gme_batch_header.attribute22
434: ,l_gme_batch_header.attribute15
435: ,l_gme_batch_header.attribute16
436: ,l_gme_batch_header.attribute17
437: ,l_gme_batch_header.attribute18
438: ,l_gme_batch_header.attribute19
439: ,l_gme_batch_header.attribute20
440: ,l_gme_batch_header.attribute21
441: ,l_gme_batch_header.attribute22
442: ,l_gme_batch_header.attribute23
435: ,l_gme_batch_header.attribute16
436: ,l_gme_batch_header.attribute17
437: ,l_gme_batch_header.attribute18
438: ,l_gme_batch_header.attribute19
439: ,l_gme_batch_header.attribute20
440: ,l_gme_batch_header.attribute21
441: ,l_gme_batch_header.attribute22
442: ,l_gme_batch_header.attribute23
443: ,l_gme_batch_header.attribute24
436: ,l_gme_batch_header.attribute17
437: ,l_gme_batch_header.attribute18
438: ,l_gme_batch_header.attribute19
439: ,l_gme_batch_header.attribute20
440: ,l_gme_batch_header.attribute21
441: ,l_gme_batch_header.attribute22
442: ,l_gme_batch_header.attribute23
443: ,l_gme_batch_header.attribute24
444: ,l_gme_batch_header.attribute25
437: ,l_gme_batch_header.attribute18
438: ,l_gme_batch_header.attribute19
439: ,l_gme_batch_header.attribute20
440: ,l_gme_batch_header.attribute21
441: ,l_gme_batch_header.attribute22
442: ,l_gme_batch_header.attribute23
443: ,l_gme_batch_header.attribute24
444: ,l_gme_batch_header.attribute25
445: ,l_gme_batch_header.attribute26
438: ,l_gme_batch_header.attribute19
439: ,l_gme_batch_header.attribute20
440: ,l_gme_batch_header.attribute21
441: ,l_gme_batch_header.attribute22
442: ,l_gme_batch_header.attribute23
443: ,l_gme_batch_header.attribute24
444: ,l_gme_batch_header.attribute25
445: ,l_gme_batch_header.attribute26
446: ,l_gme_batch_header.attribute27
439: ,l_gme_batch_header.attribute20
440: ,l_gme_batch_header.attribute21
441: ,l_gme_batch_header.attribute22
442: ,l_gme_batch_header.attribute23
443: ,l_gme_batch_header.attribute24
444: ,l_gme_batch_header.attribute25
445: ,l_gme_batch_header.attribute26
446: ,l_gme_batch_header.attribute27
447: ,l_gme_batch_header.attribute28
440: ,l_gme_batch_header.attribute21
441: ,l_gme_batch_header.attribute22
442: ,l_gme_batch_header.attribute23
443: ,l_gme_batch_header.attribute24
444: ,l_gme_batch_header.attribute25
445: ,l_gme_batch_header.attribute26
446: ,l_gme_batch_header.attribute27
447: ,l_gme_batch_header.attribute28
448: ,l_gme_batch_header.attribute29
441: ,l_gme_batch_header.attribute22
442: ,l_gme_batch_header.attribute23
443: ,l_gme_batch_header.attribute24
444: ,l_gme_batch_header.attribute25
445: ,l_gme_batch_header.attribute26
446: ,l_gme_batch_header.attribute27
447: ,l_gme_batch_header.attribute28
448: ,l_gme_batch_header.attribute29
449: ,l_gme_batch_header.attribute30
442: ,l_gme_batch_header.attribute23
443: ,l_gme_batch_header.attribute24
444: ,l_gme_batch_header.attribute25
445: ,l_gme_batch_header.attribute26
446: ,l_gme_batch_header.attribute27
447: ,l_gme_batch_header.attribute28
448: ,l_gme_batch_header.attribute29
449: ,l_gme_batch_header.attribute30
450: ,l_gme_batch_header.attribute31
443: ,l_gme_batch_header.attribute24
444: ,l_gme_batch_header.attribute25
445: ,l_gme_batch_header.attribute26
446: ,l_gme_batch_header.attribute27
447: ,l_gme_batch_header.attribute28
448: ,l_gme_batch_header.attribute29
449: ,l_gme_batch_header.attribute30
450: ,l_gme_batch_header.attribute31
451: ,l_gme_batch_header.attribute32
444: ,l_gme_batch_header.attribute25
445: ,l_gme_batch_header.attribute26
446: ,l_gme_batch_header.attribute27
447: ,l_gme_batch_header.attribute28
448: ,l_gme_batch_header.attribute29
449: ,l_gme_batch_header.attribute30
450: ,l_gme_batch_header.attribute31
451: ,l_gme_batch_header.attribute32
452: ,l_gme_batch_header.attribute33
445: ,l_gme_batch_header.attribute26
446: ,l_gme_batch_header.attribute27
447: ,l_gme_batch_header.attribute28
448: ,l_gme_batch_header.attribute29
449: ,l_gme_batch_header.attribute30
450: ,l_gme_batch_header.attribute31
451: ,l_gme_batch_header.attribute32
452: ,l_gme_batch_header.attribute33
453: ,l_gme_batch_header.attribute34
446: ,l_gme_batch_header.attribute27
447: ,l_gme_batch_header.attribute28
448: ,l_gme_batch_header.attribute29
449: ,l_gme_batch_header.attribute30
450: ,l_gme_batch_header.attribute31
451: ,l_gme_batch_header.attribute32
452: ,l_gme_batch_header.attribute33
453: ,l_gme_batch_header.attribute34
454: ,l_gme_batch_header.attribute35
447: ,l_gme_batch_header.attribute28
448: ,l_gme_batch_header.attribute29
449: ,l_gme_batch_header.attribute30
450: ,l_gme_batch_header.attribute31
451: ,l_gme_batch_header.attribute32
452: ,l_gme_batch_header.attribute33
453: ,l_gme_batch_header.attribute34
454: ,l_gme_batch_header.attribute35
455: ,l_gme_batch_header.attribute36
448: ,l_gme_batch_header.attribute29
449: ,l_gme_batch_header.attribute30
450: ,l_gme_batch_header.attribute31
451: ,l_gme_batch_header.attribute32
452: ,l_gme_batch_header.attribute33
453: ,l_gme_batch_header.attribute34
454: ,l_gme_batch_header.attribute35
455: ,l_gme_batch_header.attribute36
456: ,l_gme_batch_header.attribute37
449: ,l_gme_batch_header.attribute30
450: ,l_gme_batch_header.attribute31
451: ,l_gme_batch_header.attribute32
452: ,l_gme_batch_header.attribute33
453: ,l_gme_batch_header.attribute34
454: ,l_gme_batch_header.attribute35
455: ,l_gme_batch_header.attribute36
456: ,l_gme_batch_header.attribute37
457: ,l_gme_batch_header.attribute38
450: ,l_gme_batch_header.attribute31
451: ,l_gme_batch_header.attribute32
452: ,l_gme_batch_header.attribute33
453: ,l_gme_batch_header.attribute34
454: ,l_gme_batch_header.attribute35
455: ,l_gme_batch_header.attribute36
456: ,l_gme_batch_header.attribute37
457: ,l_gme_batch_header.attribute38
458: ,l_gme_batch_header.attribute39
451: ,l_gme_batch_header.attribute32
452: ,l_gme_batch_header.attribute33
453: ,l_gme_batch_header.attribute34
454: ,l_gme_batch_header.attribute35
455: ,l_gme_batch_header.attribute36
456: ,l_gme_batch_header.attribute37
457: ,l_gme_batch_header.attribute38
458: ,l_gme_batch_header.attribute39
459: ,l_gme_batch_header.attribute40
452: ,l_gme_batch_header.attribute33
453: ,l_gme_batch_header.attribute34
454: ,l_gme_batch_header.attribute35
455: ,l_gme_batch_header.attribute36
456: ,l_gme_batch_header.attribute37
457: ,l_gme_batch_header.attribute38
458: ,l_gme_batch_header.attribute39
459: ,l_gme_batch_header.attribute40
460: ,l_gme_batch_header.attribute_category
453: ,l_gme_batch_header.attribute34
454: ,l_gme_batch_header.attribute35
455: ,l_gme_batch_header.attribute36
456: ,l_gme_batch_header.attribute37
457: ,l_gme_batch_header.attribute38
458: ,l_gme_batch_header.attribute39
459: ,l_gme_batch_header.attribute40
460: ,l_gme_batch_header.attribute_category
461: ,l_gme_batch_header.automatic_step_calculation
454: ,l_gme_batch_header.attribute35
455: ,l_gme_batch_header.attribute36
456: ,l_gme_batch_header.attribute37
457: ,l_gme_batch_header.attribute38
458: ,l_gme_batch_header.attribute39
459: ,l_gme_batch_header.attribute40
460: ,l_gme_batch_header.attribute_category
461: ,l_gme_batch_header.automatic_step_calculation
462: ,l_gme_batch_header.firmed_ind
455: ,l_gme_batch_header.attribute36
456: ,l_gme_batch_header.attribute37
457: ,l_gme_batch_header.attribute38
458: ,l_gme_batch_header.attribute39
459: ,l_gme_batch_header.attribute40
460: ,l_gme_batch_header.attribute_category
461: ,l_gme_batch_header.automatic_step_calculation
462: ,l_gme_batch_header.firmed_ind
463: ,l_gme_batch_header.finite_scheduled_ind
456: ,l_gme_batch_header.attribute37
457: ,l_gme_batch_header.attribute38
458: ,l_gme_batch_header.attribute39
459: ,l_gme_batch_header.attribute40
460: ,l_gme_batch_header.attribute_category
461: ,l_gme_batch_header.automatic_step_calculation
462: ,l_gme_batch_header.firmed_ind
463: ,l_gme_batch_header.finite_scheduled_ind
464: ,l_gme_batch_header.order_priority
457: ,l_gme_batch_header.attribute38
458: ,l_gme_batch_header.attribute39
459: ,l_gme_batch_header.attribute40
460: ,l_gme_batch_header.attribute_category
461: ,l_gme_batch_header.automatic_step_calculation
462: ,l_gme_batch_header.firmed_ind
463: ,l_gme_batch_header.finite_scheduled_ind
464: ,l_gme_batch_header.order_priority
465: ,l_gme_batch_header.migrated_batch_ind
458: ,l_gme_batch_header.attribute39
459: ,l_gme_batch_header.attribute40
460: ,l_gme_batch_header.attribute_category
461: ,l_gme_batch_header.automatic_step_calculation
462: ,l_gme_batch_header.firmed_ind
463: ,l_gme_batch_header.finite_scheduled_ind
464: ,l_gme_batch_header.order_priority
465: ,l_gme_batch_header.migrated_batch_ind
466: ,l_gme_batch_header.enforce_step_dependency
459: ,l_gme_batch_header.attribute40
460: ,l_gme_batch_header.attribute_category
461: ,l_gme_batch_header.automatic_step_calculation
462: ,l_gme_batch_header.firmed_ind
463: ,l_gme_batch_header.finite_scheduled_ind
464: ,l_gme_batch_header.order_priority
465: ,l_gme_batch_header.migrated_batch_ind
466: ,l_gme_batch_header.enforce_step_dependency
467: ,l_gme_batch_header.terminated_ind
460: ,l_gme_batch_header.attribute_category
461: ,l_gme_batch_header.automatic_step_calculation
462: ,l_gme_batch_header.firmed_ind
463: ,l_gme_batch_header.finite_scheduled_ind
464: ,l_gme_batch_header.order_priority
465: ,l_gme_batch_header.migrated_batch_ind
466: ,l_gme_batch_header.enforce_step_dependency
467: ,l_gme_batch_header.terminated_ind
468: ,l_gme_batch_header.organization_id
461: ,l_gme_batch_header.automatic_step_calculation
462: ,l_gme_batch_header.firmed_ind
463: ,l_gme_batch_header.finite_scheduled_ind
464: ,l_gme_batch_header.order_priority
465: ,l_gme_batch_header.migrated_batch_ind
466: ,l_gme_batch_header.enforce_step_dependency
467: ,l_gme_batch_header.terminated_ind
468: ,l_gme_batch_header.organization_id
469: ,l_gme_batch_header.laboratory_ind
462: ,l_gme_batch_header.firmed_ind
463: ,l_gme_batch_header.finite_scheduled_ind
464: ,l_gme_batch_header.order_priority
465: ,l_gme_batch_header.migrated_batch_ind
466: ,l_gme_batch_header.enforce_step_dependency
467: ,l_gme_batch_header.terminated_ind
468: ,l_gme_batch_header.organization_id
469: ,l_gme_batch_header.laboratory_ind
470: ,l_gme_batch_header.enhanced_pi_ind
463: ,l_gme_batch_header.finite_scheduled_ind
464: ,l_gme_batch_header.order_priority
465: ,l_gme_batch_header.migrated_batch_ind
466: ,l_gme_batch_header.enforce_step_dependency
467: ,l_gme_batch_header.terminated_ind
468: ,l_gme_batch_header.organization_id
469: ,l_gme_batch_header.laboratory_ind
470: ,l_gme_batch_header.enhanced_pi_ind
471: ,l_gme_batch_header.move_order_header_id
464: ,l_gme_batch_header.order_priority
465: ,l_gme_batch_header.migrated_batch_ind
466: ,l_gme_batch_header.enforce_step_dependency
467: ,l_gme_batch_header.terminated_ind
468: ,l_gme_batch_header.organization_id
469: ,l_gme_batch_header.laboratory_ind
470: ,l_gme_batch_header.enhanced_pi_ind
471: ,l_gme_batch_header.move_order_header_id
472: ,l_gme_batch_header.terminate_reason_id
465: ,l_gme_batch_header.migrated_batch_ind
466: ,l_gme_batch_header.enforce_step_dependency
467: ,l_gme_batch_header.terminated_ind
468: ,l_gme_batch_header.organization_id
469: ,l_gme_batch_header.laboratory_ind
470: ,l_gme_batch_header.enhanced_pi_ind
471: ,l_gme_batch_header.move_order_header_id
472: ,l_gme_batch_header.terminate_reason_id
473: ,l_gme_batch_header.fixed_process_loss_applied
466: ,l_gme_batch_header.enforce_step_dependency
467: ,l_gme_batch_header.terminated_ind
468: ,l_gme_batch_header.organization_id
469: ,l_gme_batch_header.laboratory_ind
470: ,l_gme_batch_header.enhanced_pi_ind
471: ,l_gme_batch_header.move_order_header_id
472: ,l_gme_batch_header.terminate_reason_id
473: ,l_gme_batch_header.fixed_process_loss_applied
474: FROM gme_batch_header
467: ,l_gme_batch_header.terminated_ind
468: ,l_gme_batch_header.organization_id
469: ,l_gme_batch_header.laboratory_ind
470: ,l_gme_batch_header.enhanced_pi_ind
471: ,l_gme_batch_header.move_order_header_id
472: ,l_gme_batch_header.terminate_reason_id
473: ,l_gme_batch_header.fixed_process_loss_applied
474: FROM gme_batch_header
475: WHERE batch_id = p_batch_header.batch_id;
468: ,l_gme_batch_header.organization_id
469: ,l_gme_batch_header.laboratory_ind
470: ,l_gme_batch_header.enhanced_pi_ind
471: ,l_gme_batch_header.move_order_header_id
472: ,l_gme_batch_header.terminate_reason_id
473: ,l_gme_batch_header.fixed_process_loss_applied
474: FROM gme_batch_header
475: WHERE batch_id = p_batch_header.batch_id;
476: ELSIF (l_organization_id IS NOT NULL)
469: ,l_gme_batch_header.laboratory_ind
470: ,l_gme_batch_header.enhanced_pi_ind
471: ,l_gme_batch_header.move_order_header_id
472: ,l_gme_batch_header.terminate_reason_id
473: ,l_gme_batch_header.fixed_process_loss_applied
474: FROM gme_batch_header
475: WHERE batch_id = p_batch_header.batch_id;
476: ELSIF (l_organization_id IS NOT NULL)
477: AND (l_batch_no IS NOT NULL)
470: ,l_gme_batch_header.enhanced_pi_ind
471: ,l_gme_batch_header.move_order_header_id
472: ,l_gme_batch_header.terminate_reason_id
473: ,l_gme_batch_header.fixed_process_loss_applied
474: FROM gme_batch_header
475: WHERE batch_id = p_batch_header.batch_id;
476: ELSIF (l_organization_id IS NOT NULL)
477: AND (l_batch_no IS NOT NULL)
478: AND (l_batch_type IS NOT NULL) THEN
561: ,enhanced_pi_ind
562: ,move_order_header_id
563: ,terminate_reason_id
564: ,fixed_process_loss_applied
565: INTO l_gme_batch_header.batch_id
566: --, l_gme_batch_header.PLANT_CODE
567: , l_gme_batch_header.batch_no
568: ,l_gme_batch_header.batch_type, l_gme_batch_header.prod_id
569: ,l_gme_batch_header.prod_sequence
562: ,move_order_header_id
563: ,terminate_reason_id
564: ,fixed_process_loss_applied
565: INTO l_gme_batch_header.batch_id
566: --, l_gme_batch_header.PLANT_CODE
567: , l_gme_batch_header.batch_no
568: ,l_gme_batch_header.batch_type, l_gme_batch_header.prod_id
569: ,l_gme_batch_header.prod_sequence
570: ,l_gme_batch_header.recipe_validity_rule_id
563: ,terminate_reason_id
564: ,fixed_process_loss_applied
565: INTO l_gme_batch_header.batch_id
566: --, l_gme_batch_header.PLANT_CODE
567: , l_gme_batch_header.batch_no
568: ,l_gme_batch_header.batch_type, l_gme_batch_header.prod_id
569: ,l_gme_batch_header.prod_sequence
570: ,l_gme_batch_header.recipe_validity_rule_id
571: ,l_gme_batch_header.formula_id
564: ,fixed_process_loss_applied
565: INTO l_gme_batch_header.batch_id
566: --, l_gme_batch_header.PLANT_CODE
567: , l_gme_batch_header.batch_no
568: ,l_gme_batch_header.batch_type, l_gme_batch_header.prod_id
569: ,l_gme_batch_header.prod_sequence
570: ,l_gme_batch_header.recipe_validity_rule_id
571: ,l_gme_batch_header.formula_id
572: ,l_gme_batch_header.routing_id
565: INTO l_gme_batch_header.batch_id
566: --, l_gme_batch_header.PLANT_CODE
567: , l_gme_batch_header.batch_no
568: ,l_gme_batch_header.batch_type, l_gme_batch_header.prod_id
569: ,l_gme_batch_header.prod_sequence
570: ,l_gme_batch_header.recipe_validity_rule_id
571: ,l_gme_batch_header.formula_id
572: ,l_gme_batch_header.routing_id
573: ,l_gme_batch_header.plan_start_date
566: --, l_gme_batch_header.PLANT_CODE
567: , l_gme_batch_header.batch_no
568: ,l_gme_batch_header.batch_type, l_gme_batch_header.prod_id
569: ,l_gme_batch_header.prod_sequence
570: ,l_gme_batch_header.recipe_validity_rule_id
571: ,l_gme_batch_header.formula_id
572: ,l_gme_batch_header.routing_id
573: ,l_gme_batch_header.plan_start_date
574: ,l_gme_batch_header.actual_start_date
567: , l_gme_batch_header.batch_no
568: ,l_gme_batch_header.batch_type, l_gme_batch_header.prod_id
569: ,l_gme_batch_header.prod_sequence
570: ,l_gme_batch_header.recipe_validity_rule_id
571: ,l_gme_batch_header.formula_id
572: ,l_gme_batch_header.routing_id
573: ,l_gme_batch_header.plan_start_date
574: ,l_gme_batch_header.actual_start_date
575: ,l_gme_batch_header.due_date
568: ,l_gme_batch_header.batch_type, l_gme_batch_header.prod_id
569: ,l_gme_batch_header.prod_sequence
570: ,l_gme_batch_header.recipe_validity_rule_id
571: ,l_gme_batch_header.formula_id
572: ,l_gme_batch_header.routing_id
573: ,l_gme_batch_header.plan_start_date
574: ,l_gme_batch_header.actual_start_date
575: ,l_gme_batch_header.due_date
576: ,l_gme_batch_header.plan_cmplt_date
569: ,l_gme_batch_header.prod_sequence
570: ,l_gme_batch_header.recipe_validity_rule_id
571: ,l_gme_batch_header.formula_id
572: ,l_gme_batch_header.routing_id
573: ,l_gme_batch_header.plan_start_date
574: ,l_gme_batch_header.actual_start_date
575: ,l_gme_batch_header.due_date
576: ,l_gme_batch_header.plan_cmplt_date
577: ,l_gme_batch_header.actual_cmplt_date
570: ,l_gme_batch_header.recipe_validity_rule_id
571: ,l_gme_batch_header.formula_id
572: ,l_gme_batch_header.routing_id
573: ,l_gme_batch_header.plan_start_date
574: ,l_gme_batch_header.actual_start_date
575: ,l_gme_batch_header.due_date
576: ,l_gme_batch_header.plan_cmplt_date
577: ,l_gme_batch_header.actual_cmplt_date
578: ,l_gme_batch_header.batch_status
571: ,l_gme_batch_header.formula_id
572: ,l_gme_batch_header.routing_id
573: ,l_gme_batch_header.plan_start_date
574: ,l_gme_batch_header.actual_start_date
575: ,l_gme_batch_header.due_date
576: ,l_gme_batch_header.plan_cmplt_date
577: ,l_gme_batch_header.actual_cmplt_date
578: ,l_gme_batch_header.batch_status
579: ,l_gme_batch_header.priority_value
572: ,l_gme_batch_header.routing_id
573: ,l_gme_batch_header.plan_start_date
574: ,l_gme_batch_header.actual_start_date
575: ,l_gme_batch_header.due_date
576: ,l_gme_batch_header.plan_cmplt_date
577: ,l_gme_batch_header.actual_cmplt_date
578: ,l_gme_batch_header.batch_status
579: ,l_gme_batch_header.priority_value
580: ,l_gme_batch_header.priority_code
573: ,l_gme_batch_header.plan_start_date
574: ,l_gme_batch_header.actual_start_date
575: ,l_gme_batch_header.due_date
576: ,l_gme_batch_header.plan_cmplt_date
577: ,l_gme_batch_header.actual_cmplt_date
578: ,l_gme_batch_header.batch_status
579: ,l_gme_batch_header.priority_value
580: ,l_gme_batch_header.priority_code
581: ,l_gme_batch_header.print_count
574: ,l_gme_batch_header.actual_start_date
575: ,l_gme_batch_header.due_date
576: ,l_gme_batch_header.plan_cmplt_date
577: ,l_gme_batch_header.actual_cmplt_date
578: ,l_gme_batch_header.batch_status
579: ,l_gme_batch_header.priority_value
580: ,l_gme_batch_header.priority_code
581: ,l_gme_batch_header.print_count
582: ,l_gme_batch_header.fmcontrol_class
575: ,l_gme_batch_header.due_date
576: ,l_gme_batch_header.plan_cmplt_date
577: ,l_gme_batch_header.actual_cmplt_date
578: ,l_gme_batch_header.batch_status
579: ,l_gme_batch_header.priority_value
580: ,l_gme_batch_header.priority_code
581: ,l_gme_batch_header.print_count
582: ,l_gme_batch_header.fmcontrol_class
583: --, l_gme_batch_header.WIP_WHSE_CODE
576: ,l_gme_batch_header.plan_cmplt_date
577: ,l_gme_batch_header.actual_cmplt_date
578: ,l_gme_batch_header.batch_status
579: ,l_gme_batch_header.priority_value
580: ,l_gme_batch_header.priority_code
581: ,l_gme_batch_header.print_count
582: ,l_gme_batch_header.fmcontrol_class
583: --, l_gme_batch_header.WIP_WHSE_CODE
584: , l_gme_batch_header.batch_close_date
577: ,l_gme_batch_header.actual_cmplt_date
578: ,l_gme_batch_header.batch_status
579: ,l_gme_batch_header.priority_value
580: ,l_gme_batch_header.priority_code
581: ,l_gme_batch_header.print_count
582: ,l_gme_batch_header.fmcontrol_class
583: --, l_gme_batch_header.WIP_WHSE_CODE
584: , l_gme_batch_header.batch_close_date
585: ,l_gme_batch_header.poc_ind
578: ,l_gme_batch_header.batch_status
579: ,l_gme_batch_header.priority_value
580: ,l_gme_batch_header.priority_code
581: ,l_gme_batch_header.print_count
582: ,l_gme_batch_header.fmcontrol_class
583: --, l_gme_batch_header.WIP_WHSE_CODE
584: , l_gme_batch_header.batch_close_date
585: ,l_gme_batch_header.poc_ind
586: ,l_gme_batch_header.actual_cost_ind
579: ,l_gme_batch_header.priority_value
580: ,l_gme_batch_header.priority_code
581: ,l_gme_batch_header.print_count
582: ,l_gme_batch_header.fmcontrol_class
583: --, l_gme_batch_header.WIP_WHSE_CODE
584: , l_gme_batch_header.batch_close_date
585: ,l_gme_batch_header.poc_ind
586: ,l_gme_batch_header.actual_cost_ind
587: ,l_gme_batch_header.gl_posted_ind
580: ,l_gme_batch_header.priority_code
581: ,l_gme_batch_header.print_count
582: ,l_gme_batch_header.fmcontrol_class
583: --, l_gme_batch_header.WIP_WHSE_CODE
584: , l_gme_batch_header.batch_close_date
585: ,l_gme_batch_header.poc_ind
586: ,l_gme_batch_header.actual_cost_ind
587: ,l_gme_batch_header.gl_posted_ind
588: ,l_gme_batch_header.update_inventory_ind
581: ,l_gme_batch_header.print_count
582: ,l_gme_batch_header.fmcontrol_class
583: --, l_gme_batch_header.WIP_WHSE_CODE
584: , l_gme_batch_header.batch_close_date
585: ,l_gme_batch_header.poc_ind
586: ,l_gme_batch_header.actual_cost_ind
587: ,l_gme_batch_header.gl_posted_ind
588: ,l_gme_batch_header.update_inventory_ind
589: ,l_gme_batch_header.last_update_date
582: ,l_gme_batch_header.fmcontrol_class
583: --, l_gme_batch_header.WIP_WHSE_CODE
584: , l_gme_batch_header.batch_close_date
585: ,l_gme_batch_header.poc_ind
586: ,l_gme_batch_header.actual_cost_ind
587: ,l_gme_batch_header.gl_posted_ind
588: ,l_gme_batch_header.update_inventory_ind
589: ,l_gme_batch_header.last_update_date
590: ,l_gme_batch_header.last_updated_by
583: --, l_gme_batch_header.WIP_WHSE_CODE
584: , l_gme_batch_header.batch_close_date
585: ,l_gme_batch_header.poc_ind
586: ,l_gme_batch_header.actual_cost_ind
587: ,l_gme_batch_header.gl_posted_ind
588: ,l_gme_batch_header.update_inventory_ind
589: ,l_gme_batch_header.last_update_date
590: ,l_gme_batch_header.last_updated_by
591: ,l_gme_batch_header.creation_date
584: , l_gme_batch_header.batch_close_date
585: ,l_gme_batch_header.poc_ind
586: ,l_gme_batch_header.actual_cost_ind
587: ,l_gme_batch_header.gl_posted_ind
588: ,l_gme_batch_header.update_inventory_ind
589: ,l_gme_batch_header.last_update_date
590: ,l_gme_batch_header.last_updated_by
591: ,l_gme_batch_header.creation_date
592: ,l_gme_batch_header.created_by
585: ,l_gme_batch_header.poc_ind
586: ,l_gme_batch_header.actual_cost_ind
587: ,l_gme_batch_header.gl_posted_ind
588: ,l_gme_batch_header.update_inventory_ind
589: ,l_gme_batch_header.last_update_date
590: ,l_gme_batch_header.last_updated_by
591: ,l_gme_batch_header.creation_date
592: ,l_gme_batch_header.created_by
593: ,l_gme_batch_header.last_update_login
586: ,l_gme_batch_header.actual_cost_ind
587: ,l_gme_batch_header.gl_posted_ind
588: ,l_gme_batch_header.update_inventory_ind
589: ,l_gme_batch_header.last_update_date
590: ,l_gme_batch_header.last_updated_by
591: ,l_gme_batch_header.creation_date
592: ,l_gme_batch_header.created_by
593: ,l_gme_batch_header.last_update_login
594: ,l_gme_batch_header.delete_mark
587: ,l_gme_batch_header.gl_posted_ind
588: ,l_gme_batch_header.update_inventory_ind
589: ,l_gme_batch_header.last_update_date
590: ,l_gme_batch_header.last_updated_by
591: ,l_gme_batch_header.creation_date
592: ,l_gme_batch_header.created_by
593: ,l_gme_batch_header.last_update_login
594: ,l_gme_batch_header.delete_mark
595: ,l_gme_batch_header.text_code
588: ,l_gme_batch_header.update_inventory_ind
589: ,l_gme_batch_header.last_update_date
590: ,l_gme_batch_header.last_updated_by
591: ,l_gme_batch_header.creation_date
592: ,l_gme_batch_header.created_by
593: ,l_gme_batch_header.last_update_login
594: ,l_gme_batch_header.delete_mark
595: ,l_gme_batch_header.text_code
596: ,l_gme_batch_header.parentline_id, l_gme_batch_header.fpo_id
589: ,l_gme_batch_header.last_update_date
590: ,l_gme_batch_header.last_updated_by
591: ,l_gme_batch_header.creation_date
592: ,l_gme_batch_header.created_by
593: ,l_gme_batch_header.last_update_login
594: ,l_gme_batch_header.delete_mark
595: ,l_gme_batch_header.text_code
596: ,l_gme_batch_header.parentline_id, l_gme_batch_header.fpo_id
597: ,l_gme_batch_header.attribute1
590: ,l_gme_batch_header.last_updated_by
591: ,l_gme_batch_header.creation_date
592: ,l_gme_batch_header.created_by
593: ,l_gme_batch_header.last_update_login
594: ,l_gme_batch_header.delete_mark
595: ,l_gme_batch_header.text_code
596: ,l_gme_batch_header.parentline_id, l_gme_batch_header.fpo_id
597: ,l_gme_batch_header.attribute1
598: ,l_gme_batch_header.attribute2
591: ,l_gme_batch_header.creation_date
592: ,l_gme_batch_header.created_by
593: ,l_gme_batch_header.last_update_login
594: ,l_gme_batch_header.delete_mark
595: ,l_gme_batch_header.text_code
596: ,l_gme_batch_header.parentline_id, l_gme_batch_header.fpo_id
597: ,l_gme_batch_header.attribute1
598: ,l_gme_batch_header.attribute2
599: ,l_gme_batch_header.attribute3
592: ,l_gme_batch_header.created_by
593: ,l_gme_batch_header.last_update_login
594: ,l_gme_batch_header.delete_mark
595: ,l_gme_batch_header.text_code
596: ,l_gme_batch_header.parentline_id, l_gme_batch_header.fpo_id
597: ,l_gme_batch_header.attribute1
598: ,l_gme_batch_header.attribute2
599: ,l_gme_batch_header.attribute3
600: ,l_gme_batch_header.attribute4
593: ,l_gme_batch_header.last_update_login
594: ,l_gme_batch_header.delete_mark
595: ,l_gme_batch_header.text_code
596: ,l_gme_batch_header.parentline_id, l_gme_batch_header.fpo_id
597: ,l_gme_batch_header.attribute1
598: ,l_gme_batch_header.attribute2
599: ,l_gme_batch_header.attribute3
600: ,l_gme_batch_header.attribute4
601: ,l_gme_batch_header.attribute5
594: ,l_gme_batch_header.delete_mark
595: ,l_gme_batch_header.text_code
596: ,l_gme_batch_header.parentline_id, l_gme_batch_header.fpo_id
597: ,l_gme_batch_header.attribute1
598: ,l_gme_batch_header.attribute2
599: ,l_gme_batch_header.attribute3
600: ,l_gme_batch_header.attribute4
601: ,l_gme_batch_header.attribute5
602: ,l_gme_batch_header.attribute6
595: ,l_gme_batch_header.text_code
596: ,l_gme_batch_header.parentline_id, l_gme_batch_header.fpo_id
597: ,l_gme_batch_header.attribute1
598: ,l_gme_batch_header.attribute2
599: ,l_gme_batch_header.attribute3
600: ,l_gme_batch_header.attribute4
601: ,l_gme_batch_header.attribute5
602: ,l_gme_batch_header.attribute6
603: ,l_gme_batch_header.attribute7
596: ,l_gme_batch_header.parentline_id, l_gme_batch_header.fpo_id
597: ,l_gme_batch_header.attribute1
598: ,l_gme_batch_header.attribute2
599: ,l_gme_batch_header.attribute3
600: ,l_gme_batch_header.attribute4
601: ,l_gme_batch_header.attribute5
602: ,l_gme_batch_header.attribute6
603: ,l_gme_batch_header.attribute7
604: ,l_gme_batch_header.attribute8
597: ,l_gme_batch_header.attribute1
598: ,l_gme_batch_header.attribute2
599: ,l_gme_batch_header.attribute3
600: ,l_gme_batch_header.attribute4
601: ,l_gme_batch_header.attribute5
602: ,l_gme_batch_header.attribute6
603: ,l_gme_batch_header.attribute7
604: ,l_gme_batch_header.attribute8
605: ,l_gme_batch_header.attribute9
598: ,l_gme_batch_header.attribute2
599: ,l_gme_batch_header.attribute3
600: ,l_gme_batch_header.attribute4
601: ,l_gme_batch_header.attribute5
602: ,l_gme_batch_header.attribute6
603: ,l_gme_batch_header.attribute7
604: ,l_gme_batch_header.attribute8
605: ,l_gme_batch_header.attribute9
606: ,l_gme_batch_header.attribute10
599: ,l_gme_batch_header.attribute3
600: ,l_gme_batch_header.attribute4
601: ,l_gme_batch_header.attribute5
602: ,l_gme_batch_header.attribute6
603: ,l_gme_batch_header.attribute7
604: ,l_gme_batch_header.attribute8
605: ,l_gme_batch_header.attribute9
606: ,l_gme_batch_header.attribute10
607: ,l_gme_batch_header.attribute11
600: ,l_gme_batch_header.attribute4
601: ,l_gme_batch_header.attribute5
602: ,l_gme_batch_header.attribute6
603: ,l_gme_batch_header.attribute7
604: ,l_gme_batch_header.attribute8
605: ,l_gme_batch_header.attribute9
606: ,l_gme_batch_header.attribute10
607: ,l_gme_batch_header.attribute11
608: ,l_gme_batch_header.attribute12
601: ,l_gme_batch_header.attribute5
602: ,l_gme_batch_header.attribute6
603: ,l_gme_batch_header.attribute7
604: ,l_gme_batch_header.attribute8
605: ,l_gme_batch_header.attribute9
606: ,l_gme_batch_header.attribute10
607: ,l_gme_batch_header.attribute11
608: ,l_gme_batch_header.attribute12
609: ,l_gme_batch_header.attribute13
602: ,l_gme_batch_header.attribute6
603: ,l_gme_batch_header.attribute7
604: ,l_gme_batch_header.attribute8
605: ,l_gme_batch_header.attribute9
606: ,l_gme_batch_header.attribute10
607: ,l_gme_batch_header.attribute11
608: ,l_gme_batch_header.attribute12
609: ,l_gme_batch_header.attribute13
610: ,l_gme_batch_header.attribute14
603: ,l_gme_batch_header.attribute7
604: ,l_gme_batch_header.attribute8
605: ,l_gme_batch_header.attribute9
606: ,l_gme_batch_header.attribute10
607: ,l_gme_batch_header.attribute11
608: ,l_gme_batch_header.attribute12
609: ,l_gme_batch_header.attribute13
610: ,l_gme_batch_header.attribute14
611: ,l_gme_batch_header.attribute15
604: ,l_gme_batch_header.attribute8
605: ,l_gme_batch_header.attribute9
606: ,l_gme_batch_header.attribute10
607: ,l_gme_batch_header.attribute11
608: ,l_gme_batch_header.attribute12
609: ,l_gme_batch_header.attribute13
610: ,l_gme_batch_header.attribute14
611: ,l_gme_batch_header.attribute15
612: ,l_gme_batch_header.attribute16
605: ,l_gme_batch_header.attribute9
606: ,l_gme_batch_header.attribute10
607: ,l_gme_batch_header.attribute11
608: ,l_gme_batch_header.attribute12
609: ,l_gme_batch_header.attribute13
610: ,l_gme_batch_header.attribute14
611: ,l_gme_batch_header.attribute15
612: ,l_gme_batch_header.attribute16
613: ,l_gme_batch_header.attribute17
606: ,l_gme_batch_header.attribute10
607: ,l_gme_batch_header.attribute11
608: ,l_gme_batch_header.attribute12
609: ,l_gme_batch_header.attribute13
610: ,l_gme_batch_header.attribute14
611: ,l_gme_batch_header.attribute15
612: ,l_gme_batch_header.attribute16
613: ,l_gme_batch_header.attribute17
614: ,l_gme_batch_header.attribute18
607: ,l_gme_batch_header.attribute11
608: ,l_gme_batch_header.attribute12
609: ,l_gme_batch_header.attribute13
610: ,l_gme_batch_header.attribute14
611: ,l_gme_batch_header.attribute15
612: ,l_gme_batch_header.attribute16
613: ,l_gme_batch_header.attribute17
614: ,l_gme_batch_header.attribute18
615: ,l_gme_batch_header.attribute19
608: ,l_gme_batch_header.attribute12
609: ,l_gme_batch_header.attribute13
610: ,l_gme_batch_header.attribute14
611: ,l_gme_batch_header.attribute15
612: ,l_gme_batch_header.attribute16
613: ,l_gme_batch_header.attribute17
614: ,l_gme_batch_header.attribute18
615: ,l_gme_batch_header.attribute19
616: ,l_gme_batch_header.attribute20
609: ,l_gme_batch_header.attribute13
610: ,l_gme_batch_header.attribute14
611: ,l_gme_batch_header.attribute15
612: ,l_gme_batch_header.attribute16
613: ,l_gme_batch_header.attribute17
614: ,l_gme_batch_header.attribute18
615: ,l_gme_batch_header.attribute19
616: ,l_gme_batch_header.attribute20
617: ,l_gme_batch_header.attribute21
610: ,l_gme_batch_header.attribute14
611: ,l_gme_batch_header.attribute15
612: ,l_gme_batch_header.attribute16
613: ,l_gme_batch_header.attribute17
614: ,l_gme_batch_header.attribute18
615: ,l_gme_batch_header.attribute19
616: ,l_gme_batch_header.attribute20
617: ,l_gme_batch_header.attribute21
618: ,l_gme_batch_header.attribute22
611: ,l_gme_batch_header.attribute15
612: ,l_gme_batch_header.attribute16
613: ,l_gme_batch_header.attribute17
614: ,l_gme_batch_header.attribute18
615: ,l_gme_batch_header.attribute19
616: ,l_gme_batch_header.attribute20
617: ,l_gme_batch_header.attribute21
618: ,l_gme_batch_header.attribute22
619: ,l_gme_batch_header.attribute23
612: ,l_gme_batch_header.attribute16
613: ,l_gme_batch_header.attribute17
614: ,l_gme_batch_header.attribute18
615: ,l_gme_batch_header.attribute19
616: ,l_gme_batch_header.attribute20
617: ,l_gme_batch_header.attribute21
618: ,l_gme_batch_header.attribute22
619: ,l_gme_batch_header.attribute23
620: ,l_gme_batch_header.attribute24
613: ,l_gme_batch_header.attribute17
614: ,l_gme_batch_header.attribute18
615: ,l_gme_batch_header.attribute19
616: ,l_gme_batch_header.attribute20
617: ,l_gme_batch_header.attribute21
618: ,l_gme_batch_header.attribute22
619: ,l_gme_batch_header.attribute23
620: ,l_gme_batch_header.attribute24
621: ,l_gme_batch_header.attribute25
614: ,l_gme_batch_header.attribute18
615: ,l_gme_batch_header.attribute19
616: ,l_gme_batch_header.attribute20
617: ,l_gme_batch_header.attribute21
618: ,l_gme_batch_header.attribute22
619: ,l_gme_batch_header.attribute23
620: ,l_gme_batch_header.attribute24
621: ,l_gme_batch_header.attribute25
622: ,l_gme_batch_header.attribute26
615: ,l_gme_batch_header.attribute19
616: ,l_gme_batch_header.attribute20
617: ,l_gme_batch_header.attribute21
618: ,l_gme_batch_header.attribute22
619: ,l_gme_batch_header.attribute23
620: ,l_gme_batch_header.attribute24
621: ,l_gme_batch_header.attribute25
622: ,l_gme_batch_header.attribute26
623: ,l_gme_batch_header.attribute27
616: ,l_gme_batch_header.attribute20
617: ,l_gme_batch_header.attribute21
618: ,l_gme_batch_header.attribute22
619: ,l_gme_batch_header.attribute23
620: ,l_gme_batch_header.attribute24
621: ,l_gme_batch_header.attribute25
622: ,l_gme_batch_header.attribute26
623: ,l_gme_batch_header.attribute27
624: ,l_gme_batch_header.attribute28
617: ,l_gme_batch_header.attribute21
618: ,l_gme_batch_header.attribute22
619: ,l_gme_batch_header.attribute23
620: ,l_gme_batch_header.attribute24
621: ,l_gme_batch_header.attribute25
622: ,l_gme_batch_header.attribute26
623: ,l_gme_batch_header.attribute27
624: ,l_gme_batch_header.attribute28
625: ,l_gme_batch_header.attribute29
618: ,l_gme_batch_header.attribute22
619: ,l_gme_batch_header.attribute23
620: ,l_gme_batch_header.attribute24
621: ,l_gme_batch_header.attribute25
622: ,l_gme_batch_header.attribute26
623: ,l_gme_batch_header.attribute27
624: ,l_gme_batch_header.attribute28
625: ,l_gme_batch_header.attribute29
626: ,l_gme_batch_header.attribute30
619: ,l_gme_batch_header.attribute23
620: ,l_gme_batch_header.attribute24
621: ,l_gme_batch_header.attribute25
622: ,l_gme_batch_header.attribute26
623: ,l_gme_batch_header.attribute27
624: ,l_gme_batch_header.attribute28
625: ,l_gme_batch_header.attribute29
626: ,l_gme_batch_header.attribute30
627: ,l_gme_batch_header.attribute31
620: ,l_gme_batch_header.attribute24
621: ,l_gme_batch_header.attribute25
622: ,l_gme_batch_header.attribute26
623: ,l_gme_batch_header.attribute27
624: ,l_gme_batch_header.attribute28
625: ,l_gme_batch_header.attribute29
626: ,l_gme_batch_header.attribute30
627: ,l_gme_batch_header.attribute31
628: ,l_gme_batch_header.attribute32
621: ,l_gme_batch_header.attribute25
622: ,l_gme_batch_header.attribute26
623: ,l_gme_batch_header.attribute27
624: ,l_gme_batch_header.attribute28
625: ,l_gme_batch_header.attribute29
626: ,l_gme_batch_header.attribute30
627: ,l_gme_batch_header.attribute31
628: ,l_gme_batch_header.attribute32
629: ,l_gme_batch_header.attribute33
622: ,l_gme_batch_header.attribute26
623: ,l_gme_batch_header.attribute27
624: ,l_gme_batch_header.attribute28
625: ,l_gme_batch_header.attribute29
626: ,l_gme_batch_header.attribute30
627: ,l_gme_batch_header.attribute31
628: ,l_gme_batch_header.attribute32
629: ,l_gme_batch_header.attribute33
630: ,l_gme_batch_header.attribute34
623: ,l_gme_batch_header.attribute27
624: ,l_gme_batch_header.attribute28
625: ,l_gme_batch_header.attribute29
626: ,l_gme_batch_header.attribute30
627: ,l_gme_batch_header.attribute31
628: ,l_gme_batch_header.attribute32
629: ,l_gme_batch_header.attribute33
630: ,l_gme_batch_header.attribute34
631: ,l_gme_batch_header.attribute35
624: ,l_gme_batch_header.attribute28
625: ,l_gme_batch_header.attribute29
626: ,l_gme_batch_header.attribute30
627: ,l_gme_batch_header.attribute31
628: ,l_gme_batch_header.attribute32
629: ,l_gme_batch_header.attribute33
630: ,l_gme_batch_header.attribute34
631: ,l_gme_batch_header.attribute35
632: ,l_gme_batch_header.attribute36
625: ,l_gme_batch_header.attribute29
626: ,l_gme_batch_header.attribute30
627: ,l_gme_batch_header.attribute31
628: ,l_gme_batch_header.attribute32
629: ,l_gme_batch_header.attribute33
630: ,l_gme_batch_header.attribute34
631: ,l_gme_batch_header.attribute35
632: ,l_gme_batch_header.attribute36
633: ,l_gme_batch_header.attribute37
626: ,l_gme_batch_header.attribute30
627: ,l_gme_batch_header.attribute31
628: ,l_gme_batch_header.attribute32
629: ,l_gme_batch_header.attribute33
630: ,l_gme_batch_header.attribute34
631: ,l_gme_batch_header.attribute35
632: ,l_gme_batch_header.attribute36
633: ,l_gme_batch_header.attribute37
634: ,l_gme_batch_header.attribute38
627: ,l_gme_batch_header.attribute31
628: ,l_gme_batch_header.attribute32
629: ,l_gme_batch_header.attribute33
630: ,l_gme_batch_header.attribute34
631: ,l_gme_batch_header.attribute35
632: ,l_gme_batch_header.attribute36
633: ,l_gme_batch_header.attribute37
634: ,l_gme_batch_header.attribute38
635: ,l_gme_batch_header.attribute39
628: ,l_gme_batch_header.attribute32
629: ,l_gme_batch_header.attribute33
630: ,l_gme_batch_header.attribute34
631: ,l_gme_batch_header.attribute35
632: ,l_gme_batch_header.attribute36
633: ,l_gme_batch_header.attribute37
634: ,l_gme_batch_header.attribute38
635: ,l_gme_batch_header.attribute39
636: ,l_gme_batch_header.attribute40
629: ,l_gme_batch_header.attribute33
630: ,l_gme_batch_header.attribute34
631: ,l_gme_batch_header.attribute35
632: ,l_gme_batch_header.attribute36
633: ,l_gme_batch_header.attribute37
634: ,l_gme_batch_header.attribute38
635: ,l_gme_batch_header.attribute39
636: ,l_gme_batch_header.attribute40
637: ,l_gme_batch_header.attribute_category
630: ,l_gme_batch_header.attribute34
631: ,l_gme_batch_header.attribute35
632: ,l_gme_batch_header.attribute36
633: ,l_gme_batch_header.attribute37
634: ,l_gme_batch_header.attribute38
635: ,l_gme_batch_header.attribute39
636: ,l_gme_batch_header.attribute40
637: ,l_gme_batch_header.attribute_category
638: ,l_gme_batch_header.automatic_step_calculation
631: ,l_gme_batch_header.attribute35
632: ,l_gme_batch_header.attribute36
633: ,l_gme_batch_header.attribute37
634: ,l_gme_batch_header.attribute38
635: ,l_gme_batch_header.attribute39
636: ,l_gme_batch_header.attribute40
637: ,l_gme_batch_header.attribute_category
638: ,l_gme_batch_header.automatic_step_calculation
639: ,l_gme_batch_header.firmed_ind
632: ,l_gme_batch_header.attribute36
633: ,l_gme_batch_header.attribute37
634: ,l_gme_batch_header.attribute38
635: ,l_gme_batch_header.attribute39
636: ,l_gme_batch_header.attribute40
637: ,l_gme_batch_header.attribute_category
638: ,l_gme_batch_header.automatic_step_calculation
639: ,l_gme_batch_header.firmed_ind
640: ,l_gme_batch_header.finite_scheduled_ind
633: ,l_gme_batch_header.attribute37
634: ,l_gme_batch_header.attribute38
635: ,l_gme_batch_header.attribute39
636: ,l_gme_batch_header.attribute40
637: ,l_gme_batch_header.attribute_category
638: ,l_gme_batch_header.automatic_step_calculation
639: ,l_gme_batch_header.firmed_ind
640: ,l_gme_batch_header.finite_scheduled_ind
641: ,l_gme_batch_header.order_priority
634: ,l_gme_batch_header.attribute38
635: ,l_gme_batch_header.attribute39
636: ,l_gme_batch_header.attribute40
637: ,l_gme_batch_header.attribute_category
638: ,l_gme_batch_header.automatic_step_calculation
639: ,l_gme_batch_header.firmed_ind
640: ,l_gme_batch_header.finite_scheduled_ind
641: ,l_gme_batch_header.order_priority
642: ,l_gme_batch_header.migrated_batch_ind
635: ,l_gme_batch_header.attribute39
636: ,l_gme_batch_header.attribute40
637: ,l_gme_batch_header.attribute_category
638: ,l_gme_batch_header.automatic_step_calculation
639: ,l_gme_batch_header.firmed_ind
640: ,l_gme_batch_header.finite_scheduled_ind
641: ,l_gme_batch_header.order_priority
642: ,l_gme_batch_header.migrated_batch_ind
643: ,l_gme_batch_header.enforce_step_dependency
636: ,l_gme_batch_header.attribute40
637: ,l_gme_batch_header.attribute_category
638: ,l_gme_batch_header.automatic_step_calculation
639: ,l_gme_batch_header.firmed_ind
640: ,l_gme_batch_header.finite_scheduled_ind
641: ,l_gme_batch_header.order_priority
642: ,l_gme_batch_header.migrated_batch_ind
643: ,l_gme_batch_header.enforce_step_dependency
644: ,l_gme_batch_header.terminated_ind
637: ,l_gme_batch_header.attribute_category
638: ,l_gme_batch_header.automatic_step_calculation
639: ,l_gme_batch_header.firmed_ind
640: ,l_gme_batch_header.finite_scheduled_ind
641: ,l_gme_batch_header.order_priority
642: ,l_gme_batch_header.migrated_batch_ind
643: ,l_gme_batch_header.enforce_step_dependency
644: ,l_gme_batch_header.terminated_ind
645: ,l_gme_batch_header.organization_id
638: ,l_gme_batch_header.automatic_step_calculation
639: ,l_gme_batch_header.firmed_ind
640: ,l_gme_batch_header.finite_scheduled_ind
641: ,l_gme_batch_header.order_priority
642: ,l_gme_batch_header.migrated_batch_ind
643: ,l_gme_batch_header.enforce_step_dependency
644: ,l_gme_batch_header.terminated_ind
645: ,l_gme_batch_header.organization_id
646: ,l_gme_batch_header.laboratory_ind
639: ,l_gme_batch_header.firmed_ind
640: ,l_gme_batch_header.finite_scheduled_ind
641: ,l_gme_batch_header.order_priority
642: ,l_gme_batch_header.migrated_batch_ind
643: ,l_gme_batch_header.enforce_step_dependency
644: ,l_gme_batch_header.terminated_ind
645: ,l_gme_batch_header.organization_id
646: ,l_gme_batch_header.laboratory_ind
647: ,l_gme_batch_header.enhanced_pi_ind
640: ,l_gme_batch_header.finite_scheduled_ind
641: ,l_gme_batch_header.order_priority
642: ,l_gme_batch_header.migrated_batch_ind
643: ,l_gme_batch_header.enforce_step_dependency
644: ,l_gme_batch_header.terminated_ind
645: ,l_gme_batch_header.organization_id
646: ,l_gme_batch_header.laboratory_ind
647: ,l_gme_batch_header.enhanced_pi_ind
648: ,l_gme_batch_header.move_order_header_id
641: ,l_gme_batch_header.order_priority
642: ,l_gme_batch_header.migrated_batch_ind
643: ,l_gme_batch_header.enforce_step_dependency
644: ,l_gme_batch_header.terminated_ind
645: ,l_gme_batch_header.organization_id
646: ,l_gme_batch_header.laboratory_ind
647: ,l_gme_batch_header.enhanced_pi_ind
648: ,l_gme_batch_header.move_order_header_id
649: ,l_gme_batch_header.terminate_reason_id
642: ,l_gme_batch_header.migrated_batch_ind
643: ,l_gme_batch_header.enforce_step_dependency
644: ,l_gme_batch_header.terminated_ind
645: ,l_gme_batch_header.organization_id
646: ,l_gme_batch_header.laboratory_ind
647: ,l_gme_batch_header.enhanced_pi_ind
648: ,l_gme_batch_header.move_order_header_id
649: ,l_gme_batch_header.terminate_reason_id
650: ,l_gme_batch_header.fixed_process_loss_applied
643: ,l_gme_batch_header.enforce_step_dependency
644: ,l_gme_batch_header.terminated_ind
645: ,l_gme_batch_header.organization_id
646: ,l_gme_batch_header.laboratory_ind
647: ,l_gme_batch_header.enhanced_pi_ind
648: ,l_gme_batch_header.move_order_header_id
649: ,l_gme_batch_header.terminate_reason_id
650: ,l_gme_batch_header.fixed_process_loss_applied
651: FROM gme_batch_header
644: ,l_gme_batch_header.terminated_ind
645: ,l_gme_batch_header.organization_id
646: ,l_gme_batch_header.laboratory_ind
647: ,l_gme_batch_header.enhanced_pi_ind
648: ,l_gme_batch_header.move_order_header_id
649: ,l_gme_batch_header.terminate_reason_id
650: ,l_gme_batch_header.fixed_process_loss_applied
651: FROM gme_batch_header
652: WHERE organization_id = p_batch_header.organization_id
645: ,l_gme_batch_header.organization_id
646: ,l_gme_batch_header.laboratory_ind
647: ,l_gme_batch_header.enhanced_pi_ind
648: ,l_gme_batch_header.move_order_header_id
649: ,l_gme_batch_header.terminate_reason_id
650: ,l_gme_batch_header.fixed_process_loss_applied
651: FROM gme_batch_header
652: WHERE organization_id = p_batch_header.organization_id
653: AND batch_no = p_batch_header.batch_no
646: ,l_gme_batch_header.laboratory_ind
647: ,l_gme_batch_header.enhanced_pi_ind
648: ,l_gme_batch_header.move_order_header_id
649: ,l_gme_batch_header.terminate_reason_id
650: ,l_gme_batch_header.fixed_process_loss_applied
651: FROM gme_batch_header
652: WHERE organization_id = p_batch_header.organization_id
653: AND batch_no = p_batch_header.batch_no
654: AND batch_type = p_batch_header.batch_type;
647: ,l_gme_batch_header.enhanced_pi_ind
648: ,l_gme_batch_header.move_order_header_id
649: ,l_gme_batch_header.terminate_reason_id
650: ,l_gme_batch_header.fixed_process_loss_applied
651: FROM gme_batch_header
652: WHERE organization_id = p_batch_header.organization_id
653: AND batch_no = p_batch_header.batch_no
654: AND batch_type = p_batch_header.batch_type;
655: ELSE
662: IF g_debug <= gme_debug.g_log_procedure THEN
663: gme_debug.put_line ('Exiting api ' || g_pkg_name || '.' || l_api_name);
664: END IF;
665:
666: x_batch_header := l_gme_batch_header;
667: RETURN TRUE;
668: EXCEPTION
669: WHEN NO_DATA_FOUND THEN
670: gme_common_pvt.log_message ('GME_NO_DATA_FOUND'
693: | TYPE |
694: | Private |
695: | |
696: | USAGE |
697: | delete_Row will delete a row in gme_batch_header |
698: | |
699: | |
700: | DESCRIPTION |
701: | delete_row will delete a row in gme_batch_header |
697: | delete_Row will delete a row in gme_batch_header |
698: | |
699: | |
700: | DESCRIPTION |
701: | delete_row will delete a row in gme_batch_header |
702: | |
703: | |
704: | PARAMETERS |
705: | p_batch_header IN gme_batch_header%ROWTYPE |
701: | delete_row will delete a row in gme_batch_header |
702: | |
703: | |
704: | PARAMETERS |
705: | p_batch_header IN gme_batch_header%ROWTYPE |
706: | RETURNS |
707: | BOOLEAN |
708: | |
709: | HISTORY |
710: |
711: +==========================================================================+
712: Api end of comments
713: */
714: FUNCTION delete_row (p_batch_header IN gme_batch_header%ROWTYPE)
715: RETURN BOOLEAN
716: IS
717: l_gme_batch_header gme_batch_header%ROWTYPE;
718: l_batch_id NUMBER;
713: */
714: FUNCTION delete_row (p_batch_header IN gme_batch_header%ROWTYPE)
715: RETURN BOOLEAN
716: IS
717: l_gme_batch_header gme_batch_header%ROWTYPE;
718: l_batch_id NUMBER;
719: l_organization_id NUMBER;
720: l_batch_no VARCHAR2 (32);
721: l_batch_type NUMBER (5);
736:
737: IF l_batch_id IS NOT NULL THEN
738: SELECT 1
739: INTO l_dummy
740: FROM gme_batch_header
741: WHERE batch_id = l_batch_id
742: FOR UPDATE NOWAIT;
743:
744: UPDATE gme_batch_header
740: FROM gme_batch_header
741: WHERE batch_id = l_batch_id
742: FOR UPDATE NOWAIT;
743:
744: UPDATE gme_batch_header
745: SET delete_mark = 1
746: WHERE batch_id = p_batch_header.batch_id;
747: ELSIF (l_organization_id IS NOT NULL)
748: AND (l_batch_no IS NOT NULL)
748: AND (l_batch_no IS NOT NULL)
749: AND (l_batch_type IS NOT NULL) THEN
750: SELECT 1
751: INTO l_dummy
752: FROM gme_batch_header
753: WHERE organization_id = p_batch_header.organization_id
754: AND batch_no = p_batch_header.batch_no
755: AND batch_type = p_batch_header.batch_type
756: FOR UPDATE NOWAIT;
754: AND batch_no = p_batch_header.batch_no
755: AND batch_type = p_batch_header.batch_type
756: FOR UPDATE NOWAIT;
757:
758: UPDATE gme_batch_header
759: SET delete_mark = 1
760: WHERE organization_id = p_batch_header.organization_id
761: AND batch_no = p_batch_header.batch_no
762: AND batch_type = p_batch_header.batch_type;
820: | TYPE |
821: | Private |
822: | |
823: | USAGE |
824: | update_row will update a row in gme_batch_header |
825: | |
826: | |
827: | DESCRIPTION |
828: | update_row will update a row in gme_batch_header |
824: | update_row will update a row in gme_batch_header |
825: | |
826: | |
827: | DESCRIPTION |
828: | update_row will update a row in gme_batch_header |
829: | |
830: | |
831: | PARAMETERS |
832: | p_batch_header IN gme_batch_header%ROWTYPE |
828: | update_row will update a row in gme_batch_header |
829: | |
830: | |
831: | PARAMETERS |
832: | p_batch_header IN gme_batch_header%ROWTYPE |
833: | RETURNS |
834: | BOOLEAN |
835: | |
836: | HISTORY |
838: | |
839: +==========================================================================+
840: Api end of comments
841: */
842: FUNCTION update_row (p_batch_header IN gme_batch_header%ROWTYPE)
843: RETURN BOOLEAN
844: IS
845: l_dummy NUMBER := 0;
846: l_batch_id NUMBER;
868:
869: IF l_batch_id IS NOT NULL THEN
870: SELECT 1
871: INTO l_dummy
872: FROM gme_batch_header
873: WHERE batch_id = l_batch_id
874: FOR UPDATE NOWAIT;
875:
876: UPDATE gme_batch_header
872: FROM gme_batch_header
873: WHERE batch_id = l_batch_id
874: FOR UPDATE NOWAIT;
875:
876: UPDATE gme_batch_header
877: SET recipe_validity_rule_id =
878: p_batch_header.recipe_validity_rule_id
879: ,formula_id = p_batch_header.formula_id
880: ,routing_id = p_batch_header.routing_id
959: AND (l_batch_no IS NOT NULL)
960: AND (l_batch_type IS NOT NULL) THEN
961: SELECT 1
962: INTO l_dummy
963: FROM gme_batch_header
964: WHERE organization_id = p_batch_header.organization_id
965: AND batch_no = p_batch_header.batch_no
966: AND batch_type = p_batch_header.batch_type
967: FOR UPDATE NOWAIT;
965: AND batch_no = p_batch_header.batch_no
966: AND batch_type = p_batch_header.batch_type
967: FOR UPDATE NOWAIT;
968:
969: UPDATE gme_batch_header
970: SET organization_id = p_batch_header.organization_id
971: ,batch_no = p_batch_header.batch_no
972: ,batch_type = p_batch_header.batch_type
973: ,prod_id = p_batch_header.prod_id
1118: |
1119: | TYPE
1120: | Private
1121: | USAGE
1122: | Lock_Row will lock a row in gme_batch_header
1123: |
1124: |
1125: | DESCRIPTION
1126: | Lock_Row will lock a row in gme_batch_header
1122: | Lock_Row will lock a row in gme_batch_header
1123: |
1124: |
1125: | DESCRIPTION
1126: | Lock_Row will lock a row in gme_batch_header
1127: |
1128: |
1129: |
1130: | PARAMETERS
1127: |
1128: |
1129: |
1130: | PARAMETERS
1131: | p_batch_header IN gme_batch_header%ROWTYPE
1132: |
1133: | RETURNS
1134: | BOOLEAN
1135: | HISTORY
1138: |
1139: |
1140: +=============================================================================
1141: */
1142: FUNCTION lock_row (p_batch_header IN gme_batch_header%ROWTYPE)
1143: RETURN BOOLEAN
1144: IS
1145: l_dummy NUMBER;
1146: l_api_name CONSTANT VARCHAR2 (30) := 'LOCK_ROW';
1152:
1153: IF p_batch_header.batch_id IS NOT NULL THEN
1154: SELECT 1
1155: INTO l_dummy
1156: FROM gme_batch_header
1157: WHERE batch_id = p_batch_header.batch_id
1158: FOR UPDATE NOWAIT;
1159: ELSIF ( p_batch_header.organization_id IS NOT NULL
1160: AND p_batch_header.batch_no IS NOT NULL
1160: AND p_batch_header.batch_no IS NOT NULL
1161: AND p_batch_header.batch_type IS NOT NULL) THEN
1162: SELECT 1
1163: INTO l_dummy
1164: FROM gme_batch_header
1165: WHERE organization_id = p_batch_header.organization_id
1166: AND batch_no = p_batch_header.batch_no
1167: AND batch_type = p_batch_header.batch_type
1168: FOR UPDATE NOWAIT;
1201: --Bug2804440
1202: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
1203: RETURN FALSE;
1204: END lock_row;
1205: END gme_batch_header_dbl;