DBA Data[Home] [Help]

APPS.PA_COST_RATE_PUB dependencies on PA_BILL_RATES_ALL

Line 24: g_rt_cost_rate pa_bill_rates_all.rate%TYPE;

20: * Contains information about the last processed record by the api get_labor_rate.
21: */
22: g_rt_calling_module varchar2(50);
23: g_rt_organization_id pa_expenditures_all.incurred_by_organization_id%TYPE;
24: g_rt_cost_rate pa_bill_rates_all.rate%TYPE;
25: g_rt_start_date_active date;
26: g_rt_end_date_active date;
27: g_rt_org_labor_sch_rule_id pa_org_labor_sch_rule.org_labor_sch_rule_id%TYPE;
28: g_rt_costing_rule pa_compensation_rule_sets.compensation_rule_set%TYPE;

Line 30: g_rt_cost_rate_curr_code pa_bill_rates_all.rate_currency_code%TYPE;

26: g_rt_end_date_active date;
27: g_rt_org_labor_sch_rule_id pa_org_labor_sch_rule.org_labor_sch_rule_id%TYPE;
28: g_rt_costing_rule pa_compensation_rule_sets.compensation_rule_set%TYPE;
29: g_rt_rate_sch_id pa_std_bill_rate_schedules_all.bill_rate_sch_id%TYPE;
30: g_rt_cost_rate_curr_code pa_bill_rates_all.rate_currency_code%TYPE;
31: g_rt_acct_rate_type pa_org_labor_sch_rule.acct_rate_type%TYPE;
32: g_rt_acct_rate_date_code pa_org_labor_sch_rule.acct_rate_date_code%TYPE;
33: g_rt_acct_exch_rate pa_org_labor_sch_rule.acct_exchange_rate%TYPE;
34: g_rt_ot_project_id pa_projects_all.project_id%TYPE;

Line 38: g_rt_person_id pa_bill_rates_all.person_id%TYPE;

34: g_rt_ot_project_id pa_projects_all.project_id%TYPE;
35: g_rt_ot_task_id pa_tasks.task_id%TYPE;
36: g_rt_err_stage number;
37: g_rt_err_code varchar2(50);
38: g_rt_person_id pa_bill_rates_all.person_id%TYPE;
39: g_rt_job_id pa_bill_rates_all.job_id%TYPE;
40: g_base_hours pa_org_labor_sch_rule.base_hours%TYPE;
41: g_rbc_elem_type_id pa_org_labor_sch_rule.rbc_element_type_id%TYPE;
42: g_rt_sch_type pa_std_bill_rate_schedules_all.schedule_type%TYPE;

Line 39: g_rt_job_id pa_bill_rates_all.job_id%TYPE;

35: g_rt_ot_task_id pa_tasks.task_id%TYPE;
36: g_rt_err_stage number;
37: g_rt_err_code varchar2(50);
38: g_rt_person_id pa_bill_rates_all.person_id%TYPE;
39: g_rt_job_id pa_bill_rates_all.job_id%TYPE;
40: g_base_hours pa_org_labor_sch_rule.base_hours%TYPE;
41: g_rbc_elem_type_id pa_org_labor_sch_rule.rbc_element_type_id%TYPE;
42: g_rt_sch_type pa_std_bill_rate_schedules_all.schedule_type%TYPE;
43:

Line 70: ,x_cost_rate OUT NOCOPY pa_bill_rates_all.rate%TYPE

66: ,p_calling_module IN varchar2 default 'STAFFED'
67: ,p_org_id IN pa_expenditures_all.org_id%TYPE default NULL /*2879644*/
68: ,x_job_id IN OUT NOCOPY pa_expenditure_items_all.job_id%TYPE
69: ,x_organization_id IN OUT NOCOPY pa_expenditures_all.incurred_by_organization_id%TYPE
70: ,x_cost_rate OUT NOCOPY pa_bill_rates_all.rate%TYPE
71: ,x_start_date_active OUT NOCOPY date
72: ,x_end_date_active OUT NOCOPY date
73: ,x_org_labor_sch_rule_id OUT NOCOPY pa_org_labor_sch_rule.org_labor_sch_rule_id%TYPE
74: ,x_costing_rule OUT NOCOPY pa_compensation_rule_sets.compensation_rule_set%TYPE

Line 112: G_EMP_COST_RATE pa_bill_rates_all.rate%type;

108: );
109: -- Labor Cost Rate Reports
110: --Globals for the Cache values.
111: G_EMP_RATE_RULE pa_compensation_rule_sets.compensation_rule_set%type;
112: G_EMP_COST_RATE pa_bill_rates_all.rate%type;
113: G_EMP_ACCT_COST_RATE pa_bill_rates_all.rate%type;
114: G_EMP_RATE_CURR pa_expenditure_items_all.acct_currency_code%type;
115: G_EMP_RATE_START_DATE date;
116: G_EMP_RATE_END_DATE date;

Line 113: G_EMP_ACCT_COST_RATE pa_bill_rates_all.rate%type;

109: -- Labor Cost Rate Reports
110: --Globals for the Cache values.
111: G_EMP_RATE_RULE pa_compensation_rule_sets.compensation_rule_set%type;
112: G_EMP_COST_RATE pa_bill_rates_all.rate%type;
113: G_EMP_ACCT_COST_RATE pa_bill_rates_all.rate%type;
114: G_EMP_RATE_CURR pa_expenditure_items_all.acct_currency_code%type;
115: G_EMP_RATE_START_DATE date;
116: G_EMP_RATE_END_DATE date;
117:

Line 156: RETURN pa_bill_rates_all.rate%type;

152: ,P_Effective_Date IN date default SYSDATE
153: ,P_Rate_Type IN varchar2
154: ,P_Called_From IN varchar2 DEFAULT 'O' /* Added for 3405326 */
155: )
156: RETURN pa_bill_rates_all.rate%type;
157: /*----------------------------------------------------------------------------*/
158: -- Start of Comments
159: -- API name : GetEmpCostRateInfo
160: -- Type : Public Function