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.

[Home] [Help]

APPS.PA_COST_RATE_PUB dependencies on PA_ORG_LABOR_SCH_RULE

Line 32: ,x_org_labor_sch_rule_id OUT NOCOPY pa_org_labor_sch_rule.org_labor_sch_rule_id%TYPE

28: ,x_organization_id IN OUT NOCOPY pa_expenditures_all.incurred_by_organization_id%TYPE
29: ,x_cost_rate OUT NOCOPY pa_bill_rates_all.rate%TYPE
30: ,x_start_date_active OUT NOCOPY date
31: ,x_end_date_active OUT NOCOPY date
32: ,x_org_labor_sch_rule_id OUT NOCOPY pa_org_labor_sch_rule.org_labor_sch_rule_id%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

Line 38: ,x_acct_exch_rate OUT NOCOPY pa_org_labor_sch_rule.acct_exchange_rate%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
42: ,x_err_code OUT NOCOPY varchar2

Line 526: ,x_org_labor_sch_rule_id IN OUT NOCOPY pa_org_labor_sch_rule.org_labor_sch_rule_id%TYPE

522: ,p_person_id IN pa_expenditures_all.incurred_by_person_id%TYPE
523: ,p_job_id IN pa_expenditure_items_all.job_id%TYPE
524: ,p_txn_date IN pa_expenditure_items_all.expenditure_item_date%TYPE
525: ,p_calling_module IN varchar2 default 'STAFFED'
526: ,x_org_labor_sch_rule_id IN OUT NOCOPY pa_org_labor_sch_rule.org_labor_sch_rule_id%TYPE
527: ,x_costing_rule IN OUT NOCOPY pa_compensation_rule_sets.compensation_rule_set%TYPE
528: ,x_rate_sch_id IN OUT NOCOPY pa_std_bill_rate_schedules.bill_rate_sch_id%TYPE
529: ,x_ot_project_id IN OUT NOCOPY pa_projects_all.project_id%TYPE
530: ,x_ot_task_id IN OUT NOCOPY pa_tasks.task_id%TYPE

Line 544: l_org_labor_sch_rule_id pa_org_labor_sch_rule.org_labor_sch_rule_id%TYPE;

540:
541: l_debug_mode VARCHAR2(1) := 'Y';
542: l_stage VARCHAR2(500);
543:
544: l_org_labor_sch_rule_id pa_org_labor_sch_rule.org_labor_sch_rule_id%TYPE;
545: l_rate_sch_id pa_std_bill_rate_schedules.bill_rate_sch_id%TYPE;
546: l_costing_rule pa_compensation_rule_sets.compensation_rule_set%TYPE;
547: l_ot_project_id pa_projects_all.project_id%TYPE;
548: l_ot_task_id pa_tasks.task_id%TYPE;

Line 549: l_acct_rate_date_code pa_org_labor_sch_rule.acct_rate_date_code%TYPE;

