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 767: ap_exp_report_dists XD

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

Line 1998: l_org_id AP_EXP_REPORT_DISTS.ORG_ID%TYPE;

1994: p_new_report_line_id IN NUMBER,
1995: p_distribution_line_number IN NUMBER) IS
1996:
1997: l_clearning_ccid NUMBER;
1998: l_org_id AP_EXP_REPORT_DISTS.ORG_ID%TYPE;
1999: l_sequence_num AP_EXP_REPORT_DISTS.SEQUENCE_NUM%TYPE;
2000: l_last_updated_by AP_EXP_REPORT_DISTS.LAST_UPDATED_BY%TYPE;
2001: l_created_by AP_EXP_REPORT_DISTS.CREATED_BY%TYPE;
2002: l_segment1 AP_EXP_REPORT_DISTS.SEGMENT1%TYPE;

Line 1999: l_sequence_num AP_EXP_REPORT_DISTS.SEQUENCE_NUM%TYPE;

1995: p_distribution_line_number IN NUMBER) IS
1996:
1997: l_clearning_ccid NUMBER;
1998: l_org_id AP_EXP_REPORT_DISTS.ORG_ID%TYPE;
1999: l_sequence_num AP_EXP_REPORT_DISTS.SEQUENCE_NUM%TYPE;
2000: l_last_updated_by AP_EXP_REPORT_DISTS.LAST_UPDATED_BY%TYPE;
2001: l_created_by AP_EXP_REPORT_DISTS.CREATED_BY%TYPE;
2002: l_segment1 AP_EXP_REPORT_DISTS.SEGMENT1%TYPE;
2003: l_segment2 AP_EXP_REPORT_DISTS.SEGMENT2%TYPE;

Line 2000: l_last_updated_by AP_EXP_REPORT_DISTS.LAST_UPDATED_BY%TYPE;

1996:
1997: l_clearning_ccid NUMBER;
1998: l_org_id AP_EXP_REPORT_DISTS.ORG_ID%TYPE;
1999: l_sequence_num AP_EXP_REPORT_DISTS.SEQUENCE_NUM%TYPE;
2000: l_last_updated_by AP_EXP_REPORT_DISTS.LAST_UPDATED_BY%TYPE;
2001: l_created_by AP_EXP_REPORT_DISTS.CREATED_BY%TYPE;
2002: l_segment1 AP_EXP_REPORT_DISTS.SEGMENT1%TYPE;
2003: l_segment2 AP_EXP_REPORT_DISTS.SEGMENT2%TYPE;
2004: l_segment3 AP_EXP_REPORT_DISTS.SEGMENT3%TYPE;

Line 2001: l_created_by AP_EXP_REPORT_DISTS.CREATED_BY%TYPE;

1997: l_clearning_ccid NUMBER;
1998: l_org_id AP_EXP_REPORT_DISTS.ORG_ID%TYPE;
1999: l_sequence_num AP_EXP_REPORT_DISTS.SEQUENCE_NUM%TYPE;
2000: l_last_updated_by AP_EXP_REPORT_DISTS.LAST_UPDATED_BY%TYPE;
2001: l_created_by AP_EXP_REPORT_DISTS.CREATED_BY%TYPE;
2002: l_segment1 AP_EXP_REPORT_DISTS.SEGMENT1%TYPE;
2003: l_segment2 AP_EXP_REPORT_DISTS.SEGMENT2%TYPE;
2004: l_segment3 AP_EXP_REPORT_DISTS.SEGMENT3%TYPE;
2005: l_segment4 AP_EXP_REPORT_DISTS.SEGMENT4%TYPE;

Line 2002: l_segment1 AP_EXP_REPORT_DISTS.SEGMENT1%TYPE;

1998: l_org_id AP_EXP_REPORT_DISTS.ORG_ID%TYPE;
1999: l_sequence_num AP_EXP_REPORT_DISTS.SEQUENCE_NUM%TYPE;
2000: l_last_updated_by AP_EXP_REPORT_DISTS.LAST_UPDATED_BY%TYPE;
2001: l_created_by AP_EXP_REPORT_DISTS.CREATED_BY%TYPE;
2002: l_segment1 AP_EXP_REPORT_DISTS.SEGMENT1%TYPE;
2003: l_segment2 AP_EXP_REPORT_DISTS.SEGMENT2%TYPE;
2004: l_segment3 AP_EXP_REPORT_DISTS.SEGMENT3%TYPE;
2005: l_segment4 AP_EXP_REPORT_DISTS.SEGMENT4%TYPE;
2006: l_segment5 AP_EXP_REPORT_DISTS.SEGMENT5%TYPE;

Line 2003: l_segment2 AP_EXP_REPORT_DISTS.SEGMENT2%TYPE;

1999: l_sequence_num AP_EXP_REPORT_DISTS.SEQUENCE_NUM%TYPE;
2000: l_last_updated_by AP_EXP_REPORT_DISTS.LAST_UPDATED_BY%TYPE;
2001: l_created_by AP_EXP_REPORT_DISTS.CREATED_BY%TYPE;
2002: l_segment1 AP_EXP_REPORT_DISTS.SEGMENT1%TYPE;
2003: l_segment2 AP_EXP_REPORT_DISTS.SEGMENT2%TYPE;
2004: l_segment3 AP_EXP_REPORT_DISTS.SEGMENT3%TYPE;
2005: l_segment4 AP_EXP_REPORT_DISTS.SEGMENT4%TYPE;
2006: l_segment5 AP_EXP_REPORT_DISTS.SEGMENT5%TYPE;
2007: l_segment6 AP_EXP_REPORT_DISTS.SEGMENT6%TYPE;

Line 2004: l_segment3 AP_EXP_REPORT_DISTS.SEGMENT3%TYPE;

2000: l_last_updated_by AP_EXP_REPORT_DISTS.LAST_UPDATED_BY%TYPE;
2001: l_created_by AP_EXP_REPORT_DISTS.CREATED_BY%TYPE;
2002: l_segment1 AP_EXP_REPORT_DISTS.SEGMENT1%TYPE;
2003: l_segment2 AP_EXP_REPORT_DISTS.SEGMENT2%TYPE;
2004: l_segment3 AP_EXP_REPORT_DISTS.SEGMENT3%TYPE;
2005: l_segment4 AP_EXP_REPORT_DISTS.SEGMENT4%TYPE;
2006: l_segment5 AP_EXP_REPORT_DISTS.SEGMENT5%TYPE;
2007: l_segment6 AP_EXP_REPORT_DISTS.SEGMENT6%TYPE;
2008: l_segment7 AP_EXP_REPORT_DISTS.SEGMENT7%TYPE;

Line 2005: l_segment4 AP_EXP_REPORT_DISTS.SEGMENT4%TYPE;

2001: l_created_by AP_EXP_REPORT_DISTS.CREATED_BY%TYPE;
2002: l_segment1 AP_EXP_REPORT_DISTS.SEGMENT1%TYPE;
2003: l_segment2 AP_EXP_REPORT_DISTS.SEGMENT2%TYPE;
2004: l_segment3 AP_EXP_REPORT_DISTS.SEGMENT3%TYPE;
2005: l_segment4 AP_EXP_REPORT_DISTS.SEGMENT4%TYPE;
2006: l_segment5 AP_EXP_REPORT_DISTS.SEGMENT5%TYPE;
2007: l_segment6 AP_EXP_REPORT_DISTS.SEGMENT6%TYPE;
2008: l_segment7 AP_EXP_REPORT_DISTS.SEGMENT7%TYPE;
2009: l_segment8 AP_EXP_REPORT_DISTS.SEGMENT8%TYPE;

Line 2006: l_segment5 AP_EXP_REPORT_DISTS.SEGMENT5%TYPE;

2002: l_segment1 AP_EXP_REPORT_DISTS.SEGMENT1%TYPE;
2003: l_segment2 AP_EXP_REPORT_DISTS.SEGMENT2%TYPE;
2004: l_segment3 AP_EXP_REPORT_DISTS.SEGMENT3%TYPE;
2005: l_segment4 AP_EXP_REPORT_DISTS.SEGMENT4%TYPE;
2006: l_segment5 AP_EXP_REPORT_DISTS.SEGMENT5%TYPE;
2007: l_segment6 AP_EXP_REPORT_DISTS.SEGMENT6%TYPE;
2008: l_segment7 AP_EXP_REPORT_DISTS.SEGMENT7%TYPE;
2009: l_segment8 AP_EXP_REPORT_DISTS.SEGMENT8%TYPE;
2010: l_segment9 AP_EXP_REPORT_DISTS.SEGMENT9%TYPE;

Line 2007: l_segment6 AP_EXP_REPORT_DISTS.SEGMENT6%TYPE;

2003: l_segment2 AP_EXP_REPORT_DISTS.SEGMENT2%TYPE;
2004: l_segment3 AP_EXP_REPORT_DISTS.SEGMENT3%TYPE;
2005: l_segment4 AP_EXP_REPORT_DISTS.SEGMENT4%TYPE;
2006: l_segment5 AP_EXP_REPORT_DISTS.SEGMENT5%TYPE;
2007: l_segment6 AP_EXP_REPORT_DISTS.SEGMENT6%TYPE;
2008: l_segment7 AP_EXP_REPORT_DISTS.SEGMENT7%TYPE;
2009: l_segment8 AP_EXP_REPORT_DISTS.SEGMENT8%TYPE;
2010: l_segment9 AP_EXP_REPORT_DISTS.SEGMENT9%TYPE;
2011: l_segment10 AP_EXP_REPORT_DISTS.SEGMENT10%TYPE;

Line 2008: l_segment7 AP_EXP_REPORT_DISTS.SEGMENT7%TYPE;

