DBA Data[Home] [Help]

APPS.AP_WEB_POLICY_UTILS dependencies on AP_POL_SCHEDULE_PERIODS

Line 686: p_from_schedule_period_id IN ap_pol_schedule_periods.schedule_period_id%TYPE,

682: |
683: *=======================================================================*/
684: PROCEDURE duplicatePolicyLines(p_user_id IN NUMBER,
685: p_from_policy_id IN ap_pol_headers.policy_id%TYPE,
686: p_from_schedule_period_id IN ap_pol_schedule_periods.schedule_period_id%TYPE,
687: p_to_policy_id IN ap_pol_headers.policy_id%TYPE,
688: p_to_schedule_period_id IN ap_pol_schedule_periods.schedule_period_id%TYPE);
689:
690: /*========================================================================

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

684: PROCEDURE duplicatePolicyLines(p_user_id IN NUMBER,
685: p_from_policy_id IN ap_pol_headers.policy_id%TYPE,
686: p_from_schedule_period_id IN ap_pol_schedule_periods.schedule_period_id%TYPE,
687: p_to_policy_id IN ap_pol_headers.policy_id%TYPE,
688: p_to_schedule_period_id IN ap_pol_schedule_periods.schedule_period_id%TYPE);
689:
690: /*========================================================================
691: | PUBLIC PROCEDURE preservePolicyLine
692: |

Line 770: p_policy_id IN ap_pol_schedule_periods.policy_id%TYPE,

766: | 16-May-2002 R Langi Created
767: |
768: *=======================================================================*/
769: FUNCTION createSchedulePeriod(p_user_id IN NUMBER,
770: p_policy_id IN ap_pol_schedule_periods.policy_id%TYPE,
771: p_schedule_period_name IN ap_pol_schedule_periods.schedule_period_name%TYPE,
772: p_start_date IN ap_pol_schedule_periods.start_date%TYPE,
773: p_end_date IN ap_pol_schedule_periods.end_date%TYPE DEFAULT NULL,
774: p_rate_per_passenger IN ap_pol_schedule_periods.rate_per_passenger%TYPE,

Line 771: p_schedule_period_name IN ap_pol_schedule_periods.schedule_period_name%TYPE,

767: |
768: *=======================================================================*/
769: FUNCTION createSchedulePeriod(p_user_id IN NUMBER,
770: p_policy_id IN ap_pol_schedule_periods.policy_id%TYPE,
771: p_schedule_period_name IN ap_pol_schedule_periods.schedule_period_name%TYPE,
772: p_start_date IN ap_pol_schedule_periods.start_date%TYPE,
773: p_end_date IN ap_pol_schedule_periods.end_date%TYPE DEFAULT NULL,
774: p_rate_per_passenger IN ap_pol_schedule_periods.rate_per_passenger%TYPE,
775: p_min_days IN ap_pol_schedule_periods.min_days%TYPE,

Line 772: p_start_date IN ap_pol_schedule_periods.start_date%TYPE,

768: *=======================================================================*/
769: FUNCTION createSchedulePeriod(p_user_id IN NUMBER,
770: p_policy_id IN ap_pol_schedule_periods.policy_id%TYPE,
771: p_schedule_period_name IN ap_pol_schedule_periods.schedule_period_name%TYPE,
772: p_start_date IN ap_pol_schedule_periods.start_date%TYPE,
773: p_end_date IN ap_pol_schedule_periods.end_date%TYPE DEFAULT NULL,
774: p_rate_per_passenger IN ap_pol_schedule_periods.rate_per_passenger%TYPE,
775: p_min_days IN ap_pol_schedule_periods.min_days%TYPE,
776: p_tolerance IN ap_pol_schedule_periods.tolerance%TYPE,

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

769: FUNCTION createSchedulePeriod(p_user_id IN NUMBER,
770: p_policy_id IN ap_pol_schedule_periods.policy_id%TYPE,
771: p_schedule_period_name IN ap_pol_schedule_periods.schedule_period_name%TYPE,
772: p_start_date IN ap_pol_schedule_periods.start_date%TYPE,
773: p_end_date IN ap_pol_schedule_periods.end_date%TYPE DEFAULT NULL,
774: p_rate_per_passenger IN ap_pol_schedule_periods.rate_per_passenger%TYPE,
775: p_min_days IN ap_pol_schedule_periods.min_days%TYPE,
776: p_tolerance IN ap_pol_schedule_periods.tolerance%TYPE,
777: p_min_rate_per_period IN ap_pol_schedule_periods.min_rate_per_period%TYPE,

Line 774: p_rate_per_passenger IN ap_pol_schedule_periods.rate_per_passenger%TYPE,

770: p_policy_id IN ap_pol_schedule_periods.policy_id%TYPE,
771: p_schedule_period_name IN ap_pol_schedule_periods.schedule_period_name%TYPE,
772: p_start_date IN ap_pol_schedule_periods.start_date%TYPE,
773: p_end_date IN ap_pol_schedule_periods.end_date%TYPE DEFAULT NULL,
774: p_rate_per_passenger IN ap_pol_schedule_periods.rate_per_passenger%TYPE,
775: p_min_days IN ap_pol_schedule_periods.min_days%TYPE,
776: p_tolerance IN ap_pol_schedule_periods.tolerance%TYPE,
777: p_min_rate_per_period IN ap_pol_schedule_periods.min_rate_per_period%TYPE,
778: p_max_breakfast_deduction IN ap_pol_schedule_periods.max_breakfast_deduction_amt%TYPE,

Line 775: p_min_days IN ap_pol_schedule_periods.min_days%TYPE,

771: p_schedule_period_name IN ap_pol_schedule_periods.schedule_period_name%TYPE,
772: p_start_date IN ap_pol_schedule_periods.start_date%TYPE,
773: p_end_date IN ap_pol_schedule_periods.end_date%TYPE DEFAULT NULL,
774: p_rate_per_passenger IN ap_pol_schedule_periods.rate_per_passenger%TYPE,
775: p_min_days IN ap_pol_schedule_periods.min_days%TYPE,
776: p_tolerance IN ap_pol_schedule_periods.tolerance%TYPE,
777: p_min_rate_per_period IN ap_pol_schedule_periods.min_rate_per_period%TYPE,
778: p_max_breakfast_deduction IN ap_pol_schedule_periods.max_breakfast_deduction_amt%TYPE,
779: p_max_lunch_deduction IN ap_pol_schedule_periods.max_lunch_deduction_amt%TYPE,

Line 776: p_tolerance IN ap_pol_schedule_periods.tolerance%TYPE,

772: p_start_date IN ap_pol_schedule_periods.start_date%TYPE,
773: p_end_date IN ap_pol_schedule_periods.end_date%TYPE DEFAULT NULL,
774: p_rate_per_passenger IN ap_pol_schedule_periods.rate_per_passenger%TYPE,
775: p_min_days IN ap_pol_schedule_periods.min_days%TYPE,
776: p_tolerance IN ap_pol_schedule_periods.tolerance%TYPE,
777: p_min_rate_per_period IN ap_pol_schedule_periods.min_rate_per_period%TYPE,
778: p_max_breakfast_deduction IN ap_pol_schedule_periods.max_breakfast_deduction_amt%TYPE,
779: p_max_lunch_deduction IN ap_pol_schedule_periods.max_lunch_deduction_amt%TYPE,
780: p_max_dinner_deduction IN ap_pol_schedule_periods.max_dinner_deduction_amt%TYPE,

Line 777: p_min_rate_per_period IN ap_pol_schedule_periods.min_rate_per_period%TYPE,

773: p_end_date IN ap_pol_schedule_periods.end_date%TYPE DEFAULT NULL,
774: p_rate_per_passenger IN ap_pol_schedule_periods.rate_per_passenger%TYPE,
775: p_min_days IN ap_pol_schedule_periods.min_days%TYPE,
776: p_tolerance IN ap_pol_schedule_periods.tolerance%TYPE,
777: p_min_rate_per_period IN ap_pol_schedule_periods.min_rate_per_period%TYPE,
778: p_max_breakfast_deduction IN ap_pol_schedule_periods.max_breakfast_deduction_amt%TYPE,
779: p_max_lunch_deduction IN ap_pol_schedule_periods.max_lunch_deduction_amt%TYPE,
780: p_max_dinner_deduction IN ap_pol_schedule_periods.max_dinner_deduction_amt%TYPE,
781: p_first_day_rate IN ap_pol_schedule_periods.first_day_rate%TYPE,

Line 778: p_max_breakfast_deduction IN ap_pol_schedule_periods.max_breakfast_deduction_amt%TYPE,

774: p_rate_per_passenger IN ap_pol_schedule_periods.rate_per_passenger%TYPE,
775: p_min_days IN ap_pol_schedule_periods.min_days%TYPE,
776: p_tolerance IN ap_pol_schedule_periods.tolerance%TYPE,
777: p_min_rate_per_period IN ap_pol_schedule_periods.min_rate_per_period%TYPE,
778: p_max_breakfast_deduction IN ap_pol_schedule_periods.max_breakfast_deduction_amt%TYPE,
779: p_max_lunch_deduction IN ap_pol_schedule_periods.max_lunch_deduction_amt%TYPE,
780: p_max_dinner_deduction IN ap_pol_schedule_periods.max_dinner_deduction_amt%TYPE,
781: p_first_day_rate IN ap_pol_schedule_periods.first_day_rate%TYPE,
782: p_last_day_rate IN ap_pol_schedule_periods.last_day_rate%TYPE,

Line 779: p_max_lunch_deduction IN ap_pol_schedule_periods.max_lunch_deduction_amt%TYPE,

775: p_min_days IN ap_pol_schedule_periods.min_days%TYPE,
776: p_tolerance IN ap_pol_schedule_periods.tolerance%TYPE,
777: p_min_rate_per_period IN ap_pol_schedule_periods.min_rate_per_period%TYPE,
778: p_max_breakfast_deduction IN ap_pol_schedule_periods.max_breakfast_deduction_amt%TYPE,
779: p_max_lunch_deduction IN ap_pol_schedule_periods.max_lunch_deduction_amt%TYPE,
780: p_max_dinner_deduction IN ap_pol_schedule_periods.max_dinner_deduction_amt%TYPE,
781: p_first_day_rate IN ap_pol_schedule_periods.first_day_rate%TYPE,
782: p_last_day_rate IN ap_pol_schedule_periods.last_day_rate%TYPE,
783: p_reimbursement_percentage In ap_pol_schedule_periods.reimbursement_percentage%TYPE) RETURN ap_pol_schedule_periods.schedule_period_id%TYPE;

Line 780: p_max_dinner_deduction IN ap_pol_schedule_periods.max_dinner_deduction_amt%TYPE,

776: p_tolerance IN ap_pol_schedule_periods.tolerance%TYPE,
777: p_min_rate_per_period IN ap_pol_schedule_periods.min_rate_per_period%TYPE,
778: p_max_breakfast_deduction IN ap_pol_schedule_periods.max_breakfast_deduction_amt%TYPE,
779: p_max_lunch_deduction IN ap_pol_schedule_periods.max_lunch_deduction_amt%TYPE,
780: p_max_dinner_deduction IN ap_pol_schedule_periods.max_dinner_deduction_amt%TYPE,
781: p_first_day_rate IN ap_pol_schedule_periods.first_day_rate%TYPE,
782: p_last_day_rate IN ap_pol_schedule_periods.last_day_rate%TYPE,
783: p_reimbursement_percentage In ap_pol_schedule_periods.reimbursement_percentage%TYPE) RETURN ap_pol_schedule_periods.schedule_period_id%TYPE;
784:

Line 781: p_first_day_rate IN ap_pol_schedule_periods.first_day_rate%TYPE,

777: p_min_rate_per_period IN ap_pol_schedule_periods.min_rate_per_period%TYPE,
778: p_max_breakfast_deduction IN ap_pol_schedule_periods.max_breakfast_deduction_amt%TYPE,
779: p_max_lunch_deduction IN ap_pol_schedule_periods.max_lunch_deduction_amt%TYPE,
780: p_max_dinner_deduction IN ap_pol_schedule_periods.max_dinner_deduction_amt%TYPE,
781: p_first_day_rate IN ap_pol_schedule_periods.first_day_rate%TYPE,
782: p_last_day_rate IN ap_pol_schedule_periods.last_day_rate%TYPE,
783: p_reimbursement_percentage In ap_pol_schedule_periods.reimbursement_percentage%TYPE) RETURN ap_pol_schedule_periods.schedule_period_id%TYPE;
784:
785: /*========================================================================

Line 782: p_last_day_rate IN ap_pol_schedule_periods.last_day_rate%TYPE,

778: p_max_breakfast_deduction IN ap_pol_schedule_periods.max_breakfast_deduction_amt%TYPE,
779: p_max_lunch_deduction IN ap_pol_schedule_periods.max_lunch_deduction_amt%TYPE,
780: p_max_dinner_deduction IN ap_pol_schedule_periods.max_dinner_deduction_amt%TYPE,
781: p_first_day_rate IN ap_pol_schedule_periods.first_day_rate%TYPE,
782: p_last_day_rate IN ap_pol_schedule_periods.last_day_rate%TYPE,
783: p_reimbursement_percentage In ap_pol_schedule_periods.reimbursement_percentage%TYPE) RETURN ap_pol_schedule_periods.schedule_period_id%TYPE;
784:
785: /*========================================================================
786: | PUBLIC FUNCTION massUpdateValue

Line 783: p_reimbursement_percentage In ap_pol_schedule_periods.reimbursement_percentage%TYPE) RETURN ap_pol_schedule_periods.schedule_period_id%TYPE;

779: p_max_lunch_deduction IN ap_pol_schedule_periods.max_lunch_deduction_amt%TYPE,
780: p_max_dinner_deduction IN ap_pol_schedule_periods.max_dinner_deduction_amt%TYPE,
781: p_first_day_rate IN ap_pol_schedule_periods.first_day_rate%TYPE,
782: p_last_day_rate IN ap_pol_schedule_periods.last_day_rate%TYPE,
783: p_reimbursement_percentage In ap_pol_schedule_periods.reimbursement_percentage%TYPE) RETURN ap_pol_schedule_periods.schedule_period_id%TYPE;
784:
785: /*========================================================================
786: | PUBLIC FUNCTION massUpdateValue
787: |