1 package PA_CLIENT_EXTN_PTE as
2 -- $Header: PAXPTEES.pls 120.3 2006/07/25 19:39:54 skannoji noship $
3 /*#
4 * This extension contains procedures that you can use to define conditions under which expense reports are approved automatically.
5 * @rep:scope public
6 * @rep:product PA
7 * @rep:lifecycle active
8 * @rep:displayname AutoApproval
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 dummy Pa_Otc_Api.Timecard_Table;
16
17 -- Added a parameter to Check_Time_Exp_Proj_User to handle admin entry
18 -- in Web Expenses
19 /*#
20 * You can use this procedure to return the AutoApproval profile option value defined for the user.
21 * @param X_person_id Identifier of the person.
22 * @param X_fnd_user_id Identifier of the FND user.
23 * @param X_approved Value of the AutoApproval profile option.
24 * @rep:paraminfo {@rep:required}
25 * @param X_msg_text Message text.
26 * @rep:paraminfo {@rep:required}
27 * @rep:scope public
28 * @rep:lifecycle active
29 * @rep:displayname Check Time Expense Project User
30 * @rep:compatibility S
31 */
32 PROCEDURE Check_Time_Exp_Proj_User(X_person_id IN NUMBER DEFAULT NULL,
33 X_fnd_user_id IN NUMBER DEFAULT NULL,
34 X_approved IN OUT NOCOPY VARCHAR2,
35 X_msg_text OUT NOCOPY VARCHAR2 );
36
37
38 -- This Procedure can be customized to provide any additional validation that
39 -- might be required for a user .
40 -- If no changes are made, this procedure will return the value as set
41 -- in the profile option
42 /*#
43 * This API contains the default logic to read the values of the AutoApproval profile options.
44 * @param X_source The source of the expenditure
45 * @rep:paraminfo {@rep:required}
46 * @param X_exp_class_code The expenditure Class(OT for timecards and OE for expense reports)
47 * @param X_txn_id System-generated identifier of the expenditure.
48 * @param X_exp_ending_date Ending date of the expenditure week.
49 * @param X_person_id The identifier for the employee transcation.
50 * @param P_Timecard_table Table of expenditure items included on the timecard.
51 * @param P_module The module calling the procedure (for example, Self-Service Time or Oracle Time and Labor).
52 * @param X_approved Value of the AutoApproval profile option
53 * @rep:paraminfo {@rep:required}
54 * @rep:scope public
55 * @rep:lifecycle active
56 * @rep:displayname Get Expenditure Auto Approval
57 * @rep:compatibility S
58 */
59 PROCEDURE Get_Exp_AutoApproval (X_source IN VARCHAR2,
60 X_exp_class_code IN VARCHAR2 DEFAULT NULL,
61 X_txn_id IN NUMBER DEFAULT NULL,
62 X_exp_ending_date IN DATE DEFAULT NULL,
63 X_person_id IN NUMBER DEFAULT NULL,
64 P_Timecard_Table IN Pa_Otc_Api.Timecard_Table DEFAULT PAGTCX.dummy,
65 P_Module IN VARCHAR2 DEFAULT NULL,
66 X_approved IN OUT NOCOPY VARCHAR2);
67
68 -- This procedure can be customized to provide any additional
69 -- validations that might be required. If no changes are made, this procedure
70 -- will return the value as set in the profile option.
71
72 end PA_CLIENT_EXTN_PTE;