1 PACKAGE PAGTCX AS
2 /* $Header: PAXTGTCS.pls 120.4 2006/07/29 11:40:26 skannoji noship $ */
3 /*#
4 * Oracle Projects provides a package that contains the procedure that you can modify to implement
5 * the summmary validation extension for an expenditure.
6 * @rep:scope public
7 * @rep:product PA
8 * @rep:lifecycle active
9 * @rep:displayname Summary Validation Extension
10 * @rep:compatibility S
11 * @rep:category BUSINESS_ENTITY PA_PROJECT
12 * @rep:category BUSINESS_ENTITY PA_LABOR_COST
13 * @rep:doccd 120pjapi.pdf See the Oracle Projects API's, Client Extensions, and Open Interfaces Reference
14 */
15
16 /*#
17 * Procedure that can be modified to implement the summary validation extension.
18 * @param P_Timecard_Table The entire timecard in PL/SQL table format (used when the extension is called from Oracle Time and Labor)
19 * @rep:paraminfo {@rep:required}
20 * @param P_Module Application calling this extension (for example, OTL for Oracle Time and Labor)
21 * @rep:paraminfo {@rep:required}
22 * @param X_Expenditure_Id The internal identifier of the expenditure
23 * @rep:paraminfo {@rep:required}
24 * @param X_Incurred_By_Person_Id The identifier of the employee who submitted the expenditure
25 * @rep:paraminfo {@rep:required}
26 * @param X_Expenditure_End_Date The ending date of the expenditure period
27 * @rep:paraminfo {@rep:required}
28 * @param X_Exp_Class_Code Identifier of the expenditure type( OT for timesheets or OE for expense reports)
29 * @rep:paraminfo {@rep:required}
30 * @param X_Status Status indicating whether an error occurred. The valid values are =0 (Success), <0 OR >0 (Application Error)
31 * @rep:paraminfo {@rep:required}
32 * @param X_comment Comment to be passed back to employee submitting expenditure
33 * @rep:paraminfo {@rep:required}
34 * @param P_Action_Code The action being performed in when calling extension(For OIT only)
35 * @rep:paraminfo {@rep:required}
36 * @rep:scope public
37 * @rep:lifecycle active
38 * @rep:displayname Summary Validation Extension
39 * @rep:compatibility S
40 */
41
42 dummy Pa_Otc_Api.Timecard_Table;
43
44 PROCEDURE Summary_Validation_Extension (
45 P_Timecard_Table IN Pa_Otc_Api.Timecard_Table DEFAULT PAGTCX.dummy
46 , P_Module IN VARCHAR2 DEFAULT NULL
47 , X_expenditure_id IN NUMBER DEFAULT NULL
48 , X_incurred_by_person_id IN NUMBER
49 , X_expenditure_end_date IN DATE
50 , X_exp_class_code IN VARCHAR2
51 , X_status OUT NOCOPY VARCHAR2
52 , X_comment OUT NOCOPY VARCHAR2
53 , P_Action_Code IN VARCHAR2 DEFAULT NULL ); /*Added for Bug#3036106 */
54
55 END PAGTCX;