DBA Data[Home] [Help]

APPS.WSH_ASN_RECEIPT_PVT dependencies on OE_WSH_BULK_GRP

Line 1453: -- p_line_rec IN OUT NOCOPY OE_WSH_BULK_GRP.line_rec_type

1449: --
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

Line 1459: -- x_po_cancel_rec OUT NOCOPY OE_WSH_BULK_GRP.line_rec_type

1455: --IN:
1456: -- p_shipment_header_id IN NUMBER,
1457: -- p_max_txn_id IN NUMBER
1458: -- OUT:
1459: -- x_po_cancel_rec OUT NOCOPY OE_WSH_BULK_GRP.line_rec_type
1460: -- x_po_close_rec OUT NOCOPY OE_WSH_BULK_GRP.line_rec_type
1461: -- x_return_status OUT NOCOPY VARCHAR2
1462: -- Cache Tables :
1463: -- ----------------------------------------------------------------------

Line 1460: -- x_po_close_rec OUT NOCOPY OE_WSH_BULK_GRP.line_rec_type

1456: -- p_shipment_header_id IN NUMBER,
1457: -- p_max_txn_id IN NUMBER
1458: -- OUT:
1459: -- x_po_cancel_rec OUT NOCOPY OE_WSH_BULK_GRP.line_rec_type
1460: -- x_po_close_rec OUT NOCOPY OE_WSH_BULK_GRP.line_rec_type
1461: -- x_return_status OUT NOCOPY VARCHAR2
1462: -- Cache Tables :
1463: -- ----------------------------------------------------------------------
1464: -- | Cache Table Name | Key | Value |

Line 1491: p_line_rec IN OUT NOCOPY OE_WSH_BULK_GRP.line_rec_type,

1487: -- End of comments
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,

Line 1495: x_po_cancel_rec OUT NOCOPY OE_WSH_BULK_GRP.line_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,
1497: x_return_status OUT NOCOPY VARCHAR2)
1498:
1499: IS

Line 1496: x_po_close_rec 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,
1497: x_return_status OUT NOCOPY VARCHAR2)
1498:
1499: IS
1500:

Line 3793: l_line_rec OE_WSH_BULK_GRP.line_rec_type;

3789: FROM
3790: Wsh_new_deliveries
3791: WHERE ASN_SHIPMENT_HEADER_ID = p_header_id;
3792:
3793: l_line_rec OE_WSH_BULK_GRP.line_rec_type;
3794: l_max_txn_id NUMBER;
3795: l_dd_list WSH_PO_CMG_PVT.dd_list_type;
3796: l_Stop_ids wsh_util_core.Id_Tab_Type;
3797: l_Trip_ids wsh_util_core.Id_Tab_Type;

Line 6968: -- p_line_rec IN OE_WSH_BULK_GRP.line_rec_type

6964: -- Parameters:
6965: -- IN:
6966: -- p_index IN NUMBER
6967: -- The position of the record of p_dd_rec upon which this API has been called.
6968: -- p_line_rec IN OE_WSH_BULK_GRP.line_rec_type
6969: -- A table of records which contains all information got from the PO side.
6970: -- It contains a record for each delivery detail line.
6971: -- p_gross_weight IN NUMBER DEFAULT NULL
6972: -- p_net_weight IN NUMBER DEFAULT NULL

Line 7002: p_line_rec IN OE_WSH_BULK_GRP.line_rec_type,

6998:
6999: Procedure populate_update_dd_rec(
7000: p_dd_rec IN OUT NOCOPY WSH_IB_UI_RECON_GRP.asn_rcv_del_det_rec_type,
7001: p_index IN NUMBER,
7002: p_line_rec IN OE_WSH_BULK_GRP.line_rec_type,
7003: p_gross_weight IN NUMBER DEFAULT NULL,
7004: p_net_weight IN NUMBER DEFAULT NULL,
7005: p_volume IN NUMBER DEFAULT NULL,
7006: x_release_status IN VARCHAR2,

Line 8093: -- p_po_cancel_rec IN OE_WSH_BULK_GRP.line_rec_type

8089: -- have to be closed when the txns have been matched.This job is taken care
8090: -- of this API.
8091: -- Parameters:
8092: -- IN:
8093: -- p_po_cancel_rec IN OE_WSH_BULK_GRP.line_rec_type
8094: -- contains details of the lines which are to be cancelled.These details
8095: -- include shipment_line_id, header_id,delivery_detail_id etc.
8096: -- p_po_close_rec IN OE_WSH_BULK_GRP.line_rec_type
8097: -- contains details of the lines which are to be closed..These details

Line 8096: -- p_po_close_rec IN OE_WSH_BULK_GRP.line_rec_type

8092: -- IN:
8093: -- p_po_cancel_rec IN OE_WSH_BULK_GRP.line_rec_type
8094: -- contains details of the lines which are to be cancelled.These details
8095: -- include shipment_line_id, header_id,delivery_detail_id etc.
8096: -- p_po_close_rec IN OE_WSH_BULK_GRP.line_rec_type
8097: -- contains details of the lines which are to be closed..These details
8098: -- include shipment_line_id, header_id,delivery_detail_id etc.
8099: -- IN OUT:
8100: -- OUT:

Line 8108: p_po_cancel_rec IN OE_WSH_BULK_GRP.line_rec_type,

8104: -- End of comments
8105:
8106:
8107: PROCEDURE cancel_close_pending_txns(
8108: p_po_cancel_rec IN OE_WSH_BULK_GRP.line_rec_type,
8109: p_po_close_rec IN OE_WSH_BULK_GRP.line_rec_type,
8110: x_return_status OUT NOCOPY VARCHAR2)
8111:
8112: IS

Line 8109: p_po_close_rec IN OE_WSH_BULK_GRP.line_rec_type,

8105:
8106:
8107: PROCEDURE cancel_close_pending_txns(
8108: p_po_cancel_rec IN OE_WSH_BULK_GRP.line_rec_type,
8109: p_po_close_rec IN OE_WSH_BULK_GRP.line_rec_type,
8110: x_return_status OUT NOCOPY VARCHAR2)
8111:
8112: IS
8113: