DBA Data[Home] [Help]

APPS.GME_COMMON_PVT dependencies on GME_BATCH_HEADER

Line 194: TYPE batch_headers_tab IS TABLE OF gme_batch_header%ROWTYPE

190:
191: TYPE field_values_tab IS TABLE OF p_field
192: INDEX BY BINARY_INTEGER;
193:
194: TYPE batch_headers_tab IS TABLE OF gme_batch_header%ROWTYPE
195: INDEX BY BINARY_INTEGER;
196:
197: TYPE material_details_tab IS TABLE OF gme_material_details%ROWTYPE
198: INDEX BY BINARY_INTEGER;

Line 329: ,p_batch_header_rec IN gme_batch_header%ROWTYPE

325:
326: PROCEDURE construct_material_detail (
327: p_formula_detail_rec IN fm_matl_dtl%ROWTYPE
328: ,p_item_master_rec IN mtl_system_items_kfv%ROWTYPE
329: ,p_batch_header_rec IN gme_batch_header%ROWTYPE
330: ,x_material_detail_rec OUT NOCOPY gme_material_details%ROWTYPE
331: ,x_return_status OUT NOCOPY VARCHAR2);
332:
333: FUNCTION get_process_loss (

Line 342: p_batch_header_rec IN gme_batch_header%ROWTYPE

338: ,p_total_output_qty_pre_scale IN NUMBER)
339: RETURN NUMBER;
340:
341: PROCEDURE create_document_no (
342: p_batch_header_rec IN gme_batch_header%ROWTYPE
343: ,x_batch_header_rec IN OUT NOCOPY gme_batch_header%ROWTYPE);
344:
345: FUNCTION calc_date_from_prod_rule (
346: p_organization_id IN NUMBER

Line 343: ,x_batch_header_rec IN OUT NOCOPY gme_batch_header%ROWTYPE);

339: RETURN NUMBER;
340:
341: PROCEDURE create_document_no (
342: p_batch_header_rec IN gme_batch_header%ROWTYPE
343: ,x_batch_header_rec IN OUT NOCOPY gme_batch_header%ROWTYPE);
344:
345: FUNCTION calc_date_from_prod_rule (
346: p_organization_id IN NUMBER
347: ,p_inventory_item_id IN NUMBER

Line 356: p_batch_header_rec IN gme_batch_header%ROWTYPE

352: ,x_cmplt_date IN OUT NOCOPY DATE)
353: RETURN BOOLEAN;
354:
355: PROCEDURE calc_mtl_req_date (
356: p_batch_header_rec IN gme_batch_header%ROWTYPE
357: DEFAULT NULL
358: ,p_batchstep_rec IN gme_batch_steps%ROWTYPE
359: DEFAULT NULL
360: ,p_mtl_dtl_rec IN gme_material_details%ROWTYPE

Line 444: p_batch_header_rec IN gme_batch_header%ROWTYPE

440: p_material_detail_id IN gme_material_details.material_detail_id%TYPE)
441: RETURN BOOLEAN;
442:
443: FUNCTION get_batch_header (
444: p_batch_header_rec IN gme_batch_header%ROWTYPE
445: ,p_org_code IN VARCHAR2
446: ,p_batch_type IN NUMBER
447: ,x_batch_header_rec OUT NOCOPY gme_batch_header%ROWTYPE)
448: RETURN BOOLEAN;

Line 447: ,x_batch_header_rec OUT NOCOPY gme_batch_header%ROWTYPE)

443: FUNCTION get_batch_header (
444: p_batch_header_rec IN gme_batch_header%ROWTYPE
445: ,p_org_code IN VARCHAR2
446: ,p_batch_type IN NUMBER
447: ,x_batch_header_rec OUT NOCOPY gme_batch_header%ROWTYPE)
448: RETURN BOOLEAN;
449:
450: FUNCTION get_batch_step (
451: p_batch_step_rec IN gme_batch_steps%ROWTYPE

Line 455: ,x_batch_header_rec OUT NOCOPY gme_batch_header%ROWTYPE)

