APPS.GMS_BILLING_ADJUSTMENTS dependencies on GMS_AWARD_DISTRIBUTIONS

Line 55: Update gms_award_distributions adl

51:
52: End If;
53:
54: -- B. Update ADL Flag ..
55: Update gms_award_distributions adl
56: set adl.billed_flag = decode(p_calling_process,'REVENUE',
57: adl.billed_flag,'N'),
58: adl.revenue_distributed_flag = decode(p_calling_process,'INVOICE',
59: adl.revenue_distributed_flag,'N')

Line 892: UPDATE GMS_AWARD_DISTRIBUTIONS

888: Begin
889:
890: If X_Calling_Process = 'Invoice' then
891:
892: UPDATE GMS_AWARD_DISTRIBUTIONS
893: set
894: billed_flag = 'N'
895: ,last_update_date = sysdate
896: ,last_updated_by = fnd_global.user_id

Line 953: UPDATE GMS_AWARD_DISTRIBUTIONS

949: Else
950: X_Err_Code := 'S';
951: End If;
952: */
953: UPDATE GMS_AWARD_DISTRIBUTIONS
954: set
955: revenue_distributed_flag = 'N'
956: ,last_update_date = sysdate
957: ,last_updated_by = fnd_global.user_id

Line 1356: /* Updating PA_EXPENDITURE_ITEMS_ALL and GMS_AWARD_DISTRIBUTIONS, setting the Revenue Accrued Flag to 'N' */

1352: F_request_id; -- 4594090
1353:
1354: EXIT WHEN IDENT_INV_INTRSCT_ITEMS%NOTFOUND;
1355:
1356: /* Updating PA_EXPENDITURE_ITEMS_ALL and GMS_AWARD_DISTRIBUTIONS, setting the Revenue Accrued Flag to 'N' */
1357: UPD_PA_EXP_AND_ADL(F_Award_Project_id,
1358: F_Expenditure_Item_Id,
1359: F_Adl_Line_No,
1360: X_Calling_Process,

Line 1454: /* On GMS_AWARD_DISTRIBUTIONS setting the Invoice Accrued Flag to 'N' */

1450:
1451: EXIT WHEN BURDEN_INV_INTRSCT_ITEMS%NOTFOUND;
1452:
1453: -- Bug 2477972, start
1454: /* On GMS_AWARD_DISTRIBUTIONS setting the Invoice Accrued Flag to 'N' */
1455: UPD_PA_EXP_AND_ADL(F_Award_Project_id,
1456: F_Burd_Expenditure_Item_Id,
1457: F_Burd_Adl_Line_No,
1458: X_Calling_Process,

Line 1755: /* Updating PA_EXPENDITURE_ITEMS_ALL and GMS_AWARD_DISTRIBUTIONS, setting the Revenue Accrued Flag to 'N' */

1751: F_Rev_Accumulated,
1752: F_request_id; -- 4594090
1753: EXIT WHEN IDENT_REV_INTRSCT_ITEMS%NOTFOUND;
1754:
1755: /* Updating PA_EXPENDITURE_ITEMS_ALL and GMS_AWARD_DISTRIBUTIONS, setting the Revenue Accrued Flag to 'N' */
1756: UPD_PA_EXP_AND_ADL(F_Award_Project_id,
1757: F_Expenditure_Item_Id,
1758: F_Adl_Line_No,
1759: X_Calling_Process,

Line 1873: /* On GMS_AWARD_DISTRIBUTIONS setting the Revenue Accrued Flag to 'N' */

1869: F_request_id; -- 4594090
1870: EXIT WHEN BURDEN_REV_INTRSCT_ITEMS%NOTFOUND;
1871:
1872: -- Bug 2477972, Start
1873: /* On GMS_AWARD_DISTRIBUTIONS setting the Revenue Accrued Flag to 'N' */
1874: UPD_PA_EXP_AND_ADL(F_Award_Project_id,
1875: F_Rev_Burd_Expend_Item_Id,
1876: F_Rev_Adl_Line_No,
1877: X_Calling_Process,