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.CS_COVERAGE_PVT dependencies on CS_COVERAGES_S

Line 5: SELECT CS_COVERAGES_S.nextval FROM SYS.DUAL;

1: PACKAGE BODY CS_COVERAGE_PVT AS
2: /* $Header: csctcovb.pls 115.1 99/07/16 08:50:27 porting ship $ */
3: FUNCTION get_seq_id RETURN NUMBER IS
4: CURSOR get_seq_id_csr IS
5: SELECT CS_COVERAGES_S.nextval FROM SYS.DUAL;
6: l_seq_id NUMBER := 0;
7: BEGIN
8: OPEN get_seq_id_csr;
9: FETCH get_seq_id_csr INTO l_seq_id;

Line 485: p_sunday_start_time IN CS_COVERAGES.SUNDAY_START_TIME%TYPE := NULL,

481: p_max_expense_billable_amount IN NUMBER := NULL,
482: p_max_coverage_amount IN NUMBER := NULL,
483: p_response_time_period_code IN CS_COVERAGES.RESPONSE_TIME_PERIOD_CODE%TYPE := NULL,
484: p_response_time_value IN NUMBER := NULL,
485: p_sunday_start_time IN CS_COVERAGES.SUNDAY_START_TIME%TYPE := NULL,
486: p_sunday_end_time IN CS_COVERAGES.SUNDAY_END_TIME%TYPE := NULL,
487: p_monday_start_time IN CS_COVERAGES.MONDAY_START_TIME%TYPE := NULL,
488: p_monday_end_time IN CS_COVERAGES.MONDAY_END_TIME%TYPE := NULL,
489: p_start_date_active IN CS_COVERAGES.START_DATE_ACTIVE%TYPE := NULL,

Line 486: p_sunday_end_time IN CS_COVERAGES.SUNDAY_END_TIME%TYPE := NULL,

482: p_max_coverage_amount IN NUMBER := NULL,
483: p_response_time_period_code IN CS_COVERAGES.RESPONSE_TIME_PERIOD_CODE%TYPE := NULL,
484: p_response_time_value IN NUMBER := NULL,
485: p_sunday_start_time IN CS_COVERAGES.SUNDAY_START_TIME%TYPE := NULL,
486: p_sunday_end_time IN CS_COVERAGES.SUNDAY_END_TIME%TYPE := NULL,
487: p_monday_start_time IN CS_COVERAGES.MONDAY_START_TIME%TYPE := NULL,
488: p_monday_end_time IN CS_COVERAGES.MONDAY_END_TIME%TYPE := NULL,
489: p_start_date_active IN CS_COVERAGES.START_DATE_ACTIVE%TYPE := NULL,
490: p_tuesday_start_time IN CS_COVERAGES.TUESDAY_START_TIME%TYPE := NULL,

Line 489: p_start_date_active IN CS_COVERAGES.START_DATE_ACTIVE%TYPE := NULL,

485: p_sunday_start_time IN CS_COVERAGES.SUNDAY_START_TIME%TYPE := NULL,
486: p_sunday_end_time IN CS_COVERAGES.SUNDAY_END_TIME%TYPE := NULL,
487: p_monday_start_time IN CS_COVERAGES.MONDAY_START_TIME%TYPE := NULL,
488: p_monday_end_time IN CS_COVERAGES.MONDAY_END_TIME%TYPE := NULL,
489: p_start_date_active IN CS_COVERAGES.START_DATE_ACTIVE%TYPE := NULL,
490: p_tuesday_start_time IN CS_COVERAGES.TUESDAY_START_TIME%TYPE := NULL,
491: p_tuesday_end_time IN CS_COVERAGES.TUESDAY_END_TIME%TYPE := NULL,
492: p_end_date_active IN CS_COVERAGES.END_DATE_ACTIVE%TYPE := NULL,
493: p_wednesday_start_time IN CS_COVERAGES.WEDNESDAY_START_TIME%TYPE := NULL,

Line 499: p_saturday_start_time IN CS_COVERAGES.SATURDAY_START_TIME%TYPE := NULL,

495: p_thursday_start_time IN CS_COVERAGES.THURSDAY_START_TIME%TYPE := NULL,
496: p_thursday_end_time IN CS_COVERAGES.THURSDAY_END_TIME%TYPE := NULL,
497: p_friday_start_time IN CS_COVERAGES.FRIDAY_START_TIME%TYPE := NULL,
498: p_friday_end_time IN CS_COVERAGES.FRIDAY_END_TIME%TYPE := NULL,
499: p_saturday_start_time IN CS_COVERAGES.SATURDAY_START_TIME%TYPE := NULL,
500: p_saturday_end_time IN CS_COVERAGES.SATURDAY_END_TIME%TYPE := NULL,
501: p_created_by IN NUMBER := NULL,
502: p_creation_date IN CS_COVERAGES.CREATION_DATE%TYPE := NULL,
503: p_last_update_date IN CS_COVERAGES.LAST_UPDATE_DATE%TYPE := NULL,

Line 500: p_saturday_end_time IN CS_COVERAGES.SATURDAY_END_TIME%TYPE := NULL,

496: p_thursday_end_time IN CS_COVERAGES.THURSDAY_END_TIME%TYPE := NULL,
497: p_friday_start_time IN CS_COVERAGES.FRIDAY_START_TIME%TYPE := NULL,
498: p_friday_end_time IN CS_COVERAGES.FRIDAY_END_TIME%TYPE := NULL,
499: p_saturday_start_time IN CS_COVERAGES.SATURDAY_START_TIME%TYPE := NULL,
500: p_saturday_end_time IN CS_COVERAGES.SATURDAY_END_TIME%TYPE := NULL,
501: p_created_by IN NUMBER := NULL,
502: p_creation_date IN CS_COVERAGES.CREATION_DATE%TYPE := NULL,
503: p_last_update_date IN CS_COVERAGES.LAST_UPDATE_DATE%TYPE := NULL,
504: p_last_updated_by IN NUMBER := NULL,

Line 1202: p_sunday_start_time IN CS_COVERAGES.SUNDAY_START_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,

1198: p_max_expense_billable_amount IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1199: p_max_coverage_amount IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1200: p_response_time_period_code IN CS_COVERAGES.RESPONSE_TIME_PERIOD_CODE%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1201: p_response_time_value IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1202: p_sunday_start_time IN CS_COVERAGES.SUNDAY_START_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1203: p_sunday_end_time IN CS_COVERAGES.SUNDAY_END_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1204: p_monday_start_time IN CS_COVERAGES.MONDAY_START_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1205: p_monday_end_time IN CS_COVERAGES.MONDAY_END_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1206: p_start_date_active IN CS_COVERAGES.START_DATE_ACTIVE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,

Line 1203: p_sunday_end_time IN CS_COVERAGES.SUNDAY_END_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,

1199: p_max_coverage_amount IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1200: p_response_time_period_code IN CS_COVERAGES.RESPONSE_TIME_PERIOD_CODE%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1201: p_response_time_value IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1202: p_sunday_start_time IN CS_COVERAGES.SUNDAY_START_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1203: p_sunday_end_time IN CS_COVERAGES.SUNDAY_END_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1204: p_monday_start_time IN CS_COVERAGES.MONDAY_START_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1205: p_monday_end_time IN CS_COVERAGES.MONDAY_END_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1206: p_start_date_active IN CS_COVERAGES.START_DATE_ACTIVE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1207: p_tuesday_start_time IN CS_COVERAGES.TUESDAY_START_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,

Line 1206: p_start_date_active IN CS_COVERAGES.START_DATE_ACTIVE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,

1202: p_sunday_start_time IN CS_COVERAGES.SUNDAY_START_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1203: p_sunday_end_time IN CS_COVERAGES.SUNDAY_END_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1204: p_monday_start_time IN CS_COVERAGES.MONDAY_START_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1205: p_monday_end_time IN CS_COVERAGES.MONDAY_END_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1206: p_start_date_active IN CS_COVERAGES.START_DATE_ACTIVE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1207: p_tuesday_start_time IN CS_COVERAGES.TUESDAY_START_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1208: p_tuesday_end_time IN CS_COVERAGES.TUESDAY_END_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1209: p_end_date_active IN CS_COVERAGES.END_DATE_ACTIVE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1210: p_wednesday_start_time IN CS_COVERAGES.WEDNESDAY_START_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,

Line 1216: p_saturday_start_time IN CS_COVERAGES.SATURDAY_START_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,

1212: p_thursday_start_time IN CS_COVERAGES.THURSDAY_START_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1213: p_thursday_end_time IN CS_COVERAGES.THURSDAY_END_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1214: p_friday_start_time IN CS_COVERAGES.FRIDAY_START_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1215: p_friday_end_time IN CS_COVERAGES.FRIDAY_END_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1216: p_saturday_start_time IN CS_COVERAGES.SATURDAY_START_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1217: p_saturday_end_time IN CS_COVERAGES.SATURDAY_END_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1218: p_created_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1219: p_creation_date IN CS_COVERAGES.CREATION_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1220: p_last_update_date IN CS_COVERAGES.LAST_UPDATE_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,

Line 1217: p_saturday_end_time IN CS_COVERAGES.SATURDAY_END_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,

1213: p_thursday_end_time IN CS_COVERAGES.THURSDAY_END_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1214: p_friday_start_time IN CS_COVERAGES.FRIDAY_START_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1215: p_friday_end_time IN CS_COVERAGES.FRIDAY_END_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1216: p_saturday_start_time IN CS_COVERAGES.SATURDAY_START_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1217: p_saturday_end_time IN CS_COVERAGES.SATURDAY_END_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1218: p_created_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1219: p_creation_date IN CS_COVERAGES.CREATION_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1220: p_last_update_date IN CS_COVERAGES.LAST_UPDATE_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1221: p_last_updated_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,

Line 1540: p_sunday_start_time IN CS_COVERAGES.SUNDAY_START_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,

1536: p_max_expense_billable_amount IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1537: p_max_coverage_amount IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1538: p_response_time_period_code IN CS_COVERAGES.RESPONSE_TIME_PERIOD_CODE%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1539: p_response_time_value IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1540: p_sunday_start_time IN CS_COVERAGES.SUNDAY_START_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1541: p_sunday_end_time IN CS_COVERAGES.SUNDAY_END_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1542: p_monday_start_time IN CS_COVERAGES.MONDAY_START_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1543: p_monday_end_time IN CS_COVERAGES.MONDAY_END_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1544: p_start_date_active IN CS_COVERAGES.START_DATE_ACTIVE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,

Line 1541: p_sunday_end_time IN CS_COVERAGES.SUNDAY_END_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,

1537: p_max_coverage_amount IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1538: p_response_time_period_code IN CS_COVERAGES.RESPONSE_TIME_PERIOD_CODE%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1539: p_response_time_value IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1540: p_sunday_start_time IN CS_COVERAGES.SUNDAY_START_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1541: p_sunday_end_time IN CS_COVERAGES.SUNDAY_END_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1542: p_monday_start_time IN CS_COVERAGES.MONDAY_START_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1543: p_monday_end_time IN CS_COVERAGES.MONDAY_END_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1544: p_start_date_active IN CS_COVERAGES.START_DATE_ACTIVE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1545: p_tuesday_start_time IN CS_COVERAGES.TUESDAY_START_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,

Line 1544: p_start_date_active IN CS_COVERAGES.START_DATE_ACTIVE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,

1540: p_sunday_start_time IN CS_COVERAGES.SUNDAY_START_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1541: p_sunday_end_time IN CS_COVERAGES.SUNDAY_END_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1542: p_monday_start_time IN CS_COVERAGES.MONDAY_START_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1543: p_monday_end_time IN CS_COVERAGES.MONDAY_END_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1544: p_start_date_active IN CS_COVERAGES.START_DATE_ACTIVE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1545: p_tuesday_start_time IN CS_COVERAGES.TUESDAY_START_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1546: p_tuesday_end_time IN CS_COVERAGES.TUESDAY_END_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1547: p_end_date_active IN CS_COVERAGES.END_DATE_ACTIVE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1548: p_wednesday_start_time IN CS_COVERAGES.WEDNESDAY_START_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,

Line 1554: p_saturday_start_time IN CS_COVERAGES.SATURDAY_START_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,

1550: p_thursday_start_time IN CS_COVERAGES.THURSDAY_START_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1551: p_thursday_end_time IN CS_COVERAGES.THURSDAY_END_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1552: p_friday_start_time IN CS_COVERAGES.FRIDAY_START_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1553: p_friday_end_time IN CS_COVERAGES.FRIDAY_END_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1554: p_saturday_start_time IN CS_COVERAGES.SATURDAY_START_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1555: p_saturday_end_time IN CS_COVERAGES.SATURDAY_END_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1556: p_created_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1557: p_creation_date IN CS_COVERAGES.CREATION_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1558: p_last_update_date IN CS_COVERAGES.LAST_UPDATE_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,

Line 1555: p_saturday_end_time IN CS_COVERAGES.SATURDAY_END_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,

1551: p_thursday_end_time IN CS_COVERAGES.THURSDAY_END_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1552: p_friday_start_time IN CS_COVERAGES.FRIDAY_START_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1553: p_friday_end_time IN CS_COVERAGES.FRIDAY_END_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1554: p_saturday_start_time IN CS_COVERAGES.SATURDAY_START_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1555: p_saturday_end_time IN CS_COVERAGES.SATURDAY_END_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1556: p_created_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1557: p_creation_date IN CS_COVERAGES.CREATION_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1558: p_last_update_date IN CS_COVERAGES.LAST_UPDATE_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1559: p_last_updated_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,