APPS.WSH_DETAILS_VALIDATIONS dependencies on WSH_DELIVERY_AUTOCREATE

Line 920: x_del_params OUT NOCOPY wsh_delivery_autocreate.grp_attr_rec_type,

916:
917:
918: PROCEDURE check_assign_del_multi(
919: p_detail_rows IN wsh_util_core.id_tab_type,
920: x_del_params OUT NOCOPY wsh_delivery_autocreate.grp_attr_rec_type,
921: x_return_status OUT NOCOPY VARCHAR2) IS
922:
923: l_del_rows wsh_util_core.id_tab_type;
924: l_group_rows wsh_util_core.id_tab_type;

Line 935: l_attr_tab wsh_delivery_autocreate.grp_attr_tab_type;

931: from wsh_delivery_assignments_v
932: where delivery_detail_id = detail_id
933: and delivery_id IS NOT NULL;
934:
935: l_attr_tab wsh_delivery_autocreate.grp_attr_tab_type;
936: l_group_tab wsh_delivery_autocreate.grp_attr_tab_type;
937: l_action_rec wsh_delivery_autocreate.action_rec_type;
938: l_target_rec wsh_delivery_autocreate.grp_attr_rec_type;
939: l_matched_entities wsh_util_core.id_tab_type;

Line 936: l_group_tab wsh_delivery_autocreate.grp_attr_tab_type;

932: where delivery_detail_id = detail_id
933: and delivery_id IS NOT NULL;
934:
935: l_attr_tab wsh_delivery_autocreate.grp_attr_tab_type;
936: l_group_tab wsh_delivery_autocreate.grp_attr_tab_type;
937: l_action_rec wsh_delivery_autocreate.action_rec_type;
938: l_target_rec wsh_delivery_autocreate.grp_attr_rec_type;
939: l_matched_entities wsh_util_core.id_tab_type;
940: l_out_rec wsh_delivery_autocreate.out_rec_type;

Line 937: l_action_rec wsh_delivery_autocreate.action_rec_type;

933: and delivery_id IS NOT NULL;
934:
935: l_attr_tab wsh_delivery_autocreate.grp_attr_tab_type;
936: l_group_tab wsh_delivery_autocreate.grp_attr_tab_type;
937: l_action_rec wsh_delivery_autocreate.action_rec_type;
938: l_target_rec wsh_delivery_autocreate.grp_attr_rec_type;
939: l_matched_entities wsh_util_core.id_tab_type;
940: l_out_rec wsh_delivery_autocreate.out_rec_type;
941: l_generic_flag varchar2(1);

Line 938: l_target_rec wsh_delivery_autocreate.grp_attr_rec_type;

934:
935: l_attr_tab wsh_delivery_autocreate.grp_attr_tab_type;
936: l_group_tab wsh_delivery_autocreate.grp_attr_tab_type;
937: l_action_rec wsh_delivery_autocreate.action_rec_type;
938: l_target_rec wsh_delivery_autocreate.grp_attr_rec_type;
939: l_matched_entities wsh_util_core.id_tab_type;
940: l_out_rec wsh_delivery_autocreate.out_rec_type;
941: l_generic_flag varchar2(1);
942:

Line 940: l_out_rec wsh_delivery_autocreate.out_rec_type;

936: l_group_tab wsh_delivery_autocreate.grp_attr_tab_type;
937: l_action_rec wsh_delivery_autocreate.action_rec_type;
938: l_target_rec wsh_delivery_autocreate.grp_attr_rec_type;
939: l_matched_entities wsh_util_core.id_tab_type;
940: l_out_rec wsh_delivery_autocreate.out_rec_type;
941: l_generic_flag varchar2(1);
942:
943:
944:

Line 1012: -- number of deliveries created is 1. Use the wsh_delivery_autocreate

1008:
1009:
1010:
1011: -- Call autocreate deliveries to group details together. Check if the
1012: -- number of deliveries created is 1. Use the wsh_delivery_autocreate
1013: -- package to return a list of matching delivery parameters and then
1014: -- delete these tables so that subsequent calls are not effected.
1015: --p_init_flag should be N (if it is Y, all the tables get deleted at
1016: --the end of the call to autocreate_deliveries which should not

Line 1023: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_AUTOCREATE.AUTOCREATE_DELIVERIES',WSH_DEBUG_SV.C_PROC_LEVEL);

1019: --
1020: -- Debug Statements
1021: --
1022: IF l_debug_on THEN
1023: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_AUTOCREATE.AUTOCREATE_DELIVERIES',WSH_DEBUG_SV.C_PROC_LEVEL);
1024: END IF;
1025: --
1026: FOR i in 1..p_detail_rows.count LOOP
1027:

Line 1037: WSH_DELIVERY_AUTOCREATE.Find_Matching_Groups(p_attr_tab => l_attr_tab,

1033: l_action_rec.action := 'MATCH_GROUPS';
1034: -- l_action_rec.check_single_grp := 'Y';
1035:
1036:
1037: WSH_DELIVERY_AUTOCREATE.Find_Matching_Groups(p_attr_tab => l_attr_tab,
1038: p_action_rec => l_action_rec,
1039: p_target_rec => l_target_rec,
1040: p_group_tab => l_group_tab,
1041: x_matched_entities => l_matched_entities,