1 PACKAGE AP_WEB_PROJECT_PKG AS
2 /* $Header: apwprojs.pls 120.4 2006/02/24 10:20:19 sbalaji ship $ */
3
4 PROCEDURE IsSessionProjectEnabled(
5 P_EmployeeID IN FND_USER.employee_id%TYPE,
6 P_FNDUserID IN FND_USER.user_id%TYPE,
7 P_Result OUT NOCOPY VARCHAR2);
8
9 PROCEDURE DerivePAInfoFromDatabase(
10 P_IsProjectEnabled IN VARCHAR2,
11 P_PAProjectNumber IN OUT NOCOPY PA_PROJECTS_EXPEND_V.project_number%TYPE,
12 P_PAProjectID IN OUT NOCOPY PA_PROJECTS_EXPEND_V.project_id%TYPE,
13 P_PATaskNumber IN OUT NOCOPY PA_TASKS_EXPEND_V.task_number%TYPE,
14 P_PATaskID IN OUT NOCOPY PA_TASKS_EXPEND_V.task_id%TYPE,
15 P_PAExpenditureType IN OUT NOCOPY AP_EXPENSE_REPORT_PARAMS.pa_expenditure_type%TYPE );
16
17
18 PROCEDURE DerivePAInfoFromUserInput(
19 P_IsProjectEnabled IN VARCHAR2,
20 P_PAProjectNumber IN OUT NOCOPY PA_PROJECTS_EXPEND_V.project_number%TYPE,
21 P_PAProjectID OUT NOCOPY PA_PROJECTS_EXPEND_V.project_id%TYPE,
22 P_PAProjectName OUT NOCOPY PA_PROJECTS_EXPEND_V.project_name%TYPE,
23 P_PATaskNumber IN OUT NOCOPY PA_TASKS_EXPEND_V.task_number%TYPE,
24 P_PATaskID OUT NOCOPY PA_TASKS_EXPEND_V.task_id%TYPE,
25 P_PATaskName OUT NOCOPY PA_TASKS_EXPEND_V.task_name%TYPE,
26 P_PAExpenditureType OUT NOCOPY AP_EXPENSE_REPORT_PARAMS.pa_expenditure_type%TYPE,
27 P_ExpenseType IN AP_EXPENSE_REPORT_PARAMS.parameter_id%TYPE
28 );
29
30 PROCEDURE ValidatePATransaction(
31 P_project_id IN NUMBER,
32 P_task_id IN NUMBER,
33 P_ei_date IN DATE,
34 P_expenditure_type IN VARCHAR2,
35 P_non_labor_resource IN VARCHAR2,
36 P_person_id IN NUMBER,
37 P_quantity IN NUMBER DEFAULT NULL,
38 P_denom_currency_code IN VARCHAR2 DEFAULT NULL,
39 P_acct_currency_code IN VARCHAR2 DEFAULT NULL,
40 P_denom_raw_cost IN NUMBER DEFAULT NULL,
41 P_acct_raw_cost IN NUMBER DEFAULT NULL,
42 P_acct_rate_type IN VARCHAR2 DEFAULT NULL,
43 P_acct_rate_date IN DATE DEFAULT NULL,
44 P_acct_exchange_rate IN NUMBER DEFAULT NULL ,
45 P_transfer_ei IN NUMBER DEFAULT NULL,
46 P_incurred_by_org_id IN NUMBER DEFAULT NULL,
47 P_nl_resource_org_id IN NUMBER DEFAULT NULL,
48 P_transaction_source IN VARCHAR2 DEFAULT NULL ,
49 P_calling_module IN VARCHAR2 DEFAULT NULL,
50 P_vendor_id IN NUMBER DEFAULT NULL,
51 P_entered_by_user_id IN NUMBER DEFAULT NULL,
52 P_attribute_category IN VARCHAR2 DEFAULT NULL,
53 P_attribute1 IN VARCHAR2 DEFAULT NULL,
54 P_attribute2 IN VARCHAR2 DEFAULT NULL,
55 P_attribute3 IN VARCHAR2 DEFAULT NULL,
56 P_attribute4 IN VARCHAR2 DEFAULT NULL,
57 P_attribute5 IN VARCHAR2 DEFAULT NULL,
58 P_attribute6 IN VARCHAR2 DEFAULT NULL,
59 P_attribute7 IN VARCHAR2 DEFAULT NULL,
60 P_attribute8 IN VARCHAR2 DEFAULT NULL,
61 P_attribute9 IN VARCHAR2 DEFAULT NULL,
62 P_attribute10 IN VARCHAR2 DEFAULT NULL,
63 P_attribute11 IN VARCHAR2 DEFAULT NULL,
64 P_attribute12 IN VARCHAR2 DEFAULT NULL,
65 P_attribute13 IN VARCHAR2 DEFAULT NULL,
66 P_attribute14 IN VARCHAR2 DEFAULT NULL,
67 P_attribute15 IN VARCHAR2 DEFAULT NULL,
68 P_msg_type OUT NOCOPY VARCHAR2,
69 P_msg_data OUT NOCOPY VARCHAR2,
70 P_billable_flag OUT NOCOPY VARCHAR2);
71
72 PROCEDURE GetExpenditureTypeMapping(
73 P_ExpenseType IN AP_EXPENSE_REPORT_PARAMS.parameter_id%TYPE,
74 P_PAExpenditureType OUT NOCOPY AP_EXPENSE_REPORT_PARAMS.pa_expenditure_type%TYPE);
75
76 ----------------------------------------------------------------------
77 FUNCTION IsGrantsEnabled RETURN VARCHAR2;
78
79 END AP_WEB_PROJECT_PKG;