DBA Data[Home] [Help]

APPS.CZ_IMP_SINGLE dependencies on CZ_SECURITY_PVT

Line 3790: l_locked_models cz_security_pvt.number_type_tbl;

3786:
3787: l_msg_data VARCHAR2(2000);
3788: l_msg_count NUMBER := 0;
3789: l_return_status VARCHAR2(1);
3790: l_locked_models cz_security_pvt.number_type_tbl;
3791: l_checkout_user cz_security_pvt.varchar_type_tbl;
3792: HAS_NO_PRIV EXCEPTION;
3793: PRIV_CHECK_ERR EXCEPTION;
3794: FAILED_TO_LOCK_MODEL EXCEPTION;

Line 3791: l_checkout_user cz_security_pvt.varchar_type_tbl;

3787: l_msg_data VARCHAR2(2000);
3788: l_msg_count NUMBER := 0;
3789: l_return_status VARCHAR2(1);
3790: l_locked_models cz_security_pvt.number_type_tbl;
3791: l_checkout_user cz_security_pvt.varchar_type_tbl;
3792: HAS_NO_PRIV EXCEPTION;
3793: PRIV_CHECK_ERR EXCEPTION;
3794: FAILED_TO_LOCK_MODEL EXCEPTION;
3795:

Line 4015: cz_security_pvt.lock_model(

4011: ----------deep-lock the model if it exists
4012: FOR j IN (SELECT devl_project_id FROM cz_devl_projects
4013: WHERE devl_project_id = nModelId AND deleted_flag='0')
4014: LOOP
4015: cz_security_pvt.lock_model(
4016: p_api_version => 1.0,
4017: p_model_id => nModelId,
4018: p_lock_child_models => FND_API.G_TRUE,
4019: p_commit_flag => FND_API.G_TRUE,

Line 4347: cz_security_pvt.unlock_model(

4343:
4344: ----6) Unlock model
4345: IF ( l_locked_models.COUNT > 0 ) THEN
4346: BEGIN
4347: cz_security_pvt.unlock_model(
4348: p_api_version => 1.0,
4349: p_commit_flag => FND_API.G_TRUE,
4350: p_models_to_unlock => l_locked_models,
4351: x_return_status => l_return_status,

Line 4373: cz_security_pvt.unlock_model(

4369: xERROR:=cz_utils.log_report(SQLERRM,1,'SINGLEBILL.GENERAL',11276,genRun_ID);
4370: WHEN OTHERS THEN
4371: IF ( l_locked_models.COUNT > 0 ) THEN
4372: BEGIN
4373: cz_security_pvt.unlock_model(
4374: p_api_version => 1.0,
4375: p_commit_flag => FND_API.G_TRUE,
4376: p_models_to_unlock => l_locked_models,
4377: x_return_status => l_return_status,