1: PACKAGE BODY gme_batch_header_dbl AS
2: /* $Header: GMEVGBHB.pls 120.11.12020000.2 2012/07/26 15:37:14 gmurator ship $ */
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.11.12020000.2 2012/07/26 15:37:14 gmurator ship $ */
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 |
42: | TYPE |
43: | Private |
44: | |
45: | USAGE |
46: | insert_Row will insert a row in gme_batch_header |
47: | |
48: | |
49: | DESCRIPTION |
50: | insert_Row will insert a row in gme_batch_header |
46: | insert_Row will insert a row in gme_batch_header |
47: | |
48: | |
49: | DESCRIPTION |
50: | insert_Row will insert a row in gme_batch_header |
51: | |
52: | |
53: | PARAMETERS |
54: | p_batch_header IN gme_batch_header%ROWTYPE |
50: | insert_Row will insert a row in gme_batch_header |
51: | |
52: | |
53: | PARAMETERS |
54: | p_batch_header IN gme_batch_header%ROWTYPE |
55: | x_batch_header IN OUT NOCOPY gme_batch_header%ROWTYPE |
56: | RETURNS |
57: | BOOLEAN |
58: | |
51: | |
52: | |
53: | PARAMETERS |
54: | p_batch_header IN gme_batch_header%ROWTYPE |
55: | x_batch_header IN OUT NOCOPY gme_batch_header%ROWTYPE |
56: | RETURNS |
57: | BOOLEAN |
58: | |
59: | HISTORY |
62: +==========================================================================+
63: Api end of comments
64: */
65: FUNCTION insert_row (
66: p_batch_header IN gme_batch_header%ROWTYPE
67: ,x_batch_header IN OUT NOCOPY gme_batch_header%ROWTYPE)
68: RETURN BOOLEAN
69: IS
70: l_api_name CONSTANT VARCHAR2 (30) := 'INSERT_ROW';
63: Api end of comments
64: */
65: FUNCTION insert_row (
66: p_batch_header IN gme_batch_header%ROWTYPE
67: ,x_batch_header IN OUT NOCOPY gme_batch_header%ROWTYPE)
68: RETURN BOOLEAN
69: IS
70: l_api_name CONSTANT VARCHAR2 (30) := 'INSERT_ROW';
71: l_wip_entity_id NUMBER;
108: ,0, gme_common_pvt.g_wip_entity_type_batch
109: ,gme_common_pvt.g_wip_entity_type_fpo)
110: ,mtl_gen_object_id_s.NEXTVAL);
111:
112: INSERT INTO gme_batch_header
113: (batch_id, batch_no
114: ,batch_type, prod_id
115: ,prod_sequence
116: ,recipe_validity_rule_id
255: | TYPE |
256: | Private |
257: | |
258: | USAGE |
259: | fetch_Row will fetch a row in gme_batch_header |
260: | |
261: | |
262: | DESCRIPTION |
263: | fetch_row will fetch a row in gme_batch_header |
259: | fetch_Row will fetch a row in gme_batch_header |
260: | |
261: | |
262: | DESCRIPTION |
263: | fetch_row will fetch a row in gme_batch_header |
264: | |
265: | |
266: | PARAMETERS |
267: | p_batch_header IN gme_batch_header%ROWTYPE |
263: | fetch_row will fetch a row in gme_batch_header |
264: | |
265: | |
266: | PARAMETERS |
267: | p_batch_header IN gme_batch_header%ROWTYPE |
268: | x_batch_header IN OUT NOCOPY gme_batch_header%ROWTYPE |
269: | RETURNS |
270: | BOOLEAN |
271: | |
264: | |
265: | |
266: | PARAMETERS |
267: | p_batch_header IN gme_batch_header%ROWTYPE |
268: | x_batch_header IN OUT NOCOPY gme_batch_header%ROWTYPE |
269: | RETURNS |
270: | BOOLEAN |
271: | |
272: | HISTORY |
274: +==========================================================================+
275: Api end of comments
276: */
277: FUNCTION fetch_row (
278: p_batch_header IN gme_batch_header%ROWTYPE
279: ,x_batch_header IN OUT NOCOPY gme_batch_header%ROWTYPE)
280: RETURN BOOLEAN
281: IS
282: l_gme_batch_header gme_batch_header%ROWTYPE;
275: Api end of comments
276: */
277: FUNCTION fetch_row (
278: p_batch_header IN gme_batch_header%ROWTYPE
279: ,x_batch_header IN OUT NOCOPY gme_batch_header%ROWTYPE)
280: RETURN BOOLEAN
281: IS
282: l_gme_batch_header gme_batch_header%ROWTYPE;
283: l_batch_id NUMBER;
278: p_batch_header IN gme_batch_header%ROWTYPE
279: ,x_batch_header IN OUT NOCOPY gme_batch_header%ROWTYPE)
280: RETURN BOOLEAN
281: IS
282: l_gme_batch_header gme_batch_header%ROWTYPE;
283: l_batch_id NUMBER;
284: l_organization_id NUMBER;
285: l_batch_no VARCHAR2 (32);
286: l_batch_type NUMBER (5);
388: ,move_order_header_id
389: ,terminate_reason_id
390: ,fixed_process_loss_applied
391: ,ja_osp_batch --Bug7616310
392: INTO l_gme_batch_header.batch_id
393: --, l_gme_batch_header.PLANT_CODE
394: , l_gme_batch_header.batch_no
395: ,l_gme_batch_header.batch_type, l_gme_batch_header.prod_id
396: ,l_gme_batch_header.prod_sequence
389: ,terminate_reason_id
390: ,fixed_process_loss_applied
391: ,ja_osp_batch --Bug7616310
392: INTO l_gme_batch_header.batch_id
393: --, l_gme_batch_header.PLANT_CODE
394: , l_gme_batch_header.batch_no
395: ,l_gme_batch_header.batch_type, l_gme_batch_header.prod_id
396: ,l_gme_batch_header.prod_sequence
397: ,l_gme_batch_header.recipe_validity_rule_id
390: ,fixed_process_loss_applied
391: ,ja_osp_batch --Bug7616310
392: INTO l_gme_batch_header.batch_id
393: --, l_gme_batch_header.PLANT_CODE
394: , l_gme_batch_header.batch_no
395: ,l_gme_batch_header.batch_type, l_gme_batch_header.prod_id
396: ,l_gme_batch_header.prod_sequence
397: ,l_gme_batch_header.recipe_validity_rule_id
398: ,l_gme_batch_header.formula_id
391: ,ja_osp_batch --Bug7616310
392: INTO l_gme_batch_header.batch_id
393: --, l_gme_batch_header.PLANT_CODE
394: , l_gme_batch_header.batch_no
395: ,l_gme_batch_header.batch_type, l_gme_batch_header.prod_id
396: ,l_gme_batch_header.prod_sequence
397: ,l_gme_batch_header.recipe_validity_rule_id
398: ,l_gme_batch_header.formula_id
399: ,l_gme_batch_header.routing_id
392: INTO l_gme_batch_header.batch_id
393: --, l_gme_batch_header.PLANT_CODE
394: , l_gme_batch_header.batch_no
395: ,l_gme_batch_header.batch_type, l_gme_batch_header.prod_id
396: ,l_gme_batch_header.prod_sequence
397: ,l_gme_batch_header.recipe_validity_rule_id
398: ,l_gme_batch_header.formula_id
399: ,l_gme_batch_header.routing_id
400: ,l_gme_batch_header.plan_start_date
393: --, l_gme_batch_header.PLANT_CODE
394: , l_gme_batch_header.batch_no
395: ,l_gme_batch_header.batch_type, l_gme_batch_header.prod_id
396: ,l_gme_batch_header.prod_sequence
397: ,l_gme_batch_header.recipe_validity_rule_id
398: ,l_gme_batch_header.formula_id
399: ,l_gme_batch_header.routing_id
400: ,l_gme_batch_header.plan_start_date
401: ,l_gme_batch_header.actual_start_date
394: , l_gme_batch_header.batch_no
395: ,l_gme_batch_header.batch_type, l_gme_batch_header.prod_id
396: ,l_gme_batch_header.prod_sequence
397: ,l_gme_batch_header.recipe_validity_rule_id
398: ,l_gme_batch_header.formula_id
399: ,l_gme_batch_header.routing_id
400: ,l_gme_batch_header.plan_start_date
401: ,l_gme_batch_header.actual_start_date
402: ,l_gme_batch_header.due_date
395: ,l_gme_batch_header.batch_type, l_gme_batch_header.prod_id
396: ,l_gme_batch_header.prod_sequence
397: ,l_gme_batch_header.recipe_validity_rule_id
398: ,l_gme_batch_header.formula_id
399: ,l_gme_batch_header.routing_id
400: ,l_gme_batch_header.plan_start_date
401: ,l_gme_batch_header.actual_start_date
402: ,l_gme_batch_header.due_date
403: ,l_gme_batch_header.plan_cmplt_date
396: ,l_gme_batch_header.prod_sequence
397: ,l_gme_batch_header.recipe_validity_rule_id
398: ,l_gme_batch_header.formula_id
399: ,l_gme_batch_header.routing_id
400: ,l_gme_batch_header.plan_start_date
401: ,l_gme_batch_header.actual_start_date
402: ,l_gme_batch_header.due_date
403: ,l_gme_batch_header.plan_cmplt_date
404: ,l_gme_batch_header.actual_cmplt_date
397: ,l_gme_batch_header.recipe_validity_rule_id
398: ,l_gme_batch_header.formula_id
399: ,l_gme_batch_header.routing_id
400: ,l_gme_batch_header.plan_start_date
401: ,l_gme_batch_header.actual_start_date
402: ,l_gme_batch_header.due_date
403: ,l_gme_batch_header.plan_cmplt_date
404: ,l_gme_batch_header.actual_cmplt_date
405: ,l_gme_batch_header.batch_status
398: ,l_gme_batch_header.formula_id
399: ,l_gme_batch_header.routing_id
400: ,l_gme_batch_header.plan_start_date
401: ,l_gme_batch_header.actual_start_date
402: ,l_gme_batch_header.due_date
403: ,l_gme_batch_header.plan_cmplt_date
404: ,l_gme_batch_header.actual_cmplt_date
405: ,l_gme_batch_header.batch_status
406: ,l_gme_batch_header.priority_value
399: ,l_gme_batch_header.routing_id
400: ,l_gme_batch_header.plan_start_date
401: ,l_gme_batch_header.actual_start_date
402: ,l_gme_batch_header.due_date
403: ,l_gme_batch_header.plan_cmplt_date
404: ,l_gme_batch_header.actual_cmplt_date
405: ,l_gme_batch_header.batch_status
406: ,l_gme_batch_header.priority_value
407: ,l_gme_batch_header.priority_code
400: ,l_gme_batch_header.plan_start_date
401: ,l_gme_batch_header.actual_start_date
402: ,l_gme_batch_header.due_date
403: ,l_gme_batch_header.plan_cmplt_date
404: ,l_gme_batch_header.actual_cmplt_date
405: ,l_gme_batch_header.batch_status
406: ,l_gme_batch_header.priority_value
407: ,l_gme_batch_header.priority_code
408: ,l_gme_batch_header.print_count
401: ,l_gme_batch_header.actual_start_date
402: ,l_gme_batch_header.due_date
403: ,l_gme_batch_header.plan_cmplt_date
404: ,l_gme_batch_header.actual_cmplt_date
405: ,l_gme_batch_header.batch_status
406: ,l_gme_batch_header.priority_value
407: ,l_gme_batch_header.priority_code
408: ,l_gme_batch_header.print_count
409: ,l_gme_batch_header.fmcontrol_class
402: ,l_gme_batch_header.due_date
403: ,l_gme_batch_header.plan_cmplt_date
404: ,l_gme_batch_header.actual_cmplt_date
405: ,l_gme_batch_header.batch_status
406: ,l_gme_batch_header.priority_value
407: ,l_gme_batch_header.priority_code
408: ,l_gme_batch_header.print_count
409: ,l_gme_batch_header.fmcontrol_class
410: --, l_gme_batch_header.WIP_WHSE_CODE
403: ,l_gme_batch_header.plan_cmplt_date
404: ,l_gme_batch_header.actual_cmplt_date
405: ,l_gme_batch_header.batch_status
406: ,l_gme_batch_header.priority_value
407: ,l_gme_batch_header.priority_code
408: ,l_gme_batch_header.print_count
409: ,l_gme_batch_header.fmcontrol_class
410: --, l_gme_batch_header.WIP_WHSE_CODE
411: , l_gme_batch_header.batch_close_date
404: ,l_gme_batch_header.actual_cmplt_date
405: ,l_gme_batch_header.batch_status
406: ,l_gme_batch_header.priority_value
407: ,l_gme_batch_header.priority_code
408: ,l_gme_batch_header.print_count
409: ,l_gme_batch_header.fmcontrol_class
410: --, l_gme_batch_header.WIP_WHSE_CODE
411: , l_gme_batch_header.batch_close_date
412: ,l_gme_batch_header.poc_ind
405: ,l_gme_batch_header.batch_status
406: ,l_gme_batch_header.priority_value
407: ,l_gme_batch_header.priority_code
408: ,l_gme_batch_header.print_count
409: ,l_gme_batch_header.fmcontrol_class
410: --, l_gme_batch_header.WIP_WHSE_CODE
411: , l_gme_batch_header.batch_close_date
412: ,l_gme_batch_header.poc_ind
413: ,l_gme_batch_header.actual_cost_ind
406: ,l_gme_batch_header.priority_value
407: ,l_gme_batch_header.priority_code
408: ,l_gme_batch_header.print_count
409: ,l_gme_batch_header.fmcontrol_class
410: --, l_gme_batch_header.WIP_WHSE_CODE
411: , l_gme_batch_header.batch_close_date
412: ,l_gme_batch_header.poc_ind
413: ,l_gme_batch_header.actual_cost_ind
414: ,l_gme_batch_header.gl_posted_ind
407: ,l_gme_batch_header.priority_code
408: ,l_gme_batch_header.print_count
409: ,l_gme_batch_header.fmcontrol_class
410: --, l_gme_batch_header.WIP_WHSE_CODE
411: , l_gme_batch_header.batch_close_date
412: ,l_gme_batch_header.poc_ind
413: ,l_gme_batch_header.actual_cost_ind
414: ,l_gme_batch_header.gl_posted_ind
415: ,l_gme_batch_header.update_inventory_ind
408: ,l_gme_batch_header.print_count
409: ,l_gme_batch_header.fmcontrol_class
410: --, l_gme_batch_header.WIP_WHSE_CODE
411: , l_gme_batch_header.batch_close_date
412: ,l_gme_batch_header.poc_ind
413: ,l_gme_batch_header.actual_cost_ind
414: ,l_gme_batch_header.gl_posted_ind
415: ,l_gme_batch_header.update_inventory_ind
416: ,l_gme_batch_header.last_update_date
409: ,l_gme_batch_header.fmcontrol_class
410: --, l_gme_batch_header.WIP_WHSE_CODE
411: , l_gme_batch_header.batch_close_date
412: ,l_gme_batch_header.poc_ind
413: ,l_gme_batch_header.actual_cost_ind
414: ,l_gme_batch_header.gl_posted_ind
415: ,l_gme_batch_header.update_inventory_ind
416: ,l_gme_batch_header.last_update_date
417: ,l_gme_batch_header.last_updated_by
410: --, l_gme_batch_header.WIP_WHSE_CODE
411: , l_gme_batch_header.batch_close_date
412: ,l_gme_batch_header.poc_ind
413: ,l_gme_batch_header.actual_cost_ind
414: ,l_gme_batch_header.gl_posted_ind
415: ,l_gme_batch_header.update_inventory_ind
416: ,l_gme_batch_header.last_update_date
417: ,l_gme_batch_header.last_updated_by
418: ,l_gme_batch_header.creation_date
411: , l_gme_batch_header.batch_close_date
412: ,l_gme_batch_header.poc_ind
413: ,l_gme_batch_header.actual_cost_ind
414: ,l_gme_batch_header.gl_posted_ind
415: ,l_gme_batch_header.update_inventory_ind
416: ,l_gme_batch_header.last_update_date
417: ,l_gme_batch_header.last_updated_by
418: ,l_gme_batch_header.creation_date
419: ,l_gme_batch_header.created_by
412: ,l_gme_batch_header.poc_ind
413: ,l_gme_batch_header.actual_cost_ind
414: ,l_gme_batch_header.gl_posted_ind
415: ,l_gme_batch_header.update_inventory_ind
416: ,l_gme_batch_header.last_update_date
417: ,l_gme_batch_header.last_updated_by
418: ,l_gme_batch_header.creation_date
419: ,l_gme_batch_header.created_by
420: ,l_gme_batch_header.last_update_login
413: ,l_gme_batch_header.actual_cost_ind
414: ,l_gme_batch_header.gl_posted_ind
415: ,l_gme_batch_header.update_inventory_ind
416: ,l_gme_batch_header.last_update_date
417: ,l_gme_batch_header.last_updated_by
418: ,l_gme_batch_header.creation_date
419: ,l_gme_batch_header.created_by
420: ,l_gme_batch_header.last_update_login
421: ,l_gme_batch_header.delete_mark
414: ,l_gme_batch_header.gl_posted_ind
415: ,l_gme_batch_header.update_inventory_ind
416: ,l_gme_batch_header.last_update_date
417: ,l_gme_batch_header.last_updated_by
418: ,l_gme_batch_header.creation_date
419: ,l_gme_batch_header.created_by
420: ,l_gme_batch_header.last_update_login
421: ,l_gme_batch_header.delete_mark
422: ,l_gme_batch_header.text_code
415: ,l_gme_batch_header.update_inventory_ind
416: ,l_gme_batch_header.last_update_date
417: ,l_gme_batch_header.last_updated_by
418: ,l_gme_batch_header.creation_date
419: ,l_gme_batch_header.created_by
420: ,l_gme_batch_header.last_update_login
421: ,l_gme_batch_header.delete_mark
422: ,l_gme_batch_header.text_code
423: ,l_gme_batch_header.parentline_id, l_gme_batch_header.fpo_id
416: ,l_gme_batch_header.last_update_date
417: ,l_gme_batch_header.last_updated_by
418: ,l_gme_batch_header.creation_date
419: ,l_gme_batch_header.created_by
420: ,l_gme_batch_header.last_update_login
421: ,l_gme_batch_header.delete_mark
422: ,l_gme_batch_header.text_code
423: ,l_gme_batch_header.parentline_id, l_gme_batch_header.fpo_id
424: ,l_gme_batch_header.attribute1
417: ,l_gme_batch_header.last_updated_by
418: ,l_gme_batch_header.creation_date
419: ,l_gme_batch_header.created_by
420: ,l_gme_batch_header.last_update_login
421: ,l_gme_batch_header.delete_mark
422: ,l_gme_batch_header.text_code
423: ,l_gme_batch_header.parentline_id, l_gme_batch_header.fpo_id
424: ,l_gme_batch_header.attribute1
425: ,l_gme_batch_header.attribute2
418: ,l_gme_batch_header.creation_date
419: ,l_gme_batch_header.created_by
420: ,l_gme_batch_header.last_update_login
421: ,l_gme_batch_header.delete_mark
422: ,l_gme_batch_header.text_code
423: ,l_gme_batch_header.parentline_id, l_gme_batch_header.fpo_id
424: ,l_gme_batch_header.attribute1
425: ,l_gme_batch_header.attribute2
426: ,l_gme_batch_header.attribute3
419: ,l_gme_batch_header.created_by
420: ,l_gme_batch_header.last_update_login
421: ,l_gme_batch_header.delete_mark
422: ,l_gme_batch_header.text_code
423: ,l_gme_batch_header.parentline_id, l_gme_batch_header.fpo_id
424: ,l_gme_batch_header.attribute1
425: ,l_gme_batch_header.attribute2
426: ,l_gme_batch_header.attribute3
427: ,l_gme_batch_header.attribute4
420: ,l_gme_batch_header.last_update_login
421: ,l_gme_batch_header.delete_mark
422: ,l_gme_batch_header.text_code
423: ,l_gme_batch_header.parentline_id, l_gme_batch_header.fpo_id
424: ,l_gme_batch_header.attribute1
425: ,l_gme_batch_header.attribute2
426: ,l_gme_batch_header.attribute3
427: ,l_gme_batch_header.attribute4
428: ,l_gme_batch_header.attribute5
421: ,l_gme_batch_header.delete_mark
422: ,l_gme_batch_header.text_code
423: ,l_gme_batch_header.parentline_id, l_gme_batch_header.fpo_id
424: ,l_gme_batch_header.attribute1
425: ,l_gme_batch_header.attribute2
426: ,l_gme_batch_header.attribute3
427: ,l_gme_batch_header.attribute4
428: ,l_gme_batch_header.attribute5
429: ,l_gme_batch_header.attribute6
422: ,l_gme_batch_header.text_code
423: ,l_gme_batch_header.parentline_id, l_gme_batch_header.fpo_id
424: ,l_gme_batch_header.attribute1
425: ,l_gme_batch_header.attribute2
426: ,l_gme_batch_header.attribute3
427: ,l_gme_batch_header.attribute4
428: ,l_gme_batch_header.attribute5
429: ,l_gme_batch_header.attribute6
430: ,l_gme_batch_header.attribute7
423: ,l_gme_batch_header.parentline_id, l_gme_batch_header.fpo_id
424: ,l_gme_batch_header.attribute1
425: ,l_gme_batch_header.attribute2
426: ,l_gme_batch_header.attribute3
427: ,l_gme_batch_header.attribute4
428: ,l_gme_batch_header.attribute5
429: ,l_gme_batch_header.attribute6
430: ,l_gme_batch_header.attribute7
431: ,l_gme_batch_header.attribute8
424: ,l_gme_batch_header.attribute1
425: ,l_gme_batch_header.attribute2
426: ,l_gme_batch_header.attribute3
427: ,l_gme_batch_header.attribute4
428: ,l_gme_batch_header.attribute5
429: ,l_gme_batch_header.attribute6
430: ,l_gme_batch_header.attribute7
431: ,l_gme_batch_header.attribute8
432: ,l_gme_batch_header.attribute9
425: ,l_gme_batch_header.attribute2
426: ,l_gme_batch_header.attribute3
427: ,l_gme_batch_header.attribute4
428: ,l_gme_batch_header.attribute5
429: ,l_gme_batch_header.attribute6
430: ,l_gme_batch_header.attribute7
431: ,l_gme_batch_header.attribute8
432: ,l_gme_batch_header.attribute9
433: ,l_gme_batch_header.attribute10
426: ,l_gme_batch_header.attribute3
427: ,l_gme_batch_header.attribute4
428: ,l_gme_batch_header.attribute5
429: ,l_gme_batch_header.attribute6
430: ,l_gme_batch_header.attribute7
431: ,l_gme_batch_header.attribute8
432: ,l_gme_batch_header.attribute9
433: ,l_gme_batch_header.attribute10
434: ,l_gme_batch_header.attribute11
427: ,l_gme_batch_header.attribute4
428: ,l_gme_batch_header.attribute5
429: ,l_gme_batch_header.attribute6
430: ,l_gme_batch_header.attribute7
431: ,l_gme_batch_header.attribute8
432: ,l_gme_batch_header.attribute9
433: ,l_gme_batch_header.attribute10
434: ,l_gme_batch_header.attribute11
435: ,l_gme_batch_header.attribute12
428: ,l_gme_batch_header.attribute5
429: ,l_gme_batch_header.attribute6
430: ,l_gme_batch_header.attribute7
431: ,l_gme_batch_header.attribute8
432: ,l_gme_batch_header.attribute9
433: ,l_gme_batch_header.attribute10
434: ,l_gme_batch_header.attribute11
435: ,l_gme_batch_header.attribute12
436: ,l_gme_batch_header.attribute13
429: ,l_gme_batch_header.attribute6
430: ,l_gme_batch_header.attribute7
431: ,l_gme_batch_header.attribute8
432: ,l_gme_batch_header.attribute9
433: ,l_gme_batch_header.attribute10
434: ,l_gme_batch_header.attribute11
435: ,l_gme_batch_header.attribute12
436: ,l_gme_batch_header.attribute13
437: ,l_gme_batch_header.attribute14
430: ,l_gme_batch_header.attribute7
431: ,l_gme_batch_header.attribute8
432: ,l_gme_batch_header.attribute9
433: ,l_gme_batch_header.attribute10
434: ,l_gme_batch_header.attribute11
435: ,l_gme_batch_header.attribute12
436: ,l_gme_batch_header.attribute13
437: ,l_gme_batch_header.attribute14
438: ,l_gme_batch_header.attribute15
431: ,l_gme_batch_header.attribute8
432: ,l_gme_batch_header.attribute9
433: ,l_gme_batch_header.attribute10
434: ,l_gme_batch_header.attribute11
435: ,l_gme_batch_header.attribute12
436: ,l_gme_batch_header.attribute13
437: ,l_gme_batch_header.attribute14
438: ,l_gme_batch_header.attribute15
439: ,l_gme_batch_header.attribute16
432: ,l_gme_batch_header.attribute9
433: ,l_gme_batch_header.attribute10
434: ,l_gme_batch_header.attribute11
435: ,l_gme_batch_header.attribute12
436: ,l_gme_batch_header.attribute13
437: ,l_gme_batch_header.attribute14
438: ,l_gme_batch_header.attribute15
439: ,l_gme_batch_header.attribute16
440: ,l_gme_batch_header.attribute17
433: ,l_gme_batch_header.attribute10
434: ,l_gme_batch_header.attribute11
435: ,l_gme_batch_header.attribute12
436: ,l_gme_batch_header.attribute13
437: ,l_gme_batch_header.attribute14
438: ,l_gme_batch_header.attribute15
439: ,l_gme_batch_header.attribute16
440: ,l_gme_batch_header.attribute17
441: ,l_gme_batch_header.attribute18
434: ,l_gme_batch_header.attribute11
435: ,l_gme_batch_header.attribute12
436: ,l_gme_batch_header.attribute13
437: ,l_gme_batch_header.attribute14
438: ,l_gme_batch_header.attribute15
439: ,l_gme_batch_header.attribute16
440: ,l_gme_batch_header.attribute17
441: ,l_gme_batch_header.attribute18
442: ,l_gme_batch_header.attribute19
435: ,l_gme_batch_header.attribute12
436: ,l_gme_batch_header.attribute13
437: ,l_gme_batch_header.attribute14
438: ,l_gme_batch_header.attribute15
439: ,l_gme_batch_header.attribute16
440: ,l_gme_batch_header.attribute17
441: ,l_gme_batch_header.attribute18
442: ,l_gme_batch_header.attribute19
443: ,l_gme_batch_header.attribute20
436: ,l_gme_batch_header.attribute13
437: ,l_gme_batch_header.attribute14
438: ,l_gme_batch_header.attribute15
439: ,l_gme_batch_header.attribute16
440: ,l_gme_batch_header.attribute17
441: ,l_gme_batch_header.attribute18
442: ,l_gme_batch_header.attribute19
443: ,l_gme_batch_header.attribute20
444: ,l_gme_batch_header.attribute21
437: ,l_gme_batch_header.attribute14
438: ,l_gme_batch_header.attribute15
439: ,l_gme_batch_header.attribute16
440: ,l_gme_batch_header.attribute17
441: ,l_gme_batch_header.attribute18
442: ,l_gme_batch_header.attribute19
443: ,l_gme_batch_header.attribute20
444: ,l_gme_batch_header.attribute21
445: ,l_gme_batch_header.attribute22
438: ,l_gme_batch_header.attribute15
439: ,l_gme_batch_header.attribute16
440: ,l_gme_batch_header.attribute17
441: ,l_gme_batch_header.attribute18
442: ,l_gme_batch_header.attribute19
443: ,l_gme_batch_header.attribute20
444: ,l_gme_batch_header.attribute21
445: ,l_gme_batch_header.attribute22
446: ,l_gme_batch_header.attribute23
439: ,l_gme_batch_header.attribute16
440: ,l_gme_batch_header.attribute17
441: ,l_gme_batch_header.attribute18
442: ,l_gme_batch_header.attribute19
443: ,l_gme_batch_header.attribute20
444: ,l_gme_batch_header.attribute21
445: ,l_gme_batch_header.attribute22
446: ,l_gme_batch_header.attribute23
447: ,l_gme_batch_header.attribute24
440: ,l_gme_batch_header.attribute17
441: ,l_gme_batch_header.attribute18
442: ,l_gme_batch_header.attribute19
443: ,l_gme_batch_header.attribute20
444: ,l_gme_batch_header.attribute21
445: ,l_gme_batch_header.attribute22
446: ,l_gme_batch_header.attribute23
447: ,l_gme_batch_header.attribute24
448: ,l_gme_batch_header.attribute25
441: ,l_gme_batch_header.attribute18
442: ,l_gme_batch_header.attribute19
443: ,l_gme_batch_header.attribute20
444: ,l_gme_batch_header.attribute21
445: ,l_gme_batch_header.attribute22
446: ,l_gme_batch_header.attribute23
447: ,l_gme_batch_header.attribute24
448: ,l_gme_batch_header.attribute25
449: ,l_gme_batch_header.attribute26
442: ,l_gme_batch_header.attribute19
443: ,l_gme_batch_header.attribute20
444: ,l_gme_batch_header.attribute21
445: ,l_gme_batch_header.attribute22
446: ,l_gme_batch_header.attribute23
447: ,l_gme_batch_header.attribute24
448: ,l_gme_batch_header.attribute25
449: ,l_gme_batch_header.attribute26
450: ,l_gme_batch_header.attribute27
443: ,l_gme_batch_header.attribute20
444: ,l_gme_batch_header.attribute21
445: ,l_gme_batch_header.attribute22
446: ,l_gme_batch_header.attribute23
447: ,l_gme_batch_header.attribute24
448: ,l_gme_batch_header.attribute25
449: ,l_gme_batch_header.attribute26
450: ,l_gme_batch_header.attribute27
451: ,l_gme_batch_header.attribute28
444: ,l_gme_batch_header.attribute21
445: ,l_gme_batch_header.attribute22
446: ,l_gme_batch_header.attribute23
447: ,l_gme_batch_header.attribute24
448: ,l_gme_batch_header.attribute25
449: ,l_gme_batch_header.attribute26
450: ,l_gme_batch_header.attribute27
451: ,l_gme_batch_header.attribute28
452: ,l_gme_batch_header.attribute29
445: ,l_gme_batch_header.attribute22
446: ,l_gme_batch_header.attribute23
447: ,l_gme_batch_header.attribute24
448: ,l_gme_batch_header.attribute25
449: ,l_gme_batch_header.attribute26
450: ,l_gme_batch_header.attribute27
451: ,l_gme_batch_header.attribute28
452: ,l_gme_batch_header.attribute29
453: ,l_gme_batch_header.attribute30
446: ,l_gme_batch_header.attribute23
447: ,l_gme_batch_header.attribute24
448: ,l_gme_batch_header.attribute25
449: ,l_gme_batch_header.attribute26
450: ,l_gme_batch_header.attribute27
451: ,l_gme_batch_header.attribute28
452: ,l_gme_batch_header.attribute29
453: ,l_gme_batch_header.attribute30
454: ,l_gme_batch_header.attribute31
447: ,l_gme_batch_header.attribute24
448: ,l_gme_batch_header.attribute25
449: ,l_gme_batch_header.attribute26
450: ,l_gme_batch_header.attribute27
451: ,l_gme_batch_header.attribute28
452: ,l_gme_batch_header.attribute29
453: ,l_gme_batch_header.attribute30
454: ,l_gme_batch_header.attribute31
455: ,l_gme_batch_header.attribute32
448: ,l_gme_batch_header.attribute25
449: ,l_gme_batch_header.attribute26
450: ,l_gme_batch_header.attribute27
451: ,l_gme_batch_header.attribute28
452: ,l_gme_batch_header.attribute29
453: ,l_gme_batch_header.attribute30
454: ,l_gme_batch_header.attribute31
455: ,l_gme_batch_header.attribute32
456: ,l_gme_batch_header.attribute33
449: ,l_gme_batch_header.attribute26
450: ,l_gme_batch_header.attribute27
451: ,l_gme_batch_header.attribute28
452: ,l_gme_batch_header.attribute29
453: ,l_gme_batch_header.attribute30
454: ,l_gme_batch_header.attribute31
455: ,l_gme_batch_header.attribute32
456: ,l_gme_batch_header.attribute33
457: ,l_gme_batch_header.attribute34
450: ,l_gme_batch_header.attribute27
451: ,l_gme_batch_header.attribute28
452: ,l_gme_batch_header.attribute29
453: ,l_gme_batch_header.attribute30
454: ,l_gme_batch_header.attribute31
455: ,l_gme_batch_header.attribute32
456: ,l_gme_batch_header.attribute33
457: ,l_gme_batch_header.attribute34
458: ,l_gme_batch_header.attribute35
451: ,l_gme_batch_header.attribute28
452: ,l_gme_batch_header.attribute29
453: ,l_gme_batch_header.attribute30
454: ,l_gme_batch_header.attribute31
455: ,l_gme_batch_header.attribute32
456: ,l_gme_batch_header.attribute33
457: ,l_gme_batch_header.attribute34
458: ,l_gme_batch_header.attribute35
459: ,l_gme_batch_header.attribute36
452: ,l_gme_batch_header.attribute29
453: ,l_gme_batch_header.attribute30
454: ,l_gme_batch_header.attribute31
455: ,l_gme_batch_header.attribute32
456: ,l_gme_batch_header.attribute33
457: ,l_gme_batch_header.attribute34
458: ,l_gme_batch_header.attribute35
459: ,l_gme_batch_header.attribute36
460: ,l_gme_batch_header.attribute37
453: ,l_gme_batch_header.attribute30
454: ,l_gme_batch_header.attribute31
455: ,l_gme_batch_header.attribute32
456: ,l_gme_batch_header.attribute33
457: ,l_gme_batch_header.attribute34
458: ,l_gme_batch_header.attribute35
459: ,l_gme_batch_header.attribute36
460: ,l_gme_batch_header.attribute37
461: ,l_gme_batch_header.attribute38
454: ,l_gme_batch_header.attribute31
455: ,l_gme_batch_header.attribute32
456: ,l_gme_batch_header.attribute33
457: ,l_gme_batch_header.attribute34
458: ,l_gme_batch_header.attribute35
459: ,l_gme_batch_header.attribute36
460: ,l_gme_batch_header.attribute37
461: ,l_gme_batch_header.attribute38
462: ,l_gme_batch_header.attribute39
455: ,l_gme_batch_header.attribute32
456: ,l_gme_batch_header.attribute33
457: ,l_gme_batch_header.attribute34
458: ,l_gme_batch_header.attribute35
459: ,l_gme_batch_header.attribute36
460: ,l_gme_batch_header.attribute37
461: ,l_gme_batch_header.attribute38
462: ,l_gme_batch_header.attribute39
463: ,l_gme_batch_header.attribute40
456: ,l_gme_batch_header.attribute33
457: ,l_gme_batch_header.attribute34
458: ,l_gme_batch_header.attribute35
459: ,l_gme_batch_header.attribute36
460: ,l_gme_batch_header.attribute37
461: ,l_gme_batch_header.attribute38
462: ,l_gme_batch_header.attribute39
463: ,l_gme_batch_header.attribute40
464: ,l_gme_batch_header.attribute_category
457: ,l_gme_batch_header.attribute34
458: ,l_gme_batch_header.attribute35
459: ,l_gme_batch_header.attribute36
460: ,l_gme_batch_header.attribute37
461: ,l_gme_batch_header.attribute38
462: ,l_gme_batch_header.attribute39
463: ,l_gme_batch_header.attribute40
464: ,l_gme_batch_header.attribute_category
465: ,l_gme_batch_header.automatic_step_calculation
458: ,l_gme_batch_header.attribute35
459: ,l_gme_batch_header.attribute36
460: ,l_gme_batch_header.attribute37
461: ,l_gme_batch_header.attribute38
462: ,l_gme_batch_header.attribute39
463: ,l_gme_batch_header.attribute40
464: ,l_gme_batch_header.attribute_category
465: ,l_gme_batch_header.automatic_step_calculation
466: ,l_gme_batch_header.firmed_ind
459: ,l_gme_batch_header.attribute36
460: ,l_gme_batch_header.attribute37
461: ,l_gme_batch_header.attribute38
462: ,l_gme_batch_header.attribute39
463: ,l_gme_batch_header.attribute40
464: ,l_gme_batch_header.attribute_category
465: ,l_gme_batch_header.automatic_step_calculation
466: ,l_gme_batch_header.firmed_ind
467: ,l_gme_batch_header.finite_scheduled_ind
460: ,l_gme_batch_header.attribute37
461: ,l_gme_batch_header.attribute38
462: ,l_gme_batch_header.attribute39
463: ,l_gme_batch_header.attribute40
464: ,l_gme_batch_header.attribute_category
465: ,l_gme_batch_header.automatic_step_calculation
466: ,l_gme_batch_header.firmed_ind
467: ,l_gme_batch_header.finite_scheduled_ind
468: ,l_gme_batch_header.order_priority
461: ,l_gme_batch_header.attribute38
462: ,l_gme_batch_header.attribute39
463: ,l_gme_batch_header.attribute40
464: ,l_gme_batch_header.attribute_category
465: ,l_gme_batch_header.automatic_step_calculation
466: ,l_gme_batch_header.firmed_ind
467: ,l_gme_batch_header.finite_scheduled_ind
468: ,l_gme_batch_header.order_priority
469: ,l_gme_batch_header.migrated_batch_ind
462: ,l_gme_batch_header.attribute39
463: ,l_gme_batch_header.attribute40
464: ,l_gme_batch_header.attribute_category
465: ,l_gme_batch_header.automatic_step_calculation
466: ,l_gme_batch_header.firmed_ind
467: ,l_gme_batch_header.finite_scheduled_ind
468: ,l_gme_batch_header.order_priority
469: ,l_gme_batch_header.migrated_batch_ind
470: ,l_gme_batch_header.enforce_step_dependency
463: ,l_gme_batch_header.attribute40
464: ,l_gme_batch_header.attribute_category
465: ,l_gme_batch_header.automatic_step_calculation
466: ,l_gme_batch_header.firmed_ind
467: ,l_gme_batch_header.finite_scheduled_ind
468: ,l_gme_batch_header.order_priority
469: ,l_gme_batch_header.migrated_batch_ind
470: ,l_gme_batch_header.enforce_step_dependency
471: ,l_gme_batch_header.terminated_ind
464: ,l_gme_batch_header.attribute_category
465: ,l_gme_batch_header.automatic_step_calculation
466: ,l_gme_batch_header.firmed_ind
467: ,l_gme_batch_header.finite_scheduled_ind
468: ,l_gme_batch_header.order_priority
469: ,l_gme_batch_header.migrated_batch_ind
470: ,l_gme_batch_header.enforce_step_dependency
471: ,l_gme_batch_header.terminated_ind
472: ,l_gme_batch_header.organization_id
465: ,l_gme_batch_header.automatic_step_calculation
466: ,l_gme_batch_header.firmed_ind
467: ,l_gme_batch_header.finite_scheduled_ind
468: ,l_gme_batch_header.order_priority
469: ,l_gme_batch_header.migrated_batch_ind
470: ,l_gme_batch_header.enforce_step_dependency
471: ,l_gme_batch_header.terminated_ind
472: ,l_gme_batch_header.organization_id
473: ,l_gme_batch_header.laboratory_ind
466: ,l_gme_batch_header.firmed_ind
467: ,l_gme_batch_header.finite_scheduled_ind
468: ,l_gme_batch_header.order_priority
469: ,l_gme_batch_header.migrated_batch_ind
470: ,l_gme_batch_header.enforce_step_dependency
471: ,l_gme_batch_header.terminated_ind
472: ,l_gme_batch_header.organization_id
473: ,l_gme_batch_header.laboratory_ind
474: ,l_gme_batch_header.enhanced_pi_ind
467: ,l_gme_batch_header.finite_scheduled_ind
468: ,l_gme_batch_header.order_priority
469: ,l_gme_batch_header.migrated_batch_ind
470: ,l_gme_batch_header.enforce_step_dependency
471: ,l_gme_batch_header.terminated_ind
472: ,l_gme_batch_header.organization_id
473: ,l_gme_batch_header.laboratory_ind
474: ,l_gme_batch_header.enhanced_pi_ind
475: ,l_gme_batch_header.move_order_header_id
468: ,l_gme_batch_header.order_priority
469: ,l_gme_batch_header.migrated_batch_ind
470: ,l_gme_batch_header.enforce_step_dependency
471: ,l_gme_batch_header.terminated_ind
472: ,l_gme_batch_header.organization_id
473: ,l_gme_batch_header.laboratory_ind
474: ,l_gme_batch_header.enhanced_pi_ind
475: ,l_gme_batch_header.move_order_header_id
476: ,l_gme_batch_header.terminate_reason_id
469: ,l_gme_batch_header.migrated_batch_ind
470: ,l_gme_batch_header.enforce_step_dependency
471: ,l_gme_batch_header.terminated_ind
472: ,l_gme_batch_header.organization_id
473: ,l_gme_batch_header.laboratory_ind
474: ,l_gme_batch_header.enhanced_pi_ind
475: ,l_gme_batch_header.move_order_header_id
476: ,l_gme_batch_header.terminate_reason_id
477: ,l_gme_batch_header.fixed_process_loss_applied
470: ,l_gme_batch_header.enforce_step_dependency
471: ,l_gme_batch_header.terminated_ind
472: ,l_gme_batch_header.organization_id
473: ,l_gme_batch_header.laboratory_ind
474: ,l_gme_batch_header.enhanced_pi_ind
475: ,l_gme_batch_header.move_order_header_id
476: ,l_gme_batch_header.terminate_reason_id
477: ,l_gme_batch_header.fixed_process_loss_applied
478: ,l_gme_batch_header.ja_osp_batch --Bug7616310
471: ,l_gme_batch_header.terminated_ind
472: ,l_gme_batch_header.organization_id
473: ,l_gme_batch_header.laboratory_ind
474: ,l_gme_batch_header.enhanced_pi_ind
475: ,l_gme_batch_header.move_order_header_id
476: ,l_gme_batch_header.terminate_reason_id
477: ,l_gme_batch_header.fixed_process_loss_applied
478: ,l_gme_batch_header.ja_osp_batch --Bug7616310
479: FROM gme_batch_header
472: ,l_gme_batch_header.organization_id
473: ,l_gme_batch_header.laboratory_ind
474: ,l_gme_batch_header.enhanced_pi_ind
475: ,l_gme_batch_header.move_order_header_id
476: ,l_gme_batch_header.terminate_reason_id
477: ,l_gme_batch_header.fixed_process_loss_applied
478: ,l_gme_batch_header.ja_osp_batch --Bug7616310
479: FROM gme_batch_header
480: WHERE batch_id = p_batch_header.batch_id;
473: ,l_gme_batch_header.laboratory_ind
474: ,l_gme_batch_header.enhanced_pi_ind
475: ,l_gme_batch_header.move_order_header_id
476: ,l_gme_batch_header.terminate_reason_id
477: ,l_gme_batch_header.fixed_process_loss_applied
478: ,l_gme_batch_header.ja_osp_batch --Bug7616310
479: FROM gme_batch_header
480: WHERE batch_id = p_batch_header.batch_id;
481: ELSIF (l_organization_id IS NOT NULL)
474: ,l_gme_batch_header.enhanced_pi_ind
475: ,l_gme_batch_header.move_order_header_id
476: ,l_gme_batch_header.terminate_reason_id
477: ,l_gme_batch_header.fixed_process_loss_applied
478: ,l_gme_batch_header.ja_osp_batch --Bug7616310
479: FROM gme_batch_header
480: WHERE batch_id = p_batch_header.batch_id;
481: ELSIF (l_organization_id IS NOT NULL)
482: AND (l_batch_no IS NOT NULL)
475: ,l_gme_batch_header.move_order_header_id
476: ,l_gme_batch_header.terminate_reason_id
477: ,l_gme_batch_header.fixed_process_loss_applied
478: ,l_gme_batch_header.ja_osp_batch --Bug7616310
479: FROM gme_batch_header
480: WHERE batch_id = p_batch_header.batch_id;
481: ELSIF (l_organization_id IS NOT NULL)
482: AND (l_batch_no IS NOT NULL)
483: AND (l_batch_type IS NOT NULL) THEN
567: ,move_order_header_id
568: ,terminate_reason_id
569: ,fixed_process_loss_applied
570: ,ja_osp_batch --Bug7616310
571: INTO l_gme_batch_header.batch_id
572: --, l_gme_batch_header.PLANT_CODE
573: , l_gme_batch_header.batch_no
574: ,l_gme_batch_header.batch_type, l_gme_batch_header.prod_id
575: ,l_gme_batch_header.prod_sequence
568: ,terminate_reason_id
569: ,fixed_process_loss_applied
570: ,ja_osp_batch --Bug7616310
571: INTO l_gme_batch_header.batch_id
572: --, l_gme_batch_header.PLANT_CODE
573: , l_gme_batch_header.batch_no
574: ,l_gme_batch_header.batch_type, l_gme_batch_header.prod_id
575: ,l_gme_batch_header.prod_sequence
576: ,l_gme_batch_header.recipe_validity_rule_id
569: ,fixed_process_loss_applied
570: ,ja_osp_batch --Bug7616310
571: INTO l_gme_batch_header.batch_id
572: --, l_gme_batch_header.PLANT_CODE
573: , l_gme_batch_header.batch_no
574: ,l_gme_batch_header.batch_type, l_gme_batch_header.prod_id
575: ,l_gme_batch_header.prod_sequence
576: ,l_gme_batch_header.recipe_validity_rule_id
577: ,l_gme_batch_header.formula_id
570: ,ja_osp_batch --Bug7616310
571: INTO l_gme_batch_header.batch_id
572: --, l_gme_batch_header.PLANT_CODE
573: , l_gme_batch_header.batch_no
574: ,l_gme_batch_header.batch_type, l_gme_batch_header.prod_id
575: ,l_gme_batch_header.prod_sequence
576: ,l_gme_batch_header.recipe_validity_rule_id
577: ,l_gme_batch_header.formula_id
578: ,l_gme_batch_header.routing_id
571: INTO l_gme_batch_header.batch_id
572: --, l_gme_batch_header.PLANT_CODE
573: , l_gme_batch_header.batch_no
574: ,l_gme_batch_header.batch_type, l_gme_batch_header.prod_id
575: ,l_gme_batch_header.prod_sequence
576: ,l_gme_batch_header.recipe_validity_rule_id
577: ,l_gme_batch_header.formula_id
578: ,l_gme_batch_header.routing_id
579: ,l_gme_batch_header.plan_start_date
572: --, l_gme_batch_header.PLANT_CODE
573: , l_gme_batch_header.batch_no
574: ,l_gme_batch_header.batch_type, l_gme_batch_header.prod_id
575: ,l_gme_batch_header.prod_sequence
576: ,l_gme_batch_header.recipe_validity_rule_id
577: ,l_gme_batch_header.formula_id
578: ,l_gme_batch_header.routing_id
579: ,l_gme_batch_header.plan_start_date
580: ,l_gme_batch_header.actual_start_date
573: , l_gme_batch_header.batch_no
574: ,l_gme_batch_header.batch_type, l_gme_batch_header.prod_id
575: ,l_gme_batch_header.prod_sequence
576: ,l_gme_batch_header.recipe_validity_rule_id
577: ,l_gme_batch_header.formula_id
578: ,l_gme_batch_header.routing_id
579: ,l_gme_batch_header.plan_start_date
580: ,l_gme_batch_header.actual_start_date
581: ,l_gme_batch_header.due_date
574: ,l_gme_batch_header.batch_type, l_gme_batch_header.prod_id
575: ,l_gme_batch_header.prod_sequence
576: ,l_gme_batch_header.recipe_validity_rule_id
577: ,l_gme_batch_header.formula_id
578: ,l_gme_batch_header.routing_id
579: ,l_gme_batch_header.plan_start_date
580: ,l_gme_batch_header.actual_start_date
581: ,l_gme_batch_header.due_date
582: ,l_gme_batch_header.plan_cmplt_date
575: ,l_gme_batch_header.prod_sequence
576: ,l_gme_batch_header.recipe_validity_rule_id
577: ,l_gme_batch_header.formula_id
578: ,l_gme_batch_header.routing_id
579: ,l_gme_batch_header.plan_start_date
580: ,l_gme_batch_header.actual_start_date
581: ,l_gme_batch_header.due_date
582: ,l_gme_batch_header.plan_cmplt_date
583: ,l_gme_batch_header.actual_cmplt_date
576: ,l_gme_batch_header.recipe_validity_rule_id
577: ,l_gme_batch_header.formula_id
578: ,l_gme_batch_header.routing_id
579: ,l_gme_batch_header.plan_start_date
580: ,l_gme_batch_header.actual_start_date
581: ,l_gme_batch_header.due_date
582: ,l_gme_batch_header.plan_cmplt_date
583: ,l_gme_batch_header.actual_cmplt_date
584: ,l_gme_batch_header.batch_status
577: ,l_gme_batch_header.formula_id
578: ,l_gme_batch_header.routing_id
579: ,l_gme_batch_header.plan_start_date
580: ,l_gme_batch_header.actual_start_date
581: ,l_gme_batch_header.due_date
582: ,l_gme_batch_header.plan_cmplt_date
583: ,l_gme_batch_header.actual_cmplt_date
584: ,l_gme_batch_header.batch_status
585: ,l_gme_batch_header.priority_value
578: ,l_gme_batch_header.routing_id
579: ,l_gme_batch_header.plan_start_date
580: ,l_gme_batch_header.actual_start_date
581: ,l_gme_batch_header.due_date
582: ,l_gme_batch_header.plan_cmplt_date
583: ,l_gme_batch_header.actual_cmplt_date
584: ,l_gme_batch_header.batch_status
585: ,l_gme_batch_header.priority_value
586: ,l_gme_batch_header.priority_code
579: ,l_gme_batch_header.plan_start_date
580: ,l_gme_batch_header.actual_start_date
581: ,l_gme_batch_header.due_date
582: ,l_gme_batch_header.plan_cmplt_date
583: ,l_gme_batch_header.actual_cmplt_date
584: ,l_gme_batch_header.batch_status
585: ,l_gme_batch_header.priority_value
586: ,l_gme_batch_header.priority_code
587: ,l_gme_batch_header.print_count
580: ,l_gme_batch_header.actual_start_date
581: ,l_gme_batch_header.due_date
582: ,l_gme_batch_header.plan_cmplt_date
583: ,l_gme_batch_header.actual_cmplt_date
584: ,l_gme_batch_header.batch_status
585: ,l_gme_batch_header.priority_value
586: ,l_gme_batch_header.priority_code
587: ,l_gme_batch_header.print_count
588: ,l_gme_batch_header.fmcontrol_class
581: ,l_gme_batch_header.due_date
582: ,l_gme_batch_header.plan_cmplt_date
583: ,l_gme_batch_header.actual_cmplt_date
584: ,l_gme_batch_header.batch_status
585: ,l_gme_batch_header.priority_value
586: ,l_gme_batch_header.priority_code
587: ,l_gme_batch_header.print_count
588: ,l_gme_batch_header.fmcontrol_class
589: --, l_gme_batch_header.WIP_WHSE_CODE
582: ,l_gme_batch_header.plan_cmplt_date
583: ,l_gme_batch_header.actual_cmplt_date
584: ,l_gme_batch_header.batch_status
585: ,l_gme_batch_header.priority_value
586: ,l_gme_batch_header.priority_code
587: ,l_gme_batch_header.print_count
588: ,l_gme_batch_header.fmcontrol_class
589: --, l_gme_batch_header.WIP_WHSE_CODE
590: , l_gme_batch_header.batch_close_date
583: ,l_gme_batch_header.actual_cmplt_date
584: ,l_gme_batch_header.batch_status
585: ,l_gme_batch_header.priority_value
586: ,l_gme_batch_header.priority_code
587: ,l_gme_batch_header.print_count
588: ,l_gme_batch_header.fmcontrol_class
589: --, l_gme_batch_header.WIP_WHSE_CODE
590: , l_gme_batch_header.batch_close_date
591: ,l_gme_batch_header.poc_ind
584: ,l_gme_batch_header.batch_status
585: ,l_gme_batch_header.priority_value
586: ,l_gme_batch_header.priority_code
587: ,l_gme_batch_header.print_count
588: ,l_gme_batch_header.fmcontrol_class
589: --, l_gme_batch_header.WIP_WHSE_CODE
590: , l_gme_batch_header.batch_close_date
591: ,l_gme_batch_header.poc_ind
592: ,l_gme_batch_header.actual_cost_ind
585: ,l_gme_batch_header.priority_value
586: ,l_gme_batch_header.priority_code
587: ,l_gme_batch_header.print_count
588: ,l_gme_batch_header.fmcontrol_class
589: --, l_gme_batch_header.WIP_WHSE_CODE
590: , l_gme_batch_header.batch_close_date
591: ,l_gme_batch_header.poc_ind
592: ,l_gme_batch_header.actual_cost_ind
593: ,l_gme_batch_header.gl_posted_ind
586: ,l_gme_batch_header.priority_code
587: ,l_gme_batch_header.print_count
588: ,l_gme_batch_header.fmcontrol_class
589: --, l_gme_batch_header.WIP_WHSE_CODE
590: , l_gme_batch_header.batch_close_date
591: ,l_gme_batch_header.poc_ind
592: ,l_gme_batch_header.actual_cost_ind
593: ,l_gme_batch_header.gl_posted_ind
594: ,l_gme_batch_header.update_inventory_ind
587: ,l_gme_batch_header.print_count
588: ,l_gme_batch_header.fmcontrol_class
589: --, l_gme_batch_header.WIP_WHSE_CODE
590: , l_gme_batch_header.batch_close_date
591: ,l_gme_batch_header.poc_ind
592: ,l_gme_batch_header.actual_cost_ind
593: ,l_gme_batch_header.gl_posted_ind
594: ,l_gme_batch_header.update_inventory_ind
595: ,l_gme_batch_header.last_update_date
588: ,l_gme_batch_header.fmcontrol_class
589: --, l_gme_batch_header.WIP_WHSE_CODE
590: , l_gme_batch_header.batch_close_date
591: ,l_gme_batch_header.poc_ind
592: ,l_gme_batch_header.actual_cost_ind
593: ,l_gme_batch_header.gl_posted_ind
594: ,l_gme_batch_header.update_inventory_ind
595: ,l_gme_batch_header.last_update_date
596: ,l_gme_batch_header.last_updated_by
589: --, l_gme_batch_header.WIP_WHSE_CODE
590: , l_gme_batch_header.batch_close_date
591: ,l_gme_batch_header.poc_ind
592: ,l_gme_batch_header.actual_cost_ind
593: ,l_gme_batch_header.gl_posted_ind
594: ,l_gme_batch_header.update_inventory_ind
595: ,l_gme_batch_header.last_update_date
596: ,l_gme_batch_header.last_updated_by
597: ,l_gme_batch_header.creation_date
590: , l_gme_batch_header.batch_close_date
591: ,l_gme_batch_header.poc_ind
592: ,l_gme_batch_header.actual_cost_ind
593: ,l_gme_batch_header.gl_posted_ind
594: ,l_gme_batch_header.update_inventory_ind
595: ,l_gme_batch_header.last_update_date
596: ,l_gme_batch_header.last_updated_by
597: ,l_gme_batch_header.creation_date
598: ,l_gme_batch_header.created_by
591: ,l_gme_batch_header.poc_ind
592: ,l_gme_batch_header.actual_cost_ind
593: ,l_gme_batch_header.gl_posted_ind
594: ,l_gme_batch_header.update_inventory_ind
595: ,l_gme_batch_header.last_update_date
596: ,l_gme_batch_header.last_updated_by
597: ,l_gme_batch_header.creation_date
598: ,l_gme_batch_header.created_by
599: ,l_gme_batch_header.last_update_login
592: ,l_gme_batch_header.actual_cost_ind
593: ,l_gme_batch_header.gl_posted_ind
594: ,l_gme_batch_header.update_inventory_ind
595: ,l_gme_batch_header.last_update_date
596: ,l_gme_batch_header.last_updated_by
597: ,l_gme_batch_header.creation_date
598: ,l_gme_batch_header.created_by
599: ,l_gme_batch_header.last_update_login
600: ,l_gme_batch_header.delete_mark
593: ,l_gme_batch_header.gl_posted_ind
594: ,l_gme_batch_header.update_inventory_ind
595: ,l_gme_batch_header.last_update_date
596: ,l_gme_batch_header.last_updated_by
597: ,l_gme_batch_header.creation_date
598: ,l_gme_batch_header.created_by
599: ,l_gme_batch_header.last_update_login
600: ,l_gme_batch_header.delete_mark
601: ,l_gme_batch_header.text_code
594: ,l_gme_batch_header.update_inventory_ind
595: ,l_gme_batch_header.last_update_date
596: ,l_gme_batch_header.last_updated_by
597: ,l_gme_batch_header.creation_date
598: ,l_gme_batch_header.created_by
599: ,l_gme_batch_header.last_update_login
600: ,l_gme_batch_header.delete_mark
601: ,l_gme_batch_header.text_code
602: ,l_gme_batch_header.parentline_id, l_gme_batch_header.fpo_id
595: ,l_gme_batch_header.last_update_date
596: ,l_gme_batch_header.last_updated_by
597: ,l_gme_batch_header.creation_date
598: ,l_gme_batch_header.created_by
599: ,l_gme_batch_header.last_update_login
600: ,l_gme_batch_header.delete_mark
601: ,l_gme_batch_header.text_code
602: ,l_gme_batch_header.parentline_id, l_gme_batch_header.fpo_id
603: ,l_gme_batch_header.attribute1
596: ,l_gme_batch_header.last_updated_by
597: ,l_gme_batch_header.creation_date
598: ,l_gme_batch_header.created_by
599: ,l_gme_batch_header.last_update_login
600: ,l_gme_batch_header.delete_mark
601: ,l_gme_batch_header.text_code
602: ,l_gme_batch_header.parentline_id, l_gme_batch_header.fpo_id
603: ,l_gme_batch_header.attribute1
604: ,l_gme_batch_header.attribute2
597: ,l_gme_batch_header.creation_date
598: ,l_gme_batch_header.created_by
599: ,l_gme_batch_header.last_update_login
600: ,l_gme_batch_header.delete_mark
601: ,l_gme_batch_header.text_code
602: ,l_gme_batch_header.parentline_id, l_gme_batch_header.fpo_id
603: ,l_gme_batch_header.attribute1
604: ,l_gme_batch_header.attribute2
605: ,l_gme_batch_header.attribute3
598: ,l_gme_batch_header.created_by
599: ,l_gme_batch_header.last_update_login
600: ,l_gme_batch_header.delete_mark
601: ,l_gme_batch_header.text_code
602: ,l_gme_batch_header.parentline_id, l_gme_batch_header.fpo_id
603: ,l_gme_batch_header.attribute1
604: ,l_gme_batch_header.attribute2
605: ,l_gme_batch_header.attribute3
606: ,l_gme_batch_header.attribute4
599: ,l_gme_batch_header.last_update_login
600: ,l_gme_batch_header.delete_mark
601: ,l_gme_batch_header.text_code
602: ,l_gme_batch_header.parentline_id, l_gme_batch_header.fpo_id
603: ,l_gme_batch_header.attribute1
604: ,l_gme_batch_header.attribute2
605: ,l_gme_batch_header.attribute3
606: ,l_gme_batch_header.attribute4
607: ,l_gme_batch_header.attribute5
600: ,l_gme_batch_header.delete_mark
601: ,l_gme_batch_header.text_code
602: ,l_gme_batch_header.parentline_id, l_gme_batch_header.fpo_id
603: ,l_gme_batch_header.attribute1
604: ,l_gme_batch_header.attribute2
605: ,l_gme_batch_header.attribute3
606: ,l_gme_batch_header.attribute4
607: ,l_gme_batch_header.attribute5
608: ,l_gme_batch_header.attribute6
601: ,l_gme_batch_header.text_code
602: ,l_gme_batch_header.parentline_id, l_gme_batch_header.fpo_id
603: ,l_gme_batch_header.attribute1
604: ,l_gme_batch_header.attribute2
605: ,l_gme_batch_header.attribute3
606: ,l_gme_batch_header.attribute4
607: ,l_gme_batch_header.attribute5
608: ,l_gme_batch_header.attribute6
609: ,l_gme_batch_header.attribute7
602: ,l_gme_batch_header.parentline_id, l_gme_batch_header.fpo_id
603: ,l_gme_batch_header.attribute1
604: ,l_gme_batch_header.attribute2
605: ,l_gme_batch_header.attribute3
606: ,l_gme_batch_header.attribute4
607: ,l_gme_batch_header.attribute5
608: ,l_gme_batch_header.attribute6
609: ,l_gme_batch_header.attribute7
610: ,l_gme_batch_header.attribute8
603: ,l_gme_batch_header.attribute1
604: ,l_gme_batch_header.attribute2
605: ,l_gme_batch_header.attribute3
606: ,l_gme_batch_header.attribute4
607: ,l_gme_batch_header.attribute5
608: ,l_gme_batch_header.attribute6
609: ,l_gme_batch_header.attribute7
610: ,l_gme_batch_header.attribute8
611: ,l_gme_batch_header.attribute9
604: ,l_gme_batch_header.attribute2
605: ,l_gme_batch_header.attribute3
606: ,l_gme_batch_header.attribute4
607: ,l_gme_batch_header.attribute5
608: ,l_gme_batch_header.attribute6
609: ,l_gme_batch_header.attribute7
610: ,l_gme_batch_header.attribute8
611: ,l_gme_batch_header.attribute9
612: ,l_gme_batch_header.attribute10
605: ,l_gme_batch_header.attribute3
606: ,l_gme_batch_header.attribute4
607: ,l_gme_batch_header.attribute5
608: ,l_gme_batch_header.attribute6
609: ,l_gme_batch_header.attribute7
610: ,l_gme_batch_header.attribute8
611: ,l_gme_batch_header.attribute9
612: ,l_gme_batch_header.attribute10
613: ,l_gme_batch_header.attribute11
606: ,l_gme_batch_header.attribute4
607: ,l_gme_batch_header.attribute5
608: ,l_gme_batch_header.attribute6
609: ,l_gme_batch_header.attribute7
610: ,l_gme_batch_header.attribute8
611: ,l_gme_batch_header.attribute9
612: ,l_gme_batch_header.attribute10
613: ,l_gme_batch_header.attribute11
614: ,l_gme_batch_header.attribute12
607: ,l_gme_batch_header.attribute5
608: ,l_gme_batch_header.attribute6
609: ,l_gme_batch_header.attribute7
610: ,l_gme_batch_header.attribute8
611: ,l_gme_batch_header.attribute9
612: ,l_gme_batch_header.attribute10
613: ,l_gme_batch_header.attribute11
614: ,l_gme_batch_header.attribute12
615: ,l_gme_batch_header.attribute13
608: ,l_gme_batch_header.attribute6
609: ,l_gme_batch_header.attribute7
610: ,l_gme_batch_header.attribute8
611: ,l_gme_batch_header.attribute9
612: ,l_gme_batch_header.attribute10
613: ,l_gme_batch_header.attribute11
614: ,l_gme_batch_header.attribute12
615: ,l_gme_batch_header.attribute13
616: ,l_gme_batch_header.attribute14
609: ,l_gme_batch_header.attribute7
610: ,l_gme_batch_header.attribute8
611: ,l_gme_batch_header.attribute9
612: ,l_gme_batch_header.attribute10
613: ,l_gme_batch_header.attribute11
614: ,l_gme_batch_header.attribute12
615: ,l_gme_batch_header.attribute13
616: ,l_gme_batch_header.attribute14
617: ,l_gme_batch_header.attribute15
610: ,l_gme_batch_header.attribute8
611: ,l_gme_batch_header.attribute9
612: ,l_gme_batch_header.attribute10
613: ,l_gme_batch_header.attribute11
614: ,l_gme_batch_header.attribute12
615: ,l_gme_batch_header.attribute13
616: ,l_gme_batch_header.attribute14
617: ,l_gme_batch_header.attribute15
618: ,l_gme_batch_header.attribute16
611: ,l_gme_batch_header.attribute9
612: ,l_gme_batch_header.attribute10
613: ,l_gme_batch_header.attribute11
614: ,l_gme_batch_header.attribute12
615: ,l_gme_batch_header.attribute13
616: ,l_gme_batch_header.attribute14
617: ,l_gme_batch_header.attribute15
618: ,l_gme_batch_header.attribute16
619: ,l_gme_batch_header.attribute17
612: ,l_gme_batch_header.attribute10
613: ,l_gme_batch_header.attribute11
614: ,l_gme_batch_header.attribute12
615: ,l_gme_batch_header.attribute13
616: ,l_gme_batch_header.attribute14
617: ,l_gme_batch_header.attribute15
618: ,l_gme_batch_header.attribute16
619: ,l_gme_batch_header.attribute17
620: ,l_gme_batch_header.attribute18
613: ,l_gme_batch_header.attribute11
614: ,l_gme_batch_header.attribute12
615: ,l_gme_batch_header.attribute13
616: ,l_gme_batch_header.attribute14
617: ,l_gme_batch_header.attribute15
618: ,l_gme_batch_header.attribute16
619: ,l_gme_batch_header.attribute17
620: ,l_gme_batch_header.attribute18
621: ,l_gme_batch_header.attribute19
614: ,l_gme_batch_header.attribute12
615: ,l_gme_batch_header.attribute13
616: ,l_gme_batch_header.attribute14
617: ,l_gme_batch_header.attribute15
618: ,l_gme_batch_header.attribute16
619: ,l_gme_batch_header.attribute17
620: ,l_gme_batch_header.attribute18
621: ,l_gme_batch_header.attribute19
622: ,l_gme_batch_header.attribute20
615: ,l_gme_batch_header.attribute13
616: ,l_gme_batch_header.attribute14
617: ,l_gme_batch_header.attribute15
618: ,l_gme_batch_header.attribute16
619: ,l_gme_batch_header.attribute17
620: ,l_gme_batch_header.attribute18
621: ,l_gme_batch_header.attribute19
622: ,l_gme_batch_header.attribute20
623: ,l_gme_batch_header.attribute21
616: ,l_gme_batch_header.attribute14
617: ,l_gme_batch_header.attribute15
618: ,l_gme_batch_header.attribute16
619: ,l_gme_batch_header.attribute17
620: ,l_gme_batch_header.attribute18
621: ,l_gme_batch_header.attribute19
622: ,l_gme_batch_header.attribute20
623: ,l_gme_batch_header.attribute21
624: ,l_gme_batch_header.attribute22
617: ,l_gme_batch_header.attribute15
618: ,l_gme_batch_header.attribute16
619: ,l_gme_batch_header.attribute17
620: ,l_gme_batch_header.attribute18
621: ,l_gme_batch_header.attribute19
622: ,l_gme_batch_header.attribute20
623: ,l_gme_batch_header.attribute21
624: ,l_gme_batch_header.attribute22
625: ,l_gme_batch_header.attribute23
618: ,l_gme_batch_header.attribute16
619: ,l_gme_batch_header.attribute17
620: ,l_gme_batch_header.attribute18
621: ,l_gme_batch_header.attribute19
622: ,l_gme_batch_header.attribute20
623: ,l_gme_batch_header.attribute21
624: ,l_gme_batch_header.attribute22
625: ,l_gme_batch_header.attribute23
626: ,l_gme_batch_header.attribute24
619: ,l_gme_batch_header.attribute17
620: ,l_gme_batch_header.attribute18
621: ,l_gme_batch_header.attribute19
622: ,l_gme_batch_header.attribute20
623: ,l_gme_batch_header.attribute21
624: ,l_gme_batch_header.attribute22
625: ,l_gme_batch_header.attribute23
626: ,l_gme_batch_header.attribute24
627: ,l_gme_batch_header.attribute25
620: ,l_gme_batch_header.attribute18
621: ,l_gme_batch_header.attribute19
622: ,l_gme_batch_header.attribute20
623: ,l_gme_batch_header.attribute21
624: ,l_gme_batch_header.attribute22
625: ,l_gme_batch_header.attribute23
626: ,l_gme_batch_header.attribute24
627: ,l_gme_batch_header.attribute25
628: ,l_gme_batch_header.attribute26
621: ,l_gme_batch_header.attribute19
622: ,l_gme_batch_header.attribute20
623: ,l_gme_batch_header.attribute21
624: ,l_gme_batch_header.attribute22
625: ,l_gme_batch_header.attribute23
626: ,l_gme_batch_header.attribute24
627: ,l_gme_batch_header.attribute25
628: ,l_gme_batch_header.attribute26
629: ,l_gme_batch_header.attribute27
622: ,l_gme_batch_header.attribute20
623: ,l_gme_batch_header.attribute21
624: ,l_gme_batch_header.attribute22
625: ,l_gme_batch_header.attribute23
626: ,l_gme_batch_header.attribute24
627: ,l_gme_batch_header.attribute25
628: ,l_gme_batch_header.attribute26
629: ,l_gme_batch_header.attribute27
630: ,l_gme_batch_header.attribute28
623: ,l_gme_batch_header.attribute21
624: ,l_gme_batch_header.attribute22
625: ,l_gme_batch_header.attribute23
626: ,l_gme_batch_header.attribute24
627: ,l_gme_batch_header.attribute25
628: ,l_gme_batch_header.attribute26
629: ,l_gme_batch_header.attribute27
630: ,l_gme_batch_header.attribute28
631: ,l_gme_batch_header.attribute29
624: ,l_gme_batch_header.attribute22
625: ,l_gme_batch_header.attribute23
626: ,l_gme_batch_header.attribute24
627: ,l_gme_batch_header.attribute25
628: ,l_gme_batch_header.attribute26
629: ,l_gme_batch_header.attribute27
630: ,l_gme_batch_header.attribute28
631: ,l_gme_batch_header.attribute29
632: ,l_gme_batch_header.attribute30
625: ,l_gme_batch_header.attribute23
626: ,l_gme_batch_header.attribute24
627: ,l_gme_batch_header.attribute25
628: ,l_gme_batch_header.attribute26
629: ,l_gme_batch_header.attribute27
630: ,l_gme_batch_header.attribute28
631: ,l_gme_batch_header.attribute29
632: ,l_gme_batch_header.attribute30
633: ,l_gme_batch_header.attribute31
626: ,l_gme_batch_header.attribute24
627: ,l_gme_batch_header.attribute25
628: ,l_gme_batch_header.attribute26
629: ,l_gme_batch_header.attribute27
630: ,l_gme_batch_header.attribute28
631: ,l_gme_batch_header.attribute29
632: ,l_gme_batch_header.attribute30
633: ,l_gme_batch_header.attribute31
634: ,l_gme_batch_header.attribute32
627: ,l_gme_batch_header.attribute25
628: ,l_gme_batch_header.attribute26
629: ,l_gme_batch_header.attribute27
630: ,l_gme_batch_header.attribute28
631: ,l_gme_batch_header.attribute29
632: ,l_gme_batch_header.attribute30
633: ,l_gme_batch_header.attribute31
634: ,l_gme_batch_header.attribute32
635: ,l_gme_batch_header.attribute33
628: ,l_gme_batch_header.attribute26
629: ,l_gme_batch_header.attribute27
630: ,l_gme_batch_header.attribute28
631: ,l_gme_batch_header.attribute29
632: ,l_gme_batch_header.attribute30
633: ,l_gme_batch_header.attribute31
634: ,l_gme_batch_header.attribute32
635: ,l_gme_batch_header.attribute33
636: ,l_gme_batch_header.attribute34
629: ,l_gme_batch_header.attribute27
630: ,l_gme_batch_header.attribute28
631: ,l_gme_batch_header.attribute29
632: ,l_gme_batch_header.attribute30
633: ,l_gme_batch_header.attribute31
634: ,l_gme_batch_header.attribute32
635: ,l_gme_batch_header.attribute33
636: ,l_gme_batch_header.attribute34
637: ,l_gme_batch_header.attribute35
630: ,l_gme_batch_header.attribute28
631: ,l_gme_batch_header.attribute29
632: ,l_gme_batch_header.attribute30
633: ,l_gme_batch_header.attribute31
634: ,l_gme_batch_header.attribute32
635: ,l_gme_batch_header.attribute33
636: ,l_gme_batch_header.attribute34
637: ,l_gme_batch_header.attribute35
638: ,l_gme_batch_header.attribute36
631: ,l_gme_batch_header.attribute29
632: ,l_gme_batch_header.attribute30
633: ,l_gme_batch_header.attribute31
634: ,l_gme_batch_header.attribute32
635: ,l_gme_batch_header.attribute33
636: ,l_gme_batch_header.attribute34
637: ,l_gme_batch_header.attribute35
638: ,l_gme_batch_header.attribute36
639: ,l_gme_batch_header.attribute37
632: ,l_gme_batch_header.attribute30
633: ,l_gme_batch_header.attribute31
634: ,l_gme_batch_header.attribute32
635: ,l_gme_batch_header.attribute33
636: ,l_gme_batch_header.attribute34
637: ,l_gme_batch_header.attribute35
638: ,l_gme_batch_header.attribute36
639: ,l_gme_batch_header.attribute37
640: ,l_gme_batch_header.attribute38
633: ,l_gme_batch_header.attribute31
634: ,l_gme_batch_header.attribute32
635: ,l_gme_batch_header.attribute33
636: ,l_gme_batch_header.attribute34
637: ,l_gme_batch_header.attribute35
638: ,l_gme_batch_header.attribute36
639: ,l_gme_batch_header.attribute37
640: ,l_gme_batch_header.attribute38
641: ,l_gme_batch_header.attribute39
634: ,l_gme_batch_header.attribute32
635: ,l_gme_batch_header.attribute33
636: ,l_gme_batch_header.attribute34
637: ,l_gme_batch_header.attribute35
638: ,l_gme_batch_header.attribute36
639: ,l_gme_batch_header.attribute37
640: ,l_gme_batch_header.attribute38
641: ,l_gme_batch_header.attribute39
642: ,l_gme_batch_header.attribute40
635: ,l_gme_batch_header.attribute33
636: ,l_gme_batch_header.attribute34
637: ,l_gme_batch_header.attribute35
638: ,l_gme_batch_header.attribute36
639: ,l_gme_batch_header.attribute37
640: ,l_gme_batch_header.attribute38
641: ,l_gme_batch_header.attribute39
642: ,l_gme_batch_header.attribute40
643: ,l_gme_batch_header.attribute_category
636: ,l_gme_batch_header.attribute34
637: ,l_gme_batch_header.attribute35
638: ,l_gme_batch_header.attribute36
639: ,l_gme_batch_header.attribute37
640: ,l_gme_batch_header.attribute38
641: ,l_gme_batch_header.attribute39
642: ,l_gme_batch_header.attribute40
643: ,l_gme_batch_header.attribute_category
644: ,l_gme_batch_header.automatic_step_calculation
637: ,l_gme_batch_header.attribute35
638: ,l_gme_batch_header.attribute36
639: ,l_gme_batch_header.attribute37
640: ,l_gme_batch_header.attribute38
641: ,l_gme_batch_header.attribute39
642: ,l_gme_batch_header.attribute40
643: ,l_gme_batch_header.attribute_category
644: ,l_gme_batch_header.automatic_step_calculation
645: ,l_gme_batch_header.firmed_ind
638: ,l_gme_batch_header.attribute36
639: ,l_gme_batch_header.attribute37
640: ,l_gme_batch_header.attribute38
641: ,l_gme_batch_header.attribute39
642: ,l_gme_batch_header.attribute40
643: ,l_gme_batch_header.attribute_category
644: ,l_gme_batch_header.automatic_step_calculation
645: ,l_gme_batch_header.firmed_ind
646: ,l_gme_batch_header.finite_scheduled_ind
639: ,l_gme_batch_header.attribute37
640: ,l_gme_batch_header.attribute38
641: ,l_gme_batch_header.attribute39
642: ,l_gme_batch_header.attribute40
643: ,l_gme_batch_header.attribute_category
644: ,l_gme_batch_header.automatic_step_calculation
645: ,l_gme_batch_header.firmed_ind
646: ,l_gme_batch_header.finite_scheduled_ind
647: ,l_gme_batch_header.order_priority
640: ,l_gme_batch_header.attribute38
641: ,l_gme_batch_header.attribute39
642: ,l_gme_batch_header.attribute40
643: ,l_gme_batch_header.attribute_category
644: ,l_gme_batch_header.automatic_step_calculation
645: ,l_gme_batch_header.firmed_ind
646: ,l_gme_batch_header.finite_scheduled_ind
647: ,l_gme_batch_header.order_priority
648: ,l_gme_batch_header.migrated_batch_ind
641: ,l_gme_batch_header.attribute39
642: ,l_gme_batch_header.attribute40
643: ,l_gme_batch_header.attribute_category
644: ,l_gme_batch_header.automatic_step_calculation
645: ,l_gme_batch_header.firmed_ind
646: ,l_gme_batch_header.finite_scheduled_ind
647: ,l_gme_batch_header.order_priority
648: ,l_gme_batch_header.migrated_batch_ind
649: ,l_gme_batch_header.enforce_step_dependency
642: ,l_gme_batch_header.attribute40
643: ,l_gme_batch_header.attribute_category
644: ,l_gme_batch_header.automatic_step_calculation
645: ,l_gme_batch_header.firmed_ind
646: ,l_gme_batch_header.finite_scheduled_ind
647: ,l_gme_batch_header.order_priority
648: ,l_gme_batch_header.migrated_batch_ind
649: ,l_gme_batch_header.enforce_step_dependency
650: ,l_gme_batch_header.terminated_ind
643: ,l_gme_batch_header.attribute_category
644: ,l_gme_batch_header.automatic_step_calculation
645: ,l_gme_batch_header.firmed_ind
646: ,l_gme_batch_header.finite_scheduled_ind
647: ,l_gme_batch_header.order_priority
648: ,l_gme_batch_header.migrated_batch_ind
649: ,l_gme_batch_header.enforce_step_dependency
650: ,l_gme_batch_header.terminated_ind
651: ,l_gme_batch_header.organization_id
644: ,l_gme_batch_header.automatic_step_calculation
645: ,l_gme_batch_header.firmed_ind
646: ,l_gme_batch_header.finite_scheduled_ind
647: ,l_gme_batch_header.order_priority
648: ,l_gme_batch_header.migrated_batch_ind
649: ,l_gme_batch_header.enforce_step_dependency
650: ,l_gme_batch_header.terminated_ind
651: ,l_gme_batch_header.organization_id
652: ,l_gme_batch_header.laboratory_ind
645: ,l_gme_batch_header.firmed_ind
646: ,l_gme_batch_header.finite_scheduled_ind
647: ,l_gme_batch_header.order_priority
648: ,l_gme_batch_header.migrated_batch_ind
649: ,l_gme_batch_header.enforce_step_dependency
650: ,l_gme_batch_header.terminated_ind
651: ,l_gme_batch_header.organization_id
652: ,l_gme_batch_header.laboratory_ind
653: ,l_gme_batch_header.enhanced_pi_ind
646: ,l_gme_batch_header.finite_scheduled_ind
647: ,l_gme_batch_header.order_priority
648: ,l_gme_batch_header.migrated_batch_ind
649: ,l_gme_batch_header.enforce_step_dependency
650: ,l_gme_batch_header.terminated_ind
651: ,l_gme_batch_header.organization_id
652: ,l_gme_batch_header.laboratory_ind
653: ,l_gme_batch_header.enhanced_pi_ind
654: ,l_gme_batch_header.move_order_header_id
647: ,l_gme_batch_header.order_priority
648: ,l_gme_batch_header.migrated_batch_ind
649: ,l_gme_batch_header.enforce_step_dependency
650: ,l_gme_batch_header.terminated_ind
651: ,l_gme_batch_header.organization_id
652: ,l_gme_batch_header.laboratory_ind
653: ,l_gme_batch_header.enhanced_pi_ind
654: ,l_gme_batch_header.move_order_header_id
655: ,l_gme_batch_header.terminate_reason_id
648: ,l_gme_batch_header.migrated_batch_ind
649: ,l_gme_batch_header.enforce_step_dependency
650: ,l_gme_batch_header.terminated_ind
651: ,l_gme_batch_header.organization_id
652: ,l_gme_batch_header.laboratory_ind
653: ,l_gme_batch_header.enhanced_pi_ind
654: ,l_gme_batch_header.move_order_header_id
655: ,l_gme_batch_header.terminate_reason_id
656: ,l_gme_batch_header.fixed_process_loss_applied
649: ,l_gme_batch_header.enforce_step_dependency
650: ,l_gme_batch_header.terminated_ind
651: ,l_gme_batch_header.organization_id
652: ,l_gme_batch_header.laboratory_ind
653: ,l_gme_batch_header.enhanced_pi_ind
654: ,l_gme_batch_header.move_order_header_id
655: ,l_gme_batch_header.terminate_reason_id
656: ,l_gme_batch_header.fixed_process_loss_applied
657: ,l_gme_batch_header.ja_osp_batch --Bug7616310
650: ,l_gme_batch_header.terminated_ind
651: ,l_gme_batch_header.organization_id
652: ,l_gme_batch_header.laboratory_ind
653: ,l_gme_batch_header.enhanced_pi_ind
654: ,l_gme_batch_header.move_order_header_id
655: ,l_gme_batch_header.terminate_reason_id
656: ,l_gme_batch_header.fixed_process_loss_applied
657: ,l_gme_batch_header.ja_osp_batch --Bug7616310
658: FROM gme_batch_header
651: ,l_gme_batch_header.organization_id
652: ,l_gme_batch_header.laboratory_ind
653: ,l_gme_batch_header.enhanced_pi_ind
654: ,l_gme_batch_header.move_order_header_id
655: ,l_gme_batch_header.terminate_reason_id
656: ,l_gme_batch_header.fixed_process_loss_applied
657: ,l_gme_batch_header.ja_osp_batch --Bug7616310
658: FROM gme_batch_header
659: WHERE organization_id = p_batch_header.organization_id
652: ,l_gme_batch_header.laboratory_ind
653: ,l_gme_batch_header.enhanced_pi_ind
654: ,l_gme_batch_header.move_order_header_id
655: ,l_gme_batch_header.terminate_reason_id
656: ,l_gme_batch_header.fixed_process_loss_applied
657: ,l_gme_batch_header.ja_osp_batch --Bug7616310
658: FROM gme_batch_header
659: WHERE organization_id = p_batch_header.organization_id
660: AND batch_no = p_batch_header.batch_no
653: ,l_gme_batch_header.enhanced_pi_ind
654: ,l_gme_batch_header.move_order_header_id
655: ,l_gme_batch_header.terminate_reason_id
656: ,l_gme_batch_header.fixed_process_loss_applied
657: ,l_gme_batch_header.ja_osp_batch --Bug7616310
658: FROM gme_batch_header
659: WHERE organization_id = p_batch_header.organization_id
660: AND batch_no = p_batch_header.batch_no
661: AND batch_type = p_batch_header.batch_type;
654: ,l_gme_batch_header.move_order_header_id
655: ,l_gme_batch_header.terminate_reason_id
656: ,l_gme_batch_header.fixed_process_loss_applied
657: ,l_gme_batch_header.ja_osp_batch --Bug7616310
658: FROM gme_batch_header
659: WHERE organization_id = p_batch_header.organization_id
660: AND batch_no = p_batch_header.batch_no
661: AND batch_type = p_batch_header.batch_type;
662: ELSE
669: IF g_debug <= gme_debug.g_log_procedure THEN
670: gme_debug.put_line ('Exiting api ' || g_pkg_name || '.' || l_api_name);
671: END IF;
672:
673: x_batch_header := l_gme_batch_header;
674: RETURN TRUE;
675: EXCEPTION
676: WHEN NO_DATA_FOUND THEN
677: gme_common_pvt.log_message ('GME_NO_DATA_FOUND'
700: | TYPE |
701: | Private |
702: | |
703: | USAGE |
704: | delete_Row will delete a row in gme_batch_header |
705: | |
706: | |
707: | DESCRIPTION |
708: | delete_row will delete a row in gme_batch_header |
704: | delete_Row will delete a row in gme_batch_header |
705: | |
706: | |
707: | DESCRIPTION |
708: | delete_row will delete a row in gme_batch_header |
709: | |
710: | |
711: | PARAMETERS |
712: | p_batch_header IN gme_batch_header%ROWTYPE |
708: | delete_row will delete a row in gme_batch_header |
709: | |
710: | |
711: | PARAMETERS |
712: | p_batch_header IN gme_batch_header%ROWTYPE |
713: | RETURNS |
714: | BOOLEAN |
715: | |
716: | HISTORY |
717: |
718: +==========================================================================+
719: Api end of comments
720: */
721: FUNCTION delete_row (p_batch_header IN gme_batch_header%ROWTYPE)
722: RETURN BOOLEAN
723: IS
724: l_gme_batch_header gme_batch_header%ROWTYPE;
725: l_batch_id NUMBER;
720: */
721: FUNCTION delete_row (p_batch_header IN gme_batch_header%ROWTYPE)
722: RETURN BOOLEAN
723: IS
724: l_gme_batch_header gme_batch_header%ROWTYPE;
725: l_batch_id NUMBER;
726: l_organization_id NUMBER;
727: l_batch_no VARCHAR2 (32);
728: l_batch_type NUMBER (5);
743:
744: IF l_batch_id IS NOT NULL THEN
745: SELECT 1
746: INTO l_dummy
747: FROM gme_batch_header
748: WHERE batch_id = l_batch_id
749: FOR UPDATE NOWAIT;
750:
751: UPDATE gme_batch_header
747: FROM gme_batch_header
748: WHERE batch_id = l_batch_id
749: FOR UPDATE NOWAIT;
750:
751: UPDATE gme_batch_header
752: SET delete_mark = 1
753: WHERE batch_id = p_batch_header.batch_id;
754: ELSIF (l_organization_id IS NOT NULL)
755: AND (l_batch_no IS NOT NULL)
755: AND (l_batch_no IS NOT NULL)
756: AND (l_batch_type IS NOT NULL) THEN
757: SELECT 1
758: INTO l_dummy
759: FROM gme_batch_header
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
763: FOR UPDATE NOWAIT;
761: AND batch_no = p_batch_header.batch_no
762: AND batch_type = p_batch_header.batch_type
763: FOR UPDATE NOWAIT;
764:
765: UPDATE gme_batch_header
766: SET delete_mark = 1
767: WHERE organization_id = p_batch_header.organization_id
768: AND batch_no = p_batch_header.batch_no
769: AND batch_type = p_batch_header.batch_type;
827: | TYPE |
828: | Private |
829: | |
830: | USAGE |
831: | update_row will update a row in gme_batch_header |
832: | |
833: | |
834: | DESCRIPTION |
835: | update_row will update a row in gme_batch_header |
831: | update_row will update a row in gme_batch_header |
832: | |
833: | |
834: | DESCRIPTION |
835: | update_row will update a row in gme_batch_header |
836: | |
837: | |
838: | PARAMETERS |
839: | p_batch_header IN gme_batch_header%ROWTYPE |
835: | update_row will update a row in gme_batch_header |
836: | |
837: | |
838: | PARAMETERS |
839: | p_batch_header IN gme_batch_header%ROWTYPE |
840: | RETURNS |
841: | BOOLEAN |
842: | |
843: | HISTORY |
845: | |
846: +==========================================================================+
847: Api end of comments
848: */
849: FUNCTION update_row (p_batch_header IN gme_batch_header%ROWTYPE)
850: RETURN BOOLEAN
851: IS
852: l_dummy NUMBER := 0;
853: l_batch_id NUMBER;
881:
882: IF l_batch_id IS NOT NULL THEN
883: SELECT 1
884: INTO l_dummy
885: FROM gme_batch_header
886: WHERE batch_id = l_batch_id
887: FOR UPDATE NOWAIT;
888:
889: UPDATE gme_batch_header
885: FROM gme_batch_header
886: WHERE batch_id = l_batch_id
887: FOR UPDATE NOWAIT;
888:
889: UPDATE gme_batch_header
890: SET recipe_validity_rule_id =
891: p_batch_header.recipe_validity_rule_id
892: ,formula_id = p_batch_header.formula_id
893: ,routing_id = p_batch_header.routing_id
973: AND (l_batch_no IS NOT NULL)
974: AND (l_batch_type IS NOT NULL) THEN
975: SELECT 1
976: INTO l_dummy
977: FROM gme_batch_header
978: WHERE organization_id = p_batch_header.organization_id
979: AND batch_no = p_batch_header.batch_no
980: AND batch_type = p_batch_header.batch_type
981: FOR UPDATE NOWAIT;
979: AND batch_no = p_batch_header.batch_no
980: AND batch_type = p_batch_header.batch_type
981: FOR UPDATE NOWAIT;
982:
983: UPDATE gme_batch_header
984: SET organization_id = p_batch_header.organization_id
985: ,batch_no = p_batch_header.batch_no
986: ,batch_type = p_batch_header.batch_type
987: ,prod_id = p_batch_header.prod_id
1133: |
1134: | TYPE
1135: | Private
1136: | USAGE
1137: | Lock_Row will lock a row in gme_batch_header
1138: |
1139: |
1140: | DESCRIPTION
1141: | Lock_Row will lock a row in gme_batch_header
1137: | Lock_Row will lock a row in gme_batch_header
1138: |
1139: |
1140: | DESCRIPTION
1141: | Lock_Row will lock a row in gme_batch_header
1142: |
1143: |
1144: |
1145: | PARAMETERS
1142: |
1143: |
1144: |
1145: | PARAMETERS
1146: | p_batch_header IN gme_batch_header%ROWTYPE
1147: |
1148: | RETURNS
1149: | BOOLEAN
1150: | HISTORY
1153: |
1154: |
1155: +=============================================================================
1156: */
1157: FUNCTION lock_row (p_batch_header IN gme_batch_header%ROWTYPE)
1158: RETURN BOOLEAN
1159: IS
1160: l_dummy NUMBER;
1161: l_api_name CONSTANT VARCHAR2 (30) := 'LOCK_ROW';
1167:
1168: IF p_batch_header.batch_id IS NOT NULL THEN
1169: SELECT 1
1170: INTO l_dummy
1171: FROM gme_batch_header
1172: WHERE batch_id = p_batch_header.batch_id
1173: FOR UPDATE NOWAIT;
1174: ELSIF ( p_batch_header.organization_id IS NOT NULL
1175: AND p_batch_header.batch_no IS NOT NULL
1175: AND p_batch_header.batch_no IS NOT NULL
1176: AND p_batch_header.batch_type IS NOT NULL) THEN
1177: SELECT 1
1178: INTO l_dummy
1179: FROM gme_batch_header
1180: WHERE organization_id = p_batch_header.organization_id
1181: AND batch_no = p_batch_header.batch_no
1182: AND batch_type = p_batch_header.batch_type
1183: FOR UPDATE NOWAIT;
1216: --Bug2804440
1217: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
1218: RETURN FALSE;
1219: END lock_row;
1220: END gme_batch_header_dbl;