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 696: p_policy_id IN ap_pol_lines.policy_id%TYPE,

692: | 12-Aug-2002 R Langi Created
693: |
694: *=======================================================================*/
695: PROCEDURE preservePolicyLine(p_user_id IN NUMBER,
696: p_policy_id IN ap_pol_lines.policy_id%TYPE,
697: p_schedule_period_id IN ap_pol_lines.schedule_period_id%TYPE,
698: p_policy_line_id IN ap_pol_lines.policy_line_id%TYPE);
699:
700: /*========================================================================

Line 697: p_schedule_period_id IN ap_pol_lines.schedule_period_id%TYPE,

693: |
694: *=======================================================================*/
695: PROCEDURE preservePolicyLine(p_user_id IN NUMBER,
696: p_policy_id IN ap_pol_lines.policy_id%TYPE,
697: p_schedule_period_id IN ap_pol_lines.schedule_period_id%TYPE,
698: p_policy_line_id IN ap_pol_lines.policy_line_id%TYPE);
699:
700: /*========================================================================
701: | PUBLIC PROCEDURE archivePreservedPolicyLines

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

694: *=======================================================================*/
695: PROCEDURE preservePolicyLine(p_user_id IN NUMBER,
696: p_policy_id IN ap_pol_lines.policy_id%TYPE,
697: p_schedule_period_id IN ap_pol_lines.schedule_period_id%TYPE,
698: p_policy_line_id IN ap_pol_lines.policy_line_id%TYPE);
699:
700: /*========================================================================
701: | PUBLIC PROCEDURE archivePreservedPolicyLines
702: |

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

716: | 12-Aug-2002 R Langi Created
717: |
718: *=======================================================================*/
719: PROCEDURE archivePreservedPolicyLines(p_user_id IN NUMBER,
720: p_policy_id IN ap_pol_lines.policy_id%TYPE);
721:
722: /*========================================================================
723: | PUBLIC FUNCTION createSchedulePeriod
724: |

Line 1299: p_start_of_season IN ap_pol_lines.start_of_season%TYPE,

1295: | 21-Feb-2006 albowicz Created
1296: |
1297: *=======================================================================*/
1298: FUNCTION isDateInSeason (p_date IN DATE,
1299: p_start_of_season IN ap_pol_lines.start_of_season%TYPE,
1300: p_end_of_season IN ap_pol_lines.end_of_season%TYPE) RETURN VARCHAR2;
1301:
1302: /*========================================================================
1303: | PUBLIC FUNCTION getPolicyLineId

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

1296: |
1297: *=======================================================================*/
1298: FUNCTION isDateInSeason (p_date IN DATE,
1299: p_start_of_season IN ap_pol_lines.start_of_season%TYPE,
1300: p_end_of_season IN ap_pol_lines.end_of_season%TYPE) RETURN VARCHAR2;
1301:
1302: /*========================================================================
1303: | PUBLIC FUNCTION getPolicyLineId
1304: |

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

1375: | Date Author Description of Changes
1376: | 08-Jun-2006 krmenon Created
1377: |
1378: *=======================================================================*/
1379: FUNCTION checkForInvalidLines(p_policy_id IN ap_pol_lines.POLICY_ID%type,
1380: p_schedule_id IN ap_pol_lines.SCHEDULE_PERIOD_ID%type,
1381: p_std_invalid OUT NOCOPY NUMBER,
1382: p_first_invalid OUT NOCOPY NUMBER,
1383: p_last_invalid OUT NOCOPY NUMBER,

Line 1380: p_schedule_id IN ap_pol_lines.SCHEDULE_PERIOD_ID%type,

1376: | 08-Jun-2006 krmenon Created
1377: |
1378: *=======================================================================*/
1379: FUNCTION checkForInvalidLines(p_policy_id IN ap_pol_lines.POLICY_ID%type,
1380: p_schedule_id IN ap_pol_lines.SCHEDULE_PERIOD_ID%type,
1381: p_std_invalid OUT NOCOPY NUMBER,
1382: p_first_invalid OUT NOCOPY NUMBER,
1383: p_last_invalid OUT NOCOPY NUMBER,
1384: p_same_invalid OUT NOCOPY NUMBER,

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

1400: | Date Author Description of Changes
1401: | 08-Jun-2006 krmenon Created
1402: |
1403: *=======================================================================*/
1404: PROCEDURE activatePolicyLines(p_policy_id IN ap_pol_lines.POLICY_ID%type,
1405: p_schedule_id IN ap_pol_lines.SCHEDULE_PERIOD_ID%type);
1406:
1407:
1408: END AP_WEB_POLICY_UTILS;

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

1401: | 08-Jun-2006 krmenon Created
1402: |
1403: *=======================================================================*/
1404: PROCEDURE activatePolicyLines(p_policy_id IN ap_pol_lines.POLICY_ID%type,
1405: p_schedule_id IN ap_pol_lines.SCHEDULE_PERIOD_ID%type);
1406:
1407:
1408: END AP_WEB_POLICY_UTILS;