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 1952: l_schedule_period_id ap_pol_schedule_periods.schedule_period_id%TYPE;

1948: *=======================================================================*/
1949: PROCEDURE permutatePolicyLines(p_user_id IN NUMBER,
1950: p_policy_id IN ap_pol_headers.policy_id%TYPE) IS
1951:
1952: l_schedule_period_id ap_pol_schedule_periods.schedule_period_id%TYPE;
1953: l_permutate_curref INTEGER;
1954: l_rows_permutated NUMBER := 0;
1955:
1956: l_policy_line_count NUMBER := 0;

Line 1992: from ap_pol_schedule_periods

1988: -- cursor for schedule periods
1989: ---------------------------------------
1990: cursor c_schedule_period_id is
1991: select schedule_period_id
1992: from ap_pol_schedule_periods
1993: where policy_id = p_policy_id;
1994:
1995: ---------------------------------------------------
1996: -- cursor for first last and same day rate periods

Line 3406: p_from_schedule_period_id IN ap_pol_schedule_periods.schedule_period_id%TYPE,

3402: |
3403: *=======================================================================*/
3404: PROCEDURE duplicatePolicyLines(p_user_id IN NUMBER,
3405: p_from_policy_id IN ap_pol_headers.policy_id%TYPE,
3406: p_from_schedule_period_id IN ap_pol_schedule_periods.schedule_period_id%TYPE,
3407: p_to_policy_id IN ap_pol_headers.policy_id%TYPE,
3408: p_to_schedule_period_id IN ap_pol_schedule_periods.schedule_period_id%TYPE) IS
3409:
3410: l_duplicate_curref INTEGER;

Line 3408: p_to_schedule_period_id IN ap_pol_schedule_periods.schedule_period_id%TYPE) IS

3404: PROCEDURE duplicatePolicyLines(p_user_id IN NUMBER,
3405: p_from_policy_id IN ap_pol_headers.policy_id%TYPE,
3406: p_from_schedule_period_id IN ap_pol_schedule_periods.schedule_period_id%TYPE,
3407: p_to_policy_id IN ap_pol_headers.policy_id%TYPE,
3408: p_to_schedule_period_id IN ap_pol_schedule_periods.schedule_period_id%TYPE) IS
3409:
3410: l_duplicate_curref INTEGER;
3411: l_rows_duplicated NUMBER := 0;
3412:

Line 3855: p_policy_id IN ap_pol_schedule_periods.policy_id%TYPE,

3851: | 16-May-2002 R Langi Created
3852: |
3853: *=======================================================================*/
3854: FUNCTION createSchedulePeriod(p_user_id IN NUMBER,
3855: p_policy_id IN ap_pol_schedule_periods.policy_id%TYPE,
3856: p_schedule_period_name IN ap_pol_schedule_periods.schedule_period_name%TYPE,
3857: p_start_date IN ap_pol_schedule_periods.start_date%TYPE,
3858: p_end_date IN ap_pol_schedule_periods.end_date%TYPE,
3859: p_rate_per_passenger IN ap_pol_schedule_periods.rate_per_passenger%TYPE,

Line 3856: p_schedule_period_name IN ap_pol_schedule_periods.schedule_period_name%TYPE,

3852: |
3853: *=======================================================================*/
3854: FUNCTION createSchedulePeriod(p_user_id IN NUMBER,
3855: p_policy_id IN ap_pol_schedule_periods.policy_id%TYPE,
3856: p_schedule_period_name IN ap_pol_schedule_periods.schedule_period_name%TYPE,
3857: p_start_date IN ap_pol_schedule_periods.start_date%TYPE,
3858: p_end_date IN ap_pol_schedule_periods.end_date%TYPE,
3859: p_rate_per_passenger IN ap_pol_schedule_periods.rate_per_passenger%TYPE,
3860: p_min_days IN ap_pol_schedule_periods.min_days%TYPE,

Line 3857: p_start_date IN ap_pol_schedule_periods.start_date%TYPE,

3853: *=======================================================================*/
3854: FUNCTION createSchedulePeriod(p_user_id IN NUMBER,
3855: p_policy_id IN ap_pol_schedule_periods.policy_id%TYPE,
3856: p_schedule_period_name IN ap_pol_schedule_periods.schedule_period_name%TYPE,
3857: p_start_date IN ap_pol_schedule_periods.start_date%TYPE,
3858: p_end_date IN ap_pol_schedule_periods.end_date%TYPE,
3859: p_rate_per_passenger IN ap_pol_schedule_periods.rate_per_passenger%TYPE,
3860: p_min_days IN ap_pol_schedule_periods.min_days%TYPE,
3861: p_tolerance IN ap_pol_schedule_periods.tolerance%TYPE,

Line 3858: p_end_date IN ap_pol_schedule_periods.end_date%TYPE,

3854: FUNCTION createSchedulePeriod(p_user_id IN NUMBER,
3855: p_policy_id IN ap_pol_schedule_periods.policy_id%TYPE,
3856: p_schedule_period_name IN ap_pol_schedule_periods.schedule_period_name%TYPE,
3857: p_start_date IN ap_pol_schedule_periods.start_date%TYPE,
3858: p_end_date IN ap_pol_schedule_periods.end_date%TYPE,
3859: p_rate_per_passenger IN ap_pol_schedule_periods.rate_per_passenger%TYPE,
3860: p_min_days IN ap_pol_schedule_periods.min_days%TYPE,
3861: p_tolerance IN ap_pol_schedule_periods.tolerance%TYPE,
3862: p_min_rate_per_period IN ap_pol_schedule_periods.min_rate_per_period%TYPE,

Line 3859: p_rate_per_passenger IN ap_pol_schedule_periods.rate_per_passenger%TYPE,

3855: p_policy_id IN ap_pol_schedule_periods.policy_id%TYPE,
3856: p_schedule_period_name IN ap_pol_schedule_periods.schedule_period_name%TYPE,
3857: p_start_date IN ap_pol_schedule_periods.start_date%TYPE,
3858: p_end_date IN ap_pol_schedule_periods.end_date%TYPE,
3859: p_rate_per_passenger IN ap_pol_schedule_periods.rate_per_passenger%TYPE,
3860: p_min_days IN ap_pol_schedule_periods.min_days%TYPE,
3861: p_tolerance IN ap_pol_schedule_periods.tolerance%TYPE,
3862: p_min_rate_per_period IN ap_pol_schedule_periods.min_rate_per_period%TYPE,
3863: p_max_breakfast_deduction IN ap_pol_schedule_periods.max_breakfast_deduction_amt%TYPE,

Line 3860: p_min_days IN ap_pol_schedule_periods.min_days%TYPE,

3856: p_schedule_period_name IN ap_pol_schedule_periods.schedule_period_name%TYPE,
3857: p_start_date IN ap_pol_schedule_periods.start_date%TYPE,
3858: p_end_date IN ap_pol_schedule_periods.end_date%TYPE,
3859: p_rate_per_passenger IN ap_pol_schedule_periods.rate_per_passenger%TYPE,
3860: p_min_days IN ap_pol_schedule_periods.min_days%TYPE,
3861: p_tolerance IN ap_pol_schedule_periods.tolerance%TYPE,
3862: p_min_rate_per_period IN ap_pol_schedule_periods.min_rate_per_period%TYPE,
3863: p_max_breakfast_deduction IN ap_pol_schedule_periods.max_breakfast_deduction_amt%TYPE,
3864: p_max_lunch_deduction IN ap_pol_schedule_periods.max_lunch_deduction_amt%TYPE,

Line 3861: p_tolerance IN ap_pol_schedule_periods.tolerance%TYPE,

3857: p_start_date IN ap_pol_schedule_periods.start_date%TYPE,
3858: p_end_date IN ap_pol_schedule_periods.end_date%TYPE,
3859: p_rate_per_passenger IN ap_pol_schedule_periods.rate_per_passenger%TYPE,
3860: p_min_days IN ap_pol_schedule_periods.min_days%TYPE,
3861: p_tolerance IN ap_pol_schedule_periods.tolerance%TYPE,
3862: p_min_rate_per_period IN ap_pol_schedule_periods.min_rate_per_period%TYPE,
3863: p_max_breakfast_deduction IN ap_pol_schedule_periods.max_breakfast_deduction_amt%TYPE,
3864: p_max_lunch_deduction IN ap_pol_schedule_periods.max_lunch_deduction_amt%TYPE,
3865: p_max_dinner_deduction IN ap_pol_schedule_periods.max_dinner_deduction_amt%TYPE,

Line 3862: p_min_rate_per_period IN ap_pol_schedule_periods.min_rate_per_period%TYPE,

3858: p_end_date IN ap_pol_schedule_periods.end_date%TYPE,
3859: p_rate_per_passenger IN ap_pol_schedule_periods.rate_per_passenger%TYPE,
3860: p_min_days IN ap_pol_schedule_periods.min_days%TYPE,
3861: p_tolerance IN ap_pol_schedule_periods.tolerance%TYPE,
3862: p_min_rate_per_period IN ap_pol_schedule_periods.min_rate_per_period%TYPE,
3863: p_max_breakfast_deduction IN ap_pol_schedule_periods.max_breakfast_deduction_amt%TYPE,
3864: p_max_lunch_deduction IN ap_pol_schedule_periods.max_lunch_deduction_amt%TYPE,
3865: p_max_dinner_deduction IN ap_pol_schedule_periods.max_dinner_deduction_amt%TYPE,
3866: p_first_day_rate IN ap_pol_schedule_periods.first_day_rate%TYPE,

Line 3863: p_max_breakfast_deduction IN ap_pol_schedule_periods.max_breakfast_deduction_amt%TYPE,

3859: p_rate_per_passenger IN ap_pol_schedule_periods.rate_per_passenger%TYPE,
3860: p_min_days IN ap_pol_schedule_periods.min_days%TYPE,
3861: p_tolerance IN ap_pol_schedule_periods.tolerance%TYPE,
3862: p_min_rate_per_period IN ap_pol_schedule_periods.min_rate_per_period%TYPE,
3863: p_max_breakfast_deduction IN ap_pol_schedule_periods.max_breakfast_deduction_amt%TYPE,
3864: p_max_lunch_deduction IN ap_pol_schedule_periods.max_lunch_deduction_amt%TYPE,
3865: p_max_dinner_deduction IN ap_pol_schedule_periods.max_dinner_deduction_amt%TYPE,
3866: p_first_day_rate IN ap_pol_schedule_periods.first_day_rate%TYPE,
3867: p_last_day_rate IN ap_pol_schedule_periods.last_day_rate%TYPE,

Line 3864: p_max_lunch_deduction IN ap_pol_schedule_periods.max_lunch_deduction_amt%TYPE,

3860: p_min_days IN ap_pol_schedule_periods.min_days%TYPE,
3861: p_tolerance IN ap_pol_schedule_periods.tolerance%TYPE,
3862: p_min_rate_per_period IN ap_pol_schedule_periods.min_rate_per_period%TYPE,
3863: p_max_breakfast_deduction IN ap_pol_schedule_periods.max_breakfast_deduction_amt%TYPE,
3864: p_max_lunch_deduction IN ap_pol_schedule_periods.max_lunch_deduction_amt%TYPE,
3865: p_max_dinner_deduction IN ap_pol_schedule_periods.max_dinner_deduction_amt%TYPE,
3866: p_first_day_rate IN ap_pol_schedule_periods.first_day_rate%TYPE,
3867: p_last_day_rate IN ap_pol_schedule_periods.last_day_rate%TYPE,
3868: p_reimbursement_percentage IN ap_pol_schedule_periods.reimbursement_percentage%TYPE) RETURN ap_pol_schedule_periods.schedule_period_id%TYPE IS

Line 3865: p_max_dinner_deduction IN ap_pol_schedule_periods.max_dinner_deduction_amt%TYPE,

3861: p_tolerance IN ap_pol_schedule_periods.tolerance%TYPE,
3862: p_min_rate_per_period IN ap_pol_schedule_periods.min_rate_per_period%TYPE,
3863: p_max_breakfast_deduction IN ap_pol_schedule_periods.max_breakfast_deduction_amt%TYPE,
3864: p_max_lunch_deduction IN ap_pol_schedule_periods.max_lunch_deduction_amt%TYPE,
3865: p_max_dinner_deduction IN ap_pol_schedule_periods.max_dinner_deduction_amt%TYPE,
3866: p_first_day_rate IN ap_pol_schedule_periods.first_day_rate%TYPE,
3867: p_last_day_rate IN ap_pol_schedule_periods.last_day_rate%TYPE,
3868: p_reimbursement_percentage IN ap_pol_schedule_periods.reimbursement_percentage%TYPE) RETURN ap_pol_schedule_periods.schedule_period_id%TYPE IS
3869:

Line 3866: p_first_day_rate IN ap_pol_schedule_periods.first_day_rate%TYPE,

3862: p_min_rate_per_period IN ap_pol_schedule_periods.min_rate_per_period%TYPE,
3863: p_max_breakfast_deduction IN ap_pol_schedule_periods.max_breakfast_deduction_amt%TYPE,
3864: p_max_lunch_deduction IN ap_pol_schedule_periods.max_lunch_deduction_amt%TYPE,
3865: p_max_dinner_deduction IN ap_pol_schedule_periods.max_dinner_deduction_amt%TYPE,
3866: p_first_day_rate IN ap_pol_schedule_periods.first_day_rate%TYPE,
3867: p_last_day_rate IN ap_pol_schedule_periods.last_day_rate%TYPE,
3868: p_reimbursement_percentage IN ap_pol_schedule_periods.reimbursement_percentage%TYPE) RETURN ap_pol_schedule_periods.schedule_period_id%TYPE IS
3869:
3870: l_schedule_period_id ap_pol_schedule_periods.schedule_period_id%TYPE;

Line 3867: p_last_day_rate IN ap_pol_schedule_periods.last_day_rate%TYPE,

3863: p_max_breakfast_deduction IN ap_pol_schedule_periods.max_breakfast_deduction_amt%TYPE,
3864: p_max_lunch_deduction IN ap_pol_schedule_periods.max_lunch_deduction_amt%TYPE,
3865: p_max_dinner_deduction IN ap_pol_schedule_periods.max_dinner_deduction_amt%TYPE,
3866: p_first_day_rate IN ap_pol_schedule_periods.first_day_rate%TYPE,
3867: p_last_day_rate IN ap_pol_schedule_periods.last_day_rate%TYPE,
3868: p_reimbursement_percentage IN ap_pol_schedule_periods.reimbursement_percentage%TYPE) RETURN ap_pol_schedule_periods.schedule_period_id%TYPE IS
3869:
3870: l_schedule_period_id ap_pol_schedule_periods.schedule_period_id%TYPE;
3871:

