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 PA_PROJECTS_ALL

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 129: l_labor_sch_type pa_projects_all.labor_sch_type%TYPE; -- store labor schedule type

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:
131: l_no_revenue EXCEPTION;--no revenue
132: l_no_val_in_funct EXCEPTION; -- Exception if no record found from get to job proc.
133: l_job_bill_rate_schedule_id pa_projects_all.job_bill_rate_schedule_id%TYPE; -- store job bill rate

Line 133: l_job_bill_rate_schedule_id pa_projects_all.job_bill_rate_schedule_id%TYPE; -- store job bill rate

129: l_labor_sch_type pa_projects_all.labor_sch_type%TYPE; -- store labor schedule type
130:
131: l_no_revenue EXCEPTION;--no revenue
132: l_no_val_in_funct EXCEPTION; -- Exception if no record found from get to job proc.
133: l_job_bill_rate_schedule_id pa_projects_all.job_bill_rate_schedule_id%TYPE; -- store job bill rate
134: -- schedule id
135: l_project_org_id pa_projects_all.org_id%TYPE;
136:
137: /* Added for MCB2 */

Line 135: l_project_org_id pa_projects_all.org_id%TYPE;

131: l_no_revenue EXCEPTION;--no revenue
132: l_no_val_in_funct EXCEPTION; -- Exception if no record found from get to job proc.
133: l_job_bill_rate_schedule_id pa_projects_all.job_bill_rate_schedule_id%TYPE; -- store job bill rate
134: -- schedule id
135: l_project_org_id pa_projects_all.org_id%TYPE;
136:
137: /* Added for MCB2 */
138: l_txn_bill_rate NUMBER :=null; -- store bill amount transaction curr.
139: l_txn_raw_revenue NUMBER :=null; -- store the raw revenue trans. curr.

Line 142: l_projfunc_currency_code pa_projects_all.projfunc_currency_code%TYPE;

138: l_txn_bill_rate NUMBER :=null; -- store bill amount transaction curr.
139: l_txn_raw_revenue NUMBER :=null; -- store the raw revenue trans. curr.
140: l_rate_currency_code pa_bill_rates_all.rate_currency_code%TYPE;
141:
142: l_projfunc_currency_code pa_projects_all.projfunc_currency_code%TYPE;
143: l_markup_percentage pa_bill_rates_all.markup_percentage%TYPE; /* Added for Asgmt overide */
144: l_assignment_precedes_task pa_projects_all.assign_precedes_task%TYPE; /* Added for Asgmt overide */
145:
146: l_revenue_calculated_flag VARCHAR2(1); /* Added for bug 2212852, if it is Y means it has calculated

Line 144: l_assignment_precedes_task pa_projects_all.assign_precedes_task%TYPE; /* Added for Asgmt overide */

140: l_rate_currency_code pa_bill_rates_all.rate_currency_code%TYPE;
141:
142: l_projfunc_currency_code pa_projects_all.projfunc_currency_code%TYPE;
143: l_markup_percentage pa_bill_rates_all.markup_percentage%TYPE; /* Added for Asgmt overide */
144: l_assignment_precedes_task pa_projects_all.assign_precedes_task%TYPE; /* Added for Asgmt overide */
145:
146: l_revenue_calculated_flag VARCHAR2(1); /* Added for bug 2212852, if it is Y means it has calculated
147: the revenue from client extension */
148: l_item_quantity pa_forecast_items.item_quantity%TYPE; /* Added for bug 2212852 */

Line 281: FROM pa_projects_all

277: INTO l_labor_schdl_discnt,l_labor_bill_rate_org_id,l_labor_std_bill_rate_schdl,
278: l_labor_schdl_fixed_date,l_labor_sch_type,l_job_bill_rate_schedule_id,l_project_org_id,
279: l_projfunc_currency_code, /* Added the following columns for MCB2 */
280: l_assignment_precedes_task
281: FROM pa_projects_all
282: WHERE project_id = p_project_id;
283:
284:
285: EXCEPTION

Line 774: l_bill_job_grp_id pa_projects_all.bill_job_group_id%TYPE; -- store bill job group id