2004: l_segment3 AP_EXP_REPORT_DISTS.SEGMENT3%TYPE;
2005: l_segment4 AP_EXP_REPORT_DISTS.SEGMENT4%TYPE;
2006: l_segment5 AP_EXP_REPORT_DISTS.SEGMENT5%TYPE;
2007: l_segment6 AP_EXP_REPORT_DISTS.SEGMENT6%TYPE;
2008: l_segment7 AP_EXP_REPORT_DISTS.SEGMENT7%TYPE;
2009: l_segment8 AP_EXP_REPORT_DISTS.SEGMENT8%TYPE;
2010: l_segment9 AP_EXP_REPORT_DISTS.SEGMENT9%TYPE;
2011: l_segment10 AP_EXP_REPORT_DISTS.SEGMENT10%TYPE;
2012: l_segment11 AP_EXP_REPORT_DISTS.SEGMENT11%TYPE;

Line 2009: l_segment8 AP_EXP_REPORT_DISTS.SEGMENT8%TYPE;

2005: l_segment4 AP_EXP_REPORT_DISTS.SEGMENT4%TYPE;
2006: l_segment5 AP_EXP_REPORT_DISTS.SEGMENT5%TYPE;
2007: l_segment6 AP_EXP_REPORT_DISTS.SEGMENT6%TYPE;
2008: l_segment7 AP_EXP_REPORT_DISTS.SEGMENT7%TYPE;
2009: l_segment8 AP_EXP_REPORT_DISTS.SEGMENT8%TYPE;
2010: l_segment9 AP_EXP_REPORT_DISTS.SEGMENT9%TYPE;
2011: l_segment10 AP_EXP_REPORT_DISTS.SEGMENT10%TYPE;
2012: l_segment11 AP_EXP_REPORT_DISTS.SEGMENT11%TYPE;
2013: l_segment12 AP_EXP_REPORT_DISTS.SEGMENT12%TYPE;

Line 2010: l_segment9 AP_EXP_REPORT_DISTS.SEGMENT9%TYPE;

2006: l_segment5 AP_EXP_REPORT_DISTS.SEGMENT5%TYPE;
2007: l_segment6 AP_EXP_REPORT_DISTS.SEGMENT6%TYPE;
2008: l_segment7 AP_EXP_REPORT_DISTS.SEGMENT7%TYPE;
2009: l_segment8 AP_EXP_REPORT_DISTS.SEGMENT8%TYPE;
2010: l_segment9 AP_EXP_REPORT_DISTS.SEGMENT9%TYPE;
2011: l_segment10 AP_EXP_REPORT_DISTS.SEGMENT10%TYPE;
2012: l_segment11 AP_EXP_REPORT_DISTS.SEGMENT11%TYPE;
2013: l_segment12 AP_EXP_REPORT_DISTS.SEGMENT12%TYPE;
2014: l_segment13 AP_EXP_REPORT_DISTS.SEGMENT13%TYPE;

Line 2011: l_segment10 AP_EXP_REPORT_DISTS.SEGMENT10%TYPE;

2007: l_segment6 AP_EXP_REPORT_DISTS.SEGMENT6%TYPE;
2008: l_segment7 AP_EXP_REPORT_DISTS.SEGMENT7%TYPE;
2009: l_segment8 AP_EXP_REPORT_DISTS.SEGMENT8%TYPE;
2010: l_segment9 AP_EXP_REPORT_DISTS.SEGMENT9%TYPE;
2011: l_segment10 AP_EXP_REPORT_DISTS.SEGMENT10%TYPE;
2012: l_segment11 AP_EXP_REPORT_DISTS.SEGMENT11%TYPE;
2013: l_segment12 AP_EXP_REPORT_DISTS.SEGMENT12%TYPE;
2014: l_segment13 AP_EXP_REPORT_DISTS.SEGMENT13%TYPE;
2015: l_segment14 AP_EXP_REPORT_DISTS.SEGMENT14%TYPE;

Line 2012: l_segment11 AP_EXP_REPORT_DISTS.SEGMENT11%TYPE;

2008: l_segment7 AP_EXP_REPORT_DISTS.SEGMENT7%TYPE;
2009: l_segment8 AP_EXP_REPORT_DISTS.SEGMENT8%TYPE;
2010: l_segment9 AP_EXP_REPORT_DISTS.SEGMENT9%TYPE;
2011: l_segment10 AP_EXP_REPORT_DISTS.SEGMENT10%TYPE;
2012: l_segment11 AP_EXP_REPORT_DISTS.SEGMENT11%TYPE;
2013: l_segment12 AP_EXP_REPORT_DISTS.SEGMENT12%TYPE;
2014: l_segment13 AP_EXP_REPORT_DISTS.SEGMENT13%TYPE;
2015: l_segment14 AP_EXP_REPORT_DISTS.SEGMENT14%TYPE;
2016: l_segment15 AP_EXP_REPORT_DISTS.SEGMENT15%TYPE;

Line 2013: l_segment12 AP_EXP_REPORT_DISTS.SEGMENT12%TYPE;

