APPS.AP_WEB_OA_DISC_PKG dependencies on AP_EXPENSE_REPORT_PARAMS

Line 1170: Function AreMPDRateSchedulesAssigned (p_parameter_id IN ap_expense_report_params.parameter_id%TYPE)

1166: Assumption:
1167: Date:
1168: 12-Jul-2002
1169: */
1170: Function AreMPDRateSchedulesAssigned (p_parameter_id IN ap_expense_report_params.parameter_id%TYPE)
1171: RETURN boolean IS
1172:
1173: v_numRows NUMBER := 0;
1174: BEGIN

Line 1182: FROM ap_expense_report_params expTypes

1178: INTO v_numRows
1179: FROM dual
1180: WHERE exists
1181: (SELECT 1
1182: FROM ap_expense_report_params expTypes
1183: WHERE expTypes.company_policy_id IS NOT NULL
1184: AND expTypes.category_code in ('MILEAGE', 'PER_DIEM')
1185: AND trunc(sysdate) <= trunc(NVL(expTypes.end_date, sysdate))
1186: AND expTypes.parameter_id = p_parameter_id);

Line 1217: Function ArePCRateSchedulesAssigned (p_parameter_id IN ap_expense_report_params.parameter_id%TYPE)

1213: Assumption:
1214: Date:
1215: 12-Jul-2002
1216: */
1217: Function ArePCRateSchedulesAssigned (p_parameter_id IN ap_expense_report_params.parameter_id%TYPE)
1218: RETURN boolean IS
1219:
1220: v_numRows NUMBER := 0;
1221: BEGIN

Line 1229: FROM ap_expense_report_params expTypes

1225: INTO v_numRows
1226: FROM dual
1227: WHERE EXISTS
1228: (SELECT 1
1229: FROM ap_expense_report_params expTypes
1230: WHERE expTypes.company_policy_id IS NOT NULL
1231: AND expTypes.category_code in ('ACCOMMODATIONS', 'AIRFARE', 'CAR_RENTAL', 'MEALS')
1232: AND trunc(sysdate) <= trunc(NVL(expTypes.end_date, sysdate))
1233: AND expTypes.parameter_id = p_parameter_id);

Line 1263: Function CheckExpenseFields (p_parameter_id IN ap_expense_report_params.parameter_id%TYPE, p_reqd_enabled IN VARCHAR2)

1259: Assumption:
1260: Date:
1261: 12-Jul-2002
1262: */
1263: Function CheckExpenseFields (p_parameter_id IN ap_expense_report_params.parameter_id%TYPE, p_reqd_enabled IN VARCHAR2)
1264: RETURN boolean IS
1265:
1266: v_numRows NUMBER := 0;
1267: BEGIN

Line 1275: FROM ap_expense_report_params expTypes,

1271: INTO v_numRows
1272: FROM dual
1273: WHERE EXISTS
1274: (SELECT 1
1275: FROM ap_expense_report_params expTypes,
1276: ap_pol_cat_options catOptions
1277: WHERE
1278: ((catOptions.category_code = 'ACCOMMODATIONS'
1279: AND (END_DATE_FIELD = p_reqd_enabled

Line 1318: Function AreExpenseFieldsRequired (p_parameter_id IN ap_expense_report_params.parameter_id%TYPE)

1314: WHEN OTHERS THEN
1315: raise;
1316: END CheckExpenseFields;
1317:
1318: Function AreExpenseFieldsRequired (p_parameter_id IN ap_expense_report_params.parameter_id%TYPE)
1319: RETURN boolean IS
1320:
1321: BEGIN
1322: return CheckExpenseFields(p_parameter_id, C_REQUIRED);

Line 1325: Function AreExpenseFieldsEnabled (p_parameter_id IN ap_expense_report_params.parameter_id%TYPE)

1321: BEGIN
1322: return CheckExpenseFields(p_parameter_id, C_REQUIRED);
1323: END AreExpenseFieldsRequired;
1324:
1325: Function AreExpenseFieldsEnabled (p_parameter_id IN ap_expense_report_params.parameter_id%TYPE)
1326: RETURN boolean IS
1327:
1328: BEGIN
1329: return CheckExpenseFields(p_parameter_id, C_ENABLED);

Line 1348: Function IsItemizationRequired (p_parameter_id IN ap_expense_report_params.parameter_id%TYPE)

1344: Assumption:
1345: Date:
1346: 12-Jul-2002
1347: */
1348: Function IsItemizationRequired (p_parameter_id IN ap_expense_report_params.parameter_id%TYPE)
1349: RETURN boolean IS
1350:
1351: v_numRows NUMBER := 0;
1352: BEGIN

Line 1359: FROM ap_expense_report_params expTypes

1355: INTO v_numRows
1356: FROM dual
1357: WHERE EXISTS
1358: (SELECT 1
1359: FROM ap_expense_report_params expTypes
1360: WHERE expTypes.itemization_required_flag = C_Yes
1361: AND trunc(sysdate) <= trunc(NVL(expTypes.end_date, sysdate))
1362: AND expTypes.parameter_id = p_parameter_id);
1363:

Line 1556: l_receipt_required_amount AP_EXPENSE_REPORT_PARAMS.require_receipt_amount%TYPE;

1552:
1553: l_MPD_present BOOLEAN := false; -- Keeps track whether the report contains Mileage / Per Diem header exceptions
1554: l_foreign_currency_present BOOLEAN := false; -- Keeps track whether foreign currencies exist.
1555: l_reimbursement_currency_code AP_WEB_DFLEX_PKG.expLines_currCode;
1556: l_receipt_required_amount AP_EXPENSE_REPORT_PARAMS.require_receipt_amount%TYPE;
1557: l_base_currency_code AP_WEB_DB_AP_INT_PKG.apSetUp_baseCurrencyCode;
1558:
1559: BEGIN
1560: AP_WEB_UTILITIES_PKG.logProcedure('AP_WEB_OA_DISC_PKG', 'start CheckForPerDiemMileagePolicy');