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.OKC_CONTRACT_PVT dependencies on OKC_CLE_PVT

Line 1213: p_clev_rec IN OKC_CLE_PVT.clev_rec_type) Is

1209: p_init_msg_list IN VARCHAR2 ,
1210: x_return_status OUT NOCOPY VARCHAR2,
1211: x_msg_count OUT NOCOPY NUMBER,
1212: x_msg_data OUT NOCOPY VARCHAR2,
1213: p_clev_rec IN OKC_CLE_PVT.clev_rec_type) Is
1214:
1215: l_acyv_rec OKC_ACY_PVT.acyv_rec_type;
1216: l_out_rec OKC_ACY_PVT.acyv_rec_type;
1217: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

Line 1311: PROCEDURE Get_Contract_Id(p_clev_rec IN OKC_CLE_PVT.clev_rec_type,

1307: -- This procedure returns the contract header id corresponding to the
1308: -- contract line record
1309: -- Called only if dnz_chr_id is null in clev_rec
1310: --
1311: PROCEDURE Get_Contract_Id(p_clev_rec IN OKC_CLE_PVT.clev_rec_type,
1312: x_chr_id OUT NOCOPY NUMBER,
1313: x_return_status OUT NOCOPY VARCHAR2) Is
1314: Cursor l_clev_csr Is
1315: SELECT dnz_chr_id

Line 1374: p_clev_rec IN OKC_CLE_PVT.clev_rec_type,

1370: x_return_status OUT NOCOPY VARCHAR2,
1371: x_msg_count OUT NOCOPY NUMBER,
1372: x_msg_data OUT NOCOPY VARCHAR2,
1373: p_restricted_update IN VARCHAR2 ,
1374: p_clev_rec IN OKC_CLE_PVT.clev_rec_type,
1375: x_clev_rec OUT NOCOPY OKC_CLE_PVT.clev_rec_type) IS
1376:
1377: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1378: l_chr_id NUMBER;

Line 1375: x_clev_rec OUT NOCOPY OKC_CLE_PVT.clev_rec_type) IS

1371: x_msg_count OUT NOCOPY NUMBER,
1372: x_msg_data OUT NOCOPY VARCHAR2,
1373: p_restricted_update IN VARCHAR2 ,
1374: p_clev_rec IN OKC_CLE_PVT.clev_rec_type,
1375: x_clev_rec OUT NOCOPY OKC_CLE_PVT.clev_rec_type) IS
1376:
1377: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1378: l_chr_id NUMBER;
1379: BEGIN

Line 1398: OKC_CLE_PVT.Insert_Row(

1394: Else
1395: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1396: End If;
1397:
1398: OKC_CLE_PVT.Insert_Row(
1399: p_api_version => p_api_version,
1400: p_init_msg_list => p_init_msg_list,
1401: x_return_status => x_return_status,
1402: x_msg_count => x_msg_count,

Line 1455: p_clev_tbl IN OKC_CLE_PVT.clev_tbl_type,

1451: p_init_msg_list IN VARCHAR2 ,
1452: x_return_status OUT NOCOPY VARCHAR2,
1453: x_msg_count OUT NOCOPY NUMBER,
1454: x_msg_data OUT NOCOPY VARCHAR2,
1455: p_clev_tbl IN OKC_CLE_PVT.clev_tbl_type,
1456: x_clev_tbl OUT NOCOPY OKC_CLE_PVT.clev_tbl_type) IS
1457:
1458: BEGIN
1459: OKC_CLE_PVT.Insert_Row(

Line 1456: x_clev_tbl OUT NOCOPY OKC_CLE_PVT.clev_tbl_type) IS

1452: x_return_status OUT NOCOPY VARCHAR2,
1453: x_msg_count OUT NOCOPY NUMBER,
1454: x_msg_data OUT NOCOPY VARCHAR2,
1455: p_clev_tbl IN OKC_CLE_PVT.clev_tbl_type,
1456: x_clev_tbl OUT NOCOPY OKC_CLE_PVT.clev_tbl_type) IS
1457:
1458: BEGIN
1459: OKC_CLE_PVT.Insert_Row(
1460: p_api_version => p_api_version,

Line 1459: OKC_CLE_PVT.Insert_Row(

1455: p_clev_tbl IN OKC_CLE_PVT.clev_tbl_type,
1456: x_clev_tbl OUT NOCOPY OKC_CLE_PVT.clev_tbl_type) IS
1457:
1458: BEGIN
1459: OKC_CLE_PVT.Insert_Row(
1460: p_api_version => p_api_version,
1461: p_init_msg_list => p_init_msg_list,
1462: x_return_status => x_return_status,
1463: x_msg_count => x_msg_count,

Line 1476: p_clev_rec IN OKC_CLE_PVT.clev_rec_type,

1472: x_return_status OUT NOCOPY VARCHAR2,
1473: x_msg_count OUT NOCOPY NUMBER,
1474: x_msg_data OUT NOCOPY VARCHAR2,
1475: p_restricted_update IN VARCHAR2 ,
1476: p_clev_rec IN OKC_CLE_PVT.clev_rec_type,
1477: x_clev_rec OUT NOCOPY OKC_CLE_PVT.clev_rec_type) IS
1478:
1479: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1480: l_chr_id NUMBER;

Line 1477: x_clev_rec OUT NOCOPY OKC_CLE_PVT.clev_rec_type) IS

1473: x_msg_count OUT NOCOPY NUMBER,
1474: x_msg_data OUT NOCOPY VARCHAR2,
1475: p_restricted_update IN VARCHAR2 ,
1476: p_clev_rec IN OKC_CLE_PVT.clev_rec_type,
1477: x_clev_rec OUT NOCOPY OKC_CLE_PVT.clev_rec_type) IS
1478:
1479: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1480: l_chr_id NUMBER;
1481: l_api_name CONSTANT VARCHAR2(30) := 'Update_Contract_Line';

Line 1511: OKC_CLE_PVT.Update_Row(

1507: End If;
1508: Else
1509: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1510: End If;
1511: OKC_CLE_PVT.Update_Row(
1512: p_api_version => p_api_version,
1513: p_init_msg_list => p_init_msg_list,
1514: x_return_status => x_return_status,
1515: x_msg_count => x_msg_count,

Line 1598: p_clev_tbl IN OKC_CLE_PVT.clev_tbl_type,

1594: x_return_status OUT NOCOPY VARCHAR2,
1595: x_msg_count OUT NOCOPY NUMBER,
1596: x_msg_data OUT NOCOPY VARCHAR2,
1597: p_restricted_update IN VARCHAR2 ,
1598: p_clev_tbl IN OKC_CLE_PVT.clev_tbl_type,
1599: x_clev_tbl OUT NOCOPY OKC_CLE_PVT.clev_tbl_type) IS
1600:
1601: BEGIN
1602: OKC_CLE_PVT.Update_Row(

Line 1599: x_clev_tbl OUT NOCOPY OKC_CLE_PVT.clev_tbl_type) IS

1595: x_msg_count OUT NOCOPY NUMBER,
1596: x_msg_data OUT NOCOPY VARCHAR2,
1597: p_restricted_update IN VARCHAR2 ,
1598: p_clev_tbl IN OKC_CLE_PVT.clev_tbl_type,
1599: x_clev_tbl OUT NOCOPY OKC_CLE_PVT.clev_tbl_type) IS
1600:
1601: BEGIN
1602: OKC_CLE_PVT.Update_Row(
1603: p_api_version => p_api_version,

Line 1602: OKC_CLE_PVT.Update_Row(

1598: p_clev_tbl IN OKC_CLE_PVT.clev_tbl_type,
1599: x_clev_tbl OUT NOCOPY OKC_CLE_PVT.clev_tbl_type) IS
1600:
1601: BEGIN
1602: OKC_CLE_PVT.Update_Row(
1603: p_api_version => p_api_version,
1604: p_init_msg_list => p_init_msg_list,
1605: x_return_status => x_return_status,
1606: x_msg_count => x_msg_count,

Line 1696: p_clev_rec IN OKC_CLE_PVT.clev_rec_type) IS

1692: p_init_msg_list IN VARCHAR2 ,
1693: x_return_status OUT NOCOPY VARCHAR2,
1694: x_msg_count OUT NOCOPY NUMBER,
1695: x_msg_data OUT NOCOPY VARCHAR2,
1696: p_clev_rec IN OKC_CLE_PVT.clev_rec_type) IS
1697:
1698: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1699: l_chr_id NUMBER;
1700: l_dummy_val NUMBER;

Line 1785: OKC_CLE_PVT.Delete_Row(

1781: close l_cimv_csr;
1782:
1783: -- delete only if there are no items
1784: If (l_dummy_val = 0) Then
1785: OKC_CLE_PVT.Delete_Row(
1786: p_api_version => p_api_version,
1787: p_init_msg_list => p_init_msg_list,
1788: x_return_status => x_return_status,
1789: x_msg_count => x_msg_count,

Line 1994: p_clev_tbl IN OKC_CLE_PVT.clev_tbl_type) IS

1990: p_init_msg_list IN VARCHAR2 ,
1991: x_return_status OUT NOCOPY VARCHAR2,
1992: x_msg_count OUT NOCOPY NUMBER,
1993: x_msg_data OUT NOCOPY VARCHAR2,
1994: p_clev_tbl IN OKC_CLE_PVT.clev_tbl_type) IS
1995:
1996: BEGIN
1997: OKC_CLE_PVT.Delete_Row(
1998: p_api_version => p_api_version,

Line 1997: OKC_CLE_PVT.Delete_Row(

1993: x_msg_data OUT NOCOPY VARCHAR2,
1994: p_clev_tbl IN OKC_CLE_PVT.clev_tbl_type) IS
1995:
1996: BEGIN
1997: OKC_CLE_PVT.Delete_Row(
1998: p_api_version => p_api_version,
1999: p_init_msg_list => p_init_msg_list,
2000: x_return_status => x_return_status,
2001: x_msg_count => x_msg_count,

Line 3126: okc_debug.log('1400: calling okc_cle_pvt.force_delete_row', 2);

3122: END IF;
3123: END IF;
3124:
3125: IF (l_debug = 'Y') THEN
3126: okc_debug.log('1400: calling okc_cle_pvt.force_delete_row', 2);
3127: END IF;
3128:
3129: IF NOT l_clev_tbl_in.COUNT=0
3130: THEN

Line 3131: okc_cle_pvt.force_delete_row (

3127: END IF;
3128:
3129: IF NOT l_clev_tbl_in.COUNT=0
3130: THEN
3131: okc_cle_pvt.force_delete_row (
3132: p_api_version => l_api_version,
3133: p_init_msg_list => l_init_msg_list,
3134: x_return_status => l_return_status,
3135: x_msg_count => l_msg_count,

Line 3261: p_clev_rec IN OKC_CLE_PVT.clev_rec_type) IS

3257: p_init_msg_list IN VARCHAR2 ,
3258: x_return_status OUT NOCOPY VARCHAR2,
3259: x_msg_count OUT NOCOPY NUMBER,
3260: x_msg_data OUT NOCOPY VARCHAR2,
3261: p_clev_rec IN OKC_CLE_PVT.clev_rec_type) IS
3262:
3263: BEGIN
3264: OKC_CLE_PVT.Lock_Row(
3265: p_api_version => p_api_version,

Line 3264: OKC_CLE_PVT.Lock_Row(

3260: x_msg_data OUT NOCOPY VARCHAR2,
3261: p_clev_rec IN OKC_CLE_PVT.clev_rec_type) IS
3262:
3263: BEGIN
3264: OKC_CLE_PVT.Lock_Row(
3265: p_api_version => p_api_version,
3266: p_init_msg_list => p_init_msg_list,
3267: x_return_status => x_return_status,
3268: x_msg_count => x_msg_count,

Line 3279: p_clev_tbl IN OKC_CLE_PVT.clev_tbl_type) IS

3275: p_init_msg_list IN VARCHAR2 ,
3276: x_return_status OUT NOCOPY VARCHAR2,
3277: x_msg_count OUT NOCOPY NUMBER,
3278: x_msg_data OUT NOCOPY VARCHAR2,
3279: p_clev_tbl IN OKC_CLE_PVT.clev_tbl_type) IS
3280:
3281: BEGIN
3282: OKC_CLE_PVT.Lock_Row(
3283: p_api_version => p_api_version,

Line 3282: OKC_CLE_PVT.Lock_Row(

3278: x_msg_data OUT NOCOPY VARCHAR2,
3279: p_clev_tbl IN OKC_CLE_PVT.clev_tbl_type) IS
3280:
3281: BEGIN
3282: OKC_CLE_PVT.Lock_Row(
3283: p_api_version => p_api_version,
3284: p_init_msg_list => p_init_msg_list,
3285: x_return_status => x_return_status,
3286: x_msg_count => x_msg_count,

Line 3297: p_clev_rec IN OKC_CLE_PVT.clev_rec_type) IS

3293: p_init_msg_list IN VARCHAR2 ,
3294: x_return_status OUT NOCOPY VARCHAR2,
3295: x_msg_count OUT NOCOPY NUMBER,
3296: x_msg_data OUT NOCOPY VARCHAR2,
3297: p_clev_rec IN OKC_CLE_PVT.clev_rec_type) IS
3298:
3299: BEGIN
3300: OKC_CLE_PVT.Validate_Row(
3301: p_api_version => p_api_version,

Line 3300: OKC_CLE_PVT.Validate_Row(

3296: x_msg_data OUT NOCOPY VARCHAR2,
3297: p_clev_rec IN OKC_CLE_PVT.clev_rec_type) IS
3298:
3299: BEGIN
3300: OKC_CLE_PVT.Validate_Row(
3301: p_api_version => p_api_version,
3302: p_init_msg_list => p_init_msg_list,
3303: x_return_status => x_return_status,
3304: x_msg_count => x_msg_count,

Line 3315: p_clev_tbl IN OKC_CLE_PVT.clev_tbl_type) IS

3311: p_init_msg_list IN VARCHAR2 ,
3312: x_return_status OUT NOCOPY VARCHAR2,
3313: x_msg_count OUT NOCOPY NUMBER,
3314: x_msg_data OUT NOCOPY VARCHAR2,
3315: p_clev_tbl IN OKC_CLE_PVT.clev_tbl_type) IS
3316:
3317: BEGIN
3318: OKC_CLE_PVT.Validate_Row(
3319: p_api_version => p_api_version,

Line 3318: OKC_CLE_PVT.Validate_Row(

3314: x_msg_data OUT NOCOPY VARCHAR2,
3315: p_clev_tbl IN OKC_CLE_PVT.clev_tbl_type) IS
3316:
3317: BEGIN
3318: OKC_CLE_PVT.Validate_Row(
3319: p_api_version => p_api_version,
3320: p_init_msg_list => p_init_msg_list,
3321: x_return_status => x_return_status,
3322: x_msg_count => x_msg_count,

Line 4056: OKC_CLE_PVT.add_language;

4052:
4053: PROCEDURE add_language IS
4054: BEGIN
4055: OKC_CHR_PVT.add_language;
4056: OKC_CLE_PVT.add_language;
4057: END add_language;
4058:
4059: PROCEDURE Get_Active_Process (
4060: p_api_version IN NUMBER,