PACKAGE: APPS.INV_CR_ASN_DETAILS

Source

1 PACKAGE INV_CR_ASN_DETAILS AS
2 /* $Header: INVCRDIS.pls 120.3 2005/10/10 12:56:04 methomas noship $*/
3 
4 /*******************************************************
5 *  Name: create_asn_details
6 *
7 *  Description:
8 *
9 *
10 *  Parameters:
11 *
12 *
13 *******************************************************/
14 
15 TYPE asn_details_rec_tp IS RECORD
16 (
17 GROUP_ID                      number,
18 SHIPMENT_NUM                  varchar2(30),
19 ORGANIZATION_ID               number,
20 DISCREPANCY_REPORTING_CONTEXT varchar2(25),
21 ITEM_ID                       number,
22 QUANTITY_EXPECTED             number,
23 QUANTITY_ACTUAL               number,
24 UNIT_OF_MEASURE_EXPECTED      varchar2(25),
25 UNIT_OF_MEASURE_ACTUAL        varchar2(25),
26 LPN_EXPECTED                  varchar2(30),
27 LPN_ACTUAL                    varchar2(30),
28 ITEM_REVISION_EXPECTED        varchar2(3),
29 ITEM_REVISION_ACTUAL          varchar2(3),
30 -- Increased lot size to 80 Char - Mercy Thomas - B4625329
31 LOT_NUMBER_EXPECTED           varchar2(80),
32 -- Increased lot size to 80 Char - Mercy Thomas - B4625329
33 LOT_NUMBER_ACTUAL             varchar2(80),
34 SERIAL_NUMBER_EXPECTED        varchar2(30),
35 SERIAL_NUMBER_ACTUAL          varchar2(30),
36 VENDOR_ID                     number,
37 VENDOR_SITE_ID                number,
38 TRANSACTION_DATE              date
39 );
40 
41 TYPE rcv_intf_rec_tp IS RECORD
42 (
43 	 group_id                 number ,
44 	 to_organization_id       number,
45 	 item_id                  number,
46 	 item_revision            varchar2(3),
47 	 shipment_header_id       number,
48 	 po_line_id               number,
49 	 quantity                 number,
50 	 unit_of_measure          varchar2(25),
51 	 uom_code                 varchar2(3),
52 	 header_interface_id      number
53 );
54 
55 
56 
57 PROCEDURE create_asn_details_from_intf(
58     p_interface_transaction_rec IN OUT nocopy rcv_intf_rec_tp ,
59     x_status                  OUT nocopy VARCHAR2,
60     x_message                 OUT nocopy VARCHAR2
61 			    );
62 
63 PROCEDURE create_asn_details(
64     p_organization_id      IN     NUMBER,
65     p_group_id             IN     NUMBER,
66     p_rcv_rcpt_rec         IN OUT nocopy  inv_rcv_std_rcpt_apis.rcv_enter_receipts_rec_tp,
67     p_rcv_transaction_rec  IN OUT nocopy  inv_rcv_std_rcpt_apis.rcv_transaction_rec_tp,
68     p_rcpt_lot_qty_rec_tb  IN OUT nocopy  inv_rcv_std_rcpt_apis.rcpt_lot_qty_rec_tb_tp,
69     p_interface_transaction_id IN number,
70     x_status                  OUT nocopy VARCHAR2,
71     x_message                 OUT nocopy VARCHAR2
72 			    );
73 
74 /* Bug 4551595-Added the procedure to update wms_asn_details
75                for item to be called from INV_RCV_STD_RCPT_APIS
76 	       at the header level for all the records of rti
77 	       for a group id */
78 
79 PROCEDURE update_asn_item_details
80 (p_group_id IN NUMBER);
81 
82 /* End of fix for Bug 4551595 */
83 
84 END inv_cr_asn_details;