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.

[Home] [Help]

APPS.RG_XFER_COMP_PRIVATE_PKG SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 18


    'INSERT INTO RG_REPORT_AXES (' ||
    '  APPLICATION_ID, AXIS_SET_ID, AXIS_SEQ, LAST_UPDATE_DATE' ||
    ', LAST_UPDATED_BY, LAST_UPDATE_LOGIN, CREATION_DATE, CREATED_BY' ||
    ', AXIS_TYPE, AXIS_NAME, AMOUNT_ID, STANDARD_AXIS_ID' ||
    ', WIDTH, POSITION, STRUCTURE_ID, UNIT_OF_MEASURE_ID' ||
    ', PARAMETER_NUM, PERIOD_OFFSET, DESCRIPTION, DISPLAY_FLAG' ||
    ', BEFORE_AXIS_STRING, AFTER_AXIS_STRING, NUMBER_CHARACTERS_INDENTED' ||
    ', PAGE_BREAK_AFTER_FLAG, PAGE_BREAK_BEFORE_FLAG' ||
    ', NUMBER_LINES_SKIPPED_BEFORE, NUMBER_LINES_SKIPPED_AFTER,DISPLAY_LEVEL'||
    ', DISPLAY_ZERO_AMOUNT_FLAG, CHANGE_SIGN_FLAG, CHANGE_VARIANCE_SIGN_FLAG'||
    ', DISPLAY_UNITS, DISPLAY_FORMAT, CALCULATION_PRECEDENCE_FLAG, CONTEXT ' ||
    ', ATTRIBUTE1 , ATTRIBUTE2 , ATTRIBUTE3 , ATTRIBUTE4 , ATTRIBUTE5' ||
    ', ATTRIBUTE6 , ATTRIBUTE7 , ATTRIBUTE8 , ATTRIBUTE9 ' ||
    ', ATTRIBUTE10, ATTRIBUTE11, ATTRIBUTE12, ATTRIBUTE13' ||
    ', ATTRIBUTE14, ATTRIBUTE15, PERCENTAGE_DIVISOR_SEQ, TRANSACTION_FLAG' ||
    ', FORMAT_BEFORE_TEXT, FORMAT_AFTER_TEXT, FORMAT_MASK_WIDTH' ||
    ', DISPLAY_PRECISION, SEGMENT_OVERRIDE_VALUE' ||
    ', OVERRIDE_ALC_LEDGER_CURRENCY, ELEMENT_ID' ||
    ') SELECT' ||
    '  APPLICATION_ID, :id, AXIS_SEQ, sysdate' ||
    ', :user_id, :login_id, sysdate, :user_id' ||
    ', AXIS_TYPE, AXIS_NAME, AMOUNT_ID, STANDARD_AXIS_ID' ||
    ', WIDTH, POSITION, null, :currency_code ' ||
    ', PARAMETER_NUM, PERIOD_OFFSET, DESCRIPTION, DISPLAY_FLAG' ||
    ', BEFORE_AXIS_STRING, AFTER_AXIS_STRING, NUMBER_CHARACTERS_INDENTED' ||
    ', PAGE_BREAK_AFTER_FLAG, PAGE_BREAK_BEFORE_FLAG' ||
    ', NUMBER_LINES_SKIPPED_BEFORE, NUMBER_LINES_SKIPPED_AFTER,DISPLAY_LEVEL'||
    ', DISPLAY_ZERO_AMOUNT_FLAG, CHANGE_SIGN_FLAG, CHANGE_VARIANCE_SIGN_FLAG'||
    ', DISPLAY_UNITS, DISPLAY_FORMAT, CALCULATION_PRECEDENCE_FLAG, CONTEXT'  ||
    ', ATTRIBUTE1 , ATTRIBUTE2 , ATTRIBUTE3 , ATTRIBUTE4 , ATTRIBUTE5' ||
    ', ATTRIBUTE6 , ATTRIBUTE7 , ATTRIBUTE8 , ATTRIBUTE9 ' ||
    ', ATTRIBUTE10, ATTRIBUTE11, ATTRIBUTE12, ATTRIBUTE13' ||
    ', ATTRIBUTE14, ATTRIBUTE15, PERCENTAGE_DIVISOR_SEQ, TRANSACTION_FLAG' ||
    ', FORMAT_BEFORE_TEXT, FORMAT_AFTER_TEXT, FORMAT_MASK_WIDTH' ||
    ', DISPLAY_PRECISION,'||
    ':segment_override_value' ||
    ', :override_alc_ledger_currency, :elem_id ' ||
    'FROM RG_REPORT_AXES@';

