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:
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
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: );
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: