APPS.CZ_SECURITY_PVT dependencies on CZ_PS_NODES

Line 872: FROM cz_ps_nodes

868: SELECT checkout_user
869: BULK
870: COLLECT
871: INTO l_checkout_user_tbl
872: FROM cz_ps_nodes
873: WHERE cz_ps_nodes.ps_node_id = l_locked_entities(j)
874: AND cz_ps_nodes.deleted_flag = '0'
875: AND cz_ps_nodes.checkout_user IS NOT NULL;
876:

Line 873: WHERE cz_ps_nodes.ps_node_id = l_locked_entities(j)

869: BULK
870: COLLECT
871: INTO l_checkout_user_tbl
872: FROM cz_ps_nodes
873: WHERE cz_ps_nodes.ps_node_id = l_locked_entities(j)
874: AND cz_ps_nodes.deleted_flag = '0'
875: AND cz_ps_nodes.checkout_user IS NOT NULL;
876:
877: IF (l_checkout_user_tbl.COUNT > 0) THEN

Line 874: AND cz_ps_nodes.deleted_flag = '0'

870: COLLECT
871: INTO l_checkout_user_tbl
872: FROM cz_ps_nodes
873: WHERE cz_ps_nodes.ps_node_id = l_locked_entities(j)
874: AND cz_ps_nodes.deleted_flag = '0'
875: AND cz_ps_nodes.checkout_user IS NOT NULL;
876:
877: IF (l_checkout_user_tbl.COUNT > 0) THEN
878: rec_count := x_locked_entities.COUNT + 1;

Line 875: AND cz_ps_nodes.checkout_user IS NOT NULL;

871: INTO l_checkout_user_tbl
872: FROM cz_ps_nodes
873: WHERE cz_ps_nodes.ps_node_id = l_locked_entities(j)
874: AND cz_ps_nodes.deleted_flag = '0'
875: AND cz_ps_nodes.checkout_user IS NOT NULL;
876:
877: IF (l_checkout_user_tbl.COUNT > 0) THEN
878: rec_count := x_locked_entities.COUNT + 1;
879: x_locked_entities(rec_count) := l_locked_entities(j);

Line 1587: FROM cz_ps_nodes

1583: l_ret_status := 'T';
1584: BEGIN
1585: SELECT checkout_user
1586: INTO l_checkout_user
1587: FROM cz_ps_nodes
1588: WHERE ps_node_id = p_model_id;
1589: EXCEPTION
1590: WHEN NO_DATA_FOUND THEN
1591: l_checkout_user := NULL;

Line 1595: UPDATE cz_ps_nodes

1591: l_checkout_user := NULL;
1592: END;
1593:
1594: IF (l_checkout_user IS NULL) THEN
1595: UPDATE cz_ps_nodes
1596: SET checkout_user = FND_GLOBAL.user_name
1597: WHERE ps_node_id = p_model_id;
1598:
1599: l_event_note := CZ_UTILS.GET_TEXT('CZ_SEC_LOCK_MODEL_STRUCTURE',

Line 1633: FROM cz_ps_nodes

1629: END IF;
1630:
1631: SELECT checkout_user
1632: INTO l_checkout_user
1633: FROM cz_ps_nodes
1634: WHERE cz_ps_nodes.ps_node_id = p_model_id
1635: AND cz_ps_nodes.deleted_flag = '0';
1636:
1637: IF (l_checkout_user IS NULL) THEN

Line 1634: WHERE cz_ps_nodes.ps_node_id = p_model_id

1630:
1631: SELECT checkout_user
1632: INTO l_checkout_user
1633: FROM cz_ps_nodes
1634: WHERE cz_ps_nodes.ps_node_id = p_model_id
1635: AND cz_ps_nodes.deleted_flag = '0';
1636:
1637: IF (l_checkout_user IS NULL) THEN
1638: l_status := '0';

Line 1635: AND cz_ps_nodes.deleted_flag = '0';

1631: SELECT checkout_user
1632: INTO l_checkout_user
1633: FROM cz_ps_nodes
1634: WHERE cz_ps_nodes.ps_node_id = p_model_id
1635: AND cz_ps_nodes.deleted_flag = '0';
1636:
1637: IF (l_checkout_user IS NULL) THEN
1638: l_status := '0';
1639: ELSIF (l_checkout_user = FND_GLOBAL.user_name) THEN

Line 1677: FROM cz_ps_nodes

1673:
1674: BEGIN
1675: SELECT checkout_user
1676: INTO l_checkout_user
1677: FROM cz_ps_nodes
1678: WHERE ps_node_id = p_model_id;
1679: EXCEPTION
1680: WHEN NO_DATA_FOUND THEN
1681: l_checkout_user := NULL;

Line 1685: UPDATE cz_ps_nodes

1681: l_checkout_user := NULL;
1682: END;
1683:
1684: IF ( (l_checkout_user IS NOT NULL) AND (l_checkout_user = FND_GLOBAL.user_name) ) THEN
1685: UPDATE cz_ps_nodes
1686: SET checkout_user = NULL
1687: WHERE ps_node_id = p_model_id;
1688:
1689: l_event_note := CZ_UTILS.GET_TEXT('CZ_SEC_UNLOCK_MODEL_STRUCTURE',