Line: 58


 'INSERT INTO RG_REPORT_CONTENT_OVERRIDES (' ||
 '  APPLICATION_ID, CONTENT_SET_ID, LAST_UPDATE_DATE' ||
 ', LAST_UPDATED_BY, LAST_UPDATE_LOGIN, CREATION_DATE' ||
 ', CREATED_BY, OVERRIDE_SEQ, RANGE_MODE' ||
 ', LEDGER_ID, LEDGER_SEGMENT_TYPE, ALC_LEDGER_CURRENCY' ||
 ', SEGMENT1_LOW, SEGMENT1_HIGH, SEGMENT1_TYPE' ||
 ', SEGMENT2_LOW, SEGMENT2_HIGH, SEGMENT2_TYPE' ||
 ', SEGMENT3_LOW, SEGMENT3_HIGH, SEGMENT3_TYPE' ||
 ', SEGMENT4_LOW, SEGMENT4_HIGH, SEGMENT4_TYPE' ||
 ', SEGMENT5_LOW, SEGMENT5_HIGH, SEGMENT5_TYPE' ||
 ', SEGMENT6_LOW, SEGMENT6_HIGH, SEGMENT6_TYPE' ||
 ', SEGMENT7_LOW, SEGMENT7_HIGH, SEGMENT7_TYPE' ||
 ', SEGMENT8_LOW, SEGMENT8_HIGH, SEGMENT8_TYPE' ||
 ', SEGMENT9_LOW, SEGMENT9_HIGH, SEGMENT9_TYPE' ||
 ', SEGMENT10_LOW, SEGMENT10_HIGH, SEGMENT10_TYPE' ||
 ', SEGMENT11_LOW, SEGMENT11_HIGH, SEGMENT11_TYPE' ||
 ', SEGMENT12_LOW, SEGMENT12_HIGH, SEGMENT12_TYPE' ||
 ', SEGMENT13_LOW, SEGMENT13_HIGH, SEGMENT13_TYPE' ||
 ', SEGMENT14_LOW, SEGMENT14_HIGH, SEGMENT14_TYPE' ||
 ', SEGMENT15_LOW, SEGMENT15_HIGH, SEGMENT15_TYPE' ||
 ', SEGMENT16_LOW, SEGMENT16_HIGH, SEGMENT16_TYPE' ||
 ', SEGMENT17_LOW, SEGMENT17_HIGH, SEGMENT17_TYPE' ||
 ', SEGMENT18_LOW, SEGMENT18_HIGH, SEGMENT18_TYPE' ||
 ', SEGMENT19_LOW, SEGMENT19_HIGH, SEGMENT19_TYPE' ||
 ', SEGMENT20_LOW, SEGMENT20_HIGH, SEGMENT20_TYPE' ||
 ', SEGMENT21_LOW, SEGMENT21_HIGH, SEGMENT21_TYPE' ||
 ', SEGMENT22_LOW, SEGMENT22_HIGH, SEGMENT22_TYPE' ||
 ', SEGMENT23_LOW, SEGMENT23_HIGH, SEGMENT23_TYPE' ||
 ', SEGMENT24_LOW, SEGMENT24_HIGH, SEGMENT24_TYPE' ||
 ', SEGMENT25_LOW, SEGMENT25_HIGH, SEGMENT25_TYPE' ||
 ', SEGMENT26_LOW, SEGMENT26_HIGH, SEGMENT26_TYPE' ||
 ', SEGMENT27_LOW, SEGMENT27_HIGH, SEGMENT27_TYPE' ||
 ', SEGMENT28_LOW, SEGMENT28_HIGH, SEGMENT28_TYPE' ||
 ', SEGMENT29_LOW, SEGMENT29_HIGH, SEGMENT29_TYPE' ||
 ', SEGMENT30_LOW, SEGMENT30_HIGH, SEGMENT30_TYPE' ||
 ', CONTEXT, ATTRIBUTE1, ATTRIBUTE2, ATTRIBUTE3, ATTRIBUTE4, ATTRIBUTE5' ||
 ', ATTRIBUTE6, ATTRIBUTE7, ATTRIBUTE8, ATTRIBUTE9, ATTRIBUTE10, ATTRIBUTE11'||
 ', ATTRIBUTE12, ATTRIBUTE13, ATTRIBUTE14' ||
 ', ATTRIBUTE15, SEGMENT_ATTRIBUTE1_LOW, SEGMENT_ATTRIBUTE1_HIGH' ||
 ', SEGMENT_ATTRIBUTE1_TYPE, SEGMENT_ATTRIBUTE2_LOW, SEGMENT_ATTRIBUTE2_HIGH'||
 ', SEGMENT_ATTRIBUTE2_TYPE, SEGMENT_ATTRIBUTE3_LOW, SEGMENT_ATTRIBUTE3_HIGH'||
 ', SEGMENT_ATTRIBUTE3_TYPE, SEGMENT_ATTRIBUTE4_LOW, SEGMENT_ATTRIBUTE4_HIGH'||
 ', SEGMENT_ATTRIBUTE4_TYPE, SEGMENT_ATTRIBUTE5_LOW, SEGMENT_ATTRIBUTE5_HIGH'||
 ', SEGMENT_ATTRIBUTE5_TYPE, SEGMENT_ATTRIBUTE6_LOW, SEGMENT_ATTRIBUTE6_HIGH'||
 ', SEGMENT_ATTRIBUTE6_TYPE, SEGMENT_ATTRIBUTE7_LOW, SEGMENT_ATTRIBUTE7_HIGH'||
 ', SEGMENT_ATTRIBUTE7_TYPE, SEGMENT_ATTRIBUTE8_LOW, SEGMENT_ATTRIBUTE8_HIGH'||
 ', SEGMENT_ATTRIBUTE8_TYPE, SEGMENT_ATTRIBUTE9_LOW, SEGMENT_ATTRIBUTE9_HIGH'||
 ',SEGMENT_ATTRIBUTE9_TYPE,SEGMENT_ATTRIBUTE10_LOW,SEGMENT_ATTRIBUTE10_HIGH'||
 ',SEGMENT_ATTRIBUTE10_TYPE,SEGMENT_ATTRIBUTE11_LOW,SEGMENT_ATTRIBUTE11_HIGH'||
 ',SEGMENT_ATTRIBUTE11_TYPE,SEGMENT_ATTRIBUTE12_LOW,SEGMENT_ATTRIBUTE12_HIGH'||
 ',SEGMENT_ATTRIBUTE12_TYPE,SEGMENT_ATTRIBUTE13_LOW,SEGMENT_ATTRIBUTE13_HIGH'||
 ',SEGMENT_ATTRIBUTE13_TYPE,SEGMENT_ATTRIBUTE14_LOW,SEGMENT_ATTRIBUTE14_HIGH'||
 ',SEGMENT_ATTRIBUTE14_TYPE,SEGMENT_ATTRIBUTE15_LOW,SEGMENT_ATTRIBUTE15_HIGH'||
 ',SEGMENT_ATTRIBUTE15_TYPE,SEGMENT_ATTRIBUTE16_LOW,SEGMENT_ATTRIBUTE16_HIGH'||
 ',SEGMENT_ATTRIBUTE16_TYPE,SEGMENT_ATTRIBUTE17_LOW,SEGMENT_ATTRIBUTE17_HIGH'||
 ',SEGMENT_ATTRIBUTE17_TYPE,SEGMENT_ATTRIBUTE18_LOW,SEGMENT_ATTRIBUTE18_HIGH'||
 ',SEGMENT_ATTRIBUTE18_TYPE,SEGMENT_ATTRIBUTE19_LOW,SEGMENT_ATTRIBUTE19_HIGH'||
 ',SEGMENT_ATTRIBUTE19_TYPE,SEGMENT_ATTRIBUTE20_LOW,SEGMENT_ATTRIBUTE20_HIGH'||
 ',SEGMENT_ATTRIBUTE20_TYPE,SEGMENT_ATTRIBUTE21_LOW,SEGMENT_ATTRIBUTE21_HIGH'||
 ',SEGMENT_ATTRIBUTE21_TYPE,SEGMENT_ATTRIBUTE22_LOW,SEGMENT_ATTRIBUTE22_HIGH'||
 ',SEGMENT_ATTRIBUTE22_TYPE,SEGMENT_ATTRIBUTE23_LOW,SEGMENT_ATTRIBUTE23_HIGH'||
 ',SEGMENT_ATTRIBUTE23_TYPE,SEGMENT_ATTRIBUTE24_LOW,SEGMENT_ATTRIBUTE24_HIGH'||
 ',SEGMENT_ATTRIBUTE24_TYPE,SEGMENT_ATTRIBUTE25_LOW,SEGMENT_ATTRIBUTE25_HIGH'||
 ',SEGMENT_ATTRIBUTE25_TYPE,SEGMENT_ATTRIBUTE26_LOW,SEGMENT_ATTRIBUTE26_HIGH'||
 ',SEGMENT_ATTRIBUTE26_TYPE,SEGMENT_ATTRIBUTE27_LOW,SEGMENT_ATTRIBUTE27_HIGH'||
 ',SEGMENT_ATTRIBUTE27_TYPE,SEGMENT_ATTRIBUTE28_LOW,SEGMENT_ATTRIBUTE28_HIGH'||
 ',SEGMENT_ATTRIBUTE28_TYPE,SEGMENT_ATTRIBUTE29_LOW,SEGMENT_ATTRIBUTE29_HIGH'||
 ',SEGMENT_ATTRIBUTE29_TYPE,SEGMENT_ATTRIBUTE30_LOW,SEGMENT_ATTRIBUTE30_HIGH'||
 ',SEGMENT_ATTRIBUTE30_TYPE,SEGMENT_ATTRIBUTE31_LOW,SEGMENT_ATTRIBUTE31_HIGH'||
 ',SEGMENT_ATTRIBUTE31_TYPE,SEGMENT_ATTRIBUTE32_LOW,SEGMENT_ATTRIBUTE32_HIGH'||
 ',SEGMENT_ATTRIBUTE32_TYPE,SEGMENT_ATTRIBUTE33_LOW,SEGMENT_ATTRIBUTE33_HIGH'||
 ',SEGMENT_ATTRIBUTE33_TYPE,SEGMENT_ATTRIBUTE34_LOW,SEGMENT_ATTRIBUTE34_HIGH'||
 ',SEGMENT_ATTRIBUTE34_TYPE,SEGMENT_ATTRIBUTE35_LOW,SEGMENT_ATTRIBUTE35_HIGH'||
 ',SEGMENT_ATTRIBUTE35_TYPE,SEGMENT_ATTRIBUTE36_LOW,SEGMENT_ATTRIBUTE36_HIGH'||
 ',SEGMENT_ATTRIBUTE36_TYPE,SEGMENT_ATTRIBUTE37_LOW,SEGMENT_ATTRIBUTE37_HIGH'||
 ',SEGMENT_ATTRIBUTE37_TYPE,SEGMENT_ATTRIBUTE38_LOW,SEGMENT_ATTRIBUTE38_HIGH'||
 ',SEGMENT_ATTRIBUTE38_TYPE,SEGMENT_ATTRIBUTE39_LOW,SEGMENT_ATTRIBUTE39_HIGH'||
 ',SEGMENT_ATTRIBUTE39_TYPE,SEGMENT_ATTRIBUTE40_LOW,SEGMENT_ATTRIBUTE40_HIGH'||
 ',SEGMENT_ATTRIBUTE40_TYPE,SEGMENT_ATTRIBUTE41_LOW,SEGMENT_ATTRIBUTE41_HIGH'||
 ',SEGMENT_ATTRIBUTE41_TYPE,SEGMENT_ATTRIBUTE42_LOW,SEGMENT_ATTRIBUTE42_HIGH'||
 ',SEGMENT_ATTRIBUTE42_TYPE'||
 ') SELECT'||
 '  APPLICATION_ID, :id, sysdate' ||
 ', :user_id, :login_id, sysdate' ||
 ', :user_id, OVERRIDE_SEQ, RANGE_MODE' ||
 ', :ledger_id, LEDGER_SEGMENT_TYPE, :alc_ledger_currency' ||
 ', SEGMENT1_LOW, SEGMENT1_HIGH, SEGMENT1_TYPE' ||
 ', SEGMENT2_LOW, SEGMENT2_HIGH, SEGMENT2_TYPE' ||
 ', SEGMENT3_LOW, SEGMENT3_HIGH, SEGMENT3_TYPE' ||
 ', SEGMENT4_LOW, SEGMENT4_HIGH, SEGMENT4_TYPE' ||
 ', SEGMENT5_LOW, SEGMENT5_HIGH, SEGMENT5_TYPE' ||
 ', SEGMENT6_LOW, SEGMENT6_HIGH, SEGMENT6_TYPE' ||
 ', SEGMENT7_LOW, SEGMENT7_HIGH, SEGMENT7_TYPE' ||
 ', SEGMENT8_LOW, SEGMENT8_HIGH, SEGMENT8_TYPE' ||
 ', SEGMENT9_LOW, SEGMENT9_HIGH, SEGMENT9_TYPE' ||
 ', SEGMENT10_LOW, SEGMENT10_HIGH, SEGMENT10_TYPE' ||
 ', SEGMENT11_LOW, SEGMENT11_HIGH, SEGMENT11_TYPE' ||
 ', SEGMENT12_LOW, SEGMENT12_HIGH, SEGMENT12_TYPE' ||
 ', SEGMENT13_LOW, SEGMENT13_HIGH, SEGMENT13_TYPE' ||
 ', SEGMENT14_LOW, SEGMENT14_HIGH, SEGMENT14_TYPE' ||
 ', SEGMENT15_LOW, SEGMENT15_HIGH, SEGMENT15_TYPE' ||
 ', SEGMENT16_LOW, SEGMENT16_HIGH, SEGMENT16_TYPE' ||
 ', SEGMENT17_LOW, SEGMENT17_HIGH, SEGMENT17_TYPE' ||
 ', SEGMENT18_LOW, SEGMENT18_HIGH, SEGMENT18_TYPE' ||
 ', SEGMENT19_LOW, SEGMENT19_HIGH, SEGMENT19_TYPE' ||
 ', SEGMENT20_LOW, SEGMENT20_HIGH, SEGMENT20_TYPE' ||
 ', SEGMENT21_LOW, SEGMENT21_HIGH, SEGMENT21_TYPE' ||
 ', SEGMENT22_LOW, SEGMENT22_HIGH, SEGMENT22_TYPE' ||
 ', SEGMENT23_LOW, SEGMENT23_HIGH, SEGMENT23_TYPE' ||
 ', SEGMENT24_LOW, SEGMENT24_HIGH, SEGMENT24_TYPE' ||
 ', SEGMENT25_LOW, SEGMENT25_HIGH, SEGMENT25_TYPE' ||
 ', SEGMENT26_LOW, SEGMENT26_HIGH, SEGMENT26_TYPE' ||
 ', SEGMENT27_LOW, SEGMENT27_HIGH, SEGMENT27_TYPE' ||
 ', SEGMENT28_LOW, SEGMENT28_HIGH, SEGMENT28_TYPE' ||
 ', SEGMENT29_LOW, SEGMENT29_HIGH, SEGMENT29_TYPE' ||
 ', SEGMENT30_LOW, SEGMENT30_HIGH, SEGMENT30_TYPE' ||
 ', CONTEXT, ATTRIBUTE1, ATTRIBUTE2, ATTRIBUTE3, ATTRIBUTE4, ATTRIBUTE5' ||
 ', ATTRIBUTE6, ATTRIBUTE7, ATTRIBUTE8, ATTRIBUTE9, ATTRIBUTE10, ATTRIBUTE11'||
 ', ATTRIBUTE12, ATTRIBUTE13, ATTRIBUTE14' ||
 ', ATTRIBUTE15, SEGMENT_ATTRIBUTE1_LOW, SEGMENT_ATTRIBUTE1_HIGH' ||
 ', SEGMENT_ATTRIBUTE1_TYPE, SEGMENT_ATTRIBUTE2_LOW, SEGMENT_ATTRIBUTE2_HIGH'||
 ', SEGMENT_ATTRIBUTE2_TYPE, SEGMENT_ATTRIBUTE3_LOW, SEGMENT_ATTRIBUTE3_HIGH'||
 ', SEGMENT_ATTRIBUTE3_TYPE, SEGMENT_ATTRIBUTE4_LOW, SEGMENT_ATTRIBUTE4_HIGH'||
 ', SEGMENT_ATTRIBUTE4_TYPE, SEGMENT_ATTRIBUTE5_LOW, SEGMENT_ATTRIBUTE5_HIGH'||
 ', SEGMENT_ATTRIBUTE5_TYPE, SEGMENT_ATTRIBUTE6_LOW, SEGMENT_ATTRIBUTE6_HIGH'||
 ', SEGMENT_ATTRIBUTE6_TYPE, SEGMENT_ATTRIBUTE7_LOW, SEGMENT_ATTRIBUTE7_HIGH'||
 ', SEGMENT_ATTRIBUTE7_TYPE, SEGMENT_ATTRIBUTE8_LOW, SEGMENT_ATTRIBUTE8_HIGH'||
 ', SEGMENT_ATTRIBUTE8_TYPE, SEGMENT_ATTRIBUTE9_LOW, SEGMENT_ATTRIBUTE9_HIGH'||
 ',SEGMENT_ATTRIBUTE9_TYPE,SEGMENT_ATTRIBUTE10_LOW,SEGMENT_ATTRIBUTE10_HIGH'||
 ',SEGMENT_ATTRIBUTE10_TYPE,SEGMENT_ATTRIBUTE11_LOW,SEGMENT_ATTRIBUTE11_HIGH'||
 ',SEGMENT_ATTRIBUTE11_TYPE,SEGMENT_ATTRIBUTE12_LOW,SEGMENT_ATTRIBUTE12_HIGH'||
 ',SEGMENT_ATTRIBUTE12_TYPE,SEGMENT_ATTRIBUTE13_LOW,SEGMENT_ATTRIBUTE13_HIGH'||
 ',SEGMENT_ATTRIBUTE13_TYPE,SEGMENT_ATTRIBUTE14_LOW,SEGMENT_ATTRIBUTE14_HIGH'||
 ',SEGMENT_ATTRIBUTE14_TYPE,SEGMENT_ATTRIBUTE15_LOW,SEGMENT_ATTRIBUTE15_HIGH'||
 ',SEGMENT_ATTRIBUTE15_TYPE,SEGMENT_ATTRIBUTE16_LOW,SEGMENT_ATTRIBUTE16_HIGH'||
 ',SEGMENT_ATTRIBUTE16_TYPE,SEGMENT_ATTRIBUTE17_LOW,SEGMENT_ATTRIBUTE17_HIGH'||
 ',SEGMENT_ATTRIBUTE17_TYPE,SEGMENT_ATTRIBUTE18_LOW,SEGMENT_ATTRIBUTE18_HIGH'||
 ',SEGMENT_ATTRIBUTE18_TYPE,SEGMENT_ATTRIBUTE19_LOW,SEGMENT_ATTRIBUTE19_HIGH'||
 ',SEGMENT_ATTRIBUTE19_TYPE,SEGMENT_ATTRIBUTE20_LOW,SEGMENT_ATTRIBUTE20_HIGH'||
 ',SEGMENT_ATTRIBUTE20_TYPE,SEGMENT_ATTRIBUTE21_LOW,SEGMENT_ATTRIBUTE21_HIGH'||
 ',SEGMENT_ATTRIBUTE21_TYPE,SEGMENT_ATTRIBUTE22_LOW,SEGMENT_ATTRIBUTE22_HIGH'||
 ',SEGMENT_ATTRIBUTE22_TYPE,SEGMENT_ATTRIBUTE23_LOW,SEGMENT_ATTRIBUTE23_HIGH'||
 ',SEGMENT_ATTRIBUTE23_TYPE,SEGMENT_ATTRIBUTE24_LOW,SEGMENT_ATTRIBUTE24_HIGH'||
 ',SEGMENT_ATTRIBUTE24_TYPE,SEGMENT_ATTRIBUTE25_LOW,SEGMENT_ATTRIBUTE25_HIGH'||
 ',SEGMENT_ATTRIBUTE25_TYPE,SEGMENT_ATTRIBUTE26_LOW,SEGMENT_ATTRIBUTE26_HIGH'||
 ',SEGMENT_ATTRIBUTE26_TYPE,SEGMENT_ATTRIBUTE27_LOW,SEGMENT_ATTRIBUTE27_HIGH'||
 ',SEGMENT_ATTRIBUTE27_TYPE,SEGMENT_ATTRIBUTE28_LOW,SEGMENT_ATTRIBUTE28_HIGH'||
 ',SEGMENT_ATTRIBUTE28_TYPE,SEGMENT_ATTRIBUTE29_LOW,SEGMENT_ATTRIBUTE29_HIGH'||
 ',SEGMENT_ATTRIBUTE29_TYPE,SEGMENT_ATTRIBUTE30_LOW,SEGMENT_ATTRIBUTE30_HIGH'||
 ',SEGMENT_ATTRIBUTE30_TYPE,SEGMENT_ATTRIBUTE31_LOW,SEGMENT_ATTRIBUTE31_HIGH'||
 ',SEGMENT_ATTRIBUTE31_TYPE,SEGMENT_ATTRIBUTE32_LOW,SEGMENT_ATTRIBUTE32_HIGH'||
 ',SEGMENT_ATTRIBUTE32_TYPE,SEGMENT_ATTRIBUTE33_LOW,SEGMENT_ATTRIBUTE33_HIGH'||
 ',SEGMENT_ATTRIBUTE33_TYPE,SEGMENT_ATTRIBUTE34_LOW,SEGMENT_ATTRIBUTE34_HIGH'||
 ',SEGMENT_ATTRIBUTE34_TYPE,SEGMENT_ATTRIBUTE35_LOW,SEGMENT_ATTRIBUTE35_HIGH'||
 ',SEGMENT_ATTRIBUTE35_TYPE,SEGMENT_ATTRIBUTE36_LOW,SEGMENT_ATTRIBUTE36_HIGH'||
 ',SEGMENT_ATTRIBUTE36_TYPE,SEGMENT_ATTRIBUTE37_LOW,SEGMENT_ATTRIBUTE37_HIGH'||
 ',SEGMENT_ATTRIBUTE37_TYPE,SEGMENT_ATTRIBUTE38_LOW,SEGMENT_ATTRIBUTE38_HIGH'||
 ',SEGMENT_ATTRIBUTE38_TYPE,SEGMENT_ATTRIBUTE39_LOW,SEGMENT_ATTRIBUTE39_HIGH'||
 ',SEGMENT_ATTRIBUTE39_TYPE,SEGMENT_ATTRIBUTE40_LOW,SEGMENT_ATTRIBUTE40_HIGH'||
 ',SEGMENT_ATTRIBUTE40_TYPE,SEGMENT_ATTRIBUTE41_LOW,SEGMENT_ATTRIBUTE41_HIGH'||
 ',SEGMENT_ATTRIBUTE41_TYPE,SEGMENT_ATTRIBUTE42_LOW,SEGMENT_ATTRIBUTE42_HIGH'||
 ',SEGMENT_ATTRIBUTE42_TYPE '||
 'FROM RG_REPORT_CONTENT_OVERRIDES@';