Line 3868: p_reimbursement_percentage IN ap_pol_schedule_periods.reimbursement_percentage%TYPE) RETURN ap_pol_schedule_periods.schedule_period_id%TYPE IS

3864: p_max_lunch_deduction IN ap_pol_schedule_periods.max_lunch_deduction_amt%TYPE,
3865: p_max_dinner_deduction IN ap_pol_schedule_periods.max_dinner_deduction_amt%TYPE,
3866: p_first_day_rate IN ap_pol_schedule_periods.first_day_rate%TYPE,
3867: p_last_day_rate IN ap_pol_schedule_periods.last_day_rate%TYPE,
3868: p_reimbursement_percentage IN ap_pol_schedule_periods.reimbursement_percentage%TYPE) RETURN ap_pol_schedule_periods.schedule_period_id%TYPE IS
3869:
3870: l_schedule_period_id ap_pol_schedule_periods.schedule_period_id%TYPE;
3871:
3872: BEGIN

Line 3870: l_schedule_period_id ap_pol_schedule_periods.schedule_period_id%TYPE;

3866: p_first_day_rate IN ap_pol_schedule_periods.first_day_rate%TYPE,
3867: p_last_day_rate IN ap_pol_schedule_periods.last_day_rate%TYPE,
3868: p_reimbursement_percentage IN ap_pol_schedule_periods.reimbursement_percentage%TYPE) RETURN ap_pol_schedule_periods.schedule_period_id%TYPE IS
3869:
3870: l_schedule_period_id ap_pol_schedule_periods.schedule_period_id%TYPE;
3871:
3872: BEGIN
3873:
3874: select AP_POL_SCHEDULE_PERIODS_S.NEXTVAL

