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.CZ_DEVELOPER_UTILS_PVT dependencies on CZ_SECURITY_PVT

Line 2463: l_locked_entities_tbl cz_security_pvt.number_type_tbl;

2459: x_msg_data OUT NOCOPY VARCHAR2) IS
2460:
2461: l_rule_id NUMBER;
2462: l_rule_folder_id NUMBER;
2463: l_locked_entities_tbl cz_security_pvt.number_type_tbl;
2464: l_has_priveleges VARCHAR2(255);
2465: l_msg_data VARCHAR2(32000);
2466: l_lock_status VARCHAR2(255);
2467: l_return_status VARCHAR2(255);

Line 2484: cz_security_pvt.has_privileges (p_model_id => p_new_parent_folder_id,

2480: -- by calling sequirity package
2481: --
2482: IF gDB_SETTING_USE_SECURITY THEN
2483:
2484: cz_security_pvt.has_privileges (p_model_id => p_new_parent_folder_id,
2485: p_function_name => cz_security_pvt.LOCK_RULEFOLDER_FUNC,
2486: x_return_status => l_return_status,
2487: x_msg_data => l_msg_data,
2488: x_msg_count => l_msg_count);

Line 2485: p_function_name => cz_security_pvt.LOCK_RULEFOLDER_FUNC,

2481: --
2482: IF gDB_SETTING_USE_SECURITY THEN
2483:
2484: cz_security_pvt.has_privileges (p_model_id => p_new_parent_folder_id,
2485: p_function_name => cz_security_pvt.LOCK_RULEFOLDER_FUNC,
2486: x_return_status => l_return_status,
2487: x_msg_data => l_msg_data,
2488: x_msg_count => l_msg_count);
2489:

Line 2490: IF (l_return_status IN(cz_security_pvt.UNEXPECTED_ERROR,cz_security_pvt.HAS_NO_PRIVILEGE)) THEN

2486: x_return_status => l_return_status,
2487: x_msg_data => l_msg_data,
2488: x_msg_count => l_msg_count);
2489:
2490: IF (l_return_status IN(cz_security_pvt.UNEXPECTED_ERROR,cz_security_pvt.HAS_NO_PRIVILEGE)) THEN
2491: x_run_id := GetRunID;
2492: LOG_REPORT(x_run_id,l_msg_count);
2493: RETURN;
2494: END IF;

