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_SECURITY_PVT dependencies on CZ_PUBLICATION_LOCKS

Line 4261: * are in processing . Using this lock_status , update the current publication lock_status in cz_publication_locks

4257:
4258: ------------------------------------->>>>>>>>>>>>>>>>
4259: /* bug #10417318
4260: * get_prev_lock_status procedure provides the lock_status of a model from other publications which
4261: * are in processing . Using this lock_status , update the current publication lock_status in cz_publication_locks
4262: * for that model
4263: * Lock Status = 0 (Explict Locking) = 1 (Implicit Locking) */
4264: PROCEDURE get_prev_lock_status (p_object_id IN NUMBER,
4265: p_object_type IN VARCHAR2,

Line 4277: FROM cz_publication_locks

4273: BEGIN
4274:
4275: SELECT lock_status
4276: INTO x_lock_status
4277: FROM cz_publication_locks
4278: WHERE (publication_id <> p_pub_id)
4279: AND object_id = p_object_id
4280: AND object_type = p_object_type
4281: AND deleted_flag = '0'

Line 4294: * update_pub_lock_status procedure update cz_publication_locks.lock_status

4290: RAISE;
4291: END get_prev_lock_status;
4292: --------------------------------------->>>>>>>>>>>>>>>>>>
4293: /* bug #10417318
4294: * update_pub_lock_status procedure update cz_publication_locks.lock_status
4295: * Lock Status = 0 (Explict Locking) = 1 (Implicit Locking) */
4296: PROCEDURE update_pub_lock_status(p_lock_status IN VARCHAR2,
4297: p_object_id IN NUMBER,
4298: p_object_type IN VARCHAR2,

Line 4304: UPDATE cz_publication_locks

4300: IS
4301:
4302: BEGIN
4303:
4304: UPDATE cz_publication_locks
4305: SET lock_status = p_lock_status
4306: WHERE publication_id = p_pub_id
4307: AND object_id = p_object_id
4308: AND object_type = p_object_type

Line 4472: INSERT INTO cz_publication_locks ( publication_id, object_type, OBJECT_ID, server_id, deleted_flag, lock_time, lock_by)

4468: l_count := 0;
4469: l_lock_status := '0';
4470:
4471: -----Insert into cz_model_locking table here for all the models (child and parent)
4472: INSERT INTO cz_publication_locks ( publication_id, object_type, OBJECT_ID, server_id, deleted_flag, lock_time, lock_by)
4473: VALUES (p_pub_id, 'PRJ', x_locked_models(i), p_server_id, '0', sysdate, FND_GLOBAL.user_name);
4474:
4475: -------get_prev_lock_status
4476: get_prev_lock_status(x_locked_models(i), 'PRJ', p_pub_id, l_lock_status);

Line 4488: FROM cz_publication_locks

4484: AND (cz_devl_projects.checkout_user IS NULL)
4485: AND cz_devl_projects.deleted_flag = '0'
4486: ---- add following logic for locking the very first entry for that object
4487: AND EXISTS (SELECT count(*)
4488: FROM cz_publication_locks
4489: WHERE object_type='PRJ'
4490: AND deleted_flag = '0'
4491: AND object_id = x_locked_models(i)
4492: GROUP BY object_id HAVING count(*) = 1);

Line 4501: ELSE ---- Updating cz_publication_locks.Lock_status if it is implicitly locked already

4497: get_checkout_user(x_locked_models(i),'PRJ',l_checkout_user,l_model_name);
4498: IF(l_checkout_user<>FND_GLOBAL.user_name AND l_checkout_user is not null)
4499: THEN
4500: RAISE MODEL_IS_LOCKED;
4501: ELSE ---- Updating cz_publication_locks.Lock_status if it is implicitly locked already
4502: IF(l_lock_status = '1') THEN
4503: update_pub_lock_status(l_lock_status, x_locked_models(i), 'PRJ', p_pub_id);
4504: ELSE ------- updating cz_publication_locks.Lock_status that it is explicitly locked
4505: update_pub_lock_status('0', x_locked_models(i), 'PRJ', p_pub_id);

Line 4504: ELSE ------- updating cz_publication_locks.Lock_status that it is explicitly locked

4500: RAISE MODEL_IS_LOCKED;
4501: ELSE ---- Updating cz_publication_locks.Lock_status if it is implicitly locked already
4502: IF(l_lock_status = '1') THEN
4503: update_pub_lock_status(l_lock_status, x_locked_models(i), 'PRJ', p_pub_id);
4504: ELSE ------- updating cz_publication_locks.Lock_status that it is explicitly locked
4505: update_pub_lock_status('0', x_locked_models(i), 'PRJ', p_pub_id);
4506: END IF;
4507: END IF;
4508: ELSE

Line 4651: FROM cz_publication_locks

4647: AND cz_devl_projects.deleted_flag = '0'
4648: AND (cz_devl_projects.checkout_user IS NULL
4649: OR cz_devl_projects.checkout_user = FND_GLOBAL.user_name)
4650: AND EXISTS (SELECT count(*)
4651: FROM cz_publication_locks
4652: WHERE object_type='PRJ'
4653: AND deleted_flag = '0'
4654: AND lock_status = '1'
4655: AND object_id= p_model_id

Line 4696: UPDATE cz_publication_locks

4692: END;
4693:
4694: --Delete all the model entries for that publication at the end of the successful publications
4695: BEGIN
4696: UPDATE cz_publication_locks
4697: SET deleted_flag = '1',
4698: lock_by = FND_GLOBAL.user_name,
4699: lock_time = sysdate
4700: WHERE publication_id = p_pub_id

Line 4798: INSERT INTO cz_publication_locks ( publication_id, object_type, OBJECT_ID, server_id, deleted_flag, lock_time, lock_by)

4794: RAISE TEMPLATEID_IS_NULL;
4795: END IF; /* IF (p_template_id IS NULL) */
4796:
4797: ----- Insert into cz_model_locking table here for all the Templates (child and parent)
4798: INSERT INTO cz_publication_locks ( publication_id, object_type, OBJECT_ID, server_id, deleted_flag, lock_time, lock_by)
4799: VALUES (p_pub_id, 'UIT', p_template_id, p_server_id, '0', sysdate, FND_GLOBAL.user_name);
4800:
4801: ----- get_prev_lock_status
4802: get_prev_lock_status(p_template_id, 'UIT', p_pub_id, l_lock_status);

Line 4811: AND EXISTS (SELECT count(*) FROM cz_publication_locks

4807: SET cz_ui_templates.checkout_user = FND_GLOBAL.user_name,
4808: cz_ui_templates.checkout_time = sysdate
4809: WHERE cz_ui_templates.template_id = p_template_id
4810: AND (cz_ui_templates.checkout_user IS NULL)
4811: AND EXISTS (SELECT count(*) FROM cz_publication_locks
4812: WHERE object_type='UIT'
4813: AND deleted_flag = '0'
4814: AND object_id = p_template_id
4815: GROUP BY object_id HAVING count(*) = 1);

Line 4822: ELSE -----updating cz_publication_locks.Lock_status that it is Implicitly locked

4818: get_checkout_user(p_template_id,'UIT',l_checkout_user,l_template_name);
4819: IF(l_checkout_user<>FND_GLOBAL.user_name AND l_checkout_user is not null)
4820: THEN
4821: RAISE TEMPLATE_IS_LOCKED;
4822: ELSE -----updating cz_publication_locks.Lock_status that it is Implicitly locked
4823: IF(l_lock_status = '1') THEN
4824: update_pub_lock_status(l_lock_status, p_template_id, 'UIT', p_pub_id);
4825: ELSE ------- updating cz_publication_locks.Lock_status that it is explicitly locked
4826: update_pub_lock_status('0', p_template_id, 'UIT', p_pub_id);

Line 4825: ELSE ------- updating cz_publication_locks.Lock_status that it is explicitly locked

4821: RAISE TEMPLATE_IS_LOCKED;
4822: ELSE -----updating cz_publication_locks.Lock_status that it is Implicitly locked
4823: IF(l_lock_status = '1') THEN
4824: update_pub_lock_status(l_lock_status, p_template_id, 'UIT', p_pub_id);
4825: ELSE ------- updating cz_publication_locks.Lock_status that it is explicitly locked
4826: update_pub_lock_status('0', p_template_id, 'UIT', p_pub_id);
4827: END IF;
4828: END IF;
4829: ELSE

Line 4955: FROM cz_publication_locks

4951: WHERE cz_ui_templates.template_id = p_template_id
4952: AND (cz_ui_templates.checkout_user IS NULL
4953: OR cz_ui_templates.checkout_user = FND_GLOBAL.user_name)
4954: AND EXISTS (SELECT count(*)
4955: FROM cz_publication_locks
4956: WHERE object_type='UIT'
4957: AND deleted_flag = '0'
4958: AND lock_status = '1'
4959: AND object_id= p_template_id

Line 5004: UPDATE cz_publication_locks

5000: END;
5001:
5002: BEGIN
5003:
5004: UPDATE cz_publication_locks
5005: SET deleted_flag = '1',
5006: lock_by = FND_GLOBAL.user_name,
5007: lock_time = sysdate
5008: WHERE publication_id = p_pub_id