Line 3874: select AP_POL_SCHEDULE_PERIODS_S.NEXTVAL

3870: l_schedule_period_id ap_pol_schedule_periods.schedule_period_id%TYPE;
3871:
3872: BEGIN
3873:
3874: select AP_POL_SCHEDULE_PERIODS_S.NEXTVAL
3875: into l_schedule_period_id
3876: from sys.dual;
3877:
3878: insert into AP_POL_SCHEDULE_PERIODS

Line 3878: insert into AP_POL_SCHEDULE_PERIODS

3874: select AP_POL_SCHEDULE_PERIODS_S.NEXTVAL
3875: into l_schedule_period_id
3876: from sys.dual;
3877:
3878: insert into AP_POL_SCHEDULE_PERIODS
3879: (
3880: SCHEDULE_PERIOD_ID,
3881: SCHEDULE_PERIOD_NAME,
3882: POLICY_ID,

Line 4027: l_from_schedule_period_id ap_pol_schedule_periods.schedule_period_id%TYPE;

4023:
4024: l_from_policy_id ap_pol_headers.policy_id%TYPE;
4025: l_to_policy_id ap_pol_headers.policy_id%TYPE;
4026:
4027: l_from_schedule_period_id ap_pol_schedule_periods.schedule_period_id%TYPE;
4028: l_to_schedule_period_id ap_pol_schedule_periods.schedule_period_id%TYPE;
4029:
4030: l_schedule_period_name ap_pol_schedule_periods.schedule_period_name%TYPE;
4031: l_start_date ap_pol_schedule_periods.start_date%TYPE;

Line 4028: l_to_schedule_period_id ap_pol_schedule_periods.schedule_period_id%TYPE;

4024: l_from_policy_id ap_pol_headers.policy_id%TYPE;
4025: l_to_policy_id ap_pol_headers.policy_id%TYPE;
4026:
4027: l_from_schedule_period_id ap_pol_schedule_periods.schedule_period_id%TYPE;
4028: l_to_schedule_period_id ap_pol_schedule_periods.schedule_period_id%TYPE;
4029:
4030: l_schedule_period_name ap_pol_schedule_periods.schedule_period_name%TYPE;
4031: l_start_date ap_pol_schedule_periods.start_date%TYPE;
4032: l_end_date ap_pol_schedule_periods.end_date%TYPE;

Line 4030: l_schedule_period_name ap_pol_schedule_periods.schedule_period_name%TYPE;

4026:
4027: l_from_schedule_period_id ap_pol_schedule_periods.schedule_period_id%TYPE;
4028: l_to_schedule_period_id ap_pol_schedule_periods.schedule_period_id%TYPE;
4029:
4030: l_schedule_period_name ap_pol_schedule_periods.schedule_period_name%TYPE;
4031: l_start_date ap_pol_schedule_periods.start_date%TYPE;
4032: l_end_date ap_pol_schedule_periods.end_date%TYPE;
4033: l_rate_per_passenger ap_pol_schedule_periods.rate_per_passenger%TYPE;
4034: l_min_days ap_pol_schedule_periods.min_days%TYPE;

Line 4031: l_start_date ap_pol_schedule_periods.start_date%TYPE;

4027: l_from_schedule_period_id ap_pol_schedule_periods.schedule_period_id%TYPE;
4028: l_to_schedule_period_id ap_pol_schedule_periods.schedule_period_id%TYPE;
4029:
4030: l_schedule_period_name ap_pol_schedule_periods.schedule_period_name%TYPE;
4031: l_start_date ap_pol_schedule_periods.start_date%TYPE;
4032: l_end_date ap_pol_schedule_periods.end_date%TYPE;
4033: l_rate_per_passenger ap_pol_schedule_periods.rate_per_passenger%TYPE;
4034: l_min_days ap_pol_schedule_periods.min_days%TYPE;
4035: l_tolerance ap_pol_schedule_periods.tolerance%TYPE;

Line 4032: l_end_date ap_pol_schedule_periods.end_date%TYPE;

4028: l_to_schedule_period_id ap_pol_schedule_periods.schedule_period_id%TYPE;
4029:
4030: l_schedule_period_name ap_pol_schedule_periods.schedule_period_name%TYPE;
4031: l_start_date ap_pol_schedule_periods.start_date%TYPE;
4032: l_end_date ap_pol_schedule_periods.end_date%TYPE;
4033: l_rate_per_passenger ap_pol_schedule_periods.rate_per_passenger%TYPE;
4034: l_min_days ap_pol_schedule_periods.min_days%TYPE;
4035: l_tolerance ap_pol_schedule_periods.tolerance%TYPE;
4036: l_min_rate_per_period ap_pol_schedule_periods.min_rate_per_period%TYPE;

Line 4033: l_rate_per_passenger ap_pol_schedule_periods.rate_per_passenger%TYPE;

4029:
4030: l_schedule_period_name ap_pol_schedule_periods.schedule_period_name%TYPE;
4031: l_start_date ap_pol_schedule_periods.start_date%TYPE;
4032: l_end_date ap_pol_schedule_periods.end_date%TYPE;
4033: l_rate_per_passenger ap_pol_schedule_periods.rate_per_passenger%TYPE;
4034: l_min_days ap_pol_schedule_periods.min_days%TYPE;
4035: l_tolerance ap_pol_schedule_periods.tolerance%TYPE;
4036: l_min_rate_per_period ap_pol_schedule_periods.min_rate_per_period%TYPE;
4037: l_max_breakfast_deduction ap_pol_schedule_periods.max_breakfast_deduction_amt%TYPE;

Line 4034: l_min_days ap_pol_schedule_periods.min_days%TYPE;

4030: l_schedule_period_name ap_pol_schedule_periods.schedule_period_name%TYPE;
4031: l_start_date ap_pol_schedule_periods.start_date%TYPE;
4032: l_end_date ap_pol_schedule_periods.end_date%TYPE;
4033: l_rate_per_passenger ap_pol_schedule_periods.rate_per_passenger%TYPE;
4034: l_min_days ap_pol_schedule_periods.min_days%TYPE;
4035: l_tolerance ap_pol_schedule_periods.tolerance%TYPE;
4036: l_min_rate_per_period ap_pol_schedule_periods.min_rate_per_period%TYPE;
4037: l_max_breakfast_deduction ap_pol_schedule_periods.max_breakfast_deduction_amt%TYPE;
4038: l_max_lunch_deduction ap_pol_schedule_periods.max_lunch_deduction_amt%TYPE;

Line 4035: l_tolerance ap_pol_schedule_periods.tolerance%TYPE;

4031: l_start_date ap_pol_schedule_periods.start_date%TYPE;
4032: l_end_date ap_pol_schedule_periods.end_date%TYPE;
4033: l_rate_per_passenger ap_pol_schedule_periods.rate_per_passenger%TYPE;
4034: l_min_days ap_pol_schedule_periods.min_days%TYPE;
4035: l_tolerance ap_pol_schedule_periods.tolerance%TYPE;
4036: l_min_rate_per_period ap_pol_schedule_periods.min_rate_per_period%TYPE;
4037: l_max_breakfast_deduction ap_pol_schedule_periods.max_breakfast_deduction_amt%TYPE;
4038: l_max_lunch_deduction ap_pol_schedule_periods.max_lunch_deduction_amt%TYPE;
4039: l_max_dinner_deduction ap_pol_schedule_periods.max_dinner_deduction_amt%TYPE;

Line 4036: l_min_rate_per_period ap_pol_schedule_periods.min_rate_per_period%TYPE;

4032: l_end_date ap_pol_schedule_periods.end_date%TYPE;
4033: l_rate_per_passenger ap_pol_schedule_periods.rate_per_passenger%TYPE;
4034: l_min_days ap_pol_schedule_periods.min_days%TYPE;
4035: l_tolerance ap_pol_schedule_periods.tolerance%TYPE;
4036: l_min_rate_per_period ap_pol_schedule_periods.min_rate_per_period%TYPE;
4037: l_max_breakfast_deduction ap_pol_schedule_periods.max_breakfast_deduction_amt%TYPE;
4038: l_max_lunch_deduction ap_pol_schedule_periods.max_lunch_deduction_amt%TYPE;
4039: l_max_dinner_deduction ap_pol_schedule_periods.max_dinner_deduction_amt%TYPE;
4040: l_first_day_rate ap_pol_schedule_periods.first_day_rate%TYPE;

Line 4037: l_max_breakfast_deduction ap_pol_schedule_periods.max_breakfast_deduction_amt%TYPE;

4033: l_rate_per_passenger ap_pol_schedule_periods.rate_per_passenger%TYPE;
4034: l_min_days ap_pol_schedule_periods.min_days%TYPE;
4035: l_tolerance ap_pol_schedule_periods.tolerance%TYPE;
4036: l_min_rate_per_period ap_pol_schedule_periods.min_rate_per_period%TYPE;
4037: l_max_breakfast_deduction ap_pol_schedule_periods.max_breakfast_deduction_amt%TYPE;
4038: l_max_lunch_deduction ap_pol_schedule_periods.max_lunch_deduction_amt%TYPE;
4039: l_max_dinner_deduction ap_pol_schedule_periods.max_dinner_deduction_amt%TYPE;
4040: l_first_day_rate ap_pol_schedule_periods.first_day_rate%TYPE;
4041: l_last_day_rate ap_pol_schedule_periods.last_day_rate%TYPE;

Line 4038: l_max_lunch_deduction ap_pol_schedule_periods.max_lunch_deduction_amt%TYPE;

4034: l_min_days ap_pol_schedule_periods.min_days%TYPE;
4035: l_tolerance ap_pol_schedule_periods.tolerance%TYPE;
4036: l_min_rate_per_period ap_pol_schedule_periods.min_rate_per_period%TYPE;
4037: l_max_breakfast_deduction ap_pol_schedule_periods.max_breakfast_deduction_amt%TYPE;
4038: l_max_lunch_deduction ap_pol_schedule_periods.max_lunch_deduction_amt%TYPE;
4039: l_max_dinner_deduction ap_pol_schedule_periods.max_dinner_deduction_amt%TYPE;
4040: l_first_day_rate ap_pol_schedule_periods.first_day_rate%TYPE;
4041: l_last_day_rate ap_pol_schedule_periods.last_day_rate%TYPE;
4042: l_reimbursement_percentage ap_pol_schedule_periods.reimbursement_percentage%TYPE;

Line 4039: l_max_dinner_deduction ap_pol_schedule_periods.max_dinner_deduction_amt%TYPE;

4035: l_tolerance ap_pol_schedule_periods.tolerance%TYPE;
4036: l_min_rate_per_period ap_pol_schedule_periods.min_rate_per_period%TYPE;
4037: l_max_breakfast_deduction ap_pol_schedule_periods.max_breakfast_deduction_amt%TYPE;
4038: l_max_lunch_deduction ap_pol_schedule_periods.max_lunch_deduction_amt%TYPE;
4039: l_max_dinner_deduction ap_pol_schedule_periods.max_dinner_deduction_amt%TYPE;
4040: l_first_day_rate ap_pol_schedule_periods.first_day_rate%TYPE;
4041: l_last_day_rate ap_pol_schedule_periods.last_day_rate%TYPE;
4042: l_reimbursement_percentage ap_pol_schedule_periods.reimbursement_percentage%TYPE;
4043:

Line 4040: l_first_day_rate ap_pol_schedule_periods.first_day_rate%TYPE;

4036: l_min_rate_per_period ap_pol_schedule_periods.min_rate_per_period%TYPE;
4037: l_max_breakfast_deduction ap_pol_schedule_periods.max_breakfast_deduction_amt%TYPE;
4038: l_max_lunch_deduction ap_pol_schedule_periods.max_lunch_deduction_amt%TYPE;
4039: l_max_dinner_deduction ap_pol_schedule_periods.max_dinner_deduction_amt%TYPE;
4040: l_first_day_rate ap_pol_schedule_periods.first_day_rate%TYPE;
4041: l_last_day_rate ap_pol_schedule_periods.last_day_rate%TYPE;
4042: l_reimbursement_percentage ap_pol_schedule_periods.reimbursement_percentage%TYPE;
4043:
4044: cursor l_duplicate_periods_cursor

Line 4041: l_last_day_rate ap_pol_schedule_periods.last_day_rate%TYPE;

4037: l_max_breakfast_deduction ap_pol_schedule_periods.max_breakfast_deduction_amt%TYPE;
4038: l_max_lunch_deduction ap_pol_schedule_periods.max_lunch_deduction_amt%TYPE;
4039: l_max_dinner_deduction ap_pol_schedule_periods.max_dinner_deduction_amt%TYPE;
4040: l_first_day_rate ap_pol_schedule_periods.first_day_rate%TYPE;
4041: l_last_day_rate ap_pol_schedule_periods.last_day_rate%TYPE;
4042: l_reimbursement_percentage ap_pol_schedule_periods.reimbursement_percentage%TYPE;
4043:
4044: cursor l_duplicate_periods_cursor
4045: is

Line 4042: l_reimbursement_percentage ap_pol_schedule_periods.reimbursement_percentage%TYPE;

4038: l_max_lunch_deduction ap_pol_schedule_periods.max_lunch_deduction_amt%TYPE;
4039: l_max_dinner_deduction ap_pol_schedule_periods.max_dinner_deduction_amt%TYPE;
4040: l_first_day_rate ap_pol_schedule_periods.first_day_rate%TYPE;
4041: l_last_day_rate ap_pol_schedule_periods.last_day_rate%TYPE;
4042: l_reimbursement_percentage ap_pol_schedule_periods.reimbursement_percentage%TYPE;
4043:
4044: cursor l_duplicate_periods_cursor
4045: is
4046: select

Line 4061: from AP_POL_SCHEDULE_PERIODS

4057: MAX_DINNER_DEDUCTION_AMT,
4058: FIRST_DAY_RATE,
4059: LAST_DAY_RATE,
4060: REIMBURSEMENT_PERCENTAGE
4061: from AP_POL_SCHEDULE_PERIODS
4062: where POLICY_ID = p_from_policy_id; /* l_duplicate_periods_cursor */
4063:
4064:
4065:

Line 4852: DELETE FROM AP_POL_SCHEDULE_PERIODS WHERE POLICY_ID = p_policy_id;

4848: BEGIN
4849:
4850: DELETE FROM AP_POL_SCHEDULE_OPTIONS WHERE POLICY_ID = p_policy_id;
4851:
4852: DELETE FROM AP_POL_SCHEDULE_PERIODS WHERE POLICY_ID = p_policy_id;
4853:
4854: DELETE FROM AP_POL_LINES WHERE POLICY_ID = p_policy_id;
4855:
4856: EXCEPTION

Line 5005: l_schedule_period_id ap_pol_schedule_periods.schedule_period_id%TYPE;

5001: PROCEDURE permutatePolicyLines(p_user_id IN NUMBER,
5002: p_policy_id IN ap_pol_headers.policy_id%TYPE,
5003: p_rate_type IN ap_pol_schedule_options.rate_type_code%TYPE) IS
5004:
5005: l_schedule_period_id ap_pol_schedule_periods.schedule_period_id%TYPE;
5006: l_permutate_curref INTEGER;
5007: l_rows_permutated NUMBER := 0;
5008: l_policy_line_count NUMBER := 0;
5009: l_insert_sql_stmt VARCHAR2(4000);

Line 5029: from ap_pol_schedule_periods

5025: -- cursor for schedule periods
5026: ---------------------------------------
5027: cursor c_schedule_period_id is
5028: select schedule_period_id
5029: from ap_pol_schedule_periods
5030: where policy_id = p_policy_id;
5031:
5032: ---------------------------------------
5033: -- cursor for insert/select

Line 6305: from AP_POL_HEADERS h, AP_POL_LINES l, AP_POL_SCHEDULE_PERIODS sp, AP_SYSTEM_PARAMETERS sys, AP_POL_EXRATE_OPTIONS rate_opts, ap_expense_report_params_all p

6301: End If;
6302:
6303: select l.POLICY_LINE_ID
6304: INTO l_policy_line_id
6305: from AP_POL_HEADERS h, AP_POL_LINES l, AP_POL_SCHEDULE_PERIODS sp, AP_SYSTEM_PARAMETERS sys, AP_POL_EXRATE_OPTIONS rate_opts, ap_expense_report_params_all p
6306: where p.parameter_id = p_expense_type_id
6307: AND h.policy_id = p.company_policy_id
6308: AND h.category_code <> 'MILEAGE'
6309: AND h.category_code <> 'PER_DIEM'