1 PACKAGE GMS_OIE_INT_PKG AUTHID CURRENT_USER AS
2 -- $Header: gmsoieis.pls 115.10 2002/11/26 12:28:52 srkotwal noship $
3
4 SUBTYPE gms_awardNum IS gms_awards_all.award_number%TYPE;
5 SUBTYPE gms_awardId IS gms_awards_all.award_id%TYPE;
6 SUBTYPE gms_awardName IS gms_awards_all.award_short_name%TYPE;
7
8 -------------------------------------------------------------------
9 -- Name: RaiseException
10 -- Desc: common routine for handling unrecoverrable(database) errors
11 -- Params: p_calling_squence - the name of the caller function
12 -- p_debug_info - additional error message
13 -- p_set_name - fnd message name
14 -- p_params - fnd message parameters
15 -------------------------------------------------------------------
16 PROCEDURE RaiseException(
17 p_calling_sequence IN VARCHAR2,
18 p_debug_info IN VARCHAR2 DEFAULT '',
19 p_set_name IN VARCHAR2 DEFAULT NULL,
20 p_params IN VARCHAR2 DEFAULT ''
21 );
22
23
24 FUNCTION GetAwardNumber(
25 p_award_id IN gms_awardId,
26 p_award_number OUT NOCOPY gms_awardNum
27 ) RETURN BOOLEAN;
28 ----------
29 -------------------------------------------------------------------
30 -- Name: GetAwardInfo
31 -- Desc: This function returns TRUE or FALSE depending on whether
32 -- Award_ID and Award_Name are found for a given Award_Number
33 -- Params: p_award_number - IN parameter for award_number
34 -- p_award_id - OUT NOCOPY param for Award_ID
35 -- p_award_name - OUT NOCOPY param for Award_Number
36 -------------------------------------------------------------------
37
38 FUNCTION GetAwardInfo(
39 p_award_number IN gms_awardNum,
40 p_award_id OUT NOCOPY gms_awardId,
41 p_award_name OUT NOCOPY gms_awardName
42 ) RETURN BOOLEAN;
43 ----------
44 -------------------------------------------------------------------
45 -- Name: GetAwardID
46 -- Desc: This function returns TRUE or FALSE depending on whether
47 -- Award_ID is found for a given Award_Number
48 -- Params: p_Award_number - IN param for Award_Number
49 -- p_award_id - OUT NOCOPY param for Award_ID
50 -------------------------------------------------------------------
51
52 FUNCTION GetAwardID(
53 p_award_number IN gms_awardNum,
54 p_award_id OUT NOCOPY gms_awardId
55 ) RETURN BOOLEAN;
56 ----------
57 -------------------------------------------------------------------
58 -- Name: IsSponsoredProject
59 -- Desc: This function returns TRUE or FALSE depending on whether
60 -- a given project is sponsored
61 -- Params: p_project_num - IN param for Project_Number
62 -- p_sponsored_flag - OUT NOCOPY param for Sponsored_Flag
63 -- valid values are 'N' and 'Y'
64 -------------------------------------------------------------------
65
66 FUNCTION IsSponsoredProject(
67 p_project_num IN varchar2,
68 p_sponsored_flag OUT NOCOPY varchar2
69 ) RETURN BOOLEAN;
70 ----------
71 -------------------------------------------------------------------
72 -- Name: IsGrantsEnabled
73 -- Desc: This function returns TRUE or FALSE depending on whether
74 -- Grants Accounting is implemented
75 -- Params: None
76 -------------------------------------------------------------------
77
78 FUNCTION IsGrantsEnabled RETURN BOOLEAN;
79 ----------
80 -------------------------------------------------------------------
81 -- Name: IsAwardValid
82 -- Desc: This function returns TRUE or FALSE depending on whether
83 -- a given award_number is valid
84 -- Params: p_Award_number - IN param for Award_Number
85 -------------------------------------------------------------------
86
87 FUNCTION IsAwardValid(
88 p_award_number IN gms_awardNum
89 )RETURN BOOLEAN;
90 ----------
91 -------------------------------------------------------------------
92 -- Name: AwardFundingProject
93 -- Desc: This function returns TRUE or FALSE depending on whether
94 -- Award is funding the project and/or task
95 -- Params: p_award_id - IN param for Award_ID
96 -- p_project_id - IN param for Project_ID
97 -- p_task_id - IN param for Task_ID
98 -------------------------------------------------------------------
99
100 FUNCTION AwardFundingProject (
101 p_award_id IN NUMBER,
102 p_project_id IN NUMBER,
103 p_task_id IN NUMBER
104 ) RETURN BOOLEAN;
105 ----------
106 -------------------------------------------------------------------
107 -- Name: DoGrantsValidation
108 -- Desc: This function returns TRUE or FALSE depending on whether
109 -- validation for the data passes or not
110 -- Params:
111 -- p_project_id - IN param for Project_ID
112 -- p_task_id - IN param for Task_ID
113 -- p_award_id - IN param for Award_ID
114 -- p_Award_number - IN param for Award_Number
115 -- p_expenditure_type - IN param for Expenditre_Type
116 -- p_expenditure_item_date - IN param for Expenditure_Item_Date
117 -- p_calling_module - IN param for Calling_Module, hard coded to 'GMS-OIE'
118 -- p_err_msg - OUT NOCOPY param for Error Message. Give the actual error
119 -------------------------------------------------------------------
120 FUNCTION DoGrantsValidation ( p_project_id IN NUMBER,
121 p_task_id IN NUMBER,
122 p_award_id IN NUMBER,
123 p_award_number IN VARCHAR2,
124 p_expenditure_type IN VARCHAR2,
125 p_expenditure_item_date IN DATE,
126 p_calling_module IN VARCHAR2,
127 p_err_msg OUT NOCOPY VARCHAR2
128 ) RETURN BOOLEAN ;
129 ----------
130 -------------------------------------------------------------------
131 -- Name: CreateACGenADL
132 -- Desc: This function returns number for Award_Set_ID. This award_set_id
133 -- is used for Account Generation purposes
134 -- Params:
135 -- p_award_id - IN param for Award_ID
136 -- p_project_id - IN param for Project_ID
137 -- p_task_id - IN param for Task_ID
138 -------------------------------------------------------------------
139 FUNCTION CreateACGenADL(p_award_id IN NUMBER,
140 p_project_id IN NUMBER,
141 p_task_id IN NUMBER)
142 RETURN NUMBER;
146 -- Desc: This function returns Boolean, signifying whether the ADL created for
143 ----------
144 -------------------------------------------------------------------
145 -- Name: DeleteACGenADL
147 -- Account Generation process has been deleted.
148 --
149 -- Params:
150 -- p_award_set_id - IN param for Award_Set_ID
151 -------------------------------------------------------------------
152 FUNCTION DeleteACGenADL(p_award_set_id IN NUMBER)
153 RETURN BOOLEAN;
154 ----------
155 -------------------------------------------------------------------
156 -- Name: CREATE_AWARD_DISTRIBUTIONS
157 -- Desc: This procedure creates the ADLs for the Invoices that are
158 -- successfully imported to Payables and updates the award_id
159 -- column in ap_invoice_distribution_lines table with the
160 -- award_set_id value.
161 --
162 -- Params: p_invoice_id - IN PL/SQL table of Invoice_IDs.
163 -- p_source - IN param for source (SelfServie for OIE
164 -- Oracle Project Accounting for PA Exp Rep etc)
165 -------------------------------------------------------------------
166
167 TYPE invoice_id_tab is table of number index by binary_integer;
168
169 PROCEDURE CREATE_AWARD_DISTRIBUTIONS( p_invoice_id IN gms_oie_int_pkg.invoice_id_tab);
170 ----------
171 -------------------------------------------------------------------
172 -- Name: GMS_ENABLED
173 -- Desc: This is a wrapper procedure used in Invoice Import process
174 -- to check whether Grants Accounting is implemented.
175 -- This procedure calls gms_install.enable function. Function call
176 -- is not directly supported as the build requires sqlcheck=syntax
177 -- and the function call requires : sqlcheck=semantics.
178 --
179 -- Params: p_enabled - OUT.
180 -- Returns 0 - if Grants Accounting is not enabled.
181 -- Returns 1 - if Grants Accouting is enabled
182 -------------------------------------------------------------------
183
184 PROCEDURE GMS_ENABLED ( p_gms_enabled out NOCOPY number);
185
186 ----------
187 END GMS_OIE_INT_PKG;