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

Line 24: IF p_contractbilling_rec.cp_service_id = TAPI_DEV_KIT.G_MISS_NUM OR

20: RETURN VARCHAR2
21: IS
22: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
23: BEGIN
24: IF p_contractbilling_rec.cp_service_id = TAPI_DEV_KIT.G_MISS_NUM OR
25: p_contractbilling_rec.cp_service_id IS NULL
26: THEN
27: TAPI_DEV_KIT.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'cp_service_id');
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,'cp_service_id');

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

Line 29: ELSIF p_contractbilling_rec.contract_id = TAPI_DEV_KIT.G_MISS_NUM OR

25: p_contractbilling_rec.cp_service_id IS NULL
26: THEN
27: TAPI_DEV_KIT.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'cp_service_id');
28: l_return_status := FND_API.G_RET_STS_ERROR;
29: ELSIF p_contractbilling_rec.contract_id = TAPI_DEV_KIT.G_MISS_NUM OR
30: p_contractbilling_rec.contract_id IS NULL
31: THEN
32: TAPI_DEV_KIT.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'contract_id');
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,'contract_id');

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

Line 34: ELSIF p_contractbilling_rec.billed_until_date = TAPI_DEV_KIT.G_MISS_DATE OR

30: p_contractbilling_rec.contract_id IS NULL
31: THEN
32: TAPI_DEV_KIT.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'contract_id');
33: l_return_status := FND_API.G_RET_STS_ERROR;
34: ELSIF p_contractbilling_rec.billed_until_date = TAPI_DEV_KIT.G_MISS_DATE OR
35: p_contractbilling_rec.billed_until_date IS NULL
36: THEN
37: TAPI_DEV_KIT.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'billed_until_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,'billed_until_date');

33: l_return_status := FND_API.G_RET_STS_ERROR;
34: ELSIF p_contractbilling_rec.billed_until_date = TAPI_DEV_KIT.G_MISS_DATE OR
35: p_contractbilling_rec.billed_until_date IS NULL
36: THEN
37: TAPI_DEV_KIT.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'billed_until_date');
38: l_return_status := FND_API.G_RET_STS_ERROR;
39: ELSIF p_contractbilling_rec.currency_code = TAPI_DEV_KIT.G_MISS_CHAR OR
40: p_contractbilling_rec.currency_code IS NULL
41: THEN

Line 39: ELSIF p_contractbilling_rec.currency_code = TAPI_DEV_KIT.G_MISS_CHAR OR

35: p_contractbilling_rec.billed_until_date IS NULL
36: THEN
37: TAPI_DEV_KIT.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'billed_until_date');
38: l_return_status := FND_API.G_RET_STS_ERROR;
39: ELSIF p_contractbilling_rec.currency_code = TAPI_DEV_KIT.G_MISS_CHAR OR
40: p_contractbilling_rec.currency_code IS NULL
41: THEN
42: TAPI_DEV_KIT.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'currency_code');
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,'currency_code');

38: l_return_status := FND_API.G_RET_STS_ERROR;
39: ELSIF p_contractbilling_rec.currency_code = TAPI_DEV_KIT.G_MISS_CHAR OR
40: p_contractbilling_rec.currency_code IS NULL
41: THEN
42: TAPI_DEV_KIT.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'currency_code');
43: l_return_status := FND_API.G_RET_STS_ERROR;
44: ELSIF p_contractbilling_rec.last_update_date = TAPI_DEV_KIT.G_MISS_DATE OR
45: p_contractbilling_rec.last_update_date IS NULL
46: THEN

Line 44: ELSIF p_contractbilling_rec.last_update_date = TAPI_DEV_KIT.G_MISS_DATE OR

40: p_contractbilling_rec.currency_code IS NULL
41: THEN
42: TAPI_DEV_KIT.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'currency_code');
43: l_return_status := FND_API.G_RET_STS_ERROR;
44: ELSIF p_contractbilling_rec.last_update_date = TAPI_DEV_KIT.G_MISS_DATE OR
45: p_contractbilling_rec.last_update_date IS NULL
46: THEN
47: TAPI_DEV_KIT.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'last_update_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,'last_update_date');

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

Line 49: ELSIF p_contractbilling_rec.last_updated_by = TAPI_DEV_KIT.G_MISS_NUM OR

45: p_contractbilling_rec.last_update_date IS NULL
46: THEN
47: TAPI_DEV_KIT.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'last_update_date');
48: l_return_status := FND_API.G_RET_STS_ERROR;
49: ELSIF p_contractbilling_rec.last_updated_by = TAPI_DEV_KIT.G_MISS_NUM OR
50: p_contractbilling_rec.last_updated_by IS NULL
51: THEN
52: TAPI_DEV_KIT.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'last_updated_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,'last_updated_by');

48: l_return_status := FND_API.G_RET_STS_ERROR;
49: ELSIF p_contractbilling_rec.last_updated_by = TAPI_DEV_KIT.G_MISS_NUM OR
50: p_contractbilling_rec.last_updated_by IS NULL
51: THEN
52: TAPI_DEV_KIT.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'last_updated_by');
53: l_return_status := FND_API.G_RET_STS_ERROR;
54: ELSIF p_contractbilling_rec.creation_date = TAPI_DEV_KIT.G_MISS_DATE OR
55: p_contractbilling_rec.creation_date IS NULL
56: THEN

Line 54: ELSIF p_contractbilling_rec.creation_date = TAPI_DEV_KIT.G_MISS_DATE OR

50: p_contractbilling_rec.last_updated_by IS NULL
51: THEN
52: TAPI_DEV_KIT.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'last_updated_by');
53: l_return_status := FND_API.G_RET_STS_ERROR;
54: ELSIF p_contractbilling_rec.creation_date = TAPI_DEV_KIT.G_MISS_DATE OR
55: p_contractbilling_rec.creation_date IS NULL
56: THEN
57: TAPI_DEV_KIT.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'creation_date');
58: l_return_status := FND_API.G_RET_STS_ERROR;

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

53: l_return_status := FND_API.G_RET_STS_ERROR;
54: ELSIF p_contractbilling_rec.creation_date = TAPI_DEV_KIT.G_MISS_DATE OR
55: p_contractbilling_rec.creation_date IS NULL
56: THEN
57: TAPI_DEV_KIT.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'creation_date');
58: l_return_status := FND_API.G_RET_STS_ERROR;
59: ELSIF p_contractbilling_rec.created_by = TAPI_DEV_KIT.G_MISS_NUM OR
60: p_contractbilling_rec.created_by IS NULL
61: THEN

Line 59: ELSIF p_contractbilling_rec.created_by = TAPI_DEV_KIT.G_MISS_NUM OR

55: p_contractbilling_rec.creation_date IS NULL
56: THEN
57: TAPI_DEV_KIT.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'creation_date');
58: l_return_status := FND_API.G_RET_STS_ERROR;
59: ELSIF p_contractbilling_rec.created_by = TAPI_DEV_KIT.G_MISS_NUM OR
60: p_contractbilling_rec.created_by IS NULL
61: THEN
62: TAPI_DEV_KIT.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'created_by');
63: l_return_status := FND_API.G_RET_STS_ERROR;

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

58: l_return_status := FND_API.G_RET_STS_ERROR;
59: ELSIF p_contractbilling_rec.created_by = TAPI_DEV_KIT.G_MISS_NUM OR
60: p_contractbilling_rec.created_by IS NULL
61: THEN
62: TAPI_DEV_KIT.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'created_by');
63: l_return_status := FND_API.G_RET_STS_ERROR;
64: END IF;
65: RETURN(l_return_status);
66: END Validate_Item_Attributes;

Line 115: TAPI_DEV_KIT.set_message(G_APP_NAME, G_INVALID_VALUE,G_COL_NAME_TOKEN,'CONTRACT_ID');

111: FETCH cs_contracts_all_pk_csr INTO l_cs_contracts_all_pk;
112: l_row_notfound := cs_contracts_all_pk_csr%NOTFOUND;
113: CLOSE cs_contracts_all_pk_csr;
114: IF (l_row_notfound) THEN
115: TAPI_DEV_KIT.set_message(G_APP_NAME, G_INVALID_VALUE,G_COL_NAME_TOKEN,'CONTRACT_ID');
116: RAISE item_not_found_error;
117: END IF;
118: END IF;
119: IF (p_contractbilling_rec.CP_SERVICE_ID IS NOT NULL)

Line 126: TAPI_DEV_KIT.set_message(G_APP_NAME, G_INVALID_VALUE,G_COL_NAME_TOKEN,'CP_SERVICE_ID');

122: FETCH cs_cp_services_all_pk_csr INTO l_cs_cp_services_all_pk;
123: l_row_notfound := cs_cp_services_all_pk_csr%NOTFOUND;
124: CLOSE cs_cp_services_all_pk_csr;
125: IF (l_row_notfound) THEN
126: TAPI_DEV_KIT.set_message(G_APP_NAME, G_INVALID_VALUE,G_COL_NAME_TOKEN,'CP_SERVICE_ID');
127: RAISE item_not_found_error;
128: END IF;
129: END IF;
130: RETURN (l_return_status);

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

225: END migrate;
226: PROCEDURE insert_row
227: (
228: p_api_version IN NUMBER,
229: p_init_msg_list IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
230: p_validation_level IN NUMBER,
231: p_commit IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
232: x_return_status OUT VARCHAR2,
233: x_msg_count OUT NUMBER,

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

227: (
228: p_api_version IN NUMBER,
229: p_init_msg_list IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
230: p_validation_level IN NUMBER,
231: p_commit IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
232: x_return_status OUT VARCHAR2,
233: x_msg_count OUT NUMBER,
234: x_msg_data OUT VARCHAR2,
235: p_contractbilling_rec IN ContractBilling_Rec_Type := G_MISS_CONTRACTBILLING_REC,

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

240: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
241: l_contractbilling_rec ContractBilling_Rec_Type;
242: l_def_contractbilling_rec ContractBilling_Rec_Type;
243: BEGIN
244: l_return_status := TAPI_DEV_KIT.START_ACTIVITY(l_api_name,
245: G_PKG_NAME,
246: l_api_version,
247: p_api_version,
248: p_init_msg_list,

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

365: l_def_contractbilling_rec.object_version_number);
366: -- Set OUT values
367: x_contract_billing_id := l_def_contractbilling_rec.contract_billing_id;
368: x_object_version_number := l_def_contractbilling_rec.OBJECT_VERSION_NUMBER;
369: TAPI_DEV_KIT.END_ACTIVITY(p_commit, x_msg_count, x_msg_data);
370: EXCEPTION
371: WHEN FND_API.G_EXC_ERROR THEN
372: x_return_status := TAPI_DEV_KIT.HANDLE_EXCEPTIONS
373: (

Line 372: x_return_status := TAPI_DEV_KIT.HANDLE_EXCEPTIONS

368: x_object_version_number := l_def_contractbilling_rec.OBJECT_VERSION_NUMBER;
369: TAPI_DEV_KIT.END_ACTIVITY(p_commit, x_msg_count, x_msg_data);
370: EXCEPTION
371: WHEN FND_API.G_EXC_ERROR THEN
372: x_return_status := TAPI_DEV_KIT.HANDLE_EXCEPTIONS
373: (
374: l_api_name,
375: G_PKG_NAME,
376: 'FND_API.G_RET_STS_ERROR',

Line 383: x_return_status :=TAPI_DEV_KIT.HANDLE_EXCEPTIONS

379: '_Pvt'
380: );
381: APP_EXCEPTION.RAISE_EXCEPTION;
382: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
383: x_return_status :=TAPI_DEV_KIT.HANDLE_EXCEPTIONS
384: (
385: l_api_name,
386: G_PKG_NAME,
387: 'FND_API.G_RET_STS_UNEXP_ERROR',

Line 393: WHEN TAPI_DEV_KIT.G_EXC_DUP_VAL_ON_INDEX THEN

389: x_msg_data,
390: '_Pvt'
391: );
392: APP_EXCEPTION.RAISE_EXCEPTION;
393: WHEN TAPI_DEV_KIT.G_EXC_DUP_VAL_ON_INDEX THEN
394: x_return_status :=TAPI_DEV_KIT.HANDLE_EXCEPTIONS
395: (
396: l_api_name,
397: G_PKG_NAME,

Line 394: x_return_status :=TAPI_DEV_KIT.HANDLE_EXCEPTIONS

390: '_Pvt'
391: );
392: APP_EXCEPTION.RAISE_EXCEPTION;
393: WHEN TAPI_DEV_KIT.G_EXC_DUP_VAL_ON_INDEX THEN
394: x_return_status :=TAPI_DEV_KIT.HANDLE_EXCEPTIONS
395: (
396: l_api_name,
397: G_PKG_NAME,
398: 'TAPI_DEV_KIT.G_RET_STS_DUP_VAL_ON_INDEX',

Line 398: 'TAPI_DEV_KIT.G_RET_STS_DUP_VAL_ON_INDEX',

394: x_return_status :=TAPI_DEV_KIT.HANDLE_EXCEPTIONS
395: (
396: l_api_name,
397: G_PKG_NAME,
398: 'TAPI_DEV_KIT.G_RET_STS_DUP_VAL_ON_INDEX',
399: x_msg_count,
400: x_msg_data,
401: '_Pvt'
402: );

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

404: END insert_row;
405: PROCEDURE insert_row
406: (
407: p_api_version IN NUMBER,
408: p_init_msg_list IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
409: p_validation_level IN NUMBER,
410: p_commit IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
411: x_return_status OUT VARCHAR2,
412: x_msg_count OUT NUMBER,

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

406: (
407: p_api_version IN NUMBER,
408: p_init_msg_list IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
409: p_validation_level IN NUMBER,
410: p_commit IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
411: x_return_status OUT VARCHAR2,
412: x_msg_count OUT NUMBER,
413: x_msg_data OUT VARCHAR2,
414: p_header_id IN NUMBER := NULL,

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

452: l_api_version CONSTANT NUMBER := 1;
453: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
454: l_contractbilling_rec ContractBilling_Rec_Type;
455: BEGIN
456: l_return_status := TAPI_DEV_KIT.START_ACTIVITY(l_api_name,
457: G_PKG_NAME,
458: l_api_version,
459: p_api_version,
460: p_init_msg_list,

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

511: l_contractbilling_rec,
512: x_contract_billing_id,
513: x_object_version_number
514: );
515: TAPI_DEV_KIT.END_ACTIVITY(p_commit, x_msg_count, x_msg_data);
516: EXCEPTION
517: WHEN FND_API.G_EXC_ERROR THEN
518: x_return_status := TAPI_DEV_KIT.HANDLE_EXCEPTIONS
519: (

Line 518: x_return_status := TAPI_DEV_KIT.HANDLE_EXCEPTIONS

514: );
515: TAPI_DEV_KIT.END_ACTIVITY(p_commit, x_msg_count, x_msg_data);
516: EXCEPTION
517: WHEN FND_API.G_EXC_ERROR THEN
518: x_return_status := TAPI_DEV_KIT.HANDLE_EXCEPTIONS
519: (
520: l_api_name,
521: G_PKG_NAME,
522: 'FND_API.G_RET_STS_ERROR',

Line 529: x_return_status :=TAPI_DEV_KIT.HANDLE_EXCEPTIONS

525: '_Pvt'
526: );
527: APP_EXCEPTION.RAISE_EXCEPTION;
528: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
529: x_return_status :=TAPI_DEV_KIT.HANDLE_EXCEPTIONS
530: (
531: l_api_name,
532: G_PKG_NAME,
533: 'FND_API.G_RET_STS_UNEXP_ERROR',

Line 539: WHEN TAPI_DEV_KIT.G_EXC_DUP_VAL_ON_INDEX THEN

535: x_msg_data,
536: '_Pvt'
537: );
538: APP_EXCEPTION.RAISE_EXCEPTION;
539: WHEN TAPI_DEV_KIT.G_EXC_DUP_VAL_ON_INDEX THEN
540: x_return_status :=TAPI_DEV_KIT.HANDLE_EXCEPTIONS
541: (
542: l_api_name,
543: G_PKG_NAME,

Line 540: x_return_status :=TAPI_DEV_KIT.HANDLE_EXCEPTIONS

536: '_Pvt'
537: );
538: APP_EXCEPTION.RAISE_EXCEPTION;
539: WHEN TAPI_DEV_KIT.G_EXC_DUP_VAL_ON_INDEX THEN
540: x_return_status :=TAPI_DEV_KIT.HANDLE_EXCEPTIONS
541: (
542: l_api_name,
543: G_PKG_NAME,
544: 'TAPI_DEV_KIT.G_RET_STS_DUP_VAL_ON_INDEX',

Line 544: 'TAPI_DEV_KIT.G_RET_STS_DUP_VAL_ON_INDEX',

540: x_return_status :=TAPI_DEV_KIT.HANDLE_EXCEPTIONS
541: (
542: l_api_name,
543: G_PKG_NAME,
544: 'TAPI_DEV_KIT.G_RET_STS_DUP_VAL_ON_INDEX',
545: x_msg_count,
546: x_msg_data,
547: '_Pvt'
548: );

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

550: END insert_row;
551: Procedure lock_row
552: (
553: p_api_version IN NUMBER,
554: p_init_msg_list IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
555: p_validation_level IN NUMBER,
556: p_commit IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
557: x_return_status OUT VARCHAR2,
558: x_msg_count OUT NUMBER,

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

552: (
553: p_api_version IN NUMBER,
554: p_init_msg_list IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
555: p_validation_level IN NUMBER,
556: p_commit IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
557: x_return_status OUT VARCHAR2,
558: x_msg_count OUT NUMBER,
559: x_msg_data OUT VARCHAR2,
560: p_contract_billing_id IN NUMBER,

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

582: lc_object_version_number CS_CONTRACTS_BILLING.OBJECT_VERSION_NUMBER%TYPE;
583: l_row_notfound BOOLEAN := FALSE;
584: lc_row_notfound BOOLEAN := FALSE;
585: BEGIN
586: l_return_status := TAPI_DEV_KIT.START_ACTIVITY(l_api_name,
587: G_PKG_NAME,
588: l_api_version,
589: p_api_version,
590: p_init_msg_list,

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

604: WHEN E_Resource_Busy THEN
605: IF (lock_csr%ISOPEN) THEN
606: CLOSE lock_csr;
607: END IF;
608: TAPI_DEV_KIT.set_message(G_FND_APP,G_FORM_UNABLE_TO_RESERVE_REC);
609: RAISE APP_EXCEPTIONS.RECORD_LOCK_EXCEPTION;
610: END;
611:
612: IF ( l_row_notfound ) THEN

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

615: lc_row_notfound := lchk_csr%NOTFOUND;
616: CLOSE lchk_csr;
617: END IF;
618: IF (lc_row_notfound) THEN
619: TAPI_DEV_KIT.set_message(G_FND_APP,G_FORM_RECORD_DELETED);
620: RAISE FND_API.G_EXC_ERROR;
621: ELSIF lc_object_version_number > p_object_version_number THEN
622: TAPI_DEV_KIT.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
623: RAISE FND_API.G_EXC_ERROR;

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

618: IF (lc_row_notfound) THEN
619: TAPI_DEV_KIT.set_message(G_FND_APP,G_FORM_RECORD_DELETED);
620: RAISE FND_API.G_EXC_ERROR;
621: ELSIF lc_object_version_number > p_object_version_number THEN
622: TAPI_DEV_KIT.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
623: RAISE FND_API.G_EXC_ERROR;
624: ELSIF lc_object_version_number <> p_object_version_number THEN
625: TAPI_DEV_KIT.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
626: RAISE FND_API.G_EXC_ERROR;

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

621: ELSIF lc_object_version_number > p_object_version_number THEN
622: TAPI_DEV_KIT.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
623: RAISE FND_API.G_EXC_ERROR;
624: ELSIF lc_object_version_number <> p_object_version_number THEN
625: TAPI_DEV_KIT.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
626: RAISE FND_API.G_EXC_ERROR;
627: ELSIF lc_object_version_number = -1 THEN
628: TAPI_DEV_KIT.set_message(G_APP_NAME,G_RECORD_LOGICALLY_DELETED);
629: RAISE FND_API.G_EXC_ERROR;

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

624: ELSIF lc_object_version_number <> p_object_version_number THEN
625: TAPI_DEV_KIT.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
626: RAISE FND_API.G_EXC_ERROR;
627: ELSIF lc_object_version_number = -1 THEN
628: TAPI_DEV_KIT.set_message(G_APP_NAME,G_RECORD_LOGICALLY_DELETED);
629: RAISE FND_API.G_EXC_ERROR;
630: END IF;
631: TAPI_DEV_KIT.END_ACTIVITY(p_commit, x_msg_count, x_msg_data);
632: EXCEPTION

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

627: ELSIF lc_object_version_number = -1 THEN
628: TAPI_DEV_KIT.set_message(G_APP_NAME,G_RECORD_LOGICALLY_DELETED);
629: RAISE FND_API.G_EXC_ERROR;
630: END IF;
631: TAPI_DEV_KIT.END_ACTIVITY(p_commit, x_msg_count, x_msg_data);
632: EXCEPTION
633: WHEN FND_API.G_EXC_ERROR THEN
634: x_return_status := TAPI_DEV_KIT.HANDLE_EXCEPTIONS
635: (

Line 634: x_return_status := TAPI_DEV_KIT.HANDLE_EXCEPTIONS

630: END IF;
631: TAPI_DEV_KIT.END_ACTIVITY(p_commit, x_msg_count, x_msg_data);
632: EXCEPTION
633: WHEN FND_API.G_EXC_ERROR THEN
634: x_return_status := TAPI_DEV_KIT.HANDLE_EXCEPTIONS
635: (
636: l_api_name,
637: G_PKG_NAME,
638: 'FND_API.G_RET_STS_ERROR',

Line 645: x_return_status :=TAPI_DEV_KIT.HANDLE_EXCEPTIONS

641: '_Pvt'
642: );
643: APP_EXCEPTION.RAISE_EXCEPTION;
644: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
645: x_return_status :=TAPI_DEV_KIT.HANDLE_EXCEPTIONS
646: (
647: l_api_name,
648: G_PKG_NAME,
649: 'FND_API.G_RET_STS_UNEXP_ERROR',

Line 655: WHEN TAPI_DEV_KIT.G_EXC_DUP_VAL_ON_INDEX THEN

651: x_msg_data,
652: '_Pvt'
653: );
654: APP_EXCEPTION.RAISE_EXCEPTION;
655: WHEN TAPI_DEV_KIT.G_EXC_DUP_VAL_ON_INDEX THEN
656: x_return_status :=TAPI_DEV_KIT.HANDLE_EXCEPTIONS
657: (
658: l_api_name,
659: G_PKG_NAME,

Line 656: x_return_status :=TAPI_DEV_KIT.HANDLE_EXCEPTIONS

652: '_Pvt'
653: );
654: APP_EXCEPTION.RAISE_EXCEPTION;
655: WHEN TAPI_DEV_KIT.G_EXC_DUP_VAL_ON_INDEX THEN
656: x_return_status :=TAPI_DEV_KIT.HANDLE_EXCEPTIONS
657: (
658: l_api_name,
659: G_PKG_NAME,
660: 'TAPI_DEV_KIT.G_RET_STS_DUP_VAL_ON_INDEX',

Line 660: 'TAPI_DEV_KIT.G_RET_STS_DUP_VAL_ON_INDEX',

656: x_return_status :=TAPI_DEV_KIT.HANDLE_EXCEPTIONS
657: (
658: l_api_name,
659: G_PKG_NAME,
660: 'TAPI_DEV_KIT.G_RET_STS_DUP_VAL_ON_INDEX',
661: x_msg_count,
662: x_msg_data,
663: '_Pvt'
664: );

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

666: END lock_row;
667: Procedure update_row
668: (
669: p_api_version IN NUMBER,
670: p_init_msg_list IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
671: p_validation_level IN NUMBER,
672: p_commit IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
673: x_return_status OUT VARCHAR2,
674: x_msg_count OUT NUMBER,

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

668: (
669: p_api_version IN NUMBER,
670: p_init_msg_list IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
671: p_validation_level IN NUMBER,
672: p_commit IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
673: x_return_status OUT VARCHAR2,
674: x_msg_count OUT NUMBER,
675: x_msg_data OUT VARCHAR2,
676: p_contractbilling_val_rec IN ContractBilling_Val_Rec_Type := G_MISS_CONTRACTBILLING_VAL_REC,

Line 704: IF (x_contractbilling_rec.contract_billing_id = TAPI_DEV_KIT.G_MISS_NUM)

700: CLOSE cs_contracts_billing_pk_csr;
701: IF (l_row_notfound) THEN
702: l_return_status := FND_API.G_RET_STS_ERROR;
703: END IF;
704: IF (x_contractbilling_rec.contract_billing_id = TAPI_DEV_KIT.G_MISS_NUM)
705: THEN
706: x_contractbilling_rec.contract_billing_id := l_cs_contracts_billing_pk.contract_billing_id;
707: END IF;
708: IF (x_contractbilling_rec.header_id = TAPI_DEV_KIT.G_MISS_NUM)

Line 708: IF (x_contractbilling_rec.header_id = TAPI_DEV_KIT.G_MISS_NUM)

704: IF (x_contractbilling_rec.contract_billing_id = TAPI_DEV_KIT.G_MISS_NUM)
705: THEN
706: x_contractbilling_rec.contract_billing_id := l_cs_contracts_billing_pk.contract_billing_id;
707: END IF;
708: IF (x_contractbilling_rec.header_id = TAPI_DEV_KIT.G_MISS_NUM)
709: THEN
710: x_contractbilling_rec.header_id := l_cs_contracts_billing_pk.header_id;
711: END IF;
712: IF (x_contractbilling_rec.order_number = TAPI_DEV_KIT.G_MISS_NUM)

Line 712: IF (x_contractbilling_rec.order_number = TAPI_DEV_KIT.G_MISS_NUM)

708: IF (x_contractbilling_rec.header_id = TAPI_DEV_KIT.G_MISS_NUM)
709: THEN
710: x_contractbilling_rec.header_id := l_cs_contracts_billing_pk.header_id;
711: END IF;
712: IF (x_contractbilling_rec.order_number = TAPI_DEV_KIT.G_MISS_NUM)
713: THEN
714: x_contractbilling_rec.order_number := l_cs_contracts_billing_pk.order_number;
715: END IF;
716: IF (x_contractbilling_rec.line_id = TAPI_DEV_KIT.G_MISS_NUM)

Line 716: IF (x_contractbilling_rec.line_id = TAPI_DEV_KIT.G_MISS_NUM)

712: IF (x_contractbilling_rec.order_number = TAPI_DEV_KIT.G_MISS_NUM)
713: THEN
714: x_contractbilling_rec.order_number := l_cs_contracts_billing_pk.order_number;
715: END IF;
716: IF (x_contractbilling_rec.line_id = TAPI_DEV_KIT.G_MISS_NUM)
717: THEN
718: x_contractbilling_rec.line_id := l_cs_contracts_billing_pk.line_id;
719: END IF;
720: IF (x_contractbilling_rec.cp_service_id = TAPI_DEV_KIT.G_MISS_NUM)

Line 720: IF (x_contractbilling_rec.cp_service_id = TAPI_DEV_KIT.G_MISS_NUM)

716: IF (x_contractbilling_rec.line_id = TAPI_DEV_KIT.G_MISS_NUM)
717: THEN
718: x_contractbilling_rec.line_id := l_cs_contracts_billing_pk.line_id;
719: END IF;
720: IF (x_contractbilling_rec.cp_service_id = TAPI_DEV_KIT.G_MISS_NUM)
721: THEN
722: x_contractbilling_rec.cp_service_id := l_cs_contracts_billing_pk.cp_service_id;
723: END IF;
724: IF (x_contractbilling_rec.contract_id = TAPI_DEV_KIT.G_MISS_NUM)

Line 724: IF (x_contractbilling_rec.contract_id = TAPI_DEV_KIT.G_MISS_NUM)

720: IF (x_contractbilling_rec.cp_service_id = TAPI_DEV_KIT.G_MISS_NUM)
721: THEN
722: x_contractbilling_rec.cp_service_id := l_cs_contracts_billing_pk.cp_service_id;
723: END IF;
724: IF (x_contractbilling_rec.contract_id = TAPI_DEV_KIT.G_MISS_NUM)
725: THEN
726: x_contractbilling_rec.contract_id := l_cs_contracts_billing_pk.contract_id;
727: END IF;
728: IF (x_contractbilling_rec.cust_trx_type_id = TAPI_DEV_KIT.G_MISS_NUM)

Line 728: IF (x_contractbilling_rec.cust_trx_type_id = TAPI_DEV_KIT.G_MISS_NUM)

724: IF (x_contractbilling_rec.contract_id = TAPI_DEV_KIT.G_MISS_NUM)
725: THEN
726: x_contractbilling_rec.contract_id := l_cs_contracts_billing_pk.contract_id;
727: END IF;
728: IF (x_contractbilling_rec.cust_trx_type_id = TAPI_DEV_KIT.G_MISS_NUM)
729: THEN
730: x_contractbilling_rec.cust_trx_type_id := l_cs_contracts_billing_pk.cust_trx_type_id;
731: END IF;
732: IF (x_contractbilling_rec.trx_date = TAPI_DEV_KIT.G_MISS_DATE)

Line 732: IF (x_contractbilling_rec.trx_date = TAPI_DEV_KIT.G_MISS_DATE)

728: IF (x_contractbilling_rec.cust_trx_type_id = TAPI_DEV_KIT.G_MISS_NUM)
729: THEN
730: x_contractbilling_rec.cust_trx_type_id := l_cs_contracts_billing_pk.cust_trx_type_id;
731: END IF;
732: IF (x_contractbilling_rec.trx_date = TAPI_DEV_KIT.G_MISS_DATE)
733: THEN
734: x_contractbilling_rec.trx_date := l_cs_contracts_billing_pk.trx_date;
735: END IF;
736: IF (x_contractbilling_rec.trx_number = TAPI_DEV_KIT.G_MISS_NUM)

Line 736: IF (x_contractbilling_rec.trx_number = TAPI_DEV_KIT.G_MISS_NUM)

732: IF (x_contractbilling_rec.trx_date = TAPI_DEV_KIT.G_MISS_DATE)
733: THEN
734: x_contractbilling_rec.trx_date := l_cs_contracts_billing_pk.trx_date;
735: END IF;
736: IF (x_contractbilling_rec.trx_number = TAPI_DEV_KIT.G_MISS_NUM)
737: THEN
738: x_contractbilling_rec.trx_number := l_cs_contracts_billing_pk.trx_number;
739: END IF;
740: IF (x_contractbilling_rec.trx_amount = TAPI_DEV_KIT.G_MISS_NUM)

Line 740: IF (x_contractbilling_rec.trx_amount = TAPI_DEV_KIT.G_MISS_NUM)

736: IF (x_contractbilling_rec.trx_number = TAPI_DEV_KIT.G_MISS_NUM)
737: THEN
738: x_contractbilling_rec.trx_number := l_cs_contracts_billing_pk.trx_number;
739: END IF;
740: IF (x_contractbilling_rec.trx_amount = TAPI_DEV_KIT.G_MISS_NUM)
741: THEN
742: x_contractbilling_rec.trx_amount := l_cs_contracts_billing_pk.trx_amount;
743: END IF;
744: IF (x_contractbilling_rec.trx_class = TAPI_DEV_KIT.G_MISS_CHAR)

Line 744: IF (x_contractbilling_rec.trx_class = TAPI_DEV_KIT.G_MISS_CHAR)

740: IF (x_contractbilling_rec.trx_amount = TAPI_DEV_KIT.G_MISS_NUM)
741: THEN
742: x_contractbilling_rec.trx_amount := l_cs_contracts_billing_pk.trx_amount;
743: END IF;
744: IF (x_contractbilling_rec.trx_class = TAPI_DEV_KIT.G_MISS_CHAR)
745: THEN
746: x_contractbilling_rec.trx_class := l_cs_contracts_billing_pk.trx_class;
747: END IF;
748: IF (x_contractbilling_rec.billed_until_date = TAPI_DEV_KIT.G_MISS_DATE)

Line 748: IF (x_contractbilling_rec.billed_until_date = TAPI_DEV_KIT.G_MISS_DATE)

744: IF (x_contractbilling_rec.trx_class = TAPI_DEV_KIT.G_MISS_CHAR)
745: THEN
746: x_contractbilling_rec.trx_class := l_cs_contracts_billing_pk.trx_class;
747: END IF;
748: IF (x_contractbilling_rec.billed_until_date = TAPI_DEV_KIT.G_MISS_DATE)
749: THEN
750: x_contractbilling_rec.billed_until_date := l_cs_contracts_billing_pk.billed_until_date;
751: END IF;
752: IF (x_contractbilling_rec.currency_code = TAPI_DEV_KIT.G_MISS_CHAR)

Line 752: IF (x_contractbilling_rec.currency_code = TAPI_DEV_KIT.G_MISS_CHAR)

748: IF (x_contractbilling_rec.billed_until_date = TAPI_DEV_KIT.G_MISS_DATE)
749: THEN
750: x_contractbilling_rec.billed_until_date := l_cs_contracts_billing_pk.billed_until_date;
751: END IF;
752: IF (x_contractbilling_rec.currency_code = TAPI_DEV_KIT.G_MISS_CHAR)
753: THEN
754: x_contractbilling_rec.currency_code := l_cs_contracts_billing_pk.currency_code;
755: END IF;
756: IF (x_contractbilling_rec.last_update_date = TAPI_DEV_KIT.G_MISS_DATE)

Line 756: IF (x_contractbilling_rec.last_update_date = TAPI_DEV_KIT.G_MISS_DATE)

752: IF (x_contractbilling_rec.currency_code = TAPI_DEV_KIT.G_MISS_CHAR)
753: THEN
754: x_contractbilling_rec.currency_code := l_cs_contracts_billing_pk.currency_code;
755: END IF;
756: IF (x_contractbilling_rec.last_update_date = TAPI_DEV_KIT.G_MISS_DATE)
757: THEN
758: x_contractbilling_rec.last_update_date := l_cs_contracts_billing_pk.last_update_date;
759: END IF;
760: IF (x_contractbilling_rec.last_updated_by = TAPI_DEV_KIT.G_MISS_NUM)

Line 760: IF (x_contractbilling_rec.last_updated_by = TAPI_DEV_KIT.G_MISS_NUM)

756: IF (x_contractbilling_rec.last_update_date = TAPI_DEV_KIT.G_MISS_DATE)
757: THEN
758: x_contractbilling_rec.last_update_date := l_cs_contracts_billing_pk.last_update_date;
759: END IF;
760: IF (x_contractbilling_rec.last_updated_by = TAPI_DEV_KIT.G_MISS_NUM)
761: THEN
762: x_contractbilling_rec.last_updated_by := l_cs_contracts_billing_pk.last_updated_by;
763: END IF;
764: IF (x_contractbilling_rec.creation_date = TAPI_DEV_KIT.G_MISS_DATE)

Line 764: IF (x_contractbilling_rec.creation_date = TAPI_DEV_KIT.G_MISS_DATE)

760: IF (x_contractbilling_rec.last_updated_by = TAPI_DEV_KIT.G_MISS_NUM)
761: THEN
762: x_contractbilling_rec.last_updated_by := l_cs_contracts_billing_pk.last_updated_by;
763: END IF;
764: IF (x_contractbilling_rec.creation_date = TAPI_DEV_KIT.G_MISS_DATE)
765: THEN
766: x_contractbilling_rec.creation_date := l_cs_contracts_billing_pk.creation_date;
767: END IF;
768: IF (x_contractbilling_rec.created_by = TAPI_DEV_KIT.G_MISS_NUM)

Line 768: IF (x_contractbilling_rec.created_by = TAPI_DEV_KIT.G_MISS_NUM)

764: IF (x_contractbilling_rec.creation_date = TAPI_DEV_KIT.G_MISS_DATE)
765: THEN
766: x_contractbilling_rec.creation_date := l_cs_contracts_billing_pk.creation_date;
767: END IF;
768: IF (x_contractbilling_rec.created_by = TAPI_DEV_KIT.G_MISS_NUM)
769: THEN
770: x_contractbilling_rec.created_by := l_cs_contracts_billing_pk.created_by;
771: END IF;
772: IF (x_contractbilling_rec.last_update_login = TAPI_DEV_KIT.G_MISS_NUM)

Line 772: IF (x_contractbilling_rec.last_update_login = TAPI_DEV_KIT.G_MISS_NUM)

768: IF (x_contractbilling_rec.created_by = TAPI_DEV_KIT.G_MISS_NUM)
769: THEN
770: x_contractbilling_rec.created_by := l_cs_contracts_billing_pk.created_by;
771: END IF;
772: IF (x_contractbilling_rec.last_update_login = TAPI_DEV_KIT.G_MISS_NUM)
773: THEN
774: x_contractbilling_rec.last_update_login := l_cs_contracts_billing_pk.last_update_login;
775: END IF;
776: IF (x_contractbilling_rec.trx_pre_tax_amount = TAPI_DEV_KIT.G_MISS_NUM)

Line 776: IF (x_contractbilling_rec.trx_pre_tax_amount = TAPI_DEV_KIT.G_MISS_NUM)

772: IF (x_contractbilling_rec.last_update_login = TAPI_DEV_KIT.G_MISS_NUM)
773: THEN
774: x_contractbilling_rec.last_update_login := l_cs_contracts_billing_pk.last_update_login;
775: END IF;
776: IF (x_contractbilling_rec.trx_pre_tax_amount = TAPI_DEV_KIT.G_MISS_NUM)
777: THEN
778: x_contractbilling_rec.trx_pre_tax_amount := l_cs_contracts_billing_pk.trx_pre_tax_amount;
779: END IF;
780: IF (x_contractbilling_rec.attribute1 = TAPI_DEV_KIT.G_MISS_CHAR)

Line 780: IF (x_contractbilling_rec.attribute1 = TAPI_DEV_KIT.G_MISS_CHAR)

776: IF (x_contractbilling_rec.trx_pre_tax_amount = TAPI_DEV_KIT.G_MISS_NUM)
777: THEN
778: x_contractbilling_rec.trx_pre_tax_amount := l_cs_contracts_billing_pk.trx_pre_tax_amount;
779: END IF;
780: IF (x_contractbilling_rec.attribute1 = TAPI_DEV_KIT.G_MISS_CHAR)
781: THEN
782: x_contractbilling_rec.attribute1 := l_cs_contracts_billing_pk.attribute1;
783: END IF;
784: IF (x_contractbilling_rec.attribute2 = TAPI_DEV_KIT.G_MISS_CHAR)

Line 784: IF (x_contractbilling_rec.attribute2 = TAPI_DEV_KIT.G_MISS_CHAR)

780: IF (x_contractbilling_rec.attribute1 = TAPI_DEV_KIT.G_MISS_CHAR)
781: THEN
782: x_contractbilling_rec.attribute1 := l_cs_contracts_billing_pk.attribute1;
783: END IF;
784: IF (x_contractbilling_rec.attribute2 = TAPI_DEV_KIT.G_MISS_CHAR)
785: THEN
786: x_contractbilling_rec.attribute2 := l_cs_contracts_billing_pk.attribute2;
787: END IF;
788: IF (x_contractbilling_rec.attribute3 = TAPI_DEV_KIT.G_MISS_CHAR)

Line 788: IF (x_contractbilling_rec.attribute3 = TAPI_DEV_KIT.G_MISS_CHAR)

784: IF (x_contractbilling_rec.attribute2 = TAPI_DEV_KIT.G_MISS_CHAR)
785: THEN
786: x_contractbilling_rec.attribute2 := l_cs_contracts_billing_pk.attribute2;
787: END IF;
788: IF (x_contractbilling_rec.attribute3 = TAPI_DEV_KIT.G_MISS_CHAR)
789: THEN
790: x_contractbilling_rec.attribute3 := l_cs_contracts_billing_pk.attribute3;
791: END IF;
792: IF (x_contractbilling_rec.attribute4 = TAPI_DEV_KIT.G_MISS_CHAR)

Line 792: IF (x_contractbilling_rec.attribute4 = TAPI_DEV_KIT.G_MISS_CHAR)

788: IF (x_contractbilling_rec.attribute3 = TAPI_DEV_KIT.G_MISS_CHAR)
789: THEN
790: x_contractbilling_rec.attribute3 := l_cs_contracts_billing_pk.attribute3;
791: END IF;
792: IF (x_contractbilling_rec.attribute4 = TAPI_DEV_KIT.G_MISS_CHAR)
793: THEN
794: x_contractbilling_rec.attribute4 := l_cs_contracts_billing_pk.attribute4;
795: END IF;
796: IF (x_contractbilling_rec.attribute5 = TAPI_DEV_KIT.G_MISS_CHAR)

Line 796: IF (x_contractbilling_rec.attribute5 = TAPI_DEV_KIT.G_MISS_CHAR)

792: IF (x_contractbilling_rec.attribute4 = TAPI_DEV_KIT.G_MISS_CHAR)
793: THEN
794: x_contractbilling_rec.attribute4 := l_cs_contracts_billing_pk.attribute4;
795: END IF;
796: IF (x_contractbilling_rec.attribute5 = TAPI_DEV_KIT.G_MISS_CHAR)
797: THEN
798: x_contractbilling_rec.attribute5 := l_cs_contracts_billing_pk.attribute5;
799: END IF;
800: IF (x_contractbilling_rec.attribute6 = TAPI_DEV_KIT.G_MISS_CHAR)

Line 800: IF (x_contractbilling_rec.attribute6 = TAPI_DEV_KIT.G_MISS_CHAR)

796: IF (x_contractbilling_rec.attribute5 = TAPI_DEV_KIT.G_MISS_CHAR)
797: THEN
798: x_contractbilling_rec.attribute5 := l_cs_contracts_billing_pk.attribute5;
799: END IF;
800: IF (x_contractbilling_rec.attribute6 = TAPI_DEV_KIT.G_MISS_CHAR)
801: THEN
802: x_contractbilling_rec.attribute6 := l_cs_contracts_billing_pk.attribute6;
803: END IF;
804: IF (x_contractbilling_rec.attribute7 = TAPI_DEV_KIT.G_MISS_CHAR)

Line 804: IF (x_contractbilling_rec.attribute7 = TAPI_DEV_KIT.G_MISS_CHAR)

800: IF (x_contractbilling_rec.attribute6 = TAPI_DEV_KIT.G_MISS_CHAR)
801: THEN
802: x_contractbilling_rec.attribute6 := l_cs_contracts_billing_pk.attribute6;
803: END IF;
804: IF (x_contractbilling_rec.attribute7 = TAPI_DEV_KIT.G_MISS_CHAR)
805: THEN
806: x_contractbilling_rec.attribute7 := l_cs_contracts_billing_pk.attribute7;
807: END IF;
808: IF (x_contractbilling_rec.attribute8 = TAPI_DEV_KIT.G_MISS_CHAR)

Line 808: IF (x_contractbilling_rec.attribute8 = TAPI_DEV_KIT.G_MISS_CHAR)

804: IF (x_contractbilling_rec.attribute7 = TAPI_DEV_KIT.G_MISS_CHAR)
805: THEN
806: x_contractbilling_rec.attribute7 := l_cs_contracts_billing_pk.attribute7;
807: END IF;
808: IF (x_contractbilling_rec.attribute8 = TAPI_DEV_KIT.G_MISS_CHAR)
809: THEN
810: x_contractbilling_rec.attribute8 := l_cs_contracts_billing_pk.attribute8;
811: END IF;
812: IF (x_contractbilling_rec.attribute9 = TAPI_DEV_KIT.G_MISS_CHAR)

Line 812: IF (x_contractbilling_rec.attribute9 = TAPI_DEV_KIT.G_MISS_CHAR)

808: IF (x_contractbilling_rec.attribute8 = TAPI_DEV_KIT.G_MISS_CHAR)
809: THEN
810: x_contractbilling_rec.attribute8 := l_cs_contracts_billing_pk.attribute8;
811: END IF;
812: IF (x_contractbilling_rec.attribute9 = TAPI_DEV_KIT.G_MISS_CHAR)
813: THEN
814: x_contractbilling_rec.attribute9 := l_cs_contracts_billing_pk.attribute9;
815: END IF;
816: IF (x_contractbilling_rec.attribute10 = TAPI_DEV_KIT.G_MISS_CHAR)

Line 816: IF (x_contractbilling_rec.attribute10 = TAPI_DEV_KIT.G_MISS_CHAR)

812: IF (x_contractbilling_rec.attribute9 = TAPI_DEV_KIT.G_MISS_CHAR)
813: THEN
814: x_contractbilling_rec.attribute9 := l_cs_contracts_billing_pk.attribute9;
815: END IF;
816: IF (x_contractbilling_rec.attribute10 = TAPI_DEV_KIT.G_MISS_CHAR)
817: THEN
818: x_contractbilling_rec.attribute10 := l_cs_contracts_billing_pk.attribute10;
819: END IF;
820: IF (x_contractbilling_rec.attribute11 = TAPI_DEV_KIT.G_MISS_CHAR)

Line 820: IF (x_contractbilling_rec.attribute11 = TAPI_DEV_KIT.G_MISS_CHAR)

816: IF (x_contractbilling_rec.attribute10 = TAPI_DEV_KIT.G_MISS_CHAR)
817: THEN
818: x_contractbilling_rec.attribute10 := l_cs_contracts_billing_pk.attribute10;
819: END IF;
820: IF (x_contractbilling_rec.attribute11 = TAPI_DEV_KIT.G_MISS_CHAR)
821: THEN
822: x_contractbilling_rec.attribute11 := l_cs_contracts_billing_pk.attribute11;
823: END IF;
824: IF (x_contractbilling_rec.attribute12 = TAPI_DEV_KIT.G_MISS_CHAR)

Line 824: IF (x_contractbilling_rec.attribute12 = TAPI_DEV_KIT.G_MISS_CHAR)

820: IF (x_contractbilling_rec.attribute11 = TAPI_DEV_KIT.G_MISS_CHAR)
821: THEN
822: x_contractbilling_rec.attribute11 := l_cs_contracts_billing_pk.attribute11;
823: END IF;
824: IF (x_contractbilling_rec.attribute12 = TAPI_DEV_KIT.G_MISS_CHAR)
825: THEN
826: x_contractbilling_rec.attribute12 := l_cs_contracts_billing_pk.attribute12;
827: END IF;
828: IF (x_contractbilling_rec.attribute13 = TAPI_DEV_KIT.G_MISS_CHAR)

Line 828: IF (x_contractbilling_rec.attribute13 = TAPI_DEV_KIT.G_MISS_CHAR)

824: IF (x_contractbilling_rec.attribute12 = TAPI_DEV_KIT.G_MISS_CHAR)
825: THEN
826: x_contractbilling_rec.attribute12 := l_cs_contracts_billing_pk.attribute12;
827: END IF;
828: IF (x_contractbilling_rec.attribute13 = TAPI_DEV_KIT.G_MISS_CHAR)
829: THEN
830: x_contractbilling_rec.attribute13 := l_cs_contracts_billing_pk.attribute13;
831: END IF;
832: IF (x_contractbilling_rec.attribute14 = TAPI_DEV_KIT.G_MISS_CHAR)

Line 832: IF (x_contractbilling_rec.attribute14 = TAPI_DEV_KIT.G_MISS_CHAR)

828: IF (x_contractbilling_rec.attribute13 = TAPI_DEV_KIT.G_MISS_CHAR)
829: THEN
830: x_contractbilling_rec.attribute13 := l_cs_contracts_billing_pk.attribute13;
831: END IF;
832: IF (x_contractbilling_rec.attribute14 = TAPI_DEV_KIT.G_MISS_CHAR)
833: THEN
834: x_contractbilling_rec.attribute14 := l_cs_contracts_billing_pk.attribute14;
835: END IF;
836: IF (x_contractbilling_rec.attribute15 = TAPI_DEV_KIT.G_MISS_CHAR)

Line 836: IF (x_contractbilling_rec.attribute15 = TAPI_DEV_KIT.G_MISS_CHAR)

832: IF (x_contractbilling_rec.attribute14 = TAPI_DEV_KIT.G_MISS_CHAR)
833: THEN
834: x_contractbilling_rec.attribute14 := l_cs_contracts_billing_pk.attribute14;
835: END IF;
836: IF (x_contractbilling_rec.attribute15 = TAPI_DEV_KIT.G_MISS_CHAR)
837: THEN
838: x_contractbilling_rec.attribute15 := l_cs_contracts_billing_pk.attribute15;
839: END IF;
840: IF (x_contractbilling_rec.context = TAPI_DEV_KIT.G_MISS_CHAR)

Line 840: IF (x_contractbilling_rec.context = TAPI_DEV_KIT.G_MISS_CHAR)

836: IF (x_contractbilling_rec.attribute15 = TAPI_DEV_KIT.G_MISS_CHAR)
837: THEN
838: x_contractbilling_rec.attribute15 := l_cs_contracts_billing_pk.attribute15;
839: END IF;
840: IF (x_contractbilling_rec.context = TAPI_DEV_KIT.G_MISS_CHAR)
841: THEN
842: x_contractbilling_rec.context := l_cs_contracts_billing_pk.context;
843: END IF;
844: IF (x_contractbilling_rec.object_version_number = TAPI_DEV_KIT.G_MISS_NUM)

Line 844: IF (x_contractbilling_rec.object_version_number = TAPI_DEV_KIT.G_MISS_NUM)

840: IF (x_contractbilling_rec.context = TAPI_DEV_KIT.G_MISS_CHAR)
841: THEN
842: x_contractbilling_rec.context := l_cs_contracts_billing_pk.context;
843: END IF;
844: IF (x_contractbilling_rec.object_version_number = TAPI_DEV_KIT.G_MISS_NUM)
845: THEN
846: x_contractbilling_rec.object_version_number := l_cs_contracts_billing_pk.object_version_number;
847: END IF;
848: RETURN(l_return_status);

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

847: END IF;
848: RETURN(l_return_status);
849: END populate_new_record;
850: BEGIN
851: l_return_status := TAPI_DEV_KIT.START_ACTIVITY(l_api_name,
852: G_PKG_NAME,
853: l_api_version,
854: p_api_version,
855: p_init_msg_list,

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

941: WHERE
942: CONTRACT_BILLING_ID = l_def_contractbilling_rec.contract_billing_id
943: ;
944: x_object_version_number := l_def_contractbilling_rec.OBJECT_VERSION_NUMBER;
945: TAPI_DEV_KIT.END_ACTIVITY(p_commit, x_msg_count, x_msg_data);
946: EXCEPTION
947: WHEN FND_API.G_EXC_ERROR THEN
948: x_return_status := TAPI_DEV_KIT.HANDLE_EXCEPTIONS
949: (

Line 948: x_return_status := TAPI_DEV_KIT.HANDLE_EXCEPTIONS

944: x_object_version_number := l_def_contractbilling_rec.OBJECT_VERSION_NUMBER;
945: TAPI_DEV_KIT.END_ACTIVITY(p_commit, x_msg_count, x_msg_data);
946: EXCEPTION
947: WHEN FND_API.G_EXC_ERROR THEN
948: x_return_status := TAPI_DEV_KIT.HANDLE_EXCEPTIONS
949: (
950: l_api_name,
951: G_PKG_NAME,
952: 'FND_API.G_RET_STS_ERROR',

Line 959: x_return_status :=TAPI_DEV_KIT.HANDLE_EXCEPTIONS

955: '_Pvt'
956: );
957: APP_EXCEPTION.RAISE_EXCEPTION;
958: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
959: x_return_status :=TAPI_DEV_KIT.HANDLE_EXCEPTIONS
960: (
961: l_api_name,
962: G_PKG_NAME,
963: 'FND_API.G_RET_STS_UNEXP_ERROR',

Line 969: WHEN TAPI_DEV_KIT.G_EXC_DUP_VAL_ON_INDEX THEN

965: x_msg_data,
966: '_Pvt'
967: );
968: APP_EXCEPTION.RAISE_EXCEPTION;
969: WHEN TAPI_DEV_KIT.G_EXC_DUP_VAL_ON_INDEX THEN
970: x_return_status :=TAPI_DEV_KIT.HANDLE_EXCEPTIONS
971: (
972: l_api_name,
973: G_PKG_NAME,

Line 970: x_return_status :=TAPI_DEV_KIT.HANDLE_EXCEPTIONS

966: '_Pvt'
967: );
968: APP_EXCEPTION.RAISE_EXCEPTION;
969: WHEN TAPI_DEV_KIT.G_EXC_DUP_VAL_ON_INDEX THEN
970: x_return_status :=TAPI_DEV_KIT.HANDLE_EXCEPTIONS
971: (
972: l_api_name,
973: G_PKG_NAME,
974: 'TAPI_DEV_KIT.G_RET_STS_DUP_VAL_ON_INDEX',

Line 974: 'TAPI_DEV_KIT.G_RET_STS_DUP_VAL_ON_INDEX',

970: x_return_status :=TAPI_DEV_KIT.HANDLE_EXCEPTIONS
971: (
972: l_api_name,
973: G_PKG_NAME,
974: 'TAPI_DEV_KIT.G_RET_STS_DUP_VAL_ON_INDEX',
975: x_msg_count,
976: x_msg_data,
977: '_Pvt'
978: );

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

980: END update_row;
981: Procedure update_row
982: (
983: p_api_version IN NUMBER,
984: p_init_msg_list IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
985: p_validation_level IN NUMBER,
986: p_commit IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
987: x_return_status OUT VARCHAR2,
988: x_msg_count OUT NUMBER,

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

982: (
983: p_api_version IN NUMBER,
984: p_init_msg_list IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
985: p_validation_level IN NUMBER,
986: p_commit IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
987: x_return_status OUT VARCHAR2,
988: x_msg_count OUT NUMBER,
989: x_msg_data OUT VARCHAR2,
990: p_contract_billing_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,

Line 990: p_contract_billing_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,

986: p_commit IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
987: x_return_status OUT VARCHAR2,
988: x_msg_count OUT NUMBER,
989: x_msg_data OUT VARCHAR2,
990: p_contract_billing_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
991: p_header_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
992: p_order_number IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
993: p_line_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
994: p_cp_service_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,

Line 991: p_header_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,

987: x_return_status OUT VARCHAR2,
988: x_msg_count OUT NUMBER,
989: x_msg_data OUT VARCHAR2,
990: p_contract_billing_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
991: p_header_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
992: p_order_number IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
993: p_line_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
994: p_cp_service_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
995: p_contract_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,

Line 992: p_order_number IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,

988: x_msg_count OUT NUMBER,
989: x_msg_data OUT VARCHAR2,
990: p_contract_billing_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
991: p_header_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
992: p_order_number IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
993: p_line_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
994: p_cp_service_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
995: p_contract_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
996: p_cust_trx_type_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,

Line 993: p_line_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,

989: x_msg_data OUT VARCHAR2,
990: p_contract_billing_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
991: p_header_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
992: p_order_number IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
993: p_line_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
994: p_cp_service_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
995: p_contract_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
996: p_cust_trx_type_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
997: p_trx_date IN CS_CONTRACTS_BILLING.TRX_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,

Line 994: p_cp_service_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,

990: p_contract_billing_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
991: p_header_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
992: p_order_number IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
993: p_line_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
994: p_cp_service_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
995: p_contract_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
996: p_cust_trx_type_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
997: p_trx_date IN CS_CONTRACTS_BILLING.TRX_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
998: p_trx_number IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,

Line 995: p_contract_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,

991: p_header_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
992: p_order_number IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
993: p_line_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
994: p_cp_service_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
995: p_contract_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
996: p_cust_trx_type_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
997: p_trx_date IN CS_CONTRACTS_BILLING.TRX_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
998: p_trx_number IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
999: p_trx_amount IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,

Line 996: p_cust_trx_type_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,

992: p_order_number IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
993: p_line_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
994: p_cp_service_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
995: p_contract_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
996: p_cust_trx_type_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
997: p_trx_date IN CS_CONTRACTS_BILLING.TRX_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
998: p_trx_number IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
999: p_trx_amount IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1000: p_trx_class IN CS_CONTRACTS_BILLING.TRX_CLASS%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

Line 997: p_trx_date IN CS_CONTRACTS_BILLING.TRX_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,

993: p_line_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
994: p_cp_service_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
995: p_contract_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
996: p_cust_trx_type_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
997: p_trx_date IN CS_CONTRACTS_BILLING.TRX_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
998: p_trx_number IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
999: p_trx_amount IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1000: p_trx_class IN CS_CONTRACTS_BILLING.TRX_CLASS%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1001: p_billed_until_date IN CS_CONTRACTS_BILLING.BILLED_UNTIL_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,

Line 998: p_trx_number IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,

994: p_cp_service_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
995: p_contract_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
996: p_cust_trx_type_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
997: p_trx_date IN CS_CONTRACTS_BILLING.TRX_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
998: p_trx_number IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
999: p_trx_amount IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1000: p_trx_class IN CS_CONTRACTS_BILLING.TRX_CLASS%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1001: p_billed_until_date IN CS_CONTRACTS_BILLING.BILLED_UNTIL_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1002: p_currency_code IN CS_CONTRACTS_BILLING.CURRENCY_CODE%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

Line 999: p_trx_amount IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,

995: p_contract_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
996: p_cust_trx_type_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
997: p_trx_date IN CS_CONTRACTS_BILLING.TRX_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
998: p_trx_number IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
999: p_trx_amount IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1000: p_trx_class IN CS_CONTRACTS_BILLING.TRX_CLASS%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1001: p_billed_until_date IN CS_CONTRACTS_BILLING.BILLED_UNTIL_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1002: p_currency_code IN CS_CONTRACTS_BILLING.CURRENCY_CODE%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1003: p_last_update_date IN CS_CONTRACTS_BILLING.LAST_UPDATE_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,

Line 1000: p_trx_class IN CS_CONTRACTS_BILLING.TRX_CLASS%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

996: p_cust_trx_type_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
997: p_trx_date IN CS_CONTRACTS_BILLING.TRX_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
998: p_trx_number IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
999: p_trx_amount IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1000: p_trx_class IN CS_CONTRACTS_BILLING.TRX_CLASS%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1001: p_billed_until_date IN CS_CONTRACTS_BILLING.BILLED_UNTIL_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1002: p_currency_code IN CS_CONTRACTS_BILLING.CURRENCY_CODE%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1003: p_last_update_date IN CS_CONTRACTS_BILLING.LAST_UPDATE_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1004: p_last_updated_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,

Line 1001: p_billed_until_date IN CS_CONTRACTS_BILLING.BILLED_UNTIL_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,

997: p_trx_date IN CS_CONTRACTS_BILLING.TRX_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
998: p_trx_number IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
999: p_trx_amount IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1000: p_trx_class IN CS_CONTRACTS_BILLING.TRX_CLASS%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1001: p_billed_until_date IN CS_CONTRACTS_BILLING.BILLED_UNTIL_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1002: p_currency_code IN CS_CONTRACTS_BILLING.CURRENCY_CODE%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1003: p_last_update_date IN CS_CONTRACTS_BILLING.LAST_UPDATE_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1004: p_last_updated_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1005: p_creation_date IN CS_CONTRACTS_BILLING.CREATION_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,

Line 1002: p_currency_code IN CS_CONTRACTS_BILLING.CURRENCY_CODE%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

998: p_trx_number IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
999: p_trx_amount IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1000: p_trx_class IN CS_CONTRACTS_BILLING.TRX_CLASS%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1001: p_billed_until_date IN CS_CONTRACTS_BILLING.BILLED_UNTIL_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1002: p_currency_code IN CS_CONTRACTS_BILLING.CURRENCY_CODE%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1003: p_last_update_date IN CS_CONTRACTS_BILLING.LAST_UPDATE_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1004: p_last_updated_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1005: p_creation_date IN CS_CONTRACTS_BILLING.CREATION_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1006: p_created_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,

Line 1003: p_last_update_date IN CS_CONTRACTS_BILLING.LAST_UPDATE_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,

999: p_trx_amount IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1000: p_trx_class IN CS_CONTRACTS_BILLING.TRX_CLASS%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1001: p_billed_until_date IN CS_CONTRACTS_BILLING.BILLED_UNTIL_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1002: p_currency_code IN CS_CONTRACTS_BILLING.CURRENCY_CODE%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1003: p_last_update_date IN CS_CONTRACTS_BILLING.LAST_UPDATE_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1004: p_last_updated_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1005: p_creation_date IN CS_CONTRACTS_BILLING.CREATION_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1006: p_created_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1007: p_last_update_login IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,

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

1000: p_trx_class IN CS_CONTRACTS_BILLING.TRX_CLASS%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1001: p_billed_until_date IN CS_CONTRACTS_BILLING.BILLED_UNTIL_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1002: p_currency_code IN CS_CONTRACTS_BILLING.CURRENCY_CODE%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1003: p_last_update_date IN CS_CONTRACTS_BILLING.LAST_UPDATE_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1004: p_last_updated_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1005: p_creation_date IN CS_CONTRACTS_BILLING.CREATION_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1006: p_created_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1007: p_last_update_login IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1008: p_trx_pre_tax_amount IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,

Line 1005: p_creation_date IN CS_CONTRACTS_BILLING.CREATION_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,

1001: p_billed_until_date IN CS_CONTRACTS_BILLING.BILLED_UNTIL_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1002: p_currency_code IN CS_CONTRACTS_BILLING.CURRENCY_CODE%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1003: p_last_update_date IN CS_CONTRACTS_BILLING.LAST_UPDATE_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1004: p_last_updated_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1005: p_creation_date IN CS_CONTRACTS_BILLING.CREATION_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1006: p_created_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1007: p_last_update_login IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1008: p_trx_pre_tax_amount IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1009: p_attribute1 IN CS_CONTRACTS_BILLING.ATTRIBUTE1%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

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

1002: p_currency_code IN CS_CONTRACTS_BILLING.CURRENCY_CODE%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1003: p_last_update_date IN CS_CONTRACTS_BILLING.LAST_UPDATE_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1004: p_last_updated_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1005: p_creation_date IN CS_CONTRACTS_BILLING.CREATION_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1006: p_created_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1007: p_last_update_login IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1008: p_trx_pre_tax_amount IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1009: p_attribute1 IN CS_CONTRACTS_BILLING.ATTRIBUTE1%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1010: p_attribute2 IN CS_CONTRACTS_BILLING.ATTRIBUTE2%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

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

1003: p_last_update_date IN CS_CONTRACTS_BILLING.LAST_UPDATE_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1004: p_last_updated_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1005: p_creation_date IN CS_CONTRACTS_BILLING.CREATION_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1006: p_created_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1007: p_last_update_login IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1008: p_trx_pre_tax_amount IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1009: p_attribute1 IN CS_CONTRACTS_BILLING.ATTRIBUTE1%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1010: p_attribute2 IN CS_CONTRACTS_BILLING.ATTRIBUTE2%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1011: p_attribute3 IN CS_CONTRACTS_BILLING.ATTRIBUTE3%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

Line 1008: p_trx_pre_tax_amount IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,

1004: p_last_updated_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1005: p_creation_date IN CS_CONTRACTS_BILLING.CREATION_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1006: p_created_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1007: p_last_update_login IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1008: p_trx_pre_tax_amount IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1009: p_attribute1 IN CS_CONTRACTS_BILLING.ATTRIBUTE1%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1010: p_attribute2 IN CS_CONTRACTS_BILLING.ATTRIBUTE2%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1011: p_attribute3 IN CS_CONTRACTS_BILLING.ATTRIBUTE3%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1012: p_attribute4 IN CS_CONTRACTS_BILLING.ATTRIBUTE4%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

Line 1009: p_attribute1 IN CS_CONTRACTS_BILLING.ATTRIBUTE1%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

1005: p_creation_date IN CS_CONTRACTS_BILLING.CREATION_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1006: p_created_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1007: p_last_update_login IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1008: p_trx_pre_tax_amount IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1009: p_attribute1 IN CS_CONTRACTS_BILLING.ATTRIBUTE1%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1010: p_attribute2 IN CS_CONTRACTS_BILLING.ATTRIBUTE2%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1011: p_attribute3 IN CS_CONTRACTS_BILLING.ATTRIBUTE3%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1012: p_attribute4 IN CS_CONTRACTS_BILLING.ATTRIBUTE4%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1013: p_attribute5 IN CS_CONTRACTS_BILLING.ATTRIBUTE5%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

Line 1010: p_attribute2 IN CS_CONTRACTS_BILLING.ATTRIBUTE2%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

1006: p_created_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1007: p_last_update_login IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1008: p_trx_pre_tax_amount IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1009: p_attribute1 IN CS_CONTRACTS_BILLING.ATTRIBUTE1%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1010: p_attribute2 IN CS_CONTRACTS_BILLING.ATTRIBUTE2%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1011: p_attribute3 IN CS_CONTRACTS_BILLING.ATTRIBUTE3%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1012: p_attribute4 IN CS_CONTRACTS_BILLING.ATTRIBUTE4%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1013: p_attribute5 IN CS_CONTRACTS_BILLING.ATTRIBUTE5%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1014: p_attribute6 IN CS_CONTRACTS_BILLING.ATTRIBUTE6%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

Line 1011: p_attribute3 IN CS_CONTRACTS_BILLING.ATTRIBUTE3%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

1007: p_last_update_login IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1008: p_trx_pre_tax_amount IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1009: p_attribute1 IN CS_CONTRACTS_BILLING.ATTRIBUTE1%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1010: p_attribute2 IN CS_CONTRACTS_BILLING.ATTRIBUTE2%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1011: p_attribute3 IN CS_CONTRACTS_BILLING.ATTRIBUTE3%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1012: p_attribute4 IN CS_CONTRACTS_BILLING.ATTRIBUTE4%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1013: p_attribute5 IN CS_CONTRACTS_BILLING.ATTRIBUTE5%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1014: p_attribute6 IN CS_CONTRACTS_BILLING.ATTRIBUTE6%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1015: p_attribute7 IN CS_CONTRACTS_BILLING.ATTRIBUTE7%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

Line 1012: p_attribute4 IN CS_CONTRACTS_BILLING.ATTRIBUTE4%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

1008: p_trx_pre_tax_amount IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1009: p_attribute1 IN CS_CONTRACTS_BILLING.ATTRIBUTE1%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1010: p_attribute2 IN CS_CONTRACTS_BILLING.ATTRIBUTE2%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1011: p_attribute3 IN CS_CONTRACTS_BILLING.ATTRIBUTE3%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1012: p_attribute4 IN CS_CONTRACTS_BILLING.ATTRIBUTE4%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1013: p_attribute5 IN CS_CONTRACTS_BILLING.ATTRIBUTE5%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1014: p_attribute6 IN CS_CONTRACTS_BILLING.ATTRIBUTE6%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1015: p_attribute7 IN CS_CONTRACTS_BILLING.ATTRIBUTE7%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1016: p_attribute8 IN CS_CONTRACTS_BILLING.ATTRIBUTE8%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

Line 1013: p_attribute5 IN CS_CONTRACTS_BILLING.ATTRIBUTE5%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

1009: p_attribute1 IN CS_CONTRACTS_BILLING.ATTRIBUTE1%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1010: p_attribute2 IN CS_CONTRACTS_BILLING.ATTRIBUTE2%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1011: p_attribute3 IN CS_CONTRACTS_BILLING.ATTRIBUTE3%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1012: p_attribute4 IN CS_CONTRACTS_BILLING.ATTRIBUTE4%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1013: p_attribute5 IN CS_CONTRACTS_BILLING.ATTRIBUTE5%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1014: p_attribute6 IN CS_CONTRACTS_BILLING.ATTRIBUTE6%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1015: p_attribute7 IN CS_CONTRACTS_BILLING.ATTRIBUTE7%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1016: p_attribute8 IN CS_CONTRACTS_BILLING.ATTRIBUTE8%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1017: p_attribute9 IN CS_CONTRACTS_BILLING.ATTRIBUTE9%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

Line 1014: p_attribute6 IN CS_CONTRACTS_BILLING.ATTRIBUTE6%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

1010: p_attribute2 IN CS_CONTRACTS_BILLING.ATTRIBUTE2%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1011: p_attribute3 IN CS_CONTRACTS_BILLING.ATTRIBUTE3%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1012: p_attribute4 IN CS_CONTRACTS_BILLING.ATTRIBUTE4%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1013: p_attribute5 IN CS_CONTRACTS_BILLING.ATTRIBUTE5%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1014: p_attribute6 IN CS_CONTRACTS_BILLING.ATTRIBUTE6%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1015: p_attribute7 IN CS_CONTRACTS_BILLING.ATTRIBUTE7%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1016: p_attribute8 IN CS_CONTRACTS_BILLING.ATTRIBUTE8%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1017: p_attribute9 IN CS_CONTRACTS_BILLING.ATTRIBUTE9%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1018: p_attribute10 IN CS_CONTRACTS_BILLING.ATTRIBUTE10%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

Line 1015: p_attribute7 IN CS_CONTRACTS_BILLING.ATTRIBUTE7%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

1011: p_attribute3 IN CS_CONTRACTS_BILLING.ATTRIBUTE3%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1012: p_attribute4 IN CS_CONTRACTS_BILLING.ATTRIBUTE4%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1013: p_attribute5 IN CS_CONTRACTS_BILLING.ATTRIBUTE5%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1014: p_attribute6 IN CS_CONTRACTS_BILLING.ATTRIBUTE6%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1015: p_attribute7 IN CS_CONTRACTS_BILLING.ATTRIBUTE7%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1016: p_attribute8 IN CS_CONTRACTS_BILLING.ATTRIBUTE8%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1017: p_attribute9 IN CS_CONTRACTS_BILLING.ATTRIBUTE9%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1018: p_attribute10 IN CS_CONTRACTS_BILLING.ATTRIBUTE10%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1019: p_attribute11 IN CS_CONTRACTS_BILLING.ATTRIBUTE11%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

Line 1016: p_attribute8 IN CS_CONTRACTS_BILLING.ATTRIBUTE8%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

1012: p_attribute4 IN CS_CONTRACTS_BILLING.ATTRIBUTE4%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1013: p_attribute5 IN CS_CONTRACTS_BILLING.ATTRIBUTE5%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1014: p_attribute6 IN CS_CONTRACTS_BILLING.ATTRIBUTE6%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1015: p_attribute7 IN CS_CONTRACTS_BILLING.ATTRIBUTE7%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1016: p_attribute8 IN CS_CONTRACTS_BILLING.ATTRIBUTE8%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1017: p_attribute9 IN CS_CONTRACTS_BILLING.ATTRIBUTE9%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1018: p_attribute10 IN CS_CONTRACTS_BILLING.ATTRIBUTE10%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1019: p_attribute11 IN CS_CONTRACTS_BILLING.ATTRIBUTE11%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1020: p_attribute12 IN CS_CONTRACTS_BILLING.ATTRIBUTE12%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

Line 1017: p_attribute9 IN CS_CONTRACTS_BILLING.ATTRIBUTE9%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

1013: p_attribute5 IN CS_CONTRACTS_BILLING.ATTRIBUTE5%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1014: p_attribute6 IN CS_CONTRACTS_BILLING.ATTRIBUTE6%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1015: p_attribute7 IN CS_CONTRACTS_BILLING.ATTRIBUTE7%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1016: p_attribute8 IN CS_CONTRACTS_BILLING.ATTRIBUTE8%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1017: p_attribute9 IN CS_CONTRACTS_BILLING.ATTRIBUTE9%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1018: p_attribute10 IN CS_CONTRACTS_BILLING.ATTRIBUTE10%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1019: p_attribute11 IN CS_CONTRACTS_BILLING.ATTRIBUTE11%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1020: p_attribute12 IN CS_CONTRACTS_BILLING.ATTRIBUTE12%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1021: p_attribute13 IN CS_CONTRACTS_BILLING.ATTRIBUTE13%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

Line 1018: p_attribute10 IN CS_CONTRACTS_BILLING.ATTRIBUTE10%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

1014: p_attribute6 IN CS_CONTRACTS_BILLING.ATTRIBUTE6%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1015: p_attribute7 IN CS_CONTRACTS_BILLING.ATTRIBUTE7%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1016: p_attribute8 IN CS_CONTRACTS_BILLING.ATTRIBUTE8%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1017: p_attribute9 IN CS_CONTRACTS_BILLING.ATTRIBUTE9%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1018: p_attribute10 IN CS_CONTRACTS_BILLING.ATTRIBUTE10%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1019: p_attribute11 IN CS_CONTRACTS_BILLING.ATTRIBUTE11%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1020: p_attribute12 IN CS_CONTRACTS_BILLING.ATTRIBUTE12%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1021: p_attribute13 IN CS_CONTRACTS_BILLING.ATTRIBUTE13%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1022: p_attribute14 IN CS_CONTRACTS_BILLING.ATTRIBUTE14%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

Line 1019: p_attribute11 IN CS_CONTRACTS_BILLING.ATTRIBUTE11%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

1015: p_attribute7 IN CS_CONTRACTS_BILLING.ATTRIBUTE7%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1016: p_attribute8 IN CS_CONTRACTS_BILLING.ATTRIBUTE8%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1017: p_attribute9 IN CS_CONTRACTS_BILLING.ATTRIBUTE9%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1018: p_attribute10 IN CS_CONTRACTS_BILLING.ATTRIBUTE10%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1019: p_attribute11 IN CS_CONTRACTS_BILLING.ATTRIBUTE11%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1020: p_attribute12 IN CS_CONTRACTS_BILLING.ATTRIBUTE12%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1021: p_attribute13 IN CS_CONTRACTS_BILLING.ATTRIBUTE13%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1022: p_attribute14 IN CS_CONTRACTS_BILLING.ATTRIBUTE14%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1023: p_attribute15 IN CS_CONTRACTS_BILLING.ATTRIBUTE15%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

Line 1020: p_attribute12 IN CS_CONTRACTS_BILLING.ATTRIBUTE12%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

1016: p_attribute8 IN CS_CONTRACTS_BILLING.ATTRIBUTE8%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1017: p_attribute9 IN CS_CONTRACTS_BILLING.ATTRIBUTE9%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1018: p_attribute10 IN CS_CONTRACTS_BILLING.ATTRIBUTE10%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1019: p_attribute11 IN CS_CONTRACTS_BILLING.ATTRIBUTE11%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1020: p_attribute12 IN CS_CONTRACTS_BILLING.ATTRIBUTE12%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1021: p_attribute13 IN CS_CONTRACTS_BILLING.ATTRIBUTE13%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1022: p_attribute14 IN CS_CONTRACTS_BILLING.ATTRIBUTE14%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1023: p_attribute15 IN CS_CONTRACTS_BILLING.ATTRIBUTE15%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1024: p_context IN CS_CONTRACTS_BILLING.CONTEXT%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

Line 1021: p_attribute13 IN CS_CONTRACTS_BILLING.ATTRIBUTE13%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

1017: p_attribute9 IN CS_CONTRACTS_BILLING.ATTRIBUTE9%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1018: p_attribute10 IN CS_CONTRACTS_BILLING.ATTRIBUTE10%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1019: p_attribute11 IN CS_CONTRACTS_BILLING.ATTRIBUTE11%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1020: p_attribute12 IN CS_CONTRACTS_BILLING.ATTRIBUTE12%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1021: p_attribute13 IN CS_CONTRACTS_BILLING.ATTRIBUTE13%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1022: p_attribute14 IN CS_CONTRACTS_BILLING.ATTRIBUTE14%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1023: p_attribute15 IN CS_CONTRACTS_BILLING.ATTRIBUTE15%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1024: p_context IN CS_CONTRACTS_BILLING.CONTEXT%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1025: p_object_version_number IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,

Line 1022: p_attribute14 IN CS_CONTRACTS_BILLING.ATTRIBUTE14%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

1018: p_attribute10 IN CS_CONTRACTS_BILLING.ATTRIBUTE10%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1019: p_attribute11 IN CS_CONTRACTS_BILLING.ATTRIBUTE11%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1020: p_attribute12 IN CS_CONTRACTS_BILLING.ATTRIBUTE12%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1021: p_attribute13 IN CS_CONTRACTS_BILLING.ATTRIBUTE13%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1022: p_attribute14 IN CS_CONTRACTS_BILLING.ATTRIBUTE14%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1023: p_attribute15 IN CS_CONTRACTS_BILLING.ATTRIBUTE15%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1024: p_context IN CS_CONTRACTS_BILLING.CONTEXT%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1025: p_object_version_number IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1026: x_object_version_number OUT NUMBER) IS

Line 1023: p_attribute15 IN CS_CONTRACTS_BILLING.ATTRIBUTE15%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

1019: p_attribute11 IN CS_CONTRACTS_BILLING.ATTRIBUTE11%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1020: p_attribute12 IN CS_CONTRACTS_BILLING.ATTRIBUTE12%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1021: p_attribute13 IN CS_CONTRACTS_BILLING.ATTRIBUTE13%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1022: p_attribute14 IN CS_CONTRACTS_BILLING.ATTRIBUTE14%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1023: p_attribute15 IN CS_CONTRACTS_BILLING.ATTRIBUTE15%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1024: p_context IN CS_CONTRACTS_BILLING.CONTEXT%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1025: p_object_version_number IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1026: x_object_version_number OUT NUMBER) IS
1027: l_api_name CONSTANT VARCHAR2(30) := 'update_row';

Line 1024: p_context IN CS_CONTRACTS_BILLING.CONTEXT%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

1020: p_attribute12 IN CS_CONTRACTS_BILLING.ATTRIBUTE12%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1021: p_attribute13 IN CS_CONTRACTS_BILLING.ATTRIBUTE13%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1022: p_attribute14 IN CS_CONTRACTS_BILLING.ATTRIBUTE14%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1023: p_attribute15 IN CS_CONTRACTS_BILLING.ATTRIBUTE15%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1024: p_context IN CS_CONTRACTS_BILLING.CONTEXT%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1025: p_object_version_number IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1026: x_object_version_number OUT NUMBER) IS
1027: l_api_name CONSTANT VARCHAR2(30) := 'update_row';
1028: l_api_version CONSTANT NUMBER := 1;

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

1021: p_attribute13 IN CS_CONTRACTS_BILLING.ATTRIBUTE13%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1022: p_attribute14 IN CS_CONTRACTS_BILLING.ATTRIBUTE14%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1023: p_attribute15 IN CS_CONTRACTS_BILLING.ATTRIBUTE15%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1024: p_context IN CS_CONTRACTS_BILLING.CONTEXT%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1025: p_object_version_number IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1026: x_object_version_number OUT NUMBER) IS
1027: l_api_name CONSTANT VARCHAR2(30) := 'update_row';
1028: l_api_version CONSTANT NUMBER := 1;
1029: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;

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

1028: l_api_version CONSTANT NUMBER := 1;
1029: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
1030: l_contractbilling_rec ContractBilling_Val_Rec_Type;
1031: BEGIN
1032: l_return_status := TAPI_DEV_KIT.START_ACTIVITY(l_api_name,
1033: G_PKG_NAME,
1034: l_api_version,
1035: p_api_version,
1036: p_init_msg_list,

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

1087: x_msg_data,
1088: l_contractbilling_rec,
1089: x_object_version_number
1090: );
1091: TAPI_DEV_KIT.END_ACTIVITY(p_commit, x_msg_count, x_msg_data);
1092: EXCEPTION
1093: WHEN FND_API.G_EXC_ERROR THEN
1094: x_return_status := TAPI_DEV_KIT.HANDLE_EXCEPTIONS
1095: (

Line 1094: x_return_status := TAPI_DEV_KIT.HANDLE_EXCEPTIONS

1090: );
1091: TAPI_DEV_KIT.END_ACTIVITY(p_commit, x_msg_count, x_msg_data);
1092: EXCEPTION
1093: WHEN FND_API.G_EXC_ERROR THEN
1094: x_return_status := TAPI_DEV_KIT.HANDLE_EXCEPTIONS
1095: (
1096: l_api_name,
1097: G_PKG_NAME,
1098: 'FND_API.G_RET_STS_ERROR',

Line 1105: x_return_status :=TAPI_DEV_KIT.HANDLE_EXCEPTIONS

1101: '_Pvt'
1102: );
1103: APP_EXCEPTION.RAISE_EXCEPTION;
1104: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1105: x_return_status :=TAPI_DEV_KIT.HANDLE_EXCEPTIONS
1106: (
1107: l_api_name,
1108: G_PKG_NAME,
1109: 'FND_API.G_RET_STS_UNEXP_ERROR',

Line 1115: WHEN TAPI_DEV_KIT.G_EXC_DUP_VAL_ON_INDEX THEN

1111: x_msg_data,
1112: '_Pvt'
1113: );
1114: APP_EXCEPTION.RAISE_EXCEPTION;
1115: WHEN TAPI_DEV_KIT.G_EXC_DUP_VAL_ON_INDEX THEN
1116: x_return_status :=TAPI_DEV_KIT.HANDLE_EXCEPTIONS
1117: (
1118: l_api_name,
1119: G_PKG_NAME,

Line 1116: x_return_status :=TAPI_DEV_KIT.HANDLE_EXCEPTIONS

1112: '_Pvt'
1113: );
1114: APP_EXCEPTION.RAISE_EXCEPTION;
1115: WHEN TAPI_DEV_KIT.G_EXC_DUP_VAL_ON_INDEX THEN
1116: x_return_status :=TAPI_DEV_KIT.HANDLE_EXCEPTIONS
1117: (
1118: l_api_name,
1119: G_PKG_NAME,
1120: 'TAPI_DEV_KIT.G_RET_STS_DUP_VAL_ON_INDEX',

Line 1120: 'TAPI_DEV_KIT.G_RET_STS_DUP_VAL_ON_INDEX',

1116: x_return_status :=TAPI_DEV_KIT.HANDLE_EXCEPTIONS
1117: (
1118: l_api_name,
1119: G_PKG_NAME,
1120: 'TAPI_DEV_KIT.G_RET_STS_DUP_VAL_ON_INDEX',
1121: x_msg_count,
1122: x_msg_data,
1123: '_Pvt'
1124: );

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

1126: END update_row;
1127: Procedure delete_row
1128: (
1129: p_api_version IN NUMBER,
1130: p_init_msg_list IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
1131: p_validation_level IN NUMBER,
1132: p_commit IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
1133: x_return_status OUT VARCHAR2,
1134: x_msg_count OUT NUMBER,

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

1128: (
1129: p_api_version IN NUMBER,
1130: p_init_msg_list IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
1131: p_validation_level IN NUMBER,
1132: p_commit IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
1133: x_return_status OUT VARCHAR2,
1134: x_msg_count OUT NUMBER,
1135: x_msg_data OUT VARCHAR2,
1136: p_contract_billing_id IN NUMBER) IS

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

1137: l_api_name CONSTANT VARCHAR2(30) := 'delete_row';
1138: l_api_version CONSTANT NUMBER := 1;
1139: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
1140: BEGIN
1141: l_return_status := TAPI_DEV_KIT.START_ACTIVITY(l_api_name,
1142: G_PKG_NAME,
1143: l_api_version,
1144: p_api_version,
1145: p_init_msg_list,

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

1153: DELETE FROM CS_CONTRACTS_BILLING
1154: WHERE
1155: CONTRACT_BILLING_ID = p_contract_billing_id
1156: ;
1157: TAPI_DEV_KIT.END_ACTIVITY(p_commit, x_msg_count, x_msg_data);
1158: EXCEPTION
1159: WHEN FND_API.G_EXC_ERROR THEN
1160: x_return_status := TAPI_DEV_KIT.HANDLE_EXCEPTIONS
1161: (

Line 1160: x_return_status := TAPI_DEV_KIT.HANDLE_EXCEPTIONS

1156: ;
1157: TAPI_DEV_KIT.END_ACTIVITY(p_commit, x_msg_count, x_msg_data);
1158: EXCEPTION
1159: WHEN FND_API.G_EXC_ERROR THEN
1160: x_return_status := TAPI_DEV_KIT.HANDLE_EXCEPTIONS
1161: (
1162: l_api_name,
1163: G_PKG_NAME,
1164: 'FND_API.G_RET_STS_ERROR',

Line 1171: x_return_status :=TAPI_DEV_KIT.HANDLE_EXCEPTIONS

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

Line 1181: WHEN TAPI_DEV_KIT.G_EXC_DUP_VAL_ON_INDEX THEN

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

Line 1182: x_return_status :=TAPI_DEV_KIT.HANDLE_EXCEPTIONS

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

Line 1186: 'TAPI_DEV_KIT.G_RET_STS_DUP_VAL_ON_INDEX',

1182: x_return_status :=TAPI_DEV_KIT.HANDLE_EXCEPTIONS
1183: (
1184: l_api_name,
1185: G_PKG_NAME,
1186: 'TAPI_DEV_KIT.G_RET_STS_DUP_VAL_ON_INDEX',
1187: x_msg_count,
1188: x_msg_data,
1189: '_Pvt'
1190: );

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

1192: END delete_row;
1193: PROCEDURE validate_row
1194: (
1195: p_api_version IN NUMBER,
1196: p_init_msg_list IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
1197: p_validation_level IN NUMBER,
1198: p_commit IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
1199: x_return_status OUT VARCHAR2,
1200: x_msg_count OUT NUMBER,

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

1194: (
1195: p_api_version IN NUMBER,
1196: p_init_msg_list IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
1197: p_validation_level IN NUMBER,
1198: p_commit IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
1199: x_return_status OUT VARCHAR2,
1200: x_msg_count OUT NUMBER,
1201: x_msg_data OUT VARCHAR2,
1202: p_contractbilling_val_rec IN ContractBilling_Val_Rec_Type := G_MISS_CONTRACTBILLING_VAL_REC) IS

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

1205: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
1206: l_contractbilling_rec ContractBilling_Rec_Type;
1207: l_def_contractbilling_rec ContractBilling_Rec_Type;
1208: BEGIN
1209: l_return_status := TAPI_DEV_KIT.START_ACTIVITY(l_api_name,
1210: G_PKG_NAME,
1211: l_api_version,
1212: p_api_version,
1213: p_init_msg_list,

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

1239: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
1240: RAISE FND_API.G_EXC_ERROR;
1241: END IF;
1242: END IF;
1243: TAPI_DEV_KIT.END_ACTIVITY(p_commit, x_msg_count, x_msg_data);
1244: EXCEPTION
1245: WHEN FND_API.G_EXC_ERROR THEN
1246: x_return_status := TAPI_DEV_KIT.HANDLE_EXCEPTIONS
1247: (

Line 1246: x_return_status := TAPI_DEV_KIT.HANDLE_EXCEPTIONS

1242: END IF;
1243: TAPI_DEV_KIT.END_ACTIVITY(p_commit, x_msg_count, x_msg_data);
1244: EXCEPTION
1245: WHEN FND_API.G_EXC_ERROR THEN
1246: x_return_status := TAPI_DEV_KIT.HANDLE_EXCEPTIONS
1247: (
1248: l_api_name,
1249: G_PKG_NAME,
1250: 'FND_API.G_RET_STS_ERROR',

Line 1257: x_return_status :=TAPI_DEV_KIT.HANDLE_EXCEPTIONS

1253: '_Pvt'
1254: );
1255: APP_EXCEPTION.RAISE_EXCEPTION;
1256: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1257: x_return_status :=TAPI_DEV_KIT.HANDLE_EXCEPTIONS
1258: (
1259: l_api_name,
1260: G_PKG_NAME,
1261: 'FND_API.G_RET_STS_UNEXP_ERROR',

Line 1267: WHEN TAPI_DEV_KIT.G_EXC_DUP_VAL_ON_INDEX THEN

1263: x_msg_data,
1264: '_Pvt'
1265: );
1266: APP_EXCEPTION.RAISE_EXCEPTION;
1267: WHEN TAPI_DEV_KIT.G_EXC_DUP_VAL_ON_INDEX THEN
1268: x_return_status :=TAPI_DEV_KIT.HANDLE_EXCEPTIONS
1269: (
1270: l_api_name,
1271: G_PKG_NAME,

Line 1268: x_return_status :=TAPI_DEV_KIT.HANDLE_EXCEPTIONS

1264: '_Pvt'
1265: );
1266: APP_EXCEPTION.RAISE_EXCEPTION;
1267: WHEN TAPI_DEV_KIT.G_EXC_DUP_VAL_ON_INDEX THEN
1268: x_return_status :=TAPI_DEV_KIT.HANDLE_EXCEPTIONS
1269: (
1270: l_api_name,
1271: G_PKG_NAME,
1272: 'TAPI_DEV_KIT.G_RET_STS_DUP_VAL_ON_INDEX',

Line 1272: 'TAPI_DEV_KIT.G_RET_STS_DUP_VAL_ON_INDEX',

1268: x_return_status :=TAPI_DEV_KIT.HANDLE_EXCEPTIONS
1269: (
1270: l_api_name,
1271: G_PKG_NAME,
1272: 'TAPI_DEV_KIT.G_RET_STS_DUP_VAL_ON_INDEX',
1273: x_msg_count,
1274: x_msg_data,
1275: '_Pvt'
1276: );

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

1278: END validate_row;
1279: PROCEDURE validate_row
1280: (
1281: p_api_version IN NUMBER,
1282: p_init_msg_list IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
1283: p_validation_level IN NUMBER,
1284: p_commit IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
1285: x_return_status OUT VARCHAR2,
1286: x_msg_count OUT NUMBER,

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

1280: (
1281: p_api_version IN NUMBER,
1282: p_init_msg_list IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
1283: p_validation_level IN NUMBER,
1284: p_commit IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
1285: x_return_status OUT VARCHAR2,
1286: x_msg_count OUT NUMBER,
1287: x_msg_data OUT VARCHAR2,
1288: p_contract_billing_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,

Line 1288: p_contract_billing_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,

1284: p_commit IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
1285: x_return_status OUT VARCHAR2,
1286: x_msg_count OUT NUMBER,
1287: x_msg_data OUT VARCHAR2,
1288: p_contract_billing_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1289: p_header_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1290: p_order_number IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1291: p_line_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1292: p_cp_service_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,

Line 1289: p_header_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,

1285: x_return_status OUT VARCHAR2,
1286: x_msg_count OUT NUMBER,
1287: x_msg_data OUT VARCHAR2,
1288: p_contract_billing_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1289: p_header_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1290: p_order_number IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1291: p_line_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1292: p_cp_service_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1293: p_contract_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,

Line 1290: p_order_number IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,

1286: x_msg_count OUT NUMBER,
1287: x_msg_data OUT VARCHAR2,
1288: p_contract_billing_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1289: p_header_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1290: p_order_number IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1291: p_line_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1292: p_cp_service_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1293: p_contract_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1294: p_cust_trx_type_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,

Line 1291: p_line_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,

1287: x_msg_data OUT VARCHAR2,
1288: p_contract_billing_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1289: p_header_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1290: p_order_number IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1291: p_line_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1292: p_cp_service_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1293: p_contract_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1294: p_cust_trx_type_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1295: p_trx_date IN CS_CONTRACTS_BILLING.TRX_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,

Line 1292: p_cp_service_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,

1288: p_contract_billing_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1289: p_header_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1290: p_order_number IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1291: p_line_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1292: p_cp_service_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1293: p_contract_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1294: p_cust_trx_type_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1295: p_trx_date IN CS_CONTRACTS_BILLING.TRX_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1296: p_trx_number IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,

Line 1293: p_contract_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,

1289: p_header_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1290: p_order_number IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1291: p_line_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1292: p_cp_service_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1293: p_contract_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1294: p_cust_trx_type_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1295: p_trx_date IN CS_CONTRACTS_BILLING.TRX_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1296: p_trx_number IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1297: p_trx_amount IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,

Line 1294: p_cust_trx_type_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,

1290: p_order_number IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1291: p_line_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1292: p_cp_service_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1293: p_contract_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1294: p_cust_trx_type_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1295: p_trx_date IN CS_CONTRACTS_BILLING.TRX_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1296: p_trx_number IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1297: p_trx_amount IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1298: p_trx_class IN CS_CONTRACTS_BILLING.TRX_CLASS%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

Line 1295: p_trx_date IN CS_CONTRACTS_BILLING.TRX_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,

1291: p_line_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1292: p_cp_service_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1293: p_contract_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1294: p_cust_trx_type_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1295: p_trx_date IN CS_CONTRACTS_BILLING.TRX_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1296: p_trx_number IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1297: p_trx_amount IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1298: p_trx_class IN CS_CONTRACTS_BILLING.TRX_CLASS%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1299: p_billed_until_date IN CS_CONTRACTS_BILLING.BILLED_UNTIL_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,

Line 1296: p_trx_number IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,

1292: p_cp_service_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1293: p_contract_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1294: p_cust_trx_type_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1295: p_trx_date IN CS_CONTRACTS_BILLING.TRX_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1296: p_trx_number IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1297: p_trx_amount IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1298: p_trx_class IN CS_CONTRACTS_BILLING.TRX_CLASS%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1299: p_billed_until_date IN CS_CONTRACTS_BILLING.BILLED_UNTIL_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1300: p_currency_code IN CS_CONTRACTS_BILLING.CURRENCY_CODE%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

Line 1297: p_trx_amount IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,

1293: p_contract_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1294: p_cust_trx_type_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1295: p_trx_date IN CS_CONTRACTS_BILLING.TRX_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1296: p_trx_number IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1297: p_trx_amount IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1298: p_trx_class IN CS_CONTRACTS_BILLING.TRX_CLASS%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1299: p_billed_until_date IN CS_CONTRACTS_BILLING.BILLED_UNTIL_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1300: p_currency_code IN CS_CONTRACTS_BILLING.CURRENCY_CODE%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1301: p_last_update_date IN CS_CONTRACTS_BILLING.LAST_UPDATE_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,

Line 1298: p_trx_class IN CS_CONTRACTS_BILLING.TRX_CLASS%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

1294: p_cust_trx_type_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1295: p_trx_date IN CS_CONTRACTS_BILLING.TRX_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1296: p_trx_number IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1297: p_trx_amount IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1298: p_trx_class IN CS_CONTRACTS_BILLING.TRX_CLASS%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1299: p_billed_until_date IN CS_CONTRACTS_BILLING.BILLED_UNTIL_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1300: p_currency_code IN CS_CONTRACTS_BILLING.CURRENCY_CODE%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1301: p_last_update_date IN CS_CONTRACTS_BILLING.LAST_UPDATE_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1302: p_last_updated_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,

Line 1299: p_billed_until_date IN CS_CONTRACTS_BILLING.BILLED_UNTIL_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,

1295: p_trx_date IN CS_CONTRACTS_BILLING.TRX_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1296: p_trx_number IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1297: p_trx_amount IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1298: p_trx_class IN CS_CONTRACTS_BILLING.TRX_CLASS%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1299: p_billed_until_date IN CS_CONTRACTS_BILLING.BILLED_UNTIL_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1300: p_currency_code IN CS_CONTRACTS_BILLING.CURRENCY_CODE%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1301: p_last_update_date IN CS_CONTRACTS_BILLING.LAST_UPDATE_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1302: p_last_updated_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1303: p_creation_date IN CS_CONTRACTS_BILLING.CREATION_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,

Line 1300: p_currency_code IN CS_CONTRACTS_BILLING.CURRENCY_CODE%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

1296: p_trx_number IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1297: p_trx_amount IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1298: p_trx_class IN CS_CONTRACTS_BILLING.TRX_CLASS%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1299: p_billed_until_date IN CS_CONTRACTS_BILLING.BILLED_UNTIL_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1300: p_currency_code IN CS_CONTRACTS_BILLING.CURRENCY_CODE%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1301: p_last_update_date IN CS_CONTRACTS_BILLING.LAST_UPDATE_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1302: p_last_updated_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1303: p_creation_date IN CS_CONTRACTS_BILLING.CREATION_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1304: p_created_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,

Line 1301: p_last_update_date IN CS_CONTRACTS_BILLING.LAST_UPDATE_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,

1297: p_trx_amount IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1298: p_trx_class IN CS_CONTRACTS_BILLING.TRX_CLASS%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1299: p_billed_until_date IN CS_CONTRACTS_BILLING.BILLED_UNTIL_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1300: p_currency_code IN CS_CONTRACTS_BILLING.CURRENCY_CODE%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1301: p_last_update_date IN CS_CONTRACTS_BILLING.LAST_UPDATE_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1302: p_last_updated_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1303: p_creation_date IN CS_CONTRACTS_BILLING.CREATION_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1304: p_created_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1305: p_last_update_login IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,

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

1298: p_trx_class IN CS_CONTRACTS_BILLING.TRX_CLASS%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1299: p_billed_until_date IN CS_CONTRACTS_BILLING.BILLED_UNTIL_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1300: p_currency_code IN CS_CONTRACTS_BILLING.CURRENCY_CODE%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1301: p_last_update_date IN CS_CONTRACTS_BILLING.LAST_UPDATE_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1302: p_last_updated_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1303: p_creation_date IN CS_CONTRACTS_BILLING.CREATION_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1304: p_created_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1305: p_last_update_login IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1306: p_trx_pre_tax_amount IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,

Line 1303: p_creation_date IN CS_CONTRACTS_BILLING.CREATION_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,

1299: p_billed_until_date IN CS_CONTRACTS_BILLING.BILLED_UNTIL_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1300: p_currency_code IN CS_CONTRACTS_BILLING.CURRENCY_CODE%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1301: p_last_update_date IN CS_CONTRACTS_BILLING.LAST_UPDATE_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1302: p_last_updated_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1303: p_creation_date IN CS_CONTRACTS_BILLING.CREATION_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1304: p_created_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1305: p_last_update_login IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1306: p_trx_pre_tax_amount IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1307: p_attribute1 IN CS_CONTRACTS_BILLING.ATTRIBUTE1%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

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

1300: p_currency_code IN CS_CONTRACTS_BILLING.CURRENCY_CODE%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1301: p_last_update_date IN CS_CONTRACTS_BILLING.LAST_UPDATE_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1302: p_last_updated_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1303: p_creation_date IN CS_CONTRACTS_BILLING.CREATION_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1304: p_created_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1305: p_last_update_login IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1306: p_trx_pre_tax_amount IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1307: p_attribute1 IN CS_CONTRACTS_BILLING.ATTRIBUTE1%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1308: p_attribute2 IN CS_CONTRACTS_BILLING.ATTRIBUTE2%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

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

1301: p_last_update_date IN CS_CONTRACTS_BILLING.LAST_UPDATE_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1302: p_last_updated_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1303: p_creation_date IN CS_CONTRACTS_BILLING.CREATION_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1304: p_created_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1305: p_last_update_login IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1306: p_trx_pre_tax_amount IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1307: p_attribute1 IN CS_CONTRACTS_BILLING.ATTRIBUTE1%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1308: p_attribute2 IN CS_CONTRACTS_BILLING.ATTRIBUTE2%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1309: p_attribute3 IN CS_CONTRACTS_BILLING.ATTRIBUTE3%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

Line 1306: p_trx_pre_tax_amount IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,

1302: p_last_updated_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1303: p_creation_date IN CS_CONTRACTS_BILLING.CREATION_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1304: p_created_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1305: p_last_update_login IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1306: p_trx_pre_tax_amount IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1307: p_attribute1 IN CS_CONTRACTS_BILLING.ATTRIBUTE1%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1308: p_attribute2 IN CS_CONTRACTS_BILLING.ATTRIBUTE2%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1309: p_attribute3 IN CS_CONTRACTS_BILLING.ATTRIBUTE3%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1310: p_attribute4 IN CS_CONTRACTS_BILLING.ATTRIBUTE4%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

Line 1307: p_attribute1 IN CS_CONTRACTS_BILLING.ATTRIBUTE1%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

1303: p_creation_date IN CS_CONTRACTS_BILLING.CREATION_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1304: p_created_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1305: p_last_update_login IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1306: p_trx_pre_tax_amount IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1307: p_attribute1 IN CS_CONTRACTS_BILLING.ATTRIBUTE1%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1308: p_attribute2 IN CS_CONTRACTS_BILLING.ATTRIBUTE2%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1309: p_attribute3 IN CS_CONTRACTS_BILLING.ATTRIBUTE3%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1310: p_attribute4 IN CS_CONTRACTS_BILLING.ATTRIBUTE4%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1311: p_attribute5 IN CS_CONTRACTS_BILLING.ATTRIBUTE5%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

Line 1308: p_attribute2 IN CS_CONTRACTS_BILLING.ATTRIBUTE2%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

1304: p_created_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1305: p_last_update_login IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1306: p_trx_pre_tax_amount IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1307: p_attribute1 IN CS_CONTRACTS_BILLING.ATTRIBUTE1%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1308: p_attribute2 IN CS_CONTRACTS_BILLING.ATTRIBUTE2%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1309: p_attribute3 IN CS_CONTRACTS_BILLING.ATTRIBUTE3%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1310: p_attribute4 IN CS_CONTRACTS_BILLING.ATTRIBUTE4%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1311: p_attribute5 IN CS_CONTRACTS_BILLING.ATTRIBUTE5%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1312: p_attribute6 IN CS_CONTRACTS_BILLING.ATTRIBUTE6%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

Line 1309: p_attribute3 IN CS_CONTRACTS_BILLING.ATTRIBUTE3%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

1305: p_last_update_login IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1306: p_trx_pre_tax_amount IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1307: p_attribute1 IN CS_CONTRACTS_BILLING.ATTRIBUTE1%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1308: p_attribute2 IN CS_CONTRACTS_BILLING.ATTRIBUTE2%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1309: p_attribute3 IN CS_CONTRACTS_BILLING.ATTRIBUTE3%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1310: p_attribute4 IN CS_CONTRACTS_BILLING.ATTRIBUTE4%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1311: p_attribute5 IN CS_CONTRACTS_BILLING.ATTRIBUTE5%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1312: p_attribute6 IN CS_CONTRACTS_BILLING.ATTRIBUTE6%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1313: p_attribute7 IN CS_CONTRACTS_BILLING.ATTRIBUTE7%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

Line 1310: p_attribute4 IN CS_CONTRACTS_BILLING.ATTRIBUTE4%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

1306: p_trx_pre_tax_amount IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1307: p_attribute1 IN CS_CONTRACTS_BILLING.ATTRIBUTE1%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1308: p_attribute2 IN CS_CONTRACTS_BILLING.ATTRIBUTE2%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1309: p_attribute3 IN CS_CONTRACTS_BILLING.ATTRIBUTE3%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1310: p_attribute4 IN CS_CONTRACTS_BILLING.ATTRIBUTE4%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1311: p_attribute5 IN CS_CONTRACTS_BILLING.ATTRIBUTE5%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1312: p_attribute6 IN CS_CONTRACTS_BILLING.ATTRIBUTE6%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1313: p_attribute7 IN CS_CONTRACTS_BILLING.ATTRIBUTE7%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1314: p_attribute8 IN CS_CONTRACTS_BILLING.ATTRIBUTE8%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

Line 1311: p_attribute5 IN CS_CONTRACTS_BILLING.ATTRIBUTE5%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

1307: p_attribute1 IN CS_CONTRACTS_BILLING.ATTRIBUTE1%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1308: p_attribute2 IN CS_CONTRACTS_BILLING.ATTRIBUTE2%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1309: p_attribute3 IN CS_CONTRACTS_BILLING.ATTRIBUTE3%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1310: p_attribute4 IN CS_CONTRACTS_BILLING.ATTRIBUTE4%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1311: p_attribute5 IN CS_CONTRACTS_BILLING.ATTRIBUTE5%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1312: p_attribute6 IN CS_CONTRACTS_BILLING.ATTRIBUTE6%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1313: p_attribute7 IN CS_CONTRACTS_BILLING.ATTRIBUTE7%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1314: p_attribute8 IN CS_CONTRACTS_BILLING.ATTRIBUTE8%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1315: p_attribute9 IN CS_CONTRACTS_BILLING.ATTRIBUTE9%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

Line 1312: p_attribute6 IN CS_CONTRACTS_BILLING.ATTRIBUTE6%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

1308: p_attribute2 IN CS_CONTRACTS_BILLING.ATTRIBUTE2%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1309: p_attribute3 IN CS_CONTRACTS_BILLING.ATTRIBUTE3%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1310: p_attribute4 IN CS_CONTRACTS_BILLING.ATTRIBUTE4%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1311: p_attribute5 IN CS_CONTRACTS_BILLING.ATTRIBUTE5%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1312: p_attribute6 IN CS_CONTRACTS_BILLING.ATTRIBUTE6%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1313: p_attribute7 IN CS_CONTRACTS_BILLING.ATTRIBUTE7%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1314: p_attribute8 IN CS_CONTRACTS_BILLING.ATTRIBUTE8%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1315: p_attribute9 IN CS_CONTRACTS_BILLING.ATTRIBUTE9%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1316: p_attribute10 IN CS_CONTRACTS_BILLING.ATTRIBUTE10%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

Line 1313: p_attribute7 IN CS_CONTRACTS_BILLING.ATTRIBUTE7%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

1309: p_attribute3 IN CS_CONTRACTS_BILLING.ATTRIBUTE3%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1310: p_attribute4 IN CS_CONTRACTS_BILLING.ATTRIBUTE4%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1311: p_attribute5 IN CS_CONTRACTS_BILLING.ATTRIBUTE5%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1312: p_attribute6 IN CS_CONTRACTS_BILLING.ATTRIBUTE6%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1313: p_attribute7 IN CS_CONTRACTS_BILLING.ATTRIBUTE7%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1314: p_attribute8 IN CS_CONTRACTS_BILLING.ATTRIBUTE8%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1315: p_attribute9 IN CS_CONTRACTS_BILLING.ATTRIBUTE9%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1316: p_attribute10 IN CS_CONTRACTS_BILLING.ATTRIBUTE10%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1317: p_attribute11 IN CS_CONTRACTS_BILLING.ATTRIBUTE11%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

Line 1314: p_attribute8 IN CS_CONTRACTS_BILLING.ATTRIBUTE8%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

1310: p_attribute4 IN CS_CONTRACTS_BILLING.ATTRIBUTE4%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1311: p_attribute5 IN CS_CONTRACTS_BILLING.ATTRIBUTE5%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1312: p_attribute6 IN CS_CONTRACTS_BILLING.ATTRIBUTE6%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1313: p_attribute7 IN CS_CONTRACTS_BILLING.ATTRIBUTE7%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1314: p_attribute8 IN CS_CONTRACTS_BILLING.ATTRIBUTE8%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1315: p_attribute9 IN CS_CONTRACTS_BILLING.ATTRIBUTE9%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1316: p_attribute10 IN CS_CONTRACTS_BILLING.ATTRIBUTE10%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1317: p_attribute11 IN CS_CONTRACTS_BILLING.ATTRIBUTE11%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1318: p_attribute12 IN CS_CONTRACTS_BILLING.ATTRIBUTE12%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

Line 1315: p_attribute9 IN CS_CONTRACTS_BILLING.ATTRIBUTE9%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

1311: p_attribute5 IN CS_CONTRACTS_BILLING.ATTRIBUTE5%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1312: p_attribute6 IN CS_CONTRACTS_BILLING.ATTRIBUTE6%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1313: p_attribute7 IN CS_CONTRACTS_BILLING.ATTRIBUTE7%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1314: p_attribute8 IN CS_CONTRACTS_BILLING.ATTRIBUTE8%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1315: p_attribute9 IN CS_CONTRACTS_BILLING.ATTRIBUTE9%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1316: p_attribute10 IN CS_CONTRACTS_BILLING.ATTRIBUTE10%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1317: p_attribute11 IN CS_CONTRACTS_BILLING.ATTRIBUTE11%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1318: p_attribute12 IN CS_CONTRACTS_BILLING.ATTRIBUTE12%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1319: p_attribute13 IN CS_CONTRACTS_BILLING.ATTRIBUTE13%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

Line 1316: p_attribute10 IN CS_CONTRACTS_BILLING.ATTRIBUTE10%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

1312: p_attribute6 IN CS_CONTRACTS_BILLING.ATTRIBUTE6%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1313: p_attribute7 IN CS_CONTRACTS_BILLING.ATTRIBUTE7%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1314: p_attribute8 IN CS_CONTRACTS_BILLING.ATTRIBUTE8%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1315: p_attribute9 IN CS_CONTRACTS_BILLING.ATTRIBUTE9%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1316: p_attribute10 IN CS_CONTRACTS_BILLING.ATTRIBUTE10%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1317: p_attribute11 IN CS_CONTRACTS_BILLING.ATTRIBUTE11%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1318: p_attribute12 IN CS_CONTRACTS_BILLING.ATTRIBUTE12%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1319: p_attribute13 IN CS_CONTRACTS_BILLING.ATTRIBUTE13%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1320: p_attribute14 IN CS_CONTRACTS_BILLING.ATTRIBUTE14%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

Line 1317: p_attribute11 IN CS_CONTRACTS_BILLING.ATTRIBUTE11%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

1313: p_attribute7 IN CS_CONTRACTS_BILLING.ATTRIBUTE7%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1314: p_attribute8 IN CS_CONTRACTS_BILLING.ATTRIBUTE8%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1315: p_attribute9 IN CS_CONTRACTS_BILLING.ATTRIBUTE9%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1316: p_attribute10 IN CS_CONTRACTS_BILLING.ATTRIBUTE10%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1317: p_attribute11 IN CS_CONTRACTS_BILLING.ATTRIBUTE11%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1318: p_attribute12 IN CS_CONTRACTS_BILLING.ATTRIBUTE12%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1319: p_attribute13 IN CS_CONTRACTS_BILLING.ATTRIBUTE13%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1320: p_attribute14 IN CS_CONTRACTS_BILLING.ATTRIBUTE14%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1321: p_attribute15 IN CS_CONTRACTS_BILLING.ATTRIBUTE15%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

Line 1318: p_attribute12 IN CS_CONTRACTS_BILLING.ATTRIBUTE12%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

1314: p_attribute8 IN CS_CONTRACTS_BILLING.ATTRIBUTE8%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1315: p_attribute9 IN CS_CONTRACTS_BILLING.ATTRIBUTE9%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1316: p_attribute10 IN CS_CONTRACTS_BILLING.ATTRIBUTE10%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1317: p_attribute11 IN CS_CONTRACTS_BILLING.ATTRIBUTE11%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1318: p_attribute12 IN CS_CONTRACTS_BILLING.ATTRIBUTE12%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1319: p_attribute13 IN CS_CONTRACTS_BILLING.ATTRIBUTE13%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1320: p_attribute14 IN CS_CONTRACTS_BILLING.ATTRIBUTE14%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1321: p_attribute15 IN CS_CONTRACTS_BILLING.ATTRIBUTE15%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1322: p_context IN CS_CONTRACTS_BILLING.CONTEXT%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

Line 1319: p_attribute13 IN CS_CONTRACTS_BILLING.ATTRIBUTE13%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

1315: p_attribute9 IN CS_CONTRACTS_BILLING.ATTRIBUTE9%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1316: p_attribute10 IN CS_CONTRACTS_BILLING.ATTRIBUTE10%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1317: p_attribute11 IN CS_CONTRACTS_BILLING.ATTRIBUTE11%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1318: p_attribute12 IN CS_CONTRACTS_BILLING.ATTRIBUTE12%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1319: p_attribute13 IN CS_CONTRACTS_BILLING.ATTRIBUTE13%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1320: p_attribute14 IN CS_CONTRACTS_BILLING.ATTRIBUTE14%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1321: p_attribute15 IN CS_CONTRACTS_BILLING.ATTRIBUTE15%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1322: p_context IN CS_CONTRACTS_BILLING.CONTEXT%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1323: p_object_version_number IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM) IS

Line 1320: p_attribute14 IN CS_CONTRACTS_BILLING.ATTRIBUTE14%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

1316: p_attribute10 IN CS_CONTRACTS_BILLING.ATTRIBUTE10%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1317: p_attribute11 IN CS_CONTRACTS_BILLING.ATTRIBUTE11%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1318: p_attribute12 IN CS_CONTRACTS_BILLING.ATTRIBUTE12%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1319: p_attribute13 IN CS_CONTRACTS_BILLING.ATTRIBUTE13%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1320: p_attribute14 IN CS_CONTRACTS_BILLING.ATTRIBUTE14%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1321: p_attribute15 IN CS_CONTRACTS_BILLING.ATTRIBUTE15%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1322: p_context IN CS_CONTRACTS_BILLING.CONTEXT%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1323: p_object_version_number IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM) IS
1324: l_api_name CONSTANT VARCHAR2(30) := 'validate_row';

Line 1321: p_attribute15 IN CS_CONTRACTS_BILLING.ATTRIBUTE15%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

1317: p_attribute11 IN CS_CONTRACTS_BILLING.ATTRIBUTE11%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1318: p_attribute12 IN CS_CONTRACTS_BILLING.ATTRIBUTE12%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1319: p_attribute13 IN CS_CONTRACTS_BILLING.ATTRIBUTE13%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1320: p_attribute14 IN CS_CONTRACTS_BILLING.ATTRIBUTE14%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1321: p_attribute15 IN CS_CONTRACTS_BILLING.ATTRIBUTE15%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1322: p_context IN CS_CONTRACTS_BILLING.CONTEXT%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1323: p_object_version_number IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM) IS
1324: l_api_name CONSTANT VARCHAR2(30) := 'validate_row';
1325: l_api_version CONSTANT NUMBER := 1;

Line 1322: p_context IN CS_CONTRACTS_BILLING.CONTEXT%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

1318: p_attribute12 IN CS_CONTRACTS_BILLING.ATTRIBUTE12%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1319: p_attribute13 IN CS_CONTRACTS_BILLING.ATTRIBUTE13%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1320: p_attribute14 IN CS_CONTRACTS_BILLING.ATTRIBUTE14%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1321: p_attribute15 IN CS_CONTRACTS_BILLING.ATTRIBUTE15%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1322: p_context IN CS_CONTRACTS_BILLING.CONTEXT%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1323: p_object_version_number IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM) IS
1324: l_api_name CONSTANT VARCHAR2(30) := 'validate_row';
1325: l_api_version CONSTANT NUMBER := 1;
1326: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;

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

1319: p_attribute13 IN CS_CONTRACTS_BILLING.ATTRIBUTE13%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1320: p_attribute14 IN CS_CONTRACTS_BILLING.ATTRIBUTE14%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1321: p_attribute15 IN CS_CONTRACTS_BILLING.ATTRIBUTE15%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1322: p_context IN CS_CONTRACTS_BILLING.CONTEXT%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1323: p_object_version_number IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM) IS
1324: l_api_name CONSTANT VARCHAR2(30) := 'validate_row';
1325: l_api_version CONSTANT NUMBER := 1;
1326: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
1327: l_contractbilling_rec ContractBilling_Val_Rec_Type;

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

1325: l_api_version CONSTANT NUMBER := 1;
1326: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
1327: l_contractbilling_rec ContractBilling_Val_Rec_Type;
1328: BEGIN
1329: l_return_status := TAPI_DEV_KIT.START_ACTIVITY(l_api_name,
1330: G_PKG_NAME,
1331: l_api_version,
1332: p_api_version,
1333: p_init_msg_list,

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

1383: x_msg_count,
1384: x_msg_data,
1385: l_contractbilling_rec
1386: );
1387: TAPI_DEV_KIT.END_ACTIVITY(p_commit, x_msg_count, x_msg_data);
1388: EXCEPTION
1389: WHEN FND_API.G_EXC_ERROR THEN
1390: x_return_status := TAPI_DEV_KIT.HANDLE_EXCEPTIONS
1391: (

Line 1390: x_return_status := TAPI_DEV_KIT.HANDLE_EXCEPTIONS

1386: );
1387: TAPI_DEV_KIT.END_ACTIVITY(p_commit, x_msg_count, x_msg_data);
1388: EXCEPTION
1389: WHEN FND_API.G_EXC_ERROR THEN
1390: x_return_status := TAPI_DEV_KIT.HANDLE_EXCEPTIONS
1391: (
1392: l_api_name,
1393: G_PKG_NAME,
1394: 'FND_API.G_RET_STS_ERROR',

Line 1401: x_return_status :=TAPI_DEV_KIT.HANDLE_EXCEPTIONS

1397: '_Pvt'
1398: );
1399: APP_EXCEPTION.RAISE_EXCEPTION;
1400: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1401: x_return_status :=TAPI_DEV_KIT.HANDLE_EXCEPTIONS
1402: (
1403: l_api_name,
1404: G_PKG_NAME,
1405: 'FND_API.G_RET_STS_UNEXP_ERROR',

Line 1411: WHEN TAPI_DEV_KIT.G_EXC_DUP_VAL_ON_INDEX THEN

1407: x_msg_data,
1408: '_Pvt'
1409: );
1410: APP_EXCEPTION.RAISE_EXCEPTION;
1411: WHEN TAPI_DEV_KIT.G_EXC_DUP_VAL_ON_INDEX THEN
1412: x_return_status :=TAPI_DEV_KIT.HANDLE_EXCEPTIONS
1413: (
1414: l_api_name,
1415: G_PKG_NAME,

Line 1412: x_return_status :=TAPI_DEV_KIT.HANDLE_EXCEPTIONS

1408: '_Pvt'
1409: );
1410: APP_EXCEPTION.RAISE_EXCEPTION;
1411: WHEN TAPI_DEV_KIT.G_EXC_DUP_VAL_ON_INDEX THEN
1412: x_return_status :=TAPI_DEV_KIT.HANDLE_EXCEPTIONS
1413: (
1414: l_api_name,
1415: G_PKG_NAME,
1416: 'TAPI_DEV_KIT.G_RET_STS_DUP_VAL_ON_INDEX',

Line 1416: 'TAPI_DEV_KIT.G_RET_STS_DUP_VAL_ON_INDEX',

1412: x_return_status :=TAPI_DEV_KIT.HANDLE_EXCEPTIONS
1413: (
1414: l_api_name,
1415: G_PKG_NAME,
1416: 'TAPI_DEV_KIT.G_RET_STS_DUP_VAL_ON_INDEX',
1417: x_msg_count,
1418: x_msg_data,
1419: '_Pvt'
1420: );