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