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.

[Home] [Help]

APPS.OKC_CONTRACT_PVT dependencies on OKC_CLE_PVT

Line 1271: p_clev_rec IN OKC_CLE_PVT.clev_rec_type) Is

1267: p_init_msg_list IN VARCHAR2 ,
1268: x_return_status OUT NOCOPY VARCHAR2,
1269: x_msg_count OUT NOCOPY NUMBER,
1270: x_msg_data OUT NOCOPY VARCHAR2,
1271: p_clev_rec IN OKC_CLE_PVT.clev_rec_type) Is
1272:
1273: l_acyv_rec OKC_ACY_PVT.acyv_rec_type;
1274: l_out_rec OKC_ACY_PVT.acyv_rec_type;
1275: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

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

1365: -- This procedure returns the contract header id corresponding to the
1366: -- contract line record
1367: -- Called only if dnz_chr_id is null in clev_rec
1368: --
1369: PROCEDURE Get_Contract_Id(p_clev_rec IN OKC_CLE_PVT.clev_rec_type,
1370: x_chr_id OUT NOCOPY NUMBER,
1371: x_return_status OUT NOCOPY VARCHAR2) Is
1372: Cursor l_clev_csr Is
1373: SELECT dnz_chr_id

Line 1432: p_clev_rec IN OKC_CLE_PVT.clev_rec_type,

1428: x_return_status OUT NOCOPY VARCHAR2,
1429: x_msg_count OUT NOCOPY NUMBER,
1430: x_msg_data OUT NOCOPY VARCHAR2,
1431: p_restricted_update IN VARCHAR2 ,
1432: p_clev_rec IN OKC_CLE_PVT.clev_rec_type,
1433: x_clev_rec OUT NOCOPY OKC_CLE_PVT.clev_rec_type) IS
1434:
1435: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1436: l_chr_id NUMBER;

Line 1433: x_clev_rec OUT NOCOPY OKC_CLE_PVT.clev_rec_type) IS

1429: x_msg_count OUT NOCOPY NUMBER,
1430: x_msg_data OUT NOCOPY VARCHAR2,
1431: p_restricted_update IN VARCHAR2 ,
1432: p_clev_rec IN OKC_CLE_PVT.clev_rec_type,
1433: x_clev_rec OUT NOCOPY OKC_CLE_PVT.clev_rec_type) IS
1434:
1435: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1436: l_chr_id NUMBER;
1437: BEGIN

Line 1456: OKC_CLE_PVT.Insert_Row(

1452: Else
1453: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1454: End If;
1455:
1456: OKC_CLE_PVT.Insert_Row(
1457: p_api_version => p_api_version,
1458: p_init_msg_list => p_init_msg_list,
1459: x_return_status => x_return_status,
1460: x_msg_count => x_msg_count,

Line 1513: p_clev_tbl IN OKC_CLE_PVT.clev_tbl_type,

1509: p_init_msg_list IN VARCHAR2 ,
1510: x_return_status OUT NOCOPY VARCHAR2,
1511: x_msg_count OUT NOCOPY NUMBER,
1512: x_msg_data OUT NOCOPY VARCHAR2,
1513: p_clev_tbl IN OKC_CLE_PVT.clev_tbl_type,
1514: x_clev_tbl OUT NOCOPY OKC_CLE_PVT.clev_tbl_type) IS
1515:
1516: BEGIN
1517: OKC_CLE_PVT.Insert_Row(

Line 1514: x_clev_tbl OUT NOCOPY OKC_CLE_PVT.clev_tbl_type) IS

1510: x_return_status OUT NOCOPY VARCHAR2,
1511: x_msg_count OUT NOCOPY NUMBER,
1512: x_msg_data OUT NOCOPY VARCHAR2,
1513: p_clev_tbl IN OKC_CLE_PVT.clev_tbl_type,
1514: x_clev_tbl OUT NOCOPY OKC_CLE_PVT.clev_tbl_type) IS
1515:
1516: BEGIN
1517: OKC_CLE_PVT.Insert_Row(
1518: p_api_version => p_api_version,

Line 1517: OKC_CLE_PVT.Insert_Row(

1513: p_clev_tbl IN OKC_CLE_PVT.clev_tbl_type,
1514: x_clev_tbl OUT NOCOPY OKC_CLE_PVT.clev_tbl_type) IS
1515:
1516: BEGIN
1517: OKC_CLE_PVT.Insert_Row(
1518: p_api_version => p_api_version,
1519: p_init_msg_list => p_init_msg_list,
1520: x_return_status => x_return_status,
1521: x_msg_count => x_msg_count,

Line 1534: p_clev_rec IN OKC_CLE_PVT.clev_rec_type,

1530: x_return_status OUT NOCOPY VARCHAR2,
1531: x_msg_count OUT NOCOPY NUMBER,
1532: x_msg_data OUT NOCOPY VARCHAR2,
1533: p_restricted_update IN VARCHAR2 ,
1534: p_clev_rec IN OKC_CLE_PVT.clev_rec_type,
1535: x_clev_rec OUT NOCOPY OKC_CLE_PVT.clev_rec_type) IS
1536:
1537: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1538: l_chr_id NUMBER;

Line 1535: x_clev_rec OUT NOCOPY OKC_CLE_PVT.clev_rec_type) IS