2009: l_segment8 AP_EXP_REPORT_DISTS.SEGMENT8%TYPE;
2010: l_segment9 AP_EXP_REPORT_DISTS.SEGMENT9%TYPE;
2011: l_segment10 AP_EXP_REPORT_DISTS.SEGMENT10%TYPE;
2012: l_segment11 AP_EXP_REPORT_DISTS.SEGMENT11%TYPE;
2013: l_segment12 AP_EXP_REPORT_DISTS.SEGMENT12%TYPE;
2014: l_segment13 AP_EXP_REPORT_DISTS.SEGMENT13%TYPE;
2015: l_segment14 AP_EXP_REPORT_DISTS.SEGMENT14%TYPE;
2016: l_segment15 AP_EXP_REPORT_DISTS.SEGMENT15%TYPE;
2017: l_segment16 AP_EXP_REPORT_DISTS.SEGMENT16%TYPE;

Line 2014: l_segment13 AP_EXP_REPORT_DISTS.SEGMENT13%TYPE;

2010: l_segment9 AP_EXP_REPORT_DISTS.SEGMENT9%TYPE;
2011: l_segment10 AP_EXP_REPORT_DISTS.SEGMENT10%TYPE;
2012: l_segment11 AP_EXP_REPORT_DISTS.SEGMENT11%TYPE;
2013: l_segment12 AP_EXP_REPORT_DISTS.SEGMENT12%TYPE;
2014: l_segment13 AP_EXP_REPORT_DISTS.SEGMENT13%TYPE;
2015: l_segment14 AP_EXP_REPORT_DISTS.SEGMENT14%TYPE;
2016: l_segment15 AP_EXP_REPORT_DISTS.SEGMENT15%TYPE;
2017: l_segment16 AP_EXP_REPORT_DISTS.SEGMENT16%TYPE;
2018: l_segment17 AP_EXP_REPORT_DISTS.SEGMENT17%TYPE;

Line 2015: l_segment14 AP_EXP_REPORT_DISTS.SEGMENT14%TYPE;

2011: l_segment10 AP_EXP_REPORT_DISTS.SEGMENT10%TYPE;
2012: l_segment11 AP_EXP_REPORT_DISTS.SEGMENT11%TYPE;
2013: l_segment12 AP_EXP_REPORT_DISTS.SEGMENT12%TYPE;
2014: l_segment13 AP_EXP_REPORT_DISTS.SEGMENT13%TYPE;
2015: l_segment14 AP_EXP_REPORT_DISTS.SEGMENT14%TYPE;
2016: l_segment15 AP_EXP_REPORT_DISTS.SEGMENT15%TYPE;
2017: l_segment16 AP_EXP_REPORT_DISTS.SEGMENT16%TYPE;
2018: l_segment17 AP_EXP_REPORT_DISTS.SEGMENT17%TYPE;
2019: l_segment18 AP_EXP_REPORT_DISTS.SEGMENT18%TYPE;

Line 2016: l_segment15 AP_EXP_REPORT_DISTS.SEGMENT15%TYPE;

2012: l_segment11 AP_EXP_REPORT_DISTS.SEGMENT11%TYPE;
2013: l_segment12 AP_EXP_REPORT_DISTS.SEGMENT12%TYPE;
2014: l_segment13 AP_EXP_REPORT_DISTS.SEGMENT13%TYPE;
2015: l_segment14 AP_EXP_REPORT_DISTS.SEGMENT14%TYPE;
2016: l_segment15 AP_EXP_REPORT_DISTS.SEGMENT15%TYPE;
2017: l_segment16 AP_EXP_REPORT_DISTS.SEGMENT16%TYPE;
2018: l_segment17 AP_EXP_REPORT_DISTS.SEGMENT17%TYPE;
2019: l_segment18 AP_EXP_REPORT_DISTS.SEGMENT18%TYPE;
2020: l_segment19 AP_EXP_REPORT_DISTS.SEGMENT19%TYPE;

Line 2017: l_segment16 AP_EXP_REPORT_DISTS.SEGMENT16%TYPE;

2013: l_segment12 AP_EXP_REPORT_DISTS.SEGMENT12%TYPE;
2014: l_segment13 AP_EXP_REPORT_DISTS.SEGMENT13%TYPE;
2015: l_segment14 AP_EXP_REPORT_DISTS.SEGMENT14%TYPE;
2016: l_segment15 AP_EXP_REPORT_DISTS.SEGMENT15%TYPE;
2017: l_segment16 AP_EXP_REPORT_DISTS.SEGMENT16%TYPE;
2018: l_segment17 AP_EXP_REPORT_DISTS.SEGMENT17%TYPE;
2019: l_segment18 AP_EXP_REPORT_DISTS.SEGMENT18%TYPE;
2020: l_segment19 AP_EXP_REPORT_DISTS.SEGMENT19%TYPE;
2021: l_segment20 AP_EXP_REPORT_DISTS.SEGMENT20%TYPE;

