APPS.CS_TXNGRP_PVT dependencies on CS_COVERAGE_TXN_GROUPS

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 326: INSERT INTO CS_COVERAGE_TXN_GROUPS(

322: END IF;
323: END IF;
324: -- Set primary key value
325: l_def_txngrp_rec.coverage_txn_group_id := get_seq_id;
326: INSERT INTO CS_COVERAGE_TXN_GROUPS(
327: coverage_txn_group_id,
328: offset_duration,
329: offset_period,
330: coverage_start_date,

Line 477: p_offset_period IN CS_COVERAGE_TXN_GROUPS.OFFSET_PERIOD%TYPE := NULL,

473: x_return_status OUT VARCHAR2,
474: x_msg_count OUT NUMBER,
475: x_msg_data OUT VARCHAR2,
476: p_offset_duration IN NUMBER := NULL,
477: p_offset_period IN CS_COVERAGE_TXN_GROUPS.OFFSET_PERIOD%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,

Line 478: p_coverage_start_date IN CS_COVERAGE_TXN_GROUPS.COVERAGE_START_DATE%TYPE := NULL,

474: x_msg_count OUT NUMBER,
475: x_msg_data OUT VARCHAR2,
476: p_offset_duration IN NUMBER := NULL,
477: p_offset_period IN CS_COVERAGE_TXN_GROUPS.OFFSET_PERIOD%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,

Line 479: p_coverage_end_date IN CS_COVERAGE_TXN_GROUPS.COVERAGE_END_DATE%TYPE := NULL,

475: x_msg_data OUT VARCHAR2,
476: p_offset_duration IN NUMBER := NULL,
477: p_offset_period IN CS_COVERAGE_TXN_GROUPS.OFFSET_PERIOD%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,

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 488: p_monday_start_time IN CS_COVERAGE_TXN_GROUPS.MONDAY_START_TIME%TYPE := 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,
492: p_wednesday_start_time IN CS_COVERAGE_TXN_GROUPS.WEDNESDAY_START_TIME%TYPE := NULL,

Line 489: p_monday_end_time IN CS_COVERAGE_TXN_GROUPS.MONDAY_END_TIME%TYPE := 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,
492: p_wednesday_start_time IN CS_COVERAGE_TXN_GROUPS.WEDNESDAY_START_TIME%TYPE := NULL,
493: p_wednesday_end_time IN CS_COVERAGE_TXN_GROUPS.WEDNESDAY_END_TIME%TYPE := NULL,

Line 490: p_tuesday_start_time IN CS_COVERAGE_TXN_GROUPS.TUESDAY_START_TIME%TYPE := 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,
492: p_wednesday_start_time IN CS_COVERAGE_TXN_GROUPS.WEDNESDAY_START_TIME%TYPE := NULL,
493: p_wednesday_end_time IN CS_COVERAGE_TXN_GROUPS.WEDNESDAY_END_TIME%TYPE := NULL,
494: p_thursday_start_time IN CS_COVERAGE_TXN_GROUPS.THURSDAY_START_TIME%TYPE := NULL,

Line 491: p_tuesday_end_time IN CS_COVERAGE_TXN_GROUPS.TUESDAY_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,
492: p_wednesday_start_time IN CS_COVERAGE_TXN_GROUPS.WEDNESDAY_START_TIME%TYPE := NULL,
493: p_wednesday_end_time IN CS_COVERAGE_TXN_GROUPS.WEDNESDAY_END_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,

Line 492: p_wednesday_start_time IN CS_COVERAGE_TXN_GROUPS.WEDNESDAY_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,
492: p_wednesday_start_time IN CS_COVERAGE_TXN_GROUPS.WEDNESDAY_START_TIME%TYPE := NULL,
493: p_wednesday_end_time IN CS_COVERAGE_TXN_GROUPS.WEDNESDAY_END_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,

Line 493: p_wednesday_end_time IN CS_COVERAGE_TXN_GROUPS.WEDNESDAY_END_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,
492: p_wednesday_start_time IN CS_COVERAGE_TXN_GROUPS.WEDNESDAY_START_TIME%TYPE := NULL,
493: p_wednesday_end_time IN CS_COVERAGE_TXN_GROUPS.WEDNESDAY_END_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,

Line 494: p_thursday_start_time IN CS_COVERAGE_TXN_GROUPS.THURSDAY_START_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,
492: p_wednesday_start_time IN CS_COVERAGE_TXN_GROUPS.WEDNESDAY_START_TIME%TYPE := NULL,
493: p_wednesday_end_time IN CS_COVERAGE_TXN_GROUPS.WEDNESDAY_END_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,

Line 495: p_thursday_end_time IN CS_COVERAGE_TXN_GROUPS.THURSDAY_END_TIME%TYPE := NULL,

491: p_tuesday_end_time IN CS_COVERAGE_TXN_GROUPS.TUESDAY_END_TIME%TYPE := NULL,
492: p_wednesday_start_time IN CS_COVERAGE_TXN_GROUPS.WEDNESDAY_START_TIME%TYPE := NULL,
493: p_wednesday_end_time IN CS_COVERAGE_TXN_GROUPS.WEDNESDAY_END_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,

Line 496: p_friday_start_time IN CS_COVERAGE_TXN_GROUPS.FRIDAY_START_TIME%TYPE := NULL,

492: p_wednesday_start_time IN CS_COVERAGE_TXN_GROUPS.WEDNESDAY_START_TIME%TYPE := NULL,
493: p_wednesday_end_time IN CS_COVERAGE_TXN_GROUPS.WEDNESDAY_END_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,

Line 497: p_friday_end_time IN CS_COVERAGE_TXN_GROUPS.FRIDAY_END_TIME%TYPE := NULL,

493: p_wednesday_end_time IN CS_COVERAGE_TXN_GROUPS.WEDNESDAY_END_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,

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 500: p_preferred_engineer1 IN CS_COVERAGE_TXN_GROUPS.PREFERRED_ENGINEER1%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,
504: p_last_updated_by IN NUMBER := NULL,

Line 502: p_preferred_engineer2 IN CS_COVERAGE_TXN_GROUPS.PREFERRED_ENGINEER2%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,
504: p_last_updated_by IN NUMBER := NULL,
505: p_creation_date IN CS_COVERAGE_TXN_GROUPS.CREATION_DATE%TYPE := NULL,
506: p_created_by IN NUMBER := NULL,

Line 503: p_last_update_date IN CS_COVERAGE_TXN_GROUPS.LAST_UPDATE_DATE%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,
504: p_last_updated_by IN NUMBER := NULL,
505: p_creation_date IN CS_COVERAGE_TXN_GROUPS.CREATION_DATE%TYPE := NULL,
506: p_created_by IN NUMBER := NULL,
507: p_last_update_login IN NUMBER := NULL,

Line 505: p_creation_date IN CS_COVERAGE_TXN_GROUPS.CREATION_DATE%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,
504: p_last_updated_by IN NUMBER := NULL,
505: p_creation_date IN CS_COVERAGE_TXN_GROUPS.CREATION_DATE%TYPE := NULL,
506: p_created_by IN NUMBER := NULL,
507: p_last_update_login IN NUMBER := NULL,
508: p_attribute1 IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE1%TYPE := NULL,
509: p_attribute2 IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE2%TYPE := NULL,

Line 508: p_attribute1 IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE1%TYPE := NULL,

504: p_last_updated_by IN NUMBER := NULL,
505: p_creation_date IN CS_COVERAGE_TXN_GROUPS.CREATION_DATE%TYPE := NULL,
506: p_created_by IN NUMBER := NULL,
507: p_last_update_login IN NUMBER := NULL,
508: p_attribute1 IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE1%TYPE := NULL,
509: p_attribute2 IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE2%TYPE := NULL,
510: p_attribute3 IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE3%TYPE := NULL,
511: p_attribute4 IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE4%TYPE := NULL,
512: p_attribute5 IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE5%TYPE := NULL,

Line 509: p_attribute2 IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE2%TYPE := NULL,

505: p_creation_date IN CS_COVERAGE_TXN_GROUPS.CREATION_DATE%TYPE := NULL,
506: p_created_by IN NUMBER := NULL,
507: p_last_update_login IN NUMBER := NULL,
508: p_attribute1 IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE1%TYPE := NULL,
509: p_attribute2 IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE2%TYPE := NULL,
510: p_attribute3 IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE3%TYPE := NULL,
511: p_attribute4 IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE4%TYPE := NULL,
512: p_attribute5 IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE5%TYPE := NULL,
513: p_attribute6 IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE6%TYPE := NULL,

Line 510: p_attribute3 IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE3%TYPE := NULL,

506: p_created_by IN NUMBER := NULL,
507: p_last_update_login IN NUMBER := NULL,
508: p_attribute1 IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE1%TYPE := NULL,
509: p_attribute2 IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE2%TYPE := NULL,
510: p_attribute3 IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE3%TYPE := NULL,
511: p_attribute4 IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE4%TYPE := NULL,
512: p_attribute5 IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE5%TYPE := NULL,
513: p_attribute6 IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE6%TYPE := NULL,
514: p_attribute7 IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE7%TYPE := NULL,

Line 511: p_attribute4 IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE4%TYPE := NULL,

507: p_last_update_login IN NUMBER := NULL,
508: p_attribute1 IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE1%TYPE := NULL,
509: p_attribute2 IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE2%TYPE := NULL,
510: p_attribute3 IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE3%TYPE := NULL,
511: p_attribute4 IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE4%TYPE := NULL,
512: p_attribute5 IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE5%TYPE := NULL,
513: p_attribute6 IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE6%TYPE := NULL,
514: p_attribute7 IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE7%TYPE := NULL,
515: p_attribute8 IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE8%TYPE := NULL,

Line 512: p_attribute5 IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE5%TYPE := NULL,

508: p_attribute1 IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE1%TYPE := NULL,
509: p_attribute2 IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE2%TYPE := NULL,
510: p_attribute3 IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE3%TYPE := NULL,
511: p_attribute4 IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE4%TYPE := NULL,
512: p_attribute5 IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE5%TYPE := NULL,
513: p_attribute6 IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE6%TYPE := NULL,
514: p_attribute7 IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE7%TYPE := NULL,
515: p_attribute8 IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE8%TYPE := NULL,
516: p_attribute9 IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE9%TYPE := NULL,

Line 513: p_attribute6 IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE6%TYPE := NULL,

509: p_attribute2 IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE2%TYPE := NULL,
510: p_attribute3 IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE3%TYPE := NULL,
511: p_attribute4 IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE4%TYPE := NULL,
512: p_attribute5 IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE5%TYPE := NULL,
513: p_attribute6 IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE6%TYPE := NULL,
514: p_attribute7 IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE7%TYPE := NULL,
515: p_attribute8 IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE8%TYPE := NULL,
516: p_attribute9 IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE9%TYPE := NULL,
517: p_attribute10 IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE10%TYPE := NULL,

Line 514: p_attribute7 IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE7%TYPE := NULL,

510: p_attribute3 IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE3%TYPE := NULL,
511: p_attribute4 IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE4%TYPE := NULL,
512: p_attribute5 IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE5%TYPE := NULL,
513: p_attribute6 IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE6%TYPE := NULL,
514: p_attribute7 IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE7%TYPE := NULL,
515: p_attribute8 IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE8%TYPE := NULL,
516: p_attribute9 IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE9%TYPE := NULL,
517: p_attribute10 IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE10%TYPE := NULL,
518: p_attribute11 IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE11%TYPE := NULL,

Line 515: p_attribute8 IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE8%TYPE := NULL,

511: p_attribute4 IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE4%TYPE := NULL,
512: p_attribute5 IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE5%TYPE := NULL,
513: p_attribute6 IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE6%TYPE := NULL,
514: p_attribute7 IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE7%TYPE := NULL,
515: p_attribute8 IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE8%TYPE := NULL,
516: p_attribute9 IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE9%TYPE := NULL,
517: p_attribute10 IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE10%TYPE := NULL,
518: p_attribute11 IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE11%TYPE := NULL,
519: p_attribute12 IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE12%TYPE := NULL,

Line 516: p_attribute9 IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE9%TYPE := NULL,

512: p_attribute5 IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE5%TYPE := NULL,
513: p_attribute6 IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE6%TYPE := NULL,
514: p_attribute7 IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE7%TYPE := NULL,
515: p_attribute8 IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE8%TYPE := NULL,
516: p_attribute9 IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE9%TYPE := NULL,
517: p_attribute10 IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE10%TYPE := NULL,
518: p_attribute11 IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE11%TYPE := NULL,
519: p_attribute12 IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE12%TYPE := NULL,
520: p_attribute13 IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE13%TYPE := NULL,

Line 517: p_attribute10 IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE10%TYPE := NULL,

513: p_attribute6 IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE6%TYPE := NULL,
514: p_attribute7 IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE7%TYPE := NULL,
515: p_attribute8 IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE8%TYPE := NULL,
516: p_attribute9 IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE9%TYPE := NULL,
517: p_attribute10 IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE10%TYPE := NULL,
518: p_attribute11 IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE11%TYPE := NULL,
519: p_attribute12 IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE12%TYPE := NULL,
520: p_attribute13 IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE13%TYPE := NULL,
521: p_attribute14 IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE14%TYPE := NULL,

Line 518: p_attribute11 IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE11%TYPE := NULL,

514: p_attribute7 IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE7%TYPE := NULL,
515: p_attribute8 IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE8%TYPE := NULL,
516: p_attribute9 IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE9%TYPE := NULL,
517: p_attribute10 IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE10%TYPE := NULL,
518: p_attribute11 IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE11%TYPE := NULL,
519: p_attribute12 IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE12%TYPE := NULL,
520: p_attribute13 IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE13%TYPE := NULL,
521: p_attribute14 IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE14%TYPE := NULL,
522: p_attribute15 IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE15%TYPE := NULL,

Line 519: p_attribute12 IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE12%TYPE := NULL,

515: p_attribute8 IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE8%TYPE := NULL,
516: p_attribute9 IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE9%TYPE := NULL,
517: p_attribute10 IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE10%TYPE := NULL,
518: p_attribute11 IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE11%TYPE := NULL,
519: p_attribute12 IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE12%TYPE := NULL,
520: p_attribute13 IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE13%TYPE := NULL,
521: p_attribute14 IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE14%TYPE := NULL,
522: p_attribute15 IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE15%TYPE := NULL,
523: p_context IN CS_COVERAGE_TXN_GROUPS.CONTEXT%TYPE := NULL,

Line 520: p_attribute13 IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE13%TYPE := NULL,

516: p_attribute9 IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE9%TYPE := NULL,
517: p_attribute10 IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE10%TYPE := NULL,
518: p_attribute11 IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE11%TYPE := NULL,
519: p_attribute12 IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE12%TYPE := NULL,
520: p_attribute13 IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE13%TYPE := NULL,
521: p_attribute14 IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE14%TYPE := NULL,
522: p_attribute15 IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE15%TYPE := NULL,
523: p_context IN CS_COVERAGE_TXN_GROUPS.CONTEXT%TYPE := NULL,
524: p_object_version_number IN NUMBER := NULL,

Line 521: p_attribute14 IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE14%TYPE := NULL,

517: p_attribute10 IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE10%TYPE := NULL,
518: p_attribute11 IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE11%TYPE := NULL,
519: p_attribute12 IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE12%TYPE := NULL,
520: p_attribute13 IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE13%TYPE := NULL,
521: p_attribute14 IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE14%TYPE := NULL,
522: p_attribute15 IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE15%TYPE := NULL,
523: p_context IN CS_COVERAGE_TXN_GROUPS.CONTEXT%TYPE := NULL,
524: p_object_version_number IN NUMBER := NULL,
525: x_coverage_txn_group_id OUT NUMBER,

Line 522: p_attribute15 IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE15%TYPE := NULL,

518: p_attribute11 IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE11%TYPE := NULL,
519: p_attribute12 IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE12%TYPE := NULL,
520: p_attribute13 IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE13%TYPE := NULL,
521: p_attribute14 IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE14%TYPE := NULL,
522: p_attribute15 IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE15%TYPE := NULL,
523: p_context IN CS_COVERAGE_TXN_GROUPS.CONTEXT%TYPE := NULL,
524: p_object_version_number IN NUMBER := NULL,
525: x_coverage_txn_group_id OUT NUMBER,
526: x_object_version_number OUT NUMBER) IS

Line 523: p_context IN CS_COVERAGE_TXN_GROUPS.CONTEXT%TYPE := NULL,

519: p_attribute12 IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE12%TYPE := NULL,
520: p_attribute13 IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE13%TYPE := NULL,
521: p_attribute14 IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE14%TYPE := NULL,
522: p_attribute15 IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE15%TYPE := NULL,
523: p_context IN CS_COVERAGE_TXN_GROUPS.CONTEXT%TYPE := NULL,
524: p_object_version_number IN NUMBER := NULL,
525: x_coverage_txn_group_id OUT NUMBER,
526: x_object_version_number OUT NUMBER) IS
527: l_api_name CONSTANT VARCHAR2(30) := 'insert_row';