1531: x_msg_count OUT NOCOPY NUMBER,
1532: x_msg_data OUT NOCOPY VARCHAR2,
1533: p_restricted_update IN VARCHAR2 ,
1534: p_clev_rec IN OKC_CLE_PVT.clev_rec_type,
1535: x_clev_rec OUT NOCOPY OKC_CLE_PVT.clev_rec_type) IS
1536:
1537: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1538: l_chr_id NUMBER;
1539: l_api_name CONSTANT VARCHAR2(30) := 'Update_Contract_Line';

Line 1569: OKC_CLE_PVT.Update_Row(

1565: End If;
1566: Else
1567: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1568: End If;
1569: OKC_CLE_PVT.Update_Row(
1570: p_api_version => p_api_version,
1571: p_init_msg_list => p_init_msg_list,
1572: x_return_status => x_return_status,
1573: x_msg_count => x_msg_count,

Line 1656: p_clev_tbl IN OKC_CLE_PVT.clev_tbl_type,

1652: x_return_status OUT NOCOPY VARCHAR2,
1653: x_msg_count OUT NOCOPY NUMBER,
1654: x_msg_data OUT NOCOPY VARCHAR2,
1655: p_restricted_update IN VARCHAR2 ,
1656: p_clev_tbl IN OKC_CLE_PVT.clev_tbl_type,
1657: x_clev_tbl OUT NOCOPY OKC_CLE_PVT.clev_tbl_type) IS
1658:
1659: BEGIN
1660: OKC_CLE_PVT.Update_Row(

Line 1657: x_clev_tbl OUT NOCOPY OKC_CLE_PVT.clev_tbl_type) IS

1653: x_msg_count OUT NOCOPY NUMBER,
1654: x_msg_data OUT NOCOPY VARCHAR2,
1655: p_restricted_update IN VARCHAR2 ,
1656: p_clev_tbl IN OKC_CLE_PVT.clev_tbl_type,
1657: x_clev_tbl OUT NOCOPY OKC_CLE_PVT.clev_tbl_type) IS
1658:
1659: BEGIN
1660: OKC_CLE_PVT.Update_Row(
1661: p_api_version => p_api_version,

Line 1660: OKC_CLE_PVT.Update_Row(

1656: p_clev_tbl IN OKC_CLE_PVT.clev_tbl_type,
1657: x_clev_tbl OUT NOCOPY OKC_CLE_PVT.clev_tbl_type) IS
1658:
1659: BEGIN
1660: OKC_CLE_PVT.Update_Row(
1661: p_api_version => p_api_version,
1662: p_init_msg_list => p_init_msg_list,
1663: x_return_status => x_return_status,
1664: x_msg_count => x_msg_count,

Line 1754: p_clev_rec IN OKC_CLE_PVT.clev_rec_type) IS

1750: p_init_msg_list IN VARCHAR2 ,
1751: x_return_status OUT NOCOPY VARCHAR2,
1752: x_msg_count OUT NOCOPY NUMBER,
1753: x_msg_data OUT NOCOPY VARCHAR2,
1754: p_clev_rec IN OKC_CLE_PVT.clev_rec_type) IS
1755:
1756: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1757: l_chr_id NUMBER;
1758: l_dummy_val NUMBER;

Line 1843: OKC_CLE_PVT.Delete_Row(

1839: close l_cimv_csr;
1840:
1841: -- delete only if there are no items
1842: If (l_dummy_val = 0) Then
1843: OKC_CLE_PVT.Delete_Row(
1844: p_api_version => p_api_version,
1845: p_init_msg_list => p_init_msg_list,
1846: x_return_status => x_return_status,
1847: x_msg_count => x_msg_count,

Line 2052: p_clev_tbl IN OKC_CLE_PVT.clev_tbl_type) IS

2048: p_init_msg_list IN VARCHAR2 ,
2049: x_return_status OUT NOCOPY VARCHAR2,
2050: x_msg_count OUT NOCOPY NUMBER,
2051: x_msg_data OUT NOCOPY VARCHAR2,
2052: p_clev_tbl IN OKC_CLE_PVT.clev_tbl_type) IS
2053:
2054: BEGIN
2055: OKC_CLE_PVT.Delete_Row(
2056: p_api_version => p_api_version,

Line 2055: OKC_CLE_PVT.Delete_Row(

2051: x_msg_data OUT NOCOPY VARCHAR2,
2052: p_clev_tbl IN OKC_CLE_PVT.clev_tbl_type) IS
2053:
2054: BEGIN
2055: OKC_CLE_PVT.Delete_Row(
2056: p_api_version => p_api_version,
2057: p_init_msg_list => p_init_msg_list,
2058: x_return_status => x_return_status,
2059: x_msg_count => x_msg_count,

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

3180: END IF;
3181: END IF;
3182:
3183: IF (l_debug = 'Y') THEN
3184: okc_debug.log('1400: calling okc_cle_pvt.force_delete_row', 2);
3185: END IF;
3186:
3187: IF NOT l_clev_tbl_in.COUNT=0
3188: THEN

Line 3189: okc_cle_pvt.force_delete_row (

3185: END IF;
3186:
3187: IF NOT l_clev_tbl_in.COUNT=0
3188: THEN
3189: okc_cle_pvt.force_delete_row (
3190: p_api_version => l_api_version,
3191: p_init_msg_list => l_init_msg_list,
3192: x_return_status => l_return_status,
3193: x_msg_count => l_msg_count,

Line 3319: p_clev_rec IN OKC_CLE_PVT.clev_rec_type) IS

3315: p_init_msg_list IN VARCHAR2 ,
3316: x_return_status OUT NOCOPY VARCHAR2,
3317: x_msg_count OUT NOCOPY NUMBER,
3318: x_msg_data OUT NOCOPY VARCHAR2,
3319: p_clev_rec IN OKC_CLE_PVT.clev_rec_type) IS
3320:
3321: BEGIN
3322: OKC_CLE_PVT.Lock_Row(
3323: p_api_version => p_api_version,

Line 3322: OKC_CLE_PVT.Lock_Row(

3318: x_msg_data OUT NOCOPY VARCHAR2,
3319: p_clev_rec IN OKC_CLE_PVT.clev_rec_type) IS
3320:
3321: BEGIN
3322: OKC_CLE_PVT.Lock_Row(
3323: p_api_version => p_api_version,
3324: p_init_msg_list => p_init_msg_list,
3325: x_return_status => x_return_status,
3326: x_msg_count => x_msg_count,

Line 3337: p_clev_tbl IN OKC_CLE_PVT.clev_tbl_type) IS

3333: p_init_msg_list IN VARCHAR2 ,
3334: x_return_status OUT NOCOPY VARCHAR2,
3335: x_msg_count OUT NOCOPY NUMBER,
3336: x_msg_data OUT NOCOPY VARCHAR2,
3337: p_clev_tbl IN OKC_CLE_PVT.clev_tbl_type) IS
3338:
3339: BEGIN
3340: OKC_CLE_PVT.Lock_Row(
3341: p_api_version => p_api_version,

Line 3340: OKC_CLE_PVT.Lock_Row(

3336: x_msg_data OUT NOCOPY VARCHAR2,
3337: p_clev_tbl IN OKC_CLE_PVT.clev_tbl_type) IS
3338:
3339: BEGIN
3340: OKC_CLE_PVT.Lock_Row(
3341: p_api_version => p_api_version,
3342: p_init_msg_list => p_init_msg_list,
3343: x_return_status => x_return_status,
3344: x_msg_count => x_msg_count,

Line 3355: p_clev_rec IN OKC_CLE_PVT.clev_rec_type) IS

3351: p_init_msg_list IN VARCHAR2 ,
3352: x_return_status OUT NOCOPY VARCHAR2,
3353: x_msg_count OUT NOCOPY NUMBER,
3354: x_msg_data OUT NOCOPY VARCHAR2,
3355: p_clev_rec IN OKC_CLE_PVT.clev_rec_type) IS
3356:
3357: BEGIN
3358: OKC_CLE_PVT.Validate_Row(
3359: p_api_version => p_api_version,

Line 3358: OKC_CLE_PVT.Validate_Row(

3354: x_msg_data OUT NOCOPY VARCHAR2,
3355: p_clev_rec IN OKC_CLE_PVT.clev_rec_type) IS
3356:
3357: BEGIN
3358: OKC_CLE_PVT.Validate_Row(
3359: p_api_version => p_api_version,
3360: p_init_msg_list => p_init_msg_list,
3361: x_return_status => x_return_status,
3362: x_msg_count => x_msg_count,

Line 3373: p_clev_tbl IN OKC_CLE_PVT.clev_tbl_type) IS

3369: p_init_msg_list IN VARCHAR2 ,
3370: x_return_status OUT NOCOPY VARCHAR2,
3371: x_msg_count OUT NOCOPY NUMBER,
3372: x_msg_data OUT NOCOPY VARCHAR2,
3373: p_clev_tbl IN OKC_CLE_PVT.clev_tbl_type) IS
3374:
3375: BEGIN
3376: OKC_CLE_PVT.Validate_Row(
3377: p_api_version => p_api_version,

Line 3376: OKC_CLE_PVT.Validate_Row(

3372: x_msg_data OUT NOCOPY VARCHAR2,
3373: p_clev_tbl IN OKC_CLE_PVT.clev_tbl_type) IS
3374:
3375: BEGIN
3376: OKC_CLE_PVT.Validate_Row(
3377: p_api_version => p_api_version,
3378: p_init_msg_list => p_init_msg_list,
3379: x_return_status => x_return_status,
3380: x_msg_count => x_msg_count,

Line 4114: OKC_CLE_PVT.add_language;

4110:
4111: PROCEDURE add_language IS
4112: BEGIN
4113: OKC_CHR_PVT.add_language;
4114: OKC_CLE_PVT.add_language;
4115: END add_language;
4116:
4117: PROCEDURE Get_Active_Process (
4118: p_api_version IN NUMBER,