Line 2018: l_segment17 AP_EXP_REPORT_DISTS.SEGMENT17%TYPE;

2014: l_segment13 AP_EXP_REPORT_DISTS.SEGMENT13%TYPE;
2015: l_segment14 AP_EXP_REPORT_DISTS.SEGMENT14%TYPE;
2016: l_segment15 AP_EXP_REPORT_DISTS.SEGMENT15%TYPE;
2017: l_segment16 AP_EXP_REPORT_DISTS.SEGMENT16%TYPE;
2018: l_segment17 AP_EXP_REPORT_DISTS.SEGMENT17%TYPE;
2019: l_segment18 AP_EXP_REPORT_DISTS.SEGMENT18%TYPE;
2020: l_segment19 AP_EXP_REPORT_DISTS.SEGMENT19%TYPE;
2021: l_segment20 AP_EXP_REPORT_DISTS.SEGMENT20%TYPE;
2022: l_segment21 AP_EXP_REPORT_DISTS.SEGMENT21%TYPE;

Line 2019: l_segment18 AP_EXP_REPORT_DISTS.SEGMENT18%TYPE;

2015: l_segment14 AP_EXP_REPORT_DISTS.SEGMENT14%TYPE;
2016: l_segment15 AP_EXP_REPORT_DISTS.SEGMENT15%TYPE;
2017: l_segment16 AP_EXP_REPORT_DISTS.SEGMENT16%TYPE;
2018: l_segment17 AP_EXP_REPORT_DISTS.SEGMENT17%TYPE;
2019: l_segment18 AP_EXP_REPORT_DISTS.SEGMENT18%TYPE;
2020: l_segment19 AP_EXP_REPORT_DISTS.SEGMENT19%TYPE;
2021: l_segment20 AP_EXP_REPORT_DISTS.SEGMENT20%TYPE;
2022: l_segment21 AP_EXP_REPORT_DISTS.SEGMENT21%TYPE;
2023: l_segment22 AP_EXP_REPORT_DISTS.SEGMENT22%TYPE;

Line 2020: l_segment19 AP_EXP_REPORT_DISTS.SEGMENT19%TYPE;

2016: l_segment15 AP_EXP_REPORT_DISTS.SEGMENT15%TYPE;
2017: l_segment16 AP_EXP_REPORT_DISTS.SEGMENT16%TYPE;
2018: l_segment17 AP_EXP_REPORT_DISTS.SEGMENT17%TYPE;
2019: l_segment18 AP_EXP_REPORT_DISTS.SEGMENT18%TYPE;
2020: l_segment19 AP_EXP_REPORT_DISTS.SEGMENT19%TYPE;
2021: l_segment20 AP_EXP_REPORT_DISTS.SEGMENT20%TYPE;
2022: l_segment21 AP_EXP_REPORT_DISTS.SEGMENT21%TYPE;
2023: l_segment22 AP_EXP_REPORT_DISTS.SEGMENT22%TYPE;
2024: l_segment23 AP_EXP_REPORT_DISTS.SEGMENT23%TYPE;

Line 2021: l_segment20 AP_EXP_REPORT_DISTS.SEGMENT20%TYPE;

2017: l_segment16 AP_EXP_REPORT_DISTS.SEGMENT16%TYPE;
2018: l_segment17 AP_EXP_REPORT_DISTS.SEGMENT17%TYPE;
2019: l_segment18 AP_EXP_REPORT_DISTS.SEGMENT18%TYPE;
2020: l_segment19 AP_EXP_REPORT_DISTS.SEGMENT19%TYPE;
2021: l_segment20 AP_EXP_REPORT_DISTS.SEGMENT20%TYPE;
2022: l_segment21 AP_EXP_REPORT_DISTS.SEGMENT21%TYPE;
2023: l_segment22 AP_EXP_REPORT_DISTS.SEGMENT22%TYPE;
2024: l_segment23 AP_EXP_REPORT_DISTS.SEGMENT23%TYPE;
2025: l_segment24 AP_EXP_REPORT_DISTS.SEGMENT24%TYPE;

Line 2022: l_segment21 AP_EXP_REPORT_DISTS.SEGMENT21%TYPE;

2018: l_segment17 AP_EXP_REPORT_DISTS.SEGMENT17%TYPE;
2019: l_segment18 AP_EXP_REPORT_DISTS.SEGMENT18%TYPE;
2020: l_segment19 AP_EXP_REPORT_DISTS.SEGMENT19%TYPE;
2021: l_segment20 AP_EXP_REPORT_DISTS.SEGMENT20%TYPE;
2022: l_segment21 AP_EXP_REPORT_DISTS.SEGMENT21%TYPE;
2023: l_segment22 AP_EXP_REPORT_DISTS.SEGMENT22%TYPE;
2024: l_segment23 AP_EXP_REPORT_DISTS.SEGMENT23%TYPE;
2025: l_segment24 AP_EXP_REPORT_DISTS.SEGMENT24%TYPE;
2026: l_segment25 AP_EXP_REPORT_DISTS.SEGMENT25%TYPE;

Line 2023: l_segment22 AP_EXP_REPORT_DISTS.SEGMENT22%TYPE;

2019: l_segment18 AP_EXP_REPORT_DISTS.SEGMENT18%TYPE;
2020: l_segment19 AP_EXP_REPORT_DISTS.SEGMENT19%TYPE;
2021: l_segment20 AP_EXP_REPORT_DISTS.SEGMENT20%TYPE;
2022: l_segment21 AP_EXP_REPORT_DISTS.SEGMENT21%TYPE;
2023: l_segment22 AP_EXP_REPORT_DISTS.SEGMENT22%TYPE;
2024: l_segment23 AP_EXP_REPORT_DISTS.SEGMENT23%TYPE;
2025: l_segment24 AP_EXP_REPORT_DISTS.SEGMENT24%TYPE;
2026: l_segment25 AP_EXP_REPORT_DISTS.SEGMENT25%TYPE;
2027: l_segment26 AP_EXP_REPORT_DISTS.SEGMENT26%TYPE;

Line 2024: l_segment23 AP_EXP_REPORT_DISTS.SEGMENT23%TYPE;

2020: l_segment19 AP_EXP_REPORT_DISTS.SEGMENT19%TYPE;
2021: l_segment20 AP_EXP_REPORT_DISTS.SEGMENT20%TYPE;
2022: l_segment21 AP_EXP_REPORT_DISTS.SEGMENT21%TYPE;
2023: l_segment22 AP_EXP_REPORT_DISTS.SEGMENT22%TYPE;
2024: l_segment23 AP_EXP_REPORT_DISTS.SEGMENT23%TYPE;
2025: l_segment24 AP_EXP_REPORT_DISTS.SEGMENT24%TYPE;
2026: l_segment25 AP_EXP_REPORT_DISTS.SEGMENT25%TYPE;
2027: l_segment26 AP_EXP_REPORT_DISTS.SEGMENT26%TYPE;
2028: l_segment27 AP_EXP_REPORT_DISTS.SEGMENT27%TYPE;

Line 2025: l_segment24 AP_EXP_REPORT_DISTS.SEGMENT24%TYPE;

2021: l_segment20 AP_EXP_REPORT_DISTS.SEGMENT20%TYPE;
2022: l_segment21 AP_EXP_REPORT_DISTS.SEGMENT21%TYPE;
2023: l_segment22 AP_EXP_REPORT_DISTS.SEGMENT22%TYPE;
2024: l_segment23 AP_EXP_REPORT_DISTS.SEGMENT23%TYPE;
2025: l_segment24 AP_EXP_REPORT_DISTS.SEGMENT24%TYPE;
2026: l_segment25 AP_EXP_REPORT_DISTS.SEGMENT25%TYPE;
2027: l_segment26 AP_EXP_REPORT_DISTS.SEGMENT26%TYPE;
2028: l_segment27 AP_EXP_REPORT_DISTS.SEGMENT27%TYPE;
2029: l_segment28 AP_EXP_REPORT_DISTS.SEGMENT28%TYPE;

Line 2026: l_segment25 AP_EXP_REPORT_DISTS.SEGMENT25%TYPE;

2022: l_segment21 AP_EXP_REPORT_DISTS.SEGMENT21%TYPE;
2023: l_segment22 AP_EXP_REPORT_DISTS.SEGMENT22%TYPE;
2024: l_segment23 AP_EXP_REPORT_DISTS.SEGMENT23%TYPE;
2025: l_segment24 AP_EXP_REPORT_DISTS.SEGMENT24%TYPE;
2026: l_segment25 AP_EXP_REPORT_DISTS.SEGMENT25%TYPE;
2027: l_segment26 AP_EXP_REPORT_DISTS.SEGMENT26%TYPE;
2028: l_segment27 AP_EXP_REPORT_DISTS.SEGMENT27%TYPE;
2029: l_segment28 AP_EXP_REPORT_DISTS.SEGMENT28%TYPE;
2030: l_segment29 AP_EXP_REPORT_DISTS.SEGMENT29%TYPE;

Line 2027: l_segment26 AP_EXP_REPORT_DISTS.SEGMENT26%TYPE;

2023: l_segment22 AP_EXP_REPORT_DISTS.SEGMENT22%TYPE;
2024: l_segment23 AP_EXP_REPORT_DISTS.SEGMENT23%TYPE;
2025: l_segment24 AP_EXP_REPORT_DISTS.SEGMENT24%TYPE;
2026: l_segment25 AP_EXP_REPORT_DISTS.SEGMENT25%TYPE;
2027: l_segment26 AP_EXP_REPORT_DISTS.SEGMENT26%TYPE;
2028: l_segment27 AP_EXP_REPORT_DISTS.SEGMENT27%TYPE;
2029: l_segment28 AP_EXP_REPORT_DISTS.SEGMENT28%TYPE;
2030: l_segment29 AP_EXP_REPORT_DISTS.SEGMENT29%TYPE;
2031: l_segment30 AP_EXP_REPORT_DISTS.SEGMENT30%TYPE;

