1 PACKAGE pa_client_extn_output_tax AUTHID CURRENT_USER AS
2 /* $Header: PAXPOTXS.pls 120.12 2006/07/25 06:38:32 lveerubh noship $ */
3 /*#
4 *In the Tax Defaults implementation option, you set up a hierarchy for determining default tax codes for invoice lines.
5 *One of the sources the system can use to find default tax codes is the Output Tax client extension.
6 *Oracle Projects uses the extension during the Generate Draft Invoices process, if it has not yet found the output tax code
7 *using the Tax Defaults hierarchy. You can modify the extension to satisfy your business rules for assigning the default output
8 *tax code for invoice lines.
9 * @rep:scope public
10 * @rep:product PA
11 * @rep:lifecycle active
12 * @rep:displayname Output Tax Extension
13 * @rep:compatibility S
14 * @rep:category BUSINESS_ENTITY PA_PROJECT
15 * @rep:category BUSINESS_ENTITY PA_INVOICE
16 * @rep:doccd 120pjapi.pdf See the Oracle Projects API's, Client Extensions, and Open Interfaces Reference
17 */
18
19 /*#
20 * This procedure assigns a tax code to an invoice line.
21 * @param P_project_id The identifier of the project
22 * @rep:paraminfo {@rep:required}
23 * @param P_customer_id The identifier of the customer
24 * @rep:paraminfo {@rep:required}
25 * @param P_bill_to_site_use_id The identifier of the bill-to site
26 * @rep:paraminfo {@rep:required}
27 * @param P_ship_to_site_use_id The identifier of the ship-to site
28 * @rep:paraminfo {@rep:required}
29 * @param P_set_of_books_id The identifier of the set of books associated with the project
30 * @rep:paraminfo {@rep:required}
31 * @param P_expenditure_item_id The identifier of the expenditure item
32 * @rep:paraminfo {@rep:required}
33 * @param P_event_id The identifier of the event
34 * @rep:paraminfo {@rep:required}
35 * @param P_line_type The type of invoice line (event, expenditure, or retention)
36 * @rep:paraminfo {@rep:required}
37 * @param P_request_id The request identifier of the Generate Draft Invoices process
38 * @rep:paraminfo {@rep:required}
39 * @param P_user_id The identifier of the user who ran the Generate Draft Invoices process
40 * @rep:paraminfo {@rep:required}
41 * @param X_output_tax_code The identifier of the output tax code
42 * @rep:paraminfo {@rep:required}
43 * @rep:scope public
44 * @rep:lifecycle active
45 * @rep:displayname Get Tax Codes
46 * @rep:compatibility S
47 */
48
49 PROCEDURE get_tax_code
50 ( P_project_id IN NUMBER,
51 P_customer_id IN NUMBER DEFAULT NULL,
52 P_bill_to_site_use_id IN NUMBER DEFAULT NULL,
53 P_ship_to_site_use_id IN NUMBER DEFAULT NULL,
54 P_set_of_books_id IN NUMBER DEFAULT NULL,
55 P_expenditure_item_id IN NUMBER DEFAULT NULL,
56 P_event_id IN NUMBER DEFAULT NULL,
57 P_line_type IN VARCHAR2 DEFAULT NULL,
58 P_request_id IN NUMBER DEFAULT NULL,
59 P_user_id IN NUMBER DEFAULT NULL,
60 X_output_tax_code OUT NOCOPY VARCHAR2 ); --File.Sql.39 bug 4440895
61 end pa_client_extn_output_tax;