DBA Data[Home] [Help]

APPS.OKC_STD_ARTICLE_PVT dependencies on OKC_SAC_PVT

Line 1635: OKC_SAC_PVT.insert_row(p_api_version,

1631: x_msg_data OUT NOCOPY VARCHAR2,
1632: p_sacv_tbl IN sacv_tbl_type,
1633: x_sacv_tbl OUT NOCOPY sacv_tbl_type) IS
1634: BEGIN
1635: OKC_SAC_PVT.insert_row(p_api_version,
1636: p_init_msg_list,
1637: x_return_status,
1638: x_msg_count,
1639: x_msg_data,

Line 1653: OKC_SAC_PVT.insert_row(p_api_version,

1649: x_msg_data OUT NOCOPY VARCHAR2,
1650: p_sacv_rec IN sacv_rec_type,
1651: x_sacv_rec OUT NOCOPY sacv_rec_type) IS
1652: BEGIN
1653: OKC_SAC_PVT.insert_row(p_api_version,
1654: p_init_msg_list,
1655: x_return_status,
1656: x_msg_count,
1657: x_msg_data,

Line 1670: OKC_SAC_PVT.lock_row(p_api_version,

1666: x_msg_count OUT NOCOPY NUMBER,
1667: x_msg_data OUT NOCOPY VARCHAR2,
1668: p_sacv_tbl IN sacv_tbl_type)IS
1669: BEGIN
1670: OKC_SAC_PVT.lock_row(p_api_version,
1671: p_init_msg_list,
1672: x_return_status,
1673: x_msg_count,
1674: x_msg_data,

Line 1687: OKC_SAC_PVT.lock_row(p_api_version,

1683: x_msg_count OUT NOCOPY NUMBER,
1684: x_msg_data OUT NOCOPY VARCHAR2,
1685: p_sacv_rec IN sacv_rec_type) IS
1686: BEGIN
1687: OKC_SAC_PVT.lock_row(p_api_version,
1688: p_init_msg_list,
1689: x_return_status,
1690: x_msg_count,
1691: x_msg_data,

Line 1705: OKC_SAC_PVT.update_row(p_api_version,

1701: x_msg_data OUT NOCOPY VARCHAR2,
1702: p_sacv_tbl IN sacv_tbl_type,
1703: x_sacv_tbl OUT NOCOPY sacv_tbl_type) IS
1704: BEGIN
1705: OKC_SAC_PVT.update_row(p_api_version,
1706: p_init_msg_list,
1707: x_return_status,
1708: x_msg_count,
1709: x_msg_data,

Line 1724: OKC_SAC_PVT.update_row(p_api_version,

1720: x_msg_data OUT NOCOPY VARCHAR2,
1721: p_sacv_rec IN sacv_rec_type,
1722: x_sacv_rec OUT NOCOPY sacv_rec_type) IS
1723: BEGIN
1724: OKC_SAC_PVT.update_row(p_api_version,
1725: p_init_msg_list,
1726: x_return_status,
1727: x_msg_count,
1728: x_msg_data,

Line 1741: OKC_SAC_PVT.delete_row(p_api_version,

1737: x_msg_count OUT NOCOPY NUMBER,
1738: x_msg_data OUT NOCOPY VARCHAR2,
1739: p_sacv_tbl IN sacv_tbl_type) IS
1740: BEGIN
1741: OKC_SAC_PVT.delete_row(p_api_version,
1742: p_init_msg_list,
1743: x_return_status,
1744: x_msg_count,
1745: x_msg_data,

Line 1758: OKC_SAC_PVT.delete_row(p_api_version,

1754: x_msg_count OUT NOCOPY NUMBER,
1755: x_msg_data OUT NOCOPY VARCHAR2,
1756: p_sacv_rec IN sacv_rec_type) IS
1757: BEGIN
1758: OKC_SAC_PVT.delete_row(p_api_version,
1759: p_init_msg_list,
1760: x_return_status,
1761: x_msg_count,
1762: x_msg_data,

Line 1774: OKC_SAC_PVT.validate_row(p_api_version,

1770: x_msg_count OUT NOCOPY NUMBER,
1771: x_msg_data OUT NOCOPY VARCHAR2,
1772: p_sacv_tbl IN sacv_tbl_type) IS
1773: BEGIN
1774: OKC_SAC_PVT.validate_row(p_api_version,
1775: p_init_msg_list,
1776: x_return_status,
1777: x_msg_count,
1778: x_msg_data,

Line 1791: OKC_SAC_PVT.validate_row(p_api_version,

1787: x_msg_count OUT NOCOPY NUMBER,
1788: x_msg_data OUT NOCOPY VARCHAR2,
1789: p_sacv_rec IN sacv_rec_type) IS
1790: BEGIN
1791: OKC_SAC_PVT.validate_row(p_api_version,
1792: p_init_msg_list,
1793: x_return_status,
1794: x_msg_count,
1795: x_msg_data,

Line 1838: OKC_SAC_PVT.validate_price_type(p_sacv_rec,l_return_status);

1834: END IF;
1835: */
1836:
1837: --- Validate price_type
1838: OKC_SAC_PVT.validate_price_type(p_sacv_rec,l_return_status);
1839: --- If any errors happen abort API
1840: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1841: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1842: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN

Line 1921: OKC_SAC_PVT.validate_scs_code(p_sacv_rec,l_return_status);

1917: END IF;
1918: */
1919:
1920: --- Validate scs_code
1921: OKC_SAC_PVT.validate_scs_code(p_sacv_rec,l_return_status);
1922: --- If any errors happen abort API
1923: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1924: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1925: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN