eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.CS_REACTTIME_PVT dependencies on CS_COV_REACTION_TIMES

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

1: PACKAGE BODY CS_REACTTIME_PVT AS
2: /* $Header: csctcrtb.pls 115.1 99/07/16 08:51:02 porting ship $ */
3: FUNCTION get_seq_id RETURN NUMBER IS
4: CURSOR get_seq_id_csr IS
5: SELECT CS_COV_REACTION_TIMES_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 268: INSERT INTO CS_COV_REACTION_TIMES(

264: END IF;
265: END IF;
266: -- Set primary key value
267: l_def_reacttime_rec.reaction_time_id := get_seq_id;
268: INSERT INTO CS_COV_REACTION_TIMES(
269: reaction_time_id,
270: name,
271: description,
272: reaction_time_sunday,

Line 392: p_name IN CS_COV_REACTION_TIMES.NAME%TYPE := NULL,

388: p_commit IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
389: x_return_status OUT VARCHAR2,
390: x_msg_count OUT NUMBER,
391: x_msg_data OUT VARCHAR2,
392: p_name IN CS_COV_REACTION_TIMES.NAME%TYPE := NULL,
393: p_description IN CS_COV_REACTION_TIMES.DESCRIPTION%TYPE := NULL,
394: p_reaction_time_sunday IN NUMBER := NULL,
395: p_reaction_time_monday IN NUMBER := NULL,
396: p_reaction_time_tuesday IN NUMBER := NULL,

Line 393: p_description IN CS_COV_REACTION_TIMES.DESCRIPTION%TYPE := NULL,

389: x_return_status OUT VARCHAR2,
390: x_msg_count OUT NUMBER,
391: x_msg_data OUT VARCHAR2,
392: p_name IN CS_COV_REACTION_TIMES.NAME%TYPE := NULL,
393: p_description IN CS_COV_REACTION_TIMES.DESCRIPTION%TYPE := NULL,
394: p_reaction_time_sunday IN NUMBER := NULL,
395: p_reaction_time_monday IN NUMBER := NULL,
396: p_reaction_time_tuesday IN NUMBER := NULL,
397: p_reaction_time_wednesday IN NUMBER := NULL,

Line 402: p_always_covered IN CS_COV_REACTION_TIMES.ALWAYS_COVERED%TYPE := NULL,

398: p_reaction_time_thursday IN NUMBER := NULL,
399: p_reaction_time_friday IN NUMBER := NULL,
400: p_reaction_time_saturday IN NUMBER := NULL,
401: p_incident_severity_id IN NUMBER := NULL,
402: p_always_covered IN CS_COV_REACTION_TIMES.ALWAYS_COVERED%TYPE := NULL,
403: p_workflow IN CS_COV_REACTION_TIMES.WORKFLOW%TYPE := NULL,
404: p_coverage_txn_group_id IN NUMBER := NULL,
405: p_use_for_sr_date_calc IN CS_COV_REACTION_TIMES.USE_FOR_SR_DATE_CALC%TYPE := NULL,
406: p_last_update_date IN CS_COV_REACTION_TIMES.LAST_UPDATE_DATE%TYPE := NULL,

Line 403: p_workflow IN CS_COV_REACTION_TIMES.WORKFLOW%TYPE := NULL,

399: p_reaction_time_friday IN NUMBER := NULL,
400: p_reaction_time_saturday IN NUMBER := NULL,
401: p_incident_severity_id IN NUMBER := NULL,
402: p_always_covered IN CS_COV_REACTION_TIMES.ALWAYS_COVERED%TYPE := NULL,
403: p_workflow IN CS_COV_REACTION_TIMES.WORKFLOW%TYPE := NULL,
404: p_coverage_txn_group_id IN NUMBER := NULL,
405: p_use_for_sr_date_calc IN CS_COV_REACTION_TIMES.USE_FOR_SR_DATE_CALC%TYPE := NULL,
406: p_last_update_date IN CS_COV_REACTION_TIMES.LAST_UPDATE_DATE%TYPE := NULL,
407: p_last_updated_by IN NUMBER := NULL,

Line 405: p_use_for_sr_date_calc IN CS_COV_REACTION_TIMES.USE_FOR_SR_DATE_CALC%TYPE := NULL,

401: p_incident_severity_id IN NUMBER := NULL,
402: p_always_covered IN CS_COV_REACTION_TIMES.ALWAYS_COVERED%TYPE := NULL,
403: p_workflow IN CS_COV_REACTION_TIMES.WORKFLOW%TYPE := NULL,
404: p_coverage_txn_group_id IN NUMBER := NULL,
405: p_use_for_sr_date_calc IN CS_COV_REACTION_TIMES.USE_FOR_SR_DATE_CALC%TYPE := NULL,
406: p_last_update_date IN CS_COV_REACTION_TIMES.LAST_UPDATE_DATE%TYPE := NULL,
407: p_last_updated_by IN NUMBER := NULL,
408: p_creation_date IN CS_COV_REACTION_TIMES.CREATION_DATE%TYPE := NULL,
409: p_created_by IN NUMBER := NULL,

Line 406: p_last_update_date IN CS_COV_REACTION_TIMES.LAST_UPDATE_DATE%TYPE := NULL,

402: p_always_covered IN CS_COV_REACTION_TIMES.ALWAYS_COVERED%TYPE := NULL,
403: p_workflow IN CS_COV_REACTION_TIMES.WORKFLOW%TYPE := NULL,
404: p_coverage_txn_group_id IN NUMBER := NULL,
405: p_use_for_sr_date_calc IN CS_COV_REACTION_TIMES.USE_FOR_SR_DATE_CALC%TYPE := NULL,
406: p_last_update_date IN CS_COV_REACTION_TIMES.LAST_UPDATE_DATE%TYPE := NULL,
407: p_last_updated_by IN NUMBER := NULL,
408: p_creation_date IN CS_COV_REACTION_TIMES.CREATION_DATE%TYPE := NULL,
409: p_created_by IN NUMBER := NULL,
410: p_last_update_login IN NUMBER := NULL,

Line 408: p_creation_date IN CS_COV_REACTION_TIMES.CREATION_DATE%TYPE := NULL,

404: p_coverage_txn_group_id IN NUMBER := NULL,
405: p_use_for_sr_date_calc IN CS_COV_REACTION_TIMES.USE_FOR_SR_DATE_CALC%TYPE := NULL,
406: p_last_update_date IN CS_COV_REACTION_TIMES.LAST_UPDATE_DATE%TYPE := NULL,
407: p_last_updated_by IN NUMBER := NULL,
408: p_creation_date IN CS_COV_REACTION_TIMES.CREATION_DATE%TYPE := NULL,
409: p_created_by IN NUMBER := NULL,
410: p_last_update_login IN NUMBER := NULL,
411: p_attribute1 IN CS_COV_REACTION_TIMES.ATTRIBUTE1%TYPE := NULL,
412: p_attribute2 IN CS_COV_REACTION_TIMES.ATTRIBUTE2%TYPE := NULL,

Line 411: p_attribute1 IN CS_COV_REACTION_TIMES.ATTRIBUTE1%TYPE := NULL,

407: p_last_updated_by IN NUMBER := NULL,
408: p_creation_date IN CS_COV_REACTION_TIMES.CREATION_DATE%TYPE := NULL,
409: p_created_by IN NUMBER := NULL,
410: p_last_update_login IN NUMBER := NULL,
411: p_attribute1 IN CS_COV_REACTION_TIMES.ATTRIBUTE1%TYPE := NULL,
412: p_attribute2 IN CS_COV_REACTION_TIMES.ATTRIBUTE2%TYPE := NULL,
413: p_attribute3 IN CS_COV_REACTION_TIMES.ATTRIBUTE3%TYPE := NULL,
414: p_attribute4 IN CS_COV_REACTION_TIMES.ATTRIBUTE4%TYPE := NULL,
415: p_attribute5 IN CS_COV_REACTION_TIMES.ATTRIBUTE5%TYPE := NULL,

Line 412: p_attribute2 IN CS_COV_REACTION_TIMES.ATTRIBUTE2%TYPE := NULL,

408: p_creation_date IN CS_COV_REACTION_TIMES.CREATION_DATE%TYPE := NULL,
409: p_created_by IN NUMBER := NULL,
410: p_last_update_login IN NUMBER := NULL,
411: p_attribute1 IN CS_COV_REACTION_TIMES.ATTRIBUTE1%TYPE := NULL,
412: p_attribute2 IN CS_COV_REACTION_TIMES.ATTRIBUTE2%TYPE := NULL,
413: p_attribute3 IN CS_COV_REACTION_TIMES.ATTRIBUTE3%TYPE := NULL,
414: p_attribute4 IN CS_COV_REACTION_TIMES.ATTRIBUTE4%TYPE := NULL,
415: p_attribute5 IN CS_COV_REACTION_TIMES.ATTRIBUTE5%TYPE := NULL,
416: p_attribute6 IN CS_COV_REACTION_TIMES.ATTRIBUTE6%TYPE := NULL,

Line 413: p_attribute3 IN CS_COV_REACTION_TIMES.ATTRIBUTE3%TYPE := NULL,

409: p_created_by IN NUMBER := NULL,
410: p_last_update_login IN NUMBER := NULL,
411: p_attribute1 IN CS_COV_REACTION_TIMES.ATTRIBUTE1%TYPE := NULL,
412: p_attribute2 IN CS_COV_REACTION_TIMES.ATTRIBUTE2%TYPE := NULL,
413: p_attribute3 IN CS_COV_REACTION_TIMES.ATTRIBUTE3%TYPE := NULL,
414: p_attribute4 IN CS_COV_REACTION_TIMES.ATTRIBUTE4%TYPE := NULL,
415: p_attribute5 IN CS_COV_REACTION_TIMES.ATTRIBUTE5%TYPE := NULL,
416: p_attribute6 IN CS_COV_REACTION_TIMES.ATTRIBUTE6%TYPE := NULL,
417: p_attribute7 IN CS_COV_REACTION_TIMES.ATTRIBUTE7%TYPE := NULL,

Line 414: p_attribute4 IN CS_COV_REACTION_TIMES.ATTRIBUTE4%TYPE := NULL,

410: p_last_update_login IN NUMBER := NULL,
411: p_attribute1 IN CS_COV_REACTION_TIMES.ATTRIBUTE1%TYPE := NULL,
412: p_attribute2 IN CS_COV_REACTION_TIMES.ATTRIBUTE2%TYPE := NULL,
413: p_attribute3 IN CS_COV_REACTION_TIMES.ATTRIBUTE3%TYPE := NULL,
414: p_attribute4 IN CS_COV_REACTION_TIMES.ATTRIBUTE4%TYPE := NULL,
415: p_attribute5 IN CS_COV_REACTION_TIMES.ATTRIBUTE5%TYPE := NULL,
416: p_attribute6 IN CS_COV_REACTION_TIMES.ATTRIBUTE6%TYPE := NULL,
417: p_attribute7 IN CS_COV_REACTION_TIMES.ATTRIBUTE7%TYPE := NULL,
418: p_attribute8 IN CS_COV_REACTION_TIMES.ATTRIBUTE8%TYPE := NULL,

Line 415: p_attribute5 IN CS_COV_REACTION_TIMES.ATTRIBUTE5%TYPE := NULL,

411: p_attribute1 IN CS_COV_REACTION_TIMES.ATTRIBUTE1%TYPE := NULL,
412: p_attribute2 IN CS_COV_REACTION_TIMES.ATTRIBUTE2%TYPE := NULL,
413: p_attribute3 IN CS_COV_REACTION_TIMES.ATTRIBUTE3%TYPE := NULL,
414: p_attribute4 IN CS_COV_REACTION_TIMES.ATTRIBUTE4%TYPE := NULL,
415: p_attribute5 IN CS_COV_REACTION_TIMES.ATTRIBUTE5%TYPE := NULL,
416: p_attribute6 IN CS_COV_REACTION_TIMES.ATTRIBUTE6%TYPE := NULL,
417: p_attribute7 IN CS_COV_REACTION_TIMES.ATTRIBUTE7%TYPE := NULL,
418: p_attribute8 IN CS_COV_REACTION_TIMES.ATTRIBUTE8%TYPE := NULL,
419: p_attribute9 IN CS_COV_REACTION_TIMES.ATTRIBUTE9%TYPE := NULL,

Line 416: p_attribute6 IN CS_COV_REACTION_TIMES.ATTRIBUTE6%TYPE := NULL,

412: p_attribute2 IN CS_COV_REACTION_TIMES.ATTRIBUTE2%TYPE := NULL,
413: p_attribute3 IN CS_COV_REACTION_TIMES.ATTRIBUTE3%TYPE := NULL,
414: p_attribute4 IN CS_COV_REACTION_TIMES.ATTRIBUTE4%TYPE := NULL,
415: p_attribute5 IN CS_COV_REACTION_TIMES.ATTRIBUTE5%TYPE := NULL,
416: p_attribute6 IN CS_COV_REACTION_TIMES.ATTRIBUTE6%TYPE := NULL,
417: p_attribute7 IN CS_COV_REACTION_TIMES.ATTRIBUTE7%TYPE := NULL,
418: p_attribute8 IN CS_COV_REACTION_TIMES.ATTRIBUTE8%TYPE := NULL,
419: p_attribute9 IN CS_COV_REACTION_TIMES.ATTRIBUTE9%TYPE := NULL,
420: p_attribute10 IN CS_COV_REACTION_TIMES.ATTRIBUTE10%TYPE := NULL,

Line 417: p_attribute7 IN CS_COV_REACTION_TIMES.ATTRIBUTE7%TYPE := NULL,

413: p_attribute3 IN CS_COV_REACTION_TIMES.ATTRIBUTE3%TYPE := NULL,
414: p_attribute4 IN CS_COV_REACTION_TIMES.ATTRIBUTE4%TYPE := NULL,
415: p_attribute5 IN CS_COV_REACTION_TIMES.ATTRIBUTE5%TYPE := NULL,
416: p_attribute6 IN CS_COV_REACTION_TIMES.ATTRIBUTE6%TYPE := NULL,
417: p_attribute7 IN CS_COV_REACTION_TIMES.ATTRIBUTE7%TYPE := NULL,
418: p_attribute8 IN CS_COV_REACTION_TIMES.ATTRIBUTE8%TYPE := NULL,
419: p_attribute9 IN CS_COV_REACTION_TIMES.ATTRIBUTE9%TYPE := NULL,
420: p_attribute10 IN CS_COV_REACTION_TIMES.ATTRIBUTE10%TYPE := NULL,
421: p_attribute11 IN CS_COV_REACTION_TIMES.ATTRIBUTE11%TYPE := NULL,

Line 418: p_attribute8 IN CS_COV_REACTION_TIMES.ATTRIBUTE8%TYPE := NULL,

414: p_attribute4 IN CS_COV_REACTION_TIMES.ATTRIBUTE4%TYPE := NULL,
415: p_attribute5 IN CS_COV_REACTION_TIMES.ATTRIBUTE5%TYPE := NULL,
416: p_attribute6 IN CS_COV_REACTION_TIMES.ATTRIBUTE6%TYPE := NULL,
417: p_attribute7 IN CS_COV_REACTION_TIMES.ATTRIBUTE7%TYPE := NULL,
418: p_attribute8 IN CS_COV_REACTION_TIMES.ATTRIBUTE8%TYPE := NULL,
419: p_attribute9 IN CS_COV_REACTION_TIMES.ATTRIBUTE9%TYPE := NULL,
420: p_attribute10 IN CS_COV_REACTION_TIMES.ATTRIBUTE10%TYPE := NULL,
421: p_attribute11 IN CS_COV_REACTION_TIMES.ATTRIBUTE11%TYPE := NULL,
422: p_attribute12 IN CS_COV_REACTION_TIMES.ATTRIBUTE12%TYPE := NULL,

Line 419: p_attribute9 IN CS_COV_REACTION_TIMES.ATTRIBUTE9%TYPE := NULL,

415: p_attribute5 IN CS_COV_REACTION_TIMES.ATTRIBUTE5%TYPE := NULL,
416: p_attribute6 IN CS_COV_REACTION_TIMES.ATTRIBUTE6%TYPE := NULL,
417: p_attribute7 IN CS_COV_REACTION_TIMES.ATTRIBUTE7%TYPE := NULL,
418: p_attribute8 IN CS_COV_REACTION_TIMES.ATTRIBUTE8%TYPE := NULL,
419: p_attribute9 IN CS_COV_REACTION_TIMES.ATTRIBUTE9%TYPE := NULL,
420: p_attribute10 IN CS_COV_REACTION_TIMES.ATTRIBUTE10%TYPE := NULL,
421: p_attribute11 IN CS_COV_REACTION_TIMES.ATTRIBUTE11%TYPE := NULL,
422: p_attribute12 IN CS_COV_REACTION_TIMES.ATTRIBUTE12%TYPE := NULL,
423: p_attribute13 IN CS_COV_REACTION_TIMES.ATTRIBUTE13%TYPE := NULL,

Line 420: p_attribute10 IN CS_COV_REACTION_TIMES.ATTRIBUTE10%TYPE := NULL,

416: p_attribute6 IN CS_COV_REACTION_TIMES.ATTRIBUTE6%TYPE := NULL,
417: p_attribute7 IN CS_COV_REACTION_TIMES.ATTRIBUTE7%TYPE := NULL,
418: p_attribute8 IN CS_COV_REACTION_TIMES.ATTRIBUTE8%TYPE := NULL,
419: p_attribute9 IN CS_COV_REACTION_TIMES.ATTRIBUTE9%TYPE := NULL,
420: p_attribute10 IN CS_COV_REACTION_TIMES.ATTRIBUTE10%TYPE := NULL,
421: p_attribute11 IN CS_COV_REACTION_TIMES.ATTRIBUTE11%TYPE := NULL,
422: p_attribute12 IN CS_COV_REACTION_TIMES.ATTRIBUTE12%TYPE := NULL,
423: p_attribute13 IN CS_COV_REACTION_TIMES.ATTRIBUTE13%TYPE := NULL,
424: p_attribute14 IN CS_COV_REACTION_TIMES.ATTRIBUTE14%TYPE := NULL,

Line 421: p_attribute11 IN CS_COV_REACTION_TIMES.ATTRIBUTE11%TYPE := NULL,

417: p_attribute7 IN CS_COV_REACTION_TIMES.ATTRIBUTE7%TYPE := NULL,
418: p_attribute8 IN CS_COV_REACTION_TIMES.ATTRIBUTE8%TYPE := NULL,
419: p_attribute9 IN CS_COV_REACTION_TIMES.ATTRIBUTE9%TYPE := NULL,
420: p_attribute10 IN CS_COV_REACTION_TIMES.ATTRIBUTE10%TYPE := NULL,
421: p_attribute11 IN CS_COV_REACTION_TIMES.ATTRIBUTE11%TYPE := NULL,
422: p_attribute12 IN CS_COV_REACTION_TIMES.ATTRIBUTE12%TYPE := NULL,
423: p_attribute13 IN CS_COV_REACTION_TIMES.ATTRIBUTE13%TYPE := NULL,
424: p_attribute14 IN CS_COV_REACTION_TIMES.ATTRIBUTE14%TYPE := NULL,
425: p_attribute15 IN CS_COV_REACTION_TIMES.ATTRIBUTE15%TYPE := NULL,

Line 422: p_attribute12 IN CS_COV_REACTION_TIMES.ATTRIBUTE12%TYPE := NULL,

418: p_attribute8 IN CS_COV_REACTION_TIMES.ATTRIBUTE8%TYPE := NULL,
419: p_attribute9 IN CS_COV_REACTION_TIMES.ATTRIBUTE9%TYPE := NULL,
420: p_attribute10 IN CS_COV_REACTION_TIMES.ATTRIBUTE10%TYPE := NULL,
421: p_attribute11 IN CS_COV_REACTION_TIMES.ATTRIBUTE11%TYPE := NULL,
422: p_attribute12 IN CS_COV_REACTION_TIMES.ATTRIBUTE12%TYPE := NULL,
423: p_attribute13 IN CS_COV_REACTION_TIMES.ATTRIBUTE13%TYPE := NULL,
424: p_attribute14 IN CS_COV_REACTION_TIMES.ATTRIBUTE14%TYPE := NULL,
425: p_attribute15 IN CS_COV_REACTION_TIMES.ATTRIBUTE15%TYPE := NULL,
426: p_context IN CS_COV_REACTION_TIMES.CONTEXT%TYPE := NULL,

Line 423: p_attribute13 IN CS_COV_REACTION_TIMES.ATTRIBUTE13%TYPE := NULL,

419: p_attribute9 IN CS_COV_REACTION_TIMES.ATTRIBUTE9%TYPE := NULL,
420: p_attribute10 IN CS_COV_REACTION_TIMES.ATTRIBUTE10%TYPE := NULL,
421: p_attribute11 IN CS_COV_REACTION_TIMES.ATTRIBUTE11%TYPE := NULL,
422: p_attribute12 IN CS_COV_REACTION_TIMES.ATTRIBUTE12%TYPE := NULL,
423: p_attribute13 IN CS_COV_REACTION_TIMES.ATTRIBUTE13%TYPE := NULL,
424: p_attribute14 IN CS_COV_REACTION_TIMES.ATTRIBUTE14%TYPE := NULL,
425: p_attribute15 IN CS_COV_REACTION_TIMES.ATTRIBUTE15%TYPE := NULL,
426: p_context IN CS_COV_REACTION_TIMES.CONTEXT%TYPE := NULL,
427: p_object_version_number IN NUMBER := NULL,

Line 424: p_attribute14 IN CS_COV_REACTION_TIMES.ATTRIBUTE14%TYPE := NULL,

420: p_attribute10 IN CS_COV_REACTION_TIMES.ATTRIBUTE10%TYPE := NULL,
421: p_attribute11 IN CS_COV_REACTION_TIMES.ATTRIBUTE11%TYPE := NULL,
422: p_attribute12 IN CS_COV_REACTION_TIMES.ATTRIBUTE12%TYPE := NULL,
423: p_attribute13 IN CS_COV_REACTION_TIMES.ATTRIBUTE13%TYPE := NULL,
424: p_attribute14 IN CS_COV_REACTION_TIMES.ATTRIBUTE14%TYPE := NULL,
425: p_attribute15 IN CS_COV_REACTION_TIMES.ATTRIBUTE15%TYPE := NULL,
426: p_context IN CS_COV_REACTION_TIMES.CONTEXT%TYPE := NULL,
427: p_object_version_number IN NUMBER := NULL,
428: x_reaction_time_id OUT NUMBER,

Line 425: p_attribute15 IN CS_COV_REACTION_TIMES.ATTRIBUTE15%TYPE := NULL,

421: p_attribute11 IN CS_COV_REACTION_TIMES.ATTRIBUTE11%TYPE := NULL,
422: p_attribute12 IN CS_COV_REACTION_TIMES.ATTRIBUTE12%TYPE := NULL,
423: p_attribute13 IN CS_COV_REACTION_TIMES.ATTRIBUTE13%TYPE := NULL,
424: p_attribute14 IN CS_COV_REACTION_TIMES.ATTRIBUTE14%TYPE := NULL,
425: p_attribute15 IN CS_COV_REACTION_TIMES.ATTRIBUTE15%TYPE := NULL,
426: p_context IN CS_COV_REACTION_TIMES.CONTEXT%TYPE := NULL,
427: p_object_version_number IN NUMBER := NULL,
428: x_reaction_time_id OUT NUMBER,
429: x_object_version_number OUT NUMBER) IS

Line 426: p_context IN CS_COV_REACTION_TIMES.CONTEXT%TYPE := NULL,

422: p_attribute12 IN CS_COV_REACTION_TIMES.ATTRIBUTE12%TYPE := NULL,
423: p_attribute13 IN CS_COV_REACTION_TIMES.ATTRIBUTE13%TYPE := NULL,
424: p_attribute14 IN CS_COV_REACTION_TIMES.ATTRIBUTE14%TYPE := NULL,
425: p_attribute15 IN CS_COV_REACTION_TIMES.ATTRIBUTE15%TYPE := NULL,
426: p_context IN CS_COV_REACTION_TIMES.CONTEXT%TYPE := NULL,
427: p_object_version_number IN NUMBER := NULL,
428: x_reaction_time_id OUT NUMBER,
429: x_object_version_number OUT NUMBER) IS
430: l_api_name CONSTANT VARCHAR2(30) := 'insert_row';