Line 2028: l_segment27 AP_EXP_REPORT_DISTS.SEGMENT27%TYPE;

2024: l_segment23 AP_EXP_REPORT_DISTS.SEGMENT23%TYPE;
2025: l_segment24 AP_EXP_REPORT_DISTS.SEGMENT24%TYPE;
2026: l_segment25 AP_EXP_REPORT_DISTS.SEGMENT25%TYPE;
2027: l_segment26 AP_EXP_REPORT_DISTS.SEGMENT26%TYPE;
2028: l_segment27 AP_EXP_REPORT_DISTS.SEGMENT27%TYPE;
2029: l_segment28 AP_EXP_REPORT_DISTS.SEGMENT28%TYPE;
2030: l_segment29 AP_EXP_REPORT_DISTS.SEGMENT29%TYPE;
2031: l_segment30 AP_EXP_REPORT_DISTS.SEGMENT30%TYPE;
2032: l_preparer_modified_flag AP_EXP_REPORT_DISTS.PREPARER_MODIFIED_FLAG%TYPE;

Line 2029: l_segment28 AP_EXP_REPORT_DISTS.SEGMENT28%TYPE;

2025: l_segment24 AP_EXP_REPORT_DISTS.SEGMENT24%TYPE;
2026: l_segment25 AP_EXP_REPORT_DISTS.SEGMENT25%TYPE;
2027: l_segment26 AP_EXP_REPORT_DISTS.SEGMENT26%TYPE;
2028: l_segment27 AP_EXP_REPORT_DISTS.SEGMENT27%TYPE;
2029: l_segment28 AP_EXP_REPORT_DISTS.SEGMENT28%TYPE;
2030: l_segment29 AP_EXP_REPORT_DISTS.SEGMENT29%TYPE;
2031: l_segment30 AP_EXP_REPORT_DISTS.SEGMENT30%TYPE;
2032: l_preparer_modified_flag AP_EXP_REPORT_DISTS.PREPARER_MODIFIED_FLAG%TYPE;
2033: l_amount AP_EXP_REPORT_DISTS.AMOUNT%TYPE;

Line 2030: l_segment29 AP_EXP_REPORT_DISTS.SEGMENT29%TYPE;

2026: l_segment25 AP_EXP_REPORT_DISTS.SEGMENT25%TYPE;
2027: l_segment26 AP_EXP_REPORT_DISTS.SEGMENT26%TYPE;
2028: l_segment27 AP_EXP_REPORT_DISTS.SEGMENT27%TYPE;
2029: l_segment28 AP_EXP_REPORT_DISTS.SEGMENT28%TYPE;
2030: l_segment29 AP_EXP_REPORT_DISTS.SEGMENT29%TYPE;
2031: l_segment30 AP_EXP_REPORT_DISTS.SEGMENT30%TYPE;
2032: l_preparer_modified_flag AP_EXP_REPORT_DISTS.PREPARER_MODIFIED_FLAG%TYPE;
2033: l_amount AP_EXP_REPORT_DISTS.AMOUNT%TYPE;
2034: l_cost_center AP_EXP_REPORT_DISTS.COST_CENTER%TYPE;

Line 2031: l_segment30 AP_EXP_REPORT_DISTS.SEGMENT30%TYPE;

2027: l_segment26 AP_EXP_REPORT_DISTS.SEGMENT26%TYPE;
2028: l_segment27 AP_EXP_REPORT_DISTS.SEGMENT27%TYPE;
2029: l_segment28 AP_EXP_REPORT_DISTS.SEGMENT28%TYPE;
2030: l_segment29 AP_EXP_REPORT_DISTS.SEGMENT29%TYPE;
2031: l_segment30 AP_EXP_REPORT_DISTS.SEGMENT30%TYPE;
2032: l_preparer_modified_flag AP_EXP_REPORT_DISTS.PREPARER_MODIFIED_FLAG%TYPE;
2033: l_amount AP_EXP_REPORT_DISTS.AMOUNT%TYPE;
2034: l_cost_center AP_EXP_REPORT_DISTS.COST_CENTER%TYPE;
2035:

Line 2032: l_preparer_modified_flag AP_EXP_REPORT_DISTS.PREPARER_MODIFIED_FLAG%TYPE;

2028: l_segment27 AP_EXP_REPORT_DISTS.SEGMENT27%TYPE;
2029: l_segment28 AP_EXP_REPORT_DISTS.SEGMENT28%TYPE;
2030: l_segment29 AP_EXP_REPORT_DISTS.SEGMENT29%TYPE;
2031: l_segment30 AP_EXP_REPORT_DISTS.SEGMENT30%TYPE;
2032: l_preparer_modified_flag AP_EXP_REPORT_DISTS.PREPARER_MODIFIED_FLAG%TYPE;
2033: l_amount AP_EXP_REPORT_DISTS.AMOUNT%TYPE;
2034: l_cost_center AP_EXP_REPORT_DISTS.COST_CENTER%TYPE;
2035:
2036: -- Bug: 6611357, Removed References to Project Information and updated dists

