DBA Data[Home] [Help]

APPS.WSH_ASN_RECEIPT_PVT dependencies on WSH_GLBL_VAR_STRCT_GRP

Line 1454: -- p_action_prms IN OUT NOCOPY WSH_GLBL_VAR_STRCT_GRP.dd_action_parameters_rec_type

1450: -- Parameters :
1451: -- IN OUT:
1452: -- p_dd_rec IN OUT NOCOPY WSH_IB_UI_RECON_GRP.asn_rcv_del_det_rec_type
1453: -- p_line_rec IN OUT NOCOPY OE_WSH_BULK_GRP.line_rec_type
1454: -- p_action_prms IN OUT NOCOPY WSH_GLBL_VAR_STRCT_GRP.dd_action_parameters_rec_type
1455: --IN:
1456: -- p_shipment_header_id IN NUMBER,
1457: -- p_max_txn_id IN NUMBER
1458: -- OUT:

Line 1492: p_action_prms IN OUT NOCOPY WSH_GLBL_VAR_STRCT_GRP.dd_action_parameters_rec_type,

1488:
1489: PROCEDURE Process_Matched_Txns(
1490: p_dd_rec IN OUT NOCOPY WSH_IB_UI_RECON_GRP.asn_rcv_del_det_rec_type,
1491: p_line_rec IN OUT NOCOPY OE_WSH_BULK_GRP.line_rec_type,
1492: p_action_prms IN OUT NOCOPY WSH_GLBL_VAR_STRCT_GRP.dd_action_parameters_rec_type,
1493: p_shipment_header_id IN NUMBER,
1494: p_max_txn_id IN NUMBER,
1495: x_po_cancel_rec OUT NOCOPY OE_WSH_BULK_GRP.line_rec_type,
1496: x_po_close_rec OUT NOCOPY OE_WSH_BULK_GRP.line_rec_type,

Line 1590: p_dd_info WSH_GLBL_VAR_STRCT_GRP.Delivery_Details_Rec_Type;

1586:
1587:
1588: temp_lpn NUMBER;
1589:
1590: p_dd_info WSH_GLBL_VAR_STRCT_GRP.Delivery_Details_Rec_Type;
1591: p_dd_assign_info WSH_DELIVERY_DETAILS_PKG.Delivery_Assignments_Rec_type;
1592:
1593: p_dd_list WSH_PO_CMG_PVT.dd_list_type;
1594: l_local_dd_rec LOCAL_DD_REC_TABLE_TYPE;

Line 3732: -- p_action_prms IN OUT NOCOPY WSH_GLBL_VAR_STRCT_GRP.dd_action_parameters_rec_type

3728: -- the container from the delivery.
3729: -- Get the list of deliveries, trips and trip stops for updating the status on the entities
3730: -- Parameters :
3731: -- IN OUT:
3732: -- p_action_prms IN OUT NOCOPY WSH_GLBL_VAR_STRCT_GRP.dd_action_parameters_rec_type
3733: --IN:
3734: -- p_header_id IN NUMBER,
3735: -- OUT:
3736: -- x_return_status OUT NOCOPY VARCHAR2

Line 3766: p_action_prms IN OUT NOCOPY WSH_GLBL_VAR_STRCT_GRP.dd_action_parameters_rec_type,

3762: -- End of comments
3763:
3764: PROCEDURE Cancel_ASN(
3765: p_header_id IN NUMBER,
3766: p_action_prms IN OUT NOCOPY WSH_GLBL_VAR_STRCT_GRP.dd_action_parameters_rec_type,
3767: x_return_status OUT NOCOPY VARCHAR2) IS
3768:
3769: /*Cursor c_get_dds(p_header_id NUMBER) IS
3770: SELECT

Line 3826: l_unassign_action_prms WSH_GLBL_VAR_STRCT_GRP.dd_action_parameters_rec_type;

3822: l_status VARCHAR2(50);
3823: l_txn_type VARCHAR2(50);
3824: l_local_ddrec LOCAL_DD_REC_TABLE_TYPE;
3825:
3826: l_unassign_action_prms WSH_GLBL_VAR_STRCT_GRP.dd_action_parameters_rec_type;
3827: --
3828: l_lpnGWTcachetbl WSH_UTIL_CORE.key_value_tab_type;
3829: l_lpnGWTcacheExttbl WSH_UTIL_CORE.key_value_tab_type;
3830: l_lpnNWTcachetbl WSH_UTIL_CORE.key_value_tab_type;

Line 4240: -- p_action_prms IN WSH_GLBL_VAR_STRCT_GRP.dd_action_parameters_rec_type

4236: -- IN:
4237: -- p_del_ids IN wsh_util_core.id_tab_type
4238: -- A table containing the list of delivery IDs for which the action
4239: -- should be carried out.
4240: -- p_action_prms IN WSH_GLBL_VAR_STRCT_GRP.dd_action_parameters_rec_type
4241: -- contains the action code ,the caller ,the transaction type etc.
4242: -- IN OUT:
4243: -- OUT:
4244: -- x_return_status OUT NOCOPY VARCHAR2

Line 4252: p_action_prms IN WSH_GLBL_VAR_STRCT_GRP.dd_action_parameters_rec_type,

4248: -- End of comments
4249:
4250: PROCEDURE unassign_open_det_from_del(
4251: p_del_ids IN wsh_util_core.id_tab_type,
4252: p_action_prms IN WSH_GLBL_VAR_STRCT_GRP.dd_action_parameters_rec_type,
4253: p_shipment_header_id IN NUMBER,
4254: x_return_status OUT NOCOPY VARCHAR2 ) IS
4255:
4256: --Cursor to get the open lines for a Delivery ID.

Line 4318: l_unassign_action_prms WSH_GLBL_VAR_STRCT_GRP.dd_action_parameters_rec_type;

4314: i NUMBER;
4315: l_index NUMBER;
4316:
4317:
4318: l_unassign_action_prms WSH_GLBL_VAR_STRCT_GRP.dd_action_parameters_rec_type;
4319: --
4320: l_debug_on BOOLEAN;
4321: --
4322: l_module_name CONSTANT VARCHAR2(100) := 'wsh.plsql.' || G_PKG_NAME || '.' || 'UNASSIGN_OPEN_DET_FROM_DEL';

Line 4629: -- p_action_prms IN OUT NOCOPY WSH_GLBL_VAR_STRCT_GRP.dd_action_parameters_rec_type

4625: -- This is a pl/sql table which contains the unique deliveries passed to this API.
4626: -- this table is also updated in this API once the deliveries are created for the
4627: -- delivery detail ids present in the cache tables p_index_dd_ids_cache and
4628: -- p_index_dd_ids_ext_cache.This table is not contiguous.
4629: -- p_action_prms IN OUT NOCOPY WSH_GLBL_VAR_STRCT_GRP.dd_action_parameters_rec_type
4630: -- This contains the caller, type of action to be performed.
4631: -- p_shipment_header_id IN NUMBER
4632: -- RCV Shipment header id
4633: -- OUT:

Line 4666: p_action_prms IN OUT NOCOPY WSH_GLBL_VAR_STRCT_GRP.dd_action_parameters_rec_type,

4662: p_index_del_ids_ext_cache IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type,
4663: p_del_ids_del_ids_cache IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type,
4664: p_del_ids_del_ids_ext_cache IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type,
4665: p_uniq_del_ids_tab IN OUT NOCOPY WSH_UTIL_CORE.ID_TAB_TYPE,
4666: p_action_prms IN OUT NOCOPY WSH_GLBL_VAR_STRCT_GRP.dd_action_parameters_rec_type,
4667: p_shipment_header_id IN NUMBER,
4668: x_return_status OUT NOCOPY VARCHAR2 ) IS
4669:
4670:

Line 5121: -- p_action_prms IN OUT NOCOPY WSH_GLBL_VAR_STRCT_GRP.dd_action_parameters_rec_type

5117: -- IN OUT:
5118: -- p_local_dd_rec IN OUT NOCOPY LOCAL_DD_REC_TABLE_TYPE,
5119: -- The structure which contains necessary information of the changed attributes
5120: -- of the lines.
5121: -- p_action_prms IN OUT NOCOPY WSH_GLBL_VAR_STRCT_GRP.dd_action_parameters_rec_type
5122: --- A record which contains the action code, transaction type etc..
5123: -- x_lpnGWTcachetbl IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type
5124: -- A key-value cache (mapping table) which has the key as LPN id and value as
5125: -- Gross weight for the corresponding LPN. The key ranges from 1 to (2^31 -1)

Line 5192: p_action_prms IN OUT NOCOPY WSH_GLBL_VAR_STRCT_GRP.dd_action_parameters_rec_type,

5188:
5189:
5190: PROCEDURE reconfigure_del_trips(
5191: p_local_dd_rec IN OUT NOCOPY LOCAL_DD_REC_TABLE_TYPE,
5192: p_action_prms IN OUT NOCOPY WSH_GLBL_VAR_STRCT_GRP.dd_action_parameters_rec_type,
5193: x_lpnGWTcachetbl IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type,
5194: x_lpnGWTcacheExttbl IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type,
5195: x_lpnNWTcachetbl IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type,
5196: x_lpnNWTcacheExttbl IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type,

Line 6138: -- p_action_prms IN WSH_GLBL_VAR_STRCT_GRP.dd_action_parameters_rec_type,

6134: -- shipping tables.
6135: -- Parameters :
6136: -- IN: p_del_id IN NUMBER,
6137: -- p_bol IN VARCHAR2,
6138: -- p_action_prms IN WSH_GLBL_VAR_STRCT_GRP.dd_action_parameters_rec_type,
6139: -- IN OUT:
6140: --
6141: -- OUT: x_return_status OUT NOCOPY VARCHAR2
6142: -- Version : 1.0

Line 6151: p_action_prms IN WSH_GLBL_VAR_STRCT_GRP.dd_action_parameters_rec_type,

6147:
6148: PROCEDURE synch_bols(
6149: p_del_id IN NUMBER,
6150: p_bol IN VARCHAR2,
6151: p_action_prms IN WSH_GLBL_VAR_STRCT_GRP.dd_action_parameters_rec_type,
6152: x_return_status OUT NOCOPY VARCHAR2) IS
6153:
6154: --Cursor to get the BOL and delivery Leg ID of a Delivery ID.
6155: Cursor c_BOL(p_del_id NUMBER ) is

Line 6341: p_action_prms IN OUT NOCOPY WSH_GLBL_VAR_STRCT_GRP.dd_action_parameters_rec_type,

6337:
6338:
6339:
6340: PROCEDURE update_status (
6341: p_action_prms IN OUT NOCOPY WSH_GLBL_VAR_STRCT_GRP.dd_action_parameters_rec_type,
6342: p_del_ids IN wsh_util_core.id_tab_type,
6343: p_trip_ids IN wsh_util_core.id_tab_type,
6344: p_stop_ids IN wsh_util_core.id_tab_type,
6345: p_shipment_header_id_tab IN wsh_util_core.id_tab_type,

Line 7359: -- p_action_prms IN OUT NOCOPY WSH_GLBL_VAR_STRCT_GRP.dd_action_parameters_rec_type

7355: -- temp_dels IN OUT NOCOPY WSH_UTIL_CORE.id_tab_type
7356: -- Contains non-duplicate delivery IDs belonging to the record structure p_local_dd_rec
7357: -- This is a dynamic container and goes on adding until all the records of the structure
7358: -- are scanned.
7359: -- p_action_prms IN OUT NOCOPY WSH_GLBL_VAR_STRCT_GRP.dd_action_parameters_rec_type
7360: -- The Record which specifies the Caller,Action to Be performed and the transaction type etc.
7361: -- OUT:
7362: -- x_return_status OUT NOCOPY VARCHAR2
7363: -- Version : 1.0

Line 7384: p_action_prms IN OUT NOCOPY WSH_GLBL_VAR_STRCT_GRP.dd_action_parameters_rec_type,

7380: l_psno_flag IN OUT NOCOPY NUMBER,
7381: l_trigger IN OUT NOCOPY NUMBER,
7382: l_waybill_flag IN OUT NOCOPY NUMBER,
7383: temp_dels IN OUT NOCOPY WSH_UTIL_CORE.id_tab_type,
7384: p_action_prms IN OUT NOCOPY WSH_GLBL_VAR_STRCT_GRP.dd_action_parameters_rec_type,
7385: x_return_status OUT NOCOPY VARCHAR2
7386: )
7387: IS
7388: