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_REVENUE dependencies on STANDARD

Line 28: -- P_labor_std_bill_rate_schdl VARCHAR2 NO Standard bill rate schedule

24: -- P_item_date DATE YES Forecast Item date
25: -- P_project_bill_job_grp_id NUMBER NO Billing job group id for project
26: -- P_labor_schdl_discnt NUMBER NO Labour schedule discount
27: -- P_labor_bill_rate_org_id NUMBER NO Bill rate organization id
28: -- P_labor_std_bill_rate_schdl VARCHAR2 NO Standard bill rate schedule
29: -- P_labor_schdl_fixed_date DATE NO Labor schedule fixed date
30: -- P_forecast_job_id NUMBER YES Forecast job Id at assignment level
31: -- P_forecast_job_grp_id NUMBER YES Forecast job group id at assignment level
32: -- P_labor_schdl_type VARCHAR2 NO Labor schedule type i.e. 'I' (Indirect) 'B'( Bill)

Line 126: l_labor_std_bill_rate_schdl pa_projects_all.labor_std_bill_rate_schdl%TYPE; -- store labor standard

122: l_adjusted_rate NUMBER:=NULL; -- Local variable
123: l_labor_schdl_discnt NUMBER; -- Variable to store labor schedule discount
124: l_discount_pct NUMBER; -- Variable to store the discount pct override
125: l_labor_bill_rate_org_id NUMBER; -- Variable to store labor bill rate organization id
126: l_labor_std_bill_rate_schdl pa_projects_all.labor_std_bill_rate_schdl%TYPE; -- store labor standard
127: -- bill rate schedule
128: l_labor_schdl_fixed_date DATE; -- variable to store labor schedule fixed date
129: l_labor_sch_type pa_projects_all.labor_sch_type%TYPE; -- store labor schedule type
130:

Line 255: -- Selecting labor schedule discount,labor bill rate orgnization id,labor standard bill rate

251:
252: IF ( NVL(l_revenue_calculated_flag,'N') = 'N') THEN /* added for bug 2212852 { */
253:
254:
255: -- Selecting labor schedule discount,labor bill rate orgnization id,labor standard bill rate
256: -- schedule and labor schedule fixed date if any one of them is null then taking value from task
257: -- table only if passed task id is not null if it is null then taking value from project table
258:
259: IF ( (p_labor_schdl_discnt IS NULL )OR (p_labor_bill_rate_org_id IS NULL)

Line 548: | revenue using standard job bill rate schedule. |

544: /*------------------------------------------------------------+
545: |5. Job based bill rate schedule for forecasting |
546: +------------------------------------------------------------+
547: | Set bill rate, raw revenue, adjusted rate, adjusted |
548: | revenue using standard job bill rate schedule. |
549: +------------------------------------------------------------*/
550:
551: IF ( l_raw_revenue IS NULL AND l_bill_rate IS NULL ) THEN
552:

Line 671: -- P_labor_std_bill_rate_schdl VARCHAR2 NO Standard bill rate schedule

667: -- P_raw_cost NUMBER YES Row cost
668: -- P_item_date DATE YES Forecast Item date
669: -- P_labor_schdl_discnt NUMBER NO Labour schedule discount
670: -- P_labor_bill_rate_org_id NUMBER NO Bill rate organization id
671: -- P_labor_std_bill_rate_schdl VARCHAR2 NO Standard bill rate schedule
672: -- P_labor_schdl_fixed_date DATE NO Schedule date
673: -- P_bill_job_grp_id NUMBER NO Project Group Id
674: -- P_item_id NUMBER NO Unique id
675: -- P_forecast_item_id NUMBER NO Unique identifier for forecast item used in

Line 761: l_labor_std_bill_rate_schdl VARCHAR2(20); -- store labor standard bill rate schedule

757: l_adjusted_revenue NUMBER; -- Local variable
758: l_adjusted_rate NUMBER:=NULL; -- Local variable
759: l_labor_schdl_discnt NUMBER; -- store labor schedule discount
760: l_labor_bill_rate_org_id NUMBER; -- store labor bill rate organization id
761: l_labor_std_bill_rate_schdl VARCHAR2(20); -- store labor standard bill rate schedule
762: l_labor_schdl_fixed_date DATE; -- store labor schedule fixed date
763: l_labor_sch_type VARCHAR2(1); -- store labor schedule type
764: l_expenditure_currency_code gl_sets_of_books.currency_code%TYPE := null;
765: l_bill_job_grp_id pa_projects_all.bill_job_group_id%TYPE; -- store bill job group id

Line 960: -- Selecting labor schedule discount,labor bill rate orgnization id,labor standard bill rate

956:
957: IF ( NVL(l_revenue_calculated_flag,'N') = 'N' ) THEN /* added for bug 2212852 { */
958:
959:
960: -- Selecting labor schedule discount,labor bill rate orgnization id,labor standard bill rate
961: -- schedule and labor schedule fixed date if any one of them is null then taking value from task
962: -- table only if passed task id is not null if it is null then taking value from project table
963: /* bug#4245956, added the p_called_Process='TASK or PROJECT' for RATE API */
964: IF ( ((p_labor_schdl_discnt IS NULL )OR (p_labor_bill_rate_org_id IS NULL)

Line 1880: |15. Standard Employee bill rate schedule . |

1876: END;
1877: END IF;
1878:
1879: /*------------------------------------------------------------+
1880: |15. Standard Employee bill rate schedule . |
1881: | Set bill rate, raw revenue, adjusted rate, adjusted |
1882: | revenue using standard employee bill rate schedule. |
1883: +------------------------------------------------------------*/
1884: /* Changes done for bug 2668753. Whenever MCB is 'Y' the denom_raw_cost and denom_curr_code

Line 1882: | revenue using standard employee bill rate schedule. |

1878:
1879: /*------------------------------------------------------------+
1880: |15. Standard Employee bill rate schedule . |
1881: | Set bill rate, raw revenue, adjusted rate, adjusted |
1882: | revenue using standard employee bill rate schedule. |
1883: +------------------------------------------------------------*/
1884: /* Changes done for bug 2668753. Whenever MCB is 'Y' the denom_raw_cost and denom_curr_code
1885: are changed to l_mcb_raw_cost and l_mcb_currency_code */
1886:

Line 2127: |16. Standard Job bill rate schedule |

2123: END IF; */
2124:
2125:
2126: /*------------------------------------------------------------+
2127: |16. Standard Job bill rate schedule |
2128: +------------------------------------------------------------+
2129: | Set bill rate, raw revenue, adjusted rate, adjusted |
2130: | revenue using standard job bill rate schedule. |
2131: +------------------------------------------------------------*/

Line 2130: | revenue using standard job bill rate schedule. |

2126: /*------------------------------------------------------------+
2127: |16. Standard Job bill rate schedule |
2128: +------------------------------------------------------------+
2129: | Set bill rate, raw revenue, adjusted rate, adjusted |
2130: | revenue using standard job bill rate schedule. |
2131: +------------------------------------------------------------*/
2132:
2133: IF ( l_raw_revenue IS NULL AND l_bill_rate IS NULL AND l_called_process =0 AND
2134: (nvl(l_amount_calculation_code,'O') IN ('J','O')) ) THEN

Line 2212: |16a. Standard Job bill rate schedule at Project |

2208:
2209:
2210:
2211: /*------------------------------------------------------------+
2212: |16a. Standard Job bill rate schedule at Project |
2213: +------------------------------------------------------------+
2214: | Set bill rate, raw revenue, adjusted rate, adjusted |
2215: | revenue using standard job bill rate schedule. |
2216: +------------------------------------------------------------

Line 2215: | revenue using standard job bill rate schedule. |

2211: /*------------------------------------------------------------+
2212: |16a. Standard Job bill rate schedule at Project |
2213: +------------------------------------------------------------+
2214: | Set bill rate, raw revenue, adjusted rate, adjusted |
2215: | revenue using standard job bill rate schedule. |
2216: +------------------------------------------------------------
2217:
2218: IF ( l_raw_revenue IS NULL AND l_bill_rate IS NULL AND p_called_process !='PA') THEN
2219: