1 PACKAGE GMS_TRANSACTIONS_PUB AUTHID CURRENT_USER AS
2 -- $Header: gmstpubs.pls 120.1 2005/07/26 14:38:44 appldev ship $
3
4 -- -------------------------------------------------------------
5 -- Common Table handler for Table GMS_transaction Interface all
6 -- -------------------------------------------------------------
7
8 PROCEDURE LOAD_GMS_XFACE_API ( p_rec gms_transaction_interface_all%ROWTYPE
9 ,P_OUTCOME OUT NOCOPY varchar2 ) ;
10
11 PROCEDURE UPDATE_GMS_XFACE_API ( p_rec gms_transaction_interface_all%ROWTYPE
12 , P_OUTCOME OUT NOCOPY varchar2 ) ;
13
14 PROCEDURE DELETE_GMS_XFACE_API ( p_rec gms_transaction_interface_all%ROWTYPE
15 , P_OUTCOME OUT NOCOPY varchar2 ) ;
16
17 PROCEDURE validate_transaction( P_project_id IN NUMBER
18 , P_task_id IN NUMBER
19 , P_award_id IN NUMBER
20 , P_expenditure_type IN VARCHAR2
21 , P_expenditure_item_date IN DATE
22 , P_calling_module IN varchar2
23 , P_OUTCOME OUT NOCOPY VARCHAR2) ;
24
25 -- This function is used by Procedure validate_award. Procedure Validate_award is used by
26 -- GMS_OIE_INT_PKG (OIE Integration Validation Package)
27
28 FUNCTION Is_Sponsored_Project(x_project_id IN NUMBER) RETURN BOOLEAN;
29
30 -- This procedure is called from the validation package for Internet Expenses.
31 -- This is called if Grants is implemented and after pressing the Submit for the Expense Report.
32 -- All validations for the Award entered are done and the status code is returned indicating success
33 -- or failure. If there is a failure, then the error message is returned via x_err_msg.
34
35 PROCEDURE validate_award ( X_project_id IN NUMBER,
36 X_task_id IN NUMBER,
37 X_award_id IN NUMBER,
38 X_award_number IN VARCHAR2,
39 X_expenditure_type IN VARCHAR2,
40 X_expenditure_item_date IN DATE,
41 X_calling_module IN VARCHAR2,
42 X_status IN OUT NOCOPY VARCHAR2,
43 X_err_msg OUT NOCOPY VARCHAR2 );
44
45 END GMS_TRANSACTIONS_PUB;