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_UI_TEMPLATES

Line 3056: FROM cz_ui_templates

3052: WHERE cz_devl_projects.devl_project_id = p_obj_id ;
3053: ELSIF (p_obj_type = 'UIT') THEN
3054: SELECT template_name, checkout_user
3055: INTO x_model_name,x_checkout_user
3056: FROM cz_ui_templates
3057: WHERE cz_ui_templates.template_id = p_obj_id ;
3058: END IF;
3059: EXCEPTION
3060: WHEN OTHERS THEN

Line 3057: WHERE cz_ui_templates.template_id = p_obj_id ;

3053: ELSIF (p_obj_type = 'UIT') THEN
3054: SELECT template_name, checkout_user
3055: INTO x_model_name,x_checkout_user
3056: FROM cz_ui_templates
3057: WHERE cz_ui_templates.template_id = p_obj_id ;
3058: END IF;
3059: EXCEPTION
3060: WHEN OTHERS THEN
3061: NULL;

Line 3242: * @param p_template_id number. Template_id of the template from cz_ui_templates table

3238: --------------------
3239: /*#
3240: * This is the public interface for force unlock operations on a UI content template in Oracle Configurator
3241: * @param p_api_version number. Current version of the API is 1.0
3242: * @param p_template_id number. Template_id of the template from cz_ui_templates table
3243: * @param p_init_msg_list FND_API.G_TRUE if the API should initialize the FND stack, FND_API.G_FALSE if not.
3244: * @param x_return_status standard FND status. (ex:FND_API.G_RET_STS_SUCCESS )
3245: * @param x_msg_count number of messages on the stack.
3246: * @param x_msg_data standard FND OUT parameter for message. Messages are written to the FND error stack

Line 3299: UPDATE cz_ui_templates

3295: END IF; /* IF (NOT l_has_priv) */
3296:
3297: -----unlock the template by setting the checkout user
3298: -----and check out time to NULL
3299: UPDATE cz_ui_templates
3300: SET cz_ui_templates.checkout_user = NULL,
3301: cz_ui_templates.checkout_time = NULL
3302: WHERE cz_ui_templates.template_id = p_template_id;
3303:

Line 3300: SET cz_ui_templates.checkout_user = NULL,

3296:
3297: -----unlock the template by setting the checkout user
3298: -----and check out time to NULL
3299: UPDATE cz_ui_templates
3300: SET cz_ui_templates.checkout_user = NULL,
3301: cz_ui_templates.checkout_time = NULL
3302: WHERE cz_ui_templates.template_id = p_template_id;
3303:
3304: IF (SQL%ROWCOUNT = 0) THEN

Line 3301: cz_ui_templates.checkout_time = NULL

3297: -----unlock the template by setting the checkout user
3298: -----and check out time to NULL
3299: UPDATE cz_ui_templates
3300: SET cz_ui_templates.checkout_user = NULL,
3301: cz_ui_templates.checkout_time = NULL
3302: WHERE cz_ui_templates.template_id = p_template_id;
3303:
3304: IF (SQL%ROWCOUNT = 0) THEN
3305: get_checkout_user(p_template_id,'UIT',l_checkout_user,l_template_name);

Line 3302: WHERE cz_ui_templates.template_id = p_template_id;

3298: -----and check out time to NULL
3299: UPDATE cz_ui_templates
3300: SET cz_ui_templates.checkout_user = NULL,
3301: cz_ui_templates.checkout_time = NULL
3302: WHERE cz_ui_templates.template_id = p_template_id;
3303:
3304: IF (SQL%ROWCOUNT = 0) THEN
3305: get_checkout_user(p_template_id,'UIT',l_checkout_user,l_template_name);
3306: RAISE template_UNLOCK_ERR;

Line 3339: * @param p_template_id number. Template_id of the template from cz_ui_templates table

3335: --------------------
3336: /*#
3337: * This is the public interface for lock operations on a UI content template in Oracle Configurator
3338: * @param p_api_version number. Current version of the API is 1.0
3339: * @param p_template_id number. Template_id of the template from cz_ui_templates table
3340: * @param p_commit_flag A value of FND_API.G_TRUE indicates that the a commit be issued at the end of the
3341: * the procedure. A value of FND_API.G_FALSE indicates that no COMMIT is done.
3342: * @param p_init_msg_list FND_API.G_TRUE if the API should initialize the FND stack, FND_API.G_FALSE if not.
3343: * @param x_return_status standard FND status. (ex:FND_API.G_RET_STS_SUCCESS )

Line 3363: l_checkout_user cz_ui_templates.checkout_user%TYPE;

3359: x_msg_count OUT NOCOPY NUMBER,
3360: x_msg_data OUT NOCOPY VARCHAR2)
3361: IS
3362:
3363: l_checkout_user cz_ui_templates.checkout_user%TYPE;
3364: l_template_name cz_ui_templates.template_name%TYPE;
3365: TEMPLATE_IS_LOCKED EXCEPTION;
3366: TEMPLATEID_IS_NULL EXCEPTION;
3367: NO_LOCKING_REQUIRED EXCEPTION;

Line 3364: l_template_name cz_ui_templates.template_name%TYPE;

3360: x_msg_data OUT NOCOPY VARCHAR2)
3361: IS
3362:
3363: l_checkout_user cz_ui_templates.checkout_user%TYPE;
3364: l_template_name cz_ui_templates.template_name%TYPE;
3365: TEMPLATE_IS_LOCKED EXCEPTION;
3366: TEMPLATEID_IS_NULL EXCEPTION;
3367: NO_LOCKING_REQUIRED EXCEPTION;
3368: l_commit_flag VARCHAR2(1);

Line 3405: UPDATE cz_ui_templates

3401: l_commit_flag := DO_NOT_COMMIT;
3402: END IF; /* IF (p_commit_flag IS NULL) */
3403:
3404: -----set the checkout_user and checkout_time
3405: UPDATE cz_ui_templates
3406: SET cz_ui_templates.checkout_user = FND_GLOBAL.user_name,
3407: cz_ui_templates.checkout_time = sysdate
3408: WHERE cz_ui_templates.template_id = p_template_id
3409: AND (cz_ui_templates.checkout_user IS NULL);

Line 3406: SET cz_ui_templates.checkout_user = FND_GLOBAL.user_name,

3402: END IF; /* IF (p_commit_flag IS NULL) */
3403:
3404: -----set the checkout_user and checkout_time
3405: UPDATE cz_ui_templates
3406: SET cz_ui_templates.checkout_user = FND_GLOBAL.user_name,
3407: cz_ui_templates.checkout_time = sysdate
3408: WHERE cz_ui_templates.template_id = p_template_id
3409: AND (cz_ui_templates.checkout_user IS NULL);
3410: IF (SQL%ROWCOUNT = 0) THEN

Line 3407: cz_ui_templates.checkout_time = sysdate

3403:
3404: -----set the checkout_user and checkout_time
3405: UPDATE cz_ui_templates
3406: SET cz_ui_templates.checkout_user = FND_GLOBAL.user_name,
3407: cz_ui_templates.checkout_time = sysdate
3408: WHERE cz_ui_templates.template_id = p_template_id
3409: AND (cz_ui_templates.checkout_user IS NULL);
3410: IF (SQL%ROWCOUNT = 0) THEN
3411: get_checkout_user(p_template_id,'UIT',l_checkout_user,l_template_name);

Line 3408: WHERE cz_ui_templates.template_id = p_template_id

3404: -----set the checkout_user and checkout_time
3405: UPDATE cz_ui_templates
3406: SET cz_ui_templates.checkout_user = FND_GLOBAL.user_name,
3407: cz_ui_templates.checkout_time = sysdate
3408: WHERE cz_ui_templates.template_id = p_template_id
3409: AND (cz_ui_templates.checkout_user IS NULL);
3410: IF (SQL%ROWCOUNT = 0) THEN
3411: get_checkout_user(p_template_id,'UIT',l_checkout_user,l_template_name);
3412: IF(l_checkout_user<>FND_GLOBAL.user_name AND l_checkout_user is not null)

Line 3409: AND (cz_ui_templates.checkout_user IS NULL);

