DBA Data[Home] [Help]

APPS.WSH_DETAILS_VALIDATIONS dependencies on WSH_DELIVERY_AUTOCREATE

Line 880: x_del_params OUT NOCOPY wsh_delivery_autocreate.grp_attr_rec_type,

876:
877:
878: PROCEDURE check_assign_del_multi(
879: p_detail_rows IN wsh_util_core.id_tab_type,
880: x_del_params OUT NOCOPY wsh_delivery_autocreate.grp_attr_rec_type,
881: x_return_status OUT NOCOPY VARCHAR2) IS
882:
883: l_del_rows wsh_util_core.id_tab_type;
884: l_group_rows wsh_util_core.id_tab_type;

Line 895: l_attr_tab wsh_delivery_autocreate.grp_attr_tab_type;

891: from wsh_delivery_assignments_v
892: where delivery_detail_id = detail_id
893: and delivery_id IS NOT NULL;
894:
895: l_attr_tab wsh_delivery_autocreate.grp_attr_tab_type;
896: l_group_tab wsh_delivery_autocreate.grp_attr_tab_type;
897: l_action_rec wsh_delivery_autocreate.action_rec_type;
898: l_target_rec wsh_delivery_autocreate.grp_attr_rec_type;
899: l_matched_entities wsh_util_core.id_tab_type;

Line 896: l_group_tab wsh_delivery_autocreate.grp_attr_tab_type;

892: where delivery_detail_id = detail_id
893: and delivery_id IS NOT NULL;
894:
895: l_attr_tab wsh_delivery_autocreate.grp_attr_tab_type;
896: l_group_tab wsh_delivery_autocreate.grp_attr_tab_type;
897: l_action_rec wsh_delivery_autocreate.action_rec_type;
898: l_target_rec wsh_delivery_autocreate.grp_attr_rec_type;
899: l_matched_entities wsh_util_core.id_tab_type;
900: l_out_rec wsh_delivery_autocreate.out_rec_type;

Line 897: l_action_rec wsh_delivery_autocreate.action_rec_type;

893: and delivery_id IS NOT NULL;
894:
895: l_attr_tab wsh_delivery_autocreate.grp_attr_tab_type;
896: l_group_tab wsh_delivery_autocreate.grp_attr_tab_type;
897: l_action_rec wsh_delivery_autocreate.action_rec_type;
898: l_target_rec wsh_delivery_autocreate.grp_attr_rec_type;
899: l_matched_entities wsh_util_core.id_tab_type;
900: l_out_rec wsh_delivery_autocreate.out_rec_type;
901: l_generic_flag varchar2(1);

Line 898: l_target_rec wsh_delivery_autocreate.grp_attr_rec_type;

894:
895: l_attr_tab wsh_delivery_autocreate.grp_attr_tab_type;
896: l_group_tab wsh_delivery_autocreate.grp_attr_tab_type;
897: l_action_rec wsh_delivery_autocreate.action_rec_type;
898: l_target_rec wsh_delivery_autocreate.grp_attr_rec_type;
899: l_matched_entities wsh_util_core.id_tab_type;
900: l_out_rec wsh_delivery_autocreate.out_rec_type;
901: l_generic_flag varchar2(1);
902:

Line 900: l_out_rec wsh_delivery_autocreate.out_rec_type;

896: l_group_tab wsh_delivery_autocreate.grp_attr_tab_type;
897: l_action_rec wsh_delivery_autocreate.action_rec_type;
898: l_target_rec wsh_delivery_autocreate.grp_attr_rec_type;
899: l_matched_entities wsh_util_core.id_tab_type;
900: l_out_rec wsh_delivery_autocreate.out_rec_type;
901: l_generic_flag varchar2(1);
902:
903:
904:

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

968:
969:
970:
971: -- Call autocreate deliveries to group details together. Check if the
972: -- number of deliveries created is 1. Use the wsh_delivery_autocreate
973: -- package to return a list of matching delivery parameters and then
974: -- delete these tables so that subsequent calls are not effected.
975: --p_init_flag should be N (if it is Y, all the tables get deleted at
976: --the end of the call to autocreate_deliveries which should not

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

979: --
980: -- Debug Statements
981: --
982: IF l_debug_on THEN
983: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_AUTOCREATE.AUTOCREATE_DELIVERIES',WSH_DEBUG_SV.C_PROC_LEVEL);
984: END IF;
985: --
986: FOR i in 1..p_detail_rows.count LOOP
987:

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

993: l_action_rec.action := 'MATCH_GROUPS';
994: -- l_action_rec.check_single_grp := 'Y';
995:
996:
997: WSH_DELIVERY_AUTOCREATE.Find_Matching_Groups(p_attr_tab => l_attr_tab,
998: p_action_rec => l_action_rec,
999: p_target_rec => l_target_rec,
1000: p_group_tab => l_group_tab,
1001: x_matched_entities => l_matched_entities,