APPS.CZ_MODELOPERATIONS_PUB dependencies on CZ_SECURITY_PVT

Line 1656: l_locked_models_tbl cz_security_pvt.number_type_tbl;

1652: l_dummy_nbr NUMBER;
1653: l_msg_data VARCHAR2(2000);
1654: l_msg_count NUMBER := 0;
1655: l_return_status VARCHAR2(1);
1656: l_locked_models_tbl cz_security_pvt.number_type_tbl;
1657: l_model_id_tbl cz_security_pvt.number_type_tbl;
1658: l_devl_prj_id_tbl cz_security_pvt.number_type_tbl;
1659: l_all_locked_models_tbl cz_security_pvt.number_type_tbl;
1660:

Line 1657: l_model_id_tbl cz_security_pvt.number_type_tbl;

1653: l_msg_data VARCHAR2(2000);
1654: l_msg_count NUMBER := 0;
1655: l_return_status VARCHAR2(1);
1656: l_locked_models_tbl cz_security_pvt.number_type_tbl;
1657: l_model_id_tbl cz_security_pvt.number_type_tbl;
1658: l_devl_prj_id_tbl cz_security_pvt.number_type_tbl;
1659: l_all_locked_models_tbl cz_security_pvt.number_type_tbl;
1660:
1661: NO_PRIV_EXCP EXCEPTION;

Line 1658: l_devl_prj_id_tbl cz_security_pvt.number_type_tbl;

1654: l_msg_count NUMBER := 0;
1655: l_return_status VARCHAR2(1);
1656: l_locked_models_tbl cz_security_pvt.number_type_tbl;
1657: l_model_id_tbl cz_security_pvt.number_type_tbl;
1658: l_devl_prj_id_tbl cz_security_pvt.number_type_tbl;
1659: l_all_locked_models_tbl cz_security_pvt.number_type_tbl;
1660:
1661: NO_PRIV_EXCP EXCEPTION;
1662: PRIV_CHECK_ERR_EXP EXCEPTION;

Line 1659: l_all_locked_models_tbl cz_security_pvt.number_type_tbl;

1655: l_return_status VARCHAR2(1);
1656: l_locked_models_tbl cz_security_pvt.number_type_tbl;
1657: l_model_id_tbl cz_security_pvt.number_type_tbl;
1658: l_devl_prj_id_tbl cz_security_pvt.number_type_tbl;
1659: l_all_locked_models_tbl cz_security_pvt.number_type_tbl;
1660:
1661: NO_PRIV_EXCP EXCEPTION;
1662: PRIV_CHECK_ERR_EXP EXCEPTION;
1663: FAILED_TO_LOCK_MODEL_EXCP EXCEPTION;

Line 1725: cz_security_pvt.lock_model(

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

Line 1757: cz_security_pvt.unlock_model(

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

Line 1819: cz_security_pvt.unlock_model(

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

Line 1883: cz_security_pvt.force_unlock_model (p_api_version,

1879: x_msg_data OUT NOCOPY VARCHAR2)
1880: IS
1881:
1882: BEGIN
1883: cz_security_pvt.force_unlock_model (p_api_version,
1884: p_model_id,
1885: p_unlock_references,
1886: p_init_msg_list,
1887: x_return_status,

Line 1945: cz_security_pvt.force_unlock_template (p_api_version,

1941: x_msg_data OUT NOCOPY VARCHAR2)
1942: IS
1943:
1944: BEGIN
1945: cz_security_pvt.force_unlock_template (p_api_version,
1946: p_template_id,
1947: p_init_msg_list,
1948: x_return_status,
1949: x_msg_count,