APPS.AP_WEB_POLICY_UTILS dependencies on AP_POL_SCHEDULE_OPTIONS

Line 27: | List of possible AP_POL_SCHEDULE_OPTIONS.OPTION_TYPE

23: c_ACTIVE CONSTANT VARCHAR2(20) := 'ACTIVE';
24: c_INACTIVE CONSTANT VARCHAR2(20) := 'INACTIVE';
25: c_ARCHIVED CONSTANT VARCHAR2(20) := 'ARCHIVED';
26: /*=======================================================================+
27: | List of possible AP_POL_SCHEDULE_OPTIONS.OPTION_TYPE
28: +=======================================================================*/
29: c_LOCATION CONSTANT VARCHAR2(20) := 'LOCATION';
30: c_EMPLOYEE_ROLE CONSTANT VARCHAR2(20) := 'EMPLOYEE_ROLE';
31: c_CURRENCY CONSTANT VARCHAR2(20) := 'CURRENCY';

Line 42: | as a valid AP_POL_SCHEDULE_OPTIONS.OPTION_TYPE

38: c_NIGHT_RATES CONSTANT VARCHAR2(30) := 'OIE_NIGHT_RATES';
39: /*=======================================================================+
40: | c_THRESHOLD means (OPTION_TYPE = c_DISTANCE_THRESHOLD or OPTION_TYPE = c_TIME_THRESHOLD)
41: | c_THRESHOLD is used only in this package and is not stored in db
42: | as a valid AP_POL_SCHEDULE_OPTIONS.OPTION_TYPE
43: +=======================================================================*/
44: c_THRESHOLD CONSTANT VARCHAR2(20) := 'THRESHOLD';
45: /*=======================================================================+
46: | List of possible AP_POL_HEADERS.CURRENCY_PREFERENCE (OIE_POL_CUR_RULES)

Line 496: p_threshold IN ap_pol_schedule_options.threshold%TYPE) RETURN ap_pol_schedule_options.threshold%TYPE;

492: | 16-May-2002 R Langi Created
493: |
494: *=======================================================================*/
495: FUNCTION getHighEndOfThreshold(p_policy_id IN ap_pol_headers.policy_id%TYPE,
496: p_threshold IN ap_pol_schedule_options.threshold%TYPE) RETURN ap_pol_schedule_options.threshold%TYPE;
497:
498: /*========================================================================
499: | PUBLIC FUNCTION getHighEndOfThreshold
500: |

Line 518: p_threshold IN ap_pol_schedule_options.threshold%TYPE,

514: | 01-Nov-2005 krmenon Created
515: |
516: *=======================================================================*/
517: FUNCTION getHighEndOfThreshold(p_policy_id IN ap_pol_headers.policy_id%TYPE,
518: p_threshold IN ap_pol_schedule_options.threshold%TYPE,
519: p_rate_type IN ap_pol_schedule_options.rate_type_code%TYPE) RETURN ap_pol_schedule_options.threshold%TYPE;
520:
521: /*========================================================================
522: | PUBLIC FUNCTION getPolicyCategoryCode

Line 519: p_rate_type IN ap_pol_schedule_options.rate_type_code%TYPE) RETURN ap_pol_schedule_options.threshold%TYPE;

515: |
516: *=======================================================================*/
517: FUNCTION getHighEndOfThreshold(p_policy_id IN ap_pol_headers.policy_id%TYPE,
518: p_threshold IN ap_pol_schedule_options.threshold%TYPE,
519: p_rate_type IN ap_pol_schedule_options.rate_type_code%TYPE) RETURN ap_pol_schedule_options.threshold%TYPE;
520:
521: /*========================================================================
522: | PUBLIC FUNCTION getPolicyCategoryCode
523: |