1: PACKAGE RCV_TRANSACTIONS_INTERFACE_SV1 AS
2: /* $Header: RCVTIS2S.pls 120.0 2005/06/02 00:14:55 appldev noship $*/
3:
4:
5: /* INVCONV, Punit Kumar, ROI convergence */
13: g_exc_unexpected_error EXCEPTION;
14:
15: /*INVCONV , Introduced the following record type*/
16: TYPE attributes_record_type IS RECORD (
17: inventory_item_id RCV_TRANSACTIONS_INTERFACE.item_id%Type,
18: transaction_quantity RCV_TRANSACTIONS_INTERFACE.quantity%Type,
19: transaction_unit_of_measure RCV_TRANSACTIONS_INTERFACE.unit_of_measure%Type,
20: secondary_quantity RCV_TRANSACTIONS_INTERFACE.Secondary_quantity%Type,
21: secondary_unit_of_measure RCV_TRANSACTIONS_INTERFACE.Secondary_UNIT_OF_MEASURE%Type,
14:
15: /*INVCONV , Introduced the following record type*/
16: TYPE attributes_record_type IS RECORD (
17: inventory_item_id RCV_TRANSACTIONS_INTERFACE.item_id%Type,
18: transaction_quantity RCV_TRANSACTIONS_INTERFACE.quantity%Type,
19: transaction_unit_of_measure RCV_TRANSACTIONS_INTERFACE.unit_of_measure%Type,
20: secondary_quantity RCV_TRANSACTIONS_INTERFACE.Secondary_quantity%Type,
21: secondary_unit_of_measure RCV_TRANSACTIONS_INTERFACE.Secondary_UNIT_OF_MEASURE%Type,
22: secondary_uom_code RCV_TRANSACTIONS_INTERFACE.secondary_uom_code%TYPE,
15: /*INVCONV , Introduced the following record type*/
16: TYPE attributes_record_type IS RECORD (
17: inventory_item_id RCV_TRANSACTIONS_INTERFACE.item_id%Type,
18: transaction_quantity RCV_TRANSACTIONS_INTERFACE.quantity%Type,
19: transaction_unit_of_measure RCV_TRANSACTIONS_INTERFACE.unit_of_measure%Type,
20: secondary_quantity RCV_TRANSACTIONS_INTERFACE.Secondary_quantity%Type,
21: secondary_unit_of_measure RCV_TRANSACTIONS_INTERFACE.Secondary_UNIT_OF_MEASURE%Type,
22: secondary_uom_code RCV_TRANSACTIONS_INTERFACE.secondary_uom_code%TYPE,
23: to_organization_id RCV_TRANSACTIONS_INTERFACE.to_organization_id%Type,
16: TYPE attributes_record_type IS RECORD (
17: inventory_item_id RCV_TRANSACTIONS_INTERFACE.item_id%Type,
18: transaction_quantity RCV_TRANSACTIONS_INTERFACE.quantity%Type,
19: transaction_unit_of_measure RCV_TRANSACTIONS_INTERFACE.unit_of_measure%Type,
20: secondary_quantity RCV_TRANSACTIONS_INTERFACE.Secondary_quantity%Type,
21: secondary_unit_of_measure RCV_TRANSACTIONS_INTERFACE.Secondary_UNIT_OF_MEASURE%Type,
22: secondary_uom_code RCV_TRANSACTIONS_INTERFACE.secondary_uom_code%TYPE,
23: to_organization_id RCV_TRANSACTIONS_INTERFACE.to_organization_id%Type,
24: error_record RCV_SHIPMENT_OBJECT_SV.ErrorRecType) ;
17: inventory_item_id RCV_TRANSACTIONS_INTERFACE.item_id%Type,
18: transaction_quantity RCV_TRANSACTIONS_INTERFACE.quantity%Type,
19: transaction_unit_of_measure RCV_TRANSACTIONS_INTERFACE.unit_of_measure%Type,
20: secondary_quantity RCV_TRANSACTIONS_INTERFACE.Secondary_quantity%Type,
21: secondary_unit_of_measure RCV_TRANSACTIONS_INTERFACE.Secondary_UNIT_OF_MEASURE%Type,
22: secondary_uom_code RCV_TRANSACTIONS_INTERFACE.secondary_uom_code%TYPE,
23: to_organization_id RCV_TRANSACTIONS_INTERFACE.to_organization_id%Type,
24: error_record RCV_SHIPMENT_OBJECT_SV.ErrorRecType) ;
25:
18: transaction_quantity RCV_TRANSACTIONS_INTERFACE.quantity%Type,
19: transaction_unit_of_measure RCV_TRANSACTIONS_INTERFACE.unit_of_measure%Type,
20: secondary_quantity RCV_TRANSACTIONS_INTERFACE.Secondary_quantity%Type,
21: secondary_unit_of_measure RCV_TRANSACTIONS_INTERFACE.Secondary_UNIT_OF_MEASURE%Type,
22: secondary_uom_code RCV_TRANSACTIONS_INTERFACE.secondary_uom_code%TYPE,
23: to_organization_id RCV_TRANSACTIONS_INTERFACE.to_organization_id%Type,
24: error_record RCV_SHIPMENT_OBJECT_SV.ErrorRecType) ;
25:
26:
19: transaction_unit_of_measure RCV_TRANSACTIONS_INTERFACE.unit_of_measure%Type,
20: secondary_quantity RCV_TRANSACTIONS_INTERFACE.Secondary_quantity%Type,
21: secondary_unit_of_measure RCV_TRANSACTIONS_INTERFACE.Secondary_UNIT_OF_MEASURE%Type,
22: secondary_uom_code RCV_TRANSACTIONS_INTERFACE.secondary_uom_code%TYPE,
23: to_organization_id RCV_TRANSACTIONS_INTERFACE.to_organization_id%Type,
24: error_record RCV_SHIPMENT_OBJECT_SV.ErrorRecType) ;
25:
26:
27: /*===========================================================================
111: ===========================================================================*/
112:
113: PROCEDURE validate_item
114: (x_item_id_record IN OUT NOCOPY rcv_shipment_line_sv.item_id_record_type,
115: x_auto_transact_code IN rcv_transactions_interface.auto_transact_code%type);
116: /*===========================================================================
117: PROCEDURE NAME: validate_item_description()
118:
119: DESCRIPTION:
519:
520: Procedure VALIDATE_SECONDARY_PARAMETERS(
521: p_api_version IN NUMBER,
522: p_init_msg_lst IN VARCHAR2,
523: x_att_rec IN OUT NOCOPY RCV_TRANSACTIONS_INTERFACE_SV1.attributes_record_type,
524: x_return_status OUT NOCOPY VARCHAR2,
525: x_msg_count OUT NOCOPY NUMBER,
526: x_msg_data OUT NOCOPY VARCHAR2);
527: /*END INVCONV*/
525: x_msg_count OUT NOCOPY NUMBER,
526: x_msg_data OUT NOCOPY VARCHAR2);
527: /*END INVCONV*/
528:
529: END RCV_TRANSACTIONS_INTERFACE_SV1;
530: