APPS.AP_WEB_DB_EXPLINE_PKG dependencies on OIE_ADDON_MILEAGE_RATES

Line 2175: l_temp OIE_ADDON_MILEAGE_RATES.ADDON_RATE_TYPE%type;

2171:
2172: -----------------------------------------------------------------------------
2173: PROCEDURE DeleteAddonRates(P_ReportID IN NUMBER) IS
2174: --------------------------------------------------------------------------------
2175: l_temp OIE_ADDON_MILEAGE_RATES.ADDON_RATE_TYPE%type;
2176:
2177: -- Selects report lines to delete. The actual value being selected does not
2178: -- matter. For some reason the compiler complains when the OF column-name
2179: -- in the FOR UPDATE is missing and NOWAIT is used, so the OF

Line 2183: FROM OIE_ADDON_MILEAGE_RATES addon, AP_EXPENSE_REPORT_LINES el

2179: -- in the FOR UPDATE is missing and NOWAIT is used, so the OF
2180: -- EMPLOYEE_FLAG is used as a place holder.
2181: CURSOR addonRates IS
2182: SELECT ADDON_RATE_TYPE
2183: FROM OIE_ADDON_MILEAGE_RATES addon, AP_EXPENSE_REPORT_LINES el
2184: WHERE (el.REPORT_HEADER_ID = P_ReportID AND
2185: el.REPORT_LINE_ID = addon.REPORT_LINE_ID)
2186: FOR UPDATE OF ADDON_RATE_TYPE NOWAIT;
2187:

Line 2199: DELETE OIE_ADDON_MILEAGE_RATES WHERE CURRENT OF addonRates;

2195: FETCH addonRates into l_temp;
2196: EXIT WHEN addonRates%NOTFOUND;
2197:
2198: -- Delete matching line
2199: DELETE OIE_ADDON_MILEAGE_RATES WHERE CURRENT OF addonRates;
2200: END LOOP;
2201:
2202: CLOSE addonRates;
2203:

Line 3180: INSERT INTO OIE_ADDON_MILEAGE_RATES(REPORT_LINE_ID,

3176: ---------------------------------------------------------------
3177: x_report_line_id := l_report_line_id;
3178:
3179: -- copy additional mileage rate
3180: INSERT INTO OIE_ADDON_MILEAGE_RATES(REPORT_LINE_ID,
3181: ADDON_RATE_TYPE,
3182: MILEAGE_RATE,
3183: MILEAGE_AMOUNT,
3184: LAST_UPDATE_DATE,

Line 3198: FROM OIE_ADDON_MILEAGE_RATES

3194: LAST_UPDATED_BY,
3195: LAST_UPDATE_LOGIN,
3196: CREATED_BY,
3197: SYSDATE
3198: FROM OIE_ADDON_MILEAGE_RATES
3199: WHERE REPORT_LINE_ID = (SELECT REPORT_LINE_ID
3200: FROM AP_EXPENSE_REPORT_LINES
3201: WHERE REPORT_HEADER_ID = P_ORIG_EXPENSE_REPORT_ID
3202: AND DISTRIBUTION_LINE_NUMBER = P_ORIG_DIST_LINE_NUMBER

Line 3230: INSERT INTO OIE_ADDON_MILEAGE_RATES(REPORT_LINE_ID,

3226: WHERE REPORT_LINE_ID = P_FROM_REPORT_LINE_ID;
3227:
3228: IF (L_CATEGORY_CODE = 'MILEAGE') THEN
3229: -- COPY ADDITIONAL MILEAGE RATE
3230: INSERT INTO OIE_ADDON_MILEAGE_RATES(REPORT_LINE_ID,
3231: ADDON_RATE_TYPE,
3232: MILEAGE_RATE,
3233: MILEAGE_AMOUNT,
3234: LAST_UPDATE_DATE,

Line 3248: FROM OIE_ADDON_MILEAGE_RATES

3244: LAST_UPDATED_BY,
3245: LAST_UPDATE_LOGIN,
3246: CREATED_BY,
3247: SYSDATE
3248: FROM OIE_ADDON_MILEAGE_RATES
3249: WHERE REPORT_LINE_ID = P_FROM_REPORT_LINE_ID;
3250: END IF;
3251: EXCEPTION WHEN OTHERS THEN
3252: null;