PACKAGE: APPS.PO_RELEASES_SV

Source

1 PACKAGE PO_RELEASES_SV as
2 /* $Header: POXPOR1S.pls 120.1 2005/06/10 01:57:24 kpsingh noship $ */
3 
4 /*===========================================================================
5   PACKAGE NAME:		PO_RELEASES_SV
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:	lock_row_for_status_update
17 		        delete_release()
18 			delete_children()
19 			insert_release()
20 			update_release()
21 
22 ===========================================================================*/
23 
24 /*===========================================================================
25   FUNCTION NAME:	lock_row_for_status_update
26 
27   DESCRIPTION:   	Locks a row in the po_releases table for update.
28 
29   PARAMETERS:		x_po_release_id		IN	NUMBER
30 
31   DESIGN REFERENCES:	POXDOAPP.fmb
32 
33   ALGORITHM:
34 
35   NOTES:
36 
37   OPEN ISSUES:
38 
39   CLOSED ISSUES:
40 
41   CHANGE HISTORY:	cmok	7/26	created it
42 ===========================================================================*/
43 
44 PROCEDURE lock_row_for_status_update (x_po_release_id  IN  NUMBER);
45 
46 /*===========================================================================
47   PROCEDURE NAME:	delete_release
48 
49   DESCRIPTION:		Cover routine that includes deleting the
50 			release header and all of it's children.
51 
52 
53 
54   PARAMETERS:	        X_po_release_id IN NUMBER,
55 	                X_row_id        IN VARCHAR2
56 
57   DESIGN REFERENCES:
58 
59   ALGORITHM:
60 
61   NOTES:
62 
63   OPEN ISSUES:
64 
65   CLOSED ISSUES:
66 
67   CHANGE HISTORY:	KPOWELL CREATED 5/4
68 
69 ===========================================================================*/
70    PROCEDURE delete_release
71 		      (X_po_release_id IN NUMBER,
72 	               X_row_id        IN VARCHAR2);
73 
74 /*===========================================================================
75   PROCEDURE NAME:	delete_children
76 
77   DESCRIPTION:		Deletes all of the children associated with
78 			a release header including:
79 				- shipments
80 				- distributions
81 				- attachements
82 				- notifications
83 				- the requisition link to the PO
84 
85   PARAMETERS:	        X_po_release_id IN NUMBER
86 
87   DESIGN REFERENCES:
88 
89   ALGORITHM:
90 
91   NOTES:
92 
93   OPEN ISSUES:		DEBUG.  Need to include calls to other packages.
94 			(KP - 5/4)
95 
96   CLOSED ISSUES:
97 
98   CHANGE HISTORY:	KPOWELL CREATED 5/4
99 
100 ===========================================================================*/
101    PROCEDURE delete_children
102 		      (X_po_release_id IN NUMBER);
103 
104 
105 END PO_RELEASES_SV;