135:
136: END;
137:
138: PROCEDURE GetExpenditureTypeMapping(
139: P_ExpenseType IN AP_EXPENSE_REPORT_PARAMS.parameter_id%TYPE,
140: P_PAExpenditureType OUT NOCOPY AP_EXPENSE_REPORT_PARAMS.pa_expenditure_type%TYPE
141: )
142: -- Returns the expenditure type mapped to the expense type
143: -- Exception generated if cannot find P_ExpenseType
136: END;
137:
138: PROCEDURE GetExpenditureTypeMapping(
139: P_ExpenseType IN AP_EXPENSE_REPORT_PARAMS.parameter_id%TYPE,
140: P_PAExpenditureType OUT NOCOPY AP_EXPENSE_REPORT_PARAMS.pa_expenditure_type%TYPE
141: )
142: -- Returns the expenditure type mapped to the expense type
143: -- Exception generated if cannot find P_ExpenseType
144:
167: P_PAProjectNumber IN OUT NOCOPY PA_PROJECTS_EXPEND_V.project_number%TYPE,
168: P_PAProjectID IN OUT NOCOPY PA_PROJECTS_EXPEND_V.project_id%TYPE,
169: P_PATaskNumber IN OUT NOCOPY PA_TASKS_EXPEND_V.task_number%TYPE,
170: P_PATaskID IN OUT NOCOPY PA_TASKS_EXPEND_V.task_id%TYPE,
171: P_PAExpenditureType IN OUT NOCOPY AP_EXPENSE_REPORT_PARAMS.pa_expenditure_type%TYPE )
172:
173: -- Populates the ProjectNumber, TaskNumber
174: -- Assumes that Project and Task Number are filled in already
175: -- Reports errors that would not be caught by core validation
238: P_PAProjectName OUT NOCOPY PA_PROJECTS_EXPEND_V.project_name%TYPE,
239: P_PATaskNumber IN OUT NOCOPY PA_TASKS_EXPEND_V.task_number%TYPE,
240: P_PATaskID OUT NOCOPY PA_TASKS_EXPEND_V.task_id%TYPE,
241: P_PATaskName OUT NOCOPY PA_TASKS_EXPEND_V.task_name%TYPE,
242: P_PAExpenditureType OUT NOCOPY AP_EXPENSE_REPORT_PARAMS.pa_expenditure_type%TYPE,
243: P_ExpenseType IN AP_EXPENSE_REPORT_PARAMS.parameter_id%TYPE
244: )
245:
246: -- Populates the ProjectID, TaskID, and Expenditure Type
239: P_PATaskNumber IN OUT NOCOPY PA_TASKS_EXPEND_V.task_number%TYPE,
240: P_PATaskID OUT NOCOPY PA_TASKS_EXPEND_V.task_id%TYPE,
241: P_PATaskName OUT NOCOPY PA_TASKS_EXPEND_V.task_name%TYPE,
242: P_PAExpenditureType OUT NOCOPY AP_EXPENSE_REPORT_PARAMS.pa_expenditure_type%TYPE,
243: P_ExpenseType IN AP_EXPENSE_REPORT_PARAMS.parameter_id%TYPE
244: )
245:
246: -- Populates the ProjectID, TaskID, and Expenditure Type
247: -- Assumes that Project and Task Number are filled in already