3405: UPDATE cz_ui_templates
3406: SET cz_ui_templates.checkout_user = FND_GLOBAL.user_name,
3407: cz_ui_templates.checkout_time = sysdate
3408: WHERE cz_ui_templates.template_id = p_template_id
3409: AND (cz_ui_templates.checkout_user IS NULL);
3410: IF (SQL%ROWCOUNT = 0) THEN
3411: get_checkout_user(p_template_id,'UIT',l_checkout_user,l_template_name);
3412: IF(l_checkout_user<>FND_GLOBAL.user_name AND l_checkout_user is not null)
3413: THEN

Line 3471: l_checkout_user cz_ui_templates.checkout_user%TYPE;

3467: IS
3468:
3469: NO_TEMPLATES_IDS EXCEPTION;
3470: l_count NUMBER;
3471: l_checkout_user cz_ui_templates.checkout_user%TYPE;
3472: l_return_status VARCHAR2(1);
3473:
3474: BEGIN
3475:

Line 3494: FROM cz_ui_templates

3490: l_checkout_user := NULL;
3491: BEGIN
3492: SELECT checkout_user
3493: INTO l_checkout_user
3494: FROM cz_ui_templates
3495: WHERE template_id = p_templates_to_lock(i)
3496: AND checkout_user = FND_GLOBAL.user_name;
3497: EXCEPTION
3498: WHEN NO_DATA_FOUND THEN

Line 3534: * @param p_template_id number. Template_id of the template from cz_ui_templates table

