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;