DBA Data[Home] [Help]

APPS.OKE_CONTRACT_PUB dependencies on OKC_CONTRACT_PUB

Line 85: p_chrv_rec IN okc_contract_pub.chrv_rec_type,

81: x_return_status OUT NOCOPY VARCHAR2,
82: x_msg_count OUT NOCOPY NUMBER,
83: x_msg_data OUT NOCOPY VARCHAR2,
84: p_chr_rec IN oke_chr_pvt.chr_rec_type,
85: p_chrv_rec IN okc_contract_pub.chrv_rec_type,
86: x_chr_rec OUT NOCOPY oke_chr_pvt.chr_rec_type,
87: x_chrv_rec OUT NOCOPY okc_contract_pub.chrv_rec_type) IS
88:
89: l_chr_rec oke_chr_pvt.chr_rec_type;

Line 87: x_chrv_rec OUT NOCOPY okc_contract_pub.chrv_rec_type) IS

83: x_msg_data OUT NOCOPY VARCHAR2,
84: p_chr_rec IN oke_chr_pvt.chr_rec_type,
85: p_chrv_rec IN okc_contract_pub.chrv_rec_type,
86: x_chr_rec OUT NOCOPY oke_chr_pvt.chr_rec_type,
87: x_chrv_rec OUT NOCOPY okc_contract_pub.chrv_rec_type) IS
88:
89: l_chr_rec oke_chr_pvt.chr_rec_type;
90: l_chrv_rec okc_contract_pub.chrv_rec_type;
91: l_api_name CONSTANT VARCHAR2(30) := 'CREATE_CONTRACT_HEADER';

Line 90: l_chrv_rec okc_contract_pub.chrv_rec_type;

86: x_chr_rec OUT NOCOPY oke_chr_pvt.chr_rec_type,
87: x_chrv_rec OUT NOCOPY okc_contract_pub.chrv_rec_type) IS
88:
89: l_chr_rec oke_chr_pvt.chr_rec_type;
90: l_chrv_rec okc_contract_pub.chrv_rec_type;
91: l_api_name CONSTANT VARCHAR2(30) := 'CREATE_CONTRACT_HEADER';
92: l_api_version CONSTANT NUMBER := 1.0;
93: l_return_status VARCHAR2(1) := OKE_API.G_RET_STS_SUCCESS;
94:

Line 160: OKC_CONTRACT_PUB.create_contract_header(

156: -- set okc context before API call
157: --
158:
159: OKC_CONTEXT.SET_OKC_ORG_CONTEXT(l_chrv_rec.authoring_org_id,l_chrv_rec.inv_organization_id);
160: OKC_CONTRACT_PUB.create_contract_header(
161: p_api_version => p_api_version,
162: p_init_msg_list => p_init_msg_list,
163: x_return_status => x_return_status,
164: x_msg_count => x_msg_count,

Line 259: p_chrv_tbl IN okc_contract_pub.chrv_tbl_type,

255: x_return_status OUT NOCOPY VARCHAR2,
256: x_msg_count OUT NOCOPY NUMBER,
257: x_msg_data OUT NOCOPY VARCHAR2,
258: p_chr_tbl IN oke_chr_pvt.chr_tbl_type,
259: p_chrv_tbl IN okc_contract_pub.chrv_tbl_type,
260: x_chr_tbl OUT NOCOPY oke_chr_pvt.chr_tbl_type,
261: x_chrv_tbl OUT NOCOPY okc_contract_pub.chrv_tbl_type) IS
262:
263: l_api_name CONSTANT VARCHAR2(30) := 'CREATE_CONTRACT_HEADER';

Line 261: x_chrv_tbl OUT NOCOPY okc_contract_pub.chrv_tbl_type) IS

257: x_msg_data OUT NOCOPY VARCHAR2,
258: p_chr_tbl IN oke_chr_pvt.chr_tbl_type,
259: p_chrv_tbl IN okc_contract_pub.chrv_tbl_type,
260: x_chr_tbl OUT NOCOPY oke_chr_pvt.chr_tbl_type,
261: x_chrv_tbl OUT NOCOPY okc_contract_pub.chrv_tbl_type) IS
262:
263: l_api_name CONSTANT VARCHAR2(30) := 'CREATE_CONTRACT_HEADER';
264: l_api_version CONSTANT NUMBER := 1.0;
265: l_return_status VARCHAR2(1) := OKE_API.G_RET_STS_SUCCESS;

Line 364: p_chrv_rec IN okc_contract_pub.chrv_rec_type,

360: x_msg_count OUT NOCOPY NUMBER,
361: x_msg_data OUT NOCOPY VARCHAR2,
362: p_restricted_update IN VARCHAR2 DEFAULT OKE_API.G_TRUE,
363: p_chr_rec IN oke_chr_pvt.chr_rec_type,
364: p_chrv_rec IN okc_contract_pub.chrv_rec_type,
365: x_chr_rec OUT NOCOPY oke_chr_pvt.chr_rec_type,
366: x_chrv_rec OUT NOCOPY okc_contract_pub.chrv_rec_type) IS
367:
368: l_api_name CONSTANT VARCHAR2(30) := 'UPDATE_CONTRACT_HEADER';

Line 366: x_chrv_rec OUT NOCOPY okc_contract_pub.chrv_rec_type) IS

362: p_restricted_update IN VARCHAR2 DEFAULT OKE_API.G_TRUE,
363: p_chr_rec IN oke_chr_pvt.chr_rec_type,
364: p_chrv_rec IN okc_contract_pub.chrv_rec_type,
365: x_chr_rec OUT NOCOPY oke_chr_pvt.chr_rec_type,
366: x_chrv_rec OUT NOCOPY okc_contract_pub.chrv_rec_type) IS
367:
368: l_api_name CONSTANT VARCHAR2(30) := 'UPDATE_CONTRACT_HEADER';
369: l_api_version CONSTANT NUMBER := 1.0;
370: l_return_status VARCHAR2(1) := OKE_API.G_RET_STS_SUCCESS;

Line 393: OKC_CONTRACT_PUB.update_contract_header(

389: End If;
390:
391:
392: -- call procedure in complex API
393: OKC_CONTRACT_PUB.update_contract_header(
394: p_api_version => p_api_version,
395: p_init_msg_list => p_init_msg_list,
396: x_return_status => x_return_status,
397: x_msg_count => x_msg_count,

Line 485: p_chrv_tbl IN okc_contract_pub.chrv_tbl_type,

481: x_msg_count OUT NOCOPY NUMBER,
482: x_msg_data OUT NOCOPY VARCHAR2,
483: p_restricted_update IN VARCHAR2 DEFAULT OKE_API.G_TRUE,
484: p_chr_tbl IN oke_chr_pvt.chr_tbl_type,
485: p_chrv_tbl IN okc_contract_pub.chrv_tbl_type,
486: x_chr_tbl OUT NOCOPY oke_chr_pvt.chr_tbl_type,
487: x_chrv_tbl OUT NOCOPY okc_contract_pub.chrv_tbl_type) IS
488:
489: l_api_name CONSTANT VARCHAR2(30) := 'UPDATE_CONTRACT_HEADER';

Line 487: x_chrv_tbl OUT NOCOPY okc_contract_pub.chrv_tbl_type) IS

483: p_restricted_update IN VARCHAR2 DEFAULT OKE_API.G_TRUE,
484: p_chr_tbl IN oke_chr_pvt.chr_tbl_type,
485: p_chrv_tbl IN okc_contract_pub.chrv_tbl_type,
486: x_chr_tbl OUT NOCOPY oke_chr_pvt.chr_tbl_type,
487: x_chrv_tbl OUT NOCOPY okc_contract_pub.chrv_tbl_type) IS
488:
489: l_api_name CONSTANT VARCHAR2(30) := 'UPDATE_CONTRACT_HEADER';
490: l_api_version CONSTANT NUMBER := 1.0;
491: l_return_status VARCHAR2(1) := OKE_API.G_RET_STS_SUCCESS;

Line 591: p_chrv_rec IN okc_contract_pub.chrv_rec_type) IS

587: x_return_status OUT NOCOPY VARCHAR2,
588: x_msg_count OUT NOCOPY NUMBER,
589: x_msg_data OUT NOCOPY VARCHAR2,
590: p_chr_rec IN oke_chr_pvt.chr_rec_type,
591: p_chrv_rec IN okc_contract_pub.chrv_rec_type) IS
592:
593: l_chr_rec oke_chr_pvt.chr_rec_type;
594: l_chrv_rec okc_contract_pub.chrv_rec_type;
595: l_api_name CONSTANT VARCHAR2(30) := 'DELETE_CONTRACT_HEADER';

Line 594: l_chrv_rec okc_contract_pub.chrv_rec_type;

590: p_chr_rec IN oke_chr_pvt.chr_rec_type,
591: p_chrv_rec IN okc_contract_pub.chrv_rec_type) IS
592:
593: l_chr_rec oke_chr_pvt.chr_rec_type;
594: l_chrv_rec okc_contract_pub.chrv_rec_type;
595: l_api_name CONSTANT VARCHAR2(30) := 'DELETE_CONTRACT_HEADER';
596: l_api_version CONSTANT NUMBER := 1.0;
597: l_return_status VARCHAR2(1) := OKE_API.G_RET_STS_SUCCESS;
598: BEGIN

Line 637: OKC_CONTRACT_PUB.delete_contract_header(

633: raise OKE_API.G_EXCEPTION_ERROR;
634: End If;
635:
636: -- call procedure in complex API
637: OKC_CONTRACT_PUB.delete_contract_header(
638: p_api_version => p_api_version,
639: p_init_msg_list => p_init_msg_list,
640: x_return_status => x_return_status,
641: x_msg_count => x_msg_count,

Line 709: p_chrv_tbl IN okc_contract_pub.chrv_tbl_type) IS

705: x_return_status OUT NOCOPY VARCHAR2,
706: x_msg_count OUT NOCOPY NUMBER,
707: x_msg_data OUT NOCOPY VARCHAR2,
708: p_chr_tbl IN oke_chr_pvt.chr_tbl_type,
709: p_chrv_tbl IN okc_contract_pub.chrv_tbl_type) IS
710:
711: l_api_name CONSTANT VARCHAR2(30) := 'DELETE_CONTRACT_HEADER';
712: l_api_version CONSTANT NUMBER := 1.0;
713: l_return_status VARCHAR2(1) := OKE_API.G_RET_STS_SUCCESS;

Line 758: OKC_CONTRACT_PUB.delete_contract_header(

754: End If;
755: End If;
756:
757: -- call procedure in public API for a record
758: OKC_CONTRACT_PUB.delete_contract_header(
759: p_api_version => p_api_version,
760: p_init_msg_list => p_init_msg_list,
761: x_return_status => x_return_status,
762: x_msg_count => x_msg_count,

Line 844: p_chrv_rec IN okc_contract_pub.chrv_rec_type) IS

840: x_return_status OUT NOCOPY VARCHAR2,
841: x_msg_count OUT NOCOPY NUMBER,
842: x_msg_data OUT NOCOPY VARCHAR2,
843: p_chr_rec IN oke_chr_pvt.chr_rec_type,
844: p_chrv_rec IN okc_contract_pub.chrv_rec_type) IS
845:
846: l_chr_rec oke_chr_pvt.chr_rec_type;
847: l_chrv_rec okc_contract_pub.chrv_rec_type;
848: l_api_name CONSTANT VARCHAR2(30) := 'VALIDATE_CONTRACT_HEADER';

Line 847: l_chrv_rec okc_contract_pub.chrv_rec_type;

