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 3423: from pa_expenditure_items_all peia,

3419: Begin
3420: -- Bug 3235390 : Added decode to get correct quantity
3421: Select SUM(NVL( DECODE(adl.line_num_reversed, NULL, peia.quantity,-1*peia.quantity),0))
3422: into x_qty
3423: from pa_expenditure_items_all peia,
3424: gms_event_intersect gei,
3425: gms_award_distributions adl
3426: where peia.expenditure_item_id = gei.expenditure_item_id
3427: and adl.expenditure_item_id = gei.expenditure_item_id

Line 4574: X_Expenditure_Item_Id PA_EXPENDITURE_ITEMS_ALL.EXPENDITURE_ITEM_ID%TYPE;

4570: X_New_Values Selected_Values_Rows;
4571:
4572: cur_select INTEGER := 0;
4573: X_Rows_Processed INTEGER := 0;
4574: X_Expenditure_Item_Id PA_EXPENDITURE_ITEMS_ALL.EXPENDITURE_ITEM_ID%TYPE;
4575: X_Expenditure_Item_Date PA_EXPENDITURE_ITEMS_ALL.EXPENDITURE_ITEM_DATE%TYPE;
4576: X_Task_Id PA_EXPENDITURE_ITEMS_ALL.TASK_ID%TYPE;
4577: X_Bill_Hold_Flag PA_EXPENDITURE_ITEMS_ALL.BILL_HOLD_FLAG%TYPE; --VARCHAR2(1);
4578: X_Billable_Flag PA_EXPENDITURE_ITEMS_ALL.BILLABLE_FLAG%TYPE; --VARCHAR2(1);

Line 4575: X_Expenditure_Item_Date PA_EXPENDITURE_ITEMS_ALL.EXPENDITURE_ITEM_DATE%TYPE;

4571:
4572: cur_select INTEGER := 0;
4573: X_Rows_Processed INTEGER := 0;
4574: X_Expenditure_Item_Id PA_EXPENDITURE_ITEMS_ALL.EXPENDITURE_ITEM_ID%TYPE;
4575: X_Expenditure_Item_Date PA_EXPENDITURE_ITEMS_ALL.EXPENDITURE_ITEM_DATE%TYPE;
4576: X_Task_Id PA_EXPENDITURE_ITEMS_ALL.TASK_ID%TYPE;
4577: X_Bill_Hold_Flag PA_EXPENDITURE_ITEMS_ALL.BILL_HOLD_FLAG%TYPE; --VARCHAR2(1);
4578: X_Billable_Flag PA_EXPENDITURE_ITEMS_ALL.BILLABLE_FLAG%TYPE; --VARCHAR2(1);
4579: X_Adjusted_Expenditure_Item_Id PA_EXPENDITURE_ITEMS_ALL.ADJUSTED_EXPENDITURE_ITEM_ID%TYPE;

Line 4576: X_Task_Id PA_EXPENDITURE_ITEMS_ALL.TASK_ID%TYPE;

4572: cur_select INTEGER := 0;
4573: X_Rows_Processed INTEGER := 0;
4574: X_Expenditure_Item_Id PA_EXPENDITURE_ITEMS_ALL.EXPENDITURE_ITEM_ID%TYPE;
4575: X_Expenditure_Item_Date PA_EXPENDITURE_ITEMS_ALL.EXPENDITURE_ITEM_DATE%TYPE;
4576: X_Task_Id PA_EXPENDITURE_ITEMS_ALL.TASK_ID%TYPE;
4577: X_Bill_Hold_Flag PA_EXPENDITURE_ITEMS_ALL.BILL_HOLD_FLAG%TYPE; --VARCHAR2(1);
4578: X_Billable_Flag PA_EXPENDITURE_ITEMS_ALL.BILLABLE_FLAG%TYPE; --VARCHAR2(1);
4579: X_Adjusted_Expenditure_Item_Id PA_EXPENDITURE_ITEMS_ALL.ADJUSTED_EXPENDITURE_ITEM_ID%TYPE;
4580: X_First_Indicator BOOLEAN := TRUE;

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

4573: X_Rows_Processed INTEGER := 0;
4574: X_Expenditure_Item_Id PA_EXPENDITURE_ITEMS_ALL.EXPENDITURE_ITEM_ID%TYPE;
4575: X_Expenditure_Item_Date PA_EXPENDITURE_ITEMS_ALL.EXPENDITURE_ITEM_DATE%TYPE;
4576: X_Task_Id PA_EXPENDITURE_ITEMS_ALL.TASK_ID%TYPE;
4577: X_Bill_Hold_Flag PA_EXPENDITURE_ITEMS_ALL.BILL_HOLD_FLAG%TYPE; --VARCHAR2(1);
4578: X_Billable_Flag PA_EXPENDITURE_ITEMS_ALL.BILLABLE_FLAG%TYPE; --VARCHAR2(1);
4579: X_Adjusted_Expenditure_Item_Id PA_EXPENDITURE_ITEMS_ALL.ADJUSTED_EXPENDITURE_ITEM_ID%TYPE;
4580: X_First_Indicator BOOLEAN := TRUE;
4581:

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

4574: X_Expenditure_Item_Id PA_EXPENDITURE_ITEMS_ALL.EXPENDITURE_ITEM_ID%TYPE;
4575: X_Expenditure_Item_Date PA_EXPENDITURE_ITEMS_ALL.EXPENDITURE_ITEM_DATE%TYPE;
4576: X_Task_Id PA_EXPENDITURE_ITEMS_ALL.TASK_ID%TYPE;
4577: X_Bill_Hold_Flag PA_EXPENDITURE_ITEMS_ALL.BILL_HOLD_FLAG%TYPE; --VARCHAR2(1);
4578: X_Billable_Flag PA_EXPENDITURE_ITEMS_ALL.BILLABLE_FLAG%TYPE; --VARCHAR2(1);
4579: X_Adjusted_Expenditure_Item_Id PA_EXPENDITURE_ITEMS_ALL.ADJUSTED_EXPENDITURE_ITEM_ID%TYPE;
4580: X_First_Indicator BOOLEAN := TRUE;
4581:
4582: -- 11.5 Changes Start

Line 4579: X_Adjusted_Expenditure_Item_Id PA_EXPENDITURE_ITEMS_ALL.ADJUSTED_EXPENDITURE_ITEM_ID%TYPE;

4575: X_Expenditure_Item_Date PA_EXPENDITURE_ITEMS_ALL.EXPENDITURE_ITEM_DATE%TYPE;
4576: X_Task_Id PA_EXPENDITURE_ITEMS_ALL.TASK_ID%TYPE;
4577: X_Bill_Hold_Flag PA_EXPENDITURE_ITEMS_ALL.BILL_HOLD_FLAG%TYPE; --VARCHAR2(1);
4578: X_Billable_Flag PA_EXPENDITURE_ITEMS_ALL.BILLABLE_FLAG%TYPE; --VARCHAR2(1);
4579: X_Adjusted_Expenditure_Item_Id PA_EXPENDITURE_ITEMS_ALL.ADJUSTED_EXPENDITURE_ITEM_ID%TYPE;
4580: X_First_Indicator BOOLEAN := TRUE;
4581:
4582: -- 11.5 Changes Start
4583: X_Adl_Line_Num gms_award_distributions.adl_line_num%type;

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

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

Line 4635: X_old_task_id pa_expenditure_items_all.task_id%type;

4631: k NUMBER := 0;
4632: /* bug 5242484 end */
4633:
4634: /* Bug 3523930 Start*/
4635: X_old_task_id pa_expenditure_items_all.task_id%type;
4636: X_new_task_id pa_expenditure_items_all.task_id%type;
4637: X_old_actprj_id pa_expenditure_items_all.project_id%type;
4638: X_new_actprj_id pa_expenditure_items_all.project_id%type;
4639: /* Bug 3523930 End*/

Line 4636: X_new_task_id pa_expenditure_items_all.task_id%type;

4632: /* bug 5242484 end */
4633:
4634: /* Bug 3523930 Start*/
4635: X_old_task_id pa_expenditure_items_all.task_id%type;
4636: X_new_task_id pa_expenditure_items_all.task_id%type;
4637: X_old_actprj_id pa_expenditure_items_all.project_id%type;
4638: X_new_actprj_id pa_expenditure_items_all.project_id%type;
4639: /* Bug 3523930 End*/
4640: ss_text VARCHAR2(300);

Line 4637: X_old_actprj_id pa_expenditure_items_all.project_id%type;

4633:
4634: /* Bug 3523930 Start*/
4635: X_old_task_id pa_expenditure_items_all.task_id%type;
4636: X_new_task_id pa_expenditure_items_all.task_id%type;
4637: X_old_actprj_id pa_expenditure_items_all.project_id%type;
4638: X_new_actprj_id pa_expenditure_items_all.project_id%type;
4639: /* Bug 3523930 End*/
4640: ss_text VARCHAR2(300);
4641: RESOURCE_BUSY EXCEPTION;

Line 4638: X_new_actprj_id pa_expenditure_items_all.project_id%type;

