DBA Data[Home] [Help]

APPS.PA_COST_RATE_PUB dependencies on PA_IMPLEMENTATIONS_ALL

Line 37: ,x_acct_rate_date_code OUT NOCOPY pa_implementations_all.acct_rate_date_code%TYPE

33: ,x_costing_rule OUT NOCOPY pa_compensation_rule_sets.compensation_rule_set%TYPE
34: ,x_rate_sch_id OUT NOCOPY pa_std_bill_rate_schedules_all.bill_rate_sch_id%TYPE
35: ,x_cost_rate_curr_code OUT NOCOPY gl_sets_of_books.currency_code%TYPE
36: ,x_acct_rate_type OUT NOCOPY pa_expenditure_items_all.acct_rate_type%TYPE
37: ,x_acct_rate_date_code OUT NOCOPY pa_implementations_all.acct_rate_date_code%TYPE
38: ,x_acct_exch_rate OUT NOCOPY pa_org_labor_sch_rule.acct_exchange_rate%TYPE
39: ,x_ot_project_id OUT NOCOPY pa_projects_all.project_id%TYPE
40: ,x_ot_task_id OUT NOCOPY pa_tasks.task_id%TYPE
41: ,x_err_stage OUT NOCOPY number

Line 636: ( p_org_id IN pa_implementations_all.org_id%TYPE

632: raise;
633: end get_labor_rate;
634: ---------------------------------------------------------------------------------------------
635: PROCEDURE get_orgn_level_costing_info
636: ( p_org_id IN pa_implementations_all.org_id%TYPE
637: ,p_organization_id IN pa_expenditures_all.incurred_by_organization_id%TYPE
638: ,p_person_id IN pa_expenditures_all.incurred_by_person_id%TYPE
639: ,p_job_id IN pa_expenditure_items_all.job_id%TYPE
640: ,p_txn_date IN pa_expenditure_items_all.expenditure_item_date%TYPE

Line 651: ,x_acct_rate_date_code IN OUT NOCOPY pa_implementations_all.acct_rate_date_code%TYPE

647: ,x_base_hours IN OUT NOCOPY pa_org_labor_sch_rule.base_hours%TYPE /* 12.2 payroll intg .. bug 11811475 */
648: ,x_rbc_elem_type_id IN OUT NOCOPY pa_org_labor_sch_rule.rbc_element_type_id%TYPE
649: ,x_cost_rate_curr_code IN OUT NOCOPY pa_expenditure_items_all.denom_currency_code%TYPE
650: ,x_acct_rate_type IN OUT NOCOPY pa_expenditure_items_all.acct_rate_type%TYPE
651: ,x_acct_rate_date_code IN OUT NOCOPY pa_implementations_all.acct_rate_date_code%TYPE
652: ,x_acct_exch_rate IN OUT NOCOPY pa_compensation_details_all.acct_exchange_rate%TYPE
653: ,x_err_stage IN OUT NOCOPY number
654: ,x_err_code IN OUT NOCOPY varchar2
655: ,P_Called_From IN varchar2 DEFAULT 'O' /* Added for 3405326 */

Line 676: cursor org_costing_rule( p_org_id IN pa_implementations_all.org_id%TYPE

672: l_rate_source_code pa_compensation_rule_sets.rate_source_code%TYPE;
673: l_base_hours pa_org_labor_sch_rule.base_hours%TYPE;
674: l_rbc_elem_type_id pa_org_labor_sch_rule.rbc_element_type_id%TYPE;
675:
676: cursor org_costing_rule( p_org_id IN pa_implementations_all.org_id%TYPE
677: ,p_organization_id IN pa_expenditures_all.incurred_by_organization_id%TYPE
678: ,p_person_id IN pa_expenditures_all.incurred_by_person_id%TYPE
679: ,p_job_id IN pa_expenditure_items_all.job_id%TYPE
680: ,p_txn_date IN pa_expenditure_items_all.expenditure_item_date%TYPE

Line 707: cursor assignment( p_org_id IN pa_implementations_all.org_id%TYPE

703: and trunc(p_txn_date) between trunc(assign.start_date_active)
704: and trunc(nvl(assign.end_date_active,p_txn_date));
705:
706:
707: cursor assignment( p_org_id IN pa_implementations_all.org_id%TYPE
708: ,p_organization_id IN pa_expenditures_all.incurred_by_organization_id%TYPE
709: ,p_person_id IN pa_expenditures_all.incurred_by_person_id%TYPE
710: ,p_job_id IN pa_expenditure_items_all.job_id%TYPE
711: ,p_txn_date IN pa_expenditure_items_all.expenditure_item_date%TYPE