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_STD_ARTICLE_PVT dependencies on OKC_SAI_PVT

Line 1201: OKC_SAI_PVT.insert_row(p_api_version,

1197: x_msg_data OUT NOCOPY VARCHAR2,
1198: p_saiv_tbl IN saiv_tbl_type,
1199: x_saiv_tbl OUT NOCOPY saiv_tbl_type) IS
1200: BEGIN
1201: OKC_SAI_PVT.insert_row(p_api_version,
1202: p_init_msg_list,
1203: x_return_status,
1204: x_msg_count,
1205: x_msg_data,

Line 1229: OKC_SAI_PVT.validate_unique(l_saiv_rec,x_return_status);

1225: l_saiv_rec:=p_saiv_rec;
1226: l_saiv_rec.sae_id:=p_saiv_rec.sae_id_for;
1227: l_saiv_rec.sae_id_for:=p_saiv_rec.sae_id;
1228:
1229: OKC_SAI_PVT.validate_unique(l_saiv_rec,x_return_status);
1230: IF (x_return_status = OKC_API.G_RET_STS_SUCCESS) THEN
1231: OKC_SAI_PVT.insert_row(p_api_version,
1232: p_init_msg_list,
1233: x_return_status,

Line 1231: OKC_SAI_PVT.insert_row(p_api_version,

1227: l_saiv_rec.sae_id_for:=p_saiv_rec.sae_id;
1228:
1229: OKC_SAI_PVT.validate_unique(l_saiv_rec,x_return_status);
1230: IF (x_return_status = OKC_API.G_RET_STS_SUCCESS) THEN
1231: OKC_SAI_PVT.insert_row(p_api_version,
1232: p_init_msg_list,
1233: x_return_status,
1234: x_msg_count,
1235: x_msg_data,

Line 1260: OKC_SAI_PVT.lock_row(p_api_version,

1256: x_msg_count OUT NOCOPY NUMBER,
1257: x_msg_data OUT NOCOPY VARCHAR2,
1258: p_saiv_tbl IN saiv_tbl_type) IS
1259: BEGIN
1260: OKC_SAI_PVT.lock_row(p_api_version,
1261: p_init_msg_list,
1262: x_return_status,
1263: x_msg_count,
1264: x_msg_data,

Line 1290: OKC_SAI_PVT.lock_row(p_api_version,

1286: FETCH l_sai_csr into l_dummy_var;
1287: CLOSE l_sai_csr;
1288: IF (l_dummy_var<>'1') Then --if opposite combination record doesnot exist then
1289: --lock the record if the combination exists like this
1290: OKC_SAI_PVT.lock_row(p_api_version,
1291: p_init_msg_list,
1292: x_return_status,
1293: x_msg_count,
1294: x_msg_data,

Line 1301: OKC_SAI_PVT.lock_row(p_api_version,

1297: l_saiv_rec:=p_saiv_rec;
1298: l_saiv_rec.sae_id:=p_saiv_rec.sae_id_for;
1299: l_saiv_rec.sae_id_for:=p_saiv_rec.sae_id;
1300: -- lock the opposite combination as the record might exist the opposite combination way
1301: OKC_SAI_PVT.lock_row(p_api_version,
1302: p_init_msg_list,
1303: x_return_status,
1304: x_msg_count,
1305: x_msg_data,

Line 1329: OKC_SAI_PVT.update_row(p_api_version,

1325: x_msg_data OUT NOCOPY VARCHAR2,
1326: p_saiv_tbl IN saiv_tbl_type,
1327: x_saiv_tbl OUT NOCOPY saiv_tbl_type) IS
1328: BEGIN
1329: OKC_SAI_PVT.update_row(p_api_version,
1330: p_init_msg_list,
1331: x_return_status,
1332: x_msg_count,
1333: x_msg_data,

Line 1365: OKC_SAI_PVT.update_row(p_api_version,

1361: FETCH l_sai_csr into l_dummy_var;
1362: CLOSE l_sai_csr;
1363: IF (l_dummy_var<>'1') Then --if opposite combination record doesnot exist then
1364: --update the record if the combination exists like this
1365: OKC_SAI_PVT.update_row(p_api_version,
1366: p_init_msg_list,
1367: x_return_status,
1368: x_msg_count,
1369: x_msg_data,

Line 1377: OKC_SAI_PVT.update_row(p_api_version,

1373: l_saiv_rec:=p_saiv_rec;
1374: l_saiv_rec.sae_id:=p_saiv_rec.sae_id_for;
1375: l_saiv_rec.sae_id_for:=p_saiv_rec.sae_id;
1376: -- update the opposite combination as the record might exist the opposite combination way
1377: OKC_SAI_PVT.update_row(p_api_version,
1378: p_init_msg_list,
1379: x_return_status,
1380: x_msg_count,
1381: x_msg_data,

Line 1406: OKC_SAI_PVT.delete_row(p_api_version,

1402: x_msg_count OUT NOCOPY NUMBER,
1403: x_msg_data OUT NOCOPY VARCHAR2,
1404: p_saiv_tbl IN saiv_tbl_type) IS
1405: BEGIN
1406: OKC_SAI_PVT.delete_row(p_api_version,
1407: p_init_msg_list,
1408: x_return_status,
1409: x_msg_count,
1410: x_msg_data,

Line 1435: OKC_SAI_PVT.delete_row(p_api_version,

1431: FETCH l_sai_csr into l_dummy_var;
1432: CLOSE l_sai_csr;
1433: IF (l_dummy_var<>'1') Then --if opposite combination record doesnot exist then
1434: --delete the record if the combination exists like this
1435: OKC_SAI_PVT.delete_row(p_api_version,
1436: p_init_msg_list,
1437: x_return_status,
1438: x_msg_count,
1439: x_msg_data,

Line 1446: OKC_SAI_PVT.delete_row(p_api_version,

1442: l_saiv_rec:=p_saiv_rec;
1443: l_saiv_rec.sae_id:=p_saiv_rec.sae_id_for;
1444: l_saiv_rec.sae_id_for:=p_saiv_rec.sae_id;
1445: -- try to delete the opposite combination as the record might exist the opposite combination way
1446: OKC_SAI_PVT.delete_row(p_api_version,
1447: p_init_msg_list,
1448: x_return_status,
1449: x_msg_count,
1450: x_msg_data,

Line 1475: OKC_SAI_PVT.validate_row(p_api_version,

1471: x_msg_count OUT NOCOPY NUMBER,
1472: x_msg_data OUT NOCOPY VARCHAR2,
1473: p_saiv_tbl IN saiv_tbl_type) IS
1474: BEGIN
1475: OKC_SAI_PVT.validate_row(p_api_version,
1476: p_init_msg_list,
1477: x_return_status,
1478: x_msg_count,
1479: x_msg_data,

Line 1509: OKC_SAI_PVT.validate_row(p_api_version,

1505: FETCH l_sai_csr into l_dummy_var;
1506: CLOSE l_sai_csr;
1507: IF (l_dummy_var<>'1') Then --if opposite combination record doesnot exist then
1508: --validate the record if the combination exists like this
1509: OKC_SAI_PVT.validate_row(p_api_version,
1510: p_init_msg_list,
1511: x_return_status,
1512: x_msg_count,
1513: x_msg_data,

Line 1520: OKC_SAI_PVT.validate_row(p_api_version,

1516: l_saiv_rec:=p_saiv_rec;
1517: l_saiv_rec.sae_id:=p_saiv_rec.sae_id_for;
1518: l_saiv_rec.sae_id_for:=p_saiv_rec.sae_id;
1519: -- validate the opposite combination as the record might exist the opposite combination way
1520: OKC_SAI_PVT.validate_row(p_api_version,
1521: p_init_msg_list,
1522: x_return_status,
1523: x_msg_count,
1524: x_msg_data,

Line 1569: OKC_SAI_PVT.validate_unique(p_saiv_rec,l_return_status);

1565: RAISE OKC_API.G_EXCEPTION_ERROR;
1566: END IF;
1567:
1568: --check if the record exists
1569: OKC_SAI_PVT.validate_unique(p_saiv_rec,l_return_status);
1570:
1571: --- If any errors happen abort API
1572: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1573: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

Line 1583: OKC_SAI_PVT.validate_unique(l_saiv_rec,l_return_status);

1579: l_saiv_rec.sae_id:=p_saiv_rec.sae_id_for;
1580: l_saiv_rec.sae_id_for:=p_saiv_rec.sae_id;
1581: -- validate opposite combination as the record might exist the opposite combination way
1582:
1583: OKC_SAI_PVT.validate_unique(l_saiv_rec,l_return_status);
1584: --- If any errors happen abort API
1585: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1586: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1587: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN