1 PACKAGE GMS_AP_API AS
2 /* $Header: gmsapx1s.pls 120.2 2006/05/22 12:20:50 asubrama noship $ */
3
4 -- ------------------------------------------------------------------------
5 -- PROCEDURE GMS_AP_ER_HEADERS_AUT1
6 -- Parameters : P_invoice_id Invoice_id for ap_invoice_distributions_all
7 -- : p_report_header_id Ap_expense_report_headers ID.
8 -- : p_reject_code Rejection identifier
9 -- ------------------------------------------------------------------------
10 PROCEDURE GMS_AP_ER_HEADERS_AUT1 ( P_invoice_id in NUMBER,
11 p_report_header_id IN NUMBER,
12 P_reject_code IN varchar2 ) ;
13
14 FUNCTION V_CHECK_LINE_AWARD_INFO (
15 p_invoice_line_id IN NUMBER DEFAULT NULL,
16 p_line_amount IN NUMBER DEFAULT NULL,
17 p_base_line_amount IN NUMBER DEFAULT NULL,
18 p_dist_code_concatenated IN VARCHAR2 DEFAULT NULL,
19 p_dist_code_combination_id IN OUT NOCOPY NUMBER ,
20 p_default_po_number IN VARCHAR2 DEFAULT NULL,
21 p_po_number IN VARCHAR2 DEFAULT NULL,
22 p_po_header_id IN NUMBER DEFAULT NULL,
23 p_distribution_set_id IN NUMBER DEFAULT NULL,
24 p_distribution_set_name IN VARCHAR2 DEFAULT NULL,
25 p_set_of_books_id IN NUMBER DEFAULT NULL,
26 p_base_currency_code IN VARCHAR2 DEFAULT NULL,
27 p_invoice_currency_code IN VARCHAR2 DEFAULT NULL,
28 p_exchange_rate IN NUMBER DEFAULT NULL,
29 p_exchange_rate_type IN VARCHAR2 DEFAULT NULL,
30 p_exchange_rate_date IN DATE DEFAULT NULL,
31 p_project_id IN NUMBER DEFAULT NULL,
32 p_task_id IN NUMBER DEFAULT NULL,
33 p_expenditure_type IN VARCHAR2 DEFAULT NULL,
34 p_expenditure_item_date IN DATE DEFAULT NULL,
35 p_expenditure_organization_id IN NUMBER DEFAULT NULL,
36 p_project_accounting_context IN VARCHAR2 DEFAULT NULL,
37 p_pa_addition_flag IN VARCHAR2 DEFAULT NULL,
38 p_pa_quantity IN NUMBER DEFAULT NULL,
39 p_employee_id IN NUMBER DEFAULT NULL,
40 p_vendor_id IN NUMBER DEFAULT NULL,
41 p_chart_of_accounts_id IN NUMBER DEFAULT NULL,
42 p_pa_installed IN VARCHAR2 DEFAULT NULL,
43 p_prorate_across_flag IN VARCHAR2 DEFAULT NULL,
44 p_lines_attribute_category IN VARCHAR2 DEFAULT NULL,
45 p_lines_attribute1 IN VARCHAR2 DEFAULT NULL,
46 p_lines_attribute2 IN VARCHAR2 DEFAULT NULL,
47 p_lines_attribute3 IN VARCHAR2 DEFAULT NULL,
48 p_lines_attribute4 IN VARCHAR2 DEFAULT NULL,
49 p_lines_attribute5 IN VARCHAR2 DEFAULT NULL,
50 p_lines_attribute6 IN VARCHAR2 DEFAULT NULL,
51 p_lines_attribute7 IN VARCHAR2 DEFAULT NULL,
52 p_lines_attribute8 IN VARCHAR2 DEFAULT NULL,
53 p_lines_attribute9 IN VARCHAR2 DEFAULT NULL,
54 p_lines_attribute10 IN VARCHAR2 DEFAULT NULL,
55 p_lines_attribute11 IN VARCHAR2 DEFAULT NULL,
56 p_lines_attribute12 IN VARCHAR2 DEFAULT NULL,
57 p_lines_attribute13 IN VARCHAR2 DEFAULT NULL,
58 p_lines_attribute14 IN VARCHAR2 DEFAULT NULL,
59 p_lines_attribute15 IN VARCHAR2 DEFAULT NULL,
60 p_attribute_category IN VARCHAR2 DEFAULT NULL,
61 p_attribute1 IN VARCHAR2 DEFAULT NULL,
62 p_attribute2 IN VARCHAR2 DEFAULT NULL,
63 p_attribute3 IN VARCHAR2 DEFAULT NULL,
64 p_attribute4 IN VARCHAR2 DEFAULT NULL,
65 p_attribute5 IN VARCHAR2 DEFAULT NULL,
66 p_attribute6 IN VARCHAR2 DEFAULT NULL,
67 p_attribute7 IN VARCHAR2 DEFAULT NULL,
68 p_attribute8 IN VARCHAR2 DEFAULT NULL,
69 p_attribute9 IN VARCHAR2 DEFAULT NULL,
70 p_attribute10 IN VARCHAR2 DEFAULT NULL,
71 p_attribute11 IN VARCHAR2 DEFAULT NULL,
72 p_attribute12 IN VARCHAR2 DEFAULT NULL,
73 p_attribute13 IN VARCHAR2 DEFAULT NULL,
74 p_attribute14 IN VARCHAR2 DEFAULT NULL,
75 p_attribute15 IN VARCHAR2 DEFAULT NULL,
76 p_partial_segments_flag IN VARCHAR2 DEFAULT NULL,
77 p_default_last_updated_by IN NUMBER DEFAULT NULL,
78 p_default_last_update_login IN NUMBER DEFAULT NULL,
79 p_calling_sequence IN VARCHAR2 DEFAULT NULL,
80 p_award_id IN OUT NOCOPY NUMBER,
81 P_EVENT IN varchar2 ) return BOOLEAN ;
82
83
84 PROCEDURE CREATE_AWARD_DISTRIBUTIONS( p_invoice_id IN NUMBER,
85 p_distribution_line_number IN NUMBER,
86 p_invoice_distribution_id IN NUMBER,
87 p_award_id IN NUMBER,
88 p_mode IN VARCHAR2 default 'AP',
89 p_dist_set_id IN NUMBER default NULL,
90 p_dist_set_line_number IN NUMBER default NULL
91 ) ;
92 Procedure GET_DISTRIBUTION_AWARD ( p_invoice_id IN NUMBER,
93 p_distribution_line_number IN NUMBER,
94 p_invoice_distribution_id IN NUMBER,
95 p_award_set_id IN NUMBER,
96 p_award_id IN OUT NOCOPY NUMBER ) ;
97
98 FUNCTION GMS_DEBUG_SWITCH( p_debug_flag varchar2 ) return boolean ;
99
100 Procedure CREATE_PREPAY_ADL(p_prepay_dist_id IN NUMBER ,
101 p_invoice_id IN NUMBER ,
102 p_next_dist_line_num IN NUMBER,
103 p_invoice_distribution_id IN NUMBER );
104
105
106 -- ============================================================================
107 -- BUG : 2676134 ( APXIIMPT distribution set with invalid award not validated.
108 -- ============================================================================
109 PROCEDURE GET_DIST_SET_AWARD ( p_distribution_set_id IN NUMBER,
110 p_distribution_set_line_number IN NUMBER,
111 p_award_set_id IN NUMBER,
112 p_award_id IN OUT NOCOPY NUMBER ) ;
113
114 -- Start of comments
115 -- -----------------
116 -- API Name : verify_create_adl
117 -- Type : public
118 -- Pre Reqs : None
119 -- Function : This is used to create award distribution lines
120 -- using the bulk processing. This provides a
121 -- interface with ap recurring invoice feature.
122 -- Logic : Identify the newly created invoice distribution
123 -- lines and create award distribution lines for
124 -- sponsored project.
125 -- Parameters :
126 -- IN : p_invoice_id IN NUMBER
127 -- The invoice id created and that may
128 -- have distributions associated with
129 -- an award.
130 -- : p_calling_sequence IN varchar2
131 -- calling sequence of the API for the debugging purpose.
132 -- Calling API : AP_RECURRING_INVOICES_PKG.ap_create_recurring_invoices
133 --
134 -- End of comments
135 -- ----------------
136
137 PROCEDURE verify_create_adls( p_invoice_id IN NUMBER,
138 p_calling_sequence IN VARCHAR2 ) ;
139
140 PROCEDURE validate_transaction( x_project_id IN NUMBER,
141 x_task_id IN NUMBER,
142 x_award_id IN NUMBER,
143 x_expenditure_type IN varchar2,
144 x_expenditure_item_date IN DATE,
145 x_calling_sequence in VARCHAR2,
146 x_msg_application in out nocopy VARCHAR2,
147 x_msg_type out nocopy VARCHAR2,
148 X_msg_count OUT nocopy NUMBER,
149 X_msg_data OUT nocopy VARCHAR2 ) ;
150
151 FUNCTION GET_DISTRIBUTION_AWARD ( p_award_set_id IN NUMBER ) return NUMBER ;
152
153 FUNCTION vert_install RETURN BOOLEAN; /* Added for Bug 5194359 */
154
155 END GMS_AP_API;
[Home] [Help]