[Home] [Help]
338: --========================================================================
339: -- PROCEDURE : validate_constraint_dlvy Called by constraint Wrapper API
340: -- and the Group API.
341: --
342: -- PARAMETERS: p_init_msg_list FND_API.G_TRUE to reset list
343: -- p_action_code Predefined action code
344: -- p_exception_list Compatibility classes to skip if any
345: -- indexed by class code numbers
346: -- p_in_ids Table of delivery ids to process
382: --========================================================================
383:
384:
385: PROCEDURE validate_constraint_dlvy(
386: p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false,
387: p_action_code IN VARCHAR2 DEFAULT NULL,
388: p_exception_list IN WSH_UTIL_CORE.Column_Tab_Type,
389: p_in_ids IN WSH_UTIL_CORE.id_tab_type,
390: p_delivery_info IN delivery_ccinfo_tab_type,
408: --========================================================================
409: -- PROCEDURE : validate_constraint_dleg Called by constraint Wrapper API
410: -- and the Lane search API.
411: --
412: -- PARAMETERS: p_init_msg_list FND_API.G_TRUE to reset list
413: -- p_action_code Predefined action code
414: -- p_exception_list Compatibility classes to skip if any
415: -- indexed by class code numbers
416: -- p_delivery_leg_rec Input delivery leg record
426: -- A. Lane search for delivery leg (DLS)
427: --========================================================================
428:
429: PROCEDURE validate_constraint_dleg(
430: p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false,
431: p_action_code IN VARCHAR2 DEFAULT NULL,
432: p_exception_list IN WSH_UTIL_CORE.Column_Tab_Type,
433: p_delivery_leg_rec IN dleg_ccinfo_rec_type,
434: p_target_trip IN trip_ccinfo_tab_type,
446: --========================================================================
447: -- PROCEDURE : validate_constraint_dlvb Called by constraint Wrapper API
448: -- and the Group API.
449: --
450: -- PARAMETERS: p_init_msg_list FND_API.G_TRUE to reset list
451: -- p_action_code Predefined action code
452: -- p_exception_list Compatibility classes to skip if any
453: -- indexed by class code numbers
454: -- p_in_ids Table of delivery ids to process
482: -- to the target delivery
483: --========================================================================
484:
485: PROCEDURE validate_constraint_dlvb(
486: p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false,
487: p_action_code IN VARCHAR2 DEFAULT NULL,
488: p_exception_list IN WSH_UTIL_CORE.Column_Tab_Type,
489: p_in_ids IN WSH_UTIL_CORE.id_tab_type,
490: p_del_detail_info IN detail_ccinfo_tab_type,
505: --========================================================================
506: -- PROCEDURE : validate_constraint_trip Called by constraint Wrapper API
507: -- and the Group API.
508: --
509: -- PARAMETERS: p_init_msg_list FND_API.G_TRUE to reset list
510: -- p_action_code Predefined action code
511: -- p_exception_list Compatibility classes to skip if any
512: -- indexed by class code numbers
513: -- p_trip_info Table of Trip records to process
526: -- A. Update an existing trip (UPT)
527: --========================================================================
528:
529: PROCEDURE validate_constraint_trip(
530: p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false,
531: p_action_code IN VARCHAR2 DEFAULT NULL,
532: p_exception_list IN WSH_UTIL_CORE.Column_Tab_Type,
533: p_trip_info IN trip_ccinfo_tab_type,
534: p_trip_assigned_dels IN delivery_ccinfo_tab_type,
545: --========================================================================
546: -- PROCEDURE : validate_constraint_stop Called by constraint Wrapper API
547: -- and the Group API.
548: --
549: -- PARAMETERS: p_init_msg_list FND_API.G_TRUE to reset list
550: -- p_action_code Predefined action code
551: -- p_exception_list Compatibility classes to skip if any
552: -- indexed by class code numbers
553: -- p_stop_info Table of Stop records to process
564: -- C. Delete a stop (DTS)
565: --========================================================================
566:
567: PROCEDURE validate_constraint_stop(
568: p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false,
569: p_action_code IN VARCHAR2 DEFAULT NULL,
570: p_exception_list IN WSH_UTIL_CORE.Column_Tab_Type,
571: p_stop_info IN stop_ccinfo_tab_type,
572: p_parent_trip_info IN trip_ccinfo_tab_type,
710: --***************************************************************************--
711: --========================================================================
712: -- PROCEDURE : VALIDATE_CONSTRAINT_DECONSOL
713: --
714: -- PARAMETERS: p_init_msg_list FND_API.G_TRUE to reset list
715: -- p_delivery_info Table of delivery records to process
716: -- Only one of p_in_ids and p_delivery_info should be passed
717: -- p_in_ids Table of delivery ids to process
718: -- p_rule_deconsol_location Default deconsolidation location passed
724: -- x_return_status Return status
725: -- COMMENT : This procedure stamps each of the deliveries with deconsolidation locations,
726: -- procedure is to find deconsolidation locations for a group of deliveries passed
727: --========================================================================
728: PROCEDURE validate_constraint_deconsol( p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false,
729: p_delivery_info IN OUT NOCOPY delivery_ccinfo_tab_type,
730: p_in_ids IN wsh_util_core.id_tab_type,
731: p_rule_deconsol_location IN NUMBER default NULL,
732: p_rule_override_deconsol IN BOOLEAN DEFAULT FALSE,