eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.GME_API_PUB dependencies on FND_API

Line 44: 'T' (FND_API.G_TRUE) - to commit work

40: S - Success
41: E - Error
42: U - Unexpected Error
43: p_commit Indicates whether to commit.
44: 'T' (FND_API.G_TRUE) - to commit work
45: 'F' (FND_API.G_FALSE) - Not to commit work
46: This is defaulted 'F'
47: ================================================================================*/
48: /* Bug 5255959 added p_clear_qty_cache parameter */

Line 45: 'F' (FND_API.G_FALSE) - Not to commit work

41: E - Error
42: U - Unexpected Error
43: p_commit Indicates whether to commit.
44: 'T' (FND_API.G_TRUE) - to commit work
45: 'F' (FND_API.G_FALSE) - Not to commit work
46: This is defaulted 'F'
47: ================================================================================*/
48: /* Bug 5255959 added p_clear_qty_cache parameter */
49: PROCEDURE save_batch (

Line 52: ,p_commit IN VARCHAR2 := fnd_api.g_false

48: /* Bug 5255959 added p_clear_qty_cache parameter */
49: PROCEDURE save_batch (
50: p_header_id IN NUMBER DEFAULT NULL
51: ,p_table IN NUMBER DEFAULT NULL
52: ,p_commit IN VARCHAR2 := fnd_api.g_false
53: ,x_return_status OUT NOCOPY VARCHAR2
54: --Bug#5584699 Changed the datatype from boolean to varchar2.
55: ,p_clear_qty_cache IN VARCHAR2 := fnd_api.g_true);
56: --,p_clear_qty_cache IN BOOLEAN DEFAULT TRUE);

Line 55: ,p_clear_qty_cache IN VARCHAR2 := fnd_api.g_true);

51: ,p_table IN NUMBER DEFAULT NULL
52: ,p_commit IN VARCHAR2 := fnd_api.g_false
53: ,x_return_status OUT NOCOPY VARCHAR2
54: --Bug#5584699 Changed the datatype from boolean to varchar2.
55: ,p_clear_qty_cache IN VARCHAR2 := fnd_api.g_true);
56: --,p_clear_qty_cache IN BOOLEAN DEFAULT TRUE);
57:
58: /*#
59: * Create Batch Procedure

Line 145: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false

141: PROCEDURE create_batch (
142: p_api_version IN NUMBER
143: ,p_validation_level IN NUMBER
144: := gme_common_pvt.g_max_errors
145: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
146: ,p_commit IN VARCHAR2 := fnd_api.g_false
147: ,x_message_count OUT NOCOPY NUMBER
148: ,x_message_list OUT NOCOPY VARCHAR2
149: ,x_return_status OUT NOCOPY VARCHAR2

Line 146: ,p_commit IN VARCHAR2 := fnd_api.g_false

142: p_api_version IN NUMBER
143: ,p_validation_level IN NUMBER
144: := gme_common_pvt.g_max_errors
145: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
146: ,p_commit IN VARCHAR2 := fnd_api.g_false
147: ,x_message_count OUT NOCOPY NUMBER
148: ,x_message_list OUT NOCOPY VARCHAR2
149: ,x_return_status OUT NOCOPY VARCHAR2
150: ,p_org_code IN VARCHAR2 := NULL

Line 163: ,p_ignore_qty_below_cap IN VARCHAR2 := fnd_api.g_true

159: ,p_product_no IN VARCHAR2 := NULL
160: ,p_item_revision IN VARCHAR2 := NULL
161: ,p_product_id IN NUMBER := NULL
162: ,p_sum_all_prod_lines IN VARCHAR2 := 'A'
163: ,p_ignore_qty_below_cap IN VARCHAR2 := fnd_api.g_true
164: ,p_use_workday_cal IN VARCHAR2 := fnd_api.g_true
165: ,p_contiguity_override IN VARCHAR2 := fnd_api.g_true
166: ,p_use_least_cost_validity_rule IN VARCHAR2 := fnd_api.g_false
167: ,x_exception_material_tbl OUT NOCOPY gme_common_pvt.exceptions_tab);

Line 164: ,p_use_workday_cal IN VARCHAR2 := fnd_api.g_true

160: ,p_item_revision IN VARCHAR2 := NULL
161: ,p_product_id IN NUMBER := NULL
162: ,p_sum_all_prod_lines IN VARCHAR2 := 'A'
163: ,p_ignore_qty_below_cap IN VARCHAR2 := fnd_api.g_true
164: ,p_use_workday_cal IN VARCHAR2 := fnd_api.g_true
165: ,p_contiguity_override IN VARCHAR2 := fnd_api.g_true
166: ,p_use_least_cost_validity_rule IN VARCHAR2 := fnd_api.g_false
167: ,x_exception_material_tbl OUT NOCOPY gme_common_pvt.exceptions_tab);
168:

Line 165: ,p_contiguity_override IN VARCHAR2 := fnd_api.g_true

161: ,p_product_id IN NUMBER := NULL
162: ,p_sum_all_prod_lines IN VARCHAR2 := 'A'
163: ,p_ignore_qty_below_cap IN VARCHAR2 := fnd_api.g_true
164: ,p_use_workday_cal IN VARCHAR2 := fnd_api.g_true
165: ,p_contiguity_override IN VARCHAR2 := fnd_api.g_true
166: ,p_use_least_cost_validity_rule IN VARCHAR2 := fnd_api.g_false
167: ,x_exception_material_tbl OUT NOCOPY gme_common_pvt.exceptions_tab);
168:
169: /*#

Line 166: ,p_use_least_cost_validity_rule IN VARCHAR2 := fnd_api.g_false

162: ,p_sum_all_prod_lines IN VARCHAR2 := 'A'
163: ,p_ignore_qty_below_cap IN VARCHAR2 := fnd_api.g_true
164: ,p_use_workday_cal IN VARCHAR2 := fnd_api.g_true
165: ,p_contiguity_override IN VARCHAR2 := fnd_api.g_true
166: ,p_use_least_cost_validity_rule IN VARCHAR2 := fnd_api.g_false
167: ,x_exception_material_tbl OUT NOCOPY gme_common_pvt.exceptions_tab);
168:
169: /*#
170: * Create Phantom Procedure

Line 223: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false

219: PROCEDURE create_phantom (
220: p_api_version IN NUMBER
221: ,p_validation_level IN NUMBER
222: := gme_common_pvt.g_max_errors
223: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
224: ,p_commit IN VARCHAR2 := fnd_api.g_false
225: ,x_message_count OUT NOCOPY NUMBER
226: ,x_message_list OUT NOCOPY VARCHAR2
227: ,x_return_status OUT NOCOPY VARCHAR2

Line 224: ,p_commit IN VARCHAR2 := fnd_api.g_false

220: p_api_version IN NUMBER
221: ,p_validation_level IN NUMBER
222: := gme_common_pvt.g_max_errors
223: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
224: ,p_commit IN VARCHAR2 := fnd_api.g_false
225: ,x_message_count OUT NOCOPY NUMBER
226: ,x_message_list OUT NOCOPY VARCHAR2
227: ,x_return_status OUT NOCOPY VARCHAR2
228: ,p_material_detail_rec IN gme_material_details%ROWTYPE

Line 234: ,p_use_workday_cal IN VARCHAR2 := fnd_api.g_true

230: ,p_org_code IN VARCHAR2
231: ,p_batch_no IN VARCHAR2 DEFAULT NULL
232: ,x_material_detail_rec OUT NOCOPY gme_material_details%ROWTYPE
233: ,p_validity_rule_id IN NUMBER
234: ,p_use_workday_cal IN VARCHAR2 := fnd_api.g_true
235: ,p_contiguity_override IN VARCHAR2 := fnd_api.g_true
236: ,p_use_least_cost_validity_rule IN VARCHAR2 := fnd_api.g_false
237: ,x_exception_material_tbl OUT NOCOPY gme_common_pvt.exceptions_tab);
238:

Line 235: ,p_contiguity_override IN VARCHAR2 := fnd_api.g_true

231: ,p_batch_no IN VARCHAR2 DEFAULT NULL
232: ,x_material_detail_rec OUT NOCOPY gme_material_details%ROWTYPE
233: ,p_validity_rule_id IN NUMBER
234: ,p_use_workday_cal IN VARCHAR2 := fnd_api.g_true
235: ,p_contiguity_override IN VARCHAR2 := fnd_api.g_true
236: ,p_use_least_cost_validity_rule IN VARCHAR2 := fnd_api.g_false
237: ,x_exception_material_tbl OUT NOCOPY gme_common_pvt.exceptions_tab);
238:
239: /*#

Line 236: ,p_use_least_cost_validity_rule IN VARCHAR2 := fnd_api.g_false

232: ,x_material_detail_rec OUT NOCOPY gme_material_details%ROWTYPE
233: ,p_validity_rule_id IN NUMBER
234: ,p_use_workday_cal IN VARCHAR2 := fnd_api.g_true
235: ,p_contiguity_override IN VARCHAR2 := fnd_api.g_true
236: ,p_use_least_cost_validity_rule IN VARCHAR2 := fnd_api.g_false
237: ,x_exception_material_tbl OUT NOCOPY gme_common_pvt.exceptions_tab);
238:
239: /*#
240: * Scale Batch Procedure

Line 296: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false

292: PROCEDURE scale_batch (
293: p_api_version IN NUMBER
294: ,p_validation_level IN NUMBER
295: := gme_common_pvt.g_max_errors
296: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
297: ,p_commit IN VARCHAR2 := fnd_api.g_false
298: ,p_batch_header_rec IN gme_batch_header%ROWTYPE
299: ,p_org_code IN VARCHAR2
300: ,p_ignore_exception IN VARCHAR2 := fnd_api.g_false

Line 297: ,p_commit IN VARCHAR2 := fnd_api.g_false

293: p_api_version IN NUMBER
294: ,p_validation_level IN NUMBER
295: := gme_common_pvt.g_max_errors
296: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
297: ,p_commit IN VARCHAR2 := fnd_api.g_false
298: ,p_batch_header_rec IN gme_batch_header%ROWTYPE
299: ,p_org_code IN VARCHAR2
300: ,p_ignore_exception IN VARCHAR2 := fnd_api.g_false
301: ,p_scale_factor IN NUMBER

Line 300: ,p_ignore_exception IN VARCHAR2 := fnd_api.g_false

296: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
297: ,p_commit IN VARCHAR2 := fnd_api.g_false
298: ,p_batch_header_rec IN gme_batch_header%ROWTYPE
299: ,p_org_code IN VARCHAR2
300: ,p_ignore_exception IN VARCHAR2 := fnd_api.g_false
301: ,p_scale_factor IN NUMBER
302: ,p_primaries IN VARCHAR2
303: ,p_qty_type IN NUMBER := 1
304: ,p_recalc_dates IN VARCHAR2 := fnd_api.g_false

Line 304: ,p_recalc_dates IN VARCHAR2 := fnd_api.g_false

300: ,p_ignore_exception IN VARCHAR2 := fnd_api.g_false
301: ,p_scale_factor IN NUMBER
302: ,p_primaries IN VARCHAR2
303: ,p_qty_type IN NUMBER := 1
304: ,p_recalc_dates IN VARCHAR2 := fnd_api.g_false
305: ,p_use_workday_cal IN VARCHAR2 := fnd_api.g_false
306: ,p_contiguity_override IN VARCHAR2 := fnd_api.g_false
307: ,x_exception_material_tbl OUT NOCOPY gme_common_pvt.exceptions_tab
308: ,x_message_count OUT NOCOPY NUMBER

Line 305: ,p_use_workday_cal IN VARCHAR2 := fnd_api.g_false

301: ,p_scale_factor IN NUMBER
302: ,p_primaries IN VARCHAR2
303: ,p_qty_type IN NUMBER := 1
304: ,p_recalc_dates IN VARCHAR2 := fnd_api.g_false
305: ,p_use_workday_cal IN VARCHAR2 := fnd_api.g_false
306: ,p_contiguity_override IN VARCHAR2 := fnd_api.g_false
307: ,x_exception_material_tbl OUT NOCOPY gme_common_pvt.exceptions_tab
308: ,x_message_count OUT NOCOPY NUMBER
309: ,x_message_list OUT NOCOPY VARCHAR2

Line 306: ,p_contiguity_override IN VARCHAR2 := fnd_api.g_false

302: ,p_primaries IN VARCHAR2
303: ,p_qty_type IN NUMBER := 1
304: ,p_recalc_dates IN VARCHAR2 := fnd_api.g_false
305: ,p_use_workday_cal IN VARCHAR2 := fnd_api.g_false
306: ,p_contiguity_override IN VARCHAR2 := fnd_api.g_false
307: ,x_exception_material_tbl OUT NOCOPY gme_common_pvt.exceptions_tab
308: ,x_message_count OUT NOCOPY NUMBER
309: ,x_message_list OUT NOCOPY VARCHAR2
310: ,x_return_status OUT NOCOPY VARCHAR2

Line 356: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false

352: PROCEDURE theoretical_yield_batch (
353: p_api_version IN NUMBER := 2.0
354: ,p_validation_level IN NUMBER
355: := gme_common_pvt.g_max_errors
356: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
357: ,p_commit IN VARCHAR2 := fnd_api.g_false
358: ,p_batch_header_rec IN gme_batch_header%ROWTYPE
359: ,p_org_code IN VARCHAR2
360: ,p_scale_factor IN NUMBER

Line 357: ,p_commit IN VARCHAR2 := fnd_api.g_false

353: p_api_version IN NUMBER := 2.0
354: ,p_validation_level IN NUMBER
355: := gme_common_pvt.g_max_errors
356: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
357: ,p_commit IN VARCHAR2 := fnd_api.g_false
358: ,p_batch_header_rec IN gme_batch_header%ROWTYPE
359: ,p_org_code IN VARCHAR2
360: ,p_scale_factor IN NUMBER
361: ,x_message_count OUT NOCOPY NUMBER

Line 420: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false

416: PROCEDURE update_actual_rsrc_usage (
417: p_api_version IN NUMBER := 2.0
418: ,p_validation_level IN NUMBER
419: := gme_common_pvt.g_max_errors
420: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
421: ,p_commit IN VARCHAR2 := fnd_api.g_false
422: ,p_org_code IN VARCHAR2
423: , /* inventory organization under which the batch was created */
424: p_batch_no IN VARCHAR2 := NULL

