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.AP_WEB_DB_EXPDIST_PKG dependencies on AP_EXP_REPORT_DISTS_ALL

Line 609: FROM AP_EXP_REPORT_DISTS_ALL

605: IS
606: --------------------------------------------------------------------------------
607: CURSOR dist_lines_c IS
608: SELECT *
609: FROM AP_EXP_REPORT_DISTS_ALL
610: WHERE REPORT_HEADER_ID = p_report_header_id
611: FOR UPDATE OF REPORT_HEADER_ID NOWAIT;
612:
613: dist_lines_rec dist_lines_c%ROWTYPE;

Line 624: UPDATE ap_exp_report_dists_all

620: FETCH dist_lines_c into dist_lines_rec;
621: EXIT WHEN dist_lines_c%NOTFOUND;
622:
623: IF dist_lines_rec.CODE_COMBINATION_ID IS NOT NULL THEN
624: UPDATE ap_exp_report_dists_all
625: SET (segment1,
626: segment2,
627: segment3,
628: segment4,

Line 897: l_amount ap_exp_report_dists_all.amount%TYPE;

893: l_created_by NUMBER;
894: l_report_distribution_id expDist_REPORT_DISTRIBUTION_ID;
895: l_code_combination_id expDist_CODE_COMBINATION_ID;
896: l_org_id NUMBER;
897: l_amount ap_exp_report_dists_all.amount%TYPE;
898: l_project_id ap_exp_report_dists_all.project_id%TYPE;
899: l_task_id ap_exp_report_dists_all.task_id%TYPE;
900: l_award_id ap_exp_report_dists_all.award_id%TYPE;
901: l_expenditure_organization_id ap_exp_report_dists_all.expenditure_organization_id%TYPE;

Line 898: l_project_id ap_exp_report_dists_all.project_id%TYPE;

894: l_report_distribution_id expDist_REPORT_DISTRIBUTION_ID;
895: l_code_combination_id expDist_CODE_COMBINATION_ID;
896: l_org_id NUMBER;
897: l_amount ap_exp_report_dists_all.amount%TYPE;
898: l_project_id ap_exp_report_dists_all.project_id%TYPE;
899: l_task_id ap_exp_report_dists_all.task_id%TYPE;
900: l_award_id ap_exp_report_dists_all.award_id%TYPE;
901: l_expenditure_organization_id ap_exp_report_dists_all.expenditure_organization_id%TYPE;
902: l_cost_center ap_exp_report_dists_all.cost_center%TYPE;

Line 899: l_task_id ap_exp_report_dists_all.task_id%TYPE;

895: l_code_combination_id expDist_CODE_COMBINATION_ID;
896: l_org_id NUMBER;
897: l_amount ap_exp_report_dists_all.amount%TYPE;
898: l_project_id ap_exp_report_dists_all.project_id%TYPE;
899: l_task_id ap_exp_report_dists_all.task_id%TYPE;
900: l_award_id ap_exp_report_dists_all.award_id%TYPE;
901: l_expenditure_organization_id ap_exp_report_dists_all.expenditure_organization_id%TYPE;
902: l_cost_center ap_exp_report_dists_all.cost_center%TYPE;
903: l_cost_center_seg_num NUMBER;

Line 900: l_award_id ap_exp_report_dists_all.award_id%TYPE;

896: l_org_id NUMBER;
897: l_amount ap_exp_report_dists_all.amount%TYPE;
898: l_project_id ap_exp_report_dists_all.project_id%TYPE;
899: l_task_id ap_exp_report_dists_all.task_id%TYPE;
900: l_award_id ap_exp_report_dists_all.award_id%TYPE;
901: l_expenditure_organization_id ap_exp_report_dists_all.expenditure_organization_id%TYPE;
902: l_cost_center ap_exp_report_dists_all.cost_center%TYPE;
903: l_cost_center_seg_num NUMBER;
904: l_chart_of_accounts_id gl_sets_of_books.chart_of_accounts_id%type;

Line 901: l_expenditure_organization_id ap_exp_report_dists_all.expenditure_organization_id%TYPE;

897: l_amount ap_exp_report_dists_all.amount%TYPE;
898: l_project_id ap_exp_report_dists_all.project_id%TYPE;
899: l_task_id ap_exp_report_dists_all.task_id%TYPE;
900: l_award_id ap_exp_report_dists_all.award_id%TYPE;
901: l_expenditure_organization_id ap_exp_report_dists_all.expenditure_organization_id%TYPE;
902: l_cost_center ap_exp_report_dists_all.cost_center%TYPE;
903: l_cost_center_seg_num NUMBER;
904: l_chart_of_accounts_id gl_sets_of_books.chart_of_accounts_id%type;
905:

Line 902: l_cost_center ap_exp_report_dists_all.cost_center%TYPE;

898: l_project_id ap_exp_report_dists_all.project_id%TYPE;
899: l_task_id ap_exp_report_dists_all.task_id%TYPE;
900: l_award_id ap_exp_report_dists_all.award_id%TYPE;
901: l_expenditure_organization_id ap_exp_report_dists_all.expenditure_organization_id%TYPE;
902: l_cost_center ap_exp_report_dists_all.cost_center%TYPE;
903: l_cost_center_seg_num NUMBER;
904: l_chart_of_accounts_id gl_sets_of_books.chart_of_accounts_id%type;
905:
906: -- BUG 7025517

Line 1387: from ap_exp_report_dists_all

1383: l_last_dist_id NUMBER;
1384:
1385: cursor c_dists is
1386: select report_distribution_id, amount
1387: from ap_exp_report_dists_all
1388: where report_line_id = p_report_line_id;
1389:
1390: BEGIN
1391: select sum(amount) into l_dist_sum

Line 1392: from ap_exp_report_dists_all

1388: where report_line_id = p_report_line_id;
1389:
1390: BEGIN
1391: select sum(amount) into l_dist_sum
1392: from ap_exp_report_dists_all
1393: where report_line_id = p_report_line_id;
1394:
1395: IF (l_dist_sum <> 0) THEN
1396: l_remainder := p_line_amt;

Line 1407: update ap_exp_report_dists_all set amount = l_dist_amt

1403: -- 300 and 300, the new dists will be 200 * (300/600) = 100 and 100
1404: -- This logic will work in all cases and is used in ExpenseAllocationAMImpl.java as well.
1405: l_dist_amt := AP_WEB_UTILITIES_PKG.OIE_ROUND_CURRENCY(p_line_amt * (l_dist_amt/l_dist_sum), p_currency_code);
1406:
1407: update ap_exp_report_dists_all set amount = l_dist_amt
1408: where report_distribution_id = l_dist_id;
1409: l_remainder := l_remainder - l_dist_amt;
1410: l_last_dist_id := l_dist_id;
1411: end loop;

Line 1415: update ap_exp_report_dists_all set amount = (amount + l_remainder)

1411: end loop;
1412: close c_dists;
1413: -- If there is any line amount still remaining add it to the last line.
1414: if(l_remainder <> 0) then
1415: update ap_exp_report_dists_all set amount = (amount + l_remainder)
1416: where report_distribution_id = l_last_dist_id;
1417: end if;
1418: END IF;
1419: exception