[Home] [Help]
PACKAGE: APPS.PO_RELEASES_SV
Source
1 PACKAGE PO_RELEASES_SV AUTHID CURRENT_USER 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;