eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PA_ACC_GEN_WF_PKG dependencies on PO_VENDORS

Line 23: p_vendor_id IN po_vendors.vendor_id%type,

19: PROCEDURE wf_acc_derive_params (
20: p_project_id IN pa_projects_all.project_id%TYPE,
21: p_task_id IN pa_tasks.task_id%TYPE,
22: p_expenditure_type IN pa_expenditure_types.expenditure_type%TYPE,
23: p_vendor_id IN po_vendors.vendor_id%type,
24: p_expenditure_organization_id IN hr_organization_units.organization_id%TYPE,
25: p_expenditure_item_date IN
26: pa_expenditure_items_all.expenditure_item_date%TYPE,
27: x_class_code OUT NOCOPY pa_class_codes.class_code%TYPE,

Line 46: x_vendor_type OUT NOCOPY po_vendors.vendor_type_lookup_code%TYPE)

42: x_top_task_id OUT NOCOPY pa_tasks.task_id%TYPE,
43: x_top_task_number OUT NOCOPY pa_tasks.task_number%TYPE,
44: x_vendor_employee_id OUT NOCOPY per_people_f.person_id%TYPE,
45: x_vendor_employee_number OUT NOCOPY per_people_f.employee_number%TYPE,
46: x_vendor_type OUT NOCOPY po_vendors.vendor_type_lookup_code%TYPE)
47: AS
48:
49: l_person_effective_date DATE;
50:

Line 84: po_vendors VEND,

80: x_vendor_employee_id,
81: x_vendor_employee_number,
82: x_vendor_type
83: FROM
84: po_vendors VEND,
85: per_people_f EMP
86: WHERE
87: VEND.vendor_id = p_vendor_id
88: AND VEND.employee_id = EMP.person_id (+)

Line 101: po_vendors VEND

97: INTO
98: x_vendor_employee_id,
99: x_vendor_type
100: FROM
101: po_vendors VEND
102: WHERE
103: VEND.vendor_id = p_vendor_id;
104:
105: IF x_vendor_employee_id IS NOT NULL

Line 182: p_vendor_id IN po_vendors.vendor_id%type,

178: PROCEDURE wf_acc_derive_er_params (
179: p_project_id IN pa_projects_all.project_id%TYPE,
180: p_task_id IN pa_tasks.task_id%TYPE,
181: p_expenditure_type IN pa_expenditure_types.expenditure_type%TYPE,
182: p_vendor_id IN po_vendors.vendor_id%type,
183: p_expenditure_organization_id IN hr_organization_units.organization_id%TYPE,
184: p_expenditure_item_date IN
185: pa_expenditure_items_all.expenditure_item_date%TYPE,
186: p_calling_module IN VARCHAR2,

Line 208: x_vendor_type OUT NOCOPY po_vendors.vendor_type_lookup_code%TYPE,

204: x_task_service_type OUT NOCOPY pa_tasks.service_type_code%TYPE,
205: x_top_task_id OUT NOCOPY pa_tasks.task_id%TYPE,
206: x_top_task_number OUT NOCOPY pa_tasks.task_number%TYPE,
207: x_employee_number OUT NOCOPY per_people_f.employee_number%TYPE,
208: x_vendor_type OUT NOCOPY po_vendors.vendor_type_lookup_code%TYPE,
209: x_person_type OUT NOCOPY VARCHAR2 )
210: AS
211:
212: l_person_effective_date DATE;

Line 244: po_vendors VEND

240: VEND.vendor_type_lookup_code VENDOR_TYPE
241: INTO
242: x_vendor_type
243: FROM
244: po_vendors VEND
245: WHERE
246: VEND.vendor_id = p_vendor_id ;
247: END IF;
248:

Line 747: p_vendor_id IN po_vendors.vendor_id%type,

743: (
744: p_project_id IN pa_projects_all.project_id%TYPE,
745: p_task_id IN pa_tasks.task_id%TYPE,
746: p_expenditure_type IN pa_expenditure_types.expenditure_type%TYPE,
747: p_vendor_id IN po_vendors.vendor_id%type,
748: p_expenditure_organization_id IN hr_organization_units.organization_id%TYPE,
749: p_expenditure_item_date IN
750: pa_expenditure_items_all.expenditure_item_date%TYPE,
751: p_billable_flag IN pa_tasks.billable_flag%TYPE,

Line 829: l_vendor_type po_vendors.vendor_type_lookup_code%TYPE;

825: l_task_service_type pa_tasks.service_type_code%TYPE;
826: l_top_task_id pa_tasks.task_id%TYPE;
827: l_top_task_number pa_tasks.task_number%TYPE;
828: l_employee_number per_people_f.employee_number%TYPE;
829: l_vendor_type po_vendors.vendor_type_lookup_code%TYPE;
830: l_error_message VARCHAR2(1000) := '';
831: l_org_id hr_organization_units.organization_id %TYPE; -- Workflow Enhancement
832:
833: l_code_combination BOOLEAN;

Line 1544: p_vendor_id IN po_vendors.vendor_id%type,

1540: (
1541: p_project_id IN pa_projects_all.project_id%TYPE,
1542: p_task_id IN pa_tasks.task_id%TYPE,
1543: p_expenditure_type IN pa_expenditure_types.expenditure_type%TYPE,
1544: p_vendor_id IN po_vendors.vendor_id%type,
1545: p_expenditure_organization_id IN hr_organization_units.organization_id%TYPE,
1546: p_expenditure_item_date IN
1547: pa_expenditure_items_all.expenditure_item_date%TYPE,
1548: p_billable_flag IN pa_tasks.billable_flag%TYPE,

Line 1625: l_vendor_type po_vendors.vendor_type_lookup_code%TYPE;

1621: l_top_task_id pa_tasks.task_id%TYPE;
1622: l_top_task_number pa_tasks.task_number%TYPE;
1623: l_vendor_employee_id per_people_f.person_id%TYPE;
1624: l_vendor_employee_number per_people_f.employee_number%TYPE;
1625: l_vendor_type po_vendors.vendor_type_lookup_code%TYPE;
1626: l_error_message VARCHAR2(1000) :='';
1627: l_accounting_date DATE;
1628: l_org_id hr_organization_units.organization_id %TYPE; -- Workflow Enhancement
1629:

Line 2333: l_vendor_id po_vendors.vendor_id%type;

2329:
2330: l_project_id pa_projects_all.project_id%TYPE;
2331: l_task_id pa_tasks.task_id%TYPE;
2332: l_expenditure_type pa_expenditure_types.expenditure_type%TYPE;
2333: l_vendor_id po_vendors.vendor_id%type;
2334: l_expenditure_organization_id hr_organization_units.organization_id%TYPE;
2335: l_expenditure_item_date pa_expenditure_items_all.expenditure_item_date%TYPE;
2336: l_billable_flag pa_tasks.billable_flag%TYPE;
2337: l_chart_of_accounts_id NUMBER;