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_EXPLINE_PKG dependencies on AP_EXP_REPORT_DISTS

Line 765: ap_exp_report_dists XD

761: XL.AP_VALIDATION_ERROR,
762: XL.Report_Line_id
763: FROM ap_expense_report_params XP,
764: ap_expense_report_lines XL,
765: ap_exp_report_dists XD
766: WHERE XL.report_header_id = p_exp_report_id
767: AND XL.web_parameter_id = XP.parameter_id
768: AND XD.report_line_id(+) = XL.report_line_id
769: AND (XL.itemization_parent_id is null OR XL.itemization_parent_id <> -1)

Line 1754: l_org_id AP_EXP_REPORT_DISTS.ORG_ID%TYPE;

1750: p_new_report_line_id IN NUMBER,
1751: p_distribution_line_number IN NUMBER) IS
1752:
1753: l_clearning_ccid NUMBER;
1754: l_org_id AP_EXP_REPORT_DISTS.ORG_ID%TYPE;
1755: l_sequence_num AP_EXP_REPORT_DISTS.SEQUENCE_NUM%TYPE;
1756: l_last_updated_by AP_EXP_REPORT_DISTS.LAST_UPDATED_BY%TYPE;
1757: l_created_by AP_EXP_REPORT_DISTS.CREATED_BY%TYPE;
1758: l_segment1 AP_EXP_REPORT_DISTS.SEGMENT1%TYPE;

Line 1755: l_sequence_num AP_EXP_REPORT_DISTS.SEQUENCE_NUM%TYPE;

1751: p_distribution_line_number IN NUMBER) IS
1752:
1753: l_clearning_ccid NUMBER;
1754: l_org_id AP_EXP_REPORT_DISTS.ORG_ID%TYPE;
1755: l_sequence_num AP_EXP_REPORT_DISTS.SEQUENCE_NUM%TYPE;
1756: l_last_updated_by AP_EXP_REPORT_DISTS.LAST_UPDATED_BY%TYPE;
1757: l_created_by AP_EXP_REPORT_DISTS.CREATED_BY%TYPE;
1758: l_segment1 AP_EXP_REPORT_DISTS.SEGMENT1%TYPE;
1759: l_segment2 AP_EXP_REPORT_DISTS.SEGMENT2%TYPE;

Line 1756: l_last_updated_by AP_EXP_REPORT_DISTS.LAST_UPDATED_BY%TYPE;

1752:
1753: l_clearning_ccid NUMBER;
1754: l_org_id AP_EXP_REPORT_DISTS.ORG_ID%TYPE;
1755: l_sequence_num AP_EXP_REPORT_DISTS.SEQUENCE_NUM%TYPE;
1756: l_last_updated_by AP_EXP_REPORT_DISTS.LAST_UPDATED_BY%TYPE;
1757: l_created_by AP_EXP_REPORT_DISTS.CREATED_BY%TYPE;
1758: l_segment1 AP_EXP_REPORT_DISTS.SEGMENT1%TYPE;
1759: l_segment2 AP_EXP_REPORT_DISTS.SEGMENT2%TYPE;
1760: l_segment3 AP_EXP_REPORT_DISTS.SEGMENT3%TYPE;

Line 1757: l_created_by AP_EXP_REPORT_DISTS.CREATED_BY%TYPE;

1753: l_clearning_ccid NUMBER;
1754: l_org_id AP_EXP_REPORT_DISTS.ORG_ID%TYPE;
1755: l_sequence_num AP_EXP_REPORT_DISTS.SEQUENCE_NUM%TYPE;
1756: l_last_updated_by AP_EXP_REPORT_DISTS.LAST_UPDATED_BY%TYPE;
1757: l_created_by AP_EXP_REPORT_DISTS.CREATED_BY%TYPE;
1758: l_segment1 AP_EXP_REPORT_DISTS.SEGMENT1%TYPE;
1759: l_segment2 AP_EXP_REPORT_DISTS.SEGMENT2%TYPE;
1760: l_segment3 AP_EXP_REPORT_DISTS.SEGMENT3%TYPE;
1761: l_segment4 AP_EXP_REPORT_DISTS.SEGMENT4%TYPE;

Line 1758: l_segment1 AP_EXP_REPORT_DISTS.SEGMENT1%TYPE;

1754: l_org_id AP_EXP_REPORT_DISTS.ORG_ID%TYPE;
1755: l_sequence_num AP_EXP_REPORT_DISTS.SEQUENCE_NUM%TYPE;
1756: l_last_updated_by AP_EXP_REPORT_DISTS.LAST_UPDATED_BY%TYPE;
1757: l_created_by AP_EXP_REPORT_DISTS.CREATED_BY%TYPE;
1758: l_segment1 AP_EXP_REPORT_DISTS.SEGMENT1%TYPE;
1759: l_segment2 AP_EXP_REPORT_DISTS.SEGMENT2%TYPE;
1760: l_segment3 AP_EXP_REPORT_DISTS.SEGMENT3%TYPE;
1761: l_segment4 AP_EXP_REPORT_DISTS.SEGMENT4%TYPE;
1762: l_segment5 AP_EXP_REPORT_DISTS.SEGMENT5%TYPE;

Line 1759: l_segment2 AP_EXP_REPORT_DISTS.SEGMENT2%TYPE;

1755: l_sequence_num AP_EXP_REPORT_DISTS.SEQUENCE_NUM%TYPE;
1756: l_last_updated_by AP_EXP_REPORT_DISTS.LAST_UPDATED_BY%TYPE;
1757: l_created_by AP_EXP_REPORT_DISTS.CREATED_BY%TYPE;
1758: l_segment1 AP_EXP_REPORT_DISTS.SEGMENT1%TYPE;
1759: l_segment2 AP_EXP_REPORT_DISTS.SEGMENT2%TYPE;
1760: l_segment3 AP_EXP_REPORT_DISTS.SEGMENT3%TYPE;
1761: l_segment4 AP_EXP_REPORT_DISTS.SEGMENT4%TYPE;
1762: l_segment5 AP_EXP_REPORT_DISTS.SEGMENT5%TYPE;
1763: l_segment6 AP_EXP_REPORT_DISTS.SEGMENT6%TYPE;

Line 1760: l_segment3 AP_EXP_REPORT_DISTS.SEGMENT3%TYPE;

1756: l_last_updated_by AP_EXP_REPORT_DISTS.LAST_UPDATED_BY%TYPE;
1757: l_created_by AP_EXP_REPORT_DISTS.CREATED_BY%TYPE;
1758: l_segment1 AP_EXP_REPORT_DISTS.SEGMENT1%TYPE;
1759: l_segment2 AP_EXP_REPORT_DISTS.SEGMENT2%TYPE;
1760: l_segment3 AP_EXP_REPORT_DISTS.SEGMENT3%TYPE;
1761: l_segment4 AP_EXP_REPORT_DISTS.SEGMENT4%TYPE;
1762: l_segment5 AP_EXP_REPORT_DISTS.SEGMENT5%TYPE;
1763: l_segment6 AP_EXP_REPORT_DISTS.SEGMENT6%TYPE;
1764: l_segment7 AP_EXP_REPORT_DISTS.SEGMENT7%TYPE;

Line 1761: l_segment4 AP_EXP_REPORT_DISTS.SEGMENT4%TYPE;

1757: l_created_by AP_EXP_REPORT_DISTS.CREATED_BY%TYPE;
1758: l_segment1 AP_EXP_REPORT_DISTS.SEGMENT1%TYPE;
1759: l_segment2 AP_EXP_REPORT_DISTS.SEGMENT2%TYPE;
1760: l_segment3 AP_EXP_REPORT_DISTS.SEGMENT3%TYPE;
1761: l_segment4 AP_EXP_REPORT_DISTS.SEGMENT4%TYPE;
1762: l_segment5 AP_EXP_REPORT_DISTS.SEGMENT5%TYPE;
1763: l_segment6 AP_EXP_REPORT_DISTS.SEGMENT6%TYPE;
1764: l_segment7 AP_EXP_REPORT_DISTS.SEGMENT7%TYPE;
1765: l_segment8 AP_EXP_REPORT_DISTS.SEGMENT8%TYPE;

Line 1762: l_segment5 AP_EXP_REPORT_DISTS.SEGMENT5%TYPE;

1758: l_segment1 AP_EXP_REPORT_DISTS.SEGMENT1%TYPE;
1759: l_segment2 AP_EXP_REPORT_DISTS.SEGMENT2%TYPE;
1760: l_segment3 AP_EXP_REPORT_DISTS.SEGMENT3%TYPE;
1761: l_segment4 AP_EXP_REPORT_DISTS.SEGMENT4%TYPE;
1762: l_segment5 AP_EXP_REPORT_DISTS.SEGMENT5%TYPE;
1763: l_segment6 AP_EXP_REPORT_DISTS.SEGMENT6%TYPE;
1764: l_segment7 AP_EXP_REPORT_DISTS.SEGMENT7%TYPE;
1765: l_segment8 AP_EXP_REPORT_DISTS.SEGMENT8%TYPE;
1766: l_segment9 AP_EXP_REPORT_DISTS.SEGMENT9%TYPE;

Line 1763: l_segment6 AP_EXP_REPORT_DISTS.SEGMENT6%TYPE;

1759: l_segment2 AP_EXP_REPORT_DISTS.SEGMENT2%TYPE;
1760: l_segment3 AP_EXP_REPORT_DISTS.SEGMENT3%TYPE;
1761: l_segment4 AP_EXP_REPORT_DISTS.SEGMENT4%TYPE;
1762: l_segment5 AP_EXP_REPORT_DISTS.SEGMENT5%TYPE;
1763: l_segment6 AP_EXP_REPORT_DISTS.SEGMENT6%TYPE;
1764: l_segment7 AP_EXP_REPORT_DISTS.SEGMENT7%TYPE;
1765: l_segment8 AP_EXP_REPORT_DISTS.SEGMENT8%TYPE;
1766: l_segment9 AP_EXP_REPORT_DISTS.SEGMENT9%TYPE;
1767: l_segment10 AP_EXP_REPORT_DISTS.SEGMENT10%TYPE;

Line 1764: l_segment7 AP_EXP_REPORT_DISTS.SEGMENT7%TYPE;

1760: l_segment3 AP_EXP_REPORT_DISTS.SEGMENT3%TYPE;
1761: l_segment4 AP_EXP_REPORT_DISTS.SEGMENT4%TYPE;
1762: l_segment5 AP_EXP_REPORT_DISTS.SEGMENT5%TYPE;
1763: l_segment6 AP_EXP_REPORT_DISTS.SEGMENT6%TYPE;
1764: l_segment7 AP_EXP_REPORT_DISTS.SEGMENT7%TYPE;
1765: l_segment8 AP_EXP_REPORT_DISTS.SEGMENT8%TYPE;
1766: l_segment9 AP_EXP_REPORT_DISTS.SEGMENT9%TYPE;
1767: l_segment10 AP_EXP_REPORT_DISTS.SEGMENT10%TYPE;
1768: l_segment11 AP_EXP_REPORT_DISTS.SEGMENT11%TYPE;

Line 1765: l_segment8 AP_EXP_REPORT_DISTS.SEGMENT8%TYPE;

1761: l_segment4 AP_EXP_REPORT_DISTS.SEGMENT4%TYPE;
1762: l_segment5 AP_EXP_REPORT_DISTS.SEGMENT5%TYPE;
1763: l_segment6 AP_EXP_REPORT_DISTS.SEGMENT6%TYPE;
1764: l_segment7 AP_EXP_REPORT_DISTS.SEGMENT7%TYPE;
1765: l_segment8 AP_EXP_REPORT_DISTS.SEGMENT8%TYPE;
1766: l_segment9 AP_EXP_REPORT_DISTS.SEGMENT9%TYPE;
1767: l_segment10 AP_EXP_REPORT_DISTS.SEGMENT10%TYPE;
1768: l_segment11 AP_EXP_REPORT_DISTS.SEGMENT11%TYPE;
1769: l_segment12 AP_EXP_REPORT_DISTS.SEGMENT12%TYPE;

Line 1766: l_segment9 AP_EXP_REPORT_DISTS.SEGMENT9%TYPE;

1762: l_segment5 AP_EXP_REPORT_DISTS.SEGMENT5%TYPE;
1763: l_segment6 AP_EXP_REPORT_DISTS.SEGMENT6%TYPE;
1764: l_segment7 AP_EXP_REPORT_DISTS.SEGMENT7%TYPE;
1765: l_segment8 AP_EXP_REPORT_DISTS.SEGMENT8%TYPE;
1766: l_segment9 AP_EXP_REPORT_DISTS.SEGMENT9%TYPE;
1767: l_segment10 AP_EXP_REPORT_DISTS.SEGMENT10%TYPE;
1768: l_segment11 AP_EXP_REPORT_DISTS.SEGMENT11%TYPE;
1769: l_segment12 AP_EXP_REPORT_DISTS.SEGMENT12%TYPE;
1770: l_segment13 AP_EXP_REPORT_DISTS.SEGMENT13%TYPE;

Line 1767: l_segment10 AP_EXP_REPORT_DISTS.SEGMENT10%TYPE;

1763: l_segment6 AP_EXP_REPORT_DISTS.SEGMENT6%TYPE;
1764: l_segment7 AP_EXP_REPORT_DISTS.SEGMENT7%TYPE;
1765: l_segment8 AP_EXP_REPORT_DISTS.SEGMENT8%TYPE;
1766: l_segment9 AP_EXP_REPORT_DISTS.SEGMENT9%TYPE;
1767: l_segment10 AP_EXP_REPORT_DISTS.SEGMENT10%TYPE;
1768: l_segment11 AP_EXP_REPORT_DISTS.SEGMENT11%TYPE;
1769: l_segment12 AP_EXP_REPORT_DISTS.SEGMENT12%TYPE;
1770: l_segment13 AP_EXP_REPORT_DISTS.SEGMENT13%TYPE;
1771: l_segment14 AP_EXP_REPORT_DISTS.SEGMENT14%TYPE;

Line 1768: l_segment11 AP_EXP_REPORT_DISTS.SEGMENT11%TYPE;

1764: l_segment7 AP_EXP_REPORT_DISTS.SEGMENT7%TYPE;
1765: l_segment8 AP_EXP_REPORT_DISTS.SEGMENT8%TYPE;
1766: l_segment9 AP_EXP_REPORT_DISTS.SEGMENT9%TYPE;
1767: l_segment10 AP_EXP_REPORT_DISTS.SEGMENT10%TYPE;
1768: l_segment11 AP_EXP_REPORT_DISTS.SEGMENT11%TYPE;
1769: l_segment12 AP_EXP_REPORT_DISTS.SEGMENT12%TYPE;
1770: l_segment13 AP_EXP_REPORT_DISTS.SEGMENT13%TYPE;
1771: l_segment14 AP_EXP_REPORT_DISTS.SEGMENT14%TYPE;
1772: l_segment15 AP_EXP_REPORT_DISTS.SEGMENT15%TYPE;

Line 1769: l_segment12 AP_EXP_REPORT_DISTS.SEGMENT12%TYPE;

1765: l_segment8 AP_EXP_REPORT_DISTS.SEGMENT8%TYPE;
1766: l_segment9 AP_EXP_REPORT_DISTS.SEGMENT9%TYPE;
1767: l_segment10 AP_EXP_REPORT_DISTS.SEGMENT10%TYPE;
1768: l_segment11 AP_EXP_REPORT_DISTS.SEGMENT11%TYPE;
1769: l_segment12 AP_EXP_REPORT_DISTS.SEGMENT12%TYPE;
1770: l_segment13 AP_EXP_REPORT_DISTS.SEGMENT13%TYPE;
1771: l_segment14 AP_EXP_REPORT_DISTS.SEGMENT14%TYPE;
1772: l_segment15 AP_EXP_REPORT_DISTS.SEGMENT15%TYPE;
1773: l_segment16 AP_EXP_REPORT_DISTS.SEGMENT16%TYPE;

Line 1770: l_segment13 AP_EXP_REPORT_DISTS.SEGMENT13%TYPE;

1766: l_segment9 AP_EXP_REPORT_DISTS.SEGMENT9%TYPE;
1767: l_segment10 AP_EXP_REPORT_DISTS.SEGMENT10%TYPE;
1768: l_segment11 AP_EXP_REPORT_DISTS.SEGMENT11%TYPE;
1769: l_segment12 AP_EXP_REPORT_DISTS.SEGMENT12%TYPE;
1770: l_segment13 AP_EXP_REPORT_DISTS.SEGMENT13%TYPE;
1771: l_segment14 AP_EXP_REPORT_DISTS.SEGMENT14%TYPE;
1772: l_segment15 AP_EXP_REPORT_DISTS.SEGMENT15%TYPE;
1773: l_segment16 AP_EXP_REPORT_DISTS.SEGMENT16%TYPE;
1774: l_segment17 AP_EXP_REPORT_DISTS.SEGMENT17%TYPE;

Line 1771: l_segment14 AP_EXP_REPORT_DISTS.SEGMENT14%TYPE;

1767: l_segment10 AP_EXP_REPORT_DISTS.SEGMENT10%TYPE;
1768: l_segment11 AP_EXP_REPORT_DISTS.SEGMENT11%TYPE;
1769: l_segment12 AP_EXP_REPORT_DISTS.SEGMENT12%TYPE;
1770: l_segment13 AP_EXP_REPORT_DISTS.SEGMENT13%TYPE;
1771: l_segment14 AP_EXP_REPORT_DISTS.SEGMENT14%TYPE;
1772: l_segment15 AP_EXP_REPORT_DISTS.SEGMENT15%TYPE;
1773: l_segment16 AP_EXP_REPORT_DISTS.SEGMENT16%TYPE;
1774: l_segment17 AP_EXP_REPORT_DISTS.SEGMENT17%TYPE;
1775: l_segment18 AP_EXP_REPORT_DISTS.SEGMENT18%TYPE;

Line 1772: l_segment15 AP_EXP_REPORT_DISTS.SEGMENT15%TYPE;

1768: l_segment11 AP_EXP_REPORT_DISTS.SEGMENT11%TYPE;
1769: l_segment12 AP_EXP_REPORT_DISTS.SEGMENT12%TYPE;
1770: l_segment13 AP_EXP_REPORT_DISTS.SEGMENT13%TYPE;
1771: l_segment14 AP_EXP_REPORT_DISTS.SEGMENT14%TYPE;
1772: l_segment15 AP_EXP_REPORT_DISTS.SEGMENT15%TYPE;
1773: l_segment16 AP_EXP_REPORT_DISTS.SEGMENT16%TYPE;
1774: l_segment17 AP_EXP_REPORT_DISTS.SEGMENT17%TYPE;
1775: l_segment18 AP_EXP_REPORT_DISTS.SEGMENT18%TYPE;
1776: l_segment19 AP_EXP_REPORT_DISTS.SEGMENT19%TYPE;

Line 1773: l_segment16 AP_EXP_REPORT_DISTS.SEGMENT16%TYPE;

1769: l_segment12 AP_EXP_REPORT_DISTS.SEGMENT12%TYPE;
1770: l_segment13 AP_EXP_REPORT_DISTS.SEGMENT13%TYPE;
1771: l_segment14 AP_EXP_REPORT_DISTS.SEGMENT14%TYPE;
1772: l_segment15 AP_EXP_REPORT_DISTS.SEGMENT15%TYPE;
1773: l_segment16 AP_EXP_REPORT_DISTS.SEGMENT16%TYPE;
1774: l_segment17 AP_EXP_REPORT_DISTS.SEGMENT17%TYPE;
1775: l_segment18 AP_EXP_REPORT_DISTS.SEGMENT18%TYPE;
1776: l_segment19 AP_EXP_REPORT_DISTS.SEGMENT19%TYPE;
1777: l_segment20 AP_EXP_REPORT_DISTS.SEGMENT20%TYPE;

Line 1774: l_segment17 AP_EXP_REPORT_DISTS.SEGMENT17%TYPE;

1770: l_segment13 AP_EXP_REPORT_DISTS.SEGMENT13%TYPE;
1771: l_segment14 AP_EXP_REPORT_DISTS.SEGMENT14%TYPE;
1772: l_segment15 AP_EXP_REPORT_DISTS.SEGMENT15%TYPE;
1773: l_segment16 AP_EXP_REPORT_DISTS.SEGMENT16%TYPE;
1774: l_segment17 AP_EXP_REPORT_DISTS.SEGMENT17%TYPE;
1775: l_segment18 AP_EXP_REPORT_DISTS.SEGMENT18%TYPE;
1776: l_segment19 AP_EXP_REPORT_DISTS.SEGMENT19%TYPE;
1777: l_segment20 AP_EXP_REPORT_DISTS.SEGMENT20%TYPE;
1778: l_segment21 AP_EXP_REPORT_DISTS.SEGMENT21%TYPE;

Line 1775: l_segment18 AP_EXP_REPORT_DISTS.SEGMENT18%TYPE;

1771: l_segment14 AP_EXP_REPORT_DISTS.SEGMENT14%TYPE;
1772: l_segment15 AP_EXP_REPORT_DISTS.SEGMENT15%TYPE;
1773: l_segment16 AP_EXP_REPORT_DISTS.SEGMENT16%TYPE;
1774: l_segment17 AP_EXP_REPORT_DISTS.SEGMENT17%TYPE;
1775: l_segment18 AP_EXP_REPORT_DISTS.SEGMENT18%TYPE;
1776: l_segment19 AP_EXP_REPORT_DISTS.SEGMENT19%TYPE;
1777: l_segment20 AP_EXP_REPORT_DISTS.SEGMENT20%TYPE;
1778: l_segment21 AP_EXP_REPORT_DISTS.SEGMENT21%TYPE;
1779: l_segment22 AP_EXP_REPORT_DISTS.SEGMENT22%TYPE;

Line 1776: l_segment19 AP_EXP_REPORT_DISTS.SEGMENT19%TYPE;

1772: l_segment15 AP_EXP_REPORT_DISTS.SEGMENT15%TYPE;
1773: l_segment16 AP_EXP_REPORT_DISTS.SEGMENT16%TYPE;
1774: l_segment17 AP_EXP_REPORT_DISTS.SEGMENT17%TYPE;
1775: l_segment18 AP_EXP_REPORT_DISTS.SEGMENT18%TYPE;
1776: l_segment19 AP_EXP_REPORT_DISTS.SEGMENT19%TYPE;
1777: l_segment20 AP_EXP_REPORT_DISTS.SEGMENT20%TYPE;
1778: l_segment21 AP_EXP_REPORT_DISTS.SEGMENT21%TYPE;
1779: l_segment22 AP_EXP_REPORT_DISTS.SEGMENT22%TYPE;
1780: l_segment23 AP_EXP_REPORT_DISTS.SEGMENT23%TYPE;

Line 1777: l_segment20 AP_EXP_REPORT_DISTS.SEGMENT20%TYPE;

1773: l_segment16 AP_EXP_REPORT_DISTS.SEGMENT16%TYPE;
1774: l_segment17 AP_EXP_REPORT_DISTS.SEGMENT17%TYPE;
1775: l_segment18 AP_EXP_REPORT_DISTS.SEGMENT18%TYPE;
1776: l_segment19 AP_EXP_REPORT_DISTS.SEGMENT19%TYPE;
1777: l_segment20 AP_EXP_REPORT_DISTS.SEGMENT20%TYPE;
1778: l_segment21 AP_EXP_REPORT_DISTS.SEGMENT21%TYPE;
1779: l_segment22 AP_EXP_REPORT_DISTS.SEGMENT22%TYPE;
1780: l_segment23 AP_EXP_REPORT_DISTS.SEGMENT23%TYPE;
1781: l_segment24 AP_EXP_REPORT_DISTS.SEGMENT24%TYPE;

Line 1778: l_segment21 AP_EXP_REPORT_DISTS.SEGMENT21%TYPE;

1774: l_segment17 AP_EXP_REPORT_DISTS.SEGMENT17%TYPE;
1775: l_segment18 AP_EXP_REPORT_DISTS.SEGMENT18%TYPE;
1776: l_segment19 AP_EXP_REPORT_DISTS.SEGMENT19%TYPE;
1777: l_segment20 AP_EXP_REPORT_DISTS.SEGMENT20%TYPE;
1778: l_segment21 AP_EXP_REPORT_DISTS.SEGMENT21%TYPE;
1779: l_segment22 AP_EXP_REPORT_DISTS.SEGMENT22%TYPE;
1780: l_segment23 AP_EXP_REPORT_DISTS.SEGMENT23%TYPE;
1781: l_segment24 AP_EXP_REPORT_DISTS.SEGMENT24%TYPE;
1782: l_segment25 AP_EXP_REPORT_DISTS.SEGMENT25%TYPE;

Line 1779: l_segment22 AP_EXP_REPORT_DISTS.SEGMENT22%TYPE;

1775: l_segment18 AP_EXP_REPORT_DISTS.SEGMENT18%TYPE;
1776: l_segment19 AP_EXP_REPORT_DISTS.SEGMENT19%TYPE;
1777: l_segment20 AP_EXP_REPORT_DISTS.SEGMENT20%TYPE;
1778: l_segment21 AP_EXP_REPORT_DISTS.SEGMENT21%TYPE;
1779: l_segment22 AP_EXP_REPORT_DISTS.SEGMENT22%TYPE;
1780: l_segment23 AP_EXP_REPORT_DISTS.SEGMENT23%TYPE;
1781: l_segment24 AP_EXP_REPORT_DISTS.SEGMENT24%TYPE;
1782: l_segment25 AP_EXP_REPORT_DISTS.SEGMENT25%TYPE;
1783: l_segment26 AP_EXP_REPORT_DISTS.SEGMENT26%TYPE;

Line 1780: l_segment23 AP_EXP_REPORT_DISTS.SEGMENT23%TYPE;

1776: l_segment19 AP_EXP_REPORT_DISTS.SEGMENT19%TYPE;
1777: l_segment20 AP_EXP_REPORT_DISTS.SEGMENT20%TYPE;
1778: l_segment21 AP_EXP_REPORT_DISTS.SEGMENT21%TYPE;
1779: l_segment22 AP_EXP_REPORT_DISTS.SEGMENT22%TYPE;
1780: l_segment23 AP_EXP_REPORT_DISTS.SEGMENT23%TYPE;
1781: l_segment24 AP_EXP_REPORT_DISTS.SEGMENT24%TYPE;
1782: l_segment25 AP_EXP_REPORT_DISTS.SEGMENT25%TYPE;
1783: l_segment26 AP_EXP_REPORT_DISTS.SEGMENT26%TYPE;
1784: l_segment27 AP_EXP_REPORT_DISTS.SEGMENT27%TYPE;

Line 1781: l_segment24 AP_EXP_REPORT_DISTS.SEGMENT24%TYPE;

1777: l_segment20 AP_EXP_REPORT_DISTS.SEGMENT20%TYPE;
1778: l_segment21 AP_EXP_REPORT_DISTS.SEGMENT21%TYPE;
1779: l_segment22 AP_EXP_REPORT_DISTS.SEGMENT22%TYPE;
1780: l_segment23 AP_EXP_REPORT_DISTS.SEGMENT23%TYPE;
1781: l_segment24 AP_EXP_REPORT_DISTS.SEGMENT24%TYPE;
1782: l_segment25 AP_EXP_REPORT_DISTS.SEGMENT25%TYPE;
1783: l_segment26 AP_EXP_REPORT_DISTS.SEGMENT26%TYPE;
1784: l_segment27 AP_EXP_REPORT_DISTS.SEGMENT27%TYPE;
1785: l_segment28 AP_EXP_REPORT_DISTS.SEGMENT28%TYPE;

Line 1782: l_segment25 AP_EXP_REPORT_DISTS.SEGMENT25%TYPE;

1778: l_segment21 AP_EXP_REPORT_DISTS.SEGMENT21%TYPE;
1779: l_segment22 AP_EXP_REPORT_DISTS.SEGMENT22%TYPE;
1780: l_segment23 AP_EXP_REPORT_DISTS.SEGMENT23%TYPE;
1781: l_segment24 AP_EXP_REPORT_DISTS.SEGMENT24%TYPE;
1782: l_segment25 AP_EXP_REPORT_DISTS.SEGMENT25%TYPE;
1783: l_segment26 AP_EXP_REPORT_DISTS.SEGMENT26%TYPE;
1784: l_segment27 AP_EXP_REPORT_DISTS.SEGMENT27%TYPE;
1785: l_segment28 AP_EXP_REPORT_DISTS.SEGMENT28%TYPE;
1786: l_segment29 AP_EXP_REPORT_DISTS.SEGMENT29%TYPE;

Line 1783: l_segment26 AP_EXP_REPORT_DISTS.SEGMENT26%TYPE;

1779: l_segment22 AP_EXP_REPORT_DISTS.SEGMENT22%TYPE;
1780: l_segment23 AP_EXP_REPORT_DISTS.SEGMENT23%TYPE;
1781: l_segment24 AP_EXP_REPORT_DISTS.SEGMENT24%TYPE;
1782: l_segment25 AP_EXP_REPORT_DISTS.SEGMENT25%TYPE;
1783: l_segment26 AP_EXP_REPORT_DISTS.SEGMENT26%TYPE;
1784: l_segment27 AP_EXP_REPORT_DISTS.SEGMENT27%TYPE;
1785: l_segment28 AP_EXP_REPORT_DISTS.SEGMENT28%TYPE;
1786: l_segment29 AP_EXP_REPORT_DISTS.SEGMENT29%TYPE;
1787: l_segment30 AP_EXP_REPORT_DISTS.SEGMENT30%TYPE;

Line 1784: l_segment27 AP_EXP_REPORT_DISTS.SEGMENT27%TYPE;

1780: l_segment23 AP_EXP_REPORT_DISTS.SEGMENT23%TYPE;
1781: l_segment24 AP_EXP_REPORT_DISTS.SEGMENT24%TYPE;
1782: l_segment25 AP_EXP_REPORT_DISTS.SEGMENT25%TYPE;
1783: l_segment26 AP_EXP_REPORT_DISTS.SEGMENT26%TYPE;
1784: l_segment27 AP_EXP_REPORT_DISTS.SEGMENT27%TYPE;
1785: l_segment28 AP_EXP_REPORT_DISTS.SEGMENT28%TYPE;
1786: l_segment29 AP_EXP_REPORT_DISTS.SEGMENT29%TYPE;
1787: l_segment30 AP_EXP_REPORT_DISTS.SEGMENT30%TYPE;
1788: l_preparer_modified_flag AP_EXP_REPORT_DISTS.PREPARER_MODIFIED_FLAG%TYPE;

Line 1785: l_segment28 AP_EXP_REPORT_DISTS.SEGMENT28%TYPE;

1781: l_segment24 AP_EXP_REPORT_DISTS.SEGMENT24%TYPE;
1782: l_segment25 AP_EXP_REPORT_DISTS.SEGMENT25%TYPE;
1783: l_segment26 AP_EXP_REPORT_DISTS.SEGMENT26%TYPE;
1784: l_segment27 AP_EXP_REPORT_DISTS.SEGMENT27%TYPE;
1785: l_segment28 AP_EXP_REPORT_DISTS.SEGMENT28%TYPE;
1786: l_segment29 AP_EXP_REPORT_DISTS.SEGMENT29%TYPE;
1787: l_segment30 AP_EXP_REPORT_DISTS.SEGMENT30%TYPE;
1788: l_preparer_modified_flag AP_EXP_REPORT_DISTS.PREPARER_MODIFIED_FLAG%TYPE;
1789: l_amount AP_EXP_REPORT_DISTS.AMOUNT%TYPE;

Line 1786: l_segment29 AP_EXP_REPORT_DISTS.SEGMENT29%TYPE;

1782: l_segment25 AP_EXP_REPORT_DISTS.SEGMENT25%TYPE;
1783: l_segment26 AP_EXP_REPORT_DISTS.SEGMENT26%TYPE;
1784: l_segment27 AP_EXP_REPORT_DISTS.SEGMENT27%TYPE;
1785: l_segment28 AP_EXP_REPORT_DISTS.SEGMENT28%TYPE;
1786: l_segment29 AP_EXP_REPORT_DISTS.SEGMENT29%TYPE;
1787: l_segment30 AP_EXP_REPORT_DISTS.SEGMENT30%TYPE;
1788: l_preparer_modified_flag AP_EXP_REPORT_DISTS.PREPARER_MODIFIED_FLAG%TYPE;
1789: l_amount AP_EXP_REPORT_DISTS.AMOUNT%TYPE;
1790: l_cost_center AP_EXP_REPORT_DISTS.COST_CENTER%TYPE;

Line 1787: l_segment30 AP_EXP_REPORT_DISTS.SEGMENT30%TYPE;

1783: l_segment26 AP_EXP_REPORT_DISTS.SEGMENT26%TYPE;
1784: l_segment27 AP_EXP_REPORT_DISTS.SEGMENT27%TYPE;
1785: l_segment28 AP_EXP_REPORT_DISTS.SEGMENT28%TYPE;
1786: l_segment29 AP_EXP_REPORT_DISTS.SEGMENT29%TYPE;
1787: l_segment30 AP_EXP_REPORT_DISTS.SEGMENT30%TYPE;
1788: l_preparer_modified_flag AP_EXP_REPORT_DISTS.PREPARER_MODIFIED_FLAG%TYPE;
1789: l_amount AP_EXP_REPORT_DISTS.AMOUNT%TYPE;
1790: l_cost_center AP_EXP_REPORT_DISTS.COST_CENTER%TYPE;
1791:

Line 1788: l_preparer_modified_flag AP_EXP_REPORT_DISTS.PREPARER_MODIFIED_FLAG%TYPE;

1784: l_segment27 AP_EXP_REPORT_DISTS.SEGMENT27%TYPE;
1785: l_segment28 AP_EXP_REPORT_DISTS.SEGMENT28%TYPE;
1786: l_segment29 AP_EXP_REPORT_DISTS.SEGMENT29%TYPE;
1787: l_segment30 AP_EXP_REPORT_DISTS.SEGMENT30%TYPE;
1788: l_preparer_modified_flag AP_EXP_REPORT_DISTS.PREPARER_MODIFIED_FLAG%TYPE;
1789: l_amount AP_EXP_REPORT_DISTS.AMOUNT%TYPE;
1790: l_cost_center AP_EXP_REPORT_DISTS.COST_CENTER%TYPE;
1791:
1792: -- Bug: 6611357, Removed References to Project Information and updated dists

Line 1789: l_amount AP_EXP_REPORT_DISTS.AMOUNT%TYPE;

1785: l_segment28 AP_EXP_REPORT_DISTS.SEGMENT28%TYPE;
1786: l_segment29 AP_EXP_REPORT_DISTS.SEGMENT29%TYPE;
1787: l_segment30 AP_EXP_REPORT_DISTS.SEGMENT30%TYPE;
1788: l_preparer_modified_flag AP_EXP_REPORT_DISTS.PREPARER_MODIFIED_FLAG%TYPE;
1789: l_amount AP_EXP_REPORT_DISTS.AMOUNT%TYPE;
1790: l_cost_center AP_EXP_REPORT_DISTS.COST_CENTER%TYPE;
1791:
1792: -- Bug: 6611357, Removed References to Project Information and updated dists
1793: -- table with nulls when creating a .1 report with BothPay

Line 1790: l_cost_center AP_EXP_REPORT_DISTS.COST_CENTER%TYPE;

1786: l_segment29 AP_EXP_REPORT_DISTS.SEGMENT29%TYPE;
1787: l_segment30 AP_EXP_REPORT_DISTS.SEGMENT30%TYPE;
1788: l_preparer_modified_flag AP_EXP_REPORT_DISTS.PREPARER_MODIFIED_FLAG%TYPE;
1789: l_amount AP_EXP_REPORT_DISTS.AMOUNT%TYPE;
1790: l_cost_center AP_EXP_REPORT_DISTS.COST_CENTER%TYPE;
1791:
1792: -- Bug: 6611357, Removed References to Project Information and updated dists
1793: -- table with nulls when creating a .1 report with BothPay
1794:

Line 1804: FROM AP_EXP_REPORT_DISTS_ALL DT,

1800: DT.CREATED_BY,
1801: DT.PREPARER_MODIFIED_FLAG,
1802: DT.AMOUNT,
1803: DT.COST_CENTER
1804: FROM AP_EXP_REPORT_DISTS_ALL DT,
1805: AP_EXPENSE_REPORT_LINES_ALL DL
1806: WHERE DT.REPORT_LINE_ID = p_line_id
1807: AND DT.REPORT_LINE_ID = DL.REPORT_LINE_ID
1808: AND (DL.ITEMIZATION_PARENT_ID IS NULL

Line 1934: -- for bug 5288256: insert a new row in ap_exp_report_dists_all table

1930: allocation_split_code --Bug#6870253
1931: FROM ap_expense_report_lines erl
1932: WHERE report_line_id = p_report_line_id;
1933:
1934: -- for bug 5288256: insert a new row in ap_exp_report_dists_all table
1935: SELECT GL.SEGMENT1, GL.SEGMENT2,GL.SEGMENT3,GL.SEGMENT4, GL.SEGMENT5, GL.SEGMENT6,
1936: GL.SEGMENT7, GL.SEGMENT8,GL.SEGMENT9,GL.SEGMENT10,GL.SEGMENT11, GL.SEGMENT12,
1937: GL.SEGMENT13, GL.SEGMENT14, GL.SEGMENT15, GL.SEGMENT16, GL.SEGMENT17, GL.SEGMENT18,
1938: GL.SEGMENT19, GL.SEGMENT20, GL.SEGMENT21, GL.SEGMENT22, GL.SEGMENT23, GL.SEGMENT24,

Line 1955: INSERT INTO AP_EXP_REPORT_DISTS

1951: FETCH copy_dist into l_org_id, l_sequence_num, l_last_updated_by, l_created_by,
1952: l_preparer_modified_flag, l_amount, l_cost_center;
1953: EXIT WHEN copy_dist%NOTFOUND;
1954:
1955: INSERT INTO AP_EXP_REPORT_DISTS
1956: (
1957: report_header_id,
1958: report_line_id,
1959: report_distribution_id,

Line 2008: AP_EXP_REPORT_DISTS_S.NEXTVAL,

2004: )
2005: VALUES (
2006: p_new_report_header_id,
2007: p_new_report_line_id,
2008: AP_EXP_REPORT_DISTS_S.NEXTVAL,
2009: l_org_id,
2010: l_sequence_num,
2011: SYSDATE,
2012: l_last_updated_by,