DBA Data[Home] [Help]

APPS.WSH_DELIVERY_AUTOCREATE dependencies on WSH_GLBL_VAR_STRCT_GRP

Line 2105: l_lpn_in_sync_comm_rec WSH_GLBL_VAR_STRCT_GRP.lpn_sync_comm_in_rec_type;

2101: l_warn_num NUMBER := 0;
2102:
2103: -- LPN CONV. rv
2104: l_error_num NUMBER := 0;
2105: l_lpn_in_sync_comm_rec WSH_GLBL_VAR_STRCT_GRP.lpn_sync_comm_in_rec_type;
2106: l_lpn_out_sync_comm_rec WSH_GLBL_VAR_STRCT_GRP.lpn_sync_comm_out_rec_type;
2107: -- LPN CONV. rv
2108:
2109: l_lock_handle VARCHAR2(100);

Line 2106: l_lpn_out_sync_comm_rec WSH_GLBL_VAR_STRCT_GRP.lpn_sync_comm_out_rec_type;

2102:
2103: -- LPN CONV. rv
2104: l_error_num NUMBER := 0;
2105: l_lpn_in_sync_comm_rec WSH_GLBL_VAR_STRCT_GRP.lpn_sync_comm_in_rec_type;
2106: l_lpn_out_sync_comm_rec WSH_GLBL_VAR_STRCT_GRP.lpn_sync_comm_out_rec_type;
2107: -- LPN CONV. rv
2108:
2109: l_lock_handle VARCHAR2(100);
2110: l_lock_status NUMBER;

Line 3475: l_sync_tmp_wms_recTbl wsh_glbl_var_strct_grp.sync_tmp_recTbl_type;

3471:
3472:
3473: -- LPN CONV. rv
3474: l_wms_org VARCHAR2(10) := 'N';
3475: l_sync_tmp_wms_recTbl wsh_glbl_var_strct_grp.sync_tmp_recTbl_type;
3476: l_sync_tmp_inv_recTbl wsh_glbl_var_strct_grp.sync_tmp_recTbl_type;
3477:
3478: l_cnt_wms_counter NUMBER;
3479: l_cnt_inv_counter NUMBER;

Line 3476: l_sync_tmp_inv_recTbl wsh_glbl_var_strct_grp.sync_tmp_recTbl_type;

3472:
3473: -- LPN CONV. rv
3474: l_wms_org VARCHAR2(10) := 'N';
3475: l_sync_tmp_wms_recTbl wsh_glbl_var_strct_grp.sync_tmp_recTbl_type;
3476: l_sync_tmp_inv_recTbl wsh_glbl_var_strct_grp.sync_tmp_recTbl_type;
3477:
3478: l_cnt_wms_counter NUMBER;
3479: l_cnt_inv_counter NUMBER;
3480: l_delivery_id NUMBER;

Line 3493: l_lpn_in_sync_comm_rec WSH_GLBL_VAR_STRCT_GRP.lpn_sync_comm_in_rec_type;

3489: l_del_det_id_tbl wsh_util_core.id_tab_type;
3490: l_organization_id_tbl wsh_util_core.id_tab_type;
3491: l_line_direction_tbl wsh_util_core.column_tab_type;
3492:
3493: l_lpn_in_sync_comm_rec WSH_GLBL_VAR_STRCT_GRP.lpn_sync_comm_in_rec_type;
3494: l_lpn_out_sync_comm_rec WSH_GLBL_VAR_STRCT_GRP.lpn_sync_comm_out_rec_type;
3495: l_operation_type VARCHAR2(100);
3496:
3497: CURSOR l_detail_assgn_info_csr (p_detail_id IN NUMBER) is

Line 3494: l_lpn_out_sync_comm_rec WSH_GLBL_VAR_STRCT_GRP.lpn_sync_comm_out_rec_type;

3490: l_organization_id_tbl wsh_util_core.id_tab_type;
3491: l_line_direction_tbl wsh_util_core.column_tab_type;
3492:
3493: l_lpn_in_sync_comm_rec WSH_GLBL_VAR_STRCT_GRP.lpn_sync_comm_in_rec_type;
3494: l_lpn_out_sync_comm_rec WSH_GLBL_VAR_STRCT_GRP.lpn_sync_comm_out_rec_type;
3495: l_operation_type VARCHAR2(100);
3496:
3497: CURSOR l_detail_assgn_info_csr (p_detail_id IN NUMBER) is
3498: SELECT delivery_id,