1: PACKAGE BODY CS_COUNTERFILTER_PVT AS
2: /* $Header: csctdflb.pls 115.9 2002/11/18 21:57:28 mkommuri ship $ */
3: FUNCTION get_seq_id RETURN NUMBER IS
4: CURSOR get_seq_id_csr IS
5: SELECT CS_COUNTER_DER_FILTERS_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;
226: END IF;
227: END IF;
228: -- Set primary key value
229: l_def_counterfilter_rec.counter_der_filter_id := get_seq_id;
230: INSERT INTO CS_COUNTER_DER_FILTERS(
231: counter_der_filter_id,
232: counter_id,
233: seq_no,
234: left_paren,
340: x_msg_count OUT NOCOPY NUMBER,
341: x_msg_data OUT NOCOPY VARCHAR2,
342: p_counter_id IN NUMBER := NULL,
343: p_seq_no IN NUMBER := NULL,
344: p_left_paren IN CS_COUNTER_DER_FILTERS.LEFT_PAREN%TYPE := NULL,
345: p_counter_property_id IN NUMBER := NULL,
346: p_relational_operator IN CS_COUNTER_DER_FILTERS.RELATIONAL_OPERATOR%TYPE := NULL,
347: p_right_paren IN CS_COUNTER_DER_FILTERS.RIGHT_PAREN%TYPE := NULL,
348: p_right_value IN CS_COUNTER_DER_FILTERS.RIGHT_VALUE%TYPE := NULL,
342: p_counter_id IN NUMBER := NULL,
343: p_seq_no IN NUMBER := NULL,
344: p_left_paren IN CS_COUNTER_DER_FILTERS.LEFT_PAREN%TYPE := NULL,
345: p_counter_property_id IN NUMBER := NULL,
346: p_relational_operator IN CS_COUNTER_DER_FILTERS.RELATIONAL_OPERATOR%TYPE := NULL,
347: p_right_paren IN CS_COUNTER_DER_FILTERS.RIGHT_PAREN%TYPE := NULL,
348: p_right_value IN CS_COUNTER_DER_FILTERS.RIGHT_VALUE%TYPE := NULL,
349: p_logical_operator IN CS_COUNTER_DER_FILTERS.LOGICAL_OPERATOR%TYPE := NULL,
350: p_last_update_date IN CS_COUNTER_DER_FILTERS.LAST_UPDATE_DATE%TYPE := NULL,
343: p_seq_no IN NUMBER := NULL,
344: p_left_paren IN CS_COUNTER_DER_FILTERS.LEFT_PAREN%TYPE := NULL,
345: p_counter_property_id IN NUMBER := NULL,
346: p_relational_operator IN CS_COUNTER_DER_FILTERS.RELATIONAL_OPERATOR%TYPE := NULL,
347: p_right_paren IN CS_COUNTER_DER_FILTERS.RIGHT_PAREN%TYPE := NULL,
348: p_right_value IN CS_COUNTER_DER_FILTERS.RIGHT_VALUE%TYPE := NULL,
349: p_logical_operator IN CS_COUNTER_DER_FILTERS.LOGICAL_OPERATOR%TYPE := NULL,
350: p_last_update_date IN CS_COUNTER_DER_FILTERS.LAST_UPDATE_DATE%TYPE := NULL,
351: p_last_updated_by IN NUMBER := NULL,
344: p_left_paren IN CS_COUNTER_DER_FILTERS.LEFT_PAREN%TYPE := NULL,
345: p_counter_property_id IN NUMBER := NULL,
346: p_relational_operator IN CS_COUNTER_DER_FILTERS.RELATIONAL_OPERATOR%TYPE := NULL,
347: p_right_paren IN CS_COUNTER_DER_FILTERS.RIGHT_PAREN%TYPE := NULL,
348: p_right_value IN CS_COUNTER_DER_FILTERS.RIGHT_VALUE%TYPE := NULL,
349: p_logical_operator IN CS_COUNTER_DER_FILTERS.LOGICAL_OPERATOR%TYPE := NULL,
350: p_last_update_date IN CS_COUNTER_DER_FILTERS.LAST_UPDATE_DATE%TYPE := NULL,
351: p_last_updated_by IN NUMBER := NULL,
352: p_creation_date IN CS_COUNTER_DER_FILTERS.CREATION_DATE%TYPE := NULL,
345: p_counter_property_id IN NUMBER := NULL,
346: p_relational_operator IN CS_COUNTER_DER_FILTERS.RELATIONAL_OPERATOR%TYPE := NULL,
347: p_right_paren IN CS_COUNTER_DER_FILTERS.RIGHT_PAREN%TYPE := NULL,
348: p_right_value IN CS_COUNTER_DER_FILTERS.RIGHT_VALUE%TYPE := NULL,
349: p_logical_operator IN CS_COUNTER_DER_FILTERS.LOGICAL_OPERATOR%TYPE := NULL,
350: p_last_update_date IN CS_COUNTER_DER_FILTERS.LAST_UPDATE_DATE%TYPE := NULL,
351: p_last_updated_by IN NUMBER := NULL,
352: p_creation_date IN CS_COUNTER_DER_FILTERS.CREATION_DATE%TYPE := NULL,
353: p_created_by IN NUMBER := NULL,
346: p_relational_operator IN CS_COUNTER_DER_FILTERS.RELATIONAL_OPERATOR%TYPE := NULL,
347: p_right_paren IN CS_COUNTER_DER_FILTERS.RIGHT_PAREN%TYPE := NULL,
348: p_right_value IN CS_COUNTER_DER_FILTERS.RIGHT_VALUE%TYPE := NULL,
349: p_logical_operator IN CS_COUNTER_DER_FILTERS.LOGICAL_OPERATOR%TYPE := NULL,
350: p_last_update_date IN CS_COUNTER_DER_FILTERS.LAST_UPDATE_DATE%TYPE := NULL,
351: p_last_updated_by IN NUMBER := NULL,
352: p_creation_date IN CS_COUNTER_DER_FILTERS.CREATION_DATE%TYPE := NULL,
353: p_created_by IN NUMBER := NULL,
354: p_last_update_login IN NUMBER := NULL,
348: p_right_value IN CS_COUNTER_DER_FILTERS.RIGHT_VALUE%TYPE := NULL,
349: p_logical_operator IN CS_COUNTER_DER_FILTERS.LOGICAL_OPERATOR%TYPE := NULL,
350: p_last_update_date IN CS_COUNTER_DER_FILTERS.LAST_UPDATE_DATE%TYPE := NULL,
351: p_last_updated_by IN NUMBER := NULL,
352: p_creation_date IN CS_COUNTER_DER_FILTERS.CREATION_DATE%TYPE := NULL,
353: p_created_by IN NUMBER := NULL,
354: p_last_update_login IN NUMBER := NULL,
355: p_attribute1 IN CS_COUNTER_DER_FILTERS.ATTRIBUTE1%TYPE := NULL,
356: p_attribute2 IN CS_COUNTER_DER_FILTERS.ATTRIBUTE2%TYPE := NULL,
351: p_last_updated_by IN NUMBER := NULL,
352: p_creation_date IN CS_COUNTER_DER_FILTERS.CREATION_DATE%TYPE := NULL,
353: p_created_by IN NUMBER := NULL,
354: p_last_update_login IN NUMBER := NULL,
355: p_attribute1 IN CS_COUNTER_DER_FILTERS.ATTRIBUTE1%TYPE := NULL,
356: p_attribute2 IN CS_COUNTER_DER_FILTERS.ATTRIBUTE2%TYPE := NULL,
357: p_attribute3 IN CS_COUNTER_DER_FILTERS.ATTRIBUTE3%TYPE := NULL,
358: p_attribute4 IN CS_COUNTER_DER_FILTERS.ATTRIBUTE4%TYPE := NULL,
359: p_attribute5 IN CS_COUNTER_DER_FILTERS.ATTRIBUTE5%TYPE := NULL,
352: p_creation_date IN CS_COUNTER_DER_FILTERS.CREATION_DATE%TYPE := NULL,
353: p_created_by IN NUMBER := NULL,
354: p_last_update_login IN NUMBER := NULL,
355: p_attribute1 IN CS_COUNTER_DER_FILTERS.ATTRIBUTE1%TYPE := NULL,
356: p_attribute2 IN CS_COUNTER_DER_FILTERS.ATTRIBUTE2%TYPE := NULL,
357: p_attribute3 IN CS_COUNTER_DER_FILTERS.ATTRIBUTE3%TYPE := NULL,
358: p_attribute4 IN CS_COUNTER_DER_FILTERS.ATTRIBUTE4%TYPE := NULL,
359: p_attribute5 IN CS_COUNTER_DER_FILTERS.ATTRIBUTE5%TYPE := NULL,
360: p_attribute6 IN CS_COUNTER_DER_FILTERS.ATTRIBUTE6%TYPE := NULL,
353: p_created_by IN NUMBER := NULL,
354: p_last_update_login IN NUMBER := NULL,
355: p_attribute1 IN CS_COUNTER_DER_FILTERS.ATTRIBUTE1%TYPE := NULL,
356: p_attribute2 IN CS_COUNTER_DER_FILTERS.ATTRIBUTE2%TYPE := NULL,
357: p_attribute3 IN CS_COUNTER_DER_FILTERS.ATTRIBUTE3%TYPE := NULL,
358: p_attribute4 IN CS_COUNTER_DER_FILTERS.ATTRIBUTE4%TYPE := NULL,
359: p_attribute5 IN CS_COUNTER_DER_FILTERS.ATTRIBUTE5%TYPE := NULL,
360: p_attribute6 IN CS_COUNTER_DER_FILTERS.ATTRIBUTE6%TYPE := NULL,
361: p_attribute7 IN CS_COUNTER_DER_FILTERS.ATTRIBUTE7%TYPE := NULL,
354: p_last_update_login IN NUMBER := NULL,
355: p_attribute1 IN CS_COUNTER_DER_FILTERS.ATTRIBUTE1%TYPE := NULL,
356: p_attribute2 IN CS_COUNTER_DER_FILTERS.ATTRIBUTE2%TYPE := NULL,
357: p_attribute3 IN CS_COUNTER_DER_FILTERS.ATTRIBUTE3%TYPE := NULL,
358: p_attribute4 IN CS_COUNTER_DER_FILTERS.ATTRIBUTE4%TYPE := NULL,
359: p_attribute5 IN CS_COUNTER_DER_FILTERS.ATTRIBUTE5%TYPE := NULL,
360: p_attribute6 IN CS_COUNTER_DER_FILTERS.ATTRIBUTE6%TYPE := NULL,
361: p_attribute7 IN CS_COUNTER_DER_FILTERS.ATTRIBUTE7%TYPE := NULL,
362: p_attribute8 IN CS_COUNTER_DER_FILTERS.ATTRIBUTE8%TYPE := NULL,
355: p_attribute1 IN CS_COUNTER_DER_FILTERS.ATTRIBUTE1%TYPE := NULL,
356: p_attribute2 IN CS_COUNTER_DER_FILTERS.ATTRIBUTE2%TYPE := NULL,
357: p_attribute3 IN CS_COUNTER_DER_FILTERS.ATTRIBUTE3%TYPE := NULL,
358: p_attribute4 IN CS_COUNTER_DER_FILTERS.ATTRIBUTE4%TYPE := NULL,
359: p_attribute5 IN CS_COUNTER_DER_FILTERS.ATTRIBUTE5%TYPE := NULL,
360: p_attribute6 IN CS_COUNTER_DER_FILTERS.ATTRIBUTE6%TYPE := NULL,
361: p_attribute7 IN CS_COUNTER_DER_FILTERS.ATTRIBUTE7%TYPE := NULL,
362: p_attribute8 IN CS_COUNTER_DER_FILTERS.ATTRIBUTE8%TYPE := NULL,
363: p_attribute9 IN CS_COUNTER_DER_FILTERS.ATTRIBUTE9%TYPE := NULL,
356: p_attribute2 IN CS_COUNTER_DER_FILTERS.ATTRIBUTE2%TYPE := NULL,
357: p_attribute3 IN CS_COUNTER_DER_FILTERS.ATTRIBUTE3%TYPE := NULL,
358: p_attribute4 IN CS_COUNTER_DER_FILTERS.ATTRIBUTE4%TYPE := NULL,
359: p_attribute5 IN CS_COUNTER_DER_FILTERS.ATTRIBUTE5%TYPE := NULL,
360: p_attribute6 IN CS_COUNTER_DER_FILTERS.ATTRIBUTE6%TYPE := NULL,
361: p_attribute7 IN CS_COUNTER_DER_FILTERS.ATTRIBUTE7%TYPE := NULL,
362: p_attribute8 IN CS_COUNTER_DER_FILTERS.ATTRIBUTE8%TYPE := NULL,
363: p_attribute9 IN CS_COUNTER_DER_FILTERS.ATTRIBUTE9%TYPE := NULL,
364: p_attribute10 IN CS_COUNTER_DER_FILTERS.ATTRIBUTE10%TYPE := NULL,
357: p_attribute3 IN CS_COUNTER_DER_FILTERS.ATTRIBUTE3%TYPE := NULL,
358: p_attribute4 IN CS_COUNTER_DER_FILTERS.ATTRIBUTE4%TYPE := NULL,
359: p_attribute5 IN CS_COUNTER_DER_FILTERS.ATTRIBUTE5%TYPE := NULL,
360: p_attribute6 IN CS_COUNTER_DER_FILTERS.ATTRIBUTE6%TYPE := NULL,
361: p_attribute7 IN CS_COUNTER_DER_FILTERS.ATTRIBUTE7%TYPE := NULL,
362: p_attribute8 IN CS_COUNTER_DER_FILTERS.ATTRIBUTE8%TYPE := NULL,
363: p_attribute9 IN CS_COUNTER_DER_FILTERS.ATTRIBUTE9%TYPE := NULL,
364: p_attribute10 IN CS_COUNTER_DER_FILTERS.ATTRIBUTE10%TYPE := NULL,
365: p_attribute11 IN CS_COUNTER_DER_FILTERS.ATTRIBUTE11%TYPE := NULL,
358: p_attribute4 IN CS_COUNTER_DER_FILTERS.ATTRIBUTE4%TYPE := NULL,
359: p_attribute5 IN CS_COUNTER_DER_FILTERS.ATTRIBUTE5%TYPE := NULL,
360: p_attribute6 IN CS_COUNTER_DER_FILTERS.ATTRIBUTE6%TYPE := NULL,
361: p_attribute7 IN CS_COUNTER_DER_FILTERS.ATTRIBUTE7%TYPE := NULL,
362: p_attribute8 IN CS_COUNTER_DER_FILTERS.ATTRIBUTE8%TYPE := NULL,
363: p_attribute9 IN CS_COUNTER_DER_FILTERS.ATTRIBUTE9%TYPE := NULL,
364: p_attribute10 IN CS_COUNTER_DER_FILTERS.ATTRIBUTE10%TYPE := NULL,
365: p_attribute11 IN CS_COUNTER_DER_FILTERS.ATTRIBUTE11%TYPE := NULL,
366: p_attribute12 IN CS_COUNTER_DER_FILTERS.ATTRIBUTE12%TYPE := NULL,
359: p_attribute5 IN CS_COUNTER_DER_FILTERS.ATTRIBUTE5%TYPE := NULL,
360: p_attribute6 IN CS_COUNTER_DER_FILTERS.ATTRIBUTE6%TYPE := NULL,
361: p_attribute7 IN CS_COUNTER_DER_FILTERS.ATTRIBUTE7%TYPE := NULL,
362: p_attribute8 IN CS_COUNTER_DER_FILTERS.ATTRIBUTE8%TYPE := NULL,
363: p_attribute9 IN CS_COUNTER_DER_FILTERS.ATTRIBUTE9%TYPE := NULL,
364: p_attribute10 IN CS_COUNTER_DER_FILTERS.ATTRIBUTE10%TYPE := NULL,
365: p_attribute11 IN CS_COUNTER_DER_FILTERS.ATTRIBUTE11%TYPE := NULL,
366: p_attribute12 IN CS_COUNTER_DER_FILTERS.ATTRIBUTE12%TYPE := NULL,
367: p_attribute13 IN CS_COUNTER_DER_FILTERS.ATTRIBUTE13%TYPE := NULL,
360: p_attribute6 IN CS_COUNTER_DER_FILTERS.ATTRIBUTE6%TYPE := NULL,
361: p_attribute7 IN CS_COUNTER_DER_FILTERS.ATTRIBUTE7%TYPE := NULL,
362: p_attribute8 IN CS_COUNTER_DER_FILTERS.ATTRIBUTE8%TYPE := NULL,
363: p_attribute9 IN CS_COUNTER_DER_FILTERS.ATTRIBUTE9%TYPE := NULL,
364: p_attribute10 IN CS_COUNTER_DER_FILTERS.ATTRIBUTE10%TYPE := NULL,
365: p_attribute11 IN CS_COUNTER_DER_FILTERS.ATTRIBUTE11%TYPE := NULL,
366: p_attribute12 IN CS_COUNTER_DER_FILTERS.ATTRIBUTE12%TYPE := NULL,
367: p_attribute13 IN CS_COUNTER_DER_FILTERS.ATTRIBUTE13%TYPE := NULL,
368: p_attribute14 IN CS_COUNTER_DER_FILTERS.ATTRIBUTE14%TYPE := NULL,
361: p_attribute7 IN CS_COUNTER_DER_FILTERS.ATTRIBUTE7%TYPE := NULL,
362: p_attribute8 IN CS_COUNTER_DER_FILTERS.ATTRIBUTE8%TYPE := NULL,
363: p_attribute9 IN CS_COUNTER_DER_FILTERS.ATTRIBUTE9%TYPE := NULL,
364: p_attribute10 IN CS_COUNTER_DER_FILTERS.ATTRIBUTE10%TYPE := NULL,
365: p_attribute11 IN CS_COUNTER_DER_FILTERS.ATTRIBUTE11%TYPE := NULL,
366: p_attribute12 IN CS_COUNTER_DER_FILTERS.ATTRIBUTE12%TYPE := NULL,
367: p_attribute13 IN CS_COUNTER_DER_FILTERS.ATTRIBUTE13%TYPE := NULL,
368: p_attribute14 IN CS_COUNTER_DER_FILTERS.ATTRIBUTE14%TYPE := NULL,
369: p_attribute15 IN CS_COUNTER_DER_FILTERS.ATTRIBUTE15%TYPE := NULL,
362: p_attribute8 IN CS_COUNTER_DER_FILTERS.ATTRIBUTE8%TYPE := NULL,
363: p_attribute9 IN CS_COUNTER_DER_FILTERS.ATTRIBUTE9%TYPE := NULL,
364: p_attribute10 IN CS_COUNTER_DER_FILTERS.ATTRIBUTE10%TYPE := NULL,
365: p_attribute11 IN CS_COUNTER_DER_FILTERS.ATTRIBUTE11%TYPE := NULL,
366: p_attribute12 IN CS_COUNTER_DER_FILTERS.ATTRIBUTE12%TYPE := NULL,
367: p_attribute13 IN CS_COUNTER_DER_FILTERS.ATTRIBUTE13%TYPE := NULL,
368: p_attribute14 IN CS_COUNTER_DER_FILTERS.ATTRIBUTE14%TYPE := NULL,
369: p_attribute15 IN CS_COUNTER_DER_FILTERS.ATTRIBUTE15%TYPE := NULL,
370: p_context IN CS_COUNTER_DER_FILTERS.CONTEXT%TYPE := NULL,
363: p_attribute9 IN CS_COUNTER_DER_FILTERS.ATTRIBUTE9%TYPE := NULL,
364: p_attribute10 IN CS_COUNTER_DER_FILTERS.ATTRIBUTE10%TYPE := NULL,
365: p_attribute11 IN CS_COUNTER_DER_FILTERS.ATTRIBUTE11%TYPE := NULL,
366: p_attribute12 IN CS_COUNTER_DER_FILTERS.ATTRIBUTE12%TYPE := NULL,
367: p_attribute13 IN CS_COUNTER_DER_FILTERS.ATTRIBUTE13%TYPE := NULL,
368: p_attribute14 IN CS_COUNTER_DER_FILTERS.ATTRIBUTE14%TYPE := NULL,
369: p_attribute15 IN CS_COUNTER_DER_FILTERS.ATTRIBUTE15%TYPE := NULL,
370: p_context IN CS_COUNTER_DER_FILTERS.CONTEXT%TYPE := NULL,
371: p_object_version_number IN NUMBER := NULL,
364: p_attribute10 IN CS_COUNTER_DER_FILTERS.ATTRIBUTE10%TYPE := NULL,
365: p_attribute11 IN CS_COUNTER_DER_FILTERS.ATTRIBUTE11%TYPE := NULL,
366: p_attribute12 IN CS_COUNTER_DER_FILTERS.ATTRIBUTE12%TYPE := NULL,
367: p_attribute13 IN CS_COUNTER_DER_FILTERS.ATTRIBUTE13%TYPE := NULL,
368: p_attribute14 IN CS_COUNTER_DER_FILTERS.ATTRIBUTE14%TYPE := NULL,
369: p_attribute15 IN CS_COUNTER_DER_FILTERS.ATTRIBUTE15%TYPE := NULL,
370: p_context IN CS_COUNTER_DER_FILTERS.CONTEXT%TYPE := NULL,
371: p_object_version_number IN NUMBER := NULL,
372: x_counter_der_filter_id OUT NOCOPY NUMBER,
365: p_attribute11 IN CS_COUNTER_DER_FILTERS.ATTRIBUTE11%TYPE := NULL,
366: p_attribute12 IN CS_COUNTER_DER_FILTERS.ATTRIBUTE12%TYPE := NULL,
367: p_attribute13 IN CS_COUNTER_DER_FILTERS.ATTRIBUTE13%TYPE := NULL,
368: p_attribute14 IN CS_COUNTER_DER_FILTERS.ATTRIBUTE14%TYPE := NULL,
369: p_attribute15 IN CS_COUNTER_DER_FILTERS.ATTRIBUTE15%TYPE := NULL,
370: p_context IN CS_COUNTER_DER_FILTERS.CONTEXT%TYPE := NULL,
371: p_object_version_number IN NUMBER := NULL,
372: x_counter_der_filter_id OUT NOCOPY NUMBER,
373: x_object_version_number OUT NOCOPY NUMBER) IS
366: p_attribute12 IN CS_COUNTER_DER_FILTERS.ATTRIBUTE12%TYPE := NULL,
367: p_attribute13 IN CS_COUNTER_DER_FILTERS.ATTRIBUTE13%TYPE := NULL,
368: p_attribute14 IN CS_COUNTER_DER_FILTERS.ATTRIBUTE14%TYPE := NULL,
369: p_attribute15 IN CS_COUNTER_DER_FILTERS.ATTRIBUTE15%TYPE := NULL,
370: p_context IN CS_COUNTER_DER_FILTERS.CONTEXT%TYPE := NULL,
371: p_object_version_number IN NUMBER := NULL,
372: x_counter_der_filter_id OUT NOCOPY NUMBER,
373: x_object_version_number OUT NOCOPY NUMBER) IS
374: l_api_name CONSTANT VARCHAR2(30) := 'insert_row';
482: E_Resource_Busy EXCEPTION;
483: PRAGMA EXCEPTION_INIT(E_Resource_Busy, -00054);
484: CURSOR lock_csr IS
485: SELECT OBJECT_VERSION_NUMBER
486: FROM CS_COUNTER_DER_FILTERS
487: WHERE
488: COUNTER_DER_FILTER_ID = p_counter_der_filter_id AND
489: OBJECT_VERSION_NUMBER = p_object_version_number
490: FOR UPDATE OF OBJECT_VERSION_NUMBER NOWAIT;
490: FOR UPDATE OF OBJECT_VERSION_NUMBER NOWAIT;
491:
492: CURSOR lchk_csr IS
493: SELECT OBJECT_VERSION_NUMBER
494: FROM CS_COUNTER_DER_FILTERS
495: WHERE
496: COUNTER_DER_FILTER_ID = p_counter_der_filter_id
497: ;
498: l_api_name CONSTANT VARCHAR2(30) := 'lock_row';
497: ;
498: l_api_name CONSTANT VARCHAR2(30) := 'lock_row';
499: l_api_version CONSTANT NUMBER := 1;
500: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
501: l_object_version_number CS_COUNTER_DER_FILTERS.OBJECT_VERSION_NUMBER%TYPE;
502: lc_object_version_number CS_COUNTER_DER_FILTERS.OBJECT_VERSION_NUMBER%TYPE;
503: l_row_notfound BOOLEAN := FALSE;
504: lc_row_notfound BOOLEAN := FALSE;
505: BEGIN
498: l_api_name CONSTANT VARCHAR2(30) := 'lock_row';
499: l_api_version CONSTANT NUMBER := 1;
500: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
501: l_object_version_number CS_COUNTER_DER_FILTERS.OBJECT_VERSION_NUMBER%TYPE;
502: lc_object_version_number CS_COUNTER_DER_FILTERS.OBJECT_VERSION_NUMBER%TYPE;
503: l_row_notfound BOOLEAN := FALSE;
504: lc_row_notfound BOOLEAN := FALSE;
505: BEGIN
506: l_return_status := TAPI_DEV_KIT.START_ACTIVITY(l_api_name,
605: x_counterfilter_rec OUT NOCOPY CounterFilter_Rec_Type
606: ) RETURN VARCHAR2 IS
607: CURSOR ccd_pk_csr (p_counter_der_filter_id IN NUMBER) IS
608: SELECT *
609: FROM Cs_Counter_Der_Filters
610: WHERE cs_counter_der_filters.counter_der_filter_id = p_counter_der_filter_id;
611: l_ccd_pk ccd_pk_csr%ROWTYPE;
612: l_row_notfound BOOLEAN := TRUE;
613: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
606: ) RETURN VARCHAR2 IS
607: CURSOR ccd_pk_csr (p_counter_der_filter_id IN NUMBER) IS
608: SELECT *
609: FROM Cs_Counter_Der_Filters
610: WHERE cs_counter_der_filters.counter_der_filter_id = p_counter_der_filter_id;
611: l_ccd_pk ccd_pk_csr%ROWTYPE;
612: l_row_notfound BOOLEAN := TRUE;
613: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
614: BEGIN
799: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
800: RAISE FND_API.G_EXC_ERROR;
801: END IF;
802: END IF;
803: UPDATE CS_COUNTER_DER_FILTERS
804: SET
805: COUNTER_DER_FILTER_ID = l_def_counterfilter_rec.counter_der_filter_id ,
806: COUNTER_ID = l_def_counterfilter_rec.counter_id ,
807: SEQ_NO = l_def_counterfilter_rec.seq_no ,
884: x_msg_data OUT NOCOPY VARCHAR2,
885: p_counter_der_filter_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
886: p_counter_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
887: p_seq_no IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
888: p_left_paren IN CS_COUNTER_DER_FILTERS.LEFT_PAREN%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
889: p_counter_property_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
890: p_relational_operator IN CS_COUNTER_DER_FILTERS.RELATIONAL_OPERATOR%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
891: p_right_paren IN CS_COUNTER_DER_FILTERS.RIGHT_PAREN%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
892: p_right_value IN CS_COUNTER_DER_FILTERS.RIGHT_VALUE%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
886: p_counter_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
887: p_seq_no IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
888: p_left_paren IN CS_COUNTER_DER_FILTERS.LEFT_PAREN%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
889: p_counter_property_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
890: p_relational_operator IN CS_COUNTER_DER_FILTERS.RELATIONAL_OPERATOR%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
891: p_right_paren IN CS_COUNTER_DER_FILTERS.RIGHT_PAREN%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
892: p_right_value IN CS_COUNTER_DER_FILTERS.RIGHT_VALUE%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
893: p_logical_operator IN CS_COUNTER_DER_FILTERS.LOGICAL_OPERATOR%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
894: p_last_update_date IN CS_COUNTER_DER_FILTERS.LAST_UPDATE_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
887: p_seq_no IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
888: p_left_paren IN CS_COUNTER_DER_FILTERS.LEFT_PAREN%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
889: p_counter_property_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
890: p_relational_operator IN CS_COUNTER_DER_FILTERS.RELATIONAL_OPERATOR%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
891: p_right_paren IN CS_COUNTER_DER_FILTERS.RIGHT_PAREN%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
892: p_right_value IN CS_COUNTER_DER_FILTERS.RIGHT_VALUE%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
893: p_logical_operator IN CS_COUNTER_DER_FILTERS.LOGICAL_OPERATOR%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
894: p_last_update_date IN CS_COUNTER_DER_FILTERS.LAST_UPDATE_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
895: p_last_updated_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
888: p_left_paren IN CS_COUNTER_DER_FILTERS.LEFT_PAREN%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
889: p_counter_property_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
890: p_relational_operator IN CS_COUNTER_DER_FILTERS.RELATIONAL_OPERATOR%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
891: p_right_paren IN CS_COUNTER_DER_FILTERS.RIGHT_PAREN%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
892: p_right_value IN CS_COUNTER_DER_FILTERS.RIGHT_VALUE%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
893: p_logical_operator IN CS_COUNTER_DER_FILTERS.LOGICAL_OPERATOR%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
894: p_last_update_date IN CS_COUNTER_DER_FILTERS.LAST_UPDATE_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
895: p_last_updated_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
896: p_creation_date IN CS_COUNTER_DER_FILTERS.CREATION_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
889: p_counter_property_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
890: p_relational_operator IN CS_COUNTER_DER_FILTERS.RELATIONAL_OPERATOR%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
891: p_right_paren IN CS_COUNTER_DER_FILTERS.RIGHT_PAREN%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
892: p_right_value IN CS_COUNTER_DER_FILTERS.RIGHT_VALUE%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
893: p_logical_operator IN CS_COUNTER_DER_FILTERS.LOGICAL_OPERATOR%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
894: p_last_update_date IN CS_COUNTER_DER_FILTERS.LAST_UPDATE_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
895: p_last_updated_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
896: p_creation_date IN CS_COUNTER_DER_FILTERS.CREATION_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
897: p_created_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
890: p_relational_operator IN CS_COUNTER_DER_FILTERS.RELATIONAL_OPERATOR%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
891: p_right_paren IN CS_COUNTER_DER_FILTERS.RIGHT_PAREN%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
892: p_right_value IN CS_COUNTER_DER_FILTERS.RIGHT_VALUE%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
893: p_logical_operator IN CS_COUNTER_DER_FILTERS.LOGICAL_OPERATOR%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
894: p_last_update_date IN CS_COUNTER_DER_FILTERS.LAST_UPDATE_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
895: p_last_updated_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
896: p_creation_date IN CS_COUNTER_DER_FILTERS.CREATION_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
897: p_created_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
898: p_last_update_login IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
892: p_right_value IN CS_COUNTER_DER_FILTERS.RIGHT_VALUE%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
893: p_logical_operator IN CS_COUNTER_DER_FILTERS.LOGICAL_OPERATOR%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
894: p_last_update_date IN CS_COUNTER_DER_FILTERS.LAST_UPDATE_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
895: p_last_updated_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
896: p_creation_date IN CS_COUNTER_DER_FILTERS.CREATION_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
897: p_created_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
898: p_last_update_login IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
899: p_attribute1 IN CS_COUNTER_DER_FILTERS.ATTRIBUTE1%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
900: p_attribute2 IN CS_COUNTER_DER_FILTERS.ATTRIBUTE2%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
895: p_last_updated_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
896: p_creation_date IN CS_COUNTER_DER_FILTERS.CREATION_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
897: p_created_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
898: p_last_update_login IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
899: p_attribute1 IN CS_COUNTER_DER_FILTERS.ATTRIBUTE1%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
900: p_attribute2 IN CS_COUNTER_DER_FILTERS.ATTRIBUTE2%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
901: p_attribute3 IN CS_COUNTER_DER_FILTERS.ATTRIBUTE3%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
902: p_attribute4 IN CS_COUNTER_DER_FILTERS.ATTRIBUTE4%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
903: p_attribute5 IN CS_COUNTER_DER_FILTERS.ATTRIBUTE5%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
896: p_creation_date IN CS_COUNTER_DER_FILTERS.CREATION_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
897: p_created_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
898: p_last_update_login IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
899: p_attribute1 IN CS_COUNTER_DER_FILTERS.ATTRIBUTE1%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
900: p_attribute2 IN CS_COUNTER_DER_FILTERS.ATTRIBUTE2%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
901: p_attribute3 IN CS_COUNTER_DER_FILTERS.ATTRIBUTE3%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
902: p_attribute4 IN CS_COUNTER_DER_FILTERS.ATTRIBUTE4%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
903: p_attribute5 IN CS_COUNTER_DER_FILTERS.ATTRIBUTE5%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
904: p_attribute6 IN CS_COUNTER_DER_FILTERS.ATTRIBUTE6%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
897: p_created_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
898: p_last_update_login IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
899: p_attribute1 IN CS_COUNTER_DER_FILTERS.ATTRIBUTE1%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
900: p_attribute2 IN CS_COUNTER_DER_FILTERS.ATTRIBUTE2%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
901: p_attribute3 IN CS_COUNTER_DER_FILTERS.ATTRIBUTE3%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
902: p_attribute4 IN CS_COUNTER_DER_FILTERS.ATTRIBUTE4%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
903: p_attribute5 IN CS_COUNTER_DER_FILTERS.ATTRIBUTE5%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
904: p_attribute6 IN CS_COUNTER_DER_FILTERS.ATTRIBUTE6%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
905: p_attribute7 IN CS_COUNTER_DER_FILTERS.ATTRIBUTE7%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
898: p_last_update_login IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
899: p_attribute1 IN CS_COUNTER_DER_FILTERS.ATTRIBUTE1%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
900: p_attribute2 IN CS_COUNTER_DER_FILTERS.ATTRIBUTE2%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
901: p_attribute3 IN CS_COUNTER_DER_FILTERS.ATTRIBUTE3%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
902: p_attribute4 IN CS_COUNTER_DER_FILTERS.ATTRIBUTE4%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
903: p_attribute5 IN CS_COUNTER_DER_FILTERS.ATTRIBUTE5%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
904: p_attribute6 IN CS_COUNTER_DER_FILTERS.ATTRIBUTE6%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
905: p_attribute7 IN CS_COUNTER_DER_FILTERS.ATTRIBUTE7%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
906: p_attribute8 IN CS_COUNTER_DER_FILTERS.ATTRIBUTE8%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
899: p_attribute1 IN CS_COUNTER_DER_FILTERS.ATTRIBUTE1%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
900: p_attribute2 IN CS_COUNTER_DER_FILTERS.ATTRIBUTE2%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
901: p_attribute3 IN CS_COUNTER_DER_FILTERS.ATTRIBUTE3%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
902: p_attribute4 IN CS_COUNTER_DER_FILTERS.ATTRIBUTE4%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
903: p_attribute5 IN CS_COUNTER_DER_FILTERS.ATTRIBUTE5%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
904: p_attribute6 IN CS_COUNTER_DER_FILTERS.ATTRIBUTE6%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
905: p_attribute7 IN CS_COUNTER_DER_FILTERS.ATTRIBUTE7%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
906: p_attribute8 IN CS_COUNTER_DER_FILTERS.ATTRIBUTE8%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
907: p_attribute9 IN CS_COUNTER_DER_FILTERS.ATTRIBUTE9%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
900: p_attribute2 IN CS_COUNTER_DER_FILTERS.ATTRIBUTE2%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
901: p_attribute3 IN CS_COUNTER_DER_FILTERS.ATTRIBUTE3%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
902: p_attribute4 IN CS_COUNTER_DER_FILTERS.ATTRIBUTE4%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
903: p_attribute5 IN CS_COUNTER_DER_FILTERS.ATTRIBUTE5%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
904: p_attribute6 IN CS_COUNTER_DER_FILTERS.ATTRIBUTE6%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
905: p_attribute7 IN CS_COUNTER_DER_FILTERS.ATTRIBUTE7%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
906: p_attribute8 IN CS_COUNTER_DER_FILTERS.ATTRIBUTE8%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
907: p_attribute9 IN CS_COUNTER_DER_FILTERS.ATTRIBUTE9%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
908: p_attribute10 IN CS_COUNTER_DER_FILTERS.ATTRIBUTE10%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
901: p_attribute3 IN CS_COUNTER_DER_FILTERS.ATTRIBUTE3%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
902: p_attribute4 IN CS_COUNTER_DER_FILTERS.ATTRIBUTE4%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
903: p_attribute5 IN CS_COUNTER_DER_FILTERS.ATTRIBUTE5%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
904: p_attribute6 IN CS_COUNTER_DER_FILTERS.ATTRIBUTE6%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
905: p_attribute7 IN CS_COUNTER_DER_FILTERS.ATTRIBUTE7%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
906: p_attribute8 IN CS_COUNTER_DER_FILTERS.ATTRIBUTE8%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
907: p_attribute9 IN CS_COUNTER_DER_FILTERS.ATTRIBUTE9%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
908: p_attribute10 IN CS_COUNTER_DER_FILTERS.ATTRIBUTE10%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
909: p_attribute11 IN CS_COUNTER_DER_FILTERS.ATTRIBUTE11%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
902: p_attribute4 IN CS_COUNTER_DER_FILTERS.ATTRIBUTE4%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
903: p_attribute5 IN CS_COUNTER_DER_FILTERS.ATTRIBUTE5%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
904: p_attribute6 IN CS_COUNTER_DER_FILTERS.ATTRIBUTE6%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
905: p_attribute7 IN CS_COUNTER_DER_FILTERS.ATTRIBUTE7%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
906: p_attribute8 IN CS_COUNTER_DER_FILTERS.ATTRIBUTE8%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
907: p_attribute9 IN CS_COUNTER_DER_FILTERS.ATTRIBUTE9%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
908: p_attribute10 IN CS_COUNTER_DER_FILTERS.ATTRIBUTE10%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
909: p_attribute11 IN CS_COUNTER_DER_FILTERS.ATTRIBUTE11%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
910: p_attribute12 IN CS_COUNTER_DER_FILTERS.ATTRIBUTE12%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
903: p_attribute5 IN CS_COUNTER_DER_FILTERS.ATTRIBUTE5%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
904: p_attribute6 IN CS_COUNTER_DER_FILTERS.ATTRIBUTE6%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
905: p_attribute7 IN CS_COUNTER_DER_FILTERS.ATTRIBUTE7%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
906: p_attribute8 IN CS_COUNTER_DER_FILTERS.ATTRIBUTE8%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
907: p_attribute9 IN CS_COUNTER_DER_FILTERS.ATTRIBUTE9%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
908: p_attribute10 IN CS_COUNTER_DER_FILTERS.ATTRIBUTE10%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
909: p_attribute11 IN CS_COUNTER_DER_FILTERS.ATTRIBUTE11%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
910: p_attribute12 IN CS_COUNTER_DER_FILTERS.ATTRIBUTE12%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
911: p_attribute13 IN CS_COUNTER_DER_FILTERS.ATTRIBUTE13%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
904: p_attribute6 IN CS_COUNTER_DER_FILTERS.ATTRIBUTE6%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
905: p_attribute7 IN CS_COUNTER_DER_FILTERS.ATTRIBUTE7%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
906: p_attribute8 IN CS_COUNTER_DER_FILTERS.ATTRIBUTE8%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
907: p_attribute9 IN CS_COUNTER_DER_FILTERS.ATTRIBUTE9%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
908: p_attribute10 IN CS_COUNTER_DER_FILTERS.ATTRIBUTE10%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
909: p_attribute11 IN CS_COUNTER_DER_FILTERS.ATTRIBUTE11%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
910: p_attribute12 IN CS_COUNTER_DER_FILTERS.ATTRIBUTE12%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
911: p_attribute13 IN CS_COUNTER_DER_FILTERS.ATTRIBUTE13%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
912: p_attribute14 IN CS_COUNTER_DER_FILTERS.ATTRIBUTE14%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
905: p_attribute7 IN CS_COUNTER_DER_FILTERS.ATTRIBUTE7%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
906: p_attribute8 IN CS_COUNTER_DER_FILTERS.ATTRIBUTE8%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
907: p_attribute9 IN CS_COUNTER_DER_FILTERS.ATTRIBUTE9%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
908: p_attribute10 IN CS_COUNTER_DER_FILTERS.ATTRIBUTE10%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
909: p_attribute11 IN CS_COUNTER_DER_FILTERS.ATTRIBUTE11%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
910: p_attribute12 IN CS_COUNTER_DER_FILTERS.ATTRIBUTE12%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
911: p_attribute13 IN CS_COUNTER_DER_FILTERS.ATTRIBUTE13%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
912: p_attribute14 IN CS_COUNTER_DER_FILTERS.ATTRIBUTE14%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
913: p_attribute15 IN CS_COUNTER_DER_FILTERS.ATTRIBUTE15%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
906: p_attribute8 IN CS_COUNTER_DER_FILTERS.ATTRIBUTE8%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
907: p_attribute9 IN CS_COUNTER_DER_FILTERS.ATTRIBUTE9%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
908: p_attribute10 IN CS_COUNTER_DER_FILTERS.ATTRIBUTE10%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
909: p_attribute11 IN CS_COUNTER_DER_FILTERS.ATTRIBUTE11%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
910: p_attribute12 IN CS_COUNTER_DER_FILTERS.ATTRIBUTE12%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
911: p_attribute13 IN CS_COUNTER_DER_FILTERS.ATTRIBUTE13%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
912: p_attribute14 IN CS_COUNTER_DER_FILTERS.ATTRIBUTE14%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
913: p_attribute15 IN CS_COUNTER_DER_FILTERS.ATTRIBUTE15%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
914: p_context IN CS_COUNTER_DER_FILTERS.CONTEXT%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
907: p_attribute9 IN CS_COUNTER_DER_FILTERS.ATTRIBUTE9%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
908: p_attribute10 IN CS_COUNTER_DER_FILTERS.ATTRIBUTE10%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
909: p_attribute11 IN CS_COUNTER_DER_FILTERS.ATTRIBUTE11%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
910: p_attribute12 IN CS_COUNTER_DER_FILTERS.ATTRIBUTE12%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
911: p_attribute13 IN CS_COUNTER_DER_FILTERS.ATTRIBUTE13%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
912: p_attribute14 IN CS_COUNTER_DER_FILTERS.ATTRIBUTE14%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
913: p_attribute15 IN CS_COUNTER_DER_FILTERS.ATTRIBUTE15%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
914: p_context IN CS_COUNTER_DER_FILTERS.CONTEXT%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
915: p_object_version_number IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
908: p_attribute10 IN CS_COUNTER_DER_FILTERS.ATTRIBUTE10%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
909: p_attribute11 IN CS_COUNTER_DER_FILTERS.ATTRIBUTE11%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
910: p_attribute12 IN CS_COUNTER_DER_FILTERS.ATTRIBUTE12%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
911: p_attribute13 IN CS_COUNTER_DER_FILTERS.ATTRIBUTE13%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
912: p_attribute14 IN CS_COUNTER_DER_FILTERS.ATTRIBUTE14%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
913: p_attribute15 IN CS_COUNTER_DER_FILTERS.ATTRIBUTE15%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
914: p_context IN CS_COUNTER_DER_FILTERS.CONTEXT%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
915: p_object_version_number IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
916: x_object_version_number OUT NOCOPY NUMBER) IS
909: p_attribute11 IN CS_COUNTER_DER_FILTERS.ATTRIBUTE11%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
910: p_attribute12 IN CS_COUNTER_DER_FILTERS.ATTRIBUTE12%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
911: p_attribute13 IN CS_COUNTER_DER_FILTERS.ATTRIBUTE13%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
912: p_attribute14 IN CS_COUNTER_DER_FILTERS.ATTRIBUTE14%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
913: p_attribute15 IN CS_COUNTER_DER_FILTERS.ATTRIBUTE15%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
914: p_context IN CS_COUNTER_DER_FILTERS.CONTEXT%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
915: p_object_version_number IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
916: x_object_version_number OUT NOCOPY NUMBER) IS
917: l_api_name CONSTANT VARCHAR2(30) := 'update_row';
910: p_attribute12 IN CS_COUNTER_DER_FILTERS.ATTRIBUTE12%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
911: p_attribute13 IN CS_COUNTER_DER_FILTERS.ATTRIBUTE13%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
912: p_attribute14 IN CS_COUNTER_DER_FILTERS.ATTRIBUTE14%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
913: p_attribute15 IN CS_COUNTER_DER_FILTERS.ATTRIBUTE15%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
914: p_context IN CS_COUNTER_DER_FILTERS.CONTEXT%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
915: p_object_version_number IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
916: x_object_version_number OUT NOCOPY NUMBER) IS
917: l_api_name CONSTANT VARCHAR2(30) := 'update_row';
918: l_api_version CONSTANT NUMBER := 1;
1035: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1036: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
1037: RAISE FND_API.G_EXC_ERROR;
1038: END IF;
1039: DELETE FROM CS_COUNTER_DER_FILTERS
1040: WHERE
1041: COUNTER_DER_FILTER_ID = p_counter_der_filter_id
1042: ;
1043: TAPI_DEV_KIT.END_ACTIVITY(p_commit, x_msg_count, x_msg_data);
1173: x_msg_data OUT NOCOPY VARCHAR2,
1174: p_counter_der_filter_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1175: p_counter_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1176: p_seq_no IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1177: p_left_paren IN CS_COUNTER_DER_FILTERS.LEFT_PAREN%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1178: p_counter_property_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1179: p_relational_operator IN CS_COUNTER_DER_FILTERS.RELATIONAL_OPERATOR%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1180: p_right_paren IN CS_COUNTER_DER_FILTERS.RIGHT_PAREN%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1181: p_right_value IN CS_COUNTER_DER_FILTERS.RIGHT_VALUE%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1175: p_counter_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1176: p_seq_no IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1177: p_left_paren IN CS_COUNTER_DER_FILTERS.LEFT_PAREN%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1178: p_counter_property_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1179: p_relational_operator IN CS_COUNTER_DER_FILTERS.RELATIONAL_OPERATOR%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1180: p_right_paren IN CS_COUNTER_DER_FILTERS.RIGHT_PAREN%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1181: p_right_value IN CS_COUNTER_DER_FILTERS.RIGHT_VALUE%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1182: p_logical_operator IN CS_COUNTER_DER_FILTERS.LOGICAL_OPERATOR%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1183: p_last_update_date IN CS_COUNTER_DER_FILTERS.LAST_UPDATE_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1176: p_seq_no IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1177: p_left_paren IN CS_COUNTER_DER_FILTERS.LEFT_PAREN%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1178: p_counter_property_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1179: p_relational_operator IN CS_COUNTER_DER_FILTERS.RELATIONAL_OPERATOR%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1180: p_right_paren IN CS_COUNTER_DER_FILTERS.RIGHT_PAREN%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1181: p_right_value IN CS_COUNTER_DER_FILTERS.RIGHT_VALUE%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1182: p_logical_operator IN CS_COUNTER_DER_FILTERS.LOGICAL_OPERATOR%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1183: p_last_update_date IN CS_COUNTER_DER_FILTERS.LAST_UPDATE_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1184: p_last_updated_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1177: p_left_paren IN CS_COUNTER_DER_FILTERS.LEFT_PAREN%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1178: p_counter_property_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1179: p_relational_operator IN CS_COUNTER_DER_FILTERS.RELATIONAL_OPERATOR%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1180: p_right_paren IN CS_COUNTER_DER_FILTERS.RIGHT_PAREN%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1181: p_right_value IN CS_COUNTER_DER_FILTERS.RIGHT_VALUE%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1182: p_logical_operator IN CS_COUNTER_DER_FILTERS.LOGICAL_OPERATOR%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1183: p_last_update_date IN CS_COUNTER_DER_FILTERS.LAST_UPDATE_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1184: p_last_updated_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1185: p_creation_date IN CS_COUNTER_DER_FILTERS.CREATION_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1178: p_counter_property_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1179: p_relational_operator IN CS_COUNTER_DER_FILTERS.RELATIONAL_OPERATOR%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1180: p_right_paren IN CS_COUNTER_DER_FILTERS.RIGHT_PAREN%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1181: p_right_value IN CS_COUNTER_DER_FILTERS.RIGHT_VALUE%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1182: p_logical_operator IN CS_COUNTER_DER_FILTERS.LOGICAL_OPERATOR%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1183: p_last_update_date IN CS_COUNTER_DER_FILTERS.LAST_UPDATE_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1184: p_last_updated_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1185: p_creation_date IN CS_COUNTER_DER_FILTERS.CREATION_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1186: p_created_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1179: p_relational_operator IN CS_COUNTER_DER_FILTERS.RELATIONAL_OPERATOR%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1180: p_right_paren IN CS_COUNTER_DER_FILTERS.RIGHT_PAREN%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1181: p_right_value IN CS_COUNTER_DER_FILTERS.RIGHT_VALUE%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1182: p_logical_operator IN CS_COUNTER_DER_FILTERS.LOGICAL_OPERATOR%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1183: p_last_update_date IN CS_COUNTER_DER_FILTERS.LAST_UPDATE_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1184: p_last_updated_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1185: p_creation_date IN CS_COUNTER_DER_FILTERS.CREATION_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1186: p_created_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1187: p_last_update_login IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1181: p_right_value IN CS_COUNTER_DER_FILTERS.RIGHT_VALUE%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1182: p_logical_operator IN CS_COUNTER_DER_FILTERS.LOGICAL_OPERATOR%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1183: p_last_update_date IN CS_COUNTER_DER_FILTERS.LAST_UPDATE_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1184: p_last_updated_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1185: p_creation_date IN CS_COUNTER_DER_FILTERS.CREATION_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1186: p_created_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1187: p_last_update_login IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1188: p_attribute1 IN CS_COUNTER_DER_FILTERS.ATTRIBUTE1%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1189: p_attribute2 IN CS_COUNTER_DER_FILTERS.ATTRIBUTE2%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1184: p_last_updated_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1185: p_creation_date IN CS_COUNTER_DER_FILTERS.CREATION_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1186: p_created_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1187: p_last_update_login IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1188: p_attribute1 IN CS_COUNTER_DER_FILTERS.ATTRIBUTE1%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1189: p_attribute2 IN CS_COUNTER_DER_FILTERS.ATTRIBUTE2%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1190: p_attribute3 IN CS_COUNTER_DER_FILTERS.ATTRIBUTE3%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1191: p_attribute4 IN CS_COUNTER_DER_FILTERS.ATTRIBUTE4%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1192: p_attribute5 IN CS_COUNTER_DER_FILTERS.ATTRIBUTE5%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1185: p_creation_date IN CS_COUNTER_DER_FILTERS.CREATION_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1186: p_created_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1187: p_last_update_login IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1188: p_attribute1 IN CS_COUNTER_DER_FILTERS.ATTRIBUTE1%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1189: p_attribute2 IN CS_COUNTER_DER_FILTERS.ATTRIBUTE2%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1190: p_attribute3 IN CS_COUNTER_DER_FILTERS.ATTRIBUTE3%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1191: p_attribute4 IN CS_COUNTER_DER_FILTERS.ATTRIBUTE4%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1192: p_attribute5 IN CS_COUNTER_DER_FILTERS.ATTRIBUTE5%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1193: p_attribute6 IN CS_COUNTER_DER_FILTERS.ATTRIBUTE6%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1186: p_created_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1187: p_last_update_login IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1188: p_attribute1 IN CS_COUNTER_DER_FILTERS.ATTRIBUTE1%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1189: p_attribute2 IN CS_COUNTER_DER_FILTERS.ATTRIBUTE2%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1190: p_attribute3 IN CS_COUNTER_DER_FILTERS.ATTRIBUTE3%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1191: p_attribute4 IN CS_COUNTER_DER_FILTERS.ATTRIBUTE4%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1192: p_attribute5 IN CS_COUNTER_DER_FILTERS.ATTRIBUTE5%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1193: p_attribute6 IN CS_COUNTER_DER_FILTERS.ATTRIBUTE6%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1194: p_attribute7 IN CS_COUNTER_DER_FILTERS.ATTRIBUTE7%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1187: p_last_update_login IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1188: p_attribute1 IN CS_COUNTER_DER_FILTERS.ATTRIBUTE1%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1189: p_attribute2 IN CS_COUNTER_DER_FILTERS.ATTRIBUTE2%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1190: p_attribute3 IN CS_COUNTER_DER_FILTERS.ATTRIBUTE3%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1191: p_attribute4 IN CS_COUNTER_DER_FILTERS.ATTRIBUTE4%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1192: p_attribute5 IN CS_COUNTER_DER_FILTERS.ATTRIBUTE5%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1193: p_attribute6 IN CS_COUNTER_DER_FILTERS.ATTRIBUTE6%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1194: p_attribute7 IN CS_COUNTER_DER_FILTERS.ATTRIBUTE7%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1195: p_attribute8 IN CS_COUNTER_DER_FILTERS.ATTRIBUTE8%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1188: p_attribute1 IN CS_COUNTER_DER_FILTERS.ATTRIBUTE1%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1189: p_attribute2 IN CS_COUNTER_DER_FILTERS.ATTRIBUTE2%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1190: p_attribute3 IN CS_COUNTER_DER_FILTERS.ATTRIBUTE3%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1191: p_attribute4 IN CS_COUNTER_DER_FILTERS.ATTRIBUTE4%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1192: p_attribute5 IN CS_COUNTER_DER_FILTERS.ATTRIBUTE5%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1193: p_attribute6 IN CS_COUNTER_DER_FILTERS.ATTRIBUTE6%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1194: p_attribute7 IN CS_COUNTER_DER_FILTERS.ATTRIBUTE7%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1195: p_attribute8 IN CS_COUNTER_DER_FILTERS.ATTRIBUTE8%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1196: p_attribute9 IN CS_COUNTER_DER_FILTERS.ATTRIBUTE9%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1189: p_attribute2 IN CS_COUNTER_DER_FILTERS.ATTRIBUTE2%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1190: p_attribute3 IN CS_COUNTER_DER_FILTERS.ATTRIBUTE3%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1191: p_attribute4 IN CS_COUNTER_DER_FILTERS.ATTRIBUTE4%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1192: p_attribute5 IN CS_COUNTER_DER_FILTERS.ATTRIBUTE5%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1193: p_attribute6 IN CS_COUNTER_DER_FILTERS.ATTRIBUTE6%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1194: p_attribute7 IN CS_COUNTER_DER_FILTERS.ATTRIBUTE7%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1195: p_attribute8 IN CS_COUNTER_DER_FILTERS.ATTRIBUTE8%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1196: p_attribute9 IN CS_COUNTER_DER_FILTERS.ATTRIBUTE9%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1197: p_attribute10 IN CS_COUNTER_DER_FILTERS.ATTRIBUTE10%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1190: p_attribute3 IN CS_COUNTER_DER_FILTERS.ATTRIBUTE3%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1191: p_attribute4 IN CS_COUNTER_DER_FILTERS.ATTRIBUTE4%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1192: p_attribute5 IN CS_COUNTER_DER_FILTERS.ATTRIBUTE5%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1193: p_attribute6 IN CS_COUNTER_DER_FILTERS.ATTRIBUTE6%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1194: p_attribute7 IN CS_COUNTER_DER_FILTERS.ATTRIBUTE7%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1195: p_attribute8 IN CS_COUNTER_DER_FILTERS.ATTRIBUTE8%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1196: p_attribute9 IN CS_COUNTER_DER_FILTERS.ATTRIBUTE9%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1197: p_attribute10 IN CS_COUNTER_DER_FILTERS.ATTRIBUTE10%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1198: p_attribute11 IN CS_COUNTER_DER_FILTERS.ATTRIBUTE11%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1191: p_attribute4 IN CS_COUNTER_DER_FILTERS.ATTRIBUTE4%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1192: p_attribute5 IN CS_COUNTER_DER_FILTERS.ATTRIBUTE5%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1193: p_attribute6 IN CS_COUNTER_DER_FILTERS.ATTRIBUTE6%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1194: p_attribute7 IN CS_COUNTER_DER_FILTERS.ATTRIBUTE7%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1195: p_attribute8 IN CS_COUNTER_DER_FILTERS.ATTRIBUTE8%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1196: p_attribute9 IN CS_COUNTER_DER_FILTERS.ATTRIBUTE9%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1197: p_attribute10 IN CS_COUNTER_DER_FILTERS.ATTRIBUTE10%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1198: p_attribute11 IN CS_COUNTER_DER_FILTERS.ATTRIBUTE11%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1199: p_attribute12 IN CS_COUNTER_DER_FILTERS.ATTRIBUTE12%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1192: p_attribute5 IN CS_COUNTER_DER_FILTERS.ATTRIBUTE5%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1193: p_attribute6 IN CS_COUNTER_DER_FILTERS.ATTRIBUTE6%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1194: p_attribute7 IN CS_COUNTER_DER_FILTERS.ATTRIBUTE7%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1195: p_attribute8 IN CS_COUNTER_DER_FILTERS.ATTRIBUTE8%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1196: p_attribute9 IN CS_COUNTER_DER_FILTERS.ATTRIBUTE9%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1197: p_attribute10 IN CS_COUNTER_DER_FILTERS.ATTRIBUTE10%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1198: p_attribute11 IN CS_COUNTER_DER_FILTERS.ATTRIBUTE11%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1199: p_attribute12 IN CS_COUNTER_DER_FILTERS.ATTRIBUTE12%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1200: p_attribute13 IN CS_COUNTER_DER_FILTERS.ATTRIBUTE13%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1193: p_attribute6 IN CS_COUNTER_DER_FILTERS.ATTRIBUTE6%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1194: p_attribute7 IN CS_COUNTER_DER_FILTERS.ATTRIBUTE7%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1195: p_attribute8 IN CS_COUNTER_DER_FILTERS.ATTRIBUTE8%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1196: p_attribute9 IN CS_COUNTER_DER_FILTERS.ATTRIBUTE9%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1197: p_attribute10 IN CS_COUNTER_DER_FILTERS.ATTRIBUTE10%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1198: p_attribute11 IN CS_COUNTER_DER_FILTERS.ATTRIBUTE11%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1199: p_attribute12 IN CS_COUNTER_DER_FILTERS.ATTRIBUTE12%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1200: p_attribute13 IN CS_COUNTER_DER_FILTERS.ATTRIBUTE13%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1201: p_attribute14 IN CS_COUNTER_DER_FILTERS.ATTRIBUTE14%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1194: p_attribute7 IN CS_COUNTER_DER_FILTERS.ATTRIBUTE7%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1195: p_attribute8 IN CS_COUNTER_DER_FILTERS.ATTRIBUTE8%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1196: p_attribute9 IN CS_COUNTER_DER_FILTERS.ATTRIBUTE9%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1197: p_attribute10 IN CS_COUNTER_DER_FILTERS.ATTRIBUTE10%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1198: p_attribute11 IN CS_COUNTER_DER_FILTERS.ATTRIBUTE11%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1199: p_attribute12 IN CS_COUNTER_DER_FILTERS.ATTRIBUTE12%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1200: p_attribute13 IN CS_COUNTER_DER_FILTERS.ATTRIBUTE13%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1201: p_attribute14 IN CS_COUNTER_DER_FILTERS.ATTRIBUTE14%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1202: p_attribute15 IN CS_COUNTER_DER_FILTERS.ATTRIBUTE15%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1195: p_attribute8 IN CS_COUNTER_DER_FILTERS.ATTRIBUTE8%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1196: p_attribute9 IN CS_COUNTER_DER_FILTERS.ATTRIBUTE9%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1197: p_attribute10 IN CS_COUNTER_DER_FILTERS.ATTRIBUTE10%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1198: p_attribute11 IN CS_COUNTER_DER_FILTERS.ATTRIBUTE11%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1199: p_attribute12 IN CS_COUNTER_DER_FILTERS.ATTRIBUTE12%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1200: p_attribute13 IN CS_COUNTER_DER_FILTERS.ATTRIBUTE13%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1201: p_attribute14 IN CS_COUNTER_DER_FILTERS.ATTRIBUTE14%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1202: p_attribute15 IN CS_COUNTER_DER_FILTERS.ATTRIBUTE15%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1203: p_context IN CS_COUNTER_DER_FILTERS.CONTEXT%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1196: p_attribute9 IN CS_COUNTER_DER_FILTERS.ATTRIBUTE9%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1197: p_attribute10 IN CS_COUNTER_DER_FILTERS.ATTRIBUTE10%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1198: p_attribute11 IN CS_COUNTER_DER_FILTERS.ATTRIBUTE11%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1199: p_attribute12 IN CS_COUNTER_DER_FILTERS.ATTRIBUTE12%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1200: p_attribute13 IN CS_COUNTER_DER_FILTERS.ATTRIBUTE13%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1201: p_attribute14 IN CS_COUNTER_DER_FILTERS.ATTRIBUTE14%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1202: p_attribute15 IN CS_COUNTER_DER_FILTERS.ATTRIBUTE15%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1203: p_context IN CS_COUNTER_DER_FILTERS.CONTEXT%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1204: p_object_version_number IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM) IS
1197: p_attribute10 IN CS_COUNTER_DER_FILTERS.ATTRIBUTE10%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1198: p_attribute11 IN CS_COUNTER_DER_FILTERS.ATTRIBUTE11%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1199: p_attribute12 IN CS_COUNTER_DER_FILTERS.ATTRIBUTE12%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1200: p_attribute13 IN CS_COUNTER_DER_FILTERS.ATTRIBUTE13%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1201: p_attribute14 IN CS_COUNTER_DER_FILTERS.ATTRIBUTE14%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1202: p_attribute15 IN CS_COUNTER_DER_FILTERS.ATTRIBUTE15%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1203: p_context IN CS_COUNTER_DER_FILTERS.CONTEXT%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1204: p_object_version_number IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM) IS
1205: l_api_name CONSTANT VARCHAR2(30) := 'validate_row';
1198: p_attribute11 IN CS_COUNTER_DER_FILTERS.ATTRIBUTE11%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1199: p_attribute12 IN CS_COUNTER_DER_FILTERS.ATTRIBUTE12%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1200: p_attribute13 IN CS_COUNTER_DER_FILTERS.ATTRIBUTE13%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1201: p_attribute14 IN CS_COUNTER_DER_FILTERS.ATTRIBUTE14%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1202: p_attribute15 IN CS_COUNTER_DER_FILTERS.ATTRIBUTE15%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1203: p_context IN CS_COUNTER_DER_FILTERS.CONTEXT%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1204: p_object_version_number IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM) IS
1205: l_api_name CONSTANT VARCHAR2(30) := 'validate_row';
1206: l_api_version CONSTANT NUMBER := 1;
1199: p_attribute12 IN CS_COUNTER_DER_FILTERS.ATTRIBUTE12%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1200: p_attribute13 IN CS_COUNTER_DER_FILTERS.ATTRIBUTE13%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1201: p_attribute14 IN CS_COUNTER_DER_FILTERS.ATTRIBUTE14%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1202: p_attribute15 IN CS_COUNTER_DER_FILTERS.ATTRIBUTE15%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1203: p_context IN CS_COUNTER_DER_FILTERS.CONTEXT%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1204: p_object_version_number IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM) IS
1205: l_api_name CONSTANT VARCHAR2(30) := 'validate_row';
1206: l_api_version CONSTANT NUMBER := 1;
1207: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;