DBA Data[Home] [Help]

APPS.WMS_WAVE_PLANNING_PVT dependencies on WSH_DELIVERY_AUTOCREATE

Line 2492: l_attr_tab wsh_delivery_autocreate.grp_attr_tab_type;

2488: l_tbl_last number;
2489: l_mtrl_count NUMBER := 0;
2490: l_wdd_count NUMBER := 0;
2491:
2492: l_attr_tab wsh_delivery_autocreate.grp_attr_tab_type;
2493: l_action_rec wsh_delivery_autocreate.action_rec_type;
2494: l_target_rec wsh_delivery_autocreate.grp_attr_rec_type;
2495: l_group_info wsh_delivery_autocreate.grp_attr_tab_type;
2496: l_matched_entities wsh_util_core.id_tab_type;

Line 2493: l_action_rec wsh_delivery_autocreate.action_rec_type;

2489: l_mtrl_count NUMBER := 0;
2490: l_wdd_count NUMBER := 0;
2491:
2492: l_attr_tab wsh_delivery_autocreate.grp_attr_tab_type;
2493: l_action_rec wsh_delivery_autocreate.action_rec_type;
2494: l_target_rec wsh_delivery_autocreate.grp_attr_rec_type;
2495: l_group_info wsh_delivery_autocreate.grp_attr_tab_type;
2496: l_matched_entities wsh_util_core.id_tab_type;
2497: l_out_rec wsh_delivery_autocreate.out_rec_type;

Line 2494: l_target_rec wsh_delivery_autocreate.grp_attr_rec_type;

2490: l_wdd_count NUMBER := 0;
2491:
2492: l_attr_tab wsh_delivery_autocreate.grp_attr_tab_type;
2493: l_action_rec wsh_delivery_autocreate.action_rec_type;
2494: l_target_rec wsh_delivery_autocreate.grp_attr_rec_type;
2495: l_group_info wsh_delivery_autocreate.grp_attr_tab_type;
2496: l_matched_entities wsh_util_core.id_tab_type;
2497: l_out_rec wsh_delivery_autocreate.out_rec_type;
2498:

Line 2495: l_group_info wsh_delivery_autocreate.grp_attr_tab_type;

2491:
2492: l_attr_tab wsh_delivery_autocreate.grp_attr_tab_type;
2493: l_action_rec wsh_delivery_autocreate.action_rec_type;
2494: l_target_rec wsh_delivery_autocreate.grp_attr_rec_type;
2495: l_group_info wsh_delivery_autocreate.grp_attr_tab_type;
2496: l_matched_entities wsh_util_core.id_tab_type;
2497: l_out_rec wsh_delivery_autocreate.out_rec_type;
2498:
2499: TYPE group_match_seq_rec_type IS RECORD(

Line 2497: l_out_rec wsh_delivery_autocreate.out_rec_type;

2493: l_action_rec wsh_delivery_autocreate.action_rec_type;
2494: l_target_rec wsh_delivery_autocreate.grp_attr_rec_type;
2495: l_group_info wsh_delivery_autocreate.grp_attr_tab_type;
2496: l_matched_entities wsh_util_core.id_tab_type;
2497: l_out_rec wsh_delivery_autocreate.out_rec_type;
2498:
2499: TYPE group_match_seq_rec_type IS RECORD(
2500: delivery_detail_id NUMBER,
2501: match_group_id NUMBER,

Line 2631: wsh_Delivery_autocreate.Find_Matching_Groups(p_attr_tab => l_attr_tab,

2627: l_action_rec.group_by_header_flag := 'N';
2628:
2629: print_debug('Calling Find Matching Groups ', l_debug);
2630:
2631: wsh_Delivery_autocreate.Find_Matching_Groups(p_attr_tab => l_attr_tab,
2632: p_action_rec => l_action_rec,
2633: p_target_rec => l_target_rec,
2634: p_group_tab => l_group_info,
2635: x_matched_entities => l_matched_entities,

Line 9696: l_attr_tab wsh_delivery_autocreate.grp_attr_tab_type;

9692: FROM dual)
9693: CONNECT BY level <=
9694: LENGTH(txt) - LENGTH(REPLACE(txt, ',', '')) - 1);*/
9695:
9696: l_attr_tab wsh_delivery_autocreate.grp_attr_tab_type;
9697: l_action_rec wsh_delivery_autocreate.action_rec_type;
9698: l_target_rec wsh_delivery_autocreate.grp_attr_rec_type;
9699: l_group_info wsh_delivery_autocreate.grp_attr_tab_type;
9700: l_matched_entities wsh_util_core.id_tab_type;

Line 9697: l_action_rec wsh_delivery_autocreate.action_rec_type;

9693: CONNECT BY level <=
9694: LENGTH(txt) - LENGTH(REPLACE(txt, ',', '')) - 1);*/
9695:
9696: l_attr_tab wsh_delivery_autocreate.grp_attr_tab_type;
9697: l_action_rec wsh_delivery_autocreate.action_rec_type;
9698: l_target_rec wsh_delivery_autocreate.grp_attr_rec_type;
9699: l_group_info wsh_delivery_autocreate.grp_attr_tab_type;
9700: l_matched_entities wsh_util_core.id_tab_type;
9701: l_out_rec wsh_delivery_autocreate.out_rec_type;

Line 9698: l_target_rec wsh_delivery_autocreate.grp_attr_rec_type;

9694: LENGTH(txt) - LENGTH(REPLACE(txt, ',', '')) - 1);*/
9695:
9696: l_attr_tab wsh_delivery_autocreate.grp_attr_tab_type;
9697: l_action_rec wsh_delivery_autocreate.action_rec_type;
9698: l_target_rec wsh_delivery_autocreate.grp_attr_rec_type;
9699: l_group_info wsh_delivery_autocreate.grp_attr_tab_type;
9700: l_matched_entities wsh_util_core.id_tab_type;
9701: l_out_rec wsh_delivery_autocreate.out_rec_type;
9702: p_line_rows wsh_util_core.id_tab_type;

Line 9699: l_group_info wsh_delivery_autocreate.grp_attr_tab_type;

9695:
9696: l_attr_tab wsh_delivery_autocreate.grp_attr_tab_type;
9697: l_action_rec wsh_delivery_autocreate.action_rec_type;
9698: l_target_rec wsh_delivery_autocreate.grp_attr_rec_type;
9699: l_group_info wsh_delivery_autocreate.grp_attr_tab_type;
9700: l_matched_entities wsh_util_core.id_tab_type;
9701: l_out_rec wsh_delivery_autocreate.out_rec_type;
9702: p_line_rows wsh_util_core.id_tab_type;
9703: p_carton_grouping_tbl inv_move_order_pub.num_tbl_type;

Line 9701: l_out_rec wsh_delivery_autocreate.out_rec_type;

9697: l_action_rec wsh_delivery_autocreate.action_rec_type;
9698: l_target_rec wsh_delivery_autocreate.grp_attr_rec_type;
9699: l_group_info wsh_delivery_autocreate.grp_attr_tab_type;
9700: l_matched_entities wsh_util_core.id_tab_type;
9701: l_out_rec wsh_delivery_autocreate.out_rec_type;
9702: p_line_rows wsh_util_core.id_tab_type;
9703: p_carton_grouping_tbl inv_move_order_pub.num_tbl_type;
9704: p_move_order_line_tbl inv_move_order_pub.num_tbl_type;
9705: l_match_found boolean;

Line 10525: wsh_Delivery_autocreate.Find_Matching_Groups(p_attr_tab IN OUT NOCOPY grp_attr_tab_type,

10521: -- l_action_rec.check_single_grp := 'Y';
10522:
10523: print_debug('Calling Find Matching Groups ', l_debug);
10524: /*
10525: wsh_Delivery_autocreate.Find_Matching_Groups(p_attr_tab IN OUT NOCOPY grp_attr_tab_type,
10526: p_action_rec IN action_rec_type,
10527: p_target_rec IN grp_attr_rec_type,
10528: p_group_tab IN OUT NOCOPY grp_attr_tab_type,
10529: x_matched_entities OUT NOCOPY wsh_util_core.id_tab_type,

Line 10533: wsh_Delivery_autocreate.Find_Matching_Groups(p_attr_tab => l_attr_tab,

10529: x_matched_entities OUT NOCOPY wsh_util_core.id_tab_type,
10530: x_out_rec out NOCOPY out_rec_type,
10531: x_return_status out NOCOPY varchar2); */
10532: -- l_group_info.organization_id := p_organization_id;
10533: wsh_Delivery_autocreate.Find_Matching_Groups(p_attr_tab => l_attr_tab,
10534: p_action_rec => l_action_rec,
10535: p_target_rec => l_target_rec,
10536: p_group_tab => l_group_info,
10537: x_matched_entities => l_matched_entities,