3530: ------------------------------
3531: ---------->>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
3532: /*#
3533: * This is the public interface for unlock operations on a UI content template in Oracle Configurator
3534: * @param p_template_id number. Template_id of the template from cz_ui_templates table
3535: * @param p_init_msg_list FND_API.G_TRUE if the API should initialize the FND stack, FND_API.G_FALSE if not.
3536: * @param x_return_status standard FND status. (ex:FND_API.G_RET_STS_SUCCESS )
3537: * @param x_msg_count number of messages on the stack.
3538: * @param x_msg_data standard FND OUT parameter for message. Messages are written to the FND error stack

Line 3559: l_checkout_user cz_ui_templates.checkout_user%TYPE;

3555: TEMPLATEID_IS_NULL EXCEPTION;
3556: TEMPLATE_UNLOCK_ERR EXCEPTION;
3557: NO_LOCKING_REQUIRED EXCEPTION;
3558: l_count NUMBER := 0;
3559: l_checkout_user cz_ui_templates.checkout_user%TYPE;
3560: l_template_name cz_ui_templates.template_name%TYPE;
3561: l_commit_flag VARCHAR2(1);
3562: l_lock_profile VARCHAR2(3);
3563:

Line 3560: l_template_name cz_ui_templates.template_name%TYPE;

3556: TEMPLATE_UNLOCK_ERR EXCEPTION;
3557: NO_LOCKING_REQUIRED EXCEPTION;
3558: l_count NUMBER := 0;
3559: l_checkout_user cz_ui_templates.checkout_user%TYPE;
3560: l_template_name cz_ui_templates.template_name%TYPE;
3561: l_commit_flag VARCHAR2(1);
3562: l_lock_profile VARCHAR2(3);
3563:
3564: BEGIN

Line 3587: UPDATE cz_ui_templates

3583: RAISE NO_LOCKING_REQUIRED;
3584: END IF; /* IF (UPPER(NVL(l_lock_profile,'Y')) IN ('N','NO')) */
3585:
3586: -----set the checkout_user and checkout_time
3587: UPDATE cz_ui_templates
3588: SET cz_ui_templates.checkout_user = NULL,
3589: cz_ui_templates.checkout_time = NULL
3590: WHERE cz_ui_templates.template_id = p_template_id
3591: AND (cz_ui_templates.checkout_user IS NULL

Line 3588: SET cz_ui_templates.checkout_user = NULL,

3584: END IF; /* IF (UPPER(NVL(l_lock_profile,'Y')) IN ('N','NO')) */
3585:
3586: -----set the checkout_user and checkout_time
3587: UPDATE cz_ui_templates
3588: SET cz_ui_templates.checkout_user = NULL,
3589: cz_ui_templates.checkout_time = NULL
3590: WHERE cz_ui_templates.template_id = p_template_id
3591: AND (cz_ui_templates.checkout_user IS NULL
3592: OR cz_ui_templates.checkout_user = FND_GLOBAL.user_name);

Line 3589: cz_ui_templates.checkout_time = NULL

3585:
3586: -----set the checkout_user and checkout_time
3587: UPDATE cz_ui_templates
3588: SET cz_ui_templates.checkout_user = NULL,
3589: cz_ui_templates.checkout_time = NULL
3590: WHERE cz_ui_templates.template_id = p_template_id
3591: AND (cz_ui_templates.checkout_user IS NULL
3592: OR cz_ui_templates.checkout_user = FND_GLOBAL.user_name);
3593: IF (SQL%ROWCOUNT = 0) THEN

Line 3590: WHERE cz_ui_templates.template_id = p_template_id

3586: -----set the checkout_user and checkout_time
3587: UPDATE cz_ui_templates
3588: SET cz_ui_templates.checkout_user = NULL,
3589: cz_ui_templates.checkout_time = NULL
3590: WHERE cz_ui_templates.template_id = p_template_id
3591: AND (cz_ui_templates.checkout_user IS NULL
3592: OR cz_ui_templates.checkout_user = FND_GLOBAL.user_name);
3593: IF (SQL%ROWCOUNT = 0) THEN
3594: get_checkout_user(p_template_id,'UIT',l_checkout_user,l_template_name);

Line 3591: AND (cz_ui_templates.checkout_user IS NULL

3587: UPDATE cz_ui_templates
3588: SET cz_ui_templates.checkout_user = NULL,
3589: cz_ui_templates.checkout_time = NULL
3590: WHERE cz_ui_templates.template_id = p_template_id
3591: AND (cz_ui_templates.checkout_user IS NULL
3592: OR cz_ui_templates.checkout_user = FND_GLOBAL.user_name);
3593: IF (SQL%ROWCOUNT = 0) THEN
3594: get_checkout_user(p_template_id,'UIT',l_checkout_user,l_template_name);
3595: RAISE TEMPLATE_UNLOCK_ERR;

Line 3592: OR cz_ui_templates.checkout_user = FND_GLOBAL.user_name);

3588: SET cz_ui_templates.checkout_user = NULL,
3589: cz_ui_templates.checkout_time = NULL
3590: WHERE cz_ui_templates.template_id = p_template_id
3591: AND (cz_ui_templates.checkout_user IS NULL
3592: OR cz_ui_templates.checkout_user = FND_GLOBAL.user_name);
3593: IF (SQL%ROWCOUNT = 0) THEN
3594: get_checkout_user(p_template_id,'UIT',l_checkout_user,l_template_name);
3595: RAISE TEMPLATE_UNLOCK_ERR;
3596: END IF; /* IF (SQL%ROWCOUNT = 0) */

Line 4750: l_checkout_user cz_ui_templates.checkout_user%TYPE;

4746: x_return_status OUT NOCOPY VARCHAR2,
4747: x_msg_count OUT NOCOPY NUMBER,
4748: x_msg_data OUT NOCOPY VARCHAR2)
4749: IS
4750: l_checkout_user cz_ui_templates.checkout_user%TYPE;
4751: l_template_name cz_ui_templates.template_name%TYPE;
4752: TEMPLATE_IS_LOCKED EXCEPTION;
4753: TEMPLATEID_IS_NULL EXCEPTION;
4754: NO_LOCKING_REQUIRED EXCEPTION;

Line 4751: l_template_name cz_ui_templates.template_name%TYPE;

4747: x_msg_count OUT NOCOPY NUMBER,
4748: x_msg_data OUT NOCOPY VARCHAR2)
4749: IS
4750: l_checkout_user cz_ui_templates.checkout_user%TYPE;
4751: l_template_name cz_ui_templates.template_name%TYPE;
4752: TEMPLATE_IS_LOCKED EXCEPTION;
4753: TEMPLATEID_IS_NULL EXCEPTION;
4754: NO_LOCKING_REQUIRED EXCEPTION;
4755: NO_TEMPLATES_IDS EXCEPTION;

Line 4806: UPDATE cz_ui_templates

4802: get_prev_lock_status(p_template_id, 'UIT', p_pub_id, l_lock_status);
4803:
4804:
4805: -----set the checkout_user and checkout_time
4806: UPDATE cz_ui_templates
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)

Line 4807: SET cz_ui_templates.checkout_user = FND_GLOBAL.user_name,

4803:
4804:
4805: -----set the checkout_user and checkout_time
4806: UPDATE cz_ui_templates
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

Line 4808: cz_ui_templates.checkout_time = sysdate

4804:
4805: -----set the checkout_user and checkout_time
4806: UPDATE cz_ui_templates
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'

Line 4809: WHERE cz_ui_templates.template_id = p_template_id

4805: -----set the checkout_user and checkout_time
4806: UPDATE cz_ui_templates
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'

Line 4810: AND (cz_ui_templates.checkout_user IS NULL)

4806: UPDATE cz_ui_templates
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

Line 4908: l_checkout_user cz_ui_templates.checkout_user%TYPE;

4904: TEMPLATE_UNLOCK_ERR EXCEPTION;
4905: NO_LOCKING_REQUIRED EXCEPTION;
4906: p_template_id NUMBER;
4907: l_count NUMBER := 0;
4908: l_checkout_user cz_ui_templates.checkout_user%TYPE;
4909: l_template_name cz_ui_templates.template_name%TYPE;
4910: l_lock_profile VARCHAR2(3);
4911:
4912: BEGIN

Line 4909: l_template_name cz_ui_templates.template_name%TYPE;

4905: NO_LOCKING_REQUIRED EXCEPTION;
4906: p_template_id NUMBER;
4907: l_count NUMBER := 0;
4908: l_checkout_user cz_ui_templates.checkout_user%TYPE;
4909: l_template_name cz_ui_templates.template_name%TYPE;
4910: l_lock_profile VARCHAR2(3);
4911:
4912: BEGIN
4913: ----initialize FND stack

Line 4948: UPDATE cz_ui_templates

4944: RAISE TEMPLATEID_IS_NULL;
4945: END IF; /* IF (p_template_id IS NULL) */
4946:
4947: -----set the checkout_user and checkout_time
4948: UPDATE cz_ui_templates
4949: SET cz_ui_templates.checkout_user = NULL,
4950: cz_ui_templates.checkout_time = NULL
4951: WHERE cz_ui_templates.template_id = p_template_id
4952: AND (cz_ui_templates.checkout_user IS NULL

Line 4949: SET cz_ui_templates.checkout_user = NULL,

4945: END IF; /* IF (p_template_id IS NULL) */
4946:
4947: -----set the checkout_user and checkout_time
4948: UPDATE cz_ui_templates
4949: SET cz_ui_templates.checkout_user = NULL,
4950: cz_ui_templates.checkout_time = NULL
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)

Line 4950: cz_ui_templates.checkout_time = NULL

4946:
4947: -----set the checkout_user and checkout_time
4948: UPDATE cz_ui_templates
4949: SET cz_ui_templates.checkout_user = NULL,
4950: cz_ui_templates.checkout_time = NULL
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(*)

Line 4951: WHERE cz_ui_templates.template_id = p_template_id

4947: -----set the checkout_user and checkout_time
4948: UPDATE cz_ui_templates
4949: SET cz_ui_templates.checkout_user = NULL,
4950: cz_ui_templates.checkout_time = NULL
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

Line 4952: AND (cz_ui_templates.checkout_user IS NULL

4948: UPDATE cz_ui_templates
4949: SET cz_ui_templates.checkout_user = NULL,
4950: cz_ui_templates.checkout_time = NULL
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'

Line 4953: OR cz_ui_templates.checkout_user = FND_GLOBAL.user_name)

4949: SET cz_ui_templates.checkout_user = NULL,
4950: cz_ui_templates.checkout_time = NULL
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'