APPS.PA_BL_UTILS dependencies on PA_EXPENDITURE_ITEMS_ALL

Line 17: (v_expenditure_item_id IN pa_expenditure_items_all.expenditure_item_id%TYPE,

13: -- v_person_id - Incurred by Person ID
14: -- Return : either the supplier name or the employee full name.
15: --===========================================================================
16: FUNCTION get_supplier_or_emp_name
17: (v_expenditure_item_id IN pa_expenditure_items_all.expenditure_item_id%TYPE,
18: v_sys_linkage_func IN pa_expenditure_items_all.system_linkage_function%TYPE,
19: v_creation_date IN pa_expenditure_items_all.expenditure_item_date%TYPE,
20: v_person_id IN pa_expenditures_all.incurred_by_person_id%TYPE)
21: RETURN VARCHAR2

Line 18: v_sys_linkage_func IN pa_expenditure_items_all.system_linkage_function%TYPE,

14: -- Return : either the supplier name or the employee full name.
15: --===========================================================================
16: FUNCTION get_supplier_or_emp_name
17: (v_expenditure_item_id IN pa_expenditure_items_all.expenditure_item_id%TYPE,
18: v_sys_linkage_func IN pa_expenditure_items_all.system_linkage_function%TYPE,
19: v_creation_date IN pa_expenditure_items_all.expenditure_item_date%TYPE,
20: v_person_id IN pa_expenditures_all.incurred_by_person_id%TYPE)
21: RETURN VARCHAR2
22: IS

Line 19: v_creation_date IN pa_expenditure_items_all.expenditure_item_date%TYPE,

15: --===========================================================================
16: FUNCTION get_supplier_or_emp_name
17: (v_expenditure_item_id IN pa_expenditure_items_all.expenditure_item_id%TYPE,
18: v_sys_linkage_func IN pa_expenditure_items_all.system_linkage_function%TYPE,
19: v_creation_date IN pa_expenditure_items_all.expenditure_item_date%TYPE,
20: v_person_id IN pa_expenditures_all.incurred_by_person_id%TYPE)
21: RETURN VARCHAR2
22: IS
23: v_emp_name per_people_f.full_name%TYPE := NULL;

Line 83: (v_sys_linkage_fn IN pa_expenditure_items_all.system_linkage_function%TYPE,

79: -- v_incurred_by_orgid - Incurred by Organization ID
80: -- Return : organization name
81: --===========================================================================
82: FUNCTION get_organization_name
83: (v_sys_linkage_fn IN pa_expenditure_items_all.system_linkage_function%TYPE,
84: v_non_labor_orgid IN pa_expenditure_items_all.organization_id%TYPE,
85: v_override_orgid IN pa_expenditure_items_all.override_to_organization_id%TYPE,
86: v_incurred_by_orgid IN pa_expenditures_all.incurred_by_organization_id%TYPE)
87: RETURN VARCHAR2

Line 84: v_non_labor_orgid IN pa_expenditure_items_all.organization_id%TYPE,

80: -- Return : organization name
81: --===========================================================================
82: FUNCTION get_organization_name
83: (v_sys_linkage_fn IN pa_expenditure_items_all.system_linkage_function%TYPE,
84: v_non_labor_orgid IN pa_expenditure_items_all.organization_id%TYPE,
85: v_override_orgid IN pa_expenditure_items_all.override_to_organization_id%TYPE,
86: v_incurred_by_orgid IN pa_expenditures_all.incurred_by_organization_id%TYPE)
87: RETURN VARCHAR2
88: IS

Line 85: v_override_orgid IN pa_expenditure_items_all.override_to_organization_id%TYPE,

81: --===========================================================================
82: FUNCTION get_organization_name
83: (v_sys_linkage_fn IN pa_expenditure_items_all.system_linkage_function%TYPE,
84: v_non_labor_orgid IN pa_expenditure_items_all.organization_id%TYPE,
85: v_override_orgid IN pa_expenditure_items_all.override_to_organization_id%TYPE,
86: v_incurred_by_orgid IN pa_expenditures_all.incurred_by_organization_id%TYPE)
87: RETURN VARCHAR2
88: IS
89: v_org_id hr_all_organization_units_tl.organization_id%TYPE;