Line 546: FROM CS_COV_REACTION_TIMES

542: E_Resource_Busy EXCEPTION;
543: PRAGMA EXCEPTION_INIT(E_Resource_Busy, -00054);
544: CURSOR lock_csr IS
545: SELECT OBJECT_VERSION_NUMBER
546: FROM CS_COV_REACTION_TIMES
547: WHERE
548: REACTION_TIME_ID = p_reaction_time_id AND
549: OBJECT_VERSION_NUMBER = p_object_version_number
550: FOR UPDATE OF OBJECT_VERSION_NUMBER NOWAIT;

Line 554: FROM CS_COV_REACTION_TIMES

550: FOR UPDATE OF OBJECT_VERSION_NUMBER NOWAIT;
551:
552: CURSOR lchk_csr IS
553: SELECT OBJECT_VERSION_NUMBER
554: FROM CS_COV_REACTION_TIMES
555: WHERE
556: REACTION_TIME_ID = p_reaction_time_id
557: ;
558: l_api_name CONSTANT VARCHAR2(30) := 'lock_row';

Line 561: l_object_version_number CS_COV_REACTION_TIMES.OBJECT_VERSION_NUMBER%TYPE;

557: ;
558: l_api_name CONSTANT VARCHAR2(30) := 'lock_row';
559: l_api_version CONSTANT NUMBER := 1;
560: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
561: l_object_version_number CS_COV_REACTION_TIMES.OBJECT_VERSION_NUMBER%TYPE;
562: lc_object_version_number CS_COV_REACTION_TIMES.OBJECT_VERSION_NUMBER%TYPE;
563: l_row_notfound BOOLEAN := FALSE;
564: lc_row_notfound BOOLEAN := FALSE;
565: BEGIN

Line 562: lc_object_version_number CS_COV_REACTION_TIMES.OBJECT_VERSION_NUMBER%TYPE;

558: l_api_name CONSTANT VARCHAR2(30) := 'lock_row';
559: l_api_version CONSTANT NUMBER := 1;
560: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
561: l_object_version_number CS_COV_REACTION_TIMES.OBJECT_VERSION_NUMBER%TYPE;
562: lc_object_version_number CS_COV_REACTION_TIMES.OBJECT_VERSION_NUMBER%TYPE;
563: l_row_notfound BOOLEAN := FALSE;
564: lc_row_notfound BOOLEAN := FALSE;
565: BEGIN
566: l_return_status := TAPI_DEV_KIT.START_ACTIVITY(l_api_name,

Line 669: FROM Cs_Cov_Reaction_Times

665: x_reacttime_rec OUT ReactTime_Rec_Type
666: ) RETURN VARCHAR2 IS
667: CURSOR cs_coverage_reaction1_csr (p_reaction_time_id IN NUMBER) IS
668: SELECT *
669: FROM Cs_Cov_Reaction_Times
670: WHERE cs_cov_reaction_times.reaction_time_id = p_reaction_time_id;
671: l_cs_coverage_reaction1 cs_coverage_reaction1_csr%ROWTYPE;
672: l_row_notfound BOOLEAN := TRUE;
673: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;

Line 670: WHERE cs_cov_reaction_times.reaction_time_id = p_reaction_time_id;

666: ) RETURN VARCHAR2 IS
667: CURSOR cs_coverage_reaction1_csr (p_reaction_time_id IN NUMBER) IS
668: SELECT *
669: FROM Cs_Cov_Reaction_Times
670: WHERE cs_cov_reaction_times.reaction_time_id = p_reaction_time_id;
671: l_cs_coverage_reaction1 cs_coverage_reaction1_csr%ROWTYPE;
672: l_row_notfound BOOLEAN := TRUE;
673: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
674: BEGIN

Line 887: UPDATE CS_COV_REACTION_TIMES

883: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
884: RAISE FND_API.G_EXC_ERROR;
885: END IF;
886: END IF;
887: UPDATE CS_COV_REACTION_TIMES
888: SET
889: REACTION_TIME_ID = l_def_reacttime_rec.reaction_time_id ,
890: NAME = l_def_reacttime_rec.name ,
891: DESCRIPTION = l_def_reacttime_rec.description ,

Line 976: p_name IN CS_COV_REACTION_TIMES.NAME%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

972: x_return_status OUT VARCHAR2,
973: x_msg_count OUT NUMBER,
974: x_msg_data OUT VARCHAR2,
975: p_reaction_time_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
976: p_name IN CS_COV_REACTION_TIMES.NAME%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
977: p_description IN CS_COV_REACTION_TIMES.DESCRIPTION%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
978: p_reaction_time_sunday IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
979: p_reaction_time_monday IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
980: p_reaction_time_tuesday IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,

Line 977: p_description IN CS_COV_REACTION_TIMES.DESCRIPTION%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

973: x_msg_count OUT NUMBER,
974: x_msg_data OUT VARCHAR2,
975: p_reaction_time_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
976: p_name IN CS_COV_REACTION_TIMES.NAME%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
977: p_description IN CS_COV_REACTION_TIMES.DESCRIPTION%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
978: p_reaction_time_sunday IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
979: p_reaction_time_monday IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
980: p_reaction_time_tuesday IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
981: p_reaction_time_wednesday IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,

Line 986: p_always_covered IN CS_COV_REACTION_TIMES.ALWAYS_COVERED%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

982: p_reaction_time_thursday IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
983: p_reaction_time_friday IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
984: p_reaction_time_saturday IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
985: p_incident_severity_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
986: p_always_covered IN CS_COV_REACTION_TIMES.ALWAYS_COVERED%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
987: p_workflow IN CS_COV_REACTION_TIMES.WORKFLOW%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
988: p_coverage_txn_group_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
989: p_use_for_sr_date_calc IN CS_COV_REACTION_TIMES.USE_FOR_SR_DATE_CALC%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
990: p_last_update_date IN CS_COV_REACTION_TIMES.LAST_UPDATE_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,

Line 987: p_workflow IN CS_COV_REACTION_TIMES.WORKFLOW%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

983: p_reaction_time_friday IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
984: p_reaction_time_saturday IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
985: p_incident_severity_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
986: p_always_covered IN CS_COV_REACTION_TIMES.ALWAYS_COVERED%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
987: p_workflow IN CS_COV_REACTION_TIMES.WORKFLOW%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
988: p_coverage_txn_group_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
989: p_use_for_sr_date_calc IN CS_COV_REACTION_TIMES.USE_FOR_SR_DATE_CALC%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
990: p_last_update_date IN CS_COV_REACTION_TIMES.LAST_UPDATE_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
991: p_last_updated_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,

Line 989: p_use_for_sr_date_calc IN CS_COV_REACTION_TIMES.USE_FOR_SR_DATE_CALC%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

985: p_incident_severity_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
986: p_always_covered IN CS_COV_REACTION_TIMES.ALWAYS_COVERED%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
987: p_workflow IN CS_COV_REACTION_TIMES.WORKFLOW%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
988: p_coverage_txn_group_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
989: p_use_for_sr_date_calc IN CS_COV_REACTION_TIMES.USE_FOR_SR_DATE_CALC%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
990: p_last_update_date IN CS_COV_REACTION_TIMES.LAST_UPDATE_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
991: p_last_updated_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
992: p_creation_date IN CS_COV_REACTION_TIMES.CREATION_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
993: p_created_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,

Line 990: p_last_update_date IN CS_COV_REACTION_TIMES.LAST_UPDATE_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,

986: p_always_covered IN CS_COV_REACTION_TIMES.ALWAYS_COVERED%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
987: p_workflow IN CS_COV_REACTION_TIMES.WORKFLOW%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
988: p_coverage_txn_group_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
989: p_use_for_sr_date_calc IN CS_COV_REACTION_TIMES.USE_FOR_SR_DATE_CALC%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
990: p_last_update_date IN CS_COV_REACTION_TIMES.LAST_UPDATE_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
991: p_last_updated_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
992: p_creation_date IN CS_COV_REACTION_TIMES.CREATION_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
993: p_created_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
994: p_last_update_login IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,

Line 992: p_creation_date IN CS_COV_REACTION_TIMES.CREATION_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,

988: p_coverage_txn_group_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
989: p_use_for_sr_date_calc IN CS_COV_REACTION_TIMES.USE_FOR_SR_DATE_CALC%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
990: p_last_update_date IN CS_COV_REACTION_TIMES.LAST_UPDATE_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
991: p_last_updated_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
992: p_creation_date IN CS_COV_REACTION_TIMES.CREATION_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
993: p_created_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
994: p_last_update_login IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
995: p_attribute1 IN CS_COV_REACTION_TIMES.ATTRIBUTE1%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
996: p_attribute2 IN CS_COV_REACTION_TIMES.ATTRIBUTE2%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

Line 995: p_attribute1 IN CS_COV_REACTION_TIMES.ATTRIBUTE1%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

991: p_last_updated_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
992: p_creation_date IN CS_COV_REACTION_TIMES.CREATION_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
993: p_created_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
994: p_last_update_login IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
995: p_attribute1 IN CS_COV_REACTION_TIMES.ATTRIBUTE1%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
996: p_attribute2 IN CS_COV_REACTION_TIMES.ATTRIBUTE2%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
997: p_attribute3 IN CS_COV_REACTION_TIMES.ATTRIBUTE3%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
998: p_attribute4 IN CS_COV_REACTION_TIMES.ATTRIBUTE4%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
999: p_attribute5 IN CS_COV_REACTION_TIMES.ATTRIBUTE5%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

Line 996: p_attribute2 IN CS_COV_REACTION_TIMES.ATTRIBUTE2%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

992: p_creation_date IN CS_COV_REACTION_TIMES.CREATION_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
993: p_created_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
994: p_last_update_login IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
995: p_attribute1 IN CS_COV_REACTION_TIMES.ATTRIBUTE1%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
996: p_attribute2 IN CS_COV_REACTION_TIMES.ATTRIBUTE2%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
997: p_attribute3 IN CS_COV_REACTION_TIMES.ATTRIBUTE3%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
998: p_attribute4 IN CS_COV_REACTION_TIMES.ATTRIBUTE4%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
999: p_attribute5 IN CS_COV_REACTION_TIMES.ATTRIBUTE5%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1000: p_attribute6 IN CS_COV_REACTION_TIMES.ATTRIBUTE6%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

Line 997: p_attribute3 IN CS_COV_REACTION_TIMES.ATTRIBUTE3%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

993: p_created_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
994: p_last_update_login IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
995: p_attribute1 IN CS_COV_REACTION_TIMES.ATTRIBUTE1%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
996: p_attribute2 IN CS_COV_REACTION_TIMES.ATTRIBUTE2%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
997: p_attribute3 IN CS_COV_REACTION_TIMES.ATTRIBUTE3%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
998: p_attribute4 IN CS_COV_REACTION_TIMES.ATTRIBUTE4%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
999: p_attribute5 IN CS_COV_REACTION_TIMES.ATTRIBUTE5%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1000: p_attribute6 IN CS_COV_REACTION_TIMES.ATTRIBUTE6%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1001: p_attribute7 IN CS_COV_REACTION_TIMES.ATTRIBUTE7%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

Line 998: p_attribute4 IN CS_COV_REACTION_TIMES.ATTRIBUTE4%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

994: p_last_update_login IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
995: p_attribute1 IN CS_COV_REACTION_TIMES.ATTRIBUTE1%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
996: p_attribute2 IN CS_COV_REACTION_TIMES.ATTRIBUTE2%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
997: p_attribute3 IN CS_COV_REACTION_TIMES.ATTRIBUTE3%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
998: p_attribute4 IN CS_COV_REACTION_TIMES.ATTRIBUTE4%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
999: p_attribute5 IN CS_COV_REACTION_TIMES.ATTRIBUTE5%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1000: p_attribute6 IN CS_COV_REACTION_TIMES.ATTRIBUTE6%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1001: p_attribute7 IN CS_COV_REACTION_TIMES.ATTRIBUTE7%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1002: p_attribute8 IN CS_COV_REACTION_TIMES.ATTRIBUTE8%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

Line 999: p_attribute5 IN CS_COV_REACTION_TIMES.ATTRIBUTE5%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

995: p_attribute1 IN CS_COV_REACTION_TIMES.ATTRIBUTE1%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
996: p_attribute2 IN CS_COV_REACTION_TIMES.ATTRIBUTE2%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
997: p_attribute3 IN CS_COV_REACTION_TIMES.ATTRIBUTE3%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
998: p_attribute4 IN CS_COV_REACTION_TIMES.ATTRIBUTE4%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
999: p_attribute5 IN CS_COV_REACTION_TIMES.ATTRIBUTE5%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1000: p_attribute6 IN CS_COV_REACTION_TIMES.ATTRIBUTE6%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1001: p_attribute7 IN CS_COV_REACTION_TIMES.ATTRIBUTE7%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1002: p_attribute8 IN CS_COV_REACTION_TIMES.ATTRIBUTE8%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1003: p_attribute9 IN CS_COV_REACTION_TIMES.ATTRIBUTE9%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

Line 1000: p_attribute6 IN CS_COV_REACTION_TIMES.ATTRIBUTE6%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

996: p_attribute2 IN CS_COV_REACTION_TIMES.ATTRIBUTE2%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
997: p_attribute3 IN CS_COV_REACTION_TIMES.ATTRIBUTE3%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
998: p_attribute4 IN CS_COV_REACTION_TIMES.ATTRIBUTE4%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
999: p_attribute5 IN CS_COV_REACTION_TIMES.ATTRIBUTE5%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1000: p_attribute6 IN CS_COV_REACTION_TIMES.ATTRIBUTE6%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1001: p_attribute7 IN CS_COV_REACTION_TIMES.ATTRIBUTE7%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1002: p_attribute8 IN CS_COV_REACTION_TIMES.ATTRIBUTE8%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1003: p_attribute9 IN CS_COV_REACTION_TIMES.ATTRIBUTE9%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1004: p_attribute10 IN CS_COV_REACTION_TIMES.ATTRIBUTE10%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

Line 1001: p_attribute7 IN CS_COV_REACTION_TIMES.ATTRIBUTE7%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

997: p_attribute3 IN CS_COV_REACTION_TIMES.ATTRIBUTE3%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
998: p_attribute4 IN CS_COV_REACTION_TIMES.ATTRIBUTE4%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
999: p_attribute5 IN CS_COV_REACTION_TIMES.ATTRIBUTE5%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1000: p_attribute6 IN CS_COV_REACTION_TIMES.ATTRIBUTE6%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1001: p_attribute7 IN CS_COV_REACTION_TIMES.ATTRIBUTE7%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1002: p_attribute8 IN CS_COV_REACTION_TIMES.ATTRIBUTE8%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1003: p_attribute9 IN CS_COV_REACTION_TIMES.ATTRIBUTE9%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1004: p_attribute10 IN CS_COV_REACTION_TIMES.ATTRIBUTE10%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1005: p_attribute11 IN CS_COV_REACTION_TIMES.ATTRIBUTE11%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

Line 1002: p_attribute8 IN CS_COV_REACTION_TIMES.ATTRIBUTE8%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

998: p_attribute4 IN CS_COV_REACTION_TIMES.ATTRIBUTE4%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
999: p_attribute5 IN CS_COV_REACTION_TIMES.ATTRIBUTE5%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1000: p_attribute6 IN CS_COV_REACTION_TIMES.ATTRIBUTE6%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1001: p_attribute7 IN CS_COV_REACTION_TIMES.ATTRIBUTE7%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1002: p_attribute8 IN CS_COV_REACTION_TIMES.ATTRIBUTE8%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1003: p_attribute9 IN CS_COV_REACTION_TIMES.ATTRIBUTE9%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1004: p_attribute10 IN CS_COV_REACTION_TIMES.ATTRIBUTE10%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1005: p_attribute11 IN CS_COV_REACTION_TIMES.ATTRIBUTE11%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1006: p_attribute12 IN CS_COV_REACTION_TIMES.ATTRIBUTE12%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

Line 1003: p_attribute9 IN CS_COV_REACTION_TIMES.ATTRIBUTE9%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

999: p_attribute5 IN CS_COV_REACTION_TIMES.ATTRIBUTE5%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1000: p_attribute6 IN CS_COV_REACTION_TIMES.ATTRIBUTE6%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1001: p_attribute7 IN CS_COV_REACTION_TIMES.ATTRIBUTE7%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1002: p_attribute8 IN CS_COV_REACTION_TIMES.ATTRIBUTE8%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1003: p_attribute9 IN CS_COV_REACTION_TIMES.ATTRIBUTE9%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1004: p_attribute10 IN CS_COV_REACTION_TIMES.ATTRIBUTE10%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1005: p_attribute11 IN CS_COV_REACTION_TIMES.ATTRIBUTE11%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1006: p_attribute12 IN CS_COV_REACTION_TIMES.ATTRIBUTE12%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1007: p_attribute13 IN CS_COV_REACTION_TIMES.ATTRIBUTE13%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

Line 1004: p_attribute10 IN CS_COV_REACTION_TIMES.ATTRIBUTE10%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

1000: p_attribute6 IN CS_COV_REACTION_TIMES.ATTRIBUTE6%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1001: p_attribute7 IN CS_COV_REACTION_TIMES.ATTRIBUTE7%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1002: p_attribute8 IN CS_COV_REACTION_TIMES.ATTRIBUTE8%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1003: p_attribute9 IN CS_COV_REACTION_TIMES.ATTRIBUTE9%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1004: p_attribute10 IN CS_COV_REACTION_TIMES.ATTRIBUTE10%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1005: p_attribute11 IN CS_COV_REACTION_TIMES.ATTRIBUTE11%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1006: p_attribute12 IN CS_COV_REACTION_TIMES.ATTRIBUTE12%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1007: p_attribute13 IN CS_COV_REACTION_TIMES.ATTRIBUTE13%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1008: p_attribute14 IN CS_COV_REACTION_TIMES.ATTRIBUTE14%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

Line 1005: p_attribute11 IN CS_COV_REACTION_TIMES.ATTRIBUTE11%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

1001: p_attribute7 IN CS_COV_REACTION_TIMES.ATTRIBUTE7%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1002: p_attribute8 IN CS_COV_REACTION_TIMES.ATTRIBUTE8%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1003: p_attribute9 IN CS_COV_REACTION_TIMES.ATTRIBUTE9%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1004: p_attribute10 IN CS_COV_REACTION_TIMES.ATTRIBUTE10%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1005: p_attribute11 IN CS_COV_REACTION_TIMES.ATTRIBUTE11%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1006: p_attribute12 IN CS_COV_REACTION_TIMES.ATTRIBUTE12%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1007: p_attribute13 IN CS_COV_REACTION_TIMES.ATTRIBUTE13%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1008: p_attribute14 IN CS_COV_REACTION_TIMES.ATTRIBUTE14%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1009: p_attribute15 IN CS_COV_REACTION_TIMES.ATTRIBUTE15%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

Line 1006: p_attribute12 IN CS_COV_REACTION_TIMES.ATTRIBUTE12%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

1002: p_attribute8 IN CS_COV_REACTION_TIMES.ATTRIBUTE8%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1003: p_attribute9 IN CS_COV_REACTION_TIMES.ATTRIBUTE9%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1004: p_attribute10 IN CS_COV_REACTION_TIMES.ATTRIBUTE10%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1005: p_attribute11 IN CS_COV_REACTION_TIMES.ATTRIBUTE11%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1006: p_attribute12 IN CS_COV_REACTION_TIMES.ATTRIBUTE12%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1007: p_attribute13 IN CS_COV_REACTION_TIMES.ATTRIBUTE13%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1008: p_attribute14 IN CS_COV_REACTION_TIMES.ATTRIBUTE14%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1009: p_attribute15 IN CS_COV_REACTION_TIMES.ATTRIBUTE15%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1010: p_context IN CS_COV_REACTION_TIMES.CONTEXT%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

Line 1007: p_attribute13 IN CS_COV_REACTION_TIMES.ATTRIBUTE13%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

1003: p_attribute9 IN CS_COV_REACTION_TIMES.ATTRIBUTE9%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1004: p_attribute10 IN CS_COV_REACTION_TIMES.ATTRIBUTE10%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1005: p_attribute11 IN CS_COV_REACTION_TIMES.ATTRIBUTE11%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1006: p_attribute12 IN CS_COV_REACTION_TIMES.ATTRIBUTE12%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1007: p_attribute13 IN CS_COV_REACTION_TIMES.ATTRIBUTE13%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1008: p_attribute14 IN CS_COV_REACTION_TIMES.ATTRIBUTE14%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1009: p_attribute15 IN CS_COV_REACTION_TIMES.ATTRIBUTE15%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1010: p_context IN CS_COV_REACTION_TIMES.CONTEXT%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1011: p_object_version_number IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,

Line 1008: p_attribute14 IN CS_COV_REACTION_TIMES.ATTRIBUTE14%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

1004: p_attribute10 IN CS_COV_REACTION_TIMES.ATTRIBUTE10%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1005: p_attribute11 IN CS_COV_REACTION_TIMES.ATTRIBUTE11%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1006: p_attribute12 IN CS_COV_REACTION_TIMES.ATTRIBUTE12%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1007: p_attribute13 IN CS_COV_REACTION_TIMES.ATTRIBUTE13%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1008: p_attribute14 IN CS_COV_REACTION_TIMES.ATTRIBUTE14%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1009: p_attribute15 IN CS_COV_REACTION_TIMES.ATTRIBUTE15%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1010: p_context IN CS_COV_REACTION_TIMES.CONTEXT%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1011: p_object_version_number IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1012: x_object_version_number OUT NUMBER) IS

Line 1009: p_attribute15 IN CS_COV_REACTION_TIMES.ATTRIBUTE15%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

1005: p_attribute11 IN CS_COV_REACTION_TIMES.ATTRIBUTE11%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1006: p_attribute12 IN CS_COV_REACTION_TIMES.ATTRIBUTE12%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1007: p_attribute13 IN CS_COV_REACTION_TIMES.ATTRIBUTE13%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1008: p_attribute14 IN CS_COV_REACTION_TIMES.ATTRIBUTE14%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1009: p_attribute15 IN CS_COV_REACTION_TIMES.ATTRIBUTE15%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1010: p_context IN CS_COV_REACTION_TIMES.CONTEXT%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1011: p_object_version_number IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1012: x_object_version_number OUT NUMBER) IS
1013: l_api_name CONSTANT VARCHAR2(30) := 'update_row';

Line 1010: p_context IN CS_COV_REACTION_TIMES.CONTEXT%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

1006: p_attribute12 IN CS_COV_REACTION_TIMES.ATTRIBUTE12%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1007: p_attribute13 IN CS_COV_REACTION_TIMES.ATTRIBUTE13%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1008: p_attribute14 IN CS_COV_REACTION_TIMES.ATTRIBUTE14%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1009: p_attribute15 IN CS_COV_REACTION_TIMES.ATTRIBUTE15%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1010: p_context IN CS_COV_REACTION_TIMES.CONTEXT%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1011: p_object_version_number IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1012: x_object_version_number OUT NUMBER) IS
1013: l_api_name CONSTANT VARCHAR2(30) := 'update_row';
1014: l_api_version CONSTANT NUMBER := 1;

Line 1140: DELETE FROM CS_COV_REACTION_TIMES

1136: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1137: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
1138: RAISE FND_API.G_EXC_ERROR;
1139: END IF;
1140: DELETE FROM CS_COV_REACTION_TIMES
1141: WHERE
1142: REACTION_TIME_ID = p_reaction_time_id
1143: ;
1144: TAPI_DEV_KIT.END_ACTIVITY(p_commit, x_msg_count, x_msg_data);

Line 1276: p_name IN CS_COV_REACTION_TIMES.NAME%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

1272: x_return_status OUT VARCHAR2,
1273: x_msg_count OUT NUMBER,
1274: x_msg_data OUT VARCHAR2,
1275: p_reaction_time_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1276: p_name IN CS_COV_REACTION_TIMES.NAME%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1277: p_description IN CS_COV_REACTION_TIMES.DESCRIPTION%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1278: p_reaction_time_sunday IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1279: p_reaction_time_monday IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1280: p_reaction_time_tuesday IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,

Line 1277: p_description IN CS_COV_REACTION_TIMES.DESCRIPTION%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

1273: x_msg_count OUT NUMBER,
1274: x_msg_data OUT VARCHAR2,
1275: p_reaction_time_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1276: p_name IN CS_COV_REACTION_TIMES.NAME%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1277: p_description IN CS_COV_REACTION_TIMES.DESCRIPTION%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1278: p_reaction_time_sunday IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1279: p_reaction_time_monday IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1280: p_reaction_time_tuesday IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1281: p_reaction_time_wednesday IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,

Line 1286: p_always_covered IN CS_COV_REACTION_TIMES.ALWAYS_COVERED%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

1282: p_reaction_time_thursday IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1283: p_reaction_time_friday IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1284: p_reaction_time_saturday IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1285: p_incident_severity_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1286: p_always_covered IN CS_COV_REACTION_TIMES.ALWAYS_COVERED%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1287: p_workflow IN CS_COV_REACTION_TIMES.WORKFLOW%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1288: p_coverage_txn_group_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1289: p_use_for_sr_date_calc IN CS_COV_REACTION_TIMES.USE_FOR_SR_DATE_CALC%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1290: p_last_update_date IN CS_COV_REACTION_TIMES.LAST_UPDATE_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,

Line 1287: p_workflow IN CS_COV_REACTION_TIMES.WORKFLOW%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

1283: p_reaction_time_friday IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1284: p_reaction_time_saturday IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1285: p_incident_severity_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1286: p_always_covered IN CS_COV_REACTION_TIMES.ALWAYS_COVERED%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1287: p_workflow IN CS_COV_REACTION_TIMES.WORKFLOW%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1288: p_coverage_txn_group_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1289: p_use_for_sr_date_calc IN CS_COV_REACTION_TIMES.USE_FOR_SR_DATE_CALC%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1290: p_last_update_date IN CS_COV_REACTION_TIMES.LAST_UPDATE_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1291: p_last_updated_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,

