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 272: FROM pa_projects_all

268: INTO l_labor_schdl_discnt,l_labor_bill_rate_org_id,l_labor_std_bill_rate_schdl,
269: l_labor_schdl_fixed_date,l_labor_sch_type,l_job_bill_rate_schedule_id,l_project_org_id,
270: l_projfunc_currency_code, /* Added the following columns for MCB2 */
271: l_assignment_precedes_task
272: FROM pa_projects_all
273: WHERE project_id = p_project_id;
274:
275:
276: EXCEPTION

Line 765: l_bill_job_grp_id pa_projects_all.bill_job_group_id%TYPE; -- store bill job group 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
766: l_project_org_id pa_projects_all.org_id%TYPE; -- store project org id
767: l_rev_currency_code pa_projects_all.project_currency_code%TYPE; -- store revenue currency code
768: l_emp_bill_rate_schedule_id NUMBER;
769: l_job_bill_rate_schedule_id NUMBER;

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

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
766: l_project_org_id pa_projects_all.org_id%TYPE; -- store project org id
767: l_rev_currency_code pa_projects_all.project_currency_code%TYPE; -- store revenue currency code
768: l_emp_bill_rate_schedule_id NUMBER;
769: l_job_bill_rate_schedule_id NUMBER;
770:

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

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
766: l_project_org_id pa_projects_all.org_id%TYPE; -- store project org id
767: l_rev_currency_code pa_projects_all.project_currency_code%TYPE; -- store revenue currency code
768: l_emp_bill_rate_schedule_id NUMBER;
769: l_job_bill_rate_schedule_id NUMBER;
770:
771: /* Added for MCB2 */

Line 776: l_projfunc_currency_code pa_projects_all.projfunc_currency_code%TYPE;

772: l_txn_bill_rate NUMBER :=null; -- store bill amount transaction curr.
773: l_txn_raw_revenue NUMBER :=null; -- store the raw revenue trans. curr.
774: l_rate_currency_code pa_bill_rates_all.rate_currency_code%TYPE;
775:
776: l_projfunc_currency_code pa_projects_all.projfunc_currency_code%TYPE;
777:
778: l_markup_percentage pa_bill_rates_all.markup_percentage%TYPE; /* Added for Asgmt overide */
779: l_assignment_precedes_task pa_projects_all.assign_precedes_task%TYPE; /* Added for Asgmt overide */
780:

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

775:
776: l_projfunc_currency_code pa_projects_all.projfunc_currency_code%TYPE;
777:
778: l_markup_percentage pa_bill_rates_all.markup_percentage%TYPE; /* Added for Asgmt overide */
779: l_assignment_precedes_task pa_projects_all.assign_precedes_task%TYPE; /* Added for Asgmt overide */
780:
781: l_revenue_calculated_flag VARCHAR2(1); /* Added for bug 2212852, if it is Y means it has calculated
782: the revenue from client extension */
783: l_item_quantity pa_forecast_items.item_quantity%TYPE; /* Added for bug 2212852 */

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

820: IF P_called_process ='TASK_LEVEL_PLANNING' THEN
821: l_called_process :=2;
822: END IF;
823:
824: /* Bug 2668753 : Get the BTC_COST_BASE_REV_CODE from pa_projects_all table */
825: IF ( nvl(p_mcb_flag,'N') = 'Y' ) THEN
826: BEGIN
827: /* Added the following nvl so that code doesn't break even if upgrade script fails - For bug 2668753 */
828:

Line 831: from pa_projects_all

827: /* Added the following nvl so that code doesn't break even if upgrade script fails - For bug 2668753 */
828:
829: select nvl(BTC_COST_BASE_REV_CODE,'EXP_TRANS_CURR')
830: into l_mcb_cost_flag
831: from pa_projects_all
832: where project_id = p_project_id;
833:
834: EXCEPTION
835: WHEN NO_DATA_FOUND THEN

Line 875: FROM pa_projects_all

871: IF (p_project_id IS NOT NULL and p_called_process is NULL) THEN
872: BEGIN
873: SELECT projfunc_currency_code
874: INTO l_rev_currency_code
875: FROM pa_projects_all
876: WHERE project_id = p_project_id;
877: x_rev_currency_code := l_rev_currency_code;
878: EXCEPTION
879: WHEN NO_DATA_FOUND THEN

Line 983: FROM pa_projects_all

979: l_labor_schdl_fixed_date,l_labor_sch_type,l_bill_job_grp_id,l_project_org_id,
980: l_emp_bill_rate_schedule_id,l_job_bill_rate_schedule_id,
981: l_projfunc_currency_code, /* Added the following columns for MCB2 */
982: l_assignment_precedes_task
983: FROM pa_projects_all
984: WHERE project_id = p_project_id;
985:
986: EXCEPTION
987: WHEN NO_DATA_FOUND THEN

Line 2408: l_projfunc_currency_code PA_PROJECTS_ALL.projfunc_currency_code%TYPE;

2404: l_converted_project_rev_amount NUMBER;
2405: l_converted_project_bill_rate NUMBER :=null;
2406: l_conversion_project_date DATE; -- store item date
2407:
2408: l_projfunc_currency_code PA_PROJECTS_ALL.projfunc_currency_code%TYPE;
2409: l_projfunc_bil_rate_date_code PA_PROJECTS_ALL.projfunc_bil_rate_date_code%TYPE;
2410: l_projfunc_bil_rate_type PA_PROJECTS_ALL.projfunc_bil_rate_type%TYPE;
2411: l_projfunc_bil_rate_date PA_PROJECTS_ALL.projfunc_bil_rate_date%TYPE;
2412: l_projfunc_bil_exchange_rate PA_PROJECTS_ALL.projfunc_bil_exchange_rate%TYPE;

Line 2409: l_projfunc_bil_rate_date_code PA_PROJECTS_ALL.projfunc_bil_rate_date_code%TYPE;

2405: l_converted_project_bill_rate NUMBER :=null;
2406: l_conversion_project_date DATE; -- store item date
2407:
2408: l_projfunc_currency_code PA_PROJECTS_ALL.projfunc_currency_code%TYPE;
2409: l_projfunc_bil_rate_date_code PA_PROJECTS_ALL.projfunc_bil_rate_date_code%TYPE;
2410: l_projfunc_bil_rate_type PA_PROJECTS_ALL.projfunc_bil_rate_type%TYPE;
2411: l_projfunc_bil_rate_date PA_PROJECTS_ALL.projfunc_bil_rate_date%TYPE;
2412: l_projfunc_bil_exchange_rate PA_PROJECTS_ALL.projfunc_bil_exchange_rate%TYPE;
2413:

Line 2410: l_projfunc_bil_rate_type PA_PROJECTS_ALL.projfunc_bil_rate_type%TYPE;

2406: l_conversion_project_date DATE; -- store item date
2407:
2408: l_projfunc_currency_code PA_PROJECTS_ALL.projfunc_currency_code%TYPE;
2409: l_projfunc_bil_rate_date_code PA_PROJECTS_ALL.projfunc_bil_rate_date_code%TYPE;
2410: l_projfunc_bil_rate_type PA_PROJECTS_ALL.projfunc_bil_rate_type%TYPE;
2411: l_projfunc_bil_rate_date PA_PROJECTS_ALL.projfunc_bil_rate_date%TYPE;
2412: l_projfunc_bil_exchange_rate PA_PROJECTS_ALL.projfunc_bil_exchange_rate%TYPE;
2413:
2414: l_project_currency_code PA_PROJECTS_ALL.project_currency_code%TYPE;

Line 2411: l_projfunc_bil_rate_date PA_PROJECTS_ALL.projfunc_bil_rate_date%TYPE;

2407:
2408: l_projfunc_currency_code PA_PROJECTS_ALL.projfunc_currency_code%TYPE;
2409: l_projfunc_bil_rate_date_code PA_PROJECTS_ALL.projfunc_bil_rate_date_code%TYPE;
2410: l_projfunc_bil_rate_type PA_PROJECTS_ALL.projfunc_bil_rate_type%TYPE;
2411: l_projfunc_bil_rate_date PA_PROJECTS_ALL.projfunc_bil_rate_date%TYPE;
2412: l_projfunc_bil_exchange_rate PA_PROJECTS_ALL.projfunc_bil_exchange_rate%TYPE;
2413:
2414: l_project_currency_code PA_PROJECTS_ALL.project_currency_code%TYPE;
2415: l_project_bil_rate_date_code PA_PROJECTS_ALL.project_bil_rate_date_code%TYPE;

Line 2412: l_projfunc_bil_exchange_rate PA_PROJECTS_ALL.projfunc_bil_exchange_rate%TYPE;

2408: l_projfunc_currency_code PA_PROJECTS_ALL.projfunc_currency_code%TYPE;
2409: l_projfunc_bil_rate_date_code PA_PROJECTS_ALL.projfunc_bil_rate_date_code%TYPE;
2410: l_projfunc_bil_rate_type PA_PROJECTS_ALL.projfunc_bil_rate_type%TYPE;
2411: l_projfunc_bil_rate_date PA_PROJECTS_ALL.projfunc_bil_rate_date%TYPE;
2412: l_projfunc_bil_exchange_rate PA_PROJECTS_ALL.projfunc_bil_exchange_rate%TYPE;
2413:
2414: l_project_currency_code PA_PROJECTS_ALL.project_currency_code%TYPE;
2415: l_project_bil_rate_date_code PA_PROJECTS_ALL.project_bil_rate_date_code%TYPE;
2416: l_project_bil_rate_type PA_PROJECTS_ALL.project_bil_rate_type%TYPE;

Line 2414: l_project_currency_code PA_PROJECTS_ALL.project_currency_code%TYPE;

2410: l_projfunc_bil_rate_type PA_PROJECTS_ALL.projfunc_bil_rate_type%TYPE;
2411: l_projfunc_bil_rate_date PA_PROJECTS_ALL.projfunc_bil_rate_date%TYPE;
2412: l_projfunc_bil_exchange_rate PA_PROJECTS_ALL.projfunc_bil_exchange_rate%TYPE;
2413:
2414: l_project_currency_code PA_PROJECTS_ALL.project_currency_code%TYPE;
2415: l_project_bil_rate_date_code PA_PROJECTS_ALL.project_bil_rate_date_code%TYPE;
2416: l_project_bil_rate_type PA_PROJECTS_ALL.project_bil_rate_type%TYPE;
2417: l_project_bil_rate_date PA_PROJECTS_ALL.project_bil_rate_date%TYPE;
2418: l_project_bil_exchange_rate PA_PROJECTS_ALL.project_bil_exchange_rate%TYPE;

Line 2415: l_project_bil_rate_date_code PA_PROJECTS_ALL.project_bil_rate_date_code%TYPE;

2411: l_projfunc_bil_rate_date PA_PROJECTS_ALL.projfunc_bil_rate_date%TYPE;
2412: l_projfunc_bil_exchange_rate PA_PROJECTS_ALL.projfunc_bil_exchange_rate%TYPE;
2413:
2414: l_project_currency_code PA_PROJECTS_ALL.project_currency_code%TYPE;
2415: l_project_bil_rate_date_code PA_PROJECTS_ALL.project_bil_rate_date_code%TYPE;
2416: l_project_bil_rate_type PA_PROJECTS_ALL.project_bil_rate_type%TYPE;
2417: l_project_bil_rate_date PA_PROJECTS_ALL.project_bil_rate_date%TYPE;
2418: l_project_bil_exchange_rate PA_PROJECTS_ALL.project_bil_exchange_rate%TYPE;
2419:

Line 2416: l_project_bil_rate_type PA_PROJECTS_ALL.project_bil_rate_type%TYPE;

2412: l_projfunc_bil_exchange_rate PA_PROJECTS_ALL.projfunc_bil_exchange_rate%TYPE;
2413:
2414: l_project_currency_code PA_PROJECTS_ALL.project_currency_code%TYPE;
2415: l_project_bil_rate_date_code PA_PROJECTS_ALL.project_bil_rate_date_code%TYPE;
2416: l_project_bil_rate_type PA_PROJECTS_ALL.project_bil_rate_type%TYPE;
2417: l_project_bil_rate_date PA_PROJECTS_ALL.project_bil_rate_date%TYPE;
2418: l_project_bil_exchange_rate PA_PROJECTS_ALL.project_bil_exchange_rate%TYPE;
2419:
2420:

Line 2417: l_project_bil_rate_date PA_PROJECTS_ALL.project_bil_rate_date%TYPE;

2413:
2414: l_project_currency_code PA_PROJECTS_ALL.project_currency_code%TYPE;
2415: l_project_bil_rate_date_code PA_PROJECTS_ALL.project_bil_rate_date_code%TYPE;
2416: l_project_bil_rate_type PA_PROJECTS_ALL.project_bil_rate_type%TYPE;
2417: l_project_bil_rate_date PA_PROJECTS_ALL.project_bil_rate_date%TYPE;
2418: l_project_bil_exchange_rate PA_PROJECTS_ALL.project_bil_exchange_rate%TYPE;
2419:
2420:
2421: /* ATG Changes */

Line 2418: l_project_bil_exchange_rate PA_PROJECTS_ALL.project_bil_exchange_rate%TYPE;

2414: l_project_currency_code PA_PROJECTS_ALL.project_currency_code%TYPE;
2415: l_project_bil_rate_date_code PA_PROJECTS_ALL.project_bil_rate_date_code%TYPE;
2416: l_project_bil_rate_type PA_PROJECTS_ALL.project_bil_rate_type%TYPE;
2417: l_project_bil_rate_date PA_PROJECTS_ALL.project_bil_rate_date%TYPE;
2418: l_project_bil_exchange_rate PA_PROJECTS_ALL.project_bil_exchange_rate%TYPE;
2419:
2420:
2421: /* ATG Changes */
2422:

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

2835: otherwise following the steps given below { */
2836:
2837: /* Changes for bug 2668753 */
2838:
2839: /* Bug 2668753 : Get the BTC_COST_BASE_REV_CODE from pa_projects_all table */
2840: IF ( nvl(p_mcb_flag,'N') = 'Y' ) THEN
2841: BEGIN
2842:
2843: /* Added the following nvl so that code does not break even when upgrade script fails-bug 2742778 */

Line 2847: from pa_projects_all

2843: /* Added the following nvl so that code does not break even when upgrade script fails-bug 2742778 */
2844:
2845: select nvl(BTC_COST_BASE_REV_CODE,'EXP_TRANS_CURR')
2846: into l_mcb_cost_flag
2847: from pa_projects_all
2848: where project_id = p_project_id;
2849:
2850: EXCEPTION
2851: WHEN NO_DATA_FOUND THEN

Line 3295: FROM pa_projects_all

3291: /* Commenting out the below select statements as the schedule ids are now passed as input
3292: parameters to the function */
3293: /* SELECT non_lab_std_bill_rt_sch_id
3294: into l_proj_std_bill_rate_sch_id
3295: FROM pa_projects_all
3296: WHERE project_id=p_project_id;
3297:
3298: SELECT non_lab_std_bill_rt_sch_id
3299: into l_task_std_bill_rate_sch_id