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_S

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 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 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 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 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 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 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'