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.

[Home] [Help]

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 495: FUNCTION getHighEndOfThreshold(p_policy_id IN ap_pol_headers.policy_id%TYPE,

491: | Date Author Description of Changes
492: | 16-May-2002 R Langi Created
493: |
494: *=======================================================================*/
495: FUNCTION getHighEndOfThreshold(p_policy_id IN ap_pol_headers.policy_id%TYPE,
496: p_threshold IN ap_pol_schedule_options.threshold%TYPE) RETURN ap_pol_schedule_options.threshold%TYPE;
497:
498: /*========================================================================
499: | PUBLIC FUNCTION getHighEndOfThreshold

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

513: | Date Author Description of Changes
514: | 01-Nov-2005 krmenon Created
515: |
516: *=======================================================================*/
517: FUNCTION getHighEndOfThreshold(p_policy_id IN ap_pol_headers.policy_id%TYPE,
518: p_threshold IN ap_pol_schedule_options.threshold%TYPE,
519: p_rate_type IN ap_pol_schedule_options.rate_type_code%TYPE) RETURN ap_pol_schedule_options.threshold%TYPE;
520:
521: /*========================================================================

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

535: | Date Author Description of Changes
536: | 16-May-2002 R Langi Created
537: |
538: *=======================================================================*/
539: FUNCTION getPolicyCategoryCode(p_policy_id IN ap_pol_headers.policy_id%TYPE) RETURN ap_pol_headers.category_code%TYPE;
540:
541: /*========================================================================
542: | PUBLIC FUNCTION checkRuleOption
543: |

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

565: | Date Author Description of Changes
566: | 16-May-2002 R Langi Created
567: |
568: *=======================================================================*/
569: FUNCTION checkRuleOption(p_policy_id IN ap_pol_headers.policy_id%TYPE,
570: p_rule IN VARCHAR2) RETURN VARCHAR2;
571:
572: /*========================================================================
573: | PUBLIC FUNCTION getUnionStmtForRuleOption

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

588: | Date Author Description of Changes
589: | 16-May-2002 R Langi Created
590: |
591: *=======================================================================*/
592: FUNCTION getUnionStmtForRuleOption(p_policy_id IN ap_pol_headers.policy_id%TYPE,
593: p_rule IN VARCHAR2) RETURN VARCHAR2;
594:
595: /*========================================================================
596: | PUBLIC PROCEDURE permutatePolicyLines

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

615: | 16-May-2002 R Langi Created
616: |
617: *=======================================================================*/
618: PROCEDURE permutatePolicyLines(p_user_id IN NUMBER,
619: p_policy_id IN ap_pol_headers.policy_id%TYPE);
620:
621: /*========================================================================
622: | PUBLIC PROCEDURE removeObsoletedPolicyLines
623: |

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

636: | Date Author Description of Changes
637: | 16-May-2002 R Langi Created
638: |
639: *=======================================================================*/
640: PROCEDURE removeObsoletedPolicyLines(p_policy_id IN ap_pol_headers.policy_id%TYPE);
641:
642: /*========================================================================
643: | PUBLIC PROCEDURE updateInactivePolicyLines
644: |

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

656: | Date Author Description of Changes
657: | 16-May-2002 R Langi Created
658: |
659: *=======================================================================*/
660: PROCEDURE updateInactivePolicyLines(p_policy_id IN ap_pol_headers.policy_id%TYPE);
661:
662: /*========================================================================
663: | PUBLIC PROCEDURE duplicatePolicyLines
664: |

Line 685: p_from_policy_id IN ap_pol_headers.policy_id%TYPE,

681: | 16-May-2002 R Langi Created
682: |
683: *=======================================================================*/
684: PROCEDURE duplicatePolicyLines(p_user_id IN NUMBER,
685: p_from_policy_id IN ap_pol_headers.policy_id%TYPE,
686: p_from_schedule_period_id IN ap_pol_schedule_periods.schedule_period_id%TYPE,
687: p_to_policy_id IN ap_pol_headers.policy_id%TYPE,
688: p_to_schedule_period_id IN ap_pol_schedule_periods.schedule_period_id%TYPE);
689:

Line 687: p_to_policy_id IN ap_pol_headers.policy_id%TYPE,

683: *=======================================================================*/
684: PROCEDURE duplicatePolicyLines(p_user_id IN NUMBER,
685: p_from_policy_id IN ap_pol_headers.policy_id%TYPE,
686: p_from_schedule_period_id IN ap_pol_schedule_periods.schedule_period_id%TYPE,
687: p_to_policy_id IN ap_pol_headers.policy_id%TYPE,
688: p_to_schedule_period_id IN ap_pol_schedule_periods.schedule_period_id%TYPE);
689:
690: /*========================================================================
691: | PUBLIC PROCEDURE preservePolicyLine

Line 834: p_from_policy_id IN ap_pol_headers.policy_id%TYPE,

830: | 16-May-2002 R Langi Created
831: |
832: *=======================================================================*/
833: PROCEDURE duplicatePolicy(p_user_id IN NUMBER,
834: p_from_policy_id IN ap_pol_headers.policy_id%TYPE,
835: p_new_policy_id OUT NOCOPY ap_pol_headers.policy_id%TYPE);
836:
837: /*========================================================================
838: | PUBLIC FUNCTION active_option_exists

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

831: |
832: *=======================================================================*/
833: PROCEDURE duplicatePolicy(p_user_id IN NUMBER,
834: p_from_policy_id IN ap_pol_headers.policy_id%TYPE,
835: p_new_policy_id OUT NOCOPY ap_pol_headers.policy_id%TYPE);
836:
837: /*========================================================================
838: | PUBLIC FUNCTION active_option_exists
839: |

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

998: | Date Author Description of Changes
999: | 31-JUL-2002 Mohammad Shoaib Jamall Created
1000: |
1001: *=======================================================================*/
1002: FUNCTION are_exp_type_enddates_capped(p_policy_id IN ap_pol_headers.policy_id%TYPE,
1003: p_end_date IN ap_pol_headers.end_date%TYPE DEFAULT NULL) RETURN VARCHAR2;
1004:
1005: /*========================================================================
1006: | PUBLIC FUNCTION cap_expense_type_enddates

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

999: | 31-JUL-2002 Mohammad Shoaib Jamall Created
1000: |
1001: *=======================================================================*/
1002: FUNCTION are_exp_type_enddates_capped(p_policy_id IN ap_pol_headers.policy_id%TYPE,
1003: p_end_date IN ap_pol_headers.end_date%TYPE DEFAULT NULL) RETURN VARCHAR2;
1004:
1005: /*========================================================================
1006: | PUBLIC FUNCTION cap_expense_type_enddates
1007: |

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

1020: | Date Author Description of Changes
1021: | 31-JUL-2002 Mohammad Shoaib Jamall Created
1022: |
1023: *=======================================================================*/
1024: PROCEDURE cap_expense_type_enddates(p_policy_id IN ap_pol_headers.policy_id%TYPE,
1025: p_end_date IN ap_pol_headers.end_date%TYPE DEFAULT NULL);
1026:
1027:
1028: /*========================================================================

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

1021: | 31-JUL-2002 Mohammad Shoaib Jamall Created
1022: |
1023: *=======================================================================*/
1024: PROCEDURE cap_expense_type_enddates(p_policy_id IN ap_pol_headers.policy_id%TYPE,
1025: p_end_date IN ap_pol_headers.end_date%TYPE DEFAULT NULL);
1026:
1027:
1028: /*========================================================================
1029: | PUBLIC PROCEDURE initialize_user_expense_options

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

1221: | Date Author Description of Changes
1222: | 10-Nov-2005 krmenon Created
1223: |
1224: *=======================================================================*/
1225: FUNCTION isFirstPeriodRatesEnabled ( p_policy_id ap_pol_headers.policy_id%TYPE ) RETURN VARCHAR2;
1226:
1227: /*========================================================================
1228: | PUBLIC FUNCTION isLastPeriodRatesEnabled
1229: |

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

1244: | Date Author Description of Changes
1245: | 10-Nov-2005 krmenon Created
1246: |
1247: *=======================================================================*/
1248: FUNCTION isLastPeriodRatesEnabled ( p_policy_id ap_pol_headers.policy_id%TYPE ) RETURN VARCHAR2;
1249:
1250: /*========================================================================
1251: | PUBLIC FUNCTION isSameDayRatesEnabled
1252: |

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

1267: | Date Author Description of Changes
1268: | 10-Nov-2005 krmenon Created
1269: |
1270: *=======================================================================*/
1271: FUNCTION isSameDayRatesEnabled ( p_policy_id ap_pol_headers.policy_id%TYPE ) RETURN VARCHAR2;
1272:
1273: /*========================================================================
1274: | PUBLIC FUNCTION isNightRatesEnabled
1275: |

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

1290: | Date Author Description of Changes
1291: | 10-Nov-2005 krmenon Created
1292: |
1293: *=======================================================================*/
1294: FUNCTION isNightRatesEnabled(p_policy_id IN ap_pol_headers.policy_id%TYPE) RETURN VARCHAR2;
1295:
1296: /*========================================================================
1297: | PUBLIC FUNCTION isDateInSeason
1298: |