Line: 223


 'INSERT INTO RG_REPORT_AXIS_CONTENTS (' ||
 '  APPLICATION_ID, AXIS_SET_ID, AXIS_SEQ' ||
 ', LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN' ||
 ', CREATION_DATE, CREATED_BY, RANGE_MODE, SIGN' ||
 ', DR_CR_NET_CODE, LEDGER_ID, LEDGER_SEGMENT_TYPE, ALC_LEDGER_CURRENCY' ||
 ', SEGMENT1_LOW, SEGMENT1_HIGH, SEGMENT1_TYPE' ||
 ', SEGMENT2_LOW, SEGMENT2_HIGH, SEGMENT2_TYPE' ||
 ', SEGMENT3_LOW, SEGMENT3_HIGH, SEGMENT3_TYPE' ||
 ', SEGMENT4_LOW, SEGMENT4_HIGH, SEGMENT4_TYPE' ||
 ', SEGMENT5_LOW, SEGMENT5_HIGH, SEGMENT5_TYPE' ||
 ', SEGMENT6_LOW, SEGMENT6_HIGH, SEGMENT6_TYPE' ||
 ', SEGMENT7_LOW, SEGMENT7_HIGH, SEGMENT7_TYPE' ||
 ', SEGMENT8_LOW, SEGMENT8_HIGH, SEGMENT8_TYPE' ||
 ', SEGMENT9_LOW, SEGMENT9_HIGH, SEGMENT9_TYPE' ||
 ', SEGMENT10_LOW, SEGMENT10_HIGH, SEGMENT10_TYPE' ||
 ', SEGMENT11_LOW, SEGMENT11_HIGH, SEGMENT11_TYPE' ||
 ', SEGMENT12_LOW, SEGMENT12_HIGH, SEGMENT12_TYPE' ||
 ', SEGMENT13_LOW, SEGMENT13_HIGH, SEGMENT13_TYPE' ||
 ', SEGMENT14_LOW, SEGMENT14_HIGH, SEGMENT14_TYPE' ||
 ', SEGMENT15_LOW, SEGMENT15_HIGH, SEGMENT15_TYPE' ||
 ', SEGMENT16_LOW, SEGMENT16_HIGH, SEGMENT16_TYPE' ||
 ', SEGMENT17_LOW, SEGMENT17_HIGH, SEGMENT17_TYPE' ||
 ', SEGMENT18_LOW, SEGMENT18_HIGH, SEGMENT18_TYPE' ||
 ', SEGMENT19_LOW, SEGMENT19_HIGH, SEGMENT19_TYPE' ||
 ', SEGMENT20_LOW, SEGMENT20_HIGH, SEGMENT20_TYPE' ||
 ', SEGMENT21_LOW, SEGMENT21_HIGH, SEGMENT21_TYPE' ||
 ', SEGMENT22_LOW, SEGMENT22_HIGH, SEGMENT22_TYPE' ||
 ', SEGMENT23_LOW, SEGMENT23_HIGH, SEGMENT23_TYPE' ||
 ', SEGMENT24_LOW, SEGMENT24_HIGH, SEGMENT24_TYPE' ||
 ', SEGMENT25_LOW, SEGMENT25_HIGH, SEGMENT25_TYPE' ||
 ', SEGMENT26_LOW, SEGMENT26_HIGH, SEGMENT26_TYPE' ||
 ', SEGMENT27_LOW, SEGMENT27_HIGH, SEGMENT27_TYPE' ||
 ', SEGMENT28_LOW, SEGMENT28_HIGH, SEGMENT28_TYPE' ||
 ', SEGMENT29_LOW, SEGMENT29_HIGH, SEGMENT29_TYPE' ||
 ', SEGMENT30_LOW, SEGMENT30_HIGH, SEGMENT30_TYPE' ||
 ', CONTEXT, ATTRIBUTE1, ATTRIBUTE2' ||
 ', ATTRIBUTE3, ATTRIBUTE4, ATTRIBUTE5' ||
 ', ATTRIBUTE6, ATTRIBUTE7, ATTRIBUTE8' ||
 ', ATTRIBUTE9, ATTRIBUTE10, ATTRIBUTE11' ||
 ', ATTRIBUTE12, ATTRIBUTE13, ATTRIBUTE14' ||
 ', ATTRIBUTE15, SEGMENT_ATTRIBUTE1_LOW, SEGMENT_ATTRIBUTE1_HIGH' ||
 ',SEGMENT_ATTRIBUTE1_TYPE,SEGMENT_ATTRIBUTE2_LOW,SEGMENT_ATTRIBUTE2_HIGH'||
 ',SEGMENT_ATTRIBUTE2_TYPE,SEGMENT_ATTRIBUTE3_LOW,SEGMENT_ATTRIBUTE3_HIGH'||
 ',SEGMENT_ATTRIBUTE3_TYPE,SEGMENT_ATTRIBUTE4_LOW,SEGMENT_ATTRIBUTE4_HIGH'||
 ',SEGMENT_ATTRIBUTE4_TYPE,SEGMENT_ATTRIBUTE5_LOW,SEGMENT_ATTRIBUTE5_HIGH'||
 ',SEGMENT_ATTRIBUTE5_TYPE,SEGMENT_ATTRIBUTE6_LOW,SEGMENT_ATTRIBUTE6_HIGH'||
 ',SEGMENT_ATTRIBUTE6_TYPE,SEGMENT_ATTRIBUTE7_LOW,SEGMENT_ATTRIBUTE7_HIGH'||
 ',SEGMENT_ATTRIBUTE7_TYPE,SEGMENT_ATTRIBUTE8_LOW,SEGMENT_ATTRIBUTE8_HIGH'||
 ',SEGMENT_ATTRIBUTE8_TYPE,SEGMENT_ATTRIBUTE9_LOW,SEGMENT_ATTRIBUTE9_HIGH'||
 ',SEGMENT_ATTRIBUTE9_TYPE,SEGMENT_ATTRIBUTE10_LOW,SEGMENT_ATTRIBUTE10_HIGH'||
 ',SEGMENT_ATTRIBUTE10_TYPE,SEGMENT_ATTRIBUTE11_LOW,SEGMENT_ATTRIBUTE11_HIGH'||
 ',SEGMENT_ATTRIBUTE11_TYPE,SEGMENT_ATTRIBUTE12_LOW,SEGMENT_ATTRIBUTE12_HIGH'||
 ',SEGMENT_ATTRIBUTE12_TYPE,SEGMENT_ATTRIBUTE13_LOW,SEGMENT_ATTRIBUTE13_HIGH'||
 ',SEGMENT_ATTRIBUTE13_TYPE,SEGMENT_ATTRIBUTE14_LOW,SEGMENT_ATTRIBUTE14_HIGH'||
 ',SEGMENT_ATTRIBUTE14_TYPE,SEGMENT_ATTRIBUTE15_LOW,SEGMENT_ATTRIBUTE15_HIGH'||
 ',SEGMENT_ATTRIBUTE15_TYPE,SEGMENT_ATTRIBUTE16_LOW,SEGMENT_ATTRIBUTE16_HIGH'||
 ',SEGMENT_ATTRIBUTE16_TYPE,SEGMENT_ATTRIBUTE17_LOW,SEGMENT_ATTRIBUTE17_HIGH'||
 ',SEGMENT_ATTRIBUTE17_TYPE,SEGMENT_ATTRIBUTE18_LOW,SEGMENT_ATTRIBUTE18_HIGH'||
 ',SEGMENT_ATTRIBUTE18_TYPE,SEGMENT_ATTRIBUTE19_LOW,SEGMENT_ATTRIBUTE19_HIGH'||
 ',SEGMENT_ATTRIBUTE19_TYPE,SEGMENT_ATTRIBUTE20_LOW,SEGMENT_ATTRIBUTE20_HIGH'||
 ',SEGMENT_ATTRIBUTE20_TYPE,SEGMENT_ATTRIBUTE21_LOW,SEGMENT_ATTRIBUTE21_HIGH'||
 ',SEGMENT_ATTRIBUTE21_TYPE,SEGMENT_ATTRIBUTE22_LOW,SEGMENT_ATTRIBUTE22_HIGH'||
 ',SEGMENT_ATTRIBUTE22_TYPE,SEGMENT_ATTRIBUTE23_LOW,SEGMENT_ATTRIBUTE23_HIGH'||
 ',SEGMENT_ATTRIBUTE23_TYPE,SEGMENT_ATTRIBUTE24_LOW,SEGMENT_ATTRIBUTE24_HIGH'||
 ',SEGMENT_ATTRIBUTE24_TYPE,SEGMENT_ATTRIBUTE25_LOW,SEGMENT_ATTRIBUTE25_HIGH'||
 ',SEGMENT_ATTRIBUTE25_TYPE,SEGMENT_ATTRIBUTE26_LOW,SEGMENT_ATTRIBUTE26_HIGH'||
 ',SEGMENT_ATTRIBUTE26_TYPE,SEGMENT_ATTRIBUTE27_LOW,SEGMENT_ATTRIBUTE27_HIGH'||
 ',SEGMENT_ATTRIBUTE27_TYPE,SEGMENT_ATTRIBUTE28_LOW,SEGMENT_ATTRIBUTE28_HIGH'||
 ',SEGMENT_ATTRIBUTE28_TYPE,SEGMENT_ATTRIBUTE29_LOW,SEGMENT_ATTRIBUTE29_HIGH'||
 ',SEGMENT_ATTRIBUTE29_TYPE,SEGMENT_ATTRIBUTE30_LOW,SEGMENT_ATTRIBUTE30_HIGH'||
 ',SEGMENT_ATTRIBUTE30_TYPE,SEGMENT_ATTRIBUTE31_LOW,SEGMENT_ATTRIBUTE31_HIGH'||
 ',SEGMENT_ATTRIBUTE31_TYPE,SEGMENT_ATTRIBUTE32_LOW,SEGMENT_ATTRIBUTE32_HIGH'||
 ',SEGMENT_ATTRIBUTE32_TYPE,SEGMENT_ATTRIBUTE33_LOW,SEGMENT_ATTRIBUTE33_HIGH'||
 ',SEGMENT_ATTRIBUTE33_TYPE,SEGMENT_ATTRIBUTE34_LOW,SEGMENT_ATTRIBUTE34_HIGH'||
 ',SEGMENT_ATTRIBUTE34_TYPE,SEGMENT_ATTRIBUTE35_LOW,SEGMENT_ATTRIBUTE35_HIGH'||
 ',SEGMENT_ATTRIBUTE35_TYPE,SEGMENT_ATTRIBUTE36_LOW,SEGMENT_ATTRIBUTE36_HIGH'||
 ',SEGMENT_ATTRIBUTE36_TYPE,SEGMENT_ATTRIBUTE37_LOW,SEGMENT_ATTRIBUTE37_HIGH'||
 ',SEGMENT_ATTRIBUTE37_TYPE,SEGMENT_ATTRIBUTE38_LOW,SEGMENT_ATTRIBUTE38_HIGH'||
 ',SEGMENT_ATTRIBUTE38_TYPE,SEGMENT_ATTRIBUTE39_LOW,SEGMENT_ATTRIBUTE39_HIGH'||
 ',SEGMENT_ATTRIBUTE39_TYPE,SEGMENT_ATTRIBUTE40_LOW,SEGMENT_ATTRIBUTE40_HIGH'||
 ',SEGMENT_ATTRIBUTE40_TYPE,SEGMENT_ATTRIBUTE41_LOW,SEGMENT_ATTRIBUTE41_HIGH'||
 ',SEGMENT_ATTRIBUTE41_TYPE,SEGMENT_ATTRIBUTE42_LOW,SEGMENT_ATTRIBUTE42_HIGH'||
 ',SEGMENT_ATTRIBUTE42_TYPE ' ||
 ') SELECT' ||
 '  APPLICATION_ID, :id, AXIS_SEQ' ||
 ', sysdate, :user_id, :login_id' ||
 ', sysdate, :user_id, RANGE_MODE, SIGN' ||
 ', DR_CR_NET_CODE, :ledger_id, LEDGER_SEGMENT_TYPE, :alc_ledger_currency' ||
 ', SEGMENT1_LOW, SEGMENT1_HIGH, SEGMENT1_TYPE' ||
 ', SEGMENT2_LOW, SEGMENT2_HIGH, SEGMENT2_TYPE' ||
 ', SEGMENT3_LOW, SEGMENT3_HIGH, SEGMENT3_TYPE' ||
 ', SEGMENT4_LOW, SEGMENT4_HIGH, SEGMENT4_TYPE' ||
 ', SEGMENT5_LOW, SEGMENT5_HIGH, SEGMENT5_TYPE' ||
 ', SEGMENT6_LOW, SEGMENT6_HIGH, SEGMENT6_TYPE' ||
 ', SEGMENT7_LOW, SEGMENT7_HIGH, SEGMENT7_TYPE' ||
 ', SEGMENT8_LOW, SEGMENT8_HIGH, SEGMENT8_TYPE' ||
 ', SEGMENT9_LOW, SEGMENT9_HIGH, SEGMENT9_TYPE' ||
 ', SEGMENT10_LOW, SEGMENT10_HIGH, SEGMENT10_TYPE' ||
 ', SEGMENT11_LOW, SEGMENT11_HIGH, SEGMENT11_TYPE' ||
 ', SEGMENT12_LOW, SEGMENT12_HIGH, SEGMENT12_TYPE' ||
 ', SEGMENT13_LOW, SEGMENT13_HIGH, SEGMENT13_TYPE' ||
 ', SEGMENT14_LOW, SEGMENT14_HIGH, SEGMENT14_TYPE' ||
 ', SEGMENT15_LOW, SEGMENT15_HIGH, SEGMENT15_TYPE' ||
 ', SEGMENT16_LOW, SEGMENT16_HIGH, SEGMENT16_TYPE' ||
 ', SEGMENT17_LOW, SEGMENT17_HIGH, SEGMENT17_TYPE' ||
 ', SEGMENT18_LOW, SEGMENT18_HIGH, SEGMENT18_TYPE' ||
 ', SEGMENT19_LOW, SEGMENT19_HIGH, SEGMENT19_TYPE' ||
 ', SEGMENT20_LOW, SEGMENT20_HIGH, SEGMENT20_TYPE' ||
 ', SEGMENT21_LOW, SEGMENT21_HIGH, SEGMENT21_TYPE' ||
 ', SEGMENT22_LOW, SEGMENT22_HIGH, SEGMENT22_TYPE' ||
 ', SEGMENT23_LOW, SEGMENT23_HIGH, SEGMENT23_TYPE' ||
 ', SEGMENT24_LOW, SEGMENT24_HIGH, SEGMENT24_TYPE' ||
 ', SEGMENT25_LOW, SEGMENT25_HIGH, SEGMENT25_TYPE' ||
 ', SEGMENT26_LOW, SEGMENT26_HIGH, SEGMENT26_TYPE' ||
 ', SEGMENT27_LOW, SEGMENT27_HIGH, SEGMENT27_TYPE' ||
 ', SEGMENT28_LOW, SEGMENT28_HIGH, SEGMENT28_TYPE' ||
 ', SEGMENT29_LOW, SEGMENT29_HIGH, SEGMENT29_TYPE' ||
 ', SEGMENT30_LOW, SEGMENT30_HIGH, SEGMENT30_TYPE' ||
 ', CONTEXT, ATTRIBUTE1, ATTRIBUTE2' ||
 ', ATTRIBUTE3, ATTRIBUTE4, ATTRIBUTE5' ||
 ', ATTRIBUTE6, ATTRIBUTE7, ATTRIBUTE8' ||
 ', ATTRIBUTE9, ATTRIBUTE10, ATTRIBUTE11' ||
 ', ATTRIBUTE12, ATTRIBUTE13, ATTRIBUTE14' ||
 ', ATTRIBUTE15, SEGMENT_ATTRIBUTE1_LOW, SEGMENT_ATTRIBUTE1_HIGH' ||
 ',SEGMENT_ATTRIBUTE1_TYPE,SEGMENT_ATTRIBUTE2_LOW,SEGMENT_ATTRIBUTE2_HIGH'||
 ',SEGMENT_ATTRIBUTE2_TYPE,SEGMENT_ATTRIBUTE3_LOW,SEGMENT_ATTRIBUTE3_HIGH'||
 ',SEGMENT_ATTRIBUTE3_TYPE,SEGMENT_ATTRIBUTE4_LOW,SEGMENT_ATTRIBUTE4_HIGH'||
 ',SEGMENT_ATTRIBUTE4_TYPE,SEGMENT_ATTRIBUTE5_LOW,SEGMENT_ATTRIBUTE5_HIGH'||
 ',SEGMENT_ATTRIBUTE5_TYPE,SEGMENT_ATTRIBUTE6_LOW,SEGMENT_ATTRIBUTE6_HIGH'||
 ',SEGMENT_ATTRIBUTE6_TYPE,SEGMENT_ATTRIBUTE7_LOW,SEGMENT_ATTRIBUTE7_HIGH'||
 ',SEGMENT_ATTRIBUTE7_TYPE,SEGMENT_ATTRIBUTE8_LOW,SEGMENT_ATTRIBUTE8_HIGH'||
 ',SEGMENT_ATTRIBUTE8_TYPE,SEGMENT_ATTRIBUTE9_LOW,SEGMENT_ATTRIBUTE9_HIGH'||
 ',SEGMENT_ATTRIBUTE9_TYPE,SEGMENT_ATTRIBUTE10_LOW,SEGMENT_ATTRIBUTE10_HIGH'||
 ',SEGMENT_ATTRIBUTE10_TYPE,SEGMENT_ATTRIBUTE11_LOW,SEGMENT_ATTRIBUTE11_HIGH'||
 ',SEGMENT_ATTRIBUTE11_TYPE,SEGMENT_ATTRIBUTE12_LOW,SEGMENT_ATTRIBUTE12_HIGH'||
 ',SEGMENT_ATTRIBUTE12_TYPE,SEGMENT_ATTRIBUTE13_LOW,SEGMENT_ATTRIBUTE13_HIGH'||
 ',SEGMENT_ATTRIBUTE13_TYPE,SEGMENT_ATTRIBUTE14_LOW,SEGMENT_ATTRIBUTE14_HIGH'||
 ',SEGMENT_ATTRIBUTE14_TYPE,SEGMENT_ATTRIBUTE15_LOW,SEGMENT_ATTRIBUTE15_HIGH'||
 ',SEGMENT_ATTRIBUTE15_TYPE,SEGMENT_ATTRIBUTE16_LOW,SEGMENT_ATTRIBUTE16_HIGH'||
 ',SEGMENT_ATTRIBUTE16_TYPE,SEGMENT_ATTRIBUTE17_LOW,SEGMENT_ATTRIBUTE17_HIGH'||
 ',SEGMENT_ATTRIBUTE17_TYPE,SEGMENT_ATTRIBUTE18_LOW,SEGMENT_ATTRIBUTE18_HIGH'||
 ',SEGMENT_ATTRIBUTE18_TYPE,SEGMENT_ATTRIBUTE19_LOW,SEGMENT_ATTRIBUTE19_HIGH'||
 ',SEGMENT_ATTRIBUTE19_TYPE,SEGMENT_ATTRIBUTE20_LOW,SEGMENT_ATTRIBUTE20_HIGH'||
 ',SEGMENT_ATTRIBUTE20_TYPE,SEGMENT_ATTRIBUTE21_LOW,SEGMENT_ATTRIBUTE21_HIGH'||
 ',SEGMENT_ATTRIBUTE21_TYPE,SEGMENT_ATTRIBUTE22_LOW,SEGMENT_ATTRIBUTE22_HIGH'||
 ',SEGMENT_ATTRIBUTE22_TYPE,SEGMENT_ATTRIBUTE23_LOW,SEGMENT_ATTRIBUTE23_HIGH'||
 ',SEGMENT_ATTRIBUTE23_TYPE,SEGMENT_ATTRIBUTE24_LOW,SEGMENT_ATTRIBUTE24_HIGH'||
 ',SEGMENT_ATTRIBUTE24_TYPE,SEGMENT_ATTRIBUTE25_LOW,SEGMENT_ATTRIBUTE25_HIGH'||
 ',SEGMENT_ATTRIBUTE25_TYPE,SEGMENT_ATTRIBUTE26_LOW,SEGMENT_ATTRIBUTE26_HIGH'||
 ',SEGMENT_ATTRIBUTE26_TYPE,SEGMENT_ATTRIBUTE27_LOW,SEGMENT_ATTRIBUTE27_HIGH'||
 ',SEGMENT_ATTRIBUTE27_TYPE,SEGMENT_ATTRIBUTE28_LOW,SEGMENT_ATTRIBUTE28_HIGH'||
 ',SEGMENT_ATTRIBUTE28_TYPE,SEGMENT_ATTRIBUTE29_LOW,SEGMENT_ATTRIBUTE29_HIGH'||
 ',SEGMENT_ATTRIBUTE29_TYPE,SEGMENT_ATTRIBUTE30_LOW,SEGMENT_ATTRIBUTE30_HIGH'||
 ',SEGMENT_ATTRIBUTE30_TYPE,SEGMENT_ATTRIBUTE31_LOW,SEGMENT_ATTRIBUTE31_HIGH'||
 ',SEGMENT_ATTRIBUTE31_TYPE,SEGMENT_ATTRIBUTE32_LOW,SEGMENT_ATTRIBUTE32_HIGH'||
 ',SEGMENT_ATTRIBUTE32_TYPE,SEGMENT_ATTRIBUTE33_LOW,SEGMENT_ATTRIBUTE33_HIGH'||
 ',SEGMENT_ATTRIBUTE33_TYPE,SEGMENT_ATTRIBUTE34_LOW,SEGMENT_ATTRIBUTE34_HIGH'||
 ',SEGMENT_ATTRIBUTE34_TYPE,SEGMENT_ATTRIBUTE35_LOW,SEGMENT_ATTRIBUTE35_HIGH'||
 ',SEGMENT_ATTRIBUTE35_TYPE,SEGMENT_ATTRIBUTE36_LOW,SEGMENT_ATTRIBUTE36_HIGH'||
 ',SEGMENT_ATTRIBUTE36_TYPE,SEGMENT_ATTRIBUTE37_LOW,SEGMENT_ATTRIBUTE37_HIGH'||
 ',SEGMENT_ATTRIBUTE37_TYPE,SEGMENT_ATTRIBUTE38_LOW,SEGMENT_ATTRIBUTE38_HIGH'||
 ',SEGMENT_ATTRIBUTE38_TYPE,SEGMENT_ATTRIBUTE39_LOW,SEGMENT_ATTRIBUTE39_HIGH'||
 ',SEGMENT_ATTRIBUTE39_TYPE,SEGMENT_ATTRIBUTE40_LOW,SEGMENT_ATTRIBUTE40_HIGH'||
 ',SEGMENT_ATTRIBUTE40_TYPE,SEGMENT_ATTRIBUTE41_LOW,SEGMENT_ATTRIBUTE41_HIGH'||
 ',SEGMENT_ATTRIBUTE41_TYPE,SEGMENT_ATTRIBUTE42_LOW,SEGMENT_ATTRIBUTE42_HIGH'||
 ',SEGMENT_ATTRIBUTE42_TYPE ' ||
 'FROM RG_REPORT_AXIS_CONTENTS@';

