1 PACKAGE GMS_POR_API as
2 --$Header: gmspor1s.pls 120.0 2005/05/29 11:24:55 appldev noship $
3
4 FUNCTION get_award_number ( X_award_set_id IN NUMBER,
5 X_award_id IN NUMBER,
6 X_req_distribution_id IN NUMBER)
7 return VARCHAR2 ;
8
9 FUNCTION get_award_ID ( X_award_set_id IN NUMBER,
10 X_award_number IN VARCHAR2,
11 X_req_distribution_id IN NUMBER)
12 return NUMBER ;
13
14 PROCEDURE validate_award ( X_project_id IN NUMBER,
15 X_task_id IN NUMBER,
16 X_award_id IN NUMBER,
17 X_award_number IN VARCHAR2,
18 X_expenditure_type IN VARCHAR2,
19 X_expenditure_item_date IN DATE,
20 X_calling_module IN VARCHAR2,
21 X_source_type_code IN VARCHAR2,
22 X_status IN OUT NOCOPY VARCHAR2,
23 X_err_msg OUT NOCOPY VARCHAR2 ) ;
24 --BUG 3295360 : add Procedure to provide backward compatibility through overloading
25 PROCEDURE validate_award ( X_project_id IN NUMBER,
26 X_task_id IN NUMBER,
27 X_award_id IN NUMBER,
28 X_award_number IN VARCHAR2,
29 X_expenditure_type IN VARCHAR2,
30 X_expenditure_item_date IN DATE,
31 X_calling_module IN VARCHAR2,
32 X_status IN OUT NOCOPY VARCHAR2,
33 X_err_msg OUT NOCOPY VARCHAR2 ) ;
34
35 PROCEDURE account_generator_ADL ( X_project_id IN NUMBER,
36 X_task_id IN NUMBER,
37 X_award_id IN NUMBER,
38 X_event IN VARCHAR2,
39 X_award_set_id IN OUT NOCOPY NUMBER,
40 X_status IN OUT NOCOPY varchar2 ) ;
41
42 PROCEDURE when_insert_line ( X_distribution_id IN NUMBER,
43 X_project_id IN NUMBER,
44 X_task_id IN NUMBER,
45 X_award_id IN NUMBER,
46 X_expenditure_type IN VARCHAR2,
47 X_expenditure_item_date IN DATE,
48 X_award_set_id OUT NOCOPY NUMBER,
49 X_status IN OUT NOCOPY varchar2 ) ;
50 --
51 -- 3068454 ( CHANGE REQUIRED IN GMS_POR_API.WHEN_UPDATE/INSERT_LINE TO WORK
52 -- WITH OA GUIDELINE )
53 --
54 PROCEDURE get_req_dist_AwardSetID ( X_distribution_id IN NUMBER,
55 X_award_set_id OUT NOCOPY NUMBER,
56 X_status IN OUT NOCOPY varchar2 ) ;
57
58 PROCEDURE when_update_line ( X_distribution_id IN NUMBER,
59 X_project_id IN NUMBER,
60 X_task_id IN NUMBER,
61 X_award_id IN NUMBER,
62 X_expenditure_type IN VARCHAR2,
63 X_expenditure_item_date IN DATE,
64 X_award_set_id OUT NOCOPY NUMBER,
65 X_status IN OUT NOCOPY varchar2 ) ;
66
67 PROCEDURE when_update_line ( X_distribution_id IN NUMBER,
68 X_project_id IN NUMBER,
69 X_task_id IN NUMBER,
70 X_award_id IN NUMBER,
71 X_expenditure_type IN VARCHAR2,
72 X_expenditure_item_date IN DATE,
73 X_status IN OUT NOCOPY varchar2 ) ;
74
75 PROCEDURE when_delete_line ( X_distribution_id IN NUMBER,
76 X_status IN OUT NOCOPY varchar2 ) ;
77
78 --
79 -- Start : 3103564
80 -- NEW DELETE API NEEDED FOR DELETING AN AWARD DISTRIBUTION LINE
81 --
82 -- Start of comments
83 -- API name : delete_adl
84 -- Type : Public
85 -- Pre-reqs : None.
86 -- Function : Deletes a record from gms_award_distributions
87 -- table.
88 -- Parameters :
89 -- IN : p_award_set_id IN NUMBER Required
90 -- .
91 -- .
92 -- OUT : x_status OUT Varchar2
93 -- values are 'S', 'E', 'U'
94 -- fnd_api.G_RET_STS_SUCCESS
95 -- fnd_api.G_RET_STS_ERROR
96 -- fnd_api.G_RET_STS_UNEXP_ERROR
97 -- End of comments
98
99 PROCEDURE delete_adl ( p_award_set_id IN NUMBER,
100 x_status OUT NOCOPY varchar2,
101 x_err_msg OUT NOCOPY varchar2 ) ;
102 --
103 -- NEW DELETE API NEEDED FOR DELETING AN AWARD DISTRIBUTION LINE
104 -- End : 3103564
105 --
106
107 --=================================================================
108 -- Bug-2557041
109 -- This API used by IP to determine award distribution information
110 --=================================================================
111 PROCEDURE get_award_dist_param (p_award_dist_option OUT NOCOPY VARCHAR2,
112 p_dist_award_number OUT NOCOPY VARCHAR2,
113 p_dist_award_id OUT NOCOPY NUMBER );
114
115 --==============================================================
116 --Bug-2557041
117 -- following API used to validate dummy award specific validation
118 --==============================================================
119 PROCEDURE validate_dist_award( p_project_id IN NUMBER,
120 p_task_id IN NUMBER,
121 p_award_id IN NUMBER,
122 p_expenditure_type IN VARCHAR2,
123 p_status IN OUT NOCOPY VARCHAR2,
124 p_err_msg_label OUT NOCOPY VARCHAR2 ) ;
125
126 --=============================================================
127 -- Bug-2557041
128 -- The purpose of this API is to prepare for award distributions
129 -- and kicks off award distribution engine
130 --=============================================================
131 PROCEDURE distribute_award ( p_doc_header_id IN NUMBER,
132 p_distribution_id IN NUMBER,
133 p_document_source IN VARCHAR2,
134 p_gl_encumbered_date IN DATE,
135 p_project_id IN NUMBER,
136 p_task_id IN NUMBER,
137 p_dummy_award_id IN NUMBER,
138 p_expenditure_type IN VARCHAR2,
139 p_expenditure_organization_id IN NUMBER,
140 p_expenditure_item_date IN DATE,
141 p_quantity IN NUMBER,
142 p_unit_price IN NUMBER,
143 p_func_amount IN NUMBER,
144 p_vendor_id IN NUMBER,
145 p_source_type_code IN VARCHAR2,
146 p_award_qty_obj OUT NOCOPY gms_obj_award,
147 p_status OUT NOCOPY VARCHAR2,
148 p_error_msg_label OUT NOCOPY VARCHAR2 );
149
150
151 FUNCTION enabled return varchar2 ;
152
153
154
155 END GMS_POR_API ;