1 PACKAGE AP_AUTO_DM_CREATION_PKG AS
2 /* $Header: apcrtdms.pls 120.1 2003/06/13 19:41:49 isartawi noship $ */
3
4
5 /*-------------------------------------------------------------------------
6 p_rcv_txn_id : The transaction_id for which the RTS is issues (should always
7 be the id of the RECEIVE transaction)
8 p_rts_txn_id : The transaction id of the RTS itself.(i.e. the RETURN
9 transaction)
10 p_po_dist_id : If the Return is done against a delivery and the
11 po_distribution_id is known. If this is null, the quantity
12 will be prorated across the po distributions.
13 p_quantity : The quantity returned. Please note that the quantity should be
14 in the same UOM as the Receive Transaction, because we are
15 matching against that transaction. The quantity should be
16 negative.
17 p_qty_uom : The UOM the quantity is in.
18 p_unit_price : The price at which the goods are returned. This price will be
19 the same as the PO price but should be passed in terms of
20 x_qty_uom. The quantity and unit_price are used to get the
21 amount and these 2 should correspondto the same UOM. The unit
22 price should be positive.
23 p_user_id : AOL User Id from the Form
24 p_login_id : AOL Login Id from the form
25 p_calling_seq: The name of the module calling this function. Used for exception
26 handling
27
28 This procedure returns a Boolean value of TRUE when it completes sucessfully
29 and will return a value of FALSE when either a known exception or an unhandled
30 exception occurs. The Oracle error is stored on the message stack when an
31 unhandled exception occures. a meaningful error is stored when a known
32 exception occurs.
33 --------------------------------------------------------------------------*/
34
35 Function Create_DM (
36 p_rcv_txn_id IN NUMBER,
37 p_rts_txn_id IN NUMBER,
38 p_po_dist_id IN NUMBER,
39 p_quantity IN NUMBER,
40 p_qty_uom IN VARCHAR2,
41 p_unit_price IN NUMBER,
42 p_user_id IN NUMBER,
43 p_login_id IN NUMBER,
44 p_calling_sequence IN VARCHAR2)
45 RETURN BOOLEAN;
46
47 END AP_AUTO_DM_CREATION_PKG;
48