Line 421: ,p_commit IN VARCHAR2 := fnd_api.g_false

417: p_api_version IN NUMBER := 2.0
418: ,p_validation_level IN NUMBER
419: := gme_common_pvt.g_max_errors
420: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
421: ,p_commit IN VARCHAR2 := fnd_api.g_false
422: ,p_org_code IN VARCHAR2
423: , /* inventory organization under which the batch was created */
424: p_batch_no IN VARCHAR2 := NULL
425: ,p_batchstep_no IN NUMBER := NULL

Line 431: ,p_validate_flexfields IN VARCHAR2 := fnd_api.g_false

427: ,p_resource IN VARCHAR2 := NULL
428: ,p_instance_no IN NUMBER := NULL
429: ,p_reason_name IN VARCHAR2 := NULL
430: ,p_rsrc_txn_rec IN gme_resource_txns%ROWTYPE
431: ,p_validate_flexfields IN VARCHAR2 := fnd_api.g_false
432: , /* indicates whether to validate the flex fields*/
433: x_rsrc_txn_rec IN OUT NOCOPY gme_resource_txns%ROWTYPE
434: ,x_message_count OUT NOCOPY NUMBER
435: ,x_message_list OUT NOCOPY VARCHAR2

Line 491: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false

487: PROCEDURE insert_incr_actual_rsrc_txn (
488: p_api_version IN NUMBER := 2.0
489: ,p_validation_level IN NUMBER
490: := gme_common_pvt.g_max_errors
491: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
492: ,p_commit IN VARCHAR2 := fnd_api.g_false
493: ,p_org_code IN VARCHAR2
494: , /* inventory organization under which the batch was created.*/
495: p_batch_no IN VARCHAR2 := NULL

Line 492: ,p_commit IN VARCHAR2 := fnd_api.g_false

488: p_api_version IN NUMBER := 2.0
489: ,p_validation_level IN NUMBER
490: := gme_common_pvt.g_max_errors
491: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
492: ,p_commit IN VARCHAR2 := fnd_api.g_false
493: ,p_org_code IN VARCHAR2
494: , /* inventory organization under which the batch was created.*/
495: p_batch_no IN VARCHAR2 := NULL
496: ,p_batchstep_no IN NUMBER := NULL

Line 502: ,p_validate_flexfields IN VARCHAR2 := fnd_api.g_false

498: ,p_resource IN VARCHAR2 := NULL
499: ,p_instance_no IN NUMBER := NULL
500: ,p_reason_name IN VARCHAR2 := NULL
501: ,p_rsrc_txn_rec IN gme_resource_txns%ROWTYPE
502: ,p_validate_flexfields IN VARCHAR2 := fnd_api.g_false
503: , /* indicates whether to validate the flex fields */
504: x_rsrc_txn_rec IN OUT NOCOPY gme_resource_txns%ROWTYPE
505: ,x_message_count OUT NOCOPY NUMBER
506: ,x_message_list OUT NOCOPY VARCHAR2

Line 564: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false

560: PROCEDURE insert_timed_actual_rsrc_txn (
561: p_api_version IN NUMBER := 2.0
562: ,p_validation_level IN NUMBER
563: := gme_common_pvt.g_max_errors
564: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
565: ,p_commit IN VARCHAR2 := fnd_api.g_false
566: ,p_org_code IN VARCHAR2
567: , /* inventory organization under which the batch was created. */
568: p_batch_no IN VARCHAR2 := NULL

Line 565: ,p_commit IN VARCHAR2 := fnd_api.g_false

561: p_api_version IN NUMBER := 2.0
562: ,p_validation_level IN NUMBER
563: := gme_common_pvt.g_max_errors
564: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
565: ,p_commit IN VARCHAR2 := fnd_api.g_false
566: ,p_org_code IN VARCHAR2
567: , /* inventory organization under which the batch was created. */
568: p_batch_no IN VARCHAR2 := NULL
569: ,p_batchstep_no IN NUMBER := NULL

Line 575: ,p_validate_flexfields IN VARCHAR2 := fnd_api.g_false

571: ,p_resource IN VARCHAR2 := NULL
572: ,p_instance_no IN NUMBER := NULL
573: ,p_reason_name IN VARCHAR2 := NULL
574: ,p_rsrc_txn_rec IN gme_resource_txns%ROWTYPE
575: ,p_validate_flexfields IN VARCHAR2 := fnd_api.g_false
576: , /* indicates whether to validate the flex fields */
577: x_rsrc_txn_rec IN OUT NOCOPY gme_resource_txns%ROWTYPE
578: ,x_message_count OUT NOCOPY NUMBER
579: ,x_message_list OUT NOCOPY VARCHAR2

Line 637: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false

633: PROCEDURE start_cmplt_actual_rsrc_txn (
634: p_api_version IN NUMBER := 2.0
635: ,p_validation_level IN NUMBER
636: := gme_common_pvt.g_max_errors
637: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
638: ,p_commit IN VARCHAR2 := fnd_api.g_false
639: ,p_org_code IN VARCHAR2
640: , /*inventory organization under which the batch was created.*/
641: p_batch_no IN VARCHAR2 := NULL

Line 638: ,p_commit IN VARCHAR2 := fnd_api.g_false

634: p_api_version IN NUMBER := 2.0
635: ,p_validation_level IN NUMBER
636: := gme_common_pvt.g_max_errors
637: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
638: ,p_commit IN VARCHAR2 := fnd_api.g_false
639: ,p_org_code IN VARCHAR2
640: , /*inventory organization under which the batch was created.*/
641: p_batch_no IN VARCHAR2 := NULL
642: ,p_batchstep_no IN NUMBER := NULL

Line 649: ,p_validate_flexfields IN VARCHAR2 := fnd_api.g_false

645: ,p_instance_no IN NUMBER
646: ,p_reason_name IN VARCHAR2 := NULL
647: , /*instance of the resource for which the transaction is being added.*/
648: p_rsrc_txn_rec IN gme_resource_txns%ROWTYPE
649: ,p_validate_flexfields IN VARCHAR2 := fnd_api.g_false
650: , /*indicates whether to validate the flex fields*/
651: x_rsrc_txn_rec IN OUT NOCOPY gme_resource_txns%ROWTYPE
652: ,x_message_count OUT NOCOPY NUMBER
653: ,x_message_list OUT NOCOPY VARCHAR2

Line 700: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false

696: PROCEDURE end_cmplt_actual_rsrc_txn (
697: p_api_version IN NUMBER := 2.0
698: ,p_validation_level IN NUMBER
699: := gme_common_pvt.g_max_errors
700: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
701: ,p_commit IN VARCHAR2 := fnd_api.g_false
702: ,p_instance_no IN NUMBER := NULL
703: ,p_reason_name IN VARCHAR2 := NULL
704: ,p_rsrc_txn_rec IN gme_resource_txns%ROWTYPE

Line 701: ,p_commit IN VARCHAR2 := fnd_api.g_false

697: p_api_version IN NUMBER := 2.0
698: ,p_validation_level IN NUMBER
699: := gme_common_pvt.g_max_errors
700: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
701: ,p_commit IN VARCHAR2 := fnd_api.g_false
702: ,p_instance_no IN NUMBER := NULL
703: ,p_reason_name IN VARCHAR2 := NULL
704: ,p_rsrc_txn_rec IN gme_resource_txns%ROWTYPE
705: , /*contains information for resource_transaction to be completed*/

Line 706: p_validate_flexfields IN VARCHAR2 := fnd_api.g_false

702: ,p_instance_no IN NUMBER := NULL
703: ,p_reason_name IN VARCHAR2 := NULL
704: ,p_rsrc_txn_rec IN gme_resource_txns%ROWTYPE
705: , /*contains information for resource_transaction to be completed*/
706: p_validate_flexfields IN VARCHAR2 := fnd_api.g_false
707: , /* indicates whether to validate the flex fields */
708: x_rsrc_txn_rec IN OUT NOCOPY gme_resource_txns%ROWTYPE
709: ,x_message_count OUT NOCOPY NUMBER
710: ,x_message_list OUT NOCOPY VARCHAR2

Line 760: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false

756: PROCEDURE reschedule_batch (
757: p_api_version IN NUMBER := 2.0
758: ,p_validation_level IN NUMBER
759: := gme_common_pvt.g_max_errors
760: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
761: ,p_commit IN VARCHAR2 := fnd_api.g_false
762: ,p_batch_header_rec IN gme_batch_header%ROWTYPE
763: ,p_use_workday_cal IN VARCHAR2 := fnd_api.g_false
764: ,p_contiguity_override IN VARCHAR2 := fnd_api.g_false

Line 761: ,p_commit IN VARCHAR2 := fnd_api.g_false

757: p_api_version IN NUMBER := 2.0
758: ,p_validation_level IN NUMBER
759: := gme_common_pvt.g_max_errors
760: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
761: ,p_commit IN VARCHAR2 := fnd_api.g_false
762: ,p_batch_header_rec IN gme_batch_header%ROWTYPE
763: ,p_use_workday_cal IN VARCHAR2 := fnd_api.g_false
764: ,p_contiguity_override IN VARCHAR2 := fnd_api.g_false
765: ,p_org_code IN VARCHAR2

Line 763: ,p_use_workday_cal IN VARCHAR2 := fnd_api.g_false

759: := gme_common_pvt.g_max_errors
760: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
761: ,p_commit IN VARCHAR2 := fnd_api.g_false
762: ,p_batch_header_rec IN gme_batch_header%ROWTYPE
763: ,p_use_workday_cal IN VARCHAR2 := fnd_api.g_false
764: ,p_contiguity_override IN VARCHAR2 := fnd_api.g_false
765: ,p_org_code IN VARCHAR2
766: ,x_message_count OUT NOCOPY NUMBER
767: ,x_message_list OUT NOCOPY VARCHAR2

Line 764: ,p_contiguity_override IN VARCHAR2 := fnd_api.g_false

760: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
761: ,p_commit IN VARCHAR2 := fnd_api.g_false
762: ,p_batch_header_rec IN gme_batch_header%ROWTYPE
763: ,p_use_workday_cal IN VARCHAR2 := fnd_api.g_false
764: ,p_contiguity_override IN VARCHAR2 := fnd_api.g_false
765: ,p_org_code IN VARCHAR2
766: ,x_message_count OUT NOCOPY NUMBER
767: ,x_message_list OUT NOCOPY VARCHAR2
768: ,x_return_status OUT NOCOPY VARCHAR2

Line 824: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false

820: PROCEDURE reschedule_step (
821: p_api_version IN NUMBER := 2.0
822: ,p_validation_level IN NUMBER
823: := gme_common_pvt.g_max_errors
824: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
825: ,p_commit IN VARCHAR2 := fnd_api.g_false
826: ,p_batch_step_rec IN gme_batch_steps%ROWTYPE
827: ,p_use_workday_cal IN VARCHAR2 := fnd_api.g_false
828: ,p_contiguity_override IN VARCHAR2 := fnd_api.g_false

Line 825: ,p_commit IN VARCHAR2 := fnd_api.g_false

821: p_api_version IN NUMBER := 2.0
822: ,p_validation_level IN NUMBER
823: := gme_common_pvt.g_max_errors
824: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
825: ,p_commit IN VARCHAR2 := fnd_api.g_false
826: ,p_batch_step_rec IN gme_batch_steps%ROWTYPE
827: ,p_use_workday_cal IN VARCHAR2 := fnd_api.g_false
828: ,p_contiguity_override IN VARCHAR2 := fnd_api.g_false
829: ,p_org_code IN VARCHAR2

Line 827: ,p_use_workday_cal IN VARCHAR2 := fnd_api.g_false

823: := gme_common_pvt.g_max_errors
824: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
825: ,p_commit IN VARCHAR2 := fnd_api.g_false
826: ,p_batch_step_rec IN gme_batch_steps%ROWTYPE
827: ,p_use_workday_cal IN VARCHAR2 := fnd_api.g_false
828: ,p_contiguity_override IN VARCHAR2 := fnd_api.g_false
829: ,p_org_code IN VARCHAR2
830: ,p_batch_no IN VARCHAR2
831: ,p_batch_type IN NUMBER

Line 828: ,p_contiguity_override IN VARCHAR2 := fnd_api.g_false

824: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
825: ,p_commit IN VARCHAR2 := fnd_api.g_false
826: ,p_batch_step_rec IN gme_batch_steps%ROWTYPE
827: ,p_use_workday_cal IN VARCHAR2 := fnd_api.g_false
828: ,p_contiguity_override IN VARCHAR2 := fnd_api.g_false
829: ,p_org_code IN VARCHAR2
830: ,p_batch_no IN VARCHAR2
831: ,p_batch_type IN NUMBER
832: ,p_reschedule_preceding IN VARCHAR2 := fnd_api.g_false

Line 832: ,p_reschedule_preceding IN VARCHAR2 := fnd_api.g_false

828: ,p_contiguity_override IN VARCHAR2 := fnd_api.g_false
829: ,p_org_code IN VARCHAR2
830: ,p_batch_no IN VARCHAR2
831: ,p_batch_type IN NUMBER
832: ,p_reschedule_preceding IN VARCHAR2 := fnd_api.g_false
833: ,p_reschedule_succeeding IN VARCHAR2 := fnd_api.g_true
834: ,x_message_count OUT NOCOPY NUMBER
835: ,x_message_list OUT NOCOPY VARCHAR2
836: ,x_return_status OUT NOCOPY VARCHAR2

Line 833: ,p_reschedule_succeeding IN VARCHAR2 := fnd_api.g_true

829: ,p_org_code IN VARCHAR2
830: ,p_batch_no IN VARCHAR2
831: ,p_batch_type IN NUMBER
832: ,p_reschedule_preceding IN VARCHAR2 := fnd_api.g_false
833: ,p_reschedule_succeeding IN VARCHAR2 := fnd_api.g_true
834: ,x_message_count OUT NOCOPY NUMBER
835: ,x_message_list OUT NOCOPY VARCHAR2
836: ,x_return_status OUT NOCOPY VARCHAR2
837: ,x_batch_step_rec OUT NOCOPY gme_batch_steps%ROWTYPE);

Line 889: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false

885: PROCEDURE create_batch_reservations (
886: p_api_version IN NUMBER := 2.0
887: ,p_validation_level IN NUMBER
888: := gme_common_pvt.g_max_errors
889: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
890: ,p_commit IN VARCHAR2 := fnd_api.g_false
891: ,p_batch_rec IN gme_batch_header%ROWTYPE
892: ,p_org_code IN VARCHAR2
893: ,x_message_count OUT NOCOPY NUMBER

Line 890: ,p_commit IN VARCHAR2 := fnd_api.g_false

886: p_api_version IN NUMBER := 2.0
887: ,p_validation_level IN NUMBER
888: := gme_common_pvt.g_max_errors
889: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
890: ,p_commit IN VARCHAR2 := fnd_api.g_false
891: ,p_batch_rec IN gme_batch_header%ROWTYPE
892: ,p_org_code IN VARCHAR2
893: ,x_message_count OUT NOCOPY NUMBER
894: ,x_message_list OUT NOCOPY VARCHAR2

Line 946: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false

942: PROCEDURE create_line_reservations (
943: p_api_version IN NUMBER := 2.0
944: ,p_validation_level IN NUMBER
945: := gme_common_pvt.g_max_errors
946: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
947: ,p_commit IN VARCHAR2 := fnd_api.g_false
948: ,p_material_detail_id IN NUMBER
949: ,p_org_code IN VARCHAR2
950: ,p_batch_no IN VARCHAR2

Line 947: ,p_commit IN VARCHAR2 := fnd_api.g_false

943: p_api_version IN NUMBER := 2.0
944: ,p_validation_level IN NUMBER
945: := gme_common_pvt.g_max_errors
946: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
947: ,p_commit IN VARCHAR2 := fnd_api.g_false
948: ,p_material_detail_id IN NUMBER
949: ,p_org_code IN VARCHAR2
950: ,p_batch_no IN VARCHAR2
951: ,p_line_no IN NUMBER

Line 1003: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false

999: PROCEDURE insert_process_parameter (
1000: p_api_version IN NUMBER := 2.0
1001: ,p_validation_level IN NUMBER
1002: := gme_common_pvt.g_max_errors
1003: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
1004: ,p_commit IN VARCHAR2 := fnd_api.g_false
1005: ,x_message_count OUT NOCOPY NUMBER
1006: ,x_message_list OUT NOCOPY VARCHAR2
1007: ,x_return_status OUT NOCOPY VARCHAR2

Line 1004: ,p_commit IN VARCHAR2 := fnd_api.g_false

1000: p_api_version IN NUMBER := 2.0
1001: ,p_validation_level IN NUMBER
1002: := gme_common_pvt.g_max_errors
1003: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
1004: ,p_commit IN VARCHAR2 := fnd_api.g_false
1005: ,x_message_count OUT NOCOPY NUMBER
1006: ,x_message_list OUT NOCOPY VARCHAR2
1007: ,x_return_status OUT NOCOPY VARCHAR2
1008: ,p_batch_no IN VARCHAR2 := NULL

Line 1010: ,p_validate_flexfields IN VARCHAR2 := fnd_api.g_false

1006: ,x_message_list OUT NOCOPY VARCHAR2
1007: ,x_return_status OUT NOCOPY VARCHAR2
1008: ,p_batch_no IN VARCHAR2 := NULL
1009: ,p_org_code IN VARCHAR2 := NULL
1010: ,p_validate_flexfields IN VARCHAR2 := fnd_api.g_false
1011: ,p_batchstep_no IN NUMBER := NULL
1012: ,p_activity IN VARCHAR2 := NULL
1013: ,p_parameter IN VARCHAR2 := NULL
1014: ,p_process_param_rec IN gme_process_parameters%ROWTYPE

Line 1065: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false

1061: PROCEDURE update_process_parameter (
1062: p_api_version IN NUMBER := 2.0
1063: ,p_validation_level IN NUMBER
1064: := gme_common_pvt.g_max_errors
1065: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
1066: ,p_commit IN VARCHAR2 := fnd_api.g_false
1067: ,x_message_count OUT NOCOPY NUMBER
1068: ,x_message_list OUT NOCOPY VARCHAR2
1069: ,x_return_status OUT NOCOPY VARCHAR2

Line 1066: ,p_commit IN VARCHAR2 := fnd_api.g_false

1062: p_api_version IN NUMBER := 2.0
1063: ,p_validation_level IN NUMBER
1064: := gme_common_pvt.g_max_errors
1065: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
1066: ,p_commit IN VARCHAR2 := fnd_api.g_false
1067: ,x_message_count OUT NOCOPY NUMBER
1068: ,x_message_list OUT NOCOPY VARCHAR2
1069: ,x_return_status OUT NOCOPY VARCHAR2
1070: ,p_batch_no IN VARCHAR2 := NULL

Line 1072: ,p_validate_flexfields IN VARCHAR2 := fnd_api.g_false

1068: ,x_message_list OUT NOCOPY VARCHAR2
1069: ,x_return_status OUT NOCOPY VARCHAR2
1070: ,p_batch_no IN VARCHAR2 := NULL
1071: ,p_org_code IN VARCHAR2 := NULL
1072: ,p_validate_flexfields IN VARCHAR2 := fnd_api.g_false
1073: ,p_batchstep_no IN NUMBER := NULL
1074: ,p_activity IN VARCHAR2 := NULL
1075: ,p_parameter IN VARCHAR2 := NULL
1076: ,p_process_param_rec IN gme_process_parameters%ROWTYPE

Line 1122: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false

1118: PROCEDURE delete_process_parameter (
1119: p_api_version IN NUMBER := 2.0
1120: ,p_validation_level IN NUMBER
1121: := gme_common_pvt.g_max_errors
1122: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
1123: ,p_commit IN VARCHAR2 := fnd_api.g_false
1124: ,x_message_count OUT NOCOPY NUMBER
1125: ,x_message_list OUT NOCOPY VARCHAR2
1126: ,x_return_status OUT NOCOPY VARCHAR2

Line 1123: ,p_commit IN VARCHAR2 := fnd_api.g_false

1119: p_api_version IN NUMBER := 2.0
1120: ,p_validation_level IN NUMBER
1121: := gme_common_pvt.g_max_errors
1122: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
1123: ,p_commit IN VARCHAR2 := fnd_api.g_false
1124: ,x_message_count OUT NOCOPY NUMBER
1125: ,x_message_list OUT NOCOPY VARCHAR2
1126: ,x_return_status OUT NOCOPY VARCHAR2
1127: ,p_batch_no IN VARCHAR2 := NULL

Line 1181: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false

1177: PROCEDURE insert_step (
1178: p_api_version IN NUMBER := 2.0
1179: ,p_validation_level IN NUMBER
1180: := gme_common_pvt.g_max_errors
1181: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
1182: ,p_commit IN VARCHAR2
1183: ,p_org_code IN VARCHAR2
1184: /*FPBug#4395561*/
1185: ,p_validate_flexfields IN VARCHAR2 := fnd_api.g_false

Line 1185: ,p_validate_flexfields IN VARCHAR2 := fnd_api.g_false

1181: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
1182: ,p_commit IN VARCHAR2
1183: ,p_org_code IN VARCHAR2
1184: /*FPBug#4395561*/
1185: ,p_validate_flexfields IN VARCHAR2 := fnd_api.g_false
1186: , /* The inventory organization under which the batch exists.*/
1187: p_oprn_no IN VARCHAR2
1188: , /* The operation number for the step */
1189: p_oprn_vers IN NUMBER

Line 1245: ,p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false

1241: ================================================================================*/
1242: PROCEDURE insert_material_line (
1243: p_api_version IN NUMBER := 2.0
1244: ,p_validation_level IN NUMBER := gme_common_pvt.g_max_errors
1245: ,p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false
1246: ,p_commit IN VARCHAR2 DEFAULT fnd_api.g_false
1247: ,p_batch_header_rec IN gme_batch_header%ROWTYPE
1248: ,p_material_detail_rec IN gme_material_details%ROWTYPE
1249: ,p_locator_code IN VARCHAR2

Line 1246: ,p_commit IN VARCHAR2 DEFAULT fnd_api.g_false

1242: PROCEDURE insert_material_line (
1243: p_api_version IN NUMBER := 2.0
1244: ,p_validation_level IN NUMBER := gme_common_pvt.g_max_errors
1245: ,p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false
1246: ,p_commit IN VARCHAR2 DEFAULT fnd_api.g_false
1247: ,p_batch_header_rec IN gme_batch_header%ROWTYPE
1248: ,p_material_detail_rec IN gme_material_details%ROWTYPE
1249: ,p_locator_code IN VARCHAR2
1250: ,p_org_code IN VARCHAR2

Line 1252: ,p_validate_flexfields IN VARCHAR2 DEFAULT fnd_api.g_false

1248: ,p_material_detail_rec IN gme_material_details%ROWTYPE
1249: ,p_locator_code IN VARCHAR2
1250: ,p_org_code IN VARCHAR2
1251: ,p_batchstep_no IN NUMBER := NULL
1252: ,p_validate_flexfields IN VARCHAR2 DEFAULT fnd_api.g_false
1253: ,x_material_detail_rec OUT NOCOPY gme_material_details%ROWTYPE
1254: ,x_message_count OUT NOCOPY NUMBER
1255: ,x_message_list OUT NOCOPY VARCHAR2
1256: ,x_return_status OUT NOCOPY VARCHAR2);

Line 1307: ,p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false

1303: ================================================================================*/
1304: PROCEDURE update_material_line (
1305: p_api_version IN NUMBER := 2.0
1306: ,p_validation_level IN NUMBER := gme_common_pvt.g_max_errors
1307: ,p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false
1308: ,p_commit IN VARCHAR2 DEFAULT fnd_api.g_false
1309: ,p_batch_header_rec IN gme_batch_header%ROWTYPE
1310: ,p_material_detail_rec IN gme_material_details%ROWTYPE
1311: ,p_locator_code IN VARCHAR2

Line 1308: ,p_commit IN VARCHAR2 DEFAULT fnd_api.g_false

1304: PROCEDURE update_material_line (
1305: p_api_version IN NUMBER := 2.0
1306: ,p_validation_level IN NUMBER := gme_common_pvt.g_max_errors
1307: ,p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false
1308: ,p_commit IN VARCHAR2 DEFAULT fnd_api.g_false
1309: ,p_batch_header_rec IN gme_batch_header%ROWTYPE
1310: ,p_material_detail_rec IN gme_material_details%ROWTYPE
1311: ,p_locator_code IN VARCHAR2
1312: ,p_org_code IN VARCHAR2

Line 1313: ,p_scale_phantom IN VARCHAR2 DEFAULT fnd_api.g_false

1309: ,p_batch_header_rec IN gme_batch_header%ROWTYPE
1310: ,p_material_detail_rec IN gme_material_details%ROWTYPE
1311: ,p_locator_code IN VARCHAR2
1312: ,p_org_code IN VARCHAR2
1313: ,p_scale_phantom IN VARCHAR2 DEFAULT fnd_api.g_false
1314: ,p_validate_flexfields IN VARCHAR2 DEFAULT fnd_api.g_false
1315: ,x_material_detail_rec OUT NOCOPY gme_material_details%ROWTYPE
1316: ,x_message_count OUT NOCOPY NUMBER
1317: ,x_message_list OUT NOCOPY VARCHAR2

Line 1314: ,p_validate_flexfields IN VARCHAR2 DEFAULT fnd_api.g_false

1310: ,p_material_detail_rec IN gme_material_details%ROWTYPE
1311: ,p_locator_code IN VARCHAR2
1312: ,p_org_code IN VARCHAR2
1313: ,p_scale_phantom IN VARCHAR2 DEFAULT fnd_api.g_false
1314: ,p_validate_flexfields IN VARCHAR2 DEFAULT fnd_api.g_false
1315: ,x_material_detail_rec OUT NOCOPY gme_material_details%ROWTYPE
1316: ,x_message_count OUT NOCOPY NUMBER
1317: ,x_message_list OUT NOCOPY VARCHAR2
1318: ,x_return_status OUT NOCOPY VARCHAR2 );

Line 1360: ,p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false

1356: ================================================================================*/
1357: PROCEDURE delete_material_line (
1358: p_api_version IN NUMBER := 2.0
1359: ,p_validation_level IN NUMBER := gme_common_pvt.g_max_errors
1360: ,p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false
1361: ,p_commit IN VARCHAR2 DEFAULT fnd_api.g_false
1362: ,p_batch_header_rec IN gme_batch_header%ROWTYPE
1363: ,p_material_detail_rec IN gme_material_details%ROWTYPE
1364: ,p_org_code IN VARCHAR2

Line 1361: ,p_commit IN VARCHAR2 DEFAULT fnd_api.g_false

1357: PROCEDURE delete_material_line (
1358: p_api_version IN NUMBER := 2.0
1359: ,p_validation_level IN NUMBER := gme_common_pvt.g_max_errors
1360: ,p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false
1361: ,p_commit IN VARCHAR2 DEFAULT fnd_api.g_false
1362: ,p_batch_header_rec IN gme_batch_header%ROWTYPE
1363: ,p_material_detail_rec IN gme_material_details%ROWTYPE
1364: ,p_org_code IN VARCHAR2
1365: ,x_message_count OUT NOCOPY NUMBER

Line 1407: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false

1403: PROCEDURE delete_step (
1404: p_api_version IN NUMBER := 2.0
1405: ,p_validation_level IN NUMBER
1406: := gme_common_pvt.g_max_errors
1407: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
1408: ,p_commit IN VARCHAR2
1409: ,p_org_code IN VARCHAR2
1410: ,p_batch_no IN VARCHAR2
1411: ,x_message_count OUT NOCOPY NUMBER

Line 1615: p_init_msg_list IN VARCHAR2 := fnd_api.g_false

1611: , /* Punit Kumar */
1612: p_validation_level IN NUMBER
1613: := gme_common_pvt.g_max_errors
1614: , /* Punit Kumar */
1615: p_init_msg_list IN VARCHAR2 := fnd_api.g_false
1616: ,p_commit IN VARCHAR2
1617: ,x_message_count OUT NOCOPY NUMBER
1618: ,x_message_list OUT NOCOPY VARCHAR2
1619: ,x_return_status OUT NOCOPY VARCHAR2

Line 1621: ,p_delete_pending IN VARCHAR2 := fnd_api.g_false

1617: ,x_message_count OUT NOCOPY NUMBER
1618: ,x_message_list OUT NOCOPY VARCHAR2
1619: ,x_return_status OUT NOCOPY VARCHAR2
1620: ,p_batch_step_rec IN gme_batch_steps%ROWTYPE
1621: ,p_delete_pending IN VARCHAR2 := fnd_api.g_false
1622: ,p_org_code IN VARCHAR2
1623: ,p_batch_no IN VARCHAR2
1624: ,x_batch_step_rec OUT NOCOPY gme_batch_steps%ROWTYPE);
1625:

Line 1666: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false

1662: PROCEDURE cancel_batch (
1663: p_api_version IN NUMBER := 2.0
1664: ,p_validation_level IN NUMBER
1665: := gme_common_pvt.g_max_errors
1666: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
1667: ,p_commit IN VARCHAR2 := fnd_api.g_false
1668: ,x_message_count OUT NOCOPY NUMBER
1669: ,x_message_list OUT NOCOPY VARCHAR2
1670: ,x_return_status OUT NOCOPY VARCHAR2

Line 1667: ,p_commit IN VARCHAR2 := fnd_api.g_false

1663: p_api_version IN NUMBER := 2.0
1664: ,p_validation_level IN NUMBER
1665: := gme_common_pvt.g_max_errors
1666: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
1667: ,p_commit IN VARCHAR2 := fnd_api.g_false
1668: ,x_message_count OUT NOCOPY NUMBER
1669: ,x_message_list OUT NOCOPY VARCHAR2
1670: ,x_return_status OUT NOCOPY VARCHAR2
1671: ,p_org_code IN VARCHAR2

Line 1720: p_init_msg_list IN VARCHAR2 := fnd_api.g_false

1716: , /* Punit Kumar */
1717: p_validation_level IN NUMBER
1718: := gme_common_pvt.g_max_errors
1719: , /* Punit Kumar */
1720: p_init_msg_list IN VARCHAR2 := fnd_api.g_false
1721: ,p_commit IN VARCHAR2
1722: ,x_message_count OUT NOCOPY NUMBER
1723: ,x_message_list OUT NOCOPY VARCHAR2
1724: ,x_return_status OUT NOCOPY VARCHAR2

Line 1727: ,p_reopen_steps IN VARCHAR2 := fnd_api.g_false

1723: ,x_message_list OUT NOCOPY VARCHAR2
1724: ,x_return_status OUT NOCOPY VARCHAR2
1725: ,p_batch_header_rec IN gme_batch_header%ROWTYPE
1726: ,p_org_code IN VARCHAR2
1727: ,p_reopen_steps IN VARCHAR2 := fnd_api.g_false
1728: ,x_batch_header_rec OUT NOCOPY gme_batch_header%ROWTYPE);
1729:
1730: /*#
1731: * Reopen Step Procedure

Line 1773: p_init_msg_list IN VARCHAR2 := fnd_api.g_false

1769: , /* Punit Kumar */
1770: p_validation_level IN NUMBER
1771: := gme_common_pvt.g_max_errors
1772: , /* Punit Kumar */
1773: p_init_msg_list IN VARCHAR2 := fnd_api.g_false
1774: ,p_commit IN VARCHAR2
1775: ,x_message_count OUT NOCOPY NUMBER
1776: ,x_message_list OUT NOCOPY VARCHAR2
1777: ,x_return_status OUT NOCOPY VARCHAR2

Line 1817: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false

1813: PROCEDURE incremental_backflush (
1814: p_api_version IN NUMBER
1815: ,p_validation_level IN NUMBER
1816: := gme_common_pvt.g_max_errors
1817: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
1818: ,p_commit IN VARCHAR2 := fnd_api.g_false
1819: ,x_message_count OUT NOCOPY NUMBER
1820: ,x_message_list OUT NOCOPY VARCHAR2
1821: ,x_return_status OUT NOCOPY VARCHAR2

Line 1818: ,p_commit IN VARCHAR2 := fnd_api.g_false

1814: p_api_version IN NUMBER
1815: ,p_validation_level IN NUMBER
1816: := gme_common_pvt.g_max_errors
1817: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
1818: ,p_commit IN VARCHAR2 := fnd_api.g_false
1819: ,x_message_count OUT NOCOPY NUMBER
1820: ,x_message_list OUT NOCOPY VARCHAR2
1821: ,x_return_status OUT NOCOPY VARCHAR2
1822: ,p_batch_header_rec IN gme_batch_header%ROWTYPE

Line 1828: ,p_ignore_exception IN VARCHAR2 := fnd_api.g_false

1824: ,p_material_detail_rec IN gme_material_details%ROWTYPE
1825: ,p_qty IN NUMBER
1826: ,p_qty_type IN NUMBER := 0
1827: ,p_trans_date IN DATE
1828: ,p_ignore_exception IN VARCHAR2 := fnd_api.g_false
1829: ,p_adjust_cmplt IN VARCHAR2 := fnd_api.g_true
1830: ,x_exception_material_tbl OUT NOCOPY gme_common_pvt.exceptions_tab);
1831: /*#
1832: * Create Material Transaction Procedure

Line 1829: ,p_adjust_cmplt IN VARCHAR2 := fnd_api.g_true

1825: ,p_qty IN NUMBER
1826: ,p_qty_type IN NUMBER := 0
1827: ,p_trans_date IN DATE
1828: ,p_ignore_exception IN VARCHAR2 := fnd_api.g_false
1829: ,p_adjust_cmplt IN VARCHAR2 := fnd_api.g_true
1830: ,x_exception_material_tbl OUT NOCOPY gme_common_pvt.exceptions_tab);
1831: /*#
1832: * Create Material Transaction Procedure
1833: * This procedure Creates a Material Transaction.

Line 1875: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false

1871: PROCEDURE create_material_txn (
1872: p_api_version IN NUMBER := 2.0
1873: ,p_validation_level IN NUMBER
1874: := gme_common_pvt.g_max_errors
1875: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
1876: ,p_commit IN VARCHAR2 := fnd_api.g_false
1877: ,p_save_batch IN VARCHAR2 := fnd_api.g_true -- Bug 14685438
1878: ,x_message_count OUT NOCOPY NUMBER
1879: ,x_message_list OUT NOCOPY VARCHAR2

Line 1876: ,p_commit IN VARCHAR2 := fnd_api.g_false

1872: p_api_version IN NUMBER := 2.0
1873: ,p_validation_level IN NUMBER
1874: := gme_common_pvt.g_max_errors
1875: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
1876: ,p_commit IN VARCHAR2 := fnd_api.g_false
1877: ,p_save_batch IN VARCHAR2 := fnd_api.g_true -- Bug 14685438
1878: ,x_message_count OUT NOCOPY NUMBER
1879: ,x_message_list OUT NOCOPY VARCHAR2
1880: ,x_return_status OUT NOCOPY VARCHAR2

Line 1877: ,p_save_batch IN VARCHAR2 := fnd_api.g_true -- Bug 14685438

1873: ,p_validation_level IN NUMBER
1874: := gme_common_pvt.g_max_errors
1875: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
1876: ,p_commit IN VARCHAR2 := fnd_api.g_false
1877: ,p_save_batch IN VARCHAR2 := fnd_api.g_true -- Bug 14685438
1878: ,x_message_count OUT NOCOPY NUMBER
1879: ,x_message_list OUT NOCOPY VARCHAR2
1880: ,x_return_status OUT NOCOPY VARCHAR2
1881: ,p_org_code IN VARCHAR2 := NULL

Line 1932: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false

1928: PROCEDURE update_material_txn (
1929: p_api_version IN NUMBER := 2.0
1930: ,p_validation_level IN NUMBER
1931: := gme_common_pvt.g_max_errors
1932: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
1933: ,p_commit IN VARCHAR2 := fnd_api.g_false
1934: ,x_message_count OUT NOCOPY NUMBER
1935: ,x_message_list OUT NOCOPY VARCHAR2
1936: ,x_return_status OUT NOCOPY VARCHAR2

Line 1933: ,p_commit IN VARCHAR2 := fnd_api.g_false

1929: p_api_version IN NUMBER := 2.0
1930: ,p_validation_level IN NUMBER
1931: := gme_common_pvt.g_max_errors
1932: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
1933: ,p_commit IN VARCHAR2 := fnd_api.g_false
1934: ,x_message_count OUT NOCOPY NUMBER
1935: ,x_message_list OUT NOCOPY VARCHAR2
1936: ,x_return_status OUT NOCOPY VARCHAR2
1937: ,p_transaction_id IN NUMBER

Line 1978: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false

1974: PROCEDURE delete_material_txn (
1975: p_api_version IN NUMBER := 2.0
1976: ,p_validation_level IN NUMBER
1977: := gme_common_pvt.g_max_errors
1978: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
1979: ,p_commit IN VARCHAR2 := fnd_api.g_false
1980: ,x_message_count OUT NOCOPY NUMBER
1981: ,x_message_list OUT NOCOPY VARCHAR2
1982: ,x_return_status OUT NOCOPY VARCHAR2

Line 1979: ,p_commit IN VARCHAR2 := fnd_api.g_false

1975: p_api_version IN NUMBER := 2.0
1976: ,p_validation_level IN NUMBER
1977: := gme_common_pvt.g_max_errors
1978: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
1979: ,p_commit IN VARCHAR2 := fnd_api.g_false
1980: ,x_message_count OUT NOCOPY NUMBER
1981: ,x_message_list OUT NOCOPY VARCHAR2
1982: ,x_return_status OUT NOCOPY VARCHAR2
1983: ,p_transaction_id IN NUMBER);

Line 2033: DEFAULT fnd_api.g_false

2029: p_api_version IN NUMBER := 2.0
2030: ,p_validation_level IN NUMBER
2031: := gme_common_pvt.g_max_errors
2032: ,p_init_msg_list IN VARCHAR2
2033: DEFAULT fnd_api.g_false
2034: ,p_commit IN VARCHAR2
2035: DEFAULT fnd_api.g_false
2036: ,p_batch_header_rec IN gme_batch_header%ROWTYPE
2037: ,p_validity_rule_id IN NUMBER

Line 2035: DEFAULT fnd_api.g_false

2031: := gme_common_pvt.g_max_errors
2032: ,p_init_msg_list IN VARCHAR2
2033: DEFAULT fnd_api.g_false
2034: ,p_commit IN VARCHAR2
2035: DEFAULT fnd_api.g_false
2036: ,p_batch_header_rec IN gme_batch_header%ROWTYPE
2037: ,p_validity_rule_id IN NUMBER
2038: ,p_org_code IN VARCHAR2
2039: ,p_use_workday_cal IN VARCHAR2

Line 2040: DEFAULT fnd_api.g_false

2036: ,p_batch_header_rec IN gme_batch_header%ROWTYPE
2037: ,p_validity_rule_id IN NUMBER
2038: ,p_org_code IN VARCHAR2
2039: ,p_use_workday_cal IN VARCHAR2
2040: DEFAULT fnd_api.g_false
2041: ,p_contiguity_override IN VARCHAR2
2042: DEFAULT fnd_api.g_false
2043: ,x_message_count OUT NOCOPY NUMBER
2044: ,x_message_list OUT NOCOPY VARCHAR2

Line 2042: DEFAULT fnd_api.g_false

2038: ,p_org_code IN VARCHAR2
2039: ,p_use_workday_cal IN VARCHAR2
2040: DEFAULT fnd_api.g_false
2041: ,p_contiguity_override IN VARCHAR2
2042: DEFAULT fnd_api.g_false
2043: ,x_message_count OUT NOCOPY NUMBER
2044: ,x_message_list OUT NOCOPY VARCHAR2
2045: ,x_return_status OUT NOCOPY VARCHAR2
2046: ,x_batch_header_rec OUT NOCOPY gme_batch_header%ROWTYPE);

Line 2092: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false

2088: PROCEDURE terminate_batch (
2089: p_api_version IN NUMBER := 2.0
2090: ,p_validation_level IN NUMBER
2091: := gme_common_pvt.g_max_errors
2092: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
2093: ,p_commit IN VARCHAR2 := fnd_api.g_false
2094: ,x_message_count OUT NOCOPY NUMBER
2095: ,x_message_list OUT NOCOPY VARCHAR2
2096: ,x_return_status OUT NOCOPY VARCHAR2

Line 2093: ,p_commit IN VARCHAR2 := fnd_api.g_false

2089: p_api_version IN NUMBER := 2.0
2090: ,p_validation_level IN NUMBER
2091: := gme_common_pvt.g_max_errors
2092: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
2093: ,p_commit IN VARCHAR2 := fnd_api.g_false
2094: ,x_message_count OUT NOCOPY NUMBER
2095: ,x_message_list OUT NOCOPY VARCHAR2
2096: ,x_return_status OUT NOCOPY VARCHAR2
2097: ,p_org_code IN VARCHAR2

Line 2168: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false

2164: PROCEDURE convert_dtl_reservation (
2165: p_api_version IN NUMBER := 2.0
2166: ,p_validation_level IN NUMBER
2167: := gme_common_pvt.g_max_errors
2168: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
2169: ,p_commit IN VARCHAR2 := fnd_api.g_false
2170: ,x_message_count OUT NOCOPY NUMBER
2171: ,x_message_list OUT NOCOPY VARCHAR2
2172: ,x_return_status OUT NOCOPY VARCHAR2

Line 2169: ,p_commit IN VARCHAR2 := fnd_api.g_false

2165: p_api_version IN NUMBER := 2.0
2166: ,p_validation_level IN NUMBER
2167: := gme_common_pvt.g_max_errors
2168: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
2169: ,p_commit IN VARCHAR2 := fnd_api.g_false
2170: ,x_message_count OUT NOCOPY NUMBER
2171: ,x_message_list OUT NOCOPY VARCHAR2
2172: ,x_return_status OUT NOCOPY VARCHAR2
2173: ,p_reservation_rec IN mtl_reservations%ROWTYPE

Line 2241: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false

2237: PROCEDURE insert_batchstep_resource (
2238: p_api_version IN NUMBER
2239: ,p_validation_level IN NUMBER
2240: := gme_common_pvt.g_max_errors
2241: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
2242: ,p_commit IN VARCHAR2 := fnd_api.g_false
2243: ,p_batchstep_resource_rec IN gme_batch_step_resources%ROWTYPE
2244: ,p_org_code IN VARCHAR2 := NULL
2245: ,p_batch_no IN VARCHAR2 := NULL

Line 2242: ,p_commit IN VARCHAR2 := fnd_api.g_false

2238: p_api_version IN NUMBER
2239: ,p_validation_level IN NUMBER
2240: := gme_common_pvt.g_max_errors
2241: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
2242: ,p_commit IN VARCHAR2 := fnd_api.g_false
2243: ,p_batchstep_resource_rec IN gme_batch_step_resources%ROWTYPE
2244: ,p_org_code IN VARCHAR2 := NULL
2245: ,p_batch_no IN VARCHAR2 := NULL
2246: ,p_batchstep_no IN NUMBER := NULL

Line 2248: ,p_ignore_qty_below_cap IN VARCHAR2 := fnd_api.g_false

2244: ,p_org_code IN VARCHAR2 := NULL
2245: ,p_batch_no IN VARCHAR2 := NULL
2246: ,p_batchstep_no IN NUMBER := NULL
2247: ,p_activity IN VARCHAR2 := NULL
2248: ,p_ignore_qty_below_cap IN VARCHAR2 := fnd_api.g_false
2249: ,p_validate_flexfields IN VARCHAR2 := fnd_api.g_false
2250: ,x_batchstep_resource_rec OUT NOCOPY gme_batch_step_resources%ROWTYPE
2251: ,x_message_count OUT NOCOPY NUMBER
2252: ,x_message_list OUT NOCOPY VARCHAR2

Line 2249: ,p_validate_flexfields IN VARCHAR2 := fnd_api.g_false

2245: ,p_batch_no IN VARCHAR2 := NULL
2246: ,p_batchstep_no IN NUMBER := NULL
2247: ,p_activity IN VARCHAR2 := NULL
2248: ,p_ignore_qty_below_cap IN VARCHAR2 := fnd_api.g_false
2249: ,p_validate_flexfields IN VARCHAR2 := fnd_api.g_false
2250: ,x_batchstep_resource_rec OUT NOCOPY gme_batch_step_resources%ROWTYPE
2251: ,x_message_count OUT NOCOPY NUMBER
2252: ,x_message_list OUT NOCOPY VARCHAR2
2253: ,x_return_status OUT NOCOPY VARCHAR2);

Line 2311: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false

2307: PROCEDURE update_batchstep_resource (
2308: p_api_version IN NUMBER
2309: ,p_validation_level IN NUMBER
2310: := gme_common_pvt.g_max_errors
2311: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
2312: ,p_commit IN VARCHAR2 := fnd_api.g_false
2313: ,p_batchstep_resource_rec IN gme_batch_step_resources%ROWTYPE
2314: ,p_org_code IN VARCHAR2 := NULL
2315: ,p_batch_no IN VARCHAR2 := NULL

Line 2312: ,p_commit IN VARCHAR2 := fnd_api.g_false

2308: p_api_version IN NUMBER
2309: ,p_validation_level IN NUMBER
2310: := gme_common_pvt.g_max_errors
2311: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
2312: ,p_commit IN VARCHAR2 := fnd_api.g_false
2313: ,p_batchstep_resource_rec IN gme_batch_step_resources%ROWTYPE
2314: ,p_org_code IN VARCHAR2 := NULL
2315: ,p_batch_no IN VARCHAR2 := NULL
2316: ,p_batchstep_no IN NUMBER := NULL

Line 2318: ,p_ignore_qty_below_cap IN VARCHAR2 := fnd_api.g_false

2314: ,p_org_code IN VARCHAR2 := NULL
2315: ,p_batch_no IN VARCHAR2 := NULL
2316: ,p_batchstep_no IN NUMBER := NULL
2317: ,p_activity IN VARCHAR2 := NULL
2318: ,p_ignore_qty_below_cap IN VARCHAR2 := fnd_api.g_false
2319: ,p_validate_flexfields IN VARCHAR2 := fnd_api.g_false
2320: ,x_batchstep_resource_rec OUT NOCOPY gme_batch_step_resources%ROWTYPE
2321: ,x_message_count OUT NOCOPY NUMBER
2322: ,x_message_list OUT NOCOPY VARCHAR2

Line 2319: ,p_validate_flexfields IN VARCHAR2 := fnd_api.g_false

2315: ,p_batch_no IN VARCHAR2 := NULL
2316: ,p_batchstep_no IN NUMBER := NULL
2317: ,p_activity IN VARCHAR2 := NULL
2318: ,p_ignore_qty_below_cap IN VARCHAR2 := fnd_api.g_false
2319: ,p_validate_flexfields IN VARCHAR2 := fnd_api.g_false
2320: ,x_batchstep_resource_rec OUT NOCOPY gme_batch_step_resources%ROWTYPE
2321: ,x_message_count OUT NOCOPY NUMBER
2322: ,x_message_list OUT NOCOPY VARCHAR2
2323: ,x_return_status OUT NOCOPY VARCHAR2);

Line 2372: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false

2368: PROCEDURE delete_batchstep_resource (
2369: p_api_version IN NUMBER := 2.0
2370: ,p_validation_level IN NUMBER
2371: := gme_common_pvt.g_max_errors
2372: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
2373: ,p_commit IN VARCHAR2 := fnd_api.g_false
2374: ,p_batchstep_resource_id IN NUMBER := NULL
2375: ,p_org_code IN VARCHAR2 := NULL
2376: ,p_batch_no IN VARCHAR2 := NULL

Line 2373: ,p_commit IN VARCHAR2 := fnd_api.g_false

2369: p_api_version IN NUMBER := 2.0
2370: ,p_validation_level IN NUMBER
2371: := gme_common_pvt.g_max_errors
2372: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
2373: ,p_commit IN VARCHAR2 := fnd_api.g_false
2374: ,p_batchstep_resource_id IN NUMBER := NULL
2375: ,p_org_code IN VARCHAR2 := NULL
2376: ,p_batch_no IN VARCHAR2 := NULL
2377: ,p_batchstep_no IN NUMBER := NULL

Line 2436: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false

2432: PROCEDURE auto_detail_line (
2433: p_api_version IN NUMBER := 2.0
2434: ,p_validation_level IN NUMBER
2435: := gme_common_pvt.g_max_errors
2436: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
2437: ,p_commit IN VARCHAR2 := fnd_api.g_false
2438: ,x_message_count OUT NOCOPY NUMBER
2439: ,x_message_list OUT NOCOPY VARCHAR2
2440: ,x_return_status OUT NOCOPY VARCHAR2

Line 2437: ,p_commit IN VARCHAR2 := fnd_api.g_false

2433: p_api_version IN NUMBER := 2.0
2434: ,p_validation_level IN NUMBER
2435: := gme_common_pvt.g_max_errors
2436: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
2437: ,p_commit IN VARCHAR2 := fnd_api.g_false
2438: ,x_message_count OUT NOCOPY NUMBER
2439: ,x_message_list OUT NOCOPY VARCHAR2
2440: ,x_return_status OUT NOCOPY VARCHAR2
2441: ,p_material_detail_id IN NUMBER

Line 2487: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE

2483: p_batch_rec (R) Production batch
2484: ================================================================================*/
2485:
2486: PROCEDURE auto_detail_batch (p_api_version IN NUMBER := 2.0
2487: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
2488: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
2489: ,x_message_count OUT NOCOPY NUMBER
2490: ,x_message_list OUT NOCOPY VARCHAR2
2491: ,x_return_status OUT NOCOPY VARCHAR2

Line 2488: ,p_commit IN VARCHAR2 := FND_API.G_FALSE

2484: ================================================================================*/
2485:
2486: PROCEDURE auto_detail_batch (p_api_version IN NUMBER := 2.0
2487: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
2488: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
2489: ,x_message_count OUT NOCOPY NUMBER
2490: ,x_message_list OUT NOCOPY VARCHAR2
2491: ,x_return_status OUT NOCOPY VARCHAR2
2492: ,p_org_code IN VARCHAR2

Line 2541: DEFAULT fnd_api.g_false,

2537: p_api_version IN NUMBER ,
2538: p_validation_level IN NUMBER
2539: := gme_common_pvt.g_max_errors,
2540: p_init_msg_list IN VARCHAR2
2541: DEFAULT fnd_api.g_false,
2542: p_commit IN VARCHAR2
2543: DEFAULT fnd_api.g_false,
2544: p_org_code IN VARCHAR2,
2545: p_batchstep_activity_rec IN gme_batch_step_activities%ROWTYPE,

Line 2543: DEFAULT fnd_api.g_false,

2539: := gme_common_pvt.g_max_errors,
2540: p_init_msg_list IN VARCHAR2
2541: DEFAULT fnd_api.g_false,
2542: p_commit IN VARCHAR2
2543: DEFAULT fnd_api.g_false,
2544: p_org_code IN VARCHAR2,
2545: p_batchstep_activity_rec IN gme_batch_step_activities%ROWTYPE,
2546: p_batchstep_resource_tbl IN gme_create_step_pvt.resources_tab,
2547: p_batch_no IN VARCHAR2 := NULL,

Line 2550: DEFAULT fnd_api.g_false,

2546: p_batchstep_resource_tbl IN gme_create_step_pvt.resources_tab,
2547: p_batch_no IN VARCHAR2 := NULL,
2548: p_batchstep_no IN NUMBER := NULL,
2549: p_ignore_qty_below_cap IN VARCHAR2
2550: DEFAULT fnd_api.g_false,
2551: p_validate_flexfield IN VARCHAR2
2552: DEFAULT fnd_api.g_false,
2553: x_batchstep_activity_rec OUT NOCOPY gme_batch_step_activities%ROWTYPE,
2554: x_message_count OUT NOCOPY NUMBER,

Line 2552: DEFAULT fnd_api.g_false,

2548: p_batchstep_no IN NUMBER := NULL,
2549: p_ignore_qty_below_cap IN VARCHAR2
2550: DEFAULT fnd_api.g_false,
2551: p_validate_flexfield IN VARCHAR2
2552: DEFAULT fnd_api.g_false,
2553: x_batchstep_activity_rec OUT NOCOPY gme_batch_step_activities%ROWTYPE,
2554: x_message_count OUT NOCOPY NUMBER,
2555: x_message_list OUT NOCOPY VARCHAR2,
2556: x_return_status OUT NOCOPY VARCHAR2

Line 2602: DEFAULT fnd_api.g_false,

2598: p_api_version IN NUMBER ,
2599: p_validation_level IN NUMBER
2600: := gme_common_pvt.g_max_errors,
2601: p_init_msg_list IN VARCHAR2
2602: DEFAULT fnd_api.g_false,
2603: p_commit IN VARCHAR2
2604: DEFAULT fnd_api.g_false,
2605: p_org_code IN VARCHAR2,
2606: p_batchstep_activity_rec IN gme_batch_step_activities%ROWTYPE,

Line 2604: DEFAULT fnd_api.g_false,

2600: := gme_common_pvt.g_max_errors,
2601: p_init_msg_list IN VARCHAR2
2602: DEFAULT fnd_api.g_false,
2603: p_commit IN VARCHAR2
2604: DEFAULT fnd_api.g_false,
2605: p_org_code IN VARCHAR2,
2606: p_batchstep_activity_rec IN gme_batch_step_activities%ROWTYPE,
2607: p_batch_no IN VARCHAR2 := NULL,
2608: p_batchstep_no IN NUMBER := NULL,

Line 2610: DEFAULT fnd_api.g_false,

2606: p_batchstep_activity_rec IN gme_batch_step_activities%ROWTYPE,
2607: p_batch_no IN VARCHAR2 := NULL,
2608: p_batchstep_no IN NUMBER := NULL,
2609: p_validate_flexfield IN VARCHAR2
2610: DEFAULT fnd_api.g_false,
2611: x_batchstep_activity_rec OUT NOCOPY gme_batch_step_activities%ROWTYPE,
2612: x_message_count OUT NOCOPY NUMBER,
2613: x_message_list OUT NOCOPY VARCHAR2,
2614: x_return_status OUT NOCOPY VARCHAR2

Line 2662: DEFAULT fnd_api.g_false,

2658: p_api_version IN NUMBER := 2.0,
2659: p_validation_level IN NUMBER
2660: := gme_common_pvt.g_max_errors,
2661: p_init_msg_list IN VARCHAR2
2662: DEFAULT fnd_api.g_false,
2663: p_commit IN VARCHAR2
2664: DEFAULT fnd_api.g_false,
2665: p_org_code IN VARCHAR2,
2666: p_batchstep_activity_id IN NUMBER := NULL,

Line 2664: DEFAULT fnd_api.g_false,

2660: := gme_common_pvt.g_max_errors,
2661: p_init_msg_list IN VARCHAR2
2662: DEFAULT fnd_api.g_false,
2663: p_commit IN VARCHAR2
2664: DEFAULT fnd_api.g_false,
2665: p_org_code IN VARCHAR2,
2666: p_batchstep_activity_id IN NUMBER := NULL,
2667: p_batch_no IN VARCHAR2 := NULL,
2668: p_batchstep_no IN NUMBER := NULL,

Line 2747: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false

2743:
2744: PROCEDURE convert_fpo (
2745: p_api_version IN NUMBER := 2.0
2746: ,p_validation_level IN NUMBER := gme_common_pvt.g_max_errors
2747: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
2748: ,p_commit IN VARCHAR2 := fnd_api.g_false
2749: ,x_message_count OUT NOCOPY NUMBER
2750: ,x_message_list OUT NOCOPY VARCHAR2
2751: ,p_enforce_vldt_check IN VARCHAR2 := fnd_api.g_true

Line 2748: ,p_commit IN VARCHAR2 := fnd_api.g_false

2744: PROCEDURE convert_fpo (
2745: p_api_version IN NUMBER := 2.0
2746: ,p_validation_level IN NUMBER := gme_common_pvt.g_max_errors
2747: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
2748: ,p_commit IN VARCHAR2 := fnd_api.g_false
2749: ,x_message_count OUT NOCOPY NUMBER
2750: ,x_message_list OUT NOCOPY VARCHAR2
2751: ,p_enforce_vldt_check IN VARCHAR2 := fnd_api.g_true
2752: ,x_return_status OUT NOCOPY VARCHAR2

Line 2751: ,p_enforce_vldt_check IN VARCHAR2 := fnd_api.g_true

2747: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
2748: ,p_commit IN VARCHAR2 := fnd_api.g_false
2749: ,x_message_count OUT NOCOPY NUMBER
2750: ,x_message_list OUT NOCOPY VARCHAR2
2751: ,p_enforce_vldt_check IN VARCHAR2 := fnd_api.g_true
2752: ,x_return_status OUT NOCOPY VARCHAR2
2753: ,p_org_code IN VARCHAR2 := NULL
2754: ,p_batch_header IN gme_batch_header%ROWTYPE
2755: ,x_batch_header OUT NOCOPY gme_batch_header%ROWTYPE

Line 2765: ,p_use_shop_cal IN VARCHAR2 := fnd_api.g_false

2761: ,p_batch_offset IN NUMBER DEFAULT 0
2762: ,p_offset_type IN NUMBER DEFAULT 0
2763: ,p_plan_start_date IN gme_batch_header.plan_start_date%TYPE
2764: ,p_plan_cmplt_date IN gme_batch_header.plan_cmplt_date%TYPE
2765: ,p_use_shop_cal IN VARCHAR2 := fnd_api.g_false
2766: ,p_contiguity_override IN VARCHAR2 := fnd_api.g_true
2767: ,p_use_for_all IN VARCHAR2 := fnd_api.g_true);
2768:
2769: /*#

Line 2766: ,p_contiguity_override IN VARCHAR2 := fnd_api.g_true

2762: ,p_offset_type IN NUMBER DEFAULT 0
2763: ,p_plan_start_date IN gme_batch_header.plan_start_date%TYPE
2764: ,p_plan_cmplt_date IN gme_batch_header.plan_cmplt_date%TYPE
2765: ,p_use_shop_cal IN VARCHAR2 := fnd_api.g_false
2766: ,p_contiguity_override IN VARCHAR2 := fnd_api.g_true
2767: ,p_use_for_all IN VARCHAR2 := fnd_api.g_true);
2768:
2769: /*#
2770: * Create a pending product lot. Note that identification must be provided:

Line 2767: ,p_use_for_all IN VARCHAR2 := fnd_api.g_true);

2763: ,p_plan_start_date IN gme_batch_header.plan_start_date%TYPE
2764: ,p_plan_cmplt_date IN gme_batch_header.plan_cmplt_date%TYPE
2765: ,p_use_shop_cal IN VARCHAR2 := fnd_api.g_false
2766: ,p_contiguity_override IN VARCHAR2 := fnd_api.g_true
2767: ,p_use_for_all IN VARCHAR2 := fnd_api.g_true);
2768:
2769: /*#
2770: * Create a pending product lot. Note that identification must be provided:
2771: * material detail id or batch_id, line_no, line_type or

Line 2837: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false

2833: PROCEDURE create_pending_product_lot
2834: (p_api_version IN NUMBER
2835: ,p_validation_level IN NUMBER
2836: := gme_common_pvt.g_max_errors
2837: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
2838: ,p_commit IN VARCHAR2 := fnd_api.g_false
2839: ,x_message_count OUT NOCOPY NUMBER
2840: ,x_message_list OUT NOCOPY VARCHAR2
2841: ,x_return_status OUT NOCOPY VARCHAR2

Line 2838: ,p_commit IN VARCHAR2 := fnd_api.g_false

2834: (p_api_version IN NUMBER
2835: ,p_validation_level IN NUMBER
2836: := gme_common_pvt.g_max_errors
2837: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
2838: ,p_commit IN VARCHAR2 := fnd_api.g_false
2839: ,x_message_count OUT NOCOPY NUMBER
2840: ,x_message_list OUT NOCOPY VARCHAR2
2841: ,x_return_status OUT NOCOPY VARCHAR2
2842: ,p_batch_header_rec IN gme_batch_header%ROWTYPE

Line 2844: ,p_create_lot IN VARCHAR2 := fnd_api.g_false

2840: ,x_message_list OUT NOCOPY VARCHAR2
2841: ,x_return_status OUT NOCOPY VARCHAR2
2842: ,p_batch_header_rec IN gme_batch_header%ROWTYPE
2843: ,p_org_code IN VARCHAR2
2844: ,p_create_lot IN VARCHAR2 := fnd_api.g_false
2845: ,p_generate_lot IN VARCHAR2 := fnd_api.g_false
2846: ,p_generate_parent_lot IN VARCHAR2 := fnd_api.g_false
2847: ,p_parent_lot IN mtl_lot_numbers.lot_number%TYPE := NULL
2848: ,p_material_detail_rec IN gme_material_details%ROWTYPE

Line 2845: ,p_generate_lot IN VARCHAR2 := fnd_api.g_false

2841: ,x_return_status OUT NOCOPY VARCHAR2
2842: ,p_batch_header_rec IN gme_batch_header%ROWTYPE
2843: ,p_org_code IN VARCHAR2
2844: ,p_create_lot IN VARCHAR2 := fnd_api.g_false
2845: ,p_generate_lot IN VARCHAR2 := fnd_api.g_false
2846: ,p_generate_parent_lot IN VARCHAR2 := fnd_api.g_false
2847: ,p_parent_lot IN mtl_lot_numbers.lot_number%TYPE := NULL
2848: ,p_material_detail_rec IN gme_material_details%ROWTYPE
2849: /* nsinghi bug#4486074 Added the p_expiration_dt parameter. */

Line 2846: ,p_generate_parent_lot IN VARCHAR2 := fnd_api.g_false

2842: ,p_batch_header_rec IN gme_batch_header%ROWTYPE
2843: ,p_org_code IN VARCHAR2
2844: ,p_create_lot IN VARCHAR2 := fnd_api.g_false
2845: ,p_generate_lot IN VARCHAR2 := fnd_api.g_false
2846: ,p_generate_parent_lot IN VARCHAR2 := fnd_api.g_false
2847: ,p_parent_lot IN mtl_lot_numbers.lot_number%TYPE := NULL
2848: ,p_material_detail_rec IN gme_material_details%ROWTYPE
2849: /* nsinghi bug#4486074 Added the p_expiration_dt parameter. */
2850: ,p_expiration_date IN mtl_lot_numbers.expiration_date%TYPE := NULL

Line 2900: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false

2896: PROCEDURE update_pending_product_lot
2897: (p_api_version IN NUMBER
2898: ,p_validation_level IN NUMBER
2899: := gme_common_pvt.g_max_errors
2900: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
2901: ,p_commit IN VARCHAR2 := fnd_api.g_false
2902: ,x_message_count OUT NOCOPY NUMBER
2903: ,x_message_list OUT NOCOPY VARCHAR2
2904: ,x_return_status OUT NOCOPY VARCHAR2

Line 2901: ,p_commit IN VARCHAR2 := fnd_api.g_false

2897: (p_api_version IN NUMBER
2898: ,p_validation_level IN NUMBER
2899: := gme_common_pvt.g_max_errors
2900: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
2901: ,p_commit IN VARCHAR2 := fnd_api.g_false
2902: ,x_message_count OUT NOCOPY NUMBER
2903: ,x_message_list OUT NOCOPY VARCHAR2
2904: ,x_return_status OUT NOCOPY VARCHAR2
2905: ,p_batch_header_rec IN gme_batch_header%ROWTYPE

Line 2956: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false

2952: PROCEDURE delete_pending_product_lot
2953: (p_api_version IN NUMBER
2954: ,p_validation_level IN NUMBER
2955: := gme_common_pvt.g_max_errors
2956: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
2957: ,p_commit IN VARCHAR2 := fnd_api.g_false
2958: ,x_message_count OUT NOCOPY NUMBER
2959: ,x_message_list OUT NOCOPY VARCHAR2
2960: ,x_return_status OUT NOCOPY VARCHAR2

Line 2957: ,p_commit IN VARCHAR2 := fnd_api.g_false

2953: (p_api_version IN NUMBER
2954: ,p_validation_level IN NUMBER
2955: := gme_common_pvt.g_max_errors
2956: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
2957: ,p_commit IN VARCHAR2 := fnd_api.g_false
2958: ,x_message_count OUT NOCOPY NUMBER
2959: ,x_message_list OUT NOCOPY VARCHAR2
2960: ,x_return_status OUT NOCOPY VARCHAR2
2961: ,p_batch_header_rec IN gme_batch_header%ROWTYPE

Line 3011: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false

3007: PROCEDURE unrelease_batch
3008: (p_api_version IN NUMBER
3009: ,p_validation_level IN NUMBER
3010: := gme_common_pvt.g_max_errors
3011: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
3012: ,p_commit IN VARCHAR2 := fnd_api.g_false
3013: ,x_message_count OUT NOCOPY NUMBER
3014: ,x_message_list OUT NOCOPY VARCHAR2
3015: ,x_return_status OUT NOCOPY VARCHAR2

Line 3012: ,p_commit IN VARCHAR2 := fnd_api.g_false

3008: (p_api_version IN NUMBER
3009: ,p_validation_level IN NUMBER
3010: := gme_common_pvt.g_max_errors
3011: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
3012: ,p_commit IN VARCHAR2 := fnd_api.g_false
3013: ,x_message_count OUT NOCOPY NUMBER
3014: ,x_message_list OUT NOCOPY VARCHAR2
3015: ,x_return_status OUT NOCOPY VARCHAR2
3016: ,p_batch_header_rec IN gme_batch_header%ROWTYPE

Line 3069: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false

3065: PROCEDURE unrelease_step
3066: (p_api_version IN NUMBER
3067: ,p_validation_level IN NUMBER
3068: := gme_common_pvt.g_max_errors
3069: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
3070: ,p_commit IN VARCHAR2 := fnd_api.g_false
3071: ,x_message_count OUT NOCOPY NUMBER
3072: ,x_message_list OUT NOCOPY VARCHAR2
3073: ,x_return_status OUT NOCOPY VARCHAR2

Line 3070: ,p_commit IN VARCHAR2 := fnd_api.g_false

3066: (p_api_version IN NUMBER
3067: ,p_validation_level IN NUMBER
3068: := gme_common_pvt.g_max_errors
3069: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
3070: ,p_commit IN VARCHAR2 := fnd_api.g_false
3071: ,x_message_count OUT NOCOPY NUMBER
3072: ,x_message_list OUT NOCOPY VARCHAR2
3073: ,x_return_status OUT NOCOPY VARCHAR2
3074: ,p_batch_step_rec IN gme_batch_steps%ROWTYPE

Line 3115: p_validate_flexfields (O) indicates whether to validate flexfields... Defaults to fnd_api.g_false;

3111: p_batch_header_rec (O) batch header to identify the batch to complete;
3112: p_org_code (O) organization code to identify the batch is conjunction with batch_no in p_batch_header_rec
3113: p_ignore_exception (O) indicates whether to ignore exceptions; if exceptions are ignored,
3114: x_exception_material_tbl won't be populated ever if exceptions were found
3115: p_validate_flexfields (O) indicates whether to validate flexfields... Defaults to fnd_api.g_false;
3116: this is used for direct completion only because of release batch
3117: x_batch_header_rec Output batch header record after complete
3118: x_exception_material_tbl Batch exceptions found during batch complete. Won't be reported if
3119: p_ignore_exception is set to fnd_api.g_true.

Line 3119: p_ignore_exception is set to fnd_api.g_true.

3115: p_validate_flexfields (O) indicates whether to validate flexfields... Defaults to fnd_api.g_false;
3116: this is used for direct completion only because of release batch
3117: x_batch_header_rec Output batch header record after complete
3118: x_exception_material_tbl Batch exceptions found during batch complete. Won't be reported if
3119: p_ignore_exception is set to fnd_api.g_true.
3120: x_return_status outcome of the API call
3121: S - Success
3122: E - Error
3123: U - Unexpected Error

Line 3130: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false

3126: PROCEDURE complete_batch
3127: (p_api_version IN NUMBER
3128: ,p_validation_level IN NUMBER
3129: := gme_common_pvt.g_max_errors
3130: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
3131: ,p_commit IN VARCHAR2 := fnd_api.g_false
3132: ,x_message_count OUT NOCOPY NUMBER
3133: ,x_message_list OUT NOCOPY VARCHAR2
3134: ,x_return_status OUT NOCOPY VARCHAR2

Line 3131: ,p_commit IN VARCHAR2 := fnd_api.g_false

3127: (p_api_version IN NUMBER
3128: ,p_validation_level IN NUMBER
3129: := gme_common_pvt.g_max_errors
3130: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
3131: ,p_commit IN VARCHAR2 := fnd_api.g_false
3132: ,x_message_count OUT NOCOPY NUMBER
3133: ,x_message_list OUT NOCOPY VARCHAR2
3134: ,x_return_status OUT NOCOPY VARCHAR2
3135: ,p_batch_header_rec IN gme_batch_header%ROWTYPE

Line 3137: ,p_ignore_exception IN VARCHAR2 := fnd_api.g_false

3133: ,x_message_list OUT NOCOPY VARCHAR2
3134: ,x_return_status OUT NOCOPY VARCHAR2
3135: ,p_batch_header_rec IN gme_batch_header%ROWTYPE
3136: ,p_org_code IN VARCHAR2
3137: ,p_ignore_exception IN VARCHAR2 := fnd_api.g_false
3138: ,p_validate_flexfields IN VARCHAR2 := fnd_api.g_false
3139: ,x_batch_header_rec OUT NOCOPY gme_batch_header%ROWTYPE
3140: ,x_exception_material_tbl OUT NOCOPY gme_common_pvt.exceptions_tab);
3141:

Line 3138: ,p_validate_flexfields IN VARCHAR2 := fnd_api.g_false

3134: ,x_return_status OUT NOCOPY VARCHAR2
3135: ,p_batch_header_rec IN gme_batch_header%ROWTYPE
3136: ,p_org_code IN VARCHAR2
3137: ,p_ignore_exception IN VARCHAR2 := fnd_api.g_false
3138: ,p_validate_flexfields IN VARCHAR2 := fnd_api.g_false
3139: ,x_batch_header_rec OUT NOCOPY gme_batch_header%ROWTYPE
3140: ,x_exception_material_tbl OUT NOCOPY gme_common_pvt.exceptions_tab);
3141:
3142: /*#

Line 3183: p_override_quality (O) Override quality indicator; defaults to fnd_api.g_false

3179: p_batch_no (O) batch_no to identify the step
3180: p_org_code (O) organization code to identify the step is conjunction with batch_no in p_batch_header_rec
3181: p_ignore_exception (O) indicates whether to ignore exceptions; if exceptions are ignored,
3182: x_exception_material_tbl won't be populated ever if exceptions were found
3183: p_override_quality (O) Override quality indicator; defaults to fnd_api.g_false
3184: p_validate_flexfields (O) indicates whether to validate flexfields... Defaults to fnd_api.g_false;
3185: this is used for direct step completion (pending_batch) only, because of release batch
3186: x_batch_step_rec Output batch step record after complete
3187: x_exception_material_tbl Material exceptions found in complete step (only those associated to step)

Line 3184: p_validate_flexfields (O) indicates whether to validate flexfields... Defaults to fnd_api.g_false;

3180: p_org_code (O) organization code to identify the step is conjunction with batch_no in p_batch_header_rec
3181: p_ignore_exception (O) indicates whether to ignore exceptions; if exceptions are ignored,
3182: x_exception_material_tbl won't be populated ever if exceptions were found
3183: p_override_quality (O) Override quality indicator; defaults to fnd_api.g_false
3184: p_validate_flexfields (O) indicates whether to validate flexfields... Defaults to fnd_api.g_false;
3185: this is used for direct step completion (pending_batch) only, because of release batch
3186: x_batch_step_rec Output batch step record after complete
3187: x_exception_material_tbl Material exceptions found in complete step (only those associated to step)
3188: x_return_status outcome of the API call

Line 3198: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false

3194: PROCEDURE complete_step
3195: (p_api_version IN NUMBER
3196: ,p_validation_level IN NUMBER
3197: := gme_common_pvt.g_max_errors
3198: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
3199: ,p_commit IN VARCHAR2 := fnd_api.g_false
3200: ,p_save_batch IN VARCHAR2 := fnd_api.g_true -- Bug 16079623
3201: ,x_message_count OUT NOCOPY NUMBER
3202: ,x_message_list OUT NOCOPY VARCHAR2

Line 3199: ,p_commit IN VARCHAR2 := fnd_api.g_false

3195: (p_api_version IN NUMBER
3196: ,p_validation_level IN NUMBER
3197: := gme_common_pvt.g_max_errors
3198: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
3199: ,p_commit IN VARCHAR2 := fnd_api.g_false
3200: ,p_save_batch IN VARCHAR2 := fnd_api.g_true -- Bug 16079623
3201: ,x_message_count OUT NOCOPY NUMBER
3202: ,x_message_list OUT NOCOPY VARCHAR2
3203: ,x_return_status OUT NOCOPY VARCHAR2

Line 3200: ,p_save_batch IN VARCHAR2 := fnd_api.g_true -- Bug 16079623

3196: ,p_validation_level IN NUMBER
3197: := gme_common_pvt.g_max_errors
3198: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
3199: ,p_commit IN VARCHAR2 := fnd_api.g_false
3200: ,p_save_batch IN VARCHAR2 := fnd_api.g_true -- Bug 16079623
3201: ,x_message_count OUT NOCOPY NUMBER
3202: ,x_message_list OUT NOCOPY VARCHAR2
3203: ,x_return_status OUT NOCOPY VARCHAR2
3204: ,p_batch_step_rec IN gme_batch_steps%ROWTYPE

Line 3207: ,p_ignore_exception IN VARCHAR2 := fnd_api.g_false

3203: ,x_return_status OUT NOCOPY VARCHAR2
3204: ,p_batch_step_rec IN gme_batch_steps%ROWTYPE
3205: ,p_batch_no IN VARCHAR2
3206: ,p_org_code IN VARCHAR2
3207: ,p_ignore_exception IN VARCHAR2 := fnd_api.g_false
3208: ,p_override_quality IN VARCHAR2 := fnd_api.g_false
3209: ,p_validate_flexfields IN VARCHAR2 := fnd_api.g_false
3210: ,x_batch_step_rec OUT NOCOPY gme_batch_steps%ROWTYPE
3211: ,x_exception_material_tbl OUT NOCOPY gme_common_pvt.exceptions_tab);

Line 3208: ,p_override_quality IN VARCHAR2 := fnd_api.g_false

3204: ,p_batch_step_rec IN gme_batch_steps%ROWTYPE
3205: ,p_batch_no IN VARCHAR2
3206: ,p_org_code IN VARCHAR2
3207: ,p_ignore_exception IN VARCHAR2 := fnd_api.g_false
3208: ,p_override_quality IN VARCHAR2 := fnd_api.g_false
3209: ,p_validate_flexfields IN VARCHAR2 := fnd_api.g_false
3210: ,x_batch_step_rec OUT NOCOPY gme_batch_steps%ROWTYPE
3211: ,x_exception_material_tbl OUT NOCOPY gme_common_pvt.exceptions_tab);
3212:

Line 3209: ,p_validate_flexfields IN VARCHAR2 := fnd_api.g_false

3205: ,p_batch_no IN VARCHAR2
3206: ,p_org_code IN VARCHAR2
3207: ,p_ignore_exception IN VARCHAR2 := fnd_api.g_false
3208: ,p_override_quality IN VARCHAR2 := fnd_api.g_false
3209: ,p_validate_flexfields IN VARCHAR2 := fnd_api.g_false
3210: ,x_batch_step_rec OUT NOCOPY gme_batch_steps%ROWTYPE
3211: ,x_exception_material_tbl OUT NOCOPY gme_common_pvt.exceptions_tab);
3212:
3213: /*#

Line 3248: p_validate_flexfields (O) indicates whether to validate flexfields... Defaults to fnd_api.g_false;

3244: p_batch_header_rec (O) batch header to identify the batch to release;
3245: p_org_code (O) organization code to identify the batch is conjunction with batch_no in p_batch_header_rec
3246: p_ignore_exception (O) indicates whether to ignore exceptions; if exceptions are ignored,
3247: x_exception_material_tbl won't be populated even if exceptions were found
3248: p_validate_flexfields (O) indicates whether to validate flexfields... Defaults to fnd_api.g_false;
3249: x_batch_header_rec Output batch header record after release
3250: x_exception_material_tbl Batch exceptions found in release batch
3251: x_return_status outcome of the API call
3252: S - Success

Line 3261: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false

3257: PROCEDURE release_batch
3258: (p_api_version IN NUMBER
3259: ,p_validation_level IN NUMBER
3260: := gme_common_pvt.g_max_errors
3261: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
3262: ,p_commit IN VARCHAR2 := fnd_api.g_false
3263: ,x_message_count OUT NOCOPY NUMBER
3264: ,x_message_list OUT NOCOPY VARCHAR2
3265: ,x_return_status OUT NOCOPY VARCHAR2

Line 3262: ,p_commit IN VARCHAR2 := fnd_api.g_false

3258: (p_api_version IN NUMBER
3259: ,p_validation_level IN NUMBER
3260: := gme_common_pvt.g_max_errors
3261: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
3262: ,p_commit IN VARCHAR2 := fnd_api.g_false
3263: ,x_message_count OUT NOCOPY NUMBER
3264: ,x_message_list OUT NOCOPY VARCHAR2
3265: ,x_return_status OUT NOCOPY VARCHAR2
3266: ,p_batch_header_rec IN gme_batch_header%ROWTYPE

Line 3268: ,p_ignore_exception IN VARCHAR2 := fnd_api.g_false

3264: ,x_message_list OUT NOCOPY VARCHAR2
3265: ,x_return_status OUT NOCOPY VARCHAR2
3266: ,p_batch_header_rec IN gme_batch_header%ROWTYPE
3267: ,p_org_code IN VARCHAR2
3268: ,p_ignore_exception IN VARCHAR2 := fnd_api.g_false
3269: ,p_validate_flexfields IN VARCHAR2 := fnd_api.g_false
3270: ,x_batch_header_rec OUT NOCOPY gme_batch_header%ROWTYPE
3271: ,x_exception_material_tbl OUT NOCOPY gme_common_pvt.exceptions_tab);
3272:

Line 3269: ,p_validate_flexfields IN VARCHAR2 := fnd_api.g_false

3265: ,x_return_status OUT NOCOPY VARCHAR2
3266: ,p_batch_header_rec IN gme_batch_header%ROWTYPE
3267: ,p_org_code IN VARCHAR2
3268: ,p_ignore_exception IN VARCHAR2 := fnd_api.g_false
3269: ,p_validate_flexfields IN VARCHAR2 := fnd_api.g_false
3270: ,x_batch_header_rec OUT NOCOPY gme_batch_header%ROWTYPE
3271: ,x_exception_material_tbl OUT NOCOPY gme_common_pvt.exceptions_tab);
3272:
3273: /*#

Line 3313: p_validate_flexfields (O) indicates whether to validate flexfields... Defaults to fnd_api.g_false;

3309: p_batch_no (O) batch_no to identify the step
3310: p_org_code (O) organization code to identify the step is conjunction with batch_no in p_batch_header_rec
3311: p_ignore_exception (O) indicates whether to ignore exceptions; if exceptions are ignored,
3312: x_exception_material_tbl won't be populated ever if exceptions were found
3313: p_validate_flexfields (O) indicates whether to validate flexfields... Defaults to fnd_api.g_false;
3314: x_batch_step_rec Output batch step record after release
3315: x_exception_material_tbl Material exceptions found in release step (only those associated to step and processed dep steps)
3316: x_return_status outcome of the API call
3317: S - Success

Line 3326: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false

3322: PROCEDURE release_step
3323: (p_api_version IN NUMBER
3324: ,p_validation_level IN NUMBER
3325: := gme_common_pvt.g_max_errors
3326: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
3327: ,p_commit IN VARCHAR2 := fnd_api.g_false
3328: ,p_save_batch IN VARCHAR2 := fnd_api.g_true -- Bug 16079623
3329: ,x_message_count OUT NOCOPY NUMBER
3330: ,x_message_list OUT NOCOPY VARCHAR2

Line 3327: ,p_commit IN VARCHAR2 := fnd_api.g_false

3323: (p_api_version IN NUMBER
3324: ,p_validation_level IN NUMBER
3325: := gme_common_pvt.g_max_errors
3326: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
3327: ,p_commit IN VARCHAR2 := fnd_api.g_false
3328: ,p_save_batch IN VARCHAR2 := fnd_api.g_true -- Bug 16079623
3329: ,x_message_count OUT NOCOPY NUMBER
3330: ,x_message_list OUT NOCOPY VARCHAR2
3331: ,x_return_status OUT NOCOPY VARCHAR2

Line 3328: ,p_save_batch IN VARCHAR2 := fnd_api.g_true -- Bug 16079623

3324: ,p_validation_level IN NUMBER
3325: := gme_common_pvt.g_max_errors
3326: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
3327: ,p_commit IN VARCHAR2 := fnd_api.g_false
3328: ,p_save_batch IN VARCHAR2 := fnd_api.g_true -- Bug 16079623
3329: ,x_message_count OUT NOCOPY NUMBER
3330: ,x_message_list OUT NOCOPY VARCHAR2
3331: ,x_return_status OUT NOCOPY VARCHAR2
3332: ,p_batch_step_rec IN gme_batch_steps%ROWTYPE

Line 3335: ,p_ignore_exception IN VARCHAR2 := fnd_api.g_false

3331: ,x_return_status OUT NOCOPY VARCHAR2
3332: ,p_batch_step_rec IN gme_batch_steps%ROWTYPE
3333: ,p_batch_no IN VARCHAR2
3334: ,p_org_code IN VARCHAR2
3335: ,p_ignore_exception IN VARCHAR2 := fnd_api.g_false
3336: ,p_validate_flexfields IN VARCHAR2 := fnd_api.g_false
3337: ,x_batch_step_rec OUT NOCOPY gme_batch_steps%ROWTYPE
3338: ,x_exception_material_tbl OUT NOCOPY gme_common_pvt.exceptions_tab);
3339:

Line 3336: ,p_validate_flexfields IN VARCHAR2 := fnd_api.g_false

3332: ,p_batch_step_rec IN gme_batch_steps%ROWTYPE
3333: ,p_batch_no IN VARCHAR2
3334: ,p_org_code IN VARCHAR2
3335: ,p_ignore_exception IN VARCHAR2 := fnd_api.g_false
3336: ,p_validate_flexfields IN VARCHAR2 := fnd_api.g_false
3337: ,x_batch_step_rec OUT NOCOPY gme_batch_steps%ROWTYPE
3338: ,x_exception_material_tbl OUT NOCOPY gme_common_pvt.exceptions_tab);
3339:
3340: /*#

Line 3388: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false

3384: PROCEDURE process_group
3385: (p_api_version IN NUMBER
3386: ,p_validation_level IN NUMBER
3387: := gme_common_pvt.g_max_errors
3388: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
3389: ,p_commit IN VARCHAR2 := fnd_api.g_false
3390: ,p_group_name IN VARCHAR2
3391: ,p_org_code IN VARCHAR2
3392: ,p_action IN NUMBER

Line 3389: ,p_commit IN VARCHAR2 := fnd_api.g_false

3385: (p_api_version IN NUMBER
3386: ,p_validation_level IN NUMBER
3387: := gme_common_pvt.g_max_errors
3388: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
3389: ,p_commit IN VARCHAR2 := fnd_api.g_false
3390: ,p_group_name IN VARCHAR2
3391: ,p_org_code IN VARCHAR2
3392: ,p_action IN NUMBER
3393: ,p_on_error_flag IN VARCHAR2

Line 3430: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false

3426: ================================================================================*/
3427: PROCEDURE update_batchstep_qty (
3428: p_api_version IN NUMBER := 1.0
3429: ,p_validation_level IN NUMBER := gme_common_pvt.g_max_errors
3430: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
3431: ,p_commit IN VARCHAR2
3432: ,p_org_code IN VARCHAR2
3433: ,p_batch_no IN VARCHAR2 := NULL
3434: ,p_add IN VARCHAR2 := 'N'