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

1889: *=======================================================================*/
1890: PROCEDURE permutatePolicyLines(p_user_id IN NUMBER,
1891: p_policy_id IN ap_pol_headers.policy_id%TYPE) IS
1892:
1893: l_schedule_period_id ap_pol_schedule_periods.schedule_period_id%TYPE;
1894: l_permutate_curref INTEGER;
1895: l_rows_permutated NUMBER := 0;
1896:
1897: l_policy_line_count NUMBER := 0;

Line 1933: from ap_pol_schedule_periods

1929: -- cursor for schedule periods
1930: ---------------------------------------
1931: cursor c_schedule_period_id is
1932: select schedule_period_id
1933: from ap_pol_schedule_periods
1934: where policy_id = p_policy_id;
1935:
1936: ---------------------------------------------------
1937: -- cursor for first last and same day rate periods

Line 3358: p_from_schedule_period_id IN ap_pol_schedule_periods.schedule_period_id%TYPE,

3354: |
3355: *=======================================================================*/
3356: PROCEDURE duplicatePolicyLines(p_user_id IN NUMBER,
3357: p_from_policy_id IN ap_pol_headers.policy_id%TYPE,
3358: p_from_schedule_period_id IN ap_pol_schedule_periods.schedule_period_id%TYPE,
3359: p_to_policy_id IN ap_pol_headers.policy_id%TYPE,
3360: p_to_schedule_period_id IN ap_pol_schedule_periods.schedule_period_id%TYPE) IS
3361:
3362: l_duplicate_curref INTEGER;

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

3356: PROCEDURE duplicatePolicyLines(p_user_id IN NUMBER,
3357: p_from_policy_id IN ap_pol_headers.policy_id%TYPE,
3358: p_from_schedule_period_id IN ap_pol_schedule_periods.schedule_period_id%TYPE,
3359: p_to_policy_id IN ap_pol_headers.policy_id%TYPE,
3360: p_to_schedule_period_id IN ap_pol_schedule_periods.schedule_period_id%TYPE) IS
3361:
3362: l_duplicate_curref INTEGER;
3363: l_rows_duplicated NUMBER := 0;
3364:

Line 3795: p_policy_id IN ap_pol_schedule_periods.policy_id%TYPE,

3791: | 16-May-2002 R Langi Created
3792: |
3793: *=======================================================================*/
3794: FUNCTION createSchedulePeriod(p_user_id IN NUMBER,
3795: p_policy_id IN ap_pol_schedule_periods.policy_id%TYPE,
3796: p_schedule_period_name IN ap_pol_schedule_periods.schedule_period_name%TYPE,
3797: p_start_date IN ap_pol_schedule_periods.start_date%TYPE,
3798: p_end_date IN ap_pol_schedule_periods.end_date%TYPE,
3799: p_rate_per_passenger IN ap_pol_schedule_periods.rate_per_passenger%TYPE,

Line 3796: p_schedule_period_name IN ap_pol_schedule_periods.schedule_period_name%TYPE,

3792: |
3793: *=======================================================================*/
3794: FUNCTION createSchedulePeriod(p_user_id IN NUMBER,
3795: p_policy_id IN ap_pol_schedule_periods.policy_id%TYPE,
3796: p_schedule_period_name IN ap_pol_schedule_periods.schedule_period_name%TYPE,
3797: p_start_date IN ap_pol_schedule_periods.start_date%TYPE,
3798: p_end_date IN ap_pol_schedule_periods.end_date%TYPE,
3799: p_rate_per_passenger IN ap_pol_schedule_periods.rate_per_passenger%TYPE,
3800: p_min_days IN ap_pol_schedule_periods.min_days%TYPE,

Line 3797: p_start_date IN ap_pol_schedule_periods.start_date%TYPE,

3793: *=======================================================================*/
3794: FUNCTION createSchedulePeriod(p_user_id IN NUMBER,
3795: p_policy_id IN ap_pol_schedule_periods.policy_id%TYPE,
3796: p_schedule_period_name IN ap_pol_schedule_periods.schedule_period_name%TYPE,
3797: p_start_date IN ap_pol_schedule_periods.start_date%TYPE,
3798: p_end_date IN ap_pol_schedule_periods.end_date%TYPE,
3799: p_rate_per_passenger IN ap_pol_schedule_periods.rate_per_passenger%TYPE,
3800: p_min_days IN ap_pol_schedule_periods.min_days%TYPE,
3801: p_tolerance IN ap_pol_schedule_periods.tolerance%TYPE,

Line 3798: p_end_date IN ap_pol_schedule_periods.end_date%TYPE,

3794: FUNCTION createSchedulePeriod(p_user_id IN NUMBER,
3795: p_policy_id IN ap_pol_schedule_periods.policy_id%TYPE,
3796: p_schedule_period_name IN ap_pol_schedule_periods.schedule_period_name%TYPE,
3797: p_start_date IN ap_pol_schedule_periods.start_date%TYPE,
3798: p_end_date IN ap_pol_schedule_periods.end_date%TYPE,
3799: p_rate_per_passenger IN ap_pol_schedule_periods.rate_per_passenger%TYPE,
3800: p_min_days IN ap_pol_schedule_periods.min_days%TYPE,
3801: p_tolerance IN ap_pol_schedule_periods.tolerance%TYPE,
3802: p_min_rate_per_period IN ap_pol_schedule_periods.min_rate_per_period%TYPE,

Line 3799: p_rate_per_passenger IN ap_pol_schedule_periods.rate_per_passenger%TYPE,

3795: p_policy_id IN ap_pol_schedule_periods.policy_id%TYPE,
3796: p_schedule_period_name IN ap_pol_schedule_periods.schedule_period_name%TYPE,
3797: p_start_date IN ap_pol_schedule_periods.start_date%TYPE,
3798: p_end_date IN ap_pol_schedule_periods.end_date%TYPE,
3799: p_rate_per_passenger IN ap_pol_schedule_periods.rate_per_passenger%TYPE,
3800: p_min_days IN ap_pol_schedule_periods.min_days%TYPE,
3801: p_tolerance IN ap_pol_schedule_periods.tolerance%TYPE,
3802: p_min_rate_per_period IN ap_pol_schedule_periods.min_rate_per_period%TYPE,
3803: p_max_breakfast_deduction IN ap_pol_schedule_periods.max_breakfast_deduction_amt%TYPE,

Line 3800: p_min_days IN ap_pol_schedule_periods.min_days%TYPE,

3796: p_schedule_period_name IN ap_pol_schedule_periods.schedule_period_name%TYPE,
3797: p_start_date IN ap_pol_schedule_periods.start_date%TYPE,
3798: p_end_date IN ap_pol_schedule_periods.end_date%TYPE,
3799: p_rate_per_passenger IN ap_pol_schedule_periods.rate_per_passenger%TYPE,
3800: p_min_days IN ap_pol_schedule_periods.min_days%TYPE,
3801: p_tolerance IN ap_pol_schedule_periods.tolerance%TYPE,
3802: p_min_rate_per_period IN ap_pol_schedule_periods.min_rate_per_period%TYPE,
3803: p_max_breakfast_deduction IN ap_pol_schedule_periods.max_breakfast_deduction_amt%TYPE,
3804: p_max_lunch_deduction IN ap_pol_schedule_periods.max_lunch_deduction_amt%TYPE,

Line 3801: p_tolerance IN ap_pol_schedule_periods.tolerance%TYPE,

3797: p_start_date IN ap_pol_schedule_periods.start_date%TYPE,
3798: p_end_date IN ap_pol_schedule_periods.end_date%TYPE,
3799: p_rate_per_passenger IN ap_pol_schedule_periods.rate_per_passenger%TYPE,
3800: p_min_days IN ap_pol_schedule_periods.min_days%TYPE,
3801: p_tolerance IN ap_pol_schedule_periods.tolerance%TYPE,
3802: p_min_rate_per_period IN ap_pol_schedule_periods.min_rate_per_period%TYPE,
3803: p_max_breakfast_deduction IN ap_pol_schedule_periods.max_breakfast_deduction_amt%TYPE,
3804: p_max_lunch_deduction IN ap_pol_schedule_periods.max_lunch_deduction_amt%TYPE,
3805: p_max_dinner_deduction IN ap_pol_schedule_periods.max_dinner_deduction_amt%TYPE,

Line 3802: p_min_rate_per_period IN ap_pol_schedule_periods.min_rate_per_period%TYPE,

3798: p_end_date IN ap_pol_schedule_periods.end_date%TYPE,
3799: p_rate_per_passenger IN ap_pol_schedule_periods.rate_per_passenger%TYPE,
3800: p_min_days IN ap_pol_schedule_periods.min_days%TYPE,
3801: p_tolerance IN ap_pol_schedule_periods.tolerance%TYPE,
3802: p_min_rate_per_period IN ap_pol_schedule_periods.min_rate_per_period%TYPE,
3803: p_max_breakfast_deduction IN ap_pol_schedule_periods.max_breakfast_deduction_amt%TYPE,
3804: p_max_lunch_deduction IN ap_pol_schedule_periods.max_lunch_deduction_amt%TYPE,
3805: p_max_dinner_deduction IN ap_pol_schedule_periods.max_dinner_deduction_amt%TYPE,
3806: p_first_day_rate IN ap_pol_schedule_periods.first_day_rate%TYPE,

Line 3803: p_max_breakfast_deduction IN ap_pol_schedule_periods.max_breakfast_deduction_amt%TYPE,

3799: p_rate_per_passenger IN ap_pol_schedule_periods.rate_per_passenger%TYPE,
3800: p_min_days IN ap_pol_schedule_periods.min_days%TYPE,
3801: p_tolerance IN ap_pol_schedule_periods.tolerance%TYPE,
3802: p_min_rate_per_period IN ap_pol_schedule_periods.min_rate_per_period%TYPE,
3803: p_max_breakfast_deduction IN ap_pol_schedule_periods.max_breakfast_deduction_amt%TYPE,
3804: p_max_lunch_deduction IN ap_pol_schedule_periods.max_lunch_deduction_amt%TYPE,
3805: p_max_dinner_deduction IN ap_pol_schedule_periods.max_dinner_deduction_amt%TYPE,
3806: p_first_day_rate IN ap_pol_schedule_periods.first_day_rate%TYPE,
3807: p_last_day_rate IN ap_pol_schedule_periods.last_day_rate%TYPE) RETURN ap_pol_schedule_periods.schedule_period_id%TYPE IS

Line 3804: p_max_lunch_deduction IN ap_pol_schedule_periods.max_lunch_deduction_amt%TYPE,

3800: p_min_days IN ap_pol_schedule_periods.min_days%TYPE,
3801: p_tolerance IN ap_pol_schedule_periods.tolerance%TYPE,
3802: p_min_rate_per_period IN ap_pol_schedule_periods.min_rate_per_period%TYPE,
3803: p_max_breakfast_deduction IN ap_pol_schedule_periods.max_breakfast_deduction_amt%TYPE,
3804: p_max_lunch_deduction IN ap_pol_schedule_periods.max_lunch_deduction_amt%TYPE,
3805: p_max_dinner_deduction IN ap_pol_schedule_periods.max_dinner_deduction_amt%TYPE,
3806: p_first_day_rate IN ap_pol_schedule_periods.first_day_rate%TYPE,
3807: p_last_day_rate IN ap_pol_schedule_periods.last_day_rate%TYPE) RETURN ap_pol_schedule_periods.schedule_period_id%TYPE IS
3808:

Line 3805: p_max_dinner_deduction IN ap_pol_schedule_periods.max_dinner_deduction_amt%TYPE,

3801: p_tolerance IN ap_pol_schedule_periods.tolerance%TYPE,
3802: p_min_rate_per_period IN ap_pol_schedule_periods.min_rate_per_period%TYPE,
3803: p_max_breakfast_deduction IN ap_pol_schedule_periods.max_breakfast_deduction_amt%TYPE,
3804: p_max_lunch_deduction IN ap_pol_schedule_periods.max_lunch_deduction_amt%TYPE,
3805: p_max_dinner_deduction IN ap_pol_schedule_periods.max_dinner_deduction_amt%TYPE,
3806: p_first_day_rate IN ap_pol_schedule_periods.first_day_rate%TYPE,
3807: p_last_day_rate IN ap_pol_schedule_periods.last_day_rate%TYPE) RETURN ap_pol_schedule_periods.schedule_period_id%TYPE IS
3808:
3809: l_schedule_period_id ap_pol_schedule_periods.schedule_period_id%TYPE;

Line 3806: p_first_day_rate IN ap_pol_schedule_periods.first_day_rate%TYPE,

3802: p_min_rate_per_period IN ap_pol_schedule_periods.min_rate_per_period%TYPE,
3803: p_max_breakfast_deduction IN ap_pol_schedule_periods.max_breakfast_deduction_amt%TYPE,
3804: p_max_lunch_deduction IN ap_pol_schedule_periods.max_lunch_deduction_amt%TYPE,
3805: p_max_dinner_deduction IN ap_pol_schedule_periods.max_dinner_deduction_amt%TYPE,
3806: p_first_day_rate IN ap_pol_schedule_periods.first_day_rate%TYPE,
3807: p_last_day_rate IN ap_pol_schedule_periods.last_day_rate%TYPE) RETURN ap_pol_schedule_periods.schedule_period_id%TYPE IS
3808:
3809: l_schedule_period_id ap_pol_schedule_periods.schedule_period_id%TYPE;
3810:

Line 3807: p_last_day_rate IN ap_pol_schedule_periods.last_day_rate%TYPE) RETURN ap_pol_schedule_periods.schedule_period_id%TYPE IS

3803: p_max_breakfast_deduction IN ap_pol_schedule_periods.max_breakfast_deduction_amt%TYPE,
3804: p_max_lunch_deduction IN ap_pol_schedule_periods.max_lunch_deduction_amt%TYPE,
3805: p_max_dinner_deduction IN ap_pol_schedule_periods.max_dinner_deduction_amt%TYPE,
3806: p_first_day_rate IN ap_pol_schedule_periods.first_day_rate%TYPE,
3807: p_last_day_rate IN ap_pol_schedule_periods.last_day_rate%TYPE) RETURN ap_pol_schedule_periods.schedule_period_id%TYPE IS
3808:
3809: l_schedule_period_id ap_pol_schedule_periods.schedule_period_id%TYPE;
3810:
3811: BEGIN

Line 3809: l_schedule_period_id ap_pol_schedule_periods.schedule_period_id%TYPE;

3805: p_max_dinner_deduction IN ap_pol_schedule_periods.max_dinner_deduction_amt%TYPE,
3806: p_first_day_rate IN ap_pol_schedule_periods.first_day_rate%TYPE,
3807: p_last_day_rate IN ap_pol_schedule_periods.last_day_rate%TYPE) RETURN ap_pol_schedule_periods.schedule_period_id%TYPE IS
3808:
3809: l_schedule_period_id ap_pol_schedule_periods.schedule_period_id%TYPE;
3810:
3811: BEGIN
3812:
3813: select AP_POL_SCHEDULE_PERIODS_S.NEXTVAL

