DBA Data[Home] [Help]

APPS.PA_COST_RATE_PUB dependencies on PA_IMPLEMENTATIONS_ALL

Line 9: g_ou_id pa_implementations_all.org_id%TYPE;

5: g_func_curr gl_sets_of_books.currency_Code%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;

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

72: ,x_costing_rule OUT NOCOPY pa_compensation_rule_sets.compensation_rule_set%TYPE
73: ,x_rate_sch_id OUT NOCOPY pa_std_bill_rate_schedules_all.bill_rate_sch_id%TYPE
74: ,x_cost_rate_curr_code OUT NOCOPY gl_sets_of_books.currency_code%TYPE
75: ,x_acct_rate_type OUT NOCOPY pa_expenditure_items_all.acct_rate_type%TYPE
76: ,x_acct_rate_date_code OUT NOCOPY pa_implementations_all.acct_rate_date_code%TYPE
77: ,x_acct_exch_rate OUT NOCOPY pa_org_labor_sch_rule.acct_exchange_rate%TYPE
78: ,x_ot_project_id OUT NOCOPY pa_projects_all.project_id%TYPE
79: ,x_ot_task_id OUT NOCOPY pa_tasks.task_id%TYPE
80: ,x_err_stage OUT NOCOPY number

Line 86: p_org_id IN pa_implementations_all.org_id%TYPE

82: ,P_Called_From IN varchar2 DEFAULT 'O' /* Added for 3405326 */
83: );
84:
85: PROCEDURE get_orgn_level_costing_info(
86: p_org_id IN pa_implementations_all.org_id%TYPE
87: ,p_organization_id IN pa_expenditures_all.incurred_by_organization_id%TYPE
88: ,p_person_id IN pa_expenditures_all.incurred_by_person_id%TYPE
89: ,p_job_id IN pa_expenditure_items_all.job_id%TYPE
90: ,p_txn_date IN pa_expenditure_items_all.expenditure_item_date%TYPE

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

95: ,x_ot_project_id IN OUT NOCOPY pa_projects_all.project_id%TYPE
96: ,x_ot_task_id IN OUT NOCOPY pa_tasks.task_id%TYPE
97: ,x_cost_rate_curr_code IN OUT NOCOPY pa_expenditure_items_all.denom_currency_code%TYPE
98: ,x_acct_rate_type IN OUT NOCOPY pa_expenditure_items_all.acct_rate_type%TYPE
99: ,x_acct_rate_date_code IN OUT NOCOPY pa_implementations_all.acct_rate_date_code%TYPE
100: ,x_acct_exch_rate IN OUT NOCOPY pa_compensation_details_all.acct_exchange_rate%TYPE
101: ,x_err_stage IN OUT NOCOPY number
102: ,x_err_code IN OUT NOCOPY varchar2
103: ,P_Called_From IN varchar2 DEFAULT 'O' /* Added for 3405326 */

Line 120: G_ORG_ID pa_implementations_all.org_id%TYPE;

116: G_EMP_JOB_ID per_jobs.job_id%type;
117: G_EMP_ORGANIZATION_ID hr_organization_units.organization_id%type;
118:
119: -- Bug 3785956
120: G_ORG_ID pa_implementations_all.org_id%TYPE;
121: G_TXN_DATE pa_expenditure_items_all.expenditure_item_date%TYPE;
122: G_CALLING_MODULE VARCHAR2(150) := 'STAFFED';
123:
124: