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.GMS_BILLING dependencies on PA_EXPENDITURE_ITEMS_ALL

Line 999: from pa_expenditure_items_all ei,

995: select /*+INDEX(pt PA_PROJECT_TYPES_U1)*/
996: ei.expenditure_item_id expenditure_item_id,
997: adl.adl_line_num adl_line_num,
998: adl.award_id award_id
999: from pa_expenditure_items_all ei,
1000: pa_expenditure_types et,
1001: pa_projects_all p,
1002: pa_project_types pt,
1003: pa_tasks t3,

Line 1038: update pa_expenditure_items_all

1034: and document_type='EXP'
1035: and adl_status = 'A';
1036: */
1037:
1038: update pa_expenditure_items_all
1039: set bill_hold_flag='N'
1040: where expenditure_item_id = Bill_Hold_Rec.expenditure_item_id;
1041:
1042: if sql%notfound then

Line 1385: from pa_expenditure_items_all ei,

1381: select --distinct
1382: adl.expenditure_item_id,
1383: adl.adl_line_num,
1384: adl.award_id
1385: from pa_expenditure_items_all ei,
1386: pa_projects_all p,
1387: pa_project_types pt,
1388: pa_tasks t3,
1389: pa_tasks t5,

Line 3448: from pa_expenditure_items_all peia,

3444: Begin
3445: -- Bug 3235390 : Added decode to get correct quantity
3446: Select SUM(NVL( DECODE(adl.line_num_reversed, NULL, peia.quantity,-1*peia.quantity),0))
3447: into x_qty
3448: from pa_expenditure_items_all peia,
3449: gms_event_intersect gei,
3450: gms_award_distributions adl
3451: where peia.expenditure_item_id = gei.expenditure_item_id
3452: and adl.expenditure_item_id = gei.expenditure_item_id

Line 4602: X_Expenditure_Item_Id PA_EXPENDITURE_ITEMS_ALL.EXPENDITURE_ITEM_ID%TYPE;

4598: X_New_Values Selected_Values_Rows;
4599:
4600: cur_select INTEGER := 0;
4601: X_Rows_Processed INTEGER := 0;
4602: X_Expenditure_Item_Id PA_EXPENDITURE_ITEMS_ALL.EXPENDITURE_ITEM_ID%TYPE;
4603: X_Expenditure_Item_Date PA_EXPENDITURE_ITEMS_ALL.EXPENDITURE_ITEM_DATE%TYPE;
4604: X_Task_Id PA_EXPENDITURE_ITEMS_ALL.TASK_ID%TYPE;
4605: X_Bill_Hold_Flag PA_EXPENDITURE_ITEMS_ALL.BILL_HOLD_FLAG%TYPE; --VARCHAR2(1);
4606: X_Billable_Flag PA_EXPENDITURE_ITEMS_ALL.BILLABLE_FLAG%TYPE; --VARCHAR2(1);

Line 4603: X_Expenditure_Item_Date PA_EXPENDITURE_ITEMS_ALL.EXPENDITURE_ITEM_DATE%TYPE;

4599:
4600: cur_select INTEGER := 0;
4601: X_Rows_Processed INTEGER := 0;
4602: X_Expenditure_Item_Id PA_EXPENDITURE_ITEMS_ALL.EXPENDITURE_ITEM_ID%TYPE;
4603: X_Expenditure_Item_Date PA_EXPENDITURE_ITEMS_ALL.EXPENDITURE_ITEM_DATE%TYPE;
4604: X_Task_Id PA_EXPENDITURE_ITEMS_ALL.TASK_ID%TYPE;
4605: X_Bill_Hold_Flag PA_EXPENDITURE_ITEMS_ALL.BILL_HOLD_FLAG%TYPE; --VARCHAR2(1);
4606: X_Billable_Flag PA_EXPENDITURE_ITEMS_ALL.BILLABLE_FLAG%TYPE; --VARCHAR2(1);
4607: X_Adjusted_Expenditure_Item_Id PA_EXPENDITURE_ITEMS_ALL.ADJUSTED_EXPENDITURE_ITEM_ID%TYPE;

Line 4604: X_Task_Id PA_EXPENDITURE_ITEMS_ALL.TASK_ID%TYPE;

