DBA Data[Home] [Help]

APPS.PA_COST_RATE_PUB dependencies on PA_ORG_LABOR_SCH_RULE

Line 10: g_ou_org_labor_sch_rule_id pa_org_labor_sch_rule.org_labor_sch_rule_id%TYPE;

6: /*
7: * Contains information for OU level Schedule Assignment.
8: */
9: g_ou_id pa_implementations_all.org_id%TYPE;
10: g_ou_org_labor_sch_rule_id pa_org_labor_sch_rule.org_labor_sch_rule_id%TYPE;
11: g_ou_cost_rate_sch_id pa_std_bill_rate_schedules.bill_rate_sch_id%TYPE;
12: g_ou_labor_costing_rule pa_compensation_rule_sets.compensation_rule_set%TYPE;
13: g_ou_ot_project_id pa_projects_all.project_id%TYPE;
14: g_ou_ot_task_id pa_tasks.task_id%TYPE;

Line 15: g_ou_acct_rate_date_code pa_org_labor_sch_rule.acct_rate_date_code%TYPE;

11: g_ou_cost_rate_sch_id pa_std_bill_rate_schedules.bill_rate_sch_id%TYPE;
12: g_ou_labor_costing_rule pa_compensation_rule_sets.compensation_rule_set%TYPE;
13: g_ou_ot_project_id pa_projects_all.project_id%TYPE;
14: g_ou_ot_task_id pa_tasks.task_id%TYPE;
15: g_ou_acct_rate_date_code pa_org_labor_sch_rule.acct_rate_date_code%TYPE;
16: g_ou_acct_rate_type pa_org_labor_sch_rule.acct_rate_type%TYPE;
17: g_ou_acct_exch_rate pa_org_labor_sch_rule.acct_exchange_rate%TYPE;
18:
19: /*

Line 16: g_ou_acct_rate_type pa_org_labor_sch_rule.acct_rate_type%TYPE;

12: g_ou_labor_costing_rule pa_compensation_rule_sets.compensation_rule_set%TYPE;
13: g_ou_ot_project_id pa_projects_all.project_id%TYPE;
14: g_ou_ot_task_id pa_tasks.task_id%TYPE;
15: g_ou_acct_rate_date_code pa_org_labor_sch_rule.acct_rate_date_code%TYPE;
16: g_ou_acct_rate_type pa_org_labor_sch_rule.acct_rate_type%TYPE;
17: g_ou_acct_exch_rate pa_org_labor_sch_rule.acct_exchange_rate%TYPE;
18:
19: /*
20: * Contains information about the last processed record by the api get_labor_rate.

Line 17: g_ou_acct_exch_rate pa_org_labor_sch_rule.acct_exchange_rate%TYPE;

13: g_ou_ot_project_id pa_projects_all.project_id%TYPE;
14: g_ou_ot_task_id pa_tasks.task_id%TYPE;
15: g_ou_acct_rate_date_code pa_org_labor_sch_rule.acct_rate_date_code%TYPE;
16: g_ou_acct_rate_type pa_org_labor_sch_rule.acct_rate_type%TYPE;
17: g_ou_acct_exch_rate pa_org_labor_sch_rule.acct_exchange_rate%TYPE;
18:
19: /*
20: * Contains information about the last processed record by the api get_labor_rate.
21: */

Line 27: g_rt_org_labor_sch_rule_id pa_org_labor_sch_rule.org_labor_sch_rule_id%TYPE;

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;
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;

Line 31: g_rt_acct_rate_type pa_org_labor_sch_rule.acct_rate_type%TYPE;

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;
35: g_rt_ot_task_id pa_tasks.task_id%TYPE;

Line 32: g_rt_acct_rate_date_code pa_org_labor_sch_rule.acct_rate_date_code%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;
35: g_rt_ot_task_id pa_tasks.task_id%TYPE;
36: g_rt_err_stage number;

Line 33: g_rt_acct_exch_rate pa_org_labor_sch_rule.acct_exchange_rate%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;
35: g_rt_ot_task_id pa_tasks.task_id%TYPE;
36: g_rt_err_stage number;
37: g_rt_err_code varchar2(50);

Line 40: g_base_hours pa_org_labor_sch_rule.base_hours%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:
44:

Line 41: g_rbc_elem_type_id pa_org_labor_sch_rule.rbc_element_type_id%TYPE;

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:
44:
45: -- Start of comments

Line 73: ,x_org_labor_sch_rule_id OUT NOCOPY pa_org_labor_sch_rule.org_labor_sch_rule_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
75: ,x_rate_sch_id OUT NOCOPY pa_std_bill_rate_schedules_all.bill_rate_sch_id%TYPE
76: ,x_cost_rate_curr_code OUT NOCOPY gl_sets_of_books.currency_code%TYPE
77: ,x_acct_rate_type OUT NOCOPY pa_expenditure_items_all.acct_rate_type%TYPE