Line 2033: l_amount AP_EXP_REPORT_DISTS.AMOUNT%TYPE;

2029: l_segment28 AP_EXP_REPORT_DISTS.SEGMENT28%TYPE;
2030: l_segment29 AP_EXP_REPORT_DISTS.SEGMENT29%TYPE;
2031: l_segment30 AP_EXP_REPORT_DISTS.SEGMENT30%TYPE;
2032: l_preparer_modified_flag AP_EXP_REPORT_DISTS.PREPARER_MODIFIED_FLAG%TYPE;
2033: l_amount AP_EXP_REPORT_DISTS.AMOUNT%TYPE;
2034: l_cost_center AP_EXP_REPORT_DISTS.COST_CENTER%TYPE;
2035:
2036: -- Bug: 6611357, Removed References to Project Information and updated dists
2037: -- table with nulls when creating a .1 report with BothPay

Line 2034: l_cost_center AP_EXP_REPORT_DISTS.COST_CENTER%TYPE;

2030: l_segment29 AP_EXP_REPORT_DISTS.SEGMENT29%TYPE;
2031: l_segment30 AP_EXP_REPORT_DISTS.SEGMENT30%TYPE;
2032: l_preparer_modified_flag AP_EXP_REPORT_DISTS.PREPARER_MODIFIED_FLAG%TYPE;
2033: l_amount AP_EXP_REPORT_DISTS.AMOUNT%TYPE;
2034: l_cost_center AP_EXP_REPORT_DISTS.COST_CENTER%TYPE;
2035:
2036: -- Bug: 6611357, Removed References to Project Information and updated dists
2037: -- table with nulls when creating a .1 report with BothPay
2038:

Line 2048: FROM AP_EXP_REPORT_DISTS_ALL DT,

2044: DT.CREATED_BY,
2045: DT.PREPARER_MODIFIED_FLAG,
2046: DT.AMOUNT,
2047: DT.COST_CENTER
2048: FROM AP_EXP_REPORT_DISTS_ALL DT,
2049: AP_EXPENSE_REPORT_LINES_ALL DL
2050: WHERE DT.REPORT_LINE_ID = p_line_id
2051: AND DT.REPORT_LINE_ID = DL.REPORT_LINE_ID
2052: AND (DL.ITEMIZATION_PARENT_ID IS NULL

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

2174: allocation_split_code --Bug#6870253
2175: FROM ap_expense_report_lines erl
2176: WHERE report_line_id = p_report_line_id;
2177:
2178: -- for bug 5288256: insert a new row in ap_exp_report_dists_all table
2179: SELECT GL.SEGMENT1, GL.SEGMENT2,GL.SEGMENT3,GL.SEGMENT4, GL.SEGMENT5, GL.SEGMENT6,
2180: GL.SEGMENT7, GL.SEGMENT8,GL.SEGMENT9,GL.SEGMENT10,GL.SEGMENT11, GL.SEGMENT12,
2181: GL.SEGMENT13, GL.SEGMENT14, GL.SEGMENT15, GL.SEGMENT16, GL.SEGMENT17, GL.SEGMENT18,
2182: GL.SEGMENT19, GL.SEGMENT20, GL.SEGMENT21, GL.SEGMENT22, GL.SEGMENT23, GL.SEGMENT24,

Line 2199: INSERT INTO AP_EXP_REPORT_DISTS

2195: FETCH copy_dist into l_org_id, l_sequence_num, l_last_updated_by, l_created_by,
2196: l_preparer_modified_flag, l_amount, l_cost_center;
2197: EXIT WHEN copy_dist%NOTFOUND;
2198:
2199: INSERT INTO AP_EXP_REPORT_DISTS
2200: (
2201: report_header_id,
2202: report_line_id,
2203: report_distribution_id,

Line 2252: AP_EXP_REPORT_DISTS_S.NEXTVAL,

2248: )
2249: VALUES (
2250: p_new_report_header_id,
2251: p_new_report_line_id,
2252: AP_EXP_REPORT_DISTS_S.NEXTVAL,
2253: l_org_id,
2254: l_sequence_num,
2255: SYSDATE,
2256: l_last_updated_by,

Line 2627: DELETE FROM ap_exp_report_dists

2623: return FALSE;
2624: END IF; /* GetPersonalParamID */
2625:
2626: -- Bug: 8588537 remove distributions on the personal lines
2627: DELETE FROM ap_exp_report_dists
2628: WHERE report_line_id in
2629: (SELECT report_line_id
2630: FROM ap_expense_report_lines
2631: WHERE web_parameter_id = l_personalParameterId