1 PACKAGE PO_REQ_DIST_SV1 AUTHID CURRENT_USER as
2 /* $Header: POXRQD2S.pls 115.4 2003/12/19 18:57:32 jskim ship $ */
3 /*===========================================================================
4 PACKAGE NAME: po_req_dist_sv1
5
6 DESCRIPTION: Contains all the server side procedures
7 that access the entity, PO_REQ_DISTRIBUTIONS.
8
9 CLIENT/SERVER: Server
10
11 LIBRARY NAME None
12
13 OWNER: MCHIHAOU
14
15 PROCEDURE NAMES: get_dist_num
16
17 ===========================================================================*/
18 /*===========================================================================
19 PROCEDURE NAME: get_dist_num_account
20
21 DESCRIPTION: Obtain the number of distributions for
22 the specified line. If there is only
23 one distribution then the procedure also
24 provides the ccid for the distribution.
25
26 PARAMETERS: x_requisition_line_id
27 x_num_of_dist
28 x_code_combination_id
29
30 DESIGN REFERENCES: POXRQERQ.doc
31
32 ALGORITHM:
33
34 NOTES:
35
36 OPEN ISSUES:
37
38 CLOSED ISSUES:
39
40 CHANGE HISTORY: 10/30 RMULPURY Created
41 ===========================================================================*/
42 PROCEDURE get_dist_num_account( x_requisition_line_id IN OUT NOCOPY NUMBER,
43 x_num_of_dist IN OUT NOCOPY NUMBER,
44 x_code_combination_id IN OUT NOCOPY NUMBER);
45
46 /*===========================================================================
47 PROCEDURE NAME: get_dist_account
48
49 DESCRIPTION: Used to get the code_combination_id if the line
50 has only one distribution. Otherwise, if the line
51 has multiple distributions it will return the number
52 -11. If the line has no distributions, it will return
53 null.
54 Created in order to eliminate POST_QUERY processing,
55 by calling this function in view po_requisition_lines_v.
56
57 PARAMETERS: x_requisition_line_id
58
59 DESIGN REFERENCES:
60
61 ALGORITHM:
62
63 NOTES:
64
65 OPEN ISSUES:
66
67 CLOSED ISSUES:
68
69 CHANGE HISTORY: 7/3/96 MCHIHAOU Created
70 ===========================================================================*/
71 FUNCTION get_dist_account( x_requisition_line_id IN NUMBER) return NUMBER;
72
73
74 --pragma restrict_references(get_dist_account,WNDS,RNPS,WNPS);
75
76 --< Bug 3265539 > Removed unused function get_project_num.
77
78 /*===========================================================================
79 PROCEDURE NAME: update_dist_quantity
80
81 DESCRIPTION: Verify if the requisition line
82 has only one distribution . If it
83 does then the procedure updates the
84 distribution quantity to match the
85 line quantity only if the distribution
86 is not encumbered.
87
88 PARAMETERS: x_requisition_line_id
89 x_line_quantity
90
91
92 DESIGN REFERENCES: POXRQERQ.doc
93
94 ALGORITHM:
95
96 NOTES:
97
98 OPEN ISSUES:
99
100 CLOSED ISSUES:
101
102 CHANGE HISTORY: 03/23 RMULPURY Created
103 ===========================================================================*/
104 PROCEDURE update_dist_quantity( x_requisition_line_id NUMBER,
105 x_line_quantity NUMBER);
106
107
108
109 END po_req_dist_sv1;