Line: 392


    'INSERT INTO RG_REPORT_CALCULATIONS (' ||
    '  APPLICATION_ID, AXIS_SET_ID, AXIS_SEQ, CALCULATION_SEQ' ||
    ', LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN, CREATION_DATE' ||
    ', CREATED_BY, OPERATOR, AXIS_SEQ_LOW, AXIS_SEQ_HIGH ' ||
    ', AXIS_NAME_LOW, AXIS_NAME_HIGH, CONSTANT, CONTEXT  ' ||
    ', ATTRIBUTE1 , ATTRIBUTE2 , ATTRIBUTE3 , ATTRIBUTE4 ' ||
    ', ATTRIBUTE5 , ATTRIBUTE6 , ATTRIBUTE7 , ATTRIBUTE8 ' ||
    ', ATTRIBUTE9 , ATTRIBUTE10, ATTRIBUTE11, ATTRIBUTE12' ||
    ', ATTRIBUTE13, ATTRIBUTE14, ATTRIBUTE15' ||
    ') SELECT' ||
    '  APPLICATION_ID, :id     , AXIS_SEQ  , CALCULATION_SEQ' ||
    ', sysdate    , :user_id   , :login_id , sysdate    ' ||
    ', :user_id   , OPERATOR   , AXIS_SEQ_LOW, AXIS_SEQ_HIGH ' ||
    ', AXIS_NAME_LOW, AXIS_NAME_HIGH, CONSTANT, CONTEXT  ' ||
    ', ATTRIBUTE1 , ATTRIBUTE2 , ATTRIBUTE3 , ATTRIBUTE4 ' ||
    ', ATTRIBUTE5 , ATTRIBUTE6 , ATTRIBUTE7 , ATTRIBUTE8 ' ||
    ', ATTRIBUTE9 , ATTRIBUTE10, ATTRIBUTE11, ATTRIBUTE12' ||
    ', ATTRIBUTE13, ATTRIBUTE14, ATTRIBUTE15 ' ||
    'FROM RG_REPORT_CALCULATIONS@';

