1 PACKAGE RCV_ACCRUAL_SV AUTHID CURRENT_USER AS
2 /* $Header: RCVACCRS.pls 120.1 2005/09/21 02:47:35 bigoyal noship $*/
3
4
5 /* ======================================================================= *\
6 * PROCEDURE NAME: get_received_quantity() *
7 * *
8 * DESCRIPTION: *
9 * This function will accept a RECEIVE or MATCH transaction id and *
10 * return the quantity received in the PO's unit of measure. This is *
11 * mainly a function wrapper that calls the get_quantities API. *
12 * *
13 * USAGE: *
14 * This function is called from the period end accruals concurrent *
15 * program when the match option is set to match to receipt. *
16 \* ======================================================================= */
17
18 FUNCTION get_received_quantity( p_transaction_id IN NUMBER,
19 p_accrual_cutoff_date IN DATE) RETURN NUMBER;
20
21 -- PRAGMA RESTRICT_REFERENCES(get_received_quantity, WNDS);
22
23 /* ======================================================================= *\
24 * PROCEDURE NAME: get_delivered_quantity() *
25 * *
26 * DESCRIPTION: *
27 * This function will accept a DELIVER transaction id and *
28 * return the quantity delivered in the PO's unit of measure. This is *
29 * mainly a function wrapper that calls the get_quantities API. *
30 * *
31 * USAGE: *
32 * This function is called from the accounting events API *
33 * while accounting for retroactive price changes. *
34 \* ======================================================================= */
35
36 FUNCTION get_delivered_quantity (p_transaction_id IN NUMBER,
37 p_accrual_cutoff_date IN DATE) RETURN NUMBER;
38
39
40
41 /* ======================================================================= *\
42 * PROCEDURE NAME: get_quantities() *
43 * *
44 * DESCRIPTION: *
45 * Given a transaction_id, this procedure will return the following *
46 * transaction quantities: *
47 * Ordered *
48 * Received *
49 * Corrected *
50 * Delivered *
51 * Returned To Vendor *
52 * Billed *
53 * Accepted *
54 * Rejected *
55 * The quantities are returned in both the PO and Transaction's unit *
56 * of measure. For period end accruals, we are only concerned with *
57 * the received transaction quantity in the PO's UOM. *
58 * This procedure contains the same logic as in the *
59 * RCV_INVOICE_MATCHING_SV package. However, we are using inventory's *
60 * UOM conversion routine here so that we do not violate the *
61 * associated WNDS pragma restriction associated with this procedure *
62 * *
63 * USAGE: *
64 * This function is called from the period end accruals concurrent *
65 * program when the match option is set to match to receipt. *
66 \* ======================================================================= */
67
68 PROCEDURE get_quantities ( top_transaction_id IN NUMBER,
69 ordered_po_qty IN OUT NOCOPY NUMBER,
70 received_po_qty IN OUT NOCOPY NUMBER,
71 corrected_po_qty IN OUT NOCOPY NUMBER,
72 delivered_po_qty IN OUT NOCOPY NUMBER,
73 rtv_po_qty IN OUT NOCOPY NUMBER,
74 billed_po_qty IN OUT NOCOPY NUMBER,
75 accepted_po_qty IN OUT NOCOPY NUMBER,
76 rejected_po_qty IN OUT NOCOPY NUMBER,
77 ordered_txn_qty IN OUT NOCOPY NUMBER,
78 received_txn_qty IN OUT NOCOPY NUMBER,
79 corrected_txn_qty IN OUT NOCOPY NUMBER,
80 delivered_txn_qty IN OUT NOCOPY NUMBER,
81 rtv_txn_qty IN OUT NOCOPY NUMBER,
82 billed_txn_qty IN OUT NOCOPY NUMBER,
83 accepted_txn_qty IN OUT NOCOPY NUMBER,
84 rejected_txn_qty IN OUT NOCOPY NUMBER,
85 p_accrual_cutoff_date IN DATE);
86
87 -- PRAGMA RESTRICT_REFERENCES(get_quantities, WNDS);
88
89 END RCV_ACCRUAL_SV;