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 143: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false

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

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

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

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

156: ,p_recipe_version IN NUMBER := NULL
157: ,p_product_no IN VARCHAR2 := NULL
158: ,p_item_revision IN VARCHAR2 := NULL
159: ,p_product_id IN NUMBER := NULL
160: ,p_ignore_qty_below_cap IN VARCHAR2 := fnd_api.g_true
161: ,p_use_workday_cal IN VARCHAR2 := fnd_api.g_true
162: ,p_contiguity_override IN VARCHAR2 := fnd_api.g_true
163: ,p_use_least_cost_validity_rule IN VARCHAR2 := fnd_api.g_false
164: ,x_exception_material_tbl OUT NOCOPY gme_common_pvt.exceptions_tab);

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

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

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

158: ,p_item_revision IN VARCHAR2 := NULL
159: ,p_product_id IN NUMBER := NULL
160: ,p_ignore_qty_below_cap IN VARCHAR2 := fnd_api.g_true
161: ,p_use_workday_cal IN VARCHAR2 := fnd_api.g_true
162: ,p_contiguity_override IN VARCHAR2 := fnd_api.g_true
163: ,p_use_least_cost_validity_rule IN VARCHAR2 := fnd_api.g_false
164: ,x_exception_material_tbl OUT NOCOPY gme_common_pvt.exceptions_tab);
165:
166: /*#

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

159: ,p_product_id IN NUMBER := NULL
160: ,p_ignore_qty_below_cap IN VARCHAR2 := fnd_api.g_true
161: ,p_use_workday_cal IN VARCHAR2 := fnd_api.g_true
162: ,p_contiguity_override IN VARCHAR2 := fnd_api.g_true
163: ,p_use_least_cost_validity_rule IN VARCHAR2 := fnd_api.g_false
164: ,x_exception_material_tbl OUT NOCOPY gme_common_pvt.exceptions_tab);
165:
166: /*#
167: * Create Phantom Procedure

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

215: PROCEDURE create_phantom (
216: p_api_version IN NUMBER
217: ,p_validation_level IN NUMBER
218: := gme_common_pvt.g_max_errors
219: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
220: ,p_commit IN VARCHAR2 := fnd_api.g_false
221: ,x_message_count OUT NOCOPY NUMBER
222: ,x_message_list OUT NOCOPY VARCHAR2
223: ,x_return_status OUT NOCOPY VARCHAR2

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

216: p_api_version IN NUMBER
217: ,p_validation_level IN NUMBER
218: := gme_common_pvt.g_max_errors
219: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
220: ,p_commit IN VARCHAR2 := fnd_api.g_false
221: ,x_message_count OUT NOCOPY NUMBER
222: ,x_message_list OUT NOCOPY VARCHAR2
223: ,x_return_status OUT NOCOPY VARCHAR2
224: ,p_material_detail_rec IN gme_material_details%ROWTYPE

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

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

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

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

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

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

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

288: PROCEDURE scale_batch (
289: p_api_version IN NUMBER
290: ,p_validation_level IN NUMBER
291: := gme_common_pvt.g_max_errors
292: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
293: ,p_commit IN VARCHAR2 := fnd_api.g_false
294: ,p_batch_header_rec IN gme_batch_header%ROWTYPE
295: ,p_org_code IN VARCHAR2
296: ,p_ignore_exception IN VARCHAR2 := fnd_api.g_false

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

289: p_api_version IN NUMBER
290: ,p_validation_level IN NUMBER
291: := gme_common_pvt.g_max_errors
292: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
293: ,p_commit IN VARCHAR2 := fnd_api.g_false
294: ,p_batch_header_rec IN gme_batch_header%ROWTYPE
295: ,p_org_code IN VARCHAR2
296: ,p_ignore_exception IN VARCHAR2 := fnd_api.g_false
297: ,p_scale_factor IN NUMBER

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

292: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
293: ,p_commit IN VARCHAR2 := fnd_api.g_false
294: ,p_batch_header_rec IN gme_batch_header%ROWTYPE
295: ,p_org_code IN VARCHAR2
296: ,p_ignore_exception IN VARCHAR2 := fnd_api.g_false
297: ,p_scale_factor IN NUMBER
298: ,p_primaries IN VARCHAR2
299: ,p_qty_type IN NUMBER := 1
300: ,p_recalc_dates IN VARCHAR2 := fnd_api.g_false

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

296: ,p_ignore_exception IN VARCHAR2 := fnd_api.g_false
297: ,p_scale_factor IN NUMBER
298: ,p_primaries IN VARCHAR2
299: ,p_qty_type IN NUMBER := 1
300: ,p_recalc_dates IN VARCHAR2 := fnd_api.g_false
301: ,p_use_workday_cal IN VARCHAR2 := fnd_api.g_false
302: ,p_contiguity_override IN VARCHAR2 := fnd_api.g_false
303: ,x_exception_material_tbl OUT NOCOPY gme_common_pvt.exceptions_tab
304: ,x_message_count OUT NOCOPY NUMBER

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

297: ,p_scale_factor IN NUMBER
298: ,p_primaries IN VARCHAR2
299: ,p_qty_type IN NUMBER := 1
300: ,p_recalc_dates IN VARCHAR2 := fnd_api.g_false
301: ,p_use_workday_cal IN VARCHAR2 := fnd_api.g_false
302: ,p_contiguity_override IN VARCHAR2 := fnd_api.g_false
303: ,x_exception_material_tbl OUT NOCOPY gme_common_pvt.exceptions_tab
304: ,x_message_count OUT NOCOPY NUMBER
305: ,x_message_list OUT NOCOPY VARCHAR2

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

298: ,p_primaries IN VARCHAR2
299: ,p_qty_type IN NUMBER := 1
300: ,p_recalc_dates IN VARCHAR2 := fnd_api.g_false
301: ,p_use_workday_cal IN VARCHAR2 := fnd_api.g_false
302: ,p_contiguity_override IN VARCHAR2 := fnd_api.g_false
303: ,x_exception_material_tbl OUT NOCOPY gme_common_pvt.exceptions_tab
304: ,x_message_count OUT NOCOPY NUMBER
305: ,x_message_list OUT NOCOPY VARCHAR2
306: ,x_return_status OUT NOCOPY VARCHAR2

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

348: PROCEDURE theoretical_yield_batch (
349: p_api_version IN NUMBER := 2.0
350: ,p_validation_level IN NUMBER
351: := gme_common_pvt.g_max_errors
352: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
353: ,p_commit IN VARCHAR2 := fnd_api.g_false
354: ,p_batch_header_rec IN gme_batch_header%ROWTYPE
355: ,p_org_code IN VARCHAR2
356: ,p_scale_factor IN NUMBER

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

349: p_api_version IN NUMBER := 2.0
350: ,p_validation_level IN NUMBER
351: := gme_common_pvt.g_max_errors
352: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
353: ,p_commit IN VARCHAR2 := fnd_api.g_false
354: ,p_batch_header_rec IN gme_batch_header%ROWTYPE
355: ,p_org_code IN VARCHAR2
356: ,p_scale_factor IN NUMBER
357: ,x_message_count OUT NOCOPY NUMBER

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

692: PROCEDURE end_cmplt_actual_rsrc_txn (
693: p_api_version IN NUMBER := 2.0
694: ,p_validation_level IN NUMBER
695: := gme_common_pvt.g_max_errors
696: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
697: ,p_commit IN VARCHAR2 := fnd_api.g_false
698: ,p_instance_no IN NUMBER := NULL
699: ,p_reason_name IN VARCHAR2 := NULL
700: ,p_rsrc_txn_rec IN gme_resource_txns%ROWTYPE

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

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

Line 702: p_validate_flexfields IN VARCHAR2 := fnd_api.g_false

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

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

752: PROCEDURE reschedule_batch (
753: p_api_version IN NUMBER := 2.0
754: ,p_validation_level IN NUMBER
755: := gme_common_pvt.g_max_errors
756: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
757: ,p_commit IN VARCHAR2 := fnd_api.g_false
758: ,p_batch_header_rec IN gme_batch_header%ROWTYPE
759: ,p_use_workday_cal IN VARCHAR2 := fnd_api.g_false
760: ,p_contiguity_override IN VARCHAR2 := fnd_api.g_false

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

753: p_api_version IN NUMBER := 2.0
754: ,p_validation_level IN NUMBER
755: := gme_common_pvt.g_max_errors
756: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
757: ,p_commit IN VARCHAR2 := fnd_api.g_false
758: ,p_batch_header_rec IN gme_batch_header%ROWTYPE
759: ,p_use_workday_cal IN VARCHAR2 := fnd_api.g_false
760: ,p_contiguity_override IN VARCHAR2 := fnd_api.g_false
761: ,p_org_code IN VARCHAR2

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

755: := gme_common_pvt.g_max_errors
756: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
757: ,p_commit IN VARCHAR2 := fnd_api.g_false
758: ,p_batch_header_rec IN gme_batch_header%ROWTYPE
759: ,p_use_workday_cal IN VARCHAR2 := fnd_api.g_false
760: ,p_contiguity_override IN VARCHAR2 := fnd_api.g_false
761: ,p_org_code IN VARCHAR2
762: ,x_message_count OUT NOCOPY NUMBER
763: ,x_message_list OUT NOCOPY VARCHAR2

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

756: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
757: ,p_commit IN VARCHAR2 := fnd_api.g_false
758: ,p_batch_header_rec IN gme_batch_header%ROWTYPE
759: ,p_use_workday_cal IN VARCHAR2 := fnd_api.g_false
760: ,p_contiguity_override IN VARCHAR2 := fnd_api.g_false
761: ,p_org_code IN VARCHAR2
762: ,x_message_count OUT NOCOPY NUMBER
763: ,x_message_list OUT NOCOPY VARCHAR2
764: ,x_return_status OUT NOCOPY VARCHAR2

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

816: PROCEDURE reschedule_step (
817: p_api_version IN NUMBER := 2.0
818: ,p_validation_level IN NUMBER
819: := gme_common_pvt.g_max_errors
820: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
821: ,p_commit IN VARCHAR2 := fnd_api.g_false
822: ,p_batch_step_rec IN gme_batch_steps%ROWTYPE
823: ,p_use_workday_cal IN VARCHAR2 := fnd_api.g_false
824: ,p_contiguity_override IN VARCHAR2 := fnd_api.g_false

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

817: p_api_version IN NUMBER := 2.0
818: ,p_validation_level IN NUMBER
819: := gme_common_pvt.g_max_errors
820: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
821: ,p_commit IN VARCHAR2 := fnd_api.g_false
822: ,p_batch_step_rec IN gme_batch_steps%ROWTYPE
823: ,p_use_workday_cal IN VARCHAR2 := fnd_api.g_false
824: ,p_contiguity_override IN VARCHAR2 := fnd_api.g_false
825: ,p_org_code IN VARCHAR2

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

819: := gme_common_pvt.g_max_errors
820: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
821: ,p_commit IN VARCHAR2 := fnd_api.g_false
822: ,p_batch_step_rec IN gme_batch_steps%ROWTYPE
823: ,p_use_workday_cal IN VARCHAR2 := fnd_api.g_false
824: ,p_contiguity_override IN VARCHAR2 := fnd_api.g_false
825: ,p_org_code IN VARCHAR2
826: ,p_batch_no IN VARCHAR2
827: ,p_batch_type IN NUMBER

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

820: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
821: ,p_commit IN VARCHAR2 := fnd_api.g_false
822: ,p_batch_step_rec IN gme_batch_steps%ROWTYPE
823: ,p_use_workday_cal IN VARCHAR2 := fnd_api.g_false
824: ,p_contiguity_override IN VARCHAR2 := fnd_api.g_false
825: ,p_org_code IN VARCHAR2
826: ,p_batch_no IN VARCHAR2
827: ,p_batch_type IN NUMBER
828: ,p_reschedule_preceding IN VARCHAR2 := fnd_api.g_false

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

824: ,p_contiguity_override IN VARCHAR2 := fnd_api.g_false
825: ,p_org_code IN VARCHAR2
826: ,p_batch_no IN VARCHAR2
827: ,p_batch_type IN NUMBER
828: ,p_reschedule_preceding IN VARCHAR2 := fnd_api.g_false
829: ,p_reschedule_succeeding IN VARCHAR2 := fnd_api.g_true
830: ,x_message_count OUT NOCOPY NUMBER
831: ,x_message_list OUT NOCOPY VARCHAR2
832: ,x_return_status OUT NOCOPY VARCHAR2

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

825: ,p_org_code IN VARCHAR2
826: ,p_batch_no IN VARCHAR2
827: ,p_batch_type IN NUMBER
828: ,p_reschedule_preceding IN VARCHAR2 := fnd_api.g_false
829: ,p_reschedule_succeeding IN VARCHAR2 := fnd_api.g_true
830: ,x_message_count OUT NOCOPY NUMBER
831: ,x_message_list OUT NOCOPY VARCHAR2
832: ,x_return_status OUT NOCOPY VARCHAR2
833: ,x_batch_step_rec OUT NOCOPY gme_batch_steps%ROWTYPE);

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

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

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

882: p_api_version IN NUMBER := 2.0
883: ,p_validation_level IN NUMBER
884: := gme_common_pvt.g_max_errors
885: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
886: ,p_commit IN VARCHAR2 := fnd_api.g_false
887: ,p_batch_rec IN gme_batch_header%ROWTYPE
888: ,p_org_code IN VARCHAR2
889: ,x_message_count OUT NOCOPY NUMBER
890: ,x_message_list OUT NOCOPY VARCHAR2

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

938: PROCEDURE create_line_reservations (
939: p_api_version IN NUMBER := 2.0
940: ,p_validation_level IN NUMBER
941: := gme_common_pvt.g_max_errors
942: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
943: ,p_commit IN VARCHAR2 := fnd_api.g_false
944: ,p_material_detail_id IN NUMBER
945: ,p_org_code IN VARCHAR2
946: ,p_batch_no IN VARCHAR2

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

939: p_api_version IN NUMBER := 2.0
940: ,p_validation_level IN NUMBER
941: := gme_common_pvt.g_max_errors
942: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
943: ,p_commit IN VARCHAR2 := fnd_api.g_false
944: ,p_material_detail_id IN NUMBER
945: ,p_org_code IN VARCHAR2
946: ,p_batch_no IN VARCHAR2
947: ,p_line_no IN NUMBER

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

995: PROCEDURE insert_process_parameter (
996: p_api_version IN NUMBER := 2.0
997: ,p_validation_level IN NUMBER
998: := gme_common_pvt.g_max_errors
999: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
1000: ,p_commit IN VARCHAR2 := fnd_api.g_false
1001: ,x_message_count OUT NOCOPY NUMBER
1002: ,x_message_list OUT NOCOPY VARCHAR2
1003: ,x_return_status OUT NOCOPY VARCHAR2

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

996: p_api_version IN NUMBER := 2.0
997: ,p_validation_level IN NUMBER
998: := gme_common_pvt.g_max_errors
999: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
1000: ,p_commit IN VARCHAR2 := fnd_api.g_false
1001: ,x_message_count OUT NOCOPY NUMBER
1002: ,x_message_list OUT NOCOPY VARCHAR2
1003: ,x_return_status OUT NOCOPY VARCHAR2
1004: ,p_batch_no IN VARCHAR2 := NULL

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

1002: ,x_message_list OUT NOCOPY VARCHAR2
1003: ,x_return_status OUT NOCOPY VARCHAR2
1004: ,p_batch_no IN VARCHAR2 := NULL
1005: ,p_org_code IN VARCHAR2 := NULL
1006: ,p_validate_flexfields IN VARCHAR2 := fnd_api.g_false
1007: ,p_batchstep_no IN NUMBER := NULL
1008: ,p_activity IN VARCHAR2 := NULL
1009: ,p_parameter IN VARCHAR2 := NULL
1010: ,p_process_param_rec IN gme_process_parameters%ROWTYPE

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

1057: PROCEDURE update_process_parameter (
1058: p_api_version IN NUMBER := 2.0
1059: ,p_validation_level IN NUMBER
1060: := gme_common_pvt.g_max_errors
1061: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
1062: ,p_commit IN VARCHAR2 := fnd_api.g_false
1063: ,x_message_count OUT NOCOPY NUMBER
1064: ,x_message_list OUT NOCOPY VARCHAR2
1065: ,x_return_status OUT NOCOPY VARCHAR2

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

1058: p_api_version IN NUMBER := 2.0
1059: ,p_validation_level IN NUMBER
1060: := gme_common_pvt.g_max_errors
1061: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
1062: ,p_commit IN VARCHAR2 := fnd_api.g_false
1063: ,x_message_count OUT NOCOPY NUMBER
1064: ,x_message_list OUT NOCOPY VARCHAR2
1065: ,x_return_status OUT NOCOPY VARCHAR2
1066: ,p_batch_no IN VARCHAR2 := NULL

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

1064: ,x_message_list OUT NOCOPY VARCHAR2
1065: ,x_return_status OUT NOCOPY VARCHAR2
1066: ,p_batch_no IN VARCHAR2 := NULL
1067: ,p_org_code IN VARCHAR2 := NULL
1068: ,p_validate_flexfields IN VARCHAR2 := fnd_api.g_false
1069: ,p_batchstep_no IN NUMBER := NULL
1070: ,p_activity IN VARCHAR2 := NULL
1071: ,p_parameter IN VARCHAR2 := NULL
1072: ,p_process_param_rec IN gme_process_parameters%ROWTYPE

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

1114: PROCEDURE delete_process_parameter (
1115: p_api_version IN NUMBER := 2.0
1116: ,p_validation_level IN NUMBER
1117: := gme_common_pvt.g_max_errors
1118: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
1119: ,p_commit IN VARCHAR2 := fnd_api.g_false
1120: ,x_message_count OUT NOCOPY NUMBER
1121: ,x_message_list OUT NOCOPY VARCHAR2
1122: ,x_return_status OUT NOCOPY VARCHAR2

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

1115: p_api_version IN NUMBER := 2.0
1116: ,p_validation_level IN NUMBER
1117: := gme_common_pvt.g_max_errors
1118: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
1119: ,p_commit IN VARCHAR2 := fnd_api.g_false
1120: ,x_message_count OUT NOCOPY NUMBER
1121: ,x_message_list OUT NOCOPY VARCHAR2
1122: ,x_return_status OUT NOCOPY VARCHAR2
1123: ,p_batch_no IN VARCHAR2 := NULL

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

1173: PROCEDURE insert_step (
1174: p_api_version IN NUMBER := 2.0
1175: ,p_validation_level IN NUMBER
1176: := gme_common_pvt.g_max_errors
1177: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
1178: ,p_commit IN VARCHAR2
1179: ,p_org_code IN VARCHAR2
1180: /*FPBug#4395561*/
1181: ,p_validate_flexfields IN VARCHAR2 := fnd_api.g_false

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

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

