DBA Data[Home] [Help]

APPS.CZ_MODELOPERATIONS_PUB dependencies on CZ_SECURITY_PVT

Line 1652: l_locked_models_tbl cz_security_pvt.number_type_tbl;

1648: l_dummy_nbr NUMBER;
1649: l_msg_data VARCHAR2(2000);
1650: l_msg_count NUMBER := 0;
1651: l_return_status VARCHAR2(1);
1652: l_locked_models_tbl cz_security_pvt.number_type_tbl;
1653: l_model_id_tbl cz_security_pvt.number_type_tbl;
1654: l_devl_prj_id_tbl cz_security_pvt.number_type_tbl;
1655: l_all_locked_models_tbl cz_security_pvt.number_type_tbl;
1656:

Line 1653: l_model_id_tbl cz_security_pvt.number_type_tbl;

1649: l_msg_data VARCHAR2(2000);
1650: l_msg_count NUMBER := 0;
1651: l_return_status VARCHAR2(1);
1652: l_locked_models_tbl cz_security_pvt.number_type_tbl;
1653: l_model_id_tbl cz_security_pvt.number_type_tbl;
1654: l_devl_prj_id_tbl cz_security_pvt.number_type_tbl;
1655: l_all_locked_models_tbl cz_security_pvt.number_type_tbl;
1656:
1657: NO_PRIV_EXCP EXCEPTION;

Line 1654: l_devl_prj_id_tbl cz_security_pvt.number_type_tbl;

1650: l_msg_count NUMBER := 0;
1651: l_return_status VARCHAR2(1);
1652: l_locked_models_tbl cz_security_pvt.number_type_tbl;
1653: l_model_id_tbl cz_security_pvt.number_type_tbl;
1654: l_devl_prj_id_tbl cz_security_pvt.number_type_tbl;
1655: l_all_locked_models_tbl cz_security_pvt.number_type_tbl;
1656:
1657: NO_PRIV_EXCP EXCEPTION;
1658: PRIV_CHECK_ERR_EXP EXCEPTION;

Line 1655: l_all_locked_models_tbl cz_security_pvt.number_type_tbl;

1651: l_return_status VARCHAR2(1);
1652: l_locked_models_tbl cz_security_pvt.number_type_tbl;
1653: l_model_id_tbl cz_security_pvt.number_type_tbl;
1654: l_devl_prj_id_tbl cz_security_pvt.number_type_tbl;
1655: l_all_locked_models_tbl cz_security_pvt.number_type_tbl;
1656:
1657: NO_PRIV_EXCP EXCEPTION;
1658: PRIV_CHECK_ERR_EXP EXCEPTION;
1659: FAILED_TO_LOCK_MODEL_EXCP EXCEPTION;

Line 1721: cz_security_pvt.lock_model(

1717: IF (l_model_id_tbl.COUNT > 0) THEN
1718: FOR i IN l_model_id_tbl.FIRST..l_model_id_tbl.LAST LOOP
1719: IF (l_model_id_tbl(i) <> 0) THEN
1720: l_locked_models_tbl.DELETE;
1721: cz_security_pvt.lock_model(
1722: p_api_version => 1.0,
1723: p_model_id => l_model_id_tbl(i),
1724: p_lock_child_models => FND_API.G_FALSE,
1725: p_commit_flag => FND_API.G_TRUE,

Line 1753: cz_security_pvt.unlock_model(

1749: CZ_IMP_ALL.go_generic(x_run_id, p_run_id, p_rp_folder_id);
1750: x_status := G_STATUS_SUCCESS;
1751:
1752: IF (l_all_locked_models_tbl.COUNT > 0) THEN
1753: cz_security_pvt.unlock_model(
1754: p_api_version => 1.0,
1755: p_commit_flag => FND_API.G_TRUE,
1756: p_models_to_unlock => l_all_locked_models_tbl,
1757: x_return_status => l_return_status,

Line 1815: cz_security_pvt.unlock_model(

1811: INSERT INTO cz_db_logs (message, statuscode, caller, urgency, run_id, logtime)
1812: VALUES (l_msg_data, 11276, G_PKG_NAME||'.'||l_api_name, 1, p_run_id, SYSDATE);
1813: COMMIT;
1814: IF (l_all_locked_models_tbl.COUNT > 0) THEN
1815: cz_security_pvt.unlock_model(
1816: p_api_version => 1.0,
1817: p_commit_flag => FND_API.G_TRUE,
1818: p_models_to_unlock => l_all_locked_models_tbl,
1819: x_return_status => l_return_status,

Line 1879: cz_security_pvt.force_unlock_model (p_api_version,

1875: x_msg_data OUT NOCOPY VARCHAR2)
1876: IS
1877:
1878: BEGIN
1879: cz_security_pvt.force_unlock_model (p_api_version,
1880: p_model_id,
1881: p_unlock_references,
1882: p_init_msg_list,
1883: x_return_status,

Line 1941: cz_security_pvt.force_unlock_template (p_api_version,

1937: x_msg_data OUT NOCOPY VARCHAR2)
1938: IS
1939:
1940: BEGIN
1941: cz_security_pvt.force_unlock_template (p_api_version,
1942: p_template_id,
1943: p_init_msg_list,
1944: x_return_status,
1945: x_msg_count,