Line: 413


    'INSERT INTO RG_REPORT_EXCEPTIONS (' ||
    '  APPLICATION_ID, AXIS_SET_ID, AXIS_SEQ, EXCEPTION_ID' ||
    ', LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN, CREATION_DATE' ||
    ', CREATED_BY , CONDITION  , CONSTANT   , CONTEXT' ||
    ', ATTRIBUTE1 , ATTRIBUTE2 , ATTRIBUTE3 , ATTRIBUTE4' ||
    ', ATTRIBUTE5 , ATTRIBUTE6 , ATTRIBUTE7 , ATTRIBUTE8' ||
    ', ATTRIBUTE9 , ATTRIBUTE10, ATTRIBUTE11, ATTRIBUTE12' ||
    ', ATTRIBUTE13, ATTRIBUTE14, ATTRIBUTE15' ||
    ') SELECT' ||
    '  APPLICATION_ID, :id     , AXIS_SEQ   , :exception_id' ||
    ', sysdate    , :user_id   , :login_id  , sysdate' ||
    ', :user_id   , CONDITION  , CONSTANT   , CONTEXT' ||
    ', ATTRIBUTE1 , ATTRIBUTE2 , ATTRIBUTE3 , ATTRIBUTE4' ||
    ', ATTRIBUTE5 , ATTRIBUTE6 , ATTRIBUTE7 , ATTRIBUTE8' ||
    ', ATTRIBUTE9 , ATTRIBUTE10, ATTRIBUTE11, ATTRIBUTE12' ||
    ', ATTRIBUTE13, ATTRIBUTE14, ATTRIBUTE15 ' ||
    'FROM RG_REPORT_EXCEPTIONS@';

