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_CONTRACTSTATS_PVT dependencies on TAPI_DEV_KIT

Line 24: IF p_contractstats_rec.name = TAPI_DEV_KIT.G_MISS_CHAR OR

20: RETURN VARCHAR2
21: IS
22: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
23: BEGIN
24: IF p_contractstats_rec.name = TAPI_DEV_KIT.G_MISS_CHAR OR
25: p_contractstats_rec.name IS NULL
26: THEN
27: TAPI_DEV_KIT.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'name');
28: l_return_status := FND_API.G_RET_STS_ERROR;

Line 27: TAPI_DEV_KIT.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'name');

23: BEGIN
24: IF p_contractstats_rec.name = TAPI_DEV_KIT.G_MISS_CHAR OR
25: p_contractstats_rec.name IS NULL
26: THEN
27: TAPI_DEV_KIT.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'name');
28: l_return_status := FND_API.G_RET_STS_ERROR;
29: ELSIF p_contractstats_rec.status_level = TAPI_DEV_KIT.G_MISS_NUM OR
30: p_contractstats_rec.status_level IS NULL
31: THEN

Line 29: ELSIF p_contractstats_rec.status_level = TAPI_DEV_KIT.G_MISS_NUM OR

25: p_contractstats_rec.name IS NULL
26: THEN
27: TAPI_DEV_KIT.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'name');
28: l_return_status := FND_API.G_RET_STS_ERROR;
29: ELSIF p_contractstats_rec.status_level = TAPI_DEV_KIT.G_MISS_NUM OR
30: p_contractstats_rec.status_level IS NULL
31: THEN
32: TAPI_DEV_KIT.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'status_level');
33: l_return_status := FND_API.G_RET_STS_ERROR;

Line 32: TAPI_DEV_KIT.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'status_level');

28: l_return_status := FND_API.G_RET_STS_ERROR;
29: ELSIF p_contractstats_rec.status_level = TAPI_DEV_KIT.G_MISS_NUM OR
30: p_contractstats_rec.status_level IS NULL
31: THEN
32: TAPI_DEV_KIT.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'status_level');
33: l_return_status := FND_API.G_RET_STS_ERROR;
34: ELSIF p_contractstats_rec.last_update_date = TAPI_DEV_KIT.G_MISS_DATE OR
35: p_contractstats_rec.last_update_date IS NULL
36: THEN

Line 34: ELSIF p_contractstats_rec.last_update_date = TAPI_DEV_KIT.G_MISS_DATE OR

30: p_contractstats_rec.status_level IS NULL
31: THEN
32: TAPI_DEV_KIT.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'status_level');
33: l_return_status := FND_API.G_RET_STS_ERROR;
34: ELSIF p_contractstats_rec.last_update_date = TAPI_DEV_KIT.G_MISS_DATE OR
35: p_contractstats_rec.last_update_date IS NULL
36: THEN
37: TAPI_DEV_KIT.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'last_update_date');
38: l_return_status := FND_API.G_RET_STS_ERROR;

Line 37: TAPI_DEV_KIT.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'last_update_date');

33: l_return_status := FND_API.G_RET_STS_ERROR;
34: ELSIF p_contractstats_rec.last_update_date = TAPI_DEV_KIT.G_MISS_DATE OR
35: p_contractstats_rec.last_update_date IS NULL
36: THEN
37: TAPI_DEV_KIT.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'last_update_date');
38: l_return_status := FND_API.G_RET_STS_ERROR;
39: ELSIF p_contractstats_rec.last_updated_by = TAPI_DEV_KIT.G_MISS_NUM OR
40: p_contractstats_rec.last_updated_by IS NULL
41: THEN

Line 39: ELSIF p_contractstats_rec.last_updated_by = TAPI_DEV_KIT.G_MISS_NUM OR

35: p_contractstats_rec.last_update_date IS NULL
36: THEN
37: TAPI_DEV_KIT.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'last_update_date');
38: l_return_status := FND_API.G_RET_STS_ERROR;
39: ELSIF p_contractstats_rec.last_updated_by = TAPI_DEV_KIT.G_MISS_NUM OR
40: p_contractstats_rec.last_updated_by IS NULL
41: THEN
42: TAPI_DEV_KIT.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'last_updated_by');
43: l_return_status := FND_API.G_RET_STS_ERROR;

Line 42: TAPI_DEV_KIT.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'last_updated_by');

38: l_return_status := FND_API.G_RET_STS_ERROR;
39: ELSIF p_contractstats_rec.last_updated_by = TAPI_DEV_KIT.G_MISS_NUM OR
40: p_contractstats_rec.last_updated_by IS NULL
41: THEN
42: TAPI_DEV_KIT.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'last_updated_by');
43: l_return_status := FND_API.G_RET_STS_ERROR;
44: ELSIF p_contractstats_rec.creation_date = TAPI_DEV_KIT.G_MISS_DATE OR
45: p_contractstats_rec.creation_date IS NULL
46: THEN

Line 44: ELSIF p_contractstats_rec.creation_date = TAPI_DEV_KIT.G_MISS_DATE OR

40: p_contractstats_rec.last_updated_by IS NULL
41: THEN
42: TAPI_DEV_KIT.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'last_updated_by');
43: l_return_status := FND_API.G_RET_STS_ERROR;
44: ELSIF p_contractstats_rec.creation_date = TAPI_DEV_KIT.G_MISS_DATE OR
45: p_contractstats_rec.creation_date IS NULL
46: THEN
47: TAPI_DEV_KIT.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'creation_date');
48: l_return_status := FND_API.G_RET_STS_ERROR;

Line 47: TAPI_DEV_KIT.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'creation_date');

43: l_return_status := FND_API.G_RET_STS_ERROR;
44: ELSIF p_contractstats_rec.creation_date = TAPI_DEV_KIT.G_MISS_DATE OR
45: p_contractstats_rec.creation_date IS NULL
46: THEN
47: TAPI_DEV_KIT.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'creation_date');
48: l_return_status := FND_API.G_RET_STS_ERROR;
49: ELSIF p_contractstats_rec.created_by = TAPI_DEV_KIT.G_MISS_NUM OR
50: p_contractstats_rec.created_by IS NULL
51: THEN

Line 49: ELSIF p_contractstats_rec.created_by = TAPI_DEV_KIT.G_MISS_NUM OR

45: p_contractstats_rec.creation_date IS NULL
46: THEN
47: TAPI_DEV_KIT.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'creation_date');
48: l_return_status := FND_API.G_RET_STS_ERROR;
49: ELSIF p_contractstats_rec.created_by = TAPI_DEV_KIT.G_MISS_NUM OR
50: p_contractstats_rec.created_by IS NULL
51: THEN
52: TAPI_DEV_KIT.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'created_by');
53: l_return_status := FND_API.G_RET_STS_ERROR;

Line 52: TAPI_DEV_KIT.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'created_by');

48: l_return_status := FND_API.G_RET_STS_ERROR;
49: ELSIF p_contractstats_rec.created_by = TAPI_DEV_KIT.G_MISS_NUM OR
50: p_contractstats_rec.created_by IS NULL
51: THEN
52: TAPI_DEV_KIT.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'created_by');
53: l_return_status := FND_API.G_RET_STS_ERROR;
54: END IF;
55: RETURN(l_return_status);
56: END Validate_Item_Attributes;

Line 168: p_init_msg_list IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,

164: END migrate;
165: PROCEDURE insert_row
166: (
167: p_api_version IN NUMBER,
168: p_init_msg_list IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
169: p_validation_level IN NUMBER,
170: p_commit IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
171: x_return_status OUT VARCHAR2,
172: x_msg_count OUT NUMBER,

Line 170: p_commit IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,

166: (
167: p_api_version IN NUMBER,
168: p_init_msg_list IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
169: p_validation_level IN NUMBER,
170: p_commit IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
171: x_return_status OUT VARCHAR2,
172: x_msg_count OUT NUMBER,
173: x_msg_data OUT VARCHAR2,
174: p_contractstats_rec IN ContractStats_Rec_Type := G_MISS_CONTRACTSTATS_REC,

Line 183: l_return_status := TAPI_DEV_KIT.START_ACTIVITY(l_api_name,

179: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
180: l_contractstats_rec ContractStats_Rec_Type;
181: l_def_contractstats_rec ContractStats_Rec_Type;
182: BEGIN
183: l_return_status := TAPI_DEV_KIT.START_ACTIVITY(l_api_name,
184: G_PKG_NAME,
185: l_api_version,
186: p_api_version,
187: p_init_msg_list,

Line 304: TAPI_DEV_KIT.END_ACTIVITY(p_commit, x_msg_count, x_msg_data);

300: l_def_contractstats_rec.object_version_number);
301: -- Set OUT values
302: x_contract_status_id := l_def_contractstats_rec.contract_status_id;
303: x_object_version_number := l_def_contractstats_rec.OBJECT_VERSION_NUMBER;
304: TAPI_DEV_KIT.END_ACTIVITY(p_commit, x_msg_count, x_msg_data);
305: EXCEPTION
306: WHEN FND_API.G_EXC_ERROR THEN
307: x_return_status := TAPI_DEV_KIT.HANDLE_EXCEPTIONS
308: (

Line 307: x_return_status := TAPI_DEV_KIT.HANDLE_EXCEPTIONS

303: x_object_version_number := l_def_contractstats_rec.OBJECT_VERSION_NUMBER;
304: TAPI_DEV_KIT.END_ACTIVITY(p_commit, x_msg_count, x_msg_data);
305: EXCEPTION
306: WHEN FND_API.G_EXC_ERROR THEN
307: x_return_status := TAPI_DEV_KIT.HANDLE_EXCEPTIONS
308: (
309: l_api_name,
310: G_PKG_NAME,
311: 'FND_API.G_RET_STS_ERROR',

Line 318: x_return_status :=TAPI_DEV_KIT.HANDLE_EXCEPTIONS

314: '_Pvt'
315: );
316: APP_EXCEPTION.RAISE_EXCEPTION;
317: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
318: x_return_status :=TAPI_DEV_KIT.HANDLE_EXCEPTIONS
319: (
320: l_api_name,
321: G_PKG_NAME,
322: 'FND_API.G_RET_STS_UNEXP_ERROR',

Line 328: WHEN TAPI_DEV_KIT.G_EXC_DUP_VAL_ON_INDEX THEN

324: x_msg_data,
325: '_Pvt'
326: );
327: APP_EXCEPTION.RAISE_EXCEPTION;
328: WHEN TAPI_DEV_KIT.G_EXC_DUP_VAL_ON_INDEX THEN
329: x_return_status :=TAPI_DEV_KIT.HANDLE_EXCEPTIONS
330: (
331: l_api_name,
332: G_PKG_NAME,

Line 329: x_return_status :=TAPI_DEV_KIT.HANDLE_EXCEPTIONS

325: '_Pvt'
326: );
327: APP_EXCEPTION.RAISE_EXCEPTION;
328: WHEN TAPI_DEV_KIT.G_EXC_DUP_VAL_ON_INDEX THEN
329: x_return_status :=TAPI_DEV_KIT.HANDLE_EXCEPTIONS
330: (
331: l_api_name,
332: G_PKG_NAME,
333: 'TAPI_DEV_KIT.G_RET_STS_DUP_VAL_ON_INDEX',

Line 333: 'TAPI_DEV_KIT.G_RET_STS_DUP_VAL_ON_INDEX',

329: x_return_status :=TAPI_DEV_KIT.HANDLE_EXCEPTIONS
330: (
331: l_api_name,
332: G_PKG_NAME,
333: 'TAPI_DEV_KIT.G_RET_STS_DUP_VAL_ON_INDEX',
334: x_msg_count,
335: x_msg_data,
336: '_Pvt'
337: );

Line 343: p_init_msg_list IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,

339: END insert_row;
340: PROCEDURE insert_row
341: (
342: p_api_version IN NUMBER,
343: p_init_msg_list IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
344: p_validation_level IN NUMBER,
345: p_commit IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
346: x_return_status OUT VARCHAR2,
347: x_msg_count OUT NUMBER,

Line 345: p_commit IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,

341: (
342: p_api_version IN NUMBER,
343: p_init_msg_list IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
344: p_validation_level IN NUMBER,
345: p_commit IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
346: x_return_status OUT VARCHAR2,
347: x_msg_count OUT NUMBER,
348: x_msg_data OUT VARCHAR2,
349: p_name IN CS_CONTRACT_STATUSES.NAME%TYPE := NULL,

Line 389: l_return_status := TAPI_DEV_KIT.START_ACTIVITY(l_api_name,

385: l_api_version CONSTANT NUMBER := 1;
386: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
387: l_contractstats_rec ContractStats_Rec_Type;
388: BEGIN
389: l_return_status := TAPI_DEV_KIT.START_ACTIVITY(l_api_name,
390: G_PKG_NAME,
391: l_api_version,
392: p_api_version,
393: p_init_msg_list,

Line 446: TAPI_DEV_KIT.END_ACTIVITY(p_commit, x_msg_count, x_msg_data);

442: l_contractstats_rec,
443: x_contract_status_id,
444: x_object_version_number
445: );
446: TAPI_DEV_KIT.END_ACTIVITY(p_commit, x_msg_count, x_msg_data);
447: EXCEPTION
448: WHEN FND_API.G_EXC_ERROR THEN
449: x_return_status := TAPI_DEV_KIT.HANDLE_EXCEPTIONS
450: (

Line 449: x_return_status := TAPI_DEV_KIT.HANDLE_EXCEPTIONS

445: );
446: TAPI_DEV_KIT.END_ACTIVITY(p_commit, x_msg_count, x_msg_data);
447: EXCEPTION
448: WHEN FND_API.G_EXC_ERROR THEN
449: x_return_status := TAPI_DEV_KIT.HANDLE_EXCEPTIONS
450: (
451: l_api_name,
452: G_PKG_NAME,
453: 'FND_API.G_RET_STS_ERROR',

Line 460: x_return_status :=TAPI_DEV_KIT.HANDLE_EXCEPTIONS

456: '_Pvt'
457: );
458: APP_EXCEPTION.RAISE_EXCEPTION;
459: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
460: x_return_status :=TAPI_DEV_KIT.HANDLE_EXCEPTIONS
461: (
462: l_api_name,
463: G_PKG_NAME,
464: 'FND_API.G_RET_STS_UNEXP_ERROR',

Line 470: WHEN TAPI_DEV_KIT.G_EXC_DUP_VAL_ON_INDEX THEN

466: x_msg_data,
467: '_Pvt'
468: );
469: APP_EXCEPTION.RAISE_EXCEPTION;
470: WHEN TAPI_DEV_KIT.G_EXC_DUP_VAL_ON_INDEX THEN
471: x_return_status :=TAPI_DEV_KIT.HANDLE_EXCEPTIONS
472: (
473: l_api_name,
474: G_PKG_NAME,

Line 471: x_return_status :=TAPI_DEV_KIT.HANDLE_EXCEPTIONS

467: '_Pvt'
468: );
469: APP_EXCEPTION.RAISE_EXCEPTION;
470: WHEN TAPI_DEV_KIT.G_EXC_DUP_VAL_ON_INDEX THEN
471: x_return_status :=TAPI_DEV_KIT.HANDLE_EXCEPTIONS
472: (
473: l_api_name,
474: G_PKG_NAME,
475: 'TAPI_DEV_KIT.G_RET_STS_DUP_VAL_ON_INDEX',

Line 475: 'TAPI_DEV_KIT.G_RET_STS_DUP_VAL_ON_INDEX',

471: x_return_status :=TAPI_DEV_KIT.HANDLE_EXCEPTIONS
472: (
473: l_api_name,
474: G_PKG_NAME,
475: 'TAPI_DEV_KIT.G_RET_STS_DUP_VAL_ON_INDEX',
476: x_msg_count,
477: x_msg_data,
478: '_Pvt'
479: );

Line 485: p_init_msg_list IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,

481: END insert_row;
482: Procedure lock_row
483: (
484: p_api_version IN NUMBER,
485: p_init_msg_list IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
486: p_validation_level IN NUMBER,
487: p_commit IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
488: x_return_status OUT VARCHAR2,
489: x_msg_count OUT NUMBER,

Line 487: p_commit IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,

483: (
484: p_api_version IN NUMBER,
485: p_init_msg_list IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
486: p_validation_level IN NUMBER,
487: p_commit IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
488: x_return_status OUT VARCHAR2,
489: x_msg_count OUT NUMBER,
490: x_msg_data OUT VARCHAR2,
491: p_contract_status_id IN NUMBER,

Line 517: l_return_status := TAPI_DEV_KIT.START_ACTIVITY(l_api_name,

513: lc_object_version_number CS_CONTRACT_STATUSES.OBJECT_VERSION_NUMBER%TYPE;
514: l_row_notfound BOOLEAN := FALSE;
515: lc_row_notfound BOOLEAN := FALSE;
516: BEGIN
517: l_return_status := TAPI_DEV_KIT.START_ACTIVITY(l_api_name,
518: G_PKG_NAME,
519: l_api_version,
520: p_api_version,
521: p_init_msg_list,

Line 539: TAPI_DEV_KIT.set_message(G_FND_APP,G_FORM_UNABLE_TO_RESERVE_REC);

535: WHEN E_Resource_Busy THEN
536: IF (lock_csr%ISOPEN) THEN
537: CLOSE lock_csr;
538: END IF;
539: TAPI_DEV_KIT.set_message(G_FND_APP,G_FORM_UNABLE_TO_RESERVE_REC);
540: RAISE APP_EXCEPTIONS.RECORD_LOCK_EXCEPTION;
541: END;
542:
543: IF ( l_row_notfound ) THEN

Line 550: TAPI_DEV_KIT.set_message(G_FND_APP,G_FORM_RECORD_DELETED);

546: lc_row_notfound := lchk_csr%NOTFOUND;
547: CLOSE lchk_csr;
548: END IF;
549: IF (lc_row_notfound) THEN
550: TAPI_DEV_KIT.set_message(G_FND_APP,G_FORM_RECORD_DELETED);
551: RAISE FND_API.G_EXC_ERROR;
552: ELSIF lc_object_version_number > p_object_version_number THEN
553: TAPI_DEV_KIT.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
554: RAISE FND_API.G_EXC_ERROR;

Line 553: TAPI_DEV_KIT.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);

549: IF (lc_row_notfound) THEN
550: TAPI_DEV_KIT.set_message(G_FND_APP,G_FORM_RECORD_DELETED);
551: RAISE FND_API.G_EXC_ERROR;
552: ELSIF lc_object_version_number > p_object_version_number THEN
553: TAPI_DEV_KIT.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
554: RAISE FND_API.G_EXC_ERROR;
555: ELSIF lc_object_version_number <> p_object_version_number THEN
556: TAPI_DEV_KIT.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
557: RAISE FND_API.G_EXC_ERROR;

Line 556: TAPI_DEV_KIT.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);

552: ELSIF lc_object_version_number > p_object_version_number THEN
553: TAPI_DEV_KIT.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
554: RAISE FND_API.G_EXC_ERROR;
555: ELSIF lc_object_version_number <> p_object_version_number THEN
556: TAPI_DEV_KIT.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
557: RAISE FND_API.G_EXC_ERROR;
558: ELSIF lc_object_version_number = -1 THEN
559: TAPI_DEV_KIT.set_message(G_APP_NAME,G_RECORD_LOGICALLY_DELETED);
560: RAISE FND_API.G_EXC_ERROR;

Line 559: TAPI_DEV_KIT.set_message(G_APP_NAME,G_RECORD_LOGICALLY_DELETED);

555: ELSIF lc_object_version_number <> p_object_version_number THEN
556: TAPI_DEV_KIT.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
557: RAISE FND_API.G_EXC_ERROR;
558: ELSIF lc_object_version_number = -1 THEN
559: TAPI_DEV_KIT.set_message(G_APP_NAME,G_RECORD_LOGICALLY_DELETED);
560: RAISE FND_API.G_EXC_ERROR;
561: END IF;
562: TAPI_DEV_KIT.END_ACTIVITY(p_commit, x_msg_count, x_msg_data);
563: EXCEPTION

Line 562: TAPI_DEV_KIT.END_ACTIVITY(p_commit, x_msg_count, x_msg_data);

558: ELSIF lc_object_version_number = -1 THEN
559: TAPI_DEV_KIT.set_message(G_APP_NAME,G_RECORD_LOGICALLY_DELETED);
560: RAISE FND_API.G_EXC_ERROR;
561: END IF;
562: TAPI_DEV_KIT.END_ACTIVITY(p_commit, x_msg_count, x_msg_data);
563: EXCEPTION
564: WHEN FND_API.G_EXC_ERROR THEN
565: x_return_status := TAPI_DEV_KIT.HANDLE_EXCEPTIONS
566: (

Line 565: x_return_status := TAPI_DEV_KIT.HANDLE_EXCEPTIONS

561: END IF;
562: TAPI_DEV_KIT.END_ACTIVITY(p_commit, x_msg_count, x_msg_data);
563: EXCEPTION
564: WHEN FND_API.G_EXC_ERROR THEN
565: x_return_status := TAPI_DEV_KIT.HANDLE_EXCEPTIONS
566: (
567: l_api_name,
568: G_PKG_NAME,
569: 'FND_API.G_RET_STS_ERROR',

Line 576: x_return_status :=TAPI_DEV_KIT.HANDLE_EXCEPTIONS

572: '_Pvt'
573: );
574: APP_EXCEPTION.RAISE_EXCEPTION;
575: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
576: x_return_status :=TAPI_DEV_KIT.HANDLE_EXCEPTIONS
577: (
578: l_api_name,
579: G_PKG_NAME,
580: 'FND_API.G_RET_STS_UNEXP_ERROR',

Line 586: WHEN TAPI_DEV_KIT.G_EXC_DUP_VAL_ON_INDEX THEN

582: x_msg_data,
583: '_Pvt'
584: );
585: APP_EXCEPTION.RAISE_EXCEPTION;
586: WHEN TAPI_DEV_KIT.G_EXC_DUP_VAL_ON_INDEX THEN
587: x_return_status :=TAPI_DEV_KIT.HANDLE_EXCEPTIONS
588: (
589: l_api_name,
590: G_PKG_NAME,

Line 587: x_return_status :=TAPI_DEV_KIT.HANDLE_EXCEPTIONS

583: '_Pvt'
584: );
585: APP_EXCEPTION.RAISE_EXCEPTION;
586: WHEN TAPI_DEV_KIT.G_EXC_DUP_VAL_ON_INDEX THEN
587: x_return_status :=TAPI_DEV_KIT.HANDLE_EXCEPTIONS
588: (
589: l_api_name,
590: G_PKG_NAME,
591: 'TAPI_DEV_KIT.G_RET_STS_DUP_VAL_ON_INDEX',

Line 591: 'TAPI_DEV_KIT.G_RET_STS_DUP_VAL_ON_INDEX',

587: x_return_status :=TAPI_DEV_KIT.HANDLE_EXCEPTIONS
588: (
589: l_api_name,
590: G_PKG_NAME,
591: 'TAPI_DEV_KIT.G_RET_STS_DUP_VAL_ON_INDEX',
592: x_msg_count,
593: x_msg_data,
594: '_Pvt'
595: );

Line 601: p_init_msg_list IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,

597: END lock_row;
598: Procedure update_row
599: (
600: p_api_version IN NUMBER,
601: p_init_msg_list IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
602: p_validation_level IN NUMBER,
603: p_commit IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
604: x_return_status OUT VARCHAR2,
605: x_msg_count OUT NUMBER,

Line 603: p_commit IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,

599: (
600: p_api_version IN NUMBER,
601: p_init_msg_list IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
602: p_validation_level IN NUMBER,
603: p_commit IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
604: x_return_status OUT VARCHAR2,
605: x_msg_count OUT NUMBER,
606: x_msg_data OUT VARCHAR2,
607: p_contractstats_val_rec IN ContractStats_Val_Rec_Type := G_MISS_CONTRACTSTATS_VAL_REC,

Line 635: IF (x_contractstats_rec.contract_status_id = TAPI_DEV_KIT.G_MISS_NUM)

631: CLOSE cs_contracts_statuses_pk_csr;
632: IF (l_row_notfound) THEN
633: l_return_status := FND_API.G_RET_STS_ERROR;
634: END IF;
635: IF (x_contractstats_rec.contract_status_id = TAPI_DEV_KIT.G_MISS_NUM)
636: THEN
637: x_contractstats_rec.contract_status_id := l_cs_contracts_statuses_pk.contract_status_id;
638: END IF;
639: IF (x_contractstats_rec.name = TAPI_DEV_KIT.G_MISS_CHAR)

Line 639: IF (x_contractstats_rec.name = TAPI_DEV_KIT.G_MISS_CHAR)

635: IF (x_contractstats_rec.contract_status_id = TAPI_DEV_KIT.G_MISS_NUM)
636: THEN
637: x_contractstats_rec.contract_status_id := l_cs_contracts_statuses_pk.contract_status_id;
638: END IF;
639: IF (x_contractstats_rec.name = TAPI_DEV_KIT.G_MISS_CHAR)
640: THEN
641: x_contractstats_rec.name := l_cs_contracts_statuses_pk.name;
642: END IF;
643: IF (x_contractstats_rec.description = TAPI_DEV_KIT.G_MISS_CHAR)

Line 643: IF (x_contractstats_rec.description = TAPI_DEV_KIT.G_MISS_CHAR)

639: IF (x_contractstats_rec.name = TAPI_DEV_KIT.G_MISS_CHAR)
640: THEN
641: x_contractstats_rec.name := l_cs_contracts_statuses_pk.name;
642: END IF;
643: IF (x_contractstats_rec.description = TAPI_DEV_KIT.G_MISS_CHAR)
644: THEN
645: x_contractstats_rec.description := l_cs_contracts_statuses_pk.description;
646: END IF;
647: IF (x_contractstats_rec.validate_contract = TAPI_DEV_KIT.G_MISS_CHAR)

Line 647: IF (x_contractstats_rec.validate_contract = TAPI_DEV_KIT.G_MISS_CHAR)

643: IF (x_contractstats_rec.description = TAPI_DEV_KIT.G_MISS_CHAR)
644: THEN
645: x_contractstats_rec.description := l_cs_contracts_statuses_pk.description;
646: END IF;
647: IF (x_contractstats_rec.validate_contract = TAPI_DEV_KIT.G_MISS_CHAR)
648: THEN
649: x_contractstats_rec.validate_contract := l_cs_contracts_statuses_pk.validate_contract;
650: END IF;
651: IF (x_contractstats_rec.status_level = TAPI_DEV_KIT.G_MISS_NUM)

Line 651: IF (x_contractstats_rec.status_level = TAPI_DEV_KIT.G_MISS_NUM)

647: IF (x_contractstats_rec.validate_contract = TAPI_DEV_KIT.G_MISS_CHAR)
648: THEN
649: x_contractstats_rec.validate_contract := l_cs_contracts_statuses_pk.validate_contract;
650: END IF;
651: IF (x_contractstats_rec.status_level = TAPI_DEV_KIT.G_MISS_NUM)
652: THEN
653: x_contractstats_rec.status_level := l_cs_contracts_statuses_pk.status_level;
654: END IF;
655: IF (x_contractstats_rec.eligible_for_invoicing = TAPI_DEV_KIT.G_MISS_CHAR)

Line 655: IF (x_contractstats_rec.eligible_for_invoicing = TAPI_DEV_KIT.G_MISS_CHAR)

651: IF (x_contractstats_rec.status_level = TAPI_DEV_KIT.G_MISS_NUM)
652: THEN
653: x_contractstats_rec.status_level := l_cs_contracts_statuses_pk.status_level;
654: END IF;
655: IF (x_contractstats_rec.eligible_for_invoicing = TAPI_DEV_KIT.G_MISS_CHAR)
656: THEN
657: x_contractstats_rec.eligible_for_invoicing := l_cs_contracts_statuses_pk.eligible_for_invoicing;
658: END IF;
659: IF (x_contractstats_rec.update_allowed = TAPI_DEV_KIT.G_MISS_CHAR)

Line 659: IF (x_contractstats_rec.update_allowed = TAPI_DEV_KIT.G_MISS_CHAR)

655: IF (x_contractstats_rec.eligible_for_invoicing = TAPI_DEV_KIT.G_MISS_CHAR)
656: THEN
657: x_contractstats_rec.eligible_for_invoicing := l_cs_contracts_statuses_pk.eligible_for_invoicing;
658: END IF;
659: IF (x_contractstats_rec.update_allowed = TAPI_DEV_KIT.G_MISS_CHAR)
660: THEN
661: x_contractstats_rec.update_allowed := l_cs_contracts_statuses_pk.update_allowed;
662: END IF;
663: IF (x_contractstats_rec.eligible_for_entitlements = TAPI_DEV_KIT.G_MISS_CHAR)

Line 663: IF (x_contractstats_rec.eligible_for_entitlements = TAPI_DEV_KIT.G_MISS_CHAR)

659: IF (x_contractstats_rec.update_allowed = TAPI_DEV_KIT.G_MISS_CHAR)
660: THEN
661: x_contractstats_rec.update_allowed := l_cs_contracts_statuses_pk.update_allowed;
662: END IF;
663: IF (x_contractstats_rec.eligible_for_entitlements = TAPI_DEV_KIT.G_MISS_CHAR)
664: THEN
665: x_contractstats_rec.eligible_for_entitlements := l_cs_contracts_statuses_pk.eligible_for_entitlements;
666: END IF;
667: IF (x_contractstats_rec.terminated_flag = TAPI_DEV_KIT.G_MISS_CHAR)

Line 667: IF (x_contractstats_rec.terminated_flag = TAPI_DEV_KIT.G_MISS_CHAR)

663: IF (x_contractstats_rec.eligible_for_entitlements = TAPI_DEV_KIT.G_MISS_CHAR)
664: THEN
665: x_contractstats_rec.eligible_for_entitlements := l_cs_contracts_statuses_pk.eligible_for_entitlements;
666: END IF;
667: IF (x_contractstats_rec.terminated_flag = TAPI_DEV_KIT.G_MISS_CHAR)
668: THEN
669: x_contractstats_rec.terminated_flag := l_cs_contracts_statuses_pk.terminated_flag;
670: END IF;
671: IF (x_contractstats_rec.delete_allowed = TAPI_DEV_KIT.G_MISS_CHAR)

Line 671: IF (x_contractstats_rec.delete_allowed = TAPI_DEV_KIT.G_MISS_CHAR)

667: IF (x_contractstats_rec.terminated_flag = TAPI_DEV_KIT.G_MISS_CHAR)
668: THEN
669: x_contractstats_rec.terminated_flag := l_cs_contracts_statuses_pk.terminated_flag;
670: END IF;
671: IF (x_contractstats_rec.delete_allowed = TAPI_DEV_KIT.G_MISS_CHAR)
672: THEN
673: x_contractstats_rec.delete_allowed := l_cs_contracts_statuses_pk.delete_allowed;
674: END IF;
675: IF (x_contractstats_rec.last_update_date = TAPI_DEV_KIT.G_MISS_DATE)

Line 675: IF (x_contractstats_rec.last_update_date = TAPI_DEV_KIT.G_MISS_DATE)

671: IF (x_contractstats_rec.delete_allowed = TAPI_DEV_KIT.G_MISS_CHAR)
672: THEN
673: x_contractstats_rec.delete_allowed := l_cs_contracts_statuses_pk.delete_allowed;
674: END IF;
675: IF (x_contractstats_rec.last_update_date = TAPI_DEV_KIT.G_MISS_DATE)
676: THEN
677: x_contractstats_rec.last_update_date := l_cs_contracts_statuses_pk.last_update_date;
678: END IF;
679: IF (x_contractstats_rec.last_updated_by = TAPI_DEV_KIT.G_MISS_NUM)

Line 679: IF (x_contractstats_rec.last_updated_by = TAPI_DEV_KIT.G_MISS_NUM)

675: IF (x_contractstats_rec.last_update_date = TAPI_DEV_KIT.G_MISS_DATE)
676: THEN
677: x_contractstats_rec.last_update_date := l_cs_contracts_statuses_pk.last_update_date;
678: END IF;
679: IF (x_contractstats_rec.last_updated_by = TAPI_DEV_KIT.G_MISS_NUM)
680: THEN
681: x_contractstats_rec.last_updated_by := l_cs_contracts_statuses_pk.last_updated_by;
682: END IF;
683: IF (x_contractstats_rec.creation_date = TAPI_DEV_KIT.G_MISS_DATE)

Line 683: IF (x_contractstats_rec.creation_date = TAPI_DEV_KIT.G_MISS_DATE)

679: IF (x_contractstats_rec.last_updated_by = TAPI_DEV_KIT.G_MISS_NUM)
680: THEN
681: x_contractstats_rec.last_updated_by := l_cs_contracts_statuses_pk.last_updated_by;
682: END IF;
683: IF (x_contractstats_rec.creation_date = TAPI_DEV_KIT.G_MISS_DATE)
684: THEN
685: x_contractstats_rec.creation_date := l_cs_contracts_statuses_pk.creation_date;
686: END IF;
687: IF (x_contractstats_rec.created_by = TAPI_DEV_KIT.G_MISS_NUM)

Line 687: IF (x_contractstats_rec.created_by = TAPI_DEV_KIT.G_MISS_NUM)

683: IF (x_contractstats_rec.creation_date = TAPI_DEV_KIT.G_MISS_DATE)
684: THEN
685: x_contractstats_rec.creation_date := l_cs_contracts_statuses_pk.creation_date;
686: END IF;
687: IF (x_contractstats_rec.created_by = TAPI_DEV_KIT.G_MISS_NUM)
688: THEN
689: x_contractstats_rec.created_by := l_cs_contracts_statuses_pk.created_by;
690: END IF;
691: IF (x_contractstats_rec.last_update_login = TAPI_DEV_KIT.G_MISS_NUM)

Line 691: IF (x_contractstats_rec.last_update_login = TAPI_DEV_KIT.G_MISS_NUM)

687: IF (x_contractstats_rec.created_by = TAPI_DEV_KIT.G_MISS_NUM)
688: THEN
689: x_contractstats_rec.created_by := l_cs_contracts_statuses_pk.created_by;
690: END IF;
691: IF (x_contractstats_rec.last_update_login = TAPI_DEV_KIT.G_MISS_NUM)
692: THEN
693: x_contractstats_rec.last_update_login := l_cs_contracts_statuses_pk.last_update_login;
694: END IF;
695: IF (x_contractstats_rec.start_date_active = TAPI_DEV_KIT.G_MISS_DATE)

Line 695: IF (x_contractstats_rec.start_date_active = TAPI_DEV_KIT.G_MISS_DATE)

691: IF (x_contractstats_rec.last_update_login = TAPI_DEV_KIT.G_MISS_NUM)
692: THEN
693: x_contractstats_rec.last_update_login := l_cs_contracts_statuses_pk.last_update_login;
694: END IF;
695: IF (x_contractstats_rec.start_date_active = TAPI_DEV_KIT.G_MISS_DATE)
696: THEN
697: x_contractstats_rec.start_date_active := l_cs_contracts_statuses_pk.start_date_active;
698: END IF;
699: IF (x_contractstats_rec.end_date_active = TAPI_DEV_KIT.G_MISS_DATE)

Line 699: IF (x_contractstats_rec.end_date_active = TAPI_DEV_KIT.G_MISS_DATE)

695: IF (x_contractstats_rec.start_date_active = TAPI_DEV_KIT.G_MISS_DATE)
696: THEN
697: x_contractstats_rec.start_date_active := l_cs_contracts_statuses_pk.start_date_active;
698: END IF;
699: IF (x_contractstats_rec.end_date_active = TAPI_DEV_KIT.G_MISS_DATE)
700: THEN
701: x_contractstats_rec.end_date_active := l_cs_contracts_statuses_pk.end_date_active;
702: END IF;
703: IF (x_contractstats_rec.attribute1 = TAPI_DEV_KIT.G_MISS_CHAR)

Line 703: IF (x_contractstats_rec.attribute1 = TAPI_DEV_KIT.G_MISS_CHAR)

699: IF (x_contractstats_rec.end_date_active = TAPI_DEV_KIT.G_MISS_DATE)
700: THEN
701: x_contractstats_rec.end_date_active := l_cs_contracts_statuses_pk.end_date_active;
702: END IF;
703: IF (x_contractstats_rec.attribute1 = TAPI_DEV_KIT.G_MISS_CHAR)
704: THEN
705: x_contractstats_rec.attribute1 := l_cs_contracts_statuses_pk.attribute1;
706: END IF;
707: IF (x_contractstats_rec.attribute2 = TAPI_DEV_KIT.G_MISS_CHAR)

Line 707: IF (x_contractstats_rec.attribute2 = TAPI_DEV_KIT.G_MISS_CHAR)

703: IF (x_contractstats_rec.attribute1 = TAPI_DEV_KIT.G_MISS_CHAR)
704: THEN
705: x_contractstats_rec.attribute1 := l_cs_contracts_statuses_pk.attribute1;
706: END IF;
707: IF (x_contractstats_rec.attribute2 = TAPI_DEV_KIT.G_MISS_CHAR)
708: THEN
709: x_contractstats_rec.attribute2 := l_cs_contracts_statuses_pk.attribute2;
710: END IF;
711: IF (x_contractstats_rec.attribute3 = TAPI_DEV_KIT.G_MISS_CHAR)

Line 711: IF (x_contractstats_rec.attribute3 = TAPI_DEV_KIT.G_MISS_CHAR)

707: IF (x_contractstats_rec.attribute2 = TAPI_DEV_KIT.G_MISS_CHAR)
708: THEN
709: x_contractstats_rec.attribute2 := l_cs_contracts_statuses_pk.attribute2;
710: END IF;
711: IF (x_contractstats_rec.attribute3 = TAPI_DEV_KIT.G_MISS_CHAR)
712: THEN
713: x_contractstats_rec.attribute3 := l_cs_contracts_statuses_pk.attribute3;
714: END IF;
715: IF (x_contractstats_rec.attribute4 = TAPI_DEV_KIT.G_MISS_CHAR)

Line 715: IF (x_contractstats_rec.attribute4 = TAPI_DEV_KIT.G_MISS_CHAR)

711: IF (x_contractstats_rec.attribute3 = TAPI_DEV_KIT.G_MISS_CHAR)
712: THEN
713: x_contractstats_rec.attribute3 := l_cs_contracts_statuses_pk.attribute3;
714: END IF;
715: IF (x_contractstats_rec.attribute4 = TAPI_DEV_KIT.G_MISS_CHAR)
716: THEN
717: x_contractstats_rec.attribute4 := l_cs_contracts_statuses_pk.attribute4;
718: END IF;
719: IF (x_contractstats_rec.attribute5 = TAPI_DEV_KIT.G_MISS_CHAR)

Line 719: IF (x_contractstats_rec.attribute5 = TAPI_DEV_KIT.G_MISS_CHAR)

715: IF (x_contractstats_rec.attribute4 = TAPI_DEV_KIT.G_MISS_CHAR)
716: THEN
717: x_contractstats_rec.attribute4 := l_cs_contracts_statuses_pk.attribute4;
718: END IF;
719: IF (x_contractstats_rec.attribute5 = TAPI_DEV_KIT.G_MISS_CHAR)
720: THEN
721: x_contractstats_rec.attribute5 := l_cs_contracts_statuses_pk.attribute5;
722: END IF;
723: IF (x_contractstats_rec.attribute6 = TAPI_DEV_KIT.G_MISS_CHAR)

Line 723: IF (x_contractstats_rec.attribute6 = TAPI_DEV_KIT.G_MISS_CHAR)

719: IF (x_contractstats_rec.attribute5 = TAPI_DEV_KIT.G_MISS_CHAR)
720: THEN
721: x_contractstats_rec.attribute5 := l_cs_contracts_statuses_pk.attribute5;
722: END IF;
723: IF (x_contractstats_rec.attribute6 = TAPI_DEV_KIT.G_MISS_CHAR)
724: THEN
725: x_contractstats_rec.attribute6 := l_cs_contracts_statuses_pk.attribute6;
726: END IF;
727: IF (x_contractstats_rec.attribute7 = TAPI_DEV_KIT.G_MISS_CHAR)

Line 727: IF (x_contractstats_rec.attribute7 = TAPI_DEV_KIT.G_MISS_CHAR)

723: IF (x_contractstats_rec.attribute6 = TAPI_DEV_KIT.G_MISS_CHAR)
724: THEN
725: x_contractstats_rec.attribute6 := l_cs_contracts_statuses_pk.attribute6;
726: END IF;
727: IF (x_contractstats_rec.attribute7 = TAPI_DEV_KIT.G_MISS_CHAR)
728: THEN
729: x_contractstats_rec.attribute7 := l_cs_contracts_statuses_pk.attribute7;
730: END IF;
731: IF (x_contractstats_rec.attribute8 = TAPI_DEV_KIT.G_MISS_CHAR)

Line 731: IF (x_contractstats_rec.attribute8 = TAPI_DEV_KIT.G_MISS_CHAR)

727: IF (x_contractstats_rec.attribute7 = TAPI_DEV_KIT.G_MISS_CHAR)
728: THEN
729: x_contractstats_rec.attribute7 := l_cs_contracts_statuses_pk.attribute7;
730: END IF;
731: IF (x_contractstats_rec.attribute8 = TAPI_DEV_KIT.G_MISS_CHAR)
732: THEN
733: x_contractstats_rec.attribute8 := l_cs_contracts_statuses_pk.attribute8;
734: END IF;
735: IF (x_contractstats_rec.attribute9 = TAPI_DEV_KIT.G_MISS_CHAR)

Line 735: IF (x_contractstats_rec.attribute9 = TAPI_DEV_KIT.G_MISS_CHAR)

731: IF (x_contractstats_rec.attribute8 = TAPI_DEV_KIT.G_MISS_CHAR)
732: THEN
733: x_contractstats_rec.attribute8 := l_cs_contracts_statuses_pk.attribute8;
734: END IF;
735: IF (x_contractstats_rec.attribute9 = TAPI_DEV_KIT.G_MISS_CHAR)
736: THEN
737: x_contractstats_rec.attribute9 := l_cs_contracts_statuses_pk.attribute9;
738: END IF;
739: IF (x_contractstats_rec.attribute10 = TAPI_DEV_KIT.G_MISS_CHAR)

Line 739: IF (x_contractstats_rec.attribute10 = TAPI_DEV_KIT.G_MISS_CHAR)

735: IF (x_contractstats_rec.attribute9 = TAPI_DEV_KIT.G_MISS_CHAR)
736: THEN
737: x_contractstats_rec.attribute9 := l_cs_contracts_statuses_pk.attribute9;
738: END IF;
739: IF (x_contractstats_rec.attribute10 = TAPI_DEV_KIT.G_MISS_CHAR)
740: THEN
741: x_contractstats_rec.attribute10 := l_cs_contracts_statuses_pk.attribute10;
742: END IF;
743: IF (x_contractstats_rec.attribute11 = TAPI_DEV_KIT.G_MISS_CHAR)

Line 743: IF (x_contractstats_rec.attribute11 = TAPI_DEV_KIT.G_MISS_CHAR)

739: IF (x_contractstats_rec.attribute10 = TAPI_DEV_KIT.G_MISS_CHAR)
740: THEN
741: x_contractstats_rec.attribute10 := l_cs_contracts_statuses_pk.attribute10;
742: END IF;
743: IF (x_contractstats_rec.attribute11 = TAPI_DEV_KIT.G_MISS_CHAR)
744: THEN
745: x_contractstats_rec.attribute11 := l_cs_contracts_statuses_pk.attribute11;
746: END IF;
747: IF (x_contractstats_rec.attribute12 = TAPI_DEV_KIT.G_MISS_CHAR)

Line 747: IF (x_contractstats_rec.attribute12 = TAPI_DEV_KIT.G_MISS_CHAR)

743: IF (x_contractstats_rec.attribute11 = TAPI_DEV_KIT.G_MISS_CHAR)
744: THEN
745: x_contractstats_rec.attribute11 := l_cs_contracts_statuses_pk.attribute11;
746: END IF;
747: IF (x_contractstats_rec.attribute12 = TAPI_DEV_KIT.G_MISS_CHAR)
748: THEN
749: x_contractstats_rec.attribute12 := l_cs_contracts_statuses_pk.attribute12;
750: END IF;
751: IF (x_contractstats_rec.attribute13 = TAPI_DEV_KIT.G_MISS_CHAR)

Line 751: IF (x_contractstats_rec.attribute13 = TAPI_DEV_KIT.G_MISS_CHAR)

747: IF (x_contractstats_rec.attribute12 = TAPI_DEV_KIT.G_MISS_CHAR)
748: THEN
749: x_contractstats_rec.attribute12 := l_cs_contracts_statuses_pk.attribute12;
750: END IF;
751: IF (x_contractstats_rec.attribute13 = TAPI_DEV_KIT.G_MISS_CHAR)
752: THEN
753: x_contractstats_rec.attribute13 := l_cs_contracts_statuses_pk.attribute13;
754: END IF;
755: IF (x_contractstats_rec.attribute14 = TAPI_DEV_KIT.G_MISS_CHAR)

Line 755: IF (x_contractstats_rec.attribute14 = TAPI_DEV_KIT.G_MISS_CHAR)

751: IF (x_contractstats_rec.attribute13 = TAPI_DEV_KIT.G_MISS_CHAR)
752: THEN
753: x_contractstats_rec.attribute13 := l_cs_contracts_statuses_pk.attribute13;
754: END IF;
755: IF (x_contractstats_rec.attribute14 = TAPI_DEV_KIT.G_MISS_CHAR)
756: THEN
757: x_contractstats_rec.attribute14 := l_cs_contracts_statuses_pk.attribute14;
758: END IF;
759: IF (x_contractstats_rec.attribute15 = TAPI_DEV_KIT.G_MISS_CHAR)

Line 759: IF (x_contractstats_rec.attribute15 = TAPI_DEV_KIT.G_MISS_CHAR)

755: IF (x_contractstats_rec.attribute14 = TAPI_DEV_KIT.G_MISS_CHAR)
756: THEN
757: x_contractstats_rec.attribute14 := l_cs_contracts_statuses_pk.attribute14;
758: END IF;
759: IF (x_contractstats_rec.attribute15 = TAPI_DEV_KIT.G_MISS_CHAR)
760: THEN
761: x_contractstats_rec.attribute15 := l_cs_contracts_statuses_pk.attribute15;
762: END IF;
763: IF (x_contractstats_rec.context = TAPI_DEV_KIT.G_MISS_CHAR)

Line 763: IF (x_contractstats_rec.context = TAPI_DEV_KIT.G_MISS_CHAR)

759: IF (x_contractstats_rec.attribute15 = TAPI_DEV_KIT.G_MISS_CHAR)
760: THEN
761: x_contractstats_rec.attribute15 := l_cs_contracts_statuses_pk.attribute15;
762: END IF;
763: IF (x_contractstats_rec.context = TAPI_DEV_KIT.G_MISS_CHAR)
764: THEN
765: x_contractstats_rec.context := l_cs_contracts_statuses_pk.context;
766: END IF;
767: IF (x_contractstats_rec.object_version_number = TAPI_DEV_KIT.G_MISS_NUM)

Line 767: IF (x_contractstats_rec.object_version_number = TAPI_DEV_KIT.G_MISS_NUM)

763: IF (x_contractstats_rec.context = TAPI_DEV_KIT.G_MISS_CHAR)
764: THEN
765: x_contractstats_rec.context := l_cs_contracts_statuses_pk.context;
766: END IF;
767: IF (x_contractstats_rec.object_version_number = TAPI_DEV_KIT.G_MISS_NUM)
768: THEN
769: x_contractstats_rec.object_version_number := l_cs_contracts_statuses_pk.object_version_number;
770: END IF;
771: RETURN(l_return_status);

Line 774: l_return_status := TAPI_DEV_KIT.START_ACTIVITY(l_api_name,

770: END IF;
771: RETURN(l_return_status);
772: END populate_new_record;
773: BEGIN
774: l_return_status := TAPI_DEV_KIT.START_ACTIVITY(l_api_name,
775: G_PKG_NAME,
776: l_api_version,
777: p_api_version,
778: p_init_msg_list,

Line 866: TAPI_DEV_KIT.END_ACTIVITY(p_commit, x_msg_count, x_msg_data);

862: WHERE
863: CONTRACT_STATUS_ID = l_def_contractstats_rec.contract_status_id
864: ;
865: x_object_version_number := l_def_contractstats_rec.OBJECT_VERSION_NUMBER;
866: TAPI_DEV_KIT.END_ACTIVITY(p_commit, x_msg_count, x_msg_data);
867: EXCEPTION
868: WHEN FND_API.G_EXC_ERROR THEN
869: x_return_status := TAPI_DEV_KIT.HANDLE_EXCEPTIONS
870: (

Line 869: x_return_status := TAPI_DEV_KIT.HANDLE_EXCEPTIONS

865: x_object_version_number := l_def_contractstats_rec.OBJECT_VERSION_NUMBER;
866: TAPI_DEV_KIT.END_ACTIVITY(p_commit, x_msg_count, x_msg_data);
867: EXCEPTION
868: WHEN FND_API.G_EXC_ERROR THEN
869: x_return_status := TAPI_DEV_KIT.HANDLE_EXCEPTIONS
870: (
871: l_api_name,
872: G_PKG_NAME,
873: 'FND_API.G_RET_STS_ERROR',

Line 880: x_return_status :=TAPI_DEV_KIT.HANDLE_EXCEPTIONS

876: '_Pvt'
877: );
878: APP_EXCEPTION.RAISE_EXCEPTION;
879: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
880: x_return_status :=TAPI_DEV_KIT.HANDLE_EXCEPTIONS
881: (
882: l_api_name,
883: G_PKG_NAME,
884: 'FND_API.G_RET_STS_UNEXP_ERROR',

Line 890: WHEN TAPI_DEV_KIT.G_EXC_DUP_VAL_ON_INDEX THEN

886: x_msg_data,
887: '_Pvt'
888: );
889: APP_EXCEPTION.RAISE_EXCEPTION;
890: WHEN TAPI_DEV_KIT.G_EXC_DUP_VAL_ON_INDEX THEN
891: x_return_status :=TAPI_DEV_KIT.HANDLE_EXCEPTIONS
892: (
893: l_api_name,
894: G_PKG_NAME,

Line 891: x_return_status :=TAPI_DEV_KIT.HANDLE_EXCEPTIONS

887: '_Pvt'
888: );
889: APP_EXCEPTION.RAISE_EXCEPTION;
890: WHEN TAPI_DEV_KIT.G_EXC_DUP_VAL_ON_INDEX THEN
891: x_return_status :=TAPI_DEV_KIT.HANDLE_EXCEPTIONS
892: (
893: l_api_name,
894: G_PKG_NAME,
895: 'TAPI_DEV_KIT.G_RET_STS_DUP_VAL_ON_INDEX',

Line 895: 'TAPI_DEV_KIT.G_RET_STS_DUP_VAL_ON_INDEX',

891: x_return_status :=TAPI_DEV_KIT.HANDLE_EXCEPTIONS
892: (
893: l_api_name,
894: G_PKG_NAME,
895: 'TAPI_DEV_KIT.G_RET_STS_DUP_VAL_ON_INDEX',
896: x_msg_count,
897: x_msg_data,
898: '_Pvt'
899: );

Line 905: p_init_msg_list IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,

901: END update_row;
902: Procedure update_row
903: (
904: p_api_version IN NUMBER,
905: p_init_msg_list IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
906: p_validation_level IN NUMBER,
907: p_commit IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
908: x_return_status OUT VARCHAR2,
909: x_msg_count OUT NUMBER,

Line 907: p_commit IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,

903: (
904: p_api_version IN NUMBER,
905: p_init_msg_list IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
906: p_validation_level IN NUMBER,
907: p_commit IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
908: x_return_status OUT VARCHAR2,
909: x_msg_count OUT NUMBER,
910: x_msg_data OUT VARCHAR2,
911: p_contract_status_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,

Line 911: p_contract_status_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,

907: p_commit IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
908: x_return_status OUT VARCHAR2,
909: x_msg_count OUT NUMBER,
910: x_msg_data OUT VARCHAR2,
911: p_contract_status_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
912: p_name IN CS_CONTRACT_STATUSES.NAME%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
913: p_description IN CS_CONTRACT_STATUSES.DESCRIPTION%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
914: p_validate_contract IN CS_CONTRACT_STATUSES.VALIDATE_CONTRACT%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
915: p_status_level IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,

Line 912: p_name IN CS_CONTRACT_STATUSES.NAME%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

908: x_return_status OUT VARCHAR2,
909: x_msg_count OUT NUMBER,
910: x_msg_data OUT VARCHAR2,
911: p_contract_status_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
912: p_name IN CS_CONTRACT_STATUSES.NAME%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
913: p_description IN CS_CONTRACT_STATUSES.DESCRIPTION%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
914: p_validate_contract IN CS_CONTRACT_STATUSES.VALIDATE_CONTRACT%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
915: p_status_level IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
916: p_eligible_for_invoicing IN CS_CONTRACT_STATUSES.ELIGIBLE_FOR_INVOICING%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

Line 913: p_description IN CS_CONTRACT_STATUSES.DESCRIPTION%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

909: x_msg_count OUT NUMBER,
910: x_msg_data OUT VARCHAR2,
911: p_contract_status_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
912: p_name IN CS_CONTRACT_STATUSES.NAME%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
913: p_description IN CS_CONTRACT_STATUSES.DESCRIPTION%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
914: p_validate_contract IN CS_CONTRACT_STATUSES.VALIDATE_CONTRACT%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
915: p_status_level IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
916: p_eligible_for_invoicing IN CS_CONTRACT_STATUSES.ELIGIBLE_FOR_INVOICING%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
917: p_update_allowed IN CS_CONTRACT_STATUSES.UPDATE_ALLOWED%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

Line 914: p_validate_contract IN CS_CONTRACT_STATUSES.VALIDATE_CONTRACT%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

910: x_msg_data OUT VARCHAR2,
911: p_contract_status_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
912: p_name IN CS_CONTRACT_STATUSES.NAME%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
913: p_description IN CS_CONTRACT_STATUSES.DESCRIPTION%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
914: p_validate_contract IN CS_CONTRACT_STATUSES.VALIDATE_CONTRACT%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
915: p_status_level IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
916: p_eligible_for_invoicing IN CS_CONTRACT_STATUSES.ELIGIBLE_FOR_INVOICING%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
917: p_update_allowed IN CS_CONTRACT_STATUSES.UPDATE_ALLOWED%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
918: p_eligible_for_entitlements IN CS_CONTRACT_STATUSES.ELIGIBLE_FOR_ENTITLEMENTS%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

Line 915: p_status_level IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,

911: p_contract_status_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
912: p_name IN CS_CONTRACT_STATUSES.NAME%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
913: p_description IN CS_CONTRACT_STATUSES.DESCRIPTION%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
914: p_validate_contract IN CS_CONTRACT_STATUSES.VALIDATE_CONTRACT%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
915: p_status_level IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
916: p_eligible_for_invoicing IN CS_CONTRACT_STATUSES.ELIGIBLE_FOR_INVOICING%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
917: p_update_allowed IN CS_CONTRACT_STATUSES.UPDATE_ALLOWED%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
918: p_eligible_for_entitlements IN CS_CONTRACT_STATUSES.ELIGIBLE_FOR_ENTITLEMENTS%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
919: p_terminated_flag IN CS_CONTRACT_STATUSES.TERMINATED_FLAG%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

Line 916: p_eligible_for_invoicing IN CS_CONTRACT_STATUSES.ELIGIBLE_FOR_INVOICING%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

912: p_name IN CS_CONTRACT_STATUSES.NAME%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
913: p_description IN CS_CONTRACT_STATUSES.DESCRIPTION%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
914: p_validate_contract IN CS_CONTRACT_STATUSES.VALIDATE_CONTRACT%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
915: p_status_level IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
916: p_eligible_for_invoicing IN CS_CONTRACT_STATUSES.ELIGIBLE_FOR_INVOICING%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
917: p_update_allowed IN CS_CONTRACT_STATUSES.UPDATE_ALLOWED%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
918: p_eligible_for_entitlements IN CS_CONTRACT_STATUSES.ELIGIBLE_FOR_ENTITLEMENTS%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
919: p_terminated_flag IN CS_CONTRACT_STATUSES.TERMINATED_FLAG%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
920: p_delete_allowed IN CS_CONTRACT_STATUSES.DELETE_ALLOWED%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

Line 917: p_update_allowed IN CS_CONTRACT_STATUSES.UPDATE_ALLOWED%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

913: p_description IN CS_CONTRACT_STATUSES.DESCRIPTION%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
914: p_validate_contract IN CS_CONTRACT_STATUSES.VALIDATE_CONTRACT%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
915: p_status_level IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
916: p_eligible_for_invoicing IN CS_CONTRACT_STATUSES.ELIGIBLE_FOR_INVOICING%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
917: p_update_allowed IN CS_CONTRACT_STATUSES.UPDATE_ALLOWED%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
918: p_eligible_for_entitlements IN CS_CONTRACT_STATUSES.ELIGIBLE_FOR_ENTITLEMENTS%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
919: p_terminated_flag IN CS_CONTRACT_STATUSES.TERMINATED_FLAG%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
920: p_delete_allowed IN CS_CONTRACT_STATUSES.DELETE_ALLOWED%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
921: p_last_update_date IN CS_CONTRACT_STATUSES.LAST_UPDATE_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,

Line 918: p_eligible_for_entitlements IN CS_CONTRACT_STATUSES.ELIGIBLE_FOR_ENTITLEMENTS%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

914: p_validate_contract IN CS_CONTRACT_STATUSES.VALIDATE_CONTRACT%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
915: p_status_level IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
916: p_eligible_for_invoicing IN CS_CONTRACT_STATUSES.ELIGIBLE_FOR_INVOICING%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
917: p_update_allowed IN CS_CONTRACT_STATUSES.UPDATE_ALLOWED%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
918: p_eligible_for_entitlements IN CS_CONTRACT_STATUSES.ELIGIBLE_FOR_ENTITLEMENTS%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
919: p_terminated_flag IN CS_CONTRACT_STATUSES.TERMINATED_FLAG%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
920: p_delete_allowed IN CS_CONTRACT_STATUSES.DELETE_ALLOWED%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
921: p_last_update_date IN CS_CONTRACT_STATUSES.LAST_UPDATE_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
922: p_last_updated_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,

Line 919: p_terminated_flag IN CS_CONTRACT_STATUSES.TERMINATED_FLAG%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

915: p_status_level IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
916: p_eligible_for_invoicing IN CS_CONTRACT_STATUSES.ELIGIBLE_FOR_INVOICING%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
917: p_update_allowed IN CS_CONTRACT_STATUSES.UPDATE_ALLOWED%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
918: p_eligible_for_entitlements IN CS_CONTRACT_STATUSES.ELIGIBLE_FOR_ENTITLEMENTS%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
919: p_terminated_flag IN CS_CONTRACT_STATUSES.TERMINATED_FLAG%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
920: p_delete_allowed IN CS_CONTRACT_STATUSES.DELETE_ALLOWED%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
921: p_last_update_date IN CS_CONTRACT_STATUSES.LAST_UPDATE_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
922: p_last_updated_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
923: p_creation_date IN CS_CONTRACT_STATUSES.CREATION_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,

Line 920: p_delete_allowed IN CS_CONTRACT_STATUSES.DELETE_ALLOWED%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

916: p_eligible_for_invoicing IN CS_CONTRACT_STATUSES.ELIGIBLE_FOR_INVOICING%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
917: p_update_allowed IN CS_CONTRACT_STATUSES.UPDATE_ALLOWED%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
918: p_eligible_for_entitlements IN CS_CONTRACT_STATUSES.ELIGIBLE_FOR_ENTITLEMENTS%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
919: p_terminated_flag IN CS_CONTRACT_STATUSES.TERMINATED_FLAG%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
920: p_delete_allowed IN CS_CONTRACT_STATUSES.DELETE_ALLOWED%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
921: p_last_update_date IN CS_CONTRACT_STATUSES.LAST_UPDATE_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
922: p_last_updated_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
923: p_creation_date IN CS_CONTRACT_STATUSES.CREATION_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
924: p_created_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,

Line 921: p_last_update_date IN CS_CONTRACT_STATUSES.LAST_UPDATE_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,

917: p_update_allowed IN CS_CONTRACT_STATUSES.UPDATE_ALLOWED%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
918: p_eligible_for_entitlements IN CS_CONTRACT_STATUSES.ELIGIBLE_FOR_ENTITLEMENTS%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
919: p_terminated_flag IN CS_CONTRACT_STATUSES.TERMINATED_FLAG%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
920: p_delete_allowed IN CS_CONTRACT_STATUSES.DELETE_ALLOWED%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
921: p_last_update_date IN CS_CONTRACT_STATUSES.LAST_UPDATE_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
922: p_last_updated_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
923: p_creation_date IN CS_CONTRACT_STATUSES.CREATION_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
924: p_created_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
925: p_last_update_login IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,

Line 922: p_last_updated_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,

918: p_eligible_for_entitlements IN CS_CONTRACT_STATUSES.ELIGIBLE_FOR_ENTITLEMENTS%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
919: p_terminated_flag IN CS_CONTRACT_STATUSES.TERMINATED_FLAG%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
920: p_delete_allowed IN CS_CONTRACT_STATUSES.DELETE_ALLOWED%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
921: p_last_update_date IN CS_CONTRACT_STATUSES.LAST_UPDATE_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
922: p_last_updated_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
923: p_creation_date IN CS_CONTRACT_STATUSES.CREATION_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
924: p_created_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
925: p_last_update_login IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
926: p_start_date_active IN CS_CONTRACT_STATUSES.START_DATE_ACTIVE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,

Line 923: p_creation_date IN CS_CONTRACT_STATUSES.CREATION_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,

919: p_terminated_flag IN CS_CONTRACT_STATUSES.TERMINATED_FLAG%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
920: p_delete_allowed IN CS_CONTRACT_STATUSES.DELETE_ALLOWED%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
921: p_last_update_date IN CS_CONTRACT_STATUSES.LAST_UPDATE_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
922: p_last_updated_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
923: p_creation_date IN CS_CONTRACT_STATUSES.CREATION_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
924: p_created_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
925: p_last_update_login IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
926: p_start_date_active IN CS_CONTRACT_STATUSES.START_DATE_ACTIVE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
927: p_end_date_active IN CS_CONTRACT_STATUSES.END_DATE_ACTIVE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,

Line 924: p_created_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,

920: p_delete_allowed IN CS_CONTRACT_STATUSES.DELETE_ALLOWED%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
921: p_last_update_date IN CS_CONTRACT_STATUSES.LAST_UPDATE_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
922: p_last_updated_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
923: p_creation_date IN CS_CONTRACT_STATUSES.CREATION_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
924: p_created_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
925: p_last_update_login IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
926: p_start_date_active IN CS_CONTRACT_STATUSES.START_DATE_ACTIVE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
927: p_end_date_active IN CS_CONTRACT_STATUSES.END_DATE_ACTIVE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
928: p_attribute1 IN CS_CONTRACT_STATUSES.ATTRIBUTE1%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

Line 925: p_last_update_login IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,

921: p_last_update_date IN CS_CONTRACT_STATUSES.LAST_UPDATE_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
922: p_last_updated_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
923: p_creation_date IN CS_CONTRACT_STATUSES.CREATION_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
924: p_created_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
925: p_last_update_login IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
926: p_start_date_active IN CS_CONTRACT_STATUSES.START_DATE_ACTIVE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
927: p_end_date_active IN CS_CONTRACT_STATUSES.END_DATE_ACTIVE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
928: p_attribute1 IN CS_CONTRACT_STATUSES.ATTRIBUTE1%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
929: p_attribute2 IN CS_CONTRACT_STATUSES.ATTRIBUTE2%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

Line 926: p_start_date_active IN CS_CONTRACT_STATUSES.START_DATE_ACTIVE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,

922: p_last_updated_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
923: p_creation_date IN CS_CONTRACT_STATUSES.CREATION_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
924: p_created_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
925: p_last_update_login IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
926: p_start_date_active IN CS_CONTRACT_STATUSES.START_DATE_ACTIVE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
927: p_end_date_active IN CS_CONTRACT_STATUSES.END_DATE_ACTIVE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
928: p_attribute1 IN CS_CONTRACT_STATUSES.ATTRIBUTE1%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
929: p_attribute2 IN CS_CONTRACT_STATUSES.ATTRIBUTE2%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
930: p_attribute3 IN CS_CONTRACT_STATUSES.ATTRIBUTE3%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

Line 927: p_end_date_active IN CS_CONTRACT_STATUSES.END_DATE_ACTIVE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,

923: p_creation_date IN CS_CONTRACT_STATUSES.CREATION_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
924: p_created_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
925: p_last_update_login IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
926: p_start_date_active IN CS_CONTRACT_STATUSES.START_DATE_ACTIVE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
927: p_end_date_active IN CS_CONTRACT_STATUSES.END_DATE_ACTIVE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
928: p_attribute1 IN CS_CONTRACT_STATUSES.ATTRIBUTE1%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
929: p_attribute2 IN CS_CONTRACT_STATUSES.ATTRIBUTE2%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
930: p_attribute3 IN CS_CONTRACT_STATUSES.ATTRIBUTE3%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
931: p_attribute4 IN CS_CONTRACT_STATUSES.ATTRIBUTE4%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

Line 928: p_attribute1 IN CS_CONTRACT_STATUSES.ATTRIBUTE1%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

924: p_created_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
925: p_last_update_login IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
926: p_start_date_active IN CS_CONTRACT_STATUSES.START_DATE_ACTIVE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
927: p_end_date_active IN CS_CONTRACT_STATUSES.END_DATE_ACTIVE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
928: p_attribute1 IN CS_CONTRACT_STATUSES.ATTRIBUTE1%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
929: p_attribute2 IN CS_CONTRACT_STATUSES.ATTRIBUTE2%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
930: p_attribute3 IN CS_CONTRACT_STATUSES.ATTRIBUTE3%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
931: p_attribute4 IN CS_CONTRACT_STATUSES.ATTRIBUTE4%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
932: p_attribute5 IN CS_CONTRACT_STATUSES.ATTRIBUTE5%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

Line 929: p_attribute2 IN CS_CONTRACT_STATUSES.ATTRIBUTE2%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

925: p_last_update_login IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
926: p_start_date_active IN CS_CONTRACT_STATUSES.START_DATE_ACTIVE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
927: p_end_date_active IN CS_CONTRACT_STATUSES.END_DATE_ACTIVE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
928: p_attribute1 IN CS_CONTRACT_STATUSES.ATTRIBUTE1%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
929: p_attribute2 IN CS_CONTRACT_STATUSES.ATTRIBUTE2%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
930: p_attribute3 IN CS_CONTRACT_STATUSES.ATTRIBUTE3%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
931: p_attribute4 IN CS_CONTRACT_STATUSES.ATTRIBUTE4%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
932: p_attribute5 IN CS_CONTRACT_STATUSES.ATTRIBUTE5%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
933: p_attribute6 IN CS_CONTRACT_STATUSES.ATTRIBUTE6%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

Line 930: p_attribute3 IN CS_CONTRACT_STATUSES.ATTRIBUTE3%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

926: p_start_date_active IN CS_CONTRACT_STATUSES.START_DATE_ACTIVE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
927: p_end_date_active IN CS_CONTRACT_STATUSES.END_DATE_ACTIVE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
928: p_attribute1 IN CS_CONTRACT_STATUSES.ATTRIBUTE1%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
929: p_attribute2 IN CS_CONTRACT_STATUSES.ATTRIBUTE2%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
930: p_attribute3 IN CS_CONTRACT_STATUSES.ATTRIBUTE3%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
931: p_attribute4 IN CS_CONTRACT_STATUSES.ATTRIBUTE4%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
932: p_attribute5 IN CS_CONTRACT_STATUSES.ATTRIBUTE5%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
933: p_attribute6 IN CS_CONTRACT_STATUSES.ATTRIBUTE6%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
934: p_attribute7 IN CS_CONTRACT_STATUSES.ATTRIBUTE7%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

Line 931: p_attribute4 IN CS_CONTRACT_STATUSES.ATTRIBUTE4%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

927: p_end_date_active IN CS_CONTRACT_STATUSES.END_DATE_ACTIVE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
928: p_attribute1 IN CS_CONTRACT_STATUSES.ATTRIBUTE1%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
929: p_attribute2 IN CS_CONTRACT_STATUSES.ATTRIBUTE2%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
930: p_attribute3 IN CS_CONTRACT_STATUSES.ATTRIBUTE3%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
931: p_attribute4 IN CS_CONTRACT_STATUSES.ATTRIBUTE4%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
932: p_attribute5 IN CS_CONTRACT_STATUSES.ATTRIBUTE5%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
933: p_attribute6 IN CS_CONTRACT_STATUSES.ATTRIBUTE6%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
934: p_attribute7 IN CS_CONTRACT_STATUSES.ATTRIBUTE7%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
935: p_attribute8 IN CS_CONTRACT_STATUSES.ATTRIBUTE8%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

Line 932: p_attribute5 IN CS_CONTRACT_STATUSES.ATTRIBUTE5%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

928: p_attribute1 IN CS_CONTRACT_STATUSES.ATTRIBUTE1%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
929: p_attribute2 IN CS_CONTRACT_STATUSES.ATTRIBUTE2%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
930: p_attribute3 IN CS_CONTRACT_STATUSES.ATTRIBUTE3%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
931: p_attribute4 IN CS_CONTRACT_STATUSES.ATTRIBUTE4%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
932: p_attribute5 IN CS_CONTRACT_STATUSES.ATTRIBUTE5%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
933: p_attribute6 IN CS_CONTRACT_STATUSES.ATTRIBUTE6%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
934: p_attribute7 IN CS_CONTRACT_STATUSES.ATTRIBUTE7%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
935: p_attribute8 IN CS_CONTRACT_STATUSES.ATTRIBUTE8%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
936: p_attribute9 IN CS_CONTRACT_STATUSES.ATTRIBUTE9%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

Line 933: p_attribute6 IN CS_CONTRACT_STATUSES.ATTRIBUTE6%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

929: p_attribute2 IN CS_CONTRACT_STATUSES.ATTRIBUTE2%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
930: p_attribute3 IN CS_CONTRACT_STATUSES.ATTRIBUTE3%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
931: p_attribute4 IN CS_CONTRACT_STATUSES.ATTRIBUTE4%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
932: p_attribute5 IN CS_CONTRACT_STATUSES.ATTRIBUTE5%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
933: p_attribute6 IN CS_CONTRACT_STATUSES.ATTRIBUTE6%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
934: p_attribute7 IN CS_CONTRACT_STATUSES.ATTRIBUTE7%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
935: p_attribute8 IN CS_CONTRACT_STATUSES.ATTRIBUTE8%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
936: p_attribute9 IN CS_CONTRACT_STATUSES.ATTRIBUTE9%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
937: p_attribute10 IN CS_CONTRACT_STATUSES.ATTRIBUTE10%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

Line 934: p_attribute7 IN CS_CONTRACT_STATUSES.ATTRIBUTE7%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

930: p_attribute3 IN CS_CONTRACT_STATUSES.ATTRIBUTE3%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
931: p_attribute4 IN CS_CONTRACT_STATUSES.ATTRIBUTE4%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
932: p_attribute5 IN CS_CONTRACT_STATUSES.ATTRIBUTE5%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
933: p_attribute6 IN CS_CONTRACT_STATUSES.ATTRIBUTE6%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
934: p_attribute7 IN CS_CONTRACT_STATUSES.ATTRIBUTE7%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
935: p_attribute8 IN CS_CONTRACT_STATUSES.ATTRIBUTE8%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
936: p_attribute9 IN CS_CONTRACT_STATUSES.ATTRIBUTE9%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
937: p_attribute10 IN CS_CONTRACT_STATUSES.ATTRIBUTE10%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
938: p_attribute11 IN CS_CONTRACT_STATUSES.ATTRIBUTE11%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

Line 935: p_attribute8 IN CS_CONTRACT_STATUSES.ATTRIBUTE8%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

931: p_attribute4 IN CS_CONTRACT_STATUSES.ATTRIBUTE4%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
932: p_attribute5 IN CS_CONTRACT_STATUSES.ATTRIBUTE5%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
933: p_attribute6 IN CS_CONTRACT_STATUSES.ATTRIBUTE6%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
934: p_attribute7 IN CS_CONTRACT_STATUSES.ATTRIBUTE7%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
935: p_attribute8 IN CS_CONTRACT_STATUSES.ATTRIBUTE8%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
936: p_attribute9 IN CS_CONTRACT_STATUSES.ATTRIBUTE9%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
937: p_attribute10 IN CS_CONTRACT_STATUSES.ATTRIBUTE10%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
938: p_attribute11 IN CS_CONTRACT_STATUSES.ATTRIBUTE11%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
939: p_attribute12 IN CS_CONTRACT_STATUSES.ATTRIBUTE12%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

Line 936: p_attribute9 IN CS_CONTRACT_STATUSES.ATTRIBUTE9%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

932: p_attribute5 IN CS_CONTRACT_STATUSES.ATTRIBUTE5%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
933: p_attribute6 IN CS_CONTRACT_STATUSES.ATTRIBUTE6%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
934: p_attribute7 IN CS_CONTRACT_STATUSES.ATTRIBUTE7%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
935: p_attribute8 IN CS_CONTRACT_STATUSES.ATTRIBUTE8%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
936: p_attribute9 IN CS_CONTRACT_STATUSES.ATTRIBUTE9%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
937: p_attribute10 IN CS_CONTRACT_STATUSES.ATTRIBUTE10%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
938: p_attribute11 IN CS_CONTRACT_STATUSES.ATTRIBUTE11%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
939: p_attribute12 IN CS_CONTRACT_STATUSES.ATTRIBUTE12%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
940: p_attribute13 IN CS_CONTRACT_STATUSES.ATTRIBUTE13%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

Line 937: p_attribute10 IN CS_CONTRACT_STATUSES.ATTRIBUTE10%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

933: p_attribute6 IN CS_CONTRACT_STATUSES.ATTRIBUTE6%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
934: p_attribute7 IN CS_CONTRACT_STATUSES.ATTRIBUTE7%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
935: p_attribute8 IN CS_CONTRACT_STATUSES.ATTRIBUTE8%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
936: p_attribute9 IN CS_CONTRACT_STATUSES.ATTRIBUTE9%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
937: p_attribute10 IN CS_CONTRACT_STATUSES.ATTRIBUTE10%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
938: p_attribute11 IN CS_CONTRACT_STATUSES.ATTRIBUTE11%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
939: p_attribute12 IN CS_CONTRACT_STATUSES.ATTRIBUTE12%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
940: p_attribute13 IN CS_CONTRACT_STATUSES.ATTRIBUTE13%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
941: p_attribute14 IN CS_CONTRACT_STATUSES.ATTRIBUTE14%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

Line 938: p_attribute11 IN CS_CONTRACT_STATUSES.ATTRIBUTE11%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

934: p_attribute7 IN CS_CONTRACT_STATUSES.ATTRIBUTE7%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
935: p_attribute8 IN CS_CONTRACT_STATUSES.ATTRIBUTE8%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
936: p_attribute9 IN CS_CONTRACT_STATUSES.ATTRIBUTE9%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
937: p_attribute10 IN CS_CONTRACT_STATUSES.ATTRIBUTE10%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
938: p_attribute11 IN CS_CONTRACT_STATUSES.ATTRIBUTE11%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
939: p_attribute12 IN CS_CONTRACT_STATUSES.ATTRIBUTE12%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
940: p_attribute13 IN CS_CONTRACT_STATUSES.ATTRIBUTE13%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
941: p_attribute14 IN CS_CONTRACT_STATUSES.ATTRIBUTE14%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
942: p_attribute15 IN CS_CONTRACT_STATUSES.ATTRIBUTE15%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

Line 939: p_attribute12 IN CS_CONTRACT_STATUSES.ATTRIBUTE12%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

935: p_attribute8 IN CS_CONTRACT_STATUSES.ATTRIBUTE8%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
936: p_attribute9 IN CS_CONTRACT_STATUSES.ATTRIBUTE9%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
937: p_attribute10 IN CS_CONTRACT_STATUSES.ATTRIBUTE10%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
938: p_attribute11 IN CS_CONTRACT_STATUSES.ATTRIBUTE11%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
939: p_attribute12 IN CS_CONTRACT_STATUSES.ATTRIBUTE12%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
940: p_attribute13 IN CS_CONTRACT_STATUSES.ATTRIBUTE13%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
941: p_attribute14 IN CS_CONTRACT_STATUSES.ATTRIBUTE14%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
942: p_attribute15 IN CS_CONTRACT_STATUSES.ATTRIBUTE15%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
943: p_context IN CS_CONTRACT_STATUSES.CONTEXT%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

Line 940: p_attribute13 IN CS_CONTRACT_STATUSES.ATTRIBUTE13%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

936: p_attribute9 IN CS_CONTRACT_STATUSES.ATTRIBUTE9%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
937: p_attribute10 IN CS_CONTRACT_STATUSES.ATTRIBUTE10%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
938: p_attribute11 IN CS_CONTRACT_STATUSES.ATTRIBUTE11%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
939: p_attribute12 IN CS_CONTRACT_STATUSES.ATTRIBUTE12%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
940: p_attribute13 IN CS_CONTRACT_STATUSES.ATTRIBUTE13%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
941: p_attribute14 IN CS_CONTRACT_STATUSES.ATTRIBUTE14%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
942: p_attribute15 IN CS_CONTRACT_STATUSES.ATTRIBUTE15%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
943: p_context IN CS_CONTRACT_STATUSES.CONTEXT%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
944: p_object_version_number IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,

Line 941: p_attribute14 IN CS_CONTRACT_STATUSES.ATTRIBUTE14%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

937: p_attribute10 IN CS_CONTRACT_STATUSES.ATTRIBUTE10%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
938: p_attribute11 IN CS_CONTRACT_STATUSES.ATTRIBUTE11%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
939: p_attribute12 IN CS_CONTRACT_STATUSES.ATTRIBUTE12%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
940: p_attribute13 IN CS_CONTRACT_STATUSES.ATTRIBUTE13%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
941: p_attribute14 IN CS_CONTRACT_STATUSES.ATTRIBUTE14%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
942: p_attribute15 IN CS_CONTRACT_STATUSES.ATTRIBUTE15%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
943: p_context IN CS_CONTRACT_STATUSES.CONTEXT%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
944: p_object_version_number IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
945: x_object_version_number OUT NUMBER) IS

Line 942: p_attribute15 IN CS_CONTRACT_STATUSES.ATTRIBUTE15%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

938: p_attribute11 IN CS_CONTRACT_STATUSES.ATTRIBUTE11%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
939: p_attribute12 IN CS_CONTRACT_STATUSES.ATTRIBUTE12%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
940: p_attribute13 IN CS_CONTRACT_STATUSES.ATTRIBUTE13%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
941: p_attribute14 IN CS_CONTRACT_STATUSES.ATTRIBUTE14%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
942: p_attribute15 IN CS_CONTRACT_STATUSES.ATTRIBUTE15%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
943: p_context IN CS_CONTRACT_STATUSES.CONTEXT%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
944: p_object_version_number IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
945: x_object_version_number OUT NUMBER) IS
946: l_api_name CONSTANT VARCHAR2(30) := 'update_row';

Line 943: p_context IN CS_CONTRACT_STATUSES.CONTEXT%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

939: p_attribute12 IN CS_CONTRACT_STATUSES.ATTRIBUTE12%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
940: p_attribute13 IN CS_CONTRACT_STATUSES.ATTRIBUTE13%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
941: p_attribute14 IN CS_CONTRACT_STATUSES.ATTRIBUTE14%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
942: p_attribute15 IN CS_CONTRACT_STATUSES.ATTRIBUTE15%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
943: p_context IN CS_CONTRACT_STATUSES.CONTEXT%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
944: p_object_version_number IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
945: x_object_version_number OUT NUMBER) IS
946: l_api_name CONSTANT VARCHAR2(30) := 'update_row';
947: l_api_version CONSTANT NUMBER := 1;

Line 944: p_object_version_number IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,

940: p_attribute13 IN CS_CONTRACT_STATUSES.ATTRIBUTE13%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
941: p_attribute14 IN CS_CONTRACT_STATUSES.ATTRIBUTE14%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
942: p_attribute15 IN CS_CONTRACT_STATUSES.ATTRIBUTE15%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
943: p_context IN CS_CONTRACT_STATUSES.CONTEXT%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
944: p_object_version_number IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
945: x_object_version_number OUT NUMBER) IS
946: l_api_name CONSTANT VARCHAR2(30) := 'update_row';
947: l_api_version CONSTANT NUMBER := 1;
948: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;

Line 951: l_return_status := TAPI_DEV_KIT.START_ACTIVITY(l_api_name,

947: l_api_version CONSTANT NUMBER := 1;
948: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
949: l_contractstats_rec ContractStats_Val_Rec_Type;
950: BEGIN
951: l_return_status := TAPI_DEV_KIT.START_ACTIVITY(l_api_name,
952: G_PKG_NAME,
953: l_api_version,
954: p_api_version,
955: p_init_msg_list,

Line 1008: TAPI_DEV_KIT.END_ACTIVITY(p_commit, x_msg_count, x_msg_data);

1004: x_msg_data,
1005: l_contractstats_rec,
1006: x_object_version_number
1007: );
1008: TAPI_DEV_KIT.END_ACTIVITY(p_commit, x_msg_count, x_msg_data);
1009: EXCEPTION
1010: WHEN FND_API.G_EXC_ERROR THEN
1011: x_return_status := TAPI_DEV_KIT.HANDLE_EXCEPTIONS
1012: (

Line 1011: x_return_status := TAPI_DEV_KIT.HANDLE_EXCEPTIONS

1007: );
1008: TAPI_DEV_KIT.END_ACTIVITY(p_commit, x_msg_count, x_msg_data);
1009: EXCEPTION
1010: WHEN FND_API.G_EXC_ERROR THEN
1011: x_return_status := TAPI_DEV_KIT.HANDLE_EXCEPTIONS
1012: (
1013: l_api_name,
1014: G_PKG_NAME,
1015: 'FND_API.G_RET_STS_ERROR',

Line 1022: x_return_status :=TAPI_DEV_KIT.HANDLE_EXCEPTIONS

1018: '_Pvt'
1019: );
1020: APP_EXCEPTION.RAISE_EXCEPTION;
1021: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1022: x_return_status :=TAPI_DEV_KIT.HANDLE_EXCEPTIONS
1023: (
1024: l_api_name,
1025: G_PKG_NAME,
1026: 'FND_API.G_RET_STS_UNEXP_ERROR',

Line 1032: WHEN TAPI_DEV_KIT.G_EXC_DUP_VAL_ON_INDEX THEN

1028: x_msg_data,
1029: '_Pvt'
1030: );
1031: APP_EXCEPTION.RAISE_EXCEPTION;
1032: WHEN TAPI_DEV_KIT.G_EXC_DUP_VAL_ON_INDEX THEN
1033: x_return_status :=TAPI_DEV_KIT.HANDLE_EXCEPTIONS
1034: (
1035: l_api_name,
1036: G_PKG_NAME,

Line 1033: x_return_status :=TAPI_DEV_KIT.HANDLE_EXCEPTIONS

1029: '_Pvt'
1030: );
1031: APP_EXCEPTION.RAISE_EXCEPTION;
1032: WHEN TAPI_DEV_KIT.G_EXC_DUP_VAL_ON_INDEX THEN
1033: x_return_status :=TAPI_DEV_KIT.HANDLE_EXCEPTIONS
1034: (
1035: l_api_name,
1036: G_PKG_NAME,
1037: 'TAPI_DEV_KIT.G_RET_STS_DUP_VAL_ON_INDEX',

Line 1037: 'TAPI_DEV_KIT.G_RET_STS_DUP_VAL_ON_INDEX',

1033: x_return_status :=TAPI_DEV_KIT.HANDLE_EXCEPTIONS
1034: (
1035: l_api_name,
1036: G_PKG_NAME,
1037: 'TAPI_DEV_KIT.G_RET_STS_DUP_VAL_ON_INDEX',
1038: x_msg_count,
1039: x_msg_data,
1040: '_Pvt'
1041: );

Line 1047: p_init_msg_list IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,

1043: END update_row;
1044: Procedure delete_row
1045: (
1046: p_api_version IN NUMBER,
1047: p_init_msg_list IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
1048: p_validation_level IN NUMBER,
1049: p_commit IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
1050: x_return_status OUT VARCHAR2,
1051: x_msg_count OUT NUMBER,

Line 1049: p_commit IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,

1045: (
1046: p_api_version IN NUMBER,
1047: p_init_msg_list IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
1048: p_validation_level IN NUMBER,
1049: p_commit IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
1050: x_return_status OUT VARCHAR2,
1051: x_msg_count OUT NUMBER,
1052: x_msg_data OUT VARCHAR2,
1053: p_contract_status_id IN NUMBER) IS

Line 1058: l_return_status := TAPI_DEV_KIT.START_ACTIVITY(l_api_name,

1054: l_api_name CONSTANT VARCHAR2(30) := 'delete_row';
1055: l_api_version CONSTANT NUMBER := 1;
1056: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
1057: BEGIN
1058: l_return_status := TAPI_DEV_KIT.START_ACTIVITY(l_api_name,
1059: G_PKG_NAME,
1060: l_api_version,
1061: p_api_version,
1062: p_init_msg_list,

Line 1074: TAPI_DEV_KIT.END_ACTIVITY(p_commit, x_msg_count, x_msg_data);

1070: DELETE FROM CS_CONTRACT_STATUSES
1071: WHERE
1072: CONTRACT_STATUS_ID = p_contract_status_id
1073: ;
1074: TAPI_DEV_KIT.END_ACTIVITY(p_commit, x_msg_count, x_msg_data);
1075: EXCEPTION
1076: WHEN FND_API.G_EXC_ERROR THEN
1077: x_return_status := TAPI_DEV_KIT.HANDLE_EXCEPTIONS
1078: (

Line 1077: x_return_status := TAPI_DEV_KIT.HANDLE_EXCEPTIONS

1073: ;
1074: TAPI_DEV_KIT.END_ACTIVITY(p_commit, x_msg_count, x_msg_data);
1075: EXCEPTION
1076: WHEN FND_API.G_EXC_ERROR THEN
1077: x_return_status := TAPI_DEV_KIT.HANDLE_EXCEPTIONS
1078: (
1079: l_api_name,
1080: G_PKG_NAME,
1081: 'FND_API.G_RET_STS_ERROR',

Line 1088: x_return_status :=TAPI_DEV_KIT.HANDLE_EXCEPTIONS

1084: '_Pvt'
1085: );
1086: APP_EXCEPTION.RAISE_EXCEPTION;
1087: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1088: x_return_status :=TAPI_DEV_KIT.HANDLE_EXCEPTIONS
1089: (
1090: l_api_name,
1091: G_PKG_NAME,
1092: 'FND_API.G_RET_STS_UNEXP_ERROR',

Line 1098: WHEN TAPI_DEV_KIT.G_EXC_DUP_VAL_ON_INDEX THEN

1094: x_msg_data,
1095: '_Pvt'
1096: );
1097: APP_EXCEPTION.RAISE_EXCEPTION;
1098: WHEN TAPI_DEV_KIT.G_EXC_DUP_VAL_ON_INDEX THEN
1099: x_return_status :=TAPI_DEV_KIT.HANDLE_EXCEPTIONS
1100: (
1101: l_api_name,
1102: G_PKG_NAME,

Line 1099: x_return_status :=TAPI_DEV_KIT.HANDLE_EXCEPTIONS

1095: '_Pvt'
1096: );
1097: APP_EXCEPTION.RAISE_EXCEPTION;
1098: WHEN TAPI_DEV_KIT.G_EXC_DUP_VAL_ON_INDEX THEN
1099: x_return_status :=TAPI_DEV_KIT.HANDLE_EXCEPTIONS
1100: (
1101: l_api_name,
1102: G_PKG_NAME,
1103: 'TAPI_DEV_KIT.G_RET_STS_DUP_VAL_ON_INDEX',

Line 1103: 'TAPI_DEV_KIT.G_RET_STS_DUP_VAL_ON_INDEX',

1099: x_return_status :=TAPI_DEV_KIT.HANDLE_EXCEPTIONS
1100: (
1101: l_api_name,
1102: G_PKG_NAME,
1103: 'TAPI_DEV_KIT.G_RET_STS_DUP_VAL_ON_INDEX',
1104: x_msg_count,
1105: x_msg_data,
1106: '_Pvt'
1107: );

Line 1113: p_init_msg_list IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,

1109: END delete_row;
1110: PROCEDURE validate_row
1111: (
1112: p_api_version IN NUMBER,
1113: p_init_msg_list IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
1114: p_validation_level IN NUMBER,
1115: p_commit IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
1116: x_return_status OUT VARCHAR2,
1117: x_msg_count OUT NUMBER,

Line 1115: p_commit IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,

1111: (
1112: p_api_version IN NUMBER,
1113: p_init_msg_list IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
1114: p_validation_level IN NUMBER,
1115: p_commit IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
1116: x_return_status OUT VARCHAR2,
1117: x_msg_count OUT NUMBER,
1118: x_msg_data OUT VARCHAR2,
1119: p_contractstats_val_rec IN ContractStats_Val_Rec_Type := G_MISS_CONTRACTSTATS_VAL_REC) IS

Line 1126: l_return_status := TAPI_DEV_KIT.START_ACTIVITY(l_api_name,

1122: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
1123: l_contractstats_rec ContractStats_Rec_Type;
1124: l_def_contractstats_rec ContractStats_Rec_Type;
1125: BEGIN
1126: l_return_status := TAPI_DEV_KIT.START_ACTIVITY(l_api_name,
1127: G_PKG_NAME,
1128: l_api_version,
1129: p_api_version,
1130: p_init_msg_list,

Line 1160: TAPI_DEV_KIT.END_ACTIVITY(p_commit, x_msg_count, x_msg_data);

1156: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
1157: RAISE FND_API.G_EXC_ERROR;
1158: END IF;
1159: END IF;
1160: TAPI_DEV_KIT.END_ACTIVITY(p_commit, x_msg_count, x_msg_data);
1161: EXCEPTION
1162: WHEN FND_API.G_EXC_ERROR THEN
1163: x_return_status := TAPI_DEV_KIT.HANDLE_EXCEPTIONS
1164: (

Line 1163: x_return_status := TAPI_DEV_KIT.HANDLE_EXCEPTIONS

1159: END IF;
1160: TAPI_DEV_KIT.END_ACTIVITY(p_commit, x_msg_count, x_msg_data);
1161: EXCEPTION
1162: WHEN FND_API.G_EXC_ERROR THEN
1163: x_return_status := TAPI_DEV_KIT.HANDLE_EXCEPTIONS
1164: (
1165: l_api_name,
1166: G_PKG_NAME,
1167: 'FND_API.G_RET_STS_ERROR',

Line 1174: x_return_status :=TAPI_DEV_KIT.HANDLE_EXCEPTIONS

1170: '_Pvt'
1171: );
1172: APP_EXCEPTION.RAISE_EXCEPTION;
1173: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1174: x_return_status :=TAPI_DEV_KIT.HANDLE_EXCEPTIONS
1175: (
1176: l_api_name,
1177: G_PKG_NAME,
1178: 'FND_API.G_RET_STS_UNEXP_ERROR',

Line 1184: WHEN TAPI_DEV_KIT.G_EXC_DUP_VAL_ON_INDEX THEN

1180: x_msg_data,
1181: '_Pvt'
1182: );
1183: APP_EXCEPTION.RAISE_EXCEPTION;
1184: WHEN TAPI_DEV_KIT.G_EXC_DUP_VAL_ON_INDEX THEN
1185: x_return_status :=TAPI_DEV_KIT.HANDLE_EXCEPTIONS
1186: (
1187: l_api_name,
1188: G_PKG_NAME,

Line 1185: x_return_status :=TAPI_DEV_KIT.HANDLE_EXCEPTIONS

1181: '_Pvt'
1182: );
1183: APP_EXCEPTION.RAISE_EXCEPTION;
1184: WHEN TAPI_DEV_KIT.G_EXC_DUP_VAL_ON_INDEX THEN
1185: x_return_status :=TAPI_DEV_KIT.HANDLE_EXCEPTIONS
1186: (
1187: l_api_name,
1188: G_PKG_NAME,
1189: 'TAPI_DEV_KIT.G_RET_STS_DUP_VAL_ON_INDEX',

Line 1189: 'TAPI_DEV_KIT.G_RET_STS_DUP_VAL_ON_INDEX',

1185: x_return_status :=TAPI_DEV_KIT.HANDLE_EXCEPTIONS
1186: (
1187: l_api_name,
1188: G_PKG_NAME,
1189: 'TAPI_DEV_KIT.G_RET_STS_DUP_VAL_ON_INDEX',
1190: x_msg_count,
1191: x_msg_data,
1192: '_Pvt'
1193: );

Line 1199: p_init_msg_list IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,

1195: END validate_row;
1196: PROCEDURE validate_row
1197: (
1198: p_api_version IN NUMBER,
1199: p_init_msg_list IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
1200: p_validation_level IN NUMBER,
1201: p_commit IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
1202: x_return_status OUT VARCHAR2,
1203: x_msg_count OUT NUMBER,

Line 1201: p_commit IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,

1197: (
1198: p_api_version IN NUMBER,
1199: p_init_msg_list IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
1200: p_validation_level IN NUMBER,
1201: p_commit IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
1202: x_return_status OUT VARCHAR2,
1203: x_msg_count OUT NUMBER,
1204: x_msg_data OUT VARCHAR2,
1205: p_contract_status_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,

Line 1205: p_contract_status_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,

1201: p_commit IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
1202: x_return_status OUT VARCHAR2,
1203: x_msg_count OUT NUMBER,
1204: x_msg_data OUT VARCHAR2,
1205: p_contract_status_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1206: p_name IN CS_CONTRACT_STATUSES.NAME%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1207: p_description IN CS_CONTRACT_STATUSES.DESCRIPTION%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1208: p_validate_contract IN CS_CONTRACT_STATUSES.VALIDATE_CONTRACT%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1209: p_status_level IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,

Line 1206: p_name IN CS_CONTRACT_STATUSES.NAME%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

1202: x_return_status OUT VARCHAR2,
1203: x_msg_count OUT NUMBER,
1204: x_msg_data OUT VARCHAR2,
1205: p_contract_status_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1206: p_name IN CS_CONTRACT_STATUSES.NAME%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1207: p_description IN CS_CONTRACT_STATUSES.DESCRIPTION%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1208: p_validate_contract IN CS_CONTRACT_STATUSES.VALIDATE_CONTRACT%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1209: p_status_level IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1210: p_eligible_for_invoicing IN CS_CONTRACT_STATUSES.ELIGIBLE_FOR_INVOICING%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

Line 1207: p_description IN CS_CONTRACT_STATUSES.DESCRIPTION%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

1203: x_msg_count OUT NUMBER,
1204: x_msg_data OUT VARCHAR2,
1205: p_contract_status_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1206: p_name IN CS_CONTRACT_STATUSES.NAME%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1207: p_description IN CS_CONTRACT_STATUSES.DESCRIPTION%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1208: p_validate_contract IN CS_CONTRACT_STATUSES.VALIDATE_CONTRACT%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1209: p_status_level IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1210: p_eligible_for_invoicing IN CS_CONTRACT_STATUSES.ELIGIBLE_FOR_INVOICING%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1211: p_update_allowed IN CS_CONTRACT_STATUSES.UPDATE_ALLOWED%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

Line 1208: p_validate_contract IN CS_CONTRACT_STATUSES.VALIDATE_CONTRACT%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

1204: x_msg_data OUT VARCHAR2,
1205: p_contract_status_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1206: p_name IN CS_CONTRACT_STATUSES.NAME%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1207: p_description IN CS_CONTRACT_STATUSES.DESCRIPTION%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1208: p_validate_contract IN CS_CONTRACT_STATUSES.VALIDATE_CONTRACT%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1209: p_status_level IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1210: p_eligible_for_invoicing IN CS_CONTRACT_STATUSES.ELIGIBLE_FOR_INVOICING%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1211: p_update_allowed IN CS_CONTRACT_STATUSES.UPDATE_ALLOWED%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1212: p_eligible_for_entitlements IN CS_CONTRACT_STATUSES.ELIGIBLE_FOR_ENTITLEMENTS%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

Line 1209: p_status_level IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,

1205: p_contract_status_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1206: p_name IN CS_CONTRACT_STATUSES.NAME%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1207: p_description IN CS_CONTRACT_STATUSES.DESCRIPTION%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1208: p_validate_contract IN CS_CONTRACT_STATUSES.VALIDATE_CONTRACT%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1209: p_status_level IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1210: p_eligible_for_invoicing IN CS_CONTRACT_STATUSES.ELIGIBLE_FOR_INVOICING%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1211: p_update_allowed IN CS_CONTRACT_STATUSES.UPDATE_ALLOWED%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1212: p_eligible_for_entitlements IN CS_CONTRACT_STATUSES.ELIGIBLE_FOR_ENTITLEMENTS%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1213: p_terminated_flag IN CS_CONTRACT_STATUSES.TERMINATED_FLAG%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

Line 1210: p_eligible_for_invoicing IN CS_CONTRACT_STATUSES.ELIGIBLE_FOR_INVOICING%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

1206: p_name IN CS_CONTRACT_STATUSES.NAME%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1207: p_description IN CS_CONTRACT_STATUSES.DESCRIPTION%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1208: p_validate_contract IN CS_CONTRACT_STATUSES.VALIDATE_CONTRACT%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1209: p_status_level IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1210: p_eligible_for_invoicing IN CS_CONTRACT_STATUSES.ELIGIBLE_FOR_INVOICING%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1211: p_update_allowed IN CS_CONTRACT_STATUSES.UPDATE_ALLOWED%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1212: p_eligible_for_entitlements IN CS_CONTRACT_STATUSES.ELIGIBLE_FOR_ENTITLEMENTS%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1213: p_terminated_flag IN CS_CONTRACT_STATUSES.TERMINATED_FLAG%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1214: p_delete_allowed IN CS_CONTRACT_STATUSES.DELETE_ALLOWED%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

Line 1211: p_update_allowed IN CS_CONTRACT_STATUSES.UPDATE_ALLOWED%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

1207: p_description IN CS_CONTRACT_STATUSES.DESCRIPTION%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1208: p_validate_contract IN CS_CONTRACT_STATUSES.VALIDATE_CONTRACT%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1209: p_status_level IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1210: p_eligible_for_invoicing IN CS_CONTRACT_STATUSES.ELIGIBLE_FOR_INVOICING%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1211: p_update_allowed IN CS_CONTRACT_STATUSES.UPDATE_ALLOWED%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1212: p_eligible_for_entitlements IN CS_CONTRACT_STATUSES.ELIGIBLE_FOR_ENTITLEMENTS%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1213: p_terminated_flag IN CS_CONTRACT_STATUSES.TERMINATED_FLAG%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1214: p_delete_allowed IN CS_CONTRACT_STATUSES.DELETE_ALLOWED%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1215: p_last_update_date IN CS_CONTRACT_STATUSES.LAST_UPDATE_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,

Line 1212: p_eligible_for_entitlements IN CS_CONTRACT_STATUSES.ELIGIBLE_FOR_ENTITLEMENTS%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

1208: p_validate_contract IN CS_CONTRACT_STATUSES.VALIDATE_CONTRACT%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1209: p_status_level IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1210: p_eligible_for_invoicing IN CS_CONTRACT_STATUSES.ELIGIBLE_FOR_INVOICING%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1211: p_update_allowed IN CS_CONTRACT_STATUSES.UPDATE_ALLOWED%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1212: p_eligible_for_entitlements IN CS_CONTRACT_STATUSES.ELIGIBLE_FOR_ENTITLEMENTS%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1213: p_terminated_flag IN CS_CONTRACT_STATUSES.TERMINATED_FLAG%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1214: p_delete_allowed IN CS_CONTRACT_STATUSES.DELETE_ALLOWED%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1215: p_last_update_date IN CS_CONTRACT_STATUSES.LAST_UPDATE_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1216: p_last_updated_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,

Line 1213: p_terminated_flag IN CS_CONTRACT_STATUSES.TERMINATED_FLAG%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

1209: p_status_level IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1210: p_eligible_for_invoicing IN CS_CONTRACT_STATUSES.ELIGIBLE_FOR_INVOICING%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1211: p_update_allowed IN CS_CONTRACT_STATUSES.UPDATE_ALLOWED%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1212: p_eligible_for_entitlements IN CS_CONTRACT_STATUSES.ELIGIBLE_FOR_ENTITLEMENTS%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1213: p_terminated_flag IN CS_CONTRACT_STATUSES.TERMINATED_FLAG%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1214: p_delete_allowed IN CS_CONTRACT_STATUSES.DELETE_ALLOWED%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1215: p_last_update_date IN CS_CONTRACT_STATUSES.LAST_UPDATE_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1216: p_last_updated_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1217: p_creation_date IN CS_CONTRACT_STATUSES.CREATION_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,

Line 1214: p_delete_allowed IN CS_CONTRACT_STATUSES.DELETE_ALLOWED%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

1210: p_eligible_for_invoicing IN CS_CONTRACT_STATUSES.ELIGIBLE_FOR_INVOICING%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1211: p_update_allowed IN CS_CONTRACT_STATUSES.UPDATE_ALLOWED%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1212: p_eligible_for_entitlements IN CS_CONTRACT_STATUSES.ELIGIBLE_FOR_ENTITLEMENTS%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1213: p_terminated_flag IN CS_CONTRACT_STATUSES.TERMINATED_FLAG%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1214: p_delete_allowed IN CS_CONTRACT_STATUSES.DELETE_ALLOWED%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1215: p_last_update_date IN CS_CONTRACT_STATUSES.LAST_UPDATE_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1216: p_last_updated_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1217: p_creation_date IN CS_CONTRACT_STATUSES.CREATION_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1218: p_created_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,

Line 1215: p_last_update_date IN CS_CONTRACT_STATUSES.LAST_UPDATE_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,

1211: p_update_allowed IN CS_CONTRACT_STATUSES.UPDATE_ALLOWED%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1212: p_eligible_for_entitlements IN CS_CONTRACT_STATUSES.ELIGIBLE_FOR_ENTITLEMENTS%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1213: p_terminated_flag IN CS_CONTRACT_STATUSES.TERMINATED_FLAG%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1214: p_delete_allowed IN CS_CONTRACT_STATUSES.DELETE_ALLOWED%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1215: p_last_update_date IN CS_CONTRACT_STATUSES.LAST_UPDATE_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1216: p_last_updated_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1217: p_creation_date IN CS_CONTRACT_STATUSES.CREATION_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1218: p_created_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1219: p_last_update_login IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,

Line 1216: p_last_updated_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,

1212: p_eligible_for_entitlements IN CS_CONTRACT_STATUSES.ELIGIBLE_FOR_ENTITLEMENTS%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1213: p_terminated_flag IN CS_CONTRACT_STATUSES.TERMINATED_FLAG%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1214: p_delete_allowed IN CS_CONTRACT_STATUSES.DELETE_ALLOWED%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1215: p_last_update_date IN CS_CONTRACT_STATUSES.LAST_UPDATE_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1216: p_last_updated_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1217: p_creation_date IN CS_CONTRACT_STATUSES.CREATION_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1218: p_created_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1219: p_last_update_login IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1220: p_start_date_active IN CS_CONTRACT_STATUSES.START_DATE_ACTIVE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,

Line 1217: p_creation_date IN CS_CONTRACT_STATUSES.CREATION_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,

1213: p_terminated_flag IN CS_CONTRACT_STATUSES.TERMINATED_FLAG%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1214: p_delete_allowed IN CS_CONTRACT_STATUSES.DELETE_ALLOWED%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1215: p_last_update_date IN CS_CONTRACT_STATUSES.LAST_UPDATE_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1216: p_last_updated_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1217: p_creation_date IN CS_CONTRACT_STATUSES.CREATION_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1218: p_created_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1219: p_last_update_login IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1220: p_start_date_active IN CS_CONTRACT_STATUSES.START_DATE_ACTIVE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1221: p_end_date_active IN CS_CONTRACT_STATUSES.END_DATE_ACTIVE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,

Line 1218: p_created_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,

1214: p_delete_allowed IN CS_CONTRACT_STATUSES.DELETE_ALLOWED%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1215: p_last_update_date IN CS_CONTRACT_STATUSES.LAST_UPDATE_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1216: p_last_updated_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1217: p_creation_date IN CS_CONTRACT_STATUSES.CREATION_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1218: p_created_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1219: p_last_update_login IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1220: p_start_date_active IN CS_CONTRACT_STATUSES.START_DATE_ACTIVE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1221: p_end_date_active IN CS_CONTRACT_STATUSES.END_DATE_ACTIVE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1222: p_attribute1 IN CS_CONTRACT_STATUSES.ATTRIBUTE1%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

Line 1219: p_last_update_login IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,

1215: p_last_update_date IN CS_CONTRACT_STATUSES.LAST_UPDATE_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1216: p_last_updated_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1217: p_creation_date IN CS_CONTRACT_STATUSES.CREATION_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1218: p_created_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1219: p_last_update_login IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1220: p_start_date_active IN CS_CONTRACT_STATUSES.START_DATE_ACTIVE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1221: p_end_date_active IN CS_CONTRACT_STATUSES.END_DATE_ACTIVE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1222: p_attribute1 IN CS_CONTRACT_STATUSES.ATTRIBUTE1%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1223: p_attribute2 IN CS_CONTRACT_STATUSES.ATTRIBUTE2%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

Line 1220: p_start_date_active IN CS_CONTRACT_STATUSES.START_DATE_ACTIVE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,

1216: p_last_updated_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1217: p_creation_date IN CS_CONTRACT_STATUSES.CREATION_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1218: p_created_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1219: p_last_update_login IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1220: p_start_date_active IN CS_CONTRACT_STATUSES.START_DATE_ACTIVE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1221: p_end_date_active IN CS_CONTRACT_STATUSES.END_DATE_ACTIVE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1222: p_attribute1 IN CS_CONTRACT_STATUSES.ATTRIBUTE1%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1223: p_attribute2 IN CS_CONTRACT_STATUSES.ATTRIBUTE2%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1224: p_attribute3 IN CS_CONTRACT_STATUSES.ATTRIBUTE3%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

Line 1221: p_end_date_active IN CS_CONTRACT_STATUSES.END_DATE_ACTIVE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,

1217: p_creation_date IN CS_CONTRACT_STATUSES.CREATION_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1218: p_created_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1219: p_last_update_login IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1220: p_start_date_active IN CS_CONTRACT_STATUSES.START_DATE_ACTIVE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1221: p_end_date_active IN CS_CONTRACT_STATUSES.END_DATE_ACTIVE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1222: p_attribute1 IN CS_CONTRACT_STATUSES.ATTRIBUTE1%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1223: p_attribute2 IN CS_CONTRACT_STATUSES.ATTRIBUTE2%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1224: p_attribute3 IN CS_CONTRACT_STATUSES.ATTRIBUTE3%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1225: p_attribute4 IN CS_CONTRACT_STATUSES.ATTRIBUTE4%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

Line 1222: p_attribute1 IN CS_CONTRACT_STATUSES.ATTRIBUTE1%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

1218: p_created_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1219: p_last_update_login IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1220: p_start_date_active IN CS_CONTRACT_STATUSES.START_DATE_ACTIVE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1221: p_end_date_active IN CS_CONTRACT_STATUSES.END_DATE_ACTIVE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1222: p_attribute1 IN CS_CONTRACT_STATUSES.ATTRIBUTE1%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1223: p_attribute2 IN CS_CONTRACT_STATUSES.ATTRIBUTE2%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1224: p_attribute3 IN CS_CONTRACT_STATUSES.ATTRIBUTE3%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1225: p_attribute4 IN CS_CONTRACT_STATUSES.ATTRIBUTE4%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1226: p_attribute5 IN CS_CONTRACT_STATUSES.ATTRIBUTE5%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

Line 1223: p_attribute2 IN CS_CONTRACT_STATUSES.ATTRIBUTE2%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

1219: p_last_update_login IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1220: p_start_date_active IN CS_CONTRACT_STATUSES.START_DATE_ACTIVE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1221: p_end_date_active IN CS_CONTRACT_STATUSES.END_DATE_ACTIVE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1222: p_attribute1 IN CS_CONTRACT_STATUSES.ATTRIBUTE1%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1223: p_attribute2 IN CS_CONTRACT_STATUSES.ATTRIBUTE2%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1224: p_attribute3 IN CS_CONTRACT_STATUSES.ATTRIBUTE3%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1225: p_attribute4 IN CS_CONTRACT_STATUSES.ATTRIBUTE4%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1226: p_attribute5 IN CS_CONTRACT_STATUSES.ATTRIBUTE5%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1227: p_attribute6 IN CS_CONTRACT_STATUSES.ATTRIBUTE6%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

Line 1224: p_attribute3 IN CS_CONTRACT_STATUSES.ATTRIBUTE3%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

1220: p_start_date_active IN CS_CONTRACT_STATUSES.START_DATE_ACTIVE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1221: p_end_date_active IN CS_CONTRACT_STATUSES.END_DATE_ACTIVE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1222: p_attribute1 IN CS_CONTRACT_STATUSES.ATTRIBUTE1%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1223: p_attribute2 IN CS_CONTRACT_STATUSES.ATTRIBUTE2%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1224: p_attribute3 IN CS_CONTRACT_STATUSES.ATTRIBUTE3%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1225: p_attribute4 IN CS_CONTRACT_STATUSES.ATTRIBUTE4%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1226: p_attribute5 IN CS_CONTRACT_STATUSES.ATTRIBUTE5%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1227: p_attribute6 IN CS_CONTRACT_STATUSES.ATTRIBUTE6%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1228: p_attribute7 IN CS_CONTRACT_STATUSES.ATTRIBUTE7%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

Line 1225: p_attribute4 IN CS_CONTRACT_STATUSES.ATTRIBUTE4%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

1221: p_end_date_active IN CS_CONTRACT_STATUSES.END_DATE_ACTIVE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1222: p_attribute1 IN CS_CONTRACT_STATUSES.ATTRIBUTE1%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1223: p_attribute2 IN CS_CONTRACT_STATUSES.ATTRIBUTE2%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1224: p_attribute3 IN CS_CONTRACT_STATUSES.ATTRIBUTE3%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1225: p_attribute4 IN CS_CONTRACT_STATUSES.ATTRIBUTE4%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1226: p_attribute5 IN CS_CONTRACT_STATUSES.ATTRIBUTE5%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1227: p_attribute6 IN CS_CONTRACT_STATUSES.ATTRIBUTE6%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1228: p_attribute7 IN CS_CONTRACT_STATUSES.ATTRIBUTE7%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1229: p_attribute8 IN CS_CONTRACT_STATUSES.ATTRIBUTE8%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

Line 1226: p_attribute5 IN CS_CONTRACT_STATUSES.ATTRIBUTE5%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

1222: p_attribute1 IN CS_CONTRACT_STATUSES.ATTRIBUTE1%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1223: p_attribute2 IN CS_CONTRACT_STATUSES.ATTRIBUTE2%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1224: p_attribute3 IN CS_CONTRACT_STATUSES.ATTRIBUTE3%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1225: p_attribute4 IN CS_CONTRACT_STATUSES.ATTRIBUTE4%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1226: p_attribute5 IN CS_CONTRACT_STATUSES.ATTRIBUTE5%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1227: p_attribute6 IN CS_CONTRACT_STATUSES.ATTRIBUTE6%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1228: p_attribute7 IN CS_CONTRACT_STATUSES.ATTRIBUTE7%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1229: p_attribute8 IN CS_CONTRACT_STATUSES.ATTRIBUTE8%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1230: p_attribute9 IN CS_CONTRACT_STATUSES.ATTRIBUTE9%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

Line 1227: p_attribute6 IN CS_CONTRACT_STATUSES.ATTRIBUTE6%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

1223: p_attribute2 IN CS_CONTRACT_STATUSES.ATTRIBUTE2%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1224: p_attribute3 IN CS_CONTRACT_STATUSES.ATTRIBUTE3%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1225: p_attribute4 IN CS_CONTRACT_STATUSES.ATTRIBUTE4%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1226: p_attribute5 IN CS_CONTRACT_STATUSES.ATTRIBUTE5%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1227: p_attribute6 IN CS_CONTRACT_STATUSES.ATTRIBUTE6%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1228: p_attribute7 IN CS_CONTRACT_STATUSES.ATTRIBUTE7%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1229: p_attribute8 IN CS_CONTRACT_STATUSES.ATTRIBUTE8%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1230: p_attribute9 IN CS_CONTRACT_STATUSES.ATTRIBUTE9%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1231: p_attribute10 IN CS_CONTRACT_STATUSES.ATTRIBUTE10%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

Line 1228: p_attribute7 IN CS_CONTRACT_STATUSES.ATTRIBUTE7%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

1224: p_attribute3 IN CS_CONTRACT_STATUSES.ATTRIBUTE3%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1225: p_attribute4 IN CS_CONTRACT_STATUSES.ATTRIBUTE4%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1226: p_attribute5 IN CS_CONTRACT_STATUSES.ATTRIBUTE5%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1227: p_attribute6 IN CS_CONTRACT_STATUSES.ATTRIBUTE6%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1228: p_attribute7 IN CS_CONTRACT_STATUSES.ATTRIBUTE7%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1229: p_attribute8 IN CS_CONTRACT_STATUSES.ATTRIBUTE8%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1230: p_attribute9 IN CS_CONTRACT_STATUSES.ATTRIBUTE9%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1231: p_attribute10 IN CS_CONTRACT_STATUSES.ATTRIBUTE10%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1232: p_attribute11 IN CS_CONTRACT_STATUSES.ATTRIBUTE11%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

Line 1229: p_attribute8 IN CS_CONTRACT_STATUSES.ATTRIBUTE8%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

1225: p_attribute4 IN CS_CONTRACT_STATUSES.ATTRIBUTE4%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1226: p_attribute5 IN CS_CONTRACT_STATUSES.ATTRIBUTE5%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1227: p_attribute6 IN CS_CONTRACT_STATUSES.ATTRIBUTE6%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1228: p_attribute7 IN CS_CONTRACT_STATUSES.ATTRIBUTE7%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1229: p_attribute8 IN CS_CONTRACT_STATUSES.ATTRIBUTE8%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1230: p_attribute9 IN CS_CONTRACT_STATUSES.ATTRIBUTE9%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1231: p_attribute10 IN CS_CONTRACT_STATUSES.ATTRIBUTE10%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1232: p_attribute11 IN CS_CONTRACT_STATUSES.ATTRIBUTE11%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1233: p_attribute12 IN CS_CONTRACT_STATUSES.ATTRIBUTE12%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

Line 1230: p_attribute9 IN CS_CONTRACT_STATUSES.ATTRIBUTE9%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

1226: p_attribute5 IN CS_CONTRACT_STATUSES.ATTRIBUTE5%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1227: p_attribute6 IN CS_CONTRACT_STATUSES.ATTRIBUTE6%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1228: p_attribute7 IN CS_CONTRACT_STATUSES.ATTRIBUTE7%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1229: p_attribute8 IN CS_CONTRACT_STATUSES.ATTRIBUTE8%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1230: p_attribute9 IN CS_CONTRACT_STATUSES.ATTRIBUTE9%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1231: p_attribute10 IN CS_CONTRACT_STATUSES.ATTRIBUTE10%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1232: p_attribute11 IN CS_CONTRACT_STATUSES.ATTRIBUTE11%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1233: p_attribute12 IN CS_CONTRACT_STATUSES.ATTRIBUTE12%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1234: p_attribute13 IN CS_CONTRACT_STATUSES.ATTRIBUTE13%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

Line 1231: p_attribute10 IN CS_CONTRACT_STATUSES.ATTRIBUTE10%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

1227: p_attribute6 IN CS_CONTRACT_STATUSES.ATTRIBUTE6%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1228: p_attribute7 IN CS_CONTRACT_STATUSES.ATTRIBUTE7%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1229: p_attribute8 IN CS_CONTRACT_STATUSES.ATTRIBUTE8%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1230: p_attribute9 IN CS_CONTRACT_STATUSES.ATTRIBUTE9%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1231: p_attribute10 IN CS_CONTRACT_STATUSES.ATTRIBUTE10%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1232: p_attribute11 IN CS_CONTRACT_STATUSES.ATTRIBUTE11%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1233: p_attribute12 IN CS_CONTRACT_STATUSES.ATTRIBUTE12%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1234: p_attribute13 IN CS_CONTRACT_STATUSES.ATTRIBUTE13%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1235: p_attribute14 IN CS_CONTRACT_STATUSES.ATTRIBUTE14%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

Line 1232: p_attribute11 IN CS_CONTRACT_STATUSES.ATTRIBUTE11%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

1228: p_attribute7 IN CS_CONTRACT_STATUSES.ATTRIBUTE7%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1229: p_attribute8 IN CS_CONTRACT_STATUSES.ATTRIBUTE8%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1230: p_attribute9 IN CS_CONTRACT_STATUSES.ATTRIBUTE9%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1231: p_attribute10 IN CS_CONTRACT_STATUSES.ATTRIBUTE10%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1232: p_attribute11 IN CS_CONTRACT_STATUSES.ATTRIBUTE11%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1233: p_attribute12 IN CS_CONTRACT_STATUSES.ATTRIBUTE12%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1234: p_attribute13 IN CS_CONTRACT_STATUSES.ATTRIBUTE13%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1235: p_attribute14 IN CS_CONTRACT_STATUSES.ATTRIBUTE14%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1236: p_attribute15 IN CS_CONTRACT_STATUSES.ATTRIBUTE15%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

Line 1233: p_attribute12 IN CS_CONTRACT_STATUSES.ATTRIBUTE12%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

1229: p_attribute8 IN CS_CONTRACT_STATUSES.ATTRIBUTE8%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1230: p_attribute9 IN CS_CONTRACT_STATUSES.ATTRIBUTE9%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1231: p_attribute10 IN CS_CONTRACT_STATUSES.ATTRIBUTE10%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1232: p_attribute11 IN CS_CONTRACT_STATUSES.ATTRIBUTE11%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1233: p_attribute12 IN CS_CONTRACT_STATUSES.ATTRIBUTE12%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1234: p_attribute13 IN CS_CONTRACT_STATUSES.ATTRIBUTE13%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1235: p_attribute14 IN CS_CONTRACT_STATUSES.ATTRIBUTE14%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1236: p_attribute15 IN CS_CONTRACT_STATUSES.ATTRIBUTE15%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1237: p_context IN CS_CONTRACT_STATUSES.CONTEXT%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

Line 1234: p_attribute13 IN CS_CONTRACT_STATUSES.ATTRIBUTE13%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

1230: p_attribute9 IN CS_CONTRACT_STATUSES.ATTRIBUTE9%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1231: p_attribute10 IN CS_CONTRACT_STATUSES.ATTRIBUTE10%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1232: p_attribute11 IN CS_CONTRACT_STATUSES.ATTRIBUTE11%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1233: p_attribute12 IN CS_CONTRACT_STATUSES.ATTRIBUTE12%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1234: p_attribute13 IN CS_CONTRACT_STATUSES.ATTRIBUTE13%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1235: p_attribute14 IN CS_CONTRACT_STATUSES.ATTRIBUTE14%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1236: p_attribute15 IN CS_CONTRACT_STATUSES.ATTRIBUTE15%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1237: p_context IN CS_CONTRACT_STATUSES.CONTEXT%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1238: p_object_version_number IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM) IS

Line 1235: p_attribute14 IN CS_CONTRACT_STATUSES.ATTRIBUTE14%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

1231: p_attribute10 IN CS_CONTRACT_STATUSES.ATTRIBUTE10%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1232: p_attribute11 IN CS_CONTRACT_STATUSES.ATTRIBUTE11%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1233: p_attribute12 IN CS_CONTRACT_STATUSES.ATTRIBUTE12%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1234: p_attribute13 IN CS_CONTRACT_STATUSES.ATTRIBUTE13%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1235: p_attribute14 IN CS_CONTRACT_STATUSES.ATTRIBUTE14%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1236: p_attribute15 IN CS_CONTRACT_STATUSES.ATTRIBUTE15%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1237: p_context IN CS_CONTRACT_STATUSES.CONTEXT%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1238: p_object_version_number IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM) IS
1239: l_api_name CONSTANT VARCHAR2(30) := 'validate_row';

Line 1236: p_attribute15 IN CS_CONTRACT_STATUSES.ATTRIBUTE15%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

1232: p_attribute11 IN CS_CONTRACT_STATUSES.ATTRIBUTE11%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1233: p_attribute12 IN CS_CONTRACT_STATUSES.ATTRIBUTE12%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1234: p_attribute13 IN CS_CONTRACT_STATUSES.ATTRIBUTE13%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1235: p_attribute14 IN CS_CONTRACT_STATUSES.ATTRIBUTE14%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1236: p_attribute15 IN CS_CONTRACT_STATUSES.ATTRIBUTE15%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1237: p_context IN CS_CONTRACT_STATUSES.CONTEXT%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1238: p_object_version_number IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM) IS
1239: l_api_name CONSTANT VARCHAR2(30) := 'validate_row';
1240: l_api_version CONSTANT NUMBER := 1;

Line 1237: p_context IN CS_CONTRACT_STATUSES.CONTEXT%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

1233: p_attribute12 IN CS_CONTRACT_STATUSES.ATTRIBUTE12%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1234: p_attribute13 IN CS_CONTRACT_STATUSES.ATTRIBUTE13%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1235: p_attribute14 IN CS_CONTRACT_STATUSES.ATTRIBUTE14%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1236: p_attribute15 IN CS_CONTRACT_STATUSES.ATTRIBUTE15%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1237: p_context IN CS_CONTRACT_STATUSES.CONTEXT%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1238: p_object_version_number IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM) IS
1239: l_api_name CONSTANT VARCHAR2(30) := 'validate_row';
1240: l_api_version CONSTANT NUMBER := 1;
1241: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;

Line 1238: p_object_version_number IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM) IS

1234: p_attribute13 IN CS_CONTRACT_STATUSES.ATTRIBUTE13%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1235: p_attribute14 IN CS_CONTRACT_STATUSES.ATTRIBUTE14%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1236: p_attribute15 IN CS_CONTRACT_STATUSES.ATTRIBUTE15%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1237: p_context IN CS_CONTRACT_STATUSES.CONTEXT%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1238: p_object_version_number IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM) IS
1239: l_api_name CONSTANT VARCHAR2(30) := 'validate_row';
1240: l_api_version CONSTANT NUMBER := 1;
1241: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
1242: l_contractstats_rec ContractStats_Val_Rec_Type;

Line 1244: l_return_status := TAPI_DEV_KIT.START_ACTIVITY(l_api_name,

1240: l_api_version CONSTANT NUMBER := 1;
1241: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
1242: l_contractstats_rec ContractStats_Val_Rec_Type;
1243: BEGIN
1244: l_return_status := TAPI_DEV_KIT.START_ACTIVITY(l_api_name,
1245: G_PKG_NAME,
1246: l_api_version,
1247: p_api_version,
1248: p_init_msg_list,

Line 1300: TAPI_DEV_KIT.END_ACTIVITY(p_commit, x_msg_count, x_msg_data);

1296: x_msg_count,
1297: x_msg_data,
1298: l_contractstats_rec
1299: );
1300: TAPI_DEV_KIT.END_ACTIVITY(p_commit, x_msg_count, x_msg_data);
1301: EXCEPTION
1302: WHEN FND_API.G_EXC_ERROR THEN
1303: x_return_status := TAPI_DEV_KIT.HANDLE_EXCEPTIONS
1304: (

Line 1303: x_return_status := TAPI_DEV_KIT.HANDLE_EXCEPTIONS

1299: );
1300: TAPI_DEV_KIT.END_ACTIVITY(p_commit, x_msg_count, x_msg_data);
1301: EXCEPTION
1302: WHEN FND_API.G_EXC_ERROR THEN
1303: x_return_status := TAPI_DEV_KIT.HANDLE_EXCEPTIONS
1304: (
1305: l_api_name,
1306: G_PKG_NAME,
1307: 'FND_API.G_RET_STS_ERROR',

Line 1314: x_return_status :=TAPI_DEV_KIT.HANDLE_EXCEPTIONS

1310: '_Pvt'
1311: );
1312: APP_EXCEPTION.RAISE_EXCEPTION;
1313: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1314: x_return_status :=TAPI_DEV_KIT.HANDLE_EXCEPTIONS
1315: (
1316: l_api_name,
1317: G_PKG_NAME,
1318: 'FND_API.G_RET_STS_UNEXP_ERROR',

Line 1324: WHEN TAPI_DEV_KIT.G_EXC_DUP_VAL_ON_INDEX THEN

1320: x_msg_data,
1321: '_Pvt'
1322: );
1323: APP_EXCEPTION.RAISE_EXCEPTION;
1324: WHEN TAPI_DEV_KIT.G_EXC_DUP_VAL_ON_INDEX THEN
1325: x_return_status :=TAPI_DEV_KIT.HANDLE_EXCEPTIONS
1326: (
1327: l_api_name,
1328: G_PKG_NAME,

Line 1325: x_return_status :=TAPI_DEV_KIT.HANDLE_EXCEPTIONS

1321: '_Pvt'
1322: );
1323: APP_EXCEPTION.RAISE_EXCEPTION;
1324: WHEN TAPI_DEV_KIT.G_EXC_DUP_VAL_ON_INDEX THEN
1325: x_return_status :=TAPI_DEV_KIT.HANDLE_EXCEPTIONS
1326: (
1327: l_api_name,
1328: G_PKG_NAME,
1329: 'TAPI_DEV_KIT.G_RET_STS_DUP_VAL_ON_INDEX',

Line 1329: 'TAPI_DEV_KIT.G_RET_STS_DUP_VAL_ON_INDEX',

1325: x_return_status :=TAPI_DEV_KIT.HANDLE_EXCEPTIONS
1326: (
1327: l_api_name,
1328: G_PKG_NAME,
1329: 'TAPI_DEV_KIT.G_RET_STS_DUP_VAL_ON_INDEX',
1330: x_msg_count,
1331: x_msg_data,
1332: '_Pvt'
1333: );