DBA Data[Home] [Help]

APPS.PA_REVENUE_AMT dependencies on PA_DRAFT_REVENUE_ITEMS

Line 1007: l_message_code := 'Error in update on pa_draft_revenue_items';

1003: exp_cur_rec.DRAFT_REVENUE_NUM
1004: AND l.draft_revenue_item_line_num =
1005: exp_cur_rec.DRAFT_REVENUE_ITEM_LINE_NUM;
1006:
1007: l_message_code := 'Error in update on pa_draft_revenue_items';
1008:
1009: UPDATE pa_draft_revenue_items i
1010: SET i.amount = i.amount - roundoff_amount,
1011: i.projfunc_revenue_amount = -- Below lines added for Bug 5042421

Line 1009: UPDATE pa_draft_revenue_items i

1005: exp_cur_rec.DRAFT_REVENUE_ITEM_LINE_NUM;
1006:
1007: l_message_code := 'Error in update on pa_draft_revenue_items';
1008:
1009: UPDATE pa_draft_revenue_items i
1010: SET i.amount = i.amount - roundoff_amount,
1011: i.projfunc_revenue_amount = -- Below lines added for Bug 5042421
1012: DECODE(i.revproc_currency_code, i.projfunc_currency_code,
1013: i.amount - roundoff_amount,