Line: 432


    'INSERT INTO RG_REPORT_EXCEPTION_FLAGS (' ||
    '  APPLICATION_ID, AXIS_SET_ID, AXIS_SEQ, EXCEPTION_ID' ||
    ', LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN, CREATION_DATE' ||
    ', CREATED_BY , FLAG       , DESCRIPTION, CONTEXT    ' ||
    ', ATTRIBUTE1 , ATTRIBUTE2 , ATTRIBUTE3 , ATTRIBUTE4 ' ||
    ', ATTRIBUTE5 , ATTRIBUTE6 , ATTRIBUTE7 , ATTRIBUTE8 ' ||
    ', ATTRIBUTE9 , ATTRIBUTE10, ATTRIBUTE11, ATTRIBUTE12' ||
    ', ATTRIBUTE13, ATTRIBUTE14, ATTRIBUTE15' ||
    ') SELECT' ||
    '  APPLICATION_ID, :id     , AXIS_SEQ   , :exception_id' ||
    ', sysdate    , :user_id   , :login_id  , sysdate    ' ||
    ', :user_id   , FLAG       , DESCRIPTION, CONTEXT    ' ||
    ', ATTRIBUTE1 , ATTRIBUTE2 , ATTRIBUTE3 , ATTRIBUTE4 ' ||
    ', ATTRIBUTE5 , ATTRIBUTE6 , ATTRIBUTE7 , ATTRIBUTE8 ' ||
    ', ATTRIBUTE9 , ATTRIBUTE10, ATTRIBUTE11, ATTRIBUTE12' ||
    ', ATTRIBUTE13, ATTRIBUTE14, ATTRIBUTE15 ' ||
    'FROM RG_REPORT_EXCEPTION_FLAGS@';