Line 1289: p_use_for_sr_date_calc IN CS_COV_REACTION_TIMES.USE_FOR_SR_DATE_CALC%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

1285: p_incident_severity_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1286: p_always_covered IN CS_COV_REACTION_TIMES.ALWAYS_COVERED%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1287: p_workflow IN CS_COV_REACTION_TIMES.WORKFLOW%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1288: p_coverage_txn_group_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1289: p_use_for_sr_date_calc IN CS_COV_REACTION_TIMES.USE_FOR_SR_DATE_CALC%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1290: p_last_update_date IN CS_COV_REACTION_TIMES.LAST_UPDATE_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1291: p_last_updated_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1292: p_creation_date IN CS_COV_REACTION_TIMES.CREATION_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1293: p_created_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,

Line 1290: p_last_update_date IN CS_COV_REACTION_TIMES.LAST_UPDATE_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,

1286: p_always_covered IN CS_COV_REACTION_TIMES.ALWAYS_COVERED%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1287: p_workflow IN CS_COV_REACTION_TIMES.WORKFLOW%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1288: p_coverage_txn_group_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1289: p_use_for_sr_date_calc IN CS_COV_REACTION_TIMES.USE_FOR_SR_DATE_CALC%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1290: p_last_update_date IN CS_COV_REACTION_TIMES.LAST_UPDATE_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1291: p_last_updated_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1292: p_creation_date IN CS_COV_REACTION_TIMES.CREATION_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1293: p_created_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1294: p_last_update_login IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,

Line 1292: p_creation_date IN CS_COV_REACTION_TIMES.CREATION_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,

1288: p_coverage_txn_group_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1289: p_use_for_sr_date_calc IN CS_COV_REACTION_TIMES.USE_FOR_SR_DATE_CALC%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1290: p_last_update_date IN CS_COV_REACTION_TIMES.LAST_UPDATE_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1291: p_last_updated_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1292: p_creation_date IN CS_COV_REACTION_TIMES.CREATION_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1293: p_created_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1294: p_last_update_login IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1295: p_attribute1 IN CS_COV_REACTION_TIMES.ATTRIBUTE1%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1296: p_attribute2 IN CS_COV_REACTION_TIMES.ATTRIBUTE2%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

Line 1295: p_attribute1 IN CS_COV_REACTION_TIMES.ATTRIBUTE1%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

1291: p_last_updated_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1292: p_creation_date IN CS_COV_REACTION_TIMES.CREATION_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1293: p_created_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1294: p_last_update_login IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1295: p_attribute1 IN CS_COV_REACTION_TIMES.ATTRIBUTE1%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1296: p_attribute2 IN CS_COV_REACTION_TIMES.ATTRIBUTE2%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1297: p_attribute3 IN CS_COV_REACTION_TIMES.ATTRIBUTE3%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1298: p_attribute4 IN CS_COV_REACTION_TIMES.ATTRIBUTE4%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1299: p_attribute5 IN CS_COV_REACTION_TIMES.ATTRIBUTE5%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

Line 1296: p_attribute2 IN CS_COV_REACTION_TIMES.ATTRIBUTE2%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

1292: p_creation_date IN CS_COV_REACTION_TIMES.CREATION_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1293: p_created_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1294: p_last_update_login IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1295: p_attribute1 IN CS_COV_REACTION_TIMES.ATTRIBUTE1%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1296: p_attribute2 IN CS_COV_REACTION_TIMES.ATTRIBUTE2%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1297: p_attribute3 IN CS_COV_REACTION_TIMES.ATTRIBUTE3%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1298: p_attribute4 IN CS_COV_REACTION_TIMES.ATTRIBUTE4%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1299: p_attribute5 IN CS_COV_REACTION_TIMES.ATTRIBUTE5%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1300: p_attribute6 IN CS_COV_REACTION_TIMES.ATTRIBUTE6%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

Line 1297: p_attribute3 IN CS_COV_REACTION_TIMES.ATTRIBUTE3%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

1293: p_created_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1294: p_last_update_login IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1295: p_attribute1 IN CS_COV_REACTION_TIMES.ATTRIBUTE1%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1296: p_attribute2 IN CS_COV_REACTION_TIMES.ATTRIBUTE2%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1297: p_attribute3 IN CS_COV_REACTION_TIMES.ATTRIBUTE3%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1298: p_attribute4 IN CS_COV_REACTION_TIMES.ATTRIBUTE4%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1299: p_attribute5 IN CS_COV_REACTION_TIMES.ATTRIBUTE5%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1300: p_attribute6 IN CS_COV_REACTION_TIMES.ATTRIBUTE6%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1301: p_attribute7 IN CS_COV_REACTION_TIMES.ATTRIBUTE7%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

Line 1298: p_attribute4 IN CS_COV_REACTION_TIMES.ATTRIBUTE4%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

1294: p_last_update_login IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1295: p_attribute1 IN CS_COV_REACTION_TIMES.ATTRIBUTE1%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1296: p_attribute2 IN CS_COV_REACTION_TIMES.ATTRIBUTE2%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1297: p_attribute3 IN CS_COV_REACTION_TIMES.ATTRIBUTE3%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1298: p_attribute4 IN CS_COV_REACTION_TIMES.ATTRIBUTE4%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1299: p_attribute5 IN CS_COV_REACTION_TIMES.ATTRIBUTE5%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1300: p_attribute6 IN CS_COV_REACTION_TIMES.ATTRIBUTE6%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1301: p_attribute7 IN CS_COV_REACTION_TIMES.ATTRIBUTE7%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1302: p_attribute8 IN CS_COV_REACTION_TIMES.ATTRIBUTE8%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

Line 1299: p_attribute5 IN CS_COV_REACTION_TIMES.ATTRIBUTE5%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

1295: p_attribute1 IN CS_COV_REACTION_TIMES.ATTRIBUTE1%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1296: p_attribute2 IN CS_COV_REACTION_TIMES.ATTRIBUTE2%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1297: p_attribute3 IN CS_COV_REACTION_TIMES.ATTRIBUTE3%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1298: p_attribute4 IN CS_COV_REACTION_TIMES.ATTRIBUTE4%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1299: p_attribute5 IN CS_COV_REACTION_TIMES.ATTRIBUTE5%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1300: p_attribute6 IN CS_COV_REACTION_TIMES.ATTRIBUTE6%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1301: p_attribute7 IN CS_COV_REACTION_TIMES.ATTRIBUTE7%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1302: p_attribute8 IN CS_COV_REACTION_TIMES.ATTRIBUTE8%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1303: p_attribute9 IN CS_COV_REACTION_TIMES.ATTRIBUTE9%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

Line 1300: p_attribute6 IN CS_COV_REACTION_TIMES.ATTRIBUTE6%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

1296: p_attribute2 IN CS_COV_REACTION_TIMES.ATTRIBUTE2%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1297: p_attribute3 IN CS_COV_REACTION_TIMES.ATTRIBUTE3%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1298: p_attribute4 IN CS_COV_REACTION_TIMES.ATTRIBUTE4%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1299: p_attribute5 IN CS_COV_REACTION_TIMES.ATTRIBUTE5%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1300: p_attribute6 IN CS_COV_REACTION_TIMES.ATTRIBUTE6%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1301: p_attribute7 IN CS_COV_REACTION_TIMES.ATTRIBUTE7%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1302: p_attribute8 IN CS_COV_REACTION_TIMES.ATTRIBUTE8%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1303: p_attribute9 IN CS_COV_REACTION_TIMES.ATTRIBUTE9%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1304: p_attribute10 IN CS_COV_REACTION_TIMES.ATTRIBUTE10%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

Line 1301: p_attribute7 IN CS_COV_REACTION_TIMES.ATTRIBUTE7%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

1297: p_attribute3 IN CS_COV_REACTION_TIMES.ATTRIBUTE3%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1298: p_attribute4 IN CS_COV_REACTION_TIMES.ATTRIBUTE4%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1299: p_attribute5 IN CS_COV_REACTION_TIMES.ATTRIBUTE5%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1300: p_attribute6 IN CS_COV_REACTION_TIMES.ATTRIBUTE6%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1301: p_attribute7 IN CS_COV_REACTION_TIMES.ATTRIBUTE7%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1302: p_attribute8 IN CS_COV_REACTION_TIMES.ATTRIBUTE8%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1303: p_attribute9 IN CS_COV_REACTION_TIMES.ATTRIBUTE9%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1304: p_attribute10 IN CS_COV_REACTION_TIMES.ATTRIBUTE10%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1305: p_attribute11 IN CS_COV_REACTION_TIMES.ATTRIBUTE11%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

Line 1302: p_attribute8 IN CS_COV_REACTION_TIMES.ATTRIBUTE8%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

1298: p_attribute4 IN CS_COV_REACTION_TIMES.ATTRIBUTE4%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1299: p_attribute5 IN CS_COV_REACTION_TIMES.ATTRIBUTE5%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1300: p_attribute6 IN CS_COV_REACTION_TIMES.ATTRIBUTE6%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1301: p_attribute7 IN CS_COV_REACTION_TIMES.ATTRIBUTE7%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1302: p_attribute8 IN CS_COV_REACTION_TIMES.ATTRIBUTE8%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1303: p_attribute9 IN CS_COV_REACTION_TIMES.ATTRIBUTE9%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1304: p_attribute10 IN CS_COV_REACTION_TIMES.ATTRIBUTE10%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1305: p_attribute11 IN CS_COV_REACTION_TIMES.ATTRIBUTE11%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1306: p_attribute12 IN CS_COV_REACTION_TIMES.ATTRIBUTE12%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

Line 1303: p_attribute9 IN CS_COV_REACTION_TIMES.ATTRIBUTE9%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

1299: p_attribute5 IN CS_COV_REACTION_TIMES.ATTRIBUTE5%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1300: p_attribute6 IN CS_COV_REACTION_TIMES.ATTRIBUTE6%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1301: p_attribute7 IN CS_COV_REACTION_TIMES.ATTRIBUTE7%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1302: p_attribute8 IN CS_COV_REACTION_TIMES.ATTRIBUTE8%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1303: p_attribute9 IN CS_COV_REACTION_TIMES.ATTRIBUTE9%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1304: p_attribute10 IN CS_COV_REACTION_TIMES.ATTRIBUTE10%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1305: p_attribute11 IN CS_COV_REACTION_TIMES.ATTRIBUTE11%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1306: p_attribute12 IN CS_COV_REACTION_TIMES.ATTRIBUTE12%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1307: p_attribute13 IN CS_COV_REACTION_TIMES.ATTRIBUTE13%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

Line 1304: p_attribute10 IN CS_COV_REACTION_TIMES.ATTRIBUTE10%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

1300: p_attribute6 IN CS_COV_REACTION_TIMES.ATTRIBUTE6%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1301: p_attribute7 IN CS_COV_REACTION_TIMES.ATTRIBUTE7%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1302: p_attribute8 IN CS_COV_REACTION_TIMES.ATTRIBUTE8%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1303: p_attribute9 IN CS_COV_REACTION_TIMES.ATTRIBUTE9%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1304: p_attribute10 IN CS_COV_REACTION_TIMES.ATTRIBUTE10%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1305: p_attribute11 IN CS_COV_REACTION_TIMES.ATTRIBUTE11%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1306: p_attribute12 IN CS_COV_REACTION_TIMES.ATTRIBUTE12%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1307: p_attribute13 IN CS_COV_REACTION_TIMES.ATTRIBUTE13%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1308: p_attribute14 IN CS_COV_REACTION_TIMES.ATTRIBUTE14%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

Line 1305: p_attribute11 IN CS_COV_REACTION_TIMES.ATTRIBUTE11%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

1301: p_attribute7 IN CS_COV_REACTION_TIMES.ATTRIBUTE7%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1302: p_attribute8 IN CS_COV_REACTION_TIMES.ATTRIBUTE8%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1303: p_attribute9 IN CS_COV_REACTION_TIMES.ATTRIBUTE9%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1304: p_attribute10 IN CS_COV_REACTION_TIMES.ATTRIBUTE10%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1305: p_attribute11 IN CS_COV_REACTION_TIMES.ATTRIBUTE11%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1306: p_attribute12 IN CS_COV_REACTION_TIMES.ATTRIBUTE12%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1307: p_attribute13 IN CS_COV_REACTION_TIMES.ATTRIBUTE13%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1308: p_attribute14 IN CS_COV_REACTION_TIMES.ATTRIBUTE14%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1309: p_attribute15 IN CS_COV_REACTION_TIMES.ATTRIBUTE15%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

Line 1306: p_attribute12 IN CS_COV_REACTION_TIMES.ATTRIBUTE12%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

1302: p_attribute8 IN CS_COV_REACTION_TIMES.ATTRIBUTE8%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1303: p_attribute9 IN CS_COV_REACTION_TIMES.ATTRIBUTE9%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1304: p_attribute10 IN CS_COV_REACTION_TIMES.ATTRIBUTE10%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1305: p_attribute11 IN CS_COV_REACTION_TIMES.ATTRIBUTE11%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1306: p_attribute12 IN CS_COV_REACTION_TIMES.ATTRIBUTE12%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1307: p_attribute13 IN CS_COV_REACTION_TIMES.ATTRIBUTE13%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1308: p_attribute14 IN CS_COV_REACTION_TIMES.ATTRIBUTE14%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1309: p_attribute15 IN CS_COV_REACTION_TIMES.ATTRIBUTE15%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1310: p_context IN CS_COV_REACTION_TIMES.CONTEXT%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

Line 1307: p_attribute13 IN CS_COV_REACTION_TIMES.ATTRIBUTE13%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

1303: p_attribute9 IN CS_COV_REACTION_TIMES.ATTRIBUTE9%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1304: p_attribute10 IN CS_COV_REACTION_TIMES.ATTRIBUTE10%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1305: p_attribute11 IN CS_COV_REACTION_TIMES.ATTRIBUTE11%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1306: p_attribute12 IN CS_COV_REACTION_TIMES.ATTRIBUTE12%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1307: p_attribute13 IN CS_COV_REACTION_TIMES.ATTRIBUTE13%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1308: p_attribute14 IN CS_COV_REACTION_TIMES.ATTRIBUTE14%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1309: p_attribute15 IN CS_COV_REACTION_TIMES.ATTRIBUTE15%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1310: p_context IN CS_COV_REACTION_TIMES.CONTEXT%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1311: p_object_version_number IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM) IS

Line 1308: p_attribute14 IN CS_COV_REACTION_TIMES.ATTRIBUTE14%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

1304: p_attribute10 IN CS_COV_REACTION_TIMES.ATTRIBUTE10%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1305: p_attribute11 IN CS_COV_REACTION_TIMES.ATTRIBUTE11%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1306: p_attribute12 IN CS_COV_REACTION_TIMES.ATTRIBUTE12%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1307: p_attribute13 IN CS_COV_REACTION_TIMES.ATTRIBUTE13%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1308: p_attribute14 IN CS_COV_REACTION_TIMES.ATTRIBUTE14%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1309: p_attribute15 IN CS_COV_REACTION_TIMES.ATTRIBUTE15%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1310: p_context IN CS_COV_REACTION_TIMES.CONTEXT%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1311: p_object_version_number IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM) IS
1312: l_api_name CONSTANT VARCHAR2(30) := 'validate_row';

Line 1309: p_attribute15 IN CS_COV_REACTION_TIMES.ATTRIBUTE15%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

1305: p_attribute11 IN CS_COV_REACTION_TIMES.ATTRIBUTE11%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1306: p_attribute12 IN CS_COV_REACTION_TIMES.ATTRIBUTE12%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1307: p_attribute13 IN CS_COV_REACTION_TIMES.ATTRIBUTE13%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1308: p_attribute14 IN CS_COV_REACTION_TIMES.ATTRIBUTE14%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1309: p_attribute15 IN CS_COV_REACTION_TIMES.ATTRIBUTE15%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1310: p_context IN CS_COV_REACTION_TIMES.CONTEXT%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1311: p_object_version_number IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM) IS
1312: l_api_name CONSTANT VARCHAR2(30) := 'validate_row';
1313: l_api_version CONSTANT NUMBER := 1;

Line 1310: p_context IN CS_COV_REACTION_TIMES.CONTEXT%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

1306: p_attribute12 IN CS_COV_REACTION_TIMES.ATTRIBUTE12%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1307: p_attribute13 IN CS_COV_REACTION_TIMES.ATTRIBUTE13%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1308: p_attribute14 IN CS_COV_REACTION_TIMES.ATTRIBUTE14%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1309: p_attribute15 IN CS_COV_REACTION_TIMES.ATTRIBUTE15%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1310: p_context IN CS_COV_REACTION_TIMES.CONTEXT%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1311: p_object_version_number IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM) IS
1312: l_api_name CONSTANT VARCHAR2(30) := 'validate_row';
1313: l_api_version CONSTANT NUMBER := 1;
1314: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;