Line 79: ,x_acct_exch_rate OUT NOCOPY pa_org_labor_sch_rule.acct_exchange_rate%TYPE

75: ,x_rate_sch_id OUT NOCOPY pa_std_bill_rate_schedules_all.bill_rate_sch_id%TYPE
76: ,x_cost_rate_curr_code OUT NOCOPY gl_sets_of_books.currency_code%TYPE
77: ,x_acct_rate_type OUT NOCOPY pa_expenditure_items_all.acct_rate_type%TYPE
78: ,x_acct_rate_date_code OUT NOCOPY pa_implementations_all.acct_rate_date_code%TYPE
79: ,x_acct_exch_rate OUT NOCOPY pa_org_labor_sch_rule.acct_exchange_rate%TYPE
80: ,x_ot_project_id OUT NOCOPY pa_projects_all.project_id%TYPE
81: ,x_ot_task_id OUT NOCOPY pa_tasks.task_id%TYPE
82: ,x_err_stage OUT NOCOPY number
83: ,x_err_code OUT NOCOPY varchar2

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

90: ,p_person_id IN pa_expenditures_all.incurred_by_person_id%TYPE
91: ,p_job_id IN pa_expenditure_items_all.job_id%TYPE
92: ,p_txn_date IN pa_expenditure_items_all.expenditure_item_date%TYPE
93: ,p_calling_module IN varchar2 default 'STAFFED'
94: ,x_org_labor_sch_rule_id IN OUT NOCOPY pa_org_labor_sch_rule.org_labor_sch_rule_id%TYPE
95: ,x_costing_rule IN OUT NOCOPY pa_compensation_rule_sets.compensation_rule_set%TYPE
96: ,x_rate_sch_id IN OUT NOCOPY pa_std_bill_rate_schedules.bill_rate_sch_id%TYPE
97: ,x_ot_project_id IN OUT NOCOPY pa_projects_all.project_id%TYPE
98: ,x_ot_task_id IN OUT NOCOPY pa_tasks.task_id%TYPE

Line 99: ,x_base_hours IN OUT NOCOPY pa_org_labor_sch_rule.base_hours%TYPE /* 12.2 payroll intg .. bug 11811475 */

95: ,x_costing_rule IN OUT NOCOPY pa_compensation_rule_sets.compensation_rule_set%TYPE
96: ,x_rate_sch_id IN OUT NOCOPY pa_std_bill_rate_schedules.bill_rate_sch_id%TYPE
97: ,x_ot_project_id IN OUT NOCOPY pa_projects_all.project_id%TYPE
98: ,x_ot_task_id IN OUT NOCOPY pa_tasks.task_id%TYPE
99: ,x_base_hours IN OUT NOCOPY pa_org_labor_sch_rule.base_hours%TYPE /* 12.2 payroll intg .. bug 11811475 */
100: ,x_rbc_elem_type_id IN OUT NOCOPY pa_org_labor_sch_rule.rbc_element_type_id%TYPE /* 12.2 payroll intg .. bug 11811475 */
101: ,x_cost_rate_curr_code IN OUT NOCOPY pa_expenditure_items_all.denom_currency_code%TYPE
102: ,x_acct_rate_type IN OUT NOCOPY pa_expenditure_items_all.acct_rate_type%TYPE
103: ,x_acct_rate_date_code IN OUT NOCOPY pa_implementations_all.acct_rate_date_code%TYPE

Line 100: ,x_rbc_elem_type_id IN OUT NOCOPY pa_org_labor_sch_rule.rbc_element_type_id%TYPE /* 12.2 payroll intg .. bug 11811475 */

96: ,x_rate_sch_id IN OUT NOCOPY pa_std_bill_rate_schedules.bill_rate_sch_id%TYPE
97: ,x_ot_project_id IN OUT NOCOPY pa_projects_all.project_id%TYPE
98: ,x_ot_task_id IN OUT NOCOPY pa_tasks.task_id%TYPE
99: ,x_base_hours IN OUT NOCOPY pa_org_labor_sch_rule.base_hours%TYPE /* 12.2 payroll intg .. bug 11811475 */
100: ,x_rbc_elem_type_id IN OUT NOCOPY pa_org_labor_sch_rule.rbc_element_type_id%TYPE /* 12.2 payroll intg .. bug 11811475 */
101: ,x_cost_rate_curr_code IN OUT NOCOPY pa_expenditure_items_all.denom_currency_code%TYPE
102: ,x_acct_rate_type IN OUT NOCOPY pa_expenditure_items_all.acct_rate_type%TYPE
103: ,x_acct_rate_date_code IN OUT NOCOPY pa_implementations_all.acct_rate_date_code%TYPE
104: ,x_acct_exch_rate IN OUT NOCOPY pa_compensation_details_all.acct_exchange_rate%TYPE