[Home] [Help]
27: INTO
28: X_proj_num
29: , X_proj_name
30: FROM
31: pa_projects_all
32: WHERE
33: project_id = X_proj_id;
34:
35: EXCEPTION
128: project_id
129: INTO
130: X_project_id
131: FROM
132: pa_projects_all
133: WHERE
134: segment1 = X_project_num;
135:
136: G_PREV_PROJECT_ID := x_project_id;
613: l_acct_rate_type pa_compensation_details.acct_rate_type%type;
614: l_acct_rate_date_code pa_compensation_details.acct_rate_date_code%type;
615: l_acct_exch_rate pa_compensation_details.acct_exchange_rate%type;
616: l_acct_cost_rate pa_compensation_details.acct_exchange_rate%type;
617: l_ot_project_id pa_projects_all.project_id%type;
618: l_ot_task_id pa_tasks.task_id%type;
619: l_err_code varchar2(200);
620: l_err_stage number;
621: l_return_value varchar2(100);
2254: lx_override_type varchar2(150);
2255: lx_org_labor_sch_rule_id pa_org_labor_sch_rule.org_labor_sch_rule_id%TYPE;
2256: lx_costing_rule pa_compensation_rule_sets.compensation_rule_set%TYPE;
2257: lx_rate_sch_id pa_std_bill_rate_schedules.bill_rate_sch_id%TYPE;
2258: lx_ot_project_id pa_projects_all.project_id%TYPE;
2259: lx_ot_task_id pa_tasks.task_id%TYPE;
2260: lx_base_hours pa_org_labor_sch_rule.base_hours%TYPE;
2261: lx_rbc_elem_type_id pa_org_labor_sch_rule.rbc_element_type_id%TYPE;
2262: lx_cost_rate_curr_code pa_expenditure_items_all.denom_currency_code%TYPE;
2385: lx_override_type varchar2(150);
2386: lx_org_labor_sch_rule_id pa_org_labor_sch_rule.org_labor_sch_rule_id%TYPE;
2387: lx_costing_rule pa_compensation_rule_sets.compensation_rule_set%TYPE;
2388: lx_rate_sch_id pa_std_bill_rate_schedules.bill_rate_sch_id%TYPE;
2389: lx_ot_project_id pa_projects_all.project_id%TYPE;
2390: lx_ot_task_id pa_tasks.task_id%TYPE;
2391: lx_base_hours pa_org_labor_sch_rule.base_hours%TYPE;
2392: lx_rbc_elem_type_id pa_org_labor_sch_rule.rbc_element_type_id%TYPE;
2393: lx_cost_rate_curr_code pa_expenditure_items_all.denom_currency_code%TYPE;