Line: 512


                 'SELECT rowid, ledger_id, alc_ledger_currency' ||
                 ' FROM rg_report_axis_contents@' || G_LinkName ||
                 ' WHERE axis_seq = ' || TO_CHAR(SourceAxisSeq) ||
                 ' AND   axis_set_id = ' || TO_CHAR(SourceAxisSetId),
                 DBMS_SQL.v7);

Line: 522


    /* For each record, check the ledger info and insert the record. */
    IF (DBMS_SQL.fetch_rows(CursorId) > 0) THEN
      DBMS_SQL.column_value_rowid(CursorId, 1, RecRowId);

Line: 559


      /* Insert the row */
      SQLString := AxisContentsString ||G_LinkName|| ' WHERE rowid = :row_id';

Line: 569


      RG_XFER_UTILS_PKG.insert_rows(
        SQLString,
        TargetAxisSetId,
        UseCOAId=> FALSE,
        UseRowId=> TRUE,
        RecRowId=> RecRowId);

Line: 636


                     'SELECT segment_name FROM rg_report_axis_sets@' ||
                      G_LinkName || ' WHERE axis_set_id = ' ||
                      TO_CHAR(SourceAxisSetId), 30);

Line: 642


                 'SELECT axis_seq, segment_override_value,' ||
                 ' override_alc_ledger_currency FROM rg_report_axes@' ||
                   G_LinkName || ' WHERE axis_set_id =' ||
                   TO_CHAR(SourceAxisSetId),
                 DBMS_SQL.v7);

