eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PA_PLAN_REVENUE dependencies on PA_BILL_RATES_ALL

Line 47: FROM pa_std_bill_rate_schedules_all sch,pa_bill_rates_all b

43: x_msg_count OUT NOCOPY NUMBER,
44: x_msg_data OUT NOCOPY VARCHAR2) AS
45: Cursor c_rule is
46: SELECT b.rate,b.markup_percentage,b.bill_rate_unit,b.rate_currency_code
47: FROM pa_std_bill_rate_schedules_all sch,pa_bill_rates_all b
48: WHERE sch.bill_rate_sch_id = p_res_class_rate_sch_id
49: AND b.bill_rate_sch_id = sch.bill_rate_sch_id
50: AND sch.schedule_type = 'RESOURCE_CLASS'
51: AND trunc(p_item_date) BETWEEN trunc(b.start_date_active) AND trunc(NVL(b.end_date_active ,p_item_date))

Line 60: From pa_std_bill_rate_schedules_all sch,pa_bill_rates_all b,

56: the Organization and resource Class in the above cursor*/
57:
58: cursor c_parent_rule (p_proj_org_version_id IN NUMBER) is
59: SELECT b.rate,b.markup_percentage,b.bill_rate_unit,b.rate_currency_code
60: From pa_std_bill_rate_schedules_all sch,pa_bill_rates_all b,
61: ( select organization_id_parent PARENT_ORGANIZATION_ID,level parent_level
62: from per_org_structure_elements
63: where org_structure_version_id = p_proj_org_version_id
64: connect by prior organization_id_parent=organization_id_child

Line 307: l_bill_markup pa_bill_rates_all.markup_percentage%TYPE:=NULL;

303: l_raw_revenue NUMBER;
304: l_txn_raw_cost NUMBER;
305: l_txn_burden_cost NUMBER;
306: l_txn_raw_revenue NUMBER;
307: l_bill_markup pa_bill_rates_all.markup_percentage%TYPE:=NULL;
308: l_txn_bill_markup pa_bill_rates_all.markup_percentage%TYPE:=NULL;
309: l_txn_cost_markup pa_bill_rates_all.markup_percentage%TYPE:=NULL;
310: l_txn_curr_code pa_bill_rates_all.rate_currency_code%TYPE:=NULL;
311: l_cost_txn_curr_code pa_bill_rates_all.rate_currency_code%TYPE:=NULL;

Line 308: l_txn_bill_markup pa_bill_rates_all.markup_percentage%TYPE:=NULL;

304: l_txn_raw_cost NUMBER;
305: l_txn_burden_cost NUMBER;
306: l_txn_raw_revenue NUMBER;
307: l_bill_markup pa_bill_rates_all.markup_percentage%TYPE:=NULL;
308: l_txn_bill_markup pa_bill_rates_all.markup_percentage%TYPE:=NULL;
309: l_txn_cost_markup pa_bill_rates_all.markup_percentage%TYPE:=NULL;
310: l_txn_curr_code pa_bill_rates_all.rate_currency_code%TYPE:=NULL;
311: l_cost_txn_curr_code pa_bill_rates_all.rate_currency_code%TYPE:=NULL;
312: l_rev_txn_curr_code pa_bill_rates_all.rate_currency_code%TYPE:=NULL;

Line 309: l_txn_cost_markup pa_bill_rates_all.markup_percentage%TYPE:=NULL;

305: l_txn_burden_cost NUMBER;
306: l_txn_raw_revenue NUMBER;
307: l_bill_markup pa_bill_rates_all.markup_percentage%TYPE:=NULL;
308: l_txn_bill_markup pa_bill_rates_all.markup_percentage%TYPE:=NULL;
309: l_txn_cost_markup pa_bill_rates_all.markup_percentage%TYPE:=NULL;
310: l_txn_curr_code pa_bill_rates_all.rate_currency_code%TYPE:=NULL;
311: l_cost_txn_curr_code pa_bill_rates_all.rate_currency_code%TYPE:=NULL;
312: l_rev_txn_curr_code pa_bill_rates_all.rate_currency_code%TYPE:=NULL;
313: l_raw_cost_rejection_code VARCHAR2(30);

Line 310: l_txn_curr_code pa_bill_rates_all.rate_currency_code%TYPE:=NULL;

306: l_txn_raw_revenue NUMBER;
307: l_bill_markup pa_bill_rates_all.markup_percentage%TYPE:=NULL;
308: l_txn_bill_markup pa_bill_rates_all.markup_percentage%TYPE:=NULL;
309: l_txn_cost_markup pa_bill_rates_all.markup_percentage%TYPE:=NULL;
310: l_txn_curr_code pa_bill_rates_all.rate_currency_code%TYPE:=NULL;
311: l_cost_txn_curr_code pa_bill_rates_all.rate_currency_code%TYPE:=NULL;
312: l_rev_txn_curr_code pa_bill_rates_all.rate_currency_code%TYPE:=NULL;
313: l_raw_cost_rejection_code VARCHAR2(30);
314: l_burden_cost_rejection_code VARCHAR2(30);

Line 311: l_cost_txn_curr_code pa_bill_rates_all.rate_currency_code%TYPE:=NULL;

307: l_bill_markup pa_bill_rates_all.markup_percentage%TYPE:=NULL;
308: l_txn_bill_markup pa_bill_rates_all.markup_percentage%TYPE:=NULL;
309: l_txn_cost_markup pa_bill_rates_all.markup_percentage%TYPE:=NULL;
310: l_txn_curr_code pa_bill_rates_all.rate_currency_code%TYPE:=NULL;
311: l_cost_txn_curr_code pa_bill_rates_all.rate_currency_code%TYPE:=NULL;
312: l_rev_txn_curr_code pa_bill_rates_all.rate_currency_code%TYPE:=NULL;
313: l_raw_cost_rejection_code VARCHAR2(30);
314: l_burden_cost_rejection_code VARCHAR2(30);
315: l_revenue_rejection_code VARCHAR2(30);

Line 312: l_rev_txn_curr_code pa_bill_rates_all.rate_currency_code%TYPE:=NULL;

308: l_txn_bill_markup pa_bill_rates_all.markup_percentage%TYPE:=NULL;
309: l_txn_cost_markup pa_bill_rates_all.markup_percentage%TYPE:=NULL;
310: l_txn_curr_code pa_bill_rates_all.rate_currency_code%TYPE:=NULL;
311: l_cost_txn_curr_code pa_bill_rates_all.rate_currency_code%TYPE:=NULL;
312: l_rev_txn_curr_code pa_bill_rates_all.rate_currency_code%TYPE:=NULL;
313: l_raw_cost_rejection_code VARCHAR2(30);
314: l_burden_cost_rejection_code VARCHAR2(30);
315: l_revenue_rejection_code VARCHAR2(30);
316: l_cost_ind_compiled_set_id NUMBER;

Line 328: l_rev_res_txn_curr_code pa_bill_rates_all.rate_currency_code%TYPE:=NULL;

324: l_burd_sch_cost_base VARCHAR2(50);
325: l_burd_sch_cp_structure VARCHAR2(50);
326: l_cost_return_status VARCHAR2(1):=g_success;
327: l_cost_msg_data VARCHAR2(1000);
328: l_rev_res_txn_curr_code pa_bill_rates_all.rate_currency_code%TYPE:=NULL;
329: l_cost_res_txn_curr_code pa_bill_rates_all.rate_currency_code%TYPE:=NULL;
330: l_expenditure_org_id NUMBER;
331: l_calculate_mode VARCHAR2(30);
332:

Line 329: l_cost_res_txn_curr_code pa_bill_rates_all.rate_currency_code%TYPE:=NULL;

325: l_burd_sch_cp_structure VARCHAR2(50);
326: l_cost_return_status VARCHAR2(1):=g_success;
327: l_cost_msg_data VARCHAR2(1000);
328: l_rev_res_txn_curr_code pa_bill_rates_all.rate_currency_code%TYPE:=NULL;
329: l_cost_res_txn_curr_code pa_bill_rates_all.rate_currency_code%TYPE:=NULL;
330: l_expenditure_org_id NUMBER;
331: l_calculate_mode VARCHAR2(30);
332:
333:

Line 1839: l_txn_curr_code pa_bill_rates_all.rate_currency_code%TYPE;

1835: l_bill_rate NUMBER:=NULL;
1836: l_cost_rate NUMBER:=NULL;
1837: l_adjust_amount NUMBER :=null;
1838: l_markup NUMBER :=null;
1839: l_txn_curr_code pa_bill_rates_all.rate_currency_code%TYPE;
1840: l_raw_revenue NUMBER :=null; -- store the raw revenue
1841: l_true BOOLEAN := FALSE;
1842: l_txn_raw_revenue NUMBER :=null; -- store the raw revenue trans. curr.
1843: l_raw_cost number := null;

Line 1845: l_txn_currency_code pa_bill_rates_all.rate_currency_code%TYPE;

1841: l_true BOOLEAN := FALSE;
1842: l_txn_raw_revenue NUMBER :=null; -- store the raw revenue trans. curr.
1843: l_raw_cost number := null;
1844: l_burden_cost number := null;
1845: l_txn_currency_code pa_bill_rates_all.rate_currency_code%TYPE;
1846: l_inter_txn_curr_code pa_bill_rates_all.rate_currency_code%TYPE;--4194214
1847: l_burden_cost_rate NUMBER:=NULL;
1848: l_cost_ind_compiled_set_id NUMBER;
1849: l_burd_organization_id NUMBER;

Line 1846: l_inter_txn_curr_code pa_bill_rates_all.rate_currency_code%TYPE;--4194214

1842: l_txn_raw_revenue NUMBER :=null; -- store the raw revenue trans. curr.
1843: l_raw_cost number := null;
1844: l_burden_cost number := null;
1845: l_txn_currency_code pa_bill_rates_all.rate_currency_code%TYPE;
1846: l_inter_txn_curr_code pa_bill_rates_all.rate_currency_code%TYPE;--4194214
1847: l_burden_cost_rate NUMBER:=NULL;
1848: l_cost_ind_compiled_set_id NUMBER;
1849: l_burd_organization_id NUMBER;
1850: l_x_msg_data VARCHAR2(1000);

Line 1867: l_bill_txn_curr_code pa_bill_rates_all.rate_currency_code%TYPE;

1863: l_txn_burden_cost NUMBER :=null;
1864: l_txn_raw_cost NUMBER :=null;
1865: l_txn_cost_rate NUMBER:=NULL;
1866: l_burden_cost_rejection_code VARCHAR2(50);
1867: l_bill_txn_curr_code pa_bill_rates_all.rate_currency_code%TYPE;
1868: l_inter_return_status VARCHAR2(1):=null;
1869: l_calling_mode VARCHAR2(20):=null;
1870: l_override_organization_id NUMBER;
1871: l_ovr_return_status VARCHAR2(20):=g_success;

Line 1985: l_class_org_uom pa_bill_rates_all.bill_rate_unit%TYPE :=NULL;

1981: BEGIN
1982: DECLARE
1983: l_class_org_rate NUMBER:=NULL;
1984: l_class_org_markup NUMBER:=NULL;
1985: l_class_org_uom pa_bill_rates_all.bill_rate_unit%TYPE :=NULL;
1986: l_class_org_rate_curr_code pa_bill_rates_all.rate_currency_code%TYPE :=NULL;
1987: l_class_org_return_status VARCHAR2(20):= g_success;
1988: l_class_org_return_data VARCHAR2(30);
1989: l_class_org_return_count NUMBER;

Line 1986: l_class_org_rate_curr_code pa_bill_rates_all.rate_currency_code%TYPE :=NULL;

1982: DECLARE
1983: l_class_org_rate NUMBER:=NULL;
1984: l_class_org_markup NUMBER:=NULL;
1985: l_class_org_uom pa_bill_rates_all.bill_rate_unit%TYPE :=NULL;
1986: l_class_org_rate_curr_code pa_bill_rates_all.rate_currency_code%TYPE :=NULL;
1987: l_class_org_return_status VARCHAR2(20):= g_success;
1988: l_class_org_return_data VARCHAR2(30);
1989: l_class_org_return_count NUMBER;
1990: l_item_date DATE := p_item_date;

Line 2052: FROM pa_std_bill_rate_schedules_all sch,pa_bill_rates_all b

2048: ,DECODE(p_uom,b.bill_rate_unit,PA_MULTI_CURRENCY_BILLING.ROUND_TRANS_CURRENCY_AMT(b.rate * NVL(p_cost_rate_multiplier,1)
2049: * p_quantity, b.rate_currency_code),null)
2050: ) r_cost,
2051: DECODE(p_uom,'DOLLARS', b.rate_currency_code,b.rate_currency_code) rate_currency_code
2052: FROM pa_std_bill_rate_schedules_all sch,pa_bill_rates_all b
2053: WHERE sch.bill_rate_sch_id=p_cost_res_class_rate_sch_id
2054: AND sch.bill_rate_sch_id=b.bill_rate_sch_id
2055: AND b.resource_class_code = p_resource_class
2056: AND sch.schedule_type = 'RESOURCE_CLASS'

Line 2323: l_class_org_uom pa_bill_rates_all.bill_rate_unit%TYPE :=NULL;

2319: BEGIN
2320: DECLARE
2321: l_class_org_rate NUMBER:=NULL;
2322: l_class_org_markup NUMBER:=NULL;
2323: l_class_org_uom pa_bill_rates_all.bill_rate_unit%TYPE :=NULL;
2324: l_class_org_rate_curr_code pa_bill_rates_all.rate_currency_code%TYPE :=NULL;
2325: l_class_org_return_status VARCHAR2(1):= g_success;
2326: l_class_org_return_data VARCHAR2(30);
2327: l_class_org_return_count NUMBER;

Line 2324: l_class_org_rate_curr_code pa_bill_rates_all.rate_currency_code%TYPE :=NULL;

2320: DECLARE
2321: l_class_org_rate NUMBER:=NULL;
2322: l_class_org_markup NUMBER:=NULL;
2323: l_class_org_uom pa_bill_rates_all.bill_rate_unit%TYPE :=NULL;
2324: l_class_org_rate_curr_code pa_bill_rates_all.rate_currency_code%TYPE :=NULL;
2325: l_class_org_return_status VARCHAR2(1):= g_success;
2326: l_class_org_return_data VARCHAR2(30);
2327: l_class_org_return_count NUMBER;
2328: l_item_date DATE := p_item_date;