Line 656: FROM CS_COVERAGE_TXN_GROUPS

652: E_Resource_Busy EXCEPTION;
653: PRAGMA EXCEPTION_INIT(E_Resource_Busy, -00054);
654: CURSOR lock_csr IS
655: SELECT OBJECT_VERSION_NUMBER
656: FROM CS_COVERAGE_TXN_GROUPS
657: WHERE
658: COVERAGE_TXN_GROUP_ID = p_coverage_txn_group_id AND
659: OBJECT_VERSION_NUMBER = p_object_version_number
660: FOR UPDATE OF OBJECT_VERSION_NUMBER NOWAIT;

Line 664: FROM CS_COVERAGE_TXN_GROUPS

660: FOR UPDATE OF OBJECT_VERSION_NUMBER NOWAIT;
661:
662: CURSOR lchk_csr IS
663: SELECT OBJECT_VERSION_NUMBER
664: FROM CS_COVERAGE_TXN_GROUPS
665: WHERE
666: COVERAGE_TXN_GROUP_ID = p_coverage_txn_group_id
667: ;
668: l_api_name CONSTANT VARCHAR2(30) := 'lock_row';

Line 671: l_object_version_number CS_COVERAGE_TXN_GROUPS.OBJECT_VERSION_NUMBER%TYPE;

667: ;
668: l_api_name CONSTANT VARCHAR2(30) := 'lock_row';
669: l_api_version CONSTANT NUMBER := 1;
670: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
671: l_object_version_number CS_COVERAGE_TXN_GROUPS.OBJECT_VERSION_NUMBER%TYPE;
672: lc_object_version_number CS_COVERAGE_TXN_GROUPS.OBJECT_VERSION_NUMBER%TYPE;
673: l_row_notfound BOOLEAN := FALSE;
674: lc_row_notfound BOOLEAN := FALSE;
675: BEGIN

Line 672: lc_object_version_number CS_COVERAGE_TXN_GROUPS.OBJECT_VERSION_NUMBER%TYPE;

668: l_api_name CONSTANT VARCHAR2(30) := 'lock_row';
669: l_api_version CONSTANT NUMBER := 1;
670: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
671: l_object_version_number CS_COVERAGE_TXN_GROUPS.OBJECT_VERSION_NUMBER%TYPE;
672: lc_object_version_number CS_COVERAGE_TXN_GROUPS.OBJECT_VERSION_NUMBER%TYPE;
673: l_row_notfound BOOLEAN := FALSE;
674: lc_row_notfound BOOLEAN := FALSE;
675: BEGIN
676: l_return_status := TAPI_DEV_KIT.START_ACTIVITY(l_api_name,

Line 777: CURSOR cs_coverage_txn_groups_pk_csr (p_coverage_txn_group_id IN NUMBER) IS

773: FUNCTION populate_new_record (
774: p_txngrp_rec IN TxnGrp_Rec_Type,
775: x_txngrp_rec OUT TxnGrp_Rec_Type
776: ) RETURN VARCHAR2 IS
777: CURSOR cs_coverage_txn_groups_pk_csr (p_coverage_txn_group_id IN NUMBER) IS
778: SELECT *
779: FROM Cs_Coverage_Txn_Groups
780: WHERE cs_coverage_txn_groups.coverage_txn_group_id = p_coverage_txn_group_id;
781: l_cs_coverage_txn_groups_pk cs_coverage_txn_groups_pk_csr%ROWTYPE;

Line 779: FROM Cs_Coverage_Txn_Groups

775: x_txngrp_rec OUT TxnGrp_Rec_Type
776: ) RETURN VARCHAR2 IS
777: CURSOR cs_coverage_txn_groups_pk_csr (p_coverage_txn_group_id IN NUMBER) IS
778: SELECT *
779: FROM Cs_Coverage_Txn_Groups
780: WHERE cs_coverage_txn_groups.coverage_txn_group_id = p_coverage_txn_group_id;
781: l_cs_coverage_txn_groups_pk cs_coverage_txn_groups_pk_csr%ROWTYPE;
782: l_row_notfound BOOLEAN := TRUE;
783: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;

Line 780: WHERE cs_coverage_txn_groups.coverage_txn_group_id = p_coverage_txn_group_id;

776: ) RETURN VARCHAR2 IS
777: CURSOR cs_coverage_txn_groups_pk_csr (p_coverage_txn_group_id IN NUMBER) IS
778: SELECT *
779: FROM Cs_Coverage_Txn_Groups
780: WHERE cs_coverage_txn_groups.coverage_txn_group_id = p_coverage_txn_group_id;
781: l_cs_coverage_txn_groups_pk cs_coverage_txn_groups_pk_csr%ROWTYPE;
782: l_row_notfound BOOLEAN := TRUE;
783: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
784: BEGIN

Line 781: l_cs_coverage_txn_groups_pk cs_coverage_txn_groups_pk_csr%ROWTYPE;

777: CURSOR cs_coverage_txn_groups_pk_csr (p_coverage_txn_group_id IN NUMBER) IS
778: SELECT *
779: FROM Cs_Coverage_Txn_Groups
780: WHERE cs_coverage_txn_groups.coverage_txn_group_id = p_coverage_txn_group_id;
781: l_cs_coverage_txn_groups_pk cs_coverage_txn_groups_pk_csr%ROWTYPE;
782: l_row_notfound BOOLEAN := TRUE;
783: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
784: BEGIN
785: x_txngrp_rec := p_txngrp_rec;

Line 787: OPEN cs_coverage_txn_groups_pk_csr (p_txngrp_rec.coverage_txn_group_id);

783: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
784: BEGIN
785: x_txngrp_rec := p_txngrp_rec;
786: -- Get current database values
787: OPEN cs_coverage_txn_groups_pk_csr (p_txngrp_rec.coverage_txn_group_id);
788: FETCH cs_coverage_txn_groups_pk_csr INTO l_cs_coverage_txn_groups_pk;
789: l_row_notfound := cs_coverage_txn_groups_pk_csr%NOTFOUND;
790: CLOSE cs_coverage_txn_groups_pk_csr;
791: IF (l_row_notfound) THEN

Line 788: FETCH cs_coverage_txn_groups_pk_csr INTO l_cs_coverage_txn_groups_pk;

784: BEGIN
785: x_txngrp_rec := p_txngrp_rec;
786: -- Get current database values
787: OPEN cs_coverage_txn_groups_pk_csr (p_txngrp_rec.coverage_txn_group_id);
788: FETCH cs_coverage_txn_groups_pk_csr INTO l_cs_coverage_txn_groups_pk;
789: l_row_notfound := cs_coverage_txn_groups_pk_csr%NOTFOUND;
790: CLOSE cs_coverage_txn_groups_pk_csr;
791: IF (l_row_notfound) THEN
792: l_return_status := FND_API.G_RET_STS_ERROR;

Line 789: l_row_notfound := cs_coverage_txn_groups_pk_csr%NOTFOUND;

785: x_txngrp_rec := p_txngrp_rec;
786: -- Get current database values
787: OPEN cs_coverage_txn_groups_pk_csr (p_txngrp_rec.coverage_txn_group_id);
788: FETCH cs_coverage_txn_groups_pk_csr INTO l_cs_coverage_txn_groups_pk;
789: l_row_notfound := cs_coverage_txn_groups_pk_csr%NOTFOUND;
790: CLOSE cs_coverage_txn_groups_pk_csr;
791: IF (l_row_notfound) THEN
792: l_return_status := FND_API.G_RET_STS_ERROR;
793: END IF;

Line 790: CLOSE cs_coverage_txn_groups_pk_csr;

786: -- Get current database values
787: OPEN cs_coverage_txn_groups_pk_csr (p_txngrp_rec.coverage_txn_group_id);
788: FETCH cs_coverage_txn_groups_pk_csr INTO l_cs_coverage_txn_groups_pk;
789: l_row_notfound := cs_coverage_txn_groups_pk_csr%NOTFOUND;
790: CLOSE cs_coverage_txn_groups_pk_csr;
791: IF (l_row_notfound) THEN
792: l_return_status := FND_API.G_RET_STS_ERROR;
793: END IF;
794: IF (x_txngrp_rec.coverage_txn_group_id = TAPI_DEV_KIT.G_MISS_NUM)

Line 796: x_txngrp_rec.coverage_txn_group_id := l_cs_coverage_txn_groups_pk.coverage_txn_group_id;

792: l_return_status := FND_API.G_RET_STS_ERROR;
793: END IF;
794: IF (x_txngrp_rec.coverage_txn_group_id = TAPI_DEV_KIT.G_MISS_NUM)
795: THEN
796: x_txngrp_rec.coverage_txn_group_id := l_cs_coverage_txn_groups_pk.coverage_txn_group_id;
797: END IF;
798: IF (x_txngrp_rec.offset_duration = TAPI_DEV_KIT.G_MISS_NUM)
799: THEN
800: x_txngrp_rec.offset_duration := l_cs_coverage_txn_groups_pk.offset_duration;

Line 800: x_txngrp_rec.offset_duration := l_cs_coverage_txn_groups_pk.offset_duration;

796: x_txngrp_rec.coverage_txn_group_id := l_cs_coverage_txn_groups_pk.coverage_txn_group_id;
797: END IF;
798: IF (x_txngrp_rec.offset_duration = TAPI_DEV_KIT.G_MISS_NUM)
799: THEN
800: x_txngrp_rec.offset_duration := l_cs_coverage_txn_groups_pk.offset_duration;
801: END IF;
802: IF (x_txngrp_rec.offset_period = TAPI_DEV_KIT.G_MISS_CHAR)
803: THEN
804: x_txngrp_rec.offset_period := l_cs_coverage_txn_groups_pk.offset_period;

Line 804: x_txngrp_rec.offset_period := l_cs_coverage_txn_groups_pk.offset_period;

800: x_txngrp_rec.offset_duration := l_cs_coverage_txn_groups_pk.offset_duration;
801: END IF;
802: IF (x_txngrp_rec.offset_period = TAPI_DEV_KIT.G_MISS_CHAR)
803: THEN
804: x_txngrp_rec.offset_period := l_cs_coverage_txn_groups_pk.offset_period;
805: END IF;
806: IF (x_txngrp_rec.coverage_start_date = TAPI_DEV_KIT.G_MISS_DATE)
807: THEN
808: x_txngrp_rec.coverage_start_date := l_cs_coverage_txn_groups_pk.coverage_start_date;

Line 808: x_txngrp_rec.coverage_start_date := l_cs_coverage_txn_groups_pk.coverage_start_date;

804: x_txngrp_rec.offset_period := l_cs_coverage_txn_groups_pk.offset_period;
805: END IF;
806: IF (x_txngrp_rec.coverage_start_date = TAPI_DEV_KIT.G_MISS_DATE)
807: THEN
808: x_txngrp_rec.coverage_start_date := l_cs_coverage_txn_groups_pk.coverage_start_date;
809: END IF;
810: IF (x_txngrp_rec.coverage_end_date = TAPI_DEV_KIT.G_MISS_DATE)
811: THEN
812: x_txngrp_rec.coverage_end_date := l_cs_coverage_txn_groups_pk.coverage_end_date;

Line 812: x_txngrp_rec.coverage_end_date := l_cs_coverage_txn_groups_pk.coverage_end_date;

808: x_txngrp_rec.coverage_start_date := l_cs_coverage_txn_groups_pk.coverage_start_date;
809: END IF;
810: IF (x_txngrp_rec.coverage_end_date = TAPI_DEV_KIT.G_MISS_DATE)
811: THEN
812: x_txngrp_rec.coverage_end_date := l_cs_coverage_txn_groups_pk.coverage_end_date;
813: END IF;
814: IF (x_txngrp_rec.price_list_id = TAPI_DEV_KIT.G_MISS_NUM)
815: THEN
816: x_txngrp_rec.price_list_id := l_cs_coverage_txn_groups_pk.price_list_id;

Line 816: x_txngrp_rec.price_list_id := l_cs_coverage_txn_groups_pk.price_list_id;

812: x_txngrp_rec.coverage_end_date := l_cs_coverage_txn_groups_pk.coverage_end_date;
813: END IF;
814: IF (x_txngrp_rec.price_list_id = TAPI_DEV_KIT.G_MISS_NUM)
815: THEN
816: x_txngrp_rec.price_list_id := l_cs_coverage_txn_groups_pk.price_list_id;
817: END IF;
818: IF (x_txngrp_rec.manufacturing_org_id = TAPI_DEV_KIT.G_MISS_NUM)
819: THEN
820: x_txngrp_rec.manufacturing_org_id := l_cs_coverage_txn_groups_pk.manufacturing_org_id;

Line 820: x_txngrp_rec.manufacturing_org_id := l_cs_coverage_txn_groups_pk.manufacturing_org_id;

816: x_txngrp_rec.price_list_id := l_cs_coverage_txn_groups_pk.price_list_id;
817: END IF;
818: IF (x_txngrp_rec.manufacturing_org_id = TAPI_DEV_KIT.G_MISS_NUM)
819: THEN
820: x_txngrp_rec.manufacturing_org_id := l_cs_coverage_txn_groups_pk.manufacturing_org_id;
821: END IF;
822: IF (x_txngrp_rec.subinventory_code = TAPI_DEV_KIT.G_MISS_CHAR)
823: THEN
824: x_txngrp_rec.subinventory_code := l_cs_coverage_txn_groups_pk.subinventory_code;

Line 824: x_txngrp_rec.subinventory_code := l_cs_coverage_txn_groups_pk.subinventory_code;

820: x_txngrp_rec.manufacturing_org_id := l_cs_coverage_txn_groups_pk.manufacturing_org_id;
821: END IF;
822: IF (x_txngrp_rec.subinventory_code = TAPI_DEV_KIT.G_MISS_CHAR)
823: THEN
824: x_txngrp_rec.subinventory_code := l_cs_coverage_txn_groups_pk.subinventory_code;
825: END IF;
826: IF (x_txngrp_rec.coverage_id = TAPI_DEV_KIT.G_MISS_NUM)
827: THEN
828: x_txngrp_rec.coverage_id := l_cs_coverage_txn_groups_pk.coverage_id;

Line 828: x_txngrp_rec.coverage_id := l_cs_coverage_txn_groups_pk.coverage_id;

824: x_txngrp_rec.subinventory_code := l_cs_coverage_txn_groups_pk.subinventory_code;
825: END IF;
826: IF (x_txngrp_rec.coverage_id = TAPI_DEV_KIT.G_MISS_NUM)
827: THEN
828: x_txngrp_rec.coverage_id := l_cs_coverage_txn_groups_pk.coverage_id;
829: END IF;
830: IF (x_txngrp_rec.discount_id = TAPI_DEV_KIT.G_MISS_NUM)
831: THEN
832: x_txngrp_rec.discount_id := l_cs_coverage_txn_groups_pk.discount_id;

Line 832: x_txngrp_rec.discount_id := l_cs_coverage_txn_groups_pk.discount_id;

828: x_txngrp_rec.coverage_id := l_cs_coverage_txn_groups_pk.coverage_id;
829: END IF;
830: IF (x_txngrp_rec.discount_id = TAPI_DEV_KIT.G_MISS_NUM)
831: THEN
832: x_txngrp_rec.discount_id := l_cs_coverage_txn_groups_pk.discount_id;
833: END IF;
834: IF (x_txngrp_rec.business_process_id = TAPI_DEV_KIT.G_MISS_NUM)
835: THEN
836: x_txngrp_rec.business_process_id := l_cs_coverage_txn_groups_pk.business_process_id;

Line 836: x_txngrp_rec.business_process_id := l_cs_coverage_txn_groups_pk.business_process_id;