770: l_labor_std_bill_rate_schdl VARCHAR2(20); -- store labor standard bill rate schedule
771: l_labor_schdl_fixed_date DATE; -- store labor schedule fixed date
772: l_labor_sch_type VARCHAR2(1); -- store labor schedule type
773: l_expenditure_currency_code gl_sets_of_books.currency_code%TYPE := null;
774: l_bill_job_grp_id pa_projects_all.bill_job_group_id%TYPE; -- store bill job group id
775: l_project_org_id pa_projects_all.org_id%TYPE; -- store project org id
776: l_rev_currency_code pa_projects_all.project_currency_code%TYPE; -- store revenue currency code
777: l_emp_bill_rate_schedule_id NUMBER;
778: l_job_bill_rate_schedule_id NUMBER;

Line 775: l_project_org_id pa_projects_all.org_id%TYPE; -- store project org id

771: l_labor_schdl_fixed_date DATE; -- store labor schedule fixed date
772: l_labor_sch_type VARCHAR2(1); -- store labor schedule type
773: l_expenditure_currency_code gl_sets_of_books.currency_code%TYPE := null;
774: l_bill_job_grp_id pa_projects_all.bill_job_group_id%TYPE; -- store bill job group id
775: l_project_org_id pa_projects_all.org_id%TYPE; -- store project org id
776: l_rev_currency_code pa_projects_all.project_currency_code%TYPE; -- store revenue currency code
777: l_emp_bill_rate_schedule_id NUMBER;
778: l_job_bill_rate_schedule_id NUMBER;
779:

Line 776: l_rev_currency_code pa_projects_all.project_currency_code%TYPE; -- store revenue currency code

772: l_labor_sch_type VARCHAR2(1); -- store labor schedule type
773: l_expenditure_currency_code gl_sets_of_books.currency_code%TYPE := null;
774: l_bill_job_grp_id pa_projects_all.bill_job_group_id%TYPE; -- store bill job group id
775: l_project_org_id pa_projects_all.org_id%TYPE; -- store project org id
776: l_rev_currency_code pa_projects_all.project_currency_code%TYPE; -- store revenue currency code
777: l_emp_bill_rate_schedule_id NUMBER;
778: l_job_bill_rate_schedule_id NUMBER;
779:
780: /* Added for MCB2 */

Line 785: l_projfunc_currency_code pa_projects_all.projfunc_currency_code%TYPE;

781: l_txn_bill_rate NUMBER :=null; -- store bill amount transaction curr.
782: l_txn_raw_revenue NUMBER :=null; -- store the raw revenue trans. curr.
783: l_rate_currency_code pa_bill_rates_all.rate_currency_code%TYPE;
784:
785: l_projfunc_currency_code pa_projects_all.projfunc_currency_code%TYPE;
786:
787: l_markup_percentage pa_bill_rates_all.markup_percentage%TYPE; /* Added for Asgmt overide */
788: l_assignment_precedes_task pa_projects_all.assign_precedes_task%TYPE; /* Added for Asgmt overide */
789:

Line 788: l_assignment_precedes_task pa_projects_all.assign_precedes_task%TYPE; /* Added for Asgmt overide */

784:
785: l_projfunc_currency_code pa_projects_all.projfunc_currency_code%TYPE;
786:
787: l_markup_percentage pa_bill_rates_all.markup_percentage%TYPE; /* Added for Asgmt overide */
788: l_assignment_precedes_task pa_projects_all.assign_precedes_task%TYPE; /* Added for Asgmt overide */
789:
790: l_revenue_calculated_flag VARCHAR2(1); /* Added for bug 2212852, if it is Y means it has calculated
791: the revenue from client extension */
792: l_item_quantity pa_forecast_items.item_quantity%TYPE; /* Added for bug 2212852 */

Line 833: /* Bug 2668753 : Get the BTC_COST_BASE_REV_CODE from pa_projects_all table */

829: IF P_called_process ='TASK_LEVEL_PLANNING' THEN
830: l_called_process :=2;
831: END IF;
832:
833: /* Bug 2668753 : Get the BTC_COST_BASE_REV_CODE from pa_projects_all table */
834: IF ( nvl(p_mcb_flag,'N') = 'Y' ) THEN
835: BEGIN
836: /* Added the following nvl so that code doesn't break even if upgrade script fails - For bug 2668753 */
837:

Line 840: from pa_projects_all

836: /* Added the following nvl so that code doesn't break even if upgrade script fails - For bug 2668753 */
837:
838: select nvl(BTC_COST_BASE_REV_CODE,'EXP_TRANS_CURR')
839: into l_mcb_cost_flag
840: from pa_projects_all
841: where project_id = p_project_id;
842:
843: EXCEPTION
844: WHEN NO_DATA_FOUND THEN

Line 884: FROM pa_projects_all

880: IF (p_project_id IS NOT NULL and p_called_process is NULL) THEN
881: BEGIN
882: SELECT projfunc_currency_code
883: INTO l_rev_currency_code
884: FROM pa_projects_all
885: WHERE project_id = p_project_id;
886: x_rev_currency_code := l_rev_currency_code;
887: EXCEPTION
888: WHEN NO_DATA_FOUND THEN

Line 1002: FROM pa_projects_all

998: l_labor_schdl_fixed_date,l_labor_sch_type,l_bill_job_grp_id,l_project_org_id,
999: l_emp_bill_rate_schedule_id,l_job_bill_rate_schedule_id,
1000: l_projfunc_currency_code, /* Added the following columns for MCB2 */
1001: l_assignment_precedes_task
1002: FROM pa_projects_all
1003: WHERE project_id = p_project_id;
1004:
1005: EXCEPTION
1006: WHEN NO_DATA_FOUND THEN

Line 2428: l_projfunc_currency_code PA_PROJECTS_ALL.projfunc_currency_code%TYPE;

2424: l_converted_project_rev_amount NUMBER;
2425: l_converted_project_bill_rate NUMBER :=null;
2426: l_conversion_project_date DATE; -- store item date
2427:
2428: l_projfunc_currency_code PA_PROJECTS_ALL.projfunc_currency_code%TYPE;
2429: l_projfunc_bil_rate_date_code PA_PROJECTS_ALL.projfunc_bil_rate_date_code%TYPE;
2430: l_projfunc_bil_rate_type PA_PROJECTS_ALL.projfunc_bil_rate_type%TYPE;
2431: l_projfunc_bil_rate_date PA_PROJECTS_ALL.projfunc_bil_rate_date%TYPE;
2432: l_projfunc_bil_exchange_rate PA_PROJECTS_ALL.projfunc_bil_exchange_rate%TYPE;

Line 2429: l_projfunc_bil_rate_date_code PA_PROJECTS_ALL.projfunc_bil_rate_date_code%TYPE;

2425: l_converted_project_bill_rate NUMBER :=null;
2426: l_conversion_project_date DATE; -- store item date
2427:
2428: l_projfunc_currency_code PA_PROJECTS_ALL.projfunc_currency_code%TYPE;
2429: l_projfunc_bil_rate_date_code PA_PROJECTS_ALL.projfunc_bil_rate_date_code%TYPE;
2430: l_projfunc_bil_rate_type PA_PROJECTS_ALL.projfunc_bil_rate_type%TYPE;
2431: l_projfunc_bil_rate_date PA_PROJECTS_ALL.projfunc_bil_rate_date%TYPE;
2432: l_projfunc_bil_exchange_rate PA_PROJECTS_ALL.projfunc_bil_exchange_rate%TYPE;
2433:

Line 2430: l_projfunc_bil_rate_type PA_PROJECTS_ALL.projfunc_bil_rate_type%TYPE;

2426: l_conversion_project_date DATE; -- store item date
2427:
2428: l_projfunc_currency_code PA_PROJECTS_ALL.projfunc_currency_code%TYPE;
2429: l_projfunc_bil_rate_date_code PA_PROJECTS_ALL.projfunc_bil_rate_date_code%TYPE;
2430: l_projfunc_bil_rate_type PA_PROJECTS_ALL.projfunc_bil_rate_type%TYPE;
2431: l_projfunc_bil_rate_date PA_PROJECTS_ALL.projfunc_bil_rate_date%TYPE;
2432: l_projfunc_bil_exchange_rate PA_PROJECTS_ALL.projfunc_bil_exchange_rate%TYPE;
2433:
2434: l_project_currency_code PA_PROJECTS_ALL.project_currency_code%TYPE;

Line 2431: l_projfunc_bil_rate_date PA_PROJECTS_ALL.projfunc_bil_rate_date%TYPE;

2427:
2428: l_projfunc_currency_code PA_PROJECTS_ALL.projfunc_currency_code%TYPE;
2429: l_projfunc_bil_rate_date_code PA_PROJECTS_ALL.projfunc_bil_rate_date_code%TYPE;
2430: l_projfunc_bil_rate_type PA_PROJECTS_ALL.projfunc_bil_rate_type%TYPE;
2431: l_projfunc_bil_rate_date PA_PROJECTS_ALL.projfunc_bil_rate_date%TYPE;
2432: l_projfunc_bil_exchange_rate PA_PROJECTS_ALL.projfunc_bil_exchange_rate%TYPE;
2433:
2434: l_project_currency_code PA_PROJECTS_ALL.project_currency_code%TYPE;
2435: l_project_bil_rate_date_code PA_PROJECTS_ALL.project_bil_rate_date_code%TYPE;

Line 2432: l_projfunc_bil_exchange_rate PA_PROJECTS_ALL.projfunc_bil_exchange_rate%TYPE;

2428: l_projfunc_currency_code PA_PROJECTS_ALL.projfunc_currency_code%TYPE;
2429: l_projfunc_bil_rate_date_code PA_PROJECTS_ALL.projfunc_bil_rate_date_code%TYPE;
2430: l_projfunc_bil_rate_type PA_PROJECTS_ALL.projfunc_bil_rate_type%TYPE;
2431: l_projfunc_bil_rate_date PA_PROJECTS_ALL.projfunc_bil_rate_date%TYPE;
2432: l_projfunc_bil_exchange_rate PA_PROJECTS_ALL.projfunc_bil_exchange_rate%TYPE;
2433:
2434: l_project_currency_code PA_PROJECTS_ALL.project_currency_code%TYPE;
2435: l_project_bil_rate_date_code PA_PROJECTS_ALL.project_bil_rate_date_code%TYPE;
2436: l_project_bil_rate_type PA_PROJECTS_ALL.project_bil_rate_type%TYPE;

Line 2434: l_project_currency_code PA_PROJECTS_ALL.project_currency_code%TYPE;

2430: l_projfunc_bil_rate_type PA_PROJECTS_ALL.projfunc_bil_rate_type%TYPE;
2431: l_projfunc_bil_rate_date PA_PROJECTS_ALL.projfunc_bil_rate_date%TYPE;
2432: l_projfunc_bil_exchange_rate PA_PROJECTS_ALL.projfunc_bil_exchange_rate%TYPE;
2433:
2434: l_project_currency_code PA_PROJECTS_ALL.project_currency_code%TYPE;
2435: l_project_bil_rate_date_code PA_PROJECTS_ALL.project_bil_rate_date_code%TYPE;
2436: l_project_bil_rate_type PA_PROJECTS_ALL.project_bil_rate_type%TYPE;
2437: l_project_bil_rate_date PA_PROJECTS_ALL.project_bil_rate_date%TYPE;
2438: l_project_bil_exchange_rate PA_PROJECTS_ALL.project_bil_exchange_rate%TYPE;

Line 2435: l_project_bil_rate_date_code PA_PROJECTS_ALL.project_bil_rate_date_code%TYPE;

2431: l_projfunc_bil_rate_date PA_PROJECTS_ALL.projfunc_bil_rate_date%TYPE;
2432: l_projfunc_bil_exchange_rate PA_PROJECTS_ALL.projfunc_bil_exchange_rate%TYPE;
2433:
2434: l_project_currency_code PA_PROJECTS_ALL.project_currency_code%TYPE;
2435: l_project_bil_rate_date_code PA_PROJECTS_ALL.project_bil_rate_date_code%TYPE;
2436: l_project_bil_rate_type PA_PROJECTS_ALL.project_bil_rate_type%TYPE;
2437: l_project_bil_rate_date PA_PROJECTS_ALL.project_bil_rate_date%TYPE;
2438: l_project_bil_exchange_rate PA_PROJECTS_ALL.project_bil_exchange_rate%TYPE;
2439:

Line 2436: l_project_bil_rate_type PA_PROJECTS_ALL.project_bil_rate_type%TYPE;

2432: l_projfunc_bil_exchange_rate PA_PROJECTS_ALL.projfunc_bil_exchange_rate%TYPE;
2433:
2434: l_project_currency_code PA_PROJECTS_ALL.project_currency_code%TYPE;
2435: l_project_bil_rate_date_code PA_PROJECTS_ALL.project_bil_rate_date_code%TYPE;
2436: l_project_bil_rate_type PA_PROJECTS_ALL.project_bil_rate_type%TYPE;
2437: l_project_bil_rate_date PA_PROJECTS_ALL.project_bil_rate_date%TYPE;
2438: l_project_bil_exchange_rate PA_PROJECTS_ALL.project_bil_exchange_rate%TYPE;
2439:
2440:

Line 2437: l_project_bil_rate_date PA_PROJECTS_ALL.project_bil_rate_date%TYPE;

2433:
2434: l_project_currency_code PA_PROJECTS_ALL.project_currency_code%TYPE;
2435: l_project_bil_rate_date_code PA_PROJECTS_ALL.project_bil_rate_date_code%TYPE;
2436: l_project_bil_rate_type PA_PROJECTS_ALL.project_bil_rate_type%TYPE;
2437: l_project_bil_rate_date PA_PROJECTS_ALL.project_bil_rate_date%TYPE;
2438: l_project_bil_exchange_rate PA_PROJECTS_ALL.project_bil_exchange_rate%TYPE;
2439:
2440:
2441: /* ATG Changes */

Line 2438: l_project_bil_exchange_rate PA_PROJECTS_ALL.project_bil_exchange_rate%TYPE;

2434: l_project_currency_code PA_PROJECTS_ALL.project_currency_code%TYPE;
2435: l_project_bil_rate_date_code PA_PROJECTS_ALL.project_bil_rate_date_code%TYPE;
2436: l_project_bil_rate_type PA_PROJECTS_ALL.project_bil_rate_type%TYPE;
2437: l_project_bil_rate_date PA_PROJECTS_ALL.project_bil_rate_date%TYPE;
2438: l_project_bil_exchange_rate PA_PROJECTS_ALL.project_bil_exchange_rate%TYPE;
2439:
2440:
2441: /* ATG Changes */
2442:

Line 2859: /* Bug 2668753 : Get the BTC_COST_BASE_REV_CODE from pa_projects_all table */

2855: otherwise following the steps given below { */
2856:
2857: /* Changes for bug 2668753 */
2858:
2859: /* Bug 2668753 : Get the BTC_COST_BASE_REV_CODE from pa_projects_all table */
2860: IF ( nvl(p_mcb_flag,'N') = 'Y' ) THEN
2861: BEGIN
2862:
2863: /* Added the following nvl so that code does not break even when upgrade script fails-bug 2742778 */

Line 2867: from pa_projects_all

2863: /* Added the following nvl so that code does not break even when upgrade script fails-bug 2742778 */
2864:
2865: select nvl(BTC_COST_BASE_REV_CODE,'EXP_TRANS_CURR')
2866: into l_mcb_cost_flag
2867: from pa_projects_all
2868: where project_id = p_project_id;
2869:
2870: EXCEPTION
2871: WHEN NO_DATA_FOUND THEN

Line 3321: FROM pa_projects_all

3317: /* Commenting out the below select statements as the schedule ids are now passed as input
3318: parameters to the function */
3319: /* SELECT non_lab_std_bill_rt_sch_id
3320: into l_proj_std_bill_rate_sch_id
3321: FROM pa_projects_all
3322: WHERE project_id=p_project_id;
3323:
3324: SELECT non_lab_std_bill_rt_sch_id
3325: into l_task_std_bill_rate_sch_id