1 PACKAGE RCV_BILL_UPDATING_SV AUTHID CURRENT_USER AS
2 /* $Header: RCVBLUPS.pls 115.2 2003/07/24 22:14:03 sumboh ship $*/
3
4 /*===========================================================================
5 PACKAGE NAME: RCV_BILL_UPDATING_SV
6
7 DESCRIPTION:
8
9 CLIENT/SERVER: Server
10
11 LIBRARY NAME
12
13 OWNER:
14
15 PROCEDURE NAMES: ap_update_po_distributions()
16 ap_update_po_line_locations()
17 ap_update_rcv_transactions()
18 ===========================================================================*/
19
20 /*===========================================================================
21 PROCEDURE NAME: ap_update_po_distributions()
22
23 DESCRIPTION:
24 This procedure will accept a quantity_billed and the UOM in which the
25 quantity is, and convert it to the UOM corresponding to PO_DISTRIBUTIONS
26 and then insert the value. Also all values need to be added to the
27 existing values in the respective columns.
28
29 USAGE:
30
31 PARAMETERS: X_po_distribution_id IN NUMBER
32 PO Distribution ID
33 X_quantity_billed IN NUMBER
34 Billed quantity, need to convert to PO UOM
35 X_uom_lookup_code IN VARCHAR2
36 UOM in which the quantity is
37 X_amount_billed IN NUMBER
38 Billed amount
39 -- X_base_amount_billed IN NUMBER
40 -- Base billed amount
41
42
43 DESIGN REFERENCES: Generic
44
45 ALGORITHM:
46
47 NOTES:
48
49 OPEN ISSUES:
50
51 CLOSED ISSUES:
52
53 CHANGE HISTORY:
54 25-Jan-99 James Zhang Created
55 ===========================================================================*/
56 PROCEDURE ap_update_po_distributions( X_po_distribution_id IN NUMBER,
57 X_quantity_billed IN NUMBER,
58 X_uom_lookup_code IN VARCHAR2,
59 X_amount_billed IN NUMBER,
60 X_matching_basis IN VARCHAR2 := 'QUANTITY');
61
62 /*===========================================================================
63 PROCEDURE NAME: ap_update_po_line_locations()
64
65 DESCRIPTION:
66 This procedure will accept a quantity_billed and the UOM in which the
67 quantity is, and convert it to the UOM corresponding to PO_LINE_LOCATIONS
68 and then insert the value. Also all values need to be added to the
69 existing values in the respective columns.
70
71 USAGE:
72
73 PARAMETERS: X_po_line_location_id IN NUMBER
74 PO line location ID
75 X_quantity_billed IN NUMBER
76 Billed quantity, need to convert to PO UOM
77 X_uom_lookup_code IN VARCHAR2
78 UOM in which the quantity is
79
80 DESIGN REFERENCES: Generic
81
82 ALGORITHM:
83
84 NOTES:
85
86 OPEN ISSUES:
87
88 CLOSED ISSUES:
89
90 CHANGE HISTORY:
91 25-Jan-99 James Zhang Created
92 ===========================================================================*/
93 PROCEDURE ap_update_po_line_locations( X_po_line_location_id IN NUMBER,
94 X_quantity_billed IN NUMBER,
95 X_uom_lookup_code IN VARCHAR2,
96 X_amount_billed IN NUMBER := NULL,
97 X_matching_basis IN VARCHAR2 := 'QUANTITY');
98
99 /*===========================================================================
100 PROCEDURE NAME: ap_update_rcv_transactions()
101
102 DESCRIPTION:
103 This procedure will accept a quantity_billed and the UOM in which the
104 quantity is, and convert it to the UOM corresponding to RCV_TRANSACTIONS
105 and then insert the value. Also all values need to be added to the
106 existing values in the respective columns.
107
108
109 USAGE:
110
111 PARAMETERS: X_rcv_transaction_id IN NUMBER
112 Receiving transaction ID
113 X_quantity_billed IN NUMBER
114 Billed quantity, need to convert to PO UOM
115 X_uom_lookup_code IN VARCHAR2
116 UOM in which the quantity is
117 X_amount_billed IN NUMBER
118 Billed amount
119 -- X_base_amount_billed IN NUMBER -- June 07, 1999
120 -- Base billed amount
121
122
123 DESIGN REFERENCES: Generic
124
125 ALGORITHM:
126
127 NOTES:
128
129 OPEN ISSUES:
130
131 CLOSED ISSUES:
132
133 CHANGE HISTORY:
134 25-Jan-99 James Zhang Created
135 ===========================================================================*/
136 PROCEDURE ap_update_rcv_transactions( X_rcv_transaction_id IN NUMBER,
137 X_quantity_billed IN NUMBER,
138 X_uom_lookup_code IN VARCHAR2,
139 X_amount_billed IN NUMBER,
140 X_matching_basis IN VARCHAR2 := 'QUANTITY');
141
142 END RCV_BILL_UPDATING_SV;