APPS.PA_MCB_REVENUE_PKG dependencies on PA_DRAFT_REVENUES

Line 1881: to mark in pa_draft_revenues table */

1877: END IF;
1878:
1879:
1880: /* Get the draft revenue number for conversion fail cases
1881: to mark in pa_draft_revenues table */
1882:
1883:
1884: IF g1_debug_mode = 'Y' THEN
1885: PA_MCB_INVOICE_PKG.log_message('rdl_amount_conversion: ' || 'Inside the loop ........');

Line 2092: to mark in pa_draft_revenues table */

2088: END IF;
2089:
2090:
2091: /* Get the draft revenue number for conversion fail cases
2092: to mark in pa_draft_revenues table */
2093:
2094:
2095: IF g1_debug_mode = 'Y' THEN
2096: PA_MCB_INVOICE_PKG.log_message('rdl_amount_conversion: ' || 'Before setting the error status........');

Line 2184: UPDATE pa_draft_revenues

2180: IF l_rev_in_txn_curr_flag = 'Y' THEN
2181: IF l_error_rt_dr_rev_num_tab.COUNT <> 0 THEN
2182:
2183: FORALL J IN 1 .. l_error_rt_dr_rev_num_tab.COUNT
2184: UPDATE pa_draft_revenues
2185: SET generation_error_flag = 'Y',
2186: transfer_rejection_reason = l_error_revtrans_status_tab(j)
2187: WHERE project_id = p_project_id
2188: AND draft_revenue_num = l_error_rt_dr_rev_num_tab(J);

Line 2200: UPDATE pa_draft_revenues

2196:
2197: IF l_error_draft_rev_num_tab.COUNT <> 0 THEN
2198:
2199: FORALL J IN 1 .. l_error_draft_rev_num_tab.COUNT
2200: UPDATE pa_draft_revenues
2201: SET generation_error_flag = 'Y',
2202: transfer_rejection_reason = l_error_funding_status_tab(J)
2203: WHERE project_id = p_project_id
2204: AND draft_revenue_num = l_error_draft_rev_num_tab(J);

Line 2449: UPDATE pa_draft_revenues

2445:
2446:
2447: IF (l_funding_status_tab(1) <> 'N') THEN
2448:
2449: UPDATE pa_draft_revenues
2450: SET generation_error_flag = 'Y',
2451: transfer_rejection_reason = l_funding_status_tab(1)
2452: WHERE project_id = p_project_id
2453: AND draft_revenue_num = p_draft_revenue_num;

Line 2537: UPDATE pa_draft_revenues

2533: PA_MCB_INVOICE_PKG.log_message('erdl_amount_conversion: ' || 'Revtrans Amt Rejection Reason :' || l_funding_status_tab(1));
2534: END IF;
2535: IF (l_funding_status_tab(1) <> 'N') THEN
2536:
2537: UPDATE pa_draft_revenues
2538: SET generation_error_flag = 'Y',
2539: transfer_rejection_reason = l_funding_status_tab(1)
2540: WHERE project_id = p_project_id
2541: AND draft_revenue_num = p_draft_revenue_num;