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_HEADERS

Line 9: | List of possible AP_POL_HEADERS.CATEGORY_CODE (OIE_EXPENSE_CATEGORY)

5: +=======================================================================*/
6:
7:
8: /*=======================================================================+
9: | List of possible AP_POL_HEADERS.CATEGORY_CODE (OIE_EXPENSE_CATEGORY)
10: +=======================================================================*/
11: c_ACCOMMODATIONS CONSTANT VARCHAR2(20) := 'ACCOMMODATIONS';
12: c_AIRFARE CONSTANT VARCHAR2(20) := 'AIRFARE';
13: c_CAR_RENTAL CONSTANT VARCHAR2(20) := 'CAR_RENTAL';

Line 46: | List of possible AP_POL_HEADERS.CURRENCY_PREFERENCE (OIE_POL_CUR_RULES)

42: | as a valid AP_POL_SCHEDULE_OPTIONS.OPTION_TYPE
43: +=======================================================================*/
44: c_THRESHOLD CONSTANT VARCHAR2(20) := 'THRESHOLD';
45: /*=======================================================================+
46: | List of possible AP_POL_HEADERS.CURRENCY_PREFERENCE (OIE_POL_CUR_RULES)
47: +=======================================================================*/
48: c_LCR CONSTANT VARCHAR2(20) := 'LCR';
49: c_MRC CONSTANT VARCHAR2(20) := 'MRC';
50: c_SRC CONSTANT VARCHAR2(20) := 'SRC';

Line 479: FUNCTION getHighEndOfThreshold(p_policy_id IN ap_pol_headers.policy_id%TYPE,

475: | Date Author Description of Changes
476: | 16-May-2002 R Langi Created
477: |
478: *=======================================================================*/
479: FUNCTION getHighEndOfThreshold(p_policy_id IN ap_pol_headers.policy_id%TYPE,
480: p_threshold IN ap_pol_schedule_options.threshold%TYPE) RETURN ap_pol_schedule_options.threshold%TYPE;
481:
482: /*========================================================================
483: | PUBLIC FUNCTION getHighEndOfThreshold

Line 501: FUNCTION getHighEndOfThreshold(p_policy_id IN ap_pol_headers.policy_id%TYPE,

497: | Date Author Description of Changes
498: | 01-Nov-2005 krmenon Created
499: |
500: *=======================================================================*/
501: FUNCTION getHighEndOfThreshold(p_policy_id IN ap_pol_headers.policy_id%TYPE,
502: p_threshold IN ap_pol_schedule_options.threshold%TYPE,
503: p_rate_type IN ap_pol_schedule_options.rate_type_code%TYPE) RETURN ap_pol_schedule_options.threshold%TYPE;
504:
505: /*========================================================================

Line 523: FUNCTION getPolicyCategoryCode(p_policy_id IN ap_pol_headers.policy_id%TYPE) RETURN ap_pol_headers.category_code%TYPE;

519: | Date Author Description of Changes
520: | 16-May-2002 R Langi Created
521: |
522: *=======================================================================*/
523: FUNCTION getPolicyCategoryCode(p_policy_id IN ap_pol_headers.policy_id%TYPE) RETURN ap_pol_headers.category_code%TYPE;
524:
525: /*========================================================================
526: | PUBLIC FUNCTION checkRuleOption
527: |

Line 553: FUNCTION checkRuleOption(p_policy_id IN ap_pol_headers.policy_id%TYPE,

549: | Date Author Description of Changes
550: | 16-May-2002 R Langi Created
551: |
552: *=======================================================================*/
553: FUNCTION checkRuleOption(p_policy_id IN ap_pol_headers.policy_id%TYPE,
554: p_rule IN VARCHAR2) RETURN VARCHAR2;
555:
556: /*========================================================================
557: | PUBLIC FUNCTION getUnionStmtForRuleOption

Line 576: FUNCTION getUnionStmtForRuleOption(p_policy_id IN ap_pol_headers.policy_id%TYPE,

572: | Date Author Description of Changes
573: | 16-May-2002 R Langi Created
574: |
575: *=======================================================================*/
576: FUNCTION getUnionStmtForRuleOption(p_policy_id IN ap_pol_headers.policy_id%TYPE,
577: p_rule IN VARCHAR2) RETURN VARCHAR2;
578:
579: /*========================================================================
580: | PUBLIC PROCEDURE permutatePolicyLines

Line 603: p_policy_id IN ap_pol_headers.policy_id%TYPE);

599: | 16-May-2002 R Langi Created
600: |
601: *=======================================================================*/
602: PROCEDURE permutatePolicyLines(p_user_id IN NUMBER,
603: p_policy_id IN ap_pol_headers.policy_id%TYPE);
604:
605: /*========================================================================
606: | PUBLIC PROCEDURE removeObsoletedPolicyLines
607: |

Line 624: PROCEDURE removeObsoletedPolicyLines(p_policy_id IN ap_pol_headers.policy_id%TYPE);

620: | Date Author Description of Changes
621: | 16-May-2002 R Langi Created
622: |
623: *=======================================================================*/
624: PROCEDURE removeObsoletedPolicyLines(p_policy_id IN ap_pol_headers.policy_id%TYPE);
625:
626: /*========================================================================
627: | PUBLIC PROCEDURE updateInactivePolicyLines
628: |

Line 644: PROCEDURE updateInactivePolicyLines(p_policy_id IN ap_pol_headers.policy_id%TYPE);

640: | Date Author Description of Changes
641: | 16-May-2002 R Langi Created
642: |
643: *=======================================================================*/
644: PROCEDURE updateInactivePolicyLines(p_policy_id IN ap_pol_headers.policy_id%TYPE);
645:
646: /*========================================================================
647: | PUBLIC PROCEDURE duplicatePolicyLines
648: |

Line 669: p_from_policy_id IN ap_pol_headers.policy_id%TYPE,

665: | 16-May-2002 R Langi Created
666: |
667: *=======================================================================*/
668: PROCEDURE duplicatePolicyLines(p_user_id IN NUMBER,
669: p_from_policy_id IN ap_pol_headers.policy_id%TYPE,
670: p_from_schedule_period_id IN ap_pol_schedule_periods.schedule_period_id%TYPE,
671: p_to_policy_id IN ap_pol_headers.policy_id%TYPE,
672: p_to_schedule_period_id IN ap_pol_schedule_periods.schedule_period_id%TYPE);
673:

Line 671: p_to_policy_id IN ap_pol_headers.policy_id%TYPE,

667: *=======================================================================*/
668: PROCEDURE duplicatePolicyLines(p_user_id IN NUMBER,
669: p_from_policy_id IN ap_pol_headers.policy_id%TYPE,
670: p_from_schedule_period_id IN ap_pol_schedule_periods.schedule_period_id%TYPE,
671: p_to_policy_id IN ap_pol_headers.policy_id%TYPE,
672: p_to_schedule_period_id IN ap_pol_schedule_periods.schedule_period_id%TYPE);
673:
674: /*========================================================================
675: | PUBLIC PROCEDURE preservePolicyLine

Line 817: p_from_policy_id IN ap_pol_headers.policy_id%TYPE,

813: | 16-May-2002 R Langi Created
814: |
815: *=======================================================================*/
816: PROCEDURE duplicatePolicy(p_user_id IN NUMBER,
817: p_from_policy_id IN ap_pol_headers.policy_id%TYPE,
818: p_new_policy_id OUT NOCOPY ap_pol_headers.policy_id%TYPE);
819:
820: /*========================================================================
821: | PUBLIC FUNCTION active_option_exists

Line 818: p_new_policy_id OUT NOCOPY ap_pol_headers.policy_id%TYPE);

814: |
815: *=======================================================================*/
816: PROCEDURE duplicatePolicy(p_user_id IN NUMBER,
817: p_from_policy_id IN ap_pol_headers.policy_id%TYPE,
818: p_new_policy_id OUT NOCOPY ap_pol_headers.policy_id%TYPE);
819:
820: /*========================================================================
821: | PUBLIC FUNCTION active_option_exists
822: |

Line 985: FUNCTION are_exp_type_enddates_capped(p_policy_id IN ap_pol_headers.policy_id%TYPE,

981: | Date Author Description of Changes
982: | 31-JUL-2002 Mohammad Shoaib Jamall Created
983: |
984: *=======================================================================*/
985: FUNCTION are_exp_type_enddates_capped(p_policy_id IN ap_pol_headers.policy_id%TYPE,
986: p_end_date IN ap_pol_headers.end_date%TYPE DEFAULT NULL) RETURN VARCHAR2;
987:
988: /*========================================================================
989: | PUBLIC FUNCTION cap_expense_type_enddates

Line 986: p_end_date IN ap_pol_headers.end_date%TYPE DEFAULT NULL) RETURN VARCHAR2;

982: | 31-JUL-2002 Mohammad Shoaib Jamall Created
983: |
984: *=======================================================================*/
985: FUNCTION are_exp_type_enddates_capped(p_policy_id IN ap_pol_headers.policy_id%TYPE,
986: p_end_date IN ap_pol_headers.end_date%TYPE DEFAULT NULL) RETURN VARCHAR2;
987:
988: /*========================================================================
989: | PUBLIC FUNCTION cap_expense_type_enddates
990: |

Line 1007: PROCEDURE cap_expense_type_enddates(p_policy_id IN ap_pol_headers.policy_id%TYPE,

1003: | Date Author Description of Changes
1004: | 31-JUL-2002 Mohammad Shoaib Jamall Created
1005: |
1006: *=======================================================================*/
1007: PROCEDURE cap_expense_type_enddates(p_policy_id IN ap_pol_headers.policy_id%TYPE,
1008: p_end_date IN ap_pol_headers.end_date%TYPE DEFAULT NULL);
1009:
1010:
1011: /*========================================================================

Line 1008: p_end_date IN ap_pol_headers.end_date%TYPE DEFAULT NULL);

1004: | 31-JUL-2002 Mohammad Shoaib Jamall Created
1005: |
1006: *=======================================================================*/
1007: PROCEDURE cap_expense_type_enddates(p_policy_id IN ap_pol_headers.policy_id%TYPE,
1008: p_end_date IN ap_pol_headers.end_date%TYPE DEFAULT NULL);
1009:
1010:
1011: /*========================================================================
1012: | PUBLIC PROCEDURE initialize_user_expense_options

Line 1208: FUNCTION isFirstPeriodRatesEnabled ( p_policy_id ap_pol_headers.policy_id%TYPE ) RETURN VARCHAR2;

1204: | Date Author Description of Changes
1205: | 10-Nov-2005 krmenon Created
1206: |
1207: *=======================================================================*/
1208: FUNCTION isFirstPeriodRatesEnabled ( p_policy_id ap_pol_headers.policy_id%TYPE ) RETURN VARCHAR2;
1209:
1210: /*========================================================================
1211: | PUBLIC FUNCTION isLastPeriodRatesEnabled
1212: |

Line 1231: FUNCTION isLastPeriodRatesEnabled ( p_policy_id ap_pol_headers.policy_id%TYPE ) RETURN VARCHAR2;

1227: | Date Author Description of Changes
1228: | 10-Nov-2005 krmenon Created
1229: |
1230: *=======================================================================*/
1231: FUNCTION isLastPeriodRatesEnabled ( p_policy_id ap_pol_headers.policy_id%TYPE ) RETURN VARCHAR2;
1232:
1233: /*========================================================================
1234: | PUBLIC FUNCTION isSameDayRatesEnabled
1235: |

Line 1254: FUNCTION isSameDayRatesEnabled ( p_policy_id ap_pol_headers.policy_id%TYPE ) RETURN VARCHAR2;

1250: | Date Author Description of Changes
1251: | 10-Nov-2005 krmenon Created
1252: |
1253: *=======================================================================*/
1254: FUNCTION isSameDayRatesEnabled ( p_policy_id ap_pol_headers.policy_id%TYPE ) RETURN VARCHAR2;
1255:
1256: /*========================================================================
1257: | PUBLIC FUNCTION isNightRatesEnabled
1258: |

Line 1277: FUNCTION isNightRatesEnabled(p_policy_id IN ap_pol_headers.policy_id%TYPE) RETURN VARCHAR2;

1273: | Date Author Description of Changes
1274: | 10-Nov-2005 krmenon Created
1275: |
1276: *=======================================================================*/
1277: FUNCTION isNightRatesEnabled(p_policy_id IN ap_pol_headers.policy_id%TYPE) RETURN VARCHAR2;
1278:
1279: /*========================================================================
1280: | PUBLIC FUNCTION isDateInSeason
1281: |