Line 3813: select AP_POL_SCHEDULE_PERIODS_S.NEXTVAL

3809: l_schedule_period_id ap_pol_schedule_periods.schedule_period_id%TYPE;
3810:
3811: BEGIN
3812:
3813: select AP_POL_SCHEDULE_PERIODS_S.NEXTVAL
3814: into l_schedule_period_id
3815: from sys.dual;
3816:
3817: insert into AP_POL_SCHEDULE_PERIODS

Line 3817: insert into AP_POL_SCHEDULE_PERIODS

3813: select AP_POL_SCHEDULE_PERIODS_S.NEXTVAL
3814: into l_schedule_period_id
3815: from sys.dual;
3816:
3817: insert into AP_POL_SCHEDULE_PERIODS
3818: (
3819: SCHEDULE_PERIOD_ID,
3820: SCHEDULE_PERIOD_NAME,
3821: POLICY_ID,

Line 3964: l_from_schedule_period_id ap_pol_schedule_periods.schedule_period_id%TYPE;

3960:
3961: l_from_policy_id ap_pol_headers.policy_id%TYPE;
3962: l_to_policy_id ap_pol_headers.policy_id%TYPE;
3963:
3964: l_from_schedule_period_id ap_pol_schedule_periods.schedule_period_id%TYPE;
3965: l_to_schedule_period_id ap_pol_schedule_periods.schedule_period_id%TYPE;
3966:
3967: l_schedule_period_name ap_pol_schedule_periods.schedule_period_name%TYPE;
3968: l_start_date ap_pol_schedule_periods.start_date%TYPE;

Line 3965: l_to_schedule_period_id ap_pol_schedule_periods.schedule_period_id%TYPE;

3961: l_from_policy_id ap_pol_headers.policy_id%TYPE;
3962: l_to_policy_id ap_pol_headers.policy_id%TYPE;
3963:
3964: l_from_schedule_period_id ap_pol_schedule_periods.schedule_period_id%TYPE;
3965: l_to_schedule_period_id ap_pol_schedule_periods.schedule_period_id%TYPE;
3966:
3967: l_schedule_period_name ap_pol_schedule_periods.schedule_period_name%TYPE;
3968: l_start_date ap_pol_schedule_periods.start_date%TYPE;
3969: l_end_date ap_pol_schedule_periods.end_date%TYPE;

Line 3967: l_schedule_period_name ap_pol_schedule_periods.schedule_period_name%TYPE;

3963:
3964: l_from_schedule_period_id ap_pol_schedule_periods.schedule_period_id%TYPE;
3965: l_to_schedule_period_id ap_pol_schedule_periods.schedule_period_id%TYPE;
3966:
3967: l_schedule_period_name ap_pol_schedule_periods.schedule_period_name%TYPE;
3968: l_start_date ap_pol_schedule_periods.start_date%TYPE;
3969: l_end_date ap_pol_schedule_periods.end_date%TYPE;
3970: l_rate_per_passenger ap_pol_schedule_periods.rate_per_passenger%TYPE;
3971: l_min_days ap_pol_schedule_periods.min_days%TYPE;

Line 3968: l_start_date ap_pol_schedule_periods.start_date%TYPE;

3964: l_from_schedule_period_id ap_pol_schedule_periods.schedule_period_id%TYPE;
3965: l_to_schedule_period_id ap_pol_schedule_periods.schedule_period_id%TYPE;
3966:
3967: l_schedule_period_name ap_pol_schedule_periods.schedule_period_name%TYPE;
3968: l_start_date ap_pol_schedule_periods.start_date%TYPE;
3969: l_end_date ap_pol_schedule_periods.end_date%TYPE;
3970: l_rate_per_passenger ap_pol_schedule_periods.rate_per_passenger%TYPE;
3971: l_min_days ap_pol_schedule_periods.min_days%TYPE;
3972: l_tolerance ap_pol_schedule_periods.tolerance%TYPE;

Line 3969: l_end_date ap_pol_schedule_periods.end_date%TYPE;

3965: l_to_schedule_period_id ap_pol_schedule_periods.schedule_period_id%TYPE;
3966:
3967: l_schedule_period_name ap_pol_schedule_periods.schedule_period_name%TYPE;
3968: l_start_date ap_pol_schedule_periods.start_date%TYPE;
3969: l_end_date ap_pol_schedule_periods.end_date%TYPE;
3970: l_rate_per_passenger ap_pol_schedule_periods.rate_per_passenger%TYPE;
3971: l_min_days ap_pol_schedule_periods.min_days%TYPE;
3972: l_tolerance ap_pol_schedule_periods.tolerance%TYPE;
3973: l_min_rate_per_period ap_pol_schedule_periods.min_rate_per_period%TYPE;

Line 3970: l_rate_per_passenger ap_pol_schedule_periods.rate_per_passenger%TYPE;

3966:
3967: l_schedule_period_name ap_pol_schedule_periods.schedule_period_name%TYPE;
3968: l_start_date ap_pol_schedule_periods.start_date%TYPE;
3969: l_end_date ap_pol_schedule_periods.end_date%TYPE;
3970: l_rate_per_passenger ap_pol_schedule_periods.rate_per_passenger%TYPE;
3971: l_min_days ap_pol_schedule_periods.min_days%TYPE;
3972: l_tolerance ap_pol_schedule_periods.tolerance%TYPE;
3973: l_min_rate_per_period ap_pol_schedule_periods.min_rate_per_period%TYPE;
3974: l_max_breakfast_deduction ap_pol_schedule_periods.max_breakfast_deduction_amt%TYPE;

Line 3971: l_min_days ap_pol_schedule_periods.min_days%TYPE;

3967: l_schedule_period_name ap_pol_schedule_periods.schedule_period_name%TYPE;
3968: l_start_date ap_pol_schedule_periods.start_date%TYPE;
3969: l_end_date ap_pol_schedule_periods.end_date%TYPE;
3970: l_rate_per_passenger ap_pol_schedule_periods.rate_per_passenger%TYPE;
3971: l_min_days ap_pol_schedule_periods.min_days%TYPE;
3972: l_tolerance ap_pol_schedule_periods.tolerance%TYPE;
3973: l_min_rate_per_period ap_pol_schedule_periods.min_rate_per_period%TYPE;
3974: l_max_breakfast_deduction ap_pol_schedule_periods.max_breakfast_deduction_amt%TYPE;
3975: l_max_lunch_deduction ap_pol_schedule_periods.max_lunch_deduction_amt%TYPE;

Line 3972: l_tolerance ap_pol_schedule_periods.tolerance%TYPE;

3968: l_start_date ap_pol_schedule_periods.start_date%TYPE;
3969: l_end_date ap_pol_schedule_periods.end_date%TYPE;
3970: l_rate_per_passenger ap_pol_schedule_periods.rate_per_passenger%TYPE;
3971: l_min_days ap_pol_schedule_periods.min_days%TYPE;
3972: l_tolerance ap_pol_schedule_periods.tolerance%TYPE;
3973: l_min_rate_per_period ap_pol_schedule_periods.min_rate_per_period%TYPE;
3974: l_max_breakfast_deduction ap_pol_schedule_periods.max_breakfast_deduction_amt%TYPE;
3975: l_max_lunch_deduction ap_pol_schedule_periods.max_lunch_deduction_amt%TYPE;
3976: l_max_dinner_deduction ap_pol_schedule_periods.max_dinner_deduction_amt%TYPE;

Line 3973: l_min_rate_per_period ap_pol_schedule_periods.min_rate_per_period%TYPE;

3969: l_end_date ap_pol_schedule_periods.end_date%TYPE;
3970: l_rate_per_passenger ap_pol_schedule_periods.rate_per_passenger%TYPE;
3971: l_min_days ap_pol_schedule_periods.min_days%TYPE;
3972: l_tolerance ap_pol_schedule_periods.tolerance%TYPE;
3973: l_min_rate_per_period ap_pol_schedule_periods.min_rate_per_period%TYPE;
3974: l_max_breakfast_deduction ap_pol_schedule_periods.max_breakfast_deduction_amt%TYPE;
3975: l_max_lunch_deduction ap_pol_schedule_periods.max_lunch_deduction_amt%TYPE;
3976: l_max_dinner_deduction ap_pol_schedule_periods.max_dinner_deduction_amt%TYPE;
3977: l_first_day_rate ap_pol_schedule_periods.first_day_rate%TYPE;

Line 3974: l_max_breakfast_deduction ap_pol_schedule_periods.max_breakfast_deduction_amt%TYPE;

3970: l_rate_per_passenger ap_pol_schedule_periods.rate_per_passenger%TYPE;
3971: l_min_days ap_pol_schedule_periods.min_days%TYPE;
3972: l_tolerance ap_pol_schedule_periods.tolerance%TYPE;
3973: l_min_rate_per_period ap_pol_schedule_periods.min_rate_per_period%TYPE;
3974: l_max_breakfast_deduction ap_pol_schedule_periods.max_breakfast_deduction_amt%TYPE;
3975: l_max_lunch_deduction ap_pol_schedule_periods.max_lunch_deduction_amt%TYPE;
3976: l_max_dinner_deduction ap_pol_schedule_periods.max_dinner_deduction_amt%TYPE;
3977: l_first_day_rate ap_pol_schedule_periods.first_day_rate%TYPE;
3978: l_last_day_rate ap_pol_schedule_periods.last_day_rate%TYPE;

Line 3975: l_max_lunch_deduction ap_pol_schedule_periods.max_lunch_deduction_amt%TYPE;

3971: l_min_days ap_pol_schedule_periods.min_days%TYPE;
3972: l_tolerance ap_pol_schedule_periods.tolerance%TYPE;
3973: l_min_rate_per_period ap_pol_schedule_periods.min_rate_per_period%TYPE;
3974: l_max_breakfast_deduction ap_pol_schedule_periods.max_breakfast_deduction_amt%TYPE;
3975: l_max_lunch_deduction ap_pol_schedule_periods.max_lunch_deduction_amt%TYPE;
3976: l_max_dinner_deduction ap_pol_schedule_periods.max_dinner_deduction_amt%TYPE;
3977: l_first_day_rate ap_pol_schedule_periods.first_day_rate%TYPE;
3978: l_last_day_rate ap_pol_schedule_periods.last_day_rate%TYPE;
3979:

Line 3976: l_max_dinner_deduction ap_pol_schedule_periods.max_dinner_deduction_amt%TYPE;

3972: l_tolerance ap_pol_schedule_periods.tolerance%TYPE;
3973: l_min_rate_per_period ap_pol_schedule_periods.min_rate_per_period%TYPE;
3974: l_max_breakfast_deduction ap_pol_schedule_periods.max_breakfast_deduction_amt%TYPE;
3975: l_max_lunch_deduction ap_pol_schedule_periods.max_lunch_deduction_amt%TYPE;
3976: l_max_dinner_deduction ap_pol_schedule_periods.max_dinner_deduction_amt%TYPE;
3977: l_first_day_rate ap_pol_schedule_periods.first_day_rate%TYPE;
3978: l_last_day_rate ap_pol_schedule_periods.last_day_rate%TYPE;
3979:
3980: cursor l_duplicate_periods_cursor

Line 3977: l_first_day_rate ap_pol_schedule_periods.first_day_rate%TYPE;

3973: l_min_rate_per_period ap_pol_schedule_periods.min_rate_per_period%TYPE;
3974: l_max_breakfast_deduction ap_pol_schedule_periods.max_breakfast_deduction_amt%TYPE;
3975: l_max_lunch_deduction ap_pol_schedule_periods.max_lunch_deduction_amt%TYPE;
3976: l_max_dinner_deduction ap_pol_schedule_periods.max_dinner_deduction_amt%TYPE;
3977: l_first_day_rate ap_pol_schedule_periods.first_day_rate%TYPE;
3978: l_last_day_rate ap_pol_schedule_periods.last_day_rate%TYPE;
3979:
3980: cursor l_duplicate_periods_cursor
3981: is

Line 3978: l_last_day_rate ap_pol_schedule_periods.last_day_rate%TYPE;

3974: l_max_breakfast_deduction ap_pol_schedule_periods.max_breakfast_deduction_amt%TYPE;
3975: l_max_lunch_deduction ap_pol_schedule_periods.max_lunch_deduction_amt%TYPE;
3976: l_max_dinner_deduction ap_pol_schedule_periods.max_dinner_deduction_amt%TYPE;
3977: l_first_day_rate ap_pol_schedule_periods.first_day_rate%TYPE;
3978: l_last_day_rate ap_pol_schedule_periods.last_day_rate%TYPE;
3979:
3980: cursor l_duplicate_periods_cursor
3981: is
3982: select

Line 3996: from AP_POL_SCHEDULE_PERIODS

3992: MAX_LUNCH_DEDUCTION_AMT,
3993: MAX_DINNER_DEDUCTION_AMT,
3994: FIRST_DAY_RATE,
3995: LAST_DAY_RATE
3996: from AP_POL_SCHEDULE_PERIODS
3997: where POLICY_ID = p_from_policy_id; /* l_duplicate_periods_cursor */
3998:
3999:
4000:

Line 4781: DELETE FROM AP_POL_SCHEDULE_PERIODS WHERE POLICY_ID = p_policy_id;

4777: BEGIN
4778:
4779: DELETE FROM AP_POL_SCHEDULE_OPTIONS WHERE POLICY_ID = p_policy_id;
4780:
4781: DELETE FROM AP_POL_SCHEDULE_PERIODS WHERE POLICY_ID = p_policy_id;
4782:
4783: DELETE FROM AP_POL_LINES WHERE POLICY_ID = p_policy_id;
4784:
4785: EXCEPTION

Line 4934: l_schedule_period_id ap_pol_schedule_periods.schedule_period_id%TYPE;

4930: PROCEDURE permutatePolicyLines(p_user_id IN NUMBER,
4931: p_policy_id IN ap_pol_headers.policy_id%TYPE,
4932: p_rate_type IN ap_pol_schedule_options.rate_type_code%TYPE) IS
4933:
4934: l_schedule_period_id ap_pol_schedule_periods.schedule_period_id%TYPE;
4935: l_permutate_curref INTEGER;
4936: l_rows_permutated NUMBER := 0;
4937: l_policy_line_count NUMBER := 0;
4938: l_insert_sql_stmt VARCHAR2(4000);

Line 4958: from ap_pol_schedule_periods

4954: -- cursor for schedule periods
4955: ---------------------------------------
4956: cursor c_schedule_period_id is
4957: select schedule_period_id
4958: from ap_pol_schedule_periods
4959: where policy_id = p_policy_id;
4960:
4961: ---------------------------------------
4962: -- cursor for insert/select

Line 6227: 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

6223: l_location_id := getPolicyLocationId(p_expense_type_id, p_expense_date, p_location_id);
6224:
6225: select l.POLICY_LINE_ID
6226: INTO l_policy_line_id
6227: 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
6228: where p.parameter_id = p_expense_type_id
6229: AND h.policy_id = p.company_policy_id
6230: AND h.category_code <> 'MILEAGE'
6231: AND h.category_code <> 'PER_DIEM'