451: p_batch_step_rec IN gme_batch_steps%ROWTYPE
452: ,p_org_code IN VARCHAR2
453: ,p_batch_no IN VARCHAR2
454: ,x_batch_step_rec OUT NOCOPY gme_batch_steps%ROWTYPE
455: ,x_batch_header_rec OUT NOCOPY gme_batch_header%ROWTYPE)
456: RETURN BOOLEAN;
457:
458: FUNCTION create_history (
459: p_batch_header_rec IN gme_batch_header%ROWTYPE

Line 459: p_batch_header_rec IN gme_batch_header%ROWTYPE

455: ,x_batch_header_rec OUT NOCOPY gme_batch_header%ROWTYPE)
456: RETURN BOOLEAN;
457:
458: FUNCTION create_history (
459: p_batch_header_rec IN gme_batch_header%ROWTYPE
460: ,p_original_status IN NUMBER
461: ,p_event_id IN NUMBER DEFAULT NULL)
462: RETURN BOOLEAN;
463:

Line 485: ,p_batch_header_rec IN gme_batch_header%ROWTYPE DEFAULT NULL

481: FUNCTION check_validity_rule_dates (
482: p_validity_rule_id IN NUMBER
483: ,p_start_date IN DATE
484: ,p_cmplt_date IN DATE
485: ,p_batch_header_rec IN gme_batch_header%ROWTYPE DEFAULT NULL
486: --Sunitha Ch. Bug 5336007 added the parameter p_validate_plan_dates_ind that indicates whether to validate
487: --value -0 Validate Only start date
488: --Value -1 Validate Both the dates
489: ,p_validate_plan_dates_ind IN NUMBER DEFAULT 0)

Line 520: ,x_batch_header_rec OUT NOCOPY gme_batch_header%ROWTYPE

516: p_material_detail_rec IN gme_material_details%ROWTYPE
517: ,p_org_code IN VARCHAR2
518: ,p_batch_no IN VARCHAR2
519: ,p_batch_type IN NUMBER
520: ,x_batch_header_rec OUT NOCOPY gme_batch_header%ROWTYPE
521: ,x_material_detail_rec OUT NOCOPY gme_material_details%ROWTYPE)
522: RETURN BOOLEAN;
523: -- Pawan Kumar Added for bug 5138929
524: FUNCTION check_close_period (

Line 531: p_batch_header_rec IN gme_batch_header%ROWTYPE

527: RETURN BOOLEAN;
528:
529: -- Bug 7562848 - Added parameter to bypass phantom check.
530: Procedure Validate_batch (
531: p_batch_header_rec IN gme_batch_header%ROWTYPE
532: ,p_org_code IN VARCHAR2
533: ,p_batch_type IN NUMBER
534: ,p_check_phantom IN VARCHAR2 DEFAULT 'Y'
535: ,x_batch_header_rec OUT NOCOPY gme_batch_header%ROWTYPE

Line 535: ,x_batch_header_rec OUT NOCOPY gme_batch_header%ROWTYPE

531: p_batch_header_rec IN gme_batch_header%ROWTYPE
532: ,p_org_code IN VARCHAR2
533: ,p_batch_type IN NUMBER
534: ,p_check_phantom IN VARCHAR2 DEFAULT 'Y'
535: ,x_batch_header_rec OUT NOCOPY gme_batch_header%ROWTYPE
536: ,x_message_count OUT NOCOPY NUMBER
537: ,x_message_list OUT NOCOPY VARCHAR2
538: ,x_return_status OUT NOCOPY VARCHAR2);
539:

Line 545: ,x_batch_header_rec OUT NOCOPY gme_batch_header%ROWTYPE

541: p_material_detail_rec IN gme_material_details%ROWTYPE
542: ,p_org_code IN VARCHAR2
543: ,p_batch_no IN VARCHAR2
544: ,p_batch_type IN NUMBER
545: ,x_batch_header_rec OUT NOCOPY gme_batch_header%ROWTYPE
546: ,x_material_detail_rec OUT NOCOPY gme_material_details%ROWTYPE
547: ,x_message_count OUT NOCOPY NUMBER
548: ,x_message_list OUT NOCOPY VARCHAR2
549: ,x_return_status OUT NOCOPY VARCHAR2);

Line 555: ,x_batch_header_rec OUT NOCOPY gme_batch_header%ROWTYPE

551: p_batch_step_rec IN gme_batch_steps%ROWTYPE
552: ,p_org_code IN VARCHAR2
553: ,p_batch_no IN VARCHAR2
554: ,x_batch_step_rec OUT NOCOPY gme_batch_steps%ROWTYPE
555: ,x_batch_header_rec OUT NOCOPY gme_batch_header%ROWTYPE
556: ,x_message_count OUT NOCOPY NUMBER
557: ,x_message_list OUT NOCOPY VARCHAR2
558: ,x_return_status OUT NOCOPY VARCHAR2);
559: