PACKAGE: APPS.GML_RCV_TXN_INTERFACE

Source

1 PACKAGE GML_RCV_TXN_INTERFACE AS
2 /* $Header: GMLTISVS.pls 120.1 2005/06/03 13:18:10 appldev  $*/
3 
4 
5 TYPE cascaded_trans_rec_type IS RECORD
6   (
7    customer_id NUMBER,
8    error_message VARCHAR2(255),
9    error_status VARCHAR2(1),
10    expected_receipt_date DATE,
11    from_organization_id NUMBER,
12    group_id NUMBER,
13    item_id NUMBER,
14    locator_id NUMBER,
15    oe_order_header_id NUMBER,
16    oe_order_line_id NUMBER,
17    parent_transaction_id NUMBER,
18    po_distribution_id NUMBER,
19    po_header_id NUMBER,
20    po_line_id NUMBER,
21    po_line_location_id NUMBER,
22    po_release_id NUMBER,
23    primary_quantity NUMBER,
24    primary_unit_of_measure VARCHAR2(25),
25    qty_rcv_exception_code VARCHAR2(25),
26    quantity NUMBER,
27    quantity_shipped NUMBER,
28    revision VARCHAR2(3),
29    ship_to_location_id NUMBER,
30    shipment_header_id NUMBER,
31    shipment_line_id NUMBER,
32    source_doc_quantity NUMBER,
33    source_doc_unit_of_measure VARCHAR2(25),
34    subinventory VARCHAR2(10),
35    tax_amount NUMBER,
36    to_organization_id NUMBER,
37    transaction_type VARCHAR2(25),
38    unit_of_measure VARCHAR2(25),
39    inspection_status_code VARCHAR2(25),
40    p_lpn_id NUMBER,
41    item_desc VARCHAR2(240),
42    project_id number default null,
43    task_id   number  default null,
44    lot_number mtl_lot_numbers.lot_number%TYPE DEFAULT NULL,
45    secondary_quantity rcv_transactions_interface.SECONDARY_QUANTITY%TYPE,
46    secondary_unit_of_measure rcv_transactions_interface.SECONDARY_UNIT_OF_MEASURE%TYPE
47    );
48 
49 TYPE cascaded_trans_tab_type IS TABLE OF cascaded_trans_rec_type
50   INDEX BY BINARY_INTEGER;
51 
52 PROCEDURE matching_logic
53   (x_return_status                   OUT nocopy VARCHAR2,
54    x_msg_count                       OUT nocopy NUMBER,
55    x_msg_data                        OUT nocopy VARCHAR2,
56    x_cascaded_table               IN OUT nocopy cascaded_trans_tab_type,
57    n                              IN OUT nocopy  binary_integer,
58    temp_cascaded_table            IN OUT nocopy cascaded_trans_tab_type,
59    p_receipt_num                     IN   VARCHAR2,
60    p_shipment_header_id              IN   NUMBER,  -- this parameter is for ASN only, should leave it NULL for PO receipt
61    p_lpn_id                          IN   NUMBER -- this parameter is for ASN only, should leave it NULL for PO receipt
62    );
63 
64 END GML_RCV_TXN_INTERFACE;