[Home] [Help]
PACKAGE: APPS.PO_RELEASES_SV2
Source
1 PACKAGE PO_RELEASES_SV2 AUTHID CURRENT_USER as
2 /* $Header: POXPOR2S.pls 115.6 2004/03/24 15:37:02 manram ship $ */
3
4 /*===========================================================================
5 PACKAGE NAME: PO_RELEASES_SV2
6
7 DESCRIPTION: Contains all server side procedures that access the
8 PO_RELEASES entity
9
10 CLIENT/SERVER: SERVER
11
12 LIBRARY NAME NONE
13
14 OWNER: KPOWELL
15
16 PROCEDURES/FUNCTIONS:
17 get_po_header_details()
18 get_rel_total()
19 get_release_status()
20
21 ===========================================================================*/
22
23 PROCEDURE get_po_header_details(
24 X_po_header_id IN NUMBER,
25 X_type_lookup_code IN OUT NOCOPY VARCHAR2,
26 X_revision_num IN OUT NOCOPY NUMBER,
27 X_currency_code IN OUT NOCOPY VARCHAR2,
28 X_supplier_id IN OUT NOCOPY NUMBER,
29 X_supplier_name IN OUT NOCOPY VARCHAR2,
30 X_supplier_site_id IN OUT NOCOPY NUMBER,
31 X_supplier_site_name IN OUT NOCOPY VARCHAR2,
32 X_pay_on_code IN OUT NOCOPY VARCHAR2,
33 X_pay_on_dsp IN OUT NOCOPY VARCHAR2,
34 X_ship_to_location_id IN OUT NOCOPY NUMBER,
35 X_ship_to_location_code IN OUT NOCOPY VARCHAR2,
36 X_organization_id IN OUT NOCOPY NUMBER,
37 X_organization_code IN OUT NOCOPY VARCHAR2,
38 x_shipping_control IN OUT NOCOPY VARCHAR2, -- <INBOUND LOGISITCS FPJ>
39 x_supply_agreement_flag IN OUT NOCOPY VARCHAR2, --Bug#3514141
40 x_confirming_order_flag IN OUT NOCOPY VARCHAR2); --Bug#3514141
41
42 /*===========================================================================
43 FUNCTION NAME: get_rel_total
44
45 DESCRIPTION: Gets the release total for the view
46 PO_RELEASES_v
47
48 PARAMETERS: X_release_id IN NUMBER
49
50 DESIGN REFERENCES:
51
52 ALGORITHM:
53
54 NOTES:
55
56 OPEN ISSUES:
57
58 CLOSED ISSUES:
59
60 CHANGE HISTORY: KPOWELL CREATED 11/1
61 ===========================================================================*/
62 FUNCTION get_rel_total(X_release_id NUMBER)
63 return number;
64 -- pragma restrict_references (get_rel_total,WNDS,RNPS,WNPS);
65
66
67 /*===========================================================================
68 FUNCTION NAME: get_release_status
69
70 DESCRIPTION: gets the auto, cancel, close, hold, frozen,
71 reserved status of the release
72 for the view po_releases_v.
73
74 PARAMETERS: See below.
75
76 DESIGN REFERENCES:
77
78 ALGORITHM:
79
80 NOTES:
81
82 OPEN ISSUES:
83
84 CLOSED ISSUES:
85
86 CHANGE HISTORY: KPOWELL CREATED 10/10
87
88 ===========================================================================*/
89 FUNCTION get_release_status(X_po_release_id NUMBER)
90 return VARCHAR2;
91 -- pragma restrict_references (get_release_status,WNDS,RNPS,WNPS);
92
93
94 END PO_RELEASES_SV2;