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_LINES

Line 19: | List of possible AP_POL_LINES.STATUS (OIE_POLICY_LINE_STATUS)

15: c_MILEAGE CONSTANT VARCHAR2(20) := 'MILEAGE';
16: c_MISC CONSTANT VARCHAR2(20) := 'MISC';
17: c_PER_DIEM CONSTANT VARCHAR2(20) := 'PER_DIEM';
18: /*=======================================================================+
19: | List of possible AP_POL_LINES.STATUS (OIE_POLICY_LINE_STATUS)
20: +=======================================================================*/
21: c_SAVED CONSTANT VARCHAR2(20) := 'SAVED';
22: c_DUPLICATED CONSTANT VARCHAR2(20) := 'DUPLICATED';
23: c_ACTIVE CONSTANT VARCHAR2(20) := 'ACTIVE';

Line 712: p_policy_id IN ap_pol_lines.policy_id%TYPE,

708: | 12-Aug-2002 R Langi Created
709: |
710: *=======================================================================*/
711: PROCEDURE preservePolicyLine(p_user_id IN NUMBER,
712: p_policy_id IN ap_pol_lines.policy_id%TYPE,
713: p_schedule_period_id IN ap_pol_lines.schedule_period_id%TYPE,
714: p_policy_line_id IN ap_pol_lines.policy_line_id%TYPE);
715:
716: /*========================================================================

Line 713: p_schedule_period_id IN ap_pol_lines.schedule_period_id%TYPE,

709: |
710: *=======================================================================*/
711: PROCEDURE preservePolicyLine(p_user_id IN NUMBER,
712: p_policy_id IN ap_pol_lines.policy_id%TYPE,
713: p_schedule_period_id IN ap_pol_lines.schedule_period_id%TYPE,
714: p_policy_line_id IN ap_pol_lines.policy_line_id%TYPE);
715:
716: /*========================================================================
717: | PUBLIC PROCEDURE archivePreservedPolicyLines

Line 714: p_policy_line_id IN ap_pol_lines.policy_line_id%TYPE);

710: *=======================================================================*/
711: PROCEDURE preservePolicyLine(p_user_id IN NUMBER,
712: p_policy_id IN ap_pol_lines.policy_id%TYPE,
713: p_schedule_period_id IN ap_pol_lines.schedule_period_id%TYPE,
714: p_policy_line_id IN ap_pol_lines.policy_line_id%TYPE);
715:
716: /*========================================================================
717: | PUBLIC PROCEDURE archivePreservedPolicyLines
718: |

Line 736: p_policy_id IN ap_pol_lines.policy_id%TYPE);

732: | 12-Aug-2002 R Langi Created
733: |
734: *=======================================================================*/
735: PROCEDURE archivePreservedPolicyLines(p_user_id IN NUMBER,
736: p_policy_id IN ap_pol_lines.policy_id%TYPE);
737:
738: /*========================================================================
739: | PUBLIC FUNCTION createSchedulePeriod
740: |

Line 1316: p_start_of_season IN ap_pol_lines.start_of_season%TYPE,

1312: | 21-Feb-2006 albowicz Created
1313: |
1314: *=======================================================================*/
1315: FUNCTION isDateInSeason (p_date IN DATE,
1316: p_start_of_season IN ap_pol_lines.start_of_season%TYPE,
1317: p_end_of_season IN ap_pol_lines.end_of_season%TYPE) RETURN VARCHAR2;
1318:
1319: /*========================================================================
1320: | PUBLIC FUNCTION getPolicyLineId

Line 1317: p_end_of_season IN ap_pol_lines.end_of_season%TYPE) RETURN VARCHAR2;

1313: |
1314: *=======================================================================*/
1315: FUNCTION isDateInSeason (p_date IN DATE,
1316: p_start_of_season IN ap_pol_lines.start_of_season%TYPE,
1317: p_end_of_season IN ap_pol_lines.end_of_season%TYPE) RETURN VARCHAR2;
1318:
1319: /*========================================================================
1320: | PUBLIC FUNCTION getPolicyLineId
1321: |

Line 1396: FUNCTION checkForInvalidLines(p_policy_id IN ap_pol_lines.POLICY_ID%type,

1392: | Date Author Description of Changes
1393: | 08-Jun-2006 krmenon Created
1394: |
1395: *=======================================================================*/
1396: FUNCTION checkForInvalidLines(p_policy_id IN ap_pol_lines.POLICY_ID%type,
1397: p_schedule_id IN ap_pol_lines.SCHEDULE_PERIOD_ID%type,
1398: p_std_invalid OUT NOCOPY NUMBER,
1399: p_first_invalid OUT NOCOPY NUMBER,
1400: p_last_invalid OUT NOCOPY NUMBER,

Line 1397: p_schedule_id IN ap_pol_lines.SCHEDULE_PERIOD_ID%type,

1393: | 08-Jun-2006 krmenon Created
1394: |
1395: *=======================================================================*/
1396: FUNCTION checkForInvalidLines(p_policy_id IN ap_pol_lines.POLICY_ID%type,
1397: p_schedule_id IN ap_pol_lines.SCHEDULE_PERIOD_ID%type,
1398: p_std_invalid OUT NOCOPY NUMBER,
1399: p_first_invalid OUT NOCOPY NUMBER,
1400: p_last_invalid OUT NOCOPY NUMBER,
1401: p_same_invalid OUT NOCOPY NUMBER,

Line 1421: PROCEDURE activatePolicyLines(p_policy_id IN ap_pol_lines.POLICY_ID%type,

1417: | Date Author Description of Changes
1418: | 08-Jun-2006 krmenon Created
1419: |
1420: *=======================================================================*/
1421: PROCEDURE activatePolicyLines(p_policy_id IN ap_pol_lines.POLICY_ID%type,
1422: p_schedule_id IN ap_pol_lines.SCHEDULE_PERIOD_ID%type);
1423:
1424: /*========================================================================
1425: | PUBLIC FUNCTION get_dup_rule_assignment_exists

Line 1422: p_schedule_id IN ap_pol_lines.SCHEDULE_PERIOD_ID%type);

1418: | 08-Jun-2006 krmenon Created
1419: |
1420: *=======================================================================*/
1421: PROCEDURE activatePolicyLines(p_policy_id IN ap_pol_lines.POLICY_ID%type,
1422: p_schedule_id IN ap_pol_lines.SCHEDULE_PERIOD_ID%type);
1423:
1424: /*========================================================================
1425: | PUBLIC FUNCTION get_dup_rule_assignment_exists
1426: |