APPS.PA_MCB_REVENUE_PKG dependencies on PA_DRAFT_REVENUES

Line 1838: to mark in pa_draft_revenues table */

1834: END IF;
1835:
1836:
1837: /* Get the draft revenue number for conversion fail cases
1838: to mark in pa_draft_revenues table */
1839:
1840:
1841: IF g1_debug_mode = 'Y' THEN
1842: PA_MCB_INVOICE_PKG.log_message('rdl_amount_conversion: ' || 'Inside the loop ........');

Line 2049: to mark in pa_draft_revenues table */

2045: END IF;
2046:
2047:
2048: /* Get the draft revenue number for conversion fail cases
2049: to mark in pa_draft_revenues table */
2050:
2051:
2052: IF g1_debug_mode = 'Y' THEN
2053: PA_MCB_INVOICE_PKG.log_message('rdl_amount_conversion: ' || 'Before setting the error status........');

Line 2140: UPDATE pa_draft_revenues

2136: IF l_rev_in_txn_curr_flag = 'Y' THEN
2137: IF l_error_rt_dr_rev_num_tab.COUNT <> 0 THEN
2138:
2139: FORALL J IN 1 .. l_error_rt_dr_rev_num_tab.COUNT
2140: UPDATE pa_draft_revenues
2141: SET generation_error_flag = 'Y',
2142: transfer_rejection_reason = l_error_revtrans_status_tab(j)
2143: WHERE project_id = p_project_id
2144: AND draft_revenue_num = l_error_rt_dr_rev_num_tab(J);

Line 2156: UPDATE pa_draft_revenues

2152:
2153: IF l_error_draft_rev_num_tab.COUNT <> 0 THEN
2154:
2155: FORALL J IN 1 .. l_error_draft_rev_num_tab.COUNT
2156: UPDATE pa_draft_revenues
2157: SET generation_error_flag = 'Y',
2158: transfer_rejection_reason = l_error_funding_status_tab(J)
2159: WHERE project_id = p_project_id
2160: AND draft_revenue_num = l_error_draft_rev_num_tab(J);

Line 2405: UPDATE pa_draft_revenues

2401:
2402:
2403: IF (l_funding_status_tab(1) <> 'N') THEN
2404:
2405: UPDATE pa_draft_revenues
2406: SET generation_error_flag = 'Y',
2407: transfer_rejection_reason = l_funding_status_tab(1)
2408: WHERE project_id = p_project_id
2409: AND draft_revenue_num = p_draft_revenue_num;

Line 2493: UPDATE pa_draft_revenues

2489: PA_MCB_INVOICE_PKG.log_message('erdl_amount_conversion: ' || 'Revtrans Amt Rejection Reason :' || l_funding_status_tab(1));
2490: END IF;
2491: IF (l_funding_status_tab(1) <> 'N') THEN
2492:
2493: UPDATE pa_draft_revenues
2494: SET generation_error_flag = 'Y',
2495: transfer_rejection_reason = l_funding_status_tab(1)
2496: WHERE project_id = p_project_id
2497: AND draft_revenue_num = p_draft_revenue_num;