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 GMS_AWARD_DISTRIBUTIONS

Line 226: select /+ INDEX(adl gms_award_distributions_n7) / 1 /* Added hint for bug 6969435 */

222: Select 1
223: into l_value
224: from dual
225: where exists(
226: select /*+ INDEX(adl gms_award_distributions_n7) */ 1 /* Added hint for bug 6969435 */
227: from gms_award_distributions adl,
228: pa_tasks t3,
229: pa_tasks t5
230: where adl.award_id = X_Award_Id

Line 227: from gms_award_distributions adl,

223: into l_value
224: from dual
225: where exists(
226: select /*+ INDEX(adl gms_award_distributions_n7) */ 1 /* Added hint for bug 6969435 */
227: from gms_award_distributions adl,
228: pa_tasks t3,
229: pa_tasks t5
230: where adl.award_id = X_Award_Id
231: and adl.document_type = 'EXP'

Line 271: select /+ INDEX(adl gms_award_distributions_n7) / 1 /* Added hint for bug 6969435 */

267: Select 1
268: into l_value
269: from dual
270: where exists(
271: select /*+ INDEX(adl gms_award_distributions_n7) */ 1 /* Added hint for bug 6969435 */
272: from
273: gms_award_distributions adl,
274: pa_tasks t3,
275: pa_tasks t5

Line 273: gms_award_distributions adl,

269: from dual
270: where exists(
271: select /*+ INDEX(adl gms_award_distributions_n7) */ 1 /* Added hint for bug 6969435 */
272: from
273: gms_award_distributions adl,
274: pa_tasks t3,
275: pa_tasks t5
276: where adl.award_id = X_Award_Id
277: and adl.document_type = 'EXP'

Line 441: f_raw_exp_item_id gms_award_distributions.expenditure_item_id%TYPE;

437: AND gei.award_project_id = gea.project_id
438: AND gei.event_num = gea.event_num
439: AND gei.event_type = UPPER(f_event_calling_process);
440:
441: f_raw_exp_item_id gms_award_distributions.expenditure_item_id%TYPE;
442: f_raw_adl_line_num gms_award_distributions.adl_line_num%TYPE;
443: f_raw_act_project_id gms_event_attribute.actual_project_id%TYPE;
444: f_raw_act_task_id gms_event_attribute.actual_task_id%TYPE;
445: f_raw_org_id gms_event_attribute.expenditure_org_id%TYPE;

Line 442: f_raw_adl_line_num gms_award_distributions.adl_line_num%TYPE;

438: AND gei.event_num = gea.event_num
439: AND gei.event_type = UPPER(f_event_calling_process);
440:
441: f_raw_exp_item_id gms_award_distributions.expenditure_item_id%TYPE;
442: f_raw_adl_line_num gms_award_distributions.adl_line_num%TYPE;
443: f_raw_act_project_id gms_event_attribute.actual_project_id%TYPE;
444: f_raw_act_task_id gms_event_attribute.actual_task_id%TYPE;
445: f_raw_org_id gms_event_attribute.expenditure_org_id%TYPE;
446: f_raw_rev_accumulated gms_event_intersect.revenue_accumulated%TYPE;

Line 461: f_burd_exp_item_id gms_award_distributions.expenditure_item_id%TYPE;

457: WHERE award_project_id = f_project_id
458: AND event_num = f_event_num
459: AND event_type = UPPER(f_event_calling_process);
460:
461: f_burd_exp_item_id gms_award_distributions.expenditure_item_id%TYPE;
462: f_burd_adl_line_num gms_award_distributions.adl_line_num%TYPE;
463: f_burd_rev_accumulated gms_burden_components.revenue_accumulated%TYPE;
464: f_burd_revenue_amount gms_burden_components.amount%TYPE;
465: f_burd_act_project_id gms_burden_components.actual_project_id%TYPE;

Line 462: f_burd_adl_line_num gms_award_distributions.adl_line_num%TYPE;

458: AND event_num = f_event_num
459: AND event_type = UPPER(f_event_calling_process);
460:
461: f_burd_exp_item_id gms_award_distributions.expenditure_item_id%TYPE;
462: f_burd_adl_line_num gms_award_distributions.adl_line_num%TYPE;
463: f_burd_rev_accumulated gms_burden_components.revenue_accumulated%TYPE;
464: f_burd_revenue_amount gms_burden_components.amount%TYPE;
465: f_burd_act_project_id gms_burden_components.actual_project_id%TYPE;
466: f_burd_act_task_id gms_burden_components.actual_task_id%TYPE;

Line 495: || 10. Updating gms_award_distributions (revenue_distributed_flag/billed_flag)

491: x_stage NUMBER (2);
492: BEGIN
493: /* --------------------------------------------------------------------------
494: || Rollback Activities Include:
495: || 10. Updating gms_award_distributions (revenue_distributed_flag/billed_flag)
496: || 20. Deleting from gms_event_intersect
497: || 30. Deleting from gms_burden_components
498: || 40. Updating gms_summary_project_fundings
499: || 50. Deleting gms_event_attribute

Line 525: -- 10: Updating the gms_award_distributions table

521: f_request_id; --Added for bug 4957529
522: EXIT WHEN get_exp_raw_info%NOTFOUND;
523:
524: BEGIN -- Expenditure Rollup Block
525: -- 10: Updating the gms_award_distributions table
526:
527: x_stage := 10;
528:
529: IF evt.event_type = 'Revenue'

Line 554: UPDATE gms_award_distributions

550: x_err_buff
551: );
552: END IF;
553:
554: UPDATE gms_award_distributions
555: SET revenue_distributed_flag = decode(x_event_num,NULL,'N','Z'),
556: last_update_date = SYSDATE,
557: last_updated_by = fnd_global.user_id,
558: last_update_login = fnd_global.login_id

Line 565: UPDATE gms_award_distributions

561: AND document_type = 'EXP'
562: AND adl_status = 'A';
563: ELSIF evt.event_type = 'Invoice'
564: THEN
565: UPDATE gms_award_distributions
566: SET billed_flag = decode(x_event_num,NULL,'N','Z'),
567: last_update_date = SYSDATE,
568: last_updated_by = fnd_global.user_id,
569: last_update_login = fnd_global.login_id

Line 814: Update gms_award_distributions

810: IF L_DEBUG = 'Y' THEN
811: gms_error_pkg.gms_debug('In DELETE_NULL_EVENTS - Stage: Revenue Raw - ADL update', 'C');
812: END IF;
813:
814: Update gms_award_distributions
815: set revenue_distributed_flag = decode(revenue_distributed_flag,'Y','Z','Z','N')
816: where (expenditure_item_id,adl_line_num) in
817: (select expenditure_item_id,
818: adl_line_num

Line 851: Update gms_award_distributions

847: IF L_DEBUG = 'Y' THEN
848: gms_error_pkg.gms_debug('In DELETE_NULL_EVENTS - Stage: Invoice Burden - ADL Update', 'C');
849: END IF;
850:
851: Update gms_award_distributions
852: set billed_flag = decode(billed_flag,'Y','Z','Z','N')
853: where (expenditure_item_id,adl_line_num) in
854: (select expenditure_item_id,
855: adl_line_num

Line 870: Update gms_award_distributions

866: IF L_DEBUG = 'Y' THEN
867: gms_error_pkg.gms_debug('In DELETE_NULL_EVENTS - Stage: Revenue Burden - ADL Update', 'C');
868: END IF;
869:
870: Update gms_award_distributions
871: set revenue_distributed_flag = decode(revenue_distributed_flag,'Y','Z','Z','N')
872: where (expenditure_item_id,adl_line_num) in
873: (select expenditure_item_id,
874: adl_line_num

Line 1005: gms_award_distributions adl

1001: pa_projects_all p,
1002: pa_project_types pt,
1003: pa_tasks t3,
1004: pa_tasks t5,
1005: gms_award_distributions adl
1006: where adl.award_id = X_Award_Id
1007: and ei.expenditure_item_id = adl.expenditure_item_id
1008: and ei.system_linkage_function <> 'BTC'
1009: and p.project_status_code <> 'CLOSED'

Line 1029: Update gms_award_distributions

1025:
1026: For Bill_Hold_Rec in one_time_hold
1027: loop
1028: /*
1029: Update gms_award_distributions
1030: set bill_hold_flag='N'
1031: where expenditure_item_id = Bill_Hold_Rec.expenditure_item_id
1032: and adl_line_num = Bill_Hold_Rec.adl_line_num
1033: and award_id = Bill_Hold_Rec.award_id

Line 1181: || 4. Updating gms_award_distributions (revenue_distributed_flag/billed_flag)

1177: || Here's what we need to do :
1178: || 1. Updating gms_summary_project_fundings
1179: || 2. Deleting from gms_event_intersect
1180: || 3. Deleting from gms_burden_components
1181: || 4. Updating gms_award_distributions (revenue_distributed_flag/billed_flag)
1182: -------------------------------------------------------------------------- */
1183:
1184: select award_project_id
1185: into x_award_project_id

Line 1207: UPDATE gms_award_distributions

1203: AND installment_id = X_ei_rollback_inst_tab(i).installment_id ;
1204:
1205: END LOOP;
1206:
1207: UPDATE gms_award_distributions
1208: SET revenue_distributed_flag = decode(x_event_type,'REVENUE','N',revenue_distributed_flag),
1209: billed_flag = decode(x_event_type,'INVOICE','N',billed_flag),
1210: last_update_date = SYSDATE,
1211: last_updated_by = fnd_global.user_id,

Line 1390: gms_award_distributions adl

1386: pa_projects_all p,
1387: pa_project_types pt,
1388: pa_tasks t3,
1389: pa_tasks t5,
1390: gms_award_distributions adl
1391: where adl.award_id = X_Award_Id
1392: and ei.expenditure_item_id = adl.expenditure_item_id
1393: and ei.system_linkage_function <> 'BTC'
1394: and p.project_status_code <> 'CLOSED'

Line 1411: F_Expenditure_Item_Id gms_award_distributions.expenditure_item_id%type;

1407: and adl.output_tax_exempt_flag is null;
1408:
1409: -- Last clause, so that tax is calculated once for an ADL, either in Revenue or Invoice Process
1410:
1411: F_Expenditure_Item_Id gms_award_distributions.expenditure_item_id%type;
1412: F_Adl_Line_Num gms_award_distributions.adl_line_num%type;
1413: F_Award_Id gms_award_distributions.award_id%type;
1414:
1415: --S_Output_Vat_Tax_Id gms_award_distributions.output_vat_tax_id%type; --Changes for ETax

Line 1412: F_Adl_Line_Num gms_award_distributions.adl_line_num%type;

1408:
1409: -- Last clause, so that tax is calculated once for an ADL, either in Revenue or Invoice Process
1410:
1411: F_Expenditure_Item_Id gms_award_distributions.expenditure_item_id%type;
1412: F_Adl_Line_Num gms_award_distributions.adl_line_num%type;
1413: F_Award_Id gms_award_distributions.award_id%type;
1414:
1415: --S_Output_Vat_Tax_Id gms_award_distributions.output_vat_tax_id%type; --Changes for ETax
1416: S_Output_Tax_classify_code gms_award_distributions.output_tax_classification_code%type; --Changes for ETax

Line 1413: F_Award_Id gms_award_distributions.award_id%type;

1409: -- Last clause, so that tax is calculated once for an ADL, either in Revenue or Invoice Process
1410:
1411: F_Expenditure_Item_Id gms_award_distributions.expenditure_item_id%type;
1412: F_Adl_Line_Num gms_award_distributions.adl_line_num%type;
1413: F_Award_Id gms_award_distributions.award_id%type;
1414:
1415: --S_Output_Vat_Tax_Id gms_award_distributions.output_vat_tax_id%type; --Changes for ETax
1416: S_Output_Tax_classify_code gms_award_distributions.output_tax_classification_code%type; --Changes for ETax
1417: S_Output_Tax_Exempt_Flag gms_award_distributions.output_tax_exempt_flag%type;

Line 1415: --S_Output_Vat_Tax_Id gms_award_distributions.output_vat_tax_id%type; --Changes for ETax

1411: F_Expenditure_Item_Id gms_award_distributions.expenditure_item_id%type;
1412: F_Adl_Line_Num gms_award_distributions.adl_line_num%type;
1413: F_Award_Id gms_award_distributions.award_id%type;
1414:
1415: --S_Output_Vat_Tax_Id gms_award_distributions.output_vat_tax_id%type; --Changes for ETax
1416: S_Output_Tax_classify_code gms_award_distributions.output_tax_classification_code%type; --Changes for ETax
1417: S_Output_Tax_Exempt_Flag gms_award_distributions.output_tax_exempt_flag%type;
1418: S_Output_Tax_Exempt_Number gms_award_distributions.output_tax_exempt_number%type;
1419: S_Output_Exempt_Reason_Code gms_award_distributions.output_tax_exempt_reason_code%type;

Line 1416: S_Output_Tax_classify_code gms_award_distributions.output_tax_classification_code%type; --Changes for ETax

1412: F_Adl_Line_Num gms_award_distributions.adl_line_num%type;
1413: F_Award_Id gms_award_distributions.award_id%type;
1414:
1415: --S_Output_Vat_Tax_Id gms_award_distributions.output_vat_tax_id%type; --Changes for ETax
1416: S_Output_Tax_classify_code gms_award_distributions.output_tax_classification_code%type; --Changes for ETax
1417: S_Output_Tax_Exempt_Flag gms_award_distributions.output_tax_exempt_flag%type;
1418: S_Output_Tax_Exempt_Number gms_award_distributions.output_tax_exempt_number%type;
1419: S_Output_Exempt_Reason_Code gms_award_distributions.output_tax_exempt_reason_code%type;
1420:

Line 1417: S_Output_Tax_Exempt_Flag gms_award_distributions.output_tax_exempt_flag%type;

1413: F_Award_Id gms_award_distributions.award_id%type;
1414:
1415: --S_Output_Vat_Tax_Id gms_award_distributions.output_vat_tax_id%type; --Changes for ETax
1416: S_Output_Tax_classify_code gms_award_distributions.output_tax_classification_code%type; --Changes for ETax
1417: S_Output_Tax_Exempt_Flag gms_award_distributions.output_tax_exempt_flag%type;
1418: S_Output_Tax_Exempt_Number gms_award_distributions.output_tax_exempt_number%type;
1419: S_Output_Exempt_Reason_Code gms_award_distributions.output_tax_exempt_reason_code%type;
1420:
1421: X_Set_Of_Book_Id NUMBER(15);

Line 1418: S_Output_Tax_Exempt_Number gms_award_distributions.output_tax_exempt_number%type;

1414:
1415: --S_Output_Vat_Tax_Id gms_award_distributions.output_vat_tax_id%type; --Changes for ETax
1416: S_Output_Tax_classify_code gms_award_distributions.output_tax_classification_code%type; --Changes for ETax
1417: S_Output_Tax_Exempt_Flag gms_award_distributions.output_tax_exempt_flag%type;
1418: S_Output_Tax_Exempt_Number gms_award_distributions.output_tax_exempt_number%type;
1419: S_Output_Exempt_Reason_Code gms_award_distributions.output_tax_exempt_reason_code%type;
1420:
1421: X_Set_Of_Book_Id NUMBER(15);
1422:

Line 1419: S_Output_Exempt_Reason_Code gms_award_distributions.output_tax_exempt_reason_code%type;

1415: --S_Output_Vat_Tax_Id gms_award_distributions.output_vat_tax_id%type; --Changes for ETax
1416: S_Output_Tax_classify_code gms_award_distributions.output_tax_classification_code%type; --Changes for ETax
1417: S_Output_Tax_Exempt_Flag gms_award_distributions.output_tax_exempt_flag%type;
1418: S_Output_Tax_Exempt_Number gms_award_distributions.output_tax_exempt_number%type;
1419: S_Output_Exempt_Reason_Code gms_award_distributions.output_tax_exempt_reason_code%type;
1420:
1421: X_Set_Of_Book_Id NUMBER(15);
1422:
1423: -- Bug Fix 2994625

Line 1561: Update gms_award_distributions

1557: -- STAGE 50: UPDATE ADL LINES WITH TAX INFORMATION
1558:
1559: Begin
1560:
1561: Update gms_award_distributions
1562: set
1563: --output_vat_tax_id = S_Output_Vat_Tax_Id,
1564: output_tax_classification_code = S_Output_tax_classify_code,
1565: output_tax_exempt_flag = S_Output_Tax_Exempt_Flag,

Line 1919: FROM gms_award_distributions

1915: END IF;
1916:
1917: SELECT NVL(SUM(raw_cost),0)
1918: INTO l_raw_cost
1919: FROM gms_award_distributions
1920: WHERE expenditure_item_id = X_Expenditure_item_id
1921: AND document_type = 'EXP' -- To pick up only actuals and not encumbrances
1922: AND adl_status = 'A'
1923: AND fc_status = 'A'

Line 3014: FROM gms_award_distributions adl,

3010: gei.award_project_id = X_Award_Project_Id and
3011: gei.EVENT_NUM IS NULL
3012: AND EXISTS ( -- Bug 3235390 : Added below conditions to check for project and task.
3013: SELECT gei2.expenditure_item_id
3014: FROM gms_award_distributions adl,
3015: gms_event_intersect gei2
3016: WHERE gei2.expenditure_item_id = gei.expenditure_item_id
3017: AND adl.expenditure_item_id = gei2.expenditure_item_id
3018: AND adl.adl_status = 'A'

Line 3039: GMS_AWARD_DISTRIBUTIONS ADL

3035: AND EXISTS (
3036: SELECT
3037: ADL.EXPENDITURE_ITEM_ID
3038: FROM
3039: GMS_AWARD_DISTRIBUTIONS ADL
3040: WHERE ADL.EXPENDITURE_ITEM_ID = GEI.EXPENDITURE_ITEM_ID
3041: AND ADL.ADL_STATUS = 'A'
3042: AND ADL.DOCUMENT_TYPE ='EXP'
3043: AND ADL.PROJECT_ID = x_act_project_id

Line 3381: -- Procedure UPD_ADL_BILLING_FLAG: Updates GMS_AWARD_DISTRIBUTIONS table sets the

3377:
3378: End UPD_GSPF_WRAPPER;
3379:
3380: -----------------------------------------------------------------------------------------
3381: -- Procedure UPD_ADL_BILLING_FLAG: Updates GMS_AWARD_DISTRIBUTIONS table sets the
3382: -- Billed Flag and Revenue Distributed flag to 'Y' for the expenditure item that has been processed
3383: -----------------------------------------------------------------------------------------
3384: PROCEDURE UPD_ADL_BILLING_FLAG(X_Expenditure_Item_Id IN NUMBER,
3385: X_Adl_Line_Num IN NUMBER,

Line 3395: GMS_AWARD_DISTRIBUTIONS

3391:
3392: Begin
3393: If X_Calling_Process = 'Invoice' then
3394: update
3395: GMS_AWARD_DISTRIBUTIONS
3396: set
3397: BILLED_FLAG = 'Y'
3398: ,last_update_date = sysdate
3399: ,last_updated_by = fnd_global.user_id

Line 3408: GMS_AWARD_DISTRIBUTIONS

3404: and adl_status = 'A';
3405:
3406: Elsif X_Calling_Process = 'Revenue' then
3407: update
3408: GMS_AWARD_DISTRIBUTIONS
3409: set
3410: revenue_distributed_flag = 'Y'
3411: ,last_update_date = sysdate
3412: ,last_updated_by = fnd_global.user_id

Line 3450: gms_award_distributions adl

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
3453: and adl.adl_line_num = gei.adl_line_num
3454: and adl.document_type ='EXP'

Line 3863: gms_award_distributions adl

3859: ,adl.task_id Actual_Task_Id
3860: ,sum(gei.Amount) amount
3861: from
3862: gms_event_intersect gei,
3863: gms_award_distributions adl
3864: where
3865: gei.award_project_id = X_Proj_Id and
3866: gei.request_id = X_Req_Id and
3867: gei.event_type = 'INVOICE' and

Line 4388: gms_award_distributions adl

4384:
4385: CURSOR GET_RAW_ROWS_FROM_INTERSECT IS
4386: SELECT 'Y'
4387: FROM gms_event_intersect gei,
4388: gms_award_distributions adl
4389: WHERE gei.award_project_id = X_Project_Id
4390: AND gei.request_id = X_Request_Id
4391: AND gei.event_type = 'REVENUE'
4392: AND gei.event_num is NULL

Line 4611: X_Adl_Line_Num gms_award_distributions.adl_line_num%type;

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;
4612: X_Cdl_Line_Num gms_award_distributions.cdl_line_num%type; --bug 2909746
4613: X_Parent_Adl_Line_Num gms_award_distributions.parent_adl_line_num%type;
4614: X_Adl_Status gms_award_distributions.adl_status%type;
4615: X_Bill_Award_Id gms_award_distributions.award_id%type;

Line 4612: X_Cdl_Line_Num gms_award_distributions.cdl_line_num%type; --bug 2909746

4608: X_First_Indicator BOOLEAN := TRUE;
4609:
4610: -- 11.5 Changes Start
4611: X_Adl_Line_Num gms_award_distributions.adl_line_num%type;
4612: X_Cdl_Line_Num gms_award_distributions.cdl_line_num%type; --bug 2909746
4613: X_Parent_Adl_Line_Num gms_award_distributions.parent_adl_line_num%type;
4614: X_Adl_Status gms_award_distributions.adl_status%type;
4615: X_Bill_Award_Id gms_award_distributions.award_id%type;
4616: St_Err_Code NUMBER(1);

Line 4613: X_Parent_Adl_Line_Num gms_award_distributions.parent_adl_line_num%type;

4609:
4610: -- 11.5 Changes Start
4611: X_Adl_Line_Num gms_award_distributions.adl_line_num%type;
4612: X_Cdl_Line_Num gms_award_distributions.cdl_line_num%type; --bug 2909746
4613: X_Parent_Adl_Line_Num gms_award_distributions.parent_adl_line_num%type;
4614: X_Adl_Status gms_award_distributions.adl_status%type;
4615: X_Bill_Award_Id gms_award_distributions.award_id%type;
4616: St_Err_Code NUMBER(1);
4617: St_Err_Buff Varchar2(2000);

Line 4614: X_Adl_Status gms_award_distributions.adl_status%type;

4610: -- 11.5 Changes Start
4611: X_Adl_Line_Num gms_award_distributions.adl_line_num%type;
4612: X_Cdl_Line_Num gms_award_distributions.cdl_line_num%type; --bug 2909746
4613: X_Parent_Adl_Line_Num gms_award_distributions.parent_adl_line_num%type;
4614: X_Adl_Status gms_award_distributions.adl_status%type;
4615: X_Bill_Award_Id gms_award_distributions.award_id%type;
4616: St_Err_Code NUMBER(1);
4617: St_Err_Buff Varchar2(2000);
4618: X_Installment_Status Varchar2(1) :=null;

Line 4615: X_Bill_Award_Id gms_award_distributions.award_id%type;

4611: X_Adl_Line_Num gms_award_distributions.adl_line_num%type;
4612: X_Cdl_Line_Num gms_award_distributions.cdl_line_num%type; --bug 2909746
4613: X_Parent_Adl_Line_Num gms_award_distributions.parent_adl_line_num%type;
4614: X_Adl_Status gms_award_distributions.adl_status%type;
4615: X_Bill_Award_Id gms_award_distributions.award_id%type;
4616: St_Err_Code NUMBER(1);
4617: St_Err_Buff Varchar2(2000);
4618: X_Installment_Status Varchar2(1) :=null;
4619: X_Count Number :=0;

Line 4642: X_Adl_Lock_Exp_Id gms_award_distributions.expenditure_item_id%type; -- 11.5 change

4638: X_Err_Stg VARCHAR2(200) := NULL;
4639:
4640: X_Lock_Exp_Id VARCHAR2(30);
4641:
4642: X_Adl_Lock_Exp_Id gms_award_distributions.expenditure_item_id%type; -- 11.5 change
4643:
4644: X_Orig_Item_Billed_Flag VARCHAR2(2);
4645: X_Actual_project_id NUMBER(15);
4646: X_Adl_Orig_Item_Billed_Flag VARCHAR2(1); -- 11.5 change

Line 4676: X_burdenable_raw_cost gms_award_distributions.burdenable_raw_cost%type;

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:
4679: Begin
4680:

Line 4825: gms_award_distributions

4821: select expenditure_item_id
4822: into
4823: X_Adl_Lock_Exp_Id
4824: from
4825: gms_award_distributions
4826: where expenditure_item_id = X_Expenditure_Item_Id
4827: and adl_line_num=X_Adl_Line_Num
4828: and document_type='EXP'
4829: and adl_status = 'A'

Line 4843: gms_award_distributions adl

4839: nvl(adl.billed_flag,'N')
4840: into
4841: X_Orig_Item_Billed_Flag
4842: from
4843: gms_award_distributions adl
4844: where
4845: expenditure_item_id = X_Adjusted_Expenditure_Item_Id
4846: and
4847: award_id = X_Bill_award_id

Line 4855: from gms_award_distributions

4851: document_type ='EXP'
4852: and
4853: adl_line_num =
4854: (select max(adl_line_num)
4855: from gms_award_distributions
4856: where expenditure_item_id = X_Adjusted_Expenditure_Item_Id
4857: and award_id = X_Bill_award_id
4858: and adl_status='A'
4859: and document_type ='EXP');

Line 5361: -- Update GMS_AWARD_DISTRIBUTIONS set Billed_Flag to 'Y' indicating item has been picked for Invoicing

5357: OR ((X_Amount_To_Insert = 0 ) AND (X_Tot_Burd_Amt_To_Insert = 0 )) THEN -- added for bug 5182669
5358: ---OR ((X_Raw_Cost + X_Tot_Burden_Amt_In_View) = (X_Amount_In_Intersect + X_Tot_Burd_Amt_In_Tmp)) then --bug 5122434--commented for bug 5182669
5359:
5360:
5361: -- Update GMS_AWARD_DISTRIBUTIONS set Billed_Flag to 'Y' indicating item has been picked for Invoicing
5362:
5363: IF L_DEBUG = 'Y' THEN
5364: gms_error_pkg.gms_debug('Format specific Billing : Calling UPD_ADL_BILLING_FLAG for expenditure '||X_Expenditure_Item_Id,'C');
5365: END IF;

Line 5532: INDEX(adl gms_award_distributions_n7) / / Added INDEX(adl gms_award_distributions_n7) for 6969435 */

5528: --Bug : 2909746 - change the order by clause from adl.adl_line_num to adl.cdl_line_num
5529: -- 11.5, rev_cur_select cursor changed, so that certain columns are picked up from the adl table
5530: CURSOR rev_cur_select IS
5531: Select /*+INDEX(ei PA_EXPENDITURE_ITEMS_U1)
5532: INDEX(adl gms_award_distributions_n7) */ /* Added INDEX(adl gms_award_distributions_n7) for 6969435 */
5533: p.project_id
5534: , adl.task_id
5535: , ei.expenditure_type
5536: , nvl(ei.override_to_organization_id,e.incurred_by_organization_id) EXPENDITURE_ORG

Line 5554: gms_award_distributions adl /* Moved this up in the order for 6969435*/

5550: , adl.ind_compiled_set_id
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

Line 5690: X_ind_compiled_Set_id gms_award_distributions.ind_compiled_set_id%type;

5686: ss_text VARCHAR2(300);
5687: RESOURCE_BUSY EXCEPTION;
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

Line 5691: X_burdenable_raw_cost gms_award_distributions.burdenable_raw_cost%type;

5687: RESOURCE_BUSY EXCEPTION;
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:

Line 5763: gms_award_distributions

5759: select expenditure_item_id
5760: into
5761: X_Rev_Adl_Lock_Exp_Id
5762: from
5763: gms_award_distributions
5764: where expenditure_item_id = X_Rev_Expenditure_Item_Id
5765: and adl_line_num=X_Rev_Adl_Line_Num
5766: and document_type='EXP'
5767: and adl_status = 'A'

Line 5779: gms_award_distributions

5775: nvl(revenue_distributed_flag,'N')
5776: into
5777: X_Rev_Orig_Item_Distr_Flag
5778: from
5779: gms_award_distributions
5780: where expenditure_item_id = X_Rev_Adjusted_Exp_Item_Id
5781: and award_id = X_Rev_award_id
5782: and adl_status='A'
5783: and document_type ='EXP'

Line 5786: from gms_award_distributions

5782: and adl_status='A'
5783: and document_type ='EXP'
5784: and adl_line_num =
5785: (select max(adl_line_num)
5786: from gms_award_distributions
5787: where expenditure_item_id = X_Rev_Adjusted_Exp_Item_Id
5788: and award_id = X_Rev_award_id
5789: and adl_status='A'
5790: and document_type ='EXP');

Line 6824: ||' pa_tasks t3, pa_tasks t5, gms_award_distributions adl ';

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 --- */
6827: --1. gms_award_distributions added in the from clause
6828: --2. 4 new columns being selected from gms_award_distributions, raw_cost picked differently

Line 6827: --1. gms_award_distributions added in the from clause

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 --- */
6827: --1. gms_award_distributions added in the from clause
6828: --2. 4 new columns being selected from gms_award_distributions, raw_cost picked differently
6829:
6830:
6831: /* The DYNAMIC WHERE CLAUSE BUILDING below for Revenue is NOT USED any more. Replaced by the Procedure

Line 6828: --2. 4 new columns being selected from gms_award_distributions, raw_cost picked differently

6824: ||' pa_tasks t3, pa_tasks t5, gms_award_distributions adl ';
6825:
6826: /* --- 11.5 changes --- */
6827: --1. gms_award_distributions added in the from clause
6828: --2. 4 new columns being selected from gms_award_distributions, raw_cost picked differently
6829:
6830:
6831: /* The DYNAMIC WHERE CLAUSE BUILDING below for Revenue is NOT USED any more. Replaced by the Procedure
6832: REVENUE_ACCRUAL

Line 6841: -- 1.Columns like billed_flag,award_id, revenue_distributed_flag being picked from gms_award_distributions

6837:
6838: Elsif X_calling_process = 'Invoice' then
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: */

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 '