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 46: FROM pa_std_bill_rate_schedules_all sch,pa_bill_rates_all b

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

Line 59: From pa_std_bill_rate_schedules_all sch,pa_bill_rates_all b,

55: the Organization and resource Class in the above cursor*/
56:
57: cursor c_parent_rule (p_proj_org_version_id IN NUMBER) is
58: SELECT b.rate,b.markup_percentage,b.bill_rate_unit,b.rate_currency_code
59: From pa_std_bill_rate_schedules_all sch,pa_bill_rates_all b,
60: ( select organization_id_parent PARENT_ORGANIZATION_ID,level parent_level
61: from per_org_structure_elements
62: where org_structure_version_id = p_proj_org_version_id
63: 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: l_resource_class_flag pa_resource_lists_all_bg.RESOURCE_CLASS_FLAG%TYPE := 'Y'; --CBS

Line 1926: l_txn_curr_code pa_bill_rates_all.rate_currency_code%TYPE;

1922: l_bill_rate NUMBER:=NULL;
1923: l_cost_rate NUMBER:=NULL;
1924: l_adjust_amount NUMBER :=null;
1925: l_markup NUMBER :=null;
1926: l_txn_curr_code pa_bill_rates_all.rate_currency_code%TYPE;
1927: l_raw_revenue NUMBER :=null; -- store the raw revenue
1928: l_true BOOLEAN := FALSE;
1929: l_txn_raw_revenue NUMBER :=null; -- store the raw revenue trans. curr.
1930: l_raw_cost number := null;

Line 1932: l_txn_currency_code pa_bill_rates_all.rate_currency_code%TYPE;

1928: l_true BOOLEAN := FALSE;
1929: l_txn_raw_revenue NUMBER :=null; -- store the raw revenue trans. curr.
1930: l_raw_cost number := null;
1931: l_burden_cost number := null;
1932: l_txn_currency_code pa_bill_rates_all.rate_currency_code%TYPE;
1933: l_inter_txn_curr_code pa_bill_rates_all.rate_currency_code%TYPE;--4194214
1934: l_burden_cost_rate NUMBER:=NULL;
1935: l_cost_ind_compiled_set_id NUMBER;
1936: l_burd_organization_id NUMBER;

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

1929: l_txn_raw_revenue NUMBER :=null; -- store the raw revenue trans. curr.
1930: l_raw_cost number := null;
1931: l_burden_cost number := null;
1932: l_txn_currency_code pa_bill_rates_all.rate_currency_code%TYPE;
1933: l_inter_txn_curr_code pa_bill_rates_all.rate_currency_code%TYPE;--4194214
1934: l_burden_cost_rate NUMBER:=NULL;
1935: l_cost_ind_compiled_set_id NUMBER;
1936: l_burd_organization_id NUMBER;
1937: l_x_msg_data VARCHAR2(1000);

Line 1954: l_bill_txn_curr_code pa_bill_rates_all.rate_currency_code%TYPE;

1950: l_txn_burden_cost NUMBER :=null;
1951: l_txn_raw_cost NUMBER :=null;
1952: l_txn_cost_rate NUMBER:=NULL;
1953: l_burden_cost_rejection_code VARCHAR2(50);
1954: l_bill_txn_curr_code pa_bill_rates_all.rate_currency_code%TYPE;
1955: l_inter_return_status VARCHAR2(1):=null;
1956: l_calling_mode VARCHAR2(20):=null;
1957: l_override_organization_id NUMBER;
1958: l_ovr_return_status VARCHAR2(20):=g_success;

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

2068: BEGIN
2069: DECLARE
2070: l_class_org_rate NUMBER:=NULL;
2071: l_class_org_markup NUMBER:=NULL;
2072: l_class_org_uom pa_bill_rates_all.bill_rate_unit%TYPE :=NULL;
2073: l_class_org_rate_curr_code pa_bill_rates_all.rate_currency_code%TYPE :=NULL;
2074: l_class_org_return_status VARCHAR2(20):= g_success;
2075: l_class_org_return_data VARCHAR2(30);
2076: l_class_org_return_count NUMBER;

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

2069: DECLARE
2070: l_class_org_rate NUMBER:=NULL;
2071: l_class_org_markup NUMBER:=NULL;
2072: l_class_org_uom pa_bill_rates_all.bill_rate_unit%TYPE :=NULL;
2073: l_class_org_rate_curr_code pa_bill_rates_all.rate_currency_code%TYPE :=NULL;
2074: l_class_org_return_status VARCHAR2(20):= g_success;
2075: l_class_org_return_data VARCHAR2(30);
2076: l_class_org_return_count NUMBER;
2077: l_item_date DATE := p_item_date;

Line 2139: FROM pa_std_bill_rate_schedules_all sch,pa_bill_rates_all b

2135: ,DECODE(p_uom,b.bill_rate_unit,PA_MULTI_CURRENCY_BILLING.ROUND_TRANS_CURRENCY_AMT(b.rate * NVL(p_cost_rate_multiplier,1)
2136: * p_quantity, b.rate_currency_code),null)
2137: ) r_cost,
2138: DECODE(p_uom,'DOLLARS', b.rate_currency_code,b.rate_currency_code) rate_currency_code
2139: FROM pa_std_bill_rate_schedules_all sch,pa_bill_rates_all b
2140: WHERE sch.bill_rate_sch_id=p_cost_res_class_rate_sch_id
2141: AND sch.bill_rate_sch_id=b.bill_rate_sch_id
2142: AND b.resource_class_code = p_resource_class
2143: AND sch.schedule_type = 'RESOURCE_CLASS'

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

2406: BEGIN
2407: DECLARE
2408: l_class_org_rate NUMBER:=NULL;
2409: l_class_org_markup NUMBER:=NULL;
2410: l_class_org_uom pa_bill_rates_all.bill_rate_unit%TYPE :=NULL;
2411: l_class_org_rate_curr_code pa_bill_rates_all.rate_currency_code%TYPE :=NULL;
2412: l_class_org_return_status VARCHAR2(1):= g_success;
2413: l_class_org_return_data VARCHAR2(30);
2414: l_class_org_return_count NUMBER;

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

2407: DECLARE
2408: l_class_org_rate NUMBER:=NULL;
2409: l_class_org_markup NUMBER:=NULL;
2410: l_class_org_uom pa_bill_rates_all.bill_rate_unit%TYPE :=NULL;
2411: l_class_org_rate_curr_code pa_bill_rates_all.rate_currency_code%TYPE :=NULL;
2412: l_class_org_return_status VARCHAR2(1):= g_success;
2413: l_class_org_return_data VARCHAR2(30);
2414: l_class_org_return_count NUMBER;
2415: l_item_date DATE := p_item_date;

Line 2495: FROM pa_std_bill_rate_schedules_all sch,pa_bill_rates_all b

2491: ) r_revenue,
2492: 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,
2493: -- DECODE(p_uom,'DOLLARS', b.rate_currency_code,b.rate_currency_code ) rate_currency_code, --4194214
2494: 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
2495: FROM pa_std_bill_rate_schedules_all sch,pa_bill_rates_all b
2496: WHERE sch.bill_rate_sch_id=p_rev_res_class_rate_sch_id
2497: AND b.bill_rate_sch_id = sch.bill_rate_sch_id
2498: AND b.resource_class_code = p_resource_class
2499: AND sch.schedule_type = 'RESOURCE_CLASS'

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

2730: l_msg_data VARCHAR2(1000);
2731: l_txn_curr_code VARCHAR2(30);
2732: l_rev_curr_code VARCHAR2(30);
2733: l_override_cost NUMBER:=NULL;
2734: l_txn_bill_rate pa_bill_rates_all.rate%TYPE:=NULL;
2735: l_bill_rate pa_bill_rates_all.rate%TYPE:=NULL;
2736: l_txn_bill_markup NUMBER:=NULL;
2737: l_markup NUMBER:=NULL;
2738: l_raw_revenue NUMBER:=NULL;

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

2731: l_txn_curr_code VARCHAR2(30);
2732: l_rev_curr_code VARCHAR2(30);
2733: l_override_cost NUMBER:=NULL;
2734: l_txn_bill_rate pa_bill_rates_all.rate%TYPE:=NULL;
2735: l_bill_rate pa_bill_rates_all.rate%TYPE:=NULL;
2736: l_txn_bill_markup NUMBER:=NULL;
2737: l_markup NUMBER:=NULL;
2738: l_raw_revenue NUMBER:=NULL;
2739: l_txn_raw_revenue NUMBER;

Line 2746: l_dest_job_id pa_bill_rates_all.job_id%TYPE;

2742: l_true BOOLEAN :=FALSE;
2743: l_bill_txn_curr_code VARCHAR2(30);
2744: -- Added for bug 5952621
2745: l_job_group_id pa_std_bill_rate_schedules_all.job_group_id%TYPE;
2746: l_dest_job_id pa_bill_rates_all.job_id%TYPE;
2747:
2748: /* Bug 8407306 */
2749: l_job_bl_rate NUMBER;
2750: l_emp_bl_rate NUMBER;

Line 2778: FROM pa_std_bill_rate_schedules_all sch,pa_bill_rates_all b

2774: ) r_revenue,
2775: 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),
2776: p_txn_currency_code) ) rate_currency_code, -- 4194214
2777: 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
2778: FROM pa_std_bill_rate_schedules_all sch,pa_bill_rates_all b
2779: WHERE sch.bill_rate_sch_id=p_plan_rev_emp_rate_sch_id
2780: AND b.bill_rate_sch_id = sch.bill_rate_sch_id
2781: AND sch.schedule_type = 'EMPLOYEE'
2782: AND b.person_id = p_person_id

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

2798: ) r_revenue,
2799: 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),
2800: p_txn_currency_code) ) rate_currency_code, -- 4194214
2801: 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
2802: FROM pa_std_bill_rate_schedules_all sch,pa_bill_rates_all b --, per_assignments_f pa
2803: WHERE sch.bill_rate_sch_id = p_plan_rev_job_rate_sch_id
2804: AND b.bill_rate_sch_id = sch.bill_rate_sch_id
2805: AND sch.schedule_type = 'JOB'
2806: AND b.job_id = l_dest_job_id -- p_job_id Modified for bug 5952621

Line 2825: FROM pa_std_bill_rate_schedules_all sch,pa_bill_rates_all b

2821: ) r_revenue,
2822: 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),
2823: p_txn_currency_code) ) rate_currency_code, -- 4194214
2824: 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
2825: FROM pa_std_bill_rate_schedules_all sch,pa_bill_rates_all b
2826: WHERE sch.bill_rate_sch_id = p_plan_rev_nlr_rate_sch_id
2827: AND b.bill_rate_sch_id = sch.bill_rate_sch_id
2828: AND b.expenditure_type = p_expenditure_type
2829: AND b.non_labor_resource = p_non_labor_resource

Line 2849: FROM pa_std_bill_rate_schedules_all sch,pa_bill_rates_all b

2845: ) r_revenue,
2846: 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),
2847: p_txn_currency_code) ) rate_currency_code, -- 4194214
2848: 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
2849: FROM pa_std_bill_rate_schedules_all sch,pa_bill_rates_all b
2850: WHERE sch.bill_rate_sch_id = p_plan_rev_nlr_rate_sch_id
2851: AND b.bill_rate_sch_id = sch.bill_rate_sch_id
2852: AND b.expenditure_type = p_expenditure_type
2853: AND sch.schedule_type = 'NON-LABOR'

Line 3601: l_txn_curr_code pa_bill_rates_all.rate_currency_code%TYPE;

3597: l_bill_rate NUMBER :=NULL;
3598: l_cost_rate NUMBER :=NULL;
3599: l_adjust_amount NUMBER :=NULL;
3600: l_markup NUMBER :=NULL;
3601: l_txn_curr_code pa_bill_rates_all.rate_currency_code%TYPE;
3602: l_raw_revenue NUMBER :=NULL; -- store the raw revenue
3603: l_true BOOLEAN := FALSE;
3604: l_txn_raw_revenue NUMBER :=NULL; -- store the raw revenue trans. curr.
3605: l_raw_cost NUMBER := NULL;

Line 3607: l_txn_currency_code pa_bill_rates_all.rate_currency_code%TYPE;

3603: l_true BOOLEAN := FALSE;
3604: l_txn_raw_revenue NUMBER :=NULL; -- store the raw revenue trans. curr.
3605: l_raw_cost NUMBER := NULL;
3606: l_burden_cost NUMBER := NULL;
3607: l_txn_currency_code pa_bill_rates_all.rate_currency_code%TYPE;
3608: l_inter_txn_curr_code pa_bill_rates_all.rate_currency_code%TYPE;--4194214
3609: l_burden_cost_rate NUMBER:=NULL;
3610: l_cost_ind_compiled_set_id NUMBER;
3611: l_burd_organization_id NUMBER;

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

3604: l_txn_raw_revenue NUMBER :=NULL; -- store the raw revenue trans. curr.
3605: l_raw_cost NUMBER := NULL;
3606: l_burden_cost NUMBER := NULL;
3607: l_txn_currency_code pa_bill_rates_all.rate_currency_code%TYPE;
3608: l_inter_txn_curr_code pa_bill_rates_all.rate_currency_code%TYPE;--4194214
3609: l_burden_cost_rate NUMBER:=NULL;
3610: l_cost_ind_compiled_set_id NUMBER;
3611: l_burd_organization_id NUMBER;
3612: l_x_msg_data VARCHAR2(1000);

Line 3629: l_bill_txn_curr_code pa_bill_rates_all.rate_currency_code%TYPE;

3625: l_txn_burden_cost NUMBER :=NULL;
3626: l_txn_raw_cost NUMBER :=NULL;
3627: l_txn_cost_rate NUMBER :=NULL;
3628: l_burden_cost_rejection_code VARCHAR2(50);
3629: l_bill_txn_curr_code pa_bill_rates_all.rate_currency_code%TYPE;
3630: l_inter_return_status VARCHAR2(1) :=NULL;
3631: l_calling_mode VARCHAR2(20):=NULL;
3632: l_override_organization_id NUMBER;
3633: l_ovr_return_status VARCHAR2(20):=g_success;