Line 2498: cz_security_pvt.lock_entity(p_rule_folder_id,

2494: END IF;
2495:
2496: l_locked_entities_tbl.DELETE;
2497:
2498: cz_security_pvt.lock_entity(p_rule_folder_id,
2499: cz_security_pvt.LOCK_RULEFOLDER_FUNC,
2500: l_locked_entities_tbl,
2501: l_lock_status,
2502: l_msg_count,

Line 2499: cz_security_pvt.LOCK_RULEFOLDER_FUNC,

2495:
2496: l_locked_entities_tbl.DELETE;
2497:
2498: cz_security_pvt.lock_entity(p_rule_folder_id,
2499: cz_security_pvt.LOCK_RULEFOLDER_FUNC,
2500: l_locked_entities_tbl,
2501: l_lock_status,
2502: l_msg_count,
2503: l_msg_data);

Line 2597: cz_security_pvt.unlock_entity(p_rule_folder_id,

2593: LOG_REPORT(x_run_id,x_msg_data);
2594: END;
2595:
2596: IF l_locked_entities_tbl.COUNT>0 AND gDB_SETTING_USE_SECURITY THEN
2597: cz_security_pvt.unlock_entity(p_rule_folder_id,
2598: cz_security_pvt.LOCK_RULEFOLDER_FUNC,
2599: l_locked_entities_tbl,
2600: x_return_status,
2601: x_msg_count,

Line 2598: cz_security_pvt.LOCK_RULEFOLDER_FUNC,

2594: END;
2595:
2596: IF l_locked_entities_tbl.COUNT>0 AND gDB_SETTING_USE_SECURITY THEN
2597: cz_security_pvt.unlock_entity(p_rule_folder_id,
2598: cz_security_pvt.LOCK_RULEFOLDER_FUNC,
2599: l_locked_entities_tbl,
2600: x_return_status,
2601: x_msg_count,
2602: x_msg_data);

Line 3238: l_lock_profile := cz_security_pvt.get_locking_profile_value;

3234:
3235: ----check if locking is enabled
3236: ----if the site level profile for locking is not enabled then
3237: ----there is no need to check for locked objects in the folder
3238: l_lock_profile := cz_security_pvt.get_locking_profile_value;
3239: IF (UPPER(NVL(l_lock_profile,'Y')) IN ('Y','YES')) THEN
3240: FOR i IN 1..p_folder_ids.COUNT LOOP
3241: l_folder_id := p_folder_ids(i);
3242:

Line 3671: l_priv := cz_security_pvt.has_privileges (1.0,

3667: IF (l_user_name IS NULL) THEN
3668: RAISE USER_IS_NULL_EXCP;
3669: END IF;
3670:
3671: l_priv := cz_security_pvt.has_privileges (1.0,
3672: l_user_name ,cz_security_pvt.LOCK_MODEL_FUNC,cz_security_pvt.MODEL,l_devl_project_id);
3673: IF (l_priv <> cz_security_pvt.HAS_PRIVILEGE) THEN
3674: RAISE NO_PRIV_EXCP;
3675: END IF;

Line 3672: l_user_name ,cz_security_pvt.LOCK_MODEL_FUNC,cz_security_pvt.MODEL,l_devl_project_id);

3668: RAISE USER_IS_NULL_EXCP;
3669: END IF;
3670:
3671: l_priv := cz_security_pvt.has_privileges (1.0,
3672: l_user_name ,cz_security_pvt.LOCK_MODEL_FUNC,cz_security_pvt.MODEL,l_devl_project_id);
3673: IF (l_priv <> cz_security_pvt.HAS_PRIVILEGE) THEN
3674: RAISE NO_PRIV_EXCP;
3675: END IF;
3676: */

Line 3673: IF (l_priv <> cz_security_pvt.HAS_PRIVILEGE) THEN

3669: END IF;
3670:
3671: l_priv := cz_security_pvt.has_privileges (1.0,
3672: l_user_name ,cz_security_pvt.LOCK_MODEL_FUNC,cz_security_pvt.MODEL,l_devl_project_id);
3673: IF (l_priv <> cz_security_pvt.HAS_PRIVILEGE) THEN
3674: RAISE NO_PRIV_EXCP;
3675: END IF;
3676: */
3677:

Line 3680: cz_security_pvt.lock_model (l_devl_project_id,x_return_status,x_msg_count,x_msg_data);

3676: */
3677:
3678: /*
3679: ----attempt to get a lock
3680: cz_security_pvt.lock_model (l_devl_project_id,x_return_status,x_msg_count,x_msg_data);
3681: IF (x_return_status <> 'T') THEN
3682: RAISE MODEL_LOCKED_EXCP;
3683: END IF;
3684: */

Line 3729: cz_security_pvt.unlock_model (l_devl_project_id,x_return_status,x_msg_count,x_msg_data);

3725: -------------------
3726: -- Unlock the model
3727: -------------------
3728:
3729: cz_security_pvt.unlock_model (l_devl_project_id,x_return_status,x_msg_count,x_msg_data);
3730: IF (x_return_status <> 'T') THEN
3731: RAISE MODEL_UNLOCKED_EXCP;
3732: END IF;
3733: */

Line 3892: l_priv := cz_security_pvt.has_privileges (1.0,

3888: END IF;
3889: */
3890:
3891: /*
3892: l_priv := cz_security_pvt.has_privileges (1.0,
3893: l_user_name ,cz_security_pvt.LOCK_MODEL_FUNC,cz_security_pvt.MODEL,l_devl_project_id);
3894: IF (l_priv <> cz_security_pvt.HAS_PRIVILEGE) THEN
3895: RAISE NO_PRIV_EXCP;
3896: END IF;

Line 3893: l_user_name ,cz_security_pvt.LOCK_MODEL_FUNC,cz_security_pvt.MODEL,l_devl_project_id);

3889: */
3890:
3891: /*
3892: l_priv := cz_security_pvt.has_privileges (1.0,
3893: l_user_name ,cz_security_pvt.LOCK_MODEL_FUNC,cz_security_pvt.MODEL,l_devl_project_id);
3894: IF (l_priv <> cz_security_pvt.HAS_PRIVILEGE) THEN
3895: RAISE NO_PRIV_EXCP;
3896: END IF;
3897:

Line 3894: IF (l_priv <> cz_security_pvt.HAS_PRIVILEGE) THEN

3890:
3891: /*
3892: l_priv := cz_security_pvt.has_privileges (1.0,
3893: l_user_name ,cz_security_pvt.LOCK_MODEL_FUNC,cz_security_pvt.MODEL,l_devl_project_id);
3894: IF (l_priv <> cz_security_pvt.HAS_PRIVILEGE) THEN
3895: RAISE NO_PRIV_EXCP;
3896: END IF;
3897:
3898: ---------------------------------

Line 3902: IF (cz_security_pvt.lock_ui_def(p_ui_def_id) <> 'T') THEN

3898: ---------------------------------
3899: -- attempt to get a lock
3900: ---------------------------------
3901:
3902: IF (cz_security_pvt.lock_ui_def(p_ui_def_id) <> 'T') THEN
3903: RAISE UIDEF_LOCKED_EXCP;
3904: END IF;
3905: */
3906:

Line 4170: l_priv := cz_security_pvt.has_privileges (1.0,

4166: RAISE USER_IS_NULL_EXCP;
4167: END IF;
4168: */
4169: /*
4170: l_priv := cz_security_pvt.has_privileges (1.0,
4171: l_user_name ,cz_security_pvt.LOCK_MODEL_FUNC,cz_security_pvt.MODEL,l_devl_project_id);
4172: IF (l_priv <> cz_security_pvt.HAS_PRIVILEGE) THEN
4173: RAISE NO_PRIV_EXCP;
4174: END IF;

Line 4171: l_user_name ,cz_security_pvt.LOCK_MODEL_FUNC,cz_security_pvt.MODEL,l_devl_project_id);

4167: END IF;
4168: */
4169: /*
4170: l_priv := cz_security_pvt.has_privileges (1.0,
4171: l_user_name ,cz_security_pvt.LOCK_MODEL_FUNC,cz_security_pvt.MODEL,l_devl_project_id);
4172: IF (l_priv <> cz_security_pvt.HAS_PRIVILEGE) THEN
4173: RAISE NO_PRIV_EXCP;
4174: END IF;
4175:

Line 4172: IF (l_priv <> cz_security_pvt.HAS_PRIVILEGE) THEN

4168: */
4169: /*
4170: l_priv := cz_security_pvt.has_privileges (1.0,
4171: l_user_name ,cz_security_pvt.LOCK_MODEL_FUNC,cz_security_pvt.MODEL,l_devl_project_id);
4172: IF (l_priv <> cz_security_pvt.HAS_PRIVILEGE) THEN
4173: RAISE NO_PRIV_EXCP;
4174: END IF;
4175:
4176: ----------------------------------

Line 4180: IF (cz_security_pvt.lock_rulefolder(p_rule_folder_id) <> 'T') THEN

4176: ----------------------------------
4177: -- attempt to get a lock
4178: ----------------------------------
4179:
4180: IF (cz_security_pvt.lock_rulefolder(p_rule_folder_id) <> 'T') THEN
4181: RAISE RFL_LOCKED_EXCP;
4182: END IF;
4183: */
4184: ------------------------------------------------------------------------------------

Line 4336: l_priv := cz_security_pvt.has_privileges (1.0,

4332: RAISE USER_IS_NULL_EXCP;
4333: END IF;
4334: */
4335: /*
4336: l_priv := cz_security_pvt.has_privileges (1.0,
4337: l_user_name ,cz_security_pvt.LOCK_MODEL_FUNC,cz_security_pvt.MODEL,l_devl_project_id);
4338: IF (l_priv <> cz_security_pvt.HAS_PRIVILEGE) THEN
4339: RAISE NO_PRIV_EXCP;
4340: END IF;

Line 4337: l_user_name ,cz_security_pvt.LOCK_MODEL_FUNC,cz_security_pvt.MODEL,l_devl_project_id);

4333: END IF;
4334: */
4335: /*
4336: l_priv := cz_security_pvt.has_privileges (1.0,
4337: l_user_name ,cz_security_pvt.LOCK_MODEL_FUNC,cz_security_pvt.MODEL,l_devl_project_id);
4338: IF (l_priv <> cz_security_pvt.HAS_PRIVILEGE) THEN
4339: RAISE NO_PRIV_EXCP;
4340: END IF;
4341:

Line 4338: IF (l_priv <> cz_security_pvt.HAS_PRIVILEGE) THEN

4334: */
4335: /*
4336: l_priv := cz_security_pvt.has_privileges (1.0,
4337: l_user_name ,cz_security_pvt.LOCK_MODEL_FUNC,cz_security_pvt.MODEL,l_devl_project_id);
4338: IF (l_priv <> cz_security_pvt.HAS_PRIVILEGE) THEN
4339: RAISE NO_PRIV_EXCP;
4340: END IF;
4341:
4342: ----------------------------------

Line 4346: IF (cz_security_pvt.lock_rulefolder(p_rule_sequence_id) <> 'T') THEN

4342: ----------------------------------
4343: -- attempt to get a lock
4344: ----------------------------------
4345:
4346: IF (cz_security_pvt.lock_rulefolder(p_rule_sequence_id) <> 'T') THEN
4347: RAISE RSQ_LOCKED_EXCP;
4348: END IF;
4349: */
4350: ----------------------------------

Line 4473: l_priv := cz_security_pvt.has_privileges (1.0,

4469: RAISE USER_IS_NULL_EXCP;
4470: END IF;
4471: */
4472: /*
4473: l_priv := cz_security_pvt.has_privileges (1.0,
4474: l_user_name ,cz_security_pvt.LOCK_MODEL_FUNC,cz_security_pvt.MODEL,l_devl_project_id);
4475: IF (l_priv <> cz_security_pvt.HAS_PRIVILEGE) THEN
4476: RAISE NO_PRIV_EXCP;
4477: END IF;

Line 4474: l_user_name ,cz_security_pvt.LOCK_MODEL_FUNC,cz_security_pvt.MODEL,l_devl_project_id);

4470: END IF;
4471: */
4472: /*
4473: l_priv := cz_security_pvt.has_privileges (1.0,
4474: l_user_name ,cz_security_pvt.LOCK_MODEL_FUNC,cz_security_pvt.MODEL,l_devl_project_id);
4475: IF (l_priv <> cz_security_pvt.HAS_PRIVILEGE) THEN
4476: RAISE NO_PRIV_EXCP;
4477: END IF;
4478: */

Line 4475: IF (l_priv <> cz_security_pvt.HAS_PRIVILEGE) THEN

4471: */
4472: /*
4473: l_priv := cz_security_pvt.has_privileges (1.0,
4474: l_user_name ,cz_security_pvt.LOCK_MODEL_FUNC,cz_security_pvt.MODEL,l_devl_project_id);
4475: IF (l_priv <> cz_security_pvt.HAS_PRIVILEGE) THEN
4476: RAISE NO_PRIV_EXCP;
4477: END IF;
4478: */
4479:

Line 4637: l_priv := cz_security_pvt.has_model_privileges(p_model_id,'PRJ');

4633:
4634: -------------------------------------
4635: -- check for user privs on this model
4636: -------------------------------------
4637: l_priv := cz_security_pvt.has_model_privileges(p_model_id,'PRJ');
4638: IF (l_priv <> cz_security_pvt.HAS_PRIVILEGE) THEN
4639: RAISE NO_PRIV;
4640: ELSIF (l_priv = FND_API.G_RET_STS_UNEXP_ERROR) THEN
4641: RAISE UNEXPECTED_ERROR;

Line 4638: IF (l_priv <> cz_security_pvt.HAS_PRIVILEGE) THEN

4634: -------------------------------------
4635: -- check for user privs on this model
4636: -------------------------------------
4637: l_priv := cz_security_pvt.has_model_privileges(p_model_id,'PRJ');
4638: IF (l_priv <> cz_security_pvt.HAS_PRIVILEGE) THEN
4639: RAISE NO_PRIV;
4640: ELSIF (l_priv = FND_API.G_RET_STS_UNEXP_ERROR) THEN
4641: RAISE UNEXPECTED_ERROR;
4642: END IF;

Line 4742: p_error_message => ' unexpected error in cz_security_pvt.has_model_privileges()',

4738: x_msg_count => x_msg_count,
4739: x_msg_data => x_msg_data);
4740: WHEN UNEXPECTED_ERROR THEN
4741: handle_Error(p_procedure_name => 'is_model_deleteable',
4742: p_error_message => ' unexpected error in cz_security_pvt.has_model_privileges()',
4743: x_return_status => x_return_status,
4744: x_msg_count => x_msg_count,
4745: x_msg_data => x_msg_data);
4746: WHEN OTHERS THEN

Line 4760: l_locked_model_tbl cz_security_pvt.number_type_tbl;

4756: ,x_msg_count OUT NOCOPY NUMBER
4757: ,x_msg_data OUT NOCOPY VARCHAR2)
4758: IS
4759: LOCK_MODEL_EXCP EXCEPTION;
4760: l_locked_model_tbl cz_security_pvt.number_type_tbl;
4761: BEGIN
4762:
4763: FND_MSG_PUB.initialize;
4764:

Line 4769: cz_security_pvt.lock_model(

4765: is_model_deleteable(p_model_id, x_return_status, x_msg_count, x_msg_data);
4766:
4767: IF ( x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
4768:
4769: cz_security_pvt.lock_model(
4770: p_api_version => 1.0,
4771: p_model_id => p_model_id,
4772: p_lock_child_models => FND_API.G_FALSE,
4773: p_commit_flag => FND_API.G_FALSE,

Line 5918: l_templates cz_security_pvt.number_type_tbl;

5914: l_old_main_message_id NUMBER;
5915: l_index NUMBER;
5916: l_template_type NUMBER;
5917: l_template_name cz_ui_templates.template_name%TYPE;
5918: l_templates cz_security_pvt.number_type_tbl;
5919: l_locked_templates cz_security_pvt.number_type_tbl;
5920: l_return_status VARCHAR2(1);
5921: l_msg_count NUMBER;
5922: l_msg_data VARCHAR2(2000);

Line 5919: l_locked_templates cz_security_pvt.number_type_tbl;

5915: l_index NUMBER;
5916: l_template_type NUMBER;
5917: l_template_name cz_ui_templates.template_name%TYPE;
5918: l_templates cz_security_pvt.number_type_tbl;
5919: l_locked_templates cz_security_pvt.number_type_tbl;
5920: l_return_status VARCHAR2(1);
5921: l_msg_count NUMBER;
5922: l_msg_data VARCHAR2(2000);
5923: FAILED_TO_LOCK_UCT EXCEPTION;

Line 5932: cz_security_pvt.lock_template(

5928: FROM CZ_UI_TEMPLATES
5929: WHERE ui_def_id=0 AND template_id=p_template_id;
5930:
5931: l_templates(1) := p_template_id;
5932: cz_security_pvt.lock_template(
5933: p_api_version => 1.0,
5934: p_templates_to_lock => l_templates,
5935: p_commit_flag => FND_API.G_FALSE,
5936: p_init_msg_list => FND_API.G_FALSE,

Line 6094: cz_security_pvt.unlock_template(

6090: IF SQL%ROWCOUNT = 0 THEN
6091: RAISE INVALID_TEMPLATE_ID_EXCP;
6092: END IF;
6093: IF ( l_locked_templates.COUNT > 0 ) THEN
6094: cz_security_pvt.unlock_template(
6095: p_api_version => 1.0,
6096: p_templates_to_unlock => l_locked_templates,
6097: p_commit_flag => FND_API.G_FALSE,
6098: p_init_msg_list => FND_API.G_FALSE,

Line 6126: cz_security_pvt.unlock_template(p_api_version => 1.0,

6122: x_return_status => x_return_status,
6123: x_msg_count => x_msg_count,
6124: x_msg_data => x_msg_data);
6125: IF ( l_locked_templates.COUNT > 0 ) THEN
6126: cz_security_pvt.unlock_template(p_api_version => 1.0,
6127: p_templates_to_unlock => l_locked_templates,
6128: p_commit_flag => FND_API.G_FALSE,
6129: p_init_msg_list => FND_API.G_FALSE,
6130: x_return_status => l_return_status,

Line 8308: l_locked_models_tbl cz_security_pvt.number_type_tbl;

8304: TYPE object_type_tbl IS TABLE OF VARCHAR2(3) INDEX BY BINARY_INTEGER;
8305: l_rp_fld_tbl number_type_tbl;
8306: l_object_id_tbl number_type_tbl;
8307: l_object_typ_tbl object_type_tbl;
8308: l_locked_models_tbl cz_security_pvt.number_type_tbl;
8309: l_model_name cz_devl_projects.name%TYPE;
8310: l_template_name cz_ui_templates.template_name%TYPE;
8311: l_count NUMBER := 0;
8312: FAILED_TO_LOCK_PRJ EXCEPTION;

Line 8358: cz_security_pvt.lock_model(

8354: IF (l_object_id_tbl.COUNT > 0) THEN
8355: FOR I IN l_object_id_tbl.FIRST..l_object_id_tbl.LAST
8356: LOOP
8357: IF (l_object_typ_tbl(i) = 'PRJ') THEN
8358: cz_security_pvt.lock_model(
8359: p_api_version => 1.0,
8360: p_model_id => l_object_id_tbl(i),
8361: p_lock_child_models => FND_API.G_FALSE,
8362: p_commit_flag => FND_API.G_FALSE,

Line 8377: cz_security_pvt.lock_template(

8373: SET deleted_flag = '1'
8374: WHERE devl_project_id = l_object_id_tbl(i) ;
8375:
8376: ELSIF (l_object_typ_tbl(i) = 'UCT') THEN
8377: cz_security_pvt.lock_template(
8378: p_api_version => 1.0,
8379: p_template_id => l_object_id_tbl(i),
8380: p_commit_flag => FND_API.G_FALSE,
8381: p_init_msg_list => FND_API.G_FALSE,