4600: cur_select INTEGER := 0;
4601: X_Rows_Processed INTEGER := 0;
4602: X_Expenditure_Item_Id PA_EXPENDITURE_ITEMS_ALL.EXPENDITURE_ITEM_ID%TYPE;
4603: X_Expenditure_Item_Date PA_EXPENDITURE_ITEMS_ALL.EXPENDITURE_ITEM_DATE%TYPE;
4604: X_Task_Id PA_EXPENDITURE_ITEMS_ALL.TASK_ID%TYPE;
4605: X_Bill_Hold_Flag PA_EXPENDITURE_ITEMS_ALL.BILL_HOLD_FLAG%TYPE; --VARCHAR2(1);
4606: X_Billable_Flag PA_EXPENDITURE_ITEMS_ALL.BILLABLE_FLAG%TYPE; --VARCHAR2(1);
4607: X_Adjusted_Expenditure_Item_Id PA_EXPENDITURE_ITEMS_ALL.ADJUSTED_EXPENDITURE_ITEM_ID%TYPE;
4608: X_First_Indicator BOOLEAN := TRUE;

Line 4605: X_Bill_Hold_Flag PA_EXPENDITURE_ITEMS_ALL.BILL_HOLD_FLAG%TYPE; --VARCHAR2(1);

4601: X_Rows_Processed INTEGER := 0;
4602: X_Expenditure_Item_Id PA_EXPENDITURE_ITEMS_ALL.EXPENDITURE_ITEM_ID%TYPE;
4603: X_Expenditure_Item_Date PA_EXPENDITURE_ITEMS_ALL.EXPENDITURE_ITEM_DATE%TYPE;
4604: X_Task_Id PA_EXPENDITURE_ITEMS_ALL.TASK_ID%TYPE;
4605: X_Bill_Hold_Flag PA_EXPENDITURE_ITEMS_ALL.BILL_HOLD_FLAG%TYPE; --VARCHAR2(1);
4606: X_Billable_Flag PA_EXPENDITURE_ITEMS_ALL.BILLABLE_FLAG%TYPE; --VARCHAR2(1);
4607: X_Adjusted_Expenditure_Item_Id PA_EXPENDITURE_ITEMS_ALL.ADJUSTED_EXPENDITURE_ITEM_ID%TYPE;
4608: X_First_Indicator BOOLEAN := TRUE;
4609:

Line 4606: X_Billable_Flag PA_EXPENDITURE_ITEMS_ALL.BILLABLE_FLAG%TYPE; --VARCHAR2(1);

4602: X_Expenditure_Item_Id PA_EXPENDITURE_ITEMS_ALL.EXPENDITURE_ITEM_ID%TYPE;
4603: X_Expenditure_Item_Date PA_EXPENDITURE_ITEMS_ALL.EXPENDITURE_ITEM_DATE%TYPE;
4604: X_Task_Id PA_EXPENDITURE_ITEMS_ALL.TASK_ID%TYPE;
4605: X_Bill_Hold_Flag PA_EXPENDITURE_ITEMS_ALL.BILL_HOLD_FLAG%TYPE; --VARCHAR2(1);
4606: X_Billable_Flag PA_EXPENDITURE_ITEMS_ALL.BILLABLE_FLAG%TYPE; --VARCHAR2(1);
4607: X_Adjusted_Expenditure_Item_Id PA_EXPENDITURE_ITEMS_ALL.ADJUSTED_EXPENDITURE_ITEM_ID%TYPE;
4608: X_First_Indicator BOOLEAN := TRUE;
4609:
4610: -- 11.5 Changes Start

Line 4607: X_Adjusted_Expenditure_Item_Id PA_EXPENDITURE_ITEMS_ALL.ADJUSTED_EXPENDITURE_ITEM_ID%TYPE;

4603: X_Expenditure_Item_Date PA_EXPENDITURE_ITEMS_ALL.EXPENDITURE_ITEM_DATE%TYPE;
4604: X_Task_Id PA_EXPENDITURE_ITEMS_ALL.TASK_ID%TYPE;
4605: X_Bill_Hold_Flag PA_EXPENDITURE_ITEMS_ALL.BILL_HOLD_FLAG%TYPE; --VARCHAR2(1);
4606: X_Billable_Flag PA_EXPENDITURE_ITEMS_ALL.BILLABLE_FLAG%TYPE; --VARCHAR2(1);
4607: X_Adjusted_Expenditure_Item_Id PA_EXPENDITURE_ITEMS_ALL.ADJUSTED_EXPENDITURE_ITEM_ID%TYPE;
4608: X_First_Indicator BOOLEAN := TRUE;
4609:
4610: -- 11.5 Changes Start
4611: X_Adl_Line_Num gms_award_distributions.adl_line_num%type;

Line 4627: X_Raw_Cost PA_EXPENDITURE_ITEMS_ALL.RAW_COST%TYPE; -- Amount on the Current Transaction being Processed

4623: X_Money_Left_In_Inst NUMBER(22,5) := 0; -- Amount left in Installment that can be billed
4624: X_Total_Funding_Amount NUMBER(22,5) := 0; -- Total Funding by Installment,Task for a particular Project
4625: X_Total_Rev_Bill_Amount NUMBER(22,5) := 0; -- Total Revenue or Billed Amount(Depending on the Calling Process)
4626: -- by Installment, Task for a particular Project
4627: X_Raw_Cost PA_EXPENDITURE_ITEMS_ALL.RAW_COST%TYPE; -- Amount on the Current Transaction being Processed
4628: X_Amount_In_Intersect NUMBER(22,5) := 0; -- Sum of Amounts in Intersect table for current Trx being processed
4629: X_Amount_To_Insert NUMBER(22,5) := 0; -- Amount to be Inserted into Intersect Table,(X_Raw_Cost - X_Amount_In_Intersect)
4630: X_Event_Amount NUMBER(22,5) := 0; -- Running total for the Amount for which Event is to be created
4631: C_Inst_Task_Run_Total NUMBER(22,5):= 0; -- Running Total for the amount that will be billed on this Installment.

Line 4663: X_old_task_id pa_expenditure_items_all.task_id%type;

4659: k NUMBER := 0;
4660: /* bug 5242484 end */
4661:
4662: /* Bug 3523930 Start*/
4663: X_old_task_id pa_expenditure_items_all.task_id%type;
4664: X_new_task_id pa_expenditure_items_all.task_id%type;
4665: X_old_actprj_id pa_expenditure_items_all.project_id%type;
4666: X_new_actprj_id pa_expenditure_items_all.project_id%type;
4667: /* Bug 3523930 End*/

Line 4664: X_new_task_id pa_expenditure_items_all.task_id%type;

4660: /* bug 5242484 end */
4661:
4662: /* Bug 3523930 Start*/
4663: X_old_task_id pa_expenditure_items_all.task_id%type;
4664: X_new_task_id pa_expenditure_items_all.task_id%type;
4665: X_old_actprj_id pa_expenditure_items_all.project_id%type;
4666: X_new_actprj_id pa_expenditure_items_all.project_id%type;
4667: /* Bug 3523930 End*/
4668: ss_text VARCHAR2(300);

Line 4665: X_old_actprj_id pa_expenditure_items_all.project_id%type;

4661:
4662: /* Bug 3523930 Start*/
4663: X_old_task_id pa_expenditure_items_all.task_id%type;
4664: X_new_task_id pa_expenditure_items_all.task_id%type;
4665: X_old_actprj_id pa_expenditure_items_all.project_id%type;
4666: X_new_actprj_id pa_expenditure_items_all.project_id%type;
4667: /* Bug 3523930 End*/
4668: ss_text VARCHAR2(300);
4669: RESOURCE_BUSY EXCEPTION;

Line 4666: X_new_actprj_id pa_expenditure_items_all.project_id%type;

4662: /* Bug 3523930 Start*/
4663: X_old_task_id pa_expenditure_items_all.task_id%type;
4664: X_new_task_id pa_expenditure_items_all.task_id%type;
4665: X_old_actprj_id pa_expenditure_items_all.project_id%type;
4666: X_new_actprj_id pa_expenditure_items_all.project_id%type;
4667: /* Bug 3523930 End*/
4668: ss_text VARCHAR2(300);
4669: RESOURCE_BUSY EXCEPTION;
4670: PRAGMA EXCEPTION_INIT(RESOURCE_BUSY, -00054);

Line 4673: X_expenditure_type pa_expenditure_items_all.expenditure_type%type;

