DBA Data[Home] [Help]

APPS.PA_COST_RATE_PUB dependencies on PA_PROJECTS_ALL

Line 39: ,x_ot_project_id OUT NOCOPY pa_projects_all.project_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
43: ,P_Called_From IN varchar2 DEFAULT 'O' /* Added for 3405326 */

Line 529: ,x_ot_project_id IN OUT NOCOPY pa_projects_all.project_id%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
531: ,x_cost_rate_curr_code IN OUT NOCOPY pa_expenditure_items_all.denom_currency_code%TYPE
532: ,x_acct_rate_type IN OUT NOCOPY pa_expenditure_items_all.acct_rate_type%TYPE
533: ,x_acct_rate_date_code IN OUT NOCOPY pa_implementations_all.acct_rate_date_code%TYPE

Line 547: l_ot_project_id pa_projects_all.project_id%TYPE;

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

Line 828: l_ot_project_id pa_projects_all.project_id%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;
826: l_acct_rate_date_code pa_compensation_details.acct_rate_date_code%type;
827: l_acct_exch_rate pa_compensation_details.acct_exchange_rate%type;
828: l_ot_project_id pa_projects_all.project_id%type;
829: l_ot_task_id pa_tasks.task_id%type;
830: l_err_code varchar2(200) default null; /* Default null added for bug 2931397 */
831: l_err_stage number;
832: l_return_rate pa_bill_rates_all.rate%type;

Line 998: l_ot_project_id pa_projects_all.project_id%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;
996: l_acct_rate_date_code pa_compensation_details.acct_rate_date_code%type;
997: l_acct_exch_rate pa_compensation_details.acct_exchange_rate%type;
998: l_ot_project_id pa_projects_all.project_id%type;
999: l_ot_task_id pa_tasks.task_id%type;
1000: l_err_code varchar2(200);
1001: l_err_stage number;
1002: l_return_value varchar2(100);