Line 1241: ,p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false

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

Line 1242: ,p_commit IN VARCHAR2 DEFAULT fnd_api.g_false

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

Line 1248: ,p_validate_flexfields IN VARCHAR2 DEFAULT fnd_api.g_false

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

Line 1303: ,p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false

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

Line 1304: ,p_commit IN VARCHAR2 DEFAULT fnd_api.g_false

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

Line 1309: ,p_scale_phantom IN VARCHAR2 DEFAULT fnd_api.g_false

1305: ,p_batch_header_rec IN gme_batch_header%ROWTYPE
1306: ,p_material_detail_rec IN gme_material_details%ROWTYPE
1307: ,p_locator_code IN VARCHAR2
1308: ,p_org_code IN VARCHAR2
1309: ,p_scale_phantom IN VARCHAR2 DEFAULT fnd_api.g_false
1310: ,p_validate_flexfields IN VARCHAR2 DEFAULT fnd_api.g_false
1311: ,x_material_detail_rec OUT NOCOPY gme_material_details%ROWTYPE
1312: ,x_message_count OUT NOCOPY NUMBER
1313: ,x_message_list OUT NOCOPY VARCHAR2

Line 1310: ,p_validate_flexfields IN VARCHAR2 DEFAULT fnd_api.g_false

1306: ,p_material_detail_rec IN gme_material_details%ROWTYPE
1307: ,p_locator_code IN VARCHAR2
1308: ,p_org_code IN VARCHAR2
1309: ,p_scale_phantom IN VARCHAR2 DEFAULT fnd_api.g_false
1310: ,p_validate_flexfields IN VARCHAR2 DEFAULT fnd_api.g_false
1311: ,x_material_detail_rec OUT NOCOPY gme_material_details%ROWTYPE
1312: ,x_message_count OUT NOCOPY NUMBER
1313: ,x_message_list OUT NOCOPY VARCHAR2
1314: ,x_return_status OUT NOCOPY VARCHAR2 );

Line 1356: ,p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false

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

Line 1357: ,p_commit IN VARCHAR2 DEFAULT fnd_api.g_false

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

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

1399: PROCEDURE delete_step (
1400: p_api_version IN NUMBER := 2.0
1401: ,p_validation_level IN NUMBER
1402: := gme_common_pvt.g_max_errors
1403: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
1404: ,p_commit IN VARCHAR2
1405: ,p_org_code IN VARCHAR2
1406: ,p_batch_no IN VARCHAR2
1407: ,x_message_count OUT NOCOPY NUMBER

Line 1609: p_init_msg_list IN VARCHAR2 := fnd_api.g_false

1605: , /* Punit Kumar */
1606: p_validation_level IN NUMBER
1607: := gme_common_pvt.g_max_errors
1608: , /* Punit Kumar */
1609: p_init_msg_list IN VARCHAR2 := fnd_api.g_false
1610: ,p_commit IN VARCHAR2
1611: ,x_message_count OUT NOCOPY NUMBER
1612: ,x_message_list OUT NOCOPY VARCHAR2
1613: ,x_return_status OUT NOCOPY VARCHAR2

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

1611: ,x_message_count OUT NOCOPY NUMBER
1612: ,x_message_list OUT NOCOPY VARCHAR2
1613: ,x_return_status OUT NOCOPY VARCHAR2
1614: ,p_batch_step_rec IN gme_batch_steps%ROWTYPE
1615: ,p_delete_pending IN VARCHAR2 := fnd_api.g_false
1616: ,p_org_code IN VARCHAR2
1617: ,p_batch_no IN VARCHAR2
1618: ,x_batch_step_rec OUT NOCOPY gme_batch_steps%ROWTYPE);
1619:

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

1656: PROCEDURE cancel_batch (
1657: p_api_version IN NUMBER := 2.0
1658: ,p_validation_level IN NUMBER
1659: := gme_common_pvt.g_max_errors
1660: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
1661: ,p_commit IN VARCHAR2 := fnd_api.g_false
1662: ,x_message_count OUT NOCOPY NUMBER
1663: ,x_message_list OUT NOCOPY VARCHAR2
1664: ,x_return_status OUT NOCOPY VARCHAR2

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

1657: p_api_version IN NUMBER := 2.0
1658: ,p_validation_level IN NUMBER
1659: := gme_common_pvt.g_max_errors
1660: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
1661: ,p_commit IN VARCHAR2 := fnd_api.g_false
1662: ,x_message_count OUT NOCOPY NUMBER
1663: ,x_message_list OUT NOCOPY VARCHAR2
1664: ,x_return_status OUT NOCOPY VARCHAR2
1665: ,p_org_code IN VARCHAR2

Line 1714: p_init_msg_list IN VARCHAR2 := fnd_api.g_false

1710: , /* Punit Kumar */
1711: p_validation_level IN NUMBER
1712: := gme_common_pvt.g_max_errors
1713: , /* Punit Kumar */
1714: p_init_msg_list IN VARCHAR2 := fnd_api.g_false
1715: ,p_commit IN VARCHAR2
1716: ,x_message_count OUT NOCOPY NUMBER
1717: ,x_message_list OUT NOCOPY VARCHAR2
1718: ,x_return_status OUT NOCOPY VARCHAR2

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

1717: ,x_message_list OUT NOCOPY VARCHAR2
1718: ,x_return_status OUT NOCOPY VARCHAR2
1719: ,p_batch_header_rec IN gme_batch_header%ROWTYPE
1720: ,p_org_code IN VARCHAR2
1721: ,p_reopen_steps IN VARCHAR2 := fnd_api.g_false
1722: ,x_batch_header_rec OUT NOCOPY gme_batch_header%ROWTYPE);
1723:
1724: /*#
1725: * Reopen Step Procedure

Line 1767: p_init_msg_list IN VARCHAR2 := fnd_api.g_false

1763: , /* Punit Kumar */
1764: p_validation_level IN NUMBER
1765: := gme_common_pvt.g_max_errors
1766: , /* Punit Kumar */
1767: p_init_msg_list IN VARCHAR2 := fnd_api.g_false
1768: ,p_commit IN VARCHAR2
1769: ,x_message_count OUT NOCOPY NUMBER
1770: ,x_message_list OUT NOCOPY VARCHAR2
1771: ,x_return_status OUT NOCOPY VARCHAR2

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

1807: PROCEDURE incremental_backflush (
1808: p_api_version IN NUMBER
1809: ,p_validation_level IN NUMBER
1810: := gme_common_pvt.g_max_errors
1811: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
1812: ,p_commit IN VARCHAR2 := fnd_api.g_false
1813: ,x_message_count OUT NOCOPY NUMBER
1814: ,x_message_list OUT NOCOPY VARCHAR2
1815: ,x_return_status OUT NOCOPY VARCHAR2

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

1808: p_api_version IN NUMBER
1809: ,p_validation_level IN NUMBER
1810: := gme_common_pvt.g_max_errors
1811: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
1812: ,p_commit IN VARCHAR2 := fnd_api.g_false
1813: ,x_message_count OUT NOCOPY NUMBER
1814: ,x_message_list OUT NOCOPY VARCHAR2
1815: ,x_return_status OUT NOCOPY VARCHAR2
1816: ,p_batch_header_rec IN gme_batch_header%ROWTYPE

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

1818: ,p_material_detail_rec IN gme_material_details%ROWTYPE
1819: ,p_qty IN NUMBER
1820: ,p_qty_type IN NUMBER := 0
1821: ,p_trans_date IN DATE
1822: ,p_ignore_exception IN VARCHAR2 := fnd_api.g_false
1823: ,p_adjust_cmplt IN VARCHAR2 := fnd_api.g_true
1824: ,x_exception_material_tbl OUT NOCOPY gme_common_pvt.exceptions_tab);
1825: /*#
1826: * Create Material Transaction Procedure

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

1819: ,p_qty IN NUMBER
1820: ,p_qty_type IN NUMBER := 0
1821: ,p_trans_date IN DATE
1822: ,p_ignore_exception IN VARCHAR2 := fnd_api.g_false
1823: ,p_adjust_cmplt IN VARCHAR2 := fnd_api.g_true
1824: ,x_exception_material_tbl OUT NOCOPY gme_common_pvt.exceptions_tab);
1825: /*#
1826: * Create Material Transaction Procedure
1827: * This procedure Creates a Material Transaction.

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

1864: PROCEDURE create_material_txn (
1865: p_api_version IN NUMBER := 2.0
1866: ,p_validation_level IN NUMBER
1867: := gme_common_pvt.g_max_errors
1868: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
1869: ,p_commit IN VARCHAR2 := fnd_api.g_false
1870: ,x_message_count OUT NOCOPY NUMBER
1871: ,x_message_list OUT NOCOPY VARCHAR2
1872: ,x_return_status OUT NOCOPY VARCHAR2

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

1865: p_api_version IN NUMBER := 2.0
1866: ,p_validation_level IN NUMBER
1867: := gme_common_pvt.g_max_errors
1868: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
1869: ,p_commit IN VARCHAR2 := fnd_api.g_false
1870: ,x_message_count OUT NOCOPY NUMBER
1871: ,x_message_list OUT NOCOPY VARCHAR2
1872: ,x_return_status OUT NOCOPY VARCHAR2
1873: ,p_org_code IN VARCHAR2 := NULL

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

1920: PROCEDURE update_material_txn (
1921: p_api_version IN NUMBER := 2.0
1922: ,p_validation_level IN NUMBER
1923: := gme_common_pvt.g_max_errors
1924: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
1925: ,p_commit IN VARCHAR2 := fnd_api.g_false
1926: ,x_message_count OUT NOCOPY NUMBER
1927: ,x_message_list OUT NOCOPY VARCHAR2
1928: ,x_return_status OUT NOCOPY VARCHAR2

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

1921: p_api_version IN NUMBER := 2.0
1922: ,p_validation_level IN NUMBER
1923: := gme_common_pvt.g_max_errors
1924: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
1925: ,p_commit IN VARCHAR2 := fnd_api.g_false
1926: ,x_message_count OUT NOCOPY NUMBER
1927: ,x_message_list OUT NOCOPY VARCHAR2
1928: ,x_return_status OUT NOCOPY VARCHAR2
1929: ,p_transaction_id IN NUMBER

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

1966: PROCEDURE delete_material_txn (
1967: p_api_version IN NUMBER := 2.0
1968: ,p_validation_level IN NUMBER
1969: := gme_common_pvt.g_max_errors
1970: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
1971: ,p_commit IN VARCHAR2 := fnd_api.g_false
1972: ,x_message_count OUT NOCOPY NUMBER
1973: ,x_message_list OUT NOCOPY VARCHAR2
1974: ,x_return_status OUT NOCOPY VARCHAR2

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

1967: p_api_version IN NUMBER := 2.0
1968: ,p_validation_level IN NUMBER
1969: := gme_common_pvt.g_max_errors
1970: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
1971: ,p_commit IN VARCHAR2 := fnd_api.g_false
1972: ,x_message_count OUT NOCOPY NUMBER
1973: ,x_message_list OUT NOCOPY VARCHAR2
1974: ,x_return_status OUT NOCOPY VARCHAR2
1975: ,p_transaction_id IN NUMBER);

Line 2025: DEFAULT fnd_api.g_false

2021: p_api_version IN NUMBER := 2.0
2022: ,p_validation_level IN NUMBER
2023: := gme_common_pvt.g_max_errors
2024: ,p_init_msg_list IN VARCHAR2
2025: DEFAULT fnd_api.g_false
2026: ,p_commit IN VARCHAR2
2027: DEFAULT fnd_api.g_false
2028: ,p_batch_header_rec IN gme_batch_header%ROWTYPE
2029: ,p_validity_rule_id IN NUMBER

Line 2027: DEFAULT fnd_api.g_false

2023: := gme_common_pvt.g_max_errors
2024: ,p_init_msg_list IN VARCHAR2
2025: DEFAULT fnd_api.g_false
2026: ,p_commit IN VARCHAR2
2027: DEFAULT fnd_api.g_false
2028: ,p_batch_header_rec IN gme_batch_header%ROWTYPE
2029: ,p_validity_rule_id IN NUMBER
2030: ,p_org_code IN VARCHAR2
2031: ,p_use_workday_cal IN VARCHAR2

Line 2032: DEFAULT fnd_api.g_false

2028: ,p_batch_header_rec IN gme_batch_header%ROWTYPE
2029: ,p_validity_rule_id IN NUMBER
2030: ,p_org_code IN VARCHAR2
2031: ,p_use_workday_cal IN VARCHAR2
2032: DEFAULT fnd_api.g_false
2033: ,p_contiguity_override IN VARCHAR2
2034: DEFAULT fnd_api.g_false
2035: ,x_message_count OUT NOCOPY NUMBER
2036: ,x_message_list OUT NOCOPY VARCHAR2

Line 2034: DEFAULT fnd_api.g_false

2030: ,p_org_code IN VARCHAR2
2031: ,p_use_workday_cal IN VARCHAR2
2032: DEFAULT fnd_api.g_false
2033: ,p_contiguity_override IN VARCHAR2
2034: DEFAULT fnd_api.g_false
2035: ,x_message_count OUT NOCOPY NUMBER
2036: ,x_message_list OUT NOCOPY VARCHAR2
2037: ,x_return_status OUT NOCOPY VARCHAR2
2038: ,x_batch_header_rec OUT NOCOPY gme_batch_header%ROWTYPE);

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

2080: PROCEDURE terminate_batch (
2081: p_api_version IN NUMBER := 2.0
2082: ,p_validation_level IN NUMBER
2083: := gme_common_pvt.g_max_errors
2084: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
2085: ,p_commit IN VARCHAR2 := fnd_api.g_false
2086: ,x_message_count OUT NOCOPY NUMBER
2087: ,x_message_list OUT NOCOPY VARCHAR2
2088: ,x_return_status OUT NOCOPY VARCHAR2

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

2081: p_api_version IN NUMBER := 2.0
2082: ,p_validation_level IN NUMBER
2083: := gme_common_pvt.g_max_errors
2084: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
2085: ,p_commit IN VARCHAR2 := fnd_api.g_false
2086: ,x_message_count OUT NOCOPY NUMBER
2087: ,x_message_list OUT NOCOPY VARCHAR2
2088: ,x_return_status OUT NOCOPY VARCHAR2
2089: ,p_org_code IN VARCHAR2

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

2147: PROCEDURE convert_dtl_reservation (
2148: p_api_version IN NUMBER := 2.0
2149: ,p_validation_level IN NUMBER
2150: := gme_common_pvt.g_max_errors
2151: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
2152: ,p_commit IN VARCHAR2 := fnd_api.g_false
2153: ,x_message_count OUT NOCOPY NUMBER
2154: ,x_message_list OUT NOCOPY VARCHAR2
2155: ,x_return_status OUT NOCOPY VARCHAR2

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

2148: p_api_version IN NUMBER := 2.0
2149: ,p_validation_level IN NUMBER
2150: := gme_common_pvt.g_max_errors
2151: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
2152: ,p_commit IN VARCHAR2 := fnd_api.g_false
2153: ,x_message_count OUT NOCOPY NUMBER
2154: ,x_message_list OUT NOCOPY VARCHAR2
2155: ,x_return_status OUT NOCOPY VARCHAR2
2156: ,p_reservation_rec IN mtl_reservations%ROWTYPE

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

2219: PROCEDURE insert_batchstep_resource (
2220: p_api_version IN NUMBER
2221: ,p_validation_level IN NUMBER
2222: := gme_common_pvt.g_max_errors
2223: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
2224: ,p_commit IN VARCHAR2 := fnd_api.g_false
2225: ,p_batchstep_resource_rec IN gme_batch_step_resources%ROWTYPE
2226: ,p_org_code IN VARCHAR2 := NULL
2227: ,p_batch_no IN VARCHAR2 := NULL

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

2220: p_api_version IN NUMBER
2221: ,p_validation_level IN NUMBER
2222: := gme_common_pvt.g_max_errors
2223: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
2224: ,p_commit IN VARCHAR2 := fnd_api.g_false
2225: ,p_batchstep_resource_rec IN gme_batch_step_resources%ROWTYPE
2226: ,p_org_code IN VARCHAR2 := NULL
2227: ,p_batch_no IN VARCHAR2 := NULL
2228: ,p_batchstep_no IN NUMBER := NULL

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

2226: ,p_org_code IN VARCHAR2 := NULL
2227: ,p_batch_no IN VARCHAR2 := NULL
2228: ,p_batchstep_no IN NUMBER := NULL
2229: ,p_activity IN VARCHAR2 := NULL
2230: ,p_ignore_qty_below_cap IN VARCHAR2 := fnd_api.g_false
2231: ,p_validate_flexfields IN VARCHAR2 := fnd_api.g_false
2232: ,x_batchstep_resource_rec OUT NOCOPY gme_batch_step_resources%ROWTYPE
2233: ,x_message_count OUT NOCOPY NUMBER
2234: ,x_message_list OUT NOCOPY VARCHAR2

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

2227: ,p_batch_no IN VARCHAR2 := NULL
2228: ,p_batchstep_no IN NUMBER := NULL
2229: ,p_activity IN VARCHAR2 := NULL
2230: ,p_ignore_qty_below_cap IN VARCHAR2 := fnd_api.g_false
2231: ,p_validate_flexfields IN VARCHAR2 := fnd_api.g_false
2232: ,x_batchstep_resource_rec OUT NOCOPY gme_batch_step_resources%ROWTYPE
2233: ,x_message_count OUT NOCOPY NUMBER
2234: ,x_message_list OUT NOCOPY VARCHAR2
2235: ,x_return_status OUT NOCOPY VARCHAR2);

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

2289: PROCEDURE update_batchstep_resource (
2290: p_api_version IN NUMBER
2291: ,p_validation_level IN NUMBER
2292: := gme_common_pvt.g_max_errors
2293: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
2294: ,p_commit IN VARCHAR2 := fnd_api.g_false
2295: ,p_batchstep_resource_rec IN gme_batch_step_resources%ROWTYPE
2296: ,p_org_code IN VARCHAR2 := NULL
2297: ,p_batch_no IN VARCHAR2 := NULL

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

2290: p_api_version IN NUMBER
2291: ,p_validation_level IN NUMBER
2292: := gme_common_pvt.g_max_errors
2293: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
2294: ,p_commit IN VARCHAR2 := fnd_api.g_false
2295: ,p_batchstep_resource_rec IN gme_batch_step_resources%ROWTYPE
2296: ,p_org_code IN VARCHAR2 := NULL
2297: ,p_batch_no IN VARCHAR2 := NULL
2298: ,p_batchstep_no IN NUMBER := NULL

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

2296: ,p_org_code IN VARCHAR2 := NULL
2297: ,p_batch_no IN VARCHAR2 := NULL
2298: ,p_batchstep_no IN NUMBER := NULL
2299: ,p_activity IN VARCHAR2 := NULL
2300: ,p_ignore_qty_below_cap IN VARCHAR2 := fnd_api.g_false
2301: ,p_validate_flexfields IN VARCHAR2 := fnd_api.g_false
2302: ,x_batchstep_resource_rec OUT NOCOPY gme_batch_step_resources%ROWTYPE
2303: ,x_message_count OUT NOCOPY NUMBER
2304: ,x_message_list OUT NOCOPY VARCHAR2

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

2297: ,p_batch_no IN VARCHAR2 := NULL
2298: ,p_batchstep_no IN NUMBER := NULL
2299: ,p_activity IN VARCHAR2 := NULL
2300: ,p_ignore_qty_below_cap IN VARCHAR2 := fnd_api.g_false
2301: ,p_validate_flexfields IN VARCHAR2 := fnd_api.g_false
2302: ,x_batchstep_resource_rec OUT NOCOPY gme_batch_step_resources%ROWTYPE
2303: ,x_message_count OUT NOCOPY NUMBER
2304: ,x_message_list OUT NOCOPY VARCHAR2
2305: ,x_return_status OUT NOCOPY VARCHAR2);

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

2350: PROCEDURE delete_batchstep_resource (
2351: p_api_version IN NUMBER := 2.0
2352: ,p_validation_level IN NUMBER
2353: := gme_common_pvt.g_max_errors
2354: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
2355: ,p_commit IN VARCHAR2 := fnd_api.g_false
2356: ,p_batchstep_resource_id IN NUMBER := NULL
2357: ,p_org_code IN VARCHAR2 := NULL
2358: ,p_batch_no IN VARCHAR2 := NULL

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

2351: p_api_version IN NUMBER := 2.0
2352: ,p_validation_level IN NUMBER
2353: := gme_common_pvt.g_max_errors
2354: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
2355: ,p_commit IN VARCHAR2 := fnd_api.g_false
2356: ,p_batchstep_resource_id IN NUMBER := NULL
2357: ,p_org_code IN VARCHAR2 := NULL
2358: ,p_batch_no IN VARCHAR2 := NULL
2359: ,p_batchstep_no IN NUMBER := NULL

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

2414: PROCEDURE auto_detail_line (
2415: p_api_version IN NUMBER := 2.0
2416: ,p_validation_level IN NUMBER
2417: := gme_common_pvt.g_max_errors
2418: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
2419: ,p_commit IN VARCHAR2 := fnd_api.g_false
2420: ,x_message_count OUT NOCOPY NUMBER
2421: ,x_message_list OUT NOCOPY VARCHAR2
2422: ,x_return_status OUT NOCOPY VARCHAR2

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

2415: p_api_version IN NUMBER := 2.0
2416: ,p_validation_level IN NUMBER
2417: := gme_common_pvt.g_max_errors
2418: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
2419: ,p_commit IN VARCHAR2 := fnd_api.g_false
2420: ,x_message_count OUT NOCOPY NUMBER
2421: ,x_message_list OUT NOCOPY VARCHAR2
2422: ,x_return_status OUT NOCOPY VARCHAR2
2423: ,p_material_detail_id IN NUMBER

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

2465: p_batch_rec (R) Production batch
2466: ================================================================================*/
2467:
2468: PROCEDURE auto_detail_batch (p_api_version IN NUMBER := 2.0
2469: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
2470: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
2471: ,x_message_count OUT NOCOPY NUMBER
2472: ,x_message_list OUT NOCOPY VARCHAR2
2473: ,x_return_status OUT NOCOPY VARCHAR2

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

2466: ================================================================================*/
2467:
2468: PROCEDURE auto_detail_batch (p_api_version IN NUMBER := 2.0
2469: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
2470: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
2471: ,x_message_count OUT NOCOPY NUMBER
2472: ,x_message_list OUT NOCOPY VARCHAR2
2473: ,x_return_status OUT NOCOPY VARCHAR2
2474: ,p_org_code IN VARCHAR2

Line 2523: DEFAULT fnd_api.g_false,

2519: p_api_version IN NUMBER ,
2520: p_validation_level IN NUMBER
2521: := gme_common_pvt.g_max_errors,
2522: p_init_msg_list IN VARCHAR2
2523: DEFAULT fnd_api.g_false,
2524: p_commit IN VARCHAR2
2525: DEFAULT fnd_api.g_false,
2526: p_org_code IN VARCHAR2,
2527: p_batchstep_activity_rec IN gme_batch_step_activities%ROWTYPE,

Line 2525: DEFAULT fnd_api.g_false,

2521: := gme_common_pvt.g_max_errors,
2522: p_init_msg_list IN VARCHAR2
2523: DEFAULT fnd_api.g_false,
2524: p_commit IN VARCHAR2
2525: DEFAULT fnd_api.g_false,
2526: p_org_code IN VARCHAR2,
2527: p_batchstep_activity_rec IN gme_batch_step_activities%ROWTYPE,
2528: p_batchstep_resource_tbl IN gme_create_step_pvt.resources_tab,
2529: p_batch_no IN VARCHAR2 := NULL,

Line 2532: DEFAULT fnd_api.g_false,

2528: p_batchstep_resource_tbl IN gme_create_step_pvt.resources_tab,
2529: p_batch_no IN VARCHAR2 := NULL,
2530: p_batchstep_no IN NUMBER := NULL,
2531: p_ignore_qty_below_cap IN VARCHAR2
2532: DEFAULT fnd_api.g_false,
2533: p_validate_flexfield IN VARCHAR2
2534: DEFAULT fnd_api.g_false,
2535: x_batchstep_activity_rec OUT NOCOPY gme_batch_step_activities%ROWTYPE,
2536: x_message_count OUT NOCOPY NUMBER,

Line 2534: DEFAULT fnd_api.g_false,

2530: p_batchstep_no IN NUMBER := NULL,
2531: p_ignore_qty_below_cap IN VARCHAR2
2532: DEFAULT fnd_api.g_false,
2533: p_validate_flexfield IN VARCHAR2
2534: DEFAULT fnd_api.g_false,
2535: x_batchstep_activity_rec OUT NOCOPY gme_batch_step_activities%ROWTYPE,
2536: x_message_count OUT NOCOPY NUMBER,
2537: x_message_list OUT NOCOPY VARCHAR2,
2538: x_return_status OUT NOCOPY VARCHAR2

Line 2584: DEFAULT fnd_api.g_false,

2580: p_api_version IN NUMBER ,
2581: p_validation_level IN NUMBER
2582: := gme_common_pvt.g_max_errors,
2583: p_init_msg_list IN VARCHAR2
2584: DEFAULT fnd_api.g_false,
2585: p_commit IN VARCHAR2
2586: DEFAULT fnd_api.g_false,
2587: p_org_code IN VARCHAR2,
2588: p_batchstep_activity_rec IN gme_batch_step_activities%ROWTYPE,

Line 2586: DEFAULT fnd_api.g_false,

2582: := gme_common_pvt.g_max_errors,
2583: p_init_msg_list IN VARCHAR2
2584: DEFAULT fnd_api.g_false,
2585: p_commit IN VARCHAR2
2586: DEFAULT fnd_api.g_false,
2587: p_org_code IN VARCHAR2,
2588: p_batchstep_activity_rec IN gme_batch_step_activities%ROWTYPE,
2589: p_batch_no IN VARCHAR2 := NULL,
2590: p_batchstep_no IN NUMBER := NULL,

Line 2592: DEFAULT fnd_api.g_false,

2588: p_batchstep_activity_rec IN gme_batch_step_activities%ROWTYPE,
2589: p_batch_no IN VARCHAR2 := NULL,
2590: p_batchstep_no IN NUMBER := NULL,
2591: p_validate_flexfield IN VARCHAR2
2592: DEFAULT fnd_api.g_false,
2593: x_batchstep_activity_rec OUT NOCOPY gme_batch_step_activities%ROWTYPE,
2594: x_message_count OUT NOCOPY NUMBER,
2595: x_message_list OUT NOCOPY VARCHAR2,
2596: x_return_status OUT NOCOPY VARCHAR2

Line 2644: DEFAULT fnd_api.g_false,

2640: p_api_version IN NUMBER := 2.0,
2641: p_validation_level IN NUMBER
2642: := gme_common_pvt.g_max_errors,
2643: p_init_msg_list IN VARCHAR2
2644: DEFAULT fnd_api.g_false,
2645: p_commit IN VARCHAR2
2646: DEFAULT fnd_api.g_false,
2647: p_org_code IN VARCHAR2,
2648: p_batchstep_activity_id IN NUMBER := NULL,

Line 2646: DEFAULT fnd_api.g_false,

2642: := gme_common_pvt.g_max_errors,
2643: p_init_msg_list IN VARCHAR2
2644: DEFAULT fnd_api.g_false,
2645: p_commit IN VARCHAR2
2646: DEFAULT fnd_api.g_false,
2647: p_org_code IN VARCHAR2,
2648: p_batchstep_activity_id IN NUMBER := NULL,
2649: p_batch_no IN VARCHAR2 := NULL,
2650: p_batchstep_no IN NUMBER := NULL,

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

2725:
2726: PROCEDURE convert_fpo (
2727: p_api_version IN NUMBER := 2.0
2728: ,p_validation_level IN NUMBER := gme_common_pvt.g_max_errors
2729: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
2730: ,p_commit IN VARCHAR2 := fnd_api.g_false
2731: ,x_message_count OUT NOCOPY NUMBER
2732: ,x_message_list OUT NOCOPY VARCHAR2
2733: ,p_enforce_vldt_check IN VARCHAR2 := fnd_api.g_true

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

2726: PROCEDURE convert_fpo (
2727: p_api_version IN NUMBER := 2.0
2728: ,p_validation_level IN NUMBER := gme_common_pvt.g_max_errors
2729: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
2730: ,p_commit IN VARCHAR2 := fnd_api.g_false
2731: ,x_message_count OUT NOCOPY NUMBER
2732: ,x_message_list OUT NOCOPY VARCHAR2
2733: ,p_enforce_vldt_check IN VARCHAR2 := fnd_api.g_true
2734: ,x_return_status OUT NOCOPY VARCHAR2

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

2729: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
2730: ,p_commit IN VARCHAR2 := fnd_api.g_false
2731: ,x_message_count OUT NOCOPY NUMBER
2732: ,x_message_list OUT NOCOPY VARCHAR2
2733: ,p_enforce_vldt_check IN VARCHAR2 := fnd_api.g_true
2734: ,x_return_status OUT NOCOPY VARCHAR2
2735: ,p_org_code IN VARCHAR2 := NULL
2736: ,p_batch_header IN gme_batch_header%ROWTYPE
2737: ,x_batch_header OUT NOCOPY gme_batch_header%ROWTYPE

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

2743: ,p_batch_offset IN NUMBER DEFAULT 0
2744: ,p_offset_type IN NUMBER DEFAULT 0
2745: ,p_plan_start_date IN gme_batch_header.plan_start_date%TYPE
2746: ,p_plan_cmplt_date IN gme_batch_header.plan_cmplt_date%TYPE
2747: ,p_use_shop_cal IN VARCHAR2 := fnd_api.g_false
2748: ,p_contiguity_override IN VARCHAR2 := fnd_api.g_true
2749: ,p_use_for_all IN VARCHAR2 := fnd_api.g_true);
2750:
2751: /*#

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

2744: ,p_offset_type IN NUMBER DEFAULT 0
2745: ,p_plan_start_date IN gme_batch_header.plan_start_date%TYPE
2746: ,p_plan_cmplt_date IN gme_batch_header.plan_cmplt_date%TYPE
2747: ,p_use_shop_cal IN VARCHAR2 := fnd_api.g_false
2748: ,p_contiguity_override IN VARCHAR2 := fnd_api.g_true
2749: ,p_use_for_all IN VARCHAR2 := fnd_api.g_true);
2750:
2751: /*#
2752: * Create a pending product lot. Note that identification must be provided:

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

2745: ,p_plan_start_date IN gme_batch_header.plan_start_date%TYPE
2746: ,p_plan_cmplt_date IN gme_batch_header.plan_cmplt_date%TYPE
2747: ,p_use_shop_cal IN VARCHAR2 := fnd_api.g_false
2748: ,p_contiguity_override IN VARCHAR2 := fnd_api.g_true
2749: ,p_use_for_all IN VARCHAR2 := fnd_api.g_true);
2750:
2751: /*#
2752: * Create a pending product lot. Note that identification must be provided:
2753: * material detail id or batch_id, line_no, line_type or

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

2810: PROCEDURE create_pending_product_lot
2811: (p_api_version IN NUMBER
2812: ,p_validation_level IN NUMBER
2813: := gme_common_pvt.g_max_errors
2814: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
2815: ,p_commit IN VARCHAR2 := fnd_api.g_false
2816: ,x_message_count OUT NOCOPY NUMBER
2817: ,x_message_list OUT NOCOPY VARCHAR2
2818: ,x_return_status OUT NOCOPY VARCHAR2

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

2811: (p_api_version IN NUMBER
2812: ,p_validation_level IN NUMBER
2813: := gme_common_pvt.g_max_errors
2814: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
2815: ,p_commit IN VARCHAR2 := fnd_api.g_false
2816: ,x_message_count OUT NOCOPY NUMBER
2817: ,x_message_list OUT NOCOPY VARCHAR2
2818: ,x_return_status OUT NOCOPY VARCHAR2
2819: ,p_batch_header_rec IN gme_batch_header%ROWTYPE

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

2817: ,x_message_list OUT NOCOPY VARCHAR2
2818: ,x_return_status OUT NOCOPY VARCHAR2
2819: ,p_batch_header_rec IN gme_batch_header%ROWTYPE
2820: ,p_org_code IN VARCHAR2
2821: ,p_create_lot IN VARCHAR2 := fnd_api.g_false
2822: ,p_generate_lot IN VARCHAR2 := fnd_api.g_false
2823: ,p_generate_parent_lot IN VARCHAR2 := fnd_api.g_false
2824: ,p_material_detail_rec IN gme_material_details%ROWTYPE
2825: /* nsinghi bug#4486074 Added the p_expiration_dt parameter. */

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

2818: ,x_return_status OUT NOCOPY VARCHAR2
2819: ,p_batch_header_rec IN gme_batch_header%ROWTYPE
2820: ,p_org_code IN VARCHAR2
2821: ,p_create_lot IN VARCHAR2 := fnd_api.g_false
2822: ,p_generate_lot IN VARCHAR2 := fnd_api.g_false
2823: ,p_generate_parent_lot IN VARCHAR2 := fnd_api.g_false
2824: ,p_material_detail_rec IN gme_material_details%ROWTYPE
2825: /* nsinghi bug#4486074 Added the p_expiration_dt parameter. */
2826: ,p_expiration_date IN mtl_lot_numbers.expiration_date%TYPE := NULL

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

2819: ,p_batch_header_rec IN gme_batch_header%ROWTYPE
2820: ,p_org_code IN VARCHAR2
2821: ,p_create_lot IN VARCHAR2 := fnd_api.g_false
2822: ,p_generate_lot IN VARCHAR2 := fnd_api.g_false
2823: ,p_generate_parent_lot IN VARCHAR2 := fnd_api.g_false
2824: ,p_material_detail_rec IN gme_material_details%ROWTYPE
2825: /* nsinghi bug#4486074 Added the p_expiration_dt parameter. */
2826: ,p_expiration_date IN mtl_lot_numbers.expiration_date%TYPE := NULL
2827: ,p_pending_product_lots_rec IN gme_pending_product_lots%ROWTYPE

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

2872: PROCEDURE update_pending_product_lot
2873: (p_api_version IN NUMBER
2874: ,p_validation_level IN NUMBER
2875: := gme_common_pvt.g_max_errors
2876: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
2877: ,p_commit IN VARCHAR2 := fnd_api.g_false
2878: ,x_message_count OUT NOCOPY NUMBER
2879: ,x_message_list OUT NOCOPY VARCHAR2
2880: ,x_return_status OUT NOCOPY VARCHAR2

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

2873: (p_api_version IN NUMBER
2874: ,p_validation_level IN NUMBER
2875: := gme_common_pvt.g_max_errors
2876: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
2877: ,p_commit IN VARCHAR2 := fnd_api.g_false
2878: ,x_message_count OUT NOCOPY NUMBER
2879: ,x_message_list OUT NOCOPY VARCHAR2
2880: ,x_return_status OUT NOCOPY VARCHAR2
2881: ,p_batch_header_rec IN gme_batch_header%ROWTYPE

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

2928: PROCEDURE delete_pending_product_lot
2929: (p_api_version IN NUMBER
2930: ,p_validation_level IN NUMBER
2931: := gme_common_pvt.g_max_errors
2932: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
2933: ,p_commit IN VARCHAR2 := fnd_api.g_false
2934: ,x_message_count OUT NOCOPY NUMBER
2935: ,x_message_list OUT NOCOPY VARCHAR2
2936: ,x_return_status OUT NOCOPY VARCHAR2

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

2929: (p_api_version IN NUMBER
2930: ,p_validation_level IN NUMBER
2931: := gme_common_pvt.g_max_errors
2932: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
2933: ,p_commit IN VARCHAR2 := fnd_api.g_false
2934: ,x_message_count OUT NOCOPY NUMBER
2935: ,x_message_list OUT NOCOPY VARCHAR2
2936: ,x_return_status OUT NOCOPY VARCHAR2
2937: ,p_batch_header_rec IN gme_batch_header%ROWTYPE

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

2981: PROCEDURE unrelease_batch
2982: (p_api_version IN NUMBER
2983: ,p_validation_level IN NUMBER
2984: := gme_common_pvt.g_max_errors
2985: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
2986: ,p_commit IN VARCHAR2 := fnd_api.g_false
2987: ,x_message_count OUT NOCOPY NUMBER
2988: ,x_message_list OUT NOCOPY VARCHAR2
2989: ,x_return_status OUT NOCOPY VARCHAR2

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

2982: (p_api_version IN NUMBER
2983: ,p_validation_level IN NUMBER
2984: := gme_common_pvt.g_max_errors
2985: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
2986: ,p_commit IN VARCHAR2 := fnd_api.g_false
2987: ,x_message_count OUT NOCOPY NUMBER
2988: ,x_message_list OUT NOCOPY VARCHAR2
2989: ,x_return_status OUT NOCOPY VARCHAR2
2990: ,p_batch_header_rec IN gme_batch_header%ROWTYPE

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

3038: PROCEDURE unrelease_step
3039: (p_api_version IN NUMBER
3040: ,p_validation_level IN NUMBER
3041: := gme_common_pvt.g_max_errors
3042: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
3043: ,p_commit IN VARCHAR2 := fnd_api.g_false
3044: ,x_message_count OUT NOCOPY NUMBER
3045: ,x_message_list OUT NOCOPY VARCHAR2
3046: ,x_return_status OUT NOCOPY VARCHAR2

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

3039: (p_api_version IN NUMBER
3040: ,p_validation_level IN NUMBER
3041: := gme_common_pvt.g_max_errors
3042: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
3043: ,p_commit IN VARCHAR2 := fnd_api.g_false
3044: ,x_message_count OUT NOCOPY NUMBER
3045: ,x_message_list OUT NOCOPY VARCHAR2
3046: ,x_return_status OUT NOCOPY VARCHAR2
3047: ,p_batch_step_rec IN gme_batch_steps%ROWTYPE

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

3084: p_batch_header_rec (O) batch header to identify the batch to complete;
3085: p_org_code (O) organization code to identify the batch is conjunction with batch_no in p_batch_header_rec
3086: p_ignore_exception (O) indicates whether to ignore exceptions; if exceptions are ignored,
3087: x_exception_material_tbl won't be populated ever if exceptions were found
3088: p_validate_flexfields (O) indicates whether to validate flexfields... Defaults to fnd_api.g_false;
3089: this is used for direct completion only because of release batch
3090: x_batch_header_rec Output batch header record after complete
3091: x_exception_material_tbl Batch exceptions found during batch complete. Won't be reported if
3092: p_ignore_exception is set to fnd_api.g_true.

Line 3092: p_ignore_exception is set to fnd_api.g_true.

3088: p_validate_flexfields (O) indicates whether to validate flexfields... Defaults to fnd_api.g_false;
3089: this is used for direct completion only because of release batch
3090: x_batch_header_rec Output batch header record after complete
3091: x_exception_material_tbl Batch exceptions found during batch complete. Won't be reported if
3092: p_ignore_exception is set to fnd_api.g_true.
3093: x_return_status outcome of the API call
3094: S - Success
3095: E - Error
3096: U - Unexpected Error

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

3099: PROCEDURE complete_batch
3100: (p_api_version IN NUMBER
3101: ,p_validation_level IN NUMBER
3102: := gme_common_pvt.g_max_errors
3103: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
3104: ,p_commit IN VARCHAR2 := fnd_api.g_false
3105: ,x_message_count OUT NOCOPY NUMBER
3106: ,x_message_list OUT NOCOPY VARCHAR2
3107: ,x_return_status OUT NOCOPY VARCHAR2

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

3100: (p_api_version IN NUMBER
3101: ,p_validation_level IN NUMBER
3102: := gme_common_pvt.g_max_errors
3103: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
3104: ,p_commit IN VARCHAR2 := fnd_api.g_false
3105: ,x_message_count OUT NOCOPY NUMBER
3106: ,x_message_list OUT NOCOPY VARCHAR2
3107: ,x_return_status OUT NOCOPY VARCHAR2
3108: ,p_batch_header_rec IN gme_batch_header%ROWTYPE

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

3106: ,x_message_list OUT NOCOPY VARCHAR2
3107: ,x_return_status OUT NOCOPY VARCHAR2
3108: ,p_batch_header_rec IN gme_batch_header%ROWTYPE
3109: ,p_org_code IN VARCHAR2
3110: ,p_ignore_exception IN VARCHAR2 := fnd_api.g_false
3111: ,p_validate_flexfields IN VARCHAR2 := fnd_api.g_false
3112: ,x_batch_header_rec OUT NOCOPY gme_batch_header%ROWTYPE
3113: ,x_exception_material_tbl OUT NOCOPY gme_common_pvt.exceptions_tab);
3114:

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

3107: ,x_return_status OUT NOCOPY VARCHAR2
3108: ,p_batch_header_rec IN gme_batch_header%ROWTYPE
3109: ,p_org_code IN VARCHAR2
3110: ,p_ignore_exception IN VARCHAR2 := fnd_api.g_false
3111: ,p_validate_flexfields IN VARCHAR2 := fnd_api.g_false
3112: ,x_batch_header_rec OUT NOCOPY gme_batch_header%ROWTYPE
3113: ,x_exception_material_tbl OUT NOCOPY gme_common_pvt.exceptions_tab);
3114:
3115: /*#

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

3151: p_batch_no (O) batch_no to identify the step
3152: p_org_code (O) organization code to identify the step is conjunction with batch_no in p_batch_header_rec
3153: p_ignore_exception (O) indicates whether to ignore exceptions; if exceptions are ignored,
3154: x_exception_material_tbl won't be populated ever if exceptions were found
3155: p_override_quality (O) Override quality indicator; defaults to fnd_api.g_false
3156: p_validate_flexfields (O) indicates whether to validate flexfields... Defaults to fnd_api.g_false;
3157: this is used for direct step completion (pending_batch) only, because of release batch
3158: x_batch_step_rec Output batch step record after complete
3159: x_exception_material_tbl Material exceptions found in complete step (only those associated to step)

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

3152: p_org_code (O) organization code to identify the step is conjunction with batch_no in p_batch_header_rec
3153: p_ignore_exception (O) indicates whether to ignore exceptions; if exceptions are ignored,
3154: x_exception_material_tbl won't be populated ever if exceptions were found
3155: p_override_quality (O) Override quality indicator; defaults to fnd_api.g_false
3156: p_validate_flexfields (O) indicates whether to validate flexfields... Defaults to fnd_api.g_false;
3157: this is used for direct step completion (pending_batch) only, because of release batch
3158: x_batch_step_rec Output batch step record after complete
3159: x_exception_material_tbl Material exceptions found in complete step (only those associated to step)
3160: x_return_status outcome of the API call

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

3166: PROCEDURE complete_step
3167: (p_api_version IN NUMBER
3168: ,p_validation_level IN NUMBER
3169: := gme_common_pvt.g_max_errors
3170: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
3171: ,p_commit IN VARCHAR2 := fnd_api.g_false
3172: ,x_message_count OUT NOCOPY NUMBER
3173: ,x_message_list OUT NOCOPY VARCHAR2
3174: ,x_return_status OUT NOCOPY VARCHAR2

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

3167: (p_api_version IN NUMBER
3168: ,p_validation_level IN NUMBER
3169: := gme_common_pvt.g_max_errors
3170: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
3171: ,p_commit IN VARCHAR2 := fnd_api.g_false
3172: ,x_message_count OUT NOCOPY NUMBER
3173: ,x_message_list OUT NOCOPY VARCHAR2
3174: ,x_return_status OUT NOCOPY VARCHAR2
3175: ,p_batch_step_rec IN gme_batch_steps%ROWTYPE

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

3174: ,x_return_status OUT NOCOPY VARCHAR2
3175: ,p_batch_step_rec IN gme_batch_steps%ROWTYPE
3176: ,p_batch_no IN VARCHAR2
3177: ,p_org_code IN VARCHAR2
3178: ,p_ignore_exception IN VARCHAR2 := fnd_api.g_false
3179: ,p_override_quality IN VARCHAR2 := fnd_api.g_false
3180: ,p_validate_flexfields IN VARCHAR2 := fnd_api.g_false
3181: ,x_batch_step_rec OUT NOCOPY gme_batch_steps%ROWTYPE
3182: ,x_exception_material_tbl OUT NOCOPY gme_common_pvt.exceptions_tab);

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

3175: ,p_batch_step_rec IN gme_batch_steps%ROWTYPE
3176: ,p_batch_no IN VARCHAR2
3177: ,p_org_code IN VARCHAR2
3178: ,p_ignore_exception IN VARCHAR2 := fnd_api.g_false
3179: ,p_override_quality IN VARCHAR2 := fnd_api.g_false
3180: ,p_validate_flexfields IN VARCHAR2 := fnd_api.g_false
3181: ,x_batch_step_rec OUT NOCOPY gme_batch_steps%ROWTYPE
3182: ,x_exception_material_tbl OUT NOCOPY gme_common_pvt.exceptions_tab);
3183:

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

3176: ,p_batch_no IN VARCHAR2
3177: ,p_org_code IN VARCHAR2
3178: ,p_ignore_exception IN VARCHAR2 := fnd_api.g_false
3179: ,p_override_quality IN VARCHAR2 := fnd_api.g_false
3180: ,p_validate_flexfields IN VARCHAR2 := fnd_api.g_false
3181: ,x_batch_step_rec OUT NOCOPY gme_batch_steps%ROWTYPE
3182: ,x_exception_material_tbl OUT NOCOPY gme_common_pvt.exceptions_tab);
3183:
3184: /*#

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

3215: p_batch_header_rec (O) batch header to identify the batch to release;
3216: p_org_code (O) organization code to identify the batch is conjunction with batch_no in p_batch_header_rec
3217: p_ignore_exception (O) indicates whether to ignore exceptions; if exceptions are ignored,
3218: x_exception_material_tbl won't be populated even if exceptions were found
3219: p_validate_flexfields (O) indicates whether to validate flexfields... Defaults to fnd_api.g_false;
3220: x_batch_header_rec Output batch header record after release
3221: x_exception_material_tbl Batch exceptions found in release batch
3222: x_return_status outcome of the API call
3223: S - Success

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

3228: PROCEDURE release_batch
3229: (p_api_version IN NUMBER
3230: ,p_validation_level IN NUMBER
3231: := gme_common_pvt.g_max_errors
3232: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
3233: ,p_commit IN VARCHAR2 := fnd_api.g_false
3234: ,x_message_count OUT NOCOPY NUMBER
3235: ,x_message_list OUT NOCOPY VARCHAR2
3236: ,x_return_status OUT NOCOPY VARCHAR2

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

3229: (p_api_version IN NUMBER
3230: ,p_validation_level IN NUMBER
3231: := gme_common_pvt.g_max_errors
3232: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
3233: ,p_commit IN VARCHAR2 := fnd_api.g_false
3234: ,x_message_count OUT NOCOPY NUMBER
3235: ,x_message_list OUT NOCOPY VARCHAR2
3236: ,x_return_status OUT NOCOPY VARCHAR2
3237: ,p_batch_header_rec IN gme_batch_header%ROWTYPE

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

3235: ,x_message_list OUT NOCOPY VARCHAR2
3236: ,x_return_status OUT NOCOPY VARCHAR2
3237: ,p_batch_header_rec IN gme_batch_header%ROWTYPE
3238: ,p_org_code IN VARCHAR2
3239: ,p_ignore_exception IN VARCHAR2 := fnd_api.g_false
3240: ,p_validate_flexfields IN VARCHAR2 := fnd_api.g_false
3241: ,x_batch_header_rec OUT NOCOPY gme_batch_header%ROWTYPE
3242: ,x_exception_material_tbl OUT NOCOPY gme_common_pvt.exceptions_tab);
3243:

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

3236: ,x_return_status OUT NOCOPY VARCHAR2
3237: ,p_batch_header_rec IN gme_batch_header%ROWTYPE
3238: ,p_org_code IN VARCHAR2
3239: ,p_ignore_exception IN VARCHAR2 := fnd_api.g_false
3240: ,p_validate_flexfields IN VARCHAR2 := fnd_api.g_false
3241: ,x_batch_header_rec OUT NOCOPY gme_batch_header%ROWTYPE
3242: ,x_exception_material_tbl OUT NOCOPY gme_common_pvt.exceptions_tab);
3243:
3244: /*#

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

3279: p_batch_no (O) batch_no to identify the step
3280: p_org_code (O) organization code to identify the step is conjunction with batch_no in p_batch_header_rec
3281: p_ignore_exception (O) indicates whether to ignore exceptions; if exceptions are ignored,
3282: x_exception_material_tbl won't be populated ever if exceptions were found
3283: p_validate_flexfields (O) indicates whether to validate flexfields... Defaults to fnd_api.g_false;
3284: x_batch_step_rec Output batch step record after release
3285: x_exception_material_tbl Material exceptions found in release step (only those associated to step and processed dep steps)
3286: x_return_status outcome of the API call
3287: S - Success

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

3292: PROCEDURE release_step
3293: (p_api_version IN NUMBER
3294: ,p_validation_level IN NUMBER
3295: := gme_common_pvt.g_max_errors
3296: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
3297: ,p_commit IN VARCHAR2 := fnd_api.g_false
3298: ,x_message_count OUT NOCOPY NUMBER
3299: ,x_message_list OUT NOCOPY VARCHAR2
3300: ,x_return_status OUT NOCOPY VARCHAR2

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

3293: (p_api_version IN NUMBER
3294: ,p_validation_level IN NUMBER
3295: := gme_common_pvt.g_max_errors
3296: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
3297: ,p_commit IN VARCHAR2 := fnd_api.g_false
3298: ,x_message_count OUT NOCOPY NUMBER
3299: ,x_message_list OUT NOCOPY VARCHAR2
3300: ,x_return_status OUT NOCOPY VARCHAR2
3301: ,p_batch_step_rec IN gme_batch_steps%ROWTYPE

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

3300: ,x_return_status OUT NOCOPY VARCHAR2
3301: ,p_batch_step_rec IN gme_batch_steps%ROWTYPE
3302: ,p_batch_no IN VARCHAR2
3303: ,p_org_code IN VARCHAR2
3304: ,p_ignore_exception IN VARCHAR2 := fnd_api.g_false
3305: ,p_validate_flexfields IN VARCHAR2 := fnd_api.g_false
3306: ,x_batch_step_rec OUT NOCOPY gme_batch_steps%ROWTYPE
3307: ,x_exception_material_tbl OUT NOCOPY gme_common_pvt.exceptions_tab);
3308:

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

3301: ,p_batch_step_rec IN gme_batch_steps%ROWTYPE
3302: ,p_batch_no IN VARCHAR2
3303: ,p_org_code IN VARCHAR2
3304: ,p_ignore_exception IN VARCHAR2 := fnd_api.g_false
3305: ,p_validate_flexfields IN VARCHAR2 := fnd_api.g_false
3306: ,x_batch_step_rec OUT NOCOPY gme_batch_steps%ROWTYPE
3307: ,x_exception_material_tbl OUT NOCOPY gme_common_pvt.exceptions_tab);
3308:
3309: /*#

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

3353: PROCEDURE process_group
3354: (p_api_version IN NUMBER
3355: ,p_validation_level IN NUMBER
3356: := gme_common_pvt.g_max_errors
3357: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
3358: ,p_commit IN VARCHAR2 := fnd_api.g_false
3359: ,p_group_name IN VARCHAR2
3360: ,p_org_code IN VARCHAR2
3361: ,p_action IN NUMBER

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

3354: (p_api_version IN NUMBER
3355: ,p_validation_level IN NUMBER
3356: := gme_common_pvt.g_max_errors
3357: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
3358: ,p_commit IN VARCHAR2 := fnd_api.g_false
3359: ,p_group_name IN VARCHAR2
3360: ,p_org_code IN VARCHAR2
3361: ,p_action IN NUMBER
3362: ,p_on_error_flag IN VARCHAR2