1 package PA_CLIENT_EXTN_RTE AUTHID CURRENT_USER as
2 -- $Header: PAXTRT1S.pls 120.5 2006/07/29 11:40:44 skannoji noship $
3 /*#
4 * Oracle Projects provides a template package that contains the procedure that you can modify to implement check approval extensions.
5 * @rep:scope public
6 * @rep:product PA
7 * @rep:lifecycle active
8 * @rep:displayname Check Approval
9 * @rep:compatibility S
10 * @rep:category BUSINESS_ENTITY PA_PROJECT
11 * @rep:category BUSINESS_ENTITY PA_LABOR_COST
12 * @rep:doccd 120pjapi.pdf See the Oracle Projects API's, Client Extensions, and Open Interfaces Reference
13 */
14
15 /*#
16 * Procedure that can be modified to implement check approval extensions
17 * @param X_Expenditure_Id The internal identifier of the expenditure
18 * @rep:paraminfo {@rep:required}
19 * @param X_Incurred_By_Person_Id The identifier of the employee who submitted expenditure
20 * @rep:paraminfo {@rep:required}
21 * @param X_Expenditure_End_Date The ending date of the expenditure period
22 * @rep:paraminfo {@rep:required}
23 * @param X_Exp_Class_Code Identifer of expenditure type, either (OT for timesheets or OE for expense reports)
24 * @rep:paraminfo {@rep:required}
25 * @param X_Amount Amount of the expenditure. The value must be "hours" if the value of X_EXP_CLASS_CODE is OT. For other expenditure types the value can be "P"T or "dollars"
26 * @rep:paraminfo {@rep:required}
27 * @param X_Approver_Id Identifier of the employee approving the expenditure
28 * @rep:paraminfo {@rep:required}
29 * @param X_Routed_To_Mode Responsibility of approving employee(SUPERVISOR or ALL)
30 * @rep:paraminfo {@rep:required}
31 * @param P_Timecard_Table The entire timecard in PL/SQL table format (used when this procedure is called from Oracle Time and Labor)
32 * @rep:paraminfo {@rep:required}
33 * @param P_Module Application calling this expenditure. (OTL for Oracle Time and Labor)
34 * @rep:paraminfo {@rep:required}
35 * @param X_Status Status indicating whether an error occurred. The valid values are =0 (Success), <0 OR >0 (Application Error)
36 * @rep:paraminfo {@rep:required}
37 * @param X_Application_Id Short name of application defined in AOL (PA for Oracle Projects)
38 * @rep:paraminfo {@rep:required}
39 * @param X_Message_Code Message Code
40 * @rep:paraminfo {@rep:required}
41 * @param X_Token_1 Message token used in warning messages
42 * @rep:paraminfo {@rep:required}
43 * @param X_Token_2 Message token used in warning messages
44 * @rep:paraminfo {@rep:required}
45 * @param X_Token_3 Message token used in warning messages
46 * @rep:paraminfo {@rep:required}
47 * @param X_Token_4 Message token used in warning messages
48 * @rep:paraminfo {@rep:required}
49 * @param X_Token_5 Message token used in warning messages
50 * @rep:paraminfo {@rep:required}
51 * @rep:scope public
52 * @rep:lifecycle active
53 * @rep:displayname Check Approval Extension
54 * @rep:compatibility S
55 */
56
57 dummy Pa_Otc_Api.Timecard_Table;
58
59 Procedure check_approval
60 ( X_Expenditure_Id In Number,
61 X_Incurred_By_Person_Id In Number,
62 X_Expenditure_End_Date In Date,
63 X_Exp_Class_Code In Varchar2,
64 X_Amount In Number,
65 X_Approver_Id In Number,
66 X_Routed_To_Mode In Varchar2,
67 P_Timecard_Table IN Pa_Otc_Api.Timecard_Table Default PA_CLIENT_EXTN_RTE.dummy,
68 P_Module IN VARCHAR2 DEFAULT NULL,
69 X_Status Out NOCOPY Number,
70 X_Application_Id Out NOCOPY Varchar2,
71 X_Message_Code Out NOCOPY Varchar2,
72 X_Token_1 Out NOCOPY Varchar2,
73 X_Token_2 Out NOCOPY Varchar2,
74 X_Token_3 Out NOCOPY Varchar2,
75 X_Token_4 Out NOCOPY Varchar2,
76 X_Token_5 Out NOCOPY Varchar2 );
77
78 end PA_CLIENT_EXTN_RTE ;