Line 2405: FROM pa_std_bill_rate_schedules_all sch,pa_bill_rates_all b

2401: ) r_revenue,
2402: DECODE(p_uom,'DOLLARS',l_inter_txn_curr_code,DECODE(p_uom,b.bill_rate_unit,decode(b.rate,null,l_inter_txn_curr_code,b.rate_currency_code),l_inter_txn_curr_code) ) rate_currency_code,
2403: -- DECODE(p_uom,'DOLLARS', b.rate_currency_code,b.rate_currency_code ) rate_currency_code, --4194214
2404: DECODE (p_uom,'DOLLARS',b.markup_percentage,DECODE(p_uom,b.bill_rate_unit,decode(b.rate,null,b.markup_percentage,NULL),b.markup_percentage)) markup
2405: FROM pa_std_bill_rate_schedules_all sch,pa_bill_rates_all b
2406: WHERE sch.bill_rate_sch_id=p_rev_res_class_rate_sch_id
2407: AND b.bill_rate_sch_id = sch.bill_rate_sch_id
2408: AND b.resource_class_code = p_resource_class
2409: AND sch.schedule_type = 'RESOURCE_CLASS'

Line 2644: l_txn_bill_rate pa_bill_rates_all.rate%TYPE:=NULL;

2640: l_msg_data VARCHAR2(1000);
2641: l_txn_curr_code VARCHAR2(30);
2642: l_rev_curr_code VARCHAR2(30);
2643: l_override_cost NUMBER:=NULL;
2644: l_txn_bill_rate pa_bill_rates_all.rate%TYPE:=NULL;
2645: l_bill_rate pa_bill_rates_all.rate%TYPE:=NULL;
2646: l_txn_bill_markup NUMBER:=NULL;
2647: l_markup NUMBER:=NULL;
2648: l_raw_revenue NUMBER:=NULL;

Line 2645: l_bill_rate pa_bill_rates_all.rate%TYPE:=NULL;

2641: l_txn_curr_code VARCHAR2(30);
2642: l_rev_curr_code VARCHAR2(30);
2643: l_override_cost NUMBER:=NULL;
2644: l_txn_bill_rate pa_bill_rates_all.rate%TYPE:=NULL;
2645: l_bill_rate pa_bill_rates_all.rate%TYPE:=NULL;
2646: l_txn_bill_markup NUMBER:=NULL;
2647: l_markup NUMBER:=NULL;
2648: l_raw_revenue NUMBER:=NULL;
2649: l_txn_raw_revenue NUMBER;

Line 2656: l_dest_job_id pa_bill_rates_all.job_id%TYPE;

2652: l_true BOOLEAN :=FALSE;
2653: l_bill_txn_curr_code VARCHAR2(30);
2654: -- Added for bug 5952621
2655: l_job_group_id pa_std_bill_rate_schedules_all.job_group_id%TYPE;
2656: l_dest_job_id pa_bill_rates_all.job_id%TYPE;
2657:
2658:
2659: -- Modified the select of all the four cursors for bug 5079161
2660: CURSOR C_std_emp_sch_rev IS

Line 2683: FROM pa_std_bill_rate_schedules_all sch,pa_bill_rates_all b

2679: ) r_revenue,
2680: DECODE(p_uom,'DOLLARS',p_txn_currency_code,DECODE(p_uom,b.bill_rate_unit, DECODE(b.rate,NULL,p_txn_currency_code,b.rate_currency_code),
2681: p_txn_currency_code) ) rate_currency_code, -- 4194214
2682: DECODE(p_uom,'DOLLARS',b.markup_percentage,DECODE(p_uom,b.bill_rate_unit,DECODE(b.rate,NULL,b.markup_percentage,NULL),b.markup_percentage)) markup
2683: FROM pa_std_bill_rate_schedules_all sch,pa_bill_rates_all b
2684: WHERE sch.bill_rate_sch_id=p_plan_rev_emp_rate_sch_id
2685: AND b.bill_rate_sch_id = sch.bill_rate_sch_id
2686: AND sch.schedule_type = 'EMPLOYEE'
2687: AND b.person_id = p_person_id

Line 2707: FROM pa_std_bill_rate_schedules_all sch,pa_bill_rates_all b --, per_assignments_f pa

2703: ) r_revenue,
2704: DECODE(p_uom,'DOLLARS',p_txn_currency_code,DECODE(p_uom,b.bill_rate_unit, DECODE(b.rate,NULL,p_txn_currency_code,b.rate_currency_code),
2705: p_txn_currency_code) ) rate_currency_code, -- 4194214
2706: DECODE(p_uom,'DOLLARS',b.markup_percentage,DECODE(p_uom,b.bill_rate_unit,DECODE(b.rate,NULL,b.markup_percentage,NULL),b.markup_percentage)) markup
2707: FROM pa_std_bill_rate_schedules_all sch,pa_bill_rates_all b --, per_assignments_f pa
2708: WHERE sch.bill_rate_sch_id = p_plan_rev_job_rate_sch_id
2709: AND b.bill_rate_sch_id = sch.bill_rate_sch_id
2710: AND sch.schedule_type = 'JOB'
2711: AND b.job_id = l_dest_job_id -- p_job_id Modified for bug 5952621

Line 2730: FROM pa_std_bill_rate_schedules_all sch,pa_bill_rates_all b

2726: ) r_revenue,
2727: DECODE(p_uom,'DOLLARS',p_txn_currency_code,DECODE(p_uom,b.bill_rate_unit, DECODE(b.rate,NULL,p_txn_currency_code,b.rate_currency_code),
2728: p_txn_currency_code) ) rate_currency_code, -- 4194214
2729: DECODE(p_uom,'DOLLARS',b.markup_percentage,DECODE(p_uom,b.bill_rate_unit,DECODE(b.rate,NULL,b.markup_percentage,NULL),b.markup_percentage)) markup
2730: FROM pa_std_bill_rate_schedules_all sch,pa_bill_rates_all b
2731: WHERE sch.bill_rate_sch_id = p_plan_rev_nlr_rate_sch_id
2732: AND b.bill_rate_sch_id = sch.bill_rate_sch_id
2733: AND b.expenditure_type = p_expenditure_type
2734: AND b.non_labor_resource = p_non_labor_resource

Line 2754: FROM pa_std_bill_rate_schedules_all sch,pa_bill_rates_all b

2750: ) r_revenue,
2751: DECODE(p_uom,'DOLLARS',p_txn_currency_code,DECODE(p_uom,b.bill_rate_unit, DECODE(b.rate,NULL,p_txn_currency_code,b.rate_currency_code),
2752: p_txn_currency_code) ) rate_currency_code, -- 4194214
2753: DECODE(p_uom,'DOLLARS',b.markup_percentage,DECODE(p_uom,b.bill_rate_unit,DECODE(b.rate,NULL,b.markup_percentage,NULL),b.markup_percentage)) markup
2754: FROM pa_std_bill_rate_schedules_all sch,pa_bill_rates_all b
2755: WHERE sch.bill_rate_sch_id = p_plan_rev_nlr_rate_sch_id
2756: AND b.bill_rate_sch_id = sch.bill_rate_sch_id
2757: AND b.expenditure_type = p_expenditure_type
2758: AND sch.schedule_type = 'NON-LABOR'