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_TXNGRP_PVT dependencies on CS_COVERAGE_TXN_GROUPS_S

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

1: PACKAGE BODY CS_TXNGRP_PVT AS
2: /* $Header: csctxngb.pls 115.1 99/07/16 08:56:05 porting ship $ */
3: FUNCTION get_seq_id RETURN NUMBER IS
4: CURSOR get_seq_id_csr IS
5: SELECT CS_COVERAGE_TXN_GROUPS_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 482: p_subinventory_code IN CS_COVERAGE_TXN_GROUPS.SUBINVENTORY_CODE%TYPE := NULL,

478: p_coverage_start_date IN CS_COVERAGE_TXN_GROUPS.COVERAGE_START_DATE%TYPE := NULL,
479: p_coverage_end_date IN CS_COVERAGE_TXN_GROUPS.COVERAGE_END_DATE%TYPE := NULL,
480: p_price_list_id IN NUMBER := NULL,
481: p_manufacturing_org_id IN NUMBER := NULL,
482: p_subinventory_code IN CS_COVERAGE_TXN_GROUPS.SUBINVENTORY_CODE%TYPE := NULL,
483: p_coverage_id IN NUMBER := NULL,
484: p_discount_id IN NUMBER := NULL,
485: p_business_process_id IN NUMBER := NULL,
486: p_sunday_end_time IN CS_COVERAGE_TXN_GROUPS.SUNDAY_END_TIME%TYPE := NULL,

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

482: p_subinventory_code IN CS_COVERAGE_TXN_GROUPS.SUBINVENTORY_CODE%TYPE := NULL,
483: p_coverage_id IN NUMBER := NULL,
484: p_discount_id IN NUMBER := NULL,
485: p_business_process_id IN NUMBER := NULL,
486: p_sunday_end_time IN CS_COVERAGE_TXN_GROUPS.SUNDAY_END_TIME%TYPE := NULL,
487: p_sunday_start_time IN CS_COVERAGE_TXN_GROUPS.SUNDAY_START_TIME%TYPE := NULL,
488: p_monday_start_time IN CS_COVERAGE_TXN_GROUPS.MONDAY_START_TIME%TYPE := NULL,
489: p_monday_end_time IN CS_COVERAGE_TXN_GROUPS.MONDAY_END_TIME%TYPE := NULL,
490: p_tuesday_start_time IN CS_COVERAGE_TXN_GROUPS.TUESDAY_START_TIME%TYPE := NULL,

Line 487: p_sunday_start_time IN CS_COVERAGE_TXN_GROUPS.SUNDAY_START_TIME%TYPE := NULL,

483: p_coverage_id IN NUMBER := NULL,
484: p_discount_id IN NUMBER := NULL,
485: p_business_process_id IN NUMBER := NULL,
486: p_sunday_end_time IN CS_COVERAGE_TXN_GROUPS.SUNDAY_END_TIME%TYPE := NULL,
487: p_sunday_start_time IN CS_COVERAGE_TXN_GROUPS.SUNDAY_START_TIME%TYPE := NULL,
488: p_monday_start_time IN CS_COVERAGE_TXN_GROUPS.MONDAY_START_TIME%TYPE := NULL,
489: p_monday_end_time IN CS_COVERAGE_TXN_GROUPS.MONDAY_END_TIME%TYPE := NULL,
490: p_tuesday_start_time IN CS_COVERAGE_TXN_GROUPS.TUESDAY_START_TIME%TYPE := NULL,
491: p_tuesday_end_time IN CS_COVERAGE_TXN_GROUPS.TUESDAY_END_TIME%TYPE := NULL,

Line 498: p_saturday_start_time IN CS_COVERAGE_TXN_GROUPS.SATURDAY_START_TIME%TYPE := NULL,

494: p_thursday_start_time IN CS_COVERAGE_TXN_GROUPS.THURSDAY_START_TIME%TYPE := NULL,
495: p_thursday_end_time IN CS_COVERAGE_TXN_GROUPS.THURSDAY_END_TIME%TYPE := NULL,
496: p_friday_start_time IN CS_COVERAGE_TXN_GROUPS.FRIDAY_START_TIME%TYPE := NULL,
497: p_friday_end_time IN CS_COVERAGE_TXN_GROUPS.FRIDAY_END_TIME%TYPE := NULL,
498: p_saturday_start_time IN CS_COVERAGE_TXN_GROUPS.SATURDAY_START_TIME%TYPE := NULL,
499: p_saturday_end_time IN CS_COVERAGE_TXN_GROUPS.SATURDAY_END_TIME%TYPE := NULL,
500: p_preferred_engineer1 IN CS_COVERAGE_TXN_GROUPS.PREFERRED_ENGINEER1%TYPE := NULL,
501: p_time_zone_id IN NUMBER := NULL,
502: p_preferred_engineer2 IN CS_COVERAGE_TXN_GROUPS.PREFERRED_ENGINEER2%TYPE := NULL,

Line 499: p_saturday_end_time IN CS_COVERAGE_TXN_GROUPS.SATURDAY_END_TIME%TYPE := NULL,

495: p_thursday_end_time IN CS_COVERAGE_TXN_GROUPS.THURSDAY_END_TIME%TYPE := NULL,
496: p_friday_start_time IN CS_COVERAGE_TXN_GROUPS.FRIDAY_START_TIME%TYPE := NULL,
497: p_friday_end_time IN CS_COVERAGE_TXN_GROUPS.FRIDAY_END_TIME%TYPE := NULL,
498: p_saturday_start_time IN CS_COVERAGE_TXN_GROUPS.SATURDAY_START_TIME%TYPE := NULL,
499: p_saturday_end_time IN CS_COVERAGE_TXN_GROUPS.SATURDAY_END_TIME%TYPE := NULL,
500: p_preferred_engineer1 IN CS_COVERAGE_TXN_GROUPS.PREFERRED_ENGINEER1%TYPE := NULL,
501: p_time_zone_id IN NUMBER := NULL,
502: p_preferred_engineer2 IN CS_COVERAGE_TXN_GROUPS.PREFERRED_ENGINEER2%TYPE := NULL,
503: p_last_update_date IN CS_COVERAGE_TXN_GROUPS.LAST_UPDATE_DATE%TYPE := NULL,

Line 1157: p_subinventory_code IN CS_COVERAGE_TXN_GROUPS.SUBINVENTORY_CODE%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

1153: p_coverage_start_date IN CS_COVERAGE_TXN_GROUPS.COVERAGE_START_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1154: p_coverage_end_date IN CS_COVERAGE_TXN_GROUPS.COVERAGE_END_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1155: p_price_list_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1156: p_manufacturing_org_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1157: p_subinventory_code IN CS_COVERAGE_TXN_GROUPS.SUBINVENTORY_CODE%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1158: p_coverage_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1159: p_discount_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1160: p_business_process_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1161: p_sunday_end_time IN CS_COVERAGE_TXN_GROUPS.SUNDAY_END_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,

Line 1161: p_sunday_end_time IN CS_COVERAGE_TXN_GROUPS.SUNDAY_END_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,

1157: p_subinventory_code IN CS_COVERAGE_TXN_GROUPS.SUBINVENTORY_CODE%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1158: p_coverage_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1159: p_discount_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1160: p_business_process_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1161: p_sunday_end_time IN CS_COVERAGE_TXN_GROUPS.SUNDAY_END_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1162: p_sunday_start_time IN CS_COVERAGE_TXN_GROUPS.SUNDAY_START_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1163: p_monday_start_time IN CS_COVERAGE_TXN_GROUPS.MONDAY_START_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1164: p_monday_end_time IN CS_COVERAGE_TXN_GROUPS.MONDAY_END_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1165: p_tuesday_start_time IN CS_COVERAGE_TXN_GROUPS.TUESDAY_START_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,

Line 1162: p_sunday_start_time IN CS_COVERAGE_TXN_GROUPS.SUNDAY_START_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,

1158: p_coverage_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1159: p_discount_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1160: p_business_process_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1161: p_sunday_end_time IN CS_COVERAGE_TXN_GROUPS.SUNDAY_END_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1162: p_sunday_start_time IN CS_COVERAGE_TXN_GROUPS.SUNDAY_START_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1163: p_monday_start_time IN CS_COVERAGE_TXN_GROUPS.MONDAY_START_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1164: p_monday_end_time IN CS_COVERAGE_TXN_GROUPS.MONDAY_END_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1165: p_tuesday_start_time IN CS_COVERAGE_TXN_GROUPS.TUESDAY_START_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1166: p_tuesday_end_time IN CS_COVERAGE_TXN_GROUPS.TUESDAY_END_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,

Line 1173: p_saturday_start_time IN CS_COVERAGE_TXN_GROUPS.SATURDAY_START_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,

1169: p_thursday_start_time IN CS_COVERAGE_TXN_GROUPS.THURSDAY_START_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1170: p_thursday_end_time IN CS_COVERAGE_TXN_GROUPS.THURSDAY_END_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1171: p_friday_start_time IN CS_COVERAGE_TXN_GROUPS.FRIDAY_START_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1172: p_friday_end_time IN CS_COVERAGE_TXN_GROUPS.FRIDAY_END_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1173: p_saturday_start_time IN CS_COVERAGE_TXN_GROUPS.SATURDAY_START_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1174: p_saturday_end_time IN CS_COVERAGE_TXN_GROUPS.SATURDAY_END_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1175: p_preferred_engineer1 IN CS_COVERAGE_TXN_GROUPS.PREFERRED_ENGINEER1%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1176: p_time_zone_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1177: p_preferred_engineer2 IN CS_COVERAGE_TXN_GROUPS.PREFERRED_ENGINEER2%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

Line 1174: p_saturday_end_time IN CS_COVERAGE_TXN_GROUPS.SATURDAY_END_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,

1170: p_thursday_end_time IN CS_COVERAGE_TXN_GROUPS.THURSDAY_END_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1171: p_friday_start_time IN CS_COVERAGE_TXN_GROUPS.FRIDAY_START_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1172: p_friday_end_time IN CS_COVERAGE_TXN_GROUPS.FRIDAY_END_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1173: p_saturday_start_time IN CS_COVERAGE_TXN_GROUPS.SATURDAY_START_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1174: p_saturday_end_time IN CS_COVERAGE_TXN_GROUPS.SATURDAY_END_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1175: p_preferred_engineer1 IN CS_COVERAGE_TXN_GROUPS.PREFERRED_ENGINEER1%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1176: p_time_zone_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1177: p_preferred_engineer2 IN CS_COVERAGE_TXN_GROUPS.PREFERRED_ENGINEER2%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1178: p_last_update_date IN CS_COVERAGE_TXN_GROUPS.LAST_UPDATE_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,

Line 1483: p_subinventory_code IN CS_COVERAGE_TXN_GROUPS.SUBINVENTORY_CODE%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

1479: p_coverage_start_date IN CS_COVERAGE_TXN_GROUPS.COVERAGE_START_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1480: p_coverage_end_date IN CS_COVERAGE_TXN_GROUPS.COVERAGE_END_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1481: p_price_list_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1482: p_manufacturing_org_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1483: p_subinventory_code IN CS_COVERAGE_TXN_GROUPS.SUBINVENTORY_CODE%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1484: p_coverage_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1485: p_discount_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1486: p_business_process_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1487: p_sunday_end_time IN CS_COVERAGE_TXN_GROUPS.SUNDAY_END_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,

Line 1487: p_sunday_end_time IN CS_COVERAGE_TXN_GROUPS.SUNDAY_END_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,

1483: p_subinventory_code IN CS_COVERAGE_TXN_GROUPS.SUBINVENTORY_CODE%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1484: p_coverage_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1485: p_discount_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1486: p_business_process_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1487: p_sunday_end_time IN CS_COVERAGE_TXN_GROUPS.SUNDAY_END_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1488: p_sunday_start_time IN CS_COVERAGE_TXN_GROUPS.SUNDAY_START_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1489: p_monday_start_time IN CS_COVERAGE_TXN_GROUPS.MONDAY_START_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1490: p_monday_end_time IN CS_COVERAGE_TXN_GROUPS.MONDAY_END_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1491: p_tuesday_start_time IN CS_COVERAGE_TXN_GROUPS.TUESDAY_START_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,

Line 1488: p_sunday_start_time IN CS_COVERAGE_TXN_GROUPS.SUNDAY_START_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,

1484: p_coverage_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1485: p_discount_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1486: p_business_process_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1487: p_sunday_end_time IN CS_COVERAGE_TXN_GROUPS.SUNDAY_END_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1488: p_sunday_start_time IN CS_COVERAGE_TXN_GROUPS.SUNDAY_START_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1489: p_monday_start_time IN CS_COVERAGE_TXN_GROUPS.MONDAY_START_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1490: p_monday_end_time IN CS_COVERAGE_TXN_GROUPS.MONDAY_END_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1491: p_tuesday_start_time IN CS_COVERAGE_TXN_GROUPS.TUESDAY_START_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1492: p_tuesday_end_time IN CS_COVERAGE_TXN_GROUPS.TUESDAY_END_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,

Line 1499: p_saturday_start_time IN CS_COVERAGE_TXN_GROUPS.SATURDAY_START_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,

1495: p_thursday_start_time IN CS_COVERAGE_TXN_GROUPS.THURSDAY_START_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1496: p_thursday_end_time IN CS_COVERAGE_TXN_GROUPS.THURSDAY_END_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1497: p_friday_start_time IN CS_COVERAGE_TXN_GROUPS.FRIDAY_START_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1498: p_friday_end_time IN CS_COVERAGE_TXN_GROUPS.FRIDAY_END_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1499: p_saturday_start_time IN CS_COVERAGE_TXN_GROUPS.SATURDAY_START_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1500: p_saturday_end_time IN CS_COVERAGE_TXN_GROUPS.SATURDAY_END_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1501: p_preferred_engineer1 IN CS_COVERAGE_TXN_GROUPS.PREFERRED_ENGINEER1%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1502: p_time_zone_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1503: p_preferred_engineer2 IN CS_COVERAGE_TXN_GROUPS.PREFERRED_ENGINEER2%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

Line 1500: p_saturday_end_time IN CS_COVERAGE_TXN_GROUPS.SATURDAY_END_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,

1496: p_thursday_end_time IN CS_COVERAGE_TXN_GROUPS.THURSDAY_END_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1497: p_friday_start_time IN CS_COVERAGE_TXN_GROUPS.FRIDAY_START_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1498: p_friday_end_time IN CS_COVERAGE_TXN_GROUPS.FRIDAY_END_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1499: p_saturday_start_time IN CS_COVERAGE_TXN_GROUPS.SATURDAY_START_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1500: p_saturday_end_time IN CS_COVERAGE_TXN_GROUPS.SATURDAY_END_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1501: p_preferred_engineer1 IN CS_COVERAGE_TXN_GROUPS.PREFERRED_ENGINEER1%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1502: p_time_zone_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1503: p_preferred_engineer2 IN CS_COVERAGE_TXN_GROUPS.PREFERRED_ENGINEER2%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1504: p_last_update_date IN CS_COVERAGE_TXN_GROUPS.LAST_UPDATE_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,