843: p_chr_rec IN oke_chr_pvt.chr_rec_type,
844: p_chrv_rec IN okc_contract_pub.chrv_rec_type) IS
845:
846: l_chr_rec oke_chr_pvt.chr_rec_type;
847: l_chrv_rec okc_contract_pub.chrv_rec_type;
848: l_api_name CONSTANT VARCHAR2(30) := 'VALIDATE_CONTRACT_HEADER';
849: l_api_version CONSTANT NUMBER := 1.0;
850: l_return_status VARCHAR2(1) := OKE_API.G_RET_STS_SUCCESS;
851:

Line 876: OKC_CONTRACT_PUB.validate_contract_header(

872: l_chr_rec := p_chr_rec;
873: l_chrv_rec := p_chrv_rec;
874:
875: -- call procedure in complex API
876: OKC_CONTRACT_PUB.validate_contract_header(
877: p_api_version => p_api_version,
878: p_init_msg_list => p_init_msg_list,
879: x_return_status => x_return_status,
880: x_msg_count => x_msg_count,

Line 968: p_chrv_tbl IN okc_contract_pub.chrv_tbl_type) IS

964: x_return_status OUT NOCOPY VARCHAR2,
965: x_msg_count OUT NOCOPY NUMBER,
966: x_msg_data OUT NOCOPY VARCHAR2,
967: p_chr_tbl IN oke_chr_pvt.chr_tbl_type,
968: p_chrv_tbl IN okc_contract_pub.chrv_tbl_type) IS
969:
970: l_api_name CONSTANT VARCHAR2(30) := 'VALIDATE_CONTRACT_HEADER';
971:
972: l_api_version CONSTANT NUMBER := 1.0;

Line 1000: OKC_CONTRACT_PUB.validate_contract_header(

996: If (p_chrv_tbl.COUNT > 0) Then
997: i := p_chrv_tbl.FIRST;
998: LOOP
999: -- call procedure in complex API
1000: OKC_CONTRACT_PUB.validate_contract_header(
1001: p_api_version => p_api_version,
1002: p_init_msg_list => p_init_msg_list,
1003: x_return_status => x_return_status,
1004: x_msg_count => x_msg_count,

Line 1105: p_clev_rec IN okc_contract_pub.clev_rec_type,

1101: x_msg_count OUT NOCOPY NUMBER,
1102: x_msg_data OUT NOCOPY VARCHAR2,
1103: p_restricted_update IN VARCHAR2 DEFAULT OKE_API.G_TRUE,
1104: p_cle_rec IN oke_cle_pvt.cle_rec_type,
1105: p_clev_rec IN okc_contract_pub.clev_rec_type,
1106: x_cle_rec OUT NOCOPY oke_cle_pvt.cle_rec_type,
1107: x_clev_rec OUT NOCOPY okc_contract_pub.clev_rec_type) IS
1108:
1109: l_cle_rec oke_cle_pvt.cle_rec_type;

Line 1107: x_clev_rec OUT NOCOPY okc_contract_pub.clev_rec_type) IS

1103: p_restricted_update IN VARCHAR2 DEFAULT OKE_API.G_TRUE,
1104: p_cle_rec IN oke_cle_pvt.cle_rec_type,
1105: p_clev_rec IN okc_contract_pub.clev_rec_type,
1106: x_cle_rec OUT NOCOPY oke_cle_pvt.cle_rec_type,
1107: x_clev_rec OUT NOCOPY okc_contract_pub.clev_rec_type) IS
1108:
1109: l_cle_rec oke_cle_pvt.cle_rec_type;
1110: l_clev_rec okc_contract_pub.clev_rec_type;
1111: l_api_name CONSTANT VARCHAR2(30) := 'CREATE_CONTRACT_LINE';

Line 1110: l_clev_rec okc_contract_pub.clev_rec_type;

1106: x_cle_rec OUT NOCOPY oke_cle_pvt.cle_rec_type,
1107: x_clev_rec OUT NOCOPY okc_contract_pub.clev_rec_type) IS
1108:
1109: l_cle_rec oke_cle_pvt.cle_rec_type;
1110: l_clev_rec okc_contract_pub.clev_rec_type;
1111: l_api_name CONSTANT VARCHAR2(30) := 'CREATE_CONTRACT_LINE';
1112: l_api_version CONSTANT NUMBER := 1.0;
1113: l_return_status VARCHAR2(1) := OKE_API.G_RET_STS_SUCCESS;
1114: --bug 9354391 changed length of line_number to 150 as per table

Line 1183: OKC_CONTRACT_PUB.create_contract_line(

1179: Else
1180: Close l_chrv_csr;
1181: End If;
1182:
1183: OKC_CONTRACT_PUB.create_contract_line(
1184: p_api_version => p_api_version,
1185: p_init_msg_list => p_init_msg_list,
1186: x_return_status => x_return_status,
1187: x_msg_count => x_msg_count,

Line 1298: p_clev_tbl IN okc_contract_pub.clev_tbl_type,

1294: x_msg_count OUT NOCOPY NUMBER,
1295: x_msg_data OUT NOCOPY VARCHAR2,
1296: p_restricted_update IN VARCHAR2 DEFAULT OKE_API.G_TRUE,
1297: p_cle_tbl IN oke_cle_pvt.cle_tbl_type,
1298: p_clev_tbl IN okc_contract_pub.clev_tbl_type,
1299: x_cle_tbl OUT NOCOPY oke_cle_pvt.cle_tbl_type,
1300: x_clev_tbl OUT NOCOPY okc_contract_pub.clev_tbl_type) IS
1301:
1302: l_api_name CONSTANT VARCHAR2(30) := 'CREATE_CONTRACT_LINE';

Line 1300: x_clev_tbl OUT NOCOPY okc_contract_pub.clev_tbl_type) IS

1296: p_restricted_update IN VARCHAR2 DEFAULT OKE_API.G_TRUE,
1297: p_cle_tbl IN oke_cle_pvt.cle_tbl_type,
1298: p_clev_tbl IN okc_contract_pub.clev_tbl_type,
1299: x_cle_tbl OUT NOCOPY oke_cle_pvt.cle_tbl_type,
1300: x_clev_tbl OUT NOCOPY okc_contract_pub.clev_tbl_type) IS
1301:
1302: l_api_name CONSTANT VARCHAR2(30) := 'CREATE_CONTRACT_LINE';
1303: l_api_version CONSTANT NUMBER := 1.0;
1304: l_return_status VARCHAR2(1) := OKE_API.G_RET_STS_SUCCESS;

Line 1406: p_clev_rec IN okc_contract_pub.clev_rec_type,

1402: x_msg_count OUT NOCOPY NUMBER,
1403: x_msg_data OUT NOCOPY VARCHAR2,
1404: p_restricted_update IN VARCHAR2 DEFAULT OKE_API.G_TRUE,
1405: p_cle_rec IN oke_cle_pvt.cle_rec_type,
1406: p_clev_rec IN okc_contract_pub.clev_rec_type,
1407: x_cle_rec OUT NOCOPY oke_cle_pvt.cle_rec_type,
1408: x_clev_rec OUT NOCOPY okc_contract_pub.clev_rec_type) IS
1409:
1410: l_api_name CONSTANT VARCHAR2(30) := 'UPDATE_CONTRACT_LINE';

Line 1408: x_clev_rec OUT NOCOPY okc_contract_pub.clev_rec_type) IS

1404: p_restricted_update IN VARCHAR2 DEFAULT OKE_API.G_TRUE,
1405: p_cle_rec IN oke_cle_pvt.cle_rec_type,
1406: p_clev_rec IN okc_contract_pub.clev_rec_type,
1407: x_cle_rec OUT NOCOPY oke_cle_pvt.cle_rec_type,
1408: x_clev_rec OUT NOCOPY okc_contract_pub.clev_rec_type) IS
1409:
1410: l_api_name CONSTANT VARCHAR2(30) := 'UPDATE_CONTRACT_LINE';
1411: l_api_version CONSTANT NUMBER := 1.0;
1412: l_return_status VARCHAR2(1) := OKE_API.G_RET_STS_SUCCESS;

Line 1435: OKC_CONTRACT_PUB.update_contract_line(

1431: raise OKE_API.G_EXCEPTION_ERROR;
1432: End If;
1433:
1434: -- call procedure in complex API
1435: OKC_CONTRACT_PUB.update_contract_line(
1436: p_api_version => p_api_version,
1437: p_init_msg_list => p_init_msg_list,
1438: x_return_status => x_return_status,
1439: x_msg_count => x_msg_count,

Line 1527: p_clev_tbl IN okc_contract_pub.clev_tbl_type,

1523: x_msg_count OUT NOCOPY NUMBER,
1524: x_msg_data OUT NOCOPY VARCHAR2,
1525: p_restricted_update IN VARCHAR2 DEFAULT OKE_API.G_TRUE,
1526: p_cle_tbl IN oke_cle_pvt.cle_tbl_type,
1527: p_clev_tbl IN okc_contract_pub.clev_tbl_type,
1528: x_cle_tbl OUT NOCOPY oke_cle_pvt.cle_tbl_type,
1529: x_clev_tbl OUT NOCOPY okc_contract_pub.clev_tbl_type) IS
1530:
1531: l_api_name CONSTANT VARCHAR2(30) := 'UPDATE_CONTRACT_HEADER';

Line 1529: x_clev_tbl OUT NOCOPY okc_contract_pub.clev_tbl_type) IS

1525: p_restricted_update IN VARCHAR2 DEFAULT OKE_API.G_TRUE,
1526: p_cle_tbl IN oke_cle_pvt.cle_tbl_type,
1527: p_clev_tbl IN okc_contract_pub.clev_tbl_type,
1528: x_cle_tbl OUT NOCOPY oke_cle_pvt.cle_tbl_type,
1529: x_clev_tbl OUT NOCOPY okc_contract_pub.clev_tbl_type) IS
1530:
1531: l_api_name CONSTANT VARCHAR2(30) := 'UPDATE_CONTRACT_HEADER';
1532: l_api_version CONSTANT NUMBER := 1.0;
1533: l_return_status VARCHAR2(1) := OKE_API.G_RET_STS_SUCCESS;

Line 1634: p_clev_rec IN okc_contract_pub.clev_rec_type) IS

1630: x_return_status OUT NOCOPY VARCHAR2,
1631: x_msg_count OUT NOCOPY NUMBER,
1632: x_msg_data OUT NOCOPY VARCHAR2,
1633: p_cle_rec IN oke_cle_pvt.cle_rec_type,
1634: p_clev_rec IN okc_contract_pub.clev_rec_type) IS
1635:
1636: l_cle_rec oke_cle_pvt.cle_rec_type;
1637: l_clev_rec okc_contract_pub.clev_rec_type;
1638: l_api_name CONSTANT VARCHAR2(30) := 'DELETE_CONTRACT_LINE';

Line 1637: l_clev_rec okc_contract_pub.clev_rec_type;

1633: p_cle_rec IN oke_cle_pvt.cle_rec_type,
1634: p_clev_rec IN okc_contract_pub.clev_rec_type) IS
1635:
1636: l_cle_rec oke_cle_pvt.cle_rec_type;
1637: l_clev_rec okc_contract_pub.clev_rec_type;
1638: l_api_name CONSTANT VARCHAR2(30) := 'DELETE_CONTRACT_LINE';
1639: l_api_version CONSTANT NUMBER := 1.0;
1640: l_return_status VARCHAR2(1) := OKE_API.G_RET_STS_SUCCESS;
1641: BEGIN

Line 1680: OKC_CONTRACT_PUB.delete_contract_line(

1676: raise OKE_API.G_EXCEPTION_ERROR;
1677: End If;
1678:
1679: -- call procedure in complex API
1680: OKC_CONTRACT_PUB.delete_contract_line(
1681: p_api_version => p_api_version,
1682: p_init_msg_list => p_init_msg_list,
1683: x_return_status => x_return_status,
1684: x_msg_count => x_msg_count,

Line 1752: p_clev_tbl IN okc_contract_pub.clev_tbl_type) IS

1748: x_return_status OUT NOCOPY VARCHAR2,
1749: x_msg_count OUT NOCOPY NUMBER,
1750: x_msg_data OUT NOCOPY VARCHAR2,
1751: p_cle_tbl IN oke_cle_pvt.cle_tbl_type,
1752: p_clev_tbl IN okc_contract_pub.clev_tbl_type) IS
1753:
1754: l_api_name CONSTANT VARCHAR2(30) := 'DELETE_CONTRACT_HEADER';
1755: l_api_version CONSTANT NUMBER := 1.0;
1756: l_return_status VARCHAR2(1) := OKE_API.G_RET_STS_SUCCESS;

Line 1801: OKC_CONTRACT_PUB.delete_contract_line(

1797: End If;
1798: End If;
1799:
1800: -- call procedure in public API for a record
1801: OKC_CONTRACT_PUB.delete_contract_line(
1802: p_api_version => p_api_version,
1803: p_init_msg_list => p_init_msg_list,
1804: x_return_status => x_return_status,
1805: x_msg_count => x_msg_count,

Line 1963: p_clev_rec IN okc_contract_pub.clev_rec_type) IS

1959: x_return_status OUT NOCOPY VARCHAR2,
1960: x_msg_count OUT NOCOPY NUMBER,
1961: x_msg_data OUT NOCOPY VARCHAR2,
1962: p_cle_rec IN oke_cle_pvt.cle_rec_type,
1963: p_clev_rec IN okc_contract_pub.clev_rec_type) IS
1964:
1965: l_cle_rec oke_cle_pvt.cle_rec_type;
1966: l_clev_rec okc_contract_pub.clev_rec_type;
1967: l_api_name CONSTANT VARCHAR2(30) := 'VALIDATE_CONTRACT_LINE';

Line 1966: l_clev_rec okc_contract_pub.clev_rec_type;

1962: p_cle_rec IN oke_cle_pvt.cle_rec_type,
1963: p_clev_rec IN okc_contract_pub.clev_rec_type) IS
1964:
1965: l_cle_rec oke_cle_pvt.cle_rec_type;
1966: l_clev_rec okc_contract_pub.clev_rec_type;
1967: l_api_name CONSTANT VARCHAR2(30) := 'VALIDATE_CONTRACT_LINE';
1968: l_api_version CONSTANT NUMBER := 1.0;
1969: l_return_status VARCHAR2(1) := OKE_API.G_RET_STS_SUCCESS;
1970:

Line 1995: OKC_CONTRACT_PUB.validate_contract_line(

1991: l_cle_rec := p_cle_rec;
1992: l_clev_rec := p_clev_rec;
1993:
1994: -- call procedure in complex API
1995: OKC_CONTRACT_PUB.validate_contract_line(
1996: p_api_version => p_api_version,
1997: p_init_msg_list => p_init_msg_list,
1998: x_return_status => x_return_status,
1999: x_msg_count => x_msg_count,

Line 2087: p_clev_tbl IN okc_contract_pub.clev_tbl_type) IS

2083: x_return_status OUT NOCOPY VARCHAR2,
2084: x_msg_count OUT NOCOPY NUMBER,
2085: x_msg_data OUT NOCOPY VARCHAR2,
2086: p_cle_tbl IN oke_cle_pvt.cle_tbl_type,
2087: p_clev_tbl IN okc_contract_pub.clev_tbl_type) IS
2088:
2089: l_api_name CONSTANT VARCHAR2(30) := 'VALIDATE_CONTRACT_LINE';
2090:
2091: l_api_version CONSTANT NUMBER := 1.0;

Line 2119: OKC_CONTRACT_PUB.validate_contract_line(

2115: If (p_clev_tbl.COUNT > 0) Then
2116: i := p_clev_tbl.FIRST;
2117: LOOP
2118: -- call procedure in complex API
2119: OKC_CONTRACT_PUB.validate_contract_line(
2120: p_api_version => p_api_version,
2121: p_init_msg_list => p_init_msg_list,
2122: x_return_status => x_return_status,
2123: x_msg_count => x_msg_count,