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_AMT dependencies on PA_EXPENDITURE_ITEMS_ALL

Line 8: -- pa_expenditure_items_all table.

4: -- 1. Procedure calls the client labor billing extension for calculating
5: -- bill amount
6: -- 2. Procedure calls the IRS api for populating raw revenue
7: -- and bill amount, irs rate sch rev id for revenue/invoice in
8: -- pa_expenditure_items_all table.
9: -- This procedure verifies whether 'Indirect rate schedule'
10: -- this applicable for an ei or not and if applicable then it calls the
11: -- cost plus api to compute the Indirect amount which later on gets added
12: -- to raw revenue and bill amount.

Line 116: WHERE project_id =(select project_id from pa_expenditure_items_all

112:
113: SELECT nvl(BTC_COST_BASE_REV_CODE,'EXP_TRANS_CURR')
114: INTO l_mcb_cost_flag
115: FROM pa_projects_all
116: WHERE project_id =(select project_id from pa_expenditure_items_all
117: where expenditure_item_id=ei_id(1));
118: EXCEPTION
119: WHEN NO_DATA_FOUND THEN
120: IF g1_debug_mode = 'Y' THEN

Line 382: where project_id =(select project_id from pa_expenditure_items_all where expenditure_item_id=ei_id(j));

378:
379: select BTC_COST_BASE_REV_CODE
380: into l_mcb_cost_flag
381: from pa_projects_all
382: where project_id =(select project_id from pa_expenditure_items_all where expenditure_item_id=ei_id(j));
383:
384: EXCEPTION
385: WHEN NO_DATA_FOUND THEN
386: IF g1_debug_mode = 'Y' THEN

Line 549: where project_id =(select project_id from pa_expenditure_items_all where expenditure_item_id=ei_id(j));

545:
546: select BTC_COST_BASE_REV_CODE
547: into l_mcb_cost_flag
548: from pa_projects_all
549: where project_id =(select project_id from pa_expenditure_items_all where expenditure_item_id=ei_id(j));
550:
551: EXCEPTION
552: WHEN NO_DATA_FOUND THEN
553: IF g1_debug_mode = 'Y' THEN

Line 612: pa_expenditure_items_all table.

608: inv_amount( j ) := NULL;
609: END IF;
610: /*-----------------------------------------------------------------------------
611: Rejection code error message which would be eventually populated in
612: pa_expenditure_items_all table.
613: ----------------------------------------------------------------------------*/
614:
615: IF ( insert_error_message ) THEN
616: IF (stage = 200) THEN

Line 759: FROM pa_expenditure_items_all x,

755: AND t.project_id = dr.project_id
756: AND dr.request_id = p_request_id
757: AND EXISTS
758: ( SELECT NULL
759: FROM pa_expenditure_items_all x,
760: pa_cust_rev_dist_lines_all rdl
761: WHERE x.request_id+0 = dr.request_id
762: AND x.task_id = t.task_id
763: AND x.revenue_distributed_flag||'' = 'A'

Line 784: FROM pa_expenditure_items_all ei2,

780: AND dr2.project_id = p_project_id
781: AND dr2.request_id+0 = p_request_id
782: AND EXISTS
783: ( SELECT NULL
784: FROM pa_expenditure_items_all ei2,
785: pa_cust_rev_dist_lines_all rdl2
786: WHERE ei2.request_id = rdl2.request_id
787: AND rdl2.expenditure_item_id = ei2.expenditure_item_id
788: AND ei2.raw_revenue is not NULL

Line 821: from pa_cust_rev_dist_lines_all rdl,pa_expenditure_items_all ei,

817: rdl.draft_revenue_item_line_num,
818: rdl.draft_revenue_num,
819: ei.accrued_revenue ,
820: ei.raw_revenue
821: from pa_cust_rev_dist_lines_all rdl,pa_expenditure_items_all ei,
822: pa_tasks t
823: where p_top_task_id is not NULL
824: AND ei.request_id+0 = p_request_id
825: AND ei.raw_revenue is not NULL

Line 845: from pa_cust_rev_dist_lines_all rdl,pa_expenditure_items_all ei

841: rdl.draft_revenue_item_line_num,
842: rdl.draft_revenue_num,
843: ei.accrued_revenue ,
844: ei.raw_revenue
845: from pa_cust_rev_dist_lines_all rdl,pa_expenditure_items_all ei
846: where p_top_task_id is NULL
847: AND ei.request_id+0 = p_request_id
848: AND ei.raw_revenue is not NULL
849: AND ei.accrued_revenue is not NULL

Line 899: pa_expenditure_items_all ei ,

895: /*Modified the query for 9767275*/
896: select /*+ LEADING ( T ) ORDERED USE_NL ( T EI RDL ) INDEX ( RDL PA_CUST_REV_DIST_LINES_N1 ) */ 'X'
897: into dummy_x
898: from pa_tasks t ,
899: pa_expenditure_items_all ei ,
900: pa_cust_rev_dist_lines_all rdl
901: where ei.request_id+0 = p_request_id
902: AND ei.raw_revenue is not NULL
903: AND ei.accrued_revenue is not NULL

Line 923: from pa_expenditure_items_all ei ,

919:
920: /*Modified the query for 9767275*/
921: select /*+ LEADING(EI) ORDERED INDEX ( RDL PA_CUST_REV_DIST_LINES_N1 ) */ 'X'
922: into dummy_x
923: from pa_expenditure_items_all ei ,
924: pa_cust_rev_dist_lines_all rdl
925: where ei.request_id+0 = p_request_id
926: AND ei.raw_revenue is not NULL
927: AND ei.accrued_revenue is not NULL

Line 1038: l_message_code := 'Error in update on pa_expenditure_items_all';

1034: exp_cur_rec.DRAFT_REVENUE_NUM
1035: AND i.line_num =
1036: exp_cur_rec.DRAFT_REVENUE_ITEM_LINE_NUM;
1037:
1038: l_message_code := 'Error in update on pa_expenditure_items_all';
1039:
1040: UPDATE pa_expenditure_items_all x
1041: SET x.accrued_revenue
1042: = x.accrued_revenue - roundoff_amount

Line 1040: UPDATE pa_expenditure_items_all x

1036: exp_cur_rec.DRAFT_REVENUE_ITEM_LINE_NUM;
1037:
1038: l_message_code := 'Error in update on pa_expenditure_items_all';
1039:
1040: UPDATE pa_expenditure_items_all x
1041: SET x.accrued_revenue
1042: = x.accrued_revenue - roundoff_amount
1043: WHERE x.expenditure_item_id =
1044: exp_cur_rec.EXPENDITURE_ITEM_ID;