Line: 686


                        'SELECT unit_of_measure_id FROM rg_report_axes@'||
                          G_LinkName || ' WHERE axis_set_id = ' ||
                          TO_CHAR(SourceAxisSetId) ||
                          ' AND axis_seq = ' || TO_CHAR(AxisSeq),
                        15);

Line: 746


      RG_XFER_UTILS_PKG.insert_rows(
        SQLString, TargetAxisSetId, UseCOAId=> FALSE);

Line: 758


      RG_XFER_UTILS_PKG.insert_rows(
        CalculationsString || G_LinkName ||
          ' WHERE axis_set_id = ' || TO_CHAR(SourceAxisSetId) ||
          ' AND   axis_seq = ' || TO_CHAR(AxisSeq),
        TargetAxisSetId, UseCOAId=>FALSE);

Line: 775


        RG_XFER_UTILS_PKG.insert_rows(
          SQLString, TargetAxisSetId, UseCOAId=>FALSE);

Line: 781


          'SELECT exception_id FROM rg_report_exception_flags@' || G_LinkName||
            ' WHERE axis_set_id = ' || TO_CHAR(SourceAxisSetId) ||
            ' AND axis_seq = ' || TO_CHAR(AxisSeq),
          DBMS_SQL.v7);

Line: 795


          RG_XFER_UTILS_PKG.insert_rows(
            SQLString,
            TargetAxisSetId,
            UseCOAId=>FALSE);

Line: 833


  SQLString    VARCHAR2(200) := 'UPDATE rg_report_axis_sets ' ||
                                'SET column_set_header = :header ' ||
                                'WHERE axis_set_id = :id';

Line: 850


                 'SELECT to_char(column_set_header) FROM rg_report_axis_sets@' ||
                   G_LinkName || ' WHERE axis_set_id = ' ||
                   TO_CHAR(SourceColumnSetId),
                 DBMS_SQL.v7);

Line: 907


  /* Insert the detail records for the specified content set. */
  CursorId := DBMS_SQL.open_cursor;

Line: 910


                 'SELECT rowid, ledger_id, alc_ledger_currency' ||
                 ' FROM rg_report_content_overrides@' || G_LinkName ||
                 ' WHERE content_set_id = ' || TO_CHAR(SourceContentSetId),
                 DBMS_SQL.v7);

Line: 919


    /* For each record, check the ledger info and insert the record. */
    IF (DBMS_SQL.fetch_rows(CursorId) > 0) THEN
      DBMS_SQL.column_value_rowid(CursorId, 1, RecRowId);

Line: 948


      /* Insert the row */
      SQLString := ContentOverridesString || G_LinkName||
                   ' WHERE rowid = :row_id';

Line: 959


      RG_XFER_UTILS_PKG.insert_rows(
        SQLString,
        TargetContentSetId,
        UseCOAId=> FALSE,
        UseRowId=> TRUE,
        RecRowId=> RecRowId);

Line: 1004


  SQLString := 'SELECT a.element_id, e.element_identifier, e.taxonomy_id ' ||
               'FROM rg_report_axes@'||
               G_LinkName || ' a, rg_xbrl_elements@' || G_LinkName || ' e' ||
               ' WHERE a.axis_set_id = ' || TO_CHAR(SourceAxisSetId) ||
               ' AND a.axis_seq = ' || TO_CHAR(AxisSeq) ||
               ' AND a.element_id = e.element_id';

Line: 1035


    SQLString := 'SELECT ref_table.taxonomy_alias '||
                 'FROM '||
                 ' RG_XBRL_TAXONOMIES' || '@'|| G_LinkName || ' ref_table ' ||
                 'WHERE ref_table.taxonomy_id ' || '= '|| TO_CHAR(SourceTaxId);

Line: 1056


    SQLString := 'SELECT taxonomy_id ' ||
               'FROM   rg_xbrl_taxonomies ' ||
               'WHERE  taxonomy_alias = ' || ValueString;

Line: 1064


    SQLString := 'SELECT element_id ' ||
                 ' FROM rg_xbrl_elements ' ||
                 ' WHERE  taxonomy_id = ' || TO_CHAR(TaxTargetId) ||
                 ' AND element_identifier ' || '=' || ValueString;