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 3013: FROM gms_award_distributions adl,

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

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

3352:
3353: End UPD_GSPF_WRAPPER;
3354:
3355: -----------------------------------------------------------------------------------------
3356: -- Procedure UPD_ADL_BILLING_FLAG: Updates GMS_AWARD_DISTRIBUTIONS table sets the
3357: -- Billed Flag and Revenue Distributed flag to 'Y' for the expenditure item that has been processed
3358: -----------------------------------------------------------------------------------------
3359: PROCEDURE UPD_ADL_BILLING_FLAG(X_Expenditure_Item_Id IN NUMBER,
3360: X_Adl_Line_Num IN NUMBER,

Line 3370: GMS_AWARD_DISTRIBUTIONS

3366:
3367: Begin
3368: If X_Calling_Process = 'Invoice' then
3369: update
3370: GMS_AWARD_DISTRIBUTIONS
3371: set
3372: BILLED_FLAG = 'Y'
3373: ,last_update_date = sysdate
3374: ,last_updated_by = fnd_global.user_id

Line 3383: GMS_AWARD_DISTRIBUTIONS

3379: and adl_status = 'A';
3380:
3381: Elsif X_Calling_Process = 'Revenue' then
3382: update
3383: GMS_AWARD_DISTRIBUTIONS
3384: set
3385: revenue_distributed_flag = 'Y'
3386: ,last_update_date = sysdate
3387: ,last_updated_by = fnd_global.user_id

Line 3425: gms_award_distributions adl

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

Line 3838: gms_award_distributions adl

3834: ,adl.task_id Actual_Task_Id
3835: ,sum(gei.Amount) amount
3836: from
3837: gms_event_intersect gei,
3838: gms_award_distributions adl
3839: where
3840: gei.award_project_id = X_Proj_Id and
3841: gei.request_id = X_Req_Id and
3842: gei.event_type = 'INVOICE' and

Line 4363: gms_award_distributions adl

4359:
4360: CURSOR GET_RAW_ROWS_FROM_INTERSECT IS
4361: SELECT 'Y'
4362: FROM gms_event_intersect gei,
4363: gms_award_distributions adl
4364: WHERE gei.award_project_id = X_Project_Id
4365: AND gei.request_id = X_Request_Id
4366: AND gei.event_type = 'REVENUE'
4367: AND gei.event_num is NULL

Line 4583: X_Adl_Line_Num gms_award_distributions.adl_line_num%type;

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;
4584: X_Cdl_Line_Num gms_award_distributions.cdl_line_num%type; --bug 2909746
4585: X_Parent_Adl_Line_Num gms_award_distributions.parent_adl_line_num%type;
4586: X_Adl_Status gms_award_distributions.adl_status%type;
4587: X_Bill_Award_Id gms_award_distributions.award_id%type;

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

4580: X_First_Indicator BOOLEAN := TRUE;
4581:
4582: -- 11.5 Changes Start
4583: X_Adl_Line_Num gms_award_distributions.adl_line_num%type;
4584: X_Cdl_Line_Num gms_award_distributions.cdl_line_num%type; --bug 2909746
4585: X_Parent_Adl_Line_Num gms_award_distributions.parent_adl_line_num%type;
4586: X_Adl_Status gms_award_distributions.adl_status%type;
4587: X_Bill_Award_Id gms_award_distributions.award_id%type;
4588: St_Err_Code NUMBER(1);

Line 4585: X_Parent_Adl_Line_Num gms_award_distributions.parent_adl_line_num%type;

4581:
4582: -- 11.5 Changes Start
4583: X_Adl_Line_Num gms_award_distributions.adl_line_num%type;
4584: X_Cdl_Line_Num gms_award_distributions.cdl_line_num%type; --bug 2909746
4585: X_Parent_Adl_Line_Num gms_award_distributions.parent_adl_line_num%type;
4586: X_Adl_Status gms_award_distributions.adl_status%type;
4587: X_Bill_Award_Id gms_award_distributions.award_id%type;
4588: St_Err_Code NUMBER(1);
4589: St_Err_Buff Varchar2(2000);

Line 4586: X_Adl_Status gms_award_distributions.adl_status%type;

4582: -- 11.5 Changes Start
4583: X_Adl_Line_Num gms_award_distributions.adl_line_num%type;
4584: X_Cdl_Line_Num gms_award_distributions.cdl_line_num%type; --bug 2909746
4585: X_Parent_Adl_Line_Num gms_award_distributions.parent_adl_line_num%type;
4586: X_Adl_Status gms_award_distributions.adl_status%type;
4587: X_Bill_Award_Id gms_award_distributions.award_id%type;
4588: St_Err_Code NUMBER(1);
4589: St_Err_Buff Varchar2(2000);
4590: X_Installment_Status Varchar2(1) :=null;

Line 4587: X_Bill_Award_Id gms_award_distributions.award_id%type;

4583: X_Adl_Line_Num gms_award_distributions.adl_line_num%type;
4584: X_Cdl_Line_Num gms_award_distributions.cdl_line_num%type; --bug 2909746
4585: X_Parent_Adl_Line_Num gms_award_distributions.parent_adl_line_num%type;
4586: X_Adl_Status gms_award_distributions.adl_status%type;
4587: X_Bill_Award_Id gms_award_distributions.award_id%type;
4588: St_Err_Code NUMBER(1);
4589: St_Err_Buff Varchar2(2000);
4590: X_Installment_Status Varchar2(1) :=null;
4591: X_Count Number :=0;

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

4610: X_Err_Stg VARCHAR2(200) := NULL;
4611:
4612: X_Lock_Exp_Id VARCHAR2(30);
4613:
4614: X_Adl_Lock_Exp_Id gms_award_distributions.expenditure_item_id%type; -- 11.5 change
4615:
4616: X_Orig_Item_Billed_Flag VARCHAR2(2);
4617: X_Actual_project_id NUMBER(15);
4618: X_Adl_Orig_Item_Billed_Flag VARCHAR2(1); -- 11.5 change

Line 4648: X_burdenable_raw_cost gms_award_distributions.burdenable_raw_cost%type;

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:
4651: Begin
4652:

Line 4797: gms_award_distributions

4793: select expenditure_item_id
4794: into
4795: X_Adl_Lock_Exp_Id
4796: from
4797: gms_award_distributions
4798: where expenditure_item_id = X_Expenditure_Item_Id
4799: and adl_line_num=X_Adl_Line_Num
4800: and document_type='EXP'
4801: and adl_status = 'A'

Line 4815: gms_award_distributions adl

4811: nvl(adl.billed_flag,'N')
4812: into
4813: X_Orig_Item_Billed_Flag
4814: from
4815: gms_award_distributions adl
4816: where
4817: expenditure_item_id = X_Adjusted_Expenditure_Item_Id
4818: and
4819: award_id = X_Bill_award_id

Line 4827: from gms_award_distributions

4823: document_type ='EXP'
4824: and
4825: adl_line_num =
4826: (select max(adl_line_num)
4827: from gms_award_distributions
4828: where expenditure_item_id = X_Adjusted_Expenditure_Item_Id
4829: and award_id = X_Bill_award_id
4830: and adl_status='A'
4831: and document_type ='EXP');

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

5328: OR ((X_Amount_To_Insert = 0 ) AND (X_Tot_Burd_Amt_To_Insert = 0 )) THEN -- added for bug 5182669
5329: ---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
5330:
5331:
5332: -- Update GMS_AWARD_DISTRIBUTIONS set Billed_Flag to 'Y' indicating item has been picked for Invoicing
5333:
5334: IF L_DEBUG = 'Y' THEN
5335: gms_error_pkg.gms_debug('Format specific Billing : Calling UPD_ADL_BILLING_FLAG for expenditure '||X_Expenditure_Item_Id,'C');
5336: END IF;

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

5499: --Bug : 2909746 - change the order by clause from adl.adl_line_num to adl.cdl_line_num
5500: -- 11.5, rev_cur_select cursor changed, so that certain columns are picked up from the adl table
5501: CURSOR rev_cur_select IS
5502: Select /*+INDEX(ei PA_EXPENDITURE_ITEMS_U1)
5503: INDEX(adl gms_award_distributions_n7) */ /* Added INDEX(adl gms_award_distributions_n7) for 6969435 */
5504: p.project_id
5505: , adl.task_id
5506: , ei.expenditure_type
5507: , nvl(ei.override_to_organization_id,e.incurred_by_organization_id) EXPENDITURE_ORG

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

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

Line 5661: X_ind_compiled_Set_id gms_award_distributions.ind_compiled_set_id%type;

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

Line 5662: X_burdenable_raw_cost gms_award_distributions.burdenable_raw_cost%type;

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

Line 5734: gms_award_distributions

5730: select expenditure_item_id
5731: into
5732: X_Rev_Adl_Lock_Exp_Id
5733: from
5734: gms_award_distributions
5735: where expenditure_item_id = X_Rev_Expenditure_Item_Id
5736: and adl_line_num=X_Rev_Adl_Line_Num
5737: and document_type='EXP'
5738: and adl_status = 'A'

Line 5750: gms_award_distributions

5746: nvl(revenue_distributed_flag,'N')
5747: into
5748: X_Rev_Orig_Item_Distr_Flag
5749: from
5750: gms_award_distributions
5751: where expenditure_item_id = X_Rev_Adjusted_Exp_Item_Id
5752: and award_id = X_Rev_award_id
5753: and adl_status='A'
5754: and document_type ='EXP'

Line 5757: from gms_award_distributions

5753: and adl_status='A'
5754: and document_type ='EXP'
5755: and adl_line_num =
5756: (select max(adl_line_num)
5757: from gms_award_distributions
5758: where expenditure_item_id = X_Rev_Adjusted_Exp_Item_Id
5759: and award_id = X_Rev_award_id
5760: and adl_status='A'
5761: and document_type ='EXP');

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

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

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

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

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

6793: ||' pa_tasks t3, pa_tasks t5, gms_award_distributions adl ';
6794:
6795: /* --- 11.5 changes --- */
6796: --1. gms_award_distributions added in the from clause
6797: --2. 4 new columns being selected from gms_award_distributions, raw_cost picked differently
6798:
6799:
6800: /* The DYNAMIC WHERE CLAUSE BUILDING below for Revenue is NOT USED any more. Replaced by the Procedure
6801: REVENUE_ACCRUAL

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

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

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 '