APPS.AP_WEB_DB_EXPLINE_PKG dependencies on OIE_ADDON_MILEAGE_RATES

Line 2424: l_temp OIE_ADDON_MILEAGE_RATES.ADDON_RATE_TYPE%type;

2420:
2421: -----------------------------------------------------------------------------
2422: PROCEDURE DeleteAddonRates(P_ReportID IN NUMBER) IS
2423: --------------------------------------------------------------------------------
2424: l_temp OIE_ADDON_MILEAGE_RATES.ADDON_RATE_TYPE%type;
2425:
2426: -- Selects report lines to delete. The actual value being selected does not
2427: -- matter. For some reason the compiler complains when the OF column-name
2428: -- in the FOR UPDATE is missing and NOWAIT is used, so the OF

Line 2432: FROM OIE_ADDON_MILEAGE_RATES addon, AP_EXPENSE_REPORT_LINES el

2428: -- in the FOR UPDATE is missing and NOWAIT is used, so the OF
2429: -- EMPLOYEE_FLAG is used as a place holder.
2430: CURSOR addonRates IS
2431: SELECT ADDON_RATE_TYPE
2432: FROM OIE_ADDON_MILEAGE_RATES addon, AP_EXPENSE_REPORT_LINES el
2433: WHERE (el.REPORT_HEADER_ID = P_ReportID AND
2434: el.REPORT_LINE_ID = addon.REPORT_LINE_ID)
2435: FOR UPDATE OF ADDON_RATE_TYPE NOWAIT;
2436:

Line 2448: DELETE OIE_ADDON_MILEAGE_RATES WHERE CURRENT OF addonRates;

2444: FETCH addonRates into l_temp;
2445: EXIT WHEN addonRates%NOTFOUND;
2446:
2447: -- Delete matching line
2448: DELETE OIE_ADDON_MILEAGE_RATES WHERE CURRENT OF addonRates;
2449: END LOOP;
2450:
2451: CLOSE addonRates;
2452:

Line 3465: INSERT INTO OIE_ADDON_MILEAGE_RATES(REPORT_LINE_ID,

3461: ---------------------------------------------------------------
3462: x_report_line_id := l_report_line_id;
3463:
3464: -- copy additional mileage rate
3465: INSERT INTO OIE_ADDON_MILEAGE_RATES(REPORT_LINE_ID,
3466: ADDON_RATE_TYPE,
3467: MILEAGE_RATE,
3468: MILEAGE_AMOUNT,
3469: LAST_UPDATE_DATE,

Line 3483: FROM OIE_ADDON_MILEAGE_RATES

3479: LAST_UPDATED_BY,
3480: LAST_UPDATE_LOGIN,
3481: CREATED_BY,
3482: SYSDATE
3483: FROM OIE_ADDON_MILEAGE_RATES
3484: WHERE REPORT_LINE_ID = (SELECT REPORT_LINE_ID
3485: FROM AP_EXPENSE_REPORT_LINES
3486: WHERE REPORT_HEADER_ID = P_ORIG_EXPENSE_REPORT_ID
3487: AND DISTRIBUTION_LINE_NUMBER = P_ORIG_DIST_LINE_NUMBER

Line 3515: INSERT INTO OIE_ADDON_MILEAGE_RATES(REPORT_LINE_ID,

3511: WHERE REPORT_LINE_ID = P_FROM_REPORT_LINE_ID;
3512:
3513: IF (L_CATEGORY_CODE = 'MILEAGE') THEN
3514: -- COPY ADDITIONAL MILEAGE RATE
3515: INSERT INTO OIE_ADDON_MILEAGE_RATES(REPORT_LINE_ID,
3516: ADDON_RATE_TYPE,
3517: MILEAGE_RATE,
3518: MILEAGE_AMOUNT,
3519: LAST_UPDATE_DATE,

Line 3533: FROM OIE_ADDON_MILEAGE_RATES

3529: LAST_UPDATED_BY,
3530: LAST_UPDATE_LOGIN,
3531: CREATED_BY,
3532: SYSDATE
3533: FROM OIE_ADDON_MILEAGE_RATES
3534: WHERE REPORT_LINE_ID = P_FROM_REPORT_LINE_ID;
3535: END IF;
3536: EXCEPTION WHEN OTHERS THEN
3537: null;