832: x_txngrp_rec.discount_id := l_cs_coverage_txn_groups_pk.discount_id;
833: END IF;
834: IF (x_txngrp_rec.business_process_id = TAPI_DEV_KIT.G_MISS_NUM)
835: THEN
836: x_txngrp_rec.business_process_id := l_cs_coverage_txn_groups_pk.business_process_id;
837: END IF;
838: IF (x_txngrp_rec.sunday_end_time = TAPI_DEV_KIT.G_MISS_DATE)
839: THEN
840: x_txngrp_rec.sunday_end_time := l_cs_coverage_txn_groups_pk.sunday_end_time;

Line 840: x_txngrp_rec.sunday_end_time := l_cs_coverage_txn_groups_pk.sunday_end_time;

836: x_txngrp_rec.business_process_id := l_cs_coverage_txn_groups_pk.business_process_id;
837: END IF;
838: IF (x_txngrp_rec.sunday_end_time = TAPI_DEV_KIT.G_MISS_DATE)
839: THEN
840: x_txngrp_rec.sunday_end_time := l_cs_coverage_txn_groups_pk.sunday_end_time;
841: END IF;
842: IF (x_txngrp_rec.sunday_start_time = TAPI_DEV_KIT.G_MISS_DATE)
843: THEN
844: x_txngrp_rec.sunday_start_time := l_cs_coverage_txn_groups_pk.sunday_start_time;

Line 844: x_txngrp_rec.sunday_start_time := l_cs_coverage_txn_groups_pk.sunday_start_time;

840: x_txngrp_rec.sunday_end_time := l_cs_coverage_txn_groups_pk.sunday_end_time;
841: END IF;
842: IF (x_txngrp_rec.sunday_start_time = TAPI_DEV_KIT.G_MISS_DATE)
843: THEN
844: x_txngrp_rec.sunday_start_time := l_cs_coverage_txn_groups_pk.sunday_start_time;
845: END IF;
846: IF (x_txngrp_rec.monday_start_time = TAPI_DEV_KIT.G_MISS_DATE)
847: THEN
848: x_txngrp_rec.monday_start_time := l_cs_coverage_txn_groups_pk.monday_start_time;

Line 848: x_txngrp_rec.monday_start_time := l_cs_coverage_txn_groups_pk.monday_start_time;

844: x_txngrp_rec.sunday_start_time := l_cs_coverage_txn_groups_pk.sunday_start_time;
845: END IF;
846: IF (x_txngrp_rec.monday_start_time = TAPI_DEV_KIT.G_MISS_DATE)
847: THEN
848: x_txngrp_rec.monday_start_time := l_cs_coverage_txn_groups_pk.monday_start_time;
849: END IF;
850: IF (x_txngrp_rec.monday_end_time = TAPI_DEV_KIT.G_MISS_DATE)
851: THEN
852: x_txngrp_rec.monday_end_time := l_cs_coverage_txn_groups_pk.monday_end_time;

Line 852: x_txngrp_rec.monday_end_time := l_cs_coverage_txn_groups_pk.monday_end_time;

848: x_txngrp_rec.monday_start_time := l_cs_coverage_txn_groups_pk.monday_start_time;
849: END IF;
850: IF (x_txngrp_rec.monday_end_time = TAPI_DEV_KIT.G_MISS_DATE)
851: THEN
852: x_txngrp_rec.monday_end_time := l_cs_coverage_txn_groups_pk.monday_end_time;
853: END IF;
854: IF (x_txngrp_rec.tuesday_start_time = TAPI_DEV_KIT.G_MISS_DATE)
855: THEN
856: x_txngrp_rec.tuesday_start_time := l_cs_coverage_txn_groups_pk.tuesday_start_time;

Line 856: x_txngrp_rec.tuesday_start_time := l_cs_coverage_txn_groups_pk.tuesday_start_time;

852: x_txngrp_rec.monday_end_time := l_cs_coverage_txn_groups_pk.monday_end_time;
853: END IF;
854: IF (x_txngrp_rec.tuesday_start_time = TAPI_DEV_KIT.G_MISS_DATE)
855: THEN
856: x_txngrp_rec.tuesday_start_time := l_cs_coverage_txn_groups_pk.tuesday_start_time;
857: END IF;
858: IF (x_txngrp_rec.tuesday_end_time = TAPI_DEV_KIT.G_MISS_DATE)
859: THEN
860: x_txngrp_rec.tuesday_end_time := l_cs_coverage_txn_groups_pk.tuesday_end_time;

Line 860: x_txngrp_rec.tuesday_end_time := l_cs_coverage_txn_groups_pk.tuesday_end_time;

856: x_txngrp_rec.tuesday_start_time := l_cs_coverage_txn_groups_pk.tuesday_start_time;
857: END IF;
858: IF (x_txngrp_rec.tuesday_end_time = TAPI_DEV_KIT.G_MISS_DATE)
859: THEN
860: x_txngrp_rec.tuesday_end_time := l_cs_coverage_txn_groups_pk.tuesday_end_time;
861: END IF;
862: IF (x_txngrp_rec.wednesday_start_time = TAPI_DEV_KIT.G_MISS_DATE)
863: THEN
864: x_txngrp_rec.wednesday_start_time := l_cs_coverage_txn_groups_pk.wednesday_start_time;

Line 864: x_txngrp_rec.wednesday_start_time := l_cs_coverage_txn_groups_pk.wednesday_start_time;

860: x_txngrp_rec.tuesday_end_time := l_cs_coverage_txn_groups_pk.tuesday_end_time;
861: END IF;
862: IF (x_txngrp_rec.wednesday_start_time = TAPI_DEV_KIT.G_MISS_DATE)
863: THEN
864: x_txngrp_rec.wednesday_start_time := l_cs_coverage_txn_groups_pk.wednesday_start_time;
865: END IF;
866: IF (x_txngrp_rec.wednesday_end_time = TAPI_DEV_KIT.G_MISS_DATE)
867: THEN
868: x_txngrp_rec.wednesday_end_time := l_cs_coverage_txn_groups_pk.wednesday_end_time;

Line 868: x_txngrp_rec.wednesday_end_time := l_cs_coverage_txn_groups_pk.wednesday_end_time;

864: x_txngrp_rec.wednesday_start_time := l_cs_coverage_txn_groups_pk.wednesday_start_time;
865: END IF;
866: IF (x_txngrp_rec.wednesday_end_time = TAPI_DEV_KIT.G_MISS_DATE)
867: THEN
868: x_txngrp_rec.wednesday_end_time := l_cs_coverage_txn_groups_pk.wednesday_end_time;
869: END IF;
870: IF (x_txngrp_rec.thursday_start_time = TAPI_DEV_KIT.G_MISS_DATE)
871: THEN
872: x_txngrp_rec.thursday_start_time := l_cs_coverage_txn_groups_pk.thursday_start_time;

Line 872: x_txngrp_rec.thursday_start_time := l_cs_coverage_txn_groups_pk.thursday_start_time;

868: x_txngrp_rec.wednesday_end_time := l_cs_coverage_txn_groups_pk.wednesday_end_time;
869: END IF;
870: IF (x_txngrp_rec.thursday_start_time = TAPI_DEV_KIT.G_MISS_DATE)
871: THEN
872: x_txngrp_rec.thursday_start_time := l_cs_coverage_txn_groups_pk.thursday_start_time;
873: END IF;
874: IF (x_txngrp_rec.thursday_end_time = TAPI_DEV_KIT.G_MISS_DATE)
875: THEN
876: x_txngrp_rec.thursday_end_time := l_cs_coverage_txn_groups_pk.thursday_end_time;

Line 876: x_txngrp_rec.thursday_end_time := l_cs_coverage_txn_groups_pk.thursday_end_time;

872: x_txngrp_rec.thursday_start_time := l_cs_coverage_txn_groups_pk.thursday_start_time;
873: END IF;
874: IF (x_txngrp_rec.thursday_end_time = TAPI_DEV_KIT.G_MISS_DATE)
875: THEN
876: x_txngrp_rec.thursday_end_time := l_cs_coverage_txn_groups_pk.thursday_end_time;
877: END IF;
878: IF (x_txngrp_rec.friday_start_time = TAPI_DEV_KIT.G_MISS_DATE)
879: THEN
880: x_txngrp_rec.friday_start_time := l_cs_coverage_txn_groups_pk.friday_start_time;

Line 880: x_txngrp_rec.friday_start_time := l_cs_coverage_txn_groups_pk.friday_start_time;

876: x_txngrp_rec.thursday_end_time := l_cs_coverage_txn_groups_pk.thursday_end_time;
877: END IF;
878: IF (x_txngrp_rec.friday_start_time = TAPI_DEV_KIT.G_MISS_DATE)
879: THEN
880: x_txngrp_rec.friday_start_time := l_cs_coverage_txn_groups_pk.friday_start_time;
881: END IF;
882: IF (x_txngrp_rec.friday_end_time = TAPI_DEV_KIT.G_MISS_DATE)
883: THEN
884: x_txngrp_rec.friday_end_time := l_cs_coverage_txn_groups_pk.friday_end_time;

Line 884: x_txngrp_rec.friday_end_time := l_cs_coverage_txn_groups_pk.friday_end_time;

880: x_txngrp_rec.friday_start_time := l_cs_coverage_txn_groups_pk.friday_start_time;
881: END IF;
882: IF (x_txngrp_rec.friday_end_time = TAPI_DEV_KIT.G_MISS_DATE)
883: THEN
884: x_txngrp_rec.friday_end_time := l_cs_coverage_txn_groups_pk.friday_end_time;
885: END IF;
886: IF (x_txngrp_rec.saturday_start_time = TAPI_DEV_KIT.G_MISS_DATE)
887: THEN
888: x_txngrp_rec.saturday_start_time := l_cs_coverage_txn_groups_pk.saturday_start_time;

Line 888: x_txngrp_rec.saturday_start_time := l_cs_coverage_txn_groups_pk.saturday_start_time;

884: x_txngrp_rec.friday_end_time := l_cs_coverage_txn_groups_pk.friday_end_time;
885: END IF;
886: IF (x_txngrp_rec.saturday_start_time = TAPI_DEV_KIT.G_MISS_DATE)
887: THEN
888: x_txngrp_rec.saturday_start_time := l_cs_coverage_txn_groups_pk.saturday_start_time;
889: END IF;
890: IF (x_txngrp_rec.saturday_end_time = TAPI_DEV_KIT.G_MISS_DATE)
891: THEN
892: x_txngrp_rec.saturday_end_time := l_cs_coverage_txn_groups_pk.saturday_end_time;

Line 892: x_txngrp_rec.saturday_end_time := l_cs_coverage_txn_groups_pk.saturday_end_time;

888: x_txngrp_rec.saturday_start_time := l_cs_coverage_txn_groups_pk.saturday_start_time;
889: END IF;
890: IF (x_txngrp_rec.saturday_end_time = TAPI_DEV_KIT.G_MISS_DATE)
891: THEN
892: x_txngrp_rec.saturday_end_time := l_cs_coverage_txn_groups_pk.saturday_end_time;
893: END IF;
894: IF (x_txngrp_rec.preferred_engineer1 = TAPI_DEV_KIT.G_MISS_CHAR)
895: THEN
896: x_txngrp_rec.preferred_engineer1 := l_cs_coverage_txn_groups_pk.preferred_engineer1;

Line 896: x_txngrp_rec.preferred_engineer1 := l_cs_coverage_txn_groups_pk.preferred_engineer1;

892: x_txngrp_rec.saturday_end_time := l_cs_coverage_txn_groups_pk.saturday_end_time;
893: END IF;
894: IF (x_txngrp_rec.preferred_engineer1 = TAPI_DEV_KIT.G_MISS_CHAR)
895: THEN
896: x_txngrp_rec.preferred_engineer1 := l_cs_coverage_txn_groups_pk.preferred_engineer1;
897: END IF;
898: IF (x_txngrp_rec.time_zone_id = TAPI_DEV_KIT.G_MISS_NUM)
899: THEN
900: x_txngrp_rec.time_zone_id := l_cs_coverage_txn_groups_pk.time_zone_id;

Line 900: x_txngrp_rec.time_zone_id := l_cs_coverage_txn_groups_pk.time_zone_id;

896: x_txngrp_rec.preferred_engineer1 := l_cs_coverage_txn_groups_pk.preferred_engineer1;
897: END IF;
898: IF (x_txngrp_rec.time_zone_id = TAPI_DEV_KIT.G_MISS_NUM)
899: THEN
900: x_txngrp_rec.time_zone_id := l_cs_coverage_txn_groups_pk.time_zone_id;
901: END IF;
902: IF (x_txngrp_rec.preferred_engineer2 = TAPI_DEV_KIT.G_MISS_CHAR)
903: THEN
904: x_txngrp_rec.preferred_engineer2 := l_cs_coverage_txn_groups_pk.preferred_engineer2;

Line 904: x_txngrp_rec.preferred_engineer2 := l_cs_coverage_txn_groups_pk.preferred_engineer2;

900: x_txngrp_rec.time_zone_id := l_cs_coverage_txn_groups_pk.time_zone_id;
901: END IF;
902: IF (x_txngrp_rec.preferred_engineer2 = TAPI_DEV_KIT.G_MISS_CHAR)
903: THEN
904: x_txngrp_rec.preferred_engineer2 := l_cs_coverage_txn_groups_pk.preferred_engineer2;
905: END IF;
906: IF (x_txngrp_rec.last_update_date = TAPI_DEV_KIT.G_MISS_DATE)
907: THEN
908: x_txngrp_rec.last_update_date := l_cs_coverage_txn_groups_pk.last_update_date;

Line 908: x_txngrp_rec.last_update_date := l_cs_coverage_txn_groups_pk.last_update_date;

904: x_txngrp_rec.preferred_engineer2 := l_cs_coverage_txn_groups_pk.preferred_engineer2;
905: END IF;
906: IF (x_txngrp_rec.last_update_date = TAPI_DEV_KIT.G_MISS_DATE)
907: THEN
908: x_txngrp_rec.last_update_date := l_cs_coverage_txn_groups_pk.last_update_date;
909: END IF;
910: IF (x_txngrp_rec.last_updated_by = TAPI_DEV_KIT.G_MISS_NUM)
911: THEN
912: x_txngrp_rec.last_updated_by := l_cs_coverage_txn_groups_pk.last_updated_by;

Line 912: x_txngrp_rec.last_updated_by := l_cs_coverage_txn_groups_pk.last_updated_by;

908: x_txngrp_rec.last_update_date := l_cs_coverage_txn_groups_pk.last_update_date;
909: END IF;
910: IF (x_txngrp_rec.last_updated_by = TAPI_DEV_KIT.G_MISS_NUM)
911: THEN
912: x_txngrp_rec.last_updated_by := l_cs_coverage_txn_groups_pk.last_updated_by;
913: END IF;
914: IF (x_txngrp_rec.creation_date = TAPI_DEV_KIT.G_MISS_DATE)
915: THEN
916: x_txngrp_rec.creation_date := l_cs_coverage_txn_groups_pk.creation_date;

Line 916: x_txngrp_rec.creation_date := l_cs_coverage_txn_groups_pk.creation_date;

912: x_txngrp_rec.last_updated_by := l_cs_coverage_txn_groups_pk.last_updated_by;
913: END IF;
914: IF (x_txngrp_rec.creation_date = TAPI_DEV_KIT.G_MISS_DATE)
915: THEN
916: x_txngrp_rec.creation_date := l_cs_coverage_txn_groups_pk.creation_date;
917: END IF;
918: IF (x_txngrp_rec.created_by = TAPI_DEV_KIT.G_MISS_NUM)
919: THEN
920: x_txngrp_rec.created_by := l_cs_coverage_txn_groups_pk.created_by;

Line 920: x_txngrp_rec.created_by := l_cs_coverage_txn_groups_pk.created_by;

916: x_txngrp_rec.creation_date := l_cs_coverage_txn_groups_pk.creation_date;
917: END IF;
918: IF (x_txngrp_rec.created_by = TAPI_DEV_KIT.G_MISS_NUM)
919: THEN
920: x_txngrp_rec.created_by := l_cs_coverage_txn_groups_pk.created_by;
921: END IF;
922: IF (x_txngrp_rec.last_update_login = TAPI_DEV_KIT.G_MISS_NUM)
923: THEN
924: x_txngrp_rec.last_update_login := l_cs_coverage_txn_groups_pk.last_update_login;

Line 924: x_txngrp_rec.last_update_login := l_cs_coverage_txn_groups_pk.last_update_login;

920: x_txngrp_rec.created_by := l_cs_coverage_txn_groups_pk.created_by;
921: END IF;
922: IF (x_txngrp_rec.last_update_login = TAPI_DEV_KIT.G_MISS_NUM)
923: THEN
924: x_txngrp_rec.last_update_login := l_cs_coverage_txn_groups_pk.last_update_login;
925: END IF;
926: IF (x_txngrp_rec.attribute1 = TAPI_DEV_KIT.G_MISS_CHAR)
927: THEN
928: x_txngrp_rec.attribute1 := l_cs_coverage_txn_groups_pk.attribute1;

Line 928: x_txngrp_rec.attribute1 := l_cs_coverage_txn_groups_pk.attribute1;

924: x_txngrp_rec.last_update_login := l_cs_coverage_txn_groups_pk.last_update_login;
925: END IF;
926: IF (x_txngrp_rec.attribute1 = TAPI_DEV_KIT.G_MISS_CHAR)
927: THEN
928: x_txngrp_rec.attribute1 := l_cs_coverage_txn_groups_pk.attribute1;
929: END IF;
930: IF (x_txngrp_rec.attribute2 = TAPI_DEV_KIT.G_MISS_CHAR)
931: THEN
932: x_txngrp_rec.attribute2 := l_cs_coverage_txn_groups_pk.attribute2;

Line 932: x_txngrp_rec.attribute2 := l_cs_coverage_txn_groups_pk.attribute2;

928: x_txngrp_rec.attribute1 := l_cs_coverage_txn_groups_pk.attribute1;
929: END IF;
930: IF (x_txngrp_rec.attribute2 = TAPI_DEV_KIT.G_MISS_CHAR)
931: THEN
932: x_txngrp_rec.attribute2 := l_cs_coverage_txn_groups_pk.attribute2;
933: END IF;
934: IF (x_txngrp_rec.attribute3 = TAPI_DEV_KIT.G_MISS_CHAR)
935: THEN
936: x_txngrp_rec.attribute3 := l_cs_coverage_txn_groups_pk.attribute3;

Line 936: x_txngrp_rec.attribute3 := l_cs_coverage_txn_groups_pk.attribute3;

932: x_txngrp_rec.attribute2 := l_cs_coverage_txn_groups_pk.attribute2;
933: END IF;
934: IF (x_txngrp_rec.attribute3 = TAPI_DEV_KIT.G_MISS_CHAR)
935: THEN
936: x_txngrp_rec.attribute3 := l_cs_coverage_txn_groups_pk.attribute3;
937: END IF;
938: IF (x_txngrp_rec.attribute4 = TAPI_DEV_KIT.G_MISS_CHAR)
939: THEN
940: x_txngrp_rec.attribute4 := l_cs_coverage_txn_groups_pk.attribute4;

Line 940: x_txngrp_rec.attribute4 := l_cs_coverage_txn_groups_pk.attribute4;

936: x_txngrp_rec.attribute3 := l_cs_coverage_txn_groups_pk.attribute3;
937: END IF;
938: IF (x_txngrp_rec.attribute4 = TAPI_DEV_KIT.G_MISS_CHAR)
939: THEN
940: x_txngrp_rec.attribute4 := l_cs_coverage_txn_groups_pk.attribute4;
941: END IF;
942: IF (x_txngrp_rec.attribute5 = TAPI_DEV_KIT.G_MISS_CHAR)
943: THEN
944: x_txngrp_rec.attribute5 := l_cs_coverage_txn_groups_pk.attribute5;

Line 944: x_txngrp_rec.attribute5 := l_cs_coverage_txn_groups_pk.attribute5;

940: x_txngrp_rec.attribute4 := l_cs_coverage_txn_groups_pk.attribute4;
941: END IF;
942: IF (x_txngrp_rec.attribute5 = TAPI_DEV_KIT.G_MISS_CHAR)
943: THEN
944: x_txngrp_rec.attribute5 := l_cs_coverage_txn_groups_pk.attribute5;
945: END IF;
946: IF (x_txngrp_rec.attribute6 = TAPI_DEV_KIT.G_MISS_CHAR)
947: THEN
948: x_txngrp_rec.attribute6 := l_cs_coverage_txn_groups_pk.attribute6;

Line 948: x_txngrp_rec.attribute6 := l_cs_coverage_txn_groups_pk.attribute6;

944: x_txngrp_rec.attribute5 := l_cs_coverage_txn_groups_pk.attribute5;
945: END IF;
946: IF (x_txngrp_rec.attribute6 = TAPI_DEV_KIT.G_MISS_CHAR)
947: THEN
948: x_txngrp_rec.attribute6 := l_cs_coverage_txn_groups_pk.attribute6;
949: END IF;
950: IF (x_txngrp_rec.attribute7 = TAPI_DEV_KIT.G_MISS_CHAR)
951: THEN
952: x_txngrp_rec.attribute7 := l_cs_coverage_txn_groups_pk.attribute7;

Line 952: x_txngrp_rec.attribute7 := l_cs_coverage_txn_groups_pk.attribute7;

948: x_txngrp_rec.attribute6 := l_cs_coverage_txn_groups_pk.attribute6;
949: END IF;
950: IF (x_txngrp_rec.attribute7 = TAPI_DEV_KIT.G_MISS_CHAR)
951: THEN
952: x_txngrp_rec.attribute7 := l_cs_coverage_txn_groups_pk.attribute7;
953: END IF;
954: IF (x_txngrp_rec.attribute8 = TAPI_DEV_KIT.G_MISS_CHAR)
955: THEN
956: x_txngrp_rec.attribute8 := l_cs_coverage_txn_groups_pk.attribute8;

Line 956: x_txngrp_rec.attribute8 := l_cs_coverage_txn_groups_pk.attribute8;

952: x_txngrp_rec.attribute7 := l_cs_coverage_txn_groups_pk.attribute7;
953: END IF;
954: IF (x_txngrp_rec.attribute8 = TAPI_DEV_KIT.G_MISS_CHAR)
955: THEN
956: x_txngrp_rec.attribute8 := l_cs_coverage_txn_groups_pk.attribute8;
957: END IF;
958: IF (x_txngrp_rec.attribute9 = TAPI_DEV_KIT.G_MISS_CHAR)
959: THEN
960: x_txngrp_rec.attribute9 := l_cs_coverage_txn_groups_pk.attribute9;

Line 960: x_txngrp_rec.attribute9 := l_cs_coverage_txn_groups_pk.attribute9;

956: x_txngrp_rec.attribute8 := l_cs_coverage_txn_groups_pk.attribute8;
957: END IF;
958: IF (x_txngrp_rec.attribute9 = TAPI_DEV_KIT.G_MISS_CHAR)
959: THEN
960: x_txngrp_rec.attribute9 := l_cs_coverage_txn_groups_pk.attribute9;
961: END IF;
962: IF (x_txngrp_rec.attribute10 = TAPI_DEV_KIT.G_MISS_CHAR)
963: THEN
964: x_txngrp_rec.attribute10 := l_cs_coverage_txn_groups_pk.attribute10;

Line 964: x_txngrp_rec.attribute10 := l_cs_coverage_txn_groups_pk.attribute10;

960: x_txngrp_rec.attribute9 := l_cs_coverage_txn_groups_pk.attribute9;
961: END IF;
962: IF (x_txngrp_rec.attribute10 = TAPI_DEV_KIT.G_MISS_CHAR)
963: THEN
964: x_txngrp_rec.attribute10 := l_cs_coverage_txn_groups_pk.attribute10;
965: END IF;
966: IF (x_txngrp_rec.attribute11 = TAPI_DEV_KIT.G_MISS_CHAR)
967: THEN
968: x_txngrp_rec.attribute11 := l_cs_coverage_txn_groups_pk.attribute11;

Line 968: x_txngrp_rec.attribute11 := l_cs_coverage_txn_groups_pk.attribute11;

964: x_txngrp_rec.attribute10 := l_cs_coverage_txn_groups_pk.attribute10;
965: END IF;
966: IF (x_txngrp_rec.attribute11 = TAPI_DEV_KIT.G_MISS_CHAR)
967: THEN
968: x_txngrp_rec.attribute11 := l_cs_coverage_txn_groups_pk.attribute11;
969: END IF;
970: IF (x_txngrp_rec.attribute12 = TAPI_DEV_KIT.G_MISS_CHAR)
971: THEN
972: x_txngrp_rec.attribute12 := l_cs_coverage_txn_groups_pk.attribute12;

Line 972: x_txngrp_rec.attribute12 := l_cs_coverage_txn_groups_pk.attribute12;

968: x_txngrp_rec.attribute11 := l_cs_coverage_txn_groups_pk.attribute11;
969: END IF;
970: IF (x_txngrp_rec.attribute12 = TAPI_DEV_KIT.G_MISS_CHAR)
971: THEN
972: x_txngrp_rec.attribute12 := l_cs_coverage_txn_groups_pk.attribute12;
973: END IF;
974: IF (x_txngrp_rec.attribute13 = TAPI_DEV_KIT.G_MISS_CHAR)
975: THEN
976: x_txngrp_rec.attribute13 := l_cs_coverage_txn_groups_pk.attribute13;

Line 976: x_txngrp_rec.attribute13 := l_cs_coverage_txn_groups_pk.attribute13;

972: x_txngrp_rec.attribute12 := l_cs_coverage_txn_groups_pk.attribute12;
973: END IF;
974: IF (x_txngrp_rec.attribute13 = TAPI_DEV_KIT.G_MISS_CHAR)
975: THEN
976: x_txngrp_rec.attribute13 := l_cs_coverage_txn_groups_pk.attribute13;
977: END IF;
978: IF (x_txngrp_rec.attribute14 = TAPI_DEV_KIT.G_MISS_CHAR)
979: THEN
980: x_txngrp_rec.attribute14 := l_cs_coverage_txn_groups_pk.attribute14;

Line 980: x_txngrp_rec.attribute14 := l_cs_coverage_txn_groups_pk.attribute14;

976: x_txngrp_rec.attribute13 := l_cs_coverage_txn_groups_pk.attribute13;
977: END IF;
978: IF (x_txngrp_rec.attribute14 = TAPI_DEV_KIT.G_MISS_CHAR)
979: THEN
980: x_txngrp_rec.attribute14 := l_cs_coverage_txn_groups_pk.attribute14;
981: END IF;
982: IF (x_txngrp_rec.attribute15 = TAPI_DEV_KIT.G_MISS_CHAR)
983: THEN
984: x_txngrp_rec.attribute15 := l_cs_coverage_txn_groups_pk.attribute15;

Line 984: x_txngrp_rec.attribute15 := l_cs_coverage_txn_groups_pk.attribute15;

980: x_txngrp_rec.attribute14 := l_cs_coverage_txn_groups_pk.attribute14;
981: END IF;
982: IF (x_txngrp_rec.attribute15 = TAPI_DEV_KIT.G_MISS_CHAR)
983: THEN
984: x_txngrp_rec.attribute15 := l_cs_coverage_txn_groups_pk.attribute15;
985: END IF;
986: IF (x_txngrp_rec.context = TAPI_DEV_KIT.G_MISS_CHAR)
987: THEN
988: x_txngrp_rec.context := l_cs_coverage_txn_groups_pk.context;

Line 988: x_txngrp_rec.context := l_cs_coverage_txn_groups_pk.context;

984: x_txngrp_rec.attribute15 := l_cs_coverage_txn_groups_pk.attribute15;
985: END IF;
986: IF (x_txngrp_rec.context = TAPI_DEV_KIT.G_MISS_CHAR)
987: THEN
988: x_txngrp_rec.context := l_cs_coverage_txn_groups_pk.context;
989: END IF;
990: IF (x_txngrp_rec.object_version_number = TAPI_DEV_KIT.G_MISS_NUM)
991: THEN
992: x_txngrp_rec.object_version_number := l_cs_coverage_txn_groups_pk.object_version_number;

Line 992: x_txngrp_rec.object_version_number := l_cs_coverage_txn_groups_pk.object_version_number;

988: x_txngrp_rec.context := l_cs_coverage_txn_groups_pk.context;
989: END IF;
990: IF (x_txngrp_rec.object_version_number = TAPI_DEV_KIT.G_MISS_NUM)
991: THEN
992: x_txngrp_rec.object_version_number := l_cs_coverage_txn_groups_pk.object_version_number;
993: END IF;
994: RETURN(l_return_status);
995: END populate_new_record;
996: BEGIN

Line 1049: UPDATE CS_COVERAGE_TXN_GROUPS

1045: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
1046: RAISE FND_API.G_EXC_ERROR;
1047: END IF;
1048: END IF;
1049: UPDATE CS_COVERAGE_TXN_GROUPS
1050: SET
1051: COVERAGE_TXN_GROUP_ID = l_def_txngrp_rec.coverage_txn_group_id ,
1052: OFFSET_DURATION = l_def_txngrp_rec.offset_duration ,
1053: OFFSET_PERIOD = l_def_txngrp_rec.offset_period ,

Line 1152: p_offset_period IN CS_COVERAGE_TXN_GROUPS.OFFSET_PERIOD%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

1148: x_msg_count OUT NUMBER,
1149: x_msg_data OUT VARCHAR2,
1150: p_coverage_txn_group_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1151: p_offset_duration IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1152: p_offset_period IN CS_COVERAGE_TXN_GROUPS.OFFSET_PERIOD%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,

Line 1153: p_coverage_start_date IN CS_COVERAGE_TXN_GROUPS.COVERAGE_START_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,

1149: x_msg_data OUT VARCHAR2,
1150: p_coverage_txn_group_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1151: p_offset_duration IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1152: p_offset_period IN CS_COVERAGE_TXN_GROUPS.OFFSET_PERIOD%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,

Line 1154: p_coverage_end_date IN CS_COVERAGE_TXN_GROUPS.COVERAGE_END_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,

1150: p_coverage_txn_group_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1151: p_offset_duration IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1152: p_offset_period IN CS_COVERAGE_TXN_GROUPS.OFFSET_PERIOD%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,

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 1163: p_monday_start_time IN CS_COVERAGE_TXN_GROUPS.MONDAY_START_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,

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,
1167: p_wednesday_start_time IN CS_COVERAGE_TXN_GROUPS.WEDNESDAY_START_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,

Line 1164: p_monday_end_time IN CS_COVERAGE_TXN_GROUPS.MONDAY_END_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,

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,
1167: p_wednesday_start_time IN CS_COVERAGE_TXN_GROUPS.WEDNESDAY_START_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1168: p_wednesday_end_time IN CS_COVERAGE_TXN_GROUPS.WEDNESDAY_END_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,

Line 1165: p_tuesday_start_time IN CS_COVERAGE_TXN_GROUPS.TUESDAY_START_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,

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,
1167: p_wednesday_start_time IN CS_COVERAGE_TXN_GROUPS.WEDNESDAY_START_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1168: p_wednesday_end_time IN CS_COVERAGE_TXN_GROUPS.WEDNESDAY_END_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,

Line 1166: p_tuesday_end_time IN CS_COVERAGE_TXN_GROUPS.TUESDAY_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,
1167: p_wednesday_start_time IN CS_COVERAGE_TXN_GROUPS.WEDNESDAY_START_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1168: p_wednesday_end_time IN CS_COVERAGE_TXN_GROUPS.WEDNESDAY_END_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,

Line 1167: p_wednesday_start_time IN CS_COVERAGE_TXN_GROUPS.WEDNESDAY_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,
1167: p_wednesday_start_time IN CS_COVERAGE_TXN_GROUPS.WEDNESDAY_START_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1168: p_wednesday_end_time IN CS_COVERAGE_TXN_GROUPS.WEDNESDAY_END_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,

Line 1168: p_wednesday_end_time IN CS_COVERAGE_TXN_GROUPS.WEDNESDAY_END_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,
1167: p_wednesday_start_time IN CS_COVERAGE_TXN_GROUPS.WEDNESDAY_START_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1168: p_wednesday_end_time IN CS_COVERAGE_TXN_GROUPS.WEDNESDAY_END_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,

Line 1169: p_thursday_start_time IN CS_COVERAGE_TXN_GROUPS.THURSDAY_START_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,
1167: p_wednesday_start_time IN CS_COVERAGE_TXN_GROUPS.WEDNESDAY_START_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1168: p_wednesday_end_time IN CS_COVERAGE_TXN_GROUPS.WEDNESDAY_END_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,

Line 1170: p_thursday_end_time IN CS_COVERAGE_TXN_GROUPS.THURSDAY_END_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,
1167: p_wednesday_start_time IN CS_COVERAGE_TXN_GROUPS.WEDNESDAY_START_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1168: p_wednesday_end_time IN CS_COVERAGE_TXN_GROUPS.WEDNESDAY_END_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,

Line 1171: p_friday_start_time IN CS_COVERAGE_TXN_GROUPS.FRIDAY_START_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,

1167: p_wednesday_start_time IN CS_COVERAGE_TXN_GROUPS.WEDNESDAY_START_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1168: p_wednesday_end_time IN CS_COVERAGE_TXN_GROUPS.WEDNESDAY_END_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,

Line 1172: p_friday_end_time IN CS_COVERAGE_TXN_GROUPS.FRIDAY_END_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,

1168: p_wednesday_end_time IN CS_COVERAGE_TXN_GROUPS.WEDNESDAY_END_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,

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 1175: p_preferred_engineer1 IN CS_COVERAGE_TXN_GROUPS.PREFERRED_ENGINEER1%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

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,
1179: p_last_updated_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,

Line 1177: p_preferred_engineer2 IN CS_COVERAGE_TXN_GROUPS.PREFERRED_ENGINEER2%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

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,
1179: p_last_updated_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1180: p_creation_date IN CS_COVERAGE_TXN_GROUPS.CREATION_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1181: p_created_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,

Line 1178: p_last_update_date IN CS_COVERAGE_TXN_GROUPS.LAST_UPDATE_DATE%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,
1179: p_last_updated_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1180: p_creation_date IN CS_COVERAGE_TXN_GROUPS.CREATION_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1181: p_created_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1182: p_last_update_login IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,

Line 1180: p_creation_date IN CS_COVERAGE_TXN_GROUPS.CREATION_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,

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,
1179: p_last_updated_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1180: p_creation_date IN CS_COVERAGE_TXN_GROUPS.CREATION_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1181: p_created_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1182: p_last_update_login IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1183: p_attribute1 IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE1%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1184: p_attribute2 IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE2%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

Line 1183: p_attribute1 IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE1%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

1179: p_last_updated_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1180: p_creation_date IN CS_COVERAGE_TXN_GROUPS.CREATION_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1181: p_created_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1182: p_last_update_login IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1183: p_attribute1 IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE1%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1184: p_attribute2 IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE2%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1185: p_attribute3 IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE3%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1186: p_attribute4 IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE4%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1187: p_attribute5 IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE5%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

Line 1184: p_attribute2 IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE2%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

1180: p_creation_date IN CS_COVERAGE_TXN_GROUPS.CREATION_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1181: p_created_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1182: p_last_update_login IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1183: p_attribute1 IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE1%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1184: p_attribute2 IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE2%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1185: p_attribute3 IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE3%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1186: p_attribute4 IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE4%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1187: p_attribute5 IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE5%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1188: p_attribute6 IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE6%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

Line 1185: p_attribute3 IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE3%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

1181: p_created_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1182: p_last_update_login IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1183: p_attribute1 IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE1%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1184: p_attribute2 IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE2%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1185: p_attribute3 IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE3%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1186: p_attribute4 IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE4%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1187: p_attribute5 IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE5%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1188: p_attribute6 IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE6%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1189: p_attribute7 IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE7%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

Line 1186: p_attribute4 IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE4%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

1182: p_last_update_login IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1183: p_attribute1 IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE1%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1184: p_attribute2 IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE2%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1185: p_attribute3 IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE3%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1186: p_attribute4 IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE4%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1187: p_attribute5 IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE5%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1188: p_attribute6 IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE6%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1189: p_attribute7 IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE7%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1190: p_attribute8 IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE8%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

Line 1187: p_attribute5 IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE5%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

1183: p_attribute1 IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE1%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1184: p_attribute2 IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE2%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1185: p_attribute3 IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE3%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1186: p_attribute4 IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE4%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1187: p_attribute5 IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE5%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1188: p_attribute6 IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE6%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1189: p_attribute7 IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE7%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1190: p_attribute8 IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE8%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1191: p_attribute9 IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE9%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

Line 1188: p_attribute6 IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE6%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

1184: p_attribute2 IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE2%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1185: p_attribute3 IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE3%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1186: p_attribute4 IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE4%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1187: p_attribute5 IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE5%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1188: p_attribute6 IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE6%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1189: p_attribute7 IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE7%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1190: p_attribute8 IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE8%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1191: p_attribute9 IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE9%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1192: p_attribute10 IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE10%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

Line 1189: p_attribute7 IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE7%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

1185: p_attribute3 IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE3%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1186: p_attribute4 IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE4%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1187: p_attribute5 IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE5%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1188: p_attribute6 IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE6%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1189: p_attribute7 IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE7%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1190: p_attribute8 IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE8%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1191: p_attribute9 IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE9%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1192: p_attribute10 IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE10%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1193: p_attribute11 IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE11%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

Line 1190: p_attribute8 IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE8%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

1186: p_attribute4 IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE4%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1187: p_attribute5 IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE5%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1188: p_attribute6 IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE6%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1189: p_attribute7 IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE7%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1190: p_attribute8 IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE8%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1191: p_attribute9 IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE9%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1192: p_attribute10 IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE10%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1193: p_attribute11 IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE11%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1194: p_attribute12 IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE12%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

Line 1191: p_attribute9 IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE9%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

1187: p_attribute5 IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE5%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1188: p_attribute6 IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE6%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1189: p_attribute7 IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE7%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1190: p_attribute8 IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE8%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1191: p_attribute9 IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE9%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1192: p_attribute10 IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE10%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1193: p_attribute11 IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE11%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1194: p_attribute12 IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE12%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1195: p_attribute13 IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE13%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

Line 1192: p_attribute10 IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE10%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

1188: p_attribute6 IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE6%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1189: p_attribute7 IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE7%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1190: p_attribute8 IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE8%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1191: p_attribute9 IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE9%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1192: p_attribute10 IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE10%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1193: p_attribute11 IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE11%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1194: p_attribute12 IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE12%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1195: p_attribute13 IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE13%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1196: p_attribute14 IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE14%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

Line 1193: p_attribute11 IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE11%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

1189: p_attribute7 IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE7%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1190: p_attribute8 IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE8%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1191: p_attribute9 IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE9%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1192: p_attribute10 IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE10%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1193: p_attribute11 IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE11%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1194: p_attribute12 IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE12%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1195: p_attribute13 IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE13%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1196: p_attribute14 IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE14%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1197: p_attribute15 IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE15%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

Line 1194: p_attribute12 IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE12%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

1190: p_attribute8 IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE8%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1191: p_attribute9 IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE9%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1192: p_attribute10 IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE10%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1193: p_attribute11 IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE11%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1194: p_attribute12 IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE12%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1195: p_attribute13 IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE13%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1196: p_attribute14 IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE14%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1197: p_attribute15 IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE15%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1198: p_context IN CS_COVERAGE_TXN_GROUPS.CONTEXT%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

Line 1195: p_attribute13 IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE13%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

1191: p_attribute9 IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE9%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1192: p_attribute10 IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE10%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1193: p_attribute11 IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE11%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1194: p_attribute12 IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE12%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1195: p_attribute13 IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE13%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1196: p_attribute14 IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE14%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1197: p_attribute15 IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE15%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1198: p_context IN CS_COVERAGE_TXN_GROUPS.CONTEXT%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1199: p_object_version_number IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,

Line 1196: p_attribute14 IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE14%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

1192: p_attribute10 IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE10%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1193: p_attribute11 IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE11%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1194: p_attribute12 IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE12%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1195: p_attribute13 IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE13%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1196: p_attribute14 IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE14%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1197: p_attribute15 IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE15%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1198: p_context IN CS_COVERAGE_TXN_GROUPS.CONTEXT%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1199: p_object_version_number IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1200: x_object_version_number OUT NUMBER) IS

Line 1197: p_attribute15 IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE15%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

1193: p_attribute11 IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE11%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1194: p_attribute12 IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE12%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1195: p_attribute13 IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE13%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1196: p_attribute14 IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE14%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1197: p_attribute15 IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE15%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1198: p_context IN CS_COVERAGE_TXN_GROUPS.CONTEXT%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1199: p_object_version_number IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1200: x_object_version_number OUT NUMBER) IS
1201: l_api_name CONSTANT VARCHAR2(30) := 'update_row';

Line 1198: p_context IN CS_COVERAGE_TXN_GROUPS.CONTEXT%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

1194: p_attribute12 IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE12%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1195: p_attribute13 IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE13%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1196: p_attribute14 IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE14%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1197: p_attribute15 IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE15%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1198: p_context IN CS_COVERAGE_TXN_GROUPS.CONTEXT%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1199: p_object_version_number IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1200: x_object_version_number OUT NUMBER) IS
1201: l_api_name CONSTANT VARCHAR2(30) := 'update_row';
1202: l_api_version CONSTANT NUMBER := 1;

Line 1341: DELETE FROM CS_COVERAGE_TXN_GROUPS

1337: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1338: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
1339: RAISE FND_API.G_EXC_ERROR;
1340: END IF;
1341: DELETE FROM CS_COVERAGE_TXN_GROUPS
1342: WHERE
1343: COVERAGE_TXN_GROUP_ID = p_coverage_txn_group_id
1344: ;
1345: TAPI_DEV_KIT.END_ACTIVITY(p_commit, x_msg_count, x_msg_data);

Line 1478: p_offset_period IN CS_COVERAGE_TXN_GROUPS.OFFSET_PERIOD%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

1474: x_msg_count OUT NUMBER,
1475: x_msg_data OUT VARCHAR2,
1476: p_coverage_txn_group_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1477: p_offset_duration IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1478: p_offset_period IN CS_COVERAGE_TXN_GROUPS.OFFSET_PERIOD%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,

Line 1479: p_coverage_start_date IN CS_COVERAGE_TXN_GROUPS.COVERAGE_START_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,

1475: x_msg_data OUT VARCHAR2,
1476: p_coverage_txn_group_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1477: p_offset_duration IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1478: p_offset_period IN CS_COVERAGE_TXN_GROUPS.OFFSET_PERIOD%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,

Line 1480: p_coverage_end_date IN CS_COVERAGE_TXN_GROUPS.COVERAGE_END_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,

1476: p_coverage_txn_group_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1477: p_offset_duration IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1478: p_offset_period IN CS_COVERAGE_TXN_GROUPS.OFFSET_PERIOD%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,

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 1489: p_monday_start_time IN CS_COVERAGE_TXN_GROUPS.MONDAY_START_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,

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,
1493: p_wednesday_start_time IN CS_COVERAGE_TXN_GROUPS.WEDNESDAY_START_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,

Line 1490: p_monday_end_time IN CS_COVERAGE_TXN_GROUPS.MONDAY_END_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,

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,
1493: p_wednesday_start_time IN CS_COVERAGE_TXN_GROUPS.WEDNESDAY_START_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1494: p_wednesday_end_time IN CS_COVERAGE_TXN_GROUPS.WEDNESDAY_END_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,

Line 1491: p_tuesday_start_time IN CS_COVERAGE_TXN_GROUPS.TUESDAY_START_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,

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,
1493: p_wednesday_start_time IN CS_COVERAGE_TXN_GROUPS.WEDNESDAY_START_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1494: p_wednesday_end_time IN CS_COVERAGE_TXN_GROUPS.WEDNESDAY_END_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,

Line 1492: p_tuesday_end_time IN CS_COVERAGE_TXN_GROUPS.TUESDAY_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,
1493: p_wednesday_start_time IN CS_COVERAGE_TXN_GROUPS.WEDNESDAY_START_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1494: p_wednesday_end_time IN CS_COVERAGE_TXN_GROUPS.WEDNESDAY_END_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,

Line 1493: p_wednesday_start_time IN CS_COVERAGE_TXN_GROUPS.WEDNESDAY_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,
1493: p_wednesday_start_time IN CS_COVERAGE_TXN_GROUPS.WEDNESDAY_START_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1494: p_wednesday_end_time IN CS_COVERAGE_TXN_GROUPS.WEDNESDAY_END_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,

Line 1494: p_wednesday_end_time IN CS_COVERAGE_TXN_GROUPS.WEDNESDAY_END_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,
1493: p_wednesday_start_time IN CS_COVERAGE_TXN_GROUPS.WEDNESDAY_START_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1494: p_wednesday_end_time IN CS_COVERAGE_TXN_GROUPS.WEDNESDAY_END_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,

Line 1495: p_thursday_start_time IN CS_COVERAGE_TXN_GROUPS.THURSDAY_START_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,
1493: p_wednesday_start_time IN CS_COVERAGE_TXN_GROUPS.WEDNESDAY_START_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1494: p_wednesday_end_time IN CS_COVERAGE_TXN_GROUPS.WEDNESDAY_END_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,

Line 1496: p_thursday_end_time IN CS_COVERAGE_TXN_GROUPS.THURSDAY_END_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,
1493: p_wednesday_start_time IN CS_COVERAGE_TXN_GROUPS.WEDNESDAY_START_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1494: p_wednesday_end_time IN CS_COVERAGE_TXN_GROUPS.WEDNESDAY_END_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,

Line 1497: p_friday_start_time IN CS_COVERAGE_TXN_GROUPS.FRIDAY_START_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,

1493: p_wednesday_start_time IN CS_COVERAGE_TXN_GROUPS.WEDNESDAY_START_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1494: p_wednesday_end_time IN CS_COVERAGE_TXN_GROUPS.WEDNESDAY_END_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,

Line 1498: p_friday_end_time IN CS_COVERAGE_TXN_GROUPS.FRIDAY_END_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,

1494: p_wednesday_end_time IN CS_COVERAGE_TXN_GROUPS.WEDNESDAY_END_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,

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,

Line 1501: p_preferred_engineer1 IN CS_COVERAGE_TXN_GROUPS.PREFERRED_ENGINEER1%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

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,
1505: p_last_updated_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,

Line 1503: p_preferred_engineer2 IN CS_COVERAGE_TXN_GROUPS.PREFERRED_ENGINEER2%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

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,
1505: p_last_updated_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1506: p_creation_date IN CS_COVERAGE_TXN_GROUPS.CREATION_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1507: p_created_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,

Line 1504: p_last_update_date IN CS_COVERAGE_TXN_GROUPS.LAST_UPDATE_DATE%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,
1505: p_last_updated_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1506: p_creation_date IN CS_COVERAGE_TXN_GROUPS.CREATION_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1507: p_created_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1508: p_last_update_login IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,

Line 1506: p_creation_date IN CS_COVERAGE_TXN_GROUPS.CREATION_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,

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,
1505: p_last_updated_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1506: p_creation_date IN CS_COVERAGE_TXN_GROUPS.CREATION_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1507: p_created_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1508: p_last_update_login IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1509: p_attribute1 IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE1%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1510: p_attribute2 IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE2%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

Line 1509: p_attribute1 IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE1%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

1505: p_last_updated_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1506: p_creation_date IN CS_COVERAGE_TXN_GROUPS.CREATION_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1507: p_created_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1508: p_last_update_login IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1509: p_attribute1 IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE1%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1510: p_attribute2 IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE2%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1511: p_attribute3 IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE3%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1512: p_attribute4 IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE4%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1513: p_attribute5 IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE5%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

Line 1510: p_attribute2 IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE2%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

1506: p_creation_date IN CS_COVERAGE_TXN_GROUPS.CREATION_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1507: p_created_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1508: p_last_update_login IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1509: p_attribute1 IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE1%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1510: p_attribute2 IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE2%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1511: p_attribute3 IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE3%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1512: p_attribute4 IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE4%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1513: p_attribute5 IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE5%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1514: p_attribute6 IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE6%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

Line 1511: p_attribute3 IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE3%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

1507: p_created_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1508: p_last_update_login IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1509: p_attribute1 IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE1%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1510: p_attribute2 IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE2%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1511: p_attribute3 IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE3%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1512: p_attribute4 IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE4%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1513: p_attribute5 IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE5%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1514: p_attribute6 IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE6%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1515: p_attribute7 IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE7%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

Line 1512: p_attribute4 IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE4%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

1508: p_last_update_login IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1509: p_attribute1 IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE1%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1510: p_attribute2 IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE2%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1511: p_attribute3 IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE3%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1512: p_attribute4 IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE4%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1513: p_attribute5 IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE5%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1514: p_attribute6 IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE6%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1515: p_attribute7 IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE7%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1516: p_attribute8 IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE8%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

Line 1513: p_attribute5 IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE5%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

1509: p_attribute1 IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE1%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1510: p_attribute2 IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE2%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1511: p_attribute3 IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE3%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1512: p_attribute4 IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE4%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1513: p_attribute5 IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE5%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1514: p_attribute6 IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE6%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1515: p_attribute7 IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE7%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1516: p_attribute8 IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE8%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1517: p_attribute9 IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE9%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

Line 1514: p_attribute6 IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE6%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

1510: p_attribute2 IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE2%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1511: p_attribute3 IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE3%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1512: p_attribute4 IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE4%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1513: p_attribute5 IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE5%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1514: p_attribute6 IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE6%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1515: p_attribute7 IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE7%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1516: p_attribute8 IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE8%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1517: p_attribute9 IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE9%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1518: p_attribute10 IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE10%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

Line 1515: p_attribute7 IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE7%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

1511: p_attribute3 IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE3%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1512: p_attribute4 IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE4%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1513: p_attribute5 IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE5%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1514: p_attribute6 IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE6%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1515: p_attribute7 IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE7%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1516: p_attribute8 IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE8%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1517: p_attribute9 IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE9%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1518: p_attribute10 IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE10%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1519: p_attribute11 IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE11%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

Line 1516: p_attribute8 IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE8%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

1512: p_attribute4 IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE4%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1513: p_attribute5 IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE5%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1514: p_attribute6 IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE6%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1515: p_attribute7 IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE7%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1516: p_attribute8 IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE8%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1517: p_attribute9 IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE9%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1518: p_attribute10 IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE10%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1519: p_attribute11 IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE11%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1520: p_attribute12 IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE12%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

Line 1517: p_attribute9 IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE9%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

1513: p_attribute5 IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE5%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1514: p_attribute6 IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE6%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1515: p_attribute7 IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE7%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1516: p_attribute8 IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE8%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1517: p_attribute9 IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE9%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1518: p_attribute10 IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE10%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1519: p_attribute11 IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE11%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1520: p_attribute12 IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE12%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1521: p_attribute13 IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE13%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

Line 1518: p_attribute10 IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE10%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

1514: p_attribute6 IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE6%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1515: p_attribute7 IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE7%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1516: p_attribute8 IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE8%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1517: p_attribute9 IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE9%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1518: p_attribute10 IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE10%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1519: p_attribute11 IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE11%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1520: p_attribute12 IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE12%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1521: p_attribute13 IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE13%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1522: p_attribute14 IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE14%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

Line 1519: p_attribute11 IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE11%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

1515: p_attribute7 IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE7%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1516: p_attribute8 IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE8%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1517: p_attribute9 IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE9%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1518: p_attribute10 IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE10%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1519: p_attribute11 IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE11%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1520: p_attribute12 IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE12%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1521: p_attribute13 IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE13%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1522: p_attribute14 IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE14%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1523: p_attribute15 IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE15%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

Line 1520: p_attribute12 IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE12%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

1516: p_attribute8 IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE8%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1517: p_attribute9 IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE9%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1518: p_attribute10 IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE10%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1519: p_attribute11 IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE11%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1520: p_attribute12 IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE12%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1521: p_attribute13 IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE13%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1522: p_attribute14 IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE14%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1523: p_attribute15 IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE15%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1524: p_context IN CS_COVERAGE_TXN_GROUPS.CONTEXT%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

Line 1521: p_attribute13 IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE13%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

1517: p_attribute9 IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE9%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1518: p_attribute10 IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE10%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1519: p_attribute11 IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE11%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1520: p_attribute12 IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE12%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1521: p_attribute13 IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE13%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1522: p_attribute14 IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE14%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1523: p_attribute15 IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE15%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1524: p_context IN CS_COVERAGE_TXN_GROUPS.CONTEXT%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1525: p_object_version_number IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM) IS

Line 1522: p_attribute14 IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE14%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

1518: p_attribute10 IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE10%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1519: p_attribute11 IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE11%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1520: p_attribute12 IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE12%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1521: p_attribute13 IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE13%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1522: p_attribute14 IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE14%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1523: p_attribute15 IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE15%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1524: p_context IN CS_COVERAGE_TXN_GROUPS.CONTEXT%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1525: p_object_version_number IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM) IS
1526: l_api_name CONSTANT VARCHAR2(30) := 'validate_row';

Line 1523: p_attribute15 IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE15%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

1519: p_attribute11 IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE11%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1520: p_attribute12 IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE12%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1521: p_attribute13 IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE13%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1522: p_attribute14 IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE14%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1523: p_attribute15 IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE15%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1524: p_context IN CS_COVERAGE_TXN_GROUPS.CONTEXT%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1525: p_object_version_number IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM) IS
1526: l_api_name CONSTANT VARCHAR2(30) := 'validate_row';
1527: l_api_version CONSTANT NUMBER := 1;

Line 1524: p_context IN CS_COVERAGE_TXN_GROUPS.CONTEXT%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

1520: p_attribute12 IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE12%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1521: p_attribute13 IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE13%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1522: p_attribute14 IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE14%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1523: p_attribute15 IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE15%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1524: p_context IN CS_COVERAGE_TXN_GROUPS.CONTEXT%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1525: p_object_version_number IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM) IS
1526: l_api_name CONSTANT VARCHAR2(30) := 'validate_row';
1527: l_api_version CONSTANT NUMBER := 1;
1528: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;