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.

APPS.AP_WEB_POLICY_UTILS dependencies on AP_POL_SCHEDULE_PERIODS

Line 670: p_from_schedule_period_id IN ap_pol_schedule_periods.schedule_period_id%TYPE,

666: |
667: *=======================================================================*/
668: PROCEDURE duplicatePolicyLines(p_user_id IN NUMBER,
669: p_from_policy_id IN ap_pol_headers.policy_id%TYPE,
670: p_from_schedule_period_id IN ap_pol_schedule_periods.schedule_period_id%TYPE,
671: p_to_policy_id IN ap_pol_headers.policy_id%TYPE,
672: p_to_schedule_period_id IN ap_pol_schedule_periods.schedule_period_id%TYPE);
673:
674: /*========================================================================

Line 672: p_to_schedule_period_id IN ap_pol_schedule_periods.schedule_period_id%TYPE);

668: PROCEDURE duplicatePolicyLines(p_user_id IN NUMBER,
669: p_from_policy_id IN ap_pol_headers.policy_id%TYPE,
670: p_from_schedule_period_id IN ap_pol_schedule_periods.schedule_period_id%TYPE,
671: p_to_policy_id IN ap_pol_headers.policy_id%TYPE,
672: p_to_schedule_period_id IN ap_pol_schedule_periods.schedule_period_id%TYPE);
673:
674: /*========================================================================
675: | PUBLIC PROCEDURE preservePolicyLine
676: |

Line 754: p_policy_id IN ap_pol_schedule_periods.policy_id%TYPE,

750: | 16-May-2002 R Langi Created
751: |
752: *=======================================================================*/
753: FUNCTION createSchedulePeriod(p_user_id IN NUMBER,
754: p_policy_id IN ap_pol_schedule_periods.policy_id%TYPE,
755: p_schedule_period_name IN ap_pol_schedule_periods.schedule_period_name%TYPE,
756: p_start_date IN ap_pol_schedule_periods.start_date%TYPE,
757: p_end_date IN ap_pol_schedule_periods.end_date%TYPE DEFAULT NULL,
758: p_rate_per_passenger IN ap_pol_schedule_periods.rate_per_passenger%TYPE,

Line 755: p_schedule_period_name IN ap_pol_schedule_periods.schedule_period_name%TYPE,

751: |
752: *=======================================================================*/
753: FUNCTION createSchedulePeriod(p_user_id IN NUMBER,
754: p_policy_id IN ap_pol_schedule_periods.policy_id%TYPE,
755: p_schedule_period_name IN ap_pol_schedule_periods.schedule_period_name%TYPE,
756: p_start_date IN ap_pol_schedule_periods.start_date%TYPE,
757: p_end_date IN ap_pol_schedule_periods.end_date%TYPE DEFAULT NULL,
758: p_rate_per_passenger IN ap_pol_schedule_periods.rate_per_passenger%TYPE,
759: p_min_days IN ap_pol_schedule_periods.min_days%TYPE,

Line 756: p_start_date IN ap_pol_schedule_periods.start_date%TYPE,

752: *=======================================================================*/
753: FUNCTION createSchedulePeriod(p_user_id IN NUMBER,
754: p_policy_id IN ap_pol_schedule_periods.policy_id%TYPE,
755: p_schedule_period_name IN ap_pol_schedule_periods.schedule_period_name%TYPE,
756: p_start_date IN ap_pol_schedule_periods.start_date%TYPE,
757: p_end_date IN ap_pol_schedule_periods.end_date%TYPE DEFAULT NULL,
758: p_rate_per_passenger IN ap_pol_schedule_periods.rate_per_passenger%TYPE,
759: p_min_days IN ap_pol_schedule_periods.min_days%TYPE,
760: p_tolerance IN ap_pol_schedule_periods.tolerance%TYPE,

Line 757: p_end_date IN ap_pol_schedule_periods.end_date%TYPE DEFAULT NULL,

753: FUNCTION createSchedulePeriod(p_user_id IN NUMBER,
754: p_policy_id IN ap_pol_schedule_periods.policy_id%TYPE,
755: p_schedule_period_name IN ap_pol_schedule_periods.schedule_period_name%TYPE,
756: p_start_date IN ap_pol_schedule_periods.start_date%TYPE,
757: p_end_date IN ap_pol_schedule_periods.end_date%TYPE DEFAULT NULL,
758: p_rate_per_passenger IN ap_pol_schedule_periods.rate_per_passenger%TYPE,
759: p_min_days IN ap_pol_schedule_periods.min_days%TYPE,
760: p_tolerance IN ap_pol_schedule_periods.tolerance%TYPE,
761: p_min_rate_per_period IN ap_pol_schedule_periods.min_rate_per_period%TYPE,

Line 758: p_rate_per_passenger IN ap_pol_schedule_periods.rate_per_passenger%TYPE,

754: p_policy_id IN ap_pol_schedule_periods.policy_id%TYPE,
755: p_schedule_period_name IN ap_pol_schedule_periods.schedule_period_name%TYPE,
756: p_start_date IN ap_pol_schedule_periods.start_date%TYPE,
757: p_end_date IN ap_pol_schedule_periods.end_date%TYPE DEFAULT NULL,
758: p_rate_per_passenger IN ap_pol_schedule_periods.rate_per_passenger%TYPE,
759: p_min_days IN ap_pol_schedule_periods.min_days%TYPE,
760: p_tolerance IN ap_pol_schedule_periods.tolerance%TYPE,
761: p_min_rate_per_period IN ap_pol_schedule_periods.min_rate_per_period%TYPE,
762: p_max_breakfast_deduction IN ap_pol_schedule_periods.max_breakfast_deduction_amt%TYPE,

Line 759: p_min_days IN ap_pol_schedule_periods.min_days%TYPE,

755: p_schedule_period_name IN ap_pol_schedule_periods.schedule_period_name%TYPE,
756: p_start_date IN ap_pol_schedule_periods.start_date%TYPE,
757: p_end_date IN ap_pol_schedule_periods.end_date%TYPE DEFAULT NULL,
758: p_rate_per_passenger IN ap_pol_schedule_periods.rate_per_passenger%TYPE,
759: p_min_days IN ap_pol_schedule_periods.min_days%TYPE,
760: p_tolerance IN ap_pol_schedule_periods.tolerance%TYPE,
761: p_min_rate_per_period IN ap_pol_schedule_periods.min_rate_per_period%TYPE,
762: p_max_breakfast_deduction IN ap_pol_schedule_periods.max_breakfast_deduction_amt%TYPE,
763: p_max_lunch_deduction IN ap_pol_schedule_periods.max_lunch_deduction_amt%TYPE,

Line 760: p_tolerance IN ap_pol_schedule_periods.tolerance%TYPE,

756: p_start_date IN ap_pol_schedule_periods.start_date%TYPE,
757: p_end_date IN ap_pol_schedule_periods.end_date%TYPE DEFAULT NULL,
758: p_rate_per_passenger IN ap_pol_schedule_periods.rate_per_passenger%TYPE,
759: p_min_days IN ap_pol_schedule_periods.min_days%TYPE,
760: p_tolerance IN ap_pol_schedule_periods.tolerance%TYPE,
761: p_min_rate_per_period IN ap_pol_schedule_periods.min_rate_per_period%TYPE,
762: p_max_breakfast_deduction IN ap_pol_schedule_periods.max_breakfast_deduction_amt%TYPE,
763: p_max_lunch_deduction IN ap_pol_schedule_periods.max_lunch_deduction_amt%TYPE,
764: p_max_dinner_deduction IN ap_pol_schedule_periods.max_dinner_deduction_amt%TYPE,

Line 761: p_min_rate_per_period IN ap_pol_schedule_periods.min_rate_per_period%TYPE,

757: p_end_date IN ap_pol_schedule_periods.end_date%TYPE DEFAULT NULL,
758: p_rate_per_passenger IN ap_pol_schedule_periods.rate_per_passenger%TYPE,
759: p_min_days IN ap_pol_schedule_periods.min_days%TYPE,
760: p_tolerance IN ap_pol_schedule_periods.tolerance%TYPE,
761: p_min_rate_per_period IN ap_pol_schedule_periods.min_rate_per_period%TYPE,
762: p_max_breakfast_deduction IN ap_pol_schedule_periods.max_breakfast_deduction_amt%TYPE,
763: p_max_lunch_deduction IN ap_pol_schedule_periods.max_lunch_deduction_amt%TYPE,
764: p_max_dinner_deduction IN ap_pol_schedule_periods.max_dinner_deduction_amt%TYPE,
765: p_first_day_rate IN ap_pol_schedule_periods.first_day_rate%TYPE,

Line 762: p_max_breakfast_deduction IN ap_pol_schedule_periods.max_breakfast_deduction_amt%TYPE,

758: p_rate_per_passenger IN ap_pol_schedule_periods.rate_per_passenger%TYPE,
759: p_min_days IN ap_pol_schedule_periods.min_days%TYPE,
760: p_tolerance IN ap_pol_schedule_periods.tolerance%TYPE,
761: p_min_rate_per_period IN ap_pol_schedule_periods.min_rate_per_period%TYPE,
762: p_max_breakfast_deduction IN ap_pol_schedule_periods.max_breakfast_deduction_amt%TYPE,
763: p_max_lunch_deduction IN ap_pol_schedule_periods.max_lunch_deduction_amt%TYPE,
764: p_max_dinner_deduction IN ap_pol_schedule_periods.max_dinner_deduction_amt%TYPE,
765: p_first_day_rate IN ap_pol_schedule_periods.first_day_rate%TYPE,
766: p_last_day_rate IN ap_pol_schedule_periods.last_day_rate%TYPE) RETURN ap_pol_schedule_periods.schedule_period_id%TYPE;

Line 763: p_max_lunch_deduction IN ap_pol_schedule_periods.max_lunch_deduction_amt%TYPE,

759: p_min_days IN ap_pol_schedule_periods.min_days%TYPE,
760: p_tolerance IN ap_pol_schedule_periods.tolerance%TYPE,
761: p_min_rate_per_period IN ap_pol_schedule_periods.min_rate_per_period%TYPE,
762: p_max_breakfast_deduction IN ap_pol_schedule_periods.max_breakfast_deduction_amt%TYPE,
763: p_max_lunch_deduction IN ap_pol_schedule_periods.max_lunch_deduction_amt%TYPE,
764: p_max_dinner_deduction IN ap_pol_schedule_periods.max_dinner_deduction_amt%TYPE,
765: p_first_day_rate IN ap_pol_schedule_periods.first_day_rate%TYPE,
766: p_last_day_rate IN ap_pol_schedule_periods.last_day_rate%TYPE) RETURN ap_pol_schedule_periods.schedule_period_id%TYPE;
767:

Line 764: p_max_dinner_deduction IN ap_pol_schedule_periods.max_dinner_deduction_amt%TYPE,

760: p_tolerance IN ap_pol_schedule_periods.tolerance%TYPE,
761: p_min_rate_per_period IN ap_pol_schedule_periods.min_rate_per_period%TYPE,
762: p_max_breakfast_deduction IN ap_pol_schedule_periods.max_breakfast_deduction_amt%TYPE,
763: p_max_lunch_deduction IN ap_pol_schedule_periods.max_lunch_deduction_amt%TYPE,
764: p_max_dinner_deduction IN ap_pol_schedule_periods.max_dinner_deduction_amt%TYPE,
765: p_first_day_rate IN ap_pol_schedule_periods.first_day_rate%TYPE,
766: p_last_day_rate IN ap_pol_schedule_periods.last_day_rate%TYPE) RETURN ap_pol_schedule_periods.schedule_period_id%TYPE;
767:
768: /*========================================================================

Line 765: p_first_day_rate IN ap_pol_schedule_periods.first_day_rate%TYPE,

761: p_min_rate_per_period IN ap_pol_schedule_periods.min_rate_per_period%TYPE,
762: p_max_breakfast_deduction IN ap_pol_schedule_periods.max_breakfast_deduction_amt%TYPE,
763: p_max_lunch_deduction IN ap_pol_schedule_periods.max_lunch_deduction_amt%TYPE,
764: p_max_dinner_deduction IN ap_pol_schedule_periods.max_dinner_deduction_amt%TYPE,
765: p_first_day_rate IN ap_pol_schedule_periods.first_day_rate%TYPE,
766: p_last_day_rate IN ap_pol_schedule_periods.last_day_rate%TYPE) RETURN ap_pol_schedule_periods.schedule_period_id%TYPE;
767:
768: /*========================================================================
769: | PUBLIC FUNCTION massUpdateValue

Line 766: p_last_day_rate IN ap_pol_schedule_periods.last_day_rate%TYPE) RETURN ap_pol_schedule_periods.schedule_period_id%TYPE;

762: p_max_breakfast_deduction IN ap_pol_schedule_periods.max_breakfast_deduction_amt%TYPE,
763: p_max_lunch_deduction IN ap_pol_schedule_periods.max_lunch_deduction_amt%TYPE,
764: p_max_dinner_deduction IN ap_pol_schedule_periods.max_dinner_deduction_amt%TYPE,
765: p_first_day_rate IN ap_pol_schedule_periods.first_day_rate%TYPE,
766: p_last_day_rate IN ap_pol_schedule_periods.last_day_rate%TYPE) RETURN ap_pol_schedule_periods.schedule_period_id%TYPE;
767:
768: /*========================================================================
769: | PUBLIC FUNCTION massUpdateValue
770: |