[Home] [Help]
PACKAGE: APPS.GMS_AWARD_DELETE_PKG
Source
1 PACKAGE GMS_AWARD_DELETE_PKG as
2 /* $Header: gmsawdls.pls 120.1 2005/07/26 14:20:33 appldev ship $ */
3 /*===============================================================================
4 Verify whether user can delete the award or not
5 ===============================================================================*/
6 FUNCTION Delete_Award_Ok
7 (
8 p_Award_Id IN NUMBER,
9 p_Billing_Rule IN VARCHAR2, -- Stop using parameter bug 2355648
10 p_Revenue_Rule IN VARCHAR2, -- Stop using parameter bug 2355648
11 RETCODE OUT NOCOPY VARCHAR2,
12 ERRBUFF OUT NOCOPY VARCHAR2
13 ) RETURN BOOLEAN;
14
15 /*===============================================================================
16 Delete all award related information if award is getting deleted
17 ===============================================================================*/
18
19 PROCEDURE Delete_Award_All
20 ( p_Award_Id IN NUMBER,
21 p_msg_count OUT NOCOPY NUMBER,
22 RETCODE OUT NOCOPY VARCHAR2,
23 ERRBUFF OUT NOCOPY VARCHAR2
24 );
25
26 /*===============================================================================
27 Checks whether project funding exists.
28 ===============================================================================*/
29 FUNCTION Check_Funding_Exists
30 (
31 p_Award_Id IN NUMBER,
32 p_msg_count OUT NOCOPY NUMBER, --Added for bug 2355648
33 RETCODE OUT NOCOPY VARCHAR2,
34 ERRBUFF OUT NOCOPY VARCHAR2
35 ) RETURN BOOLEAN;
36
37
38 /*===============================================================================
39 Checks whether draft budget exists.
40 ===============================================================================*/
41 FUNCTION Check_Draft_Budget_Exists
42 (
43 p_Award_Id IN NUMBER,
44 p_msg_count OUT NOCOPY NUMBER ,--Added for bug 235564
45 RETCODE OUT NOCOPY VARCHAR2,
46 ERRBUFF OUT NOCOPY VARCHAR2
47
48 ) RETURN BOOLEAN;
49
50 /* Added below API to fix bug 2355648 */
51
52 PROCEDURE DELETE_AWARD_DETAIL( p_award_id IN NUMBER ,
53 p_award_project_id IN NUMBER,
54 p_agreement_id IN NUMBER,
55 p_Award_Template_flag IN VARCHAR2,
56 p_msg_count OUT NOCOPY NUMBER,
57 RETCODE OUT NOCOPY VARCHAR2,
58 ERRBUFF OUT NOCOPY VARCHAR2);
59
60 END GMS_AWARD_DELETE_PKG;