4634: /* Bug 3523930 Start*/
4635: X_old_task_id pa_expenditure_items_all.task_id%type;
4636: X_new_task_id pa_expenditure_items_all.task_id%type;
4637: X_old_actprj_id pa_expenditure_items_all.project_id%type;
4638: X_new_actprj_id pa_expenditure_items_all.project_id%type;
4639: /* Bug 3523930 End*/
4640: ss_text VARCHAR2(300);
4641: RESOURCE_BUSY EXCEPTION;
4642: PRAGMA EXCEPTION_INIT(RESOURCE_BUSY, -00054);

Line 4645: X_expenditure_type pa_expenditure_items_all.expenditure_type%type;

4641: RESOURCE_BUSY EXCEPTION;
4642: PRAGMA EXCEPTION_INIT(RESOURCE_BUSY, -00054);
4643:
4644: -- Bug 3630577 : performance fix ..
4645: X_expenditure_type pa_expenditure_items_all.expenditure_type%type;
4646: X_expenditure_org_id pa_expenditure_items_all.override_to_organization_id%type;
4647: X_ind_compiled_set_id pa_cost_distribution_lines_all.ind_compiled_set_id%type;
4648: X_burdenable_raw_cost gms_award_distributions.burdenable_raw_cost%type;
4649: X_transaction_source pa_transaction_sources.transaction_source%type;

Line 4646: X_expenditure_org_id pa_expenditure_items_all.override_to_organization_id%type;

4642: PRAGMA EXCEPTION_INIT(RESOURCE_BUSY, -00054);
4643:
4644: -- Bug 3630577 : performance fix ..
4645: X_expenditure_type pa_expenditure_items_all.expenditure_type%type;
4646: X_expenditure_org_id pa_expenditure_items_all.override_to_organization_id%type;
4647: X_ind_compiled_set_id pa_cost_distribution_lines_all.ind_compiled_set_id%type;
4648: X_burdenable_raw_cost gms_award_distributions.burdenable_raw_cost%type;
4649: X_transaction_source pa_transaction_sources.transaction_source%type;
4650:

Line 4786: pa_expenditure_items_all

4782: select expenditure_item_id
4783: into
4784: X_Lock_Exp_Id
4785: from
4786: pa_expenditure_items_all
4787: where
4788: expenditure_item_id = X_Expenditure_Item_Id
4789: FOR UPDATE NOWAIT;
4790:

Line 5526: ,pa_expenditure_items_all ei

5522: , adl.burdenable_raw_cost
5523: , ei.transaction_source
5524: from
5525: gms_award_distributions adl /* Moved this up in the order for 6969435*/
5526: ,pa_expenditure_items_all ei
5527: ,pa_expenditures e
5528: ,pa_expenditure_types et
5529: ,pa_lookups unit
5530: ,pa_projects_all p

Line 5663: X_transaction_source pa_expenditure_items_all.transaction_source%type;

5659: PRAGMA EXCEPTION_INIT(RESOURCE_BUSY, -00054);
5660:
5661: X_ind_compiled_Set_id gms_award_distributions.ind_compiled_set_id%type;
5662: X_burdenable_raw_cost gms_award_distributions.burdenable_raw_cost%type;
5663: X_transaction_source pa_expenditure_items_all.transaction_source%type;
5664:
5665: Begin
5666:
5667:

Line 5723: pa_expenditure_items_all

5719: select expenditure_item_id
5720: into
5721: X_Rev_Lock_Exp_Id
5722: from
5723: pa_expenditure_items_all
5724: where
5725: expenditure_item_id = X_Rev_Expenditure_Item_Id
5726: FOR UPDATE NOWAIT;
5727:

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

6787: adl.adl_status, adl.award_id, adl.project_id, adl.cdl_line_num,ei.expenditure_type,
6788: nvl(ei.override_to_organization_id,e.incurred_by_organization_id),adl.ind_compiled_Set_id,adl.burdenable_raw_cost,
6789: ei.transaction_source '; --bug 2909746
6790:
6791: X_Fixed_From := 'pa_expenditure_items_all ei ,pa_expenditures_all e, pa_expenditure_types et,'
6792: ||' pa_projects_all p, pa_project_types pt,'
6793: ||' pa_tasks t3, pa_tasks t5, gms_award_distributions adl ';
6794:
6795: /* --- 11.5 changes --- */

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

6808:
6809: /* --- 11.5 Changes ---
6810: -- 1.Columns like billed_flag,award_id, revenue_distributed_flag being picked from gms_award_distributions
6811: -- 2.Column attribute2 IS NULL changed to adl.document_type <>'ENC'
6812: -- 3.condtions to join gms_award_distributions and pa_expenditure_items_all added
6813: -- 4.check for adl lines with adl status <> 'I'
6814: */
6815:
6816: X_Fixed_Where := ' adl.award_id = :X_Award_Id '