4669: RESOURCE_BUSY EXCEPTION;
4670: PRAGMA EXCEPTION_INIT(RESOURCE_BUSY, -00054);
4671:
4672: -- Bug 3630577 : performance fix ..
4673: X_expenditure_type pa_expenditure_items_all.expenditure_type%type;
4674: X_expenditure_org_id pa_expenditure_items_all.override_to_organization_id%type;
4675: X_ind_compiled_set_id pa_cost_distribution_lines_all.ind_compiled_set_id%type;
4676: X_burdenable_raw_cost gms_award_distributions.burdenable_raw_cost%type;
4677: X_transaction_source pa_transaction_sources.transaction_source%type;

Line 4674: X_expenditure_org_id pa_expenditure_items_all.override_to_organization_id%type;

4670: PRAGMA EXCEPTION_INIT(RESOURCE_BUSY, -00054);
4671:
4672: -- Bug 3630577 : performance fix ..
4673: X_expenditure_type pa_expenditure_items_all.expenditure_type%type;
4674: X_expenditure_org_id pa_expenditure_items_all.override_to_organization_id%type;
4675: X_ind_compiled_set_id pa_cost_distribution_lines_all.ind_compiled_set_id%type;
4676: X_burdenable_raw_cost gms_award_distributions.burdenable_raw_cost%type;
4677: X_transaction_source pa_transaction_sources.transaction_source%type;
4678:

Line 4814: pa_expenditure_items_all

4810: select expenditure_item_id
4811: into
4812: X_Lock_Exp_Id
4813: from
4814: pa_expenditure_items_all
4815: where
4816: expenditure_item_id = X_Expenditure_Item_Id
4817: FOR UPDATE NOWAIT;
4818:

Line 5555: ,pa_expenditure_items_all ei

5551: , adl.burdenable_raw_cost
5552: , ei.transaction_source
5553: from
5554: gms_award_distributions adl /* Moved this up in the order for 6969435*/
5555: ,pa_expenditure_items_all ei
5556: ,pa_expenditures e
5557: ,pa_expenditure_types et
5558: ,pa_lookups unit
5559: ,pa_projects_all p

Line 5692: X_transaction_source pa_expenditure_items_all.transaction_source%type;

5688: PRAGMA EXCEPTION_INIT(RESOURCE_BUSY, -00054);
5689:
5690: X_ind_compiled_Set_id gms_award_distributions.ind_compiled_set_id%type;
5691: X_burdenable_raw_cost gms_award_distributions.burdenable_raw_cost%type;
5692: X_transaction_source pa_expenditure_items_all.transaction_source%type;
5693:
5694: Begin
5695:
5696:

Line 5752: pa_expenditure_items_all

5748: select expenditure_item_id
5749: into
5750: X_Rev_Lock_Exp_Id
5751: from
5752: pa_expenditure_items_all
5753: where
5754: expenditure_item_id = X_Rev_Expenditure_Item_Id
5755: FOR UPDATE NOWAIT;
5756:

Line 6822: X_Fixed_From := 'pa_expenditure_items_all ei ,pa_expenditures_all e, pa_expenditure_types et,'

6818: adl.adl_status, adl.award_id, adl.project_id, adl.cdl_line_num,ei.expenditure_type,
6819: nvl(ei.override_to_organization_id,e.incurred_by_organization_id),adl.ind_compiled_Set_id,adl.burdenable_raw_cost,
6820: ei.transaction_source '; --bug 2909746
6821:
6822: X_Fixed_From := 'pa_expenditure_items_all ei ,pa_expenditures_all e, pa_expenditure_types et,'
6823: ||' pa_projects_all p, pa_project_types pt,'
6824: ||' pa_tasks t3, pa_tasks t5, gms_award_distributions adl ';
6825:
6826: /* --- 11.5 changes --- */

Line 6843: -- 3.condtions to join gms_award_distributions and pa_expenditure_items_all added

6839:
6840: /* --- 11.5 Changes ---
6841: -- 1.Columns like billed_flag,award_id, revenue_distributed_flag being picked from gms_award_distributions
6842: -- 2.Column attribute2 IS NULL changed to adl.document_type <>'ENC'
6843: -- 3.condtions to join gms_award_distributions and pa_expenditure_items_all added
6844: -- 4.check for adl lines with adl status <> 'I'
6845: */
6846:
6847: X_Fixed_Where := ' adl.award_id = :X_Award_Id '