545: l_rate_sch_id pa_std_bill_rate_schedules.bill_rate_sch_id%TYPE;
546: l_costing_rule pa_compensation_rule_sets.compensation_rule_set%TYPE;
547: l_ot_project_id pa_projects_all.project_id%TYPE;
548: l_ot_task_id pa_tasks.task_id%TYPE;
549: l_acct_rate_date_code pa_org_labor_sch_rule.acct_rate_date_code%TYPE;
550: l_acct_rate_type pa_org_labor_sch_rule.acct_rate_type%TYPE;
551: l_acct_exch_rate pa_org_labor_sch_rule.acct_exchange_rate%TYPE;
552:
553: cursor assignment( p_org_id IN pa_implementations_all.org_id%TYPE

Line 550: l_acct_rate_type pa_org_labor_sch_rule.acct_rate_type%TYPE;

546: l_costing_rule pa_compensation_rule_sets.compensation_rule_set%TYPE;
547: l_ot_project_id pa_projects_all.project_id%TYPE;
548: l_ot_task_id pa_tasks.task_id%TYPE;
549: l_acct_rate_date_code pa_org_labor_sch_rule.acct_rate_date_code%TYPE;
550: l_acct_rate_type pa_org_labor_sch_rule.acct_rate_type%TYPE;
551: l_acct_exch_rate pa_org_labor_sch_rule.acct_exchange_rate%TYPE;
552:
553: cursor assignment( p_org_id IN pa_implementations_all.org_id%TYPE
554: ,p_organization_id IN pa_expenditures_all.incurred_by_organization_id%TYPE

Line 551: l_acct_exch_rate pa_org_labor_sch_rule.acct_exchange_rate%TYPE;

547: l_ot_project_id pa_projects_all.project_id%TYPE;
548: l_ot_task_id pa_tasks.task_id%TYPE;
549: l_acct_rate_date_code pa_org_labor_sch_rule.acct_rate_date_code%TYPE;
550: l_acct_rate_type pa_org_labor_sch_rule.acct_rate_type%TYPE;
551: l_acct_exch_rate pa_org_labor_sch_rule.acct_exchange_rate%TYPE;
552:
553: cursor assignment( p_org_id IN pa_implementations_all.org_id%TYPE
554: ,p_organization_id IN pa_expenditures_all.incurred_by_organization_id%TYPE
555: ,p_person_id IN pa_expenditures_all.incurred_by_person_id%TYPE

Line 570: from pa_org_labor_sch_rule assign

566: ,assign.overtime_task_id
567: ,assign.acct_rate_date_code
568: ,assign.acct_rate_type
569: ,assign.acct_exchange_rate
570: from pa_org_labor_sch_rule assign
571: ,pa_org_hierarchy_denorm hier
572: ,pa_implementations imp
573: where hier.child_organization_id = p_organization_id
574: and imp.exp_org_structure_version_id=hier.org_hierarchy_version_id

Line 708: from pa_org_labor_sch_rule assign

704: ,g_ou_ot_task_id
705: ,g_ou_acct_rate_date_code
706: ,g_ou_acct_rate_type
707: ,g_ou_acct_exch_rate
708: from pa_org_labor_sch_rule assign
709: where assign.organization_id is null
710: and trunc(p_txn_date) between trunc(assign.start_date_active)
711: and trunc(nvl(assign.end_date_active,p_txn_date))
712: and nvl(assign.org_id,-99) = nvl(p_org_id, -99);

Line 821: l_org_labor_sch_rule_id pa_org_labor_sch_rule.org_labor_sch_rule_id%type;

817: l_cost_rate pa_bill_rates_all.rate%type;
818: l_acct_cost_rate pa_bill_rates_all.rate%type;
819: l_start_date_active date;
820: l_end_date_active date;
821: l_org_labor_sch_rule_id pa_org_labor_sch_rule.org_labor_sch_rule_id%type;
822: l_rate_sch_id pa_std_bill_rate_schedules.bill_rate_sch_id%type;
823: l_override_type pa_compensation_details.override_type%type;
824: l_cost_rate_curr_code pa_compensation_details.cost_rate_currency_code%type;
825: l_acct_rate_type pa_compensation_details.acct_rate_type%type;

Line 991: l_org_labor_sch_rule_id pa_org_labor_sch_rule.org_labor_sch_rule_id%type;

987: l_costing_rule pa_compensation_details_all.compensation_rule_set%type;
988: l_cost_rate pa_bill_rates_all.rate%type;
989: l_start_date_active date;
990: l_end_date_active date;
991: l_org_labor_sch_rule_id pa_org_labor_sch_rule.org_labor_sch_rule_id%type;
992: l_rate_sch_id pa_std_bill_rate_schedules.bill_rate_sch_id%type;
993: l_override_type pa_compensation_details.override_type%type;
994: l_cost_rate_curr_code pa_compensation_details.cost_rate_currency_code%type;
995: l_acct_rate_type pa_compensation_details.acct_rate_type%type;